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 Screenshot 4-90. Calculate and explain what happens to the optimal solution for each of the following situations. Each question is independent of the other questions. a. You acquire 2 additional pounds of material. b. You acquire 1.5 additional hours of labor. c. You give up 1 hour of labor and get 1.5 pounds of material. d. The profit contributions for both products X and Yare changed to $4.75 each. e. You decide to introducera 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. 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 Coll Name SDS7 Labor SDS8 Material SDS9 Storage Final Shadow Constraint Allowable Allowable Value Prico R.H. Side Increase Decreaso 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 1E430 8.00