Please provide needed excel formulas and step by step directions

4. The annual demand for a particular drug is 1,800 tablets. The is 25% of the item's price, and the cost of placing an order is $30. purchase price of a tablet is $20. The holding cost The pharmacist orders the drug in quantities of 200. Demand is costs per unit per year 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? -12 fx B C D E 1 M4-5(P11.4) H 2 Annual demand, D Item Cost Holding cost per item per year Placing order cost, s Order quantity, Q 1,800 $ 20.00 25.0% of item cost $ 30.00 200 Holding cost per item per year, H a. Optimal order quantity, EOQ b. Total Cost for EOQ (TC using EOQ) c. Total Cost for Q(TC using Q) d. Average number of orders placed Length of order cycle orders days