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?]