Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Microsoft Excel 14.0 Sensitivity Report Problom 4-20 Variable Cells Cell Name SBS4 Solution value X SCS4 Solution value Y Constraints Coll SDS7 Labor SDS8 Material
Microsoft Excel 14.0 Sensitivity Report Problom 4-20 Variable Cells Cell Name SBS4 Solution value X SCS4 Solution value Y Constraints Coll SDS7 Labor SDS8 Material SDS9 Storage Name 11.4-20 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 2.00 4.00 0.00 0.00 1.00 0.50 0.00 4.00 5.00 1.00 3.00 Final Shadow Constraint Allowable Allowable Value Price R.H. Sido Increase Docroase 10.00 10.00 36.00 36.00 32.00 40.00 subject to the constraints X + 2Y 6X+6Y 8X+4Y X, Y 2.00 4.00 1E+30 1.50 1.00 (Ctrl) 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: - 2.00 6.00 8.00 $4X + $5Y 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 Y are changed to $4.75 each. e. 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 Cells Cell Name SBS4 Solution value X SCS4 Solution value Y Constraints Coll SDS7 Labor SDS8 Material SDS9 Storage Name 11.4-20 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 2.00 4.00 0.00 0.00 1.00 0.50 0.00 4.00 5.00 1.00 3.00 Final Shadow Constraint Allowable Allowable Value Price R.H. Sido Increase Docroase 10.00 10.00 36.00 36.00 32.00 40.00 subject to the constraints X + 2Y 6X+6Y 8X+4Y X, Y 2.00 4.00 1E+30 1.50 1.00 (Ctrl) 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: - 2.00 6.00 8.00 $4X + $5Y 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 Y are changed to $4.75 each. e. 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started