No preview available
HomeMy WebLinkAboutOctober 2014 - Financial Statements HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 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 $ 90,053 47.82% $ 87,965 Administration 339,722 250,759 295,629 153,021 51.76% 133,407 Legal Services 122,070 103,351 119,294 115,827 97.09% 106,496 Engineering - 1 - 18,714 18,810 Human Resources 224,821 254,738 272,012 104,909 38.57% 100,641 Board of Elections 357,108 303,532 358,674 104,920 29.25% 101,501 Finance 961,984 729,469 877,297 332,077 37.85% 342,090 Clerk of Court 98,086 77,704 89,554 31,654 35.35% 30,684 Tax 1,664,758 1,569,231 1,741,896 504,211 28.95% 529,795 General Services 473,759 140,485 153,902 49,625 32.24% 45,367 Fleet Maintenance - 438,847 700,730 183,551 26.19% - Transportation 940,206 1,004,266 1,391,237 179,442 12.90% 221,184 Transportation - Admin 188,721 194,790 219,108 50,184 22.90% 65,813 Facilities Maintenance 3,285,478 3,400,887 4,184,554 983,321 23.50% 971,934 Register of Deeds 761,273 730,166 813,812 189,444 23.28% 230,282 Information Technology 1,256,973 1,301,628 1,776,660 725,598 40.84% 602,542 GIS 440,731 432,327 448,798 129,046 28.75% 148,526 Sheriff 9,344,007 10,166,283 10,603,575 3,003,078 28.32% 3,302,953 Campbell Deputies 357,903 354,232 433,165 126,843 29.28% 120,122 Harnett CJPP 53,836 80,119 - - 22,125 Sheriff's Department Grants 38,810 15,213 25,615 - 0.00% - Child Support Enforcement 67,192 66,257 77,977 22,202 28.47% 21,552 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 387,317 24.99% 368,148 Jail 4,187,264 4,306,490 4,886,316 1,412,188 28.90% 1,390,849 Emergency Services 712,960 737,021 808,957 197,337 24.39% 252,374 Emergency Services Grant 1,000 32,000 - - 26,484 Emergency Medical Service 4,179,979 3,991,897 4,056,454 1,267,921 31.26% 2,479,233 EMS Transport 960,370 1,083,318 1,197,127 321,697 26.87% 361,339 Rescue Districts 3,225,144 3,314,704 3,361,704 1,400,710 41.67% - Animal Services 381,748 376,744 476,149 120,275 25.26% 114,565 Medical Examiner 40,200 50,000 65,000 16,800 25.85% 15,150 JCPC Admin - - 5,000 225 4.50% - Public Safety Appropriations 126,278 124,334 79,429 19,025 23.95% 30,215 Emergency Telephone System 243,460 240,521 258,736 81,467 31.49% 79,536 Radio System 474,341 300,204 302,100 71,170 23.56% 102,063 Harnett Regional Jetport 179,592 174,955 205,244 43,868 21.37% 66,375 Soil & Water 119,598 124,133 175,754 43,180 24.57% 33,198 Environmental Protection 4,000 4,000 14,000 4,000 28.57% 4,000 Forestry Program 113,334 114,849 114,992 - 0.00% - Economic/Physical Dev. App. 1,509,397 449,748 595,500 132,275 22.21% 99,588 Industrial Development 1,462,725 776,301 884,353 207,485 23.46% 141,750 Planning & Inspections 1,437,604 1,321,571 1,387,900 418,314 30.14% 431,847 Community Development (BG) - 1,129 1,300 319 24.54% 235 Abandoned MFG Home - 31,903 45,628 12,181 26.70% - Cooperative Extension 427,644 351,557 422,437 90,820 21.50% 102,231 CCR&R - Block Grant 27,369 31,419 33,673 10,754 31.94% 7,665 CCR&R - United Way - 2,483 2,678 298 11.13% - Parents As Teachers 226,262 158,263 59,500 6,085 10.23% 50,814 Adolescent Parenting 60,003 59,107 60,000 20,330 33.88% 15,014 U:\\My Documents\\Monthly Reports\\2014 - 2015\\October 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 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 - - - 250 4-H Teen Court & At Risk 30,804 45,686 49,773 13,865 27.86% 11,515 Child Care Youth Training - 27,367 17,897 - 0.00% 8,251 Race to the Top - 13,570 27,775 4,845 17.44% 4,068 Adolescent Parenting - 3,789 - - 4,595 Department on Aging 293,761 283,332 314,750 85,459 27.15% 94,564 Family Caregiver Support 38,363 51,769 61,146 19,868 32.49% 18,982 RSVP 72,852 73,276 77,705 26,363 33.93% 24,790 CAP - Disabled Adults 291,181 326,783 331,970 104,831 31.58% 106,759 Nutrition for Elderly 405,545 378,087 432,711 124,290 28.72% 118,194 Health 5,932,196 5,787,018 7,208,993 1,752,457 24.31% 1,767,887 Mental Health 615,679 815,679 605,679 302,840 50.00% 252,840 Social Services 9,418,756 9,359,396 10,313,676 2,966,275 28.76% 3,089,198 Public Assistance 7,944,608 7,829,453 9,691,288 2,297,603 23.71% 2,247,007 Veteran's Services 166,579 172,197 176,245 56,988 32.33% 55,727 Restitution 127,765 110,369 120,868 38,150 31.56% 37,141 Human Services App. 174,635 99,840 99,000 67,557 68.24% 74,713 Library 881,506 928,107 1,082,480 303,982 28.08% 330,053 Cultural & Recreational App. 167,000 100,000 150,000 - 0.00% 100,000 Parks & Recreation 319,254 363,011 436,081 136,931 31.40% 140,875 Education Board of Education - current 20,288,004 20,523,700 21,523,700 7,174,567 33.33% 8,551,542 Board of Education - capital - - - - - Central Carolina - current 638,841 927,711 917,467 305,822 33.33% 309,237 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 99,246 0.65% 753,239 Contingency - - - - - Total$ 102,308,383 $ 105,234,405 $ 114,714,295 $ 29,292,36725.54%$ 31,515,056 2014 - 2015 Total Adjusted Percent FYE 2015 Same Period BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Ad Valorem Taxes$ 54,273,480$ 58,070,801$ 57,851,526$ 14,666,04025.35%$ 16,051,534 Sales Tax 14,238,193 14,884,497 14,980,744 1,041,5246.95% Other taxes 1,010,549 1,037,719 1,200,000 271,138 22.59% Permits & Fees 3,089,188 2,763,205 2,927,767 666,695 22.77% 814,005 Intergovernmental Revenue 20,204,388 19,304,274 19,852,080 3,904,39519.67% 3,843,334 Sales & Services 9,422,096 7,658,151 9,694,505 1,991,66120.54% 1,795,186 Other Revenues 2,902,980 3,451,519 3,778,586 999,381 26.45% 380,789 Rents, Concessions. & Fees 83,870 77,898 84,251 18,77822.29% 8,892 Other Finance Sources 960,622 857,548 450,000 - 0.00% - Interfund Transfers 438,263 460,947 492,541 - 0.00% - Fund Balance Appropriated - - 3,402,295 - 0.00% - Total$ 106,623,629 $ 108,566,559 $ 114,714,295 $ 23,559,61220.54%$ 22,893,740 Revenues over/(under) expenditures$ (5,732,755) (8,621,316) U:\\My Documents\\Monthly Reports\\2014 - 2015\\October 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 2014 GENERAL FUND Cash and Investments CashTax LockboxNCCMTTotal 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 November, 2013$ 16,621,211$ 27,858 $ 12,624,371$ 29,273,440 October, 2013$ 6,725,797$ 27,405 $ 13,767,699$ 20,520,901 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 Restricted Fund Balance - creditors or imposed by law. This classification represents the portion of fund balance that can only be used for specific purposes imposed by majority vote by a quorum of the County Commissioners, that can by adoption of an Committed Fund Balance - 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 Unassigned Fund Balance - is not restricted, committed, or assigned to specific purposes within the general fund. U:\\My Documents\\Monthly Reports\\2014 - 2015\\October 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 2014 GENERAL FUND Unassigned Fund Balance at June 30, 2014$ 18,732,09518.20% Unaudited 06/30/2014 Revenues over/(under) Expenditures Year to Date Revenues over/(under) Expenditures (5,732,755) 12,999,340 Remaining Debt Payments for this Year (15,085,963) Outstanding budget amendments - Year to Date Fund Balance Appropriated (3,402,295) (18,488,258) IftheCountyweretostopoperationsattheendofthismonthandhad $ (5,488,918) nofurtherreceivablesorpayables,thenthiswouldbetheestimated -4.78% fund balance amount and its percentage of expenditures. Amount by which fund balance percentage will change$ 1,147,143 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\\October 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 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$ 13,146,523$ 2,327,92517.71%$ 1,844,969 Water Treatment 3,571,705 3,671,291 4,397,498 990,167 22.52% 1,046,881 Wastewater Treatment 1,790,807 1,965,319 2,349,238 447,439 19.05% 538,393 Wastewater Treatment SHWW 1,358,206 1,860,402 2,336,717 461,723 19.76% 447,301 Distribution 3,349,268 3,383,463 4,167,901 1,202,69528.86% 971,387 Collections 3,056,462 2,975,052 3,486,170 791,780 22.71% 866,958 Total$ 50,724,474$ 33,084,560$ 29,884,047$ 6,221,72920.82%$ 5,715,889 2014 - 2015 Total Adjusted Percent FYE 2015 Same Period BudgetActivityto DateLast Fiscal Year FYE 2013FYE 2014 Intergovernmental Revenue$ 3,703$ 3,703$ 3,600$ -0.00%$ - Sales & Services 27,670,467 30,275,723 26,921,865 10,469,81638.89% 8,703,846 Other Revenues 4,934,826 13,281,536 1,788,900 115,844 6.48% 101,491 Rents, Concess. & Feees 5,531 96 5,000 140.28% - Other Finance Sources 20,065,000 473,683 - 1,230,196 - Interfund Transfers - 150,000 - - - Fund Balance Appropriated - - 1,164,682 - 0.00% - Total$ 52,679,527$ 44,184,741$ 29,884,047$ 11,815,87039.54%$ 8,805,337 Revenues over/(under) expenditures$ 5,594,141$ 3,089,448 Cash and Investments CashLockbox *NCCMTTotal 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 November, 2013$ 19,734,711$ -$ 453,440$ 20,188,151 October, 2013$ 17,751,137$ -$ 453,180$ 18,204,317 * The balance in the lockbox account is rolled into the cash account before each month closes. 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\\October 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 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,394,790$ 1,146,52621.25%$ 1,474,420 Total$ 5,073,308$ 5,161,897$ 5,394,790$ 1,146,52621.25%$ 1,474,420 2014 - 2015 Total Adjusted Percent FYE 2015 Same Period BudgetActivityto DateLast Fiscal Year Revenues:FYE 2013FYE 2014 Taxes$ 227,228$ 237,297$ 259,000$ -0.00%$ - Intergovernmental Revenue - - 25,000 - - Sales & Services 4,776,288 5,006,315 5,097,390 1,247,24024.47% 1,432,011 Other Revenues 638,962 378,116 2,400 1757.29% 1,992 Rents, Concess. & Feees 430 243 - 27 14 Other Finance Sources 582,662 739,763 - - 739,763 Interfund Transfers - - - - - Fund Balance Appropriated - - 11,000 - 0.00% - Total$ 6,225,570$ 6,361,734$ 5,394,790$ 1,247,44223.12%$ 2,173,780 Revenues over/(under) expenditures$ 100,916$ 699,360 Cash and Investments CashSun TrustFirst BankNCCMTTotal 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 November, 2013$ 463,532$ 70,276 $ 88,219 $ 127,968$ 749,995 October, 2013$ 598,623$ 62,630 $ 80,153 $ 58,925 $ 800,331 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\\October 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 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,490,000$ 1,200,56921.87%$ - Fixed Cost - - 637,000 305,262 47.92% - Total$ -$ -$ 6,127,000$ 1,505,83024.58%$ - 2014 - 2015 Total Adjusted Percent FYE 2015 FYE 2015 BudgetActivityto DateActivity Revenues:FYE 2013FYE 2014 Medical Premiums$ -$ -$ 6,127,000$ 2,442,38239.86%$ - Other revenues - - - 10,783 - Fund Balance Appropriated - - - - - Total$ -$ -$ 6,127,000$ 2,453,16540.04%$ - Revenues over/(under) expenditures$ 947,334$ - Loss Ratio61.65% Cash and Investments CashNCCMTTotal 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$ -$ -$ - November, 2013$ -$ -$ - October, 2013$ -$ -$ - U:\\My Documents\\Monthly Reports\\2014 - 2015\\October 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 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$ 67,877 19.96%$ - Fixed Cost - - 36,000 11,81832.83% - Total$ -$ -$ 376,000$ 79,695 21.20%$ - 2014 - 2015 Total Adjusted Percent FYE 2015 FYE 2015 BudgetActivityto DateActivity Revenues:FYE 2013FYE 2014 Dental Premiums$ -$ -$ 376,000$ 124,16933.02%$ - Other revenues - - - 166,433 - Fund Balance Appropriated - - - - - Total$ -$ -$ 376,000$ 290,60277.29%$ - Revenues over/(under) expenditures$ 210,907$ - Loss Ratio64.18% Cash and Investments CashNCCMTTotal 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$ -$ -$ - November, 2013$ -$ -$ - October, 2013$ -$ -$ - U:\\My Documents\\Monthly Reports\\2014 - 2015\\October 2014 - Financial Statements.xlsx