Q$2)$ Suppose the U$.$S$.$ pharmaceutical company has $3$ factories supplying the warehouses for $3$ major

consumers and its management wants to determine the minimum$-$cost shipping schedule for its monthly

output to these customers. Factory supply, warehouse demand, and shipping costs per case for these drugs

are shown in following table.

Data for U$.$S$.$ pharmaceutical transportation problem

Shipping costs per case $($in dollars$)$

Please indicate the optimum low$-$cost transportation plan for the U$.$S$.$ pharmaceutical company

$($i$)$ By using northwest corner method and then stepping stone approach. Show details of

$($ii$)$ By using excel solver