Jan 2005 Brain Teaser - Case Study

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

If you are looking for manufacturing case studies, a great resource is Dr. Sophronia Ward's Brain Teaser column in Quality Magazine. You can view back issues on the Quality Magazine website or you can purchase a compilation of articles in her new book Quality Brain Teasers for $19.95.

This issue of the QI Macros ezine shows you how to solve the Jan 2005 Brain Teaser using the QI Macros for Excel. To read the complete case study, go to "Where Rubber Meets the Road"

Background

A rubber company needs to know if its product is meeting customer specifications of 12 +/-3 and if its process is stable.

You can download the data from: http://www.qimacros.com/free-excel-tips/rubberdata.xls.

To determine if the data meets specifications, use a histogram. To run a histogram using the QI Macros:

Select the data. Note: Just select the data points and not the batch numbers. Since the batch numbers are formatted as numbers, the macro will treat them as part of your data if selected.

Click on the QI Macros pull down menu and then select Histogram. The histogram macro will prompt you for the spec limits. In this case the upper spec limit is 15 (12 + 3) and the lower spec limit is 9 (12-3).

Here is the histogram for the rubber flash values. Do the flash values meet specifications?

The answer is "yes" since all of the points on the histogram fall between the spec limits.

In the case study, the production department wants spec limits of 12 +/-1(13 and 11). Rerun the histogram with these limits. Do the flash values still meet specifications?

The answer is "no". A large number of the flash values fall out side of the spec limits. Also, note that the new spec limits reduce the Cp and Cpk values.

The next question is, "Is the process predictable?" Use a control chart to determine the stability and predictability of a process.

Using the SPC Quick reference card, choose the kind of chart. In this case use the XmR chart because this is variable data, single sample.

Here is the X and R chart for the rubber flash values. Is the process stable and predictable?

The answer is "no." The QI Macros turn all unstable points or trends red. The Xchart contains two sets of unstable trends and indicates that the process is not predictable.

View further information and the answers to this case study in the Quality Magazine Feb 2005 Brain Teaser column.

The QI Macros for Excel includes 19 Excel macros and over 90+ Excel Templates. Many Excel templates can be purchased separately or as part of the QI Macros for Excel SPC Software.

If you love the QI Macros...
Please ask a handful of friends to download the trial version. Here's what to say:
Need easy to learn, easy to use software for Lean Six Sigma and SPC that works right in Microsoft Excel? Test drive the QI Macros!
Find out more at www.qimacros.com/excel-spc-software.html.
Get a 30-day trial at www.qimacros.com/free-spc-software.html.

Going to a meeting of quality professionals?
We can send you as many QI Macros 30-day trial CDs as you need. Just send an email with the address and quantities needed to orders@qimacros.com.

Try QI Macros
FREE
For 30-Days

Or Buy It Now!