Guided project · 5 steps Cellwise Plus
Owner-operator cost per mile in Excel
Turn a truck's monthly bills, fuel and miles into a cost per mile and the minimum rate per loaded mile worth taking.
Starting data
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Fixed cost | Per month | Running cost | Value | |
| 2 | Truck payment | 2350 | Diesel per gallon | 3.85 | |
| 3 | Trailer payment | 650 | MPG | 6.5 | |
| 4 | Insurance | 1180 | Maintenance and tires per mile | 0.19 | |
| 5 | Permits and plates | 160 | Fuel per mile | ||
| 6 | ELD and load board | 120 | Total cost per mile | ||
| 7 | Phone and office | 140 | Miles per month | 9800 | |
| 8 | Total fixed | Deadhead share | 0.12 | ||
| 9 | Fixed per mile | Target profit per mile | 0.45 | ||
| 10 | Minimum rate per loaded mile |
Build it step by step
Step 1
Add up the monthly fixed costs in B8.
Step 2
Spread the fixed costs over the miles you run: B8 divided by the miles per month in E7. Write it in B9.
Step 3
Fuel per mile is the diesel price divided by MPG. Write it in E5.
Step 4
Total cost per mile in E6: fixed per mile, plus maintenance and tires, plus fuel.
Step 5
Only loaded miles get paid. In E10, add the target profit to the cost per mile and divide by the loaded share (1 minus the deadhead share), rounded up to the cent with ROUNDUP.