Analysis and Reporting

Cost per Mile Breakdown

An AI prompt that explains where your cost per mile moved, which cost lines drove it, and what to look at next.

5 fields to fill · Updated

The prompt 5 fields

Explain the change in cost per mile for [fleet or region] between [period A] and [period B]. Data: total miles [miles for each period], and costs by line for each period: [fuel, driver pay, maintenance, insurance, equipment, tolls, other]. Calculate cost per mile for each line and in total, rank the lines by how much they moved, and give the likely reason for the top three. Note any line where the data looks incomplete. Use a short table and no more than 200 words.

From the ledger to the three lines that moved.

What you fill in
Fleet
Southeast region
Periods
Q2 vs Q3
Miles
1.42M vs 1.38M
Cost lines
Fuel, pay, maintenance, insurance, equipment, tolls
What comes back

Total cost per mile rose from $1.96 to $2.08, up 12 cents.

Biggest movers

  • Maintenance: up 6 cents. Two engine repairs in August on older tractors.
  • Fuel: up 4 cents. Higher diesel prices, partly offset by better mpg.
  • Equipment: up 2 cents. Fewer miles over the same fixed lease cost.

Look at next: whether the older tractors in the August repairs are due for replacement.

Data note: tolls look low for Q3 and may be missing September.

Know where cost moved. Line by line.

Vic pulls miles and cost lines, calculates the change, and drafts the explanation for your approval.

ANALYSIS · Q3 VS Q2
Costs pulled6 lines, 2 periods
Change found+12 cents per mile
Cost breakdown ready for review

Four ways to trust the breakdown.

Use the same periods.Compare equal lengths so seasonality doesn’t skew it.
Include miles for both periods.Fixed costs move per mile when miles change.
Ask it to flag gaps.Missing invoices look like savings.
Check the math.Recalculate the total before you share it.
Questions

FAQs

How is cost per mile calculated?

Total operating cost for a period divided by total miles driven in that period. Breaking it out by cost line shows what drives the change.

Which cost lines should I include?

Commonly fuel, driver pay, maintenance, insurance, equipment and tolls. Use the lines your accounting already tracks.

Should I use loaded or total miles?

Pick one and use it every time. Total miles is the most common. Loaded miles shows the cost of empty miles more clearly.

Which AI tools does this prompt work in?

Any AI chat tool. Paste it, fill the fields, and review the draft before sending. In Vic, the facts fill in for you.