Being part of Western Healthcare System, means that your hospital is compared with a few more hospitals in that system. You are provided with the first month of data pertaining to the operation of their HIM departments. The data provided in the

Excel spreadsheet – HIM Dashboard

are used to evaluate the performance of each hospital and across the health system. Western Healthcare System has also established benchmark standards for each of the key performance metrics (see Best Practice Standard at the bottom of the spreadsheet).   

Tasks:

• Focusing on Hospital D (which is the one you work for), select the appropriate graphs to represent the data for each metric along with the corresponding corporate average and best practice standard for that data element. (30 points)
• Identify issues that are concerning and opportunities for improvement pertaining to any of the metrics across the corporation. Explain why they are concerning. Explain Hospital D performance in the area(s) identified. (20 points)
• Knowing the position of hospital D in the dashboard, identify opportunities for improvement. What additional data would you request and what additional analysis would you perform? 

Sheet1

Western Healthcare System HIM Dashboard – March 202x Charts Received Scan days Index days Quality Review of Scanning/Indexing Process in Days Analysis Days Delinquency Rate Community Region Inpatient (

IP

) Next Day Same day Surgery (

SDS

)2 days Emergency Department (

ED

) Next Day

IP SDS ED

Out-patient (

OP

)

IP SDS ED OP IP SDS ED IP SDS ED
Hospital A 10

0% 96% 9

8

% 2.0

2.0 2.0

1.0

2.0 1.0 1.0 2.0

11.0

11.0

3.0

3.0 3.0 2.0

5% Hospital B 100%

100% 100% 1.0

0.0

1.0 2.0 2.0 1.0 2.0 2.0 1.0 1.0 1.0 1.0 2.0 1.0 0%
Hospital C

100% 100% 100% 0.0 1.0 2.0 1.0 3.0 0.0 2.0 0.0 0.0 0.0 0.0 1.0 3.0 1.0 8%
Urban Region Hospital D 9

9% 99% 69%

2.0 3.0 1.0 1.0 0.0 1.0 0.0 1.0

55.0 45.0

0.0

4.0

1.0 0.0

12% Hospital E

96%

97% 77%

0.0 1.0 2.0 3.0 1.0 2.0 1.0 2.0

1

30.0

130.0

120.0

2.0

32.0

30.0

23% Hospital F 86% 95% 89%

1.0 2.0 3.0 1.0 2.0 0.0 2.0 2.0

145.0

45.0 32.0 3.0

7.0

4.0

18% Corporate average

97%

98%

89% 1.0

1.5

8 1.83

1.5

1.67 0.83 1.33

1.5

57.0 38.67 26.0 2.33

8

6.33

9%
Best Practice Standard

100% 100% 100% 2.0 2.0 1.0 1.0 2.0 1.0 1.0 1.0 1.0 1.0 1.0 2.0 2.0 1.0

<15% Charts Received Scan days Index days

Quality Review of Scanning/Indexing process n

Analysis Days Delinquency Rate
IP SDS ED IP SDS ED OP IP SDS ED OP IP SDS ED IP SDS ED
Hospital D 99% 99% 69%

2.00

3.0

1.00

1.00

0.00

1.00 0.00 1.00

55.00 45.00

0.00

4.00

1.00 0.00 12%
Corporate average 97% 98% 89% 1.00

1.58

1.83

1.50

1.67 0.83 1.33 1.50

57.00

38.67

26.00

2.33

8.00

6.33 9%
Best Practice Standard 100% 100% 100% 2.00 2.00 1.00 1.00 2.00 1.00 1.00 1.00 1.00 1.00 1.00 2.00 2.00 1.00 <15% Scan days
IP SDS ED OP
Hospital D 2.00 3.0 1.00 1.00
Corporate average 1.00 1.58 1.83 1.50
Best Practice Standard 2.00 2.00 1.00 1.00
Index days

IP SDS ED OP

Hospital D 0.00 1.00 0.00 1.00
Corporate average 1.67 0.83 1.33 1.50
Best Practice Standard 2.00 1.00 1.00 1.00

Review of scanning/Indexing process

in

IP SDS ED
Hospital D 55.00 45.00 0.00
Corporate average 57.00 38.67 26.00
Best Practice Standard 1.00 1.00 1.00
Analysis Days

IP SDS ED

Hospital D 4.00 1.00 0.00
Corporate average 2.33 8.00 6.33
Best Practice Standard 2.00 2.00 1.00
Delinquency Rate
Hospital D 12%
Corporate average 9%
Best Practice Standard <15%

Charts Received Charts Received IP Hospital D Corporate average Best Practice Standard 0.99 0.97 1 Charts Received SDS Hospital D Corporate average Best Practice Standard 0.99 0.98 1 Charts Received ED Hospital D Corporate average Best Practice Standard 0.69 0.89 1 Scan days Hospital D IP SDS ED OP 2 3 1 1 Corporate average IP SDS ED OP 1 1.58 1.83 1.5 Best Practice Standard IP SDS ED OP 2 2 1 1 Index days Hospital D IP SDS ED OP 0 1 0 1 Corporate average IP SDS ED OP 1.67 0.83 1.33 1.5 Best Practice Standard IP SDS ED OP 2 1 1 1 Review of scanning/Indexing process
Hospital D IP SDS ED 55 45 0 Corporate average IP SDS ED 57 38.67 26 Best Practice Standard IP SDS ED 1 1 1 Analysis Days Hospital D IP SDS ED 4 1 0 Corporate average IP SDS ED 2.33 8 6.33 Best Practice Standard IP SDS ED 2 2 1