Washington Township Health Care District Washington Hospital - - PowerPoint PPT Presentation
Washington Township Health Care District Washington Hospital Operating Indicators April 2018 April YTD 12 Mo Over Over Avg Budget (Under) Budget (Under) Actual Actual Acute Inpatient Average Daily Census 161.6 153.3 184.8 (31.5)
12 Mo Avg Actual Budget Over (Under) Actual Budget Over (Under) Acute Inpatient Average Daily Census 161.6 153.3 184.8 (31.5) 161.4 168.3 (6.9) Admissions 1,045 978 1,106 (128) 10,445 10,250 195 Patient Days 4,913 4,599 5,545 (946) 49,078 51,167 (2,089) O/P Observation Equivalent Days 134 122 216 (94) 1,309 2,021 (712) ALOS (discharge days) 4.67 4.98 5.01 (0.03) 4.65 4.99 (0.34) April 2018 April YTD
12 Mo Avg Actual Budget Over (Under) Actual Budget Over (Under) Utilization Statistics CMI (discharge basis) 1.485 1.519 1.531 (0.012) 1.479 1.531 (0.052) Deliveries 142 113 169 (56) 1,403 1,497 (94) Surgical Cases 354 354 407 (53) 3,525 3,755 (230) Joint Replacement Cases 139 160 152 8 1,383 1,375 8 Neurosurgical Cases 24 15 29 (14) 235 268 (33) Cardiac Surgical Cases 9 8 13 (5) 89 107 (18) Cath Lab Procedures 325 269 346 (77) 3,199 3,357 (158) Outpatient Visits 7,227 7,087 7,040 47 72,414 70,565 1,849 Emergency Visits 4,384 4,061 4,555 (494) 43,469 44,336 (867) April 2018 April YTD
Cath Lab Activity – May 2018
12 Month Avg Actual Budget (Over) Under Actual Budget (Over) Under
Productivity Indicators Productive FTEs 1,250.1 1,248.0 1,383.6 135.6 1,251.8 1,296.6 44.8 Nonproductive FTEs 180.8 180.4 178.5 (1.9) 184.1 189.0 4.9 Total FTEs 1,430.9 1,428.4 1,562.1 133.7 1,435.9 1,485.6 49.7 Total FTEs/Adjusted Occupied Bed 6.65 6.80 6.41 (0.39) 6.68 6.56 (0.12) April 2018 April YTD
(000s)
Actual Budget Variance % VAR. Actual Budget Variance % VAR. 158,911 186,831 (27,920) -14.9% Total Patient Rev 1,662,843 1,745,284 (82,441)
73.32% 76.77% Contractual % of Rev 75.31% 76.89% 43,503 43,948 (445)
Net Operating Rev 420,494 412,677 7,817 1.9% 40,646 41,309 663 1.6% Operating Expenses 399,986 400,532 546 0.1% 2,857 2,639 218 8.3% Operating Income (Loss) 20,508 12,145 8,363 68.9% 6.6% 6.0% Operating Margin 4.9% 2.9%
314 285 29 10.2% Investment Income 2,825 2,806 19 0.7% (34)
0.0% Realized Gain/(Loss) on Investments (295)
0.0% 270 305 (35)
Rental Income, Net 2,440 3,058 (618)
(185) (185)
Amortization of Intangible Assets (1,844) (1,844)
1,356 1,355 1 0.1% Property Tax Revenue 13,548 13,528 20 0.1% (466)
0.0% Unrealized Gain/(Loss) on Investments (2,545)
0.0%
1,255 1,760 (505) -28.7% Non-Operating Inc & Exp 14,129 17,548 (3,419) -19.5% 4,112 4,399 (287)
Net Income (Loss) 34,637 29,693 4,944 16.7% 9.5% 10.0% Total Margin 8.2% 7.2% April 2018 April YTD
(000s)
Actual Budget Variance % VAR. Actual Budget Variance % VAR. 158,911 186,831 (27,920)
Total Patient Rev 1,662,843 1,745,284 (82,441)
73.32% 76.77% Contractual % of Rev 75.31% 76.89% 43,503 43,948 (445)
Net Operating Rev 420,494 412,677 7,817 1.9% 40,646 41,309 663 1.6% Operating Expenses 399,986 400,532 546 0.1% 2,857 2,639 218 8.3% Operating Income (Loss) 20,508 12,145 8,363 68.9% 6.6% 6.0% Operating Margin 4.9% 2.9% 314 285 29 10.2%
Investment Income
2,825 2,806 19 0.7% (34)
0.0%
Realized Gain/(Loss) on Investments
(295)
0.0% 270 305 (35)
Rental Income, Net
2,440 3,058 (618)
(185) (185)
Amortization of Intangible Assets
(1,844) (1,844)
365 405 (40)
Non-Operating Inc & Exp 3,126 4,020 (894)
3,222 3,044 178 5.8% Net Income (Loss) 23,634 16,165 7,469 46.2% 7.4% 6.9% Total Margin 5.6% 3.9% April 2018 April YTD
1
% May Actual Budget Variance Variance 2017 IP Gross Revenue $121,906 $134,350 ($12,444) (9.3%) $130,372 OP Gross Revenue $47,107 $45,335 $1,772 3.9% $45,500 Total Gross Revenue $169,013 $179,685 ($10,672) (5.9%) $175,872
2
% Actual Budget Variance Variance Cath Lab Procedures $13,812 $11,531 $2,281 19.8% Birthing Center $3,204 $3,808 ($604) (15.9%) Emergency Room $10,180 $10,975 ($795) (7.2%) Room & Board $30,866 $37,465 ($6,599) (17.6%) Ancillary Services $74,369 $79,577 ($5,208) (6.5%)
In Thousands
3
% May Actual Budget Variance Variance 2017 ALOS (discharge based) 4.47 4.93 (0.46) (9.3%) 4.62 OP Observation Days 147 203 (56) (27.6%) 156 Average Daily Census 145.6 172.1 (26.5) (15.4%) 164.4
4
% May Actual Budget Variance Variance 2017 1,012 1,082 (70) (6.5%) 1,090
500 700 900 1100 1300 Actual Budget
5
% May Actual Budget Variance Variance 2017 4,514 5,336 (822)
5,096
3500 4000 4500 5000 5500 6000 Actual Budget
6
% May Actual Budget Variance Variance 2017 375 396 (21) (5.3%) 376
200 250 300 350 400 450 500 550 600 Actual Budget
7
% Actual Budget Variance Variance Joint Replacement Surgery 153 139 14 10.1% Cardiac Surgery 12 10 2 20.0% Neuro Surgery 28 28 0.0% General Surgery 182 219 (37) (16.9%) Total 375 396 (21) (5.3%) Surgery Detail
8
% May Actual Budget Variance Variance 2017 335 328 7 2.1% 343
200 250 300 350 400 450 Actual Budget
9
% Actual Budget Variance Variance Peripheral Vascular Procedures 144 123 21 17.1% Cardiac Procedures 140 120 20 16.7% Neuro IR Procedures 6 12 (6) (50.0%) Non-Vascular IR Procedures 45 73 (28) (38.4%) Total 335 328 7 2.1%
10
% May Actual Budget Variance Variance 2017 130 169 (39) (23.1%) 156
100 120 140 160 180 200 Actual Budget
11
% May Actual Budget Variance Variance 2017 7,481 7,458 23 0.3% 7,217
5000 6000 7000 8000 9000 Actual Budget
12
% May Actual Budget Variance Variance 2017 4,237 4,612 (375) (8.1%) 4,776
3000 3500 4000 4500 5000 5500 Actual Budget
13
% May Actual Budget Variance Variance 2017 Productive FTEs 1,216.1 1,324.7 108.6 8.2% 1,274.4 Nonproductive FTEs 151.8 153.1 1.3 0.8% 136.0 Total FTEs 1,367.9 1,477.8 109.9 7.4% 1,410.4 Productive FTE/AOB 6.02 5.76 (0.26) (4.5%) 5.75 Total FTE/AOB 6.78 6.42 (0.36) (5.6%) 6.36
14
% May Actual Budget Variance Variance 2017 WOSC Surgical Cases 474 498 (24) (4.8%) 508 Clinic Visits 3,403 4,003 (600) (15.0%) 3,875
15
May Gross Revenue Actual Budget Variance 2017 Total Medicare Sponsored 53.5% 52.4% 1.1% 49.2% Total Medi-Cal Sponsored 20.5% 19.4% 1.1% 23.4% Total Government Sponsored 74.0% 71.8% 2.2% 72.6% HMO 1.9% 3.0% (1.1%) 2.9% PPO 22.2% 23.4% (1.2%) 23.0% Private Pay 1.9% 1.8% 0.1% 1.5%
16
Prior Prior Actual Month Year Days Cash on Hand 178 176 172 Days in A/R 55 53 57 Charity Care $104,911 $355,768 $475,088