MANAGERIAL ACCOUNTING-W/ACCESS >C<
22nd Edition
ISBN: 9781307839302
Author: Garrison
Publisher: MCG/CREATE
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 5.A, Problem 2E
EXERCISE 5A-2 Least-Squares Regression LO5-11
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:
Required:
- Prepare a scattergraph plot. (Place car wash costs on the vertical axis and rental returns on the horizontal axis.)
- Using least-squares regression, estimate the variable cost per rental return and the monthly fixed cost incurred to wash cars. The total fixed cost should be estimated to file nearest dollar and the variable cost per rental return to the nearest cent.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Required information
Exercise 5A-2 (Algo) Least-Squares Regression [LO5-11]
[The following information applies to the questions displayed below.]
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,400
2,500
2,800
3,100
3,700
5,100
5,600
5,600
4,700
4,100
2,200
2,900
Exercise 5A-2 Part 2 (Algo)
Car Wash Costs.
$ 11,300
$ 13,300
$ 12,100
$ 14,700
$ 16,500
$ 23,900
$ 22,500
$ 22,900
$ 23,100
$ 22,000
$ 11,000
$ 15,300
2. Using least-squares regression, estimate the variable cost per rental return and the monthly fixed
cost incurred to wash cars.
Note: Round…
Required information
Exercise 5A-2 (Algo) Least-Squares Regression [LO5-11]
[The following information applies to the questions displayed below.]
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,100
5,600
5,600
4,800
4,100
Fixed cost per month
Variable cost per rental return
2,200
3,000
Car Wash Costs
$ 11,500
$ 13,400
$ 12,300
$ 15,000
$ 16,700
$ 24,300
$ 22,700
$ 23,400
$ 23,300
$ 22,600
$ 11, 200
$ 16,000
Exercise 5A-2 Part 2 (Algo)
2. Using least-squares regression, estimate the variable cost per rental return and the…
Required information
Exercise 5A-2 (Algo) Least-Squares Regression [LO5-11]
[The following information applies to the questions displayed below.]
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 following data have been compiled:
Month
January
February
March
April
May
June
July
August
September
October
November
December
Rental
Returns
2,400
2,500
2,800
3,100
Fixed cost per month
Variable cost per rental return i
3,700
5,100
5,600
5,600
4,800
4,100.
2,200
3,000.
Car Wash Costs
$ 11,400
$ 13,300
$ 12,200
$ 14,900
$ 16,600
$ 24,100
$…
Chapter 5 Solutions
MANAGERIAL ACCOUNTING-W/ACCESS >C<
Ch. 5.A - EXERCISE 5A-1 High-Low Method LO5-10 The Cheyenne...Ch. 5.A - EXERCISE 5A-2 Least-Squares Regression LO5-11...Ch. 5.A - EXERCISE 5A-3 Cost Behavior; High-Low Method...Ch. 5.A - Prob. 4ECh. 5.A - EXERCISE 5A-5 Least-Squares Regression LO5-11...Ch. 5.A - Prob. 6PCh. 5.A - Problem 5A-7 Cost Behavior; High-Low Method;...Ch. 5.A - Problem 5A-8 High-Low Method; Predicting Cost...Ch. 5.A - Prob. 9PCh. 5.A - Prob. 10P
Ch. 5.A - Case 5A-11 Mixed Cost Analysis and the Relevant...Ch. 5.A - CASE 5A-12 Analysis of Mixed Costs in a Pricing...Ch. 5 - Prob. 1QCh. 5 - Often the most direct route to a business decision...Ch. 5 - Prob. 3QCh. 5 - What is the meaning of operating leverage?Ch. 5 - What is the meaning of break-even point?Ch. 5 - 5-6 In response to a request from your immediate...Ch. 5 - Prob. 7QCh. 5 - Prob. 8QCh. 5 - Prob. 9QCh. 5 - Prob. 1AECh. 5 - Prob. 2AECh. 5 - Prob. 3AECh. 5 - Prob. 4AECh. 5 - Prob. 5AECh. 5 - Prob. 1F15Ch. 5 - Prob. 2F15Ch. 5 - Prob. 3F15Ch. 5 - Prob. 4F15Ch. 5 - Prob. 5F15Ch. 5 - Prob. 6F15Ch. 5 - Prob. 7F15Ch. 5 - Prob. 8F15Ch. 5 - Prob. 9F15Ch. 5 - Prob. 10F15Ch. 5 - Prob. 11F15Ch. 5 - Prob. 12F15Ch. 5 - Prob. 13F15Ch. 5 - Prob. 14F15Ch. 5 - Prob. 15F15Ch. 5 - Prob. 1ECh. 5 - Prob. 2ECh. 5 - Prob. 3ECh. 5 - Prob. 4ECh. 5 - Prob. 5ECh. 5 - Prob. 6ECh. 5 - Prob. 7ECh. 5 - Prob. 8ECh. 5 - Prob. 9ECh. 5 - EXERCISE 5-10 Multiproduct Break-Even Analysis...Ch. 5 - Prob. 11ECh. 5 - EXERCISE 5-12 Multiproduct Break-Even Analysis...Ch. 5 - EXERCISE 5-13 Changes in Selling Price, Sales...Ch. 5 - Prob. 14ECh. 5 - Prob. 15ECh. 5 - Prob. 16ECh. 5 - Prob. 17ECh. 5 - Prob. 18ECh. 5 - Prob. 19PCh. 5 - PROBLEM 5-20 CVP Applications: Break-Even...Ch. 5 - PROBLEM 5-21 Sales Mix; Multiproduct Break-Even...Ch. 5 - Prob. 22PCh. 5 - Prob. 23PCh. 5 - Prob. 24PCh. 5 - Prob. 25PCh. 5 -
PROBLEM 5-26 CVP Applications; Break-Even...Ch. 5 - Prob. 27PCh. 5 - Prob. 28PCh. 5 - Prob. 29PCh. 5 - Prob. 30PCh. 5 -
PROBLEM 5-31 Interpretive Questions on the CVP...Ch. 5 - Prob. 32C
Knowledge Booster
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
- help in detailarrow_forward7arrow_forwardRequired information Exercise 6A-2 (Algo) Least-Squares Regression [LO6-11] [The following information applies to the questions displayed below.] 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 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,500 2,300 3,100 Car Wash Costs $ 11,900 $ 13,600 $ 12,700 $ 15,600 $ 17,100 $ 25,100 $ 23,100 $ 24,400 $ 23,700 $ 23,800 Fixed cost per month…arrow_forward
- Serial Problem Business Solutions LO P3 Santana Rey has found that Business Solutions's line of computer desks and chairs has become very popular, and she is finding it hard to keep up with demand. She knows that she cannot fill all of her orders for both items, so she decides she must determine the optimal sales mix given the resources she has available. Information about the desks and chairs follows. Selling price per unit. Variable costs per unit Contribution margin per unit Direct labor hours per unit Expected demand for next quarter Contribution per direct labor hour Maximum number of units to be sold Hours required to produce maximum units For most profitable sales mix Desks $1,203.50 Santana has determined that she only has 1,167 direct labor hours available for the next quarter and wants to optimize her contribution margin given the limited number of direct labor hours available. Hours dedicated to the production of each product 410.00 $ 793.50 Required: Determine the optimal…arrow_forwardA7arrow_forwardExercise 6-3 Compute Activity Rates [LO6-3] Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate costs for pricing and other purposes. The proprietor of the company believes that costs are driven primarily by the size of customer lawns, the size of customer garden beds, the distance to travel to customers, and the number of customers. In addition, the costs of maintaining garden beds depends on whether the beds are low maintenance beds (mainly ordinary trees and shrubs) or high maintenance beds (mainly flowers and exotic plants). Accordingly, the company uses the five activity cost pools listed below: Activity Cost Pool Activity Measure Caring for lawn Square feet of lawn Caring for garden beds–low maintenance Square feet of low maintenance beds Caring for garden beds–high maintenance Square feet of high maintenance beds Travel to jobs Miles Customer billing and service Number of customers The company has already…arrow_forward
- Helparrow_forwardQuestion 6 Part 2arrow_forward(Appendix 3A) Method of Least Squares Using Computer Spreadsheet Program Susan Lewis, owner of a florist shop, is interested in predicting the cost of delivering floral arrangements. She collected monthly data on the number of deliveries and the total monthly delivery cost (depreciation on the van, wages of the driver, and fuel) for the past year. Required: 1. Using a computer spreadsheet program such as Excel, run a regression on these data. Print out your results. 2. Using your results from Requirement 1, write the cost formula for delivery cost. (Note: Round the fixed cost to the nearest dollar and the variable rate to the nearest cent.) 3. CONCEPTUAL CONNECTION What is R2 based on your results? Do you think that the number of direct labor hours is a good predictor of delivery cost? 4. Using the cost formula in Requirement 2, what would predicted delivery cost be for a month with 300 deliveries?arrow_forward
- Activity Rate Travel Deliveries $2 per mile driven. $ 50 per delivery $ 22 per phone call Customer service Two of the company's many customers include Customer A and Customer B. These two customers consumed the company's activities as follows: Total Expected Activity Customer A Customer B 250 5 12 Activity Cost Pool Travel (number of miles driven) Deliveries (number of deliveries) Customer service (number of phone calls) How much cost would be assigned from the Travel activity to Customer A? Multiple Choice $170 $60 $680 340 15 20arrow_forwardNumber 6 Tasty Time Cafeteria operates cafeteria food services in public buildings in the Midwest. Tasty Time is contemplating a major change in its cost structure. Currently, all of their cafeteria lines are staffed with hourly wage employees who hand serve the food to customers. Benson Riggs, Tasty Time's owner, is considering replacing the employees with an automated self-service system. However, before making the change, Benson would like to know the consequences of the change, since the volume of business varies significantly from location to location. Shown below are the CVP income statements for each alternative. Automated Self-Service Personal Service System $2,500,000 1.125,000 $1,375,000 875,000 S 500,000 System $2,500,000 1.875,000 625,000 125,000 S 500,000 Sales Variable costs Contribution margin Fixed costs Net Income Instructions Determine the degree of operating leverage for each alternative. Which alternative would produce the higher net income if sales increased by…arrow_forwardSh3 Please help me. Thanksarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
GE McKinsey Matrix for SBU Strategies; Author: Wolters World;https://www.youtube.com/watch?v=FffD1Ze76JQ;License: Standard Youtube License