Question

In: Operations Management

(Automobile leasing problem) Sundown Rent-a-Car, a large automobile rental agency operating in the Midwest, is preparing...

(Automobile leasing problem) Sundown Rent-a-Car, a large automobile rental agency operating in the Midwest, is preparing a leasing strategy for the next six months. Sundown leases cars from an automobile manufacturer and then rents them to the public on a daily basis. A forecast of the demand for Sundown’s cars in the next six months follows: MONTH MARCH APRIL MAY JUNE JULY AUGUST Demand 420 400 430 460 470 440 Cars may be leased from the manufacturer for either three, four, or five months. These are leased on the first day of the month and are returned on the last day of the month. Every six months the automobile manufacturer is notified by Sundown about the number of cars needed during the next six months. The automobile manufacturer has stipulated that at least 50% of the cars leased during a six-month period must be on the five-month lease. The cost per month on each of the three types of leases are $420 for the three-month lease, $400 for the four-month lease, and $370 for the five-month lease. Currently, Sundown has 390 cars. The lease on 120 cars expires at the end of March. The lease on another 140 cars expires at the end of April, and the lease on the rest of these expires at the end of May. Use LP to determine how many cars should be leased in each month on each type of lease to minimize the cost of leasing over the six-month period. How many cars are left at the end of August?

Show objective function and constraints

Solutions

Expert Solution


Related Solutions

Consider Ace Rent-A-Car, a nationwide automobile rental company. For each car that the company owns, Ace...
Consider Ace Rent-A-Car, a nationwide automobile rental company. For each car that the company owns, Ace records its unique vehicle identification number (VIN), its “make” (manufacturer), model, year of manufacture, and the manufacturer’s factory in which it was made. Each factory is identified by the combination of its company name (i.e. manufacturer name) and the city in which it is located. We also know its size and the year it was built. Each manufacturer is identified by its unique name,...
Consider Ace Rent-A-Car, a nationwide automobile rental company. For each car that the company owns, Ace...
Consider Ace Rent-A-Car, a nationwide automobile rental company. For each car that the company owns, Ace records its unique vehicle identification number (VIN), its “make” (manufacturer), model, year of manufacture, and the manufacturer’s factory in which it was made. Each factory is identified by the combination of its company name (i.e. manufacturer name) and the city in which it is located. We also know its size and the year it was built. Each manufacturer is identified by its unique name,...
A rental car company claims the mean time to rent a car on their website is...
A rental car company claims the mean time to rent a car on their website is 60 seconds with a standard deviation of 30 seconds. A random sample of 36 customers attempted to rent a car on the website. The mean time to rent was 75 seconds. Is this enough evidence to contradict the company's claim ? I need help how to solve in Excel
Introduction Rent-a-Car is one of the two car rental agencies serving a small regional airport in...
Introduction Rent-a-Car is one of the two car rental agencies serving a small regional airport in the U.S. Midwest. Forty per cent (40%) of its customers are airline passengers and the remaining sixty per cent (60%) are dwellers of the small nearby college town who use rental cars for business and leisure trips. The airport is within two miles from campus and approximately six miles from the city center. It is easy to reach by car, taxi, or city bus....
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...
The following data represent the daily rental cost for a compact automobile charged by two car...
The following data represent the daily rental cost for a compact automobile charged by two car rental companies, Thrifty and Hertz, in 10 randomly selected major U.S. cities. Test whether Thrifty is less expensive than Hertz at the α = 0.1 level of significance. City Thrifty Hertz Chicago 21.81 18.99 Los Angeles 29.89 48.99 Houston 17.90 19.99 Orlando 27.98 35.99 Boston 24.61 25.60 Seattle 21.96 22.99 Pittsburgh 20.90 19.99 Phoenix 47.75 36.99 New Orleans 33.81 26.99 Minneapolis 33.49 20.99 Conditions:...
Suppose that a car-rental agency offers insurance for a week that costs $100. A minor fender...
Suppose that a car-rental agency offers insurance for a week that costs $100. A minor fender bender will cost $3,500, whereas a major accident might cost $16,000 in repairs. Without the insurance, you would be personally liable for any damages. What should you do? Clearly, there are two decision alter-natives: take the insurance, or do not take the insurance. The uncertain consequences, or events that might occur, are that you would not be involved in an accident, that you would...
A car rental agency is considering a modification in its oil change procedure. currently, it uses...
A car rental agency is considering a modification in its oil change procedure. currently, it uses a type X filter, which cost $4.25 and must be changed every 9,000 miles along with oil (4 quarts.) Between each oil change , one quart of oil must be added after each 500 miles. The proposed filter (typeY) has to be replaced every 4,000 miles (along with 4 quarts of oil) but does not require any additional oil between filter changes. If the...
Suppose that a car-rental agency offers insurance for a week that costs $100. A minor fender...
Suppose that a car-rental agency offers insurance for a week that costs $100. A minor fender bender will cost $3,500, whereas a major accident might cost $16,000 in repairs. Without the insurance, you would be personally liable for any damages. What should you do? Clearly, there are two decision alternatives: take the insurance, or do not take the insurance. The uncertain consequences, or events that might occur, are that you would not be involved in an accident, that you would...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT