Syntha Lab RU

New and carryover: share, return per SKU, sell-through and margin

Compares groups of SKUs of a season, for example new items, carryover (carried over from past seasons) and basics: the share in the range and in sales, sales per SKU, sell-through and margin. Shows which group gives a return above its share in the range.

Season results: brand, category, SKU For whom: Merchandise directors, category managers, heads of brands.

Calculate on your data →

At a glance

What question does it answer?
Which group of SKUs (new, carryover, basics) returns more than its share in the range.
What data is needed?
By group: SKUs, units delivered and sold, net sales and gross margin excl. VAT.
How to read the result?
On the example of 200 SKUs worth 105.6m new items (60% of SKUs) give 47.7% of sales, a return index of 0.80; carryover (30%) gives 36.4%, an index of 1.21; basics (10%) give 15.9%, an index of 1.59. Sales per SKU are 420,000, 640,000 and 840,000. Example on the default values: SKUs in total: 200; Net sales: RUB 105.6 million; Sell-through, total: 77.4%; Gross margin, total: 53.4%. The figures are illustrative: enter your own to see your result.

Why and how to reason

Each collection consists of new arrivals, carryover and basic items. They have different roles: new items create interest, carryover gives predictability, basics hold turnover. But the temptation is to measure them by total count whereas the return per slot in the assortment is what matters. Return index = group’s share of sales ÷ group’s share of items. In the example 200 items and 105.6 million of sales. New arrivals: 120 items (60%) give 47.7% of sales, index 0.80. Basics: 20 items (10%) give 15.9% of sales, index 1.59. Sales per item for new arrivals are 420 thousand, for basics 840 thousand. An index above 1 means the group sells more than its share of space. Sell-through (77.4% overall) and gross margin (53.4%) are also compared: a new item with good sales but low margin needs a separate conversation.

When to use it

Reach for it when planning the next collection: how many new items can be afforded and how much basics to keep. It suits a brand and a retailer with a private label. It does not suit a case without a group tag on each item. Assumptions: groups are defined by you (new means first time this season); sales net of VAT, profit gross; it does not account for new items supporting interest in the basics.

How to read the result

Look at the return index: below 1 for new items means they occupy more space than they sell. That is the normal price of novelty as long as it stays within your limits: decide how much under-return you are ready to tolerate for novelty. Compare sell-through and margin of the groups: if carryover is higher on both, increase its share in the next collection. The wider the spread of return per item, the more important it is to keep part of the assortment proven. The decision: revise the number of new items and the share of basics for the season. It is worth testing the result over several seasons: one season may be an exception.

Common mistakes

Counting any item in a new color as a new arrival. Comparing sales per item for groups with different time on the shelf. Concluding “new items are bad” from one season: they prepare the base and carryover for the next. Another trap: looking at sales but not margin: a new item with a heavy discount looks good on turnover and bad on profit.

What data is needed?

  • By group: SKUs, units delivered and sold, net sales and gross margin excl. VAT.

How it is calculated

StepFormula
Return index(group sales ÷ all sales) ÷ (group articles ÷ all articles)
Sales per articlenet sales of the group ÷ articles of the group
Margingross margin of the group ÷ net sales of the group

Worked numbers

Default values from the app; in the interactive version you enter your own.

Articles in total
200
Net sales
105.6 m ₽
Sell-through, total
77.4 %
Gross margin, total
53.4 %
Best return index
1.59× · Basics (permanent)Share of sales ÷ share of articles; above 1 means a return above the share.
Worst return index
0.8× · New items of the season
Sales per article: the best group
840,000 ₽
Sales per article: the weakest group
420,000 ₽

By group

GroupShare of articlesShare of salesReturn indexSales per articleSell-throughMargin
New items of the season60 %47.7 %0.8×420,000 ₽70 %50 %
Carryover30 %36.4 %1.21×640,000 ₽80 %55 %
Basics (permanent)10 %15.9 %1.59×840,000 ₽90 %60 %

The return index shows how much a group “earns its shelf”. A low index for new items is normal if they are needed to refresh the range; read it together with margin and sell-through.

The definition of carryover in your company may differ (by model, by colour, by seasons on sale). Fix it before comparing periods.

Nuances and limits

  • Not fixing what carryover is: the figures of different periods stop adding up.
  • Judging new items by the index alone: they are also needed to refresh the range.

Terms used

Calculate on your data →