PCBA Rework Cost Tracking Worksheet
Rework is a hidden cost in electronics assembly, often buried in labor variances. This editable worksheet records each rework event with its time and material so the cost of poor quality becomes visible by work order and defect type.
| Work order | Assembly part no. | Defect type | Boards reworked | Minutes per board | Labor rate per hour | Material cost | Labor cost | Total rework cost | Date | |
|---|---|---|---|---|---|---|---|---|---|---|
$58 | $62 | |||||||||
$29 | $31 | |||||||||
$43 | $62 | |||||||||
$50 | $54 | |||||||||
$39 | $101 |
Add one row per work order, assembly and defect type. Include re-inspection time in minutes per board. Add scrap value as material cost if a board or component is scrapped.
Cost of poor quality from ERP data
Optional: talk through pulling rework, scrap and labor from your ERP into one view.
Optional. The tool and every export work without this. No spam.
How to use it
Add a row for each rework event. Enter the work order, the assembly, the defect type, boards reworked, minutes per board, labor rate and any material cost, such as replacement parts, solder and flux, or scrapped components. The worksheet computes labor and total cost per line and totals the sheet. Export to Excel to pivot by defect type, product or week.
- Use the same defect names as your AOI and inspection codes.
- Include re-inspection and retest time in minutes.
- Log scrap material in the material column.
Why track rework cost
Rework consumes skilled hours, adds thermal cycles to boards and can hide process problems. Under AS9100 and similar quality systems, rework and repair require controlled procedures and records, and many defense customers specify workmanship standards such as IPC-A-610 and J-STD-001 for acceptance. Putting cost on each event helps rank corrective actions by money and hours rather than by gut feel.
Reading the summary
The average rework cost per board shows the average cost of every reworked unit, while the highest line cost points to expensive single events such as damaged components. In the example, a handful of low-cost bridging fixes add up to less than one damaged high value part. Sort by defect type in Excel to see where reworking time goes, then compare with DPMO trends for the same assemblies.
Common mistakes
Teams often log only labor and forget material, scrap and retest. Another mistake is mixing rework and repair in one log: they differ in how they are authorized and documented, so keep a separate column or sheet if your system needs it. Avoid vague defect labels like Other, because they hide the pattern you need for corrective action. Reconcile with ERP labor reporting monthly so the log stays honest.
Frequently Asked Questions
What is the difference between rework and repair?
Rework returns a product to its original specification using the original or an approved process. Repair makes a nonconforming product usable without fully meeting its original specification, and usually needs a documented disposition.
Should labor rate include overhead?
Use the rate your finance team agrees for cost of quality analysis. A fully burdened rate shows true cost, while direct rate shows the cash labor. Be consistent between periods.
How do I handle scrap?
Enter the cost of any scrapped board or component in the material column for the event, and use a clear defect type such as Damaged component so scrap can be filtered later.
Can I use this with IPC-A-610 rejects?
Yes. Log each reject by defect type, then compare against your acceptance criteria and corrective action records. The worksheet records cost; it does not replace your inspection standard.
If rework data should flow into your ERP cost of quality and nonconformance records, Netray can discuss how to connect it on your own systems.
Related Tools
Solder Defect DPMO and First Pass Yield Calculator
Turn inspection defect counts into DPMO, defects per unit, expected first pass yield and a sigma level for assembly lines.
Electronics ManufacturingSolder Paste Stencil Area Ratio Calculator
Check rectangular stencil apertures against area ratio and aspect ratio guidelines and find the thickest foil that still releases paste.
Electronics ManufacturingMSL Floor Life and Exposure Time Remaining Calculator
Compute how much moisture sensitivity floor life remains after a part has been out of its dry bag, and whether a planned run will exceed it.
More Quality & Inspection tools
See all- J-STD-001 Solder Workmanship Inspection Checklist
- Solder Joint Defect Log and DPMO Worksheet
- Rolled Throughput Yield Calculator for PCB Assembly
- SAP QM Process Capability Cp Cpk Calculator
- SAP QM Lot Rejection Rate, PPM and Sigma Level Calculator
- SAP QM Gauge R&R Study Calculator
- SAP QM Cp and Cpk Capability Calculator
- Job Shop Material Certification Log Worksheet
- Job Shop First Piece Inspection Sign-Off Template