Introduction to management ( MG305) book

problem 16, pg 151

LINEAR PROGRAMMING SENSITI 16 Consider the Insider the following LP problem, in which X and enote the number of units of products X and Y to produce, respectively: Maximize profit = $4X + $5Y subject to the constraints X + 2Y = 10 (labor available, in hours) 6X + 6Y S 36 (material available, in pounds) 8x + 4Y S 40 (storage available, in square feet) X Y Z 0 (nonnegativity) The Excel Sensitivity Report for this problem is shown in Screenshot 9. Calculate and explain what happens to the optimal solution for each of the fol- lowing 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 ob Microsoft Excel 14.0 Sensitivity Report Problem 16 Variable Cells Cell Name ISB$4 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.501 4.00 0 .00 5.00 3.00 1.00 Constraints Cell Name $D$7 Labor SDS 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