A food distribution company ships fresh spinach from its four packing plants to large East-coast cities. The shipping costs per crate, the supply and demand are shown in the table at the bottom of this page.
(a) Formulate a model that will permit the company to meet its demand at the lowest possible cost.
(b) The company wishes to spread out the source for each of its markets to the maximum extent possible. To accomplish this, it will accept a 5 % increase in its total transportation cost from part (a). What is the new transportation cost, and what is the new cost?
Markets
Packing
Plants Atlanta Boston Charlestown Dover Supply
Eaglestown $6.00 $7.00 $7.50 $7.50 8,000
Farrier $5.50 $5.50 $4.00 $7.00 10,000
Guyton $6.00 $5.00 $6.50 $7.00 5,000
Hayesville $7.00 $7.50 $8.50 $6.50 9,000
Demand 8,000 9,000 10,000 5,000
5-26 A trauma center keeps ambulances at locations throughout the east side of a city in an attempt to minimize the response time in the event of an emergency. The times, in minutes, from the ambulance locations to the population centers are given in the table at the top of the next column.
POPULATION
AMBULANCE
LOCATIONS EAST NORTH-EAST SOUTH-EAST CENTRAL
SITE 1 12 8 9 13
SITE 2 10 9 11 10
SITE 3 11 12 14 11
SITE 4 13 11 12 9
Find the optimal assignment of ambulances to population centers that will minimize the total emergency response time.
5-30 The city of Six Mile, South Carolina, is considering making several of its streets one-way. What is the maximum number of cars per hour that can travel from east (node 1) to west (node 8)? The network is shown below.
Solve the given problem scenario to determine the maximum number of cars per hour that can travel from east (node 1) to west (node 8) by formulating and setting up the problem in Excel Solver.
Excel should provide clearly labeled values used for the decision variables, constraints, and objective function