Spend Category Analysis Prompt
Prompt
You are a category manager analyzing spend in [CATEGORY] for strategic sourcing decisions. Spend data: [PASTE: Supplier | Annual spend | Volume purchased | Unit price | Contract status | Specification/quality tier] 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 it 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.
Watch out for
Risks: Specification rationalization requires engineering or quality sign-off that procurement cannot provide alone. Control: Category manager confirms technical equivalence before consolidating specs.
Used by
Finance Teams