ExcelFlux
← Restaurant and café

Menu engineering and product mix

Separate popularity from unit contribution to decide which dishes to feature, reprice, or retire.

Restaurant and Café Pack · Excel workbook in Turkish

Results from the sample workbook

Net porsiyon
119.06
Birim katkı (TL)
160.44
Toplam katkı (TL)
19,071.63

Who can use it, and for what?

Menu committees and kitchen managers

Separate popularity from unit contribution to decide which dishes to feature, reprice, or retire.

A worked example from the workbook

The first sample row in the baseline has the following results. Net porsiyon 117, Birim katkı (TL) 155, Toplam katkı (TL) 18.135, Katkı marjı %64,58. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.

MeasureSample result
Net porsiyon119.06
Birim katkı (TL)160.44
Toplam katkı (TL)19,071.63
Katkı marjı64.67%

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 sales from one menu period and record returns as units. Feature dishes that combine high volume with strong unit contribution. Price scenarios hold volume constant.
  3. Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Fiyat senaryosu”. The sample settings are 1 / 0,92 / 1,08. 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.

  • Satılan porsiyon
  • Porsiyon fiyatı (TL)
  • Malzeme (TL)
  • Değişken servis (TL)
  • İade adedi

Sample assumptions

Fiyat senaryosu
1