Loading...
102814ssa Agenda PackageHarnett County Board of Commissioners Special Session Tuesday, October 28, 2014 9:00 am 9:00 am Summerville Bunnlevel Fire & Rescue, Inc. is requesting approval to purchase a 1992 International 2674 General Fire Safety Engine with a 65' Telesquirt Aerial Ladder/Water Tower. 9:15 am Discussion regarding the Harnett County Schools Revised Capital Outlay Project List 9:45 am Finance Officer's Report — September 2014 10:00 am County Manager's Report 10:15 am Regular Meeting Agenda Review October 20, 2014 SUMMERVILLE BUNNLEVEL FIRE & RESCUE, INC. P.O. Box 1144 Lillington, NC 27546 www.summervillefire.org Request for Budget Amendment To the Harnett County Board of Commissioners RECD oar El) 12014 444NAGZsc004,4, The Board of Directors of Summerville Bunnlevel Fire & Rescue, Inc. is requesting a budget amendment to the fiscal year 2014/2015 budget as submitted in the amount of $35,000 to include the purchase of a 1992 International 2674 General Fire Safety Engine with a 65' Telesquirt Aerial Ladder/Water Tower. This unit will be a valuable resource for protecting the new homes under construction within our district, most of which are 2 and 3 story as well as Central Harnett Hospital which in within our response area. Also, Summerville Bunnlevel is in the process of preparing to request a reinspection of our insurance rate issued by the North Carolina Office of State Fire Marshal. Our current rate is a split 7/9E. This rate only benefits those insured properties within 1000 feet of a fire hydrant. We estimate that this only benefits 30% of our taxpayers. Our goal is to receive a straight rating, even if it's a 7, which will offer the same benefit to all insured's of the Summerville Bunnlevel Fire District. Doing this will cause many of our taxpayers to save hundreds of dollars on their fire insurance premium. An Engine with the water tower will provide maximum insurance points to Summerville Bunnlevel in our reinspection and be available to provide aerial support to any of our mutual aid departments. The apparatus being requested is a used unit that belongs to the Falcon Heights Fire Department in Falcon Heights MN and is currently listed for sale on GovDeals.com with an October 30 bid date. The unit is currently in service and recently passed the annual pump certification and ladder certification in accordance with NFPA 1911 standards. New, this apparatus would cost in excess of $600,000. We have the funds available for this purchase and will require no financing. We thank you for your consideration of this request and should additional questions exist, do not hesitate to let us know. Leo Mc[?oria President of the Board of Directors Summerville Station 1 111 East Harnett Street Lillington, North Carolina 27546 Bunnlevel Station 2 6825 US401S Bunnlevel, North Carolina 28323 1992 International 2674 General Safety Fire Engine - GovDeals.com Page 1 of 2 GovDeaJs A LIQUIDITY SERVICES MARKE7PLACE Searches FAQ Contact Us About Us Search View Auctions cri October 20,2014,08:37 AM ET P22 Like 1 Home Log In Register 1992 International 2674 General Safety Fire EEngine Year Make /Brand International 2674 iition Category See Description More media Miles Title Restriction 1HTGKCUR7NH441994 ( 19,872 No You are bidding on a 1992 International 2674 SBA, 14.0L L6 DIESEL. Cummins N -14 330 HP engine and an Allison HT -740 4 speed automatic transmission. Waterous 2 -stage 1500 gpm pump (last certified 6 -6 -14) with a steel 500 gallon tank Onan 7.5kw generator. 19872 miles 1861 hours 65' Telesquirt aerial ladder and Water tower (length 33'; height 148 ") Engine is currently in use ... will be available in September Unit is sold 'as is." NOTE: you are bidding only on the asset listed, regardless of what may be showing in the pictures. Additional Info: Falcon Heights Inspection Sheet 2.pdf, Falcon Heights Inspection Sheet 1.pdf »Seller Information Ask a question Seller Name: Falcon Heights, MN Asset Contact: Mike Poeschl (Phone: 651- 792 -7632) Asset Location: 2077 Larpenteur Ave W Falcon Heights, Minnesota 55113 -5551 Map to this location Auction Ends: 10/29/14 9:00 PM ET Remaining: 9 Days 12 Hrs This item is subject to an auto extension of the auction end time. Refresh Bid & Time Reserve Not Met Admin Fee: 7.50% Starting Bid. $3,800.00 Bids: 3 High Bidder: s * *.-*..,..,, „. » * ..............9 Current Bid: $5,100.00 Bid Increment $100.00 Minimum Bid: $5,200.00 Terms and Conditions 221 visitors q Inspection Most items offered for sale are used and may contain defects not immediately detectable Bidders may inspect the property prior to bidding. Inspection is by appointment only Please see the contact above to schedule an inspection. Payment The Buyer's Certificate will contain information to schedule payment & removal. Payment in full is due not later than five (5) business days from the time and date of the Buyers Certificate. Acceptable forms of payment are U S. Currency, Certified Cashiers Check, Money Order, or a Company Check (with Bank Letter guaranteeing funds ? mandatory). Checks shall be made payable to: Falcon Heights, MN Additional Fees Administrative Fee: 7 50% http: / /www.govdeals. corn/ index.cfm ?fa= Main.Item &itemid =1 &acctid =7041 10/20/2014 1992 International 2674 General Safety Fire Engine - GovDeals.com Removal Page 2 of 2 Property may be removed by appointment only and appointments must be made at least 24 hours in business days from the time and date of issuance of the Buyer's Certificate. The Buyer will make all arrangements and perform all work necessary, including packing, loading and provided. A daily storage fee of $10.00 may be charged for any item not removed within the 10 Certificate, advance. All items must be removed within ten (10) transportation of the property. No Assistance will be business days allowed and stated on the Buyer's I Special Instructions NOTICE: If you are the winning bidder and default by failing to adhere to this sellers terms and conditions your account with GovDeals WILL BE LOCKED. Guaranty Waiver. All property is offered for sale AS IS. WHERE IS,' Falcon Heights, MN makes no warranty, guaranty or representation of any kind, expressed or implied, as to the merchantability or fitness for any purpose of the property offered for sale, Please note that upon removal of the property, all sales are final. Description Warranty Seller warrants to the Buyer that the property offered for sale will conform to its description. Any claim for misdescription must be made prior to removal of the property. If Seller confirms that the property does not conform to the description, Seller will keep the property and refund any money paid. The liability of the seller shall not exceed the actual purchase price of the property. ?Questions and Answers Ask a question There are currently no questions posted for this asset v' Help Desk Hours: Monday - Friday, 8 am - 7 pm ET. Contact us with any questions, comments or concerns. Copyright © 2014.. GovDeals. Inc All Rights Reserved Site Map Center. corn http: / /www. govdeals. com/ index.cfm ?fa= Main.Item &itemid =1 &acctid =7041 Liquidity Services Inc. 10/20/2014 MI IMP � qe « �6 Pump Test Certification Results Department: Vehicle: Falcon Heights Fire Department Ladder 757 Make: Model: Engine: International 2674 Year. 1992 Mlles: 19800 Governed Speed: 2190 Pump Make: Pump Model: Waterous CMUYBX Purnp Capacity: 1500 Pump S/ N: 26157W Test Time: Ambient Temperature ( °F): Water Temperature (0F): Barometer (mmHg): 14:40:00 80 70 30 Test Date: 06/06/2014 PASSED Cumulative Test Data Capacity 200 PSI 250 PSI Gallons Per Minute: 1500 1050 750 R.P.M. Calibrated: 1444 1525 1352 R.P.M. Engine: 1500 1600 1400 R.P.M. Panel: 1400 1500 1300 Net Pump Pressure: 150 200 250 Correction Factor: 5 4 3 Pump Pressure: 145 196 247 Pump Suction: 7 6 6 1500 GPM ,4 150 PSI @ 1444RPM Volume 1050 GPM @ 200 PSI Eai 1525 RPM Volume 750 GPM @ 250 PSI @ 1352 RPM Pressure Relief valve /Pressure Governor T est Operates Pressure Property PSI Increase 150 PSI 90 PSI 250 PSI YES YES YES 10 10 10 Capacity Test Raw Data Dry Vacuum. Test Pump Packing Drip Rate: Vacuum Achieved: Vacuum Drop: 0 24 1 Tachometer Cab Panel 1444 1400 Pump Gauges Pressure Compound 150 10 Test Gauges Pressure Vacuum 145 7 Calibrated Time RPM PITOT 14:40:00 1444 65 14:45:00 1440 65 14:50:00 1450 65 14:55:00 1446 65 15 :00:00 1440 65 200 PSI Test Raw Data Tip 2" Mode Volume Prirnirig Test Suction Diameter: Suction Length: Suction Lift: Time: 6 20 4 7 250 PSI Test Raw Data Tachometer Cab Panel 1525 1500 Pump Gauges Pressure Compound 200 10 Test Gauges Pressure Vacuum 196 6 Calibrated Time RPM PITOT 15:05:00 1520 78 15:10:00 1530 78 15:15 :00 1526 78 Tachometer Cab Panel 1352 1300 Pump Gauges Pressure Compound 250 10 Test Gauges Pressure Vacuum 247 6 Time 15:20:00 15:25 :00 15:30:00 Calibrated RPM 1360 1348 1350 PITOT 68 68 68 • •^.------t..-.. . , ...,....--•-•-...,...'n ..,....--•-•-...,...'...,....--•-•-...,...'n "",. ti.• ' • '` :, .- � ..... - ,s .!:^ \� ,• Y .•,ti.�.' a,., _ `r' !•Y'Y, •iF �\ I .11,'' ' 11 % .'1 ,1 / Y, t 7.f: '('�! r! t. rt.. °' ` ( Y 11'f i 1 +I { ( �1 is�, I } rll •fr' • Al ' {11 •.' .Jt!!{' :,__:.- .._.'i1 ., •1. �_...i. -..•• - _��.-t,l f i�l.. , IL ?'�__— _. -_'i} ....._._ .t f.l (�, (fl - z'� 4' :.. .'` 1) ,,.,.,..,...:,::::.,::.....,........_:, , .i..„::;.......,...., • . • . . , r.i.,.......„,...,...,.,%,......,:. , . . .• • . „.........„.„.....4000. ,. I ' ISSUED TO: � FALCON HEIGHTS FIRE •DEPT Ifi...,:,._....._. ,A DDRESS;. 2077 W LARPENTEUR i�rlbi, �,� : - ..,- . .., • 4 FALCON HEIGHTS; MN 551'13 • r q t • ter •; TESTREPORT #t 1 ,;'1 It. 7 • . - . 1,((iiii,:i' :.: .. „Y' r. • . ,' ...fl ' ' ; .. . 1 • , . , , ' . ; ' :rt. Aff - .. 11011 , , . t . -. . ' 1„,:o... ...`:. . - • • ..........1, ii FT141838 =1 # ►�j� • DATE OF TEST. 7 /29/201 ; AERIAL MANUFACTURER / MODEL TELE SQURT -65 / P6560 • {i fll.i' i .. AERIAL TYPE: Squirt • 1 SERIAL NUMBER: 050721473 ' i - 1 : r. a MAKE: INTERNATIONAL ( . ;;� • SER ::• CHASSIS {',` (((((k((k4k't4 CHASSIS VIN' IHTGKCUR7NH447994 Y . NFP • ( Ilt i,. ; .. • ;A ;h,. , TESL TYPE; ANNUAL COMMENTS; 191 ' I ';:ii . ' TIER . r I tri iINS+CtltAaAfQN11bI I ** 77ts inspection is not intended for condition of sale . _. _, . I, {�( ,'1�� • _.....46,,edi • • • . '11{ {ff!"{A, i ' ' r , I, I-. I r, .I; '' II /• 3�i 4` ,Y, , I Y +' iu i.1:',1:. ilr i 1 P.. .�H 5 + r I ,1.; ,,:;...',1;:$!..:1;', 1 , I _• r �• J +-ti�� 1 -yam,.- n • "�/ .,ti+...".-""✓F %•• \ -ti:.. hz ` "mow nom' http://www.govdeals.com/photos/7041/7041 1 1 0.JPG Page 1 of 1 10/20/2014 http://www.govdeals.com/photos/7041/7041 1 1 4. JP G Page 1 of 1 10/20/2014 Thomas S. Frye Superintendent Harnett County Schools Office of Superintendent P. O. Box 1029 Lillington, NC 27546 910- 893 -8151 Fax: 910 -893 4279 TO: Tommy Burns, Harnett County Manager FROM: Tom Frye, Superintendent DATE: October 6, 2014 RE: Revised Capital Outlay Project List Per my September 15, 2014 memo (enclosed) to you, please find included below a revised list of capital projects from the Harnett County Board of Education's 2014 -2015 local budget request as well as a line item for due diligence on potential property in western Harnett County. I am submitting a request for these projects to be funded from the capital outlay (% ¢ sales tax) appropriation as approved by the Harnett County Board of Commissioners' Budget for Fiscal Year 2015. It is my understanding that these projects will be funded on a reimbursement basis paid quarterly. Please note that the projected cost column represents budget estimates. Project Scope Projected Cost Ener ro ect gyp Debt service (final year) for 2002 energy performance contract _ 147,751.13 Safety and security - Multiple schools Buzz -in controls, fencing, door controls (portion of original request) 404,248.87 Due Diligence - Elementary School Property Due Diligence on potential property for an elementary school in western Harnett County 138 000.00 ' Roofing repair Roofing repair at Benhaven Elementary School 50,000.00 Roofing repair Roofing repair at Erwin Elementary School 30,000.00 Downspouts/guttering Replacement of rusted downspouts and guttering at Dunn Middle School 30,000.00 Plumbing replacement Replacement of plumbing at Western Harnett High School - system failure 435,000.00 Fire panel replacement Replace failed fire panel — Coats -Erwin Middle . 65,000.00 Total 1,300,000.00 If the' /, ¢ sales tax revenue is higher than expected, we have a multitude of additional projects that we can undertake. Please alert me regarding the approval of these projects by the Board of Commissioners. Enclosure For our students—whatever it takes; whenever it takes it; however long it takes, WE will do! Department HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 FYE 2013 Governing Body Administration Legal Services Engineering Human Resources Board of Elections Finance Clerk of Court Tax General Services Fleet Maintenance Transportation Transportation - Admin Facilities Maintenance Register of Deeds Information Technology GIS Sheriff Campbell Deputies Harnett CJPP Sheriff's Department Grants Child Support Enforcement Governor's Highway Safety Life is Fragile (NCGCC) Communications Jail Emergency Services Emergency Services Grant Emergency Medical Service EMS Transport Rescue Districts Animal Services Medical Examiner JCPC Admin Public Safety Appropriations Emergency Telephone System Radio System Harnett Regional Jetport Soil & Water Environmental Protection Forestry Program Economic /Physical Dev. App. Industrial Development Planning & Inspections Community Development (BG) Abandoned MFG Home Cooperative Extension CCR &R - Block Grant CCR &R - United Way Parents As Teachers Adolescent Parenting $ 180,854 339,722 122,070 224,821 357,108 961,984 98,086 1,664,758 473,759 940,206 188,721 3,285,478 761,273 1,256,973 440,731 9,344,007 357,903 53,836 38,810 67,192 112,332 29,531 1,116,529 4,187, 264 712,960 1,000 4,179, 979 960,370 3,225,144 381,748 40,200 126,278 243,460 474,341 179,592 119,598 4,000 113,334 1,509,397 1,462,725 1,437,604 427,644 27,369 226,262 60,003 U: \My Documents \Monthly Reports \2014 - 2015 \September 2014 - Financial Statements.xlsx GENERAL FUN FYE 2014 $ 164,631 250,759 103,351 1 254,738 303,532 729,469 77,704 1,569,231 140,485 438,847 1,004,266 194,790 3,400,887 730,166 1,301,628 432,327 10,166, 283 354,232 80,119 15,213 66,257 26,536 1,219,142 4,306,490 737,021 32,000 3,991,897 1,083,318 3,314,704 376,744 50,000 124,334 240,521 300,204 174,955 124,133 4,000 114,849 449,748 776,301 1,321,571 1,129 31,903 351,557 31,419 2,483 158,263 59,107 2014 - 2015 Original Budget $ 188,313 298,463 120,966 274,623 365,189 897,440 90,842 1,767,369 154,752 701,293 1,435,000 225,479 4,187,163 828,767 1,451,480 458,523 10,617,396 433,165 77,977 1,549,815 4,891,294 816,311 4,071,973 4,056,454 1,202,067 1,197,127 3,361,704 3,361,704 478,055 476,149 65,000 65,000 5,000 79,756 74,756 261,116 258,736 302,100 302,100 180,244 205,244 177,482 175,754 14,000 14,000 114,849 114,849 595,500 595,500 887,853 884,353 1,390,709 1,387,900 1,300 1,300 45,628 45,628 426,277 422,158 45,675 33,673 2,678 2,678 61,500 58,835 60,000 2014 - 2015 Adjusted Budget $ 188,313 295,629 119,294 272,012 358,674 877,440 89,554 1,741,896 153,902 700,730 1,516,440 219,288 4,184,554 813,812 1,776,660 448,798 10,511,034 433,165 77,977 1,549,815 4,886,316 808,957 FYE 2015 Activity (includes encumbrances) 69,168 115,377 80,319 14,035 79,950 71,926 249,306 21,189 386,236 37,510 132,173 124,446 40,094 692,572 138,136 570,515 99,951 2,264,594 89,149 16,734 285,391 932,551 145,364 909,400 232,681 1,120,568 83,593 13,200 14,937 60,319 49,062 31,603 32,530 4,000 100,482 198,760 313,428 121 9,541 59,754 8,474 55 1,666 15,303 Department CCR &R - Smart Start 4 -H Teen Court & At Risk Child Care Youth Training Race to the Top Adolescent Parenting Department on Aging Family Caregiver Support RSVP CAP - Disabled Adults Nutrition for Elderly Health Mental Health Social Services Public Assistance Veteran's Services Restitution Human Services App. Library Cultural & Recreational App. Parks & Recreation Education Board of Education - current Board of Education - capital Central Carolina - current Central Carolina - capital Central Carolina - works Interfund Transfers Debt Service Contingency Total Ad Valorem Taxes Sales Tax Other taxes Permits & Fees Intergovernmental Revenue Sales & Services Other Revenues Rents, Concessions. & Fees Other Finance Sources Interfund Transfers Fund Balance Appropriated Total HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 FYE 2013 17,922 30,804 293,761 38,363 72,852 291,181 405,545 5,932,196 615,679 9,418,756 7,944,608 166,579 127,765 174,635 881,506 167,000 319,254 20,288,004 638,841 23,973 455,491 11,486, 712 GENERAL FU FYE 2014 45,686 27,367 13,570 3,789 283,332 51,769 73,276 326,783 378,087 5,787,018 815,679 9,359,396 7,829,453 172,197 110,369 99,840 928,107 100,000 363,011 20,523,700 927,711 25,000 1,903,876 13,902,144 2014 - 2015 Original Budget 48,987 17,897 16,038 305,150 61,036 75,205 331,970 432,711 7,007,971 605,679 10,313,676 9,691,288 178,003 120,868 99,000 1,055,629 150,000 437,558 21,523,700 917,467 25,000 43,334 15,185, 209 102,308,383 $ 105,234,405 $ FYE 2013 $ 54,273,480 14,238,193 1,010,549 3,089,188 20,204,388 9,422,096 2,902,980 83,870 960,622 438,263 FYE 2014 58,070,801 14,884,497 1,037,719 2,763,205 19, 304, 274 7,658,151 3,451,519 77,898 857,548 460,947 2014 - 2015 Adjusted Budget 49,773 17,897 27,775 314,750 60,353 77,705 331,970 432,711 7,162,520 605,679 10,313,676 9,691,288 176,245 120,868 99,000 1,082,480 150,000 436,081 21,523,700 917,467 25,000 43,334 15,185, 209 FYE 201 Activity (includes encumbrances) 10,998 3,337 55,953 14,907 15,968 84,205 91,194 1,294,470 51,420 2,211,446 1,728,665 42,421 28,566 67,557 230,369 103,235 5,380,925 229,367 44,030 114,237,797 $ 114,671,304 $ 21,605,196 2014 - 2015 Original Budget $ 57,851,526 14,980,744 1,200,000 2,927,767 19,801,584 9,638,797 3,709,317 84,251 450,000 400,000 3,193,811 114,237,797 $ 106,623,629 $ 108,566,559 $ Revenues over /(under) expenditures U: \My Documents \Monthly Reports \2014 - 2015 \September 2014 - Financial Statements.xlsx 2014 - 2015 Adjusted Budget $ 57,851,526 14, 980, 744 1,200,000 2,927,767 19,925,994 9,635,807 3,804,792 84,251 450,000 400,000 3,410,423 $ 114,671,304 Activity (includes $ 12,286,935 209,075 483,250 2,631,575 1,344,952 865,166 13,359 $ 17,834,312 $ (3,770,884) September, 2014 August, 2014 July, 2014 June, 2014 May, 2014 April, 2014 March, 2014 February, 2014 January, 2014 December, 2013 November, 2013 October, 2013 September, 2013 HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 GENERAL FUND Cash and Investments Cash Tax Lockbox $ - $ 475 $ - $ 475 $ - $ 475 $ 2,799,637 $ 475 $ 5,325,561 $ 27,888 $ 12,798,914 $ 27,888 $ 14,373,115 $ 27,887 $ 16,560,067 $ 27,845 $ 17,860,088 $ 27,845 $ 10,145,781 $ 27,845 $ 16,621,211 $ 27,858 $ 6,725,797 $ 27,405 $ 4,446,957 $ 611 NCCMT Total $ 26,396,094 $ 26,396,569 $ 19,277,617 $ 19,278,091 $ 20,554,835 $ 20,555,310 $ 21,645,331 $ 24,445,443 $ 20,305,523 $ 25,658,972 $ 20,164,065 $ 32,990,868 $ 18,787,339 $ 33,188,341 $ 16,075,525 $ 32,663,437 $ 15,963,619 $ 33,851,552 $ 14,551,933 $ 24,725,559 $ 12,624,371 $ 29,273,440 $ 13,767,699 $ 20,520,901 $ 13,644,045 $ 18,091,613 Debt Service and Transfer Requiremen Current Year Outstanding Interest $ 5,465,931 $ 58,811,027 Principal 9,719,278 143,630,869 Transfers Out 43,334 $ 15,228,543 $ 202,441,896 Stiff ated 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: Non Spendable Fund Balance spendable form or (b) legally or contractually required to be maintained intact. This classification includes amounts that cannot be spent because they are either (a) not in Restricted Fund Balance - creditors or imposed by law. The classification includes amount that are restricted to specific purposes externally imposed by This classification represents the portion of fund balance that can only be used for specific purposes Committed Fund Balance - imposed by majority vote by a quorum of the County Commissioners, that can by adoption of an ordinance, commit fund balance. Assigned Fund Balance - Commissioners have the authority to assign fund balances. That portion of fund balance that the County intends to use for specific purposes. The County Unassigned Fund Balance - fund or is not restricted, committed, or assigned to specific purposes within the general fund. This classification represents the portion of fund balance that has not been assigned to another U: \My Documents \Monthly Reports \2014 - 2015 \September 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 GENERAL FUND'' Unassigned Fund Balance at June 30, 2014 $ 18,732,094 Year to Date Revenues over /(under) Expenditures (3,770,884) 14,961,210 Remaining Debt Payments for this Year (15,141,179) Outstanding budget amendments Year to Date Fund Balance Appropriated (3,410,423) (18,551,602) If the County were to stop operations at the end of this month and had no $ (3,590,392) further receivables or payables, then this would be the estimated fund balance amount and its percentage of expenditures. -3.13% Amount by which fund balance percentage will change $ 1,146,713 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 \September 2014 - Financial Statements.xlsx 18.20% Admin /CSR /Meter Services Water Treatment Wastewater Treatment Wastewater Treatment SHWW Distribution Collections Total Intergovernmental Revenue Sales & Services Other Revenues Rents, Concess. & Feees Other Finance Sources Interfund Transfers Fund Balance Appropriated Total Revenues over /(under) expenditures September, 2014 August, 2014 July, 2014 June, 2014 May, 2014 April, 2014 March, 2014 February, 2014 January, 2014 December, 2013 November, 2013 October, 2013 September, 2013 HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 PUBLIC UTILITIES FUND FYE 2013 $ 37,598,026 3,571,705 1,790,807 1,358,206 3,349,268 3,056,462 $ 50,724,474 FYE 2013 $ 3,703 27,670,467 4,934,826 5,531 20,065,000 FYE 2014 $ 19,229,033 3,671,291 1,965,319 1,860,402 3,383,463 2,975,052 33,084,560 FYE 2014 $ 3,703 30,275,723 13,281,536 96 473,683 150,000 2014 - 2015 Original Budget 12,381,841 4,397,498 2,349,238 2,336,717 4,167,901 3,486,170 $ 29,119,365 2014 - 2015 Original Budget $ 3,600 26,921,865 1,788,900 5,000 400,000 1,164,682 29,119,365 $ 29,884,047 52,679,527 $ 44,184,741 $ 2014 -2015 Adjusted Budget 13,146, 523 4,397,498 2,349,238 2,336,717 4,167,901 3,486,170 29,884,047 FYE 2015 Activity (includes encumbrances) 1,779,698 646,115 303,334 312,051 937,460 512,297 $ 4,490,955 2014 -2015 Adjusted Budget $ 3,600 $ 26,921,865 1,788,900 5,000 Cash and Investments Cash $ 28,441,620 $ $ 25,475,483 $ $ 25,392,786 $ $ 23,566,116 $ $ 22,909,362 $ $ 24,890,282 $ $ 25,824,291 $ $ 21,864,353 $ $ 21,428,607 $ $ 19,879,494 $ $ 19,734,711 $ $ 17,751,137 $ $ 18,085,580 $ Lockbox * NCCMT Total $ 517,378 $ 28,958,997 $ 516,449 $ 25,991,932 $ 515,469 $ 25,908,254 $ 512,929 $ 24,079,044 $ 511,160 $ 23,420,522 $ 505,012 $ 25,395,294 $ 497,945 $ 26,322,236 $ 458,673 $ 22,323,026 $ 455,673 $ 21,884,280 $ 454,890 $ 20,334,384 $ 453,440 $ 20,188,151 $ 453,180 $ 18,204,317 $ 452,951 $ 18,538,531 * The balance in the Iockbox account is rolled into the cash account before each month closes. Debt Service and Transfer Requirements Interest Principal Transfers Out U: \My Documents \Monthly Reports \2014 - 2015 \September 2014 - Financial Statements.xlsx Current Year $ 2,999,352 $ 4,922,410 $ 1,164,682 $ 9,086,444 FYE 2015 Activity 7,581,031 100,463 14 1,230,196 8,911,704 $4,420,749 Outstanding $ 36,944,577 87,739,896 $ 124,684,473 Solid Waste Total Revenues: Taxes Intergovernmental Revenue Sales & Services Other Revenues Rents, Concess. & Feees Other Finance Sources Interfund Transfers Fund Balance Appropriated Total Revenues over /(under) expenditures September, 2014 August, 2014 July, 2014 June, 2014 May, 2014 April, 2014 March, 2014 February, 2014 January, 2014 December, 2013 November, 2013 October, 2013 September, 2013 HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 FYE 2013 $ 5,073,308 $ 5,073,308 FYE 2013 $ 227,228 4,776,288 638,962 430 582,662 SOLID WASTE FUND FYE 2014 5,161,897 5,161,897 FYE 2014 $ 237,297 5,006,315 378,116 243 739,763 6,225,570 $ Cash $ 783,054 $ 513,937 $ 481,103 $ 709,310 $ 1,018,519 $ 517,264 $ 659,891 $ 929,101 $ 1,206,501 $ 462,549 $ 463,532 $ 598,623 $ (389,231) 2014 - 2015 Original Budget $ 5,358,790 $ 5,358,790 2014 - 2015 Original Budget $ 259,000 5,097,390 2,400 6,361,734 $ Cash and Investments Sun Trust 237,379 202,029 193,679 153,450 153,450 144,082 122,417 98,860 94,942 77,362 70,276 62,630 37,986 2014 - 2015 Adjusted Budget $ 5,394,790 $ 5,394,790 FYE 2015 Activity (includes encumbrances) $ 783,246 $ 783,246 2014 - 2015 Adjusted Budget $ 259,000 $ 25,000 5,097,390 2,400 11,000 FYE 2015 Activity 1,051,342 175 5,358,790 $ 5,394,790 $ 1,051,517 $ 268,271 First Bank NCCMT Total $ 234,622 $ 296,324 $ 1,551,379 $ 206,671 $ 296,324 $ 1,218,960 $ 199,824 $ 242,829 $ 1,117,436 $ 169,118 $ 242,829 $ 1,274,707 $ 169,118 $ 242,829 $ 1,583,916 $ 159,723 $ 190,383 $ 1,011,453 $ 153,463 $ 190,282 $ 1,126,053 $ 110,949 $ 190,282 $ 1,329,192 $ 110,849 $ 127,968 $ 1,540,260 $ 102,262 $ 127,968 $ 770,141 $ 88,219 $ 127,968 $ 749,995 $ 80,153 $ 58,925 $ 800,331 $ 53,459 $ 58,925 $ (238,861) Debt Service and Transfer Requirements Interest Principal Transfers Out U: \My Documents \Monthly Reports \2014 - 2015 \September 2014 - Financial Statements.xlsx Current Year $ 127,786 403,867 Outstanding $ 796,081 3,338,828 $ 531,653 $ 4,134, 909 Paid Claims Fixed Cost Total Revenues: Medical Premiums Fund Balance Appropriated Total Revenues over /(under) expenditures Loss Ratio September, 2014 August, 2014 July, 2014 June, 2014 May, 2014 April, 2014 March, 2014 February, 2014 January, 2014 December, 2013 November, 2013 October, 2013 September, 2013 HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 EDICAL INSURANCE FUND 2014 - 2015 FYE 2013 FYE 2014 Original Budget $ $ - $ 6,000,000 $ - $ $ 1,000,000 $ - $ - $ 7,000,000 FYE 2013 FYE 2014 _ Cash 1,086,724 1,042,547 768,924 U: \My Documents \Monthly Reports \2014 - 2015 \September 2014 - Financial Statements.xlsx $ 2014 - 2015 Original Budget $ 7,000,000 - $ 7,000,000 Cash and Investments NCCMT 543,297 543,297 543,297 Total 1,630,021 1,585,844 1,312,222 2014 - 2015 Adjusted Budget $ 5,490,000 $ 637,000 $ 6,127,000 2014 - 2015 Adjusted Budget $ 6,127,000 $ 6,127,000 FYE 2015 Activity (includes encumbrances) $ 765,780 $ 166,780 $ 932,561 FYE 2015 Activity $ 1,556,901 $ 1,556,901 $ 624,340 59.90% Paid Claims Fixed Cost Total Revenues: Dental Premiums Fund Balance Appropriated Total Revenues over /(under) expenditures Loss Ratio September, 2014 August, 2014 July, 2014 June, 2014 May, 2014 April, 2014 March, 2014 February, 2014 January, 2014 December, 2013 November, 2013 October, 2013 September, 2013 HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 NTAL INSURANCE FUND 2014 - 2015 2014 - 2015 Adjusted FYE 2013 FYE 2014 Original Budget Budget $ $ - $ - $ 340,000 $ - $ - $ - $ 36,000 $ $ $ - $ 376,000 FYE 2013 Cash 203,941 204,905 192,296 U: \My Documents \Monthly Reports \2014 - 2015 \September 2014 - Financial Statements.xlsx 2014 - 2015 FYE 2014 Original Budget $ $ $ - $ 2014 - 2015 Adjusted Budget $ 376,000 FYE 2015 Activity (includes encumbrances) $ 45,447 $ 8,873 $ 54,320 FYE 2015 Activity $ 92,688 - $ 376,000 $ Cash and Investments NCCMT Total 203,941 204,905 192,296 92,688 $ 38,368 58.61%