Free Scrap Rate Tracker Excel Template
Log every scrapped part with a real reason code. Calculate scrap rate by work center, by operator, and by part number. Most shops cut scrap 30%+ in year one.
What you get
Working scrap tracker with reason codes, cost roll-up, and Pareto analysis. Captures the data needed to actually attack scrap — not just report on it after the fact.
Free 30-day trial · No credit card required · Used by manufacturers since 1991
Why manufacturers still use Excel for this
Scrap is the most visible waste in any shop, and the hardest to fix without data. Every scrap event has a reason — but if the reason is logged as "operator error" or "material issue," nothing improves. Categorical clarity in the reason codes is what separates a useful scrap tracker from a paper trail.
This template forces structure: part number, quantity scrapped, work center, operator, root-cause category, and a free-text "what actually happened" field. The free text matters as much as the code — patterns hide in the descriptions that codes miss.
A 90-day tracking discipline plus a weekly Pareto review is usually enough to identify the top 3 causes. Fix those, and most shops drop their scrap rate 30–40% in the first year. After that, RMX or RMDB can wire scrap capture directly into the work order so you do not need a separate spreadsheet.
What's inside the template
Scrap event log
Date, work order, part number, operation, quantity scrapped, scrap cost, work center, operator, root-cause code, and notes.
Root-cause code dictionary
Standardized categories: setup error, material defect, tool wear, programming error, operator skill, equipment fault, design issue.
Scrap rate by work center
Scrap quantity ÷ total produced quantity, by work center. Identifies which areas of the shop produce the most defects.
Scrap cost rollup
Total cost of scrapped material + labor consumed before scrap. The financial size of the problem.
Pareto by root cause
Top 10 root causes by scrap cost. This is the worksheet you use to pick your improvement project.
Trend chart by month
12-month rolling chart of scrap rate. Track whether interventions are working.
How to use this template
A practical walkthrough — five steps from blank spreadsheet to a working schedule.
- 1
Standardize reason codes before logging
Agree on 10–15 root-cause codes with your quality and production team. Codes the operators understand get used; abstract codes do not.
- 2
Capture cost, not just count
A 100-part scrap event of a $2 part is different from a 5-part scrap event of a $300 part. The cost column drives the Pareto priority.
- 3
Review weekly, attack monthly
Weekly reviews keep the data fresh. Monthly improvement projects are paced for impact — pick one root cause and run a 30-day fix project.
- 4
Close the loop with verification
After each fix, the trend chart confirms whether scrap on that work center actually dropped. If not, the root cause was wrong.
When you outgrow this template
Excel is the right answer for early-stage scheduling — until it isn't. Here are the warning signs that you need a real production scheduling tool.
If three or more of these apply, you have outgrown Excel scheduling. The good news: you do not have to leave Excel behind. Resource Manager for Excel (RMX) is a real finite-capacity scheduling engine that runs as an Excel add-in — so your team keeps the interface they know while gaining the scheduling power of a dedicated APS tool.
Learn about RMXFrequently asked questions
What scrap rate is "normal" for manufacturing?+
It varies wildly by industry. Precision machining typically runs 1–3%. Plastic injection molding can run 0.5–2%. Food processing can run 5–10% due to yield variability. The right benchmark is your own trend — is scrap going down over time?
How do I calculate scrap rate correctly?+
Scrap rate = (scrap quantity ÷ total produced quantity) × 100. Always use the same units — pieces, pounds, gallons. The trap is calculating against "good parts" instead of "total parts" — that understates the problem.
Should I track scrap by part, by work center, or by operator?+
All three. By part identifies design issues. By work center identifies process issues. By operator identifies training gaps (and protects against blame culture — patterns across many operators usually mean a process problem).
What is the difference between scrap and rework?+
Scrap = part is unsalvageable, written off completely. Rework = part can be fixed with additional labor. Both cost money but the fix paths differ. Track them separately — combining them obscures the right action.
Get the free template — plus the tool that grew up around it
The template is the starting point. Resource Manager for Excel (RMX) is what manufacturers move to when their Excel scheduler starts breaking. 35+ years in production, free 30-day trial.