Measure the price variance between actual and standard material cost.
Unfavorable variance: you paid more than standard.
Please do not make financial decisions based on these results.
What is the Direct Material Price Variance Calculator?
Measure the price variance between actual and standard material cost. To use the Direct Material Price Variance Calculator, enter actual price per unit, standard price per unit, actual quantity purchased; it returns material price variance, variance per unit, variance percent, total actual cost, and shows them instantly as you type.
Where the Direct Material Price Variance Calculator fits
Measure the price variance between actual and standard material cost. The main figure it returns is the Material price variance, worked out from the values you enter.
It belongs with the other business planning tools. If you are comparing options or checking a result from another angle, try the Price / Quantity Calculator, Lerner Index Calculator or the EVM Calculator.
How to use the Direct Material Price Variance Calculator
- Enter your numbers. The inputs are Actual price per unit ($), Standard price per unit ($), Actual quantity purchased. Use figures from the same period (same month, quarter or year) for every field. Fields marked optional can stay at zero.
- Read the result. The highlighted box gives the Material price variance, and the cards below show Variance per unit, Variance percent, Total actual cost. Tables and charts break it down further.
- Test other scenarios. Results update as you type. Change one value at a time to see what drives the answer, and press Reset to go back to the defaults.
Formula and how it works
Example with real numbers
Here is the Direct Material Price Variance Calculator using the default values shown in the calculator above:
Inputs
| Actual price per unit ($) | 5.4 |
|---|---|
| Standard price per unit ($) | 5 |
| Actual quantity purchased | 12,000 |
Results
| Material price variance | $4,800.00 |
|---|---|
| Variance per unit | $0.40 |
| Variance percent | 8% |
| Total actual cost | $64,800.00 |
With these inputs the calculator returns Material price variance: $4,800.00. Change any value in the calculator to see how the result moves.
What if you change one input?
Sensitivity check: raising Actual price per unit ($) from 5.4 to 6.48 (about 20% higher) and leaving everything else as in the example above changes the results like this:
| Result | Example | After the change | Change |
|---|---|---|---|
| Material price variance | $4,800.00 | $17,760.00 | +270% |
| Variance per unit | $0.40 | $1.48 | +270% |
| Variance percent | 8% | 29.6% | +270% |
| Total actual cost | $64,800.00 | $77,760.00 | +20% |
The input that moves the result most is the one to check twice. Change it in the calculator above to test your own case.
What the results tell you
The results panel of the Direct Material Price Variance Calculator reports Material price variance, variance per unit, variance percent and total actual cost. Compare these figures while changing one input at a time, and use the related calculators below to look at the same situation from another angle.
Method and limits. This calculator applies the formula in the section above to your inputs, in your browser; nothing you enter is stored on our servers. The result is only as accurate as the numbers you enter and the formula shown above. It is for information, not financial, tax or legal advice.
Frequently asked questions
Is a positive variance good or bad?
A positive result means you paid more than standard, which is unfavorable.
What is the most important number for a new business?
Cash runway. A profitable plan still fails if cash runs out first, so check burn rate and break-even together.
Can these calculators replace an accountant?
No. They give fast estimates from your inputs. Use an accountant for tax, audited accounts and valuation reports.
Are the results guaranteed?
No. Results depend entirely on the numbers you enter and the formulas shown on this page. Please do not make financial decisions based on them alone; confirm important figures with a licensed professional.
Related business planning calculators
- Price / Quantity Calculator
- Lerner Index Calculator
- EVM Calculator
- Lemonade Stand Calculator
- PVGO Calculator
- GMROI Calculator — Gross Margin Return on Investment
- HHI Calculator (Herfindahl-Hirschman Index Calculator)
- Revenue Per Employee Calculator
- Average Fixed Cost Calculator
- Build vs. Buy Calculator
- Cost of Doing Business Calculator
- Cost Function Calculator
All Business Planning calculators →