Milford Lumber Company ships construction materials from three wood-processing plants to three retail stores. The shipping cost, monthly production capacites, and monthly demand for framing lumber are given below.

Milford Lumber Company ships construction materlals from three wood-processing plants to three retail stores. The shipping cost, monthly production capoclties, and monthly demand for framing lumber are given below. Formulate a linear optimization model for this problem, implement your model on a spreadsheet, and use Excel Solver to find a solution that minimizes tot 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 producad 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 Subject to the constraints 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. Milford Lumber Company ships construction materlals from three wood-processing plants to three retail stores. The shipping cost, monthly production capoclties, and monthly demand for framing lumber are given below. Formulate a linear optimization model for this problem, implement your model on a spreadsheet, and use Excel Solver to find a solution that minimizes tot 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 producad 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 Subject to the constraints 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