# Maintenance Backlog Calculator (Weeks of Work)

> Source: https://netray.co/tools/maintenance-backlog-weeks-crew-sizing-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Turn backlog hours into weeks of work, estimate the time to clear it and find the crew size that holds it stable.

## Category

maintenance

## Industry

Manufacturing

## Audience

- Maintenance manager
- Maintenance planner
- Plant manager

## Tool

**Kind:** calculator

**Inputs:**

#### Total backlog (estimated hours)

**Key:** backlog

**Type:** number

**Default:** 2400

**Min:** 0

**Step:** 50

**Unit:** hours

**Help:** Estimated labor hours on all open, approved work orders.

#### Ready backlog (parts, permits, planning done)

**Key:** ready

**Type:** number

**Default:** 1500

**Min:** 0

**Step:** 50

**Unit:** hours

#### Technicians in crew

**Key:** crew

**Type:** slider

**Default:** 12

**Min:** 2

**Max:** 40

**Step:** 1

**Unit:** people

#### Paid hours per technician per week

**Key:** hours

**Type:** number

**Default:** 40

**Min:** 1

**Step:** 1

**Unit:** hours

#### Wrench time

**Key:** wrench

**Type:** slider

**Default:** 55

**Min:** 20

**Max:** 80

**Step:** 1

**Unit:** %

**Help:** Share of paid time spent actually doing work.

#### New work arriving per week

**Key:** new_work

**Type:** number

**Default:** 220

**Min:** 0

**Step:** 10

**Unit:** hours

**Help:** Estimated hours of new approved work added each week.

**Outputs:**

#### Productive capacity per week

**Key:** cap

**Expr:** crew * hours * wrench / 100

**Format:** hours

#### Total backlog

**Key:** weeks_total

**Expr:** backlog / cap

**Format:** weeks

**Primary:** true

**Description:** Backlog hours divided by weekly productive capacity.

#### Ready backlog

**Key:** weeks_ready

**Expr:** ready / cap

**Format:** weeks

**Primary:** true

**Description:** Only work that could be started now.

#### Net weekly burn-down

**Key:** net

**Expr:** cap - new_work

**Format:** hours

**Description:** Negative means the backlog is growing.

#### Weeks to clear backlog

**Key:** clear

**Expr:** if(gt(cap - new_work, 0), backlog / (cap - new_work), 0)

**Format:** weeks

**Description:** Shows 0 when capacity does not exceed incoming work, so the backlog never clears.

#### Crew to hold backlog steady

**Key:** steady_crew

**Expr:** ceil(new_work / (hours * wrench / 100))

**Format:** integer

**Description:** Technicians needed just to match incoming work.

**Chart:**

#### Backlog in weeks vs crew size

**Type:** line

**X:** crew

**From:** 4

**To:** 30

**Steps:** 27

**Series:**

- weeks_total
- weeks_ready

**Disclaimer:** Backlog hours are estimates and vary with planning quality. Exclude work on hold for engineering or budget. Counts only work for this crew.

## Content

**Intro:** 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.

**Sections:**

#### How to use it

**Body:** 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

**Body:** 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.

**Bullets:**

- 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

**Body:** 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

**Body:** 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.

**Cta:** 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.

**Faq:**

#### What counts as maintenance backlog?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** Backlog estimates are work content, so compare them with productive hours. That is why the calculator multiplies paid hours by wrench time before dividing.

## Search terms

maintenance backlog calculator, maintenance backlog weeks, how to calculate maintenance backlog, backlog in weeks formula, maintenance crew size calculator, ready backlog maintenance, wrench time backlog, maintenance planning kpi

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json