# SAP Production Order Variance Calculator (Price, Usage, Rate, Efficiency)

> Source: https://netray.co/tools/sap-pp-production-order-variance-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Break the difference between target and actual production order cost into price, usage, rate and efficiency variances.

## Category

sap

## Erp

SAP S/4HANA

## Audience

- SAP PP consultant
- Cost accountant
- Plant controller

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Quantity produced

**Key:** qty

**Type:** number

**Default:** 500

**Min:** 1

**Step:** 10

**Unit:** units

#### Standard material quantity per unit

**Key:** std_mat

**Type:** number

**Default:** 2.4

**Min:** 0

**Step:** 0.1

**Unit:** kg

#### Standard material price

**Key:** std_price

**Type:** number

**Default:** 6.5

**Min:** 0

**Step:** 0.1

**Unit:** currency per kg

#### Actual material consumed

**Key:** act_mat

**Type:** number

**Default:** 1260

**Min:** 0

**Step:** 10

**Unit:** kg

#### Actual material price

**Key:** act_price

**Type:** number

**Default:** 6.9

**Min:** 0

**Step:** 0.1

**Unit:** currency per kg

#### Standard hours per unit

**Key:** std_hrs

**Type:** number

**Default:** 0.08

**Min:** 0

**Step:** 0.01

**Unit:** hours

#### Standard activity rate

**Key:** std_rate

**Type:** number

**Default:** 55

**Min:** 0

**Step:** 1

**Unit:** currency per hour

#### Actual hours confirmed

**Key:** act_hrs

**Type:** number

**Default:** 44

**Min:** 0

**Step:** 1

**Unit:** hours

#### Actual activity rate

**Key:** act_rate

**Type:** number

**Default:** 58

**Min:** 0

**Step:** 1

**Unit:** currency per hour

**Outputs:**

#### Target material quantity

**Key:** tgt_mat_qty

**Expr:** qty * std_mat

**Format:** number

#### Target (standard) hours

**Key:** tgt_hrs

**Expr:** qty * std_hrs

**Format:** hours

#### Target cost

**Key:** tgt_cost

**Expr:** tgt_mat_qty * std_price + tgt_hrs * std_rate

**Format:** currency

**Description:** Standard cost of the quantity produced.

#### Actual cost

**Key:** act_cost

**Expr:** act_mat * act_price + act_hrs * act_rate

**Format:** currency

#### Material usage variance

**Key:** usage_var

**Expr:** (act_mat - tgt_mat_qty) * std_price

**Format:** currency

**Description:** Positive means more material than standard (unfavorable).

#### Material price variance

**Key:** price_var

**Expr:** (act_price - std_price) * act_mat

**Format:** currency

#### Labor efficiency variance

**Key:** eff_var

**Expr:** (act_hrs - tgt_hrs) * std_rate

**Format:** currency

#### Labor rate variance

**Key:** rate_var

**Expr:** (act_rate - std_rate) * act_hrs

**Format:** currency

#### Total variance (actual minus target)

**Key:** total_var

**Expr:** usage_var + price_var + eff_var + rate_var

**Format:** currency

**Primary:** true

**Description:** Equals actual cost minus target cost. Positive is unfavorable.

**Chart:**

#### Total variance vs actual hours

**Type:** line

**X:** act_hrs

**From:** 10

**To:** 100

**Steps:** 30

**Series:**

- total_var

**Disclaimer:** Textbook variance decomposition to help interpret results. SAP variance categories (input, resource usage, scrap, lot size, output price) are set up in customizing and may group these differently.

## Content

**Intro:** At period end, SAP calculates production order variances (CO88 or KKS1) and posts them. Understanding what drove the number is another matter. This calculator splits the total into price and quantity effects for material and for activity, which is the usual first question from a controller.

**Sections:**

#### How to use this calculator

**Body:** Enter the quantity produced and the standard material and hours per unit, with their standard price and rate. Then enter the actual material consumed, actual price, actual hours and actual rate, which you can read from the production order cost analysis (CO03 or COOIS, cost view). The output shows target cost, actual cost and the four variances. A positive variance means actual cost was higher than target.

**Bullets:**

- Target cost is based on quantity produced, not on planned order quantity.
- Check that actual hours come from confirmations, not from a plan value.

#### The formulas

**Body:** Material usage variance equals (actual quantity minus standard quantity for actual output) times standard price. Material price variance equals (actual price minus standard price) times actual quantity. Labor efficiency variance equals (actual hours minus standard hours for actual output) times standard rate. Labor rate variance equals (actual rate minus standard rate) times actual hours. The four add to total variance exactly, which is a useful check.

#### Reading the result in SAP terms

**Body:** In SAP, price effects usually show up on purchase price variance accounts at goods receipt for standard price materials, so the production order may see only the usage side. Activity rate variance can come from the cost center side, not the order. The order variance categories in SAP include input price, input quantity, resource usage, lot size, remaining variance and output price variance, determined by the variance key and target cost version. Use this calculator as the conceptual split and CKM3 or the order cost report for the posted facts.

**Bullets:**

- Large usage variances often point to BOM quantity errors or unrecorded scrap.
- Large efficiency variances point to routing standard values that no longer match the floor.

#### Common mistakes

**Body:** Mixing units (kilograms in the BOM, tonnes in confirmations) creates apparent variances. Another is judging variance on tiny orders where setup dominates. Also, a favorable total can hide offsetting unfavorable components, so always look at all four.

**Cta:** Netray can read production order cost and confirmation data from SAP and answer questions like which orders drove usage variance last period, read-only and with the query visible.

**Faq:**

#### Which SAP transaction calculates production order variances?

**Answer:** CO88 calculates variances for a collective set of orders and KKS1 for individual orders in the period. The variance key on the order controls which categories are determined.

#### Is positive variance good or bad here?

**Answer:** In this calculator, positive means actual cost is higher than target, so it is unfavorable. SAP shows debits and credits on the order, so sign conventions in reports may differ.

#### Why is there no price variance on my production order?

**Answer:** With standard price control, purchase price differences are usually posted at goods receipt to a price difference account, so they do not reach the order. Moving average price materials do carry price effects into the order.

#### What causes labor rate variance?

**Answer:** A difference between the planned activity price on the cost center and the actual activity price after assessment or actual price calculation, or from mixing work centers with different rates.

## Search terms

sap production order variance, sap material usage variance, sap price variance production order, sap co88 variance calculation, labor efficiency variance calculator, sap ckm3 variance, production order target cost actual cost, standard costing variance analysis

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