Loading...
HomeMy WebLinkAboutApril 2014 - Financial Statements HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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 $ 182,524 $ 99,435 Administration 193,643 339,722 288,657 288,657 162,062 Legal Services 66,489 122,070 110,034 111,349 40,622 Engineering - - - - (15,853) Human Resources 220,461 224,821 269,691 269,691 197,234 Board of Elections 320,832 357,108 390,189 390,189 230,849 Finance 718,207 961,984 844,315 850,548 540,960 Clerk of Court 74,776 98,086 84,124 84,124 68,641 Tax 1,429,030 1,664,758 1,777,745 1,777,745 1,320,001 General Services 489,471 473,759 443,491 187,281 113,964 Transportation 1,111,563 940,206 1,100,038 1,114,506 666,332 Transportation - Admin - 188,721 219,109 219,109 155,182 Facilities Maintenance 2,440,691 3,285,478 3,650,583 3,650,583 2,356,908 Register of Deeds 737,080 761,273 808,328 808,328 602,776 Information Technology 1,083,183 1,256,973 1,312,631 1,344,631 1,088,733 GIS 381,412 440,731 440,076 440,076 360,478 Sheriff 8,610,487 9,344,007 10,555,506 10,937,819 8,421,187 Campbell Deputies 335,926 357,903 471,357 471,357 296,105 Harnett CJPP 67,303 53,836 100,029 100,029 63,591 Sheriff's Department Grants 50,267 38,810 - 16,820 - Child Support Enforcement 59,687 67,192 76,872 76,872 55,247 Governor's Highway Safety 107,362 112,332 - 26,540 27,036 Life is Fragile (NCGCC) - 29,531 - - - Communications 1,053,732 1,116,529 1,335,844 1,310,844 936,982 Jail 3,886,465 4,187,264 4,666,795 4,636,795 3,461,015 Emergency Services 681,809 712,960 756,903 804,967 605,292 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,274,174 3,237,064 EMS Transport 822,529 960,370 1,399,917 1,266,917 835,501 Rescue Districts 2,920,650 3,225,144 3,314,704 3,314,704 2,762,254 Animal Services 350,297 381,748 444,687 459,635 297,785 Medical Examiner 48,600 40,200 50,000 50,000 38,500 Public Safety Appropriations 126,472 126,278 64,767 124,773 104,891 Emergency Telephone System 235,087 243,460 280,815 280,815 200,738 Radio System 294,675 474,341 405,500 405,500 265,816 Harnett Regional Jetport 160,068 179,592 173,221 178,921 155,103 Soil & Water 114,166 119,598 127,688 127,688 100,298 Environmental Protection 4,000 4,000 14,000 14,000 4,000 Forestry Program 107,849 113,334 114,849 114,849 95,427 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 784,777 775,895 Planning & Inspections 1,358,230 1,437,604 1,394,065 1,365,297 1,069,243 Community Development (BG) - - 2,050 2,050 1,162 Abandoned MFG Home - - - 44,715 26,290 Cooperative Extension 350,461 427,644 416,748 431,756 267,923 CCR&R - Block Grant 27,981 27,369 47,774 33,673 22,807 CCR&R - United Way 797 - 2,800 6,502 1,181 Parents As Teachers 243,193 226,262 258,283 155,337 131,070 Adolescent Parenting 59,819 60,003 59,095 60,000 47,413 U:\\My Documents\\Monthly Reports\\2013 - 2014\\April, 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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 33,000 Child Care Youth Training - - - 34,371 17,194 Race to the Top - - - 16,590 11,660 Adolescent Parenting - - - 3,791 3,789 Department on Aging 291,935 293,761 311,543 301,436 226,782 Family Caregiver Support 61,212 38,363 62,446 62,160 45,848 RSVP 72,450 72,852 72,569 78,056 60,819 CAP - Disabled Adults 315,979 291,181 351,417 351,417 271,554 Nutrition for Elderly 404,768 405,545 439,163 438,888 283,467 Health 6,028,627 5,932,196 6,915,997 7,090,354 4,581,065 Mental Health 297,679 615,679 605,679 615,679 615,679 Social Services 8,906,348 9,418,756 10,134,132 10,134,132 7,726,551 Public Assistance 7,803,429 7,944,608 8,617,114 8,931,565 6,260,560 Veteran's Services 165,281 166,579 180,562 180,562 141,145 Restitution 108,790 127,765 113,802 116,017 88,065 Human Services App. 124,819 174,635 129,635 100,280 84,358 Library 934,233 881,506 1,053,285 1,055,285 731,238 Cultural & Recreational App. 150,000 167,000 100,000 100,000 100,000 Parks & Recreation 270,651 319,254 392,427 397,106 274,707 Education Board of Education - current 20,288,004 20,288,004 20,523,700 20,523,700 17,103,083 Board of Education - capital 2,830,946 - - - - Central Carolina - current 656,341 638,841 927,711 927,711 773,093 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 9,586,708 Contingency - - - - - Total$ 122,078,040$ 102,308,383$ 110,237,472$ 109,786,624$ 81,737,433 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$ 64,232,819 Permits & Fees 2,709,725 3,089,188 2,631,983 2,856,983 2,137,732 Intergovernmental Revenue 19,719,642 20,204,388 19,547,183 19,632,560 14,486,929 Sales & Services 9,660,129 9,422,096 8,414,478 8,192,428 5,435,624 Other Revenues 1,959,260 2,902,980 2,792,094 3,260,044 1,704,469 Rents, Concessions. & Fees 92,496 83,870 83,731 83,731 58,215 Other Finance Sources 3,092,503 960,622 851,690 851,690 - Interfund Transfers 629,415 438,263 2,425,000 1,137,534 5,947 Fund Balance Appropriated - - 2,400,000 2,680,341 - Total$ 104,937,535$ 106,623,629$ 110,237,472$ 109,786,624$ 88,061,735 Revenues over/(under) expenditures$ 6,324,303 U:\\My Documents\\Monthly Reports\\2013 - 2014\\April, 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 2014 GENERAL FUND Cash and Investments CashTax LockboxNCCMTTotal 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 April, 2013$ 11,805,090$ 120,388$ 13,294,693$ 25,220,170 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. U:\\My Documents\\Monthly Reports\\2013 - 2014\\April, 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 2014 GENERAL FUND Unassigned Fund Balance at June 30, 2013$ 17,959,942 Year to Date Revenues over/(under) Expenditures 6,324,303 24,284,245 Remaining Debt Payments for this Year (4,523,817) Outstanding budget amendments (1,867,209) Year to Date Fund Balance Appropriated (2,680,341) (9,071,367) IftheCountywheretostopoperationsattheendofthismonthandhadno $ 15,212,878 furtherreceivablesorpayables,thenthiswouldbetheestimatedfund balance amount and its percentage of expenditures. 13.86% Amount by which fund balance percentage will change$ 1,097,866 The County Board of Commissioners have approved a fund balance policy which strives to maintain a fund balance of 15%. U:\\My Documents\\Monthly Reports\\2013 - 2014\\April, 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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$ 13,077,173$ 6,939,643 Water Treatment 3,658,297 3,571,705 4,363,981 4,168,181 2,734,978 Wastewater Treatment 1,598,521 1,790,807 2,322,760 2,338,210 1,430,956 Wastewater Treatment SHWW 878,066 1,358,206 2,220,983 2,242,733 1,408,407 Distribution 2,913,944 3,349,268 4,176,329 4,141,879 2,669,937 Collections 2,232,445 3,056,462 2,856,474 3,123,274 2,232,687 Total$ 28,704,256$ 50,724,474$ 28,803,015$ 29,091,450$ 17,416,608 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 22,874,877 Other Revenues 32,027,608 4,934,826 248,000 248,000 685,614 Rents, Concess. & Feees 6,146 5,531 5,000 5,000 - Other Finance Sources 777,437 20,065,000 - - - Interfund Transfers - - - 2,030 - Fund Balance Appropriated - - 2,400,000 2,686,405 - Total$ 59,954,406$ 52,679,527$ 28,803,015$ 29,091,450$ 23,564,194 Revenues over/(under) expenditures$6,147,586 Cash and Investments CashLockbox *NCCMTTotal 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 April, 2013$ 16,442,297$ -$ 436,038 $ 16,878,335 * 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 U:\\My Documents\\Monthly Reports\\2013 - 2014\\April, 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT April, 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$ 3,755,646 Total$ 4,245,365 $ 5,073,308$ 5,329,390$ 5,542,871$ 3,755,646 2013 - 2014 Adjusted 2013 - 2014 FYE 2014 Original BudgetBudgetActivity Revenues:FYE 2012FYE 2013 Taxes$ 236,713$ 227,228$ 259,000 $ 259,000$ 131,357 Sales & Services 3,956,796 4,776,288 5,067,990 5,067,990 4,432,017 Other Revenues 10,451 638,962 2,400 2,400 106,305 Rents, Concess. & Feees 506 430 - - 69 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,409,511 Revenues over/(under) expenditures$ 1,653,865 Cash and Investments CashSun TrustFirst BankNCCMTTotal 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 April, 2013$ 697,584$ 192,583$ 305,437 $ 249,258$ 1,444,862 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 U:\\My Documents\\Monthly Reports\\2013 - 2014\\April, 2014 - Financial Statements.xlsx