REVEL for Horngren's Cost Accounting: A Managerial Emphasis -- Access Card (16th Edition) (What's New in Accounting)
16th Edition
ISBN: 9780134789705
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.
Use the high-low method to compute the function relating promotional costs and revenues.
Chapter 10 Solutions
REVEL for Horngren's Cost Accounting: A Managerial Emphasis -- Access Card (16th Edition) (What's New in Accounting)
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
- 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.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_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_forward
- Meargia 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_forwardAnu’s Amusement Center has collected the following data for operations for the year. Total revenues $ 2,016,000 Total fixed costs $ 694,400 Total variable costs $ 1,134,000 Total tickets sold 63,000 Required: a. What is the average selling price for a ticket? b. What is the average variable cost per ticket? c. What is the average contribution margin per ticket? (Do not round intermediate calculations.) d. What is the break-even point? (Do not round intermediate calculations.) e. Anu has decided that unless the operation can earn at least $222,600 in operating profits, she will close it down. What number of tickets must be sold for Anu’s Amusements to make a $222,600 operating profit for the year on ticket sales? (Do not round intermediate calculations.)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
- The 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_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
- 1. 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_forwardIt's Still Raining (ISR) manufacturers umbrellas. In order to better budget and manage costs, they are analyzing the purchasing costs behavior. They have the following data from the last six months of last year. Month Total Purchasing Costs Purchase Orders July $19,670 460 August $20,940 560 September $19,430 400 October $20,020 500 November $18,800 470 December $19,340 480 Using the regression analysis function in Excel, what are the expected costs if 520 purchase orders are processed? Please round your answer to the nearest whole dollar.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
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
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
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
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
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
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