A section of output from Excel Solver is shown below.

$\backslash$table$[[\backslash$table$[[$Name$],[$Product A$]],\backslash$table$[[$Value$],[150]],\frac{\text{C}\text{o}\text{s}\text{t}}{0},100,20,40],[$Product A$,150,\backslash$table$[[0],[0]],300,120,60],[$Product B$,100,0,,,]]$

What will happen to the optimal solution if the objective function coefficient for Product A increases by $30?q,$ The problem will need to be recalculated because the increase caused the range of optimality to be exceeded.

$$ The problem will need to be recalculated because the increase caused the range of feasibility to be exceeded.

The optimal solution will remain the same but the value at the optimal solution will change.

The optimal solution will remain the same and the value at the optimal solution will also remain the same.