Purchase price variance calculator: PPV from standard and actual price times quantity received, with favourable or unfavourable and annual exposure.
Free · no signup · runs in your browser·Updated
Short answer
Purchase price variance is the actual unit price minus the standard price, multiplied by the quantity received. Buying 48,000 units at $13.05 against a $12.40 standard gives $31,200 unfavourable, 5.2% above standard. Actual above standard is unfavourable, actual below is favourable. Annualised over 620,000 units that gap is $403,000.
Purchase price variance is the gap between what you planned to pay for a purchased part and what you actually paid, valued at the quantity you received. It is the cleanest signal finance gets that a standard cost no longer matches the market.
Enter the standard price, the price actually paid and the quantity received. The calculator returns PPV in currency, the variance as a percentage of standard, the annualised exposure if the gap holds, and whether the variance clears your materiality threshold.
Your numbers
$
The frozen price your BOM rollup used.
$
Same basis as the standard — landed or invoice, not one of each.
units
Received, not ordered. An open purchase order carries no variance.
units
Used to annualise the exposure if the price gap holds all year.
% of standard spend
Below this you note it; above this you investigate it. Most teams sit at 1–3%.
Result
Purchase price variance
$31,200 U
5.2% above standard on 48,000 units received
Variance per unit$0.65
Spend at standard$595,200
Actual spend$626,400
Annualised exposure$403,000
Materiality limit (2%)$11,904
Price move to return to standard−5.0%
F = actual below standard, U = actual above standard.
Basis
Units
At standard
Actual
Variance
Per unit
1
$12.40
$13.05
$0.65 U
This period
48,000
$595,200
$626,400
$31,200 U
Annualised
620,000
$7,688,000
$8,091,000
$403,000 U
actual − standard = $13.05 − $12.40 = $0.65 per unit
× 48,000 units received
PPV = $31,200 unfavourable (5.2% off standard)
$31,200 unfavourable clears your 2.0% materiality limit of $11,904, so this one gets investigated. If the $0.65 gap holds, annual exposure is $403,000 — reprice, requote or reset the standard rather than explaining it again next month.
Everything is computed in your browser. Nothing you type is sent anywhere or stored.
The formula
PPV = (Actual unit price − Standard unit price) × Actual quantity received
Actual unit price
What you actually paid per unit. Include freight and duty only if your standard is a landed standard.
Standard unit price
The frozen price in the item master that the BOM rollup used.
Actual quantity received
Quantity received in the period, not quantity ordered. PPV is recognised on receipt in most systems.
Sign convention matters. Written this way a positive result means you paid more than standard, which is unfavourable. Many reports flip the sign so favourable reads positive. Neither is wrong; both in the same pack is.
Worked example
Standard price
$12.40
Actual price paid
$13.05
Quantity received
48,000
Annual volume
620,000
Result
PPV = $31,200 unfavourable (5.2% above standard)
$13.05 − $12.40 = $0.65 per unit. Multiply by 48,000 units received and PPV is $31,200 unfavourable. Spend at standard would have been $595,200; you spent $626,400. Held for a full year at 620,000 units the same $0.65 gap is $403,000 — which is the number that belongs in the forecast, not the monthly variance.
Favourable is not the same as good
A favourable purchase price variance means you paid less than standard. That is all it means. It does not mean purchasing did well, and it does not mean the money is yours to keep. Four of the five common causes cost more than they save somewhere else in the business.
Cause of a favourable PPV
Is it actually good?
What to check
Negotiated a better contract price
Yes. Bank it and update the standard.
That the new price is contractual, not a one-off quote.
Bought a larger quantity to reach a price break
Only if you use it.
Carrying cost and obsolescence risk on the extra stock.
Switched to a cheaper grade or an alternate supplier
Rarely.
Scrap rate, rework and warranty claims one to two months later.
The standard was set above the market
No — it is a costing error.
When the standard was last rolled, and inventory value in the meantime.
Commodity index fell
Neutral. Nobody earned it.
Whether your contracts pass the fall through, and how fast it reverses.
Where PPV is recognised, and why the timing confuses people
Most ERP systems post purchase price variance at goods receipt, when the receipt is valued at standard and the difference against the PO price goes to a variance account. A second variance can appear at invoice matching if the invoice differs from the PO. That is why a month's PPV rarely ties to a month's purchasing activity: receipts and invoices land in different periods.
Measure on quantity received, not ordered. An open PO carries no variance.
Keep the basis consistent. If the standard is a landed standard, the actual price has to include freight and duty — work it out with the landed cost calculator.
Exclude one-time charges such as tooling, expedite fees and minimum-order surcharges. They are real costs but they are not price variance, and they make the trend unreadable.
Report by commodity, not by part. Fifty part numbers moving 4% because steel moved 4% is one story, not fifty.
From variance to forecast
The monthly figure tells you what already happened. The annualised figure tells you what happens if nothing changes, and that is the one the CFO wants. On the seeded numbers a $0.65 gap on 620,000 annual units is $403,000 — material enough to reprice, requote, or reset the standard. A $0.02 gap on the same volume is $12,400 and belongs in the noise.
Once you have the exposure, feed it back into the BOM cost rollup to see what the new price does to standard cost and to margin. A purchased part at 23% of unit cost passes most of its increase straight into your gross margin.
Pulling PPV by commodity for six periods is normally an export and a pivot table. With ERPray you ask for it: "purchase price variance by commodity for the last six months, quantity received basis" — computed from your own receipts and item standards, with the query shown so you can check which cost the standard came from.
Frequently asked questions
How do you calculate purchase price variance?
Subtract the standard unit price from the actual unit price and multiply by the quantity received in the period. At $13.05 actual against a $12.40 standard on 48,000 units, PPV is $31,200. Use quantity received rather than ordered, because that is when most systems recognise the variance.
Is a favourable purchase price variance good?
Not automatically. Favourable only means you paid below standard. It can come from a genuine negotiation, but equally from a cheaper grade that scraps more, an over-order placed to reach a price break, or a standard cost set too high. Always find the cause before crediting anyone with the saving.
What causes purchase price variance?
Supplier price changes, commodity index moves, currency movement on imports, expedited freight, buying outside a contract, quantity breaks taken or missed, and stale standard costs. The last one is the most common in practice: nothing on the shop floor changed, the standard simply stopped matching the market.
What is a good purchase price variance target?
Zero on average, with small variances in both directions. A standard cost that produces consistently favourable or consistently unfavourable variance is a broken standard, not a purchasing result. Most teams set a materiality threshold of 1–3% of standard spend and only investigate variances above it.
Should freight be included in purchase price variance?
Only if your standard cost is a landed standard that includes freight. Then the actual price must include it too. If your standard is the supplier invoice price, keep freight in a separate freight variance. Mixing the two bases makes PPV move whenever a shipping mode changes, which tells you nothing.
What is the difference between purchase price variance and material usage variance?
Price variance is about what you paid per unit: actual price minus standard price, times quantity received. Usage variance is about how much you consumed: actual quantity minus standard quantity, times standard price. One belongs to purchasing, the other to production. Reporting them together hides which is which.
This calculator needs you to find the inputs first. ERPray pulls them from your own ERP account and computes the answer live — with the exact query shown so you can check it.