ExcelFlux
← Restaurant and café

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.

MeasureSample result
Beklenen gelen kişi96.84
Tahmini koltuk kapasitesi124.69
Kapasite açığı1.89
Riskte satış (TL)1,029.72

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. Use guests rather than table counts. Estimate dining time from prior service. Review large groups and arrivals bunched into the same slots separately.
  3. 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.
  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.

  • 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