|
CABARRUS COUNTY
<br />SELF INSURED HEALTH INSURANCE FUND 610
<br />From Inception to Date
<br />EXPENSES
<br />61091917 -9301
<br />Employee Premium
<br />Office Supplies
<br />$
<br />$
<br />$
<br />450
<br />$ 352
<br />$ 1,042
<br /># of Participates on plan
<br />1,250
<br />$
<br />278
<br />$
<br />300
<br />61091917 -9331
<br />Minor Off Equip & Furniture
<br />ACTUAL
<br />3,821
<br />270
<br />794
<br />Estimated
<br />318
<br />2005
<br />2006
<br />2007
<br />2008
<br />2009
<br />2010
<br />2011
<br />2012
<br />REVENUES:
<br />5,757
<br />11,663
<br />-
<br />10,366
<br />61061917 -6661
<br />Insurance Premiums
<br />$ 4,361,107
<br />$ 4,813,783 $
<br />4,706,864 $
<br />6,058,399 $
<br />7,167,699 $
<br />7,621,823 $
<br />7,601,985
<br />$ 7,600,000
<br />61061917 -6804
<br />Insurance Refunds
<br />31,380
<br />38,315
<br />78,110
<br />140,882
<br />121,347
<br />294
<br />61061917 -6902
<br />Cont from General Fund
<br />15,562
<br />1,000,000
<br />16,828
<br />61061917 -6240
<br />EERP
<br />28,212
<br />30,000
<br />61091917 -9412
<br />Lights & Power
<br />87,149
<br />96,067
<br />61061917 -6701
<br />Interest on Investments
<br />54,076
<br />98,080
<br />102,478
<br />66,122
<br />33,155
<br />8,732
<br />9,797
<br />2,595
<br />Total Revenues
<br />4,000
<br />$ 4,415,183
<br />$ 4,911,863 $
<br />4,809,342 $
<br />6,124,521 $
<br />7,278,964 $
<br />8,771,437 $
<br />7,820,278
<br />$ 7,698,956
<br />EXPENSES
<br />61091917 -9301
<br />Office Supplies
<br />$
<br />$
<br />$
<br />450
<br />$ 352
<br />$ 1,042
<br />$
<br />1,250
<br />$
<br />278
<br />$
<br />300
<br />61091917 -9331
<br />Minor Off Equip & Furniture
<br />3,821
<br />270
<br />794
<br />14,652
<br />318
<br />240
<br />61091917 -9360
<br />Medical Supplies
<br />5,757
<br />11,663
<br />-
<br />10,366
<br />45,000
<br />61091917 -9360
<br />Medical Labs
<br />19,336
<br />43,749
<br />28,068
<br />31,380
<br />38,315
<br />61091917 -9401
<br />Building Rent
<br />15,562
<br />16,004
<br />16,828
<br />23,337
<br />28,212
<br />30,000
<br />61091917 -9412
<br />Lights & Power
<br />1,812
<br />1,812
<br />2,187
<br />3,641
<br />4,955
<br />4,000
<br />61091917 -
<br />942001
<br />Telephone
<br />2,093
<br />2,624
<br />1,552
<br />1,420
<br />332
<br />61091917 -9445
<br />Purchased Services
<br />30,480
<br />21,437
<br />27,718
<br />6,395
<br />3,679
<br />150
<br />61091917 -9485
<br />Admin Fees
<br />505,251
<br />608,178
<br />682,657
<br />819,230
<br />932,373
<br />1,006,615
<br />1,072,165
<br />1,140,000
<br />61091917 -9570
<br />Service Contracts
<br />-
<br />-
<br />94,875
<br />146,054
<br />145,115
<br />171,377
<br />328,775
<br />484,000
<br />61091917 -9605
<br />Consultants
<br />-
<br />-
<br />5,273
<br />-
<br />4,895
<br />5,158
<br />61091917 -9645
<br />Hospital Claims
<br />2,745,242
<br />3,623,186
<br />3,953,179
<br />5,755,000
<br />5,194,040
<br />6,535,995
<br />6,626,935
<br />8,100,000
<br />61091917 -9647
<br />Wellness Program
<br />-
<br />1,310
<br />-
<br />-
<br />61091917 -9821
<br />Building Renovations
<br />8,289
<br />Total Expenses
<br />$
<br />3,250,493
<br />$
<br />4,232,674
<br />$
<br />4,815,295
<br />$ 6,818,195
<br />$ 6,354,610
<br />$
<br />7,819,876
<br />$
<br />8,103,963
<br />$
<br />9,803,690
<br />Net Difference
<br />$
<br />1,164,690
<br />$
<br />679,189
<br />$
<br />(5,953)
<br />$ (693,674)
<br />$ 924,354
<br />$
<br />951,561
<br />$
<br />(283,685)
<br />$
<br />(2,104,734)
<br />Reserve Balance (Actual)
<br />$
<br />1,164,690
<br />$
<br />1,843,879
<br />$
<br />1,837,926
<br />$ 1,144,252
<br />$ 2,068,606
<br />$
<br />3,020,166
<br />$
<br />2,736,482
<br />$
<br />631,748
<br />Reserve Balance ( Est at 20 %)
<br />$
<br />650,099
<br />$
<br />846,535
<br />$
<br />963,059
<br />$ 1,363,639
<br />$ 1,270,922
<br />$
<br />1,563,975
<br />$
<br />1,620,793
<br />$
<br />1,960,738
<br />Excess Reserve
<br />$
<br />514,591
<br />$
<br />997,344
<br />$
<br />874,867
<br />$ (219,387)
<br />$ 797,684
<br />$
<br />1,456,191
<br />$
<br />1,115,689
<br />$
<br />(1,328,990)
<br />Attachment number 1
<br />F -1 Page 31
<br />
|