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?$

Problem #$4$ Transportation Models

Please answer the transportation model data and Excel Output to answer questions $24$ to $27.$

Unit Shipping Cost

Sources Plant A Plant B Plant C Plant D Supply

W $5\mathrm{.}0010\mathrm{.}0010\mathrm{.}005\mathrm{.}0010\mathrm{.}00$

X $10\mathrm{.}005\mathrm{.}005\mathrm{.}000\mathrm{.}0020\mathrm{.}00$

Y $10\mathrm{.}005\mathrm{.}0020\mathrm{.}005\mathrm{.}0030\mathrm{.}00$

Z $5\mathrm{.}0020\mathrm{.}0010\mathrm{.}005\mathrm{.}0020\mathrm{.}00$

Demand $10\mathrm{.}0030\mathrm{.}0010\mathrm{.}0020\mathrm{.}00$

Excel Solver Output

Destinations

Sources Plant A Plant B Plant C Plant D Sum Supply

W $0\mathrm{.}000\mathrm{.}0010\mathrm{.}000\mathrm{.}0010\mathrm{.}00<=10$

X $0\mathrm{.}0020\mathrm{.}000\mathrm{.}000\mathrm{.}0020\mathrm{.}00<=20$

Y $10\mathrm{.}0010\mathrm{.}000\mathrm{.}000\mathrm{.}0020\mathrm{.}00<=30$

Z $0\mathrm{.}000\mathrm{.}000\mathrm{.}0020\mathrm{.}0020\mathrm{.}00<=20$

Sum $10\mathrm{.}0030\mathrm{.}0010\mathrm{.}0020\mathrm{.}00$

$====$ Ttl Cost $xxxx

Demand $10301020$

Question # $24$: $-$ Based on the Excel Solver, the minimum total transportation cost is$?$

Question # $25$: $-$ Based on the Excel Solver, what source will have an excess supply?

Question # $26$: $-$ Based on the Excel Solver, the amount shipped from Z to Plant D will be:

Question #$27$: $-$ Based on the Excel Solver output, the dummy destination will receive what amount?