<. FROM T. I 13 Paragraph Styles A company produces its automobile model in three plants located in Flint, Michigan; Fresno, California; and Monterrey, Mexico. The cars are distributed to dealers through the regional distribution centers located in Phoenix, Arizona; Davenport, Iowa; and Columbia, South Carolina. Anticipated production at the plants over the next month is 3,300 cars at Flint, 2,600 cars at Fresno, and. 3,100 cars at Monterrey. Based on firm orders and other requests from dealers, the company has decided that it needs to have the following numbers of cars at the regional distribution centers at the end of the month: Phoenix - 2,600 cars; Davenport- 2,800 cars; and Columbia – 3,000 cars. | In order to deal more effectively with unforeseen events (such as the road closing), the company has established two transshipment points between the plants and the regional distribution centers. The two transshipment points are located at Santa Fe, New Mexico, and Jefferson City, Missouri. The costs of shipping one car to from one node to another node in the transshipment network are given in the table below. Use an LP solver to find the optimal flow of cars through the transshipment network that minimizes the total shipping costs. TO Phoenix Santa Fe Jefferson Davenport Columbia City $ 120 $ 70 $ 180 Flint $ 80 2480 $170 09 $ 09 $ 06 06 $ $ 140 $ 210 $ 310 $ 100 Fresno 24140 $ 220 $ 80 $ 50 Santa Fe %2430 Jefferson City 2450 06 $ y: Investigate P.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
<.
FROM
T.
I 13
Paragraph
Styles
A company produces its automobile model in three plants located in Flint, Michigan; Fresno, California; and
Monterrey, Mexico. The cars are distributed to dealers through the regional distribution centers located in
Phoenix, Arizona; Davenport, Iowa; and Columbia, South Carolina.
Anticipated production at the plants over the next month is 3,300 cars at Flint, 2,600 cars at Fresno, and. 3,100
cars at Monterrey. Based on firm orders and other requests from dealers, the company has decided that it needs
to have the following numbers of cars at the regional distribution centers at the end of the month: Phoenix -
2,600 cars; Davenport- 2,800 cars; and Columbia – 3,000 cars.
|
In order to deal more effectively with unforeseen events (such as the road closing), the company has
established two transshipment points between the plants and the regional distribution centers. The two
transshipment points are located at Santa Fe, New Mexico, and Jefferson City, Missouri. The costs of shipping
one car to from one node to another node in the transshipment network are given in the table below. Use an LP
solver to find the optimal flow of cars through the transshipment network that minimizes the total
shipping costs.
TO
Phoenix
Santa Fe
Jefferson
Davenport
Columbia
City
$ 120
$ 70
$ 180
Flint
$ 80
2480
$170
09 $
09 $
06
06 $
$ 140
$ 210
$ 310
$ 100
Fresno
24140
$ 220
$ 80
$ 50
Santa Fe
%2430
Jefferson City
2450
06 $
y: Investigate
P.
Transcribed Image Text:<. FROM T. I 13 Paragraph Styles A company produces its automobile model in three plants located in Flint, Michigan; Fresno, California; and Monterrey, Mexico. The cars are distributed to dealers through the regional distribution centers located in Phoenix, Arizona; Davenport, Iowa; and Columbia, South Carolina. Anticipated production at the plants over the next month is 3,300 cars at Flint, 2,600 cars at Fresno, and. 3,100 cars at Monterrey. Based on firm orders and other requests from dealers, the company has decided that it needs to have the following numbers of cars at the regional distribution centers at the end of the month: Phoenix - 2,600 cars; Davenport- 2,800 cars; and Columbia – 3,000 cars. | In order to deal more effectively with unforeseen events (such as the road closing), the company has established two transshipment points between the plants and the regional distribution centers. The two transshipment points are located at Santa Fe, New Mexico, and Jefferson City, Missouri. The costs of shipping one car to from one node to another node in the transshipment network are given in the table below. Use an LP solver to find the optimal flow of cars through the transshipment network that minimizes the total shipping costs. TO Phoenix Santa Fe Jefferson Davenport Columbia City $ 120 $ 70 $ 180 Flint $ 80 2480 $170 09 $ 09 $ 06 06 $ $ 140 $ 210 $ 310 $ 100 Fresno 24140 $ 220 $ 80 $ 50 Santa Fe %2430 Jefferson City 2450 06 $ y: Investigate P.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

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,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.