Cost of Goods Sold (COGS) Calculator
Calculate COGS using beginning inventory, purchases, and ending inventory. Compare FIFO, LIFO, and weighted-average methods with gross profit analysis.
Material Variance Calculator
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 Price Variance⧉
$640.00
Unfavorable
Material Quantity Variance⧉
$1,000.00
Unfavorable
Total Material Variance⧉
$1,640.00
+10.9% of standard
Actual Cost per Finished Unit⧉
$16.64
Std: $15.00
Three-Column Variance Decomposition
Actual Qty × Actual Price
3,200.00 × $5.20
$16,640.00
Actual Qty × Std Price
3,200.00 × $5.00
$16,000.00
Std Qty Allowed × Std Price
3,000.00 × $5.00
$15,000.00
Price Variance: $640.00 Unfavorable
Quantity Variance: $1,000.00 Unfavorable
Price Premium
+4.0%
Scrap / Excess
+6.7%
Extra Qty Used
200.00
Std Qty Allowed
3,000.00
Price Sensitivity (Usage Held Constant)
| Price Change | Actual Price | MPV | Total Variance |
|---|---|---|---|
| -20% | $4.00 | $3,200.00 F | $2,200.00 F |
| -10% | $4.50 | $1,600.00 F | $600.00 F |
| -5% | $4.75 | $800.00 F | $200.00 U |
| +0% | $5.00 | $0.00 F | $1,000.00 U |
| +5% | $5.25 | $800.00 U | $1,800.00 U |
| +10% | $5.50 | $1,600.00 U | $2,600.00 U |
| +20% | $6.00 | $3,200.00 U | $4,200.00 U |
Usage Sensitivity (Price Held Constant)
| Usage Change | Actual Qty | MQV | Total Variance |
|---|---|---|---|
| -10% | 2,700.00 | $1,500.00 F | $860.00 F |
| -5% | 2,850.00 | $750.00 F | $110.00 F |
| -2% | 2,940.00 | $300.00 F | $340.00 U |
| +0% | 3,000.00 | $0.00 F | $640.00 U |
| +2% | 3,060.00 | $300.00 U | $940.00 U |
| +5% | 3,150.00 | $750.00 U | $1,390.00 U |
| +10% | 3,300.00 | $1,500.00 U | $2,140.00 U |
| +15% | 3,450.00 | $2,250.00 U | $2,890.00 U |
Planning notes, formulas, and examples
About the Material Variance Calculator
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.
Use the result to compare scenarios, test assumptions, and revisit the model when pricing, volume, or financing inputs change.
When This Page Helps
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.
How to Use the Inputs
- Enter the standard price and standard quantity per finished unit for each material.
- Enter the number of finished units actually produced.
- Enter the actual price paid and actual total quantity used.
- Review the material price variance and material quantity variance.
- Check the per-unit impact and percentage deviation.
- Use sensitivity analysis to evaluate different price and usage scenarios.
Formula used
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 + MQVExample Calculation
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.
Tips & Best Practices
- Calculate MPV at the time of purchase (not usage) for timely purchasing feedback.
- Track MQV by production run to identify specific jobs or batches with high scrap.
- Compare actual scrap rates to standard allowances — standards may need updating.
- A favorable MPV from cheaper material may cause unfavorable MQV from higher waste.
- Use purchase price variance instead of MPV when buying and usage quantities differ.
- Investigate quantity variance by cause: setup waste, operator error, machine malfunction, quality issues.
The Purchase Price Variance
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.
Controlling Material Usage
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.
Impact on Profitability
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.
Sources & Methodology
Last updated:
Frequently Asked Questions
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.
More in this topic
Direct vs. Indirect Cost Calculator
Classify and analyze direct vs. indirect costs. Calculate cost ratios, overhead burden, and model cost structure scenarios for better pricing and profitability decisions.
Fixed vs. Variable Cost Calculator
Classify fixed and variable costs, calculate cost behavior ratios, and analyze how total costs change with volume. Includes high-low method and break-even analysis.