7-12.
Let Aj, Bj and Cj the shipments from warehouse A, B and C to
customer j and YA, YB, and YC zero/one switch variables denoting
whether warehouse A, B, and C will be used. Since warehouses can be assumed to have unlimited capacity, for modeling purposes
we might consider the capcities (if operated) to be equal to the total demand, the most that might ever be shipped from a single warehouse.
MIN 15A1 + 32A2 + 21A3 + 9B1 + 7B2 + 6B3 + 11C1 + 18C2
+ 5C3 + 5000YA + 750YB + 600YC
SUBJECT TO
A1 + B1 + C1 >= 200
A2 + B2 + C2 >= 150
A3 + B3 + C3 >= 175
A1 + A2 + A3 <= 525YA
B1 + B2 + B3 <= 525YB
C1 + C2 + C3 <= 525YC
YA + YB + YC >= 2
Aj, Bj, Cj>=0, YA, YB, YC =0,1
Excel solution
[go to top]
[Any questions?]