Calcipedia

Direct Material Price Variance Calculator

Calculate direct material price variance from standard price, actual price, and actual quantity purchased, then compare standard spend, actual spend, and the favorable or unfavorable variance.

Last updated

Also in Pricing & Profit

← All Pricing & Profit calculators

Cost Variance

Direct material price variance calculator guide: compare standard cost with actual purchase price

A direct material price variance calculator compares the actual purchase price for materials with the standard price and multiplies the difference by the quantity purchased. It helps purchasing, costing, and budgeting teams see whether materials came in above or below expectation and how much that price difference changed period cost.

What this calculator measures

Direct material price variance isolates the unit-price difference between what you expected to pay and what you actually paid. The calculator then applies that difference to the actual quantity purchased so you can see the total cost effect in currency terms.

This is a price-only variance. It does not measure quantity usage, scrap, yield, or production efficiency. That separation matters because a business can buy the right quantity at the wrong price, or the wrong quantity at the right price, and those are different management questions.

The price-variance formula and sign convention

The calculator uses the standard direct material price variance relationship: actual price minus standard price, multiplied by actual quantity purchased. If the actual price is higher than standard, the variance is positive and therefore unfavorable. If the actual price is lower than standard, the variance is negative and therefore favorable.

To make the comparison easier to audit, the page also shows the standard spend at the purchased quantity and the actual spend at the purchased quantity. That turns the variance into two side-by-side totals rather than a single abstract difference.

Direct material price variance = (Actual price - Standard price) x Actual quantity purchased

Positive values mean the purchase price came in above standard; negative values mean it came in below standard.

Standard spend at actual quantity = Standard price x Actual quantity purchased

This is the expected material cost for the purchased quantity at the standard price.

Actual spend at actual quantity = Actual price x Actual quantity purchased

This is the actual material cost for the purchased quantity at the negotiated or invoiced price.

Worked example: a small price increase across a large purchase

Suppose the standard price for a component is 12.50, the actual purchase price is 13.10, and the business bought 800 units. The price difference is 0.60 per unit. Applied across 800 units, the variance is 480 unfavorable.

The same result can be read as standard spend of 10,000 versus actual spend of 10,480. Seeing both totals makes the purchasing effect easier to explain to management than quoting the unit difference alone.

How to interpret the result

Use the result to separate purchasing performance from production efficiency. If the variance is unfavorable, the next question is whether the issue came from supplier pricing, timing, freight, market conditions, or a different purchasing specification than the one used for the standard.

If you also need quantity variance, compare standard quantity allowed with actual quantity used. That is a different calculation and should be handled separately from the price variance shown on this page.

Further reading

Frequently asked questions

What does direct material price variance measure?

It measures the difference between the actual purchase price and the standard price for materials, multiplied by the actual quantity purchased. That shows the total dollar effect of paying more or less than expected.

Why is a positive variance unfavorable?

Because a positive result means the actual price was higher than the standard price, which increases material cost. A negative result means the actual price was lower than standard, which is favorable.

Does this calculator also measure quantity variance?

No. It isolates price variance only. Quantity variance is a different analysis because it compares the actual quantity used or purchased with the standard quantity allowed.

Why does the calculator use actual quantity purchased?

Price variance is often measured using the quantity purchased so you can isolate the purchasing decision from the later production or usage decision. That keeps the comparison focused on what was actually paid for materials.

Related

More from nearby categories

These related calculators come from the same leaf category, nearby sibling categories, or the same top-level topic.