Purchase price variance (PPV): formula, example, and a free template

What purchase price variance means

Purchase price variance is the gap, per SKU, between the cost you expected to pay — your standard cost, usually set at the start of a budget period or contract — and the cost you actually paid, your actual cost, on a real purchase. It's a question a procurement analyst, buyer, or finance controller asks when reconciling what purchasing actually cost against what was planned, not just whether a supplier's list price moved.

The PPV formula

PPV = (Actual Purchase Cost − Standard Purchase Cost) × Quantity

A positive result is unfavorable — you paid more in total than standard cost would predict. A negative result is favorable — you paid less. A result of exactly zero means the actual cost matched standard, no matter how large the quantity.

Why quantity changes the picture

A tiny per-unit variance on a high-volume SKU can outweigh a large per-unit variance on a low-volume one — which is exactly why PPV multiplies by quantity instead of stopping at the percentage change. A 0.045 standard-cost bolt bought 50,000 times carries real budget weight even if its price never moves at all; a $0.90 increase on 500 units of a low-volume item is a smaller total dollar impact than a one-cent increase on 50,000 units of a high-volume one, even though the percentage increase looks far larger.

A worked example

Four rows from the downloadable template's example data — fictional, but shaped like a real purchase-cost reconciliation: one unfavorable increase, one favorable reduction, one item unchanged, and a second unfavorable item at a much smaller quantity.

Across just these four rows, the unfavorable items (+1,400 and +450) outweigh the favorable one (−1,440) by 410 — a net unfavorable position that a quick glance at percentage changes alone wouldn't surface, since the largest percentage move (−15%) belongs to the favorable item.

Why this matters to procurement and finance

A blended "spend is up 4% this quarter" number hides which specific SKUs drove it, and by how much. PPV broken out by SKU is what lets a buyer go to a supplier with the exact items and dollar amounts that moved, and what lets finance separate a real cost increase from a one-off purchase made off-contract, from a different supplier, or at the wrong quantity break.

The spreadsheet workflow — and where it gets fragile

For a short SKU list and one purchase per item per period, the template below is genuinely enough: standard cost, actual cost, and quantity in, variance calculated out. It gets fragile once the SKU list runs into the hundreds, a SKU is purchased more than once in the same period at different costs, standard costs need updating every budget cycle, or the comparison has to be rebuilt by hand every time a new purchase round lands — the same scale problem tracking a supplier's price changes over time runs into.

Where CostRift fits — and where it doesn't

CostRift's Price Change mode compares a previous cost file against a current one and flags every SKU that increased, decreased, or stayed the same, with the percentage change — automatically, whether the file has a dozen rows or a few thousand. Used with a standard-cost file as the "previous" side, that's the rate-variance half of PPV done for you, at any scale, instead of rebuilt by hand each round.

What it doesn't do: CostRift has no quantity field in Price Change, so it never produces a quantity-weighted dollar PPV total on its own — that multiplication happens in the template below, or in your own system. CostRift also has no ERP or accounting integration, doesn't post journal entries, doesn't reconcile against purchase orders, doesn't forecast a budget, and doesn't value inventory. For the selling-price side of a cost change instead of the purchase-cost side, see the margin impact calculator, and for the decision that follows a real supplier increase, see supplier price increase. Want to compare your standard and actual cost files on one pair before building the full template? The free old vs. new price list diff tool does that comparison with no signup.

Frequently asked questions