Maintenance Backlog Planner Skip to main content
Shops & Outbuildings Free Pro Features Available

Maintenance Backlog Planner

Compare ready work with the crew hours available to do it.

PREVIEW All Pro features are currently free for a limited time. No license key required.

Shops & Outbuildings

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.

Pro Tip: Start with jobs that are estimated and ready to schedule. Keep waiting-for-parts work separate, and do not deduct the same hours as both unavailable time and reserved work.

How It Works

  1. 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.

  2. Enter weekly crew capacity

    Enter crew full-time equivalents and hours per FTE per week. Fractional FTE values can represent part-time staffing.

  3. Separate capacity deductions

    Enter unavailable time as a percentage and other reserved work as weekly hours. Do not count the same deduction twice.

  4. 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

  1. DOE-HDBK-1211-2014: Activity Level Work Planning and Control Implementation Appendix B, printed page B-2: CM backlog in crew weeks.

Frequently Asked Questions

It is one week of the whole entered crew capacity. For example, 4 FTE at 40 hours each provide 160 labor-hours per week. A 1,200-hour backlog is 7.5 crew-weeks at that gross capacity.
With 15% unavailable time and 20 separately reserved hours, that 160-hour gross capacity becomes 116 hours per week. The same backlog is about 10.3448 crew-weeks. The deductions must represent different hours.
Dividing by zero or negative capacity does not give a useful completion duration. The planner shows the capacity and explains why the result is unavailable. Invalid or non-finite inputs must be corrected first.
No. It assumes a fixed backlog and constant capacity. Incoming work, task dependencies, skill matching and day-by-day scheduling are outside this calculation.
Disclaimer: A capacity estimate from the inputs you enter. Use current work estimates and local scheduling judgment before committing a crew or completion date.