Purchase price variance calculator
- Purchase price variance
- $4,200.00 unfavorable
- Variance per unit
- $0.35
- Variance %
- 8.33%
Formula: PPV = (actual price − standard cost) × quantity purchased
Example
- Standard cost per unit ($)
- $4.20
- Actual price per unit ($)
- $4.55
- Quantity purchased
- 12,000
- Purchase price variance
- $4,200.00 unfavorable
- Variance per unit
- $0.35
- Variance %
- 8.33%
What the calculator works out
The calculator takes three numbers and gives you the price variance on a purchase. Standard cost per unit is what your records say the item should cost. You'll find it in the item master or cost record in your ERP, usually the cost the item was valued at when the receipt was posted. Actual price per unit is what the vendor charged on the invoice line, before sales tax. Quantity purchased is the number of units that price applies to.
The formula is PPV equals (actual price minus standard cost) multiplied by quantity purchased. Subtract the standard from the actual, then multiply by the quantity. If the answer is positive, the variance is unfavorable: you paid more than standard. If it is negative, the variance is favorable.
Two things make the result mean something. The standard cost and the invoice price have to be for the same unit of measure, and they have to be for the same item. A standard cost set per case against an invoice priced per each will produce a variance that is pure noise. So will a standard cost that was set two years ago and never revisited.
A worked example
The worked example uses a standard cost per unit of $4.20, an actual price per unit of $4.55 and a quantity purchased of 12,000. The standard cost comes from the item record. The actual price comes from the vendor invoice line. The quantity comes from the receipt or the invoice, as long as it is the same quantity the price applies to.
The calculation is ($4.55 minus $4.20) multiplied by 12,000. That gives a purchase price variance of $4,200.00 unfavorable. The variance per unit is $0.35 and the variance percentage is 8.33%.
In practice, the invoice was priced 35 cents a unit above standard on 12,000 units, so the ledger carries $4,200 more cost than the standard says it should. Nothing in that figure tells you why. It could be a real price increase, a contract price that never got applied, or an overcharge on the invoice.
Reading the result
Sign matters more than size at first glance. A positive variance is unfavorable because cost came in above standard. A negative variance is favorable. Before you treat a favorable result as good news, check that the standard cost is current. A favorable variance on an item whose standard cost is out of date usually means the standard is wrong, not that you got a bargain.
PPV is not the same as invoice price variance. PPV compares the price paid with the standard cost on your books. Invoice price variance compares the price paid with the price on the purchase order. Both are useful, and they answer different questions. PPV tells you whether purchasing and standard costing line up. Invoice price variance tells you whether the vendor billed what you ordered.
On contracted items, a large unfavorable variance deserves a look at the contract. It is one of the commonest places where money sits: a negotiated price that never made it into the PO or the item record, a surcharge the contract does not allow, or a quantity break that was not applied. The $4,200 figure above is the kind of number that gets written off as price movement without anyone opening the contract.
Standard costs need a review cycle. If they are not updated, PPV stops measuring anything useful and starts measuring how stale your cost record is. Teams that run this monthly usually pick a threshold and a review date rather than chasing every cent.
Where the inputs go wrong
The standard cost is the input that fails most often. People pull today's standard cost for an invoice posted three months ago, or they use the PO price as if it were the standard. Use the standard cost that was in effect when the transaction was recorded, and pull it from the item or cost record, not from the last invoice you saw.
Unit of measure is next. A vendor who quotes per 100 units, or per case, or per kilo will produce a variance that looks enormous and means nothing if the standard is per each. Check the invoice line UOM against the item record before you read the number.
Watch what is inside the actual price. Freight, duty, a one-time surcharge or a rebate that has not been credited will all move the variance. Decide once whether your standard cost includes those costs and apply the same rule to the actual price. Mixing the two produces a variance that no one can explain.
Finally, quantity. Using ordered quantity when the receipt was short, or invoice quantity when the invoice covers a different delivery, shifts the multiplication. Tie the quantity to the same document the price came from, and if a credit or a return is in play, check whether it has already been applied. A clean PPV starts with three inputs from three consistent sources.
Questions
What is the difference between purchase price variance and invoice price variance?
Purchase price variance compares the price you paid with the standard cost on your item record. Invoice price variance compares the price you paid with the price on the purchase order. Both use the same invoice line, but they test different things: PPV tests your standard cost, and invoice price variance tests whether the vendor billed what you ordered.
Is a favorable purchase price variance always good?
No. A favorable variance means you paid less than standard, but it can also mean the standard cost is too high or out of date. Check the standard before you book the result as a saving. If the standard is stale, the variance is a costing problem, not a purchasing win.
How often should standard costs be updated?
There is no single answer, but the useful rule is that a standard cost should be reviewed on a set cycle and whenever a contract price changes. If standards are not updated, PPV stops meaning anything and starts reflecting the age of your cost record. Pick a review date and stick to it.
Why is my PPV so large on a contracted item?
Large unfavorable variances on contracted items usually come from a contract price that was not applied, a surcharge the contract does not allow, or a quantity break that was missed. Pull the contract and compare the invoiced unit price with the agreed price. That check is where a lot of recoverable money sits.
Updated Nov 9, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.