BUDGET PROJECT ASSIGNMENT

profileMANDY17
CopyofAdditionalCaseStudyTables.xlsx
Home>Nursing homework help>BUDGET PROJECT ASSIGNMENT

Table 1.5

Table 1.5
Hillsboro County Health Insurance Profile 2016–2017 (Special Study by Chamber of Commerce, Percent of Total)
Percent of Coverage Not covered any time during the year Covered by employment-based insurance Covered by own employment-based insurance (self-employed) Covered by Medicaid and private insurance Covered by Medicare and private insurance Covered by Medicare and Medicaid
All Residents 19.3 55.1 28.6 2.8 7.5 2.1
Employer size, workers aged 18–64
Fewer than 25 employees 32.7 50.6 12.4 1.0 0.2 0.2
25–99 employees 25.6 70.5 8.3 1.5 0.1 0
100–499 employees 14.9 76.6 5.6 1.5 0.2 0.3
500–999 employees 13.6 78.8 0.0 0.7 0.2 0.3
1,000+ employees 0.0 0.0 0.0 0.0 0.0 0.0
Household income
Less than $25,000 28.3 7.3 8.2 0.00 8.1 0.00
$25,000 to $49,999 22.8 43.4 23.6 0.00 15.4 0.00
$50,000 to $74,999 13.2 64.1 30.5 0.00 7.5 0.00
$75,000 or more 9.3 79.5 39.4 0.00 5.7 0.00
NOTE: Percentages may exceed 100% depending on changes during the year of study and multiple coverage.

Table 1.9

Table 1.9
HIV and AIDS in Capital City and Hillsboro County, 2007–2017
2017 2012 2007
AIDS cases Rate per 100,000 Population, All Ages
Hillsboro County 6.9 7.2 7.8
Capital City 8.4 9.3 11.2
Statewide 12.5 13.4 14.5
AIDS cases Rate per 100,000 Population, Adults and Adolescents
Hillsboro County 7.0 7.4 8.2
Capital City 8.5 9.6 11.5
Statewide 15.2 16.0 18.3
AIDS case rates Adults and Adolescents, Rates per 100,000 by Sex
Hillsboro County
Male 20.9 23.5 17.2
Female 6.3 7.9 5.4
Capital City
Male 22.9 24.0 21.3
Female 7.7 7.7 7.9
Statewide
Male 22.9 26.3 30.1
Female 7.7 6.7 6.7
AIDS cases Distribution of Persons Estimated to be Living with AIDS (%)
Hillsboro County
White 70.9 71.2 67.3
Black 18.8 19.3 20.3
Hispanic 4.4 4.4 6.2
Other 5.9 5.1 6.2
Capital City
White 48.2 40.3 35.5
Black 35.7 40.7 44.5
Hispanic 13.4 16.7 17.3
Other 2.7 2.3 2.7
Statewide
White 34.1 30.2 28.4
Black 42.7 44 44.3
Hispanic 20.9 23.2 25.2
Other 2.3 2.6 2.1
HIV Age-Adjusted Death Rate per 100,000 for HIV
Hillsboro County 1.1 1.2 1.1
Capital City 3.8 3.2 3.2
Statewide 4.2 4.6 4.8
HIV Estimated Rate per 100,000 for Persons Living with HIV Infections (not AIDS)
Hillsboro County 22.7 21.3 24.3
Capital City 34.5 36.7 39.5
Statewide 51.7 48.3 50.2
HIV—2017 Rates per 100,000 of New HIV Infections in Adults and Adolescents
Males Females Total
Hillsboro County
Whites 10.5 2.2 7.1
Blacks 80.7 21.7 51.9
Hispanics 31.2 6.3 19.2
Capital City
Whites 13.5 4.1 9.1
Blacks 112.4 50.9 82.7
Hispanics 47.5 13.0 30.7
Statewide
Whites 19.6 3.9 11.5
Blacks 115.7 55.7 83.7
Hispanics 43.8 14.4 29.3

Table 2.2

Table 2.2
Service Area Utilization by Town and Division for Calendar Years Ending December 31
Boalsburg Carterville Harris City Jasper Middleboro Mifflenville Minortown Stateville Total
Division Service
Home Care
RN visits 1,702 2,004 3,404 3,220 16,071 3,794 3,020 820 34,035
LPN visits 330 356 676 666 3,264 725 445 200 6,662
HHA visits 422 82 823 863 4,904 967 106 263 8,430
PT visits 150 26 301 605 1,547 335 18 92 3,074
OT visits 56 59 107 101 490 100 71 30 1,014
ST visits 10 13 18 20 91 21 11 5 189
Social worker visits 26 24 47 51 230 53 38 18 487
Private Duty
RN in-home hours 73 54 154 194 798 150 61 50 1,534
LPN in-home hours 794 290 1,241 1,448 7,109 1,571 293 419 13,165
PCA in-home hours 957 1,487 1,835 1,741 9,479 2,155 1,315 376 19,345
HHA in-home hours 844 1,513 1,517 1,291 7,658 2,040 1,729 426 17,018
Other in-home hours 10 43 21 6 64 0 39 8 191
Community Health
Ante/postpartum visits 18 38 56 34 190 101 16 23 476
Child health visits 7 23 11 44 198 131 12 30 456
Senior Health Clinic attendees by HCHHA Office Location
Seen at Middleboro office 15 12 72 0 653 114 12 45 923
Seen at Jasper office 0 0 0 246 0 0 0 8 254

Table 2.3

Table 2.3
Services to Patients, Calendar Years Ending December 31
Division/Program 2017 2016 2015 2014 2013
Home Care
Unduplicated client census 1,596 1,582 1,578 1,498 1,499
RN home visits 34,035 35,463 35,867 36,304 37,192
LPN home visits 6,662 5,678 5,980 4,823 4,725
Home health aide visits 8,430 8,230 8,356 8,856 8,923
PT visits 3,074 2,647 2,630 2,240 2,430
OT visits 1,014 993 897 899 903
ST visits 189 165 174 178 156
SW visits 487 472 434 445 342
Total visits 53,891 53,648 54,338 53,745 54,671
Private Duty
Unduplicated client census 260 225 145
RN in-home hours 1,534 1,267 1,050
LPN in-home hours 13,165 12,564 9,160
Personal care attendant in-home hours 19,345 16,745 14,290
HHA in-home hours 17,018 11,788 8,304
Other in-home hours 212 180 210
Total hours 51,274 42,544 33,014
Community Health
Ante/postpartum visits 476 512 500 499 412
Child health visits 456 502 656 450 496
Prenatal class enrollees 139 140 123 130 112
Children seen, Middleboro 901 740 634 812 845
Children seen, Jasper 301 222 305 317 328
High Blood Pressure Program
People screened 7,456 6,867 7,234 7,124 6,838
MD referrals 398 423 307 456 512
Senior Health Clinics
Clients seen, Middleboro 923 902 920 934 978
Clients seen, Jasper 254 243 289 389 412

Table 2.6

Table 2.6
Statement of Revenue and Expenses for Calendar Year Ending December 31
2017 2016 2015
REVENUE
Home Care Division 6,736,375 6,322,329 5,936,445
Less allowances for bad debt -85,240 -88,340 -72,450
Less contractual allowances -2,049,283 -1,737,912 -1,365,999
Net revenue 4,601,852 4,496,077 4,497,996
Private Duty Division 3,165,221 2,843,959 1,893,345
Less allowances for bad debt -65,340 -45,230 -24,550
Less contractual allowances -18,469 -12,669 -8,738
Net revenue 3,081,412 2,786,060 1,860,057
Community Health Division
Support from state and towns 208,750 240,000 240,000
United Appeal 20,000 20,000 60,000
Other 1,935 1,257 1,458
Net revenue 230,685 261,257 301,458
Total net operational revenue 7,913,949 7,543,394 6,659,511
Expenses
Divisional
Salaries and wages 4,186,227 4,086,160 3,604,595
Fringe benefits 1,255,868 1,022,548 1,021,445
Travel 725,388 701,383 604,387
Supplies 453,778 398,202 258,304
Equipment 152,430 122,494 82,394
Total divisional 6,773,691 6,330,787 5,571,125
Administrative
Salaries and wages 360,233 340,229 335,110
Fringe benefits 102,339 98,334 96,990
Supplies 157,910 158,705 140,680
Equipment 45,929 42,393 34,220
Insurance 56,729 54,202 45,043
Interest 54,894 53,890 53,004
Maintenance—Middleboro 138,595 79,303 78,380
Rent—Jasper office 40,500 40,500 40,500
Computer services 84,253 80,150 73,229
Travel 18,356 18,430 13,450
Heat/light—Middleboro 11,488 10,004 7,545
Legal/audit 55,088 44,411 28,340
Printing and postage 15,540 13,450 12,000
Telecommunications 21,364 19,560 18,334
Staff development 10,060 7,010 7,500
Board expenses 10,150 10,445 6,342
Publications and memberships 10,700 10,500 8,550
Depreciation expense 38,240 39,440 44,350
Total administrative 1,232,368 1,120,956 1,043,567
Total expenses 8,006,059 7,451,743 6,614,692
Gain (or loss) from operations -92,110 91,651 44,819
Other Income 202,445 245,300 295,606
Gain (or loss) 110,335 336,951 340,425

Table 2.7

Table 2.7
Balance Sheet as of December 31
2017 2016 2015
Current assets
Cash 708,339 474,519 378,495
Accounts receivable (net) 1,430,404 1,152,383 904,871
Prepaid insurance 8,650 17,340 14,230
Inventory 19,299 19,345 14,236
Total current assets 2,166,692 1,663,587 1,311,832
Property and equipment
Gross, property & equipment 2,328,440 2,255,606 2,153,284
(Less accumulated depreciation) -603,559 -565,319 -525,879
Net property and equipment 1,724,881 1,690,287 1,627,405
Other assets
Investments (at market) 7,951,190 8,403,134 7,456,012
Total assets 11,842,763 11,757,008 10,395,249
Liabilities and net assets
Current liabilities
Accounts payable 487,220 433,291 415,073
Accrued items 284,570 255,683 306,492
Current portion of long-term debt 68,244 69,262 70,385
Total current liabilities 840,034 758,236 791,950
Noncurrent Liabilities
Loan payable 448,292 472,445 492,558
Total liabilities 1,288,326 1,230,681 1,284,508
Net assets
Donor-restricted fund 6,917,307 6,961,213 5,423,731
Investment fund (at market) 3,024,604 3,062,923 3,521,770
Working capital fund 612,526 502,191 165,240
Total net assets 10,554,437 10,526,327 9,110,741
Liabilities + net assets 11,842,763 11,757,008 10,395,249

Table 3.1

