Materials calculator

Material Price Variance Calculator

Material Price Variance (MPV) measures the dollar difference between what you planned to pay for a material and what you actually paid, isolated from any change in usage volume. Purchasing managers, cost accountants, and plant controllers use it to hold suppliers and buyers accountable for price movement on resins, corrugate, steel, films, and other bought-in materials. An unfavorable MPV signals price creep, an expired contract, or a rush buy at spot, while a favorable one may reflect a negotiated win or a lower-grade substitution. Because it strips out quantity effects, MPV tells you cleanly whether your cost problem is a price problem.

What this calculator does

  • Measure actual-versus-standard material price variance for purchased or consumed materials.
  • Use in purchasing, quoting, or operations reviews when material price changes affect margin.
  • It computes the price variance for a purchased material as (actual price minus standard price) times the quantity bought, plus the per-unit gap and its annualized cost impact.

Formula used

  • Price variance = (actual price − standard price) × quantity
  • Variance per unit = actual price − standard price
  • Annualized impact = variance per unit × annual usage

Inputs explained

  • Standard price: undefined
  • Actual price: undefined
  • Quantity: undefined
  • Annual usage: undefined

How to use the result

  • Use it during month-end cost reviews, after a supplier price change, or when quoting to check whether current buy prices still support your standard-cost model.
  • MPV only isolates price; it says nothing about whether you used more or less material than planned (that is the quantity/usage variance) and it depends entirely on a well-maintained standard price.

Current U.S. benchmarks

  • The producer price index for plastic resins and materials stands at 319.371 (BLS, May 2026), up 19.5% from a year earlier. Quotes priced off last quarter's material cost miss this move.
  • On-highway diesel averages $4.58 per gallon this week (EIA), trending down over recent periods. Truck tonnage is up 3.4% year over year (ATA via FRED).
  • The producer price index for paperboard and containers stands at 276.831 (BLS, May 2026), up 8.8% from a year earlier. Quotes priced off last quarter's material cost miss this move.

Common questions

  • How do you calculate material price variance? Subtract the standard price from the actual price and multiply by the quantity purchased. At a standard of $2.40/unit, an actual of $2.68/unit, and 18,000 units, the variance is (2.68 - 2.40) x 18,000 = $5,040 unfavorable.
  • Is a positive material price variance good or bad? By this calculator's convention a positive number is unfavorable because you paid above standard. Here the $5,040 variance means you spent $5,040 more than the standard-cost plan on those 18,000 units.
  • What is the per-unit material price variance in this example? $0.28 per unit ($2.68 actual minus $2.40 standard). That small gap looks minor until you scale it: across 96,000 units a year it becomes a $26,880 annualized impact.
  • Material price variance vs material usage variance - what's the difference? Price variance isolates the effect of paying a different price than standard; usage (quantity) variance isolates using more or fewer units than the standard bill of materials allowed. Together they reconcile the total material cost variance.
  • What is a good material price variance? The ideal is near zero or slightly favorable, meaning actual buy prices track your standards. Persistent unfavorable variances above a few percent usually mean your standards are stale or your contracts need renegotiation.

Last reviewed 2026-05-12.