Free Excel template · Excel for trucking
Free trucking cost per mile calculator template
For owner-operators and small fleet owners who want to know their real cost per mile and the lowest rate worth taking. Enter your monthly fixed costs, fuel price, MPG, per-mile running costs, miles and deadhead share, and the template gives your cost per mile, your break-even and minimum rate per loaded mile, and the revenue you need each month. Type in any load offer and it shows the rate per loaded and total mile, the profit and whether it meets your target.
Preview and try it
This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Trucking cost per mile calculator | ||||
| 2 | Month | Nov 1, 2026 | |||
| 3 | |||||
| 4 | Fixed costs (per month) | Amount | Running costs and plan | Amount | |
| 5 | Truck payment | $2,350.00 | Diesel price per gallon | $3.85 | |
| 6 | Trailer payment | $650.00 | Average MPG | 6.5 | |
| 7 | Truck and cargo insurance | $1,180.00 | Maintenance and repairs per mile | $0.15 | |
| 8 | Plates, permits, registration (monthly share) | $160.00 | Tires per mile | $0.04 | |
| 9 | ELD, load board, dispatch software | $120.00 | Driver pay per mile (0 if you take profit as pay) | $0.00 | |
| 10 | Phone, accounting, office | $140.00 | Other per mile (tolls, lumpers, washes) | $0.03 | |
| 11 | Parking and other | $100.00 | |||
| 12 | Total fixed costs | $4,700.00 | Miles per month (all miles) | 9,800 | |
| 13 | Deadhead share of miles | 12% | |||
| 14 | Target profit per mile | $0.45 | |||
| 15 | |||||
| 16 | Results | Per mile | Check a load | Amount | |
| 17 | Fixed cost per mile | $0.48 | Loaded miles | 540 | |
| 18 | Fuel cost per mile | $0.59 | Deadhead miles to pick up | 85 | |
| 19 | Other running cost per mile | $0.22 | Offered pay | $1,050.00 | |
| 20 | Total cost per mile (all miles) | $1.29 | Tolls and lumper fees | $0.00 | |
| 21 | Break-even rate per loaded mile | $1.47 | Rate per loaded mile | $1.94 | |
| 22 | Minimum rate per loaded mile (with target profit) | $1.98 | Rate per total mile | $1.68 | |
| 23 | Revenue needed per month to break even | $12,660.62 | Cost to run the load | $807.44 | |
| 24 | Revenue needed per month for target profit | $17,070.62 | Profit on the load | $242.56 | |
| 25 | Pay needed for target profit | $1,089.00 | |||
| 26 | Verdict | Covers costs, under target |
How the formulas work
Fixed cost per mile
Your monthly fixed costs divided by the miles you run in a month, loaded and empty. These costs arrive whether the truck moves or not, so a slow month raises the fixed cost on every mile. Here $4,700 over 9,800 miles is about $0.48 a mile. Use the miles you really run, not the miles you hope to run.
Fuel cost per mile
Price per gallon divided by miles per gallon: $3.85 at 6.5 MPG is about $0.59 a mile. Work your MPG out from fill-ups (miles since the last fill divided by gallons), not the dashboard. If a fuel surcharge is part of your pay, keep it in the pay, and keep the full fuel cost here.
Total cost and break-even per loaded mile
B20 adds fixed, fuel and running costs: about $1.29 for every mile the truck moves. But only loaded miles get paid, so divide by the share of miles that are loaded (1 minus the deadhead share). With 12% deadhead, break-even is $1.47 per loaded mile. ROUNDUP keeps it from being rounded below what you need.
Minimum rate to quote
Cost per mile plus the profit you want per mile, divided by the loaded share. $1.29 plus $0.45, at 12% deadhead, is $1.98 per loaded mile. That is the floor for your usual mix of loads; a single load with a long deadhead needs more, which is what the load checker shows.
Check a load before you accept it
Type the loaded miles, the deadhead to pick up, the offer and any tolls in E17:E20. E25 works out the pay the load needs for your target profit, E24 the profit at the offered pay, and E26 sorts it into one of three verdicts. The sample offer of $1,050 is $1.94 a loaded mile but only $1.68 per total mile once the 85 deadhead miles count. It makes $242.56 over costs, but hitting the target needs $1,089, so the verdict is Covers costs, under target: counter at $1,089 or more.
Make it yours
- Update the miles per month in E12 from last month's real miles. Fixed cost per mile is the number that moves most in a slow month.
- If you pay yourself a set amount per mile, put it in E9. If you take whatever is left as your pay, leave E9 at 0 and treat the profit as your wage.
- Spread once-a-year costs (plates, permits, annual insurance payments) over 12 months in the fixed cost list.
- Keep a copy of the sheet for each month so you can see your cost per mile change with fuel prices and miles.
FAQ
How do I calculate cost per mile for a truck?
Add your monthly fixed costs and divide by the miles you run in a month, then add fuel per mile (price per gallon / MPG) and your other per-mile costs such as maintenance and tires: =fixed/miles + price/MPG + running_costs.
What is the difference between rate per loaded mile and rate per total mile?
Rate per loaded mile divides the pay by the miles with freight on board, the way loads are usually quoted. Rate per total mile also counts the deadhead miles you drove to pick up. Compare total-mile rate with your cost per mile to see whether a load really pays.
How do I find my break-even rate per mile?
Divide your total cost per mile by the share of your miles that are loaded: =cost_per_mile/(1-deadhead_share). With about $1.29 a mile and 12% deadhead, you need $1.47 per loaded mile just to cover costs.
Functions used
Related guides
- How to calculate the break-even point in Excel
- How to calculate fuel cost and mileage in Excel
- How to calculate cost per unit in Excel (formula and examples)
- ROUND vs ROUNDUP vs ROUNDDOWN in Excel
More free templates
- Trucking load tracker templateFor owner-operators and dispatchers who want a month of loads in one place.Free .xlsx
- Employee expense report template for ExcelFor employees who need to claim back business costs, and for the managers and bookkeepers who check those claims.Free .xlsx
- Purchase order template for Excel (PO form with sample)A simple purchase order form for small businesses, office managers and buyers who send POs to suppliers and want to track what actually arrives.Free .xlsx
- Accounts receivable aging report templateFor owners, bookkeepers and credit controllers who invoice customers on terms and need to see who owes what and for how long.Free .xlsx
Updated