Calculate direct material price variance using standard price, actual invoice price, actual quantity purchased or consumed.
Last updated
Compare actual material price against standard cost Enter the standard price, actual invoice price, quantity, and any purchase adjustments to calculate direct material price variance, compare actual cost with standard cost, and see whether the materials price variance is favorable or unfavorable.
Display currency
Set the currency for material prices and variance outputs before entering standard-cost inputs.
Quick examples
Quantity basis
Most purchase price variance reports use quantity purchased; switch to consumed only when your policy measures the price variance at issue or usage.
Assumptions
The landed actual price equals invoice price plus total purchase adjustments spread across the entered quantity. Use positive adjustments for freight, duties, or handling and negative adjustments for rebates or supplier credits. Quantity variance, mix variance, and yield effects are separate calculations.
Result
$9,900.00 unfavorable price variance
Actual landed spend of $125,100.00 versus standard spend of $115,200.00 on 18,000 purchased units.
Variance per unit
$0.55
Variance percent
8.59%
Landed actual price
$6.95
Adjustment effect
$0.00
Unfavorable price variance Actual landed price came in above standard by 0.55 per unit on the actual quantity purchased.
Standard view
$115,200.00
$6.40 standard price on 18,000 units.
Actual view
$125,100.00
$6.95 invoice price plus $0.00 adjustment per unit.
Variance bridge
Standard price per unit
$6.40
Actual invoice price per unit
$6.95
Adjustment per unit
$0.00
Landed actual price per unit
$6.95
Actual quantity purchased
18,000
Direct material price variance
$9,900.00
Scenario comparison
Use these rows to see how freight, duties, handling, rebates, or supplier credits change the materials price variance.
Scenario
Actual price
Variance
Status
Current landed priceInvoice price plus purchase adjustments.
$6.95
$9,900.00 $0.55 per unit, 8.59%
Unfavorable price variance
Invoice price onlyExcludes freight, duties, handling, rebates, or other purchase adjustments.
$6.95
$9,900.00 $0.55 per unit, 8.59%
Unfavorable price variance
At standard priceShows the zero-variance benchmark for the same quantity.
$6.40
$0.00 $0.00 per unit, 0%
On standard
What to check next
Investigate supplier price increases, smaller order quantities, lost discounts, expedited freight, duties, handling costs, or specification changes.
Separate controllable purchasing issues from market-wide raw material price changes before assigning responsibility.
Check whether selling prices, budgets, or standard costs need updating if the higher landed cost will continue.
Direct material price variance calculator guide: compare standard cost with actual
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.
Landed actual price = Actual invoice price + (Freight, duties, handling, rebates, or credits / Actual quantity)
Use this when the purchase price variance should include landed-cost adjustments rather than invoice price alone.
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.
When to include freight, duties, handling, rebates, or credits
Many real materials price variance reviews start with an invoice price, then ask whether freight-in, import duties, handling, supplier credits, rebates, or expedited-delivery charges should be included in the actual price. The calculator's purchase adjustment field lets you spread those total adjustments across the entered quantity so the final comparison uses a landed actual price.
A positive adjustment increases the actual landed price and can turn a favorable invoice price into an unfavorable materials price variance. A negative adjustment reduces the landed price and can show the effect of a supplier credit or rebate separately from the invoice price.
Purchased quantity versus consumed quantity
Direct materials price variance is commonly calculated at the time of purchase using the actual quantity purchased. That keeps the price variance focused on purchasing performance and separates it from the later material quantity or usage variance.
Some organisations calculate the price variance when materials are issued or consumed, especially when inventory is not carried at standard cost. If that is your policy, use the same formula but label the quantity as consumed rather than purchased. The key is to keep the price basis consistent with your management accounting policy.
Common causes of favorable and unfavorable materials price variance
A favorable direct material price variance can come from bulk purchase discounts, better supplier negotiation, cheaper substitute materials, rebates, or a fall in market prices. It is useful, but not automatically good: lower-priced materials may also create later quality, scrap, delivery, or usage problems.
An unfavorable variance can come from supplier price increases, lost discounts, smaller order sizes, expedited freight, duties, handling charges, specification changes, or raw material market pressure. The calculator separates invoice price from adjustments so you can see whether the issue is supplier rate, landed cost, or both.
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.
A good variance review also asks whether the standard price is still realistic. A one-off supplier surcharge may belong in a purchasing follow-up, while a sustained market price increase may require updating budgets, selling prices, or standard costs.
Further reading
OpenStax - Managerial Accounting — OpenStax managerial accounting text covering manufacturing costs, standards, and variance analysis concepts.
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.
Should freight and duties be included in direct material price variance?
Include freight, duties, handling, rebates, or supplier credits when your standard-cost policy treats those items as part of the landed material price. Enter positive adjustments for added costs and negative adjustments for rebates or credits.
What is the difference between invoice price and landed actual price?
Invoice price is the supplier's quoted or billed price per unit. Landed actual price adds allocated purchase adjustments such as freight, duties, handling, or credits, which can change the final materials price variance.
What causes an unfavorable direct materials price variance?
Common causes include supplier price increases, smaller order quantities, lost purchase discounts, expedited freight, duties, handling costs, market shortages, or a higher material specification than the standard assumed.
Can a favorable materials price variance be bad?
Yes. A lower purchase price can be helpful, but it may also reflect lower material quality, delayed delivery, or a substitute material that creates scrap or usage problems later. Review quantity and quality outcomes before treating it as a pure win.
