1. Introduction and Objectives
When actual material expenditures deviate from standard targets, variance analysis isolates pricing changes from physical usage efficiency. This lesson details the mathematical structure used to audit material variances.
2. Formula Architecture
  • Direct Material Price Variance (MPV): Measures the financial impact of purchasing raw materials at prices that differ from standard benchmarks.

    MPV = (Actual Price − Standard Price) × Actual Quantity Purchased
  • Direct Material Quantity (Usage) Variance (MQV): Measures the physical efficiency of production by comparing actual material consumption against the standard quantity allowed for the output achieved.

    MQV = (Actual Quantity Used − Standard Quantity Allowed) × Standard Price

    Where:
    Standard Quantity Allowed (SQ) = Actual Units Produced × Standard Unit Material Benchmark

3. Computational Ledger Simulation
A plant manufactures 2,000 units of Product SKU-500. According to the standard cost card, each unit requires 4.0 kg of material at $5.00/kg.
  • Actual Results: The company purchased and used 8,300 kg of raw material at an actual price of $4.80/kg.

python
actual_units = 2000
standard_qty_per_unit = 4.0
standard_price = 5.00

actual_qty_used = 8300
actual_price = 4.80

# Calculations
sq_allowed = actual_units * standard_qty_per_unit
mpv = (actual_price - standard_price) * actual_qty_used
mqv = (actual_qty_used - sq_allowed) * standard_price

print(f"Standard Quantity Allowed (SQ): {sq_allowed} kg")
print(f"Material Price Variance (MPV): ${mpv:.2f} (Negative = Favorable)")
print(f"Material Quantity Variance (MQV): ${mqv:.2f} (Positive = Unfavorable)")
 

Evaluating these formulas confirms:

  • Standard Quantity Allowed (SQ) = 2,000 × 4.0 = 8,000 kg.

    MPV = ($4.80 − $5.00) × 8,300 = −$0.20 × 8,300 = −$1,660 [Favorable]

    MQV = (8,300 − 8,000) × $5.00 = 300 × $5.00 = $1,500 [Unfavorable]

  • Managerial Insight: The purchasing manager secured a lower price per kilogram (favorable MPV), but the lower-quality material may have caused excessive waste on the shop floor, resulting in an unfavorable usage variance (MQV).

  •  
PreviousNext