Inputs
Assumptions
Analysis
Summary
Note: Enter data into orange cells.
Items (your annual figures)
Company Name   
Units   
Total Miles    mi
Deadhead/Empty Miles Ratio    %
Average Haul    mi
Variable Cost Mile $
Fixed Cost Mile $
Total Revenue $
Dispatcher salary $
Office clerk salary $
Recruiting cost per driver $
Communications charges
Cell phone charges per driver $
Number of drivers   
Number of dispatchers   
Number of office clerks   
Number of all other employees   
Automatic Calculations
Miles/Unit    mi
Empty Miles    mi
Revenue Miles    mi
Total Cost Mile $
Revenue/Mile $
Revenue/Loaded Mile $
Total Annual Variable Expense $
Total Costs $
Operating Ratio   
Total Number of trips   
Trips per tractor   
Total Employees   
Driver to employee ratio   
Driver to dispatcher ratio   
       
Assumptions
Assumption
Factor
Percent increase in revenue miles through better resource utilization %
 
Percent reduction in empty miles through raised awareness and driver management %
 

Percent increase in driver to dispatcher ratio,
by increasing dispatcher productivity through simplifying working environment you will be in a position to optimize resources and potentially redeploy them to other productive tasks.

 %
 

Percent increase in driver to office clerk ratio,
by increasing office clerk productivity through eliminating duplicate data entry, (back office integration opportunities), eliminating lost orders and simplifying customer billing you will be in a position to reduce the need for clerical staff.

 %
 

Percent increase in driver retention,
because of improved communication, timely re-load and delivery information as well as a user friendly operating enviroment.

 %
 
Percent decrease in communications charges,
with 2-way text messaging included with LoadTrak, drivers are able reduce their reliance on cell phones.		 %
 
Monthly costs for LoadTrak Service
LoadTrak access fee per truck       $
Sample 5yr equipment lease ($3,900 per truck @9%)     + $
Monthly charge per truck       $
Analysis
Analysis   Figures   Result  
1. Increased revenue mileage     $    Increase in revenue
Total Revenue Miles      mi  
Percent increase in revenue miles x    %  
Contribution revenue miles      mi  
Revenue per loaded mile x $    
Contribution revenue   $    
2. Reduce empty miles     $    Empty mile savings
Empty miles      mi  
Percent reduction in empty miles x    %  
Empty miles saved      mi  
Cost per mile x $    
Empty mile savings   $    
3. Staffing ratios     $    Dispatch and clerical savings
Driver to dispatcher ratio         
Percent improvement in driver to dispatcher ratio x    %  
Driver to dispatcher ratio using LoadTrak         
Reposition (avoid hiring) dispatcher(s)         
Annual dispatcher cost x $    
Dispatcher staffing savings   $    
Driver to office clerk ratio         
Percent improvement in driver to office clerk ratio x    %  
Driver to office clerk ratio when using LoadTrak         
Reposition (avoid hiring) clerk(s)         
Annual office clerk cost x $    
Office clerk staffing savings   $    
          
Total dispatch/clerical savings   $    
4. Driver Retention     $ Driver retention savings
Number of drivers         
Driver retention improvement x    %  
Fewer new drivers required when using LoadTrak         
Cost of recruiting a driver x $    
Driver retention savings         
5. Communication charges (per driver)     $    Communications savings
Annual communications charge   $    
Decrease in communications charges x    %  
Communications savings per year   $    
ROI Summary
Analysis item Per Fleet (Year) Per Tractor (Year) Per Month (Fleet)
1. Increased revenue mileage $ $ $
       
2. Reduce empty miles $ $ $
       
3. Dispatch/clerical savings $ $ $
       
4. Driver retention $ $ $
       
5. Communications savings $ $ $
       
Total Benefits $ $ $
       
Total Cost $ $ $
       
Return on Investment $ $ $
ROI %        %        %        %