Blog · Procurement and supply chain · Procurement
Purchase price variance compares actual purchase prices with standard prices at actual quantities. Work through a supplier and item report, reconcile the total, and separate price effects from quantity changes and invoice exceptions.
Purchase price variance is the difference between actual and standard unit price, multiplied by actual quantity purchased. It isolates the purchase-price effect at the quantity the company actually bought. A useful report shows the item, supplier, price basis and applicable standard behind every amount, then proves that the line variances equal the total cost difference.
Purchase price variance (PPV) = (Actual unit price − Standard unit price) × Actual quantity purchased
Equivalent check = Actual purchase cost − Standard cost of actual purchases
This article uses positive for unfavorable and negative for favorable. Paying above standard increases cost; paying below standard reduces it. The OpenStax treatment of materials price variance explains the actual-versus-standard comparison and its favorable and unfavorable interpretation.
The standard is the approved benchmark for the item and period. It is not automatically the last price paid, the lowest supplier quote or the current contract price. OpenStax describes standard cost as an expected cost established for comparison with actual results. Keep its effective date and approval basis with the report.
PPV also differs from the total spending variance against budget. Buying more units can raise spending even if every unit costs exactly the standard. The broader variance analysis guide separates price and quantity effects; the calculation here holds quantity at actual purchases.
Take one row per unique purchase transaction line. Keep document and line identifiers, transaction date, item, supplier, location, quantity, unit of measure, net purchase amount and currency. Bring the standard-price file with item, location where relevant, unit, currency and effective dates.
Choose a reporting basis before combining the files. For an invoice-based management report, actual unit price is net invoice amount divided by invoiced quantity. Use the corresponding receipt and order prices instead if the question concerns receipt-based PPV. Exclude recoverable sales tax, freight and rebates consistently with the standard, or put them on separate cost lines.
A management report does not automatically match a posted PPV account. For example, Oracle's standard-costing documentation calculates receipt PPV from purchase-order price versus standard cost and describes invoice price variance separately. Confirm your own system's basis before attempting a ledger tie. Covirage is not affiliated with Oracle.
The three-way match exceptions guide covers invoice, order and receipt discrepancies. An invoice can match its order perfectly and still be above standard cost.
An Ohio packaging company reviews four October purchase lines. All purchases are invoiced and received within the reporting period; order and invoice prices agree. Each item is measured in individual units, and freight and tax are excluded from both actual and standard prices. The standards remain unchanged throughout the period.
| Line | Item | Supplier | Actual quantity | Standard unit price (USD) | Actual unit price (USD) | Standard cost (USD) | Actual cost (USD) | PPV (USD) |
|---|---|---|---|---|---|---|---|---|
| A | Carton | Atlas | 1,000 | 4.00 | 4.20 | 4,000 | 4,200 | 200 |
| B | Carton | Beacon | 500 | 4.00 | 3.80 | 2,000 | 1,900 | -100 |
| C | Sleeve | Atlas | 800 | 2.50 | 2.75 | 2,000 | 2,200 | 200 |
| D | Sleeve | Beacon | 200 | 2.50 | 2.25 | 500 | 450 | -50 |
| Total | 8,500 | 8,750 | 250 |
For line A, the price gap is 4.20 − 4.00 = 0.20 per carton. Multiplying by 1,000 purchased cartons gives $200 unfavorable. Line B's gap is 3.80 − 4.00 = −0.20; multiplied by 500 cartons, that gives $100 favorable.
With the columns above in A:I and the first purchase in row 2, use these worksheet formulas and fill down through row 5:
G2 = D2*E2
H2 = D2*F2
I2 = (F2-E2)*D2
Quantities and prices in this example produce exact dollar amounts. Display unit prices to two decimal places and report percentages to two decimals; retain full precision when calculating real purchase lines.
The purchase-line check must work in both directions:
| Check | Calculation | Result (USD) |
|---|---|---|
| Sum of line PPV | 200 − 100 + 200 − 50 | 250 |
| Actual less standard cost | 8,750 − 8,500 | 250 |
| Unfavorable less favorable amounts | 400 − 150 | 250 |
| Reconciliation difference | 250 − 250 | 0 |
The worksheet reconciliation is:
=SUM(I2:I5)-(SUM(H2:H5)-SUM(G2:G5))
It must return zero at the report's currency precision; investigate any difference beyond rounding. Also reconcile the $8,750 actual amount to the selected purchase export and confirm that no transaction line disappeared or multiplied when the standard was added. Show missing standards as exceptions rather than inserting zero.
The total price variance percentage is 250 / 8,500 = 2.94% unfavorable. Its denominator is standard cost at actual quantities. Do not average the line percentages: the cost exposures differ.
Group the same four lines by supplier without changing their price basis:
| Supplier | Lines included | Standard cost (USD) | Actual cost (USD) | PPV (USD) |
|---|---|---|---|---|
| Atlas | A and C | 6,000 | 6,400 | 400 |
| Beacon | B and D | 2,500 | 2,350 | -150 |
| Total | A through D | 8,500 | 8,750 | 250 |
The item view gives cartons $100 unfavorable and sleeves $150 unfavorable. Both views reconcile to $250. Atlas merits review, but the figures do not prove overcharging: investigate specification, order size, freight basis and whether the standards are current. The nearby purchase price analysis guide covers comparing buying patterns beyond this standard-cost measure.
To test a proposed price change, change only line C's actual unit price from 2.75 to 2.60. Its actual cost becomes 800 × 2.60 = $2,080 and its PPV becomes $80 unfavorable. Total actual cost falls to $8,630 and PPV to $130 unfavorable, a $120 improvement at unchanged quantity and standard.
Bring your purchase-line workbook and dated standard prices, or a Google Sheet containing the comparable fields. Covirage maps the columns; its tools compute the price differences and check the totals, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for procurement teams for the purchasing context.
With actual price minus standard price, a positive variance is unfavorable because purchases cost more than the standard allows. Some reports reverse the subtraction. Always display the formula and favorable or unfavorable labels so the sign cannot be mistaken for savings.
Use actual purchased quantity for the purchase population being measured, with price and quantity expressed in the same unit. A receipt-based report uses received quantity and its applicable price. Budget quantity measures a different exposure and should not replace actual quantity in this calculation.
They can use different benchmarks. Purchase price variance compares purchase price with standard cost; invoice price variance commonly compares invoice price with purchase-order price. Confirm the definitions in your accounting system before comparing its posted variance with an invoice-based management report.
It proves that the selected prices were below the selected standard at actual quantities. Confirm that the standard is current, specifications are comparable, and quality or freight costs did not rise elsewhere. A favorable variance alone does not establish a negotiated saving or better total cost.