Table 3.1
PCS Utilization Report
Alpha Alpha Beta Beta Alpha Beta Total
Total Visits Private Visits Occupational Health Visits Private Visits Occupational Health Visits Gross Charges ($) Gross Charges ($) Gross Charges ($)
2017
January 909 302 185 192 230 78,450 94,040 172,490
February 1,030 402 170 207 251 87,650 102,272 189,922
March 1,039 449 165 204 221 92,425 93,092 185,517
April 1,100 481 190 187 242 101,925 96,844 198,769
May 988 480 103 167 238 82,660 92,876 175,536
June 1,067 493 150 195 229 94,625 94,168 188,793
July 1,195 460 252 219 264 112,940 107,748 220,688
August 1,276 503 260 217 296 120,075 116,812 236,887
September 1,031 406 165 209 251 87,050 102,552 189,602
October 1,048 403 233 205 207 101,635 89,144 190,779
November 905 329 225 168 183 90,625 76,956 167,581
December 799 325 230 119 125 91,225 53,160 144,385
Total 12,387 5,033 2,328 2,289 2,737 1,141,285 1,119,664 2,260,949
2016
January 894 312 180 202 200 72,228 75,038 147,266
February 990 398 166 214 212 79,732 79,526 159,258
March 1,048 440 173 217 218 86,095 81,413 167,508
April 1,102 486 176 203 237 92,154 84,592 176,746
May 999 476 115 163 245 79,069 81,872 160,941
June 978 478 132 133 235 82,622 75,752 158,374
July 1,031 455 204 117 255 93,925 78,948 172,873
August 1,276 501 251 269 255 108,564 97,036 205,600
September 970 396 160 202 212 78,324 78,098 156,422
October 1,056 447 203 199 207 92,778 76,466 169,244
November 1,005 423 254 178 150 99,867 59,432 159,299
December 1,000 405 240 190 165 94,995 64,685 159,680
Total 12,349 5,217 2,254 2,287 2,591 1,060,353 932,858 1,993,211
2015
January 876 303 170 213 190 66,842 73,912 140,754
February 938 365 169 200 204 73,720 75,800 149,520
March 993 402 190 205 196 81,928 74,420 156,348
April 963 406 156 194 207 75,924 75,806 151,730
May 1,001 426 155 175 245 78,014 82,950 160,964
June 986 453 145 143 245 79,192 78,982 158,174
July 1,027 451 184 127 265 86,374 81,998 168,372
August 1,259 493 271 227 268 107,692 95,148 202,840
September 909 312 203 189 205 74,138 74,686 148,824
October 1,057 449 213 178 217 91,656 76,322 167,978
November 974 425 207 164 178 87,780 64,836 152,616
December 1,012 401 231 193 187 89,604 70,682 160,286
Total 11,995 4,886 2,294 2,208 2,607 992,864 925,542 1,918,406
2013
January 866 313 160 200 193 62,917 60,235 123,152
February 887 375 153 145 214 68,415 58,115 126,530
March 978 397 187 189 205 76,933 61,332 138,265
April 954 376 159 205 214 69,604 64,895 134,499
May 1,035 445 193 165 232 83,245 63,885 147,130
June 1,047 463 193 160 231 85,207 63,125 148,332
July 968 421 195 107 245 80,989 59,866 140,855
August 1,212 504 241 207 260 98,316 74,091 172,407
September 986 323 200 188 275 71,207 74,869 146,076
October 990 409 198 156 227 80,221 61,893 142,114
November 974 400 212 145 217 81,760 58,700 140,460
December 960 394 223 156 187 83,086 54,093 137,179
Total 11,857 4,820 2,314 2,023 2,700 941,900 755,099 1,696,999
A
Amy E. Carlton: Amy E. Carlton: Is this section included in the table?		 B
PP OH PP OH
125 220 140 292 189.7579757976 This is a "work area" - please do
125 220 140 292 184.3902912621 not include in table.
125 220 140 292 178.5534167469
125 220 140 292 180.6990909091
125 220 140 292 177.6680161943
125 220 140 292 176.9381443299
125 220 140 292 184.6761506276
125 220 140 292 185.6481191223
125 220 140 292 183.9010669253
125 220 140 292 182.0410305344
125 220 140 292 185.1723756906
125 220 140 292 180.7071339174
292 182.5259546299
119 195 119 255 164.7270693512
119 195 119 255 160.8666666667
119 195 119 255 159.8358778626
119 195 119 255 160.386569873
119 195 119 255 161.1021021021
119 195 119 255 161.936605317
119 195 119 255 167.6750727449
119 195 119 255 161.1285266458
119 195 119 255 161.2597938144
119 195 119 255 160.2689393939
119 195 119 255 158.5064676617
119 195 119 255 159.68
161.4066726051
114 190 124 250 160.6780821918
114 190 124 250 159.4029850746
114 190 124 250 157.4501510574
114 190 124 250 157.559709242
114 190 124 250 160.8031968032
114 190 124 250 160.4198782961
114 190 124 250 163.9454722493
114 190 124 250 161.1119936458
114 190 124 250 163.7227722772
114 190 124 250 158.9195837275
114 190 124 250 156.6899383984
114 190 124 250 158.3853754941
159.9338057524
109 180 113 195 142.207852194
109 180 113 195 142.6493799324
109 180 113 195 141.3752556237
109 180 113 195 140.9842767296
109 180 113 195 142.154589372
109 180 113 195 141.6733524355
109 180 113 195 145.5113636364
109 180 113 195 142.25
109 180 113 195 148.1501014199
109 180 113 195 143.5494949495
109 180 113 195 144.2094455852
109 180 113 195 142.8947916667
143.1221219533

Table 3.5

Table 3.5
Revenue Generation by Physician, Center, Day of Week, September 1–November 29, 2017
RECORD DATE MD/ARNP DAY CTR REVENUE $ VISITS
1 Sept 1 Holiday 1 1
2 Sept 2 1 2 1 3,156 17
3 Sept 3 3 3 1 3,788 21
4 Sept 4 3 4 1 3,956 23
5 Sept 5 1 5 1 3,059 24
6 Sept 6 11 6 1 3,076 19
7 Sept 8 1 1 1 3,044 22
8 Sept 9 1 2 1 3,657 34
9 Sept 10 3 3 1 4,366 20
10 Sept 11 3 4 1 4,381 25
11 Sept 12 4 5 1 3,547 38
12 Sept 13 11 6 1 3,148 16
13 Sept 15 1 1 1 3,008 23
14 Sept 16 1 2 1 3,005 18
15 Sept 17 3 3 1 3,976 21
16 Sept 18 3 4 1 3,740 19
17 Sept 19 4 5 1 3,547 30
18 Sept 20 11 6 1 3,005 20
19 Sept 22 1 1 1 3,259 32
20 Sept 23 1 2 1 3,051 22
21 Sept 24 3 3 1 3,906 18
22 Sept 25 3 4 1 3,856 22
23 Sept 26 4 5 1 3,944 24
24 Sept 27 11 6 1 3,452 20
25 Sept 29 1 1 1 3,056 20
26 Sept 30 1 2 1 3,067 23
27 Oct 1 3 3 1 3,010 23
28 Oct 2 3 4 1 2,840 18
29 Oct 3 5 5 1 3,049 20
30 Oct 4 11 6 1 1,599 10
31 Oct 6 1 1 1 6,559 42
32 Oct 7 1 2 1 3,769 21
33 Oct 8 3 3 1 3,276 20
34 Oct 9 3 4 1 3,806 20
35 Oct 10 4 5 1 3,051 18
36 Oct 11 11 6 1 3,028 20
37 Oct 13 1 1 1 5,278 33
38 Oct 14 1 2 1 4,650 28
39 Oct 15 3 3 1 3,920 20
40 Oct 16 3 4 1 2,534 14
41 Oct 17 5 5 1 4,020 28
42 Oct 18 11 6 1 3,699 24
43 Oct 20 1 1 1 4,460 36
44 Oct 21 1 2 1 4,739 28
45 Oct 22 3 3 1 4,230 22
46 Oct 23 3 4 1 3,288 19
47 Oct 24 4 5 1 3,805 25
48 Oct 25 11 6 1 3,397 22
49 Oct 27 1 1 1 5,520 39
50 Oct 28 1 2 1 4,367 28
51 Oct 29 3 3 1 3,650 20
52 Oct 30 3 4 1 3,090 18
53 Oct 31 4 5 1 3,001 20
54 Nov 1 11 6 1 1,145 10
55 Nov 3 1 1 1 5,350 35
56 Nov 4 1 2 1 2,768 15
57 Nov 5 3 3 1 3,587 21
58 Nov 6 3 4 1 4,879 26
59 Nov 7 5 5 1 2,757 19
60 Nov 8 11 6 1 1,036 10
61 Nov 10 1 1 1 5,567 31
62 Nov 11 1 2 1 2,586 17
63 Nov 12 3 3 1 5,980 32
64 Nov 13 3 4 1 4,771 24
65 Nov 14 4 5 1 2,061 14
66 Nov 15 13 6 1 2,212 22
67 Nov 17 1 1 1 5,789 35
68 Nov 18 1 2 1 3,879 23
69 Nov 19 3 3 1 5,879 31
70 Nov 20 3 4 1 4,244 24
71 Nov 21 5 5 1 2,959 17
72 Nov 22 11 6 1 2,055 15
73 Nov 24 1 1 1 4,789 30
74 Nov 25 1 2 1 4,444 25
75 Nov 26 3 3 1 5,546 32
76 Nov 27 Holiday 4 1
77 Nov 28 9 5 1 4,007 30
78 Nov 29 11 6 1 2,335 16
79 Sept 1 Holiday 1 2
80 Sept 2 2 2 2 5,157 25
81 Sept 3 6 3 2 4,286 14
82 Sept 4 6 4 2 4,367 16
83 Sept 5 7 5 2 4,156 17
84 Sept 6 13 6 2 1,956 10
85 Sept 8 2 1 2 6,648 30
86 Sept 9 2 2 2 5,978 29
87 Sept 10 6 3 2 4,934 20
88 Sept 11 6 4 2 2,166 12
89 Sept 12 7 5 2 4,305 16
90 Sept 13 13 6 2 1,510 9
91 Sept 15 2 1 2 6,250 28
92 Sept 16 2 2 2 4,850 20
93 Sept 17 6 3 2 3,956 18
94 Sept 18 7 4 2 4,707 20
95 Sept 19 8 5 2 3,958 18
96 Sept 20 13 6 2 1,941 10
97 Sept 22 2 1 2 5,790 28
98 Sept 23 2 2 2 4,415 20
99 Sept 24 6 3 2 3,083 14
100 Sept 25 8 4 2 3,546 16
101 Sept 26 8 5 2 4,026 16
102 Sept 27 12 6 2 1,850 12
103 Sept 29 2 1 2 4,890 24
104 Sept 30 2 2 2 3,827 18
105 Oct 1 5 3 2 4,080 18
106 Oct 2 5 4 2 3,080 15
107 Oct 3 8 5 2 2,044 9
108 Oct 4 13 6 2 830 4
109 Oct 6 2 1 2 4,560 20
110 Oct 7 2 2 2 4,050 20
111 Oct 8 5 3 2 4,069 20
112 Oct 9 5 4 2 3,827 18
113 Oct 10 6 5 2 1,566 11
114 Oct 11 13 6 2 1,209 6
115 Oct 13 2 1 2 4,038 19
116 Oct 14 2 2 2 4,740 20
117 Oct 15 5 3 2 3,567 17
118 Oct 16 5 4 2 5,035 18
119 Oct 17 6 5 2 3,077 15
120 Oct 18 13 6 2 1,518 8
121 Oct 20 2 1 2 5,734 22
122 Oct 21 2 2 2 3,657 19
123 Oct 22 5 3 2 3,256 20
124 Oct 23 5 4 2 3,070 13
125 Oct 24 6 5 2 3,058 12
126 Oct 25 12 6 2 1,656 8
127 Oct 27 2 1 2 5,020 22
128 Oct 28 2 2 2 4,640 20
129 Oct 29 5 3 2 2,748 15
130 Oct 30 5 4 2 2,978 14
131 Oct 31 6 5 2 2,007 9
132 Nov 1 13 6 2 1,205 6
133 Nov 3 2 1 2 3,557 17
134 Nov 4 2 2 2 4,047 15
135 Nov 5 6 3 2 3,344 18
136 Nov 6 6 4 2 4,289 20
137 Nov 7 8 5 2 3,756 14
138 Nov 8 13 6 2 1,034 4
139 Nov 10 2 1 2 4,420 30
140 Nov 11 2 2 2 4,510 16
141 Nov 12 6 3 2 3,089 16
142 Nov 13 6 4 2 3,837 15
143 Nov 14 8 5 2 4,730 17
144 Nov 15 13 6 2 1,856 10
145 Nov 17 2 1 2 4,298 21
146 Nov 18 2 2 2 3,587 12
147 Nov 19 6 3 2 2,689 13
148 Nov 20 6 4 2 4,856 22
149 Nov 21 7 5 2 3,962 14
150 Nov 22 13 6 2 1,091 10
151 Nov 24 2 1 2 5,029 24
152 Nov 25 2 2 2 2,538 12
153 Nov 26 6 3 2 2,177 12
154 Nov 27 Holiday 4 2
155 Nov 28 9 5 2 2,002 8
156 Nov 29 13 6 2 1,053 5
CODES For Table 3-5
MD/ARNP Day Center
1 B. Casey Monday Alpha
2 M. Welby Tuesday Beta
3 S. Tobias Wednesday
4 J. Smooth Thursday
5 R. Hottle Friday
6 L. Cytesmath Saturday
7 C. Withers
8 L. Jones
9 M. Foxx
10 M. Meyers
11 C. Withers, ARNP
12 J. Jones, ARNP
13 G Mattox, ARNP
Revenue = Total gross billed charges
Visits = Number of paying patients

