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.
| Measure | Sample result |
|---|---|
| Net porsiyon | 119.06 |
| Birim katkı (TL) | 160.44 |
| Toplam katkı (TL) | 19,071.63 |
| Katkı marjı | 64.67% |
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.
- 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.
- 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.
- 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