Maintenance program
Maintenance backlog calculator
Backlog measured in weeks tells you how long the outstanding work would take if no new work arrived. Measured in hours it means nothing without a crew size, which is why the weeks figure is the one worth reporting.
Backlog weeks = Outstanding work hours ÷ (Technicians × Available hours per technician per week)
Estimated hours on every approved open work order
Net of meetings, training and holiday
Show the assumptions
- Formula
- Backlog weeks = Outstanding work hours ÷ (Technicians × Available hours per technician per week)
Available hours, not paid hours. Subtract training, meetings, PM commitments and holiday, or you will calculate a backlog the crew has no capacity to clear.
A backlog near zero is not a win. It usually means work is not being raised, or the crew is oversized. Too high and the oldest jobs will never be done, so the list stops being a plan and becomes a record of intentions.
Maintenance backlog
—
Prefilled with an example. Change any number and the result updates.
How to calculate Maintenance backlog
Backlog weeks = Outstanding work hours ÷ (Technicians × Available hours per technician per week)
Available hours, not paid hours. Subtract training, meetings, PM commitments and holiday, or you will calculate a backlog the crew has no capacity to clear.
Worked example
- Outstanding work hours 640 hrs
- Technicians 6
- Available hours per technician per week 30 hrs
Maintenance backlog = 3.6 weeks
Reading the result
A backlog near zero is not a win. It usually means work is not being raised, or the crew is oversized. Too high and the oldest jobs will never be done, so the list stops being a plan and becomes a record of intentions.
Benchmarks
Two to four weeks of ready backlog per crew is the range commonly cited as healthy: enough to schedule around without work aging out.
Maintenance backlog questions
What is a healthy maintenance backlog?
Two to four weeks per crew is the range most planners aim for. That is enough to build a full schedule from and to absorb a bad week, without jobs sitting so long that the conditions they were raised against have changed.
Should the backlog include work waiting on parts?
Track it separately. Work waiting on parts is not schedulable, so including it in the ready backlog makes the crew look busier than it can be. Most planners report ready backlog and total backlog side by side, and the gap between them is a stores problem rather than a labor one.
Why is a backlog of zero a problem?
Because it means one of three things: work is not being raised, estimates are missing, or you are carrying more labor than the site needs. None of them are good, and all of them are hidden by a number that looks like success.
Related calculators
See the backlog by craft
UpKeep records the work, the hours and the failures this metric depends on, so Maintenance backlog is a report rather than a spreadsheet exercise.