operations research

please solve in excel with all the steps and formulas

will give a thumbs up, thank you !

5. (25 points) Demand for a specific model of Kenmore refrigerator at NWA Sears is Poisson with mean of 5 per month. The lead time is 2 months and the Sears store manager uses base stock policy with a reorder point (r) of 12. a. Evaluate the manager fill rate. b. Suppose the manager's goal is to achieve 95% fill rate. What is the required base stock level point (R)? The selling price of a refrigerator is $800, the acquisition cost is $640, the firm carrying cost is 15% per year. The firm has a customer service policy, that if the refrigerator is not on stock, it is backorder but gives the customer a 5% discount over the selling price. Calculate the fill rate, back order level, and inventory level for the required reorder point