Accounting & Financial Statement Analysis Budgeting & Variance Analysis Standard costing, two-variance materials model

Direct Material Price & Quantity Variance Calculator

Enter the price you actually paid, your standard price, the quantity you actually consumed and the output it produced, and this calculator splits the total direct materials variance into the two halves a cost accountant has to report: the price variance from paying something other than standard, and the quantity or usage variance from consuming more material than the standard cost card allows for the units you finished. You get the full three-column standard-costing layout, favorable and unfavorable labels on each component, and the total scaled against standard material cost so you can see whether it clears an investigation threshold.

Calculator

This calculator runs in your browser. Enable JavaScript for live results — the inputs, formula and worked example below remain fully readable without it.

Inputs this calculator takes, with typical values
InputWhat to enterExample
Actual price paid per unit of materialInvoice cost delivered, net of trade discounts, divided by the quantity received.5.2 $
Standard price per unit of materialThe price on your standard cost card for this material, on the same delivered basis as the actual.5.0 $
Actual quantity used in productionMaterial issued to production and consumed in the period, from the stores requisitions or the backflush.10500
Standard quantity allowed per finished unitThe bill-of-materials quantity for one good unit, including any allowance your standard makes for normal waste.5
Actual units of good output producedGood units completed in the period, not units started, not units sold, and not the budgeted quantity.2000 units
Unit of measure for the materialLabels the quantities in the working; enter the quantity and the price in the same unit so the unit cancels.pounds (lb)
Strike the price variance onChoose purchased if you value raw-materials inventory at standard price and recognise the price variance at receipt.Quantity used (purchases equal usage)
Actual quantity purchasedQuantity received in the period, which is the base for the price variance when inventory is carried at standard.11000

It returns

  • Total direct material variance — Price variance plus quantity variance. Positive is unfavorable: material cost more than the standard allowed.
  • Material price variance
  • Material quantity (usage) variance
  • Standard quantity allowed for actual output — Standard quantity per unit times the good units you actually produced, in your unit of measure.
  • Actual material used per unit — Compare this directly against the standard quantity per unit to see the yield loss in physical terms.
  • Standard material cost of actual output
  • Actual cost of material used
  • Total variance vs standard material cost

The formula

MPV=(APSP)AQMQV=(AQusedSQ)SP
SQ=qstdQactual
Vtotal=AQusedAPSQSP

In plain text: MPV = (AP − SP) × AQ ; MQV = (AQᵤ − SQ) × SP ; Total = MPV + MQV

  • APActual price paid per unit of material ($)
  • SPStandard price per unit of material ($)
  • AQActual quantity the price variance is struck on: purchased, or used where they are equal (material units)
  • AQᵤActual quantity consumed in production (material units)
  • SQStandard quantity allowed for the output actually produced (material units)
  • MPVMaterial price variance; positive is unfavorable ($)
  • MQVMaterial quantity or usage variance; positive is unfavorable ($)

SQ = standard quantity per unit × actual good output, never budgeted output. A positive variance is unfavorable because the convention throughout standard costing is actual cost minus standard cost.

Updated Category Budgeting & Variance Analysis Verified against published test cases Reading time 13 min

What the direct material variance separates

The total direct material variance is one number: what your material actually cost minus what the output you produced should have cost. As a management report it is nearly worthless, because two different people control the two forces inside it. Purchasing decides what a pound costs; the production floor decides how many pounds a unit takes.

Standard costing splits the total into exactly those two pieces. The material price variance isolates the price of the input; the material quantity variance, also called the usage variance, isolates how much of it got consumed. Once split, each half has a named owner and a short list of plausible causes, and the two always add back to the total with nothing left over.

The sign convention runs the same way as every other cost variance: actual minus standard, so positive is unfavorable. Variance reports quote the magnitude followed by a letter, as in “$2,100 U”, and this calculator gives you both. The revenue-side variances run the other way round, which is why the sales price and volume variance calculator treats a positive number as favorable.

The two formulas, and why one uses actual quantity and the other uses standard price

The price variance takes the gap between what you paid and what your standard says and multiplies it by the whole quantity that gap applied to: MPV = (APSP) × AQ. The overpayment landed on every pound that came through the door, including the ones later wasted, so actual quantity is the right multiplier.

