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