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.
| Measure | Sample result |
|---|---|
| Kalan plan saati | 40.47 |
| Kullanılan yedek saat | 3.57 |
| Kapsanmayan saat | 0.29 |
| Bütçe farkı (TL) | 161.02 |
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 required hours by role and shift. This model retains planned labour cost and adds cover cost. Resolve uncovered hours before approving.
- 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.
- 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