Concept explainers
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.
Want to see the full answer?
Check out a sample textbook solutionChapter 6 Solutions
Loose Leaf For Introduction To Managerial Accounting
- 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…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,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_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
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningManagerial 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