Control Strategies - SPC for Excel (2024)

August 2004

In this issue:

  • Control Strategies
  • Control Strategy Example
  • Control Strategy Basics
  • Quick Links

The point you just plotted on your control chart is above the upper control limit. Your chart is telling you that there is a special cause present in your process. You are supposed to find out what caused this point to be above the upper control limit. Where do you start looking? There are thousands of things which could have caused this point to be above the upper control limit. A control strategy provides a method of helping you look for causes of out-of-control points. This e-zine introduces the concept of control strategies.

Control Strategies

Control Strategies - SPC for Excel (1)Control charts tell us two basic things: when to take action and when to leave our process alone. We should take action when our process shows signs of special causes of variation. When our control charts show us that there is an out-of-control situation, it is the responsibility of those people closest to the process to find the cause for the out-of-control situation and eliminate the cause from the process. This prevents the cause from occurring again. Sounds fairly easy, doesn’t it? However, bringing a process back into control is usually not that simple. For example, if you think about all the possible reasons why a process may go out of control, you will probably develop a fairly long list. Time constraints and costs probably wouldn’t allow you to look into all the possible causes. In most cases, you do know that some causes are more likely to occur than others. Control strategies help you look into the more likely causes.

Control strategies are specific action plans for bringing a process back into control. The strategies usually consist of five to ten steps that help you find reasons for special causes, and most importantly, help you do something about the causes.

Control Strategy Example

A non-manufacturing example of a control strategy is shown in the figure. This control strategy is for operating supplies variance. Operating supplies is often a category used in budgeting. Operating supplies variance is the difference between what was budgeted for operating supplies and what was actually spent.

The first column on the control strategy is a statement of the out-of-control situation. In this example, the out-of-control situation is that the operating supplies variance is below the lower control limit. Notice that the out-of-control situation only talks about the variance below the lower control limit (or seven points in a row below the average).

The control strategy for points above the upper control limits (or seven points in a row above the average) might be different. You might also have different control strategies depending on the type of chart (range or average) on which the out-of-control situation occurred.

The second column lists the five to ten most probable causes for the out-of-control situation described. The third column indicates what action needs to be taken to investigate each cause. The results or information from the action taken is recorded in the fourth column. The next column is for the initials or the name of the person who took action. The last column is the action taken to correct the problem.

Control Strategies - SPC for Excel (2)

Control Strategy Basics

Control strategies should be developed and used by the local work force. Those people closest to the process will know best what the most likely causes of an out-of-control situation are, and what to do about them. In addition, out-of-control situations should be addressed immediately. For this reason, the responsibility for using control strategies also lies with the local work force.

Control strategies should be updated regularly. If one of the causes on the control strategy has never surfaced as a reason for an out-of-control point, then that cause should be deleted from the strategy and replaced by another possible cause (and the action to be taken for pursuing the new cause).

There are various benefits to control strategies. Control strategies provide a method of systematically looking for special causes. This helps front-line personnel to do their jobs better. Also, control strategies help us increase the understanding of our processes. For example, if you use and update control strategies over time, you will establish a database that will evaluate the causes of out-of-control points long term. This increased knowledge about our processes will be useful for training new hires. They will have a standardized approach for controlling their processes instead of working by trial and error. Control strategies also provide a permanent record of what happened after each out-of-control situation.

Control strategies are specific plans for what to do when your process shows the presence of special causes. This plan describes the out-of-control situation, possible causes, how to check each cause and the result of your check. All control charts in use should have a control strategy. It is the responsibility of those people closest to the process to develop and use the control strategies.

Control Strategies - SPC for Excel (2024)

FAQs

How do you calculate SPC control limits? ›

The control limits for the X-bar chart are calculated by adding A2 * R-bar to X-double bar for the upper control limit (UCL) and subtracting A2 * R-bar from X-double bar for the lower control limit (LCL). A2 is a constant that depends on the subgroup size.

What is the 7 point rule in SPC? ›

