Items
10
Annual usage value
$102,618
A items
3
ABC Inventory Analysis
Rank every item by annual usage value and class it A, B or C so you know where control matters most.
6 free supply chain analysis templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 5 spreadsheets and 1 document from Manufacturing & Operations, Inventory & Stock Management and Purchasing & Procurement. Start with ABC Inventory Analysis, Failure Mode and Effects Analysis (FMEA) and Vendor Quote Comparison: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Items
10
Annual usage value
$102,618
A items
3
Rank every item by annual usage value and class it A, B or C so you know where control matters most.
Failure modes
8
High priority
1
Highest RPN
175
Rate severity, occurrence and detection for every failure mode, get the RPN and action priority, and track risk after actions.
Quotes compared
5
Lowest landed cost
$6,050
Spread, lowest to highest
$640
Compare supplier quotes on total landed cost, lead time and terms, with a weighted score.
Units inspected
2,370
Defect rate
3%
First-pass yield
97%
Record inspections, defects by type and the defect rate, with the few causes behind most rejects.
| Owner | Problem owner name, role |
| Coach / sponsor | Name, role |
| Team | Moulding technician, qualit |
1. Background
Why does this problem matter now? Two or three sentences. Line 2 moulds the ID-40 cover for our largest customer. Scrap rose from a stable 1.8% to 4.6% over the last quarter, costing about $11,200 a month in material
2. Current condition
Go and see. Show the facts and the gap to the standard.
| Measure | Standard / target | Current (Sep 2026) |
| Scrap rate | 2.0% | 4.6% |
| Short shots (share of scrap) | Not tracked | 58% |
Tell the whole story of a problem on one page: background, current condition, target, root cause, countermeasures and results.
Effective capacity
4,399
Required hours
2,414.5
Over capacity
1
Compare required hours with effective capacity for every work centre, using efficiency and OEE, and find the bottleneck.