Costing & FinanceFree calculatorPDF, Excel, Word export

Purchase Price Variance Calculator

Purchase price variance is the difference between what you paid and what you planned to pay, multiplied by the quantity. This calculator gives the variance for a receipt, the percentage, and a projection for the year, plus a chart showing how sensitive it is to price.

Your numbers

Standard price per unit

The planned or standard cost set for the period

Actual PO price per unit

The price on the purchase order or invoice

Quantity purchased

units

Annual purchase quantity

units

Used to project the yearly effect

Share of this receipt still in stock

35 %

Useful for seeing how much variance has not yet hit the product cost

Your results

Purchase price variance (this receipt)

$3,600

Positive means unfavorable (paid more than standard). Negative means favorable.

Projected annual PPV

$43,200

Variance per unit

Percent variance

7.2%

Variance tied to stock on hand

$1,260

The portion of this receipt's variance that relates to units not yet consumed.

Price to bring PPV to zero

$13

Sign convention here: positive PPV is unfavorable (actual above standard). Some ERP reports show the opposite sign. Check how your system posts price differences before comparing.

Save results:

PPV on this receipt as actual price changes

Sweeps Actual PO price per unit from 8 to 18, holding your other inputs fixed.

See PPV by item and supplier in your ERP

Optional: a short review of how to report price variance without exporting spreadsheets.

Optional. The tool and every export work without this. No spam.

How to use the PPV calculator

Enter the standard price per unit, the actual price on the purchase order, and the quantity you bought. Add your annual purchase quantity to see the year-end effect, and use the stock slider to estimate how much of the receipt is still on the shelf. The calculator returns variance per unit, total PPV for the receipt, percent variance and the projected annual PPV. The chart sweeps the actual price from low to high so you can see how a price increase or a negotiated discount would change the number before you commit to it.

The formula and sign convention

PPV equals actual price minus standard price, multiplied by quantity purchased. If you paid more than standard, the variance is unfavorable and shows as a positive number here. If you paid less, it is favorable. Under standard costing, inventory is received at standard and the difference goes to a price variance account, so PPV is visible at the time of receipt or invoice. Under actual or moving average costing there is no PPV in the same sense, because the price flows into inventory value. Always check which method your company uses, since the same price move will show up in different accounts.

PPV = (actual price - standard price) x quantity
Positive here means unfavorable
Standard costing posts variance at receipt or invoice
Moving average costing spreads it into inventory value

Reading the result

A single receipt variance is only a data point. Look at percent variance to see how far the supplier is from plan, and annual PPV to see the budget effect. A small percentage on a high-volume part can matter more than a large percentage on a rarely bought one. Repeated unfavorable PPV on one part usually means the standard is out of date, not that buying is failing. If the standard was set a year ago and metal prices moved, update it. If the price is above a contract price, that is a compliance issue to raise with the supplier or the buyer.

Common mistakes

Teams often blame buyers for PPV that comes from an old standard. Others forget freight, duty and rebates, which can move the true price in either direction. Mixing units of measure is another source of false variance, for example a standard per piece against a price per hundred. Finally, comparing PPV across periods without adjusting for volume mix makes the trend misleading. Report PPV by part and by supplier, and review standards at least once a year.

Frequently Asked Questions

What is purchase price variance?

Purchase price variance is the difference between the actual price paid for materials and the standard price set in the cost system, multiplied by the quantity bought. It shows whether purchasing came in above or below plan for the period.

Is positive PPV good or bad?

It depends on the system's sign convention. In this calculator, positive means the actual price was higher than standard, which is unfavorable. Many accounting reports show unfavorable variance as a debit. Check how your ERP displays it before comparing numbers.

Does PPV apply to moving average costing?

Not in the same way. With moving average cost, the actual price goes into the inventory value and the item cost changes. PPV as a separate account is a feature of standard costing, where the item is held at a fixed standard.

How often should standards be updated?

At least annually, and sooner for commodities that move fast, such as metals or electronic components. Persistent unfavorable PPV on a part is a sign that the standard no longer reflects the market and needs a review.

If your ERP posts price variances by item and supplier, Netray can help you build a read-only view that flags parts whose standard has drifted from the market.

Talk to an Expert Explore More Free Tools

Related Tools

Costing & Finance

More Costing & Finance tools

See all

Back to All Tools