By Donald Luverne
Most owner-operators I've talked to over the years can tell you what they grossed last month. Very few can tell you what it actually cost them to earn it. And almost none can tell you whether the load they're about to accept will put money in their pocket or take it out.
That gap, between what you earn and what you actually keep, is where most small trucking operations bleed out. Not from one bad decision, but from a hundred small ones made without the right information.
The AYRMD Cost Per Mile Analyzer was built to close that gap. It's a single spreadsheet that handles four distinct jobs: tracking your true operating costs month by month, giving you a visual dashboard of your business health, evaluating any load before you accept it, and generating AI-powered analysis of your numbers in natural language. No subscription. No complicated setup. No spreadsheet expertise required.
The foundation of the tool is the Inputs tab. Every month, you enter your operating data — miles driven, fixed costs like your truck payment and insurance, variable costs like driver pay and maintenance reserve, your fuel data, and your gross revenue. That's it. From those inputs, the analyzer calculates your Cost Per Mile, your Break-Even Rate, your Loaded Mile percentage, and your estimated net income automatically.
Once you save that month to history, the data is permanent. The tool builds a running record of your operation — month by month, going back as far as you want. You can add earlier history manually, or just start fresh from today and let it accumulate over time.
The Dashboard tab turns your history into a picture of your business. Five KPI tiles across the top show your current month at a glance — Total CPM, Break-Even Rate, estimated net income, Loaded Mile percentage, and average MPG. Each tile shows a status indicator and a month-over-month trend so you know immediately whether things are moving in the right direction.
Below the KPIs, a Risk and Opportunity Intelligence panel auto-generates based on your last three months of data. It flags trends worth paying attention to — MPG declining, loaded mile efficiency dropping, net income compressing — without you having to dig through numbers to find them. The CPM Trend chart at the bottom plots your cost history against the ATRI industry benchmark, so you always know how your operation stacks up against the national average for your type of work.
The AI Advisor tab is where the tool separates itself from anything else on the market. Enter an API key from Claude, OpenAI, or Google Gemini — all free to start, and each analysis costs less than a penny and you have two buttons at your disposal.
The first generates a Business Performance Assessment using only your own data. It reads your history, identifies the patterns that matter, and writes a plain-English report covering your recent trend, your 12-month profile, specific callouts ranked by financial impact, and a forecast signal based on where your numbers are heading. The second button does the same thing but adds a live web search for current freight market conditions, rate trends, and fuel price outlook — then connects that market context directly to your cost structure.
No prompts to write. No AI expertise required. The analysis is pre-configured for trucking economics and calibrated to your specific numbers.
The Load Check tab handles a problem every owner-operator faces: figuring out whether a load is worth taking before you commit to it. Enter the lane, the miles, and the quoted rate. The tool instantly shows you your revenue per mile, how it compares to your break-even rate, and your estimated margin on that load.
There's also a reverse calculator — enter your miles and it shows you the minimum rate to break even, the rate needed to hit your target margin, and the rate required to reach a specific dollar profit goal. And a side-by-side comparison grid lets you evaluate up to five loads at once so you're choosing the best option, not just the first one offered.
The Cost Per Mile Analyzer is a one-time purchase at $19. No monthly subscription fees. No upsells. No account to manage. The file is yours permanently. Download it once and use it as long as you run a truck.
If you've ever wondered whether your operation is actually making money, or taken a load that felt right but didn't pencil out, or wished you had someone who could look at your numbers and tell you what they mean — this is the tool that does all of that. In one spreadsheet. For the cost of a truck stop meal.