# Material Mix and Yield Variance Calculator

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

## Short answer

Decomposes total material usage variance into a mix variance (different proportions than standard) and a yield variance (more input per unit of output).

## Category

cost-finance

## Industry

Process Manufacturing

## Audience

- Cost accountant
- Controller
- Process engineer

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Standard quantity of material A (per standard batch)

**Key:** std_a

**Type:** number

**Default:** 60

**Min:** 0

**Step:** 1

**Unit:** kg

**Help:** Standard recipe proportion for A.

#### Standard price of A

**Key:** pa

**Type:** number

**Default:** 2

**Min:** 0

**Step:** 0.05

**Unit:** $/kg

#### Standard quantity of material B (per standard batch)

**Key:** std_b

**Type:** number

**Default:** 40

**Min:** 0

**Step:** 1

**Unit:** kg

#### Standard price of B

**Key:** pb

**Type:** number

**Default:** 5

**Min:** 0

**Step:** 0.05

**Unit:** $/kg

#### Standard yield (output / input)

**Key:** yield

**Type:** number

**Default:** 95

**Min:** 1

**Max:** 100

**Step:** 0.5

**Unit:** %

#### Actual quantity of A used

**Key:** act_a

**Type:** number

**Default:** 6600

**Min:** 0

**Step:** 50

**Unit:** kg

#### Actual quantity of B used

**Key:** act_b

**Type:** number

**Default:** 3900

**Min:** 0

**Step:** 50

**Unit:** kg

#### Actual good output

**Key:** act_out

**Type:** number

**Default:** 9700

**Min:** 0

**Step:** 50

**Unit:** kg

**Outputs:**

#### Standard input per standard batch

**Key:** std_total

**Expr:** std_a + std_b

**Format:** decimal

#### Standard cost per kg of input at standard mix

**Key:** stdavg

**Expr:** (std_a * pa + std_b * pb) / std_total

**Format:** currency

#### Actual total input

**Key:** tot_in

**Expr:** act_a + act_b

**Format:** number

#### Standard input allowed for actual output

**Key:** allowed

**Expr:** act_out / (yield / 100)

**Format:** number

#### Mix variance (positive = unfavorable)

**Key:** mix_var

**Expr:** (act_a - tot_in * std_a / std_total) * pa + (act_b - tot_in * std_b / std_total) * pb

**Format:** currency

#### Yield variance (positive = unfavorable)

**Key:** yield_var

**Expr:** (tot_in - allowed) * stdavg

**Format:** currency

#### Total material usage variance

**Key:** usage_var

**Expr:** mix_var + yield_var

**Format:** currency

**Primary:** true

**Chart:**

#### Yield and total usage variance vs actual good output

**Type:** line

**X:** act_out

**From:** 8500

**To:** 11000

**Steps:** 25

**Series:**

- yield_var
- usage_var

**Disclaimer:** Covers two materials and one process step. Price variances are excluded and should be analyzed separately at purchase.

## Content

**Intro:** When a recipe uses more than one input, a simple usage variance hides two different problems: using the wrong proportions and getting less output from the input. This calculator separates them so production and purchasing know where to look.

**Sections:**

#### How to use it

**Body:** Enter the standard recipe quantities and standard prices for materials A and B, the standard yield, and what was actually consumed and produced in the period. The tool computes the cost per kilogram at standard mix, the input that should have been used for the actual good output, and the resulting mix, yield and total usage variances at standard prices. Use consistent units across materials.

#### The method behind it

**Body:** Mix variance compares actual quantities to total actual input redistributed at the standard proportions, valued at standard prices. Yield variance compares total actual input to the standard input allowed, valued at the standard average cost.

**Bullets:**

- Mix = sum over materials of (actual qty - total actual input x standard share) x standard price.
- Yield = (total actual input - standard input allowed) x standard average cost per unit of input.
- Standard input allowed = actual good output / standard yield.
- Mix + yield = actual input at standard prices - standard cost allowed.

#### Reading results and common mistakes

**Body:** A favorable mix with an unfavorable yield often signals substitution of a cheaper input that hurts conversion, so check whether quality or scrap rose. An unfavorable mix with a favorable yield may be deliberate, for example adding more of a costly active ingredient. Do not mix price effects into this view and do not apply it to products where inputs cannot be substituted, since mix then has no meaning and only the yield variance matters.

**Cta:** We can wire this variance split to your batch or production order consumption records so it appears with each period close.

**Faq:**

#### When is a mix variance meaningful?

**Answer:** Only when inputs can be substituted within limits, as in alloys, blends, plastics compounds, chemicals and food recipes. For fixed bill of material assemblies, material usage is analyzed as quantity variance per component.

#### Why value everything at standard prices?

**Answer:** To isolate quantity effects from purchase price effects. Price variance is computed separately when material is received or invoiced, which keeps responsibility clear between production and purchasing.

#### Can yield variance be negative?

**Answer:** Yes. A negative result is favorable: you used less input than the standard allowed for the output achieved, perhaps due to a process improvement or an overstated standard yield.

#### What if I have three or more materials?

**Answer:** The same formulas extend by adding one term per material to the mix variance. This page keeps to two materials so the arithmetic stays visible and checkable.

## Search terms

material mix variance calculator, material yield variance formula, direct material usage variance split, standard mix and yield variance, blend cost variance analysis, mix variance vs yield variance, process costing variance calculator

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