Syntha Lab RU

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.

Owner’s cash and management dashboard For whom: Owners and chief financial officers: to assess the plan’s margin of safety.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Price excl. VAT₽4,900The average selling price of a unit. The example value is illustrative.
Unit cost₽2,200The full cost of a unit. The example value is illustrative.
Sales volumeunits3,000Sales over the period. Footwear, accessories and children’s have their own values: take the category data.
Fixed costs₽3,000,000Costs for the same period independent of volume.
Variable selling costs% of price12Marketplace commission, acquiring, bonuses: a share of the price that moves with it.
Which two factorsPrice and volumeThe first factor runs across columns, the second down rows.
Shift step%5The table covers shifts from −3 to +3 steps: at a step of 5 it is from −15 to +15%.

How it is calculated

StepFormula
Profitvolume × (price × (1 − cost share) − cost) − fixed
Zero by price(fixed ÷ volume + cost) ÷ (1 − share)
Zero by volumefixed ÷ (price × (1 − share) − cost)
Zero by costprice × (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 %
Profit: heat map of shifts
Heat map: 7×7; min 736k, max 6.52m−15 %−15 %−10 %−10 %−5 %−5 %0 %0 %+5 %+5 %+10 %+10 %+15 %+15 %Volume −15 %Volume −15 %736kVolume −15 % / −15 %: 736k1.29mVolume −15 % / −10 %: 1.29m1.84mVolume −15 % / −5 %: 1.84m2.39mVolume −15 % / 0 %: 2.39m2.94mVolume −15 % / +5 %: 2.94m3.49mVolume −15 % / +10 %: 3.49m4.03mVolume −15 % / +15 %: 4.03mVolume −10 %Volume −10 %956kVolume −10 % / −15 %: 956k1.54mVolume −10 % / −10 %: 1.54m2.12mVolume −10 % / −5 %: 2.12m2.7mVolume −10 % / 0 %: 2.7m3.28mVolume −10 % / +5 %: 3.28m3.87mVolume −10 % / +10 %: 3.87m4.45mVolume −10 % / +15 %: 4.45mVolume −5 %Volume −5 %1.18mVolume −5 % / −15 %: 1.18m1.79mVolume −5 % / −10 %: 1.79m2.4mVolume −5 % / −5 %: 2.4m3.02mVolume −5 % / 0 %: 3.02m3.63mVolume −5 % / +5 %: 3.63m4.25mVolume −5 % / +10 %: 4.25m4.86mVolume −5 % / +15 %: 4.86mVolume 0 %Volume 0 %1.4mVolume 0 % / −15 %: 1.4m2.04mVolume 0 % / −10 %: 2.04m2.69mVolume 0 % / −5 %: 2.69m3.34mVolume 0 % / 0 %: 3.34m3.98mVolume 0 % / +5 %: 3.98m4.63mVolume 0 % / +10 %: 4.63m5.28mVolume 0 % / +15 %: 5.28mVolume +5 %Volume +5 %1.62mVolume +5 % / −15 %: 1.62m2.29mVolume +5 % / −10 %: 2.29m2.97mVolume +5 % / −5 %: 2.97m3.65mVolume +5 % / 0 %: 3.65m4.33mVolume +5 % / +5 %: 4.33m5.01mVolume +5 % / +10 %: 5.01m5.69mVolume +5 % / +15 %: 5.69mVolume +10 %Volume +10 %1.84mVolume +10 % / −15 %: 1.84m2.55mVolume +10 % / −10 %: 2.55m3.26mVolume +10 % / −5 %: 3.26m3.97mVolume +10 % / 0 %: 3.97m4.68mVolume +10 % / +5 %: 4.68m5.39mVolume +10 % / +10 %: 5.39m6.1mVolume +10 % / +15 %: 6.1mVolume +15 %Volume +15 %2.05mVolume +15 % / −15 %: 2.05m2.8mVolume +15 % / −10 %: 2.8m3.54mVolume +15 % / −5 %: 3.54m4.29mVolume +15 % / 0 %: 4.29m5.03mVolume +15 % / +5 %: 5.03m5.77mVolume +15 % / +10 %: 5.77m6.52mVolume +15 % / +15 %: 6.52mPrice: shift from base
  • 736k … 0 … 6.52m ₽
Data as a table
−15 %−10 %−5 %0 %+5 %+10 %+15 %
Volume −15 %736k1.29m1.84m2.39m2.94m3.49m4.03m
Volume −10 %956k1.54m2.12m2.7m3.28m3.87m4.45m
Volume −5 %1.18m1.79m2.4m3.02m3.63m4.25m4.86m
Volume 0 %1.4m2.04m2.69m3.34m3.98m4.63m5.28m
Volume +5 %1.62m2.29m2.97m3.65m4.33m5.01m5.69m
Volume +10 %1.84m2.55m3.26m3.97m4.68m5.39m6.1m
Volume +15 %2.05m2.8m3.54m4.29m5.03m5.77m6.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.

Terms used

Calculate on your data →