course project Quality control

Additional Project Information

The basic information for you to complete the project is contained in the Course Project Scenario document. This is additional information that you will need to know in order to create the charts and perform the analyses correctly.

1. You are a widget manufacturer. This is for a special production of widgets with extremely tight tolerances. Since you specialize in widget design and production, you can assume that the processes that are similar in nature with regard to the specification limits are valid to base a process capability.

2. The initial run of the widgets should be considered a trail run. This is due to the fact that you make widgets similar in tolerance, but maybe not as tight as those required by this customer. You can assume that based in your experience in widget manufacture, the first 4 runs of the prototype widget will meet specification.

However, you’re more concerned with the tolerances of the machines. The question is whether the current process and machinery is capable of making the widgets to the close tolerances required by the customer. This is why you selected a sample of the population runs (each run * 20 samples)

3. The UCL and LCL are calculated using data set 1 as a population. They will provide a more reliable assessment on the current manufacturing process. To calculate UCL and LCL, you simply add and subtract the mean of each subgroup to 3*std dev. To get these values, copy the following formulas into the appropriate cells:

Column F – Avg: Cell F2 =AVERAGE(B2:E2) Copy this formula to the end of the table

Grand Mean: Cell F22 =AVERAGE(F2:F21)

Std Dev: Cell F23 =STDEV.S(F2:F21)

These formulas will also be used in Data Set 2.

The Project Video will demonstrate how to perform these functions/formulas. You should watch the video at least twice before attempting to do anything with the project data. This will help you better understand what to do, and to do it correctly.

4. Create a line chart using the subgroups averages, mean, UCL and LCL (columns F-I). This will be the X-bar chart for the subgroup data. Follow the format instructions on Data Set 1 tab.

5. The IM charts are columns K-R. You MUST stack the data as instructed on the project document. You must then do descriptive stats on the stacked column and place the results in the area shown. Make sure you follow the placement help for the mean and stddev!!

6. The first IM chart is plotted against the process mean and will use the desc stats for the calculations. Create a line chart using the stacked data, process mean, UCL and LCL just like the x-bar and follow the formatting directions.

7. Copy the stacked data into column “O” and enter the SPECIFICATION limits into the appropriate cells. Make sure you copy these data for the entire stacked column length!!! Create another IM chart based on these data.

8. For all charts you must provide a detailed analysis. Be detailed and thorough, but not lengthy.

9. Answer the Questions for data set 1.

10. After the analysis of data set 1, you have determined that process improvements must be made. You have done this and have collected another set of data to see if you are now within the customer specification limits. These data are found in data set 2.

11. Repeat steps 3-9 for data set 2.

IMPORTANT:

The Project comes with text boxes for you to type in your analysis. There is NO REQUIREMENT to use the Report Template for the Project.

The Project spreadsheet file is a self-contained examination. ONLY the Project spreadsheet will be used to document your charts and analyses of each chart.

The Project video demonstrates how to modify the text boxes to allow for your analysis of the data.

Analysis MUST be concise, but detailed. Instructions on how to scope your analysis is also part of the Project video.

The Project video IS NOT a representation of the actual data you will be using. It is solely for instructional purposes only.