Purchase Price Variance: Separate Price, Quantity and Mix

Supplier spending can rise because unit prices increased, more units were purchased or the product mix changed. A purchase price variance calculation isolates one part of that story. It is most useful when the quantity, unit, currency and baseline price are explicit.

This guide uses an illustrative management-analysis convention: price variance equals actual quantity multiplied by actual unit price minus baseline unit price. Some accounting systems use different timing or sign conventions. Match the organization’s adopted definitions before comparing reports, and do not treat this educational calculation as a required accounting entry.

Define the comparison population

Choose a product, supplier, period and purchasing stage. Ordered, received and invoiced quantities are different populations. A report based on receipts should not be compared casually with a budget based on purchase orders.

Use a consistent unit of measure. A supplier’s price per carton cannot be compared directly with an internal price per individual item. Document the conversion and whether pack size changed during the period.

Separate currency effects if purchases use different currencies. A higher converted cost can reflect exchange rates even when the supplier’s quoted local-currency price is unchanged. Keep the price review’s scope clear rather than assigning every movement to the buyer or supplier.

Work through a simple example

Suppose the plan called for 1,000 identical units at $8 each, giving planned spend of $8,000. Actual purchases were 1,200 units at $8.50, giving $10,200.

Using actual quantity for the price effect:

• Price effect: 1,200 × ($8.50 − $8.00) = $600 unfavorable.
• Quantity effect at baseline price: (1,200 − 1,000) × $8 = $1,600 unfavorable.
• Total change: $600 + $1,600 = $2,200, matching $10,200 − $8,000.

The arithmetic explains the spend bridge under these assumptions. It does not establish whether buying more was bad. Additional units may have supported higher sales, built needed safety stock or reflected an avoidable over-order.

Choose a sign convention readers understand

State whether positive means additional cost or favorable performance. Do not let one report show an unfavorable increase as positive while another labels the same number as a saving without explanation.

Use words beside the figure when ambiguity is likely. A table with “$600 additional price cost” is easier to interpret than a bare variance whose sign depends on an undocumented system convention.

Keep the full reconciliation visible. If the components do not add to the total spend change, investigate timing, rounding, freight, taxes, discounts or missing records rather than forcing an unexplained balancing line.

Handle multiple products at the right grain

Calculate like-for-like comparisons at the product level before aggregating. A total average purchase price can rise because the business bought more of an expensive model, even when every individual model’s price stayed unchanged.

For example, buying a larger share of high-capacity storage devices changes the mix. Comparing one blended dollars-per-device number would confuse a deliberate specification choice with supplier inflation.

Keep new products and discontinued products visible. If a product has no meaningful baseline, label its comparison separately instead of inventing a standard price to make the table complete.

Decide which costs belong in the price

Supplier invoice price, landed cost and fully allocated inventory cost are not the same measure. Freight, duties, rebates and other adjustments can change the unit cost being analyzed.

Define the included components once and apply them consistently. If a rebate is recognized later, explain whether the current variance is provisional or whether the baseline and actual both exclude it.

Do not compare a tax-inclusive actual with a tax-exclusive baseline. Likewise, a price quoted for a minimum order quantity may not apply to a smaller urgent shipment. Those conditions belong in the explanation of the variance.

Connect the calculation to an investigation

For significant changes, attach a concise reason supported by the purchase records: specification change, emergency shipping, contract increase, lost volume discount or data correction. Treat an unexplained variance as a question, not an accusation.

Ask whether the change is recurring and whether a future decision can influence it. A one-time rush shipment needs a different response from a permanent price increase or a repeated planning error.

Keep ownership practical. Procurement can explain supplier terms, operations can explain quantity needs and finance can reconcile invoices and accounting treatment. The bridge should help those teams collaborate rather than assign blame from one number.

Validate the source data

Check duplicate invoice lines, returns, credit notes, partial receipts and unit conversions. Preserve stable line identifiers so a correction can be traced back to the underlying transaction.

For a small review, recompute a sample manually and compare it with the report. Then reconcile period totals to the relevant source population before using the result in a management discussion.

Conclusion

Separate price from quantity using a stated formula and a consistent population. Analyze product mix and cost components before interpreting a variance as supplier inflation, procurement performance or a realized saving.