29. The following are processing times for an assembly operation. Requirements are 8 and 22. Annual volume is 40,000. Use the table below to comment on the process. If the process is in control the sigma level is closest to Sample Date 11 72 12.00 1 2 3 4 5 6 Sum Average Range 12-Sep 10 14 13 11 13 13-Sep 17 12 16 14 11 16| 14-Sep 16 14 12 11 10 15 78 15-Sep 13 13 10 12 16 86 14.33 13.00 12 76 80 73 87 80 16-Sep 15 13 13 14 13 12 17-Sep 15 14 10 10 12 12 18-Sep 11 12 12 17 15 16 83 19-Sep 14 11 17 11 17 17 20-Sep 15 12 10 14 15 14 21-Sep 16 14 14 16 13 15 88 22-Sep 14 10 16 11 10 17 78 23-Sep 13 16 10 12 12 15 78 24-Sep 14 13 13 12 15 15 82 25-Sep 17 13 11 10 17 17 85 26-Sep 17 16 14 12 13 15 87 27-Sep 16 10 12 12 13 10 73 28-Sep 12 11 16 11 14 13 77 29-Sep 12 10 17 13 15 10 77 30-Sep 10 14 16 17 10 13 1-Oct 12 16 17 15 10 13 83 Avg The process is not in control 12.67 13.33 12.17 13.83 CO 00 14.50 13.33 14.67 13.00 13.00 13.67 14.17 14.50 12.17 12.83 12.83 80 13.33 13.83 13.36 6 6 6 3 5 6 6 5 3 7 6 3 7 5 6 5 7 7 7 5.50

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

Please do not give solution in image format thanku 

29. The following are processing times for an assembly operation. Requirements are 8 and 22. Annual
volume is 40,000. Use the table below to comment on the process. If the process is in control the sigma
level is closest to
Sample
Date
1 2 3 4
12-Sep 10 14 13 11 13 11 72 12.00
13-Sep 17 12 16 14 11 16 86 14.33
14-Sep 16 14 12 11 10 15
15-Sep 13 13 10 12 16 12 76
13.00
12.67
16-Sep 15 13 13 14 13 12
13.33
73 12.17
17-Sep 15 14 10 10 12 12
18-Sep 11 12 12 17 15 16
19-Sep 14 11
83
13.83
14.50
13.33
14.67
13.00
13.00
13.67
14.17
14.50
12.17
12.83
12.83
13.33
SHEE
3
2
The process is not in control
1
5
6 Sum Average Range
HE
105
BON CO
ca va
78
87
17 11 17 17
20-Sep 15 12 10 14 15 14 80
21-Sep 16 14 14 16 13 15
22-Sep 14 10 16 11 10 17
23-Sep 13 16 10 12 12 15
24-Sep 14 13
13 12 15 15
25-Sep 17 13 11 10 17 17
26-Sep 17 16 14 12 13 15
27-Sep 16 10 12 12 13
28-Sep 12 11 16 11
10
14 13
77
29-Sep 12 10 17 13 15 10 77
30-Sep 10 14 16 17 10 13
1-Oct 12 16 17 15 10 13
80
887
88
78
78
82
00 00 00
85
87
73
80
00 00
83 13.83
Avg 13.36
4
6
6
6
55
3
6
99
6
5
3
7
6
3
75
6
5
7
7
7
5.50
Transcribed Image Text:29. The following are processing times for an assembly operation. Requirements are 8 and 22. Annual volume is 40,000. Use the table below to comment on the process. If the process is in control the sigma level is closest to Sample Date 1 2 3 4 12-Sep 10 14 13 11 13 11 72 12.00 13-Sep 17 12 16 14 11 16 86 14.33 14-Sep 16 14 12 11 10 15 15-Sep 13 13 10 12 16 12 76 13.00 12.67 16-Sep 15 13 13 14 13 12 13.33 73 12.17 17-Sep 15 14 10 10 12 12 18-Sep 11 12 12 17 15 16 19-Sep 14 11 83 13.83 14.50 13.33 14.67 13.00 13.00 13.67 14.17 14.50 12.17 12.83 12.83 13.33 SHEE 3 2 The process is not in control 1 5 6 Sum Average Range HE 105 BON CO ca va 78 87 17 11 17 17 20-Sep 15 12 10 14 15 14 80 21-Sep 16 14 14 16 13 15 22-Sep 14 10 16 11 10 17 23-Sep 13 16 10 12 12 15 24-Sep 14 13 13 12 15 15 25-Sep 17 13 11 10 17 17 26-Sep 17 16 14 12 13 15 27-Sep 16 10 12 12 13 28-Sep 12 11 16 11 10 14 13 77 29-Sep 12 10 17 13 15 10 77 30-Sep 10 14 16 17 10 13 1-Oct 12 16 17 15 10 13 80 887 88 78 78 82 00 00 00 85 87 73 80 00 00 83 13.83 Avg 13.36 4 6 6 6 55 3 6 99 6 5 3 7 6 3 75 6 5 7 7 7 5.50
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
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.