Syntha Lab RU

The trend share in the matrix and its life window: the share ceiling, the test batch, the chase order and the “rising / falling” signal

From the number of SKUs and the budget of the matrix, the trend SKUs and their budget it counts the shares and compares them with your ceiling; from the expected trend life, the lead time to the shelf, the test weeks and the reorder lead time it counts the selling window and the chase window; from the result of the test batch (sold, %) and the fading of the rate it determines the chase order in units and money; from a series of a signal index (queries, mentions, test sales) it determines the growth rate per week and shows whether the trend rises, falls or stands. It gives the decision: chase or not. The share ceiling, the life window and the test threshold are set by your policy, the calculation has no universal values; the default values are illustrative.

Collection and range For whom: Buyers, category managers, product managers and range directors who decide how much budget to give to a trend and whether to chase it after the test.

Calculate on your data →

At a glance

What question does it answer?
What share of the matrix and the budget the trend takes against your ceiling, whether a chase order has time to sell and what the signal series shows: rising, falling or flat.
What data is needed?
The number of SKUs and the budget of the matrix, the number and the budget of trend SKUs.
How to read the result?
Example at the default values (48 SKUs, 10 of them trend, a budget of RUB 14.4m against a ceiling of 20%): the share of articles 20.8%, of the budget 21%, a deviation of 1 pp; the window after arrival is 16 weeks, the chase window 9 weeks; 70% sold in the test; the signal rises by 4.3% a week; the chase order is 1,076 units worth RUB 2.04 million; the decision is “chase”. Example on the default values: Share of trend SKUs: 20.8%; Share of the trend budget: 21%; Deviation from the ceiling, pp: 1; Selling window after arrival, weeks: 16. The figures are illustrative: enter your own to see your result.

Why and how to reason

A trend gives interest but the risk is in the timing: it lives for weeks while production takes months. So the calculation is divided into three parts. The first is the share: 10 trend SKUs out of 48 are 20.8%, and their budget of RUB 3.02m out of RUB 14.4m is 21%; the policy ceiling is 20%, an excess of 1 pp The second is the window: the trend life was estimated at 26 weeks, 10 go before the shelf, 3 on the test and 4 on the reorder, which leaves 9 weeks of selling the chase. The third is the test: over 3 weeks at a rate of 14 units a week per SKU, 70% of 60 were sold, above the threshold of 60%. The chase equals the rate multiplied by the sum of weeks with a fade of 4% a week: 108 units per SKU, 1,076 units in all worth RUB 2.04m. The signal is taken from a series of an index: it grows by 4.3% a week.

When to use it

Apply when drawing up the matrix and before the chase decision, when there is an estimate of the trend life, the time to the shelf and at least four weeks of the signal series. The calculation does not guess a trend and does not give a universal ceiling: the ceiling, the test threshold and the window are set by your policy. For footwear the window is shorter because of production, for accessories the reaction time is longer, for children’s the season and the size run matter more than the trend.

How to read the result

Look at the decision and the reasons. The chase window is above zero (9 weeks), the test is above the threshold (70% against 60%), the signal rises (4.3% a week): a chase is possible. But after the chase the trend share of the budget will grow to 30.8%: this is above the ceiling, so the chase must be agreed as a separate budget or the SKUs cut. If the chase window is zero, release only the test batch. If the signal falls, chase only at a very high test result. The next step: update the estimate of the trend life by the test sales and revise the ceiling by the results of the season.

Common mistakes

They treat the trend life as a measured fact. They take the time to the shelf without certification and marking. They judge a trend by one week of the signal and by one source and take the seasonal growth of queries for a trend. They forget that the chase adds budget above the matrix and raises the trend share. They set the ceiling “like others” instead of by the results of their own past seasons.

What data is needed?

  • The number of SKUs and the budget of the matrix, the number and the budget of trend SKUs.
  • The estimate of the trend life, the time to the shelf, the test weeks, the test batch, the rate and the reorder lead time.
  • A series of a signal index by week: queries, mentions or test sales.

Inputs

FieldUnitValue in the exampleMeaning
SKUs in the matrixunits48All SKUs of the collection or the category the share is counted for. The example value is illustrative.
Of them trendunits10SKUs that you assigned to the trend by your own signs: silhouette, color, detail. The example value is illustrative.
Matrix budget₽14,400,000The purchase or production budget of the whole matrix at cost without VAT. The example value is illustrative.
Budget of trend SKUs₽3,024,000The part of the budget given to trend SKUs at cost without VAT. The example value is illustrative.
Ceiling of the trend share in the budget%20The largest share of the budget the brand is ready to give to a trend: it is a policy and not a norm; take it from the results of past seasons. The example value is illustrative.
Expected trend life from the decisionweeks26How many weeks, by your estimate, the trend will sell at the full price counted from the order decision date. An estimate and not a fact. The example value is illustrative.
Time from the decision to the shelfweeks10Development, production and delivery to the store or the marketplace warehouse. The example value is illustrative.
Test weeksweeks3How many weeks the test batch is sold before the chase decision. The example value is illustrative.
Test batch per SKUunits60How many units of one trend SKU were released into the test. The example value is illustrative.
Sales rate per SKUunits/week14The observed or expected sales rate of one SKU per week in the test. The example value is illustrative.
Reorder lead timeweeks4Weeks from the chase decision to the reorder arriving on the shelf. The example value is illustrative.
Weekly fade of the rate%4How much the sales rate falls per week towards the end of the trend life; zero if the rate holds. The example value is illustrative.
Threshold of sold in the test for the chase%60The share of the test batch sold over the test weeks from which you are ready to reorder; your policy. The example value is illustrative.
Unit cost₽1,900The cost of one unit of a trend SKU without VAT: the chase cost is counted by it. The example value is illustrative.
Signal threshold per week%3Growth or decline of the index per week above which the signal is read as “rising” or “falling”; below it “flat”. The example value is illustrative.

How it is calculated

StepFormula
Sharestrend articles ÷ all; trend budget ÷ whole budget; compare with the ceiling
Windowsafter arrival = life − time to the shelf; chase = after arrival − test weeks − reorder lead time
Testsold = rate × weeks ÷ test batch, not above 100%
Chaseper article = rate × (1 − (1 − fade)^window) ÷ fade; in total = per article × trend articles
Signalthe slope of ln(index) by week; growth = exp(slope) − 1
Decisionchase if the window is above zero, the test is not below the threshold and the signal is not below −threshold

Worked numbers

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

Share of trend articles
20.8 %
Share of the trend budget
21 %
Deviation from the ceiling, p.p.
1A plus means that the trend has been given more than the ceiling of your policy.
Selling window after arrival, weeks
16
Chase window, weeks
9The weeks in which a chase order still sells: the window after arrival minus the test weeks and the reorder lead time.
Sold in the test
70 %
Signal growth per week
4.3 %The signal: rising. The rate comes from the slope of the logarithm of the index by week.
Last weeks against the previous
17.6 %The average of the last 4 weeks against the average of the previous 4.
Chase order per article, units
108
Chase order in total, units
1,076
Cost of the chase
2.04 m ₽
Trend share of the budget after the chase
30.8 %The chase is counted as an additional purchase above the matrix budget.
Decision: chase (1) or not (0)
1Chase if there is a window, the test sold not below the threshold and the signal does not fall.
The signal index by week and the trend line
Line chart: Index: 100 → 148; Growth line: 100 → 146100110120130140150Week 1Week 3Week 5Week 7Week 9Week 10Index, Week 1: 100Index, Week 2: 106Index, Week 3: 111Index, Week 4: 109Index, Week 5: 120Index, Week 6: 127Index, Week 7: 131Index, Week 8: 128Index, Week 9: 142Index, Week 10: 148Growth line, Week 1: 100Growth line, Week 2: 104Growth line, Week 3: 109Growth line, Week 4: 113Growth line, Week 5: 118Growth line, Week 6: 123Growth line, Week 7: 129Growth line, Week 8: 134Growth line, Week 9: 140Growth line, Week 10: 146rel. unitsWeek
  • Index
  • Growth line
Data as a table
WeekIndexGrowth line
Week 1100100
Week 2106104
Week 3111109
Week 4109113
Week 5120118
Week 6127123
Week 7131129
Week 8128134
Week 9142140
Week 10148146
Trend share: articles, budget, ceiling, %
Bar chart: Articles 20.8, Budget 21, Ceiling 20, Budget after the chase 30.8010203040ArticlesArticlesShare, %: 20.820.8BudgetBudgetShare, %: 2121CeilingCeilingShare, %: 2020Budget after the chaseBudget after thechaseShare, %: 30.830.8%
Data as a table
MeasureShare, %
Articles20.8
Budget21
Ceiling20
Budget after the chase30.8

The trend budget 21 % is above the ceiling 20 %: cut the number of articles or the depth.

The calculation: the share ceiling and the test threshold are set by your policy, there are no universal values. The trend life window is an estimate from your signals and the experience of past seasons and not a measured fact. The signal is built on the logarithm of the index: growth “by so many percent per week” does not depend on the level. The chase is counted as an additional purchase. For footwear the window is longer because of production lead times, for accessories the time to the shelf is shorter, for children’s a trend rests on the season and the size run.

Nuances and limits

  • Treating the trend life window as a measured fact: it is an estimate and must be revised by the signal.
  • Reordering without the weeks for production and delivery: the trend is already fading on arrival.
  • Judging a trend by one week of the signal: a series and a rate are needed and not a peak.

Terms used

Calculate on your data →