# SAP Standard Cost Variance Calculator: Price, Usage, Rate and Efficiency

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

## Short answer

Split a production variance into material price, material usage, labor rate and labor efficiency using the standard formulas.

## Category

sap

## Erp

SAP ECC and S/4HANA

## Audience

- Cost accountant
- SAP FICO consultant
- Controller

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Units produced

**Key:** units

**Type:** number

**Default:** 1000

**Min:** 1

**Step:** 50

**Unit:** units

**Help:** Good output for the period or order.

#### Standard material per unit

**Key:** std_mat_qty

**Type:** number

**Default:** 2.5

**Min:** 0

**Step:** 0.1

**Unit:** kg

**Help:** BOM quantity including planned scrap.

#### Standard material price

**Key:** std_mat_price

**Type:** number

**Default:** 12.4

**Min:** 0

**Step:** 0.05

**Unit:** per kg

**Help:** Price in the standard cost estimate.

#### Actual material consumed

**Key:** act_mat_qty

**Type:** number

**Default:** 2650

**Min:** 0

**Step:** 10

**Unit:** kg

**Help:** Total goods issued to the order.

#### Actual material price

**Key:** act_mat_price

**Type:** number

**Default:** 12.85

**Min:** 0

**Step:** 0.05

**Unit:** per kg

**Help:** Actual invoice or moving price.

#### Standard hours per unit

**Key:** std_hours

**Type:** number

**Default:** 0.75

**Min:** 0

**Step:** 0.05

**Unit:** hours

**Help:** Routing time per unit.

#### Actual hours booked

**Key:** act_hours

**Type:** number

**Default:** 790

**Min:** 0

**Step:** 5

**Unit:** hours

**Help:** Confirmed from the order.

#### Standard activity rate

**Key:** std_rate

**Type:** number

**Default:** 38

**Min:** 0

**Step:** 0.5

**Unit:** per hour

**Help:** Activity type price used in the estimate.

#### Actual activity rate

**Key:** act_rate

**Type:** number

**Default:** 39.5

**Min:** 0

**Step:** 0.5

**Unit:** per hour

**Help:** Actual rate after the period is closed.

**Outputs:**

#### Material price variance

**Key:** ppv

**Expr:** (act_mat_price - std_mat_price) * act_mat_qty

**Format:** currency

**Description:** Positive is unfavorable (paid more than standard).

#### Material usage variance

**Key:** muv

**Expr:** (act_mat_qty - std_mat_qty * units) * std_mat_price

**Format:** currency

**Description:** Extra quantity valued at the standard price.

#### Labor rate variance

**Key:** lrv

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

**Format:** currency

#### Labor efficiency variance

**Key:** lev

**Expr:** (act_hours - std_hours * units) * std_rate

**Format:** currency

#### Total variance

**Key:** total

**Expr:** ppv + muv + lrv + lev

**Format:** currency

**Primary:** true

**Description:** Positive means actual cost exceeded the standard.

#### Standard cost of output

**Key:** std_cost

**Expr:** units * (std_mat_qty * std_mat_price + std_hours * std_rate)

**Format:** currency

#### Variance as percent of standard

**Key:** pct

**Expr:** total / std_cost * 100

**Format:** percent

**Primary:** true

**Chart:**

#### Variance vs actual material price

**Type:** line

**X:** act_mat_price

**From:** 11

**To:** 14.5

**Steps:** 15

**Series:**

- ppv
- total

**Disclaimer:** Simplified two-way split per cost component. SAP production order variance categories (input price, input quantity, resource usage, scrap, lot size, remaining) use their own rules, so figures here are a cross-check, not a replacement for KKS2.

## Content

**Intro:** A production order variance is only useful when you can say why it happened. This calculator splits the difference between standard and actual into price and quantity effects for material and for labor, so you can see which one deserves attention before running variance calculation in SAP.

**Sections:**

#### How to use it

**Body:** Enter the units produced, the standard quantity and price from the cost estimate (CK11N), and the actuals from the production order. Material price variance is actual price minus standard price, times actual quantity. Usage variance is actual quantity minus allowed quantity, times standard price. Labor works the same way with rate and hours. Positive figures are unfavorable. The chart sweeps the actual material price so you can see how sensitive the order is.

#### How it maps to SAP

**Body:** In SAP, KKS1 and KKS2 calculate variances on an order and classify them into categories. Input price variance corresponds to the price effect here, input quantity variance to usage and efficiency. Scrap, lot size and remaining variance are SAP categories that arise from planned scrap in the estimate, quantity structure differences and everything not otherwise assigned. A material ledger with actual costing changes how price differences are posted, because they flow into the inventory and consumption at period close.

#### Worked example

**Body:** With the defaults, 1,000 units should use 2,500 kg at 12.40, but 2,650 kg were used at 12.85. Price variance is 0.45 times 2,650, or about 1,193. Usage variance is 150 kg times 12.40, or 1,860. Labor is 40 hours over standard at 38 and 1.50 above standard rate across 790 hours. The total is about 9.7 percent of the standard cost, which is large enough to investigate.

#### Common mistakes

**Body:** Valuing the usage variance at the actual price, which double counts price. Mixing planned scrap into the standard quantity in one place and not the other. Comparing a period total to a single order standard. Ignoring that a favorable price variance from a cheap supplier may bring quality issues that show up as scrap.

**Cta:** If you want variance drivers pulled from your own production orders without exporting to Excel, Netray can build a read-only analysis over your SAP data.

**Faq:**

#### What does a positive variance mean here?

**Answer:** A positive figure means actual cost was higher than standard, which is unfavorable. A negative figure means you spent less than the standard allowed. Some reports flip the sign convention, so check which one your SAP report uses.

#### Why does my SAP variance differ from this result?

**Answer:** SAP splits variances into more categories, applies lot size and scrap rules from the cost estimate, and may use moving average or actual costing prices. This tool uses a classic two-way split, so small differences are normal.

#### Which price do I enter for the actual material price?

**Answer:** Use the price at which the material was actually valued at goods issue, or the invoice price if you track purchase price variance separately. In SAP with standard price control, price differences are posted at invoice receipt.

#### Can I use this for a service or process industry order?

**Answer:** Yes, as long as you can state a standard quantity and price per unit of output. For co-products or joint costs you will need to apportion the standard first.

## Search terms

standard cost variance calculator, sap production order variance calculation, material price variance formula, sap input quantity variance, labor efficiency variance calculator, sap cost estimate variance, standard costing variance analysis, ppv purchase price variance sap

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