Bargain Rental Car wants to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility that cleans each rental car before releasing it to another customer. Management believes the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled: Month January February March April May June July August September October November December Rental Returns. 2,500 2,500 2,800 3,100 3,700 5,200 5,600 5,700 4,800 4,900 2,300 3,100 Exercise 5A-2 Part 2 (Algo) Fixed cost per month Variable cost per rental return Car Wash Costs $ 11,800 $ 13,500 $ 12,600 2. Using least-squares regression; estimate the variable cost per rental return and the monthly fixed cost incurred to wash cars. Note: Round Fixed cost to the nearest whole dollar amount and the Variable cost per unit to 2 decimal places. $ 15,500 $ 17,000 $ 24,900 $ 23,000 $ 24,200 $ 23,600 $ 23,500 $ 11,500 $ 17,000 wwwwww

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter2: Descriptive Statistics
Section: Chapter Questions
Problem 3P: Ohio Logistics manages the logistical activities for firms by matching companies that need products...
icon
Related questions
icon
Concept explainers
Topic Video
Question
Bargain Rental Car wants to better understand the variable and fixed portions of its car washing costs. The company
operates its own car wash facility that cleans each rental car before releasing it to another customer. Management
believes the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following
data have been compiled:
Month
January
February
March
April
May
June
July
August
September
October
November
December
Rental
Returns
2,500
2,500
2,800
3,100
3,700
5,200
5,600
5,700
4,800
4,900
Fixed cost per month
Variable cost per rental return
2,300
3,100
Exercise 5A-2 Part 2 (Algo)
Car Wash Costs
$ 11,800
$ 13,500
$ 12,600
$ 15,500
$ 17,000
$ 24,900
$ 23,000
$ 24,200
$ 23,600
$ 23,500
$ 11,500
$ 17,000
2. Using least-squares regression; estimate the variable cost per rental return and the monthly fixed cost incurred to wash cars.
Note: Round Fixed cost to the nearest whole dollar amount and the Variable cost per unit to 2 decimal places.
Transcribed Image Text:Bargain Rental Car wants to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility that cleans each rental car before releasing it to another customer. Management believes the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled: Month January February March April May June July August September October November December Rental Returns 2,500 2,500 2,800 3,100 3,700 5,200 5,600 5,700 4,800 4,900 Fixed cost per month Variable cost per rental return 2,300 3,100 Exercise 5A-2 Part 2 (Algo) Car Wash Costs $ 11,800 $ 13,500 $ 12,600 $ 15,500 $ 17,000 $ 24,900 $ 23,000 $ 24,200 $ 23,600 $ 23,500 $ 11,500 $ 17,000 2. Using least-squares regression; estimate the variable cost per rental return and the monthly fixed cost incurred to wash cars. Note: Round Fixed cost to the nearest whole dollar amount and the Variable cost per unit to 2 decimal places.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College