Financial report (pdf) - Memorial Hospital of Converse County

Memorial Hospital of Converse County
Financial and Statistical Packet
Table of Contents - December 2014
Admissions and Avg. IP Daily Census Graphs
Page #
1
Average Floor Census Breakdown Graph
2
Average Monthly Inpatient Admissions by Physician Graph
3
Average Length of Stay by Physician Graph
4
Payor Mix Comparisons and Emergency Room Visits Graphs
5
Total Surgeries and Orthopedic Surgeries Graphs
6
General and OB/GYN Surgery Graphs
7
Procedure Core Visits Graphs
8
Mammography Exams Graph
9
MRI and Cat Scan Graphs
10
Nuclear Medicine and Ultrasound Exams Graphs
11
Lab Procedures and Other X-Ray Graphs
12
Newborns and Net Days of Revenue in A/R Graphs
13
Respiratory and EKG Procedures Graphs
14
Hospital Revenue Graph
15
Income Statement and Budget Variance Report
16
Financial and Statistical Highlights
17
Statistics (Ratios - Productivity Indicators)
18
Balance Sheet
19
Cash Flow Statement
20
Memorial Hospital of Converse County
Admissions and Avg. IP Daily Census
Dec 2014
Admissions
120
100
80
60
40
20
0
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
77
75
84
Feb.
63
75
95
Mar
78
75
72
Apr
89
75
77
May
92
75
87
June
100
75
83
July
89
81
68
Current 12 mo. avg. = 84
Aug
85
81
91
Sep
94
81
78
Oct
70
81
78
Nov
81
81
59
Dec
86
81
63
Previous 12 mo. avg. = 78
Average IP Daily Census
10.00
9.00
8.00
7.00
6.00
5.00
4.00
3.00
2.00
1.00
0.00
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
7.32
9.17
7.61
Feb.
6.14
9.17
9.50
Mar
6.48
9.17
6.68
Apr
8.03
9.17
6.93
May
9.42
9.17
6.39
June
7.70
9.17
7.80
Curr. 12 mo. avg. = 7.41
July
9.23
6.84
5.71
Aug
7.58
6.84
7.35
Sep
7.23
6.84
5.60
Oct
6.61
6.84
6.65
Nov
6.83
6.84
4.17
Dec
6.29
6.84
5.10
Prev. 12 mo. avg. = 6.62
Page 1
Memorial Hospital of Converse County
(FY 2014) Average Floor Census Breakdown
Dec 2014
(FY 2015) Average Floor Census Breakdown
14.00
12.00
2.58
2.33
0.56
0.60
10.00
1.13
8.00
1.97
2.02
3.00
0.71
0.67
1.10
0.51
0.65
1.00
6.00
9.23
4.00
9.17
7.58
7.23
7.69
6.61
6.29
2.00
0.00
SB
OBS
IP
Jul.
Aug.
Sep.
Oct.
Nov.
Dec.
2.58
0.56
9.23
1.13
0.71
7.58
1.97
0.51
7.23
3.00
0.65
6.61
2.33
0.60
9.17
1.10
1.00
6.29
IP
Jan.
Feb.
Mar.
Apr.
May
June
Average
2.02
0.67
7.69
OBS
SB
Page 2
Memorial Hospital of Converse County
Average Monthly Inpatient Admissions by Physician
Dec 2014
Average Monthly Inpatient Admissions by Physician Based on Previous 12 Months
40.00
35.00
30.00
25.00
20.00
15.00
10.00
5.00
0.00
Page 3
Memorial Hospital of Converse County
Average Length of Stay by Physician
Dec 2014
Average Length of Stay by Physician for Fiscal Year 2015
4.00
3.50
3.00
2.50
2.00
1.50
1.00
0.50
0.00
Retherford
Lansang
Thalken
Hospitalist
Grosdidier
White, W.
Croft
Skuza
Yost
Engle
Current Month Avg. Length of Stay
0.00
2.00
0.00
0.00
2.52
2.25
0.00
2.40
2.33
1.71
2.00
1.96
YTD FY 2015 Avg. Length of Stay
0.00
1.50
0.00
0.00
3.25
2.45
0.00
3.52
2.83
1.61
1.50
1.80
Page 4
Memorial Hospital of Converse County
Payor Mix Comparisons and ER Visits
Dec 2014
Payor Mix Comparisons
50.00%
45.00%
40.00%
35.00%
30.00%
25.00%
20.00%
15.00%
10.00%
5.00%
0.00%
Insurance
Medicare
Medicaid
Self Pay
Workers Comp.
Other
Payors
Fiscal Year 2014
Fiscal Year 2015
Emergency Room Visits
800
700
600
500
400
300
200
100
0
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
447
507
492
Feb.
393
507
485
Mar
429
507
514
Apr
474
507
418
May
582
507
514
June
565
507
491
Curr. 12 mo. avg. = 538
July
626
477
482
Aug
703
477
532
Sep
661
477
446
Oct
503
477
455
Nov
546
477
384
Dec
525
477
371
Prev. 12. mo. avg. = 465
Page 5
Memorial Hospital of Converse County
Total Surgeries and Orthopedic Surgeries
Dec 2014
Total Surgeries
160
140
120
100
80
60
40
20
0
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
93
119
139
Feb.
94
119
108
Mar
77
119
101
Apr
100
119
126
May
88
119
134
June
98
119
108
July
83
105
139
Current 12 mo. avg. = 94
Aug
88
105
118
Sep
85
105
97
Oct
110
105
105
Nov
89
105
94
Dec
127
105
119
Previous 12 mo. avg. = 116
Orthopedic Surgeries
90
80
70
60
50
40
30
20
10
0
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
37
73
83
Feb.
42
73
71
Mar
40
73
55
Apr
39
73
80
May
49
73
70
June
37
73
66
Curr. 12 mo. avg. = 40
July
43
52
73
Aug
28
52
72
Sep
36
52
58
Oct
37
52
45
Nov
46
52
56
Dec
47
52
53
Prev. 12 mo. avg. = 65
Page 6
Memorial Hospital of Converse County
General and OB/GYN Surgeries
Dec 2014
General Surgeries
35
30
25
20
15
10
5
0
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
28
21
26
Feb.
25
21
19
Mar
20
21
16
Apr
22
21
20
May
22
21
23
June
24
21
26
July
23
24
28
Curr. 12 mo. avg. = 25
Aug
26
24
27
Sep
24
24
22
Oct
29
24
18
Nov
23
24
16
Dec
32
24
22
Prev. 12 mo. avg. = 22
OB/GYN Surgeries
14
12
10
8
6
4
2
0
Jan
Feb.
Mar
Apr
May
June
Curr. 12 mo. avg. = 9
Curr. 12 mo.
July
Aug
Sep
Oct
Nov
Dec
Prev. 12 mo. avg. = 10
Current Budget
Prev. 12 mo.
Page 7
Memorial Hospital of Converse County
Procedure Core Visits
Dec 2014
Procedure Core Visits
70
60
50
40
30
20
10
0
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
41
46
35
Feb.
49
46
47
Mar
64
46
57
Apr
37
46
44
May
45
46
44
June
41
46
35
July
47
49
40
Aug
44
49
41
Curr. 12 mo. avg. = 46
Sep
34
49
54
Oct
55
49
49
Nov
38
49
50
Dec
60
49
61
Prev. 12 mo. avg. = 46
Procedure Core Visit Types
100
90
80
70
40
60
50
40
48
30
20
Curr. 12 mo. Scopes
Curr. 12 mo. Minor Procedures
42
29
41
28
37
40
35
47
22
32
24
10
0
31
16
4
Jan
37
4
9
8
Feb.
41
8
Mar
48
16
Apr
28
9
5
6
May
40
5
June
35
6
July
40
47
15
12
Aug
29
15
Sep
22
12
18
6
Oct
31
24
Nov
32
6
Dec
42
18
Page 8
Memorial Hospital of Converse County
Mammography Exams
Dec 2014
Mammography Exams
140
120
100
80
60
40
20
0
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
93
90
82
Feb.
96
90
84
Mar
102
90
79
Apr
90
90
80
May
90
90
93
June
82
90
86
Curr. 12 mo. avg. = 93
July
95
94
80
Aug
96
94
84
Sep
92
94
65
Oct
112
94
75
Nov
81
94
117
Dec
92
94
95
Prev. 12 mo. avg. = 85
Page 9
Memorial Hospital of Converse County
MRI & Cat Scans
Dec 2014
MRI Exams
120
100
80
60
40
20
0
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
90
89
95
Feb.
70
89
79
Mar
94
89
78
Apr
76
89
86
May
88
89
73
June
97
89
88
Curr. 12 mo. avg. = 89
July
105
84
61
Aug
82
84
71
Sep
94
84
65
Oct
93
84
91
Nov
79
84
96
Dec
97
84
83
Prev. 12 mo. avg. = 81
CT Exams
300
250
200
150
100
50
0
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
189
169
194
Feb.
152
169
171
Mar
158
169
196
Apr
181
169
182
May
195
169
276
June
164
169
225
Curr. 12 mo. avg. = 198
July
214
201
246
Aug
253
201
275
Sep
242
201
233
Oct
201
201
226
Nov
176
201
174
Dec
247
201
155
Prev. 12 mo. avg. = 213
Page 10
Memorial Hospital of Converse County
Nuclear Med and Ultrasound Exams
Dec 2014
Nuclear Medicine Exams
40
35
30
25
20
15
10
5
0
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
26
18
30
Feb.
20
18
29
Mar
25
18
20
Apr
28
18
13
May
36
18
14
June
36
18
21
July
38
25
26
Curr. 12 mo. avg = 29
Aug
30
25
16
Sep
27
25
22
Oct
38
25
16
Nov
13
25
19
Dec
32
25
13
Nov
144
176
148
Dec
190
176
191
Prev. 12 mo. avg. = 20
Ultrasound Exams
250
200
150
100
50
0
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
149
158
157
Feb.
140
158
184
Mar
192
158
164
Apr
204
158
142
May
224
158
186
June
199
158
172
Curr. 12 mo. avg. = 191
July
214
176
145
Aug
228
176
156
Sep
206
176
147
Oct
198
176
156
Prev. 12 mo. avg. = 162
Page 11
Memorial Hospital of Converse County
Lab Procedures and Other X-Ray Exams
Dec 2014
Lab Procedures
45,000
40,000
35,000
30,000
25,000
20,000
15,000
10,000
5,000
0
Jan
Feb.
Mar
Apr
May
June
July
Aug
Sep
Oct
Nov
Dec
Curr. 12 mo.
25,973 22,836 27,622 38,230 30,980 29,091 32,256 40,728 34,548 33,336 26,829 29,939
Current Budget 23,409 23,409 23,409 23,409 23,409 23,409 29,531 29,531 29,531 29,531 29,531 29,531
Prev. 12 mo.
29,217 24,029 25,658 34,126 29,692 25,921 29,163 40,549 24,336 30,996 21,915 22,361
Curr. 12 mo. avg. = 31,031
Prev. 12 mo. avg. = 28,164
Total Other X-Ray Exams
700
600
500
400
300
200
100
0
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
499
423
413
Feb.
437
423
387
Mar
505
423
362
Apr
559
423
359
May
602
423
440
June
486
423
466
Curr. 12 mo. avg. = 541
July
625
483
448
Aug
624
483
462
Sep
598
483
440
Oct
598
483
433
Nov
450
483
399
Dec
503
483
355
Prev. 12 mo. avg. = 414
Page 12
Memorial Hospital of Converse County
Newborns and Net A/R Days
Dec 2014
Newborns
20
18
16
14
12
10
8
6
4
2
0
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Jan
12
11
12
Feb.
12
11
16
Mar
17
11
11
Apr
16
11
13
May
12
11
15
June
19
11
14
July
14
15
9
Curr. 12 mo. avg. = 14
Aug
12
15
17
Sep
14
15
11
Oct
8
15
16
Nov
15
15
12
Dec
17
15
12
Nov
69.09
53.00
55.62
Dec
64.15
53.00
53.61
Prev. 12 mo. avg. = 13
Net Days of Revenue in A/R
80.00
70.00
60.00
50.00
40.00
30.00
20.00
10.00
0.00
Jan
Curr. 12 mo.
57.25
Current Budget 53.00
Prev. 12 mo.
43.26
Feb.
54.43
53.00
50.34
Mar
53.54
53.00
59.35
Apr
61.17
53.00
56.48
May
65.31
53.00
62.21
June
71.01
53.00
63.07
Curr. 12 mo. avg. = 63.68
July
63.76
53.00
62.15
Aug
67.46
53.00
61.79
Sep
69.98
53.00
60.50
Oct
67.01
53.00
57.03
Prev. 12 mo. avg. = 57.95
Page 13
Memorial Hospital of Converse County
Respiratory and EKG Procedures
Dec 2014
Respiratory Procedures
5000
4500
4000
3500
3000
2500
2000
1500
1000
500
0
Jan
Feb.
Mar
Apr
May
June
July
Current 12 mo. Avg = 3,460
Curr. 12 mo.
Aug
Sep
Oct
Nov
Previous 12 mo. Avg. = 3,239
Current Budget
Dec
Prev. 12 mo.
EKG Procedures
500
450
400
350
300
250
200
150
100
50
0
Jan
Feb.
Mar
Apr
May
Current 12 mo. Avg. = 373
Curr. 12 mo.
June
July
Aug
Sep
Oct
Nov
Dec
Previous 12 mo. Avg. = 372
Current Budget
Prev. 12 mo.
Page 14
Memorial Hospital of Converse County
Hospital Patient Revenues
Dec 2014
Hospital Patient Revenues
7,000,000
6,000,000
5,000,000
4,000,000
3,000,000
2,000,000
1,000,000
0
Curr. 12 mo.
Jan
5,037,823
Feb.
4,732,954
Mar
4,679,530
Apr
5,688,110
May
6,044,398
June
5,973,921
July
6,284,035
Aug
6,179,897
Sep
6,582,246
Oct
6,384,088
Nov
6,214,322
Dec
6,623,555
Current Budget
5,424,304
4,818,806
4,818,806
4,870,486
4,637,970
5,134,485
5,522,322
4,988,287
5,522,327
5,344,299
5,522,325
5,522,325
Prev. 12 mo.
4,654,329
4,589,688
4,385,660
4,209,355
3,701,345
4,618,919
4,388,895
5,014,654
4,581,501
4,556,531
3,832,418
4,681,439
Curr. 12 mo. avg. = $5,868,740
Prev. 12 mo. avg. = $4,434,561
Page 15
Memorial Hospital of Converse County
Income Statement Summary
Budget Variance Report
Current Month
Year to Date
Dec 2014
Budget
Variance
Amount
$1,527,507
3,393,495
1,702,553
$6,623,555
$1,312,863
2,703,165
1,328,276
$5,344,304
$214,644
690,330
374,277
$1,279,251
534,432
421,778
65,004
627,700
115,658
$1,764,572
368,444
234,469
40,993
410,448
81,985
$1,136,339
4,858,983
December
YTD Thru
Dec 2014
YTD
Budget
Prior Year YTD
Variance
Amount
YTD Thru
Dec 2013
Change From
Prior YTD
Patient Revenue
Inpatient
Outpatient
Physician Clinics
Total Patient Revenue
$10,017,183
18,531,854
9,719,105
$38,268,142
$7,920,940
16,309,130
8,013,794
$32,243,864
$2,096,243
2,222,724
1,705,311
$6,024,278
$884,065
2,643,778
1,153,595
$4,681,438
$9,133,118
15,888,076
8,565,510
$33,586,704
165,988
187,309
24,011
217,252
33,673
$628,233
Deductions From Revenue
Medicare
Medicaid
Worker's Compensation
Other Contractuals
Other
Total Deductions
3,343,545
1,579,292
574,422
2,901,003
772,400
$9,170,662
2,222,942
1,414,631
247,321
2,476,369
494,643
$6,855,906
1,120,603
164,661
327,101
424,634
277,757
$2,314,756
349,783
248,958
105,368
225,904
97,847
$1,027,860
2,993,762
1,330,334
469,054
2,675,099
674,553
$8,142,802
4,207,965
651,018
Net Patient Revenue
29,097,480
25,387,958
3,709,522
3,653,578
25,443,902
33,725
$4,892,708
85,988
$4,293,953
(52,263)
$598,755
Other Operating Revenue
Total Operating Revenue
581,853
$29,679,333
515,928
$25,903,886
65,925
$3,775,447
199,400
$3,852,978
382,453
$25,826,355
2,241,845
550,688
570,223
107,514
70,244
1,018
13,475
101,940
56,895
41,483
35,059
25,539
34,929
49,775
341,664
691,536
$4,933,827
2,187,989
498,395
368,512
99,466
69,653
4,167
26,092
76,115
31,750
32,500
33,479
120,296
32,883
47,951
385,833
377,390
$4,392,471
53,856
52,293
201,711
8,048
591
(3,149)
(12,617)
25,825
25,145
8,983
1,580
(94,757)
2,046
1,824
(44,169)
314,146
$541,356
Operating Expenses
Salaries & Wages
Benefits
Supplies
Lease & Rentals
Other Expenses
Legal
Travel & Education
Maintenance & Repair
Physician Fees
Interest
Professional Fees
Purchased Services
Insurance
Utilities
Depreciation
Indigent Care
Total Expenses
13,825,548
2,946,560
3,053,393
539,006
525,630
5,835
106,509
586,117
277,396
258,601
286,943
760,765
208,199
289,055
2,351,434
2,612,466
$28,633,457
13,200,879
2,990,379
2,211,102
596,798
417,978
25,000
156,528
456,696
190,500
195,000
200,872
721,783
197,300
287,710
2,315,000
2,265,009
$26,428,534
624,669
(43,819)
842,291
(57,792)
107,652
(19,165)
(50,019)
129,421
86,896
63,601
86,071
38,982
10,899
1,345
36,434
347,457
$2,204,923
2,025,548
596,258
515,989
105,780
86,849
4,777
28,060
80,387
33,797
30,775
142,126
135,621
31,254
46,186
372,138
357,157
$4,592,702
11,800,000
2,350,302
2,537,404
433,226
438,781
1,058
78,449
505,730
243,599
227,826
144,817
625,144
176,945
242,869
1,979,296
2,255,309
$24,040,755
(41,119)
(98,518)
57,399
Operating Income (Loss)
87,500
37,500
69,113
87,500
37,500
47,424
0
0
21,689
Non-Operating Revenue
County - Indigent Care Reimbursement
County - Ambulance Reimbursement
Other Non-Operating
0
$152,994
0
$73,906
0
$79,088
Non-Operating Expense
Net Income/(Loss)
1,045,876
(524,648)
525,000
375,000
220,654
525,000
225,000
284,550
0
$2,166,530
0
$509,902
1,570,524
0
150,000
(63,896)
0
$1,656,628
(739,724)
72,917
33,333
40,396
0
($593,078)
1,785,600
452,083
341,667
180,258
0
$2,759,608
Page 16
Memorial Hospital of Converse County
Financial and Statistical Highlights
Dec 2014
Page #
Patient Volumes
IP Daily Census……….
Surgeries……………. ..
Radiology Exams………
Laboratory Tests……. ..
Emer. Rm. Visits………
At 6.29 up 1.19 from December 2013 - down .54 from November 2014
At 127 up 8 from December 2013 - up 38 from November 2014
At 1,161 up 352 from December 2013 - up 218 from November 2014
At 29,939 up 7,578 from December 2013 - up 3,110 from November 2014
At 525 up 154 from December 2013 - down 21 from November 2014
1-2
6-7
9-12
12
5
Income Statement
Gross Patient Revenue for the month was $6,623,000 compared to $4,681,439 last December and
$6,214,000 last month. Net Income for December is $152,000 compared to ($593,077) last year
and $189,000 last month.
15
Monthly Revenue - over budget by $1,279,000
The departments that are under budget by $10,000 or more are as follows:
Med/Surg - 83,000
Swing Bed - 10,000
Deductions From Revenue - Over budget by $628,000
Monthly Expense Variances - Over budget by $541,000
Supplies - $201,000
Med/Surg - 12,000
Ambulance 3,100
Drugs - 64,500
Lab - 26,000
Cardiopulmonary - 6,200
Arbor Café - 6,000
Surgery - 100,000
Physician Services - 5,500
Physician Fees - $25,000
Hospitalists - 9,000
Radiologists - 2,600
ER - 13,000
Indigent Care - $314,000
Interest - $8,000
Lease & Rentals - $8,000
Housing & Storage
Insurance - $2,000
Benefits - $52,000
Health Insurance - 34,000
Retirement - 19,000
Maintenance & Repairs -$25,000
Surgery - 12,000
Facilities - 13,000
Professional Fees - $1,500
Surgery - 5,000
Salaries & Wages - $53,000
Utilities - $1,800
Electricity
Cash Status
Cash balances as of December 31, 2014 are $15,376,226
This equates to 108 days of expenses on hand.
Accounts Receivable
Net Accounts Receivable days are at 64.15 days for the end of December compared to 63.33 last year
and 69.09 last month.
Page 17
Memorial Hospital of Converse County
Statistics
For The Period Ended December 31, 2014
Monthly
Dec 2014
Dec 2013
Variance From
Prior Dec
Year to Date
Budget
Variance
Amount
%
86
1
63
4
23
(3)
79
4
7
(3)
87
67
20
83
4
195
34
158
53
37
(19)
208
55
(13)
(21)
-6.3%
-38.2%
229
211
18
263
(34)
-12.9%
17
34
12
21
5
13
15
23
2
11
13.3%
47.8%
127
119
8
105
22
3,241
525
2,532
371
709
154
2,817
477
3,766
2,903
863
3,294
327
315
12
331
Financial Ratios
Days Cash on Hand
Operating Margin
Dec 2014
108
Dec 2013
114
YTD Thru
Dec 2013
Variance From
Prior YTD
YTD Budget
Variance
Amt.
419
25
425
16
(6)
9
474
24
(55)
1
-11.6%
4.2%
Total A & P Admissions
444
441
3
498
(54)
-10.8%
A & P Patient Days - Regular
-Swing Bed
1,343
371
1,062
293
281
78
1,248
330
95
41
7.6%
12.4%
Total A & P Patient Days
1,714
1,355
359
1,578
136
8.6%
Newborn - Admissions
-Patients Days
80
142
77
122
3
20
90
138
(10)
4
-11.1%
2.9%
21.0%
Surgeries
582
672
(90)
630
(48)
-7.6%
424
48
15.1%
10.1%
Outpatient Registrations
ER Registrations
19,279
3,564
15,297
2,670
3,982
894
16,902
2,862
2,377
702
14.1%
24.5%
472
14.3%
Total Registrations
22,843
17,967
4,876
19,764
3,079
15.6%
-1.1%
FTE's
324
316
8
331
YTD
N/A
4.8%
US
69
WY
Misc. Measurements
86 Total Revenue per FTE
YTD - 15
$236,223
YTD - 14
$171,236
Variance From
Prior Year
$64,987
WY
$114,924
(7)
-19.20%
3.52%
0.68%
0.64% Contractual Deductions
23.96%
17.28%
6.68%
27.29%
-3.33%
Net Margin
3.13%
-15.39%
7.30%
2.33%
4.98% Inpatient Revenue %
35.09%
30.78%
4.31%
31.41%
3.68%
Current Ratio
6.05
4.37
64.91%
69.22%
-4.31%
68.59%
-3.68%
70.33
64.15
71.50
63.33
N/A
2.32
4.29 Outpatient Revenue %
Average Length of Stay
51.53
2.29
2.63
(0.34)
3.30
-2.2%
Variance
From WY
$121,299
-0.08%
Gross A/R Days
Net A/R Days
%
A & P Admissions - Regular
-Swing Bed
(4)
8.9%
-75.0%
YTD Thru
Dec 2014
(1.01)
55.62
Medicare Inp. Payer Mix
33.10%
25.00%
8.10%
Average I/P Daily Census
7.30
5.10
Salaries to Total Expense
48.29%
44.93%
3.36%
Benefits as % of Salaries
21.31%
23.18%
-1.87%
31.00%
2.10%
Medicare Rural Hospital Flexibility Program Monitoring Team - US CAH Median-2011
2.20
3.92
3.38
Medicare Rural Hospital Flexibility Program Monitoring Team -WY CAH Medium-2011
46.32%
1.97%
Page 18
Memorial Hospital of Converse County
Balance Sheet
December 31, 2014
Dec
2014
Dec
2013
ASSETS
CURRENT ASSETS
Cash On Hand And In Banks
Certificates Of Deposit - Unrestricted
Total Cash Assets
$5,194,210
1,731,695
$6,925,905
$7,159,649
618,390
$7,778,039
Helmsley Trust Grant
Total Designated Cash Assets
0
$0
0
$0
Assets Whose Use is Restricted
Bond Reserve Fund - (Bond Covenant Requirement)
Bond Payment Fund-(Bond Covenant Requirement)
Certificates of Deposit Securing Loan
Reserve Account - (Patient Contracts)
Additional (Bond Covenant Requirement)
Total Restricted Assets
628,360
158,899
5,000,000
12,413
2,650,648
$8,450,320
626,261
163,966
6,000,000
12,413
(385,751)
$6,416,889
Accounts Receivable (Gross)
Uncollectable Accts. & Contratual. Adj.
Net Patient Accounts
14,874,985
(4,861,077)
$10,013,908
11,520,734
(3,774,773)
$7,745,961
Due From Physicians
Inventories Of Supplies
Other Current Assets
Total Current Assets
107,988
1,070,302
3,019,234
$29,587,657
225,022
1,028,106
3,322,150
$26,516,167
31,118,752
28,991,059
283,888
7,762
$291,650
357,999
140,922
$498,921
$60,998,059
$56,006,147
LAND, BUILDING AND EQUIPMENT, net
OTHER ASSETS
Investment - Big Country Rehab
Investment - Powder River Imaging
Total Other Assets
Total Assets
LIABILITIES AND FUND EQUITY
CURRENT LIABILITIES
Accounts Payable
Accrued Bond Interest/Principal Payable
Accrued Salaries
Accrued Self Funded Health Ins.
Accrued Taxes And Deductions
Current Portion Of Capital Leases
Contingent Liability-(Patient Contracts)
Total Current Liabilities
1,878,083
(72,945)
2,241,415
0
580,774
253,146
12,413
$4,892,886
2,356,123
(59,001)
1,833,531
0
339,698
1,579,108
12,413
$6,061,872
OTHER LIABILITIES
Revenue Bonds Payable
Long Term EIB Accrual
Deferred Loss On Early Retirement Of Bonds
Discount On Bonds
Medicare Cost Report Settlement
Long Term Capital Lease Obligations
Total Other Liabilities
6,308,504
83,485
(587,840)
(30,494)
95,000
5,943,927
$11,812,582
6,768,333
81,793
(701,091)
(30,494)
95,000
942,551
$7,156,092
Total Liabilities
FUND EQUITY
Fund Balance
Net Income
$16,705,467
42,126,062
2,166,530
$13,217,964
43,759,841
(971,658)
Total Fund Balance
$44,292,592
$42,788,183
Total Liabilities And Fund Equity
$60,998,059
$56,006,147
Page 19
Cash Flow Statement for December 2014 and FYTD 2015
Cash Flow From Operations
Dec 2014
Net Earnings/(Loss)
Additions/Subtractions to Cash
Depreciation
Decrease/(Increase) in AR
(Decrease)/Increase in AP
Decrease/(Increase) in Inventory
Net Cash Flow From Operations
FYTD
$152,994
$2,166,530
341,664
906,660
(50,276)
7,568
$1,358,610
2,351,434
(862,765)
320,892
26,488
$4,002,579
Cash Flow from Investing
Equipment, Fixed Assets
Loan Advance
(188,048)
0
(1,168,182)
0
Cash Flow from Financing
Bonds, Notes Payable
(61,946)
(361,905)
Cash Flow for the Month Ending:
Dec 2014
$1,108,616
$2,472,492
Page 20
October
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Days
Recorded
31
IP
7
5
5
4
5
5
5
6
6
4
10
12
11
2
0
0
2
8
10
12
10
10
7
9
10
8
8
7
6
5
3
202
6.5
OBS
0
2
1
4
0
1
3
0
1
2
1
1
2
0
0
0
1
4
1
2
0
0
0
1
4
2
0
1
0
0
1
35
1.1
SW
2
2
2
1
1
1
1
1
1
1
1
1
1
2
2
2
2
1
1
1
1
1
1
1
2
2
2
2
2
2
4
47
9
9
8
9
6
7
9
7
8
7
12
14
14
4
2
2
5
13
12
15
11
11
8
11
16
12
10
10
8
7
8
1.5
9.2
Days
Recorded
30
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
IP
4
9
8
11
11
11
8
11
10
7
5
4
5
10
13
9
8
9
8
7
8
9
11
12
7
6
4
6
16
16
263
8.8
OBS
4
0
1
4
0
0
3
1
1
2
0
0
1
1
2
2
0
0
0
0
0
3
2
0
0
0
0
1
0
1
29
1.0
109
3.6
13.4
Days
Recorded
31
November
SW
4
3
2
2
2
2
3
4
2
3
4
3
3
3
3
2
3
3
3
3
5
5
4
4
6
6
6
6
5
5
12
12
11
17
13
13
14
16
13
12
9
7
9
14
18
13
11
12
11
10
13
17
17
16
13
12
10
13
21
22
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
IP
10
7
6
8
7
9
14
12
15
7
7
8
9
12
11
7
4
4
10
12
8
7
5
5
8
5
8
11
9
6
8
OBS
0
0
0
0
2
5
0
1
0
0
1
0
1
0
1
0
0
1
2
2
0
1
1
0
0
1
0
0
2
1
SB
5
5
5
5
3
2
3
4
4
3
3
1
2
2
1
1
1
1
1
1
1
2
2
2
2
2
3
3
3
4
December
Aug.
Sep.
Oct.
Nov.
Dec.
Jan.
Feb.
Mo's Rec
6
Mar.
Apr.
May
June
Average
259
8.4
IP
9.23
7.58
7.23
6.61
9.17
6.29
7.69
0
22
0.7
OBS
0.56
0.71
0.51
0.65
0.60
1.00
0.67
4
81
2.6
11.7
SB
2.58
12.37
1.13
9.42
1.97
9.71
3.00
10.26
2.33
12.10
1.10
8.39
Days
Recorded
31
Hi
Lo
16
2
22
7
January
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
IP
6
5
8
8
13
12
11
9
8
8
7
8
3
2
4
7
10
10
11
10
13
13
14
16
7
9
8
9
8
9
12
278
9.0
OBS
0
0
1
0
1
1
0
0
1
2
0
1
3
1
0
0
3
2
4
2
1
1
0
2
0
1
1
0
0
1
2
31
1.0
SB
3
4
4
3
3
2
4
4
6
4
3
3
4
5
5
5
3
3
2
3
3
3
3
3
6
4
3
3
3
4
4
112
3.6
13.6
Days
Recorded
28
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
February
IP
13
13
7
8
7
10
11
12
8
9
1
2
4
9
14
18
20
16
13
6
10
8
6
5
4
5
8
13
260
9.3
OBS
1
1
1
0
3
1
1
1
3
1
0
0
4
3
0
1
1
1
0
1
2
1
1
0
0
0
0
0
28
1.0
SB
4
3
4
3
3
2
3
2
3
5
4
4
3
2
2
2
3
4
4
2
2
2
2
2
2
2
3
3
80
2.9
13.1
Days
Recorded
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
7.7
March
IP
11
12
5
10
7
4
4
3
3
5
5
3
9
11
7
7
8
4
5
8
11
11
11
12
11
7
7
9
8
10
12
240
OBS
0
2
1
0
0
1
1
1
1
0
0
1
1
1
0
2
0
0
0
0
1
1
1
0
0
1
1
3
3
2
3
28
0.9
SB
4
4
4
4
4
3
2
2
3
3
3
3
3
3
3
1
1
1
1
2
2
3
2
2
1
1
2
2
2
2
2
75
2.4
11.1
Days
Recorded
30
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
April
IP
12
14
11
15
12
10
12
7
5
3
5
4
6
5
3
1
2
4
8
8
4
3
7
6
8
14
9
13
12
8
205
6.8
OBS
0
1
2
2
1
1
0
0
0
0
3
0
1
1
0
0
0
1
0
2
0
0
0
0
2
0
0
2
0
2
21
0.7
SB
2
2
2
2
2
2
1
1
1
1
1
2
2
2
2
2
2
2
2
2
3
3
3
4
4
3
4
4
4
5
72
2.4
9.9
Days
Recorded
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
6.6
May
0.00
0.00
0.00
0.00
0.00
0.00
2.02
10.38
0.00
31
IP
12
14
11
15
12
10
12
7
5
3
5
4
6
5
3
1
2
4
8
8
4
3
7
6
8
14
9
13
12
8
205
OBS
0
1
2
2
1
1
0
0
0
0
3
0
1
1
0
0
0
1
0
2
0
0
0
0
2
0
0
2
0
2
21
0.7
SB
2
2
2
2
2
2
1
1
1
1
1
2
2
2
2
2
2
2
2
2
3
3
3
4
4
3
4
4
4
5
72
2.3
9.6
Z:\Clients\Converse County\Admin\Client content\2015\Copy of December 2014 Financial Report (2).xlsm
Jul.
1/30/2015
Statistics
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Surgeries
Curr. 12 mo.
Current Budget
Prev. 12 mo.
IP Daily Census
Curr. 12 mo.
Current Budget
Prev. 12 mo.
CTs
Curr. 12 mo.
Current Budget
Prev. 12 mo.
MRIs
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Total Other X-ray Exams
Lab Procedures
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Emergency Room Visits
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Hospital Revenues
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Net Days of Revenue in A/R
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Orthopedic Surgeries
Dec 2014
Dec
Prior Dec Thru Dec Dec 2013
Dec 2014 Dec 2013 Prior Dec
Jan
93
119
139
Feb.
94
119
108
Mar
77
119
101
Apr
100
119
126
May
88
119
134
June
98
119
108
July
83
105
139
Aug
88
105
118
Sep
85
105
97
Oct
110
105
105
Nov
89
105
94
Dec
127
105
119
Jan
7.32
9.17
7.61
Feb.
6.14
9.17
9.50
Mar
6.48
9.17
6.68
Apr
8.03
9.17
6.93
May
9.42
9.17
6.39
June
7.70
9.17
7.80
July
9.23
6.84
5.71
Aug
7.58
6.84
7.35
Sep
7.23
6.84
5.60
Oct
6.61
6.84
6.65
Nov
6.83
6.84
4.17
Dec
6.29
6.84
5.10
Jan
189
169
194
Feb.
152
169
171
Mar
158
169
196
Apr
181
169
182
May
195
169
276
June
164
169
225
July
214
201
246
Aug
253
201
275
Sep
242
201
233
Oct
201
201
226
Nov
176
201
174
Dec
247
201
155
Jan
90
89
95
Feb.
70
89
79
Mar
94
89
78
Apr
76
89
86
May
88
89
73
June
97
89
88
July
105
84
61
Aug
82
84
71
Sep
94
84
65
Oct
93
84
91
Nov
79
84
96
Dec
97
84
83
Jan
499
423
413
Feb.
437
423
387
Mar
505
423
362
Apr
559
423
359
May
602
423
440
June
486
423
466
July
625
483
448
Aug
624
483
462
Sep
598
483
440
Oct
598
483
433
Nov
450
483
399
Dec
503
483
355
Jan
25,973
23,409
29,217
Feb.
22,836
23,409
24,029
Mar
27,622
23,409
25,658
Apr
38,230
23,409
34,126
May
30,980
23,409
29,692
June
29,091
23,409
25,921
July
32,256
29,531
29,163
Aug
40,728
29,531
40,549
Sep
34,548
29,531
24,336
Oct
33,336
29,531
30,996
Nov
26,829
29,531
21,915
Dec
29,939
29,531
22,361
Jan
447
507
492
Feb.
393
507
485
Mar
429
507
514
Apr
474
507
418
May
582
507
514
June
565
507
491
July
626
477
482
Aug
703
477
532
Sep
661
477
446
Oct
503
477
455
Nov
546
477
384
Dec
525
477
371
Jan
Feb.
Mar
Apr
May
June
July
Aug
Sep
Oct
Nov
Dec
5,037,823 4,732,954 4,679,530 5,688,110 6,044,398 5,973,921 6,284,035 6,179,897 6,582,246 6,384,088 6,214,322 6,623,555
5,424,304 4,818,806 4,818,806 4,870,486 4,637,970 5,134,485 5,522,322 4,988,287 5,522,327 5,344,299 5,522,325 5,522,325
4,654,329 4,589,688 4,385,660 4,209,355 3,701,345 4,618,919 4,388,895 5,014,654 4,581,501 4,556,531 3,832,418 4,681,439
Jan
57.25
53.00
43.26
Feb.
54.43
53.00
50.34
Mar
53.54
53.00
59.35
Apr
61.17
53.00
56.48
May
65.31
53.00
62.21
June
71.01
53.00
63.07
July
63.76
53.00
62.15
Aug
67.46
53.00
61.79
Sep
69.98
53.00
60.50
Oct
67.01
53.00
57.03
Nov
69.09
53.00
55.62
Dec
64.15
53.00
53.61
Jan
37
73
83
Feb.
42
73
71
Mar
40
73
55
Apr
39
73
80
May
49
73
70
June
37
73
66
July
43
52
73
Aug
28
52
72
Sep
36
52
58
Oct
37
52
45
Nov
46
52
56
Dec
47
52
53
Jan
Feb.
Mar
Apr
May
June
July
Aug
Sep
Oct
Nov
Dec
94
116
7.41
6.62
198
213
89
81
541
414
31,031
28,164
0
538
465
5,868,740
4,434,561
63.68
57.12
40
65
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Newborns
Curr. 12 mo.
Current Budget
Prev. 12 mo.
General Surgeries
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Procedure Core Visits
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Mammography
12
11
12
12
11
16
17
11
11
16
11
13
12
11
15
19
11
14
14
15
9
12
15
17
14
15
11
8
15
16
15
15
12
17
15
12
Jan
28
21
26
Feb.
25
21
19
Mar
20
21
16
Apr
22
21
20
May
22
21
23
June
24
21
26
July
23
24
28
Aug
26
24
27
Sep
24
24
22
Oct
29
24
18
Nov
23
24
16
Dec
32
24
22
Jan
41
46
35
Feb.
49
46
47
Mar
64
46
57
Apr
37
46
44
May
45
46
44
June
41
46
35
July
47
49
40
Aug
44
49
41
Sep
34
49
54
Oct
55
49
49
Nov
38
49
50
Dec
60
49
61
Jan
93
90
82
Feb.
96
90
84
Mar
102
90
79
Apr
90
90
80
May
90
90
93
June
82
90
86
July
95
94
80
Aug
96
94
84
Sep
92
94
65
Oct
112
94
75
Nov
81
94
117
Dec
92
94
95
Year
Dec-04
Dec-05
Dec-06
Dec-07
Dec-08
Dec-09
Dec-10
Dec-11
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Ultrasound
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Nuclear Medicine
Curr. 12 mo.
Current Budget
Prev. 12 mo.
OB/GYN Surgeries
Curr. 12 mo.
Current Budget
Prev. 12 mo.
Admissions
Fiscal Year 2014
Fiscal Year 2015
Payor Mix
13
25
22
46
46
93
85
Mammo Exams
977
1,037
1,081
1,101
1,154
1,231
1,208
979
Jan
149
158
157
Feb.
140
158
184
Mar
192
158
164
Apr
204
158
142
May
224
158
186
June
199
158
172
July
214
176
145
Aug
228
176
156
Sep
206
176
147
Oct
198
176
156
Nov
144
176
148
Dec
190
176
191
Jan
26
18
30
Feb.
20
18
29
Mar
25
18
20
Apr
28
18
13
May
36
18
14
June
36
18
21
July
38
25
26
Aug
30
25
16
Sep
27
25
22
Oct
38
25
16
Nov
13
25
19
Dec
32
25
13
Jan
11
11
9
Feb.
7
11
10
Mar
4
11
6
Apr
8
11
14
May
5
11
12
June
11
11
8
July
8
10
10
Aug
11
10
11
Sep
11
10
6
Oct
12
10
11
Nov
8
10
10
Dec
14
10
12
Jan
77
75
84
Feb.
63
75
95
Mar
78
75
72
Apr
89
75
77
May
92
75
87
June
100
75
83
July
89
81
68
Aug
85
81
91
Sep
94
81
78
Oct
70
81
78
Nov
81
81
59
Dec
86
81
63
Other
0.21%
0.17%
100.00%
100.00%
Aug
July
June
May
Apr
Mar
Feb.
Insurance
Medicare
Medicaid Self Pay
Workers Co
47.11%
32.17%
9.84%
6.79%
3.88%
45.73%
33.10%
9.18%
8.58%
3.24%
Avg.
14
Dec
Nov
Oct.
Sep
191
162
29
20
9
10
84
78
Jan
Thalken
Yost
Murphy
Retherford
Campbell
Rupp
Robertson
Lansang
Grosdidier
White, W.
Wortham
Engle
Hospitalist
Skuza
Croft
Newborns
Admissions
Curr. 12 mo. Minor Procedures
Curr. 12 mo. Scopes
Procedure Core Visits
0.08
0.25
0.58
3.25
3.17
0.00
4.42
0.00
2.75
1.92
0.92
9.67
33.67
1.42
5.17
13.92
81.17
0
0
0
2
5
0
6
0
3
4
0
12
29
2
6
17
86
0
0
0
2
5
0
7
0
5
2
0
10
30
0
5
15
81
0
0
0
3
3
0
6
0
3
2
0
8
30
3
4
8
70
0
2
0
4
4
0
6
0
3
2
0
10
42
3
5
13
94
0
1
0
5
2
0
2
0
4
2
0
6
46
0
5
12
85
0
0
0
6
4
0
4
0
2
4
0
7
43
0
5
14
89
0
0
0
7
5
0
5
0
4
1
0
8
42
1
4
19
96
0
0
1
3
3
0
4
0
4
2
0
8
49
0
4
12
90
0
0
0
4
2
0
6
0
2
1
0
8
38
1
9
16
87
0
0
0
1
3
0
3
0
0
0
3
23
20
5
6
17
81
0
0
0
0
1
0
2
0
2
2
3
8
12
1
8
12
51
Jan-00
0
0
0
0
Jan-00
0
0
0
0
Jan-00
0
0
0
0
Jan-00
0
0
0
0
Jan-00
0
0
0
0
Jan-00
0
0
0
0
Jan-00
0
0
0
0
Jan-00
0
0
0
0
Jan-00
0
0
0
0
Jan-00
0
0
0
0
Jan-00
0
0
0
0
Jan-00
0
0
0
0
Jan
4
37
Feb.
8
41
Mar
16
48
Apr
9
28
May
5
40
June
6
35
July
47
40
Aug
15
29
Sep
12
22
Oct
24
31
Nov
6
32
Dec
18
42
Avg. Length
of Stay
0.00
2.00
YTD FY
2015
Avg.
Length of
Stay
0.00
1.50
Lansang
Thalken
0.00
0.00
0.00
0.00
Hospitalist
Grosdidier
2.52
2.25
0.00
2.40
2.33
1.71
2.00
1.96
0.00
1.67
2.33
3.25
2.45
0.00
3.52
2.83
1.61
1.50
1.80
0.00
2.04
2.43
Jan
3965
3265
4302
Feb.
3160
3265
4647
Mar
3073
3265
3702
Apr
3461
3265
2894
May
3985
3265
2820
June
3531
3265
4070
July
3633
3228
2363
Aug
2855
3228
3195
Sep
3219
3228
2988
Oct
3654
3228
3195
Nov
3857
3228
1925
Dec
3124
3228
2765
Jan
358
366
442
Feb.
274
366
367
Mar
396
366
323
Apr
358
366
342
May
465
366
473
June
347
366
416
July
420
369
455
Aug
382
369
409
Sep
440
369
257
Oct
416
369
409
Nov
262
369
280
Dec
362
369
286
Current Month
Retherford
White, W.
Croft
Skuza
Yost
Engle
Rupp
Campbell
Robertson
Curr. 12 mo.
Current Budget
Prev. 12 mo.
RT Procedures
Curr. 12 mo.
Current Budget
Prev. 12 mo.
1
0
6
2
1
0
2
0
1
1
5
8
23
1
1
12
64
3,460
3,239
373
372