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 solutionChapter 6 Solutions
Managerial Accounting: Creating Value in a Dynamic Business Environment
- Estimate the cost equation using the high-low method, and draw this line on your graph.arrow_forwardWhich of the following statements is true? Select one: O a. The most complex of the cost estimation methods is the high-low method. O b. Engineering approach approximates cost function by classifying each account as either variable or fixed based on the analyst's knowledge of how the account behaves. C The high-low method of deriving an estimated cost line uses all the data points available. O d. In approximating the cost function, the account analysis classifies costs based upon an industrial engineer's evaluation of production methods, and material, labor, and overhead requirements. O e. The high-low 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.arrow_forwardA) Write difference between absorption costing and variable costing. B) Write cost pool, cost driver, activity cost, budgeting. C) What are the assumption of CVP analysis? What is BEP point? D) Draw a CVP graph.arrow_forward
- Which of the following statements related to cost estimation methods is true? O a. The most complex method of cost estimation is the high-low method. O b. The high-low method is the most accurate and reliable method to determine the cost behavior compared to scatter-graph plot and least-squares regression methods. O c. The low-high 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. O d. Only high-low method has a slope and an intercept. O . None of the given answers.arrow_forwardAn analyst has started preparing a spreadsheet as shown below. Column A contains the headings for various parameters and Column B contains the analyst's range names to be used in Excel. A 1 Price per Unit 2 Cost per Unit 3 Profit per Unit Price_per_Unit Cost per Unit Profit$_per_Unit 4. 5 Fixed Costs 6 Variable Costs Fixed Costs VariableCosts Label each of the following range names as "Correct" if is a valid range name in Excel or "Incorrect" if the range name is not valid for use in Excel. Proposed Range Name Price_per_Unit Cost per Unit Profit$_per_Unit Fixed Costs VariableCostsarrow_forwardUsing the step method to allocate the service center costs, what is the total cost of programming and classes?arrow_forward
- Distinguish between ( a ) a variable cost, ( b ) a mixed cost, and ( c ) a step-variable cost. Plot thethree costs on a graph, with activity plotted horizontally and cost plotted verticallyarrow_forward6.) 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_forwardUPVOTE WILL BE GIVEN! INPUT THE COMPLETE SOLUTIONS. YOU MAY USE EXCEL. BOX THE FINAL ANSWERS. d. How much is the total cost for completed units? e. How much is the total cost to be accounted for?arrow_forward
- Write cost pool, cost driver, activity cost, budgeting. What are the assumption of CVP analysis? What is BEP point? Draw a CVP graph.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
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College