Cost / Budget / Finance · Excel template
Free Cost-Per-Mile Worksheet
A cost-per-mile worksheet that splits every operating expense into fixed and variable buckets and divides by miles — so you know your true CPM and the rate you actually need to charge to make money.
Built and reviewed by the FleetOpsClub research team. Preview it free below. Enter your name and email to unlock the full template and the editable spreadsheet — a CSV that opens in Excel, Google Sheets, or Numbers.
- Editable CSV — yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
What you get
- Separate fixed-cost (payments, insurance, permits) and variable-cost (fuel, tires, maintenance) sections
- Total miles input that converts every cost line into cents per mile
- A combined cost-per-mile figure plus the breakeven rate per mile
- A driver/fixed-pay handling line so labor lands in the right bucket
- A worked example computing CPM for a single power unit over a month
How to use it
- 1
Enter your fixed monthly costs — truck payment, insurance, permits, plates — that don't change with miles.
- 2
Enter your variable costs — fuel, tires, maintenance, tolls — that scale with distance.
- 3
Input the total miles driven for the same period.
- 4
Divide each total by miles to get fixed CPM and variable CPM, then add them for total cost per mile.
- 5
Compare your cost per mile against your average rate per mile — the gap is your margin per mile.
Preview the template
Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.
Preview
Cost-Per-Mile Worksheet
Cost per mile = total cost ÷ total miles. Keep fixed and variable separate: fixed CPM rises sharply when miles drop, which is why low-utilization months hurt margin most.
| Cost Category | Type | Monthly Amount ($) | Miles | Cost/Mile ($) |
|---|---|---|---|---|
| Truck payment | Fixed | 2,100 | 10,000 | 0.210 |
| Insurance & permits | Fixed | 1,250 | 10,000 | 0.125 |
Free unlock
Unlock the full template
Enter your name and email to reveal the complete template and download the editable spreadsheet. You can print it, save it as a PDF, or adapt the columns to your own vehicles. It's a fair trade: the preview costs nothing, and the full file costs you about 20 seconds.
- Editable CSV
- Every row & section
- Branded PDF
Frequently asked questions
Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.
Cost per mile (CPM) is your total operating cost divided by the miles driven over the same period. It's the single most important number for pricing freight, because it tells you the rate per mile you must beat to make a profit.
Fixed costs — payments, insurance, permits — stay the same whether you run 8,000 or 12,000 miles, so fixed cost per mile rises sharply when miles fall. Variable costs scale with distance. Splitting them shows why low-mileage months erode margin.
It varies widely by equipment, lane, fuel price, and how labor is counted, so there's no single right number — owner-operator CPM commonly lands somewhere around $1.50–$2.00 all-in. Calculate your own; benchmarks are only a sanity check.
Cost per mile is an operating-rate view over a recent period, used mainly for pricing. Total cost of ownership looks at a vehicle's full lifecycle cost from purchase to disposal. CPM feeds TCO but answers a more immediate question.
Related guides & tools
- Fleet cost per mile: how to calculate it
- Truck cost per mile calculator
- Glossary: Cost per mile
- Total cost of ownership worksheet
Looking for more? Browse all fleet templates or run a fleet calculator.