Purchase prices

Purchase price variance software for purchasing teams

See which prices went up, which went down, and what the changes cost over a year at the quantities you buy. The Statadventure Optimization Lab reads the unit cost on each line of your purchase order history, so there is nothing to key in.

What tracking purchase prices does for you

Price increases rarely arrive as one big letter. They come a few percent at a time, on one item and then the next, and each one is easy to approve. A year later material cost is up and nobody can say where. The Purchase prices page lists every item whose last price differs from what you paid before, puts a yearly dollar figure on it, and totals it by supplier, so you know which conversations are worth having.

What the Purchase prices page shows

  • Price change by item. The last price paid against the average of the earlier buys in the period, as a percent.
  • What the change costs a year, at the quantity you bought in the period. Increases and decreases are totalled separately.
  • Purchase price variance (PPV). What you paid against the cost on your item list, in dollars and percent.
  • A table by supplier: spend, items raised and lowered, the average change and the variance.
  • Same item, different prices. Items you buy from more than one supplier, with the lowest-priced one named.
  • A unit-of-measure guard. A price more than 60% away from earlier buys is usually a case priced as an each. It is listed to check and left out of the totals.

The three measures

MeasureFormulaWhat it answers
Price changeLast price ÷ earlier average price − 1Is this item getting more expensive?
Change a year( Last price − earlier average ) × units bought a yearHow much is it worth arguing about?
Purchase price variance( Price paid − item cost ) × quantityAre my costs and margins still right?

Read our guide to the purchase price variance formula, or try the free PPV calculator.

How it works

  1. Load your PO history from Excel or CSV, or connect your ERP. Each line needs the item, the order date, the quantity and the unit cost. Add the item list for the variance against your costs.
  2. Choose the period (12 months to start) and the change worth flagging (3% to start).
  3. Start with the increases. They are sorted by what they cost a year.
  4. Download the table for your supplier reviews.

What it is not. It is not a quoting or sourcing tool, and it does not know why a price changed. It shows where to look and how much is at stake. If the cost on your item list is an average or a last cost rather than a standard, read the variance as the gap between what you paid and what your books carry.

Which plans include it

Purchase prices is on the Planner plan, at $850 a month, and the Growth plan, at $1,947 a month, with procurement and supplier scores. See plans and pricing.

See price changes on sample data

The live demo needs no account. Use the sample company or load your own files, which stay in your browser tab.

Frequently asked questions

What is purchase price variance?

The difference between what you paid for purchased items and the cost you expected to pay, usually the standard cost, times the quantity bought. A positive variance means you paid more.

Which price is compared with which?

For the price change, the last price paid is compared with the quantity-weighted average of your earlier buys in the period. For the variance, every price paid is compared with the cost on your item list.

What data do I need?

Purchase order history with the item, order date, quantity and unit cost on each line. An item list with unit costs adds the variance.

Does a price increase show up as a saving?

No. An increase is a cost to challenge, not money found. The page shows the yearly amount so you can decide which suppliers to talk to first.

What about freight or foreign currency?

The page compares the unit costs in your PO history as they are. If some lines include freight or are in another currency, convert them first, or expect those items to be flagged.

Scroll to Top