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 (600)

Black Forest (300)

Cimmaron (200)

Knob Hills (500)

There are three locations for the fair (with capacity)

Air Force Academy (1000)

UCCS (1500)

EPCC (1500)

The respective transportation cost $ per student is given as follows:

	Air Force Academy	UCCS	EPCC
Monument	5	7	6
Austin	5	3	7
Black Forest	8	5	5
Cimmaron	9	6	5
Knob Hills	7	6	6

Part A.

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 to the pandemic, UCCS 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.