Syntha Lab RU

A brand inside a multi-brand retailer: share of space and sales, margin and a decision

For brands inside one retailer calculates the share of sales and the share of space, margin including markdown support, sell-through, turnover and GMROI and suggests a decision: expand, keep or cut the brand; gives a space guide by margin share.

Wholesale terms and credit For whom: Category managers and buyers of multi-brand retailers, and brand managers and key-account managers when reviewing a brand’s position at a retailer.

Calculate on your data →

At a glance

What question does it answer?
Which brands give more margin per meter and per rouble of stock than the space they take, and what to do with them.
What data is needed?
By brand: sales, cost of goods sold, support and bonuses, average stock.
How to read the result?
On the default data (four brands, 180 days) margin with support is 32,800,000, 48.2% of sales, sell-through 64.9%. The best space return is Brand C: 1.61, the worst is Brand D: 0.17. Expanding A and C is suggested, keeping B (index 0.98), cutting or renegotiating D: 21.9% of space gives 3.7% of margin. If space were split by margin share, the shift would be 60.5 m². Example on the default values: Margin with support, total: RUB 32.8 million; Margin with support, % of sales: 48.2%; Sell-through, all brands: 64.9%; Best space return: 1.61× · Brand C. The figures are illustrative: enter your own to see your result.

Why and how to reason

A retailer gives a brand two resources: shelf (area) and money in stock. A fair question is how much margin the brand brings per meter and per rouble of stock compared with the average. Margin is counted with support (markdown compensation and bonuses). The area index equals the brand’s margin per meter divided by the network average. Brand C: 6.6 million of margin on 40 m² is 165 thousand per meter, at an average of 102.5 thousand an index of 1.61. Brand D: 1.2 million on 70 m² is 17 thousand per meter, an index of 0.17. The stock index does the same for money in stock. The decision depends on both indices and sell-through: expand if the area index is above 1 + tolerance, the stock index is not below 1 and sell-through is not below target; reduce if both indices are lower. The area guide by margin share shows how many meters to shift.

When to use it

It is useful for deciding how to distribute area between brands and in negotiations about the size of a corner or support. Do not use it on a short history: the period should cover a season. Assumptions: one period for all brands, area matches the actual display, the 15% return-index tolerance and the 60% sell-through target are yours and can change. The calculation suits a quarterly review: changes in indices from period to period are clearer than in a single table.

How to read the result

Here two brands are for expansion and one for reduction (D): its area index is 0.17 against an average of 1. But do not cut automatically: check whether the brand has a special role (image, traffic) and whether it sells poorly because of its place on the shelf. “Area by margin share: how much to shift” (60 m²) is a guide for a conversation, not an order. Compare sell-through with the target: a brand with a high margin but low sell-through ties up money in stock. For a talk with the brand use the stock index: it shows who pays for leftovers.

Common mistakes

Computing margin without compensation, taking sales for a period shorter than a season, not entering actual area, judging on one period, forgetting that a new brand has not yet opened up. Compare brands within one category: indices across categories are not comparable. Check that area includes the display and the corner storage in the same way for all brands, otherwise the index is distorted.

What data is needed?

  • By brand: sales, cost of goods sold, support and bonuses, average stock.
  • Units available and sold, brand space.
  • Days in the period, the index tolerance and optionally the sell-through target.

Inputs

FieldUnitValue in the exampleMeaning
Days in the perioddays180The data period: a season 180 days, a year 365. The example value is illustrative.
Index tolerance%15How far the index must differ from the average for a brand to count as strong or weak. The value is yours. The example value is illustrative.
Your sell-through target%60Sold ÷ available over the period; empty: sell-through does not take part in the decision. There is no single standard in Russia: enter your own figure.

How it is calculated

StepFormula
Margin with supportsales − cost + support and bonuses
Space index(brand margin ÷ brand space) ÷ (total margin ÷ total space)
Stock index(brand margin ÷ brand stock) ÷ (total margin ÷ total stock)
Decisionexpand: space index ≥ 1 + tolerance, stock index ≥ 1, sell-through not below target; cut: both indices below (1 − tolerance) and 1

Worked numbers

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

Margin with support, total
32.8 m ₽Sales − cost + markdown support and bonuses.
Margin with support, % of sales
48.2 %
Sell-through, all brands
64.9 %Basis: sold ÷ available to sell over the period (opening stock plus receipts), as in the brand table; not “total received”.
Best space return
1.61× · Brand CThe index = margin share ÷ space share; 1 means the average return.
Worst space return
0.17× · Brand D
Brands to expand
2 · Brand A, Brand C
Brands to cut
1 · Brand D
Space by margin share: how much to move
60.5 m²The sum of space gains if space were split in proportion to margin. A guide, not a plan: take the sales-floor layout and contracts into account.

Brands: return and decision

BrandSales and space shareMargin, % of salesSell-throughTurnover, a yearGMROI, a yearSpace by margin share, m²Decision
Brand A44.1 % / 37.5 %53.3 %70 %3.38×3.6×156.1Expand
Brand B30.9 % / 28.1 %42.9 %65 %3.24×2.43×87.8Keep
Brand C17.6 % / 12.5 %55 %80 %4.06×4.46×64.4Expand
Brand D7.4 % / 21.9 %24 %37.1 %2.14×0.68×11.7Cut or renegotiate

Brand A: expand. Space share 37.5 %, margin share 48.8 %, space return index 1.3, stock 1.3, sell-through 70 %.

Brand C: expand. Space share 12.5 %, margin share 20.1 %, space return index 1.6, stock 1.5, sell-through 80 %.

Brand D: cut or renegotiate. Space share 21.9 %, margin share 3.7 %, space return index 0.2, stock 0.2, sell-through 37.1 %.

The decision is a prompt: the thresholds (tolerance, sell-through target) are yours, there is no single standard. Before cutting check the contract, return terms and the effect on traffic: a low-margin brand may bring customers. Take space and stock for the same period.

Nuances and limits

  • The space return index does not count the traffic a brand brings to the store.
  • Enter consignment goods with a cost of sales × (1 − commission).
  • The tolerance and the sell-through target are yours: there is no single standard.
  • Space by margin share is a guide, not a plan: the sales-floor layout and contracts shift the result.

Terms used

Calculate on your data →