Question: Please show work in full detail with formulas, i do not have excel and need to understand how the problem is worked by hand 4.

Please show work in full detail with formulas, i do not have excel and need to understand how the problem is worked by hand
4. a) One of the hot sellers for the Wonka Toy store is the Chocolate Factory Board Game. The store uses a periodic review inventory system. The review period for the board game is 4 weeks, while the lead time to obtain the board game is 1 week. The demand for the board game is normally distributed with a mean of 800/month and a standard deviation of 20/week. If the store uses a target inventory of 1055, what service level is being achieved? (Assume there are 4 weeks in a month). (10 points) b) Harvey Gold, the owner of Harvey's Specialty Shop, orders an unusual olive from the island of Santorini, off the Greek coast. Over the years, Harvey has noticed considerable variability in the time it takes to receive the orders of these olives. On average, the order lead time is four months and the standard deviation is six weeks (1.5 months). Monthly demand for the olives is normally distributed with mean 15 and standard deviation 6. Harvey provides a service level of 94% during the leadtime. Determine the Reorder point (ROP) for this data? (10 points)Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
