A section of output from Excel Solver is shown below.

$\backslash$table$[[,$Final,$\backslash$table$[[$Reduced$],[$Name$]],\backslash$table$[[$Objective$],[$Coefficient$]],\backslash$table$[[$Allowable$],[$Increase$]],\backslash$table$[[$Allowable$],[$Decrease$]]],[$Product A$,150,0,100,20,40],[$Product B$,100,0,300,120,60]]$

What will happen to the solution if the objective function coefficient for Product A increases by $30?$

The value of the objective function will change, but the values of the decision variables and the shadow prices will remain the same.

The same decision variables will be positive, but their values, the objective function value, and the shadow prices will change.

Nothing. The values of the decision variables, the shadow prices, and the objective function will all remain the same.

$$ The problem will need to be resolved to find the new optimal solution and shadow prices.