Direct Material Price Variance Calculator
Calculate the direct material price variance to measure the difference between what you paid for materials versus the standard cost. A negative result indicates an unfavorable variance (paid more than standard).
How to use this tool
- Enter standard price per unit, actual price per unit and actual quantity purchased in the fields above.
- Results update instantly as you type โ or click Calculate.
- Read your material price variance and the full breakdown beneath it.
โ This tool provides general estimates for education only and is not financial, tax or legal advice. Figures may not reflect your situation โ verify with a qualified professional.
Formula
Material Price Variance: MPV = (Standard Price โ Actual Price) ร Actual Quantity
A positive MPV is favorable (paid less than standard); a negative MPV is unfavorable (paid more than standard).
How it works
The direct material price variance isolates the effect of paying a different price than planned for raw materials, holding quantity constant at the actual amount purchased. It is a key metric in standard costing systems used in managerial accounting to identify purchasing efficiency or inefficiency. A favorable variance means actual costs were lower than the standard, while an unfavorable variance signals overspending relative to the budget.
Worked example
Steel Purchase Variance
- Standard price: $10/unit; Actual price: $12/unit; Actual quantity: 500 units
- Price difference = $10 โ $12 = โ$2 per unit (paid more than standard)
- Material Price Variance = โ$2 ร 500 = โ$1,000
- A negative result means the variance is unfavorable โ the company spent $1,000 more than planned
The material price variance is โ$1,000 (unfavorable), meaning the company paid $1,000 more than the standard cost for these materials.
Common mistakes to avoid
- Multiplying by standard quantity instead of actual quantity purchased, which blends the price variance with the efficiency variance rather than isolating the price effect.
- Reversing the sign convention -- (Standard Price - Actual Price) x Actual Quantity gives a positive favorable variance when you paid less than standard. Some textbooks use the opposite sign, so always verify the convention.
- Confusing material price variance (isolated at purchase) with material quantity variance (based on production usage) and incorrectly combining the two.
Key terms
- What is a favorable vs. unfavorable variance?
- A favorable variance occurs when actual costs are less than standard costs, improving profitability. An unfavorable variance occurs when actual costs exceed standard costs, reducing profitability.
- What causes a material price variance?
- Common causes include supplier price changes, bulk purchase discounts, market price fluctuations, or differences in quality of materials purchased compared to standard.
- What is standard costing?
- Standard costing is a cost accounting method where predetermined (standard) costs are assigned to products, and actual costs are compared to these standards to identify variances for management review.
- Why is actual quantity used instead of standard quantity?
- The material price variance uses actual quantity purchased because the price difference affects every unit actually bought, regardless of how many units were budgeted for.
Frequently asked questions
- Why is the variance calculated on quantity purchased rather than quantity used?
- Price variance is isolated at purchase so the purchasing department is held accountable immediately. Calculating it on quantity used would defer the variance to production and mix purchasing efficiency with production efficiency.
- What causes an unfavorable material price variance?
- Common causes include emergency spot-market purchases, supplier price increases not yet reflected in standards, buying smaller quantities that lose volume discounts, or substituting a different grade of material than the standard specifies.
- How does this variance tie to the standard cost system?
- In standard costing, raw materials are recorded at standard price. The price variance is booked at purchase to close the gap between actual cost paid and the standard cost recorded. Unfavorable variances reduce reported profit; favorable ones increase it.