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).
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
| Step | Formula |
|---|---|
| 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
| Category | Share of sales | Growth | Contribution to growth | Margin | Margin change |
|---|---|---|---|---|---|
| Outerwear | 37.5 % | 15.4 % | 5.4 p.p. | 45 % | −2 p.p. |
| Dresses | 30 % | 9.1 % | 2.7 p.p. | 55 % | 0 p.p. |
| Knitwear | 22.5 % | −10 % | −2.7 p.p. | 45 % | −2 p.p. |
| Accessories | 10 % | 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.