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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| New store sales per month | ₽ | 4,500,000 | Average monthly sales after ramp-up, excl. VAT. The example value is illustrative. |
| Gross margin | % | 52 | The margin used for the neighbors’ loss and the new store’s contribution. The example value is illustrative. |
| New store costs per month | ₽ | 1,900,000 | Rent, payroll and other store costs excluding cost of goods, excl. VAT. The example value is illustrative. |
| Growth of control stores over the same period | % | 3 | By 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 growth | pp | 0 | 0: 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
| Step | Formula |
|---|---|
| Expected at a neighbour | sales before × (1 + control growth %) |
| Loss | expected − actual after; summed over neighbours |
| Cannibalisation rate | neighbours’ 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
| Store | Expected without the new store | Actual | Loss | Loss to expected |
|---|---|---|---|---|
| Nearby store, mall | 6.18 m ₽ | 5.4 m ₽ | 780,000 ₽ | 12.6 % |
| Store, city center | 4.12 m ₽ | 3.7 m ₽ | 420,000 ₽ | 10.2 % |
| Store, residential area | 5.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.