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.

Rate per mile quick check live — change any orange cell
The load — type here
1
2
3
4
5
6
What it actually pays
7Total miles985
8Revenue for the load$2,173.75
9Revenue per all miles$2.21
10Fuel cost$583.42
11Other cost (cost per mile × all miles)$1,379.00
12Total cost$1,962.42
13Profit on this load$211.33
14Profit per mile (all miles)$0.21
15Breakeven rate per loaded mile$2.12
ABOVE BREAKEVEN — clears $211.33 on this load
This is the free one-sheet, running in your browser. Get the Excel / Google Sheets version — or see the full Cost Per Mile Calculator.
The free Rate Per Mile Quick Check spreadsheet

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].