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 AcademyUCCSPPSCMonument576Austin Bluffs537Black Forest855Cimmaron965Knob Hills766

Please read pages 320-322 (Chapter/section 9.1) of the textbook.

Part A.

Hand written:

1. 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

1. Identification of the correct variables (including labeling).
2. Use solver to come up with the optimal transportation plan and provide a cost.
3. Correct answer with units and/or explanation.
4. Spreadsheet clarity/color/ease of understanding
5. Spreadsheet use of spreadsheet functionality rather than typing the answer in.
6. Spreadsheet separation of input variables from output variables.

Part B. Due 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.