X11 supplied Imber or components produced in Plant 1 Store A X12 = number of components...

Transcribed Image Text:

X11 supplied Imber or components produced in Plant 1 Store A X12 = number of components produced in Plant 1 and supplied to Store B X13 = number of components produced in Plant 1 and supplied to Store C X21 = number of components produced in Plant 2 and supplied to Store A X22 = number of components produced in Plant 2 and supplied to Store B X23 = number of components produced in Plant 2 and supplied to Store C X31 = number of components produced in Plant 3 and supplied to Store A X32 = number of components produced in Plant 3 and supplied to Store B X33 = number of components produced in Plant 3 and supplied to Store C 5.50 X11 + Min 2.40 Ox22 + 4.60 X33 3.30X12+ 1.20 X13 + 5.80 X21+ + 2.50 X23+ 2.90 X31 + 1.70 X32 + Subject to the constraints > 320 1 X11 + 1 X12 + X13 s 720 1 X21 + 1 x22 + 1 X23 s 510 1 X31 + X32+ X33 X11+ 1 X21+ X31= 790 160 1 X12+ 1 X22+ X32= 540 113+ 1 X23+ 1 X33 X11, X12, X13, X21, X22, X23, X31, X32, X33 0 What is the value of total distribution costs at the optimal solution? Use the Excel solver to find the optimal solution. Round your answer to the nearest dollar. +A 1,600 X11 supplied Imber or components produced in Plant 1 Store A X12 = number of components produced in Plant 1 and supplied to Store B X13 = number of components produced in Plant 1 and supplied to Store C X21 = number of components produced in Plant 2 and supplied to Store A X22 = number of components produced in Plant 2 and supplied to Store B X23 = number of components produced in Plant 2 and supplied to Store C X31 = number of components produced in Plant 3 and supplied to Store A X32 = number of components produced in Plant 3 and supplied to Store B X33 = number of components produced in Plant 3 and supplied to Store C 5.50 X11 + Min 2.40 Ox22 + 4.60 X33 3.30X12+ 1.20 X13 + 5.80 X21+ + 2.50 X23+ 2.90 X31 + 1.70 X32 + Subject to the constraints > 320 1 X11 + 1 X12 + X13 s 720 1 X21 + 1 x22 + 1 X23 s 510 1 X31 + X32+ X33 X11+ 1 X21+ X31= 790 160 1 X12+ 1 X22+ X32= 540 113+ 1 X23+ 1 X33 X11, X12, X13, X21, X22, X23, X31, X32, X33 0 What is the value of total distribution costs at the optimal solution? Use the Excel solver to find the optimal solution. Round your answer to the nearest dollar. +A 1,600