A Company Needs to Ship 100 Units from Seattle to Denver

Essay

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: