General Rating Formula for Va Claims - Excel
General Rating Formula for Va Claims document sample
Shared by: dzt19660
2010 Annual Benchmarking Survey Please enter answers only in the red highlighted areas The National Private Truck Council is conducting its 2010 Benchmarking Survey, which reflects performance achieved in the 2009 calendar year. This survey is designed for the benefit of our members and the private fleet community. The purpose is to help you benchmark your operation to other best-in-class performers, thereby validating your performance and identifying areas of opportunity. Please enter information in the boxes provided and hit the submit button to e-mail it to NPTC by FRIDAY, MARCH 12 to allow ample time to tabulate the results and prepare a summary report. Since many of you operate distinct private fleet operations (i.e. long-haul, DSD, interplant, etc.), and in order to make the survey more meaningful, please consider filling out separate surveys for each distinct operation. This will help ensure an apples-to-apples comparison in addition to providing you with a more valuable report. We understand the essentiality of keeping your responses completely confidential. We are asking that you return your responses directly via e-mail so that Tom can call you back with any questions. Your company's responses will not be reported to other companies nor shared with anyone. They will simply be aggregated into a broad data set for analysis of trends and industry standards. If you would prefer to keep your information totally confidential, please print out the survey and return it via fax to (815)642-0317 or regular mail to NPTC, Attn: Benchmarking Survey, 950 N. Glebe Road, Suite 530, Arlington, VA 22203-4183. A report of the benchmarking report will be presented at the Annual Conference, April 18-20, 2010 in Cincinnati If you have any questions while answering the survey, please feel free to contact Tom Moore, CTP directly at email@example.com or (703)838-8898. General Background 1 What is the primary reason why your company operates a private fleet? 2 What are the principal commodities or products your private fleet hauls for your company? 3 What are the top issues you face in your operation? 1 2 3 4 OPTIONAL: What was your most significant achievement in 2009? Equipment and Maintenance Short Term Trade Cycle Trade Cycle Annual Miles 5 EquipmentTotals Owned Leased Rental (Years) (Miles) Per Unit Number of Heavy Duty Power Units (Class 8) Number of Medium Duty (Class 5-7) Number of Light Duty (Class 3-4) Number of Van Trailers Number of Refrigerated Trailers Number of Flatbed Trailers Number of Bulk Trailers Number of Other Trailers 6 Total annual mileage 0 (Include all miles for the fleet for which you are completing survey) 7 Percent of empty mileage 8 Percentage of maintenance spend that is outsourced Percentage of maintenance spend that is in-house Fuel 9 Gallons of fuel purchased in 2009 (excluding reefers) 10 Annual cost of all fuel purchased in 2009 (excluding reefers) 11 Fuel taxes paid in 2009 12 Please answer all that apply to your operation (use only power unit fuel for the calculation -- no reefer or PTO fuel) What is your average MPG for Heavy Duty? (Class 8) Miles per Gallon What is your average MPG for Medium Duty? (Class 5-7) Miles per Gallon What is your average MPG for Light Duty? (Class 3-4 ) Miles per Gallon 13 How do you manage your fuel spend? (check all that apply) Over-the-road provider discount (wholesale cost plus) Over-the-road provider discount (retail cost minus) Fuel hedging Fuel routing technology Other: Personnel 14 Please list the number of drivers for each of the following: Full-time company Owner-operators Full-time leased Total Drivers 0 If seasonal, # Annual Part time or casual/leased of months Average 15 What percentage of your total miles are run by teams? 16 How many non-driving personnel (full-time equivalents) do you have in your fleet? Supervisors/Managers Dispatchers and/or fleet managers Safety and compliance Maintenance and equipment Accounting, billing, payroll Backhaul, brokerage, etc. Administrative/ other personnel Tax and registration TOTAL 0 17 What are the minimum qualifacations to drive for your fleet? Age Years Experience Other: 18 What is the total number of drivers lost in 2009 for any reason? Annual turnover rate #DIV/0! 19 What percentage of your fleet is slip-seated? 20 What is the average full-time driver’s W2 gross wages? Starting After 1 Year After 3 Years Maximum 21 How are your drivers paid? (check all that apply) By the hour Activity or performance based By the mile Salary 22 Please check all components available to a driver in you company's benefit package: Medical 401 K Pension Plan Paid Vacation Paid Sick Days Dental Paid Holidays Life Insurance Family Leave Short Term Disability Long Term Disability Other: 23 Do your drivers receive incentive pay? Yes No Don't Know If yes, what is the average potential percentage of base pay achieved from it? Please check all the components of this incentive: Safety Productivity On-Time % Compliance MPG Company Goals Attendance Appearance Miles and Stops Idle Time Other: 24 How many hours per week do your drivers spend doing the following: Driving Loading product What % of total deliveries do drivers load? Unloading product What % of total deliveries do drivers unload? TOTAL 0 25 Does your company havea driver "wellness" program? Yes No Don't Know Sleep Management Smoking Cessation Yes Don't Know Please check all the components of this incentive: Sleep Management Smoking Cessation Exercise Programs Nutritional Counseling Weight Management Other: 26 What is the average age of your driver workforce? 0 Operations 27 The number of total terminal, distribution, maintenance and/or physical locations: What is the number of vehicles per location? Minimum Maximum Average 28 What percentage of your fleet's loads weigh out? Cube out? 29 If your private fleet does not haul all your company freight, how do you decide which shipments your private fleet will move? (check all that apply) Commodity type Length of haul Private fleet vs. external alternative Specific traffic lanes (lanes you do not want your private fleet in) Customer size or importance Don't know Other: 30 Please estimate your company's OUTBOUND freight (finished goods or work-in-process delivered to a customer location) as accurately as possible: Avg length of Percentage haul total Avg number Avg distance of all freight (one-way) of stops to 1st drop Private fleet truckload to customer Private fleet truckload to distribution centers Interplant (warehouse to warehouse) For-hire (truckload or LTL) Third party or dedicated to distribution centers Third party or dedicated to customer Third party or dedicated interplant Rail or intermodal Other explanation: Other (please explain) Total (must equal 100%) 31 Please estimate your company's INBOUND freight (raw materials and packaging supplies) as accurately as possible: Percentage Avg length of Avg number Avg distance of all freight haul total of stops to 1st drop Private fleet truckload (one-way) For-hire (truckload or LTL) Third party or dedicated Rail or intermodal Other explanation: Other (please explain) Total (must equal 100%) 32 Over the next five years, my fleet will: stay the same grow in size by percent and/or power units shrink in size by percent and/or power units handle more of my company's freight by percent and/or power units handle less of my compan's freight by percent and/or power units 33 For comparison purposes, do you benchmark typical for-hire cost-per-mile in lane bands with simlar length of haul? Yes No Don't Know 34 Is your private fleet used as leverage against for-hire carriers? Yes No Don't Know 35 Do you track expenses as a percentage of sales? Yes No If yes, what is your transportation as a percentage of sales? What is your warehousing as a percentage of sales? 36 What is the operating cost-per-mile of your fleet? (please ensure you complete number 6) Cost Cost Per Mile Tractors #DIV/0! per/mile (annual lease with sales and property tax OR principle and interest) Licenses, Permits and Registration Cost #DIV/0! per/mile Tractor Maintenance #DIV/0! per/mile (all fixed and variable cost paid annually to maintain equipment, whether in-house or outsourced) Trailers #DIV/0! per/mile (annual lease or operating payments plus all registration and license fees) Trailer Maintenance #DIV/0! per/mile (all fixed and variable cost paid annually to maintain equipment) Fuel #DIV/0! per/mile (total annual fuel spend: if needed use this formula: total miles/fleet mpg = total gallons x avg price per gallon for the year = avg total spend) Driver payroll #DIV/0! per/mile (including vacation, benefits, insurance, uniforms, etc.) Claims/Insurance (liability, cargo, and worker's comp) #DIV/0! per/mile Administrative overhead #DIV/0! per/mile (staff salaries, utilities, office equipment, and corporate allocations for HR, IT, etc.) Other #DIV/0! per/mile TOTAL $ - #DIV/0! per/mile 37 Does your fleet collect a fuel surcharge? Yes No Don't know If yes, how much do you collect? 38 Does your private fleet use on-board GPS enabled computers? Yes No Don't know Driving performance Long Idle time MPG Payroll E-logs Fuel tax Safety If you collect operating data, please check all that apply: Out of route miles Non-driving performance (deliveries) On-Time % Other: 39 Does your private fleet use any computer programs and/or software? Yes No Don't know If yes, please check all that apply: Dispatch Payroll Fuel tax Out of route miles Safety On-Time % Planned vs. actual Routing Maintenance Other: 40 Does your fleet have for-hire authority and solicit non-company backhaul freight? Yes No Don't know If you fleet has for-hire authority, which takes priority? Contract freight Company freight Equal priority 41 Does your private fleet have its own transportation sales force? Yes No Don't know 42 Does your fleet use broker or internet sites to find backahuls? Yes No Don't know 43 Does your private fleet also act as a broker or transportation department to move loads it cannot or does not want to move with the private fleet? Yes No Don't know 44 What measures of customer service do you track? Early delivery Late delivery Customer comments OS & D Stop sequence Other: 45 If on-time delivery is tracked, please check the standard to which your fleet is measured: + / - 10 min + / - 15 min + / - 30 min + / - 45 min + / - 60 min Other: Safety 46 What is your DOT reportable crash rate? (total DOT reportable crashes multiplied by one million and divided by your total mileage) Number of D.O.T. Reportable Accidents Rating 47 What is your preventable crash rate? (total crashes – resulting from errors, deficient conditions, work processes, or other problems that could have been prevented by one or more employee/management action(s), program(s), or practice(s), i.e., training, communication, coaching, equipment design, installation, maintenance, inspection, etc. – multiplied by one million and divided by your total mileage) Number of preventable accidents Rating 48 What is your non-preventable crash rate? (total crashes in which no errors, deficient conditions or work processes could be identified that contributed to the occurrence multiplied by one million and divided by your total mileage) Total number of accidents that apply to the above. Rating Which of the following safety devices does your company employ? adaptive cruise control collision warning devices lane departure warning devices roll stability control devices 49 What is your Lost Workday Case Rate (LWC)? (OSHA 300 Log for 2009. Total LWCs [RIIs involving days away from work], divided by hours worked by all your employees, multiplied by 200,000 hours) Total hours worked by all employees Total number of acidents that apply to above Rating What is the total number of days lost? 50 What is your Restricted Injury/Illness Rate (RII)? (OSHA 300 Log for 2009. Total RII's divided by hours worked by all your employees, multiplied by 200,000 hours) Total number of accidents that apply to the above. Rating 51 What is your Medical Treatment Case Rate (MTC)? 52 What is your Recordable Workday Case Rate? 53 What is your First Aid Case Rate (FAC)? 54 What is your workers’ compensation cost? (three year average= total costs for 2006-2009 divided by 3 ) Total workers compensation cost 2006-2008 3 yr Avg 55 Does your private fleet have a light duty return to work (RTW) program? Yes No Don't know If Yes, What activities are involved? ( please explain ) 56 Does your fleet have a policy against texting and/or cell phone use when driving? Yes No Don't know Graphics 57 Does your fleet have a fleet graphics program? Yes No Don't know If so, which department(s) funds the investment? How would you rate the effectiveness of your graphics program as a component of fleet value? Environmental 58 Is your fleet a member of Smart Way? Yes No Don't know 59 Does your company have any green/environmental sustainability initiatives? Yes No Don't know If yes, what are the top "green iniatives your fleet has been charged to accomplish? Trailer skirts Biodiesel Anti-idling devices Hybrid vehicles 60 MPH limit on all power units Increased load density Nitrogen refridgeration Wide-bias tires Fuel economy improvement Other: Additional Information 60 What other questions/information would you like to see in future benchmarking studies? 61 Would you like an advance copy of the summary report sent to you? Yes No Email: 62 Would you like someone from NPTC to contact you pesonally? Yes No PLEASE RETURN YOUR COMPLETED SURVEY BY FRIDAY MARCH 12, 2010. Email survey to Tom Moore, CTP, at firstname.lastname@example.org. Or, if you would prefer, fax it to (815)642-0317.