Leak 04 · Pricing & Margin - Inconsistent pricing across similar customers
Two customers of the same size, buying the same item in the same quantity, pay prices that differ by 20%. Not by design. By accumulation.
Diagnostic note. Symptoms, required records, an initial check, and possible fixes. This shorter note does not include a full worked example.
What is it?
Prices for similar customers drift apart through years of individual quotes, special deals, and different salespeople with different habits. The spread is invisible in aggregate margin and only appears when you line customers up side by side. The low end of the spread is usually where the money is.
- Family
- Pricing & Margin
- Primary owner
- Pricing Manager
- Secondary owners
- VP Sales, Branch Managers
- Primary impact
- Gross margin
- Typical data source
- ERP invoice lines, customer master
- Detection difficulty
- 30-day measurability
Ask yourself
For your top 50 items, do customers of similar size and type pay within a defined band of each other?
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?
Warning signs. None of these proves the leak exists. They tell you where to look.
- Wide price ranges on the same item at similar quantities across customers of the same segment.
- Salespeople who cannot say what a “normal” price is for a common item.
- Customers who discover a peer’s price and ask for it.
What data do I need?
The minimum viable set. Most of it is already in your ERP.
| Field |
|---|
| Invoice line: customer, item, quantity, unit price, date |
| Customer segment or size band |
| Salesperson and branch |
The initial check
Start with a small sample. Gathering the exports, agreements, or observations is separate from running the check; agree that work with the person who owns the records.
- 1Pick your top ten items by revenue.
- 2For each, list every customer who bought it in the last quarter with quantity and unit price.
- 3Group by customer size band. Within each band, note the highest and lowest price and the spread as a percentage of the median.
Spread % = (highest price − lowest price) ÷ median price, within one size band
Then ask one question: Can anyone explain the bottom three prices in each band? If the answer is “history,” that is the leak.
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 below-band customers of (band floor price − actual price) × annual units × realistic recovery rate
Common root causes
Fixes fall into three layers. Not every problem needs software, and almost none needs AI first.
- Process
- No defined price bands by segment, so every price is negotiated from scratch.
- Data
- Customer segmentation is missing or stale, so “similar customers” cannot be identified in the system.
- Technology
- The quoting screen shows no reference to what comparable customers pay.
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 price-dispersion report for the top 100 items, by customer segment.
Level 2
Guardrails
Published floor and target prices by segment, with approval required below the floor.
Level 3
Workflow
Show comparable-customer prices inside the quote screen at the moment a price is entered.
Where AI helps
- Clustering customers into segments when the master data does not carry a usable one.
- Surfacing comparable transactions during quoting.
Where AI probably doesn’t
Defining what a fair price band is for each segment is a management decision, not a model output.
Before you call it a leak
- Some spread is legitimate: service levels, payment terms, freight arrangements, and volume commitments differ. Normalize for those before calling a low price a leak.
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 01 · PricingUncontrolled quote discountingSalespeople discount quotes without the discount buying enough extra win probability to justify the margin given away. Thousands of individually reasonable decisions add up.
- Leak 03 · PricingExpired customer-specific pricingA special price was agreed for a project, a period, or a volume commitment. The project ended and the price stayed. Nobody owns the expiry.
- Leak 05 · PricingPrice overrides without adequate controlsAnyone with order-entry access can change a price, and nothing records why. The override rate is the leak, and it is usually unmeasured.
Let’s start with one thing.
What would better performance look like?
Bring a result you want to improve, a symptom, or a workflow you already understand. You do not need to know the bottleneck yet. We’ll help choose what to investigate first.
No transaction files needed for the first conversation.