Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following LP problem: Max 4X1-3X2+5X3 2Xi-3X3 S20 3X2+5X3 25 Using the Excel Solver, one obtains the optimal objective value of 37 and the

image text in transcribed

Consider the following LP problem: Max 4X1-3X2+5X3 2Xi-3X3 S20 3X2+5X3 25 Using the Excel Solver, one obtains the optimal objective value of 37 and the following Sensitivity Report Microsoft Excel 16.0 Sensitivity Report Report Created: 6/12/2017 4:27:59 PM Variable Cells Cell uS5 X1 SK$5 X2 L$5 X3 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 1.5 E+30 E+30 4 1E+30 8.8 -8.8 Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease Cell SMS11 Constraint 3 Obj 5-0.6 5 205 10 3.5 13 20 1E 30 1. What is the optimal solutions for Xi Xa, and X? 2. Please answer following questions by circling Yes or No in the "Answer" column Question Answer 1. Will the optimal objective value still be 37 if the coefficient for X in the objective function increasesYesNo from 4 to 4.5? 2. Will the optimal solutions to Xi, X and Xa remain unchanged if the coefficient for X in the objectve YesNo function decreases from -3 to -5 3. Will the optimal solutions to Xi, X andX, remain unchanged if the coefficient for X, in the objective YesNo function increases from 5 to 9? Is constraint 1 binding under the optimal solution? 5. Is constraint 2 binding under the optimal solution? Yes No No raint 7. The shadow of constraint 3 will still be -0.6 if its RHS increases from 5 to 10

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Understand Business Finance

Authors: Bob Cinnamon, Brian Helweg-Larsen

2nd Edition

0749460202, 978-0749460204

More Books

Students also viewed these Finance questions

Question

Understand why succession management is important.

Answered: 1 week ago

Question

Make efficient use of your practice time?

Answered: 1 week ago