Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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
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
See similar textbooks
icon
Related questions
Question
Please do fast
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 framing lun below. Let: Store C $1.20 $2.50 3 $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 equal "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 X13+ Min X11+ Subject to the constraints X11+ X11 X12+ X12+ X12 Plant 1 2 X13 X13 X21+ X21+ X21 Store A $5.50 $5.80 $2.90 790 + Store B $3.30 $2.40 $1.70 X22+ X22+ X22 X23+ + X23 Capacity 320 720 510 + X31+ X31+ X31 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. $ + X32+ X32+ X32 + X33 -Select- -Select- X33 -Select-v -Select- v -Select- v X33 -Select- v
Transcribed Image Text: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 framing lun below. Let: Store C $1.20 $2.50 3 $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 equal "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 X13+ Min X11+ Subject to the constraints X11+ X11 X12+ X12+ X12 Plant 1 2 X13 X13 X21+ X21+ X21 Store A $5.50 $5.80 $2.90 790 + Store B $3.30 $2.40 $1.70 X22+ X22+ X22 X23+ + X23 Capacity 320 720 510 + X31+ X31+ X31 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. $ + X32+ X32+ X32 + X33 -Select- -Select- X33 -Select-v -Select- v -Select- v X33 -Select- v
per Company ships construction materials from three wood-processing plants to three retail stores. The shipping cost, monthly production capacities, and monthly demand for framing lumber are given Plant 1 2 Store C $1.20 $2.50 $4.60 3 Demand 160 540 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 equal to one, enter umber of components produced in Plant 1 and supplied to Store A umber of components produced in Plant 1 and supplied to Store B umber of components produced in Plant 1 and supplied to Store C umber of components produced in Plant 2 and supplied to Store A umber of components produced in Plant 2 and supplied to Store B umber of components produced in Plant 2 and supplied to Store C umber of components produced in Plant 3 and supplied to Store A humber of components produced in Plant 3 and supplied to Store B umber of components produced in Plant 3 and supplied to Store C X12+ X13+ X11+ he constraints X11+ X11 X12+ X12 X13 X21+ X13 X21+ X21 Store A $5.50 $5.80 $2.90 790 + Store B $3.30 $2.40 $1.70 X22+ X22+ X22 X23+ + Capacity 320 720 510 X23 X31+ X23 X11, X12, X13, X21, X22, X23, X31, X32, X33 20 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 -Select- v -Select- X33 -Select-v -Select- -Select- X33 -Select- v
Transcribed Image Text:per Company ships construction materials from three wood-processing plants to three retail stores. The shipping cost, monthly production capacities, and monthly demand for framing lumber are given Plant 1 2 Store C $1.20 $2.50 $4.60 3 Demand 160 540 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 equal to one, enter umber of components produced in Plant 1 and supplied to Store A umber of components produced in Plant 1 and supplied to Store B umber of components produced in Plant 1 and supplied to Store C umber of components produced in Plant 2 and supplied to Store A umber of components produced in Plant 2 and supplied to Store B umber of components produced in Plant 2 and supplied to Store C umber of components produced in Plant 3 and supplied to Store A humber of components produced in Plant 3 and supplied to Store B umber of components produced in Plant 3 and supplied to Store C X12+ X13+ X11+ he constraints X11+ X11 X12+ X12 X13 X21+ X13 X21+ X21 Store A $5.50 $5.80 $2.90 790 + Store B $3.30 $2.40 $1.70 X22+ X22+ X22 X23+ + Capacity 320 720 510 X23 X31+ X23 X11, X12, X13, X21, X22, X23, X31, X32, X33 20 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 -Select- v -Select- X33 -Select-v -Select- -Select- X33 -Select- v
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
SEE MORE TEXTBOOKS