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.
Put this calculator on your website
Run a trucking blog, a dispatch service, a CDL school or an association site? You can embed the live Rate Per Mile Quick Check on any page, free. Copy the code below and paste it into your page's HTML. We only ask that you keep the credit line under it.
Click the box to select the whole code. Questions, or want a version sized for your layout? Email [email protected].