A Company Needs to Ship 100 Units from Seattle to Denver

question 7

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:
$\quad$$\quad$$\quad$$\quad$$\quad$$\quad$$\quad$$\quad$$\quad$$\quad$$\quad$$\underline{\text { \quad\quad\quad\quad\quad\quad\quad\quad\quad To\quad\quad\quad\quad\quad}}$
$\begin{array}{lcccc}\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 should go into cells G6:L13 in the following Excel spreadsheet?

---

Definitions:

File

A tool used to remove fine amounts of material from a workpiece, typically made of hardened steel with a series of ridges or teeth.

Impact Socket

A type of socket made from more durable materials designed to withstand the high torque produced by impact wrenches.

Deep Well

A type of well that is constructed at a considerable depth to access groundwater in aquifers.

Air Gun

A tool that uses compressed air to project a forceful stream or projectile, often used for cleaning or in pneumatic tools.