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. Use it alongside our fleet calculators to size the costs this template tracks, or browse fleet management software when you are ready to automate the workflow. See all downloads in the template library, and check the fleet glossary for any unfamiliar terms.
Built and reviewed by the FleetOpsClub research team. Preview it free below.
- 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
- Editable CSV. Yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
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.
What's inside
- 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
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 |
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.