Calculate material price variance (MPV) by comparing actual vs standard purchase price times actual quantity. Key variance analysis tool.
Material Price Variance (MPV) measures the cost impact of paying more or less than the standard price for purchased materials. It is calculated as the difference between the actual price paid and the standard price, multiplied by the actual quantity purchased. MPV isolates the price effect from the usage effect, giving purchasing managers a clear metric for price performance.
A favorable MPV means the company paid less than the standard price — perhaps through negotiation, bulk discounts, or favorable market conditions. An unfavorable MPV indicates higher-than-expected prices due to supplier increases, rush orders, small quantities, or commodity price spikes.
MPV is typically recognized at the time of purchase, making it a timely signal. If materials are purchased at unfavorable prices, the variance appears immediately, allowing purchasing to investigate and potentially renegotiate before the next order. This calculator computes MPV quickly so you can monitor price performance against standards.
This measurement forms a critical foundation for capacity planning, helping teams align production capabilities with demand forecasts and strategic business objectives throughout the planning cycle.
MPV tells you whether your purchasing function is meeting cost targets. It separates the price effect from efficiency issues so you can hold the right people accountable — purchasing for prices, production for usage. Having accurate figures readily available streamlines reporting, audit preparation, and strategic planning discussions with management and key stakeholders across the business.
MPV = (Actual Price − Standard Price) × Actual Qty Purchased Positive MPV = Unfavorable (paid more than standard) Negative MPV = Favorable (paid less than standard)
Result: $2,500.00 Unfavorable
The company paid $5.25 per unit instead of the $5.00 standard, a $0.25 overage. Multiplied by 10,000 units purchased: ($5.25 − $5.00) × 10,000 = $2,500 unfavorable variance.
MPV is the primary metric for evaluating the purchasing department's cost performance. However, purchasing decisions involve trade-offs — price vs. quality, price vs. delivery speed, price vs. supplier reliability. MPV should be evaluated alongside quality metrics and delivery performance to get a complete picture.
For materials tied to volatile commodities (steel, copper, resins), some companies use hedging strategies — forward contracts, futures, or long-term fixed-price agreements — to stabilize MPV. Without hedging, MPV swings with commodity markets, making it difficult to distinguish purchasing performance from market forces.
Companies with multiple plants can benchmark MPV across locations. If Plant A has consistently lower MPV than Plant B for the same materials, it suggests Plant A's purchasing practices are superior or it has better supplier relationships. Sharing best practices across plants can reduce company-wide material costs.
MPV is typically recognized at the time of purchase (when materials are received), not when they are used in production. This provides the earliest possible signal of price deviations and makes the purchasing department accountable at the point of commitment.
Common causes include supplier price increases, purchasing in smaller-than-optimal quantities, rush orders with premium pricing, commodity price spikes, using a more expensive substitute material, tariff changes, and currency fluctuations on imported materials. Reviewing these factors periodically ensures your analysis stays current as conditions and requirements evolve over time.
Favorable MPV can result from negotiated discounts, bulk buying, taking advantage of market dips, switching to lower-cost suppliers, or currency movements that reduce import costs. However, be cautious — buying cheaper materials may affect quality.
MPV measures the price effect — did you pay more or less per unit? Material usage variance measures the efficiency effect — did you use more or less material than standard? Together they explain the total material cost variance.
Both are useful. Per-PO MPV provides granular feedback for each transaction. Period MPV (monthly or quarterly) shows the aggregate price performance and is used for financial reporting and trend analysis.
Yes. Standards that are too tight (based on historical lows) generate chronic unfavorable variances that are meaningless. Standards that are too loose (inflated prices) generate chronic favorable variances that mask real issues. Standards should reflect realistic, attainable prices.