Complaint resolution and recovery costs
Track resolution time, recovery spend, and the impact of recurrent complaints.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Süre aşımı (saat)
- 5.06
- Beklenen kupon gideri (TL)
- 194.26
- Toplam telafi (TL)
- 551.31
Who can use it, and for what?
Guest experience and branch management
Track resolution time, recovery spend, and the impact of recurrent complaints.
A worked example from the workbook
The first sample row in the baseline has the following results. Süre aşımı (saat) 5, Beklenen kupon gideri (TL) 196,1, Toplam telafi (TL) 554,93, Konu tekrar adedi 4. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Süre aşımı (saat) | 5.06 |
| Beklenen kupon gideri (TL) | 194.26 |
| Toplam telafi (TL) | 551.31 |
| Konu tekrar adedi | 4 |
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 one row per complaint. Record the issue category in the branch or category field. Keep final elapsed time on resolved cases and read recurrence across all entered records.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Kupon kullanım çarpanı”. The sample settings are 1 / 0,65 / 1,25. 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.
- Açık geçen saat
- Hedef çözüm saati
- İade (TL)
- Kupon nominal (TL)
- Kupon kullanım oranı
- Ekip dakika
- Ekip saat bedeli (TL)
Sample assumptions
- Kupon kullanım çarpanı
- 1