Problem 6-42 Algo (Supply Chain Optimization) Question 4 Check My Wo Milford Lumber Company ships construction materials from three wood-processing plants to three retail stores. The shipping cost, monthly production capacities, and monthly demand for fremning lumber are given below. Plant Store A Store B Store C Capacity 1 $7.30 $6.80 $6.10 510 2 $4.60 $9.00 $9.30 290 3 $9.10 $8.20 $5.80 320 Demand 190 400 470 Formulate a linear optimization madel for this problem, implement your model on a spredsheet, and use Excel Salver to find a solution that minimizes total distribution costs. If the constant is equal to one, enter "1". Let: X11 = number of components produced in Plant 1 and supplied to 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 Min X11+ X12+ X13+ X21+ X22+ X23+ X31+ X32+ X33 Subject to the constraints X11+ X12+ X13 -Select- X21+ + X22+ X23 -Select- X31+ X32+ X33 -Select- X11 + X21 + X 31 -Select- X12 + + X32 -Select- X13 + X23 + X33 -Select- X11, X12, X13, X21, 22, 23, X31, X32, X330 , , , 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 $ X22 Check My Wo