Critical equipment downtime decision
Compare expedited and standard repair with lost contribution for the same incident.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Saatlik riskte katkı (TL)
- 779.68
- Normal toplam maliyet (TL)
- 37,622.7
- Hızlı toplam maliyet (TL)
- 26,511.85
Who can use it, and for what?
Facilities and operations managers
Compare expedited and standard repair with lost contribution for the same incident.
A worked example from the workbook
The first sample row in the baseline has the following results. Saatlik riskte katkı (TL) 780,3, Normal toplam maliyet (TL) 38.151,4, Hızlı toplam maliyet (TL) 26.424,2, Hızlı tamir avantajı (TL) 11.727,2. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Saatlik riskte katkı (TL) | 779.68 |
| Normal toplam maliyet (TL) | 37,622.7 |
| Hızlı toplam maliyet (TL) | 26,511.85 |
| Hızlı tamir avantajı (TL) | 11,110.86 |
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.
- Enter affected service hours and equipment-dependent sales. Estimate the share that alternative capacity can cover.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Talep çarpanı”. The sample settings are 1 / 0,7 / 1,3. 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.
- Normal tamir (TL)
- Hızlı tamir (TL)
- Normal duruş saat
- Hızlı duruş saat
- Saatlik satış (TL)
- Katkı oranı
- Alternatif kapasite payı
Sample assumptions
- Talep çarpanı
- 1