Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

A section of output from Excel Solver is shown here; what will happen to the sol

ID: 3177960 • Letter: A

Question

A section of output from Excel Solver is shown here; what will happen to the solution if the objective function coefficient for V1 increases by 25? the value of the objective function will decrease, but the values of the decision variables and the shadow prices will remain the same. the problem will need to be resolved because the range of optimality has been exceeded. the same decision variables will be positive, but their values, the objective function value, and the shadow prices will change. the problem will need to be resolved because the range of feasibility has been exceeded.

Explanation / Answer

For V1, allowable increase is upto 20 only. If we increase the coefficient by 25, then we final value will change and the entire problem needs to be resolved again.

So option 2 is correct.

The range of optimality, which is the range of values over which the objective function coefficient of a decision variable can change without changing either the list of variables in solution or their optimal quantities, although the value of the objective function will change.

The range of feasibility, which is the range of values of the RHS quantities of a constraint for which the shadow prices and the variables in solution remain the same.

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote