Department · Utilisation and yield
Read available capacity, utilisation and revenue per capacity unit together. Quantify unused capacity.
Premium preview · Member downloads are not yet available · Excel workbook in Turkish
Results from the sample workbook
- Saleable capacity
- 3,267
- Utilisation
- 65.38%
- Net revenue
- 273,891.78
Who can use it, and for what?
Grocery and retail
For teams tracking department records by store. Read available capacity, utilisation and revenue per capacity unit together. Quantify unused capacity.
A worked example from the workbook
These figures come from 16 fictional records in the workbook’s Panel sheet.
| Measure | Sample result |
|---|---|
| Saleable capacity | 3,267 |
| Utilisation | 65.38% |
| Net revenue | 273,891.78 |
| Operating contribution | 150,138.78 |
How do you start with your own data?
- Choose a start and end date on Panel. If the workbook has assumptions, replace the example values with your own.
- Replace the sample records in the yellow cells on Girdiler. Enter a unique ID and a valid date for each record.
- Review period totals and breakdowns on Panel. Resolve flags on Kontrol and trace calculations on Hesap.
Workbook input fields
Labels appear in Turkish in the workbook.
- Brüt kapasite (Satış birimi)
- Plan dışı kapalı kapasite
- Kullanılan kapasite
- Birim brüt gelir
- Kanal kesintisi
- Birim kullanım gideri