Please answer everything in the clearest way and with all the steps If it can be in Excel better Thanks

Problem 2 (18 points). An assembly plant purchases 35,000 filters per year. Fixed order cost is $100. The holding cost rate is 0.4 per year. The vendor has offered the following price breaks: for orders of more than 5,000 filters, cost is $2.90/unit; for orders between 1,000 and 5,000 filters, cost is $3.00/unit; orders less than 1,000 filters have a cost of $3.10/unit a. (10 points). Find the economic order quantity. b. (8 points). Calculate the average annual cost for the optimal solution