O General Ford has two plants, two warehouses, and thre ustomers. The locations of these are as follows: Plants: Detroit and Atlanta Warehouses: Denver and New York Customers: Los Angeles, Chicago, and Philadelphia Cars are produccd at plants, then shipped to warehouses, and finally shipped to customers. Detroit can produce 150

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
Please do the linear programming and solve by MS excel for me
Home
Insert
Page Layout
Formulas
Data
Review
Vie
- Là From Text/CSV
LO Recent Sources
Queries & Connec
eFrom Web
et
From Table/Range
EProperties
A Edit Links
E Existing Connections
Refresh
a
All -
Get & Transform Data
Queries & Connections
fx
D
E
F
H.
I
shipping costs
Denver
New York Los Angeles
Chicago
Philadelphia
Dummy
optimal Target
Detroit
Atlanta
Denver
New York
Denver
New York Los Angeles
Chicago
Philadelphia
Dummy
Supply
uns
Detroit
150
Atlanta
100
Denver
250
New York
250
sum
Demand
250
250
so
70
60
40
ข้อที่3
Problem 22
Ready
Transcribed Image Text:Home Insert Page Layout Formulas Data Review Vie - Là From Text/CSV LO Recent Sources Queries & Connec eFrom Web et From Table/Range EProperties A Edit Links E Existing Connections Refresh a All - Get & Transform Data Queries & Connections fx D E F H. I shipping costs Denver New York Los Angeles Chicago Philadelphia Dummy optimal Target Detroit Atlanta Denver New York Denver New York Los Angeles Chicago Philadelphia Dummy Supply uns Detroit 150 Atlanta 100 Denver 250 New York 250 sum Demand 250 250 so 70 60 40 ข้อที่3 Problem 22 Ready
General Ford has two plants, two warehouses, and three
customers. The locations of these are as follows:
Plants: Detroit and Atlanta
Warehouses: Denver and New York
Customers: Los Angeles, Chicago, and Philadelphia
Cars are produced at plants, then shipped to warehouses,
and finally shipped to customers. Detroit can produce 150
cars per week, and Atlanta can produce 100 cars per week.
Los Angeles requires 80 cars per week; Chicago, 70; and
Philadelphia, 60. It costs $10,000 to produce a car at each
plant, and the cost of shipping a car between two cities is
given in Table 62. Determine how to meet General Ford's
weekly demands at minimum cost.
TABLE 62
To (S)
From
Denver
New York
Detroit
1,253
637
Atlanta
1,398
841
To ($)
From
Los Angeles
Chicago
Philadelphia
Denver
1,059
996
1,691
New York
2,786
802
100
Transcribed Image Text:General Ford has two plants, two warehouses, and three customers. The locations of these are as follows: Plants: Detroit and Atlanta Warehouses: Denver and New York Customers: Los Angeles, Chicago, and Philadelphia Cars are produced at plants, then shipped to warehouses, and finally shipped to customers. Detroit can produce 150 cars per week, and Atlanta can produce 100 cars per week. Los Angeles requires 80 cars per week; Chicago, 70; and Philadelphia, 60. It costs $10,000 to produce a car at each plant, and the cost of shipping a car between two cities is given in Table 62. Determine how to meet General Ford's weekly demands at minimum cost. TABLE 62 To (S) From Denver New York Detroit 1,253 637 Atlanta 1,398 841 To ($) From Los Angeles Chicago Philadelphia Denver 1,059 996 1,691 New York 2,786 802 100
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
LUP Decomposition
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education