ExcelFlux
← Restaurant and café

Delivery contribution and basket threshold

Calculate order contribution and the minimum basket needed to earn a target contribution.

Restaurant and Café Pack · Excel workbook in Turkish

Results from the sample workbook

Net sepet (TL)
402.75
Sipariş maliyeti (TL)
190.63
Sipariş katkısı (TL)
132.52

Who can use it, and for what?

Delivery teams and branch owners

Calculate order contribution and the minimum basket needed to earn a target contribution.

A worked example from the workbook

The first sample row in the baseline has the following results. Net sepet (TL) 396, Sipariş maliyeti (TL) 192, Sipariş katkısı (TL) 124,8, Asgari brüt sepet (TL) 357,75. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.

MeasureSample result
Net sepet (TL)402.75
Sipariş maliyeti (TL)190.63
Sipariş katkısı (TL)132.52
Asgari brüt sepet (TL)357.45

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. Enter merchant coupons, actual delivery and packaging costs separately. Evaluate the impact of any new basket threshold on demand.
  3. Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Kurye çarpanı”. The sample settings are 1 / 0,8 / 1,3. 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.

  • Sepet (TL)
  • İşletme kuponu (TL)
  • Yemek maliyeti (TL)
  • Ambalaj (TL)
  • Kurye (TL)
  • Komisyon
  • Hedef katkı (TL)

Sample assumptions

Kurye çarpanı
1