Combo offers and cannibalization
Measure contribution displaced from standalone sales and recovered through incremental orders.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Kombo katkısı (TL)
- 44,444.06
- Kaydırılan katkı (TL)
- 39,702.79
- Net ek katkı (TL)
- 2,141.27
Who can use it, and for what?
Menu pricing and promotion teams
Measure contribution displaced from standalone sales and recovered through incremental orders.
A worked example from the workbook
The first sample row in the baseline has the following results. Kombo katkısı (TL) 41.420, Kaydırılan katkı (TL) 39.121, Net ek katkı (TL) -301, Başabaş kombo fiyatı (TL) 235,79. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Kombo katkısı (TL) | 44,444.06 |
| Kaydırılan katkı (TL) | 39,702.79 |
| Net ek katkı (TL) | 2,141.27 |
| Başabaş kombo fiyatı (TL) | 233.92 |
How do you start with your own data?
- Start with Kılavuz (Guide). Replace the 16 fictional entries in the yellow cells on Veri (Data). Use an Excel date, a unique record ID and a branch or category. There are 64 ready-to-use input rows.
- Estimate contribution from the same items sold separately. Update cannibalization using customer behaviour observed in test locations.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “İkame payı çarpanı”. The sample settings are 1 / 0,7 / 1,28. Changing the scenario preserves source records.
- Panel shows the three cases and the group breakdown for the selected case. On Hesap (Calculations), check input flags and row-level decisions. To rename a group, use the same name on Settings and Data.
Workbook input fields
Labels appear in Turkish in the workbook.
- Kombo satış tahmini
- Kombo fiyatı (TL)
- Kombo değişken maliyet (TL)
- Tekil sepet katkısı (TL)
- Yer değiştiren pay
- Sabit kampanya (TL)
Sample assumptions
- İkame payı çarpanı
- 1