Saved

Press the star next to a tool's name to save it.

All my tools

Direct Material Price Variance Calculator

Use this direct material price variance calculator to compare the actual and standard price of materials for the quantity bought, and see if it is adverse.

Restored your last values ·

Enter the quantity of material actually bought, the price actually paid per unit and the standard price per unit from your budget or standard costing. Amounts are in your own currency.

Everything is worked out in your browser. Nothing you type is sent anywhere.

–

–

Fill in the boxes and press Calculate.

See full result

A direct material price variance calculator shows how much more or less a business paid for its materials than the standard price it planned for. Enter the quantity of material bought, the actual price per unit and the standard price per unit. The calculator works out the price variance, says whether it is favourable or adverse, and shows the actual cost, the standard cost of the same quantity and the difference per unit.

The direct material price variance formula

Direct material price variance = (actual price − standard price) × actual quantity
= actual cost − standard cost of the actual quantity

OpenStax's Principles of Managerial Accounting gives the variance as the actual quantity times the actual price, minus the actual quantity times the standard price. That is the difference between the actual cost and the standard cost for the actual quantity of material purchased. When the actual price is higher than the standard price, the business paid more than planned and the variance is unfavourable, also called adverse. When it is lower, the variance is favourable.

How to use the direct material price variance calculator

  1. Enter the actual quantity of material bought.
  2. Enter the actual price paid per unit. If you only know the total cost, divide it by the quantity.
  3. Enter the standard price per unit.
  4. Press Calculate to see the variance and whether it is favourable or adverse.

Worked example

For example, a product has a standard of 2 kilograms of material at €60 per kilogram. To make 100 units, the business used 212 kilograms, which cost €13,144. At the standard price, 212 kilograms should have cost 212 × €60 = €12,720. The price variance is €13,144 − €12,720 = €424 adverse. The actual price was €13,144 ÷ 212 = €62 per kilogram, €2 more than standard, and €2 × 212 = €424.

Why the actual quantity is used

The price variance isolates the effect of the price. By valuing the same, actual quantity at both prices, it measures only how much the price difference cost or saved. The separate question of whether more or less material was used than the standard allowed is answered by the material usage variance, which values the difference in quantity at the standard price. In the example, the standard for 100 units is 200 kilograms, so using 212 kilograms also creates a usage variance of 12 × €60 = €720 adverse. Together the two variances explain the whole gap between the standard cost of the output and the actual cost.

What causes price variances

  • Supplier price changes since the standard was set.
  • Buying in smaller or larger quantities, which changes discounts.
  • Changing suppliers or buying a different grade of material.
  • Urgent orders that carry extra charges.
  • Exchange rate moves for imported materials.

A favourable price variance is not always good news: cheaper, lower-quality material can cause more waste and an adverse usage variance. Looking at both variances together gives the full picture.

Who uses it

Purchasing managers are usually responsible for price variances, because they negotiate with suppliers. Production managers are usually responsible for usage variances. Reporting the two separately makes it clear who can act on each. For related cost figures, try the AVC calculator and the COGS calculator.

Setting standard prices

A standard price is the price the business expects to pay for a unit of material, usually set when the budget is prepared. It is based on supplier quotes, recent purchase prices and expected changes over the year, such as known price rises. A good standard is realistic: if it is set too low, every purchase looks adverse and the variance stops being useful; if it is set too high, it hides overspending. Reviewing standards once a year, or when a supplier changes its prices, keeps the variances meaningful.

Variance per unit and in total

The calculator shows both the total variance and the difference per unit. The per-unit figure is useful for spotting changes in supplier pricing, while the total shows the effect on profit. In the example, a difference of €2 per kilogram looks small, but over 212 kilograms it adds up to €424, and over a year of purchases it could be many times that. Reporting both helps managers judge whether a variance is worth investigating.

Recording variances in the accounts

In a standard costing system, materials are often recorded at the standard price, and the price variance is recorded separately when the purchase is made. That way the variance is identified as soon as the material is bought, rather than when it is used, and the purchasing team can be told straight away if prices have moved.

Investigating a large variance

When a variance is large, start by checking the invoices: confirm the quantity, the price and any delivery or rush charges. Then ask the purchasing team whether the supplier, the grade of material or the order size changed, and whether the change is likely to continue.

Common mistakes

  • Using the standard quantity. The price variance uses the actual quantity bought.
  • Getting the sign the wrong way round. Paying more than standard is adverse for a cost.
  • Mixing units. Use the same unit, such as kilograms, for quantity and price.

What next

Use this often? Add Direct Mater to your Home screen.

Frequently asked questions

How does a direct material price variance calculator work?

It multiplies the difference between the actual and standard price per unit by the actual quantity bought.

What is the variance for 212 kg bought at €62 against a €60 standard?

(€62 − €60) × 212 = €424 adverse, as in the worked example.

Is a positive variance good or bad?

For a cost, paying more than standard is adverse; paying less is favourable.

What is the difference between price and usage variance?

Price variance measures the price difference on the actual quantity; usage variance measures the quantity difference at the standard price.

Who is responsible for material price variances?

Usually the purchasing department, because it negotiates prices.

What went wrong?

We only receive the reason you pick, never what you typed into the tool.

Thanks for your feedback.

More Finance Tools