Introduction To Managerial Accounting
8th Edition
ISBN: 9781259917066
Author: BREWER, Peter C., Garrison, Ray H., Noreen, Eric W.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 6.A, Problem 2E
Least-Squares Regression LOS−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 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.
Required:
1. Prepare a scattergraph plot. (Place car wash costs cii the vertical axis and rental returns on the horizontal axis.)
2. 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 the 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
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
Rental Returns
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
January
February
2,500
2,500
March
April
May
June
July
August
September
October
2,800
3,100
3,700
5,100
5,600
5,600
4,800
4,100
2,200
3,000
November
December
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…
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
Rental Returns
Car Wash Costs
January
2,500
$
11,600
February
2,500
$
13,400
March
2,800
$
12,400
April
3,100
$
15,200
May
3,700
$
16,800
June
5,200
$
24,500
July
5,600
$
22,800
August
5,600
$
23,700
September
4,800
$
23,400
October
4,200
$
22,900
November
2,300
$
11,300
December
3,000
$
16,300
2. Using least-squares regression, estimate the variable cost…
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…
Chapter 6 Solutions
Introduction To Managerial Accounting
Ch. 6.A - The Cheyenne Hotel in Big Sky, Montana, has...Ch. 6.A - Least-Squares Regression LOS11 Bargain Rental Car...Ch. 6.A - Prob. 3ECh. 6.A - Archer Company is a wholesaler of custom-built...Ch. 6.A - George Caloz&Freres, located in Grenchen,...Ch. 6.A - Least-Square. Regression; Scattergraph; Comparison...Ch. 6.A - Cost Behaviour; High4æw Method; Contribution...Ch. 6.A - Nova Company’s total overhead cost at various...Ch. 6.A - High-Low Method; Contribution Format Income...Ch. 6.A - Least-Squares Regression Method; Scattergraph;...
Ch. 6.A - Mixed Cost Analysis and the Relevant Range LOS-10...Ch. 6.A - Prob. 12PCh. 6 - What is the meaning of contribution margin ratio?...Ch. 6 - Prob. 2QCh. 6 - In all respects, Company A and Company B are...Ch. 6 - What is the meaning of operating leverage?Ch. 6 - What is the meaning of break-even point?Ch. 6 - In response to a request from your immediate...Ch. 6 - What is the meaning of margin of safety?Ch. 6 - Prob. 8QCh. 6 - Explain how a shift in the sales mix could result...Ch. 6 - The Excel worksheet form that appears be1o is to...Ch. 6 - The Excel work sheet from that appears below is to...Ch. 6 - Prob. 3AECh. 6 - The Excel worksheet form that appears be1o is to...Ch. 6 - Prob. 5AECh. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Prob. 11F15Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - The Effect of Cha noes ¡n Activity on Net...Ch. 6 - Prob. 2ECh. 6 - Prepare a Profit Graph L062 Jaffre Enterprises...Ch. 6 - Computing and Using the CM Ratio L063 Last month...Ch. 6 - Changes in Venable Costs, Fixed Costs, Selling...Ch. 6 - Prob. 6ECh. 6 - Lin Corporation has a single product 1ose selling...Ch. 6 - Compute the Margin of Safety LO6-7 Molander...Ch. 6 - Compute and Use the Degree 01 Operating Leverage...Ch. 6 - Prob. 10ECh. 6 - Missing Data; Basic CVP Concepts L061, L069 Fill...Ch. 6 - Prob. 12ECh. 6 - Change in selling price, Sales Volume, Variable...Ch. 6 - Prob. 14ECh. 6 - Operating Leverage 1061. 1068 Magic Realm, Inc.,...Ch. 6 - Prob. 16ECh. 6 - Break-Even and Target Profit Analysis 1064, 1066,...Ch. 6 - Break-Even and Target Profit Analysis; Margin of...Ch. 6 - Prob. 19PCh. 6 - Prob. 20PCh. 6 - Prob. 21PCh. 6 - Prob. 22PCh. 6 - CVP Applications; Contribution Margin Ratio:...Ch. 6 - Break-Even and Target Profit Analysis LO6-6, L066...Ch. 6 - Prob. 25PCh. 6 - Prob. 26PCh. 6 - Prob. 27PCh. 6 - Sales Mix; Commission Structure; Multiproduct...Ch. 6 - Changes in Cost Structure; Break-Even Analysis;...Ch. 6 - Graphing; Incremental Analysis; Operating Leverage...Ch. 6 - Interpretive Questions on the CVP Graph L062, L065...
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
- 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…arrow_forwardRequired 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…arrow_forwardCost Behavior, High-Low Method, Pricing Decision Fonseca, Ruiz, and Dunn is a large, local accounting firm located in a southwestern city. Carlos Ruiz, one of the firms founders, appreciates the success his firm has enjoyed and wants to give something back to his community. He believes that an inexpensive accounting services clinic could provide basic accounting services for small businesses located in the barrio. He wants to price the services at cost. Since the clinic is brand new, it has no experience to go on. Carlos decided to operate the clinic for 2 months before determining how much to charge per hour on an ongoing basis. As a temporary measure, the clinic adopted an hourly charge of 25, half the amount charged by Fonseca, Ruiz, and Dunn for professional services. The accounting services clinic opened on January 1. During January, the clinic had 120 hours of professional service. During February, the activity was 150 hours. Costs for these two levels of activity usage are as follows: Required: 1. Classify each cost as fixed, variable, or mixed, using hours of professional service as the activity driver. 2. Use the high-low method to separate the mixed costs into their fixed and variable components. (Note: Round variable rates to two decimal places and fixed amounts to the nearest dollar.) 3. Luz Mondragon, the chief paraprofessional of the clinic, has estimated that the clinic will average 140 professional hours per month. If the clinic is to be operated as a nonprofit organization, how much will it need to charge per professional hour ? How much of this charge is variable? How much is fixed? (Note: Round answers to two decimal places.) 4. CONCEPTUAL CONNECTION Suppose the accounting center averages 170 professional hours per month. How much would need to be charged per hour for the center to cover its costs ? Explain why the per-hour charge decreased as the activity output increased. (Note: Round answers to two decimal places.)arrow_forward
- Cost Behavior, High-Low Method, Pricing Decision Fonseca, Ruiz, and Dunn is a large, local accounting firm located in a southwestern city. Carlos Ruiz, one of the firm's founders, appreciates the success his firm has enjoyed and wants to give something back to his community. He believes that an inexpensive accounting services clinic could provide basic accounting services for small businesses located in the barrio. He wants to price the services at cost. Since the clinic is brand new, it has no experience to go on. Carlos decided to operate the clinic for 2 months before determining how much to charge per hour on an ongoing basis. As a temporary measure, the clinic adopted an hourly charge of $25, half the amount charged by Fonseca, Ruiz, and Dunn for professional services. The accounting services clinic opened on January 1. During January, the clinic had 120 hours of professional service. During February, the activity was 150 hours. Costs for these two levels of activity usage are as…arrow_forwardRound Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver, Deluxe, and Business. The profit per night for each type of room and rental class is as follows: Type I rooms do not have high-speed wireless Internet access and are not available for the Business rental class. Round Trees management makes a forecast of the demand by rental class for each night in the future. A linear programming model developed to maximize profit is used to determine how many reservations to accept for each rental class. The demand forecast for a particular night is 130 rentals in the Super Saver class, 60 in the Deluxe class, and 50 in the Business class. Round Tree has 100 Type I rooms and 120 Type II rooms. a. Formulate and solve a linear program to determine how many reservations to accept in each rental class and how the reservations should be allocated to room types. b. For the solution in part (a), how many reservations can be accommodated in each rental class? Is the demand for any rental class not satisfied? c. With a little work, an unused office area could be converted to a rental room. If the conversion cost is the same for both types of rooms, would you recommend converting the office to a Type I or a Type II room? Why? d. Could the linear programming model be modified to plan for the allocation of rental demand for the next night? What information would be needed and how would the model change?arrow_forwardDifferential Costing As pointed out earlier in Heres the Real Kicker, Kicker changed banks a couple of years ago because the loan officer at its bank moved out of state. Kicker saw that as an opportunity to take bids for its banking business and to fine-tune the banking services it was using. This problem uses that situation as the underlying scenario but uses three banks: FirstBank, Community Bank, and RegionalOne Bank. A set of representative data was presented to each bank for the purpose of preparing a bid. The data are as follows: Checking accounts needed: 6 Checks per month: 2,000 Foreign debits/credits on checking accounts per month: 200 Deposits per month: 300 Returned checks: 25 per month Credit card charges per month: 4,000 Wire transfers per month: 100, of which 60 are to foreign bank accounts Monthly credit needs (line of credit availability and cost): 100,000 average monthly usage These are overall totals for the six accounts during a month. Internet banking services? Knowledgeable loan officer? Responsiveness of bank? FirstBank Bid: Checking accounts: 5 monthly maintenance fee per account 0.10 foreign debit/credit 0.50 earned for each deposit 3 per returned check Credit card fees: 0.50 per item Wire transfers: 15 to domestic bank accounts, 50 to foreign bank accounts Line of credit: Yes, this amount is available, interest charged at prime plus 2%, subject to a 6% minimum interest rate Internet banking services? Yes, full online banking available: 15 one-time setup fee for each account 20 monthly fee for software module The loan officer assigned to the potential Kicker account had 10 years of experience with medium to large business banking and showed an understanding of the audio industry. Community Bank Bid: Checking accounts: No fees for the accounts, and no credits earned on deposits 2.00 per returned check Credit card fees: 0.50 per item, 7 per batch processed. Only manual processing was available, and Kicker estimated 20 batches per month Wire transfers: 30 per wire transfer Line of credit: Yes, this amount is available: interest charged at prime plus 2% subject to a 7% minimum interest rate Internet banking services? Not currently, but within the next 6 months The loan officer assigned to the potential Kicker account had 4 years of experience with medium to large business banking, none of which pertained to the audio industry. RegionalOne Bank Bid: Checking accounts: 5 monthly maintenance fee per account to be waived for Kicker 0.20 foreign debit/credit 0.30 earned for each deposit 3.80 per returned check Credit card fees: 0.50 per item Wire transfers: 10 to domestic bank accounts, 55 to foreign bank accounts Line of credit: Yes, this amount is available: interest charged at prime plus 2% subject to a 6.5% minimum interest rate Internet banking services? Yes, full online banking available: one-time setup fee for each account waived for Kicker 20 monthly fee for software module The loan officer assigned to the potential Kicker account had 2 years of experience with large business banking. Another branch of the bank had expertise in the audio industry and would be willing to help as needed. This bank was the first one to submit a bid. Required: 1. Calculate the predicted monthly cost of banking with each bank. Round answers to the nearest dollar. 2. CONCEPTUAL CONNECTION Suppose Kicker felt that full online Internet banking was critical. How would that affect your analysis from Requirement 1? How would you incorporate the subjective factors (e.g., experience, access to expertise)?arrow_forward
- Air Americo is about to introduce a daily round-trip flight from New York to Los Angeles and is determining how to price its round-trip tickets. The market research group at Air Americo segments the market into business and pleasure travelers. It provides the following information on the effects of two different prices on the number of seats expected to be sold and the variable cost per ticket, including the commission paid to travel agents: Price Charged Variable Costs per Ticket # of Seats Expected to be Sold Business Pleasure 800 2,100 75 300 150 185 285 30 Pleasure travelers start their travel during one week, spend at least I weekend at their destination, and return the following week or thereafter. Business travelers usually start and complete their travel within the same workweek. They do not stay over weekends. Assume that round-trip fuel costs are fixed costs of $24,500 and that fixed costs allocated to the round-trip flight for airplane-lease costs, ground services, and…arrow_forwardSolve the following: A company recently established a branch to sell its most popular fan. The company purchases these fans and stores them in a warehouse. The fans are then shipped from the warehouse to both the home office and the new branch, FOB destination. Home office management is responsible for setting the transfer price of the fans charged to the branch in a manner that will measure the long-run incremental cost of supplying the fans to the branch on a continuing basis. Per unit costs for the fans are P50.00 purchase price P2.50 shipping cost to warehouse P3.00 handling cost including P1.00 of allocated administrative overhead P3.50 shipping cost to branch paid by home office P1.25 shipping cost to home office The minimum transfer price that home office should charge the branch to meet its measurement objective is?arrow_forwardIdentify Fixed and Variable Costs Intuit Inc. develops and sells software products for the personal finance market, including popular titles such as Quickbooks® and TurboTax®. Classify each of the following costs and expenses for this company as either variable or fixed to the number of units produced and sold: a. Packaging costs b. Sales commissions c. Property taxes on general offices d. Shipping expenses e. Straight-line depreciation of computer equipment f. President’s salary g. Salaries of software developers h. Salaries of human resources personnel i. Wages of telephone order assistants j. Users' guidesarrow_forward
- Strategy; Variable and Fixed Costs Zipcar (www.zipcar.com) is a car-sharing club founded inCambridge, Massachusetts, in 1999. The club members pay an annual fee and then have the opportunity to rent a small car (usually a subcompact; the models include the Toyota Prius) for a fixedhourly rate. Zipcar is located largely in select metropolitan areas such as Boston, San Francisco, andWashington, D.C. Members, called “Zipsters,” make reservations for a car on the Zipcar website andthen use an access card to open the vehicle. The vehicle has a “home base” parking spot where thedriver picks up and returns the vehicle. The club—which, as of early 2017, operates in more than500 cities and towns, at more than 600 college campuses, and 50 airports—has grown to more than1 million members since its initial public offering in April 2011.Required1. What are the fixed and variable costs for Zipcar?2. What are some of the competitive advantages and challenges of the Zipcar concept?arrow_forwardCVP Analysis: Sales-Revenue Approach, Pricing, After-Tax Target Income Mahan Consulting is a service organization that specializes in the design, installation, and servicing of mechanical, hydraulic, and pneumatic systems. For example, some manufacturing firms, with machinery that cannot be turned off for servicing, need some type of system to lubricate the machinery during use. To deal with this type of problem for a client, Mahan designed a central lubricating system that pumps lubricants intermittently to bearings and other moving parts. The operating results for the firm for the previous year are as follows: Sales $974,880 Less: Variable expenses 534,234 Contribution margin $440,646 Less: Fixed expenses 264,300 Operating income $176,346 In the coming year, Mahan expects variable costs to increase by 4 percent and fixed costs to increase by 3 percent. Required: 1. What is the contribution margin ratio for the previous year? Enter your answer as a decimal value…arrow_forwardJims Camera shop sells two high-end cameras, the Sky Eagle and Horizon. The demand for these two cameras are as follows: Ds = demand for the Sky Eagle, Ps is the selling price of the Sky Eagle, DH is the demand for the Horizon, and PH is the selling price of the Horizon. DS=2220.60Ps+0.35PHDH270+0.10Ps0.64PH The store wishes to determine the selling price that maximizes revenue for these two products. Develop the revenue function for these two models, and find the prices that maximize revenue.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
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...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Pricing Decisions; Author: Rutgers Accounting Web;https://www.youtube.com/watch?v=rQHbIVEAOvM;License: Standard Youtube License