The quantity variance takes the gap between what you consumed and what the output earned, valued at the standard price: MQV = (AQSQ) × SP. Using the standard price is deliberate. Value the excess pounds at the actual price and you charge the supervisor for a purchasing decision they did not make, and the two variances start double-counting the overlap between the price gap and the quantity gap.

Everything hinges on SQ, the standard quantity allowed, and this is where most people go wrong. SQ = standard quantity per unit × the good units you actually finished. Not budgeted output, not units started, not units shipped. Because it flexes to real output, a volume shortfall can never contaminate the usage variance.

The structure is easiest to see in the three-column layout this calculator prints:

  • (1) AQ × AP — what the material actually cost.
  • (2) AQ × SP — the hybrid column: your quantity, standard price.
  • (3) SQ × SP — what the output should have cost.

Price variance is (1) − (2), quantity variance is (2) − (3), total is (1) − (3). Column (2) is the bridge that makes the split possible, and that fact alone explains why one formula carries actual quantity and the other carries standard price. One refinement: if you hold raw materials at standard price, strike the price variance on the quantity purchased at receipt, which is what the advanced option here does. Purchasing then gets its answer in the month it bought, but the two variances stop reconciling to usage cost minus standard cost, because part of the price variance sits in unissued stock.

Worked example: 10,500 lb at $5.20 against a $5.00 standard

A plant finishes 2,000 units in March. The standard cost card allows 5.00 lb of resin per unit at $5.00 per pound. Stores issued 10,500 lb, and the invoices show a delivered cost of $5.20 per pound because the contract renewed at a higher price.

  1. Standard quantity allowed. 5.00 lb per unit × 2,000 units = 10,000 lb.
  2. Column (1), actual cost. 10,500 lb × $5.20 = $54,600.
  3. Column (2), actual quantity at standard price. 10,500 lb × $5.00 = $52,500.
  4. Column (3), standard cost of output. 10,000 lb × $5.00 = $50,000.
  5. Price variance. ($5.20 − $5.00) × 10,500 lb = $0.20 × 10,500 = $2,100 unfavorable. Same as (1) − (2) = $54,600 − $52,500.
  6. Quantity variance. (10,500 lb − 10,000 lb) × $5.00 = 500 × $5.00 = $2,500 unfavorable. Same as (2) − (3) = $52,500 − $50,000.
  7. Total. $2,100 U + $2,500 U = $4,600 unfavorable, which equals (1) − (3) = $54,600 − $50,000.
  8. Scale it. $4,600 ÷ $50,000 = 9.2% of standard material cost — well past a 5% investigation threshold.
  9. Convert to physical terms. 10,500 lb ÷ 2,000 units = 5.25 lb per unit against a 5.00 lb standard, so yield loss is 5%.

Read the two halves separately and you get two different conversations. The $2,100 is a market story: the contract reprice is a fact, and the only decisions left are whether to hedge, resource or reset the standard. The $2,500 is a floor story worth 0.25 lb per unit, and it is the more urgent, because 5% yield loss on every unit compounds until someone fixes it. Note too that valuing those 500 excess pounds at the $5.20 actually paid rather than the $5.00 standard would have overstated the floor variance by $100 and stopped the two variances adding to the total.

How to read the result: ownership, causes and size

Assign each half to whoever controls it before you interpret anything. The price variance belongs to purchasing, subject to two honest defences: a market move nobody could avoid, and a rush order forced on them by a late production schedule. The quantity variance belongs to the floor, subject to the same kind of defence — off-specification material, a worn tool or an unusually short run all show up as usage loss while being nobody on the line's fault.

Read the pair together, because they trade against each other constantly:

  • Favorable price with unfavorable usage is the signature of buying cheaper, lower-grade material. If the extra scrap is worth more than the discount, the saving destroyed value. This calculator flags the combination when it appears.
  • Unfavorable price with favorable usage usually means you paid up for better material or a smaller lot and got the yield back — often a good trade, and worth stating as one.
  • Both unfavorable points at a stale standard as often as at bad performance.

On size, the usual desk rule is to investigate a total past roughly 5% of standard material cost together with a dollar floor that matters at your scale — the same two-part materiality test used in ordinary budget versus actual variance analysis. Tune it to the process: a continuous chemical line running a tight recipe should sit very close to its standard, so a narrow usage variance is already a signal, while a shop cutting parts out of sheet stock has unavoidable offcuts and needs a wider band before anything is wrong.

