Loading...
HomeMy WebLinkAboutOrdinance 3861 ORDINANCE NO. 3861 AN ORDINANCE OF THE CITY OF NORTH RICHLAND HILLS, TEXAS, ADOPTING THE REVISED BUDGET FOR THE FISCAL YEAR OCTOBER 1, 2023, THROUGH SEPTEMBER 30, 2024, IN ACCORDANCE WITH THE CHARTER OF THE CITY OF NORTH RICHLAND HILLS, TEXAS; PROVIDING FOR THE FILING OF THE AMENDED BUDGET; PROVIDING A SEVERABILITY CLAUSE AND PROVIDING AN EFFECTIVE DATE. WHEREAS, the City of North Richland Hills is a home rule city acting under its charter adopted by the electorate pursuant to Article XI, Section 5 of the Texas Constitution and Chapter 9 of the Local Government Code; and WHEREAS, the City Manager of the City of North Richland Hills submitted a revised budget for the fiscal year beginning October 1, 2023, and ending September 30, 2024 to the City Council as required by the City Charter of the City of North Richland Hills; and WHEREAS, the City Council finds that all provisions pertaining to the approval of the revised budget contained in the City Charter and in state law have been, in all things complied with; and WHEREAS, in accordance with Section 102.001, et seq, Texas Local Government Code, the City Council determined that a public hearing should be held at a time and place which was set forth in a notice published as required by law; and WHEREAS in accordance with Article XII of the City of North Richland Hills City Charter, a notice of public hearing was placed in the Star Telegram on August 1, 2024, at least ten (10) days prior to the public hearing; and WHEREAS, such public hearing on the revised budget was duly held on August 12, 2024, and all taxpayers were given an opportunity to attend and participate in such public hearing; and WHEREAS, after full and final consideration, the City Council is of the opinion that the budget should be approved and amended; NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL, CITY OF NORTH RICHLAND HILLS, TEXAS, THAT: SECTION 1. The revised budget for the City of North Richland Hills, Texas, for the Fiscal Year beginning October 1, 2023, and ending September 30, 2024, as set forth in Attachments "A" and "B", operating and capital project budgets for FY 2023/2024 is hereby amended and approved. Ordinance No.3861 Page 1 of 3 SECTION 2. The revised budget for Fiscal Year 2023/2024 is on file with the City Secretary in accordance with state law and the City Charter. SECTION 3. The City Manager is hereby authorized to make inter-departmental and inter-fund transfers during the fiscal year as deemed necessary in order to avoid over-expenditure of particular accounts. SECTION 4. The City Manager, or their designee, is hereby authorized to invest any funds not needed for current use in any lawful manner. Interest accrued from investments shall be deposited to the interest income account of the funds from which the principal was invested. SECTION 5. This ordinance shall be cumulative of all provisions of ordinances and of the Code of Ordinances, City of North Richland Hills, Texas, as amended, except where the provisions are in direct conflict with the provisions of other ordinances, in which event the conflicting provisions of the other ordinances are hereby repealed. SECTION 6. It is hereby declared to be the intention of the City Council that the phrases, clauses, sentences, paragraphs and sections of this ordinance are severable, and if any phrase, clause, sentence, paragraph or section of this ordinance shall be declared unconstitutional by the valid judgment or decree of any court of competent jurisdiction, such unconstitutionality shall not affect any of the remaining phrases, clauses, sentences, paragraphs and sections of this ordinance, since the same would have been enacted by the City Council without the incorporation in this ordinance of any such unconstitutional phrase, clause, sentence, paragraph or section. SECTION 7. This ordinance shall be in full force and effect from and after its passage. AND IT IS SO ORDAINED. PASSED AND APPROVED on this 12th day of August, 2024. CITY OF NORTH RICHLAND HILLS 4Z € k McCarty, Mayor Ordinance No.3861 Page 2 of 3 ATTEST: KZ v (/jOe(Areo)iiiitz' — yy a w Traci Henderson Assistant City Secretary �'3';; ��/ , APP OVED AS TO FORM AND LEGALITY: II Q ( ' it�� Cara Leahy White, In rim City A orney APPROVED AS TO CONTENT: (✓- Chase Fosse, Director of Budget & Research Ordinance No.3861 Page 3 of 3 FISCAL YEAR 2024-2025 SCHEDULE 1-SUMMARY OF REVENUES AND EXPENDITURES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES Taxes $40,902,426 $44,951,422 $45,914,658 $44,118,881 Fines&Forfeitures 1,974,887 1,320,238 1,226,816 1,087,970 Licenses&Permits 2,796,060 1,711,676 1,832,053 2,685,574 Charges for Service 3,132,961 3,594,231 3,016,965 3,626,939 Intergovernmental 5,292,770 5,350,477 5,500,923 5,502,575 Miscellaneous 1,996,004 4,855,401 2,566,092 2,931,931 TOTAL REVENUES $56,095,108 $61,783,445 $60,057,507 $59,953,870 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $39,000 $0 $0 $0 SUB-TOTAL APPROPRIATIONS $39,000 $0 $0 $0 TOTAL RESOURCES $56,134,108 $61,783,445 $60,057,507 $59,953,870 EXPENDITURES City Council $101,945 $102,148 $134,472 $142,398 City Manager 822,375 858,186 896,480 889,988 Communications 446,324 479,065 498,092 488,722 City Secretary 468,601 667,740 646,346 639,014 Legal 641,344 655,658 708,068 704,760 Human Resources 131,522 185,273 165,604 164,023 Finance 796,999 860,034 880,779 867,139 Budget&Research 415,013 485,229 508,378 509,282 Municipal Court 1,432,484 1,502,023 1,541,440 1,537,969 Development Services 1,348,934 1,450,025 1,544,576 1,522,193 Economic Development 367,645 369,553 396,153 391,315 Library 2,294,275 2,454,987 2,563,061 2,530,774 Neighborhood Services 2,117,249 2,356,355 2,429,905 2,397,229 Public Works 3,097,171 3,421,820 3,614,455 3,658,698 Parks&Recreation 1,925,006 1,975,652 2,053,265 2,049,271 Police 17,007,871 17,532,010 18,437,343 18,298,210 Fire 14,842,737 15,773,229 16,820,899 17,031,243 Building Services 812,101 899,730 899,730 899,730 Non-Departmental 1,267,858 2,760,654 4,053,250 3,948,729 SUB-TOTAL DEPARTMENTS $50,337,455 $54,789,369 $58,792,296 $58,670,687 RESERVES&OTHER EXPENDITURES Planned Contribution to Fund Balance $0 $0 $16,851 $151,116 Capital Project Transfers 2,953,693 1,589,512 1,116,293 1,000,000 Operational Transfers 296,555 190,848 132,067 132,067 SUB-TOTAL RESERVES AND OTHER $3,250,248 $1,780,360 $1,265,211 $1,283,183 TOTAL EXPENDITURES $53,587,703 $56,569,729 $60,057,507 $59,953,870 BALANCE $2,546,405 $5,213,716 $0 $0 Ordinance No.3861 Attachment"A" Page 1 of 28 FISCAL YEAR 2024-2025 SCHEDULE 2-SUMMARY OF REVENUES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 TAXES Current Property Taxes $22,051,012 $25,391,158 $26,093,764 $25,423,967 Delinquent Property Taxes (55,587) 33 50,000 (300,000) Penalty and Interest 264,424 80,226 180,000 79,500 Recalculated Property Taxes 0 0 0 (517,500) Franchise Fees 3,633,715 3,857,529 3,761,371 3,653,602 Utility Fund Franchise Taxes 1,233,378 1,243,806 1,210,201 1,210,201 Sales Taxes 13,219,393 13,819,833 14,076,000 14,025,789 Mixed Beverages 150,849 159,615 144,100 144,100 Payment in Lieu of Taxes 405,242 399,222 399,222 399,222 SUB-TOTAL $40,902,426 $44,951,422 $45,914,658 $44,118,881 FINES AND FORFEITURES Municipal Court Fines $1,812,597 $1,212,614 $1,116,816 $987,902 Warrant&Arrest Fees 162,290 107,613 110,000 100,068 SUB-TOTAL $1,974,887 $1,320,238 $1,226,816 $1,087,970 LICENSES AND PERMITS Building Permits $1,451,291 $793,652 $800,000 $1,525,000 Electrical Permits 147,663 81,791 100,000 100,000 Plumbing Permits 157,266 92,834 100,000 152,192 Mechanical Permits 161,754 132,055 110,000 160,000 Miscellaneous Permits 252,755 114,248 142,300 115,500 Certificate of Occupancy 12,882 10,620 12,000 9,000 Plan/Review/Application Fee 40,768 5,496 25,921 12,920 Apartment Inspection Fees 114,954 115,654 122,800 122,800 Curb&Drainage Inspection Fees 60,457 4,960 38,932 75,428 Re-Inspection Fees 16,019 23,683 6,000 26,000 License Fees 6,700 760 8,600 12,100 Fire Inspection 27,475 0 20,000 20,000 Gas Well Inspection 56,000 56,000 56,000 56,000 Food Service Permits 174,919 176,561 180,000 203,134 Food Managers School 2,789 4,078 2,500 2,500 Animal License/Adoption Fees 31,914 14,997 25,000 16,500 Animal Control Impoundment 10,900 6,035 13,000 7,500 Auto Impoundment Fees 6,285 20,198 9,000 9,000 Burglar Alarm Permits 63,268 58,055 60,000 60,000 SUB-TOTAL $2,796,060 $1,711,676 $1,832,053 $2,685,574 CHARGES FOR SERVICE Park Facility Rental $0 $0 $500 $500 Ambulance Fees 2,016,259 2,490,862 2,106,400 2,744,251 Ambulance Supplemental Program 312,111 203,991 250,000 250,000 Garbage Billing 550,000 579,986 550,000 550,000 Recreation Fees 13,295 12,682 11,700 11,700 Athletic Revenue 0 1,625 0 0 Recreation Special Events 13,541 16,938 9,500 9,500 Planning&Zoning Fees 190,755 186,147 25,000 25,000 Sale of Accident Reports 4,071 3,097 5,000 5,000 Mowing 19,609 95,356 44,000 17,000 Fire Dept Certification/CPR Citizen Class 3,285 2,975 4,765 3,888 Miscellaneous 10,036 572 10,100 10,100 SUB-TOTAL $3,132,961 $3,594,231 $3,016,965 $3,626,939 Ordinance No.3861 Attachment"A" Page 2 of 28 FISCAL YEAR 2024-2025 SCHEDULE 2-SUMMARY OF REVENUES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 INTERGOVERNMENTAL Indirect Costs: Utility Fund $2,323,713 $2,182,170 $2,182,176 $2,182,176 Park&Rec Facilities Dev.Corp. 469,207 501,201 551,249 551,249 Crime Control District 33,890 31,994 82,042 82,042 Consolidation Reimbursements 2,465,960 2,635,113 2,685,456 2,687,108 SUB-TOTAL $5,292,770 $5,350,477 $5,500,923 $5,502,575 MISCELLANEOUS Interest Income $302,934 $1,443,449 $845,345 $1,301,712 Radio Reimbursement 246,270 292,334 293,128 195,863 Lease Income 313,312 258,889 200,000 200,000 Grant Proceeds 362,042 2,102,813 656,000 656,000 Fleet Service Fund Reimbursement 446,552 467,112 391,050 391,050 Teen Court Reimbursement 20,653 12,988 12,988 12,988 Other Income 246,145 210,497 107,581 114,318 Public Safety Reimbursements 58,097 67,318 60,000 60,000 SUB-TOTAL $1,996,004 $4,855,401 $2,566,092 $2,931,931 APPROPRIATION-FUND BALANCE Appropriation of Fund Balance $39,000 $0 $0 $0 SUB-TOTAL $39,000 $0 $0 $0 TOTAL REVENUES $56,134,110 $61,783,445 $60,057,507 $59,953,870 Ordinance No.3861 Attachment"A" Page 3 of 28 FISCAL YEAR 2024-2025 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 EXPENDITURES City Council $101,945 $102,148 $134,472 $142,398 City Manager's Office City Manager's Office Administration $822,375 $858,186 $896,480 $889,988 Emergency Management 0 0 0 0 Total City Manager's Office $822,375 $858,186 $896,480 $889,988 Communications Public Information $282,811 $324,246 $339,410 $336,343 Citicable 163,513 154,819 158,682 152,379 Total Communications $446,324 $479,065 $498,092 $488,722 City Secretary City Secretary $351,844 $545,013 $487,345 $481,936 Record Management 116,757 122,728 159,001 157,078 Total City Secretary $468,601 $667,740 $646,346 $639,014 Legal $641,344 $655,658 $708,068 $704,760 Human Resources $131,522 $185,273 $165,604 $164,023 Finance Accounting&Administration $505,431 $550,832 $561,058 $552,345 Purchasing 291,568 309,202 319,721 314,794 Total Finance $796,999 $860,034 $880,779 $867,139 Budget&Research Budget $415,013 $485,229 $508,378 $509,282 Total Budget&Research $415,013 $485,229 $508,378 $509,282 Municipal Court Administration/Prosecution $887,465 $989,442 $975,283 $978,233 Warrant Division 431,849 355,465 407,752 402,345 Teen Court 113,170 112,916 34,746 35,296 Code Court 0 44,200 123,659 122,095 Total Municipal Court $1,432,484 $1,502,023 $1,541,440 $1,537,969 Development Services Inspections and Permitting $1,021,369 $1,042,775 $1,113,206 $1,096,985 Planning and Zoning 327,566 407,250 431,370 425,208 Total Planning and Development $1,348,934 $1,450,025 $1,544,576 $1,522,193 Economic Development $367,645 $369,553 $396,153 $391,315 Library General Services $433,864 $468,267 $463,751 $458,166 Public Services 984,245 1,055,348 1,088,884 1,078,403 Technical Services 876,167 931,372 1,010,426 994,205 Total Library $2,294,275 $2,454,987 $2,563,061 $2,530,774 Ordinance No.3861 Attachment"A" Page 4 of 28 FISCAL YEAR 2024-2025 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 Neighborhood Services Neighborhood Resources $378,073 $480,680 $512,755 $511,369 Animal Services 852,518 930,860 940,936 926,646 Consumer Health 372,714 376,960 404,659 398,895 Code Compliance 513,944 567,855 571,555 560,319 Total Neighborhood Services $2,117,249 $2,356,355 $2,429,905 $2,397,229 Public Works General Services $306,150 $268,909 $342,590 $338,446 Traffic Control 1,092,799 1,199,540 1,278,155 1,360,678 Street&Drainage 1,698,221 1,953,372 1,993,710 1,959,574 Total Public Works $3,097,171 $3,421,820 $3,614,455 $3,658,698 Parks&Recreation General Services $123,261 $120,481 $149,515 $148,195 Parks Maintenance 998,338 1,021,053 1,047,343 1,049,718 Recreation Services 487,102 487,102 487,102 487,102 Athletic Program Services 1 0 0 0 Senior Adult Services 290,515 315,582 326,502 321,453 Youth Outreach&Cultural 25,791 31,433 42,803 42,803 Total Parks&Recreation $1,925,006 $1,975,652 $2,053,265 $2,049,271 Police General Services $1,503,668 $1,595,264 $1,313,626 $1,303,650 Administrative Services 780,942 808,863 896,122 917,230 Criminal Investigations 3,132,653 3,007,100 3,336,102 3,293,919 Uniform Patrol 6,533,674 6,616,721 7,364,869 7,356,467 Detention Services 1,877,586 1,932,670 1,968,873 1,917,181 Property Evidence 637,103 631,310 586,927 581,950 Communications 2,542,245 2,940,081 2,970,824 2,927,813 Total Police $17,007,871 $17,532,010 $18,437,343 $18,298,210 Fire Department General Services $424,361 $502,223 $524,574 $527,520 Operations 11,164,128 11,708,644 12,345,067 12,191,350 Emergency Medical 1,904,432 2,155,142 2,264,519 2,543,784 Fire Inspections 559,520 615,686 786,631 778,882 Emergency Management 790,296 791,533 900,108 989,707 Total Fire $14,842,737 $15,773,229 $16,820,899 $17,031,243 Building Services $812,101 $899,730 $899,730 $899,730 Non Departmental $1,267,858 $2,760,654 $4,053,250 $3,948,729 SUB-TOTAL DEPARTMENTS $50,337,455 $54,789,369 $58,792,296 $58,670,687 Ordinance No.3861 Attachment"A" Page 5 of 28 FISCAL YEAR 2024-2025 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 RESERVES&OTHER EXPENDITURES Operational Transfers Transfer to Information Technology Fund $296,555 $190,848 $97,011 $97,011 Transfer to Court Spec Rev Fund 0 0 35,056 35,056 Operational Transfers Total $296,555 $190,848 $132,067 $132,067 Capital Project Transfers General Capital Project Transfers $103,693 $589,512 $116,293 $0 Street&Sidewalk Capital Project Transfers 2,850,000 1,000,000 1,000,000 1,000,000 Capital Project Transfers Total $2,953,693 $1,589,512 $1,116,293 $1,000,000 Planned Contribution to Fund Balance General Fund Reserves $0 $0 $16,851 $151,116 Contribution to Fund Balance Total $0 $0 $16,851 $151,116 TOTAL RESERVES&OTHER EXPENDITURES $3,250,248 $1,780,360 $1,265,211 $1,283,183 TOTAL EXPENDITURES $53,587,703 $56,569,728 $60,057,507 $59,953,870 BALANCE $2,546,406 $5,213,717 $0 $0 Ordinance No.3861 Attachment"A" Page 6 of 28 FISCAL YEAR 2024-2025 SCHEDULE 5-SUMMARY OF REVENUES AND EXPENDITURES GENERAL DEBT SERVICE FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY2021/22 FY2022123 FY2023/24 FY2023/24 REVENUES PROPERTY TAXES General Debt Service Taxes $11,541,403 $12,718,118 $12,714,307 $12,714,307 PROPERTY TAXES $11,541,403 $12,718,118 $12,714,307 $12,714,307 TRANSFER-IN Drainage Utility $219,200 $203,975 $189,213 $189,213 Park&Rec.Facilities Dev.Corp 452,505 442,005 431,505 431,505 Fleet Services Fund 243,300 234,300 225,300 225,300 TOTAL TRANSFER-IN $915,005 $880,280 $846,018 $846,018 OTHER REVENUES Interest Income $19,618 $86,659 $60,000 $100,730 City of Watauga,CIP Participation 63,068 63,068 60,352 60,352 Excess Collection 0 789,512 1,539,558 1,539,558 TOTAL OTHER REVENUES $82,686 $939,239 $1,659,910 $1,700,640 TOTAL REVENUES $12,539,094 $14,537,637 $15,220,235 $15,260,965 APPROPRIATION OF FUND BALANCE General Fund Fund Balance $0 $0 $0 $0 Appropriation of Fund Balance 0 0 0 0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $0 TOTAL RESOURCES $12,539,094 $14,537,637 $15,220,235 $15,260,965 EXPENDITURES DEBT EXPENDITURES Existing Bonds&C.O.'s $12,521,720 $14,389,522 $15,160,235 $15,160,235 Issuance Costs/Paying Agent Fees 980 (9,120) 6,075 6,075 Bond Defeasance/Refunding 0 0 0 0 TOTAL EXPENDITURES $12,522,700 $14,380,402 $15,166,310 $15,166,310 BALANCE $16,395 $157,235 $53,925 $94,655 Ordinance No.3861 Attachment"A" Page 7 of 28 FISCAL YEAR 2023-2024 SCHEDULE 7-SUMMARY OF REVENUES AND EXPENDITURES TAX INCREMENT FINANCING FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES PROPERTY TAXES City of North Richland Hills $10,442 $21,307 $34,590 $34,590 Tarrant County 3,808 7,521 11,860 11,860 TOTAL PROPERTY TAXES $14,251 $28,828 $46,450 $46,450 OTHER FUNDING SOURCES Investment Income $0 $13,104 $0 $0 TOTAL OTHER FUNDING SOURCES $0 $13,104 $0 $0 TOTAL REVENUES $14,251 $41,932 $46,450 $46,450 EXPENDITURES Public Improvement District Contribution $13,104 $14,992 $22,100 $22,100 Contribution to Fund Balance 0 0 24,350 24,350 TOTAL EXPENDITURES $13,104 $14,992 $46,450 $46,450 BALANCE $1,147 $26,940 $0 $0 Ordinance No.3861 Attachment"A" Page 8 of 28 FISCAL YEAR 2024-2025 SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES OPERATING Sales Tax $6,609,698 $6,909,918 $7,038,000 $7,012,895 Tennis Center Revenue 493,640 531,249 491,725 604,500 Athletic Program Revenue 146,750 111,640 183,400 140,000 Youth Association Fees 21,357 21,174 16,300 16,300 Park Impact Fees 69,574 12,154 75,000 75,000 Other Income 21,194 215,376 111,700 320,439 TOTAL OPERATING $7,362,213 $7,801,509 $7,916,125 $8,169,134 NRH CENTRE Memberships/Drop-In Passes $1,418,802 $1,565,128 $1,550,000 $1,550,000 Fitness 409,435 461,293 437,000 479,600 Recreation/Sports 387,504 441,095 543,000 457,000 Grand Hall Rental 481,686 501,898 427,500 475,400 Catering&Event Fees 22,297 27,887 20,000 25,000 Aquatic Programs 229,641 248,975 240,000 245,000 Pool Rental 2,565 4,705 5,000 5,000 Gym Rental 200 60 0 0 Concessions/Merchandise 37,157 47,563 50,000 50,000 Special Events 9,180 10,500 10,000 11,798 Other 34,169 120,947 65,867 103,349 General Fund 487,102 487,102 487,102 487,102 Park Fund 0 0 0 0 TOTAL NRH CENTRE $3,519,738 $3,917,154 $3,835,469 $3,889,249 TOTAL REVENUES $10,881,951 $11,718,663 $11,751,594 $12,058,383 APPROPRIATION OF FUND BALANCE Appropriation of Park Impact Fee Reserves $0 $0 $0 $0 Appropriation of NRH Centre Reserves 0 0 369,592 391,682 Appropriation of Sales Tax Reserves 0 0 0 0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $369,592 $391,682 TOTAL RESOURCES $10,881,951 $11,718,663 $12,121,186 $12,450,065 Ordinance No.3861 Attachment"A" Page 9 of 28 FISCAL YEAR 2024-2025 SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 EXPENDITURES OPERATING Park Facilities Development Admin. $728,514 $760,641 $736,144 $727,350 Parks&Public Grounds 2,027,206 2,112,482 2,302,646 2,338,620 Athletic Program Services 167,687 151,109 240,205 171,514 Tennis Center Operations 635,605 642,095 608,477 700,127 Non-Departmental 52,385 75,567 112,908 124,102 TOTAL OPERATING $3,611,397 $3,741,895 $4,000,380 $4,061,713 NRH CENTRE Center Management $926,763 $1,033,342 $1,061,944 $1,079,845 Fitness 399,026 393,344 383,543 392,458 Building Operations 231,098 306,901 270,936 277,630 Aquatic 775,242 803,528 811,805 819,860 Recreation Sports 294,591 356,745 381,700 391,850 Grand Hall 299,902 343,773 343,370 340,314 Building Services 275,090 315,123 414,017 414,017 TOTAL NRH CENTRE $3,201,712 $3,552,756 $3,667,315 $3,715,974 OTHER&RESERVES Debt Service $470,035 $442,005 $441,958 $431,505 Indirect Costs 503,097 501,201 551,249 551,249 Transfers Parks Capital Projects 644,000 1,168,000 1,472,746 1,494,795 Parks NRH Centre 0 200 0 0 Aquatic Park Capital Projects 0 0 0 0 Impact Fee Capital Projects 297,075 0 0 0 Economic Development Transfer 165,242 172,748 175,950 175,322 Planned Contribution to Fund Balance Parks Fund Reserves 0 0 1,736,588 1,944,507 NRH Centre Fund Reserves 318,026 0 0 0 Impact Fee Reserves 69,574 0 75,000 75,000 TOTAL OTHER&RESERVES $2,467,049 $2,284,154 $4,453,491 $4,672,378 TOTAL EXPENDITURES $9,280,158 $9,578,805 $12,121,186 $12,450,065 BALANCE $1,601,793 $2,139,859 $0 $0 Ordinance No.3861 Attachment"A" Page 10 of 28 FISCAL YEAR 2024-2025 SCHEDULE 9-SUMMARY OF REVENUES AND EXPENDITURES CRIME CONTROL DISTRICT ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES Sales Tax $6,570,113 $6,890,538 $7,011,508 $7,011,454 Franchise Tax 122,254 156,571 123,725 140,778 Interest Income 20,718 97,384 40,576 55,724 SRO Reimbursement(BISD) 327,419 325,546 340,168 340,168 Other 213,231 129,488 83,185 83,185 TOTAL REVENUES $7,253,736 $7,599,527 $7,599,162 $7,631,309 APPROPRIATION OF FUND BALANCE Contribution from the General Fund $0 $0 $0 $0 Appropriation of Fund Balance 0 0 112,928 155,829 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $112,928 $155,829 TOTAL RESOURCES $7,253,736 $7,599,527 $7,712,090 $7,787,138 EXPENDITURES OPERATING EXPENDITURES Administration $15,013 $18,630 $17,978 $18,645 Community Resources 1,064,393 1,401,535 1,141,034 1,173,513 Victim Assistance Program 82,280 27,444 28,575 28,968 Investigations 468,927 571,629 727,141 723,805 Uniform Patrol 3,294,107 3,795,091 4,374,110 4,337,499 Technical Services 543,446 556,834 575,325 562,371 Property Evidence 118,970 130,625 49,875 105,409 Partner Agency Funding 37,001 44,278 60,497 65,187 Non-Departmental 127,153 1,098,134 655,513 689,699 TOTAL OPERATING EXPENDITURES $5,751,289 $7,644,200 $7,630,048 $7,705,096 OTHER&RESERVES Operating Transfers $33,890 $76,959 $82,042 $82,042 Capital Project Transfers 672,925 0 0 0 Planned Contribution to Fund Balance 0 0 0 0 TOTAL OTHER&RESERVES $706,815 $76,959 $82,042 $82,042 TOTAL EXPENDITURES $6,458,105 $7,721,160 $7,712,090 $7,787,138 BALANCE $795,631 ($121,632) $0 $0 Ordinance No.3861 Attachment"A" Page 11 of 28 FISCAL YEAR 2024-2025 SCHEDULE 10-SUMMARY OF REVENUES AND EXPENDITURES MUNICIPAL COURT SPECIAL REVENUE FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES Court Fees $0 $0 $10,800 $10,800 Municipal Court Technology Fee 0 0 32,025 25,547 Municipal Court Building Security Fee 0 0 40,000 30,989 Local Truancy Prevention/Diversion Fee 0 0 40,000 34,743 Other 0 0 35,056 73,127 TOTAL OPERATING REVENUES $0 $0 $157,881 $175,206 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $116,426 $84,459 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $116,426 $84,459 TOTAL RESOURCES $0 $0 $274,307 $259,665 EXPENDITURES OPERATING EXPENDITURES Warrant Division $0 $0 $98,786 $96,865 Teen Court Division 0 0 86,721 84,800 Court IT Technology/Equipment 0 0 78,000 78,000 TOTAL OPERATING EXPENDITURES $0 $0 $263,507 $259,665 OTHER&RESERVES Planned Contributions to Fund Balance $0 $0 $10,800 $0 TOTAL OTHER&RESERVES $0 $0 $10,800 $0 TOTAL EXPENDITURES $0 $0 $274,307 $259,665 BALANCE $0 $0 $0 $0 Ordinance No.3861 Attachment"A" Page 12 of 28 FISCAL YEAR 2024-2025 SCHEDULE 11-SUMMARY OF REVENUES AND EXPENDITURES PUBLIC,EDUCATIONAL,AND GOVERNMENTAL ACCESS CHANNELS"PEG"SPECIAL REVENUE FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES PEG Fees $0 $0 $115,000 $115,000 Other 0 0 15,000 37,140 TOTAL OPERATING REVENUES $0 $0 $130,000 $152,140 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $0 $0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $0 TOTAL RESOURCES $0 $0 $130,000 $152,140 EXPENDITURES OPERATING EXPENDITURES Equipment Expenses $0 $0 $54,685 $39,800 Transfer to IT Capital 0 0 0 0 TOTAL OPERATING EXPENDITURES $0 $0 $54,685 $39,800 OTHER&RESERVES Planned Contributions to Fund Balance $0 $0 $75,315 $112,340 TOTAL OTHER&RESERVES $0 $0 $75,315 $112,340 TOTAL EXPENDITURES $0 $0 $130,000 $152,140 BALANCE $0 $0 $0 $0 Ordinance No.3861 Attachment"A" Page 13 of 28 FISCAL YEAR 2024-2025 SCHEDULE 12-SUMMARY OF REVENUES AND EXPENDITURES PROMOTIONAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES Occupancy Tax Proceeds $328,965 $312,158 $350,000 $350,000 Interest Income 7,522 40,052 19,375 42,315 Other 1,221 0 0 0 TOTAL OPERATING REVENUES $337,707 $352,210 $369,375 $392,315 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $29,041 $0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $29,041 $0 TOTAL RESOURCES $337,707 $352,210 $398,416 $392,315 EXPENDITURES OPERATING EXPENDITURES Economic Development $124,781 $131,664 $190,893 $140,502 Cultural&Leisure 142,476 148,288 205,858 203,553 Non-Departmental 316 192 1,665 1,576 TOTAL OPERATING EXPENDITURES $267,573 $280,143 $398,416 $345,631 OTHER&RESERVES Planned Contributions to Fund Balance $0 $0 $0 $46,684 TOTAL OTHER&RESERVES $0 $0 $0 $46,684 TOTAL EXPENDITURES $267,573 $280,144 $398,416 $392,315 BALANCE $70,134 $72,066 $0 $0 Ordinance No.3861 Attachment"A" Page 14 of 28 FISCAL YEAR 2024-2025 SCHEDULE 13-SUMMARY OF REVENUES AND EXPENDITURES DONATIONS FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES Parks&Recreation Program Donations $56,704 $78,385 $52,800 $87,775 Library Program Donations 43,815 42,169 44,800 44,800 Neighborhood Services Program Donations 75,816 76,785 86,800 99,800 Public Safety Program Donations 3,650 8,950 25,350 25,350 Teen Court Program Donations 2,078 3,354 4,041 4,125 Investment Income 6,570 33,283 9,215 35,099 TOTAL REVENUES $188,632 $242,927 $223,006 $296,949 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $0 $13,901 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $13,901 TOTAL RESOURCES $188,632 $242,927 $223,006 $310,850 EXPENDITURES OPERATING EXPENDITURES Parks&Recreation Programs $38,377 $41,491 $80,500 $124,739 Library Programs 34,521 36,138 53,391 53,391 Neighborhood Services Programs 85,407 78,859 56,000 83,000 Public Safety Programs 26,917 9,148 18,720 18,720 Teen Court Program 0 4,000 4,000 4,000 TOTAL OPERATING EXPENDITURES $185,222 $169,637 $212,611 $283,850 OTHER&RESERVES Capital Project Transfers $5,000 $0 $0 $27,000 Planned Contribution to Fund Balance 0 0 0 0 TOTAL OTHER&RESERVES $5,000 $0 $0 $27,000 TOTAL EXPENDITURES $190,222 $169,637 $212,611 $310,850 BALANCE ($1,590) $73,290 $10,395 $0 Ordinance No.3861 Attachment"A" Page 15 of 28 FISCAL YEAR 2024-2025 SCHEDULE 14-SUMMARY OF REVENUES AND EXPENDITURES SPECIAL INVESTIGATIONS FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES Federal Forfeited Funds $98,750 $81,177 $50,000 $50,000 State Forfeited Funds 10,240 35,591 35,000 35,000 Local Forfeited Funds 688 1,353 1,000 1,000 AFIS Program Revenues 0 14,424 11,175 11,175 Other Income 0 21,144 6,375 21,006 TOTAL REVENUES $109,679 $153,688 $103,550 $118,181 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $172,350 $158,812 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $172,350 $158,812 TOTAL RESOURCES $109,679 $153,688 $275,900 $276,993 EXPENDITURES OPERATING EXPENDITURES Federal Forfeited Funds $41,103 $133,888 $175,000 $173,900 State Forfeited Funds 35,323 1,676 85,000 85,000 Local Forfeited Fund 0 0 1,000 2,100 AFIS Maintenance&Equipment 14,089 13,973 14,900 15,993 TOTAL OPERATING EXPENDITURES $90,514 $149,538 $275,900 $276,993 OTHER&RESERVES Planned Contribution to Fund Balance $0 $0 $0 $0 TOTAL OTHER&RESERVES $0 $0 $0 $0 TOTAL EXPENDITURES $90,514 $149,538 $275,900 $276,993 BALANCE $19,164 $4,150 $0 $0 Ordinance No.3861 Attachment"A" Page 16 of 28 FISCAL YEAR 2024-2025 SCHEDULE 15-SUMMARY OF REVENUES AND EXPENDITURES DRAINAGE UTILITY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES Drainage Fees $1,720,723 $1,751,877 $1,725,000 $1,725,000 Interest Income 30,787 111,571 44,450 119,525 Other 820 0 0 0 TOTAL REVENUES $1,752,330 $1,863,448 $1,769,450 $1,844,525 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $0 $0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $0 TOTAL RESOURCES $1,752,330 $1,863,448 $1,769,450 $1,844,525 EXPENDITURES OPERATING EXPENDITURES Public Works Administration $399 $109,901 $191,221 $189,389 Drainage Utility Crew 92,593 147,704 190,951 187,287 Non-Departmental 1,188 1,045 5,523 5,255 Debt Service Payments 219,200 203,975 189,213 189,213 TOTAL OPERATING EXPENDITURES $313,379 $462,625 $576,908 $571,144 OTHER&RESERVES Capital Project Transfers $310,000 $2,237,000 $700,000 $700,000 Planned Contribution to Fund Balance 0 0 492,542 573,381 TOTAL OTHER&RESERVES $310,000 $2,237,000 $1,192,542 $1,273,381 TOTAL EXPENDITURES $623,379 $2,699,625 $1,769,450 $1,844,525 BALANCE $1,128,951 ($836,177) $0 $0 Ordinance No.3861 Attachment"A" Page 17 of 28 FISCAL YEAR 2024-2025 SCHEDULE 16 -SUMMARY OF REVENUES AND EXPENDITURES ECONOMIC DEVELOPMENT FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES Park Fund Transfer In $165,242 $172,748 $175,950 $175,322 Other (9,142) 23,227 19,000 36,057 TOTAL OPERATING REVENUES $156,101 $195,975 $194,950 $211,379 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $0 $0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $0 TOTAL RESOURCES $156,101 $195,975 $194,950 $211,379 EXPENDITURES OPERATING EXPENDITURES Other Expenses $0 $0 $191,000 $191,000 TOTAL OPERATING EXPENDITURES $0 $0 $191,000 $191,000 OTHER&RESERVES Planned Contributions to Fund Balance $149,023 $156,101 $3,950 $20,379 TOTAL OTHER&RESERVES $149,023 $156,101 $3,950 $20,379 TOTAL EXPENDITURES $149,023 $156,101 $194,950 $211,379 BALANCE $7,078 $39,874 $0 $0 Ordinance No.3861 Attachment"A" Page 18 of 28 FISCAL YEAR 2024-2025 SCHEDULE 17-SUMMARY OF REVENUES AND EXPENDITURES GAS DEVELOPMENT FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES Gas Royalty Revenue $1,134,010 $545,431 $600,000 $348,749 Interest Income 14,351 105,526 40,700 125,486 Other Income 0 351,459 0 0 TOTAL REVENUES $1,148,361 $1,002,416 $640,700 $474,235 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $0 $0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $0 TOTAL RESOURCES $1,148,361 $1,002,416 $640,700 $474,235 EXPENDITURES OPERATING Transfer to Capital Projects $0 $250,000 $0 $0 Miscellaneous Expenditures 40,671 0 0 0 TOTAL OPERATING EXPENDITURES $40,671 $250,000 $0 $0 OTHER&RESERVES Planned Contribution to Fund Balance $0 $0 $640,700 $474,235 TOTAL OTHER&RESERVES $0 $0 $640,700 $474,235 TOTAL EXPENDITURES $40,671 $250,000 $640,700 $474,235 BALANCE $1,107,690 $752,416 $0 $0 Ordinance No.3861 Attachment"A" Page 19 of 28 FISCAL YEAR 2024-2025 SCHEDULE 18-SUMMARY OF REVENUES AND EXPENDITURES TRAFFIC SAFETY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021122 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES Gross Fine Revenues $0 $0 $0 $0 Interest Income 6,183 28,964 14,700 25,937 TOTAL REVENUES $6,183 $28,964 $14,700 $25,937 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $27,540 $0 $125,232 $121,068 TOTAL APPROPRIATION OF FUND BALANCE $27,540 $0 $125,232 $121,068 TOTAL RESOURCES $33,723 $28,964 $139,932 $147,005 EXPENDITURES OPERATING EXPENDITURES Traffic Enforcement/Traffic Safety 0 0 37,050 37,050 Pedestrian Safety 33,723 71,908 102,882 109,955 TOTAL OPERATING EXPENDITURES $33,723 $71,908 $139,932 $147,005 OTHER&RESERVES Tranfer to Capital Projects $0 $0 $0 $0 Contribution to Reserves 0 0 0 0 TOTAL OTHER&RESERVES $0 $0 $0 $0 TOTAL EXPENDITURES $33,723 $71,908 $139,932 $147,005 BALANCE $0 ($42,943) $0 $0 Ordinance No.3861 Attachment"A" Page 20 of 28 FISCAL YEAR 2024-2025 SCHEDULE 19-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES WATER CHARGES Water Charges $27,688,553 $28,056,000 $27,076,642 $27,076,642 Water Prior Year Settle-up 728,118 1,542,944 0 1,212,095 Water Taps 52,345 23,315 52,000 37,800 Water Inspection Fees 22,707 25,217 54,500 54,500 TOTAL WATER CHARGES $28,491,723 $29,647,476 $27,183,142 $28,381,037 SEWER TREATMENT CHARGES Sewer Treatment Charges $12,958,268 $13,678,991 $14,273,721 $14,273,721 Sewer Prior Year Settle-Up 275,831 294,887 0 178,267 Sewer Taps 13,400 7,200 14,800 14,800 Sewer Inspection Fees 10,591 2,971 28,000 28,000 TOTAL SEWER TREATMENT CHARGES $13,258,090 $13,984,049 $14,316,521 $14,494,788 MISCELLANEOUS Interest Income $141,334 $677,612 $328,925 $873,825 Service Charges 124,772 117,307 128,000 128,000 Late Charges 512,354 521,887 500,000 500,000 Miscellaneous 717,790 652,288 45,000 45,000 Joint Use Reimbursement-Watauga 58,453 93,594 113,143 81,922 Subdivision Meter Revenue 58,476 35,586 60,621 45,346 TOTAL MISCELLANEOUS $1,613,179 $2,098,274 $1,175,689 $1,674,093 TOTAL REVENUE $43,362,991 $45,729,798 $42,675,352 $44,549,918 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $151,783 $0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $151,783 $0 TOTAL RESOURCES $43,362,992 $45,729,799 $42,827,135 $44,549,918 Ordinance No.3861 Attachment"A" Page 21 of 28 FISCAL YEAR 2024-2025 SCHEDULE 19-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 EXPENDITURES WATER SERVICES Water Operations $4,312,789 $3,713,512 $4,685,785 $4,728,136 Purchase of Water FTW 4,106,834 3,764,898 3,997,048 3,997,048 Purchase of Water TRA 7,677,095 8,729,334 8,081,645 8,081,645 TOTAL WATER SERVICES $16,096,718 $16,207,743 $16,764,478 $16,806,829 SEWER TREATMENT SERVICES Sewer Operations $1,443,863 $1,386,452 $1,531,787 $1,528,447 Sewer Treatment FTW 913,219 1,389,175 1,694,260 1,694,260 Sewer Treatment TRA 5,154,153 5,979,273 6,363,226 6,363,226 TOTAL SEWER TREATMENT SERVICES $7,511,235 $8,754,900 $9,589,273 $9,585,933 UTILITY BILLING&FINANCIAL SERVICES Utility Meter Reading $560,341 $590,983 $581,943 $635,454 Utility Billing&Customer Service 1,116,392 1,207,235 1,267,955 1,216,265 Utility Collection Services 261,188 244,212 259,472 256,178 Accounting Services 456,860 434,353 433,485 427,777 Budget&Research 228,515 272,731 279,714 277,100 TOTAL UTILITY BILLING&FINANCIAL $2,623,296 $2,749,515 $2,822,569 $2,812,774 OTHER OPERATING EXPENDITURES Administration $396,375 $391,389 $412,504 $409,979 Development 993,224 1,087,039 1,318,253 1,305,045 Right of Way Maintenance 293,010 271,211 329,345 354,822 Utility Construction Crew&Support 1,133,617 1,273,927 1,384,505 1,368,441 Building Services 1,822,929 1,852,138 1,852,138 1,852,138 Non Departmental 891,627 3,252,484 494,519 591,222 TOTAL OTHER OPERATING $5,530,782 $8,128,189 $5,791,264 $5,881,647 TOTAL DEPARTMENT EXPENDITURES $31,762,032 $35,840,348 $34,967,584 $35,087,183 OTHER&RESERVES Debt Service $1,656,963 $2,146,451 $2,578,904 $2,578,904 Franchise Fees 1,233,378 1,243,806 1,239,749 1,211,438 Indirect Costs 2,182,170 2,182,170 2,182,176 2,182,176 Payment in Lieu of Taxes 405,242 399,222 399,222 399,222 Transfer for IT&Support Services 175,000 175,000 209,500 209,500 Transfer to Capital 778,620 1,460,000 1,250,000 1,250,000 Planned Contribution to Fund Balance 0 0 0 1,631,495 TOTAL OTHER&RESERVES $6,431,373 $7,606,649 $7,859,551 $9,462,735 TOTAL EXPENDITURES $38,193,405 $43,446,997 $42,827,135 $44,549,918 BALANCE $5,169,586 $2,282,802 $0 $0 Ordinance No.3861 Attachment"A" Page 22 of 28 FISCAL YEAR 2024-2025 SCHEDULE 20-SUMMARY OF REVENUES AND EXPENDITURES AQUATIC PARK FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 ATTENDANCE 194,393 165,463 210,000 180,000 REVENUES OPERATING Admissions $3,813,034 $3,592,919 $4,300,284 $4,113,400 Food and Beverage 1,084,215 933,849 1,163,050 951,700 Merchandise 235,604 133,141 254,100 219,800 Rentals 175,268 208,362 357,192 333,650 TOTAL OPERATING $5,308,121 $4,868,270 $6,074,626 $5,618,550 OTHER REVENUES Interest Income $13,762 $74,696 $31,000 $61,544 Other Income 51,258 13,594 50,000 40,000 TOTAL OTHER REVENUES $65,020 $88,289 $81,000 $101,544 TOTAL REVENUES $5,373,141 $4,956,560 $6,155,626 $5,720,094 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance 0 0 0 0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $0 TOTAL RESOURCES $5,373,142 $4,956,561 $6,155,626 $5,720,094 EXPENDITURES OPERATING General Services&Utilities $800,920 $805,387 $1,046,360 $885,790 Public Grounds/Aquatics/Maint. 1,251,892 1,659,626 1,543,399 1,826,992 Business&Office Administration 343,866 334,677 450,791 458,188 Gift Shop/Concessions 750,472 803,209 930,984 959,940 Sales/Special Events/Admissions 303,859 310,267 379,323 464,329 Non-Departmental 64,369 81,324 117,032 118,799 TOTAL OPERATING $3,515,378 $3,994,490 $4,467,889 $4,714,038 OTHER&RESERVES Debt Service $711,541 $699,117 $568,001 $568,001 Debt Defeasance/Refunding/Agent Fees 969 681 4,282 550 Transfer to Capital Projects 100,000 0 375,000 375,000 Planned Contribution to Fund Balance 0 0 740,454 62,505 TOTAL OTHER&RESERVES $812,510 $699,799 $1,687,737 $1,006,056 TOTAL EXPENDITURES $4,327,888 $4,694,288 $6,155,626 $5,720,094 BALANCE $1,045,253 $262,272 $0 $0 Ordinance No.3861 Attachment"A" Page 23 of 28 FISCAL YEAR 2024-2025 SCHEDULE 21-SUMMARY OF REVENUES AND EXPENDITURES GOLF COURSE FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 ROUNDS 18,961 18,961 46,276 45,537 REVENUES OPERATING REVENUE Green Fees $1,607,624 $1,743,589 $1,882,843 $1,882,843 Pro Shop 357,489 270,864 270,306 270,306 Driving Range 141,985 138,389 135,417 135,417 Carts 352,918 338,223 405,784 405,784 Food&Beverage 652,185 699,965 688,843 688,843 Miscellaneous 12,865 6,203 0 0 TOTAL OPERATING REVENUE $3,125,066 $3,197,233 $3,383,193 $3,383,193 RESERVES&INTERFUND LOANS Appropriation of Fund Balance 0 0 0 0 TOTAL USE OF RESERVES&INTERFUND LOANS $0 $0 $0 $0 TOTAL RESOURCES $3,125,066 $3,197,233 $3,383,193 $3,383,193 EXPENDITURES OPERATING Pro Shop $168,004 $202,680 $187,167 $187,167 Pro Shop:Cost of Goods Sold 174,197 148,162 138,722 138,722 Driving Range 9,316 7,929 21,123 21,123 Golf Carts 299,341 358,599 321,944 321,944 Course Maintenance 742,411 928,066 970,355 1,044,355 Food&Beverage 259,470 299,837 299,106 299,106 Food&Beverage:Cost of Goods Sold 215,771 210,381 217,858 217,858 Sales&Membership 99,999 95,870 104,096 104,096 General&Administrative 609,139 563,721 572,540 583,867 Clubhouse 886 0 0 0 Management Fees 159,977 130,392 135,328 135,328 Equipment Repair and Replacement 51,502 0 0 0 TOTAL OPERATING $2,790,011 $2,945,635 $2,968,239 $3,053,566 OTHER&RESERVES Debt Service $321,153 $310,331 $304,415 $304,415 Transfer to Capital Projects 0 0 0 0 Planned Contribution to Reserves 0 0 110,539 25,212 TOTAL OTHER&RESERVES $321,153 $310,331 $414,954 $329,627 TOTAL EXPENDITURES $3,111,165 $3,255,966 $3,383,193 $3,383,193 BALANCE $13,901 ($58,733) $0 $0 Ordinance No.3861 Attachment"A" Page 24 of 28 FISCAL YEAR 2024-2025 SCHEDULE 22-SUMMARY OF REVENUES AND EXPENDITURES FACILITIES/CONSTRUCTION MANAGEMENT FUND ADOPTED REVISED PROPOSED ACTUAL ACTUAL BUDGET BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 FY 2023/24 REVENUES CHARGES FOR SERVICE Transfer From: General Fund $812,101 $899,730 $899,730 $899,730 $899,730 Park Development Fund 275,090 315,123 442,017 442,017 455,143 Utility Fund 1,822,929 1,852,138 1,852,138 1,852,138 1,852,138 SUB-TOTAL $2,910,120 $3,066,991 $3,193,885 $3,193,885 $3,207,011 OTHER REVENUES Interest Income $26,860 $98,436 $50,573 $94,981 $76,000 Rent From Rental Properties 22,860 0 0 0 0 Other Income 4,574 0 34,500 34,500 0 SUB-TOTAL $54,294 $98,436 $85,073 $129,481 $76,000 TOTAL REVENUES $2,964,414 $3,165,427 $3,278,958 $3,323,366 $3,283,011 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $162 $0 $255,286 $313,934 $979,746 TOTAL APPROPRIATION OF FUND BALANCE $162 $0 $255,286 $313,934 $979,746 TOTAL RESOURCES $2,964,576 $3,165,427 $3,534,244 $3,637,300 $4,262,757 EXPENDITURES OPERATING EXPENDITURES Administration $256,798 $263,338 $268,423 $264,937 $266,981 Building Services 2,642,028 2,948,710 3,214,692 3,322,842 3,053,382 Rental Property Program 34,003 15,679 0 0 0 Non-Departmental 31,746 87,922 51,129 49,521 47,727 TOTAL OPERATING EXPENDITURES $2,964,576 $3,315,649 $3,534,244 $3,637,300 $3,368,090 OTHER&RESERVES Capital Project Transfers $0 $59,000 $0 $0 $653,550 Planned Contribution to Fund Balance 0 0 0 0 0 TOTAL OTHER&RESERVES $0 $59,000 $0 $0 $653,550 TOTAL EXPENDITURES $2,964,576 $3,374,649 $3,534,244 $3,637,300 $4,021,640 BALANCE $0 ($209,222) $0 $0 $241,117 Ordinance No.3861 Attachment"A" Page 25 of 28 FISCAL YEAR 2024-2025 SCHEDULE 23-SUMMARY OF REVENUES AND EXPENDITURES FLEET SERVICES FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES CHARGES FOR SERVICE General Fund $1,389,677 $1,569,269 $1,569,269 $1,569,269 Utility Fund 2,256,325 2,514,175 2,514,175 2,514,175 Crime Control District Fund 170,426 189,903 189,903 189,903 Park&Recreation Dev.Fund 171,939 191,591 191,591 191,591 Other Funds 24,119 88,874 26,874 26,874 TOTAL CHARGES FOR SERVICE $4,012,486 $4,553,812 $4,491,812 $4,491,812 OTHER REVENUES Interest Income $34,817 $174,082 $90,431 $176,584 Sale of City Property 68,439 0 50,000 157,804 Other Income 7,241 3,675 0 0 Transfer from Utility Fund 0 0 0 0 TOTAL OTHER REVENUES $110,497 $177,757 $140,431 $334,388 TOTAL REVENUES $4,122,983 $4,731,569 $4,632,243 $4,826,200 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $0 $1,449,129 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $1,449,129 TOTAL RESOURCES $4,122,983 $4,731,569 $4,632,243 $6,275,329 EXPENDITURES OPERATING EXPENDITURES Administration $300,538 $313,599 $318,941 $312,598 Fleet Services Operations 1,837,440 1,961,353 1,841,644 2,084,368 Fire Fleet Maintenance Operations 360,864 518,780 500,837 532,538 Vehicle and Equipment Purchases 416,383 1,163,322 1,195,836 2,571,734 Non-Departmental 21,047 25,340 49,635 48,741 TOTAL OPERATING EXPENDITURES $2,936,272 $3,982,393 $3,906,893 $5,549,979 OTHER&RESERVES Debt Service $243,300 $234,300 $225,300 $225,300 Transfer to General Fund 446,552 467,112 391,050 391,050 Capital Project Transfers 135,000 0 109,000 109,000 Planned Contribution to Fund Balance 0 0 0 0 TOTAL OTHER&RESERVES $824,852 $701,412 $725,350 $725,350 TOTAL EXPENDITURES $3,761,124 $4,683,805 $4,632,243 $6,275,329 BALANCE $361,859 $47,763 $0 $0 Ordinance No.3861 Attachment"A" Page 26 of 28 FISCAL YEAR 2024-2025 SCHEDULE 24-SUMMARY OF REVENUES AND EXPENDITURES INFORMATION TECHNOLOGY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY2021/22 FY2022/23 FY2023/24 FY2023/24 REVENUES CHARGES FOR SERVICE General Fund $1,623,149 $1,977,477 $1,974,869 $1,959,984 Park Fund 228,161 267,896 272,056 272,056 Crime Control District 320,693 438,540 411,935 411,935 Utility Fund 1,218,245 1,419,161 1,428,474 1,428,474 Other Funds 394,784 467,669 468,638 529,613 TOTAL CHARGES FOR SERVICE $3,785,032 $4,570,743 $4,555,972 $4,602,062 OTHER REVENUES Transmitter Lease $205,877 $208,195 $180,000 $180,000 Transfer from General Fund 296,555 190,848 97,011 97,011 Interest Income 15,929 79,862 31,275 27,770 Other Income 28,484 4,702 4,600 10,307 TOTAL OTHER REVENUES $546,845 $483,607 $312,886 $315,088 TOTAL REVENUES $4,331,877 $5,054,350 $4,868,858 $4,917,150 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $14,489 $0 $224,780 $880,367 TOTAL APPROPRIATION OF FUND BALANCE $14,489 $0 $224,780 $880,367 TOTAL RESOURCES $4,346,366 $5,054,350 $5,093,638 $5,797,517 EXPENDITURES OPERATING EXPENDITURES General Services $428,331 $3,538,224 $4,096,658 $4,171,718 Major Computer Systems 518,677 468 0 8,995 Microcomputer Systems 1,004,668 7,164 0 0 Telecommunications 317,173 10,819 0 0 Data Network 1,207,463 34,765 0 0 GIS System 224,698 0 0 0 Public Safety 632,276 825,605 962,181 1,430,777 Non-Departmental 13,080 15,122 34,799 31,582 TOTAL OPERATING EXPENDITURES $4,346,366 $4,432,167 $5,093,638 $5,643,072 OTHER&RESERVES Transfer to Capital Projects $0 $1,462,853 $0 $129,466 Planned Contribution to Fund Balance 0 0 0 24,979 TOTAL OTHER&RESERVES $0 $1,462,853 $0 $154,445 TOTAL EXPENDITURES $4,346,366 $5,895,019 $5,093,638 $5,797,517 BALANCE $0 ($840,669) $0 $0 Ordinance No.3861 Attachment"A" Page 27 of 28 FISCAL YEAR 2024-2025 SCHEDULE 25-SUMMARY OF REVENUES AND EXPENDITURES SELF INSURANCE FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2021/22 FY 2022/23 FY 2023/24 FY 2023/24 REVENUES HEALTH&MEDICAL CONTRIBUTIONS Health&Medical(City Contribution) $10,442,223 $9,479,130 $9,528,258 $8,390,758 Health&Medical(Employee Contribution) 2,439,041 2,627,896 2,056,826 1,941,826 TOTAL HEALTH&MEDICAL CONTRIBUTIONS $12,881,264 $12,107,026 $11,585,084 $10,332,584 OTHER CONTRIBUTIONS Worker's Comp&Admin(City Contribution) $1,119,127 $1,233,834 $513,373 $513,373 Other Insurance(City Contribution) 1,057,369 1,141,803 1,743,593 1,743,593 Flexible Spending Account(Employee Contribution) 113,065 98,504 125,000 125,000 TOTAL OTHER CONTRIBUTIONS $2,289,562 $2,474,140 $2,381,966 $2,381,966 OTHER REVENUES Stop Loss Reimbursement $47,382 $111,052 $0 $411,158 Interest Income 175,391 999,976 473,371 1,035,128 Other Income 358,191 398,026 33,700 333,700 TOTAL OTHER REVENUES $580,965 $1,509,054 $507,071 $1,779,986 TOTAL REVENUES $15,751,791 $16,090,221 $14,474,121 $14,494,536 APPROPRIATION OF FUND BALANCE Self Insurance Fund Reserves $0 $0 $0 $0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $0 TOTAL RESOURCES $15,751,791 $16,090,221 $14,474,121 $14,494,536 EXPENDITURES Health&Medical $8,499,157 $10,402,926 $11,376,474 $11,376,474 Worker's Compensation 117,303 301,930 515,000 523,573 Personnel Expenses 647,500 698,733 712,040 716,290 Property,Liability,and Other Insurance 1,063,500 1,486,902 1,743,592 1,743,592 Flexible Spending Account Expense 110,156 98,369 125,000 125,000 Non-Departmental 88,550 26,575 2,015 0 TOTAL OPERATING EXPENDITURES $10,526,165 $13,015,434 $14,474,121 $14,484,929 OTHER&RESERVES Transfer to Retiree Health Care Fund $100,000 $0 $0 $0 Planned Contribution to Fund Balance 0 0 0 9,607 TOTAL OTHER&RESERVES $100,000 $0 $0 $9,607 TOTAL EXPENDITURES $10,626,165 $13,015,434 $14,474,121 $14,494,536 BALANCE $5,125,626 _ $3,074,786 $0 $0 Ordinance No.3861 Attachment"A" Page 28 of 28 r o ;t.= ` FIRS. c-,T v " • IJ.� IIChiHi!iUiii ci�nillill ' / o ,� ,i row"ris-.*,w fi 1:v - 3 n v. - '! 1". Yip' ! 1 .; _.<_ �:�. ,€N` + 1. -...__ IRevised _CápitaI • i1 (")Budget µ �. .o• o� • <, s. 7 f i'e.".y. i O°n FY20-2-3-1'24- '-' 1; _. .,„„ , 1 i _______ . ,.., .,_,.,..,,.....,,. ., „,,,,,,. ‘.., • ( *.. •.. �, ,-.4,...-„ ,-.,,,,,- _...„.-7'' ---.. %. \ /' °o°o \*; \111 01, ---,* '5''-' '. ::::1. 1103. , .e.,,...Ti .,.._7,,,s,„...4elt‘ 4;-, ' ' (n) - ----ip. V t Y Xa '�tjiofzNortltRichland GOMA 7`""` 1953 Schedule 10 2023-24 Budget Revisions Budget Summary Ordinance 3861 Attachment"B" Page 2 of 77 Adopted Budget 2023-24 Project Project Through Revision Revised Number Name 2023-24 2023-24 Budget STREET&SIDEWALK CAPITAL PROJECTS ST1102 Main St.Streetscaping&Snider St.Extension Project $2,866,050 $0 $2,866,050 ST2006 Glenview Drive East Project 3,860,000 1,858,500 5,718,500 ST2212 Main Street 1,622,315 90,534 1,712,849 ST2115 Pearl Street Reconstruction 690,000 (45,659) 644,341 ST2116 Southampton Drive Reconstruction 1,080,000 (44,875) 1,035,125 ST2301 Acts Court Retaining Wall 120,000 0 120,000 ST2103 Hightower/Davis Traffic Signal 476,000 (16,057) 459,943 CDBG23 Sao Paulo Court Reconstruction 15,000 16,057 31,057 ST2119 Stonybrooke Drive Reconstruction 870,000 (216,251) 653,749 ST2214 Kirk Lane 533,800 70,000 603,800 ST2120 Nob Hill Drive Reconstruction 820,000 (461,724) 358,276 ST2221 Post Oak Drive 680,400 380,000 1,060,400 ST2413 Post Oak Drive 632,500 321,368 953,868 ST2210 Dawn Drive 1,222,800 (93,393) 1,129,407 SD2404 Smithfield Middle School Safe Routes to School 729,889 0 729,889 SD2403 Sidewalk Rehabilitation and Replacement Project(2023-24) 50,000 0 50,000 Sub-Total $16,268,754 $1,858,500 $18,127,254 DRAINAGE CAPITAL PROJECTS DR2304 Street Drainage Improvements Project $100,000 $45,050 $145,050 DR2401 Miscellaneous Drainage Improvements(FY24) 500,000 (110,050) 389,950 DR2002 North Hills Addition-Bewley Drive Drainge Improvements 65,000 (7,260) 57,740 DR2202 Sunnybrook Addition Drainage Improvements 210,000 7,260 217,260 DR1701 Walker Branch Channel Repair(200ft South of Harwood Road) 928,130 65,000 993,130 DR2303 Meadow Lakes BFC-7 Drainage Improvements 1,012,653 0 1,012,653 DR2302 Northwest Stonybrooke Drainage Improvements 212,000 (17,457) 194,543 DR2301 Stream LB-1 Bank Restoration 325,000 17,457 342,457 Sub-Total $3,352,783 $0 $3,352,783 UTILITY CAPITAL PROJECTS UT2403 Conn Pump Station Permanent Generator $1,250,000 $250,000 $1,500,000 UT2208 Utility Generators 250,000 (250,000) 0 UT2302 Lead and Copper Service Line Assessment 775,000 (342,600) 432,400 UT1607 Walker Branch Interceptor 4,916,525 (917,637) 3,998,888 UT2304 Cellular Meter Reading Project 5,571,179 960,540 6,531,719 UT2207 Tyson 12"and 10"Sanitary Sewer By-Pass Line 1,027,525 1,184,335 2,211,860 UT1404 Motor Operated Transfer Valves 496,740 (165,137) 331,603 UT2107 Automatic Control Valve(ACV)Replacement 135,000 (64,500) 70,500 CDBG22 Paramount Street Sanitary Sewer 15,000 (15,000) 0 CDBG24 Sheridan/Garwood Sanitary Sewer Project 50,000 15,000 65,000 UT1703 Sanitary Sewer System Rehabilitation(Various Locations) 150,000 (76,165) 73,835 UT2303 Sewer Main Replacement-Lowery Lane 275,000 76,165 351,165 Sub-Total $14,911,969 $655,001 $15,566,970 PARKS&RECREATION CAPITAL PROJECTS PK2202 Timbers Park Playground Replacement with Shade $192,000 ($1,845) $190,155 PK2407 Tommy&Sue Brown Playground Replacement with Shade $300,000 $5,567 305,567 PK2303 Dr.Pillow Playground Replacement with Shade $238,000 ($3,722) 234,278 PK2402 NRH Centre Infrastructure Maintenance $50,000 $26,795 76,795 Sub-Total $780,000 $26,795 $806,795 AQUATIC PARK CAPITAL PROJECTS WP2305 NRH2O Green Extreme Replacement $5,742,014 $15,625 $5,757,639 WP2405 NRH2O Accelerator Slide Resurface 100,000 (15,625) 84,375 Sub-Total $5,842,014 $0 $5,842,014 FACILITIES CAPITAL PROJECTS FC2404 FD/PD Training and Fire Station#5 Roof and Window $557,000 $0 557,000 Replacement FC2407 Fire Station#4-Roof Replacement $255,000 $0 255,000 FC2411 NRH Centre Dectron Replacement Engineering and Construction $95,000 $16,680 111,680 FC2410 NRH Centre-Exterior Metal Panel Repair $60,000 ($16,680) 43,320 FC2200 Generator Feasibility Study and Equipment $853,000 ($25,000) 828,000 Sub-Total $1,820,000 ($25,000) $1,795,000 Schedule 10 2023-24 Budget Revisions Budget Summary Ordinance 3861 Attachment"B" Page 3 of 77 Adopted Budget 2023-24 Project Project Through Revision Revised Number Name 2023-24 2023-24 Budget MAJOR CAPITAL EQUIPMENT CAPITAL PROJECT5 IT1901 Network Replacement for Offsite City Facilities $221,167 ($125,905) $95,262 IT2410 Technology Upgrades 1,180,000 125,905 1,305,905 IT2301 Network Switches Upgrade 160,000 (3,482) 156,518 IT1701 ERP System Replacement 3,682,527 3,482 3,686,009 FS2403 2014 Hydro Excavator and Trailer(#5565)Replacement 173,500 (15,486) 158,014 FS2404 2011 Trailer Mounted Trash Pump Replacement(#5544) 69,000 15,486 84,486 IT2202 Backup Fiber for City Hall 183,100 (6,166) 176,934 1T2205 SCADA System Upgrade 60,000 6,794 66,794 IT2207 ARPA-Replace Nexus Network Switches 153,000 (628) 152,372 FS2405 Crew Cab Dump Truck Replacement(#6618) 206,000 0 206,000 FS2408 Ambulance Replacement(Unit#991) 444,000 0 444,000 FS2407 Brush Truck Replacement(#967) 281,500 0 281,500 IT2405 Network Refresh 1,300,000 0 1,300,000 Sub-Total $8,113,794 $0 68,113,794 OTHER CAPITAL PROJECTS ES2301 Neighborhood Initiative Program $36,275 ($4,144) $32,131 ES2401 Neighborhood Initiative Program 13,000 17,144 30,144 Sub-Total $49,275 $13,000 662,275 Total All Projects $51,138?589 $2,528,296 $53,666,885 SOURCES OF FUNDS General Obligation Bonds $11,631,815 $0 $11,631,815 Certificates of Obligations 13,590,500 (4,030,000) 9,560,500 Federal/State Grants 4,246,845 1,833,500 6,080,345 Reserves 21,604,429 4,711,796 26,316,225 Sales Tax 0 0 0 Other 65,000 13,000 78,000 Total Sources of Funds $51,138,589 $2,528,296 $53,666,885 Street& Sidewalk Capital Projects Ordinance 3861 Main St. Streetscaping &Snider St. Extension Project Attachment ST1102 Page 4 of 77 PROJECT DESCRIPTION&JUSTIFICATION This project reconstructs Main St, Snider St. and Center St. near the Smithfield Station. Located in the center of the Smithfield Transit Oriented Development, Main St. is an existing street that lacks pedestrian infrastructure such as sidewalks, street furniture, lighting and trees. Snider St. and Center St. both intersect with Main St. and will be reconstructed as pedestrian friendly streets(sidewalks,street furniture, lighting and trees).A majority of the funds come from an NCTCOG RTR Grant. Project funding is contingent upon NCTCOG approval and notice to proceed.The project scope also includes sidewalks along Davis Boulevard to connect Main St.to Odell St. Main St. Streetscaping&Snider St. Extension Project is designated to promote a pedestrian friendly mixed use environment adjacent to the future Smithfield Rail Station as part of the approved Smithfield TOD District.The original project utilized a sustainable development grant, but now RTR funds will be used instead to expand the scope of the project to include more infrastructure. Eighty percent of total funding will be provided as part of this approved grant. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Additional funds($130,355)are required to be transferred internal to the project from the construction budget to the professional services budget. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 ��REVISION ''' 2022/23 BALANCE COST FUNDING SOURCES Grant $2,084,149 $0 $2,084,149 $0 $2,084,149 Reserves 351,901 0 351,901 0 $351,901 Other 430,000 0 430,000 0 $430,000 0 0 0 0 $0 0 0' 0 0 $0 Total $2,866,050 $0! $2,866,050 $0 $2,866,050 PROJECT EXPENDITURES Professional Services $254,550 $130,355 $384,905 $0 $384,905 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 2,611,500 (130,355)' 2,481,145 0 $2,481,145 Other 0 0` 0 0 $0 Total $2,866,050 $0 $2,866,050 $0 $2,866,050 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Glenview Drive East Project Attachment"B" Page 5 of 77 ST2006 PROJECT DESCRIPTION&JUSTIFICATION 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. 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. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 07/2020 02/2022 Land/ROW Acquisition 11/2021 05/2022 Construction 06/2023 10/2023 12/2024 04/2025 Other REVISION EXPLANATION This revision is needed in order to reflect action taken by City Council in December 2022 and by Tarrant County in March 2023 for grant funding in the amount of$1,858,500 that was awarded for this project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES General Obligation Bonds(2003) $3,480,000 $0 $3,480,000 $0 $3,480,000 Certificates of Obligation 380,000 '0 380,000 0 $380,000 Grants 0 1,858,500' 1,858,500 0 $1,858,500 0 0 0 0 $0 0 0` 0 0 $0 Total $3,860,000 $1,858,500 $5,718,500 $0 $5,718,500 PROJECT EXPENDITURES Professional Services $381,841 $0 $381,841 $0 $381,841 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 20,000 0 20,000 0 $20,000 Construction 3,458,159 1,858,500 5,316,659 0 $5,316,659 Other 0 0 0 0 $0 Total $3,860,000 $1,858,500 $5,718,500 $0 $5,718,500 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Main Street Attachment"B" ST2212 Page 6 of 77 PROJECT DESCRIPTION&JUSTIFICATION The project consists of engineering and construction of approximately 1,100 linear feet of Main Street from Amundson Drive to Amundson Road.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. A 2020 Capital Program Advisory Committee evaluated the city's infrastructure needs and due to poor road conditions, recommended that Main Street be reconstructed. The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records, citizen input and estimated project costs. Main Street is a minor collector in the City's roadway network,and this portion of the roadway carries over 4,000 vehicles per day.The current pavement condition rating is 25.0 on a scale of 1-100,and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Both Pearl Street(ST2115)&Southampton Drive(ST2116)are preparing to be closed out, and remaining funds are projected to be needed for the upcoming Main Street(ST2212)construction. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES G.O. Bonds $1,622,315 $0 $1,622,315 $0 $1,622,315 Project Savings 0 90,534 90,534 0 $90,534 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $1,622,315 $90,534 $1,712,849 $0 $1,712,849 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 181,610 0 181,610 0 $181,610 Land/ROW Acquistion 0 0 0 0 $0 Construction 1,440,705 90,534 1,531,239 0 $1,531,239 Other 0 0 0 0 $0 Total $1,622,315 $90,534 $1,712,849 $0 $1,712,849 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Pearl Street Reconstruction Attachment"B" ST2115 Page 7 of 77 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 1,100 linear feet of Pearl Street from Freda Lane to the alley in Hometown. The improvements include reconstructing the existing roadway with new full-depth subgrade, limited curb and gutter replacement, and new asphalt pavement. The road will be reconstructed within the existing right-of-way in its current configuration;this is not a roadway expansion. A 2020 Capital Program Advisory Committee evaluated the city's infrastructure needs and due to poor road conditions, recommended that Pearl Street be reconstructed. The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records, and estimated project costs. Pearl Street is a local or residential street in the City's roadway network.The current pavement condition rating is 14.5 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Both Pearl Street(ST2115)&Southampton Drive(ST2116)are preparing to be closed out, and remaining funds are projected to be needed for the upcoming Main Street(ST2212)construction. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES G.O. Bonds $690,000 ($45,659) $644,341 $0 $644,341 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $690,000 ($45,659) $644,341 $0 $644,341 PROJECT EXPENDITURES Professional Services $0 $0, $0 $0 $0 Engineering/Design 15,000 (15,000) 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 675,000 (30,659) 644,341 0 $644,341 Other 0 0 0 0 $0 Total $690,000 ($45,659) $644,341 $0 $644,341 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Southampton Drive Reconstruction Attachment"B" ST2116 Page 8 of 77 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 1,700 linear feet of Southampton Drive from Wakefield Road to Chapman Road.The improvements include reconstructing the existing roadway with new full-depth subgrade, limited curb and gutter replacement, and new asphalt pavement. The road will be reconstructed within the existing right-of-way in its current configuration;this is not a roadway expansion. A 2020 Capital Program Advisory Committee evaluated the city's infrastructure needs and due to poor road conditions, recommended that Southampton Drive be reconstructed. The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records, and estimated project costs. Southampton Drive is a local or residential street in the City's roadway network.The current pavement condition rating is 9.4 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Both Pearl Street(ST2115)&Southampton Drive(ST2116)are preparing to be closed out, and remaining funds are projected to be needed for the upcoming Main Street(ST2212)construction. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES G.O. Bonds $1,080,000 ($44,875) $1,035,125 $0 $1,035,125 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $1,080,000 ($44,875)' $1,035,125 $0 $1,035,125 PROJECT EXPENDITURES Professional Services $0 $0' $0 $0 $0 Engineering/Design 15,000 (15,000) 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 1,065,000 (29,875) 1,035,125 0 $1,035,125 Other 0 0 0 0 $0 Total $1,080,000 ($44,875) $1,035,125 $0 $1,035,125 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Acts Court Retaining Wall Attachment"B" Page 9 of 77 ST2301 PROJECT DESCRIPTION&JUSTIFICATION This project will reconstruct approximately 150 linear feet of retaining wall on the north side of Starnes Road, immediately west of Acts Court.The existing 5'-7'tall terraced RR tie retaining wall will be replaced with a concrete or masonry wall. The existing RR tie wall was constructed as part of the 1987 Starnes Road project at the high point of a vertical curve on the road, and is located wholly within the public right-of-way.The top tier of the wall lies roughly 17'south of an existing home, and mitigates the approximately 11'vertical difference between the elevation of the home and the curb on Starnes.The wall has deteriorated with age and needs to be replaced with a longer lasting structural wall. Project Status: Staff is preparing to advertise for an RFQ. Funding Source: $120,000 from General CIP Reserves. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION The cost for design came in higher than the existing budget. Negotiations took place to lower the contract amount, and this revision is to transfer the remaining overage($16,672)from the construction budget to the design budget. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves $120,000 $0 $120,000 $0 $120,000 0 0 0 0 $0 0 0' 0 0 $0 0 0' 0 0 $0 0 6; 0 0 $0 Total $120,000 $0 $120,000 $0 $120,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 20,000 16,672 36,672 0 $36,672 Land/ROW Acquistion 0 0 0 0 $0 Construction 100,000 (16,672)! 83,328 0 $83,328 Other 0 0 0 0 $0 Total $120,000 $0 $120,000 $0 $120,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Hightower/Davis Traffic Signal Attachment",B" ST2103 Page 10 of 77 PROJECT DESCRIPTION&JUSTIFICATION 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. 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. Project Status: project is preparing to be closed out. Funding Source: $390,000 from Certificates of Obligation, and$86,000 from Reserves. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION CDBG23 Sao Paulo Court is expected to need an additional-$13,000 in funding to cover cost overruns. ST2103 Hightower/ Davis Traffic Signal is complete and ready to be closed out, and the remaining funds($16,057)can be used to offset the additional costs anticipated to be incurred on Sao Paulo. FINANCIAL DATA ADOPTED � h REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES a Certificates of Obligation $390,000 $0 $390,000 $0 $390,000 Reserves 86,000 (16,057) 69,943 0 $69,943 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $476,000 ($16,057) $459,943 $0 $459,943 PROJECT EXPENDITURES Professional Services $40,680 ($10,100) $30,580 $0 $30,580 Engineering/Design 0 0' 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 435,320 (5,957) 429,363 0 $429,363 Other 0 0 0 0 $0 Total $476,000 ($16,057)` $459,943 $0 $459,943 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Sao Paulo Court Reconstruction Attachment"B" CDBG23 Page 11 of 77 PROJECT DESCRIPTION&JUSTIFICATION This is the 48th Year Community Development Block Grant(CDBG) Project.The project will consist of reconstructing the entire length(410 linear feet)of Sao Paulo Court.The estimated cost for this project is$369,416. City funds in the amount of$15,000 have been designated, but may not be needed to cover project costs. "The condition rating of Sao Paulo Court is 18.7.The length of the project is 410 linear feet between Caracus Drive and the cul-desac.The existing 30'wide asphalt road, including curb and gutter,will be removed and replaced with 6"stabilized subgrade and 6"of reinforced concrete pavement.The project will include the installation of sidewalks as well. Note:This project is part of the Federal/State Grant Funds known as 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 received or administered by the City; all funds remain with Tarrant County. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION CDBG23 Sao Paulo Court is expected to need an additional—$13,000 in funding to cover cost overruns. ST2103 Hightower/ Davis Traffic Signal is complete and ready to be closed out,and the remaining funds($16,057)can be used to offset the additional costs anticipated to be incurred on Sao Paulo. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023124 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves $15,000 $0 $15,000 $0 $15,000 Project Savings(ST2103) 0 10,057 16,057 0 $16,057 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $15,000 $16,057 $31,057 $0 $31,057 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 15,000 16,057 31,057 0 $31,057 Other 0 0 0 0 $0 Total $15,000 $16,057 $31,057 $0 $31,057 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Stonybrooke Drive Reconstruction Attachment"B" ST2119 Page 12 of 77 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 1,240 linear feet of Stonybrooke Drive from Stephanie Drive to approximately 340'north of Hightower.The improvements include reconstructing the existing roadway with new full-depth subgrade, limited curb and gutter replacement, and new asphalt pavement. The road will be reconstructed within the existing right-of-way in its current configuration;this is not a roadway expansion. A 2020 Capital Program Advisory Committee evaluated the city's infrastructure needs and due to poor road conditions, recommended that Stonybrooke Drive be reconstructed.The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records, and estimated project costs. Stonybrooke Drive is a local or residential street in the City's roadway network. The current pavement condition rating is 24 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ST2119 Stonybrooke Drive is being prepared for close out. ST2214 Kirk Lane is projected to be short$65,249.This transfer ($70,000)is to cover that projected shortage, and to provide a slight buffer. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES g ($70,000)' $800,000 $0 $800,000 G. O. Bonds 2020 Program $870,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $870,000 ($70,000) $800,000 $0 $800,000 PROJECT EXPENDITURES Professional Services $0 $0! $0 $0 $0 Engineering/Design 15,000 0 15,000 0 $15,000 Land/ROW Acquistion 0 0 0 0 $0 Construction 855,000 (70,000) 785,000 0 $785,000 Other 0 0 0 0 $0 Total $870,000 ($70,000) $800,000 $0 $800,000 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Stonybrooke Drive Reconstruction Attachment"B" ST2119 Page 13 of 77 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 1,240 linear feet of Stonybrooke Drive from Stephanie Drive to approximately 340'north of Hightower. The improvements include reconstructing the existing roadway with new full-depth subgrade, limited curb and gutter replacement,and new asphalt pavement. The road will be reconstructed within the existing right-of-way in its current configuration;this is not a roadway expansion. A 2020 Capital Program Advisory Committee evaluated the city's infrastructure needs and due to poor road conditions, recommended that Stonybrooke Drive be reconstructed.The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records,and estimated project costs. Stonybrooke Drive is a local or residential street in the City's roadway network.The current pavement condition rating is 24 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ST2119 Stonybrooke Drive, ST2120 Nob Hill Drive, and ST2210 Dawn Drive are all complete.The remaining funds for each are requested for transfer into the ST2413 2020 Bond Program Residential Street Funding Project where they can be used to fund additional residential streets identified by the Capital Program Advisory Committee. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES ""_." , G. O.Bonds 2020 Program $800,000 ($146,251) $653,749 $0 $653,749 0 0' 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $800,000 ($146,251) $653,749 $0 $653,749 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 15,000 (15,000) 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 785,000 (131,251) 653,749 0 $653,749 Other 0 0 0 0 $0 Total $800,000 ($146,2511' $653,749 $0 $653,749 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Kirk Lane Attachment"B" ST2214 Page 14 of 77 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 700 linear feet of Kirk Lane from Northfield Drive to Kirk Court.The improvements include reconstructing the existing roadway with new full-depth subgrade, limited curb and gutter replacement, and new asphalt pavement.The road will be reconstructed within the existing right-of-way in its current configuration;this is not a roadway expansion. A 2020 Capital Program Advisory Committee evaluated the city's infrastructure needs and due to poor road conditions, recommended that Kirk Lane be reconstructed. The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records, and estimated project costs. Kirk Lane is a local or residential street in the City's roadway network.The current pavement condition rating is 18.9 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ST2119 Stonybrooke Drive is being prepared for close out. ST2214 Kirk Lane is projected to be short$65,249. This transfer ($70,000)is to cover that projected shortage, and to provide a slight buffer. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES G. O. Bonds 2020 Program $533,800 $0 $533,800 $0 $533,800 ST2119 Project Savings(G.O. Bonds) 0 70,000' 70,000 0 $70,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $533,800 $70,000 $603,800 $0 $603,800 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 15,000 0 15,000 0 $15,000 Land/ROW Acquistion 0 0 0 0 $0 Construction 518,800 70,000 588,800 0 $588,800 Other 0 0 0 0 $0 Total $533,800 $70,000 $603,800 $0 $603,800 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Nob Hill Drive Reconstruction Attachment"B' Page 15 of 77 ST2120 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 1,365 linear feet of Nob Hill Drive from just west of High Oaks Drive to the dead end.The improvements include reconstructing the existing roadway with new full-depth subgrade, limited curb and gutter replacement, and new asphalt pavement. The road will be reconstructed within the existing right-of-way in its current configuration;this is not a roadway expansion. A 2020 Capital Program Advisory Committee evaluated the city's infrastructure needs and due to poor road conditions, recommended that Nob Hill Drive be reconstructed.The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records, and estimated project costs. Nob Hill Drive is a local or residential street in the City's roadway network. The current pavement condition rating is 9.8 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ST2120 Nob Hill Drive Reconstruction is being prepared for close out. ST2221 Post Oak Drive is projected to be short $372,029. This transfer($380,000)is to cover that projected shortage, and to provide a slight buffer. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES G. O. Bonds 2020 Program $820,000 ($380,000) $440,000 $0 $440,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $820,000 ($380,000) $440,000 $0 $440,000 PROJECT EXPENDITURES , Professional Services $0 $0! $0 $0 $0 Engineering/Design 15,000 0' 15,000 0 $15,000 Land/ROW Acquistion 0 0 0 0 $0 Construction 805,000 (380,000) 425,000 0 $425,000 Other 0 0 0 0 $0 Total $820,000 ($380,000) $440,000 $0 $440,000 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Nob Hill Drive Reconstruction Attachment"B" ST2120 Page 16 of 77 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 1,365 linear feet of Nob Hill Drive from just west of High Oaks Drive to the dead end.The improvements include reconstructing the existing roadway with new full-depth subgrade, limited curb and gutter replacement, and new asphalt pavement. The road will be reconstructed within the existing right-of-way in its current configuration;this is not a roadway expansion. A 2020 Capital Program Advisory Committee evaluated the city's infrastructure needs and due to poor road conditions, recommended that Nob Hill Drive be reconstructed.The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records, and estimated project costs. Nob Hill Drive is a local or residential street in the City's roadway network.The current pavement condition rating is 9.8 on a scale of 1-100,and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ST2119 Stonybrooke Drive, ST2120 Nob Hill Drive, and ST2210 Dawn Drive are all complete.The remaining funds for each are requested for transfer into the ST2413 2020 Bond Program Residential Street Funding Project where they can be used to fund additional residential streets identified by the Capital Program Advisory Committee. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES G. O. Bonds 2020 Program $440,000 ($81,724) $358,276 $0 $358,276 0 O.i 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $440,000 ($81,724) $358,276 $0 $358,276 PROJECT EXPENDITURES Professional Services $0 $0, $0 $0 $0 Engineering/Design 15,000 (15,000) 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 425,000 (66,724) 358,276 0 $358,276 Other 0 o 0 0 $0 Total $440,000 ($81,724) $358,276 $0 $358,276 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Post Oak Drive Attachment"B' Page 17 of 77 ST2221 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 1,000 linear feet of Post Oak Drive from Briarwood Drive to Hightower Drive.The improvements include reconstructing the existing roadway with new full-depth subgrade, limited curb and gutter replacement, and new asphalt pavement.The road will be reconstructed within the existing right-of-way in its current configuration;this is not a roadway expansion. A 2020 Capital Program Advisory Committee evaluated the city's infrastructure needs and due to poor road conditions, recommended that Post Oak Drive be reconstructed.The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records, and estimated project costs. Post Oak Drive is a local or residential street in the City's roadway network. The current pavement condition rating is 17.3 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ST2120 Nob Hill Drive Reconstruction is being prepared for close out. ST2221 Post Oak Drive is projected to be short $372,029. This transfer($380,000)is to cover that projected shortage, and to provide a slight buffer. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 ,REVISION 2023/24 BALANCE COST FUNDING SOURCES G.O. Bonds 2020 Program $680,400 ! $0 $680,400 $0 $680,400 ST2120 Project Savings(G.O. Bonds) 0 380,000 380,000 0 $380,000 0 0- 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $680,400 $380,000 $1,060,400 $0 $1,060,400 PROJECT EXPENDITURES Professional Services $0 $0; $0 $0 $0 Engineering/Design 15,000 0 15,000 0 $15,000 Land/ROW Acquistion 0 0` 0 0 $0 Construction 665,400 380,000 1,045,400 0 $1,045,400 Other 0 0' 0 0 $0 Total $680,400 $380,000 $1,060,400 $0 $1,060,400 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 2020 Bond Program Residential Street Funding Project Attachment"B" ST2413 Page 18 of 77 PROJECT DESCRIPTION&JUSTIFICATION This project consists of funding to be used for reconstruction of residential streets identified by the Capital Program Advisory Committee prior to the successful November 2020 Street Bond Program election. Bond funds are available for use in completing residential street projects identified by the Capital Program Advisory Committee either to augment existing budgets or to provide funds for additional streets which were included on the recommended project list but did not make the original funding cutoff. Funding sources include: $632,500 in General Obligation Bonds from the 2020 Bond Program. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ST2119 Stonybrooke Drive, ST2120 Nob Hill Drive, and ST2210 Dawn Drive are all complete.The remaining funds for each are requested for transfer into the ST2413 2020 Bond Program Residential Street Funding Project where they can be used to fund additional residential streets identified by the Capital Program Advisory Committee. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES w4 G. O. Bonds 2020 Program $632,500 $0', $632,500 $0 $632,500 ST2119 Project Savings(GO Bonds) 0 146,251 146,251 0 $146,251 ST2120 Project Savings(GO Bonds) 0 81,724 81,724 0 $81,724 ST2210 Project Savings(GO Bonds) 0 93,393 93,393 0 $93,393 0 0 0 0 $0 Total $632,500 $321,368 $953,868 $0 $953,868 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 50,000 0 50,000 0 $50,000 Land/ROW Acquistion 0 0 0 0 $0 Construction 582,500 321,368 903,868 0 $903,868 Other 0 0 0 0 $0 Total $632,500 $321,368 $953,868 $0 $953,868 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 _ 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Dawn Drive Attachment"B" ST2210 Page 19 of 77 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 2,100 linear feet of Dawn Drive from Onyx Drive North to Glenview Drive. The improvements include reconstructing the existing roadway with new full-depth subgrade, limited curb and gutter replacement, and new asphalt pavement.The road will be reconstructed within the existing right-of-way in its current configuration;this is not a roadway expansion. A 2020 Capital Program Advisory Committee evaluated the city's infrastructure needs and due to poor road conditions, recommended that Dawn Drive be reconstructed. The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records, and estimated project costs. Dawn Drive is a local or residential street in the City's roadway network.The current pavement condition rating is 15.2 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ST2119 Stonybrooke Drive, ST2120 Nob Hill Drive, and ST2210 Dawn Drive are all complete.The remaining funds for each are requested for transfer into the ST2413 2020 Bond Program Residential Street Funding Project where they can be used to fund additional residential streets identified by the Capital Program Advisory Committee. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 `' 'REVISION 2023/24 BALANCE COST FUNDING SOURCES G. O. Bonds 2020 Program $1,222,800 ($93,393) $1,129,407 $0 $1,129,407 0 0 0 0 $0 0 0'' 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $1,222,800 ($93,393)_ $1,129,407 $0 $1,129,407 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 15,000 (15,000), 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 1,207,800 (78,393) 1,129,407 0 $1,129,407 Other 0 0 0 0 $0 Total $1,222,800 ($93,393) $1,129,407 $0 $1,129,407 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Smithfield Middle School Safe Routes to School Attachment"B° Page 20 of 77 SD2404 PROJECT DESCRIPTION&JUSTIFICATION This is a Safe Routes to Schools project through the Transportation Alternatives Set-Aside infrastructure reimbursement program by the North Central Texas Council of Governments.This particular project focuses on the bicycle and pedestrian feeder routes to Smithfield Middle School. It includes filling existing gaps in the sidewalk network, replacing and installing new sidewalk ramps,establishing new sidewalk routes, installing mid-block cross walks with advanced warning signage in key locations, a bicycle parking station for up to 30 bicycles, and pedestrian crossing signage with LED outline at Mid-Cities& Amundson/ inter Park. In August 2016,the Planning&Zoning Department asked Birdville ISD which three school campuses might require the most attention for a Safe Routes to School pilot project.A group of University of North Texas Master in Public Administration students then prepared a draft Safe Routes to Schools Plan for North Richland Hills that focused on those three campuses. Smithfield Middle School was one of the three campuses. Because of the location of Smithfield Middle School between PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering 03/2024 04/2025 Land/ROW Acquisition Construction 04/2025 12/2025 Other REVISION EXPLANATION TxDOT has calculated the estimated payment to them by the City for direct and indirect State costs of the project, so the budget is being amended to reflect those additional costs of$3,317 for design stage review. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES ' 10 i" h Grant-TXDOT $663,596 $0 $663,596 $0 $663,596 Reserves-General Fund(100) 66,293 0 66,293 0 $66,293 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $729,889 $0 $729,889 $0 $729,889 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 66,293 3,317 69,610 0 $69,610 Land/ROW Acquistion 0 0 0 0 $0 Construction 663,596 (3,317) 660,279 0 $660,279 Other 0, 0 0 $0 Total $729,889 $0 $729,889 $0 $729,889 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street& Sidewalk Capital Projects Ordinance 3861 Smithfield Middle School Safe Routes to School Attachment„B" Page 21 of 77 SD2404 PROJECT DESCRIPTION&JUSTIFICATION This is a Safe Routes to Schools project through the Transportation Alternatives Set-Aside infrastructure reimbursement program by the North Central Texas Council of Governments. This particular project focuses on the bicycle and pedestrian feeder routes to Smithfield Middle School. It includes filling existing gaps in the sidewalk network, replacing and installing new sidewalk ramps,establishing new sidewalk routes, installing mid-block cross walks with advanced warning signage in key locations, a bicycle parking station for up to 30 bicycles, and pedestrian crossing signage with LED outline at Mid-Cities& Amundson/Winter Park. In August 2016,the Planning&Zoning Department asked Birdville ISD which three school campuses might require the most attention for a Safe Routes to School pilot project.A group of University of North Texas Master in Public Administration students then prepared a draft Safe Routes to Schools Plan for North Richland Hills that focused o.n those three campuses. Smithfield Middle School was one of the three campuses. Because of the location of Smithfield Middle School between a PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering 03/2024 04/2025 Land/ROW Acquisition Construction 04/2025 12/2025 Other REVISION EXPLANATION City Management decision to utilize existing fund balance in the Sidewalk Capital Project Fund(335). FINANCIAL DATA ADOPTED 1 REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES »ii TXDOT-Grant $663,596 $0 $663,5960 $0 $663,596 General Fund(100)Reserves 66,293 (66,293)' 0 0 $0 Sidewalk CIP Fund(335)Reserves 0 66,293' 66,293 0 $66,293 0 0 0 0 $0 0 0 0 0 $0 Total $729,889 $U $0 $729,889 $0 $729,889 $0 PROJECT EXPENDITURES Professional Services $0 $0 $0 Engineering/Design 69,610 0 69,610 0 $69,610 Land/ROW Acquistion 0 0r 0 0 $0 Construction 660,279 0 660,279 0 $660,279 Other 0 . 0 0 0 $0 Total $729,889 $0 $729,889 $0 $729,889 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Sidewalk Rehabilitation and Replacement Project(2023-24) Attachment"B" Page 22 of 77 SD2403 PROJECT DESCRIPTION&JUSTIFICATION This project provides for rehabilitation of the city's sidewalk system. Funding will allow for the replacement of approximately 5,000 square feet of deteriorated sidewalks or new sidewalk in residential and high pedestrian areas. 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 areas along Holiday Lane and Mid-Cities Blvd. This project will allow staff the funding to begin making necessary repairs to these locations. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2023 09/2024 Other REVISION EXPLANATION City Management decision to utilize existing fund balance in the Sidewalk Capital Project Fund(335). FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES General Fund Reserves $50,000 ($50,000) $0 $0 $0 Sidewalk CIP Fund(335)Reserves 0 50,000 50,000 0 $50,000 0 0 0 0 $0 0 0 0 0 $0 0 0' 0 0 $0 Total $50,000 $0 $50,000 $0 $50,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 50,000 0 50,000 0 $50,000 Other 0 0: 0 0 $0 Total 550,000 $0 $50,000 $0 $50,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Drainage Capital Projects Ordinance 3861 Street Drainage Improvements Project Attachment"B" Page 23 of 77 DR2304 PROJECT DESCRIPTION&JUSTIFICATION The project would consist of addressing a portion of the numerous non-grade standing water request 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 206 locations at the cost of$576,557. This project could be considered an annual project until such time as the list of request is completed or until the list can be accomplished within the operating budget. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION $45,050 in funding is requested to be transferred from DR2401 to DR2304 to cover the cost of a design contract. FINANCIAL DATA ADOPTED i REVISED TOTAL BUDGET THRU PROJECT 01 BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves $100,000 $0 $100,000 $0 $100,000 Reserves(DR2401) 0 45,050 45,050 0 $45,050 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $100,000 $45,050 $145,050 $0 $145,050 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 45,050 0 45,050 0 $45,050 Land/ROW Acquistion 0 0 0 0 $0 Construction 54,950 45,050 100,000 0 $100,000 Other 0 0 0 0 $0 Total $100,000 $45,050 $145,050 $0 $145,050 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Drainage Capital Projects Ordinance 3861 Miscellaneous Drainage Improvements (FY24) Attachment"B" Page 24 of 77 DR2401 PROJECT DESCRIPTION&JUSTIFICATION This project includes the design and construction of various drainage infrastructure items in three locations: Heidelburg Court, Colorado Blvd,and Amundson Drive near Dick Faram Park. The Heidelburg Court project involves extension of a concrete flume to an existing inlet at the end of the cul-de-sac to provide overland relief to the underground system.The Colorado Blvd. project will extend a drainage lateral and intake structure to a repetitive flooding loss property in the 5100 block of the street. The Amundson Drive project would install drainage infrastructure to intercept flow from Dick Faram Park and convey it safely to an existing drainage system on Amundson Road. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION $45,050 in funding is requested to be transferred from DR2401 to DR2304 to cover the cost of a design contract. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves $500,000 ($45,050)! $454,950 $0 $454,950 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $500,000 ($45,050) $454,950 $0 $454,950 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 100,000 (45,050)', 54,950 0 $54,950 Land/ROW Acquistion 0 0 0 0 $0 Construction 400,000 0 400,000 0 $400,000 Other 0 0 0 0 $0 Total $500,000 ($45,050) $454,950 $0 $454,950 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Drainage Capital Projects Ordinance 3861 Miscellaneous Drainage Improvements (FY24) Attachment""B" DR2401 Page 25 of 77 PROJECT DESCRIPTION&JUSTIFICATION This project includes the design and construction of various drainage infrastructure items in three locations: Heidelburg Court, Colorado Blvd, and Amundson Drive near Dick Faram Park.The Heidelburg Court project involves extension of a concrete flume to an existing inlet at the end of the cul-de-sac to provide overland relief to the underground system. The Colorado Blvd. project will extend a drainage lateral and intake structure to a repetitive flooding loss property in the 5100 block of the street. The Amundson Drive project would install drainage infrastructure to intercept flow from Dick Faram Park and convey it safely to an existing drainage system on Amundson Road. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Due to a change order for construction of DR1701 Walker Branch Channel Repair, additional funding in the amount of$65,000 is required to make further necessary repairs to the channel. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES , Reserves $454,950 ($65,000);' $389,950 $0 $389,950 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $454,950 ($65,000). $389,950 $0 $389,950 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 54,950 0 54,950 0 $54,950 Land/ROW Acquistion 0 0 0 0 $0 Construction 400,000 (65,000)', 335,000 0 $335,000 Other 0 0' 0 0 $0 Total $454,950 ($65,000) $389,950 $0 $389,950 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Drainage Capital Projects Ordinance 3861 North Hills Addition - Bewley Drive Drainage Improvements Attachment"B" Page 26 of 77 DR2002 PROJECT DESCRIPTION&JUSTIFICATION This project consists of designing and constructing public drainage improvements serving a portion of the North Hills Subdivision.This area was developed decades ago with no underground drainage.The scope of the improvements consists of installing approximately 450 LF of concrete flume, installing grouted rock riprap at the end of the flume to prevent erosion. This project will address property damage due to flooding where stormwater runoff leaves an unimproved drainage easement. Funding Source: Drainage Utility Fund(120). Project Status: On hold. Resident who stands to benefit from the improvements is refusing to grant drainage easement for overland relief. He is requesting a pipe installation which will require engineering redesign and possibly additional funding, but the amount will not be known until design is complete. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering 02/2020 03/2020 Land/ROW Acquisition Construction 04/2023 08/2023 Other REVISION EXPLANATION Construction bids for DR2202 came in$7,260 above the budgeted amount. Funding is proposed to be transferred out of DR2002 to cover this overage. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves $65,000 ($7,260) $57,740 $0 $57,740 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0' 0 0 $0 Total $65,000 ($7,260) $57,740 $0 $57,740 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 15,000 0 15,000 0 $15,000 Land/ROW Acquistion 0 0 0 0 $0 Construction 50,000 (7,260) 42,740 0 $42,740 Other 0 0 0 0 $0 Total $65,000 ($7,260) $57,740 $0 $57,740 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Drainage Capital Projects Ordinance 3861 Sunnybrook Addition Drainage Improvements Attachment"B" Page 27 of 77 DR2202 PROJECT DESCRIPTION&JUSTIFICATION This project involves the installation of approximately 650-feet of concrete drainage pipe to allow for unobstructed discharge of the Sunnybrook storm drain system directly into the Walker Branch channel.The project includes dedication of permanent drainage easements to house the new storm drain line. Approximately 4 acres of the Smithfield Middle School property, and a number of Sunnybrook residential properties currently drain through a public storm drain system at the north end of Sunnybrook Drive which outfalls onto private property to the east, where it is conveyed overland across multiple properties before arriving at the Walker Branch concrete lined channel next to Martin Drive.The outfall ditch has silted in over the years, and without drainage easements the city does not have the ability to properly maintain the downstream system. This causes standing water in the Sunnybrook inlets, and maintenance problems for the property owners. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2022 03/2023 11/2023 Land/ROW Acquisition Construction 06/2023 02/2024 10/2023 06/2024 Other REVISION EXPLANATION Construction bids for DR2202 came in$7,260 above the budgeted amount. Funding is proposed to be transferred out of DR2002 to cover this overage. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023124 BALANCE COST FUNDING SOURCES Reserves $210,000 $0 $210,000 $0 $210,000 Project Savings(DR2002) 0 7,260 7,260 0 $7,260 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $210,000 $7,260". $217,260 $0 $217,260 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 39,000 0 39,000 0 $39,000 Land/ROWAcquistion 0 0 0 0 $0 Construction 171,000 7,260 178,260 0 $178,260 Other 0 0 0 0 $0 Total $210,000 $7,260 $217,260 $0 $217,260 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Drainage Capital Projects Ordinance 3861 Walker Branch Channel Repair (200ft South of Harwood Road) Attachment"B" Page 28 of 77 DR1701 PROJECT DESCRIPTION&JUSTIFICATION The project consists of engineering and reconstructing approximately 400 feet of gabions along the Walker Branch Channel. The project begins south of Harwood along the west bank and will focus on two areas where the gabion baskets have failed. Project Status:As of February of 2023, design is complete and anticipated to go out to bid in March of 2023. Because of record rainfall received in 2015 following years of drought conditions significant erosion has occurred in recent months.As a result of the soil conditions due to these weather events,the Walker Branch Channel has experienced several failures along the banks adjacent to residential properties and the situation continues to deteriorate.Without fortification of the bank in this area,the erosion will progress into private property. Project Status:As of February of 2023, design is complete and anticipated to go out to bid in March of 2023. Funding Source: $740,783 Drainage Utility Fund Reserves and$187,347 in project savings(DR2303). PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Due to a change order for construction of DR1701 Walker Branch Channel Repair, additional funding in the amount of$65,000 is required to make further necessary repairs to the channel. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves $928,130 $0 $928,130 $0 $928,130 Project Savings(DR2401) 0 65,000 65,000 0 $65,000 0 0 0 0 $0 0 0 0 0 $0 o 0 0 0 $0 Total $928,130 $65,000! $993,130 $0 $993,130 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 120,380 0 120,380 0 $120,380 Land/ROW Acquistion 0 0 0 0 $0 Construction 807,750 65,000 872,750 0 $872,750 Other 0 0 0 0 $0 Total $928,130 $65,000 $993,130 $0 $993,130 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2026/26 2026/27 2027/28 TOTAL Projected $0 Drainage Capital Projects Ordinance 3861 Meadow Lakes BFC-7 Drainage Improvements Attachment",B,. DR2303 Page 29 of 77 PROJECT DESCRIPTION&JUSTIFICATION This project consists of upsizing and augmenting the existing storm drain system from north of Surrey Court to the outfall in the eastern lake in the Meadow Lakes neighborhood. The engineering firm that performed the flood study provided three infrastructure alternatives, including a regional detention pond immediately south of the Loop 820 frontage road and two different underground storm drain alignments in excess of 1,500 linear feet within the Meadow Lakes Addition to convey stormwater from the north into the upper lake behind the homes on Lake Side Circle and Pebble Court. The recently completed BFC-7 flood study indicates that the existing storm drain system is undersized, and 15 residential lots are currently within the FEMA designated floodplain. The study provided three infrastructure alternatives to mitigate the drainage issues. Funding Source: $1,012,653 from Drainage Utility Fund Reserves(120). PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION This revision is to cover the professional services costs associated with appraisals for easement acquisition($6,500). FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves $1,012,653 $0 $1,012,653 $0 $1,012,653 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0, 0 0 0 0 $0 Total $1,012,653 $0 $1,012,653 $0 $1,012,653 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 199,879 6,500 206,379 0 $206,379 Land/ROW Acquistion 0 0 0 0 $0 Construction 812,774 (6,500) 806,274 0 $806,274 Other 0 0` 0 0 $0 Total $1,012,653 $0 $1,012,653 $0 $1,012,6531 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Drainage Capital Projects Ordinance 3861 Northwest Stonybrooke Drainage Improvements Attachment"B". Page 30 of 77 DR2302 PROJECT DESCRIPTION&JUSTIFICATION This project will install a structure to intercept flow from the duplex properties along Davis Boulevard and convey it safely downstream. Included in the scope of work for this project is the acquisition of drainage easements as there are currently no public drainage easements established. The homes and duplexes in the southeast quadrant of the David/Rumfield intersection were constructed beginning in the late 1970s.The west to east drainage pattern is concentrated at 2-3 discharge points,creating issues for downstream properties on Hillcrest Court and on Rumfield Road.The downstream property owners on Hillcrest Court and those on Rumfield deal with a considerable amount of stormwater runoff during heavy rain events,with no underlying drainage easements or infrastructure as would be required under current drainage standards to convey offsite flow. Funding Source: $212,000 from Drainage Utility Fund Reserves. Project Status:As of February 2024,this project is in design. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Construction bids for DR2301 Stream LB-1 Bank Restoration came in over budget by$17,457. Those funds are available in available construction funds from the Northwest Stonybrooke Drainage Improvements Project(DR2302).We are in the design phase for DR2302,and current estimates show the project is expected to come in under budget. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves $212,000 ($17,457) $194,543 $0 $194,543 0 0 0 0 $0 0 0! 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $212,000 ($17,457) $194,543 $0 $194,543 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 55,200 0 55,200 0 $55,200 Land/ROW Acquistion 0 0 0 0 $0 Construction 156,800 (17,457) 139,343 0 $139,343 Other 0 0 0 0 $0 Total $212,000 ($17,457) $194,543 $0 $194,543 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 _ 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Drainage Capital Projects Ordinance 3861 Stream LB-1 Bank Restoration Attachment"B" Page 31 of 77 DR2301 PROJECT DESCRIPTION&JUSTIFICATION Stream LB-1 is a tributary to Little Bear Creek. The upper limits of the recognized tributary begin near the intersection of Smithfield and Starnes, after which it flows generally northeast to the confluence with Little Bear Creek just east of Northfield Park.This project will stabilize approximately 100 feet of stream bank located just east of Davis Boulevard using gabion baskets or another method as recommended following a full geotechnical analysis. The south bank of Stream LB-1 experienced failure in early summer 2021 due to erosion immediately downstream of the Davis Boulevard outfall. Further migration of the stream bank will likely occur if no action is taken,which will impact a residential property in the Saint Joseph Estates neighborhood. Funding Source: $325,000 from Drainage Utility Fund Reserves. Project Status:As of February 2024,this project is about to go out to bid for construction. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Construction bids for DR2301 Stream LB-1 Bank Restoration came in over budget by$17,457.Those funds are available in available construction funds from the Northwest Stonybrooke Drainage Improvements Project(DR2302).We are in the design phase for DR2302, and current estimates show the project is expected to come in under budget. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES 1 Reserves $325,000 $0 $325,000 $0 $325,000 Project Savings(DR2302) 0 17,457 17,457 0 $17,457 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $325,000 $17,457 $342,457 $0 $342,457 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 111,577 0 111,577 0 $111,577 Land/ROW Acquistion 0 0 0 0 $0 Construction 213,423 17,457 230,880 0 $230,880 Other 0 0' 0 0 $0 Total $325,000 $17,457 $342,457 $0 $342,457 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Conn Pump Station Permanent Generator Attachment"B" UT2403 Page 32 of 77 PROJECT DESCRIPTION&JUSTIFICATION PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2023 09/2024 Other REVISION EXPLANATION After the Utility Generator Study was completed,we discovered that we did not have enough funding in UT2208 alone to cover the cost of a generator. Instead,the$250,000 in ARPA funding from UT2208 is proposed to be transferred to UT2403 where the funds could still be used for their intended purpose. FINANCIAL DATA ADOPTED " REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 'REVISION 2022/23 BALANCE COST FUNDING SOURCES Reserves $1,250,000 $0 $1,250,000 $0 $1,250,000 ARPA(UT2208) 0 250,000 250,000 0 $250,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $1,250,000 $250,000 $1,500,000 $0 $1,500,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 1,250,000 250,000 1,500,000 0 $1,500,000 Other 0 0 0 0 $0 Total $1,250,000 $250,000` $1,500,000 $0 $1,500,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Utility Generators Attachment"B" Page 33 of 77 UT2208 PROJECT DESCRIPTION&JUSTIFICATION This project will include identifying, purchasing and installing auxiliary power equipment at key utility infrastructure sites to ensure that remote monitoring and site functionality is available during extended power outages. The city's water distribution system includes a network of pipes, as well as elevated and ground storage tanks, motorized valves, and pump stations all needed to supply the water pressure required to operate the system in compliance with regulatory standards. The storage tanks and pump stations have monitoring and operational equipment that require electricity to function, and currently the majority of these facilities do not have auxiliary power options. Following winter storm Uri in February 2021 and the subsequent extended power outages,the State of Texas passed a bill requiring that public water utilities take steps to ensure that they can continue to provide adequate service to their customers in the event of an extended power outage, regardless of the cause of that outage. Providing auxiliary power options to the city's key utility sites is a step towards meeting that goal. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION After the Utility Generator Study was completed,we discovered that we did not have enough funding in UT2208 alone to cover the cost of a generator. Instead,the$250,000 in ARPA funding from UT2208 is proposed to be transferred to UT2403 where the funds could still be used for their intended purpose. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES ARPA $250,000 ($250,000)', $0 $0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $250,000 ($250,000) $0 $0 $0 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 250,000 (250,000) 0 0 $0 Other 0 0 0 0 $0 Total $250,000 ($250,000) $0 $0 $0 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Lead and Copper Service Line Assessment Attachment'B' UT2302 Page 34 of 77 PROJECT DESCRIPTION&JUSTIFICATION Beginning December 2021 the Environmental Protective Agency(EPA)revised the Lead and Copper Rule Revision(LCRR) creating the Lead and Copper Rule Improvements(LCRI).This rule mandates certain agencies, including the City of North Richland Hills, perform a material survey and certification and complete a lead service line inventory.To remain in compliance, the City of North Richland Hills will be required to inventory and survey an estimated 12,000 to 18,000 water service lines including the City's and customer's service lines that are 2 inch and smaller. Rough estimates to perform the contract services portion of the project ranged from$40 to$50 per service line excavation performed. The EPA's goal is to proactively remove lead service lines and more equitably protect public health through regimented data collection through the inventory process as well as a stringent lead and copper water testing procedures.This project will be the funding source that will allow the City to hire a contractor that will perform the service line excavations, inventory, and perform surface restorations.Additionally,there will be a small amount of professional services required to assist with GIS andj PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Additional funds($407,400)are required to be transferred internal to the project from the construction budget to the professional services budget. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 ".'REVISION 2022/23 BALANCE COST FUNDING SOURCES Utility Operating Fund(410) $775,000 $0 $775,000 $0 $775,000 0 0 0 0 $0 0 0 0 0 $0 0 0' 0 0 $0 0 0 0 0 $0 Total $775,000 $0 $775,000 $0 $775,000 PROJECT EXPENDITURES Professional Services $25,000 $407,400 $432,400 $0 $432,400 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 750,000 (407,400) 342,600 0 $342,600 Other 0 0 0 0 $0 Total $775,000 $0 $775,000 $0 $775,000 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Lead and Copper Service Line Assessment Attachment"B" UT2302 Page 35 of 77 PROJECT DESCRIPTION&JUSTIFICATION Beginning December 2021 the Environmental Protective Agency(EPA)revised the Lead and Copper Rule Revision(LCRR) creating the Lead and Copper Rule Improvements(LCRI).This rule mandates certain agencies, including the City of North Richland Hills, perform a material survey and certification and complete a lead service line inventory. To remain in compliance, the City of North Richland Hills will be required to inventory and survey an estimated 12,000 to 18,000 water service lines including the City's and customer's service lines that are 2 inch and smaller. Rough estimates to perform the contract services portion of the project ranged from$40 to$50 per service line excavation performed. The EPA's goal is to proactively remove lead service lines and more equitably protect public health through regimented data collection through the inventory process as well as a stringent lead and copper water testing procedures.This project will be the funding source that will allow the City to hire a contractor that will perform the service line excavations, inventory, and perform surface restorations.Additionally,there will be a small amount of professional services required to assist with GIS andu PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Prices for the UT2304 Cellular Meter Reading project came in higher than expected for the base bid. The project is offsetting costs for a professional services contract in this project,so the project savings from the scope adjustment($342,600)are being transferred accordingly. FINANCIAL DATA ADOPTED # REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES ,10 Utility Operating Fund(410) $775,000 ($342,600) $432,400 $0 $432,400 0 0 0 0 $0 0 CI 0 0 $0 0 0' 0 0 $0 0 0 0 0 $0 Total $775,000 ($342,600) $432,400 $0 $432,400 PROJECT EXPENDITURES Professional Services $432,400 $0 $432,400 $0 $432,400 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 342,600 (342,600) 0 0 $0 Other 0 0' 0 0 $0 Total $775,000 ($342,600) $432,400 $0 $432,400 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Walker Branch Interceptor Attachment"B" UT1607 Page 36 of 77 PROJECT DESCRIPTION&JUSTIFICATION PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Prices for the UT2304 Cellular Meter Reading project came in higher than expected for the base bid. This transfer to UT2304 ($617,940)would make up the difference. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022123 REVISION 2022/23 BALANCE COST FUNDING SOURCES Various $4,916,525 ($617,940) $4,298,585 $0 $4,298,585 0 0 0 $0 0' 0 0 $0 0' 0 0 $0 0 0' 0 0 $0 Total $4,616,525 ($617,940) $4,298,585 $0 $4,298,585 PROJECT EXPENDITURES Professional Services $421,631 $0 $421,631 $0 $421,631 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 4,393 0 4,393 0 $4,393 Construction 4,490,501 (617,940) 3,872,561 0 $3,872,561 Other 0 0 0 0 $0 Total $4,916,525 ($617,940) $4,298,585 $0 $4,298,585 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Walker Branch Interceptor Attachment..8.. UT1607 Page 37 of 77 PROJECT DESCRIPTION&JUSTIFICATION PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Construction bids for UT2207 came in over budget. The project transfers from UT1404, UT1607, and UT2107, are to help bridge the gap by identifying projects that are either completed and preparing to be closed out, or are nearly complete and we anticipate having a project balance remaining. UT1607 has$299,697 available for transfer to UT2207. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU P OJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Various $4,298,585 ($299,6970) $3,998,888 $0 $3,998,888 0 ' 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $4,298,585 ($299,697)' $3,998,888 $0 $3,998,888 PROJECT EXPENDITURES Professional Services $0 $Q $0 $0 $0 Engineering/Design 421,631 0' 421,631 0 $421,631 Land/ROW Acquistion 4,393 Q' 4,393 0 $4,393 Construction 3,872,561 (299,697) $3,572,864 0 $3,572,864 Other 0 0 0 0 $0 Total $4,298,585 ($299,697) $3,998,888 $0 $3,998,888 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Cellular Meter Reading Project Attachment„B„ UT2304 Page 38 of 77 PROJECT DESCRIPTION&JUSTIFICATION This project will consist of converting the current drive-by meter reading process to a cellular reading process.This will involve replacing approximately 23,500 meter endpoints(aka transponders)with cellular endpoints. The project will also include replacing the roughly 24,000 meters some of which are over twenty years in age while their endpoints are being exchanged. Converting the system to a cellular read system will eliminate the need to drive-by each meter location to obtain the water usage for each meter.The cellular system sends a reading every 15 minutes to the central location for billing purposes and for customer use, and is compatible with our current reading and billing software.This will make the system much more customer friendly, and offers ancillary benefits such as real-time leak detection and a robust customer dashboard. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Prices for the project came in higher than expected for the base bid.The project is also offsetting costs for a contract with the UT2302 Lead and Copper project, so the project savings from the scope adjustment are being transferred here accordingly. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Certificates of Obligation $4,855,500 $0 $4,855,500 $0 $4,855,500 Reserves 715,679 0 715,679 0 $715,679 Project Savings(UT2302) 0 342,600 342,600 0 $342,600 Project Savings(UT1607) 0 617,940' 617,940 0 $617,940 0 O 0 0 $0 Total $5,571,179 $960,540 $6,531,719 $0 $6,531,719 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 ' Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0' 0 0 $0 Construction 5,571,179 960,54,0 6,531,719 0 $6,531,719 Other 0 0' 0 0 $0 Total $5,571,179 $960,540 $6,531,719 $0 $6,531,719 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Tyson 12" and 10" Sanitary Sewer By-Pass Line Attachment"B" Page 39 of 77 UT2207 PROJECT DESCRIPTION&JUSTIFICATION This project consists of designing and constructing approximately 1000 LF of 12"sanitary sewer line and approximately 400 LF of 10"sanitary sewer line.The new 12"and 10"lines will replace an older, 1400 LF section of an 8"line. The majority of the line will be constructed parallel to Browning Drive and will connect to an 18"sewer main that runs through the golf course and carries the flows to the Fort Worth treatment plant. The existing 8"line being replaced and increased in size has been in place for 30 plus years. Besides the line being old,the size of the line needs to be increased to accommodate the Tyson flows and the increase in flows from the Iron Horse TOD development. Since the line is being replaced,the new 12"will be rerouted around the existing residential neighborhood.This will eliminate the industrial flows from Tyson being discharged through the neighborhood. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2021 03/2022 08/2023 Land/ROW Acquisition Construction 06/2023 01/2024 05/2024 12/2024 Other REVISION EXPLANATION Construction bids for UT2207 came in over budget.The project transfers from UT1404, UT1607,and UT2107, are to help bridge the gap by identifying projects that are either completed and preparing to be closed out, or are nearly complete and we anticipate having a project balance remaining. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION - 2023/24 BALANCE COST FUNDING SOURCES Certificates of Obligation $910,000 $0 $910,000 $0 $910,000 Reserves 117,525 0 117,525 0 $117,525 Project Savings(UT1404) 0 165,137s 165,137 0 $165,137 Project Savings(UT1607) 0 299,698 299,698 0 $299,698 Project Savings(UT2107) 0 64,500 64,500 0 $64,500 Total $1,027,525 $529,335 $1,556,860 $0 $1,556,860 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 119,611 0 119,611 0 $119,611 Land/ROWAcquistion 0 7,625 7,625 0 $7,625 Construction 907,914 521,710 1,429,624 0 $1,429,624 Other 0 0'' 0 0 $0 Total $1,027,525 $529,335 $1,556,860 $0 $1,556,860 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Tyson 12" and 10" Sanitary Sewer By-Pass Line Attachment"B" Page 40 of 77 UT2207 PROJECT DESCRIPTION&JUSTIFICATION This project consists of designing and constructing approximately 1000 LF of 12"sanitary sewer line and approximately 400 LF of 10"sanitary sewer line.The new 12"and 10'lines will replace an older, 1400 LF section of an 8"line.The majority of the line will be constructed parallel to Browning Drive and will connect to an 18"sewer main that runs through the golf course and carries the flows to the Fort Worth treatment plant. The existing 8"line being replaced and increased in size has been in place for 30 plus years. Besides the line being old,the size of the line needs to be increased to accommodate the Tyson flows and the increase in flows from the Iron Horse TOD development. Since the line is being replaced,the new 12'will be rerouted around the existing residential neighborhood.This will eliminate the industrial flows from Tyson being discharged through the neighborhood. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2021 03/2022 08/2023 Land/ROW Acquisition Construction 06/2023 01/2024 05/2024 12/2024 Other REVISION EXPLANATION Construction bids for UT2207 came in over budget.While$646,860 has been allocated from project savings identified in other utility projects,there is not enough to cover the full amount required to award the construction contract for this project.A transfer of$655,000 from the Utility Fund Reserves is requested to cover the remaining construction contract amount. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Certificates of Obligation $910,000 $0 $910,000 $0 $910,000 Project Savings 646,860 0 646,860 0 $646,860 Utility Fund Reserves 0 655,000 655,000 0 $655,000 0 0' 0 0 $0 0 0' 0 0 $0 Total $1,556,860 " $655,000 $2,211,860 $0 $2,211,860 PROJECT EXPENDITURES Professional Services $0 $0' $0 $0 $0 Engineering/Design 119,611 0 119,611 0 $119,611 Land/ROWAcquistion 7,625 0 7,625 0 $7,625 Construction 1,429,624 655,000 2,084,624 0 $2,084,624 Other 0 0 0 0 $0 Total $1,556,860 $655,000 $2,211,860 $0 $2,211,860 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Motor Operated Transfer Valves Attachment"B" Page 41 of 77 UT1404 PROJECT DESCRIPTION&JUSTIFICATION This project consists of motor operated valves to be placed on existing water lines at three locations along Holiday Lane, Thaxton Parkway, and Boulevard 26. This project is part of the City's Water Capital Improvement Plan that is taken from the Water and Wastewater Master Plan of 2011.The proposed motor operated transfer valves will allow water to transfer from the north and south areas of the City without increasing the water pressure at customers taps.This will improve the water circulation in the city and will provide adequate water supplies during peak demand.The valves will also help to keep adequate water supplies in the elevated and ground storage tanks throughout the City. The valves are very large and require major construction of holding vaults to be built along with electronics to be installed to operate the valves on a daily basis. Monitoring of the valves will be accomplished by electronic data on a daily basis to meet the requirements of maintaining adequate water pressure throughout the City. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Construction bids for UT2207 came in over budget.The project transfers from UT1404, UT1607, and UT2107, are to help bridge the gap by identifying projects that are either completed and preparing to be closed out, or are nearly complete and we anticipate having a project balance remaining. UT1404 has$165,137 available for transfer to UT2207. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023124 REVISION 2023/24 BALANCE COST FUNDING SOURCES Utility Operations for Capital Projects $496,740 ($165,137) $331,603 $0 $331,603 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $496,740 ($165,137) $331,603 $0 $331,603 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 496,740 (165,137) 331,603 0 $331,603 Other 0 0 0 0 $0 Total $496,740 ($165,137) $331,603 $0 $331,603 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Automatic Control Valve (ACV) Replacement Attachment"B° Page 42 of 77 UT2107 PROJECT DESCRIPTION&JUSTIFICATION 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 STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Construction bids for UT2207 came in over budget.The project transfers from UT1404, UT1607, and UT2107, are to help bridge the gap by identifying projects that are either completed and preparing to be closed out,or are nearly complete and we anticipate having a project balance remaining. UT2107 has$64,500 available for transfer to UT2207. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves $135,000 ($64,500) $70,500 $0 $70,500 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0' 0 0 $0 Total $135,000 ($64,500) $70,500 $0 $70,500 PROJECT EXPENDITURES Professional Services $0 $0' $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 135,000 (64,500) 70,500 0 $70,500 Other 0 0 0 0 $0 Total $135,000 ($64,500) $70,500 $0 $70,500 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Paramount Street Sanitary Sewer (CDBG) Attachment"B" Page 43 of 77 CDBG22 PROJECT DESCRIPTION&JUSTIFICATION The is the 47th Year Community Development Block Grant(CDBG)Project.The project will consist of reconstructing approximately 1,900 linear feet of sanitary sewer main on the west and north sides of Paramount Street. The existing vitrified clay sanitary sewer main serving the residents on the west and north sides of Paramount Street is in poor condition and requires significant maintenance as it continues to deteriorate. Note:The funding requirement represented in this project is the City's anticipated share of project costs which is proposed to come from the Utility Fund(410).As with all previous CDBG projects,the City will have to provide construction inspection services. No CDBG funds are received or administered by the City; all funds remain with Tarrant County. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Bids for CDBG24 came in at$15,000 over the amount the City has available to cover in overages. Construction for CDBG22 has recently been completed and is preparing to be closed out.The$15,000 in CDBG22 is requested to be transferred over to CDBG24 to cover this overage. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves(Utility Fund 410) $15,000 ($15,000) $0 $0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $15,000 ($15,000) $0 $0 $0 "PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 15,000 (15,000) 0 0 $0 Other 0 0 0 0 $0 Total $15,000 ($15,000) $0 $0 $0 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Sheridan/Garwood Sanitary Sewer Project Attachment"B" Page 44 of 77 CDBG24 PROJECT DESCRIPTION&JUSTIFICATION This is the 49th Year Community Development Block Grant(CDBG)Project.The project will consist of reconstructing approximately 1,700 linear feet of sanitary sewer main on the west and north side of Sheridan Drive. The existing vitrified clay sanitary sewer main serving residents on the west and north sides of Sheridan and the east side of Garwood is in poor condition and requires increasing maintenance as it continues to deteriorate. Note: The funding requirement represented in this project is the City's anticipated share of construction costs which is proposed to come from Utility Capital Fund Reserves(412).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. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Bids for CDBG24 came in at$15,000 over the amount the City has available to cover in overages. Construction for CDBG22 has recently been completed and is preparing to be closed out. The$15,000 in CDBG22 is requested to be transferred over to CDBG24 to cover this overage. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves(Utility Fund 410) $50,000 $0 $50,000 $0 $50,000 Project Savings(CDBG22) 0 15,000 15,000 0 $15,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $50,000 $15,000 $65,000 $0 $65,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 50,000 15,000 65,000 0 $65,000 Other 0 0 0 0 $0 Total $50,000 $15,000 $65,000 $0 $65,000 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Sanitary Sewer System Rehabilitation (Various Locations) Attachment"B" UT 1703 Page 45 of 77 PROJECT DESCRIPTION&JUSTIFICATION This project will consist of replacing approximately 1,200 linear feet of sanitary sewer main lines in North Richland Hills. In addition five manholes will be replaced. Streets included in this project will be Nancy Lane(4900 to 5000 block); 8020 Laura Street to 8017 Lazy Street; and 7000 to 7028 Smithfield Road. In 2010,the City conducted a Sanitary Sewer Assessment for the southern portion of the City(Project UT0902).The Study found that approximately 9,000 linear feet of sanitary sewer main lines are in need of replacement.The main lines are made of vitrified clay tile and have deteriorated to a point where pipe failures have occurred causing blockage and overflows. Many of the joint pipe sections are separated, allowing ground water and surface water intrusion resulting in capacity issues and added costs for the treatment of wastewater.This project will replace segments of the main lines by using the latest technology such as pipe bursting to eliminate the problem lines.The construction methods used will create minor inconveniences to residents. The result will be a more efficient, and safer sanitary sewer system in the southern portion of the City.Approximately 1,200 PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION The remaining work needed on this project is to be completed as its own project, UT2303.Therefore,we request the remaining funds be transferred to that project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Utility Operations Reserves $150,000 ($76,165) $73,835 $0 $73,835 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $150,000 ($76,165) $73,835 $0 $73,835 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 150,000 (76,165), 73,835 0 $73,835 Other 0 0' 0 0 $0 Total $150,000 ($76,165) $73,835 $0 $73,835 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Utility Capital Projects Ordinance 3861 Sewer Main Replacement- Lowery Lane Attachment"B" UT2303 Page 46 of 77 PROJECT DESCRIPTION&JUSTIFICATION The project will consist of reconstructing approximately 1,200 linear feet of sanitary sewer main and four sewer manholes. The existing vitrified clay sanitary sewer main serving the residents on the west side of Lowery Ln and the east side of Crabtree Ln is in poor condition and requires significant maintenance as it continues to deteriorate. Staff has responded to 15 repairs on this sewer main.The line is roughly 10 feet deep and is in the easement of the resident's backyards. Funding Source: $275,000 from Utility CIP Fund Reserves. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023124 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION The work on UT1703 has been completed,with the exception of the work required on Lowery, for which its own project was created for.The remaining balance of UT1703($76,165)is requested to be transferred to this project so that it can be closed out. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Utility CIP Fund Reserves $275,000 $0 $275,000 $0 $275,000 Project Savings(UT1703) 0 76,165 76,165 0 $76,165 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $275,000 $76,165, $351,165 $0 $351,165 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 76,120 0' 76,120 0 $76,120 Land/ROW Acquistion 0 0 0 0 $0 Construction 198,880 76,165 275,045 0 $275,045 Other 0 0 0 0 $0 Total $275,000 $76,165 $351,165 $0 $351,165 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Parks & Recreation Capital Projects Ordinance 3861 Timbers Park Playground Replacement with Shade Attachment„B„ Page 47 of 77 PK2202 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the replacement of the playground at Cross Timbers Park. Originally constructed in 2001, parts were no longer available for replacement or retrofit. This project has been completed. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2021 12/2022 Other REVISION EXPLANATION Additional funds are needed for the Tommy and Sue Brown Playground Replacement for increased shade and play value.The requested funding would come from PK2202-Cross Timbers Playground Replacement with Shade. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves-Impact Fee $192,000 ($1,845) $190,155 $0 $190,155 0 0' 0 0 $0 0 0 0 0 $0 o 0 0 0 $0 0 0 0 0 $0 Total $192,000 ($1,845) $190,155 $0 $190,155 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 192,000 (1,845) 190,155 0 $190,155 Other 0 0 0 0 $0 Total $192,000 ($1,845) $190,155 $0 $190,155 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Parks & Recreation Capital Projects Ordinance 3861 Tommy& Sue Brown Playground Replacement with Shade Attachment„B„ Page48of77 PK2407 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the replacement of the playground at Tommy and Sue Brown Park.This playground was constructed in 2004. From the original construction, parts are no longer available for replacement or retrofit. Due to the fact that older playgrounds are often exposed to the summer sun and heat,the 2007 Parks, Recreation and Open Space Master Plan makes specific recommendations for parks to construct shade structures over play areas.This project will serve to provide a safe, accessible and high quality play experience for our citizens to enjoy for years to come. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2023 12/2023 Other REVISION EXPLANATION Additional funds are needed for the Tommy and Sue Brown Playground Replacement for increased shade and play value.The requested funding would come from PK2202-Cross Timbers Playground Replacement with Shade. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Park Sale Tax(125) Reserves $300,000 $0 $300,000 $0 $300,000 Reserves-Impact Fees 0 1,845 1,845 0 $1,845 0 0 0 0 $0 0 0 0 0 $0 0 0' 0 0 $0 Total $300,000 $1,845' $301,845 $0 $301,845 PROJECT EXPENDITURES Professional Services $0 $0' $0 $0 $0 Engineering/Design 0 0' 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 300,000 1,845' 301,845 0 $301,845 Other 0 0 0 0 $0 Total $300,000 $1,845 $301,845 $0 $301,845 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 _ 2027/28 TOTAL Projected $0 Parks & Recreation Capital Projects Ordinance 3861 Tommy & Sue Brown Playground Replacement with Shade Attachment"B" Page 49 of 77 PK2407 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the replacement of the playground at Tommy and Sue Brown Park.This playground was constructed in 2004. From the original construction, parts are no longer available for replacement or retrofit. Due to the fact that older playgrounds are often exposed to the summer sun and heat,the 2007 Parks, Recreation and Open Space Master Plan makes specific recommendations for parks to construct shade structures over play areas. This project will serve to provide a safe, accessible and high quality play experience for our citizens to enjoy for years to come. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2023 12/2023 Other REVISION EXPLANATION Additional funds are needed for the Tommy and Sue Brown Playground Replacement for increased shade and play value. The requested funding would come from PK2303-Dr. Pillow Park Playground Replacement with Shade,which is a completed project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves-Park Sales Tax(125) $300,000 $0 $300,000 $0 $300,000 Reserves-Impact Fees 1,845 3,722 5,567 0 $5,567 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $301,845 $3,722 $305,567 $0 $305,567 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 301,845 3,722 305,567 0 $305,567 Other 0 0 0 0 $0 Total $301,845 $3,722 $305,567 $0 $305,567 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Parks & Recreation Capital Projects Ordinance 3861 Dr. Pillow Playground Replacement with Shade Attachment,"B" PK2303 Page 50 of 77 PROJECT DESCRIPTION&JUSTIFICATION This project provided for the replacement of the playground at Dr. Pillow Park. Since originally constructed in 2006,The John Barfield Trail was completed which provides a direct active transportation link to the cities of Keller and Hurst.The playground components provided limited play opportunities for a wider age range of children. The renovation project provides updated components to encourage physical activity through structured, safe and fun activities.This project has been completed. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2022 12/2023 Other REVISION EXPLANATION Additional funds are needed for the Tommy and Sue Brown Playground Replacement for increased shade and play value.The requested funding would come from PK2202-Cross Timbers Playground Replacement with Shade. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves-Park Sales Tax $200,000 $0 $200,000 $0 $200,000 Reserves-Impact Fees 38,000 (3,722) 34,278 0 $34,278 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $238,000 ($3,722) $234,278 $0 $234,278 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 238,000 (3,722) 234,278 0 $234,278 Other 0 0 0 0 $0 Total $238,000 ($3,722) $234,278 $0_ $234,278 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Parks & Recreation Capital Projects Ordinance 3861 NRH Centre Infrastructure Maintenance Attachment"B" Page 51 of 77 PK2402 PROJECT DESCRIPTION&JUSTIFICATION This project provides funding for NRH Centre infrastructure in response to age, use, damage, and safety.The FY23/24 priorities include:Aquatics slide painting, Bathroom fixture renovation,Trash can replacement, Furniture replacement and repair. With the NRH Centre in its eleventh year of operation,the infrastructure and maintenance needs of the facility continue to grow. Staff is developing an asset management plan for all items requiring replacement or repairs outside of the annual operations budget. Through the years the NRH Centre has continued to operate at a level allowing for contribution of funds to reserves. This annual maintenance plan in conjunction with the long range facility capital plan will allow for responsible use of those reserves whilestill allowing the NRH Centre to continue to contribute to reserves. Funding Source:$50,000 from the NRH Centre Fund Reserves(126) PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2023 09/2024 REVISION EXPLANATION With the assistance of IT the NRH Centre was able to change cable TV providers at the NRH Centre. With the line upgrades made by Spectrum they were no longer able to provide reliable consistent service of all channels. The change was not anticipated or budgeted so the funds were taken out of the NRH Centre Infrastructure Maintenance. This revision will replenish the funds for the necessary projects required at the aging NRH Centre facility. FINANCIAL DATA ADOPTED pia i1,P 'i REVISED TOTAL BUDGET THRU PROJECT° ; BUDGET THRU REMAINING PROJECT 2023/24 ���REVIS ON 2023/24 BALANCE COST FUNDING SOURCES , I4'41"-r"J". vCP,,, ��, NRH Centre Reserves $50,000 a'$26,7> $76,795 $0 $76,795 0a.-,. ; .,0, 0 0 $0 0 4,;,,,"Oi 0 0 $0 0 � I�� h' EI 0 0 $0 0 :i��Ii III II�91P� 'i'IM' ' 0 il' 0', 0 $0 Total $50,000 ' z $26,795 $76,795 $0 $76,795 PROJECTEXPENDITURES _ , ,. 'E ia. =n, x , s� Professional Services $0 $f $0 $0 $0 Engineering/Design 0 , 0 0 0 $0 Land/ROW Acquistion 0 , `� ` 0: 0 0 $0 Construction 010; 0 0 $0 n. Other ' 50,000 i1�26,7 76,795 0 $76,795 Total $50,000 $26,795 $76,795 $0 $76,795 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Aquatic Park Capital Projects Ordinance 3861 Green Extreme Replacement Design and Construction Attachment"B" WP2305 Page 52 of 77 PROJECT DESCRIPTION&JUSTIFICATION This project serves to engage a professional services consultant/design firm to plan,design and implement the plan in conjunction with city staff for the removal of the existing Green Extreme attraction and the installation of a new attraction in the place of the Green Extreme. As the water park continues to age, attractions will reach their expected end of life usefulness and need to be replaced.The Green Extreme was installed in 1998. Most water slides or attractions have a life expectancy of 15-20 years.The Green Extreme is now at the point where it needs to be replaced with a newer, more energy efficient, attraction with a larger throughput that allows for NRH2O to continue to move forward and attract new guests as well as retain current ones.This new attraction will also present the water park with new opportunities for revenue growth and a new attraction that is not only efficient fiscally, but also allows for savings in number of staff needed to run the attraction and continues to present the park as an amusement park that continues to grow and move forward. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2022 09/2023 Land/ROW Acquisition Construction 10/2023 07/2023 10/2024 09/2024 Other REVISION EXPLANATION Project savings from WP2405 is being transferred into WP2305 in order to account for additional costs on that project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES ' Reserves $342,014 '$115,625 $357,639 $0 $357,639 Certificates of Obligation 5,400,000 5,400,000 0 $5,400,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $5,742,014 $15,625 $5,757,639 $0 $5,757,639 PROJECT EXPENDITURES Professional Services $342,014 $0 $342,014 $0 $342,014 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 5,400,000 15,625 5,415,625 0 $5,415,625 Other 0 0 0 0 $0 Total $5,742,014 $15,625' $5,757,639 $0 $5,757,639 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Aquatic Park Capital Projects Ordinance 3861 NRH2O Accelerator Slide Resurface Attachment"a" Page 53 of 77 WP2405 PROJECT DESCRIPTION&JUSTIFICATION This project consists of costs for labor and materials to strip the existing ride surface, patch the existing ride surface, repair slide seams, and resurface the ride surface of NRH2O's Accelerator Slide. This project is important in order to maintain the Accelerator slide in safe operating condition and aid in extending the life span of the attraction. Due to age, use of mats on the slide surface, UV exposure and chlorinated water,fiberglass ride surfaces on the Accelerator have faded and dulled and require a complete slide surface repair and resurface.This product will refurbish the Accelerator with a specialized coating which will improve the colors and lifespan of the attraction. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2023 02/2024 Other REVISION EXPLANATION Project savings from WP2405 is being transferred into WP2305 in order to account for additional costs on that project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Aquatic Park Infrastructure Reserves $100,000 ;, ($15,625) $84,375 $0 $84,375 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $100,000 ($15,625) $84,375 $0 $84,375 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0` 0 0 $0 Land/ROWAcquistion 0 0 0 0 $0 Construction 100,000 C'15,625) 84,375 0 $84,375 Other 0 0 0 0 $0 Total $100,000 ($15,625) $84,375 $0 $84,375 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Municipal Facility Capital Projects Ordinance 3861 FD/PD Training and Fire Station#5 Roof and Window Replacement Attachment"B" Page 54 of 77 FC2404 PROJECT DESCRIPTION&JUSTIFICATION The fire station was built in 1988.This request is to replace the roofing system, improve the building envelope, and replace the windows and screens at the FD/PD Training Center and Fire Station#5.The windows located on the training side of the facility leak a considerable amount allowing cold air in during the winter and cool air out during the hotter months.The window screens for all windows are missing which prevents the ability to open the windows during nice weather. The request is to replace the windows and the window screens at the training side of the facility as well as the roofing system on the entire building. The roofing system at FD/PD training and Fire Station#5 is at the end of life. This project coupled with replacing the windows will reduce the utility costs for the facility and improve interior conditions. The envelope will also be addressed, removing any water infiltration, upgrading caulking,and improving indoor air quality. Funding sources is Certificates of Obligation for$557,000. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering 04/2024 12/2024 Land/ROW Acquisition Construction 10/2023 09/2024 12/2024 Other REVISION EXPLANATION This transfer is necessary to reflect the cost of engineering services associated with this project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Certificates of Obligation $557,000 $0 $557,000 $0 $557,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $557,000 $0 $557,000 $0 $557,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 30,000 30,000 0 $30,000 Land/ROW Acquistion 0 0 0 0 $0 Construction 557,000 (30,000) 527,000 0 $527,000 Other 0 0 0 0 $0 Total $557,000 $0 $557,000 $0 $557,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Municipal Facility Capital Projects Ordinance 3861 FD/PD Training and Fire Station#5 Roof and Window Replacement Attachment"B" FC2404 Page 55 of 77 PROJECT DESCRIPTION&JUSTIFICATION The fire station was built in 1988.This request is to replace the roofing system, improve the building envelope, and replace the windows and screens at the FD/PD Training Center and Fire Station#5. The windows located on the training side of the facility leak a considerable amount allowing cold air in during the winter and cool air out during the hotter months.The window screens for all windows are missing which prevents the ability to open the windows during nice weather.The request is to replace the windows and the window screens at the training side of the facility as well as the roofing system on the entire building. The roofing system at FD/PD training and Fire Station#5 is at the end of life. This project coupled with replacing the windows will reduce the utility costs for the facility and improve interior conditions.The envelope will also be addressed, removing any water infiltration, upgrading caulking, and improving indoor air quality. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering 04/2024 12/2024 Land/ROW Acquisition Construction 09/2024 12/2024 Other REVISION EXPLANATION Capital fund balance reserves are sufficient to fund this project without selling certificates of obligation. Changing funding source from Certificates of Obligation to Facility Capital Projects Fund(370) Reserves. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 u 1 REVISION 2023/24 BALANCE COST FUNDING SOURCES ' Certificates of Obligation $557,000 ($557,000) $0 $0 $0 Facility CIP Fund(370) Reserves 0 557,000 557,000 0 $557,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $557,000 „ $0 $557,000 $0 $557,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 30,000 0 30,000 0 $30,000 Land/ROW Acquistion 0 0 0 0 $0 Construction 527,000 0 527,000 0 $527,000 Other 0 0 0 0 $0 Total $557,000 $0' $557,000 $0 $557,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Municipal Facility Capital Projects Ordinance 3861 Fire Station#4 - Roof Replacement Attachment"B" FC2407 Page 56 of 77 PROJECT DESCRIPTION&JUSTIFICATION This request is to replace the roofing system and improve the building envelope at Fire Station#4. The roofing system at Fire Station#4 is at the end of life. The envelope will also be addressed removing any water infiltration, upgrading caulking, and improve indoor air quality. Funding sources is Certificates of Obligation for$255,000. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering 04/2024 12/2024 Land/ROW Acquisition Construction 10/2023 09/2024 12/2024 Other REVISION EXPLANATION This transfer is necessary to reflect the cost of engineering services associated with this project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Certificates of Obligation $255,000 $0 $255,000 $0 $255,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $255,000 $0 $255,000 $0 $255,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 30,000 30,000 0 $30,000 Land/ROW Acquistion 0 0 0 0 $0 Construction 255,000 (30,000) 225,000 0 $225,000 Other 0 0 0 0 $0 Total $255,000 $0 $255,000 $0 $255,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Municipal Facility Capital Projects Ordinance 3861 Fire Station#4-Roof Replacement Attachment"B" Page 57 of 77 FC2407 PROJECT DESCRIPTION&JUSTIFICATION This request is to replace the roofing system and improve the building envelope at Fire Station#4. The roofing system at Fire Station#4 is at the end of life. The envelope will also be addressed removing any water infiltration, upgrading caulking,and improve indoor air quality. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering 04/2024 12/2024 Land/ROW Acquisition Construction 09/2024 12/2024 Other REVISION EXPLANATION Capital fund balance reserves are sufficient to fund this project without selling certificates of obligation. Changing funding source from Certificates of Obligation to Facility Capital Projects Fund(370) Reserves. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Certificates of Obligation $255,000 ($255,000) $0 $0 $0 Facility CIP Fund(370) Reserves 0 255,000 255,000 0 $255,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $255,000 $0 $255,000 $0 $255,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 30,000 0 30,000 0 $30,000 Land/ROW Acquistion 0 0 0 0 $0 Construction 225,000 0 225,000 0 $225,000 Other 0 0 0 0 $0 Total $255,000 $0 $255,000 $0 $255,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Municipal Facility Capital Projects Ordinance 3861 NRH Centre Dectron Replacement Engineering Attachment°B^ FC2411 Page 58 of 77 PROJECT DESCRIPTION&JUSTIFICATION In order to gain design analysis and data for the full replacement of the NRH Centre Aquatics area Dectron HVAC unit the need to analyze and model the new unit design specific to this facility is needed.The professional design and analysis will include both the specifics of the existing indoor space airflow with the unique design of the replacement HVAC unit to ensure the facility is achieving the best indoor air quality possible. The NRH Centre Indoor Aquatics Dectron HVAC system is original to the facility and has seen significant repair needs over the past few years.The system must be maintained at maximum capacity in order to handle the Texas climate and harsh indoor aquatics environment.With the most recent major repairs,the vendor has indicated that full system replacement will be necessary within the next few years. Due to customization required for such installation, it is necessary that we prepare for the full replacement prior to system failure as aquatics closure would severely impact membership and revenues at the NRH Centre. This professional engineering study will analyze and model the airflow within the space as well as provide a PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services 10/2023 09/2024 09/2024 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Project is in design. Project savings roll from FC2410, NRH Centre Exterior Metal Panel Repair to CIP project FC2411 NRH Centre Dectron Replacement Engineering. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves $95,000 $16,680 $111,680 $0 $111,680 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $95,000 $16,680 $111,680 $0 $111,680 PROJECT EXPENDITURES Professional Services $95,000 $16,680 $111,680 $0 $111,680 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 $0 Other 0 0 0 0 $0 Total $95,000 $16,680' $111,680 $0 $111,680 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Municipal Facility Capital Projects Ordinance 3861 NRH Centre- Exterior Metal Panel Repair Attachment"B" Page 59 of 77 FC2410 PROJECT DESCRIPTION&JUSTIFICATION This request is to remove and repair the exterior metal panels on the southwest and west elevations of the NRH Centre. Several panels have become loose and are not attached to the building. Recent wind has compounded this issue. The metal panels have to be removed and re-formed in a fabrication shop. The west facing panels have been through many cycles of extreme heat.The integrity of the panels will be restored,extending the life of the exterior envelope. Funding Source: Is$60,000 from NRH Center Reserves. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2023 09/2024 06/2024 Other REVISION EXPLANATION Project is complete. Project savings roll to CIP project FC2411 NRH Centre Dectron Replacement Engineering. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT" BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Reserves-NRH Centre Fund(126) $60,000 ($16,680) $43,320 $0 $43,320 0 4 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $60,000 ($16,680) $43,320 $0 $43,320 PROJECT EXPENDITURES Professional Services $0 $0[ $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 60,000 (16,680), 43,320 0 $43,320 Other 0 0 0 0 $0 Total $60,000 ($16,680) $43,320 $0 $43,320 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Municipal Facility Capital Projects Ordinance 3861 ARPA FACILITY GENERATORS Attachment"B" FC2200 Page 60 of 77 PROJECT DESCRIPTION&JUSTIFICATION The purpose of the generator feasibility study is to provide a report evaluating the feasibility of electrical equipment upgrades. The project will evaluate(13)facilities. The(13)facilities include:Animal Adoption and Rescue Center, Park Operations, Permanent Records/Public Works Training, Facilities&Construction/Fleet Admin/Fire Maintenance, Public Library, NRH Centre/Grand Hall, Public Works Operations/Fleet Maintenance, NRH2O Pump House/Warehouse, Fire Station#1, Fire Station#2, Fire Station#3, Fire Station#4, Fire Station #5. Upon completion of the study, FNI will render an electrical, structural, and civil report for each of the 13 facilities. Each facility's report will include the estimated size of the generator and automatic transfer switch; potential locations for electrical equipment; and a rough order of magnitude costs for electrical equipment upgrades and design.A final report will be compiled to show existing data and conditions,evaluations, calculations, and recommendations. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services 01/2022 12/2023 Engineering Land/ROW Acquisition Construction 07/2023 12/2024 Other REVISION EXPLANATION ARPA FACILITY GENERATORS FC2200 project savings to be rolled back into other ARPA projects FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES ARPA Grant $853,000 ($25,000), $828,000 $0 $828,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $853,000 ($25,000) $828,000 $0 $828,000 PROJECT EXPENDITURES Professional Services $103,000 $0 $103,000 $0 $103,000 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 750,000 (25,000) 725,000 0 $725,000 Other 0 0 0 0 $0 Total $853,000 ($25,000) $828,000 $0 $828,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Major Capital Equipment Capital Projects Ordinance 3861 Network Replacement for Offsite City Facilities Attachment"B" Page 61 of 77 IT1901 PROJECT DESCRIPTION&JUSTIFICATION Purchase and installation of network hardware and software for three offsite City Facilities. This is a two year project with planned replacement in year 1 for the NRH2O and year 2 is planned replacement for Fire Training and Public Works facilities. This project encompasses all costs associated with engineering, design, hardware staging(for configuration),data migration, installation, site configuration, project management,training and knowledge transfer to City staff. This project includes equipment for the 15 intermediate data rooms at those locations including upgraded wireless access points. The system design of this project positions the City to meet the demands of continued changes and expansion of technology.This project encompasses all costs associated with engineering,design, hardware staging(for configuration),data migration, installation, site configuration, project management,training and knowledge transfer to City staff. This project includes equipment for the 15 intermediate data rooms at those locations including upgraded wireless access points. The system design of this project positions the City to meet the demands of continued changes and expansion of technology. Project Status Update: Phase onen PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Parts of IT1901 and IT2410 include upgrading the wireless access points at various city facilities. IT1901 will be closed out and the balance transfered to IT2410 so that all expenses pertaining to the upgrade fall under one project(IT2410). FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Certificates of Obligation $120,000 ($120,000)', $0 $0 $0 Reserves 101,167 (5,905) 95,262 0 $95,262 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $221,167 ($125,905) $95,262 $0 $95,262 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 221,167 (125,905);, 95,262 0 $95,262 Total $221,167 ($125,905)'r $95,262 $0 $95,262 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Major Capital Equipment Capital Projects Ordinance 3861 Technology Upgrades Attachment"B" Page 62 of 77 IT2410 PROJECT DESCRIPTION&JUSTIFICATION City Hall's Distributed Antenna System(DAS)boosts cell phone signals inside City Hall and boosts radio communication in the jail.The manufacturer of the City's current DAS has decided to stop product support so the DAS hardware is now End of Life. Wireless access points connect devices to the network and Internet via Wi-Fi. Upgrading this equipment increases the speed of the wireless network and provides more security.The Storage Array upgrade is an increase in the Primary storage and DR storage used to house all City data. With the City's DAS no longer being supported by the manufacturer, replacement parts are not available to make repairs. Without DAS,jail radios do not work and cell phone coverage diminishes.There are DAS systems on the market that are still in production and can be selected from as a replacement for the City's current DAS that is no longer supported.The wireless access points and controller in City Hall need to be upgraded. The age of the controller at City Hall makes it impossible to upgrade the other facilities because the current controller is no longer compatible with the newer wireless access points that PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Parts of IT1901 and IT2410 include upgrading the wireless access points at various city facilities. IT1901 will be closed out and the balance transfered to IT2410 so that all expenses pertaining to the upgrade fall under one project(IT2410). FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU w PROJECT BUDGET THRU REMAINING PROJECT 2023/24 ,,,REVISION 2023/24 BALANCE COST FUNDING SOURCES Certificates of Obligation $1,180,000 $0 $1,180,000 $0 $1,180,000 Project Savings 0 125,905 125,905 0 $125,905 0 0 0 0 $0 0 0 0 0 $0 0 0' 0 0 $0 Total $1,180,000 $125,905 $1,305,905 $0 $1,305,905 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0' 0 0 $0 Other 1,180,000 125,905 1,305,905 0 $1,305,905 Total $1,180,000 $125,905 $1,305,905 $0 $1,305,905 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Major Capital Equipment Capital Projects Ordinance 3861 Technology Upgrades Attachment"B" Page 63 of 77 IT2410 PROJECT DESCRIPTION&JUSTIFICATION City Hall's Distributed Antenna System(DAS)boosts cell phone signals inside City Hall and boosts radio communication in the jail.The manufacturer of the City's current DAS has decided to stop product support so the DAS hardware is now End of Life. Wireless access points connect devices to the network and Internet via Wii-Fi. Upgrading this equipment increases the speed of the wireless network and provides more security. The Storage Array upgrade is an increase in the Primary storage and DR storage used to house all City data. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services 10/2023 07/2025 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Capital fund balance reserves are sufficient to fund this project without selling certificates of obligation. Changing funding source from Certificates of Obligation to Capital Projects Reserve Fund(341) Reserves. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES '� Certificates of Obligation $1,180,000 ` !($1,180,000) $0 $0 $0 Certificates of Obligation from IT1901 120,000 0 120,000 0 $120,000 Reserves from IT1901 5,905 0 5,905 0 $5,905 CIP Reserve Fund(341)Reserves 0 1,180,000 1,180,000 0 $1,180,000 0 0 0 0 $0 Total $1,305,905 $0 $1,305,905 $0 $1,305,905 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 1,305,905 0 1,305,905 0 $1,305,905 Total $1,305,905 ' $0 $1,305,905 $0 $1,305,905 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Major Capital Equipment Capital Projects Ordinance 3861 Network Switches Upgrade Attachment„B„ Page 64 of 77 IT2301 PROJECT DESCRIPTION&JUSTIFICATION Access switch refresh for AARC, Service Center, Park Maintenance, and Library. The network switches in these locations are 7+years old.This exceeds the best practice life cycle. Upgrading the switch will ensure the network equipment is using the newest security features and provide better performance. Funding Source: $160,000 from Information Technology Capital Reserves. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2022 03/2024 09/2024 REVISION EXPLANATION Transfer the funds of$3,482.00 from IT2301 (NETWORK SWITCHES UPGRADE)and move the funds to the Professional Services line for project IT1701 (ERP SYSTEM REPLACEMENT). FINANCIAL DATA .... ...... ......... ADOPTED REVISED TOTAL BUDGET THRU PROJECT. BUDGET THRU REMAINING PROJECT 2022/23 REVISION " 2022/23 BALANCE COST FUNDING SOURCES Reserves $160,000 ($3,482) $156,518 $0 $156,518 0 0 0 0 $0 0 0 0 0 $0 0 0. 0 0 $0 0 0 0 0 $0 Total $160,000 ($3,482) $156,518 $0 $156,518 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROWAcquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 160,000 (3,482) 156,518 0 $156,518 Total $160,000 ($3,482) $156,518 $0 $156,518 IMPACT ON OPERATING BUDGET Not applicable. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Major Capital Equipment Capital Projects Ordinance 3861 ERP System Replacement Attachment",B,. Page 65 of 77 1T1701 PROJECT DESCRIPTION&JUSTIFICATION This project is for the purchase and replacement of the current enterprise computer system serving the city of North Richland Hills. The City of North Richland Hills currently has the Superion Public Sector enterprise resource planning system. Modules currently in use are those related to accounting/finance, purchasing, budget, utility billing, building permits,fleet management and licenses. The City has utilized Superion since 1998. Both business and technology needs have changed dramatically since implementation of Superion.With a new system costs should be reduced, it will improve decision making by providing easier access to information, improve customer service both internally and externally, improve efficiency and effectiveness of business operations and PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services 02/2018 03/2024 09/2018 Engineering Land/ROW Acquisition Construction Other 10/2018 09/2024 REVISION EXPLANATION Transfer the funds of$3,482.00 from IT2301 (NETWORK SWITCHES UPGRADE)and move the funds to the Professional Services line for project IT1701 (ERP SYSTEM REPLACEMENT). FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Certificates of Obligation $2,905,000 $0 $2,905,000 $0 $2,905,000 Reserves 777,527 3,482 781,009 0 $781,009 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $3,682,527 $3,482 $3,686,009 $0 $3,686,009 PROJECT EXPENDITURES Professional Services $436,059 $3,482 $439,541 $0 $439,541 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 3,246,468 0 3,246,468 0 $3,246,468 Total $3,682,527 $3,482 $3,686,009 $0 $3,686,009 IMPACT ON OPERATING BUDGET Operating impact will be determined at a future date when new system is implemented. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Major Capital Equipment Capital Projects Ordinance 3861 2014 Hydro Excavator and Trailer(#5565) Replacement Attachment"B" Page 66 of 77 FS2403 PROJECT DESCRIPTION&JUSTIFICATION This is a nine year old unit at the end of its useful life cycle. It is used to excavate around sensitive fiber optic cables, gas lines and cables. This unit was originally purchased by Public Works and is used every day in hydro excavation where excavating is prohibited with back hoes and other heavy equipment to insure fiber optics,gas lines and cable are not damaged.This unit is constantly in the shop due to ongoing maintenance and repair issues and the steel tank is beginning to wear thin to the point that is continuously is cracking and has to be welded. The unit operates using a vacuum and therefore becomes relatively useless when the tank cracks and will not allow a vacuum to be pulled to remove dirt and debris. Funding Source: Utility Fund 412 Reserves. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2023 10/2023 09/2024 09/2024 REVISION EXPLANATION Project savings have been identified that need to be transferred to Project FS2404-2011 Trailer Mounted Trash Pump Replacement(#5544). The Holland Pump Company's quote for the Atlas Copco Attenuated Pump Trailer Mount came in at $83,486.00-an amount exceeding the CIP Budget approval of$68,000.00. Public Works required 500 additional feet of 6-inch piping for the discharge hose, as well as the need to"remote monitor"the system. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Utility Capital Fund 412 Reserves. $173,500 ($15,486) $158,014 $0 $158,014 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $173,500 ($15,486) $158,014 $0 $158,014 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 173,500 (15,486) 158,014 0 $158,014 Total $173,500 ($15,486) $158,014 $0 $158,014 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Major Capital Equipment Capital Projects Ordinance 3861 2011 Trailer Mounted Trash Pump Replacement(#5544) Attachment"B" Page 67 of 77 FS2404 PROJECT DESCRIPTION&JUSTIFICATION Twelve year old trash pump with engine locked up and needing replacement. The engine has locked up and will require replacement that costs more than the unit is worth. This unit is used to remove water in excavated areas, in emergency flood areas, and for sewage. Funding Source: Utility Capital Fund Reserves(412). PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2023 10/2023 09/2024 09/2024 REVISION EXPLANATION Project savings have been identified that need to be transferred to Project FS2404-2011 Trailer Mounted Trash Pump Replacement(#5544).The Holland Pump Company's quote for the Atlas Copco Attenuated Pump Trailer Mount came in at $83,486.00-an amount exceeding the CIP Budget approval of$68,000.00. Public Works required 500 additional feet of 6- inch piping for the discharge hose, as well as the need to"remote monitor"the system. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Utility Capital Projects Fund(412) $69,000 $15,486 $84,486 $0 $84,486 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $69,000 $15,486 $84,486 $0 $84,486 PROJECT EXPENDITURES Professional Services $0 $0' $0 $0 $0 Engineering/Design 0 0' 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 69,000 15,486 84,486 0 $84,486 Total $69,000 $15,486 $84,486 $0 $84,486 IMPACT ON OPERATING BUDGET Not applicable. ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected 0 0 0 0 0 $0 Major Capital Equipment Capital Projects Ordinance 3861 Backup Fiber for City Hall Attachment"B" 1T2202 Page 68 of 77 PROJECT DESCRIPTION&JUSTIFICATION Installation of a secondary fiber internet connection and related hardware to provide a more robust system that provides citywide redundancy for communication and data traffic throughout all city facilities. In July we experienced an internet outage that was caused by a single point of failure at our providers NOC location.Adding multiple redundant routes to separate locations will allow us to provide a much more reliable system. Funding sources are comprised of$183,100 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 06/2023 12/2024 REVISION EXPLANATION Transfer the funds of$6,166 from the ARPA Backup Fiber for City Hall project IT2202 and move the funds to SCADA System Upgrade project IT2205. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Federal/State Grants $183,100 ($6,166) $176,934 $0 $176,934 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $183,100 ($6,166) $176,934 $0 $176,934 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 183,100 (6,166) 176,934 0 $176,934 Total $183,100 ($6,166)I' $176,934 $0 $176,934 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Major Capital Equipment Capital Projects Ordinance 3861 SCADA System Upgrade Attachment",B,. Page 69 of 77 IT2205 PROJECT DESCRIPTION&JUSTIFICATION Install an upgraded server that supports the SCADA System in a server class environment with proper power and redundancy. During the winter storm in 2021 there was a power outage at a city facility where the current SCADA server is located. Moving this and upgrading to new hardware to another location with backup power and network redundancy will improve the system reliability. Funding sources are comprised of$60,000 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 08/2022 07/2025 REVISION EXPLANATION Transfer the funds of$6,166 from the ARPA Backup Fiber for City Hall project IT2202 and move the funds to SCADA System Upgrade project IT2205. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Federal/State Grants $60,000 $6,166 $66,166 $0 $66,166 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $60,000 $6,166 $66,166 $0 $66,166 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 60,000 6,166 66,166 0 $66,166 Total $60,000 $6,166 $66,166 $0 $66,166 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 _ 2024/25 2026/26 2026/27 2027/28 TOTAL Projected $0 Major Capital Equipment Capital Projects Ordinance 3861 SCADA SYSTEM UPGRADE Attachment"B" Page 70 of 77 IT2205 PROJECT DESCRIPTION&JUSTIFICATION Install an upgraded server that supports the SCADA System in a server class environment with proper power and redundancy. During the winter storm in 2021 there was a power outage at a city facility where the current SCADA server is located. Moving this and upgrading to new hardware to another location with backup power and network redundancy will improve the system reliability. Funding sources are comprised of$60,000 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 08/2022 07/2025 REVISION EXPLANATION Transfer the funds of$628 from the ARPA Replace Nexus Network Switches project IT2207 and move the funds to the SCADA System Upgrade project IT2205. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Federal/State Grants $66,166 $628 $66,794 $0 $66,794 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $66,166 $628_ $66,794 $0 $66,794 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 66,166 628 66,794 0 $66,794 Total $66,166 $628 $66,794 $0 ' $66,794 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Major Capital Equipment Capital Projects Ordinance 3861 ARPA-REPLACE NEXUS NETWORK SWITCHES Attachment"B" 1T2207 Page 71 of 77 PROJECT DESCRIPTION&JUSTIFICATION Replacement of existing rack switches in the Main Data Center in City Hall and the Public Safety Training Center.These switches have reached end-of-life and will no longer be supported by the vendor. These switches are the core network switches connecting City Hall to all other City facilities and buildings.All connections to city buildings/facilities either come from City Hall or the Public Safety Training Center.These switches connect City Hall to Public Safety Training Center.As an end-of-life switch,the vendor began to limit their support of the switches. October 2021 was the last date for any new releases of the software for this switch.After this date,the vendor no longer developed, repaired, maintained,or tested the switch software(inclusive of network security updates). Purchase will include 5 years of maintenance. Funding sources are comprised of$153,000 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 06/2023 12/2024 REVISION EXPLANATION Transfer the funds of$628 from the ARPA Replace Nexus Network Switches project IT2207 and move the funds to the SCADA System Upgrade project IT2205. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Federal/State Grants $153,000 ($628), $152,372 $0 $152,372 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $153,000 ($628) $152,372 $0 $152,372 PROJECT EXPENDITURES Professional Services $39,931 ($299) $39,632 $0 $39,632 Engineering/Design 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 113,069 (329) 112,740 0 $112,740 Total $153,000 ($628) $152,372 $0 $152,372 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT _ 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Major Capital Equipment Capital Projects Ordinance 3861 Crew Cab Dump Truck Replacement(#6618) Attachment"B" FS2405 Page 72 of 77 PROJECT DESCRIPTION&JUSTIFICATION This is a replacement for a 2004 Chevy Kodiak crew cab dump truck(#6618). This unit has reached the end of its life expectancy and maintenance costs and down time are both increasing. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2023 09/2024 REVISION EXPLANATION Capital fund balance reserves are sufficient to fund this project without selling certificates of obligation. Changing funding source from Certificates of Obligation to Fleet Capital Projects Fund(375)Reserves. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES $1 ','P! Certificates of Obligation $206,000 ($206,000) $0 $0 $0 Fleet CIP Fund(375)Reserves 0 206,000 206,000 0 $206,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $206,000 $0 $206,000 $0 $206,000 ;PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 206,000 . 0 206,000 0 $206,000 Total $206,000 $0 $206,000 $0 $206,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Major Capital Equipment Capital Projects Ordinance 3861 Ambulance Replacement(Unit#991) Attachment„B„ FS2408 Page 73 of 77 PROJECT DESCRIPTION&JUSTIFICATION This is a life-cycle replacement for a 2014 Frazer Ambulance.This project cost includes the purchase of the vehicle, make ready, and equipment/supplies. This ambulance has reached the end of its life-cycle.The mileage is 155,000 mis and it has 11,000 hours(equal to 374,000 mis). PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2023 09/2024 REVISION EXPLANATION Capital fund balance reserves are sufficient to fund this project without selling certificates of obligation. Changing funding source from Certificates of Obligation to Fleet Capital Projects Fund(375) Reserves. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 a' REVISION 2023/24 BALANCE COST FUNDING SOURCES Certificates of Obligation $319,500 ($319,500) $0 $0 $0 Reserves Fleet Fund(520) 40,000 0 40,000 0 $40,000 Reserves-Project Savings 84,500 0 84,500 0 $84,500 Reserves-Fleet CIP Fund(375) 0 319,500 319,500 0 $319,500 0 0 0 0 $0 Total $444,000 $0 $444,000 $0 $444,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 444,000 0 444,000 0 $444,000 Total $444,000 $0 $444,000 $0 $444,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Street & Sidewalk Capital Projects Ordinance 3861 Brush Truck Replacement(#967) Attachment"B" Page 74 of 77 FS2407 PROJECT DESCRIPTION&JUSTIFICATION This is a scheduled replacement of unit#967(a 2004 F550 Brush truck). Unit will be a diesel 4x4 crew cab w/a 250 gpm skid unit w/300 gallons of water,class A foam system and a 200'booster reel. Estimated cost of the replacement unit is $281,500.00 including equipment and Make Ready cost. Maintain ability to combat fires in isolated or confined areas. Brush trucks have the ability to attack brush fires off road,which an engine or quint cannot access. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Capital fund balance reserves are sufficient to fund this project without selling certificates of obligation. Changing funding source from Certificates of Obligation to Fleet Capital Projects Fund(375)Reserves. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Certificates of Obligation $212,500 ($212,500) $0 $0 $0 Reserves-Fleet Fund(520) 69,000 0 69,000 0 $69,000 Fleet CIP Fund(375)Reserves 0 212,500 212,500 0 $212,500 0 0 0 0 $0 0 0 0 0 $0 Total 1 $281,500 $0, $281,500 $0 $281,500 PROJECT EXPENDITURES Professional Services $0 $0, $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 281,500 0 281,500 0 $281,500 Total $281,500 $0 $281,500 $0 $281,500 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Major Capital Equipment Capital Projects Ordinance 3861 Network Refresh Attachment"B" IT2405 Page 75 of 77 PROJECT DESCRIPTION&JUSTIFICATION This is to refresh the network hardware in all ten IT closets. The hardware in these closets connect phones,computers, printers and any other network capable device that attaches to the City's network. The current network equipment was purchased in 2015 when City Hall was being built. The equipment has exceed its recommended life cycle. Cisco Engineering stopped releasing software maintenance releases and bug fixes in October 2021 and no longer develops, repairs, maintains, or tests the product software. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2023 07/2025 REVISION EXPLANATION Capital fund balance reserves are sufficient to fund this project without selling certificates of obligation. Changing funding source from Certificates of Obligation to Capital Projects Reserve Fund(341)Reserves. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2023/24 REVISION 2023/24 BALANCE COST FUNDING SOURCES Certificates of Obligation $1,300,000 ($1,300,000) $0 $0 $0 Reserves-CIP Reserve Fund(341) 0 1,300,000 1,300,000 0 $1,300,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $1,300,000 $0 $1,300,000 $0 $1,300,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 1,300,000 0 1,300,000 0 $1,300,000 Total $1,300,000 $0 $1,300,000 $0 $1,300,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Other Capital Projects ce 861 ES2301 Ordinance Attachment"B" Page 76 of3 77 Neighborhood Initiative Program PROJECT DESCRIPTION&JUSTIFICATION The Neighborhood Initiative Program(NIP)has been assisting the elderly, single parent,veterans and persons with disabilities with minor exterior home repairs since 2004.This program helps residents continue living safely and comfortably in their own homes and also helps to make their neighborhoods a better place to live. Quality community development and revitalization continues to be one ofi City Council's primary goals for North Richland Hills. The Neighborhood Initiative Program is the City's primary residential revitalization program that works toward accomplishing this goal. NIP is designed to bring about community support and involvement for improving the livability of NRH neighborhoods, and targets help toward residents who are physically and financially unable to keep their houses in a livable condition. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services 10/2022 10/2022 09/2024 02/2024 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Staff is asking to move the remaining balance in this project to ES2401 to cover costs associated with the FY24 Neighborhood Initiative Program. FINANCIAL DATA ADOPTED y REVISED TOTAL BUDGET THRU , PR O���ECT BUDGET THRU REMAINING PROJECT 2023/24 SION 2023/24 BALANCE COST FUNDING SOURCES. wt* t , ;u 99 u' " Reserves $34,970 $34,970 $0 $34,970 Reserves 1,305 � �� 1,305 0 $1,305 Transfer out to ES2401 0444 (4,144) 0 ($4,144) 0 tl 0 0 $0 0 0 0 0 $0 Total $36 275 3, ,Uo ���t ,f44) $32,131 $0 $32,131 PROJECT EXPENDITURES , Professional Services $36,275 I��'�'�' .1 )x. $32,131 $0 $32,131 Engineering/Design 0I: 0 0 $0 Land/ROW Acquistion 0 k � P'0' 0 0 $0 Construction 0 0' 0 0 $0 Other 0 lG� ti �.Et 0 0 $0 Total $36,275 04,144 $32,131 $0 $32,131 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0 Other Capital Projects Ordinance 3861 ES2401 Attachment"B" Page 77 of 77 Neighborhood Initiative Program PROJECT DESCRIPTION&JUSTIFICATION The Neighborhood Initiative Program(NIP) has been assisting the elderly, single parent,veterans and persons with disabilities with minor exterior home repairs since 2004.This program helps residents continue living safely and comfortably in their own homes and also helps to make their neighborhoods a better place to live. Quality community development and revitalization continues to be one of City Council's primary goals for North Richland Hills. The Neighborhood Initiative Program is the City's primary residential revitalization program that works toward accomplishing this goal. NIP is designed to bring about community support and involvement for improving the livability of NRH neighborhoods, and targets help toward residents who are physically and financially unable to keep their houses in a livable condition. PROJECT STATUS ORIGINAL 2023/24 ORIGINAL 2023/24 START DATE REVISION END DATE REVISION Professional Services 10/2023 10/2023 11/2024 11/2024 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Staff is asking that the budget be revised to$17,144 in order to cover the necessary FY24 costs of the Neighborhood Initiative Program.There is funding left in ES2301 that can be moved in order to increase the budget of ES2401. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PR01" ; BUDGET THRU REMAINING PROJECT 2023/24 :RE`ISiti t ` � 2023/24 BALANCE COST FUNDING SOURCES "t; ;. w {aN,I dl"'; Reserves $13,000 IPiPN .:$0, $13,000 $0 $13,000 Transfer from ES2301 0 ti d'�i4 4,144 0 $4,144 0i NR° 'D0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $13,000 $4,144 $17,144 $0 $17,144 PROJECT EXPENDRES " $0 SUN IIIIUI $0 $0 $0 Professional Services Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 G', 0 0 $0 Construction 0 0! 0 0 $0 Other 13,000 4 144 17,144 0 $17,144 Total $13,000 ; $4,144 $17,144 $0 $17,144 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2023/24 2024/25 2025/26 2026/27 2027/28 TOTAL Projected $0