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
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 solutionStudents have asked these similar questions
Draw a graph of the cost behavior for each of the following costs incurred by the Mountain Summit Hospital. The hospital measures monthly activity in patient days. Label both axes and the cost line in each graph.1. The cost of food varies in proportion to the number of patient days of activity. In January, the hospital provided 3,000 patient days of care, and food costs amounted to $24,000.2. The cost of salaries and fringe benefits for the administrative staff totals $12,000 per month.3. The hospital’s laboratory costs include two components: (a) $40,000 per month for compensation of personnel and depreciation on equipment and (b) $10 per patient day for chemicals and other materials used in performing the tests.4. The cost of utilities depends on how many wards the hospital needs to use during a particular month. During months with activity under 2,000 patient days of care, two wards are used, resulting in utility costs of $10,000. During months with greater than 2,000 patient days…
Outpatient Surgery is developing an RVU and product cost for the following surgical procedures, given the projected volumes and samples direct costs. Projected total costs for the Outpatient Surgery department are $20 million ($12 million in direct costs and $8 million in indirect costs). Use the steps provided in your textbook to Calculate the cost per procedure using job-order costing.
Procedure
Projected Volumes
Labor Expense
Supply Expense
Subcutaneous Tissue Debridement
2,000
$100
$90
Esophagastroduodeno with Biopsy
4,000
$150
$60
Aspiration/Injection of a Joint
8,000
$75
$30
Colonoscopy
10,400
$110
$20
Next, Outpatient Surgery wants to add a cost driver to better represent the causal relationship of their indirect costs to produce a more accurate cost-per-procedure. Using the steps in your textbook assign costs to each procedure using the following information.
Procedure
Equipment Use (min.)
Subcutaneous Tissue Debridement
10
Esophagastroduodeno with…
The manager of the main laboratory facility at UrbanFit Center is interested in being able to predict the overhead costs each month for the lab. The manager believes that total overhead varies with the number of lab tests performed I
that some costs remain the same each month regardless of the number of lab tests performed. The lab manager collected the following data for the first seven months of the year.
(Click the icon to view the data.)
Use the high-low method to determine the laboratory's cost equation for total laboratory overhead. Use your results to predict total laboratory overhead if 3,500 lab tests are performed next month.
Let's begin by determining the formula that is used to calculate the variable cost (slope).
Data table
Variable cost (slope)
Number of Lab
Month
Tests Performed
Total Laboratory
Overhead Costs
January
2,800
$21,500
February
2,600
$22,700
March
3,100
$27,900
April....
3,550
$31,400
May
3,700
$28,500
June..
1,200
$19,500
July
1,400
$14,500
Print
Done
X
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_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_forwardHaysbert 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_forward
- Johnson 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_forwardOutpatient Surgery is developing an RVU and product cost for the following surgical procedures, given the projected volumes and samples direct costs. Projected total costs for the Outpatient Surgery department are $20 million ($12 million in direct costs and $8 million in indirect costs). Use the steps provided in your textbook to Calculate the cost per procedure using job-order costing. Procedure Projected Volumes Labor Expense Supply Expense Subcutaneous Tissue Debridement 2,000 $100 $90 Esophagastroduodeno with Biopsy 4,000 $150 $60 Aspiration/Injection of a Joint 8,000 $75 $30 Colonoscopy 10,400 $110 $20 Stage 1: Calculate the RVU for each procedure (Show your work): Stage 2: Calculate the total cost for each procedure (Show your work): Next, Outpatient Surgery wants to add a cost driver to better represent the causal relationship of their indirect costs to produce a more accurate cost-per-procedure. Using the steps in your textbook assign costs to each procedure…arrow_forwardOH allocation using cost driversRegis Place is a health-care facility that has been allocating its overhead costs to patients based on number of patient days. The facility’s overhead costs total $2,172,240 per year and the facility (which operates monthly at capacity) has a total of 60 beds available. (Assume a 360-day year.) The facility’s accountant is considering a new overhead allocation method using the following information: OH Cost Cost Driver (Quantity) Rooms (depreciation, cleaning, etc.) $302,400 # of rooms (25 double) 35 Laundry 90,720 # of beds 60 Nursing care 788,400 # of nurse-hours annually 43,800 Physical therapy 576,000 # of hours of rehab 8,000 General services 414,720 # of patient days ? Rooms are cleaned daily; laundry for rooms is done, on average, every other day. d. Assume a patient stayed at Regis Place for six days. The patient was in a single room and required six hours of nursing care and 30 hours of physical therapy.1. What overhead…arrow_forward
- OH allocation using cost driversRegis Place is a health-care facility that has been allocating its overhead costs to patients based on number of patient days. The facility’s overhead costs total $2,172,240 per year and the facility (which operates monthly at capacity) has a total of 60 beds available. (Assume a 360-day year.) The facility’s accountant is considering a new overhead allocation method using the following information: OH Cost Cost Driver (Quantity) Rooms (depreciation, cleaning, etc.) $302,400 # of rooms (25 double) 35 Laundry 90,720 # of beds 60 Nursing care 788,400 # of nurse-hours annually 43,800 Physical therapy 576,000 # of hours of rehab 8,000 General services 414,720 # of patient days ? Rooms are cleaned daily; laundry for rooms is done, on average, every other day.a. How many patient days are available at Regis Place? Answer daysb. What is the current overhead rate per patient day?Note: Round your answer to the nearest whole dollar.$Answerc.…arrow_forwardWrite a linear cost function equation for each of the following conditions. Use y for estimated costsand X for activity of the cost driver. Machine operating costs include $1,000 of maintenance per month, and $15.00 of coolant usagecosts for each day the machinery is in operation.arrow_forwardThe 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_forward
- Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Employee Hours Month January February March April May June July August Labor Cost $7,000 8,140 9,899 9,787 8,490 7,450 9,490 7,531 Coefficients shown by a regression program for Pizza Vesuvio's data are: 360 550 630 600 480 350 570 310. Intercept 4,497 X Variable 8.26 In your calculations, round the variable rate per employee hour to the nearest cent. Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of labor. 17,430 X Calculate the variable rate per employee hour. 7.40 X per employee hourarrow_forward1. The administrator of ABC Hospital would like to know the relationship between the costs of admitting in relation to the number of patients being admitted and determine the cost formula. The following are the related data for the past five months that will be used determine such cost formula. Month |# of Patients Admitted |Admitting Costs January 1,800 P 14,700 February 1,900 P 15,200 March 1,700 P 13,700 April 1,600 P 14,000 May 1,500 P 14,300 The controller suggested to use the high-low method approach to derive for the cost formula. If the controller’s suggestion is to be followed: How much would be the variable cost per unit? 2. The administrator of ABC Hospital would like to know the relationship between the costs of admitting in relation to the number of patients…arrow_forwardUsing the least-squares method of analyzing costs, answer the following questions and show computations to support your answers. a. What is the estimated variable portion of maintenance costs per labor hour? B.What is the estimated fixed maintenance cost each month? C.Formulate the regression equation D.If it is estimated that 600 labor hours will be used in July, what is the expected total power cost for July?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 LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher: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 LearningPrinciples 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: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
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
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