FIRST SET-UP & SOLVE THE MARTIN BECK SUPPLY CHAIN PROBLEM

Min 5x11+ 2x12 +3x13 +4x21+3x22+4x23 +9x31+7x32+5x33+10x41+4x42+2x43+8x51+4x52+3x53+175y1+300y2+375y3+500y

s.t. x11+x12 +x13 <= 10y1 (Detroit capacity)

x21+x22+x23 <= 20y2 (Toledo capacity)

x31+x32+x33 <= 30y3 (Denver capacity)

x41+x42+x43 <= 40y4 (Kansas City capacity)

x51+x52+x53 <= 30 (St.Louis capacity)

x11+x21 +x31+x41+x51 = 30 (Boston demand)

x12+x22+x32+x42+x52 = 20 (Atlanta demand)

x13+x23+x33+x43+x53 = 20 (Houston demand)

xij >= for all i and j; y1, y2, y3, y4 = 0, 1

THEN USE EXCEL SOLVER TO WORK ON:

a) Modify the formulation shown in Section 11.3 to account for the policy restriction that a plant must be located either in Detroit or in Toledo, but not both.

b) Modify the formulation shown in Section 11.3 to account for the policy restriction that no more than two plants can be located in Denver, Kansas City, and St. Louis.