NEED CLEAR EXPLAIN

USE EXCEL SOLVER

IF NOT I GIVE YOU DISLIKE

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 = $4X + $5Y subject to the constraints X+2Y 510 (labor available, in hours) 6X +6Y 536 (material available, in pounds) 8X + 4y 0 (nonnegativity) The Excel Sensitivity Report for this problem is shown in Figure 4.26. Calculate and explain what happens to the optimal solution for each of the following situations. Each question is independent of the other questions. Microsoft Excel 14.0 Sensitivity Report Problem 4-20 Variable Cells Cell Name SBS4 Solution value X SCS4 Solution value Y Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 2.00 0.00 4.00 1.00 1.50 4.00 0.00 5.00 3.00 1.00 Constraints Cell Name $D$7 Labor SD$8 Material $D$9 Storage Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 10.00 1.00 10.00 2.00 2.00 36.00 0.50 36.00 4.00 6.00 32.00 0.00 40.00 1E+30 8.00 Figure 4.26: Solver Sensitivity Report for Problem 4-20 (a) You acquire 2 additional pounds of material. (b) You acquire 1.5 additional hours of labor