DescriptionName & Class Time___________________________________________________
Date___________
Mgt. 385: Participation Exercise – 7 Points
Chapter 3: Statistical Process Control
Submission Requirements:
1. Compute UCL, LCL, and CL for the R-chart first. Then, answer Question 1 below.
2. Then, compute UCL, LCL, and CL for the X-bar chart. Answer remaining questions below.
3. Bring your completed Excel file to class and submit this hard copy at the beginning of
class.
******************************************************************************
1. Based on the R-chart alone, what is your conclusion about the process – is the process in
control? Why or why not?
2.
Based on the x-bar and R-charts together, what is your conclusion about the process – is
the process in control? Why or why not?
3.
Why should x-bar and R charts be interpreted together?
Name & Class Time___________________________________________________
4.
Date___________
Answer any one:
If the process is in control, what type of variation is present in the process? If not, what
type of variation is present in the process?
In control Process: _______________________________
Out of Control Process: ___________________________
5.
What could have caused the process to go out of control?
6.
If out of control, what should the company do?
Using SPC, assess if there is assignable variation in a meat locker’s temperature controls. Seven samples
were collected over a period of 30 days (see data below).
Submission Requirements: 1. Compute UCL, LCL, and CL for the R-chart first. Answer Question 1 in the h
2. Next, compute UCL, LCL, and CL for the X-bar chart. Answer remaining questions in the homework (ha
3. Create an R-chart chart & X-bar chart.
4. Bring this completed Excel file to class and submit the hard copy of your answers at the beginning of cl
Sample
Item 1
Sample 1
46.3
Sample 2
41.2
Sample 3
40.1
Sample 4
42.3
Sample 5
35.2
Sample 6
40.6
Sample 7
33.2
Sample 8
41.8
Sample 9
42.4
Sample 10 44.7
Sample 11 42.6
Sample 12 40.5
Sample 13 45.3
Sample 14 36.4
Sample 15 40.5
Sample 16 42.0
Sample 17 37.6
Sample 18 41.0
Sample 19 40.9
Sample 20 37.6
Sample 21 41.8
Sample 22 42.4
Sample 23 39.0
Sample 24 35.2
Sample 25 33.8
Sample 26 40.0
Sample 27 39.8
Sample 28 45.3
Sample 29 42.0
Sample 30 41.0
Item 2
48.1
40.5
41.3
44.1
38.1
41.7
38.6
40.0
41.6
36.5
43.5
40.4
42.0
37.5
34.3
45.0
40.6
34.3
42.3
39.2
39.8
41.6
40.6
39.0
38.6
43.5
37.0
41.0
34.3
34.3
Item 3
42.5
37.8
34.5
39.5
40.5
38.6
41.5
41.6
40.8
37.3
35.4
39.1
43.1
36.2
36.2
47.0
40.3
39.1
37.6
39.3
41.6
40.8
40.3
40.5
41.5
35.4
42.1
43.1
36.2
39.1
Table for Control Chart Factors
Item 4
43.1
36.5
33.2
37.7
39.1
43.5
40.7
40.7
40.9
35.3
36.1
37.2
44.7
38.9
35.1
43.0
39.7
45.2
35.4
41.2
40.7
43.0
39.7
39.1
40.7
36.1
34.8
38.0
36.0
45.2
Item 5
37.5
36.8
39.4
41.2
43.5
41.5
42.8
39.0
38.6
37.4
34.8
34.8
41.8
42.4
36.0
42.6
40.5
45.3
36.4
41.0
39.0
39.0
41.0
43.5
42.8
34.8
32.7
41.8
36.0
45.3
Item 6
40.4
42.0
37.5
34.3
38.2
40.6
37.0
39.0
42.0
45.7
44.1
38.0
39.0
37.6
34.6
44.0
42.0
40.0
39.8
40.0
39.0
42.0
42.0
42.0
37.0
42.0
33.9
39.0
34.6
40.0
Item 7
39.6
42.3
36.7
38.6
42.3
44.6
43.1
39.3
42.3
41.1
38.2
41.6
39.5
40.1
36.8
38.7
41.2
43.7
34.8
37.6
39.3
42.3
41.2
42.3
43.1
38.2
42.0
39.5
36.8
43.7
Sample
size, n
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Mean Upper Lower
Factor, Range, Range,
A2
D4
D3
1.88
3.268
0
1.023
2.574
0
0.729
2.282
0
0.577
2.115
0
0.483
2.004
0
0.419
1.924
0.076
0.373
1.864
0.136
0.337
1.816
0.184
0.308
1.777
0.223
0.285
1.744
0.256
0.266
1.716
0.284
0.249
1.692
0.308
0.235
1.671
0.329
0.223
1.652
0.348
0.212
1.636
0.364
0.203
1.621
0.379
0.194
1.608
0.392
0.187
1.596
0.404
0.18
1.586
0.414
0.173
1.575
0.425
0.167
1.566
0.434
0.162
1.557
0.443
0.157
1.548
0.452
0.153
1.541
0.459
Homework
ure controls. Seven samples of the meat locker’s temperature (in degrees F)
t. Answer Question 1 in the homework (hardcopy).
estions in the homework (hardcopy).
nswers at the beginning of class.
Sample
Number
Defective
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
12
14
10
16
18
19
14
20
18
17
9
11
14
12
7
6
3
7
10
14
18
22
26
20
24
18
19
20
17
18
Purchase answer to see full
attachment
