NP Ex 4-4

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 14

Spirit Care Hospital & Clinic

Author Nguyen Dieu Quynh Anh


Date 11/8/2024
Purpose To report on patient care and patient
satisfaction at the Spirit Care Hospital &
Clinic in the Pine Ridge reservation
Spirit Care Hospital & Clinic
Year-End Summary

Department Inpatient Outpatient This chart isn't available in your version of Excel. 4,000
3,500
Cardiology 4,832 5,413 Editing this shape or saving this workbook into a different file format 3,000
will permanently break the chart.
Dermatology 1,760 2,564 2,500
2,000
Gynaecology 1,821 2,825 1,500
Neurology 1,269 2,360 1,000
500
Oncology 1,103 2,095
31,025 Othopaedics 1,248 1,845
-
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Total Patients Surgery 1,510 380 Inpatient Outpatient

This chart isn't available in your version of Excel. This chart isn't available in your version of Excel.
Admissions and 30-Day Readmissions Rate
Editing this shape or saving this workbook into a different file format 5,000 30.00% Editing this shape or saving this workbook into a different
will permanently break the chart. 4,500 file format will permanently break the chart.

Impatient Admissions
4,000
25.00%

Readmission Rate
3,500
3,000
2,500 20.00%
2,000
1,500
15.00%
1,000
500
- 10.00%
Qtr 1 Qtr 2 Qtr 3 Qtr 4

3.54 days
Quarter

Avg. Length of Stay inpatient Admissions Readmission Rate

Department Avg. Waiting Times (min.) Monthly Trend Average Nurse to Patient Ratio
Cardiology 17.03
Dermatology 20.77 Day Shift 1:4 Trauma Units 1:1
Gynaecology 23.27 Emergency Rooms 1:3
Neurology 23.63 Surgical Rooms 1:5
Oncology 11.15 Rehabilitation Units 1:6
19.50 min Othopaedics 19.68 Night Shift 1:8 Nursery Units 1:8
Avg. ER Waiting Time Surgery 20.95
Spirit Care Hospital & Clinic
Average Waiting Time (min.) per Month

Month Inpatient Outpatient


Jan 865 1,273
Feb 646 719
Mar 854 1,027
Apr 966 1,183
May 1,213 1,596
Jun 1,315 1,891
Jul 1,518 1,871
Aug 1,408 1,755
Sep 1,465 1,880
Oct 988 1,228
Nov 1,121 1,496
Dec 1,184 1,563
Total 13,543 17,482
Spirit Care Hospital & Clinic
Sample Length of Stay (Days)

Inpatient Stay
5 days
0 days
3 days
3 days
4 days
5 days
3 days
2 days
0 days
1 days
6 days
4 days
4 days
1 days
3 days
5 days
4 days
2 days
7 days
3 days
2 days
6 days
4 days
1 days
11 days
2 days
3 days
3 days
4 days
3 days
1 days
5 days
6 days
2 days
1 days
3 days
3 days
8 days
3 days
2 days
4 days
3 days
3 days
1 days
4 days
5 days
1 days
3 days
3 days
3 days
4 days
3 days
3 days
1 days
4 days
2 days
6 days
0 days
5 days
3 days
1 days
2 days
3 days
12 days
2 days
7 days
12 days
5 days
5 days
4 days
3 days
13 days
1 days
4 days
2 days
6 days
4 days
2 days
4 days
4 days
2 days
3 days
3 days
0 days
3 days
6 days
6 days
12 days
6 days
1 days
1 days
3 days
3 days
3 days
12 days
3 days
2 days
3 days
1 days
5 days
4 days
4 days
4 days
14 days
2 days
3 days
5 days
4 days
2 days
8 days
4 days
4 days
4 days
12 days
2 days
5 days
3 days
4 days
2 days
11 days
2 days
3 days
2 days
2 days
1 days
0 days
4 days
5 days
0 days
3 days
2 days
2 days
1 days
2 days
0 days
1 days
1 days
3 days
3 days
3 days
6 days
3 days
3 days
6 days
1 days
3 days
2 days
2 days
2 days
3 days
3 days
2 days
12 days
3 days
2 days
3 days
2 days
4 days
3 days
6 days
2 days
3 days
3 days
2 days
0 days
2 days
2 days
2 days
3 days
6 days
3 days
3 days
6 days
1 days
5 days
1 days
0 days
3 days
5 days
3 days
3 days
2 days
0 days
3 days
11 days
3 days
3 days
4 days
6 days
5 days
3 days
5 days
3 days
3 days
4 days
3 days
3 days
4 days
3 days
2 days
3 days
8 days
4 days
3 days
3 days
2 days
4 days
2 days
2 days
1 days
4 days
5 days
1 days
6 days
4 days
12 days
3 days
3 days
1 days
3 days
1 days
3 days
1 days
3 days
7 days
1 days
2 days
2 days
4 days
3 days
1 days
4 days
3 days
3 days
2 days
3 days
0 days
5 days
5 days
3 days
3 days
2 days
12 days
4 days
2 days
3 days
2 days
5 days
6 days
4 days
4 days
1 days
4 days
3 days
1 days
3 days
6 days
2 days
2 days
2 days
3 days
4 days
5 days
5 days
5 days
12 days
5 days
4 days
3 days
2 days
4 days
6 days
3 days
2 days
5 days
2 days
4 days
4 days
12 days
4 days
1 days
5 days
1 days
7 days
2 days
2 days
1 days
6 days
1 days
3 days
3 days
5 days
4 days
2 days
0 days
2 days
4 days
1 days
3 days
0 days
Spirit Care Hospital & Clinic
Admissions and 30-Day Readmission Rate

Quarter inpatient Admissions Readmission Rate


Qtr 1 2,365 14.48%
Qtr 2 3,494 21.29%
Qtr 3 4,391 23.81%
Qtr 4 3,293 19.48%
Spirit Care Hospital & Clinic
Admissions by Payer

Payer Admissions
Medicaid 6,825
Medicare 12,100
Insurance 9,618
Uninsured 2,482
Spirit Care Hospital & Clinic
Average Waiting Time (min.) per Month

Month Cardiology Dermatology Gynaecology Neurology Oncology Othopaedics


Jan 18.02 18.85 17.87 19.92 13.87 19.76
Feb 17.38 19.48 19.53 20.40 13.01 20.25
Mar 17.10 19.47 20.97 21.62 13.51 20.24
Apr 17.90 20.14 21.45 22.12 12.82 21.02
May 17.55 19.75 23.23 23.09 10.31 21.75
Jun 16.56 20.74 24.41 25.20 10.70 20.04
Jul 16.74 21.32 23.94 24.92 10.27 19.32
Aug 17.67 22.40 24.63 24.98 9.87 18.12
Sep 17.35 21.13 25.45 24.66 11.26 18.98
Oct 17.03 21.03 26.53 25.46 9.35 20.16
Nov 15.95 23.13 25.32 25.14 9.95 18.76
Dec 15.11 21.78 25.89 26.08 8.83 17.79
Surgery
22.89
23.78
24.59
24.38
23.12
21.96
19.66
19.65
19.37
18.22
16.53
17.20

You might also like