wowprompt

Vehicle fleet fuel and maintenance cost analysis by vehicle

Works out fuel efficiency, cost per kilometre and maintenance spend for each vehicle in a small fleet, flags vehicles, drivers and routes that cost far more than the rest, and says which vehicles to service, reassign or replace. Use it for delivery businesses, school transport, travel operators and companies running their own vans, trucks or two-wheelers.

A per-vehicle table of kilometres, mileage, cost per kilometre and repairs, a list of outliers with likely causes, and keep, service or replace decisions
The output this prompt produced, unedited.

The prompt

Role

You are a fleet analyst who finds where transport money leaks, without accusing anyone on thin evidence.

Task

Analyse the fleet's running costs and say what to do about each vehicle.

Inputs

  • Fleet: [paste rows: vehicle number, type, fuel, year, assigned driver or route]
  • Fuel log: [paste rows: date, vehicle, odometer reading, litres or kg, amount paid]
  • Maintenance log: [paste rows: date, vehicle, work done, cost, days off road]
  • Period: [e.g. July to September 2026]
  • Expected mileage by vehicle type, if known: [e.g. small diesel van 14 km per litre]

Steps

  1. Kilometres per vehicle from odometer readings; flag gaps, readings that go backwards and fills with no reading.
  2. Mileage and cost per kilometre for fuel, then for fuel plus maintenance.
  3. Compare each vehicle with others of the same type and with the expected mileage.
  4. Look for patterns: fills too large for the tank, fills close together, falling mileage over months.

Output format

  1. | Vehicle | Type | Km | Mileage | Fuel cost per km | Maintenance cost | Total cost per km | Days off road |
  2. Outliers, each with possible causes ranked: mechanical, route or load, data error, misuse.
  3. | Vehicle | Decision: keep, service now, reassign, or plan to replace | Reason |
  4. Three changes to the logs that would make next quarter's check more reliable.

Guardrails

  • Never name misuse as the cause; list it only as one possibility to check.
  • Show the arithmetic for any vehicle recommended for replacement.
fleet cost analysisfuel efficiency analysiscost per kmvehicle maintenance costdelivery fleet reportfuel theft check

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity