Purchase price variance (PPV) is the difference between what you paid for purchased items and what you expected to pay, times the quantity you bought. It tells purchasing and finance whether material is costing more or less than the costs your prices and margins are built on.
The PPV formula
PPV = ( actual price − standard cost ) × quantity bought
A positive result is unfavorable: you paid more than standard. A negative result is favorable. Some companies write the formula the other way round, standard minus actual, so that favorable is positive. Either works: pick one and label it.
PPV % = PPV ÷ ( standard cost × quantity bought )
A worked example
An item has a standard cost of $10.00. In the year you bought it three times:
| Buy | Quantity | Price paid | Variance |
|---|---|---|---|
| February | 100 | $10.00 | $0 |
| May | 100 | $10.40 | +$40 |
| September | 200 | $11.00 | +$200 |
| Total | 400 | $10.60 on average | +$240 |
The PPV for the year is $240 unfavorable, or 6% of the $4,000 the 400 units should have cost.
PPV is not the same as a price increase
PPV compares what you paid with a standard. A price change compares what you pay now with what you paid before. In the example, the last price of $11.00 is 7.8% above the $10.20 average of the two earlier buys. At 400 units a year, that increase costs $320 a year from now on, whatever the standard says.
Change a year = ( last price − earlier average price ) × units bought a year
Use PPV to keep your costs and margins honest. Use the price change to decide which supplier to call.
What causes purchase price variance
- A supplier price increase, often passed on as a material, freight or tariff surcharge.
- Smaller orders. Buying below a price break, or paying a minimum-order charge. See EOQ vs MOQ.
- Rush buys. Expedite fees, air freight and spot buys from a second source.
- A different supplier or a substitute part at another price.
- Currency moves on imported items.
- A stale standard. If the standard has not been reviewed in two years, the variance says more about the standard than about purchasing.
- A unit-of-measure mix-up. A case entered as an each makes a huge variance that is not real.
How to track it
- Export your PO history with item, supplier, order date, quantity and unit cost.
- Compare each line with the standard cost for PPV, by item, supplier and month.
- Compare each item’s last price with its earlier average for price changes.
- Rank by dollars a year, not by percent. A 20% rise on an item you spend $50 a year on is noise.
- Check the outliers first. Anything more than about 60% off is usually a unit or data-entry problem.
- Review the largest increases with each supplier, and update the standards for the prices you accept.
What is a good PPV?
There is no universal benchmark, because it depends on how the standards were set. A steady drift in one direction means prices have moved, and your product costs, quotes and margins are out of date. Review price beside delivery and quality on your supplier scorecard, so a low price does not hide late or rejected deliveries.
Spreadsheet or software?
A pivot table of PO history does the job for a few hundred lines. It gets hard when items have several suppliers and units of measure. Purchase price variance software reads your PO history, flags the changes and totals them by supplier. For one item, use the free PPV calculator.
See price changes on sample data
The live demo needs no account. Use the sample company or load your own files, which stay in your browser tab.
Frequently asked questions
What is purchase price variance?
The difference between the actual price paid and the standard cost of purchased items, multiplied by the quantity bought.
Is a positive PPV good or bad?
With the formula actual minus standard, a positive PPV is unfavorable: you paid more than standard. Some companies reverse the formula, so check how yours is defined.
Who is responsible for PPV?
Usually purchasing, because it negotiates prices. But a variance can also come from rush orders, small order quantities or a standard that was set too low, which other teams control.
Try the Statadventure live tools
Inventory tools for US manufacturers: reorder point, safety stock, EOQ and landed cost, with the inputs and assumptions shown.
Open the live tools