Loading...
HomeMy WebLinkAboutMay 2014 - Financial Statements HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2014 GENERAL FUND FYE 2014 Activity (includes 2013 - 2014 2013 - 2014 Original BudgetAdjusted Budgetencumbrances) DepartmentFYE 2012FYE 2013 Governing Body $ 267,435 $ 180,854 $ 180,524 $ 190,024 $ 118,295 Administration 193,643 339,722 288,657 288,657 198,408 Legal Services 66,489 122,070 110,034 112,099 66,721 Engineering - - - 200 (11,268) Human Resources 220,461 224,821 269,691 283,296 222,344 Board of Elections 320,832 357,108 390,189 396,989 287,344 Finance 718,207 961,984 844,315 856,548 619,696 Clerk of Court 74,776 98,086 84,124 84,124 74,213 Tax 1,429,030 1,664,758 1,777,745 1,777,745 1,432,160 General Services 489,471 473,759 443,491 177,281 124,768 Fleet Maintenance - - - - 413,695 Transportation 1,111,563 940,206 1,100,038 1,123,455 750,021 Transportation - Admin - 188,721 219,109 219,109 168,342 Facilities Maintenance 2,440,691 3,285,478 3,650,583 3,650,583 2,695,790 Register of Deeds 737,080 761,273 808,328 808,328 646,040 Information Technology 1,083,183 1,256,973 1,312,631 1,347,131 1,206,069 GIS 381,412 440,731 440,076 440,076 400,877 Sheriff 8,610,487 9,344,007 10,555,506 10,936,516 9,112,109 Campbell Deputies 335,926 357,903 471,357 471,357 326,373 Harnett CJPP 67,303 53,836 100,029 100,029 70,430 Sheriff's Department Grants 50,267 38,810 - 16,820 15,213 Child Support Enforcement 59,687 67,192 76,872 76,872 60,617 Governor's Highway Safety 107,362 112,332 - 26,540 26,536 Life is Fragile (NCGCC) - 29,531 - - - Communications 1,053,732 1,116,529 1,335,844 1,310,844 1,106,794 Jail 3,886,465 4,187,264 4,666,795 4,611,423 3,793,630 Emergency Services 681,809 712,960 756,903 822,851 651,501 Emergency Services Grant 35,593 1,000 46,000 37,592 32,000 Emergency Medical Service 3,483,315 4,179,979 4,074,887 4,288,601 3,492,853 EMS Transport 822,529 960,370 1,399,917 1,206,512 924,118 Rescue Districts 2,920,650 3,225,144 3,314,704 3,314,704 3,314,704 Animal Services 350,297 381,748 444,687 459,635 323,617 Medical Examiner 48,600 40,200 50,000 50,000 45,300 Public Safety Appropriations 126,472 126,278 64,767 124,773 115,329 Emergency Telephone System 235,087 243,460 280,815 280,815 217,883 Radio System 294,675 474,341 405,500 405,500 278,471 Harnett Regional Jetport 160,068 179,592 173,221 178,921 170,114 Soil & Water 114,166 119,598 127,688 127,688 110,902 Environmental Protection 4,000 4,000 14,000 14,000 4,000 Forestry Program 107,849 113,334 114,849 114,849 104,791 Economic/Physical Dev. App. 1,459,319 1,509,397 470,500 470,500 328,261 Industrial Development 2,214,439 1,462,725 753,609 793,776 776,130 Planning & Inspections 1,358,230 1,437,604 1,394,065 1,385,297 1,179,870 Community Development (BG) - - 2,050 2,050 1,250 Abandoned MFG Home - - - 44,715 28,857 Cooperative Extension 350,461 427,644 416,748 432,256 295,111 CCR&R - Block Grant 27,981 27,369 47,774 33,673 27,444 CCR&R - United Way 797 - 2,800 6,502 2,153 Parents As Teachers 243,193 226,262 258,283 156,337 144,874 Adolescent Parenting 59,819 60,003 59,095 60,000 54,512 \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2013 - 2014\\May, 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2014 GENERAL FUND FYE 2014 Activity (includes 2013 - 2014 2013 - 2014 Original BudgetAdjusted Budgetencumbrances) DepartmentFYE 2012FYE 2013 CCR&R - Smart Start 22,558 17,922 - - - 4-H Teen Court & At Risk - 30,804 35,935 49,773 40,493 Child Care Youth Training - - - 34,371 27,367 Race to the Top - - - 16,590 12,654 Adolescent Parenting - - - 3,791 3,789 Department on Aging 291,935 293,761 311,543 301,737 247,516 Family Caregiver Support 61,212 38,363 62,446 62,160 48,430 RSVP 72,450 72,852 72,569 78,056 65,960 CAP - Disabled Adults 315,979 291,181 351,417 351,417 300,647 Nutrition for Elderly 404,768 405,545 439,163 438,888 319,921 Health 6,028,627 5,932,196 6,915,997 7,097,090 5,066,189 Mental Health 297,679 615,679 605,679 815,679 815,679 Social Services 8,906,348 9,418,756 10,134,132 10,134,132 8,475,792 Public Assistance 7,803,429 7,944,608 8,617,114 9,175,379 6,991,693 Veteran's Services 165,281 166,579 180,562 180,562 154,663 Restitution 108,790 127,765 113,802 117,968 96,597 Human Services App. 124,819 174,635 129,635 100,280 99,840 Library 934,233 881,506 1,053,285 1,056,285 801,708 Cultural & Recreational App. 150,000 167,000 100,000 100,000 100,000 Parks & Recreation 270,651 319,254 392,427 397,106 310,369 Education Board of Education - current 20,288,004 20,288,004 20,523,700 20,523,700 20,523,700 Board of Education - capital 2,830,946 - - - - Central Carolina - current 656,341 638,841 927,711 927,711 850,402 Central Carolina - capital 25,730 23,973 - - - Central Carolina - works - - - 25,000 25,000 Interfund Transfers 135,817 455,491 36,667 36,667 36,667 Debt Service 33,377,592 11,486,712 15,434,888 14,110,525 13,859,606 Contingency - - - - - Total$ 122,078,040$ 102,308,383$ 110,237,472$ 110,252,460$ 95,823,944 2013 - 2014 2013 - 2014 FYE 2014 Original BudgetAdjusted BudgetActivity FYE 2012FYE 2013 Taxes$ 67,074,365$ 69,522,222$ 71,091,313$ 71,091,313$ 66,053,620 Permits & Fees 2,709,725 3,089,188 2,631,983 2,874,983 2,463,057 Intergovernmental Revenue 19,719,642 20,204,388 19,547,183 19,825,410 16,656,144 Sales & Services 9,660,129 9,422,096 8,414,478 8,192,428 5,854,214 Other Revenues 1,959,260 2,902,980 2,792,094 3,267,965 2,648,331 Rents, Concessions. & Fees 92,496 83,870 83,731 83,731 60,645 Other Finance Sources 3,092,503 960,622 851,690 830,155 830,155 Interfund Transfers 629,415 438,263 2,425,000 1,137,534 5,947 Fund Balance Appropriated - - 2,400,000 2,948,941 - Total$ 104,937,535$ 106,623,629$ 110,237,472$ 110,252,460$ 94,572,113 Revenues over/(under) expenditures$ (1,251,831) \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2013 - 2014\\May, 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2014 GENERAL FUND Cash and Investments CashTax LockboxNCCMTTotal 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 June, 2013$ 14,111,649$ 611$ 7,006,755$ 21,119,015 May, 2013$ 7,789,286$ 71,619$ 14,586,274$ 22,447,179 Debt Service and Transfer Requirements Current YearOutstanding Interest$ 5,802,069$ 65,308,696 Principal 9,819,089 145,351,553 Transfers Out 36,667 - $ 15,657,825$ 210,660,249 Estimated Fund Balance Inthegovernmentfundfinancialstatements,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\\2013 - 2014\\May, 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2014 GENERAL FUND Unassigned Fund Balance at June 30, 2013$ 17,959,942 Year to Date Revenues over/(under) Expenditures (1,251,831) 16,708,111.25 Remaining Debt Payments for this Year (250,919) Outstanding budget amendments (1,867,209) Year to Date Fund Balance Appropriated (2,948,941) (5,067,069) IftheCountywheretostopoperationsattheendofthismonthandhadno $ 11,641,042 furtherreceivablesorpayables,thenthiswouldbetheestimatedfund balance amount and its percentage of expenditures. 10.56% Amount by which fund balance percentage will change$ 1,102,525 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\\2013 - 2014\\May, 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2014 PUBLIC UTILITIES FYE 2014 Activity 2013 - 2014 Adjusted (includes 2013 - 2014 Original BudgetBudgetencumbrances) FYE 2012FYE 2013 Admin/CSR/Meter Services$ 17,422,983$ 37,598,026$ 12,862,488$ 15,169,666$ 11,784,559 Water Treatment 3,658,297 3,571,705 4,363,981 4,097,218 3,093,222 Wastewater Treatment 1,598,521 1,790,807 2,322,760 2,261,380 1,582,747 Wastewater Treatment SHWW 878,066 1,358,206 2,220,983 2,332,283 1,586,240 Distribution 2,913,944 3,349,268 4,176,329 4,140,429 2,882,837 Collections 2,232,445 3,056,462 2,856,474 3,180,974 2,498,314 Total$ 28,704,256$ 50,724,474$ 28,803,015$ 31,181,950$ 23,427,919 2013 - 2014 Adjusted 2013 - 2014 FYE 2014 Original BudgetBudgetActivity FYE 2012FYE 2013 Intergovernmental Revenue$ 7,406$ 3,703$ 3,600$ 3,600$ 3,703 Sales & Services 27,135,809 27,670,467 26,146,415 26,146,415 25,776,870 Other Revenues 32,027,608 4,934,826 248,000 493,537 1,145,550 Rents, Concess. & Feees 6,146 5,531 5,000 5,000 - Other Finance Sources 777,437 20,065,000 - - - Interfund Transfers - - - 2,030 150,000 Fund Balance Appropriated - - 2,400,000 4,531,368 - Total$ 59,954,406$ 52,679,527$ 28,803,015$ 31,181,950$ 27,076,123 Revenues over/(under) expenditures$3,648,204 Cash and Investments CashLockbox *NCCMTTotal 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 June, 2013$ 14,324,616$ -$ 446,603 $ 14,771,219 May, 2013$ 14,711,106$ -$ 439,025 $ 15,150,131 * The balance in the lockbox account is rolled into the cash account before each month closes. Debt Service and Transfer Requirements Current YearOutstanding Interest$ 4,513,340$ 40,802,024 Principal$ 4,763,045 93,343,703 Transfers Out$ 2,583,435 - $ 11,859,820$ 134,145,727 \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2013 - 2014\\May, 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2014 SOLID WASTE FYE 2014 Activity 2013 - 2014 Adjusted (includes 2013 - 2014 Original BudgetBudgetencumbrances) FYE 2012FYE 2013 Solid Waste$ 4,245,365 $ 5,073,308$ 5,329,390$ 5,542,871$ 4,177,043 Total$ 4,245,365 $ 5,073,308$ 5,329,390$ 5,542,871$ 4,177,043 2013 - 2014 Adjusted 2013 - 2014 FYE 2014 Original BudgetBudgetActivity Revenues:FYE 2012FYE 2013 Taxes$ 236,713$ 227,228$ 259,000 $ 259,000$ 183,803 Sales & Services 3,956,796 4,776,288 5,067,990 5,067,990 4,497,821 Other Revenues 10,451 638,962 2,400 2,400 106,480 Rents, Concess. & Feees 506 430 - - 203 Other Finance Sources - 582,662 - 157,101 739,763 Interfund Transfers 8,360 - - - - Fund Balance Appropriated - - - 56,380 - Total$ 4,212,826 $ 6,225,570$ 5,329,390$ 5,542,871$ 5,528,070 Revenues over/(under) expenditures$ 1,351,027 Cash and Investments CashSun TrustFirst BankNCCMTTotal 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) June, 2013$ 156,608$ 1,106$ 17,254$ -$ 174,968 May, 2013$ (425,548) $ 212,035$ 319,976 $ 308,218$ 414,681 Debt Service and Transfer Requirements Current YearOutstanding Interest$ 135,825$ 923,608 Principal 339,834 3,569,540 Transfers Out 200,000 - $ 675,659$ 4,493,148 \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2013 - 2014\\May, 2014 - Financial Statements.xlsx