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
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
- State with a brief reason, the appropriate pricing policy that should be adopted in the following situations. (Do not copy the situation into your answer books) (i) A health centre doing routine health check-up with normal facilities. (ii) A newly formed company is trying to build a unique product that it may patent. Some of the product's components, designed to specifications are outsourced to A. Thearrow_forwardMed Max buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to dozens of hospitals. In the face of declining profits, Med Max decided to implement an activity-based costing system to improve its understanding of the costs incurred to serve each hospital. The company broke its selling and administrative expenses into four activities as shown below: Activity Cost Pool Customer deliveries Manual order processing Activity Measure Number of deliveries Number of manual orders Number of electronic orders. Number of line items picked Electronic order processing Line item picking Total selling and administrative expenses Med Max gathered the data below for two of the many hospitals that it serves-City General and County General: Required 1 Required 2 Activity City General 10 0 10 100 Activity Cost Pool Customer deliveries County General Required: 1. Compute the activity rate for each activity cost pool. 2. Compute the total activity costs that…arrow_forwardVishnuarrow_forward
- Med Max buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to dozens of hospitals. In the face of declining profits, Med Max decided to implement an activity-based costing system to improve its understanding of the costs incurred to serve each hospital. The company broke its selling and administrative expenses into four activities as shown below: Activity Cost Pool Customer deliveries Manual order processing Electronic order processing Line item picking Total selling and administrative expenses Activity Measure Number of deliveries Number of manual orders Number of electronic orders Number of line items picked Total Activity 4,700 deliveries 3,700 orders Total Cost $ 361,900 266,400 191,540 518,000 370,000 line items $ 1,337,840 12,200 orders Med Max gathered the data below for two of the many hospitals that it serves-City General and County General: Activity Measure Number of deliveries Number of manual orders Number of electronic…arrow_forwardO. Accountarrow_forwardThe board of directors of Earth Rock's!, a nonprofit organization focused on environmental protection, hypothesizes that individuals are more likely to donate if they see evidence that their donations are used primarily for program activities rather than administrative and fund-raising costs. To get a sense of how its own cost structure compares to other groups, the board decides to benchmark the financial performance of Earth Rocks! against several other environmental organizations. The data for Earth Rocks! and the other environmental organizations appear below Program Expenditures Fund-raising Costs Administrative Costs Total Costs Earth Rocks 374,900 98,000 121,400 594,300 Weed Lovers 421,000 104,300 98,350 623,650 Flora and Fauna 353,000 97,600 71,840 522,840 Leaf It Be 501,900 89,000 109,750 700,650 Nature's Gift 455,470 71,000 82,450 608,920 Use these data to benchmark Earth Rocks! against the other environmental organizations. How does Earth Rocks! compare to…arrow_forward
- Jim Salters, the COO of CryoDerm, has asked his cost management team for a product-line profitability analysis for his firm’s two products, Zderm and Bderm. The two skincare products require a large amount of research and development and advertising. After receiving the following statement fromCryoDerm’s costing team, Jim concludes that Zderm is the more profitable product and that perhaps cost-cutting measures should be applied to Bderm. Zderm Bderm Total Sales $3,000,000 $2,000,000 $5,000,000 Cost of Goods Sold ($1,900,000) ($1,600,000) ($3,500,000) Gross Profit $1,100,000 $ 400,000 $1,500,000 R&D (900,000) Selling expenses (100,000) Profit before taxes $ 500,000 Required:(i) Briefly explain why Jim may be wrong in his assessment of the relative performance of the twoproducts. (ii) Suppose that 80% of the R&D and selling expenses are traceable to Zderm. Prepare life-cycle income statements for each product. What does this indicate…arrow_forwardDavid Jones, the new administrator for a surgical clinic, was trying to determine how to allocate his indirect expenses. His staff was complaining that the current method of taking a percentage of revenues was unfair. He decided to try to allocate utilities based on square footage of each department, administration based on direct costs, and laboratory based on tests. Use the information in the chart below to answer problems 22, 23 and 24. Square Footage DirectExpenses Lab Tests Utilities $200,000 Administration 2,000 500,000 Laboratory 2,000 625,000 Day-op Suite 3,000 1,400,000 4,000 Cystoscopy 1,500 300,000 500 Endoscopy 1,500 600,000 500 Total 10,000 $3,375,000 5,000 1. What are the Day Op Suite’s total expenses? 2. What are the Cystoscopy Department’s total expenses? 3. What are the Endoscopy Department’s total expenses?arrow_forwardPlease do not give solution in image format ? And Fast answering please and explain proper steps by Step.arrow_forward
- can you help me with this problem with step by step explanation, please? I'm not sure what I did wrong.arrow_forwardCost allocation in hospitals, alternative allocation criteria. Harold Monette vacationed at Lake Tahoe last winter. Unfortunately, he broke his ankle while skiing and spent two days at the Sierra University Hospital. Monette’s insurance company received a $4,950 bill for his two-day stay. One item that caught Monette’s attention was a $10.60 charge for a roll of cotton. Monette is a salesman for Johnson & Johnson and knows that the cost to the hospital of the roll of cotton is between $2.45 and $3.25. He asked for a breakdown of the $10.60 charge. The accounting office of the hospital sent him the following information: Monette believes the overhead charge is outrageous. He comments, “There was nothing I could do about it. When they come in and dab your stitches, it’s not as if you can say, ‘Keep your cotton roll. I brought my own.’”arrow_forwardCould you outline the difference between a fixed cost and a variable cost?Could you identify which expense is a fixed cost and which is a variable cost from the information in the scenario (storage unit vs. hospital gowns)?Develop a plan to reduce both costs within the next fiscal year.arrow_forward
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning