project

The basic information for you to complete the project is contained in the Course Project 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 population. This is due to the fact that you make widgets similar in tolerance, but maybe not as tight as those in the contract. You can assume that 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 machinery can make these close tolerance widgets. 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 manufacturing process. To calculate UCL and LCL on a population, you simply add and subtract the mean of each subgroup to 3*population std dev. To get the 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.

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.

Submit ONLY the completed spreadsheet via the Project dropbox.