Control Plan Template in Excel

Compatible with AIAG Standards, Excel 2010-2019 and Office 365

Purpose of a control plan: To aid the manufacturing of quality products by using a structured approach to identify and implement value-added controls to minimize process and product variation.

QI Macros Add-in for Excel includes these Control Plan Templates

Control Plan

Special Characteristics

Control Plan Checklist

QI Macros SPC add-in for Excel also includes:

• APQP Checklists
• PPAP Forms
• MSA Gage R&R Templates
• Macros to draw control charts, histograms, paretos, fishbones and more with the click of a button

How to Create a Control Plan

1. QI Macros adds a new menu to Excel's toolbar. Click on the QI Macros menu then the DOE, Gage RR, FMEA sub-menu and then Control Plan.
   
2. The template will open with a tab for each of the three options shown above.
3. Input production control plan, and other high level information in the top sections of the template.
4. For all the steps in the manufacturing process that are relevant to the control of the product quality, identify:
• Processing equipment as precisely as possible (e.g., machine, device, jig, machine make, machine model number, asset #, etc.)
• Characteristic reference number, starting with 1. If process flow diagrams or FMEA’s are available, cross reference number in this column
• Special Product Characteristics
• Process Characteristics that have a cause and effect relationship with the Product Characteristic
• Specifications/tolerances
• Measurement system: gages, fixtures, tools, and/or test equipment required to measure the part or process
• Sample size and frequency
• Control method: statistical process control, inspection, sampling
• Reaction plan to avoid producing nonconforming product
  

For more detailed instructions, see the Advanced Product Quality Planning and Control Plan manual published by the AIAG.

Control Plan - How to Video

Why Choose QI Macros Over Other SPC Software?