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:
Moses Moonrocks Inc. has developed a balanced scorecard with a measure map that suggests that the number of erroneous shipments has a direct effect on operating profit. The company estimates that every shipment error leads to a reduction of revenue by $6,000 and increased costs of about $4,000.
Sales
$227,000
Cost of goods sold
142,000
Depreciation expense
17,000
Other expenses
18,000
If the company has the above budgeted sales and costs for next month (without accounting for any possible shipping errors), determine how many shipping errors the company can afford to have and still break even.
Break-even shipping errors : ?
An 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)…
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
- Projected financial results for the university's cafeteria for next year are shown. Answer each of the following independent questions. Sales $944,000 Fixed Cost $597,000 Total Variable Cost $235, 470 Total Cost $832, 470 Net Income $111,530 (a) How much is the contribution margin and the contribution rate?(b) How much does the business need to sell to break even?(c) If the business was to spend $24,000 to upgrade their processes, how much does the business need to sell to break even?(d) If 9% more meals were sold, what would be the resulting net income?arrow_forwardUsing (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_forwardAn auditor uses regression analysis to evaluate relationship between utility cost and machine hours. The following information is available based from monthly cost and machine hours of the company:· Intercept: 3,000 · Regression is .90· Correlation coefficient is .80· SD error 2,000· No of observations: 1,000What is the expected annual utility cost of the company if it has 150 machines, and it will use 5,000 hours for next year?arrow_forward
- Anu's Amusement Center has collected the following data for operations for the year. Total revenues $ 1,914,000 Total fixed costs 500,500 Total variable costs 1,188,000 Total tickets sold 66,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 $253,000 in operating profits, she will close it down. What number of tickets must be sold for Anu's Amusements to make a $253,000 operating profit for the year on ticket sales? (do not round intermediate calculations) a. Average selling price __________ per…arrow_forwardUsing the data from the attached picture, compute for the following: 1. If 5,000 units are sold, what will be the store’s operating income (loss)?2. If sales commissions are discontinued and fixed salaries are raised by a total of₱810,000, what would be the annual breakeven point in (a) units sold and (b) revenues?3. Refer to the original data. If in addition to his fixed salary, the store manager is paida commission of ₱30 per unit in excess of the break-even point, what would be the store’s operating income if 10,000 units were sold.arrow_forwardUse the following information to complete Short Exercises S20-10 through S20-13. Funday Park competes with Cool World by providing a variety of rides. Funday Park sells tickers at $70 per- person as a one-day entrance fee. Variable costs are $42 per person, and fixed costs are $170,800 per month Applying Sensitivity analysis of changing sales price and variable cost Using the Funday Park information presented, do the following tasks. Requirements Suppose Funday Park cuts its ticket price from $70 to $56 to increase the number of tickets sold. Compute the new breakeven point in tickets and in sales dollars. Ignore the information in Requirement 1. Instead, assume that Funday Park increases the variable cost from $42 to $36 per ticket. Compute the new breakeven point in tickets and in sales dollars.arrow_forward
- Cost Classification, Income Statement Gateway Construction Company, run by Jack Gateway, employs 25 to 30 people as subcontractors for laying gas, water, and sewage pipelines. Most of Gateways work comes from contracts with city and state agencies in Nebraska. The companys sales volume averages 3 million, and profits vary between 0 and 10% of sales. Sales and profits have been somewhat below average for the past 3 years due to a recession and intense competition. Because of this competition, Jack constantly reviews the prices that other companies bid for jobs. When a bid is lost, he analyzes the reasons for the differences between his bid and that of his competitors and uses this information to increase the competitiveness of future bids. Jack believes that Gateways current accounting system is deficient. Currently, all expenses are simply deducted from revenues to arrive at operating income. No effort is made to distinguish among the costs of laying pipe, obtaining contracts, and administering the company. Yet all bids are based on the costs of laying pipe. With these thoughts in mind, Jack looked more carefully at the income statement for the previous year (see below). First, he noted that jobs were priced on the basis of equipment hours, with an average price of 165 per equipment hour. However, when it came to classifying and assigning costs, he needed some help. One thing that really puzzled him was how to classify his own 114,000 salary. About half of his time was spent in bidding and securing contracts, and the other half was spent in general administrative matters. Required: 1. Classify the costs in the income statement as (1) costs of laying pipe (production costs), (2) costs of securing contracts (selling costs), or (3) costs of general administration. For production costs, identify direct materials, direct labor, and overhead costs. The company never has significant work in process (most jobs are started and completed within a day). 2. Assume that a significant driver is equipment hours. Identify the expenses that would likely be traced to jobs using this driver. Explain why you feel these costs are traceable using equipment hours. What is the cost per equipment hour for these traceable costs?arrow_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_forwardMoses Moonrocks Inc. has developed a balanced scorecard with a measure map that suggests that the number of erroneous shipments has a direct effect on operating profit. The company estimates that every shipment error leads to a reduction of revenue by 3,000 and increased costs of about 2,000. If the company has the following budgeted sales and costs for next month (without accounting for any possible shipping errors), determine how many shipping errors the company can afford to have and still break even:arrow_forward
- Suppose that Kicker had the following sales and cost experience (in thousands of dollars) for May of the current year and for May of the prior year: In May of the prior year, Kicker started an intensive quality program designed to enable it to build original equipment manufacture (OEM) speaker systems for a major automobile company. The program was housed in research and development. In the beginning of the current year, Kickers accounting department exercised tighter control over sales commissions, ensuring that no dubious (e.g., double) payments were made. The increased sales in the current year required additional warehouse space that Kicker rented in town. (Round ratios to four decimal places. Round sales dollars computations to the nearest dollar.) Required: 1. Calculate the contribution margin ratio for May of both years. 2. Calculate the break-even point in sales dollars for both years. 3. Calculate the margin of safety in sales dollars for both years. 4. CONCEPTUAL CONNECTION Analyze the differences shown by your calculations in Requirements 1, 2, and 3.arrow_forwardUsing 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 controller for Dohini Manufacturing Company felt that the number of purchase orders alone did not explain the monthly purchasing cost. He knew that nonstandard orders (for example, one requiring an overseas supplier) took more time and effort. He collected data on the number of nonstandard orders for the past 12 months and added that information to the data on purchasing cost and total number of purchase orders. Multiple regression was run on the above data; 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 total purchase orders and 45 nonstandard 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 and 580 nonstandard orders? What will estimated total purchasing cost be? What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 2? (Round your answers to the nearest dollar.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
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 Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
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: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
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