HesapHanem

Quantity Variance Calculator

Enter the actual quantity, standard quantity, and standard price to find the quantity variance.

How it is calculated

The quantity (usage) variance is variance = (actual quantity − standard quantity) × standard price. The quantities are in the same unit (kilograms, metres, hours or pieces), and the standard price is the budgeted price per one unit of that quantity. Using the standard price, not the price actually paid, keeps price effects out of this figure.

A positive variance means more was used than the standard allows and is labelled unfavorable; a negative one means less was used and is labelled favorable; zero is no variance. The tool also shows the difference in units. The standard price cannot be negative, while the quantities can be any number. Standard quantity should be the amount the standard allows for the output actually produced, not for the planned output, otherwise the result mixes volume changes with efficiency.

Worked example

The standard calls for 5,000 kg of material at a standard price of $2.40 per kg. Production actually used 5,300 kg.

Difference = 5,300 − 5,000 = 300 units over. Variance = 300 × 2.40 = $720.00, which is unfavorable (used more). If only 4,800 kg had been used, the difference would be −200 and the variance −$480.00, favorable.

Try this example →

Common mistakes

  • Using the price actually paid instead of the standard price. That blends price variance into the result; use the budgeted price.
  • Comparing actual use against the standard for planned output when production volume differed. Use the standard quantity allowed for the actual output.
  • Reading a positive number as good. Here positive means unfavorable, more material than the standard, and negative means favorable.
  • Mixing units, such as actual usage in tonnes and standard quantity in kilograms.
  • Stopping at the money amount. The variance only tells you how much; whether the cause was waste, poor material quality or a wrong standard needs investigating.

Sources

About this calculator

In standard cost accounting, quantity variance (also called usage or efficiency variance) isolates how much of a cost overrun or saving came from using more or less material than planned, holding the price fixed. It’s calculated as (actual quantity − standard quantity) × standard price, so a positive result flags material waste or inefficiency while a negative one shows a favorable, below-budget usage.

Separating quantity variance from price variance (which instead isolates the effect of paying more or less per unit than budgeted) lets a business pinpoint whether a cost problem came from the purchasing department paying too much, or from the production floor using too much — two very different fixes. Cost accountants, manufacturing controllers and operations managers run this calculation each period to compare actual material usage against the standard set in the budget and investigate significant variances.

Was this helpful?

You can pick up to 3 reactions.

Comments

  • Be the first to comment.

Popular calculators

Loan Calculator

Monthly payment, total interest and full amortization schedule.

Percentage Calculator

Percent change, percent of, and ratio calculations.

Discount Calculator

Calculate final price, savings, and discount amount.

BMI Calculator

Body mass index from height and weight (metric or imperial).

Age Calculator

Compute your exact age in years, months and days from a birth date.

Compound Interest Calculator

Calculate the final amount and interest earned with compounding.

All Calculators