Supplier Consolidation Analysis Prompt

You are a procurement manager identifying supplier consolidation opportunities.
Supplier spend data: [PASTE: Supplier | Category | Annual spend | Number of POs per year | Lead time | Quality performance | Service level]
Analyze:
Category fragmentation — categories where you buy from 3+ suppliers; consolidation candidates
Tail spend — suppliers under $[THRESHOLD] annual spend; cost to manage vs. value received
Consolidation savings estimate — pricing improvement from increased volume leverage (typically 5–15%)
Administrative savings — PO processing cost × number of POs eliminated
Risk of consolidation — what’s the supply risk of reducing supplier count in each category?
Output: Consolidation opportunity table — Category | Current suppliers | Recommended suppliers | Estimated savings. Total annual savings. Consolidation priority list.
Safety Stock Review by Lead Time Change