please answer this one and not just post an old one. Thank you!!

Brussels, Inc. is a local liquor retailer specializing in selling beer at bo discounts, Historical data shows that the demand for beer has a normal distribution. The average daily demand for beer at Brussels is 250 cases, and its standard deviation for daily demand is 26 cases. Brussels supplier maintains a very reliable and constant lead time of four days. The manager desires to determine the standard deviation of demand during lead time, the safety stock and statistical reorder point that results in a 92.5 percent service level and the safety stock reduction in the manager decides to attain a 87.5 percent service level Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. HAH Open spreadsheet Questions 1. What is the standard deviation of demand during lead time? Round your answer to one decimal place. cases 2. What is the required safety stock at a 92.5 percent service level? Round your answer to the nearest whole number. Cases 3. What is the reorder point? Round your answer to the nearest whole number cases 4. What is the required safety stock at a 87.5 percent service level? Round your answer to the nearest whole number A B D E Statistical Reorder Point Using Probabilistic Demand and Constant Delivery Lead Time 2 3 Average daily demand (d) 250 cases 4 Demand Standard deviation (0) 26 cases 5 Service level 92.5% 6 Service level alternative 87.5% 7 Lead tme, LT 4 days 8 Formulas 9 Standard deviation of demand during lead time cases #N/A 10 11 Z-value for service level #N/A 12 Z-value for service level alternative #N/A 13 14 Required safety stock cases #N/A 15 ROP cases #N/A 16 17 Required safety stock alternative cases #N/A 18 19 Safety stock difference cases #N/A 20