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, from the sample data to a plan built on your own numbers.
- 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 planning, until it isn't. These are the warning signs that you need a real production scheduling tool.
If three or more of these apply, you have outgrown spreadsheet planning. EDGEBIC, the current generation of RMDB, is User Solutions' finite capacity scheduling and production planning software. It imports the same orders, routings, work centers and stock from Excel, CSV or your ERP, schedules them against real machine, labor and material limits, and shows the result on a drag-and-drop Gantt chart. It is a one-time license: EDGEBIC APS is $25,000, and EDGEBIC Complete, which adds MRP, inventory and purchasing, is $35,000.
See EDGEBICNot ready to decide? Read what actually changes when you move off the spreadsheet, or see the published price before you talk to anyone.
Frequently 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.
Start with the spreadsheet. Move to EDGEBIC when it breaks.
The template handles the math for a small plan. EDGEBIC is what manufacturers move to when orders, routings and capacity change faster than a spreadsheet can follow: published one-time pricing, and implementation measured in days.