Problem # $3$

Consider the Solver output of a linear programming problem in which $3$ resources A$,$ B and C$,$ are

blended for the best mix at the minimum total cost.

Assume you correctly solved this problem and obtain following

sensitivity report from the Solver Solution. Use the solver report to

answer Question #$23$ seen below Table G$.$

Table G$.$

Variable Cells

Final Reduced Objective Allowable Allowable

Variable Value Cost Coefficient Increase Decrease

T$10\mathrm{.}2590800223\mathrm{.}636120$

T$20\mathrm{.}7037040066\mathrm{.}848300$

T$30\mathrm{.}037060085\mathrm{.}714118\mathrm{.}269$

T$4091\mathrm{.}115001\mathrm{.}00$E$+3091\mathrm{.}11$

Constraints

Resource Final Reduced Objective Allowable Allowable

Name Value Cost Coefficient Increase Decrease

A Total $544\mathrm{.}4452\mathrm{.}3750\mathrm{.}25$

B Total $131\mathrm{.}67010031\mathrm{.}6671\mathrm{.}00$E$+30$

C Total $304\mathrm{.}44300\mathrm{.}7147$

Balance Total $1155\mathrm{.}5610\mathrm{.}250\mathrm{.}043$

Question #$23$: $-$What will happen to the solution if the cost per unit of T$2$ is decreased to $$300?$