Always convert the usage variance back into physical terms before you present it. “$2,500 unfavorable” invites an argument about accounting. “5.25 lb per unit against a 5.00 lb standard” invites an argument about the process, which is the one you want.

All four sign combinations, worked out

Every row assumes 10,000 lb allowed at a $5.00 standard price, so the standard material cost of output is $50,000 throughout. Price variance is column (1) minus column (2); quantity variance is (2) minus (3).
Actual(1) AQ × AP(2) AQ × SP(3) SQ × SPPrice varianceQuantity varianceTotal
10,500 lb at $5.20$54,600$52,500$50,000$2,100 U$2,500 U$4,600 U
10,500 lb at $4.75$49,875$52,500$50,000$2,625 F$2,500 U$125 F
9,600 lb at $5.20$49,920$48,000$50,000$1,920 U$2,000 F$80 F
9,600 lb at $4.75$45,600$48,000$50,000$2,400 F$2,000 F$4,400 F

Row two is the trap: a $2,625 favorable price variance nets down to $125 favorable once the extra 500 lb of usage is counted, so almost the whole discount was consumed by waste.

What each percent of yield loss costs a year

A product with a 5.00 lb standard at $5.00 per pound, so standard material cost is $25.00 per unit, made 24,000 times a year. The annual column is the quantity variance the yield loss produces over twelve months.
Actual usage per unitVersus standardQuantity variance per unitAnnual variance at 24,000 units
4.90 lb2% under$0.50 favorable$12,000 favorable
5.00 lbon standard$0.00$0
5.05 lb1% over$0.25 unfavorable$6,000 unfavorable
5.10 lb2% over$0.50 unfavorable$12,000 unfavorable
5.25 lb5% over$1.25 unfavorable$30,000 unfavorable
5.50 lb10% over$2.50 unfavorable$60,000 unfavorable
6.00 lb20% over$5.00 unfavorable$120,000 unfavorable

Scale it to your own product by multiplying the percent of yield loss by your standard material cost per unit and by annual volume. The arithmetic is why a one-percent yield project usually pays for itself.

Mistakes that corrupt a material variance

  • Using budgeted output instead of actual output for the standard quantity. The commonest error of all. It drags a volume shortfall into the usage variance and makes the floor answer for a sales miss.
  • Valuing the usage variance at the actual price. The two variances then overlap, stop adding to the total, and charge the supervisor for a purchasing decision.
  • Mixing quantity purchased and quantity used without saying which. Both bases are defensible; using one in the formula and the other in the commentary is not.
  • Comparing quantities in different units of measure. A bill of materials in kilograms against issues in pounds produces a 120% usage variance and a wasted afternoon.
  • Setting the standard at theoretical yield. With no allowance for normal, unavoidable scrap, every period shows an unfavorable usage variance nobody can remove, which teaches people to ignore the report.
  • Counting issues and output over different periods. Material issued on the last day of the month against units finished next month guarantees a fictitious usage variance that reverses.
  • Reporting only the net total. The $125 favorable in the reference table above hides $2,625 of price movement and $2,500 of waste.

Standard costs and the accounting rules

US GAAP permits standard costs for inventory measurement provided they reasonably approximate cost, which is why material variances cannot simply be dumped into cost of goods sold. At period end, immaterial variances are normally written off to cost of sales while material ones are prorated between inventory and cost of sales, so the carrying amount still approximates actual cost. IFRS takes the same line in IAS 2, permitting standard cost where it approximates cost and requiring that standards be reviewed regularly. Abnormal amounts of wasted material are excluded from inventory cost under both frameworks and expensed as incurred. Once your variances are large enough to matter, their treatment at close is an audit question rather than a reporting preference.

The material split is one quarter of a full standard-cost analysis, and every part uses the same three-column skeleton. Labour swaps price for wage rate and quantity for hours in the direct labor rate and efficiency variance calculator. The revenue side swaps them for selling price and units sold. Overhead needs a third structure because part of it is fixed, and its variable half usually runs off the same labour-hour base as your predetermined overhead rate.

