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

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!