Solved

A Transportation Planner Has Set Up the Following Spreadsheet Formulation  Target Cell (Min) \text { Target Cell (Min) }

Question 9

Multiple Choice

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:  Target Cell (Min)  \text { Target Cell (Min) }
 Cell  Name  Original Value  Final Value $E$17 Total Cost 0680\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}


 Adjustable Cells \text { Adjustable Cells }
 Cell  Name  Original Value  Final Value  $E$12  From I to A 00 SF$12  From I to B 020 $G$12  From I to C 040 SE$13  From II to A 00 $F$13  From II to B 060$G$13 From II to C 00 $E$14  From III to A 030$F$14 From III to B 00$G$14 From III to C 030\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

Correct Answer:

verifed

Verified

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

Related Questions