Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
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
You wish to take an Excel course. You may enroll at one within your school or you may take a community class at the local library. You've gathered the following information to aid in your decision-making process:
Costs/Benefits
College Course
Community Course
Cost
$4,300
$1,190
Distance to course
0.20 miles (walking distance)
18 miles (driving distance)
Timing of course
Weekday
Weekend
Number of meetings
16
8
Qualitative considerations
Convenience, quality of instruction
Flexibility, brief duration
Pretend transportation (gas, mileage, and parking) cost $220 per class session at the library. If you consider solely the cost - including transportation - of each alternative, which would you choose?
Multiple Choice
College course
Community course
Both alternatives
Neither alternative
Full of Hope Center Operations
Recent Operations
Presently, the Full of Hope Center facility accommodates a maximum of 20 children at one time, although more children enroll and attend part-time. Sometimes, especially during school vacations, daily attendance is less than 20. Hours are from 7:00 a.m. until 6:00 p.m. each weekday, with lunch and snacks provided for the children. The fee is $500 per week per child, with payment due at the beginning of each week. However, fee payments often trickle in during the week as the services are provided. Each day, three employees operate the Full of Hope Center—the salaried director, one full-time employee, and one part-time emplo
But, within a few days, Ruth noticed the cash collected did not match the number of children she observed at the Center during the week. When Ruth asked Miriam if there was additional cash that had been collected, Miriam reached into a desk drawer and handed Ruth currency that totalled $1,000. Miriam explained that…
Full of Hope Center Operations
Recent Operations
Presently, the Full of Hope Center facility accommodates a maximum of 20 children at one time, although more children enroll and attend part-time. Sometimes, especially during school vacations, daily attendance is less than 20. Hours are from 7:00 a.m. until 6:00 p.m. each weekday, with lunch and snacks provided for the children. The fee is $500 per week per child, with payment due at the beginning of each week. However, fee payments often trickle in during the week as the services are provided. Each day, three employees operate the Full of Hope Center—the salaried director, one full-time employee, and one part-time emplo
But, within a few days, Ruth noticed the cash collected did not match the number of children she observed at the Center during the week. When Ruth asked Miriam if there was additional cash that had been collected, Miriam reached into a desk drawer and handed Ruth currency that totalled $1,000. Miriam explained that…
Chapter 6 Solutions
Managerial Accounting (5th Edition)
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
- Thames Assurance Company sells a variety of life and health insurance products. Recently, Thames developed a long-term care policy for sale to members of university and college alumni associations. Thames estimated that the sale and service of this type of policy would be subject to a 90 percent cumulative average-time learning curve model. Each unit consists of 350 policies sold. The first unit is estimated to take 1,000 hours to sell and service. Required: 1. Set up a table with columns for cumulative number of units, cumulative average time per unit in hours, and the cumulative total time in hours. Complete the table for 1, 2, 4, 8, 16, and 32 units. 2. Suppose that Thames revises its assumption to an 80 percent learning curve. How will this affect the amount of time needed to sell and service eight units? How do you suppose that Thames estimates the percent learning rate?arrow_forwardRequired information Camp Rainbow offers overnight summer camp programs for children ages 10-14 every summer during June and July. Each camp session is one week and can accommodate up to 200 children. The camp is not coed, so boys attend during the odd-numbered weeks and girls attend during the even-numbered weeks. While at the camp, participants make crafts, participate in various sports, help care for the camp's resident animals, have cookouts and hayrides, and help assemble toys for local underprivileged children. The camp provides all food as well as materials for all craft classes and the toys to be assembled. One cabin can accommodate up to 10 children, and one camp counselor is assigned to each cabin. Three camp managers are on-site regardless of the number of campers enrolled. Following is the cost information for Camp Rainbow's operations last summer: Number of Cost to Run Week Campers Camp $14,420 188 2 116 9,150 14,440 10,08০ 10,090 14,410 8,750 11,370 3 174 4 142 146 176 7…arrow_forwardShow all work using Excel formulas (you must submit an Excel worksheet showing your work) FPPT Clinic offers Family Practice and Physical Therapy services at its location. The Family Practice Department generates $4,000,000 in revenue per year and the Physical Therapy Department generates $850,000 in revenue per year. The Family Practice Department occupies 80,000 square feet and the Physical Therapy Department occupies 40,000 square feet. Expenses for the departments are: Salaries/Wages & Benefits Other Expenses Family Practice $1,885,000 $1,226,000 Physical Therapy $400,000 $261,111 The Clinic is supported by three cost centers - Human Resources, Accounting, and Housekeeping services. Cost for those services are: Human Resources: $100,000 Accounting: $100,000 Housekeeping: $75,000 Allocate the costs for each of the three cost centers to the Family Practice Department and Physical Therapy Department. For each cost center, select a driver that you think is fair and allocate the cost…arrow_forward
- St. Johns Medical Center (SJMC) has five medical technicians who are responsible for conducting cardiac catheterization testing in SJMCs Cath Lab. Each technician is paid a salary of 36,000 and is capable of conducting 1,000 procedures per year. The cardiac catheterization equipment is one year old and was purchased for 250,000. It is expected to last five years. The equipments capacity is 25,000 procedures over its life. Depreciation is computed on a straight-line basis, with no salvage value expected. The reading of the catheterization results is conducted by an outside physician whose fee is 120 per test. The technicians report with the outside physicians note of results is sent to the referring physician. In addition to the salaries and equipment, SJMC spends 50,000 for supplies and other costs needed to operate the equipment (assuming 5,000 procedures are conducted). When SJMC purchased the equipment, it fully expected to perform 5,000 procedures per year. In fact, during its first year of operation, 5,000 procedures were run. However, a larger hospital has established a clinic in the city and will siphon off some of SJMCs business. During the coming years, SJMC expects to run only 4,200 cath procedures yearly. SJMC has been charging 850 for the procedureenough to cover the direct costs of the procedure plus an assignment of general overhead (e.g., depreciation on the hospital building, lighting and heating, and janitorial services). At the beginning of the second year, an HMO from a neighboring community approached SJMC and offered to send its clients to SJMC for cardiac catheterization provided that the charge per procedure would be 550. The HMO estimates that it can provide about 500 patients per year. The HMO has indicated that the arrangement is temporaryfor one year only. The HMO expects to have its own testing capabilities within one year. Required: 1. Classify the resources associated with the cardiac catheterization activity into one of the following: (1) committed resources, or (2) flexible resources. 2. Calculate the activity rate for the cardiac catheterization activity. Break the activity rate into fixed and variable components. Now, classify each activity resource as relevant or irrelevant with respect to the following alternatives: (1) accept the HMO offer, or (2) reject the HMO offer. Explain your reasoning. 3. Assume that SJMC will accept the HMO offer if it reduces the hospitals operating costs. Should the HMO offer be accepted? 4. Jerold Bosserman, SJMCs hospital controller, argued against accepting the HMOs offer. Instead, he argued that the hospital should be increasing the charge per procedure rather than accepting business that doesnt even cover full costs. He also was concerned about local physician reaction if word got out that the HMO was receiving procedures for 550. Discuss the merits of Jerolds position. Include in your discussion an assessment of the price increase that would be needed if the objective is to maintain total revenues from cardiac catheterizations experienced in the first year of operation. 5. Chandra Denton, SJMCs administrator, has been informed that one of the Cath Lab technicians is leaving for an opportunity at a larger hospital. She met with the other technicians, and they agreed to increase their hours to pick up the slack so that SJMC wont need to hire another technician. By working a couple hours extra every week, each remaining technician can perform 1,050 procedures per year. They agreed to do this for an increase in salary of 2,000 per year. How does this outcome affect the analysis of the HMO offer? 6. Assuming that SJMC wants to bring in the same revenues earned in the cardiac catheterization activitys first year less the reduction in resource spending attributable to using only four technicians, how much must SJMC charge for a procedure?arrow_forwardThe actual and planned data for Underwater University for the Fall term were as follows: Actual Planned Enrollment 4,500 4,125 Tuition per credit hour $120 $135 Credit hours 60,450 43,200 Registration, records, and marketing costs per enrolled student $275 $275 Instructional costs per credit hour $64 $60 Depreciation on classrooms and equipment $825,600 $825,600 Registration, records, and marketing costs vary by the number of enrolled students, while instructional costs vary by the number of credit hours. Depreciation is a fixed cost. Prepare a variable costing income statement showing the contribution margin and operating income for the Fall term. Underwater University Variable Costing Income Statement For the Fall Term Revenue $ Variable costs: Registration, records, and marketing costs $ Instructional costs Total variable costs $ Contribution margin $ Depreciation on classrooms and equipment Operating income…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
- MASTERY PROBLEMBarry Bird opened the Barry Bird Basketball Camp for children ages 10through 18. Campers typically register for one week in June or July,arriving on Sunday and returning home the following Saturday. Collegeplayers serve as cabin counselors and assist the local college and high school coaches who run the practice sessions. The registration feeincludes a room, meals at a nearby restaurant, and basketballinstruction. In the off-season, the facilities are used for weekend retreatsand coaching clinics. Bird developed the following chart of accounts forhis service business: The following transactions took place during the month of June:June 1 Bird invested cash in the business, $10,000.1 Purchased basketballs and other athletic equipment, $3,000. 2 Paid Hite Advertising for flyers that had been mailed to prospectivecampers, $5,000.2 Collected registration fees, $15,000.2 Rogers Construction completed work on a new basketball court thatcost $12,000. Arrangements were made to…arrow_forwardQuestion ENGINEERING ECONOMICS You want to launch a printing services business on campus. The initial cost to get the business running with a September 1st launch date would be $2,000. You estimate that the revenues would approximately offset your costs (e.g. paper, toner, etc.) in the first month of operation so that the monthly profit would be $0. Afterwards, you estimate that profits would increase by $80 each month until the end of the academic year (i.e. $80 profit in October, $160 profit in November, etc. until the end of April). Your annual MARR is 10%, compounded monthly. (a) Calculate the internal rate of return for your investment based on an 8 months study period. Select the appropriate IRR between options 1 to 4 below. (b) Suppose that you now consider another investment opportunity for your printing business services, also with monthly profits, and the internal rate of return of 3%. Is this alternative economically feasible based on IRR?arrow_forwardJones Oil and Lube is a car care center specializing in ten-minute oil changes. Jones Oil and Lube has two service bays, which limits its capacity to 3,400 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,700arrow_forward
- Cameron Street Barber Shop pays $5 per month for water for the first 14,000 gallons and $3.25 per thousand gallons above 14,000 gallons. Calculate the total water cost when the barber shop uses 13,000 gallons, 16,000 gallons, and 20,000 gallons. Question content area bottom Part 1 (Do not round interim calculations. Round your final answers to the nearest cent.) Usage Total Water Cost 13,000 gallons 16,000 gallons 20,000 gallonsarrow_forwardACE Math Academy provides math help for high school students. The organizations believes a small group learning environment allows students to become more comfortable in asking questions while being able to learn from other students. As a result, each instructor is expected to have a class of six students and each session is two hours long. There are four instructors and they are each being paid $35 per hour. Each session is expected to cost $30 for the student. For the month of June, the company expects 120 sessions. By the end of the month the company noticed everything has met expectations expect the following Instructors were being paid at $40 per hour There were a total of 100 sessions in the month students paid 34 per session A) Calculate the selling price variance for the month. B) Calculate the rate and efficiency variance per hour for direct labor C) Calculate the total direct labor flexible budget variancearrow_forwardProblem 4) ABC Manufacturing manufactures one type of pontoon boat: Model A. The beginning inventory of the pontoon boats is 1,200 units. Capacity is limited to the following number of boats each month: 3,000. Demand for the pontoon boats for the next 6 months is: 1,500 in Month 1, 1,800 in Month 2, 3,000 in Month 3, 1,800 in Month 4, 1,700 in Month 5, and 1,600 in Month 6. The production cost per unit in Months 1, 2, & 3= $6,420. The production cost per unit in Months 4, 5, & 6= $3,200. Holding costs are assessed on Ending Inventory each month. The holding cost per unit in Months 1, 2, & 3 = $1,310. The holding cost per unit in Months 4, 5, & 6 = $950. Management has specified that the ending inventory in Month 2 must be at least 408 units and that no backorders are allowed in any period. Formulate a linear programming model to minimize total cost over the 6 months. Use the headings listed below in your model formulation: Decision Variables: Objective Function: Constraints: Additional…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