Please provide excel formula

4. The annual demand for a particular drug is 1,800 tablets. The purchase price of a tablet is $20. The holding cost per unit per year is 25% of the item's price, and the cost of placing an order is $30. The pharmacist orders the drug in quantities of 200. Demand is known and constant. a. Determine the optimal order quantity. b. Determine the total annual ordering and holding costs for the quantity determined in part a. C. Determine the total annual cost associated with the quantity ordered by the pharmacist. Which cost (holding or ordering) is higher and why? d. If the pharmacist used the EOQ, how many orders per year would be placed on average? What would the length of an order cycle (time between two consecutive orders) be, assuming 300 work days in a year? 9. D llowing fx 25% -5 D C E G H B M4-5(P11.4) 10 3 1,800 $ 20.00 25.0% of item cost $ 30.00 200 Annual demand, D Item Cost Holding cost per item per year Placing order cost, S Order quantity, Q . Holding cost per item per year, H $ 5.00 a. Optimal order quantity, EOQ 147.00 b. Total Cost for EOQ (TC using EOQ) #NAME? . c. Total Cost for Q (TC using Q) #NAME? d. Average number of orders placed Length of order cycle orders days