Free purchase price variance (PPV) calculator
This free purchase price variance calculator shows how much more or less you paid than your standard cost, in dollars and percent. Add your earlier price and your yearly volume to see what a price change costs over a year. It runs in your browser.
Purchase price variance calculator
Estimates for planning only. Results depend entirely on the numbers you enter. Nothing you enter is stored or sent.
The formulas
Variance % = ( price paid − standard cost ) ÷ standard cost
Price change = price paid ÷ earlier price − 1
Change a year = ( price paid − earlier price ) × units bought a year
A worked example
An item has a standard cost of $10.00. You buy 200 at $11.00. The purchase price variance is ($11.00 − $10.00) × 200 = $200 unfavorable, or +10.0% of standard: you paid $2,200 for what should have cost $2,000. Your earlier buys averaged $10.20, so the price is up 7.8%. At 400 units a year, that increase costs ($11.00 − $10.20) × 400 = $320 a year.
Frequently asked questions
What is purchase price variance?
The difference between the price you paid and the standard cost, times the quantity bought. With this formula a positive result means you paid more than standard.
Is a favorable PPV always good?
Not always. A lower price from buying far more than you need, or from a supplier with late deliveries or poor quality, can cost more than it saves.
What is the difference between PPV and a price change?
PPV compares the price paid with your standard cost. A price change compares it with what you paid before. A standard can be out of date, so look at both.
Related
- Purchase price variance: formula, example and causes
- Purchase price variance software
- Landed cost calculator
- Tariff cost calculator
- All free supply chain tools
Want every price change in your PO history, ranked by what it costs a year and totalled by supplier? Purchase prices in the Optimization Lab does it, on the Planner and Growth plans.
Try the live demoSee plans and pricing