Cost of assortment complexity: the SKU tail
For assortment bands (by revenue) counts the contribution, the fixed cost per SKU and the net result; shows what is better: to cut a band or to keep it if part of its sales moves to the remaining SKUs.
At a glance
- What question does it answer?
- Whether the assortment tail brings more than the fixed cost of its SKUs and what is better: to cut or to keep.
- What data is needed?
- The number of SKUs, revenue and contribution margin by band.
- How to read the result?
- Look at the cutting benefit of a band, not only at a negative net result: without flow-over a cut does not help. Example on the default values: Contribution of all bands: RUB 21.2 million; Fixed costs of SKUs: RUB 13.5 million; Net result of the assortment: RUB 7.7 million; Benefit of cutting the bands with a benefit: RUB 6.18 million. The figures are illustrative: enter your own to see your result.
Why and how to reason
Each SKU bears fixed costs, and the assortment tail pays only if its contribution exceeds them. In the example there are three bands of 60, 90 and 150 SKUs at RUB 45,000 per SKU and a flow-over of 40%: the net result is 7.7 m RUB, the cutting benefit of bands B and C is 6.18 m RUB, that is 240 SKUs of 300.
When to use it
Apply when reviewing the assortment for the season and when the number of cards grows faster than revenue. ABC classes and card labor are counted by abc and skucount, here the decision is in roubles.
How to read the result
Look at the cutting benefit of a band and the share of SKUs to cut: more than half requires checking the flow-over.
Common mistakes
The tail is called loss-making by revenue without fixed costs, the flow of sales is ignored, image SKUs are cut.
What data is needed?
- The number of SKUs, revenue and contribution margin by band.
- The fixed cost per SKU.
- The share of flowing sales.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Fixed cost per SKU per season | ₽ | 45,000 | The card, sample, photos, labeling and documents, minimum stock, accounting. Higher for sized goods. The example value is illustrative. |
| Share of sales that flows to the remaining SKUs | % | 40 | If a SKU is removed, this share of its buyers will buy another item instead of giving up the purchase. Estimate from analogs and substitution data. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Band contribution | revenue × contribution margin |
| Fixed costs | 45,000 ₽ × number of SKUs |
| Net result | contribution − fixed costs |
| Cutting benefit | fixed costs − (1 − 40%) × contribution |
| Revenue threshold per SKU | fixed cost per SKU ÷ contribution margin |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Contribution of all bands
- 21.2 m ₽
- Fixed costs of SKUs
- 13.5 m ₽
- Net result of the assortment
- 7.7 m ₽
- Benefit of cutting the bands with a benefit
- 6.18 m ₽
- SKUs to cut
- 240
- Share of SKUs to cut, %
- 80 %
- Revenue of the bands to cut, % of total
- 40 %
- Net result
- Cutting benefit
Data as a table
| Measure | Net result | Cutting benefit |
|---|---|---|
| Band A | 10.8 | −5.4 |
| Band B | 1.55 | 0.69 |
| Band C | −4.65 | 5.49 |
Assortment bands
| Band | SKUs | Contribution | Fixed | Net | Net per SKU | Cutting benefit | Revenue threshold per SKU |
|---|---|---|---|---|---|---|---|
| Band A | 60 | 13.5 m ₽ | 2.7 m ₽ | 10.8 m ₽ | 180,000 ₽ | −5.4 m ₽ | 100,000 ₽ |
| Band B | 90 | 5.6 m ₽ | 4.05 m ₽ | 1.55 m ₽ | 17,222 ₽ | 690,000 ₽ | 112,500 ₽ |
| Band C | 150 | 2.1 m ₽ | 6.75 m ₽ | −4.65 m ₽ | −31,000 ₽ | 5.49 m ₽ | 128,571 ₽ |
The cut proposes 240 of 300 SKUs, more than half: check the flow-over share of 40% and whether image SKUs that bring people into the brand are being cut.
Cutting benefit = the fixed cost of the band SKUs − the part of the contribution that will not flow over. A positive number means profit is higher without the band. The flow-over is taken at the same margin and without new fixed costs.
What to do with the result: start the cut with the band of maximum benefit, check its SKUs by size sales and by the role in the brand; repeat the estimate every season.
A typical mistake: calling the tail loss-making by revenue without subtracting fixed costs; ignoring the flow-over; cutting “image” SKUs.
Nuances and limits
- Calling the tail loss-making by revenue without fixed costs.
- Ignoring the flow of sales.
- Cutting image SKUs.