Where the variance goes next depends on why you are looking at it. To explain a gross margin miss it is one line of the bridge, and the cost of goods sold calculator plus the gross profit margin calculator supply the rest. To judge whether a permanent price rise can be absorbed, material is part of variable cost per unit, so it flows into the contribution margin calculator and from there into break-even volume. Where the price movement is large and stock turns slowly, check how much of the increase still sits in inventory rather than in cost of sales with the FIFO inventory valuation calculator.

Be clear about what a material variance cannot see. It measures cost against a standard, not value: a crew that hits standard usage by loosening an inspection step produces a clean usage variance and a warranty cost two quarters later. Review it beside the scrap report, never on its own.

Key terms

Standard quantity allowed
Standard quantity per unit multiplied by actual good output. The flexible-budget benchmark the production floor is measured against.
Material price variance
The price gap times actual quantity. Also called the purchase price variance. Owned by purchasing, and struck at receipt where inventory is held at standard.
Material quantity variance
The quantity gap valued at the standard price. Also called the usage variance or, where a formula has several inputs, decomposed further into mix and yield variances.
Normal versus abnormal waste
Normal waste is built into the standard quantity and carried in inventory cost. Abnormal waste is excluded from inventory and expensed in the period it occurs.

Frequently asked questions

Do I use quantity purchased or quantity used in the price variance?

Use quantity purchased if you carry raw materials at standard price, and quantity used if you do not. Holding inventory at standard means the price difference is recognised the moment goods are received, which gets the variance to the buyer in the month they bought. The trade-off is that the two variances then no longer add back to actual usage cost minus standard cost, because part of the price variance relates to material still in stock. This calculator handles either basis and reports the size of that gap.

Why is the quantity variance valued at the standard price rather than what I actually paid?

To stop the two variances overlapping. The price gap has already been charged against every unit of material in the price variance; valuing the excess quantity at the actual price would count that gap twice on the excess, and the two components would no longer sum to the total. Holding price at standard also keeps the production supervisor's variance free of a purchasing decision they had no part in.

Is a favorable material price variance good news?

Not on its own. The easiest way to manufacture a favorable price variance is to buy a cheaper grade, buy in bulk you do not need, or accept off-specification stock, and all three tend to reappear as an unfavorable usage variance, extra rework, or inventory you have to write down later. Compare the two amounts before you judge: in the reference table above a $2,625 favorable price variance nets to just $125 favorable once 500 lb of extra waste is counted.

How do mix and yield variances relate to the quantity variance?

They are a further split of it, used where several materials are interchangeable in a formulation. The mix variance measures the cost of using a different blend of inputs than the standard recipe; the yield variance measures the cost of getting less total output from the same total input. Add them together and you get exactly the quantity variance this calculator reports. Compute the two-variance split first: if the quantity variance is small, decomposing it further buys you nothing.

How large does a material variance have to be before I investigate?

A common desk rule is roughly 5% of the standard material cost of output plus a dollar floor that matters at your scale, and this calculator flags that threshold. Tune it to the process: a continuous chemical line with a tight recipe should sit very close to its standard, so even a narrow variance is a real signal, while a fabrication shop cutting parts out of sheet has unavoidable offcuts and needs a wider band. Consistency month to month matters more than the exact number.

Where do the variances go in the accounts at month end?

They arise as the offset when purchases and issues are recorded against inventory and work in process at standard, and they must be cleared before you close. Immaterial variances are normally written off to cost of goods sold. Material ones are prorated between inventory and cost of sales so the carrying amount still approximates actual cost, which is the condition on which standard costing is acceptable for inventory measurement. Abnormal waste is expensed as incurred rather than capitalised.

Can I use this outside manufacturing?

Yes, anywhere a job consumes a measurable input against a documented estimate. A restaurant can compare plate cost against a recipe card, a print shop can compare stock consumed against the imposition, and a construction crew can compare material drawn against the take-off. Substitute your estimate for the standard cost card, the units delivered for good output, and the arithmetic is unchanged: price variance for what the input cost, usage variance for how much of it the job absorbed.

References

  • Cost Accounting: A Managerial Emphasis — Pearson (Horngren, Datar & Rajan)
  • Managerial Accounting — McGraw-Hill (Garrison, Noreen & Brewer)
  • Principles of Cost Accounting — Cengage (Vanderbeck & Mitchell)
  • ASC 330, Inventory — Financial Accounting Standards Board
  • IAS 2, Inventories — IFRS Foundation