Trucking Cost Per Mile Calculator for Owner-Operators
Ratelane is a trucking cost per mile calculator and rate-per-mile spreadsheet built for owner-operators and small fleets. Enter your truck and trailer payments, insurance, permits, fuel, tires, tolls and your own pay once, and it tells you three numbers you need before every booking: your true cost per mile, your break-even rate per loaded mile and the minimum rate to accept at your target profit margin. Then it puts those numbers to work with a load quote checker, a load board comparison, what-if scenarios and a monthly actuals tracker.
Most free calculators stop at one cost per mile figure. Ratelane goes further: it prices in deadhead, treats factoring, dispatch and lease-on percentages correctly as a share of revenue, and shows the counteroffer you should ask for.
Who It Is For
- Owner-operators with their own authority or leased on to a carrier
- New authorities setting rates and building a business plan
- Small fleets (one copy per truck) and dispatchers quoting loads for drivers
- Dry van, reefer, flatbed, hotshot and box truck operators: the math is the same, only the inputs change
Main Benefits
- Stop hauling below cost. See the exact rate per loaded mile where you start losing money.
- Know your minimum before you call the broker. Set a target margin and get the minimum rate and a rounded counteroffer.
- Price deadhead into every quote. Brokers pay loaded miles; Ratelane makes sure empty miles are covered.
- Plan ahead. Test diesel price jumps, a new truck payment or better MPG before they hit your bank account.
- Track reality. Compare each month’s real cost per mile, rate, MPG and profit with your plan.
Features of the Cost Per Mile and Rate Per Mile Spreadsheet
Cost per mile and break-even rate
- Fixed Costs tab with 30 lines (24 pre-named: payments, insurance types, IRP plates, Form 2290, UCR, permits, ELD, load boards, health insurance and more) and a how-often drop-down: weekly, every 2 weeks, monthly, quarterly, every 6 months or yearly
- Variable Costs tab: fuel and DEF from price and MPG, 10 tire and maintenance reserves (cost each time / miles it lasts), a general repair reserve, tolls and other per-mile costs
- Driver or owner pay four ways: per mile, percent of revenue, weekly pay or no separate pay
- Revenue-based fees: lease-on carrier split, dispatch fee and factoring fee
- Cost Per Mile tab: full breakdown per year, month, total mile and loaded mile; break-even rate; minimum rate to accept; revenue needed per year, month, week and working day; comparison with the ATRI industry benchmark
- Rate ladder showing the profit per mile, per 1,000-mile load and per year at 14 different rates, color-coded by verdict
Load quote checker and load compare
- Quote Checker: linehaul, fuel surcharge, detention pay, loaded and deadhead miles, days and extra costs; per-load diesel price and MPG overrides
- True profit after fuel, wear, pay, fees and a share of fixed costs (per mile or per day), plus profit per day and per mile
- Clear verdict banner: accept, negotiate or decline, with break-even pay, minimum pay and a counteroffer rounded up to your step
- Load Compare: up to 30 load board offers side by side, verdicts and a ranking by profit per day
Planning and tracking
- What-If: your plan plus 4 scenarios (diesel, MPG, miles, deadhead, fixed cost change, maintenance, margin, rate) with a comparison chart
- Diesel price x MPG grid showing your break-even rate for 66 combinations
- Monthly Actuals: 12 months of real numbers vs plan with cost per mile, rate per loaded mile, deadhead %, MPG, margin and status
- Dashboard with 8 KPI tiles, a rate check banner and 3 charts
What Is Included
- Ratelane-Trucking-Cost-Per-Mile-Calculator.xlsx: one workbook, 11 tabs, clean and ready for your numbers
- Ratelane-User-Guide.docx: a 13-page illustrated Word guide covering set-up, every tab, tips, troubleshooting and FAQs
How It Works
- Settings: choose your currency, plan year, miles per year, deadhead %, fuel price, MPG and target margin.
- Enter costs: fill in the yellow cells on Fixed Costs and Variable Costs. Set-up takes about 20 minutes.
- Read your numbers: the Dashboard and Cost Per Mile tab show your cost per mile, break-even and minimum rate.
- Check loads: use the Quote Checker for one offer or Load Compare for a shortlist.
- Track: log each month on Monthly Actuals and watch the dashboard update.
File Format and Software Requirements
The workbook is a standard .xlsx file. It works in Microsoft Excel 2016 or newer, Microsoft 365, Excel for Mac and Excel for the web, and in Google Sheets (upload it to Google Drive and open it with Google Sheets). No macros, add-ins or internet connection are needed. The user guide is a .docx file that opens in Word, Google Docs or any word processor. A computer is recommended for set-up; phone and tablet apps work for viewing.
Customization
Type your own currency symbol and every money label follows it. Rename any cost line, add costs in the spare rows and change colors or column widths. Formula cells are locked to protect them from accidental edits, with no password, so you can unprotect a sheet whenever you want to change it.
Digital Download
This is a digital product. You receive the workbook and user guide as instant downloads after purchase; nothing is shipped. License: personal use, or use within your own business. Please do not resell, share or redistribute the files.
Use Cases
- A new authority working out what rate to quote on its first loads
- An owner-operator deciding whether a cheap backhaul is worth taking or deadheading home
- A driver comparing a lease-on offer at a 25% carrier split with running under their own authority and factoring at 3%
- Checking what a $0.75 diesel increase or an $800 truck payment does to the break-even rate
- Showing a lender or partner a realistic yearly revenue target
Trucking Cost Per Mile Calculator FAQ
How do I calculate my trucking cost per mile?
Add up all yearly costs (fixed, variable, your pay and fees) and divide by the total miles you run, loaded and empty. Ratelane does this for you and also divides by loaded miles to give your break-even rate.
What is a good cost per mile for an owner-operator?
It depends on your equipment and lanes. ATRI’s 2026 report put the average 2025 carrier cost at $2.336 per mile including driver pay. The workbook compares your number with this benchmark, which you can edit.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. Formulas, drop-downs, conditional colors and charts carry over.
Does it include deadhead miles?
Yes. Your plan uses a deadhead percentage, and each quote uses the actual deadhead miles to the pickup.
Can I use it if I am leased on to a carrier?
Yes. Enter the carrier’s percentage as the lease-on split and only the costs you pay yourself.
Does it do IFTA or taxes?
No. Ratelane focuses on cost per mile and rate decisions. It is a planning tool, not tax software or tax advice.
Can I change the currency?
Yes. Type any symbol on the Settings tab and every money label updates.












Reviews
There are no reviews yet.