HORNGRENS COST ACCOUNTING W/ACCESS
16th Edition
ISBN: 9781323687604
Author: Datar
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 10, Problem 10.39P
Interpreting regression results. Spirit Freightways is a leader in transporting agricultural products in the western provinces of Canada. Reese Brown, a financial analyst at Spirit Freightways, is studying the behavior of transportation costs for budgeting purposes. Transportation costs at Spirit are of two types: (a) operating costs (such as labor and fuel) and (b) maintenance costs (primarily overhaul of vehicles). Brown gathers monthly data on each type of cost, as well as the total freight miles traveled by Spirit vehicles in each month. The data collected are shown below (all in thousands):
- 1. Conduct a regression using the monthly data of operating costs on freight miles. You should obtain the following result:
Regression: Operating costs = a + (b × Number of freight miles)
- 2. Plot the data and regression line for the above estimation. Evaluate the regression using the criteria of economic plausibility, goodness of fit, and slope of the regression line.
- 3. Brown expects Spirit to generate, on average, 3,600 freight miles each month next year. How much in operating costs should Brown budget for next year?
- 4. Name three variables, other than freight miles, that Brown might expect to be important cost drivers for Spirit’s operating costs.
- 5. Brown next conducts a regression using the monthly data of maintenance costs on freight miles. Verify that she obtained the following result:
Regression: Maintenance costs = a + (b × Number of freight miles)
- 6. Provide a reasoned explanation for the observed sign on the cost driver variable in the maintenance cost regression. What alternative data or alternative regression specifications would you like to use to better capture the above relationship?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Provide a reasoned explanation for the observed sign on the cost driver variable in the maintenance cost regression. What alternative data or alternative regression specifications would you like to use to better capture the above relationship?
Nation’s Capital Fitness, Inc. operates a chain of fitness centers in the Washington, D.C., area. The firm’s controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern of the firm’s equipment maintenance costs must be determined. The accounting staff has suggested the use of an equation, in the form of Y = a + bX, for maintenance costs. Data regarding the maintenance hours and costs for last year are as follows: (image below)
Required:1. Using the high-low method of cost estimation, estimate the behavior of the maintenance costs incurred by Nation’s Capital Fitness, Inc. Express the cost behavior pattern in equation form.2. Using your answer to requirement (1), what is the variable component of the maintenance cost?3. Compute the predicted maintenance cost at 590 hours of activity.4. Compute the variable cost per hour and the fixed cost per hour at 600 hours of activity. Explain why the fixed cost per hour could be…
Nation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The firm's
controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern
of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of an
equation, in the form of Y= a + bX, for maintenance costs. Data regarding the maintenance hours and costs for last year
are as follows:
Month
January
February
March
April
May
June
July
August
September
October
November
December
Total
Average
Hours of
Maintenance
Service
Variable maintenance cost
560
480
280
470
350
460
320
430
490
380
350
340
4,910
409
$
Maintenance
Costs
$ 5,110
4,240
2,730
4,300
3,030
4, 120
PR 6-38 (Algo) Part 2 What is the variable component of the maintenance cost?
2. Using your answer to requirement 1, what is the variable component of the maintenance cost?
Note: Round your answer to 2 decimal places.
3,000
3,590…
Chapter 10 Solutions
HORNGRENS COST ACCOUNTING W/ACCESS
Ch. 10 - What two assumptions are frequently made when...Ch. 10 - Describe three alternative linear cost functions.Ch. 10 - What is the difference between a linear and a...Ch. 10 - High correlation between two variables means that...Ch. 10 - Name four approaches to estimating a cost...Ch. 10 - Describe the conference method for estimating a...Ch. 10 - Describe the account analysis method for...Ch. 10 - List the six steps in estimating a cost function...Ch. 10 - When using the high-low method, should you base...Ch. 10 - Describe three criteria for evaluating cost...
Ch. 10 - Define learning curve. Outline two models that can...Ch. 10 - Discuss four frequently encountered problems when...Ch. 10 - Prob. 10.13QCh. 10 - All the independent variables in a cost function...Ch. 10 - Multicollinearity exists when the dependent...Ch. 10 - HL Co. uses the high-low method to derive a total...Ch. 10 - A firm uses simple linear regression to forecast...Ch. 10 - In regression analysis, the coefficient of...Ch. 10 - A regression equation is set up, where the...Ch. 10 - What would be the approximate value of the...Ch. 10 - Estimating a cost function. The controller of the...Ch. 10 - Identifying variable-, fixed-, and mixed-cost...Ch. 10 - Various cost-behavior patterns. (CPA, adapted)....Ch. 10 - Matching graphs with descriptions of cost and...Ch. 10 - Account analysis, high-low. Stein Corporation...Ch. 10 - Account analysis method. Gower, Inc., a...Ch. 10 - Prob. 10.27ECh. 10 - Estimating a cost function, high-low method. Lacy...Ch. 10 - Linear cost approximation. Dr. Young, of Young and...Ch. 10 - Cost-volume-profit and regression analysis....Ch. 10 - Regression analysis, service company. (CMA,...Ch. 10 - High-low, regression. May Blackwell is the new...Ch. 10 - Learning curve, cumulative average-time learning...Ch. 10 - Learning curve, incremental unit-time learning...Ch. 10 - High-low method. Wayne Mueller financial analyst...Ch. 10 - High-low method and regression analysis. Market...Ch. 10 - High-low method; regression analysis. (CIMA,...Ch. 10 - Regression, activity-based costing, choosing cost...Ch. 10 - Interpreting regression results. Spirit...Ch. 10 - Cost estimation, cumulative average-time learning...Ch. 10 - Cost estimation, incremental unit-time learning...Ch. 10 - Regression; choosing among models. Apollo Hospital...Ch. 10 - Multiple regression (continuation of 10-42). After...Ch. 10 - Cost estimation. Hankuk Electronics started...Ch. 10 - Prob. 10.45PCh. 10 - Interpreting regression results, matching time...Ch. 10 - Purchasing department cost drivers, activity-based...Ch. 10 - Purchasing department cost drivers, multiple...
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
- Nation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The firm's controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of an equation, in the form of Y= a + bX, for maintenance costs. Data regarding the maintenance hours and costs for last year are as follows: Month January February March April May June July August September October November December Total Average Hours of Maintenance Service 560 480 280 470 350 Monthly maintenance cost = 460 320 430 490 380 350 340 4,910 409 Maintenance Costs $ 5,110 4,240 2,730 4,300 3,030 4,120 3,000 3,590 4,000 3,220 3,170 3,070 $ 43,580 $ 3,632 PR 6-38 (Algo) Part 1 Estimate the behavior of the maintenance costs incurred... Required: 1. Using the high-low method of cost estimation, estimate the behavior of the maintenance…arrow_forwardNation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The firm's controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of an equation, in the form of Y = a + bX, for maintenance costs. Data regarding the maintenance hours and costs for last year are as follows: Month January February March April May June July August September October November December Total Average Hours of Maintenance Service Variable maintenance cost 520 470 250 490 340 470 330 410 480 380 390 340 4,870 406 Maintenance Costs $ 5,305 4,170 2,740 4,280 3,050 4,160 3,040 3,570 3,990 3,230 3,170 3,120 $ 43,825 $ 3,652 2. Using your answer to requirement 1, what is the variable component of the maintenance cost? Note: Round your answer to 2 decimal places. ********* per hourarrow_forwardNation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The firm's controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of an equation, in the form of Y= a + bx, for maintenance costs. Data regarding the maintenance hours and costs for last year are as follows: Month January February March April May June July August September October November December Total Average Hours of Maintenance Service 560 480 280 470 350 460 320 430 490 380 350 340 4,910 409 Maintenance cost Maintenance Costs $ 5,110 4,240 2,730 4,300 3,030 4, 120 3,000 3,590 4,000 3,220 3,170 3,070 $ 43,580 $ 3,632 PR 6-38 (Algo) Part 3 Compute the predicted maintenance cost... 3. Compute the predicted maintenance cost at 670 hours of activity. Answer is complete but not entirely correct. $ 49,192 Xarrow_forward
- a) Provincial Packages, Inc. operates a local parcel delivery service. The company keeps detailed records relating to operating costs of trucks, and has found that if a truck is driven 122,000 kilometres per year, the operating cost is 8.5 cents per kilometre. This cost increases to 9.25 cents per kilometre if a truck is driven 72,000 kilometres per year. Required: Estimate the cost formula for truck operating costs using the high-low method. Accessibility: Investigate Focusarrow_forwardJensen Tire Auto is deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars). a. Develop a scatter chart with weekly usage hours as the independent variable. What does the scatter chart indicate about the relationship between weekly usage and annual maintenance expense? b. Use the data to develop an estimated regression equation that could be used to predict the annual maintenance expense for a given number of hours of weekly usage. What is the estimated regression model? c. 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? d. How much of the variation in the sample values of annual maintenance expense does the model you estimated in part (b) explain? e. If the maintenance contract costs 3,000 per year, would you recommend purchasing it? Why or why not?arrow_forwardFriendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forward
- The Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to forecast annual sales because previous forecasts have been inaccurate. The new sales forecast will be used to initiate the budgeting process and to identify more completely the underlying process that generates sales. Larry Husky, the controller of Lockit, has considered many possible independent variables and equations to predict sales and has narrowed his choices to four equations. Husky used annual observations from 20 prior years to estimate each of the four equations. Following are definitions of the variables used in the four equations and a statistical summary of these equations: St=ForecastedsalesindollarsforLockitinperiodtSt1=ActualsalesindollarsforLockitinperiodt1Gt=ForecastedU.S.grossdomesticproductinperiodtGt1=ActualU.S.grossdomesticproductinperiodt1Nt1=Lockitsnetincomeinperiodt1 Required: 1. Write Equations 2 and 4 in the form Y = a + bx. 2. If actual sales are 1,500,000 in the current year, what would be the forecasted sales for Lockit in the coming year? 3. Explain why Larry Husky might prefer Equation 3 to Equation 2. 4. Explain the advantages and disadvantages of using Equation 4 to forecast sales.arrow_forwardArmer Company is accumulating data to use in preparing its annual profit plan for the coming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff has suggested the use of linear regression to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis follow: Maintenance Machine Month Cost Hours $ 4,200 Jan. 480 Feb. 3,000 320 Mar. 3,600 400 Apr. 2,820 300 May 4,350 500 June 2,960 310 July 3,030 320 Aug. 4,470 520 Sept. 4,260 490 Oct. 4,050 470 Nov. 3,300 350 Dec. 3,160 340 Sum $43, 200 4,800 $ 3,600 $ $ $ 684.65 Average 400 Average cost per hour a (intercept) b (coefficient) 9.00 7.2884 Standard error of the estimate 34.469 R-squared 0.99724 t-value for b 60.105 At 400 hours of activity, Armer management can be approximately two-thirds confident that the maintenance costs will be in the range ofarrow_forwarda) Calculate the contribution margin per unit.b) Calculate the number of units Beauty Supplies Company must sell each year to break even.c) Calculate the number of units Beauty Supplies Company must sell to yield a profit of $160,000.d) Managers may use Sensitivity analysis in their accounting system.i) What is sensitivity analysis? ii) How is Sensitivity analysis useful to managers?arrow_forward
- Plot the relationship between promotional costs and ticket revenues. Also draw the regression line and evaluate it using the criteria of economic plausibility, goodness of fit, and slope of the regression line.arrow_forwardVice President for Sales and Marketing at Waterways Corporation is planning for production needs to meet sales demand in the coming year. He is also trying to determine how the company's profits might be increased in the coming year. This problem asks you to use cost-volume-profit concepts to help Waterways understand contribution margins of some of its products and decide whether to mass-produce any of them. Waterways markets a simple water control and timer that it mass-produces, Last year, the company sold 630,000 units at an average unit selling price of $4.40. The variable costs were $1,663,200, and the fixed costs were $742,896. Show Transcribed Text Margin of safety in dollars What is the margin of safety, both in dollars and as a ratio? (Round ratio to 0 decimal places, e.g. 25%.) Margin of safety ratio 3 $ Ć %arrow_forwardMeargia Plastics is evaluating its plastic bottles division. The accounting manager has come up with the following data for the year: contribution margin of $570,000, controllable fixed of $228,000, and noncontrollable fixed costs of $57,000. Required: 1. What is the controllable margin? Controllable Margin 2. What is the total contribution by profit center (CPC)?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Essentials 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 College
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher: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
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY