Free: the Rate Per Mile Quick Check
One sheet. Type the loaded miles, the deadhead, the rate, fuel price, MPG and your cost per mile — get revenue per all miles, fuel cost, profit, your breakeven rate per loaded mile, and a ladder showing what the same load earns at other rates. Excel 2016+ and Google Sheets.
| The load — type here | ||
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| What it actually pays | ||
| 7 | Total miles | 985 |
| 8 | Revenue for the load | $2,173.75 |
| 9 | Revenue per all miles | $2.21 |
| 10 | Fuel cost | $583.42 |
| 11 | Other cost (cost per mile × all miles) | $1,379.00 |
| 12 | Total cost | $1,962.42 |
| 13 | Profit on this load | $211.33 |
| 14 | Profit per mile (all miles) | $0.21 |
| 15 | Breakeven rate per loaded mile | $2.12 |
| ABOVE BREAKEVEN — clears $211.33 on this load | ||
What's on the sheet
- Six orange input cells: loaded miles, deadhead miles, rate per loaded mile, fuel price, MPG, your cost per mile excluding fuel
- Revenue for the load and revenue per all miles
- Fuel gallons and fuel cost, other cost, total cost
- Profit on the load, profit per mile, and the breakeven rate per loaded mile
- A verdict that turns red the moment the rate drops below breakeven
- A rate ladder: the same load at six rates, 10 cents apart
What happens after you sign up
The download link arrives by email within a minute. Over the next ten days you'll get five short emails: how to use the sheet, where to get your cost-per-mile number, a worked cost-per-mile lesson, and a look at the two paid calculators that take this further. After that, an occasional note when a tool is updated or a new one is released. Unsubscribe any time; keep the file.
Free for personal and business use. Not for resale. This is a calculation tool, not tax or legal advice.