Question: please use excel solver to solve it. Consider the following linear program: Min s.t. 8X + 12Y 1X + 3Y >= 9 2X + 2Y

please use excel solver to solve it.
please use excel solver to solve it. Consider the
Consider the following linear program: Min s.t. 8X + 12Y 1X + 3Y >= 9 2X + 2Y >= 10 6X + 2Y >= 18 A, B >= 0 a. Use the graphical solution procedure to find the optimal solution. b. Assume that the objective function coefficient for X changes from 8 to 6. Does the optimal solution change? Use the graphical solution procedure to find the new optimal solution. C. Assume that the objective function coefficient for X remains 8, but the objective function coefficient for Y changes from 12 to 6. Does the optimal solution change? Use the graphical solution procedure to find the new optimal solution. d. The computer solution for the linear program in part (a) provides the following objective coefficient range information: Variable Objective Allowable Allowable Coefficient Increase Decrease X 8.00000 4.00000 4.00000 Y 12.00000 12.00000 4.00000 How would this objective coefficient range information help you answer parts (b) and (c) prior to re-solving the

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!