Quality & InspectionFree worksheetPDF, Excel, Word exportAutomotive

CS1 and CS2 Containment Log Worksheet

When a customer places you on controlled shipping after a quality escape, you need a clean record of every lot inspected, what was found and what it cost. This worksheet is a simple log you can fill in daily and share.

Download:
DatePart numberLot or batchLevelQty inspectedDefects foundReject rate %Inspection hoursRate per hourContainment costClean lot?
0.25
$392
0.0833
$364
0
$364
0
$405
0
$405
Total inspected
12,000
Total defects found
8
Total inspection hours
58
Total containment cost
$1,930
Overall reject rate %
0.0667
Containment cost per part inspected
$0

CS1 is an additional inspection by your own staff inside the plant. CS2 is a further inspection, often by a third party or a separate team, with reporting to the customer. Exit criteria, such as a number of consecutive clean lots, are set by the customer: record them in your notes. Rate per hour should reflect your real or invoiced cost.

Lot-level containment data from ERP

Optional: see how inspection and lot records can fill this log for you.

Optional. The tool and every export work without this. No spam.

How to use the log

Add one row per lot or inspection batch with the date, part, lot number and containment level. Enter the quantity inspected, the defects found, the hours spent and the rate per hour. The worksheet calculates the reject rate per row and the cost, and totals both. Mark each lot clean or not so you can see consecutive clean lots against the exit requirement. Export to Excel to send to the customer or attach to the 8D.

CS1 and CS2 explained

Controlled shipping, as used by many automotive OEMs, is a formal containment status. Level 1 generally means an added inspection by the supplier at the supplier site with defined reporting. Level 2 generally means a further inspection, often by an independent party, and a higher level of oversight. The exact names, steps and exit rules differ by customer, so always follow your customer's procedure and contract.

  • Containment is temporary and does not replace root cause correction
  • Record inspection method, gauge and sample or 100 percent
  • Track consecutive clean lots required to exit
  • Keep the cost: it supports cost recovery and prioritization

Common mistakes

Teams often inspect with the same method that missed the defect, so define a different or more sensitive method. Another mistake is losing the link between the log and the corrective action: store the 8D number with the log. Containment cost can be significant, so also use a cost calculator to compare sorting with fixing the process. If your ERP records inspection results by lot, use them as the source for the log so numbers match what the customer sees.

Frequently Asked Questions

What is controlled shipping?

Controlled shipping is a formal containment status some automotive customers impose after a significant quality issue. The supplier adds inspection steps and reports results until agreed exit criteria are met. Names and rules vary by customer.

What is the difference between CS1 and CS2?

In most programs CS1 is an added inspection by the supplier, and CS2 adds independent verification and tighter oversight. The details differ by OEM, so use your customer's supplier manual as the authority.

How do I exit controlled shipping?

Exit usually requires verified corrective action and a set number of consecutive lots or a time period with no defects, accepted by the customer in writing. Record every clean lot in the log and keep the evidence.

Can I recover containment costs?

Customers often charge costs back to the supplier and may expect you to pay for third-party inspection. Keep clear records of hours and rates, and also use them to build the business case for fixing the root cause.

Netray can feed inspection results and lot data from your ERP into a containment dashboard on your own servers. The worksheet is free without us.