Question

In: Statistics and Probability

HIMT 2150 Healthcare Statistics You are the Health Information Management Director at Georgetown Hospital. Georgetown is...

HIMT 2150

Healthcare Statistics

You are the Health Information Management Director at Georgetown Hospital. Georgetown is a 75 bed, 20 bassinet general hospital located in Charleston, South Carolina. A flu epidemic in Charleston stretched the capacity of the facility, so 10 adult beds were set up in the solarium for the entire month of March 2014.

Your responsibilities as HIM director include the maintenance and reporting of common hospital statistics. As often happens during budget and tax season, requests for information begin to arrive from a number of sources throughout the hospital. Make calculations as necessary and construct appropriate displays for each question. Be sure your displays have effective titles, that the page orientation is appropriate, etc.

You must use Excel to develop the graphs and PowerPoint to develop your displays. Graphs for all 6 scenarios should be combined into a single PowerPoint presentation.

Develop one or more displays for each of the scenarios that follow:

  1. Your hospital administrator would like to consider requesting a certificate of need for five more adult beds. He is having lunch with the head of the hospital’s governing board tomorrow, and would like to discuss the issue. He asks you for information on percentage of occupancy at Georgetown Hospital last year. Since the governing body executive is very visual, he’d like to present it in some kind of graphic form. Adult/child occupancy data is listed in the table below. Make your calculations and prepare a display the administrator can use for this meeting.

GEORGETOWN HOSPITAL

Occupancy Data on Adults and Children

January – December 2013

Month

Inpatient Service Days

Total Length of Stay

Discharges (including deaths)

Jan

2201

2146

510

Feb

1978

1977

465

Mar

2682

2145

479

Apr

2197

2084

552

May

2204

2040

513

Jun

2114

1977

477

Jul

2188

2039

513

Aug

2170

2056

573

Sep

2203

2204

479

Oct

2215

2058

483

Nov

2196

2085

519

Dec

2147

2094

529

  1. The day after your administrator’s lunch with the head of the board, he stops by to ask you for more occupancy information. The governing body head was encouraging, so they are going to put the question on the agenda for the next full board meeting. In addition to the information you have already provided on percentage of occupancy, the administrator would like to see information on the average length of stay this past year. Calculate the length of stay and develop a display the administrator can use at the full board meeting.

  1. As you get together this information, you notice that patients on the general medicine floor have unusually long lengths of stay, which of course drives up your hospital’s length of stay. You decide that, in addition to reporting the hospital’s average length of stay, you want to show them the average LOS for Medicine and Surgery. The breakout data is as follows:

GEORGETOWN HOSPITAL

Average Length of Stay (in days) for Adults and Children

Medicine and Surgical Services, 2013

Month

Medicine Service

Surgical Service

Jan

5.4

2.3

Feb

6.5

3.5

Mar

7.3

3

Apr

7.2

4

May

5.9

2.3

Jun

5.2

3

Jul

7.3

3.8

Aug

4.9

4

Sep

7.2

3

Oct

6.1

3.2

Nov

5.1

2

Dec

5.9

2.2

  1. Your hospital marketing director is going to address the local chapter of the Expectant Mother’s Association. She would like to take along a display of the number of births at the hospital during the past year, and she’s like to look really upbeat and “spiffy”. Your data is as follows:

GEORGETOWN HOSPITAL

Live Births – 2013

Month

Number of Live Births

Jan

62

Feb

60

Mar

58

Apr

48

May

65

Jun

69

Jul

67

Aug

59

Sep

61

Oct

58

Nov

52

Dec

52

  1. The board of directors will discuss income at their next meeting. You have been asked to prepare a handout that illustrates the sources of the hospital’s income. You visit the finance office and obtain the following information:

GEORGETOWN HOSPITAL SOURCES OF HOSPITAL INCOME

2013

Payment Source

Percentage of Total Income

Medicare

28%

