Vikas

HSA525/HSA 525 WEEK 6 ASSIGNMENT

HSA 535 WEEK 6 148 CHAPTER 13 Common Sizing, Trend Analysis and Forecasted Data Exhibit 13-1 Capacity Level Checkpoints for an Outpatient Infusion Center Outpatient Infusion Center Capacity Level Checkpoints # infusion chairs 3 chairs # staff 1 RN # weekly operating hours 40 hours # of hours per patient infusion average 2 hours (for purposes of this example) Work Flow Description For each infusion the nurse must perform the following steps (generalized for this purpose; actual protocol is more specific): 1) Obtain and review the patient's chart 2) Obtain and prepare the appropriate drug for infusion 3) Interview the patient 4) Prepare the patient and commence the infusion 5) Monitor and record progress throughout the ongoing infusion 6) Observe the patient upon completion of the infusion 7) Complete charting Work Flow Comments It is impossible for one nurse to start patients' infusions in all three chairs simultaneously. Thus the theoretical treatment sequence might be as follows. • Assume one-half-hour for patient number one's steps (1) through (4). • Once patient number one is at step (5), the nurse can begin the protocol for patient number two. • Assume another one-half-hour for patient number two's steps (1) through (4). • Once patient number two is at step (5), theoretically the nurse can begin the protocol for patient number three. This sequence should work, assuming all factors work smoothly; that is, the appropriate drugs in the proper amounts are at hand, the patients show up on time, and no one patient demands an unusual amount of the nurse's attention. (For example, a new patient will require more attention.) Daily Infusion Center Capacity Level Assumption Patient scheduling is never entirely smooth, and patient reactions during infusions are never predictable. Therefore, we realistically assume the following: Chair #1 = 3 patients per day; Chair #2 = 2 patients per day, and Chair #3 = 2 patients per day, for a daily total of 7 patients infused. Chapter 13 383 Hospital A Current Assets Property, Plant, &Equipment Other Assets Total Assets Year 1 $1,600,000 6,000,000 400,000 $8,000,000 Year 2 $ 2,000,000 7,500,000 500,000 $10,000,000 Assignment Exercise 13-2: Trend Analysis Refer to the Metropolis Health System (MHS) comparative financial statements at the back of the Examples and Exercises section. Required Perform trend analysis on the MHS statement of revenue and expenses. Practice Exercise 13-ID: Contractual Allowance Assumptions: L 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, assume the revenue volume from each represents 25% of the total. (The equal proportion 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? ~ Assignment Exercise 13-3 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. 384 EXAMPLES AND EXERCISES, SUPPLEMENTAL MATERIALS, Al"lD SOLUTIONS 3. The unit receives revenue from four major payers. The number of procedures performed 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 contractual allowance per procedure for each payer? Q: How much is the total net revenue for each payer, and how much is the total contractual allowance for each payer? ~signment Exercise 13-4.1: Forecast CapacityLevels Review the information in Exhibit 13-1 "Capacity Level Checkpoints for an Outpatient Infusion Center." The exhibit assumes three chairs and one 40-hour RN, for a realistic capacity 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 infused per day? ~Signment 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 infused per day? Chapter 14 385 CHAPTER 14 Assignment Exercise 14-1: Comparable Data in a Graph ReviewFigures 14-1through 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 comparative data. (2) Using your data, create one or more graphs similar to those found in Figures 14-1through 14-5. ,f.Assignment Exercise 14-2: Cumulative Inflation Factor for Comparable Data ReviewTable 14-3and 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 cumulative inflation factor of five percent per year while Hospital 2 has not applied any inflation factor. Thus the information is not properly comparable. Projected Revenue Year 1 Year 2 Year 3 Year4 Year5 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 ReviseHospital2's projections by applying a cumulative inflation factor offive percent per year. ~ Assignment Exercise 14-3 The head of your department is a prominent researcher. Ahealth 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 willstill need to take along some personal money. Consequently, he asksyou 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. 386 EXAMPLES AND EXERCISES, SUPPLEMENTAL MATERIALS, AND SOUJTIONS Required Locate the current exchange rates for pounds and euros and compute the currency conversion for $500 and for $1,000. --{CAssignment 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 assessment 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 financial 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. Chapter 14 387 _11__ 11_1LJ II I Outpatient I Parking - t-, Parking -; iil '" ISample Hospital '" I I I Figure Ex-l Sample Hospital Map Washington Street Jefferson Street Jackson Street I I Grounds Maintenance Arrangements for the Three Facilities The current grounds maintenance arrangements vary among the three facilities as follows: 1. Sample Hospital uses its Maintenance department employees for grounds care. The hospital pays these employees $15 per hour plus 15% employee benefits; it is estimated they spend 1,000 hours per year on grounds maintenance work. Another estimated 120 hours per year are spent on maintaining the lawn care equipment. The employees use a riding lawn mower, edger, and blower, all owned by the hospital. The hospital just bought a new mower for $2,995 less a ten percent discount. It is expected that the mower should last for fiveyears. 2. The hospital's Chief of the Medical Staffs sonJason, a student at the local community college, is paid $100 per week year round for grounds maintenance at the hospital's Outpatient Center. A friend sometimes helps, but when that happens Jason pays him out of his weekly $100. It takes about one-and-a-half hours to mow, edge, and blow.Jason uses his dad's riding mower and blower, but Jason recently bought his own edger. Jason also buys fertilizer for the grass twice a year. 3. The Nursing Facilitycontracts with a landscape service on a seasonally adjusted sliding scale.The landscape service is paid $600 per month from April to October (mowing season); $400 per month for February, March, and November; and $200 per month for November, 388 EXAMPLES AND EXERCISES, SUPPLEMENTAL MATERL>lLS, AND SOLUTIONS December, and January. The landscape service provides all their own equipment. They also provide fertilizer and provide annuals to plant in the flower beds every quarter. Sample Hospital Property Description The grounds to be maintained are as follows: • The front lawn is grass in two sections on either side of the front entrance. Each section is about 50' by 60' . • There is a hedge along the front of the building that is about 50' on either side of the front entrance. • There are two small matching flower beds on either side of the front entrance. • Another strip of grass alongside of the building is 30' by 100'. • A third small strip of grass about 5' by 25' is by the Emergency entrance. • The walkwaydimensions are as follows: about 50' of front walk; about 30' of staff entrance walk, both of which are 5' wide. • The Emergency Department's paved patient drop-off area is about 25' by 30'. • The parking lot surface is about 200' by 250'. Along one side are overhanging trees that drop leaves and debris and are a constant sweeping problem. These are the only trees on the hospital site. Outpatient Center Pmperty Description The grounds to be maintained are as follows: • There is a strip of grass at the front of the building that is 12' wide and 65' long, split in the middle by a walkway5' wide. • There is a strip of grass at the back of the building between the building and the parking lot that is 5' wide and 50' long • All the rest of the property is paved. Nursing Center Property Description Golden Age Nursing Center occupies one whole block. The grounds have many large trees. Flowerbeds have been planted around the trees as well as along the front walk and entrance. There are also two secured patio areas at the side of the building, screened by hedges, and each has a small bed of annuals. Because of the unique design of the building, grounds maintenance requires considerable handwork such as edging with a weed eater. CHAPTER 15 Example 15A:Budgeting A static budget is based on a single level of operations, which is never adjusted. Therefore, the static budgeted expense amounts will not change, even though actual volume does change during the year. Chapter 13 383 Hospital A Curren t Assets Property, Plant, & Equipment Other Assets Total Assets Year 1 $1,600,000 6,000,000 400,000 $8,000,000 Year 2 $ 2,000,000 7,500,000 500,000 $10,000,000 Assignment Exercise 13-2: Trend Analysis Refer to the Metropolis Health System (MHS) comparative financial statements at the back of the Examples and Exercises section. Required Perform trend analysis on the MHS statement of revenue and expenses. Practice Exercise 13-111: 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, assume the revenue volume from each represents 25% of the total. (The equal proportion 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? -} Assignment Exercise 13-3 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. 426 EXAMPLES AND EXERCISES, SUPPLEMENTAL MATERIALS, AND SOLUTIO S SOLUTION TO PRACTICE EXERCISE 13-11 Year 1 Current assets Property, plant, and equipment Other assets Total assets $1,600,000 6,000,000 400,000 $8,000,000 Hospital A Year 2 Difference $ 2,000,000 7,500,000 500,000 $10,000,000 $ 400,000 1,500,000 100,000 $2,000,000 25% 25% 25% Note: The worksheet below showsHospital Awith both common sizing and trend analysis: Year 1 Current assets Property, plant, and equipment Other assets Total assets $1,600,000 6,000,000 400,000 $8,000,000 20% 75% 5% 100% SOLUTION TO PRACTICE EXERCISE 13-Ill Hospital A Year 2 Difference $ 2,000,000 20% $ 400,000 7,500,000 75% 1,500,000 500,000 5% 100,000 $10,000,000 100% $2,000,000 ( ~ )
Answered
Other / Other
13 Jan 2016

Answers (1)

  1. Vikas

    HSA525/HSA 525 WEEK 6 ASSIGNMENT

    HSA525/HSA 525 WEEK 6 ASSIGNMENTHSA525/HSA 525 WEEK 6 ASSIGNMENTHSA525/HSA 525 WEEK 6 ASSIGNMENTHSA5 ****** ******
    To see full answer buy this answer.
    Answer Attachments

    2 attachments —

    • img
      Exercise_13195946.xls
    • img
      Exercises_14195947.xls

Report As Dispute

Share Your Feedback

Give Review : A+ A B C D F