please show all the work in detail with all the excel formulas, on EXCEL please.

3 PROBLEM 1 4 Brooke Army Medical Center dispenses 250,000 bottles of brand name pharmaceutical annually. The optimal safety stock (which is on hand 5 initially) is 1,000 bottles. Each bottle costs the center $10, inventory carrying costs are 30 percent, and the cost of placing an order with its supplier is $175. 6 7 a. What is the economic order quantity? 8 b. What is the maximum inventory for this medication? 9 c. What is the center's average inventory of bottles of this medication? 10 d. How often must the center order (in days)? 11 12 ANSWER 13 Ordering costs F $175 14 Annual usage in units S 250,000 15 Annual carrying costs C 16 Purchase price per bottle P $10.00 17 Days per year w 360 18 Safety stock SF 1,000 19 30%