A transportation planner has set up the following spreadsheet formulation of a transportation problem: $A transportation planner has set up the following spreadsheet formulation of a transportation problem: Suppose the output from this formulation is as follows: \text { Target Cell (Min) } \begin{array}{cccc} \hline \text { Cell } & \text { Name } & \text { Original Value } & \text { Final Value } \\ \hline \$ E \$ 17 & \text { Total Cost } & 0 & 680 \\ \hline \end{array} \text { Adjustable Cells } \begin{array}{lrrr} \hline \text { Cell } & \text { Name } & \text { Original Value } & \text { Final Value } \\ \hline \text { \$E\$12 } & \text { From I to A } & 0 & 0 \\ \hline \text { SF\$12 } & \text { From I to B } & 0 & 20 \\ \hline \text { \$G\$12 } & \text { From I to C } & 0 & 40 \\ \hline \text { SE\$13 } & \text { From II to A } & 0 & 0 \\ \hline \text { \$F\$13 } & \text { From II to B } & 0 & 60 \\ \hline \$ G \$ 13 & \text { From II to C } & 0 & 0 \\ \hline \text { \$E\$14 } & \text { From III to A } & 0 & 30 \\ \hline \$ F \$ 14 & \text { From III to B } & 0 & 0 \\ \hline \$ G \$ 14 & \text { From III to C } & 0 & 30 \\ \hline \end{array} How many units are shipped from location II to location C? A) 0 B) 60 C) 70 D) 80 E) none of these$ Suppose the output from this formulation is as follows:

\text { Target Cell (Min) }

\begin{array}{cccc}\hline \text { Cell } & \text { Name } & \text { Original Value } & \text { Final Value } \\\hline \$ E \$ 17 & \text { Total Cost } & 0 & 680 \\\hline\end{array}

\text { Adjustable Cells }

\begin{array}{lrrr}\hline \text { Cell } & \text { Name } & \text { Original Value } & \text { Final Value } \\\hline \text { \$E\$12 } & \text { From I to A } & 0 & 0 \\\hline \text { SF\$12 } & \text { From I to B } & 0 & 20 \\\hline \text { \$G\$12 } & \text { From I to C } & 0 & 40 \\\hline \text { SE\$13 } & \text { From II to A } & 0 & 0 \\\hline \text { \$F\$13 } & \text { From II to B } & 0 & 60 \\\hline \$ G \$ 13 & \text { From II to C } & 0 & 0 \\\hline \text { \$E\$14 } & \text { From III to A } & 0 & 30 \\\hline \$ F \$ 14 & \text { From III to B } & 0 & 0 \\\hline \$ G \$ 14 & \text { From III to C } & 0 & 30 \\\hline\end{array}

How many units are shipped from location II to location C?
A) 0
B) 60
C) 70
D) 80
E) none of these

An Automobile Manufacturer That Has Eight Assembly Plants and Thousands

Multiple Choice

Correct Answer:VerifiedUnlock this answer nowGet Access to more Verified Answers free of chargeAccess For Free

Correct Answer:
Verified
Unlock this answer now
Get Access to more Verified Answers free of charge