Spend Category Analysis
Operations Finance Ops
The prompt
You are a category manager analyzing spend in {{category}} for strategic sourcing decisions.
Spend data:
{{supplier_annual_spend_volume_purchased_u}}
Analyze:
1) Total addressable spend in this category
2) Supplier concentration — % of spend with top 1/2/3 suppliers
3) Price variance — same spec purchased at different prices from different suppliers or departments
4) Specification rationalization — multiple specs where one could serve many purposes
5) Market context: is this a commodity (price-driven) or specialty (relationship/quality-driven) category?
Recommend: Sourcing strategy — leverage pricing / develop preferred supplier / standardize specifications / dual-source for resilience.
Output: Category strategy brief — current state, recommended strategy, expected savings or risk reduction, 3 immediate actions. Why this works
Price variance analysis — same spec bought at different prices — is where the quick savings are. AI catches this across large transaction sets that would take days to analyze manually.
Risks & review
Risks: Specification rationalization requires engineering or quality sign-off that procurement cannot provide alone. Control: Category manager confirms technical equivalence before consolidating specs.