Catering quote and contract margins
Compare event quotes with target margin, guaranteed attendance, and variable service costs.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Faturalanan kişi
- 109.69
- Beklenen ciro (TL)
- 87,515.06
- Beklenen katkı (TL)
- 34,583.94
Who can use it, and for what?
Catering sales teams and chefs
Compare event quotes with target margin, guaranteed attendance, and variable service costs.
A worked example from the workbook
The first sample row in the baseline has the following results. Faturalanan kişi 104, Beklenen ciro (TL) 84.240, Beklenen katkı (TL) 31.700, Hedef teklif (TL/kişi) 673,59. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Faturalanan kişi | 109.69 |
| Beklenen ciro (TL) | 87,515.06 |
| Beklenen katkı (TL) | 34,583.94 |
| Hedef teklif (TL/kişi) | 645.77 |
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 contracted minimum guests. Keep costs that vary with actual attendance separate from setup costs. Check the higher-cost case before quoting.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Yemek maliyeti çarpanı”. The sample settings are 1 / 0,9 / 1,16. 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.
- Garanti kişi
- Beklenen kişi
- Teklif (TL/kişi)
- Yemek (TL/kişi)
- Servis (TL/kişi)
- Sabit kurulum (TL)
- Hedef marj
Sample assumptions
- Yemek maliyeti çarpanı
- 1