As part of a school science fair, students from various school districts must be

As part of a school science fair, students from various school districts must be transported to the various locations.
School districts are as follows (with the number of attendees listed by district)
Monument (400)
Austin Bluffs (600)
Black Forest (200)
Cimmaron (300)
Knob Hills (500)
There are three locations for the fair (with capacity)
Air Force Academy (1000)
UCCS (1500)
PPSC (1500)
The respective transportation cost per student is given as follows:
Air Force Academy / UCCS / PPSC /
Monument 5 / 7 / 6
Austin Bluffs 5 / 3 / 7
Black Forest 8 / 5 / 5
Cimmaron 9 / 6 / 5
Knob Hills 7 / 6 / 6
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.