No preview available
HomeMy WebLinkAboutApril 2015 - Financial Statements HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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 $ 222,842 $ 94,204 42.27% $ 99,435 Administration 339,722 250,759 305,357 190,009 62.23% 162,062 Legal Services 122,070 103,351 120,401 (33,954) 40,622 -28.20% Engineering - 1 2,140 45,648 ####### (15,853) Human Resources 224,821 254,738 282,017 176,733 62.67% 197,234 Board of Elections 357,108 303,532 364,857 264,333 72.45% 230,849 Finance 961,984 729,469 891,894 573,431 64.29% 540,960 Clerk of Court 98,086 77,704 89,554 67,847 75.76% 68,641 Tax 1,664,758 1,569,231 1,782,024 1,160,262 65.11% 1,320,001 General Services 473,759 140,485 158,765 124,437 78.38% 113,964 Fleet Maintenance - 438,847 706,002 467,377 66.20% - Transportation 940,206 1,004,266 1,275,021 625,740 49.08% 666,332 Transportation - Admin 188,721 194,790 224,152 169,686 75.70% 155,182 Facilities Maintenance 3,285,478 3,400,887 4,205,536 2,477,522 58.91% 2,356,908 Register of Deeds 761,273 730,166 830,612 558,287 67.21% 602,776 Information Technology 1,256,973 1,301,628 1,841,232 1,424,465 77.36% 1,088,733 GIS 440,731 432,327 463,211 343,473 74.15% 360,478 Sheriff 9,344,007 10,166,283 10,874,786 8,052,986 74.05% 8,421,187 Campbell Deputies 357,903 354,232 444,887 317,630 71.40% 296,105 Harnett CJPP 53,836 80,119 - - 63,591 Sheriff's Department Grants 38,810 15,213 25,615 1,607 6.27% - Child Support Enforcement 67,192 66,257 80,227 56,537 70.47% 55,247 Governor's Highway Safety 112,332 26,536 - - 27,036 Life is Fragile (NCGCC) 29,531 - - - - Communications 1,116,529 1,219,142 1,596,653 1,115,462 69.86% 936,982 Jail 4,187,264 4,306,490 4,983,521 3,510,990 70.45% 3,461,015 Emergency Services 712,960 737,021 832,315 577,329 69.36% 605,292 Emergency Services Grant 1,000 32,000 - - 32,000 Emergency Medical Service 4,179,979 3,991,897 4,210,715 3,088,306 73.34% 3,237,064 EMS Transport 960,370 1,083,318 1,187,036 829,996 69.92% 835,501 Rescue Districts 3,225,144 3,314,704 3,361,704 2,801,421 83.33% 2,762,254 Animal Services 381,748 376,744 486,818 323,085 66.37% 297,785 Medical Examiner 40,200 50,000 65,000 38,600 59.38% 38,500 JCPC Admin - - 5,000 2,390 47.80% - Public Safety Appropriations 126,278 124,334 79,766 66,714 83.64% 104,891 Emergency Telephone System 243,460 240,521 264,951 196,094 74.01% 200,738 Radio System 474,341 300,204 302,100 174,873 57.89% 265,816 Harnett Regional Jetport 179,592 174,955 222,804 129,797 58.26% 155,103 Soil & Water 119,598 124,133 181,873 126,034 69.30% 100,298 Environmental Protection 4,000 4,000 14,000 4,000 28.57% 4,000 Forestry Program 113,334 114,849 114,992 76,455 66.49% 95,427 Economic/Physical Dev. App. 1,509,397 449,748 595,500 334,833 56.23% 328,261 Industrial Development 1,462,725 776,301 897,382 757,433 84.40% 775,895 Planning & Inspections 1,437,604 1,321,571 1,423,500 1,013,371 71.19% 1,069,243 Community Development (BG) - 1,129 1,300 309 23.77% 1,162 Abandoned MFG Home - 31,903 70,005 40,506 57.86% 26,290 Cooperative Extension 427,644 351,557 431,453 200,368 46.44% 267,923 CCR&R - Block Grant 27,369 31,419 34,623 22,810 65.88% 22,807 CCR&R - United Way - 2,483 2,978 341 11.45% 1,181 Parents As Teachers 226,262 158,263 59,500 32,455 54.55% 131,070 Adolescent Parenting 60,003 59,107 62,488 50,466 80.76% 47,413 U:\\My Documents\\Monthly Reports\\2014 - 2015\\April 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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 37,159 73.07% 33,000 Child Care Youth Training - 27,367 - - 17,194 Race to the Top - 13,570 28,409 13,924 49.01% 11,660 Adolescent Parenting - 3,789 - - 3,789 Department on Aging 293,761 283,332 319,984 235,319 73.54% 226,782 Family Caregiver Support 38,363 51,769 64,295 50,328 78.28% 45,848 RSVP 72,852 73,276 79,902 61,607 77.10% 60,819 CAP - Disabled Adults 291,181 326,783 341,626 266,398 77.98% 271,554 Nutrition for Elderly 405,545 378,087 434,767 314,364 72.31% 283,467 Health 5,932,196 5,787,018 7,607,728 4,711,069 61.92% 4,581,065 Mental Health 615,679 815,679 605,679 605,679 100.00% 615,679 Social Services 9,418,756 9,359,396 10,671,648 7,762,157 72.74% 7,726,551 Public Assistance 7,944,608 7,829,453 8,723,337 6,376,631 73.10% 6,260,560 Veteran's Services 166,579 172,197 182,079 143,392 78.75% 141,145 Restitution 127,765 110,369 117,214 80,655 68.81% 88,065 Human Services App. 174,635 99,840 99,000 75,298 76.06% 84,358 Library 881,506 928,107 1,103,474 752,543 68.20% 731,238 Cultural & Recreational App. 167,000 100,000 150,000 - 0.00% 100,000 Parks & Recreation 319,254 363,011 449,547 299,583 66.64% 274,707 Education Board of Education - current 20,288,004 20,523,700 21,523,700 17,936,417 83.33% 17,103,083 Board of Education - capital - - - - - Central Carolina - current 638,841 927,711 917,467 764,556 83.33% 773,093 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 26,667 46.17% 36,667 Debt Service 11,486,712 13,902,144 15,185,209 15,110,901 99.51% 9,586,708 Contingency - - - - - Total $ 102,308,383 $ 105,234,405 $ 115,417,783$ 88,322,34576.52%$ 81,737,433 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,243,348101.40%$ 53,325,722 Motor Vehicles - 3,949,979 5,340,855 4,189,35378.44% 2,589,587 Sales Tax 14,238,193 14,884,497 14,980,744 10,332,71568.97% 7,553,492 Other taxes 1,010,549 1,037,719 1,200,000 678,760 56.56% 764,018 Permits & Fees 3,089,188 2,763,205 2,928,667 2,015,98368.84% 2,137,732 Intergovernmental Revenue 20,204,388 19,304,274 18,946,920 11,970,72163.18% 14,486,929 Sales & Services 9,422,096 7,658,151 9,747,780 5,392,63655.32% 5,435,624 Other Revenues 2,902,980 3,451,519 3,825,558 2,534,82666.26% 1,704,469 Rents, Concessions. & Fees 83,870 77,898 84,251 52,72862.58% 58,215 Other Finance Sources 960,622 857,548 450,000 3,8960.87% - Interfund Transfers 438,263 460,947 492,541 - 0.00% 5,947 Fund Balance Appropriated - - 4,909,796 - 0.00% - Total $ 106,623,629 $ 108,566,559 $ 115,417,783$ 90,414,96678.34%$ 88,061,735 Revenues over/(under) expenditures $ 2,092,621 6,324,302 U:\\My Documents\\Monthly Reports\\2014 - 2015\\April 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 2015 GENERAL FUND Cash and Investments CashTax LockboxMBSNCCMTTotal 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 April, 2014 $ 12,798,914$ 27,888 $ -$ 20,164,065$ 32,990,868 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\\April 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 2015 GENERAL FUND Unassigned Fund Balance at June 30, 2014$ 18,732,09517.90% Year to Date Revenues over/(under) Expenditures 2,092,621 20,824,716 Remaining Debt Payments for this Year (74,308) Outstanding budget amendments - Year to Date Fund Balance Appropriated (4,909,796) (4,984,104) If the County were to stop operations at the end of this month and had $ 15,840,612 no further receivables or payables, then this would be the estimated fund balance amount and its percentage of expenditures. 13.72% Amount by which fund balance percentage will change$ 1,154,178 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\\April 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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,122,002$ 18,649,95777.32%$ 6,939,643 Water Treatment 3,571,705 3,671,291 4,460,918 2,825,61163.34% 2,734,978 Wastewater Treatment 1,790,807 1,965,319 2,355,225 1,452,72761.68% 1,430,956 Wastewater Treatment SHWW 1,358,206 1,860,402 2,331,404 1,388,66459.56% 1,408,407 Distribution 3,349,268 3,383,463 4,235,854 2,918,42368.90% 2,669,937 Collections 3,056,462 2,975,052 3,545,154 2,302,65464.95% 2,232,687 Total$ 50,724,474$ 33,084,560$ 41,050,557$ 29,538,03671.96%$ 17,416,608 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 23,163,56586.04% 22,874,877 Other Revenues 4,934,826 13,281,536 1,788,900 2,368,537132.40% 685,614 Rents, Concess. & Feees 5,531 96 5,000 140.28% - Other Finance Sources 20,065,000 473,683 - 1,440,312 - Interfund Transfers - 150,000 - 652,130 - Fund Balance Appropriated - - 12,331,192 - 0.00% - Total$ 52,679,527$ 44,184,741$ 41,050,557$ 27,628,26167.30%$ 23,564,194 Revenues over/(under) expenses$ (1,909,775)$ 6,147,586 Cash and Investments CashLockboxNCCMTTotal 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 April, 2014 $ 24,890,282$ -$ 505,012$ 25,395,294 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\\April 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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,634,041$ 3,805,42067.54%$ 3,755,646 Total$ 5,073,308$ 5,161,897$ 5,634,041$ 3,805,42067.54%$ 3,755,646 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,537 Intergovernmental Revenue - - 154,500 - - Sales & Services 4,776,288 5,006,315 5,097,390 4,687,18091.95% 4,432,017 Other Revenues 638,962 378,116 2,400 263,563 106,305 10981.79% Rents, Concess. & Feees 430 243 - 119 69 Other Finance Sources 582,662 739,763 - - 739,763 Interfund Transfers - - - - - Fund Balance Appropriated - - 120,751 - 0.00% - Total$ 6,225,570$ 6,361,734$ 5,634,041$ 5,069,79989.99%$ 5,409,691 Revenues over/(under) expenses$ 1,264,379$ 1,654,045 Cash and Investments CashSun TrustFirst BankNCCMTTotal 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 April, 2014 $ 517,264$ 144,082$ 159,723$ 190,383$ 1,011,453 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\\April 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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$ 402,06432.17%$ 1,129,945 Fixed Cost - - - - 1,000 Total$ -$ -$ 1,250,000$ 402,064$ 1,130,945 32.17% Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Departmental Charge $ -$ -$ 1,000,000$ 737,30773.73%$ 1,420,685 Other revenues - - 250,000 164,157 65.66% 255,269 Fund Balance Appropriated - - - - - Total$ -$ -$ 1,250,000$ 901,46472.12%$ 1,675,954 Revenues over/(under) expenses$ 499,400$ 545,009 Cash and Investments CashNCCMTTotal 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 April, 2014$ 80,633 $ -$ 80,633 Liability Liability as of July 1$ 3,189,117 # of Claims this 51 Current year claims and 83,820 fiscal year changes in estimates Actual claim payments 48,701 Liability as of end of month$ 3,224,236 U:\\My Documents\\Monthly Reports\\2014 - 2015\\April 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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$ 95,363 35.49%$ 34,025 Total$ -$ -$ 268,667$ 95,363 $ 34,025 35.49% Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Departmental Charge $ -$ -$ 268,667$ 190,25070.81%$ 235,820 Other revenues - - - - - Fund Balance Appropriated - - - - - Total$ -$ -$ 268,667$ 190,25070.81%$ 235,820 Revenues over/(under) expenses$ 94,887 $ 201,795 Cash and Investments CashNCCMTTotal 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 April, 2014$ 187,542$ -$ 187,542 U:\\My Documents\\Monthly Reports\\2014 - 2015\\April 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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$ 3,740,39368.26%$ - Fixed Cost - - 634,000 632,507 99.76% - Wellness - - 13,000 13,000100.00% - Total$ -$ -$ 6,127,000$ 4,385,899$ - 71.58% Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Medical Premium Equivilents $ -$ -$ 6,127,000$ 5,618,13191.69%$ - Other revenues - - - 10,783 - Total$ -$ -$ 6,127,000$ 5,628,91491.87%$ - Revenues over/(under) expenses$ 1,243,014$ - Cash and Investments CashNCCMTTotal 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 $ -$ -$ - April, 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 June, 2015 Year to Date7991,134$ 3,760,965.66$ 548,157.3281.91%$ 5,260,662.64 (membership = avg) U:\\My Documents\\Monthly Reports\\2014 - 2015\\April 2015 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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$ 205,82160.54%$ - Fixed Cost - - 36,000 29,35381.54% - Total$ -$ -$ 376,000$ 235,174$ - 62.55% Total Percent 2014 - 2015 FYE 2015 Same Period Revenues: Adjusted BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Dental Premium Equivilents $ -$ -$ 376,000$ 481,484128.05%$ - Other revenues - - - 166,433 - Total$ -$ -$ 376,000$ 647,917172.32%$ - Revenues over/(under) expenses$ 412,743$ - Cash and Investments CashNCCMTTotal 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 $ -$ -$ - April, 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 June, 2015 Year to Date395633$ 220,648.88$ 29,376.6479.18%$ 315,758.09 (membership = avg) U:\\My Documents\\Monthly Reports\\2014 - 2015\\April 2015 - Financial Statements.xlsx