Fundamentals Of Cost Accounting (6th Edition)
6th Edition
ISBN: 9781259969478
Author: WILLIAM LANEN, Shannon Anderson, Michael Maher
Publisher: McGraw Hill Education
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 5, Problem 48E
Interpretation of Regression Results: Simple Regression
The director of surgery at a local hospital is interested in understanding his unit’s costs. An assistant collected data for the past 36 months on unit cost (labor, supplies, and so on) along with the number of procedures performed in the unit. The assistant analyzed the data using a spreadsheet program, and the following output was generated:
The unit is planning to perform an average 1,500 procedures per month for the coming year.
Required
- a. Use the regression output to write the surgical unit cost equation.
- b. Based on the cost equation, compute the estimated costs for the surgical unit per month for the coming year.
- c. The director of surgery has asked you for advice on whether he should rely on the estimate. What will you say?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
H1.
To estimate the monthly maintenance cost for the maintenance department in a hospital, the following monthly costs are
available:
Monthly Expense
Supervisor Salary Expense
Depreciation Expense-Maintenance Equipment
Repairs Expense-Maintenance Equipment
Supplies Expense
Wages Expense-Maintenance Workers
$10,000
The Supervisor Salary Expense and the Depreciation Expense are fixed costs. The remaining expenses are variable costs. There are
1,000 patient days in a month, which is the cost driver for maintenance costs. Estimate the cost function where Y is the monthly
maintenance cost and X is the variable cost per patient day.
OY-58+$22X
OY $30,000 $22.000x
OY-$8,000-$22,000x
OY-$8,000 $22X
$5,000
Costs
$3,000
$5,000
$7,000
Cost Behavior
Alisha Incorporated manufactures medical stents for use in heart bypass surgery. Based on past experience, Alisha has found that its total maintenance costs can be represented by the following formula: Maintenance Cost = $1,750,000 + $125X, where X = Number of Heart Stents. Last year, Alisha produced 25,000 stents. Actual maintenance costs for the year were as expected.
Required:
1. What is the total maintenance cost incurred by Alisha last year? Round your answer to nearest dollar.$
2. What is the total fixed maintenance cost incurred by Alisha last year? Round your answer to nearest dollar.$
3. What is the total variable maintenance cost incurred by Alisha last year? Round your answer to nearest dollar.$
4. What is the maintenance cost per unit produced? Round your answer two decimal places.$per unit
5. What is the fixed maintenance cost per unit? Round your answer two decimal places.$per unit
6. What is the variable maintenance cost per unit? Round your answer…
Chapter 5 Solutions
Fundamentals Of Cost Accounting (6th Edition)
Ch. 5 - What are the common methods of cost estimation?Ch. 5 - Prob. 2RQCh. 5 - Under what conditions is the engineering estimates...Ch. 5 - If one wishes simply to prepare a cost estimate...Ch. 5 - When using cost estimation methods based on past...Ch. 5 - Prob. 6RQCh. 5 - What is the difference between R2 and adjusted R2?Ch. 5 - Why are accurate cost estimates important?Ch. 5 - What are three practical implementation problems...Ch. 5 - Why is it important to incorporate learning into...
Ch. 5 - What are some complications that can arise when...Ch. 5 - The following costs are labeled fixed or variable...Ch. 5 - Prob. 13CADQCh. 5 - When preparing cost estimates for account analysis...Ch. 5 - How can one compensate for the effects of price...Ch. 5 - Prob. 16CADQCh. 5 - Prob. 17CADQCh. 5 - A decision maker is interested in obtaining a cost...Ch. 5 - Consider the Business Application item Using...Ch. 5 - A friend comes to you with the following problem....Ch. 5 - After doing an account analysis and giving the...Ch. 5 - In doing cost analysis, you realize that there...Ch. 5 - Prob. 23CADQCh. 5 - Are learning curves likely to affect materials...Ch. 5 - McDonalds, the fast-food restaurant, is known for...Ch. 5 - Prob. 26CADQCh. 5 - A manager asks you for a cost estimate to open a...Ch. 5 - Prob. 28CADQCh. 5 - Methods of Estimating Costs: Engineering Estimates...Ch. 5 - Prob. 30ECh. 5 - Methods of Estimating Costs: Engineering Estimates...Ch. 5 - Prob. 32ECh. 5 - Methods of Estimating Costs: Account Analysis The...Ch. 5 - Methods of Estimating Costs: Account Analysis...Ch. 5 - Methods of Estimating Costs: High-Low, Ethical...Ch. 5 - Methods of Estimating Costs: High-Low Adriana...Ch. 5 - Methods of Estimating Costs: High-Low
Adriana...Ch. 5 - Prob. 38ECh. 5 - Adriana Corporation manufactures football...Ch. 5 - Methods of Estimating Costs: Simple...Ch. 5 - Prob. 41ECh. 5 - Methods of Estimating Costs: High-Low Davis Stores...Ch. 5 - Methods of Estimating Costs: Scattergraph Prepare...Ch. 5 - Prob. 44ECh. 5 - Interpretation of Regression Results: Multiple...Ch. 5 - Interpretation of Regression Results Brodie...Ch. 5 - Prob. 47ECh. 5 - Interpretation of Regression Results: Simple...Ch. 5 - Learning Curves Assume that General Dynamics,...Ch. 5 - Learning Curves Assume that Whee, Cheatham, and...Ch. 5 - Prob. 51ECh. 5 - Learning Curves (Appendix B) Refer to the example...Ch. 5 - Prob. 53PCh. 5 - Prob. 54PCh. 5 - Regressions from Published Data Obtain 13 years of...Ch. 5 - Prob. 56PCh. 5 - High-Low Method, Scattcrgraph Cubicle Solutions...Ch. 5 - High-Low Method, Scattcrgraph Academy Products...Ch. 5 - High-Low, Scattergraph, Issues with Data
Wyoming...Ch. 5 - Interpretation of Regression Results: Simple...Ch. 5 - Interpretation of Regression Results: Simple...Ch. 5 - Interpretation of Regression Results: Multiple...Ch. 5 - Interpretation of Regression Results: Simple...Ch. 5 - Interpretation of Regression Results Brews 4 U is...Ch. 5 - Cost Estimation: Simple Regression The following...Ch. 5 - Prob. 68PCh. 5 - Methods of Cost Analysis: Account Analysis, Simple...Ch. 5 - Learning Curves (Appendix B) Refer to the example...Ch. 5 - Learning Curves (Appendix B) Krylon Company...
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
- Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forwardJohnson Filtration. Inc., provides maintenance service for water filtration systems throughout southern Florida. Customers contact Johnson with requests for maintenance service on their water filtration systems. To estimate the service time and the service cost. Johnson’s managers want to predict the repair time necessary for each maintenance request. Hence, repair time in hours is the dependent variable. Repair time is believed to be related to three factors: the number of months since the last maintenance service, the type of repair problem (mechanical or electrical), and the repairperson who performs the repair (Donna Newton or Bob Jones). Data for a sample of 10 service calls are reported in the following table: Develop the simple linear regression equation to predict repair time given the number of months since the last maintenance service, and use the results to test the hypothesis that no relationship exists between repair time and the number of months since the last maintenance service at the 0.05 level of significance. What is the interpretation of this relationship? What does the coefficient of determination tell you about this model? Using the simple linear regression model developed in part (a), calculate the predicted repair time and residual for each of the 10 repairs in the data. Sort the data in ascending order by value of the residual. Do you see any pattern in the residuals for the two types of repair? Do you see any pattern in the residuals for the two repairpersons? Do these results suggest any potential modifications to your simple linear regression model? Now create a scatter chart with months since last service on the x-axis and repair time in hours on the y-axis for which the points representing electrical and mechanical repairs are shown in different shapes and/or colors. Create a similar scatter chart of months since last service and repair time in hours for which the points representing repairs by Bob Jones and Donna Newton are shown in different shapes and/or colors. Do these charts and the results of your residual analysis suggest the same potential modifications to your simple linear regression model? Create a new dummy variable that is equal to zero if the type of repair is mechanical and one if the type of repair is electrical. Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service and the type of repair. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model? Create a new dummy variable that is equal to zero if the repairperson is Bob Jones and one if the repairperson is Donna Newton. Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service and the repairperson. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model? Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service, the type of repair, and the repairperson. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model? Which of these models would you use? Why?arrow_forwardThe Bienestar Cardiology Clinic has two major activities: diagnostic and treatment. The two activities use four resources: nursing, medical technicians, cardiologists, and equipment. Detailed interviews have provided the work distribution matrix shown below. The total time estimated corresponds to practical capacity (interviewers adjusted the total time to about 80 percent of the available time). The equipment time is measured in machine hours. Thus, the total time (at practical capacity) in the system is 20,000 hours. In considering the implementation of a TDABC model, the following unit times and transaction information are also provided: Required: 1. Calculate the cost of each activity using the indicated values of the resource drivers. 2. Calculate the capacity cost rate for TDABC. Using the capacity cost rate, calculate the cost of each activity under TDABC. Compare these values with those obtained in Requirement 1 and discuss possible reasons for any differences. 3. Suppose that the actual activity driver quantities are 3,500 and 9,000. Calculate the cost of unused capacity. 4. Suppose that the clinic acquires new equipment that reduces the total time required for the two activities from 6,000 to 4,000 hours. The equipment cost remains the same. Explain how the ABC system would be updated and then describe how TDABC would provide updates. 5. Suppose that diagnosing patients without any cardiac disease takes two hours while diagnosing patients with mildly diseased hearts takes an additional 1.5 hours and those with more severe problems takes an additional two hours. Prepare a time equation and, using the capacity cost rate from Requirement 2, calculate the activity rate for each of the three types of patients.arrow_forward
- Haysbert Company provides management services for apartments and rental units. In general, Haysbert packages its services into two groups: basic and complete. The basic package includes advertising vacant units, showing potential renters through them, and collecting monthly rent and remitting it to the owner. The complete package adds maintenance of units and bookkeeping to the basic package. Packages are priced on a per-rental unit basis. Actual results from last year are as follows: Haysbert had budgeted the following amounts: Required: 1. Calculate the contribution margin variance. 2. Calculate the contribution margin volume variance. 3. Calculate the sales mix variance.arrow_forwardCost Behavior Alisha Incorporated manufactures medical stents for use in heart bypass surgery. Based on past experience, Alisha has found that its total maintenance costs can be represented by the following formula: Maintenance Cost = $1,675,000+ $150X, where X = Number of Heart Stents. Last year, Alisha produced 66,000 stents. Actual maintenance costs for the year were as expected. Required: If required, round your answers to the nearest cent. 1. What is the total maintenance cost incurred by Alisha last year? 2. What is the total fixed maintenance cost incurred by Alisha last year? 3. What is the total variable maintenance cost incurred by Alisha last year? 4. What is the maintenance cost per unit produced? per unit 5. What is the fixed maintenance cost per unit? per unit 6. What is the variable maintenance cost per unit?arrow_forwardQ.Using an activity-based costing approach to cost analysis, calculate the budgeted cost of each program and the budgeted cost per patient-year of the drug program.arrow_forward
- The administrator of Azalea Hills Hospital would like a cost formula linking the administrative costsinvolved in admitting patients to the number of patients admitted during a month. The Admitting Department’s costs and the number of patients admitted during the immediately preceding eight months are givenin the following table:Number of AdmittingMonth Patients Admitted Department CostsMay ........................... 1,800 $14,700June .......................... 1,900 $15,200July ........................... 1,700 $13,700August ....................... 1,600 $14,000September ................ 1,500 $14,300October ..................... 1,300 $13,100November ................ 1,100 $12,800December ................. 1,500 $14,600Required:1. Use the high-low method to estimate the fixed and variable components of admitting costs.2. Express the fixed and variable components of admitting costs as a cost formula in the formY a bX .arrow_forwardTASK A. Problem Solving. Analyze the given problem and perform the required tasks in the worksheet provided. 1. A hospital has P250,000 expected utility bill this year. The janitorial, accounting, and orderlies departments are service departments servicing the operating, hospital rooms, and laboratories departments. Floor spaces assigned to each department are as follows Department Square Footage Janitorial Accounting Orderlies 1,000 2,000 7,000 Operating Hospital rooms Laboratories 4,000 30,000 6,000 How much of the P200,000 will eventually become the hospital rooms department's total costs, assuming a direct allocation based in square footage is used? 2. The Laptop complex, which offers two main services: 1) time on a time-shared computer and (2) propriety computer programs. Computer time is provided by the Operating Department (OD), and programs are written by the programming Department(PD). Usually, the Operating Department spends P 9,000 and the Programming Departmemnt spends…arrow_forwardLean Mfgarrow_forward
- Calculate the amount for each of the following (one unit=one test) if the number of tests is 2000 per month. Also calculate if the number of tests decreases to 1,250 per month. Do not round intermediate calculations. Round your final answers to the nearest whole dollar.arrow_forwardThe production department is proposing the purchase of an automatic insertion machine. It has identified three machines and has asked the accountant to analyze them to determine which one has the best average rate of return. Machine A Machine B Machine C $83,087.40 $73,001.40 322,364.00 276,958.00 486,676.00 Estimated average income $45,130.96 Average investment Oa. Machine B Ob. Machine C Oc. Machine A Od. Machines B and C have the same preferred average rate of return.arrow_forwardFalls Creek Community Health Clinic uses the high-low method to analyze cost behavior and has determined that number of patients treated predict the clinic's total treatment costs. Determine the cost function (formula) for total treatment costs. What will the estimated treatment cost be if Falls Creek treats 1,402 patients in a month? Total Number Treatment of Patients Costs January $3,410 February $3,790 $3,574 $3,730 $4,500 1060 1180 March 1030 April 1260 May 1310 $4,294 June 1430 (Round your final answer to two decimal places)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
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher: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,
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
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,
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
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