Excel 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.As part of a school science fair, students from various school districts must be transported to the various locations.