Production Quality, Scrap and Rework
See first-pass yield, internal quality costs and the impact of customer returns by production cell.
Premium workbook preview · Member downloads are not yet available
Results from the sample workbook
- First-pass yield
- 93.27%
- Internal quality cost
- 52,248
- Cost including returns
- 64,948.8
Who can use it, and for what?
Quality, manufacturing engineering and cost control
Separate scrap, rework and return costs when choosing which cell to investigate.
A worked example from the workbook
K-001 has a first-pass yield of 93.27%. Internal quality costs 52,248, rising to 64,948.80 with customer returns included. The difference isolates the cost of returns.

| Measure | Sample result |
|---|---|
| First-pass yield | 93.27% |
| Internal quality cost | 52,248 |
| Cost including returns | 64,948.8 |
How do you start with your own data?
- Set unit costs for scrap, rework and returns and a first-pass yield target per cell.
- Post production, scrap, rework and returned quantities by date and cell code.
- Set the report start, end and scenario on Ayarlar. Both boundary dates are included.
- Review per-record calculations on Analiz and totals and selected cards such as K-001 on Panel. Resolve unmatched codes, missing dates and duplicate records on Kontrol.
Test a different scenario
Raise the return-cost multiplier in Ayarlar B9 from 1.20 to 1.50. K-001 stays at 93.27% first-pass yield, while cost including returns rises from 64,948.80 to 68,124. Keep K-001 selected on Panel and compare the result. Restore the original input when you finish.
Hücre adresleri ve formüller için Türkçe kılavuzu aç