Problem 4: 10 points Milford Lumber Company ships construction materials from three wood-processing plants to stores. The shipping cost, monthly production capacities, and monthly demand for framing l given below and in the supplement Excel file. 0 Origin Nodes Plant 1 Plant 2 Plant 3 Store Demand Store A $7.30 $4.60 $8.10 190 Cost Matrix Destination Nodes Store B Store C $6.80 $6.10 $9.00 $8.30 $8.20 $5.80 400 470 Plant Capacity 510 290 320 Formulate a linear optimization model for this problem, implement your model on a spreadsheet, and use Excel Solver to find a solution that minimizes total distribution costs. See Supplement E for a discussion of modeling and solving transportation problems. Clarify your constro like slide 30

Problem 4: 10 points Milford Lumber Company ships construction materials from three wood-processing plants stores. The shipping cost, monthly production capacities, and monthly demand for framing given below and in the supplement Excel file. Formulate a linear optimization model for this problem, implement your model on a spreadsheet, and use Excel Solver to find a solution that minimizes total distribution costs. See Supplement E for a discussion of modeling and solving transportation problems. Clarify your constr like slide 30