Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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

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
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
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
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.
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
SEE MORE TEXTBOOKS