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 frami below. Let: Plant Store C 1 Store B $3.30 $2.40 $1.20 2 $2.50 3 $1.70 $4.60 Demand 160 540 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 "1". 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 Xz2 = 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 X12+ X13+ Min X11+ Subject to the constraints X11+ | X11 X12+ X13 X12 X21+ X13 X21+ Store A $5.50 $5.80 $2.90 790 X21 X22+ X22+ X23+ Capacity 320 720 510 X23 X31+ X22 + X23 X11, X12, X13, X21, X22, X23, X31, X32, X33 20 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. X31+ X31 + X32+ X32+ X32 + X33 -Sel -Sel X33 -Sel -Sel -Sel X33 -Sel
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 frami below. Let: Plant Store C 1 Store B $3.30 $2.40 $1.20 2 $2.50 3 $1.70 $4.60 Demand 160 540 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 "1". 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 Xz2 = 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 X12+ X13+ Min X11+ Subject to the constraints X11+ | X11 X12+ X13 X12 X21+ X13 X21+ Store A $5.50 $5.80 $2.90 790 X21 X22+ X22+ X23+ Capacity 320 720 510 X23 X31+ X22 + X23 X11, X12, X13, X21, X22, X23, X31, X32, X33 20 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. X31+ X31 + X32+ X32+ X32 + X33 -Sel -Sel X33 -Sel -Sel -Sel X33 -Sel
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter8: Evolutionary Solver: An Alternative Optimization Procedure
Section8.6: Fitting An S-shaped Curve
Problem 12P
Related questions
Question
Please do fast
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,