Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. advance math
  3. general ford produces cars in los angeles and detr

General Ford produces cars in Los Angeles and Detroit and has a warehouse in Atlanta. The...

80.2K

Verified Solution

Question

Advance Math

General Ford produces cars in Los Angeles and Detroit and has awarehouse in Atlanta. The company supplies cars to customers inHouston and Tampa. The costs of shipping a car between variouspoints are listed in the file P05_54.xlsx, where a blank means thata shipment is not allowed. Los Angeles can produce up to 1600 cars,and Detroit can produce up to 3200 cars. Houston must receive 1800cars, and Tampa must receive 2900 cars. a. Determine how tominimize the cost of meeting demands in Houston and Tampa. b.Modify the answer to part a if no shipments through Atlanta areallowed.

unit shipping cost
to
LADetroitAtlantaHoustonTampa
fromLA$97$95$125$156
Detroit$94$103$110$148
Atlanta$87$100$95$56
Houston$129$103$88$100
Tampa$147$145$60$103
network formulationflow balance contraints
origindestinationcostflowlocationindexnet flow in/outRequired
12$97LA1<=
13$95Detroit2<=
14$125Atlanta3=
15$156Houston4=
21$94Tampa5=
23$103
24$110
25$148
31$87
32$100
34$95
35$56
41$129
42$103
43$88
45$100
51$147
52$145
53$60
54$103

total cost

Answer & Explanation Solved by verified expert
3.7 Ratings (591 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Geometry
1.2K views

Day 5 Use the figure to complete the proportions 1 3 EF BA FG 5...

Psychology
1.2K views

1. What is the first step of substance abuse treatment? 2. Explain the difference between the...

Physics
1.2K views

One end of a long metallic wire of length L is tied to the ceiling...

Basic Math
1.2K views

Rewrite the following in the form of a single exponential 73 74

Basic Math
1.2K views

Find if possible AB and BA If not possible enter IMPOSSIBLE in any single cell...

Accounting
1.2K views

Laurel Inc. entered into a 4-year lease agreement for equipment requiring $8,000 annual payments, with...

Accounting
1.2K views

Marcus invested $215,000 to purchase a home. After 10 years, he sold the home for...

Accounting
1.2K views

Cash Inc. reports warranty expense when related products are sold. For tax purposes, the warranty...

Accounting
1.2K views

The Cutting Department of Cassel Company has the following production and cost data for July....

Accounting
1.2K views

Defend the cost of rebranding the company and funding an advertising campaign?

Accounting
1.2K views

A retailer has a perpetual inventory system. The payment of a $2,000 inventory purchase within...

Accounting
1.2K views

Comprehensive Ratio Analysis Tuxedo Corporation's condensed comparative income statements and balance sheets follow. All figures...