Question: please help with below question w Using screenshot 9 of the sensitivity report on page 151, answer questions 4-20 parts A-E on page 151. You

please help with below question
please help with below question w Using
please help with below question w Using
please help with below question w Using
w 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. Y 11.4-20 Consider the following LP problem, in which X and Y denote the mumber 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 3 40 (storage available, in square feet) X,Y 20 (nonegativity) The Excel Sensitivity Report for this problom is shown in Screenshot 4-0 Calculato 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 matorial b. You acquiro 15 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 Y are changed to $4.75 each . You decide to introduce a new product that has a profit contribution of S2 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 Cels Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SBS4 Solution value X 2000.00 4.00 1.00 1.50 SCS4 Solution value Y 4.000.00 5.00 3.00 1.00 Constraints Final Shadow Constraint Allowable Allowable Coll Namo Valuo Prico R.H. Sido Increaso Docroaco SDS7 Labor 10 00 1.00 10.00 200 200 SD$8 Motorial 36.00 0.50 36.00 4.00 6.00 SO89 Storage 32 00 0.00 40.00 1E+30 8.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!