AutoSave OFF り × Assignment 4 Tell me Home Insert Draw Page Layout Formulas Data Review View Automate Share Comments Calibri (Body) ✓ 11 ✓ Aˆ A Wrap Text General Insert ✓ Σ ✓ ✓ ✓ Delete ▼ Paste B I U ✓ ✓ Merge & Center $ ✓ %9 .00 →0 Conditional Format Formatting as Table Cell Styles Format ✓ ✓ Sort & Filter Find & Select Analyze Data Sensitivity A1 fx A B C D E F G H J K L M N ○ P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH ΑΙ AJ AK AL AM AN AO AP AQ AR 1 3 2 This problem has two questions: Q1 & Q2. The BrightSpark Electronics plant monitors the temperature of a critical process to ensure product quality. The plant manager has randomly selected 16 temperature readings each day during the production hours and recorded them for quality control purposes. The following table shows the sample data collected during 4 weeks of observation (i.e., 20 production days). Q1: The manager wants to investigate whether the critical process is in statistical control, using the average of temperature readings from the sample. Prepare the control chart (with 99.73% control limits) for the manager. You must show your calculations for making the charts. Your chart should be made by linking to the data on the worksheet, not a picture copied from another source. 4 56 7 8 9 10 11 12 Day 13 1 14 2 15 3 16 4 17 5 18 6 19 7 20 8 21 9 22 10 23 11 24 12 25 13 26 14 27 15 28 16 29 17 30 18 31 19 32 20 1 2 3 4 5 6 16 105.5 104.3 107.9 106.6 104.4 105.2 104.0 103.0 105.7 106.0 107.2 105.6 102.8 103.4 104.6 105.6 106.6 104.1 102.0 104.0 106.5 105.3 104.4 105.5 105.6 102.8 106.4 101.9 103.2 103.7 106.1 108.8 104.2 103.4 106.3 104.0 103.1 105.5 104.3 108.5 104.1 104.6 104.5 105.1 103.3 105.9 107.8 105.0 106.3 103.1 104.9 105.5 106.4 103.8 104.2 103.2 104.8 103.9 105.5 107.1 104.5 104.8 105.8 103.8 104.9 105.2 107.1 106.9 103.9 105.3 103.8 102.6 104.7 104.2 103.7 105.7 104.1 104.5 104.4 106.7 106.5 106.4 105.4 106.4 102.7 106.3 104.8 106.8 104.8 105.8 104.3 104.4 103.5 104.8 104.4 104.8 105.9 108.2 104.6 106.7 104.2 103.2 104.1 104.3 107.3 103.2 104.2 104.1 103.9 102.3 106.2 104.0 103.3 103.3 103.5 103.8 102.4 104.4 102.1 104.9 105.5 103.9 103.0 106.4 103.9 102.1 102.9 104.2 104.8 103.5 104.1 103.7 104.0 107.0 104.9 106.4 102.5 107.6 103.9 103.9 103.4 104.8 105.9 105.2 104.9 106.2 104.6 106.2 104.2 105.6 104.2 105.7 105.3 105.2 107.2 105.8 102.2 103.4 105.6 103.5 106.3 105.6 103.4 104.0 103.7 106.6 106.0 106.5 103.9 105.6 105.5 105.2 104.3 102.8 105.4 104.7 106.8 106.4 105.9 103.4 106.9 104.2 106.9 107.5 103.2 104.6 105.3 102.8 106.2 105.3 106.0 109.0 107.6 107.3 108.8 108.1 106.4 105.9 106.0 102.3 105.9 105.8 106.6 106.1 109.0 104.5 105.2 103.6 103.9 104.9 104.5 105.6 106.7 105.3 106.2 104.0 105.8 104.2 106.5 106.7 104.8 104.0 107.6 106.1 106.7 105.7 105.7 103.8 105.8 103.3 104.2 106.9 106.9 104.2 105.2 102.6 107.5 105.1 106.1 103.5 106.6 104.9 107.2 103.8 103.5 102.9 106.2 104.2 104.7 102.4 106.1 106.3 106.8 103.4 107.2 106.5 105.1 103.5 105.1 102.2 102.8 104.5 106.7 106.1 106.2 105.2 105.7 106.8 104.7 102.2 105.7 106.8 107.0 103.2 104.6 102.5 108.2 104.2 105.4 107.5 105.1 104.7 107.3 106.0 102.8 104.9 105.3 105.2 102.3 103.5 101.8 104.3 103.0 104.6 103.1 103.8 103.1 102.2 104.2 105.4 107.4 104.3 104.4 102.5 107.6 105.3 103.5 103.3 105.9 104.7 105.7 103.9 104.3 105.2 107.1 104.8 104.3 106.8 106.0 105.3 7 Temperature readings (F) 8 9 10 11 12 13 14 15 33 34 35 36 37 38 Q2: The engineers have worked to incorporate newer technology into the above process so the temperature between 102 F and 107 F is expected to be maintained during the process. A new sample of 200 temperature readings were taken at different times/days (see the table below). After the incorporation of new technology, does the process (not the sample) meet the 6-sigma standard for temperature control? Explain your answer. 39 40 41 Temperature Met 6-sigma standard, Yes or No? Explain the reasoning behind your answer 42 (F) 43 104.5 44 104.1 45 104.3 46 104.2 47 103.9 48 103.7 49 104.2 50 104.6 51 105.1 52 104.8 53 102.9 54 55 103.8 103.8 56 103.0 57 103.1 58 103.9 59 104.5 60 105.7 1025 Problem 1 Problem 2 Problem 3 + Ready Accessibility: Investigate A + 70%
AutoSave OFF り × Assignment 4 Tell me Home Insert Draw Page Layout Formulas Data Review View Automate Share Comments Calibri (Body) ✓ 11 ✓ Aˆ A Wrap Text General Insert ✓ Σ ✓ ✓ ✓ Delete ▼ Paste B I U ✓ ✓ Merge & Center $ ✓ %9 .00 →0 Conditional Format Formatting as Table Cell Styles Format ✓ ✓ Sort & Filter Find & Select Analyze Data Sensitivity A1 fx A B C D E F G H J K L M N ○ P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH ΑΙ AJ AK AL AM AN AO AP AQ AR 1 3 2 This problem has two questions: Q1 & Q2. The BrightSpark Electronics plant monitors the temperature of a critical process to ensure product quality. The plant manager has randomly selected 16 temperature readings each day during the production hours and recorded them for quality control purposes. The following table shows the sample data collected during 4 weeks of observation (i.e., 20 production days). Q1: The manager wants to investigate whether the critical process is in statistical control, using the average of temperature readings from the sample. Prepare the control chart (with 99.73% control limits) for the manager. You must show your calculations for making the charts. Your chart should be made by linking to the data on the worksheet, not a picture copied from another source. 4 56 7 8 9 10 11 12 Day 13 1 14 2 15 3 16 4 17 5 18 6 19 7 20 8 21 9 22 10 23 11 24 12 25 13 26 14 27 15 28 16 29 17 30 18 31 19 32 20 1 2 3 4 5 6 16 105.5 104.3 107.9 106.6 104.4 105.2 104.0 103.0 105.7 106.0 107.2 105.6 102.8 103.4 104.6 105.6 106.6 104.1 102.0 104.0 106.5 105.3 104.4 105.5 105.6 102.8 106.4 101.9 103.2 103.7 106.1 108.8 104.2 103.4 106.3 104.0 103.1 105.5 104.3 108.5 104.1 104.6 104.5 105.1 103.3 105.9 107.8 105.0 106.3 103.1 104.9 105.5 106.4 103.8 104.2 103.2 104.8 103.9 105.5 107.1 104.5 104.8 105.8 103.8 104.9 105.2 107.1 106.9 103.9 105.3 103.8 102.6 104.7 104.2 103.7 105.7 104.1 104.5 104.4 106.7 106.5 106.4 105.4 106.4 102.7 106.3 104.8 106.8 104.8 105.8 104.3 104.4 103.5 104.8 104.4 104.8 105.9 108.2 104.6 106.7 104.2 103.2 104.1 104.3 107.3 103.2 104.2 104.1 103.9 102.3 106.2 104.0 103.3 103.3 103.5 103.8 102.4 104.4 102.1 104.9 105.5 103.9 103.0 106.4 103.9 102.1 102.9 104.2 104.8 103.5 104.1 103.7 104.0 107.0 104.9 106.4 102.5 107.6 103.9 103.9 103.4 104.8 105.9 105.2 104.9 106.2 104.6 106.2 104.2 105.6 104.2 105.7 105.3 105.2 107.2 105.8 102.2 103.4 105.6 103.5 106.3 105.6 103.4 104.0 103.7 106.6 106.0 106.5 103.9 105.6 105.5 105.2 104.3 102.8 105.4 104.7 106.8 106.4 105.9 103.4 106.9 104.2 106.9 107.5 103.2 104.6 105.3 102.8 106.2 105.3 106.0 109.0 107.6 107.3 108.8 108.1 106.4 105.9 106.0 102.3 105.9 105.8 106.6 106.1 109.0 104.5 105.2 103.6 103.9 104.9 104.5 105.6 106.7 105.3 106.2 104.0 105.8 104.2 106.5 106.7 104.8 104.0 107.6 106.1 106.7 105.7 105.7 103.8 105.8 103.3 104.2 106.9 106.9 104.2 105.2 102.6 107.5 105.1 106.1 103.5 106.6 104.9 107.2 103.8 103.5 102.9 106.2 104.2 104.7 102.4 106.1 106.3 106.8 103.4 107.2 106.5 105.1 103.5 105.1 102.2 102.8 104.5 106.7 106.1 106.2 105.2 105.7 106.8 104.7 102.2 105.7 106.8 107.0 103.2 104.6 102.5 108.2 104.2 105.4 107.5 105.1 104.7 107.3 106.0 102.8 104.9 105.3 105.2 102.3 103.5 101.8 104.3 103.0 104.6 103.1 103.8 103.1 102.2 104.2 105.4 107.4 104.3 104.4 102.5 107.6 105.3 103.5 103.3 105.9 104.7 105.7 103.9 104.3 105.2 107.1 104.8 104.3 106.8 106.0 105.3 7 Temperature readings (F) 8 9 10 11 12 13 14 15 33 34 35 36 37 38 Q2: The engineers have worked to incorporate newer technology into the above process so the temperature between 102 F and 107 F is expected to be maintained during the process. A new sample of 200 temperature readings were taken at different times/days (see the table below). After the incorporation of new technology, does the process (not the sample) meet the 6-sigma standard for temperature control? Explain your answer. 39 40 41 Temperature Met 6-sigma standard, Yes or No? Explain the reasoning behind your answer 42 (F) 43 104.5 44 104.1 45 104.3 46 104.2 47 103.9 48 103.7 49 104.2 50 104.6 51 105.1 52 104.8 53 102.9 54 55 103.8 103.8 56 103.0 57 103.1 58 103.9 59 104.5 60 105.7 1025 Problem 1 Problem 2 Problem 3 + Ready Accessibility: Investigate A + 70%
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...
Question
please help walk me step by step to solve.
Transcribed Image Text:AutoSave OFF
り
× Assignment 4
Tell me
Home Insert
Draw
Page Layout
Formulas
Data
Review View
Automate
Share
Comments
Calibri (Body)
✓
11
✓
Aˆ A
Wrap Text
General
Insert ✓ Σ
✓
✓
✓
Delete ▼
Paste
B
I
U
✓
✓
Merge & Center
$
✓
%9
.00
→0
Conditional Format
Formatting as Table
Cell
Styles
Format
✓
✓
Sort &
Filter
Find &
Select
Analyze
Data
Sensitivity
A1
fx
A
B
C
D
E
F
G
H
J
K
L
M
N
○
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
ΑΙ
AJ
AK
AL
AM
AN
AO
AP
AQ
AR
1
3
2 This problem has two questions: Q1 & Q2. The BrightSpark Electronics plant monitors the temperature of a critical process to ensure product quality. The plant manager has randomly selected 16 temperature
readings each day during the production hours and recorded them for quality control purposes. The following table shows the sample data collected during 4 weeks of observation (i.e., 20 production days).
Q1: The manager wants to investigate whether the critical process is in statistical control, using the average of temperature readings from the sample. Prepare the control chart (with 99.73% control limits) for the
manager. You must show your calculations for making the charts. Your chart should be made by linking to the data on the worksheet, not a picture copied from another source.
4
56
7
8
9
10
11
12
Day
13
1
14
2
15
3
16
4
17
5
18
6
19
7
20
8
21
9
22
10
23
11
24
12
25
13
26
14
27
15
28
16
29
17
30
18
31
19
32
20
1 2 3 4 5 6
16
105.5 104.3 107.9 106.6 104.4 105.2 104.0 103.0 105.7 106.0 107.2 105.6 102.8 103.4 104.6 105.6
106.6 104.1 102.0 104.0 106.5 105.3 104.4 105.5 105.6 102.8 106.4 101.9 103.2 103.7 106.1 108.8
104.2 103.4 106.3 104.0 103.1 105.5 104.3 108.5 104.1 104.6 104.5 105.1 103.3 105.9 107.8 105.0
106.3 103.1 104.9 105.5 106.4 103.8 104.2 103.2 104.8 103.9 105.5 107.1 104.5 104.8 105.8 103.8
104.9 105.2 107.1 106.9 103.9 105.3 103.8 102.6 104.7 104.2 103.7 105.7 104.1 104.5 104.4 106.7
106.5 106.4 105.4 106.4 102.7 106.3 104.8 106.8 104.8 105.8 104.3 104.4 103.5 104.8 104.4 104.8
105.9 108.2 104.6 106.7 104.2 103.2 104.1 104.3 107.3 103.2 104.2 104.1 103.9 102.3 106.2 104.0
103.3 103.3 103.5 103.8 102.4 104.4 102.1 104.9 105.5 103.9 103.0 106.4 103.9 102.1 102.9 104.2
104.8 103.5 104.1 103.7 104.0 107.0 104.9 106.4 102.5 107.6 103.9 103.9 103.4 104.8 105.9 105.2
104.9 106.2 104.6 106.2 104.2 105.6 104.2 105.7 105.3 105.2 107.2 105.8 102.2 103.4 105.6 103.5
106.3 105.6 103.4 104.0 103.7 106.6 106.0 106.5 103.9 105.6 105.5 105.2 104.3 102.8 105.4 104.7
106.8 106.4 105.9 103.4 106.9 104.2 106.9 107.5 103.2 104.6 105.3 102.8 106.2 105.3 106.0 109.0
107.6 107.3 108.8 108.1 106.4 105.9 106.0 102.3 105.9 105.8 106.6 106.1 109.0 104.5 105.2 103.6
103.9 104.9 104.5 105.6 106.7 105.3 106.2 104.0 105.8 104.2 106.5 106.7 104.8 104.0 107.6 106.1
106.7 105.7 105.7 103.8 105.8 103.3 104.2 106.9 106.9 104.2 105.2 102.6 107.5 105.1 106.1 103.5
106.6 104.9 107.2 103.8 103.5 102.9 106.2 104.2 104.7 102.4 106.1 106.3 106.8 103.4 107.2 106.5
105.1 103.5 105.1 102.2 102.8 104.5 106.7 106.1 106.2 105.2 105.7 106.8 104.7 102.2 105.7 106.8
107.0 103.2 104.6 102.5 108.2 104.2 105.4 107.5 105.1 104.7 107.3 106.0 102.8 104.9 105.3 105.2
102.3 103.5 101.8 104.3 103.0 104.6 103.1 103.8 103.1 102.2 104.2 105.4 107.4 104.3 104.4 102.5
107.6 105.3 103.5 103.3 105.9 104.7 105.7 103.9 104.3 105.2 107.1 104.8 104.3 106.8 106.0 105.3
7
Temperature readings (F)
8 9
10
11
12
13
14 15
33
34
35
36
37
38
Q2: The engineers have worked to incorporate newer technology into the above process so the temperature between 102 F and 107 F is expected to be maintained during the process. A new sample of 200
temperature readings were taken at different times/days (see the table below). After the incorporation of new technology, does the process (not the sample) meet the 6-sigma standard for temperature control?
Explain your answer.
39
40
41 Temperature
Met 6-sigma standard,
Yes or No?
Explain the reasoning behind your answer
42
(F)
43
104.5
44
104.1
45
104.3
46
104.2
47
103.9
48
103.7
49
104.2
50
104.6
51
105.1
52
104.8
53
102.9
54
55
103.8
103.8
56
103.0
57
103.1
58
103.9
59
104.5
60
105.7
1025
Problem 1
Problem 2
Problem 3
+
Ready
Accessibility: Investigate
A
+
70%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 4 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.