Absorption Costing Calculator
Calculate full product cost using absorption costing by allocating direct materials, direct labor, variable overhead, and fixed overhead to each unit.
Material Price Variance Calculator
Calculate material price variance (MPV) by comparing actual vs standard purchase price times actual quantity. Key variance analysis tool.
$
$
$
$
%
Material Price Variance⧉
$5,250.00
Unfavorable - difference between actual and standard price times quantity purchased
Landed Cost Variance⧉
$6,795.00
Unfavorable - variance including freight, handling, and discount adjustments
Price Difference / Unit⧉
$0.35
Actual is $0.35 above standard per unit
Variance %⧉
7.78%
Price deviation expressed as a percentage of the standard price
Landed Unit Cost⧉
$4.95
Net price after discount plus freight and handling per unit
Annualized Impact⧉
$63,000.00
Projected 12-month financial impact at current variance rate
Cost Waterfall (per unit)
List Price
$4.85
Less: Discount
-$0.10
Net Price
$4.75
Plus: Freight
$0.12
Plus: Handling
$0.08
Landed Cost
$4.95
Standard Price
$4.50
Cost Summary
| Line Item | Per Unit | Total | % of Landed |
|---|---|---|---|
| Actual Purchase Price | $4.85 | $72,750.00 | 97.9% |
| Volume Discount | -$0.10 | -$1,455.00 | 2% |
| Freight | $0.12 | $1,800.00 | 2.4% |
| Handling | $0.08 | $1,200.00 | 1.6% |
| Landed Cost | $4.95 | $74,295.00 | 100% |
| Standard Cost | $4.50 | $67,500.00 | 90.9% |
Volume Discount Analysis
| Order Qty | Landed $/Unit | Total Cost | Variance | Direction |
|---|---|---|---|---|
| 7,500.00 | $5.00 | $37,511.25 | $2,261.25 | Unfavorable |
| 15,000.00 | $4.95 | $74,295.00 | $3,795.00 | Unfavorable |
| 30,000.00 | $4.92 | $147,717.00 | $6,717.00 | Unfavorable |
| 75,000.00 | $4.88 | $365,655.00 | $13,155.00 | Unfavorable |
| 150,000.00 | $4.84 | $725,490.00 | $20,490.00 | Unfavorable |
Planning notes, formulas, and examples
About the Material Price Variance Calculator
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.
When This Page Helps
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.
How to Use the Inputs
- Enter the actual price paid per unit of material.
- Enter the standard price per unit of material.
- Enter the actual quantity purchased.
- Review the MPV and whether it is favorable or unfavorable.
- Investigate unfavorable MPV to identify the cause and corrective actions.
Formula used
MPV = (Actual Price − Standard Price) × Actual Qty Purchased
Positive MPV = Unfavorable (paid more than standard)
Negative MPV = Favorable (paid less than standard)Example Calculation
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.
Tips & Best Practices
- Compare MPV across suppliers to identify which relationships deliver best pricing.
- Separate MPV for major commodity groups — metals, plastics, electronics — for targeted analysis.
- Consider whether favorable MPV came at the expense of quality (cheaper materials may cause defects).
- For commodities with volatile prices, use indexed standards that adjust with market prices.
- Track MPV monthly and quarterly to identify pricing trends.
- Include freight and duties in the actual price for imported materials for a complete MPV.
MPV and Purchasing Performance
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.
Commodity Price Hedging
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.
MPV in Multi-Plant Companies
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.
Sources & Methodology
Last updated:
Frequently Asked Questions
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.
More in this topic
Activity-Based Costing (ABC) Calculator
Calculate cost per activity using activity-based costing. Divide cost pools by activity drivers for precise overhead allocation.
Actual vs Standard Cost Variance Calculator
Calculate total cost variance between actual and standard manufacturing costs. Identify favorable and unfavorable variances quickly.