Syntha Lab RU

Cannibalization on a store opening: the chain’s net gain

Compares the sales of neighboring stores before and after a new store opens with an adjustment for the growth of control stores, calculates the neighbors’ loss, the cannibalization rate, the net sales gain and the new store’s contribution with and without the loss.

Investment and store openings For whom: Chain directors, expansion specialists and finance directors when choosing the site of a new store.

Calculate on your data →

At a glance

What question does it answer?
How much of a new store’s sales came from the chain and whether the chain keeps a contribution after that.
What data is needed?
New store sales per month, margin, store costs.
How to read the result?
On the default data (the new store 4,500,000 a month, control growth 3%, three neighboring stores) neighbors lost 1,400,000 against expected: cannibalization is 31.1% of the new store’s sales. The net sales gain is 3,100,000. The new store’s contribution alone is 440,000, with the neighbors’ loss minus 288,000: cannibalization ate 728,000. The most affected is the nearby mall store: minus 12.6% to expected. Example on the default values: Neighbors’ loss per month: RUB 1.4 million; Cannibalization rate: 31.1%; Net sales gain of the chain: RUB 3.1 million; New store contribution without cannibalization: RUB 440,000. The figures are illustrative: enter your own to see your result.

Why and how to reason

A new point sells, but part of its sales flow over from neighbors: those customers were already yours. So the contribution of the new point to the network is smaller than its own. To measure the flow, neighbors are compared before and after the opening, with an adjustment: without the new point they would also have grown. Control stores grow 3%, so a neighbor with 6 million is “due” 6.18 million, and it sold 5.4. A loss of 780 thousand. Adding three neighboring stores: 15 million were expected to become 15.45 million, got 14.05, a loss of 1.4 million a month. The cannibalization share is 1.4 ÷ 4.5 = 31% of the new point’s sales. The contribution of the new point alone (4.5 × 52% − 1.9 = 440 thousand) is positive, while for the network (3.1 × 52% − 1.9 = minus 288 thousand) it is negative.

When to use it

Use it when assessing an already opened point and when planning new ones near existing ones. Do not use it if during the same time a promotion, assortment or traffic changed at the neighbors: the effect will mix with cannibalization. Assumptions: the right neighbors are selected, control stores are unaffected, the periods before and after have equal length and no seasonal jump. It is a good check of a network plan: before opening, you can insert an expected loss and see whether the point stays profitable.

How to read the result

Compare the two contributions: without cannibalization (440 thousand) and with it (minus 288 thousand). If the difference changes the sign, as here, the point is loss-making for the network, and the issue is not the point but the choice of location. “Net sales gain” (3.1 million) shows real growth. The most affected store (a loss of 12.6% against expected) tells whom to protect, and the 31% share gives a guide for future openings. If the share is large, think of other formats or assortment for the new point so that it attracts a new audience.

Common mistakes

Comparing “after” with “before” without a growth adjustment, taking too many stores as neighbors (the effect is diluted), taking too few months after opening when the new point is still ramping up. Do not blame the new point for the whole decline of neighbors if they had other causes.

What data is needed?

  • New store sales per month, margin, store costs.
  • Growth of control stores over the same period.
  • For neighboring stores: sales before and after opening.

Inputs

FieldUnitValue in the exampleMeaning
New store sales per month₽4,500,000Average monthly sales after ramp-up, excl. VAT. The example value is illustrative.
Gross margin%52The margin used for the neighbors’ loss and the new store’s contribution. The example value is illustrative.
New store costs per month₽1,900,000Rent, payroll and other store costs excluding cost of goods, excl. VAT. The example value is illustrative.
Growth of control stores over the same period%3By how much sales of stores far from the new one grew (minus: fell) between the same months. Without a control the season distorts the result. The example value is illustrative.
Uncertainty of the control growthpp00: the control growth is taken as exact, as before. The standard error of the control stores’ growth, pp; from the spread of the control stores.
The loss that matters not to miss% of expected sales—Optional. The neighbors’ loss as a percent of expected sales: the calculation shows how many neighboring stores are needed to notice it. Empty: not counted.

How it is calculated

StepFormula
Expected at a neighboursales before × (1 + control growth %)
Lossexpected − actual after; summed over neighbours
Cannibalisation rateneighbours’ loss ÷ new store sales
Chain contribution(new store sales − loss) × margin − new store costs

Worked numbers

Default values from the app; in the interactive version you enter your own.

Neighbours’ loss per month
1.4 m ₽Expected neighbour sales minus actual. A negative loss means neighbours grew above expected.
Cannibalisation rate
31.1 %Neighbours’ loss ÷ new store sales. A minus means neighbours grew above expected (a halo): this is not cannibalisation.
Net sales gain of the chain
3.1 m ₽
New store contribution without cannibalisation
440,000 ₽
Chain contribution with cannibalisation
−288,000 ₽
Contribution lost to cannibalisation
728,000 ₽
Most affected store, loss to expected
12.6 % · Nearby store, mall
Loss to expected: 95% interval, from
−2.3 %The mean over neighbours ± t × the standard error (the neighbours’ spread and the control uncertainty). A rough estimate with few stores.
Loss to expected: 95% interval, to
20.1 %
Minimum detectable loss
7.3 %(z₁ + z₂) × the standard error at power 80% and level 5%: a smaller loss cannot be told from random fluctuation with this number of neighbours.

Neighbouring stores

StoreExpected without the new storeActualLossLoss to expected
Nearby store, mall6.18 m ₽5.4 m ₽780,000 ₽12.6 %
Store, city center4.12 m ₽3.7 m ₽420,000 ₽10.2 %
Store, residential area5.15 m ₽4.95 m ₽200,000 ₽3.9 %

Neighbours lost 1.4 m ₽ a month against expected with the control adjustment (3 %): 31.1 % of the new store’s sales came from the chain. The net gain is 3.1 m ₽.

Not all of the loss is caused by the new store: check whether neighbours changed range, price and mall traffic. There is no norm for acceptable cannibalisation: the decision is yours. Amounts excl. VAT.

Nuances and limits

  • Without control stores the season and mall traffic pass for cannibalization: enter the control growth.
  • Count after the new store has ramped up, not in the first month.
  • The neighbors’ loss is valued at margin; their costs do not change.
  • There is no norm for acceptable cannibalization: decide by net contribution.

Terms used

Calculate on your data →