Managerial Accounting
null Edition
ISBN: 9781260195408
Author: Whitecotton
Publisher: MCG
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
Tom uses his computer to calculate the following regression formula:Weekly total costs = $18,791 + ($19.97 * Number of orders per week) Draw the regression line on your graph. Use your graph to evaluate the regression line using the criteria of economic plausibility, goodness of fit, and significance of the independent variable. Is the cost function estimated using the high-low method a close approximation of the cost function estimated using the regression method? Explain briefly.
Please see attached. Help me with the following question.
1. What is another name for the “line of best fit” in Excel? What is the purpose of this line?
b. Using the “line of best fit”, determine Angla Ruston University’s fixed cost per month and the variable costper student. (Use 0 & 2,500 students.)
c. Based on the scatter gram, what is the equation of the total mixed cost function?
Specifically, 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.
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
- Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys 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: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?arrow_forwardUsing Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Pizza Vesuvio on the previous page. Coefficients shown by a regression program for Pizza Vesuvios data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of labor and the variable rate per employee hour. 2. Construct the cost formula for total labor cost. 3. Calculate the budgeted cost for next month, assuming that 675 employee hours are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-17 through 3-20: Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:arrow_forwardWeber Valley Regional Hospital has collected data on all of its activities for the past 16 months. Data for cardiac nursing care follow: Required: 1. Using the high-low method, calculate the variable rate per hour and the fixed cost for the nursing care activity. 2. Run a regression on the data, using hours of nursing care as the independent variable. Predict cost for the cardiac nursing care for September Year 2 if 1,400 hours of nursing care are forecast. Evaluate the regression equation. How comfortable are you with the predicted cost for September Year 2? 3. Upon looking into the events that happened at the end of Year 1, you find that the cardiology ward bought a cardiac-monitoring machine for the nursing station. Administrators also decided to add a new supervisory position for the evening shift. Monthly depreciation on the monitor and the salary of the new supervisor together total 10,000. Now, run two regression equations, one for the observations from Year 1 and the second using only the observations for the eight months in Year 2. Discuss your findings. What is your predicted cost of the cardiac nursing care activity for September Year 2?arrow_forward
- Method 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_forwardUsing Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Speedy Petes on the previous page. Coefficients shown by a regression program for Speedy Petes data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of deliveries and the variable rate per delivery. 2. Construct the cost formula for total delivery cost. 3. Calculate the budgeted cost for next month, assuming that 3,000 deliveries are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-26 through 3-29: Speedy Petes is a small start-up company that delivers high-end coffee drinks to large metropolitan office buildings via a cutting-edge motorized coffee cart to compete with other premium coffee shops. Data for the past 8 months were collected as follows:arrow_forwardThe 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_forward
- Recent monthly costs of providing on-board flight service incurred by Great Plains Airlines are shown in the following table. Required:1. Build a spreadsheet: Construct an Excel spreadsheet and use the Excel commands to perform a least-squares regression. Estimate the cost behavior of the airline’s on-board flight service. Express the cost behavior in equation form.2. Use Excel to calculate and interpret the R2 value for the regression.arrow_forwardCost estimation, learning curves (continuation of 10-44). Inbee is concerned that she still does not understand the relationship between output and labor consumption. She consults with Jim Park, the head of engineering, and shares the results of her regression estimation. Jim indicates that the production of new smartphone models exhibits significant learning effects—as Hankuk gains experience with production, it can produce additional units using less time. He suggests that it is more appropriate to specify the following relationship: where x is cumulative production in units, y is the cumulative average direct labor-hours per unit (i.e., cumulative DLH divided by cumulative production), and a and b are parameters of the learning effect. To estimate this, Inbee and Jim use the original data to calculate the cumulative output and cumulative average labor-hours per unit for each month. They then take natural logarithms of these variables in order to be able to estimate a regression…arrow_forwarda) Determine the variable cost per unit and the fixed cost using the high-low method. b) What is the equation of the total mixed cost function? c) Prepare the scatter diagram, clearly showing any outliers. d) Using the line of best-fit, determine the company’s fixed cost per month and the variable cost per unit. (Use 0 & 5,000 units.) e) In view of the department’s cost behavior pattern, which of the two methods appear more appropriate? Explain your answerarrow_forward
- Curry Rubber manufactures rubber bands for retail companies. The accounting manager has performed a regression analysis of past data. You notice that the formula has an R-squared of 0.68, a t-value of 2.2, and a standard error of the estimate of $218,200. The estimate for next quarter costs is $2,597,623. Calculate Standard Error as a % of predicted total cost which represents a measure of precision of his regression analysis? (Round your answer to one decimal place, i.e., 0.052 = 5.2%.)arrow_forwardMethod of Least Squares, Predicting Cost for Different Time Periods from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. However, assume that Tracy has used the method of least squares on the receiving data and has gotten the following results: Required: 1. Using the results from the method of least squares, prepare a cost formula for the receiving activity. 2. Using the formula from Requirement 1, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? (Note: Round your answer to the nearest dollar.) 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated?arrow_forwardScattergraph, High-Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. Required: 1. Prepare a scattergraph based on the 10 months of data. Does the relationship appear to be linear? 2. Using the high-low method, prepare a cost formula for the receiving activity. Using this formula, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated? Use the following information for Problems 3-60 and 3-61: Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controllers department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows: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 LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher: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 Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
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
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
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