Question

Food orders are produced at three locations on the SFU Burnaby campus: West Mall, Student Services (Maggie Benston) Building, and East Concourse.

• There are two primary clusters of delivery demand: AQ and Residences.

• Delivering orders requires time during which the food loses freshness so the total should be minimized.

• Below are the average monthly demand for orders, the maximum production capacity, and the delivery time per order

demand	food orders
AQ	40
residences	20
production capacity (max)
West mall	10
Maggie Benston	2
East Concourse	60

From	AQ	Residences
West mall	10	3
Maggie Benston	5	12
East Concourse	2	12

Step 1. Draw a simple transportation network diagram of the problem showing nodes, arcs, and quantities.

Step 2. Construct a formulation in the space below showing objective function and all constraints. Align decision variables in vertical columns.

Step 3. Use Excel’s Solver to optimize allocation of order delivery routes and report values of all six decision variables

From	AQ	Residences	Flow out
West mall	?	?	?
student services	?	?	?
East concourse	?	?	?
Flow in	?	?

Step 4. Is there an alternate optimal solution available? What indicates whether an alternate solution exists or not?

Answer 1

The formulation is in the colored region.

The Solver's parameter is:

The solution is:

There is no alternative solution to this problem.