Problem 11-13

Hi can you please help me solve this using Excel? Thanks!

network representation of the potential Martin-Beck supply chain is shown in figure below. THE NETWORK REPRESENTATION OF THE MARTIN-BECK COMPANY SUPPLY CHAIN DESIGN PROBLEM Let y1=1 if a plant is constructed in Detroit; 0 if not y2=1 if a plant is constructed in Toledo; 0 if not y3=1 if a plant is constuct in Dever 0 in not y4=1 if a plant is constructed in Kansas City; 0 if not xij= the units shipped in thousands from plant i to distribution center j i=1,2,3,4,5, and j=1,2,3 in which you must enter subtractive or negative numbers use a minus sign. (Example: -300) Let y1=1 if a plant is constructed in Detroit; 0 if not y2=1 if a plant is constructed in Toledo; 0 if not y3=1 if a plant is constructed in Denver; 0 if not y4=1 if a plant is constructed in Kansas City; 0 if not xij= the units shipped in thousands from plant i to distribution center j i=1,2,3,4,5,andj=1,2,3 The shipping cost per unit from each plant to each distribution center is shown in table below. SHIPPING COST PER UNIT FOR THE MARTIN-BECK SUPPLY CHAIN