Question: provide me this case with the formulas in excel . please use excel. provide me the answer At the Jugos Felicidad distribution warehouse, inventory planning

provide me this case with the formulas in excel .
please use excel.
provide me the answer
At the Jugos Felicidad distribution warehouse, inventory planning is being conducted for the assortment of 1.5-liter plastic containers. The annual demand is 24,400,000 liters, with a daily demand standard deviation of 90,000 liters/day. The price per liter is $5.50. The order management cycle is 30 days, and the cost of placing an order is $10.50. It has been determined that the holding cost is $0.20 per liter. To review the inventory planning and its policy, you have been asked to: a) Using the inventory planning table, determine the inventory policy and provide a recommendation on which inventory policy should be implemented, considering the most optimal service level.

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!