Category Risk Escalation

The Business Problem

Knowing where the risk sits — before the next tariff headline.

A tariff announcement lands on a Tuesday. By Wednesday, leadership wants a single number: how much of our spend is exposed? Most procurement teams can't answer that in the meeting — not because the data doesn't exist, but because their analytics was built to report what they spent, not to reveal where they're exposed.

Three questions drive every category risk conversation:

• How much of our spend is exposed to tariffs — sourced outside the US?
• Where are we dependent on a single supplier, with no fallback and no leverage?
• Where is price quietly eroding — PPV widening month over month while a quarterly summary still reads flat?

Spend visibility is table stakes now. But a spend cube is a rear-view mirror: it tells you what you bought and from whom, not where the exposure sits. Those risks live inside the spend, so they get discovered the hard way — after the fact. Executives need to see where the risk is; category managers need to know what to act on now. Both should be looking at the same numbers.

	Spend visibility — what most teams have	Risk escalation — what you actually need
The question it answers	What did we spend, and with whom?	Where are we exposed — and what's the next move?
Which way it looks	Backward — last quarter's invoices, already closed.	Forward — today's exposure and tomorrow's decision.
How it gets triggered	Someone asks, and you pull a report.	The risk surfaces itself and ranks by spend at stake.
What you leave with	A number to drop into a slide.	A prioritized action with an owner attached.

The Solution

A ranked view of where the risk sits — and what to do about it.

Built on spend, country-of-origin, sourcing, and price-variance data, the dashboard layers three risk lenses on top of clean, classified spend — each one invisible on a standard spend report:

• Tariff exposure — the share of spend sourced outside the US, the portion that reprices the moment a duty lands.
• Single-source concentration — where one vendor is the only vendor, so a disruption has no fallback and no leverage behind it.
• Price erosion — the widening gap between what you should pay and what you do, creeping up while a quarterly view reads as flat.

A sub-category risk matrix scores each of these, a supplier Pareto shows where the exposure concentrates, and the point isn't the heatmap — it's the escalation. Every flagged item resolves to a single recommended move, ranked by the spend behind it.

Category item	Spend at risk	Vendors	PPV	Risk	Recommended action
Specialty polymer, single grade	$$$	1	+16%	High	Renegotiate
Precision casting, ductile iron	$$	2	+11%	Medium	Dual-source
High-torque electric motor	$$	2	+12%	High	Run RFQ
Recurring facilities service	$	3	+7%	Low	Re-bid

Illustrative action list — each exposure lands as one recommended move, ranked by the spend behind it. Sample data.

Why It Matters

A ranked action list, not a lump-sum number.

A single spend total tells you almost nothing about where you're exposed. Breaking it down by risk lens, supplier, and SKU turns a category review into a short, ranked list of moves.

When a tariff or a supplier failure hits, the teams that move first aren't the ones with the most data — they're the ones whose analytics already told them where the exposure sat, and what to do about it. This project reflects my approach: understand the business pressure, build something actionable, and keep the path from data to decision short.