Loading...
Ord. 1605-2 2021-12-13ORDINANCE NO.1605-2 An Ordinance of the City Council of the City of Pearland, Texas, amending Ordinance No. 1605-1, the 2021-2022 Annual Budget Ordinance, to facilitate the changes identified herein; providing a savings clause, a severability clause, a repealer clause, and an effective date. WHEREAS, the City Council is authorized by law to make changes in the City budget for municipal purposes and for emergency appropriations to meet a pressing need for public expenditure to protect the public health, safety, and welfare as a result of unusual and unforeseen conditions; and WHEREAS, said amendments are necessary to reflect the Fiscal year 2022 budget revisions, including revenues and expenditures; now therefore, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS: Section 1. That the City Manager or his designee is authorized to make appropriations for a revised Fiscal Year 2022 year-end budget as set out in Exhibit A, attached hereto and incorporated herein by reference for all purposes, as authorized by law for municipal purposes. Section 2. That the City Manager or his designee is authorized to take all actions necessary to facilitate the changes identified herein. Section 3. Savings. All rights and remedies which have accrued in favor of the City under this Chapter and amendments thereto shall be and are preserved for the benefit of the City. Section 4. Severability. If any section, subsection, sentence, clause, phrase or portion of this Ordinance is for any reason held invalid, unconstitutional or otherwise unenforceable by any court of competent jurisdiction, such portion shall be deemed a separate, distinct, and independent provision and such holding shall not affect the validity of the remaining portions thereof. Section 5. Repealer. All ordinances and parts of ordinances in conflict herewith are hereby repealed, but only to the extent of such conflict. DocuSign Envelope ID: 5FAB980C-43C0-497B-A506-4174CF747E78 ORDINANCE NO. 1605-2 2 Section 6. Effective Date. This Ordinance shall become effective immediately upon its passage and approval by the City Council. PASSED and APPROVED ON FIRST READING this the 6th day of December, A.D., 2021. ________________________________ J. KEVIN COLE MAYOR ATTEST: ________________________________ CRYSTAL ROAN, TRMC, CMC CITY SECRETARY PASSED and APPROVED ON SECOND AND FINAL READING this the 13th day of December, A. D., 2021. ________________________________ J. KEVIN COLE MAYOR ATTEST: ____________________________ CRYSTAL N. ROAN, TRMC, CMC CITY SECRETARY APPROVED AS TO FORM: ____________________________ DARRIN M. COKER CITY ATTORNEY DocuSign Envelope ID: 5FAB980C-43C0-497B-A506-4174CF747E78 Adopted Budget Amended Budget #1 Amended Budget #2 Adopted Budget Amended Budget #1 Amended Budget #2 Ord No. 1605 Ord No. 1605-1 Ord No. 1605-2 Ord No. 1605 Ord No. 1605-1 Ord No. 1605-2 OPERATIONS 100 General 99,602,092 101,345,824 101,345,824 99,572,064 101,315,796 102,526,952 200 Debt Service-General 43,172,285 43,172,285 43,172,285 44,425,764 44,425,764 44,425,764 900 PEDC 11,917,344 11,917,344 11,917,344 26,346,571 26,346,571 28,102,871 Special Revenue Funds 305 Hotel/Motel 927,900 927,900 927,900 1,067,623 1,067,623 1,075,166 310 Municipal Court Security 48,004 48,004 48,004 45,609 45,609 45,609 315 Citywide Donation 30,067 30,067 30,067 50,459 50,459 50,459 320 Court Technology 45,100 45,100 45,100 48,533 48,533 48,533 330 Parks Donations 105,650 105,650 105,650 105,550 105,550 105,550 331 Tree Trust 2,100 2,100 2,100 280,500 280,500 310,500 332 Parks Financial Assistance Donations 2,550 2,550 2,550 2,500 2,500 2,500 335 Police State Seizure 108 108 108 37,200 37,200 37,200 336 Federal Police 100 100 100 - 340 Park & Recreation Development 98,000 98,000 98,000 458,754 458,754 481,249 345 Sidewalk 5,100 5,100 5,100 - 350 Grant 1,841,796 1,841,796 1,841,796 1,843,115 1,843,115 1,877,214 351 Community Development 462,666 462,666 462,666 462,666 462,666 1,912,319 352 CDBG - Disaster Recovery Fund - 5,308,153 353 Disaster Recovery Fund - - 354 Hazard Mitigation Fund 1,073,790 1,073,790 1,073,790 1,073,790 1,073,790 4,292,742 355 Coronavirus Relief Fund - 129,216 356 ARPA Fund 5,944,486 5,944,486 5,944,486 5,964,486 5,964,486 5,964,486 360 Traffic Impact Improvement 100 100 100 214,920 214,920 214,920 365 Truancy Prevention and Diversion 52,600 52,600 52,600 51,984 51,984 51,984 366 Municipal Jury Fund 1,025 1,025 1,025 1,000 1,000 1,000 370 Municipal Channel 236,500 236,500 236,500 860,500 860,500 860,500 380 Regional Detention - - 510 Lower Kirby - - 514 Infrastructure Reinvestment Fund 1,462,471 2,406,203 2,406,203 1,553,000 2,496,732 2,496,732 Internal Service Fund 700 Risk Management Fund 2,496,691 2,496,691 2,496,691 2,478,801 2,478,801 2,494,187 702 Medical Self-Insurance 9,775,632 9,775,632 9,775,632 9,775,633 9,775,633 9,775,633 703 Motor Pool 13,252,969 13,252,969 13,252,969 4,562,078 5,012,078 7,998,913 Proprietary Funds 600 Water and Sewer 54,437,322 54,437,322 54,437,322 64,055,530 64,055,530 65,915,470 601 Water and Sewer Debt Fund 30,676,991 30,676,991 30,676,991 26,416,290 26,416,290 26,416,290 610 Solid Waste 8,203,800 8,203,800 8,203,800 8,200,000 8,200,000 8,200,000 SUB TOTAL - OPERATIONS 285,875,239 288,562,703 288,562,703 299,954,920 303,092,384 321,122,112 CAPITAL IMPROVEMENT PROGRAM Water/Sewer Capital Projects Funds 550 Utility Impact Fee 1,100,000 1,100,000 1,100,000 7,299,324 7,299,324 7,299,324 551 Water Impact Fee - - - - 552 Sewer Impact Fee - - - - 555 Shadow Creek Impact Fee - - - - 565 1999 W & S Revenue Bonds - - 2,154,393 2,154,393 2,154,393 566 W & S Revenue Bonds 2020 - - 29,239 29,239 29,239 567 TWDB Revenue Bond Series 2020 - - 60,381 60,381 60,381 568 W & S Revenue Bonds 2021 - - 101,992 101,992 101,992 569 W & S Revenue Bonds 2022 94,859,397 94,859,397 94,859,397 60,949,508 60,949,508 60,949,508 570 Water/Sewer Pay As You Go 3,819,000 3,819,000 3,819,000 2,889,938 2,889,938 2,889,938 571 TWDB Bonds 2021 - - 43,645 43,645 43,645 572 TWDB Bonds 2022 - - - - 573 TWDB Bonds 2023 - - - - 574 W&S Revenue Bonds 2023 - - 72,716,490 72,716,490 72,716,490 575 MUD 4 Capital Program - - - - 576 W&S Revenue Bonds 2024 - - 43,795,365 43,795,365 43,795,365 - - - - Capital Projects Funds - - - - 500 Capital Projects 2,162,000 2,162,000 2,162,000 2,307,802 2,307,802 2,307,802 501 Capital Projects-CO 2001 450,000 450,000 450,000 1,338,212 1,338,212 1,338,212 503 Capital Projects-CO 2006 - - 3,542 3,542 3,542 506 Capital Projects-GO 2009 - - 987,032 987,032 1,382,376 507 Capital Projects-GO 2020 - - 329,934 329,934 329,934 508 Capital Projects-CO 2020 2,553,600 2,553,600 2,553,600 5,657,767 5,657,767 5,657,767 509 Capital Projects-GO 2021 - - 38,327 38,327 38,327 511 PEDC Projects - - - 15,289,500 512 Capital Projects-CO 2021 - - 55,834 55,834 55,834 513 Capital Projects-GO 2022 36,387,377 36,387,377 36,387,377 17,367,565 17,367,565 17,367,565 515 Capital Projects-CO 2020 (TIRZ) - - 282,303 282,303 282,303 516 Capital Projects-CO 2021 (TIRZ) 18,472,464 18,472,464 18,472,464 55,498 55,498 55,498 517 Capital Projects-CO 2022 32,808,776 32,808,776 32,808,776 26,786,884 26,786,884 26,786,884 518 Capital Projects-CO 2022 (TIRZ) 19,539,500 19,539,500 19,539,500 17,085,372 17,085,372 17,085,372 519 Capital Projects-GO 2023 - - 5,118,985 5,118,985 5,118,985 520 Capital Projects-CO 2023 - - 5,575,506 5,575,506 5,575,506 SUB TOTAL - CIP 212,152,114 212,152,114 212,152,114 273,030,838 273,030,838 288,715,682 GRAND TOTAL: 498,027,353 500,714,817 500,714,817 572,985,758 576,123,222 609,837,794 Fund Description Revenues Expenses EXHIBIT A City of Pearland Fiscal Year 2021-2022 Budget Department GL Account Budget Carry-Over Request Amount Justification Purchase Order PO Description PO Amount Remaining City Manager's Office 100-105-270.5430.020 5,425$ Training needed to be rescheduled. Carryover needed to fund IAP Software Training for Emergency Management. 2021-00001888 IAP Software Training 5,425$ City Manager's Office 100-105-270.5600.080 15,872$ Carryover needed to fund high water rescue boat. Expected delivery date is December 2021. 2021-00001914 High water rescue boat-Fire 15,873$ Community Development 100-410-420.5400.160 184,605$ Comprehensive Plan Update was authorized by Council (R2021-129) and contract spans from FY21-FY22. Project is in progress and is on the list of Supplemental and Major Items for tracking purposes.2021-00001749 Comprehensive Plan Update 184,305$ Community Development 100-410-420.5400.160 40,000$ Community Development portion of Tree Maintenance required for public property to maintain a Safe Community and Sustainable Infrastructure. Bids were collected in July of 2021 and requesting approval for carryover in order to fulfill full estimated contract amount of $235,000 including FY21 and FY22 funds. Community Development 100-305-315.5400.090 40,000$ Public Works portion of Tree Maintenance required for public property to maintain a Safe Community and Sustainable Infrastructure. Bids were collected in July of 2021 and requesting approval for carryover in order to fulfill full estimated contract amount of $235,000 including FY21 and FY22 funds. Engineering & Capital Projects 100-300-345.5400.150 987$ City cost for waterline design with the County on the Magnolia Road project. Project is not complete at this time.2020-00001569 County Road 59-Magnolia Water Line Design 987$ Engineering & Capital Projects 100-300-340.5400.150 25,000$ Due to staff working with the County and equipment not being available, we could not conduct engineering or evaluation of asphalt.2020-00001869 MSA Task 04- flexible pavement evaluation 25,000$ Engineering & Capital Projects 100-300-345.5400.150 2,650$ Ongoing Project. This is a professional service contract that remains open for the water storage building. Staff are in contact with the consultant on completing this, closing this out, getting finalized invoicing, etc. 2021-00001401 Water Storage Bldg.- Site Planning 2,650$ Engineering & Capital Projects 100-300-340.5400.150 7,705$ Ongoing Project for the Community Rating System (CRS) Program Modification that is ongoing.2021-00001657 CRS Modification 7,705$ Engineering & Capital Projects 100-300-305.5410.250 5,800$ Traffic base is custom made to fit decorative pole, item received does not fit the base, ordered the correct size.2019-00001693 Insurance Claim/Accident/Traffic Signal 5,800$ Engineering & Capital Projects 100-300-305.5400.160 5,263$ Ongoing Contract for open task order for traffic services with Cobb Fendley. 2021-00000282 MSA Task Order #5 -Traffic Operations 5,263$ Engineering & Capital Projects 100-300-305.5440.010 8,054$ Current rental contract for the bucket truck. Replacement bucket truck was ordered in April 2021. The rental is needed until the replacement vehicle arrives.2021-00000708 Bucket Truck Rental #2 8,054$ Engineering & Capital Projects 100-300-305.5110.110 75,430$ Due to supply availability and market conditions, parts & materials were unavailable or backordered.2021-00001283 Traffic Signal Heads and Components 75,430$ Engineering & Capital Projects 100-300-305.5110.060 4,315$ Due to supply availability and market conditions, parts & materials were unavailable or backordered.2021-00001283 Traffic Signal Heads and Components 4,315$ Engineering & Capital Projects 100-300-305.5110.110 1,175$ Due to supply availability and market conditions, parts & materials were unavailable or backordered.2021-00001371 Traffic Signal parts & services 1,175$ Associated Purchase OrderBudget Carry-Over Request DetailsGeneral Fund City of Pearland Budget Office 11/24/2021 Page 9 of 19 Department GL Account Budget Carry-Over Request Amount Justification Purchase Order PO Description PO Amount Remaining Associated Purchase OrderBudget Carry-Over Request DetailsGeneral Fund Engineering & Capital Projects 100-300-305.5400.160 6,300$ Due to staffing constraints, additional counts were not completed as part of the traffic committee requests.2021-00001665 Traffic Counts for the Traffic Calming Committee 6,300$ Engineering & Capital Projects 100-300-305.5400.160 28,450$ This is for the installation of Span Wire at an intersection. Staff are working with the company to close this out and get final invoices.2021-00001740 Span wire Construction 28,450$ Engineering & Capital Projects 100-300-305.5410.250 3,703$ Pending Completion - Insurance Claim 2021-00002081 Fire Station 8 Flasher-accident insurance claim 3,703$ Engineering & Capital Projects 100-300-345.5400.160 6,184$ Meritage Development Agreement - City received $34,375 per the Meritage Development agreement. Some funds have been expenses/encumbered but not all. Additional funds will need to be rolled per the agreement to continue land acquisition. Finance 100-130-100.5400.150 44,500$ This was allocated in FY21 through BA#2 by City Council for HUB Tracking. Staff has not come to a final determination on how the funds could best be used and have not spent any funding to date. Fire 100-205-100.5420.065 5,030$ Contracted Services - Current contract runs through January 2022.2021-00000871 Medical Director Services 5,030$ Fire 100-205-275.5420.100 80,500$ Project was delayed due to weather. 2021-00001906 Demolition-4653 Main St 80,500$ Fire 100-205-260.5145.025 92,122$ Manufacturer and Shipping Delays. Ordered in FY 21 and not received before October 1, 2021. 2021-00000809 Bunker Gear 92,122$ Fire 100-205-260.5400.010 21,442$ Contracted Services. Outstanding Invoices. Journal Adjustments Needed. 2021-00000894 EMS Billing Services 21,442$ Fire 100-205-260.5145.025 5,661$ Manufacturer and Shipping Delays. Ordered in FY 21 and not received before October 1, 2021. 2021-00001201 Bunker Gloves 5,661$ Fire 100-205-260.5400.160 9,589$ Contracted Services - Current Contract runs through December 2021. 2021-00001331 Dispatching Services for 2021 9,589$ Fire 100-205-260.5600.080 23,834$ Manufacturer and Shipping Delays. Ordered in FY 21 and not received before October 1, 2021. 2021-00001454 Stryker PowerLoad 23,834$ Fire 100-205-260.5115.050 7,565$ Manufacturer and Shipping Delays. Ordered in FY 21 and not received before October 1, 2021. 2021-00001563 Equipment for Burn Building 7,565$ Fire 100-205-260.5600.080 44,796$ Manufacturer and Shipping Delays. Ordered in FY 21 and not received before October 1, 2021. 2021-00001584 Ventilator and Monitor 44,796$ Fire 100-205-260.5145.020 31,934$ Manufacturer and Shipping Delays. Ordered in FY 21 and not received before October 1, 2021. Production Backorder.2021-00001694 Fire Department Uniforms 31,934$ Fire 100-205-260.5420.070 6,356$ Partial Assessments Complete. Upcoming Assessments to be Scheduled. New hires were able to complete assessments and vacant positions will require assessments. 2021-00001784 Assessment Center-BC, Captain and LT 6,356$ Fire 100-205-260.5145.025 7,583$ Manufacturer and Shipping Delays. Ordered in FY 21 and not received before October 1, 2021. 2021-00001786 Gear for Training 7,583$ Fire 100-205-260.5115.050 1,196$ Manufacturer and Shipping Delays. Ordered in FY 21 and not received before October 1, 2021. 2021-00001793 Standpipe Bag Kt 1,196$ City of Pearland Budget Office 11/24/2021 Page 10 of 19 Department GL Account Budget Carry-Over Request Amount Justification Purchase Order PO Description PO Amount Remaining Associated Purchase OrderBudget Carry-Over Request DetailsGeneral Fund Fire 100-205-260.5200.130 3,569$ Manufacturer and Shipping Delays. Ordered in FY 21 and not received before October 1, 2021. 2021-00001847 Station 3 Long Range Reader 3,569$ Fire 100-205-260.5600.080 41,900$ Work will not be completed until December 2021. Currently Under Contract. 2021-00001945 Purvis FSAS Systems 41,900$ Fire 100-205-260.5110.060 1,085$ Manufacturer and Shipping Delays. Ordered in FY 21 and not received before October 1, 2021. Long Lead Time Item. 2021-00001955 Ladder 1,085$ Fire 100-205-260.5300.030 10,000$ Programming Update Delayed. Work to be completed December 2021. Long Lead Time Item. 2021-00001971 Portable Radios 10,000$ Human Resources 100-120-100.5420.075 13,984$ PO being carried over due to preemployment screenings for fire department. New hires were hired during the 2021 -2022 fiscal year. 2021-00000539 PreEmploy & Medical Screenings for Firefighters 13,984$ Human Resources 100-120-100.5420.070 8,961$ PO being carried over due to recruitment process still in place for Assistant fire chief. HR has not received all invoices for the recruitment process. 2021-00002068 Executive Recruitment for Assistant fire Chief 3,960$ Human Resources 100-120-100.5420.070 6,344$ PO being carried over due to recruitment process still in place for Assistant fire chief. HR has not received all invoices for the recruitment process. 2021-00002068 Executive Recruitment for Assistant fire Chief 5,468$ IT 100-140-100.5300.090 1,695$ Laserfiche implementation services for build out of operational workflow necessary for the successful rollout of the new software application.2021-00000224 CS-Laserfiche Software Support 17,506$ IT 100-140-100.5445.010 1,119$ Invoices for phone services cross into October with a bill date in November.2021-00000323 AT&T Old Alvin Fire Alarm 1,119$ IT 100-140-100.5445.050 7,250$ Cellular Service for AMI communication cross into October with a bill date in November.2021-00000992 AMI CGR Internet Service 7,250$ IT 100-140-100.5300.092 5,850$ Payment Gateway Change required by Finance. Solution has been implemented but there are issues with the solution. Payment and Invoice have been held until 100% solved.2021-00001632 Public Safety Project Management Services 5,850$ IT 100-140-100.5550 38,062$ A/V equipment for Court Technology Refresh. Delays in equipment have contributed to installation delays and project completion.2021-00002084 Audio Visual and Recording Systems 95,155$ Parks 100-500-540.5300.060 $ 5,481 Delay in delivery of parts and limited work force 2021-00000108 American Maintenance - Equipment repair and maintenance to zero turn mowers $ 5,481 Parks 100-500-555.5200.130 $ 25,354 Install awaiting drawings from Sheridan. Currently running into major delays with supplies and materials. Estimated ship date for drive system is November 26th with estimated installation for the week of December 6th. 2021-00001959 Key Installations - Installation of Friction Drive Electric System - RCN Bleachers $ 25,354 Parks 100-500-510.5140.020 $ 1,175 Delays on production. 2021-00002022 CustomInk - Table Covers for Programming $ 1,175 City of Pearland Budget Office 11/24/2021 Page 11 of 19 Department GL Account Budget Carry-Over Request Amount Justification Purchase Order PO Description PO Amount Remaining Associated Purchase OrderBudget Carry-Over Request DetailsGeneral Fund Police 100-200-230.5110.020 25,893$ Nationwide ammo shortage has remaining portion of ammo on backorder. Supply and pricing for the FY22 bulk order is unknown, so PD wants to avoid eating into FY22 funds for the remaining balance. 2021-00001616 Ammunition Purchase for FY21 25,893$ Police 100-200-200.5145.020 3,566$ Large badge order that did not come in before 9/30 2021-00001855 Bulk order of Police Badges 3,566$ Police 100-200-200.5600.080 10,000$ Funds were budgeted to replace K9 that was retired in FY21 but officer vacancies prevented the department from moving another officer to K9 division after the officer with the retired K9 moved to CID. The department plans to move an officer to the K9 division and replace the retired K9 in FY22 once new officers are realized in squad staffing. Public Works 100-305-315.5200.020 21,913$ Due to paint shortage, all pavement marking areas were not completed.2021-00000704 Pavement Markings 21,913$ Public Works 100-305-315.5200.020 109,898$ Due to contract limitations staff could not expend all of the mid- year funds for the pavement markings. Per State law we could not increase the contract from the original bid/award by more than 25%. This carryover is for the additional funding Public Works received at mid-year (Budget Amendment #2) and did not have enough time from mid-year updates to bid the work out again to spend the remaining funds needed in FY21. The contract renewal recently went to Council – R2021-224. Total 1,192,125$ 1,008,269$ City of Pearland Budget Office 11/24/2021 Page 12 of 19 Department GL Account Budget Carry-Over Request Amount Justification Purchase Order PO Description PO Amount Remaining CVB 305-800-100.5400.160 7,543$ Ongoing - Adapt CVB conf room for hybrid meetings.2021-0001836 CVB Conference Room Hybrid A/V 7,453$ Community Development 331-410-100.5200.130 30,000$ Tree Trust portion of Tree Maintenance required for public property to maintain a Safe Community and Sustainable Infrastructure. Bids were collected in July of 2021 and requesting approval for carryover in order to fulfill full estimated contract amount of $235,000 including FY21 and FY22 funds. Parks 340-500-100.5600.050 22,495$ Manufacturing delays would have led to project not being completed on time.N/A Variable Frequency Drive $ - Grants 350-205-260.5430.020 34,099$ Unspent NDRI Grant Allocation 2021-00001763 Peer Support Class 2,520$ CDBG Grant Fund 351-850-800.5420.140 493,099$ Per HUD CDBG regulations, several CDBG allocations involving unspent funds MUST remain as part of the City's available CDBG Grant Fund (Fund 351) balance as they remain part of our allocated available resources for future uses (24 CFR 570). They cannot, however, always be used in future years for the administrative or social services purposes that they were originally budgeted for beyond the initial program year they were budgeted in, and in those cases will be reverted to other, unprogrammed uses (future infrastructure, facilities, etc...). Therefore, these amounts MUST be carried over into the "OTHER" budgetary account until the City decides how to reprogram these dollar amounts into HUD CDBG eligible projects and amend previous/applicable annual action plans to accommodate the affiliated project(s). There may be exceptions; specifically, social services programmed and/or unprogrammed resources that are a part of multi-year COVID-19 HUD Allocations (CDBG-CV) that can be used for those same purposes year after year. CDBG Grant Fund 351-850-800.5500 38,623$ See above CDBG Grant Fund 351-850-800.5500 186$ See above CDBG Grant Fund 351-850-800.5500 2,062$ See above CDBG Grant Fund 351-850-800.5500 92$ See above CDBG Grant Fund 351-850-800.5500 5,630$ See above CDBG Grant Fund 351-850-800.5500 2,798$ See above CDBG Grant Fund 351-850-800.5500 28$ See above CDBG Grant Fund 351-850-800.5500 13,393$ See above CDBG Grant Fund 351-850-800.5500 2,200$ See above CDBG Grant Fund 351-850-800.5500 1,156$ See above CDBG Grant Fund 351-850-800.5500 2,001$ See above CDBG Grant Fund 351-850-800.5500 50,000$ See above CDBG Grant Fund 351-850-800.5500 4,500$ See above CDBG Grant Fund 351-850-800.5500 2,100$ See above CDBG Grant Fund 351-850-800.5500 2,016$ See above Special Revenue Funds Budget Carry-Over Request Details Associated Purchase Order City of Pearland Budget Office 11/24/2021 Page 13 of 19 Department GL Account Budget Carry-Over Request Amount Justification Purchase Order PO Description PO Amount Remaining Special Revenue Funds Budget Carry-Over Request Details Associated Purchase Order CDBG Grant Fund 351-850-800.5500 912$ See above CDBG Grant Fund 351-850-800.5500 199,255$ See above CDBG Grant Fund 351-850-800.5500 1,600$ See above CDBG Grant Fund 351-850-800.5500 272$ See above CDBG Grant Fund 351-850-800.5500 500$ See above CDBG Grant Fund 351-850-800.5500 69,546$ See above CDBG Grant Fund 351-850-800.5500 8,238$ See above CDBG Grant Fund 351-850-800.5500 1,545$ See above CDBG Grant Fund 351-850-800.5500 1,100$ See above CDBG Grant Fund 351-850-800.5500 9,608$ See above 2021-00001700 CDBG-Public Services-Mental Health Services (close PO)9,608$ CDBG Grant Fund 351-850-800.5500.110 183,400$ HUD CDBG Home Repair Program 2020-00000502 Community development Block Grant (CDBG)183,400$ CDBG Grant Fund 351-850-800.5500.110 117,499$ Public Facilities and Improvements-CDBG-PNC 2021-00001801 Public Facilities and Improvements-CDBG- PNC CDBG Grant Fund 351-850-800.5500.110 236,294$ Unprogrammed CDBG Funds CDBG Disaster Recovery Fund 352-105-100.5000.010 224,136$ CDBG Disaster Recovery Fund 352-105-100.5005.010 340$ CDBG Disaster Recovery Fund 352-105-100.5005.020 28,121$ CDBG Disaster Recovery Fund 352-105-100.5005.030 15,259$ CDBG Disaster Recovery Fund 352-105-100.5005.050 3,540$ CDBG Disaster Recovery Fund 352-105-100.5005.060 35,943$ CDBG Disaster Recovery Fund 352-850-800.5500 455,342$ CDBG Disaster Recovery Fund 352-850-800.5600.010 212,259$ CDBG Disaster Recovery Fund 352-850-800.5600.030 2,135,500$ CDBG Disaster Recovery Fund 352-850-800.5600.040 2,197,713$ Hazard Mitigation Fund 354-105-100.5000.010 9,288$ Hazard Mitigation Fund 354-105-100.5005.010 1,587$ Hazard Mitigation Fund 354-105-100.5005.015 123$ Hazard Mitigation Fund 354-105-100.5005.020 735$ City of Pearland Budget Office 11/24/2021 Page 14 of 19 Department GL Account Budget Carry-Over Request Amount Justification Purchase Order PO Description PO Amount Remaining Special Revenue Funds Budget Carry-Over Request Details Associated Purchase Order Hazard Mitigation Fund 354-105-100.5005.030 1,251$ Hazard Mitigation Fund 354-105-100.5005.060 9$ Hazard Mitigation Fund 354-850-810.5400.160 504,377$ 2021-00001713 CDBG-DR-TDEM Buyouts Hurrican Harvey 77,106$ Hazard Mitigation Fund 354-850-810.5446.010 1,039$ Hazard Mitigation Fund 354-850-810.5600.030 2,700,543$ Coronavirus Relief Fund 355-850-810.5420.140 1,700$ Unspent Multi-Year Grant Funds 2021-00000556 Rental Assistance Program-CRF-PERAP- CDBG 1,700$ Coronavirus Relief Fund 355-850-810.5420.140 5,004$ Unspent Multi-Year Grant Funds 2021-00000611 Rental Assistance Program-CRF-PERAP- CDBG 5,004$ Coronavirus Relief Fund 355-850-810.5420.140 5,730$ Unspent Multi-Year Grant Funds 2021-00000616 Rental Assistance Program-CRF-PERAP- CDBG 5,730$ Coronavirus Relief Fund 355-850-810.5420.140 1,982$ Unspent Multi-Year Grant Funds 2021-00000619 Rental Assistance Program-CRF-PERAP- CDBG 1,982$ Coronavirus Relief Fund 355-850-810.5420.140 4,675$ Unspent Multi-Year Grant Funds 2021-00000622 Rental Assistance Program-CRF-PERAP- CDBG 4,675$ Coronavirus Relief Fund 355-850-810.5420.140 6,336$ Unspent Multi-Year Grant Funds 2021-00000780 Rental Assistance Program-CRF-PERAP- CDBG 6,336$ Coronavirus Relief Fund 355-850-810.5420.140 1,715$ Unspent Multi-Year Grant Funds 2021-00000767 Rental Assistance Program-CRF-PERAP- CDBG 1,715$ Coronavirus Relief Fund 355-850-810.5420.140 8,275$ Unspent Multi-Year Grant Funds 2021-00001259 Rental Assistance Program-CRF-PERAP- CDBG 8,275$ Coronavirus Relief Fund 355-850-810.5420.140 4,000$ Unspent Multi-Year Grant Funds 2021-00001573 Rental Assistance Program-CRF-PERAP- CDBG 4,000$ Coronavirus Relief Fund 355-850-810.5420.140 58,050$ 2021-00001739 CDBG-CV Nutrition Services Program- ActionS 58,050$ Coronavirus Relief Fund 355-850-810.5420.140 9,837$ 2021-00000529 Rental & Utility Assistance Program CRF 9,837$ Coronavirus Relief Fund 355-850-810.5420.140 1,241$ 2021-00000653 Rental & Utility Assistance Program CRF 1,241$ Coronavirus Relief Fund 355-850-810.5420.140 18,572$ 2021-00000672 Rental & Utility Assistance Program CRF 18,572$ Coronavirus Relief Fund 355-850-810.5420.140 2,100$ 2021-00000678 Rental & Utility Assistance Program CRF 2,100$ Total 10,200,111$ 409,303$ City of Pearland Budget Office 11/24/2021 Page 15 of 19 Department GL Account Budget Carry-Over Request Amount Justification Purchase Order PO Description PO Amount Remaining IT 600-140-100.5300.095 1,720$ Equipment Inventory depletion and delays from the manufacturer.2021-00001991 HP Thin Clients Hardware 1,720$ IT 600-140-100.5300.095 2,475$ Equipment Inventory depletion and delays from the manufacturer.2021-00002087 NUC 2,475$ Public Works 600-305-350.5300.105 34,510$ Ongoing Project - SCADA in process 2020-00001681 SCADA Design Build Contract 34,510$ Public Works 600-305-365.5300.100 19,391$ Ongoing Project - SCADA in process 2020-00001681 SCADA Design Build Contract 19,391$ Public Works 600-305-355.5400.160 79,685$ MUD invoicing is approximately two months behind. 2021-00000858 Brazoria County MUD #3 Services 79,685$ Public Works 600-305-350.5400.160 2,266$ MUD invoicing is approximately two months behind. 2021-00000858 Brazoria County MUD #3 Services 2,266$ Public Works 600-305-315.5400.090 3,304$ MUD invoicing is approximately two months behind. 2021-00000858 Brazoria County MUD #3 Services 3,304$ Public Works 600-305-365.5400.160 25,187$ MUD invoicing is approximately two months behind. 2021-00001101 Brazoria County MUD #2 Services 25,187$ Public Works 600-305-100.5400.160 20,000$ Ongoing Project - Modeling in process 2021-00001156 Wastewater Model Updates 20,000$ Public Works 600-305-100.5300.090 125,274$ Ongoing Project - Asset Management Implementation is in process 2021-00001157 Asset Management Implementation 125,274$ Public Works 600-305-100.5400.160 13,767$ Ongoing Project - Modeling in process 2021-00001483 On Call Water Modeling & Planning 13,767$ Public Works 600-305-355.5300.105 5,541$ Pending invoice 2021-00002093 Emergency Pump Rental-TS Nicholas 5,541$ Public Works 600-305-365.5170.050 105,246$ Invoicing is delayed and pending water true up invoice 2021-00000468 Purchase of Water-American Canal 105,246$ Public Works 600-305-365.5170.010 1,074,752$ Invoicing is delayed and pending water true up invoice 2021-00000588 Annual Drinking Water FM521 1,074,752$ Public Works 600-305-365.5170.020 231,593$ Invoicing is delayed and pending water true up invoice 2021-00000686 Drinking Water 10mgd 231,593$ Public Works 600-305-365.5200.130 4,908$ Due to supply availability and market conditions, parts & materials were unavailable or backordered. This is the second vendor we have attempted to order the reagents from.2021-00002075 Purchase Regents for Ammonia/Monochloramine Analyzers 4,908$ Public Works 600-305-365.5300.090 83,120$ Asset Management implementation ongoing cost. Utility Billing 600-130-390.5400.160 27,200$ Ongoing contract with Rogue Water. Contract initiated 3/25/21 and runs through FY22. Resolution #R2021-62.2021-00001280 Utility Billing Communication Consultant 27,200$ Total 1,859,940$ 1,776,820$ Associated Purchase OrderBudget Carry-Over Request DetailsEnterprise Fund City of Pearland Budget Office 11/24/2021 Page 16 of 19 Department GL Account Budget Carry-Over Request Amount Justification Purchase Order PO Description PO Amount Remaining Fire 703-305-325.5600.110 185,294$ Manufacturer and Shipping Delays. Ordered in FY 21 and not received before October 1, 2021. No Chassis Available. 2021-00001074 Emergency Services Vehicles 185,294$ Fire 703-305-325.5600.110 30,071$ Manufacturer and Shipping Delays. Ordered in FY 21 and not received before October 1, 2021. Long Lead Time Item. 2021-00001968 Mobile Radio Units for FD Vehicles 30,071$ Fire 703-305-325.5600.110 1,219$ Manufacturer and Shipping Delays. Ordered in FY 21 and not received before October 1, 2021. 2021-00001994 Cradlepoint for new FD Units 1,219$ Public Works 703-305-325.5600.110 421,259$ Pending vehicle(s) delivery 2021-00001094 Purchase of 1 GapVax Truck (S&D)421,259$ Public Works 703-305-325.5600.110 29,955$ Pending vehicle(s) delivery 2021-00001158 Purchase of 1 new replace F150 for IT 29,955$ Public Works 703-305-325.5600.110 111,013$ Pending vehicle(s) delivery 2021-00001199 Purchase of 3 vehicles 111,013$ Public Works 703-305-325.5600.110 166,271$ Pending vehicle(s) delivery 2021-00001200 Bucket Truck 166,271$ Public Works 703-305-325.5600.110 34,328$ Pending vehicle(s) delivery 2021-00001642 Purchase of One New Vehicle for EOC 34,328$ Public Works 703-305-325.5600.110 174,425$ Pending vehicle(s) delivery 2021-00001805 New Chassis and Remount Unit TL160 174,425$ Public Works 703-305-325.5300.070 63,000$ Additional fleet rental funds due to delayed vehicle manufacturing and failing vehicles, i.e. bucket truck and ambulance. Total 1,216,835$ 1,153,835$ Associated Purchase OrderBudget Carry-Over Request DetailsMotor Pool Fund City of Pearland Budget Office 11/24/2021 Page 17 of 19 Department GL Account Budget Carry-Over Request Amount Justification Purchase Order PO Description PO Amount Remaining Public Works 700-150-100.5410.250 7,338$ Due to supply availability and market conditions, parts & materials are backordered.2021-00001529 Overhead Door Repair Fire Sta #3 7,338$ Public Works 700-150-100.5410.250 8,048$ Due to supply availability and market conditions, parts & materials are backordered.2021-00001570 Overhead Door Repair Fire Sta #2 8,048$ Total 15,386$ 15,386$ Associated Purchase OrderBudget Carry-Over Request DetailsRisk Management Fund City of Pearland Budget Office 11/24/2021 Page 18 of 19 Department GL Account Budget Carry-Over Request Amount Justification Purchase Order PO Description PO Amount Remaining PEDC 900-600-100.5650 63,000$ Approved by PEDC Board Rice Drier Road Reconstruction (Phase II)63,000$ PEDC 900-600-100.5650 300,000$ Approved by PEDC Board Halik Road Reconstruction (Phase III)300,000$ PEDC 900-600-100.5650 302,000$ Approved by PEDC Board LK Park Amenities 302,000$ PEDC 900-600-100.5650 20,000$ Approved by PEDC Board 288 Corridor Enhancements (construction)20,000$ PEDC 900-600-100.5600.130 85,000$ Approved by PEDC Board Distressed Property Demolition (4653 Main)85,000$ PEDC 900-600-100.5448.070 27,300$ Approved by PEDC Board Marketing 27,300$ PEDC 900-600-100.5400.320 75,000$ Entryway maintenance repair projects intended to be completed in FY21 but ran over to FY22. Entryway Maintenance Repair Projects 75,000$ PEDC 900-600-100.5650 214,000$ Previously approved by PEDC Board and Council Alice Street Redevelopment 214,000$ PEDC 900-600-100.5650 440,000$ Previously approved by PEDC Board and Council 288 Corridor Enhancements (Construction)440,000$ PEDC 900-600-100.5650 230,000$ Previously approved by PEDC Board and Council LK Labrador Road and BW8 WL 230,000$ Total 1,756,300$ 1,756,300$ Associated Purchase OrderBudget Carry-Over Request DetailsPEDC Fund City of Pearland Budget Office 11/24/2021 Page 19 of 19 FY22 Adopted Budget Amendment #2 12/06/21 Tonight’s Discussion •What is a Carry-Over? •FY21 Unaudited Preliminary Year-end Standing •Recommended FY22 Carry-Overs & New FY22 Appropriations •General Fund •Water and Sewer Enterprise Fund •Motor Pool •Other Funds •Questions 11/30/2021 2 Defining Carry-Overs •The process of recognizing and moving some expenditures and revenues from one fiscal year to the next. •Standard practice in municipal financial management •Carry-Overs are... •Goods/services approved and ordered in FY21 but not received by September 30, 2021 •Special projects or purchases that were approved, budgeted, and scheduled to occur during FY21 but were delayed •Funds for FY21 Mid-year allocation items •Carry-Overs are not… •Items under $1,000 -Small dollar amounts are absorbed by FY22 funding •Savings meant to compensate for reductions to FY22 Budget requests •Operating and supply accounts and other recurring expenses 11/30/2021 3 General Fund 11/8/21 4 Preliminary FY21 Income Statement General Fund 11/30/2021 5 Fiscal Year 2021 year-end projects are not final because the fiscal year has not yet closed. Final figures will be shared with t he Comprehensive Annual Financial Report available in March. Figures are before the carryovers that are subject of the FY 22 budget amendment #2. These expenditures had been anticipated in FY 21 but are going to hit FY22 by virtue of this FY22 budget amendment #2. FY21 Amended Budget FY21 Unaudited Actual Variance % Variance Beginning Fund Balance $29,076,296 $29,076,297 - Revenue $91,541,723 $94,181,866 $2,640,143 2.88% Expenditures $93,827,920 $89,782,610 ($4,045,310)-4.31% Ending Fund Balance $26,790,099 $33,475,553 6,685,453 Policy Minimum Current Target (90 days) $23,135,652 90 Days $22,138,178 90 Days Amount Over Policy $3,654,447 104 Days $11,337,375 136 Days General Fund Budget Variance Notes •Revenues outperformed expectations. •Sales Taxes came in $1.87M higher than expected. •Charges for Services also contributed a positive variance of ~$330K. •Expenditures were less than expected. •This was primarily driven by Salaries & Wages, which is projected to finish with ~$1.5M or 2%remaining at year-end. •Miscellaneous Services expenditures (mostly contracts with third parties) also finished approximately $1.5M below projected expenditures. This will decrease between now and the FY21 close. 11/8/21 6 New FY21 Appropriations General Fund •Budget Amendment #2 General Fund contains $0 in New FY22 Appropriations. 11/30/2021 7 Updated FY22 Income Statement General Fund 11/30/2021 8 FY22 Amended Budget w/ Updated Fund Balance (includes Budget Amendment #1 changes)[1] Budget Carryovers FY22 Amended Budget (Budget Amendment #2) FY22 Beginning Fund Balance[2]$33,475,553 $33,475,553 Revenue $101,345,824 $101,345,824 Expenditures $101,315,796 $1,192,125[3]$102,507,921 Projected FY22 Ending Fund Balance $33,505,581 $32,313,456 Policy Minimum Target (90 days)$24,981,977 $25,275,925 Amount Over Policy $8,523,604 121 Days $7,331,479 115 Days [1]The Amended Budget for FY22 includes the changes made with Budget Amendment #1. The amendment utilized an additional $1,743,7 2 in revenue from the Texas Department of Health and Human Services to fund $450K to purchase once ambulance, $350K for capital project software, and $943,732 for street and sidewalk repairs. Budget amendment #1 was passed by Council on 11/8/21. [2]The FY22 beginning fund balance used here is the FY21 Unaudited Actuals Ending Fund Balance. [3]This figure was incorrectly listed as $1,008,269 in the Wednesday Packet memo detailing the carryover amendment. Other parts of the memo correctly referred to the full General Fund carryover amount of $1,192,125. This table has been updated with the more accurate figure. The days over policy shifted from an estimated 116 to 115. Fiscal Year 2021 year-end projects are not final because the fiscal year has not yet closed. Final figures will be shared with the Comprehensive Annual Financial Report available in March. Enterprise Operating Fund 11/30/2021 9 Carry-Over Update •The memo Council received on 11/24 incorrectly states that this amendment contains a new appropriation of $83,120 in the Enterprise Operations Fund for Asset Management. This amount is not a new appropriation and is instead a normal carryover. The item was funded in FY21. •There are no new budget appropriations in the Enterprise Fund in this amendment. 11/8/21 10 Preliminary FY22 Income statement Enterprise Operations Fund FY22 Adopted Budget w/ Updated Fund Balance Budget Carryovers New FY22 Appropriations FY22 Amended Budget Beginning Cash Equivalents $24,610,461 $24,610,461 Revenue $54,437,322 $54,437,322 Expenditures $64,055,530 $1,859,940 $65,915,470 Net $(9,618,208)$(11,478,148) Ending Cash Equivalents $14,992,253 $13,132,313 11/30/2021 11 Fiscal Year 2021 year-end projects are not final because the fiscal year has not yet closed. Final figures will be shared with the Comprehensive Annual Financial Report available in March. Bond Coverage Ratio (1.4 required) and Cash Reserve Ratio (25% required) are calculated using the combined Enterprise Fund and Enterprise Debt Fund totals. These metrics will be available in the Comprehensive Annual Financial Report. Motor Pool Fund 11/8/21 12 Other Funds One new appropriation to be aware of •The Motor Pool Fund carryover list contains an additional appropriation totaling $63K for additional fleet rental funds due to delayed vehicle manufacturing and failing vehicles. The additional funds will allow the City to rent vehicles as necessary so that mission-critical work can still be performed, rather than being postponed due to not having a vehicle. 11/30/2021 13 Motor Pool Fund Notes •This budget amendment contains $1.2M in carryover requests to pay for vehicles that were ordered last year •City Council is being asked to fund one new appropriation of $63K for to increase the vehicle and equipment rental budget. This is a new appropriation •This amendment also authorizes a new tranche of vehicle purchases in FY22, separate from the items mentioned above and the vehicles already approved for purchase by Council. •Council is being asked to appropriate $1,770,000 for a second tranche of vehicle purchases in FY22. 11/8/21 14 Equipment Replacements 11/30/2021 15 Department Unit Make Model Replacement Cost Notes DEPARTMENT:305-310 - PW -STREETS & DRAINAGE M128 VOLVO EC55 $200,000 Replace with skid steer for milling asphalt roads to couple with concrete shaver DEPARTMENT:305-310 - PW -STREETS & DRAINAGE M147 CASE 621E-XT $300,000 Replace with Grapple loader, picks up debris and vegetation DEPARTMENT:305-310 - PW -STREETS & DRAINAGE M156 ASPHALT ZIPPER AZ-390B $25,000 Replace with concrete shaver and broom DEPARTMENT:305-310 - PW -STREETS & DRAINAGE M136 BLAW-KNOX TACK TRAILER $100,000 Tack Trailer, holds tack oil for paving work Subtotal for Equipment Replacements $625,000 Vehicle Replacements 11/30/2021 16 Department Unit Make Model Replacement Cost Notes DEPARTMENT:305-315 -PW - GROUNDS MAINT.TL164 FORD F350 1 $100,000 - DEPARTMENT:305-310 -PW - STREETS & DRAINAGE TL135 FORD F450 1.5 $65,000 - DEPARTMENT:200-200 -PD -Patrol U199 CHEVROLET TAHOE $70,000 - DEPARTMENT:205-265 -FIRE MARSHAL P290 FORD F250 3/4 $40,000 - DEPARTMENT:305-330 -PW - FACILITIES P297 FORD RANGER 1/4 $40,000 - DEPARTMENT:410-415 -COMM. DEV. -PERM/INS P243 FORD F150 1/2 $40,000 - DEPARTMENT:200-200 -PD -Patrol U174 CHEVROLET TAHOE $70,000 - DEPARTMENT:305-310 -PW - STREETS & DRAINAGE P293 FORD F250 3/4 $40,000 - DEPARTMENT:205-275 -FIRE - CODE ENFORCEMENT P233 FORD F150 1/2 $40,000 - DEPARTMENT:200-200 -PD -Patrol U173 CHEVROLET TAHOE $70,000 - DEPARTMENT:205-275 -FIRE - CODE ENFORCEMENT P268 FORD RANGER 1/4 $40,000 - DEPARTMENT:300-340 - ENGINEERING P333 FORD F150 1/2 $40,000 - Subtotal for Vehicle Replacements $655,000 Total Loss Vehicle Replacements 11/30/2021 17 Department Unit Make Model Replacement Cost Notes DEPARTMENT:200-200 -PD - Patrol U167 CHEVROLET TAHOE $70,000 Vehicle struck a light pole, causing frame damage DEPARTMENT:200-200 -PD -CID C397 CHEVROLET CAPRICE $40,000 Vehicle was flooded in high water, causing the engine to knock DEPARTMENT:200-200 -PD - Patrol U188 CHEVROLET TAHOE $70,000 Vehicle struck a pedestrian vehicle in the front causing damage to the frame, TML determined total loss DEPARTMENT:200-200 -PD - Patrol -K9 U183 CHEVROLET TAHOE $70,000 Vehicle was involved in an accident involving a suspect pursuit DEPARTMENT:WS 305-350 -PW - W/S LIFT STATIONS TH160 FORD F750 $200,000 Vehicle caught fire at job site and was a total loss DEPARTMENT:WS 305-350 -PW - W/S LIFT STATIONS P428 FORD F150 1/2 $40,000 Vehicle caught fire at job site and was a total loss Subtotal for Emergency Vehicle Replacements $490,000 Carryovers -All Other Funds Fund Expense Revenue Special Revenue Funds*$10,200,111 Risk Management Fund $15,386 PEDC Fund $1,756,300 11/30/2021 18 Fiscal Year 2021 year-end projects are not final because is not yet closed. Final figures will be shared with the CAFR. *Special Revenue Fund carryovers are largely grant related. Next Steps •1st Reading –December 6th •2nd Reading –December 13th 11/30/2021 19