Profit X-Ray
"Thousands of SKUs, and no idea which ones make money." A read-only margin map by product, customer and channel — because the blended gross margin on the P&L is an average of winners and losers, and nobody can see which is which.
The problem in one line
A business with a healthy 38% gross margin does not have thousands of products earning 38%.
It has a few earning sixty, a long tail earning nothing, and a set that lose money on every order — cross-subsidised by the winners, invisible inside the average, and often growing fastest, because nobody has a reason to stop selling them.
What the blended number hides
Customer profitability
20% → 225%
The most profitable fifth of customers generated 225% of total profit; the worst 10% destroyed 125% of it. Kaplan's Kanthal study — the original whale curve.
The catalogue
~30%
Of SKUs in US retail are slow-moving or unprofitable. The bottom half of a catalogue typically contributes under 5% of total margin while consuming a disproportionate share of operations.
Price leakage
16.3pp
Of list price lost to off-invoice deductions that appear on no invoice — rebates, settlement discounts, co-op advertising, freight, carrying cost. McKinsey's pocket price waterfall.
Cost to serve
>25%
Of one manufacturer's sales sat below the break-even margin once customer-specific costs — averaging 17% of target price — were properly allocated.
The four things actually going on
- The catalogue is a whale curve, not a bell curve. Cumulative profit rises steeply on the best products and customers, flattens across the middle, then falls as the loss-makers are added. Most businesses have never plotted it, so they manage as though every line contributes.
- Roughly a fifth of SKUs carry roughly four-fifths of gross margin. The rest justify themselves with "the customer expects us to stock it" — which may be true, and is a decision worth taking deliberately rather than by default.
- The price you charge isn't the price you keep. Off-invoice deductions are settled after the fact and booked company-wide, so they never land against the product or customer that caused them.
- Cost to serve varies far more than anyone assumes. Small orders, split deliveries, returns, technical support, bespoke packaging — these fall on some customers and not others, and are almost never allocated.
The same product, wildly different money
- McKinsey's lighting-company case found identical bulbs selling at anywhere from under 30% of list to over 90% — a threefold spread. Across their engagements they've seen the top pocket price run five or six times the bottom.
- The company's own explanation was volume discounting. It wasn't true: plenty of large customers paid high prices, while small ones with long relationships and the right phone number were working the discount structure. Nobody could see it, because nobody had built the picture.
- This is not a rare blind spot. In a 2025 survey of commercial leaders, 51% of businesses ran no price waterfall at all — no view of what happens between list price and the cash they actually keep.
Why it stays invisible
- The answer spans four or five systems that don't share a key. Revenue in the accounting system, cost in the ERP, discounts in the CRM or someone's inbox, freight in a carrier portal, rebates in a spreadsheet. Joining them is the work; no single system does it.
- Costs are allocated with a peanut-butter spread. Overhead apportioned by revenue share guarantees expensive-to-serve products look average and cheap ones look worse than they are. The allocation method manufactures the answer.
- Standard cost isn't actual cost. Most ERPs report a standard set once, which then drifts through input prices, exchange rates, changeovers, scrap and freight — while the P&L keeps reporting the old figure.
- Nobody owns the question. Finance owns the total, sales owns the revenue, operations owns the cost. Product-level profit sits between all three, so it belongs to none of them.
- Volume flatters everything. While the business is growing, the winners cover the losers and the question doesn't get asked. It gets asked the year growth stops — the worst year to start building the data.
What the X-Ray produces
- The margin map — every SKU, customer and channel ranked by actual contribution after real discounts, real freight, real cost to serve. Not the standard-cost version.
- The whale curve — cumulative profit plotted across the catalogue and the customer base. One chart showing exactly how much profit is being handed back, and by whom.
- The pocket-price band — the spread of realised prices on the same product across customers, outliers named. Usually the slide that stops the room.
- The tail — which lines earn nothing, what they cost to keep, and which are genuinely strategic rather than merely historic.
- The cross-subsidy map — which customers fund which, and what happens to the P&L if the loss-makers are repriced rather than dropped.
- The pricing scenarios — what a 2%, 5% or 10% move does by segment, given how each has historically responded on volume.
What it needs — read-only, days not weeks
| Source | What it gives |
|---|---|
| Sales / invoice ledger | Every transaction: product, customer, quantity, invoiced price |
| Product cost data | Standard cost, and where possible actual — landed, with freight and duty |
| Off-invoice deductions | Rebates, settlement discounts, co-op advertising, promotional allowances — the messiest input and the most valuable |
| Logistics / service data | Order counts, delivery drops, returns, support tickets — the cost-to-serve signal |
No integration, no build on the client side, nothing switched on. Exports in, analysis out.
Why the prize is disproportionate
The price lever
~8%
Operating-profit increase from a 1% price rise at average S&P 1500 economics — nearly 50% more than a 1% cut in variable costs, and three times a 1% volume gain.
Glass manufacturer
+60%
Operating profit within a year, from a 4% improvement in pocket margin after the analysis named which accounts sat below break-even.
Lighting supplier
+51%
Operating profit within a year, from a 3.6% improvement in realised price — achieved by fixing the discount outliers, not by raising list.
Complexity
100–400bps
Margin improvement from cutting SKU complexity, alongside 2–5 points of sales growth. Bain, consumer products.
- Price is the fastest lever there is, and the one most businesses touch last. A point found on price is worth roughly three times a point found on volume.
- It cuts both ways — a 1% fall in realised price takes about 8% off operating profit. Most companies are leaking that quietly through discount drift and never book it as a price cut.
- Complexity is expensive in ways nobody attributes to the catalogue — forecast error, working capital, changeovers, warehouse handling, support load. Bain puts the supply-chain cost of SKU complexity at up to 25%.
- And it is found money, not new money. Nothing here requires winning a customer. It requires seeing the ones you already have.
Who it's for
- Who: a business with a real catalogue and real transaction volume — distribution, wholesale, manufacturing, multi-line B2B product businesses. Anywhere the sales ledger runs to tens of thousands of lines and the price list has exceptions.
- The trigger to listen for: "we're growing but margin is flat", "we don't really know what that account is worth", "the price list is a mess" — or a finance director who can't answer the product-profit question without a fortnight's notice.
- What it is not: a system, a dashboard subscription or a data project. It is an analysis delivered by people, run on exports, presented once, and repeated quarterly only if it earns that.
Honest status. This play is designed, not built. Gold Digger Pro has a working method and a live engagement behind it; AI Visibility has a live client programme with measured data. Profit X-Ray has the method and the evidence base above, but no delivery behind it yet — and should be sold on that basis or not at all.
The way in: one client, one catalogue, a fixed-fee first cut with a stated question — which fifth of your lines carries your margin, and which are you paying to sell? The first delivery is the proof; the repeatable product comes after it.
The way in: one client, one catalogue, a fixed-fee first cut with a stated question — which fifth of your lines carries your margin, and which are you paying to sell? The first delivery is the proof; the repeatable product comes after it.
Sources
- McKinsey, "The power of pricing" — pocket price waterfall, 16.3pp off-invoice leakage, the price band, the glass and lighting cases, 1% price → ~8% operating profit. Read in full.
- Kaplan's Kanthal customer-profitability study — the whale curve: 20% of customers generating 225% of profit, the worst 10% destroying 125%.
- SKU rationalisation research — ≈30% of retail SKUs slow-moving or unprofitable; bottom half of catalogue under 5% of margin.
- Bain consumer-products research, reported 2025 — complexity reduction worth 2–5pp of sales growth and 100–400bps of margin; supply-chain cost up to 25%.
- Revology Analytics 2025 RGA maturity survey — 51% of businesses run no price waterfall.
Figures are industry benchmarks, not a promise. The client's own number is produced by the analysis.