Read the case carefully, then answer question 16-21. (22 points) Susan Frank is the operations manager of Mauritius Arc Manufacturing Inc. She has developed a linear programming model to help her determine the product mix on one of the three production lines for Mauritius Arc Manufacturing Inc, where x1, x2 and x3 represent production line (product) 1, 2, and 3 respectively. Maximize Z = 15 xl+ 20 x2 + 14 x3 (profit) Subject to: 5 x1 + 6 x2 + 4 x3 0 The spreadsheet solution and sensitivity report are shown in the following two tables. Table 1 Cell Name Final Reduced Objective value cost Coefficient $B$16 Var x1 0 15 $C$16 Var 12 5 R2 20 $D$16 Var 33 32 R3 14 Allowable Allowable Increased Decrease 10.6 2.4 10.6 3.6 1.5 Table 2 The spreadsheet solution and sensitivity report are shown in the following two tables. Table 1 Cell Name $B$16 Var 21 $C$16 Var 22 $D$16 Var x3 Final Reduced value cost 0 R1 5 R2 32 R3 Objective Allowable Allowable Coefficient Increased Decrease 15 10.6 20 2.4 10.6 14 3.6 1.5 Table 2 Cell Name Final Shadow Constraint Allowable Allowable value Price R.H.S Increase Decrease $B$21 L.H.S 158 0 210 52 $B$22 L.H.S 200 2.4 200 70.9 30 $B$23 L.H.S 170 0.4 170 30 120 Question 16 (2 points) Listen (a) How much of each product should be produced each day in order to achieve the maximum profit and also calculate the value of Z. Question 17 (3 points) Listen (b) Calculate the slack or surplus in each constraint. Paragraph B I UA lili ot DO + 7 ... Question 18 (3 points) Listen (c) What is the range of optimality for the objective function coefficients of product 1, product 2, and product 3? Question 19 (3 points) Listen (d) Identify the range of feasibility for the right-hand side values for each of the constraint. Paragraph U v A, lili bello + >