Supply Chain & Procurement calculator

Purchase Price Variance Calculator

Purchase price variance (PPV) measures the difference between what you actually paid for a material and the standard or quoted price you expected to pay. Procurement, cost accounting, and finance teams use it to track buyer performance, spot supplier price creep, and reconcile standard-cost systems. A favorable variance means you beat the standard; an unfavorable one means costs ran over budget and margins are at risk. Tracked over time and by commodity, PPV is one of the cleanest signals of whether your sourcing strategy is actually saving money.

What this calculator does

  • Calculate purchase price variance from standard spend and actual spend.
  • Use it when purchase price variance in supply chain and procurement needs a clean margin number for a supply chain and procurement go / no-go review.
  • It computes the variance between the actual price paid and the standard price, showing the per-unit gap against a reference baseline.

Formula used

  • Margin = gain or available amount - cost or required amount

Inputs explained

  • Actual price paid per unit:
  • Standard or quoted price per unit:
  • Standard cost reference baseline:

How to use the result

  • Use it at PO close or period-end to compare paid prices against standard cost and evaluate sourcing and buyer performance.
  • PPV alone doesn't explain the cause — a variance can come from market moves, volume changes, spec changes, or FX, so investigate before rewarding or penalizing a buyer.

Current U.S. benchmarks

  • U.S. manufacturing runs at 75.6% of capacity (Federal Reserve, May 2026). New factory orders are up 2.3% year over year (Census).
  • Sourcing currencies as of 2026-07-02 (Federal Reserve H.10): 6.7886 CNY and 17.4524 MXN per USD. Landed-cost comparisons move with these daily rates.
  • U.S. iron and steel imports ran $2.1B in May 2026 (Census International Trade). The U.S. ran a trade deficit of $0.4B in the category that month. Import volumes are the pressure gauge behind tariff and reshoring decisions.

Common questions

  • How do you calculate purchase price variance? Subtract the standard price from the actual price paid. In this example, 125 minus 100 gives a 25-unit variance against the reference baseline.
  • What is a favorable vs unfavorable PPV? Favorable means you paid less than standard (cost savings); unfavorable means you paid more (cost overrun). The direction depends on which value is higher — a 25 gap where actual exceeds standard is unfavorable.
  • What is a good purchase price variance? As close to zero as possible if your standards are accurate, or consistently favorable if you're beating them. Large swings in either direction usually mean your standard costs are stale, not that buying suddenly got great or terrible.
  • Why compare against a standard cost baseline? The standard is the budgeted price your financial plan assumes. Measuring actuals against it tells finance whether material costs are tracking to plan and where margins are eroding.
  • What causes a large purchase price variance? Commodity price moves, currency shifts, buying off-contract, volume tier changes, rush orders, or an outdated standard cost. Always decompose the variance before assigning blame or credit.

Last reviewed 2026-05-12.