Please read pages $320-322($Chapter$/$section $9\mathrm{.}1)$ of the textbook.

Part A$.$

Hand written:

Formulate the problem $($do not solve$),$ which includes:

Identification of the correct variables $($including labeling$).$

Set up the objective function.

Set up the respective constraints including non$-$negativity.

Spreadsheet: USE SOLVER

Identification of the correct variables $($including labeling$).$

Use solver to come up with the optimal transportation plan and provide a cost.

Correct answer with units and$/$or explanation.

Spreadsheet $-$ clarity$/$color$/$ease of understanding

Spreadsheet $-$ use of spreadsheet functionality rather than typing the answer in$.$

Spreadsheet $-$ separation of input variables from output variables.

Part B$.$ Due a nearby grass fire, Air Force Academy will be unavailable. Reformulate the problem and solve it using Solver.

Explain how the routing has changed and what has happened to the total cost.