Skip to content
Omnikalc

Material variance calculator: why did the cost of materials miss the standard?

Enter the standard and actual price and quantity to get the material price variance, the usage variance and the total variance, each marked favorable or unfavorable.

Updated on
Your inputs
$

Value out of range

$

Value out of range

Value out of range

Value out of range

Value out of range

Results

Total material variance

$1,262.50

Unfavorable (cost above standard)
Material price variance
$662.50
Unfavorable (cost above standard)
Material usage (quantity) variance
$600.00
Unfavorable (cost above standard)
Standard cost allowed
$10,000.00
Actual cost
$11,262.50

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.

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.

Frequently asked questions

What is a material price variance?

It is the difference between what the company actually paid for the materials it used and what it should have paid at the standard price. A positive result means the material cost more than planned. Purchasing, supplier choices, rush orders and market changes are the usual causes.

What is a material usage variance?

It is the value, at the standard price, of the difference between the material used and the material that the actual output should have needed. A positive result means that the plant used more than allowed. Waste, scrap, poor quality material, machine setup and training can cause it.

What do favorable and unfavorable mean?

A favorable variance is one where the actual cost is below the standard, and an unfavorable one is above it. The names do not say if the result is good for the business, since a favorable price variance from a cheap, poor material may cause a high usage variance.

Who is responsible for each variance?

The price variance is usually the responsibility of purchasing, and the usage variance of production. This is a rule of thumb, and links exist, as a low price may come with a lower quality. Investigate the cause before blaming a team.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.