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

question 9

Multiple Choice

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

---

Definitions:

Controlled Processes

Tasks that require active and conscious effort and attention, such as learning something new.

Consciousness

An individual’s awareness of external events and internal sensations under a condition of arousal, including awareness of the self and thoughts about one’s experiences.

Awareness

The ability to perceive, feel, or be conscious of events, objects, or sensory patterns.

Arousal

A physiological and psychological state of being awake or reactive to stimuli.