25. (8 pts) Business Optimization Question A rent a car company wishes to minimize the cost of moving cars from where th
Posted: Thu May 05, 2022 9:16 am
Please show excel work
25. (8 pts) Business Optimization Question A rent a car company wishes to minimize the cost of moving cars from where they are dropped to where they are needed. The supply of cars at 3 locations, the demands at 4 locations, and the costs of moving one car between each location is shown below. How many cars should be moved between each origin and destination to minimize total transportation costs? Origin Destination D E F G Supply A B C Demand 5 9 5 50 8 6 6 60 6 8 3 25 5 0 10 30 50 40 75
25. (8 pts) Business Optimization Question A rent a car company wishes to minimize the cost of moving cars from where they are dropped to where they are needed. The supply of cars at 3 locations, the demands at 4 locations, and the costs of moving one car between each location is shown below. How many cars should be moved between each origin and destination to minimize total transportation costs? Origin Destination D E F G Supply A B C Demand 5 9 5 50 8 6 6 60 6 8 3 25 5 0 10 30 50 40 75