What is a fleet maintenance planner?
A fleet maintenance planner tells you which vehicles need service now, which will need it soon and when the rest are due. For each vehicle you enter the current odometer, the odometer and date at the last service and the distance it covers in a month. You set your service intervals by distance, by time and, for equipment, by engine hours. The planner checks every trigger, picks the one that comes first and sorts the fleet into overdue, due soon and on track, with an estimated due date for each.
It works as a ready-made preventive maintenance schedule for a mixed fleet without a maintenance system. Two more tabs answer the questions that come up in every maintenance budget: what does a breakdown really cost once downtime is counted, and would spending more on preventive maintenance cost less overall?
Why preventive maintenance needs a due list
Most fleets have a service interval. Few have an up-to-date view of where each vehicle stands against it. A due list helps you:
- Catch overdue vehicles before they fail. A vehicle that runs past its interval carries more risk of an unplanned stop, which usually costs more than the service it missed.
- Plan workshop capacity. Seeing what is due in the next 30 days lets you book bays, parts and drivers instead of reacting.
- Respect the first trigger. A low-mileage van can still be due by date, and a loader can be due by hours long before its odometer moves.
- Put numbers on downtime. Knowing what a day off the road costs turns maintenance from an expense line into a decision.
What data do you need for a fleet maintenance schedule?
| Input | Where to find it | Tip |
|---|---|---|
| Service intervals | Manufacturer schedule, your maintenance policy | Use the interval for your duty cycle; severe service usually needs shorter intervals. |
| Odometer now and at last service | Service records, odometer readings, tracking reports | Record the odometer on every work order so the next due point is exact. |
| Distance per month | Odometer difference between two months | Use a typical month; the planner uses it only to estimate a date. |
| Engine hours | Hour meter or engine data | Only for equipment or vehicles serviced by hours. |
| Downtime costs | Workshop invoices, rental invoices, payroll, lost jobs | Separate money you spent from work you lost. |
How to calculate service due by km, date and engine hours
Distance trigger
Time trigger
Engine-hour trigger
Status
A trigger is overdue when its remaining distance, days or hours is below zero, and due soon when it falls inside the window you set or its estimated date is within the day window. Each vehicle takes the status of its first trigger: overdue before due soon, then the fewest days.
Fleet downtime cost
Direct cost is money you can see on invoices and payroll. Lost contribution is the margin on work you could not do, which is an opportunity cost. The two are shown separately, and lost contribution only applies to days without a replacement vehicle so nothing is counted twice.
Preventive maintenance scenario
Worked example: service due dates and downtime cost
A fleet services every 10,000 km or 6 months, and flags vehicles within 1,000 km or 30 days.
- Truck 02 was serviced at 85,000 km and now reads 96,500 km: 85,000 + 10,000 − 96,500 = −1,500 km, overdue.
- Truck 01 was serviced at 139,000 km and now reads 148,200 km: 800 km left, inside the 1,000 km window, so it is due soon. At 6,500 km a month that is about 4 days.
- A breakdown keeps a truck off the road for 3 days. Repair is 1,200, recovery 250, other costs 100, and a rental at 180 a day covers half the days. The driver costs 160 a day on uncovered days and each uncovered day loses 450 of contribution: direct cost 2,060, lost contribution 675, 2,735 per breakdown.
- With 40 vehicles at 1.2 breakdowns each per year, breakdowns cost 40 × 1.2 × 2,735 = 131,280 a year. Spending 600 more per vehicle on preventive work (24,000 in total) breaks even if breakdowns fall by 24,000 ÷ 131,280 = 18.3%.
How to read your maintenance plan
- Overdue vehicles go to the top of next week's workshop plan.
- Due soon vehicles are the ones to book now, while you can still choose the slot.
- The trigger column tells you why a vehicle is due. If most are due by date while their kilometers are low, your time interval may be driving cost; check what the manufacturer allows for your duty cycle.
- Downtime per day is the figure to compare with the cost of a spare vehicle or a faster repair.
- The break-even reduction is the test for a preventive maintenance proposal: if you cannot believe breakdowns will fall by at least that much, the extra spend is hard to justify on cost alone.
Common mistakes in fleet maintenance planning
- Tracking only distance. Oil, fluids and rubber age with time too, and low-use vehicles miss their date-based service.
- Estimating the odometer. A due list is only as good as the last reading. Update it at least monthly.
- Counting downtime twice. If a rental covered the day, the work was not lost; charge the rental or the lost margin, not both.
- Treating lost contribution as cash. It is real, but it is an opportunity cost. Keep it separate when you present a budget.
- Assuming preventive maintenance always pays. The reduction in breakdowns is an assumption. Test it on a group of vehicles before rolling it out.
Assumptions and limits
Results are estimates based on the values entered. Estimated dates assume steady monthly use. The planner applies the same intervals to every row, so run it per vehicle group if intervals differ. It does not replace manufacturer schedules, inspections required by law or the judgment of a qualified technician. The preventive maintenance result is a scenario built on the reduction you enter, not a forecast or a promised saving.