Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Store A Store C $6.70 $3.30 $7.90 $7.20 $4.10 $4.60 740 400 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. If the constant is equal to one, enter "1". Let: Min 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 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 = X11 + X12 + X13 + X33 Subject to the constraints X11 + X21 + X31 + X11 + X12 + X13 + Plant 1 2 3 Demand X12 + X22 + X32 + X21 + X22 + Store B $5.20 $5.20 $7.40 290 X21 + X22 + Capacity 160 750 560 X13 -Select- X23 -Select-v X33 -Select-v X31 -Select- X32 -Select- X23 + X33 -Select- X11, X12, X13, X21, X22, X23, X31, X32, X33 2 0 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. X23 + X31 + X32 +

Store A Store C $6.70 $3.30 $7.90 $7.20 $4.10 $4.60 740 400 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. If the constant is equal to one, enter "1". Let: Min 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 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 = X11 + X12 + X13 + X33 Subject to the constraints X11 + X21 + X31 + X11 + X12 + X13 + Plant 1 2 3 Demand X12 + X22 + X32 + X21 + X22 + Store B $5.20 $5.20 $7.40 290 X21 + X22 + Capacity 160 750 560 X13 -Select- X23 -Select-v X33 -Select-v X31 -Select- X32 -Select- X23 + X33 -Select- X11, X12, X13, X21, X22, X23, X31, X32, X33 2 0 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. X23 + X31 + X32 +

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 30P: A company manufacturers a product in the United States and sells it in England. The unit cost of...
See similar textbooks
icon
Related questions
Question
Let: Min Store A Store C $6.70 $3.30 $7.90 $7.20 $4.10 $4.60 740 400 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. If the constant is equal to one, enter "1". X33 D 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 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 X11 + X12 + X13 + Subject to the constraints Plant 1 2 3 Demand X11 + X21 + X31 + X11 + X12 + X13 + Store B $5.20 $5.20 $7.40 290 X21 + Capacity 160 750 560 X22 + X23 + X31 + X12 + X13 -Select- v X22 + X23 -Select- X32 + X33 -Select- v X21 + X31 -Select- v X22 + X32 -Select- v X23 + X33 -Select- v X11, X12, X13, X21, X22, X23, X31, X32, X33 ≥ 0 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 +
Transcribed Image Text:Let: Min Store A Store C $6.70 $3.30 $7.90 $7.20 $4.10 $4.60 740 400 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. If the constant is equal to one, enter "1". X33 D 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 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 X11 + X12 + X13 + Subject to the constraints Plant 1 2 3 Demand X11 + X21 + X31 + X11 + X12 + X13 + Store B $5.20 $5.20 $7.40 290 X21 + Capacity 160 750 560 X22 + X23 + X31 + X12 + X13 -Select- v X22 + X23 -Select- X32 + X33 -Select- v X21 + X31 -Select- v X22 + X32 -Select- v X23 + X33 -Select- v X11, X12, X13, X21, X22, X23, X31, X32, X33 ≥ 0 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 +
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 8 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer