The manager has solved this problem using Excel Solver and the sensitivity report is given below:Variable CellsCell$5$B$525$C$52$SD$52$ CNameFinal Reduced Objective Allowable AllowableValue$16084$Cost Coefficient IncreaseDecrease$120\mathrm{.}5-10151$E$+3016$ConstraintsCellNameValueFinal ShadowPriceConstraint Allowable AllowableR.H$.$ Side Increase DecreaseSES$6$ Material $17200\mathrm{.}872080420$SEST Material $22$B$406001$E$+30316$SESB Material $34002,440056040$Based on the information given $($No need to implement this problem into solver$),$ by how much would the total profit increase if an additional $100$ pounds of Material $1$ could be obtained?No change$0\mathrm{.}824080$