needs completed using excel OM

M. Cotteleer Electronics supplies microcomputer circuitry to a company that incorporates microprocessors into refrigerators and other home appliances. One of the components has an annual demand of 4200 units, and this is constant throughout the year. The carrying cost is estimated to be $1.5 per unit per year, and the ordering (setup) cost is $50 per order. A. (5 points) To minimize cost, how many units should be ordered each time an order is placed? B. (5 points) How many orders per year are needed with the optimal policy? C. (5 points) What is the average inventory if costs are minimized? D. (5 points) Suppose that the ordering (setup) cost is not $50, and Cotteleer has been ordering 1000 units each time an order is placed. For this order policy (of Q=1000 ) to be optimal, determine what the ordering (setup) cost would have to be