Question: Excel's Solver tool has been used in the spreadsheet below to solve a linear programming problem to determine the optimal values of profits from the
Excel's Solver tool has been used in the spreadsheet below to solve a linear programming problem to determine the optimal values of profits from the mix of two products: X and Y. What is the objective function?
| Variable | Final value | Reduced Cost | Objective Coefficient | Allowable Increase | Allowable decrease |
| X | 20 | 0 | 5 | 2 | 1 |
| Y | 30 | 0 | 4 | 3 | 2 |
What is the optimal output for the objective function?
if the manager want to increase to profit on product X to 6 dollars, what will happen to the objective function? Group of answer choices
a.The objective function will not change and the optimal output will not change too.
b. The objective function will change and the optimal output will change too. c.The objective function will not change and the optimal output will become 240.
D. The objective function will change and the optimal output will become 240.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
