Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a normal distribution with a mean of 24 gallons per week and a standard deviation of 3.5 gallons per week. The new manager desires a service level of 90 percent. Lead time is two days, and the dairy is open seven days a week. (Hint: Work in terms of weeks.) Use Table B and Table B1.   a-1. If an ROP model is used, what ROP would be consistent with the desired service level? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)   ROP             gallons   a-2. How many days of supply are on hand at the ROP, assuming average demand? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)   Days               b-1. If a fixed-interval model is used instead of an ROP model, what order size would be needed for the 90 percent service level with an order interval of 7 days and a supply of 8 gallons on hand at the order time? (Do not round intermediate calculations. Round your final answer to the nearest whole number.)   Order size             gallons   b-2. What is the probability of experiencing a stockout before this order arrives? (Do not round intermediate calculations. Round your final answer to the nearest whole percent. Omit the "%" sign in your response.)

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
icon
Concept explainers
Topic Video
Question
Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a normal distribution with a mean of 24 gallons per week and a standard deviation of 3.5 gallons per week. The new manager desires a service level of 90 percent. Lead time is two days, and the dairy is open seven days a week. (Hint: Work in terms of weeks.)
Use Table B and Table B1.
 
a-1. If an ROP model is used, what ROP would be consistent with the desired service level? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)
 

ROP             gallons
 
a-2. How many days of supply are on hand at the ROP, assuming average demand? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)
 

Days            
 
b-1. If a fixed-interval model is used instead of an ROP model, what order size would be needed for the 90 percent service level with an order interval of 7 days and a supply of 8 gallons on hand at the order time? (Do not round intermediate calculations. Round your final answer to the nearest whole number.)
 
Order size             gallons
 
b-2. What is the probability of experiencing a stockout before this order arrives? (Do not round intermediate calculations. Round your final answer to the nearest whole percent. Omit the "%" sign in your response.)
 

Probability             %
 
c. Suppose the manager is using the ROP model described in part a. One day after placing an order with the supplier, the manager receives a call from the supplier that the order will be delayed because of problems at the supplier’s plant. The supplier promises to have the order there in two days. After hanging up, the manager checks the supply of walnut fudge ice cream and finds that 2 gallons have been sold since the order was placed. Assuming the supplier’s promise is valid, what is the probability that the dairy will run out of this flavor before the shipment arrives? (Do not round intermediate calculations. Round your final answer to the nearest whole percent. Omit the "%" sign in your response.)
 

Risk probability             %
 
 
 
 
 
 
 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

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,
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.