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.
| Measure | Sample 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?
- 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 weighted net prices and costs for the same product mix per branch and month. Identify the driver behind any negative movement.
- 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.
- 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