Question: Please show the calculations. (in Excel file format using Excel formulas) Weekly demand for avocados at the Guac Shop is normally distributed with a mean

Please show the calculations. (in Excel file format using Excel formulas)Please show the calculations. (in Excel file

Weekly demand for avocados at the Guac Shop is normally distributed with a mean of 2500 and a standard deviation of 650. The store manager has decided to follow a periodic review policy to manage inventory of avocados. They plan to order every two weeks. The farmers currently take two weeks to fill an order. a) Given a desired Cycle Service Level (CSL) of 97.5 percent, how much safety inventory should the Guac Shop carry? b) What should their Order-up-to Level (OUL) be

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!