C. Prof Brown has won the lottery and decided to purchase a Beer Distributor. One of his first process improvements has been to implement a forecasting system that better predicts how many cases of beer will be sold each month. Forecasted sales for the next 12 months are depicted below. Given this new data Professor Brown has decided to introduce a Reorder Point (ROP) so the warehouse knows when to place an order. He has leased his own warehouse and through effective supplier negotiations has eliminated ordering costs. Thus, he believes it will be more effective to only have Beerinventory equal to his planned forecast plus a level of safety stock to cover forecast deviation. Using information from the textbook and Lecture calculate the safety stock and Reorder Pont (ROP). Assume the following: Lead Time: 53 days (assume there is no variability) Desired Service Level: 95%, You will need to do research in order to determine the Z score: Safety Stock Formula: Safety stock =ZPC//1forecasterror Where PC=TLT T1 - Represents the time increments the Standard Deviation, which for purposes of simplicity you can use 30 dyas. - Calculate the safety stock using the data provided above - Using the resources in the book and data from above calculate the Reorder Point. (Hint: ROP = Safety Stock + expected sales during the lead time interval. You may use a derivative of the mean or some other daily demand calculation for this purpose) D. Given the forecast and the mean of the forecast calculate the coefficient of variation for this item's sales forecast