# Production Control Plan Worksheet for PPAP (Excel Export) > Source: https://netray.co/tools/ppap-control-plan-worksheet-automotive > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Editable control plan table covering characteristic, specification, measurement method, sample size, frequency and reaction plan. ## Category quality ## Industry Automotive ## Audience - Supplier quality engineer - Quality engineer - Process engineer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Op no. **Key:** op **Type:** text #### Machine / device **Key:** machine **Type:** text #### Characteristic **Key:** char **Type:** text #### Class **Key:** class **Type:** select **Options:** - None - Special (safety) - Special (fit/function) - Critical - Significant #### Specification / tolerance **Key:** spec **Type:** text #### Measurement method **Key:** method **Type:** text #### Sample size **Key:** sample **Type:** number #### Frequency **Key:** freq **Type:** text #### Control method **Key:** control **Type:** select **Options:** - SPC chart - Go/no-go gage - Poka-yoke - Visual check - First piece approval - Lot sampling #### Reaction plan **Key:** reaction **Type:** text **Rows:** **Op:** 20 **Machine:** CNC lathe 4 **Char:** Bore diameter **Class:** Special (fit/function) **Spec:** 22.000 +0.021 / 0 mm **Method:** Air gage **Sample:** 5 **Freq:** Every hour **Control:** SPC chart **Reaction:** Stop, contain last hour, adjust offset **Op:** 30 **Machine:** Deburr cell **Char:** Cross hole burr **Class:** Significant **Spec:** No burr visible at 10x **Method:** Visual with magnifier **Sample:** 1 **Freq:** Every 50 parts **Control:** Visual check **Reaction:** Rework lot, notify supervisor **Op:** 40 **Machine:** Wash line **Char:** Residual particle mass **Class:** Critical **Spec:** Max 2.0 mg per part **Method:** Gravimetric lab test **Sample:** 3 **Freq:** Every lot **Control:** Lot sampling **Reaction:** Hold lot, rewash, retest **Op:** 50 **Machine:** Pack station **Char:** Label content **Class:** None **Spec:** Matches work order **Method:** Barcode scan **Sample:** 1 **Freq:** Every box **Control:** Poka-yoke **Reaction:** Stop line, re-label box **Totals:** #### Total samples per cycle **Key:** sample **Agg:** sum **Format:** integer #### Control points **Key:** op **Agg:** count **Format:** integer **Notes:** The control plan is a living document. Use the prototype, pre-launch or production phase your customer expects and keep it aligned with the PFMEA and process flow. ## Content **Intro:** The control plan describes how each important product and process characteristic is controlled during production. In PPAP it is submitted with the PFMEA and process flow. This worksheet lays out the standard columns so you can fill it row by row and export it to Excel. **Sections:** #### How to fill each column **Body:** Use the same operation numbers as the process flow and PFMEA. List product characteristics from the drawing and process characteristics such as temperature, pressure or torque. Give each a specification with units, the measurement method including gage type, a sample size and a frequency, and a control method. The reaction plan should say what the operator does next, who is notified and how suspect product is contained. Vague entries like 'inform quality' are a frequent audit finding. **Bullets:** - Link every special characteristic to a control - State frequency as a number and a unit of time or quantity - Name the gage so the MSA study can be traced - Write reaction plans as actions, not intentions #### Choosing control methods **Body:** Poka-yoke and automatic checks are stronger than visual checks, and SPC suits variable data with enough volume to chart. Go/no-go gages are fast but give attribute data only. First piece approval protects against setup errors but not drift. Choose the method that matches the PFMEA detection rating you claimed, because a control plan that relies on a visual check cannot support a detection score of 2. #### Reading the example **Body:** The example shows four operations with different control strengths. The bore diameter is a fit and function characteristic charted by SPC with hourly samples. The wash residue is critical, so it is controlled by lot sampling with a hold. The summary counts control points and total samples per cycle, which helps you estimate inspection labour for the run at rate study. #### Common mistakes **Body:** Typical failures are mismatched operation numbers, specifications copied without units, sample sizes with no basis, and reaction plans that never mention containment. Review the control plan whenever the process, gage or customer requirement changes, and record the revision. If your ERP or MES holds routings and inspection plans, keep the characteristic and operation references identical there. **Cta:** If your inspection plans live in an ERP such as SAP QM or SyteLine, Netray can help check them against your control plan with read-only access. **Faq:** #### What are the three control plan phases? **Answer:** The AIAG control plan manual describes prototype, pre-launch and production phases. Prototype covers build and test of prototype parts, pre-launch covers the stage after prototype and before full production, and production is the full-volume control. Mark the phase on the header. #### Does a control plan replace work instructions? **Answer:** No. The control plan summarises what is controlled and how often. Detailed steps, setup values and gage handling belong in work instructions or inspection instructions that the control plan references. #### How is sample size decided? **Answer:** Base it on process capability, risk and customer requirements. Stable capable processes can use smaller or less frequent samples, while new or marginal processes need more. Document the rationale and review it after the initial process study. #### Can I export this worksheet? **Answer:** Yes. Download it as Excel, CSV or PDF using the export buttons and add your company header and revision details in the exported file. ## Search terms control plan template excel, production control plan format, ppap control plan example, apqp control plan worksheet, automotive control plan template, control plan reaction plan --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json