Analyze cost behavior at a hospital using various cost estimation methods (Learning Objectives 1, 2, 3, 4, & 5)
Sandy Dawson is the Chief Operating Officer at Mercy Hospital in Atlanta, Georgia. She is analyzing the hospital’s
Requirements
- 1. Are the hospital’s overhead costs fixed, variable, or mixed? Explain.
- 2. Graph the hospital’s overhead costs against nursing hours. Use Excel or graph by hand.
- 3. Graph the hospital’s overhead costs against the number of patient days. Use Excel or graph by hand.
- 4. Do the data appear to be sound, or do you see any potential data problems? Explain.
- 5. Use the high-low method to determine the hospital’s cost equation using nursing hours as the cost driver. Predict total overhead costs if 25,500 nursing hours are predicted for the month.
- 6. Dawson runs a regression analysis using nursing hours as the cost driver to predict total hospital overhead costs. The Excel output from the regression analysis is as follows:
If 25,500 nursing hours are predicted for the month, what is the total predicted hospital overhead?
- 7. Dawson then ran the regression analysis using number of patient days as the cost driver. The Excel output from the regression is shown here:
If 3,680 patient days are predicted for the month, what is the total predicted hospital overhead?
- 8. Which regression analysis (using nursing hours or using number of patient days as the cost driver) produces the best cost equation? Explain your answer.
Trending nowThis is a popular solution!
Chapter 6 Solutions
Managerial Accounting (5th Edition)
- Cost Identification Following is a list of cost terms described in the chapter as well as a list of brief descriptive settings for each item. Cost terms: a. Opportunity cost b. Period cost c. Product cost d. Direct labor cost e. Selling cost f. Conversion cost g. Prime cost h. Direct materials cost i. Manufacturing overhead cost j. Administrative cost Settings: 1. Marcus Armstrong, manager of Timmins Optical, estimated that the cost of plastic, wages of the technician producing the lenses, and overhead totaled 30 per pair of single-vision lenses. 2. Linda was having a hard time deciding whether to return to school. She was concerned about the salary she would have to give up for the next 4 years. 3. Randy Harris is the finished goods warehouse manager for a medium-sized manufacturing firm. He is paid a salary of 90,000 per year. As he studied the financial statements prepared by the local certified public accounting firm, he wondered how his salary was treated. 4. Jamie Young is in charge of the legal department at company headquarters. Her salary is 95,000 per year. She reports to the chief executive officer. 5. All factory costs that are not classified as direct materials or direct labor. 6. The new product required machining, assembly, and painting. The design engineer asked the accounting department to estimate the labor cost of each of the three operations. The engineer supplied the estimated labor hours for each operation. 7. After obtaining the estimate of direct labor cost, the design engineer estimated the cost of the materials that would be used for the new product. 8. The design engineer totaled the costs of materials and direct labor for the new product. 9. The design engineer also estimated the cost of converting the raw materials into their final form. 10. The auditor for a soft drink bottling plant pointed out that the depreciation on the delivery trucks had been incorrectly assigned to product cost (through overhead). Accordingly, the depreciation charge was reallocated on the income statement. Required: Match the cost terms with the settings. More than one cost classification may be associated with each setting; however, select the setting that seems to fit the item best. When you are done, each cost term will be used just once.arrow_forwardWeber Valley Regional Hospital has collected data on all of its activities for the past 16 months. Data for cardiac nursing care follow: Required: 1. Using the high-low method, calculate the variable rate per hour and the fixed cost for the nursing care activity. 2. Run a regression on the data, using hours of nursing care as the independent variable. Predict cost for the cardiac nursing care for September Year 2 if 1,400 hours of nursing care are forecast. Evaluate the regression equation. How comfortable are you with the predicted cost for September Year 2? 3. Upon looking into the events that happened at the end of Year 1, you find that the cardiology ward bought a cardiac-monitoring machine for the nursing station. Administrators also decided to add a new supervisory position for the evening shift. Monthly depreciation on the monitor and the salary of the new supervisor together total 10,000. Now, run two regression equations, one for the observations from Year 1 and the second using only the observations for the eight months in Year 2. Discuss your findings. What is your predicted cost of the cardiac nursing care activity for September Year 2?arrow_forwardA marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 156 students who took the course last semester are provided in the tile MktHrsPts. Develop a scatter chart for these data. What does the scatter chart indicate about the relationship between total points earned and hours spent studying? Develop an estimated regression equation showing how total points earned is related to hours spent studying. What is the estimated regression model? Test whether each of the regression parameters β0 and β1 is equal to zero at a 0.01 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? How much of the variation in the sample values of total point earned does the model you estimated in part (b) explain? Mark Sweeney spent 95 hours studying. Use the regression model you estimated in part (b) to predict the total points Mark earned.arrow_forward
- 1. 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_forwardPenny is compiling a list of costs incurred so far on a project. She must categorize these costs so that she can present the amount of direct cost incurred. Which of the following should Penny include in this list?This type of question contains radio buttons and checkboxes for selection of options. Use Tab for navigation and Enter or space to select the option. option A Expense incurred in meeting the regulatory standards for the company option B Benefits for employees in the organization option C Travel expenses to the customer’s office option D Costs incurred for maintaining coffee stations around the office.arrow_forwardThe Allegheny School of Music has hired you as a consultant to help in analyzing the behavior of the school’s costs. Use the account-classification method of cost estimation to classify each of the following costs as variable, fixed, or semivariable. Before classifying the costs, choose an appropriate measure for the school’s activity. 1.Salaries and fringe benefits of the school’s full-time teachers. 2.Salaries and fringe benefits of the school’s full-time administrative staff. 3.Cost of buying books, sheet music, and other academic materials that are supplied to the students by the school. 4.Repairs on musical instruments. The school employs a full-time repair technician. Repair jobs that are beyond the technician’s capability are taken to a local musical-instrument dealer for repairs. 5.Fee charged by a local public accounting firm to audit the school’s accounting records. 6.Wages of the school’s part-time assistant recital instructors. These employees are hired on a tem-porary…arrow_forward
- 3. 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 total costs if number of patients admitted is 1,750? 4. The administrator of ABC Hospital would like to know the relationship between the costs of admitting in relation to the number of…arrow_forwardLising Therapy has a physical therapist who performs electro-mechanical treatments for its patients. During April, Lising had the following cost and output information: Required: 1. Calculate the cost per treatment for April. 2. Calculate the cost of services sold for April. 3. What if Lising found a way to reduce overhead costs by 20 percent? How would this affect the profit per treatment?arrow_forwardA local picnic table manufacturer has budgeted these overhead costs: They are considering adapting ABC costing and have estimated the cost drivers for each pool as shown: Recent success has yielded an order for 1,000 tables. Assume direct labor costs per hour of $20. Determine how much the job would cost given the following activities:arrow_forward
- 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_forwardJane’s Cookhouse is a popular restaurant located in a scenic setting. The owner of the restaurant has been trying to better understand costs at the restaurant and has hired a student intern to conduct an ABC study. The intern, in consultation with the owner, identified three major activities. The intern then completed the first-stage allocations of costs to the activity cost pools, using data from last month’s operations. The results appear below: Activity Cost Pool Activity Measure Total Cost Total Activity Serving a party of diners Number of parties served $ 16,585 5,350 parties Serving a diner Number of diners served $ 107,010 13,050 diners Serving a drink Number of drinks ordered $ 35,310 10,700 drinks The above costs include all of the costs of the restaurant except for organization-sustaining costs such as rent, property taxes, and top-management salaries. A group of diners who ask to sit at the same table are counted as a party. Some costs, such as the…arrow_forward5. 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 total admitting costs if no patient is admitted in June? 6. The following cost relate to XYZ Corp for the year: Sales commission expenses P 185,000 Direct materials…arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning