Question

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

2. 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.

3. 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

4. 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

5. 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%

6. 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.

Answer 1

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%

Occupancy rate 120.0% 115.0% 110.0% 105.0% 100.0% 95.0% 90.0% 85.0% 80.0%

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

Average LOS for the hospital 10.00 9.00 8.00 7.00 6.00 5.00 4.00 3.00 2.00 1.00 0.00 Medicine Service Surgical Service Averge LOS for hospital

Average LOS trend 2013 25 20 15 10 Jan Feb MarApr May Jun Aug Sep Oct Nov Dec Medicine Service Surgical Service Average LOS for hospital

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

No. of live births 69 67 65 62 61 60 58 59 58 52 52 48 Number of Lve Births @Jan u Feb Mar Apr四May QJun 데Jul nAug Sep E Oct E Nov Dec

4.

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

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