Reservation no-shows and seating capacity
Compare reservations and walk-ins with expected no-shows and seat turnover.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Beklenen gelen kişi
- 96.84
- Tahmini koltuk kapasitesi
- 124.69
- Kapasite açığı
- 1.89
Who can use it, and for what?
Hosts and restaurant managers
Compare reservations and walk-ins with expected no-shows and seat turnover.
A worked example from the workbook
The first sample row in the baseline has the following results. Beklenen gelen kişi 96,36, Tahmini koltuk kapasitesi 122, Kapasite açığı 0, Riskte satış (TL) 0. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Beklenen gelen kişi | 96.84 |
| Tahmini koltuk kapasitesi | 124.69 |
| Kapasite açığı | 1.89 |
| Riskte satış (TL) | 1,029.72 |
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.
- Use guests rather than table counts. Estimate dining time from prior service. Review large groups and arrivals bunched into the same slots separately.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Gelmeme çarpanı”. The sample settings are 1 / 0,55 / 1,55. 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.
- Rezerve kişi
- Gelmeme oranı
- Beklenen walk-in
- Koltuk
- Açık dakika
- Ortalama oturum dk
- Kişi başı net satış (TL)
Sample assumptions
- Gelmeme çarpanı
- 1