Tobacco is purchased by Cooperative Tobacco Farmers, Inc., is stored in warehous
ID: 2258789 • Letter: T
Question
Tobacco is purchased by Cooperative Tobacco Farmers, Inc., is stored in warehouses in four cities at the end of each season.
Location
Capacity (tons)
Charlotte
90
Raleigh
50
Lexington
80
Danville
60
280
These warehouses supply the following amounts of tobacco to companies in the following three cities:
Plant
Demand (tons)
Richmond
120
Winston-Salem
100
Durham
110
330
The railroad shipping costs per ton are as follows:
To
Richmond
Winston-Salem
Durham
Charlotte
$70
100
50
Raleigh
120
90
40
Lexington
70
30
110
Danville
90
50
70
a) Cooperative Tobacco Farmers wants to determine what amounts of tobacco should be shipped from the warehouses to the tobacco plants at the least total cost.
b) Because of railroad construction, shipments are presently prohibited from Charlotte to Richmond. How should Cooperative Tobacco Farmers adjust their shipping plans and still minimize cost?
Can you show your excel work and equations so I can see how you got what you got please?
Location
Capacity (tons)
Charlotte
90
Raleigh
50
Lexington
80
Danville
60
280
Explanation / Answer
a Location Capacity (tons) Plant Demand (tons) Charlotte 90 Richmond 120 Raleigh 50 Winston-Salem 100 Lexington 80 Durham 110 Danville 60 330 280 Cost matrix From/To Richmond Winston-Salem Durham Charlotte 70 100 50 Raleigh 120 90 40 Lexington 70 30 110 Danville 90 50 70 Decision variable matrix - How much to be shipped from which warehouse to which plant From/To Richmond Winston-Salem Durham Charlotte 30 0 60 Raleigh 0 0 50 Lexington 40 40 0 Danville 0 60 0 Capacity constraints Charlotte 90 = 90 Raleigh 50 = 50 Lexington 80 = 80 Danville 60 = 60 Demand Constraint Richmond 70Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.