# SAP Work Center Weekly Load Worksheet

> Source: https://netray.co/tools/sap-work-center-weekly-load-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

A weekly capacity versus load sheet per work center using the SAP available capacity logic, with utilization and free hours.

## Category

sap

## Erp

SAP S/4HANA

## Audience

- Production planner
- Scheduler
- SAP PP consultant

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Work center

**Key:** wc

**Type:** text

#### Individual capacities

**Key:** indcap

**Type:** number

#### Operating hours per day

**Key:** hours

**Type:** number

#### Working days in week

**Key:** days

**Type:** number

#### Utilization rate

**Key:** rate

**Type:** number

**Unit:** %

#### Available capacity (h)

**Key:** avail

**Type:** number

**Expr:** indcap * hours * days * rate / 100

**Format:** decimal

#### Load from orders (h)

**Key:** load

**Type:** number

#### Load percent

**Key:** util

**Type:** number

**Expr:** load / avail * 100

**Format:** percent

#### Free hours

**Key:** free

**Type:** number

**Expr:** avail - load

**Format:** decimal

**Rows:**

**Wc:** MILL-01

**Indcap:** 1

**Hours:** 16

**Days:** 5

**Rate:** 85

**Load:** 72

**Wc:** LATHE-02

**Indcap:** 2

**Hours:** 8

**Days:** 5

**Rate:** 90

**Load:** 81

**Wc:** ASSY-01

**Indcap:** 4

**Hours:** 8

**Days:** 5

**Rate:** 95

**Load:** 140

**Wc:** INSP-01

**Indcap:** 1

**Hours:** 8

**Days:** 5

**Rate:** 80

**Load:** 22

**Totals:**

#### Total available hours

**Key:** avail

**Agg:** sum

**Format:** decimal

#### Total load hours

**Key:** load

**Agg:** sum

**Format:** decimal

**Summary:**

#### Plant load percent

**Key:** plant_load

**Expr:** sum_load / sum_avail * 100

**Format:** percent

**Primary:** true

**Notes:** Available capacity in SAP is operating time times number of individual capacities times utilization rate. Loads above 100 percent mean overload that needs leveling, overtime or rerouting. Use CM01 or CM21 to see the real load by period.

## Content

**Intro:** Planners often rebuild a weekly capacity picture in Excel from CM01 exports. This worksheet applies the SAP available capacity formula and flags work centers that are overloaded or idle.

**Sections:**

#### How to use the sheet

**Body:** Enter each work center with its individual capacities, operating hours per day, working days and utilization rate from the work center capacity data. Paste weekly load hours from your capacity evaluation. The sheet returns available hours, load percent and free hours. Use it for the weekly production meeting and export it for the record.

#### The formula behind it

**Body:** SAP calculates available capacity as operating time multiplied by the capacity utilization rate and the number of individual capacities. Load comes from the operations of planned and production orders using the standard values in the routing. Load percent is load divided by available capacity. Above about 100 percent you have more work than time, assuming the standard values are right.

**Bullets:**

- Available = individual capacities x hours x days x rate
- Load percent = load / available
- Free hours show where to pull work in

#### Common mistakes

**Body:** Using the wrong utilization rate gives false comfort. Loading planned orders that will never be converted distorts the picture. Ignoring breaks and maintenance windows overstates availability. Check routing times against actual confirmations regularly.

**Cta:** Netray can pull live load and availability from SAP into a view that updates daily, without exporting by hand.

**Faq:**

#### What is the SAP transaction for capacity load?

**Answer:** CM01 shows the work center load, CM02 the capacity load per work center, and CM21 the capacity evaluation of work center. Names and layouts vary by release, so use whichever your team already trusts.

#### What utilization rate should I use?

**Answer:** Use the rate that reflects normal efficiency and downtime, often between 80 and 95 percent. It should come from actual data rather than a guess.

#### What does overload mean?

**Answer:** It means scheduled operations require more hours than available in the period. Fix it by leveling, adding shifts, outsourcing or moving dates.

#### Does this do finite scheduling?

**Answer:** No. It is a load check. Finite scheduling needs APS or planning board tools.

## Search terms

sap work center capacity excel, sap capacity load worksheet, weekly capacity load template, sap cm01 capacity load excel, work center utilization template, sap available capacity calculation, capacity leveling spreadsheet

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