Excel solutions only. Please show formulas.

Do the work for the following producer of refrigerators. The company manufactures subcomponents for its refrigerators at the rate of 275 units per day. The annual usage rate of this subcomponent is 30,000 units. The holding cost is $3 per unit per year, and the setup costs of producing these subcomponents is $50 per setup. The company operates ins manufacturing facility for 300 days during a year. a (2 points) What ist he Economic production quantity (EPQ)? b (2 points) What is the average inventory level for this optimum production quantity? (2 points) How many production setups would there be in a year? d (2 points) What is the optimal length of a production run in days? e (2 points) What would be the savings in annual costs if setup costs can be reduced to $40 per setup