No preview available
HomeMy WebLinkAboutFebruary 2015 - Financial Statements HARNETT COUNTY FINANCIAL SUMMARY REPORT February, 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 $ 188,313 $ 185,131 98.31% $ 185,760 Administration 339,722 250,759 295,629 290,034 98.11% 265,567 Legal Services 122,070 103,351 119,294 169,304 214,455 141.92% Engineering - 1 - 37,582 37,497 Human Resources 224,821 254,738 272,012 209,554 77.04% 210,463 Board of Elections 357,108 303,532 358,674 232,862 64.92% 177,921 Finance 961,984 729,469 859,797 691,873 80.47% 680,411 Clerk of Court 98,086 77,704 89,554 55,021 61.44% 57,495 Tax 1,664,758 1,569,231 1,741,896 983,995 56.49% 1,121,037 General Services 473,759 140,485 153,902 100,683 65.42% 91,616 Fleet Maintenance - 438,847 700,730 382,026 54.52% - Transportation 940,206 1,004,266 1,268,801 414,229 32.65% 556,611 Transportation - Admin 188,721 194,790 219,108 114,246 52.14% 121,029 Facilities Maintenance 3,285,478 3,400,887 4,184,554 1,979,593 47.31% 1,864,948 Register of Deeds 761,273 730,166 813,812 460,062 56.53% 510,597 Information Technology 1,256,973 1,301,628 1,794,160 1,251,811 69.77% 1,050,722 GIS 440,731 432,327 448,798 269,548 60.06% 290,179 Sheriff 9,344,007 10,166,283 10,603,575 6,260,069 59.04% 6,951,936 Campbell Deputies 357,903 354,232 433,165 252,686 58.33% 242,154 Harnett CJPP 53,836 80,119 - - 46,448 Sheriff's Department Grants 38,810 15,213 25,615 1,607 6.27% - Child Support Enforcement 67,192 66,257 77,977 45,765 58.69% 44,184 Governor's Highway Safety 112,332 26,536 - - 27,036 Life is Fragile (NCGCC) 29,531 - - - - Communications 1,116,529 1,219,142 1,549,815 819,063 52.85% 751,588 Jail 4,187,264 4,306,490 4,886,316 2,797,677 57.26% 2,775,536 Emergency Services 712,960 737,021 811,383 461,948 56.93% 481,435 Emergency Services Grant 1,000 32,000 - - 31,550 Emergency Medical Service 4,179,979 3,991,897 4,094,756 2,508,099 61.25% 4,853,988 EMS Transport 960,370 1,083,318 1,162,325 651,315 56.04% 677,704 Rescue Districts 3,225,144 3,314,704 3,361,704 2,241,136 66.67% - Animal Services 381,748 376,744 476,149 254,744 53.50% 232,007 Medical Examiner 40,200 50,000 65,000 29,650 45.62% 26,500 JCPC Admin - - 5,000 1,622 32.44% - Public Safety Appropriations 126,278 124,334 79,766 48,027 60.21% 86,483 Emergency Telephone System 243,460 240,521 258,736 158,481 61.25% 157,157 Radio System 474,341 300,204 302,100 137,660 45.57% 233,699 Harnett Regional Jetport 179,592 174,955 205,244 125,390 61.09% 125,718 Soil & Water 119,598 124,133 175,754 97,060 55.22% 78,461 Environmental Protection 4,000 4,000 14,000 4,000 28.57% 4,000 Forestry Program 113,334 114,849 114,992 58,311 50.71% 56,387 Economic/Physical Dev. App. 1,509,397 449,748 595,500 227,267 38.16% 258,699 Industrial Development 1,462,725 776,301 884,353 496,501 56.14% 370,984 Planning & Inspections 1,437,604 1,321,571 1,385,295 845,611 61.04% 888,545 Community Development (BG) - 1,129 1,300 257 19.77% 981 Abandoned MFG Home - 31,903 68,733 29,732 43.26% - Cooperative Extension 427,644 351,557 426,582 159,851 37.47% 207,435 CCR&R - Block Grant 27,369 31,419 33,673 20,358 60.46% 17,872 CCR&R - United Way - 2,483 2,878 299 10.39% 1,015 Parents As Teachers 226,262 158,263 59,500 24,372 40.96% 105,141 Adolescent Parenting 60,003 59,107 60,000 40,379 67.30% 36,709 U:\\My Documents\\Monthly Reports\\2014 - 2015\\February 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT February, 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 49,773 27,799 55.85% 25,057 Child Care Youth Training - 27,367 17,897 - 0.00% 14,362 Race to the Top - 13,570 27,775 12,375 44.55% 9,180 Adolescent Parenting - 3,789 - - 3,789 Department on Aging 293,761 283,332 314,750 184,672 58.67% 191,020 Family Caregiver Support 38,363 51,769 61,656 40,663 65.95% 37,932 RSVP 72,852 73,276 77,705 48,893 62.92% 47,449 CAP - Disabled Adults 291,181 326,783 331,970 214,525 64.62% 217,751 Nutrition for Elderly 405,545 378,087 432,711 252,236 58.29% 225,832 Health 5,932,196 5,787,018 7,412,987 3,669,182 49.50% 3,615,671 Mental Health 615,679 815,679 605,679 454,259 75.00% 564,259 Social Services 9,418,756 9,359,396 10,381,679 6,096,896 58.73% 6,234,713 Public Assistance 7,944,608 7,829,453 9,721,093 5,062,433 52.08% 4,936,291 Veteran's Services 166,579 172,197 176,245 114,750 65.11% 112,078 Restitution 127,765 110,369 120,868 65,911 54.53% 70,186 Human Services App. 174,635 99,840 99,000 75,298 76.06% 84,358 Library 881,506 928,107 1,082,480 595,856 55.05% 619,120 Cultural & Recreational App. 167,000 100,000 150,000 - 0.00% 100,000 Parks & Recreation 319,254 363,011 436,981 243,453 55.71% 220,973 Education Board of Education - current 20,288,004 20,523,700 21,523,700 14,349,133 66.67% 13,682,467 Board of Education - capital - - - - - Central Carolina - current 638,841 927,711 917,467 611,645 66.67% 618,474 Central Carolina - capital 23,973 - - - - Central Carolina - works - 25,000 25,000 - 0.00% 25,000 Interfund Transfers 455,491 1,903,876 43,334 26,667 61.54% 36,667 Debt Service 11,486,712 13,902,144 15,185,209 10,345,384 68.13% 8,856,474 Contingency - - - - - Total $ 102,308,383 $ 105,234,405 $ 114,926,179$ 69,118,52160.14%$ 67,756,763 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$ 51,562,08698.19%$ 50,953,191 Motor Vehicles - 3,949,979 5,340,855 2,759,43651.67% 1,679,413 Sales Tax 14,238,193 14,884,497 14,980,744 5,805,66038.75% 4,093,544 Other taxes 1,010,549 1,037,719 1,200,000 501,490 41.79% 529,768 Permits & Fees 3,089,188 2,763,205 2,928,667 1,403,09247.91% 1,680,291 Intergovernmental Revenue 20,204,388 19,304,274 19,960,633 8,504,66542.61% 9,387,362 Sales & Services 9,422,096 7,658,151 9,694,505 4,033,48341.61% 4,170,993 Other Revenues 2,902,980 3,451,519 3,800,194 2,098,19055.21% 1,270,849 Rents, Concessions. & Fees 83,870 77,898 84,251 40,11547.61% 15,844 Other Finance Sources 960,622 857,548 450,000 3,8960.87% - Interfund Transfers 438,263 460,947 492,541 - 0.00% - Fund Balance Appropriated - - 3,483,118 - 0.00% - Total $ 106,623,629 $ 108,566,559 $ 114,926,179$ 76,712,11366.75%$ 73,781,256 Revenues over/(under) expenditures $ 7,593,592 6,024,494 U:\\My Documents\\Monthly Reports\\2014 - 2015\\February 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT February, 2015 GENERAL FUND Cash and Investments CashTax LockboxMBSNCCMTTotal 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 April, 2014 $ 12,798,914$ 27,888 $ -$ 20,164,065$ 32,990,868 March, 2014 $ 14,373,115$ 27,887 $ -$ 18,787,339$ 33,188,341 February, 2014 $ 16,560,067$ 27,845 $ -$ 16,075,525$ 32,663,437 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. U:\\My Documents\\Monthly Reports\\2014 - 2015\\February 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT February, 2015 GENERAL FUND Unassigned Fund Balance at June 30, 2014$ 18,732,09517.90% Year to Date Revenues over/(under) Expenditures 7,593,592 26,325,687 Remaining Debt Payments for this Year (4,839,825) Outstanding budget amendments - Year to Date Fund Balance Appropriated (3,483,118) (8,322,943) IftheCountyweretostopoperationsattheendofthismonthandhad $ 18,002,744 nofurtherreceivablesorpayables,thenthiswouldbetheestimated fund balance amount and its percentage of expenditures. 15.66% Amount by which fund balance percentage will change$ 1,149,262 The County Board of Commissioners have approved a fund balance policy which strives to maintain a minimum fund balance of 15%. U:\\My Documents\\Monthly Reports\\2014 - 2015\\February 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT February, 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$ 20,482,723$ 12,171,15859.42%$ 4,028,964 Water Treatment 3,571,705 3,671,291 4,397,498 2,066,01546.98% 1,984,892 Wastewater Treatment 1,790,807 1,965,319 2,349,238 1,136,50648.38% 1,043,548 Wastewater Treatment SHWW 1,358,206 1,860,402 2,336,717 1,005,78843.04% 1,047,667 Distribution 3,349,268 3,383,463 4,187,901 2,276,00254.35% 1,905,671 Collections 3,056,462 2,975,052 3,516,170 1,686,96747.98% 1,616,290 Total$ 50,724,474$ 33,084,560$ 37,270,247$ 20,342,43654.58%$ 11,627,032 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 19,723,58773.26% 18,327,976 Other Revenues 4,934,826 13,281,536 1,788,900 1,091,03860.99% 347,888 Rents, Concess. & Feees 5,531 96 5,000 140.28% - Other Finance Sources 20,065,000 473,683 - 1,440,315 - Interfund Transfers - 150,000 - 652,130 - Fund Balance Appropriated - - 8,550,882 - 0.00% - Total$ 52,679,527$ 44,184,741$ 37,270,247$ 22,910,78761.47%$ 18,679,567 Revenues over/(under) expenses$ 2,568,351$ 7,052,535 Cash and Investments CashLockboxNCCMTTotal 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 April, 2014 $ 24,890,282$ -$ 505,012$ 25,395,294 March, 2014 $ 25,824,291$ -$ 497,945$ 26,322,236 February, 2014 $ 21,864,353$ -$ 458,673$ 22,323,026 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 U:\\My Documents\\Monthly Reports\\2014 - 2015\\February 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT February, 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$ 5,604,969$ 2,976,77353.11%$ 2,979,457 Total$ 5,073,308$ 5,161,897$ 5,604,969$ 2,976,77353.11%$ 2,979,457 Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Taxes $ 227,228$ 237,297$ 259,000$ 118,93745.92%$ 131,357 Intergovernmental Revenue - - 154,500 - - Sales & Services 4,776,288 5,006,315 5,097,390 4,166,73881.74% 3,950,909 Other Revenues 638,962 378,116 2,400 37,595 2,120 1566.46% Rents, Concess. & Feees 430 243 - 119 14 Other Finance Sources 582,662 739,763 - - 739,763 Interfund Transfers - - - - - Fund Balance Appropriated - - 91,679 - 0.00% - Total$ 6,225,570$ 6,361,734$ 5,604,969$ 4,323,38977.13%$ 4,824,163 Revenues over/(under) expenses$ 1,346,616$ 1,844,706 Cash and Investments CashSun TrustFirst BankNCCMTTotal 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 April, 2014 $ 517,264$ 144,082$ 159,723$ 190,383$ 1,011,453 March, 2014 $ 659,891$ 122,417$ 153,463$ 190,282$ 1,126,053 February, 2014 $ 929,101$ 98,860 $ 110,949$ 190,282$ 1,329,192 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 U:\\My Documents\\Monthly Reports\\2014 - 2015\\February 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT February, 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$ 395,06431.61%$ 1,122,945 Fixed Cost - - - - 1,000 Total$ -$ -$ 1,250,000$ 395,064$ 1,123,945 31.61% Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Departmental Charge $ -$ -$ 1,000,000$ 587,44458.74%$ 1,136,548 Other revenues - - 250,000 106,733 42.69% 218,092 Fund Balance Appropriated - - - - - Total$ -$ -$ 1,250,000$ 694,17755.53%$ 1,354,640 Revenues over/(under) expenses$ 299,113$ 230,695 Cash and Investments CashNCCMTTotal 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 April, 2014$ 80,633 $ -$ 80,633 March, 2014$ 43,455 $ -$ 43,455 February, 2014$ 50,455 $ -$ 50,455 Liability Liability as of July 1$ 3,189,117 # of Claims this 39 Current year claims and 115,991 fiscal year changes in estimates Actual claim payments 28,869 Liability as of end of month$ 3,276,239 U:\\My Documents\\Monthly Reports\\2014 - 2015\\February 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT February, 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 $ -$ -$ 265,036$ 71,817 27.10%$ 21,229 - - - - - Total$ -$ -$ 265,036$ 71,817 $ 21,229 27.10% Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Departmental Charge $ -$ -$ 265,036$ 151,72557.25%$ 169,120 Other revenues - - - - - Fund Balance Appropriated - - - - - Total$ -$ -$ 265,036$ 151,72557.25%$ 169,120 Revenues over/(under) expenses$ 79,908 $ 147,891 Cash and Investments CashNCCMTTotal 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 April, 2014$ 187,542$ -$ 187,542 March, 2014$ 194,710$ -$ 194,710 February, 2014$ 212,742$ -$ 212,742 U:\\My Documents\\Monthly Reports\\2014 - 2015\\February 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT February, 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$ 2,892,11152.78%$ - Fixed Cost - - 647,000 525,017 81.15% - Total$ -$ -$ 6,127,000$ 3,417,128$ - 55.77% Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Medical Premiums $ -$ -$ 6,127,000$ 4,561,64074.45%$ - Other revenues - - - 10,783 - Total$ -$ -$ 6,127,000$ 4,572,42374.63%$ - Revenues over/(under) expenses$ 1,155,295$ - Cash and Investments CashNCCMTTotal 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 $ -$ -$ - April, 2014 $ -$ -$ - March, 2014 $ -$ -$ - February, 2014 $ -$ -$ - Medical Paid Claims Summary Total Employees & Pre-65 Total Loss Premium RetireesMembershipRatioEquivalent Net Paid ClaimsFixed Cost July, 2014 7981,118$ 30,033.77$ 55,339.9516.38%$ 521,068.58 August, 2014 7901,116$ 388,159.19$ 54,574.1485.26%$ 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$ 622,315.74$ 55,402.91127.90%$ 529,863.38 December, 2014 8081,147$ 333,043.11$ 49,708.9172.04%$ 531,335.01 January, 2015 8071,151$ 487,295.69$ 58,029.65103.13%$ 528,795.73 February, 2015 8061,147$ 336,382.95$ 54,934.3873.94%$ 529,264.07 March, 2015 April, 2015 May, 2015 June, 2015 Year to Date7981,132$ 2,869,637.62$ 443,128.0378.80%$ 4,204,171.48 (membership = avg) U:\\My Documents\\Monthly Reports\\2014 - 2015\\February 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT February, 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$ 162,11047.68%$ - Fixed Cost - - 36,000 23,44065.11% - Total$ -$ -$ 376,000$ 185,550$ - 49.35% Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Dental Premiums $ -$ -$ 376,000$ 417,897111.14%$ - Other revenues - - - 166,433 - Total$ -$ -$ 376,000$ 584,330155.41%$ - Revenues over/(under) expenses$ 398,780$ - Cash and Investments CashNCCMTTotal 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 $ -$ -$ - April, 2014 $ -$ -$ - March, 2014 $ -$ -$ - February, 2014 $ -$ -$ - Dental Paid Claims Summary Total Employees & Pre-65 Total Loss Premium RetireesMembershipRatioEquivalent Net Paid ClaimsFixed Cost July, 2014 213627$ 8,037.30 $ 2,931.1435.39%$ 30,995.25 August, 2014 214630$ 24,414.70$ 2,940.4689.35%$ 30,617.32 September, 2014 216634$ 17,291.64$ 3,001.0465.30%$ 31,075.28 October, 2014 204620$ 21,705.01$ 2,945.1276.58%$ 32,188.24 November, 2014 210629$ 33,017.53$ 2,968.42113.18%$ 31,796.41 December, 2014 213637$ 19,850.70$ 2,665.5270.58%$ 31,903.44 January, 2015 211641$ 22,356.03$ 3,015.0279.67%$ 31,846.58 February, 2015 213641$ 21,769.70$ 2,973.0877.93%$ 31,748.36 March, 2015 April, 2015 May, 2015 June, 2015 Year to Date212632$ 168,442.61$ 23,439.8076.09%$ 252,170.88 (membership = avg) U:\\My Documents\\Monthly Reports\\2014 - 2015\\February 2015 - Financial Statements.xlsx