Supplier Trail Bundle Excel | 11 Quality Tools: Receiving Inspection, SCAR, 8D, Supplier Scorecard, Supplier Audit | IATF 16949

One bad lot. From the receiving dock to a proven supplier fix.

A bad lot does not end when you reject it. It runs from the receiving dock, through containment and a decision, to a supplier corrective action, and finally to proof that the fix held and a look at the source. This bundle gives you a working Excel tool for every step of that trail, built to hand off from one step to the next.

It is the companion to the free field book “One Bad Lot. The Supplier Trail.” The book walks the 8 steps. This bundle gives you the 11 tools to run them.

The 11 tools, step by step

Step 1: Receive and inspect

QA-F-275 Receiving Inspection Report: check the incoming lot at the dock and record the result.

Step 2: Contain

QA-F-215 NCM Red Tag Log: tag the nonconforming material and log where it is.
QA-F-200 Quality Alert Form: tell the floor what the problem is and what to do about it, with operator acknowledgment.

Step 3: Decide and tell

QA-F-235 Deviation Waiver Form: make the call in writing when you need to use or ship the lot, with approvals and an expiry.

Step 4: Ask for the fix

QA-F-394 SCAR Form: issue the supplier corrective action request and score the supplier’s response against seven criteria before you accept it.
QA-F-395 SCAR Tracker: follow every SCAR to verified close, with overdue replies and a supplier scorecard on the dashboard.

Step 5: Find the cause

QA-F-355 8D Report: D1 through D8 on one page, from containment to prevention.

Step 6: Prove the fix

QA-F-393 Effectiveness Verification Tracker: checks at 30, 60 and 90 days, recurrences counted, with a closure gate that says close, hold or reopen.

Step 7: Update the record

QA-F-380 Incoming Part History: log every incoming lot against the part and see which characteristic rejects most.

Step 8: Audit the source

QA-F-220 Supplier Scorecard: rate each supplier on quality, delivery and responsiveness, month by month.
QA-F-396 Supplier Audit Checklist: 45 weighted questions across nine areas, with a rating and a findings list. Every Major finding points back to a SCAR.
One trail, start to finish
Receive and contain: inspect the lot, tag it, alert the floor
Decide and ask: write the waiver decision, issue the SCAR, track the reply
Find and prove: run the 8D, then verify the fix at 30, 60 and 90 days
Record and audit: log the part history, score the supplier, audit the source
How this differs from our other supplier bundles

The Supplier Onboarding bundle and the Supplier & Incoming Inspection bundle stay available as shorter, entry-level sets. The Supplier Trail Bundle covers the whole path, from the receiving dock to the supplier audit.

Details
11 Excel workbooks in one instant download
Works with Excel 2016, 2019, 2021 and Microsoft 365
Departments, suppliers and examples are generic, so replace them with your own
Open each workbook’s instructions tab for setup

Built by a quality practitioner for quality practitioners: supplier quality engineers, receiving inspectors, quality managers, buyers, and IATF 16949 / ISO 9001 sites. Standards referenced for informational alignment only. Not a certification.