ExcelFlux
← Restaurant and café

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.

MeasureSample result
Saatlik gelir (TL)29,061.74
Misafir/kişi-saat4.37
İşçilik payı25.64%
Ortalama eşzamanlı servis23.68

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 combined staff hours per interval. Demand scenarios hold spend per guest steady. Check where labour costs and capacity pressure overlap.
  3. 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.
  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.

  • 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