HIA220 Los Reyes (B) Case Assignment (2-3 Pages) with an exhibit Read through the Los Reyes Case B assignment. You are a consulting firm that Dr. Delgado has employed to complete her variance analysis, and to better understand the divergence from her budget. Not only does she require help on the analysis, but she also needs you to provide recommendations. Recommended Outline: 1. Purpose of this report: Provide the context of the report / background, the crucial differences in costs and expenses from the budget vs actual (ie: surplus). 2. Outline the factors that you suspect can be attributed to the Variance to be Explained, by comparing the budget vs Actual, and by utilizing the work that Dr. Delgado has already completed. 3. Go through each factor in your variance analysis and provide recommendations, if any, to remedy your findings. How, if at all, might this information be used by Dr. Delgado in managing the department? How might it be used by the hospital’s administration? What other information concerning cases, costs, and revenues would you suggest Dr. Delgado see on a regular basis? How might your answer be affected by the hospital’s decision about the types of responsibility centers in its management control system? 4. Provide an Exhibit / Graph / Visual representing your variance analysis. Example Below (Fake Numbers):
losreyes_b.pdf Los Reyes Hospital (B) I’m very concerned about your department’s financial performance. We’d been planning on a surplus of about $74,000 from you, and you’ve run a deficit of over $125,000. Unless something is done to turn this trend around, the hospital will have to begin a series of layoffs that will affect all departments. Maria Delgado, Chief of Medicine of Los Reyes Hospital, stared at the memorandum from the hospi- tal’s Vice President for Medical Affairs. A similar memorandum had been sent to all chiefs of service, ex- pressing concern that the results of the most recent quarter’s operations were considerably worse than budgeted. Dr. Delgado knew she had some explaining to do. In fact, she, along with several other chiefs, had been asked to make a presentation at the next Executive Committee meeting of the hospital concerning the role that their departments had played in the hospital’s poor performance, and their plans for corrective action. In reviewing the budgeted and actual results, Dr. Delgado discovered that almost all of her department’s variation could be attributed to four case types and four hospital services. For reasons of simplicity, she de- cided to base her presentation on these only. Exhibit 1 shows the original quarterly budget for these four case types: DRG089 (Simple pneumonia & pleurisy, age over 17), DRG014 (Specific cerebral vascular disorders except transient ischemic attack), DRG096 (Bronchitis & asthma, age over 17), and DRG140 (Angina pectoris). It also shows the budgeted variable expenses per case for the four hospital services: routine care (i.e. the hospital stay), radiology films, laboratory tests, and pharmacy units (such as prescriptions). Since the hospital negotiated all of its managed care contracts on the basis of diagnosis, it was paid on a per-case basis. Its anticipated revenue for each DRG is shown in Exhibit 1, as is the anticipated utilization of services and the variable expense per unit for each service for each DRG. Using these estimates, the hospital’s fiscal affairs department had calculated total variable expense per case for each DRG. The revenue and total variable expense per case then had been multiplied by the antici- pated number of cases to give total revenue and total variable expenses by DRG. The latter was deducted from total revenue to give the contribution to fixed expenses from each DRG. The department’s fixed ex- penses (including its allocated overhead) were then deducted from the total contribution to give a total budgeted surplus of $73,650 for the quarter. Exhibit 2 is similar to Exhibit 1, except that it shows actual results. As it indicates, instead of a surplus, the department incurred a deficit of $125,475. It was this that led to the concern expressed in the memoran- dum from the hospital’s Vice President for Medical Affairs. Dr. Delgado outlined some of her thinking about the deficit: Our budget is a little tricky to understand. The average expense per day figures all use what the hospital calls “variable expenses.” I think this is right, since our fixed expenses shouldn’t change with small changes in the num- ber of patients, but it makes the amounts look awfully low. Apart from the expenses, one reason for the deficit is that the hospital re-negotiated payment rates with Health- Stop [a local managed care provider], and the result was lower payment rates for several of our DRGs. But I don’t think that’s the whole story. We overspent our fixed expenses a bit, for example, but I think that’s okay since we had about an 8 percent increase over budget in the number of patients we treated during the quarter, and I remember having to bring in some agency nurses to cover the extra workload. THE CRIMSON PRESS CURRICULUM CENTER THE CRIMSON GROUP, INC. ____________________________________________________________________________________________________ This case was prepared by David W. Young. It is intended as a basis for class discussion, and not to illustrate either effective or ineffective handling of an administrative situation. Copyright © 2012 by David W. Young and The Crimson Group, Inc. All rights reserved. To order copies or request permis- sion to reproduce this document, contact The Crimson Press Curriculum Center at 617-497-9600 (Voice) or 617-576-7693 (Fax), or go to www.thecrimsongroup.net. Under provisions of United States copyright laws, no part of this document may be reproduced, stored, or transmitted in any form or by any means without written permission from The Crimson Group. If you believe that you have an illegal copy of this document, please notify the Crimson Press Curriculum Center of this fact immediately. Thank you. In preparation for her presentation to the Executive Committee, Dr. Delgado asked her staff assistant, Asher Hawkins, to prepare a report containing a complete breakdown of the reasons behind the deficit. He began by reasoning that the department had essentially no control over the number or mix of cases seen. He thus prepared a flexible budget (Exhibit 3), which s Showed that the change in the number and mix of cases seen in the department should have led to a surplus of $206,025. Using similar reasoning, he prepared an analysis of the variance due to the lower prices that had been negotiated with the managed care providers. This analysis is contained at the bottom of Exhibit 3, and shows that $150,000 was a result of the price changes. Since the department had had almost nothing to do with these negotiations, this finding made him feel quite good. At this point, Mr. Hawkins felt that he had accomplished the majority of his task. He had found $132,375 in positive variances due to the changes in volume and mix, and $150,000 in negative variances due to changes in prices. Since he felt that the department could control neither, and since the two almost offset each other, he felt that there was little left to explain. Mr. Hawkins then met with Dr. Delgado to show her the results of his work. At the meeting, it became clear that Dr. Delgado was not satisfied. This is not good enough. First of all, the two don’t really offset each other, so that’s an issue. Secondly, though, there’s something else going on here. It’s clear from your analysis that the situation is even worse than I had origi- nally thought. This [Exhibit 3] suggests that we should have had a surplus of slightly over $206,000 instead of $73,000. That makes our deficit look really bad. I’ve got more explaining to do than I had thought. You’re going to need to dig a little more deeply into the issues here, and I’m going to need to see your analysis soon, since the meet- ing is early next week. Assignment 1. Be sure you understand how Exhibit 3 was prepared. Do you agree with Mr. Hawkins’ analyses so far? 2. Besides changes in the number of cases and the payment rate per case, what are the other reasons why actual results might have diverged from budget? 3. Calculate the variance associated with each of the reasons you gave in Question 2. How, if at all, might this infor- mation be used by Dr. Delgado in managing the department? How might it be used by the hospital’s administration? What other information concerning cases, costs, and revenues would you suggest Dr. Delgado see on a regular basis? How might your answer be affected by the hospital’s decision about the types of responsibility centers in its man- agement control system? ____________________________________________________________________________________________________ Los Reyes Hospital (B) • June 2012 2 of 4 LOS REYES HOSPITAL (B) Exhibit 1. Original Budget for the Department of Medicine Overall Budget DRG 089 DRG 014 DRG 096 DRG 140 Total Number of cases 300 200 100 50 650 Revenue per case $6,000 $6,500 $5,000 $3,000 Total revenue $1,800,000 $1,300,000 $500,000 $150,000 $3,750,000 Variable expenses per case $2,800 $3,150 $1,955 $1,205 Total variable expenses $840,000 $630,000 $195,500 $60,250 1,725,750 Contribution $960,000 $670,000 $304,500 $89,750 $2,024,250 Total fixed expenses 1,950,600 Surplus (deficit) $73,650 Variable expense detail: Routine Care #days per case 9 11 7 4 Expense per day $250 $250 $250 $250 Total expense per case $2,250 $2,750 $1,750 $1,000 Radiology # films per case 5 6 4 1 Expense per film $25 $25 $25 $25 Total expense per case $125 $150 $100 $25 Laboratory # tests per case 10 10 3 5 Expense per test $15 $15 $15 $15 Total expense per case $150 $150 $45 $75 Pharmacy # units per case 55 20 12 21 Expense per unit $5.00 $5.00 $5.00 $5.00 Total expense per case $275 $100 $60 $105 Total variable expense per case $2,800 $3,150 $1,955 $1,205 LOS REYES HOSPITAL (B) Exhibit 2. Computation of Actual Overall Results DRG 089 DRG 014 DRG 096 DRG 140 Total Actual number of cases 275 250 100 75 700 Revenue per case $5,500 $6,400 $4,900 $3,300 Total revenue $1,512,500 $1,600,000 $490,000 $247,500 $3,850,000 Variable expenses per case $2,952 $3,346 $2,166 $1,673 Total variable expenses $811,800 $836,500 $216,600 $125,475 1,990,375 Contribution $700,700 $763,500 $273,400 $122,025 $1,859,625 Total fixed expenses 1,985,100 Surplus (deficit) ($125,475) Variable expense detail Routine Care Average #days per case 10 12 8 6 Average expense per day $240 $240 $240 $240 Total average expense per case $2,400 $2,880 $1,920 $1,440 Radiology Average # films per case 6 7 3 2 Average expense per film $24 $24 $24 $24 Total average expense per case $144 $168 $72 $48 Laboratory Average # tests per case 8 10 6 5 Average expense per test $21 $21 $21 $21 Total average expense per case $168 $210 $126 $105 Pharmacy Average # units per case 60 22 12 20 Average expense per unit $4 $4 $4 $4 Total average expense per case $240 $88 $48 $80 Total average variable expense per case $2,952 $3,346 $2,166 $1,673 Exhibit 3. Flexible Budget and Related