Leak 17 · Suppliers & Procurement - Poor supplier consolidation
Six suppliers for one category, none reaching a volume tier, each shipping under the freight minimum. The spread was never decided. It accumulated.
Diagnostic note. Symptoms, the records to bring, and a practical first check with your team.
What is it?
Supplier spread grows through acquisitions, salesperson preferences, one-off sourcing, and inertia. It costs money through missed volume tiers and rebates, inbound freight on small POs, more receiving and AP work, and weaker negotiating position. It also has real benefits in resilience and customer preference, which is why it should be a decision rather than an accident.
- Family
- Suppliers & Procurement
- Primary owner
- Purchasing Manager
- Secondary owners
- CFO, Product Managers
- Primary impact
- Purchasing economics
- Typical data source
- Purchase history by supplier and product category
- Detection difficulty
- 30-day measurability
Ask yourself
For your top product categories, how many suppliers do you buy from, and does the spread cost you tiers, freight minimums, or rebates?
Yes, partially, no, or don’t know. “Don’t know” is the most useful answer, because it points at the test below.
What does it look like?
Look for these patterns, then use the check below to trace the issue in your own records.
- Categories with many suppliers and no primary.
- Many small POs under supplier freight minimums.
- Volume spread so that no supplier reaches a meaningful tier.
What data do I need?
The minimum viable set. Most of it is already in your ERP.
| Field |
|---|
| Purchases by supplier and category for 12 months |
| Supplier tier and freight-minimum terms |
| PO count and average PO value by supplier |
The initial check
Start with a small sample. Ask the person who owns the records to gather the exports and agreements, then work through these steps together.
- 1For your top three categories, list every supplier and annual purchases from each.
- 2Note the tier and freight-minimum terms of the two largest.
- 3Estimate what the category would earn in tiers and freight if 80% of volume went to those two.
Consolidation value = (tier saving + rebate uplift + inbound freight saving) − loss of any supplier-specific advantage
Then ask one question: Is the spread in each category a decision anyone made?
How much could it be costing us?
A conservative range, not a headline. The goal is a number management can trust enough to investigate.
Σ over categories of consolidation value × share of volume that can realistically move without customer impact
Common root causes
Fixes fall into three layers. Not every problem needs software, and almost none needs AI first.
- Process
- No category sourcing strategy or periodic supplier review.
- Data
- Purchases are not analyzed by category, only by supplier.
- Technology
- Buyers select suppliers item by item with no view of category volume.
What should we do?
Start with the simplest intervention that could solve it. Move down the list only if the one above is not enough.
Level 1
Visibility
A category-by-supplier purchase matrix, annually.
Level 2
Strategy
A primary and secondary supplier per category, with the reasons written down.
Level 3
Workflow
Replenishment defaults to the primary supplier and flags off-strategy buying.
Where AI helps
- Categorizing items and cross-referencing equivalent products across suppliers when the item master is inconsistent.
Where AI probably doesn’t
This is a sourcing decision. The purchase matrix and a meeting come first.
Before you call it a leak
- Customers often specify brands. Consolidation is limited by what they will accept.
- Single-sourcing creates supply risk. Keep a qualified secondary.
Think this might be happening in your business?
Turn the finding into a next step.
If the numbers say there is something there, send us what you found and we will help you decide whether it is worth a full investigation. No transaction files needed for that conversation.
Related leaks
- Leak 15 · SuppliersMissed volume discount thresholdsBuying 480 units at the 100-unit price when 500 would have earned the next break. Or buying 500 units of something that does not move to get the break. Both cost money.
- Leak 14 · SuppliersMissed manufacturer rebatesRebate agreements live in a filing cabinet. Purchases live in the ERP. The money you earned but never claimed lives nowhere, and it is often the largest single leak on this list.
- Leak 18 · SuppliersBuying the same product at inconsistent costsBranch A pays $14.20. Branch B pays $15.60 for the same item from the same supplier. Or the invoice says $15.60 and the PO said $14.20, and nobody checked.
- Leak 39 · DataDuplicate customer and product recordsAcme Mfg, ACME Manufacturing, and Acme Manufacturing Inc. Three records, three price files, three credit limits, and a sales report that shows none of them as your biggest customer.
Let’s start with one thing.
Give your team more time for the work that needs them.
Show us the quoting, order-entry, or follow-up work that keeps piling up. We’ll map it with you and find a practical place to start.
Start with a free workflow conversation with Alex.