PLEASE SOLVE USING EXCEL AND ALSO MENTION FORMULAS.

The Blast company prices GC game consoles at $700 per unit. GameCore sells the GC's at $875. Annual demanc at this retail price turns out to be 200,000 units. GameCore incurs ordering, receiving, and transportation costs of $18,000 for each lot of GC's ordered. The annual holding cost used by the retailer is 12 percent. Assuming there are 50 weeks in a year, weekly demand for GC game consoles is normally distributed, with a mean of 4000 and a standard deviation of 350 . The store manager continuously monitors inventory and currently orders 10,000 printers each time the inventory drops to 12,500 printers. Blast currently takes 3 weeks to fill an order. C. (5 points)How much safety inventory does the store carry? What CSL does GameCore achieve as a result of this policy? What fill rate does the store achieve? D. (5 points)Assume that the supply lead time from Blast is normally distributed, with a mean of 3 weeks and a standard deviation of 2 weeks. How much safety inventory should GameCore carry if they want to provide a CSL of 95 percent