Project 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
- 92.75%
- Internal loss cost
- 9,054
- Cost including returns
- 11,654
Who can use it, and for what?
Software and consulting
For teams tracking project category records by delivery team. 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 | 92.75% |
| Internal loss cost | 9,054 |
| Cost including returns | 11,654 |
| Below-target records | 10 |
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 (Faturalanabilir saat)
- 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