The Control Plan document defines 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 benefiting from the Six Sigma project.
This tool can be added to your active workbook by clicking on Project and then selecting Control Plan.
Inputs
Click on Analysis Setup to open the menu options for this tool.
Setup
A sample screenshot of the setup menu is shown below.
1
Analysis Type:
Specify the tool format for this analysis. This selection is not enabled since there is only one format available.
2
Num Tasks:
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.
3
View Example:
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.
4
Help Button: Click on this button to open the help file for this topic.
5
Cancel Button: Click on this button to cancel all changes to the settings and exit this dialog box.
6
Create Design:
If this is your first time using this template, click this button to format the worksheet template. You can also update the worksheet format any time, but remember that you may lose any data entered on this worksheet.
Once you are happy with the worksheet template layout, you must enter any required data on the worksheet. When the data entered into the worksheet is complete, you can click on Analysis Setup and then Compute Outputs to generate analysis results.
7
Analyze Design:
Click on this button to save all changes and compute the outputs for this analysis. Review the results of your analysis and make changes to your inputs if required to update analysis results.
Checklist
You will see the following dialog box if you click the Checklist button.
The checklist contains a few pointers on things you must 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.
Worksheet
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 gauge 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 the LSL.
Action items to bring the process back in control if 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.
Verify
If you click the Verify button, the software will perform some checks on the data you entered. A sample screenshot of the dialog box is shown in the figure below.
The software checks 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, they are shown as green-colored checkmarks. If the verification checks fail, they are shown as a red-colored cross. The verification checks are shown in the orange exclamation mark if the verification checks result in a warning. Finally, any checks required to be performed by the user are shown as blue info icons.
1
Item:
The left-hand side shows the major tabs and the items checked within each section
2
Status:
The right-hand side shows the status of the checks.
3
Overall Status:
The overall status of all the checks for the given analysis is shown here. The overall status check shows a green thumps-up sign if everything is okay and a red thumps-down sign if any checks have not passed. Note that you cannot proceed with generating analysis results for some analyses if the overall status is not okay.
Outputs
Click on Compute Outputs to update the computation results. A sample screenshot of the worksheet is shown below.
The following message is displayed upon successful completion of this analysis:
This analysis does not produce specific outputs. Manually check it to see any gaps or problems with the control plan.
Notes
Here are a few pointers regarding this analysis:
You can modify this tool as it does not involve any calculations.
Examples
The following examples are in the Examples folder.
Develop a Control Plan for the process that involves monitoring the training effectiveness (Control Plan 1.xlsx)