Direct Material Price Variance Calculator
From standard price, actual price and actual quantity, compute the material price variance (favourable or unfavourable).
Input Data
Results
At a glance:Price variance = (standard price - actual price) x actual quantity purchased. Positive = favourable (F, bought cheaper than standard); negative = unfavourable (U, paid more). It reflects the purchasing stage (negotiation, supplier, market price). WARNING: Covers only price variance, not usage variance; depends on a reasonable standard; F is not always good (could be lower quality), U not always buyer's fault (market rise). Interpret with context. Education, not advice.
Formula
Price variance = (standard price − actual price) × actual quantity.
Positive = favourable (bought cheaper); negative = unfavourable (paid more).
$$\text{Price Variance} = (\text{Std Price} - \text{Actual Price}) \times \text{Actual Qty}$$How to Use
- Enter the standard unit price.
- Enter the actual unit price and quantity purchased.
- View the price variance — positive is favourable, negative unfavourable.
FAQ
How do I tell favourable from unfavourable?
Under the formula (standard - actual) x quantity: positive = favourable (F), negative = unfavourable (U). Logic: when actual price < standard, you bought cheaper and saved — favourable; when actual > standard, you paid more — unfavourable. But 'favourable/unfavourable' is a pure cost-accounting term, not a value judgement of good/bad — a favourable may come from lower-quality material; an unfavourable may be a market price rise. Investigate the cause, don't just read the sign.
How is price variance different from usage variance?
They are the two parts of total direct-material variance, splitting cost deviation into 'bought dear or cheap' and 'used sparingly or wastefully'. Price variance (this tool) measures the unit-PRICE deviation x actual quantity — reflecting purchasing (negotiation, supplier, timing, market). Usage variance measures the QUANTITY deviation (actual vs standard usage) x standard price — reflecting production efficiency (waste, scrap, process). Splitting them lets you target the right department: price issues → purchasing; usage issues → production. This tool covers only price variance; usage needs separate calculation.
How should I set the standard price, and what if it is wrong?
The standard price is the benchmark; its reasonableness determines the variance's value. Set it from recent actual prices, contracted supplier prices, expected market trends/inflation, volume discounts, and freight — usually at annual budgeting and reviewed periodically. If set too low (over-optimistic), almost every period shows unfavourable variance, eroding the warning value; too high (loose) creates fake favourable variances hiding real problems. A reasonable, realistic, periodically updated standard is essential. Persistent one-sided variance is often a signal to revisit the standard.
Does a favourable variance mean the purchasing team did well?
Not necessarily — a key trap. 'Favourable' only means actual price < standard, lowering cost; it does NOT equal 'team performed well'. Reasons to investigate: (1) cheaper but lower-quality substitute material may raise later usage variance, returns or reputation damage — a 'pick up pennies, lose dollars' false saving; (2) market price simply fell, not the buyer's skill; (3) bulk-buy discounts causing overstocking, tying up cash. So see favourable variances alongside usage variance, quality, return rates and inventory — don't auto-reward. Likewise, unfavourable is not automatically blame. Variance analysis guides questions, not verdicts.
How do price and usage variance work together for full analysis?
Total direct-material variance = price variance + usage (quantity) variance; this tool computes only the price half. For full cost control you combine both, pointing to different responsibilities. Price variance (this): 'bought dear or cheap' = (standard price - actual price) x actual quantity, reflecting purchasing (negotiation, supplier, timing, market). Usage variance: 'used sparingly or wastefully' = (standard usage - actual usage) x standard price, reflecting production efficiency (waste, scrap, process, skill). Splitting lets you target the right fix: if overspend is mostly price variance, review sourcing strategy; if mostly usage, improve production/material management. A good standard-cost system tracks both. This tool focuses on price; usage needs the standard vs actual usage data separately.
Related Tools
References
Content review: Calculatorism Finance Team. Results are for reference only; please refer to the relevant authorities for the official figures.