Table 3.6

Table 3.6
Statement of Operations
2017 2016 2015 2014 2013
Revenue
Patient services, gross 2,246,188 1,993,211 1,918,406 1,696,999 1,690,252
Contractual alllowances 179,695 159,457 153,472 135,760 135,220
Patient revenue, net 2,066,493 1,833,754 1,764,934 1,561,239 1,555,032
Other revenue 18,520 22,463 22,252 23,595 23,684
Total revenue 2,085,013 1,856,217 1,787,186 1,584,834 1,578,716
Expenses
Salaries and wages 1,131,608 1,001,556 982,450 839,229 838,226
Staff benefits 392,301 310,482 294,735 243,376 234,703
Administrative expenses 18,330 17,339 10,494 10,056 9,562
Advertising 3,000 3,400 3,856 3,003 2,340
Collection fees 1,267 845 342 659 589
Computer support 21,556 31,443 34,256 35,378 25,398
Consultants 1,529 1,270 948 805 355
Equipment leases 4,100 4,100 4,100 1,800 1,800
Insurance 28,100 24,100 24,100 18,560 24,100
Laboratory 44,870 45,292 42,550 44,691 39,254
Laundry and housekeeping 12,830 12,256 8,156 3,440 2,440
Legal/audit 8,450 8,450 8,450 7,850 7,850
Medical supplies 61,450 58,220 57,354 58,556 28,340
Office supplies 18,437 29,348 28,420 28,556 28,360
Printing and postage 10,122 9,450 9,014 3,588 2,013
Professional fees 23,955 23,425 23,302 23,884 24,885
Rent 78,500 78,750 58,900 58,900 58,900
Repairs and maintenance 3,167 2,966 1,529 2,349 3,620
Telephone 10,315 7,495 6,519 2,550 2,044
Utilities 18,925 16,800 13,560 13,720 13,900
Depreciation 72,556 70,449 70,383 68,363 79,262
Bad debt expenses 8,437 5,629 4,303 3,494 3,102
Total expenses 1,973,805 1,763,065 1,687,721 1,472,807 1,431,043
Income (loss) before taxes 111,208 93,152 99,465 112,027 147,673
Federal and state taxes 44,483 37,261 39,786 44,811 59,069
Income (loss) after taxes 66,725 55,891 59,679 67,216 88,604

Table 3.7

Table 3.7
Balance Sheet for Fiscal Year Ending December 31
CY 2017 2016 2015 2014 2013
Assets
Current
Cash, operating 134,578.00 153,449 163,035 86,999 76,223 84,550
Accounts receivable 48,799.00 139,385 134,450 131,560 130,455 168,455
Inventory 17,390.00 3,339 4,125 5,233 28,734 30,335
Prepaid expenses 12,712.00 3,078 4,565 4,021 5,688 8,944
Total current assets 213,479.00 299,251 306,175 227,813 241,100 292,284
Investments 368,825 341,010 405,903 353,628 314,040
Property and equipment
Equipment and leasehold improvements, gross 1,197,602 1,125,046 1,054,597 984,214 915,851
Less accumulated depreciation 645,239 572,683 502,234 431,851 363,488
Equipment and leasehold improvements, net 552,363 552,363 552,363 552,363 552,363
Total assets 1,220,439 1,199,548 1,186,079 1,147,091 1,158,687
Liabilities and net assets
Current liabilities
Accounts payable ACCOUNTS PAYABLE 49,668 13,534 13,796 10,455 77,454
Accrued expenses ACCRUED EXPENSES 29,000 27,387 30,100 45,662 23,145
Accrued payroll taxes 2,134 945 823 1,126 569
Total current liabilities 80,802 41,866 44,719 57,243 101,168
Long-term liabilities
Notes payable 0 84,770 124,339 132,506 167,393
Total liabilities 80,802 126,636 169,058 189,749 268,561
Net assets
Common stock note1
Authorized and issued 720,000 720,000 720,000 720,000 720,000
Cumulative operating (deficit) or gain after taxes 371,637 352,912 297,021 237,342 170,126
Dividends payable 48,000
Net assets 1,139,637 1,072,912 1,017,021 957,342 890,126
Net assets and liabilities 1,220,439 1,199,548 1,186,079 1,147,091 1,158,687
NOTE: 1. Common stock: $12 par, 60,000 authorized and issued.

Table 4.1

Table 4.1
Webster Hospital Medical Staff Information, 2017
Name Office Age Specialty Patient Days Discharges
Department of Medicine—Active Staff
General and Family Practice
A. Able 1 29 Family Practice* 504 115
A. Adelson 1 33 Family Practice* 601 125
A. Downs 1 34 Family Practice* 678 152
B. Dawes 1 34 Family Practice* 590 146
B. Lamb 1 37 Family Practice* 603 149
C. Franklin 2 48 Family Practice 323 66
C. Newton 2 44 Family Practice 476 96
D. Dodger 3 37 Family Practice* 415 91
E. Best 3 35 Family Practice* 340 84
E. Devishson 3 31 Family Practice* 186 43
E. Doogle 3 36 Family Practice* 357 82
F. Walczek 5 38 Family Practice 300 64
F. Evans 4 39 Family Practice 197 45
G. Liu 6 29 Family Practice 287 50
H. Megg 7 36 Family Practice 454 100
J. Child 4 43 Family Practice 244 55
J. Kim 4 32 Family Practice 456 91
J. Lopez 1 40 Family Practice 478 103
K. Blood 1 50 Family Practice 534 109
K. Justin 2 57 Family Practice 539 114
M. Heart 1 43 Family Practice 478 101
B. Easter 1 68 General Practice 547 102
C. Fisher 2 60 General Practice 416 92
D. Hamilton 2 55 General Practice 345 77
I. Kelly 8 69 General Practice 38 7
I. Lasker 8 68 General Practice 135 24
Internal Medicine: General
J. Morgan 1 35 Internal Medicine 590 121
K. Organs 1 54 Internal Medicine 398 86
Pediatrics
D. White 1 34 Pediatrics* 162 45
H. Wall 1 37 Pediatrics* 45 18
N. Green 1 35 Pediatrics* 80 28
X. Hirsh 1 39 Pediatrics* 40 15
Cardiology
W. Snipes 3 45 Cardiology 546 105
Other: Medicine
A. Zook 1 57 Endocrinology 129 24
J. Hogan 1 50 ENT 365 70
P. Taff 1 43 ENT 356 66
Department of Medicine—Consulting Staff
J. Washington 3 43 Internal Medicine 65 10
C. Eisenhower 9 50 Cardiology 243 41
S. Truman 9 43 Rheumatology 334 62
L. Coolidge 3 44 ENT 143 31
W. G. Chan 3 37 Pediatrics 132 25
W. Tafy 9 57 Oncology 356 50
V. Kennedy 3 64 ENT 140 26
T. Johnson 9 47 Cardiology 176 32
C. Nixon 9 54 Internal Medicine 160 24
M. Polk 3 40 OB/GYN 112 20
S. Warren 9 50 Pulmonary Medicine 655 113
T. Werner 9 53 Pulmonary Medicine 503 90
Others 9 168 32
Department of Surgery
General and Orthopedic
S. Saw 1 31 General* 759 155
C. Blade 1 50 General* 671 142
R. Runner 1 37 Orthopedic 766 155
D. Dolittle 1 46 Orthopedic 792 164
Other
D. Felix 1 47 Urology 403 77
OB/GYN
B. Shaw 1 40 OB/GYN* 415 90
D. Kirby 1 43 OB/GYN 403 92
E. Munson 1 44 OB/GYN* 403 95
F. Zebra 1 41 OB/GYN* 602 129
G. Martinez 1 47 OB/GYN* 621 143
M. Lewis 1 49 OB/GYN* 678 137
Surgery—Consulting Staff
M. Merrill 9 47 General 48 8
W. Pierce 9 51 General 153 27
F. Stevensen 3 61 General 100 19
J. Tyler 3 63 General 140 26
P. Miller 3 68 General 45 7
J. McKinley 3 65 General 32 5
M. Dawes 10 56 General 116 20
S. Strimpf 10 54 General 124 22
S. Skier 9 54 Orthopedic 216 41
W. Hockey 9 47 Orthopedic 106 20
S. Fremont 9 45 Orthopedic 95 18
M. Fremont 9 45 Orthopedic 96 16
D. Davids 9 50 Orthopedic 54 10
K. Nioxon 9 63 Orthopedic 20 3
G. Grant 9 50 Orthopedic 22 4
L. Goldwater 3 44 Orthopedic 20 3
W. Miller 3 47 Orthopedic 27 5
D. Garfield 9 43 Thoraracic 59 9
K. McGovern 9 53 Thoraracic 105 16
D. Chest 9 50 Thoraracic 145 20
Department of Pathology and Radiology—Active Staff
J. Ericksen 1 48 Radiology
H. Holland 1 62 Radiology
W. Jippel 1 46 Radiology
D. Yip 1 43 Pathology
M. Stern 1 44 Pathology
M. Lincoln 1 34 Pathology
Department of Pathology and Radiology—Consulting Staff
M. Currie 9 58 Radiology
D. Douglas 9 43 Radiology
W. Lewis 9 40 Radiology
D. Slide 9 55 Pathology
F. Fillerautz 9 44 Pathology
G. Gathews 9 47 Pathology
Department of Anesthesiology—Active Staff
N. Needle 1 38 Anesthesiology
S. Westerman 1 42 Anesthesiology
N. Chamerblin 1 44 Anesthesiology
S. Pak 1 54 Anesthesiology
D. Sleep 9 61 Anesthesiology
M. Halo 9 50 Anesthesiology
J. Jones 9 46 Anesthesiology
D. Dinckens 9 41 Anesthesiology
Department of Emergency Medicine—Active Staff
E. Abelson 1 44 Emergency
M. Gasp 1 51 Emergency
I. Hurt 1 42 Emergency
A. Lincoln 1 34 Emergency
H. Calson 1 40 Emergency
W. Hiller 1 47 Emergency
S. Sams 1 45 Emergency
G. Bodansky 1 50 Emergency
Department of Emergency Medicine—Consulting Staff
J. Whitey 9 47 Emergency
J. Sallowash 9 51 Emergency
R. Ritco 9 41 Emergency
TBD 9 Emergency
NOTES
* = Medical practice owned by Webster Health System, Inc.
Office Location: 1 = Middleboro; 2 = Mifflenville; 3 = Jasper; 4 = Harris City; 5 = Statesville; 6 = Carterville; 7 = Boalsburg; 8 = Minortown; 9 = Capital City; 10 = Other.

