Everbright, a light bulb firm, faces both uncertain demand and supply, which can be modeled by normal distributions. Answer the following questions. For a typical 2-week (10-workday) period, daily demand in units is recorded as follows: 10 15 20 22 18 25 25 16 18 21 For the past 10 deliveries, the following pattern of lead times (i.e., performance cycle) in days is observed as follows: Lead Time (Days) Frequency 8 1 7 2 4 5 4 1 Total 10 Q7. What is the standard deviation of daily demand (keep two decimals)? Tip: use Excel for calculations; round only at the last step 4.40

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 answer in 30 mins. and only if you are sure.
Everbright, a light bulb firm, faces both uncertain demand and supply, which can be modeled by normal distributions. Answer the following questions.
For a typical 2-week (10-workday) period, daily demand in units is recorded as follows:
10
15
20
22
18
25
25
16
18
21
For the past 10 deliveries, the following pattern of lead times (i.e., performance cycle) in days is observed as follows:
Lead Time (Days)
Frequency
8
1
7
2
6
4
5
2
4
Total
10
Q7. What is the standard deviation of daily demand (keep two decimals)? Tip: use Excel for calculations; round only at the last step
4.40
Transcribed Image Text:Everbright, a light bulb firm, faces both uncertain demand and supply, which can be modeled by normal distributions. Answer the following questions. For a typical 2-week (10-workday) period, daily demand in units is recorded as follows: 10 15 20 22 18 25 25 16 18 21 For the past 10 deliveries, the following pattern of lead times (i.e., performance cycle) in days is observed as follows: Lead Time (Days) Frequency 8 1 7 2 6 4 5 2 4 Total 10 Q7. What is the standard deviation of daily demand (keep two decimals)? Tip: use Excel for calculations; round only at the last step 4.40
Expert Solution
steps

Step by step

Solved in 2 steps with 2 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.