No preview available
HomeMy WebLinkAboutMay 2015 - Financial Statements 8/18/2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2015 GENERAL FUND FYE 2015 Activity Total (includes Percent 2014 - 2015 Same Period Department Adjusted Budgetencumbrances)to DateLast Fiscal Year FYE 2013FYE 2014 Governing Body $ 180,854 $ 164,631 $ 211,842 $ 121,113 57.17% $ 118,295 Administration 339,722 250,759 308,186 226,405 73.46% 198,408 Legal Services 122,070 103,351 121,126 (16,954)-14.00% 66,721 Engineering - 1 2,576 50,402 ####### (11,268) Human Resources 224,821 254,738 284,078 202,982 71.45% 222,344 Board of Elections 357,108 303,532 365,980 282,052 77.07% 287,344 Finance 961,984 729,469 897,005 675,555 75.31% 619,696 Clerk of Court 98,086 77,704 89,554 76,171 85.06% 74,213 Tax 1,664,758 1,569,231 1,788,464 1,322,461 73.94% 1,432,160 General Services 473,759 140,485 159,760 136,306 85.32% 124,768 Fleet Maintenance - 438,847 706,677 518,305 73.34% 413,695 Transportation 940,206 1,004,266 1,275,021 696,297 54.61% 750,021 Transportation - Admin 188,721 194,790 224,982 185,899 82.63% 168,342 Facilities Maintenance 3,285,478 3,400,887 4,209,204 2,805,879 66.66% 2,695,790 Register of Deeds 761,273 730,166 832,943 610,221 73.26% 646,040 Information Technology 1,256,973 1,301,628 1,847,448 1,557,520 84.31% 1,206,069 GIS 440,731 432,327 465,436 377,350 81.07% 400,877 Sheriff 9,344,007 10,166,283 10,878,706 8,886,098 81.68% 9,112,109 Campbell Deputies 357,903 354,232 444,887 346,005 77.77% 326,373 Harnett CJPP 53,836 80,119 - - 70,430 Sheriff's Department Grants 38,810 15,213 25,615 1,607 6.27% 15,213 Child Support Enforcement 67,192 66,257 80,227 62,027 77.31% 60,617 Governor's Highway Safety 112,332 26,536 - - 26,536 Life is Fragile (NCGCC) 29,531 - - - - Communications 1,116,529 1,219,142 1,596,653 1,227,400 76.87% 1,106,794 Jail 4,187,264 4,306,490 4,983,521 3,877,762 77.81% 3,793,630 Emergency Services 712,960 737,021 836,238 638,975 76.41% 651,501 Emergency Services Grant 1,000 32,000 - - 32,000 Emergency Medical Service 4,179,979 3,991,897 4,223,414 3,446,057 81.59% 3,492,853 EMS Transport 960,370 1,083,318 1,192,702 916,584 76.85% 924,118 Rescue Districts 3,225,144 3,314,704 3,361,704 3,361,704 100.00% 3,314,704 Animal Services 381,748 376,744 490,182 358,414 73.12% 323,617 Medical Examiner 40,200 50,000 65,000 43,850 67.46% 45,300 JCPC Admin - - 5,000 3,636 72.72% - Public Safety Appropriations 126,278 124,334 79,766 72,943 91.45% 115,329 Emergency Telephone System 243,460 240,521 265,818 217,727 81.91% 217,883 Radio System 474,341 300,204 302,100 199,336 65.98% 278,471 Harnett Regional Jetport 179,592 174,955 222,804 151,710 68.09% 170,114 Soil & Water 119,598 124,133 182,238 141,261 77.51% 110,902 Environmental Protection 4,000 4,000 14,000 4,000 28.57% 4,000 Forestry Program 113,334 114,849 114,992 94,327 82.03% 104,791 Economic/Physical Dev. App. 1,509,397 449,748 595,500 376,103 63.16% 328,261 Industrial Development 1,462,725 776,301 1,456,905 1,351,333 92.75% 776,130 Planning & Inspections 1,437,604 1,321,571 1,429,200 1,169,484 81.83% 1,179,870 Community Development (BG) - 1,129 1,300 559 43.00% 1,250 Abandoned MFG Home - 31,903 70,264 48,680 69.28% 28,857 Cooperative Extension 427,644 351,557 430,238 240,116 55.81% 295,111 CCR&R - Block Grant 27,369 31,419 34,752 22,874 65.82% 27,444 CCR&R - United Way - 2,483 2,978 342 11.48% 2,153 Parents As Teachers 226,262 158,263 59,500 40,646 68.31% 144,874 Adolescent Parenting 60,003 59,107 62,488 55,616 89.00% 54,512 1 U:\\My Documents\\Monthly Reports\\2014 - 2015\\May 2015 - Financial Statements.xlsx 8/18/2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2015 GENERAL FUND FYE 2015 Activity Total (includes Percent 2014 - 2015 Same Period Department Adjusted Budgetencumbrances)to DateLast Fiscal Year FYE 2013FYE 2014 CCR&R - Smart Start 17,922 - - - - 4-H Teen Court & At Risk 30,804 45,686 50,854 43,379 85.30% 40,493 Child Care Youth Training - 27,367 - - 27,367 Race to the Top - 13,570 28,495 14,190 49.80% 12,654 Adolescent Parenting - 3,789 - - 3,789 Department on Aging 293,761 283,332 320,788 275,063 85.75% 247,516 Family Caregiver Support 38,363 51,769 65,415 56,469 86.32% 48,430 RSVP 72,852 73,276 80,358 68,820 85.64% 65,960 CAP - Disabled Adults 291,181 326,783 343,183 294,349 85.77% 300,647 Nutrition for Elderly 405,545 378,087 434,767 370,900 85.31% 319,921 Health 5,932,196 5,787,018 7,630,297 5,279,052 69.19% 5,066,189 Mental Health 615,679 815,679 605,679 605,679 100.00% 815,679 Social Services 9,418,756 9,359,396 10,710,186 8,786,279 82.04% 8,475,792 Public Assistance 7,944,608 7,829,453 8,916,439 7,052,060 79.09% 6,991,693 Veteran's Services 166,579 172,197 182,747 157,844 86.37% 154,663 Restitution 127,765 110,369 117,214 87,680 74.80% 96,597 Human Services App. 174,635 99,840 99,000 75,298 76.06% 99,840 Library 881,506 928,107 1,105,664 797,645 72.14% 801,708 Cultural & Recreational App. 167,000 100,000 150,000 - 0.00% 100,000 Parks & Recreation 319,254 363,011 450,776 335,857 74.51% 310,369 Education Board of Education - current 20,288,004 20,523,700 21,523,700 21,523,700 100.00% 20,523,700 Board of Education - capital - - - - - Central Carolina - current 638,841 927,711 917,467 917,467 100.00% 850,402 Central Carolina - capital 23,973 - - - - Central Carolina - works - 25,000 25,000 25,000 100.00% 25,000 Interfund Transfers 455,491 1,903,876 57,755 49,272 85.31% 36,667 Debt Service 11,486,712 13,902,144 15,185,209 44,221,567 291.21% 13,859,606 Contingency - - - - - Total $ 102,308,383 $ 105,234,405 $ 116,299,967$ 128,222,710 110.25%$ 95,823,944 Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Ad Valorem Taxes Real and Personal $ 54,273,480$ 54,120,822$ 52,510,671$ 53,941,860102.73%$ 53,899,155 Motor Vehicles - 3,949,979 5,340,855 4,704,26888.08% 2,970,936 Sales Tax 14,238,193 14,884,497 14,980,744 11,460,15376.50% 8,335,577 Other taxes 1,010,549 1,037,719 1,200,000 787,564 65.63% 847,953 Permits & Fees 3,089,188 2,763,205 2,928,667 2,278,59877.80% 2,463,057 Intergovernmental Revenue 20,204,388 19,304,274 19,135,671 13,059,85068.25% 16,656,144 Sales & Services 9,422,096 7,658,151 9,717,780 6,168,78663.48% 5,854,214 Other Revenues 2,902,980 3,451,519 3,832,648 3,206,57483.66% 2,648,331 Rents, Concessions. & Fees 83,870 77,898 84,251 59,30370.39% 60,645 Other Finance Sources 960,622 857,548 450,000 29,098,735####### 830,155 Interfund Transfers 438,263 460,947 732,541 - 0.00% 5,947 Fund Balance Appropriated - - 5,386,139 - 0.00% - Total $ 106,623,629 $ 108,566,559 $ 116,299,967$ 124,765,691 107.28%$ 94,572,113 Revenues over/(under) expenditures $ (3,457,019) (1,251,830) 2 U:\\My Documents\\Monthly Reports\\2014 - 2015\\May 2015 - Financial Statements.xlsx 8/18/2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2015 GENERAL FUND Cash and Investments CashTax LockboxMBSNCCMTTotal May, 2015 $ 3,587,900$ -$ 1,149,750$ 22,024,531$ 26,762,181 April, 2015 $ 10,758,278$ -$ 1,099,750$ 20,688,202$ 32,546,230 March, 2015 $ 19,176,680$ -$ 1,099,750$ 19,219,802$ 39,496,232 February, 2015 $ 20,516,681$ 475$ 1,099,750$ 16,737,860$ 38,354,765 January, 2015 $ 25,124,005$ 475$ 874,750$ 15,004,637$ 41,003,866 December, 2014 $ 2,815,021$ 475$ 624,759$ 32,414,000$ 35,854,255 November, 2014 $ 2,599,381$ 475$ 400,000$ 24,393,150$ 27,393,006 October, 2014 $ -$ 475$ -$ 24,307,459$ 24,307,934 September, 2014 $ -$ 475$ -$ 26,396,094$ 26,396,569 August, 2014 $ -$ 475$ -$ 19,277,617$ 19,278,091 July, 2014 $ -$ 475$ -$ 20,554,835$ 20,555,310 June, 2014 $ 2,799,637$ 475$ -$ 21,645,331$ 24,445,443 May, 2014 $ 5,325,561$ 27,888 $ -$ 20,305,523$ 25,658,972 Debt Service and Transfer Requirements Current YearOutstanding Interest$ 5,465,931$ 58,811,027 Principal 9,719,278 143,630,869 Transfers Out 43,334 - $ 15,228,543$ 202,441,896 Estimated Fund Balance In the governmental fund financial statements, fund balance is composed of five classifications designed to disclose the hierarchy of constraints placed on how fund balance can be spent. They are as follows: This classification includes amounts that cannot be spent because they are either (a) not in spendable Non-Spendable Fund Balance - form or (b) legally or contractually required to be maintained intact. The classification includes amount that are restricted to specific purposes externally imposed by creditors Restricted Fund Balance - or imposed by law. This classification represents the portion of fund balance that can only be used for specific purposes Committed Fund Balance - imposed by majority vote by a quorum of the County Commissioners, that can by adoption of an ordinance, commit fund balance. That portion of fund balance that the County intends to use for specific purposes. The County Assigned Fund Balance - Commissioners have the authority to assign fund balances. This classification represents the portion of fund balance that has not been assigned to another fund or is Unassigned Fund Balance - not restricted, committed, or assigned to specific purposes within the general fund. 3 U:\\My Documents\\Monthly Reports\\2014 - 2015\\May 2015 - Financial Statements.xlsx 8/18/2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2015 GENERAL FUND Unassigned Fund Balance at June 30, 2014$ 18,732,09517.90% Year to Date Revenues over/(under) Expenditures (3,457,019) 15,275,076 Remaining Debt Payments for this Year (58,481) Outstanding budget amendments - Year to Date Fund Balance Appropriated (5,386,139) (5,444,620) If the County were to stop operations at the end of this month and had $ 9,830,456 no further receivables or payables, then this would be the estimated fund balance amount and its percentage of expenditures. 8.45% Amount by which fund balance percentage will change$ 1,163,000 The County Board of Commissioners have approved a fund balance policy which strives to maintain a minimum fund balance of 15%. 4 U:\\My Documents\\Monthly Reports\\2014 - 2015\\May 2015 - Financial Statements.xlsx 8/18/2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2015 PUBLIC UTILITIES FUND FYE 2015 Activity Total (includes Percent 2014 - 2015 Same Period Department Adjusted Budgetencumbrances)to DateLast Fiscal Year FYE 2013FYE 2014 Admin/CSR/Meter Services $ 37,598,026$ 19,229,033$ 24,466,519$ 31,577,470129.06%$ 11,784,559 Water Treatment 3,571,705 3,671,291 4,465,667 3,295,44873.80% 3,093,222 Wastewater Treatment 1,790,807 1,965,319 2,359,213 1,597,52567.71% 1,582,747 Wastewater Treatment SHWW 1,358,206 1,860,402 2,336,240 1,565,05866.99% 1,586,240 Distribution 3,349,268 3,383,463 4,240,690 3,208,05575.65% 2,882,837 Collections 3,056,462 2,975,052 3,549,873 2,662,22674.99% 2,498,314 Total$ 50,724,474$ 33,084,560$ 41,418,202$ 43,905,782106.01%$ 23,427,919 Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Intergovernmental Revenue $ 3,703$ 3,703$ 3,600$ 3,703102.86%$ 3,703 Sales & Services 27,670,467 30,275,723 26,921,865 25,857,02496.04% 25,776,870 Other Revenues 4,934,826 13,281,536 1,788,900 2,466,505137.88% 1,145,550 Rents, Concess. & Feees 5,531 96 5,000 140.28% - Other Finance Sources 20,065,000 473,683 - 12,113,312 - Interfund Transfers - 150,000 - 652,130 150,000 Fund Balance Appropriated - - 12,698,837 - 0.00% - Total$ 52,679,527$ 44,184,741$ 41,418,202$ 41,092,68899.21%$ 27,076,123 Revenues over/(under) expenses$ (2,813,094)$ 3,648,204 Cash and Investments CashLockboxNCCMTTotal May, 2015 $ 20,248,407$ 2,565,016$ 547,616$ 23,361,038 April, 2015 $ 22,900,249$ 2,178,132$ 544,445$ 25,622,825 March, 2015 $ 24,744,895$ 1,692,081$ 543,143$ 26,980,119 February, 2015 $ 25,190,426$ 1,237,290$ 524,212$ 26,951,928 January, 2015 $ 24,654,644$ 878,473$ 520,942$ 26,054,059 December, 2014 $ 28,444,625$ 391,704$ 520,942$ 29,357,270 November, 2014 $ 29,119,405$ 38,435 $ 519,270$ 29,677,110 October, 2014 $ 29,394,358$ -$ 517,712$ 29,912,069 September, 2014 $ 28,441,620$ -$ 517,378$ 28,958,997 August, 2014 $ 25,475,483$ -$ 516,449$ 25,991,932 July, 2014 $ 25,392,786$ -$ 515,469$ 25,908,254 June, 2014 $ 23,566,116$ -$ 512,929$ 24,079,044 May, 2014 $ 22,909,362$ -$ 511,160$ 23,420,522 Debt Service and Transfer Requirements Current YearOutstanding Interest$ 2,999,352$ 36,944,577 Principal$ 4,922,410 87,739,896 Transfers Out$ 1,164,682 - $ 9,086,444$ 124,684,473 5 U:\\My Documents\\Monthly Reports\\2014 - 2015\\May 2015 - Financial Statements.xlsx 8/18/2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2015 SOLID WASTE FUND FYE 2015 Activity Total (includes Percent 2014 - 2015 Same Period Department Adjusted Budgetencumbrances)to DateLast Fiscal Year FYE 2013FYE 2014 Solid Waste $ 5,073,308$ 5,161,897$ 6,012,059$ 5,641,92293.84%$ 4,177,043 Total$ 5,073,308$ 5,161,897$ 6,012,059$ 5,641,92293.84%$ 4,177,043 Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Taxes $ 227,228$ 237,297$ 259,000$ 174,45267.36%$ 183,803 Intergovernmental Revenue - - 154,500 - 4,497,821 Sales & Services 4,776,288 5,006,315 5,097,390 4,995,98098.01% 106,480 Other Revenues 638,962 378,116 2,400 263,563 203 10981.79% Rents, Concess. & Feees 430 243 - 119 739,763 Other Finance Sources 582,662 739,763 - 1,402,161 - Interfund Transfers - - - - - Fund Balance Appropriated - - 498,769 - 0.00% - Total$ 6,225,570$ 6,361,734$ 6,012,059$ 6,836,275113.71%$ 5,528,070 Revenues over/(under) expenses$ 1,194,353$ 1,351,027 Cash and Investments CashSun TrustFirst BankNCCMTTotal May, 2015 $ 954,650$ 359,056$ 333,965$ 443,279$ 2,090,950 April, 2015 $ 1,166,505$ 343,248$ 333,965$ 387,764$ 2,231,482 March, 2015 $ 1,347,614$ 316,331$ 312,432$ 387,764$ 2,364,141 February, 2015 $ 1,654,243$ 296,898$ 294,942$ 415,261$ 2,661,345 January, 2015 $ 2,189,209$ 290,527$ 289,211$ 356,254$ 3,125,201 December, 2014 $ 1,734,168$ 294,082$ 268,860$ 356,254$ 2,653,365 November, 2014 $ 1,239,986$ 267,007$ 268,860$ 356,254$ 2,132,107 October, 2014 $ 635,163$ 256,610$ 253,226$ 296,324$ 1,441,322 September, 2014 $ 783,054$ 237,379$ 234,622$ 296,324$ 1,551,379 August, 2014 $ 513,937$ 202,029$ 206,671$ 296,324$ 1,218,960 July, 2014 $ 481,103$ 193,679$ 199,824$ 242,829$ 1,117,436 June, 2014 $ 709,310$ 153,450$ 169,118$ 242,829$ 1,274,707 May, 2014 $ 1,018,519$ 153,450$ 169,118$ 242,829$ 1,583,916 Debt Service and Transfer Requirements Current YearOutstanding Interest$ 127,786$ 796,081 Principal 403,867 3,338,828 Transfers Out - - $ 531,653$ 4,134,909 6 U:\\My Documents\\Monthly Reports\\2014 - 2015\\May 2015 - Financial Statements.xlsx 8/18/2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2015 WORKER'S COMPENSATION FUND FYE 2015 Activity Total (includes Percent 2014 - 2015 Same Period Category Adjusted Budgetencumbrances)to DateLast Fiscal Year FYE 2013FYE 2014 Claims Funded $ -$ -$ 1,250,000$ 452,06436.17%$ 1,129,945 Fixed Cost - - - - 1,000 Total$ -$ -$ 1,250,000$ 452,06436.17%$ 1,130,945 Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Departmental Charge $ -$ -$ 1,000,000$ 812,24481.22%$ 1,562,753 Other revenues - - 250,000 164,157 65.66% 268,588 Fund Balance Appropriated - - - - - Total$ -$ -$ 1,250,000$ 976,40178.11%$ 1,831,341 Revenues over/(under) expenses$ 524,337$ 700,396 Cash and Investments CashNCCMTTotal May, 2015$ 1,273,019$ 562,026$ 1,835,045 April, 2015$ 1,248,082$ 562,026$ 1,810,108 March, 2015$ 1,114,579$ 562,026$ 1,676,605 February, 2015$ 710,218$ 562,026$ 1,272,244 January, 2015$ 678,017$ 562,026$ 1,240,043 December, 2014$ 603,529$ 562,026$ 1,165,555 November, 2014$ 740,749$ 562,026$ 1,302,775 October, 2014$ 667,246$ 562,026$ 1,229,273 September, 2014$ 361,074$ 562,026$ 923,101 August, 2014$ 368,074$ 562,026$ 930,101 July, 2014$ 362,656$ 562,026$ 924,682 June, 2014$ 742,259$ 562,026$ 1,304,285 May, 2014$ 899,419$ -$ 899,419 Liability Liability as of July 1$ 3,189,117 # of Claims this 57 Current year claims and 86,702 fiscal year changes in estimates Actual claim payments 52,740 Liability as of end of month$ 3,223,079 7 U:\\My Documents\\Monthly Reports\\2014 - 2015\\May 2015 - Financial Statements.xlsx 8/18/2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2015 EMPLOYEE CLINIC FUND FYE 2015 Activity Total (includes Percent 2014 - 2015 Same Period Category Adjusted Budgetencumbrances)to DateLast Fiscal Year FYE 2013FYE 2014 Employee Clinic $ -$ -$ 268,667$ 104,81939.01%$ 77,712 Total$ -$ -$ 268,667$ 104,81939.01%$ 77,712 Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Departmental Charge $ -$ -$ 268,667$ 209,60078.01%$ 259,402 Other revenues - - - - - Fund Balance Appropriated - - - - - Total$ -$ -$ 268,667$ 209,60078.01%$ 259,402 Revenues over/(under) expenses$ 104,781$ 181,690 Cash and Investments CashNCCMTTotal May, 2015$ 534,685$ 29,241 $ 563,926 April, 2015$ 529,175$ 29,241 $ 558,416 March, 2015$ 520,088$ 29,241 $ 549,330 February, 2015$ 487,335$ 29,241 $ 516,576 January, 2015$ 502,826$ 29,241 $ 532,068 December, 2014$ 491,748$ 29,241 $ 520,990 November, 2014$ 461,196$ 29,241 $ 490,437 October, 2014$ 469,068$ 29,241 $ 498,309 September, 2014$ 402,040$ 29,241 $ 431,281 August, 2014$ 409,914$ 29,241 $ 439,155 July, 2014$ 419,756$ 29,241 $ 448,997 June, 2014$ 429,904$ 29,241 $ 459,145 May, 2014$ 412,513$ -$ 412,513 8 U:\\My Documents\\Monthly Reports\\2014 - 2015\\May 2015 - Financial Statements.xlsx 8/18/2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2015 MEDICAL INSURANCE FUND FYE 2015 Activity Total (includes Percent 2014 - 2015 Same Period Category Adjusted Budgetencumbrances)to DateLast Fiscal Year FYE 2013FYE 2014 Paid Claims $ -$ -$ 5,480,000$ 4,266,84777.86%$ - Fixed Cost - - 634,000 662,901 104.56% - Wellness - - 13,000 13,000100.00% - Total$ -$ -$ 6,127,000$ 4,942,74880.67%$ - Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Medical Premium Equivilents $ -$ -$ 6,127,000$ 6,159,114100.52%$ - Other revenues - - - 10,783 - Total$ -$ -$ 6,127,000$ 6,169,897100.70%$ - Revenues over/(under) expenses$ 1,227,149$ - Cash and Investments CashNCCMTTotal May, 2015 $ 1,272,924$ 543,297$ 1,816,222 April, 2015 $ 1,300,653$ 543,297$ 1,843,950 March, 2015 $ 1,212,904$ 543,297$ 1,756,201 February, 2015 $ 1,154,305$ 543,297$ 1,697,602 January, 2015 $ 1,085,587$ 543,297$ 1,628,884 December, 2014 $ 1,252,111$ 543,297$ 1,795,409 November, 2014 $ 1,271,922$ 543,297$ 1,815,219 October, 2014 $ 970,266$ 543,297$ 1,513,564 September, 2014 $ 1,086,724$ 543,297$ 1,630,021 August, 2014 $ 1,042,547$ 543,297$ 1,585,844 July, 2014 $ 768,924$ 543,297$ 1,312,222 June, 2014 $ -$ -$ - May, 2014 $ -$ -$ - Medical Paid Claims Summary Employees & Total Loss Premium Pre-65 RetireesMembershipRatioEquivalent Net Paid ClaimsFixed Cost July, 2014 7981,118$ 30,033.77$ 55,339.9516.38%$ 521,068.58 August, 2014 7901,116$ 388,554.44$ 54,574.1485.33%$ 519,292.97 September, 2014 7901,121$ 281,141.92$ 56,866.0565.44%$ 516,539.09 October, 2014 7851,119$ 391,265.25$ 58,272.0485.14%$ 528,012.65 November, 2014 8001,138$ 621,792.30$ 55,926.35127.90%$ 529,863.38 December, 2014 8081,147$ 333,468.11$ 49,283.9172.04%$ 531,335.01 January, 2015 8071,151$ 487,728.89$ 57,596.15103.13%$ 528,795.73 February, 2015 8061,147$ 336,382.95$ 54,934.3873.94%$ 529,264.07 March, 2015 8021,146$ 515,658.71$ 53,074.98107.28%$ 530,160.13 April, 2015 8041,140$ 374,939.32$ 52,289.3781.17%$ 526,331.03 May, 2015 7961,139$ 467,578.37$ 35,682.0594.92%$ 530,200.36 June, 2015 Year to Date7991,135$ 4,228,544.03$ 583,839.3783.10%$ 5,790,863.00 (membership = avg) 9 U:\\My Documents\\Monthly Reports\\2014 - 2015\\May 2015 - Financial Statements.xlsx 8/18/2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2015 DENTAL INSURANCE FUND FYE 2015 Activity Total (includes Percent 2014 - 2015 Same Period Category Adjusted Budgetencumbrances)to DateLast Fiscal Year FYE 2013FYE 2014 Paid Claims $ -$ -$ 340,000$ 235,15569.16%$ - Fixed Cost - - 36,000 32,35989.89% - Total$ -$ -$ 376,000$ 267,51471.15%$ - Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Dental Premium Equivilents $ -$ -$ 376,000$ 514,200136.76%$ - Other revenues - - - 166,433 - Total$ -$ -$ 376,000$ 680,633181.02%$ - Revenues over/(under) expenses$ 413,118$ - Cash and Investments CashNCCMTTotal May, 2015 $ 246,685$ -$ 246,685 April, 2015 $ 246,310$ -$ 246,310 March, 2015 $ 245,180$ -$ 245,180 February, 2015 $ 232,347$ -$ 232,347 January, 2015 $ 232,396$ -$ 232,396 December, 2014 $ 228,907$ -$ 228,907 November, 2014 $ 222,170$ -$ 222,170 October, 2014 $ 210,907$ -$ 210,907 September, 2014 $ 203,941$ -$ 203,941 August, 2014 $ 204,905$ -$ 204,905 July, 2014 $ 192,296$ -$ 192,296 June, 2014 $ -$ -$ - May, 2014 $ -$ -$ - Dental Paid Claims Summary Total Loss Premium MembershipRatioEquivalent Total EmployeesNet Paid ClaimsFixed Cost July, 2014 394627$ 8,037.30 $ 2,931.1435.39%$ 30,995.25 August, 2014 385630$ 24,414.70$ 2,940.4689.35%$ 30,617.32 September, 2014 385634$ 17,291.64$ 3,001.0465.30%$ 31,075.28 October, 2014 385620$ 21,705.01$ 2,945.1276.58%$ 32,188.24 November, 2014 396629$ 33,017.53$ 2,968.42113.18%$ 31,796.41 December, 2014 402637$ 19,850.70$ 2,665.5270.58%$ 31,903.44 January, 2015 399641$ 22,356.03$ 3,015.0279.67%$ 31,846.58 February, 2015 400638$ 21,769.70$ 2,973.0877.93%$ 31,748.36 March, 2015 399637$ 22,820.00$ 2,931.1481.07%$ 31,762.95 April, 2015 404640$ 29,386.27$ 3,005.70101.78%$ 31,824.26 May, 2015 399634$ 24,135.30$ 2,963.7682.83%$ 32,715.67 June, 2015 Year to Date395633$ 244,784.18$ 32,340.4079.53%$ 348,473.76 (membership = avg) 10 U:\\My Documents\\Monthly Reports\\2014 - 2015\\May 2015 - Financial Statements.xlsx