Managerial Accounting - With Helios Access
5th Edition
ISBN: 9780134493916
Author: Braun
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 6, Problem 6.7SE
Prepare and analyze a scatterplot (Learning Objective 3)
Montrose Oil and Lube is a car care center specializing in ten-minute oil changes. Montrose Oil and Lube has two service bays, which limits its capacity to 4,000 oil changes per month. The following information was collected over the past six months:
Month | Number of Oil Changes | Operating Expenses |
January | 3,200 | $36,400 |
February | 2,600 | $31,900 |
March | 2,800 | $32,850 |
April | 2,700 | $32,500 |
May | 3,600 | $37,000 |
June | 2,900 | $33,700 |
- 1. Prepare a scatterplot graphing the volume of oil changes (x-axis) against the company’s monthly operating expenses (y-axis). Graph by hand or use Excel
- 2. How strong a relationship does there appear to be between the company’s operating expenses and the number of oil changes performed each month? Explain. Do there appear to be any outliers in the data? Explain.
- 3. Based on the graph, do the company’s operating costs appear to be fixed, variable, or mixed? Explain how you can tell.
- 4. Would you feel comfortable using this information to project operating costs for a volume of 3,800 oil changes per month? Explain.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Learning Task 2
Problem: The Prospere Bookstore
The Prospere Bookstore sells the books used in classed such as workbooks and coloring books. All the enrolled learners (150 learners) purchased the 3 prescribed books at P500 each. The books costs P200 each. Also, sales of various school supplies amounted to P500,000. Costs of these school supplies amounted to P250,000.
The monthly salary of the bookstore manager is P20,000. The store is manned by one clerk with monthly salary of P6,000. Utilities expense for the year totals P80,000. Of this, 25% is for the small office at the back of the bookstore. Depreciation for store fixtures amounted to P50,000.
Requirement: Prepare the multi-step income for the year ended December 31 for Prospere Bookstore.
C7-73 Calculate breakeven and margin of safety after hotel renovation (Learning Objective 2) Cost-Volume-Profit Analysis 437 This case is a continuation of the Caesars Entertainment Corporation serial case that began in Chapter 1. Refer to the introductory story in chapter 1 (see page 43) for additional background. (The components of the Caesars serial case can be completed in any order.) Caesars Palace® Las Vegas made headlines when it undertook a $75 million renovation. In mid-September 2015, the hotel closed its then-named Roman Tower, which was last updated in 2001, and started a major renovation of the 567 rooms housed in that tower . On January 1, 2016, the newly renamed Julius Tower reopened, replacing the Roman Tower. In addition to renovating the existing rooms and suites in the former Roman Tower, 20 guest rooms were added to the Roman Tower. With the renovation completed, Caesars expects the Julius Tower room rate to average around $149 per night. This increase, a $25 or 20…
The Happy Toddlers (THT) is a preparatory school for children three to five years old. There are ten teachers employed by THT: five senior teachers with a salary of P30,000 a month and five junior teachers at P18,000 a month. There are also four administrators with average monthly salary of P35,000. Annual depreciation for furniture and fixtures amounted to P100,000. Utilities starting operation totals P200,000.
Required:Examine and list down the expenses of THT as of December 31 by nature.
Which type of expense is the highest and lowest?
If the owner of THT consulted you on minimizing expenses and maximizing profit, what would you recommend?
Chapter 6 Solutions
Managerial Accounting - With Helios Access
Ch. 6 - (Learning Objective 1) A graph of a variable cost...Ch. 6 - (Learning Objective 2) Which of the following is...Ch. 6 - (Learning Objective 2) In the cost equation...Ch. 6 - Prob. 4QCCh. 6 - Prob. 5QCCh. 6 - (Learning Objective 3) Which of the following is...Ch. 6 - Prob. 7QCCh. 6 - (Learning Objective 5) Which of the following is...Ch. 6 - Prob. 9QCCh. 6 - Prob. 10QC
Ch. 6 - Identify cost behavior (Learning Objectives 1 2)...Ch. 6 - Prob. 6.2SECh. 6 - Compute fixed costs per unit (Learning Objective...Ch. 6 - Prob. 6.4SECh. 6 - Predict and graph total mixed costs (Learning...Ch. 6 - Prob. 6.6SECh. 6 - Prepare and analyze a scatterplot (Learning...Ch. 6 - Prob. 6.8SECh. 6 - Use the high-low method (Learning Objective 4)...Ch. 6 - Prob. 6.10SECh. 6 - Prob. 6.11SECh. 6 - Prob. 6.12SECh. 6 - Write a cost equation given regression output...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Identify cost behavior graph (Learning Objectives...Ch. 6 - Prob. 6.18SECh. 6 - Prob. 6.19SECh. 6 - Prob. 6.20AECh. 6 - Prepare income statement in two formats (Learning...Ch. 6 - Prob. 6.22AECh. 6 - Prob. 6.23AECh. 6 - Sustainability and cost estimation (Learning...Ch. 6 - Create a scatterplot (Learning Objective 3) Melody...Ch. 6 - Continuation of E6-25A: High-low method (Learning...Ch. 6 - Continuation of E6-25A: Regression analysis...Ch. 6 - Regression analysis using Excel output (Learning...Ch. 6 - Prob. 6.29AECh. 6 - Using the high-low method to predict overhead for...Ch. 6 - Using regression analysis output to predict...Ch. 6 - Performing a regression analysis to predict...Ch. 6 - Prob. 6.33AECh. 6 - Prob. 6.34AECh. 6 - Compare absorption and variable costing (Learning...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Prepare a variable costing income statement given...Ch. 6 - Prob. 6.40AECh. 6 - Prob. 6.41BECh. 6 - Prepare income statement in two formats (Learning...Ch. 6 - Use unit cost data to forecast total costs...Ch. 6 - Prob. 6.44BECh. 6 - Sustainability and cost estimation (Learning...Ch. 6 - Create a scatter plot (Learning Objective 3) Tammy...Ch. 6 - Continuation of E6-46B: High-low method (Learning...Ch. 6 - Prob. 6.48BECh. 6 - Prob. 6.49BECh. 6 - Prob. 6.50BECh. 6 - Using the high-low method to predict overhead for...Ch. 6 - Using regression analysis output to predict...Ch. 6 - Prob. 6.53BECh. 6 - Prob. 6.54BECh. 6 - Prob. 6.55BECh. 6 - Prob. 6.56BECh. 6 - Prob. 6.57BECh. 6 - Prob. 6.58BECh. 6 - Prob. 6.59BECh. 6 - Prepare a variable costing income statement given...Ch. 6 - Prob. 6.61BECh. 6 - Analyze cost behavior at a hospital using various...Ch. 6 - Analyze cost behavior (Learning Objectives 1, 2,...Ch. 6 - Prob. 6.64APCh. 6 - Prob. 6.65APCh. 6 - Prob. 6.66APCh. 6 - Analyze cost behavior at a hospital using various...Ch. 6 - Analyze cost behavior (Learning Objectives 1, 2,...Ch. 6 - Prepare traditional and contribution margin income...Ch. 6 - Prob. 6.70BPCh. 6 - Prob. 6.71BPCh. 6 - Prob. 6.72SCCh. 6 - Cost Behavior in Real Companies Choose a company...Ch. 6 - Ethics of building inventory (Learning Objective...Ch. 6 - Prob. 6.76ACT
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
- The Happy Toddlers (THT) is a preparatory school for children three to five years old. There are ten teachers employed by THT: five senior teachers with a salary of P30,000 a month and five junior teachers at P18,000 a month. There are also four administrators with average monthly salary of P35,000. Annual depreciation for furniture and fixtures amounted to P100,000. Utilities starting operation totals P200,000. Required:Examine and list down the expenses of THT as of December 31 by nature. Which type of expense is the highest and loarrow_forwardThe Happy Toddlers (THT) is a preparatory school for children three to five years old. There are ten teachers employed by THT: five senior teachers with a salary of P30,000 a month and five junior teachers at P18,000 a month. There are also four administrators with average monthly salary of P35,000. Annual depreciation for furniture and fixtures amounted to P100,000. Utilities starting operation totals P200,000.Required:Examine and list down the expenses of THT as of December 31 by nature. Which type of expense is the highest and lowest?If the owner of THT consulted you on minimizing expenses and maximizing profit, what would you recommend?arrow_forwardSocial Media, Inc. (SMI) has two services for users. To ot!, which connects tuters with students who are looking for tutoring services, and TiX, which can be used to buy, sell, or exchange event tickets. For the following year, SMI expects the following results. Toot! TiX Total Users 13,100 20,100 33,200 Revenues $ 1,800,000 $ 1,760,000 $ 3,560,000 Engineering hours 9,300 7,300 16,600 Engineering cost $ 687,750 $ 806,250 $ 1,494,000 Administrative costs $ 1,195,200 Required: a. Compute the predetermined overhead rate used to apply administrative costs to the two services assuming SMI uses the number of users to allocate administrative costs. b. Based on the rates computed in requirement (a), what is the profit for each service?arrow_forward
- While completing undergraduate school work in information systems, Dallin Bourne and Michael Banks decided to start a technology support company called eSys Answers. During year 1, they bought the following assets and incurred the following start-up fees: Year 1 Assets Purchase Date Basis Computers (5-year) October 30, Year 1 $ 15,100 Office equipment (7-year) October 30, Year 1 10,000 Furniture (7-year) October 30, Year 1 3,200 Start-up costs October 30, Year 1 17,180 In April of year 2, they decided to purchase a customer list from a company providing virtually the same services, started by fellow information systems students preparing to graduate. The customer list cost $10,180, and the sale was completed on April 30. During their summer break, Dallin and Michael passed on internship opportunities in an attempt to really grow their business into something they could do full time after graduation. In the summer, they purchased a small van (for transportation, not…arrow_forward[The following information applies to the questions displayed below.] While completing undergraduate school work in information systems, Dallin Bourne and Michael Banks decided to start a technology support company called eSys Answers. During year 1, they bought the following assets and incurred the following start-up fees: Year 1 Assets Purchase Date Basis Computers (5-year) October 30, Year 1 $ 16,400 Office equipment (7-year) October 30, Year 1 10,000 Furniture (7-year) October 30, Year 1 5,800 Start-up costs October 30, Year 1 19,520 In April of year 2, they decided to purchase a customer list from a company providing virtually the same services, started by fellow information systems students preparing to graduate. The customer list cost $12,520, and the sale was completed on April 30. During their summer break, Dallin and Michael passed on internship opportunities in an attempt to really grow their business into something they could do full time after graduation.…arrow_forwardSocial Media, Inc. (SMI) has two services for users. Toot!, which connects tutors with students who are looking for tutoring services, and TiX, which can be used to buy, sell, or exchange event tickets. For the following year, SMI expects the following results. Toot! TiX Total Users 15,500 22,100 37,600 Revenues $ 2,000,000 $ 2,080,000 $ 4,080,000 Engineering hours 10,400 8,400 18,800 Engineering cost $ 881,000 $ 999,000 $ 1,880,000 Administrative costs $ 1,504,000 The company is considering using a two-stage cost allocation system and wants to assess the effects on reported product profits. The company is considering using Engineering Hours and Users as the allocation base. Additional information follows. Toot! TiX Total Engineering hours 10,400 8,400 18,800 Users 15,500 22,100 37,600 Engineering-hour related administrative cost $ 199,280 User-related…arrow_forward
- Social Media, Inc. (SMI) has two services for users. Toot!, which connects tutors with students who are looking for tutoring services, and TIX, which can be used to buy, sell, or exchange event tickets. For the following year, SMI expects the following results. Toot! Tix Total Users 15,500 22,100 37,600 Revenues $2,000,000 $2,080,000 $4,080,000 Engineering hours 10,4000 8,400 18,800 Engineering cost $ 881,000 $ 999,000 $1,880,000 Administrative costs…arrow_forwardPlease review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.You are required to submit this assignment to LopesWrite. Please refer to the directions in the Student Success Center.Paul Duncan, financial manager of EduSoft Inc., is facing a dilemma. The firm was founded 5 years ago to provide educational software for the rapidly expanding primary and secondary school markets. Although EduSoft has done well, the firm's founder believes an industry shakeout is imminent. To survive, EduSoft must grab market share now, and this will require a large infusion of new capital.Because he expects earnings to continue rising sharply and looks for the stock price to follow suit, Mr. Duncan does not think it would be wise to issue new common stock at this time. On the other hand, interest rates are currently high by historical standards, and the firm's B rating means that interest payments on a new debt issue would be prohibitive.…arrow_forwardTo complete the first setup on a new machine took an employee 100 minutes. Using an 80% incremental unit-time learning model indicates that the second setup on the new machine is expected to take ________. Select one: a. 70 minutes b. 80 minutes c. 120 minutes d. 60 minutesarrow_forward
- Social Media, Inc. (SMI) has two services for users. Toot!, which connects tutors with students who are looking for tutoring services, and TiX, which can be used to buy, sell, or exchange event tickets. For the following year, SMI expects the following results. Toot! TiX Total Users 10,700 18,100 28,800 Revenues $ 1,600,000 $ 1,440,000 $ 3,040,000 Engineering hours 8,200 6,200 14,400 Engineering cost $ 516,500 $ 635,500 $ 1,152,000 Administrative costs $ 921,600 Required: Compute the predetermined overhead rate used to apply administrative costs to the two services assuming SMI uses the number of usersto allocate administrative costs. Based on the rates computed in requirement (a), what is the profit for each service?arrow_forwardPerformance Aid, Inc. has two divisions: Test Preparation and Language Arts. Results (in millions) for the past three years are partially displayed here: Q.Complete the table by filling in the blanks.arrow_forwardClassify costs and make a quality-initiative decision (Learning Objective 5) Sinclair Corp. manufactures radiation-shielding glass panels . Suppose Sinclair is consider-ing spending the following amounts on a new TOM program :Strength-testing one item from each batch of panels ......................... . Training employees in TOM ................................................................. . Training suppliers in TOM .................................................................... . Identifying preferred suppliers that commit to on-time delivery ofperfect quality materials ................................................................... .Sinclair expects the new program to save costs through the following:Avoid lost profits from lost sales due to disappointed customers ....... Avoid rework and spoilage ................................................................. .. Avoid inspection of raw materials ........................................................ . Avoid…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
GE McKinsey Matrix for SBU Strategies; Author: Wolters World;https://www.youtube.com/watch?v=FffD1Ze76JQ;License: Standard Youtube License