Do it on paper, Don't use excel

Question 2 The maintenance department of a large hospital uses about 11000 cases of liquid cleanser annually. Ordering cost is $35, carrying cost per unit is 20 percent of the prices of a case, and the new price schedule indicates that orders of less than 200 cases will cost $80 per case, 200 to 299 cases will cost $78 per case, 300 to 399 cases will cost $76 per case, and orders larger than 399 will cost $75 per case. i. Determine the optimal order quantity for each of the ranges ii. Determine the optimal total cost per year for each of the ranges. iii. Determine the minimal total cost solution to the