Could you help me solve this in excel please. Showing the formulas in the cells as well as the answers. Thanks so much. Will leave a like!!

D21 f A B D E F G H J K L M N. O 10.8. The local fire department uses 10,000 alkaline flashlight batteries per year, which cost $4 each. The cost of ordering batteries is estimated to be $50. The current interest rate suggested by the city council is 25%. The sales rep has recently suggested that you could get a discount of 2% for orders of 2000 batteries at a time. Should you take 10 advantage of this special offer? 11 Annual demand (A) 10,000 12 Cost per unit (c) $4.00 13 Ordering cost (S) $50.00 14 Annual inventory carrying cost rate (i) 25% 15 Volumn discount 2% 16 Discount threshold 2,000 17 Annual Demand Dollars $40,000.00 18 EOQ 19 Order by EOQ (no discount) Order by discount threshold 20 Unit purchasing price (c) 21 Order quantity (Q) 22 Average inventory (Q/2) 23 # of orders per year 24 Purchase cost (A*c) 25 Inventory carrying cost 26 Ordering cost 27 Total cost 29