ExcelFlux
← Restaurant and café

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.

MeasureSample result
Ağırlıklı saat7.29
Havuz ağırlığı29.18
Kişi pay oranı25%
Kişi payı (TL)975

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. 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.
  3. 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.
  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.

  • Havuz kodu
  • Nakit havuzu (TL)
  • Kart havuzu (TL)
  • Uygun saat
  • Rol ağırlığı

Sample assumptions

Havuz dağıtım payı
1