The URL can be used to link to this page

Home My WebLink AboutCC 2020-08-13 Agendas k4Ft, D HILLS CITY OF NORTH RICHLAND HILLS CITY COUNCIL AGENDA 4301 CITY POINT DRIVE NORTH RICHLAND HILLS, TX 76180 THURSDAY, AUGUST 13, 2020 In compliance with the Texas Open Meetings Act and in accordance with Section 418.016 of the Texas Government Code and such action issued by the Governor of Texas on March 16, 2020, the North Richland Hills City Council will conduct its regular meeting via video conference in order to advance the public health goal of limiting face-to-face meetings (also called "social distancing") to slow the spread of the Coronavirus (COVID-19). There will be no public access to the City Hall location described above, unless otherwise noted. Video conference link: https://bit.ly/3k wNTs Password: NRHCC0813 If you are not able to join the video conference there are two (2) options to address the City Council: (1) Complete a comment card and email it to publiccomments@nrhtx.com. Comment cards must be received no later than 7:00 p.m. (2) If you would like to speak to the City Council, but not wish to submit a comment card by email, you may call (817) 427-6312 between 6:00 p.m. and 7:00 p.m. to register to speak. RULES FOR SPEAKING AT CITY COUNCIL MEETING AND COMMENT CARD CAN BE FOUND ONLINE AT w .nrhtx.com//1106/speakinq-at-a®council®meeting Thursday, August 13, 2020 City Council Agenda Page 1 of 3 The live steaming video of the meeting is available at the City's website (nrhtx.legistar.com or nrhtx.com/video) and cable channels — Charter Cable Channel 190 and AT&T U-Verse Channel 99. SPECIAL MEETING: 7:00 P.M Held via Webex Video Conference A. CALL TO ORDER A.1 INVOCATION - COUNCIL MEMBER WRIGHT OUJESKY A.2 PLEDGE - COUNCIL MEMBER WRIGHT OUJESKY A.3 CITIZENS PRESENTATION An opportunity for citizens to address the City Council on matters which are not scheduled for consideration by the City Council or another City Board or Commission at a later date. In order to address the City Council during citizens presentation, register for the video conference at the link above and join the meeting at 7:00 p.m. or submit a public comment card by 7:00 p.m. the day of the meeting. A.4 PUBLIC COMMENTS An opportunity for citizens to address the City Council on matters which are scheduled on this agenda for consideration by the City Council, but not scheduled as a public hearing. In order to address the City Council during public comments, register for the video conference at the link above and join the meeting at 7:00 p.m. or submit a public comment card by 7:00 p.m. the day of the meeting. B. PUBLIC HEARINGS B.1 Conduct a public hearing on Fiscal Year 019/ 00 Revise uget and Fiscal Year 00/ 01 Proposed Budget. B.2 Conduct a Public Hearing on the Tax Year 2020 (Fiscal Year 00/2021) Proposed Tax ate. Thursday, August 13, 2020 City Council Agenda Page 2 of 3 EXECUTIVE SESSION The City Council may enter into closed Executive Session as authorized by Chapter 551, Texas Government Code. Executive Session may be held at the end of the Regular Session or at any time during the meeting that a need arises for the City Council to seek advice from the city attorney (551.071) as to the posted subject matter of this City Council meeting. The City Council may confer privately with its attorney to seek legal advice on any matter listed on the agenda or on any matter in which the duty of the attorney to the governmental body under the Texas Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with Chapter 551, Texas Government Code. C. EXECUTIVE SESSION ITEMS - CITY COUNCIL MAY TAKE ACTION ON ANY ITEM DISCUSSED IN EXECUTIVE SESSION LISTED ON WORK SESSION AGENDA D. ADJOURNMENT Certification I do hereby certify that the above notice of meeting of the North Richland Hills City Council was posted at City Hall, City of North Richland Hills, Texas in compliance with Chapter 551, Texas Government Code on Friday, August 7, 2020 by 3:00 PM. City Secretary This facility is wheelchair accessible and accessible parking spaces are available. Requests for accommodations or interpretive services must be made 48 hours prior to this meeting. Please contact the City Secretary's office at 817-427-6060 for further information. Thursday, August 13, 2020 City Council Agenda Page 3 of 3 IrLp NOKTH KICHLAN HILLS CITY COUNCIL MEMORANDUM FROM: The Office of the City Manager DATE: August 13, 2020 SUBJECT: Fiscal Year 2019/2020 Revised Budget and the Fiscal Year 2020/2021 Proposed Budget Public Hearing. PRESENTER: Robert Myers, Budget Director SUMMARY: The City Council is requested to open a public hearing and receive public comment on the FY 2019/2020 Revised Budget and the FY 2020/2021 Proposed Budget. No action is required at this hearing, as this hearing is held for the purpose of receiving public comment. GENERAL DESCRIPTION: The City Council held a budget work session on Friday, July 24, 2020 to review the FY 2019/2020 Revised Budget and the FY 2020/2021 Proposed Budget. At this work session, Council reviewed the budgets for all operating funds, capital project funds, and the budgets for the Crime Control and Prevention District and the Park and Recreation Facilities Development Corporation. Following the work session, the recommended modifications have been incorporated into the FY 2020/2021 Proposed Budget. The FY 2020/2021 Proposed Budget is based on a tax rate of 0.575700 per $100 valuation, an increase of 0.003700 from the FY 2019/2020 adopted tax rate. The FY 2019/2020 Revised Annual Operating Budget and FY 2020/2021 Proposed Operating Budget for all funds are as follows: 2019/2020 2020/2021 Fund Revised Proposed General Fund $51,931,228 $50,048,869 Debt Service Fund $11,993,596 $12,229,400 Tax Increment Financing Fund $2,175,789 $2,108,650 Park & Rec Facilities Development Fund $8,900,589 $9,757,211 Crime Control District Fund $5,828,583 $5,603,990 Promotional Fund $260,077 $276,808 Donations Fund $266,828 $262,388 Special Investigations Fund $262,300 $267,300 Drainage Utility Fund $1,657,000 $1,651,700 Gas Development Fund $3,041,989 $322,600 Traffic Safety Fund $134,294 $56,911 IrLp NOKTH KICHLAN HILLS Utility Fund $37,823,529 $38,466,058 Aquatic Park Fund $2,904,088 $4,292,723 Golf Course Fund $1,864,090 $2,727,072 Facilities/Construction Mgmt. Fund $2,988,118 $3,268,190 Fleet Services Fund (1) $5,001,728 $4,055,786 Information Services Fund $4,175,048 $4,008,357 Self Insurance Fund $15,788,154 $15,904,795 Cares Act Fund $3,738,900 $0 Each of these funds are Internal Service Funds. They receive revenue in the form of allocations from the other operating funds, which are used to cover the majority of expenses within each Internal Service Fund. While necessary to appropriate the funds in the manner above, it should be noted that the majority of expenses funded within each Internal Service Fund are also reflected as expenditures/expenses (the allocation) within the contributing funds. In addition, resources such as interest income, other income and fund balance are also used to offset any expenses in excess of these allocations. The Proposed Capital Improvements Budget totals $19,385,361 . The breakdown between project categories is as follows: Category 2020/2021 Proposed Street & Sidewalk Capital Projects $14,235,550 Drainage Capital Projects $450,000 Utility Capital Projects $2,639,906 Parks & Recreation Capital Projects $664,000 Aquatic Park Capital Projects $125,000 Facility Capital Projects $274,400 Major Capital Equipment Projects $643,400 Economic Development Projects $0 CIP Personnel $353,105 Other Capital Projects $0 In addition, over the course of Fiscal Year 2019/2020, several projects were revised. Staff will be requesting a formal amendment to the FY 2019/2020 Capital Projects Budget to include the changes summarized below. NOKTH KICHLAN HILLS STREET& SIDEWALK CAPITAL PROJECTS Adopted Budget 2019-20 Project Project Through Revision Revised Number Name 2019-20 2019-20 Budget STREET&SIDEWALK CAPITAL PROJECTS CDBG19 Schiller Drive Reconstruction $35,000 ($6,000) $29,000 ST2003 Northeast Parkway/Davis Blvd.Traffic Signal 380,000 (25,000) 355,000 ST2005 Northeast Parkway Extension 790,000 25,000 815,000 ST1304 Smithfield Road(Davis/Mid-Cities) 3,343,640 (68,170) 3,275,470 ST1701 Vance and Glenview Signal Upgrades 241,692 74,170 315,862 Sub-Total $4,790,332 $0 $4,790,332 DRAINAGE CAPITAL PROJECTS Adopted Budget 2019-20 Project Project Through Revision Revised Number Name 2019-20 2019-20 Budget DRAINAGE CAPITAL PROJECTS DR1902 Street Drainage Improvements Project(2019) $100,000 ($102) $99,898 DR1801 Snow Heights Drainage Improvements Project 320,000 (4,567) 315,433 Sub-Total $420,000 ($4,669) $415,331 UTILITY CAPITAL PROJECTS Adopted Budget 2019-20 Project Project Through Revision Revised Number Name 2019-20 2019-20 Budget UTILITY CAPITAL PROJECTS UT2009 Water Impact Fee Project $0 $21,000 $21,000 UT2010 Sewer Impact Fee Project 0 21,000 21,000 UT1905 Small Water Main Replacements(2019) 440,000 (4,989) 435,011 UT1903 Miscellaneous Water/Sewer Main Replacement(2019) 445,000 4,989 449,989 Sub-Total $885,000 $42,000 $927,000 PARKS & RECREATION CAPITAL PROJECTS Adopted Budget 2019-20 Project Project Through Revision Revised Number Name 2019-20 2019-20 Budget PARKS&RECREATION CAPITAL PROJECTS PK1802 Hometown Lakes Pedestrian Bridge Trail Connections $80,000 ($2,811) $77,189 PK1606 Park System Signange 479,486 (5,000) 474,486 PK1806 Trail and On-Road Safety Projects 730,543 5,000 735,543 PK1901 Annual Tree Planting 2019 45,000 (8,840) 36,160 PK1603 Northfield Park Redevelopment 6,125,312 (5,133) 6,120,179 PK2005 Richland Tennis Center Infrastructure Improvements(2020) 100,000 0 100,000 PK1902 Linda Spurlock Park Renovation 1,000,000 35,000 1,035,000 PK1904 Park Infrastructure Maintenance 2019 285,907 (9,954) 275,953 PK2004 Park Infrastructure Maintenance 2020 190,000 (25,046) 164,954 Sub-Total $9,036,248 ($16,784) $9,019,464 NOKTH KICHLAN HILLS MAJOR CAPITAL EQUIPMENT Adopted Budget 2019-20 Project Project Through Revision Revised Number Name 2019-20 2019-20 Budget MAJOR CAPITAL EQUIPMENT FS2004 Fuel System Enhancements $163,000 ($128,000) $35,000 IT1401 Cell Phone Signal Boosters in NRH Centre 98,000 (98,000) 0 FS1910 Utility Tractor Replacement 34,500 20,500 55,000 FS1902 Distributor Truck Replacement(Unit 681) 200,000 (211) 199,789 FS1904 Pothole Patcher 202,588 (652) 201,936 FS1909 Utility Tractor Replacement 55,000 (23,763) 31,237 FS1911 Vac-Con Truck 402,000 (5) 401,995 FS2002 Backhoe Replacement 140,000 (36,000) 104,000 FS2003 Backhoe Replacement 140,000 (38,600) 101,400 FS2006 Utility Tractor Replacement 65,000 (33,078) 31,922 FS2008 Wheel Loader 220,000 (56,000) 164,000 FS1901 Crack Sealing Machine 95,000 (26,592) 68,408 FS2007 Wheel Loader Replacement(Unit 685) 220,000 (5,000) 215,000 FS2005 Roller Replacement(Unit 6620) 65,000 5,000 70,000 FS2007 Wheel Loader Replacement(Unit 685) 215,000 (72,000) 143,000 FS1903 Dump Truck Replacement 120,412 0 120,412 IS1502 Replacement of CAD/RMS Public Safety Software Platform 3,020,000 (81,000) 2,939,000 Sub-Total $5,455,500 ($573,401) $4,882,099 AQUATIC CAPITAL PROJECTS Adopted Budget 2019-20 Project Project Through Revision Revised Number Name 2019-20 2019-20 Budget AQUATIC CAPITAL PROJECTS WP1901 General Facility Improvements 2019 $100,000 ($11,279) $88,721 Sub-Total $100,000 ($11,279) $88,721 FACILITY CAPITAL PROJECTS Adopted Budget 2019-20 Project Project Through Revision Revised Number Name 2019-20 2019-20 Budget FACILITY CAPITAL PROJECTS FC1701 Overhead Door Replacement $52,000 ($1,000) $51,000 FC1702 Overhead Door Safety Edges&Remote Control Assemblies 68,800 (900) 67,900 FC1902 Permanent Records Roof Replacement$Building Envelope Seal 78,000 (6,500) 71,500 FC1903 Replacement of HVAC Systems at Fire Stations#1 and#4 59,000 (141) 58,859 FC1904 Upgrade/Remodel of Public Works Restroom 75,000 6,500 81,500 Sub-Total $332,800 ($2,041) $330,759 ECONOMIC DEVELOPMENT CAPITAL PROJECTS Adopted Budget 2019-20 Project Project Through Revision Revised Number Name 2019-20 2019-20 Budget ECONOMIC DEVELOPMENT PROJECTS ED0601 TIF 1 Expansion-Intersection Improvements/Utility Burial $3,000,000 ($432,715) $2,567,285 ED1002 Loop 820 Redevelopment 2010 1,595,572 45,724 1,641,296 ED1503 TOD Land Management 1,200,000 89,033 1,289,033 Sub-Total $5,795,572 ($297,958) $5,497,614 IrLp NOKTH KICHLAN HILLS The notice of public hearing was published in the Star Telegram newspaper in accordance with State law and the City Charter. The public hearing for the Annual Budget was advertised to be held Thursday, August 13, 2020 during the 7.00 p.m. City Council meeting. The proposed budget document was filed with the City Secretary and was also placed at the North Richland Hills Public Library and made available online at the City's website, www.nrhtx.com. It will be presented for adoption at the City Council meeting on Monday, August 17, 2020. The Parks & Recreation Facilities Development Corporation Board meeting is scheduled for Thursday, August 13, 2020. During this meeting the Board will conduct a public hearing on the Park & Recreation Facilities Development Corporation budget, beginning at 6.30 p.m. At the July 24, 2020 budget work session, the Crime Control and Prevention District (CCD) Board reviewed the proposed FY 2020/2021 Crime Control and Prevention District Budget. The CCD Board is scheduled to conduct a public hearing on Thursday, August 13, 2020 at 6.40 p.m. RECOMMENDATION: Open a Public Hearing, receive comments on the FY 2019/2020 Revised and FY 2020/2021 Proposed budgets, and close the public hearing. City of North Richland Hills Fiscal Year 2020-21 Revised Proposed Budget As of August 4, 2020 This budget will raise more total property taxes than last year's budget by $1 , 172,444 or 3.48 percent, and of that amount $409,333 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 $144,603,534. Visit our website at: www.nrhtx.com 1 CITY OF NORTH RICHLAND HILLS FY 2020/21 Proposed Operating Budget I , / fI r r ............ „/ l a/ BUDGET DEPARTMENT E b�jdgft2 irj2jL.= rY Jl 4301 CITY POINT DR. W www.nr]htx.com h, ....... NORTH RICHLAND HILLS, TX P : 817-427-6053 � 76180 v° t , , ,n e 1° 2 CITY OF NORTH RICHLAND HILLS REVISED PROPOSED 2020/2021 OPERATING BUDGET TABLE OF CONTENTS FUND SUMMARIES Schedule1 — General Fund...............................................................................................................4 Schedule2 — General Fund...............................................................................................................5 Schedule3 — General Fund...............................................................................................................7 Schedule 4 — Summary of Property Tax Revenue and Distribution................................................. 10 Schedule 5 — General Debt Service................................................................................................. 11 Schedule 6 — Summary of Tax Increment Finance District.............................................................. 12 Schedule 7 — Tax Increment Financing Fund .................................................................................. 13 Schedule 8 — Park and Recreation Facilities Development Fund .................................................... 14 Schedule 9 — Crime Control District Fund........................................................................................ 16 Schedule 10 — Promotional Fund..................................................................................................... 17 Schedule 11 — Donations Fund........................................................................................................ 18 Schedule 12 — Special Investigations Fund ..................................................................................... 19 Schedule 13 — Drainage Utility Fund ...............................................................................................20 Schedule 14 — Gas Development Fund ...........................................................................................21 Schedule 15 — Traffic Safety Fund...................................................................................................22 Schedule 16 — Utility Fund...............................................................................................................23 Schedule 17 —Aquatic Park Fund ...................................................................................................25 Schedule 18 — Golf Course Fund.....................................................................................................26 Schedule 19 — Facilities / Construction Management Fund.............................................................27 Schedule 20 — Fleet Services Fund .................................................................................................28 Schedule 21 — Information Technology Fund ..................................................................................29 Schedule 22 — Self Insurance Fund.................................................................................................30 Schedule 23 — Cares Act Fund ........................................................................................................31 WORKING CAPITAL SUMMARY Working Capital Balance Summary .................................................................................................32 SCHEDULE OF CHANGES Schedule of Changes in Proposed Budget......................................................................................33 3 FISCAL YEAR 2020-2021 SCHEDULE 1 -SUMMARY OF REVENUES AND EXPENDITURES GENERALFUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES Taxes $32,290,436 $33,503,432 $35,342,093 $35,353,176 $36,016,560 Fines&Forfeitures 1,973,660 2,088,400 2,110,367 1,725,604 2,079,923 Licenses&Permits 2,538,181 2,935,022 2,440,521 2,586,291 2,389,377 Charges for Service 2,245,180 2,363,538 2,842,585 2,582,460 2,506,203 Intergovernmental 5,270,464 5,344,328 5,325,176 5,256,140 5,263,880 Miscellaneous 3,102,861 2,706,912 2,141,661 2,188,423 1,735,863 SUB-TOTAL $47,420,782 $48,941,632 $50,202,403 $49,692,094 $49,991,806 APPROPRIATION FROM FUND BALANCE Legal Settlement&Litigation $0 $0 $0 $0 $0 Court Technology Fund 49,950 0 59,800 64,376 57,063 Utility Assistance Program 0 0 0 0 0 PEG Fees 0 0 45,000 89,075 0 Record Preservation Fee 0 0 0 0 0 Previous Year Encumbrances 285,133 0 0 173,005 0 General Fund Reserves 0 0 0 1,912,678 0 SUB-TOTAL APPROPRIATIONS $335,083 $0 $104,800 $2,239,134 $57,063 TOTAL REVENUES $47,755,865 $48,941,632 $50,307,203 $51,931,228 $50,048,869 EXPENDITURES City Council $106,691 $118,122 $133,893 $96,789 $133,893 City Manager 667,721 686,245 734,957 728,372 765,874 Communications 360,103 373,989 394,874 388,599 401,039 City Secretary 425,931 450,507 475,819 466,292 488,120 Legal 363,156 385,459 429,510 428,034 440,345 Human Resources 144,405 130,580 141,545 140,204 148,194 Finance 701,536 739,815 771,524 758,454 752,234 Budget&Research 392,588 408,409 427,236 418,602 427,066 Municipal Court 1,331,385 1,243,624 1,394,917 1,323,166 1,404,954 Planning and Inspections 1,283,774 1,335,856 1,318,419 1,314,307 1,332,515 Economic Development 313,961 306,946 350,958 346,546 354,587 Library 2,134,157 2,174,011 2,282,980 2,234,535 2,261,062 Neighborhood Services 1,882,428 1,958,927 2,105,253 2,055,038 2,084,010 Public Works 3,126,989 3,210,817 3,411,978 3,323,604 3,254,551 Parks&Recreation 2,023,686 2,041,778 2,158,075 2,100,488 1,963,858 Police 14,544,932 14,999,848 15,879,537 15,833,912 16,192,094 Fire 12,943,835 13,195,347 14,317,885 14,047,272 14,324,044 Building Services 812,101 812,101 812,101 812,101 812,101 Non-Departmental 1,008,854 1,061,921 1,095,643 1,109,310 1,048,014 SUB-TOTAL DEPARTMENTS $44,568,231 $45,634,304 $48,637,104 $47,925,625 $48,588,555 RESERVES&OTHER EXPENDITURES Reserves $1,218,753 $135,969 $148,684 $130,420 $148,052 Transfers Out 560,280 1,229,492 1,387,423 3,741,191 1,199,144 Other 229,948 200,373 133,992 133,992 113,118 SUB-TOTAL RESERVES AND OTHER $2,008,981 $1,565,834 $1,670,099 $4,005,603 $1,460,314 TOTAL EXPENDITURES $46,577,212 $47,200,137 $50,307,203 $51,931,228 $50,048,869 BALANCE $1,178,653 $1,741,495 $0 $0 $0 4 FISCAL YEAR 2020-2021 SCHEDULE 2-SUMMARY OF REVENUES GENERALFUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 TAXES Current Property Taxes $16,178,973 $17,300,680 $19,099,518 $19,226,914 $20,035,463 Delinquent Property Taxes 147,739 78,823 207,396 80,000 80,000 Penalty and Interest 143,598 183,886 135,200 135,200 135,200 Franchise Fees 3,997,024 4,205,202 3,828,538 3,722,221 3,654,849 Utility Fund Franchise Taxes 1,003,680 937,584 1,116,527 1,097,397 1,125,062 Sales Taxes 10,281,105 10,227,474 10,398,713 10,568,043 10,432,023 Mixed Beverages 145,495 154,095 151,000 118,200 143,746 Payment in Lieu of Taxes 392,821 415,689 405,201 405,201 410,217 SUB-TOTAL $32,290,436 $33,503,432 $35,342,093 $35,353,176 $36,016,560 FINES AND FORFEITURES Municipal Court Fines $1,763,618 $1,894,644 $1,868,450 $1,579,183 $1,872,223 Warrant&Arrest Fees 156,735 153,789 181,917 132,348 167,700 Library Fines 53,307 39,967 60,000 14,073 40,000 SUB-TOTAL $1,973,660 $2,088,400 $2,110,367 $1,725,604 $2,079,923 LICENSES AND PERMITS Building Permits $1,142,662 $1,588,889 $1,270,000 $1,461,979 $1,270,000 Electrical Permits 80,706 78,779 63,600 77,670 63,600 Plumbing Permits 137,375 168,154 126,950 125,199 126,950 Mechanical Permits 147,131 143,701 117,900 130,825 117,900 Gas Drilling Permits 226 0 0 0 0 Burglar Alarm Permits 107,735 99,180 93,000 75,286 93,000 Miscellaneous Permits 82,104 83,694 77,124 73,197 77,124 Apartment Inspection Fees 101,747 103,707 102,400 102,400 102,400 Curb&Drainage Insp. Fees 110,665 138,559 123,659 96,140 96,138 Re-Inspection Fees 35,868 33,815 32,000 25,203 32,000 License Fees 35,084 28,273 19,000 22,000 19,000 Contractor Registration Fees 79,608 31,813 0 0 0 Plan/Review/Application Fee 73,680 92,252 82,335 64,012 64,012 Animal License/Adoption Fees 69,435 56,027 62,000 40,115 60,000 Animal Control Impoundment 12,614 16,614 17,300 10,513 16,600 Auto Impoundment Fees 14,315 17,669 15,200 12,787 12,600 Food Service Permits 171,733 167,695 161,053 161,053 161,053 Food Managers School 5,381 4,151 4,000 4,000 4,000 Fire Inspection/Alarm Fees 130,113 82,051 73,000 103,912 73,000 SUB-TOTAL $2,538,181 $2,935,022 $2,440,521 $2,586,291 $2,389,377 CHARGES FOR SERVICE Park Facility Rental $6,645 $17,010 $10,050 $8,000 $10,050 Ambulance Fees 1,620,898 1,564,456 1,725,625 1,725,250 1,725,715 Ambulance Supplemental Program 0 124,000 400,000 124,000 124,000 Garbage Billing 466,786 479,044 482,460 503,719 513,793 Contributions 10,000 10,000 10,000 10,000 10,000 Recreation Fees 875 1,074 875 16,374 22,945 Athletic Revenue 21,737 72,869 112,600 89,217 0 Recreation Special Events 3,810 2,068 4,000 2,693 2,700 Planning&Zoning Fees 50,109 50,695 38,000 32,421 38,000 Sale of Accident Reports 9,151 10,057 8,900 6,448 8,900 Vital Statistics 0 0 0 0 0 Mowing 48,699 24,552 44,000 59,158 44,000 Fire Dept Certification/CPR Citizen Class 6,117 7,096 6,000 5,105 6,000 Miscellaneous 352 617 75 75 100 SUB-TOTAL $2,245,180 $2,363,538 $2,842,585 $2,582,460 $2,506,203 5 FISCAL YEAR 2020-2021 SCHEDULE 2-SUMMARY OF REVENUES GENERALFUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 INTERGOVERNMENTAL Indirect Costs: Utility Fund 2,304,572 2,304,572 2,182,170 2,182,170 2,182,170 Park&Rec Facilities Dev.Corp. 500,885 499,326 497,541 497,541 497,487 Crime Control District 31,678 30,119 28,334 28,334 28,280 Aquatic Park Fund 0 0 0 0 0 Consolidation Reimbursements 2,433,328 2,510,311 2,617,131 2,548,095 2,555,943 SUB-TOTAL $5,270,464 $5,344,328 $5,325,176 $5,256,140 $5,263,880 MISCELLANEOUS Interest Income $208,466 $286,857 $243,988 $244,861 $129,625 Radio Reimbursement 265,117 255,605 273,607 253,228 259,483 Sale of City Property 376,319 67,762 3,000 0 0 Grant Proceeds 52,760 75,107 54,000 54,000 95,666 Overtime Reimbursements 7,693 8,635 281 281 281 Teen Court Reimbursement 0 40,228 20,114 20,114 20,114 Other Income 592,505 872,717 812,615 881,883 730,694 Golf Course Loan Repayment 0 0 0 0 0 Designated Funds for City Hall Project Debt 1,600,000 1,100,000 734,056 734,056 500,000 SUB-TOTAL $3,102,861 $2,706,912 $2,141,661 $2,188,423 $1,735,863 APPROPRIATION-FUND BALANCE Legal Settlement&Litigation $0 $0 $0 $0 $0 Court Technology Funds 49,950 0 59,800 64,376 57,063 Utility Assistance Program 0 0 0 0 0 PEG Fees 0 0 45,000 89,075 0 Record Preservations Fee 0 0 0 0 0 Previous Year Encumbrances 285,133 0 0 173,005 0 General Fund Reserves 0 0 0 1,912,678 0 SUB-TOTAL $335,083 $0 $104,800 $2,239,134 $57,063 TOTAL REVENUES $47,755,865 $48,941,632 $50,307,203 $51,931,228 $50,048,869 6 FISCAL YEAR 2020-2021 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERALFUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 EXPENDITURES City Council"' $106,691 $118,122 $133,893 $96,789 $133,893 City Manager $667,721 $686,245 $734,957 $728,372 $765,874 Communications Public Information $249,457 $253,734 $269,961 $265,859 $273,873 Citicable 110,647 120,255 124,913 122,740 127,166 Total Communications $360,103 $373,989 $394,874 $388,599 $401,039 City Secretary City Secretary"' $339,247 $349,057 $363,037 $354,668 $367,298 Record Management 86,684 101,450 112,782 111,624 120,822 Total City Secretary $425,931 $450,507 $475,819 $466,292 $488,120 Legal $363,156 $385,459 $429,510 $428,034 $440,345 Human Resources $144,405 $130,580 $141,545 $140,204 $148,194 Finance Accounting&Administration $450,858 $475,148 $493,471 $485,981 $473,102 Purchasing"' 250,678 264,667 278,053 272,473 279,132 Total Finance $701,536 $739,815 $771,524 $758,454 $752,234 Budget&Research Budget"' $176,790 $185,674 $195,086 $190,218 $194,916 Tax 215,798 222,735 232,150 228,384 232,150 Internal Audit 0 0 0 0 0 Total Budget&Research $392,588 $408,409 $427,236 $418,602 $427,066 Municipal Court Administration/Prosecution $394,051 $369,148 $370,677 $370,524 $369,855 Court Records 439,969 420,811 502,929 450,863 495,384 Warrants 399,782 346,342 405,224 386,973 424,913 Teen Court 97,583 107,323 116,087 114,806 114,802 Total Municipal Court $1,331,385 $1,243,624 $1,394,917 $1,323,166 $1,404,954 Planning and Development Planning&Administration 347,042 352,861 312,311 307,917 315,334 Inspections 936,731 982,996 1,006,108 1,006,390 1,017,181 Total Planning and Development $1,283,774 $1,335,856 $1,318,419 $1,314,307 $1,332,515 Economic Development $313,961 $306,946 $350,958 $346,546 $354,587 Library General Services $386,836 $386,803 $420,030 $404,727 $413,860 Public Services 910,014 942,289 961,320 940,366 951,356 Technical Services 837,307 844,920 901,630 889,442 895,846 Total Library $2,134,157 $2,174,011 $2,282,980 $2,234,535 $2,261,062 7 FISCAL YEAR 2020-2021 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERALFUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 Neighborhood Services Neighborhood Resources $328,015 $374,045 $363,738 $360,286 $368,811 Animal Services 773,642 768,509 818,581 809,615 824,113 Consumer Health 328,222 341,319 361,449 358,294 364,407 Code Compliance 452,548 475,053 561,485 526,843 526,679 Total Neighborhood Services $1,882,428 $1,958,927 $2,105,253 $2,055,038 $2,084,010 Public Works General Services $334,521 $353,823 $380,905 $353,293 $337,592 Traffic Control 1,110,455 1,103,398 1,115,755 1,096,119 1,132,319 Street&Drainage 1,682,013 1,753,596 1,915,318 1,874,192 1,784,640 Total Public Works $3,126,989 $3,210,817 $3,411,978 $3,323,604 $3,254,551 Parks&Recreation General Services $171,285 $173,271 $182,141 $180,966 $182,748 Parks Maintenance 928,964 915,775 949,265 931,577 965,301 Recreation Services 487,102 487,102 487,102 487,102 487,102 Athletic Program Services 117,002 147,927 201,047 175,271 0 Senior Adult Services 279,796 272,218 292,384 280,336 289,498 Youth Outreach&Cultural 39,537 45,485 46,136 45,236 39,209 Total Parks&Recreation $2,023,686 $2,041,778 $2,158,075 $2,100,488 $1,963,858 Police General Services $1,240,294 $1,297,028 $1,329,485 $1,431,158 $1,350,227 Administrative Services 545,450 696,709 596,676 705,993 702,957 Criminal Investigations 2,580,558 2,774,432 2,885,473 2,854,931 3,026,766 Uniform Patrol 5,901,507 5,973,925 6,306,802 6,260,057 6,245,744 Detention Services 1,584,123 1,632,595 1,781,505 1,686,100 1,787,953 Property Evidence 516,137 396,550 511,216 534,703 613,664 Communications 2,176,863 2,228,609 2,468,380 2,360,970 2,464,783 Total Police $14,544,932 $14,999,848 $15,879,537 $15,833,912 $16,192,094 Fire Department General Services $443,436 $432,778 $450,379 $443,170 $449,566 Operations 9,288,668 9,645,289 10,583,039 10,525,890 10,605,309 Emergency Medical 1,605,761 1,762,267 1,781,242 1,751,505 1,790,707 Fire Inspections 652,836 605,058 702,910 556,134 686,751 Emergency Management 953,134 749,955 800,315 770,573 791,711 Total Fire $12,943,835 $13,195,347 $14,317,885 $14,047,272 $14,324,044 Building Services $812,101 $812,101 $812,101 $812,101 $812,101 Non Departmental"' $1,008,854 $1,061,921 $1,095,643 $1,109,310 $1,048,014 SUB-TOTAL DEPARTMENTS $44,568,231 $45,634,304 $48,637,104 $47,925,625 $48,588,555 FISCAL YEAR 2020-2021 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERALFUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 RESERVES&OTHER EXPENDITURES Other Economic Development Incentives $211,948 $200,373 $133,992 $133,992 $113,118 Legal Settlement 18,000 0 0 0 0 Other Total $229,948 $200,373 $133,992 $133,992 $113,118 Transfers Capital Projects $61,297 $1,094,000 $1,000,000 $1,000,000 $1,000,000 Capital Projects-Sidewalk Maintenance 386,258 50,000 50,000 50,000 50,000 Fleet Services 0 0 0 28,875 0 NRH20 0 0 0 2,309,693 0 Information Services 82,725 85,492 193,954 209,154 149,144 Transfer to Crime Control District Fund 0 0 143,469 143,469 0 Neighborhood Revitalization Program 30,000 0 0 0 0 Transfers Total $560,280 $1,229,492 $1,387,423 $3,741,191 $1,199,144 Contribution to Reserves General Fund Reserves $1,218,753 $0 $18,264 $0 $11,409 Public, Educational,Governmental(PEG)Fees 0 135,969 130,420 130,420 136,643 Tranportation Projects(Future) 0 0 0 0 0 Contribution to Reserves Total $1,218,753 $135,969 $148,684 $130,420 $148,052 TOTAL RESERVES&OTHER EXPENDITURES $2,008,981 $1,565,834 $1,670,099 $4,005,603 $1,460,314 TOTAL EXPENDITURES $46,577,212 $47,200,137 $50,307,203 $51,931,228 $50,048,869 BALANCE $1,178,653 $1,741,495 $0 $0 $0 As required by Local Government Code 140.0045 as added in the 85th Legislature(S.B. 622)and amended in the 86th Legislature(H.B. 1495). (1) Legal Notice Expenditures for FY 19-20 were$10,600 and for the FY 20-21 Proposed Budget are$9,900. (2) Legislative advocacy expenditures for FY 19-20 were$55,310 and for the FY 20-21 Proposed Budget are$55,310. 9 FISCAL YEAR 2020-2021 SCHEDULE 4-SUMMARY OF PROPERTY TAX REVENUE AND DISTRIBUTION NET TAXABLE VALUE: M&O I&S TOTAL Total Appraised Value as of July 24,2020 7,872,103,109 Less: Absolute Exemption (444,010,423) Cases Before ARB (461,161,737) Incomplete Accounts (162,452,855) Disabled Veteran (38,878,521) Over 65 (196,147,569) Homestead (560,899,866) Disabled Persons (9,695,397) Freeport Inventory Value Loss (5,929,082) Pollution Control (27,671) Solar&Wind Powered Devices (8) Nominal Value Accounts (856,838) Miscellaneous Personal Property (35,619,678) In Process 0 Total Reduction to Values (1,915,679,645) NET TAXABLE VALUE AT JULY 24,2020 5,956,423,464 Add: Estimated Minimum ARB protested values 293,819,672 Incomplete Property 98,950,748 In Process 0 ESTIMATED NET TAXABLE VALUE AT JULY 24,2020 6,349,193,884 ESTIMATED PROPERTY TAX COLLECTIONS: Estimated Net Taxable Value 6,349,193,884 Less:TIF#2 Incremental Value (533,686,980) Less:TIF#3 Incremental Value (6,148,448) Less:Tax Ceiling Taxable Values (982,522,531) Net Taxable Values 4,826,835,925 Proposed Tax Rate per$100 Valuation 0.343611 0.232089 0.575700 Estimated Total Tax Levy at 100%Collection 16,585,539 11,202,557 27,788,096 Less:Estimated Uncollectable(1.5%) (248,783) (248,783) Less:Estimated I&S Uncollectable(1.5%) (168,038) (168,038) Estimated Revenue from Property Tax 16,168,718 11,202,557 27,371,275 Estimated Revenue from Property Tax 16,168,718 11,202,557 27,371,275 Plus:Tax Ceiling Account Revenue 3,914,955 - 3,914,955 Less:Estimated Uncollectable(1.5%) (58,724) (58,724) Plus:TIF Tax Rate Differential(0.002000) 10,674 10,674 Less:Estimated I&S Uncollectable(1.5%) (160) (160) ESTIMATED PROPERTY TAX DISTRIBUTION 20,035,463 11,202,557 31,238,020 10 FISCAL YEAR 2020-2021 SCHEDULE 5-SUMMARY OF REVENUES AND EXPENDITURES GENERAL DEBT SERVICE FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES General Debt Service Taxes $10,683,052 $11,315,208 $11,200,798 $11,200,798 $11,202,557 SUB-TOTAL AD VALOREM TAXES $10,683,052 $11,315,208 $11,200,798 $11,200,798 $11,202,557 Transfer in From: Drainage Utility $362,674 $268,276 $278,599 $248,181 $220,675 Park&Rec. Facilities Dev.Corp 627,685 524,555 509,030 509,030 463,005 Fleet Services Fund 0 0 130,911 0 257,223 Facilities Services Fund 0 0 0 0 0 Donations Fund 0 0 0 0 0 SUB-TOTAL TRANSFER IN $990,359 $792,831 $918,540 $757,211 $940,903 Proceeds Bond Issuance Proceeds $0 $0 $0 $0 $0 Interest Income 15,195 22,368 9,119 6,716 3,087 City of Watauga,CIP Participation 82,853 82,853 82,853 82,853 82,853 Miscellaneous Revenues 0 (0) 0 0 0 Transfer In 0 0 0 0 0 Appropriation of Fund Balance 0 0 0 0 0 SUB-TOTAL OTHER $98,048 $105,221 $91,972 $89,569 $85,940 TOTAL REVENUES $11,771,459 $12,213,260 $12,211,310 $12,047,578 $12,229,400 EXPENDITURES Existing Bonds&C.O.'s $11,724,762 $11,860,435 $12,202,610 $11,984,896 $12,220,017 Issuance Costs/Paying Agent Fees 8,115 7,755 8,700 8,700 9,383 Bond Defeasance/Refunding 0 0 0 0 0 TOTAL EXPENDITURES $11,732,877 $11,868,190 $12,211,310 $11,993,596 $12,229,400 BALANCE $38,582 $345,070 $0 $53,982 $0 11 FISCAL YEAR 2020-2021 SCHEDULE 6-SUMMARY OF TAX INCREMENT FINANCE(TIF)DISTICT PROPERTY TAX REVENUE AND DISTRIBUTION NET TAXABLE VALUE: TAX INCREMENT FINANCING DISTRICT#2 Taxable Value(2020 Tax Year) $597,120,099 Less: Base Taxable Value(1998 Tax Year) 40,020,188 Taxable Value Increment(2020 Tax Year) Gain/(Loss): $557,099,911 ESTIMATED TAX INCREMENT FINANCING DISTRICT PROPERTY TAX REVENUE TAX INCREMENT FINANCING DISTRICT#2 Taxable Value Increment:TIF District#2 $557,099,911 Tax Rate per$100 Valuation and Inception $0.57 TIF District#2 Property Tax Revenue at 100% $3,175,469 Collection Rate 98.50% TIF District#2 Property Tax Revenue $3,127,837 TOTAL ESTIMATED TAX INCREMENT FINANCING DISTRICT PROPERTY TAX REVENUE(1)(2) $3,127,837 Notes: 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.TIF#1A Closed in 2019. 12 FISCAL YEAR 2020-2021 SCHEDULE 7-SUMMARY OF REVENUES AND EXPENDITURES TAX INCREMENT FINANCING FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 TAX INCREMENT FINANCING DISTRICT#1 REVENUES Tax Increment Financing District#1 Taxes City of North Richland Hills $110,702 $0 $0 $0 $0 Tarrant County Hospital District 37,547 6,066 0 0 0 Tarrant County College District 27,208 0 0 0 0 Tarrant County 36,325 45,949 0 0 0 Birdville ISD 121,009 0 0 0 0 Sub-Total 332,791 $52,015 $0 $0 $0 Other Funding Sources Investment Income $649 $46,060 $20,403 $11,704 $14,050 Bond Defeasance/Refunding Proceeds 0 0 0 0 0 Appropriation of Fund Balance 433,935 0 0 0 0 Sub-Total 434,584 $46,060 $20,403 $11,704 $14,050 TOTAL REVENUES 767,374 $98,075 $20,403 $11,704 $14,050 EXPENDITURES&TRANSFERS TIF#1 Debt Service $659,532 $111,857 $210 $210 $209 Bond Defeasance/Refunding 0 0 0 0 0 TOTAL EXPENDITURES 659,532 $111,857 $210 $210 $209 BALANCE 107,843 ($13,782) $20,193 $11,494 $13,841 TAX INCREMENT FINANCING DISTRICT#2 REVENUES Tax Increment Financing District#2 Taxes City of North Richland Hills $2,321,974 $2,627,216 $2,910,684 $2,901,452 $3,127,837 Tarrant County Hospital District 976,874 1,105,791 1,244,834 172,651 0 Tarrant County College District 609,688 671,841 776,906 710,023 833,226 Tarrant County 1,022,008 1,085,576 1,353,388 380,797 0 Sub-Total 4,930,544 $5,490,424 $6,285,812 $4,164,923 $3,961,063 Other Funding Sources Investment Income ($22,497) $218,462 $0 $0 $0 Bond Defeasance/Refunding Proceeds 0 $0 $0 $0 $0 Sub-Total (22,497) $218,462 $0 $0 $0 TOTAL REVENUES 4,908,047 $5,708,887 $6,285,812 $4,164,923 $3,961,063 EXPENDITURES&TRANSFERS TIF#2 Debt Service 2,290,223 $2,234,978 $2,174,304 $2,174,304 $2,106,960 Bond Defeasance/Refunding 1,724 1,229 1,275 1,275 1,481 Sub-Total 2,291,946 2,236,206 2,175,579 2,175,579 2,108,441 TOTAL EXPENDITURES 2,291,946 2,236,206 2,175,579 2,175,579 2,108,441 BALANCE 2,616,101 $3,472,681 $4,110,233 $1,989,344 $1,852,622 13 FISCAL YEAR 2020-2021 SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES Sales Tax $5,140,554 $5,113,739 $5,199,346 $5,284,095 $5,216,013 Interest Income 50,082 83,943 69,653 73,631 27,196 Youth Assn. Maintenance Fees 42,817 39,257 39,000 39,000 35,500 Tennis Center Revenue 356,139 405,064 420,600 293,593 404,600 Park Impact Fees 87,880 448,940 95,000 200,000 95,000 Grants/Foundation 150,000 0 0 0 0 Athletic Program Service Revenue 0 0 0 0 112,800 Other Income 22,078 77,188 1,500 500 1,000 SUB-TOTAL $5,849,556 $6,168,131 $5,825,099 $5,890,819 $5,892,109 NRH CENTRE Memberships/Drop-In Passes $1,406,929 $1,409,720 $1,420,000 $889,536 $1,420,000 Fitness 486,893 502,841 453,000 326,719 500,000 Recreation/Sports 303,196 333,719 324,000 161,327 353,000 Grand Hall Rental 417,244 515,941 402,150 316,000 423,900 Catering&Event Fees 25,612 31,942 28,275 24,000 26,100 Aquatic Programs 250,290 227,944 255,000 148,217 255,000 Pool Rental 2,875 10,961 3,000 2,055 3,000 Gym Rental 3,978 19,143 12,000 9,900 12,000 Concessions/Merchandise 28,252 45,006 27,000 17,360 27,000 Special Events 8,132 8,743 9,000 8,680 0 Other 9,711 10,504 10,000 (4,025) 10,000 General Fund 487,102 487,102 487,102 487,102 487,102 SUB-TOTAL $3,430,214 $3,603,566 $3,430,527 $2,386,871 $3,517,102 APPROPRIATION OF FUND BALANCE Prior Year Encumbrances $0 $0 $0 $0 $0 Appropriation of Park Impact Fee Reserves 0 0 0 120,000 265,000 Appropriation of Tree Mitigation Reserves 0 0 0 0 83,000 Appropriation of NRH Centre Reserves 0 0 0 460,878 0 Appropriation of Sales Tax Reserves 0 0 224,057 42,021 0 SUB-TOTAL $0 $0 $224,057 $622,899 $348,000 TOTAL REVENUES $9,279,770 $9,771,696 $9,479,683 $8,900,589 $9,757,211 14 FISCAL YEAR 2020-2021 SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 EXPENDITURES OPERATING Park Facilities Development Admin. $823,120 $900,472 $956,834 $945,945 $802,369 Parks&Public Grounds 2,049,782 2,156,320 2,129,790 2,015,150 2,125,992 Athletic Program Services 0 0 0 0 192,914 Tennis Center Operations 544,843 540,068 627,934 528,488 580,643 SUB-TOTAL $3,417,745 $3,596,859 $3,714,558 $3,489,583 $3,701,918 NRH CENTRE Center Management $701,603 $753,512 $825,518 $762,924 $792,372 Fitness 427,782 416,150 513,399 414,756 403,333 Building Operations 223,378 253,884 223,910 258,160 226,658 Aquatic 650,536 670,266 659,956 566,097 666,934 Recreation Sports 324,784 278,770 313,492 247,730 321,491 Event Center 304,695 409,219 377,310 320,294 404,343 Building Services 284,090 274,090 277,788 277,788 276,414 SUB-TOTAL $2,916,869 $3,055,891 $3,191,373 $2,847,749 $3,091,545 OTHER&RESERVES Debt Services-CO's $627,685 $524,555 $509,030 $509,030 $463,005 Indirect Costs 500,885 499,326 497,541 497,541 497,487 Non-Departmental 42,675 44,706 57,043 53,590 58,409 Transfers to Capital Projects Capital Projects 666,284 569,000 1,046,000 1,051,000 424,000 Capital Projects-Grant/Donation/Foundation 0 0 0 0 0 Capital Projects-Impact Fees 205,000 89,000 0 120,000 265,000 Contributions to Reserves Operating Reserve 150,548 0 0 0 744,890 Impact Fee Reserve 0 448,940 95,000 200,000 95,000 Economic Development Reserve 128,514 127,843 129,984 132,096 130,400 NRH Centre Reserve 221,635 0 239,154 0 285,557 SUB-TOTAL $2,543,226 $2,303,371 $2,573,752 $2,563,257 $2,963,748 TOTAL EXPENDITURES $8,877,840 $8,956,121 $9,479,683 $8,900,589 $9,757,211 BALANCE $401,930 $815,575 $0 $0 $0 15 FISCAL YEAR 2020-2021 SCHEDULE 9-SUMMARY OF REVENUES AND EXPENDITURES CRIME CONTROL DISTRICT ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES Sales Tax $5,098,136 $5,097,235 $5,160,426 $5,244,541 $5,199,180 Franchise Tax 96,127 110,793 96,127 92,579 96,127 Interest Income 9,653 15,005 15,400 11,000 4,300 SRO Reimbursement(BISD) 219,296 226,194 240,826 240,826 235,775 Other 26,194 59,352 70,877 70,877 68,608 Contribution from the General Fund 0 0 143,469 143,469 0 Prior Year Encumbrances 0 0 0 25,291 0 Appropriation of Fund Balance 0 60,729 0 0 0 TOTAL REVENUES $5,449,405 $5,569,309 $5,727,125 $5,828,583 $5,603,990 EXPENDITURES Administration $7,234 $9,329 $16,000 $11,963 $16,000 Community Resources 1,006,212 1,123,868 1,195,721 1,186,008 1,122,294 Investigations 485,927 428,589 527,912 518,833 497,273 Uniform Patrol 2,979,103 2,995,821 3,005,620 2,992,475 3,110,774 Technical Services 554,693 566,081 573,686 562,672 549,758 Property Evidence 32,815 280,657 222,668 233,658 111,508 SUB-TOTAL $5,065,984 $5,404,345 $5,541,607 $5,505,609 $5,407,607 OTHER&RESERVES Partner Agency Funding $69,525 $36,513 $44,426 $43,426 $44,426 Other 92,510 98,332 112,758 115,402 123,677 Indirect Costs 31,678 30,119 28,334 28,334 28,280 Transfer to Capital Projects 0 0 0 0 0 Reserves 16,127 0 0 135,812 0 SUB-TOTAL $209,841 $164,964 $185,518 $322,974 $196,383 TOTAL EXPENDITURES $5,275,825 $5,569,309 $5,727,125 $5,828,583 $5,603,990 BALANCE $173,580 ($0) $0 $0 $0 16 FISCAL YEAR 2020-2021 SCHEDULE 10-SUMMARY OF REVENUES AND EXPENDITURES PROMOTIONAL FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES Occupancy Tax Proceeds $301,835 $279,026 $280,000 $192,924 $176,582 Interest Income 6,252 9,846 10,000 8,330 4,400 Appropriation of Fund Balance 0 0 0 58,823 95,826 Prior Year Encumbrances 2,439 0 0 0 0 SUB-TOTAL $310,526 $288,872 $290,000 $260,077 $276,808 TOTAL REVENUES $310,526 $288,872 $290,000 $260,077 $276,808 EXPENDITURES Economic Development $120,587 $114,307 $127,891 $123,180 $128,717 Cultural&Leisure 119,556 120,242 145,222 136,409 147,646 Non-Departmental 178 210 533 488 445 Contribution to Reserves 0 0 16,354 0 0 SUB-TOTAL $240,320 $234,759 $290,000 $260,077 $276,808 TOTAL EXPENDITURES $240,320 $234,759 $290,000 $260,077 $276,808 BALANCE $70,206 $54,113 $0 $0 $0 17 FISCAL YEAR 2020-2021 SCHEDULE 11 -SUMMARY OF REVENUES AND EXPENDITURES DONATIONS FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES Contributions NRH Water Bills $61,414 $63,757 $60,200 $58,800 $60,200 SUB-TOTAL $61,414 $63,757 $60,200 $58,800 $60,200 Donations Spay/Neuter $10,766 $8,007 $8,500 $12,000 $8,500 Shelter Fund 12,056 20,020 10,800 22,934 10,800 Duncan 15,000 15,010 15,000 15,000 15,000 Santa Cops 9,747 4,105 2,500 2,500 2,500 SUB-TOTAL $47,569 $47,141 $36,800 $52,434 $36,800 Proceeds Library Book Sale $8,885 $7,972 $9,000 $6,500 $9,000 SUB-TOTAL $8,885 $7,972 $9,000 $6,500 $9,000 Other Interest Income $6,979 $9,441 $9,076 $5,949 $9,076 Other Income 158,407 121,701 124,150 113,785 118,950 Appropriation of Fund Balance Teen Court 400 400 400 2,000 400 Library 22,320 18,815 18,815 18,760 18,815 Neighborhood Services 73,830 6,823 9,923 10,523 9,923 Parks&Recreations 59,027 34,942 29,700 25,323 29,700 Police 400 32,993 3,100 2,200 3,600 Fire 0 1,159 0 0 0 Encumbrance Roll 3,500 24,682 0 0 0 SUB-TOTAL $324,863 $250,956 $195,164 $178,540 $190,464 TOTAL REVENUES $442,730 $369,826 $301,164 $296,274 $296,464 EXPENDITURES Library-Book Collection $72,985 $72,565 $68,865 $68,865 $68,865 Neighborhood Services Animal Services 21,925 10,454 19,810 19,810 19,810 Keep NRH Beautiful 15,082 14,624 17,013 17,013 17,013 Municipal Court-Teen Court 5,000 3,250 5,000 4,000 4,000 Parks-Special Events and Arts 98,858 121,773 114,500 113,000 113,000 Police Department 46,339 34,190 9,200 13,700 9,700 Fire Department 987 1,959 0 440 0 Contribution to Reserves 0 0 0 0 0 Transfers Out 30,000 34,252 30,000 30,000 30,000 TOTAL EXPENDITURES $291,176 $293,066 $264,388 $266,828 $262,388 BALANCE $151,555 $76,760 $36,776 $29,446 $34,076 18 FISCAL YEAR 2020-2021 SCHEDULE 12-SUMMARY OF REVENUES AND EXPENDITURES SPECIAL INVESTIGATIONS FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES Forfeited Funds $86,783 $114,246 $141,000 $71,000 $71,000 AFIS Reimbursements 26,250 13,500 13,500 13,500 13,500 911 Telecom 0 0 0 0 0 Interest Income 2,744 5,492 0 0 0 Other Income 25,492 7,888 0 0 0 Prior Year Encumbrances 3,300 0 0 0 0 Appropriation of Fund Balance 0 0 107,800 177,800 182,800 TOTAL REVENUES $144,569 $141,126 $262,300 $262,300 $267,300 EXPENDITURES Federal Forfeited Funds $36,869 $26,480 $145,000 $145,000 $150,000 MDT Maintenance 0 0 0 0 0 Radio Maintenance 0 0 0 0 0 State Forfeiture Funds 28,564 27,501 105,000 105,000 105,000 Local Forfeited Funds 0 0 1,000 1,000 1,000 AFIS Maintenance&Equipment 51,750 3,549 4,300 4,300 4,300 911 Telecom 0 0 0 0 0 Leose Contributions 0 0 7,000 7,000 7,000 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 $117,183 $57,530 $262,300 $262,300 $267,300 BALANCE $27,386 $83,596 $0 $0 $0 19 FISCAL YEAR 2020-2021 SCHEDULE 13-SUMMARY OF REVENUES AND EXPENDITURES DRAINAGE UTILITY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES Drainage Fees $896,000 $965,836 $1,647,000 $1,647,000 $1,647,000 Interest Income 3,772 10,295 10,000 10,000 4,700 Appropriation of Fund Balance 438,103 0 0 0 0 SUB-TOTAL $1,337,876 $976,131 $1,657,000 $1,657,000 $1,651,700 TOTAL REVENUES $1,337,876 $976,131 $1,657,000 $1,657,000 $1,651,700 EXPENDITURES Debt Service $362,674 $268,276 $278,599 $248,181 $220,675 Transfer to Capital Projects 797,850 230,000 575,000 575,000 450,000 Other Expenditures 29,748 25,715 30,000 30,000 30,000 Drainage Utility Crew 0 0 0 0 119,583 Contribution to Reserves 0 0 773,401 803,819 831,442 TOTAL EXPENDITURES $1,190,272 $523,991 $1,657,000 $1,657,000 $1,651,700 BALANCE $147,604 $452,140 $0 $0 $0 20 FISCAL YEAR 2020-2021 SCHEDULE 14-SUMMARY OF REVENUES AND EXPENDITURES GAS DEVELOPMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES BONUSES General Fund Purposes $0 $0 $0 $0 $0 SUB-TOTAL $0 $0 $0 $0 $0 ROYALITIES/OVERRIDES General Fund Purposes $555,185 $519,830 $500,000 $320,000 $320,000 SUB-TOTAL $555,185 $519,830 $500,000 $320,000 $320,000 OTHER Right of Way Usage Fees $0 $0 $0 $0 $0 Sales of Property 0 376,140 0 0 0 Interest Income 6,539 28,455 16,800 19,599 2,600 Other Income 0 1,060,000 0 0 0 SUB-TOTAL $6,539 $1,464,595 $16,800 $19,599 $2,600 APPROPRIATION OF RESERVES General Fund Purposes $0 $0 $970,679 $2,702,390 $0 SUB-TOTAL $0 $0 $970,679 $2,702,390 $0 TOTAL REVENUES $561,724 $1,984,424 $1,487,479 $3,041,989 $322,600 EXPENDITURES OPERATING Transfer to Capital Projects $100,000 $0 $790,000 $2,290,000 $0 Interfund Loan 0 0 697,479 751,989 0 Contribution to Reserves 398,300 0 0 0 322,600 Other 22,185 4,518 0 0 0 TOTAL EXPENDITURES $520,485 $4,518 $1,487,479 $3,041,989 $322,600 BALANCE $41,239 $1,979,907 $0 $0 $0 21 FISCAL YEAR 2020-2021 SCHEDULE 15-SUMMARY OF REVENUES AND EXPENDITURES TRAFFIC SAFETY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES Gross Fine Revenues $977,595 $829,488 $0 $34,250 $0 Interest Income 8,416 14,727 0 8,330 6,300 Transfer from General CIP 0 0 0 0 0 Prior Year Encumbrances 76,510 0 0 4,988 0 Appropriation of Fund Balance 0 0 86,726 86,726 50,611 TOTAL REVENUES $1,062,520 $844,215 $86,726 $134,294 $56,911 EXPENDITURES Contractor Payments $484,545 $331,500 $0 $0 $0 Program Administration 298,120 309,239 0 0 0 Payment to State 98,204 94,375 0 0 0 Traffic Enforcement/Traffic Safety 76,510 30,903 70,145 75,133 20,352 Pedestrian Safety 16,994 17,854 16,581 16,581 36,559 Transfer to Capital Projects 0 0 0 0 0 Contribution to Reserves 0 0 0 42,580 0 SUB-TOTAL OTHER EXPENDITURES $974,374 $783,870 $86,726 $134,294 $56,911 TOTAL EXPENDITURES $974,374 $783,870 $86,726 $134,294 $56,911 BALANCE $88,147 $60,345 $0 $0 $0 22 FISCAL YEAR 2020-2021 SCHEDULE 16-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES WATER SALES AND CHARGES Water Sales $22,064,283 $20,524,954 $24,556,883 $24,164,934 $24,557,806 Water Prior Year Settle-up $1,108,469 $308,637 $0 $320,263 $0 Water Taps 38,815 46,380 44,200 44,200 44,200 Water Inspection Fees 35,816 44,952 24,000 24,000 24,000 SUB-TOTAL $23,247,383 $20,924,923 $24,625,083 $24,553,397 $24,626,006 SEWER SALES AND CHARGES Sewer Sales $11,497,849 $11,473,122 $12,660,706 $12,414,977 $12,944,250 Sewer Prior Year Settle-Up $608,287 $169,741 $0 $33,699 $0 Sewer Taps 11,750 12,200 12,600 12,600 12,600 Sewer Inspection Fees 35,789 32,660 24,000 19,000 24,000 SUB-TOTAL $12,153,675 $11,687,722 $12,697,306 $12,480,276 $12,980,850 MISCELLANEOUS Interest Income $105,213 $169,319 $144,000 $103,769 $81,000 Service Charges 171,314 161,110 153,500 133,388 144,500 Late Charges 449,044 418,931 420,000 318,111 420,000 Miscellaneous 50,666 70,233 36,034 55,550 36,034 Joint Use Reimbursement-Watauga 57,724 175,940 93,000 102,925 115,668 Subdivision Meter Revenue 56,994 61,855 64,193 60,193 62,000 Bond Refunding Proceeds 0 0 0 0 0 Interfund Loan Repayments 0 0 0 0 0 SUB-TOTAL $890,955 $1,057,389 $910,727 $773,936 $859,202 APPROPRIATION OF FUND BALANCE Prior Year Encumbrances $89,843 $129,210 $0 $15,920 $0 Appropriation of Fund Balance 685,883 0 0 0 0 SUB-TOTAL $775,726 $129,210 $0 $15,920 $0 TOTAL REVENUES $37,067,738 $33,799,244 $38,233,116 $37,823,529 $38,466,058 23 FISCAL YEAR 2020-2021 SCHEDULE 16-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 EXPENDITURES OPERATING Administration $330,727 $342,151 $356,793 $354,171 $364,744 Development 835,637 912,295 946,578 945,842 946,163 Right of Way Maintenance 245,981 247,615 352,976 352,570 353,791 SUB-TOTAL $1,412,345 $1,502,061 $1,656,347 $1,652,583 $1,664,698 WATER SERVICES Water Operations $4,481,466 $4,612,600 $4,799,523 $4,766,117 $4,746,677 Purchase of Water FTW 4,706,889 3,796,889 4,294,242 3,274,554 4,162,713 Purchase of Water TRA 6,499,342 5,850,057 6,197,623 6,763,657 6,270,518 SUB-TOTAL $15,687,697 $14,259,545 $15,291,388 $14,804,328 $15,179,908 SEWER SERVICES Sewer Operations $1,380,901 $1,447,546 $1,499,013 $1,463,974 $1,498,011 Sewer Treatment FTW 1,435,478 1,652,607 1,522,893 1,463,829 1,377,029 Sewer Treatment TRA 4,594,248 4,789,894 5,073,378 5,349,157 5,054,036 SUB-TOTAL $7,410,628 $7,890,047 $8,095,284 $8,276,960 $7,929,076 FINANCE/UTILITY COLLECTIONS Meter Reading $501,660 $519,535 $571,258 $571,392 $544,694 Utility Billing/Customer Service 934,234 1,013,629 1,051,214 1,040,074 1,054,459 Utility Collection Services 230,834 238,481 249,273 248,098 249,084 Accounting Services 403,832 422,529 444,255 437,717 445,252 Budget&Research 218,301 227,407 236,339 232,820 236,379 SUB-TOTAL $2,288,861 $2,421,582 $2,552,339 $2,530,101 $2,529,868 Building Services $1,822,929 $1,822,929 $1,822,929 $1,822,929 $1,822,929 Non Departmental $177,419 $423,073 $317,120 $338,091 $323,633 SUB-TOTAL DEPARTMENTS $28,799,878 $28,319,237 $29,735,407 $29,424,992 $29,450,112 OTHER&RESERVES Debt Service $1,109,688 $1,465,880 $1,673,546 $1,658,969 $1,645,049 Bond Defeasance/Refunding 0 0 0 0 0 Franchise Fees 1,003,680 937,584 1,116,527 1,097,397 1,125,062 Indirect Costs 2,304,572 2,304,572 2,182,170 2,182,170 2,182,170 Payment in Lieu of Taxes 392,821 415,689 405,201 405,201 410,217 Transfer to Information Technology 175,000 175,000 175,000 175,000 175,000 Transfer to Equipment Services 0 0 0 0 0 Transfer to Capital 757,523 736,657 901,657 901,657 2,263,011 Contribution to Reserves 1,647,883 0 2,043,608 1,978,143 1,215,437 SUB-TOTAL $7,391,167 $6,035,382 $8,497,709 $8,398,537 $9,015,946 TOTAL EXPENDITURES $36,191,045 $34,354,619 $38,233,116 $37,823,529 $38,466,058 BALANCE $876,694 ($555,374) $0 $0 $0 24 FISCAL YEAR 2020-2021 SCHEDULE 17-SUMMARY OF REVENUES AND EXPENDITURES AQUATIC PARK FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 ATTENDANCE 184,064 185,971 210,000 12,461 190,000 REVENUES OPERATING Admissions $2,840,631 $3,018,538 $3,259,118 $500,000 $3,096,162 Food and Beverage 675,021 802,567 848,881 66,200 806,437 Merchandise 113,567 122,230 150,087 8,400 142,583 Rentals 130,093 129,071 180,105 6,000 171,100 Aquatic Classes/Special Events 10,416 (3,125) 0 0 0 SUB-TOTAL $3,769,728 $4,069,281 $4,438,191 $580,600 $4,216,282 OTHER REVENUES Interest Income $14,537 $20,572 $20,632 $13,695 $16,441 Other Income 42,362 43,315 47,500 100 60,000 Bond Refunding Proceeds 0 0 0 0 0 SUB-TOTAL $56,899 $63,887 $68,132 $13,795 $76,441 SUB-TOTAL REVENUES $3,826,627 $4,133,168 $4,506,323 $594,395 $4,292,723 APPROPRIATION OF FUND BALANCE&TRANSFERS General Fund Transfer-In $0 $0 $0 $2,309,693 $0 Appropriation of Fund Balance $0 $32,507 $0 $0 $0 SUB-TOTAL $0 $32,507 $0 $2,309,693 $0 TOTAL REVENUES $3,826,627 $4,165,675 $4,506,323 $2,904,088 $4,292,723 EXPENDITURES OPERATING General Services&Utilities $816,727 $652,875 $673,365 $552,299 $709,605 Public Grounds/Aquatics/Maint. 1,156,580 1,171,384 1,130,995 783,994 1,134,721 Business&Office Administration 511,154 508,504 516,070 225,292 524,056 Gift Shop/Concessions 548,513 593,322 601,103 233,582 601,894 Sales/Special Events/Admissions 259,626 263,682 317,519 201,612 319,327 SUB-TOTAL $3,292,600 $3,189,767 $3,239,052 $1,996,779 $3,289,603 OTHER&RESERVES Debt Service $904,108 $810,478 $753,029 $753,029 $735,408 Bond Defeasance/Refunding/Agent Fees 1,077 10,587 1,250 1,250 1,022 Indirect Costs 0 0 0 0 0 Transfer Out-PARD 0 0 0 0 0 Transfer to Capital Projects 100,000 100,000 100,000 100,000 100,000 Reserve For Infrastructure&Major Repairs 24,049 0 357,669 0 103,472 Non-Departmental 52,000 59,663 55,323 53,030 63,218 SUB-TOTAL $1,081,235 $980,728 $1,267,271 $907,309 $1,003,120 TOTAL EXPENDITURES $4,373,834 $4,170,496 $4,506,323 $2,904,088 $4,292,723 BALANCE ($547,207) ($4,821) $0 $0 $0 25 FISCAL YEAR 2020-2021 SCHEDULE 18-SUMMARY OF REVENUES AND EXPENDITURES GOLF COURSE FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 ROUNDS 42,953 46,915 16,841 17,500 47,000 REVENUES Green Fees $845,548 $1,088,406 $295,900 $318,000 $1,092,000 Pro Shop 446,520 543,648 196,400 244,000 393,000 Driving Range 58,709 71,936 34,500 34,500 75,000 Carts 383,638 341,221 133,900 114,000 415,000 Food&Beverage 625,910 515,734 253,600 267,773 744,500 General&Administrative 77 77 0 0 0 Interfund Loan 0 0 697,479 751,989 0 Other Revenue 42,832 29,756 39,768 36,307 7,572 Appropriation of Fund Balance 0 0 0 97,521 0 TOTAL REVENUE $2,403,235 $2,590,779 $1,651,547 $1,864,090 $2,727,072 EXPENDITURES OPERATING Pro Shop $91,489 $114,161 $73,110 $107,722 $145,050 Pro Shop:Cost of Goods Sold 160,495 156,730 59,000 63,500 149,000 Driving Range 14,862 21,660 16,500 12,135 18,200 Golf Carts 243,858 254,804 156,604 169,464 257,762 Course Maintenance 595,870 605,841 552,181 540,800 601,725 Food&Beverage 311,547 252,943 163,090 160,900 305,380 Food&Beverage:Cost of Goods Sold 209,681 207,015 80,280 90,400 216,900 Sales&Membership 280 0 0 0 0 General&Administrative 355,242 358,806 278,775 296,798 358,132 Clubhouse 96,681 82,811 90,100 74,430 84,032 Management Fees 135,903 145,111 130,033 130,033 147,560 Capital 156,105 319,602 0 0 114,879 SUB-TOTAL $2,372,013 $2,519,484 $1,599,673 $1,646,182 $2,398,620 OTHER&RESERVES Debt Service $63,834 $62,443 $51,874 $117,908 $328,452 Transfer to Capital Projects 0 0 0 100,000 0 Payment to Interdepartmental Loans Water Fund 0 0 0 0 0 General Fund 0 0 0 0 0 Contribution to Reserves 0 0 0 0 0 SUB-TOTAL $63,834 $62,443 $51,874 $217,908 $328,452 TOTAL EXPENDITURES $2,435,847 $2,581,927 $1,651,547 $1,864,090 $2,727,072 BALANCE ($32,612) $8,852 $0 $0 $0 26 FISCAL YEAR 2020-2021 SCHEDULE 19-SUMMARY OF REVENUES AND EXPENDITURES FACILITIES/CONSTRUCTION MANAGEMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES CHARGES FOR SERVICE Transfer From: General Fund $812,101 $812,101 $812,101 $812,101 $812,101 Park Development Fund 284,090 274,090 277,788 277,788 276,414 Utility Fund 1,822,929 1,822,929 1,822,929 1,822,929 1,822,929 SUB-TOTAL $2,919,120 $2,909,120 $2,912,818 $2,912,818 $2,911,444 OTHER REVENUES Insurance Settlements $0 $0 $0 $0 $0 Interest Income 24,743 39,998 33,000 33,000 16,000 Rent From Rental Properties 55,481 38,200 36,900 42,300 39,600 Other Income (45,260) 1,444 0 0 0 SUB-TOTAL $34,964 $79,642 $69,900 $75,300 $55,600 SUB-TOTAL REVENUES $2,954,084 $2,988,762 $2,982,718 $2,988,118 $2,967,044 APPROPRIATION OF FUND BALANCE Building Services Fund Reserves $0 $0 $0 $0 $301,146 Prior Year Encumbrances 0 0 0 0 0 SUB-TOTAL $0 $0 $0 $0 $301,146 TOTAL REVENUES $2,954,084 $2,988,762 $2,982,718 $2,988,118 $3,268,190 EXPENDITURES General Services $325,124 $257,501 $265,629 $263,157 $247,051 Building Services 2,182,135 1,984,656 2,474,383 2,499,731 2,687,042 Rental Property Program 66,509 25,993 36,120 36,120 36,120 Transfer to Capital Budget 0 309,872 53,000 96,500 274,400 SUB-TOTAL $2,573,768 $2,578,022 $2,829,132 $2,895,508 $3,244,613 OTHER&RESERVES Debt Service $0 $0 $0 $0 $0 Other 16,077 17,581 22,762 22,586 23,577 Contribution of Facility Reserves 143,770 0 130,824 70,024 0 SUB-TOTAL $159,847 $17,581 $153,586 $92,610 $23,577 TOTAL EXPENDITURES $2,733,615 $2,595,603 $2,982,718 $2,988,118 $3,268,190 BALANCE $220,469 $393,160 $0 $0 $0 27 FISCAL YEAR 2020-2021 SCHEDULE 20-SUMMARY OF REVENUES AND EXPENDITURES FLEET SERVICES FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES CHARGES FOR SERVICE Transfer From: General Fund $1,389,677 $1,389,677 $1,389,677 $1,389,677 $1,389,677 Utility Fund 1,967,647 1,967,647 1,967,647 1,967,647 1,967,647 Utility CIP/Utility Construction 288,678 288,678 288,678 288,678 288,678 Crime Control District 170,426 170,426 170,426 170,426 170,426 Park&Recreation Dev. Fund 143,817 171,939 171,939 171,939 171,939 Other Funds 24,119 24,119 24,119 24,119 24,119 SUB-TOTAL $3,984,365 $4,012,486 $4,012,486 $4,012,486 $4,012,486 OTHER REVENUES Interst Income $35,726 $44,452 $42,000 $30,000 $23,300 Sale of City Property 10,997 55,480 20,000 20,000 20,000 Other Income 56,540 180 0 23,564 0 Transfer from General Fund 0 0 0 28,875 0 Transfer from Utility Fund 0 0 0 0 0 SUB-TOTAL $103,263 $100,112 $62,000 $102,439 $43,300 SUB-TOTAL REVENUES $4,087,628 $4,112,598 $4,074,486 $4,114,925 $4,055,786 APPROPRIATION OF FUND BALANCE Equipment Services Fund Reserves $0 $146,677 $437,013 $801,424 $0 Appropriation-PY Encumbrances 732,668 634,450 0 85,379 0 SUB-TOTAL $732,668 $781,127 $437,013 $886,803 $0 TOAL REVENUES $4,820,296 $4,893,725 $4,511,499 $5,001,728 $4,055,786 EXPENDITURES General Services $176,085 $276,444 $292,713 $288,953 $295,207 Equipment Services Operations 1,563,460 1,560,112 1,574,364 1,664,249 1,621,025 Fire Fleet Maintenance 358,744 272,526 323,461 366,935 345,333 Equipment Purchases 471,993 525,005 746,830 600,748 277,750 Fire Vehicles/Equipment 162,229 63,102 107,280 77,280 0 Police Vehicles/Equipment 337,029 1,050,848 553,000 536,000 713,774 SUB-TOTAL $3,069,541 $3,748,036 $3,597,648 $3,534,165 $3,253,089 OTHER&RESERVES Debt Service $421,484 $519,706 $629,884 $498,973 $673,555 Transfer to Capital Projects 192,232 609,000 162,411 558,822 0 Other 15,498 16,983 21,556 20,320 22,516 Equipment Services Reserve 231,596 0 100,000 389,448 106,626 SUB-TOTAL $860,810 $1,145,689 $913,851 $1,467,563 $802,697 TOTAL EXPENDITURES $3,930,351 $4,893,725 $4,511,499 $5,001,728 $4,055,786 BALANCE $889,944 $0 $0 $0 $0 28 FISCAL YEAR 2020-2021 SCHEDULE 21 -SUMMARY OF REVENUES AND EXPENDITURES INFORMATION TECHNOLOGY FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES TELECOMMUNICATIONS Transfer From: General Fund $371,220 $369,543 $369,544 $369,544 $365,569 Park Fund 37,493 37,493 37,493 37,493 41,468 Crime Control District 30,796 36,532 39,739 39,739 39,739 Utility Fund 93,965 93,965 93,965 93,965 93,965 Other Funds 65,309 67,487 67,487 67,487 67,487 SUB-TOTAL $598,783 $605,020 $608,228 $608,228 $608,228 COMPUTERS Transfer From: General Fund $1,098,076 $1,093,678 $1,093,677 $1,035,727 $1,092,996 Park Fund 118,506 118,506 118,506 118,506 131,308 Crime Control District 194,627 204,632 210,252 210,252 212,354 Utility Fund 771,562 771,562 771,562 771,562 771,562 Other Funds 322,166 322,166 322,166 322,166 323,640 SUB-TOTAL $2,504,937 $2,510,545 $2,516,163 $2,458,213 $2,531,860 OTHER REVENUES Interest Income $20,445 $29,789 $29,167 $21,000 $14,000 Transmitter Lease 175,948 173,761 152,958 170,000 170,000 Other Income 3,418 8,972 0 57,952 0 Transfer from General Fund 82,725 85,492 193,954 209,154 149,144 Transfer from Utility Fund 175,000 175,000 175,000 175,000 175,000 SUB-TOTAL $457,536 $473,014 $551,079 $633,106 $508,144 SUB-TOTAL REVENUES $3,561,256 $3,588,579 $3,675,470 $3,699,547 $3,648,232 APPROPRIATION OF FUND BALANCE Prior Year Encumbrances $7,969 $259,424 $0 $153,301 $0 Appropriation of Information Systems Reserves 0 0 266,152 322,200 360,125 SUB-TOTAL $7,969 $259,424 $266,152 $475,501 $360,125 TOTAL REVENUES $3,569,225 $3,848,003 $3,941,622 $4,175,048 $4,008,357 EXPENDITURES General Services $266,607 $405,448 $266,283 $250,611 $209,230 Major Computer Systems 372,734 302,826 346,426 349,047 363,624 Microcomputer Systems 683,493 766,655 776,217 791,700 983,314 Telecommunications 425,989 445,401 500,599 495,949 370,575 Data Network 751,287 859,765 938,810 936,739 1,030,795 GIS System 175,726 177,690 183,145 182,139 186,907 Public Safety 540,204 703,438 642,645 657,336 688,845 SUB-TOTAL $3,216,040 $3,661,222 $3,654,125 $3,663,521 $3,833,290 OTHER&RESERVES Other $9,789 $10,301 $14,497 $26,017 $15,067 Transfer to Capital Projects 0 176,480 273,000 485,510 160,000 Reserve for System Improvements 55,212 0 0 0 0 SUB-TOTAL $65,001 $186,781 $287,497 $511,527 $175,067 TOTAL EXPENDITURES $3,281,041 $3,848,003 $3,941,622 $4,175,048 $4,008,357 BALANCE $288,184 $0 $0 $0 $0 29 FISCAL YEAR 2020-2021 SCHEDULE 22-SUMMARY OF REVENUES AND EXPENDITURES SELF INSURANCE FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES ALLOCATIONS Health/Medical City Contribution $9,243,366 $9,955,609 $10,384,304 $10,384,304 $10,391,990 Health/Medical Employee Contribution 2,371,080 2,553,843 2,764,264 2,764,264 2,791,021 Worker's Compensation 500,390 208,884 589,500 589,500 589,500 Administration Allocation 605,920 901,257 517,637 517,637 517,920 Other Insurance 701,581 758,584 813,925 813,925 870,496 SUB-TOTAL 13,422,336 $14,378,177 $15,069,630 $15,069,630 $15,160,927 OTHER REVENUES Interest Income $57,782 $98,968 $81,473 $81,524 $97,868 Other Income 132,519 146,565 137,000 137,000 146,000 Expenditure Reimbursement 783,065 479,032 400,000 400,000 400,000 SUB-TOTAL 973,366 $724,565 $618,473 $618,524 $643,868 SUB-TOTAL REVENUES $14,395,702 $15,102,742 $15,688,103 $15,688,154 $15,804,795 APPROPRIATION OF FUND BALANCE Self Insurance Fund Reserves $100,000 $100,000 $100,000 $100,000 $100,000 SUB-TOTAL $100,000 $100,000 $100,000 $100,000 $100,000 TOAL REVENUES $14,495,702 $15,202,742 $15,788,103 $15,788,154 $15,904,795 EXPENDITURES Health/Medical $11,483,456 $10,788,101 $13,259,089 $11,262,557 $13,652,917 Worker's Compensation 35,901 208,884 589,500 589,500 589,500 Personnel Expenses 472,280 486,331 508,784 497,881 514,731 Other Insurance 551,421 676,485 678,926 678,926 751,496 Reserve for Insurance Claims 0 0 0 0 0 Other Expenses 105,129 144,842 137,000 198,500 146,000 Life Insurance Premium 105,713 128,184 135,000 135,000 119,000 SUB-TOTAL $12,753,900 $12,432,826 $15,308,299 $13,362,364 $15,773,644 OTHER&RESERVES Transfer to Retiree Health Care Fund $100,000 $100,000 $100,000 $100,000 $100,000 Contribution to Reserves 343,205 12,900 379,804 2,325,790 31,151 SUB-TOTAL 443,205 $112,900 $479,804 $2,425,790 $131,151 TOTAL EXPENDITURES $13,197,105 $12,545,726 $15,788,103 $15,788,154 $15,904,795 BALANCE $1,298,597 $2,657,016 $0 $0 $0 30 FISCAL YEAR 2020-2021 SCHEDULE 23-SUMMARY OF REVENUES AND EXPENDITURES CARES ACT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2017/18 FY 2018/19 FY 2019/20 FY 2019/20 FY 2020/21 REVENUES Cares Act Grant $0 $0 $0 $3,738,900 $0 SUB-TOTAL $0 $0 $0 $3,738,900 $0 TOTAL REVENUES $0 $0 $0 $3,738,900 $0 EXPENDITURES COVID-19 Immediate Response $0 $0 $0 $125,000 $0 COVID-19 Mitigation&Recovery 0 0 0 575,000 0 COVID-19 Direct Reimbursable Personnel Expenses 0 0 0 3,038,900 0 SUB-TOTAL $0 $0 $0 $3,738,900 $0 TOTAL EXPENDITURES $0 $0 $0 $3,738,900 $0 BALANCE $0 $0 $0 $0 $0 31 FISCAL YEAR 2020-21 WORKING CAPITAL BALANCE SUMMARY-ALL FUNDS Working Capital is defined as current assets minus current liabilities and other restrictions(existing encumbrances,balances in projects underway,and other restrictions). Maintaining an appropriate level of working capital balance is essential for the City to mitigate financial risk that can occur from unforeseen revenue shortfalls,unanticipated expenditures,or any other adverse circumstances. The City maintains an appropriate working capital balance level within each fund as determined by best practice and City policy. The Working Capital Balance Summary shows an estimated beginning balance as of September 30,2019 for all budgeted funds along with the estimated impact based upon the FY 2019-2020 Revised Budget and FY 2020-2021 Proposed Budget. FY 2019-2020 FY 2020-2021 Revised Budget FY 2019-2020 Proposed Budget FY 2020-2021 ESTIMATE AS OF Increase Revised Budget Increase Proposed Budget FUND 09/30/19 (Decrease) Ending Balance (Decrease) Ending Balance General Fund(Unreserved/Undesignated) $ 13,191,271 $ (2,085,683) $ 11,105,588 $ 11,409 $ 11,116,997 General Fund Designated for Municipal Court $ 724,419 $ (64,376) $ 660,043 $ (57,063) $ 602,980 Technology&Security&JCM General Fund Designated for Franchise Peg $ 616,856 $ 41,345 $ 658,201 $ 136,643 $ 794,844 Fees General Debt Service Fund* $ 1,299,285 $ 53,982 $ 1,353,267 $ - $ 1,353,267 Utility Fund Unrestricted $ 4,505,793 $ 1,962,223 $ 6,468,016 $ 1,215,437 $ 7,683,453 Golf Course Fund Unrestricted $ 97,521 $ (97,521) $ - $ - $ - Aquatic Park Fund Unrestricted $ 12,506 $ - $ 12,506 $ 103,472 $ 115,978 Facilities&Construction Services Fund $ 3,138,595 $ 70,024 $ 3,208,619 $ (301,146) $ 2,907,473 Fleet Services Fund $ 2,252,911 $ (597,355) $ 1,655,556 $ 106,626 $ 1,762,182 Self Insurance Fund $ 6,720,714 $ 2,225,790 $ 8,946,504 $ (68,849) $ 8,877,655 Information Technology Fund $ 2,307,790 $ (475,501) $ 1,832,289 $ (360,125) $ 1,472,164 Promotional Fund $ 770,803 $ (58,823) $ 711,980 $ (95,826) $ 616,154 Donations Fund $ 623,771 $ (29,360) $ 594,411 $ (28,362) $ 566,049 Special Investigation Fund $ 405,157 $ (177,800) $ 227,357 $ (182,800) $ 44,557 Drainage Utility Fund $ 1,130,422 $ 803,819 $ 1,934,241 $ 831,442 $ 2,765,683 Gas Development Fund $ 2,928,056 $ (2,702,390) $ 225,666 $ 322,600 $ 548,266 Traffic Safety Fund $ 724,421 $ (49,134) $ 675,287 $ (50,611) $ 624,676 Park&Recreation Facilities Development Fund $ 842,595 $ (42,021) $ 800,574 $ 744,890 $ 1,545,464 Recreation Centre $ 3,009,997 $ (460,878) $ 2,549,119 $ 285,557 $ 2,834,676 Park Impact Fee Fund $ 971,978 $ 80,000 $ 1,051,978 $ (170,000) $ 881,978 Economic Development Fund $ 172,340 $ 126,858 $ 299,198 $ 130,400 $ 429,598 Crime Control&Prevention District Fund $ 707,949 $ 110,521 $ 818,470 $ - $ 818,470 *CAFR undesignated fund balance. 32 Summary of Changes as of August 4, 2020 in the Revised Proposed Budget Changes in Revenues Revenue FY19/20 Revised FY20/21 Proposed Page# Fund Name Schedule Category Change Amount Change Amount Reference No Changes in revenues. 33 Summary of Changes as of August 4, 2020 in the Revised Proposed Budget Changes in Expenditures Expenditure FY19/2O RevisedFY2O/21 Proposed Page# Fund Name Schedule Category Change Amount Change Amount Reference Cares Act Fund 23 COVID-19 Immediate Response $14,008 $0 31 COVID-19 Mitigation&Recovery $81,128 $0 31 COVID-19 Direct Reimbursable $3,038,900 $0 31 Personnel Expenses 34 Summary of Changes as of July 31, 2020 in the Revised Proposed Budget Changes in Revenues Revenue FY19/2O Revised FY2O/21 Proposed Page# Fund Name Schedule Category Change Amount Change Amount Reference General Fund 1 Taxes $0 ($.:i3S'r) 4 2 Current Taxes $0 ($,'18S'vr) 5 Summary of Property Tax Revenue 4 Schedule added $0 $0 10 Debt Service Fund 5 Interest Income $0 ($:'4 "'€')) 11 Fleet Services Fund "(�] ' / 'I s " ) $0 11 Tax Increment Financing Fund 6,7 TIF#2 City of NRH $0 (E L)(" L)')7) 13 TIF#2 TCCD $0 S'rS'r) 13 Parks&Recreation Facilities Dev.Fun 8 Appr.Sales Tax Reserves (l]'L );"}O $0 14 Appr.Of NRH Centre Reserves $460,878 $0 14 Promotional Fund 10 Appr.Of Fund Balance $58,823 $95,826 17 Special Investigations Fund 12 Appr.Of Fund Balance $70,000 $182,800 19 Gas Development Fund 14 General Fund Purposes $177,201 $0 21 Traffic Safety Fund 15 Appr.Of Fund Balance $0 $50,611 22 Facilities/Constr Mgmt.Fund 19 Building Services Fund Res. $0 $301,146 27 Information Technology Fund 21 Appropr of IS Reserves $0 $360,125 29 Cares Act Fund 23 Cares Act Grant $3,738,900 $0 31 35 Summary of Changes as of July 31, 2020 in the Revised Proposed Budget Changes in Expenditures Expenditure FY19/2O RevisedFY2O/21 Proposed Page# Fund Name Schedule Category Change Amount Change Amount Reference General Fund 1 Reserves $0 $11,409 4 3 General Fund Reserves $0 $11,409 9 Debt Service Fund 5 Existing Bonds&C.O.'s $0 ($: (:")'')) 11 Parks&Recreation Facilities Dev.Fun 8 Operating Reserve $0 $744,890 15 NRH Centre Reserve $0 $285,557 15 CCD Fund 9 Reserves $135,812 $0 16 Drainage Fund 13 Contribution to Reserves $30,418 $831,442 20 Gas Development Fund 14 Contribution to Reserves $0 $322,600 21 Traffic Safety Fund 15 Contribution to Reserves $42,580 $0 22 Utility Fund 16 Contribution to Reserves $0 $1,215,437 24 Aquatic Park Fund 17 Reserve for Infra.&Major Repair $0 $103,472 25 Facilities/Constr Mgmt.Fund 19 Contribution of Facility Res. $42,700 $0 27 Fleet Fund 20 Equipment Services Reserve $289,448 $106,626 28 Debt Service "(�] ' / 'I s " ) $0 Self Insurance Fund 22 Contribution to Reserves $2,007,486 $31,151 30 Cares Act Fund 23 Covid-19 Immediate Response $110,992 $0 31 Covid-19 Mitigation&Recovery $493,872 $0 31 36 CITY OF NORTH RICHLAND HILLS Proposed Capital BUDGET FY2020/21 ' l / BUDGET DEPARTMENT E b�jdgft2 irj2jL.= �Y Jl 4301 CITY POINT DR. W www.nr]htx.com h, ....... NORTH RICHLAND HILLS, TX P : 817-427-6053 � °�'�� 76180 v° t , , ,n 1° 1 NItH CITY OF NORTH RICHLAND HILLS REVISED PROPOSED 2020/2021 CAPITAL PROJECTS BUDGET CAPITAL BUDGET TABLE OF CONTENTS FY2020/21 CIP BUDGET SUMMARIES Illustration — 2020/21 Proposed CIP Budget......................................................................................7 Summary of Project Expenditures .....................................................................................................8 Summary of Project Funding .............................................................................................................9 DetailedProject Funding ................................................................................................................. 10 STREET & SIDEWALK PROJECTS Schedule 1 — Street & Sidewalk Projects Budget Summary ............................................................ 15 Continuing Projects Glenview Drive East Project..................................................................................................... 18 New Projects Hightower/ Davis Traffic Signal ............................................................................................... 19 Iron Horse Boulevard Reconstruction.......................................................................................20 Preventive Street Maintenance (2021).....................................................................................21 Sidewalk Rehabilitation and Replacement Project (2021)........................................................22 Transportation Management Project Equipment......................................................................23 DRAINAGE PROJECTS Schedule 2 — Drainage Projects Budget Summary..........................................................................24 New Projects Channel Cleaning / Street Drainage Improvements .................................................................26 Concrete Lined Channel Rehabilitation Project........................................................................27 Street Drainage Improvements Project (2021).........................................................................28 UTILITY PROJECTS Schedule 3 — Utility Projects Budget Summary................................................................................29 New Projects Automatic Control Valve (ACV) Replacement..........................................................................32 College Hills Ground Storage Tank Rehabilitation ...................................................................33 Matson Drive Sanitary Sewer...................................................................................................34 3 CITY OF NORTH RICHLAND HILLS REVISED PROPOSED 2020/2021 CAPITAL PROJECTS BUDGET CAPITAL BUDGET TABLE OF CONTENTS Miscellaneous Water/Sewer Main Replacement (2021)...........................................................35 SCADA Communication Replacement.....................................................................................36 Sewer Manhole Replacement and Rehabilitation Project (2021) .............................................37 Small Water Main Replacements (2021)..................................................................................38 Telemetric Water Meter Annual Maintenance (2020)...............................................................39 PARKS & RECREATION PROJECTS Schedule 4 — Parks & Recreation Projects Budget Summary .........................................................40 New Projects Annual Tree Planting (2021) ....................................................................................................42 NRH Centre Fitness Equipment Replacement.........................................................................43 NRH Centre Grand Hall AV Projectors Replacement...............................................................44 Park Infrastructure Maintenance (2021)...................................................................................45 Richfield Park Tennis/Pickleball Court Replacement................................................................46 Richland Tennis Center Infrastructure Maintenance (2021).....................................................47 AQUATIC PARK PROJECTS Schedule 5 —Aquatic Projects Budget Summary ............................................................................48 New Projects General Facility Improvements (2021) .....................................................................................50 Waterpark Security Camera System Improvements and Upgrade...........................................51 FACILITIES PROJECTS Schedule 6 — Facilities Projects Budget Summary ..........................................................................52 New Projects Concrete Drive Repair at FS #2, FS #5 and Service Center....................................................54 Replace UPS Batteries at City Hall ..........................................................................................55 RoofReplacement at FS #1 .....................................................................................................56 4 CITY OF NORTH RICHLAND HILLS REVISED PROPOSED 2020/2021 CAPITAL PROJECTS BUDGET CAPITAL BUDGET TABLE OF CONTENTS MAJOR CAPITAL EQUIPMENT PROJECTS Schedule 7 — Major Capital Equipment Projects Budget Summary .................................................57 Continuing Projects Purchase/Replacement of Storage Area Network (SAN) Hardware.........................................59 New Projects CradlePoint Upgrade for Fire Vehicles.....................................................................................60 Purchase of 7-Bin Automated Sorting System for the Library ..................................................61 Truck and Jetter Replacement (Units 5501 and 5551).............................................................62 Valve Maintenance Trailer........................................................................................................63 ECONOMIC DEVELOPMENT PROJECTS Schedule 8 — Economic Development Projects Budget Summary...................................................64 CIP PERSONNEL PROJECTS Schedule 9 — CIP Personnel Projects Budget Summary .................................................................65 OTHER PROJECTS Schedule 10 — Other Capital Projects Budget Summary .................................................................66 PROJECT REVISIONS Schedule 11 — Project Revision Summary.......................................................................................67 SCHEDULE OF CHANGES Schedule of Changes in Proposed Budget.................................................................................... 114 5 NItH Fiscal Year 2020/21 Proposed CIP Budget $1973857361 Uses of Funds Drainage 2.32% utility 44.95% Parks &Recreation 3.43% Street&Sidewalk �� 73.43% Aquatic Park 0.64% Facilities 1.42% Major Capital Equipment 3.32% CIP Personnel 1.82% Sources of Funds C.O. BONDS,38.0% Federal/State Grants, 23.9% Reserves,1.0% G.O. Bonds,17.3% Sales Tax,1.8% 7 Summary of Project Expenditures 2020/2021 Capital Improvement Program Project To Proposed Estimated 2022 to Total Program Classification Date 2020/2021 2021/2022 Completion Expenditures Street&Sidewalk 39,916,444 14,235,550 0 0 $ 54,151,994 Drainage 2,289,108 450,000 0 0 $ 2,739,108 Utility 15,263,260 2,639,906 0 0 $ 17,903,166 Parks&Recreation 7,076,155 664,000 0 0 $ 7,740,155 Aquatic Park 100,000 125,000 0 0 $ 225,000 Facilities 569,500 274,400 0 0 $ 843,900 Major Capital Equipment 10,571,260 643,400 0 0 $ 11,214,660 Economic Development 9,486,184 0 0 0 $ 9,486,184 CIP Personnel 1,003,318 353,105 0 0 $ 1,356,423 Other 600,796 0 0 0 $ 600,796 Total CIP Project Expenditures $ 86,876,025 $ 19,385,361 $ 0 $ 0 $ 106,261,386 8 Summary of Project Funding 2020/2021 Capital Improvement Program Funding To Proposed Estimated 2022 to Total Funds Funding Source Date 2020/2021 2021/2022 Completion General Obligation Bonds 7,120,000 3,480,000 0 0 10,600,000 Certificates of Obligation 25,004,735 3,360,000 0 0 28,364,735 Federal/State Grants 20,491,961 7,363,400 0 0 27,855,361 Reserves 24,140,612 4,632,961 0 0 28,773,573 Sales Tax 1,778,533 201,000 0 0 1,979,533 Other 8,340,184 348,000 0 0 8,688,184 Total CIP Project Funding $ 86,876,025 $ 19,385,361 $ 0 $ 0 $ 106,261,386 9 Summary of Project Funding 2020/21 Capital Improvement Program Funding To Proposed Estimated 2022 to Total Funds Program Date 2020/2021 2021/22 Completion Street&Sidewalk General Obligation Bonds G.O. Bonds 1994 Program 760,000 0 0 0 $ 760,000 G.O. Bonds 2003 Program 5,980,000 0 0 0 $ 5,980,000 2003 Bond Program Project Savings 380,000 3,480,000 0 0 $ 3,860,000 General Obligation Bonds $ 7,120,000 $ 3,480,000 $ 0 $ 0 $ 10,600,000 Certificates of Obligation Certificates of Obligation 7,625,000 2,215,000 0 0 $ 9,840,000 Certificates of Obligation $ 7,625,000 $ 2,215,000 $ 0 $ 0 $ 9,840,000 Federal/State Grants ISTEA Grant Funds 2,240,040 0 0 0 $ 2,240,040 Other 525,190 0 0 0 $ 525,190 TEA-21 Grant Funds 9,712,000 0 0 0 $ 9,712,000 TXDOT Funding 180,000 0 0 0 $ 180,000 Federal Grant 6,282,697 7,295,000 0 0 $ 13,577,697 Tarrant County Grant Funds 600,000 0 0 0 $ 600,000 Federal/State Grants $ 19,539,927 $ 7,295,000 $ 0 $ 0 $ 26,834,927 Reserves 1994 Bond Program Project Savings 365,010 0 0 0 $ 365,010 G.O. Bonds 1994 Program 75,000 0 0 0 $ 75,000 General Fund (001) 1,080,297 1,245,550 0 0 $ 2,325,847 Reserves 140,000 0 0 0 $ 140,000 Permanent Sidewalk Maintenance Fund 52,784 0 0 0 $ 52,784 Unspecified Project Savings 375,000 0 0 0 $ 375,000 Utility Operations for Capital Projects 200,000 0 0 0 $ 200,000 Project Savings 1,033,051 0 0 0 $ 1,033,051 Gas Development Fund Reserves (145) 815,000 0 0 0 $ 815,000 Bond Program Project Savings 65,000 0 0 0 $ 65,000 Utility Reserve for Future Construction 557,000 0 0 0 $ 557,000 Streets &Sidewalks CIP (355) 193,375 0 0 0 $ 193,375 Reserves $ 4,951,517 $ 1,245,550 $ 0 $ 0 $ 6,197,067 Other Other 430,000 0 0 0 $ 430,000 Tarrant County Grant Funds 250,000 0 0 0 $ 250,000 Other $ 680,000 $ 0 $ 0 $ 0 $ 680,000 Street&Sidewalk Sub-Total $ 39,916,444 $ 14,235,550 $ 0 $ 0 $ 54,151,994 Drainage 10 Summary of Project Funding 2020/21 Capital Improvement Program Funding To Proposed Estimated 2022 to Total Funds Program Date 2020/2021 2021/22 Completion Reserves Drainage Utility Fund 1,442,850 450,000 0 0 $ 1,892,850 Reserves 846,258 0 0 0 $ 846,258 Reserves $ 2,289,108 $ 450,000 $ 0 $ 0 $ 2,739,108 Drainage Sub-Total $ 2,289,108 $ 450,000 $ 0 $ 0 $ 2,739,108 Utility Certificates of Obligation Certificates of Obligation 9,429,735 840,000 0 0 $ 10,269,735 Certificates of Obligation $ 9,429,735 $ 840,000 $ 0 $ 0 $ 10,269,735 Reserves Impact Fees 42,000 0 0 0 $ 42,000 Reserves 216,525 0 0 0 $ 216,525 Unspecified Project Savings 55,000 0 0 0 $ 55,000 Utility Operations for Capital Projects 1,280,000 0 0 0 $ 1,280,000 Utility Fund (405) 965,000 1,799,906 0 0 $ 2,764,906 Utility Reserve for Future Construction 275,000 0 0 0 $ 275,000 Reserves $ 2,833,525 $ 1,799,906 $ 0 $ 0 $ 4,633,431 Other Impact Fees 3,000,000 0 0 0 $ 3,000,000 Other $ 3,000,000 $ 0 $ 0 $ 0 $ 3,000,000 Utility Sub-Total $ 15,263,260 $ 2,639,906 $ 0 $ 0 $ 17,903,166 Parks & Recreation Certificates of Obligation Certificates of Obligation 3,285,000 0 0 0 $ 3,285,000 Certificates of Obligation $ 3,285,000 $ 0 $ 0 $ 0 $ 3,285,000 Federal/State Grants TXDOT Funding 576,217 0 0 0 $ 576,217 Federal/State Grants $ 576,217 $ 0 $ 0 $ 0 $ 576,217 Reserves Golf Course Reserve 100,000 0 0 0 $ 100,000 Impact Fees 209,000 0 0 0 $ 209,000 Project Savings 190,043 0 0 0 $ 190,043 Park Sales Tax(125) 931,000 0 0 0 $ 931,000 NRH Centre Fund Reserve(126) 0 140,000 0 0 $ 140,000 Reserves $ 1,430,043 $ 140,000 $ 0 $ 0 $ 1,570,043 11 Summary of Project Funding 2020/21 Capital Improvement Program Funding To Proposed Estimated 2022 to Total Funds Program Date 2020/2021 2021/22 Completion Sales Tax Project Savings 9,505 0 0 0 $ 9,505 Sales Tax Reserve for CIP 322,400 0 0 0 $ 322,400 Park Sales Tax(125) 1,352,990 176,000 0 0 $ 1,528,990 Sales Tax $ 1,684,895 $ 176,000 $ 0 $ 0 $ 1,860,895 Other Impact Fees 0 265,000 0 0 $ 265,000 Other 100,000 0 0 0 $ 100,000 Reserves 0 83,000 0 0 $ 83,000 Project Savings 0 0 0 0 $ 0 Other $ 100,000 $ 348,000 $ 0 $ 0 $ 448,000 Parks & Recreation Sub-Total $ 7,076,155 $ 664,000 $ 0 $ 0 $ 7,740,155 Aquatic Park Reserves Aquatic Park Infrastructure Reserve 100,000 0 0 0 $ 100,000 Reserves 0 100,000 0 0 $ 100,000 Reserves $ 100,000 $ 100,000 $ 0 $ 0 $ 200,000 Sales Tax Park Sales Tax(125) 0 25,000 0 0 $ 25,000 Sales Tax $ 0 $ 25,000 $ 0 $ 0 $ 25,000 Aquatic Park Sub-Total $ 100,000 $ 125,000 $ 0 $ 0 $ 225,000 Facilities Certificates of Obligation Certificates of Obligation 320,000 0 0 0 $ 320,000 Certificates of Obligation $ 320,000 $ 0 $ 0 $ 0 $ 320,000 Reserves Building Services Fund Reserve(505) 249,500 274,400 0 0 $ 523,900 Reserves $ 249,500 $ 274,400 $ 0 $ 0 $ 523,900 Facilities Sub-Total $ 569,500 $ 274,400 $ 0 $ 0 $ 843,900 Maior Capital Equipment Certificates of Obligation Certificates of Obligation 4,345,000 305,000 0 0 $ 4,650,000 Certificates of Obligation $ 4,345,000 $ 305,000 $ 0 $ 0 $ 4,650,000 Federal/State Grants Other 75,817 0 0 0 $ 75,817 12 Summary of Project Funding 2020/21 Capital Improvement Program Funding To Proposed Estimated 2022 to Total Funds Program Date 2020/2021 2021/22 Completion Federal Grant 300,000 68,400 0 0 $ 368,400 Federal/State Grants $ 375,817 $ 68,400 $ 0 $ 0 $ 444,217 Reserves Equipment Services Fund (510) 493,822 0 0 0 $ 493,822 Information Services Reserve 911,173 160,000 0 0 $ 1,071,173 Reserves 1,076,000 0 0 0 $ 1,076,000 Project Savings 226,000 0 0 0 $ 226,000 Utility Fund (405) 0 110,000 0 0 $ 110,000 General CIP Project Savings 204,448 0 0 0 $ 204,448 Reserves $ 2,911,443 $ 270,000 $ 0 $ 0 $ 3,181,443 Other Other 2,939,000 0 0 0 $ 2,939,000 Other $ 2,939,000 $ 0 $ 0 $ 0 $ 2,939,000 Major Capital Equipment Sub-Total $ 10,571,260 $ 643,400 $ 0 $ 0 $ 11,214,660 Economic Development Reserves General Fund (001) 130,000 0 0 0 $ 130,000 General Fund Pay-As-You-Go Reserves 50,000 0 0 0 $ 50,000 Other 50,000 0 0 0 $ 50,000 Reserves 5,935,000 0 0 0 $ 5,935,000 Gas Development Fund Reserves (145) 1,500,000 0 0 0 $ 1,500,000 Gas Fund Reserves (Designated for ED Ac 300,000 0 0 0 $ 300,000 Reserves $ 7,965,000 $ 0 $ 0 $ 0 $ 7,965,000 Other Other 1,521,184 0 0 0 $ 1,521,184 Other $ 1,521,184 $ 0 $ 0 $ 0 $ 1,521,184 Economic Development Sub-Total $ 9,486,184 $ 0 $ 0 $ 0 $ 9,486,184 CIP Personnel Reserves Utility Fund (405) 1,003,318 353,105 0 0 $ 1,356,423 Reserves $ 1,003,318 $ 353,105 $ 0 $ 0 $ 1,356,423 CIP Personnel Sub-Total $ 1,003,318 $ 353,105 $ 0 $ 0 $ 1,356,423 Other Reserves Donations Fund 61,000 0 0 0 $ 61,000 13 Summary of Project Funding 2020/21 Capital Improvement Program Funding To Proposed Estimated 2022 to Total Funds Program Date 2020/2021 2021/22 Completion General Fund (001) 94,000 0 0 0 $ 94,000 Other 252,158 0 0 0 $ 252,158 Reserves $ 407,158 $ 0 $ 0 $ 0 $ 407,158 Sales Tax Economic Development Sales Tax 93,638 0 0 0 $ 93,638 Sales Tax $ 93,638 $ 0 $ 0 $ 0 $ 93,638 Other General Fund (001) 75,000 0 0 0 $ 75,000 Other 25,000 0 0 0 $ 25,000 Other $ 100,000 $ 0 $ 0 $ 0 $ 100,000 Other Sub-Total $ 600,796 $ 0 $ 0 $ 0 $ 600,796 Total CIP Project Funding $ 86,876,025 $ 19,385,361 $ 0 $ 0 $ 106,261,386 14 Schedule 1 Street & Sidewalk Capital Projects Budget Summary Project To 2020/21 2021/22 2022 To Total Date Proposed Estimated Completion Project Costs Continuing Projects 1 ST2004 Transportation Management Project 193,375 0 0 0 $ 193,375 2 ST0401 Davis Blvd/Mid-Cities Blvd Intersection 7,690,000 0 0 0 $ 7,690,000 3 ST2006 Glenview Drive East Project 380,000 3,480,000 0 0 $ 3,860,000 4 ST0904 Grand Avenue(Library to Health Markets Access Road) 75,000 0 0 0 $ 75,000 5 ST1102 Main St.Streetscaping&Snider St.Extension Project 2,866,050 0 0 0 $ 2,866,050 6 PW1602 Meadow Lakes Drive&Rufe Snow Drive Intersection 1,065,000 0 0 0 $ 1,065,000 7 ST2003 Northeast Parkway/Davis Blvd.Traffic Signal 355,000 0 0 0 $ 355,000 8 ST2005 Northeast Parkway Extension 815,000 0 0 0 $ 815,000 SM1901 Preventive Street Maintenance(2019) 1,000,000 0 0 0 $ 1,000,000 SM2001 Preventive Street Maintenance(2020) 1,000,000 0 0 0 $ 1,000,000 SM1902 Preventive Street Maintenance(Multi-Year) 1,575,000 0 0 0 $ 1,575,000 9 ST0202 Rufe Snow Dr.Street&Utility Imp.(Mid-Cities to Hightower)[TEA-21] 21,703,236 0 0 0 $ 21,703,236 10 CDBG19 Schiller Drive Road Reconstruction(CDBG) 29,000 0 0 0 $ 29,000 SD2001 Sidewalk Rehabilitation and Replacement Project(2020) 50,000 0 0 0 $ 50,000 11 ST1801 Smithfield Middle School Safe Routes to School(NCTCOG Grant) 263,921 0 0 0 $ 263,921 ST1902 Street Assessment Project 140,000 0 0 0 $ 140,000 12 ST1901 TEXRail Signal Timing Coordination 100,000 0 0 0 $ 100,000 13 ST1005 Traffic Signalization at Davis Boulevard&Creek View Drive 300,000 0 0 0 $ 300,000 14 ST1701 Vance and Glenview Signal Upgrades 315,862 0 0 0 $ 315,862 Total Continuing Projects $ 39,916,444 $ 3,480,000 $ 0 $ 0 $ 43,396,444 New Projects ST2103 Hightower/Davis Traffic Signal 0 390,000 0 0 $ 390,000 15 ST2101 Iron Horse Boulevard Reconstruction 0 9,120,000 0 0 $ 9,120,000 SM2101 Preventive Street Maintenance(2021) 0 1,000,000 0 0 $ 1,000,000 SD2101 Sidewalk Rehabilitation and Replacement Project(2021) 0 50,000 0 0 $ 50,000 16 ST2102 Transportation Management Project Equipment 0 195,550 0 0 $ 195,550 Total New Projects $ 0 $ 10,755,550 $ 0 $ 0 $ 10,755,550 Total Project Costs $ 39,916,444 $ 14,235,550 $ 0 $ 0 $ 54,151,994 Funding Sources General Obligation Bonds 7,120,000 3,480,000 0 0 $ 10,600,000 Certificates of Obligation 7,625,000 2,215,000 0 0 $ 9,840,000 Federal/State Grants 19,539,927 7,295,000 0 0 $ 26,834,927 Reserves 4,951,517 1,245,550 0 0 $ 6,197,067 Other 680,000 0 0 0 $ 680,000 15 Schedule 1 Street & Sidewalk Capital Projects Budget Summary Project To 2020/21 2021/22 2022 To Total Date Proposed Estimated Completion Total Sources of Funds $ 39,916,444 $ 14,235,550 $ 0 $ 0 $ 54,151,994 16 NItH Street&Sidewalk Capital Projects Department Project Title Project Number Public Works Glenview Drive East Project ST2006 Project Description The project consists of engineering and construction of approximately 2,700 linear feet of Glenview Drive from Boulevard 26 to Flory Street. The improvements include reconstructing the existing roadway with reinforced concrete, including the addition of sidewalks. The road will be rebuilt to its current width; this is not a roadway expansion. Project Justification Glenview Drive is a minor arterial in the City's roadway network, and this portion of the roadway carries over 25,000 vehicles per day. The current pavement condition rating is 25.2 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. In the 2019 Citizen's Survey, Glenview Drive was street that received the highest number of mentions in response to the question of which streets are in most need of repair. Funding Source: 2003 GO Bonds. Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services 07/2020 11/2021 Revision 2019-20 $380,000 Engineering/Design Proposed 2020-21 $3,480,000 Land/ROW Acquisition Total $3,860,000 Construction 12/2021 08/2023 Other Total Schedule 07/2020 08/2023 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds 380,000 3,480,000 0 0 $3,860,000 Certificates of Obligation Federal/State Grants Reserves 0 0 0 0 $0 Sales Tax Other Total Funding $380,000 $3,480,000 $0 $0 $3,860,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services 380,000 0 0 0 $380,000 Engineering/Design Land/ROW Acquisition Construction 0 3,480,000 0 0 $3,480,000 Other Total Costs $380,000 $3,480,000 $0 $0 $3,860,000 Operating Impact No impact anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 18 Street&Sidewalk Capital Projects Department Project Title Project Number Public Works Hightower/ Davis Traffic Signal ST2103 Project Description The project consists of engineering and construction of a new traffic signal at the intersection of Davis Boulevard and Hightower Drive. The scope includes coordination with TxDOT, paving and signal improvements. Project Justification The Hightower/ Davis intersection serves a large residential area east of Davis, yet as an unsignalized intersection is difficult to navigate during peak times. As a result, not only is the intersection highly inefficient, but it also results in more local traffic using the signal at Rumfield to access southbound Davis, contributing to heavy delays at that location as well. In 2018 a traffic engineering study performed at this location indicated that a traffic signal was warranted under current conditions. With the future extension of Hightower to both the east and west, even more motorists will use this intersection in the future. Note: Project funding source is Certificates of Obligation. Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services 11/2020 05/2021 Proposed 2020-21 $390,000 Engineering/Design Total $390,000 Land/ROW Acquisition Construction 06/2021 12/2021 Other Total Schedule 11/2020 12/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation 0 390,000 0 0 $390,000 Federal/State Grants Reserves Sales Tax Other Total Funding $0 $390,000 $0 $0 $390,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services 0 90,000 0 0 $90,000 Engineering/Design Land/ROW Acquisition Construction 0 300,000 0 0 $300,000 Other Total Costs $0 $390,000 $0 $0 $390,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-25 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 19 Street&Sidewalk Capital Projects Department Project Title Project Number Public Works Iron Horse Boulevard Reconstruction ST2101 Project Description Reconstruct a 1.2 mile stretch of Iron Horse Boulevard from York Street to Browning Drive. The project replaces the current asphalt with concrete roadway, in addition to curb, gutter, sidewalks, raised medians and drainage. Current road coniditon is poor and is critical road used by Prestige Ameritech, ESNA Aerospace and Tyson Prepared Foods. Project Justification A 2020 Capital Program Advisory Committee evaluated the city's infrastructure needs and due to poor road conditions, recommended that Iron Horse Boulevard be reconstructed. The Committee considered several factors when recommending street projects including existing pavement conditions, traffic volumes, maintenance records, input from citizens surveys and estimated costs. Funding: Funding for this project is proposed from Certificates of Obligation and from the Economic Adjustment Assitance Program under the Cares Act. Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services 12/2020 10/2022 Proposed 2020-21 $9,120,000 Engineering/Design 12/2020 06/2021 Total $9,120,000 Land/ROW Acquisition Construction 09/2021 09/2022 Other 12/2020 10/2022 Total Schedule 12/2020 10/2022 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation 0 1,825,000 0 0 $1,825,000 Federal/State Grants 0 7,295,000 0 0 $7,295,000 Reserves Sales Tax Other Total Funding $0 $9,120,000 $0 $0 $9,120,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services 0 136,800 0 0 $136,800 Engineering/Design 0 793,440 0 0 $793,440 Land/ROW Acquisition Construction 0 7,122,720 0 0 $7,122,720 Other 0 1,067,040 0 0 $1,067,040 Total Costs $0 $9,120,000 $0 $0 $9,120,000 Operating Impact Not applicable. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-25 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 20 Street&Sidewalk Capital Projects Department Project Title Project Number Public Works Preventive Street Maintenance(2021) SM2101 Project Description This is the annual program where funds are dedicated to enhance the city's efforts for preventive maintenance of city streets. The scope of this project provides crack sealing for approximately 15-25 streets, slurry seal for 15-25 streets, asphalt microsurface for 5- 10 streets and a 2 inch asphalt overlay for 12-15 streets. In addition to these four maintenance methods we have incorporated concrete crack sealing for 15-25 streets and concrete street partial pavement replacement for 10-20 streets. The Pavement Assessment report from 2019 will provide the recommendations the list of streets for this year's program. Project Justification Preventive maintenance activities delays more costly street reconstruction and extends the life of the current street system. This project provides staff with funding to apply the appropriate maintenance activities to the streets selected for the program. Depending on the current condition of the street and the type of preventive measures taken, the street life can be extended for a minimum cost in comparison to a total reconstruction. Note: Project funding source is the General Fund (001). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $1,000,000 Engineering/Design Total $1,000,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 1,000,000 0 0 $1,000,000 Sales Tax Other Total Funding $0 $1,000,000 $0 $0 $1,000,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 1,000,000 0 0 $1,000,000 Other Total Costs $0 $1,000,000 $0 $0 $1,000,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 21 Street&Sidewalk Capital Projects Department Project Title Project Number Public Works Sidewalk Rehabilitation and Replacement Project(2021) SD2101 Project Description This project provides for rehabilitation of the city's sidewalk system. Funding will allow for the replacement of approximately 7,000 square feet of deteriorated sidewalks in residential and high pedestrian areas. Project Justification One of the city's goals is to revitalize some of the"older"sections of the city. This sidewalk rehabilitation is an excellent way to improve the older neighborhoods. This project would allow for staff to address numerous citizen initiated requests utilizing our 50/50 cost sharing program to provide sidewalk rehabilitation in their neighborhoods. The department has identified various locations throughout the city that are in need of sidewalk replacement which include the areas of Stoney Ridge Addition (east of Davis off of Hightower) and the area south of Dick Lewis Drive near Richland High School. This project will allow staff the funding to begin making necessary repairs to these locations. Note: Project funding source is the General Fund (001). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $50,000 Engineering/Design Total $60,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 50,000 0 0 $60,000 Sales Tax Other Total Funding $0 $60,000 $0 $0 $60,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 50,000 0 0 $60,000 Other Total Costs $0 $60,000 $0 $0 $60,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-25 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 22 Street&Sidewalk Capital Projects Department Project Title Project Number Public Works Transportation Management Project Equipment ST2102 Project Description This project will build on the Traffic Management Project approved in the 2019-20 CIP budget by upgrading ten intersections to be compatible with our new central synchronization software: 1) Rufe Snow: (Meadow Lakes, Loop 820, Tapp, Dick Lewis, Iron Horse, Starnes), 2)Mid-Cities: Iron Horse, Holiday 3) Davis Blvd.: College Circle, Emerald Hills The new equipment includes controllers, vehicle detectors and communications systems. The plan is to systematically upgrade existing traffic signals each year until the entire transportation system is connected and complete. Project Justification One of the goals of the Traffic Division is to have the safest and most effective and efficient transportation system. With the implementation of the new central synchronization software the Traffic Divisions goal is to expand the boundaries from the initial project to better serve the residents of North Richland Hills. This system will operate using engineer-designed timing plans that are the basis for the traffic signal coordination. The software and equipment working in concurrence has the ability to communicate with the Service Center and Traffic Technicians alerting them by email or text message of a malfunctioning traffic signal, which will reduce signal malfunction down time and delays to motorists. Currently the only way Public Works is notified of a malfunction is by a resident making a report or City staff member observes it during their shift. The program also has the capabilities to collect traffic data, which will be used to establish timing plans along these cooridors based on actual demand to address traffic flow and congestion concerns. Note: Project funding source is the Street Reserves. Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $195,550 Engineering/Design Total $196,550 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 195,550 0 0 $196,550 Sales Tax Other Total Funding $0 $196,550 $0 $0 $196,550 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 195,550 0 0 $196,550 Other Total Costs $0 $196,550 $0 $0 $196,550 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-25 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 23 Schedule 2 Drainage Capital Projects Budget Summary Project To 2020/21 2021/22 2022 To Total Date Proposed Estimated Completion Project Costs Continuing Projects 1 DR2004 Big Fossil Creek Flood Study-BFC7 120,000 0 0 0 $ 120,000 2 DR1503 Calloway Branch Channel Repair Project 1,446,258 0 0 0 $ 1,446,258 3 DR1901 Emerald Circle Drainage Project 130,000 0 0 0 $ 130,000 4 DR2005 Mackey Creek Flood Study 120,000 0 0 0 $ 120,000 5 DR2002 North Hills Addition-Bewley Drive Drainage Improvements 65,000 0 0 0 $ 65,000 DR2003 Street Drainage Improvements Project(2020) 100,000 0 0 0 $ 100,000 6 DR1701 Walker Branch Channel Repair(200ft South of Harwood Road) 307,850 0 0 0 $ 307,850 Total Continuing Projects $ 2,289,108 $ 0 $ 0 $ 0 $ 2,289,108 New Projects DR2103 Channel Cleaning/Street Drainage Improvements 0 100,000 0 0 $ 100,000 DR2102 Concrete Lined Channel Rehabilitation Project 0 250,000 0 0 $ 250,000 DR2101 Street Drainage Improvements Project(2021) 0 100,000 0 0 $ 100,000 Total New Projects $ 0 $ 450,000 $ 0 $ 0 $ 450,000 Total Project Costs $ 2,289,108 $ 450,000 $ 0 $ 0 $ 2,739,108 Funding Sources Reserves 2,289,108 450,000 0 0 $ 2,739,108 Total Sources of Funds $ 2,289,108 $ 450,000 $ 0 $ 0 $ 2,739,108 24 NItH Drainage Capital Projects Department Project Title Project Number Public Works Channel Cleaning/Street Drainage Improvements DR2103 Project Description This is a recurring program that consists of cleaning out sediment that has built up over time in some of the City's earthen channels. This project also consists of repairing curb&gutter sections that currently pond water in existing streets. Project Justification The sediment removal will help re-establish the flow capacity of the earthen channels. This work is necessary to meet the requirements of the City's Flood Damage Protection Ordinance(#2061). Removal of the silt will improve capacity of the channels and will help eliminate flooding of properties along the channels. In addition, City staff receives numerous calls and complaints every year concerning the ponding of water along gutter lines in front of the homes of residents. This project will provide staff the funding to correct these problems. This program has been very successful with residents who have standing water problems. We have approximately 60 streets in the City that have standing water problems at this time. Note: Project funding source is the Drainage Utility Fund (120). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $100,000 Engineering/Design Total $100,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 100,000 0 0 $100,000 Sales Tax Other Total Funding $0 $100,000 $0 $0 $100,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 100,000 0 0 $100,000 Other Total Costs $0 $100,000 $0 $0 $100,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 26 Drainage Capital Projects Department Project Title Project Number Public Works Concrete Lined Channel Rehabilitation Project DR2102 Project Description This project involves ongoing rehabilitation of the City's seven (7) miles of concrete lined channels. The scope of the project will include repairing areas of channel that have deteriorated, cracked, dropped, collapsed, heaved, or hold water due to heavy ground movement and/or age. The needed repairs include patching of channel walls and channel bottoms, replacing wall sections, and replacing channel bottom sections to ensure proper drainage. The intent is to utilize$250,000 in funding every other year to arrive at a total project amount of$1,000,000 over seven years. Project Justification Concrete channels are designed to transport storm water run off during rain events. When these channels have areas of deteriorated concrete channel liner, flowing water has the ability to penetrate the concrete subgrade, which undermines the integrity of the channel and poses a threat to public and private property. Some areas in the concrete channels hold extensive amounts of water because of deterioration that has occurred, which becomes a breeding ground for mosquito larvae and raises citizen concern. These types of repairs cannot be made within the current General Fund operating budget. The repairs are specialized and must be done by private sources. No engineering work is expected for this project. Note: Project funding source is the Drainage Utility Fund (120). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $250,000 Engineering/Design Total $260,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 250,000 0 0 $260,000 Sales Tax Other Total Funding $0 $260,000 $0 $0 $260,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 250,000 0 0 $260,000 Other Total Costs $0 $260,000 $0 $0 $260,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-25 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 27 Drainage Capital Projects Department Project Title Project Number Public Works Street Drainage Improvements Project (2021) DR2101 Project Description This project consists of addressing a portion of the numerous non-grade standing water requests Public Works receives each year. This would be accomplished by removing and replacing curb and gutter systems to an adequate grade that provides positive drainage along City streets. Creating positive drainage along streets can sometimes require drive approaches and sidewalks to be replaced as well to accommodate the new grade. When this project was initially approved the list of streets to be repaired was 193 locations at the cost of$640,000, the current list is comprised of 159 locations at the cost of$543,682. This project would be considered an annual project until such time as the list of requests is completed or until the list can be accomplished within the operating budget. Project Justification The Public Works Department receives numerous citizen request for non-grade standing water problems along City streets each year. These requests are repaired in the order in which they are received unless the severity of the grade causes a public safety issue. Within our operating budget there are only so many requests we can complete due to budget constraints. Thus leaving numerous repairs remaining on our list each year. Standing water along City streets contributes to premature deterioration of asphalt, provides an environment for breeding mosquitos which causes a public health issue and is unsightly and concerning to residents that live near it. Note: Project funding source is the Drainage Utility Fund (120). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $100,000 Engineering/Design Total $100,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 100,000 0 0 $100,000 Sales Tax Other Total Funding $0 $100,000 $0 $0 $100,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 100,000 0 0 $100,000 Other Total Costs $0 $100,000 $0 $0 $100,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 28 Schedule 3 Utility Capital Projects Budget Summary Project To 2020/21 2021/22 2022 To Total Date Proposed Estimated Completion Project Costs Continuing Projects 1 UT2004 Big Fossil 24"Interceptor 1,255,000 0 0 0 $ 1,255,000 2 UT1801 Assess and Repair 16-inch Water Transmission Main 500,000 0 0 0 $ 500,000 UT0201 Big Fossil Creek Wastewater Outfall 1,231,604 0 0 0 $ 1,231,604 3 UT1701 College Hill Ground Storage Tank Stand Pipe 85,000 0 0 0 $ 85,000 4 UT2008 Conn Pump Station Pump and Electrical Rehabilitation 1,500,000 0 0 0 $ 1,500,000 5 UT1601 Franklin Court Sewer Addition and Gifford Connection 150,000 0 0 0 $ 150,000 6 CDBG20 Garwood Drive Sanitary Sewer(CDBG) 15,000 0 0 0 $ 15,000 7 UT1402 Johnson Pump Station Component and Infrastructure Replacements 275,000 0 0 0 $ 275,000 8 UT1901 Large Valve Replacement Project 95,000 0 0 0 $ 95,000 9 UT1902 Main/Snider/Center Utility Project 225,000 0 0 0 $ 225,000 10 UT2002 Miscellaneous Water/Sewer Main Replacement(2020) 445,000 0 0 0 $ 445,000 11 UT1404 Motor Operated Transfer Valves 730,000 0 0 0 $ 730,000 UT1703 Sanitary Sewer System Rehabilitation(Various Locations) 150,000 0 0 0 $ 150,000 12 UT1704 Sanitary Sewer System Trunk Line Rehabilitation 98,120 0 0 0 $ 98,120 UT2010 Sewer Impact Fee Project 21,000 0 0 0 $ 21,000 UT1904 Sewer Manhole Replacement and Rehabilation Project 150,000 0 0 0 $ 150,000 13 UT1705 Small Water Main Replacements(2017) 420,000 0 0 0 $ 420,000 14 UT1905 Small Water Main Replacements(2019) 435,011 0 0 0 $ 435,011 15 UT2001 Small Water Main Replacements(2020) 440,000 0 0 0 $ 440,000 UT1906 Telemetric Water Meter Annual Maintenance(2019) 400,000 0 0 0 $ 400,000 UT2003 Telemetric Water Meter Annual Maintenance(2020) 400,000 0 0 0 $ 400,000 UT2006 Utility Risk and Resiliency Assessment 150,000 0 0 0 $ 150,000 16 UT1607 Walker Branch Interceptor Project 6,016,525 0 0 0 $ 6,016,525 UT2009 Water Impact Fee Project 21,000 0 0 0 $ 21,000 17 UT0810 Western Center Water Facility Expansion 55,000 0 0 0 $ 55,000 Total Continuing Projects $ 15,263,260 $ 0 $ 0 $ 0 $ 15,263,260 New Projects 18 UT2107 Automatic Control Valve(ACV)Replacement 0 135,000 0 0 $ 135,000 19 UT2106 College Hills Ground Storage Tank Rehabilitation 0 840,000 0 0 $ 840,000 20 CDBG21 Matson Drive Sanitary Sewer 0 15,000 0 0 $ 15,000 21 UT2102 Miscellaneous Water/Sewer Main Replacement(2021) 0 462,453 0 0 $ 462,453 UT2105 SCADA Communication Replacement 0 75,000 0 0 $ 75,000 UT2104 Sewer Manhole Replacement and Rehabilitation Project(2021) 0 250,000 0 0 $ 250,000 22 UT2101 Small Water Main Replacements(2021) 0 462,453 0 0 $ 462,453 UT2103 Telemetric Water Meter Annual Maintenance(2021) 0 400,000 0 0 $ 400,000 Total New Projects $ 0 $ 2,639,906 $ 0 $ 0 $ 2,639,906 29 Schedule 3 Utility Capital Projects Budget Summary Project To 2020/21 2021/22 2022 To Total Date Proposed Estimated Completion Total Project Costs $ 15,263,260 $ 2,639,906 $ 0 $ 0 $ 17,903,166 Funding Sources Certificates of Obligation 9,429,735 840,000 0 0 $ 10,269,735 Reserves 2,833,525 1,799,906 0 0 $ 4,633,431 Other 3,000,000 0 0 0 $ 3,000,000 Total Sources of Funds $ 15,263,260 $ 2,639,906 $ 0 $ 0 $ 17,903,166 30 NItH Utility Capital Projects Department Project Title Project Number Public Works Automatic Control Valve(ACV) Replacement UT2107 Project Description This project will replace the six automatic control valves (ACV) at Watauga Pump Station. These six valves include: 3- 10 inch valves and 3-6 inch valves. The ACV's are a vital component in the process of providing adequate pressure and quantity in the water distribution system that serves both the City of North Richland Hills and the City of Watauga. The ACV's main purposes are: eliminating pressure spikes, back siphonage, and controlling the flow of water from the pump. The valves are located on the effluent side of the six pumps before the discharge header. Project Justification The Watauga Pump Station provides roughly 814 million gallons of water to the citizens of North Richland Hills and Watauga. Due to the age of these valves, repairs have become more frequent to the AVCs and repairs are made by specialized contractors. Parts for the valves have become more difficult to find and are causing longer out of service periods. When the valve is out of service, the pump that is associated with the valve is also out of service. Without the AVC, the pump will over amp causing a pump failure. Staff does not have the training nor the expertise to perform repairs to the ACV. Note: Project funding source is the Utility Fund (405). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $135,000 Engineering/Design Total $136,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 135,000 0 0 $136,000 Sales Tax Other Total Funding $0 $136,000 $0 $0 $136,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 135,000 0 0 $136,000 Other Total Costs $0 $136,000 $0 $0 $136,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-25 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 32 Utility Capital Projects Department Project Title Project Number Public Works College Hills Ground Storage Tank Rehabilitation UT2106 Project Description This project will rehabilitate the College Hills Ground Storage Tank. This will include preparing the exterior and interior of the tank to apply new paint on both surfaces. Additional work will include: installing pipe screen at overflow, installing a ladder gate, installing a new hatch on the roof, installing a new vent, repairing the float system, caulk and seal at the foundation, install a new safety climb system, and remove the existing interior ladder. Project Justification College Hills Ground Storage Tank was built in 1991. This tank stores the largest capacity of water in the system at five million gallons. With it's location and capacity it is very critical to the entire distribution system. Over the last 28 years, this tank has not had a total rehab applied to the tank. The exterior and interior coatings have performed very well during this time. During the installation of the Pax mixer in the tank, staff was able to inspect the interior of the tank. Rust and corrosion have started to form in different locations inside the tank. Industry standards typically recommend having the exterior and interior coatings reapplied between 10- 12 years. Note: Project funding source is Certificates of Obligation. Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services 10/2020 05/2022 Proposed 2020-21 $840,000 Engineering/Design Total $840,000 Land/ROW Acquisition Construction 11/2021 06/2022 Other Total Schedule 10/2020 06/2022 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation 0 840,000 0 0 $840,000 Federal/State Grants Reserves Sales Tax Other Total Funding $0 $840,000 $0 $0 $840,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services 0 140,000 0 0 $140,000 Engineering/Design Land/ROW Acquisition Construction 0 700,000 0 0 $700,000 Other Total Costs $0 $840,000 $0 $0 $840,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 33 Utility Capital Projects Department Project Title Project Number Public Works Matson Drive Sanitary Sewer CDBG21 Project Description This is the 46th Year Community Development Block Grant(CDBG) Project. The project will consist of reconstructing approximately 1,300 linear feet of sanitary sewer main. Project Justification The existing vitrified clay sanitary sewer main serving the residents on the west side of Matson Drive and the east side of US 377 is in poor condition and requires significant maintenance as it continues to deteriorate. Note: The Federal /State Grant Funds shown in the"Sources of Funds" are CDBG entitlement funds, which are administered entirely by Tarrant County. This includes design, ultimate contractor selection, construction management and contract close-out activities. As with all previous CDBG projects, the City will have to provide construction inspection services. No CDBG funds are administered by the City; all funds remain with Tarrant County. The City funds budgeted for in this project are from the Utility Fund Reserves (405). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services 10/2020 02/2021 Proposed 2020-21 $15,000 Engineering/Design Total $16,000 Land/ROW Acquisition Construction 03/2021 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 15,000 0 0 $16,000 Sales Tax Other Total Funding $0 $16,000 $0 $0 $16,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 15,000 0 0 $16,000 Other Total Costs $0 $16,000 $0 $0 $16,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-25 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 34 Utility Capital Projects Department Project Title Project Number Public Works Miscellaneous Water/Sewer Main Replacement(2021) UT2102 Project Description This is an annual program that is performed by the Public Works Construction Division. The program will provide for the construction of water and wastewater main replacements to include possible development projects. The project replaces the aging and undersized water and wastewater infrastructure. This year's scope is expected to include water/sewer main replacements on the following streets: Edinburg Drive(Brookshire to Wakefield), Circle Drive (Susan Lee to Cul-de-sac), Bogart(College Circle to Price), Spring Lea Way (Starnes to Lincoln) and Southampton Drive(Wakefield to Chapman). Project Justification The specific projects are selected based on factors such as ongoing maintenance cost, location of infrastructure, pipe material, and diameter of water and wastewater mains. This project provides for the retirement of existing water lines which continue to cause a decrease in system capacity and water quality. This project also replaces the aging wastewater mains that require significant maintenance and increased operating costs. The construction of these lines is completed by the Public Works Construction Division. In addition to the replacement of existing lines, the City's Construction Division also has the capability to handle water and wastewater extensions to support lot development, with the costs of those extensions borne by the land owner or developer. This has been particularly helpful for property owners who cannot afford the upcharge levied by contractors for such small projects. Note: Project funding source is the Utility Fund (405). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $462,453 Engineering/Design Total $462,463 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 462,453 0 0 $462,463 Sales Tax Other Total Funding $0 $462,463 $0 $0 $462,463 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 462,453 0 0 $462,463 Other Total Costs $0 $462,463 $0 $0 $462,463 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 35 Utility Capital Projects Department Project Title Project Number Public Works SCADA Communication Replacement UT2105 Project Description The Utility Division uses a Supervisory Control and Data Acquisition (SCADA) system to remotely monitor, make adjustments, and track trends within the water and wastewater system. Project Justification The City's SCADA system currently monitors four ground water storage tanks, five elevated storage tanks, five pump stations, three subtraction meters, two pressure reducing valves, and two wastewater lift stations. Staff receives communication back to the central computer via radio frequency. On a daily basis, radio interference creates disruptions in this communication. This radio interference can last five minutes up to 8 hours creating an unstable network. Moving to a cellular network would create a stable network of communication for the entire system. The SCADA system includes locations outside of the city limits. We have locations in Fort Worth (121 metering station), Haltom City (Stanley Keller Pump Station) and Watauga (Watauga Ground Storage Tank and Watauga Elevated Storage Tank). Communication with these sites and the sites located in the city is very critical to the reliability of the water and wastewater system. Note: Project funding source is the Utility Fund (405). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $75,000 Engineering/Design Total $76,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 75,000 0 0 $76,000 Sales Tax Other Total Funding $0 $76,000 $0 $0 $76,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 75,000 0 0 $76,000 Other Total Costs $0 $76,000 $0 $0 $76,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-25 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 36 Utility Capital Projects Department Project Title Project Number Public Works Sewer Manhole Replacement and Rehabilitation Project(2021) UT2104 Project Description This project will replace or rehabilitate roughly 150 wastewater manholes throughout the City. Staff has completed an inspection of approximately 5,500 manholes. Through this inspection process, it has been identified that 12% of the manholes (approximately 660) need some form of replacement or rehabilitation. This project will be spread out over a 5 year period to complete all 660 manholes. Project Justification Through the inspection process of the wastewater manholes, staff assessed each manhole on overall structural condition, maintenance responsibility, and inflow/infiltration present. Each manhole was given a numerical grade on structural and maintenance condition, with inflow/infiltration being noted as observed or being present. All manholes were inspected by one staff member so grading would be consistent among all manholes. The manholes that makeup the 660 that need attention were graded poor and very poor. The majority of these manholes also were noted to have inflow/infiltration. Inflow/infiltration in the wastewater system causes many difficulties for the system. With rain events, the inflow/infiltration allows rainwater into the system causing capacity issues with the possibility of creating sanitary sewer overflows. The additional rainwater also creates additional wastewater flow to the treatment plants, which the City pays for in wastewater charges from the treatment plants. Brick manholes are a major factor with allowing inflow/infiltration into the wastewater system. Brick manholes are no longer a method of building manholes. The Department has identified three different rehabilitation techniques for this project. Each technique brings value to the project based on the need of the manhole that needs repair. The three techniques include: total reconstruction, cured-in-place fiberglass manhole liner, and sprayed epoxy manhole liner. After completion of the rehabilitation process of a manhole, the system will experience less inflow/infiltration due to rainwater and have less risk of a major wastewater issue resulting from a manhole collapse. Note: Project funding source is the Utility Fund (405). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $250,000 Engineering/Design Total $260,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 250,000 0 0 $260,000 Sales Tax Other Total Funding $0 $260,000 $0 $0 $260,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 250,000 0 0 $260,000 Other Total Costs $0 $260,000 $0 $0 $260,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-25 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 37 Utility Capital Projects Department Project Title Project Number Public Works Small Water Main Replacements (2021) UT2101 Project Description This is an annual program that is performed by the Public Works Construction Division. The program replaces old 2" and 4"water mains with 6" or larger diameter water pipes. This project provides adequate fire hydrant coverage to areas currently without proper coverage. This project will be expected to provide water main replacement on the following streets: Circleview Drive(Lariat to Shady Lake), Davis Boulevard (Woods to Bursey),Meadowbrook Drive (Royal Ridge to Brookridge), and Woodcreek Lane(Lariat to Riviera). Project Justification The specified project replaces aging utility infrastructure, specifically 2" and 4"water mains with new 6" or larger water mains. The program also provides adequate fire hydrant coverage to areas currently without proper coverage, this is due to the installation of larger diameter mains. Which increases fire protection with the new installation of water hydrants, not previously allowed on smaller diameter mains. In addition, this project replaces water mains that have had an abundance of main breaks, resulting in significant annual maintenance and increased operating cost. The construction of these mains is completed by the Public Works Construction Division. Note: Project funding source is the Utility Fund (405). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $462,453 Engineering/Design Total $462,463 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 462,453 0 0 $462,463 Sales Tax Other Total Funding $0 $462,463 $0 $0 $462,463 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 462,453 0 0 $462,463 Other Total Costs $0 $462,463 $0 $0 $462,463 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 38 Utility Capital Projects Department Project Title Project Number Public Works Telemetric Water Meter Annual Maintenance(2021) UT2103 Project Description The Telemetric Water Annual Maintenance Program allows the City to continue replacing some of the transponder units and meters installed 10 years ago. The new transponder units transmit meter information to a mobile receiver or fixed network reducing and eventually eliminating the need for manual readings. Each meter with a transponder costs$285 to replace and the City replaces roughly 1,300 per year. Project Justification This program allows the City to replace transponder and meter units that were installed at the program's inception in 1992-1993. The program includes replacement of the Orion Classic Endpoint(CE)water meters with lead-free Smart Endpoints (SE)water meters for use in fixed network or mobile reading deployments. Note: Project funding source is the Utility Fund (405). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $400,000 Engineering/Design Total $400,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 400,000 0 0 $400,000 Sales Tax Other Total Funding $0 $400,000 $0 $0 $400,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 400,000 0 0 $400,000 Other Total Costs $0 $400,000 $0 $0 $400,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 39 Schedule 4 Parks & Recreation Capital Projects Budget Summary Project To 2020/21 2021/22 2022 To Total Date Proposed Estimated Completion Project Costs Continuing Projects 1 PK2007 Fossil Creek Park Mountain Bike Trails 120,000 0 0 0 $ 120,000 2 PK1801 Green Valley Raceway Historical Area 110,717 0 0 0 $ 110,717 3 GC1901 Iron Horse Golf Course Improvements 3,385,000 0 0 0 $ 3,385,000 4 PK1902 Linda Spurlock Park Renovation 1,035,000 0 0 0 $ 1,035,000 5 PK1903 NRH Centre Indoor Aquatic Pool Re-Plaster 120,000 0 0 0 $ 120,000 PK2004 Park Infrastructure Maintenance(2020) 164,954 0 0 0 $ 164,954 PK1506 Park Infrastructure Maintenance 2015 232,597 0 0 0 $ 232,597 PK1804 Park Infrastructure Maintenance 2018 301,905 0 0 0 $ 301,905 PK1904 Park Infrastructure Maintenance 2019 275,953 0 0 0 $ 275,953 PK1606 Park System Signage 474,486 0 0 0 $ 474,486 6 PK2005 Richland Tennis Center Infrastructure Improvements(2020) 100,000 0 0 0 $ 100,000 7 PK1905 Richland Tennis Center Infrastructure Maintenance 2019 20,000 0 0 0 $ 20,000 PK1806 Trail and On-Road Safety Projects 735,543 0 0 0 $ 735,543 Total Continuing Projects $ 7,076,155 $ 0 $ 0 $ 0 $ 7,076,155 New Projects 8 PK2101 Annual Tree Planting(2021) 0 83,000 0 0 $ 83,000 9 PK2108 NRH Centre Fitness Equipment Replacement 0 120,000 0 0 $ 120,000 10 PK2107 NRH Centre Grand Hall AV Projectors Replacement 0 20,000 0 0 $ 20,000 PK2104 Park Infrastructure Maintenance(2021) 0 144,000 0 0 $ 144,000 11 PK2105 Richfield Park Tennis/Pickleball Court Replacement 0 265,000 0 0 $ 265,000 12 PK2106 Richland Tennis Center Infrastructure Maintenance(2021) 0 32,000 0 0 $ 32,000 Total New Projects $ 0 $ 664,000 $ 0 $ 0 $ 664,000 Total Project Costs $ 7,076,155 $ 664,000 $ 0 $ 0 $ 7,740,155 Funding Sources Certificates of Obligation 3,285,000 0 0 0 $ 3,285,000 Federal/State Grants 576,217 0 0 0 $ 576,217 Reserves 1,430,043 140,000 0 0 $ 1,570,043 Sales Tax 1,684,895 176,000 0 0 $ 1,860,895 Other 100,000 348,000 0 0 $ 448,000 Total Sources of Funds $ 7,076,155 $ 664,000 $ 0 $ 0 $ 7,740,155 40 NItH Parks & Recreation Capital Projects Department Project Title Project Number Parks and Recreation Annual Tree Planting (2021) PK2101 Project Description This project provides for the introduction of trees into the urban forest and replacement of trees that have died at various locations throughout the City. The project involves the installation of 3"caliper, drought tolerant, native or adapted trees. Park facilities to receive trees includes Linda Spurlock Park, Walker's Creek Park and Iron Horse Golf Course. The project includes mitigation replacement of 20 trees removed during installation of a major sanitary sewer line. At Iron Horse Golf Course, 30 trees will be planted along the north side of Loop 820 to improve course aesthetics, also functioning to control trash/debris inundating the course from the highway. Project Justification The urban forest is an important part of the City's landscape. It's made up of all the public trees in North Richland Hills. Trees add to the wellbeing of our community by moderating our local climate, filtering air pollutants, storing storm water and reducing run-off, raising property values, and provides years of beauty and stress relief. This project allows for the continued maintenance and growth of our urban forest through the introduction of native or adapted trees at focusing on restoration of areas having undergone recent construction activities. Note: Project funding source is the Mitigation Proceeds/Parks Development Program Fund (Tree Mitigation). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $83,000 Engineering/Design Total $83,000 Land/ROW Acquisition Construction 10/2020 03/2021 Other Total Schedule 10/2020 03/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves Sales Tax Other 0 83,000 0 0 $83,000 Total Funding $0 $83,000 $0 $0 $83,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 83,000 0 0 $83,000 Other Total Costs $0 $83,000 $0 $0 $83,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 42 Parks & Recreation Capital Projects Department Project Title Project Number Parks and Recreation NRH Centre Fitness Equipment Replacement PK2108 Project Description This project provides replacement of fitness equipment at the NRH Centre. In 2020-2021 the identified equipment to be replaced includes: spin bikes, recumbent bikes, upright bikes, and treadmills. Project Justification Assessment of all cardio, machine weight and free weight equipment is completed by staff during bi-weekly routine preventative maintenance. Staff tracks when repairs are made throughout the year on each piece of equipment. Equipment identified as aging out through usage, antiquated technology, or through frequency of repair is tagged as a potential replacement item. The need to replace fitness equipment annually provides updates to older equipment and reduces the frequency of repairs. Note: Project funding source is NRH Centre Reserves (126). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $120,000 Engineering/Design Total $120,000 Land/ROW Acquisition Construction Other 10/2020 09/2021 Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 120,000 0 0 $120,000 Sales Tax Other Total Funding $0 $120,000 $0 $0 $120,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction Other 0 120,000 0 0 $120,000 Total Costs $0 $120,000 $0 $0 $120,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 43 Parks & Recreation Capital Projects Department Project Title Project Number Parks and Recreation NRH Centre Grand Hall AV Projectors Replacement PK2107 Project Description This project provides replacement of two AV projectors, one in Ballroom B and one in Ballroom C of the Grand Hall at the NRH Centre. The project includes replacing the eight year old originally installed AV projectors with new 8k lumen laser projectors designed to work better with existing artificial and natural room lighting while also providing much clearer images than current projectors that were installed when the NRH Centre opened in April 2012. Project Justification With the frequent and increased usage of the Grand Hall including clients regularly utilizing the AV system; the original existing AV Projectors are in need of replacement. Clients utilizing the in-house AV equipment are charged for use of the equipment. This charge includes use of microphones, projectors, audio, and screens. Note: Project funding source is NRH Centre Reserves (126). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $20,000 Engineering/Design Total $20,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 20,000 0 0 $20,000 Sales Tax Other Total Funding $0 $20,000 $0 $0 $20,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 20,000 0 0 $20,000 Other Total Costs $0 $20,000 $0 $0 $20,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 44 Parks & Recreation Capital Projects Department Project Title Project Number Parks and Recreation Park Infrastructure Maintenance(2021) PK2104 Project Description This project provides for maintenance of park infrastructure in response to use and age. The FY2021 priorities include playground fall safe material, playground equipment replacement, sports field restoration, concrete panel replacement, drinking fountain replacement, and North Electric Trail bridge deck repairs. Project Justification The Parks and Recreation Department developed an Infrastructure Management Plan for park amenities. The plan addresses long term funding needs for replacement and renovation of park sites and their amenities, demonstrating responsible stewardship of property assets by the city. Park assets are subject to continual heavy usage by citizens, exposure to the elements and the natural aging process. The Asset Management Plan and ongoing park inspections are used to identify assets that have become worn, unsafe or unsightly and to create a priority timeline for their repair, renovation or removal. Funding Source: Park Sales Tax Fund (125). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $144,000 Engineering/Design Total $144,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves Sales Tax 0 144,000 0 0 $144,000 Other Total Funding $0 $144,000 $0 $0 $144,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 144,000 0 0 $144,000 Other Total Costs $0 $144,000 $0 $0 $144,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 45 Parks & Recreation Capital Projects Department Project Title Project Number Parks and Recreation Richfield Park Tennis/Pickleball Court Replacement PK2105 Project Description This project provides for the replacement construction of the Richfield Park tennis court. With more than 40 years in service, significant cracking, birdbaths from settling of the court, net post and center strap issues and general foundation issues no longer permit resurfacing allowing safe play. This project will also include resurfacing the existing tennis court at Green Valley Park. Project Justification The tennis industry states that if a hard court is properly maintained, the average life for it is approximately 25 years. Significant spalling, cracking and foundation movement are presenting uneven surfaces awash with trip hazards that resurfacing will not correct to allow for safe play. This project will include replacing the existing, partially fenced double court with a fully fenced tennis court and 4 fenced pickleball courts. The existing lights will be preserved. Note: Project funding source is Park Impact Fee Reserves. Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services 10/2020 02/2021 Proposed 2020-21 $265,000 Engineering/Design Total $266,000 Land/ROW Acquisition Construction 03/2021 05/2021 Other Total Schedule 10/2020 06/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves Sales Tax Other 0 265,000 0 0 $266,000 Total Funding $0 $266,000 $0 $0 $266,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services 0 25,000 0 0 $26,000 Engineering/Design Land/ROW Acquisition Construction 0 240,000 0 0 $240,000 Other Total Costs $0 $266,000 $0 $0 $266,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 46 Parks & Recreation Capital Projects Department Project Title Project Number Parks and Recreation Richland Tennis Center Infrastructure Maintenance(2021) PK2106 Project Description This project provides for the maintenance of the Richland Tennis Center Infrastructure in response to use and age. The FY2021 funding will provide for replacement of bench seat awnings, relam ping of sports court lighting on all 16 courts, concrete repairs at various locations within the facility. Project Justification The Parks and Recreation Department developed an Infrastructure Management Plan for Richland Tennis Center amenities. The plan addresses long term funding needs for replacement and renovation of tennis center amenities, demonstrating responsible stewardship of property assets by the city. The Tennis Center assets are subject to continual heavy usage, exposure to the elements and the natural aging process. Funding Source is Park Sales Tax(125). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $32,000 Engineering/Design Total $32,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves Sales Tax 0 32,000 0 0 $32,000 Other Total Funding $0 $32,000 $0 $0 $32,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 32,000 0 0 $32,000 Other Total Costs $0 $32,000 $0 $0 $32,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 47 Schedule 5 Aquatic Park Capital Projects Budget Summary Project To 2020/21 2021/22 2022 To Total Date Proposed Estimated Completion Project Costs Continuing Projects WP2001 General Facility Improvements(2020) 100,000 0 0 0 $ 100,000 Total Continuing Projects $ 100,000 $ 0 $ 0 $ 0 $ 100,000 New Projects WP2101 General Facility Improvements(2021) 0 100,000 0 0 $ 100,000 WP2102 Waterpark Security Camera System Improvements and Upgrades 0 25,000 0 0 $ 25,000 Total New Projects $ 0 $ 125,000 $ 0 $ 0 $ 125,000 Total Project Costs $ 100,000 $ 125,000 $ 0 $ 0 $ 225,000 Funding Sources Reserves 100,000 100,000 0 0 $ 200,000 Sales Tax 0 25,000 0 0 $ 25,000 Total Sources of Funds $ 100,000 $ 125,000 $ 0 $ 0 $ 225,000 48 NItH Aquatic Park Capital Projects Department Project Title Project Number Aquatic Park General Facility Improvements (2021) WP2101 Project Description This project consists of costs for annual general facility improvements such as drainage improvements,miscellaneous building improvements, capital acquisitions and any safety improvements or emergency repairs for the facility that are identified during the operating season. Projects in the past have included ADA updates, replacement motors, drainage improvements, concrete repair and patching and resurfacing of numerous park attractions. Project Justification This project is important for emergency items and for general improvements to the park that are not included in the operating budget. Items may include safety items, ride equipment replacement, new initiatives to improve guest service and safety related projects. As the park ages, larger mechanical items will begin to fail due to age and use. This project wil replace end of life items such as AC units, larger kitchen equipment and ride motors and operating systems as needed. As the park lighting systems require replacement due to age, staff is requesting to replace lights with energy efficient LED lighting. This also supports the"Green Initiative"taken by park staff to use the most cost effective and energy efficient materials possible. Due to age, UV exposure and chlorinated water, the fiberglass colors on various park slides are fading and dull. This project will refurbish a portion of the slides with a specialized coating which will improve the colors and lifespan of the attractions. Funding source: Aquatic Park Fund (415). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $100,000 Engineering/Design Total $100,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 100,000 0 0 $100,000 Sales Tax Other Total Funding $0 $100,000 $0 $0 $100,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 100,000 0 0 $100,000 Other Total Costs $0 $100,000 $0 $0 $100,000 Operating Impact Decreases in electric costs with LED lights. Savings on annual expenses as older mechanical items are replaced with newer,more efficient ones. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 50 Aquatic Park Capital Projects Department Project Title Project Number Aquatic Park Waterpark Security Camera System Improvements and Upgrades WP2102 Project Description This project consists of security camera system upgrades and improvements for the waterpark primarily in the areas of the parking lot, entryway and perimeter. This also includes funds for hardware, cabling and other items that are necessary for the camera system upgrades. Project Justification As the park has aged, the original perimeter camera system that was installed on a homeland security grant has begun to break down, become obselete and need repairs/replacements. During this time the land next to the park has seen a vast increase in homes and apartments being built and this in turn has caused more fencejumping by guests as well as more people attempting to enter the park over night. This project is important to help stop this as well as to assist should any potential emergency situations arise out of these occurences. Note: Project funding source is Park Sales Tax(126). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $25,000 Engineering/Design Total $26,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves Sales Tax 0 25,000 0 0 $26,000 Other Total Funding $0 $26,000 $0 $0 $26,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 25,000 0 0 $26,000 Other Total Costs $0 $26,000 $0 $0 $26,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-25 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 51 Schedule 6 Facilities Capital Projects Budget Summary Project To 2020/21 2021/22 2022 To Total Date Proposed Estimated Completion Project Costs Continuing Projects 1 FC2001 Carpet Replacement at the Public Library 321,000 0 0 0 $ 321,000 2 FC2002 Fencing around Fire Training pad 52,000 0 0 0 $ 52,000 3 FC2003 Iron Horse Golf Course Clubhouse Exterior Improvements 43,500 0 0 0 $ 43,500 4 FC1902 Permanent Records Roof Replacement&Building Envelope Seal 71,500 0 0 0 $ 71,500 5 FC1904 Upgrade/Remodel of Public Works'Restrooms 81,500 0 0 0 $ 81,500 Total Continuing Projects $ 569,500 $ 0 $ 0 $ 0 $ 569,500 New Projects 6 FC2104 Concrete Drive Repair at FS#2,FS#5 and Service Center 0 74,400 0 0 $ 74,400 7 FC2101 Replace UPS batteries at City Hall 0 80,000 0 0 $ 80,000 8 FC2102 Roof replacement at FS#1 0 120,000 0 0 $ 120,000 Total New Projects $ 0 $ 274,400 $ 0 $ 0 $ 274,400 Total Project Costs $ 569,500 $ 274,400 $ 0 $ 0 $ 843,900 Funding Sources Certificates of Obligation 320,000 0 0 0 $ 320,000 Reserves 249,500 274,400 0 0 $ 523,900 Total Sources of Funds $ 569,500 $ 274,400 $ 0 $ 0 $ 843,900 52 NItH Facilities Capital Projects Department Project Title Project Number Facilities and Construction Concrete Drive Repair at FS#2, FS#5 and Service Center FC2104 Project Description This request is to replace approximately 6,000 square feet of concrete and subgrade at Firestation#2 ($18,000) and 80' long by 40' wide portion of the concrete drive north of Fire Station#5 ($38,400) and replace approximately 60' long by 25'wide portion of concrete at the Service Center($18,000). Project Justification The concrete drive replacement is due the sub-grade failure from the heavy equipment and trash trucks at these three locations. The F&C Department recommends replacement of the concrete, subgrade compaction, drainage improvements, and sealing. The concrete has deteriorated. Patching the area will only be a temporary solution and continue to deteriorate. Note: Project funding source is the Facilities Fund (505). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $74,400 Engineering/Design Total $74,400 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 74,400 0 0 $74,400 Sales Tax Other Total Funding $0 $74,400 $0 $0 $74,400 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 74,400 0 0 $74,400 Other Total Costs $0 $74,400 $0 $0 $74,400 Operating Impact None Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 54 Facilities Capital Projects Department Project Title Project Number Facilities and Construction Replace UPS batteries at City Hall FC2101 Project Description This request is to replace the(4) sets of Uninterrupted Power Supply (UPS) batteries for the(4)APC units at City Hall ($80,000). Project Justification The batteries located inside the(4)three phase UPS's at City Hall over five years old. The warranty has expired for the batteries and the City is unable to renew the service agreement. Replacement of these batteries on this critical infrastructure is warranted. Several of the original APC batteries failed, and were replaced under warranty with our service agreement at no additional cost. The failure of these batteries is due to their age and usage. Each UPS cabinet holds (36) battery modules. The total number of battery modules to be replaced is (144). In the event of a power outage these batteries carry the load so critical servers and computer equipment does not shut off. They bridge the power gap until the generator synchronizes and transfers power. Note: Project funding source is Facility Services (505). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $80,000 Engineering/Design Total $80,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 80,000 0 0 $80,000 Sales Tax Other Total Funding $0 $80,000 $0 $0 $80,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 80,000 0 0 $80,000 Other Total Costs $0 $80,000 $0 $0 $80,000 Operating Impact None Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 55 Facilities Capital Projects Department Project Title Project Number Facilities and Construction Roof replacement at FS#1 FC2102 Project Description This request is to replace the roof system and seal the building envelope at Fire Station#1 ($120,000). Project Justification This roof is at the useful life expectancy. It was identified in the Envelope Study performed in 2011. The roof and building envelope at Fire Station#1is original to construction and should be replaced. Note: Project funding source is Facility Services Fund (505). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $120,000 Engineering/Design Total $120,000 Land/ROW Acquisition Construction 10/2020 09/2021 Other Total Schedule 10/2020 09/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 120,000 0 0 $120,000 Sales Tax Other Total Funding $0 $120,000 $0 $0 $120,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 120,000 0 0 $120,000 Other Total Costs $0 $120,000 $0 $0 $120,000 Operating Impact None Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 56 Schedule 7 Major Capital Equipment Capital Projects Budget Summary Project To 2020/21 2021/22 2022 To Total Date Proposed Estimated Completion Project Costs Continuing Projects FS2001 Ambulance Replacement(Unit 977) 364,411 0 0 0 $ 364,411 IT1701 Enterprise Computer System Replacement 3,674,428 0 0 0 $ 3,674,428 FS2004 Fuel System Enhancements 35,000 0 0 0 $ 35,000 IT2002 IT Security Project 137,510 0 0 0 $ 137,510 IT1901 Network Replacement for Offsite City Facilities 220,500 0 0 0 $ 220,500 IT1702 Public Safety Technology 1,306,000 0 0 0 $ 1,306,000 IT2001 Purchase/Replacement of Storage Area Network(SAN)Hardware 175,000 100,000 0 0 $ 275,000 FS2009 Replacement Ambulance(Unit 984) 364,411 0 0 0 $ 364,411 IS1502 Replacement of CAD/RMS Public Safety Software Platform 2,939,000 0 0 0 $ 2,939,000 FS1912 Replacement of Fire Truck(Unit 945) 1,285,000 0 0 0 $ 1,285,000 FS2005 Roller Replacement(Unit 6620) 70,000 0 0 0 $ 70,000 Total Continuing Projects $ 10,571,260 $ 100,000 $ 0 $ 0 $ 10,671,260 New Projects IT2109 CradlePoint Upgrade for Fire Vehicles 0 60,000 0 0 $ 60,000 IT2102 Purchase of 7-Bin Automated Sorting System for the Library 0 68,400 0 0 $ 68,400 FS2104 Truck&Jetter Replacement(Units 5501&5551) 0 305,000 0 0 $ 305,000 FS2105 Valve Maintenance Trailer(NE" 0 110,000 0 0 $ 110,000 Total New Projects $ 0 $ 543,400 $ 0 $ 0 $ 543,400 Total Project Costs $ 10,571,260 $ 643,400 $ 0 $ 0 $ 11,214,660 Funding Sources Certificates of Obligation 4,345,000 305,000 0 0 $ 4,650,000 Federal/State Grants 375,817 68,400 0 0 $ 444,217 Reserves 2,911,443 270,000 0 0 $ 3,181,443 Other 2,939,000 0 0 0 $ 2,939,000 Total Sources of Funds $ 10,571,260 $ 643,400 $ 0 $ 0 $ 11,214,660 57 NItH Major Capital Equipment Capital Projects Department Project Title Project Number Information Services Purchase/Replacement of Storage Area Network(SAN) Hardware IT2001 Project Description Purchase and replacement of storage area networks (SAN) hardware. Project Justification The City's current SAN hardware is used to store and access all Departmental network drives, "My Documents"folders for each employee, email files, software applications/virtual servers, &video/audio files. The capacity of the current SAN are reaching capacity. Several of the SANs have reached their suggested life cycles and the management software of the SANs has become outdated. With this project, the City would be able to consolidate the data and move from 4 physical SANs into 2 (with greater data capacity). Funding Source: Information Technology Fund (520). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Adopted Budget 2019-20 $175,000 Engineering/Design Proposed 2020-21 $100,000 Land/ROW Acquisition Total $275,000 Construction Other 10/2019 09/2020 Total Schedule 10/2019 09/2020 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 175,000 100,000 0 0 $275,000 Sales Tax Other Total Funding $175,000 $100,000 $0 $0 $275,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction Other 175,000 100,000 0 0 $275,000 Total Costs $175,000 $100,000 $0 $0 $275,000 Operating Impact Hardware Maintenance(after 3 years) Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-25 Total Impact Amount $0 $0 $0 $30,000 $0 $30,000 Total Operating Impact $0 $0 $0 $30,000 $0 $30,000 59 Major Capital Equipment Capital Projects Department Project Title Project Number Information Services CradlePoint Upgrade for Fire Vehicles IT2109 Project Description Replacement of legacy Cradlepoints and antennas for Fire Units. These systems are used to maintain a encrypted connection to the City's network on fire vehicles. Project Justification The Fire Department was the pilot for the first installment of Cradlepoints 7yrs ago. Since then, they have not been fully upgraded to meet the demands of todays technological requirements. There have been GPS updates on the newer Cradlepoints that are not available on the legacy Cradlepoints. The GPS updates are crucial for Spillman AVL status. The antennas are also legacy antennas requiring upgrading to meet the connection outputs required by the newer Cradlepoints. The legacy antennas only provide connectivity cables for 4 connections-2-Wifi, 1 Cellular, 1-GPS. With the constant change of technology, the newer Cradlepoints will require an antenna with 2-Wifi, 2 Cellular, and 1 GPS. The antenna install will be outsourced to CrossPoint Communications. Note: Project funding source is Information Technology Fund (520). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $60,000 Engineering/Design Total $60,000 Land/ROW Acquisition Construction Other 11/2020 01/2021 Total Schedule 11/2020 01/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 60,000 0 0 $60,000 Sales Tax Other Total Funding $0 $60,000 $0 $0 $60,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction Other 0 60,000 0 0 $60,000 Total Costs $0 $60,000 $0 $0 $60,000 Operating Impact No operating impact is anticipated. Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 60 Major Capital Equipment Capital Projects Department Project Title Project Number Library Purchase of 7-Bin Automated Sorting System for the Library IT2102 Project Description The Library is requesting a 7-bin Automated Sorting System. Project Justification Currently staff spends 100-200 hours per week manually checking and sorting returned library materials. An automated system will eliminate the amount of physical contact with library materials as part of the check-in process which will help improve the the health and safety of this process for Library staff. Note: Project funding source is the CAREs Act Federal Grant. Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $68,400 Engineering/Design Total $68,400 Land/ROW Acquisition Construction Other 01/2021 02/2021 Total Schedule 01/2021 02/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants 0 68,400 0 0 $68,400 Reserves Sales Tax Other Total Funding $0 $68,400 $0 $0 $68,400 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction Other 0 68,400 0 0 $68,400 Total Costs $0 $68,400 $0 $0 $68,400 Operating Impact Yearly Hardware Maintenance Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-25 Total Impact Amount $4,500 $4,500 $4,500 $4,500 $4,500 $22,500 Total Operating Impact $4,500 $4,500 $4,500 $4,500 $4,500 $22,500 61 Major Capital Equipment Capital Projects Department Project Title Project Number Fleet Services Truck&Jetter Replacement(Units 5501 &5551) FS2104 Project Description This is for the purchase of a new truck and jetter to replace unit 5501, a 2002 Freightliner, and unit 5551, a 2012 Harben jetter utilized by the Public Works Department. Project Justification All equipment is evaluated for replacement based on frequency of use, the number of like equipment in the fleet, equipment condition, and the availability of parts and service. The truck will be 19 years old when replaced. Both units were scheduled to be replaced in 2012, but staff made the decision to retain the truck and replace only the jetter. It is to the point now that the unit no longer meets the needs of the department, is out of service frequently, and is no longer cost-effective to continue repairing. The replacement truck would be equipped with an energy-efficient clean-burning diesel engine which meets the replacement guidelines of the Clean Fleet Vehicle Program. Note: Project funding source is Certificates of Obligation. Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $305,000 Engineering/Design 10/2020 11/2020 Total $306,000 Land/ROW Acquisition Construction 11/2020 06/2021 Other Total Schedule 10/2020 06/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation 0 305,000 0 0 $306,000 Federal/State Grants Reserves Sales Tax Other Total Funding $0 $306,000 $0 $0 $306,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 305,000 0 0 $306,000 Other Total Costs $0 $306,000 $0 $0 $306,000 Operating Impact None Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 62 Major Capital Equipment Capital Projects Department Project Title Project Number Fleet Services Valve Maintenance Trailer(NEW) FS2105 Project Description Purchase and continued maintenance of a Valve Maintenance Trailer. The unit includes a valve exerciser, vacuum system, and a data collection system. The valve exerciser can deliver 800 ft Ibs of torque, which cannot be delivered by two employees exercising a valve. This additional torque will help loosen valves that would not be able to be loosened by conventional means. The vacuum system allows staff to clean and excavate valve stacks and boxes. The data collection system will provide staff with data that is not currently known, such as GPS location, number of turns to open and close valve, and direction the valve turns. Project Justification This unit will be used by the valve crew in the Public Works Utility Division and will provide staff the equipment needed to maintain valves of all sizes. Maintained valves provide citizens with faster response times and better water quality. Response times for shutting down a large water main break will decrease due to the valve maintenance program and the exerciser on the trailer. Information collected during the maintenance program will be used to lower response time. Water quality will continue to improve due to knowing which valves are open or closed. The City recently hired Pure Technology to complete a valve exercising project that was conducted on roughly 140 valves larger than 16 inches in size at a cost of$39,930. This company used a valve maintenance trailer with two employees to complete this project. This project resulted in the discovery of two large valves that were closed. Once opened, staff has seen a result in better water quality in the area. Using the current cost of the Pure Technology exercising project, the return on investment is approximately three years. The expected life cycle of this exercising equipment is 10 years. Purchasing the unit will allow for an annual valve maintenance program and GPS location of all valves. The City has roughly 7,000 valves in the distribution system. AWWA recommends that each valve have maintenance performed on an annual basis. Note: Project funding source is the Utility Fund (405). Project Schedule Beginning Date Ending Date History Fiscal Year Amount Professional Services Proposed 2020-21 $110,000 Engineering/Design 10/2020 11/2020 Total $110,000 Land/ROW Acquisition Construction 11/2020 06/2021 Other Total Schedule 10/2020 06/2021 Sources of Funds To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Funding General Obligation Bonds Certificates of Obligation Federal/State Grants Reserves 0 110,000 0 0 $110,000 Sales Tax Other Total Funding $0 $110,000 $0 $0 $110,000 Project Costs To Date 2020-21 Budget 2021-22 Estimate 2022-Completion Total Cost Professional Services Engineering/Design Land/ROW Acquisition Construction 0 110,000 0 0 $110,000 Other Total Costs $0 $110,000 $0 $0 $110,000 Operating Impact None Fiscal Year 2020-21 2021-22 2022-23 2023-24 2024-26 Total Impact Amount $0 $0 $0 $0 $0 $0 Total Operating Impact $0 $0 $0 $0 $0 $0 63 Schedule 8 Economic Development Capital Projects Budget Summary Project To 2020/21 2021/22 2022 To Total Date Proposed Estimated Completion Project Costs Continuing Projects 1 ED0801 Business Improvement and Growth(BIG)Program 350,000 0 0 0 $ 350,000 2 ED1602 Loop 820 Redevelopment 2016 8,750,000 0 0 0 $ 8,750,000 3 ED1501 Neighborhood Revitalization Program(NRP) 336,184 0 0 0 $ 336,184 PW0402 Sign Removal Assistance Program 50,000 0 0 0 $ 50,000 Total Continuing Projects $ 9,486,184 $ 0 $ 0 $ 0 $ 9,486,184 Total Project Costs $ 9,486,184 $ 0 $ 0 $ 0 $ 9,486,184 Funding Sources Reserves 7,965,000 0 0 0 $ 7,965,000 Other 1,521,184 0 0 0 $ 1,521,184 Total Sources of Funds $ 9,486,184 $ 0 $ 0 $ 0 $ 9,486,184 64 Schedule 9 CIP Personnel Capital Projects Budget Summary Project To 2020/21 2021/22 2022 To Total Date Proposed Estimated Completion Project Costs Continuing Projects UC1901 Utility Capital Projects Personnel 1,003,318 353,105 0 0 $ 1,356,423 Total Continuing Projects $ 1,003,318 $ 353,105 $ 0 $ 0 $ 1,356,423 Total Project Costs $ 1,003,318 $ 353,105 $ 0 $ 0 $ 1,356,423 Funding Sources Reserves 1,003,318 353,105 0 0 $ 1,356,423 Total Sources of Funds $ 1,003,318 $ 353,105 $ 0 $ 0 $ 1,356,423 65 Schedule 10 Other Capital Projects Budget Summary Project To 2020/21 2021/22 2022 To Total Date Proposed Estimated Completion Project Costs Continuing Projects ES0902 Litter Not Program 25,000 0 0 0 $ 25,000 ES0901 Neighborhood Initiative Program 407,158 0 0 0 $ 407,158 PL1501 Strategic Plan 168,638 0 0 0 $ 168,638 Total Continuing Projects $ 600,796 $ 0 $ 0 $ 0 $ 600,796 Total Project Costs $ 600,796 $ 0 $ 0 $ 0 $ 600,796 Funding Sources Reserves 407,158 0 0 0 $ 407,158 Sales Tax 93,638 0 0 0 $ 93,638 Other 100,000 0 0 0 $ 100,000 Total Sources of Funds $ 600,796 $ 0 $ 0 $ 0 $ 600,796 66 Schedule 11 2019-20 Budget Revisions Budget Summary Adopted Budget 2019-20 Project Project Through Revision Revised Number Name 2019-20 2019-20 Budget STREET&SIDEWALK CAPITAL PROJECTS CDBG19 Schiller Drive Reconstruction $35,000 ($6,000) $29,000 ST2003 Northeast Parkway/Davis Blvd.Traffic Signal 380,000 (25,000) 355,000 ST2005 Northeast Parkway Extension 790,000 25,000 815,000 ST1304 Smithfield Road(Davis/Mid-Cities) 3,343,640 (68,170) 3,275,470 ST1701 Vance and Glenview Signal Upgrade: 241,692 74,170 315,862 Sub-Total $4,790,332 $0 $4,790,332 DRAINAGE CAPITAL PROJECTS DR1902 Street Drainage Improvements Project(2019) $100,000 ($102) $99,898 DR1801 Snow Heights Drainage Improvements Project 320,000 (4,567) 315,433 Sub-Total $420,000 ($4,669) $415,331 PARKS&RECREATION CAPITAL PROJECTS PK1802 Hometown Lakes Pedestrian Bridge Trail Connection: $80,000 ($2,811) $77,189 PK1606 Park System Signange 479,486 (5,000) 474,486 PK1806 Trail and On-Road Safety Projects 730,543 5,000 735,543 PK1901 Annual Tree Planting 2019 45,000 (8,840) 36,160 PK1603 Northfield Park Redevelopment 6,125,312 (5,133) 6,120,179 PK2005 Richland Tennis Center Infrastructure Improvements(2020: 100,000 0 100,000 PK1902 Linda Spurlock Park Renovatior 1,000,000 35,000 1,035,000 PK1904 Park Infrastructure Maintenance 201 285,907 (9,954) 275,953 PK2004 Park Infrastructure Maintenance 202C 190,000 (25,046) 164,954 Sub-Total $9,036,248 ($16,784) $9,019,464 UTILITY CAPITAL PROJECTS UT2009 Water Impact Fee Project $0 $21,000 $21,000 UT2010 Sewer Impact Fee Project 0 21,000 21,000 UT1905 Small Water Main Replacements(2019) 440,000 (4,989) 435,011 UT1903 Miscellaneous Water/Sewer Main Replacement(2019) 445,000 4,989 449,989 Sub-Total $885,000 $42,000 $927,000 MAJOR CAPITAL EQUIPMENT FS2004 Fuel System Enhancements $163,000 ($128,000) $35,000 IT1401 Cell Phone Signal Boosters in NRH CentrE 98,000 (98,000) 0 FS1910 Utility Tractor Replacement 34,500 20,500 55,000 FS1902 Distributor Truck Replacement(Unit 681) 200,000 (211) 199,789 FS1904 Pothole Patcher 202,588 (652) 201,936 FS1909 Utility Tractor Replacement 55,000 (23,763) 31,237 FS1911 Vac-Con Truck 402,000 (5) 401,995 FS2002 Backhoe Replacement 140,000 (36,000) 104,000 FS2003 Backhoe Replacement 140,000 (38,600) 101,400 FS2006 Utility Tractor Replacement 65,000 (33,078) 31,922 FS2008 Wheel Loader 220,000 (56,000) 164,000 FS1901 Crack Sealing Machine 95,000 (26,592) 68,408 FS2007 Wheel Loader Replacement(Unit 685) 220,000 (5,000) 215,000 FS2005 Roller Replacement(Unit 6620) 65,000 5,000 70,000 FS2007 Wheel Loader Replacement(Unit 685) 215,000 (72,000) 143,000 FS1903 Dump Truck Replacement 120,412 0 120,412 IS1502 Replacement of CAD/RMS Public Safety Software Platform 3,020,000 (81,000) 2,939,000 Sub-Total $5,455,500 ($573,401) $4,882,099 AQUATIC CAPITAL PROJECTS WP1901 General Facility Improvements 201S $100,000 ($11,279) $88,721 Sub-Total $100,000 ($11,279) $88,721 FACILITY CAPITAL PROJECTS FC1701 Overhead Door Replacement $52,000 ($1,000) $51,000 FC1702 Overhead Door Safety Edges&Remote Control Assemblies 68,800 (900) 67,900 FC1902 Permanent Records Roof Replacement$Building Envelope Seal 78,000 (6,500) 71,500 FC1903 Replacement of HVAC Systems at Fire Stations#1 and#4 59,000 (141) 58,859 FC1904 Upgrade/Remodel of Public Works Restroom 75,000 6,500 81,500 Sub-Total $332,800 ($2,041) $330,759 ECONOMIC DEVELOPMENT PROJECTS ED0601 TIF 1 Expansion-Intersection Improvements/Utility Buria $3,000,000 ($432,715) $2,567,285 ED1002 Loop 820 Redevelopment 201 C 1,595,572 45,724 1,641,296 ED1503 TOD Land Management 1,200,000 89,033 1,289,033 Sub-Total $5,795,572 ($297,958) $5,497,614 67 Schedule 11 2019-20 Budget Revisions Budget Summary Adopted Budget 2019-20 Project Project Through Revision Revised Number Name 2019-20 2019-20 Budget Total All Projects $26.815.452 1gtl 64,'032) $25,951,320 SOURCES OF FUNDS General Obligation Bond=. $1,650,000 $0 $1,650,000 Certificates of Obligations 13,164,588 (887,183) 12,277,405 Federal/State Grants 1,806,217 0 1,806,217 Reserves 7,308,754 2,702 7,311,456 Sales Tax 1,630,893 (11,651) 1,619,242 Other 1,255,000 32,000 1,287,000 Total Sources of Funds $26,815,452 1gt864,132) $25,951,320 68 Street & Sidewalk Capital Projects Schiller Drive Road Reconstruction (CDBG) CDBG19 PROJECT DESCRIPTION&JUSTIFICATION This is the 44th Year Community Development Block Grant(CDBG) Project. The project will consist of reconstructing the entire length (480 linear feet)of Schiller Drive. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE I REVISION Professional Services Engineering 10/2018 09/2019 Land/ROW Acquisition Construction 02/2019 10/2019 Other REVISION EXPLANATION Staff is requesting an increase in ST1701 based an increase in the cost of engineering and construction. Savings has been identified in CDBG19 and ST1304. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Reserves $35,000 ($6,000), $29,000 $29,000 0 $0 0 $0 0 $0 0 $0 Total 1 $35 000 $6 000 $29,0001 $0 $29,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 35,000 (6,000) 29,000 $29,000 Other 0 $0 Total $35,0001 ($6,000)1 $29,000 $0 $29,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 69 Major Capital Equipment Capital Projects Northeast Parkway/ Davis Blvd. Traffic Signal ST2003 PROJECT DESCRIPTION&JUSTIFICATION This project consists of engineering and construction of a new traffic signal at the intersection of Davis Boulevard and Northeast Parkway. The scope includes paving and signal improvements. The Northeast Parkway/Davis intersection lies within the Smithfield Transit Oriented Development and serves a large residential area east of Davis. The addition of a signal would provide for safe access during peak times from Northeast Parkway to Davis Boulevard for the Stonybrooke neighborhoods, the new Smithfield Villas TOD residential neighborhood, and the existing industrial users on Northeast Parkway. Based on the future extension of Northeast Parkway to the west, it is expected that even more motorists will use this intersection in the future. PROJECT STATUS ORIGINAL 2019/20 ORIGINAL 2019/20 START DATE REVISION END DATE REVISION Professional Services Engineering 02/2020 08/2020 Land/ROW Acquisition Construction 09/2020 04/2021 Other REVISION EXPLANATION FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Certificates of Obligation $380,000 ($25,000), $355,000 $355,000 0 0 0 $0 0 $0 0 $0 0 $0 Total $380,000 $25 000 $355,0001 $0 $355,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 80,000 80,000 $80,000 Land/ROW Acquistion 0 $0 Construction 300,000 (25,000) 275,000 $275,000 Other 0 $0 Total $380,000 1 ($25,000)1 $355,000 $0 $355,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 70 Major Capital Equipment Capital Projects Northeast Parkway Extension ST2005 PROJECT DESCRIPTION&JUSTIFICATION This project consists of constructing an extension of Northeast Parkway west of Davis Boulevard towards Smithfield Road. The new pavement will intersect with Davis at a proposed traffic signal, and will include a roundabout midway between Davis and Smithfield to accomodate a future Snider Street connection and provide traffic calming. The project will be constructed in two phases,with the Davis connection through the roundabout included in Phase I, and the connection to Smithfield in Phase II after the exisitng elementary school is demolished in 2021. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 09/2019 03/2020 Land/ROW Acquisition Construction 04/2020 12/2020 Other REVISION EXPLANATION FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Reserves $790,000 $25,000 $815,000 $815,000 0 $0 0 $0 0 $0 0 $0 Total $790,000 1 $25,0001 $815,0001 $0 $815,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 50,000 0 50,000 $50,000 Land/ROW Acquistion 0 $0 Construction 740,000 25,000 765,000 $765,000 Other 0 $0 Total $790,000 1 $25,0001 $815,000 $0 $815,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 71 Street & Sidewalk Capital Projects Smithfield Road (Davis Blvd 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 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 11/2013 03/2017 Land/ROW Acquisition 04/2014 03/2017 Construction 03/2018 08/2019 Other REVISION EXPLANATION ST1304 has been completed and savings have been identified that staff is requesting to shift to ST1701 based an increase in the cost of engineering and construction. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES GO Bonds $1,650,000 $0 $1,650,000 $1,650,000 CO Bonds 100,000 0 100,000 $100,000 Federal/State Grants 550,000 0 550,000 $550,000 Reserves 1,043,640 (68,170) 975,470 $975,470 0 $0 Total $3 343 640 $68 170 $3 275 470 $0 $3 275 470 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 254,710 254,710 $254,710 Land/ROW Acquistion 552,464 552,464 $552,464 Construction 2,536,466 (68,170)! 2,468,296 $2,468,296 Other 0 $0 Total $3,343,640 1 ($68,170)1 $3,275,470 1 $0 $3,275,470 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 72 Street & Sidewalk Capital Projects Vance and Glenview Signal Upgrades ST1701 PROJECT DESCRIPTION&JUSTIFICATION This project consists of replacing the existing span wire signal at the intersection of Vance Road and Glenview Drive with pole mounted signals. This project also includes the installation of pedestrian signal heads and striping at the intersection. This project has been approved for funding through the HSIP (Highway Safety Improvement Program)grant which is 90%federal funding and 10% local funding. The 90%coverage of federal funds is only for construction costs. This project will be let through TxDOT as the grant is disseminated through TxDOT. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2016 04/2018 Land/ROW Acquisition Construction 11/2019 01/2020 Other REVISION EXPLANATION Staff is requesting an increase in ST1701 based an increase in the cost of engineering and construction. Savings has been identified in CDBG19 and ST1304. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Federal/State Grants $180,000 $0 $180,000 $180,000 Reserves 61,692 74,170" 135,862 $135,862 0 $0 0 $0 0 $0 Total 1 $241,6921 $74,1701 $315,8621 $0 $315 862 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 30,000 10,000 40,000 $40,000 Land/ROW Acquistion 0 $0 Construction 211,692 64,170'I 275,862 $275,862 Other 0 $0 Total $241,692 1 $74,1701 $315,862 $0 $315,862 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 73 Drainage Capital Projects Street Drainage Improvements Project (2019) DR 1902 PROJECT DESCRIPTION&JUSTIFICATION The project would consist of addressing a portion of the numerous non-grade standing water requests Public Works receives each year. This would be accomplished by removing and replacing curb and gutter systems to an adequate grade that provides positive drainage along city streets. Creating positive drainage along streets can sometimes require drive approaches and sidewalks to be replaced as well to accommodate the new grade. The current list of requests from citizens consist of 193 locations with an estimated cost of$640,000 to complete the entire list of locations to date. This project could be considered an annual project until such time as the list of request is completed or until the entire list can be accomplished. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2018 11/2018 Land/ROW Acquisition Construction 12/2018 04/2019 Other REVISION EXPLANATION This project was completed and savings were identified that were released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Drainage Utility Fund Reserves $100,000 ($102)! $99,898 $99,898 0 $0 0 $0 0 $0 0 $0 Total 1 $100,000 $102 $99,8981 $0 $99,898 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 100,000 (102) 99,898 $99,898 Other 0 $0 Total $100,000 1 ($102)1 $99,898 $0 $99,898 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 74 Drainage Capital Projects Snow Heights Drainage Improvements Project DR1801 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 aproximately 1,200 linear feet of concrete drainage pipe with intake structures. Phase I of the project installed the upstream portion of the drainage system and created a temporary overland path. Phase 11 of this project will continue the drainage from the previous project(DR1801)and connect via approximately 450 LF of concrete pipe to the existing drainage system in the eastbound Loop 820 frontage road. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2017 09/2020 Land/ROW Acquisition Construction 12/2017 03/2020 Other REVISION EXPLANATION Project close out. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRIJ REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Reserves $170,000 ($4,567), $165,433 $165,433 Other 150,000 0 150,000 $150,000 0 $0 0 $0 0 $0 Total $320 000 $4 567 $315,4331 $0 $315 433 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 25,000 25,000 $25,000 Land/ROW Acquistion 0 $0 Construction 295,000 (4,567) 290,433 $290,433 Other 0 $0 Total $320,000 $4,567 $315,433 $0 $315,433 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 75 Parks & Recreation Capital Projects Hometown Lakes Pedestrian Bridge Trail Connections PK1802 PROJECT DESCRIPTION&JUSTIFICATION This project provides for trail connections from the Walker's Creek Trail to the new pedestrian bridge crossing the northernmost lake of the Lakes of Hometown. The bridge and bridge abutments are being installed by Arcadia Development, and this project will provide for access to the bridge from the existing Walker's Creek Trail on both the east and west sides of the lake. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2017 03/2018 Land/ROW Acquisition Construction 04/2018 11/2018 Other REVISION EXPLANATION This project was completed and savings were identified that were released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Sales Tax $80,000 ($2,811) $77,189 $77,189 0 $0 0 $0 0 $0 0 $0 Total 1 $80 000 $2 811 $77,1891 $0 $77,189 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 80,000 (2,811) 77,189 $77,189 Other 0 $0 Total $80,0001 ($2,811)1 $77,189 $0 $77,189 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 76 Parks & Recreation Capital Projects Park System Signage PK1606 PROJECT DESCRIPTION&JUSTIFICATION This project provides for design and construction of new, updated signage that will provide a gateway to each park, consistent with the vision, "City as Park"as supported by the Park, Recreation and Open Space Master Plan. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2015 04/2020 08/2020 Other REVISION EXPLANATION This project will have significant savings when all work is completed.The funding is being provided to PK1806 to support additional requested professional services. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISIO14 2019/20 BALANCE COST FUNDING SOURCES Sales Tax $479,486 ($5,000) $0 $474,486 0 $0 0 0 $0 Total $479 486 $5 000 $0 $0 $474,486 PROJECT EXPENDITURES Professional Services Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 479,486 (6,000), 0 $474,486 Other 0 Total $479,486 $$1000 $0 $474,486 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 77 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 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services 10/2017 2/2018 09/2020 Engineering Land/ROW Acquisition Construction 04/2018 11/2020 03/2019 03/2021 Other REVISION EXPLANATION Additional professional services will be required for Lee Engineering to update their plan for permitting with TxDOT. Lee Engineering is not the lead consultant for this project, but worked on the Precinct Line and Glade Road crossing for the Cotton Belt Trail. Savings from PK1606 will be used to offset the cost. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Federal/State Grants 576217 $0 $576,217 $576,217 Reserves 154326 5000 159,326 $159,326 0 $0 0 $0 0 $0 Total $730 543 1 $5,0001 $735,5431 $0 $735 543 PROJECT EXPENDITURES Professional Services 113500 5000 $118,500 $118,500 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 606771 0 606,771 $606,771 Other 10272 10,272 $10,272 Total $730,543 1 $5,0001 $735,543 $0 $735,543 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 78 Major Capital Equipment Capital Projects Annual Tree Planting 2019 PK1901 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the introduction of trees into the urban forest and replacement of trees that have died at various locations throughout the City. The project involves the installation of 3" caliper, drought tolerant, native or adapted trees. Park facilities to receive trees includes Northfield Park and various other locations. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2018 05/2019 Other REVISION EXPLANATION This project was completed and savings was identified that was released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Sales Tax $45,000 ($8,840)j $36,160 $36,160 0 $0 0 $0 0 $0 0 $0 Total 1 $45 000 $$840 $36,1601 $0 $36,160 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 45,000 (8,840) 36,160 $36,160 Other 0 $0 Total $45,0001 ($8,840)1 $36,160 $0 $36,160 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 79 Parks & Recreation 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 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 03/2016 08/2017 Land/ROW Acquisition Construction 11/2017 11/2018 Other REVISION EXPLANATION This project was completed and savings were identified that were released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES CO Bonds $3,900,000 $3,900,000 $3,900,000 Sales Tax 405,500 405,500 $405,500 Reserves 269,812 (5,134) 264,678 $264,678 Federal/State Grants 500,000 500,000 $500,000 Other 1,050,000 1,050,000 $1,050,000 Total $6 125 312 $5 134 $6 120 178 $0 $6 120 178 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 419,932 419,932 $419,932 Land/ROW Acquistion 0 $0 Construction 5,705,380 (5,134)! 5,700,246 $5,700,246 Other 0 $0 Total $6,125,312 1 ($5,134)1 $6,120,178 1 $0 $6,120,178 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 80 Parks & Recreation Capital Projects Richland Tennis Center Infrastructure Improvements (2020) PK2005 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the maintenance of the Richland Tennis Center Infrastructure in response to use and age. The FY2020 funding will provide for the resurfacing of all 16 courts. Tennis court resurfacing typically requires replacement every 4 or 5 years. The courts were last resurfaced approximately 6 years ago, in February/March of 2014.According to our use agreement with Birdville Independent School District(BISD), the school district is responsible for resurfacing 4 of the 16 courts. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 02/2020 09/2020 Other REVISION EXPLANATION Revised due to the anticipated funding under the other category of$25,000 (BISD)and $30,000 (USTA Grant)was short by $5,000.The USTA and State of Texas Section awarded a total of$25,000. Due to this shortfall, the Park Sales Tax (125)will have to be increased by$5,000. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Park Sales Tax (125) $45,000 $5,000 $50,000 $50,000 Other 55,000 (5,000)' 50,000 $50,000 0 $0 0 $0 0 $0 Total $100,000 $0 $100,0001 $0 $100,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 100,000 100,000 $100,000 Other 0 $0 Total $100,000 1 $0 $100,000 $0 $100,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 81 Parks & Recreation Capital Projects Linda Spurlock Park Renovation PK1902 PROJECT DESCRIPTION&JUSTIFICATION This project involves the redevelopment of the existing neighborhood park through the design and construction of existing and new amenities. Recommended park elements for the renovation of the park include a new parking lot, a new pavilion, upgrade of playground equipment and support facilities. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2018 10/2018 02/2020 06/2019 Land/ROW Acquisition Construction 12/2019 07/2020 12/2020 02/2021 Other REVISION EXPLANATION Savings are being reallocated from PK1904 and PK2004 Park Infrastructure Maintenance projects to cover the the shortfall to the Linda Spurlock Park Renovation project PK1902. Funds ($40,310)was also reallocated from PK1902 PS to CN to supplement the construction budget after receiving bids. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Certificates of Obligation $0 $0 $0 $0 Reserves 900,000 0" 900,000 $900,000 Sales Tax 100,000 35,000 135,000 $135,000 0 $0 0 $0 Total $1 000 000 $35,0001 $1 035 000 $0 $1 035 000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 189,000 (40,310) 148,690 $148,690 Land/ROW Acquistion 0 $0 Construction 811,000 75,310 886,310 $886,310 Other 0 $0 Total $1,000,000 1 $35,0001 $1,035,000 1 $0 1 $1,035,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 82 Parks & Recreation Capital Projects Park Infrastructure Maintenance 2019 PK1904 PROJECT DESCRIPTION&JUSTIFICATION This project provides for maintenance of park infrastructure in response to use and age. The FY2019 priorities include playground equipment replacement,fall zone material, drinking fountain replacement, sport field bulb replacement, Liberty Park paver repairs, Richfield and Green Valley AC replacement, Fossil Creek restroom removal,trail ramp concrete stain, Cross Timbers dugout roofs, sports field infield refurbishment, Green Valley dumpster fence,Adventure World fence replacement, ballfield fence replacement. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2018 10/2018 09/2019 06/2020 Other REVISION EXPLANATION Savings are being reallocated from PK1904 and PK2004 Park Infrastructure Maintenance projects to cover the the shortfall to the Linda Spurlock Park Renovation project PK1902. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Certificates of Obligation $0 $0 $0 $0 Reserves 0i 0 $0 Sales Tax 285,907 (9,954) 275,953 $275,953 0 $0 0 $0 Total $285 907 $9 954 $275,9531 $0 $275,953 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 285,907 (9,954) 275,953 $275,953 Other 0 $0 Total $285,907 1 ($9,954)1 $275,953 $0 $275,953 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 83 Parks & Recreation Capital Projects Park Infrastructure Maintenance 2020 PK2004 PROJECT DESCRIPTION&JUSTIFICATION This project provides for maintenance of park infrastructure in response to use and age. The FY2020 priorities include fall zone material, concrete trail panel replacement, playground equipment replacement, sports field bulb replacement, sports field infield refurbishment, drinking fountain replacement, Green Valley arch and soffit repair and replacement, Liberty Park Granite Plaque, Norich Park drainage,Ace Park fence repair, Green Valley drainage infrastructure study, Walker's Creek Park dumpster and Northfield Park bleachers. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2019 10/2019 09/2020 09/2020 Other REVISION EXPLANATION Savings are being reallocated from PK1904 and PK2004 Park Infrastructure Maintenance projects to cover the the shortfall to the Linda Spurlock Park Renovation project PK1902. 0 FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Certificates of Obligation $0 $0 $0 $0 Reserves 0 0 $0 Sales Tax 190,000 (25,046); 164,954 $164,954 0 $0 0 $0 Total $190 000 $25 046 $164,9541 $0 $164,954 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 190,000 (25,046) 164,954 $164,954 Other 0 $0 Total $190,000 $25,046 $164,954 $0 $164,954 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 84 Utility Capital Projects Water Impact Fee Project UT2009 PROJECT DESCRIPTION&JUSTIFICATION The Water Impact Fee Project consists of the professional services needed to support the data collection,tracking,and analysis of the City's impact fee program. PROJECT STATUS ORIGINAL 2111120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services 10/2019 09/2020 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Professional services had not been identified as a stand-alone project in previous years. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE T COST FUNDING SOURCES Water Impact Fees $0 $21,000 $21,000 $21,000 0 0 0 $0 0 $0 0 $0 0 $0 Total $0 , $21,0001 $21,000 0 $21,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 21,000 21,000 $21,000 Land/ROW Acquistion 0 $0 Construction 0 0 0 $0 Other 0 $0 Total $0 $21,0001 $21,000 $0 I $21,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019120 1 2020/21 1 2021/22 1 2022/23 1 2023/24 1TOTAL Projected I $0 85 Utility Capital Projects Sewer Impact Fee Project UT2010 PROJECT DESCRIPTION&JUSTIFICATION The Sewer(Wastewater)Impact Fee Project consists of the professional services needed to support the data collection, tracking, and analysis of the City's impact fee program. PROJECT STATUS ORIGINAL 2019/20 ORIGINAL 2119120 START DATE REVISION END DATE REVISION Professional Services 10/2019 09/2020 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Professional services had not been identified as a stand-alone project in previous years. FINANCIAL DATA ADOPTED VISEDTOTAL BUDGETTHRU PROJECT � BURGE DETTHRU REMAINING PROJECT 2019120 REVISION 2019/20 BALANCE COST FUNDING SOURCES Wastewater Impact Fees $0 $21,000 $21,000 $21,000 0 0 0 $0 0 $0 0 $0 0 $0 Total 0 21000 21000 0 21000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 21,000 21,000 $21,000 Land/ROW Acquistion 0 $0 Construction 0 0 0 $0 Other 0 $0 Total $0 $21,0001 $21,000 $0 1 $21,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019120 1 2020/21 1 2021/22 1 2022/23 2023/24 1 TOTAL Projected $0 86 ........... .........---1111-11111-1--1 1------- Utility Capital Projects Small Water Main Replacements UT1905 PROJECT DESCRIPTION&JUSTIE[CATION This is an annivall program that is colmp�leted by the Public Works Construction Division, The project replaces old 2"'and 4" water mains,with 6"or larger diameter water Pipes.This project provides adlequa:te fire hydrant coverage to areas currently without proper coverage. This is an annual program that is completed by the Public Works Construction DvWon, The project replaces old 2"and 4" i water rnains with new 6"'or larger water pipes and provides adequate fire hydrant coverage to,areas currently without proper coverage. in addition,this project helps to replace water lines that have deteriorated to a point where nurnerous water firle breaks are occurring and keep water qivaMy,to high standard. PROJECT STATUS ORIGINAL01 20 6 'i�l START DATE REVISION REVIS 0 Protessionat Ser0ces Engineering L.andIROW Acquisition Construction Other REVISION!EXPLANATION This,revision will true up UT1903,from a cost over-run by shifting::the savings from UIT1905(Small Water Main Replacement), This is frorni sadlaries/overtirne accounts overage,fundiniq will be provided from UIT1 9105 project savings. FINANCIAL DATA ADOPTED REVISE C�:RU TOTAL BUDGETTHRU' PROJECT BUDGET TH�� RE' PROJECT 8 20:19)20 REVISION 2019/20 BALANCE COST FUNDING SOURCES ....................................................................................................................... ................. Certificates of Obligation $0 $0 . $0 $0 Reserves 0 0 0 $0 0 $0 0 $0 tt $0 .......................................................................................................... .............................................................. $0 M PROJECT EXPENDITURES ............................................................................................. Professional Services $0 $0 Engineedng/Design 01 $0 LandIRM Acqwsfion 0 $0 Construction 440,000, (4,989) 435,0 1,1 $43�5,01 1 Other 0 0 $ � Total $440,:000 ($4,989) $43,5,011 $440,00011 IMPACT ON OPERATING BUDGET ANNUAL Poje,td 87 .................................................. ........... Utility Capital Projects Miscellaneous W ter/Sewer Main Replacement UT19,0,3 PROJECT DESCRIPTION&JUSTiFICADON This is an arinLIall program,that is completed by the Public Works,Construction Division. The program will provide for water and sewer main replacements including any developmental projects. The project replaces aging infrastructure and maintains high standards for water quality. The specific projects are selected based on factors such as ma4itenance cost, location of infrastructure and pipe diameter. This project provides,for the retirement of existing water lines which continue to cause a decrease in system capacity and water quality. This project also replaces old fines the require significant maintenance and operating cost. The construction of these Mines are completed by the Public' orks Construction Division. H'i T91 2-0 OR-I-GINAL 20 PROJECT STATUS OkIdINAL VISIONj ISJOI START DATE LE � END DATE REV'IS,19120ION I...................... Professional Services Engineering Land/IROW Aquisition conslruciian 10/2018 09/2019 Other REVISION EXPLANATION This revision will true up,UT1903 from a cost over-run by sniffing the savings from UT1905(Small Water Main Replacement). This is frorn salarieslovertime accounts overage, funding will be provided from UT1905,project savings IINANCIA11 DATA -, AD-61 5TED R.EVi�S-ED ................. TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 20i 12q REVJSION 2019120 BALANCE C01ST FUNDING SOURCES ............ $0, Certificates of Obligation $0 $0 $0 Reserves 0: 0 01 $0 0 $0 0 $0 0 $0 Total io:L $01 $0, i $0- PROJECT EXPENDff-GRE§----"-_ $0 $0 Professional Services 1 Eng;Jneef ingADesign 0! $0 Land/ROW Acquistion 0; $0 Construction 445,0!00 4,989 449,989 $449,9:89 Other 0 $0 9 $01 .................. 449,989 IMPACT ON OPERATING BUDGET JANNUAL OPERATING IMPACT 2019120, 2020121 2021!122 2022/23 202=4 11 TOTAL $0 ........................................... .............................................................. 88 Major Capital Equipment Capital Projects Fuel System Enhancements FS2004 PROJECT DESCRIPTION&JUSTIFICATION This project will include the following components: 1. Replace the spill container buckets on the fuel tanks at the Service Center. 2. Remove Fire Station 3 underground fuel tank and install a 5,000 gallon above-ground partitioned tank(3500 D/1500 G). 3.Add Fuelmaster fuel management system and remote tank monitoring tied into the system at Fire Station 3 and Fire Station Due to age and cracked condition of the current spill container buckets,water is able to leak into the fuel tanks. The fuel tank at Fire Station 3 began to leak a couple of years ago so it had to be taken out of service and drained immediately. The tank cannot be reused and must be removed and replaced. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION A budget revision is necessary due to a reduction in the proposed scope of the project to include only the removal of the Fire Station 3 underground fuel tank. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRIJ REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Certificates of Obligation $160,000 ($160,000) $0 $0 Reserves 3,000 32,000" 35,000 $35,000 0 $0 0 $0 0 $0 Total $163 000 $128 000 $35,0001 $0 $35,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 163,000 (128,000) 35,000 $35,000 Other 0 $0 Total $163,000 $128,000 "1 $35,000 $0 $35,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 89 Major Capital Equipment Capital Projects Utility Tractor Replacement FS1910 PROJECT DESCRIPTION&JUSTIFICATION This is for the purchase of a new utility tractor to replace unit 788, a 1995 year-model Kubota utilized by the Parks Department. When replaced, the utility tractor will be 23 years old. The CIP Major Capital equipment replacement program was implemented using the recommendations obtained in an independent study conducted for the City by Peat Marwick in August of 1986 and August of 1993 which recommended a minimum 10-year replacement for capital equipment. At the 10-year interval, the equipment is evaluated for replacement based on frequency of use, the number of like equipment in the fleet, equipment condition, and the availability of parts and service. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2018 11/2018 Land/ROW Acquisition Construction 12/2018 04/2019 Other REVISION EXPLANATION During the FY 19-20 Proposed Budget process the budget for this project was reduced from$55,000 to$34,500. This revision will correct this project to the actual expense for this purchase. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Fleet Services Fund $34,500 $20,500 $55,000 $55,000 0 0 0 $0 0 $0 0 $0 0 $0 Total 1 $34,5001 $20,5001 $55,0001 $0 $55,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 34,500 20,500 55,000 $55,000 Other 0 $0 Total $34,5001 $20,5001 $55,000 $0 $55,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 90 Major Capital Equipment Capital Projects Distributor Truck Replacement (Unit 681) FS1902 PROJECT DESCRIPTION&JUSTIFICATION This is the replacement of a 1995 Chevrolet Kodiak distributor truck Unit 681 assigned to the Public Works Streets Division. Estimated cost of the truck is$200,000. When replaced, the truck will be 24 years old. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2018 11/2018 Land/ROW Acquisition Construction 12/2018 06/2019 Other REVISION EXPLANATION This project was completed and savings was identified that was released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES CO Bonds $200,000 ($211) $199,789 $199,789 0 $0 0 $0 0 $0 0 $0 Total 1 $200,000 $211 $199,7891 $0 $199,789 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 200,000 (211) 199,789 $199,789 Other 0 $0 Total $200,000 $211 $199,789 $0 $199,789 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 91 Major Capital Equipment Capital Projects Pothole Patcher Replacement(Unit 6609) FS1904 PROJECT DESCRIPTION&JUSTIFICATION This is for the purchase of a new pothole patcher to replace unit 6609, a 2002 year-model Freightliner. Estimated cost of the pothole patcher is$210,000. When replaced, the pothole patcher will be 17 years old and have an estimated odometer reading of 90,000 miles. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2018 11/2018 Land/ROW Acquisition Construction 12/2018 04/2019 Other REVISION EXPLANATION This project was completed and savings was identified that was released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES CO Bonds $202,588 ($652)! $201,936 $201,936 0 $0 0 $0 0 $0 0 $0 Total $202,588 $652 $201,9361 $0 $201,936 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 202,588 (652) 201,936 $201,936 Other 0 $0 Total $202,588 1 ($652)1 $201,936 $0 $201,936 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 92 Major Capital Equipment Capital Projects Utility Tractor Replacement FS1909 PROJECT DESCRIPTION&JUSTIFICATION This is for the purchase of a new pothole patcher to replace unit 6609, a 2002 year-model Freightliner. Estimated cost of the pothole patcher is$210,000. When replaced, the pothole patcher will be 17 years old and have an estimated odometer reading of 90,000 miles. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2018 11/2018 Land/ROW Acquisition Construction 12/2018 04/2019 Other REVISION EXPLANATION This project was completed and savings was identified that was released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Fleet Fund Reserves $55,000 ($23,763) $31,237 $31,237 0 $0 0 $0 0 $0 0 $0 Total 1 $55 000 $23 763 $31,2371 $0 $31,237 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 55,000 (23,763) 31,237 $31,237 Other 0 $0 Total $55,000 $23,763 $31,237 $0 $31,237 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 93 Major Capital Equipment Capital Projects Vac-con Replacement (Unit 5522) FS1911 PROJECT DESCRIPTION&JUSTIFICATION This is the replacement of a 2004 Ford Sterling Vac-con truck Unit 5522 assigned to the Public Works Utility Division. Estimated cost of the truck is$395,000. When replaced, the truck will be 15 years old. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2018 11/2018 Land/ROW Acquisition Construction 12/2018 06/2019 Other REVISION EXPLANATION This project was completed and savings was identified that was released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES CO Bonds $402,000 ($5); $401,995 $401,995 0 $0 0 $0 0 $0 0 $0 Total 1 $402,000 $5 $401,9951 $0 $401,995 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 402,000 (5) 401,995 $401,995 Other 0 $0 Total $402,000 $5 $401,995 $0 $401,995 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 94 Major Capital Equipment Capital Projects Backhoe Replacement(Unit 483) FS2002 PROJECT DESCRIPTION&JUSTIFICATION This is for the purchase of a new backhoe to replace unit 483, a 2005 year-model Komatsu utilized by the Public Works Department. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2019 11/2019 Land/ROW Acquisition Construction 11/2019 05/2020 Other REVISION EXPLANATION This project was completed and savings was identified that was released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES CO Bonds $140,000 ($36,000), $104,000 $104,000 0 $0 0 $0 0 $0 0 $0 Total $140,000 $36 000 $104,0001 $0 $104,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 140,000 (36,000) 104,000 $104,000 Other 0 $0 Total $140,000 1 ($36,000)1 $104,000 $0 $104,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 95 Major Capital Equipment Capital Projects Backhoe Replacement(Unit 5525) FS2003 PROJECT DESCRIPTION&JUSTIFICATION This is for the purchase of a new backhoe to replace unit 483, a 2005 year-model Komatsu utilized by the Public Works Department. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2019 11/2019 Land/ROW Acquisition Construction 11/2019 05/2020 Other REVISION EXPLANATION This project was completed and savings was identified that was released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES CO Bonds $140,000 ($38,600) $101,400 $101,400 0 $0 0 $0 0 $0 0 $0 Total $140,000 $38 600 $101,4001 $0 $101,400 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 140,000 (38,600) 101,400 $101,400 Other 0 $0 Total $140,000 1 ($38,600)1 $101,400 $0 $104,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 96 Major Capital Equipment Capital Projects Utility Tractor Replacement (Unit 790) FS2006 PROJECT DESCRIPTION&JUSTIFICATION This is for the purchase of a utility tractor to replace unit 790, a 1996 year-model Kubota utility tractor utilized by the Parks Department. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2019 11/2019 Land/ROW Acquisition Construction 11/2019 05/2020 Other REVISION EXPLANATION This project was completed and savings was identified that was released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Reserves $65,000 ($33,078) $31,922 $31,922 0 $0 0 $0 0 $0 0 $0 Total 1 $65 000 $33 078 $31,9221 $0 $31,922 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 65,000 (33,078) 31,922 $31,922 Other 0 $0 Total $65,000 $33,078 $31,922 $0 $31,922 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 97 Major Capital Equipment Capital Projects Wheel Loader Replacement (Unit 6602) FS2008 PROJECT DESCRIPTION&JUSTIFICATION This is for the purchase of a new wheel leader to replace unit 6602, a 2000 year-model Komatsu utilized by the Public Works Department. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2019 11/2019 Land/ROW Acquisition Construction 11/2019 05/2020 Other REVISION EXPLANATION This project was completed and savings was identified that was released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES CO Bonds $220,000 ($56,000), $164,000 $164,000 0 $0 0 $0 0 $0 0 $0 Total $220,000 $56 000 $164,0001 $0 $164,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 220,000 (56,000) 164,000 $164,000 Other 0 $0 Total $220,000 1 ($56,000)1 $164,000 $0 $164,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 98 Major Capital Equipment Capital Projects Crack Sealing Machine Replacement (Unit 6632) FS1901 PROJECT DESCRIPTION&JUSTIFICATION This is the replacement of a 2009 year model Crafco crack sealing machine assigned to the Public Works Street Division. The crack sealing machine is a specialized one-of-a-kind unit used for the preventative street maintenance program. The crack sealing machine is a self-contained trailer-mounted piece of equipment which heats and distributes crack sealant to seal and fill pavement cracks in roadways in order to prevent the intrusion of water and incompressible materials. Estimated cost of the machine is $95,000. When replaced, the machine will be 10 years old. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2018 11/2018 Land/ROW Acquisition Construction 12/2018 04/2019 Other REVISION EXPLANATION This project was completed and savings was identified that was released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Reserves $95,000 ($26,592)` $68,408 $68,408 0 $0 0 $0 0 $0 0 $0 Total 1 $95 000 $26 592 $68,4081 $0 $68,408 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 95,000 (26,592) 68,408 $68,408 Other 0 $0 Total $95,0001 ($26,592)1 $68,408 $0 $68,408 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 99 Major Capital Equipment Capital Projects Wheel Loader Replacement (685) FS2007 PROJECT DESCRIPTION&JUSTIFICATION This is for the purchase of a new wheel leader to replace unit 6602, a 2000 year-model Komatsu utilized by the Public Works Department. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE I REVISION Professional Services Engineering 10/2019 11/2019 10/2019 Land/ROW Acquisition Construction 11/2019 10/2019 05/2020 Other REVISION EXPLANATION Savings experienced from final purchase price of$77,000.00. $5,000 in savings will be shifted to FS2005 Roller to cover an overage. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Certificates of Obligation $220,000 ($5,000), $215,000 $215,000 Reserves 0 0 0 $0 0 $0 0 $0 0 $0 Total $220,000 $5 000 $215,0001 $0 $215,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 220,000 (5,000) 215,000 $215,000 Other 0 $0 Total $220,000 $5,000 "i $215,000 $0 $215,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 100 Major Capital Equipment Capital Projects Roller Replacement (6620) FS2005 PROJECT DESCRIPTION&JUSTIFICATION This is for the purchase of a new roller to replace unit 6620, a 2005 year-model Terex utilized by the Public Works Department. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2019 11/2019 10/2019 Land/ROW Acquisition Construction 11/2019 10/2019 05/2020 Other REVISION EXPLANATION Overage experienced from final purchase price of$5,000.00. Savings will be transfered from FS2007 Wheel Loader. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Reserves $65,000 $5,000 $70,000 $70,000 0 0 0 $0 0 $0 0 $0 0 $0 Total 1 $65,0001 $5,0001 $70 000 $0 1 $70,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 65,000 5,000 70,000 $70,000 Other 0 $0 Total $65,0001 $5,0001 $70,000 $0 1 $70,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 101 Major Capital Equipment Capital Projects Wheel Loader Replacement (Unit 685) FS2007 PROJECT DESCRIPTION&JUSTIFICATION This is for the purchase of a new wheel leader to replace unit 685, a 1996 year-model Case utilized by the Public Works Department. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE I REVISION Professional Services Engineering 10/2019 11/2019 Land/ROW Acquisition Construction 11/2019 05/2020 Other REVISION EXPLANATION The annual project has been completed and savings was identified that could be released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Certificates of Obligation $215,000 ($72,000), $143,000 $143,000 0 0 0 $0 0 $0 0 $0 0 $0 Total $215,000 $72 000 $143,0001 $0 $143,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 215,000 (72,000) 143,000 $143,000 Other 0 $0 Total $215,000 1 ($72,000)1 $143,000 $0 $143,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 102 Major Capital Equipment Capital Projects Dump Truck Replacement FS1903 PROJECT DESCRIPTION&JUSTIFICATION This is for the replacement of a 2004 Chevrolet Kodiak tandem dump truck Unit 6617 assigned to the Public Works Street Division. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2018 11/2018 Land/ROW Acquisition Construction 12/2018 05/2019 Other REVISION EXPLANATION FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Reserves $120,412 $0 $120,412 $120,412 0 $0 0 $0 0 $0 0 $0 Total 1 $120 412 $0 $120,4121 $0 $120,412 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 120,412 0 120,412 $120,412 Other 0 $0 Total $120,412 $0 $120,412 $0 $120,412 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 103 Major Capital Equipment Capital Projects Replacement of CAD/RMS Public Safety Software Platform IS1502 PROJECT DESCRIPTION&JUSTIFICATION Replacement of the current CAD/RMS software platform (CRIMES)with a different software and vendor. The current software (CRIMES) is not meeting the needs for Public Safety. CRIMES has proven to be improperly developed and this poor development becomes apparent when the end-users attempt to use the software. Typically, the fixes from CRIMES are implemented and tend to cause more issues for the user. The problematic software platform causes problems for all users involved in the Joint Dispatch project-North Richland Hills, Richland Hills,Watauga, and Haltom City. PROJECT STATUS ORIGINAL 2019/20 ORIGINAL 2019/20 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2014 02/2018 REVISION EXPLANATION IS1502 is completed and savings have been identified that can be utilized towards additional funding requirements in IT1702 Replacement of Enterprise Resource Planning Software. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Certificates of Obligation $3,000,000 ($61,000), $2,939,000 $2,939,000 Reserves 20,000 (20,000) 0 $0 0 $0 0 $0 0 $0 Total $3 020 000 $81 000 $2,939,000, $0 $2,939,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 0 $0 Other 3,020,000 (81,000), 2,939,000 $2,939,000 Total $3,020,000 1 ($81,000)1 $2,939,000 1 $0 $2,939,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 104 Aquatic Park Capital Projects General Facility Improvements 2019 WP1901 PROJECT DESCRIPTION&JUSTIFICATION This project consists of costs for annual general facility improvements such as drainage improvements, miscellaneous building improvements, capital acquisitions and any safety improvements or emergency repairs for the facility that are identified during the operating season. Projects in the past have included switchgear for the Green Extreme,ADA updates, replacement motors,drainage improvements, concrete repair and patching and resurfacing of the Splashatory. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2018 09/2019 Other REVISION EXPLANATION The annual project has been completed and savings was identified that could be released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRIJ REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Reserves $100,000 ($11,279)j $88,721 $88,721 0 0 0 $0 0 $0 0 $0 0 $0 Total $100,000 $11 279 $88,721 $0 $88,721 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 100,000 (11,279) 88,721 $88,721 Other 0 $0 Total $100,000 1 ($11,279)1 $88,721 1 $0 $88,721 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 105 Municipal Facility Capital Projects Overhead Door Replacement FC 1701 PROJECT DESCRIPTION&JUSTIFICATION Replace (10)overhead door assemblies at Fire Station#5. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2016 09/2019 Other REVISION EXPLANATION FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Reserves $52,000 ($1,000), $51,000 $51,000 0 $0 0 $0 0 $0 0 $0 Total 1 $52 000 $1 000 $51,0001 $0 $51,000 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 52,000 (1,000)! 51,000 $51,000 Other 0 $0 Total $52,0001 ($1,000)1 $51,000 $0 $51,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 106 Municipal Facility Capital Projects Overhead Door Safety Edges & Remote Control Assemblies FC 1702 PROJECT DESCRIPTION&JUSTIFICATION Replace safety edges,seals and remote control assemblies at$1,720 per door. Fire Station#1 eight(8)doors$13,760. Fire Station#2 six (6)doors$10,320. Fire Station#4 six (6)doors$10,320. Service Center Fleet Shop (10)doors$17,200. Facilities&Construction/Fleet Services (5)doors$8,600. Parks Operation (1)door($1,720). Traffic Division (4)doors$6,880. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2016 09/2019 Other REVISION EXPLANATION FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Reserves $68,800 ($900); $67,900 $67,900 0 $0 0 $0 0 $0 0 $0 Total 1 $68 800 $900 $67,9001 $0 $67,900 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 68,800 (900) 67,900 $67,900 Other 0 $0 Total $68,800 $900 "i $67,900 $0 $67,900 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 107 Municipal Facility Capital Projects Permanent Records Roof Replacement $ Building Envelope Seal FC 1902 PROJECT DESCRIPTION&JUSTIFICATION FC1902, Permanent Records Roof Replacement&Building Envelope Seal, savings from roofing project is requested to move to FC1904, Upgrade Remodel of Public Works Restrooms,to cover cost of undiscovered work to complete the project via change order. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2018 10/2019 09/2019 06/2020 Other REVISION EXPLANATION Project savings move to cover undiscovered work to complete the project via change order for FC1904, Upgrade Remodel of Public Works Restrooms. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Certificates of Obligation $0 $01 $0 $0 Reserves 78,000 (6,500) 71,500 $71,500 0 $0 0 $0 0 $0 Total 1 $78 000 $6 500 $71,5001 $0 $71,500 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 78,000 (6,500) 71,500 $71,500 Other 0 $0 Total $78,0001 ($6,500)1 $71,500 $0 $71,500 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 1 2019/20 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 108 Municipal Facility Capital Projects Replacement of HVAC Systems at Fire Stations #1 and #4 FC 1903 PROJECT DESCRIPTION&JUSTIFICATION This project is for the replacement of roof top HVAC units at Fire Stations#1 ($29,000)and#4 ($30,000). PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2018 09/2019 Other REVISION EXPLANATION FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Reserves $59,000 ($141)i $58,859 $58,859 0 $0 0 $0 0 $0 0 $0 Total 1 $59 000 $141 $58,8591 $0 $58,859 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 59,000 (141) 58,859 $58,859 Other 0 $0 Total $59,000 $141 $58,859 $0 $58,859 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 109 Municipal Facility Capital Projects Upgrade/Remodel of Public Works Restroom FC 1904 PROJECT DESCRIPTION&JUSTIFICATION FC1904, Upgrade remodel of Public Works Restrooms funds needed for undiscovered work to complete project. PROJECT STATUS ORIGINAL 2019/20 ORIGINAL 2019/20 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2018 01/2020 03/2019 06/2020 Other REVISION EXPLANATION Funding needed to cover undiscovered work to complete the project via change order. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Certificates of Obligation $0 $0 Reserves 75,000 6,500+ 81,500 $81,500 0 $0 0 $0 0 $0 Total 1 $75,0001 $6,5001 $81 500 $0 1 $81,500 PROJECT EXPENDITURES Professional Services $0 $0 Engineering/Design 0 $0 Land/ROW Acquistion 0 $0 Construction 75,000 6,500 81,500 $81,500 Other 0 $0 Total $75,0001 $6,5001 $81,500 $0 1 $81,500 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 1 2019/20 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 110 Economic Development Capital Projects TIF 1 Expansion - Intersection Improvements/Utility Burial ED0601 PROJECT DESCRIPTION&JUSTIFICATION This is for the purchase of a new pothole patcher to replace unit 6609, a 2002 year-model Freightliner. Estimated cost of the pothole patcher is$210,000. When replaced, the pothole patcher will be 17 years old and have an estimated odometer reading of 90,000 miles. PROJECT STATUS ORIGINAL 2019/20 ORIGINAL 2019/20 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2018 11/2018 Land/ROW Acquisition Construction 12/2018 04/2019 Other REVISION EXPLANATION This project was completed and savings was identified that was released back to fund balance. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES CO Bonds $3,000,000 ($432,715), $2,567,285 $2,567,285 0 $0 0 $0 0 $0 0 $0 Total $3,000,000 $432 715 $2,567,285, $0 $2,567,285 PROJECT EXPENDITURES Professional Services $100,000 $100,000 $100,000 Engineering/Design 450,000 450,000 $450,000 Land/ROW Acquistion 250,000 250,000 $250,000 Construction 2,200,000 (432,715) 1,767,285 $1,767,285 Other 0 $0 Total $3,000,000 $432,715 $2,567,285 1 $0 $2,567,285 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 111 Economic Development Capital Projects Loop 820 Redevelopment 2010 ED 1002 PROJECT DESCRIPTION&JUSTIFICATION The North Tarrant Express is bringing added attention and interest from the commercial development community at this key North Richland Hills intersection. This project will provide the ability to optimize accessibility and dictate uses with an emphasis on quality and impact to community.The construction costs associated with creating left turn access from southbound Rufe Snow via Corona into the southeast corner of Rufe Snow& Loop 820 is also included. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services 12/2010 09/2016 Engineering Land/ROW Acquisition 11/2009 02/2018 Construction Other REVISION EXPLANATION Project close out. Additional funds were available in capital project reserves. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Reserves $1,169,097 $45,724 $1,214,821 $1,214,821 Other 426,475 0 426,475 $426,475 0 $0 0 $0 0 $0 Total $1 595 572 $45724 $1 641 296 $0 $1 641 296 PROJECT EXPENDITURES Professional Services $100,000 $100,000 $100,000 Engineering/Design 0 $0 Land/ROWAcquistion 1,495,572 45724 1,541,296 $1,541,296 Construction 0 0 $0 Other 0 $0 Total $1,595,572 1 $45724 ii1 $1,641,296 1 $0 $1,641,296 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 112 Economic Development Capital Projects TOD Land Management ED 1503 PROJECT DESCRIPTION&JUSTIFICATION The City has established two geographic areas that are designated for high levels of growth through mass transit activities. These Transit Oriented Development(TOD)areas require the advance purchase of property to facilitate various components of mass transit which include parking, platforms, loading, unloading, etc. PROJECT STATUS ORIGINAL 2019120 ORIGINAL 2019120 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition 04/2015 04/2018 Construction Other REVISION EXPLANATION Project close out. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2019/20 REVISION 2019/20 BALANCE COST FUNDING SOURCES Reserves $1,200,000 $89,033 $1,289,033 $1,289,033 0 $0 0 $0 0 $0 0 $0 Total $1,200,000 $89,0331 $1,289,033 $0 $1,289,033 PROJECT EXPENDITURES Professional Services $30,000 $30,000 $30,000 Engineering/Design 0 $0 Land/ROWAcquistion 1,170,000 89,033 1,259,033 $1,259,033 Construction 0 $0 Other 0 $0 Total $1,200,000 1 $89,0331 $1,289,033 1 $0 1 $1,289,033 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 1 2019/20 1 2020/21 2021/22 1 2022/23 1 2023/24 1 TOTAL Projected $0 113 Summary of Changes as of August 4, 2020 in the Revised Proposed Budget Capital Project Changes Project FY20/21 Proposed Page# Project Schedule # Name Comment Change Amount Reference No additional changes made 114 Summary of Changes as of July 31, 2020 in the Revised Proposed Budget Caplta0 Project Changes Project FY2O/21 Proposed Page# Project Schedule # Name Comment Change Amount Reference Street&Sidewalk Capital Projects 1 Hightower/Davis Traffic Signal Added project $390,000 15,23 Iron Horse Boulevard Recon Funding correction $0 15, 19 Major Capital Equipment Cap Projects 7 Purchase of 7-Bin Auto Sorting System for the Library Narrative correction $0 58,60 Long Range Plans N/A N/A Removed $0 Original book Streets LRP Removed $0 15-16, Drainage LRP Removed $0 29-30 Utility LRP Removed $0 37-38 Parks&Rec LRP Removed $0 55-57 Aquatic Park LRP Removed $0 75-76 Facilities LRP Removed $0 81-82 Fleet LRP Removed $0 93-94 115 IrLp NOKTH KICHLAN HILLS CITY COUNCIL MEMORANDUM FROM: The Office of the City Manager DATE: August 13, 2020 SUBJECT: Conduct a Public Hearing on the Tax Year 2020 (Fiscal Year 2020/2021) Proposed Tax Rate. PRESENTER: Robert Myers, Budget Director SUMMARY: The City Council is requested to open a public hearing on the proposed $0.575700 per $100 of valuation tax rate and receive public comment. At the conclusion of the public comments, Council is requested to announce Monday, August 17, 2020 as the date of the vote on the adoption of the tax rate. After this announcement, Council is requested to close the public hearing. No action is required at this hearing as it is held for the purpose of receiving public comment. GENERAL DESCRIPTION: State legislation requires the City to hold one public hearing on the proposed property tax rate if the proposed rate exceeds the lower of the No-New-Revenue Tax Rate or the Voter-Approval Tax Rate. This year due to the TY 2020 Proposed tax rate of$0.575700 falling below the No-New-Revenue Tax Rate ($0.580542) and the Voter-Approval Tax Rate ($0.584901) no public hearing was required. However, in order to gather public feedback, staff recommended holding a public hearing. The vote to adopt the proposed tax rate of $0.575700 per $100 of valuation is scheduled to appear as an action item on the Monday, August 17, 2020 Council agenda for the 7.00 p.m. City Council meeting. If adopted, this will increase the tax rate by $0.003700 or 0.65%. The meeting will be held via video conference through the following video conference link [)R. . _IIyZ ,IA1�_II�IIC . The North Richland Hills City Council will conduct this meeting via video conference in order to advance the public health goal of limiting face-to-face meetings (also called "social distancing") to slow the spread of the Coronavirus (COVID-19). For more information regarding participation in this meeting, please visit www.nrhtx.com/video or contact the Budget & Research Department at 817- 427-6053. Individual taxpayers' property taxes may decrease, increase or remain the same depending on the appraised value of their property. Senior and disabled property owners that have a tax ceiling (even if their property values have increased) will pay the same amount of city property tax as the previous year unless their appraised property value decreased. IrLp NOKTH KICHLAN HILLS RECOMMENDATION: Open the public hearing on the Tax Year 2020 (Fiscal Year 2020/2021) Proposed Tax Rate, receive public comments and announce Monday, August 17, 2020 as the date of the vote on the adoption of the tax rate, and close the public hearing.