ExcelFlux
← Textiles and apparel

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.

Worksheet from the completed Excel sample
View from the Excel workbook. Open the image to enlarge it.
MeasureSample result
First-pass yield93.27%
Internal quality cost52,248
Cost including returns64,948.8

How do you start with your own data?

  1. Set unit costs for scrap, rework and returns and a first-pass yield target per cell.
  2. Post production, scrap, rework and returned quantities by date and cell code.
  3. Set the report start, end and scenario on Ayarlar. Both boundary dates are included.
  4. 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ç