Question: Please show your excel work IM.61 Demand for Etched Impressions Wood products averages 41 units per day with a standard deviation of daily demand being

Please show your excel work IM.61 Demand forPlease show your excel work

IM.61 Demand for Etched Impressions Wood products averages 41 units per day with a standard deviation of daily demand being 4 . Lead time is 5 days. This IBC company strives for a 91% service level. What is the Z-value for the company's desired service level? (Display your answer to two decimal places.) What is the standard deviation of demand during the lead-time period? (Display your answer to two decimal places.) How many units of wood should Etched Impressions carry for safety stock? (Display your answer to two decimal places. Hint: Make sure that your calculation for safety stock uses a cell reference to the Z-value and not merely the number, rounded the in the Z-value field. What is the appropriate reorder point for Etched Impressions? (Display your answer to two decimal places.)

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!