No preview available
HomeMy WebLinkAboutDecember 2014 - Financial Statements HARNETT COUNTY FINANCIAL SUMMARY REPORT December, 2014 GENERAL FUND FYE 2015 Activity 2014 - 2015 Total Adjusted (includes Percent Same Period Budgetencumbrances)to DateLast Fiscal Year DepartmentFYE 2013FYE 2014 Governing Body $ 180,854 $ 164,631 $ 188,313 $ 149,295 79.28% $ 145,465 Administration 339,722 250,759 295,629 228,262 77.21% 169,752 Legal Services 122,070 103,351 119,294 148,233 137,214 124.26% Engineering - 1 - 28,076 23,431 Human Resources 224,821 254,738 272,012 160,522 59.01% 132,030 Board of Elections 357,108 303,532 358,674 190,116 53.01% 141,590 Finance 961,984 729,469 877,297 509,275 58.05% 442,577 Clerk of Court 98,086 77,704 89,554 43,390 48.45% 42,180 Tax 1,664,758 1,569,231 1,741,896 757,606 43.49% 741,033 General Services 473,759 140,485 153,902 76,294 49.57% 57,758 Fleet Maintenance - 438,847 700,730 267,500 38.17% - Transportation 940,206 1,004,266 1,381,801 301,770 21.84% 300,990 Transportation - Admin 188,721 194,790 219,108 79,142 36.12% 80,100 Facilities Maintenance 3,285,478 3,400,887 4,184,554 1,460,938 34.91% 1,262,457 Register of Deeds 761,273 730,166 813,812 355,750 43.71% 309,858 Information Technology 1,256,973 1,301,628 1,776,660 990,699 55.76% 719,772 GIS 440,731 432,327 448,798 198,271 44.18% 190,902 Sheriff 9,344,007 10,166,283 10,603,575 4,707,118 44.39% 4,672,422 Campbell Deputies 357,903 354,232 433,165 194,939 45.00% 160,722 Harnett CJPP 53,836 80,119 - - 29,549 Sheriff's Department Grants 38,810 15,213 25,615 1,607 6.27% - Child Support Enforcement 67,192 66,257 77,977 34,722 44.53% 27,607 Governor's Highway Safety 112,332 26,536 - - 500 Life is Fragile (NCGCC) 29,531 - - - - Communications 1,116,529 1,219,142 1,549,815 588,482 37.97% 466,702 Jail 4,187,264 4,306,490 4,886,316 2,138,762 43.77% 1,777,912 Emergency Services 712,960 737,021 808,957 350,708 43.35% 320,990 Emergency Services Grant 1,000 32,000 - - 31,550 Emergency Medical Service 4,179,979 3,991,897 4,056,454 1,887,495 46.53% 3,353,916 EMS Transport 960,370 1,083,318 1,197,127 488,857 40.84% 453,747 Rescue Districts 3,225,144 3,314,704 3,361,704 1,960,994 58.33% - Animal Services 381,748 376,744 476,149 186,844 39.24% 146,820 Medical Examiner 40,200 50,000 65,000 26,900 41.38% 20,550 JCPC Admin - - 5,000 465 9.30% - Public Safety Appropriations 126,278 124,334 79,429 41,462 52.20% 65,434 Emergency Telephone System 243,460 240,521 258,736 124,913 48.28% 106,927 Radio System 474,341 300,204 302,100 98,482 32.60% 170,338 Harnett Regional Jetport 179,592 174,955 205,244 99,242 48.35% 87,815 Soil & Water 119,598 124,133 175,754 67,449 38.38% 46,224 Environmental Protection 4,000 4,000 14,000 4,000 28.57% 4,000 Forestry Program 113,334 114,849 114,992 43,572 37.89% - Economic/Physical Dev. App. 1,509,397 449,748 595,500 167,253 28.09% 163,177 Industrial Development 1,462,725 776,301 884,353 404,461 45.74% 220,003 Planning & Inspections 1,437,604 1,321,571 1,385,295 645,252 46.58% 576,333 Community Development (BG) - 1,129 1,300 139 10.69% 235 Abandoned MFG Home - 31,903 48,233 18,372 38.09% - Cooperative Extension 427,644 351,557 426,582 113,953 26.71% 150,460 CCR&R - Block Grant 27,369 31,419 33,673 15,659 46.50% 10,418 CCR&R - United Way - 2,483 2,678 298 11.13% 256 Parents As Teachers 226,262 158,263 59,500 16,268 27.34% 65,082 Adolescent Parenting 60,003 59,107 60,000 30,276 50.46% 21,256 U:\\My Documents\\Monthly Reports\\2014 - 2015\\December 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT December, 2014 GENERAL FUND FYE 2015 Activity 2014 - 2015 Total Adjusted (includes Percent Same Period Budgetencumbrances)to DateLast Fiscal Year DepartmentFYE 2013FYE 2014 CCR&R - Smart Start 17,922 - - - - 4-H Teen Court & At Risk 30,804 45,686 49,773 19,999 40.18% 15,573 Child Care Youth Training - 27,367 17,897 - 0.00% 9,918 Race to the Top - 13,570 27,775 8,276 29.80% 6,174 Adolescent Parenting - 3,789 - - 3,789 Department on Aging 293,761 283,332 314,750 137,422 43.66% 139,523 Family Caregiver Support 38,363 51,769 61,146 29,878 48.86% 24,674 RSVP 72,852 73,276 77,705 37,807 48.65% 31,097 CAP - Disabled Adults 291,181 326,783 331,970 160,021 48.20% 139,821 Nutrition for Elderly 405,545 378,087 432,711 190,611 44.05% 172,364 Health 5,932,196 5,787,018 7,391,480 2,766,784 37.43% 2,403,738 Mental Health 615,679 815,679 605,679 302,840 50.00% 502,840 Social Services 9,418,756 9,359,396 10,381,679 4,559,484 43.92% 4,026,134 Public Assistance 7,944,608 7,829,453 9,721,093 3,589,903 36.93% 3,433,768 Veteran's Services 166,579 172,197 176,245 87,171 49.46% 71,521 Restitution 127,765 110,369 120,868 52,951 43.81% 46,551 Human Services App. 174,635 99,840 99,000 75,298 76.06% 74,713 Library 881,506 928,107 1,082,480 446,283 41.23% 427,273 Cultural & Recreational App. 167,000 100,000 150,000 - 0.00% 100,000 Parks & Recreation 319,254 363,011 436,081 196,011 44.95% 159,253 Education Board of Education - current 20,288,004 20,523,700 21,523,700 10,761,850 50.00% 10,261,850 Board of Education - capital - - - - - Central Carolina - current 638,841 927,711 917,467 458,734 50.00% 463,857 Central Carolina - capital 23,973 - - - - Central Carolina - works - 25,000 25,000 - 0.00% - 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 9,737,067 64.12% 8,818,716 Contingency - - - - - Total$ 102,308,383 $ 105,234,405 $ 114,989,299 $ 54,049,14047.00%$ 49,417,867 2014 - 2015 Total Adjusted Percent FYE 2015 Same Period BudgetActivityto DateLast Fiscal Year Revenues:FYE 2013FYE 2014 Ad Valorem Taxes Real and Personal$ 54,273,480$ 54,120,822$ 52,510,671$ 39,058,77574.38%$ 37,376,500 Motor Vehicles - 3,949,979 5,340,855 2,291,76342.91% 583,951 Sales Tax 14,238,193 14,884,497 14,980,744 3,267,34421.81% 2,995,666 Other taxes 1,010,549 1,037,719 1,200,000 406,536 33.88% 415,261 Permits & Fees 3,089,188 2,763,205 2,927,767 971,054 33.17% 1,102,059 Intergovernmental Revenue 20,204,388 19,304,274 19,939,425 6,440,65732.30% 5,363,077 Sales & Services 9,422,096 7,658,151 9,694,505 2,977,23830.71% 2,753,692 Other Revenues 2,902,980 3,451,519 3,789,373 1,237,99332.67% 677,863 Rents, Concessions. & Fees 83,870 77,898 84,251 24,60829.21% 11,349 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,579,167 - 0.00% - Total$ 106,623,629 $ 108,566,559 $ 114,989,299 $ 56,679,86449.29%$ 51,279,418 Revenues over/(under) expenditures$ 2,630,724 1,861,551 U:\\My Documents\\Monthly Reports\\2014 - 2015\\December 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT December, 2014 GENERAL FUND Cash and Investments CashTax LockboxMBSNCCMTTotal 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 January, 2014$ 17,860,088$ 27,845 $ -$ 15,963,619$ 33,851,552 December, 2013$ 10,145,781$ 27,845 $ -$ 14,551,933$ 24,725,559 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 This classification includes amounts that cannot be spent because they are either (a) not in spendable Non-Spendable Fund Balance - The classification includes amount that are restricted to specific purposes externally imposed by Restricted Fund Balance - This classification represents the portion of fund balance that can only be used for specific purposes Committed Fund Balance - That portion of fund balance that the County intends to use for specific purposes. The County Assigned Fund Balance - This classification represents the portion of fund balance that has not been assigned to another fund or Unassigned Fund Balance - U:\\My Documents\\Monthly Reports\\2014 - 2015\\December 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT December, 2014 GENERAL FUND Unassigned Fund Balance at June 30, 2014$ 18,732,09517.90% Unaudited 06/30/2014 Revenues over/(under) Expenditures Year to Date Revenues over/(under) Expenditures 2,630,724 21,362,819 Remaining Debt Payments for this Year (5,448,142) Outstanding budget amendments - Year to Date Fund Balance Appropriated (3,579,167) (9,027,309) IftheCountyweretostopoperationsattheendofthismonthandhad $ 12,335,510 nofurtherreceivablesorpayables,thenthiswouldbetheestimated fund balance amount and its percentage of expenditures. 10.73% Amount by which fund balance percentage will change$ 1,149,893 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\\December 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT December, 2014 PUBLIC UTILITIES FUND FYE 2015 Activity 2014 - 2015 Total Adjusted (includes Percent Same Period Budgetencumbrances)to DateLast Fiscal Year DepartmentFYE 2013FYE 2014 Admin/CSR/Meter Services$ 37,598,026$ 19,229,033$ 15,732,723$ 6,639,72442.20%$ 2,649,888 Water Treatment 3,571,705 3,671,291 4,397,498 1,399,98631.84% 1,368,761 Wastewater Treatment 1,790,807 1,965,319 2,349,238 861,750 36.68% 726,899 Wastewater Treatment SHWW 1,358,206 1,860,402 2,336,717 741,690 31.74% 607,094 Distribution 3,349,268 3,383,463 4,167,901 1,726,25041.42% 1,250,023 Collections 3,056,462 2,975,052 3,486,170 1,321,06837.89% 1,052,735 Total$ 50,724,474$ 33,084,560$ 32,470,247$ 12,690,46839.08%$ 7,655,400 2014 - 2015 Total Adjusted Percent FYE 2015 Same Period BudgetActivityto DateLast Fiscal Year Revenues:FYE 2013FYE 2014 Intergovernmental Revenue$ 3,703$ 3,703$ 3,600$ -0.00%$ - Sales & Services 27,670,467 30,275,723 26,921,865 14,916,87655.41%$12,491,218 Other Revenues 4,934,826 13,281,536 1,788,900 527,638 29.50%$142,686 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 - 650,100 - Fund Balance Appropriated - - 3,750,882 - 0.00% - Total$ 52,679,527$ 44,184,741$ 32,470,247$ 17,534,94354.00%$ 12,633,904 Revenues over/(under) expenses$ 4,844,475$ 4,978,504 Cash and Investments CashLockboxNCCMTTotal 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 January, 2014$ 21,428,607$ -$ 455,673$ 21,884,280 December, 2013$ 19,879,494$ -$ 454,890$ 20,334,384 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\\December 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT December, 2014 SOLID WASTE FUND FYE 2015 Activity 2014 - 2015 Total Adjusted (includes Percent Same Period Budgetencumbrances)to DateLast Fiscal Year DepartmentFYE 2013FYE 2014 Solid Waste$ 5,073,308$ 5,161,897$ 5,604,969$ 1,880,89233.56%$ 2,306,847 Total$ 5,073,308$ 5,161,897$ 5,604,969$ 1,880,89233.56%$ 2,306,847 2014 - 2015 Total Adjusted Percent FYE 2015 Same Period BudgetActivityto DateLast Fiscal Year Revenues:FYE 2013FYE 2014 Taxes$ 227,228$ 237,297$ 259,000$ 59,931 23.14%$ 69,042 Intergovernmental Revenue - - 154,500 - - Sales & Services 4,776,288 5,006,315 5,097,390 3,216,07063.09% 3,023,162 Other Revenues 638,962 378,116 2,400 1,07144.63% 2,070 Rents, Concess. & Feees 430 243 - 75 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$ 3,277,14758.47%$ 3,834,051 Revenues over/(under) expenses$ 1,396,255$ 1,527,204 Cash and Investments CashSun TrustFirst BankNCCMTTotal 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 January, 2014$ 1,206,501$ 94,942 $ 110,849$ 127,968$ 1,540,260 December, 2013$ 462,549$ 77,362 $ 102,262$ 127,968$ 770,141 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\\December 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT December, 2014 WORKER'S COMPENSATION FUND FYE 2015 Activity 2014 - 2015 Total Adjusted (includes Percent Same Period Budgetencumbrances)to DateLast Fiscal Year CategoryFYE 2013FYE 2014 Claims Funded$ -$ -$ 1,250,000$ 395,06431.61%$ 772,945 Fixed Cost - - - - 1,000 Total$ -$ -$ 1,250,000$ 395,064$ 773,945 31.61% 2014 - 2015 Total Adjusted Percent FYE 2015 FYE 2015 BudgetActivityto DateActivity Revenues:FYE 2013FYE 2014 Departmental Charge$ -$ -$ 1,000,000$ 438,97543.90%$ 852,411 Other revenues - - 250,000 74,53229.81% 197,867 Fund Balance Appropriated - - - - - Total$ -$ -$ 1,250,000$ 513,50741.08%$ 1,050,277 Revenues over/(under) expenses$ 118,443$ 276,332 Loss Ratio90.00% Cash and Investments CashNCCMTTotal 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 January, 2014$ 38,472 $ -$ 38,472 December, 2013$ 380,230$ -$ 380,230 Liability Liability as of July 1$ 3,189,117 # of Claims this 30 Current year claims and fiscal year changes in estimates 70,848 Actual claim payments 17,003 Liability as of end of month$ 3,242,962 U:\\My Documents\\Monthly Reports\\2014 - 2015\\December 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT December, 2014 MEDICAL INSURANCE FUND FYE 2015 Activity 2014 - 2015 Total Adjusted (includes Percent Same Period Budgetencumbrances)to DateLast Fiscal Year CategoryFYE 2013FYE 2014 Paid Claims$ -$ -$ 5,480,000$ 1,947,46435.54%$ - Fixed Cost - - 647,000 314,787 48.65% - Total$ -$ -$ 6,127,000$ 2,262,251$ - 36.92% 2014 - 2015 Total Adjusted Percent FYE 2015 FYE 2015 BudgetActivityto DateActivity Revenues:FYE 2013FYE 2014 Medical Premiums$ -$ -$ 6,127,000$ 3,503,58057.18%$ - Other revenues - - - 10,783 - Fund Balance Appropriated - - - - - Total$ -$ -$ 6,127,000$ 3,514,36357.36%$ - Revenues over/(under) expenses$ 1,252,112$ - Loss Ratio64.57% Cash and Investments CashNCCMTTotal 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$ -$ -$ - January, 2014$ -$ -$ - December, 2013$ -$ -$ - U:\\My Documents\\Monthly Reports\\2014 - 2015\\December 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT December, 2014 DENTAL INSURANCE FUND FYE 2015 Activity 2014 - 2015 Total Adjusted (includes Percent Same Period Budgetencumbrances)to DateLast Fiscal Year CategoryFYE 2013FYE 2014 Paid Claims$ -$ -$ 340,000$ 107,94331.75%$ - Fixed Cost - - 36,000 17,45248.48% - Total$ -$ -$ 376,000$ 125,394$ - 33.35% 2014 - 2015 Total Adjusted Percent FYE 2015 FYE 2015 BudgetActivityto DateActivity Revenues:FYE 2013FYE 2014 Dental Premiums$ -$ -$ 376,000$ 187,86949.97%$ - Other revenues - - - 166,433 - Fund Balance Appropriated - - - - - Total$ -$ -$ 376,000$ 354,30294.23%$ - Revenues over/(under) expenses$ 228,907$ - Loss Ratio66.75% Cash and Investments CashNCCMTTotal 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$ -$ -$ - January, 2014$ -$ -$ - December, 2013$ -$ -$ - U:\\My Documents\\Monthly Reports\\2014 - 2015\\December 2014 - Financial Statements.xlsx