ExcelFlux
← Restaurant and café

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.

MeasureSample 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?

  1. 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.
  2. Estimate contribution from the same items sold separately. Update cannibalization using customer behaviour observed in test locations.
  3. 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.
  4. 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