Calculator Inputs
Formula Used
Expected legacy units = baseline legacy units × (1 + market trend ÷ 100).
Observed legacy loss = expected legacy units − actual legacy units.
Legacy loss method = observed legacy loss × launch attribution percentage.
New volume attribution = new product units − category expansion units − competitor steal units.
Overlap model = new product units × buyer overlap percentage × substitution percentage.
Cannibalization rate = cannibalized units ÷ new product units × 100.
Incremental gross profit = new product profit − lost legacy profit − fixed launch cost.
How To Use This Calculator
- Enter the legacy brand baseline for the same period used in your launch review.
- Add actual legacy volume after launch and total new product volume.
- Adjust the market trend to remove normal category growth or decline.
- Enter buyer overlap and substitution assumptions from surveys or panel data.
- Add units gained from new category use or rival brand switching.
- Choose a method, then calculate the cannibalization rate.
- Download the CSV or PDF result for reports and planning meetings.
Example Data Table
| Scenario | Baseline Legacy Units | Actual Legacy Units | New Units | Market Trend | Overlap | Substitution |
|---|---|---|---|---|---|---|
| Conservative | 52,000 | 48,500 | 8,000 | -1% | 35% | 45% |
| Expected | 52,000 | 47,000 | 9,000 | -2% | 45% | 55% |
| Aggressive | 52,000 | 44,000 | 11,500 | -3% | 60% | 70% |
Mountain Man Cannibalization Balance
Mountain Man Brewing Company can study a light launch as a demand transfer problem. The old brand has a known baseline. The new brand adds volume. Some new cases are truly incremental. Some cases replace bottles that loyal drinkers would have bought anyway. This calculator separates those paths.
Why This Rate Matters
Cannibalization rate shows how much new volume came from the existing flagship. A high rate can hurt profit, even when the launch looks busy. A low rate means the product reached new buyers, new occasions, or rival brands. Managers can then judge whether the extension supports the portfolio.
Physics Style View
The tool uses a balance model. Expected legacy demand enters the system. Actual legacy demand leaves after launch. The missing part is treated like transferred demand. New product volume is another stream. The model compares observed loss, buyer overlap, and stated source of volume. This creates a practical estimate, not a legal accounting figure.
Inputs That Improve Accuracy
Use the same time period for every field. Monthly values should be compared with monthly values. Seasonal peaks should not be mixed with quiet months. Add a market trend when the whole category is growing or shrinking. Add competitor steal when buyers moved from rival beer. Add category expansion when the new line created extra use occasions.
Profit And Volume Reading
The calculator reports cannibalized cases, retained new cases, net incremental cases, revenue movement, and gross profit effect. The profit view is important. A smaller product can still help when its margin is strong. It can also destroy value when it replaces a higher margin flagship.
How To Use The Output
Run several scenarios. Try conservative, expected, and aggressive assumptions. Compare the blended method with the legacy loss method. Large gaps warn that the data is weak. Use the notes field to record store coverage, promotion weeks, and regional changes. Export the result before sharing it with sales, finance, or strategy teams.
Limits To Remember
The result depends on clean inputs. It cannot prove why every buyer changed behavior. It gives a disciplined estimate for planning, pricing, and channel talks. Pair it with survey data, distributor feedback, and repeat purchase results before making launch decisions.
FAQs
What is cannibalization rate?
It is the share of new product volume that likely came from the existing product instead of new demand or competitors.
Why use market trend adjustment?
Market trend adjustment removes normal category movement. This keeps a shrinking or growing beer market from distorting the launch effect.
What does buyer overlap mean?
Buyer overlap is the percentage of new product buyers who also bought the legacy product during the measured period.
What is substitution rate?
Substitution rate estimates how often overlapping buyers replaced a legacy purchase with the new product.
Which method should I choose?
Use blended when data is mixed. Use legacy loss when baseline sales are strong. Use overlap when survey data is reliable.
Can this calculator measure profit impact?
Yes. It compares new product gross profit with lost legacy gross profit and fixed launch cost.
Why can net revenue be positive while profit is negative?
The new product may add revenue but replace a higher margin item. Profit depends on margins, not only sales volume.
Can I export the result?
Yes. Use the CSV button for spreadsheet review, or use the PDF button for a simple report file.