HSA 525 WEEK 6
Practice Exercise 13–III: Contractual Allowance Assumptions: 1. Your unit’s gross charges for the period to date amount to $200,000. 2. The uniform gross charge for each procedure in your unit is $100.00. 3. The unit receives revenue from four major payers. For purposes of this exercise, as- sume the revenue volume from each represents 25% of the total. (The equal propor- tion is unrealistic, but serves the purpose for this exercise.) 4. The following contractual payment arrangements are in effect for the current period. The percentage of the gross charge that is currently paid by each payer is as follows: Payer 1 ? 90% Payer 2 ? 80% Payer 3 ? 70% Payer 4 ? 50% Q: How many procedures has your unit recorded for the period to date? Q: Of these, how many procedures are attributed to each payer? Q: How much is the net revenue per procedure for each payer, and how much is the contractual allowance per procedure for each payer?
As a follow-up to the Practice Exercise above, new assumptions are as follows: 1. Your unit’s gross charges for the period to date amount to $200,000. 2. The uniform gross charge for each procedure in your unit is $100.00
3. The unit receives revenue from four major payers. The number of procedures per- formed for the period totals 2,000. Of that total, the number of procedures per payer (stated as a percentage) is as follows: Payer 1 ? 30% Payer 2 ? 40% Payer 3 ? 20% Payer 4 ? 10% 4. The following contractual payment arrangements are in effect for the current period. The percentage of the gross charge that is currently paid by each payer is as follows: Payer 1 ? 80% [Medicare] Payer 2 ? 70% [Commercial managed care plans] Payer 3 ? 50% [Medicaid] Payer 4 ? 90% [Self-pay] Q: How many procedures are attributed to each payer? Q: How much is the net revenue per procedure for each payer, and how much is the con- tractual allowance per procedure for each payer? Q: How much is the total net revenue for each payer, and how much is the total con- Assignment Exercise 13–4.1: Forecast Capacity Levels Review the information in Exhibit 13-1 “Capacity Level Checkpoints for an Outpatient In- fusion Center.” The exhibit assumes three chairs and one 40-hour RN, for a realistic capac- ity level of seven patients infused per day. Required Prepare another Infusion Center Capacity Level Forecast as follows: Assume the same three infusion chairs, but add another nurse for either four or six hours per day. How would this change the daily capacity level for number of patients in- fused per day? Assignment Exercise 13–4.2 Required Prepare another Infusion Center Capacity Level Forecast as follows: Increase the number of infusion chairs to four, and add another nurse for either four or six hours per day. How would this change the daily capacity level for number of patients in- fused per day?
Assignment Exercise 14–1: Comparable Data in a Graph Review Figures 14-1 through 14-5. Each of the five figures presents a graph depicting some type of comparative data. Required Locate healthcare information that can reasonably be compared. (1) Prepare your com- parative data. (2) Using your data, create one or more graphs similar to those found in Fig- ures 14-1 through 14-5. Assignment Exercise 14–2: Cumulative Inflation Factor for Comparable Data Review Table 14-3 and the accompanying text. Assumptions: Two hospitals report their annual projected revenue for five years to the local newspaper for a story on the area’s future economic outlook. However, Hospital 1 has applied a cu- mulative inflation factor of five percent per year while Hospital 2 has not applied any infla- tion factor. Thus the information is not properly comparable. Projected Revenue Year 1 Year 2 Year 3 Year 4 Year 5 Hospital 1 $20,000,000 $22,500,000 $27,500,000 $27,500,000 $30,000,000 Hospital 2 $20,000,000 $21,000,000 $25,000,000 $24,000,000 $26,000,000 Required Revise Hospital 2’s projections by applying a cumulative inflation factor of five percent per year. Assignment Exercise 14–3 The head of your department is a prominent researcher. A health research foundation has asked him travel to London to give an important speech at a conference. He will then travel to Paris to tour a research facility before returning home. Although his travel expenses are being funded by the foundation, he will still need to take along some personal money. Con- sequently, he asks you to figure the exchange rates for $500 and for $1,000 in both pounds and euros. He explains that he is trying to judge the spending power of U.S. dollars when converted to the other currencies so he can decide how much personal money to take on the trip.
Required Locate the current exchange rates for pounds and euros and compute the currency con- version for $500 and for $1,000. Assignment Exercise 14–4: The Discovery The Chief Financial Officer at Sample Hospital has just discovered that the hospital’s Chief of the Medical Staff’s son Jason, a student at the local community college, is paid $100 per week year round for grounds maintenance at the hospital’s Outpatient Center. The CFO, no fan of the Chief of Medical Staff, now wants you to prepare a report that compares the relative costs of lawn care at each of three locations; the hospital itself, the outpatient center, and the hospital-affiliated nursing home down the block. Required Review the available information for grounds maintenance at the three facilities. Decide how to convert this information into comparable data. Then prepare a report, based on your assumptions, that presents comparable costs of grounds care. Also provide your as- sessment of what the best future course of action should be. Relevant Information So far you have assembled the following information. Now you need to decide how it can be converted into comparable data. Introduction to the Three Facilities Sample Hospital is an older 100-bed hospital. The new Outpatient Center, built last year, is across the street and the Golden Age Nursing Facility is down one block, on the corner. All three facilities are part of the Metropolis Health System. (Appendix 25-A contains some fi- nancial details about Sample Hospital.) The hospital is located in the midwestern sunbelt; there is occasional frost in the winter but no snow. Grounds Maintenance Tasks That Should Be Performed at All Three Sites • Mowing and edging • Walk sweeping • Raking leaves • Blowing off parking lot • Flower bed maintenance (where necessary) • Hedge trimming and minor tree pruning (major tree trimming is performed by a contractor on an as-needed basis and thus should be disregarded) Figure Ex-1 provides a map that illustrates the layout of the grounds for each facility and their proximity to each other.
he Chief Financial Officer at Sample Hospital has just discovered that the hospital’s Chief of the Medical Staff’s son Jason, a student at the local community college, is paid $100 per week year round for grounds maintenance at the hospital’s Outpatient Center. The CFO, no fan of the Chief of Medical Staff, now wants you to prepare a report that compares the relative costs of lawn care at each of three locations; the hospital itself, the outpatient center, and the hospital-affiliated nursing home down the block.
As a follow-up to the Practice Exercise above, new assumptions are as follows: 1. Your unit’s gross charges for the period to date amount to $200,000. 2. The uniform gross charge for each procedure in your unit is $100.00
3. The unit receives revenue from four major payers. The number of procedures per- formed for the period totals 2,000. Of that total, the number of procedures per payer (stated as a percentage) is as follows: Payer 1 ? 30% Payer 2 ? 40% Payer 3 ? 20% Payer 4 ? 10% 4. The following contractual payment arrangements are in effect for the current period. The percentage of the gross charge that is currently paid by each payer is as follows: Payer 1 ? 80% [Medicare] Payer 2 ? 70% [Commercial managed care plans] Payer 3 ? 50% [Medicaid] Payer 4 ? 90% [Self-pay] Q: How many procedures are attributed to each payer? Q: How much is the net revenue per procedure for each payer, and how much is the con- tractual allowance per procedure for each payer? Q: How much is the total net revenue for each payer, and how much is the total con- Assignment Exercise 13–4.1: Forecast Capacity Levels Review the information in Exhibit 13-1 “Capacity Level Checkpoints for an Outpatient In- fusion Center.” The exhibit assumes three chairs and one 40-hour RN, for a realistic capac- ity level of seven patients infused per day. Required Prepare another Infusion Center Capacity Level Forecast as follows: Assume the same three infusion chairs, but add another nurse for either four or six hours per day. How would this change the daily capacity level for number of patients in- fused per day? Assignment Exercise 13–4.2 Required Prepare another Infusion Center Capacity Level Forecast as follows: Increase the number of infusion chairs to four, and add another nurse for either four or six hours per day. How would this change the daily capacity level for number of patients in- fused per day?
Assignment Exercise 14–1: Comparable Data in a Graph Review Figures 14-1 through 14-5. Each of the five figures presents a graph depicting some type of comparative data. Required Locate healthcare information that can reasonably be compared. (1) Prepare your com- parative data. (2) Using your data, create one or more graphs similar to those found in Fig- ures 14-1 through 14-5. Assignment Exercise 14–2: Cumulative Inflation Factor for Comparable Data Review Table 14-3 and the accompanying text. Assumptions: Two hospitals report their annual projected revenue for five years to the local newspaper for a story on the area’s future economic outlook. However, Hospital 1 has applied a cu- mulative inflation factor of five percent per year while Hospital 2 has not applied any infla- tion factor. Thus the information is not properly comparable. Projected Revenue Year 1 Year 2 Year 3 Year 4 Year 5 Hospital 1 $20,000,000 $22,500,000 $27,500,000 $27,500,000 $30,000,000 Hospital 2 $20,000,000 $21,000,000 $25,000,000 $24,000,000 $26,000,000 Required Revise Hospital 2’s projections by applying a cumulative inflation factor of five percent per year. Assignment Exercise 14–3 The head of your department is a prominent researcher. A health research foundation has asked him travel to London to give an important speech at a conference. He will then travel to Paris to tour a research facility before returning home. Although his travel expenses are being funded by the foundation, he will still need to take along some personal money. Con- sequently, he asks you to figure the exchange rates for $500 and for $1,000 in both pounds and euros. He explains that he is trying to judge the spending power of U.S. dollars when converted to the other currencies so he can decide how much personal money to take on the trip.
Required Locate the current exchange rates for pounds and euros and compute the currency con- version for $500 and for $1,000. Assignment Exercise 14–4: The Discovery The Chief Financial Officer at Sample Hospital has just discovered that the hospital’s Chief of the Medical Staff’s son Jason, a student at the local community college, is paid $100 per week year round for grounds maintenance at the hospital’s Outpatient Center. The CFO, no fan of the Chief of Medical Staff, now wants you to prepare a report that compares the relative costs of lawn care at each of three locations; the hospital itself, the outpatient center, and the hospital-affiliated nursing home down the block. Required Review the available information for grounds maintenance at the three facilities. Decide how to convert this information into comparable data. Then prepare a report, based on your assumptions, that presents comparable costs of grounds care. Also provide your as- sessment of what the best future course of action should be. Relevant Information So far you have assembled the following information. Now you need to decide how it can be converted into comparable data. Introduction to the Three Facilities Sample Hospital is an older 100-bed hospital. The new Outpatient Center, built last year, is across the street and the Golden Age Nursing Facility is down one block, on the corner. All three facilities are part of the Metropolis Health System. (Appendix 25-A contains some fi- nancial details about Sample Hospital.) The hospital is located in the midwestern sunbelt; there is occasional frost in the winter but no snow. Grounds Maintenance Tasks That Should Be Performed at All Three Sites • Mowing and edging • Walk sweeping • Raking leaves • Blowing off parking lot • Flower bed maintenance (where necessary) • Hedge trimming and minor tree pruning (major tree trimming is performed by a contractor on an as-needed basis and thus should be disregarded) Figure Ex-1 provides a map that illustrates the layout of the grounds for each facility and their proximity to each other.
he Chief Financial Officer at Sample Hospital has just discovered that the hospital’s Chief of the Medical Staff’s son Jason, a student at the local community college, is paid $100 per week year round for grounds maintenance at the hospital’s Outpatient Center. The CFO, no fan of the Chief of Medical Staff, now wants you to prepare a report that compares the relative costs of lawn care at each of three locations; the hospital itself, the outpatient center, and the hospital-affiliated nursing home down the block.
