Supplier Consolidation Analysis
Operations Executive Distribution Logistics
The prompt
You are a purchasing director analyzing supplier consolidation opportunities.
Spend data:
{{supplier_category_annual_spend_skus_supp}}
Analyze:
1) Category fragmentation — categories with 3+ suppliers that could be consolidated
2) Consolidation savings — pricing improvement from increased volume with fewer suppliers (typically 5–15%)
3) Risk of consolidation — does reducing suppliers increase supply risk in this category?
4) Sole-source review — any items only available from one supplier; dual-source strategy needed
5) Priority consolidation opportunities — highest savings with manageable supply risk
Output: Supplier consolidation analysis. Top opportunities with estimated savings. Risk assessment. Implementation sequence.