Sales and labour by service interval
Compare sales, staffing load, and labour ratio by service interval.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Saatlik gelir (TL)
- 29,061.74
- Misafir/kişi-saat
- 4.37
- İşçilik payı
- 25.64%
Who can use it, and for what?
Scheduling and branch managers
Compare sales, staffing load, and labour ratio by service interval.
A worked example from the workbook
The first sample row in the baseline has the following results. Saatlik gelir (TL) 27.800, Misafir/kişi-saat 4,13, İşçilik payı %25,9, Ortalama eşzamanlı servis 22,73. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Saatlik gelir (TL) | 29,061.74 |
| Misafir/kişi-saat | 4.37 |
| İşçilik payı | 25.64% |
| Ortalama eşzamanlı servis | 23.68 |
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 combined staff hours per interval. Demand scenarios hold spend per guest steady. Check where labour costs and capacity pressure overlap.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Talep çarpanı”. The sample settings are 1 / 0,72 / 1,24. 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.
- Net satış (TL)
- Misafir sayısı
- Ekip kişi-saat
- Saatlik maliyet (TL)
- Ortalama servis dk
- Dilimin süresi (saat)
Sample assumptions
- Talep çarpanı
- 1