Edison Electric Auto (EEA) has three plants in San Jose, Detroit, and New Orleans, and three major
Question:
Edison Electric Auto (EEA) has three plants in San Jose, Detroit, and New Orleans, and three major distribution centers in Denver, Miami, and Norfolk. The quarterly capacities of the three plants are 1500, 2000, and 1800 cars, and the demands at the three distribution centers for the same period are 2200, 1200, and 1700 cars. The mileage chart between the plants and the distribution centers is given in the following table.
The trucking company in charge of transporting the cars charges 13 cents per mile per car. EEA wants to find an optimal transportation plan.
1) Compute the transportation costs per car on the different routes?
2) Formulate the problem as a transportation problem.
3) Solve the transportation problem using Excel solver.
Business Law and the Legal Environment
ISBN: 978-1285860381
7th edition
Authors: Susan S. Samuelson, Jeffrey F. Beatty