Variable cells

$\backslash$table$[[$Ce$11,$Name,Final,Reduced,$\backslash$table$[[$Objective$],[$Coefficient$]],\backslash$table$[[$Allowable$],[$Increase$]],\backslash$table$[[$Al$],[$Di$]]],[$$B$$6,$Activity $1,3,0,30,23,],[$$C$$6$ Activity $2,6,0,40,50,,],[$$D$$6$ Activity $3,0,-7,20,7,1,]]$

Constraints

$\backslash$table$[[,,$Final,Shadow,Constraint,Allowable,A$1],[$Cell$,$Name,Value,Price,R$.$H$.$ Side,Increase,Di$],[$$E$$2,$Resource A$,20,7\mathrm{.}78,20,10,],[$$E$$3,$Resource B$,30,6,30,50,],[$$E$$4,$Resource C$,18,0,40,1E+30,]]$

If the coefficient for Activity $3$ in the objective function changes to $$30,$ then the objective function value: