How to read your Procurement Cost Analysis

This guide explains what the report contains, how each section works, and what to do with the findings.

Looking for the quote normalization guide? Read the quote analysis guide →

On this page

1. What this report shows
2. The Executive Brief
3. Priority Actions
4. Material Cards
5. How savings are calculated
6. What to do next

1. What this report shows

The Procurement Cost Analysis report analyzes 12 months of your actual purchase order and invoice history (not vendor quotes) to show you how your material prices have moved over time, where you may be overpaying, and what actions are worth taking before your next purchasing cycle.

The report covers the materials that make up the largest portion of your ingredient spend. For each one, it shows volume patterns, price trends, and a specific recommendation on what to do next.

This report is based on your actual purchasing history. The findings reflect what you have paid and how your volume has moved, not a general market forecast. The recommendations are specific to your situation.

2. The Executive Brief

The top-level summary at the start of the report

The Executive Brief appears at the top of the report and leads with up to three headline numbers: the savings opportunity range over the review period, what flagged orders cost above the period average, and how many materials need attention. The breakdown and per-material summaries sit below as expandable sections.

Executive Brief with three headline numbers: savings range, paid above average on flagged orders, and materials needing attention — The Executive Brief leads with the headline numbers; the savings breakdown and per-material summaries expand below.

Savings opportunityThe floor estimate assumes all purchases had been made at the lowest observed price across materials with transactional data. The upper estimate adds a 20% negotiation premium, consistent with typical volume contract discounts.

Paid above average on flagged ordersFor each flagged order, the unit price above the period's average price times the quantity, added up. This is the money most directly worth raising with the vendor.

Savings breakdownExpandable table listing each material with price variation: volume, average price paid, best price paid, and estimated savings. Materials priced at ERP standard cost only are excluded from the savings total.

Per-material summariesExpandable one-paragraph read of each material's price trend and a brief recommendation.

The savings figures are floor estimates, not guarantees. They assume you could have bought everything at the lowest observed price in the period, which is not realistic in practice. Use them as a relative measure of which materials have the most pricing variation, not as a budget forecast.

3. Priority Actions

A ranked list of specific things to do before your next purchasing cycle

Priority Actions are ranked by the dollar value at stake. The main types:

Prices rising: consider a larger next order

Prices rose over the period. If cash and shelf life allow, a somewhat larger next order buys ahead of the trend.

Prices falling: consider a smaller next order

Prices fell over the period. A somewhat smaller next order avoids building inventory while they settle.

Above-average price: check how an order was priced

A specific order was priced well above the period average. Small, rush or spot orders often carry a premium; if none of those applies, it is worth asking the vendor how it was priced.

Priority Actions table with material, issue, what to do, above average, spend at stake and effort columns — Priority Actions are ranked by spend at stake. Each row names the material and vendor, the issue, and the next step; the full wording is under Full action notes.

The actions appear as a table: the material and vendor, the issue, what to do, how far flagged orders came in above the period average (for flagged-order checks), the material's total spend, and the effort. Click a material name to jump to its card. The full wording of each action is under “Full action notes” below the table.

Effort ratings are a guide, not a guarantee. “Low effort” means the action is a single email or call to your supplier: no contract negotiation, no switching costs. The hard part is deciding whether to act at all.

4. Material Cards

One card per material: trend, chart, and recommendation

After the Priority Actions, the report shows a full card for each material needing attention: one with a savings opportunity, a flagged order, or a priority action. Each card leads with its key numbers and a step-by-step recommendation, then stats and a price/volume chart. Every other material is listed once under “Other materials” with its spend and trend; open any of them to see the same card.

Trend badge

RisingFallingVolatileStable

For materials with invoice prices, the badge shows the price trend over the review period; for standard-cost materials it shows the volume trend, and the label above the badge says which. Rising and falling are directional. Volatile means significant swings with no clear trend. Stable means flat or nearly flat. Each badge carries a symbol and a word, so it reads the same without color.

Vanilla Extract material card with a flagged order, recommendation steps, stats and price chart — A card with a flagged order: one order came in $196 above the period average. The recommendation lists it first, then the next-order step and the lowest price paid.

Blanched Almonds material card showing a Rising price trend across two vendors — A Rising trend card: prices rose 17.3% over the period across two vendors. Each vendor has its own color and marker shape in the chart.

Total SpendSum of all purchase orders for this material in the review period.

Total VolumeTotal quantity purchased across all orders.

Period Low / HighLowest and highest unit price observed in any single purchase order.

Key numbersFlagged orders above average (what those orders cost above the period average) and the savings floor (if every order had matched the period low), when they apply.

RecommendationLabeled steps: Worth a look (each flagged order, with the price, the period average and the amount above it; small or spot orders often explain a premium), Next order (a somewhat larger or smaller order, or your normal cadence, based on the price trend), Price benchmark (the lowest price paid this period), or Data needed for materials with standard-cost data only. The analyst's written note is under “Analyst note”.

Vendor selectorFor materials purchased from multiple vendors, use the dropdown to see the chart for one vendor. The all-vendors view stacks volume bars by vendor and plots each vendor's price with its own marker shape and color.

Volume patternExpandable narrative of how purchase volume moved over the period.

Transaction detailExpandable table showing every purchase order in the period: date, vendor, quantity, unit price, and total. Flagged orders are marked with a flag symbol.

Materials showing “standard cost data only” are priced at a fixed ERP rate: your accounting system didn't capture the actual invoice price. No trend analysis is available for these materials. The recommendation is to collect supplier invoices on the next purchasing cycle so a real price review is possible.

5. How savings are calculated

Every savings figure in the report is calculated the same way: it asks what your total spend would have been if every purchase had been made at the lowest price observed for that material during the review period. That is the floor estimate.

The upper estimate in the Executive Brief adds a 20% negotiation premium on top of the floor; the idea being that in practice, a supplier negotiation might achieve prices below the floor by a further margin. The 20% is a general benchmark, not a guarantee.

Rising-price materials need different interpretation. When a material like almonds has been on a price uptrend, the savings figure reflects market exposure: the cost of the market moving against you, not a vendor negotiation gap. The report calls this out explicitly. A savings figure driven by a rising market should trigger a forward-buy, not a supplier negotiation.

The Assumptions & Notes section at the bottom of the report documents exactly how each figure was calculated, including which materials were included in the transactional floor and which were excluded because they only have standard cost data.

6. What to do next

A practical order for working through the Priority Actions:

Rising-price materials: timing matters most here, so look at these before the next order.
Falling-price materials: on your next normal order cycle.
Above-average orders: sooner is easier, while the order is recent.
Invoices for standard-cost materials: sharing them makes price review possible in a future engagement.

Questions about your report? If something looks wrong, is unclear, or you want to talk through a specific finding, reach out: info@charterandledger.com