Standard costing compares what materials should have cost with what they did cost, and splits the gap into two causes. This material variance calculator takes the standard price, the actual price, the standard quantity per unit, the units produced and the actual quantity to give the price variance, the usage variance and the total variance.
How the calculation works
- Price variance = (actual price − standard price) × actual quantity. It isolates the effect of paying more or less than planned for each unit.
- Usage variance = (actual quantity − standard quantity allowed) × standard price. It isolates the effect of using more or less material than planned.
- Total variance = actual cost − standard cost = price variance + usage variance. A positive figure is unfavorable because the cost is above the standard.
- Standard quantity allowed = standard quantity per unit × units produced, and it is the quantity that the output should have needed.
Example
A plant plans to pay $4.00 a pound and use 2.5 pounds per unit. It makes 1,000 units, buys at $4.25 and uses 2,650 pounds. The standard cost is 4 × 2,500 = $10,000 and the actual cost is 4.25 × 2,650 = $11,262.50. The price variance is 0.25 × 2,650 = $662.50 unfavorable, the usage variance is 150 × 4 = $600.00 unfavorable, and the total is $1,262.50 unfavorable.
Why it matters
Cost accounting students, plant controllers and small manufacturers use variances to find out whether a cost overrun comes from buying or from production. It is a basic tool of budgeting and of month-end review.
Good to know
The calculation assumes that all the material bought is used in the period, so the price variance is based on the quantity used. Some companies compute it on the quantity bought, which changes the result when inventory changes. Standards must be reasonable and updated. Variances show where to look and do not tell you why, and this is a learning aid and not accounting advice.
Related tools
The COGS calculator totals the cost of goods sold, the break-even calculator finds the volume that covers costs and the inventory turnover calculator measures how fast stock moves.