Question: Please show full steps in excel with formulas, I will provide thumbs up! :) Please dont copy answer from another question 3. The Mom and

Please show full steps in excel with formulas, I

Please show full steps in excel with formulas, I will provide thumbs up! :) Please dont copy answer from another question

3. The Mom and Pop's is a country store specializing in ornaments suitable for a farm-house decor. One item with high demand is a miniature Holstein cow. The weekly demand follows normal distribution with an average of 30 cows, and a standard deviation of 5 cows. The cost to place a replenishment order is $15 and the holding cost is $0.75/cow/year. The supplier is in China. The lead time for new orders is 8 weeks, with a standard deviation of 2 weeks. The owner of the store, which is open only 50 weeks a year, wants to develop a continuous review inventory system for this item with a cycle-service level of 90 percent. a) Specify the inventory policy for the cows. Explain how it would work in practice. Round the numbers to the nearest integer. b) What is the total annual cost for the policy you developed

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!