Blog · Procurement and supply chain · Procurement
A procurement category dashboard compares purchasing spend, supplier concentration and comparable price movements. Use a worked example to separate category priorities from changes in quantity and purchasing mix.
A category dashboard compares procurement spend, supplier concentration and price changes across groups of purchases. It helps a category manager see where spending is large, where dependence is concentrated and where comparable prices are moving. Keep quantities and product mix visible so an increase in spending is not automatically called inflation.
In this context, a category is a purchasing market or related business need. Packaging, maintenance supplies and freight are useful examples because each has a different buying discussion. A category dashboard should help the person responsible for that discussion choose the purchases to examine.
The GSA describes category management as buying common goods and services across an enterprise, using purchasing data to manage suppliers and demand. The federal categories are not a mandatory taxonomy for a private company. Choose a structure that matches your own sourcing responsibilities.
Assign each invoice line to one category at the reporting level. Keep an unclassified bucket for unresolved lines rather than assigning them arbitrarily. When the mapping changes, restate the comparison or provide a bridge so a transfer between categories does not look like a change in purchasing behavior.
This page covers the quantitative overview. The written category review should explain market conditions, business requirements, trade-offs and proposed action. The dashboard supplies evidence for that review; it cannot supply a buying strategy from spend alone.
Start with a closed-period invoice export and a comparable earlier-period export. Each line needs an invoice identifier, date, supplier identifier, category, item or service specification, quantity, unit and net line amount. Keep currency and applicable credits explicit.
Use a supplier register to combine genuine name variants while retaining distinct legal suppliers where that matters. The supplier normalization guide explains the identity work. A category with several supplier names may still depend on the same underlying business.
For price comparisons, normalize pack sizes and units before dividing spend by quantity. A case and an individual item are different denominators. The supplier price and pack-size comparison covers those conversions in detail.
A US industrial distributor compares September 2026 purchasing prices with August prices. The table shows all September purchases in this small example, already matched to the same specifications and units in August. Net spend excludes recoverable tax, includes applicable credits and is entirely in USD.
The two packaging rows have different items and suppliers; the same is true in maintenance supplies and freight. Each supplier occurs in only one row here. Real exports can have many lines for the same supplier and item.
| Category | Supplier and item | September quantity | Unit | August price (USD/unit) | September price (USD/unit) | September spend (USD) |
|---|---|---|---|---|---|---|
| Packaging | Apex: box A | 10,000 | Each | 8.00 | 8.40 | 84,000 |
| Packaging | Beacon: carton B | 6,000 | Each | 10.00 | 9.50 | 57,000 |
| Maintenance supplies | Forge: bearing C | 500 | Each | 100.00 | 110.00 | 55,000 |
| Maintenance supplies | Toolway: seal D | 1,000 | Each | 20.00 | 22.00 | 22,000 |
| Freight | RouteCo: lane E | 400 | Shipment | 150.00 | 157.50 | 63,000 |
| Freight | ExpressCo: service F | 1,000 | Shipment | 30.00 | 31.50 | 31,500 |
| Total | 312,500 |
Do not total the quantities. Boxes, bearings and shipments do not share a meaningful unit. Instead, value the September quantities at both sets of prices, which holds the purchasing basket fixed.
Price effect (USD) = Current quantity × (Current unit price − Prior unit price)
Comparable price change = Total price effect / Current quantities valued at prior prices
| Item | September quantity at August price (USD) | September spend (USD) | Price effect (USD) |
|---|---|---|---|
| Box A | 80,000 | 84,000 | 4,000 |
| Carton B | 60,000 | 57,000 | −3,000 |
| Bearing C | 50,000 | 55,000 | 5,000 |
| Seal D | 20,000 | 22,000 | 2,000 |
| Lane E | 60,000 | 63,000 | 3,000 |
| Service F | 30,000 | 31,500 | 1,500 |
| Total | 300,000 | 312,500 | 12,500 |
The comparable price movement is 12,500 / 300,000 = 4.17%, rounded to two decimal places. This is the change for September's basket of purchases. It is not the change in total spending from August, because August quantities are not in this calculation.
The dashboard groups the same source rows into the following view. Supplier shares are rounded to one decimal place; price changes are rounded to two. Each percentage uses unrounded dollar amounts.
| Category | Spend (USD) | Largest supplier | Largest supplier share | Prior-price basket (USD) | Price effect (USD) | Comparable price change |
|---|---|---|---|---|---|---|
| Packaging | 141,000 | Apex | 59.6% | 140,000 | 1,000 | 0.71% |
| Maintenance supplies | 77,000 | Forge | 71.4% | 70,000 | 7,000 | 10.00% |
| Freight | 94,500 | RouteCo | 66.7% | 90,000 | 4,500 | 5.00% |
| Total | 312,500 | 300,000 | 12,500 | 4.17% |
For maintenance supplies, Forge's share is 55,000 / 77,000 = 71.4%. Its category price movement is 7,000 / 70,000 = 10.00%. That combination gives the category manager a concrete review: establish what changed on bearing C and seal D, then assess the available supply alternatives.
Packaging is the largest spend category, yet its net comparable price movement is smaller. Box A adds $4,000 while carton B offsets $3,000. A single category percentage can conceal that difference, so preserve the item view behind the summary.
The category spend check is 141,000 + 77,000 + 94,500 = $312,500, which must match the invoice control total. The price bridge also ties: 300,000 + 12,500 = $312,500. Supplier spend summed within each category must return its category total.
Keep governance status distinct from price movement. The spend-under-management invoice example shows how purchasing oversight is measured; it does not establish that a covered purchase has the best comparable price.
The category manager owns the sourcing recommendation, procurement operations maintains category and supplier mappings, and finance confirms spend treatment. This division supports the broader principle in the Census Bureau's objectivity guidance: reliable information requires sound methods and review. The guidance concerns Census information; the category checks here are a practical application of that principle.
Upload your categorized invoice exports and comparable item-price records to Covirage. Covirage maps the columns, its tools compute and check the category measures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for procurement teams for the purchasing context.
A category groups purchases that share a buying market or business purpose, such as packaging, maintenance supplies or freight. Assign each invoice line to one reporting category and keep the mapping consistent across periods so category totals remain comparable.
Match the same item, specification and unit across periods. Value current quantities at current and prior prices, then divide the difference by the prior-price value. Report unmatched purchases separately rather than treating a changed product mix as a price increase.
Yes. Show the largest supplier's spend as a share of the category, with its dollar amount. Review operational alternatives before deciding whether concentration is acceptable. Supplier count alone cannot show how strongly a category depends on one source.