Videos
Refer to the data and accompanying information in the preceding case.
Required:
1. Use the high-low method to estimate the cost behavior for the clinic’s administrative costs. Express the cost behavior in formula form (Y = a + bX). What is the variable cost per patient?
2. Build a spreadsheet: Construct an Excel spreadsheet and use the Excel commands to perform a least-squares regression and estimate the administrative cost behavior. Express the cost behavior in formula form. What is the variable cost per patient? Compute and interpret the R2 value for the regression.
3. Write a memo to the hospital administrator comparing the cost estimates using (a) least-squares regression, (b) the high-low method, and (c) the scatter diagram and visually fit semivariable-cost line from the preceding case (requirement (4). Make a recommendation as to which estimate should be used, and support your recommendation. Make any other suggestions you feel are appropriate.
4. After receiving the memo comparing the three cost estimates, Mahoney called McDonough to discuss the matter. The following exchange occurred.
Mahoney: “As you know, Megan, I was never in favor of this clinic. It’s going to be a drag on our administrative staff, and we’d have been far better off keeping the pediatrics operation here in the hospital.”
McDonough: “I was aware that you felt the clinic was a mistake. Of course, the board of trustees had other issues to consider. I believe the board felt the clinic should be built to make pediatric care more accessible to the economically depressed area on the other side of the city.”
Mahoney: “That’s true, but the board doesn’t realize how difficult it’s going to make life for us here in the hospital. In any case, I called to tell you that when you and I report to the board next week, I’m going to recommend that the clinic be shut down. I want you to support my recommendation with one of your cost estimates showing that administrative costs will soar at high activity levels.”
McDonough: “But that estimate was based on the high-low method. It’s not an appropriate method for this situation.”
Mahoney: “It is an estimate, Megan, and it’s based on a well-known estimation method. This is just the ammunition I need to make the board see things my way.”
McDonough: “I don’t know, Jeff. I just don’t think I can go along with that.”
Mahoney: “Be a team player, Megan. I’ve got a meeting now. Got to run.”
That night McDonough called to discuss the matter with her best friend, you. What would you advise her?
Want to see the full answer?
Check out a sample textbook solution
Chapter 6 Solutions
Managerial Accounting: Creating Value in a Dynamic Business Environment
- 6.) Statement 1. The high-low method needs three observations of costs to calculate the cost formula.Statement 2. The least-squares regression method uses all of the available data to find the best fitting line.Statement 3. The calculations in the least-squares regression method is always accurate in all data sets between any kind of activity and cost. Which of the following is true?Group of answer choices Statement 1 Statement 3Statements 1 and 3Statements 1 and 2 Statements 2 and 3 Statement 2 7.) Which of the following statements is true about broker markets?Group of answer choices Brokers’ extensive contacts provide them with a pool of price information that individual investors could easily duplicate themselves, and hence not really value adding. Investors have an incentive to hire a broker because what they charge as a commission is less than the cost of direct search. Brokers can guarantee an order because they have an inventory of securities. Brokers bring buyers and sellers…arrow_forward_____Identifying the relationship between the activity and the costs is a key step in which of the following cost estimation methods? a) Scattergraph. b) High-low method. c) Linear regression. d) Account analysis.arrow_forwardWhich of the following methods of cost estimation relies on only two data points?A. the high-low methodB. account analysisC. least-squares regressionD. SWOT analysis.arrow_forward
- Which of the following statements related to cost estimation methods is true ? a . Only high -low method has a slope and an intercept . b. The scatter - graph method is used to derive an estimated line of cost behavior by graphically connecting the two cost amounts identified with the highest and lowest volume levels . c. The most complex method of cost estimation is the high - low method . d. The least -squares regression method is the most accurate and reliable method to determine the cost behavior compared to scatter -graph plot and high -low methods . e. None of the given answersarrow_forwardWhich of the following methods of cost estimation relies on only two data points? A. the high-low method B. account analysis C. least-squares regression D. SWOT analysis.arrow_forwardWhat I Know Before we begin this lesson, let us check first your prior knowledge on this module. After taking and checking this short test, take note of the items that you are not able to answer correctly and look for the right answer as you go through this module. Direction: Encircle the letter of the correct answer. 1. What type of cost includes product ingredients and materials? а. fixed b. revenue с. total d. variable 2. What type of cost includes the rental of space? а. fixed b. revenue c. total d. variable 3. What type of cost is the product of the price and the quantity sold? а. fixed b. revenue с. total d. variable 4. What concept is being described when the business will neither earn a profit nor suffer a loss? а. break-even b. loss с. profit d. summit 5. What type of analysis shows equal revenue and total cost? а. break-even b. cost of variable c. profit-loss d. volume of salesarrow_forward
- answer correctly and typewritten only, please. I will give an upvote if you follow my instructions. thank you. please skip if you have already done this.arrow_forwardhelp please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forwardGive me an example How Efficient are Graphic Techniques - Scatter Charts for Estimating Costs?arrow_forward
- Search about how different techniques are efficient to estimate cost. – Engineered estimate of cost– Analysis at the account level– Regression analysisarrow_forwardCost estimation is the process of a. Summarizing pwst costs into fixed variable components. b.Estimating the relationship between costs and the costs drivers that cause those costs. c. Documenting costs in terms of direct and indirect costs. d. All of the choicesarrow_forwardPlease answer me quickely!arrow_forward
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College