Consider a firm selling Calnders. Suppose you need to order 2019 calnders to sell next year. Each calendar you order will cost you $7. The price of the calnders is fixed at $10. Demand is uncertain but suppose that uou have historical data and you think that the average demand is around 300. Demand obviously varies from year to year but it actually looks somewhat symmetric and Normal-shaped with a standard deviation of 15. Unsold calenders have no salvage valuw and will be discrded a) suppose you order 200 calenders. simulate the profit using 1000 random draws from the uncertain demand. What is your average profit? Be sure to include a prediction interval and confidence interval with your estimated average profit Use excel

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Consider a firm selling Calnders. Suppose you need to order 2019 calnders to sell next year. Each calendar you order will cost you $7. The price of the calnders is fixed at $10. Demand is uncertain but suppose that uou have historical data and you think that the average demand is around 300. Demand obviously varies from year to year but it actually looks somewhat symmetric and Normal-shaped with a standard deviation of 15. Unsold calenders have no salvage valuw and will be discrded 

a) suppose you order 200 calenders. simulate the profit using 1000 random draws from the uncertain demand. What is your average profit? Be sure to include a prediction interval and confidence interval with your estimated average profit 

Use excel 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
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,