NEED CLEAR EXPLANATION AND USE THE EXCEL SOLVER

IF NOT I GIVE DISLIKE SURE

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 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 SB$4 Solution value X SC$4 Solution value Y Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 2 00 000 400 100 1.50 4.00 0.00 500 3.00 1.00 Constraints Cell Name $D$7 Labor SD$8 Material SOS9 Storage Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 1000 1.00 10.00 2.00 200 36 00 0.50 36.00 4.00 6.00 32 00 000 40.00 1E+30 800 Figure 4.26: Solver Sensitivity Report for Problem 4-20 (a) You decide to introduce a new product that has a profit contribution of $2. Each unit of this product will use 1 hour of labor, 1 pound of material, and 2 square feet of storage space