Cellwise Start free

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.

cellwise-trucking-cost-per-mile-calculator.xlsxExcel workbook · 4.5 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup
Download free template

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.

RowABCDE
1Trucking cost per mile calculator
2MonthNov 1, 2026
3
4Fixed costs (per month)AmountRunning costs and planAmount
5Truck payment$2,350.00Diesel price per gallon$3.85
6Trailer payment$650.00Average MPG6.5
7Truck and cargo insurance$1,180.00Maintenance and repairs per mile$0.15
8Plates, permits, registration (monthly share)$160.00Tires per mile$0.04
9ELD, load board, dispatch software$120.00Driver pay per mile (0 if you take profit as pay)$0.00
10Phone, accounting, office$140.00Other per mile (tolls, lumpers, washes)$0.03
11Parking and other$100.00
12Total fixed costs$4,700.00Miles per month (all miles)9,800
13Deadhead share of miles12%
14Target profit per mile$0.45
15
16ResultsPer mileCheck a loadAmount
17Fixed cost per mile$0.48Loaded miles540
18Fuel cost per mile$0.59Deadhead miles to pick up85
19Other running cost per mile$0.22Offered pay$1,050.00
20Total cost per mile (all miles)$1.29Tolls and lumper fees$0.00
21Break-even rate per loaded mile$1.47Rate per loaded mile$1.94
22Minimum rate per loaded mile (with target profit)$1.98Rate per total mile$1.68
23Revenue needed per month to break even$12,660.62Cost to run the load$807.44
24Revenue needed per month for target profit$17,070.62Profit on the load$242.56
25Pay needed for target profit$1,089.00
26VerdictCovers costs, under target

How the formulas work

Fixed cost per mile

B17=IF(E12>0,B12/E12,0)

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

B18=IF(E6>0,E5/E6,0)

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

B21=ROUNDUP(B20/(1-E13),2)

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

B22=ROUNDUP((B20+E14)/(1-E13),2)

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

E26=IF(E19>=E25,"Meets target",IF(E24>=0,"Covers costs, under target","Loses money"))

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

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

More free templates

Updated