No preview available
HomeMy WebLinkAboutJuly 2014 - Financial Statements HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2014 GENERAL FUND FYE 2015 Activity (includes 2014 - 2015 2014 - 2015 Original BudgetAdjusted Budgetencumbrances) DepartmentFYE 2013FYE 2014 Governing Body $ 180,854 $ 164,631 $ 188,313 $ 188,313 $ 48,018 Administration 339,722 250,759 298,463 298,463 46,236 Legal Services 122,070 103,351 120,966 120,966 35,583 Engineering - 1 - - 4,681 Human Resources 224,821 254,738 274,623 274,623 43,487 Board of Elections 357,108 303,532 365,189 365,189 44,569 Finance 961,984 729,469 897,440 897,440 90,834 Clerk of Court 98,086 77,704 90,842 90,842 70,284 Tax 1,664,758 1,569,231 1,767,369 1,767,369 359,748 General Services 473,759 140,485 154,752 154,752 13,045 Fleet Maintenance - 438,847 701,293 701,293 178,707 Transportation 940,206 1,004,266 1,435,000 1,435,000 113,027 Transportation - Admin 188,721 194,790 225,479 225,479 16,056 Facilities Maintenance 3,285,478 3,400,887 4,187,163 4,187,163 1,467,789 Register of Deeds 761,273 730,166 828,767 828,767 44,609 Information Technology 1,256,973 1,301,628 1,451,480 1,451,480 342,389 GIS 440,731 432,327 458,523 458,523 37,526 Sheriff 9,344,007 10,166,283 10,617,396 10,617,396 1,308,104 Campbell Deputies 357,903 354,232 433,165 433,165 27,727 Harnett CJPP 53,836 80,119 - - - Sheriff's Department Grants 38,810 15,213 - - - Child Support Enforcement 67,192 66,257 77,977 77,977 5,302 Governor's Highway Safety 112,332 26,536 - - - Life is Fragile (NCGCC) 29,531 - - - - Communications 1,116,529 1,219,142 1,549,815 1,549,815 109,368 Jail 4,187,264 4,306,490 4,891,294 4,891,294 648,968 Emergency Services 712,960 737,021 816,311 816,311 88,811 Emergency Services Grant 1,000 32,000 - - - Emergency Medical Service 4,179,979 3,991,897 4,071,973 4,077,198 518,805 EMS Transport 960,370 1,083,318 1,202,067 1,202,067 176,832 Rescue Districts 3,225,144 3,314,704 3,361,704 3,361,704 280,142 Animal Services 381,748 376,744 478,055 478,055 52,878 Medical Examiner 40,200 50,000 65,000 65,000 4,050 Public Safety Appropriations 126,278 124,334 79,756 79,756 4,479 Emergency Telephone System 243,460 240,521 261,116 261,116 59,443 Radio System 474,341 300,204 302,100 302,100 120,265 Harnett Regional Jetport 179,592 174,955 180,244 180,244 133,741 Soil & Water 119,598 124,133 177,482 177,482 12,634 Environmental Protection 4,000 4,000 14,000 14,000 - Forestry Program 113,334 114,849 114,849 114,849 - Economic/Physical Dev. App. 1,509,397 449,748 595,500 595,500 20,500 Industrial Development 1,462,725 776,301 887,853 887,853 152,616 Planning & Inspections 1,437,604 1,321,571 1,390,709 1,400,709 115,774 Community Development (BG) - 1,129 1,300 1,300 - Abandoned MFG Home - 31,903 45,628 45,628 2,641 Cooperative Extension 427,644 351,557 426,277 426,277 10,597 CCR&R - Block Grant 27,369 31,419 45,675 33,039 3,770 CCR&R - United Way - 2,483 2,678 2,678 - Parents As Teachers 226,262 158,263 - 61,000 - Adolescent Parenting 60,003 59,107 58,835 58,835 5,156 \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\July 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2014 GENERAL FUND FYE 2015 Activity (includes 2014 - 2015 2014 - 2015 Original BudgetAdjusted Budgetencumbrances) DepartmentFYE 2013FYE 2014 CCR&R - Smart Start 17,922 - - - - 4-H Teen Court & At Risk 30,804 45,686 48,987 48,987 2,812 Child Care Youth Training - 27,367 17,897 17,897 - Race to the Top - 13,570 16,038 30,168 - Adolescent Parenting - 3,789 - - - Department on Aging 293,761 283,332 305,150 314,750 7,681 Family Caregiver Support 38,363 51,769 61,036 61,036 8,874 RSVP 72,852 73,276 75,205 77,705 5,238 CAP - Disabled Adults 291,181 326,783 331,970 331,970 56,553 Nutrition for Elderly 405,545 378,087 432,711 432,711 284,144 Health 5,932,196 5,787,018 7,007,971 7,007,721 1,449,564 Mental Health 615,679 815,679 605,679 605,679 51,420 Social Services 9,418,756 9,359,396 10,313,676 10,313,676 813,905 Public Assistance 7,944,608 7,829,453 9,691,288 9,691,288 476,279 Veteran's Services 166,579 172,197 178,003 178,003 16,962 Restitution 127,765 110,369 120,868 120,868 7,535 Human Services App. 174,635 99,840 99,000 99,000 54,000 Library 881,506 928,107 1,055,629 1,115,382 141,456 Cultural & Recreational App. 167,000 100,000 150,000 150,000 - Parks & Recreation 319,254 363,011 437,558 437,558 123,851 Education Board of Education - current 20,288,004 20,523,700 21,523,700 21,523,700 1,793,642 Board of Education - capital - - - - - Central Carolina - current 638,841 927,711 917,467 917,467 76,456 Central Carolina - capital 23,973 - - - - Central Carolina - works - 25,000 25,000 25,000 - Interfund Transfers 455,491 1,903,876 43,334 43,334 - Debt Service 11,486,712 13,902,144 15,185,209 15,185,209 14,677 Contingency - - - - Total$ 102,308,383$ 105,234,405$ 114,237,797$ 114,387,119$ 12,204,237 FYE 2015 Activity 2014 - 2015 2014 - 2015 Original BudgetAdjusted Budget(includes FYE 2013FYE 2014 Taxes$ 69,522,222$ 73,993,017$ 74,032,270$ 74,032,270$ 273,991 Permits & Fees 3,089,188 2,763,205 2,927,767 2,927,767 163,552 Intergovernmental Revenue 20,204,388 19,304,274 19,801,584 19,884,681 505,310 Sales & Services 9,422,096 7,658,151 9,638,797 9,638,797 227,004 Other Revenues 2,902,980 3,451,519 3,709,317 3,775,542 624,271 Rents, Concessions. & Fees 83,870 77,898 84,251 84,251 1,027 Other Finance Sources 960,622 857,548 450,000 450,000 - Interfund Transfers 438,263 460,947 400,000 400,000 - Fund Balance Appropriated - - 3,193,811 3,193,811 - Total$ 106,623,629$ 108,566,559$ 114,237,797$ 114,387,119$ 1,795,155 Revenues over/(under) expenditures$ (10,409,082) \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\July 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2014 GENERAL FUND Cash and Investments CashTax LockboxNCCMTTotal 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 September, 2013$ 4,446,957$ 611$ 13,644,045$ 18,091,613 August, 2013$ 5,727,362$ 611$ 12,480,364$ 18,208,337 July, 2013$ 9,974,228$ 611$ 10,954,310$ 20,929,149 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 Inthegovernmentalfundfinancialstatements,fundbalanceiscomposedoffiveclassificationsdesignedtodisclosethehierarchyof constraints placed on how fund balance can be spent. They are as follows: Thisclassificationincludesamountsthatcannotbespentbecausetheyareeither(a)notin Non-Spendable Fund Balance - spendable form or (b) legally or contractually required to be maintained intact. Theclassificationincludesamountthatarerestrictedtospecificpurposesexternallyimposedby Restricted Fund Balance - creditors or imposed by law. Thisclassificationrepresentstheportionoffundbalancethatcanonlybeusedforspecificpurposes imposedbymajorityvotebyaquorumoftheCountyCommissioners,thatcanbyadoptionofan Committed Fund Balance - ordinance, commit fund balance. ThatportionoffundbalancethattheCountyintendstouseforspecificpurposes.TheCounty Commissionershavetheauthoritytoassignfundbalances.TheManagerandFinanceOfficer,as Assigned Fund Balance - granted in the budge ordinance, have been granted limited authority to assign fund balance. Thisclassificationrepresentstheportionoffundbalancethathasnotbeenassignedtoanother Unassigned Fund Balance - fund or is not restricted, committed, or assigned to specific purposes within the general fund. \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\July 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2014 GENERAL FUND Unassigned Fund Balance at June 30, 2014$ 17,959,942 Year to Date Revenues over/(under) Expenditures (10,409,082) 7,550,860.41 Remaining Debt Payments for this Year (15,170,532) Outstanding budget amendments - Year to Date Fund Balance Appropriated (3,193,811) (18,364,343) IftheCountywheretostopoperationsattheendofthismonthandhadno $ (10,813,483) furtherreceivablesorpayables,thenthiswouldbetheestimatedfund balance amount and its percentage of expenditures. -9.45% Amount by which fund balance percentage will change$ 1,143,871 The County Board of Commissioners have approved a fund balance policy which strives to maintain a fund balance of 15%. \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\July 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2014 PUBLIC UTILITIES FYE 2015 Activity 2014 - 2015 Adjusted (includes 2014 - 2015 Original BudgetBudgetencumbrances) FYE 2013FYE 2014 Admin/CSR/Meter Services$ 37,598,026$ 19,229,033$ 12,381,841$ 13,146,523$ 1,536,786 Water Treatment 3,571,705 3,671,291 4,397,498 4,397,498 2,068,283 Wastewater Treatment 1,790,807 1,965,319 2,349,238 2,349,238 804,018 Wastewater Treatment SHWW 1,358,206 1,860,402 2,336,717 2,336,717 760,041 Distribution 3,349,268 3,383,463 4,167,901 4,167,901 1,401,541 Collections 3,056,462 2,975,052 3,486,170 3,486,170 1,220,040 Total$ 50,724,474$ 33,084,560$ 29,119,365$ 29,884,047$ 7,790,710 2014 - 2015 Adjusted 2014 - 2015 FYE 2015 Original BudgetBudgetActivity FYE 2013FYE 2014 Intergovernmental Revenue$ 3,703$ 3,703$ 3,600$ 3,600$ - Sales & Services 27,670,467 30,275,723 26,921,865 26,921,865 2,267,013 Other Revenues 4,934,826 13,281,536 1,788,900 1,788,900 43,003 Rents, Concess. & Feees 5,531 96 5,000 5,000 - Other Finance Sources 20,065,000 473,683 - - 610,494 Interfund Transfers - 150,000 - - - Fund Balance Appropriated - - 400,000 1,164,682 - Total$ 52,679,527$ 44,184,741$ 29,119,365$ 29,884,047$ 2,920,509 Revenues over/(under) expenditures-$4,870,200 Cash and Investments CashLockbox *NCCMTTotal 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 September, 2013$ 18,085,580$ -$ 452,951 $ 18,538,531 August, 2013$ 16,432,674$ -$ 448,888 $ 16,881,562 July, 2013$ 14,961,277$ -$ 446,603 $ 15,407,880 * 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$ 400,000 - $ 8,321,762$ 124,684,473 \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\July 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2014 SOLID WASTE FYE 2015 Activity 2014 - 2015 Adjusted (includes 2014 - 2015 Original BudgetBudgetencumbrances) FYE 2013FYE 2014 Solid Waste$ 5,073,308 $ 5,161,897$ 5,358,790$ 5,358,790$ 853,728 Total$ 5,073,308 $ 5,161,897$ 5,358,790$ 5,358,790$ 853,728 2014 - 2015 Adjusted 2014 - 2015 FYE 2015 Original BudgetBudgetActivity Revenues:FYE 2013FYE 2014 Taxes$ 227,228$ 237,297$ 259,000 $ 259,000$ - Intergovernmental Revenue - - - - - Sales & Services 4,776,288 5,006,315 5,097,390 5,097,390 27,807 Other Revenues 638,962 378,116 2,400 2,400 25 Rents, Concess. & Feees 430 243 - - - Other Finance Sources 582,662 739,763 - - - Interfund Transfers - - - - - Fund Balance Appropriated - - - - - Total$ 6,225,570 $ 6,361,734$ 5,358,790$ 5,358,790$ 27,832 Revenues over/(under) expenditures$ (825,895) Cash and Investments CashSun TrustFirst BankNCCMTTotal 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 September, 2013$ (389,231) $ 37,986$ 53,459$ 58,925 $ (238,861) August, 2013$ (436,599) $ 23,987$ 34,636$ 58,925 $ (319,051) July, 2013$ (229,256) $ 11,068$ 26,666$ -$ (191,522) Debt Service and Transfer Requirements Current YearOutstanding Interest$ 127,786$ 796,081 Principal 403,867 3,338,828 Transfers Out 200,000 - $ 731,653$ 4,134,909 \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\July 2014 - Financial Statements.xlsx