Cost-Per-Mile/Profit-Per-Mile Spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Cost-Per-Mile/Profit-Per-Mile Calculator
3
4
Click Here To Make a Copy
5
6
How to use this worksheet
7
Input numbers into the green boxes for your trucking company.
8
Do not edit the yellow boxes. These boxes update automatically.
9
10
Fleet Operations
11
Loaded miles run this year100,000
12
Deadhead miles run his year20,000
13
Total miles120,000
14
15
Fuel
16
Fuel gallons purchased this year19,500
17
Miles per gallon6
18
Average price per gallon$2.50
19
20
Annual Fleet Income
21
Gross earnings$200,000
22
Interest earnings (escrow funds, investments, cash, etc.)
23
Other Income
24
Total Annual Income$200,000
25
26
Annual Fixed Costs
27
Truck payments16,000
28
Trailer payments
29
Liability insurance premiums
30
Bobtail/deadhead insurance premiums
31
Cargo insurance premiums
32
Health insurance premiums$2,500
33
Collision/wokers comp insurance premiums$3,000
34
License plates$1,500
35
Permits$500
36
Parking expenses
37
Office lease payments$12,000
38
Total Fixed Costs for the Year$35,500
39
40
Annual Variable Costs
41
Fuel$48,750
42
Meals/lodging$6,500
43
Telephone
44
Satellite
45
Tolls$1,500
46
Loading/unloading fees
47
Tires
48
Maintenance$4,500
49
Repairs$6,000
50
Factoring fees
51
Broker fees
52
Drivers' salaries/wages
53
Payroll taxes
54
Professional services
55
Taxes (road, fuel, property)
56
Advance fees
57
Uncollected receivables
58
Collection fees
59
Miscellaneous expenses$1,000
60
Total variable expenses for the year68,250
61
62
Annual Summary
63
Total miles run120,000
64
Total annual income$200,000
65
Total fixed costs$35,500
66
Total variable costs$68,250
67
Total profit/loss$96,250
68
Gross income per mile$1.67
69
Fixed costs per mile$0.30
70
Variable costs per mile$0.57
71
Total costs per mile$0.86
72
73
Total Profit or Loss per Mile$0.80
74
75
Cost Per Mile$0.86
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu