Trucking Cost Per Mile Calculator Excel

What This Calculator Does and Why Owner-Operators Need It

Knowing your exact cost per mile is the foundation of a profitable trucking operation. Without this number, you cannot evaluate whether a load is worth taking, whether your rate per mile covers your expenses, or how much profit you are actually keeping at the end of the month.

This free trucking cost per mile calculator works like an Excel spreadsheet but runs entirely in your browser — no download required. It separates your fixed monthly costs from your variable per-mile costs, then combines them into a single all-in cost per mile number. If you also enter your rate per mile, you get your monthly profit or loss in one click.

For owner-operators managing their full financial picture, this tool pairs well with the owner-operator net profit calculator and the IFTA fuel tax calculator for a complete operating cost view.

How to Use This Calculator

Step-by-Step Instructions

1. Enter your monthly fixed costs: truck payment, trailer payment, insurance, permits and licenses, driver salary or draw, and any other fixed monthly expenses.
2. Enter your variable costs: fuel price per gallon and your average MPG, maintenance cost per mile, tire cost per mile, IFTA fuel tax per mile, and toll cost per mile.
3. Enter your total miles driven per month.
4. Optionally enter your rate per mile charged to see monthly profit or loss.
5. Click Calculate Cost Per Mile to see a full breakdown table with monthly totals and per-mile costs for every category.
6. Click Reset to clear all fields and start over.

The Formula Explained

Breaking Down the Formula

The cost per mile formula has two parts: fixed costs and variable costs. Fixed costs are the same every month regardless of how many miles you drive — payments, insurance, permits. Variable costs change with the miles you run — fuel, maintenance, tires, tolls. To find your cost per mile, you add these together and divide by total miles driven.

Cost Per Mile = (Total Fixed Costs Per Month + Total Variable Costs Per Month) ÷ Miles Per Month

Variable cost per mile for fuel is calculated separately: Fuel Cost Per Mile = Fuel Price Per Gallon ÷ MPG. Then all per-mile variable costs are summed: Total Variable CPM = Fuel CPM + Maintenance CPM + Tire CPM + IFTA CPM + Toll CPM. Monthly variable total equals Total Variable CPM × Miles. The grand total divided by miles equals your all-in CPM.

Example Calculation with Real Numbers

An owner-operator runs 10,000 miles per month. Fixed costs total $7,000 per month (truck payment $1,800, insurance $900, salary $3,500, permits $120, other $680). Fuel at $3.75 per gallon at 6.5 MPG equals $0.577 per mile, times 10,000 = $5,770. Maintenance $0.12, tires $0.03, IFTA $0.04, tolls $0.05 = $0.24 per mile variable total ($2,400/month). Total cost: $7,000 + $5,770 + $2,400 = $15,170. Divided by 10,000 miles = $1.517 per mile. If the driver charges $2.20 per mile, monthly profit is $6,830.

When Would You Use This

Real Life Use Cases

Every time you receive a load offer on a load board, the first question is: does this rate cover my costs? If someone offers you $1.80 per mile and your calculated CPM is $1.75, you make only $0.05 per mile — and that margin evaporates immediately if you hit any unexpected expenses. Knowing your CPM before you accept a load is the difference between running a profitable route and running yourself broke.

Owner-operators also use CPM analysis when negotiating with freight brokers, deciding whether to add a second truck, or evaluating whether to install fuel-efficiency upgrades. If adding aerodynamic improvements raises your MPG from 6.0 to 6.8, this calculator shows you exactly how much that reduces your per-mile cost and what your monthly savings would be.

Specific example scenario

A solo operator gets an offer for a 1,200-mile run at $1.95 per mile. Their calculated CPM is $1.88. The load pays $2,340 and costs $2,256 to run — a profit of only $84. But the run is deadhead 200 miles to pick up. Adding those empty miles with no revenue but real fuel cost drops the effective profit to near zero. Tools like the empty mile deadhead cost calculator and the trucking cost per mile deadhead vs loaded calculator extend this analysis to include the full round-trip cost picture.

Tips for Getting Accurate Results

Use a 3-Month Average for Variable Costs

Maintenance costs are lumpy — one month you replace a tire, another month you pay for a full brake job. Using a single month’s actual spend gives an inaccurate picture. Instead, take your last three months of maintenance and repair bills, total them, and divide by three to get a realistic monthly average. Then divide by your monthly miles to get a stable per-mile figure.

Separate Loaded Miles from Total Miles

Your effective CPM is technically based on all miles driven, including empty deadhead miles. But your revenue only comes from loaded miles. If you run 10,000 total miles but only 7,500 are loaded, you are spreading your fixed costs over fewer revenue-generating miles. Use total miles for the cost calculation and loaded miles for revenue — then compare them to see your true margin.

Update Your Calculation Every Quarter

Fuel prices change. Insurance renews at different rates. Maintenance costs rise as your truck ages. A CPM calculation done six months ago may be significantly off today. Revisit your numbers every quarter, especially after any major cost change, to ensure you are quoting loads at a rate that actually covers your updated costs.

Frequently Asked Questions

What is a good cost per mile for trucking?

A typical all-in cost per mile for an owner-operator ranges from $1.50 to $2.00 depending on equipment age, insurance rates, fuel prices, and region. Older paid-off trucks have lower fixed costs. Newer trucks with high payments push CPM higher. The key is that your rate per mile consistently exceeds your CPM by a meaningful margin.

What is the difference between fixed and variable trucking costs?

Fixed costs stay the same regardless of how many miles you drive — truck payments, insurance premiums, and permits are examples. Variable costs increase with every mile you drive — fuel, maintenance, tires, and tolls are examples. Both categories must be included to get an accurate total cost per mile.

How do I calculate fuel cost per mile?

Fuel cost per mile equals fuel price per gallon divided by your miles per gallon. If diesel costs $3.80 per gallon and your truck gets 6.2 MPG, your fuel cost per mile is $0.613. This is typically the largest variable cost category and the one most sensitive to price changes.

Does this calculator include driver pay?

Yes. The salary or driver draw field in the fixed costs section captures what you pay yourself or an employed driver each month. For owner-operators, your draw should reflect what you need to take home after covering the truck’s operating costs — not what is left over accidentally.

How do deadhead miles affect my cost per mile?

Deadhead miles cost you fuel, tire wear, and time without generating any revenue. They effectively raise your all-in cost per loaded mile. Some operators calculate a separate deadhead CPM and add it to their loaded rate when quoting to ensure empty miles are accounted for in every load price.

Why should I use a calculator instead of a spreadsheet?

A browser-based calculator is faster, requires no Excel license, and is accessible from any device including your phone in a truck stop. It also eliminates formula errors that commonly occur in manually built spreadsheets. For the same functionality without the setup time, this tool gets the job done immediately.

What maintenance cost per mile should I use?

Industry estimates for maintenance and repair typically range from $0.10 to $0.20 per mile depending on truck age and type. Newer Class 8 trucks under warranty run lower. High-mileage trucks over 500,000 miles often run higher. Use your actual 3-month average divided by miles for the most accurate figure.

How often should I recalculate my cost per mile?

At minimum, recalculate every quarter and immediately after any major cost change — fuel price spikes, an insurance renewal, a large repair bill, or a truck payment payoff. Running on stale numbers is one of the leading causes of owner-operators underbidding loads and losing money unknowingly.

Conclusion

Your cost per mile is your most important business number in trucking. Without it, every load acceptance is a guess. With it, you can evaluate every offer, spot your break-even rate instantly, and build a business that actually grows profit over time.

Use this free trucking cost per mile calculator as your starting point. Update it regularly, compare it against your load rates, and use it alongside related tools to build a complete financial picture of your operation.