Direct Material Price Variance Calculator
Enter the standard rate, the actual rate and the quantity to find the price variance and whether it is favourable or unfavourable.
Updated
Direct Material Price Variance Calculator
Our Direct Material Price Variance Calculator compares what you planned to pay for materials with what you actually paid. Enter the standard rate per unit, the actual rate per unit and the quantity, and it shows the variance and whether it is favourable or unfavourable. It is made for people in manufacturing, cost accounting, purchasing and for accounting students.
Quick answer
Direct material price variance is (standard rate − actual rate) × quantity: (50 − 55) × 25 = −125, an unfavourable variance of 125.
- Favourable: actual rate below standard rate, so you paid less than planned.
- Unfavourable: actual rate above standard rate, so you paid more than planned.
- Quantity: use the actual quantity bought, not the budgeted quantity.
- Who owns it: the variance mainly reflects purchasing, not production.
What Is Direct Material Price Variance?
Direct material price variance (DMPV) is the difference between what a business should have paid for its materials, at the standard rate, and what it actually paid. It shows how well purchasing is controlling material costs:
= (Standard rate − Actual rate)
× Quantity
- Standard rate: the planned cost per unit of material.
- Actual rate: the real cost paid per unit.
- Quantity: the actual quantity of material purchased.
Favourable and Unfavourable Variances
| Rates | Variance |
|---|---|
| Actual < Standard | Favourable: spent less than expected |
| Actual > Standard | Unfavourable: spent more than expected |
| Actual = Standard | No variance |
With the formula above, a positive answer is favourable and a negative answer is unfavourable. Some textbooks write it the other way round, as (actual rate − standard rate) × quantity, where a positive answer is unfavourable. The size is the same either way, and the calculator labels the result so the sign cannot be misread.
How to Calculate Price Variance
A furniture maker planned to buy 500 metres of wood at a standard rate of 40 per metre, but paid 45:
= −5 × 500
= −2,500 (Unfavourable)
- Find the rate difference. Standard rate minus actual rate: 40 − 45 = −5.
- Multiply by the quantity. −5 × 500 = −2,500.
- Read the sign. Negative means unfavourable: materials cost 2,500 more than planned.
If the buyer had negotiated 38 per metre instead, the result would be (40 − 38) × 500 = 1,000, a favourable variance of 1,000.
Price Variance Examples
| (Standard − Actual) × Qty | Variance |
|---|---|
| (80 − 75) × 14 | 70 Favourable |
| (50 − 55) × 25 | 125 Unfavourable |
| (40 − 40) × 100 | 0 No variance |
| (60 − 58) × 30 | 60 Favourable |
In the first case the company saved 70 because the actual rate was lower than the standard, a sign of good purchasing. In the second, material cost 125 more than planned, which is a prompt to renegotiate rates or look at other suppliers.
What Causes a Price Variance?
- Market prices. Raw material prices rise and fall.
- Supplier changes. New price lists, a different supplier or higher shipping costs.
- Order size. Bulk discounts gained or missed.
- Material grade. Buying a higher or lower quality than the standard assumed.
- Rush orders. Paying a premium for fast delivery.
- Exchange rates. Currency moves on imported materials.
- Outdated standards. A standard rate that no longer reflects the market.
Price Variance vs Quantity Variance
The two direct material variances answer different questions:
| Variance | Asks |
|---|---|
| Price | Did we pay more or less per unit than planned? |
| Quantity | Did we use more or less material than planned? |
= (Standard qty − Actual qty)
× Standard rate
Price variance usually points to purchasing and quantity variance to production. They can be linked: cheap, low-grade material can produce a favourable price variance and an unfavourable quantity variance through extra waste.
Where Price Variance Is Used
- Cost accounting. Measure how well input costs are held to budget.
- Performance evaluation. Assess the purchasing or procurement team.
- Budgeting and forecasting. Use past variances to set better standard rates.
- Supplier management. Spot suppliers charging above the expected rate.
- Profitability analysis. See how raw material prices affect production cost and margin.
To keep variances useful, update standard costs when the market moves, review variances every month and watch commodity price trends.
Common Mistakes
- Using the budgeted quantity. Price variance uses the actual quantity bought.
- Misreading the sign. Check which way round the formula is written before calling a result favourable.
- Mixing units. Both rates must be per the same unit (per metre, per kilogram) as the quantity.
- Treating favourable as always good. A low price can mean lower quality and more waste later.
- Blaming purchasing for everything. A rush order caused by poor production planning also raises the price paid.
Key Terms
- Standard rate
- The planned price per unit of material.
- Actual rate
- The price really paid per unit.
- Standard cost
- Standard rate × quantity.
- Favourable
- Actual cost below standard cost.
- Unfavourable
- Actual cost above standard cost. Also called adverse.
- Variance analysis
- Comparing actual results with standards to find out why they differ.
How to Use the Direct Material Price Variance Calculator
- Enter the standard rate. Type the planned cost per unit of material, such as 50.
- Enter the actual rate. Type the price actually paid per unit, such as 55.
- Enter the quantity. Type the number of units purchased, such as 25. Commas are fine.
- Read and copy the result. The variance appears as you type, labelled Favourable or Unfavourable, with the working, the standard cost and the actual cost. Press Copy to copy it, or Clear or Esc to start again.
Example: standard rate 80, actual rate 75 and quantity 14. The result is 70 Favourable, from (80 − 75) × 14 = 70, with a standard cost of 1,120 and an actual cost of 1,050.
Who Can Use This Calculator?
Frequently Asked Questions (FAQs)
How do you calculate direct material price variance?
Subtract the actual rate from the standard rate and multiply by the quantity purchased. Price variance = (standard rate − actual rate) × quantity. A positive result is favourable and a negative result is unfavourable.
What is the price variance if the standard rate is 50, the actual rate is 55 and the quantity is 25?
It is 125 unfavourable. (50 − 55) × 25 = −125, so the materials cost 125 more than the standard allowed.
What does direct material price variance tell you?
It shows how much more or less you spent on materials than the standard rate allowed. A favourable variance means you paid less per unit than planned. An unfavourable variance means you paid more.
What causes a direct material price variance?
Common causes are changes in raw material market prices, supplier price or shipping changes, bulk discounts gained or missed, a different grade of material, rush orders, exchange rate moves and standard rates that are out of date.
Is a favourable price variance always good?
Not always. A lower price can come from lower quality material, which may cause more waste and an unfavourable quantity variance. Look at both variances together.
What is the difference between price variance and quantity variance?
Price variance measures the difference in cost per unit between the standard and actual rates. Quantity variance measures the difference between the material that should have been used and the material actually used, valued at the standard rate.
Which quantity should I use?
Use the actual quantity of material purchased. That isolates the effect of price, so the purchasing variance is reported when the materials are bought.
Is the Direct Material Price Variance Calculator free?
Yes. It is completely free, needs no sign-up, and can be used as many times as you like.
Sources
- OpenStax, Principles of Accounting, Volume 2. 8.2 Compute and Evaluate Materials Variances.
- Accounting For Management. Direct materials price variance.
- AccountingTools. Purchase price variance definition.
- Principles of Accounting. Variance Analysis.
Try our Direct Material Price Variance Calculator to check your material costs in seconds.