Gross-margin bridge by cause
Splits the change in gross margin between two periods by cause: price and discounts, channel mix, reserve, cost, freight. Shows each cause in margin points and in money and what remains unexplained.
At a glance
- What question does it answer?
- What changed gross margin between two periods: price and discounts, channels, reserve, cost or freight.
- What data is needed?
- Gross margin of the base period and revenue of the current one.
- How to read the result?
- On the example the base margin is 52%. The causes give −2.2 pp: discounts −1.5, channels −0.7, reserve −0.4, cost +0.6, freight −0.2. The margin from the causes is 49.8%; on revenue of 300m that is −6.6m. The actual margin of 49.5% leaves an unexplained −0.3 pp, that is −0.9m. Example on the default values: Margin from the causes: 49.8%; Change from the causes: −2.2 pp; The same in money: −RUB 6.6 million; Largest loss: −1.5% pp · Price and discounts. The figures are illustrative: enter your own to see your result.
Why and how to reason
Gross margin fell from 52% to 49.5%, and the first question is not “by how much” but “why”. The bridge splits the fall by cause so each can be named and assigned to someone. The logic is simple: the change in margin in points equals the sum of the causes’ contributions. You estimate each contribution from management reporting: price and discounts −1.5 pp, channel mix −0.7, inventory write-down reserve −0.4, product cost +0.6, freight −0.2. The sum −2.2 pp gives a margin from causes of 49.8% while the actual is 49.5%: so 0.3 pp is unexplained. Converted to money: margin point × current-period revenue, that is −2.2% × 300 million = −6.6 million, unexplained −0.3% = −900 thousand. The bridge finds nothing by itself; it shows whether you have explained everything. A residual is a signal that part of the fall hides in “other”.
When to use it
Use it in a monthly or seasonal margin review when you must explain to management or an investor where a fall or rise comes from. It suits brands and retailers. It does not suit cases without reporting by cause: the contributions would have to be invented. Assumptions: contributions are given in margin points against the base and current revenue excludes VAT. Add exchange rate and duties as a separate line if they matter to you.
How to read the result
First the largest loss: aim the first action there. Then check “not explained by causes”: if above 0.25 pp in absolute value, look for the missing cause before it becomes habit. Money is convenient for talking to management: −6.6 million is more persuasive than −2.2 pp Look at the pluses too: cost +0.6 shows purchasing worked and other causes dragged margin down. Check which causes are controllable (discounts, channels) and which not (freight), and set targets on the controllable ones.
Common mistakes
Entering contributions with the wrong sign: a loss of margin must be negative. Entering contributions in money instead of points: the bridge works in margin points. Adjusting contributions so the residual becomes zero: then the bridge shows confidence rather than knowledge. And taking the base and the current period with different cost methods: part of the difference is then methodological.
What data is needed?
- Gross margin of the base period and revenue of the current one.
- The contribution of each cause in margin points from your management reporting; optionally the actual margin of the current period.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Gross margin of the base period | % | 52 | The base period’s gross margin in percent: the bridge starts from it. |
| Revenue of the current period excl. VAT | ₽ | 300,000,000 | Amount excl. VAT: the general rate is 22% from 01.01.2026. The rate follows the shipment date; confirm your regime and rate with an accountant. |
| Actual gross margin of the current period | % | 49.5 | Optional. Needed to see the unexplained part of the change. |
How it is calculated
| Step | Formula |
|---|---|
| Margin from the causes | base margin + Σ contributions |
| Money | contribution in p.p. ÷ 100 × revenue of the current period |
| Unexplained | actual margin − margin from the causes |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Margin from the causes
- 49.8 %The base plus the sum of the contributions.
- Change from the causes
- −2.2 p.p.
- The same in money
- −6.6 m ₽Margin points × revenue of the current period.
- Largest loss
- −1.5 % p.p. · Price and discounts
- Not explained by the causes
- −0.3 p.p.
- Unexplained in money
- −900,000 ₽
- positive
- negative
- total
Data as a table
| Step | Change | Level |
|---|---|---|
| Price and discounts | −1.5 | −1.5 |
| Channel mix | −0.7 | −2.2 |
| Inventory write-down reserve | −0.4 | −2.6 |
| Cost of goods | +0.6 | −2 |
| Freight and logistics | −0.2 | −2.2 |
| Unexplained | −0.3 | −2.5 |
| Total | — | −2.5 |
Bridge by cause
| Cause | Contribution, p.p. | Contribution in money |
|---|---|---|
| Base | 52 % | — |
| Price and discounts | −1.5 % | −4.5 m ₽ |
| Channel mix | −0.7 % | −2.1 m ₽ |
| Inventory write-down reserve | −0.4 % | −1.2 m ₽ |
| Cost of goods | 0.6 % | 1.8 m ₽ |
| Freight and logistics | −0.2 % | −600,000 ₽ |
| Unexplained | −0.3 % | −900,000 ₽ |
| Total | 49.5 % | −7.5 m ₽ |
The causes do not fully explain the change: a part remains in “other”. Find it before it becomes habit.
You estimate the contributions yourself from management reporting; the bridge does not find the causes by itself. Add the exchange rate and duties as a separate line if they matter to you.
Nuances and limits
- The bridge does not find the causes itself: you estimate the contributions from reports.
- An unexplained remainder over a quarter of a point means that some causes are not named.
- Compare periods of the same length and composition.