# SAP PM Maintenance Backlog Weeks Calculator

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

## Short answer

Turn the open work hours from your SAP PM order list into backlog in weeks, net burn rate and weeks to clear. Includes a crew-size sweep.

## Category

sap

## Erp

SAP PM

## Industry

Manufacturing

## Audience

- SAP PM consultant
- Maintenance planner
- Maintenance manager

## Tool

**Kind:** calculator

**Inputs:**

#### Open planned work hours

**Key:** open_hours

**Type:** number

**Default:** 3200

**Min:** 0

**Step:** 50

**Unit:** hours

**Help:** Sum of remaining work (operation work minus actual work) on released, planned orders, for example from an IW38 list exported to Excel.

#### Craft technicians available

**Key:** crew

**Type:** number

**Default:** 12

**Min:** 1

**Step:** 1

**Unit:** people

#### Paid hours per technician per week

**Key:** paid_hours

**Type:** number

**Default:** 40

**Min:** 1

**Max:** 80

**Step:** 1

**Unit:** hours

#### Wrench time

**Key:** wrench_pct

**Type:** slider

**Default:** 50

**Min:** 20

**Max:** 80

**Step:** 1

**Unit:** %

**Help:** Share of paid hours spent on hands-on work. Studies of typical plants often land between 25 and 55 percent.

#### New work arriving per week

**Key:** inflow

**Type:** number

**Default:** 380

**Min:** 0

**Step:** 10

**Unit:** hours

**Help:** Average weekly hours of new orders generated from notifications and maintenance plans.

**Outputs:**

#### Productive capacity per week

**Key:** capacity

**Expr:** crew * paid_hours * wrench_pct / 100

**Format:** hours

**Description:** Hands-on hours the crew can deliver each week.

#### Backlog in weeks

**Key:** backlog_weeks

**Expr:** open_hours / capacity

**Format:** decimal

**Primary:** true

**Description:** Open hours divided by weekly productive capacity. Many planners target roughly 2 to 4 weeks of ready backlog.

#### Net burn per week

**Key:** net_burn

**Expr:** capacity - inflow

**Format:** hours

**Description:** Positive means the backlog shrinks; negative means it grows.

#### Weeks to clear (0 if never)

**Key:** weeks_to_clear

**Expr:** if(gt(net_burn, 0), open_hours / net_burn, 0)

**Format:** decimal

**Primary:** true

**Description:** Zero means inflow is at or above capacity, so the backlog never clears at the current staffing.

#### Inflow as % of capacity

**Key:** utilisation

**Expr:** inflow / capacity * 100

**Format:** percent

**Chart:**

#### Backlog weeks vs crew size

**Type:** line

**X:** crew

**From:** 4

**To:** 40

**Steps:** 37

**Series:**

- backlog_weeks

**Disclaimer:** Planning aid. Use remaining work from your own order data; contractor hours and shutdown work should be excluded or modelled separately.

## Content

**Intro:** Backlog in weeks is the plain-language measure maintenance managers use to say whether the planned work queue is healthy. This calculator converts the open hours you pull from SAP PM into weeks of work and tells you whether your crew is gaining or losing ground.

**Sections:**

#### How to use it

**Body:** Export your open order list from IW38 (or a variant of IW37N) and sum the remaining work for orders that are planned and released. Enter that figure, the number of craft technicians, paid hours per week and your honest wrench time. Add the average weekly hours of new work coming in from IW21 notifications and maintenance plans. The result shows backlog weeks, net burn and the weeks needed to clear the queue.

**Bullets:**

- Exclude orders waiting for parts or shutdowns, or report them as a separate backlog.
- Use remaining work, not original planned work, so partly done orders are not double counted.
- Re-run monthly and compare to the trend, not a single number.

#### The formula behind it

**Body:** Productive capacity equals technicians times paid hours times wrench time. Backlog weeks equals open hours divided by that capacity. Net burn is capacity minus weekly inflow, and weeks to clear is open hours divided by net burn when it is positive. If inflow meets or exceeds capacity the backlog cannot clear, which is why the result shows zero rather than an infinite number. The chart sweeps crew size so you can see the point of diminishing return.

#### Reading the result and common mistakes

**Body:** A backlog below about one week often means too little planned work is staged, so technicians wait for jobs. Above roughly six to eight weeks, new requests age and priority work starts to jump the queue. The most common error is using paid hours as capacity, which ignores travel, permits, breaks and parts waits and understates the backlog by half.

**Bullets:**

- Do not mix emergency and planned hours in one backlog figure.
- Check that capacity in work centers (CR02) matches the headcount you enter here.
- Track ready backlog separately from total backlog.

**Cta:** If you want backlog weeks computed live from your SAP PM order data with the query shown, Netray can set that up on your own infrastructure.

**Faq:**

#### What is a good maintenance backlog in weeks?

**Answer:** Many reliability practitioners aim for roughly two to four weeks of ready, fully planned backlog. Less can leave technicians idle; much more means requests age and priorities blur. The right value depends on your mix of reactive and planned work.

#### Which SAP PM transaction gives open work hours?

**Answer:** IW38 lists orders with selection by status and planner group, and IW37N gives operation level work. Export the remaining work column to Excel and sum it. Use status filters to keep only released, planned orders.

#### Should I include preventive maintenance orders?

**Answer:** Yes, if they are released or due soon, because they consume the same crew capacity. Many sites report corrective and preventive backlog separately and then total them for the capacity check.

#### Why does the tool show zero weeks to clear?

**Answer:** Zero means weekly inflow is equal to or higher than your productive capacity, so the queue never shrinks. Add capacity, raise wrench time or reduce inflow through better preventive work.

## Search terms

maintenance backlog calculator, sap pm backlog weeks, maintenance backlog in weeks formula, sap pm open orders hours, backlog hours calculator, maintenance planner backlog report, ready backlog weeks, sap iw38 backlog

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