Maintenance Backlog Planner
Compare ready work with the crew hours available to do it.
A backlog of 1,200 labor-hours means little until it is compared with weekly capacity. Enter your ready backlog, crew size in full-time equivalents, and hours per FTE. Compare a gross scenario with a net scenario that deducts unavailable time and separately reserved work.
Review preventive-maintenance interval assumptions
PM Interval Optimizer →Review spare-parts replenishment assumptions
Spare Parts Reorder Calculator →How It Works
-
Count ready labor-hours
Total estimated labor-hours for work that is planned and ready. Do not use the number of work orders as hours.
-
Enter weekly crew capacity
Enter crew full-time equivalents and hours per FTE per week. Fractional FTE values can represent part-time staffing.
-
Separate capacity deductions
Enter unavailable time as a percentage and other reserved work as weekly hours. Do not count the same deduction twice.
-
Compare the scenarios
Check gross and net capacity before using either duration. Recalculate when the backlog or staffing assumptions change.
Built For
- Maintenance planners comparing a ready backlog with current staffing.
- Supervisors documenting the effect of a training week or a separate work commitment.
- Teams preparing a capacity discussion with their CMMS estimates in hand.
Features & Capabilities
Gross capacity
Multiply crew FTE by weekly hours per FTE. Divide backlog labor-hours by this capacity to estimate crew-weeks if the crew works only this backlog.
Net planning scenario
Subtract unavailable time and reserved weekly hours before dividing the backlog. This local scenario extends the gross calculation; it is not a DOE staffing benchmark.
Keep the assumptions
Review the inputs, formulas, limitations and reasons for any missing duration alongside the results.
Assumptions
- Backlog estimates use labor-hours and include only ready work.
- Crew FTE and weekly hours remain constant for the scenario.
- Unavailable time and reserved work do not overlap.
- The gross scenario assigns all entered capacity to the backlog.
Limitations
- Does not model incoming work, skill constraints, parts delays or task dependencies.
- Does not set maintenance priorities, staffing requirements or a promised completion date.
- Net capacity is a user-defined planning extension, not a published DOE target.
References
- DOE-HDBK-1211-2014: Activity Level Work Planning and Control Implementation Appendix B, printed page B-2: CM backlog in crew weeks.