Concept explainers
Regression; choosing among models. Apollo Hospital specializes in outpatient surgeries for relatively minor procedures. Apollo is a nonprofit institution and places great emphasis on controlling costs in order to provide services to the community in an efficient manner.
Apollo’s CFO, Julie Chen, has been concerned of late about the hospital’s consumption of medical supplies. To better understand the behavior of this cost, Julie consults with Rhett Bratt, the person responsible for Apollo’s cost system. After some discussion, Julie and Rhett conclude that there are two potential cost drivers for the hospital’s medical supplies costs. The first driver is the total number of procedures performed. The second is the number of patient-hours generated by Apollo. Julie and Rhett view the latter as a potentially better cost driver because the hospital does perform a variety of procedures, some more complex than others.
Rhett provides the following data relating to the past year to Julie.
- 1. Estimate the regression equation for (a) medical supplies costs and number of procedures and (b) medical supplies costs and number of patient-hours. You should obtain the following results:
Required
Regression 1: Medical supplies costs = a + (b × Number of procedures)
Regression 2: Medical supplies costs = a + (b × Number of patient-hours)
- 2. On different graphs plot the data and the regression lines for each of the following cost functions:
- a. Medical supplies costs = a + (b × Number of procedures)
- b. Medical supplies costs = a + (b × Number of patient-hours)
- 3. Evaluate the regression models for “Number of procedures” and “Number of patient-hours” as the cost driver according to the format of Figure 10-18 (page 406).
- 4. Based on your analysis, which cost driver should Julie Chen adopt for Apollo Hospital? Explain your answer.
Want to see the full answer?
Check out a sample textbook solutionChapter 10 Solutions
EBK HORNGREN'S COST ACCOUNTING
- ABC, Resource Drivers, Service Industry Glencoe Medical Clinic operates a cardiology care unit and a maternity care unit. Colby Hepworth, the clinic’s administrator, is investigating the charges assigned to cardiology patients. Currently, all cardiology patients are charged the same rate per patient day for daily care services. Daily care services are broadly defined as occupancy, feeding, and nursing care. A recent study, however, revealed several interesting outcomes. First, the demands patients place on daily care services vary with the severity of the case being treated. Second, the occupancy activity is a combination of two activities: lodging and use of monitoring equipment. Since some patients require more monitoring than others, these activities should be separated. Third, the daily rate should reflect the difference in demands resulting from differences in patient type. Separating the occupancy activity into two separate activities also required the determination of the cost…arrow_forwardIdentify each responsibility center in the list below as either a service center, cost center (clinical or administrative), profit center (capitated or administrative), or investment center. Explain your choices. Radiology department that must control its own costs: Admitting department of a hospital: HMO: Stand‐alone outpatient clinic that must earn a 10 percent return on investment (ROI): Volunteer department with no budget: Development office:arrow_forwardShow a detailed, step by step process for the following question below: “Apollo is a local hospital that offers two types of procedures. Currently, Apollo uses a simple system to calculate the overhead cost per treatment. This is done by taking the total overhead cost and dividing it by the number of treatments. Using this method, the full cost for each procedure is shown below: Procedure X Y Direct costs per procedure £2,610 £1,560 Full cost per procedure £2,831 £1,781 Recently, another competitor has implemented activity based costing (ABC). This has led the finance director to consider whether this alternative costing technique would bring any benefits. She has obtained an analysis of Apollo’s total overheads for the last year and some additional data, all of which is shown below:” Cost Cost driver Administrative costs Administrative time per procedure £935,080 Nursing costs Length of patient stay £3,127,808 Catering…arrow_forward
- Show a detailed, step by step process for the following question below: “Apollo is a local hospital that offers two types of procedures. Currently, Apollo uses a simple system to calculate the overhead cost per treatment. This is done by taking the total overhead cost and dividing it by the number of treatments. Using this method, the full cost for each procedure is shown below: Procedure X Y Direct costs per procedure £2,610 £1,560 Full cost per procedure £2,831 £1,781 Recently, another competitor has implemented activity based costing (ABC). This has led the finance director to consider whether this alternative costing technique would bring any benefits. She has obtained an analysis of Apollo’s total overheads for the last year and some additional data, all of which is shown below:” Cost Cost driver Administrative costs Administrative time per procedure £935,080 Nursing costs Length of patient stay £3,127,808 Catering…arrow_forwardFormation of an Activity Dictionary A hospital is in the process of implementing an ABC system. A pilot study is being done to assess the effects of the costing changes on specific products. Of particular interest is the cost of caring for patients who receive in-patient recovery treatment for illness, surgery (noncardiac), and injury. These patients are housed on the third and fourth floors of the hospital. The floors are dedicated to patient care and have only nursing stations and patient rooms. A partial transcript of an interview with the hospitals nursing supervisor is as follows: 1. How many nurses are in the hospital? There are 101 nurses, including me. 2. Of these 100 nurses, how many are assigned to the third and fourth floors? Fifty nurses are assigned to these two floors. 3. What do these nurses do (please describe)? Provide nursing care for patients, which, as you know, means answering questions, changing bandages, administering medicine, changing clothes, etc. 4. And what do you do? I supervise and coordinate all the nursing activity in the hospital. This includes surgery, maternity, the emergency room, and the two floors you mentioned. 5. What other lodging and care activities are done for the third and fourth floors by persons other than the nurses? The patients must be fed. The hospital cafeteria delivers meals. The laundry department picks up dirty clothing and bedding once each shift. The floors also have a physical therapist assigned to provide care on a physician-directed basis. 6. Do patients use any equipment? Yes. Mostly monitoring equipment. 7. Who or what uses the activity output? Patients. But there are different kinds of patients. On these two floors, we classify patients into three categories according to severity: intensive care, intermediate care, and normal care. The more severe the illness, the more activity is used. Nurses spend much more time with intermediate care patients than with normal care. The more severe patients tend to use more of the laundry service as well. Their clothing and bedding need to be changed more frequently. On the other hand, severe patients use less food. They eat fewer meals. Typically, we measure each patient type by the number of days of hospital stay. And you have to realize that the same patient contributes to each type of product. Required: Prepare an activity dictionary with three categories: activity name, activity description, and activity driver.arrow_forwardDeepa Dalal opened a free-standing radiology clinic. She had anticipated that the costs for the radiological tests would be primarily fixed, but she found that costs increased with the number of tests performed. Costs for this service over the past nine months are as follows: Required: 1. Prepare a scattergraph based on the preceding data. Use cost for the vertical axis and number of radiology tests for the horizontal axis. Based on an examination of the scattergraph, does there appear to be a linear relationship between the cost of radiology service and the number of tests? 2. Compute the cost formula for radiology services using the high-low method. 3. Calculate the predicted cost of radiology services for October for 3,500 tests using the formula found in Requirement 2.arrow_forward
- Pareto chart and cost of quality report for a service company The administrator of Liberty Hospital has been asked to perform an activity analysis of the emergency room (ER). The ER activities include cost of quality and other patient care activities. The lab tests and transportation are hospital services external to the ER for determining external failure costs. The result of the activity analysis is summarized as follows: Instructions 1. Prepare a Pareto chart of the ER activities. 2. Classify the activities into prevention, appraisal, internal failure, external failure, and other patient care activities. Classify the activities into value-added and non-value-added activities. 3. Use the activity cost information to determine the percentages of total ER costs that are prevention, appraisal, internal failure, external failure, and other patient care activities. 4. Determine the percentages of the total ER costs that are value-added and non-value-added. 5. Interpret the information.arrow_forwardPareto chart and cost of quality report for a service company The administrator of Liberty Hospital has been asked to perform an activity analysis of the emergency room (ER). The ER activities include cost of quality and other patient care activities. The lab tests and transportation are hospital services external to the ER for determining external failure costs. The result of the activity analysis is summarized as follows: Activities Activity Cost Patient registration $ 6,500 Verifying patient information 9,700 Assigning patients 13,000 Searching/waiting for doctor 9,200 Doctor exam 4,900 Waiting for transport 17,500 Transporting patients 16,200 Verifying lab orders 14,500 Searching for equipment 8,200 Incorrect labs 11,300 Lab tests 17,000 Counting supplies 19,000 Looking for supplies 8,200 Staff training 4,800 Total $160,000 a. b. c. d. Classify the…arrow_forwardLouis Clark, the new administrator for the surgical clinic, was trying to figure out how to allocate is indirect expenses. His staff were complaining that the current method of taking a percentage of revenues was unfair. He decided to try to allocate utilities expense based on square footage of each department, to allocate administration expense based on direct costs, and to allocate laboratory expense based on tests. Using the information in Exhibit 12.11 below, calculate the total indirect costs (utilities, administration, and laboratory) allocated to the Day-Op Suite; Cystoscopy; and Endoscopy. Exhibit 12-11 A B C Square Feet Dept. Costs Lab Tests Utilities $400,000 Administration 4,000 $700,000 Laboratory 2,000 $750,000 Day-Op suite…arrow_forward
- Ferdinand Construction (FC) manages the design and construction of hospitals. Ferdinand has developed several formulas that it uses to quote jobs. These include costs of basic construction but exclude equipment and furniture. These estimates are also dependent on the purpose of the hospital (teaching hospitals are more costly to build) and location (downtown hospitals are more costly to build). Both of these are based on the building costs. The estimated costs also depend on whether the hospital has few or many stories (high-rise buildings are more expensive). The following are the cost estimates for one region in the Northeast: Design costs $ 15,000,000 Building costs – per square foot (low-rise) 300 Building costs – per square foot (high-rise) 360 Downtown premium 60% Teaching hospital premium 20% Required: A local university medical school has asked Ferdinand Construction to provide a quote on a high-rise teaching hospital located in the city center downtown. The…arrow_forwardPlease provide the answer in excel with the formulas and explain he steps. The are three questions below. The bullets are the information needed to answer and solve the questions. Medical Center Hospital CEO Thomas Cleverly decided that the not-for-profit hospital needed a new revenue line to help it compete with other hospitals in the area. He envisioned a mobile medical clinic, called “Health Train,” which could travel to different neighborhoods and provide annual physical examinations for a low price. You are an MHA fellow who is assigned to the CEO’s office, and the task of doing the initial planning for this project has fallen on your shoulders. You have been able to gather the following information on the Health Train concept: An appropriate-sized bus can be purchased for $300,000; it would have a ten-year life and a 10 percent salvage value. Equipment for the bus would cost $100,000; it would have a five-year life with no salvage value. A physician to staff the Health Train…arrow_forwardWhich of the following activity bases would be the most appropriate for food costs of a hospital? a.quantity of prescriptions filled b.how many MRI's are taken c.number of nurses scheduled to work d.number of patients who stay in the hospitalarrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial 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