Coffee Bean Scenarlo Use the information given below for all questions in this scenario. Your friend from UMFlint, Cathy Morehouse, has started her own business roasting coffee beans and shipping them to customers. Sh gets orders online, and is currently shipping 16oz bags of freshly roasted and packed coffe beans. Cathy wants each bag's weight to b within 0.3 oz of the stated 16oz target. You take a sample of 10 bags and measure their weight using an accurate digital weighing machine. Data is provided in the Excel file. Excel data file: coffe bean data4.xlsx What is the process capability ratio (Cp)? Enter your answer rounded to 3 decimal places. QUESTION 23 Coffee Bean Scenario Use the information given below for all questions in this scenario. What is the process capability index (Cpk)? Enter your answer rounded to 3 decimal places.

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
I really need help with these two
A
B
D
G
3 Bag
Weight
1
16.164
16.111
6
3
16.149
4
16.058
8.
16.066
9
6
16.183
10
7
16.207
11
16.081
12
9
16.202
13
10
16.033
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
Sheet1
+.
30
Transcribed Image Text:A B D G 3 Bag Weight 1 16.164 16.111 6 3 16.149 4 16.058 8. 16.066 9 6 16.183 10 7 16.207 11 16.081 12 9 16.202 13 10 16.033 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Sheet1 +. 30
QUESTION 22
Coffee Bean Scenario
Use the information given below for all questions in this scenario.
Your friend from UMFlint, Cathy Morehouse, has started her own business roasting coffee beans and shipping them to customers. She
gets orders online, and is currently shipping 16oz bags of freshly roasted and packed coffe beans. Cathy wants each bag's weight to be
within 0.3 oz of the stated 16oz target.
You take a sample of 10 bags and measure their weight using an accurate digital weighing machine. Data is provided in the Excel file.
Excel data file: coffe bean data4.xlsx
What is the process capability ratio (Cp)? Enter your answer rounded to 3 decimal places.
QUESTION 23
Coffee Bean Scenario
Use the information given below for all questions in this scenario.
What is the process capability index (Cpk)? Enter your answer rounded to 3 decimal places.
Transcribed Image Text:QUESTION 22 Coffee Bean Scenario Use the information given below for all questions in this scenario. Your friend from UMFlint, Cathy Morehouse, has started her own business roasting coffee beans and shipping them to customers. She gets orders online, and is currently shipping 16oz bags of freshly roasted and packed coffe beans. Cathy wants each bag's weight to be within 0.3 oz of the stated 16oz target. You take a sample of 10 bags and measure their weight using an accurate digital weighing machine. Data is provided in the Excel file. Excel data file: coffe bean data4.xlsx What is the process capability ratio (Cp)? Enter your answer rounded to 3 decimal places. QUESTION 23 Coffee Bean Scenario Use the information given below for all questions in this scenario. What is the process capability index (Cpk)? Enter your answer rounded to 3 decimal places.
Expert Solution
steps

Step by step

Solved in 2 steps

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.