ExcelFlux
← Restaurant and café

Branch profit and loss variance bridge

Bridge budget to actual operating profit using volume, price, unit cost, and branch overhead.

Restaurant and Café Pack · Excel workbook in Turkish

Results from the sample workbook

Hacim etkisi (TL)
14,608.5
Fiyat etkisi (TL)
-16,251.19
Gider etkisi (TL)
-23,581.94

Who can use it, and for what?

Multi-site operators

Bridge budget to actual operating profit using volume, price, unit cost, and branch overhead.

A worked example from the workbook

The first sample row in the baseline has the following results. Hacim etkisi (TL) 13.200, Fiyat etkisi (TL) -16.160, Gider etkisi (TL) -22.160, Faaliyet sonucu farkı (TL) -25.120. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.

MeasureSample result
Hacim etkisi (TL)14,608.5
Fiyat etkisi (TL)-16,251.19
Gider etkisi (TL)-23,581.94
Faaliyet sonucu farkı (TL)-25,224.63

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 weighted net prices and costs for the same product mix per branch and month. Identify the driver behind any negative movement.
  3. Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Ek maliyet çarpanı”. The sample settings are 1 / 0,95 / 1,07. 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.

  • Bütçe adet
  • Fiili adet
  • Bütçe net fiyat (TL)
  • Fiili net fiyat (TL)
  • Bütçe birim gider (TL)
  • Fiili birim gider (TL)
  • Bütçe sabit (TL)
  • Fiili sabit (TL)

Sample assumptions

Ek maliyet çarpanı
1