Individual Case Study (Due Week 7)

This case study looks at the behavior of a circuit board process through the use of control charts. At least two control charts will need to be constructed, and from them, you will be asked to provide an assessment of what you see. A template to facilitate the construction of the control charts has been provided in Files: GSCM326_Case_Study_Template.xlsx. You are not required to use this template; however, it will greatly facilitate the solution.

Problem Statement

Fujiyama Electronics Inc. has had difficulties with circuit boards purchased from an outside supplier. Unacceptable variability occurs between two drilled holes that are supposed to be 5 cm apart on the circuit boards. Thirty samples of four boards each were taken from shipments from the supplier. The data obtained can be found on a worksheet in Files: Fujiyama_Electronics_Sample_Data.xlsx.

A tutorial is available to help complete the Week 7 Team Case Study assignment, titled WK7_Case_Study_Tutorial.

Guidelines

The student will submit the completed case study in a Word document Due Week 7.

The students will complete and answer the following questions.

1. Calculate X-bar-bar, R-bar, and associated control limits using the data in the table above.
2. Create x and R (average and range) control charts from the data in the table above.
3. Discuss notable out-of-control conditions displayed in the completed x and R (average and range) control charts. Only consider points outside the control limits. Do not consider runs, set of points within certain zones, and so forth.
4. If the conditions you note could be defined as assignable conditions, and they are removed from the process, then what will happen to the X-bar and R control chart?
5. Remove the data related to the out-of-control points you observed from the original data, and recalculate new X-bar-bar, R-bar, and associated control limits.
6. Create new X-bar and R (average and range) control charts from your updated data.
7. Discuss how the two sets of control charts are different. What has changed?

2 Fujiyama Electronics Sample Data Observations 4 Sample 4.94 4.92 4.65 5.77 6.25 5.27 Ovan 4.26 5.54 5.26 4.88 5.41 5.38 4.68 4.54 5.58 5.18 4.26 5.78 4.76 5.66 6.02 5.08 4.56 4.17 5.22 5.47 5.71 5.24 4.29 5.421 4.79 4.441 4.91 4.65 4.71 4.87' 5.41 4.73) 5.48 5.05 4.781 5.59 4.72 4.42 4.79 5.14 4.92 5.79 4.3 4.92 4.8 5.68 5.74 4.75 4.65 5.27 5.43 5.21 4.81 4.79 4.96 4.47 5.18 6.35 3.69 6.29 6.43 5.03 6.32 6.04 5.08 5.95 4.66 6.09 5.47 4.97 5.25 5.89 4.46 5.91 6.07 5.11 4.347 5.02 5.57 4.27 5.51 5.91 4.86 5.74 4.81 6.04 5.03 4.41 5.3 4.75 5.78 5.071 4.95 Selden 5.11; Sheet2 Sheet3 TER or choose Paste A B C D E F G H JK N O P Q 1 X-Bar and R-Chart 2 This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter the data ONLY in yellow-shaded 3 Enter the number of samples in cell E6 and the sample size in cell E7. Then enter your data in the grid below. Click on sheet tabs for a display of the control charts. Specification limits may be entered in cells N7 and N8 for process capability COWN 6 Number of samples (