Chapter 06 Homework: Supply Chain Design Hint(6) Check My Work 7. 8. Milford Lumber Company ships construction materials from three wood-processing plants to three retail stores. The shipping cost, monthly production capacities, demand for framing lumber are given below. Plant Store A Store B Store C Capacity 1 $7.30 $6.80 $6.10 610 2 $4.60 $9.00 $8.30 580 3 $8.10 $8.20 $5.80 230 Demand 430 310 620 Formulate a linear optimization model for this problem, implement your model on a spredsheet, and use Excel Solver to find a solution that minimizes total distri the constant is equal to one, enter "1" Leti 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 X13 - number components produced in Plant 1 and supplied to store C X1 number of components produced in Plant 2 and supplied to Store A Xu - number of components produced in Plant 2 and supplied to store X number of components produced in Plant 2 and supplied to Store Xumber of components produced in Plant 3 and supplied to Store A X = number of components produced in Plant and supplied to Store X3 - number of components produced in Plant 3 and supplied to store C Mini u 13 21 > X Subject to the constraints Balet 11 12 Xu 21 XH Set