# SAP Costing Sheet Overhead Rate and Absorption Calculator

> Source: https://netray.co/tools/sap-costing-sheet-overhead-rate-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Compute a planned overhead rate, build a costing sheet from material and labor, and see how much overhead is under or over absorbed against actual cost.

## Category

sap

## Erp

SAP S/4HANA

## Audience

- SAP CO consultant
- Cost accountant
- Controller

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Direct material cost

**Key:** dm

**Type:** number

**Default:** 400000

**Min:** 0

**Step:** 1000

**Unit:** currency

#### Actual direct labor (allocation base)

**Key:** dl

**Type:** number

**Default:** 250000

**Min:** 0

**Step:** 1000

**Unit:** currency

**Help:** Actual quantity of the base the overhead is applied to.

#### Material overhead rate

**Key:** mat_pct

**Type:** number

**Default:** 6

**Min:** 0

**Step:** 0.5

**Unit:** %

#### Planned production overhead

**Key:** plan_pool

**Type:** number

**Default:** 210000

**Min:** 0

**Step:** 1000

**Unit:** currency

**Help:** Total planned cost to be absorbed, for example from cost center planning.

#### Planned labor base

**Key:** plan_base

**Type:** number

**Default:** 240000

**Min:** 1

**Step:** 1000

**Unit:** currency

#### Administrative overhead rate

**Key:** adm_pct

**Type:** number

**Default:** 8

**Min:** 0

**Step:** 0.5

**Unit:** % of cost of manufacture

#### Actual production overhead incurred

**Key:** actual_pool

**Type:** number

**Default:** 228000

**Min:** 0

**Step:** 1000

**Unit:** currency

**Outputs:**

#### Production overhead rate

**Key:** prod_rate

**Expr:** plan_pool / plan_base * 100

**Format:** percent

**Description:** Predetermined rate: planned overhead divided by planned base.

#### Material overhead

**Key:** mat_oh

**Expr:** dm * mat_pct / 100

**Format:** currency

#### Absorbed production overhead

**Key:** prod_oh

**Expr:** dl * prod_rate / 100

**Format:** currency

#### Cost of manufacture

**Key:** com

**Expr:** dm + dl + mat_oh + prod_oh

**Format:** currency

**Primary:** true

#### Administrative overhead

**Key:** adm

**Expr:** com * adm_pct / 100

**Format:** currency

#### Total cost of sales

**Key:** total

**Expr:** com + adm

**Format:** currency

#### Under (+) / over (-) absorbed overhead

**Key:** under

**Expr:** actual_pool - prod_oh

**Format:** currency

**Primary:** true

**Description:** Positive means actual overhead exceeded what was absorbed into products.

**Chart:**

#### Absorbed overhead and under absorption vs actual labor base

**Type:** line

**X:** dl

**From:** 50000

**To:** 500000

**Steps:** 30

**Series:**

- prod_oh
- under

**Disclaimer:** Simplified single-rate costing sheet. Real SAP costing sheets use credit keys, multiple bases, activity-based rates and surcharges by cost center or order type.

## Content

**Intro:** A costing sheet in SAP product costing and order costing applies overhead percentages to a base such as material or labor. This calculator lets you derive the production overhead rate from planned cost, build a simple cost of sales, and measure how much overhead is under or over absorbed once actual volume differs from plan.

**Sections:**

#### How to use it

**Body:** Start with the planned overhead pool and planned base from your cost center plan to get the predetermined rate. Then enter actual direct material and actual labor. The tool applies the material rate and the production rate, adds administrative overhead on cost of manufacture, and compares absorbed production overhead with the overhead actually posted. The chart changes the actual labor base so you can see how volume swings drive under or over absorption.

**Bullets:**

- Use planned values from the same version as your standard cost estimate
- Keep the base consistent: labor cost in plan and in actuals
- Treat the result as the variance you would expect on the cost center or order

#### The method

**Body:** The predetermined overhead rate is planned overhead divided by the planned allocation base. Absorbed overhead equals the actual base multiplied by that rate. Under absorption is actual overhead minus absorbed overhead: if you absorbed less than you spent, the difference remains as a debit in the ledger and appears as an overhead variance. In SAP the percentage and base are set in the costing sheet (rows with base and overhead keys), and the calculated credit goes to the cost center or order that carries the overhead.

#### Reading the result

**Body:** A modest positive under absorption is normal when volume falls below plan, because fixed overhead is spread over a smaller base. A large number suggests the planned rate is stale or that activity was posted on the wrong base. Negative figures mean you recovered more overhead than you spent, which flatters inventory value until the variance is settled at period end.

#### Common mistakes

**Body:** Using actual overhead in the numerator, which defeats the purpose of a predetermined rate. Mixing hours and currency bases. Forgetting administrative overhead is applied to cost of manufacture and not to material alone. Updating the plan rate mid-year without revaluing inventory, leaving a mismatch between old standard costs and the new rate.

**Cta:** If you want faster answers on overhead variances without opening five reports, Netray can set up a read-only question interface over your SAP controlling data. Talk to us about what you need to check.

**Faq:**

#### Is this the same as SAP activity type pricing?

**Answer:** No. Costing sheet overhead applies percentage surcharges to a base, while activity types price internal services per unit such as machine hour. Both feed product costing, but they use different configuration and different rate logic.

#### What is a good overhead rate?

**Answer:** There is no universal number. It depends on how much cost is in the pool compared with the base. Compare the rate across years and cost centers instead, and investigate sharp moves, since they usually reflect plan changes rather than efficiency.

#### How do I fix large under absorption?

**Answer:** Review the planned volume, remove costs that do not belong to the pool, or choose a base that tracks the driver better, such as machine hours instead of labor. Then re-plan and run the cost estimate again so standards reflect the new rate.

#### Does it handle multiple bases?

**Answer:** This version uses one material rate and one labor-based production rate. For several bases, run the calculation once per base and add the results, or build the logic into your costing sheet and test with a cost estimate.

## Search terms

sap costing sheet overhead calculator, overhead absorption rate calculator, sap overhead rate calculation, under absorbed overhead calculator, over absorbed overhead, sap product costing overhead, predetermined overhead rate, cost of goods manufactured calculator

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