Fleet financial modeling and budgeting

Fleet Financial Modeling and Budgeting

A trucking operation lives or dies on margin per mile and asset utilization. Carriers without a financial model end up reacting to surprises; carriers with one operate from a plan.

Three statements every carrier needs

Statement	Purpose	Cadence
Profit & Loss (P&L)	Revenue, expenses, net income	Monthly
Balance Sheet	Assets, liabilities, equity at a point	Monthly
Cash Flow	Money in/out (operating, investing, financing)	Monthly

These three reconcile to each other — net income flows into retained earnings (balance sheet), and cash from operations starts with net income (cash flow).

Trucking P&L structure

Revenue
  Line-haul revenue
  Fuel surcharge revenue
  Accessorials (detention, layover, lumper, tarp, etc.)
  Other (brokerage commissions, asset sales)
= Total Revenue

Variable costs (per-mile)
  Driver wages + benefits + payroll tax
  Fuel
  Tolls & permits
  Maintenance (parts, labor, tires)
  Trailer wash / cleaning
= Total Variable Costs

Fixed costs
  Equipment (depreciation or lease)
  Insurance (liability, cargo, occ/acc, physical damage)
  Office payroll
  Office occupancy
  Software (TMS, ELD, accounting)
  Legal / professional
  Marketing
= Total Fixed Costs

Operating Income (EBIT)
- Interest
= Pre-tax income
- Taxes
= Net Income

Revenue modeling

For each truck/driver:

• Loaded miles per week × revenue per loaded mile = weekly revenue
• Empty (deadhead) miles × $0 = revenue waste
• Total miles per week × revenue per total mile = blended rate
• Loaded ratio = loaded miles / total miles (target: 90%+)

A truck running 2,400 miles/week with 91% loaded ratio at $2.20/loaded mile = $4,810/week revenue = $250K/year top-line per truck.

Fuel surcharge runs separately ($0.30–$0.50/mile) and largely offsets fuel cost.

Cost structure benchmarks (2024–2025, dry van OTR)

Cost line	$/mile	% of revenue
Driver wages	$0.55–$0.70	25–30%
Driver benefits/taxes	$0.10–$0.15	4–7%
Fuel (net of FSC)	$0.05–$0.15	3–7%
Maintenance (parts + labor)	$0.10–$0.18	5–8%
Tires	$0.025–$0.04	1–2%
Permits/tolls	$0.03–$0.06	1–3%
Equipment cost	$0.20–$0.35	9–15%
Insurance	$0.06–$0.14	3–6%
Overhead / G&A	$0.10–$0.18	5–8%

Total CPM: $1.20–$1.85 for a well-run dry van operation. Revenue per mile (gross): $2.00–$2.40.

Margin per mile: $0.15–$0.55 = $7K–$25K per truck per year operating income.

Budget building workflow (4 weeks before fiscal year)

Step 1 — Revenue assumptions

• Truck count by month (start, ending, average)
• Available days (subtract PM, breakdowns, driver gaps)
• Utilization (miles per truck per day, target 350–450)
• Rate by lane / customer (use prior-year actuals + market signal)
• Customer mix (% of revenue from top 5 customers)

Step 2 — Cost assumptions

• Driver pay raises (national average ~2–4% annual)
• Fuel price (assumption + FSC mechanism)
• Insurance renewal (use broker estimate, typically 5–15% up)
• Maintenance per mile (use trailing 12-month per truck)
• New equipment depreciation (per spec)
• Office payroll (current + planned hires)

Step 3 — Capital plan

• Truck replacements (units, timing, cost)
• Trailer additions (units, timing, cost)
• IT investments (TMS upgrade, dashcam fleet, etc.)
• Real estate / terminal

Step 4 — Cash flow

• Operating cash (net income + depreciation - working capital change)
• Investing cash (truck purchases)
• Financing cash (debt service, new debt)
• Ending cash + line-of-credit availability

Scenario planning

Run three cases at minimum:

Scenario	Revenue	Cost	Net income
Base	$X	$Y	$Z
Downside (-10% revenue, +5% cost)	$X × 0.9	$Y × 1.05	(often negative)
Upside (+10% revenue, -2% cost)	$X × 1.1	$Y × 0.98	Z + 25%

Downside scenario tests survivability. If a 10% revenue drop + 5% cost increase wipes you out, you're under-capitalized.

Tracking actuals vs budget

Weekly cadence on the top 6 metrics:

• Loaded miles per truck per week
• Revenue per loaded mile
• Empty %
• Fuel CPM
• Maintenance CPM
• Operating margin %

Monthly: full P&L vs budget with variance commentary (>5% line items get a written explanation).

Quarterly: rolling 12-month forecast update.

Common mistakes

• Building a "wishful" budget that doesn't reflect reality
• No driver-pay-raise planning — surprise mid-year cost
• Underestimating insurance increase at renewal — most carriers see 10–25% YoY
• Treating maintenance as flat per mile (older trucks cost 2× newer)
• Ignoring working capital — slow customer payment can choke cash
• No scenario planning — first downturn is existential
• Confusing revenue with cash collected (90-day pay terms common)
• Not tracking variance — budget becomes a document, not a tool

KPIs the owner should watch

KPI	Healthy range (asset-based dry van)
Operating margin	5–12%
Revenue per truck per week	$4,500–$5,500
Driver turnover annualized	< 50%
Tractor age (avg)	3–5 years
Tractor utilization (loaded miles/yr)	110K–140K
DSO (days sales outstanding)	30–45 days
Cash on hand	60–90 days of opex
Debt-to-EBITDA	< 3.0×

Where this fits in X3

X3's operations data (loaded miles, fuel, maintenance) flows into the financial model. The dashboard shows revenue per truck, CPM, and margin in near real-time so owners aren't waiting on month-end close.

A carrier that doesn't know their CPM is operating blind. The point of the budget is not the document — it's the discipline of knowing the numbers cold.

---

<!-- x3-compass-attribution-v1 -->

Built by X3 Compass

The AI-powered DOT compliance platform for fleets 1–100 power units. Try a 7-day free trial — no credit card required — at https://x3compass.com/?utm_source=skill&utm_medium=github&utm_campaign=fleet-financial-modeling-and-budgeting

X3 Compass turns these skills into a complete operational platform: driver qualification files, drug & alcohol consortium, MVR pulls, hours-of-service tracking, hazmat shipping, IFTA filing, FMCSA audit prep, and DataQ dispute drafting — all CFR-cited, all in one place.

This skill is published under the X3 Compass open skills initiative. Contributions welcome at https://github.com/x3fleetsafety/skills