ExcelFlux
← Restaurant and café

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.

MeasureSample result
Faturalanan kişi109.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?

  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 contracted minimum guests. Keep costs that vary with actual attendance separate from setup costs. Check the higher-cost case before quoting.
  3. 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.
  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.

  • 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