Rule of seven is a rule of thumb or heuristic. On a control chart, when seven consecutive data points fall on the same side of the mean, either above or below, the process is said to be out of control and in need of adjustment. All the seven points may be within the control limits.

How many data points needed for control limits? ›

For a control chart you do need more data –a minimum of 15 data points, and preferably around 20. This is because the 'mean' in your control chart is more sensitive than the median in a run chart to point-to-point variation.

What is the SPC formula? ›

Process average, or x̄ Upper Specification Limit (USL) and Lower Specification Limit (LSL). The Process Standard Deviation (σₑₛₜ). This can be calculated directly from the individual data, or can be estimated by: σₑₛₜ = R̄/d₂

What is the rule 3 in SPC? ›

Rule 3: A trend of 6 or more points in one direction, up or down (two consecutive points of equal value count as one). This rule visualizes a consistent drift in a process. Of note, this rule has the least statistical validity but is useful in practice.

What is the rule 2 in SPC? ›

Rule 2: Two out of three consecutive points do not fall beyond 2σ on the same side of the centerline. Rule 3: Four out of five consecutive points do not fall beyond 1σ on the same side of the centerline. Rule 4: Nine or more consecutive points do not fall on the same side of the centerline.

What are the control limits on a SPC chart? ›

The control chart is a graph used to study how a process changes over time. Data are plotted in time order. A control chart always has a central line for the average, an upper line for the upper control limit, and a lower line for the lower control limit. These lines are determined from historical data.

Where can I find form control in Excel? ›

“Form Controls” is available in Excel under the “Developer” tab excel.

When not to use SPC charts? ›

Don't create an SPC chart with fewer than 12 data points (20 for an I chart) – use a run chart instead. Also consider the control limits temporary until you have more than 20 data points.

What are the 4 types of control charts? ›

Types of Control Charts (SPC).
  • X bar control chart. ...
  • Range “R” control chart. ...
  • Standard Deviation “S” control chart. ...
  • Attribute Control Charts: ...
  • “u” and “c” control charts. ...
  • “p” and “np” control charts. ...
  • Pre-control Charts.

What is the 3 control limit? ›

Three-sigma control limits are used to check data from a process and if it is within statistical control. This is done by checking if data points are within three standard deviations from the mean.

How do you calculate the control limit? ›

Multiply the standard deviation by the control limit L (dispersion of sigma lines from the control mean) and: Add this number to the mean to find the upper control limit UCL = x - (-L × σ) ; or. Subtract this number from the mean to obtain the lower control limit LCL = x - (L × σ) .

What is the basis for calculation of control limits? ›

Specified control limits are based off the mean and standard deviation stored in the database. Specified limits are fixed and do not change unless the limits are updated with a new effective date. Calculated control limits are "live" limits calculated from the mean and standard deviation of the chart's data selection.

What are control limits in statistical quality control? ›

Control limits are the horizontal lines above and below the center line that are used to judge whether a process is out of control. The upper and lower control limits are based on the random variation in the process.

What are the two ways in which control limits can be calculated? ›

You can compute the limits in the following ways:
  • as a specified multiple (k) of the standard errors of Xi and Ri above and below the central line. ...
  • as probability limits defined in terms of α, a specified probability that Xi or Ri exceeds the limits.
Nov 30, 2022

Top Articles
Latest Posts
Article information

Author: Trent Wehner

Last Updated:

Views: 6003

Rating: 4.6 / 5 (56 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Trent Wehner

Birthday: 1993-03-14

Address: 872 Kevin Squares, New Codyville, AK 01785-0416

Phone: +18698800304764

Job: Senior Farming Developer

Hobby: Paintball, Calligraphy, Hunting, Flying disc, Lapidary, Rafting, Inline skating

Introduction: My name is Trent Wehner, I am a talented, brainy, zealous, light, funny, gleaming, attractive person who loves writing and wants to share my knowledge and understanding with you.