Question: please answer this question and not just post the answer to an old one. Thank you!! London, Inc., stocks a crucial part that has a

please answer this question and not just post the answer to an old one. Thank you!!
please answer this question and not just post the
please answer this question and not just post the
London, Inc., stocks a crucial part that has a normally distributed demand pattern during the reader penod. Past de and shows that the average demand during lad time () for the part is 520 units, and the standard deviation of demand during lead time(r) is 46 units. The supply chain manager wants to determine the safety stock and statistical reorder pourt that result in 14 percent stockouts or a service level of 86 percent. Alternately, the manager wants to know the additional safety stod required to attain a 90 percent service level Open the spreadsheet and perform the required analysis to answer the questions below. Do not found intermediate calculations, Round your answers to the nearest whole number Open spreadsheet Questions 1. What is the required safety stock at a 86 percent service level? units 2. What is the reorder point? units 3.What is the required safety stock at a 90 percent service level? uns A B D E 1 Statistical Reorder Point Using Probabilistic Demand and Constant Delivery Lead Time 2 3 Average demand () 520 4 Demand Standard deviation (OALT) 46 5 Service level 86% 6 Service level alternate 90% 7 Formulas 8 Z-value for service level #N/A 9 Z-value for service level alternate #N/A 10 11 Required safety stock units #N/A 12 ROP units #N/A 13 14 Required safety stock alternate units #N/A 15 16 Safety stock difference units #N/A 17

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!