Syntha Lab RU

Season matrix: product season × sales month and stock against the window

From 12 months of sales in four groups (SS, AW, leftovers of past seasons, core) calculates the share of seasonal goods and leftovers by month and calendar season, how much of its sales each season makes inside its own window and whether the window is enough to sell the stock.

Season results: brand, category, SKU For whom: Merchandisers, planners and category managers when reviewing seasonality and leftovers.

Calculate on your data →

At a glance

What question does it answer?
What part of sales comes from seasonal goods, leftovers and core by month and whether stock fits in the season window.
What data is needed?
Sales for 12 months in four groups: SS, AW, past-season leftovers, core.
How to read the result?
On the default data (annual sales of 153.5m) seasonal goods give 68.4%, past-season leftovers 14.0%, core 17.6%. SS sold inside the February-July window is 87.2%, AW inside August-January 85.3%. The peak share of leftovers is in January: 29.2% of the month’s sales. In November AW has 3 months of window left: the window capacity is 11.1m against stock of 14m, beyond it 2.86m; past-season leftovers exceed the acceptable cover by 1.78m. In total beyond the window 4.64m at cost. Example on the default values: Share of seasonal goods (SS and AW) in sales: 68.4%; Share of past-season leftovers: 14%; Share of core and carried-over: 17.6%; SS sold inside its window: 87.2%. The figures are illustrative: enter your own to see your result.

Why and how to reason

Seasonal goods sell well inside their window and then turn into leftovers that get in the way of the new. To see this, sales are split into four groups: SS, AW, leftovers of past seasons and basic range, and the share of each group in the month’s sales is counted. Here seasonal goods (SS and AW) take 68% of sales, leftovers of past seasons 14%, basics 17.6%. The share of leftovers in January reaches 29%: almost every third January purchase is a clearance sale. Another question is whether goods are sold outside their window. SS sells inside the February to July window at 87%, AW at 85%. Finally, does the window suffice to sell the stock: window capacity equals sales in the window divided by window length, multiplied by the remaining months and by cost. Stock above capacity of 4.6 million at cost is goods that will most likely go to clearance.

When to use it

It fits when planning buying and markdowns: to align selling windows with the calendar and to see what share leftovers take. Do not use it without 12 months of data: a seasonal pattern cannot be caught on three months. Assumptions: the SS and AW windows are set by you, sales are split by four groups, cost in sales is constant. It is a good input for a talk with the buying team: it shows where windows diverge from the calendar.

How to read the result

Look at three things. The share of seasonal goods shows dependence on the calendar: 68% means a mistake in the window will hit two thirds of revenue. The peak share of leftovers (29% in January) shows when they get in the way of new goods: consider whether to clear the shelf in advance. “Stock beyond window and coverage” (4.6 million) is the main number for a decision: it is the sum that must either be sped up by selling or offset by postponing new buying. It is worth comparing the coverage of leftovers and basics with the allowed one and adjust the tolerance if your turnover is different.

Common mistakes

The usual mistakes: entering sales under the wrong groups (leftovers as seasonal), taking windows by habit and not from sales, counting stock at retail rather than cost, ignoring that the current month is unfinished. One wrong month number gives a wrong share.

What data is needed?

  • Sales for 12 months in four groups: SS, AW, past-season leftovers, core.
  • The SS and AW sales windows, the current month, the cost share.
  • Stock at cost by group and acceptable cover.

Inputs

FieldUnitValue in the exampleMeaning
SS: sales window, from monthmonths2Month number 1-12. The typical SS window in the Seasons reference: February-July; shift it for the regional climate and your logistics. The example value is illustrative.
SS: sales window, to monthmonths7The last month of the window. If below the start, the window crosses the year.
AW: sales window, from monthmonths8The typical AW window: August-January. The example value is illustrative.
AW: sales window, to monthmonths1The last month of the AW window; January is below August, so the window crosses the year.
Current monthmonths11Month number 1-12; the month counts in full. The example value is illustrative.
Cost of goods in sales%45The share of cost in sales excl. VAT: it converts stock at cost into sales. The example value is illustrative.
Acceptable cover for leftovers and coremonths4How many months of sales are acceptable to hold in groups without a window. There is no single standard in Russia: enter your own figure.
SS stock at cost₽8,000,000The SS group stock. Empty: the group is skipped. The example value is illustrative.
AW stock at cost₽14,000,000The AW group stock. Empty: the group is skipped.
Leftover stock at cost₽5,000,000Goods of past seasons that still lie in stock. Empty: the group is skipped.
Core stock at cost₽4,000,000Core and carried-over lines. Empty: the group is skipped.

How it is calculated

StepFormula
Shares by monthgroup sales in the month ÷ sales of all groups in the month
Inside the windowgroup sales in window months ÷ all sales of the group
Window capacitysales in the window ÷ window length × cost share × months left
Beyond the windowstock at cost − capacity, if above zero

Worked numbers

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

Share of seasonal goods (SS and AW) in sales
68.4 %
Share of past-season leftovers
14 %
Share of core and carried-over
17.6 %
SS sold inside its window
87.2 %SS sales in window months ÷ all SS sales. Tile colour: green from 80% (illustrative); compare with your own past seasons.
AW sold inside its window
85.3 %
Peak share of past-season leftovers
29.2 % · JanuaryThe month where selling leftovers takes the largest part of sales.
Stock beyond the window and cover, at cost
4.64 m ₽ · AW

Calendar seasons: sales mix

Calendar seasonSalesSeasonal goodsPast-season leftoversCore
Winter41.5 m ₽59 %21.7 %19.3 %
Spring35 m ₽74.3 %8.6 %17.1 %
Summer35 m ₽67.1 %15.7 %17.1 %
Autumn42 m ₽73.8 %9.5 %16.7 %

Group “AW”: stock 14 m ₽ at cost, the capacity of the remaining window or acceptable cover 11.1 m ₽; beyond it 2.86 m ₽. Decide ahead: a markdown window, a move to stores with better demand or a carried-over line.

Group “Past-season leftovers”: stock 5 m ₽ at cost, the capacity of the remaining window or acceptable cover 3.23 m ₽; beyond it 1.78 m ₽. Decide ahead: a markdown window, a move to stores with better demand or a carried-over line.

Stock against the window: SS the window has not opened (6 months), stock 8 m ₽, capacity 18.5 m ₽; AW in the window, 3 months left, stock 14 m ₽, capacity 11.1 m ₽; Past-season leftovers no window, cover, stock 5 m ₽, capacity 3.23 m ₽; Core no window, cover, stock 4 m ₽, capacity 4.05 m ₽.

The typical SS windows (sales February-July, deliveries December-April) and AW (August-January, deliveries June-October) come from the Seasons reference and shift with the regional climate and logistics; there is no single standard for windows. Calendar seasons: winter December-February, spring March-May, summer June-August, autumn September-November.

Nuances and limits

  • Shift the SS and AW windows for the regional climate and your logistics.
  • Enter past-season leftovers separately: otherwise they hide in the season’s sales.
  • The sales rate in the window is taken as even: it smooths the peak and the tail.
  • The acceptable cover is yours: there is no single standard.

Terms used

Calculate on your data →