Standard costing sets a budgeted price for each material. The price variance shows how much purchasing decisions, supplier price changes or rush orders cost (or saved) compared with the budget. It is usually reported by the purchasing department.
How to use the Direct Material Price Variance Calculator
- Standard price per unit
- Actual price per unit
- Actual quantity purchased
Results update as you type, and every field accepts the units shown in its menu.
How it works
Enter the standard price per unit, the actual price per unit and the quantity purchased.
Tips
- Use figures for the same period (a month, a quarter or a year) for every input so ratios compare like with like.
- Track the metric over time – the trend usually tells you more than a single value.
- Compare your result with industry benchmarks, which vary a lot between sectors.
- Treat the result as a starting point for a decision, then check the assumptions behind each input.
Common mistakes to avoid
- Mixing monthly and yearly numbers in the same calculation.
- Using revenue where the formula needs profit (or the other way round).
- Forgetting hidden costs such as taxes, fees, overheads or your own time.
Inputs explained
| Field | What to enter |
|---|---|
| Standard price per unit | Amount in your currency |
| Actual price per unit | Amount in your currency |
| Actual quantity purchased | A number |
What each result means
- Direct material price variance = ([Actual price per unit] – [Standard price per unit])×[Actual quantity purchased]
- Price difference = ([Actual price per unit]÷[Standard price per unit] – 1)×100
Example values
How the main result changes when Standard price per unit changes and everything else stays at the example values above:
| Standard price per unit | Direct material price variance |
|---|---|
| 5 | 7,000 |
| 7.5 | 4,500 |
| 10 | 2,000 |
| 12.5 | -500 |
| 15 | -3,000 |
| 20 | -8,000 |
Formula
DMPV = (actual price − standard price) × actual quantityPositive → unfavourable (paid more); negative → favourableWorked example
Inputs — Standard price per unit: $10; Actual price per unit: $12; Actual quantity purchased: 1,000.
Results — Direct material price variance = $2,000.00; Type = Unfavourable – paid more than standard; Price difference = 20 %.
Frequently asked questions
What does an unfavourable price variance mean?
You paid more per unit than budgeted.
What causes price variances?
Supplier price rises, smaller order quantities, rush shipping or quality changes.
What is the quantity variance?
The cost of using more or less material than standard, valued at the standard price.
What formula does the Direct Material Price Variance Calculator use?
DMPV = (actual price − standard price) × actual quantity.