Question

Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in...

Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of it car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled:

Month Rental Returns Car Wash Costs
January 2,300 $ 10,400
February 2,500 $ 12,800
March 2,700 $ 11,200
April 2,900 $ 13,400
May 3,600 $ 15,600
June 4,900 $ 22,100
July 5,500 $ 21,600
August 5,300 $ 20,700
September 4,700 $ 22,200
October 3,800 $ 19,300
November 2,100 $ 10,100
December 2,600 $ 12,100

2. Using least-squares regression, estimate the variable cost per rental return and the monthly fixed cost incurred to wash cars. (Round Fixed cost to the nearest whole dollar amount and the Variable cost per unit to 2 decimal places.)

Homework Answers

Answer #1

Go to data tab in excel - data analysis - regression

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in...
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of it car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the...
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in...
Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management believes that the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the...
1. Mauro Products distributes a single product, a woven basket whose selling price is $22 per...
1. Mauro Products distributes a single product, a woven basket whose selling price is $22 per unit and whose variable expense is $19 per unit. The company’s monthly fixed expense is $8,100. Required: 1. Calculate the company’s break-even point in unit sales. 2. Calculate the company’s break-even point in dollar sales. (Do not round intermediate calculations.) 3. If the company's fixed expenses increase by $600, what would become the new break-even point in unit sales? In dollar sales? (Do not...
A company that offers cars for rent wants to better understand costs. When cars are returned,...
A company that offers cars for rent wants to better understand costs. When cars are returned, they are thoroughly cleaned before being rented again. The manager believes that the variable portion of the cleaning costs relates to the number of rental returns. She has gathered the following data: Month Rental Returns Cleaning Costs January 2,500 $ 12,000 February 2,500 $ 13,600 March 2,800 $ 12,800 April 3,200 $ 15,800 May 3,700 $ 17,200 June 5,200 $ 25,300 July 5,600 $...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT