Loading...
HomeMy WebLinkAboutOrdinance 3531 ORDINANCE NO. 3531 AN ORDINANCE ADOPTING THE BUDGET FOR THE FISCAL YEAR OCTOBER 1, 2018 THROUGH SEPTEMBER 30, 2019, IN ACCORDANCE WITH THE CHARTER OF THE CITY OF NORTH RICHLAND HILLS, TEXAS; PROVIDING FOR THE FILING OF THE BUDGET; ADOPTING THE AMENDED BUDGET FOR OCTOBER 1, 2017 THROUGH SEPTEMBER 30, 2018, PROVIDING FOR INVESTMENTS AND TRANSFERS; PROVIDING A SEVERABILITY CLAUSE AND PROVIDING AN EFFECTIVE DATE. WHEREAS, the City of North Richland Hills is a home rule city acting under its charter adopted by the electorate pursuant to Article XI, Section 5 of the Texas Constitution and Chapter 9 of the Local Government Code; and WHEREAS, the City Manager of the City of North Richland Hills submitted an amended budget for the fiscal year beginning October 1, 2017, and ending September 30, 2018 to the City Council as required by the City Charter of the City of North Richland Hills; and WHEREAS, the City Manager of the City of North Richland Hills submitted a proposed budget for the ensuing fiscal year beginning October 1, 2018, and ending September 30, 2019 to the City Council at least forty-five (45) days prior to the beginning of the fiscal year as required by the City Charter of the City of North Richland Hills; and WHEREAS, the proposed budget meets the requirements of Title 4, Chapter 102, Section 102.003 of Texas Local Government Code; and WHEREAS, the City Council finds that all provisions pertaining to the adoption of the proposed budget and approval of the amended budget contained in the City Charter and in state law have been, in all things complied with; and WHEREAS, in accordance with Section 102.001, et seq, Texas Local Government, the City Council determined that a public hearing should be held at a time and place which was set forth in a notice published as required by law; and WHEREAS, such public hearing on the budget was duly held on August 27, 2018, and all taxpayers were given an opportunity to attend and participate in such public hearing; and WHEREAS, after full and final consideration, the City Council is of the opinion that the budget should be approved and adopted. Ordinance No. 3531 Page 1 of 3 NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF NORTH RICHLAND HILLS, TEXAS, THAT: SECTION 1. The budget of revenues and expenditures of the City of North Richland Hills for the Fiscal Year beginning October 1, 2018 and ending September 30, 2019, as set forth in Attachments A and B, operating and capital projects budgets for FY 2018/2019, is hereby adopted and approved as the said City of North Richland Hills budget for the Fiscal Year beginning the first day of October, 2018, and ending the thirtieth day of September, 2019. SECTION 2. The revised budget of revenues and expenditures of the City of North Richland Hills for the Fiscal Year beginning October 1, 2017 and ending September 30, 2018, as set forth in Attachments A and B, operating and capital projects budgets for FY 2017/2018, is hereby amended. SECTION 3. The budget for Fiscal Year 2018/2019 and the amended budget for Fiscal Year 2017/2018 are on file with the City Secretary in accordance with state law and the City Charter. SECTION 4. The City Manager is hereby authorized to make inter-departmental and inter-fund transfers during the fiscal year as deemed necessary in order to avoid over-expenditure of particular accounts. SECTION 5. The City Manager, or his designee, is hereby authorized to invest any funds not needed for current use in any lawful manner. Interest accrued from investments shall be deposited to the interest income account of the funds from which the principal was invested. SECTION 6. This ordinance shall be cumulative of all provisions of ordinances and of the Code of Ordinances, City of North Richland Hills, Texas, as amended, except where the provisions are in direct conflict with the provisions of other ordinances, in which event the conflicting provisions of the other ordinances are hereby repealed. SECTION 7. It is hereby declared to be the intention of the City Council that the phrases, clauses, sentences, paragraphs and sections of this ordinance are severable, and if any phrase, clause, sentence, paragraph or section of this ordinance shall be declared unconstitutional by the valid judgment or decree of any court of competent jurisdiction, such unconstitutionality shall not affect any of the remaining phrases, clauses, sentences, paragraphs and sections of this ordinance, since the same would have been enacted by the City Council without the incorporation in this ordinance of any such unconstitutional phrase, clause, sentence, paragraph or section. Ordinance No. 3531 Page 2 of 3 SECTION 8. This ordinance shall be in full force and effect from and after its passage as provided by law, and it is so ordained. PASSED AND APPROVED on this the 10th day of September, 2018. CITY 4 OR 4 RICHLAND HILLS f/ K' By: _ A ,kollid!!ti"+'4,;,, Oscar Trevino, Mayor ATTEST: ,\`<‘.� 1, -- Alicia Richardson, ;,t'Iy.•Secre ry ;541 APPROVED AS TO FORM AND LEGALITY: ( 4 Males is B. McGinnis, City Attorney APPROVED AS TO CONTENT: 7)4 -71/ - Robert Myers, Budget & Research Director Ordinance No. 3531 Page 3 of 3 Ordinance 3531 Attachment "A" City of North Richland Hills Fiscal Year 2018/2019 Proposed Budget This budget will raise more total property taxes than last year's budget by $2,331 ,674 or 7.92 percent, and of that amount $454,771 is tax revenue to be raised from new property added to the tax roll this year. The total amount of municipal debt obligations secured by property taxes for the City of North Richland Hills is$119,765,000. Visit our website at:www.nrhtx.com 1 [3 t..:.', _ r L-i.. F3 i ,,,,_,i 1 -,,, ..9; -.1. r : .. . '10 L. .... .._ Li ..... .., ,.. . - . '0 L'..'!..-- ..._... i._.. . „.., - , • il - 1-..i : ! , f , f..., ... L_ ..._ _ ,...... , -• city: of:N h Rich hi:0'nd - HI' llsi , 1 , L.., , . L... ,_ . , _ _ _ .,..........1 ...i ....„ , ....,... . . ... .- [.) .. .. ' ' Li '... L '71! 1 '.. C) D LI 1: 11 " ',.: "i nfl DLU t171.1 11 .,..0 '- r---iLIE T.: - 10 L OD 0 . .. .,......„. -..,„ ....,... n o , .., ___ „........ U "ti-.1r.-.--- ---=•77,,!-.7„...:7,44,-;:op.i,:::.:7,---- ..,,,- .2,-: ' L:'-'-'-4710.t.t*S*ZW::------:-_-,-::-',,,-:-•.'"..fi-,.--,1"-%-44--,4.-2--!f.:::,:-:-..--4'!.. ,44,;,.!''.-:-.x...c:..INii.-ii,s-f.-.1.-117:74,ti'44-- --. -tr c-:,. .'". -*','':-1--- - -' ---- - .----:. - .....---: - --.,i'ig;1VE---Vt-1.-.A- -:.-ii---g(---1--"4:.,-;:.:F.;-.,:-.:27...'ii:;..-frf-4:.f:-. ::::-.:*--,•-..-'-::::•'1.4. --if:'•i--=.1.!::,*".!!IP:Siglif-iLA::Aiarft- --4''''''-.4-,.., :-.F.-",,M..,.!,--.-tiw.,--,z-i,----,<.,-A-...-,-,----=;-: ,.r.:--..: ..,",-,".'-r- -- -.,„-,-,,,.--::',4-:,.-*41,, _ .:-.;1%*.if104;rj.-.=-:.i',"' -^1,,,`,?!':t . N:''''''T't-t•-°-I5 *-;-'4:-:-2';''':::'";''.':: :.:;41v.:ir,--.--:-.-.._;.,:,-,ir,':„.---ct-Z.t.4L: i't-,,,.---.*:Allitil"-4.-:-. "- -_,-i..,-,-.1„-74...tittiPr ___,.._..,....--------'4:-;.:44':--•--,....,;.;-:- .-----'.-..-,:i: :: ...-,-- ..4';'''':11.171!2"jli21-'7,;:-......'i_'-'5-..':". . '. i%7:47;,...ii,-.:,..4.,::,-6,4 -i:kli-V -. -4.41.1tz..4.p.:-Azz>1-1.:,`.2..i.i?..t1,,--!n4 •--'' ' . •.. - -- ---::-.-- :::-,-,,w..-7-,.. ..."..'4'; -.'1-•..-';‘44/7""'"‘'-' -' `' .7''.;7-.7:"":" rit:W;W7f.-:-.:01-- - " '-, - '. —'-'---1,::. .1:-::---:: -::'-:•-: '1.".:444iit P'''', - , '''''''''. :4 at'F;;:t4:41.ififzW,IStil,g4-‘ - --,-45'; ' . ' . :. ' ., LA -33---333-33333 33-3=-4333343.4. 33-33:3;43:3,-333,331.*M334,3,337.33331.433,31331-33-333-3,3333;33-333-3 hij *33 . i . - - i •-- ',.' ' ' i ' ,c-k!'1 I --- ii II * ., ' ----- mi- . . • . • , ,.f. . ' .......______ i : • • ,...,:;, tiseg_ „.1.. . . . . . . . ., , 1111iiAir .. -t ' -.. - (*' 1... ... ...... I. - - J; , . .4 i',.-14.,:li i pr:. . '.. ,-, 3.1;4 '' ' .•.• i'. .i.,y-,'.i.,:t4,!..1... .. :.,- .t- ... --.! - 7' ..;..?.*::.t:..: ,, .: r I :,:;:-. :P,;', -:.-.'-''''--..4:-.'-'-f- F.. .'*-,:.,1".:,-*..:.:,..z.,t;,..:-nS;;:;2`. 1.,?-7_.=_-_:MI;z:...-.:-...=,.*- -`,-rj--;S,P,,4,-.:.f.;', '"rt:,",;-:::'':',.7".'14--.0-*"....„;',:flftiVi--:''.*-tii..;":"-_-`ii7-47"..-"-*---':.."''-.t--'-'r.-''.!."':-.-.•-'-.'r.:i:-::':?.;r:',''4. Proposed Operating Budget . . . . . , . . ..,. , Created b4../: JeN3,133.14,314.e.43 C,c3,33t3e3t,t434,3.4-s FISCAL YEAR 2018-2019 SUMMARY OF REVENUES AND EXPENDITURES CITY-WIDE FUNDS AT A GLANCE ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES General Fund $ 48,669,263 $ 46,543,427 $ 46,606,612 $ 47,565,387 $ 48,363,805 General Debt Service 13,968,299 13,338,381 11,762,764 11,762,764 12,187,902 Park and Recreation Fund 8,653,798 9,850,226 9,000,504 9,091,172 8,949,141 Crime Control District Fund 5,280,923 6,409,746 5,380,595 5,426,880 5,567,958 Promotional Fund 284,900 283,127 259,022 287,939 285,500 Donations Fund 330,251 402,600 322,004 442,255 327,802 Special Investigations Fund 517,221 298,123 252,300 265,600 261,325 Drainage Utility Fund 888,797 1,193,790 1,190,524 1,340,858 1,649,755 Gas Development Fund 6,269,658 456,827 312,673 528,300 528,300 Traffic Safety Fund 1,328,289 1,130,060 1,008,016 1,061,792 1,096,015 Utility Fund 36,658,064 33,513,452 34,336,777 36,130,719 35,364,459 Aquatic Park Fund 4,715,681 5,583,880 5,268,439 4,581,259 4,568,509 Golf Course Fund 2,656,679 2,687,743 2,575,071 2,491,415 2,601,454 TOAL REVENUES $ 130,221,823 $ 121,691,382 $ 118,275,301 $ 120,976,340 $ 121,751,925 EXPENDITURES General Fund $ 47,037,737 $ 45,280,397 $ 46,606,612 $ 47,565,387 $ 48,363,805 General Debt Service 13,707,505 13,314,573 11,762,764 11,762,764 12,187,902 Park and Recreation Fund 7,826,716 9,711,159 9,000,504 9,091,172 8,949,141 Crime Control District Fund 5,095,059 6,359,027 5,380,595 5,426,880 5,567,958 Promotional Fund 209,876 238,336 259,022 287,939 285,500 Donations Fund 218,327 269,185 311,099 406,547 298,388 Special Investigations Fund 384,814 299,653 252,300 265,600 261,325 Drainage Utility Fund 684,348 1,097,838 1,190,524 1,340,858 1,649,755 Gas Development Fund 6,022,309 70,174 312,673 528,300 528,300 Traffic Safety Fund 1,010,523 1,044,272 1,008,016 1,061,792 1,096,015 Utility Fund 35,469,014 32,654,650 34,336,777 36,130,719 35,364,459 Aquatic Park Fund 4,715,681 5,583,881 5,268,439 4,581,259 4,568,509 Golf Course Fund 2,656,679 2,762,464 2,575,071 2,491,415 2,601,454 TOTAL EXPENDITURES $ 125,038,588 $ 118,685,609 $ 118,264,396 $ 120,940,632 $ 121,722,511 BALANCE $5,183,234 $3,005,774 $10,905 $35,708 $29,414 This chart does not include TIF debt or Internal Service Funds such as Fleet Services,Facilities and Construction Management,Information Technology,and Self Insurance. 3 FISCAL YEAR 2018-2019 SCHEDULE 1-SUMMARY OF REVENUES AND EXPENDITURES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES Taxes $30,382,593 $31,174,148 $32,144,108 $32,326,156 $33,675,379 Fines&Forfeitures 1,892,511 2,212,430 2,175,366 2,001,919 2,137,226 Licenses&Permits 2,796,748 2,670,456 2,205,406 2,362,357 2,205,100 Charges for Service 2,421,983 2,373,761 2,401,541 2,298,330 2,458,053 Intergovernmental 5,215,730 5,433,392 5,446,957 5,453,195 5,515,015 Miscellaneous 1,601,013 2,549,240 2,233,234 2,788,347 2,373,032 SUB-TOTAL $44,310,579 $46,413,427 $46,606,612 $47,230,304 $48,363,805 APPROPRIATION FROM FUND BALANCE Legal Settlement&Litigation $0 $0 $0 $0 $0 Court Technology Fund 59,851 130,000 0 49,950 0 Utility Assistance Program 0 0 0 0 0 PEG Fees 0 0 0 0 0 Record Preservation Fee 0 0 0 0 0 Previous Year Encumbrances 428,833 0 0 285,133 0 General Fund Reserves 3,870,000 0 0 0 0 SUB-TOTAL APPROPRIATIONS $4,358,684 $130,000 $0 $335,083 $0 TOTAL REVENUES $48,669,263 $46,543,427 $46,606,612 $47,565,387 $48,363,805 EXPENDITURES City Council $119,155 $123,193 $131,079 $131,079 $133,893 City Manager 637,412 637,328 667,063 667,769 686,945 Communications 344,974 363,033 367,310 380,323 383,452 City Secretary 399,561 407,739 447,396 440,565 460,637 Legal 337,071 292,596 385,803 370,399 411,439 Human Resources 131,385 130,520 150,464 150,345 136,869 Finance 682,896 698,913 720,828 707,766 746,670 Budget&Research 366,334 354,072 412,093 405,638 417,313 Municipal Court 1,382,680 1,420,784 1,388,506 1,456,680 1,402,604 Planning and Inspections 1,054,078 1,129,531 1,271,250 1,300,823 1,334,141 Economic Development 325,017 322,752 336,148 336,766 350,163 Library 1,960,936 2,102,149 2,200,342 2,204,488 2,219,861 Neighborhood Services 1,701,576 1,722,233 1,978,654 2,003,763 2,071,606 Public Works 3,061,675 3,110,625 3,185,518 3,231,953 3,340,412 Parks&Recreation 2,033,662 2,083,853 2,148,142 2,115,506 2,138,611 Police 13,208,533 13,473,858 14,440,270 14,643,642 15,014,364 Emergency Management 795,810 976,835 0 0 0 Fire 11,049,544 11,608,211 12,931,029 13,261,754 13,621,936 Building Services 848,774 836,737 812,101 812,101 812,101 Non-Departmental 1,112,210 841,749 1,067,329 1,085,684 1,111,037 SUB-TOTAL DEPARTMENTS $41,553,282 $42,636,711 $45,041,325 $45,707,044 $46,794,054 RESERVES&OTHER EXPENDITURES Reserves $1,180,306 $1,369,492 $1,180,291 $1,359,574 $137,259 Transfers Out 4,050,653 513,055 187,725 264,179 1,229,492 Other 253,495 761,140 197,271 234,590 203,000 SUB-TOTAL RESERVES AND OTHER $5,484,454 $2,643,687 $1,565,287 $1,858,343 $1,569,751 TOTAL EXPENDITURES $47,037,737 $45,280,397 $46,606,612 $47,565,387 $48,363,805 BALANCE $1,631,526 $1,263,030 $0 $0 $0 4 FISCAL YEAR 2018-2019 SCHEDULE 2-SUMMARY OF REVENUES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015116 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 TAXES Current Property Taxes $14,813,054 $15,609,935 $15,966,660 $16,227,086 $17,279,976 Delinquent Property Taxes 59,740 98,895 264,799 167,000 217,977 Penalty and Interest 123,473 135,401 135,200 157,800 135,200 Franchise Fees 4,360,700 3,968,853 4,103,418 4,063,059 4,064,328 Utility Fund Franchise Taxes 823,128 895,441 943,831 981,011 1,020,989 Sales Taxes 9,675,943 9,929,417 10,192,046 10,192,046 10,395,887 Mixed Beverages 139,062 145,222 145,333 145,333 145,333 Payment in Lieu of Taxes 387,493 390,983 392,821 392,821 415,689 SUB-TOTAL $30,382,593 $31,174,148 $32,144,108 $32,326,156 $33,675,379 FINES AND FORFEITURES Municipal Court Fines $1,661,309 $1,954,602 $1,926,790 $1,776,647 $1,888,650 Warrant&Arrest Fees 168,976 198,758 188,576 171,272 188,576 Library Fines 62,227 59,070 60,000 54,000 60,000 SUB-TOTAL $1,892,511 $2,212,430 $2,175,366 $2,001,919 $2,137,226 LICENSES AND PERMITS Building Permits $1,601,749 $1,405,784 $1,076,000 $1,128,234 $1,140,560 Electrical Permits 84,552 61,695 50,000 80,000 63,600 Plumbing Permits 150,256 146,448 126,950 126,950 134,567 Mechanical Permits 93,281 107,875 77,000 90,000 87,980 Gas Drilling Permits 0 0 0 226 0 Burglar Alarm Permits 89,755 83,940 100,000 86,800 86,800 Miscellaneous Permits 92,875 89,873 86,881 83,200 91,328 Apartment Inspection Fees 100,646 100,877 102,400 102,400 104,800 Curb&Drainage Insp.Fees 56,117 142,307 62,569 73,078 62,569 Re-Inspection Fees 19,996 29,829 21,000 24,000 24,000 License Fees 19,425 22,185 19,000 31,013 19,000 Contractor Registration Fees 97,795 89,265 93,050 82,400 0 Plan/Review/Application Fee 37,334 94,778 38,743 48,656 38,743 Animal License/Adoption Fees 62,979 72,631 66,000 73,500 73,500 Animal Control Impoundment 23,972 22,837 23,825 13,300 23,000 Auto Impoundment Fees 12,402 15,463 13,000 15,200 15,200 Food Service Permits 157,936 158,581 161,053 169,000 161,053 Food Managers School 5,278 7,177 7,935 5,400 5,400 Fire Inspection/Alarm Fees 90,400 18,911 80,000 129,000 73,000 SUB-TOTAL $2,796,748 $2,670,456 $2,205,406 $2,362,357 $2,205,100 CHARGES FOR SERVICE Park Facility Rental $7,378 $9,074 $8,325 $8,150 $10,050 Ambulance Fees 1,737,332 1,688,414 1,706,000 1,661,873 1,727,500 Garbage Billing 429,813 448,063 440,891 466,450 485,108 Contributions 10,000 10,000 10,000 10,000 10,000 Recreation Fees 560 700 400 1,170 770 Athletic Revenue 119,694 107,979 119,625 42,529 123,250 Recreation Special Events 10,197 (240) 10,000 3,810 4,000 Planning&Zoning Fees 41,496 43,547 40,000 45,700 40,000 Sale of Accident Reports 7,129 7,435 7,300 8,400 7,300 Vital Statistics 0 0 0 0 0 Mowing 53,348 51,749 53,000 44,000 44,000 Fire Dept Certification/CPR Citizen Class 4,959 6,946 6,000 6,000 6,000 Miscellaneous 78 95 0 248 75 SUB-TOTAL $2,421,983 $2,373,761 $2,401,541 $2,298,330 $2,458,053 5 FISCAL YEAR 2018-2019 SCHEDULE 2-SUMMARY OF REVENUES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 INTERGOVERNMENTAL Indirect Costs: Utility Fund 2,194,831 2,304,572 2,304,572 2,304,572 2,304,572 Park&Rec Facilities Dev.Corp. 448,405 498,988 498,789 500,425 499,065 Crime Control District 22,821 52,124 29,582 31,218 29,858 Aquatic Park Fund 158,696 166,631 174,963 174,963 174,963 Consolidation Reimbursements 2,390,977 2,411,077 2,439,051 2,442,017 2,506,557 SUB-TOTAL $5,215,730 $5,433,392 $5,446,957 $5,453,195 $5,515,015 MISCELLANEOUS Interest Income $111,336 $129,320 $117,282 $208,700 $208,700 Radio Reimbursement 234,422 257,395 273,609 265,117 273,607 Sale of City Property 10,981 258,962 3,000 41,956 3,000 Grant Proceeds 0 0 84,249 54,969 54,000 Overtime Reimbursements 5,057 13,866 5,000 7,693 5,000 Teen Court Reimbursement 20,300 20,300 20,114 20,114 20,114 Other Income 112,096 122,347 129,980 589,798 708,611 Golf Course Loan Repayment 147,760 147,760 0 0 0 Designated Funds for City Hall Project Debt 959,062 1,599,289 1,600,000 1,600,000 1,100,000 SUB-TOTAL $1,601,013 $2,549,240 $2,233,234 $2,788,347 $2,373,032 APPROPRIATION-FUND BALANCE Legal Settlement&Litigation $0 $0 $0 $0 $0 Court Technology Funds 59,851 130,000 0 49,950 0 Utility Assistance Program 0 0 0 0 0 PEG Fees 0 0 0 0 0 Record Preservations Fee 0 0 0 0 0 Previous Year Encumbrances 428,833 0 0 285,133 0 General Fund Designated Reserves 3,870,000 0 0 0 0 SUB-TOTAL $4,358,684 $130,000 $0 $335,083 $0 TOTAL REVENUES $48,669,263 $46,543,427 $46,606,612 $47,565,387 $48,363,805 6 FISCAL YEAR 2018-2019 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 EXPENDITURES City Council $119,155 $123,193 $131,079 $131,079 $133,893 City Manager $637,412 $637,328 $667,063 $667,769 $686,945 Communications Public Information $230,571 $244,572 $247,870 $255,496 $262,583 Citicable 114,403 118,461 119,440 124,827 120,869 Total Communications $344,974 $363,033 $367,310 $380,323 $383,452 City Secretary City Secretary $288,668 $310,602 $339,701 $340,054 $350,211 Record Management 110,892 97,137 107,695 100,511 110,426 Total City Secretary $399,561 $407,739 $447,396 $440,565 $460,637 Legal $337,071 $292,596 $385,803 $370,399 $411,439 Human Resources $131,385 $130,520 $150,464 $150,345 $136,869 Finance Accounting&Administration $461,137 $455,438 $461,784 $456,797 $477,828 Purchasing 221,759 243,475 259,044 250,969 268,842 Total Finance $682,896 $698,913 $720,828 $707,766 $746,670 Budget&Research Budget $151,577 $135,721 $162,867 $180,481 $189,442 Tax 191,613 201,806 225,157 225,157 227,871 Internal Audit 23,144 16,546 24,069 0 0 Total Budget&Research $366,334 $354,072 $412,093 $405,638 $417,313 Municipal Court Administration/Prosecution $477,794 $451,630 $367,483 $401,404 $365,597 Court Records 457,649 468,705 497,022 517,359 505,872 Warrants 351,547 407,834 417,696 431,259 419,683 Teen Court 95,691 92,615 106,305 106,658 111,452 Total Municipal Court $1,382,680 $1,420,784 $1,388,506 $1,456,680 $1,402,604 Planning and Development Planning&Administration 266,585 325,297 346,773 347,761 361,699 Inspections 787,492 804,234 924,477 953,062 972,442 Total Planning and Development $1,054,078 $1,129,531 $1,271,250 $1,300,823 $1,334,141 Economic Development $325,017 $322,752 $336,148 $336,766 $350,163 Library General Services $292,901 $357,178 $391,225 $391,842 $405,116 Public Services 807,046 894,607 912,701 914,289 944,292 Technical Services 860,990 850,364 896,416 898,357 870,453 Total Library $1,960,936 $2,102,149 $2,200,342 $2,204,488 $2,219,861 7 FISCAL YEAR 2018-2019 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 Neighborhood Services Neighborhood Resources $305,443 $307,995 $337,406 $337,982 $352,655 Animal Services 682,246 704,283 770,927 805,800 819,985 Consumer Health 318,341 317,846 333,331 337,233 349,760 Code Compliance 395,547 392,109 536,990 522,748 549,206 Total Neighborhood Services $1,701,576 $1,722,233 $1,978,654 $2,003,763 $2,071,606 Public Works General Services $314,271 $307,407 $348,214 $348,655 $359,393 Traffic Control 1,118,882 1,171,674 1,060,840 1,120,083 1,099,309 Street&Drainage 1,628,522 1,631,544 1,776,464 1,763,215 1,881,710 Total Public Works $3,061,675 $3,110,625 $3,185,518 $3,231,953 $3,340,412 Parks&Recreation General Services $180,743 $168,557 $176,408 $176,514 $178,450 Parks Maintenance 893,018 940,970 954,402 969,279 926,488 Recreation Services 487,102 487,102 487,102 487,102 487,102 Athletic Program Services 165,716 171,090 196,186 144,619 197,355 Senior Adult Services 267,035 276,754 287,908 291,856 303,080 Youth Outreach&Cultural 40,049 39,379 46,136 46,136 46,136 Total Parks&Recreation $2,033,662 $2,083,853 $2,148,142 $2,115,506 $2,138,611 Police General Services $1,123,316 $1,134,358 $1,153,635 $1,194,841 $1,201,242 Administrative Services 478,814 557,921 578,388 601,838 602,247 Criminal Investigations 2,466,203 2,500,286 2,625,500 2,660,268 2,738,937 Uniform Patrol 5,163,999 5,292,948 5,562,210 5,682,772 5,939,640 Detention Services 1,501,067 1,530,825 1,642,093 1,645,833 1,717,916 Property Evidence 321,507 314,122 529,136 564,093 367,896 Communications 2,153,627 2,143,397 2,349,308 2,293,997 2,446,486 Total Police $13,208,533 $13,473,858 $14,440,270 $14,643,642 $15,014,364 Emergency Management $795,810 $976,835 $0 $0 $0 Fire Department General Services $384,216 $398,372 $439,947 $449,653 $440,811 Operations 8,498,293 8,794,647 9,290,758 9,293,999 9,850,851 Emergency Medical 1,503,372 1,770,525 1,578,105 1,763,574 1,758,750 Fire Inspections 663,662 644,666 765,133 768,343 705,206 Emergency Management 0 0 857,086 986,185 866,318 Total Fire $11,049,544 $11,608,211 $12,931,029 $13,261,754 $13,621,936 Building Services $848,774 $836,737 $812,101 $812,101 $812,101 Non Departmental $1,112,210 $841,749 $1,067,329 $1,085,684 $1,111,037 SUB-TOTAL DEPARTMENTS $41,553,282 $42,636,711 $45,041,325 $45,707,044 $46,794,054 8 FISCAL YEAR 2018-2019 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 RESERVES&OTHER EXPENDITURES Other Economic Development Incentives $103,495 $234,630 $197,271 $214,000 $203,000 Legal Settlement 150,000 526,510 0 20,590 0 Other Total $253,495 $761,140 $197,271 $234,590 $203,000 Transfers Capital Projects $3,924,950 $180,000 $25,000 $101,454 $1,094,000 Capital Projects-Sidewalk Maintenance 50,000 50,000 50,000 50,000 50,000 Fleet Services 0 0 0 0 0 Special Investigations 0 105,080 0 0 0 Information Services 75,703 77,975 82,725 82,725 85,492 Neighborhood Revitalization Program 0 100,000 30,000 30,000 0 Transfers Total $4,050,653 $513,055 $187,725 $264,179 $1,229,492 Contribution to Reserves General Fund Reserves $1,000,000 $1,215,141 $1,025,941 $1,218,753 $6,066 Public, Educational,Governmental(PEG)Fees 180,306 154,351 154,350 140,821 131,193 Tranportation Projects(Future) 0 0 0 0 0 Contribution to Reserves Total $1,180,306 $1,369,492 $1,180,291 $1,359,574 $137,259 TOTAL RESERVES&OTHER EXPENDITURES $5,484,454 $2,643,687 $1,565,287 $1,858,343 $1,569,751 TOTAL EXPENDITURES $47,037,737 $45,280,397 $46,606,612 $47,565,387 $48,363,805 BALANCE $1,631,526 $1,263,030 $0 $0 $0 9 FISCAL YEAR 2018-2019 SCHEDULE 4-SUMMARY OF PROPERTY TAX REVENUE AND DISTRIBUTION NET TAXABLE VALUE: M&O I&S TOTAL Total Appraised Value as of July 25,2018 6,927,461,437 Less: Absolute Exemption (428,700,070) Cases Before ARB (127,060,962) Incomplete Accounts (118,978,455) Disabled Veteran (25,987,537) Over 65 (182,593,096) Homestead (507,027,493) Disabled Persons (8,801,529) Freeport Inventory Value Loss (4,332,253) Pollution Control 0 Solar&Wnd Powered Devices (5) Nominal Value Accounts (493,506) Miscellaneous Personal Property (11,798,271) In Process 0 Total Reduction to Values (1,415,773,177) NET TAXABLE VALUE AT JULY 25,2018 5,511,688,260 Add: Estimated Minimum ARB protested values 85,155,894 Incomplete Property 53,761,005 ESTIMATED NET TAXABLE VALUE AT JULY 25,2018 5,650,605,159 ESTIMATED PROPERTY TAX COLLECTIONS: Estimated Net Taxable Value 5,650,605,159 Less:TIF#1 Incremental Value(Closed 2018) 0 Less:TIF#1A Incremental Value (16,148,540) Less:TIF#2 Incremental Value (484,980,109) Less:Tax Ceiling Taxable Values (762,250,843) Net Taxable Values 4,387,225,667 Proposed Tax Rate per$100 Valuation 0.327088 0.257912 0.585000 Estimated Total Tax Levy at 100%Collection 14,350,089 11,315,208 25,665,297 Less:Estimated Uncollectable(1.5%) (215,251) (215,251) Less:Estimated I&S Uncollectable(1.5%) (169,728) (169,728) Estimated Revenue from Property Tax 13,965,110 11,315,208 25,280,318 Estimated Revenue from Property Tax* 13,965,110 11,315,208 25,280,318 Plus:Tax Ceiling Account Revenue 3,265,120 - 3,265,120 Less:Estimated Uncollectable(1.5%) (48,977) - (48,977) Plus:TIF Tax Rate Differential(2 cents) 100,226 - 100,226 Less:Estimated l&S Uncollectable(1.5%) (1,503) - (1,503) ESTIMATED PROPERTY TAX DISTRIBUTION 17,279,976 11,315,208 28,595,184 10 FISCAL YEAR 2018-2019 SCHEDULE 5-SUMMARY OF REVENUES AND EXPENDITURES GENERAL DEBT SERVICE FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES General Debt Service Taxes $8,391,108 $9,674,703 $10,683,052 $10,683,052 $11,315,208 SUB-TOTAL AD VALOREM TAXES $8,391,108 $9,674,703 $10,683,052 $10,683,052 $11,315,208 Transfer in From: Drainage Utility $553,789 $373,018 $362,674 $362,674 $261,139 Park&Rec.Facilities Dev.Corp 329,055 320,393 627,685 627,685 524,550 Fleet Services Fund 480,406 448,414 0 0 0 Facilities Services Fund 27,399 26,193 0 0 0 Donations Fund 34,849 41,400 0 0 0 SUB-TOTAL TRANSFER IN $1,425,498 $1,209,418 $990,359 $990,359 $785,689 Proceeds Bond Issuance Proceeds $1,046,865 $1,754,180 $0 $0 $0 Interest Income 15,418 8,415 6,500 4,152 4,152 City of Watauga,CIP Participation 82,853 82,853 82,853 82,853 82,853 Miscellaneous Revenues 31 1,092 0 0 0 Transfer In 2,424,790 607,721 0 0 0 Appropriation of Fund Balance 581,736 0 0 2,348 0 SUB-TOTAL OTHER $4,151,693 $2,454,260 $89,353 $89,353 $87,005 TOTAL REVENUES $13,968,299 $13,338,381 $11,762,764 $11,762,764 $12,187,902 EXPENDITURES Existing Bonds&C.O.'s $12,641,854 $11,539,266 $11,724,765 $11,724,765 $12,146,203 Issuance Costs/Paying Agent Fees 45,517 93,288 37,999 37,999 41,699 Bond Defeaseance/Refunding 1,020,134 1,682,019 0 0 0 TOTAL EXPENDITURES $13,707,505 $13,314,573 $11,762,764 $11,762,764 $12,187,902 BALANCE $260,794 $23,809 $0 $0 $0 11 FISCAL YEAR 2018-2019 SCHEDULE 6-SUMMARY OF TAX INCREMENT FINANCE(TIF)DISTICT PROPERTY TAX REVENUE AND DISTRIBUTION NET TAXABLE VALUE: TAX INCREMENT FINANCING DISTRICT#1A Taxable Value(2018 Tax Year) $100,556,700 Less: Base Taxable Value(2008 Tax Year) 83,563,510 Taxable Value Increment(2018 Tax Year) Gain/(Loss): $16,993,190 TAX INCREMENT FINANCING DISTRICT#2 Taxable Value(2018 Tax Year) $504,922,969 Less: Base Taxable Value(1998 Tax Year) 40,020,188 Taxable Value Increment(2018 Tax Year) Gain/(Loss): $464,902,781 ESTIMATED TAX INCREMENT FINANCING DISTRICT PROPERTY TAX REVENUE TAX INCREMENT FINANCING DISTRICT#1A Current Taxable Value Increment:TIF District#1A $16,993,190 Tax Rate per$100 Valuation and Inception $0.57 Estimated TIF District#1A Property Tax Revenue at 100% $96,861 Estimated Collection Rate 98.50% Estimated TIF District#1A Property Tax Revenue $95,408 TAX INCREMENT FINANCING DISTRICT#2 Current Taxable Value Increment:TIF District#2 $464,902,781 Tax Rate per$100 Valuation and Inception $0.57 Estimated TIF District#2 Property Tax Revenue at 100% $2,649,946 Estimated Collection Rate 98.50% Estimated TIF District#2 Property Tax Revenue $2,610,197 TOTAL ESTIMATED TAX INCREMENT FINANCING DISTRICT PROPERTY TAX REVENUE(1)(2) $2,705,605 Notes: (I)The information presented on this schedule represents the contribution of the City of North Richland Hills to the Tax Increment Financing Districts in which it participates. This schedule does not reflect the contribution of other entities. (2)TIF#1 Closed in 2018. 12 FISCAL YEAR 2018-2019 SCHEDULE 7-SUMMARY OF REVENUES AND EXPENDITURES TAX INCREMENT FINANCING FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 TAX INCREMENT FINANCING DISTRICT#1 REVENUES Tax Increment Financing District#1 Taxes City of North Richland Hills 22,458 $45,432 $46,730 $46,730 $95,408 Tarrant County Hospital District 16,726 18,164 18,968 18,968 38,178 Tarrant County College District 10,972 11,536 12,046 12,046 23,816 Tarrant County 19,376 0 21,141 21,141 41,507 Birdville ISD 106,705 115,882 121,009 121,009 0 Sub-Total 176,236 $191,014 $219,894 $219,894 $198,909 Other Funding Sources Investment Income 7,687 $3,313 $5,816 $11,440 $11,440 Bond Defeasance/Refunding Proceeds 0 0 0 0 0 Appropriation of Fund Balance 497,745 471,719 433,935 433,935 0 Sub-Total 505,432 $475,032 $439,751 $445,375 $11,440 TOTAL REVENUES 681,668 $666,047 $659,645 $665,269 $210,349 EXPENDITURES&TRANSFERS TIF#1 Debt Service 681,668 $666,046 $659,645 $659,645 $111,958 Bond Defeasance/Refunding 0 0 0 0 0 TOTAL EXPENDITURES 681,668 $666,046 $659,645 $659,645 $111,958 BALANCE 0 $0 $0 $5,624 $98,391 TAX INCREMENT FINANCING DISTRICT#2 REVENUES Tax Increment Financing District#2 Taxes City of North Richland Hills 1,568,740 $1,896,052 $2,307,648 $2,307,648 $2,610,197 Tarrant County Hospital District 691,531 811,368 998,181 998,181 1,115,729 Tarrant County College District 453,674 517,776 633,902 633,902 696,316 Tarrant County 801,082 879,200 1,112,493 1,112,493 1,213,025 Sub-Total 3,515,026 $4,104,396 $5,052,224 $5,052,224 $5,635,267 Other Funding Sources Investment Income 12,003 $1,938 $0 $0 $0 Bond Defeasance/Refunding Proceeds 997,157 $0 $0 $0 $0 Sub-Total 1,009,160 $1,938 $0 $0 $0 TOTAL REVENUES 4,524,186 $4,106,334 $5,052,224 $5,052,224 $5,635,267 EXPENDITURES&TRANSFERS TIF#2 Debt Service 2,146,045 $2,346,287 $2,292,323 $2,292,323 $2,232,753 Bond Defeasance/Refunding 1,005,586 0 0 0 0 Sub-Total 3,151,631 2,346,287 2,292,323 2,292,323 2,232,753 TOTAL EXPENDITURES 3,151,631 2,346,287 2,292,323 2,292,323 2,232,753 BALANCE 1,372,555 $1,760,047 $2,759,901 $2,759,901 $3,402,514 13 FISCAL YEAR 2018-2019 SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES Sales Tax $4,837,974 $4,964,710 $5,095,823 $5,095,823 $5,197,739 Interest Income 26,801 35,561 26,160 40,732 40,600 Youth Assn.Maintenance Fees 38,245 72,845 44,500 36,300 35,500 Tennis Center Revenue 368,664 356,075 372,550 359,050 365,300 Transfer in from Aquatic Park Fund 81,248 83,685 87,869 0 0 Park Impact Fees 104,351 82,121 70,000 95,000 95,000 Grants/Foundation 95,686 50,000 0 0 0 Other Income 50,733 20,952 500 16,603 900 SUB-TOTAL $5,603,703 $5,665,949 $5,697,402 $5,643,508 $5,735,039 NRH CENTRE Memberships/Drop-In Passes $1,385,697 $1,347,606 $1,420,000 $1,390,000 $1,390,000 Fitness 450,633 464,730 429,000 474,600 465,000 Recreation/Sports 237,921 223,099 274,000 278,688 281,000 Grand Hall Rental 184,074 271,875 232,100 368,450 273,100 Catering&Event Fees 11,062 17,536 17,900 21,300 17,900 Aquatic Programs 224,422 255,350 237,500 240,000 245,000 Pool Rental 3,200 3,574 5,500 4,000 4,000 Gym Rental 3,108 2,352 4,000 4,000 4,000 Concessions/Merchandise 24,602 17,077 27,000 24,524 27,000 Special Events 8,802 8,289 10,000 10,000 10,000 Other 20,705 14,379 24,000 10,000 10,000 General Fund 487,102 487,102 487,102 487,102 487,102 SUB-TOTAL $3,041,328 $3,112,969 $3,168,102 $3,312,664 $3,214,102 APPROPRIATION OF FUND BALANCE Prior Year Encumbrances $8,767 $41,307 $0 $0 $0 Appropriation of Park Impact Fee Reserves 0 900,000 135,000 135,000 0 Appropriation of Sales Tax Reserves 0 130,000 0 0 0 SUB-TOTAL $8,767 $1,071,307 $135,000 $135,000 $0 TOTAL REVENUES $8,653,798 $9,850,226 $9,000,504 $9,091,172 $8,949,141 14 FISCAL YEAR 2018-2019 SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 EXPENDITURES OPERATING Park Facilities Development Admin. $731,370 $828,882 $764,159 $764,758 $846,010 Parks&Public Grounds 1,894,305 1,994,481 2,155,009 2,140,539 2,174,057 Tennis Center Operations 562,987 550,292 616,486 617,545 627,412 SUB-TOTAL $3,188,661 $3,373,655 $3,535,654 $3,522,842 $3,647,479 NRH CENTRE Center Management $636,010 $676,213 $792,553 $747,729 $776,077 Fitness 481,875 414,846 395,271 395,271 404,955 Building Operations 197,335 254,584 203,842 204,251 218,334 Aquatic 539,337 538,999 625,629 671,768 653,093 Recreation Sports 293,449 279,242 358,837 379,851 291,862 Event Center 249,876 260,687 362,838 408,069 300,451 Building Services 360,750 351,900 294,150 284,090 274,090 SUB-TOTAL $2,758,632 $2,776,471 $3,033,120 $3,091,029 $2,918,862 OTHER&RESERVES Debt Services-CO's $329,055 $320,393 $627,685 $627,685 $524,550 Indirect Costs 448,405 498,988 498,789 500,425 499,065 Non-Departmental 83,209 165,151 50,127 69,212 52,402 Transfers to Capital Projects Capital Projects 510,544 913,180 575,400 575,400 569,000 Capital Projects-Grant/Donation/Foundation 0 150,000 0 0 0 Capital Projects-Impact Fees 55,000 1,100,000 205,000 205,000 89,000 Contributions to Reserves Operating Reserve 0 0 211,938 150,548 343,600 Impact Fee Reserve 49,351 0 0 0 0 Economic Development Reserve 120,949 124,118 127,396 127,396 129,943 NRH Centre Reserve 282,909 289,204 135,395 221,635 175,240 SUB-TOTAL $1,879,422 $3,561,033 $2,431,730 $2,477,301 $2,382,800 TOTAL EXPENDITURES $7,826,716 $9,711,159 $9,000,504 $9,091,172 $8,949,141 BALANCE $827,082 $139,066 $0 $0 $0 15 FISCAL YEAR 2018-2019 SCHEDULE 9-SUMMARY OF REVENUES AND EXPENDITURES CRIME CONTROL DISTRICT ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES Sales Tax $4,810,105 $4,944,187 $5,069,844 $5,069,844 $5,171,241 Franchise Tax 76,443 47,129 87,248 96,127 96,127 Interest Income 4,347 4,531 3,028 6,990 2,465 SRO Reimibursement(BISD) 198,650 209,520 210,918 219,296 226,194 Other 39,159 7,220 0 25,066 55,086 Prior Year Encumbrances 152,219 70,214 0 0 0 Appropriation of Fund Balance 0 1,126,946 9,557 9,557 16,845 TOTAL REVENUES $5,280,923 $6,409,746 $5,380,595 $5,426,880 $5,567,958 EXPENDITURES Administration $115,215 $10,177 $9,500 $9,500 $9,500 Administrative Services 850,948 931,368 1,006,895 1,008,306 1,126,890 Investigations 419,162 481,350 510,117 503,731 491,527 Uniform Patrol 2,840,031 2,866,629 3,046,166 3,042,487 2,998,357 Technical Services 506,928 532,098 565,477 566,712 556,876 Property Evidence 188,672 267,545 30,400 33,235 214,443 SUB-TOTAL $4,920,957 $5,089,168 $5,168,555 $5,163,971 $5,397,593 OTHER&RESERVES Partner Agency Funding $73,570 $61,816 $84,288 $84,288 $36,530 Other 77,712 79,920 98,170 131,276 103,977 Indirect Costs 22,821 52,124 29,582 31,218 29,858 Transfer to Capital Projects 0 1,076,000 0 0 0 Reserves 0 0 0 16,127 0 SUB-TOTAL $174,103 $1,269,859 $212,040 $262,909 $170,365 TOTAL EXPENDITURES $5,095,059 $6,359,027 $5,380,595 $5,426,880 $5,567,958 BALANCE $185,864 $50,719 $0 $0 $0 16 FISCAL YEAR 2018-2019 SCHEDULE 10-SUMMARY OF REVENUES AND EXPENDITURES PROMOTIONAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015116 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES Occupancey Tax Proceeds $275,072 $278,764 $255,253 $280,000 $280,000 Interest Income 3,828 4,363 3,769 5,500 5,500 Prior Year Encumbrances 6,000 0 0 2,439 0 SUB-TOTAL $284,900 $283,127 $259,022 $287,939 $285,500 TOAL REVENUES $284,900 $283,127 $259,022 $287,939 $285,500 EXPENDITURES Economic Development $108,337 $113,807 $120,280 $127,807 $126,176 Cultural&Leisure 101,416 124,404 132,158 132,158 1 35,159 Non-Departmental 123 125 443 355 474 Contribution to Reserves 0 0 6,141 27,619 23,691 SUB-TOTAL $209,876 $238,336 $259,022 $287,939 $285,500 TOTAL EXPENDITURES $209,876 $238,336 $259,022 $287,939 $285,500 BALANCE $75,024 $44,791 $0 $0 $0 17 FISCAL YEAR 2018-2019 SCHEDULE 11 -SUMMARY OF REVENUES AND EXPENDITURES DONATIONS FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015116 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES Contributions NRH Water Bills $56,457 $60,490 $59,080 $60,200 $60,200 SUB-TOTAL $56,457 $60,490 $59,080 $60,200 $60,200 Donations Spay/Neuter $13,809 $11,351 $13,800 $10,500 $8,500 Shelter Fund 26,391 39,092 23,850 8,400 8,400 Duncan 15,500 15,000 15,000 15,000 15,000 Santa Cops 8,123 2,631 2,600 5,547 5,000 SUB-TOTAL $63,823 $68,074 $55,250 $39,447 $36,900 Proceeds Library Book Sale $9,152 $10,316 $9,000 $9,750 $9,000 SUB-TOTAL $9,152 $10,316 $9,000 $9,750 $9,000 Other Interest Income $5,002 $5,241 $4,620 $5,500 $3,614 Other Income 127,366 163,189 136,500 171,381 163,250 Appropriation of Fund Balance Teen Court 3,000 0 400 400 400 Library 19,086 43,196 24,265 22,320 14,765 Neighborhood Services 4,969 4,969 4,969 73,830 8,873 Parks&Recreations 37,986 42,375 18,920 59,027 29,700 Police 3,409 4,750 9,000 400 1,100 SUB-TOTAL $200,818 $263,720 $198,674 $332,858 $221,702 TOTAL REVENUES $330,251 $402,600 $322,004 $442,255 $327,802 EXPENDITURES Library-Book Collection $57,651 $80,165 $76,420 $77,170 $68,865 Neighborhood Services Animal Services 13,551 22,694 29,310 34,811 19,810 Keep NRH Beautiful 11,168 17,217 19,969 80,969 17,013 Municipal Court-Teen Court 5,200 4,000 5,000 5,000 5,000 Parks-Special Events and Arts 53,752 62,920 94,000 133,772 114,000 Police Department 32,157 30,789 45,000 43,838 43,700 Fire Department 0 0 0 987 0 Transfers Out 44,849 51,400 41,400 30,000 30,000 TOTAL EXPENDITURES $218,327 $269,185 $311,099 $406,547 $298,388 BALANCE $111,924 $133,415 $10,905 $35,708 $29,414 18 FISCAL YEAR 2018-2019 SCHEDULE 12-SUMMARY OF REVENUES AND EXPENDITURES SPECIAL INVESTIGATIONS FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES Forefeited Funds $112,118 $92,345 $111,000 $114,030 $141,000 AFIS Reimbursements 13,500 13,500 26,250 26,250 13,500 911 Telecom 148,290 (58,000) 0 0 0 Interest Income 2,821 2,056 2,034 2,304 2,304 Other Income 112,175 105,756 0 57 0 Prior Year Encumbrances 0 39,531 0 3,300 0 Appropriation of Fund Balance 128,317 102,935 113,016 119,659 104,521 TOTAL REVENUES $517,221 $298,123 $252,300 $265,600 $261,325 EXPENDITURES Federal Forefeited Funds $86,556 $93,434 $100,000 $113,300 $145,000 MDT Maintenance 13,238 0 0 0 0 Radio Maintenance 14,962 0 0 0 0 State Forfeitured Funds 40,592 42,592 100,000 100,000 105,000 Local Forfeited Funds 62,382 46,255 1,000 1,000 0 AFIS Maintenance&Equipment 19,446 87,672 51,300 51,300 4,300 911 Telecom 147,638 29,700 0 0 0 Leose Contributions 0 0 0 0 7,025 Reserve for City Hall Project: 911 Telecom 0 0 0 0 0 Automated Fingerprint Identification Sys.(AFIS) 0 0 0 0 0 Reserves 0 0 0 0 0 TOTAL EXPENDITURES $384,814 $299,653 $252,300 $265,600 $261,325 BALANCE $132,407 ($1,530) $0 $0 $0 19 FISCAL YEAR 2018-2019 SCHEDULE 13-SUMMARY OF REVENUES AND EXPENDITURES DRAINAGE UTILITY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES Drainage Fees $881,379 $883,195 $867,849 $900,000 $1,647,000 Interest Income 7,419 4,667 5,269 2,755 2,755 Appropriation of Fund Balance 0 305,928 317,406 438,103 0 SUB-TOTAL $888,797 $1,193,790 $1,190,524 $1,340,858 $1,649,755 TOTAL REVENUES $888,797 $1,193,790 $1,190,524 $1,340,858 $1,649,755 EXPENDITURES Debt Service $553,789 $373,018 $362,674 $362,674 $261,139 Transfer to Capital Projects 0 695,000 797,850 947,850 230,000 Other Expenditures 130,559 29,820 30,000 30,334 30,000 Contribution to Reserves 0 0 0 0 1,128,616 TOTAL EXPENDITURES $684,348 $1,097,838 $1,190,524 $1,340,858 $1,649,755 BALANCE $204,449 $95,952 $0 $0 $0 20 FISCAL YEAR 2018-2019 SCHEDULE 14-SUMMARY OF REVENUES AND EXPENDITURES GAS DEVELOPMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES BONUSES General Fund Purposes $0 $0 $0 $0 $0 SUB-TOTAL $0 $0 $0 $0 $0 ROYALITIES/OVERRIDES General Fund Purposes $263,932 $454,264 $217,000 $522,500 $522,500 SUB-TOTAL $263,932 $454,264 $217,000 $522,500 $522,500 OTHER Right of Way Usage Fees $0 $0 $0 $0 $0 Sales of Property 3,202,805 0 0 0 0 Interest Income 6,851 2,563 2,300 5,800 5,800 Other Income 0 0 93,373 0 0 SUB-TOTAL $3,209,656 $2,563 $95,673 $5,800 $5,800 APPROPRIATION OF RESERVES General Fund Purposes $2,796,070 $0 $0 $0 $0 SUB-TOTAL $2,796,070 $0 $0 $0 $0 TOTAL REVENUES $6,269,658 $456,827 $312,673 $528,300 $528,300 EXPENDITURES OPERATING Transfer to Capital Projects $2,796,070 $0 $100,000 $100,000 $0 Interfund Loan Repayment 3,226,239 0 0 0 0 Contribution to Reserves 0 0 212,673 398,300 528,300 Other 0 70,174 0 30,000 0 TOTAL EXPENDITURES $6,022,309 $70,174 $312,673 $528,300 $528,300 BALANCE $247,348 $386,653 $0 $0 $0 21 FISCAL YEAR 2018-2019 SCHEDULE 15-SUMMARY OF REVENUES AND EXPENDITURES TRAFFIC SAFETY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES Gross Fine Revenues $1,322,940 $1,088,773 $1,002,236 $955,739 $1,088,115 Interest Income 5,349 6,281 5,780 7,900 7,900 Transfer from General CIP 0 0 0 0 0 Prior Year Encumbrances 0 0 0 76,510 0 Appropriation of Fund Balance 0 35,006 0 21,643 0 TOTAL REVENUES $1,328,289 $1,130,060 $1,008,016 $1,061,792 $1,096,015 EXPENDITURES Contractor Payments $552,770 $593,690 $612,000 $612,000 $612,000 Program Administration 160,573 270,264 322,937 323,396 319,409 Payment to State 275,184 141,200 33,296 10,172 78,353 Traffic Enforcement/Traffic Safety 6,075 22,972 22,508 99,018 23,000 Pedestrian Safety 15,921 16,147 16,568 16,568 16,415 Transfer to Capital Projects 0 0 0 0 0 Contribution to Reserves 0 0 707 638 46,838 SUB-TOTAL OTHER EXPENDITURES $1,010,523 $1,044,272 $1,008,016 $1,061,792 $1,096,015 TOTAL EXPENDITURES $1,010,523 $1,044,272 $1,008,016 $1,061,792 $1,096,015 BALANCE $317,767 $85,788 $0 $0 $0 22 FISCAL YEAR 2018-2019 SCHEDULE 16-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES WATER SALES AND CHARGES Water Sales $18,407,760 $19,093,425 $21,440,826 $21,440,826 $22,563,509 Water Prior Year Settle-up $243,852 $315,360 $0 $1,108,469 $0 Water Taps 52,000 41,715 34,515 34,515 34,515 Water Inspection Fees 28,613 52,121 24,882 24,882 24,882 SUB-TOTAL $18,732,225 $19,502,621 $21,500,223 $22,608,692 $22,622,906 SEWER SALES AND CHARGES Sewer Sales $9,951,156 $10,611,314 $11,259,548 $11,259,548 $11,469,477 Sewer Prior Year Settle-Up $9,340 $0 $0 $608,287 $0 Sewer Taps 14,350 12,800 10,600 10,600 10,600 Sewer Inspection Fees 20,943 43,071 24,000 25,673 24,000 SUB-TOTAL $9,995,788 $10,667,185 $11,294,148 $11,904,108 $11,504,077 MISCELLANEOUS Interest Income $95,997 $89,926 $78,309 $103,500 $103,500 Service Charges 155,166 152,581 153,200 149,300 153,500 Late Charges 417,162 410,157 420,000 420,000 420,000 Miscellaneous 59,232 163,651 51,634 53,200 36,034 Joint Use Reimbursement-Watauga 111,265 112,583 104,048 60,000 60,000 Subdivision Meter Revenue 61,903 58,365 49,332 56,193 56,193 Bond Refunding Proceeds 792,063 0 0 0 0 Interfund Loan Repayments 3,310,867 48,003 0 0 0 SUB-TOTAL $5,003,654 $1,035,266 $856,523 $842,193 $829,227 APPROPRIATION OF FUND BALANCE Prior Year Encumbrances $43,824 $385,280 $0 $89,843 $0 Appropriation of Fund Balance 2,882,572 1,923,100 685,883 685,883 408,249 SUB-TOTAL $2,926,396 $2,308,380 $685,883 $775,726 $408,249 TOTAL REVENUES $36,658,064 $33,513,452 $34,336,777 $36,130,719 $35,364,459 23 FISCAL YEAR 2018-2019 SCHEDULE 16-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 EXPENDITURES OPERATING Administration $311,446 $315,392 $334,024 $334,377 $346,147 Development 814,543 840,824 896,822 884,502 914,673 Right of Way Maintenance 145,520 114,776 233,754 301,628 271,118 SUB-TOTAL $1,271,508 $1,270,991 $1,464,600 $1,520,507 $1,531,938 WATER SERVICES Water Operations $4,101,097 $4,521,124 $4,701,399 $4,647,257 $4,798,521 Purchase of Water FTW 4,139,257 3,608,262 4,787,352 4,787,352 4,448,150 Purchase of Water TRA 5,911,008 6,108,256 5,788,101 5,788,101 6,353,955 SUB-TOTAL $14,151,362 $14,237,641 $15,276,852 $15,222,710 $15,600,626 SEWER SERVICES Sewer Operations $1,273,582 $1,323,464 $1,455,258 $1,438,671 $1,489,643 Sewer Treatment FTW 1,588,456 1,168,452 1,390,101 1,390,101 1,326,214 Sewer Treatment TRA 4,142,146 4,323,559 4,561,306 4,580,342 4,813,368 SUB-TOTAL $7,004,184 $6,815,475 $7,406,665 $7,409,114 $7,629,225 FINANCE/UTILITY COLLECTIONS Meter Reading $463,574 $477,799 $519,638 $520,344 $532,122 Utility Billing/Customer Service 845,117 925,364 974,423 976,011 995,968 Utility Collection Services 276,130 263,305 240,027 240,027 246,057 Accounting Services 391,193 372,187 420,264 419,163 429,282 Budget&Research 211,529 172,402 227,555 221,100 229,883 SUB-TOTAL $2,187,543 $2,211,057 $2,381,907 $2,376,645 $2,433,312 Building Services $1,752,816 $1,822,929 $1,822,929 $1,822,929 $1,822,929 Non Departmental $178,106 $201,994 $291,069 $400,996 $302,286 SUB-TOTAL DEPARTMENTS $26,545,520 $26,560,087 $28,644,022 $28,752,901 $29,320,316 OTHER&RESERVES Debt Service $1,060,260 $1,128,567 $1,119,008 $1,119,008 $1,391,236 Bond Defeasance/Refunding 798,283 0 0 0 0 Franchise Fees 823,128 895,441 943,831 981,011 1,020,989 Indirect Costs 2,194,830 2,304,572 2,304,572 2,304,572 2,304,572 Payment in Lieu of Taxes 387,493 390,983 392,821 392,821 415,689 Transfer to Information Technology 175,000 175,000 175,000 175,000 175,000 Transfer to Equipment Services 50,000 0 0 0 0 Transfer to Capital 208,262 1,200,000 757,523 757,523 736,657 Contribution to Reserves 3,226,239 0 0 1,647,883 0 SUB-TOTAL $8,923,494 $6,094,563 $5,692,755 $7,377,818 $6,044,143 TOTAL EXPENDITURES $35,469,014 $32,654,650 $34,336,777 $36,130,719 $35,364,459 BALANCE $1,189,050 $858,802 $0 $0 $0 24 FISCAL YEAR 2018-2019 SCHEDULE 17-SUMMARY OF REVENUES AND EXPENDITURES AQUATIC PARK FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 ATTENDANCE 227,525 202,515 255,000 220,000 220,000 REVENUES OPERATING Admissions $2,733,058 $3,027,498 $3,678,150 $3,295,000 $3,295,000 Food and Beverage 837,352 834,519 1,019,552 870,700 870,700 Merchandise 143,644 144,398 158,100 154,000 154,000 Rentals 142,436 126,093 249,787 185,000 185,000 Aquatic Classes/Special Events 2,096 5,568 0 0 0 SUB-TOTAL $3,858,587 $4,089,301 $5,105,589 $4,504,700 $4,504,700 OTHER REVENUES Interest Income $12,403 $11,134 $12,600 $16,309 $16,309 Other Income 149,139 31,113 50,250 60,250 47,500 Bond Refunding Proceeds 206,912 198,864 0 0 0 SUB-TOTAL $368,454 $241,111 $62,850 $76,559 $63,809 SUB-TOTAL REVENUES $4,227,040 $4,330,412 $5,168,439 $4,581,259 $4,568,509 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $488,641 $1,253,468 $100,000 $0 $0 SUB-TOTAL $488,641 $1,253,468 $100,000 $0 $0 TOTAL REVENUES $4,715,681 $5,583,880 $5,268,439 $4,581,259 $4,568,509 EXPENDITURES OPERATING General Services&Utilities $850,094 $913,210 $850,866 $807,085 $847,256 Public Grounds/Aquatics/Maint. 1,189,848 1,380,100 1,253,254 1,116,236 1,121,077 Business&Office Administration 608,201 585,200 602,287 539,220 548,376 Gift Shop/Concessions 571,046 632,597 632,994 597,266 597,780 Sales/Special Events/Admissions 254,431 260,630 288,297 269,454 273,508 SUB-TOTAL $3,473,621 $3,771,737 $3,627,698 $3,329,261 $3,387,997 OTHER&RESERVES Debt Service $461,386 $954,205 $904,109 $905,234 $779,516 Bond Defeasance/Refunding 209,105 201,896 0 0 0 Indirect Costs 158,696 166,631 174,963 174,963 174,963 Transfer Out-PARD 81,248 83,685 87,869 0 0 Transfer to Capital Projects 288,675 335,000 100,000 100,000 100,000 Reserve For Infrastructure&Major Repairs 0 0 323,749 24,049 73,651 Non-Departmental 42,950 70,727 50,051 47,752 52,382 SUB-TOTAL $1,242,060 $1,812,144 $1,640,741 $1,251,998 $1,180,512 TOTAL EXPENDITURES $4,715,681 $5,583,881 $5,268,439 $4,581,259 $4,568,509 BALANCE $0 $0 $0 $0 $0 25 FISCAL YEAR 2018-2019 SCHEDULE 18-SUMMARY OF REVENUES AND EXPENDITURES GOLF COURSE FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 ROUNDS 43,250 49,147 51,000 45,000 50,000 REVENUES Green Fees $971,821 $951,730 $1,002,000 $868,000 $1,002,000 Pro Shop 400,426 403,867 392,000 483,000 413,500 Driving Range 86,163 79,132 85,000 70,000 75,000 Carts 401,580 409,075 391,000 357,990 391,000 Food&Beverage 728,709 714,299 690,000 673,971 681,500 General&Administrative 1,167 126 1,167 0 0 General Fund Loan 0 0 0 0 0 Other Revenue 39,018 129,514 13,904 38,454 38,454 Appropriation of Fund Balance 27,796 0 0 0 0 TOTAL REVENUE $2,656,679 $2,687,743 $2,575,071 $2,491,415 $2,601,454 EXPENDITURES OPERATING Pro Shop $132,812 $136,669 $165,461 $138,758 $166,710 Pro Shop:Cost of Goods Sold 154,542 191,202 143,000 177,031 143,000 Driving Range 10,446 8,150 16,200 13,200 18,200 Golf Carts 230,142 214,717 222,224 240,580 224,030 Course Maintenance 598,974 590,173 626,700 596,520 632,200 Food&Beverage 307,435 340,789 280,952 306,963 304,202 Food&Beverage:Cost of Goods Sold 208,740 226,256 215,660 227,764 206,064 Sales&Membership 51,649 36,415 56,764 50,000 56,764 General&Administrative 290,979 312,998 232,523 270,766 287,755 Clubhouse 115,306 118,783 120,544 105,644 97,434 Management Fees 146,353 144,714 113,434 142,000 144,714 Capital 67,297 129,405 217,641 58,221 154,000 SUB-TOTAL $2,314,676 $2,450,271 $2,411,103 $2,327,447 $2,435,073 OTHER&RESERVES Debt Service $109,615 $116,430 $63,968 $63,968 $62,743 Transfer to Capital Projects 0 0 100,000 100,000 103,638 Payment to Interdepartmental Loans Water Fund 84,628 48,003 0 0 0 General Fund 147,760 147,760 0 0 0 Contribution to Reserves 0 0 0 0 0 SUB-TOTAL $342,003 $312,193 $163,968 $163,968 $166,381 TOTAL EXPENDITURES $2,656,679 $2,762,464 $2,575,071 $2,491,415 $2,601,454 BALANCE $0 ($74,721) $0 $0 $0 26 FISCAL YEAR 2018-2019 SCHEDULE 19-SUMMARY OF REVENUES AND EXPENDITURES FACILITIES/CONSTRUCTION MANAGEMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES CHARGES FOR SERVICE Transfer From: General Fund $848,774 $836,737 $812,101 $812,101 $812,101 Park Development Fund 360,750 351,900 294,150 284,090 274,090 Utility Fund 1,752,816 1,822,929 1,822,929 1,822,929 1,822,929 SUB-TOTAL $2,962,340 $3,011,566 $2,929,180 $2,919,120 $2,909,120 OTHER REVENUES Insurance Settlements $0 $0 $0 $0 $0 Interest Income 14,887 16,021 13,102 23,000 23,000 Rent From Rental Properties 70,785 71,492 72,000 72,000 39,600 Other Income 91 100 0 0 0 SUB-TOTAL $85,763 $87,613 $85,102 $95,000 $62,600 SUB-TOTAL REVENUES $3,048,103 $3,099,179 $3,014,282 $3,014,120 $2,971,720 APPROPRIATION OF FUND BALANCE Building Services Fund Reserves $532,064 $60,440 $0 $0 $13,620 Prior Year Encumbrances 0 0 0 0 0 SUB-TOTAL $532,064 $60,440 $0 $0 $13,620 TOAL REVENUES $3,580,167 $3,159,619 $3,014,282 $3,014,120 $2,985,340 EXPENDITURES General Services $329,806 $330,864 $345,312 $345,665 $356,927 Building Servcies 2,188,912 2,308,154 2,357,416 2,374,245 2,359,714 Rental Property Program 115,787 25,220 46,120 73,120 36,120 Transfer to Capital Budget 439,116 120,800 60,000 60,000 212,000 SUB-TOTAL $3,073,621 $2,785,039 $2,808,848 $2,853,030 $2,964,761 OTHER&RESERVES Debt Service $27,399 $26,193 $0 $0 $0 Other 12,591 12,953 19,084 17,320 20,579 Contribution of Facility Reserves 0 0 186,350 143,770 0 SUB-TOTAL $39,990 $39,146 $205,434 $161,090 $20,579 TOTAL EXPENDITURES $3,113,611 $2,824,185 $3,014,282 $3,014,120 $2,985,340 BALANCE $466,556 $335,434 $0 $0 $0 27 FISCAL YEAR 2018-2019 SCHEDULE 20-SUMMARY OF REVENUES AND EXPENDITURES FLEET SERVICES FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES CHARGES FOR SERVICE Transfer From: General Fund $1,273,471 $1,389,677 $968,193 $1,389,677 $1,389,677 Utility Fund 1,873,949 1,967,647 1,967,647 1,967,647 1,967,647 Utility CIP/Utility Construction 274,931 288,678 288,678 288,678 288,678 Crime Control District 162,310 170,426 170,426 170,426 170,426 Park&Recreation Dev.Fund 137,085 143,939 143,939 143,939 171,939 Other Funds 38,360 40,278 40,278 24,119 24,119 SUB-TOTAL $3,760,106 $4,000,645 $3,579,161 $3,984,486 $4,012,486 OTHER REVENUES Interst Income $20,005 $23,305 $17,608 $30,000 $30,000 Sale of City Property 49,564 18,501 50,000 50,000 50,000 Other Income 7,212 11,505 6,660 52,457 3,300 Transfer from General Fund 0 0 0 0 0 Transfer from Utility Fund 50,000 0 0 0 0 SUB-TOTAL $126,780 $53,310 $74,268 $132,457 $83,300 SUB-TOTAL REVENUES $3,886,886 $4,053,955 $3,653,429 $4,116,943 $4,095,786 APPROPRIATION OF FUND BALANCE Equipment Services Fund Reserves $129,535 $41,565 $0 $0 $495,527 Appropriation-PY Encumbrances 0 0 0 732,668 0 SUB-TOTAL $129,535 $41,565 $0 $732,668 $495,527 TOAL REVENUES $4,016,421 $4,095,520 $3,653,429 $4,849,611 $4,591,313 EXPENDITURES General Services $224,090 $222,030 $341,567 $272,783 $275,794 Equipment Services Operations 1,376,118 1,367,037 1,533,410 1,605,589 1,620,090 Fire Fleet Maintenance 259,683 286,138 300,146 331,093 329,307 Equipment Purchases 677,721 3,989 368,535 666,656 425,875 Fire Vehicles/Equipment 0 390,511 76,582 231,657 0 Police Vehicles/Equipment 344,330 63,126 537,118 767,532 774,375 SUB-TOTAL $2,881,941 $2,332,832 $3,157,358 $3,875,310 $3,425,441 OTHER&RESERVES Debt Service $480,406 $448,414 $0 $421,484 $537,302 Transfer to Capital Projects 178,400 503,000 192,232 237,257 609,000 Other 12,132 12,469 18,092 83,964 19,570 Equipment Services Reserve 0 41,565 285,747 231,596 0 SUB-TOTAL $670,938 $1,005,448 $496,071 $974,301 $1,165,872 TOTAL EXPENDITURES $3,552,879 $3,338,280 $3,653,429 $4,849,611 $4,591,313 BALANCE $463,542 $757,241 $0 $0 $0 28 FISCAL YEAR 2018-2019 SCHEDULE 21-SUMMARY OF REVENUES AND EXPENDITURES INFORMATION TECHNOLOGY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES TELECOMMUNICATIONS Transfer From: General Fund $337,942 $353,538 $371,220 $371,220 $373,124 Park Fund 34,007 35,708 37,493 37,493 37,493 Crime Control District 27,922 30,018 30,256 30,796 32,472 Utility Fund 85,226 89,489 93,965 93,965 93,965 Other Funds 61,212 64,273 67,487 67,487 67,487 SUB-TOTAL $546,309 $573,026 $600,421 $600,961 $604,541 COMPUTERS Transfer From: General Fund $979,436 $1,048,660 $1,096,395 $1,098,225 $1,099,134 Park Fund 107,489 112,863 118,506 118,506 118,506 Crime Control District 179,640 188,622 193,427 194,627 199,175 Utility Fund 699,831 734,822 771,562 771,562 771,562 Other Funds 292,212 306,823 322,166 322,166 322,166 SUB-TOTAL $2,258,608 $2,391,790 $2,502,056 $2,505,086 $2,510,543 OTHER REVENUES Interest Income $12,090 $13,923 $12,322 $17,000 $17,000 Transmitter Lease 145,073 155,324 152,958 152,958 152,958 Other Income 7,069 2,606 0 36 0 Transfer from General Fund 75,703 77,975 82,725 82,725 85,492 Transfer from Utility Fund 175,000 175,000 175,000 175,000 175,000 SUB-TOTAL $414,935 $424,827 $423,005 $427,719 $430,450 SUB-TOTAL REVENUES $3,219,852 $3,389,643 $3,525,482 $3,533,766 $3,545,534 APPROPRIATION OF FUND BALANCE Prior Year Encumbrances $108,825 $0 $0 $7,969 $0 Appropriation of Information Systems Reserves 0 15,000 0 0 96,287 SUB-TOTAL $108,825 $15,000 $0 $7,969 $96,287 TOAL REVENUES $3,328,677 $3,404,643 $3,525,482 $3,541,735 $3,641,821 EXPENDITURES General Services $252,128 $256,207 $270,868 $270,868 $281,324 Major Computer Systems 318,606 331,827 397,658 398,011 343,255 Microcomputer Systems 680,208 634,629 788,657 785,378 781,059 Telecommunications 458,954 471,458 485,886 481,062 478,087 Data Network 647,639 653,370 775,032 794,672 856,422 GIS System 161,929 161,406 181,162 177,952 184,536 Public Safety 355,379 511,854 530,875 568,255 701,515 SUB-TOTAL $2,874,841 $3,020,750 $3,430,138 $3,476,198 $3,626,198 OTHER&RESERVES Other $8,257 $8,526 $12,619 $10,325 $13,123 Transfer to Capital Projects 95,000 156,000 0 0 2,500 Reserve for System Improvements 0 0 82,725 55,212 0 SUB-TOTAL $103,257 $164,526 $95,344 $65,537 $15,623 TOTAL EXPENDITURES $2,978,098 $3,185,276 $3,525,482 $3,541,735 $3,641,821 BALANCE $350,579 $219,367 $0 $0 $0 29 FISCAL YEAR 2018-2019 SCHEDULE 22-SUMMARY OF REVENUES AND EXPENDITURES SELF INSURANCE FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2015/16 FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 REVENUES ALLOCATIONS Health/Medical City Contribution $7,840,525 $8,551,168 $9,163,410 $9,212,064 $9,892,973 Health/Medical Employee Contribution 1,927,452 2,097,967 2,312,371 2,312,371 2,634,129 Worker's Compensation 605,035 48,340 592,520 586,463 593,500 Administration Allocation 400,528 1,009,412 512,517 526,629 511,311 Other Insurance 567,049 583,445 696,798 696,798 753,227 SUB-TOTAL 11,340,589 $12,290,332 $13,277,616 $13,334,325 $14,385,140 OTHER REVENUES Interest Income $45,708 $39,655 $36,604 $39,430 $39,430 Other Income 153,145 133,653 95,800 133,500 133,500 Expenditure Reimbursement 697,616 571,743 400,000 645,000 400,000 SUB-TOTAL 896,469 $745,051 $532,404 $817,930 $572,930 SUB-TOTAL REVENUES $12,237,059 $13,035,383 $13,810,020 $14,152,255 $14,958,070 APPROPRIATION OF FUND BALANCE Self Insurance Fund Reserves $1,851,859 $987,341 $100,000 $100,000 $100,000 SUB-TOTAL $1,851,859 $987,341 $100,000 $100,000 $100,000 TOAL REVENUES $14,088,917 $14,022,724 $13,910,020 $14,252,255 $15,058,070 EXPENDITURES Health/Medical $11,885,570 $11,984,074 $11,870,884 $11,867,884 $12,526,510 Worker's Compensation 605,035 334,487 592,520 592,520 593,500 Personnel Expenses 470,918 481,122 515,347 515,347 495,012 Other Insurance 484,378 577,519 589,799 592,799 644,228 Reserve for Insurance Claims 0 0 0 0 0 Other Expenses 133,194 127,529 95,800 133,500 133,500 Life Insurance Premium 87,958 99,540 107,000 107,000 109,000 SUB-TOTAL $13,667,053 $13,604,271 $13,771,350 $13,809,050 $14,501,750 OTHER&RESERVES Transfer to Retiree Health Care Fund $100,000 $100,000 $100,000 $100,000 $100,000 Contribution to Reserves 0 0 38,670 343,205 456,320 SUB-TOTAL 100,000 $100,000 $138,670 $443,205 $556,320 TOTAL EXPENDITURES $13,767,053 $13,704,271 $13,910,020 $14,252,255 $15,058,070 BALANCE $321,864 $318,453 $0 $0 $0 30 FISCAL YEAR 2018-2019 FUND BALANCE SUMMARY-ALL FUNDS Fund balance is defined as assets minus liabilities. Maintaining an appropriate fund balance is essential for the City to mitigate financial risk that can occur from unforeseen revenue shortfalls,unanticipated expenditures,or any other adverse circumstances.In addition,it is also designed to provide the appropriate amount of working capital for the City's general operations. The City maintains an appropriate fund balance level within each fund as determined by best practice and City policy. The Fund Balance Summary shows an audited beginning fund balance as of September 30,2017 for all budgeted funds along with the estimated impact based upon the FY 2017/18 Revised Budget and FY 2018/19 Proposed Budaet. FY 2017-2018 FY 2018-2019 FY 2018-2019 AUDITED Revised Budget FY 2017-2018 Proposed Proposed BALANCE AS Increase Revised Budget Budget Increase Budget Ending FUND OF 09/30/17 (Decrease) Ending Balance (Decrease) Balance General Fund(Unresenred/Undesignated)* $ 10,797,532 $ 926,880 $ 11,724,412 $ (56,460) $ 11,667,952 General Fund Designated for Municipal $ 634,712 $ 6,740 $ 641,452 $ 62,526 $ 703,978 Court Technology&Security General Fund Designated for Franchise $ 347,992 $ 140,821 $ 488,813 $ 131,193 $ 620,006 Peg Fees General Fund Designated for Record $ 4,000 $ $ 4,000 $ $ 4,000 Preservation Fee General Debt Service Fund $ 878,567 $ (2,348) $ 876,219 $ - $ 876,219 Utility Fund Unrestricted* $ 6,109,435 $ 872,157 $ 6,981,592 $ (408,249) $ 6,573,343 Golf Course Fund Unrestricted $ (88,568) $ - $ (88,568) $ - $ (88,568) Aquatic Park Fund Unrestricted $ (10,380) $ 24,049 $ 13,669 $ 73,651 $ 87,320 Facilities&Construction Services Fund $ 1,346,885 $ 143,770 $ 1,490,655 $ (13,620) $ 1,477,035 Fleet Services Fund $ 2,465,151 $ (501,072) $ 1,964,079 $ (495,527) $ 1,468,552 Self Insurance Fund $ 3,176,886 $ 243,205 $ 3,420,091 $ 356,320 $ 3,776,411 Information Technology Fund $ 1,223,668 $ 47,243 $ 1,270,911 $ (96,287) $ 1,174,624 Promotional Fund $ 643,385 $ 25,180 $ 668,565 $ 23,691 $ 692,256 Donations Fund $ 674,171 $ (120,269) $ 553,902 $ (25,424) $ 528,478 Special Investigation Fund $ 299,433 $ (122,959) $ 176,474 $ (104,521) $ 71,953 Drainage Utility Fund $ 961,057 $ (438,103) $ 522,954 $ 1,128,616 $ 1,651,570 Gas Development Fund $ 495,516 $ 398,300 $ 893,816 $ 528,300 $ 1,422,116 Traffic Safety Fund $ 720,190 $ (97,515) $ 622,675 $ 46,838 $ 669,513 Park&Recreation Facilitites Development $ 2,087,578 $ (138,778) $ 1,948,800 $ 343,600 $ 2,292,400 Fund Recreation Centre $ 1,906,764 $ 221,635 $ 2,128,399 $ 175,240 $ 2,303,639 Economic Development Fund $ 1,100,928 $ 127,396 $ 1,228,324 $ (620,057) $ 608,267 Crime Control&Prevention District Fund* $ 617,817 $ 6,570 $ 624,387 $ (16,845) $ 607,542 31 City of North Richland Hills Fiscal Year 2018/2019 Proposed Budget ADOPTED REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 Legal Notice Expenditures 7,130 8,750 8,750 8,750 This information is required by Local Government Code 140.0045 as added in the 85th Legislature in 2017 under S.B. 622. 32 Ordinance 3531 Attachment "B" City of North Richland Hills Fiscal Year 2018/2019 Proposed Budget This budget will raise more total property taxes than last year's budget by $2,331 ,674 or 7.92 percent, and of that amount $454,771 is tax revenue to be raised from new property added to the tax roll this year. The total amount of municipal debt obligations secured by property taxes for the City of North Richland Hills is $119,765,000. Visit our website at:www.nrhtx.com 1 C DL' P C3 i., , - L.,...1 Li 2: ,--- ' L 1-1.' 1 , I- , ' .10 , ; 7 1 -I-1 - 1 ,—.. _ 1_ ., ..... - ., LS_I DLL .: :- . DP - F-1 City ' , '! " nd Hil i ,, r4.!t;---, ,,,..-, C:itii of Natii Ric' hIL. .i as I T (as , - --1 Ll D,.. ........., C '-i El .. 1] - Li ' . L. '-1 1 0 OD 1 r] _ , DUD Uri DJ 0 0 r , 17310 ,.._ i , J L :1 -1 7.„ ' --I D Cll DD 0 fir; ',. 1 O L 0 fl D 1..-. -'11 r"-J C. )1' 1 '-'' t , ',..:::'''' - ,,s-vZ,- - '--1-..r`' .7--.-.• ._ - - - : . .,-.: .-,.:11.--J --..: ---, .::•,::' -Ae,,-144,f,.„._. i.„,":-..:,-.--:-.,: ---,...... ilk;-rt--. '''7*- 1--'1:,,'.4•Z'...;-;-.'.. '-'::?-:!!---41 .-.---'-: "*47;:ffi3-e, -'-.-----;if....,'..'*?c-Z7,*;41:':'''F4-24.4;:=Zv.:::-'',:j :544-,:- '-':','-'',-..•-;,,,----,-,--‘.: .,-vi-'''. ,'-, :- „ , -----e't''-'----'-,4,,,E''''-'i'.---`,.?-i:y, ii`,:. -".:, ,1;•-T-.:-..'::-.g;:s.--el--' ;:;;--":::-.:,14 .4::-.. ' '' '-'4" 4- :-: ;I? , — ---f#'44.•- •1.*ItZ,'If.''''''Z'Y_°;",-;,„,A1":' 44.'''',,' --,... , , '-'1:-.W8......M:::-Aiir "!4'4;'..• Ci.:::-4:41iX,--.'4.7,4-1W-< '.-,'' VI,ffAil:::,i-Vt:II.44.::-.-A§i:Xj-•::-I-il-;-.;,f:':: ::7;"::::41..ft.11277.=';.-.4*.- - - .. _I.::7-7: .,..-,,;7.-.' .77,7:: 47:277,m----, -,:',..-....:-,, 47.1:47-14-617.':74{isli.fr:ifi:!ti.f*.-7.:r -V:1,- --ilt*Kc.:44,- . -, .•,-44.1e+.;‘,.,01--i---..q--,=';',,---:-=:,,,."----TiA, -;.. ..:1,1-,t5-itt-i-L-N L.;:i 1., --. ',-%N , Mil I , --- ------7 *----, I tr.., 4 ' • ' ' "'-'--%-- I , ., . 1 .. , , — u • t` , 7. ..- * ... - 1 — -- -1 B . , 414thr , : 1 -,ni': l , —4 1.,. •••••■--- -C '* iii 111:1::11:1'.;11/l' 14::* • '1 LIMA'IML1S .S5,kliAtitir. .-..-.-..-:-.7.--...,-- „„,,,-- . 7 •'''''''' jill4' 41,4",11,,,,,„;,,,..„ n.,..•; ___ ..........____,.......-- „ .—_. ..,t ' -,---t.,.... -....—,.. . ..... . ,.lifoio',' ,.1,,- I ""4"01111111111110-' . --- .... ... ..-- 4 Proposed Capital Projects Budget ,.. _ . . . _ .. .....„ ...- . . , . . . Greate..ct 194i. JeA,..04.44ter Ca-ste,I.Lavtas Summary of Project Expenditures 2018/2019 Capital Improvement Program Project To Proposed Estimated 2020 to Total Program Classification Date 2018/2019 2019/2020 Completion Expenditures Street&Sidewalk 42,810,484 2,865,000 0 0 $ 45,675,484 Drainage 1,904,108 230,000 0 0 $ 2,134,108 Utility 12,281,525 1,755,000 0 0 $ 14,036,525 Parks&Recreation 9,475,901 658,000 811,000 0 $ 10,944,901 Aquatic Park 700,000 100,000 0 0 $ 800,000 Facilities 69,465,087 212,000 0 0 $ 69,677,087 Major Capital Equipment 5,361,257 4,441,500 98,000 0 $ 9,900,757 Economic Development 15,627,826 750,000 0 0 $ 16,377,826 CIP Personnel 330,004 336,657 0 0 $ 666,661 Other 528,343 94,000 0 0 $ 622,343 Total CIP Project Expenditures $ 158,484,535 $ 11,442,157 $ 909,000 $ 0 $ 170,835,692 3 Summary of Project Funding 2018/2019 Capital Improvement Program Funding To Proposed Estimated 2020 to Total Funds Funding Source Date 2018/2019 2019/2020 Completion General Obligation Bonds 58,100,950 0 0 0 58,100,950 Certificates of Obligation 39,155,000 7,860,000 98,000 0 47,113,000 Federal/State Grants 21,055,018 0 0 0 21,055,018 Reserves 23,808,314 3,133,157 0 0 26,941,471 Sales Tax 2,608,397 449,000 811,000 0 3,868,397 Other 13,756,856 0 0 0 13,756,856 Total CIP Project Funding $ 158,484,535 $11,442,157 $ 909,000 $ 0 $ 170,835,692 4 Summary of Project Funding 2018/2019 Capital Improvement Program Funding To Proposed Estimated 2020 to Total Funds Program Date 2018/19 2019/20 Completion Street&Sidewalk General Obligation Bonds 9,850,950 0 0 0 9,850,950 Certificates of Obligation 6,695,000 2,675,000 0 0 9,370,000 Federal/State Grants 19,861,907 0 0 0 19,861,907 Reserves 4,672,627 190,000 0 0 4,862,627 Other 1,730,000 0 0 0 1,730,000 Street& Sidewalk Sub-Total $ 42,810,484 $ 2,865,000 $ 0 $ 0 $ 45,675,484 Drainage Reserves 1,754,108 230,000 0 0 1,984,108 Other 150,000 0 0 0 150,000 Drainage Sub-Total $ 1,904,108 $ 230,000 $ 0 $ 0 $ 2,134,108 Utility Certificates of Obligation 5,845,000 1,355,000 0 0 7,200,000 Reserves 3,436,525 400,000 0 0 3,836,525 Other 3,000,000 0 0 0 3,000,000 Utility Sub-Total $ 12,281,525 $ 1,755,000 $ 0 $ 0 $ 14,036,525 Parks&Recreation Certificates of Obligation 3,900,000 0 0 0 3,900,000 Federal/State Grants 1,117,294 0 0 0 1,117,294 Reserves 620,485 209,000 0 0 829,485 Sales Tax 2,533,397 449,000 811,000 0 3,793,397 Other 1,304,725 0 0 0 1,304,725 Parks&Recreation Sub-Total $ 9,475,901 $ 658,000 $ 811,000 $ 0 $ 10,944,901 Aquatic Park Certificates of Obligation 600,000 0 0 0 600,000 Reserves 100,000 100,000 0 0 200,000 Aquatic Park Sub-Total $ 700,000 $ 100,000 $ 0 $ 0 $ 800,000 Facilities General Obligation Bonds 48,250,000 0 0 0 48,250,000 Certificates of Obligation 18,600,000 0 0 0 18,600,000 Reserves 180,800 212,000 0 0 392,800 Other 2,434,287 0 0 0 2,434,287 Facilities Sub-Total $ 69,465,087 $ 212,000 $ 0 $ 0 $ 69,677,087 Major Capital Equipment Certificates of Obligation 515,000 3,830,000 98,000 0 4,443,000 Federal/State Grants 75,817 0 0 0 75,817 Reserves 1,770,440 611,500 0 0 2,381,940 5 Summary of Project Funding 2018/2019 Capital Improvement Program Funding To Proposed Estimated 2020 to Total Funds Program Date 2018/19 2019/20 Completion Other 3,000,000 0 0 0 3,000,000 Major Capital Equipment Sub-Total $ 5,361,257 $ 4,441,500 $ 98,000 $ 0 $ 9,900,757 Economic Development Certificates of Obligation 3,000,000 0 0 0 3,000,000 Reserves 10,630,167 750,000 0 0 11,380,167 Other 1,997,659 0 0 0 1,997,659 Economic Development Sub-Total $ 15,627,826 $ 750,000 $ 0 $ 0 $ 16,377,826 CIP Personnel Reserves 330,004 336,657 0 0 666,661 CIP Personnel Sub-Total $ 330,004 $ 336,657 $ 0 $ 0 $ 666,661 Other Reserves 313,158 94,000 0 0 407,158 Sales Tax 75,000 0 0 0 75,000 Other 140,185 0 0 0 140,185 Other Sub-Total $ 528,343 $ 94,000 $ 0 $ 0 $ 622,343 Total CIP Project Funding $ 158,484,535 $11,442,157 $ 909,000 $ 0 $ 170,835,692 6 Schedule 1 Street & Sidewalk Capital Projects Budget Summary Pg. Map Project To 2018/19 2019/20 2020 To Total No. ID Date Proposed Estimated Completion Protect Costs Continuing Projects 1 ST0401 Davis Blvd/Mid-Cities Blvd Intersection 7,359,231 0 0 0 $ 7,359,231 2 ST0904 Grand Avenue(Library to Health Markets Access Road) 75,000 0 0 0 $ 75,000 3 ST1102 Main St.Streetscaping&Snider St.Extension Project 2,866,050 0 0 0 $ 2,866,050 4 CDBG18 Meadow Court Road Reconstruction(CDBG) 308,456 0 0 0 $ 308,456 5 PW1602 Meadow Lakes Drive&Rufe Snow Drive Intersection 1,065,000 0 0 0 $ 1,065,000 SM1701 Preventive Street Maintenance(2017) 1,000,000 0 0 0 $ 1,000,000 SM1801 Preventive Street Maintenance(2018) 1,000,000 0 0 0 $ 1,000,000 6 ST0102 Rufe Snow Dr.Street&Utility Imp.(Karen Dnve to I.H.820) 1,475,950 0 0 0 $ 1,475,950 7 ST0202 Rufe Snow Dr.Street&Utility Imp.(Mid-Cities to Hightower)[TEA-21] 21,703,236 0 0 0 $ 21,703,236 8 ST1201 Rufe Snow Drive&Glenview Drive Intersection Improvements 1,685,000 0 0 0 $ 1,685,000 9 CDBG19 Schiller Drive Road Reconstruction(CDBG) 35,000 0 0 0 $ 35,000 SD1701 Sidewalk Rehabilitation and Replacement Project(2017) 50,000 0 0 0 $ 50,000 SD1801 Sidewalk Rehabilitation and Replacement Project(2018) 50,000 0 0 0 $ 50,000 10 ST1801 Smithfield Middle School Safe Routes to School(NCTCOG Grant) 263,921 0 0 0 $ 263,921 11 ST1304 Smithfield Road(Davis Blvd to Mid-Cities Blvd) 3,343,640 0 0 0 $ 3,343,640 12 ST1005 Traffic Signalization at Davis Boulevard&Creek View Drive 300,000 0 0 0 $ 300,000 13 ST1701 Vance and Glenview Signal Upgrades 230,000 0 0 0 $ 230,000 Total Continuing Projects $ 42,810,484 $ 0 $ 0 $ 0 $ 42,810,484 New Projects SM1901 Preventive Street Maintenance(2019) 0 1,000,000 0 0 $ 1,000,000 SM1902 Preventive Street Maintenance(Multi-Year) 0 1,575,000 0 0 $ 1,575,000 SD1901 Sidewalk Rehabilitation and Replacement Project(2019) 0 50,000 0 0 $ 50,000 ST1902 Street Assessment Project 0 140,000 0 0 $ 140,000 14 ST1901 TEXRaiI Signal Timing Coordination 0 100,000 0 0 $ 100,000 Total New Projects $ 0 $ 2,865,000 $ 0 $ 0 $ 2,865,000 Total Project Costs $ 42,810,484 $ 2,865,000 $ 0 $ 0 $ 45,675,484 Funding Sources General Obligation Bonds 9,850,950 0 0 0 $ 9,850,950 Certificates of Obligation 6,695,000 2,675,000 0 0 $ 9,370,000 Federal/State Grants 19,861,907 0 0 0 $ 19,861,907 Reserves 4,672,627 190,000 0 0 $ 4,862,627 Other 1,730,000 0 0 0 $ 1,730,000 Total Sources of Funds $ 42,810,484 $ 2,865,000 $ 0 $ 0 $ 45,675,484 7 Schedule 2 Drainage Capital Projects Budget Summary Pg. Map Project To 2018/19 2019/20 2020 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects 1 DR1503 Calloway Branch Channel Repair Project 1,126,258 0 0 0 $ 1,126,258 2 DR1801 Snow Heights Drainage Improvements Project 150,000 0 0 0 $ 150,000 3 DR1701 Walker Branch Channel Repair(200ft South of Harwood Road) 627,850 0 0 0 $ 627,850 Total Continuing Projects $ 1,904,108 $ 0 $ 0 $ 0 $ 1,904,108 New Projects 4 DR1901 Emerald Circle Drainage Protect 0 130,000 0 0 $ 130,000 DR1902 Street Drainage Improvements Protect(2019) 0 100,000 0 0 $ 100,000 Total New Projects $ 0 $ 230,000 $ 0 $ 0 $ 230,000 Total Project Costs $ 1,904,108 $ 230,000 $ 0 $ 0 $ 2,134,108 Funding Sources Reserves 1,754,108 230,000 0 0 $ 1,984,108 Other 150,000 0 0 0 $ 150,000 Total Sources of Funds $ 1,904,108 $ 230,000 $ 0 $ 0 $ 2,134,108 8 Schedule 3 Utility Capital Projects Budget Summary Pg. Map Project To 2018/19 2019/20 2020 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects 1 UT1801 Assess and Repair 16-inch Water Transmission Main 500,000 0 0 0 $ 500,000 UT0201 Big Fossil Creek Wastewater Outfall 1,200,000 0 0 0 $ 1,200,000 2 UT1701 College Hill Ground Storage Tank Stand Pipe 85,000 0 0 0 $ 85,000 3 UT1601 Franklin Court Sewer Addition and Gifford Connection 150,000 0 0 0 $ 150,000 4 UT1402 Johnson Pump Station Component and Infrastructure Replacements 275,000 0 0 0 $ 275,000 5 UT1702 Miscellaneous Water/Sewer Main Replacements(2017) 420,000 0 0 0 $ 420,000 UT1802 Miscellaneous Water/Sewer Main Replacements(2018) 420,000 0 0 0 $ 420,000 6 UT1404 Motor Operated Transfer Valves 730,000 0 0 0 $ 730,000 7 UT1604 Sanitary Sewer Line Replacements(Crabtree&Onyx N.) 125,000 0 0 0 $ 125,000 UT1703 Sanitary Sewer System Rehabilitation(Various Locations) 150,000 0 0 0 $ 150,000 8 UT1704 Sanitary Sewer System Trunk Line Rehabilitation 125,000 0 0 0 $ 125,000 9 UT1705 Small Water Main Replacements(2017) 420,000 0 0 0 $ 420,000 UT1803 Small Water Main Replacements(2018) 420,000 0 0 0 $ 420,000 UT1804 Telemetric Water Meter Annual Maintenance(2018) 400,000 0 0 0 $ 400,000 10 UT1607 Walker Branch Interceptor Project 6,016,525 0 0 0 $ 6,016,525 11 UT1505 Water Line Replacement on Susan Lee(Lola Dr.to N.Richland Blvd.) 790,000 0 0 0 $ 790,000 12 UT0810 Western Center Water Facility Expansion 55,000 0 0 0 $ 55,000 Total Continuing Projects $ 12,281,525 $ 0 $ 0 $ 0 $ 12,281,525 New Projects 13 UT19o1 Large Valve Replacement Project 0 95,000 0 0 $ 95,000 14 UT1902 Main/Snider/Center Utility Project 0 225,000 0 0 $ 225,000 15 UT1903 Miscellaneous Water/Sewer Main Replacement(2019) 0 445,000 0 0 $ 445,000 UT1904 Sewer Manhole Replacement and Rehabilation Project 0 150,000 0 0 $ 150,000 16 UT1905 Small Water Main Replacements(2019) 0 440,000 0 0 $ 440,000 UT1906 Telemetnc Water Meter Annual Maintenance(2019) 0 400,000 0 0 $ 400,000 Total New Projects $ 0 $ 1,755,000 $ 0 $ 0 $ 1,755,000 Total Project Costs $ 12,281,525 $ 1,755,000 $ 0 $ 0 $ 14,036,525 Funding Sources Certificates of Obligation 5,845,000 1,355,000 0 0 $ 7,200,000 Reserves 3,436,525 400,000 0 0 $ 3,836,525 Other 3,000,000 0 0 0 $ 3,000,000 Total Sources of Funds $ 12,281,525 $ 1,755,000 $ 0 $ 0 $ 14,036,525 9 Schedule 4 Parks & Recreation Capital Projects Budget Summary Pg. Map Project To 2018119 2019/20 2020 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects 1 PK1201 Adventure World Playground Renovation 653,239 0 0 0 $ 653,239 2 PK1701 Barfield Family Foundation Grant Program 50,000 0 0 0 $ 50,000 3 PK1401 Barfield/Cotton Belt Trail Connector 65,000 0 0 0 $ 65,000 4 PK1801 Green Valley Raceway Historical Area 30,000 0 0 0 $ 30,000 5 PK1802 Hometown Lakes Pedestrian Bndge Trail Connections 80,000 0 0 0 $ 80,000 6 PK1803 Nonch Park Playground Replacement and Shade 205,000 0 0 0 $ 205,000 7 PK1603 Northfield Park Renovation 6,116,659 0 0 0 $ 6,116,659 8 PK1504 Northfield Park Security Lights/Electrical System 35,000 0 0 0 $ 35,000 PK1506 Park Infrastructure Maintenance 2015 232,597 0 0 0 $ 232,597 PK1703 Park Infrastructure Maintenance 2017 257,000 0 0 0 $ 257,000 PK1804 Park Infrastructure Maintenance 2018 301,905 0 0 0 $ 301,905 PK1606 Park System Signage 479,486 0 0 0 $ 479,486 9 PK1805 Pump House A 100,000 0 0 0 $ 100,000 10 PK1507 Richland Tennis Center Infrastructure Maintenance(2015) 51,674 0 0 0 $ 51,674 11 PK1607 Richland Tennis Center Infrastructure Maintenance(2016) 29,552 0 0 0 $ 29,552 12 PK1704 Richland Tennis Center Infrastructure Maintenance 2017 17,169 0 0 0 $ 17,169 PK1806 Trail and On-Road Safety Projects 771,620 0 0 0 $ 771,620 Total Continuing Projects $ 9,475,901 $ 0 $ 0 $ 0 $ 9,475,901 New Projects PK1901 Annual Tree Planting 2019 0 45,000 0 0 $ 45,000 13 PK1902 Linda Scurlock Park Renovation 0 189,000 811,000 0 $ 1,000,000 14 PK1903 NRH Centre Indoor Aquatic Pool Re-Plaster 0 120,000 0 0 $ 120,000 PK1904 Park Infrastructure Maintenance 2019 0 284,000 0 0 $ 284,000 15 PK1905 Richland Tennis Center Infrastructure Maintenance 2019 0 20,000 0 0 $ 20,000 Total New Projects $ 0 $ 658,000 $ 811,000 $ 0 $ 1,469,000 Total Project Costs $ 9,475,901 $ 658,000 $ 811,000 $ 0 $ 10,944,901 Funding Sources Certificates of Obligation 3,900,000 0 0 0 $ 3,900,000 Federal/State Grants 1,117,294 0 0 0 $ 1,117,294 Reserves 620,485 209,000 0 0 $ 829,485 Sales Tax 2,533,397 449,000 811,000 0 $ 3,793,397 Other 1,304,725 0 0 0 $ 1,304,725 Total Sources of Funds $ 9,475,901 $ 658,000 $ 811,000 $ 0 $ 10,944,901 10 Schedule 5 Aquatic Park Capital Projects Budget Summary Pg. Map Project To 2018/19 2019/20 2020 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects WP1801 General Facility Improvements(2018) 100,000 0 0 0 $ 100,000 WP1802 Main Filtration Replacement 600,000 0 0 0 $ 600,000 Total Continuing Projects $ 700,000 $ 0 $ 0 $ 0 $ 700,000 New Projects WP1901 General Facility Improvements(2019) 0 100,000 0 0 $ 100,000 Total New Projects $ 0 $ 100,000 $ 0 $ 0 $ 100,000 Total Project Costs $ 700,000 $ 100,000 $ 0 $ 0 $ 800,000 Funding Sources Certificates of Obligation 600,000 0 0 0 $ 600,000 Reserves 100,000 100,000 0 0 $ 200,000 Total Sources of Funds $ 700,000 $ 100,000 $ 0 $ 0 $ 800,000 11 Schedule 6 Facilities Capital Projects Budget Summary Pg. Map Project To 2018/19 2019/20 2020 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects 1 FC1205 City Hall(Municipal Government Complex) 69,284,287 0 0 0 $ 69,284,287 2 FC1803 Fire Maintenance Awning 60,000 0 0 0 $ 60,000 3 FC1701 Overhead Door Replacement 52,000 0 0 0 $ 52,000 4 FC1702 Overhead Door Safety Edges&Remote Control Assemblies 68,800 0 0 0 $ 68,800 Total Continuing Projects $ 69,465,087 $ 0 $ 0 $ 0 $ 69,465,087 New Projects 5 FC1902 Permanent Records Roof Replacement&Building Envelope Seal 0 78,000 0 0 $ 78,000 6 FC1903 Replacement of HVAC Systems at Fire Stations#1 and#4 0 59,000 0 0 $ 59,000 7 FC1904 Upgrade/Remodel of Public Works'Restrooms 0 75,000 0 0 $ 75,000 Total New Projects $ 0 $ 212,000 $ 0 $ 0 $ 212,000 Total Project Costs $ 69,465,087 $ 212,000 $ 0 $ 0 $ 69,677,087 Funding Sources General Obligation Bonds 48,250,000 0 0 0 $ 48,250,000 Certificates of Obligation 18,600,000 0 0 0 $ 18,600,000 Reserves 180,800 212,000 0 0 $ 392,800 Other 2,434,287 0 0 0 $ 2,434,287 Total Sources of Funds $ 69,465,087 $ 212,000 $ 0 $ 0 $ 69,677,087 12 Schedule 7 Major Capital Equipment Capital Projects Budget Summary Pg. Map Project To 2018/19 2019/20 2020 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects FS1801 Ambulance Replacement Unit 973 362,232 0 0 0 $ 362,232 FS1802 BackhoeReplacementUnit479 125,000 0 0 0 $ 125,000 FS1803 Bucket Truck Replacement Unit 602 220,000 0 0 0 $ 220,000 IS1401 Cell Phone Signal Boosters in NRH Centre 98,000 0 0 0 $ 98,000 IT1701 Enterprise Computer System Replacement 95,000 2,905,000 0 0 $ 3,000,000 IT1702 Public Safety Technology 1,306,000 0 0 0 $ 1,306,000 IS1502 Replacement of CAD/RMS Public Safety Software Platform 3,020,000 0 0 0 $ 3,020,000 191402 Replacement of the Fuel Management Software System 135,025 0 0 0 $ 135,025 Total Continuing Projects $ 5,361,257 $ 2,905,000 $ 0 $ 0 $ 8,266,257 New Projects FS1901 Crack Sealing Machine Replacement(Unit 6632) 0 95,000 0 0 $ 95,000 FS1902 Distnbutor Truck Replacement(Unit 681) 0 200,000 0 0 $ 200,000 FS1903 Dump Truck Replacement(Unit 6617) 0 120,000 0 0 $ 120,000 IT1901 Network Replacement for Offsite City Facilities 0 122,500 98,000 0 $ 220,500 FS1906 NRH Centre/Senior Centre Accessible Van 0 62,000 0 0 $ 62,000 FS1905 NRH Centre/Senior Centre Accessible Van 0 62,000 0 0 $ 62,000 FS1904 Pothole Patcher Replacement(Unit 6609) 0 210,000 0 0 $ 210,000 FS1907 Skid Steer Loader Replacement(Unit 6630) 0 90,000 0 0 $ 90,000 FS1908 Street Sweeper Replacement(Unit 6613) 0 70,000 0 0 $ 70,000 FS1909 Utility Tractor Replacement(Unit 787) 0 55,000 0 0 $ 55,000 FS1910 Utility Tractor Replacement(Unit 788) 0 55,000 0 0 $ 55,000 FS1911 Vac-con Replacement(Unit 5522) 0 395,000 0 0 $ 395,000 Total New Projects $ 0 $ 1,536,500 $ 98,000 $ 0 $ 1,634,500 Total Project Costs $ 5,361,257 $ 4,441,500 $ 98,000 $ 0 $ 9,900,757 Funding Sources Certificates of Obligation 515,000 3,830,000 98,000 0 $ 4,443,000 Federal/State Grants 75,817 0 0 0 $ 75,817 Reserves 1,770,440 611,500 0 0 $ 2,381,940 Other 3,000,000 0 0 0 $ 3,000,000 Total Sources of Funds $ 5,361,257 $ 4,441,500 $ 98,000 $ 0 $ 9,900,757 13 Schedule 8 Economic Development Capital Projects Budget Summary Pg. Map Project To 2018/19 2019/20 2020 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects 1 ED0801 Business Improvement and Growth(BIG)Program 350,000 0 0 0 $ 350,000 ED1601 City Point Infrastructure 2,596,070 0 0 0 $ 2,596,070 2 ED1002 Loop 820 Redevelopment 2010 1,595,572 0 0 0 $ 1,595,572 3 ED1602 Loop 820 Redevelopment 2016 6,500,000 750,000 0 0 $ 7,250,000 4 ED1501 Neighborhood Revitalization Program(NRP) 336,184 0 0 0 $ 336,184 PW0402 Sign Removal Assistance Program 50,000 0 0 0 $ 50,000 5 ED0601 TIF 1 Expansion-Intersection Improvements/Utility Burial 3,000,000 0 0 0 $ 3,000,000 ED1503 TOD Land Management 1,200,000 0 0 0 $ 1,200,000 Total Continuing Projects $ 15,627,826 $ 750,000 $ 0 $ 0 $ 16,377,826 Total Project Costs $ 15,627,826 $ 750,000 $ 0 $ 0 $ 16,377,826 Funding Sources Certificates of Obligation 3,000,000 0 0 0 $ 3,000,000 Reserves 10,630,167 750,000 0 0 $ 11,380,167 Other 1,997,659 0 0 0 $ 1,997,659 Total Sources of Funds $ 15,627,826 $ 750,000 $ 0 $ 0 $ 16,377,826 14 Schedule 9 CIP Personnel Capital Projects Budget Summary Pg. Map Project To 2018/19 2019/20 2020 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects UC1901 Utility Capital Projects Personnel 330,004 336,657 0 0 $ 666,661 Total Continuing Projects $ 330,004 $ 336,657 $ 0 $ 0 $ 666,661 Total Project Costs $ 330,004 $ 336,657 $ 0 $ 0 $ 666,661 Funding Sources Reserves 330,004 336,657 0 0 $ 666,661 Total Sources of Funds $ 330,004 $ 336,657 $ 0 $ 0 $ 666,661 15 Schedule 10 Other Capital Projects Budget Summary Pg. Map Project To 2018/19 2019/20 2020 To Total No. ID Date Proposed Estimated Completion Project Costs Continuing Projects - - ES0902 Litter Not Program 25,000 0 0 0 $ 25,000 - - ES0901 Neighborhood Initiative Program 313,158 94,000 0 0 $ 407,158 - - PL1501 Strategic Plan 150,000 0 0 0 $ 150,000 - - PW1601 TEX Rail 40,185 0 0 0 $ 40,185 Total Continuing Projects $ 528,343 $ 94,000 $ 0 $ 0 $ 622,343 Total Project Costs $ 528,343 $ 94,000 $ 0 $ 0 $ 622,343 Funding Sources Reserves 313,158 94,000 0 0 $ 407,158 Sales Tax 75,000 0 0 0 $ 75,000 Other 140,185 0 0 0 $ 140,185 Total Sources of Funds $ 528,343 $ 94,000 $ 0 $ 0 $ 622,343 16 Schedule 11 2017-18 Budget Revisions Budget Summary Adopted Budget 2017-18 Project Project Through Revision Revised Number Name 2017-18 2017-18 Budget STREET&SIDEWALK CAPITAL PROJECTS CDBG16 Lynda Court(CDBG) $261,821 ($35,000) $226,821 CDBG18 Meadow Court Road Reconstruction 247,837 60,619 308,456 CDBG19 Reconstruction of Schiller Drive(CDBG) 0 35,000 35,000 PW1602 Meadow Lakes Drive&Rufe Snow Drive Intersection 1,315,000 (250,000) 1,065,000 ST0102 Rufe Snow Dr.Street&Utility Imp.(Karen Drive to I.H.820) 1,535,950 (60,000) 1,475,950 ST0401 Davis Blvd/Mid-Cities Blvd Intersection 6,702,744 656,487 7,359,231 ST1101 Main Street Streetscaping Project 66,000 (66,000) 0 ST1102 Main St.Streetscaping&Snider St.Extension Project 2,800,050 66,000 2,866,050 ST1201 Rufe Snow Drive&Glenview Drive Intersection Improvements 2,185,000 (500,000) 1,685,000 ST1203 Smithfield Road/Davis Boulevard Intersection Improvements 70,000 (33,640) 36,360 ST1304 Smithfield Road(Davis to Mid-Cities Blvd.) 2,200,000 1,143,640 3,343,640 Sub-Total $17,384,402 $1,017,106 $18,401,508 DRAINAGE CAPITAL PROJECTS DR1503 Calloway Branch Channel Repair Project $980,314 $145,944 $1,126,258 DR1601 Drainage Improvements 10,944 (10,944) 0 DR1701 Walker Branch Channel Repair(200 ft South of Hardwood Rd.) 892,850 (265,000) 627,850 DR1801 Snow Heights Drainage Improvements Project 0 150,000 150,000 Sub-Total $1,884,108 $20,000 $1,904,108 PARKS&RECREATION CAPITAL PROJECTS PK9602 Little Bear Creek Trail Development(John Barfield Trail Dev) $2,731,342 ($239,102) $2,492,240 PK9601 Calloway Branch Trail Development $1,484,311 ($82,848) 1,401,463 PK1507 Richland Tennis Center Infrastructure Maintenance(2015) $59,900 ($8,226) 51,674 PK1607 Richland Tennis Center Infrastructure Maintenance(2016) $30,000 ($448) 29,552 PK1704 Richland Tennis Center Infrastructure Maintenance(2017) $18,000 ($831) 17,169 PK1804 Park Infrastructure Maintenance(2018) $292,400 $9,505 301,905 PK1603 Northfield Park Renovation 6,083,521 33,138 6,116,659 PK1806 Trail and On-Road Safety Projects $771,618 ($41,075) 730,543 Sub-Total $11,471,092 ($329,887) $11,141,205 UTILITY CAPITAL PROJECTS CDBG17 Harmonson Road Sanitary Sewer Improvements $771,000 ($170,000) $601,000 UT1307 Sanitary Sewer System Rehabilitation of Main Lines(Phase II) 1,125,000 (110,000) 1,015,000 UT1607 Walker Branch 4,816,525 1,200,000 6,016,525 Sub-Total $6,712,525 $920,000 $7,632,525 MAJOR CAPITAL EQUIPMENT IS1402 Replacement of the Fuel Management Software System $90,000 $45,025 $135,025 IT1702 Public Safety Technology 1,306,000 0 1,306,000 Sub-Total $1,396,000 $45,025 $1,441,025 OTHER CAPITAL PROJECTS ES0901 Neighborhood Initiative Program $252,158 $61,000 $313,158 Sub-Total $252,158 $61,000 $313,158 Total All Projects $39,100,285 $1,733,244 $40,833,529 SOURCES OF FUNDS General Obligation Bonds $2,510,950 $0 $2,510,950 Certificates of Obligations 9,565,000 580,000 10,145,000 Federal/State Grants 11,435,819 124,915 11,560,734 Reserves 8,387,991 373,688 8,761,679 Sales Tax 2,090,525 54,641 2,145,166 Other 5,110,000 600,000 5,710,000 Total Sources of Funds $39,100,285 $1,733,244 $40,833,529 17 Street & Sidewalk Capital Projects Lynda Court CDBG CDBG 16 PROJECT DESCRIPTION&JUSTIFICATION This is the 41st Year Community Development Block Grant(CDBG)project. The existing street is an asphalt pavement section and it will be reconstructed as a 31 foot wide concrete pavement section. Reconstruction of the street will also include pavement excavation, curb and gutter replacement, sub-grade stabilization, installation of sidewalks,street right-of-way restoration and utility improvements. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering 01/2015 09/2016 Land/ROW Acquisition Construction 10/2015 09/2016 Other REVISION EXPLANATION The project came in under budget and we would like to transfer$35,000.00 to the CDBG18 Meadow Court project in order to fulfill a pledge request from Tarrant County. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION 2017/18 BALANCE COST FUNDING SOURCES Grants CDBG $226,821 $226,821 $226,821 G.O. 35,000 (35,000) 0 $0 0 $0 0 $0 0 $0 Total $261,821 ($35,000) $226,821 $0 $226,821 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 32,700 32,700 $32,700 Land/ROW Acquistion 0 $0 Construction 229,121 (35,000) 194,121 $194,121 Other 0 $0 Total $261,821 ($35,000) $226,821 $0 $226,821 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 18 Street & Sidewalk Capital Projects Meadow Court CDBG CDBG 18 PROJECT DESCRIPTION&JUSTIFICATION This is the 43rd Year Community Development Block Grant(CDBG)Project. The project will consist of reconstructing the entire length(440 linear feet)of Meadow Court. In addition to the reconstruction of the street portion of the block,the project will also include the reconstruction of the 40 foot cul-de-sac radius. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2017 09/2018 Land/ROW Acquisition Construction 10/2017 09/2018 Other REVISION EXPLANATION Tarrant County determined that the actual allocation of funds for the 43rd year CDBG was higher than originally anticipated. However,the project came in over budget due to increased construction costs and we would like to transfer$35,000.00 from the CDBG16 Lynda Court project in order to fulfill a pledge request from Tarrant County. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017/18 BALANCE COST FUNDING SOURCES Grants CDBG $247,837 $25,619 $273,456 $273,456 G.O. 35,000 35,000 $35,000 0 $0 0 $0 0 $0 Total $247,837 $60,619 $308,456 $0 $308,456 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 37,806 2,264 40,070 $40,070 Land/ROW Acquistion 0 $0 Construction 210,031 58,355 268,386 $268,386 Other 0 $0 Total $247,837 $60,619 $308,456 $0 $308,456 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 19 Street & Sidewalk Capital Projects Reconstruction of Schiller Drive (CDBG) CDBG 19 PROJECT DESCRIPTION&JUSTIFICATION In 1996, HUD designated the City of North Richland Hills as a metropolitan city to receive direct entitlement of Community Development Block Grant(CDBG)funds. On June 24, 1996 the City Council accepted the direct entitlement designation and entered into an agreement with Tarrant County for the administration of the City's CDBG program.As a result of the direct entitlement designation,the City is awarded an annual grant on a formula basis to help provide a wide range of community development activities. CDBG funds are used in the revitalization of neighborhoods,economic development, and to provide public facilities and services for low to moderate income persons. Eligible CDBG projects include construction or rehabilitation of homes, basic infrastructure development such as water/sewer facilities, streets and other programs that target designated areas or persons. Each program year,the City must prepare and submit a CDBG program outlining the use of these funds in accordance with HUD guidelines. Staff was informed that the City of North Richland Hills will be awarded approximately $250,000 for the 44th Year CDBG program. Funding will be used for the reconstruction of the entire length of Schiller Drive. PROJECT STATUS ORIGINAL 2017/18 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2018 09/2019 Other REVISION EXPLANATION The reconstruction of Schiller Drive is being proposed as the City's 44th Year CDBG Project due to the poor condition of the street.The project will be managed and paid for directly by Tarrant County with the City being responsible for submitting our share directly to the county. Funding in the amount of$35,000 is being recommended by staff to come from vacancy savings in the General Fund. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION • 2017/18 BALANCE COST FUNDING SOURCES General Fund $0 $35,000 $35,000 $35,000 0 $0 0 $0 0 $0 0 $0 Total $0 $35,000, $35,000 $0 $35,000 PROJECT EXPENDITURES Professional Services $0 $0 . Engineering/Design 0 0 $0 Land/ROW Acquistion 0 $0 Construction 0 35,000 35,000 $35,000 Other 0 $0 Total $0 $35,000 $35,000 $0 $35,000 IMPACT ON OPERATING BUDGET Not applicable. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 20 Street & Sidewalk Capital Projects Meadow Lakes Drive & Rufe Snow Drive Intersection PW1602 PROJECT DESCRIPTION&JUSTIFICATION The area along Rufe Snow,south of LP 820, is severely congested with 7 different ingress/egress points within a 700 foot span.The project proposes the conversion of the current Rufe Snow/Meadow Lakes 3 way signalized intersection into a 4 way signalized intersection that would be a separate but complimentary project to ST0102-Rufe Snow Drive Street&Utility Improvements,which calls for a raised median along Rufe Snow.This project would extend Meadow Lakes east of Rufe Snow, connecting to the commercial area along LP 820. The project would also eliminate 3 of the 7 ingress/egress points within the 700 foot span. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services Engineering 05/2016 09/2017 Land/ROW Acquisition 05/2016 09/2017 Construction 05/2016 07/2017 09/2017 02/2018 Other REVISION EXPLANATION Project construction costs were lower than anticipated as the recently completed Rufe Snow Drive project included some of the streets/signal components necessary for the Meadow Lakes connection. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION 2017/18 BALANCE COST FUNDING SOURCES Certificates of Obligation $1,315,000 ($150,000) $1,165,000 $1,165,000 0 $0 0 $0 0 $0 0 $0 Total $1,315,000 ($150,000) $1,165,000 $0 $1,165,000 PROJECT EXPENDITURES $0 $0 Professional Services Engineering/Design 80,000 80,000 $80,000 Land/ROW Acquistion 435,000 435,000 $435,000 Construction 800,000 (150,000) 650,000 $650,000 Other 0 $0 Total $1,315,000 ($150,000) $1,165,000 $0 $1,165,000 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 21 Street & Sidewalk Capital Projects Meadow Lakes Drive& Rufe Snow Drive Intersection PW1602 PROJECT DESCRIPTION&JUSTIFICATION The area along Rufe Snow, south of Loop 820, is severely congested with 7 different ingress/egress points within a 700 foot span. The project proposes the conversion of the current Rufe Snow/Meadow Lakes 3-way signalized intersection into a 4-way signalized intersection that would be a separate but complimentary project to ST0102-Rufe Snow Drive STreet&Utility Improvements,which calls for a raised median along Rufe Snow. The project would extend Meadow Lakes east of Rufe Snow, connecting to the commercial area along Loop 820. The project would also eliminate 3 of the 7 ingress/egress points within the 700 foot span. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering 05/2016 05/2016 09/2017 03/2017 Land/ROW Acquisition 05/2016 05/2016 09/2017 09/2017 Construction 05/2016 07/2017 01/2018 02/2018 Other REVISION EXPLANATION Construction of the roadway extension came in lower than anticipated. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017/18 BALANCE COST FUNDING SOURCES Certificates of Obligation $1,165,000 ($100,000) $1,065,000 $1,065,000 0 $0 0 $0 0 $0 0 $0 Total $1,165,000 ($100,000) $1,065,000 $0 $1,065,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 80,000 80,000 $80,000 Land/ROW Acquistion 435,000 435,000 $435,000 Construction 650,000 (100,000) 550,000 $550,000 Other 0 $0 Total $1,165,000 ($100,000) $1,065,000 $0 $1,065,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 22 Street& Sidewalk Capital Projects Rufe Snow Dr. Street& Utility Imp. (Karen Drive to I.H. 820) ST0102 PROJECT DESCRIPTION&JUSTIFICATION This project begins at Karen Drive and ends on the north side of Corona Drive(approximate ending of the TxDOT Bridge project). The intersection at Meadow Lakes Drive will be improved as part of this project. Rufe Snow Drive will be widened with right turn lanes and improved signalization.This section will transition from the wider section at the bridge to the 4 lane section at Karen Drive.The project will be constructed as a concrete street with sidewalks and all necessary water and sewer main adjustments. Street lights and signalization at Meadow Lakes will be constructed to the City's standards. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services Engineering 01/2001 02/2006 05/2008 04/2015 Land/ROW Acquisition 08/2008 08/2008 01/2015 01/2015 Construction 06/2014 05/2015 12/2016 03/2017 Other REVISION EXPLANATION Project construction was complete in 2017 with final construction costs coming in lower than anticipated. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017118 BALANCE COST FUNDING SOURCES GO Bonds $1,425,950 $1,425,950 $1,425,950 Reserves 110,000 (60,000) 50,000 $50,000 0 $0 0 $0 0 $0 Total $1,535,950 ($60,000) $1,475,950 $0 $1,475,950 PROJECT EXPENDITURES $0 $0 Professional Services Engineering/Design 170,000 170,000 $170,000 Land/ROW Acquistion 198,331 198,331 $198,331 Construction 1,167,619 (60,000) 1,107,619 $1,107,619 Other 0 $0 Total $1,535,950 ($60,000) $1,475,950 $0 $1,475,950 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 23 Street & Sidewalk Capital Projects Davis Blvd / Mid-Cities Blvd Intersection ST0401 PROJECT DESCRIPTION&JUSTIFICATION This project consist of intersection improvements at the Davis Blvd and Mid-Cities Blvd Intersection.The improvements include adding additional right and left turn lanes,signalization improvements,and all necessary water and sewer main adjustments. This project is a 2003 Bond Program Project.This intersection is located on a major east/west and north/south thoroughfare that runs through NE Tarrant County. Heavy traffic congestion is experienced during peak hours.As of 2006, more than 53,000 vehicles travel this intersection per day. In the future,this intersection will experience significant development which will add to the traffic congestion. Improvements to this intersection will reduce the traffic congestion and provide added capacity to handle future traffic volumes. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services 10/2013 05/2008 Engineering 07/2008 10/2014 Land/ROW Acquisition 08/2014 04/2017 10/2017 Construction 06/2017 11/2017 02/2018 04/2019 Other REVISION EXPLANATION, Additional funds are needed to cover an increase in both engineering and construction cost on the project. Recently,the Regional Transportation Council approved a modification to the Transportation Improvement Program(TIP)which allows for additional federal fundings on this project.The increase amount of$656,487 was approved,with a 80/20 split.The city would be responsible for$131,297.00. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017/18 BALANCE COST FUNDING SOURCES GO Bonds $1,050,000 $1,050,000 $1,050,000 CO Bonds 500,000 130,000 630,000 $630,000 Grant 3,720,084 525,190 4,245,274 $4,245,274 Reserves 1,432,660 1,297 1,433,957 $1,433,957 0 $0 Total $6,702,744_ $656,487 $7,359,231 $0 $7,359,231 PROJECT EXPENDITURES Professional Services $107,000 $107,000 $107,000 Engineering/Design 582,000 90,493 672,493 $672,493 Land/ROW Acquistion 400,000 400,000 $400,000 Construction 4,713,755 565,994 5,279,749 $5,279,749 Other 899,989 899,989 $899,989 Total $6,702,744 $656,487 $7,359,231 $0 $7,359,231 IMPACT ON OPERATING BUDGET No additional impact is projected at this time. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 24 Street& Sidewalk Capital Projects Main Street Streetscaping Project ST 1101 PROJECT DESCRIPTION&JUSTIFICATION Main Street between Davis Boulevard and Smithfield Road is designated for a pedestrian friendly, mixed use environment directly adjacent to the future Smithfield commuter rail station as part of the approved Smithfield TOD district. The existing Main Street pavement section is 36 feet wide with no sidewalks or organized street tree plantings or features. Scheduled improvements include 11 foot wide sidewalks with street trees, pedestrian lights, bench seats,trash receptacles, bike racks and crosswalk striping. Also included is restriping Main Street to allow for on street parking and funds for right way to provide streetscaping improvements. PROJECT STATUS ORIGINAL 2017/18 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering 03/2018 10/2018 Land/ROW Acquisition 03/2017 09/2017 Construction 03/2019 10/2020 Other REVISION EXPLANATION Funding consolidated into ST1102. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION 2017/18 BALANCE COST FUNDING SOURCES Project Savings $66,000 ($66,000) $0 $0 0 $0 0 $0 0 $0 0 $0 Total $66,000_ ($66,000) $0 $0 $0 PROJECT EXPENDITURES $0 $0 Professional Services Engineering/Design 46,000 (46,000) 0 $0 Land/ROW Acquistion 20,000 (20,000) 0 $0 Construction 0 $0 Other 0 $0 Total $66,000 ($66,000) $0 $0 $0 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 _ 2020/21 2021/22 TOTAL Projected - $0 25 Street & Sidewalk Capital Projects Main St. Streetscaping &Snider St. Extension Project ST1102 PROJECT DESCRIPTION&JUSTIFICATION This project connects Main St. and expands Snider St.with the Smithfield Station. Located in the center of the Smithfield Transit Oriented Development, Main St. is an existing street that lacks lacks pedestrian infrastructure such as sidewalks,street furniture, lighting and trees. Snider St. intersects with Main St.and will be extended northward as a pedestrian friendly street (sidewalks, street furniture, lighting and trees).A majority of the funds come from the NCTCOG Sustainable Development Funding Program that connects public transportation, pedestrian mobility and mixed use development. Project funding is contingent upon NCTCOG approval and notice to proceed. PROJECT STATUS ORIGINAL 2017/18 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering 03/2018 09/2018 Land/ROW Acquisition Construction 11/2018 10/2019 Other REVISION EXPLANATION Funding consolidated from ST1101. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION 2017118 BALANCE COST FUNDING SOURCES Federal/State Grants $2,240,040 $2,240,040 $2,240,040 Other 430,000 430,000 $430,000 Reserves 130,010 130,010 $130,010 Reserves-Project Savings 66,000 66,000 $66,000 0 $0 Total $2,800,050_ $66,000 $2,866,050 $0 $2,866,050 PROJECT EXPENDITURES $0 $0 Professional Services Engineering/Design 254,550 254,550 $254,550 Land/ROW Acquistion 2,545,500 66,000 2,611,500 $2,611,500 Construction 0 $0 Other 0 $0 Total $2,800,050 $66,000 $2,866,050_ $0 $2,866,050 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 26 Street & Sidewalk Capital Projects Rufe Snow Drive&Glenview Drive Intersection Improvements ST1201 PROJECT DESCRIPTION&JUSTIFICATION This project consists of improvements to the intersection of Rufe Snow Dr.and Glenview Drive. The intersection at Rufe Snow and Glenview will be widened to accommodate dedicated left turn lanes on Rufe Snow, and a new signal will be added at Chapel Park Drive and Glenview Drive to provide better ingress/egress to the school campus on Glenview. The project is funded in part through a City/Developer Agreement with the IL Texas Charter School whereby the school pays for 80%of the design and construction,with the City covering 20%of those costs. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services 11/2011 02/2016 03/2017 07/2017 Engineering 09/2016 09/2016 12/2016 12/2016 Land/ROW Acquisition 05/2017 07/2017 11/2017 03/2018 Construction Other REVISION EXPLANATION The improvements to the Rufe Snow/Glenview and Chapel Park/Glenview intersections as part of the Charter School development were accomplished under budget due to reduced lane width limiting the amount of additional ROW acquisition and construction savings realized by only adding pavement to one side of the roadway. The developer will be receiving a reimbursement once the project is complete per the terms of the CDA. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017118 BALANCE COST FUNDING SOURCES Reserves $885,000 ($500,000) $385,000 $385,000 Other(Developer Agreement) 1,300,000 1,300,000 $1,300,000 0 $0 0 $0 0 $0 Total $2,185,000 ($500,000) $1,685,000 $0 _ $1,685,000 PROJECT EXPENDITURES $0 $0 Professional Services Engineering/Design 500,000 500,000 $500,000 Land/ROW Acquistion 300,000 300,000 $300,000 Construction 1,385,000 (500,000) 885,000 $885,000 Other 0 $0 Total $2,185,000 ($500,000) $1,685,000 $0 $1,685,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 27 Street & Sidewalk Capital Projects Smithfield Road/ Davis Boulevard Intersection Improvements ST1203 PROJECT DESCRIPTION&JUSTIFICATION This project will consist of the preliminary design and traffic impact study for the intersection of Smithfield Road and Davis Boulevard. The City's Master Thoroughfare Plan calls for Smithfield Road to be realigned so that it connects into Davis Boulevard at Bridge Street instead of the current connection just north of the Post Office.The purpose of this project is to evaluate the impacts of traffic at key points along Davis Boulevard with the main focus of the study on the traffic impacts at the Post Office and the Smithfield Road/Davis Boulevard intersection. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services 01/2012 01/2012 09/2015 09/2015 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION The traffic study was performed and the remaining funds are no longer needed. The Smithfield Road project will be accomplishing the realignment that was studied with these project funds. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017118 BALANCE COST FUNDING SOURCES Reserves $70,000 ($33,640) $36,360 $36,360 0 $0 0 $0 0 $0 0 $0 Total $70,000 ($33,640) $36,360 $0 $36,360 PROJECT EXPENDITURES Professional Services $70,000 ($33,640) $36,360 $36,360 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 0 $0 Other 0 $0 Total _ $70,000 ($33,640) $36,360 $0 $36,360 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 28 Street & Sidewalk Capital Projects Smithfield Road (Davis to Mid-Cities Blvd.) ST1304 PROJECT DESCRIPTION&JUSTIFICATION This project consists of realigning a portion of Smithfield Road so that it connects directly to Bridge Street at Davis Blvd and reconstructing the existing section of Smithfield Road north to a point approximately 100 feet north of Mid-Cities Blvd.The improvements will consist of modifying the signal light at the Davis Blvd intersection so that all four sides will be signalized instead of the 3 sides that currently exists. In addition the new road will be constructed with concrete and include sidewalks and a drainage system.This section of Smithfield Road is located in the Smithfield TOD and will be constructed to the TOD criteria. PROJECT STATUS ORIGINAL 2017/18 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering 11/2013 11/2013 03/2015 03/2017 Land/ROW Acquisition 04/2015 04/2014 03/2016 03/2017 Construction 09/2015 03/2018 11/2016 03/2019 Other REVISION EXPLANATION The project costs for ROW and construction came exceeded budget estimates. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION. 2017118 BALANCE COST FUNDING SOURCES General Obligation Bonds $1,650,000 $1,650,000 $1,650,000 Federal/State Grants 550,000 550,000 $550,000 Reserves 1,043,640 1,043,640 $1,043,640 Certificates of Obligation 100,000 100,000 $100,000 0 $0 Total $2,200,000 $1,143,640 $3,343,640 $0 $3,343,640 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 340,000 (85,290) 254,710 $254,710 Land/ROW Acquistion 170,000 382,464 552,464 $552,464 Construction 1,690,000 846,466 2,536,466 $2,536,466 Other 0 $0 Total $2,200,000 $1,143,640 $3,343,640 $0 $3,343,640 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 29 Drainage Capital Projects Calloway Branch Channel Repair Project DR 1503 PROJECT DESCRIPTION&JUSTIFICATION This is for the repair of failing channel along the Calloway Branch Channel that has resulted in the loss of material in several backyards along Waggoner Ranch Road. Erosion caused by excessive rains following the years of recent drought caused bank failure along the west bank of the Calloway Branch channel adjacent to the Graham Ranch subdivision. This project will restore the west bank in the vicinity of the Graham Ranch properties and fortify the bank to prevent a future recurrence. Because the project is located within FEMA's regulatory floodway, both a CLOMR and LOMR will be required. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services Engineering 09/2015 11/2016 Land/ROW Acquisition Construction 01/2016 11/2017 04/2018 Other REVISION EXPLANATION Project savings from DR1701 were needed to cover a cost overrun in the construction bid received($95,000)and project savings from DR1501 were needed due to an unexpected repair work at a residence on Waggoner Ranch Road related to damages caused during this project($40,000). FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017/18 BALANCE COST FUNDING SOURCES Reserves $980,314 $135,000 $1,115,314 $1,115,314 0 $0 0 $0 0 $0 0 $0 Total $980,314 $135,000 $1,115,314 $0 $1,115,314 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 98,500 98,500 $98,500 Land/ROW Acquistion 0 $0 Construction 881,814 135,000 1,016,814 $1,016,814 Other 0 $0 Total $980,314 $135,000 $1,115,314 $0 $1,115,314 IMPACT ON OPERATING BUDGET None. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 30 Drainage Capital Projects Calloway Branch Channel Repair Project DR 1503 PROJECT DESCRIPTION&JUSTIFICATION This is for the repair of failing channel along the Calloway Branch Channel that has resulted in the loss of material in several backyards along Waggoner Ranch Road. Erosion caused by excessive rain following the years of recent drought caused bank failure along the west bank of the Calloway Branch channel adjacent to the Graham Ranch subdivision. Erosion along the Calloway Branch channel is impacting at least one residential property and threatening a number of other properties along Waggoner Ranch Road. Restoring and stabilizing the channel bank is necessary to prevent channel encroachment into adjacent properties. PROJECT STATUS ORIGINAL 2017/18 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering 09/2015 11/2016 Land/ROW Acquisition Construction 01/2016 11/2017 Other REVISION EXPLANATION Additional funds are requested for construction due to increase construction cost. Project savings in the amount of$10,944.00 from DR1601are available for use. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION 2017/18 BALANCE COST FUNDING SOURCES Reserves $1,115,314 $10,944 $1,126,258 $1,126,258 0 $0 0 $0 0 $0 0 $0 Total $1,115,314 $10,944 $1,126,258 $0 $1,126,258 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 98,500 98,500 $98,500 Land/ROW Acquistion 0 $0 Construction 1,016,814 10,944 1,027,758 $1,027,758 Other 0 $0 Total $1,115,314 $10,944 $1,126,258 $0 $1,126,258 IMPACT ON OPERATING BUDGET Minimal operating impact is anticipated. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 31 Drainage Capital Projects Drainage Improvements DR1601 PROJECT DESCRIPTION&JUSTIFICATION There are two sections to the drainage improvement project. The first section consists of construction of a concrete drainage flume in the Holiday West Addition, between Meadow Park Drive North and the Holiday West Channel. The second section consists of reconstructing a concrete flume in the Steeple Ridge subdivision. PROJECT STATUS ORIGINAL 2017/18 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering 11/2016 07/2017 Land/ROW Acquisition Construction Other REVISION EXPLANATION Project closed. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION 2017/18 BALANCE _ COST FUNDING SOURCES Reserves $10,944 ($10,944) $0 $0 0 $0 0 $0 0 $0 0 $0 Total $10,944 ($10,944) $0 $0 $0 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 10,944 (10,944) 0 $0 Land/ROW Acquistion 0 $0 Construction 0 $0 Other 0 $0 Total $10,944 ($10,944) $0 $0 $0 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 32 Drainage Capital Projects Walker Branch Channel Repair(200ft South of Harwood Road) DR 1701 PROJECT DESCRIPTION&JUSTIFICATION This project consists of engineering and reconstructing approximately 400 feet of gabions along the Walker Branch Channel. The project begins south of Harwood along the west bank and will focus on two areas where the gabion baskets have failed. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2017 04/2018 03/2018 10/2018 Land/ROW Acquisition Construction 05/2018 11/2018 10/2018 05/2019 Other REVISION EXPLANATION The scope of the project is being reconsidered to evaluate options other than restoration of the existing channel cross section, inlcuding possible land acquisition to accommodate a wider channel section and reduce the reliance on gabion structures. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017/18 BALANCE COST FUNDING SOURCES Reserves $797,850 ($170,000) $627,850 $627,850 0 $0 0 $0 0 $0 0 $0 Total $797,850 ($170,000) $627,850 $0 $627,850 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 160,000 160,000 $160,000 Land/ROW Acquistion 0 $0 Construction 637,850 (170,000) 467,850 $467,850 Other 0 $0 Total $797,850 ($170,000) $627,850 $0 $627,850 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 33 Drainage Capital Projects Walker Branch Channel Repair(200 Ft. South of Hardwood Rd.) DR1701 PROJECT DESCRIPTION&JUSTIFICATION The project consists of engineering and reconstructing approximately 400 feet of gabions along the Walker Branch Channel. The project begins south of Harwood along the west bank and will focus on two areas where the gabion baskets have failed. Because of record rainfall received in 2015 following years of drought conditions significant erosion has occurred in recent months. As a result of the soil conditions due to these weather events,the Walker Branch Channel has experienced several failures along the banks adjacent to residential properties and the situation continues to deteriorate.Without fortification of the bank in this area,the erosion will progress into private property. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2017 03/2018 03/2019 Land/ROW Acquisition Construction 05/2018 10/2018 10/2019 Other REVISION EXPLANATION Project savings were transferred to DR1503 to cover a cost overrun in the construction bid received($95,000). FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION 2017/18 BALANCE COST FUNDING SOURCES _ Reserves $892,850 ($95,000) $797,850 $797,850 0 $0 0 $0 0 $0 0 $0 Total $892,850 ($95,000) $797,850 $0 $797,850 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 160,000 160,000 $160,000 Land/ROW Acquistion 0 $0 Construction 732,850 (95,000) 637,850 $637,850 Other 0 $0 Total $892,850 ($95,000) $797,850 $0 $797,850 IMPACT ON OPERATING BUDGET None. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected _ $0 34 Drainage Capital Projects Snow Heights Drainage Improvements Project DR 1801 PROJECT DESCRIPTION&JUSTIFICATION The area along the eastbound Loop 820 frontage road,east of Rufe Snow Drive was developed decades ago with no underground drainage improvements.As a result the area becomes inundated during moderate rainfall events.The proposed underground storm drain system will provide capacity for almost 11 acres of commercially zoned property and ties into the storm drain improvements installed by TxDOT during the North Tarrant Express highway project several years ago.The scope of the project includes the installation of approximately 1,200 linear feet of concrete drainage pipe with intake structures. PROJECT STATUS ORIGINAL 2017/18 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2017 11/2017 Land/ROW Acquisition Construction 12/2017 02/2018 Other REVISION EXPLANATION This project was identified in October 2017 and is in the immediate vicinity of the Meadow Lakes Extension project. Funding was changed from debt issuance to Drainage Utility Fund Reserves. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017/18 BALANCE COST FUNDING SOURCES Reserves $0 $150,000 $150,000 $150,000 0 $0 0 $0 0 $0 0 $0 Total $0_ $150,000 $150,000 $0 $150,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 0 150,000 150,000 $150,000 Other 0 $0 Total $0 $150,000 $150,000 $0 _ $150,000 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 35 Parks & Recreation Capital Projects Little Bear Creek Trail Development PK9602 PROJECT DESCRIPTION&JUSTIFICATION Project previously named as Little Bear Creek Trail[ISTEA]. This project provides for land acquisition, design, and construction of 3.5 miles of multi-use trail along Little Bear Creek. The project has terminus points at Precinct Line and the Cotton Belt Trail intersection and at the northern end of Calloway Branch Trail. The project will provide trail access to Northfield Park,J.B. Sandlin Park,Tommy&Sue Brown Park and Dr. Pillow Park.All of the individual easements and right-of-way parcels for the trail have been assembled as subdivision development along the corridor has occurred since the project was originally initiated. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering 04/1996 09/2012 Land/ROW Acquisition Construction 04/2013 09/2018 Other REVISION EXPLANATION Revision made to correct for actual collections of federal and state grants. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION 2017/18 BALANCE COST FUNDING SOURCES Federal/State Grants $2,149,808 ($384,817) $1,764,991 $1,764,991 Sales Tax 581,534 145,715 727,249 $727,249 0 $0 0 $0 0 $0 Total $2,731,342 ($239,102) $2,492,240 $0 $2,492,240 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 489,739 1,735 491,474 $491,474 Land/ROW Acquistion 19,179 19,179 $19,179 Construction 2,222,424 (240,837) 1,981,587 $1,981,587 Other 0 $0 Total $2,731,342 ($239,102) $2,492,240 $0 $2,492,240 IMPACT ON OPERATING BUDGET Building impact is calculated from man-hour expenditures. ANNUAL OPERATING IMPACT 2017118 2018/19 2019/20 2020/21 2021/22 TOTAL Projected 8,118 $8,118 36 Parks & Recreation Capital Projects Calloway Branch Trail PK9601 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the design and construction of a 5 mile on-road/off-road multi-purpose concrete trail along the Calloway Branch Drainage Corridor from Liberty Park to the John Barfield Trail.This trail has terminus points at Holiday Lane and at the John Barfield Trail within the Little Bear Creek Community Park site. Connections are provided to Liberty Park, Richfield Park,the Cotton Belt Trail, and Cross Timbers Park.The project,and associated timeline, is being implemented concurrently with the John Barfield Trail. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services Engineering 04/1996 09/2012 Land/ROW Acquisition Construction 04/2013 09/2018 Other REVISION EXPLANATION Project was completed under budget. A portion of the savings($33,138)was moved to PK1603 Northfield Park with the balance released to reserves. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION 2017/18 BALANCE COST FUNDING SOURCES Federal/State Grants $733,120 $733,120 $733,120 Sales Tax 751,191 (82,848) 668,343 $668,343 0 0 0 $0 0 0 0 $0 0 $0 Total $1,484,311 ($82,848) $1,401,463 $0 $1,401,463 PROJECT EXPENDITURES Professional Services $0 $0 $0 Engineering/Design 275,973 (973) 275,000 $275,000 Land/ROW Acquistion 0 0 $0 Construction 1,208,338 - (81,875) 1,126,463 $1,126,463 Other 0 0 $0 Total $1,484,311 ($82,848) $1,401,463 $0 $1,401,463 IMPACT ON OPERATING BUDGET No additional impact is projected at this time. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 37 Parks & Recreation Capital Projects RTC Infrastructure Maintenance 2015 PK1507 PROJECT DESCRIPTION&JUSTIFICATION This project provides for maintenance of the Tennis Center Infrastructure in response to use and age.The Parks and Recreation Department developed an Infrastructure Management Plan for the Richland Tennis Center,which addresses long term funding needs for replacement and renovation, and demonstrates responsible stewardship of property assets by the City on behalf of its citizens. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2014 10/2014 09/2015 07/2018 Other REVISION EXPLANATION Savings from RTC's Infrastructure Maintenance 2015 are being reallocated to PK1804 to help cover the cost of emergency repairs to the bridge deck on the North Electric Trail(near RHS BB fields). FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017/18 _ BALANCE COST FUNDING SOURCES Federal/State Grants $0 $0 Reserves 0 $0 Sales Tax 59,900 (8,226) 51,674 $51,674 0 $0 0 $0 Total $59,900 ($8,226) $51,674 $0 $51,674 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 59,900 (8,226) 51,674 $51,674 Other 0 $0 Total $59,900 ($8,226) $51,674 $0 $51,674 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 38 Parks & Recreation Capital Projects RTC Infrastructure Maintenance 2016 PK1607 PROJECT DESCRIPTION&JUSTIFICATION This project provides for maintenance of the Tennis Center Infrastructure in response to use and age.The FY2015-16 priorities will be the renovation of 16 tennis court benches, replacement of the shade fabric over court-side benches and painting building columns, patio and entrance awnings. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2015 10/2015 09/2016 07/2018 Other REVISION EXPLANATION Savings from RTC's Infrastructure Maintenance 2016 are being reallocated to PK1804 to help cover the cost of emergency repairs to the bridge deck on the North Electric Trail(near RHS BB fields). FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION 2017/18 BALANCE COST FUNDING SOURCES Federal/State Grants $0 $0 Reserves 0 $0 Sales Tax 30,000 (448) 29,552 $29,552 0 $0 0 $0 Total $30,000 ($448) $29,552 $0 $29,552 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 30,000 (448) 29,552 $29,552 Other 0 $0 Total $30,000 ($448) $29,552 $0 $29,552 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 39 Parks & Recreation Capital Projects RTC Infrastructure Maintenance 2017 PK 1704 PROJECT DESCRIPTION&JUSTIFICATION This project provides for maintenance of the Tennis Center Infrastructure in response to use and age.The FY2016-17 priorities will be to provide new speakers for a recently renovated Public Address system and to relamp the lighting fixtures on all tennis courts except for the championship court. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2016 10/2016 10/2017 07/2018 Other REVISION EXPLANATION Savings from RTC's Infrastructure Maintenance 2017 are being reallocated to PK1804 to help cover the cost of emergency repairs to the bridge deck on the North Electric Trail(near RHS BB fields). FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017/18 BALANCE COST FUNDING SOURCES Federal/State Grants $0 $0 Reserves 0 $0 Sales Tax 18,000 (831) 17,169 $17,169 0 $0 0 $0 Total $18,000 ($831) $17,169 $0 $17,169 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 18,000 (831) 17,169 $17,169 Other 0 $0 Total $18,000 ($831) $17,169 $0 $17,169 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 40 Parks & Recreation Capital Projects Park Infrastructure Maintenance 2018 PK1804 PROJECT DESCRIPTION&JUSTIFICATION This project provides for maintenance of park infrastructure in response to use and age.The FY2017-18 priorities include concrete trail repair, retaining wall repairs, park restroom partitions and fixtures,athletic field fencing, erosion control, playground fall zone material, security lighting maintenance, restroom/concession building repairs and drinking fountain repairs and replacement. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2017 10/2017 09/2018 10/2018 Other REVISION EXPLANATION Savings from RTC's Infrastructure Maintenance 2015,2016,2017 are being reallocated to PK1804 to help cover the cost of emergency repairs to the bridge deck on the North Electric Trail(near RHS BB fields). FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017/18 BALANCE _ COST FUNDING SOURCES Federal/State Grants $0 $0 Reserves 0 $0 Sales Tax 292,400 9,505 301,905 $301,905 0 $0 0 $0 Total $292,400 $9,505 $301,905 $0 $301,905 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 292,400 9,505 301,905 $301,905 Other 0 $o Total $292,400 $9,505 $301,905 $0 $301,905 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 41 Other Capital Projects Northfield Park Renovation PK1603 PROJECT DESCRIPTION&JUSTIFICATION This project involves the redevelopment of the existing community park through the design and construction of new amenities based on meetings to gather stakeholder input. Recommended park elements for the redevelopment of the park include a new park entry, a more efficient park layout, upgrade of all equipment and support facilities and introduction of loop trails.The project will also ensure the protection of the natural creek corridor and provide engaging views to natural areas. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering 03/2016 08/2017 09/2018 Land/ROW Acquisition Construction 11/2017 09/2018 Other REVISION EXPLANATION Construction Materials Testing services were not included in the contractor's scope.The City is responsible for hiring these services.The use of sales tax reserves has been approved in order to retain the construction contingency for unforeseen conditions that may arise throughout the project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION 2017118 BALANCE COST FUNDING SOURCES Certificates of Obligation $3,900,000 $3,900,000 $3,900,000 Reserves/Other 378,021 33,138 411,159 $411,159 Sales Tax 405,500 405,500 $405,500 Impact Fees 900,000 900,000 $900,000 Grant 500,000 500,000 $500,000 Total $6,083,521 $33,138 $6,116,659 $0 $6,116,659 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 402,500 33,138 435,638 $435,638 Land/ROW Acquistion 0 $0 Construction 5,681,021 5,681,021 $5,681,021 Other 0 $0 Total $6,083,521 $33,138 $6,116,659 $0 $6,116,659 IMPACT ON OPERATING BUDGET There is no operating impact as a result of this project. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 42 Parks & Recreation Capital Projects Trail and On-Road Safety Projects PK1806 PROJECT DESCRIPTION&JUSTIFICATION This project will provide for implementation of recommendations identified in the City Wide Trail and Route System Study addressing safety enhancements at street crossings,warning signs and markings,wayfinding signs and trail and route connections. The recommendations being implemented are all designed to provide safe,friendly on-street bicycle transportation throughout the City. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services 10/2017 02/2018 Engineering Land/ROW Acquisition Construction 04/2018 03/2019 Other REVISION EXPLANATION The revision request is due to state direct costs being inadvertently included in project costs when it should not have been. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017118 BALANCE COST FUNDING SOURCES Federal/State Grants $617,294 ($41,077) $576,217 $576,217 Reserves 154,324 2 154,326 $154,326 0 $0 0 $0 0 $0 Total $771,618 ($41,075) $730,543 $0 $730,543 PROJECT EXPENDITURES Professional Services $113,500 $113,500 $113,500 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 587,971 18,800 606,771 $606,771 Other 70,147 (59,875) 10,272 $10,272 Total $771,618 ($41,075) $730,543 $0 $730,543 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 43 Utility Capital Projects Harmonson Road Sanitary Sewer Improvements CDBG 17 PROJECT DESCRIPTION&JUSTIFICATION This is the 42nd Year Community Development Block Grant(CDBG)Project. The Project will consist of replacing approximately 1,850 linear feet of 18"sanitary sewer pipe within Harmonson Road Right-of-Way between Dawn Drive and Lochridge Court. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2016 10/2016 09/2017 09/2017 Land/ROW Acquisition Construction 10/2016 02/2017 11/2017 12/2017 Other REVISION EXPLANATION Project construction was complete in late 2017. The final scope of the project did not include as much pavement restoration as originally estimated, and the total length of sanitary sewer pipe reduced slightly to eliminate any construction in the FEMA floodplain per CDBG guidelines. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 _ REVISION 2017/18 BALANCE COST FUNDING SOURCES Reserves $396,000 ($170,000) $226,000 $226,000 Federal/State Grants 375,000 375,000 $375,000 0 $0 0 $0 0 $0 Total $771,000 ($170,000) $601,000 $0 $601,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 79,200 79,200 $79,200 Land/ROW Acquistion 0 $0 Construction 691,800 (170,000) 521,800 $521,800 Other 0 $0 Total $771,000 ($170,000) $601,000 $0 $601,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected _ $0 44 Utility Capital Projects Sanitary Sewer System Rehabilitation of Main Lines (Phase II) UT 1307 PROJECT DESCRIPTION&JUSTIFICATION This project will consist of replacing approximately 11,000 linear feet of sanitary sewer main lines in the southern portion of the City(South of Northeast Loop 820). Because of the number of locations identified(40)that needed repairs the project was divided into 2 phases. Since each phase is made up of different sections of sanitary sewer lines and manholes that will need to be designed and constructed each phase will be treated as a separate project. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2011 10/2011 10/2013 10/2013 Land/ROW Acquisition Construction 07/2014 07/2014 05/2015 05/2015 Other REVISION EXPLANATION Project construction was complete in 2015 with final construction costs coming in lower than anticipated. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017/18 BALANCE COST FUNDING SOURCES Other $80,000 $80,000 $80,000 Reserves 1,045,000 (110,000) 935,000 $935,000 0 $0 0 $0 0 $0 Total $1,125,000 ($110,000) $1,015,000 $0 _ $1,015,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 300,000 300,000 $300,000 Land/ROW Acquistion 0 $0 Construction 825,000 (110,000) 715,000 $715,000 Other 0 $0 Total $1,125,000 ($110,000) $1,015,000 $0 $1,015,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 45 Utility Capital Projects Walker Branch Interceptor Project UT 1607 PROJECT DESCRIPTION&JUSTIFICATION As the 27 mile TEXRaiI Project gets closer to completion there has been more and more interest from private developers int the NRH Transit Oriented Development(TOD) Districts. Staff has reviewed several development plans proposed for these districts. One thing staff is discovering is that some of the sanitary sewer lines are undersized for the higher density developments being proposed. In this situation a portion of the sewer upgrade in the Smithfield area is on the city's long term CIP plan but will now need to be constructed sooner than we had originally planned.The Walker Branch Interceptor Project will consist of sanitary sewer improvements. Section one of the project will consist of increasing the size of the lines from 6-inch, 8-inch,and 10-inch,to 8-inch, 12-inch, and 15-inch respectively from Smithfield Road along Main Street to the Walker Creek and Mid-Ciites Boulevard confluence.The total length of sewer line for this section is approximately 5,500 feet. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services Engineering 07/2006 06/2018 Land/ROW Acquisition Construction 08/2018 10/2019 Other REVISION EXPLANATION The need for additional funding is largely due to the increase in material and labor prices. The project has not bid yet but based on other projects the consultant has seen recently,the original estimates were below what the current market prices are for this type of work.The$1.2 million increase would be covered with a 50/50 split from Impact Fees and Certificates of Obligation. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017/18 BALANCE COST FUNDING SOURCES Certificates of Obligation $2,200,000 $600,000 $2,800,000 $2,800,000 Reserves 216,525 216,525 $216,525 Other 2,400,000 600,000 3,000,000 $3,000,000 0 $0 0 $0 Total $4,816,525 $1,200,000 $6,016,525 $0 $6,016,525 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 416,525 416,525 $416,525 Land/ROW Acquistion 0 $0 Construction 4,400,000 1,200,000 5,600,000 $5,600,000 Other 0 $0 Total $4,816,525 $1,200,000 $6,016,525 $0 $6,016,525 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2017118 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 46 Select Project Category Replacement of the Fuel Management Software System IS1402 PROJECT DESCRIPTION&JUSTIFICATION Replace fuel management software program and related hardware components at Fire Stations 3 and 4, and the Service Center complex.The new system will be directly connected to the City's data network. With the current system,there has always been concern by Staff with data integrity due to reliability of the obsolete hardware and software. All historical data will be retained in the new system. PROJECT STATUS ORIGINAL 2017/18 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2013 04/2018 02/2019 REVISION EXPLANATION The vendor is phasing out the current software system and maintenance/support will no longer be available. The age and condition of the software system have resulted in on-going maintenance issues for the Information Services and Fleet Services Departments. Funding is available in the Fleet Services Fund due to expected savings in in fuel purchases and the fuel reserve. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION 2017118 BALANCE COST FUNDING SOURCES • Reserves $90,000 $37,025 $127,025 $127,025 0 $0 0 $0 0 $0 0 $0 Total $90,000 $37,025 $127,025 $0 $127,025 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 0 $0 Other 90,000 37,025 127,025 $127,025 Total $90,000 $37,025 $127,025 $0 $127,025 IMPACT ON OPERATING BUDGET Reduction in costs associated with maintenance of the current system. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 47 Major Capital Equipment Capital Projects Replacement of the Fuel Management Software System IS1402 PROJECT DESCRIPTION&JUSTIFICATION Replace fuel management software program and related hardware components at Fire Stations 3 and 4, and the Service Center complex. The vendor is phasing out the current software system and maintenance/support will no longer be available. The age and condition of the software system have resulted in on-going maintenance issues for the Information Services and Fleet Services Departments. The new system will be directly connected to the City's data network. With the current system,there has always been concern by Staff with data integrity due to reliability of the obsolete hardware and software. All historical data will be retained in the new system. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017/18 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 04/2018 02/2019 REVISION EXPLANATION Additional funding for assistance in installation of equipment related to the fuel system in City vehicles.Additional funding is from identified savings in the Fleet Services Fund. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017/18 REVISION 2017/18 BALANCE COST FUNDING SOURCES Reserves $127,025 $8,000 $135,025 $135,025 0 $0 0 $0 0 $0 0 $0 Total $127,025 $8,000 $135,025 $0 $135,025 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 127,025 8,000 135,025 $135,025 Other 0 $0 Total $127,025 $8,000 $135,025 $0 $135,025 IMPACT ON OPERATING BUDGET No additional impact is projected at this time. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 48 Select Project Category Public Safety Technology IT1702 PROJECT DESCRIPTION&JUSTIFICATION Upgrade and replace the current mobile video in-car systems, servers and data storage. Currently,43 patrol units will need video systems installed. This project also includes the purchase of body cameras and video data storage for police department, as well as the replacement of MDC's for the Police Department. This project will also include the replacement of 25 mobile data computers for the Fire Department. The units were purchased in 2008 and maintenance can no longer be obtained. This project includes replacing the units and installation of the docking stations. PROJECT STATUS ORIGINAL 2017118 ORIGINAL 2017118 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2016 09/2017 03/2018 Other REVISION EXPLANATION Due to the original purchase also including body cameras for City Marshall's staff requests to use funding from the Municipal Court Technology fund to offset these expenses. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2017118 REVISION 2017/18 BALANCE COST FUNDING SOURCES Reserves CCD $1,076,000 $1,076,000 $1,076,000 Federal/State Grants 75,817 75,817 $75,817 Reserves ISR 154,183 (40,157) 114,026 $114,026 MC Tech Fund 40,157 40,157 $40,157 0 $0 Total $1,306,000 $0 $1,306,000 $0 $1,306,000 PROJECT,EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 0 $0 Other 1,306,000 1,306,000 $1,306,000 Total $1,306,000 $0 $1,306,000 $0 $1,306,000 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2017/18 2018/19 2019/20 2020/21 2021/22 TOTAL Projected $0 49 City of North Richland Hills Fiscal Year 2018/2019 Proposed Budget ADOPTED REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET FY 2016/17 FY 2017/18 FY 2017/18 FY 2018/19 Legal Notice Expenditures 7,130 8,750 8,750 8,750 This information is required by Local Government Code 140.0045 as added in the 85th Legislature in 2017 under S.B. 622. 50