Table 4.2

Table 4.2
Hospital Inpatient Occupancy by Service, 2017–2011
Hospital Service 2017 2016 2015 2014 2013 2012 2011
Pediatrics
Beds 2 2 3 4 4 4 6
Patient days 450 645 706 804 903 998 1,212
Occupancy 61.6% 88.4% 64.5% 55.1% 61.8% 68.4% 55.3%
Maternity
Beds 20 20 14 14 14 11 10
Patient days 5,470 4,956 4,106 3,845 3,455 2,840 2,740
Occupancy 74.9% 67.9% 80.4% 75.2% 67.6% 70.7% 75.1%
Medical Surgical I
Beds 20 20 22 20 20 18 20
Patient days 5,270 6,047 6,070 5,578 6,129 4,996 5,582
Occupancy 72.2% 82.8% 75.6% 76.4% 84.0% 76.0% 76.5%
Medical Surgical II
Beds 20 20 23 21 21 24 21
Patient days 5,442 5,163 5,890 5,830 5,770 6,556 5,979
Occupancy 74.5% 70.7% 70.2% 76.1% 75.3% 74.8% 78.0%
Medical Surgical III
Beds 20 20 20 20 20 21 20
Patient days 5,067 6,089 5,378 5,503 5,586 5,767 5,830
Occupancy 69.4% 83.4% 73.7% 75.4% 76.5% 75.2% 79.9%
Orthopedic
Beds 0 0 4 7 8 12 13
Patient days 0 0 955 1845 2140 3324 3824
Occupancy 0.0% 0.0% 65.4% 72.2% 73.3% 75.9% 80.6%
ICU
Beds 13 13 12 12 11 10 10
Patient days 2,956 2,802 2,655 2,282 1,981 1,810 1,567
Occupancy 62.3% 59.1% 60.6% 52.1% 49.3% 49.6% 42.9%
Total Hospital
Beds 95 95 98 98 98 100 100
Patient days 24,655 25,702 25,760 25,687 25,964 26,291 26,734
Occupancy 71.1% 74.1% 72.0% 71.8% 72.6% 72.0% 73.2%

Table 4.3

Table 4.3
Detailed Utilization Statistics, 2017 and 2016
2017 Discharges Patient Days Inpatient Surgery Outpatient Surgery Births ED Visits ED Admits OPV
January 412 2,133 103 407 124 1,798 215 6,962
February 387 1,894 104 367 105 1,676 200 6,072
March 507 2,060 112 427 124 1,803 234 7,245
April 499 1,978 107 419 136 1,830 220 7,520
May 409 2,178 105 434 121 1,795 218 7,029
June 389 2,056 101 495 123 1,798 212 6,998
July 353 2,157 102 412 115 1,823 219 7,126
August 375 1,867 90 390 127 1,880 230 6,349
September 435 2,245 114 408 139 1,748 200 7,836
October 423 1,956 116 417 136 1,850 213 7,354
November 494 2,059 103 426 134 1,880 223 6,926
December 412 2,072 99 403 126 1,675 200 6,559
Total 5,095 24,655 1,256 5,005 1,510 21,556 2,584 83,976
2016
January 312 2,056 117 405 121 1,662 200 6,956
February 433 1,928 104 401 108 1,640 196 5,728
March 446 2,186 116 417 110 1,658 199 6,689
April 400 2,001 137 423 124 1,640 190 7,387
May 445 1,978 132 422 108 1,720 201 7,704
June 412 1,905 113 395 118 1,710 200 7,005
July 408 2,156 105 366 114 1,720 206 6,129
August 407 2,169 95 382 113 1,820 212 5,946
September 405 2,190 134 410 118 1,748 209 7,558
October 434 2,101 120 412 137 1,743 214 7,054
November 490 2,067 116 418 122 1,734 204 7,067
December 541 2,265 109 419 106 1,656 188 6,126
Total 5,133 25,002 1,398 4,870 1,399 20,451 2,419 81,349
NOTES: ED Visits = Total emergency department visits ED Admits = ED visits that led to an inpatient admission OPV = Outpatient visits, excludes ED visits
*

Table 4.4

WEBSTER HOSPITAL
TABLE 4-4 REVISED 5/18/18
STATEMENT OF REVENUE AND EXPENSE ($)
FOR CALENDAR YEARS ENDING DECEMBER 31
2017 2016 2015
REVENUE
PATIENT SERVICES REVENUE- TOTAL 290,117,301 288,362,045 287,223,124
Inpatient 105,718,744 109,577,577 116,919,656
Outpatient 184,398,557 178,784,468 170,303,468
Allowances and Uncollectables - Inpatient 50,744,997 53,667,342 55,341,870
Allowances and Uncollectables - Outpatient 103,017,173 102,048,162 99,758,617
Total 153,762,170 155,715,504 155,100,487
NET SERVICE REVENUE 136,355,131 132,646,541 132,122,637
Other Operating Revenue 108,330 88,453 72,290
TOTAL OPERATING REVENUE 136,463,461 132,734,994 132,194,927
EXPENSE
OPERATING EXPENSES
Patient Care Services 43,245,232 40,384,554 38,345,292
Other Professional Services 30,898,223 30,556,393 30,573,990
General Services 24,836,292 22,405,239 23,450,202
Fiscal and Admin Services 24,638,272 24,003,292 24,595,281
Interest 1,865,693 1,813,907 1,936,889
Depreciation 5,320,108 5,891,202 5,412,404
Community Education and Outreach 251,799 299,874 225,665
TOTAL OPERATING EXPENSES 131,055,619 125,354,461 124,539,723
NET INCOME FROM OPERATIONS 5,407,842 7,380,533 7,655,204
NONOPERATING REVENUE
Unrestricted Gifts and Bequests 198,233 147,841 596,053
Income from Investments 3,059,282 2,517,304 3,045,222
Miscellaneous Non-Patient Revenue 1,118,332 500,300 720,754
TOTAL 4,375,847 3,165,175 4,362,029
NONOPERATING EXPENSES 2,554,293 2,007,343 1,245,422
Net Non-Operating Income 1,821,554 1,157,832 3,116,607
PROFIT or (LOSS) 7,229,396 8,538,365 10,771,811
10,771,811

Table 4.5

WEBSTER HOSPITAL
TABLE 4-5 Revised 5/18/18
BALANCE SHEET ($) AS OF DECEMBER 31
2017 2016 2015
CURRENT ASSETS
Cash 3,005,494 2,324,303 2,439,495
Short Term Investments 3,035,445 2,224,383 893,247
Accounts Receivables - Gross 33,458,282 34,292,554 36,595,230
Allowances for Uncollectables 18,563,987 19,393,554 19,937,554
Accounts Receivables - Net 14,894,295 14,899,000 16,657,676
Due from Third Party Payers 607,255 443,420 103,450
Inventories 4,866,345 4,995,395 5,394,129
Prepaid Expenses 153,702 176,872 162,508
TOTAL CURRENT ASSETS 26,562,536 25,063,373 25,650,505
NON-CURRENT ASSETS
Property, Plant and Equipment - Gross 107,353,474 104,393,556 100,384,345
Less Accumulated Depreciation 67,334,262 62,014,154 56,122,952
Property, Plant and Equipment - Net 40,019,212 42,379,402 44,261,393
Other Investments 14,997,675 14,349,292 8,530,204
TOTAL ASSETS 81,579,423 81,792,067 78,442,102
CURRENT LIABILITIES
Accounts Payable 5,334,675 5,539,564 5,420,787
Accrued Salaries and Wages 767,056 828,349 792,414
Accrued Interest 107,342 72,204 70,245
Other Accrued Expenses 279,474 261,584 270,654
Due to Third Party Vendors 705,613 702,461 582,491
Long Term Debt Due Within One Year 2,158,337 1,345,965 945,229
TOTAL CURRENT LIABILITIES 9,352,497 8,750,127 8,081,820
Long Term Debt 20,456,294 28,500,704 34,357,411
TOTAL LIABILITIES 29,808,791 37,250,831 42,439,231
NET ASSETS
Restricted 6,128,484 6,034,292 6,203,445
Unrestricted 45,642,148 38,506,944 29,799,426
TOTAL NET ASSETS 51,770,632 44,541,236 36,002,871

