Given the following Quantity Discount Schedule (Please show all your calculations - Excel solution alone will not be given full credit) - Discount Number Discount quantity 1 2 0 to 199 200 to 499 3 500 to 999 1000 or more Discount % Discount cost ($) 0 45 2.5 To be completed 3% To be completed 3.5% To be completed 4 If the normal cost per unit is $ 45, the ordering cost per order is $70; the annual demand is 3200 units, and the holding cost is 35% of the cost per unit. What order quantity will minimize the total inventory cost? Please show all work