New branch opening budget and delays
Compare setup cost, actual spending, and delay costs with funding available for opening.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Gecikme yükü (TL)
- 66,486
- Tahmini toplam (TL)
- 569,746
- Bütçe aşımı (TL)
- 40,971
Who can use it, and for what?
Founders and launch teams
Compare setup cost, actual spending, and delay costs with funding available for opening.
A worked example from the workbook
The first sample row in the baseline has the following results. Gecikme yükü (TL) 67.200, Tahmini toplam (TL) 569.200, Bütçe aşımı (TL) 49.200, Finansman açığı (TL) 19.200. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Gecikme yükü (TL) | 66,486 |
| Tahmini toplam (TL) | 569,746 |
| Bütçe aşımı (TL) | 40,971 |
| Finansman açığı (TL) | 42,413.06 |
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.
- Separate open commitments from amounts paid. Enter total funding on the same project basis as the budget. Avoid duplicating delay costs already captured elsewhere.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Kalan iş çarpanı”. The sample settings are 1 / 0,9 / 1,25. 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.
- Onaylı bütçe (TL)
- Ödenen (TL)
- Açık taahhüt (TL)
- Taahhütsüz kalan (TL)
- Gecikme gün
- Günlük ek maliyet (TL)
- Hazır kaynak (TL)
Sample assumptions
- Kalan iş çarpanı
- 1