Table 5.1

Table 5.1
Medical Staff Information as of December 2017
Name Notes Office Age Specialty 2017 Patient Days
Family Practice: Active Staff
F. Player 5 70 General Practice 235
G. Banero 8 55 General Practice 319
J. Apple 6 59 General Practice 174
S. Fistru 7 58 General Practice 260
S. Mix 2 64 General Practice 130
Family Practice: Consulting Staff
C. Berrnally 3 38 General Practice* 101
D. Mathews 3 45 General Practice* 48
H. Cavenero 3 55 General Practice* 57
H. Wang 3 40 General Practice 79
J. Yates 3 44 General Practice 51
N. Chamerberlin 3 47 General Practice 118
S. Mathews 3 42 General Practice 18
Internal Medicine
A. Barton MA 1 45 Internal Medicine 812
B. Crush 3 63 Internal Medicine 380
C. Douglas MA 1 41 Internal Medicine 800
D. Justin 1 67 Internal Medicine 310
D. Meow 1 60 Internal Medicine 280
D. Michael 4 45 Internal Medicine* 250
E. Frost MA 3 41 Internal Medicine 490
F. Grist 3 50 Internal Medicine 140
G. Filly 1 58 Internal Medicine 240
G. Hurt 8 55 Internal Medicine* 172
H. Hippster 1 56 Internal Medicine 250
J. Justin 4 59 Internal Medicine* 84
J. Vogel 5 55 Internal Medicine 103
K. Kessler MA 1 34 Internal Medicine 658
L. Lesko MA 1 38 Internal Medicine 560
L. Nask 5 56 Internal Medicine 203
M. Horse 1 68 Internal Medicine* 544
M. Mast 2 41 Internal Medicine 877
M. Master MA 1 40 Internal Medicine 472
N. Nostrom 2 57 Internal Medicine 112
O. Ogg 2 39 Internal Medicine 572
P. Xiao 2 50 Internal Medicine 126
P. Trip 6 52 Internal Medicine 263
Q. Quinn 6 63 Internal Medicine 156
S. Jessey 7 60 Internal Medicine 177
S. Knach 8 67 Internal Medicine* 63
S. Steel 3 50 Internal Medicine 416
S. Stocapy 3 57 Internal Medicine 150
T. Beata 3 60 Internal Medicine 80
T. Cushing 3 62 Internal Medicine 87
T. Davis 3 58 Internal Medicine 203
T. Figher 3 54 Internal Medicine 306
T. King 3 63 Internal Medicine 64
Pediatrics
A. Sloan 1 54 Pediatrics* 56
B. Bickford 1 50 Pediatrics 92
G. Gavin 1 44 Pediatrics 44
M Miller MA 3 40 Pediatrics 103
M. Bill 3 59 Pediatrics 52
N. Otter MA 3 37 Pediatrics 105
O. Pushy 1 50 Pediatrics 120
P. Kettel 3 57 Pediatrics 70
P. Quester MA 3 40 Pediatrics 280
Q. Reaper MA 1 59 Pediatrics 81
R. Samuels MA 1 47 Pediatrics 114
S. St. James MA 1 40 Pediatrics 120
T. Turtle 1 58 Pediatrics* 240
U. Unvey MA 3 56 Pediatrics 234
V. Vesh 1 52 Pediatrics* 92
W. Warren 1 56 Pediatrics* 84
W. Washed 3 64 Pediatrics 48
Allergy and Immunology
S. Sleek 1 49 Allergy/Immunology 448
T. Gustave 1 53 Allergy/Immunology 207
T. Hampshire 3 58 Allergy/Immunology 204
Cardiology
D. Eastman 1 56 Cardiology* 384
G. Hurst 1 60 Cardiology* 234
J. Dufresne 3 60 Cardiology 180
T. Underwood MA 1 46 Cardiology 652
U. Victem 1 41 Cardiology* 471
Gastroenterology
T. Amas 1 60 Gastroenterology 120
T. Eisher 1 55 Gastroenterology 128
T. Tiger 2 59 Gastroenterology 58
T. Wingate 2 64 Gastroenterology 86
Y. Zaller 1 49 Gastroenterology 1,270
Z. Autumn MA 1 44 Gastroenterology 748
Psychiatry
A. Actor 1 42 Psychiatry 480
B. Banana 1 50 Psychiatry 432
F. Jilley 1 39 Psychiatry 360
I. Stanzl 2 61 Psychiatry 86
S. Zeus 2 40 Psychiatry 272
Other: Medicine
C. Tunsteb 1 60 ENT 80
M. White 1 63 ENT 68
M. Whittier 1 44 ENT 353
V. Weckenson MA 1 44 ENT 470
W. Xerox MA 1 42 ENT 497
X. Yalper 1 57 ENT 170
B. Divan 1 44 Oncology/Hemo 440
M. Schoen 1 39 Oncology/Hemo* 401
S. Hatcher 1 53 Oncology/Hemo* 459
T. Kwok 1 32 Oncology/Hemo 150
C. Carp 3 54 ENT 300
F. Fish 3 49 ENT 280
Surgery: Orthopedic
D. Jones 1 57 Orthopedic 1,376
G. Hooper 1 50 Orthopedic 1,253
K. Amberson 1 55 Orthopedic 1,540
K. Matthews 1 45 Orthopedic 1,721
K. Questrom MA 1 39 Orthopedic 1,401
L. Rex 1 57 Orthopedic 1,703
M. Dillon 1 64 Orthopedic 1,420
M. Stanley MA 1 49 Orthopedic 1,507
Surgery: General
B. Hersh MA 1 40 General 1,200
C. Isherum 1 57 General* 1,245
D. Jackson MA 1 39 General 734
F. Limpey 1 58 General* 1,300
G. Munson 1 50 General* 586
H. Never MA 1 45 General 870
I. O'Connell MA 1 49 General 416
J. Putter MA 1 62 General 601
J. Timas 1 59 General* 1,246
J. Victor 1 57 General* 980
Surgery: OB/GYN
D. Dustin MA 1 33 OB/GYN 650
E. Eberle 1 51 OB/GYN 290
F. Fraser 1 65 OB/GYN* 480
G. Gost MA 1 45 OB/GYN 720
J. Kim 1 57 OB/GYN 336
I. Japen 1 56 OB/GYN* 236
K. Lights 1 55 OB/GYN 186
M. Nester 1 59 OB/GYN* 280
Surgery: Other
B. Bernal 1 45 Neuro 329
C. Eason MA 1 56 Urology 450
D. Crow 1 50 Neuro 334
D. Fixer MA 1 43 Urology 578
F. Seimer 1 59 Neuro 444
G. Tho 1 42 Plastic 332
H. Yee 1 58 Plastic 101
J. Underside 1 55 Thoracic 921
J. Warren 1 60 Thoracic 844
J. Yellow 1 60 General 640
J. Zetias 1 66 General 225
L. Clock 1 47 Thoracic 340
L. David 1 51 Vascular 310
L. Fession 1 44 Bariatric 380
L. Frederick 1 47 Vascular 340
M. Blue 1 46 Eye 300
M. Mold 1 45 Urology 650
N. Nerve 1 51 Urology 850
Department of Medicine: Consulting Staff
W. Pokorny 9 51 Psychiatry 14
B. Rubble 3 54 Oncology 32
F. Feada 9 63 Hematology 32
F. Flint 9 56 Oncology 54
H. Ruth 9 42 Gastroenterologyenterology 65
J. Klock MA 3 49 OB/GYN 130
K. Kipstein MA 3 50 Cardiology 201
L. Gomez 9 44 Allergy 26
L. Mustard MA 3 39 OB/GYN 223
M. McVoy 9 37 Psychiatry 32
O. Maeer MA 3 42 Cardiology 133
P. Carles 9 60 Pulmonary Medicine 28
S. Ange 9 48 Endocrinology 84
S. Lott 9 50 Hematology 112
S. Malone 9 55 Allergy 31
S. Parish 9 48 Dermatology 16
V. Vitter 9 57 Hematology 102
Department of Surgery: Consulting Staff
A. Hamp 9 48 General 45
A. Steve MA 3 47 Thoracic 80
C. Finn MA 3 49 Thoracic 39
F. Mike 9 60 Ortho 28
J. Wingate 9 50 Pediatric 30
L. Picture MA 3 47 Orthopedic 76
L. Richard 9 45 Orthopedic 19
N. New 9 58 Orthopedic 24
S. Lee MA 3 40 Orthopedic 56
Department of Pathology: Active Staff
A. Mixture 1 61 Pathology
B. Nerverto 1 56 Pathology
C. Leatros 1 47 Pathology
D. Mushroom 1 42 Pathology
D. Pathos 1 56 Pathology
E. Fisher 1 54 Pathology
F. Mautz 1 64 Pathology
G. Wingate 1 63 Pathology
Department of Radiology: Active Staff
A. Picture 1 56 Radiology
B. Quadic 1 45 Radiology
C. Roetgen 1 61 Radiology
D. Sunshine 1 40 Radiology
M. Ray 1 45 Radiology
K. Hines 1 50 Radiology
W. Hines 1 39 Radiology
L. Jinks 1 45 Radiology
P. Patel 1 52 Radiology
R. Ricker 1 34 Radiology
R. El-Amin 1 44 Radiology
R. Trippe 1 49 Radiology
E. Tracer 1 49 Radiology
Department of Anesthesiology: Active Staff
A. Aaron 1 38 Anesthesiology
B. Carter 1 62 Anesthesiology
B. Dexter 1 66 Anesthesiology
B. Harrington 1 63 Anesthesiology
B. Nelson 1 60 Anesthesiology
B. Thomas 1 64 Anesthesiology
C. Fisher 1 54 Anesthesiology
D. Gass 1 48 Anesthesiology
E. Lister 1 61 Anesthesiology
F. Mask 1 59 Anesthesiology
Department of Emergency Medicine: Active Staff
R. Romanikova 1 29 Emergency
S. Hines 1 60 Emergency
B. Casey 1 44 Emergency
J. Smooth 1 54 Emergency
G. Goodspeed 1 70 Emergency
L. Jinks 1 45 Emergency
M. Gotlike 1 52 Emergency
J. Ishabi 1 43 Emergency
L. Cytesmith 1 60 Emergency
M. Welby 1 56 Emergency
R. Hotlick 1 58 Emergency
S. Tobias 1 51 Emergency
Department of Hospital Medicine
A. Palmer 1 32 Hospitalist
B. Carlos 1 40 Hospitalist
C. Frost 1 39 Hospitalist
F. Drudge 1 35 Hospitalist
M. Gupta 1 40 Hospitalist
M. Shine 1 43 Hospitalist
S. Ruderbacker 1 56 Hospitalist
V. Martinez 1 44 Hospitalist
W. Lewis 1 50 Hospitalist
NOTES:
MA = Medical Associates Office Location: 1 = Middleboro; 2 = Mifflenville: 3 = Jasper 4 = Harris City; 5 = Statesville: 6 = Carterville; 7 = Boalsburg 8 = Minortown; 9 = Capital City; 10 = Other * = Medical practice owned by Medical Practice Subsidiary (MPS) Inc.

Table 5.2

Table 5.2
Hospital Inpatient Occupancy by Service, 2011–2017
Hospital Service 2017 2016 2015 2014 2013 2012 2011
Pediatrics
Beds 12 14 16 18 18 18 18
Patient days 2,249 2,245 2,224 2,270 2,546 3,260 3,150
Occupancy 51.3% 43.9% 38.1% 34.6% 38.8% 49.6% 47.9%
Maternity
Beds 26 28 28 29 29 29 29
Patient days 4,372 4,423 4,134 5,045 6,023 6,007 6,045
Occupancy 46.1% 43.3% 40.5% 47.7% 56.9% 56.8% 57.1%
Medical Surgical I
Beds 50 50 50 50 50 50 50
Patient days 13,756 13,505 13,333 13,340 12,103 12,400 12,547
Occupancy 75.4% 74.0% 73.1% 73.1% 66.3% 67.9% 68.8%
Medical Surgical II
Beds 50 50 50 50 50 50 50
Patient days 13,845 13,604 13,503 12,056 12,440 10,378 10,501
Occupancy 75.9% 74.5% 74.0% 66.1% 68.2% 56.9% 57.5%
Medical Surgical III
Beds 44 50 53 55 55 53 53
Patient days 10,054 10,450 11,004 11,856 11,420 11,890 11,945
Occupancy 62.6% 57.3% 56.9% 59.1% 56.9% 61.5% 61.7%
Medical Surgical IV
Beds 40 40 45 50 50 50 50
Patient days 9,850 9,893 9,833 10,956 11,584 12,282 12,470
Occupancy 67.5% 67.8% 59.9% 60.0% 63.5% 67.3% 68.3%
ICU/CCU
Beds 18 18 18 18 18 20 20
Patient days 4,644 4,847 4,856 4,934 4,926 5,102 5,008
Occupancy 70.7% 73.8% 73.9% 75.1% 75.0% 69.9% 68.6%
Total Hospital
Beds 240 250 260 270 270 270 270
Patient days 58,770 58,967 58,887 60,457 61,042 61,319 61,666
Occupancy 67.1% 65.5% 62.9% 62.2% 62.8% 63.1% 63.4%

Table 5.3

Table 5.3
Detailed Utilization Statistics for 2017 and 2016
2017 Discharges Patient Days Inpatient Surgery Outpatient Surgery Births ER Visits ER Admits OPV
January 890 4,959 201 362 98 2,134 272 9,558
February 823 4,655 209 350 84 1,883 238 8,973
March 934 5,098 190 372 101 2,090 268 9,495
April 956 5,124 193 348 112 2,063 254 9,088
May 923 5,170 197 394 109 2,110 283 9,265
June 1,025 5,768 185 345 108 2,203 260 8,857
July 897 4,535 170 325 99 2,083 253 9,436
August 862 4,425 165 303 101 2,068 250 9,356
September 898 4,978 187 365 109 2,205 275 9,030
October 893 4,990 198 323 114 2,003 245 9,234
November 863 4,923 193 395 104 2,209 249 9,345
December 766 4,145 170 302 109 2,027 240 8,245
Total 10,730 58,770 2,258 4,184 1,248 25,078 3,087 109,882
2016
January 882 4,703 191 390 109 2,167 270 8,951
February 837 4,780 190 331 110 2,107 265 8,094
March 893 5,149 207 387 113 2,278 289 9,092
April 967 5,547 215 367 109 2,678 365 9,234
May 980 5,320 199 346 110 2,398 310 9,245
June 1,005 5,756 204 361 111 2,351 270 9,345
July 823 3,701 187 302 103 2,278 280 9,832
August 812 4,301 160 296 102 2,056 263 9,257
September 934 5,734 188 379 116 2,556 289 9,934
October 954 5,134 193 384 111 2,044 240 10,109
November 848 4,775 196 382 103 2,196 279 9,887
December 703 4,067 178 312 113 2,286 288 8,750
Total 10,638 58,967 2,308 4,237 1,310 27,395 3,408 111,730
NOTES:
ED Visits = Total emergency department visits ED Admits = ED visits that lead to an inpatient admission OPV = Outpatient Visits, excludes ED visits
*

Table 5.4

TABLE 5-4 Revised 5/18/18
MIDDLEBORO COMMUNITY HOSPITAL
STATEMENT OF REVENUE AND EXPENSE ($)
FOR CALENDAR YEARS ENDING DECEMBER 31
2017 2016 2015
REVENUE
PATIENT SERVICES REVENUE- TOTAL 658,351,925 650,578,354 650,829,412
Inpatient 312,565,340 315,343,506 322,465,856
Outpatient 345,786,585 335,234,848 328,363,556
Allowances and Uncollectables - Inpatient 200,564,989 190,282,353 185,374,561
Allowances and Uncollectables - Outpatient 203,464,546 200,343,595 196,294,375
Total 404,029,535 390,625,948 381,668,936
NET SERVICE REVENUE 254,322,390 259,952,406 269,160,476
Other Operating Revenue 154,229 288,354 372,343
TOTAL OPERATING REVENUE 254,476,619 260,240,760 269,532,819
EXPENSE
OPERATING EXPENSES
Patient Care Services 80,373,449 78,354,002 77,343,526
Other Professional Services 69,363,454 68,394,262 68,001,200
General Services 40,383,464 42,393,446 44,627,308
Fiscal and Admin Services 40,228,343 45,383,557 50,526,303
Interest 3,956,433 3,825,354 3,800,240
Depreciation 14,378,565 15,340,272 16,340,229
Community Education and Outreach 542,383 599,454 535,495
TOTAL OPERATING EXPENSES 249,226,091 254,290,347 261,174,301
NET INCOME FROM OPERATIONS 5,250,528 5,950,413 8,358,518
NONOPERATING REVENUE
Unrestricted Gifts and Bequests 76,342 48,331 26,051
Income from Investments 1,978,564 2,018,334 2,933,162
Miscellaneous Non-Patient Revenue 118,453 49,510 157,394
TOTAL 2,173,359 2,116,175 3,116,607
NONOPERATING EXPENSES 1,553,675 1,444,303 1,324,556
Net Non-Operating Income 619,684 671,872 1,792,051
PROFIT or (LOSS) 5,870,212 6,622,285 11,475,125

Table 5.5

TABLE 5-5 REVISED 5/18/18
MIDDLEBORO COMMUNITY HOSPITAL
BALANCE SHEET ($)
AS OF DECEMBER 31,
2017 2016 2015
CURRENT ASSETS
Cash 16,008,364 16,343,949 10,438,282
Short Term Investments 6,546,791 3,283,445 3,029,393
Accounts Receivables - Gross 72,564,867 71,540,304 70,283,443
Allowances for Uncollectables 28,453,998 29,474,665 29,117,273
Accounts Receivables - Net 44,110,869 42,065,639 41,166,170
Due from Third Party Payers 378,559 349,228 103,450
Inventories 2,663,265 2,995,394 2,235,119
Prepaid Expenses 89,020 72,343 69,372
TOTAL CURRENT ASSETS 69,796,868 65,109,998 57,041,786
NON-CURRENT ASSETS
Property, Plant and Equipment - Gross 354,783,292 354,282,404 360,283,443
Less Accumulated Depreciation 176,453,887 171,133,779 165,242,577
Property, Plant and Equipment - Net 178,329,405 183,148,625 195,040,866
Other Investments 39,997,354 39,105,569 34,674,187
TOTAL ASSETS 288,123,627 287,364,192 286,756,839
CURRENT LIABILITIES
Accounts Payable 16,342,575 15,369,594 16,002,347
Accrued Salaries and Wages 10,453,274 8,259,669 7,345,002
Accrued Interest 134,569 156,304 700,585
Other Accrued Expenses 1,393,253 1,657,330 1,435,020
Due to Third Party Vendors 1,205,494 1,723,657 582,491
Long Term Debt Due Within One Year 5,142,939 4,920,338 4,823,293
TOTAL CURRENT LIABILITIES 34,672,104 32,086,892 30,888,738
Long Term Debt 67,540,223 75,330,404 82,374,337
TOTAL LIABILITIES 102,212,327 107,417,296 113,263,075
NET ASSETS
Restricted 6,128,484 6,034,292 6,203,445
Unrestricted 179,782,816 174,006,796 167,215,358
TOTAL NET ASSETS 185,911,300 180,041,088 173,418,803
NET ASSETS +LIABILITIES 288,123,627 287,458,384 286,681,878

Table 6.1

Table 6.1
Physicians Affiliated with Medical Associates as of December 31, 2017
Name Specialty Age Office Active Consulting
Autumn Gastroenterology 44 Middleboro MCH CCG
Barton Internal medicine 45 Middleboro MCH CCG
Coolidge ENT 44 Jasper CGS OMC, WH
Douglas Internal medicine 41 Middleboro MCH CCG
Dustin OB/GYN 33 Middleboro MCH CCG
Eason Urology 56 Middleboro MCH CCG
Finn Surgery 47 Jasper CCG MCH
Fixer Urology 43 Middleboro MCH CCG
Frost Internal medicine 41 Jasper MCH CGS
Goldwater Orthopedic surgery 44 Jasper CGS WH, OMC
Gost OB/GYN 45 Middleboro MCH CCG
Hersh General surgery 40 Middleboro MCH CCG
Jackson General surgery 39 Middleboro MCH CCG
Kessler Internal medicine 34 Middleboro MCH CCG
Kipstein Cardiology 50 Jasper CGS MCH
Klock OB/GYN 49 Jasper CGS MCH
Lee Orthopedic surgery 40 Jasper CGS MCH
Lesko Internal medicine 38 Middleboro MCH CCG
Maeer Cardiology 42 Jasper CGS MGH
Master Internal medicine 40 Middleboro MCH CCG
Chan Pediatrics 37 Jasper CGS MCH
Mustard OB/GYN 39 Jasper CGS MCH
Never General surgery 45 Middleboro MCH CCG
O'Connell General surgery 49 Middleboro MCH CCG
Otter Pediatrics 37 Jasper CGS MCH
Picture Orthopedic surgery 47 Jasper CGS MCH
Polk OB/GYN 40 Jasper OMC WH
Putter General surgery 62 Middleboro MCH CCG
Qestrom Orthopedic surgery 39 Middleboro MCH CCG
Quester Pediatrics 40 Jasper MCH CGS
Reeper Pediatrics 59 Middleboro MCH CCG
Samuels Pediatrics 47 Middleboro MCH CCG
St. James Pediatrics 40 Middleboro MCH CCG
Stanley Orthopedic surgery 49 Middleboro MCH CCG
Steve Orthopedic surgery 47 Jasper CGS MCH
Underwood Cardiology 46 Middleboro MCH CCG
Unvey Pediatrics 56 Jasper MCH CGS
Washington Internal medicine 43 Jasper CCG WH
Weckensen ENT 44 Middleboro MCH CCG
Xerox ENT 42 Middleboro MCH CCG
NOTES:
Active = Active medical staff privileges by hospital
Consulting = Consulting medical staff privileges by hospital
MCH = Middleboro Community Hospital
WH = Webster Hospital
CCG = Capital City General
OMC= Osteopathic Medical Center, Capital City

