Syntha Lab RU

Categories: contribution to growth and margin, this year versus last

Shows which categories raised or dropped sales and how many points of growth each gave, and splits the change in the total margin into a mix effect (category shares shifted) and a rate effect (margin within categories changed).

Season results: brand, category, SKU For whom: Finance and commercial directors, category heads.

Calculate on your data →

At a glance

What question does it answer?
Which categories gave growth and which lost margin and what changed the total margin.
What data is needed?
By category: sales and gross margin in money for this year and last for the same period.
How to read the result?
On the example sales grew 8.1% (80m against 74m). Outerwear gave +5.4 pp of growth, knitwear pulled down by −2.7 pp The total margin fell from 50.0% to 49.5% (−0.5 pp): mix effect +0.2 pp, rate effect −0.7 pp The margin dropped within categories (outerwear and knitwear), not because of a shift in shares. Example on the default values: Sales this year: RUB 80 million; Sales last year: RUB 74 million; Sales growth: 8.1%; Margin this year: 49.5%. The figures are illustrative: enter your own to see your result.

Why and how to reason

Total sales growth of 8% does not say who created it. Category contribution to growth = (this year’s sales − last year’s) ÷ total last-year sales: it shows how many points of overall growth the category brought. Outerwear grew by 4 million of 74 million, 5.4 pp of growth; knitwear fell by 2 million, −2.7 pp The sum of contributions equals total growth of 8.1%. Total margin changes for two reasons that are easy to confuse. Mix effect: category shares shifted (we sell more of high- or low-margin categories). Rate effect: margin inside categories changed. Here margin fell from 50.03 to 49.5% (−0.53 pp): mix added +0.17 and the rate inside categories took away −0.70. So the problem is not that we sell the wrong things but that margin sagged inside categories.

When to use it

It is useful in an annual or seasonal review of a brand or store to see who drives growth and who falls. It suits anyone with sales and gross profit by category for two comparable periods. It does not suit cases where categories were redefined between periods: comparison loses meaning. Assumptions: the same categories, periods comparable in length and season, sales and profit excluding VAT.

How to read the result

Start with “largest contribution to growth” and “largest decline”: they need attention. Then the margin decomposition: if the rate effect is negative, look for the cause inside categories (discounts, purchase prices, returns). If the mix effect is negative, you grow through less profitable categories: not bad if money grows, but check that turnover has not replaced profit. If both are positive, understand why and lock it in. Compare categories with stock and sell-through so as not to increase buying where growth is already tied to a promotion. Lock in the result: write down which two categories you will move next period and why.

Common mistakes

Comparing categories of different seasons and treating the fall of a seasonal item as a problem. Reading the mix effect as the cause of margin decline when it is positive. Forgetting that category sales growth in roubles can be price-driven, not volume-driven. Another mistake: taking category margin from planned rather than actual accounting: the rate effect then measures forecast error.

What data is needed?

  • By category: sales and gross margin in money for this year and last for the same period.

How it is calculated

StepFormula
Contribution to growth(sales this year − sales last year) ÷ total sales of last year
Mix effectΣ (share this year − share last year) × the category margin last year
Rate effectΣ share this year × (margin this year − margin last year) of the category

Worked numbers

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

Sales this year
80 m ₽
Sales last year
74 m ₽
Sales growth
8.1 %
Margin this year
49.5 %
Margin last year
50 %
Change in margin
−0.5 p.p.
Mix effect (shift of shares)
0.2 p.p.
Rate effect (margin within categories)
−0.7 p.p.
Largest contribution to growth
5.4 p.p. · Outerwear
Largest decline
−2.7 p.p. · Knitwear

By category

CategoryShare of salesGrowthContribution to growthMarginMargin change
Outerwear37.5 %15.4 %5.4 p.p.45 %−2 p.p.
Dresses30 %9.1 %2.7 p.p.55 %0 p.p.
Knitwear22.5 %−10 %−2.7 p.p.45 %−2 p.p.
Accessories10 %33.3 %2.7 p.p.60 %5 p.p.

Mix effect + rate effect = the change in the total margin. If the rate falls within categories, look for the cause in discounts and cost; if the mix falls, the share shifted to less profitable categories.

Nuances and limits

  • Comparing periods of a different length or with a different number of stores.
  • Explaining a margin fall only by discounts without checking the shift in shares.

Terms used

Calculate on your data →