Medicaid

32%

Other 3rd Party Payers

38%

Payments from patients

2%

  1. Even though Georgetown Hospital is small, your HIM department is pretty large. Your department has responsibility for medical records, of course; but you are also the director for quality management functions at Georgetown. You have three supervisors that help you run the department – one who supervises the QM functions (4 technical and one clerical worker), one who is in charge of record assembly (including scanning), analysis, completion, main file and release of information (12 clerks and one technical worker) and one who is the lead coder (she supervises 6 coders). Construct a chart to illustrate the organization of your department.

Solutions

Expert Solution

1. Inpatient Bed Occupancy Ratio :

The inpatient bed occupancy ratio can be computed at any specified point of time or for any specified day. To compute the percentage for a specified day, the inpatient service days for that day is multiplied by 100 and divided by the inpatient bed count for that day. To obtain the inpatient bed occupancy ratio as a daily average in a longer period, the formula is

To obtain the inpatient bed occupancy ratio as a daily average in a longer period, the formula is

=  Total inpatient service days for a period  X 100
    Total inpatient bed count days X number of days in the period

Occupancy rate: use inpatient days of care and bed days available in this formula: (Inpatient Days of Care / Bed Days Available) x 100

Month Inpatient Service Days Total Length of Stay Discharges (including deaths) Bed occupancy ratio Beds Available No of days in month of 2013 Beds Available Occupancy rate
Jan 2201 2146 510 3.31 75 31 2325 94.7%
Feb 1978 1977 465 3.57 75 28 2100 94.2%
Mar 2682 2145 479 4.03 75 31 2325 115.4%
Apr 2197 2084 552 3.51 75 30 2250 97.6%
May 2204 2040 513 3.49 75 31 2325 94.8%
Jun 2114 1977 477 3.56 75 30 2250 94.0%
Jul 2188 2039 513 3.46 75 31 2325 94.1%
Aug 2170 2056 573 3.40 75 31 2325 93.3%
Sep 2203 2204 479 3.33 75 30 2250 97.9%
Oct 2215 2058 483 3.47 75 31 2325 95.3%
Nov 2196 2085 519 3.51 75 30 2250 97.6%
Dec 2147 2094 529 3.31 75 31 2325 92.3%

The trend is visible in the month of march 2013 itself, hence the requirement of more beds

2.

Month Medicine Service Surgical Service Average LOS for hospital
Jan 5.4 2.3 7.7
Feb 6.5 3.5 10
Mar 7.3 3 10.3
Apr 7.2 4 11.2
May 5.9 2.3 8.2
Jun 5.2 3 8.2
Jul 7.3 3.8 11.1
Aug 4.9 4 8.9
Sep 7.2 3 10.2
Oct 6.1 3.2 9.3
Nov 5.1 2 7.1
Dec 5.9 2.2 8.1
2013
Medicine Service 6.17
Surgical Service 6.17 3.03
Average LOS for hospital 9.19

3.

Month Number of Live Births
Jan 62
Feb 60
Mar 58
Apr 48
May 65
Jun 69
Jul 67
Aug 59
Sep 61
Oct 58
Nov 52
Dec 52

4.

Payment Source Percentage of Total Income
Medicare 28%
Medicaid 32%
Other 3rd Party Payers 38%
Payments from patients 2%


Related Solutions

