Tip pool and shift allocation
Allocate each shift’s tip pool by eligible hours and role weights.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Ağırlıklı saat
- 7.29
- Havuz ağırlığı
- 29.18
- Kişi pay oranı
- 25%
Who can use it, and for what?
Service managers and accounting
Allocate each shift’s tip pool by eligible hours and role weights.
A worked example from the workbook
The first sample row in the baseline has the following results. Ağırlıklı saat 7,35, Havuz ağırlığı 28,16, Kişi pay oranı %26,1, Kişi payı (TL) 939,63. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Ağırlıklı saat | 7.29 |
| Havuz ağırlığı | 29.18 |
| Kişi pay oranı | 25% |
| Kişi payı (TL) | 975 |
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.
- Repeat the same cash and card pool totals for every eligible employee in that pool. Compare the sum of rounded shares with the pool before paying.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Havuz dağıtım payı”. The sample settings are %100 / %90 / %100. 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.
- Havuz kodu
- Nakit havuzu (TL)
- Kart havuzu (TL)
- Uygun saat
- Rol ağırlığı
Sample assumptions
- Havuz dağıtım payı
- 1