do the linear programming and solve by MS excel for me 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 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
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
