ExcelFlux
← Restaurant and café

Bar stock and beverage yield reconciliation

Reconcile theoretical usage from served drinks against measured closing stock.

Restaurant and Café Pack · Excel workbook in Turkish

Results from the sample workbook

Fiili kullanım (litre)
14.63
Beklenen kullanım (litre)
12.23
Açıklanamayan fark (litre)
2.4

Who can use it, and for what?

Bar managers and stocktake teams

Reconcile theoretical usage from served drinks against measured closing stock.

A worked example from the workbook

The first sample row in the baseline has the following results. Fiili kullanım (litre) 14, Beklenen kullanım (litre) 12,35, Açıklanamayan fark (litre) 1,65, Fark maliyeti (TL) 627. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.

MeasureSample result
Fiili kullanım (litre)14.63
Beklenen kullanım (litre)12.23
Açıklanamayan fark (litre)2.4
Fark maliyeti (TL)819.33

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. Measure open bottles by volume. Avoid counting comps or documented loss as sales. A positive variance means actual consumption exceeded expectation.
  3. Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Hacim toleransı (litre)”. The sample settings are 0,45 / 0,2 / 0,9. 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.

  • Açılış (litre)
  • Giriş (litre)
  • Ölçülen kapanış (litre)
  • Satılan servis
  • Standart ml
  • Belgeli ikram/kayıp (litre)
  • Birim litre (TL)

Sample assumptions

Hacim toleransı (litre)
0.45