A company needs to ship 100 units from Seattle to Denver at the lowest possible cost.The costs associated with shipping between the cities are:
To
$$\begin{array} { l c c c c }
\text { From } & \text { Portland } & \text { Spokane } & \text { Salt Lake City } & \text { Denver } \
\hline \text { Seattle } & 100 & 500 & 600 & - \
\text { Portland } & - & 350 & 300 & - \
\text { Spokane } & - & - & 250 & 200 \
\text { Salt Lake City } & - & - & - & 200
\end{array}$$
What values would you enter in the Analytic Solver Platform task pane for the following Excel spreadsheet? Objective Cell:
Variables Cells: Constraints Cells:

Question

A company needs to ship 100 units from Seattle to Denver at the lowest possible cost.The costs associated with shipping between the cities are:
To
 $$\begin{array} { l c c c c } 
\text { From } & \text { Portland } & \text { Spokane } & \text { Salt Lake City } & \text { Denver } \
\hline \text { Seattle } & 100 & 500 & 600 & - \
\text { Portland } & - & 350 & 300 & - \
\text { Spokane } & - & - & 250 & 200 \
\text { Salt Lake City } & - & - & - & 200
\end{array}$$ 
What values would you enter in the Analytic Solver Platform task pane for the following Excel spreadsheet? Objective Cell:
Variables Cells: Constraints Cells:

Quizplus · Accepted Answer

The Answer of A company needs to ship 100 units from Seattle to Denver at the lowest possible cost.The costs associated with shipping between the cities are:
To
 $$\begin{array} { l c c c c } 
\text { From } & \text { Portland } & \text { Spokane } & \text { Salt Lake City } & \text { Denver } \
\hline \text { Seattle } & 100 & 500 & 600 & - \
\text { Portland } & - & 350 & 300 & - \
\text { Spokane } & - & - & 250 & 200 \
\text { Salt Lake City } & - & - & - & 200
\end{array}$$ 
What values would you enter in the Analytic Solver Platform task pane for the following Excel spreadsheet? Objective Cell:
Variables Cells: Constraints Cells:

A Company Needs to Ship 100 Units from Seattle to Denver