Managerial Accounting
3rd Edition
ISBN: 9780077826482
Author: Stacey M Whitecotton Associate Professor, Robert Libby, Fred Phillips Associate Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 5, Problem 11E
Estimating Cost Behavior Using Least-Squares Regression
Refer to the Camp Rainbow data presented in E5-10.
1. Perform a least-square regression analysis on Camp Rainbow’s data.
2. Using the regression output, create a cost equation
3. Using the least-squares regression results, calculate the camps expected operating cost if 170 children attend a session.
4. Compare this estimated cost to the actual cost incurred dining week 7. Explain why these numbers might differ.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Carter Dry Cleaning has developed two regression analyses for cost estimation. The accounting manager has presented statistical measures for both of these regressions. Regression A has an R-squaredvalue of .53 and a t-value of 1.08. Regression B has an R-squared of .89 and a t-value of 2.17. Whatdo these statistical measures indicate about the regressions? Which regression should Carter DryCleaning use for cost estimation?
Use the information below or using Exhibit 12.14 on page 577 in Zelman to answer the following questions.
Calculate the per unit cost of an initial visit using both the conventional and ABC approaches.
Calculate the per unit cost of a regular visit using both the conventional and ABC approaches.
Calculate the per unit cost of an intensive visit using both the conventional and ABC approaches.
Exhibit 12-14
Basic data and calculation of unit costs using a conventional approach
Total Cost by Visit Type
Basic Data
A
B
C
D
Initial
Regular
Intensive
Total
(Given)
(Given)
(Given)
(A + B + C)
1
Number of visits
8,000
26,000
8,600
42,600
2
Direct materials (etc.)
$40,000
$50,000
$65,000
$155,000
3
Direct labor
$100,000
$120,000
$280,000
$500,000…
Least-Squares Regression Method; Scattergraph; Cost Behavior
Professor John Morton has just been appointed chairperson of the Finance Department at Westland University. In reviewing the department’s cost records. Professor Morton has found the following total cost associated with Finance 101 over the last five terms:
Professor Morton knows that there are some variable costs, such as amounts paid to graduate assistants, associated with the course. He would like to have the variable and fixed costs separated for planning purposes.
Required:
1. Prepare a scattergraph plot. (Plot total cost on the vertical axis and number of sections offered on the horizontal axis.)
2. Using the least-squares regression method, estimate the variable cost per section and the total fixed cost per term for Finance 101. Express these estimates in the form Y = a + bX.
3. Assume that because of the small number of sections offered during the Winter Term this year. Professor Morton will have to offer eight…
Chapter 5 Solutions
Managerial Accounting
Ch. 5 - Define each of the following terms variable cost,...Ch. 5 - Prob. 2QCh. 5 - Prob. 3QCh. 5 - Prob. 4QCh. 5 - Prob. 5QCh. 5 - Describe the three methods used to estimate cost...Ch. 5 - Prob. 7QCh. 5 - Prob. 8QCh. 5 - Prob. 9QCh. 5 - Prob. 10Q
Ch. 5 - Prob. 11QCh. 5 - Prob. 12QCh. 5 - Prob. 13QCh. 5 - Prob. 14QCh. 5 - Which of the following increases when activity...Ch. 5 - Prob. 2MCCh. 5 - Prob. 3MCCh. 5 - Consider the following information for a local...Ch. 5 - Prob. 5MCCh. 5 - Prob. 6MCCh. 5 - Prob. 7MCCh. 5 - Prob. 8MCCh. 5 - Prob. 9MCCh. 5 - Hathaway Corp, manufactures garden hoses. Last...Ch. 5 - Identifying Cost Behavior Heather Oak is trying to...Ch. 5 - Prob. 2MECh. 5 - Defining Cost Behavior Match each of the following...Ch. 5 - Prob. 4MECh. 5 - Defining Terms for the High-Low Method Indicate...Ch. 5 - Prob. 6MECh. 5 - Prob. 7MECh. 5 - Prob. 8MECh. 5 - Prob. 9MECh. 5 - Prob. 10MECh. 5 - Prob. 11MECh. 5 - Prob. 12MECh. 5 - Prob. 13MECh. 5 - Prob. 14MECh. 5 - Prob. 15MECh. 5 - Prob. 16MECh. 5 - Compare full absorption costing to variable...Ch. 5 - Identifying Cost Behavior Patterns Steve...Ch. 5 - Prob. 2ECh. 5 - Prob. 3ECh. 5 - Prob. 4ECh. 5 - Estimating Cost Behavior Using High-Low Method...Ch. 5 - Prob. 6ECh. 5 - Prob. 7ECh. 5 - Prob. 8ECh. 5 - Prob. 9ECh. 5 - Estimating Cost Behavior Using Scattergraph and...Ch. 5 - Estimating Cost Behavior Using Least-Squares...Ch. 5 - Comparing High-Low Method and Least-Squares...Ch. 5 - Preparing Contribution Margin Income Statement...Ch. 5 - Determining Cost Behavior, Preparing Contribution...Ch. 5 - Prob. 15ECh. 5 - Prob. 16ECh. 5 - Prob. 17ECh. 5 - Prob. 18ECh. 5 - Comparing Full Absorption Costing and Variable...Ch. 5 - Estimating Cost Behavior Using Least-Squares...Ch. 5 - Prob. 1.1GAPCh. 5 - Prob. 1.2GAPCh. 5 - Prob. 1.3GAPCh. 5 - Prob. 1.4GAPCh. 5 - Prob. 1.5GAPCh. 5 - Prob. 1.6GAPCh. 5 - Prob. 2.1GAPCh. 5 - Prob. 2.2GAPCh. 5 - Prob. 2.3GAPCh. 5 - Prob. 2.4GAPCh. 5 - Prob. 2.5GAPCh. 5 - Prob. 2.6GAPCh. 5 - Prob. 2.7GAPCh. 5 - Prob. 3.1GAPCh. 5 - Prob. 3.2GAPCh. 5 - Prob. 3.3GAPCh. 5 - Prob. 3.4GAPCh. 5 - Prob. 3.5GAPCh. 5 - Prob. 4.1GAPCh. 5 - Prob. 4.2GAPCh. 5 - Prob. 4.3GAPCh. 5 - Comparing Full Absorption and Variable Costing...Ch. 5 - Comparing Full Absorption and Variable Costing...Ch. 5 - Prob. 5.3GAPCh. 5 - Prob. 6.1GAPCh. 5 - Prob. 6.2GAPCh. 5 - Prob. 6.3GAPCh. 5 - Prob. 6.4GAPCh. 5 - Prob. 6.5GAPCh. 5 - Prob. 6.6GAPCh. 5 - Prob. 1.1GBPCh. 5 - Prob. 1.2GBPCh. 5 - Prob. 1.3GBPCh. 5 - Prob. 1.4GBPCh. 5 - Estimating Cost Behavior Using Scattergraph,...Ch. 5 - Prob. 1.6GBPCh. 5 - Prob. 2.1GBPCh. 5 - Estimating Cost Behavior Using Scattergraph,...Ch. 5 - Prob. 2.3GBPCh. 5 - Prob. 2.4GBPCh. 5 - Prob. 2.5GBPCh. 5 - Prob. 2.6GBPCh. 5 - Prob. 2.7GBPCh. 5 - Prob. 3.1GBPCh. 5 - Prob. 3.2GBPCh. 5 - Prob. 3.3GBPCh. 5 - Prob. 3.4GBPCh. 5 - Prob. 3.5GBPCh. 5 - Prob. 4.1GBPCh. 5 - Prob. 4.2GBPCh. 5 - Prob. 4.3GBPCh. 5 - Prob. 5.1GBPCh. 5 - Prob. 5.2GBPCh. 5 - Prob. 5.3GBPCh. 5 - Prob. 6.1GBPCh. 5 - Prob. 6.2GBPCh. 5 - Prob. 6.3GBPCh. 5 - Prob. 6.4GBPCh. 5 - Prob. 6.5GBPCh. 5 - Prob. 6.6GBP
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 regional transit authority for a major metropolitan area wants to determine whether there is a relationship between the age of a bus and the annual maintenance cost. A sample of 10 buses resulted in the following data: Develop a scatter chart for these data. What does the scatter chart indicate about the relationship between age of a bus and the annual maintenance cost? Use the data to develop an estimated regression equation that could be used to predict the annual maintenance cost given the age of the bus. What is the estimated regression model? Test whether each of the regression parameters β0 and β1 is equal to zero at a 0.05 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? How much of the variation in the sample values of annual maintenance cost does the model you estimated in part (b) explain? What do you predict the annual maintenance cost to be for a 3.5-year-old bus?arrow_forwardMethod of Least Squares Refer to the information for Luisa Crimini on the previous page. Required: 1. Using a computer spreadsheet program such as Excel, run a regression on these data. Based on the regression output, write the cost formula for tanning. (Note: Round the fixed cost to the nearest dollar and the variable rate to the nearest cent.) 2. Using the formula computed in Requirement 1, what is the predicted cost of tanning services for September for 2,500 appointments? Use the following information for Exercises 3-44 through 3-46: Luisa Crimini has been operating a beauty shop in a college town for the past 10 years. Recently, Luisa rented space next to her shop and opened a tanning salon. She anticipated that the costs for the tanning service would primarily be fixed, but found that tanning salon costs increased with the number of appointments. Costs for this service over the past 8 months are as follows:arrow_forwardThe 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: Week 1 2 3 4 5 6 7 8 Number of Cost to Run Camp $10,010 Campers 138 94 162 116 124 132 152 168 8,280 11,360 Required 4 Required 5 9,870 9,030 Required: 4. Using the high-low method, calculate Camp Rainbow's total fixed operating costs and variable operating cost per child. 5. Using the high-low method results, calculate the camp's expected operating cost if 152 children attend a session. 11,890 12,110 12,720 Complete this question by entering your answers in the tabs below. Fixed Cost Variable Cost per Child Using the high-low method, calculate Camp Rainbow's total fixed operating costs and variable operating cost per child. (Round your…arrow_forward
- PLEASE USE THIS TIME TO ANSWER THIS. AYAW NA PAGHULAT UG DEADLINE, TOMORROW IS ANOTHER DAY. PLEASE DEFINE AND GIVE THE FORMULA OF THE FOLLOWING (IF THERE IS ANY): PLEASE ANSWER HERE DIRECTLY 1. absorption costing 2. activity bases (drivers) 3. break-even polnt 4. contributlon margin 5. contributlon margin ratlo 6. cost behavlor 7. cost-volume-profit analysls 8. cost-volume-profit chartarrow_forwardAnalysis of Regression Results Wang Manufacturing uses regression analysis to predict manufacturing overhead costs based on direct labor hours and/or machine hours and has developed thethree following regression equations:Regression 1 Regression 2 Regression 3SE 33,844 45,383 31,044R-squared 0.55 0.35 0.58t-values:Direct labor hours 2.3 1.9Machine hours 1.1 0.8Required Which regression would you choose and why?arrow_forwardRefer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Company’s purchasing cost and number of purchase orders.The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Intercept 15,021 (rounded to the nearest dollar)X variable 1 9.74 (rounded to the nearest cent) Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the vari-able rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchaseorders, what is the total estimated purchasing cost for that month? (Round your answer tothe nearest dollar.)3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year andexpects 5,340 purchase orders? What will estimated total purchasing cost be? (Round youranswer to the nearest dollar.) What is the total fixed purchasing cost? Why doesn’t it equalthe fixed cost calculated in Requirement 1?arrow_forward
- Refer to the pictur ebelow: Find: 1. Total Cost of Product A under ABC System2. Total Cost of Product B under ABC System3. Selling Price per unit of Product B assuming profit margin of 20% above costarrow_forwardMethod of Least Squares, Developing and Using the Cost Formula The method of least squares was used to develop a cost equation to predict the cost of receiving purchased parts at a video game manufacturer. Ninety-six data points from monthly data were used for the regression. The following computer output was received: Intercept 147,400 Slope 210 The cost driver used was number of parts inspected. Required: 1. What is the cost formula? Total cost of receiving = $ + ( $ × ) 2. Using the cost formula from Requirement 1, identify each of the following: independent variable, dependent variable, Variable rate per professional hour, and fixed cost per month. Independent variable Dependent variable Variable rate per professional hour per part inspected Fixed cost per month 3. Using the cost formula, predict the cost of receiving for a month in which 6,800 parts are inspected. Total cost of receiving = $ Identifying the Parts of the Cost Formula;…arrow_forwardYour boss would like you to estimate the fixed and variable components of a particular cost Actual data for this cost over four recent periods appear below. Activity Cost Period 1 22 235 Period 2 23 243 Period 3 25 255 Period 4 20 227 Using the least-squares regression method, what is the cost formula for this cost? Y = P107.45 + P5.89X O Y = P0.00 + P10.67X O Y = P111.92 + P5.69X O Y = P120.81 + P3.56Xarrow_forward
- The following terms are used to describe various economic characteristics of costs.a. Opportunity costb. Out-of-pocket costc. Sunk costd. Differential coste. Marginal costf. Average costRequired: Choose one of the terms listed above to characterize each of the amounts described below.1. The cost of feeding 500 children in a public school cafeteria is $800 per day, or $1.60 per child per day. What economic term describes this $1.60 cost?2. The cost of including one extra child in a day-care center.3. The cost of merchandise inventory purchased two years ago, which is now obsolete.4. The management of a high-rise office building uses 2,500 square feet of space in the building for its own management functions. This space could be rented for $250,000. What economic term describes this $250,000 in lost rental revenue?5. The cost of building an automated assembly line in a factory is $800,000. The cost of building a manually operated assembly line is $375,000. What economic term is used to…arrow_forwardSpecifically, Mr. Schaefer wants you to do the following: PART 1. Prepare a cost-volume-profit (CVP) analysis of the proposal's financial implications. 1. Specifically, prepare an analysis that includes the projected revenue, variable costs, and fixed costs for enrollment levels of 20, 25, 30 and 37 students using the monthly projections in Attachment A of the case. 2. Then, compute the weighted average contribution margin (CM) per student (computed as the total CM divided by the number of students enrolled) and 3. The number of students that need to enroll at each of the four levels of enrollment for the center to break even. For this analysis, I have provided an Excel template in which I have already sorted variable and fixed costs: I have included the raw data. Note: Your enrollment information has already been weighted so you will not need to calculate weights for your weighted average CM.arrow_forwardMethod of Least Squares, Developing and Using the Cost Formula The method of least squares was used to develop a cost equation to predict the cost of receiving purchased parts at a video game manufacturer. Ninety-six data points from monthly data were used for the regression. The following computer output was received: Intercept 175,600 Slope 455 The cost driver used was number of parts inspected. Required: 1. What is the cost formula? Total cost of receiving = $ + ( $ × ) 2. Using the cost formula from Requirement 1, identify each of the following: independent variable, dependent variable, Variable rate per professional hour, and fixed cost per month. Independent variable Dependent variable Variable rate per professional hour per part inspected Fixed cost per month 3. Using the cost formula, predict the cost of receiving for a month in which 7,200 parts are inspected. Total cost of receiving = $arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningEssentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.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
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
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
How to Estimate Project Costs: A Method for Cost Estimation; Author: Online PM Courses - Mike Clayton;https://www.youtube.com/watch?v=YQ2Wi3Jh3X0;License: Standard Youtube License