Rent'R Cars is a multisite car rental company in the city. It istrying out a new \"return the car to the location most convenientfor you\" policy to improve customer service. But this means thatthe company has to constantly move cars around the city to maintainrequired levels of vehicle availability. The supply and demand foreconomy cars, and the total cost of moving these vehicles betweensites, are shown below.
| From\To | D | E | F | G | Supply |
| A | | $15 | | $16 | | $14 | | $6 | 70 |
| | | | | | | | | |
| B | | 8 | | 7 | | 13 | | 6 | 35 |
| | | | | | | | | |
| C | | 14 | | 9 | | 15 | | 12 | 100 |
| | | | | | | | | |
| Demand | | 55 | | 60 | | 50 | | 40 | 205\205 |
|
a. Find the solution that minimizes moving costsusing Microsoft Excel. (Leave no cells blank - be certainto enter \"0\" wherever required.)
|
| | From/To | D | E | F | G | Supply | | Candidate solution | | | | | | | A | | | | | | | B | | | | | | | C | | | | | | | Total shipped | | | | | | | Cost | | | | | | | A | | | | | | | B | | | | | | | C | | | | | | | Total costs | | | | | |
|
