Two-way profit sensitivity: price, volume and cost in pairs
Builds a profit table for simultaneous shifts of two factors (price and volume, price and cost, volume and cost), shows how many cells fall into a loss, the lowest and highest profit and by how much each factor must shift for profit to reach zero.
At a glance
- What question does it answer?
- How profit behaves when two factors change at once and by how much each must shift for profit to reach zero.
- What data is needed?
- Price, cost, volume and the period’s fixed costs.
- How to read the result?
- Example on the default values (price and volume, step 5%): base profit RUB 3.34 million, from RUB 736,260 to RUB 6.52 million; loss cells 0 of 49; to zero the price may fall by 25.8%, volume by 52.7% and cost rise by 50.5%. Example on the default values: Base profit: RUB 3.34 million; Lowest profit in the table: RUB 736,260; Highest profit in the table: RUB 6.52 million; Cells with a loss: 0 of 49. The figures are illustrative: enter your own to see your result.
Why and how to reason
Profit depends on several quantities at once, and errors in them often come in pairs: price falls and volume falls, cost rises and price does not keep up. One-factor sensitivity (“what if price is minus 5%”) does not show such combinations. A two-factor table takes two factors and changes them simultaneously with a given step, and in each cell counts profit: volume × (price × (1 − variable costs) − cost) − fixed. Base: 3,000 × (4,900 × 0.88 − 2,200) − 3,000,000 = 3.34 million. Then three “zeros”: the price at which profit is zero (minus 25.8%), volume (minus 52.7%) and cost (plus 50.5%). They show the safety margin on each factor separately. The table adds the interaction: the most dangerous cell of the grid gives 736 thousand, with no loss.
When to use it
It is useful before a launch, buying or price strategy decision to see which factor is more dangerous and how a combination of factors affects the result. Do not use it for processes with complex links (a discount changes both price and volume): set the link explicitly for those. Assumptions: variable costs as a percentage of price, fixed costs unchanged, factors independent.
How to read the result
First look at the margins to zero: compare them with each other. Volume can be lost by half, price withstands a fall of a quarter, and cost rises by 50%. So price is the most sensitive factor: one percent of price matters more than one percent of volume. Then find cells with a loss: if there are none, the scenario is stable in the chosen range, but widen the step and test a harsher stress. The most dangerous cell shows the worst case in the table. Decision: protect the most sensitive factor (price contracts, volume insurance) and do not spend effort on the one with large headroom.
Common mistakes
Typical trap: taking the step too small (the table shows nothing), entering variable costs in roubles instead of percent, not recalculating fixed costs when volume changes, reading cells as a forecast. These are “what if” scenarios, not probabilities. Remember that the table knows nothing of the link between factors: if a discount raises volume, set that as a separate scenario rather than the pair “price and volume” independently.
What data is needed?
- Price, cost, volume and the period’s fixed costs.
- The share of variable selling costs in the price.
- The pair of factors and the shift step.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Price excl. VAT | ₽ | 4,900 | The average selling price of a unit. The example value is illustrative. |
| Unit cost | ₽ | 2,200 | The full cost of a unit. The example value is illustrative. |
| Sales volume | units | 3,000 | Sales over the period. Footwear, accessories and children’s have their own values: take the category data. |
| Fixed costs | ₽ | 3,000,000 | Costs for the same period independent of volume. |
| Variable selling costs | % of price | 12 | Marketplace commission, acquiring, bonuses: a share of the price that moves with it. |
| Which two factors | Price and volume | The first factor runs across columns, the second down rows. | |
| Shift step | % | 5 | The table covers shifts from −3 to +3 steps: at a step of 5 it is from −15 to +15%. |
How it is calculated
| Step | Formula |
|---|---|
| Profit | volume × (price × (1 − cost share) − cost) − fixed |
| Zero by price | (fixed ÷ volume + cost) ÷ (1 − share) |
| Zero by volume | fixed ÷ (price × (1 − share) − cost) |
| Zero by cost | price × (1 − share) − fixed ÷ volume |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Base profit
- 3.34 m ₽
- Lowest profit in the table
- 736,260 ₽
- Highest profit in the table
- 6.52 m ₽
- Cells with a loss
- 0 of 49
- The most dangerous cell
- 736,260 ₽ · Price −15 %, Volume −15 %
- Price to zero profit: shift
- −25.8 %Everything else at base.
- Volume to zero profit: shift
- −52.7 %
- Cost to zero profit: shift
- +50.5 %
- 736k … 0 … 6.52m ₽
Data as a table
| −15 % | −10 % | −5 % | 0 % | +5 % | +10 % | +15 % | |
|---|---|---|---|---|---|---|---|
| Volume −15 % | 736k | 1.29m | 1.84m | 2.39m | 2.94m | 3.49m | 4.03m |
| Volume −10 % | 956k | 1.54m | 2.12m | 2.7m | 3.28m | 3.87m | 4.45m |
| Volume −5 % | 1.18m | 1.79m | 2.4m | 3.02m | 3.63m | 4.25m | 4.86m |
| Volume 0 % | 1.4m | 2.04m | 2.69m | 3.34m | 3.98m | 4.63m | 5.28m |
| Volume +5 % | 1.62m | 2.29m | 2.97m | 3.65m | 4.33m | 5.01m | 5.69m |
| Volume +10 % | 1.84m | 2.55m | 3.26m | 3.97m | 4.68m | 5.39m | 6.1m |
| Volume +15 % | 2.05m | 2.8m | 3.54m | 4.29m | 5.03m | 5.77m | 6.52m |
Profit under shifts of two factors
| Volume \ Price | −15 % | −10 % | −5 % | 0 % | +5 % | +10 % | +15 % |
|---|---|---|---|---|---|---|---|
| −15 % | 736,260 ₽ | 1.29 m ₽ | 1.84 m ₽ | 2.39 m ₽ | 2.94 m ₽ | 3.49 m ₽ | 4.03 m ₽ |
| −10 % | 956,040 ₽ | 1.54 m ₽ | 2.12 m ₽ | 2.7 m ₽ | 3.28 m ₽ | 3.87 m ₽ | 4.45 m ₽ |
| −5 % | 1.18 m ₽ | 1.79 m ₽ | 2.4 m ₽ | 3.02 m ₽ | 3.63 m ₽ | 4.25 m ₽ | 4.86 m ₽ |
| 0 % | 1.4 m ₽ | 2.04 m ₽ | 2.69 m ₽ | 3.34 m ₽ | 3.98 m ₽ | 4.63 m ₽ | 5.28 m ₽ |
| +5 % | 1.62 m ₽ | 2.29 m ₽ | 2.97 m ₽ | 3.65 m ₽ | 4.33 m ₽ | 5.01 m ₽ | 5.69 m ₽ |
| +10 % | 1.84 m ₽ | 2.55 m ₽ | 3.26 m ₽ | 3.97 m ₽ | 4.68 m ₽ | 5.39 m ₽ | 6.1 m ₽ |
| +15 % | 2.05 m ₽ | 2.8 m ₽ | 3.54 m ₽ | 4.29 m ₽ | 5.03 m ₽ | 5.77 m ₽ | 6.52 m ₽ |
The factors shift independently and at once: in practice price affects volume (see “Elasticity from a table”) and cost affects price. The table shows the margin of safety and not a forecast. For footwear and children’s a volume shift also changes the size mix of sales.
Nuances and limits
- Treating shifts as independent: a price cut usually changes volume.
- Stopping at one factor: pairs show where the margin of safety ends faster.
- Reading the table as a forecast: it is a margin of safety.