Question: please provide excel formulas Points: 16 18. Essay: Part 3: Question 2: Freeport Corporation finds that deman... Question Freeport Corporation finds that demand for surfboards

please provide excel formulas please provide excel formulas Points: 16 18.
Points: 16 18. Essay: Part 3: Question 2: Freeport Corporation finds that deman... Question Freeport Corporation finds that demand for surfboards has averaged 40 units per week with a standard deviation of 15 units. Delivery lead time from the supplier is a consistent 2 weeks. The surfboards cost $50 each, and the annual inventory holding cost rate is 33%. The company estimates that it costs $120 to place and receive each order with the supplier, Freeport wants to manage the surfboards to guarantee a 97cycle service level. a. Determine the optimal order quantity for the surfboards (3 points) b. Determine the safety stock and reorder point required to achieve the target 974 cycle service level. (8 points) Suppose that the supplier has become unreliable and is still delivering orders within an average of 2 weeks but now with a standard deviation of 0.75 weeks. Determine the increase in safety stock that would be required to still achieve the target 97% cycle service level. [5 points)

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!