Costing & FinanceFree calculatorPDF, Excel, Word exportProcess Manufacturing

Material Mix and Yield Variance Calculator

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.

Your numbers

Standard quantity of material A (per standard batch)

Standard recipe proportion for A.

Standard price of A

$/kg

Standard quantity of material B (per standard batch)

Standard price of B

$/kg

Standard yield (output / input)

Actual quantity of A used

Actual quantity of B used

Actual good output

Your results

Total material usage variance

$26

Standard input per standard batch

100

Standard cost per kg of input at standard mix

Actual total input

10,500

Standard input allowed for actual output

10,210.53

Mix variance (positive = unfavorable)

-$900

Yield variance (positive = unfavorable)

$926

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

Save results:

Yield and total usage variance vs actual good output

Sweeps Actual good output from 8500 to 11000, holding your other inputs fixed.

Batch variance reporting

Optional: discuss pulling actual consumption and yield from your ERP into a recurring variance view.

Optional. The tool and every export work without this. No spam.

How to use it

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

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.

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

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.

Frequently Asked Questions

When is a mix variance meaningful?

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?

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?

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?

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.

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

Talk to an Expert Explore More Free Tools

Related Tools

Costing & Finance

More Costing & Finance tools

See all

Back to All Tools