A warehouse manager, Jane, needs to
Question # 00393922
Posted By:
Updated on: 09/23/2016 10:28 PM Due on: 09/24/2016
A warehouse manager, Jane, needs to determine how many order pickers she should staff. The daily demand is normally distributed with a mean of 58,855 parts and a standard deviation of 4876 parts. The number of parts that order pickers pick daily is normally distributed with a mean of 6012 parts and a standard deviation of 163 parts.
Design a simulation using excel to help Jane determine how many order pickers she should hire so that demand is satisfied 97.5% of the time.
Please explain your workings.
-
Rating:
/5
Solution: A warehouse manager, Jane, needs to