Hints) Check My Work 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 fram below. Plant Store A Store B Store C Capacity 1 $2.60 $4.70 $5.00 650 2 $4.30 $3.30 $7.20 440 3 Demand $2.70 510 $6.40 250 $3.90 590 270 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 distribution costs. If the constant is Let Mr Xis number of components produced in Plant 1 and supplied to Store A X13 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 Xas 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 Xas number of components produced in Plant 2 and supplied to Store C Xas number of components produced in Plant 3 and supplied to Store A Xs2 number of components produced in Plant 3 and suppled to Store B Xa number of components produced in Plant 3 and supplied to Store C Subject to the constraints X Xzs Xzz x+ Xx Xa XAS Xa Xa X Xa Xu Xxx Xa X31