Plan sensitivity and breaking point
Moves one factor at a time (price, volume, exchange rate, returns, discount, variable and fixed costs) in both directions, ranks them by effect on profit (tornado) and finds how far each must worsen for the plan profit to reach zero.
At a glance
- What question does it answer?
- Which factor moves profit the most and at what shift of each the plan stops being profitable.
- What data is needed?
- The same plan inputs as in “Plan scenarios”.
- How to read the result?
- At a ±10% shift of the price profit runs from 11,132,000 to 31,328,000: a range of 20,196,000 makes price the strongest factor. Then volume 9,246,000, the rate 7,560,000, variable costs (±3 pp) 7,128,000, discount (±3 pp) 6,885,000, fixed costs 5,000,000 and returns 3,582,000. The breaking point: the price may fall by 21.0%, volume by 45.9%, the rate may rise by 56.2%; returns would have to rise by 35.6 pp, so that risk is secondary. Example on the default values: Plan profit in the base case: RUB 21.2 million; The strongest factor: RUB 20.2 million · Price; The weakest factor: RUB 3.58 million · Returns; Factors whose shift takes profit to zero or below: 0. The figures are illustrative: enter your own to see your result.
Why and how to reason
When a plan has many factors it is unclear which to watch first: price, volume, exchange rate, returns, discount, variable and fixed costs. The calculation moves one factor at a time in both directions and recomputes profit. Swing = profit at the best shift − profit at the worst. Factors are ranked by swing: this gives a tornado chart with the most influential on top. In the example base profit is 21.23 million. Shifting price, volume, exchange rate and fixed costs by 10% and returns, discount and variable by 3 pp; the strongest factor gives a swing of 20.2 million, the weakest 3.6 million. The second result is the breaking point: the shift at which profit becomes zero. Profit is linear in each factor so breaking point = profit ÷ profit per unit of the factor. Price can fall 21%, volume 46%, and the plan still does not go negative. Price matters more than volume: 1% of price is worth about 1.0 million, 1% of volume less.
When to use it
It is useful after the plan is assembled to understand what to watch and where safety margins are needed. It suits a brand and a retailer. It does not replace scenarios: here factors move one at a time while in life they are linked. Assumptions: each breaking point is computed with the others at base; discount depth is set as an average across season stages: before the sale, in the sale, after it and final liquidation (names in your company may differ).
How to read the result
Go through the tornado from top to bottom. The top factor is the main risk and main lever: direct attention and control metrics there. The breaking point shows the safety margin: if price can fall 21% while real fluctuations are 5%, the margin is large. If the break is closer than 10–15%, set a trigger for the factor (a fall of 5% switches on an action plan). Compare with real volatility: the exchange rate can swing widely while fixed costs hardly. For linked shifts (discount plus volume, rate plus price) use the “Plan scenarios” calculation. The decision: which two or three factors to control weekly.
Common mistakes
Shifting all factors by the same percentage and treating the result as comparable: 10% of price and 10% of returns are incommensurable. Taking the break for a forecast: it is a safety margin, not a probability. Forgetting that in life factors are linked: a price fall is usually accompanied by a change in volume and returns. Taking the discount as the best rather than the average across stages.
What data is needed?
- The same plan inputs as in “Plan scenarios”.
- The size of the tested shift in percent and in percentage points.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Planned sales before returns | pcs | 50,000 | How many pieces go to customers in the plan period; returns are deducted below. The example value is illustrative. |
| Price excl. VAT before discounts | ₽ | 3,000 | Amount excl. VAT: the general rate is 22% from 01.01.2026 (law of 28.11.2025 No. 425-FZ, a guide as of 13.11.2026, check against the act text). The rate follows the shipment date; confirm your regime and rate with an accountant. |
| Average discount depth from the price | % | 12 | The average over the sales of the whole period: the share of the price lost to discounts across the stages BS, IS, AS and SO: before the sale, in the sale, after it and the final sell-out (your company may name them differently). Stage breakdown: the “Season results” calculation. An example, not a standard. |
| Returns in pieces | % | 10 | The share of sold pieces that came back. Returned goods go back to stock at cost. |
| Unit cost at the warehouse | ₽ | 1,200 | Full cost: fabric, sewing, delivery, duty. |
| Share of cost that depends on the exchange rate | % | 70 | Purchases in foreign currency and duty on the foreign-currency value: count from your contracts. The rest (roubles) does not depend on the rate. |
| Variable costs in revenue | % | 15 | Commissions, advertising, delivery to the customer, acquiring: a share of revenue. |
| Return handling, per piece | ₽ | 150 | Receiving, checking, repacking, return delivery. |
| Fixed costs for the period | ₽ | 25,000,000 | Rent, payroll, office, depreciation: what does not depend on sales. |
| Shift of price, volume, rate and fixed costs | % | 10 | The same shock in percent in both directions. There is no single standard: take the spread that has already happened to you. |
| Shift of returns, discount and variable costs | pp | 3 | The shock in percentage points in both directions. |
How it is calculated
| Step | Formula |
|---|---|
| Shock | profit is recalculated with one factor shifted up and down |
| Range | profit at the better shift − profit at the worse |
| Breaking point | the shift at which profit = 0: profit ÷ profit per unit of the factor (profit is linear in each factor) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Plan profit in the base case
- 21.2 m ₽
- The strongest factor
- 20.2 m ₽ · PriceThe profit range between the worst and the best shift of this factor.
- The weakest factor
- 3.58 m ₽ · Returns
- Factors whose shift takes profit to zero or below
- 0
- The price may fall before the plan breaks
- 21 %A price fall in percent with all else at the base.
- Volume may fall before the plan breaks
- 45.9 %A fall in unit sales in percent with all else at the base.
- At the worse shift
- At the better shift
Deviation from the base plan profit; the strongest factor is on top.
Data as a table
| Measure | At the worse shift | At the better shift |
|---|---|---|
| Price | −10.1m | 10.1m |
| Sales volume | −4.62m | 4.62m |
| Purchase-currency rate | −3.78m | 3.78m |
| Variable costs | −3.56m | 3.56m |
| Discount depth | −3.44m | 3.44m |
| Fixed costs | −2.5m | 2.5m |
| Returns | −1.79m | 1.79m |
Tornado: profit at a shift of the factor
| Factor | Shift | Profit at the worse | Profit at the better | Range | The plan breaks at |
|---|---|---|---|---|---|
| Price | ±10 % | 11.1 m ₽ | 31.3 m ₽ | 20.2 m ₽ | −21 % |
| Sales volume | ±10 % | 16.6 m ₽ | 25.9 m ₽ | 9.25 m ₽ | −45.9 % |
| Purchase-currency rate | ±10 % | 17.5 m ₽ | 25 m ₽ | 7.56 m ₽ | +56.2 % |
| Variable costs | ±3 p.p. | 17.7 m ₽ | 24.8 m ₽ | 7.13 m ₽ | +17.9 p.p. |
| Discount depth | ±3 p.p. | 17.8 m ₽ | 24.7 m ₽ | 6.89 m ₽ | +18.5 p.p. |
| Fixed costs | ±10 % | 18.7 m ₽ | 23.7 m ₽ | 5 m ₽ | +84.9 % |
| Returns | ±3 p.p. | 19.4 m ₽ | 23 m ₽ | 3.58 m ₽ | +35.6 p.p. |
The breaking point is found for each factor on its own, with the others at the base. In life the factors are linked: a discount usually lifts volume, a rise in the rate often pulls the price. Set joint shifts in the “Plan scenarios” calculation. Set the discount depth as the average across the stages BS, IS, AS and SO: before the sale, in the sale, after it and the final sell-out (your company may name them differently).
Nuances and limits
- The same shock for different factors is not always comparable: 10% of price and 10% of volume are not equally likely. Change the size of the shift to your experience.
- The breaking point is found for each factor separately: a joint shift breaks the plan sooner.
- If base profit is zero or negative, the breaking point has already been passed.