a. Using factors from above table, determine upper and lower control limits for mean and range charts. (Round your intermediate calculations and final answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) UCL LCL Mean Chart Range Chart b. Decide if the process is in control. O The process is in control. O The process is not in control.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
Problem 10-4 (Static)
Software upgrade times (in minutes) are being evaluated. Samples of five observations each have been taken, and the results are as
listed.
1
79.2
78.8
80.0
78.4
81.0
Number of
Observations
in Subgroup,
n
2
4
5
6
7
8
9
Click here for the Excel Data File
Factors for three-sigma control limits for and Rcharts
10
11
13
12
13
14
SAMPLE
2
4
3
80.5 79.6 78.9
78.7
81.0 80.4 79.7
79.6 79.4
80.4
79.4
80.1
80.6
15
16
17
18
19
20
80.3
80.8
Factor for
I Chart,
A2
1.88
1.02
0.73
0.58
0.48
0.42
5
6
80.5
79.7
79.6
80.6
80.4 80.5
80.8 80.0
78.8
81.1
0.37
0.34
0.31
0.29
0.27
0.25
0.24
0.22
0.21
0.20
0.19
0.19
0.18
FACTORS FOR R CHARTS
Lower
Upper
Control
Limit,
D3
Control
Linit,
D4
3.27
2.57
2.28
2.11
2.00
1.92
1.86
1.82
1.78
1.74
1.72
1.69
1.67
1.65
1.64
1.62
1.61
1.60
1.59
0
8
0
0
0
0.08
0.14
0.18
0.22
0.26
0.28
0.31
0.33
0.35
0.36
0.38
0.39
0.40
0.41
Transcribed Image Text:Problem 10-4 (Static) Software upgrade times (in minutes) are being evaluated. Samples of five observations each have been taken, and the results are as listed. 1 79.2 78.8 80.0 78.4 81.0 Number of Observations in Subgroup, n 2 4 5 6 7 8 9 Click here for the Excel Data File Factors for three-sigma control limits for and Rcharts 10 11 13 12 13 14 SAMPLE 2 4 3 80.5 79.6 78.9 78.7 81.0 80.4 79.7 79.6 79.4 80.4 79.4 80.1 80.6 15 16 17 18 19 20 80.3 80.8 Factor for I Chart, A2 1.88 1.02 0.73 0.58 0.48 0.42 5 6 80.5 79.7 79.6 80.6 80.4 80.5 80.8 80.0 78.8 81.1 0.37 0.34 0.31 0.29 0.27 0.25 0.24 0.22 0.21 0.20 0.19 0.19 0.18 FACTORS FOR R CHARTS Lower Upper Control Limit, D3 Control Linit, D4 3.27 2.57 2.28 2.11 2.00 1.92 1.86 1.82 1.78 1.74 1.72 1.69 1.67 1.65 1.64 1.62 1.61 1.60 1.59 0 8 0 0 0 0.08 0.14 0.18 0.22 0.26 0.28 0.31 0.33 0.35 0.36 0.38 0.39 0.40 0.41
a. Using factors from above table, determine upper and lower control limits for mean and range charts. (Round your intermediate
calculations and final answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.)
UCL
LCL
Mean Chart
Range Chart
b. Decide if the process is in control.
O The process is in control.
O The process is not in control.
Transcribed Image Text:a. Using factors from above table, determine upper and lower control limits for mean and range charts. (Round your intermediate calculations and final answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) UCL LCL Mean Chart Range Chart b. Decide if the process is in control. O The process is in control. O The process is not in control.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.