Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Ordinance 3751
ORDINANCE NO. 3751 AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF NORTH RICHLAND HILLS, TEXAS, ADOPTING THE REVISED BUDGET FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2021 AND ENDING SEPTEMBER 30, 2022, IN ACCORDANCE WITH THE CHARTER OF THE CITY OF NORTH RICHLAND HILLS, TEXAS; PROVIDING FOR THE FILING OF THE BUDGET; PROVIDING FOR INVESTMENTS AND TRANSFERS; PROVIDING A SEVERABILITY CLAUSE AND PROVIDING AN EFFECTIVE DATE. WHEREAS, the City of North Richland Hills is a home rule city acting under its charter adopted by the electorate pursuant to Article XI, Section 5 of the Texas Constitution and Chapter 9 of the Local Government Code; and WHEREAS, the City Manager of the City of North Richland Hills submitted a revised budget for the fiscal year beginning October 1, 2021, and ending September 30, 2022 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, such public hearing on the revised budget was duly held on August 8, 2022, 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 revised budget should be approved and adopted; NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF NORTH RICHLAND HILLS, TEXAS, THAT: SECTION 1. The revised budget of revenues and expenditures of the City of North Richland Hills for the Fiscal Year beginning October 1, 2021 and ending September 30, 2022, as set forth in Attachments A and B, operating and capital projects budgets for FY 2021/2022, is hereby amended. SECTION 2. The revised budget for Fiscal Year 2021/2022 is on file with the City Ordinance No. 3751 Page 1 of 3 Secretary in accordance with state law and the City Charter. SECTION 4. The City Manager is hereby authorized to make inter-departmental and inter-fund transfers during the fiscal year as deemed necessary in order to avoid over-expenditure of particular accounts. SECTION 5. The City Manager, or his designee, is hereby authorized to invest any funds not needed for current use in any lawful manner. Interest accrued from investments shall be deposited to the interest income account of the funds from which the principal was invested. SECTION 6. This ordinance shall be cumulative of all provisions of ordinances and of the Code of Ordinances, City of North Richland Hills, Texas, as amended, except where the provisions are in direct conflict with the provisions of other ordinances, in which event the conflicting provisions of the other ordinances are hereby repealed. SECTION 7. It is hereby declared to be the intention of the City Council that the phrases, clauses, sentences, paragraphs and sections of this ordinance are severable, and if any phrase, clause, sentence, paragraph or section of this ordinance shall be declared unconstitutional by the valid judgment or decree of any court of competent jurisdiction, such unconstitutionality shall not affect any of the remaining phrases, clauses, sentences, paragraphs and sections of this ordinance, since the same would have been enacted by the City Council without the incorporation in this ordinance of any such unconstitutional phrase, clause, sentence, paragraph or section. 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 8th day of August, 2022. CITY OF NORTH RICHLAND HILLS Tito Rodriguez, Mayor Pro Tem Ordinance No. 3751 Page 2 of 3 11111111111111/00 ATTEST: Alicia Richardson " ® •' v City Secretary/Chief Go .rfi i er // /4onIIo lll11111 APPROVED AS TO FORM AND LEGALITY: cay; aleshia B. Mc innis, City Attorney APPROVED AS TO CONTENT: Trudy J LJ , Budget & Research Director Ordinance No. 3751 Page 3 of 3 :;10.4114,014.01„14,2f4e..•.."•,4.-.,: • a ` A3' FII�tt sq' .. 1 '� At L, ° " +¢ te�� 11 .;.u" 17�* � xs • , 1 q .. s " ry "7A" s . a}} te *1110 P '5' _� ry S' ,f�•. . - { FretC • 00• ?":;"'',..., ? 'G ,,H",o- • "Y+. aax c t, R` 0a AID... it,„ .„);_?...., .. ,:e.4::"4 *.F.' .F.4'-''._,:e.6.,..,,,,,'•'--7.144.•%:'±-‘'''''-q-5441'• '''FZ..F ° i o ! lS. 'jCI i ''FF _„,....."-'.....—..- '''I''''ll."1111. +N n# ` .•° r •i 3 w z 'Yiti • * o � Mom-""". - , ty-- , • #:rt,^ .' T: $• .. [�p• � �, p p t wa J" tea^°.._ ----- s s-.a. k`e ' kK •. " C • P:11 ' T. te ." a.,, 4... a $^a y x •t m,;� x3 :��' S . .r'�»_� ,kW ' '* ..n tf, 1t4, ••'da^$, aG+• ?4? c ". •+'", *r R ,, 4 `*an' «*4" apt, .. i„ 44 V.*"" -, °r y ;- : rr,arJ. ra 7 ,x ? a ' r • " 9•,'.J ..tipi r • ` � ce yrp 4rt4s " sL s ? s .. w. REVISED • „. : . . , , . . ,, ,,,. . .,.... ,,._ .... , , 701111111111 ...., • 9 • 1151, Ittil 'kF' saa. , -a 4a" J.PNil 4444 i 9` *4a 1 .; a a``",aa n. :.,�_".- % ...�;,^,°�:, .M 4 .6 .yd t 3. ,R:"Z di `( ' ...�r °" 4thr ,c v.s:.4.�.k,'k �^r,w.. . � 1�f • 4 N__., St_ 7, . ° . T' a s �nib L a Ain ."• : p + to,,,,,, �i VIAi 617kt� ;� 5l a1*- ' �y "X �I�� kt. '" wp � °1,a;:fi:t. rs h r•,� q» .• .7.. . o•� � k4a. " � pry - " u " • 4 a '4�r'16'0e,�; r 4 �.. �'„ P��7. "r�` .•.; 'a , r; — f^ ,; 3 A .; a4 Pryd ,-2 . 4 ,II SAL YEARI2O2w22 • ., � r � l �Sciy�QRz' ��., *'' .. �'Yf , pm fi.k-,-**"w �� r-:, ®w}a �,.'a,�� m �� 7 ... . " .- ^ . 5 m ki ;-�^ :,« . •*r i „.f.: : N ` k ,+ ' „.aat .. " L - 04&9', w � s,., " x � Y$ �I IE1811GG U 51 g r w� " - r" �#° n i�. as aw. . : ♦', uYIa€ ,-4µL6j-. w14, is t . � e � q" .fi 'ih . „ 1 1 7y 1 . ' _a ,w1 , . .v � � y � , L D... t $,. u' + ..: 4 6 o. •ti ..'$ 1z,. r 1[ sy , . ... . n u .: For ii `• ° REVISED I BUDGET ;. `. i Table of Contents Budget Summaries 3 Schedule 1 -General Fund Summary of Revenues & Expenditures 3 Schedule 2-General Fund Revenues 3 Schedule 3-General Fund Expenditures 6 Schedule 4- Property Tax Revenue and Distribution 9 Schedule 5-General Debt Service Fund 10 Schedule 6-Summary of TIF District Property Tax Revenue and Distribution 11 Schedule 7-Tax Increment Financing Fund 12 Schedule 8- Park& Recreation Facilities Development Fund Summary 14 Schedule 9-Crime Control District Summary of Revenues & Expenditures 16 Schedule 10- Promotional Summary of Revenues & Expenditures 17 Schedule 11 - Donations Summary of Revenues & Expenditures 18 Schedule 12-Special Investigation Summary of Revenues & Expenditures 19 Schedule 13- Drainage Utility Summary of Revenues & Expenditures 20 Schedule 14-Gas Development Fund 21 Schedule 15-Traffic Safety Fund 22 Schedule 16- Utility Fund Summary of Revenues & Expenses 23 Schedule 17-Aquatic Park Summary of Revenues & Expenses 25 Schedule 18-Golf Course Summary of Revenues & Expenses 26 Schedule 19- Facilities/Construction Management Summary of Revenues & Expenses 27 Schedule 20- Fleet Services Revenues & Expenses 28 Schedule 21 - Information Technology Summary of Revenues & Expenses 29 Schedule 22-Self Insurance Summary of Revenues & Expenses 30 Ordinance No.3751 NRH I TEXAS Attachment"A" e m:.°m e .,; . 5�.0�� S @ _. °, x,�;a ,�. n,gA . `! wr�".•b®ems e�+a� R �°a� �jv.s $. ,,f.s.va ° . ., FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 1-SUMMARY OF REVENUES AND EXPENDITURES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 REVENUES Taxes $35,635,260 $37,985,868 $38,746,705 $39,740,949 Fines&Forfeitures 1,840,749 2,005,047 2,090,037 1,909,315 Licenses&Permits 2,875,705 3,254,498 2,282,727 2,320,727 Charges for Service 2,549,854 2,672,725 2,531,560 2,490,435 Intergovernmental 5,274,808 5,245,249 5,184,745 5,184,745 Miscellaneous 6,120,979 1,825,709 1,920,311 1,908,774 TOTAL REVENUES $54,297,356 $52,989,097 $52,756,085 $53,554,945 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $348,443 $0 $807,963 $1,466,460 SUB-TOTAL APPROPRIATIONS $348,443 $0 $807,963 $1,466,460 TOTAL RESOURCES $54,645,799 $52,989,097 $53,564,048 $55,021,405 EXPENDITURES City Council $57,657 $63,364 $133,275 $132,775 City Manager 755,361 759,480 793,781 794,814 Communications 387,739 392,745 419,267 459,272 City Secretary 442,427 453,789 499,897 500,430 Legal 423,461 424,273 561,992 619,950 Human Resources 131,486 139,555 153,064 171,842 Finance 757,538 775,602 813,829 815,471 Budget&Research 417,821 407,582 437,213 437,302 Municipal Court 1,275,721 1,337,167 1,490,611 1,500,871 . Planning and Inspections 1,332,368 1,291,602 1,382,003 1,388,521 Economic Development 340,886 346,529 364,734 365,533 Library 2,094,826 2,189,693 2,343,658 2,352,432 Neighborhood Services 1,996,052 2,036,093 2,151,255 2,162,016 Public Works 3,278,402 2,963,870 3,336,650 3,339,085 Parks&Recreation 2,030,694 1,890,865 1,959,900 1,961,114 Police 15,652,134 16,322,074 16,904,754 17,058,555 Fire 13,788,614 14,144,935 14,933,760 15,126,928 Building Services 812,101 812,101 812,101 812,101 Non-Departmental 1,203,468 1,271,785 1,402,286 1,376,918 SUB-TOTAL DEPARTMENTS $47,178,757 $48,023,103 $50,894,030 $51,375,930 RESERVES&OTHER EXPENDITURES Planned Contribution to Fund Balance $130,420 $0 $702,442 $2,298,920 Capital Project Transfers 1,050,000 4,413,900 1,050,000 1,050,000 Operational Transfers 2,547,722 167,737 917,576 296,555 SUB-TOTAL RESERVES AND OTHER $3,728,142 $4,581,637 $2,670,018 $3,645,475 TOTAL EXPENDITURES $50,906,899 $52,604,740 $53,564,048 $55,021,405 BALANCE $3,738,900 $384,357 $0 $0 Ordinance No.3751 Attachment"A" Page 3 of 30 • FISCAL YEAR 2021-2022 SCHEDULE 2-SUMMARY OF REVENUES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 TAXES Current Property Taxes $19,152,678 $20,642,059 $21,914,146 $21,914,146 Delinquent Property Taxes (65,356) 94,926 80,000 80,000 Penalty and Interest 184,371 188,545 180,000 180,000 Franchise Fees 3,725,617 3,465,661 3,623,930 3,553,090 Utility Fund Franchise Taxes 1,087,873 1,063,691 1,156,068 1,156,068 Sales Taxes 11,019,420 11,991,880 11,243,573 12,308,657 Mixed Beverages 125,456 128,889 143,746 143,746 Payment in Lieu of Taxes 405,201 410,217 405,242 405,242 SUB-TOTAL $35,635,260 $37,985,868 $38,746,705 $39,740,949 FINES AND FORFEITURES Municipal Court Fines $1,693,892 $1,842,169 $1,896,337 $1,767,199 Warrant&Arrest Fees 138,321 162,878 153,700 142,116 Library Fines 8,537 0 40,000 0 SUB-TOTAL $1,840,749 $2,005,047 $2,090,037 $1,909,315 LICENSES AND PERMITS Building Permits $1,596,078 $1,959,595 $1,230,000 $1,230,000 Electrical Permits 108,393 (300) 63,600 63,600 Plumbing Permits 165,935 (29) 126,950 126,950 Mechanical Permits 202,346 1,587 130,000 130,000 Miscellaneous Permits 76,382 564,637 65,920 103,920 Certificate of Occupancy 12,959 2,031 14,204 14,204 Plan/Review/Application Fee 61,741 108,875 50,000 50,000 Apartment Inspection Fees 105,953 112,475 110,000 110,000 Curb&Drainage Inspection Fees 92,703 163,526 50,000 50,000 Re-Inspection Fees 23,239 0 25,000 25,000 License Fees 22,922 10,657 25,000 25,000 Contractor Registration Fees 138 0 0 0 Fire Inspection 51,227 425 17,000 17,000 Gas Well Inspection 56,000 56,000 56,000 56,000 Food Service Permits 162,825 148,351 161,053 161,053 Food Managers School 2,372 7,032 0 0 Animal License/Adoption Fees 33,117 27,629 60,000 60,000 Animal Control Impoundment 11,485 12,324 13,000 13,000 Auto Impoundment Fees 10,222 8,974 10,000 10,000 Burglar Alarm Permits 79,668 70,710 75,000 75,000 SUB-TOTAL $2,875,705 $3,254,498 $2,282,727 $2,320,727 CHARGES FOR SERVICE Park Facility Rental $18,471 $4,104 $945 $500 Ambulance Fees 1,793,217 1,752,511 1,725,715 1,726,375 Ambulance Supplemental Program 0 273,983 124,000 124,000 Garbage Billing 519,607 542,570 550,000 550,000 Recreation Fees 8,613 4,230 11,700 11,910 Athletic Revenue 96,171 10 0 0 Recreation Special Events 2,763 13,991 12,200 11,500 Planning&Zoning Fees 32,985 41,315 38,000 0 Sale of Accident Reports 5,980 3,583 8,900 8,900 Mowing 58,065 31,892 44,000 44,000 Fire Dept Certification/CPR Citizen Class 3,855 4,210 6,000 3,150 Miscellaneous 10,128 327 10,100 10,100 SUB-TOTAL $2,549,854 $2,672,725 - $2,531,560 $2,490,435 Ordinance No.3751 Attachment"A" , Page 4 of 30 FISCAL YEAR 2021-2022 SCHEDULE 2-SUMMARY OF REVENUES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 INTERGOVERNMENTAL Indirect Costs: Utility Fund $2,182,170 $2,182,170 $2,182,170 $2,182,170 Park&Rec Facilities Dev.Corp. 499,363 485,987 512,957 512,957 Crime Control District 30,156 16,780 43,750 43,750 Aquatic Park Fund 0 0 0 0 Consolidation Reimbursements 2,563,119 2,560,312 2,445,868 2,445,868 Transfers In Park Fund 0 0 0 0 SUB-TOTAL $5,274,808 $5,245,249 $5,184,745 $5,184,745 MISCELLANEOUS Interest Income $350,993 $211,290 $168,722 $133,427 Radio Reimbursement 260,371 263,497 267,460 260,181 Lease Income 98,299 99,541 131,221 131,221 Grant Proceeds 3,785,226 36,414 384,814 384,814 Park Fund Reimbursement (0) 0 0 0 Fleet Service Fund Reimbursement 498,973 416,332 446,552 446,552 Teen Court Reimbursement 11,265 30,309 20,114 20,114 Other Income 309,668 723,058 103,761 134,798 Public Safety Reimbursements 72,129 45,267 70,000 70,000 Designated Funds for City Hall Project Debt 734,056 0 327,667 327,667 SUB-TOTAL $6,120,979 $1,825,709 $1,920,311 $1,908,774 APPROPRIATION-FUND BALANCE Appropriation of Fund Balance $348,443 $0 $807,963 $1,466,460 SUB-TOTAL $348,443 $0 $807,963 $1,466,460 TOTAL REVENUES $54,645,798 $52,989,097 $53,564,048 $55,021,405 Ordinance No.3751 Attachment"A" Page 5 of 30 FISCAL YEAR 2021-2022 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 EXPENDITURES City Council $57,657 $63,364 $133,275 $132,775 City Manager $755,361 $759,480 $793,781 $794,814 Communications Public Information $265,373 $269,628 $280,010 $279,864 Citicable 122,366 123,117 139,257 179,408 Total Communications $387,739 $392,745 $419,267 $459,272 City Secretary City Secretary"v $342,880 $343,372 $374,427 $374,960 Record Management 99,547 110,417 125,470 125,470 Total City Secretary $442,427 $453,789 $499,897 $500,430 Legal $423,461 $424,273 $561,992 $619,950 Human Resources $131,486 $139,555 $153,064 $171,842 Finance Accounting&Administration $485,001 $496,617 $521,429 $522,228 Purchasing 272,538 278,985 292,400 293,243 Total Finance $757,538 $775,602 $813,829 $815,471 Budget&Research Budget $417,821 $407,582 $437,213 $437,302 Total Budget&Research $417,821 $407,582 $437,213 $437,302 Municipal Court Administration/Prosecution $790,641 $840,934 $899,259 $907,218 Warrant Division 376,737 389,887 473,946 474,656 Teen Court 108,343 106,346 117,406 118,997 Total Municipal Court $1,275,721 $1,337,167 $1,490,611 $1,500,871 Planning and Development Inspections and Permitting $1,023,096 $974,921 $1,054,201 $1,060,222 Planning and Zoning 309,272 316,681 327,802 328,299 Total Planning and Development $1,332,368 $1,291,602 $1,382,003 $1,388,521 Economic Development $340,886 $346,529 $364,734 $365,533 Library General Services $398,226 $401,885 $440,992 $441,169 Public Services 890,326 942,890 999,045 1,008,150 Technical Services 806,274 844,918 903,621 903,113 Total Library $2,094,826 $2,189,693 $2,343,658 $2,352,432 • Ordinance No.3751 Attachment"A" Page 6 of 30 FISCAL YEAR 2021-2022 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 Neighborhood Services Neighborhood Resources $358,509 $366,961 $379,951 $381,699 Animal Services 795,183 818,894 850,134 857,553 Consumer Health 346,367 352,855 381,445 381,445 Code Compliance 495,993 497,383 539,725 541,319 Total Neighborhood Services $1,996,052 $2,036,093 $2,151,255 $2,162,016 Public Works General Services $336,498 $298,825 $362,453 $362,630 Traffic Control 1,084,750 1,010,742 1,146,632 1,146,986 Street&Drainage 1,857,154 1,654,303 1,827,565 1,829,469 Total Public Works $3,278,402 $2,963,870 $3,336,650 $3,339,085 Parks&Recreation General Services $175,431 $150,311 $149,345 $149,530 Parks Maintenance 932,538 969,139 983,838 983,980 Recreation Services 487,102 487,102 487,102 487,102 Athletic Program Services 146,066 0 0 0 Senior Adult Services 258,080 258,607 298,817 299,704 Youth Outreach&Cultural 31,476 25,706 40,798 40,798 Total Parks&Recreation $2,030,694 $1,890,865 $1,959,900 $1,961,114 Police General Services $1,438,267 $1,405,079 $1,425,066 $1,471,391 Administrative Services 597,720 807,648 743,616 780,894 Criminal Investigations 2,866,692 2,979,598 3,153,664 3,146,390 Uniform Patrol 6,328,995 6,381,405 6,565,695 6,553,258 Detention Services 1,660,127 1,726,110 1,844,633 1,848,961 Property Evidence 498,901 656,573 635,936 706,062 Communications 2,261,432 2,365,662 2,536,144 2,551,599 Total Police $15,652,134 $16,322,074 $16,904,754 $17,058,555 Fire Department General Services $424,446 $437,800 $479,314 $483,041 Operations 10,508,921 10,628,103 11,069,413 11,102,153 Emergency Medical 1,620,276 1,839,690 1,990,310 2,054,838 Fire Inspections 543,058 552,828 599,955 602,496 Fire Inspections 691,912 686,514 794,768 884,400 Total Fire $13,788,614 $14,144,935 $14,933,760 $15,126,928 Building Services $812,101 $812,101 $812,101 $812,101 Non Departmental") $1,203,468 $1,271,785 $1,402,286 $1,376,918 SUB-TOTAL DEPARTMENTS $47,178,757 $48,023,103 $50,894,030 $51,375,930 Ordinance No.3751 Attachment"A" Page 7 of 30 FISCAL YEAR 2021-2022 SCHEDULE 3-SUMMARY OF EXPENDITURES GENERAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 RESERVES&OTHER EXPENDITURES Operational Transfers Transfer to Information Technology Fund $209,154 $167,737 $148,613 $296,555 Transfer to Fleet Fund 28,875 0 0 0 Transfer to NRH2O 2,309,693 0 0 0 Transfer to Debt Service Fund 0 0 768,963 0 Operational Transfers Total $2,547,722 $167,737 $917,576 $296,555 Capital Proiect Transfers General Capital Project Transfers $0 $517,511 $0 $0 Property Purchase 0 2,846,389 0 0 Street&Sidewalk Capital Project Transfers 1,050,000 1,050,000 1,050,000 1,050,000 Capital Project Transfers Total $1,050,000 $4,413,900 $1,050,000 $1,050,000 Planned Contribution to Fund Balance General Fund Reserves $0 $0 $577,442 $2,173,920 Transportation Fund Reserves 0 0 0 0 Public Educational Governmental(PEG)Reserve 130,420 0 125,000 125,000 Contribution to Fund Balance Total $130,420 $0 $702,442 $2,298,920 TOTAL RESERVES&OTHER EXPENDITURES $3,728,142 $4,581,637 $2,670,018 $3,645,475 TOTAL EXPENDITURES $50,906,899 $52,604,740 $53,564,048 $55,021,405 BALANCE $3,738,900 $384,357 $0 $0 Ordinance No.3751 Attachment"A" Page 8 of 30 FISCAL YEAR 2021-2022 SCHEDULE 4-SUMMARY OF PROPERTY TAX REVENUE AND DISTRIBUTION NETTAXABLE VALUE: M&O I&S 101AL Total Appraised Value as of July 23,2021 8,387,782,371 Less: Absolute Exemption (439,703,146) Cases Before ARB (375,670,178) Incomplete Accounts (117,026,824) Disabled Veteran (49,267,823) Over 65 (205,363,738) Homestead (608,711,721) Disabled Persons (10,367,650) Freeport Inventory Value Loss (5,853,270) Pollution Control (27,671) Solar&Wind Powered Devices (8) Nominal Value Accounts (1,089,186) Mscellaneous Personal Property (11,372,919) Property Damaged by Disaster (1,731,299) In Process (70) Total Reduction to Values (1,826,185,503) NETTAXABLE VALUE ATJULY 23,2021 6,561,596,868 Add: Estimated NGnimum ARB protested values 237,727,866 Incomplete Property 51,832,113 In Process 0 ESTIMATED NETTAXABLE VALUE ATJULY 23,2021 6,851,156,847 ESTIMATED PROPERTY TAX COLLECTIONS: Estimated Net Taxable Value 6,851,156,847 Less:TIF#2 Incremental Value (557,946,437) Less:TIF#3 Incremental Value (6,651,704) Less:Tax Ceiling Taxable Values (1,118,453,450) Net Taxable Values 5,168,105,256 i Adopted Tax RatPer$iO�Valutron71 ^iIfi 7 0:3488641�ymnw0223320 0572184 Esti mated Total Tax Levy at100%Coll ection 18,029,659 11,541,403 29,571,062 Less:Estimated Uncollectable(1.5%) (270,445) (270,445) Less:Estimated l&S Uncollectable(1.5%) (173,121) (173,121) Estimated Revenue from Property Tax 17,586,093 11,541,403 29,127,496 Estimated Revenue from Property Tax 17,586,093 11,541,403 29,127,496 Plus:Tax Ceiling Account Revenue 4,381,783 - 4,381,783 Less:Estimated Uncollectable(1.5%) (65,727) - (65,727) Plus:TIF Tax Rate Differential(0.002183) 12,180 - 12,180 Less:Estimated I&S Uncollectable(1.5%) (183) - (183) ESTIMATED PROPERTY tAX DISTRIBUTION 21,914,146 11,541,403 33,455,549 Ordinance No.3751 Attachment"A" Page 9 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 5-SUMMARY OF REVENUES AND EXPENDITURES GENERAL DEBT SERVICE FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY2019/20 FY2020/21 FY2021/22 FY2021/22 REVENUES PROPERTY TAXES General Debt Service Taxes $11,200,798 $11,202,557 $11,541,403 $11,541,403 PROPERTY TAXES $11,200,798 $11,202,557 $11,541,403 $11,541,403 TRANSFER-IN Drainage Utility $248,181 $220,675 $219,200 $219,200 Park&Rec.Facilities Dev.Corp 509,030 463,005 452,505 452,505 Fleet Services Fund 0 252,300 191,575 243,300 TOTAL TRANSFER-IN $757,211 $935,980 $863,280 $915,005 OTHER REVENUES Interest Income $28,004 $15,810 $6,000 $6,000 City of Watauga,CIP Participation 82,853 82,583 60,352 60,352 Excess Collection 0 0 0 0 TOTAL OTHER REVENUES $110,857 $98,393 $66,352 $66,352 TOTAL REVENUES $12,068,866 $12,236,930 $12,471,035 $12,522,760 APPROPRIATION OF FUND BALANCE General Fund Fund Balance $0 $0 $768,963 $0 Appropriation of Fund Balance 0 0 0 0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $0 TOTAL RESOURCES $12,068,866 $12,236,930 $13,239,998 $12,522,760 EXPENDITURES DEBT EXPENDITURES Existing Bonds&C.O.'s $11,957,471 $12,102,627 $13,230,498 $12,513,260 Issuance Costs/Paying Agent Fees 7,186 (4,740) 9,500 9,500 Bond Defeasance/Refunding 0 5,100 0 0 TOTAL EXPENDITURES $11,964,657 $12,102,987 $13,239,998 $12,522,760 BALANCE $104,209 $133,943 $0 $0 Ordinance No.3751 Attachment"A" Page 10 of 30 FISCAL YEAR 2021-2022 SCHEDULE 6-SUMMARY OF TAX INCREMENT FINANCE(TIF)DISTICT PROPERTY TAX REVENUE AND DISTRIBUTION TAX INCREMENT FINANCING DISTRICT#2 VALUE Taxable Value(2021 Tax Year) $654,610,662 Less: Base Taxable Value(1998 Tax Year) 40,020,188 Taxable Value Increment(2021 Tax Year) Gain/(Loss): $614,590,474 TAX INCREMENT FINANCING DISTRICT#2 CONRIBUTION Taxable Value Increment:TIF District#2 $614,590,474 Tax Rate per$100 Valuation and Inception $0.57 TIF District#2 Property Tax Revenue at 100% $3,503,166 Collection Rate 98.50% TIF District#2 Property Tax Revenue $3,450,618 • TAX INCREMENT FINANCING DISTRICT#3 VALUE Taxable Value(2021 Tax Year) $13,000,000 Less: Base Taxable Value(2019 Tax Year) 6,348,296 Taxable Value Increment(2021 Tax Year) Gain/(Loss): $6,651,704 TAX INCREMENT FINANCING DISTRICT#3 CONTRIBUTION Taxable Value Increment:TIF District#3 $6,651,704 Tax Rate per$100 Valuation and Inception $0.15 TIF District#3 Property Tax Revenue at 100% $10,285 Collection Rate 98.50% TIF District#3 Property Tax Revenue $10,131 TOTAL ESTIMATED TAX INCREMENT FINANCING DISTRICT PROPERTY TAX REVENUE(1)(2) $3,460,749 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)TIF#1 Closed in 2018.TIF#1A Closed in 2019. Ordinance No.3751 Attachment"A" Page 11 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 7-SUMMARY OF REVENUES AND EXPENDITURES TAX INCREMENT FINANCING FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY2019/20 FY2020/21 FY2021/22 FY2021/22 TAX INCREMENT FINANCING DISTRICT#1/1A REVENUES PROPERTY TAXES City of North Richland Hills $0 $0 $0 $0 Tarrant County Hospital District 0 0 0 0 Tarrant County College District 0 0 0 0 Tarrant County 0 0 0 0 TOTAL TIF#1/1A PROPERTY TAXES $0 $0 $0 $0 OTHER FUNDING SOURCES Investment Income $31,053 ($2,165) $0 $1,018 Appropriation of Fund Balance 0 0 0 _ 296,637 TOTAL OTHER FUNDING SOURCES $31,053 ($2,165) $0 $297,655 TOTAL REVENUES $31,053 ($2,165) $0 $297,655 EXPENDITURES Final Distribution to Participating Entities $0 $0 $0 $297,655 TOTAL EXPENDITURES $0 $0 $0 $297,655 BALANCE $31,053 ($2,165) $0 $0 TAX INCREMENT FINANCING DISTRICT#2 REVENUES PROPERTY TAXES City of North Richland Hills $2,901,452 $3,146,530 $3,450,618 $3,449,798 Tarrant County Hospital District 172,651 0 0 0 Tarrant County College District 710,023 768,126 974,477 0 Tarrant County 380,797 0 0 0 TOTAL TIF#2 PROPERTY TAXES $4,164,923 $3,914,656 $4,425,095 $3,449,798 OTHER FUNDING SOURCES Investment Income $217,235 $19,489 $217,000 $64,562 Appropriation of Fund Balance 0 0 0 26,165,170 TOTAL OTHER FUNDING SOURCES $217,235 $19,489 $217,000 $26,229,732 TOTAL REVENUES $4,382,158 $3,934,145 $4,642,095 $29,679,530 EXPENDITURES Debt Service/Bond Defeasance/Paying Agent $2,198,674 $2,228,143 $2,051,935 $9,781,877 Final Distribution to Participating Entities 1,275 0 0 12,533,199 FY21 Payment Rebate 1,275 0 0 3,914,656 FY22 Payment Rebate 0 0 0 3,449,798 TOTAL EXPENDITURES $2,201,224 $2,228,143 $2,051,935 $29,679,530 BALANCE $2,180,935 $1,706,002 $2,590,160 $0 Ordinance No.3751 Attachment"A' Page 12 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 7-SUMMARY OF REVENUES AND EXPENDITURES TAX INCREMENT FINANCING FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY2019/20 FY2020/21 FY2021/22 FY2021/22 TAX INCREMENT FINANCING DISTRICT#3 REVENUES PROPERTY TAXES City of North Richland Hills $0 $9,507 $10,131 $10,443 Tarrant County 0 3,597 3,891 3,808 TOTAL PROPERTY TAXES $0 $13,104 $14,022 $14,251 OTHER FUNDING SOURCES Investment Income $0 $0 $0 $13,104 TOTAL OTHER FUNDING SOURCES $0 $0 $0 $13,104 TOTAL REVENUES $0 $13,104 $14,022 $27,355 EXPENDITURES Public Improvement District Contribution $0 $0 $14,022 $27,355 TOTAL EXPENDITURES $0 $0 $14,022 $27,355 BALANCE $0 $13,104 $0 $0 Ordinance No.3751 Attachment"A" Page 13 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY Y 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 REVENUES OPERATING Sales Tax $5,509,712 $5,995,942 $5,621,818 $6,154,344 Tennis Center Revenue 371,746 503,555 435,750 477,250 Athletic Program Revenue 0 209,796 204,460 214,560 Youth Association Fees 27,270 16,144 22,800 16,600 Park Impact Fees 255,834 107,425 95,000 94,000 Other Income 31,662 47,109 37,353 51,242 TOTAL OPERATING $6,196,224 $6,879,971 $6,417,181 $7,007,996 NRH CENTRE Memberships/Drop-In Passes $891,315 $1,067,647 $1,300,000 $1,300,000 Fitness 289,798 214,254 442,000 361,000 Recreation/Sports 157,756 329,907 351,000 335,600 Grand Hall Rental 275,943 286,668 352,810 399,815 Catering&Event Fees 20,705 9,457 21,690 17,820 Aquatic Programs 105,556 134,268 240,000 220,000 Pool Rental 3,645 11,641 3,000 3,000 Gym Rental 12,020 2,190 12,000 0 Concessions/Merchandise 16,177 15,838 27,000 27,500 Special Events 8,680 0 8,500 9,180 Other 49,132 2,493 36,939 24,815 General Fund 487,102 487,102 487,102 487,102 TOTAL NRH CENTRE $2,317,829 $2,561,466 $3,282,041 $3,185,832 TOTAL REVENUES $8,514,053 $9,441,437 $9,699,222 $10,193,828 APPROPRIATION OF FUND BALANCE Appropriation of Park Impact Fee Reserves $0 $0 $230,000 $230,000 Appropriation of NRH Centre Reserves 0 175,084 0 6,685 Appropriation of Sales Tax Reserves 0 0 0 14,073 TOTAL APPROPRIATION OF FUND BALANCE $0 $175,084 $230,000 $250,758 TOTAL RESOURCES $8,514,053 $9,616,521 $9,929,222 $10,444,586 Ordinance No.3751 Attachment"A" Page 14 of 30 • • FISCAL YEAR 2021-2022 SCHEDULE 8-SUMMARY OF REVENUES AND EXPENDITURES PARK AND RECREATION FACILITIES DEVELOPMENT FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 EXPENDITURES OPERATING Park Facilities Development Admin. $942,044 $770,504 $831,594 $832,337 Parks&Public Grounds 1,959,715 2,048,970 2,129,559 2,145,699 Athletic Program Services 344 208,365 231,155 226,219 Tennis Center Operations 521,171 597,341 601,188 633,583 Non-Departmental 47,917 44,702 61,523 55,600 TOTAL OPERATING $3,471,191 $3,669,882 $3,855,019 $3,893,438 NRH CENTRE Center Management $691,784 $795,370 $932,697 $928,660 Fitness 405,534 311,102 406,434 342,350 Building Operations 289,717 244,883 230,674 278,005 Aquatic 581,277 676,536 673,005 724,286 Recreation Sports 178,438 199,932 317,556 318,783 Grand Hall 293,768 232,314 345,074 324,674 Building Services 277,788 276,414 275,090 _ 275,090 TOTAL NRH CENTRE $2,718,307 $2,736,550 $3,180,530 $3,191,848 OTHER&RESERVES Debt Service $509,030 $463,005 $452,505 $452,505 Indirect Costs 469,207 469,207 512,957 512,957 Transfers Parks Capital Projects 1,051,000 424,000 644,000 644,000 General Fund 30,156 16,780 0 0 Impact Fee Capital Projects 120,000 265,000 230,000 297,075 Economic Development Transfer 137,743 149,899 140,545 153,859 Planned Contribution to Fund Balance Parks Fund Reserves 0 0 717,155 1,271,310 NRH Centre Fund Reserves 0 0 101,511 669 Impact Fee Reserves 255,834 107,425 95,000 26,925 TOTAL OTHER&RESERVES $2,572,969 $1,895,316 $2,893,673 $3,359,300 TOTAL EXPENDITURES $8,762,467 $8,301,748 $9,929,222 $10,444,586 BALANCE ($248,414) $1,314,773 $0 $0 Ordinance No.3751 Attachment"A" Page 15 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 9-SUMMARY OF REVENUES AND EXPENDITURES CRIME CONTROL DISTRICT ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 REVENUES Sales Tax $5,484,940 $5,972,496 $5,603,676 $6,128,288 Franchise Tax 92,579 92,286 96,127 122,254 Interest Income 5,787 1,541 5,710 3,299 SRO Reimbursement(BISD) 240,826 241,494 327,419 327,419 Other 58,063 38,582 205,345 205,345 TOTAL REVENUES $5,882,196 $6,346,399 $6,238,277 $6,786,605 APPROPRIATION OF FUND BALANCE Contribution from the General Fund $0 $0 $0 $0 Appropriation of Fund Balance 0 0 0 180,966 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $180,966 TOTAL RESOURCES $5,882,196 $6,346,399 $6,238,277 $6,967,571 EXPENDITURES OPERATING EXPENDITURES Administration $8,055 $17,474 $17,147 $17,147 Community Resources 1,011,646 1,049,119 1,094,707 1,316,363 Victim Assistance Program 113,303 64,092 81,682 81,780 Investigations 423,855 447,264 531,596 531,257 Uniform Patrol 3,008,598 3,053,990 3,338,019 3,341,212 Technical Services 523,131 554,933 557,147 558,211 Property Evidence 231,250 106,904 163,064 163,064 Partner Agency Funding 43,009 44,426 46,770 46,770 Non-Departmental 105,052 115,943 132,395 127,607 TOTAL OPERATING EXPENDITURES $5,467,899 $5,454,144 $5,962,527 $6,183,411 OTHER&RESERVES Operating Transfers $30,156 $16,780 $43,750 $43,750 Capital Project Transfers 0 0 232,000 660,000 Planned Contribution to Fund Balance 0 0 0 80,410 TOTAL OTHER&RESERVES $30,156 $16,780 $275,750 $784,160 TOTAL EXPENDITURES $5,498,055 $5,470,924 $6,238,277 $6,967,571 • BALANCE $384,141 $875,475 $0 $0 • Ordinance No.3751 Attachment"A" Page 16 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 10-SUMMARY OF REVENUES AND EXPENDITURES PROMOTIONAL FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 REVENUES Occupancy Tax Proceeds $254,203 $313,649 $280,000 $280,000 Interest Income 9,897 5,887 5,843 4,074 Other 0 0 1,221 1,221 TOTAL OPERATING REVENUES $264,099 $319,536 $287,064 $285,295 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $0 $1,000 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $1,000 TOTAL RESOURCES $264,099 $319,536 $287,064 $286,295 EXPENDITURES OPERATING EXPENDITURES Economic Development $115,254 $101,446 $131,154 $131,243 Cultural&Leisure 127,244 100,043 143,555 144,555 Non-Departmental 222 133 6,438 6,349 TOTAL OPERATING EXPENDITURES $242,720 $201,621 $281,147 $282,147 OTHER&RESERVES Planned Contributions to Fund Balance $0 $0 $5,917 $4,148 TOTAL OTHER&RESERVES $0 $0 $5,917 $4,148 TOTAL EXPENDITURES $242,720 $201,621 $287,064 $286,295 BALANCE $21,379 $117,915 $0 $0 Ordinance No.3751 Attachment"A" Page 17 of 30 • FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 11-SUMMARY OF REVENUES AND EXPENDITURES DONATIONS FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 REVENUES Parks&Recreation Program Donations $44,640 $39,193 $44,550 $44,550 Library Program Donations 45,734 32,851 38,800 38,800 Neighborhood Services Program Donations 96,339 126,844 55,610 58,652 Public Safety Program Donations 27,900 17,030 8,800 8,800 Teen Court Program Donations 2,399 2,123 4,000 4,005 Investment Income 9,602 5,684 9,076 3,944 TOTAL REVENUES $226,615 $223,725 $160,836 $158,751 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $58,806 $0 $97,719 $97,729 TOTAL APPROPRIATION OF FUND BALANCE $58,806 $0 $97,719 $97,729 TOTAL RESOURCES $285,421 $223,725 $258,555 $256,480 EXPENDITURES OPERATING EXPENDITURES Parks&Recreation Programs $60,665 $20,422 $59,865 $59,865 Library Programs 43,232 32,868 52,391 52,401 Neighborhood Services Programs 46,742 22,462 98,423 102,465 Public Safety Programs 10,991 1,720 34,800 35,300 Teen Court Program 4,500 2,350 4,000 4,000 TOTAL OPERATING EXPENDITURES $166,129 $79,822 $249,479 $254,031 OTHER&RESERVES Capital Project Transfers $0 $30,632 $0 $0 Planned Contribution to Fund Balance 0 0 0 0 TOTAL OTHER&RESERVES $0 $30,632 $0 $0 TOTAL EXPENDITURES $166,129 $110,454 $249,479 $254,031 BALANCE $119,291 $113,271 $9,076 $2,449 Ordinance No.3751 Attachment"A" Page 18 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 12-SUMMARY OF REVENUES AND EXPENDITURES SPECIAL INVESTIGATIONS FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 REVENUES Federal Forfeited Funds $20,076 $78,598 $50,000 $75,000 State Forfeited Funds 36,191 45,428 30,000 30,000 Local Forfeited Funds 672 2,568 1,000 1,000 AFIS Program Revenues 14,500 8,850 14,500 14,500 Other Income 5,547 3,404 0 2,400 TOTAL REVENUES $76,986 $138,846 $95,500 $122,900 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $195,000 $140,838 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $195,000 $140,838 TOTAL RESOURCES $76,986 $138,846 $290,500 $263,738 EXPENDITURES OPERATING EXPENDITURES Federal Forfeited Funds $35,171 $55,959 $150,000 $150,000 State Forfeited Funds 14,400 44,320 105,000 85,000 Local Forfeited Fund 0 0 1,000 1,000 AFIS Maintenance&Equipment 7,594 14,996 14,500 15,738 Leose Contributions 0 0 20,000 12,000 TOTAL OPERATING EXPENDITURES $57,165 $115,274 $290,500 $263,738 OTHER&RESERVES Planned Contribution to Fund Balance $0 $0 $0 $0 TOTAL OTHER&RESERVES $0 $0 $0 $0 TOTAL EXPENDITURES $57,165 $115,274 $290,500 $263,738 BALANCE $19,821 $23,572 $0 $0 Ordinance No.3751 Attachment"A" Page 19 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 13-SUMMARY OF REVENUES AND EXPENDITURES DRAINAGE UTILITY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 REVENUES Drainage Fees $1,703,926 $1,724,725 $1,684,000 $1,684,000 Interest Income 14,938 14,648 6,241 15,478 Other 0 0 820 820 TOTAL REVENUES $1,718,864 $1,739,373 $1,691,061 $1,700,298 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $0 $0 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $0 $0 TOTAL RESOURCES $1,718,864 $1,739,373 $1,691,061 $1,700,298 EXPENDITURES OPERATING EXPENDITURES Public Works Administration $0 $0 $0 $0 Drainage Utility Crew $30,000 $57,900 $154,450 $154,450 Non-Departmental 3,070 (386) 5,100 5,100 Debt Service Payments 248,181 220,675 219,200 219,200 TOTAL OPERATING EXPENDITURES $281,251 $278,189 $378,750 $378,750 OTHER&RESERVES Capital Project Transfers $575,000 $450,000 $310,000 $310,000 Planned Contribution to Fund Balance 0 0 1,002,311 1,011,548 TOTAL OTHER&RESERVES $575,000 $450,000 $1,312,311 $1,321,548 TOTAL EXPENDITURES $856,251 $728,189 $1,691,061 $1,700,298 BALANCE $862,613 $1,011,184 $0 $0 Ordinance No.3751 Attachment"A" Page 20 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 14-SUMMARY OF REVENUES AND EXPENDITURES GAS DEVELOPMENT FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 REVENUES Gas Royalty Revenue $407,632 $659,356 $470,000 $705,973 Interest Income 27,076 3,589 3,453 5,592 Other Income 0 0 0 0 TOTAL REVENUES $434,708 $662,945 $473,453 $711,565 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $2,607,281 $0 $0 $0 TOTAL APPROPRIATION OF FUND BALANCE $2,607,281 $0 $0 $0 TOTAL RESOURCES $3,041,989 $662,945 $473,453 $711,565 EXPENDITURES OPERATING Transfer to Capital Projects $2,290,000 $0 $0 $0 Interfund Loan 751,989 0 0 0 Miscellaneous Expenditures 0 0 0 41,000 TOTAL OPERATING EXPENDITURES $3,041,989 $0 $0 $41,000 OTHER&RESERVES Planned Contribution to Fund Balance $0 $0 $473,453 $670,565 TOTAL OTHER&RESERVES $0 $0 $473,453 $670,565 TOTAL EXPENDITURES $3,041,989 $0 $473,453 $711,565 BALANCE ($0) $662,945 $0 $0 Ordinance No.3751 Attachment"A" Page 21 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 15-SUMMARY OF REVENUES AND EXPENDITURES TRAFFIC SAFETY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 REVENUES Gross Fine Revenues $34,250 $0 $0 $0 Interest Income 11,185 5,998 8,366 3,485 TOTAL REVENUES $45,435 $5,998 $8,366 $3,485 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $302 $54,274 $120,738 $130,474 TOTAL APPROPRIATION OF FUND BALANCE $302 $54,274 $120,738 $130,474 TOTAL RESOURCES $45,737 $60,272 $129,104 $133,959 EXPENDITURES OPERATING EXPENDITURES Contractor Payments $0 $0 $0 $0 Program Administration 0 0 0 0 Payment to State 0 17,282 0 0 Traffic Enforcement/Traffic Safety 28,491 18,474 92,545 92,545 Pedestrian Safety 17,246 24,516 36,559 41,414 TOTAL OPERATING EXPENDITURES $45,737 $60,272 $129,104 $133,959 OTHER&RESERVES Contribution to Reserves $0 $0 $0 $0 TOTAL OTHER&RESERVES $0 $0 $0 $0 TOTAL EXPENDITURES $45,737 $60,272 $129,104 $133,959 BALANCE ($1) $0 $0 $0 Ordinance No.3751 Attachment"A" Page 22 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 16-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 REVENUES WATER CHARGES Water Charges $24,185,998 $23,629,044 $25,322,450 $25,322,450 Water Prior Year Settle-up 320,263 697,768 0 728,118 Water Taps 49,900 60,265 44,200 44,200 Water Inspection Fees 47,857 46,378 24,000 24,000 TOTAL WATER CHARGES $24,604,018 $24,433,455 $25,390,650 $26,118,768 SEWER TREATMENT CHARGES Sewer Treatment Charges $12,055,090 $12,162,925 $13,172,120 $13,172,120 Sewer Prior Year Settle-Up 33,699 238,938 0 275,830 Sewer Taps 14,700 17,750 12,600 12,600 Sewer Inspection Fees 19,315 32,581 24,000 24,000 TOTAL SEWER TREATMENT CHARGES $12,122,804 $12,452,194 $13,208,720 $13,484,550 MISCELLANEOUS Interest Income $187,814 $96,480 $107,568 $65,779 Service Charges 112,746 127,163 144,500 144,500 Late Charges 347,698 482,758 420,000 420,000 Miscellaneous 63,152 3,317,827 74,928 74,928 Joint Use Reimbursement-Watauga 102,925 0 57,132 57,132 Subdivision Meter Revenue 62,109 66,878 57,825 52,545 TOTAL MISCELLANEOUS $876,444 $4,091,106 $861,953 $814,884 TOTAL REVENUE $37,603,266 $40,976,755 $39,461,323 $40,418,202 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $15,920 $0 $0 $149,637 TOTAL APPROPRIATION OF FUND BALANCE $15,920 $0 $0 $149,637 TOTAL RESOURCES $37,619,186 $40,976,755 $39,461,323 $40,567,839 Ordinance No.3751 Attachment"A" Page 23 of 30 FISCAL YEAR 2021-2022 SCHEDULE 16-SUMMARY OF REVENUES AND EXPENDITURES UTILITY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 EXPENDITURES WATER SERVICES Water Operations $4,693,705 $4,464,930 $4,840,524 $4,855,279 Purchase of Water FTW 2,726,909 4,076,463 4,291,978 4,291,978 Purchase of Water TRA 7,448,048 6,739,361 7,094,606 7,094,606 TOTAL WATER SERVICES $14,868,662 $15,280,754 $16,227,108 $16,241,863 SEWER TREATMENT SERVICES Sewer Operations $1,309,758 $1,408,171 $1,549,104 $1,550,376 Sewer Treatment FTW 1,415,527 1,109,843 1,578,734 1,578,734 Sewer Treatment TRA 5,392,857 4,848,797 5,216,504 5,216,504 TOTAL SEWER TREATMENT SERVICES $8,118,142 $7,366,811 $8,344,342 $8,345,614 UTILITY BILLING&FINANCIAL SERVICES Utility Meter Reading $566,430 $539,736 $580,432 $580,609 Utility Billing&Customer Service 982,323 1,021,948 1,092,070 1,092,780 Utility Collection Services 241,454 239,398 264,329 264,329 Accounting Services 408,603 406,705 467,548 468,214 Budget&Research 232,038 222,253 250,188 250,277 TOTAL UTILITY BILLING&FINANCIAL $2,430,849 $2,430,039 $2,654,567 $2,656,209 OTHER OPERATING EXPENDITURES Administration $358,998 $353,809 $375,600 $375,954 Development 912,495 872,882 1,014,666 1,015,322 Right of Way Maintenance 286,056 271,565 354,107 362,644 Utility Construction Crew&Support 0 (0) 1,315,550 1,315,592 Building Services 1,822,929 1,822,929 1,822,929 1,822,929 Non Departmental 290,037 200,852 333,428 1,121,187 TOTAL OTHER OPERATING $3,670,516 $3,522,037 $5,216,280 $6,013,628 TOTAL DEPARTMENT EXPENDITURES $29,088,169 $28,599,641 $32,442,297 $33,257,314 OTHER&RESERVES Debt Service $1,666,986 $1,646,296 $1,659,215 $1,659,215 Bond Defeasance/Refunding 208,323 0 0 0 Franchise Fees 1,087,873 1,063,691 1,156,068 1,156,068 Indirect Costs 2,182,170 2,182,170 2,182,170 2,182,170 Payment in Lieu of Taxes 405,201 410,217 405,242 405,242 Transfer for IT Purchases&Support 175,000 175,000 175,000 175,000 Transfer to Capital 901,657 2,278,011 665,000 793,620 Planned Contribution to Fund Balance 0 0 776,331 939,210 TOTAL OTHER&RESERVES $6,627,211 $7,755,384 $7,019,026 $7,310,525 TOTAL EXPENDITURES $35,715,379 $36,355,026 $39,461,323 $40,567,839 BALANCE $1,903,807 $4,621,729 $0 $0 Ordinance No.3751 Attachment"A" Page 24 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 17-SUMMARY OF REVENUES AND EXPENDITURES AQUATIC PARK FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 ATTENDANCE 12,501 185,971 190,000 190,000 REVENUES OPERATING Admissions $206,779 $3,261,828 $3,096,162 $3,316,162 Advanced&Group Sales 0 0 0 0 Food and Beverage 60,771 995,186 806,437 936,409 Merchandise 8,564 195,790 142,583 169,187 Rentals 11,103 145,621 171,100 171,100 TOTAL OPERATING $287,217 $4,598,425 $4,216,282 $4,592,858 OTHER REVENUES Interest Income $19,774 $10,955 $0 $13,800 Other Income 1,419 43,120 65,192 65,192 TOTAL OTHER REVENUES $21,194 $54,075 $65,192 $78,992 TOTAL REVENUES $308,411 $4,652,500 $4,281,474 $4,671,850 APPROPRIATION OF FUND BALANCE Interfund Loan $2,309,693 $69,356 $0 $0 Appropriation of Fund Balance 0 0 0 0 TOTAL APPROPRIATION OF FUND BALANCE $2,309,693 $69,356 $0 $0 TOTAL RESOURCES $2,618,104 $4,721,856 $4,281,474 $4,671,850 EXPENDITURES OPERATING General Services&Utilities $536,106 $773,388 $744,050 $792,487 Public Grounds/Aquatics/Maint. 828,326 1,023,805 1,166,365 1,354,887 Business&Office Administration 233,377 315,701 420,697 420,932 Gift Shop/Concessions 230,128 640,976 602,043 750,790 Sales/Special Events/Admissions 212,667 253,064 274,660 324,918 Non-Departmental 54,875 60,510 90,099 88,325 TOTAL OPERATING $2,095,480 $3,067,443 $3,297,914 $3,732,339 OTHER&RESERVES Debt Service $752,722 $735,129 $0 $717,238 Debt Defeasance/Refunding/Agent Fees 969 969 1,050 1,050 Transfer to Capital Projects 100,000 100,000 100,000 100,000 Transfer Out General Fund 0 0 0 0 Planned Contribution to Fund Balance 0 0 882,510 121,223 TOTAL OTHER&RESERVES $853,691 $836,098 $983,560 $939,511 TOTAL EXPENDITURES $2,949,171 $3,903,541 $4,281,474 $4,671,850 BALANCE ($331,067) $818,315 $0 $0 Ordinance No.3751 Attachment"A" Page 25 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 18-SUMMARY OF REVENUES AND EXPENDITURES GOLF COURSE FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY Y 2020/21 FY 2021/22 FY 2021/22 ROUNDS 46,915 18,961 47,000 47,000 REVENUES OPERATING REVENUE Green Fees $330,437 $1,542,553 $1,210,000 $1,719,940 Pro Shop 290,360 448,768 447,500 266,275 Driving Range 39,974 88,956 80,000 289,588 Carts 114,147 346,721 428,500 306,169 Food&Beverage 262,630 520,594 640,000 573,748 General&Administrative 0 0 0 0 Miscellaneous 77,003 40,363 37,572 17,750 TOTAL OPERATING REVENUE $1,114,551 $2,987,956 $2,843,572 $3,173,470 RESERVES&INTERFUND LOANS Interfund Loan $751,989 $0 $0 $0 Appropriation of Fund Balance 100,000 0 0 51,502 TOTAL USE OF RESERVES&INTERFUND LOANS $851,989 $0 $0 $51,502 TOTAL RESOURCES $1,966,540 $2,987,956 $2,843,572 $3,224,972 EXPENDITURES OPERATING • Pro Shop $116,296 $133,129 $203,620 $197,669 Pro Shop:Cost of Goods Sold 64,651 152,758 153,000 162,544 Driving Range 13,446 25,476 22,750 31,633 Golf Carts 178,899 254,462 220,204 284,941 Course Maintenance 617,473 680,166 581,725 829,884 Food&Beverage 171,591 244,805 305,380 315,221 Food&Beverage:Cost of Goods Sold 89,718 150,476 179,200 179,188 Sales&Membership 0 48,747 79,600 113,563 General&Administrative 327,756 378,306 307,270 463,135 Clubhouse 99,469 123,149 89,910 0 Management Fees 141,127 164,363 154,920 161,416 Equipment Repair and Replacement 0 59,611 202,256 94,586 TOTAL OPERATING $1,820,426 $2,415,449 $2,499,835 $2,833,780 OTHER&RESERVES Debt Service $190,563 $328,439 $321,940 $321,940 Transfer to Capital Projects 100,000 0 0 0 Planned Contribution to Reserves 0 0 21,797 69,252 TOTAL OTHER&RESERVES $290,563 $328,439 $343,737 $391,192 . TOTAL EXPENDITURES $2,110,989 $2,743,888 $2,843,572 $3,224,972 BALANCE ($144,449) $244,068 $0 $0 Ordinance No.3751 Attachment"A" Page 26 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 19-SUMMARY OF REVENUES AND EXPENDITURES FACILITIES/CONSTRUCTION MANAGEMENT FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 REVENUES CHARGES FOR SERVICE Transfer From: General Fund $812,101 $812,101 $812,101 $812,101 Park Development Fund 277,788 276,414 275,090 275,090 Utility Fund 1,822,929 1,822,929 1,822,929 1,822,929 SUB-TOTAL $2,912,818 $2,911,444 $2,910,120 $2,910,120 OTHER REVENUES Interest Income $43,233 $25,711 $21,248 $17,098 Rent From Rental Properties 41,270 39,810 39,600 39,600 Other Income 0 158,570 6,255 6,256 SUB-TOTAL $84,504 $224,092 $67,103 $62,954 TOTAL REVENUES $2,997,322 $3,135,536 $2,977,223 $2,973,074 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $0 $76,095 $233,893 TOTAL APPROPRIATION OF FUND BALANCE $0 $0 $76,095 $233,893 TOTAL RESOURCES $2,997,322 $3,135,536 $3,053,318 $3,206,967 EXPENDITURES OPERATING EXPENDITURES Administration $263,396 $249,310 $247,722 $249,576 Building Services 2,241,723 2,352,799 2,715,817 2,868,676 Rental Property Program 21,208 14,848 36,120 36,120 Non-Departmental 19,232 15,094 53,659 52,595 TOTAL OPERATING EXPENDITURES $2,545,559 $2,632,051 $3,053,318 $3,206,967 OTHER&RESERVES Capital Project Transfers $96,500 $274,400 $0 $0 Planned Contribution to Fund Balance 0 0 0 0 TOTAL OTHER&RESERVES $96,500 $274,400 $0 $0 TOTAL EXPENDITURES $2,642,059 $2,906,451 $3,053,318 $3,206,967 BALANCE $355,263 $229,084 $0 $0 Ordinance No.3751 Attachment"A" Page 27 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 20-SUMMARY OF REVENUES AND EXPENDITURES FLEET SERVICES FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 REVENUES CHARGES FOR SERVICE General Fund $1,389,677 $1,389,677 $1,389,677 $1,389,677 Utility Fund 2,256,325 2,256,325 2,256,325 2,256,325 Crime Control District Fund 170,426 170,426 170,426 170,426 Park&Recreation Dev.Fund 171,939 171,939 171,939 171,939 Other Funds 24,119 24,119 24,119 24,119 TOTAL CHARGES FOR SERVICE $4,012,486 $4,012,486 $4,012,486 $4,012,486 OTHER REVENUES Interest Income $42,856 $26,272 $30,942 $19,624 Sale of City Property 191,836 137,967 20,000 20,000 Other Income 34,803 11 7,240 7,240 Transfer from General Fund 28,875 169,465 0 0 TOTAL OTHER REVENUES $298,371 $333,714 $58,182 $46,864 TOTAL REVENUES $4,310,857 $4,346,200 $4,070,668 $4,059,350 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $165,623 $0 $0 $1,288,099 TOTAL APPROPRIATION OF FUND BALANCE $165,623 $0 $0 $1,288,099 TOTAL RESOURCES $4,476,480 $4,346,200 $4,070,668 $5,347,449 EXPENDITURES OPERATING EXPENDITURES Administration $288,411 $293,230 $297,188 $297,188 Fleet Services Operations 1,565,753 1,493,180 1,727,206 1,906,404 Fire Fleet Maintenance Operations 349,944 335,687 345,626 357,803 Vehicle and Equipment Purchases 1,196,067 496,898 783,259 1,909,204 Non-Departmental 18,509 19,459 53,062 51,998 TOTAL OPERATING EXPENDITURES $3,418,685 $2,638,453 $3,206,341 $4,522,597 OTHER&RESERVES Debt Service $0 $252,300 $191,575 $243,300 Transfer to General Fund 498,973 416,332 446,552 446,552 Capital Project Transfers 558,822 169,465 135,000 135,000 Planned Contribution to Fund Balance 0 0 91,200 0 TOTAL OTHER&RESERVES $1,057,795 $838,097 $864,327 $824,852 TOTAL EXPENDITURES $4,476,480 $3,476,550 $4,070,668 $5,347,449 BALANCE $0 $869,650 $0 $0 Ordinance No.3751 Attachment"A" Page 28 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 21-SUMMARY OF REVENUES AND EXPENDITURES INFORMATION TECHNOLOGY FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY2019/20 FY2020/21 FY2021/22 FY2021/22 REVENUES CHARGES FOR SERVICE General Fund $1,405,271 $1,458,565 $1,680,445 $1,680,445 Park Fund 155,999 172,776 228,161 228,161 Crime Control District 249,991 252,093 320,693 320,693 Utility Fund 1,065,770 1,065,770 1,218,245 1,218,245 Other Funds 364,410 365,884 394,784 394,784 TOTAL CHARGES FOR SERVICE $3,241,441 $3,315,088 $3,842,328 $3,842,328 OTHER REVENUES Transmitter Lease $176,960 $188,149 $175,000 $175,000 Reimbursement from General Fund 209,154 167,737 148,613 296,555 Interest Income 24,896 13,831 18,592 8,500 Other Income 61,217 4,113 10,204 15,354 TOTAL OTHER REVENUES $472,227 $373,830 $352,409 • $495,409 TOTAL REVENUES $3,713,668 $3,688,918 $4,194,737 $4,337,737 APPROPRIATION OF FUND BALANCE Appropriation of Fund Balance $0 $74,738 $0 $327,038 TOTAL APPROPRIATION OF FUND BALANCE $0 $74,738 $0 $327,038 TOTAL RESOURCES $3,713,668 $3,763,656 $4,194,737 $4,664,775 EXPENDITURES • OPERATING EXPENDITURES General Services $278,069 $326,034 $233,848 $396,848 Major Computer Systems 315,917 363,211 566,547 566,901 Microcomputer Systems 825,548 839,318 910,697 999,483 Telecommunications 474,742 360,633 361,195 379,365 Data Network 629,630 753,226 1,117,151 1,298,827 GIS System 181,397 188,166 184,487 192,537 Public Safety 548,317 761,335 744,081 774,988 Non-Departmental 47,410 11,733 58,310 55,826 TOTAL OPERATING EXPENDITURES $3,301,030 $3,603,656 $4,176,316 $4,664,775 OTHER&RESERVES Transfer to Capital Projects $485,510 $160,000 $0 $0 Planned Contribution to Fund Balance 0 0 18,421 0 TOTAL OTHER&RESERVES $485,510 $160,000 $18,421 $0 TOTAL EXPENDITURES $3,786,540 $3,763,656 $4,194,737 $4,664,775 BALANCE ($72,872) ($0) $0 $0 Ordinance No.3751 Attachment"A" Page 29 of 30 FISCAL YEAR 2021-2022 REVISED BUDGET SCHEDULE 22-SUMMARY OF REVENUES AND EXPENDITURES SELF INSURANCE FUND ADOPTED REVISED ACTUAL ACTUAL BUDGET BUDGET FY 2019/20 FY 2020/21 FY 2021/22 FY 2021/22 REVENUES HEALTH&MEDICAL CONTRIBUTIONS Health&Medical(City Contribution) $10,427,050 $10,415,739 $10,353,367 $10,444,827 Health&Medical(Employee Contribution) 2,659,633 2,665,771 2,658,755 2,507,755 TOTAL HEALTH&MEDICAL CONTRIBUTIONS $13,086,683 $13,081,510 $13,012,122 $12,952,582 OTHER CONTRIBUTIONS Worker's Comp&Admin(City Contribution) $1,108,512 $1,106,171 $1,110,634 $1,119,864 Other Insurance(City Contribution) 819,608 876,262 944,304 944,304 Flexible Spending Account(Employee Contribution) 143,515 119,970 146,000 146,000 TOTAL OTHER CONTRIBUTIONS $2,071,635 $2,102,404 $2,200,938 $2,210,168 OTHER REVENUES Stop Loss Reimbursement $107,717 $76,137 $400,000 $400,000 Interest Income 143,731 112,846 130,164 90,694 Other Income 72,040 151,269 3,634 34,634 TOTAL OTHER REVENUES $323,487 $340,252 $533,798 $525,328 TOTAL REVENUES $15,481,804 $15,524,167 $15,746,858 $15,688,078 APPROPRIATION OF FUND BALANCE Self Insurance Fund Reserves $100,000 $0 $100,000 $287,053 TOTAL APPROPRIATION OF FUND BALANCE $100,000 $0 $100,000 $287,053 TOTAL RESOURCES $15,581,804 $15,524,167 $15,846,858 $15,975,131 EXPENDITURES Health&Medical $8,687,168 $8,980,150 $12,652,917 $9,786,938 Worker's Compensation 375,971 445,152 595,000 601,944 Personnel Expenses 476,372 500,566 536,276 656,027 Property,Liability,and Other Insurance 907,844 987,680 944,303 944,330 Flexible Spending Account Expense 127,960 122,577 146,000 146,000 Non-Departmental 79,350 0 0 27,000 TOTAL OPERATING EXPENDITURES $10,654,666 $11,036,125 $14,874,496 $12,162,239 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 872,362 3,712,892 TOTAL OTHER&RESERVES $100,000 $100,000 $972,362 $3,812,892 TOTAL EXPENDITURES $10,754,666 $11,136,125 $15,846,858 $15,975,131 BALANCE $4,827,139 $4,388,041 $0 $0 Ordinance No.3751 Attachment"A" Page 30 of 30 TA,"'ilkriry'474141...A.r.AW-AritAki ' �K:° . ° 1§ V� 4. " i44.Lvey o ff. -• c ,i ids t e ;:. •° • per {„ .. � T ;[ °�'• a44 no. �S ��,' '.A. �tW`St�hlCtl, a°4 ;� �':` .,S yAnr _ •t - fix y. •h a{fMi Pa.Arum • 3 a ti w- „k • • 5 " ,. • P E`° w w S i t R .M�� se, � � �+�' "ter n A Y .,gym , x ..,� --**4•m'w Vie. r.: a 4� t a ...X 7 �`" ,' • 7 !an^:t*rw""'" -� # ' S ti g °§'fire ..-;?'• _ "*a gam- « 1r�� ma ' sreg _ 0 . •, • o M s r!• ` ca x NSF 8r 9 sA ws ✓ r ..: 4 I� �., .. g" ,. ,� .ft d r X n '� x, . E " Sys `-" �. t j�:, A A.-. »b �,a .:in, •.%sr. *,sj,r.fr, 'c ti�� 444I`G _ p. -s rr4111, w a ._ � ,.. �.t -rL� ys3 ..ray .. wi ,, -t, q.-.. ,, --., .',.��i �x : kN, P'�f s y a'" "�t*� r:``'.{i Tyr# d .'';•r,� ..-y a `+ " � . :. •.... . . 'SCT 'R it Allk ] a q 5 7+ '. +^ii'n- ,., bias '',""s ' 's °A.'d 'L' .• ••e . A.• 1 )w q"x BtAl ,x •' ears t • • : RE V I S .E • . ........, • •,:• ... ,• ,_ . . . . •. . . . . . .. . . . .... .. . . • • , •., • . . . , •• • . , . . , . . ... . . • '; �* ,. 'LV ° ...17 w "§'a 3 n V a"siv.."M'.e" .;.mac ,_,. T 7 ' x 4 2.,s " x .:, ,., .,Twd"k e z r N F.. _ .,i,,."Ai -i dh` o -``az,m.<:a,..R+"n€-._ 404, d :.mac.,_ , V ., `'° m "s' * � 'i'�i, r x w ri-+,« ,fie; ..,. .. is ��,::i�H �s• a *' ,asy ti, . , :, . , .. '; T. rwwr^+;Ga:iii h 5 A,, r S 1 d', y1.,r `��t:�Ii NI �, ' i� t, ':xoy ..ao..,rem n ..A ° `', 1.I�A. �"II4 .T,�'.g iiia X #_ a-` ii h 6,?i-Ik ,,..;., x'a o-i a§M _ Eit -..,, ° � ,..crs'a*<^. >t•°,g �e� r,,.. � �9 i i {iNi ''ii �'�i d i x� r c � ��t� � °i,� � � , 4 �,a � � � '� � °°"a-y,53.1d .: .g' r; ,».r' ,w, im.( 0,041 41111 �h ':=1'4�: § 'F M1r^.t ' I w ^«ix ''. S� , . `§t'$ 4x�.,, .�' °�. e ff..+F. 1",;;i`. P', s"�_FA �� 1,I„.�x o f- in i:i<';"`-"''-_.' §�,iar1,w''.`tN.. i. „. �. -._ r , ,,,,.* 4-t i t , �`. q T �, -,�=� �".� - �ii g6,aw"���4(� ��i tl� ',�: °h„k k5,a§`�§V:�gp � .ti,Cryi eal�e �<Ytea P RtU,i:n,mr,�IT„x t"r+kf � 'G r � 5.. < v+ ,�A 3 i �; �. .°'. ..• • sv€.g p:;yqy;�A1'a Y `;�"•'¢ * � .����I al���t+. ' x"' '�' -y-a,.. 'geY 1 ��`'"x,�a�� {�d'ti'� `'�r � - CCr w '' ��t7+ - _' .° •' ...4:,eM1a.7. •~. ., �,o 'fi t '"� sa"� " x.i ,:`„fig �r da.:,t _.. ° r w *tea a, -a �s w °'' �"�"t ix�yx�' �' y ...,-'. ' 41* ,,,,- =;,� ,,. ,a„_04, QC{ 1$Tl6e,:7N .3,7 1 v 11 t"'n w r Y F, ° e. • •s ,. _'''. � .,t'zs �e.= s.":,,. .-ai '` x •..,_* _ ... . . �.... ', ,.....,.a.� �.": �€ Wit; Schedule 11 2021-22 Budget Revisions Budget Summary Adopted Budget 2021-22 Project Project Through Revision Revised Number Name ' 2021-22 2021-22 Budget STREET&SIDEWALK CAPITAL PROJECTS ST2003 Northeast Parkway I Davis Blvd.Traffic Signal $355,000 $150,000 $505,000 ST2113 North Hills Drive Reconstruction $2,120,000 ($1,105,000) $1,015,000 ST2114 Meadow Oak Drive Reconstruction $570,000 $45,000 $615,000 ST2118 Diamond Loch West Courts Reconstruction $130,000 $75,000 $205,000 ST2111 Bedford Euless Road Reconstruction $3,415,000 $1,425,000 $4,840,000 Sub-Total $6,590,000 $590,000 $7,180,000 PARKS&RECREATION CAPITAL PROJECTS PK2104 Park Infrastructure Maintenance $144,000 $2,157 $146,157 PK1606 Park System Signage 474,486 (2,157) 472,329 PK2105 Richfield Park Tennis/Pickleball Court Replacement 265,000 67,075 332,075 PK1806 Trail and On Road Safety Projects 735,543 1,000 736,543 PK2007 Fossil Creek Park Mountain Bike Trails 120,000 (1,000) 119,000 Sub-Total $1,739,029 $67,075 $1,806,104 UTILITY CAPITAL PROJECTS UT1607 Walker Branch Interceptor Project $4,916,525 $0 $4,916,525 UT2006 Utility Risk and Resiliency 150,000 50,000 200,000 UT2105 SCADA Communication Replacement 75,000 (50,000) 25,000 UT2206 Big Fossil Interceptor Rehabilitation Project 2,510,000 0 2,510,000 UT2209 Generator feasibility study Public Works 0 128,620 128,620 Sub-Total $7,651,525 $128,620 $7,780,145 FACILITY CAPITAL PROJECTS FC2102 Roof Replacement Fire Station 1 $132,000 $64,999 $196,999 FC2104 Concrete Drive Repair at FS#2,FS#5 and Service Center 74,400 (29,505) $44,895 FC2208 Public Works Pump Stations 0 97,650 $97,650 FC2214 Custodial/Overhead Door Repairs 0 6,000 $6,000 FC2212 9KVA UPS for Distributed Antenna System 0 20,000 $20,000 FC2210 Bathroom flooring replacement 0 12,300 $12,300 FC2215 Equipment Replacement and Floor Drain 0 21,200 $21,200 FC2200 Generator Feasibility Study and Equipment 0 853,000 $853,000 FC2209 Interior/Exterior painting 0 71,000 $71,000 FC2213 Public Library Lighting Controls 0 77,500 $77,500 FC2211 Public Library painting 0 132,000 $132,000 Sub-Total $206,400 $1,326,144 $1,532,544 FLEET SERVICES PROJECTS FS2201 Ambulance Replacement(Unit 980) $385,000 ($25,000) $360,000 FS2205 Fleet Tire Machine 0 39,232 39,232 FS2204 PD FOUR(4)SUV FLEET PURCHASE 0 209,409 209,409 FS2206 POLICE DEPARTMENT MOTORCYCLE PURCHASE 0 44,860 44,860 Sub-Total $385,000 $268,501 $653,501 INFORMATION TECHNOLOGY PROJECTS IT2202 Backup Fiber for City Hall $0 $183,100 $183,100 IT2208 Eventide Dispatch Recorder software/hardware $0 82,000 $82,000 IT2210 Purchase and implementation of Digital Signature Software $45,000 25,000 70,000 IT2203 Replacement of Mobile Computers in Public Safety Vehicles $0 430,000 $430,000 IT2207 Replacement of Nexus 4500x network switches in City Hall Data $0 153,000 $153,000 Center IT2205 SCADA System Upgrade $0 60,000 $60,000 IT2206 Security Camera and Access Control Upgrade and Additions $0 340,000 $340,000 IT2212 Cybersecurity Assessment $0 90,000 $90,000 IT2211 Fire Radio Replacement $0 395,215 $395,215 IT2201 Replacement of Spillman CAD/RMS Servers $232,000 128,000 $360,000 IT2214 Interview Room Video Storage Replacement $0 150,000 $150,000 IT2215 Forensic Digital Evidence Storage $0 150,000 $150,000 Sub-Total $277,000 $2,186,315 $2,463,315 Total All Projects $16,848,954 $4,566,655 $21,415,609 Ordinance No.3751 2 Attachment"B" Page 2 of 52 Schedule 11 2021-22 Budget Revisions Budget Summary Adopted Budget 2021-22 Project Project Through Revision Revised Number Name 2021-22 2021-22 Budget SOURCES OF FUNDS General Obligation Bonds $6,235,000 $0 $6,235,000 Certificates of Obligations $4,781,525 $0 $4,781,525 Federal/State Grants $961,217 $3,317,466 $4,278,683 Reserves $1,252,726 $1,249,189 $2,501,915 Sales Tax $618,486 $0 $618,486 - - Other $3,000,000 $0 $3,000,000 Total Sources of Funds $16,848,954 $4,566,655 $21,415,609 Ordinance No.3751 3 Attachment"B" Page 3 of 52 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 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering 02/2020 04/2020 08/2020 11/2021 Land/ROW Acquisition Construction 09/2020 09/2021 04/2021 05/2022 Other REVISION EXPLANATION Transfer of funds from the Davis/Creek View signal project(ST1005)is needed to provide additional construction funding for the signalization at Northeast Parkway and Davis as a result of TxDOT requirements for a deceleration lane and accompanying environmental study. • FINANCIAL DATA ADOPTED t4ItakPi(ii'li REVISED TOTAL 'P'ROEC BUDGET THRU JJTijl1 BUDGET THRU REMAINING PROJECT 2021/22 g REVISION ��'" 2021/22 BALANCE COST ,, +y,iyFz: io-`�° (i ci Pik it i� i� y9H �I��tia �I'q�'�ii Ia� ` I'S(�ill7�x':� (x�i 4u�.�G',„1 s!a a=. R- UND�N� SOURCES .�. a yw� IIG N� �i i�pia�i.i ��'s �I���i ""� _ �l Certificates of Obligation $355,000 ° �11,011 Gm6�i"b�$0 $355,000 $0 $355,000 Reserves 0 ii,'0 150,000 150,000 0 $150,000 0ii, : 01 0 0 0 fi 'eh '347 + " 0 0 $0 0316 a i v0f 0 (] $o Total $355,000 , p$150,000' $505,000 $0 $505,000 PROJECT'EXPENDITURES r _b WAS " " t;`;n+. ,. „ `* ° FaI a': a N, YIP9(rii99 ei! � Professional Services $0 9���� ���J ;��ii" 11$0 $0 $0 $0 Engineering/Design 80,000 0,000 110,000 0 $110,000 Land/ROW Acquistion 0 H 0 0 $0 Construction 275,000 120,000 395,000 0 $395,000 Other 0 0 0 $0 Total $355,000 "Z,`$150',000°? $505,000 $0 $505,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 4 Attachment"B" Page 4 of 52 Street & Sidewalk Capital Projects North Hills Drive Reconstruction 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. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering 12/2020 03/2021 Land/ROW Acquisition Construction 03/2021 10/2021 Other REVISION EXPLANATION Project savings($985,000)needed to fund bond project ST2111. This is the second revision after$120,000 was used to fund projects ST2114&ST2118,for a total revision(reduction)of$1,105,000.00 FINANCIAL DATA ADOPTED ° ° REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2021/22 REVISION 2021/22 BALANCE COST FUNDING SOURCES General Obligation Bonds $2,120,000 ;`($1;105 000)- $1,015,000 $0 $1,015,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 � � 0, 0 0 $0 Total $2,120,000 ($1,105,000)- $1,015,000 $0 $1,015,000 PROJECT EXPENDITURES ra Professional Services $15,000 ($10,000) $5,000 $0 $5,000 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 2,105 000 (1;095,000) 1,010,000 0 $1,010,000 Other 0 � ° 0 0 0 $0 Total $2,120,000 ($1,105,000) $1,015,000 $0 $1,015,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 _ 2022/23 2023/24 2024/25 2026/26 TOTAL Projected $0 Ordinance No.3751 5 Attachment"B" Page 5 of 52 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 Oaks 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. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2021 02/2022 Land/ROW Acquisition Construction 03/2022 09/2022 Other REVISION EXPLANATION Additional funds needed to support utility reconstruction within the pavement in advance of the pavement replacement. This will significantly reduce the likelihood of future utility issues that could compromise the new roadway. FINANCIAL DATA ADOPTED ' REVISED TOTAL BUDGET THRU ;PROJECT BUDGET THRU REMAINING PROJECT 2021/22 REVISION 2021/22 BALANCE COST FUNDING SOURCE5 General Obligation Bonds $570,000 �� $45,000 $615,000 $0 $615,000 0 ,' . 0 0 0 $0 0 0 0 0 so 0 , 0' 0 0 ' $0 0 � 0 0 0 $0 Total $570,000 $615,000 $0 $615,000 PROJECT EXPENDITURES x �„ �° ° Professional Services $15,000 ($10,000) $5,000 $0 $5,000 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0' 0 0 $0 Construction 555,000 p ;' 55,000 610,000 0 $610,000 Other 0 " ' � 0 0 0 $0 Total $570,000 F°' $45,000 $615,000 $0 $615,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 6 Attachment"B" Page 6 of 52 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 of two Diamond Loch West courts 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. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2021 02/2022 Land/ROW Acquisition Construction 03/2022 09/2022 Other REVISION EXPLANATION Additional funds needed for pavement reconstruction. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2021/22 REVISION 2021/22 BALANCE COST FUNDING SOURCES, " . �;. General Obligation Bonds $130,000 ,' ra$75 000' $205,000 $0 $205,000 , 0 " ' 0 0 0 $0 0 0 0 0 $0 0 : 0 0 0 $0 0 � 0' 0 0 $0 Total $130,000 " ,$75,000:, $205,000 $0 $205,000 PROJECT EXPENDITURES 'r . ° ' ' ' ' " ' , Professional Services $15,000 -° ($11,000); $4,000 $0 $4,000 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 t q 0 0 0 $0 Construction 115 000 1, ,,-4 : .86,000 201,000 0 $201,000 Other 0 0 0 0 $0 Total $130,000 $75,000 $205,000 $0 $205,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 7 Attachment"B" Page 7 of 52 Street & Sidewalk Capital Projects Bedford Euless Road Reconstruction ST2111 PROJECT DESCRIPTION&JUSTIFICATION The project consists of engineering and construction of approximately 2,800 linear feet of Bedford Euless Road from Booth • Calloway Road to just east of Strummer Drive.The improvements include reconstructing the existing roadway with reinforced concrete,including the addition of pedestrian facilities.The road will be reconstructed within the existing right-of-way based on the Transportation Plan recommendation that the section be reduced to a three-lane configuration;this is not a roadway expansion. The 2020 Capital Programs Advisory Committee(CPAC)ranked this project as a high priority.An election was held in November 2020 to issue General Obligation bonds for street projects,and voters approved issuing the bonds for these projects. Project Status: Bidding March 2022.Construction start date anticipated early summer 2022. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering 02/2021 02/2022 Land/ROW Acquisition Construction 03/2022 07/2023 10/2023 Other REVISION EXPLANATION Additional funding needed to award construction contract for Bedford Euless Road,including two alternate bids. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU 'PROJECT BUDGET THRU REMAINING PROJECT 2021/22 REVISION 2021/22 BALANCE COST FUNDING SOURCES ,. ' General Obligation Bonds $3,415,000 ,ti;,61G$985 000.E $4,400,000 $0 $4,400,000 Reserves(Utility CIP Fund 412) 0 ��° �' 440 00d, 440,000 0 $440,000 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 Total $3,415,000 $1;425,000 $4,840,000 $0 $4,840,000, PROJECT,EXPENDITURES Professional Services $0 $0. $0 $0 $0 Engineering/Design 402,000 _ 0 402,000 0 $402,000 Land/ROW Acquistion 0 0` 0 0 $0 Construction 3,013 000 11 425,000: 4,438,000 0 $4,438,000 Other 0 0', 0 0 $0 Total $3,415,000 $1,425,000 $4,840,000 $0 $4,840,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 8 Attachment"B" Page 8 of 52 Parks & Recreation Capital Projects Park Infrastructure Maintenance 2021 PK2104 PROJECT DESCRIPTION&JUSTIFICATION This project provides for maintenance of park infrastructure in response to use and age.The FY2021 priorities include playground fall safe material,playground equipment replacement,sports field restoration,concrete panel replacement,drinking fountain replacement and North Electric Trail bridge deck repairs. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2020 09/2022 Other REVISION EXPLANATION Transfer project savings from PK1606 Park System Signage to PK2104 Park Infrastructure Maintenance for use as needed for the current year park infrastructure needs based on priority. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2021/22 REVISION 2021/22 BALANCE COST FUNDING SOURCES r te m Sales Tax $144,000 ':;;i1g ,u�� $2,157, $146,157 $0 ' $146,157 0 0 0 0 0 $0 0 0 0 0 , $0 0 0. 0 0 $0 0 $0 Total $144,000 ,r $2,157 $146,157 $0 $146,157 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 144,000 ' Fr 2151 146,157 0 $146,157 Other 0 0 0 0 $0 Total $144,000 $2,157 $146,157 $0 $146,157 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 9 Attachment"B" Page 9 of 52 Parks & Recreation Capital Projects Park System Signage PK1606 PROJECT DESCRIPTION&JUSTIFICATION This project provides for design and construction of new,updated signage that will provide a gateway to each park,consistent with the vision,"City as Park"as supported by the Parks, Recreation and Open Space Master Plan. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2015 04/2020 12/2021 Other REVISION EXPLANATION FINANCIAL DATA ADOPTED ' �1m'�' REVISED TOTAL , BUDGET THRU iiir:';14si,;6141 BUDGET THRU REMAINING PROJECT 2021/22VI 2021/22 BALANCE COST Ei�yii 9'fi`'� (U.ir�t 9 m� .;i'li' i v �M?I�IIIIIiii 14IIIi � "kti b���; ,� hear; i ,i�ni,:,y ° - -r=' 'N'' (" '''aF iw i tins iT I' �iE-y` FUNDINGZSOURt3ES ��� V i'46���I�hll�'G�� N�iilIi9'tlo-� ��P a��ar ��{ /3IPill22, ; f4 td �rii�G tF1:4 , ��4i 0.' ; '' $4 32 Sales Tax $474,486reCl ($2'i151j'I1 $472,329 $0 $472,329 s a'�r'ipsoilli„ 0 0 $0 0 i ` ' ��49 ��PI� 0 i� hIN �NN�9mj@li,�i HI0I' 0 0 $0 a���Nl tlmil i�hi�N�ri i r 0 ltliiliihi'�i��, 0 0 $0 Fr 41:71 �Uui 0 id'i,i ENNih� N'iN;y 0 0 0 $0 Total $474,486 i1 ia7($ ,1,57}:; $472,329 $0 $472,329 PROJECT'EXPENDITURESn. , ` ' ,. $c 06 p ,,$1: ':,�w r y,�2,�'��I1brt'IG�ii9min��i!r�'I I rti , t'�.",$,IH�i t y .+, ,n - ,� i:09' Professional Services $0 1Iwi,�� ,a t mot,, $0, $0 $0 0 Engineering/Design 0 pl'Pht' ,0; 0 0 $0 Land/ROW Acquistion 0 ���N 6i�' a „- 0, 0 0 $0 Construction 474,486 ��; � a, I, , (2,,�57) 472,329 0 $472,329 Other 0 ('�s� �0 0 0 $0 Total $474,486 4 -($2„157)i $472,329 $0 $472,329 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $o Ordinance No.3751 10 Attachment"B" Page 10 of 52 Parks & Recreation Capital Projects Richfield Park TennislPickleball Court Replacement PK2105 PROJECT DESCRIPTION&JUSTIFICATION This project provides for the replacement construction of the Richfield Park tennis court.With more than 40 years of service, significant cracking, birdbaths from settling of the court, net post and center strap issues and general foundation issues no longer permit resurfacing allowing safe play.This project will also include resurfacing the existing tennis court at Green Valley Park PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services 10/2020 10/2020 02/2021 10/2021 Engineering Land/ROW Acquisition Construction 06/2021 10/2021 09/2021 09/2022 Other REVISION EXPLANATION The scope of work will include two bid alternates in the amount of$15,000(Alt 1 Irrigation for Richfield court area)and$8,500 (Alt 2 for necessary resurfacing maintenance at Green Valley Park tennis court. Funds are being reallocated from Park Impact Fee Reserves to cover the shortfall for the Richfield Park Tennis/Pickleball Court Replacement project. FINANCIAL DATA ADOPTED ° REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2021/22 '`PREVISION` 2021/22 BALANCE COST FUNDING SOURCES � ° a. , Other $265,000 $0 $265,000 $0 $265,000 Impact Fee Reserves 0 67,075, 67,075 0 $67,075 0 ` 0 0 0 $0 0 0 0 0 $0 0 n 0 0 0 $0 d, Total $265,000 aT.y � ° $67,075': $332,075 $0 $332,075 PROJECT-EXPENDITURES Professional Services $3,575 $0 $3,575 $0 $3,575 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 075 328,500 0 $328,500 44 0 0 0 $0 °��� '6;7, Construction 261 425 196 Other 0 ,, _ 0 0 0 $0 Total $265,000 $67,075 $332,075 $0 $332,075 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 11 Attachment"B" Page 11 of 52 Parks & Recreation Capital Projects Trail and On-Road Safety Projects PK1806 PROJECT DESCRIPTION&JUSTIFICATION This project will provide for implementation of recommendations identified in the City Wide Trail and Route System Study addressing safety enhancements at street crossings,warning signs and markings,wayfinding signs and trail and route connections.The recommendations being implemented are all designed to provide safe,friendly on-street bicycle transportation throughout the City. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE_ REVISION END DATE REVISION Professional Services 10/2017 04/2018 02/2018 09/2020 Engineering Land/ROW Acquisition Construction 04/2018 11/2020 03/2019 09/2022 Other REVISION EXPLANATION Additional funds will be required to cover the cost of the railroad safety course for training Select Maintenance staff who will be working in the railroad right of way. Funds are being reallocated from PK2007. FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU ,PROJECT BUDGET THRU REMAINING PROJECT 2021/22 REVISION 2021/22 BALANCE COST FUNDING SOURCES ` , Federal/State Grants $576,217 l _ $0 $576,217 $0 $576,217 Reserves 159,326 1,000 160,326 0 $160,326 0 0 $0 0 0 0 0 $0 0 ®' 0 0 0 $0 Total $735,543 $1,000 $736,543 $0 $736,543 PROJECT EXPENDITURES ;.° d`' ' u Professional Services $118,500 $0 $118,500 $0 $118,500 Engineering/Design 0 ` • 0 0 0 $0 Land/ROW Acquistion 0 0; 0 0 $0 Construction 606,771 � � � �� �0 606,771 0 $606,771 1 Other 10,272 : 1,000 11,272 0 $11,272 Total $735,543 $1,000 $736,543 $0 $736,543 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 12 Attachment"B" Page 12 of 52 Parks & Recreation Capital Projects Trail and On-Road Safety Projects PK1806 PROJECT DESCRIPTION&JUSTIFICATION This project will provide for implementation of recommendations identified in the City Wide Trail and Route System Study addressing safety enhancements at street crossings,warning signs and markings,wayfinding signs and trail and route connections.The recommendations being implemented are all designed to provide safe,friendly on-street bicycle transportation throughout the City. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services 10/2017 04/2018 02/2018 09/2020 Engineering Land/ROW Acquisition Construction 04/2018 11/2020 03/2019 09/2022 Other REVISION EXPLANATION Funds are being reallocated from Construction to Other to cover the cost of an invoice that was paid from this account.The original payment to DART was supposed to be paid from CN, but the account number was revised to Other in the payment process. FINANCIAL DATA ADOPTED 4" IIi!pI (;�''°l REVISED TOTAL BUDGET THRU 4 PROJECTBUDGET THRU REMAINING PROJECT 2021/22 REVISION 2021/22 BALANCE COST FUNDING'SOURCESy 'T,' III'i Ror,,A'I"mF o °is m 1'ii2i1ii?' , ,,,,C itiagiNe i na i 6h" rici- a a e a i"I rr M Federal/State Grants $576,217wljl�°dulp'Pj� $0-, $576,217 $0 $576,217 Reserves 160,326 'i''110,! ���� 0 160,326 0 $160,326 0 iMOlit t o„ 0 0 $o 0s ,0'i 0 0 $o 0 1 0, 0 0 $o Total S ew $736,543 V oa $0 $736,543 $0 $736,543 PROJECTTEXPENDITURES IS i ' , liG HI aHUV =t D i' „ . dII i' i a iiili i! p1N i( Hfl $118 500 ` �r��'I�iu$0' $118,500 $0 $118,500 Professional Services a ��pt i1ii 1!11,WIT Engineering/Design 0 i 0 0 0 $0 Land/ROW Acquistion 0 #4 it i I�4��0 0 0 $0 Construction 606,771 0 0,1„046(2,500) 604,271, 0 $604,271 Other 11 272 ��3h hj kl� b2 500 13,772 0 $13,772 Total $736,543 er. —„ .1 '_$01 $736,543 $0 $736,543 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 _ 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 13 Attachment"B" Page 13 of 52 Parks & Recreation Capital Projects Trail and On-Road Safety Projects PK1806 PROJECT DESCRIPTION&JUSTIFICATION This project will provide for implementation of recommendations identified in the City Wide Trail and Route System Study addressing safety enhancements at street crossings,warning signs and markings,wayfinding signs and trail and route connections.The recommendations being implemented are all designed to provide safe,friendly on-street bicycle transportation throughout the City. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services 10/2017 04/2018 02/2018 09/2020 Engineering Land/ROW Acquisition Construction 04/2018 11/2020 03/2019 09/2022 Other REVISION EXPLANATION Funds are being reallocated from Construction to Other to cover the cost of mandatory Roadway Worker Protection(flaggers) for staff(contractor)working in the TEXRAIL ROW. FINANCIAL DATA ADOPTED 761iiNO"a'R REVISED TOTAL BUDGET THRU PROJECT p BUDGET THRU REMAINING PROJECT 2021/22 2021/22 BALANCE COST FUNDING;SOURtES, pt A _ vf aa4 r 1 fir' � � �z 'n ^ :iiii _z �TMt N ": S r t + Federal/State Grants $576,217 ' ." W, -$0 $576,217 $0 $576,217 Reserves 160,326 r k 160,326 0 $160,326 Ace0 2, ,644 ' 0; 0 0 $0 0 so 0 M611$144,616, Total $736,543 lti1 AINillinei 1;1;�$0" $736,543 $0 $736,543 PROJECTdgXPENDITURES t r `{`< ogil'ip!aP gat ii4Prtilt M"ti a-t,",>,.' ,Ift $118,500 hli' ` 0 $118,500 $0 $118,500 Professional Services 9 � N Engineering/Design 0 v"; p 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 604 271 (4 000) 600,271 0 $600,271 Other 0 13,772 ci; 00Or 17,772 0 $17,772 Total $736,543 niyi:,51!Iqi',,,;'?PgRa$011 $736,543 $0 $736,543 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 14 Attachment"B" Page 14 of 52 Parks & Recreation Capital Projects Fossil Creek Park Mountain Bike Trails 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 01/2020 05/2020 11/2020 Engineering Land/ROW Acquisition Construction 06/2020 12/2020 12/2020 09/2021 Other REVISION EXPLANATION Additional funds will be required to cover the cost of the railroad safety course for training Select Maintenance staff who will be working in the railroad right of way for the TA Set-Aside Trail&On-Road Safety Enhancements PK1806. Funds are being reallocated to PK1806. 0 FINANCIAL DATA ADOPTED REVISED TOTAL BUDGET THRU • PROJECT , BUDGET THRU REMAINING PROJECT 2021122 � REVISION i 2021/22 BALANCE COST lit!F6 FUNDING„SQURCE5 �ql ��Nrv�! .a Reserves $120 000 • ir 110 1A0001 $119,000 $0 $119,000 Poii 0 0 $0 , 0 • 4iiai�iEGii A 0 0 0 $D' 0 I9iP"9jI r 0 0 0 $0 0 iil! �j 0' � 0 0 $0 Total $120,000 Nlo r��($1 000Y $119,000 $0 $119,000 PRO-act :MWRIM0111:101W . p as ill 1i111i1;IIl!i11!i 4.%. 7."'',, <<Aa liI'i ii°i Gi 6 ti m,; ra .. iliN'Kdu fi Professional Services $0 $0 $0 Engineering/Design 0 0 0 $0 Land/ROW Acquistion 0k� '��6�00 q ����u�;�Illadi��I 1 0 0 $0 Construction 1 20 000 �""4 ;�(14,000) 119,000 0 $119,000 '�'�� ' Other ' � � ��HN�^��';d...�0� 0 0 $0 Total $120,000 ,taa,11:($1:',1000)i $119,000 $0 $119,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 15 Attachment"B" Page 15 of 52 Utility Capital Projects Walker Branch Interceptor Project UT1607 PROJECT DESCRIPTION&JUSTIFICATION As the Transit Orientated Development(TOD)areas begin to develop it is becoming apparent that the city's existing sanitary sewer system needs to be upgraded.The Walker Branch Interceptor Project will consist of sanitary sewer improvements. Section one of the project will consist of increasing the sizes of the lines from 6-inch,8-inch,and 10-inch to 8-inch, 12-inch and a 15-inch respectively from Smithfield Road along Main Street to the Walker Creek and Mid-Cities Boulevard confluence.The total length of sewer line for this section is approximately 5,500 feet. Section two consists of replacing an 18 inch and 21 inch line with a 27 inch sewer line.The approximate length of this section of the project is 4,100 feet. PROJECT STATUS ORIGINAL 2021122 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering 07/2016 08/2021 01/2019 08/2021 Land/ROW Acquisition Construction Other REVISION EXPLANATION Engineering firm submitted the final invoice. FINANCIAL DATA ADOPTED °��i���' REVISED TOTAL PRO BUDGET THRUPROJECT BUDGET THRU REMAINING PROJECT 2021/22 iiegiltEVISIONACt 2021/22 BALANCE COST FUNDI GSOURCES y v '""``+ ~`_ l'4';��lll��°' ' E r.�.�7IPIO -., iI iil it i Fl Ni6 Ike n N. � r �.FtiY_.� . ius��Iii u#r�.����... (�lililt� �r�. ..era �i,�.� r�� i21u +,a�. Certificates of Obligation $1,916 525 a I1-01.�r p;,�� '� $0, $1,916,525 $0 $1,916,525 ��1 !���I� 0= 3,000,000 0 $3 000 000 Other 3,000 000 1' , 0 i'11141'i'i'II'140*, 01, 0 0 $0 0 1111 ilia 01k00 E e 0'' 0 0 $0 0 sett r +0 0 0 $0 Total $4,916,525 7 ,4 -9 0i$01 $4,916,525 $0 $4,916,525 PROJECT„, XPENDITURES ra., " .'JIIiI@li t °I": ri;li'ii'iN11'TIR °", s: i�HI�III'Pid ? A a w li c� IiiIIIIIiIIEIi.e, ' .HI1tiIPjrN 1 4 � �ttl�di 4tivg Professional Services $0 �i���',� 0� $0 $0 $0 Engineering/Design 416,525 'i 15,106� 421,631 0 $421,631 Land/ROW Acquistion 0 ���' 4�i�'I,a'i�d�i�l'�� 0 0 0 $0 Construction 4,500 000 1i 1I;IN1'��(5106) 4,494,894 0 $4,494,894 Other 0 � ' 4 0' 0 0 $0 Total $4,916,525 y $0' $4,916,525 $0 $4,916,525 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 16 Attachment"B" Page 16 of 52 Utility Capital Projects Utility Risk and Resiliency UT2006 PROJECT DESCRIPTION&JUSTIFICATION This project is to conduct a risk and resiliency assessment mandated by the EPA and to create and updated Emergency Response Plan. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services 01/2020 11/2020 07/2022 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION Following completion of the Emergency Response Plan,the State of Texas is requiring that water providers perform analysis of their water distribution infrastructure to develop an emergency plan to ensure that minimum water pressures can be maintained throughout the system in the event of an extended power outage.This analysis utilizes Emergency Response Plan information. FINANCIAL DATA ADOPTED 11,JaN a wrg$ 4 REVISED TOTAL BUDGET THRU no ,PROJECT�� e BUDGET THRU REMAINING PROJECT �a 2021/22 IjDERE,VISION 2021/22 BALANCE COST )FUNDING SOURCESay" ;. °iha��B H ih��IV�N4i��p .' � ��'iH IC E ': I PI H9IMIl;latiM R 0 4 n;In ..a Reserves/Project Savings UT2105 $150,000 , '$5,0 000s $200,000 $0 $200,000 0 lea4001; 0 0 $0 0 %1 ��UMPoi�'o�14pn�lU10P '9 0 a(iHI��;I14��'y���Hu , 0 0 $0 0 akilu'Ii461Pi�tii 1H��i0 0 0 $0 Total $150,000 1 $50,000' $200,000 $0 $200,000 PROJECT'EXPENDITURES °il''��'�'fits[ $150,000 ' $50,000 $200,000 $0 $200,000 Professional Services 0 �;1 t ''4 0" 0 0 $0 Engineering/Design Land/ROW Acquistion 0 � �6��0� 0 0 Construction 0 �1'otiw �l Ri'0 $0 A. 1„'.I'��Cjl��ID(I�)f�i�IIII�I��'�I�)1lil 0 0 Other 0w�hi u' 0 0 $0 Total $150,000 ,ZNhgdldk 0,000' $200,000 $0 $150,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 17 Attachment"B" Page 17 of 52 Utility Capital Projects SCADA Communication ReplacementUtility Risk and Resiliency UT2105 PROJECT DESCRIPTION&JUSTIFICATION The Utility Division uses a Supervisory Control and Data Acquisition(SCADA)system to remotely monitor,make adjustments, and track trends within the water and wastewater system. 'PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END-DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2020 09/2021 11/2021 Other REVISION EXPLANATION The scope of SCADA modifications has been reduced as a result of repairs performed near the end of FY19/20. FINANCIAL DATA ADOPTED "11 1I11,:„I, REVISED TOTAL BUDGET THRU ,,PROJECT BUDGET THRU REMAINING PROJECT 2021/22 (!REVISION, ` 2021/22 BALANCE COST FUNDING SOURCES a�� hP 6`ra�10 I 1� a+l' ,�l T"'�b " " .b IIIII b" '�t �'�'d O.";Stat x °i 1l nr �, t �'�m���6 I ���i�4�I Reserves $75 0001ii;���� ($ 0'000 $25,000 $0 $25,000 0 1p ipl1 02 0 0 $0 0 bl',glii `iZA 0 0 $0 0 1n'a �;� a r0a, 0 0 $0 0 bil rr04 ': 01 0 0 $0 Total $75,000 h� ($50,000) $25,000 $0 $25,000 PROJECT EXPEND{TUBES 4 .2fiS. a= w ?'an-;07 40,0,1dll11111Nik a.r1e "M�1iG'ililiullliho,,,,liaL':4431�Vlt b1„,4,1jT1,-. . w u,,,,,,,„,,,1 4...,, Professional Services ii0e('i:"•ibf$0. $0 $0 $0 Engineering/Design 0 MI111 ,i1'11010 0 0 $0 Land/ROW Acquistion 0 , 1�6V:111i:�11m110 0 0 $0 q iiih lIdd�� �,a 1u1 Construction 75,000 "i'���II(50�000). 25,000 0 $25,000 Other 0 ary��p��;;IIN' 0 0 0 $0 Total $75,000 il11h ($50,000)= $25,000 $0 $25,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 18 Attachment"B" Page 18 of 52 Utility Capital Projects Big Fossil Interceptor Rehabilitation Project 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). 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. Funding Source:Certificates of Obligation. Project Status: Design to begin spring 2022,with construction anticipated to begin in early 2023. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering 10/2021 04/2022 09/2022 12/2022 Land/ROW Acquisition Construction 10/2022 02/2023 09/2023 02/2024 Other REVISION EXPLANATION Cost of engineering design exceeds the allotted budget amount. Project savings from UT2004 will be used to supplement this project once construction is closed out by summer 2022. FINANCIAL DATA ADOPTED ' ,,,""?'"'", 40.514,111111 REVISED TOTAL BUDGET THRU PROJET��il��e BUDGET THRU REMAINING PROJECT 2021/22 REVISION 2021/22 BALANCE COST FUNDING SOURCES^t''' 1 �1N�°��111ffir W 43.1n1H i h 1a' ;i F'a+,£x. =sn ., �"r i6ice ,.,, '' '' V Certificates of Obligation $2,510,000 �1 �i i"d"$0 $2,510,000 $0 $2,510,000 0 i'ilnidl 0 0 0 $0 NMI 0 i� ry0.1 05 0 0 $0 0 Pg'd 'tih kg�0 0 0 $0 0 ����ih�''��� ' �� 0 0 0 $0 Total � pp $2,510,000 ail' ' -' =°$0 $2,510,000 $0 $2,510,000 PROJECT EXPENDITURES a. ra ;Yili 'II't x' IHII'�'Ui, .'7° 4a iwN ill,y' roiJh ih IIiP �il of aalr"�'a z',& s� tiv�'h1�^f Professional Services $0 �I���$0 $0 $0 $0 1447. �111ir FM Engineering/Design 310,000 , 115 00 425,000 0 $425,000 Land/ROW Acquistion 0hd�l�,ba410 0 0 $0 Construction 2,200 000 � Ii(, S 000) 2,085,000 0 $2,085,000 Other 0 , `�yiil p$ 0 0 0 $0 Total $2,510,000 ,I�ti��i $09r, $2,510,000 $0 $2,510,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 19 Attachment"B" Page 19 of 52 Utility Capital Projects Generator feasibilty study Public Works UT2209 PROJECT DESCRIPTION&JUSTIFICATION The purpose of the generator feasibility study is to provide a report evaluating the feasibility of auxiliary electrical equipment at key infrastructure to ensure site function during extended power outages. The city's water distribution system includes a network of pipes, as well as elevated and ground storage tanks, motorized valves,and pump stations all needed to supply the water pressure required to operate the system in compliance with regulatory standards. The storage tanks, pump and lift stations have monitoring and operational equipment that require electricity to function, and currently the majority of these facilities do not have auxiliary power options. Upon completion of the feasibility study, FNI will render an electrical, structural, and civil report for each of the(10)facilities. Each facility's report will include the estimated size of the generator and automatic transfer switch;potential locations for electrical equipment; and a rough order of magnitude costs for electrical equipment upgrades and design.A final report will be compiled to show existing data and conditions,evaluations, calculations, and recommendations. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services 06/2022 03/2023 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION This project will add in the(10)Public Works key infrastructure to be coupled with the feasibility study for the(13)city facilities for auxiliary generator power. The City Managers office to make a determination on what facilities will move to the next step for auxiliary power. FINANCIAL DATA ADOPTED ���° �' I91�hP�� t REVISED TOTAL BUDGET THRU d�l�''1PROJECT • BUDGET THRU REMAINING PROJECT 2021/22 '�I' REVISION. . 2021/22 BALANCE COST h tit "> iuNlUil�r,a`,i N�iifi du;ia ��iI411iPlri:a�'i ��dilf(ibm za�ti�95� rke�M` 6w =s,..�.' "�� ICI b ,a „dM t �^ . i,"�S,ti'��Ii i :. RUNDINEsSOURGESaa� x��a r, hd i I�i �i I � � �ii�i��iifl��„� A, r � � m� Utility CIP Reserves(4126599-491410) $0 emz$12$620) $128,620 $0 $128,620 0 $0 0 0q 0 0 $0 � 0 k 1600ifi 0; 0 0 $0 0 r 0,11 p tiV O 0 0 $0 Total $0 ,',7h,$128,6207 $128,620 $0 $128,620 PROJECT;EXPENDITURESiiat a „,T., a N it i,( 'u' ! 'v a gym,:; 4* ik ,' ,r. ,, i P ti' r1e r, a _' '"G . in $0 $128,620 $128,620 $0 $128,620 Professional Services Engineering/Design 0 111� �' .0� 0 0 $0 Land/ROW Ac uistion 0 ` ��"��8 0 0 $0 Construction 0 �h 0 0 $0 Other �40,061:01H1H1 i;1 0 3Gilll�ll6i„ldiliii'161N1 0 0 $0 Total $0 0011$128•,620! $128,620 $0 $128,620 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3751 20 Attachment"B" Page 20 of 52 Municipal Facility Capital Projects Roof Replacement at FS#1 FC2102 PROJECT DESCRIPTION&JUSTIFICATION Description This request is to replace the roof system and seal the building envelope at Fire Station#1 ($120,000). Justification This roof is at the useful life expectancy. It was identified in the Envelope Study performed in 2011.The roof and building envelope at Fire Station#1 is original to construction and should be replaced. Note: Project funding source is Facility Services Fund(505). PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2020 09/2021 09/2023 Other REVISION EXPLANATION The revision requested is for additional funds needed for labor and material costs. Labor and material costs have skyrocketed due to supply and demand and pandemic challenges. FINANCIAL DATA ADOPTED ,i,;F:Kliaaiitjj, REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2021/22 ,a REVISION, „; 2021/22 BALANCE COST FUNDINGxSOURCE5 3 e 2F ,tltiL* c,.Sw q,liiFi ,'. t i, :a c,�'l hilNi i oiili' ICI w llitllt7V �iiii.11 (hplillpii�i3V i.a'e : s ' Facilities&Construction Reserves $132 000 N, $3 494` $167,494 $0 $167,494 TFR Project Savings from Reserves 0 7 01l'Hil 4 05 29,505 0 $29,505 1i'��Sihll���Pi '�' �" FC2104 Concrete Drive Repair 0 � lHllyltill�b� � , 0° 0 0 $0 0 0 0 0 $0 0 ', '^ qi 1+00 0 0 $0 Total $132,000 _` =e $64,9991 $196,999 $0 $196,999 PROJECT;EXPENDITURES x ii'liiiil'ii�ibi'1l�il°h'�"''i"f , �`,4 i°'k ; = p io ,�'i'ill 6 wn,i Iilllil6ll ill uaw :<` , .a+-u, �i�u i ,r�utdu uI ": ..,,.- a��P7�I9ia ��I I��SIB @ ,ii h .b) � vi t� �n il �t Professional Services I$l011 $0 $0 $0 1P�„ Engineering/Design 0 ,, ili'i��"�� u 0 0 $0 Land/ROW Acquistion 0 �ihl i'i 9,I,t1 l 1111 �0 0 0 $0 IliConstruction 132,000 '�;,4i';i999 196,999 0 $196,999 Other 0 ti� � ,. 0: 0 0 $0 Total $132,000 $64,999 $196,999 $0 $196,999 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3751 21 Attachment"B" Page 21 of 52 Municipal Facility Capital Projects Concrete Drive Repair at FS#2, FS#5 and Service Center FC2104 PROJECT DESCRIPTION&JUSTIFICATION Description This request is to replace approximately 6,000 square feet of concrete and subgrade at Firestation#2($18,000)and 80'long by 40'wide portion of the concrete drive north of Fire Station#5($38,400)and replace approximately 60'long by 25'wide portion of concrete at the Service Center($18,000). Justification The concrete drive replacement is due the sub-grade failure from the heavy equipment and trash trucks at these three locations. The F&C Department recommends replacement of the concrete,subgrade compaction,drainage improvements, and sealing.The concrete has deteriorated. Patching the area will only be a temporary solution and continue to deteriorate. Note: Project funding source is the Facilities Fund(505). PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 10/2020 09/2021 Other REVISION EXPLANATION FC2104 Concrete Drive Repair project savings to be transfered to FC2102 Roof Replacement at FS#1. FINANCIAL DATA ADOPTED Q R„'�g:4"��° ��H, REVISED TOTAL BUDGET THRU ' 7PROJEC` 4I BUDGET THRU REMAINING PROJECT 2021/22 REVISIO ''" 2021/22 BALANCE COST t ri) V I Val"bn"" IMtlD' cm r P r i, i�o �.rY.'P° Earn-6 "z . ' �U�IpINO;SOUR(:ESa� iu�����.:,,��r���g�.� �.� �I�y�W �n� � '(I�wt , ,�.� ���r� �a�,��n�. m#�. � itg� w � � � �:.. Project Savings from Reserves I $74,400 ($29,505)` $44,895 $0 $44,895 FC2014 Concrete Drive Repair 0 ti-tipw x' 0: 0 0 $0 0 rF i -40 0 0 $0 0 '6h1114'' l,11,60$1,0110; 0 0 $0 t�i�� 0ibij�K0 0 0 $0 Total $74,400 ($29,505) $44,895 $0 $44,895 PROJECT EXPENDITURES f' as i i'ua kaiz aNlF{ 73a ,u`.a i. " >4'.1Wya! j'tw w +' p it y a ' i ai„ya $0 $p $0 $0 $0 Professional Services Engineering/Design 0 p y,E, 4 1 '6,10 0 0 0 $0 Land/ROW Acquistion 0 �, h �,�I �0i 0 0 $0 Construction 74,400 j�N�, ::', '(29,505)!' 44,895 0 $44,895 Other 0 kflh0, 0 0 $0 Total $74,400 > A$29,505) $44,895 $0 $44,895 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL •Projected 0 0 0 0 0 $0 Ordinance No.3751 22 Attachment"B" Page 22 of 52 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($88,650). 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. Funding sources are comprised of$97,650 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 Other REVISION EXPLANATION ARPA project approved by council 12/13/2021 Item C.6. FINANCIAL DATA ADOPTED _ REVISED TOTAL BUDGET THRU ,PROJECT BUDGET THRU REMAINING PROJECT 2021/22 to REVISIOON 2 2021/22 BALANCE COST FUNDINGLSOURCES.0 rA:U'1il014 Un i�r�a�0(!'Ill �h,�Ill Pii �« u� !ltI i�t a4", t d d �ttr �c, � '.. ,_�""�C �'I�.N EH :.. .` � �m��ha hip I i. i.r0ill�i�i I :,5n�,a�-�� _ IY,i i ,,,��, �a�u�:. .� iiig ,. Federal-ARPA 21.027 (GRARP21) $0 n'$8 ",650 $88,650 $0 $88,650 Federal-ARPA 21.027(GRARP21) 0 ih�,� l,y,�,�fi,IM;',000P 9,000 0 $9,000 1$1 '0 i1l'�' �r����i d 0 ,v '~' ' 0v 0 0 $0 Total $0 z° :i k$97,650 $97,650 $0 $97,650 ipwiy0t ' a�0 iY. >r �ih k^r Pt y a. = all i0 bvt� ii0 n� PROJECT�EXPENQ[TURES,�P,u Ni��tNilmii.lii v�� �,�,w�ariii�u ri �,` ����.��=��'I1 � �r, x � �� .�-��"�t g ,; �c,iJ'��hi�+i�G1i�;i���i�6�i��,a 1�o��h�tni�iir,��N� Professional Services $O i'10��i 11.41 1;Ii,I 0i $0 $0 $0 0 Engineering/Design �111iiir �1. ' ,dip�a Land/ROW Acquistion 0 �'l '�)`0; 0 0 $0 kklConstruction 0 tt 97 650„ 97,650 0 $97,650 Other 1 R 0 4�a:�Ga�9l� 6i�� 0 0 0 Total $0 4''MIP11$97,6501 $97,650 $0 $97,650 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 23 Attachment"B" Page 23 of 52 Municipal Facility Capital Projects Custodial/Overhead Door Repairs FC2214 PROJECT DESCRIPTION&JUSTIFICATION This project will provide additional funding for custodial equipment($10,000)and overhead door maintenance($5,000). 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 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 Other REVISION EXPLANATION APRA funds approved by council 12/13/2021, Item C.6. FINANCIAL DATA ADOPTED , REVISED TOTAL BUDGET THRU 'PROJECT BUDGET THRU REMAINING PROJECT 2021/22 00,4REVISION. ! 2021/22 BALANCE COST FUNDING'SOURCES ; i gig V'rill 'in ' '4Viallli ,hM'V-14e, r,'.wi Ei lillggr 1! a17VIkreT ` tM` a Mc Federal-ARPA 21.027(GRARP21) $0 'fi$6,000 $6,000 $0 $6,000 0 ioly 0 0 $0 0 � ;;; 0 0 0 $0 0 r #.V-`" 4`"0 0 0 $0 0 ���r ;0 0 0 $0 Total $0 -.n $6,000. $6,000 $0 $6,000 PROJECTtEXPENDITURESM. u tirilityrqMx`. q 1 d6Idi0 L urt .i,awtaGiiliii. lt litOiWie°'iVi ixniii;igi" tiiiit tlP Professional Services $0 R�° �� 0 $0 $0 $0 Engineering/Design 0 ;eyiil�;�llj�'hii,,,I,0 0 0 $0 Land/ROW Acquistion 0 �iu�����au0; 0 0 $0 Construction 0 1���11�1�11'�''01Ui6000„ 6,000 0 $6,000 Other 0 ��i�ll;i411 i'gPg 0 0 $0 Total $0 iait iliQ$6,000F $6,000 $0 $6,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 24 Attachment"B" Page 24 of 52 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 ($20,000). 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. Funding sources are comprised of$20,000 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 Other REVISION EXPLANATION ARPA project approved by council 12/13/2021, Item C.6. FINANCIAL DATA ADOPTED ""Aid', REVISED TOTAL BUDGET THRU " PROJECCT, �'` BUDGET THRU REMAINING PROJECT ati 2021/22 [REVISION y, 2021/22 BALANCE COST T ` �I,a'I1ii I 9 m Pub i DDIII NLa.,�'I 111 I� "i:�= aH '�11: !MI I,Ire iip nd e Ili 7 yi its g;;; Ii lihl i y(NPiI�.i �' l e, F,UNQINf�i SQU�iCES„�,�� i���1���������III��I�IV'm���� _, �,,, ;� #�i��h�wliuil��^ ,��a�+Fra���� �� ;�J��� *t�.* a I,�����O�mWk � � � �wh iu��i,,ikl�Air Federal-ARPA 21.027(GRARP21) $0 11ii1�j�����$20,,�0�010 $20,000 $0 $20,000 0 a ll1 1iIII0 11 0 1`. : IhD 14011 1 0 0 $0 .��aMlm i�)�NPISlwab 0fr Oap{ 0 ,,pry e"uuul4k'ypl O,i 0 0 $0 0 ,iieAm "k 4'' Total $0 *=�; ,$20,000' $20,000 $0 $20,000 PROJECTEXPENDITU 2ES a o * G'„Ilil m ,u willllii a k .'. a¢ rl nas jlini:I` :AggiIjaaiNE!!!!lllairi riiigN 0 Professional Services $0 $ $ $0 $0 Engineering/Design 0 i ,i ra„ �g0 0 0 $0 Land/ROW Acquistion 0 a '�,,;Ho III, 0 0 $0 � V ,4p1lil�h�l��,lidl6i� Construction 0id11k0,i'I��a'4O,000v 20,000 0 $20,000 , i w3ikgG� , Other 0 � n�0kiihli, ,II,1lu 0 0 $0 Total $0 gp yoli$20,000 $20,000 $0 $20,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 25 Attachment"B" Page 25 of 52 Municipal Facility Capital Projects Bathroom Flooring Replacemtn FC2210 PROJECT DESCRIPTION&JUSTIFICATION This projects consists of replacing the floor coverings at Fire Station#3 ($5,700)and Fire Station#2($6,600). PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 05/2022 12/2024 Other REVISION EXPLANATION Project Justification 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. FINANCIAL DATA ADOPTED e in" , 'f iq«��� REVISED TOTAL i�BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2021/22 rdfa,REVISION1 2021/22 BALANCE COST FUNDING d k, V a.t '" !I a ll4 �"� ? b 5 d tea g '; 1.0 ti HN A r iN ; to :s„ �oYtl�r�_a �9P ) w �m� r �) ,5s�'^b„ aava.=�r�� °�>�.�,, oo��r�.a#�_�. ti �a� ��a.� ARPA GRANT FUNDS $0 w,,: $13,000V $13,000 $0 $13,000 ARPA GRANT FUNDS 0 ' ' (700) (700) 0 ($700) 0 �4�0 0 0 $0 0 'fi°PT4, �01 0 0 $0 nW 0 3 040111i111l�l4j'�[9 0 0 0 $0 �� h6 �i Vl� �(�ila� Total $0 3;Niiun$1P2,300 $12,300 $0 $12,300 ,@ Ni i1���i „sue -.w.�A qi i +,-, :�7s 51;: �11�-quo p I q m mii^ �i i4I!l i;ii14 Itl 111110�;r a .r I TI eg ;�� m �7 2 PROJECTEXPNDI,TUR�aS iiluUlh�II�JIiSY�,k�� ��'tiG . -�""��Uf�Iiu Fp�shdx-,. r..�Ia:�61I�1'�a�lll�pi;�a�i4iit�ilil�Filt�,�iP�II�Pfi6l11imi67�ih�I�i�Itli I�I� e �w� m3iit���h�, �;!&��Fw�Wtc Pi(,�� (i VO it MA 9� $0 ����I��i�'i�' h°k $0r $0 $0 $0 Professional Services 1 4 . 'illi iid Engineering/Design 0 ii!,1 0; 0 0 $0 0 * 417-X7 0 0 $0 Land/ROW Acquistion m'44 Construction 0 '. �12,300-' 12,300 0 $12,300 Other 0 u 44.', 0g 0 0 $0 Total $0 = r $12,300 $12,300 $0 $12,300 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 26 Attachment"B" Page 26 of 52 Municipal Facility Capital Projects Equipment Replacemnt and Floor Drain FC2215 PROJECT DESCRIPTION&JUSTIFICATION This project consist of replacing icemakers at Fire Stations#2 and Fire Station#3(7,500)and a floor drain at Fire Station#5 ($3,200). PROJECT STATUS ORIGINAL 2021122 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 05/2022 12/2024 12/2024 Other REVISION EXPLANATION 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. FINANCIAL DATA ADOPTED err REVISED TOTAL BUDGET THRU `[' .1`PROJECTy'O BUDGET THRU REMAINING PROJECT 2021/22 REVISION ojll; 2021/22 BALANCE COST FUNDING`SOURCES ''" 51II iVliNSi(jl7i,1PIIlIMO NdMEi Syr la.'VIPI IN0ulli'BViilti i'11 ' '461i,v`` ° '4"jli' 4 h s F r aih.F - "" n°l ARPA GRANT FUNDS $0 l��i�'$10 000 $10,000 $0 $10,000 ARPA GRANT FUNDS 0 �a1 ljiii hE�'p'u`700b 700 0 $700 to 0 1111n40100iiii10a 0 0 $0 0 ,d0,1-K #,.A,0 0 0 $0 0 i!i�L 'i p 0' 0 0 $0 Total $0 P Z;$10,700 $10,700 $0 $10,700 PROJECTtEXP.ENDITURES 1 g,` ,i"off!ik :p =,a i al a. a it ray , a r* nI9 M r e ,`.22- ,r eirVir Professional Services $0 a7,.1s+ j �li1$�00 $0 $0 $0 i° M�y119iNff� Engineering/Design O bi t ,11$11 i i'a,tV0 0 0 $0 t 0, Land/ROW Acquistion 0 vv.,„ , �,i0 0 0 $0 Construction 0 's l'�i���91i1!id°,, 00rk 10,700 0 $10,700 Other 0 iilid'1''4iu',14 0 0 0 $0 Total $0 i i� ,10$1;0,700 $10,700 $0 $10,700 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 27 Attachment"B" Page 27 of 52 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 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 06/2022 12/2024 12/2024 Other REVISION EXPLANATION The floor drain replacement part of this project included removal/replacement of concrete flooring and the cast iron p-trap. Unfortunately the cast iron pipe downstream of the p-trap is corroded and not suitable for installation of the new p-trap and associated piping. The undiscovered work requires tunneling under the existing foundation to good pipe. A camera was used to located good pipe. The new price not to exceed change order is$10,500. FINANCIAL DATA ADOPTED ' a *' REVISED TOTAL " "h BUDGET THRU s PROJECT 3 BUDGET THRU REMAINING PROJECT 2021/22 ;RE�IS ON 2021/22 BALANCE COST FUNDING,,SOURCES, z MR11'11111l'III1q1IIIIN11i d1 . 'tl" rF� 4 r ?`*,r ry,SrµS� IIINiNN�IIN'Nri,NiNliiitiim um,i,a°!poiaoi,ii,'�P' iH"ila °idle Federal/State Grants $10,700 $10 500s $21,200 $0 $21,200 0 11$1,1iSatink 0 0 $0 0 iP0141F914 446 0 0 $0 0 '1Ili4',,"Id�'dp11111GIIa NE'r�I 0k 0 0 $0 oglG Is" !g, 0 0 0 $0 Total $10,700 ,-; ° ;': A 500` $21,200 $0 $21,200 PROJECTkEXPENDITURES tt 'n""'k't A ilk, d`#tr 2 `« ,1;+.:ws" ' Ewa ' riiir y, r i NWI! d1I1ti191A;llldi ldD'"'' t10492 Professional Services $0 A $0 $0 $0 $0 Engineering/Design 0 , " 0_ 0 0 $0 Land/ROW Acquistion 0 a ,1r 1L�Y'"q;3' 1 ��'�y 0: 0 0 $0 Construction 10,700 q, ��r, �P101,500 21,200 0 $21,200 Other 11� 0,11000141i,:14 ��/ 0 t lii i �d °Ih,,0 0 0 $0 Total $10,700 ' $10,500; $21,200 $0 $21,200 IMPACT ON OPERATING BUDGET n/a 'ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 28 Attachment"B" Page 28 of 52 Municipal Facility Capital Projects Generator Feasibility Study and Equipment FC2200 PROJECT DESCRIPTION&JUSTIFICATION The purpose of this project is to evaluate generator needs at 13 facilities:Animal Adoption and Rescue Center, Park Operations, Permanent Records/Public Works Training, Facilities&Construction/Fleet Admin/Fire Maintenance, Public Library, NRH Centre/Grand Hall, Public Works Operations/Fleet Maintenance, NRH2O Pump House/Warehouse, Fire Station#1, Fire Station#2, Fire Station#3, Fire Station#4,and Fire Station#5. Upon completion of the study, FNI will render an electrical, structural,and civil report for each facility. The feasibility study will conclude with priority ranking of buildings from most needed to least needed for a permanent generator and associated switchgear. Once the building priority is ranked,the next phase would be to design, procure,and construct utilizing the funding remaining in the project. Project funds are being appropriated for a generator study,facility design and installation of generators as funds allow. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services 12/2021 Engineering Land/ROW Acquisition Construction 12/2024 Other REVISION EXPLANATION • This is a new project approved by Council during a budget amendment on 12/13/2021 from ARPA funds. FINANCIAL DATA ADOPTED ) REVISED TOTAL BUDGET THRU ROJECT BUDGET THRU REMAINING PROJECT ��,� a�aara a� 2021/22 a,W �IREVISION 2021122 BALANCE COST FUNDING§SOURCES n, r",' ",� ;., �'�I ;1:7" of r t`l ��u i 7 � 1',i$411:1'111ilgilli 71(i:'film .' • Federal/State Grants $0 �, v$103,000" $103,000 $0 $103,000 Federal/State Grants 0 4��75Q,000 750,000 0 $750,000 0 0 0 $0 0 ,V: 104,t P-0' 0 0 $0 iffftliilq*0 . .0 0 0 $0 Total $853,000 $0 $853,000 PROJECTiEXPENDITURES ka I' i i i a.. l iH ti a 1 I 411:04 big 11111 L I 1i J0s rnuro `J Professional Services $o $103 000 $103,0000 $0 $103,000 Engineering/Design 453 a '0; 0 $0 Land/ROW Acquistion 0 ��I'ii� 4�� �11�1��1�ii3 q (i����� „�;II��N �iGl'iy�d�i 0 0 $0 Construction 0 I'u � 50000 750,000 0 $750,000 i Other 0 ` 0 0 $0 Total $0 47 ^$853,000 $853,000 $0 $853,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected 0 0 0 0 0 $0 Ordinance No.3751 29 Attachment"B" Page 29 of 52 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 ($10,000), Interior Fire Station#4($10,000)Interior Fire Station#3($7,000)Exterior FD/PD Training Center($14,000), and Exterior Fire Station#3($14,000). 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. Funding sources are comprised of$59,000 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 Other REVISION EXPLANATION ARPA project approved by council 12/13/2021 Item C.6. FINANCIAL DATA ADOPTED : ` I(NK REVISED TOTAL BUDGET THRU > `'PROJECTTV BUDGET THRU REMAINING PROJECT 2021/22 2021/22 BALANCE COST FUNDING SOURCES„: M r` uGNliIiliiI '"r, `il°InAai"i °, a"tMu7jV "Ih';r'ri itiIIIIW!IN:1iligdlidi'M °r ltN ra V a T Federal-ARPA 21.027(GRARP21) $0 ntivrsi0000r $59,000 $0 $59,000 0 0 0 $0 • 0ge".a, 0 0 0 $0 0 3 ° - 0, 0 0 $0 0 Sil as 0, 0 0 $0 Total $0 Milai" °'$59,000y $59,000 $0 $59,000 PROJECT EXPENDITU ES �aa�N° i a i �ii a� !1!�. �'�! �e ; sa i �,��M p� �aainry �� li 7 4� a �. �,��`timuUNl U�i�l�V1d1!w�!�,�Qos,_�.>:�,,. Ih t.1i t v� � °%'in (ii(i�9����lt��r�ai iui ��"� � u*at�x��mn, �fi9�h�ll���lt�iii4iai� 9ndw�.f � ,��I�, a Professional Services $0 °i��;I��i rii $0 LL $0 $0 $0 Engineering/Design 0 �i 11109P;14� 0 0; 0 0 $0 Land/ROW Acquistion 0 �l1ii;i1,h�l���ki 0 0 $0 Construction 0 @a ��iyi ,,i®®�01 59,000 0 $59,000 Other 0 �x � �'041; i�1ijl 0 0 $0 Total $0 = 1$59,000 $59,000 $0 $59,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 _ 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 30 Attachment"B" Page 30 of 52 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, Interior Fire Station#1, Interior Fire Station#4, Interior Fire Station#3, Exterior FD/PD Training Center,and Exterior Fire Station#3. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 Other REVISION EXPLANATION 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. FINANCIAL DATA ADOPTED 1,11 ,1 '111 REVISED TOTAL BUDGET THRU tPROJECT BUDGET THRU REMAINING PROJECT 2021/22 PREVISION Ir 2021/22 BALANCE COST FUNDING SOURCES "4 lYig1', �l'I'IN''u'1C4c,`;,. a xTMF .. '' s 151ir Federal/State Grants $59,000 Ell $12,000. $71,000 ' $0 $71,000 0 0 0 0 $0 0 * 0_ 0 0 $0 0 Do- 0 0 $0 trAM 0 a. ,a 0 0 0 $0 Total $59,000 k `$12,000 $71,000 $0 $71,000 p1�� ��,IIIIiaiF+4t�`i F �19 Pi OIe�(�I M�� ram a .-t t Iy � U its y agsrEf p xpANDITURE,S, �.i ao7 e � �iF1'al 1'�17 ,q R ei Po �.6 iSii Ir d@ iI'd Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 le,', 1,414, 0 0 0 $0 Land/ROW Acquistion 0 P 0, 0 0 $0 144 Construction 59,000 12 000t 71,000 0 $71,000 Other 0 0 $0 Total $59,000 $12,000 $71,000 $0 $71,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 31 Attachment"B" Page 31 of 52 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 ($100,000). 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$100,000 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 Other REVISION EXPLANATION ARPA project awarded by council 12/13/2021, Item C.6. FINANCIAL DATA ADOPTED " REVISED TOTAL BUDGET THRU . PROJE BUDGET THRU REMAINING PROJECT 2021/22 REVISION _1 2021/22 BALANCE COST g�kol i�ai poii �UNDING�SOUR�ES��fl' lu�li(� i�a�a!?�y��a��!6� V Federal-ARPA 21.027(GRARP21) $05$100,000 $100,000 $0 $100,000 0 $0 41 0 , , 4 q'0# 0 0 $0 0 :0 A 0 0 0 $0 0 90P1,4440 0 0 $0 Total $0 1,b$100,000 $100,000 $0 $100,000 PROJECTeEXPENDITURES ;nm.;`!biiw�"�n? ��i,7;; % " ho i6r� �udgplil! g'�lu�� ain �i ,i'=u',�i s ; a a . ""' _. �..�� ���� it ail ��,i�a)ti!i�Ih 9!���� �l�l �, ����� k�, aMiF�7u•v �!. , � �ti*� jv,u!I IhiOorM P Professional Services $0n$ � $0 $0 $0 Engineering/Design 0 N ! !ti!! 0' 0 0 $0 Land/ROW Acquistion 0 'O xI G 0 0 0 $0 Construction 0 s 100,000 100,000 0 $100,000 Other t ' 0 0 $0 Total $0 „ :$.1:00,000 $100,000 $0 $100,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 32 Attachment"B" Page 32 of 52 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 ($88,000). • PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 Other REVISION EXPLANATION 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. FINANCIAL DATA ADOPTED x � REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2021/22 itlREVISI,ON,H;- 2021/22 BALANCE COST �iili 11111114 hi�intil(till hid 1 �.1edi,.:w ti�ii s may iq�l og (ih it �q gi ezt t a FUN[)IN�SOURL'ES Boa I����IIhUG�� ��?a,.ia�i�6�.� ..d�6i �:����� u��m � ;� � o ��� ,�ilr�'��iih`���a �.�� d, ,. :� '����u�, �ti Federal/State Grants $100,000 ••li i,($12 000) $88,000 $0 $88,000 0 't N 0, 0 0 $0 0 0 $0 0 pgl91,1 , T0 0 0 $0 OMle� }a 1 1:0;, 0 0 $0 Total $100,000 PA1' ^($12`000) $88,000 $0 $88,000 PROJEC/�T�'EXPENDITURES Spa�4d' '� �z ,h1i1 : 1�111 llr91�IEZ",I r>. ? 1e, aMr1 ur, 6�ni�l�ihid1i�i i y cs f s1-' ° " *^' _'�_._.,,, �+. <�G, I��t. *.��dh�7l�a �8a ���la tlhwd, ,��, .e as�ux �. nJ i� lil IPI II�: � ,.�x.,.o-_*�� �+Az..:'��'.rwe� $o ul11a�l,1160",s a$0 $o $o $o Professional Services �'�E� ; Engineering/Design 0 � �d�r d V111; ��� 0 0 0 $0 Land/ROW Acquistion 0 w°��61i;101i11' 4 Oil 0 0 $0 Construction 100,000 jr, 88,000 0 $88,000 Other 0 sH1i µ!1 1i'4'0 0 0 $0 Total $100,000 „4. . ($12,°000)) $88,000 $0 $100,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 33 Attachment"B" Page 33 of 52 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 as be supported in the future should issues arise. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 06/2022 12/2024 12/2024 Other REVISION EXPLANATION The floor drain replacement part of this project included removal/replacement of concrete flooring and the cast iron p-trap. Unfortunately the cast iron pipe downstream of the p-trap is corroded and not suitable for installation of the new p-trap and associated piping. The undiscovered work requires tunneling under the existing foundation to good pipe. A camera was used to located good pipe. The new price not to exceed change order is$10,500. FINANCIAL DATA ADOPTED " ° "** '„19'; al;l;';g��' REVISED TOTAL BUDGET THRU 1PROJECTI0'iP 1' BUDGET THRU REMAINING PROJECT 2021/22 '" REV�ISIIONjid G` 2021/22 BALANCE COST 01 ti "?fi x'/; ^ ° ; 1a llg eg leMS. Federal/State Grants $88,000 g ($10,500) $77,500 $0 $77,500 te 0t" t' 1i,,�'0 0 0 $0 0 Ate 181 0 0 $0 0 "'^ 0 0 0 $0 0 , 06 0 0 $0 Total $88,000 '1$10,500)",. $77,500 $0 $77,500 PROJECT!EXPENDITURES id1''a9i ald"iIIpo:Hri "x.2:;''4 � ..""uilalli°bolliI��i Fp4 i,, , F a !r, f�� .��,��� ��'. , ��� � . . ( II i�ail # .ter{����,a. $0$0 $0 $0 $0 Professional Services l�� . ,. Engineering/Design 0 �w�����Ilur 0 0 $0 Land/ROW Acquistion 0 4 a I,0, 0 0 $0 Construction 88,000d;���jib�llI (10,500 r 77,500 0 $77,500 Other 0 �i ijH �in03 0 0 $0 Total $88,000 fi " ($10,500)1, $77,500 $0 $77,500 IMPACT ON OPERATING BUDGET n/a ANNUAL OPERATING IMPACT _ 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 34 Attachment"B" Page 34 of 52 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($132,000). 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. Funding sources are comprised of$132,000 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction 01/2022 12/2024 Other REVISION EXPLANATION ARPA project was approved by council 12/13/2021, Item C.6. FINANCIAL DATA ADOPTED '"" gIili1;1 REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2021/22 9 REVISIONS ll 2021/22 BALANCE COST FUNDING SOURCE$ 1illi111Mg tin*wa Wa kNIiiiNitildt O M"ui,r4 a ViaO ,', a'"" A4 4 _ " , .,-.m ,i.a` Federal-ARPA 21.027(GRARP21) $0 g $132,001 $132,000 $0 $132,000 0 P ,u0, 0 0 $0 0 �N0 0 0 $0 0 0i 0 0 $0 0 ,s y�� �,����Ih 0 0 $0 Total $0 32,000j $132,000 $0 $132,000 PROJECT3EXPENDITURES . t- iwrli yir � xa�zu.§�H��� t�. s hih31ll d7) tl HiG+( P ot r. i s - $o 44444°i1 0} $o $o . $o Professional Services a Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0 fi'67“;-`---A 004321000 132,000 0 $132,000 Other 0 a 0 0 $0 Total $0 k 4,$132,000s $132,000 $0 $132,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 35 Attachment"B" Page 35 of 52 Major Capital Equipment Capital Projects Ambulance Replacement FS2201 PROJECT DESCRIPTION&JUSTIFICATION This is for the purchase of a new ambulance to replace unit 980,a 2009 year-model Chevrolet C4500 outfitted with a 14' Frazer brand generator-powered module.When replaced,the ambulance will be 12 years old and have an estimated odometer reading of 172,000 miles. In addition to replacing the ambulance equipment and make ready expenses will be necessary, purchases will include:advanced airway equipment,spinal immobilization and splinting equipment,firefighting tools,safety equipment,and miscellaneous medical equipment/supplies.The cost of the ambulance is estimated at$385,000,which includes$360,000 for the purchase of the ambulance and$25,000 for make ready costs. The hours on this ambulance as of mid-January 2021 was 14,011,which is equivalent to 490,385 miles.At the time of replacement,the estimated mileage based on hours will be in excess of 493,000 miles. In addition,at six to seven years of age,the cost of maintenance and repairs increases and reliability becomes a factor.This leads to the ambulance being out of service more frequently. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2021 07/2022 REVISION EXPLANATION This project was approved by city council as part of the ARPA budget revisions on December 13,2021. FINANCIAL DATA ADOPTED j� REVISED TOTAL BUDGET THRU PROJECTOR,10407,1111 BUDGET THRU REMAINING PROJECT 2021/22 ", REVISION" , 2021/22 BALANCE COST FUNDINGiSOURCES"km,l" H v iHliliifi 1pi'ipt.ma;4. X;� ggi' ,.T 4''V'tll1011,J tr4a- ARPA Grant $385,000 :,!:10„,,„L,, $360,000 $0 $360,000 0 a %41000', 0 0 $0 0ti4 4 0 0 0 $0 0 , I `f 0' 0 0 $0 k 0 , IV Total $385,000 ;4 U-($25,000) $360,000 $0 $360,000 P,RO;lECTtEXPENDITURES,�� So �111151 i�Ni Oi w Professional Services �r�w!����� i �yb��'�����i �k� 0 : �� ���I��,I'. Jpl0 0 0 $0 Engineering/Design � �, �pla �i��l��l Land/ROW Acquistion 0 a, 4c 091 0 0 $0 Construction 0 € k e 0 0 0 $0 Other 385,000 fgr :(25000) 360,000 0 $360,000 Total $385,000 1-7A: `($25,000)j $360,000 $0 $360,000 IMPACT ON OPERATING BUDGET N/A 'ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 36 Attachment"B" Page 36 of 52 Major Capital Equipment Capital Projects Fleet Tire Machine FS2205 PROJECT DESCRIPTION&JUSTIFICATION Tire-changing equipment which is for dismounting/mounting and balancing the newer and larger tires of fleet units,including ambulances. This new tire-changing equipment will replace the aging equipment,and will now allow more of the fleet unit's newer and larger tires to be dismounted/mounted and balanced in our shops, instead of outsourcing this work. Funding sources are comprised of$39,232 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2021 09/2022 REVISION EXPLANATION This project was approved by city council as part of the ARPA budget revision on December 13,2021. FINANCIAL DATA ADOPTED fi p 4' w REVISED TOTAL BUDGET THRU Ih01tp.ROJEECT V BUDGET THRU REMAINING PROJECT 2021/22 11'°I°IREVISION A;` 2021/22 BALANCE COST FUNDING,SOURCES;"IMIlyl9NlAMIPiVIlirlPMIIIIIMi`s ' I ,7"a ilwaiiki ix {, g' r liiiilhkllhlh tliNlktl6eiu . ARPA Grant $0 °aMu1 "$39,232 $39,232 $0 $39,232 0 1 'iV;!! 0` 0` 0 0 $0 0 iisolu�T1,101. 10;1:0i, 0 0 $0 0 4 4 ! relt 0 0 0 $0 0 1yi00"hrita'0 0 0 $0 5^ak�s w;+1wi�iil �;� P49 ii wi Total $0 81'$39,2321 $39,232 $0 $39,232 PROJECT EXPENDITURES a�q i i u"G .. a 4 illl � � he a liw iWuiu i 6l�ill l "m"i i�oi ii li6 it ei i 6 ip i'it of 4'ihi i ini �NTiP4a i"�I"' an d i" .I Professional Services $0 1 0 ,I 0, $0 $0 $0 Engineering/Design 0 � �i I '`'i ' 0 0 $0 �Ab�� l�`�� IIIi� Land/ROW Acquistion 0 - ,� g; 1�lb0 0 0 $0 Construction 0 "1A$ a41�0' 0 0 $0 Other 0 ;v 49 232A 39,232 0 $39,232 Total $0 R "°$39,232'< $39,232 $0 $360,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 37 Attachment"B" Page 37 of 52 Major Capital Equipment Capital Projects Fleet PD Vehicles FS2204 PROJECT DESCRIPTION&JUSTIFICATION Purchase four Police Patrol SUV Units. Four Sport Utility Vehicles have reached the end of their life expectancy and funding will be used for the replacement of these units. Funding source is$209,409 from ARPA Grant Funds for 2021/22. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2021 10/2022 REVISION EXPLANATION ' FINANCIAL DATA ADOPTED l'ii�he 1 -1 REVISED TOTAL BUDGET THRU PROJECT s BUDGET THRU REMAINING PROJECT 2021/22REVISION 2021/22 BALANCE COST FUNDING,'SOURCES HNbN i,i it "' .cx A6iilhaDI r ` ('9Ein � ARPA Grant Funds $0 ;135120k 409'� $209,409 $0 $209,409 0 6111� 640T, 0, 0 0 $0 0 , ed'kekl ,40 0 0 $0 ���1�'ap °id, y 0 kHa,i''o �u0 0 0 $0 Total $0 0 1 cD65$209,409 $209,409 $0 $209,409 PROJECT EXPENDITURES "41i"i ('Ui llki RVEitlPYW Ct. " '°0i ii 7 G Mili:hi'iirai ilid, 1iwi';Iiw'a;g .. ?;,,aiiw i �:xnya Professional Services $0 � ��1,1 1 $0 $0 $0 $0 Engineering/Design 0 ddoE,,i11,, $0 l Land/ROW Acquistion 0 lO �'qaG ;1 0 0 0 $0 Construction 0 1 0 0 $0 Other 0m °'; ©9 409 209,409 0 $209,409 Total $0 K;AlINB$209,409 $209,409 $0 $209,409 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 38 Attachment"B" Page 38 of 52 Major Capital Equipment Capital Projects Police Department Motorcycles FS2206 PROJECT DESCRIPTION&JUSTIFICATION This project will fund the purchase of one(1) police equipped motorcycle to replace a 2016 motorcycle(unit 8025). Funding sources are comprised of$44,860 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2021 10/2022 REVISION EXPLANATION This project was approved by city council as part of the ARPA budget revision on December 13, 2021. FINANCIAL DATA ADOPTED ,, N 07 REVISED TOTAL BUDGET THRU PROJECT{4 gi i BUDGET THRU REMAINING PROJECT 2021/22 "# REVISION�'r'�h�d' 2021/22 BALANCE COST UNDING3SOURCES h�Y �`^'�iilliilii .,,...i- iii hl T +.:' �h"'-.�+�»+ "Prt`� ;iul hihlil�mt ilIlnI iIP��.��i(�9e:ci7*?Iiita ,.a '"afn5,MM iNi Pqd! ARPA Grant $0 kkg "l1$4.060 $44,860 $0 $44,860 0 i:;0:4'I�71�I11;I�91Ii 0; 0 0 $0 0 ,dpi;1,10,� s0m 0 0 $0 0 ? ,�;�1�'l�'I� ;�iIINi 0; 0 0 $0 0 , tit °r� 4�I��4 0 0 $0 �0Idll)1 �1. Vrr Total $0 iloi•olalDi°I'$44,8'60 $44,860 $0 $44,860 ,PROJECTTEXPE DITURES A 19r ", "��ir�ii�(�i�i�i9lii m�Pl1i r N ii�, *we t➢� 't 9QIlppq "r c. � •�T' siG, iv a.�Fare�; i71�IlJ�� �171Y'ri 67 �,it l(ry 6ir�.w,;,h.a�ea,�,- N '� a ,�h,� ., a � 1�n� N&<mra E_ Professional Services $0 ;iIli iti'h'o',l,L` $0a. $0 $0 $0 Engineering/Design 0 *,:4'1,, 0, 0 0 $0 Land/ROW Acquistion 0 �� �� 1 0� 0 0 $0 Construction 0 � 0 0 0 ' $0 Other 0 44,8603 44,860 0 $44,860 Total $0 w _ 4$44,860 $44,860 $0 $44,860 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 39 Attachment"B" Page 39 of 52 Major Capital Equipment Capital Projects Backup Fiber for City Hall IT2202 PROJECT DESCRIPTION&JUSTIFICATION Installation of a secondary fiber internet connection and related hardware to provide a more robust system that provides citywide redundancy for communication and data traffic throughout all city facilities. In July we experienced an internet outage that was caused by a single point of failure at our providers NOC location. Adding multiple redundant routes to separate locations will allow us to provide a much more reliable system. Funding sources are comprised of$183,100 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 03/2022 09/2022 REVISION EXPLANATION This project was approved during the December 13, 2021 City Council meeting when all ARPA projects were established. FINANCIAL DATA ADOPTED , , I REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2021/22 =° REVISION 2021/22 BALANCE COST FUNDINOSOU C.ESw, F7"g jiid i 10 i.,am,o its¶uirlll i5 r m 47 r° Wsb t " Ntiii I '�G ti µd i'iiiptlwii a ,r ARPA Grant $0 f'�'li�'�°$183'"100` $183,100 $0 $183,100 �� �r h�l11;H �IIl�G'i'�mi����Ni�mh�oiii8��lil'il:i 0 i ll,t 1 �i Nl� ;,a, 0 0 $0 0 � iianSigi dtp,1l1 ,' 0 0 $0 0 i'ii'�''!IdH do,i,law"0 0 0 $0 0 �d�P NIIAbpl�I,11*11igi0, 0 0 $0 Total $0 Z%do $183,100' $183,100 $0 $183,100 PROJECrEXRENDITLIRES%Z.>M961Nii"iiibiN.+c iA, a'"kRASa9;'agZARgVM°'�6€mTwFM^,' i .P w ui!!i"9 d^(dtl"WVtKW ,J.' i Professional Services $0 W"" i�r� ��q;i�i,�$0 $0 $0 $0 Engineering/Design 0 ��P 1.i�i'�u ��'�y�0w 0 0 $0 Land/ROW Acquistion 0 Lie#4144,A,1PAO 0 0 $0 Construction 0 e ? ci0 40; 0 0 $0 Other 0 K 1831001 183,100 0 $183,100 Total $0 a7 rY.:a'$183,100. $183,100 $0 $183,100 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 40 Attachment"B" Page 40 of 52 Major Capital Equipment Capital Projects Eventide Dispatch Recorder software/hardware IT2208 PROJECT DESCRIPTION&JUSTIFICATION This project is replacement of the Eventide Recording Call Recording System at City Hall Dispatch Center.The current recording system (in City Hall Dispatch Center)will be relocated to the DR Dispatch Center(Public Safety Training Center). The system being purchased for City Hall includes upgraded processors,increased storage space,and a web-based configuration manager.While the functionality of the older recording system (being relocated to the DR Dispatch Center)is not as robust as the new system being purchased, it will allow the dispatching team to record all calls should there be an emergency situation where 911 calls will be received at the DR Dispatch Center. Currently,there is no means of recording 911 calls at the DR Dispatch Center. When complete, Dispatching staff will be able to record calls at both locations,should the need ever arise. Funding sources are comprised of$82,000 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 03/2022 03/2022 REVISION EXPLANATION FINANCIAL DATA ADOPTED ;1 07 , REVISED TOTAL BUDGET THRU 4 gPROJECT i BUDGET THRU REMAINING PROJECT 2021/22 REVISION 2021/22 BALANCE COST FUNDING SOURCES AfMf;!R PiNar` «.� i'mt".:*t_• " PI(6tr6itgx ._ ! #' i _a a_, .,i-4 l li1I i?q h '"a qrniAit e.?; Federal-ARPA 21.027 GRARP21 i' "01° ( ) $0 � $82,000! $82,000 $0 $82,000 0 0' 0 0 $0 0 10 TN,o rr, 0x 0 0 $0 0 0 0 $0 0 0 $0 Total $0 it °gar` i$82,000! $82,000 $0 $82,000 n���r u a G�i Ii�i it sr p z a ,s a r i n�i iiiir s. $0 $ $0 $0 $0 Professional Services 5 0 Engineering/Design 0 � 0, 0 0 $0 Land/ROW Acquistion 0 " t " " 0ai 0 0 $0 Construction 0 * 0° 0 0 $0 Other 0 82,000? 82,000 0 $82,000 Total $0 -t:LWR$8Z000,1 $82,000 $0 $82,000 IMPACT ON OPERATING BUDGET Purchase of software/hardware maintenance contract for new City Hall recording system. ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected 8,000 8,000 8,000 8,000 $32,000 Ordinance No.3751 41 Attachment"B" Page 41 of 52 Major Capital Equipment Capital Projects Purchase and Implementation of Digital Signature Software 1T2210 PROJECT DESCRIPTION&JUSTIFICATION Purchase and implementation of digital signature software used throughout the organization. The digital signature software will be implemented to increase the time schedules and efficiencies of obtaining and capturing signatures needed for City contracts.This project will work closely with the offices of City Secretary and City Attorney.This project will implement an electronic signature workflow to minimize the amount of time required to obtain the necessary City signatures to execute contracts and legal documents. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 04/2022 12/2022 REVISION EXPLANATION This project was approved during the December 13,2021 City Council meeting when all ARPA projects were established. FINANCIAL DATA ADOPTED �� any iild �° d REVISED TOTAL s� ��iI Ill�wik�wG� BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2021/22 REVISION At 2021/22 BALANCE COST FUNDINGS,OU CES� �, MK PP � K�� yo �iigi �� ���PvlDilln� hail �ilu91:0ilP 1: �_ �. n ��O�a��� �. � ���u�� m�1��6� ��V�� II�Wi�I ���,�,_ , a ,' �«�Im7�li�'�, _ �I��� W ARPA Grant Funds $0 INK a$251000? $25,000 $0 $25,000 0 e�x` ; Genera Fund Reserves 10 000 6�1 � 0; 10,000 0 $10,000 IT Fund Reserves 35,000 111�401 , ,.;00 35,000 0 $35,000 0 MI0, 0 0 $0 0 d40' 0 0 $0 Total $45,000 , 3 `r,$25,0001 $70,000 $0 $70,000 PPROJECTEXPEN,DITURES �Ilidlii 4 n „Pa tPT � N " < _ ii °;ti illiiaii ;,wwr'= Professional Services $0 a , $0 $0 $0 $0 ' 'r 0 0 $0 Engineering/Design 0 � t a�' ,�, Land/ROW Acquistion 0 0, 0 0 $0 Construction 0 „ir,��� �' a�n0. 0 0 $0 Other 45,000 25,0001. 70,000 0 $70,000 Total $45,000 � h `„1$25,000, $70,000 $0 $70,000 IMPACT ON OPERATING BUDGET Annual maintenance cost will be required for this system. ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL ,Projected 10,000 10,000 10,000 10,000 $40,000 Ordinance No.3751 42 Attachment"B" Page 42 of 52 Major Capital Equipment Capital Projects Replacement of Mobile Computers in Public Safety Vehicles IT2203 PROJECT DESCRIPTION&JUSTIFICATION Replacement and installation of mobile computers in 70 Public Safety vehicles(Fire, Police and Municipal Court). This purchase does not include any hand held hardware. The current computers in the vehicles have reached end-of-life. The computers are beginning to require maintenance and with the computers do not have a manufacturer warranty,the cost to maintain the computers is becoming costly. The computers allow all public safety personnel to remain in contact with Spillman providing critical dispatch information, location maps,AVL locations,and tracks unit response and status. Purchase price includes hardware maintenance for each of the computers. Funding sources are comprised of$430,000 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 04/2022 10/2022 REVISION EXPLANATION This project was approved during the December 13,2021 City Council meeting when all ARPA projects were established. FINANCIAL DATA ADOPTED ',i � �' i�pii 4' REVISED TOTAL a �z� i �h n��IIm� BUDGET THRU `�*. PROJE�CTi,I h�ii;11 BUDGET THRU REMAINING PROJECT 2021/22 REVISION 2021/22 BALANCE COST FL'NDING�SOURCES aZT\ ARPA Grant $0 .,._,,;`,,$74.30;00(-.Y1 $430,000 $0 $430,000 0 , ' _ ,40,1 o1;i0% 0 0 $0 0 rt hr°I;I0 0 0 $0 0 ' ' s'j0 0{;' 0 0 $0 0 f' ` 0 0 $0 Total $0 :2$430,0007 $430,000 $0 $430,000 PROJECT EXPENDITURES,er1 �uii'hl`d ii ii " mangy m r n� ' 4dli wEGl'l�@i alGu�a'iluti ii iii Ilih'i I!r"astir .�'?iu m' Professional Services $0 $0 $0 $0 $0 Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 ,F Construction 0 7 .11 ek fi. 0 0 $0 44 Other 0 y' "it 00 000 430,0001 0 $430,000 Total $0 416�e$430,000 $430,000 $0 $0 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 43 Attachment"B" Page 43 of 52 Municipal Facility Capital Projects Replacement of Nexus 4500X Network Switches IT2207 PROJECT DESCRIPTION&JUSTIFICATION This project is to replace Nexus 4500X core switches in City Hall data center.This includes 5 years of hardware maintenance. The Nexus 4500X switches have reached end of life.These switches are essential to connecting the City Hall data center to all other city locations.Switches need to be replaced so they can be supported and have important security updates applied. Funding sources are comprised of$153,000 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021122 START DATE REVISION END DATE REVISION Professional Services 10/2021 09/2022 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ARPA funded project included in budget amendment approved by council Dec 2021. FINANCIAL DATA ADOPTED iNg rl'2 idil REVISED TOTAL BUDGET THRU BUDGET THRU REMAINING PROJECT �� �������E 2021/22 BALANCE COST p 2021/22 �FtEVISfON�,�il�lit,�� FUNDING SOURCES +%. 'ir to nip .,, e , r ,«m 5' y,rq plim�Pp gl w' t4+. IIIi�91i'i�IlIIp91 G'rti. £ 4= x i"a Y x Federal-ARPA 21.027 (GRARP21) $0 lr, 1,$153,000` $153,000 $0 $153,000 4' 01 0 0 $0 0 0 0 0 $0 0 a0` 0 0 $0 0 °, 'x-i` 0 0 0 $0 Total $0 iP,t%:$153,000° $153,000 $0 $153,000 PROJECT;EXPENDITURESa''' 3,S= t7 P!kN EEI!;iilli,ISI I!IiiitilliG n�iia uair !Ft' gl;11�GI I , ot,tems .4}r q ts. iufi 4x i f 3 -F Professional Services $0 � $0 $0 $0 Engineering/Design 0 �rj 1 1 j, 0 0 0 $0 Land/ROW Acquistion 0 i�,t��phli1;�i��I��I�lili��i�0 0 0 $0 Construction 0 Ott 0 0 $0 Other €����� k���� 0 'f 5 000 153,000 0 $153,000 Total $0 *:':, $153,000' $153,000 $0 $153,000 IMPACT ON OPERATING BUDGET No operating budget impact expected. ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected 153,000 $153,000 Ordinance No.3751 44 Attachment"B" Page 44 of 52 Major Capital Equipment Capital Projects SCADA System Upgrade IT2205 PROJECT DESCRIPTION&JUSTIFICATION Install an upgraded server that supports the SCADA System in a server class environment with proper power and redundancy. During the winter storm in 2021 there was a power outage at a city facility where the current SCADA server is located. Moving this and upgrading to new hardware to another location with backup power and network redundancy will improve the system reliability. Funding sources are comprised of$60,000 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 06/2022 09/2022 REVISION EXPLANATION This project was approved during the December 13,2021 City Council meeting when all ARPA projects were established. FINANCIAL DATA ADOPTED r.:5;!,Watir4at REVISED TOTAL BUDGET THRU *PROJECT, BUDGET THRU REMAINING PROJECT 2021/22 : REVISION 2021/22 BALANCE COST � u a� at�.f r'.'.'^' ,IFS �I''c 'Sfl Ea ;�, t r1 iu 5. .. �s� =h ' �" �,� , �E,., .a��¢�„��� x �H�4�i ,��s4���' �.� :���a�����N�����.,,��'� un�'�u ARPA Grant $0 , b $60 000` $60,000 $0 $60,000 0 0 0 $0 o o o; 0 0 $0 0 Q�; m 4:110 0 0 $0 Total $0 ;s ' a :$60,000, $60,000 $0 $60,000 PROJECT EXPENDITURES:,, y .Q"`^^tf,Nt R g l4podkjtttr5' , PO4i - ',iii'PI4'iigptlpiq#.A*Rz;y4_M:: s§ ;?°g mi;;$Lg8.«., a Professional Services $0 14$0� $0 $0 $0 104 Engineering/Design 0 � � �0 0 0 $0 , A ? %�d�'1�'liar Land/ROW Acquistion 0 v F ���{ �i'N 10 0 0 $0 Construction 0 r i� �� g�'�P��II�I����� 0 0 $0 Other 0 �a , ,n60 0�0 60,000 0 $60,000 Total $0VIn$60,00011 $60,000 $0 $60,000 IMPACT ON OPERATING BUDGET N/A ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 45 Attachment"B" Page 45 of 52 Municipal Facility Capital Projects Security Camera and Access Control Upgrade and Additions IT2206 PROJECT DESCRIPTION&JUSTIFICATION • This project is to upgrade surveillance camera and access control systems at all city facilities using legacy systems.This project will also add additional cameras and access control systems to facilities that currently do not have security. There is 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 standards.The NRH Centre, Library, Records Storage, Public Safety Training Center and Facilities and Constructions 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 2 access badges and eliminate managing and maintaining four different security systems(2 different access control and 2 different surveillance camera systems). Funding sources are comprised of$340,000 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services 10/2021 09/2022 Engineering Land/ROW Acquisition Construction Other REVISION EXPLANATION ARPA funded project included in budget amendment approved by council Dec 2021. FINANCIAL DATA ADOPTED ''1Wh;enMH lFAI 1 REVISED TOTAL BUDGET THRU PROJECTS"»���� BUDGET THRU REMAINING PROJECT 2021/22 2021/22 BALANCE COST FUNDING SOURCES¢ "i41ii7'ilhF .._ V'i(�ii'i i4u' p"u aa,ih�a Py i,r'�r G'A�IjlliluulG.a'iir �Gfl ikw g X .,w .«°' ` Federal Grant $0 i'?';11P4$346,001 $340,000 $0 $340,000 0 $0 0 0�� 0' 0 0 $0 0M = z50" 0 0 $0 Zn :3 Total $0 a 411$340,000 $340,000 $0 $340,000 Professional Services $0 - , $0e $0 $0 $0 Engineering/Design Oak7.k 0 0 $0 Land/ROW Acquistion 0 0' ''" �"'g*0J 0 0 $0 Construction 0 *Ir' 1'd,�hw�i0 n 0 0 $0 ll�,� Pl"in Other 0 l,Mliibliu34.G0,090,i 340,000 0 $340,000 Total $0 iiellin„ii,1$340,000'r. $340,000 $0 $340,000 IMPACT ON OPERATING BUDGET No operating budget impact expected. ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected 340,000 $340,000 Ordinance No.3751 46 Attachment"B" Page 46 of 52 Municipal Facility Capital Projects Cybersecurity Assessment 1T2212 PROJECT DESCRIPTION&JUSTIFICATION With the increased threat of a cyber-attack in today's world we the need for a Cybersecurity Assessment and Cybersecurity managed services contract.These services will assess our system and provide 24x7 monitoring of the City's network infrastructure to ensure we are protected with some of the latest technology available today and into the future. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 12/2021 09/2022 REVISION EXPLANATION ARPA funded project included in budget amendment approved by council December 13,2021. FINANCIAL DATA ADOPTED #i,l,",�1,:1 REVISED TOTAL BUDGET THRU PROJECT� � I�� BUDGET THRU REMAINING PROJECT 2021/22 -.REVISIONrli' 2021/22 BALANCE COST a dirt'9R ,:a ,.a�4)1ii�lnl"a54k.Pa e. "a,r ,I nfea' i`N A+, II"N yl�lilll,'I��II���,?�'l��'lil'lla��, ilIMH rc aal t f, I' a, , -' ` '!;0 �' FUNDINGSOURGES .. ` �I a' �� u. 7 G.o+,1, o, a':,, n a g ,9,� Federal-ARPA 21.027 (GRARP21) $0 '1 .:` $90,000a5 $90,000 $0 $90,000 0 i'-:' 0, 0 0 $0 Ai 071, � 4110° 0 0 $0 -� 0 I 1 v ,0. 0 0 $0 0 5 � , ', 0f 0 0 $0 Total $0 _ 4:f‘$90,000 $90,000 $0 $90,000 PROJECTIEXPEVDITURES,�°IGi 'G M;MM1M«am* v. °'I''I�. '1 S +fi M " '' ` ', . .1 1�, :+� 'a,r r µ aIGd�,��`'I^ism i- :-, �,,, tea. Professional Services $0 "4 4 V $0 $0 $0 $0 Cl � t a S 0 ` 0, 0 0 $0 Engineering/Design Land/ROW Acquistion 0 l rt ' t 0: 0 0 $0 Construction 01��riti�01' 00 0 0 $0 Other 0 ,l'!l!Nll��,11l'�IlDj101id$90 000 90,000 0 $90,000 Total $0 ; 21;2$90,'000 $90,000 $0 $90,000 IMPACT ON OPERATING BUDGET No operating budget impact expected. ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected 90,000 90,000 90,000 90,000 90,000 $450,000 Ordinance No.3751 47 Attachment"B" Page 47 of 52 Major Capital Equipment Capital Projects Fire Radio Replacement IT2211 PROJECT DESCRIPTION&JUSTIFICATION This project is to replace Fire Department radios that are near end of service life. Every year radios are reaching their end of service life,and within the next two years,a large group of radios will have reached end of life. We have assessed the different options for new radios,and will receive a proposal for the selected radio that meets our department's needs. These radios will ensure vital communications are met during all emergency response efforts. Funding sources are comprised of$375,000 in FY22 ARPA Grant Funds. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 02/2022 09/2022 REVISION EXPLANATION This project was approved during the December 13,2021 City Council meeting when all ARPA.projects were established. FINANCIAL DATA ADOPTED � 60 ya7'uRM REVISED TOTAL BUDGET THRU PROJECTaipROABDTZ'OJ BUDGET THRU REMAINING PROJECT 2021/22 a RVISIONA 2021/22 BALANCE COST FUNDING SOU R."ES CW ,��: �r n ,mot" IIII a t ARPA Grant $0 -T,-Vi.'„,1,74..$375,,,0004 $375,000 $0 $375,000 0 NIRV 0 0 $0 0 Ele-Akil 0 0 0 $0 0 r 0 '`00', 0 0 $0 0 '1 6 " 0 0 0 $0 Total $0 Io' "°"T$375;00a $375,000 $0 $375,000 PROJECT EXPENDITURES i.4 " `' tru. 4. 111 liar ikinn41ui,6,h 111 MAti MOVN q!111l V9!!:IIlli1Pn 7:i Ati6gilIiliiTiIZ kw 1C ION7i 1 t_> $0 rilHihi;$0111106 $0 $0 $0 Professional Services Np, ,GI i1g41ti 7 Engineering/Design 0 ;� �I i��,���,�"��0 0 0 $0 Land/ROW Acquistion 0 :. t '01 0 0 $0 t�4 5c 4': Construction 0 4,M' " 4 ?0 0 0 $0 Other 01 " 375,000 375,000 0 $375,000 Total $0 i Ga.$375,000:. $375,000 $0 $375,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 48 Attachment"B" Page 48 of 52 Other Capital Projects Fire Radio Replacement IT2211 PROJECT DESCRIPTION&JUSTIFICATION This project is to replace Fire and Police Department portable radios that are at their"end of support"date.Within the next year, Public Safety will have over 80 radios that are at their end of support date.These radios ensure vital communications during all emergency response efforts,including Fire, Emergency Medical Services(EMS),and Police response. Funding: Funding is provided through the American Rescue Plan Act(ARPA). PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 02/2022 09/2022 • REVISION EXPLANATION The scope of the original project has not changed; but,the final quote from Motorola came back$20,215.25 higher than the original estimated ARPA allocation. In order to ensure no quality of communications is lost,we request to increase the amount to match the quote of$395,215.25 for 65 radios. FINANCIAL DATA ADOPTED 1?a,;X p yu REVISED TOTAL BUDGET THRU pf s";PROJECT BUDGET THRU REMAINING PROJECT 2021/22 !y,IHii,REVISIONrA 2021/22 BALANCE COST FUNDING.iSOURCES,fl .x,; iNMllliiliVT { ,:' , 11"�P111111i1111'i6ltliieiiiFliE V x":g" %»,E: .. 9 �i61HhIIII I iH .hiiudi* is kk7 iioiFi „i01r a te `. : Federal/State Grants(ARPA) $375,000 Ail�'i�'i$20 215 $395,215 $0 $395,215 u'li0 1,1 0 ��q 10 0 0 $0 0 0 $0 0 , °4 it ii llk.1 0 0 $0 Total $375,000 ,', :,,$20,215'i $395,215 $0 $395,215 PROJEGT•EXPENDITURES p11jN , Professional Services $0 1/4/ $0 $0 $0 Engineering/Design 0 ���il i' 0 0 0 $0 Land/ROW Acquistion 0 ii�;i�� 0 0 0 $0 Construction 0 ' r"„ 0 0 0 $0 Other 11� �� 3 375,000 _ 1�i�10,,215 395,215 0 $395,215 Total $375,000 :.5 s;1Iti$20.215 $395,215 $0 $395,215 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 49 Attachment"B" Page 49 of 52 Major Capital Equipment Capital Projects Replacement of Spillman CAD/RMS Servers IT2201 PROJECT DESCRIPTION&JUSTIFICATION This project is for the replacement of the Spillman CAD/RMS Servers.The replacement installation includes the production servers and the disaster recovery servers and would include critical hardware maintenance for 5 years. Project costs are broken down as follows: Hardware&Installation Costs$176,812, Managed Services$31,044, On-Site Data Migration$23,960 for a total cost of$232,000. Current server hardware configuration is at end-of-life.The total price for project is$232,000 including Managed Services. Managed services is an expense for Motorola to monitor the Spillman servers 24/7/365 remotely diagnosing any possible hardware/software issues, identifying possible down time(s)for the 4 joint dispatch cities.After year one of this project,the managed services cost will move to the IT Operating Budget(5302070-523170). Original installation/purchase date of current hardware/software was January 2015. Funding Source: Crime Control District Fund(130). PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2021 10/2021 10/2022 10/2022 REVISION EXPLANATION The initial project was to replace only the productions servers within the Spillman CAD/RMS environment. After further research it was discovered that the servers located at our Disaster Recovery site were not included in this project. However, is it mandatory that we upgrade these servers at the same time in order to provide the same Disaster Recovery service we have currently. FINANCIAL DATA ADOPTED at .: °�It REVISED TOTAL BUDGET THRU PROJECT BUDGET THRU REMAINING PROJECT 2021/22 ill, REVISION n, 2021/22 BALANCE COST �iil ;�;4 #,f ".,5xiA klhl�i{1,91 �i ,ra'� tt!q���Ik IPQ:N'iii1,, - : '5:'.. j ?, era int ."`re..' t is 1 'r'"Nt' .,,�_. FUNDI[dG�SOURCES �F,�'�.,��� �N� .. ,1� I .� ��.�M, . ��� Crime Control District Reserves $232 000 ��I;�h�q;�,�$ 8,000 $360,000 $0 $360,000 1' ��)IIITor P l 0 .4'�I 6 i1ii ,lY Fi00 0 $0 0 7 ;6;IIik ,NA0 0 0 $0 0 0,4110'd';r' `ill 0 0 $0 0 � �r MHO; 0 0 $0 Total $232,000 .`- 4'$128,000 $360,000 $0 $360,000 PROJECTXXPENDITURES r aril W'FF . ._F 71, ., :.L.L *s ,. . , .;,. .°`r i°t T11U'.' Professional Services $0 $0 $0 $0 Engineering/Design 0 �� 0 0 0 $0 Land/ROW Acquistion 0 1ry,�,aur�� a , 0 0 $0 Construction 0 l G0!9 N1 ` 0 0 $0 Other 9 �II��I7,� �',� 232,000 G ,I,� di 11�128,0000�,� 360,000 0 $360,000 Total $232,000 q1:10,$128,000j $360,000 $0 $360,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected 58,000 58,000 58,000 58,000 $232,000 Ordinance No.3751 50 Attachment"B" Page 50 of 52 Major Capital Equipment Capital Projects Interview Room Video Storage Replacement IT2214 PROJECT DESCRIPTION&JUSTIFICATION Refresh and increase the storage used to retain evidentiary interview videos. 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 100 Terabytes.This will provide them more capacity and further protect the data from possible data corruption due to not having enough space. Purchase price is$150,000 and the annual maintenance cost $40,000. Funding Source: $150,000 from Crime Control District Fund 130. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2022 09/2023 REVISION EXPLANATION This is being done as a FY22 Revision. FINANCIAL DATA ADOPTED ` r K REVISED TOTAL BUDGET THRU PROJECT" � BUDGET THRU REMAINING PROJECT 2021/22 rit REVISION y 2021/22 BALANCE COST FUNDING:SOURCES ori��p""ya i"11+w i P,to�"I ` �t% Crime Control District Fund 130 $0 $150,000 $0 $150,000 1111 0 01�'' Oi 0 0 $0 0h � ' o"(�;��nil6��,0 0 0 $0 0 h (�n��i�o�fiti�� �i �0 0 0 $0 6 PmPltil (nni�p1��) � 0 'k- Atipitil0$ 0 0 $0 Total $0 ,- a4150,000"": $150,000 $0 $150,000 PROJECT,EXPENDITURESuAr i ayu!TMIT , y,13*^t s T `.„ ^ ii '"' ""yw ihtirfi 'u„ejik k „p $0 37,A,$01, $0 $0 $0 Professional Services r, Engineering/Design 0 0 0 0 $0 Land/ROW Acquistion 0 11,r �(4i�1 9 ;�' 0 0 $0 Construction 0 0 0 0 $0 Other j6�,6 l !150 000 150,000 0 $150,000 Total $0 Ilgi, ,$;150,000 $150,000 $0 $150,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 51 Attachment"B" Page 51 of 52 Street & Sidewalk Capital Projects Forensic Digital Evidence Storage IT2215 PROJECT DESCRIPTION&JUSTIFICATION Refresh and increase the storage used to retain digital evidence in the Forensic Lab. 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.The initial purchase price is$150,000 and it requires an annual maintenance fee of$40,000. Funding Source: $150,000 from Crime Control District Fund 130. PROJECT STATUS ORIGINAL 2021/22 ORIGINAL 2021/22 START DATE REVISION END DATE REVISION Professional Services Engineering Land/ROW Acquisition Construction Other 10/2022 09/2023 REVISION EXPLANATION Revision in FY2022. FINANCIAL DATA ADOPTED `;141.:MftlgtrO REVISED TOTAL BUDGET THRU PROJC'TBUDGET THRU REMAINING PROJECT 2021/22 kt REVISION 2021/22 BALANCE COST FUNDING,SOURCESiIa+�� Fii l�bH� ��+q,� .°)~ h ii;;i , ,, ;;at; , J ! 4 "9P� , i ,� + ,s��+ mn i ti k NI'�,bk��I�_„ �*a.,� .€ !' w.�': �i !,� a� ���"�� Crime Control District Fund 130 $0 t4 2$'150,00 ? $150,000 $0 $150,000 0 ,, i7r0 0 0 $0 0 3'' k Oo 0 0 $0 0 11li(hh1ii�'��u�h��0 0 0 $0 � 0 , 4!'II�',n���610 0 0 0 $0 al,Total $0 . '!K$150;000 $150,000 $0 $150,000 PROJECT EXPENDITURES U I 6 `I I �. ,. _ Professional Services $0 $0k $0 $0 $0 Engineering/Design 0 �'`+ 0 0 0 $0 Land/ROW Acquistion 0 0 0 0 $0 Construction 0t " 4*150' 0 0 $0 Other 0 N 150,000 150,000 0 $150,000 Total $0 d' Ua$150,000 $150,000 $0 , $150,000 IMPACT ON OPERATING BUDGET ANNUAL OPERATING IMPACT 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL Projected $0 Ordinance No.3751 52 Attachment"B" Page 52 of 52