Manufacturing Cost Accounting & Finance calculator

Purchase Price Variance Calculator

Purchase price variance (PPV) is the difference between what you actually paid for a purchased material and the standard cost you set for it, multiplied across the volume bought. Procurement and cost accounting teams use it every period to measure buyer performance, flag supplier price drift, and explain why actual material cost diverged from the standard cost build. A positive PPV like the one here means you paid above standard, draining margin; a negative one means you beat standard. Loaded with inbound freight and duty, it becomes the true landed-cost variance rather than just the invoice line.

What this calculator does

  • Estimates the purchase price variance booked when actual paid price diverges from standard.
  • Use it to quantify a receipt's PPV and isolate how much of a margin miss is procurement-driven.
  • It computes the total purchase price variance dollars for a buy and the variance per unit, including a fixed freight and duty adder for landed cost.

Formula used

  • PPV = units purchased x price variance per unit x applicable share% + freight and duty
  • PPV per unit = total PPV / units purchased

Inputs explained

  • Units purchased in the period:
  • Actual minus standard price per unit:
  • Share of volume the variance applies to:
  • Inbound freight and duty adder:

How to use the result

  • Use it at period close, during supplier price negotiations, or when reconciling actual material spend against the standard cost in your BOM.
  • It treats the variance per unit as a single average; mix variances, FX swings, and tiered pricing can each move it, so decompose large totals rather than attributing them all to the buyer.

Current U.S. benchmarks

  • The U.S. prime lending rate is 6.75% (Federal Reserve via FRED, 2026-07-02). Payback and financing math should start from today's rate, not a remembered one.

Common questions

  • How do you calculate purchase price variance? Multiply units purchased by the per-unit difference between actual and standard price, scale by the applicable share, then add freight and duty. Here 5,000 x $0.85 x 100% + $1,200 = $5,450 total PPV.
  • What does a positive PPV mean? A positive (unfavorable) PPV means you paid more than standard cost. The $5,450 here is unfavorable: actual prices ran $0.85 over standard on every unit, eroding gross margin until standards are reset or prices renegotiated.
  • What is PPV per unit? Total PPV divided by units purchased. In the example $5,450 over 5,000 units is $1.09 per unit, which exceeds the $0.85 price gap because freight and duty load another $0.24 of landed cost onto each piece.
  • Should freight be included in PPV? Include it when you measure landed-cost variance rather than pure invoice price. The $1,200 freight and duty adder here turns a price-only gap into the real cost-to-shelf variance procurement is accountable for.
  • PPV vs material usage variance? PPV measures paying a different price than standard; usage (or quantity) variance measures consuming a different quantity than the BOM calls for. PPV is owned by procurement, usage by operations; keep them in separate accounts.

Last reviewed 2026-05-12.