Calculate material price variance (MPV) and material quantity variance (MQV). Analyze direct material cost differences between standard and actual with decomposition and trend analysis.
Material variance analysis breaks down the total direct material cost variance into two actionable components: the Material Price Variance (MPV) and the Material Quantity Variance (MQV, also called usage variance). This decomposition tells managers whether cost overruns came from paying more per unit of material (price) or from using more material than expected (quantity).
The MPV is typically the purchasing department's responsibility, reflecting negotiation effectiveness, supplier selection, and market price changes. The MQV is production's responsibility, reflecting material handling efficiency, scrap rates, and process control. However, these variances often interact — buying cheaper materials may increase waste.
This calculator computes both variances for multiple materials, provides per-unit and total analysis, and includes sensitivity scenarios to help managers understand the impact of price and usage changes.
Entrepreneurs, finance teams, and small-business owners gain a competitive edge from accurate material variance data when setting prices, forecasting revenue, or managing operational costs. Save this tool and revisit it each quarter to keep your financial plans aligned with current market realities.
Direct materials are often the largest manufacturing cost. Even a small percentage variance on a large material spend can represent significant dollars. Material variance analysis identifies specific opportunities: renegotiate supplier contracts (price variance), reduce scrap (quantity variance), or improve material specifications (both). Instant recalculation lets you test different assumptions side by side, giving you the confidence to act on data rather than gut instinct.
Material Price Variance = (Actual Price − Standard Price) × Actual Quantity Material Quantity Variance = (Actual Quantity − Standard Quantity Allowed) × Standard Price Standard Quantity Allowed = Standard Qty per Unit × Actual Production Total Material Variance = MPV + MQV
Result: $640 price U + $1,000 quantity U = $1,640 total unfavorable
Standard cost allowed: $5.00 × 3 × 1,000 = $15,000. Actual cost: $5.20 × 3,200 = $16,640. MPV = ($5.20 − $5.00) × 3,200 = $640 U. MQV = (3,200 − 3,000) × $5.00 = $1,000 U. Production used 200 extra units and paid $0.20/unit more.
Many companies compute the Material Price Variance at the point of purchase rather than usage. This purchase price variance uses quantity purchased (not quantity used) and provides earlier feedback to purchasing. The trade-off is that inventories are carried at standard cost, and the price variance is recognized before the material is even used in production.
Material quantity variance is controlled through proper storage and handling, operator training, machine maintenance, quality control at receiving (reject substandard materials), and engineering standards that include realistic allowances for normal scrap. Trend analysis of MQV over time reveals whether processes are improving or deteriorating.
For a company spending $10 million/year on materials, a 2% unfavorable total material variance represents $200,000 in excess cost. Decomposing this into price and quantity components directs corrective action to the right department and function.
Common causes include supplier price increases, loss of volume discounts, purchasing smaller quantities (rush orders), higher shipping costs, exchange rate changes for imported materials, and failure to take advantage of early payment discounts. Market conditions and commodity prices also play a role.
Excess usage comes from higher scrap or waste, poor quality materials, inexperienced workers, machine malfunctions, design changes requiring rework, theft or mishandling, inaccurate cutting and measurement, or outdated standards that don't reflect current processes. Always verify with current data, as conditions may change over time.
Best practice is to calculate MPV at time of purchase using quantity purchased (not quantity used). This gives purchasing managers timely feedback. The MQV is always based on quantity used. Some companies use the simpler approach of computing both on quantity used, which gives a combined joint variance.
For products using multiple raw materials, the quantity variance can be further decomposed. Mix variance measures the cost impact of changing the proportions of inputs (e.g., more of ingredient A, less of B). Yield variance measures overall usage efficiency relative to the standard. This detailed decomposition is used in industries like food, chemicals, and pharmaceuticals.
If you buy larger quantities to get volume discounts, price variance is favorable, but you may carry excess inventory (increased holding costs). If rush orders force small-quantity purchases, price variance is unfavorable. The interplay between purchase lot size, price, and inventory carrying cost requires total cost analysis.
It depends on the industry and material. A 2-3% quantity variance is typical for precision manufacturing; 5-10% may be normal for natural materials with inherent variability. Price variances of 1-3% reflect normal market fluctuations. Consistent trends above these thresholds warrant investigation.