Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. required information exercise 5a-2 (algo) least-sq

Required information Exercise 5A-2 (Algo) Least-Squares Regression [LO5-11] [The following information applies to the questions displayed below.] Bargain Rental...

Free

50.1K

Verified Solution

Question

Accounting

Required information

Exercise 5A-2 (Algo) Least-Squares Regression [LO5-11]

[The following information applies to the questionsdisplayed below.]

Bargain Rental Car offers rental cars in an off-airport locationnear a major tourist destination in California. Management wouldlike to better understand the variable and fixed portions of itscar washing costs. The company operates its own car wash facilityin which each rental car that is returned is thoroughly cleanedbefore being released for rental to another customer. Managementbelieves that the variable portion of its car washing costs relatesto the number of rental returns. Accordingly, the following datahave been compiled:

MonthRental ReturnsCar Wash Costs
January2,500$12,000
February2,500$13,600
March2,800$12,800
April3,200$15,800
May3,700$17,200
June5,200$25,300
July5,600$23,200
August5,700$24,700
September4,800$23,800
October4,700$24,100
November2,300$11,700
December3,200$17,700

Exercise 5A-2 Part 2 (Algo)

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

Answer & Explanation Solved by verified expert
4.1 Ratings (844 Votes)

Month x=rental returns y = car wash costs xy X2
Jan 2,500 12,000 3,00,00,000 62,50,000
Feb 2,500 13,600 3,40,00,000 62,50,000
Mar 2800 12,800 3,58,40,000 78,40,000
April 3200 15,800 5,05,60,000 1,02,40,000
May 3700 17,200 6,36,40,000 1,36,90,000
June 5200 25,300 13,15,60,000 2,70,40,000
July 5600 23,200 12,99,20,000 3,13,60,000
Aug 5700 24,700 14,07,90,000 3,24,90,000
Sep 4800 23,800 11,42,40,000 2,30,40,000
Oct 4700 24,100 11,32,70,000 2,20,90,000
Nov 2300 11,700 2,69,10,000 52,90,000
Dec 3200 17,700 5,66,40,000 1,02,40,000
Total 46,200 2,21,900 92,73,70,000 19,58,20,000

N = number of months = 12

Variable cost per rental return =( N ?xy ? ?x ?y)/{(N ?x²) ? (?x)²}

Variable cost per rental return ={( 12 × 92,73,70,000) - (46,200× 2,21,900) } / {(12 ×19,58,20,000) - (46,200)²}

On solving VC per Rental return = 4.0699 or 4.07

Fixed Cost per month = {?y - ( Variable cost per rental return × ?x )/N

Fixed Cost per month = {2,21,900 - (4.07 × 46,200)} /12

Fixed cost Per month = 33,866/12 = 2822.17
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

A consumer product testing organization uses a survey of readers to obtain customer satisfaction ratings for...

Statistics
Q

Explain the major ideas behind how a zygote proceeds through embryonic development

Biology
Q

Air flows through a 0.25-m-diameter duct. At the inlet the velocity is 300 m/s, and the...

Mechanical Engineering
Q

Summarize a probability and statistics journal, 1 page long. Any kind please!

Advance Math
Q

Miller Industries has 9 000 units in beginning finished goods The sales budget shows expected...

Basic Math
Q

On the table rest 8 dominoes as shown below A Suppose you were to line...

Basic Math
Q

discuss how public interest theory has been put forward to describe how accounting is regulated...

Accounting
Q

Define the term misstatement and describe characteristics that would make a misstatement material.

Accounting
Q

Miller Outdoor Equipment (MOE) makes four models of tents. The model names are Rookie, Novice,...

Accounting
Q

Your company uses the following model to forecast breakfast meals in your hotel restaurant. ...

Accounting
Q

Henley, alge 70 and single, is claimed as a dependent on a child's tax return,...

Accounting
Q

Which of the following is true about the cost of employees within a business context?...

Accounting