Syntha Lab RU

Collection mix: core, fashion, image

For collection roles (core, fashion, image or your own) calculates the share of the buy, planned revenue and margin, turnover and the money at risk in leftovers, and compares the shares with your target ranges and the margin with your target. Thresholds are editable: there is no single norm for the mix.

Collection and range For whom: Category managers, buyers, merchandisers and product directors when planning the collection mix.

Calculate on your data →

At a glance

What question does it answer?
How the collection is divided among core, fashion and image, how much margin each role brings and how much money it holds in leftovers.
What data is needed?
By role: styles, the buy in units, price, cost.
How to read the result?
On the default data (three roles, buy at cost 34,980,000) planned revenue is 81,222,000, planned margin 56.9%. Fashion takes 48.9% of the buy, above the target of 25–45%. Core gives 21,480,000 of margin (46.5%). Money at risk in leftovers is 12,174,000 (34.8% of the buy): the most in fashion, 6,840,000. The loss on the leftover price reduction is 9,178,000. Turnover is about 2.0 turns a year: core 2.4, image 1.2. Example on the default values: Buy at cost, total: RUB 35 million; Planned revenue, total: RUB 81.2 million; Planned margin of the collection, %: 56.9%; Money at risk: leftover at cost: RUB 12.2 million. The figures are illustrative: enter your own to see your result.

Why and how to reason

A collection consists of roles: basics bring turnover, fashion brings interest, image brings the face of the brand. Roles have different profitability and different leftover risk, so the structure is built deliberately and not by accident. The calculation counts for each role buying (units × cost), planned revenue allowing for sell-through and markdown of leftovers, margin, money at risk and turnover. Example: fashion is bought for 17.1 million of 35 million, that is 48.9%, while your target range is 25 to 45%: the role is out of range. Money at risk is what will not sell as planned: for fashion (1 − 0.6) × 17.1 = 6.84 million. In total 12.2 million, that is 34.8% of buying against an allowed 30%. It is a signal to reduce fashion volumes or improve the forecast.

When to use it

Reach for it at the collection planning stage and when discussing budget distribution between roles. Do not use it as a norm: there is no single norm of structure, ranges and targets for margin and risk are yours. Assumptions: sell-through by role is known from past seasons, the markdown of leftovers is an average, the season is the same length for all roles. It is also handy for talking to buyers: the numbers by role turn an argument about taste into a conversation about money and risk.

How to read the result

Look at three signals. Roles outside your range of buying share (here one, fashion). The share of money at risk against allowed (34.8% against 30%). The role with the most money at risk (fashion, 6.8 million): the main loss will be here if wrong. Collection margin of 56.9% is above the 55% target, but it is computed at the planned sell-through, and the loss on markdown of leftovers (9.2 million) shows the price of a mistake. If risk is above the allowance, reduce the role volume or raise sell-through with the size run and timing.

Common mistakes

Taking sell-through from the best season, ignoring the markdown of leftovers, computing margin before discounts, treating roles as independent (image pulls basics). Ranges of shares are your target, not a law: change them consciously and record the reason. Do not set target ranges by habit: check them against the results of the two previous seasons.

What data is needed?

  • By role: styles, the buy in units, price, cost.
  • Full-price sell-through and the depth of the leftover price reduction for each role.
  • Your targets: the range of each role’s share of the buy, planned margin, the acceptable share of money at risk.

Inputs

FieldUnitValue in the exampleMeaning
Season lengthdays180Days from the collection arriving to the end of the season: turnover per year is scaled to them. The example value is illustrative.
Target planned margin of the collection%55Your target for margin in planned revenue; below it the calculation shows the gap. There is no single norm. The example value is illustrative. For footwear and accessories margin and price reductions differ from apparel: take your own. Optional. Empty: the field is ignored (counted as zero in sums).
Acceptable share of money at risk%30What share of the buy at cost you are ready to hold as leftovers at the end of the season. Your threshold, not a norm. The example value is illustrative. For children’s the leftover loses value faster (the child grows), for accessories more slowly: decide from your own data. Optional. Empty: the field is ignored (counted as zero in sums).

How it is calculated

StepFormula
Buy and revenue of a rolebuy × cost; revenue = units × (sell-through × price + leftover × price × (1 − reduction))
Margin and sharesrevenue − buy; a role’s share = role ÷ total
Money at risk(1 − sell-through) × buy at cost
Turnoversold at full price ÷ average stock, per year; average stock = buy × (2 − sell-through) ÷ 2

Worked numbers

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

Buy at cost, total
35 m ₽
Planned revenue, total
81.2 m ₽
Planned margin of the collection, %
56.9 %(Revenue − buy) ÷ revenue including the price reduction on leftovers.
Money at risk: leftover at cost
12.2 m ₽(1 − sell-through) × buy at cost.
Share of money at risk in the buy
34.8 %
Loss on the price reduction of leftovers
9.18 m ₽
Stock turnover, turns per year
22 × sell-through ÷ (2 − sell-through) per season, scaled to a year.
Role with the largest share of the buy
48.9 % · Fashion
Role with the largest planned margin in money
21.5 m ₽ · Core
Role with the most money at risk
6.84 m ₽ · Fashion
Roles outside your target share of the buy
1

Collection roles

RoleShare of stylesShare of the buyPlanned marginShare of marginTurns per yearMoney at riskAgainst your target
Core28.2 %42.9 %58.9 %46.5 %2.43.75 m ₽in target
Fashion63.4 %48.9 %54 %43.4 %1.76.84 m ₽above target
Image8.5 %8.2 %62.1 %10.2 %1.21.58 m ₽in target

The role “Fashion” takes 48.9 % of the buy, while “Core” gives 46.5 % of the planned margin in money. The leftover at risk is 12.2 m ₽ (34.8 % of the buy); the most is in the role “Fashion”.

The target share ranges, the margin target and the acceptable risk are yours: there is no single norm for the collection mix, the example values are illustrative. The calculation is linear: stock falls evenly to the leftover at season end; it smooths seasonal peaks. Amounts excl. VAT.

Nuances and limits

  • The targets for shares and risk are yours: there is no single norm for the collection mix, the example is illustrative.
  • Take sell-through from the role’s history, not from what you wish: it determines both the leftover and the margin.
  • The calculation is linear: it smooths seasonal peaks and late deliveries.
  • For footwear count width and depth by half sizes, for accessories without sizes, for children’s by height.

Terms used

Calculate on your data →