The Control Plan document is used to define what actions the process owner has to take to keep the process in control. It highlights the key variables that need to be tracked and controlled so that the organization continues to receive benefits from the Six Sigma project.
This tool can be added to your active workbook by clicking on Project and then selecting Control Plan.
Click on Analysis Setup to open the menu options for this tool.
A sample screenshot of the setup menu is shown below.
Specify the tool format for this analysis. This selection is not enabled since there is only one format available.
Specify the number of key process steps for which you would like to define the control plan. This information is used to reformat your worksheet and create a table for data entry. Note that any data below this table will be cleared.
Click on this button to open the example file. You can view the example to get an idea of how to fill out this tool or you can use the example as a starting point and modify it to meet your project needs.
Help Button: Click on this button to open the help file for this topic.
Cancel Button: Click on this button to cancel all changes to the settings and exit this dialog box.
OK Button: Click on this button to save all changes and compute the outputs for this analysis.
On the worksheet, enter the details such as:
What variable to measure - typically your primary and secondary metrics, your control factors etc.
How to measure the variable - specify the instrument or Gage used to measure the variable.
When to measure it- specify the frequency such as daily, 1st part, weekly, every shift etc.
How many data points to measure- specify the amount of data to be collected such as 100% data, 10% random sample etc.
The specification limit to determine if the measure is acceptable or not. This could include the USL and/or the LSL.
Action items to bring the process back in control in case the measures are not okay. You could refer to other document numbers here that describe the process used to bring the process back to control.
If you click on the Checklist button, you will see the following dialog box.
The checklist contains a few pointers on things you need to pay particular attention to while performing this analysis. The checklist has been derived from experience working on past projects. Not all the checklist items need to apply to you. However, you should carefully review the checklist and apply any recommendations that make sense for your project. Make sure to read each checklist item and mark it as completed after you have read and taken actions as appropriate for your project.
If you click on the Verify button, the software will perform some checks on the data you have entered. A sample screenshot of the dialog box is shown in the figure below.
The objective of this analysis as well as any checks that are performed is listed in this dialog box. For example, the software may check if you have correctly specified the input options and entered the required data on the worksheet. The results of the analysis checks are listed on the right. If the checks are passed, then they are shown as a green-colored checkmark. If the verification checks fail, then they are shown as a red-colored cross. If the verification checks result in a warning, they are shown in the orange color exclamation mark and finally, any checks that are required to be performed by the user are shown as blue info icons.
Click on Compute Outputs to update the computation results. A sample screenshot of the worksheet is shown below.
There are no specific outputs from this analysis. Manually check it to see if there are any gaps or problems with the control plan.
Here are a few pointers regarding this analysis:
You can modify this tool as it does not involve any calculations.
Following examples can be found in the Examples folder.
Develop a Control Plan for the process that involves monitoring the training effectiveness (Control Plan 1.xlsm)