Service category · Loss and rework
Separate first-pass yield, scrap and rework. Compare the cost of corrections and returns.
Premium preview · Member downloads are not yet available · Excel workbook in Turkish
Results from the sample workbook
- First-pass yield
- 90.56%
- Internal loss cost
- 10,397
- Cost including returns
- 12,997
Who can use it, and for what?
Hair and beauty salons
For teams tracking service category records by salon branch. Separate first-pass yield, scrap and rework. Compare the cost of corrections and returns.
A worked example from the workbook
These figures come from 16 fictional records in the workbook’s Panel sheet.
| Measure | Sample result |
|---|---|
| First-pass yield | 90.56% |
| Internal loss cost | 10,397 |
| Cost including returns | 12,997 |
| Below-target records | 13 |
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.
- İşlenen (Randevu)
- Tam kayıp
- Yeniden işlenen
- Kayıp birim bedeli
- Tekrar işlem birim bedeli
- Sonradan iade
Sample assumptions
- İlk geçiş hedefi
- 0.94
- İade birim kaybı
- 65