You have been asked to plan for the cost-optimal fulfillment of demand at four cities in Africa-Johannesberg, Lusaka, Mombasa, and Nairobi. The relevant costs and demand (in kilograms) are shown in the table to your left.

1. In the box to your right of the constraint

Please explain the function of each of the following constraints

in the Solver model (10 POINTS EACH)

Constraint

$C22:$F22=0

$C26:$C29>=0

$G17:$G20=BINARY

$G6:$G9>=$H17:$H20

If you fulfill the given demands under these constraints

what is the lowest cost you will incur? (10 POINTS)

Transportation Cost per kg
	To
From	Johannesberg	Lusaka	Mombasa	Nairobi	Capacity	Fixed Cost
Johannesberg	1	4.5	8.5	9.5	40000	90000
Lusaka	3.5	1	6.5	6.85	10000	65000
Mombasa	8.25	7.85	1	2	15000	80000
Nairobi	8.75	7.15	2.25	1	25000	75000
Demand	30000	15000	20000	25000
Decision Variables
Flows	To				Location
From	Johannesberg	Lusaka	Mombasa	Nairobi	Open/close	Total
Johannesberg	0	0	0	0	0	0
Lusaka	0	0	0	0	0	0
Mombasa	0	0	0	0	0	0
Nairobi	0	0	0	0	0	0
Total	0	0	0	0	0	0
Unmet Demand	30000	15000	20000	25000
Unused Capacity
Johannesberg	0
Lusaka	0
Mombasa	0
Nairobi	0
TOTAL COST
Fixed	0
Variable	0
Total	0