ExcelFlux
← Restaurant and café

Absence and shift cover costs

Estimate role coverage gaps and budget impact after expected absences.

Restaurant and Café Pack · Excel workbook in Turkish

Results from the sample workbook

Kalan plan saati
40.47
Kullanılan yedek saat
3.57
Kapsanmayan saat
0.29

Who can use it, and for what?

Staffing and operations teams

Estimate role coverage gaps and budget impact after expected absences.

A worked example from the workbook

The first sample row in the baseline has the following results. Kalan plan saati 39,6, Kullanılan yedek saat 0,4, Kapsanmayan saat 0, Bütçe farkı (TL) -807. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.

MeasureSample result
Kalan plan saati40.47
Kullanılan yedek saat3.57
Kapsanmayan saat0.29
Bütçe farkı (TL)161.02

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 required hours by role and shift. This model retains planned labour cost and adds cover cost. Resolve uncovered hours before approving.
  3. Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Devamsızlık çarpanı”. The sample settings are 1 / 0,5 / 1,6. 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.

  • Plan kişi-saat
  • Gereken kişi-saat
  • Tahmini devamsızlık
  • Yedek saat kapasitesi
  • Yedek saat bedeli (TL)
  • Normal maliyet (TL/saat)
  • Vardiya bütçesi (TL)

Sample assumptions

Devamsızlık çarpanı
1