Given the following Quantity Discount Schedule (Please show all your calculations - Excel solution alone will not be given full credit) - For 15 points Discount Number 1 2 3 4 Discount quantity 0 to 199 200 to 499 500 to 999 1000 or more Discount% 0 2.5 3% 3.5% Discount cost ($) 45 To be completed To be completed To be completed 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