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

Purchase price variance = ( price paid − standard cost ) × quantity bought
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

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
Scroll to Top