As a Director of Health Information at a medium hospital , Create a performance management plan...
As a Director of Health Information at a medium hospital , Create a performance management plan for your medical coders; Address questions such as: *How will expectations be communicated? *What is the training plan and professional development plan? *How will you conduct performance appraisals and how often? *How will poor performance be addressed? *How will excellent performance be rewarded? Establish productivity standards for your medical coders. Include both qualitative and quantitative standards
Instructions Scenario: You are a Director of Health Information at a medium sized hospital and you...
Instructions Scenario: You are a Director of Health Information at a medium sized hospital and you have been charged with establishing a performance management plan for your medical coders. ? Put yourself in the role of Director of Health Information at a medium sized hospital. ? Create a performance management plan for your medical coders ? Address questions such as: ? How will expectations be communicated? What is the training plan and professional development plan? How will you conduct performance...
You are a health information management professional at Happy Hospital. Since the hospital is moving toward...
You are a health information management professional at Happy Hospital. Since the hospital is moving toward adopting more value-based initiatives, you are tasked with the following: 1. Nurse X and Nurse Y are confused about the sections and requirements needed in clinical documentation. They have come to you with the sections listed below. How would you educate and inform them as to what needs to be added or changed regarding what they have done thus far? What the nurses have...
Imagine that you have been appointed the director of health at the Kaluyu Memorial Hospital in...
Imagine that you have been appointed the director of health at the Kaluyu Memorial Hospital in Nairobi, Kenya—a for-profit hospital. The facility is also a referral hospital and receives severe cases of accidents and chronicle and communicable diseases, and it houses an HIV/AIDS ward. As you settle into your position, you realize that the employees always act scared as they approach their superiors. Some of the employees deliver files and leave your office in a hurry. As you make your...
Sandy is a healthcare director for Liverty Hospital. The facility is looking to implement a new...
Sandy is a healthcare director for Liverty Hospital. The facility is looking to implement a new data tracking system for customer service. The purpose of the system is to help monitor information on patient satisfaction to provide better quality of services. Sandy is trying to decide between three different systems. Should Sandy submit a request for proposal (RFP) or request for information (RFI) to each of the three vendors? (You may wish to perform an internet search for additional information.)...
The Health Information Management Department is allocated $500,000 for its budget for the year.  The Director expends...
The Health Information Management Department is allocated $500,000 for its budget for the year.  The Director expends this allocation by authorizing expenditures throughout the year to pay employee salaries, buy supplies and pay for new equipment.  The employees process the records of patients whose insurers pay the claims issued by the healthcare center.  The employees use their paychecks to buy goods and services in the community.  Some of the community members seek health care at the surgery center.  Their insurances pay for the services.  The monies...
Scenario Summary You are the new director of risk management at Little Falls Hospital, which is...
Scenario Summary You are the new director of risk management at Little Falls Hospital, which is a 450-bed tertiary care facility in a major urban area in the Northeast. The hospital is an integrated health system that provides the full array of inpatient and outpatient services. The hospital enjoys a reputation for quality care in the area. As the new risk manager, you have been briefed about a patient care case that needs your attention. ·         The patient is a...
You are the director of health information at a large medical Center that offers inpatient outpatient...
You are the director of health information at a large medical Center that offers inpatient outpatient and Emergency Care at several sites in one state. your medical center has announced that it will acquire a facility offering similar services in a neighboring state. the laws and regulations governing the retention and destruction of health records differ between the states. discuss how the lack of a consistent set of laws and regulations on these two matters affects the institutions you serve...
Hospital Administration and Management 1-Healthcare cost Many Americans are concerned with the topic of healthcare costs,...
Hospital Administration and Management 1-Healthcare cost Many Americans are concerned with the topic of healthcare costs, but not many understand the complexity of the topic. Write a two-page paper that addresses the following: Explain the factors that are driving healthcare costs and discuss the effects they have on both inpatient and outpatient facilities. Do some research on a hospital or healthcare setting where you would like to work. Outline their financial structure; are they a nonprofit, for-profit, or government facility?...
1. You are the health information manager at a local hospital. A physician on the medical...
1. You are the health information manager at a local hospital. A physician on the medical staff does not understand how to add H&P notes to a patient’s EHR. He explains that he “always used to handwrite the H&P.” You explain to the physician that he can no longer handwrite his H&P notes, and you give him two options of how he can add his H&P notes to the EHR. Describe these two options. 2. You are a laboratory manager...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT