A Company Needs to Ship 100 Units from Seattle to Denver

question 19

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:
$$\begin{array}{c}\text { 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}\end{array}$$
What values should go into cells G6:L13 in the following Excel spreadsheet?

---

Definitions:

Sales Budget

A financial plan that estimates the expected revenues from sales over a specific period.

Budgeted Accounts Receivable

The forecasted amount of money owed to a business by its customers for goods or services provided on credit.

Credit Sales

Sales for which payment is not received at the time of sale but is expected to be paid at a later date.

Budgeted Accounts Receivable

Forecasted or estimated amounts that a business expects to receive from customers for credit sales.