Maintenance Backlog Calculator (Weeks of Work)
Backlog in weeks is the plain way to answer whether a maintenance team is keeping up. This calculator converts open work hours into weeks of crew capacity and shows how many people you need just to stop it growing.
Your numbers
Estimated labor hours on all open, approved work orders.
Share of paid time spent actually doing work.
Estimated hours of new approved work added each week.
Your results
Backlog hours are estimates and vary with planning quality. Exclude work on hold for engineering or budget. Counts only work for this crew.
Backlog in weeks vs crew size
Sweeps Technicians in crew from 4 to 30, holding your other inputs fixed.
Get backlog weeks by craft from ERP data
Optional: a short review of how to calculate backlog by craft and area from your open orders.
Optional. The tool and every export work without this. No spam.
How to use it
Take the estimated hours on all open approved work orders for one crew, and separately the portion that is ready to start, meaning parts, permits and plans are in place. Enter crew size, paid hours, wrench time and the hours of new work arriving each week. Capacity equals crew times paid hours times wrench time. Backlog in weeks is hours divided by capacity. Net burn-down subtracts incoming work, and the clearance figure divides backlog by that net rate.
Reading the numbers
Many reliability guides treat two to four weeks of ready backlog as healthy, because it gives planners room to schedule without letting work age. Far above that, work orders age and users stop trusting the system. Far below, the crew may be idle or work is not being captured. Total backlog and ready backlog tell different stories. A large total with a small ready portion usually means a parts or planning problem, not a labor problem.
- Under 2 weeks ready: check for hidden work
- 2 to 4 weeks ready: usually healthy
- Over 6 weeks: aging work and rising risk
- Clearance of 0: you are not covering inflow
Wrench time matters
Studies of reactive maintenance often find wrench time near a quarter to a third of paid hours, and well planned operations reach about half or more. If you raise wrench time from 40 to 55 percent in the default example, productive capacity rises by more than a third without hiring. The chart shows how sensitive backlog weeks are to crew size, which helps when arguing for contractors or temporary help.
Common mistakes
Counting estimated hours that are not planned, mixing crews with different skills, including standing PM work that is not really backlog, and measuring backlog on a month when many orders were just closed. Use the same definition every month, split by craft where possible, and track the trend rather than a single reading. In SAP PM or a CMMS the data comes from open orders with remaining work.
Frequently Asked Questions
What counts as maintenance backlog?
Approved work orders that have not been completed, measured in estimated labor hours. Exclude work on hold for budget or engineering and anything not yet approved, or the figure overstates what the crew can act on.
How many weeks of backlog is healthy?
A common guide is two to four weeks of ready backlog per crew, though it varies with site and work type. Outside that range, look at planning, capacity and work capture rather than only the number.
What if the weeks to clear shows zero?
It means weekly productive capacity does not exceed new work arriving, so the backlog will not shrink. Increase capacity, raise wrench time, reduce incoming work or add temporary labor.
Should I use paid hours or productive hours?
Backlog estimates are work content, so compare them with productive hours. That is why the calculator multiplies paid hours by wrench time before dividing.
Netray can compute backlog weeks by craft and area directly from your ERP or CMMS each morning, with the query shown so planners can check it.
Related Tools
SAP PM Wrench Time Loss Calculator
Enter minutes lost per shift to permits, parts, travel, meetings and breaks. See wrench time percent and the yearly labor cost of the losses.
Maintenance & ReliabilityPreventive Maintenance Schedule Template
Editable PM schedule worksheet that turns task intervals and durations into annual runs, annual hours and technician load.
Maintenance & ReliabilityPM Compliance and Schedule Compliance Calculator
Calculate PM compliance, completion rate, overdue tasks, hours variance and the share of effort spent on preventive work.
Maintenance & ReliabilityMaintenance Work Order Template
Fill-in maintenance work order form covering request, safety, tasks, parts, completion data and sign-offs, with PDF and Word export.
More Maintenance & Reliability tools
See all- Inherent vs Operational Availability Calculator (MTBF, MTTR)
- Spare Parts Criticality Scoring Worksheet
- Reliability Centered Maintenance (RCM) Worksheet
- Maintenance Cost per Unit Produced Calculator
- Optimal PM Interval Calculator (Weibull Cost Model)
- Maintenance Crew Size Calculator
- P-F Interval Inspection Frequency Calculator
- Reactive vs Planned Maintenance Cost Calculator
- Maintenance Contractor vs In-House Technician Cost Calculator