Table 6.2

Table 6.2
Utilization Statistics—Middleboro Office
Name Specialty 2017 2016 2015
APPTS P-Days DIS APPTS P-Days DIS APPTS P-Days DIS
Department of Primary Care
S. St. James Pediatrics 5,521 120 45 5,432 135 40 5,234 178 59
R. Samuels Pediatrics 5,167 114 29 5,234 123 30 5,005 126 32
Q. Reeper Pediatrics 5,234 99 25 5,134 102 24 4,687 98 32
G. Gost OB/GYN 4,319 720 177 4,138 734 164 4,023 793 170
D. Dustin OB/GYN 4,625 650 193 4,456 645 187 4,044 696 190
Z. Autumn Gastroenterology 2,789 755 156 2,705 745 144 2,656 801 131
W. Xerox ENT 2,845 504 131 2,840 512 134 3,405 529 143
V. Weckensen ENT 2,945 483 104 2,834 477 99 2,341 490 105
T. Underwood Cardiology 4,456 677 133 4,178 606 105 4,277 545 109
D. Fixer Urology 2,403 578 143 2,202 598 142 2,005 612 157
C. Eason Urology 1,645 457 101 1,470 459 101 1,034 499 101
M. Master Internal medicine 3,623 492 102 4,263 501 102 2,330 535 135
L. Lesko Internal medicine 4,034 560 102 4,083 525 98 4,405 555 99
K. Kessler* Internal medicine 4,256 712 161 2,033 204 45 0 0 0
C. Douglas Internal medicine 4,340 820 210 4,256 834 187 4,456 902 167
A. Barton Internal medicine 4,206 850 177 4,256 654 152 4,124 756 165
Subtotals 62,408 8,591 1,989 59,514 7,854 1,754 54,026 8,115 1,795
Department of Surgery
H. Never General 2,546 870 215 2,206 830 204 2,345 854 207
J. Putter General 912 630 126 1,112 720 160 1,345 779 199
L. O'Connell General 1,456 416 104 1,045 418 103 867 436 109
D. Jackson General 1,843 792 167 1,678 722 134 1,767 812 99
B. Hersh General 1,245 1,200 267 1,045 1,103 245 1,956 1,223 265
M. Stanley Orthopedic 1,766 1,544 279 1,862 1,647 298 2,645 1,767 202
K. Qestrom Orthopedic 1,799 1,433 220 1,566 1,153 208 2,675 1,254 267
Subtotals 11,567 6,885 1,378 10,514 6,593 1,352 13,600 7,125 1,348
Total 73,975 15,476 3,367 70,028 14,447 3,106 67,626 15,240 3,143
NOTES:
APPTS = Appointments
P-Days - Patient days (all hospitals)
DIS = Discharges (all hospitals)
* = Hired July 1, 2013

Table 6.3

Table 6.3
Utilization Statistics—Jasper Office
Name Specialty 2017 2016 2015
APPTS P-Days DIS APPTS P-Days DIS APPTS P-Days DIS
Department of Primary Care
W. G. Chan Pediatrics 4,604 212 78 3,324 276 90 4,125 303 90
U. Unvey Pediatrics 4,767 234 66 4,654 267 69 4,209 291 81
N. Otter Pediatrics 4,523 206 51 4,045 224 57 4,509 205 45
P. Quester Pediatrics 4,033 312 75 3,978 356 76 3,956 334 79
M. Polk OB/GYN 3,651 650 140 3,612 984 202 3,487 982 215
J. Klock OB/GYN 3,749 607 135 3,256 1,115 256 3,356 1,138 267
L. Mustard OB/GYN 4,317 908 245 4,450 1,102 315 4,245 1,298 335
J. Washington Internal medicine 3,745 712 156 2,867 505 101 2,456 536 146
E. Frost* Internal medicine 4,980 700 176 3,156 646 120 2,077 495 103
L. Coolidge** ENT 3,369 345 123 3,278 806 323 1,433 345 143
K. Kipstein Cardiology 4,126 612 145 3,682 700 156 3,933 596 133
O. Maeer Cardiology 4,682 698 167 4,356 512 102 4,631 878 175
Subtotals 50,546 6,196 1,557 44,658 7,493 1,867 42,417 7,401 1,812
Department of Surgery
C. Finn General 1,587 806 165 1,601 1,206 245 700 830 203
A. Steve Orthpedic 1,266 612 134 1,534 733 167 793 723 154
S. Lee Orthpedic 2,156 885 231 1,935 893 287 1,689 1,104 303
L. Picture Orthpedic 1,920 957 245 1,756 1,234 298 2,156 1,556 366
L. Goldwater Orthpedic 2,877 1,134 278 2,645 1,376 325 2,034 1,589 387
Subtotals 9,806 4,394 1,053 9,471 5,442 1,322 7,372 5,802 1,413
Total 60,352 10,590 2,610 54,129 12,935 3,189 49,789 13,203 3,225
NOTES:
APPTS = Appointments
P-Days = Patient days (all hospitals)
DIS = Discharges (all hospitals)
* = Hired March 1, 2012
** = Hired, July 1, 2012

Table 6.7

Table 6.7
Statement of Revenue and Expense for Calendar Years Ending December 31
2017 2016 2015
Revenue
Patient services revenue 46,732,370 41,961,328 39,295,973
Allowances 8,206,111 7,658,241 5,720,365
Bad debt 760,040 519,476 498,207
Net patient services revenue 37,766,219 33,783,611 33,077,401
Other operating revenue 8,070 3,026 7,456
Total operating revenue 37,774,289 33,786,637 33,084,857
Expenses
Physician compensation 14,552,361 14,088,994 13,455,329
Other professional services 15,681,186 13,425,397 13,327,203
General services 3,548,975 2,243,109 2,125,242
Fiscal services 1,739,871 1,610,224 1,428,305
Interest 185,523 179,058 174,894
Depreciation 1,841,231 1,997,170 2,361,678
Total operating expenses 37,549,147 33,543,952 32,872,651
Pretax income (loss) 225,142 242,685 212,206
Taxes 85,554 92,220 80,638
Profit (loss) 139,588 150,465 131,568

Table 6.8

Table 6.8
Balance Sheet as of December 31
2017 2016 2015
Assets
Current assets
Cash and marketable securities 3,563,292 2,867,340 3,763,193
Accounts receivable—gross 8,929,737 7,423,188 7,334,868
Allowances for uncollectables -927,353 -689,303 -612,039
Accounts receivable—net 8,002,384 6,733,885 6,722,829
Due from third-party payers 556,247 634,929 1,012,745
Inventory 739,864 443,988 515,200
Prepaid expenses 254,352 797,665 342,389
Total current assets 13,116,139 11,477,807 12,356,356
Noncurrent assets
Property, plant, and equipment—gross 47,159,223 47,112,343 45,182,334
Less accumulated depreciation -19,084,473 -17,243,242 -15,246,072
Property, plant, and equipment—net 28,074,750 29,869,101 29,936,262
Other investments 1,917,234 2,120,940 2,087,230
Total assets 43,108,123 43,467,848 44,379,848
Liabilities
Current liabilities
Accounts payable 2,143,485 1,882,494 1,701,905
Accrued salaries and wages 837,240 801,282 735,240
Accrued interest 180,238 200,345 210,876
Other accrued expenses 137,450 154,203 150,239
Accrued vacation days 92,867 90,124 84,236
Due to third-party vendors 198,335 100,000 81,564
Long-term debt due within one year 952,189 874,230 912,572
Total current liabilities 4,541,804 4,102,678 3,876,632
Long-term debt 5,229,449 6,167,888 7,456,399
Total liabilities 9,771,253 10,270,566 11,333,031
Net assets 33,336,870 33,197,282 33,046,817
Total liabilities and net assets 43,108,123 43,467,848 44,379,848

Table 7.6

Table 7.6
Balance Sheet as of December 31
2017 2016 2015 2014
Assets
Current
Cash, operating 3,989,694 3,623,583 3,056,894 2,745,020
Cash, restricted 396,844 382,374 295,750 340,163
Patient trust cash 22,919 24,900 23,491 21,403
Total cash 4,409,457 4,030,857 3,376,135 3,106,586
Accounts receivable–net 2,083,242 2,156,393 2,134,265 1,990,237
Inventory 36,404 30,340 22,360 19,372
Prepaid expenses 50,494 45,202 37,345 39,202
Total current assets 6,579,597 6,262,792 5,570,105 5,155,397
Plant, property, and equipment (PPE)
Building, land, and improvements 814,300 795,756 690,202 680,272
Fixed and leasehold fixed equipment 156,303 155,302 155,506 180,383
Furniture and other equipment 1,082,011 995,292 990,385 994,283
Automobile 7,227 14,454 21,681 28,908
Total 2,059,841 1,960,804 1,857,774 1,883,846
Less accumulated depreciation 1,246,294 1,041,511 836,217 625,723
Net PPE 813,547 919,293 1,021,557 1,258,123
Other assets
Security deposits 11,565 9,450 10,474 12,570
Total assets 7,404,709 7,191,535 6,602,136 6,426,090
Liabilities and net assets
Current liabilities
Accounts payable 1,847,294 1,945,292 1,638,294 1,400,230
Accrued expenses 635,640 685,205 690,283 695,304
Patient trust liability 22,919 24,900 23,491 21,403
Accrued interest 9,371 9,145 8,628 8,120
Total current liabilities 2,515,224 2,664,542 2,360,696 2,125,057
Long-term liabilities
Deferred lease obligations 2,541,464 2,734,820 3,028,349 3,450,203
Due to (from) Medicaid (198,872) (106,392) (154,292) (254,981)
Notes payable 874,260 550,393 525,404 503,282
Line of credit 651,026 655,230 230,450 201,494
Total long-term liabilities 3,867,878 3,834,051 3,629,911 3,899,998
Total liabilities 6,383,102 6,498,593 5,990,607 6,025,055
Net assets–owners equity 897,725 692,942 611,529 401,035
Liabilities + net assets 7,280,827 7,191,535 6,602,136 6,426,090

