Syntha Lab RU

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.

Assortment and sizes For whom: Category managers and assortment heads who decide which SKU tail to cut.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Fixed cost per SKU per season₽45,000The 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%40If 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

StepFormula
Band contributionrevenue × contribution margin
Fixed costs45,000 ₽ × number of SKUs
Net resultcontribution − fixed costs
Cutting benefitfixed costs − (1 − 40%) × contribution
Revenue threshold per SKUfixed 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 and cutting benefit by band, m RUB
Bar chart: Band A 10.8, Band B 1.55, Band C −4.65−10−5051015Band ABand ANet result: 10.810.8Cutting benefit: −5.4−5.4Band BBand BNet result: 1.551.55Cutting benefit: 0.690.69Band CBand CNet result: −4.65−4.65Cutting benefit: 5.495.49
  • Net result
  • Cutting benefit
Data as a table
MeasureNet resultCutting benefit
Band A10.8−5.4
Band B1.550.69
Band C−4.655.49

Assortment bands

BandSKUsContributionFixedNetNet per SKUCutting benefitRevenue threshold per SKU
Band A6013.5 m ₽2.7 m ₽10.8 m ₽180,000 ₽−5.4 m ₽100,000 ₽
Band B905.6 m ₽4.05 m ₽1.55 m ₽17,222 ₽690,000 ₽112,500 ₽
Band C1502.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.

Terms used

Calculate on your data →