Vendor Spend Consolidation Analysis

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

Spend data:
{{vendor_category_annual_spend_number_of_p}}

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.

Copied to clipboard.

Why this 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.

Risks & review

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.