Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
16th Edition
ISBN: 9780134475585
Author: Srikant M. Datar, Madhav V. Rajan
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 10, Problem 10.37P
High-low method; regression analysis. (CIMA, adapted) Catherine McCarthy, sales manager of Baxter Arenas, is checking to see if there is any relationship between promotional costs and ticket revenues at the sports stadium. She obtains the following data for the past 9 months:
| Month | Ticket Revenues | Promotional Costs |
| April | $200,000 | $52,000 |
| May | 270,000 | 65,000 |
| June | 320,000 | 80,000 |
| July | 480,000 | 90,000 |
| August | 430,000 | 100,000 |
| September | 450,000 | 110,000 |
| October | 540,000 | 120,000 |
| November | 670,000 | 180,000 |
| December | 751,000 | 197,000 |
She estimates the following regression equation:
- 1. 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.
- 2. Use the high-low method to compute the function relating promotional costs and revenues.
- 3. Using (a) the regression equation and (b) the high-low equation, what is the increase in revenues for each $10,000 spent on promotional costs within the relevant range? Which method should Catherine use to predict the effect of promotional costs on ticket revenues? Explain briefly.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
High-low method; regression analysis. (CIMA, adapted) Catherine McCarthy, sales manager of Baxter Arenas, is checking to see if there is any relationship between promotional costs and ticket revenues at the sports stadium. She obtains the following data for the past 9 months:
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.
Armer 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 of
Chapter 10 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
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
- Jensen 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_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_forwardAn airport Baggage Handing Department has evaluated two proposals for baggage delivery conveyor systems. A present worth analysis at i = 15% per year of estimated revenues and costs resulted in PWA = $460,000 and PWB = $395,000. In addition to this economic measure, three more attributes were independently assigned a relative importance score from 0 to 100 by the department manager and a senior team supervisor. Importance Scores Attribute Manager Supervisor 1. Economics 80 25 2. Durability 35 80 3. Safety 30 100 4. Maintainability 20 90 Separately, you have used the four attributes to value rate the two proposals on a scale of 0 to 1.0 as shown in the following table. (The economics attribute was rated using the PW values.) Value Rating Attribute Proposal A Proposal B 1. Economics 1.00 0.90 2. Durability 0.35 0.50 3. Safety 1.00 0.20 4. Maintainability 0.25 1.00 Select the better proposal using each of the following methods: (a) Weighted evaluation of the department manager (b)…arrow_forward
- Using the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.arrow_forwardThe Port Authority sells a wide variety of cables and adapters for electronic equipment online. Last year the mean value of orders placed with the Port Authority was 47.28, and management wants to assess whether the mean value of orders placed to date this year is the same as last year. The values of a sample of 49,896 orders placed this year are collected and recorded in the tile PortAuthority. a. Formulate hypotheses that can be used to test whether the mean value of orders placed this year differs from the mean value of orders placed last year. b. Use the data in the file PortAuthority to conduct your hypothesis test. What is the p value for your hypothesis test? At = 0.01, what is your conclusion?arrow_forwardMeargia Plastics is evaluating its plastic bottles division. The accounting manager has come upwith the following data for the year: contribution margin of $500,000, controllable fixed costs of$200,000, and noncontrollable fixed costs of $50,000.What is the controllable margin and total contribution by profit center (CPC)?a. Controllable margin: $200,000; CPC: $50,000b. Controllable margin: $50,000; CPC: $500,000c. Controllable margin: $250,000; CPC: 300,000d. Controllable margin: $300,000; CPC: $250,000arrow_forward
- Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow: Month Machine Hours Electricity Costs January 2,500 $ 18,400 February 2,900 21,000 March 1,900 13,500 April 3,100 23,000 May 3,800 28,250 June 3,300 22,000 July 4,100 24,750 August 3,500 22,750 September 2,000 15,500 October 3,700 26,000 November 4,700 31,000 December 4,200 27,750 Summary Output Regression Statistics Multiple R 0.965 R Square 0.932 Adjusted R2 0.925 Standard Error 1,425.18 Observations 12.00 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 3,726.88 1,682.82 2.21 0.05 (22.69) 7,476.45 Machine Hours 5.77 0.49 11.7 0.00 4.67 6.87 The percent of the total variance that can be explained by the regression is:…arrow_forward1. Compare the costs of Version 1 POS and Version 2 POS. Consider the cumulative resultsfor the three years together, ignoring the time value of money and income taxes. 2. Advise Mr. Williams on the factors that determine whether a revenue or cost item is relevantfor management at Carib Systems and indicate whether he should accept the proposal.arrow_forwardWithout calculations, determine the contribution margin at the break-even point. Break-even point $arrow_forward
- a. Using the least squares method, develop the equation for predicting weekly receiving report costs based on the number of shipments received. b. What is the predicted amount of receiving report costs for a month (assume a month is exactly four weeks) in which 165 shipments are received?arrow_forwardHavana Hats makes the world's best hats. Information for the last eight months follows: Month January Number of Hats Produced Total Cost 7,900 $ 12,425 February 7,408 12,000 March 6,300 11,150 April 5,400 8,300 May 4,658 7,680 June 2,200 5,380 July 2,600 5,580 August 4,658 7,750 Required: Perform a least squares regression. Note: Round your answers to 2 decimal places. Variable cost per unit Total fixed costarrow_forwardAssume that you are one of the owners of Pinoy Corporation. Upon reviewing the project income statements as shown in Tables 7.3 and 7.4 you realized that salaries are understated because it only accounts for the 12 months of salary of each employee and does not include the 13th month pay, which is required by law. You also feel that cost of goods sold ought to be computed at 45% instead of 40% of salles revenues. Using a spreadsheet program, revise the projected income statements for the first year and the first three years of the business.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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 ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher: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
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
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
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