In: Statistics and Probability
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:
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 |
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.
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 |
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 |
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% |
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.
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% |