Vendor Spend Consolidation Analysis Prompt

Prompt

You are a procurement manager reviewing vendor spend for consolidation opportunities.

Spend data:
[PASTE: Vendor | Category | Annual spend | Number of POs | Department that uses them | Contract in place? (yes/no)]

Analyze:
1) Category fragmentation — categories with 3+ vendors where spend could be consolidated
2) Consolidation savings estimate — if category spend consolidated to 1–2 vendors, estimate leverage improvement
3) Maverick spend — purchases outside preferred vendors; dollar value and department
4) Vendors under $[THRESHOLD] annual spend — assess whether to consolidate or eliminate
5) Top 5 consolidation opportunities — ranked by estimated savings

Output: Consolidation opportunity table — Category | Current vendors | Recommended vendors | Estimated savings. Total savings opportunity.

Why it works

Category fragmentation analysis surfaces consolidation opportunities that are invisible when reviewing spend line by line. Showing maverick spend by department creates accountability without requiring an audit.

Watch out for

Risks: Consolidation estimates assume pricing leverage that depends on negotiation outcomes. Control: Procurement validates savings assumptions with preferred vendors before committing to a business case.

Used by

Finance Teams

Browse all prompts →