Table 8.4

Table 8.4
Statement of Revenue and Expenses as of December 31
2017 2016 2015
Revenue
County appropriation/tax levy 2,421,165 2,553,000 2,870,525
Federal grants
CDC environmental health tracking 8,450 8,450 8,200
EPA—asthma 37,566 35,688 33,903
Oral health 21,705 24,340 27,393
Rural healthcare development 194,204 212,440 215,383
Rural poverty and homelessness 103,440 90,450 85,303
State grants
County health department development 215,400 200,000 200,000
EMS assistance 121,000 110,000 110,000
EMS preparedness 45,000 45,000 45,000
HIV control and prevention 55,000 55,000 55,000
Immunization 68,445 50,000 50,000
Lead control program 15,787 15,000 12,450
Medicaid oral health 118,407 94,818 56,282
Primary healthcare—demo 234,040 212,494 0
STD control and prevention 83,817 85,000 85,000
Tobacco use 56,818 72,404 86,249
WIC administration 85,000 85,000 85,000
WIC services 357,202 325,493 365,292
Private foundations
Breast cancer awareness 40,000 30,000 0
Obesity control and prevention 2,175 0 0
Subtotal external grants and contracts 1,863,456 1,751,577 1,520,455
Licenses and permits
Food services 6,219 5,740 5,952
Campgrounds 1,250 1,433 1,340
Tanning facilities 450 560 0
Special fees and fines 2,430 3,145 3,767
Overhead recovery1 100,113 125,000 150,300
Other—misc. 204 612 120
Subtotal noncounty tax revenue 1,974,122 1,888,067 1,681,934
Total revenue 4,395,287 4,441,067 4,552,459
Expenses
Office of the director
Salaries and wages 262,969 260,314 256,408
Benefits 73,631 77,286 71,063
Supplies 18,540 21,500 20,340
Equipment 24,660 24,302 12,560
Utilities2 2,422 2,200 2,030
Marketing and promotion 4,000 4,000 5,000
Staff development 500 4,000 4,000
Misc. 2,366 596 856
Grants to local agencies 4,800 6,800 6,800
Subtotal 393,888 400,998 379,057
Administrative services division
Salaries and wages 523,420 500,200 553,487
Benefits 157,026 155,062 171,580
Supplies 84,284 94,563 99,363
Equipment 4,803 5,234 4,109
Utilities2 28,383 26,440 28,304
Marketing and promotion 450 500 500
Staff development 1,000 1,500 2,000
Misc. 200 140 167
Grants to local agencies 0 0 0
Subtotal 799,566 783,639 859,510
Environmental health division
Salaries and wages 452,320 456,675 446,905
Benefits 135,696 141,569 138,541
Supplies 6,579 6,500 5,356
Equipment 1,039 2,546 2,946
Utilities2 37,669 36,122 35,476
Marketing and promotion 3,825 4,024 6,034
Staff development 500 4,000 4,000
Misc.—lab contracts 4,375 3,760 3,700
Misc. 243 201 103
Grants to local agencies 0 0 0
Subtotal 642,246 655,397 643,061
Community health and health promotion
Salaries and wages 765,744 762,971 735,923
Benefits 222,066 236,521 228,136
Supplies 98,161 103,453 117,506
Equipment 39,445 23,450 12,404
Utilities2 22,341 23,460 24,354
Marketing and promotion 4,512 5,500 5,500
Staff development 355 5,000 5,000
Misc. 456 402 450
Grants to local agencies 124,565 135,400 150,220
Subtotal 1,277,645 1,296,157 1,279,493
Personal health and health protection
Salaries and wages 765,957 780,156 847,233
Benefits 237,447 241,848 262,642
Supplies 103,288 110,393 114,506
Equipment 23,693 12,000 4,500
Utilities2 34,552 34,595 30,282
Marketing and promotion 2,300 2,500 2,500
Staff development 1,800 4,800 4,800
Misc. 356 221 498
Grants to local agencies 112,445 118,340 124,303
Subtotal 1,281,838 1,304,853 1,391,264
Total expenses 4,395,183 4,441,045 4,552,385
Excess revenue3 104 22 74
NOTES:
1. The amount included in grants to cover overhead. Used to reduce expenses.
2. Total charges for utilities allocated based on square feet occupied
3. Excess revenue is returned to the general fund at the end of the fiscal year

Table 8.5

Table 8.5
Budget by Source of Funds, 2017
Office of the Director Administrative Services Environmental Health Community Health and Health Promotion Personal Health and Health Protection Total
Federal grants
CDC environmental health tracking 8,450 8,450
EPA—asthma 37,566 37,566
Oral health 21,705 21,705
Rural healthcare development 21,000 50,000 80,060 43,144 194,204
Rural poverty and homelessness 18,000 74,800 10,640 103,440
State grants
County health department development 118,450 950 32,000 32,000 32,000 215,400
EMS assistance 121,000 121,000
EMS preparedness 45,000 45,000
HIV control and prevention 30,000 25,000 55,000
Immunization 68,445 68,445
Lead control program 15,787 15,787
Medicaid oral health 118,407 118,407
Primary healthcare—demo 9,475 224,565 234,040
STD control and prevention 83,817 83,817
Tobacco use 56,818 56,818
WIC administration 25,500 15,600 43,900 85,000
WIC services 357,202 357,202
Private foundations
Breast cancer awareness 40,000 40,000
Obesity control and prevention 2,175 2,175
Total grants and contracts 182,950 66,550 183,338 669,502 761,116 1,863,456
Other revenue 10,553 10,553
Overhead recovery 100,113 100,113
Total noncounty revenue 193,503 166,663 183,338 669,502 761,116 1,974,122
County tax appropriation 200,385 632,903 458,908 608,143 520,722 2,421,061
Total budget by division 393,888 799,566 642,246 1,277,645 1,281,838 4,395,183
Percent total budget—county funds 50.9% 79.2% 71.5% 47.6% 40.6% 55.1%

Table 8.6

Table 8.6
Staffing Budget, 2017–2015
2017 2016 2015
Office of the director FTE Budgeted Salary FTE Budgeted Salary FTE Budgeted Salary
Director 1.0 130,174 1.0 130,174 1.0 130,174
Administrative assistant III 1.0 39,262 1.0 38,477 1.0 37,322
Administrative assistant II 0.5 31,348 0.0 30,721 0.0 29,799
Health info tech 0.5 44,560 0.5 43,669 0.5 42,359
Intern 0.5 17,625 0.5 17,273 0.5 16,754
Subtotal 3.5 262,969 3.0 260,314 3.0 256,408
Administrative services
Deputy director for administration 1.0 92,330 1.0 90,483 1.0 88,674
Public health medical director 0.5 98,517 0.5 98,517 0.5 98,517
Business services officer 1.2 90,315 1.0 73,787 1.0 72,340
Customer service rep II 1.0 53,315 1.0 52,249 1.0 51,204
Administrative services manager 1.0 51,230 2.0 50,205 2.0 49,201
Administrative assistant II 1.0 31,348 1.0 30,721 1.0 30,107
Custodian 2.5 106,365 3.0 104,238 4.0 163,444
Subtotal 8.2 523,420 9.5 500,200 10.5 553,487
Environmental health
Deputy director for environmental health 1.0 103,233 1.0 101,168 1.0 101,168
Environmental health specialist IV 1.0 54,223 1.0 53,139 1.0 53,139
Environmental health specialists II 4.0 135,056 4.0 132,408 4.0 129,812
Public health specialist II 2.0 128,460 2.0 125,891 2.0 119,598
Administrative assistant II 1.0 31,348 1.0 30,721 1.0 30,107
Administrative assistant I 0.0 0 0.5 13,348 0.5 13,081
Subtotal 9.0 452,320 9.5 456,675 9.5 446,905
Community health and health promotion
Deputy director for community health 1.0 93,274 1.0 88,610 1.0 86,838
Community health nurse 6.0 379,260 6.0 367,882 6.0 360,525
Public health specialist II 3.0 192,960 3.0 183,312 3.0 179,646
Public health preparedness admin 1.0 86,200 1.3 109,819 1.0 82,752
Administrative assistant I 0.5 14,050 0.5 13,348 1.0 26,163
Subtotal 11.5 765,744 11.8 762,971 12.0 735,923
Personal health and health protection
Deputy director for personal health 1.0 104,330 1.0 99,114 1.0 97,131
Public health specialist III 2.0 120,068 2.0 114,065 3.0 111,783
Program director for women's health 1.0 84,670 1.0 80,437 1.0 78,828
Public health nurse 5.0 332,115 5.0 315,509 5.0 247,360
Case control investigators 1.0 84,550 1.4 86,173 2.0 162,336
Community services assistant 0.5 24,550 1.5 69,968 2.0 91,425
Administrative assistant II 0.5 15,674 1.0 14,890 2.0 58,370
Subtotal 11.0 765,957 12.9 780,156 16.0 847,233
Total 43.2 2,770,410 46.7 2,760,315 51.0 2,839,956

Table A.1

Table A.1
Capital City Population: 1992–2017
All Races 1992 1997 2002 2007 2012 2017
Ward I 37,450 39,339 41,249 40,320 41,250 40,293
Ward II 45,204 46,503 47,502 50,395 52,395 50,392
Ward III 18,346 21,340 29,720 31,370 31,595 35,202
Ward IV 9,450 13,268 36,869 38,145 38,200 51,673
Total 110,450 120,450 155,340 160,230 163,440 177,560
White 1992 1997 2002 2007 2012 2017
Ward I 30,070 31,898 28,272 26,646 25,949 19,241
Ward II 40,214 38,987 39,815 42,599 44,057 38,668
Ward III 13,774 17,088 24,590 25,971 25,350 27,212
Ward IV 8,790 12,603 35,867 37,123 35,387 48,936
Total 92,848 100,576 128,544 132,339 130,743 134,057
Black 1992 1997 2002 2007 2012 2017
Ward I 6,524 6,506 11,627 12,096 13,612 19,202
Ward II 4,428 6,927 6,927 6,826 7,218 10,294
Ward III 4,252 3,820 4,368 4,516 5,365 7,067
Ward IV 189 212 379 597 1,590 1,612
Total 15,393 17,465 23,301 24,035 27,785 38,175
Other 1992 1997 2002 2007 2012 2017
Ward I 856 935 1,350 1,578 1,689 1,850
Ward II 562 589 760 970 1,120 1,430
Ward III 320 432 762 883 880 923
Ward IV 471 453 623 425 1,223 1,125
Total 2,209 2,409 3,495 3,856 4,912 5,328