Question: Can someone please help with this problem and explain how to do it on Excel? I just don't know what im doing wrong in excel
Can someone please help with this problem and explain how to do it on Excel? I just don't know what im doing wrong in excel and none of solutions I get on excel so far have been correct.
Consider the following linear program. Min8X+12Ys.t.1X+3Y82X+2Y126X+2Y16X,Y0 (a) Use the graphical solution procedure to find the optimal solution. What is the value of the objective function at the optimal solution? at(X,Y)=() (b) Assume that the objective function coefficient for X changes from 8 to 6 . Use the graphical solution procedure to find the new optimal solution. Does the optimal solution change? The extreme point (X,Y)=(1) optimal. The value of the objective function becomes Does the optimal solution change? The extreme point (X,Y)=() becomes optimal. The value of the objective function becomes (d) The computer solution for the linear program in part (a) provides the following objective coefficient range information. How would this objective coefficient range information help you answer parts (b) and (c) prior to re-solving the problem? The obiective coefficient ranae for variable X is tc . Since the change in part (c) is ]. Since the change in part (b) is this range, we know the optimal solution [1 change. change. The objective coefficient range for variable Y is
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
