Question: need help show work in excel please Suppose that the manager of a construction supply house determined from historical records that demand for sand averages

need help show work in excel please Suppose thatneed help show work in excel please Suppose that need help show work in excel please

Suppose that the manager of a construction supply house determined from historical records that demand for sand averages 54 tons. In addition, suppose the manager determined that demand during lead time could be described by a normal distribution that has a mean of 54 and a standard deviation of 6 tons. Answer the following questions assuming that the manager is willing to accept a stockout risk of no more than 4 percent. Use Table B.2 (Round your answer to two declmal polnts.) a. What value of z is approprlate? b. How much safety stock should be held? (Round your answer to two declmal polnts.) c. What reorder point should be used? (Round your answer to two decimal polnts.) Table B.2 Areas under the standardized normal curve, from to +z

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!