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 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

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!