CASE STUDY 1970

Fujiyama Electronics Case Study - Due Week 7
Objective | Project Deliverables | Grading Rubrics | Best Practices

Objective

This case study looks at the behavior of a circuit board process though the use of Control Charts. At least two Control Charts will need to be constructed, and from them you will asked to provide an assessment of you see. A template to facilitate the construction of the Control Charts has been provided.

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 ? apart on the circuit boards. 25 samples of 3 boards each were taken from shipments from the supplier as shown in the data from the worksheet. Data in the work sheet below can also be accessed here.

Fujiyama Electronics

Observations
Sample 1 2 3

1 414 388 402
2 408 382 406
3 396 402 392
4 390 398 362
5 398 442 436
6 400 400 414
7 444 390 410
8 360 372 362
9 376 398 382
10 342 400 402
11 400 402 384
12 408 414 388
13 382 430 400
14 402 409 400
15 399 424 413
16 460 375 445
17 404 420 437
18 375 380 410
19 391 392 414
20 394 399 380
21 396 416 400
22 370 411 403
23 481 450 451
24 398 398 415
25 428 406 390

Project Deliverables

The student will submit the completed case study in word document paper by the end of class week 7 to their Dropbox. The paper is worth 50 points.
The student will complete and/or 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-BarR (Average & Range) Control Charts from the data in table above.
3. Discuss notable out-of-control conditions displayed in the completed X-BarR (Average & Range) Control Charts. Only consider points outside the Control Limits. Do not consider runs, set of points within certain zones, etc.
4. If the conditions you note could be defined as assignable conditions and they are removed from the process, what will happen to the X-BarR Control Chart?
(a) Remove the data related to the out-of-control points you observed from the origainal data and recalculate a new X-Bar-Bar, R-Bar, and associated control limits.
(b) Create new X-BarR (Average & Range) Control Charts from your updated data.
5. Discuss how the two sets of Control Charts are different. What has changed?
The format of the case study should conform to the Publication Manual for the American Psychological Association (APA), 6th edition, for title page & text. Citations and references are not required. A basic APA tutorial can be found in Webliography and paper template can be found in Doc Sharing. The completed case study will be submitted to your Dropbox as a MS-Word document. All graphics and charts will be a part of the Word document and submitted as a file. Documents authored in other applications such as WordPerfect or MS-Works will not be accepted.

Grading Rubrics

First Control Chart (40 Percent) Points Possible Points Earned Comments
All calculations are correct. 5
X-Bar & R charts are presented and correct. 5
All conditions of importance discussed. 10
Total 20
Second Control Chart (40 Percent) Points Possible Points Earned Comments
All calculations are correct. 5
X-Bar & R charts are presented and correct. 5
Differences between the two sets of Control Charts are thoroughly discussed. 10
Total 20
Mechanics (20 Percent) Points Possible Points Earned Comments:
The paper, including the title page follow APA guidelines for format. (References and citations not required) 2
Sentences are complete, clear, and concise. 2
The paper is laid out with effective use of headings, font styles, and white space. 2
Rules of grammar, usage, and punctuation are followed. 2
Spelling is correct. 2
Total 10
Total (100 Percent) Points Possible Points Earned Comments:
50


Below is a excel template were i have graphed the problem
and example of a case.

X-bar and R-Chart
This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10.  Enter data ONLY in yellow-shaded cells.
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.

Number of samples (<= 50)                25
Sample size (2 - 10)                3

Grand Average       402.8266667     A2  D3  D4  d2
Average Range       30.88       1.023   0   2.574   1.693

DATA    1   2   3   4   5   6   7   8   9   10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  50
1   414 408 396 390 398 400 444 360 376 342 400 408 382 402 399 460 404 375 391 394 396 370 481 398 428
2   388 382 402 398 442 400 390 372 398 400 402 414 430 409 424 375 420 380 392 399 416 411 450 398 406
3   402 406 392 362 436 414 410 362 382 402 384 388 400 400 413 445 437 410 414 380 400 403 451 415 390
4
5
6
7
8
9
10
Average 401.3333333 398.6666667 396.6666667 383.3333333 425.3333333 404.6666667 414.6666667 364.6666667 385.3333333 381.3333333 395.3333333 403.3333333 404 403.6666667 412 426.6666667 420.3333333 388.3333333 399 391 404 394.6666667 460.6666667 403.6666667 408 #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A
LCLx-bar    371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267 371.2364267
Center  402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667 402.8266667
UCLx-bar    434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067 434.4169067

Range   26  26  10  36  44  14  54  12  22  60  18  26  48  9   25  85  33  35  23  19  20  41  31  17  38  #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A    #N/A
LCLrange    0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
Center  30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88   30.88
UCLrange    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512    79.48512























DO NOT MODIFY THIS TABLE
    Control Chart Factors
n   A2  D3  D4  d2  A3  B3  B4
2   1.88    0   3.267   1.128   2.659   0   3.267
3   1.023   0   2.574   1.693   1.954   0   2.568
4   0.729   0   2.282   2.059   1.628   0   2.266
5   0.577   0   2.114   2.326   1.427   0   2.089
6   0.483   0   2.004   2.534   1.287   0.03    1.97
7   0.419   0.076   1.924   2.704   1.182   0.118   1.882
8   0.373   0.136   1.864   2.847   1.099   0.185   1.815
9   0.337   0.184   1.816   2.97    1.032   0.239   1.761
10  0.308   0.223   1.777   3.078   0.975   0.284   1.716