Cutting the long tail of a product range is a staple of value creation plans. Counting allocated cost as saved cost can more than double it.
SKU rationalisation adds EBITDA equal to the complexity cost you can actually remove, plus the margin on sales that migrate to the remaining range, minus the contribution the cut products used to earn. On an illustrative $200.0m business cutting 300 tail SKUs worth $10.0m of revenue, that is +$1.10m of EBITDA, about $12.1m of value at 11.0x, not the $2.70m the fully allocated product P&L suggests. The result turns on two inputs: the share of complexity cost that is truly avoidable and the share of tail sales that customers move to core products.
Worked in full in The Private Equity Operating Partner by Julian R. Sterling, with every figure reproduced in a free workbook.See the book on Amazon →
Every product range has a long tail: hundreds of SKUs that sell little, tie up inventory and cause changeovers on the line. Cutting them is one of the most common items in a value creation plan, and one of the most commonly overstated. The overstatement comes from treating allocated cost as saved cost.
| Input | Value |
|---|---|
| Revenue | $200.0m |
| SKUs in the range | 1000 |
| Tail SKUs to cut (30% of the range) | 300 |
| Tail revenue (5% of total) | $10.0m |
| Contribution margin, tail SKUs | 18% |
| Contribution margin, core SKUs | 35% |
| Tail revenue that migrates to core SKUs (recapture) | 40% |
| Complexity cost allocated to the tail (changeovers, planning, warehousing) | $3.0m |
| Share of that cost that is avoidable | 50% |
| General overhead allocated to the tail | $1.5m |
| Tail inventory, written down 30% on clearance | $6.0m |
| EV / EBITDA multiple | 11.0x |
Lost contribution = tail revenue × tail contribution margin = $10.0m × 18% = $1.80m.
Contribution, not gross margin after allocations, is the right measure: it is what disappears from EBITDA when the sale disappears, before any cost is taken out.
Recaptured revenue = $10.0m × 40% = $4.0m, sold through core SKUs.
Recaptured contribution = $4.0m × 35% = $1.40m.
Recapture is the input most worth testing with customers before the cut. A buyer who used a niche variant may switch to the standard one, buy it from a competitor, or move the whole account. Revenue falls from $200.0m to $194.0m, so the plan should show a revenue decline of $6.0m and explain it before the board asks.
Avoidable complexity cost = $3.0m × 50% = $1.50m.
The other half is shared capacity: the planner who also plans core SKUs, the warehouse lease, the line that runs anyway. It stays unless a second action removes it.
| Effect on EBITDA | $m |
|---|---|
| Contribution lost on the tail | −1.80 |
| Contribution recaptured on core SKUs | +1.40 |
| Avoidable complexity cost removed | +1.50 |
| Net EBITDA impact | +1.10 |
At 11.0x, $1.10m of EBITDA is worth $12.1m of enterprise value. Separately, clearing $6.0m of tail inventory at a 30 per cent discount releases $4.20m of cash and books a one-off $1.80m write-down, which belongs below the run-rate EBITDA line, not in it.
In Excel, with the inputs named: =-TailRev*TailCM+TailRev*Recapture*CoreCM+Complexity*Avoidable.
| Recapture | 25% avoidable | 50% avoidable | 75% avoidable |
|---|---|---|---|
| 0% | −1.05 | −0.30 | 0.45 |
| 20% | −0.35 | 0.40 | 1.15 |
| 40% | 0.35 | 1.10 | 1.85 |
| 60% | 1.05 | 1.80 | 2.55 |
With half the complexity cost avoidable, the cut breaks even at a recapture rate of 8.6 per cent. If only a quarter is avoidable, it needs 30.0 per cent recapture just to stand still. The programme's value sits in the cost-out plan, not in the SKU list.
The usual deck shows the tail on a fully allocated basis: $1.80m of contribution less $3.0m of complexity cost and $1.5m of general overhead, a loss of $2.70m. "Cut the loss-making products and EBITDA rises by $2.70m," worth $29.7m at 11.0x. That overstates the real effect by $1.60m, about 2.5 times the answer, because it assumes every allocated dollar leaves with the products and that no sale migrates. Allocated overhead never leaves on its own; it is redistributed to the core range, which then looks less profitable than it did.
The second mistake is ignoring the customers who buy the tail because they also buy the core. If cutting the range costs 2 per cent of core revenue, $3.8m from accounts that want a full catalogue, the lost contribution is $1.33m and the programme turns negative at −$0.23m. Core churn of 1.7 per cent wipes out the gain entirely. Map the tail SKUs to customers, not just to sales volume, before cutting.
For the value creation plan: book the gross contribution loss on day one, the recapture as it is observed in orders, and the complexity savings only when the cost line itself falls: a shift removed, a lease exited, a planner redeployed.
SKU rationalisation is a cost programme with a revenue risk attached. Net EBITDA = −lost contribution + recaptured contribution + avoidable cost, and on these figures it gives $1.10m, well under half of the $2.70m the allocated P&L promises. The same discipline of counting only what reaches EBITDA runs through how to calculate run-rate EBITDA and procurement savings and their EBITDA impact. How initiatives like this one are reconciled to the equity value actually created is built in the free value bridge workbook.
Because allocated costs do not leave with the products. In the illustrative case the tail shows a $2.70m loss after $3.0m of complexity cost and $1.5m of overhead, but only half the complexity cost is avoidable and 40 per cent of tail sales migrate to core products. The real gain is $1.10m of EBITDA.
It depends on the avoidable cost. With $1.80m of tail contribution lost and $1.50m of complexity cost removed, recaptured sales at a 35 per cent margin must cover $0.30m, a recapture rate of 8.6 per cent. If only a quarter of the $3.0m complexity cost is avoidable, the break-even rate rises to 30.0 per cent.
Yes, when customers who bought the tail also buy the core range and leave. In the worked case a loss of 2 per cent of core revenue, $3.8m, removes $1.33m of contribution and turns a $1.10m gain into a $0.23m loss. Mapping tail SKUs to customer accounts before cutting is the safeguard.
This article is one calculation from The Private Equity Operating Partner. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.
Get the book on Amazon →Free companion files
Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada
Reading guide: private equity and private markets → · All 1501 articles →
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.