Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Ordinance 3804
ORDINANCE NO. 3804 AN ORDINANCE OF THE CITY OF NORTH RICHLAND HILLS, TEXAS, ADOPTING THE REVISED BUDGET FOR THE FISCAL YEAR OCTOBER 1, 2022 THROUGH SEPTEMBER 30, 2023, 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, 2022, and ending September 30, 2023 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 3, 2023, at least ten (10) days prior to the public hearing; and WHEREAS, such public hearing on the revised budget was duly held on August 14, 2023, 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, 2022 and ending September 30, 2023, as set forth in Attachments A and B, operating and capital project budgets for FY 2022/2023 is hereby amended and approved. Ordinance No. 3804 Page 1 of 3 SECTION 2. The revised budget for Fiscal Year 2022/2023 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 5. The City Manager, or his designee, is hereby authorized to invest any funds not needed for current use in any lawful manner. Interest accrued from investments shall be deposited to the interest income account of the funds from which the principal was invested. SECTION 6. This ordinance shall be cumulative of all provisions of ordinances and of the Code of Ordinances, City of North Richland Hills, Texas, as amended, except where the provisions are in direct conflict with the provisions of other ordinances, in which event the conflicting provisions of the other ordinances are hereby repealed. SECTION 7. It is hereby declared to be the intention of the City Council that the phrases, clauses, sentences, paragraphs and sections of this ordinance are severable, and if any phrase, clause, sentence, paragraph or section of this ordinance shall be declared unconstitutional by the valid judgment or decree of any court of competent jurisdiction, such unconstitutionality shall not affect any of the remaining phrases, clauses, sentences, paragraphs and sections of this ordinance, since the same would have been enacted by the City Council without the incorporation in this ordinance of any such unconstitutional phrase, clause, sentence, paragraph or section. SECTION 8. This ordinance shall be in full force and effect from and after its passage as provided by law, and it is so ordained. AND IT IS SO ORDAINED PASSED AND APPROVED on this 14th day of August, 2023. CITY F ORT CH 4 D HILLS By: Oscar yin ayor Ordinance No. 3804 Page 2 of 3 ou�t►I��IrrNEii,,,���� ATTEST: ���‘,(. "• .C. .1„ HiJj'':2 6% low Alicia Richardson City Secretary/Chief Goverria;,�rr f ►►i,,,`t�." �ur.nu APPROVED AS FORM AND LEGALITY: aleshia B. McGinnis, City Attorney APPROVED AS TO CONTENT: TrudyJJ i& Director of Budget and Research Ordinance No. 3804 Page 3 of 3 N` ' Ordinance No.3804 R 9 Attachment A ry Page 1 of 29 I4.- • _. =r 4IT . /. ram �. �' .. ' 4,- ". '' ..:....: 4..111*''-'".>''''''......'.....- � y 1 � -- , ....ems (i (7, 1 0 • _ _ _....- r-" ,.s a- ! AN i , ' ............ "..'''''.........."."" L ''''... "" 1 .................r........................"..." ." _ i REVISED _ L 0 U PERATING B DGET „iii. la 1 ., _ _iv .....i 1 ._ 1 .3:..,4:;.7,... .._ . . .,__ _ --to — ,. 6 , ‘ -- ....... ,_ r.A.,. ._:, ,,,, 1 till 151. 1 . - 1 f1,-� �� �-ram_ -��r . ° Y-'-- -- — plow u b. { ` Greatrd 611;t&aa /Er Caste��aaor - =a- FISCAL YEAR 2022-23 4 �SED'8.14.23 �-- Ordinance No.3804 Attachment A Page 2 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 1-SUMMARY OF REVENUES AND EXPENDITURES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 REVENUES Taxes $37,985,868 $40,902,426 $43,274,120 $45,043,761 Fines&Forfeitures 2,005,047 1,974,887 1,915,328 1,131,457 Licenses&Permits 3,254,498 2,796,060 2,525,220 1,909,042 Charges for Service 2,672,725 3,132,961 2,581,175 2,539,104 Intergovernmental 5,245,249 5,292,770 5,322,110 5,322,110 Miscellaneous 1,825,709 1,996,004 2,227,569 4,130,893 TOTAL REVENUES $52,989,097 $56,095,109 $57,845,522 $60,076,367 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $39,000 $101,756 $633,808 SUB-TOTAL APPROPRIATIONS $0 $39,000 $101,756 $633,808 TOTAL RESOURCES $52,989,097 $56,134,109 $57,947,278 $60,710,175 EXPENDITURES City Council $63,364 $101,945 $133,265 $133,538 City Manager 759,480 822,375 859,158 888,088 Communications 392,745 446,324 545,816 500,118 City Secretary 453,789 468,601 528,571 628,996 Legal 424,274 641,344 676,316 713,128 Human Resources 139,555 131,522 167,895 204,907 Finance 775,602 796,999 884,503 885,752 Budget&Research 407,582 415,013 487,900 499,427 Municipal Court 1,337,167 1,432,484 1,568,159 1,630,929 Planning and Inspections 1,291,602 1,348,934 1,523,026 1,529,005 Economic Development 346,529 367,645 389,396 393,295 Library 2,189,693 2,294,275 2,509,867 2,539,553 Neighborhood Services 2,036,093 2,117,249 2,294,343 2,444,972 Public Works 2,963,870 3,097,171 3,667,215 3,724,529 Parks&Recreation 1,890,865 1,925,006 2,051,542 2,056,378 Police 16,322,074 17,007,871 17,919,951 18,061,729 Fire 14,144,935 14,842,737 15,952,471 16,467,674 Building Services 812,101 812,101 899,730 899,730 Non-Departmental 1,271,785 1,267,858 3,519,334 2,992,198 SUB-TOTAL DEPARTMENTS $48,023,104 $50,337,455 $56,578,458 $57,193,946 RESERVES&OTHER EXPENDITURES Planned Contribution to Fund Balance $0 $0 $127,972 $2,085,959 Capital Project Transfers 4,413,900 2,953,693 1,050,000 1,239,422 Operational Transfers 167,737 296,555 190,848 190,848 SUB-TOTAL RESERVES AND OTHER $4,581,637 $3,250,248 $1,368,820 $3,516,229 TOTAL EXPENDITURES $52,604,741 $53,587,703 $57,947,278 $60,710,175 BALANCE $384,356 $2,546,406 $0 $0 Ordinance No.3804 Attachment A Page 3 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 2-SUMMARY OF REVENUES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 TAXES Current Property Taxes $20,642,059 $22,051,012 $25,536,879 $25,536,879 Delinquent Property Taxes 94,926 (55,587) 80,000 80,000 Penalty and Interest 188,545 264,424 180,000 180,000 Franchise Fees 3,465,661 3,633,715 3,474,125 3,794,125 Utility Fund Franchise Taxes 1,063,691 1,233,378 1,133,535 1,133,535 Sales Taxes 11,991,880 13,219,393 12,350,359 13,800,000 Mixed Beverages 128,889 150,849 120,000 120,000 Payment in Lieu of Taxes 410,217 405,242 399,222 399,222 SUB-TOTAL $37,985,868 $40,902,426 $43,274,120 $45,043,761 FINES AND FORFEITURES Municipal Court Fines $1,842,169 $1,812,597 $1,773,212 $1,033,457 Warrant&Arrest Fees 162,878 162,290 142,116 98,000 Library Fines 0 0 0 0 SUB-TOTAL $2,005,047 $1,974,887 $1,915,328 $1,131,457 LICENSES AND PERMITS Building Permits $1,959,595 $1,451,291 $1,500,000 $800,000 Electrical Permits (300) 147,663 64,000 107,000 Plumbing Permits (29) 157,266 125,000 106,000 Mechanical Permits 1,587 161,754 115,000 119,000 Miscellaneous Permits 564,637 252,755 96,620 149,620 Certificate of Occupancy 2,031 12,882 12,000 12,000 Plan/Review/Application Fee 108,875 40,768 50,000 33,902 Apartment Inspection Fees 112,475 114,954 112,000 112,000 Curb&Drainage Inspection Fees 163,526 60,457 60,000 50,920 Re-Inspection Fees 0 16,019 900 23,900 License Fees 10,657 6,700 8,600 8,600 Contractor Registration Fees 0 0 0 0 Fire Inspection 425 27,475 16,500 21,500 Gas Well Inspection 56,000 56,000 56,000 56,000 Food Service Permits 148,351 174,919 183,000 183,000 Food Managers School 7,032 2,789 5,000 5,000 Animal License/Adoption Fees 27,629 31,914 35,000 35,000 Animal Control Impoundment 12,324 10,900 13,000 13,000 Auto Impoundment Fees 8,974 6,285 12,600 12,600 Burglar Alarm Permits 70,710 63,268 60,000 60,000 SUB-TOTAL $3,254,498 $2,796,060 $2,525,220 $1,909,042 CHARGES FOR SERVICE Park Facility Rental $4,104 $0 $500 $500 Ambulance Fees 1,752,511 2,016,259 1,752,500 1,752,625 Ambulance Supplemental Program 273,983 312,111 124,000 124,000 Garbage Billing 542,570 550,000 550,000 550,000 Recreation Fees 4,230 13,295 11,910 11,910 Athletic Revenue 10 0 0 0 Recreation Special Events 13,991 13,541 9,500 9,500 Planning&Zoning Fees 41,315 190,755 65,000 25,000 Sale of Accident Reports 3,583 4,071 8,900 8,900 Mowing 31,892 19,609 44,000 44,000 Fire Dept Certification/CPR Citizen Class 4,210 3,285 4,765 2,569 Miscellaneous 327 10,036 10,100 10,100 SUB-TOTAL $2,672,725 $3,132,961 $2,581,175 $2,539,104 Ordinance No.3804 Attachment A Page 4 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 2-SUMMARY OF REVENUES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 INTERGOVERNMENTAL Indirect Costs: Utility Fund $2,182,170 $2,323,713 $2,182,170 $2,182,170 Park&Rec Facilities Dev.Corp. 485,987 469,207 517,957 517,957 Crime Control District 16,780 33,890 48,750 48,750 Aquatic Park Fund 0 0 0 0 Consolidation Reimbursements 2,560,312 2,465,960 2,573,233 2,573,233 Transfers In Park Fund 0 0 0 0 SUB-TOTAL $5,245,249 $5,292,770 $5,322,110 $5,322,110 MISCELLANEOUS Interest Income $211,290 $302,934 $138,442 $848,300 Radio Reimbursement 263,497 246,270 268,427 278,424 Lease Income 99,541 313,312 200,000 200,000 Grant Proceeds 36,414 362,042 423,842 2,140,341 Park Fund Reimbursement 0 0 0 0 Fleet Service Fund Reimbursement 416,332 446,552 467,112 467,112 Teen Court Reimbursement 30,309 20,653 20,653 20,653 Other Income 723,058 246,145 109,581 116,063 Public Safety Reimbursements 45,267 58,097 60,000 60,000 Designated Funds for City Hall Project Debt 0 0 539,512 0 SUB-TOTAL $1,825,709 $1,996,004 $2,227,569 $4,130,893 APPROPRIATION-FUND BALANCE Appropriation of Fund Balance $0 $39,000 $101,756 $633,808 SUB-TOTAL $0 $39,000 $101,756 $633,808 TOTAL REVENUES $52,989,096 $56,134,109 $57,947,278 $60,710,175 Ordinance No.3804 Attachment A Page 5 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 EXPENDITURES City Council"4 $63,364 $101,945 $133,265 $133,538 City Manager $759,480 $822,375 $859,158 $888,088 Communications , Public Information $269,628 $282,811 $388,045 $331,256 Citicable 123,117 163,513 157,771 168,862 Total Communications $392,745 $446,324 $545,816 $500,118 City Secretary City Secretary(1) $343,372 $351,844 $394,384 $494,979 Record Management 110,417 116,757 134,187 134,017 Total City Secretary $453,789 $468,601 $528,571 $628,996 Legal $424,274 $641,344 $676,316 $713,128 Human Resources $139,555 $131,522 $167,895 $204,907 Finance Accounting&Administration $496,617 $505,431 $570,541 $570,681 Purchasing 278,985 291,568 313,962 315,071 Total Finance $775,602 $796,999 $884,503 $885,752 Budget&Research Budget $407,582 $415,013 $487,900 $499,427 Total Budget&Research $407,582 $415,013 $487,900 $499,427 Municipal Court Administration/Prosecution $840,934 $887,465 $984,602 $971,296 Warrant Division 389,887 431,849 457,108 469,911 Teen Court 106,346 113,170 126,449 118,630 Code Court 0 0 0 71,092 Total Municipal Court $1,337,167 $1,432,484 $1,568,159 $1,630,929 Planning and Development Inspections and Permitting $974,921 $1,021,369 $1,108,986 $1,110,946 Planning and Zoning 316,681 327,566 414,040 418,059 Total Planning and Development $1,291,602 $1,348,934 $1,523,026 $1,529,005 Economic Development $346,529 $367,645 $389,396 $393,295 Library General Services $401,885 $433,864 $462,867 $465,253 Public Services 942,890 984,245 1,076,526 1,085,768 Technical Services 844,918 876,167 970,474 988,532 Total Library $2,189,693 $2,294,275 $2,509,867 $2,539,553 Ordinance No.3804 Attachment A Page 6 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 Neighborhood Services Neighborhood Resources $366,961 $378,073 $399,716 $439,963 Animal Services 818,894 852,518 922,194 936,466 Consumer Health 352,855 372,714 404,292 408,347 Code Compliance 497,383 513,944 568,141 660,196 Total Neighborhood Services $2,036,093 $2,117,249 $2,294,343 $2,444,972 Public Works General Services $298,825 $306,150 $347,218 $349,179 Traffic Control 1,010,742 1,092,799 1,283,767 1,315,146 Street&Drainage 1,654,303 1,698,221 2,036,230 2,060,204 Total Public Works $2,963,870 $3,097,171 $3,667,215 $3,724,529 Parks&Recreation General Services $150,311 $123,261 $160,926 $161,490 Parks Maintenance 969,139 998,338 1,042,568 1,043,731 Recreation Services 487,102 487,102 487,102 487,102 Athletic Program Services 0 1 0 0 Senior Adult Services 258,607 290,515 318,143 321,252 Youth Outreach&Cultural 25,706 25,791 42,803 42,803 Total Parks&Recreation $1,890,865 $1,925,006 $2,051,542 $2,056,378 Police General Services $1,405,079 $1,503,668 $1,484,924 $1,516,032 Administrative Services 807,648 780,942 783,138 788,842 Criminal Investigations 2,979,598 3,132,653 3,202,745 3,205,596 Uniform Patrol 6,381,405 6,533,674 6,929,643 6,973,932 Detention Services 1,726,110 1,877,586 1,956,863 1,957,227 Property Evidence 656,573 637,103 660,299 683,399 Communications 2,365,662 2,542,245 2,902,339 2,936,701 Total Police $16,322,074 $17,007,871 $17,919,951 $18,061,729 Fire Department General Services $437,800 $424,361 $502,540 $517,152 Operations 10,628,103 11,164,128 11,754,370 11,906,106 Emergency Medical 1,839,690 1,904,432 2,173,534 2,400,494 Fire Inspections 552,828 559,520 653,928 658,717 Fire Inspections 686,514 790,296 868,099 985,205 Total Fire $14,144,935 $14,842,737 $15,952,471 $16,467,674 Building Services $812,101 $812,101 $899,730 $899,730 Non Departmental"' $1,271,785 $1,267,858 $3,519,334 $2,992,198 SUB-TOTAL DEPARTMENTS $48,023,104 $50,337,455 $56,578,458 $57,193,946 Ordinance No.3804 Attachment A Page 7 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 RESERVES&OTHER EXPENDITURES Operational Transfers Transfer to Information Technology Fund $167,737 $296,555 $190,848 $190,848 Transfer to Court Spec Rev Fund 0 0 0 0 Transfer to Fleet Fund 0 0 0 0 Transfer to NRH2O 0 0 0 0 Transfer to Debt Service Fund 0 0 0 0 Operational Transfers Total $167,737 $296,555 $190,848 $190,848 Capital Proiect Transfers General Capital Project Transfers $517,511 $103,693 $50,000 $239,422 Property Purchase 2,846,389 0 0 0 Street&Sidewalk Capital Project Transfers 1,050,000 2,850,000 1,000,000 1,000,000 Capital Project Transfers Total $4,413,900 $2,953,693 $1,050,000 $1,239,422 Planned Contribution to Fund Balance General Fund Reserves $0 $0 $62,972 $2,020,959 Transportation Fund Reserves 0 0 0 0 Public Educational Governmental(PEG)Reserve 0 0 65,000 65,000 Contribution to Fund Balance Total $0 $0 $127,972 $2,085,959 TOTAL RESERVES&OTHER EXPENDITURES $4,581,637 $3,250,248 $1,368,820 $3,516,229 TOTAL EXPENDITURES $52,604,741 $53,587,702 $57,947,278 $60,710,175 BALANCE $384,354 $2,546,407 $0 $0 Ordinance No.3804 Attachment A Page 8 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 4-SUMMARY OF PROPERTY TAX REVENUE AND DISTRIBUTION NET TAXABLE VALUE: M&O I&S TOTAL Total Appraised Value as of July 21,2022 9,469,708,861 Less: Absolute Exemption (482,040,340) Cases Before ARB (290,234,095) Incomplete Accounts (131,462,935) Disabled Veteran (57,847,171) Over 65 (213,004,624) Homestead (926,480,479) Disabled Persons (10,535,598) Freeport Inventory Value Loss (12,646,335) Pollution Control (27,671) Solar&Wind Powered Devices (692,196) Nominal Value Accounts (1,856,048) Miscellaneous Personal Property (20,578,537) Property Damaged by Disaster 0 In Process (70) Total Reduction to Values (2,147,406,099) NET TAXABLE VALUE AT JULY 21,2022 7,322,302,762 Add: Estimated Minimum ARB protested values 180,258,992 Incomplete Property 73,648,638 In Process 0 ESTIMATED NET TAXABLE VALUE AT JULY 21,2022 7,576,210,392 ESTIMATED PROPERTY TAX COLLECTIONS: Estimated Net Taxable Value 7,576,210,392 Less:TIF#2 Incremental Value 0 Less:TIF#3 Incremental Value (13,616,004) Less:Tax Ceiling Taxable Values (1,210,778,971) Net Taxable Values 6,351,815,417 Adopted Tax Rate per$100 Valuation 0.347744 0.200228 0.547972 Estimated Total Tax Levy at 100%Collection 22,088,057 12,718,118 34,806,175 Less:Estimated Uncollectable(1.5%) (331,321) (331,321) Less:Estimated I&S Uncollectable(1.5%) (190,772) (190,772) Estimated Revenue from Property Tax 21,565,964 12,718,118 34,284,082 Estimated Revenue from Property Tax . 21,565,964 12,718,118 34,284,082 Plus:Tax Ceiling Account Revenue 4,043,409 789,512 4,832,921 Less:Estimated Uncollectable(1.5%) (72,494) (72,494) ESTIMATED PROPERTY TAX DISTRIBUTION 25,536,879 13,507,630 39,044,509 Ordinance No.3804 Attachment A Page 9 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 5-SUMMARY OF REVENUES AND EXPENDITURES GENERAL DEBT SERVICE FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY2020/21 FY2021/22 FY2022/23 FY2022/23 REVENUES PROPERTY TAXES General Debt Service Taxes $11,202,557 $11,541,403 $12,718,118 $12,718,118 PROPERTY TAXES $11,202,557 $11,541,403 $12,718,118 $12,718,118 TRANSFER-IN Drainage Utility $220,675 $219,200 $203,975 $203,975 Park&Rec.Facilities Dev.Corp 463,005 452,505 442,005 442,005 Fleet Services Fund 252,300 243,300 234,300 234,300 TOTAL TRANSFER-IN $935,980 $915,005 $880,280 $880,280 OTHER REVENUES Interest Income $15,810 $19,618 $9,500 $60,000 City of Watauga,CIP Participation 82,583 63,068 60,352 63,068 Excess Collection 0 0 789,512 789,512 TOTAL OTHER REVENUES $98,393 $82,686 $859,364 $912,580 TOTAL REVENUES $12,236,930 $12,539,094 $14,457,762 $14,510,978 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,236,930 $12,539,094 $14,457,762 $14,510,978 EXPENDITURES DEBT EXPENDITURES Existing Bonds&C.O.'s $12,102,627 $12,521,720 $14,448,262 $14,448,262 Issuance Costs/Paying Agent Fees (4,740) 980 9,500 21,185 Bond Defeasance/Refunding 5,100 0- 0 0 TOTAL EXPENDITURES $12,102,987 _ $12,522,700 $14,457,762 $14,469,447 BALANCE $133,943 $16,395 $0 $41,531 Ordinance No.3804 Attachment A Page 10 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 6-SUMMARY OF TAX INCREMENT FINANCE(TIF)DISTICT PROPERTY TAX REVENUE AND DISTRIBUTION TAX INCREMENT FINANCING DISTRICT#3 VALUE Taxable Value(2022 Tax Year) $19,964,300 Less: Base Taxable Value(2019 Tax Year) 6,348,296 Taxable Value Increment(2021 Tax Year) Gain/(Loss): $13,616,004 TAX INCREMENT FINANCING DISTRICT#3 CONTRIBUTION Taxable Value Increment:TIF District#3 $13,616,004 Tax Rate per$100 Valuation and Inception $0.154625 TIF District#3 Property Tax Revenue at 100% $21,054 Collection Rate 98.50% TIF District#3 Property Tax Revenue $20,738 Notes: (1)The information presented on this schedule represents the contribution of the City of North Richland Hills to the Tax Increment Financing Districts in which it participates. This schedule does not reflect the contribution of other entities. (2)TIE#1 Closed in 2018.TIF#1A Closed in 2019. (3)TIF#2 Closed in 2022. Ordinance No.3804 Attachment A Page 11 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 7-SUMMARY OF REVENUES AND EXPENDITURES TAX INCREMENT FINANCING FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY2020/21 FY2021/22 FY 2022/23 FY 2022/23 REVENUES PROPERTY TAXES City of North Richland Hills $9,507 $10,442 $21,376 $21,307 Tarrant County 3,597 3,808 7,795 7,521 TOTAL PROPERTY TAXES $13,104 $14,251 $29,171 $28,828 OTHER FUNDING SOURCES Investment Income $0 $13,104 $0 $0 TOTAL OTHER FUNDING SOURCES $0 $13,104 $0 $0 TOTAL REVENUES $13,104 $27,355 $29,171 $28,828 EXPENDITURES Public Improvement District Contribution $0 $13,104 $29,171 $16,340 Contribution to Fund Balance 0 0 0 12,488 TOTAL EXPENDITURES $0 $13,104 $29,171 $28,828 BALANCE $13,104 $14,251 $0 $0 Ordinance No.3804 Attachment A Page 12 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 REVENUES OPERATING Sales Tax $5,995,942 $6,609,698 $6,175,215 $6,900,000 Tennis Center Revenue 503,555 493,640 471,250 471,250 Athletic Program Revenue 209,796 146,750 213,000 164,000 Youth Association Fees 16,144 21,357 16,300 16,300 Park Impact Fees 107,425 69,574 95,000 65,000 Other Income 47,109 21,194 34,821 122,851 TOTAL OPERATING $6,879,971 $7,362,213 $7,005,586 $7,739,401 NRH CENTRE Memberships/Drop-In Passes $1,067,647 $1,418,802 $1,300,000 $1,550,000 Fitness 214,254 409,435 440,000 434,500 Recreation/Sports 329,907 387,504 353,000 432,000 Grand Hall Rental 286,668 481,686 399,700 491,000 Catering&Event Fees 9,457 22,297 18,000 26,000 Aquatic Programs 134,268 229,641 240,000 240,000 Pool Rental 11,641 2,565 5,000 5,000 Gym Rental 2,190 200 2,000 0 Concessions/Merchandise 15,838 37,157 27,000 58,000 Special Events 0 9,180 8,500 10,540 Other 2,493 34,169 22,911 62,930 General Fund 487,102 487,102 487,102 487,102 TOTAL NRH CENTRE $2,561,466 $3,519,738 $3,303,213 $3,797,072 TOTAL REVENUES $9,441,437 $10,881,951 $10,308,799 $11,536,473 APPROPRIATION OF FUND BALANCE Appropriation of Park Impact Fee Reserves $0 $0 $0 $0 Appropriation of NRH Centre Reserves 175,084 0 433,748 529,159 Appropriation of Sales Tax Reserves 0 0 0 15,055 TOTAL APPROPRIATION OF FUND BALANCE $175,084 $0 $433,748 $544,214 TOTAL RESOURCES $9,616,521 $10,881,951 $10,742,547 $12,080,687 Ordinance No.3804 Attachment A Page 13 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 EXPENDITURES OPERATING Park Facilities Development Admin. $770,504 $728,514 $745,006 $746,730 Parks&Public Grounds 2,048,970 2,027,206 2,258,327 2,273,530 Athletic Program Services 208,365 167,687 237,680 237,680 Tennis Center Operations 597,341 635,605 604,587 619,654 Non-Departmental 44,702 52,385 72,866 70,222 TOTAL OPERATING $3,669,882 $3,611,397 $3,918,466 $3,947,816 NRH CENTRE Center Management $795,370 $926,763 $992,361 $1,043,298 Fitness 311,102 399,026 376,654 374,644 Building Operations 244,883 231,098 253,687 328,697 Aquatic 676,536 775,242 685,708 852,079 Recreation Sports 199,932 294,591 325,297 389,066 Grand Hall 232,314 299,902 330,131 355,564 Building Services 276,414 275,090 315,123 315,123 TOTAL NRH CENTRE $2,736,550 $3,201,712 $3,278,961 $3,658,471 OTHER&RESERVES Debt Service $463,005 $470,035 $442,005 $442,005 Indirect Costs 469,207 503,097 517,957 517,957 Transfers Parks Capital Projects 431,422 644,000 1,098,000 1,168,000 General Fund 16,780 0 0 0 Impact Fee Capital Projects 265,000 297,075 0 0 Economic Development Transfer 149,899 165,242 154,380 172,500 Planned Contribution to Fund Balance Parks Fund Reserves 0 0 1,237,778 1,969,178 NRH Centre Fund Reserves 0 318,026 0 139,760 Impact Fee Reserves 107,425 69,574 95,000 65,000 TOTAL OTHER&RESERVES $1,902,738 $2,467,049 $3,545,120 $4,474,400 TOTAL EXPENDITURES $8,309,170 $9,280,158 $10,742,547 $12,080,687 BALANCE $1,307,351 $1,601,793 $0 $0 Ordinance No.3804 Attachment A Page 14 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 9-SUMMARY OF REVENUES AND EXPENDITURES CRIME CONTROL DISTRICT ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23_ _ REVENUES Sales Tax $5,972,496 $6,570,113 $6,155,242 $6,874,027 Franchise Tax 92,286 122,254 98,050 156,570 Interest Income 1,541 20,718 2,415 2,415 SRO Reimbursement(BISD) 9 327,419 328,823 328,823 Other 38,582 213,231 131,087 131,087 TOTAL REVENUES $6,346,408 $7,253,736 $6,715,617 $7,492,922 APPROPRIATION OF FUND BALANCE Contribution from the General Fund $0 $0 $0 $0 Appropriation of Fund Balance 0 0 0 287,077 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $287,077 TOTAL RESOURCES $6,346,408 $7,253,736 $6,715,617 $7,779,999 EXPENDITURES OPERATING EXPENDITURES Administration $17,474 $15,013 $17,147 $18,370 Community Resources 1,049,119 1,064,393 1,251,058 1,468,464 Victim Assistance Program 64,092 82,280 28,519 28,789 Investigations 447,264 468,927 612,668 685,215 Uniform Patrol 3,053,990 3,294,107 3,689,831 3,708,188 Technical Services 554,933 543,446 572,950 572,807 Property Evidence 106,904 118,970 159,558 202,524 Partner Agency Funding 44,426 37,001 50,742 50,070 Non-Departmental 115,943 127,153 164,988 285,246 TOTAL OPERATING EXPENDITURES $5,454,144 $5,751,289 $6,547,461 $7,019,673 OTHER&RESERVES Operating Transfers $16,780 $33,890 $48,750 $98,750 Capital Project Transfers 0 672,925 0 0 Planned Contribution to Fund Balance 0 0 119,406 661,576 TOTAL OTHER&RESERVES $16,780 $706,815 $168,156 $760,326 TOTAL EXPENDITURES $5,470,924 $6,458,105 $6,715,617 $7,779,999 BALANCE $875,484 $795,631 $0 $0 Ordinance No.3804 Attachment A Page 15 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 12-SUMMARY OF REVENUES AND EXPENDITURES PROMOTIONAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 REVENUES Occupancy Tax Proceeds $313,649 $328,965 $300,000 $300,000 Interest Income 5,887 7,522 4,278 19,377 Other 0 1,221 0 0 TOTAL OPERATING REVENUES $319,536 $337,707 $304,278 $319,377 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $0 $6,000 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $6,000 TOTAL RESOURCES $319,536 $337,707 $304,278 $325,377 EXPENDITURES OPERATING EXPENDITURES Economic Development $101,446 $124,781 $140,020 $146,109 Cultural&Leisure 100,043 142,476 148,729 148,872.. Non-Departmental 133 316 562 330 TOTAL OPERATING EXPENDITURES $201,621 $267,573 $289,311 $295,311 OTHER&RESERVES Planned Contributions to Fund Balance $0 $0 $14,967 $30,066 TOTAL OTHER&RESERVES $0 $0 $14,967 $30,066 TOTAL EXPENDITURES $201,621 $267,574 $304,278 $325,377 BALANCE $117,915 $70,134 $0 $0 Ordinance No.3804 Attachment A Page 16 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 13-SUMMARY OF REVENUES AND EXPENDITURES DONATIONS FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 REVENUES Parks&Recreation Program Donations $39,193 $56,704 $45,300 $60,300 Library Program Donations 32,851 43,836 37,391 37,391 Neighborhood Services Program Donations 126,844 75,816 75,100 75,100 Public Safety Program Donations 17,030 3,650 24,250 25,700 Teen Court Program Donations 2,123 2,063 4,006 4,006 Investment Income 5,684 6,145 3,699 3,699 TOTAL REVENUES $223,725 $188,213 $189,746 $206,196 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $1,223 $52,900 $52,983 TOTAL APPROPRIATION OF FUND BALANCE $0 $1,223 $52,900 $52,983 TOTAL RESOURCES $223,725 $189,436 $242,646 $259,179 EXPENDITURES OPERATING EXPENDITURES Parks&Recreation Programs $20,422 $37,591 $67,000 $79,000 Library Programs 32,868 34,521 52,391 52,475 Neighborhood Services Programs 22,462 85,407 86,300 86,300 Public Safety Programs 1,720 26,917 18,720 15,320 Teen Court Program 2,350 0 4,000 4,000 TOTAL OPERATING EXPENDITURES $79,822 $184,436 $228,411 $237,095 OTHER&RESERVES Capital Project Transfers $30,632 $5,000 $0 $0 Planned Contribution to Fund Balance 0 0 0 0 TOTAL OTHER&RESERVES $30,632 $5,000 $0 $0 TOTAL EXPENDITURES $110,454 $189,436 $228,411 $237,095 BALANCE $113,271 $0 $14,235 $22,084 11 Ordinance No.3804 Attachment A Page 17 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 14-SUMMARY OF REVENUES AND EXPENDITURES SPECIAL INVESTIGATIONS FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 REVENUES Federal Forfeited Funds $78,598 $98,750 $50,000 $50,000 State Forfeited Funds 45,428 10,240 35,000 35,000 Local Forfeited Funds 2,568 688 1,000 1,000 AFIS Program Revenues 8,850 0 14,900 14,900 Other Income 3,404 0 2,800 2,800 TOTAL REVENUES $138,846 $109,679 $103,700 $103,700 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $186,800 $174,550 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $186,800 $174,550 TOTAL RESOURCES $138,846 $109,679 $290,500 $278,250 EXPENDITURES OPERATING EXPENDITURES Federal Forfeited Funds $55,959 $41,103 $175,000 $177,750 State Forfeited Funds 44,320 35,323 85,000 85,000 Local Forfeited Fund 0 0 1,000 1,000 AFIS Maintenance&Equipment 14,996 14,089 14,500 14,500 Leose Contributions 0 0 15,000 0 TOTAL OPERATING EXPENDITURES $115,274 $90,514 $290,500 $278,250 OTHER&RESERVES Planned Contribution to Fund Balance $0 $0 $0 $0 TOTAL OTHER&RESERVES $0 $0 $0 $0 TOTAL EXPENDITURES $115,274 $90,514 $290,500 $278,250 BALANCE $23,572 $19,164 $0 $0 Ordinance No.3804 Attachment A Page 18 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 15-SUMMARY OF REVENUES AND EXPENDITURES DRAINAGE UTILITY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 REVENUES Drainage Fees $1,724,725 $1,720,723 $1,725,000 $1,725,000 Interest Income 14,648 30,787 16,252 42,519 Other 0 820 0 0 TOTAL REVENUES $1,739,373 $1,752,330 $1,741,252 $1,767,519 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $980,828 $980,828 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $980,828 $980,828 TOTAL RESOURCES $1,739,373 $1,752,330 $2,722,080 $2,748,347 EXPENDITURES OPERATING EXPENDITURES Public Works Administration $0 $399 $120,606 $122,859 Drainage Utility Crew 57,900 92,593 155,399 157,088 Non-Departmental (386) 1,188 5,100 5,100 Debt Service Payments 220,675 219,200 203,975 203,975 TOTAL OPERATING EXPENDITURES $278,189 $313,379 $485,080 $489,022 OTHER&RESERVES Capital Project Transfers $450,000 $310,000 $2,237,000 $2,237,000 Planned Contribution to Fund Balance 0 0 0 22,325 TOTAL OTHER&RESERVES $0 $0 $0 $2,259,325 TOTAL EXPENDITURES $728,189 $623,379 $2,722,080 $2,748,347 BALANCE $1,011,184 $1,128,951 $0 $0 BELOW THE LINE EXPENDITURE CHANGES 60-PUBLIC WORKS 1-Storm Water Management Program Design Consultant Fee $0 FY24 Merit/Market Salary Adjustments TOTAL EXPENDITURE CHANGES $0 BALANCE $0 Ordinance No.3804 Attachment A Page 19 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 16 -SUMMARY OF REVENUES AND EXPENDITURES ECONOMIC DEVELOPMENT FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 REVENUES Park Fund Transfer In $149,899 $165,242 $154,380 $172,500 Other (876) (9,142) 0 19,000 TOTAL OPERATING REVENUES $149,023 $156,101 $154,380 $191,500 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $0 $0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $0 TOTAL RESOURCES $149,023 $156,101 $154,380 $191,500 EXPENDITURES OPERATING EXPENDITURES Other Expenses $0 $0 $0 $0 Transfer to IT Capital 0 0 0 0 TOTAL OPERATING EXPENDITURES $0 ($1) $0 $0 OTHER&RESERVES Planned Contributions to Fund Balance $149,023 $156,101 $0 $191,500 TOTAL OTHER&RESERVES $149,023 $156,101 $0 $191,500 TOTAL EXPENDITURES $149,023 $156,101 $0 $191,500 BALANCE ($0) ($0) $154,380 $0 Ordinance No.3804 Attachment A Page 20 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 17-SUMMARY OF REVENUES AND EXPENDITURES GAS DEVELOPMENT FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 REVENUES Gas Royalty Revenue $659,356 $1,134,010 $705,973 $705,973 Interest Income 3,589 14,351 5,871 40,710 Other Income 0 0 0 351,460 TOTAL REVENUES $662,945 $1,148,361 $711,844 $1,098,143 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $0 $0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $0 TOTAL RESOURCES $662,945 $1,148,361 $711,844 $1,098,143 EXPENDITURES OPERATING Transfer to Capital Projects $0 $0 $250,000 $250,000 Interfund Loan 0 0 0 0 Miscellaneous Expenditures 0 40,671 0 0 TOTAL OPERATING EXPENDITURES $0 $40,671 $250,000 $250,000 OTHER&RESERVES Planned Contribution to Fund Balance $0 $0 $461,844 $848,143 TOTAL OTHER&RESERVES $0 $0 $461,844 $848,143 TOTAL EXPENDITURES $0 $40,671 $711,844 $1,098,143 BALANCE $662,945 $1,107,690 $0 $0 Ordinance No.3804 Attachment A Page 21 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 18-SUMMARY OF REVENUES AND EXPENDITURES TRAFFIC SAFETY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 REVENUES Gross Fine Revenues $0 $0 $0 $0 Interest Income 5,998 6,183 3,659 14,740 TOTAL REVENUES $5,998 $6,183 $3,659 $14,740 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $54,274 $27,540 $109,062 $103,428 TOTAL APPROPRIATION OF FUND BALANCE $54,274 $27,540 $109,062 $103,428 TOTAL RESOURCES $60,272 $33,723 $112,721 $118,168 EXPENDITURES OPERATING EXPENDITURES Contractor Payments $0 $0 $0 $0 Program Administration 0 0 0 0 Payment to State 17,282 0 0 0 Traffic Enforcement/Traffic Safety 18,474 0 0 0 Pedestrian Safety 24,516 33,723 112,721 118,168 TOTAL OPERATING EXPENDITURES $60,272 $33,723 $112,721 $118,168 OTHER&RESERVES Contribution to Reserves $0 $0 $0 $0 TOTAL OTHER&RESERVES $0 $0 $0 $0 TOTAL EXPENDITURES $60,272 $33,723 $112,721 $118,168 BALANCE $0 $0 $0 $0 Ordinance No.3804 Attachment A Page 22 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 19-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 REVENUES WATER CHARGES Water Charges $23,629,044 $27,688,553 $25,686,926 $25,686,926 Water Prior Year Settle-up 697,768 728,118 0 1,542,943 Water Taps 60,265 52,345 52,000 52,000 Water Inspection Fees 46,378 22,707 54,500 32,470 TOTAL WATER CHARGES $24,433,455 $28,491,723 $25,793,426 $27,314,339 SEWER TREATMENT CHARGES Sewer Treatment Charges $12,162,925 $12,958,268 $13,329,191 $13,329,191 Sewer Prior Year Settle-Up 238,938 275,831 0 294,887 Sewer Taps 17,750 13,400 14,900 14,900 Sewer Inspection Fees 32,581 10,591 28,000 9,710 TOTAL SEWER TREATMENT CHARGES $12,452,194 $13,258,090 $13,372,091 $13,648,688 MISCELLANEOUS Interest Income $96,480 $141,334 $69,068 $328,932 Service Charges 127,163 124,772 126,000 126,000 Late Charges 482,758 512,354 420,000 420,000 Miscellaneous 3,317,827 717,790 47,100 62,709 Joint Use Reimbursement-Watauga 0 58,453 123,600 123,600 Subdivision Meter Revenue 66,878 58,476 59,145 59,145 TOTAL MISCELLANEOUS $4,091,106 $1,613,179 $844,913 $1,120,386 TOTAL REVENUE $40,976,755 $43,362,991 $40,010,430 $42,083,413 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $1,418,872 $3,847,895 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $1,418,872 $3,847,895 TOTAL RESOURCES $40,976,755 $43,362,992 $41,429,302 $45,931,308 Ordinance No.3804 Attachment A Page 23 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 19-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 EXPENDITURES WATER SERVICES Water Operations $4,464,930 $4,312,789 $4,888,841 $5,021,842 Purchase of Water FTW 4,076,463 4,106,834 4,354,672 4,354,672 Purchase of Water TRA 6,739,361 7,677,095 7,946,485 7,946,485 TOTAL WATER SERVICES $15,280,754 $16,096,718 $17,189,998 $17,322,999 SEWER TREATMENT SERVICES Sewer Operations $1,408,171 $1,443,863 $1,502,192 $1,513,621 Sewer Treatment FTW 1,109,843 913,219 1,680,773 2,375,277 Sewer Treatment TRA 4,848,797 5,154,153 5,433,867 5,496,219 TOTAL SEWER TREATMENT SERVICES $7,366,811 $7,511,235 $8,616,832 $9,385,117 UTILITY BILLING&FINANCIAL SERVICES Utility Meter Reading $539,736 $560,341 $606,825 $619,070 Utility Billing&Customer Service 1,021,948 1,116,392 1,095,784 1,100,978 Utility Collection Services 239,398 261,188 269,425 270,783 Accounting Services 406,705 456,860 441,974 442,689 Budget&Research 222,253 228,515 261,966 270,872 TOTAL UTILITY BILLING&FINANCIAL $2,430,039 $2,623,296 $2,675,974 $2,704,392 OTHER OPERATING EXPENDITURES Administration $353,809 $396,375 $397,701 $416,305 Development 872,882 993,224 1,116,290 1,125,758 Right of Way Maintenance 271,565 293,010 338,647 338,647 Utility Construction Crew&Support (0) 1,133,617 1,363,372 1,355,745 Building Services 1,822,929 1,822,929 1,852,138 1,852,138 Non Departmental 200,852 891,627 373,074 2,829,597 TOTAL OTHER OPERATING $3,522,037 $5,530,782 $5,441,222 $7,918,190 TOTAL DEPARTMENT EXPENDITURES $28,599,641 $31,762,032 $33,924,026 $37,330,698 OTHER&RESERVES Debt Service $1,646,296 $1,511,963 $2,155,349 $2,155,349 Bond Defeasance/Refunding 0 0 0 0 Franchise Fees 1,063,691 1,233,378 1,133,535 1,133,535 Indirect Costs 2,182,170 2,182,170 2,182,170 2,182,170 Payment in Lieu of Taxes 410,217 405,242 399,222 399,222 Transfer for IT Purchases&Support 175,000 175,000 175,000 175,000 Transfer to Capital 2,278,011 778,620 1,460,000 1,460,000 Planned Contribution to Fund Balance 0 0 0 1,095,334 TOTAL OTHER&RESERVES $7,755,384 $6,286,373 $7,505,276 $8,600,610 TOTAL EXPENDITURES $36,355,026 $38,048,405 $41,429,302 $45,931,308 BALANCE $4,621,729 $5,314,586 $0 $0 Ordinance No.3804 Attachment A Page 24 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 20-SUMMARY OF REVENUES AND EXPENDITURES AQUATIC PARK FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 ATTENDANCE 181,808 194,393 190,000 170,000 REVENUES OPERATING . Admissions $3,261,828 $3,813,034 $3,316,162 $3,451,900 Advanced&Group Sales 0 0 0 0 Food and Beverage 995,186 1,084,215 935,060 945,566 Merchandise 195,790 235,604 169,187 194,473 Rentals 145,621 175,268 171,100 188,892 TOTAL OPERATING $4,598,425 $5,308,121 $4,591,509 $4,780,831 OTHER REVENUES Interest Income $10,955 $13,762 $8,775 $31,039 Other Income 43,120 51,258 60,000 50,000 TOTAL OTHER REVENUES $54,075 $65,020 $68,775 $81,039 TOTAL REVENUES $4,652,500 $5,373,141 $4,660,284 $4,861,870 APPROPRIATION OF FUND BALANCE Interfund Loan $69,356 $0 $0 $0 Appropriation of Fund Balance 0 0 0 116,583 TOTAL APPROPRIATION OF FUND BALANCE $69,356 $0 $0 $116,583 TOTAL RESOURCES $4,721,856 $5,373,142 $4,660,284 $4,978,453 EXPENDITURES OPERATING General Services&Utilities $773,388 $800,920 $909,437 $870,273 Public Grounds/Aquatics/Maint. 1,023,805 1,251,892 1,331,431 1,716,215 Business&Office Administration 315,701 343,866 427,690 334,489 Gift Shop/Concessions 640,976 750,472 764,448 930,130 Sales/Special Events/Admissions 253,064 303,859 323,726 344,710 Non-Departmental 60,510 64,369 84,538 82,580 TOTAL OPERATING $3,067,443 $3,515,378 $3,841,270 $4,278,397 OTHER&RESERVES Debt Service $735,129 $711,541 $699,006 $699,006 Debt Defeasance/Refunding/Agent Fees 969 969 1,050 1,050 Transfer to Capital Projects 100,000 100,000 0 0 Transfer Out General Fund 0 0 0 0 Planned Contribution to Fund Balance 0 0 118,958 0 TOTAL OTHER&RESERVES $836,098 $812,510 $819,014 $700,056 TOTAL EXPENDITURES $3,903,541 $4,327,888 $4,660,284 $4,978,453 BALANCE $818,315 $1,045,253 $0 $0 Ordinance No.3804 Attachment A Page 25 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 21-SUMMARY OF REVENUES AND EXPENDITURES GOLF COURSE FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 ROUNDS 18,961 18,961 46,276 47,000 REVENUES OPERATING REVENUE Green Fees $1,542,553 $1,607,624 $1,828,800 $1,828,800 Pro Shop 448,768 357,489 319,473 319,473 Driving Range 88,956 141,985 155,000 155,000 Carts 346,721 352,918 453,505 453,505 Food&Beverage 520,594 652,185 569,282 569,282 General&Administrative 0 0 0 0 Miscellaneous 40,363 12,865 19,000 19,000 TOTAL OPERATING REVENUE $2,987,956 $3,125,066 $3,345,060 $3,345,060 RESERVES&INTERFUND LOANS Interfund Loan $0 $0 $0 $0 Appropriation of Fund Balance 0 0 0 4,192 TOTAL USE OF RESERVES&INTERFUND LOANS $0 $0 $0 $4,192 TOTAL RESOURCES $2,987,956 $3,125,066 $3,345,060 $3,349,252 EXPENDITURES OPERATING Pro Shop $133,130 $168,004 $235,892 $235,892 Pro Shop:Cost of Goods Sold 152,758 174,197 203,628 203,628 Driving Range 25,476 9,316 28,300 28,300 Golf Carts 254,462 299,341 299,413 299,413 Course Maintenance 680,166 742,411 1,003,469 1,003,469 Food&Beverage 244,805 259,470 266,658 266,658 Food&Beverage:Cost of Goods Sold 150,476 215,771 188,759 188,759 Sales&Membership 48,747 68,037 95,412 95,412 General&Administrative 378,305 609,047 550,239 554,432 Clubhouse 123,149 886 0 0 Management Fees 164,363 191,940 133,042 133,042 Equipment Repair and Replacement 59,611 51,502 0 0 TOTAL OPERATING $2,415,449 $2,789,921 $3,004,812 $3,009,005 OTHER&RESERVES Debt Service $328,439 $321,153 $310,590 $310,590 Transfer to Capital Projects 0 0 0 0 Planned Contribution to Reserves 0 0 29,658 29,658 TOTAL OTHER&RESERVES $328,439 $321,153 $340,248 $340,248 TOTAL EXPENDITURES $2,743,888 $3,111,074 $3,345,060 $3,349,253 BALANCE $244,068 $13,992 $0 $0 Ordinance No.3804 Attachment A Page 26 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 22-SUMMARY OF REVENUES AND EXPENDITURES FACILITIES/CONSTRUCTION MANAGEMENT FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 REVENUES CHARGES FOR SERVICE Transfer From: General Fund $812,101 $812,101 $899,730 $899,730 Park Development Fund 276,414 275,090 315,123 315,123 Utility Fund 1,822,929 1,822,929 1,852,138 1,852,138 SUB-TOTAL $2,911,444 $2,910,120 $3,066,991 $3,066,991 OTHER REVENUES Interest Income $25,711 $26,860 $17,953 $49,252 Rent From Rental Properties 39,810 22,860 1,200 1,200 Other Income 158,570 4,574 2,453 2,453 SUB-TOTAL $224,092 $54,294 $21,606 $52,905 TOTAL REVENUES $3,135,536 $2,964,414 $3,088,597 $3,119,896 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $162 $236,002 $496,072 TOTAL APPROPRIATION OF FUND BALANCE $0 $162 $236,002 $496,072 TOTAL RESOURCES $3,135,536 $2,964,576 $3,324,599 $3,615,968 EXPENDITURES OPERATING EXPENDITURES Administration $249,310 $256,798 $265,539 $265,894 Building Services 2,352,799 2,642,028 2,871,815 3,183,566 Rental Property Program 14,848 34,003 36,120 15,668 Non-Departmental 15,094 31,746 92,125 91,840 TOTAL OPERATING EXPENDITURES $2,632,051 $2,964,576 $3,265,599 $3,556,968 OTHER&RESERVES Capital Project Transfers $274,400 $0 $59,000 $59,000 Planned Contribution to Fund Balance 0 0 0 0 TOTAL OTHER&RESERVES $274,400 $0 $59,000 $59,000 TOTAL EXPENDITURES $2,906,451 $2,964,576 $3,324,599 $3,615,968 BALANCE $229,084 $0 $0 $0 Ordinance No.3804 Attachment A Page 27 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 23-SUMMARY OF REVENUES AND EXPENDITURES FLEET SERVICES FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 REVENUES CHARGES FOR SERVICE General Fund $1,389,677 $1,389,677 $1,569,269 $1,569,269 Utility Fund 2,256,325 2,256,325 2,514,175 2,514,175 Crime Control District Fund 170,426 170,426 189,903 189,903 Park&Recreation Dev.Fund 171,939 171,939 191,591 191,591 Other Funds 24,119 24,119 88,874 88,874 TOTAL CHARGES FOR SERVICE $4,012,486 $4,012,486 $4,553,812 $4,553,812 OTHER REVENUES Interest Income $26,272 $34,817 $20,605 $90,291 Sale of City Property 137,967 68,439 51,463 51,463 Other Income 11 7,241 0 0 Transfer from General Fund 169,465 0 0 0 TOTAL OTHER REVENUES $333,714 $110,497 $72,068 $141,754 TOTAL REVENUES $4,346,200 $4,122,983 $4,625,880 $4,695,566 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $128,020 $1,649,485 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $128,020 $1,649,485 TOTAL RESOURCES $4,346,200 $4,122,983 $4,753,900 $6,345,051 EXPENDITURES OPERATING EXPENDITURES Administration $293,230 $300,538 $312,128 $313,128 Fleet Services Operations 1,493,180 1,837,440 2,175,889 2,139,285 Fire Fleet Maintenance Operations 335,687 360,864 435,228 537,885 Vehicle and Equipment Purchases 496,898 416,383 1,100,282 2,561,581 Non-Departmental 19,459 21,047 28,961 28,249 TOTAL OPERATING EXPENDITURES $2,638,453 $2,936,272 $4,052,488 $5,580,128 OTHER&RESERVES Debt Service $252,300 $243,300 $234,300 $234,300 Transfer to General Fund 416,332 446,552 467,112 467,112 Capital Project Transfers 169,465 135,000 0 0 Planned Contribution to Fund Balance 0 0 0 63,511 TOTAL OTHER&RESERVES $838,097 $824,852 $701,412 $764,923 TOTAL EXPENDITURES $3,476,550 $3,761,124 $4,753,900 $6,345,051 BALANCE $869,650 $361,859 $0 $0 Ordinance No.3804 Attachment A Page 28 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 24-SUMMARY OF REVENUES AND EXPENDITURES INFORMATION TECHNOLOGY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY2020/21 FY2021/22 FY2022/23 FY2022/23 REVENUES CHARGES FOR SERVICE General Fund $1,458,565 $1,623,149 $1,961,101 $1,977,457 Park Fund 172,776 228,161 267,896 267,896 Crime Control District 252,093 320,693 398,540 438,540 Utility Fund 1,065,770 1,218,245 1,419,161 1,419,161 Other Funds 365,884 394,784 467,669 467,669 TOTAL CHARGES FOR SERVICE $3,315,088 $3,785,032 $4,514,367 $4,570,723 OTHER REVENUES Transmitter Lease $188,149 $205,877 $180,000 $180,000 Reimbursement from General Fund 167,737 296,555 190,848 190,848 Interest Income 13,831 15,929 8,925 31,288 Other Income 4,113 28,484 4,630 4,630 TOTAL OTHER REVENUES $373,830 $546,845 $384,403 $406,766 TOTAL REVENUES $3,688,918 $4,331,877 $4,898,770 $4,977,489 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $74,738 $14,489 $105,895 $472,939 TOTAL APPROPRIATION OF FUND BALANCE $74,738 $14,489 $105,895 $472,939 TOTAL RESOURCES $3,763,656 $4,346,366 $5,004,665 $5,450,428 EXPENDITURES OPERATING EXPENDITURES General Services $326,034 $428,331 $3,941,657 $4,077,946 Major Computer Systems 363,211 518,677 600 11,454 Microcomputer Systems 839,318 1,004,668 1,072 322 Telecommunications 360,633 317,173 0 10,813 Data Network 753,226 1,207,463 1,550 36,101 GIS System 188,166 224,698 600 0 Public Safety 761,335 632,276 880,107 1,138,499 Non-Departmental 11,733 13,080 19,079 15,293 TOTAL OPERATING EXPENDITURES $3,603,656 $4,346,366 $4,844,665 $5,290,428 OTHER&RESERVES Transfer to Capital Projects $160,000 $0 $160,000 $160,000 Planned Contribution to Fund Balance 0 0 0 0 TOTAL OTHER&RESERVES $0 $0 $0 $160,000 TOTAL EXPENDITURES $3,763,656 $4,346,366 $5,004,665 $5,450,428 BALANCE $0 $0 $0 $0 Ordinance No.3804 Attachment A Page 29 of 29 FISCAL YEAR 2022-2023 REVISED SCHEDULE 25-SUMMARY OF REVENUES AND EXPENDITURES SELF INSURANCE FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2020/21 FY 2021/22 FY 2022/23 FY 2022/23 REVENUES HEALTH&MEDICAL CONTRIBUTIONS Health&Medical(City Contribution) $10,415,739 $10,442,223 $9,512,080 $9,528,257 Health&Medical(Employee Contribution) 2,665,771 2,439,041 2,669,470 2,669,470 TOTAL HEALTH&MEDICAL CONTRIBUTIONS $13,081,510 $12,881,264 $12,181,550 $12,197,727 OTHER CONTRIBUTIONS Worker's Comp&Admin(City Contribution) $1,106,171 $1,119,127 $1,230,753 $1,231,480 Other Insurance(City Contribution) 876,262 1,057,369 1,140,842 1,140,842 Flexible Spending Account(Employee Contribution) 119,970 113,065 146,000 146,000 TOTAL OTHER CONTRIBUTIONS $2,102,404 $2,289,562 $2,517,595 $2,518,322 OTHER REVENUES Stop Loss Reimbursement $76,137 $47,382 $400,000 $400,000 Interest Income 112,846 175,391 95,229 473,320 Other Income 151,269 358,191 33,700 33,700 TOTAL OTHER REVENUES $340,252 $580,965 $528,929 $907,020 TOTAL REVENUES $15,524,167 $15,751,791 $15,228,074 $15,623,069 APPROPRIATION OF FUND BALANCE Self Insurance Fund Reserves $0 $0 $0 $206,381 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $206,381 TOTAL RESOURCES $15,524,167 $15,751,791 $15,228,074 $15,829,450 EXPENDITURES Health&Medical $8,980,150 $8,499,157 $11,649,188 $11,507,956 Worker's Compensation 445,152 117,303 515,000 423,534 Personnel Expenses 500,566 647,500 666,622 694,248 Property,Liability,and Other Insurance 987,680 1,063,500 1,140,842 1,240,842 Flexible Spending Account Expense 122,577 110,156 146,000 146,000 Non-Departmental 0 88,550 0 26,575 TOTAL OPERATING EXPENDITURES $11,036,125 $10,526,165 $14,117,652 $14,039,155 OTHER&RESERVES Transfer to Retiree Health Care Fund $100,000 $100,000 $100,000 $100,000 COVID Lag Contingency 0 0 0 0 Planned Contribution to Fund Balance 0 0 1,010,422 1,690,295 TOTAL OTHER&RESERVES $100,000 $100,000 $1,110,422 $1,790,295 TOTAL EXPENDITURES $11,136,125 $10,626,165 $15,228,074 $15,829,450 BALANCE $4,388,041 $5,125,626 $0 $0 Ordinance No.3804 ve Attachment B , Page 1 of 101 :51Y 1 11 z I' ii fi's*it 1 ri'I'I--:---------------' .,- .ram " .. 1.°'I°:°:::.°." 1.._..,■•••••• ' ( ,,o - . - 0.00° 11°.,171•16:: ,iii_ — . REVISED 1TTT1 CAPITAL BUDGET - ....„.....„ _r______, -AL,...; _,,,......_„., '. �� ....ter-- . I,j NW,,,V f.,-:''''' '1 '''' ' 7 _.— • C Gated 6s,;c7e.47 e-Castellave - -1rAL YEAR R. -s- __- 2023/24 Ordinance No.3804 Attachment B Page 2 of 101 Schedule 11 2022-23 Budget Revisions Budget Summary Adopted Budget 2022-23 Project Project Through Revision Revised Number Name 2022-23 2022-23 _ Budget STREET&SIDEWALK CAPITAL PROJECTS ST2003 Northeast Parkway/Davis Blvd.Traffic Signal $505,000 $302,335 $807,335 ST2005 Northeast Parkway Extension 790,000 (302,335) $487,665 ST2103 Hightower/Davis Traffic Signal 390,000 86,000 $476,000 ST1901 TEXRail Signal Timing Coordination 67,052 (3,878) $63,174 ST1902 Street Assessment Project 140,000 (53,052) $86,948 ST2006 Glenview Drive East 3,860,000 0 $3,860,000 ST2101 Iron Horse Boulevard East Reconstruction 5,275,000 1,000,000 $6,275,000 ST2306 HSIP Intersection Improvements 150,000 18,232 $168,232 ST2217 Sierra Drive 658,800 345,000 $1,003,800 ST2113 North Hills Drive 1,015,000 (511,624) $503,376 ST2214 Kirk Lane 418,800 115,000 $533,800 ST2215 Wood View Drive 697,200 20,000 $717,200 ST2216 South Crest Drive 373,800 31,624 $405,424 ST2212 Main Street 1,429,378 192,937 $1,622,315 ST2118 Diamond Loch West Courts Reconstruction 141,624 (32,378) $109,246 ST2114 Meadow Oak Drive Reconstruction 615,000 (192,937) $422,063 ST2302 Street Assessment Project 140,000 3,878 $143,878 ST1701 Vance and Glenview Signal Upgrades 315,862 (18,232) $297,630 Sub-Total $16,982,516 $1,000,570 $17,983,086 DRAINAGE CAPITAL PROJECTS DR2202 Sunnybrook Addition Drainage Improvements $210,000 $0 $210,000 DR2301 Stream LB-1 Bank Restoration 325,000 0 $325,000 DR2302 Northwest Stoneybrook Drainage Improvements 212,000 0 $212,000 DR2303 Meadow Lakes BFC-7 Drainage Improvements 1,200,000 (187,347) $1,012,653 DR1701 Walker Branch Channel Repair(200ft South of Harwood Road) 740,783 187,347 $928,130 DR2004 Big Fossil Creek Flood Study-BFC7 120,000 (241) $119,759 DR2005 Mackey Creek Flood Study 120,000 (32,692) $87,308 DR2102 Concrete Lined Channel Rehabilitation Project 250,000 0 $250,000 DR2304 Street Drainage Improvements Projects 100,000 0 $100,000 Sub-Total $3,277,783 ($32,933) $3,244,850 UTILITY CAPITAL PROJECTS UT2106 College Hills Ground Storage Tank Rehabilitation $840,000 $521,360 $1,361,360 UT1404 Motor Operated Transfer Valves 730,000 (233,260) $496,740 UT1601 Franklin Court Sewer addition and Gifford Connection 150,000 (64,220) $85,780 UT2120 Utility CAP Projects Personnel 353,105 (223,880) $129,225 UT2002 Miscellaneous Water/Sewer Main Replacement(2020) 445,000 0 $445,000 UT2004 24"Wastewater Main Replacement 1,255,000 (531,667) $723,333 UT2206 Big Fossil Interceptor Rehabilitation 2,510,000 531,667 $3,041,667 UT2304 Cellular Meeter Reading Project 4,855,500 715,679 $5,571,179 UT2203 Telemetric Water Meter Annual Maintenance(2022) 400,000 (400,000) $0 UT2103 Telemetric Water Meter Annual Maintenance(2021) 400,000 (315,679) $84,321 UT2008 Conn Pump Station Pump and Electrical Rehabilitation 2,600,000 0 $2,600,000 UT2303 Sewer Main Replacement-Lowery Lane 275,000 0 $275,000 UT1607 Walker Branch Interceptor Project 4,916,525 0 $4,916,525 Sub-Total $6,283,105 $0 $6,283,105 PARKS&RECREATION CAPITAL PROJECTS PK2207 City Point Trail Development in Oncor Easement $165,000 $25,529 $190,529 PK2202 Cross Timbers Playground Replacement with Shade $230,000 ($38,000) $192,000 PK2303 Dr.Pillow Park Playground Replacement with Shade $200,000 $38,000 $238,000 PK2007 Fossil Creek Mountain Bike Trail $107,500 ($25,529) $81,971 PK1801 Green Valley Raceway Historical Area $155,717 $118,116 $273,833 PK2306 Cross Timbers Playground Replacement with Shade $45,000 ($7,500) $37,500 Sub-Total $903,217 $110,616 $1,013,833 AQUATIC PARK CAPITAL PROJECTS WP2301 General Facility Improvements(2023) $100,000 ($58,000) $42,000 WP2303 NRH2O Attraction and Facilities Analysis $85,000 ($75,000) $10,000 WP2305 Green Extreme Replacement Design and Construction $333,000 $5,400,000 $5,733,000 Sub-Total $518,000 $5,267,000 $5,785,000 Ordinance No.3804 Attachment B Page 3 of 101 Schedule 11 2022-23 Budget Revisions Budget Summary Adopted Budget 2022-23 Project Project Through Revision Revised Number Name 2022-23 2022-23 Budget FACILITIES CAPITAL PROJECTS FC2213 Public Library Lighting Controls $77,500 ($77,500) $0 FC2302 Building Improvement Projects 72,500 167,033 $239,533 FC2314 Public Library HVAC Replacement 600,000 150,000 $750,000 FC2213A Public Library Lighting Controls 77,500 (77,500) $0 FC2315 5301 Davis Blvd Abatement and Demolition 0 145,000 $145,000 FC2316 Library Public Furniture Replacement 0 711,000 $711,000 FC2317 City Hall/AARC-Security Upgrade 0 210,000 $210,000 FC2301 Carpet Replacement 77,500 3,000 $80,500 FC2208 Public Works Pump Station-Building Repairs 97,650 (1,850) $95,800 FC2209 Interior/Exterior Painting 71,000 (300) $70,700 FC2210 Bathroom Flooring Replacement 12,300 (468) $11,832 FC2212 9KVA UPS for Distributed Antenna System 20,000 (9,020) $10,980 FC2214 Custodial/Overhead Door Repairs 6,000 (3,050) $2,950 FC2215 Equipment Replacement and Floor Drain 21,200 (45) $21,155 FC2211 Public Library Painting 132,000 (300) $131,700 FC2311 ()SRAM Encelium Lighting NRH Centre 150,000 60,000 $210,000 FC2312 Refixture Pool Lighting NRH Centre 90,000 10,000 $100,000 FC2318 Outdoor Warning Siren Replacement 0 104,922 $104,922 Sub-Total $1,505,150 $1,390,922 $2,896,072 MAJOR CAPITAL EQUIPMENT CAPITAL PROJECTS IT2214 Interview and Forensic Room Video/Digital Equipment 150,000 150,000 $300,000 IT2215 Forensic Digital Evidence Storage 150,000 (150,000) $0 FS2208 FD Freeway Blocking Truck 136,441 70,000 $206,441 IT1701 Enterprise Computer System Replacement 3,674,428 8,099 $3,682,527 IS1502 Replacement of CAD/RMS Public Safety Software Platform 2,939,000 (8,099) $2,930,901 FS2301 Fire Engine Replacement(#963) 986,000 6,766 $992,766 IT2206 Security Camera and Access Control Upgrade and Additions 340,000 40,000 $380,000 IT1901 Network Replace For Offsite City Facilities 220,500 667 $221,167 IT2109 CradlePoint Upgrade for Fire Vehicles 60,000 (667) $59,333 Sub-Total $8,656,369 $116,766 $8,773,135 ECONOMIC DEVELOPMENT CAPITAL PROJECTS $0 $0 Sub-Total $0 $0 $0 CIP PERSONNEL CAPITAL PROJECTS $0 $0 Sub-Total $0 $0 $0 OTHER CAPITAL PROJECTS ES2201 Neighborhood Initiative Program $5,000 ($1,305) $3,695 ES2301 Neighborhood Initiative Program $34,970 $1,305 $36,275 Sub-Total $0 $0 $0 Total All Projects $51,613,135 $7,852,941 $59,466,076 SOURCES OF FUNDS General Obligation Bonds $8,879,602 $967,622 $9,847,224 Certificates of Obligations $22,157,025 $5,313,267 $27,470,292 Federal/State Grants $6,141,591 $1,326,000 $7,467,591 Reserves $10,999,917 $149,704 $11,149,621 Sales Tax $195,000 $0 $195,000 Other $3,240,000 $96,348 $3,336,348 Total Sources of Funds $51,613,135 $7,852,941 $59,466,076 Ordinance No.3804 Attachment B Page 4 of 101 Street & Sidewalk Capital Projects Northeast Parkway/Davis Blvd.Traffic Signal ST2003 PROJECT DESCRIPTION&JUSTIFICATION This project consists of engineering and construction of a new traffic signal at the intersection of Davis Boulevard and Northeast Parkway.The scope includes paving and signal improvements. The Northeast Parkway/Davis intersection lies within the Smithfield Transit Oriented Development and serves a large residential area east of Davis.The addition of a signal would provide for safe access during peak times from Northeast Parkway to Davis Boulevard for the Stonybrooke neighborhoods,the new Smithfield Villas TOD residential neighborhood,and the existing industrial users on Northeast Parkway. Based on the future extension of Northeast Parkway to the west, it is expected that even more motorists will use this intersection in the future. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 02/2020 04/2022 Land/ROW Acquisition Construction 09/2021 04/2022 04/2023 Other REVISION EXPLANATION ST2005 is preparing to be closed out, and the remaining available funds are needed for this associated project. FINANCIAL DATA ADOPTED f ' REVISED TOTAL BUDGET THRU PROJECT ' BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES ` Various $480,000 $0. $480,000 $0 $480,000 ST2005/Gas Development Fund 0 302,335 302,335 0 $302,335 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $480,000 $302,335 $782,335 $0 $782,335 PROJECT EXPENDITURES= , Professional Services $0 $0 $0 $0 $0 Engineering/Design 122,992 0 122,992 0 $122,992 Land/ROW Acquistion 0 0 0 0 $0 Construction 357,008 302335 659,343 0 $659,343 Other 0 0 0 0 $0 Total $480,000 $302,335 $782,335 $0 $782,335 IMPACT ON OPERATING BUDGET No additional impact anticipated. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 5 of 101 Street& Sidewalk Capital Projects Northeast Parkway Extension ST2005 PROJECT DESCRIPTION&JUSTIFICATION This project consists of constructing an extension of Northeast Parkway west of Davis Boulevard towards Smithfield Road.The new pavement will intersect with Davis at a proposed traffic signal, and will include a roundabout midway between Davis and Smithfield to accommodate a future Snider Street connection and provide traffic calming.The project will be constructed in two phases,with the Davis connection through the roundabout included in Phase I,and the connection to Smithfield in Phase II after the existing elementary school is demolished in 2021. Currently Northeast Parkway tees into Davis Boulevard, providing access to commercial and residential properties to the east. Transit-Oriented-Development growth in the area,as well as the proposed reconstruction and expansion of Smithfield Elementary, create the need for an additional connection point between Davis and Smithfield. Development adjacent to the new roadway will be responsible for TOD zoning requirements such as street trees,street lights, and so forth.A sidewalk connection will be provided from Davis to the new school property. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 09/2019 03/2020 Land/ROW Acquisition Construction 09/2020 03/2022 Other REVISION EXPLANATION This project is preparing to be closed out and there are no further anticipated expenditures. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU ° PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Gas Development Fund $790,000 ($302,335) $487,665 $0 $487,665 0• 0 0 0 $0 0 i0' 0 0 $0 0 °° 0" 0 0 $0 0 0' 0 0 $0 Total $790,000 ($302,335) $487,665 $0 $487,665 PROJECT EXPENDITURES Professional Services $0 �; n ���°$0 $0 $0 $0 Engineering/Design 50,000 (51,000) 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 740,000 ° (252,335) 487,665 0 $487,665 Other 0 :0 0 0 $0 Total $790,000 ($302,335) $487,665 $0 $487,665 IMPACT ON OPERATING BUDGET No additional impact anticipated. ANNUAL OPERATING IMPACT 2022/23_ 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 6 of 101 Street & Sidewalk Capital Projects Hightower/Davis Traffic Signal ST2103 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 ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services 05/2021 03/2022 07/2022 Engineering Land/ROW Acquisition Construction 07/2022 11/2022 12/2022 04/2023 Other REVISION EXPLANATION Bids for the construction of this project came in over the budget for this project.This revision would bring the budget up to where it would need to be for the cost of construction.A transfer within ST2103 expense lines is needed from Professional Services to Construction to help cover construction costs. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION t 2022/23 BALANCE COST FUNDING SOURCES ` Certificates of Obligation $390,000 $0 $390,000 $0 $390,000 Project Savings 0 "86';000' 86,000 0 $86,000 0 0 0 0 $0 0 1 c. 0 0 0 $0 0 0 0 0 $0 Total $390,000 _ $86,000 $476,000 $0 $476,000 PROJECT EXPENDITURES . .= °r �' tt Professional Services $90,000 ($49,320); $40,680 $0 $40,680 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 300,000 135,320; 435,320 0 $435,320 Other 0 0 0 0 $0 Total $390,000 $86,000 $476,000 $0 • $476,000 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 7 of 101 Street& Sidewalk Capital Projects TEXRail Signal Timing Coordination ST1901 PROJECT DESCRIPTION&JUSTIFICATION This project consists of signal timing coordination at the city's signalized intersections which will be impacted by railroad preemption as a result of the commuter rail. The traffic flow at the existing signals at Iron Horse/Browning, Holiday/Mid-Cities, Davis/Main, and Precinct/Glade will be impacted by the regular closure of these roadways to accommodate train traffic once commuter rail is operational at the end of 2018.The purpose of this project is to obtain detailed modeling of the signal operations in conjunction with rail activity in order to minimize the impact of the rail traffic on area motorists. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION • Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Pricing for the ST2302 Street Assessment Project have come in at$3,878 over the budgeted amount.This budget revision would cover that amount. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES General Capital Projects Fund(340) $67,052 °($3,878) $63,174 $0 $63,174 0 ^ 0' 0 0 $0 0 0 0 0 $0 0 ^0 0 0 $0 0 "0 0 0 $0 Total $67,052 ($3,878) $63,174 $0 $63,174 PROJ)=CT EXPENDITURES n,,, �� ti .;r .�• . •- � m Professional Services $0 $0 $0 $0 $0 Engineering/Design 67,052 •(3,878) 63,174 0 $63,174 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 " ,'"�,`," ,0: 0 0 $0 Other 0 '0 0 0 $0 Total $67,052 ($3,878) $63,174 $0 $63,174 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 8 of 101 Street& Sidewalk Capital Projects TEXRail Signal Timing Coordination ST1901 PROJECT DESCRIPTION&JUSTIFICATION This project consists of signal timing coordination at the city's signalized intersections which will be impacted by railroad preemption as a result of the commuter rail. The traffic flow at the existing signals at Iron Horse/Browning, Holiday/Mid-Cities, Davis/Main, and Precinct/Glade will be impacted by the regular closure of these roadways to accommodate train traffic once commuter rail is operational at the end of 2018.The purpose of this project is to obtain detailed modeling of the signal operations in conjunction with rail activity in order to minimize the impact of the rail traffic on area motorists. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 02/2020 10/2020 Land/ROW Acquisition Construction Other REVISION EXPLANATION $32,948 of the remaining project budget has been identified as a source of additional funds for the construction of ST2103 Hightower/Davis Traffic Signal. FINANCIAL DATA ADOPTED "a REVISED TOTAL BUDGET THRU PROJECT it BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Certificates of Obligation $100,000 "' ($32,948) $67,052 $0 $67,052 0 0 0 0 $0 0 0 0 0i $0 0 ,„ �� ,x ;a,pov0,, 0 0 $0 0 0 0 0 $0 Total $100,000 _,,, ($32,948). $67,052 $0 $67,052 PROJECT EXPENDITURES' a ` Professional Services $0,. $0' $0 $0 $0 Engineering/Design 100,000 (32,948) 67,052 0 $67,052 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 I0`, 0 0 $0 Other 0 0 0 0 $0 Total $100,000 ($32,948)_' $67,052 $0 $67,052 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 9 of 101 Street& Sidewalk Capital Projects Street Assessment Project ST1902 PROJECT DESCRIPTION&JUSTIFICATION The City of North Richland Hills roadway network is comprised of 549 lane miles and this project is for a consultant to utilize specialized automated equipment to collect data such as ground penetrating radar, analyze, and process the data in an overall pavement assessment.The assessment would yield a digital condition rating system, budget stressing software that allows modification of the techniques that would result in a prediction of our current as well as the future condition rating,and create five and/or ten year programs that would indicate where funds could be used most impactfully.This project and consultant would be selected on an interlocal agreement with the North Central Texas Council of Governments through their 3 vendors previously selected. This assessment will result in a pavement management program•that will increase the condition and ride-ability of our roadway network and a plan for the future to continually see improvement. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services 10/2018 09/2019 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Work has been completed on this project and the$53,052 remaining has been identified as a source of additional funds for the construction of ST2103 Hightower/Davis Traffic Signal. FINANCIAL DATA ADOPTED `1 REVISED TOTAL BUDGET THRU PROJECT `ii BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Certificates of Obligation/Reserves $140,000 ($53,052)° $86,948 $0 $86,948 0 0 0 0 $0 0 , 0 0 0 $0 0 ," ""2,', . d0 0 0 $0 0 0 0 0 $0 Total $140,000 ($53,052) $86,948 $0 $86,948 PROJECT EXPENDITURES -any d` r� ,: „ Professional Services $140,000 ($53,052) $86,948 $0 $86,948 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 e, 0 0 0 $0 Other 0 0 0 0 $0 Total $140,000 ($53,052) $86,948 $0 $86,948 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 10 of 101 Street & Sidewalk Capital Projects Glenview Drive East 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 Land/ROW Acquisition Construction Other REVISION EXPLANATION Acquisition of an easement along Glenview is necessitated, and appraising the land is required to move forward.This$1,841 transfer into professional services from construction is to cover the remaining amount of the fee to hire an experienced appraiser. FINANCIAL DATA ADOPTED 4 REVISED TOTAL BUDGET THRU PROJECT " BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Certificates of Obligation $380 000 - ' $0 $380,000 $0 $380,000 General Obligation Bonds 3,480,000 0 3,480,000 0 $3,480,000 0 A 0 0 $0 0 0' 0 0 $0 0 �0 0 0 $0 Total $3,860,000 $0 $3,860,000 $0 $3,860,000 PROJECT EXPENDITURES Professional Services $380,000 $1,841', $381,841 $0 $381,841 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 3,480,000 (1,841) 3,478,159 0 $3,478,159 Other 0 b 0 0 $0 Total $3,860,000 $0 $3,860,000 $0 $3,860,000 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT _ 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 11 of 101 Street& Sidewalk Capital Projects Iron Horse Boulevard East Reconstruction ST2101 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 4,400 linear feet of Iron Horse Boulevard from Rufe Snow Drive to York Street.The improvements include reconstructing the existing roadway with reinforced concrete, including the addition of pedestrian facilities.The road will be reconstructed within the existing 80'right-of-way based on the Transportation Plan recommendation that the section be reduced to a divided two-lane 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 Iron Horse Boulevard 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. Iron Horse Blvd. is a minor arterial in the City's roadway network, and this portion of the roadway carries approximately 5,700 vehicles per day.The current pavement condition rating is 24.0 on a scale of 1-100,and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION r END DATE REVISION Professional Services 12/2020 10/2022 Engineering 09/2021 08/2022 12/2022 Land/ROW Acquisition Construction 08/2022 01/2023 08/2023 01/2024 Other 12/2020 10/2022 REVISION EXPLANATION The lowest construction bid for this project came in$1,260,323 over the construction budget.We have$333,692 in savings from the design budget that is being transferred over to construction to help alleviate this overage.We are requesting an additional$1,000,000 in funding from the 2020 Bond Program,as this project was approved with the bond, in order to cover the remaining$926,031 in overages, plus$73,969 as an additional contingency due to the high project cost. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Certificates of Obligation $1,055000 TM $0 $1,055,000 $0 $1,055,000 Federal EDA Cares Act Grant 4,220,000 0 4,220,000 0 $4,220,000 2020 Bond Program 0 1;000,000, 1,000,000 0 $1,000,000 0 0` 0 0 $0 0 $0 Total $5,275,000 a '$1,000,000 $6,275,000 $0 $6,275,000 PROJECT EXPENDITURES rya. Professional Services $0 $0 $0 $0 $0 Engineering/Design ( } $332,308 666,000 333,692 332,308 0 Land/ROW Acquistion 0 .0 0 0 $0 Construction 4,609,000 A, `:1,333,692 5,942,692 0 $5,942,692 Other 0 `0 0 0 $0 Total $5,275,000 $1,000,000. $6,275,000 $0 $6,275,000 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 _ 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 12 of 101 Street & Sidewalk Capital Projects HSIP Intersection Improvements ST2306 PROJECT DESCRIPTION&JUSTIFICATION The project consists of engineering design and reconstruction of two existing signalized intersections: Rufe Snow Drive at Starnes Road and Smithfield Road at Starnes Road. The two subject intersections were submitted to TxDOT's Highway Safety Improvement Program(HSIP)for consideration in late 2021. Although already signalized, accident data at each of these intersections indicates that modifications to signal equipment and lane configurations is warranted in an effort to reduce conflict points and improve motorist safety. Both signals were originally installed in 1987, and while some retrofitting is possible, not all recommended features can be accommodated with the existing equipment. The HSIP grant award provides$833,616 in Federal/State funds for construction PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 03/2023 09/2024 Land/ROW Acquisition Construction 09/2024 08/2025 Other REVISION EXPLANATION This is a new project. Engineering design needs to begin mid-year in order to meet deadlines as established in this grant project. FINANCIAL DATA ADOPTED '' REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES ,__ Street Capital Project Fund Reserves $0 ;��: �$150,000 $150,000 $0 $150,000 0 0 0 0 $0 0 ,0. 0 0 $0 0 0 0 0 $0 0 ' 0 0 0 $0 Total $0 �' a$150,000 $150,000 $0 $150,000 PROJECT EXPENDITURES °" Professional Services $0 $0' $0 $0 $0 Engineering/Design 0 150,000 150,000 0 $150,000 Land/ROW Acquistion 0 0' 0 0 $0 Construction 0 p 0 0 $0 Other 0 °' 0 0 0 $o Total $0 $1'"50,000 $150,000 $0 $150,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 13of101 Street & Sidewalk Capital Projects HSIP Intersection Improvements ST2306 PROJECT DESCRIPTION&JUSTIFICATION The project consists of engineering design and reconstruction of two existing signalized intersections: Rufe Snow Drive at Starnes Road and Smithfield Road at Starnes Road. The two subject intersections were submitted to TxDOT's Highway Safety Improvement Program(HSIP)for consideration in late 2021. Although already signalized, accident data at each of these intersections indicates that modifications to signal equipment and lane configurations is warranted in an effort to reduce conflict points and improve motorist safety. Both signals were originally installed in 1987, and while some retrofitting is possible, not all recommended features can be accommodated with the existing equipment. The HSIP grant award provides$833,616 in Federal/State funds for construction. The funding source for this project is Street Capital Projects Fund Reserves. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION As part of the two Advanced Funding Agreements(AFAs)with TxDOT for the ST2306 grant funding,the City is obligated to pay some upfront costs.The$18,232 in funding would help to cover those costs. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES. Street Capital Fund Reserves $150,000 �� ° $0 $150,000 $0 $150,000 Project Savings(ST1701; Reserves) 0 '18,232 18,232 0 $18,232 0 ,0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $150,000 $18,232�" $168,232 $0 $168,232 PROJECT EXPENDITURES a 6. „� m ., �r $0 $0 $0 $0 $0 Professional Services Engineering/Design 150,000 0 150,000 0 $150,000 Land/ROW Acquistion 0 °' f m 0 0 0 $0 Construction 0 � ��°";18,232: 18,232 0 $18,232 Other 0 �� 0�: 0 0 $0 Total $150,000 $18,232, $168,232 $0 $168,232 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 14 of 101 Street & Sidewalk Capital Projects Sierra Drive ST2217 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 1,100 linear feet of Sierra Drive from Cancun Drive to Caracas 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 Sierra Drive be reconstructed.The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records,and estimated project costs.Sierra Drive is a local or residential street in the City's roadway network.The current pavement condition rating is 17.0 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2023 02/2024 Land/ROW Acquisition Construction 03/2024 09/2024 Other REVISION EXPLANATION ST2113 North Hills Drive, a residential bond street project like Sierra Drive, is,preparing to be closed out. Based on our projections, Sierra Drive will need these funds in order to complete the full scope of the 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 $658,800 .° ° $0, $658,800 $0 $658,800 Project Savings(ST2113; GO Bonds) 0 '345,000 345,000 0 $345,000 0 0 0 0 $0 0 0 0 0 $0 0 .0 0 0 $0 Total $658,800 . °,_`$345,000_ $1,003,800 $0 $1,003,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 643 800 a,: , 345;000 988,800 0 $988,800 Other 0 0 0 0 $0 Total $658,800 $345,000 $1,003,800 $0 $1,003,800 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected , $0 Ordinance No.3804 Attachment B Page 15 of 101 Street & Sidewalk Capital Projects North Hills Drive ST2113 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 3,600 linear feet of North Hills Drive from the City Limit to Wendell 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 North Hills Drive be reconstructed.The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records, and estimated project costs. North Hills Drive is a local or residential street in the City's roadway network.The current pavement condition rating is 11.3 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 12/2020 03/2021 Land/ROW Acquisition Construction 03/2021 10/2021 Other REVISION EXPLANATION ST2113 North Hills Drive, a residential bond street project like Sierra Drive, is preparing to be closed out. Based on our projections,Sierra Drive will need$345,000 in funds to complete the full scope of the 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 $1,015,000 ($345,000) $670,000 $0 $670,000 0u. 0 0 0 $0 0 0 0 0 $0 0 '0 0 0 $0 0 • 0 0 0 $0 Total $1,015,000 ($346,000) $670,000 $0 $670,000 PROJECT EXPENDITURES Professional Services $0 $0' $0 $0 $0 Engineering/Design 5,000 (79) 4,921 0 $4,921 Land/ROW Acquistion 0 0 0 0 $0 Construction 1,010 000 .°„ (344,921) 665,079 0 $665,079 Other 0 0 0 0 $0 Total $1,015,000 ($345,000) $670,000 $0 $670,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 16 of 101 Street & Sidewalk Capital Projects North Hills Drive ST2113 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 3,600 linear feet of North Hills Drive from the City Limit to Wendell 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 North Hills Drive be reconstructed.The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records, and estimated project costs. North Hills Drive is a local or residential street in the City's roadway network.The current pavement condition rating is 11.3 on a scale of 1-100,and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 12/2020 03/2021 Land/ROW Acquisition Construction 03/2021 10/2021 Other REVISION EXPLANATION ST2113 North Hills Drive,a residential bond street project like Kirk Lane, is preparing to be closed out. Based on our projections, Kirk Lane will need$115,000 in funds to complete the full scope of the project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION , 2022/23 BALANCE COST FUNDING SOURCES a °, x. ° General Obligation Bonds $670,000 u4($115,000) $555,000 $0 $555,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 " 0. 0 0 $0 Total $670,000 ($115,000) $555,000 $0 $555,000 PROJECT EXPENDITURES ° ° ° ' $0 $0 $0 $0 $0 Professional Services Engineering/Design 4,921 :0 4,921 0 $4,921 Land/ROW Acquistion 0 0 0 0 $0 Construction 665,079 (115,000) 550,079 0 $550,079 Other 0 �,0_ 0 0 $0 Total $670,000 ($115,000) $555,000 $0 $555,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 17 of 101 Street & Sidewalk Capital Projects North Hills Drive ST2113 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 3,600 linear feet of North Hills Drive from the City Limit to Wendell 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 North Hills Drive be reconstructed.The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records, and estimated project costs. North Hills Drive is a local or residential street in the City's roadway network.The current pavement condition rating is 11.3 on a scale of 1-100,and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 12/2020 03/2021 Land/ROW Acquisition Construction 03/2021 10/2021 Other REVISION EXPLANATION ST2113 North Hills Drive, a residential bond street project like Wood View Drive, is preparing to be closed out. Based on our projections,Wood View Drive will need$20,000 in funds to complete the full scope of the project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU As PROJECT1 ` BUDGET THRU REMAINING PROJECT 2022/23 "'.REVISON, 2022/23 BALANCE COST FUNDING SOURCES General Obligation Bonds $555,000 'a ,�i�4($20'000�)'' $535,000 $0 $535,000 0 " 0 0 0 $0 0s n 0''' 0 0 $0 0 A' > E° 0 0 $0 0 aw 0 0 $0 Total $555,000 �($20,(.100) $535,000 $0 $535,000 PROJECT EXPENDITURES $0 N�,g�� 0 $0 $0 $0 Professional Services Engineering/Design 4,921 i ,= 0, 4,921 0 $4,921 Land/ROW Acquistion 0 ' 0 0 0 $0 Construction 550,079 (20 0004'I 530,079 0 $530,079 Other 0 ik NI'h ' 0 0 $0 Total $555,000 N.,, ; .($20,000) $535,000 $0 $535,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT ' 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 18 of 101 Street& Sidewalk Capital Projects North Hills Drive ST2113 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 3,600 linear feet of North Hills Drive from the City Limit to Wendell 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 North Hills Drive be reconstructed.The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes,maintenance records,and estimated project costs. North Hills Drive is a local or residential street in the City's roadway network.The current pavement condition rating is 11.3 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 12/2020 03/2021 Land/ROW Acquisition Construction 03/2021 10/2021 Other REVISION EXPLANATION ST2113 North Hills Drive, a residential bond street project like South Crest Drive, is preparing to be closed out. Based on our projections,South Crest Drive will need additional funds to complete the full scope of the project,and we would cover$31,624 of needed funds from what remains from North Hills before it is closed out. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES General Obligation Bonds $535,000 `($31,624 $503,376 $0 I $503,376 0 0 0 0 $0 0 0 0 0 $0 0 0: 0 0 $0 0 0; 0 0 $0 Total $535,000 °($31,624) $503,376 $0 $503,376 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 4,921 0 4,921 0 $4,921 Land/ROW Acquistion 0 0 0 0 $0 Construction 530,079 "(31,624)' 498,455 0 $498,455 Other 0 0 0 0 $0 Total $535,000 ($31,624) $503,376 $0 $503,376 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 19 of 101 Street & Sidewalk Capital Projects Kirk Lane ST2214 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 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2023 02/2024 Land/ROW Acquisition Construction 03/2024 09/2024 Other REVISION EXPLANATION ST2113 North Hills Drive,a residential bond street project like Kirk Lane, is preparing to be closed out. Based on our projections, Kirk Lane will need$115,000 in funds to complete the full scope of the 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 $418,800 ",° $0, $418,800 $0 $418,800 Project Savings(ST2113; GO Bonds) 0 115,000 115,000 0 $115,000 0 ` 0 0 0 $0 0 a. 0 0 0 $0 0 0 $0 Total $418,800 $115,000 $533,800 $0 $533,800 PROJECT EXPENDITURES • .v 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 403,800 P�,'a-", 115,000, 518,800 0 $518,800 Other 0 0 0 0 $0 Total $418,800 $115,000 $533,800 $0 $533,800 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 _ 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 20 of 101 Street & Sidewalk Capital Projects Wood View Drive ST2215 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 1,200 linear feet of Wood View Drive from Dick Lewis Drive to Meadow Park Drive North.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 Wood View Drive be reconstructed.The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records, and estimated project costs.Wood View Drive is a local or residential street in the City's roadway network.The current pavement condition rating is 14.7 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2023 02/2024 Land/ROW Acquisition Construction 03/2024 09/2024 Other REVISION EXPLANATION ST2113 North Hills Drive,a residential bond street project like Wood View Drive, is preparing to be closed out. Based on our projections,Wood View Drive will need$20,000 in funds to complete the full scope of the 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 $697,200 °r.° _ $0 $697,200 $0 $697,200 Project Savings(ST2113; GO Bonds) 0 20,000 20,000 0 $20,000 0 0 0 0 $0 0 `0 0 0 $0 0 0 0 0 $0 Total $697,200 $20,000 $717,200 $0 $717,200 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 682,200 '20,000 702,200 0 $702,200 Other 0 0' 0 0 $0 Total $697,200 $20,000'e $717,200 $0 $717,200 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 21 of 101 Street & Sidewalk Capital Projects South Crest Drive ST2216 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 630 linear feet of South Crest Drive from Crane Road to Rolling Hills 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 South Crest Drive be reconstructed.The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes,maintenance records,and estimated project costs.South Crest Drive is a local or residential street in the City's roadway network.The current pavement condition rating is 9.1 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2023 02/2024 Land/ROW Acquisition Construction 03/2024 09/2024 Other REVISION EXPLANATION ST2113 North Hills Drive, a residential bond street project like South Crest Drive, is preparing to be closed out. Based on our projections, South Crest Drive will need additional funds to complete the full scope of the project,and we would cover$31,624 of needed funds from what remains from North Hills before it is closed out. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT _ 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES ° General Obligation Bonds $373,800 $0 $373,800 $0 $373,800 Project Savings(ST2113; GO Bonds) 0 - 31,624 31,624 0 $31,624 0 0 0 0 $0 0 '0 0 0 $0 0 0. 0 0 $0 Total $373,800 $31,624 $405,424 $0 $405,424, PROJECT EXPENDITURES "" Professional Services $0 $0 $0 $0 $0 Engineering/Design 15,000 0 15,000 0 $15,000 Land/ROW Acquistion 0 �; d ° 0 0 0 $0 Construction 358,800 n�ti ° 31,624 390,424 0 $390,424 Other 0 0 0 0 $0 Total $373,800 $31,624 $405,424 $0 $405,424 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 22 of 101 Street& Sidewalk Capital Projects Main Street ST2212 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 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ST2118 Diamond Loch West Courts Reconstruction, a bond street project like Main Street, is preparing to be closed out. Based on our projections, Main Street will need additional funds to complete the full scope of the project,and we would cover $32,378 of needed funds from what remains from Diamond Loch West Courts Reconstruction before it is closed out. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT ' BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES General Obligation Bonds $1,397,000 '�� � �� $0d $1,397,000 $0 $1,397,000 Project Savings(ST2118; GO Bonds) 0 ° 32,378 32,378 0 $32,378 0 °=0 0 0 $0 0 0 0 0 $0 0 0�„ 0 0 $0 Total $1,397,000 $32,378 $1,429,378 $0 $1,429,378 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,215,390 ° $2,378 1,247,768 0 $1,247,768 ar Other 0 0 0 0 $0 Total $1,397,000 ° $32,378 $1,429,378 $0 $1,429,378 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 23 of 101 Street & Sidewalk Capital Projects Main Street ST2212 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 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ST2114 Meadow Oak Drive Reconstruction,a bond street project like Main Street, is preparing to be closed out. Based on our projections, Main Street will need these funds($192,937)in order to complete the full scope of the project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION ' 2022/23 BALANCE COST FUNDING SOURCES 2020 GO Bonds $1,429,378 " 114,c$1�,92,937a $1,622,315 $0 $1,622,315 0 . 0� 0 0 $0 0 - 0 0 0 $0 0 0 0 0 $0 0 0 $0 Total $1,429,378 $192,937-' $1,622,315 $0 $1,622,315 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,247,768 "4 192,937 1,440,705 0 $1,440,705 Other 0 0, 0 0 $0 Total $1,429,378 $192,937 $1,622,315 $0 $1,622,315 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 _ 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 24 of 101 Street& Sidewalk Capital Projects Diamond Loch West Courts Reconstruction ST2118 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 200 linear feet of two Diamond Loch West courts from located off of the main Diamond Loch West roadway.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 two Diamond Loch West courts be reconstructed.The committee considered several factors when recommending street projects including existing pavement conditions,traffic volumes, maintenance records,and estimated project costs. Diamond Loch West is a local or residential street in the City's roadway network.The current pavement condition rating is approximately 10 on a scale of 1-100, and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ST2118 Diamond Loch West Courts Reconstruction, a bond street project like Main Street, is preparing to be closed out. Based on our projections, Main Street will need additional funds to complete the full scope of the project,and we would cover $32,378 of needed funds from what remains from Diamond Loch West Courts Reconstruction before it is closed out. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 °REVISION 2022/23 BALANCE COST FUNDING SOURCES „ General Obligation Bonds $141 624 ,d($32,378)5 $109,246 $0 $109,246 0 0 0 0 $0 0 "0. 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $141,624 ($32,378) $109,246 $0 $109,246 PROJECT EXPENDITURES °' � .:�'°" <<.r o„ , Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 141,624 (32,378) 109,246 0 $109,246 Other 0 0 0 0 $0 Total $141,624 ($32,378) $109,246 $0 $109,246 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 25 of 101 Street& Sidewalk Capital Projects Meadow Oak Drive Reconstruction ST2114 PROJECT DESCRIPTION&JUSTIFICATION The project consists of the design and reconstruction of approximately 900 linear feet of Meadow Oak Drive from Dick Lewis to Buenos Aires.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 Meadow 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. Meadow Oak Drive is a local or residential street in the City's roadway network.The current pavement condition rating is 13.6 on a scale of 1-100,and has deteriorated to the point that full reconstruction is warranted. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ST2114 Meadow Oak Drive Reconstruction, a bond street project like Main Street, is preparing to be closed out. Based on our projections, Main Street will need these funds($192,937)in order to complete the full scope of the project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES 2020 GO Bonds $615,000 w($192,937) $422,063 $0 $422,063 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $615,000 °=°($192,937) $422,063 $0 $422,063 PROJECT EXPENDITURES Professional Services $0 $0, $0 $0 $0 Engineering/Design 5,000 (5,000) 0 0 $0 Land/ROW Acquistion 0 ° 0 0 0 $0 Construction 610,000 ! (187,937) 422,063 0 $422,063 Other 0 tl 0 0 0 $0 Total $615,000 ($192,937) $422,063 $0 $422,063 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 26 of 101 Street & Sidewalk Capital Projects Street Assessment Project ST2302 PROJECT DESCRIPTION&JUSTIFICATION The City of North Richland Hills roadway network is comprised of 549 lane miles and this project is for a consultant to utilize specialized automated equipment such as ground penetrating radar to collect data, analyze, and process the data in an overall pavement assessment.The assessment will yield a digital condition rating system, budget stressing software that allows modification of the techniques that would result in a prediction of the future condition rating, and create five and/or ten year programs that would indicate where funds could be used most impactfully. This assessment will result in a pavement management program that will increase the condition and rideability of our roadway network and a plan for the future to continually see improvement.A previous assessment approved in the 18/19 budget has proven game-changing for the city's annual Preventive Street Maintenance Program, and when prioritizing available reconstruction dollars. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services 10/2022 09/2023 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Pricing for the ST2302 Street Assessment Project have come in at$3,878 over the budgeted amount.This budget revision would cover that amount. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 °°-REVISION 2022/23 BALANCE COST FUNDINGxSOURCES , ` General Capital Projects Fund(340) $140,000 pis �a. ' $0 $140,000 $0 $140,000 Project Savings(ST1901; Fund 340) 0 3,878 3,878 0 $3,878 0 0 0 0 $0 0 0 0 0 $0 0 .0` 0 0 $0 Total $140,000 $3,878 $143,878 $0 $143,878 PROJECT EXPENDITURES " w`` `. Professional Services $140,000 $3,878 $143,878 $0 $143,878 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 ,-. a0 0 0 $0 Construction 0 '0e 0 0 $0 Other 0 0 $0 Total $140,000 $3,878 $143,878 $0 $143,878 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 27 of 101 Street & Sidewalk Capital Projects Vance and Glenview Signal Upgrades ST1701 PROJECT DESCRIPTION&JUSTIFICATION This project consists of replacing the existing span wire signal at the intersection of Vance Road and Glenview Drive with pole mounted signals.This project also includes the installation of pedestrian signal heads and striping at the intersection.This project has been approved for funding through the HSIP(Highway Safety Improvement Program)grant which is 90%federal funding and 10%local funding.The 90%coverage of federal funds is only for construction costs.This project will be let through TxDOT as the grant is disseminated through TxDOT. As part of the City's submission for the HSIP grant,the City discovered from 2012-2014,there was one accident near this intersection with one fatality, one incapacitating injury and two non-incapacitating injuries. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE , REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION As part of the two Advanced Funding Agreements(AFAs)with TxDOT for the ST2306 grant funding,the City is obligated to pay some upfront costs.The$18,232 in funding would help to cover those costs. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 "`REVISION 2022/23 BALANCE COST FUNDING SOURCES Federal/State Grants $180,000 ., - $0` $180,000 $0 $180,000 Reserves 85,862 (18,232); 67,630 0 $67,630 GO Bonds(2004) 10,361 0: 10,361 0 $10,361 GO Bonds(2009) 39,639 ;0 39,639 0 $39,639 00 0 0 $0 Total $315,862 ($18,232) $297,630 $0 $297,630 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 285,862 b"(18 232) 267,630 0 $267,630 Other 0 0 0 0 $0 Total $315,862 ($18,232) $297,630 $0 $297,630 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 28 of 101 Drainage Capital Projects Sunnybrook Addition Drainage Improvements 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 2022/23 ORIGINAL 202223 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2021 10/2022 03/2022 03/2023 Land/ROW Acquisition Construction 04/2022 04/2023 09/2022 09/2023 Other REVISION EXPLANATION The design cost came in at$4,000 over the projected cost.This is after negotiations brought the initial cost down. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/32 REVISION 2022/23 BALANCE COST FUNDING SOURCES � a „ ' z Drainage Utility Fund Reserves(120) $210 000 n"� ° $0 $210,000 $0 $210,000 0 '0' 0 0 $0 0 '0 0 0 $0 0 0 0 0 $0 0 Q 0 0 $0 Total $210,000 $0 $210,000 $0 $210,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 35,000 4,000 39,000 0 $39,000 Land/ROW Acquistion 00 0 0 $0 Construction 175,000 - (4,000) 171,000 0 $171,000 Other 0 0 0 0 $0 Total $210,000 " ', $0 $210,000 $0 $210,000 IMPACT ON OPERATING BUDGET No operating impact is anticipated. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 29 of 101 Drainage Capital Projects Stream LB-1 Bank Restoration 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. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 12/2022 06/2023 Land/ROW Acquisition Construction 07/2023 11/2023 Other REVISION EXPLANATION Engineering/Design services came in higher than the budgeted amount.This$36,577 transfer is to cover the additional funds needed. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES P_° Drainage Utility Fund Reserves $325 000 $0 $325,000 $0 $325,000 0 , " 0 0 0 $0 0 0 0 0 $0 0 0 0 $0 0 0 0 0 $0 Total $325,000 2Ki` $0 $325,000 $0 $325,000 PROJECT EXPENDITURES tlU Professional Services $0 $0 $0 $0 $0 Engineering/Design 75,000 36,577 111,577 0 $111,577 Land/ROW Acquistion 0 0 0 0 $0 Construction 250,000 ° '" 136,577).; 213,423 0 $213,423 Other 0 ° ° 0 0 0 $0 Total $325,000 $0 $325,000 $0 $325,000 IMPACT ON OPERATING BUDGET No impact anticipated. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 30 of 101 Drainage Capital Projects Northwest Stonybrook Drainage Improvements 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. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE _ REVISION Professional Services Engineering 01/2023 07/2023 Land/ROW Acquisition Construction 08/2023 12/2023 Other REVISION EXPLANATION Engineering/Design services came in higher than the budgeted amount.This$13,200 transfer is to cover the additional funds needed. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION ; 2022/23 BALANCE COST FUNDING SOURCES" °_ „ , Drainage Utility Fund Reserves $212,000 a 4r,; $0 $212,000 $0 $212,000 0 0 0 0 $0 0 -` 0 0 0 $0, 0 ` 0 0 0 $0 0 0. 0 0 $0 Total $212,000 $0 $212,000 $0 $212,000 PROJECT EXPENDITURES .,o �z .. . Professional Services $0 $0 $0 $0 $0 Engineering/Design 42,000 13,200 55,200 0 $55,200 Land/ROW Acquistion 0 0e 0 0 $0 Construction 170 000 (13,200) 156,800 0 $156,800 Other 0 ,D 0 0 $0 Total $212,000 °= $0 $212,000 $0 $212,000 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 31 of 101 Drainage Capital Projects Meadow Lakes BFC-7 Drainage Improvements DR2303 PROJECT DESCRIPTION&JUSTIFICATION This project consists of up-sizing 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. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 01/2023 09/2023 Land/ROW Acquisition Construction 10/2023 08/2024 Other REVISION EXPLANATION Engineering/Design services came in higher than the budgeted amount.This$49,879 transfer is to cover the additional funds needed. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES . Drainage Utility Fund Reserves $1,200,000 ,.$0 $1,200,000 $0 $1,200,000 0 '0 0 0 $0 0 0 0 0 $0 0 tv',rr, 0 0 0 $0 0 0 0 0 $0 Total $1,20.0,000 $0 $1,200,000 $0 $1,200,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 150,000 49,879 199,879 0 $199,879 Land/ROW Acquistion 0 0 0 0 $0 Construction 1,050,000 (49,879) 1,000,121 0 $1,000,121 Other 0 0 0 0 $0 Total $1,200,000 $0 $1,200,000 $0 $1,200,000 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 _ 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 32 of 101 Drainage Capital Projects Meadow Lakes BFC-7 Drainage Improvements DR2303 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,200,000 from Drainage Utility Fund Reserves. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE • REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Construction bids came in$226,967 over the available construction budget for DR1701.We plan to transfer$39,620 of remaining funding from the design budget of DR1701,and$187,347 in available funding from the construction budget of DR2303 to come up with this funding. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Drainage Utility Fund Reserves(120) $1,200,000 ($187,347) $1,012,653 $0 $1,012,653 0 = ' �0 0 0 so 0 0 0 0 $0 0 0 0 0 $0 0 "° 0 0 0 $0 Total $1,200,000 `. ($187,347) $1,012,653 $0 $1,012,653 PROJECT EXPENDITURES ° Professional Services $0 $0 $0 $0 $0 Engineering/Design 199,879 0 199,879 0 $199,879 Land/ROW Acquistion 0 ° 0 0 0 $0 Construction 1,000,121 (187,347) 812,774 0 $812,774 Other 0 0 0 0 $0 Total $1,200,000 ($187,347) $1,012,653 $0 $1,012,653 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 33 of 101 Drainage Capital Projects Walker Branch Channel Repair DR1701 PROJECT DESCRIPTION&JUSTIFICATION The project consists of engineering and reconstructing approximately 400 feet of gabions along the Walker Branch Channel. The project begins south of Harwood along the west bank and will focus on two areas where the gabion baskets have failed. Because of record rainfall received in 2015 following years of drought conditions significant erosion has occurred in recent months.As a result of the soil conditions due to these weather events,the Walker Branch Channel has experienced several failures along the banks adjacent to residential properties and the situation continues to deteriorate.Without fortification of the bank in this area,the erosion will progress into private property. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION DR2004 and DR2005 are being prepared for close-out.The remaining open balances of$241 (DR2004)and$32,692 (DR2005)are requested for transfer to DR1701 to help cover the anticipated construction costs. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Reserves $707,850 $0 $707,850 $0 $707,850 Reserves(DR2004) 0 241 241 0 $241 Reserves(DR2005) 0 32,692 32,692 0 $32,692 0 ,. 0, 0 0 $0 0 °0' 0 0 $0 Total $707,850 $32,933 $740,783 $0 $740,783 PROJECT EXPENDITURES Professional Services $0 '$0 $0 $0 $0 Engineering/Design 160,000 '0 160,000 0 $160,000 Land/ROW Acquistion 0 0 0 0 $0 Construction 547,850 °:' 32933` 580,783 0 $580,783 Other 0 0'': 0 0 $0 Total $707,850 $32,933 $740,783 $0 $740,783 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 34 of 101 Drainage Capital Projects Walker Branch Channel Repair(200ft South of Harwood Road) DR1701 PROJECT DESCRIPTION&JUSTIFICATION The project consists of engineering and reconstructing approximately 400 feet of gabions along the Walker Branch Channel. The project begins south of Harwood along the west bank and will focus on two areas where the gabion baskets have failed. Because of record rainfall received in 2015 following years of drought conditions significant erosion has occurred in recent months.As a result of the soil conditions due to these weather events,the Walker Branch Channel has experienced several failures along the banks adjacent to residential properties and the situation continues to deteriorate.Without fortification of the bank in this area,the erosion will progress into private property. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Construction bids came in$226,967 over the available construction budget for DR1701.We plan to transfer$39,620 of remaining funding from the design budget of DR1701, and$187,347 in available funding from the construction budget of DR2303 to come up with this funding. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Drainage Utility Fund Reserves(120) $740,783 $0 $740,783 $0 $740,783 Project Savings(DR2303) 0 187 347 187,347 0 $187,347 0 '0 0 0 $0 0 0 0 0 $0 0 0 0 $0 Total $740,783 "' °$187,347 $928,130 $0 $928,130 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 160,000 (39,620) 120,380 0 $120,380 Land/ROW Acquistion 0 10 0 0 $0 Construction 580,783 y 226,967 807,750 0 $807,750 Other 0 e ,0 0 0 $0 Total $740,783 $187,347 $928,130 $0 $928,130 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 35 of 101 Drainage Capital Projects Big Fossil Creek Flood Study DR2004 PROJECT DESCRIPTION&JUSTIFICATION This project consists of performing a flood study on the existing BFC-7 Tributary to Big Fossil Creek. BFC-7 begins just south of Loop 820 with a TxDOT outfall channel south of the highway,then south into the Meadow Lakes subdivision, including portions of Meadow Lakes Drive, Lake Side Circle, Pebble Court, and the two lakes between Riviera Drive and Meadow Lakes Drive. The flood study would update FEMA's model to reflect the current hydrology and hydraulics,and upgrade this area to a Zone AE from its current Zone A status.The engineering budget for this project includes FEMA review fees for the Letter of Map Revision(LOMR)that will be required to update the maps. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION DR2004 is being prepared for close-out.The remaining open balance of$241 is requested for transfer to DR1701 to help cover the anticipated construction costs. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 `;REVISION 2022/23 BALANCE COST F.UNDINGSOURCES , a << �° `` Reserves(125) $120,000 " ($241) $119,759 $0 $119,7591 0 0 0 0 $0 0 ' " 0 0 0 $0 0 0 0 0 $0 0 ';--- A 0 0 $0 Total $120,000 '�a � ($241) $119,759 $0 $119,759 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 120,000 (241) 119,759 0 $119,759 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 ': t0 0 0 $0 Other 0 0 0 0 $0 Total $120,000 ($241) $119,759 $0 $119,759 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 36 of 101 Drainage Capital Projects Mackey Creek Flood Study DR2005 PROJECT DESCRIPTION&JUSTIFICATION This project consists of creating new hydrologic and hydraulic models to provide regulatory floodplain mapping for Mackey Creek from upstream of Shauna Drive to Big Fossil Creek(approximately 2.4 miles).This study would also identify potential future capital improvement projects to reduce the size of or completely eliminate the floodplain within the study area.The original study for Mackey Creek was done in 1985 with the City's Master Drainage Plan. New topographic data is available along Mackey Creek and new floodplain modeling techniques would be used in the study. The data current effective modeling and mapping for Mackey Creek is based on the City's 1985 Master Drainage Plan. Floodplain modeling and mapping technology has advanced to be able to better estimate flood risk in areas that have both above and below ground storm drainage conveyance systems like the upper reaches of Mackey Creek.This study would help to give a better picture of flood risk to residents and business owners along Mackey Creek and would also provide recommendations for capital improvement projects to remove/reduce the floodplain throughout the area. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION DR2005 is being prepared for close-out.The remaining open balance of$32,692 is requested for transfer to DR1701 to help cover the anticipated construction costs. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 s REVISION 2022/23 BALANCE COST FUNDING SOURCES" Reserves(125) $120,000 ($32,692)! $87,308 $0 $87,308 0 " 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 $0 Total $120,000 ° " ,($32,692) $87,308 $0 $87,308 PROJECT EXPENDITURES $0 $0 $0 $0 $0 Professional Services Engineering/Design 120,000 (32,692) 87,308 0 $87,308 Land/ROW Acquistion 0 0 0 $0 Construction 0 ' �' " '"''" ° 0' 0 0 $0 Other 0 0 0 0 $0 Total $120,000 ($32,692) $87,308 $0 $87,308 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 37 of 101 Drainage Capital Projects Concrete Lined Channel Rehabilitation Project DR2102 PROJECT DESCRIPTION&JUSTIFICATION Concrete channels are designed to transport storm water run off during rain events.When these channels have areas of deteriorated concrete channel liner,flowing water has the ability to penetrate the concrete subgrade,which undermines the integrity of the channel and poses a threat to public and private property. Some areas in the concrete channels hold extensive amounts of water because of deterioration that has occurred,which becomes a breeding ground for mosquito larvae and raises citizen concern.These types of repairs cannot be made within the current General Fund operating budget.The repairs are specialized and must be done by private sources. Note: Project funding source is the Drainage Utility Fund(120). PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Due to a recent drainage channel bank failure,geotechnical engineering services are required to identify potential solutions.A wording change is also required to allow for this project to utilize professional services/engineering services. $10,000 is requested to be moved from the construction budget to the engineering budget. FINANCIAL DATA ADOPTED "` REVISED TOTAL BUDGET THRU PROJECT • BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Reserves(Drainage Utility Fund, 120) $250,000 $0 $250,000 $0 $250,000 0 0 0 0 $0 0 ,0 0 0 $0 0 i0 0 0 $0 0 0i 0 0 $0 Total $250,000 $0 $250,000 $0 $250,000 PROJECT EXPENDITURES p,°' Professional Services $0 ° $0 $0 $0 $0 Engineering/Design 0 10,000 10,000 0 $10,000 Land/ROW Acquistion 0 0 0 0 $0 Construction 250,000 (10,000) 240,000 0 $240,000 Other 0 0 0 0 $0 Total $250,000 e;-'r$0 $250,000 $0 $250,000 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022123 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 38 of 101 Drainage Capital Projects Concrete Lined Channel Rehabilitation Project DR2102 PROJECT DESCRIPTION&JUSTIFICATION Concrete channels are designed to transport storm water run off during rain events.When these channels have-areas of deteriorated concrete channel liner,flowing water has the ability to penetrate the concrete subgrade,which undermines the integrity of the channel and poses a threat to public and private property. Some areas in the concrete channels hold extensive amounts of water because of deterioration that has occurred,which becomes a breeding ground for mosquito larvae and raises citizen concern.These types of repairs cannot be made within the current General Fund operating budget.The repairs are specialized and must be done by private sources. Note: Project funding source is the Drainage Utility Fund(120). PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Due to a recent drainage channel bank failure, engineering is required to design the improvements needed to rehabilitate the channel.$55,630 in funding is requested to be moved from the construction budget to the engineering budget. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Reserves(Drainage Utility Fund, 120) $250 000 sa ��a $0 $250,000 $0 $250,000 0 0' 0 0 $0 0 0 0 0 $0 0 '0 0 0 $0 0 i0 0 0 $0 Total $250,000 "o • $0' $250,000 $0 $250,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 10,000 55,630 65,630 0 $65,630 Land/ROW Acquistion 0 0 0 0 $0 Construction 240,000 ,a(55,630) 184,370 0 $184,370 Other 0 0 0 0 $0 Total $250,000 . $0 $250,000 $0 ' $250,000 IMPACT ON OPERATING BUDGET • No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 39 of 101 Drainage Capital Projects Street Drainage Improvements Project 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 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION A street drainage improvement is going to require engineering&design.This internal project transfer would cover those costs. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Operating Funds $100,000 $0 $100,000 $0 $100,000 0 " " 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $100,000 $0 $100,000 $0 $100,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 " 45,05Q 45,050 0 $45,050 Land/ROW Acquistion 0 '0 0 0 $0 Construction 100,000 i tip{4'5,050)" 54,950 0 $54,950 Other 0 '°' 0 0 $0 Total $100,000 $0' $100,000 $0 $100,000 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 40 of 101 Utility Capital Projects College Hills Ground Storage Tank Rehabilitation UT2106 PROJECT DESCRIPTION&JUSTIFICATION This project will rehabilitate the College Hills Ground Storage Tank.This will include preparing the exterior and interior of the tank to apply new paint on both surfaces.Additional work will include: installing pipe screen at overflow, installing a ladder gate, installing a new hatch on the roof, installing a new vent, repairing the float system,caulk and seal at the foundation, install a new safety climb system,and remove the existing interior ladder. College Hills Ground Storage Tank was built in 1991.This tank stores the largest capacity of water in the system at five million gallons.With it's location and capacity it is very critical to the entire distribution system. Over the last 28 years,this tank has not had a total rehab applied to the tank.The exterior and interior coatings have performed very well during this time. During the installation of the Pax mixer in the tank, staff was able to inspect the interior of the tank. Rust and corrosion have started to form in different locations inside the tank. Industry standards typically recommend having the exterior and interior coatings reapplied between 10-12 years. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE , REVISION END DATE REVISION Professional Services 10/2020 05/2022 05/2023 Engineering Land/ROW Acquisition Construction 11/2021 11/2022 06/2022 06/2023 Other REVISION EXPLANATION Construction bids came in above the budgeted construction amount.Additional funds are required. $71,000 is being requested to be moved from professional services over to construction, as well as$64,220 from UT1703, $223,880 from UT2120, and $233,260 from UT1404. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU 'PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Certificates of Obligation $840,000 , $64,220 $904,220 $0 $904,220 Utility Operations for Capital Projects 0 457,140 457,1401 0 $457,140 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $840,000 —$521,360 $1,361,360 $0 $1,361,360 PROJECT EXPENDITURES Professional Services $140,000 ($71,000) $69,000 $0 $69,000 Engineering/Design 0 '0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 700,000 P"° 592,360" 1,292,360 0 $1,292,360 Other 0 0 0 0 $0 Total $840,000 $521,360 $1,361,360 $0 $1,361,360 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 41 of 101 Utility Capital Projects Motor Operated Transfer Valves 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 customer's 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 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition • 11/2015 09/2020 Construction 09/2016 09/2020 06/2023 Other REVISION EXPLANATION $233,260 of the remaining available project funds are needed to fund UT2106. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Utility Operations for Capital Projects $730,000 '($233,260)°($233,260) $496,740 $0 $496,740 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $730,000 1$233,260) $496,740 $0 $496,740 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 730,000 ti' (233 260) 496,740 0 $496,740 Other 0 0 0 0 $0 Total $730,000 ($233,260) $496,740 $0 $496,740 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 _ 2023/24 _ 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 42 of 101 Utility Capital Projects Franklin Court Sewer Addition and Gifford Connection UT1601 PROJECT DESCRIPTION&JUSTIFICATION This project consists of design and construction of a new 6"sanitary sewer along Franklin Court with a partial connection to Gifford for future development.The project will consist of approximately 1,000 linear feet of 6"sanitary sewer. The lots on Franklin Court were platted in the 1950's and have not had access to NRH City utilities since that time.The older mobile homes on the street were served by individual septic systems. Currently the platted lot sizes(less than%4 acre each) pose a challenge to development in the area as there is insufficient land area to accommodate conventional R-2 homes with onsite septic systems.A sanitary sewer stub-out to the far south end of Franklin Court was provided in the 1990's with Shady Oaks. Extending this system north to serve Franklin Court unlocks development potential on the immediate 19 lots and also allows for a future extension to serve Gifford Lane,which also lacks sewer service. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 03/2017 06/2017 Land/ROW Acquisition 11/2017 12/2017 Construction 12/2017 08/2018 Other REVISION EXPLANATION $64,220 of the remaining available project funds are needed to fund UT2106. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Certificates of Obligation $150,000 1 ($64,220) $85,780 $0 $85,780 0 0. 0 0 $0 0 - 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $150,000 ($64,220)'_ $85,780 $0 $85,780 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 20,000 (12,225) 7,775 0 $7,775 Land/ROW Acquistion 10,000 • (5,640) 4,360 0 $4,360 Construction 120,000 (46,355)` 73,645 0 $73,645 Other 0 0 0 0 $0 Total $150,000 ($64,220) $85,780 $0 $85,780 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 43 of 101 Utility Capital Projects Utility CAP Projects Personnel UT2120 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 $233,880 of the remaining available funds are needed to fund UT2106. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU :PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES F. Utility Operations for Capital Projects $353,105 '°. ,"($223,880) $129,225 $0 $129,225 0 0: 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 • 0 0 0 $0 Total $353,105 ">.' -($223,880). $129,225 $0 $129,225 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 353,105 (223,880) 129,225 0 $129,225 Total $353,105 ($223,880) $129,225 $0 $129,225 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 44 of 101 Utility Capital Projects Miscellaneous Water/Sewer Main Replacement(2020) UT2002 • PROJECT DESCRIPTION&JUSTIFICATION This is an annual program that is performed by the Public Works Construction Division.The program will provide for the construction of water and wastewater main replacements to include possible development projects.The project replaces the aging and undersized water and wastewater infrastructure.This year's scope is expected to include water/sewer main replacements on the following streets: Edinburg Drive(Brookshire to Wakefield), Circle Drive(Susan Lee to Cul-de-sac), Bogart(College Circle to Price), Spring Lea Way(Starnes to Lincoln)and Southampton Drive(Wakefield to Chapman). PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2020 10/2022 09/2022 09/2023 Other REVISION EXPLANATION This revision will capture project savings from the UT2002 PROFSRVS&EQUIPMENT accounts and will provide all funding for UT2002 Construct Project String.These reimbursements will cover costs associated with the purchasing and installation of materials, equipment and services needed to complete utility and street repair completed by city forces and our concrete contractor. (PROFSRVS$2334.00—EQUIPMENT$5491.00)for a total of$7825.00 FINANCIAL DATA ADOPTED �`'' N ° REVISED TOTAL BUDGET THRU -7 PROJECTitk BUDGET THRU REMAINING PROJECT 2022/23 `REVISION` 2022/23 BALANCE COST t~.7+� URGES i (i �I � ''It'k�tiih,IM��:4Palii6jii�l`�ar 4e�r wc.:$,i�3t7,r�.,f'�:e,...?a.. i� "' xr.,x.��.sc Caw€.=FUNDIN„ 0 � d � Reserves $445,000 O r!q $445,000 $0 $445,000 0 0 0 $0 1 0I 111 V,Ih { 0 0 $0 0 A '5 d ly .0W 0 0 $0 0 0 $0 1IP �q�lon��p', Total $445,000 $445,000 $0 $445,000 PROJECT'EXPENDITU,RES n A. : r �. :° y, .x n Professional Services $0 `" , $0°' $0 $0 $0 Engineering/Design 0 ''1m , 0 0 0 $0 Land/ROW Acquistion 0 0 0 $0 Construction 445,000 "ry ' 0 445,000 0 $445,000 Other 0 '�fl'r g� � 0, 0 0 $0 Total $445,000 `.1 0.41gA1di1oP C$0, $445,000 $0 $445,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 45 of 101 Utility Capital Projects 24"Wastewater Main Replacement UT2004 PROJECT DESCRIPTION&JUSTIFICATION This project is for the replacement of the 24 inch wastewater main running from the Fort Worth meter station to just south of Holland Dr.This project will include replacement of roughly 2400 linear feet of reinforced concrete pipe, replacement of seven manholes, and will require bypass pumping during construction. The pipe material used for this pipeline was reinforced concrete pipe. Due to three major collapses in the last three years,with the two that most recently occurred staff was able to inspect this section of pipeline. Staff was able to verify that the pipeline has significant deterioration due to hydrogen sulfide gas(H2S).H2S gas eats away at the portion of pipe that does not carry the wastewater flow(roughly 50%of the top portion of the pipe).With the gases attacking the top portion of pipe,this creates concern with this portion of pipe carrying the load bearing of earth. Once the pipe collapses,this causes a blockage in the pipeline resulting in a sanitary sewer overflow.The typical thickness of reinforced concrete pipe is between 2 and 3 inches. Staff was able to locate areas in the pipeline that had a thickness as low as a quarter of an inch.This is not just at isolated PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Project savings from UT2004 design($97,079)and construction($435,200)are requested to be transferred to the UT2206 engineering($114,450)and construction($417,829)budgets. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU • PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES, Certificates of Obligation $1,255,000 ieA($532,279) $722,721 $0 $722,721 0 0` 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $1,255,000 `'' 4532,279) $722,721 $0 $722,721 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 251,000 (97,079) 153,921 0 $153,921 Land/ROW Acquistion 0 0 0 0 $0 Construction 1,004,000 ' r (435,200) 568,800 0 $568,800 Other 0 0 0 0 $0 Total $1,255,000 ($532,279) $722,721 $0 $722,721 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 46 of 101 Utility Capital Projects 24"Wastewater Main Replacement UT2004 PROJECT DESCRIPTION&JUSTIFICATION This project is for the replacement of the 24 inch wastewater main running from the Fort Worth meter station to just south of Holland Dr.This project will include replacement of roughly 2400 linear feet of reinforced concrete pipe, replacement of seven manholes,and will require bypass pumping during construction. The pipe material used for this pipeline was reinforced concrete pipe. Due to three major collapses in the last three years,with the two that most recently occurred staff was able to inspect this section of pipeline.Staff was able to verify that the pipeline has significant deterioration due to hydrogen sulfide gas(H2S). H2S gas eats away at the portion of pipe that does not carry the wastewater flow(roughly 50%of the top portion of the pipe).With the gases attacking the top portion of pipe,this creates concern with this portion of pipe carrying the load bearing of earth.Once the pipe collapses,this causes a blockage in the pipeline resulting in a sanitary sewer overflow.The typical thickness of reinforced concrete pipe is between 2 and 3 inches. Staff was able to locate areas in the pipeline that had a thickness as low as a quarter of an inch.This is not just at isolated im PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION When closing out this project, an unresolved matter arose.This is to transfer the necessary funds($612)back into the project from Phase 2(UT2206)to resolve this. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU ' �PROJECT , .' BUDGET THRU REMAINING PROJECT 2022/23 ,REVISION;° 2022/23 BALANCE COST FUNDING SOURCES u Certificates of Obligation $722,721 ° R, $0� $722,721 $0 $722,721 Certificates of Obligation(UT2206) 0 612 0 $612 P L 0 °� , u 6� 0 0 0 $0 L 0 0 0 $0 ti 0 �9 � � 0 0 0 $0 4s Total $722,721 r,;$612,„ $723,333 $0 $723,333 PROJECT_EXPENDITURES e Professional Services $0 �m $0 $0 $0 $0 Engineering/Design 153,921 61„2 154,533 0 $154,533 Land/ROWAcquistion 0 .0; 0 0 $0 ry� Construction 568,800 0) 568,800 0 $568,800 Other � 0 �� Q? 0 0 $0 Total $722,721 A .$6 L2 $723,333 $0 $723,333 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 47 of 101 Utility Capital Projects Big Fossil Interceptor Rehabilitation UT2206 PROJECT DESCRIPTION&JUSTIFICATION Rehabilitate the 24 inch wastewater interceptor line from 3621 Holland St to 6029 Riviera Dr.The total distance of the interceptor rehabilitated would be 7,250 linear feet.The intent is to utilize a trenchless construction method to the greatest extent possible to rehabilitate this line,such as cured-in-place pipe(CIPP).The project includes three logical sections that could be completed as three distinct phases.The sections are:3621 Holland St to 3817 Diamond Loch W, 3817 Diamond Loch W to 6200 Glenview Dr, and 6200 Glenview Dr to 6029 Riviera Dr. This section of reinforced concrete pipeline was constructed in the early 1970's.A series of collapses in recent years led staff to inspect sections of this pipeline. Inspection revealed that the pipeline has significant deterioration due to hydrogen sulfide gas(H2S). H2S gas eats away at the portion of pipe that does not carry the wastewater flow(roughly 50%of the pipe,the top portion of the pipe).With the gases attacking the top portion of pipe, it can buckle under the weight of the ground above it, resulting in a pipe collapse, and causing a sanitary sewer overflow.The typical thickness of reinforced concrete pipe is between PROJECT STATUS ORIGINAL 2022/23 1 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Project savings from UT2004 design($97,079)and construction($435,200)are requested to be transferred to the UT2206 engineering($114,450)and construction($417,829)budgets. 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,510,000 $0 $2,510,000 $0 $2,510,000 Certificates of Obligation(UT2004) 0 532,279 532,279 0 $532,279 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $2,510,000 $532,279' $3,042,279 $0 $3,042,279 PROJECT EXPENDITURES Professional Services $0 = $0 $0 $0 $0 Engineering/Design 310,000 114,450 424,450 0 $424,450 Land/ROW Acquistion 0 0. 0 0 $0 Construction 2,200,000 ,�g° 417,829 2,617,829 0 $2,617,829 Other 0 0 0 0 $0 Total $2,510,000 $532,279 $3,042,279 $0 $3,042,279 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 48 of 101 Utility Capital Projects Big Fossil Interceptor Rehabilitation UT2206 PROJECT DESCRIPTION&JUSTIFICATION Rehabilitate the 24 inch wastewater interceptor line from 3621 Holland St to 6029 Riviera Dr.The total distance of the interceptor rehabilitated would be 7,250 linear feet.The intent is to utilize a trenchless construction method to the greatest extent possible to rehabilitate this line,such as cured-in-place pipe(CIPP).The project includes three logical sections that could be completed as three distinct phases.The sections are:3621 Holland St to 3817 Diamond Loch W,3817 Diamond Loch W to 6200 Glenview Dr, and 6200 Glenview Dr to 6029 Riviera Dr. This section of reinforced concrete pipeline was constructed in the early 1970's.A series of collapses in recent years led staff to inspect sections of this pipeline. Inspection revealed that the pipeline has significant deterioration due to hydrogen sulfide gas(H2S). H2S gas eats away at the portion of pipe that does not carry the wastewater flow(roughly 50%of the pipe,the top portion of the pipe).With the gases attacking the top portion of pipe, it can buckle under the weight of the ground above it, resulting in a pipe collapse,and causing a sanitary sewer overflow.The typical thickness of reinforced concrete pipe is between PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION When closing out Phase 1 of this project(UT2004), an unresolved matter arose.This is to transfer the necessary funds($612) back into the project to resolve this. 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,510,000 ;;• ;• $0 $2,510,000 $0 $2,510,000 Certificates of Obligation(UT2004) 532,279 (612) 531,667 0 $531,667 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $3,042,279 ($612) $3,041,667 $0 $3,041,667 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 424,450 . 0 424,450 0 $424,450 Land/ROW Acquistion 0 0 0 0 $0 Construction 2,617,829 (612) 2,617,217 0 $2,617,217 Other 0 ° 0 0 0 $0 Total $3,042,270 ($612) $3,041,667 $0 $3,041,667 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 49 of 101 Utility Capital Projects Cellular Meter Reading Project UT2304 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 4,000 meters that 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. Funding Source: $4,855,500 from Utility Revenue Bonds. Funding will also include UT2103 and UT2203-$800,000 for the first year of the project. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Funds from UT2103($315,679)and UT2203($400,000)are being moved over to this project so that they can be closed out, as this project is a continuation of those. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU °"PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Utility Revenue Bonds $4,855,500 ;;�� $0` $4,855,500 $0 $4,855,500 Project Savings(Utility Fund 410) 0 w"'' 715,679 715,679 0 $715,679 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $4,855,500 '7` .$715,679' $5,571,179 $0 $5,571,179 PROJECT EXPENDITURES " Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 d $0 Construction 4,855 500 =" 7115,679" 5,571,179 0 $5,571,179 Other 0 0 0 0 $0 Total $4,855,500 $715,679' $5,571,179 $0 $5,571,179 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 50 of 101 Utility Capital Projects Telemetric Water Meter Annual Maintenance(2022) UT2203 PROJECT DESCRIPTION&JUSTIFICATION The City's network of water meters is comprised of a mix of older mechanical displacement meters, along with newer ultrasonic meters. In addition to the meters themselves, each service location also includes a register and transponder,which make up the reading/communications piece of the water service equipment.The Telemetric Water Annual Maintenance Program allows the City to replace system components to improve available usage data, reading capability, and reading accuracy. This program allows the City to replace transponders, registers and meter units that were installed since the program's inception in 1992-1993. Replacing older analog registers in conjunction with updated transponders will provide options for more detailed usage information for residential customers. Replacement of older displacement meters, particularly for 2"or larger service(typically commercial use)meters will improve reading accuracy of higher water consumers, reducing unbilled water usage and lost revenue.This program will prevent the unnecessary loss of revenue due to inaccurate and inadequate metering and reading equipment and helps the department to maintain accountability for the water distribution system. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Remaining funds are being moved from this project to the UT2304 Cellular Meter Reading project so that UT2203 can be closed out. FINANCIAL DATA ADOPTED i= � r�b REVISED TOTAL BUDGET THRU +,PRrO'JECT '4t BUDGET THRU REMAINING PROJECT 2022/23 .. 'REVISION 2022/23 BALANCE COST FUNDING SOURCES, � q � � : „ . dRk 2� &�.:' na.,,."fi^'.i s.+=Fm YN �b�a-p�"'�a5.�_, nhµ h41�'(0 '-.> i w'"6P1 a.� Reserves(Utility Fund 410) $400,000 f'" =($40Q,000)" $0 $0 $0 o a 0 0 0 $o 0 040414,1r0 0 0 $0 0 ''rya5E0 0 0 $0 0 ,yJ .q '40 0 0 $0 Total $400,000 '`', ($400,000) $0 $0 $0 PROJECT'EXPENDITURES & lo'i'mr °," w'u r di, $0 o ,$0 $0 $0 $0 Professional Services s Engineering/Design 0 1111' 1 ,0r 0 0 $0 Land/ROW Acquistion 00; 0 0 $0 Construction • 400 000 . �4,1,Gi(400 00,0) 0 0 $0 Other Q iiid� ��° ufi 0� 0 0 $0 Total $400,000 a`•" ($400,000) $0 $0 $0 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance.No.3804 Attachment B Page 51 of 101 Utility Capital Projects Telemetric Water Meter Annual Maintenance(2021) UT2103 PROJECT DESCRIPTION&JUSTIFICATION The City's network of water meters is comprised of a mix of older mechanical displacement meters,along with newer ultrasonic meters. In addition to the meters themselves,each service location also includes a register and transponder,which make up the reading/communications piece of the water service equipment.The Telemetric Water Annual Maintenance Program allows the City to replace system components to improve available usage data, reading capability, and reading accuracy. This program allows the City to replace transponders, registers and meter units that were installed since the program's inception in 1992-1993. Replacing older analog registers in conjunction with updated transponders will provide options for more detailed usage information for residential customers. Replacement of older displacement meters, particularly for 2"or larger service(typically commercial use)meters will improve reading accuracy of higher water consumers, reducing unbilled water usage and lost revenue.This program will prevent the unnecessary loss of revenue due to inaccurate and inadequate metering and reading equipment and helps the department to maintain accountability for the water distribution system. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Remaining funds are being moved from this project to the UT2304 Cellular Meter Reading project so that UT2103 can be closed out. FINANCIAL DATA ADOPTED n w`i REVISED TOTAL BUDGET THRU PROJECT = BUDGET THRU REMAINING PROJECT 2022/23 REVISI77 ON, � 2022/23 BALANCE COST to u;€ � x' r�i ° 4 ,20 F 3 �°w. -� ,i. llr AIM '� 4 - ri d FUNDING„SOURCES. ,a u ; ai�a , ,f L , is i a�l11S_I 4 .4 ., - , . _ (���ii� Nn,i n x Reserves(Utility Fund 410) $400,000 ; �($315 679)', $84,321 $0 $84,321 o 3` '0= 0 0 $0 0iii ' 'jai: 0;' 0 0 $0 0 � r,� r0I 0 0 so 0 �a,'�'„9n1o3'4iy 0 0 $0 Total $400,000 ($315,679) $84,321 $0 $84,321 P_ROJECTXPNDITURS >. 0, a,j�,min n'G ii , ,�` > '�.,n n a.�. _ �'�� �.. _ ��� , _. �' Professional Services $0 � �" $0: $0 $0 $0 Engineering/Design 0 0- 0 0 $0 Land/ROW Acquistion 0 a l 0= 0 0 $0 Construction 400 000 (315 679) 84,321 0 $84,321 Other 0 q 0,` 0 0 so Total I $400,000 ;'($315,679) $84,321 $0 $84,321 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 52 of 101 Utility Capital Projects Conn Pump Station Pump and Electrical Rehabilitaiton UT2008 PROJECT DESCRIPTION&JUSTIFICATION This project is to reconfigure existing suction header piping and pumps to meet the Hydraulic Institute standard for pipe pumping and to upgrade and reconfigure electrical components to meet the National Electric Code. Conn Pump Station provides potable water from the south of the city to just south of Mid-Cities Blvd.The pump station provides potable water and pressure to the distribution system through four pumps located on the site.Three of these pumps were replaced 6 years ago. Staff became aware of noticeable wear and tear on the pumps through inspections and failures. Freese and Nichols Engineering group was hired to conduct a piping analysis to determine the cause for the premature pump issues. Through this analysis, Freese and Nichols was able to determine that the pump issues were caused by the net positive suction head created by the piping alignment on the suction side of the pumps.The suction piping has a 90 degree bend located too close to the pump on three of the four pumps.The analysis also shows that the electrical panels will have to be moved to correct the alignment of the piping and to meet clearance requirements from the National Electric Code. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2019 05/2021 Land/ROW Acquisition Construction 09/2021 10/2024 Other REVISION EXPLANATION An amendment to the professional services contract was signed and executed to revise plans to include a generator. FINANCIAL DATA ADOPTED s,'u°�C iG REVISED TOTAL BUDGET THRU '" PROJE,CT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES ' �e _n. a s . �. `, fir a°_ ; j;Z , , ;'° Certificates of Obligation ' $1,500,000 ::,° ", $0 $1,500,000 $0 $1,500,000 Reserves 1,100 000 y , 1,100,000 0 $1,100,000 0 $0 0 _n 00 ofual0a 0 0 $o o x �� a �, �0 o o $o Total $2,600,000 �no r'$0:' $2,600,000 $0 $2,600,000 PROJECTEXPENDITURES I� x , 'b1:2 . .e. Professional Services $0 $0 $0 $0 $0 Engineering/Design 329,000 r� ' :34 000 363,000 0 $363,000 Land/ROW Acquistion 0 40; 0`: 0 0 $0 Construction 2,271 000 ' '1a Y� (34 000),` 2,237,000 0 $2,237,000 Other 0 0 0 0 $0 Total $2,600,000 'e�W', r°°$CP $2,600,000 $0 $2,600,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 _ 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 53 of 101 Utility Capital Projects Sewer Main Replacement-Lowery Lane UT2303 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 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION The design contract for this project came in higher than what was budgeted, so$26,120 is requested to be transferred from the construction budget to the engineering budget. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU ?4ROJECT d„' BUDGET THRU REMAINING PROJECT 2022/23 ;n REVISION, ���� 2022/23 BALANCE COST FUNDING sou RCES° ��._m� ea. Utility CIP Fund Reserves $275,000 ,'R$0; $275,000 $0 $275,000 0 $ 0 0 0 $0 0 ,,,Q, 0 0 $0 0 m t!^ 0 0 0 $0 0 wir;�����u�i � a0 0 0 $0 Total $275,000 $0, $275,000 $0 $275,000 PROJECT EXPENDITURES Professional Services $0 r $0 $0 $0 $0 Engineering/Design 50,000 26120d 76,120 0 $76,120 Land/ROW Acquistion 0 0 0 0 $0 Construction 225,000 �� w g (25,120) 198,880 0 $198,880 Other 0 0 pl idt i Y �'00 $0 Total $275,000 ^� � �,h `.' $0: $275,000 $0 $275,000 IMPACT ON OPERATING BUDGET No anticipated impact. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 54 of 101 Utility Capital Projects Walker Branch Interceptor Project UT1607 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 $4,393 is the agreed upon amount for the City to be granted a permanent sanitary sewer easement for this project. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT , BUDGET THRU REMAINING PROJECT 2022/23 :ll'REVISION 2022/23 BALANCE COST FUNDING;SOURCES a "'" "'G x w ;ii4 _, n. tiiN k'd' " ' '4 '; r;„ . t t Various $4,916,525 �, " i,$0 $4,916,525 $0 $4,916,525 0 0 0 0 $0 0 '" '' . '0 0 0 $0 0 $0 $0 Total $4,916,525 '$0 $4,916,525 $0 $4,916,525 Professional Services $0 $0. $0 $0 $0 Engineering/Design 421,631 0 421,631 0 $421,631 Land/ROW Acquistion 0 k ' 4,$9 ° 4,393 0 $4,393 Construction 4,494 894 � �^ (4,393} 4,490,501 0 $4,490,501 Other 0 0 0 $0 Total $4,916,525 $0 $4,916,525 $0 $4,916,525 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0, Ordinance No.3804 Attachment B Page 55 of 101 Parks & Recreation Capital Projects City Point Trail Development in Oncor Easement PK2207 PROJECT DESCRIPTION&JUSTIFICATION The Parks and Recreation Department is requesting to transfer$11,904.00 from PK2207:Construction to PK2207:Professional Services.This reason for this request is that additional funds are needed to encumber for professional services vendor, Aguirre&Fields. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services 10/2021 10/2022 Engineering Land/ROW Acquisition Construction 06/2022 06/2023 Other REVISION EXPLANATION Funds requested to be reallocated from PK2207:Construction to PK2207:Professional Services. FINANCIAL DATA ADOPTED Tx", r e r REVISED TOTAL BUDGET THRU BUDGET THRU REMAINING PROJECT 2022/23 Z, PREVISION 2022/23 BALANCE COST FUNDING;SOURCESu * ' V tJ a ri i,x'4 Day R ii'o ii'r i) Id ' pa P. 7'"711 p r ppi4 ,s Sales Tax $165,000 9 h '5iNS $0= $165,000 $0 $165,000 m 0 i ''° 0! 0 0 $0 s 0 410t i4k� a 0 0 0 $0 0 t1.0;- .gig V10; 0 0 $0 0 ,u r Va0; 0 0 $0 Total $165,000 Z$0 $165,000 $0 $165,000 PROJECTTEXPENDITURES ., ,-9:",'xa i1 „, P. x!'P'',o ,' - fi_ .n`rt:, eT 4 l'2i'm01 i.',43",i ;"-, n " n Professional Services $24,813 $ 1(904 $36,717 $0 $36,717 it Ql Engineering/Design 0 ,� „I ai, �jw 0 0 $0 Land/ROW Acquistion 0 ;� �ailN„o11'i e gpr 0 0 $0 dI'4w d ! i d 4 Construction 140,187 i ^2 (f. 904)° 128,283 0 $128,283 Other p ;iG " 0 0 0 $0 Total $165,000 t" ~$07. $165,000 $0 $165,000 IMPACT ON OPERATING BUDGET • ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 56 of 101 Parks & Recreation Capital Projects City Point Trail Development in Oncor Easement PK2207 PROJECT DESCRIPTION&JUSTIFICATION This project will provide for the design and construction of a 10'wide multi-use trail in the Oncor easement just west of the City Point development from Glenview Drive northward to an existing 6'wide residential pedestrian trail system adjacent to the City Point Phase 2 along Blvd 26. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services 10/2021 10/2022 Engineering Land/ROW Acquisition Construction 06/2022 09/2023 Other REVISION EXPLANATION This reallocation is requested to cover the increasing costs of construction on PK2207. Funds will need to be moved from PK2007 to PK2207. PK2007 is a completed project and will be closed out after these funds have been transferred. FINANCIAL DATA ADOPTED °""I REVISED TOTAL BUDGET THRU 'V PROJECT BUDGET THRU REMAINING PROJECT 2022/23 fief REVISION 4 2022/23 BALANCE COST FUNDING„SOURCES_w"' , , c *W,d ylll �riMii� _ .LG I. r.h,.. . r ' 1 tIGA51rlut qtwg4 1 l'W,fi'01:ti hw,,s e ei Park Sales Tax $165,000 log° , aW $0 $165,000 $0 $165,000 Park Impact Fee Reserves 0 , fifi°25,529 25,529 0 $25,529 0 ',5 u, u,0N0 0 0 $0 0 au fio 0 0 0 $0 0 0 0 0 $0 Total $165,000 i,b �,$25,529;" $190,529 $0 $190,529 II`N PROJ�T'EXPENQITURES ili r�"ems t, $36,717 4 a„,111�v * $0' $36,717 $0 $36,717 Professional Services ( 0 Engineering/Design 0 fiEi�4�'''ti�' 0 0 $0 Land/ROW Acquistion 0 ��; �'�,0' 0 0 $0 Construction 128,283 , ., 25,529 153,812 0 $153,812 Other 0 W0 ,° i 0 0 0 $0 Total $165,000 ZRa ;$25,529d $190,529 $0 $190,529 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 57 of 101 Parks & Recreation Capital Projects Cross Timbers Playground Replacement with Shade PK2202 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the replacement of the playground at Cross Timbers Park.The Parks and Recreation Department developed an Infrastructure Management Plan for park amenities which address long term funding needs for replacement and renovation of park sites and their amenities. Park assets are subject to continual heavy usage by citizens,exposure to the elements and natural aging process.The Asset Management Plan,and ongoing park inspections are used to identify assets that have become worn, unsafe or unsightly and to create a priority timeline for their repair, renovation or removal. The Cross Timbers playground was constructed in 2001,with the existing components. 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.The project funding source is Park Impact Fee Reserves(360)(North district). PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2022 10/2022 09/2023 09/2023 Other REVISION EXPLANATION Proposals for the Cross Timbers Park Playground Replacement with Shade project came in under budget because of the playground pod's smaller footprint. Because of unique design elements within the Dr. Pillow Park playground, a revision to the project budget is necessary to maintain a high level of play value and shade. FINANCIAL DATA ADOPTED j : ;,.der R41 REVISED TOTAL BUDGET THRU PROJECT, BUDGET THRU REMAINING PROJECT 2022/23 !l° REVISIION :, 2022/23 BALANCE COST iii -: WyIUI iD)�i�1� iivi, iCu ,g"�+;,"� ;a" tz Iiii�tai91W�5 �I( " •• x FUNDING',SOU,RCES'�F ��� A�� Reserves $230,000 .T.:--.`,,KY,-(:$38'060)1 $192,000 $0 $192,000 0 '` ** , , :10�, 0 0 $0 0 "�"P41,00:10o�1w0 0 0 $0 0 9111MiN�t;l is 0, 0 0 $0 0 0 0 $0 Total $230,000 x 11,($38,000) $192,000 $0 $192,000 J R hi Il.1i B �} .,:. „w«rr': �..„ `,m'a r ��1s'C i`hxu,.. .r ���,ia r*�'s••• n Professional Services $0 ¢$0 $0 $0 $0 Engineering/Design 0 Fe ��0 0 0 $0 Land/ROW Ac uistion 0 �; �P��1r;0 0 0 $0 q ut Construction 230,000 a � � y 38,000 ` 192,000 0 $192,000 Other p ��.h�p ,, � 0j, 0 0 $0 Total $230,000 y.«hy', ,($38,000);! $192,000 $0 $192,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected , $0 Ordinance No.3804 Attachment B Page 58 of 101 Parks & Recreation Capital Projects Dr. Pillow Park Playground Replacement with Shade PK2303 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the replacement of the playground at Dr. Pillow Park.The Parks and Recreation Department developed an Infrastructure Management Plan for park amenities which addresses long term funding needs for replacement and renovation of park sites and their amenities. Park assets are subject to continual heavy usage by citizens,exposure to the elements and natural aging process.The Asset Management Plan and ongoing park inspections are used to identify assets that have become worn, unsafe or unsightly and to create a priority timeline for their repair, renovation or removal. The Dr. Pillow Park playground was constructed in 2006 with the existing components.The proposed renovation project is intended to provide updated components to encourage physical activity through structured,safe and fun activities.The 2007 Parks, Recreation and Open Space Master Plan makes specific recommendations for playground renovations to construct structures to provide shade 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. Funding Source:$200,000 from Park Sales Tax(125)Reserves. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2022 10/2022 09/2023 09/2023 Other REVISION EXPLANATION Proposals for the Cross Timbers Park Playground Replacement with Shade project came in under budget because of the playground pod's smaller footprint. Because of unique design elements within the Dr. Pillow Park playground, a revision to the project budget is necessary to maintain a high level of play value and shade. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDINGSOURCES Reserves $200,000 • $38,000 $238,000 $0 $238,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $200,000 ,° $38,000 $238,000 $0 $238,000 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROWAcquistion 0 0 0 0 $0 Construction 200,000 38,000 238,000 0 $238,000 Other 0 0 0 0 $0 Total $200,000 $38,000 $238,000 $0 $238,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 59 of 101 Parks & Recreation Capital Projects Fossil Creek Mountain Bike Trail PK2007 PROJECT DESCRIPTION&JUSTIFICATION This project will provide for the development of mountain biking/hiking trails within Fossil Creek Park.The 58.5 acre park contains beautiful natural areas comprised of mature hardwood trees, a mixture of grasslands and riparian habitats,all of which are ideally suited to hiking and mountain biking. Project improvements include approximately 5 miles of trails serviced by a small parking lot and associated park usage signage. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services 01/2020 05/2020 Engineering Land/ROW Acquisition Construction 06/2020 05/2023 Other REVISION EXPLANATION This reallocation is requested to cover the increasing costs of construction on PK2207. PK2007 is a completed project and will be closed out after these funds have been transferred. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT 9 ;; BUDGET THRU REMAINING PROJECT 2021/22 `' REVISION °_.• 2021/22 BALANCE COST FUNDING SOURCE5 � .. ram , , ' ,�� ��. �, . . . Park Impact Fee Reserves $107,500 ($25 529) $81,971 $0 $81,971 0 ,; =0 0 0 $0 0 = , '= 0 0 0 $0 o n� ro; 0 0 $0 0 '" ° „ =,0" 0 0 $0 Total $107,500 dw"' ,($25,529) $81,971 $0 $81,971 PROJECT EXPENDITURES,w s$, +�M, d fil rf Professional Services $0 $0 $0 $0 $0 . ,4 0 Engineering/Design 0 0 0 $0no, Land/ROWAcquistion 0 r .° 0 0 0 $0 Construction 107,500 (25 529); 81,971 0 $81,971 Other 0 0' 0 0 $0 Total $107,500 ;`_ ,E($25,529), $81,971 $0 $81,971 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 60 of 101 Parks & Recreation Capital Projects Green Valley Raceway Historical Area PK1801 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the design and construction of an historical plaza adjacent to North Tarrant Parkway,east of Smithfield Road where the John Barfield Trail meanders through what once was the Green Valley Raceway. Proposed amenities include an attractive pedestrian and bicycle plaza with benches,trash receptacles and signage with information and photographs that celebrate the rich history of a bygone era in North Richland Hills. The Green Valley Raceway was a motorsports race track located in the area between North Tarrant Parkway and Green Valley Drive, immediately east of Smithfield Road.The race track opened in 1963 and was used for over 20 years as a permanent road course and drag strip until it closed on 1984. Remnants of the parking lot and drag strip still exist in this area.The story of the Green Valley Raceway is a reminder that North Richland Hills has a unique past that can be enjoyed by current and future generations. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 09/2017 07/2022 03/2023 Land/ROW Acquisition Construction 10/2022 03/2023 07/2023 Other REVISION EXPLANATION Due to increasing construction costs due to inflation and high demand, competitive sealed proposals received in January 2023 came in over budget. Staff negotiated a reduced project cost on a value engineered revision, but a budget revision is necessary in the amount$110,615. $25,000 will be transferred from Promotional Fund Reserves, and$85,616 from Park Impact Fee Reserved. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Reserves $30,717 = $0 $30,717 $0 $30,717 Sales Tax 30,000 0 30,000 0 $30,000 Other 95,000 0 95,000 0 $95,000 Promotional Fund Reserves 0 25,000 25,000 0 $25,000 Park Impact Fees 0 85,616 85,616 0 $85,616 Total $155,717 ' $110,616 $266,333 $0 $266,333 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 155,717 °�110,616 266,333 0 $266,333 Other 0 0 0 0 $0 Total $155,717 $110,616 $266,333 $0 $417,194 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 61 of 101 Parks & Recreation Capital Projects Green Valley Raceway Historical Area PK1801 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the design and construction of an historical plaza adjacent to North Tarrant Parkway, east of Smithfield Road where the John Barfield Trail meanders through what once was the Green Valley Raceway. Proposed amenities include an attractive pedestrian and bicycle plaza with benches,trash receptacles and signage with information and photographs that celebrate the rich history of a bygone era in North Richland Hills. The Green Valley Raceway was a motorsports race track located in the area between North Tarrant Parkway and Green Valley Drive, immediately east of Smithfield Road.The race track opened in 1963 and was used for over 20 years as a permanent road course and drag strip until it closed on 1984. Remnants of the parking lot and drag strip still exist in this area.The story of the Green Valley Raceway is a reminder that North Richland Hills has a unique past that can be enjoyed by current and future generations. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering 09/2017 07/2022 03/2023 Land/ROW Acquisition Construction 10/2022 03/2023 07/2023 Other REVISION EXPLANATION Additional funds are needed for construction material testing for the Green Valley Raceway Historical Area.The requested funding would come from PK2306-Cross Timbers Bleacher Shade Replacement. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Reserves $30,717 $7,500 $38,217 $0 $38,217 Sales Tax 30,000 0 30,000 0 $30,000 Other 95,000 0 95,000 0 $95,000 Promotional Fund Reserves 25,000 0 25,000 0 $25,000 Park Impact Fees 85,616 0 85,616 0 $85,616 Total $266,333 , _ $7,500 $273,833 $0 $273,833 PROJECT EXPENDITURES Professional Services $0 $7,500 $7,500 $0 $7,500 Engineering/Design 0 0 0 0 $0 Land/ROWAcquistion 0 0, 0 0 $0 Construction 266,333 ` •,, , 0 266,333 0 $266,333 Other 0 0 0 0 $0 Total $266,333 $7,500 $273,833 $0 $273,833 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 62 of 101 Parks & Recreation Capital Projects Cross Timbers Playground Replacement with Shade PK2306 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the removal and replacements of shade canopies on nine shade structures over selected bleachers at Cross Timbers Park. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2022 09/2023 Other REVISION EXPLANATION Funds are needed for construction materials testing at the Green Valley Raceway Historical Area.We are requesting a transfer from PK2306 to PK1801 in the amount of$7,500.00. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 'REVISION 2022/23 BALANCE COST FUNDING SOURCES Savings $45,000 -`. , ;($7,500),; $37,500 $0 $37,500 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 ` '` 0 0 0 $0 Total $45,000 �, _ .($7,500) $37,500 $0 $37,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 45,000 °- (7,500) 37,500 0 $37,500 Other 0 0 0 0 $0 Total $45,000 ' ($7,500) $37,500 $0 $37,500 IMPACT ON OPERATING BUDGET OPERATING IMPACT 2022/23 2023/24 _ 2024/25 2025/26 ANNUAL OPERATING TOTAL Projected __ $0 Ordinance No.3804 Attachment B Page 63 of 101 Aquatic Park Capital Projects General Facility Improvements (2023) WP2301 PROJECT DESCRIPTION&JUSTIFICATION This project consists of costs for annual facility improvements such as drainage improvements,miscellaneous building improvements, capital acquisitions,and and safety improvements or emergency repairs for the facility that are identified during the operating season. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2022 10/2022 09/2023 09/2023 Other REVISION EXPLANATION Revision of funds to align with actual use for Green Extreme Replacement Design and to allow for cost increases. $58,000 will be transferred from WP2301 into WP2305. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 ,=REVISIONI. 2022/23 BALANCE COST FUNDING;SOURCES Aquatic Park CIP Reserves(430) $100,000 $42,000 $0 $42,000 0 itIhaii:51iillip0, 0 0 $0 0a �; ";� � 0 0 0 $0 0 ", 4 4 p 191.1,,0 0 0 $0 0 ` 0 0 0 $0 Total $100,000 ,A$58,000)s $42,000 $0 $42,000 PROJECT EXPENDITURES �a � ;,; ya q: ' r : '. �aIIu�4. ��' $0 $0, $0 $0 $0 Professional Services �uPi�r� � �' ��+ Engineering/Design 0 � gyp, LM��� '��6i0 0 0 $0 Land/ROW Acquistion 0 . tPi A 0 0 0 $0 Construction 100,000 (5$,000): 42,000 0 $42,000 Other 0 b0 0 0 $0 Total $100,000 4-"'($58,000) $42,000 $0 $42,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 64 of 101 Aquatic Park Capital Projects NRH2O Attraction and Facilities Analysis WP2303 PROJECT DESCRIPTION&JUSTIFICATION This project serves to engage a professional services consultant to analyze existing water park attractions and facilities in order to aid in the planning and preparation for future renovations, replacements or additions as opportunities arise. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services 10/2022 10/2022 07/2023 07/2023 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Revision of funds to align with actual use for Green Extreme Replacement Design and to allow for cost increases. $75,000 will be transferred from WP2303 into WP2305. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGETTHRU ii PROJECT BUDGET THRU REMAINING PROJECT 2022/23 iEVISIOt+k, 2022/23 BALANCE COST FUNDING SOURCES ' Aquatic Park CIP Reserves(430) $85,000 "'$!Ititi11075,000 $10,000 $0 $10,000 0 dd' ,�����a � 0 0 0 $0 0 0 0 $0 0 n . 0' 0 0 $0 0 +§ 0 0 0 $0 Total $85,000 ($75,000) $10,000 $0 $10,000 Professional Services $0 �,ati�o'd,�i��i0�i9�'�"' �$0 $0 $0 $0 Engineering/Design 85 000a0,i�pp'(75,000)", 10,000 0 $10,000 Land/ROW Acquistion 0 0 0 $0 Construction 0 �' ,Zr �. 0 0 $0 Other r0� Total $85,000 ,r . 6 ($75;000) $10,000 $0 $10,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 _ 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 65 of 101 Aquatic Park Capital Projects Green Extreme Replacement Design and Construction WP2305 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. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services 10/2022 10/2022 09/2023 09/2023 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Revision of funds to align with actual use for Green Extreme Replacement Design and to allow for cost increases. $75,000 will be transferred from WP2303 into WP2305. $58,000 will be transferred from WP2301 into WP2305. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 - REVISION 2022/23 BALANCE COST FUNDING SOURCES, _ Aquatic Park CIP Reserves(430) $200 000s ,,$133,000 ry $333,000 $0 $333,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $200,000 $133,000� $333,000 $0 $333,000 PROJECT EXPENDITURES , Professional Services $0 ,$75,000 $75,000 $0 $75,000 Engineering/Design 200,000 0 200,000 0 $200,000 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 ` 58,000 58,000 0 $58,000 Other 0 0 0 0 $0 Total $200,000 $133,000 $333,000 $0 . $333,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 66 of 101 Aquatic Park Capital Projects Green Extreme Replacement Design and Construction WP2305 PROJECT DESCRIPTION&JUSTIFICATION The Parks and Recreation Department is requesting to transfer$58,000.00 from WP2305:Construction to WP2305: Professional Services.This reason for this request is that additional funds are needed to encumber for professional services vendor,Aquatic Design Group. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022123 START DATE REVISION END DATE REVISION Professional Services 10/2022 10/2022 09/2023 09/2023 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Funds requested to be reallocated from PK2207:Construction to PK2207:Professional Services. FINANCIAL DATA ADOPTED "r14 i 'u. 4 4 REVISED TOTAL BUDGET THRU 491bt PROJECTHROACirki. BUDGET THRU REMAINING PROJECT 2022/23 -, REVISIO44='- 2022/23 BALANCE COST FUNDING SOURCES :;, 1,1mr.V �,r Aquatic Park CIP Reserves(430) $333,000 $333,000 $0 $333,000 0 0; 0 0 $0 0 b{a I0 0 0 $0 0 44t 1,tl l i"r1 0.t 0 0 $0 �w A 0 ; 1tl 01 H01 0. 0 0 $0 Total $333,000 au's�,r� , $0 $333,000 $0 $333,000 PROJECT EXPENDITURESw ii�i vi'C dlili �0 i�I�i 6iyi�. �V � '` ..< _ ,. x Pam '���P k �,Nm Professional Services $275,000 a�,1 "T $58,000 $333,000 $0 $333,000 Engineering/Design 0 ri 0 0 0 $0 Land/ROW Acqu stion 0 ": "" 11;00 0 0 $0 Construction 58,000 (58,000Y 0 0 $0 Other • 0 8 �4� 0 0 $0 Total $333,000 VAIll,Mt$0 $333,000 $0 $333,000 IMPACT ON OPERATING BUDGET None ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 67 of 101 Aquatic Park Capital Projects Green Extreme Replacement Design and Construction WP2305 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 2022/23 ORIGINAL 2022/23 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 The FY2022-2023 budget funded design of a water-coaster attraction to replace the existing Green Extreme ride. City Council was briefed on a project analysis and slide manufacturer recommendation at the May 7,2023 City Council meeting. Funding in advance of the FY2023-2024 budget year is necessary in order to award a construction contract this summer and secure slide components in time for a summer 2024 ride opening. FINANCIAL DATA ADOPTED a x"" - REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES Reserves $333,000 $0 $333,000 $0 $333,000 Certificates of Obligation 0 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 $333,000 ... ... $5,400,000 $5,733,000 $0 $5,733,000 PROJECT EXPENDITURES Professional Services $75,000 - $0' $75,000 $0 $75,000 Engineering/Design 200,000 0 200,000 0 $200,000 Land/ROW Acquistion 0 0 0 0 $0 Construction 58,000 5,400,00C) 5,458,000 0 $5,458,000 Other 0 0' 0 0 $0 Total $333,0001 $5,400,000. $5,733,000 $0 $5,733,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 68 of 101 Municipal Facility Capital Projects PUBLIC LIBRARY LIGHTING CONTROLS FC2213 PROJECT DESCRIPTION&JUSTIFICATION The Public Library has an outdated lighting control program.This program controls both the interior and exterior lights ($77,500). The lighting control program is original to construction and no longer supported by the manufacturer. Should the system fail, the system would no longer control either the interior or exterior lighting.This project would provide a more user friendly system as well a be supported in the future should issues arise. Funding sources are comprised of$77,500 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2022123 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 10/2022 Other REVISION EXPLANATION This project was converted to FC2213A. FINANCIAL DATA ADOPTED ,°" REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES —�' ARPA Federal Grant $77,500 P" ($77,500); $0 $0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 ° 0 0 0 $0 Total $77,500 ($77,500) $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 77,500 , (77,500) 0 0 $0 Other 0 0 0 0 $0 Total $77,500 ($77,500) $0 $0 $0 IMPACT ON OPERATING BUDGET n/a ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 69 of 101 Municipal Facility Capital Projects Building Improvement Projects FC2302 PROJECT DESCRIPTION&JUSTIFICATION This project will consist of making routine building repairs to(5)city facilities.Those facilities include Public Works Service Center, Iron Horse Cart Barn,AARC, City Hall, and Fire Station#5. The work at the Service Center consist of repairing the ladder wire in the exterior mortar.The cart barn repairs will upgrade a restroom for staff.The AARC will repair the exterior kennels. City Hall repairs consist of painting, corner guards,door repairs and other miscellaneous items. Fire Station#5 will correct a drainage issue at the back patio. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2022 10/2022 12/2024 12/2024 Other REVISION EXPLANATION Additional scope has been added to the City Hall project. Dispatch will receive upgrades to the electrical, low voltage, and furniture. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES ARPA Federal Grant $72,500 "p= $77,500 $150,000 $0 1 $150,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $72,500 $77,500'' $150,000 $0 $150,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 72,500 77,500 150,000 0 $150,000 Other 0 , 0 0 0 $0 Total $72,500. $77,500 $150,000 $0 $150,000 IMPACT ON OPERATING BUDGET n/a ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 70 of 101 Street & Sidewalk Capital Projects Building Improvement Projects FC2302 PROJECT DESCRIPTION&JUSTIFICATION This project will consist of making routine building repairs to(5)city facilities.Those facilities include Public Works Service Center, Iron Horse Cart Barn,AARC, City Hall, Fire Station#5. The work at the Service Center consist of repairing the ladder wire in the exterior mortar.The cart barn repairs will upgrade a restroom for staff.The AARC will repair the exterior kennels. City Hall repairs consist of painting,corner guards,door repairs and other miscellaneous items. Fire Station#5 will correct a drainage issue at the back patio. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2022 12/2024 Other REVISION EXPLANATION FC2213A-$77,500, FC2208-$1,850, FC2209-$300, FC2210-$468, FC 2214-$3050, FC2215-$45 total=$83,213 FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES e ARPA $150,000 '$83,213 $233,213 $0 $233,213 0 0 0 0 $0 0 0 0 0 $0 0 ,u0 0 0 $0 0 0' 0 0 $0 Total $150,000 $83,213 $233,213 $0 $233,213 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 83213` 233,213 0 $233,213 Other 0 0 0 0 $0 Total $150,000 $83,213 $233,213 - $0 r $233,213 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 71 of 101 Street& Sidewalk Capital Projects Building Improvement Projects FC2302 PROJECT DESCRIPTION&JUSTIFICATION This project will consist of making routine building repairs to(5)city facilities.Those facilities include Public Works Service Center, Iron Horse Cart Barn,AARC, City Hall, Fire Station#5. The work at the Service Center consist of repairing the ladder wire in the exterior mortar.The cart barn repairs will upgrade a restroom for staff.The AARC will repair the exterior kennels. City Hall repairs consist of painting,corner guards,door repairs and other miscellaneous items. Fire Station#5 will correct a drainage issue at the back patio. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2022 12/2024 Other REVISION EXPLANATION Moving project savings from FC2212 to FC2302. Project is being closed. FINANCIAL DATA ADOPTED "� REVISED TOTAL BUDGET THRU ,' PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022123 BALANCE COST a n'�BniPi (h� ,�,FUNDI(�GSOURCESo, _.��r� � a�,�.�� ARPA $233,213 $242,233 $0 $242,233 0 A I?;,ra010t 0 0 $0 0 1r d� 'ald'k �,1'.0; 0 0 $0 0 1'!11000eO,, 0 0 $0 0 * 0. 0 0 $0 Total $233,213 : t $9,020 $242,233 $0 $242,233 PROJECTuEXPENDITURESw a, yili iid up 4 _, ,A ,. ., t y4; Lr �i"h r` ,r _. _". . �' s"... Professional Services $0 $0 $0 $0 Engineering/Design 0 w 0 0 $0 ���i�a�i n�to � Land/ROW Acquistion 0 "),,' IN 'tii 5'0! 0 0 $0 7'00Construction 233,213 � �huy0a°9,020 242,233 0 $242,233 Other 0 i;l'e r 0 0 0 $0 Total $233,213 'off .., .$9;020:, $242,233 $0 $242,233 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 72 of 101 Municipal Facility Capital Projects Building Improvement Projects FC2302 PROJECT DESCRIPTION&JUSTIFICATION This project will consist of making routine building repairs to(5)city facilities.Those facilities include Public Works Service Center, Iron Horse Cart Barn,AARC, City Hall, Fire Station#5. The work at the Service Center consist of repairing the ladder wire in the exterior mortar.The cart barn repairs will upgrade a restroom for staff.The AARC will repair the exterior kennels. City Hall repairs consist of painting, corner guards,door repairs and other miscellaneous items. Fire Station#5 will correct a drainage issue at the back patio. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2022 12/2024 Other REVISION EXPLANATION Moving($3,000)from FC2302 Building Improvement to FC2301 Carpet Replacement. • FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU 'PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES., ARPA Grant $242 233 '($3,000) $239,233 $0 $239,233 0 s,'„ 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $242,233 ,($3,000) $239,233 $0 $239,233 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 242,233 (3,000), 239,233 0 $239,233 Other 0 0., 0 0 $0 Total $242,233 ($3,000) $239,233 $0 $239,233 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 73 of 101 Municipal Facility Capital Projects Building Improvement Projects FC2302 PROJECT DESCRIPTION&JUSTIFICATION This project will consist of making routine building repairs to(5)city facilities.Those facilities include Public Works Service Center, Iron Horse Cart Barn,AARC, City Hall, Fire Station#5. The work at the Service Center consist of repairing the ladder wire in the exterior mortar.The cart barn repairs will upgrade a restroom for staff.The AARC will repair the exterior kennels. City Hall repairs consist of painting, corner guards,door repairs and other miscellaneous items. Fire Station#5 will correct a drainage issue at the back patio. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2022 12/2024 Other REVISION EXPLANATION Roll project savings from FC2211 -$300 FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES ARPA Grant $239,233 °' $300. $239,533 $0 $239,533 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0° 0 0 $0 Total $239,233 , $300 $239,533 $0 $239,533 PROJECT EXPENDITURES Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 „_ Q 0 0 $0 Construction 239,233 300. 239,533 0 $239,533 Other 0 0 0 0 $0 Total $239,233 $300 $239,533 $0 $239,533 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 _ 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 74 of 101 Municipal Facility Capital Projects Public Library HVAC Replacement FC2314 PROJECT DESCRIPTION&JUSTIFICATION This project includes replacing the(9) Roof Top Units(RTU's)at the Public Library and upgrading the building management system (BMS). These units have been in operation for approximately 15 years and are original to construction.The service requests continue to increase due to the age of the units. Replacing the units will improve the indoor air quality and operations'efficiency and reduce electrical consumption.The desk top building management system for these units will also be upgraded to a more user friendly web based program. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2022 12/2022 09/2023 12/2024 Other REVISION EXPLANATION Additional funding needed to purchase the labor, material, and equipment. Bids received were higher than anticipate during the budgeting process. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES ` Federal-ARPA 21.027(GRARP21) $600,000 'i $150 000 $750,000 $0 $750,000 0 0 0 0 $0 0 0 0 0 $0 0 :. 0 0 0 $0 0 ; .' : ° 0 0 0 $0 Total $600,000 $150,000 $750,000 $0 $750,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 600,000 .`150,000r 750,000 0 $750,000 Other 0 0 0 0 $0 Total $600,000 $150,000 $750,000 $0 $750,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 75 of 101 Street& Sidewalk Capital Projects Public Library Lighting Controls FC2213A PROJECT DESCRIPTION&JUSTIFICATION The Public Library has an outdated lighting control program. This program controls both the interior and exterior lights ($77,500). The lighting control program is original to construction and no longer supported by the manufacturer. Should the system fail, the system would no longer control either the interior or exterior lighting. This project would provide a more user friendly system as well as be supported in the future should issues arise. Funding sources are comprised of$77,500 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION This is the reconstituted FC2213 that was erroneously closed in Munis. Due to the inability to reopen a closed project in Munis, the project was recreated as FC2213A. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES ARPA $0 . :$771500, $77,500 $0 $77,500 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $0 $77,500' $77,500 $0 $77,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 077,500 77,500 0 $77,500 Other 0 0 0 0 $0 Total $0 $77,500 $77,500 $0 $77,500 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 76 of 101 Municipal Facility Capital Projects Public Library Lighting Controls FC2213A PROJECT DESCRIPTION&JUSTIFICATION The Public Library has an outdated lighting control program.This program controls both the interior and exterior lights. The lighting control program is original to construction and no longer supported by the manufacturer.Should the system fail, the system would no longer control either the interior or exterior lighting.This project would provide a more user friendly system as well as be supported in the future should issues arise. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 04/2023 Other REVISION EXPLANATION Moving funds from FC2213A to FC2302. Project is being closed. FINANCIAL DATA ADOPTED 4P-' REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES ARPA Grant $77,500 sp ..($77;500)` $0 $0 0 0 0 0 $0 0 0 0 0 $0 0 r r0 0 0 $0 0 Ord„ ,. 0 0 0 $0� Total $77,500 ($77,500) $0 $0 $01 PROJECT EXPENDITURE S - R_ Professional Services $0 $0fi $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 77,500 ' �(77500), 0 0 $0 Other 0 0 0 0 $0 Total $77,500 ($77,500) $0 $0 $0 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 77 of 101 Municipal Facility Capital Projects 5301 Davis Blvd Abatement and Demolition FC2315 PROJECT DESCRIPTION&JUSTIFICATION This request is to demo the building located at 5301 Davis Blvd. This project would include abatement,site monitoring,demolition, reporting to the State of Texas at 5301 Davis. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 03/2023 12/2024 Other REVISION EXPLANATION Budget amendment for appropriating the ARPA projects discussed during Council Retreat. FINANCIAL DATA ADOPTED girk,09'6;41,FE,Via REVISED TOTAL BUDGET THRU 1y��o,R PROflJECTti BUDGET THRU REMAINING PROJECT 2022/23REVISION . 2022/23 BALANCE COST FUNDING'SOUR,CES'i tlu$". .ta 6piiP ' N ,„r3a,. ;"�> na.M 1iDil .'."rL« kia!9i.a a '6I'i;IhluPi j�iiur. t {w, w" _ yiµ re Federal-ARPA 21.027(GRARP21) $0 "'';l,�if'$1�45 000` $145,000 $0 $145,000 0 Ra 01: 1�''0 0 0 $0 0 SAS, t.rzr dw!'v h0,, so 0 0 0 $0 0 $ 0 0 0 $0 K>k Total $0 J p °:$145,000: $145,000 $0 $145,000 PROJECTiEVENDITURESAiNtZ Professional Services $0 $0 $0 $0 $0 0; 0 0 $0 Engineering/Design O Land/ROW Acquistion 0 p s - 0 0 $0 Construction 0 011 6�145,000 145,000 0 $145,000 Other ���a";a'����4 l�i�`0 0 0 0 Total $0 ";'",$145,000„;, $145,000 $0 $145,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 78 of 101 Municipal Facility Capital Projects ARPA-5301 Abatement and Demolition FC2315 PROJECT DESCRIPTION&JUSTIFICATION This request is to purchase,demolish,and abate the building located at 5301 Davis Blvd. This project would include abatement,site monitoring,demolition,reporting to the State of Texas at 5301 Davis. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 04/2023 12/2024 Other REVISION EXPLANATION Budget amendment for appropriating the ARPA projects discussed during Council Retreat FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT ={, BUDGET THRU REMAINING PROJECT 2022123 REVISION 2022/23 BALANCE COST FUNDING SOURCES _.. Federal-ARPA 21.027(GRARP21) $0 $1,640,877 $1,640,877 $0 $1,640,877 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $0 $1,640,877' $1,640,877 $0 $1,640,877 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 145,000 145,000 0 $145,000 Other 0 1,495,877 1,495,877 0 $1,495,877 Total $0 $1,640,,877; $1,640,877 $0 $1,640,877 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 _ 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 79 of 101 Municipal Facility Capital Projects Library Public Furniture Replacement Project FC2316 PROJECT DESCRIPTION&JUSTIFICATION PROJECT DESCRIPTION: The purpose of this grant project is to replace the furniture in all the public service areas of the Library.This grant will pay for computer carrels, computer chairs, public lounge seating,study tables and carrels, chairs for study tables and carrels, and furniture for the children's area. PROJECT JUSTIFICATION: The Library's public furniture is currently 15 years old. Entering the pandemic,the furniture was was 12 years old and already showing great wear. During the pandemic the Library adhered to a strictly regimented cleaning schedule using a strong anti-viral cleaner, and as a result the remaining finish on all the furniture was severely damaged and the wooden and plastic parts of all the furniture are rapidly deteriorating. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 03/2023 12/2024 Other REVISION EXPLANATION Budget amendment for appropriating ARPA projects per discussion at City Council budget retreat FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES s � �, °` : F": a a Federal-ARPA 21.027(GRARP21) $0 '1 f$711,000, $711,000 $0 $711,000 0 °< 0 0 0 $0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $0 ,,i4:1''$711,000' $711,000 $0 $711,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 ' `711,"000! 711,000 0 $711,000 Other 0 0 0 0 $0 Total $0 $711,000 $711,000 $0 $711,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 80 of 101 Municipal Facility Capital Projects City HaII/AARC -Security Upgrade FC2317 PROJECT DESCRIPTION&JUSTIFICATION This request is install additional security features to several City Hall departments and the AARC. Additional construction including glass,counter tops,sheet rock, painting,etc. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 03/2023 12/2024 Other REVISION EXPLANATION Budget amendment for appropriating the ARPA projects discussed during Council Retreat. FINANCIAL DATA ADOPTED 1,iIt,MF REVISED TOTAL BUDGET THRU �, rPPROJEC`T BUDGET THRU REMAINING PROJECT 2022/23 e PREVISION, ;=" 2022/23 BALANCE COST "e i21IIGi l l n _ err Niollilii iiP jiv 11 Aa.� a _ .' X * .. $ 6 r FUd[DtlG,SOURCES �� q Federal-ARPA 21.027(GRARP21) > ' $250,000a $250,000 $0 $250,000 0 411 «� x0 0 0 $0 0 adrlif g« �01 0 0 $0 0p-t041100 0 0 $0 0 00,014 i4'1„ iti40 0 0 $0 Total $0 , rti6wi .$250,000`: $250,000 $0 $250,000 PROJECT EXPENDITURE,.F a iid'; yt ;,!;.v .. . aaa i' gi r fiiii m._ i4"* Professional Services $0 $0 $0 $0 Engineering/Design 0x 0% 0 0 $0 Land/ROW Acquistion 0 ' �0 0 0 $0 Construction 0 1,064450M00ii 250,000 0 $250,000 Other 0 a' l'0, 0 0 $0 Total $0 ¢,G r,$250,000> $250,000 $0 $250,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 81 of 101 Municipal Facility Capital Projects ARPA-City Hall/AARC -Security Upgrade FC2317 PROJECT DESCRIPTION&JUSTIFICATION This request is install additional security features to several City Hall departments and the AARC. Additional construction including glass,counter tops, sheet rock, painting,etc. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 04/2023 12/2024 Other REVISION EXPLANATION Budget amendment for appropriating the ARPA projects discussed during Council Retreat. FINANCIAL DATA ADOPTED .. REVISED TOTAL BUDGET THRU ' PROJECTx BUDGET THRU REMAINING PROJECT 2022/23 ;"`REVISIOPC'� 2022/23 BALANCE COST FUNDING,SOU CES`= Federal-ARPA 21.027(GRARP21) 'r $210,000 $210,000 $0 $210,000 0 0` 0 0 $0 0 ;;ti q tk" 0: 0 0 $0 0 0 0 $0 0 0' 0 0 $0 Total $0 ::`$210,000 $210,000 $0 $210,000 PROJECT EXPENDITURES 'u� a �� , y G: � , ; ... Professional Services $0 $Of, $0 $0 $0 4F Engineering/Design 0 n < < ' ''0` 0 0 $0 Land/ROW Acquistion 0 . � 0 0 0 $0 Construction 0 j,!;;;'; 210,000` 210,000 0 $210,000 Other 0 oy�9ia� k �,0 0 0 $0 Total $0 46 1,m$210,000 $210,000 $0 $210,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 82 of 101 Municipal Facility Capital Projects Carpet Replacement FC2301 PROJECT DESCRIPTION&JUSTIFICATION This project is to replace carpet at(4)city facilities.Those facilities include City Hall vestibules,Jail Control, Fire Station#1, and Fire Station#4. The carpeting at these(4)facilities are high usage and are at the end of life.The carpet is proposed to be changed to with new material designed for these high usage areas. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2022 12/2024 Other REVISION EXPLANATION Additional funds needed to complete entire scope of work. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 2 REVISION 2 2022/23 BALANCE COST FUNDING SOURCES Grant $77,500 :$3 000 $80,500 $0 $80,500 0 ~ ',°0" 0 0 $0 0 x& 0 0 0 $0 0 ro 0 0 $o 0 0 $0 Total $77,500 ''$3,000 $80,500 $0 $80,500 PROJECT EXPENDITURESri Professional Services $0 $0; $0 $0 $0 r '� Engineering/Design 0 �r 0� 0 0 $0 Land/ROW Acquistion 0 U �0 0 0 $0 Construction 77,500 ' ' ���i��i �`�3,000„ 80,500 0 $80,500 Other 0 � ' �� w0,� 0 0 $0 Total $77,500 ,.; _ w,$3,000;; $80,500 $0 $80,500 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 83 of 101 Municipal Facility Capital Projects Public Works Pump Station -Building Repairs FC2208 PROJECT DESCRIPTION&JUSTIFICATION This project consist of building repairs to(5)Public Works pump stations. The repairs consist of routine building repairs normally conducted by Facilities and Construction.The repairs are for the following(5)locations: College Hills,Johnson, Conn,Stanley-Keller,and Watauga pump stations. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 04/2023 Other REVISION EXPLANATION Moving project savings from FC2208 to FC2302. Project is being closed. FINANCIAL DATA ADOPTED a�°�i�0 " „" REVISED TOTAL BUDGET THRU *ATEROJECTyi ; BUDGET THRU REMAINING PROJECT 2022/23 a ii"REVI0ION1d> 2022/23 BALANCE COST FUNDIIdGrSOUF�CE$olniiilw�� a,r. i ��i�� �willi�i��ho>�'al6�.a a 9uikahlu0il'�,i4, ��`°,r .�?a��� a, I�IaGilv~a� �" !>� � ,e..,�tia. ARPA Grant $97,650 h ,'"i1$ 850 $95,800 $0 $95,800 0 fl F '4 0'° 0 0 $0 0 i,' z11„ ag„0 0 0 $0 0 rpm 0 0 $0 0 0 0 $0 Total $97,650 `, ` ($j1,850)i $95,800 $0 $95,800 Professional Services $0 CHI .&AITMaN iO $0 $0 $0 $0 Engineering/Design 0 '�"4l4iaiiil�a ilS4 0�, 0 0 $0 Land/ROW Acquistion 0 �a 4�8 0� 0 0 $0 Construction 97,650 r (= ,850)� 95,800 0 $95,800 Other a - 4 0 0 0 $0 Total $97,650 47 .;($1,850)"; $95,800 $0 $95,800 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 84 of 101 Municipal Facility Capital Projects Interior/Exterior painting FC2209 PROJECT DESCRIPTION&JUSTIFICATION This project consist of interior and exterior painting at several city facilities. Public Works Service Center awnings($4,000), Interior Fire Station#1, Interior Fire Station#4, Interior Fire Station#3, Exterior FD/PD Training Center, and Exterior Fire Station#3. Paint at the Fire Stations and Service Center have begun to fail due to either exposure of the elements, normal wear and tear or the facilities age.This project will re-coat the surfaces and bring the appearance of each facility up to acceptable standards. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 04/2023 Other REVISION EXPLANATION Moving project savings from FC2209 to FC2302. Project is being closed. FINANCIAL DATA ADOPTED F,q �'k REVISED TOTAL BUDGET THRU ` PROJECT F BUDGET THRU REMAINING PROJECT 2022/23 'e" REVISION 2022/23 BALANCE COST FUNDIIN;GSOURCES ' tlPw°I;'e II ii oiiui "I ".:i6@riCii i 9 "` .. x " 6 d. o,."';,',m ARPA Grant $71,000 1($300)y $70,700 $0 $70,700 0 `~` = , 0, 0 0 $0 0 ,{€ r0.,, 0 0 $0 0 0 0 0 $0 0 $0 Total $71,000 ._ : °�($300)T $70,700 $0 $70,700 Professional Services $0 m $0 $0 $0 $0 Engineering/Design 0 ti' 0' 0 0 $0 Land/ROW Acquistion 0 ;? 0 0 0 $0 Construction 71,000 ir 4(300); 70,700 0 $70,700 Other 0 ��4ir yfl ,� �" 0 0 $0 Total $71,000 �;?� �„ �($300)",'=; $70,700 $0 $70,700 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 85 of 101 Municipal Facility Capital Projects Bathroom flooring replacement FC2210 PROJECT DESCRIPTION&JUSTIFICATION This projects consists of replacing the floor coverings at Fire Station#3 and Fire Station#2. The floor coverings at both of these fire stations have begun to fail.We propose to grind off the existing flooring materials and replace with coverings that will work better in a restroom environment. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 04/2023 Other REVISION EXPLANATION Moving project savings from FC2210 to FC2302. Project is being closed. FINANCIAL DATA ADOPTED Q'�+a a REVISED TOTAL BUDGET THRU PROJECT ' BUDGET THRU REMAINING PROJECT 2022/23 r2iiREVISIONN*° 2022/23 BALANCE COST ARPA Grant $12,300 F;i U,,406 ($488) $11,832 $0 $11,832 0 0 $0 0 104,;; AR aIOl 0 0 $0 0 0 0 0 0 $0 Total $12,300 ;ifi A$468)_ $11,832 $0 $11,832 Fw _ r "� @ ' i a, §w u�i6, PI,tOJECT EXPEN4lTURFS. _. .� _ 7..�irlL �..�. .4, 5 .���'n "�_ ,w,.�.bZ dm����.,, , .m �e,�`�4,� d',m Professional Services $0 �` �� �$0, $0 $0 $0 1. © 0 0 $0 Engineering/Design 0 � � ., Land/ROW Acquistion 0 � 0 0 0 $0 Construction 12 300 ' (468)' 11,832 0 $11,832 Other Total $12,300 ($ 68) $11,832 $0 $11,832 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 _ 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 86 of 101 Municipal Facility Capital Projects 9KVA UPS for Distributed Antenna System FC2212 PROJECT DESCRIPTION&JUSTIFICATION This project is to add an existing UPS, uninterrupted power supply,to the DAS,distributed antenna system at City Hall. Currently when City Hall experiences an ONCOR power outage the equipment that provides first responders radio communications in the building shuts down and has to reboot.Adding an existing UPS will bridge the power needed by the radio equipment and will not have to be rebooted. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 04/2023 Other REVISION EXPLANATION Moving project savings from FC2212 to FC2302. Project is being closed. FINANCIAL DATA ADOPTED a , r44; REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 `: REVISION i 2022/23 BALANCE COST FUNDING SOURCESy iyVI I' I If;,'I D iii:RMRI' 'AIVAMni' gi+i < ARPA Grant $20,000 1($9,020),, $10,980 $0 $10,980 0 to'^^i` f, 0 0 0 $0 0 ,? 0 leoritl.F4fgli 0 0 $0 0 e<��;lit s} 0. 0 0 $0 Total $20,000 ?" "';,T($9 020) $10,980 $0 $10,980 PROJECT`EXPENDITURES 54dk;,!Pp6 4 iw -gY,Z a II"i tiiF, n Professional Services $0 �� �� r $0 $0 $0 $0 Engineering/Design 0 114.4,:'''.2.47-<*f-k'LO; 0 0 $0 0 aii�J" i t "P 0`i 0 0 $0 Land/ROW Acquistion iy < » Construction 20,000 !!1.$0,t0t9,020Y 10,980 0 $10,980 Other 0 "I , 0,e 0 0 $0 Total $20,000 , NIOR;($9,020)„ $10,980 $0 $10,980 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 87 of 101 Municipal Facility Capital Projects Custodial/Overhead Door Repairs FC2214 PROJECT DESCRIPTION A JUSTIFICATION This project will provide additional funding for custodial equipment and overhead door maintenance. The custodial equipment is used for maintenance and disinfection at city facilities.Additional funding will allow us to replace equipment that is at the end of life.Overhead doors are a high usage item.We perform routing preventative maintenance but parts wear and break.This additional funding will help with our aging doors. • PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 04/2023 Other REVISION EXPLANATION Moving project savings from FC2214 to FC2302. Project is being closed. FINANCIAL DATA ADOPTED 01i2wa I REVISED TOTAL BUDGET THRU °a•PROJECT BUDGET THRU REMAINING PROJECT 2022/23 r REVISION ,- 2022/23 BALANCE COST FUND[NG•,SOURCES. . . "' �� . _ ' 1� .• � r.��e�w,4 �i� .r ,�-.. ARPA Grant $6,000 ;y= '","VA($ $2,950 $0 $2,950 0 4-44adl� em0; 0 0 $0 0 P 40Pjfi iii0p 0 0 $0 0 ? tr° *0! 0 0 $0 1 S4 98 0 14{1U 0 0 $0 Total $6,000 !r ($3,050) $2,950 $0 $2,950 PROJECT�EXPENDITURE5,iio o�Mhikae' _ =� '� �" i � i'ud "� 3 9U;d u h h' ii iT i 'u ,s r bza�_�x.a Professional Services $0 40°b�^ $0 $0 $0 $0 Engineering/Design 0 ' ��id", � 0' 0 0 $0 Land/ROW Acquistion • 0 �� b 0' 0 0 $0 Construction 6,000 :41 (30,050) 2,950 0 $2,950 Other 0 a PO 0 0 $0 Total $6,000 A iV, ,($:3,050) $2,950 $0 $2,950 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 88 of 101 Municipal Facility Capital Projects Equipment Replacement and Floor Drain FC2215 PROJECT DESCRIPTION&JUSTIFICATION This project consist of replacing icemakers at Fire Stations#2 and Fire Station#3 and a floor drain at Fire Station#5. The ice makers are at the end of life.They are to be replaced with new units that are more energy efficient.The floor drain is temporarily repaired.The permanent fix will require removal of concrete and replacing existing cast iron sewer pipe. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 04/2023 Other REVISION EXPLANATION Moving project savings from FC2215 to FC2302. Project is being closed. FINANCIAL DATA ADOPTED �i��'a�� REVISED TOTAL BUDGET THRU "s PROJECTS BUDGET THRU REMAINING PROJECT 2022/23 `REVISION 2022/23 BALANCE COST vst. g a iM iI FUNDING�SOUi�CES, � �� �.*;�,e ,k. :.. F�+'un �S;S �. ARPA Grant $21,200 $21,155 $0 $21,155 0 m W4 r�f��04 0 0 $0 0 " .�"r t„ I'�0� 0 0 $0 0 .-- $ 414dd 0 0 $0 0 177'777: FE 0 0 0 $0 Total $21,200 d. "`Q($45)' $21,155 $0 $21,155 PROJECT<EXPENDITURES t .mow n' .. a ._, r ., n"' . i3 1I"'i13ur ' "mi:*§ r a "., , $0 r Professional Services ▪ $ $0 $0 $0 Engineering/Design 0 0� 0 0 $0 Land/ROWAcquistion 0 I ▪ 0 0 0 $0 Construction 21 200 �';,�����"� (45}' 21,155 0 $21,155 Other 0 � �11 " P1��u���� r.. 0� 0 0 $0 Total $21,200 P6,'g0'u'i ($45)3F $21,155 $0 $21,155 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 _ 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 89 of 101 Municipal Facility Capital Projects Public Library painting FC2211 PROJECT DESCRIPTION&JUSTIFICATION This project consist of repainting all of the public and staff areas of the Public Library. The Public Library recently had a full carpet replacement.This project is to repaint the interior public and staff areas.The paint is original to construction and beginning to show it's age.This repaint would upgrade the appearance of the library and compliment the recently installed carpet. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 01/2022 06/2023 Other REVISION EXPLANATION Moving project savings from FC2211 to FC2302. Project is being closed. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU x. PROJECT BUDGET THRU REMAINING PROJECT 2022/23 � REVISON 2022/23 BALANCE COST TN' 01` 'v. . ARPA Grant $132,000 ($300) $131,700 $0 $131,700 o #a: 0 0 $0 0 eu F ,„.�N 0 0 0 $0 0 1„ 0 0 0 $0 Total $132,000 ,{$300) $131,700 $0 $131,700 PROJECT EXPENDITURES a w `. , �' $0 Professional Services $0 $0 $0 $0' Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 °a, 1 , � �k 0 0 $0 Construction 132,000 ii4 1 (300)b 131,700 0 $131,700 Other0 0110$0,1NAPPQ0 Total $132,0000,,M11($300)1 $131,700 $0 $131,700 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 90 of 101 Major Capital Equipment Capital Projects Interview and Forensic Room Video/Digital Equipment IT2214 PROJECT DESCRIPTION&JUSTIFICATION This project is to refresh and increase the storage used to retain digital interviews. This is needed because the Isilon storage array was Purchased in 2017 and is no longer under mainstream support. Public safety is currently at 84%of the current storage capacity of 100Terabites.This will provide them more capacity and further protect the data from possible data corruption due to not having enough space. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2021 10/2022 09/2023 REVISION EXPLANATION Closing out project IT2215(Forensic Digital Evidence Storage)and merging it with project IT2214(Interview Room Video Storage Replacement). Update title for IT2214 to(Interview and Forensic Room Video/Digital Equipment) FINANCIAL DATA ADOPTED ' r ' "" REVISED TOTAL BUDGET THRUM PROJCI 'r��i BUDGET THRU REMAINING PROJECT 2022/23 _n VREVISION " J 2022/23 BALANCE COST FUNDING SOURCES uy .a. _`g "uHrJN;�I'IJ I� 1Mi y 'i ?a' !N a1 la 'bill h'iiJiuP4�'�i hG iNutn� ',,,liai4tlo fi%yp sw ° Crime Control District Fund 130 $150,000 150,000 $300,000 $0 $300,000 0 �� � �adlbi� f� � i i da� 0 0 $0 0 ti�i��a� l0yl 0 $0 0 1,a ooa'o' 0 0 $0 0 ;ma iN 40l 0 0 $0 aJ. Total $150,000 7,u -$150,000 $300,000 $0 $300,000 M i A P y�A 'uY' i q P,)FiOJEOT�XPENDITIJRESa �^��'� ��i�."a ,..�.5; ,J a5 P 1�.� " Professional Services $0 i 'li$f> $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 150,000 150 000. 300,000 0 $300,000 Total $150,000 lr `.'$150 000`- $300,000 $0 $300,000 IMPACT ON OPERATING BUDGET No operating budget impact expected. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 91 of 101 Major Capital Equipment Capital Projects Forensic Digital Evidence Storage IT2215 PROJECT DESCRIPTION&JUSTIFICATION This project is to refresh and increase the storage used to retain digital evidence in the Forensic Lab. This is needed because the Isilon storage array was Purchased in 2017 and will no longer be under mainstream support. Public safety has exceeded the current storage capacity of 24Terabites. PD has started offloading older investigation data to external hard drives.This provide them more capacity and further protect the data from possible data corruption,or having to handle digital evidence more than necessary. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2021 10/2022 09/2023 10/2022 REVISION EXPLANATION Closing out project IT2215(Forensic Digital Evidence Storage)and merging it with project IT2214(Interview Room Video Storage Replacement). • FINANCIAL DATA ADOPTED '1-- REVISED TOTAL BUDGET THRU !PROJECT BUDGET THRU REMAINING PROJECT 2022/23 eREVISION nr 2022/23 BALANCE COST FUNDING°SOURCES ° ", ' a a, i "-` Crime Control District Fund 130 $150,000 "'00($1150 000) $0 $0 $0 i r i ' �i 0 ire WI ��'!a''I `05 0 0 $0 0 fi"��r " ivy 0 0 0 $0 e 0 ' ja `04 0 0 $0 0 S ° x01 0 0 $0 Total $150,000 -a ($150;000), $0 $0 $0 PROJECT,EXPENDITU ES x in a Eiji a. 5.5' 4di iV i "r b Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 �P i"ii' � � 0 0 $0 6"N � Land/ROWAcquistion 0 0 0 $0� �i� ii�i�'�"��,0o- Construction 0 ; !e ,7' 40 0 0 $0 Other 150 000 "* m (150,000) 0 0 $0 Total $150,000 ,° a=($150,000) $0 $0 $0 IMPACT ON OPERATING BUDGET No operating budget impact expected. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 92 of 101 Other Capital Projects FD Freeway Blocking Truck FS2208 PROJECT DESCRIPTION&JUSTIFICATION This project is to purchase a crash attenuator truck for the Fire Department.The project currently is approved for$136,441. $109,152.80 is coming from the Traffic Incident Management(TIM)Council of Governments(COG)grant funding and $27,288.20 was from ARPA.Additional ARPA funds of$70,000 have been requested and approved for a total cost of the project being$206,441. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2021 10/2021 09/2022 12/2023 REVISION EXPLANATION 15+months post-grant application,the inflationary costs along with project scope changes have caused an increase in total project cost.The grant time line has taken longer than expected(due to State approvals)and therefore the end date has been extended to the end of 2023. FINANCIAL DATA ADOPTED "'° REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING°SOURCES ._: v„y 9R :_ _ .. ARPA $27,288 r°.$70,000 $97,288 $0 $97,288 TIM-COG 109,153 0 109,153 0 $109,153 0 0 0 0 $0 0 0' 0 0 $0 0 w 0 0 0 $0 Total $136,441 g $70,000' $206,441 $0 $206,441 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 ` A'° 0 0 $0 Other 136,441 70,000' 206,441 0 $206,441 Total $136,441 $70,000 $206,441 $0 $206,441 IMPACT ON OPERATING BUDGET ARPA funds will be used for purchase. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3804 Attachment B Page 93 of 101 Major Capital Equipment Capital Projects ERP SYSTEM REPLACEMENT IT1701 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 improve accountability. Project Status Update: Project is currently underway in year 2 of 3 for the implementation of the new ERP system. Project is anticipated to be completed by 2023. Note: FY 2016-2017 funding from Information Technology Reserves. 2018-2019 funding is Certificates of Obligation. FY 2018-2018 Funding from Information Technology Reserves. FY 2019-2020 Funding from General CIP Reserves(305)$204,448, IT Capital Project Fund Reserves (386)$221,000, and$75,000 from Information Technology Reserves(520). PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services 02/2018 03/2023 09/2018 Engineering Land/ROW Acquisition Construction Other 10/2018 09/2023 REVISION EXPLANATION Closing out project IS1502(CAD/RMS PS SOFTWARE PLATFORM)and moving funds to project IT1701 (ERP SYSTEM REPLACEMENT) FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 V''=sREVISION .h„,h. 2022/23 BALANCE COST FUNDINTG&OURCES„i;;'a:SbiaaititaaengiWua d-. .14 Certificates of Obligation $2,905,000 ' $0 $2,905,000 $0 $2,905,000 Reserves 769,428 ,V5, V;"8,'099 777,527 0 $777,527 0 ' r,lTii0: ii i;!liini0` 0 0 $0 0 1W' i,1 ;111,1 1bti 0 0 0 $0 0 i, °0 0 0 $0 Total $3,674,428 $8 099 $3,682,527 $0 $3,682,527 PROJECT EXPENDITURES,m Mgldat .tt ii Professional Services $360,205 4k d,, $0 $360,205 $0 $360,205 Engineering/Design 0 '! }©: 0 0 $0 Land/ROWAcquistion 0 '� i� � � , i0 0 0 $0 �' 47�HI�i 'u 4� Construction 0 �' 0 0 $0 Other 3,314 223 "°:1' ,,,;$099 3,322,322 0 $3,322,322 Total $3,674,428 =$8,099:: $3,682,527 $0 $3,682,527 IMPACT ON OPERATING BUDGET No operating budget impact expected. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 94 of 101 Major Capital Equipment Capital Projects Enterprise Computer System Replacement IT1701 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 improve accountability. Project Status Update: Project is currently underway in year 2 of 3 for the implementation of the new ERP system. Project is in PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services 02/2018 06/2023 09/2018 Engineering Land/ROW Acquisition Construction Other 10/2018 09/2023 REVISION EXPLANATION Transfer the funds of$70,200 from the Equipment line for project IT1701 (ERP SYSTEM REPLACEMENT)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 777527 0 777,527 0 $777,527 0 0 0 $0 0 ° 0° 0 0 $0 0 0 0 0 $0 Total $3,682,527 ° $0. $3,682,527 $0 $3,682,527 PROJECT EXPENDITURES Professional Services $360,205 $70,200 $430,405 $0 $430,405 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 0 0 0 $0 Other 3,322,322 ` a (70,200) 3,252,122 0 $3,252,122 Total $3,682,527 $0 $3,682,527 $0 $3,682,527 IMPACT ON OPERATING BUDGET No operating budget impact expected. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 95 of 101 Major Capital Equipment Capital Projects CAD/RMS PS SOFTWARE PLATFORM IS1502 PROJECT DESCRIPTION&JUSTIFICATION Replacement of the current CAD/RMS software platform (CRIMES)with a different software and vendor. The current software(CRIMES)is not meeting the needs for Public Safety. CRIMES has proven to be improperly developed and this poor development becomes apparent when the end-users attempt to use the software. Typically,the fixes from CRIMES are implemented and tend to cause more issues for the user. The problematic software platform causes problems for all users involved in the Joint Dispatch project-North Richland Hills, Richland Hills,Watauga, and Haltom City. Currently,staff from all of the participating cities are working to develop an RFP searching for a new software platform. This RFP should be available to potential vendors in May 2014 with the selection process/software demos taking place during the summer months. Contractual negotiations and pricing quotes should be ready for evaluation by staff the 4th quarter of the calendar year. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2014 02/2018 03/2023 REVISION EXPLANATION Closing out project IS1502(CAD/RMS PS SOFTWARE PLATFORM)and moving available funds of$8,099.00 to 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 Other $2,939,000 ,($8,099) $2,930,901 $0 $2,930,901 0 0 0 0 $0 0 0 0 0 $0 0 ° 0 0 0 $0 0 0 0 0 $0 Total $2,939,000 ($8,099) $2,930,901 $0 $2,930,901 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 20,000 0 20,000 0 $20,000 Other 2,919,000 (8,099) 2,910,901 0 $2,910,901 Total $2,939,000 ($8,099) $2,930,901 $0 $2,930,901 IMPACT ON OPERATING BUDGET No operating budget impact expected. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 96 of 101 Major Capital Equipment Capital Projects FS2301 Fire Engine Replacement(#963) PROJECT DESCRIPTION&JUSTIFICATION This is a replacement for an American LeFrance(ALF)Engine reserve unit E-224, Fleet unit#963,a 2003 year model engine. This unit has reached the end of its life cycle of 20 years. Repairs are more frequent and parts are difficult to find. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2022 10/2022 10/2023 10/2023 REVISION EXPLANATION The total cost of equipment to enable the vehicle to be service ready has increased due to inflation.Additionally, a comprehensive review of equipment indicates that cost should be paid for with operating funds rather than long term debt.A revision is necessary to remove a portion of debt funding for the project and replace it with Fire Department operating funds that are available. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 -,REVISION 2022/23 BALANCE COST FUNDING SOURCES " ° ' ° "`' ` Certificates of Obligation $986,000 :s. ,,($78,634)' $907,366 $0 $907,366 General Fund Operating 0 85,400. 85,400 0 $85,400 0 0 0 0 $0 0 :: 0 0 0 $0 0 0 0 0 $0 Total $986,000 ... �: ,$6,766. $992,766 $0 $992,766 �..u,. > PROJECT EXPENDITURES „ ,, ,-w= ,, w�.,�.� � �, Professional Services $0 $0. $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 ,0 0 0 $0 a Construction 0 ."0 0 0 $0 Other 986,000 6,766 992,766 0 $992,766 Total $986,000 `; $6,766 $992,766 $0 $992,766 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 97 of 101 Major Capital Equipment Capital Projects IT2206 Security Camera and Access Control Upgrade and Additions PROJECT DESCRIPTION&JUSTIFICATION Upgrade surveillance camera and access control systems at all City facilities still using legacy systems and install access control and surveillance cameras at the fire stations and training facility.This also includes adding panic buttons at key locations throughout city facilities. There is currently minimal security at all five fire stations.This project will add security to those facilities to be more in line with other City facilities'security.The NRH Centre, Library, Records Storage, Public Safety Training Center and Facilities and Construction buildings are using legacy access control and/or security cameras.This project will upgrade those systems to the standardized security systems used in all other City buildings.This will eliminate the need for staff to carry two different access badges. It will eliminate managing and maintain four different security systems(currently use 2 access control systems and 2 surveillance camera systems).This project will provide enhanced security organization wide. PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022123 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2022 06/2023 09/2023 06/2024 REVISION EXPLANATION Addition funds are needed to expand the scope of work to include panic button purchase and installation at key city facilities. This will enhance security and threat response to employees and customers. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT ` BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCES ARPA $340 000 4;1 4J °`$40,000, $380,000 $0 $380,000 0 ` 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $340,000 "° $40,000` $380,000 $0 $380,000 PROJECT EXPENDITURES 9 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 340,000 40,000 380,000 0 $380,000 Total $340,000 $40,000 $380,000 $0 $380,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 98 of 101 Major Capital Equipment Capital Projects NETWORK REPLACE FOR OFFSITE CITY FACILITIES 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 ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2019 04/2023 09/2023 REVISION EXPLANATION Close out Project IT2109(CRADLEPOINT UPGRADE FOR FIRE VEHICLES)and move available funds of$667.00 to Project IT1901 (NETWORK REPLACE FOR OFFSITE CITY FACILITIES) FINANCIAL DATA ADOPTED qy� REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 _ ,REVISION 4, 2022/23 BALANCE COST FUNDING SOURCES gt'm Ya_-x LI*„-t ,€ MA ' Certificates of Obligation $120,000 F4 1, i'i �' 1$0 $120,000 $0 $120,000 yew tl�P hSk'i" 'm �, Reserves 100,500 '� �� ;667_ 101,167 0 $101,167 0 ,,1„ 0' 0 0 $0 0 ,.,Oj 0 0 $0 0 ' ` ri rr iia4ii 0 0 0 0 $0 Total $220,500 $667 $221,167 $0 $221,167 PROJECTEXPENDITUR�S,„ai $ Professional Services $0 $0 $0 $0_ � 0`° Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 �� ��ii hti0 0 0 $0 Construction 0 OfiH�lii ��j�° �'tlp l 0 0 $0 Other 220,500 667 221,167 0 $221,167 Total $220,500 ? s < $667=' $221,167 $0 $221,167 IMPACT ON OPERATING BUDGET No operating budget impact expected. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 99 of 101 Major Capital Equipment Capital Projects CradlePoint Upgrade for Fire Vehicles IT2109 PROJECT DESCRIPTION&JUSTIFICATION Replacement of legacy Cradlepoints and antennas for Fire Units.These systems are used to maintain a encrypted connection to the City's network on fire vehicles. The Fire Department was the pilot for the first installment of Cradlepoints 7yrs ago. Since then,they have not been fully upgraded to meet the demands of todays technological requirements.There have been GPS updates on the newer Cradlepoints that are not available on the legacy Cradlepoints.The GPS updates are crucial for Spillman AVL status.The antennas are also legacy antennas requiring upgrading to meet the connection outputs required by the newer Cradlepoints. The legacy antennas only provide connectivity cables for 4 connections-2-Wifi, 1 Cellular, 1-GPS.With the constant change of technology,the newer Cradlepoints will require an antenna with 2-Wifi,2 Cellular,and 1 GPS.The antenna install will be outsourced to CrossPoint Communications. ICI PROJECT STATUS ORIGINAL 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2020 04/2023 09/2023 REVISION EXPLANATION Close out Project IT2109(CRADLEPOINT UPGRADE FOR FIRE VEHICLES)and move the available funds of$667.00 to Project IT1901 (NETWORK REPLACE FOR OFFSITE CITY FACILITIES). FINANCIAL DATA ADOPTED jrp� �yli ''�xq � REVISED TOTAL BUDGET THRU PROJECT° BUDGET THRU REMAINING PROJECT 2022/23 !REVISION ":fa, 2022/23 BALANCE COST FUNDING SOURCES a aHn " N 4I'G it x rttti.. ,„e a Mgr T Ii iwdii ib _ . _, , fi "w Reserves $60,000 V z $0 $60,000 $0 $60,000 0 if 1;sy0' 0 0 $0 0 i hy, 0" 0 0 $0 0 r 4,4 ri 4, 0 0 $0 n 0 0 0 $0 Total $60,000 r ' e $0- $60,000 $0 $60,000 PROJECT EXPENDITURES4�k iaiu .w rhuk.n , rf s �i " ° 5 c e� , ua,i a8d .'I aria°F as, r,,;' m Professional Services $0 4 $0 $0 $0 $0 Engineering/Design 0 `J �0= 0 0 $0 Land/ROW Acquistion 0 ,X A0' 0 0 $0 Construction 0 0 0 $0 �°iarsbu„���'a 6aqui '� Other 60 000 '1 a i�(6,67)J 59,333 0 $59,333 Total $60,000 ,-1!!;F,63;32b($6.67)1 $59,333 $0 $59,333 IMPACT ON OPERATING BUDGET No operating budget impact expected. ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 100 of 101 Other Capital Projects Neighborhood Initiative Program ES2201 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.This project also funds the Home Improvement Rebate Program,which provides an opportunity for qualified homeowners to receive a 50%cash rebate on the total amount of approved exterior upgrades up to$1,500. 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 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services 10/2021 11/2022 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION This revision is to lower budget of this project to what was actually spent.The remaining budget will be transferred to ES2301 (Neighborhood Initiative Program).This project will be also be closed out. FINANCIAL DATA ADOPTED �u "� REVISED TOTAL BUDGET THRU j" PROJECT BUDGET THRU REMAINING PROJECT 2022/23 _, :REVIS(iN,lg 2022/23 BALANCE COST FUNDING SOURCES .' ti pr kiA INiAPMPIRIMp rw 1gr 04®:F a_- r vapp_ , Reserves $5,000 r n($1,305)ij $3,695 $0 $3,695 do � 0 �, Q 0 0 $0 � �a��pi46 0 ,;,,bo02,0` 0 0 $0 0 s` y'tih01400'1 0. 0 $0 0 341040"4 0 0 $0 Total $5,000 "! ($1,305)a $3,695 $0 $3,695 PROJECT EXPENDITURES.,.. .. b.. x... .. _. � hvdi�a arro-�...��. .+:.�. Professional Services $5,000 „ri; iu"( ,305) $3,695 $0 $3,695 Engineering/Design 0 api;Pp 0 0 0 $0 b ' '1- Land/ROW Acquistion 0 ,,�;fi, �l ,-0� q ,A` 0 0 $0 Construction 0 ;111,001.Vigt,t0 0 0 $0 Other 0 " 'l ,F 0-' 0 0 $0 Total $5,000 .:i5 ,,-($1,305)' $3,695 $0 $3,695 IMPACT ON OPERATING BUDGET None ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 Ordinance No.3804 Attachment B Page 101 of 101 Other Capital Projects Neighborhood Initiative Program ES2301 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.This project also funds the Home Improvement Rebate Program,which provides an opportunity for qualified homeowners to receive a 50%cash rebate on the total amount of approved exterior upgrades up to$1,500. 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 2022/23 ORIGINAL 2022/23 START DATE REVISION END DATE REVISION Professional Services 10/2022 11/2024 11/2023 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION The dates are being revised to make this an annual project that will end on 11/30/2022.We will create a new project in for Fiscal Year 2023/2024.We are also adding the funding left over from project ES2201 ($1,305)to this project,a separate CIP Budget Transfer form will be submitted in addition to this revision. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2022/23 REVISION 2022/23 BALANCE COST FUNDING SOURCE5�i °':n v " .r,� u�� i� ,+o xe a q k r ,e� w a Reserves $34,970 j r $1,305 $36,275 $0 $36,275 0 0 0 0 $0 0 � ,,i;<" r 0 0 0 $0 0 b =0 0 0 $0 0 =.0 0 0 $0 Total $34,970 $1,305 $36,275 $0 $36,275 PROJECT EXPENDITURES, °�' „� .r >, ;, Professional Services $34,970 ?� $1 305'e $36,275 $0 $36,275 Engineering/Design 0 � �,0� 0 0 $0 Land/ROW Acquistion 0 �" ` '; 0` 0 0 $0 Construction 0 "a _ 0; 0 0 $0 eu� a ii s� Other 0 "u ,g µ 0: 0 0 $0 Total $34,970 61 4't oe�a;$1,305, $36,275 $0 $36,275 IMPACT ON OPERATING BUDGET None ANNUAL OPERATING IMPACT 2022/23 2023/24 2024/25 2025/26 2026/27 TOTAL Projected $0 NOTICE OF PUBLIC HEARING 2022-2023 AMENDED BUDGET NOTICE IS HEREBY GIVEN to all interested citizens in the City of North Richland Hills, that the City Council will hold a public hearing on the 2022-2023 amended budget on Monday, August 14, 2023 during the regular 7:00 p.m. City Council meeting at the North Richland Hills City Hall City Council Chambers, 4301 City Point Drive, North Richland Hills, Texas.