-4-21 Consider the following LP problem, in which X and Y denote the number of units of products X and Y to produce, respectively Maximize profit = $5X + $5Y subject to the constraints 2X +3Y 0 (nonnegativity) The Excel Sensitivity Report for this problem is shown in Screenshot 4-10 on page 152. Calculate and explain what happens to the optimal solution for each of the following situations. Each question is independent of the other questions. a. What is the optimal solution to this problem? b. For what ranges of values, holding all else constant, could each of the objective function coefficients be changed without changing the optimal solution? c. If we could obtain one additional unit of resource 1, how would it impact profit? Over what range of RHS values could we rely upon this value? d. If we were to give up one unit of resource 2, how would it impact profit? Over what range of RHS values could we rely upon this value? Microsoft Excel 14.0 Sensitivity Report Problem 4-21 Variable Cells Final Reduced Objective Allowable Allowable Cell Namor Value Cost Coefficient Increaso Decroase SB54 Solution valus x 15.00 0.00 5.00 5.00 1.67 $C$4 Solution value Y 10.00 0.00 5.00 2.50 2.50 Constraints Cell Name $D$7 Resource $D$8 Resource 2 SD$9 Resource 3 Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 60.00 1.25 60.00 60.00 12.00 80.00 0.63 80.00 8 00 40 00 15.00 0.00 18.00 1E+30 3.00