1 General Ford produces cars at L.A. and Detroit and has a warehouse in Atlanta; the company supplies cars to customers in Houston and Tampa. The cost of shipping a car between points is given in Table 60 ("-" means that a shipment is not allowed). L.A. can produce as many as 1,100 cars, and Detroit can produce as many as 2,900 cars. Houston must receive 2,400 cars, and Tampa must receive 1,500 cars. a Formulate a balanced transportation problem that can be used to minimize the shipping costs incurred in meeting demands at Houston and Tampa. b Modify the answer to part (a) if shipments between L.A. and Detroit are not allowed. c Modify the answer to part (a) if shipments between Houston and Tampa are allowed at a cost of $5.
1 General Ford produces cars at L.A. and Detroit and has a warehouse in Atlanta; the company supplies cars to customers in Houston and Tampa. The cost of shipping a car between points is given in Table 60 ("-" means that a shipment is not allowed). L.A. can produce as many as 1,100 cars, and Detroit can produce as many as 2,900 cars. Houston must receive 2,400 cars, and Tampa must receive 1,500 cars. a Formulate a balanced transportation problem that can be used to minimize the shipping costs incurred in meeting demands at Houston and Tampa. b Modify the answer to part (a) if shipments between L.A. and Detroit are not allowed. c Modify the answer to part (a) if shipments between Houston and Tampa are allowed at a cost of $5.
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...
Related questions
Question

Transcribed Image Text:TABLE 60
To (S)
From
L.A.
Detroit
Atlanta
Houston
Tampa
L.A.
140
100
90
225
Detroit
145
111
110
119
Atlanta
105
115
113
78
Houston
89
109
121
Tampa
210
117
82

Transcribed Image Text:1 General Ford produces cars at L.A. and Detroit and has
a warehouse in Atlanta; the company supplies cars to
customers in Houston and Tampa. The cost of shipping a car
between points is given in Table 60 ("-" means that a
shipment is not allowed). L.A. can produce as many as
1,100 cars, and Detroit can produce as many as 2,900 cars.
Houston must receive 2,400 cars, and Tampa must receive
1,500 cars.
a Formulate a balanced transportation problem that
can be used to minimize the shipping costs incurred in
meeting demands at Houston and Tampa.
b Modify the answer to part (a) if shipments between
L.A. and Detroit are not allowed.
c Modify the answer to part (a) if shipments between
Houston and Tampa are allowed at a cost of $5.
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 3 steps with 3 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.