# CS1 and CS2 Containment Log Worksheet > Source: https://netray.co/tools/automotive-containment-cs1-cs2-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable log for controlled shipping level 1 and level 2 containment: quantity sorted, defects found, hours, cost and the consecutive clean lots needed to exit. ## Category quality ## Industry Automotive ## Audience - Quality engineer - Customer quality engineer - Production supervisor ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Date **Key:** date **Type:** date #### Part number **Key:** part **Type:** text #### Lot or batch **Key:** lot **Type:** text #### Level **Key:** level **Type:** select **Options:** - CS1 - CS2 #### Qty inspected **Key:** sorted **Type:** number **Format:** integer #### Defects found **Key:** found **Type:** number **Format:** integer #### Reject rate % **Key:** reject_pct **Type:** number **Expr:** found / sorted * 100 **Format:** decimal #### Inspection hours **Key:** hours **Type:** number **Format:** decimal #### Rate per hour **Key:** rate **Type:** number **Format:** currency #### Containment cost **Key:** cost **Type:** number **Expr:** hours * rate **Format:** currency #### Clean lot? **Key:** clean **Type:** select **Options:** - Yes - No **Rows:** **Date:** 2026-10-05 **Part:** BR-48213-A **Lot:** L26-2841 **Level:** CS1 **Sorted:** 2400 **Found:** 6 **Hours:** 14 **Rate:** 28 **Clean:** No **Date:** 2026-10-06 **Part:** BR-48213-A **Lot:** L26-2842 **Level:** CS1 **Sorted:** 2400 **Found:** 2 **Hours:** 13 **Rate:** 28 **Clean:** No **Date:** 2026-10-07 **Part:** BR-48213-A **Lot:** L26-2843 **Level:** CS1 **Sorted:** 2400 **Found:** 0 **Hours:** 13 **Rate:** 28 **Clean:** Yes **Date:** 2026-10-08 **Part:** BR-48213-A **Lot:** L26-2844 **Level:** CS2 **Sorted:** 2400 **Found:** 0 **Hours:** 9 **Rate:** 45 **Clean:** Yes **Date:** 2026-10-09 **Part:** BR-48213-A **Lot:** L26-2845 **Level:** CS2 **Sorted:** 2400 **Found:** 0 **Hours:** 9 **Rate:** 45 **Clean:** Yes **Totals:** #### Total inspected **Key:** sorted **Agg:** sum **Format:** integer #### Total defects found **Key:** found **Agg:** sum **Format:** integer #### Total inspection hours **Key:** hours **Agg:** sum **Format:** decimal #### Total containment cost **Key:** cost **Agg:** sum **Format:** currency **Summary:** #### Overall reject rate % **Key:** overall_reject **Expr:** sum_found / sum_sorted * 100 **Format:** decimal #### Containment cost per part inspected **Key:** cost_per_part **Expr:** sum_cost / sum_sorted **Format:** currency **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How to use the log **Body:** 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 **Body:** 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. **Bullets:** - 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 **Body:** 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. **Cta:** 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. **Faq:** #### What is controlled shipping? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms controlled shipping level 1 log, CS1 CS2 containment log, controlled shipping level 2 template, containment inspection log, controlled shipping exit criteria, CS1 controlled shipping automotive, containment tracking excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json