Question

In: Operations Management

Rent'R Cars is a multisite car rental company in the city. It is trying out a...

Rent'R Cars is a multisite car rental company in the city. It is trying out a new "return the car to the location most convenient for you" policy to improve customer service. But this means that the company has to constantly move cars around the city to maintain required levels of vehicle availability. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, are shown below.

From\To D E F G Supply
A

$10

$5

$8

$4

85
B

12

5

9

11

100
C

4

11

9

6

105
Demand 50 70 70 100 290\290


a. Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.)

From/To D E F G Supply
Candidate solution
A
B
C
Total shipped
Cost
A
B
C
Total costs $

Solutions

Expert Solution

The problem can be solved using transportation model in excel

The minimum moving cost is $1,610

Following is the detailed solution


Related Solutions

Rent'R Cars is a multisite car rental company in the city. It is trying out a...
Rent'R Cars is a multisite car rental company in the city. It is trying out a new "return the car to the location most convenient for you" policy to improve customer service. But this means that the company has to constantly move cars around the city to maintain required levels of vehicle availability. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, are shown below. From\To D E F G Supply A...
Benton is a rental car company that is trying to determine whether to add 25 cars...
Benton is a rental car company that is trying to determine whether to add 25 cars to its fleet. The company fully depreciates all its rental cars over five years using the straight-line method. The new cars are expected to generate $220,000 per year in earnings before taxes and depreciation for five years. The company is entirely financed by equity and has a 21 percent tax rate. The required return on the company’s unlevered equity is 15 percent and the...
Benton is a rental car company that is trying to determine whether to add 25 cars...
Benton is a rental car company that is trying to determine whether to add 25 cars to its fleet. The company fully depreciates all its rental cars over five years using the straight-line method. The new cars are expected to generate $195,000 per year in earnings before taxes and depreciation for five years. The company is entirely financed by equity and has a 23 percent tax rate. The required return on the company’s unlevered equity is 12 percent and the...
Benton is a rental car company that is trying to determine whether to add 25 cars...
Benton is a rental car company that is trying to determine whether to add 25 cars to its fleet. The company fully depreciates all its rental cars over four years using the straight-line method. The new cars are expected to generate $240,000 per year in earnings before taxes and depreciation for four years. The company is entirely financed by equity and has a 21 percent tax rate. The required return on the company’s unlevered equity is 11 percent and the...
Zoso is a rental car company that is trying to determine whether to add 25 cars...
Zoso is a rental car company that is trying to determine whether to add 25 cars to its fleet. The company fully depreciates all its rental cars over four years using the straight-line method. The new cars are expected to generate $145,000 per year in earnings before taxes and depreciation for four years. The company is entirely financed by equity and has a 35 percent tax rate. The required return on the company’s unlevered equity is 13 percent, and the...
Zoso is a rental car company that is trying to determine whether to add 25 cars...
Zoso is a rental car company that is trying to determine whether to add 25 cars to its fleet. The company fully depreciates all its rental cars over six years using the straight-line method. The new cars are expected to generate $160,000 per year in earnings before taxes and depreciation for six years. The company is entirely financed by equity and has a 40 percent tax rate. The required return on the company’s unlevered equity is 11 percent, and the...
Zoso is a rental car company that is trying to determine whether to add 25 cars...
Zoso is a rental car company that is trying to determine whether to add 25 cars to its fleet. The company fully depreciates all its rental cars over six years using the straight-line method. The new cars are expected to generate $160,000 per year in earnings before taxes and depreciation for six years. The company is entirely financed by equity and has a 40 percent tax rate. The required return on the company’s unlevered equity is 11 percent, and the...
Benton is a rental car company that is trying to determine whether to add 25 cars...
Benton is a rental car company that is trying to determine whether to add 25 cars to its fleet. The company fully depreciates all its rental cars over five years using the straight-line method. The new cars are expected to generate $220,000 per year in earnings before taxes and depreciation for five years. The company is entirely financed by equity and has a 21 percent tax rate. The required return on the company’s unlevered equity is 15 percent and the...
A car rental agency in a major city has a total of 4500 cars that it...
A car rental agency in a major city has a total of 4500 cars that it rents from three locations: Metropolis Airport, downtown, and the smaller City Airport. Some weekly rental and return patterns are shown in the table (note that Airport means Metropolis Airport). Rented from Returned to AP DT CA Airport (AP) 90% 10% 10% Downtown (DT) 5% 80% 5% At the beginning of a week, how many cars should be at each location so that the same...
A car rental agency in a major city has a total of 2900 cars that it...
A car rental agency in a major city has a total of 2900 cars that it rents from three locations: Metropolis Airport, downtown, and the smaller City Airport. Some weekly rental and return patterns are shown in the table (note that Airport means Metropolis Airport). Rented from Returned to   AP   DT   CA Airport (AP)   90%   10%   10% Downtown (DT)   5%   80%   5% At the beginning of a week, how many cars should be at each location so that the same...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT