Question: please help with below Using screenshot 9 of the sensitivity report on page 151, answer questions 4-20 parts A-E on page 151. You have to
please help with below
Using screenshot 9 of the sensitivity report on page 151, answer questions 4-20 parts A-E on page 151. You have to click on the link in the problem to see the screenshot of the sensitivity report. To ensure that you find the correct page, I have attached a screenshot of the problem and the sensitivity report. 11.4-20 Consider the following LP problem, in which X and Y denote the number of units of products X and Y to produco, respectively Maximize profit $4X+$5Y subject to the constraints X+2Y S 10 (labor available, in hours) 6X + 6Y S 36 (material available, in pounds) 8X+4Y 40 (storage available, in square fet) XY > 0 (nonnegativity) The Excel Sensitivity Report for this problem is shown in Screenshot 4-9 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. o. 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. Microsoft Excel 14.0 Sensitivity Report Problom 4-20 Variable Cols Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 Solution value X 200 110.00 24.00 1.00 1.50 SCS4 Solution value Y14.00 0.00 15.00 13.00 1,00 Constraints Coll Namo SDS7 Labor $D$8 Matoris SOS9 Storage Final Shadow Constraint Allowable Allowablo Value Prico R.H. Side Increaso Docroato 10.00 1.00 10.00200 200 36.00 0.50 11111136.00 4.00 6.00 32000.00 40.001E+30800


Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
