The URL can be used to link to this page

09.24.24 Town Council Regular Meeting PacketPage 1 of 4 ] Welcome to the Prosper Town Council Meeting. Citizens may watch the meeting live by using the following link: www.prospertx.gov/livemeetings Addressing the Town Council: Those wishing to address the Town Council must complete the Public Comment Request Form located on the Town's website or in the Council Chambers. If you are attending in person, please submit this form to the Town Secretary or the person recording the minutes for the Board/Commission prior to the meeting. When called upon, please come to the podium, and state your name and address for the record. If you are watching online, please submit this form to the Town Secretary prior to 4:00 p.m. on the day of the meeting in order for your comments to be read into the record. The Town assumes no responsibility for technical issues beyond our control. In compliance with the Texas Open Meetings Act, the Town Council/Board/Commission may not deliberate or vote on any matter that does not appear on the agenda. The Council/Board/Commission, however, may provide statements of fact regarding the topic, request the topic be included as part of a future meeting, and/or refer the topic to Town staff for further assistance. Citizens and other visitors attending Town Council meetings shall observe the same rules of propriety, decorum, and good conduct applicable to members of the Town Council. Any person making personal, impertinent, profane or slanderous remarks or who becomes boisterous while addressing the Town Council or while attending the meeting shall be removed from the room, if so directed by the Mayor or presiding officer, and the person shall be barred from further audience before the Town Council during that session. Disruption of a public meeting could constitute a violation of Section 42.05 of the Texas Penal Code. Call to Order/ Roll Call. Invocation, Pledge of Allegiance and Pledge to the Texas Flag. Announcements of recent and upcoming events. Presentations. 1. Recognition to Officer Hubbard of the Prosper Police Department for receiving an award for their work on Mental Health. (DK) 2. Proclamation to members of the Prosper Police and Fire Departments declaring October 1, 2024, as National Night Out. (MLS) 3. Proclamation to members of Prosper Fire Rescue declaring the month of October 2024 as Fire Prevention Month. (MLS) Agenda Prosper Town Council Meeting Prosper Town Hall, Council Chambers 250 W. First Street, Prosper, Texas Tuesday, September 24, 2024 6:15 PM Page 1 Page 2 of 4 CONSENT AGENDA: Items placed on the Consent Agenda are considered routine in nature and non-controversial. The Consent Agenda can be acted upon in one motion. Items may be removed from the Consent Agenda by the request of Council Members or staff. 4. Consider and act upon the minutes from the September 10, 2024, Town Council Work Session meeting. (MLS) 5. Consider and act upon the minutes from the September 10, 2024, Town Council Regular meeting. (MLS) 6. Consider and act upon the minutes from the September 17, 2024, Town Council and Planning and Zoning Commission Joint Work Session. (MLS) 7. Consider acceptance of the August 2024 monthly financial report. (CL) 8. Consider and act upon authorizing the Town Manager to execute an agreement with Flock Inc. for the lease of additional equipment, cameras, software, and services for $153,184. (DK) 9. Consider and act upon authorizing the Town Manager to execute a contract with Groves Electrical Service, Inc., in the amount of $98,700 for the installation of lighted bollards and pole lights between Town Hall and W. Broadway St. (CE) 10. Consider and act upon awarding Bid No. 2024-26-A to Wopac Construction, Inc. as the primary vendor, and Cam-Crete Contracting, Inc., as the secondary vendor, at the unit prices bid, to establish an annual contract for Miscellaneous Concrete Replacement Services; and authorizing the Town Manager to execute the same. (CJ) 11. Consider and act upon approving Change Order No. 04 for CSP 2022-48-B to Mario Sinacola & Sons Excavating, Inc., related to construction services for the First Street (Coit Road – Custer ) 4 Lane project; and authorizing the Town Manager to execute Change Order No. 4 for $122,820. (PA) 12. Consider and act upon authorizing the Town Manager to approve the purchase of traffic control-related items for Pedestrian Hybrid Beacons (PHB) at First/Copper Canyon, First/Chaucer, Gee/Lockwood, and traffic signal equipment at other project locations, from Consolidated Traffic Controls, Inc., utilizing the Houston-Galveston Area Council (HGAC) Cooperative Purchasing Program for $350,805. (PA) 13. Consider and act upon authorizing the Town Manager to enter into an agreement with Mels Electric, LLC, related to relocating existing traffic signal conduits and span wire poles at DNT / Frontier Parkway Intersection project; and authorizing the Town Manager to execute documents for $155,999.45. (PA) CITIZEN COMMENTS The public is invited to address the Council on any topic. However, the Council is unable to discuss or take action on any topic not listed on this agenda. Please complete a “Public Comment Request Form” and present it to the Town Secretary prior to the meeting. Please limit your comments to three minutes. If multiple individuals wish to speak on a topic, they may yield their three minutes to one individual appointed to speak on their behalf. All individuals yielding their time must be present at the meeting, and the appointed individual will be limited to a total of 15 minutes. Page 2 Page 3 of 4 REGULAR AGENDA: Pursuant to Section 551.007 of the Texas Government Code, individuals wishing to address the Council for items listed as public hearings will be recognized when the public hearing is opened. [If you wish to address the Council, please fill out a “Public Comment Request Form” and present it to the Town Secretary, preferably before the meeting begins.] Items for Individual Consideration: 14. Discuss and consider Town Council Subcommittee reports. (DFB) Possibly direct Town staff to schedule topic(s) for discussion at a future meeting. EXECUTIVE SESSION: Recess into Closed Session in compliance with Section 551.001 et seq. Texas Government Code, as authorized by the Texas Open Meetings Act, to deliberate regarding: Section 551.087 - To discuss and consider economic development incentives and all matters incident and related thereto. Section 551.072 - To discuss and consider purchase, exchange, lease or value of real property for municipal purposes and all matters incident and related thereto. Section 551.074 - To discuss and consider personnel matters and all matters incident and related thereto. Section 551.071 - To receive legal advice from the Town Attorney regarding various planned development legal issues and all matters incident and related thereto. Section 551.074 - To discuss appointments to the Board of Adjustment/Construction Board of Appeals, Parks & Recreation Board, Library Board, Prosper Economic Development Corporation Board, Planning & Zoning Commission, Community Engagement Committee, Downtown Advisory Committee, and the Bond Committee, and all matters incident and related thereto. Reconvene in Regular Session and take any action necessary as a result of the Closed Session. Adjourn. CERTIFICATION I, the undersigned authority, do hereby certify that this Notice of Meeting was posted at Prosper Town Hall, located at 250 W. First Street, Prosper, Texas 75078, a place convenient and readily accessible to the general public at all times, and said Notice was posted by 5:00 p.m., on Friday, September 20, 2024, and remained so posted at least 72 hours before said meeting was convened. ________________________________ _________________________ Michelle Lewis Sirianni, Town Secretary Date Notice Removed Pursuant to Section 551.071 of the Texas Government Code, the Town Council reserves the right to consult in closed session with its attorney and to receive legal advice regarding any item listed on this agenda. Page 3 Page 4 of 4 NOTICE Pursuant to Town of Prosper Ordinance No. 13-63, all speakers other than Town of Prosper staff are limited to three (3) minutes per person, per item, which may be extended for an additional two (2) minutes with approval of a majority vote of the Town Council. NOTICE OF ASSISTANCE AT PUBLIC MEETINGS: The Prosper Town Council meetings are wheelchair accessible. For special services or assistance, please contact the Town Secretary’s Office at (972) 569 -1073 at least 48 hours prior to the meeting time. Page 4 Page 1 of 2 ] Call to Order/ Roll Call. The meeting was called to order at 5:03 p.m. Council Members Present: Mayor David F. Bristol Mayor Pro-Tem Marcus E. Ray Deputy Mayor Pro-Tem Amy Bartley Councilmember Craig Andres Councilmember Chris Kern Councilmember Jeff Hodges Councilmember Cameron Reeves Staff Members Present: Mario Canizares, Town Manager Terry Welch, Town Attorney Michelle Lewis Sirianni, Town Secretary Bob Scott, Deputy Town Manager Chuck Ewings, Assistant Town Manager Robyn Battle, Executive Director David Hoover, Development Services Director Hulon Webb, Engineering Director Chris Landrum, Finance Director Whitney Rehm, Budget Officer & Grants Administrator Tony Luton, Human Resources Director Todd Rice, Communications Director Stuart Blasingame, Fire Chief Shaw Eft, Assistant Fire Chief Items for Individual Consideration 1. Discuss Denton County Fire/EMS Reimbursement Plans. (SB) Chief Blasingame presented an overview of the Town’s current agreement and fees associated with Elm Ridge Water Control and Improvement District (WCID) for fire and EMS services. Chief Blasingame also presented information regarding Denton County’s emergency responses to mutual aid within unincorporated areas. The Town Council discussed service calls, funding/operational costs, how the new methodology by Denton County affects the Town within unincorporated areas as development occurs, and how it affects the current Interlocal Agreements with Elm Ridge WCID. EXECUTIVE SESSION Recess into Closed Session in compliance with Section 551.001 et seq. Texas Government Code, as authorized by the Texas Open Meetings Act, to deliberate regarding: MINUTES Prosper Town Council Work Session Prosper Town Hall – Council Chambers 250 W. First Street, Prosper, Texas Tuesday, September 10, 2024 Page 5 Item 4. Page 2 of 2 Section 551.074 – To discuss and consider personnel matters including the review of the Municipal Judge and all matters incident and related thereto. Section 551.074 - To discuss appointments to the Board of Adjustment/Construction Board of Appeals, Parks & Recreation Board, Library Board, Prosper Economic Development Corporation Board, Planning & Zoning Commission, Community Engagement Committee, Downtown Advisory Committee, and the Bond Committee, and all matters incident and related thereto. Section 551.071 – Consultation with the Town Attorney to discuss legal issues associated with any agenda item. The Town Council recessed into Executive Session at 5:40 p.m. Reconvene into Work Session. The Town Council reconvened into the Work Session at 6:14 p.m. No action was taken. Adjourn. The meeting was adjourned at 6:15 p.m. These minutes were approved on the 24th day of September 2024. APPROVED: David F. Bristol, Mayor ATTEST: Michelle Lewis Sirianni, Town Secretary Page 6 Item 4. Page 1 of 7 ] Call to Order/ Roll Call. The meeting was called to order at 6:15 p.m. Council Members Present: Mayor David F. Bristol Mayor Pro-Tem Marcus E. Ray Deputy Mayor Pro-Tem Amy Bartley Councilmember Craig Andres Councilmember Chris Kern Councilmember Jeff Hodges Councilmember Cameron Reeves Staff Members Present: Mario Canizares, Town Manager Terry Welch, Town Attorney Michelle Lewis Sirianni, Town Secretary Bob Scott, Deputy Town Manager Chuck Ewings, Assistant Town Manager Robyn Battle, Executive Director Mary Ann Moon, EDC Executive Director Chris Landrum, Finance Director Whitney Rehm, Budget Officer & Grants Administrator David Hoover, Development Services Director Suzanne Porter, Planning Manager Hulon Webb, Engineering Director Pete Anaya, Assistant Engineering Director – Capital Projects Leigh Johnson, IT Director Muya Mwangi, Help Desk Technician I Carrie Jones, Public Works Director Mary Ann Moon, Economic Development Director Tony Luton, Human Resources Director Todd Rice, Communications Director Doug Kowalski, Police Chief Aidan Daily, Crime Analyst Stuart Blasingame, Fire Chief Shaw Eft, Assistant Fire Chief Invocation, Pledge of Allegiance and Pledge to the Texas Flag. Jason McConnell with Prosper United Methodist Church led the invocation. The Pledge of Allegiance and the Pledge to the Texas Flag were recited. An nouncements of recent and upcoming events. Councilmember Reeves made the following announcements: MINUTES Prosper Town Council Meeting Prosper Town Hall, Council Chambers 250 W. First Street, Prosper, Texas Tuesday, September 10, 2024 Page 7 Item 5. Page 2 of 7 Join us on Wednesday, September 11 at 9 a.m. for a day of remembrance. This community event will take place at Prosper Fire Rescue Central Station located at 911 Safety Way. Carter BloodCare will be on site from 7:30 a.m. to 6:00 p.m. for anyone wishing to donate. The Prosper Economic Development Corporation is hosting the next Prosper Exchange on Thursday, September 19 at 6:00 p.m. The topic “The Role of Educational Policy” will explore vital issues facing the public education system. There is no fee to attend, but residents are asked to register by visiting prosperedc.com. North Texas Giving Day runs now through Thursday, September 19. Support a local nonprofit in Prosper by making a donation or volunteering. Visit prospertx.gov/volunteeropportunities for more information. National Night Out will be held on Tuesday, October 1 from 6 pm to 9 pm. Prosper PD, Prosper ISD PD, Prosper Fire Rescue, and First Responder Volunteers will be driving to neighborhoods that want to participate. Visit prospertx.gov for more information including how to register your neighborhood to host a block party. Join us for “Celebrate Prosper” on Saturday, October 5 at Frontier Park from 4:00 to 8:00 p.m. This free family event is jam-packed with live entertainment, food, refreshments, exhibits, vendors, and a Kid Zone that spans the lawn. New Prosper residents are invited to the New Resident Mixer tent from 4:00 p.m. to 5:30 p.m. to get acquainted with Town staff and departments and to pick up a Prosper swag bag! For more information, visit the Special Events page under the Parks and Recreation Department. Mayor Bristol recognized Chief Kowalski and Chief Blasingame's birthdays. Presentations. 1. Proclamation declaring September 17 through September 23, 2024, as Constitution Week. (MLS) Mayor Bristol read and presented a Proclamation to Linda Stagner representing the Shawnee Trail Chapter of the National Society Daughters of the American Revolution. CONSENT AGENDA: Items placed on the Consent Agenda are considered routine in nature and non-controversial. The Consent Agenda can be acted upon in one motion. Items may be removed from the Consent Agenda at the request of Council Members or staff. 2. Consider and act upon the minutes from the August 27, 2024, Town Council Work Session meeting. (MLS) 3. Consider and act upon the minutes from the August 27, 2024, Town Council Regular meeting. (MLS) 4. Consider acceptance of the July 2024 monthly financial report. (CL) 5. Consider and act upon Ordinance 2024-59 amending Division 3, “Community Engagement Committee,” of Article 1.04, "Boards, Commissions, and Committee” within Chapter 1 of the Town’s Code of Ordinances by amending Section 1.04.039, "Number of Members". (MLS) Page 8 Item 5. Page 3 of 7 6. Consider and act upon approving an update to the Library Policies. (RB) 7. Consider and act upon adopting the FY 2024-2025 Prosper Economic Development Corporation Budget. (MM) 8. Consider and act upon Ordinance 2024-60 amending Section 12.09.004 "School Traffic Zones" of Chapter 12 "Traffic and Vehicles" of the Town's Code of Ordinances by modifying the limits and hours of operation of such zones. (HW) 9. Consider and act upon authorizing the Town Manager to execute a Professional Engineering Services Agreement between CP&Y, Inc. dba STV Infrastructure, and the Town of Prosper, Texas, related to the design of the Teel Parkway (First - Freeman) - 2 SB Lanes project for $806,740.30. (PA) 10. Consider and act upon whether to direct staff to submit a written notice of appeals on behalf of the Town Council to the Development Services Department, pursuant to Chapter 4, Section 1.5(C)(7) and 1.6(B)(7) of the Town’s Zoning Ordinance, regarding action taken by the Planning & Zoning Commission on Preliminary Site Plans and Site Plans. (DH) 11. Consider and act upon the appointment of a Municipal Judge, and authorize the Mayor to execute an agreement for same. (JJ) Deputy Mayor Pro-Tem Bartley requested to pull item 10. Mayor Pro-Tem Ray requested to pull item 11. Item 11, Mayor Pro-Tem Ray noted changes to the agreement. Mayor Pro-Tem Ray made a motion to reappoint Judge Moore to a two-year term. Councilmember Hodges seconded the motion. Motion carried unanimously. Item 10, Deputy Mayor Pro-Tem Bartely asked about the landscaping around the picnic area, the electric easement for the charging stations, and the extended parking spaces. Mr. Hoover addressed the charging stations and the duration that cars would be using the stations and noted that the extended parking spaces are designed to accommodate the trucks with trailers. The Town Council expressed concerns about overnight parking at the charging stations and having adequate signage in addition to the maintenance of the property. The Entitlement Manager for 7-11 addressed the Council's concerns about overnight usage of the charging stations and supports having signage. He also noted the standards for this corporate location and the property owner of this site is The Victory Group. The Market Leader for 7-11 spoke to the property maintenance. He commented that they contract with a third-party company for grass and landscaping and the day-to-day maintenance is handled through the staff during their shifts. Deputy Mayor Pro-Tem Bartley made a motion to approve item 10 as presented. Councilmember Reeves seconded the motion. Motion carried unanimously. Page 9 Item 5. Page 4 of 7 CITIZEN COMMENTS No comments were made. Items for Individual Consideration: 12. Conduct a public hearing to receive public input, consider such input, and consider and act upon Ordinance 2024-61 adopting the Fiscal Year (FY) 2024- 2025 Annual Operating and Capital Project Funds budgets and five-year Capital Improvement Program for the fiscal year beginning October 1, 2024, and ending September 30, 2025. (CL) Mr. Landrum presented an overview of the fiscal year 2024-2025 budget including key revenue drivers, staffing, General Fund enhancements, the debt service fund, capital projects, and the multi-year capital program. Mayor Bristol opened the public hearing. No comments were made. Mayor Bristol closed the public hearing. Mayor Pro-Tem Ray made a motion to approve Ordinance 2024-61 adopting the Fiscal Year (FY) 2024-2025 Annual Operating and Capital Project Funds budgets and five- year Capital Improvement Program for the fiscal year beginning October 1, 2024, and ending September 30, 2025. Councilmember Hodges seconded the motion. Councilmember Reeves – In Favor Councilmember Hodges – In Favor Deputy Mayor Pro-Tem Bartley – In Favor Mayor Bristol – In Favor Mayor Pro-Tem Ray – In Favor Councilmember Kern – In Favor Councilmember Andres – In Favor Motion carried unanimously. 13. Conduct a public hearing to consider and act upon Ordinance 2024-62 adopting a tax rate of $0.505 per $100 valuation for fiscal year 2024-2025. (CL) Mr. Landrum presented the historical property valuations, the proposed tax rate for the fiscal year 2024-2025, and how the tax rate is divided with other tax rates (ISD and County) within Collin and Denton County. Mayor Bristol opened the public hearing. No comments were made. Mayor Bristol closed the public hearing. Councilmember Andres made a motion that the property tax rate be increased by the adoption of a tax rate of $0.505 per $100 valuation for fiscal year 2024-2025, which is Page 10 Item 5. Page 5 of 7 effectively an 8.15 percent increase in the tax rate. Deputy Mayor Pro-Tem Bartley seconded the motion. Councilmember Reeves – In Favor Councilmember Hodges – In Favor Deputy Mayor Pro-Tem Bartley – In Favor Mayor Bristol – In Favor Mayor Pro-Tem Ray – In Favor Councilmember Kern – In Favor Councilmember Andres – In Favor Motion carried unanimously. 14. Ratifying the property tax increase in the budget for fiscal year (FY) 2024-2025. (CL) Mr. Landrum noted this item is required by state law and ratifies the property tax increase reflected in the budget. Councilmember Hodges made a motion to ratify the property tax increase in the budget for fiscal year 2024-2025. Councilmember Reeves seconded the motion. Motion carried unanimously. 15. Consider and act upon approving Ordinance 2024-63 to adjust Water & Wastewater Rates. (CL) Mr. Landrum presented the item with a historical overview of the Town’s water and wastewater rates. The Town has not needed to raise rates since 2020. In recent years rapid growth in the region has required significant investment on the part of the Town’s regional providers, and the need to expand the capacity of the Doe Branch wastewater treatment plant to support growth on the west side has resulted in the need for an FY 2025 rate adjustment. The proposed rate adjustments represent a 6.35% increase in water rates and a 16% rate increase for wastewater rates or a blended rate increase of 8.77% based on the wastewater revenues representing a much smaller portion of total revenues. The Town Council discussed member cities versus non-member cities and how the Town continues to absorb part of the rate increase. Councilmember Kern made a motion to approve Ordinance 2024-63 to adjust Water and Wastewater fee amendments effective October 15, 2024. Mayor Pro-Tem Ray seconded the motion. Motion carried unanimously. Councilmember Andres left the dais. 16. Consider and act upon Resolution 2024-64 of the Town Council of the Town of Prosper, Texas, declaring the public necessity to acquire certain properties for right-of-way and easements for the construction of the Coleman Street (Gorgeous – Talon) project; determining the public use and necessity for such acquisition; authorizing the acquisition of property rights necessary for said Project; appointing an appraiser and negotiator as necessary; authorizing the Town Manager to establish just compensation for the property rights to be acquired; authorizing the Town Manager to take all steps necessary to acquire Page 11 Item 5. Page 6 of 7 the needed property rights in compliance with all applicable laws and resolutions; and authorizing the Town Attorney to institute condemnation proceedings to acquire the property if purchase negotiations are not successful. (HW) Mr. Webb stated the Town is in the process of developing engineering plans for the construction of the Coleman Street (Gorgeous – Talon) project. To facilitate the construction of the project, it is necessary for the Town to acquire right-of-way and easements. There are 17 properties affected. It is not anticipated that all parcels will require the use of eminent domain to complete the acquisition process, however, staff is requesting advance authorization to pursue acquisition by eminent domain if standard negotiations are unsuccessful. Mayor Pro-Tem Ray made a motion to approve Resolution 2024-64 declaring the public necessity to acquire certain properties for right-of-way and easements for the construction of the Coleman Street (Gorgeous – Talon) project with such properties being more particularly described in the attached Resolution; determining the public use and necessity for such acquisition; authorizing the acquisition of property rights necessary for said Project; appointing an appraiser and negotiator as necessary; authorizing the Town Manager to establish just compensation for the property rights to be acquired; authorizing the Town Manager to take all steps necessary to acquire the needed property rights in compliance with all applicable laws and resolutions; and authorizing the Town Attorney to institute condemnation proceedings to acquire the property if purchase negotiations are not successful. Deputy Mayor Pro-Tem Bartley seconded the motion. Councilmember Reeves – In Favor Councilmember Hodges – In Favor Deputy Mayor Pro-Tem Bartley – In Favor Mayor Bristol – In Favor Mayor Pro-Tem Ray – In Favor Councilmember Kern – In Favor Motion carried unanimously. Councilmember Andres returned to the dais. 17. Discuss and consider Town Council Subcommittee reports. (DFB) Community Engagement Committee: Deputy Mayor Pro-Tem Bartley noted the committee discussed how to efficiently get people to attend events and will be reviewing the full event calendar for other possible opportunities. CIP Subcommittee: The committee discussed the finance items listed on the agenda. Finance Subcommittee: The committee discussed the finance items listed on the agenda. Possibly direct Town staff to schedule topic(s) for discussion at a future meeting. Councilmember Andres requested staff to research and continue conversations with Denton County regarding the contract with Elm Ridge WCID (Artesia) regarding fire and mutual aid services. Page 12 Item 5. Page 7 of 7 EXECUTIVE SESSION: Recess into Closed Session in compliance with Section 551.001 et seq. Texas Government Code, as authorized by the Texas Open Meetings Act, to deliberate regarding: Section 551.087 – To discuss and consider economic development incentives and all matters incident and related thereto. Section 551.072 – To discuss and consider the purchase, exchange, lease, or value of real property for municipal purposes and all matters incident and related thereto. Section 551.074 – To discuss and consider personnel matters and all matters incident and related thereto. Section 551.071 - To consult with the Town Attorney regarding BFS Real Estate LLC, et al., v. Town of Prosper, et al., pending in the 471st Judicial District Court of Collin County, Texas, and all matters incident and related thereto; and discuss and consider anticipated litigation regarding contractual obligations. Section 551.074 - To discuss appointments to the Board of Adjustment/Construction Board of Appeals, Parks & Recreation Board, Library Board, Prosper Economic Development Corporation Board, Planning & Zoning Commission, Community Engagement Committee, and the Downtown Advisory Committee, and all matters incident and related thereto. The Town Council recessed into Executive Session at 7:20 p.m. Reconvene in Regular Session and take any action necessary as a result of the Closed Session. The Town Council reconvened into Regular Session at 8:40 p.m. No action was taken. Adjourn. The meeting was adjourned at 8:41 p.m. These minutes were approved on the 24th day of September 2024. APPROVED: David F. Bristol, Mayor ATTEST: Michelle Lewis Sirianni, Town Secretary Page 13 Item 5. Page 1 of 2 ] Town Council Call to Order/Roll Call. Mayor Bristol called the meeting to order at 5:02 p.m. Council Members Present: Mayor David F. Bristol Deputy Mayor Pro-Tem Amy Bartley Councilmember Craig Andres Councilmember Chris Kern Councilmember Jeff Hodges Councilmember Cameron Reeves Council Members Absent: Mayor Pro-Tem Marcus E. Ray Planning and Zoning Commission Call to Order/Roll Call. Chair Daniel called the meeting to order at 5:03 p.m. Planning and Zoning Commission Members Present: Chair Brandon Daniel Vice-Chair Damon Jackson Commissioner Sekou Harris Commissioner John Hamilton Commissioner Josh Carson Commissioner Glen Blanscet Staff Members Present: Mario Canizares, Town Manager Terry Welch, Town Attorney Robyn Battle, Executive Director Mary Ann Moon, EDC Executive Director Michelle Lewis Sirianni, Town Secretary David Hoover, Development Services Director Suzanne Porter, Planning Manager Dakari Hill, Senior Planner Trey Ramon, Planning Technician Items for Individual Consideration: 1. Discussion of a proposal to modify the Gates of Prosper Planned Development (PD- 67), located west of Preston Road between US 380 (University Drive) and First Street. (DH) Mr. Canizares introduced the item. Scott Shipp, Director of Engineering for Blue Star Land presented a history of land purchases and locations of each within the Town. Mr. Shipp indicated they are MINUTES Prosper Town Council & Planning and Zoning Commission Joint Work Session Prosper Town Hall – Council Chambers 250 W. First Street, Prosper, Texas Tuesday, September 17, 2024 Page 14 Item 6. Page 2 of 2 requesting feedback from the Commission and Town Council regarding a proposed fourth amendment, which includes two changes within Planned Development 67 (Gates of Prosper). The first proposed amendment within Subdistrict 2 is for an additional 600 multi-family units to be completed in two phases. The second proposed amendment within Subdistrict 3 is for an additional 150 single-family units. This subdistrict already includes 150 townhomes. The Town Council and Commission Members discussed each Subdistrict and the impact the proposed changes may have with the addition of the multi-family units regarding the increased density, the size of the residential lots in Subdistrict 3, and the placement of the townhomes. It was noted that the Town Council and Commission Members are looking at the developing area holistically for future impact and best uses for buildout. 2. Discussion regarding mixed-use developments within the Town of Prosper. (DH) No further comments or discussions took place on this item. Adjourn. The meeting was adjourned at 6:28 p.m. These minutes were approved on the 24th day of September 2024. APPROVED: David F. Bristol, Mayor ATTEST: Michelle Lewis Sirianni, Town Secretary Page 15 Item 6. Page 1 of 2 To: Mayor and Town Council From: Chris Landrum, Finance Director Through: Mario Canizares, Town Manager Bob Scott, Deputy Town Manager Re: August 2024 Monthly Financial Report Town Council Meeting – September 24, 2024 Strategic Visioning Priority: 4. Provide Excellent Municipal Services Agenda Item: Consider acceptance of the August 2024 monthly financial report. Description of Agenda Item: The Town Charter requires the submission of monthly financial reports to the Town Council. In summary, both revenues and expenditures are within the expected ranges and no unexpected events have occurred that require significant changes in original projections. The attached monthly financial report for August 2024 was prepared in the old format. This format is not particularly “user friendly” and staff is looking to reformat the monthly financial reports after the ERP software conversion. Budget Impact: There is no budgetary impact affiliated with this item. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has approved the attached documents as to form and legality. Attached Documents: 1. Monthly Financial Report – August 31, 2024 Town Staff Recommendation: Town staff recommends Town Council vote to accept submission of the monthly financial report for the period August 2024 in compliance with the requirements of the Town Charter. FINANCE Page 16 Item 7. Page 2 of 2 Proposed Motion: I move to accept the August 2024 Monthly Financial Report in compliance with charter requirements. Page 17 Item 7. MONTHLY FINANCIAL REPORT as of August 31, 2024 Cash/Budgetary Basis Prepared by Finance Department September 24, 2024 Page 18 Item 7. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 2024 Table of Contents General Fund 3 General Fund Charts 4 - 7 Crime Control and Prevention Special Purpose District 8 Fire Control, Prevention, and Emergency Medical Services Special Purpose District 9 TIRZ #1 - Blue Star 10 TIRZ #2 11 Debt Service Fund 12 Special Revenue Fund 13 Park Dedication and Improvement Fund 14 East Thoroughfare Impact Fees Fund 15 West Thoroughfare Impact Fees Fund 16 Water Impact Fees Fund 17 Wastewater Impact Fees Fund 18 Impact Fee Chart 19 Vehicle and Equipment Replacement Fund 20 Health Insurance Fund 21 Water-Sewer Fund 22 - 23 Water-Sewer Fund Charts 24 - 26 Storm Drainage Utility Fund 27 Solid Waste Fund 28 Solid Waste Fund Chart 29 Capital Projects Fund-General 30 - 31 Capital Projects Fund-Water/Sewer 32 Page 19 Item 7. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Amendment Budget YTD Actuals Encumbrances Budget Balance YTD Percent Note YTD Actuals Prior Year REVENUES Property Taxes 21,146,121$ -$ 21,146,121$ 20,569,253$ -$ 576,868$ 97%1,3,5 23,682,014$ -13% Sales Taxes 11,091,492 - 11,091,492 10,265,922 - 825,570 93%9,236,322 11% Franchise Fees 3,221,816 - 3,221,816 2,609,629 - 612,187 81%2 2,278,864 15% Building Permits 3,700,000 - 3,700,000 4,061,910 - (361,910) 110%3,625,375 12% Other Licenses, Fees & Permits 2,180,050 - 2,180,050 1,544,241 - 635,809 71%8 2,033,119 -24% Charges for Services 1,296,023 - 1,296,023 1,344,221 - (48,198) 104%1,159,889 16% Fines & Warrants 300,500 - 300,500 389,449 - (88,949) 130%360,639 8% Intergovernmental Revenue (Grants)37,840 - 37,840 180,815 - (142,975) 478%180,823 0% Interest Income 750,000 - 750,000 930,689 - (180,689) 124%877,138 6% Miscellaneous 63,751 - 63,751 222,722 - (158,971) 349%124,434 79% Park Fees 814,100 - 814,100 614,487 - 199,613 75%9 597,231 3% Transfers In 1,297,102 6,084 1,303,186 1,189,010 - 114,176 91%1,132,390 5% Total Revenues 45,898,795$ 6,084$ 45,904,879$ 43,922,348$ -$ 1,982,531$ 96%45,288,236$ -3% EXPENDITURES Administration 9,991,267$ (53,954)$ 9,937,313$ 9,158,142$ 454,092$ 325,079$ 97%7 7,484,722$ 22% Police 9,595,898 411,208 10,007,106 8,952,069 792,143 262,894 97%7 6,092,477 47% Fire/EMS 10,562,840 (14,528) 10,548,312 9,704,812 95,878 747,622 93%7 8,941,740 9% Public Works 4,567,242 90,681 4,657,923 3,799,610 684,068 174,245 96%7 3,196,832 19% Community Services 7,486,803 (64,931) 7,421,873 6,570,738 492,652 358,483 95%7 5,101,287 29% Development Services 4,139,855 (559) 4,139,296 2,907,345 37,576 1,194,375 71%2,728,886 7% Engineering 2,684,047 15,613 2,699,660 2,324,089 17,480 358,092 87%2,461,799 -6% Transfers Out - 446,389 446,389 446,389 - - 100%4 5,835,364 -92% Total Expenses 49,027,952$ 829,920$ 49,857,872$ 43,863,193$ 2,573,889$ 3,420,790$ 93%41,843,106$ 5% REVENUE OVER (UNDER) EXPENDITURES (3,129,157)$ (823,836)$ (3,952,993)$ 59,155$ 3,445,131$ Beginning Fund Balance October 15,011,987 15,011,987 Ending Fund Balance 11,058,994$ 15,071,142$ Notes 1 Property taxes are billed in October and the majority of collections occur December through February. 2 Franchise fees are paid quarterly or annually in arrears. 3 The negative change from prior year is due to the capital dedicated portion of the levy being recorded directly to the capital project fund. 4 Transfers Out consists of $122,500 for Downtown Streets & Alleys, $140,000 for Parks Master Plan & $183,889 for Downtown Improvements, to Capital Projects Fund. 5 2023 TIRZ annual payments reduced April property tax collections by $1.65M. 6 Fund Balance Contingency per Charter and Reserve for FY23 = $9,586,518 (21%). 7 Encumbrances, capital expeditures and annual payments that cover year-round services cause YTD percentages to show above the expected amount. 8 HB 3492 caused a change in municipal billings for inspection fees which resulted in less revenues than anticipated. 9 Funding for the NLC Dream Court did not go through the Town as originally budgeted. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 Expected Year to Date Percent 91.67% GENERAL FUND 3 Page 20 Item 7. $20,569,253 10,265,922 2,609,629 4,061,910 $23,682,014 9,236,322 2,278,864 3,625,375 $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 Property Taxes Sales Taxes Franchise Fees Building Permits GENERAL FUND REVENUE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 4 Page 21 Item 7. 0 $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 Total Budget YTD Budget YTD Actual Building Permit Revenues 0 500,000 1,000,000 1,500,000 2,000,000 2,500,000 Oct Nov Dec Jan Feb Mar Apr May June July Aug Sept Town of Prosper, Texas Sales Tax Revenue by Month FY 19/20 FY 20/21 FY 21/22 FY22/23 FY23/24 5 Page 22 Item 7. 97% 93% 81% 110% 71% 104% 478% Property Taxes Sales Taxes Franchise Fees Building Permits Other Licenses, Fees & Permits Charges for Services Intergovernmental Revenue (Grants) 0%100%200%300%400%500%600% GENERAL FUND YTD REVENUE % OF ANNUAL BUDGET 6 Page 23 Item 7. $49.858 $45.703 $43.863 $45.905 $42.079 $43.922 $- $10 $20 $30 $40 $50 $60 Total Budget YTD Budget YTD Actual In Millions General Fund Revenues and Expenditures Revenues Expenditures 7 Page 24 Item 7. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Amendment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Sales Tax - Town 3,060,806$ -$ 3,060,806$ 2,758,734$ -$ 302,072$ 90%2,462,233$ 12% Interest Income 1,200 - 1,200 - - 1,200 0%(1,290) -100% Other - - - - - - 0%- 0% Total Revenue 3,062,006$ -$ 3,062,006$ 2,758,734$ -$ 303,272$ 90%2,460,943$ 12% EXPENDITURES Personnel 3,167,364$ -$ 3,167,364$ 2,663,620$ -$ 503,744$ 84%2,579,145$ 3% Other 1,200 - 1,200 9,955 - (8,755) 830%(5,462) -282% Total Expenditures 3,168,564$ -$ 3,168,564$ 2,673,575$ -$ 494,989$ 84%2,573,683$ 4% REVENUE OVER (UNDER) EXPENDITURES (106,558)$ -$ (106,558)$ 85,159$ (112,740)$ Beginning Fund Balance October 1 210,707 210,707 302,439 Ending Fund Balance Current Month 104,149$ 295,867$ 189,699$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 Expected Year to Date Percent 91.67% CRIME CONTROL AND PREVENTION SPECIAL PURPOSE DISTRICT 8 Page 25 Item 7. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Amendment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Sales Tax - Town 3,060,806$ -$ 3,060,806$ 2,759,065$ -$ 301,741$ 90%2,459,875$ 12% Interest Income 600 - 600 4,265 - (3,665) 711%2,155 98% Other - - - - - - 0%- 0% Total Revenue 3,061,406$ -$ 3,061,406$ 2,763,331$ -$ 298,075$ 90%2,462,031$ 12% EXPENDITURES Personnel 3,026,823$ -$ 3,026,823$ 2,578,555$ -$ 448,268$ 85%2,381,206$ 8% Other 2,400 - 2,400 9,955 - (7,555) 415%(5,462) -282% Total Expenditures 3,029,223$ -$ 3,029,223$ 2,588,510$ -$ 440,713$ 85%2,375,743$ 9% REVENUE OVER (UNDER) EXPENDITURES 32,183$ -$ 32,183$ 174,820$ 86,287$ Beginning Fund Balance October 1 495,556 495,556 203,982 Ending Fund Balance Current Month 527,739$ 670,376$ 290,269$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 Expected Year to Date Percent 91.67% FIRE CONTROL, PREVENTION, AND EMERGENCY MEDICAL SERVICES SEPCIAL PURPOSE DISTRICT 9 Page 26 Item 7. Original Budget Amended Current Year Current Remaining Prior Year Change from Budget Amendment Budget YTD Actual Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Impact Fee Revenue: Water Impact Fees -$ -$ -$ 80,996$ (80,996)$ 0%-$ 0% Wastewater Impact Fees 750,000 - 750,000 548,032 201,968 73%325,896 68% East Thoroughfare Impact Fees - - - 65,244 (65,244) 0%- 0% Property Taxes - Town (Current)1,108,174 - 1,108,174 1,108,174 0 100%810,076 37% Property Taxes - Town (Rollback)- - - 486,411 (486,411) 0%1 - 0% Property Taxes - County (Current)236,601 - 236,601 231,790 4,811 98%172,956 34% Sales Taxes - Town 1,372,209 - 1,372,209 1,080,862 291,347 79%2 847,097 28% Sales Taxes - EDC 1,149,225 - 1,149,225 905,222 244,003 79%2 709,444 28% Interest Income 6,000 - 6,000 121,138 (115,138) 2019%72,474 67% Transfer In - - - - - 0%- 0% Total Revenue 4,622,209$ -$ 4,622,209$ 4,627,869$ (5,660)$ 100%2,937,942$ 58% EXPENDITURES Professional Services 6,000$ -$ 6,000$ -$ 6,000$ 0%-$ 0% Developer Rebate 4,616,209 - 4,616,209 5,096,884 (480,675) 110%1 3,607,318 41% Transfers Out - - - - - 0%- 0% Total Expenses 4,622,209$ -$ 4,622,209$ 5,096,884$ (474,675)$ 110%3,607,318$ 41% REVENUE OVER (UNDER) EXPENDITURES -$ (469,015)$ (669,375)$ Beginning Fund Balance October 1 989,032 989,032 301,260 Ending Fund Balance Current Month 989,032$ 520,017$ (368,115)$ Notes 1 Unbudgeted Rollback taxes received from Collin County and rebated to developer. 2 New TIRZ businesses resulted in lower sales tax increase than anticipated. August 31, 2024 Expected Year to Date Percent 91.67% TIRZ #1 - BLUE STAR TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT 10 Page 27 Item 7. Original Budget Amended Current Year Current Remaining Prior Year Change from Budget Amendment Budget YTD Actual Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Property Taxes - Town (Current)39,537$ -$ 39,537$ 39,537$ (0)$ 100%33,061$ 20% Property Taxes - Town (Rollback)- - - 44,560 (44,560) 0%1 - 0% Property Taxes - County (Current)8,441 - 8,441 8,270 171 98%7,059 17% Sales Taxes - Town - - - 7,194 (7,194) 0%2 - 0% Sales Taxes - EDC - - - 7,194 (7,194) 0%2 - 0% Interest Income 1,200 - 1,200 3,099 (1,899) 258%1,468 111% Total Revenue 49,178$ -$ 49,178$ 109,854$ (60,676)$ 223%41,587$ 164% EXPENDITURES Professional Services -$ -$ -$ -$ -$ 0%-$ 0% Developer Rebate 49,178 - 49,178 110,272 (61,094) 224%1,2 41,006 169% Transfers Out - - - - - 0%- 0% Total Expenditures 49,178$ -$ 49,178$ 110,272$ (61,094)$ 224%41,006$ 169% REVENUE OVER (UNDER) EXPENDITURES -$ (418)$ 582$ Beginning Fund Balance October 1 25,501 25,501 25,189 Ending Fund Balance Current Month 25,501$ 25,083$ 25,771$ Notes 1 Unbudgeted Rollback taxes received from Collin County and rebated to developer. 2 New sales tax remmittance received and rebated to developer. TIRZ #2 TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 Expected Year to Date Percent 91.67% 11 Page 28 Item 7. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Amendment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Property Taxes-Delinquent 75,000$ -$ 75,000$ 236,209$ -$ (161,209)$ 315%170,756$ 38% Property Taxes-Current 15,069,531 - 15,069,531 15,121,395 - (51,864) 100%1 13,129,675 15% Taxes-Penalties 40,000 - 40,000 64,191 - (24,191) 160%43,809 47% Interest Income 20,000 - 20,000 245,480 - (225,480) 1227%138,013 78% Transfer In - - - - - - 0%- 0% Total Revenues 15,204,531$ -$ 15,204,531$ 15,667,275$ -$ (462,744)$ 103%13,482,254$ 16% EXPENDITURES Professional Services -$ -$ -$ 2,500$ -$ (2,500)$ 0%-$ 0% Bond Administrative Fees 20,000 - 20,000 3,154 - 16,846 16%500 531% 2013 GO Refunding Bond 185,000 (185,000) - - - - 0%180,000 -100% 2014 GO Debt Payment 335,000 - 335,000 335,000 - - 100%315,000 6% 2015 GO Debt Payment 1,365,700 - 1,365,700 1,365,700 - - 100%1,309,200 4% 2015 CO Debt Payment 475,000 - 475,000 475,000 - - 100%465,000 2% 2016 GO Debt Payment - - - - - - 0%- 0% 2016 CO Debt Payment 90,000 - 90,000 90,000 - - 100%80,000 13% 2017 CO Debt Payment 450,000 - 450,000 450,000 - - 100%85,000 429% 2018 GO Debt Payment 150,000 - 150,000 150,000 - - 100% 2 145,000 3% 2018 CO Debt Payment 500,000 - 500,000 500,000 - - 100%475,000 5% 2019 CO Debt Payment 340,022 - 340,022 340,022 - - 100%399,806 -15% 2019 GO Debt Payment 165,000 - 165,000 165,000 - - 100%160,000 3% 2020 CO Debt Payment 265,000 - 265,000 265,000 - - 100%255,000 4% 2021 CO Debt Payment 260,000 - 260,000 260,000 - - 100%245,000 6% 2021 GO Debt Payment 1,290,000 - 1,290,000 1,290,000 - - 100%1,225,000 5% 2022 GO Debt Payment 3,603,450 (2,633,450) 970,000 970,000 - - 100%1,890,000 -49% 2023 GO Debt Payment - 2,055,000 2,055,000 2,055,000 - - 100%- 0% 2023 GO Refunding Debt Payment - 175,000 175,000 175,000 - - 100%- 0% Bond Interest Expense 5,458,264 1,383,880 6,842,144 6,842,143 - 1 100%5,594,880 22% Total Expenditures 14,952,436$ 795,430$ 15,747,866$ 15,733,518$ -$ 14,347$ 100%12,824,386$ 23% REVENUE OVER (UNDER) EXPENDITURES 252,095$ (795,430)$ (543,335)$ (66,243)$ 657,868$ Beginning Fund Balance October 1 1,330,265 1,330,265 2,619,367 Ending Fund Balance Current Month 786,930$ 1,264,022$ 3,277,235$ Notes 1 Property taxes are billed in October and the majority of collections occur December through February. 2 Annual debt service payments are made in February and August. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 Expected Year to Date Percent 91.67% DEBT SERVICE FUND 12 Page 29 Item 7. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Amendment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Police Donation Revenue 15,500$ -$ 15,500$ 18,297$ -$ (2,797)$ 118%21,656$ -16% Fire Donation Revenue 15,500 - 15,500 17,284 - (1,784) 112%14,251 21% Child Safety Revenue 28,000 - 28,000 21,663 - 6,337 77%4 20,956 3% Court Security Revenue 8,000 - 8,000 11,530 - (3,530) 144%10,691 8% Court Technology Revenue 7,500 - 7,500 9,501 - (2,001) 127%8,878 7% Municipal Jury revenue 150 - 150 232 - (82) 154%212 9% Tree Mitigation Revenue - - - 204,694 - (204,694) 0%1,298,694 -84% Police Seizure Revenue - - - 13,333 - (13,333) 0%12,070 10% LEOSE Revenue 3,000 - 3,000 8,756 - (5,756) 292%2,416 262% CARES Act/ARPA Funding 6,102,367 (6,102,367) - - - - 0%- 0% Escrow Income - - - 167,514 - (167,514) 0%673,667 -75% Interest Income 2,425 - 2,425 100,819 - (98,394) 4157%33,819 198% Interest Income CARES/ARPA Funds 180,000 - 180,000 112,455 - 67,545 62%213,655 -47% Transfer In - - - - - - 0%- 0% Total Revenue 6,362,442$ (6,102,367)$ 260,075$ 686,076$ -$ (426,001)$ 264%2,310,963$ -70% EXPENDITURES Police Donation Expense 26,872 - 26,872 14,169 11,940 763 97%3 18,322 -23% Fire Donation Expense 10,000 - 10,000 2,980 - 7,020 30%8,546 -65% Child Safety Expense 3,000 - 3,000 2,162 - 838 72%22,238 -90% Court Security Expense 16,860 - 16,860 - - 16,860 0%50 -100% Court Technology Expense 13,950 - 13,950 - - 13,950 0%- 0% Tree Mitigation Expense - - - - - - 0%- 0% Police Seizure Expense 12,995 - 12,995 4,074 - - 31%4,647 -12% LEOSE Expenditure 6,500$ -$ 6,500$ 3,955$ -$ 2,545$ 61%5,050$ -22% Transfer Out (ARPA Funds)6,348,861 (6,102,367) 246,494 - - 246,494 0%- 0% Transfer Out (Tree Mitigation Funds)- - - 200,000 - (200,000) 0%1 - 0% Transfer Out (Escrow Funds)- - - 167,514 - (167,514) 0%2 673,667 -75% Total Expenses 6,439,038$ (6,102,367)$ 336,671$ 394,855$ 11,940$ (79,045)$ 121%683,364$ -42% REVENUE OVER (UNDER) EXPENDITURES (76,596)$ -$ (76,596)$ 291,221$ 1,627,599$ Beginning Fund Balance October 1 2,353,529 2,353,529 567,535 Ending Fund Balance Current Month 2,276,933$ 2,644,751$ 2,195,134$ Notes 1 $200,000 for Lakewood Preserve project budgeted in Capital Projects Fund. 2 $167,514 for Windsong Escrow to Impact Fee Fund for Developer Reimbursement. 3 4 Child Safety Revenue collected quarterly. Encumbrance for capital equipment, a one-time purchase, does not follow expected percentage. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 Expected Year to Date Percent 91.67% SPECIAL REVENUE FUNDS 13 Page 30 Item 7. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Amendment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES 60-4 Park Dedication-Fees 300,000$ -$ 300,000$ 737,375$ -$ (437,375)$ 246%205,514$ 259% 60-4 Park Improvements 220,000 - 220,000 646,146 - (426,146) 294%144,000 349% Contributions/Grants - - - - - - 0%200,550 -100% 60-4 Interest-Park Dedication 2,000 - 2,000 36,184 - (34,184) 1809%35,233 3% 60-4 Interest-Park Improvements 4,050 - 4,050 40,520 - (36,470) 1000%31,491 29% Park Dedication - Transfers In - - - - - - - 0%- 0% Total Revenue 526,050$ -$ 526,050$ 1,460,226$ -$ (934,176)$ 278%616,788$ 137% EXPENDITURES Pecan Grove Park -$ 5,200$ 5,200$ 5,200$ -$ -$ 100%749,736$ -99% Capital Project 800,000 (800,000) - - - - 0%- 0% Land Acquisition 913,800 (913,800) - - - - 0%- 0% Transfers Out - 2,863,800 2,863,800 2,113,800 - 750,000 74%1 - 0% Total Expenses 1,713,800$ 1,155,200$ 2,869,000$ 2,119,000$ -$ 750,000$ 74%749,736$ 183% REVENUE OVER (UNDER) EXPENDITURES (1,187,750)$ (1,155,200)$ (2,342,950)$ (658,774)$ (132,948)$ Beginning Fund Balance October 1 2,316,978 2,316,978 Ending Fund Balance Current Month (25,972)$ 1,658,204$ Notes 1 $400,000 for Lakewood Preserve, $913,800 for Windsong Park land dedication, $50,000 Downtown Park/Broadway, $750,000 Windsong Park #3 TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 Expected Year to Date Percent 91.67% PARK DEDICATION AND IMPROVEMENT FUNDS 14 Page 31 Item 7. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Amendment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES East Thoroughfare Impact Fees 1,200,000$ -$ 1,200,000$ 956,736$ East Thoroughfare Other Revenue - - - - Interest-East Thoroughfare Impact Fees 100,000 - 100,000 147,092 Total Revenues 1,300,000$ -$ 1,300,000$ 1,103,828$ EXPENDITURES Developer Reimbursements FM 1461 (SH289-CR 165)175,000$ 175,000$ -$ 175,000$ 77,074$ -$ 97,927$ -$ 97,927$ Cambridge Park Estates 250,000 250,000 - 250,000 182,610 - 67,390 - 67,390 Total Developer Reimbursements 425,000$ 425,000$ -$ 425,000$ 259,684$ -$ 165,317$ -$ 165,317$ Capital Expenditures Coit Road (First - Frontier)1,289,900$ -$ 367,540$ 367,540$ 48,763$ 312,776$ 6,000$ 925,776$ 2,585$ Impact Fee Study 47,187$ 50,000$ (2,813)$ 47,187$ -$ -$ 47,187$ 47,187$ Impact Fee Study 52,813 - 44,167 44,167 10,200 33,967 - 8,646 - Total Projects 1,389,900$ 50,000$ 408,893$ 458,893$ 58,964$ 346,743$ 53,187$ 934,422$ 49,772$ Transfer to Capital Project Fund - - - - - - - Total Transfers Out -$ -$ -$ -$ -$ -$ -$ -$ -$ Total Expenditures 1,814,900$ 475,000$ 408,893$ 883,893$ 318,647$ 346,743$ 218,503$ 934,422$ 215,088$ REVENUE OVER (UNDER) EXPENDITURES 416,107$ 785,181$ Beginning Fund Balance October 1 2,551,734 2,551,734 Ending Fund Balance Current Month 2,967,841$ 3,336,915$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 EAST THOROUGHFARE IMPACT FEES FUND 15 Page 32 Item 7. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Amendment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES West Thoroughfare Impact Fees 4,000,000$ -$ 4,000,000$ 4,990,958$ West Thoroughfare Other Revenue - - - - Interest-West Thoroughfare Impact Fees 150,000 - 150,000 342,988 *Transfers In - - - 167,514 Total Revenues 4,150,000$ -$ 4,150,000$ 5,501,459$ EXPENDITURES Developer Reimbursements Parks at Legacy Developer Reimb 450,000$ 450,000$ -$ 450,000$ 308,063$ 141,937$ 141,937$ Star Trail Developer Reimb 1,500,000 1,500,000 - 1,500,000 - 1,500,000 1,500,000 Tellus Windsong Developer Reimb 571,668 571,668 - 571,668 - 571,668 571,668 Legacy Garden Developer Reimb 103,492 103,492 - 103,492 - 103,492 103,492 Westside Developer Reimb - - - - 69,468 (69,468) (69,468) Total Developer Reimbursements 2,625,160$ 2,625,160$ -$ 2,625,160$ 377,531$ -$ 2,247,629$ -$ 2,247,629$ Capital Expenditures Impact Fee Study 47,187$ 50,000$ (2,813)$ 47,187$ -$ -$ 47,187$ 47,187$ Impact Fee Study 52,813 - 44,167 44,167 10,200 33,967 - 8,646 - Fishtrap (Elem-DNT)300,000 300,000 - 300,000 - - 300,000 300,000 Teel - 380 Intersect - 300,000 (300,000) - - - - - Total Projects 400,000$ 650,000$ (258,646)$ 391,354$ 10,200$ 33,967$ 347,187$ 8,646$ 347,187$ Transfer to Capital Project Fund 300,000 - 300,000 300,000 300,000 - - Total Transfers Out 300,000$ -$ 300,000$ 300,000$ 300,000$ -$ -$ -$ -$ Total Expenditures 3,325,160$ 3,275,160$ 41,354$ 3,316,514$ 687,731$ 33,967$ 2,594,816$ 8,646$ 2,594,816$ REVENUE OVER (UNDER) EXPENDITURES 833,486$ 4,813,728$ Beginning Fund Balance October 1 4,678,905 4,678,905 Ending Fund Balance Current Month 5,512,391$ 9,492,633$ Notes *$167,514 Windsong Escrow From Special Revenue Fund for Developer Reimbursement. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 WEST THOROUGHFARE IMPACT FEES FUND 16 Page 33 Item 7. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Amendment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Impact Fees Water 3,250,000$ -$ 3,250,000$ 3,216,857$ Interest Income 200,000 - 200,000 357,807 Total Revenues 3,450,000$ -$ 3,450,000$ 3,574,664$ EXPENDITURES Developer Reimbursements Cambridge Park Estates -$ -$ -$ -$ -$ -$ -$ Parks at Legacy Developer Reimb 319,981 319,981 - 319,981 - 319,981 319,981 Star Trail Developer Reimb 412,192 412,192 - 412,192 - 412,192 412,192 Victory at Frontier Developer Reimb 128,471 128,471 - 128,471 15,282 113,189 113,189 Westside Developer Reimb 300,000 300,000 - 300,000 - 300,000 300,000 TVG Windsong Developer Reimb 1,020,000 1,020,000 - 1,020,000 - 1,020,000 1,020,000 Total Developer Reimbursements 2,180,644$ 2,180,644$ -$ 2,180,644$ 15,282$ -$ 2,165,362$ -$ 2,165,362$ Capital Expenditures 12" Water Line - DNT 200,000$ 24,250$ 58,393$ 82,643$ 27,286$ 7,903$ 47,454$ 133,107$ 31,704$ Lower Pressure Plane - 3,100,000 (3,100,000) - - - - - Lower Pressure Plane Easements 1,500,000 - - - - - - 95 1,499,905 Impact Fee Study 94,373 100,000 (5,627) 94,373 - - 94,373 94,373 Impact Fee Study 105,627 - 63,866 63,866 52,190 11,676 - 41,761 - Total Projects 1,900,000$ 3,224,250$ (2,983,367)$ 240,883$ 79,476$ 19,579$ 141,828$ 174,962$ 1,625,982$ Transfer to CIP Fund 3,100,000 - 3,100,000 3,100,000 3,100,000 - - - - Total Transfers Out 3,100,000$ -$ 3,100,000$ 3,100,000$ 3,100,000$ -$ -$ -$ -$ Total Expenditures 7,180,644$ 5,404,894$ 116,633$ 5,521,527$ 3,194,758$ 19,579$ 2,307,190$ 174,962$ 3,791,344$ REVENUE OVER (UNDER) EXPENDITURES (2,071,527)$ 379,906$ Beginning Fund Balance October 1 7,133,053 7,133,053 Ending Fund Balance Current Month 5,061,527$ 7,512,960$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 WATER IMPACT FEES FUND 17 Page 34 Item 7. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Amendment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Impact Fees Wastewater 2,000,000$ -$ 2,000,000$ 1,557,374$ Interest Income 100,000 - 100,000 175,406 *Upper Trinity Equity Fee 300,000 - 300,000 266,500 Total Revenues 2,400,000$ -$ 2,400,000$ 1,999,280$ EXPENDITURES Developer Reimbursements TVG Westside Utility Developer Reimb 222,502$ 222,502$ -$ 222,502$ -$ 222,502$ 222,502$ Prosper Partners Utility Developer Reimb 100,000 100,000 - 100,000 - 100,000 100,000 Frontier Estates Developer Reimb - - - - 21,774 (21,774) (21,774) LaCima Developer Reimb 150,000 150,000 - 150,000 9,030 140,970 140,970 Brookhollow Developer Reimb 152,146 152,146 - 152,146 262,446 (110,300) (110,300) TVG Windsong Developer Reimb 650,000 650,000 - 650,000 - 650,000 650,000 All Storage Developer Reimb 168,732 168,732 - 168,732 - 168,732 168,732 Legacy Garden Developer Reimb 86,711 86,711 - 86,711 33,805 52,906 52,906 Total Developer Reimbursements 1,530,091$ 1,530,091$ -$ 1,530,091$ 327,055$ -$ 1,203,036$ -$ 1,203,036$ Capital Expenditures Doe Branch Wastewater Lines 975,000$ 112,000$ 685,806$ 797,806$ 162,519$ 410,545$ 224,742$ 275,380$ 126,556$ Impact Fee Study 84,053 100,000 (15,947) 84,053 - - 84,053 84,053 Impact Fee Study 115,947 - 74,186 74,186 62,510 11,676 - 41,761 - Total Projects 1,175,000$ 212,000$ 744,045$ 956,045$ 225,029$ 422,221$ 308,795$ 317,141$ 210,609$ Transfer to CIP Fund - - - - - - - - Total Transfers Out -$ -$ -$ -$ -$ -$ -$ -$ -$ Total Expenditures 2,705,091$ 1,742,091$ 744,045$ 2,486,136$ 552,084$ 422,221$ 1,511,832$ 317,141$ 1,413,646$ REVENUE OVER (UNDER) EXPENDITURES (86,136)$ 1,447,196$ Beginning Fund Balance October 1 2,643,495 2,643,495 Ending Fund Balance Current Month 2,557,359$ 4,090,692$ Notes *Research determined that these should not be classified Impact Fees and will be reported in the W/S fund prospectively. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 WASTEWATER IMPACT FEES FUND 18 Page 35 Item 7. WATER WASTEWATER EAST THOROUGHFARE WEST THOROUGHFARE ANNUAL BUDGET $3,250,000 $2,000,000 $1,200,000 4,000,000 YTD ACTUAL $3,216,857 $1,557,374 $956,736 $4,990,958 % OF BUDGET 99%78%80%125% 99% 78% 80% 125% $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 IMPACT FEE REVENUE YTD Actual to Annual Budget 19 Page 36 Item 7. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Amendment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Grant Revenue -$ -$ -$ -$ -$ -$ 0%-$ 0% Other Reimbursements 150,000 - 150,000 - - 150,000 0%- 0% Interest Income 250,000 - 250,000 268,617 - (18,617) 107%169,071 59% Charges for Services 1,478,966 - 1,478,966 1,355,719 - 123,247 92%1,269,819 7% Total Revenue 1,878,966$ -$ 1,878,966$ 1,624,336$ -$ 254,630$ 86%1,438,890$ 13% EXPENDITURES Vehicle Replacement 772,500$ 248,374$ 1,020,874$ 369,849$ 598,411$ 52,614$ 95%1 137,570$ 169% Equipment Replacement 203,870 241,152 445,022 267,728 185,816 (8,522) 102%1 30,243 785% Technology Replacement 145,200 - 145,200 53,925 - 91,275 37%104,308 -48% Total Expenditures 1,121,570$ 489,525$ 1,611,095$ 691,501$ 784,227$ 135,367$ 92%272,121$ 154% REVENUE OVER (UNDER) EXPENDITURES 757,396$ (489,525)$ 267,871$ 932,835$ 1,166,769$ Beginning Fund Balance October 1 5,334,214 5,334,214 3,957,862 Ending Fund Balance Current Month 5,602,085$ 6,267,049$ 5,124,631$ Notes 1 Purchase orders for vehicle and equipment replacements are issued early in the year and reflect the entire year's expeditures. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 Expected Year to Date Percent 91.67% VEHICLE AND EQUIPMENT REPLACEMENT FUND 20 Page 37 Item 7. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Amendment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Health Charges 4,871,808$ -$ 4,871,808$ 4,116,353$ -$ 755,455$ 84%1 3,532,338$ 17% Health Rebates 250,000 - 250,000 162,591 - 87,409 65%2 151,577 7% Interest Income 5,000 - 5,000 32,720 - (27,720) 654%23,726 38% Total Revenue 5,126,808$ -$ 5,126,808$ 4,311,664$ -$ 815,144$ 84%3,707,641$ 16% EXPENDITURES Contractual Services 149,500$ -$ 149,500$ 120,737$ -$ 28,763$ 81%210,523$ -43% Employee Health Insurance 4,969,439 - 4,969,439 4,224,694 - 744,745 85%3,731,574 13% Total Expenditures 5,118,939$ -$ 5,118,939$ 4,345,430$ -$ 773,509$ 85%3,942,097$ 10% REVENUE OVER (UNDER) EXPENDITURES 7,869$ -$ 7,869$ (33,766)$ (234,456)$ Beginning Fund Balance October 1 389,018 389,018 552,615 Ending Fund Balance Current Month 396,887$ 355,252$ 318,159$ Notes 1 Health Charges are budgeted assuming full employment. 2 Health rebates occur at the end of the fiscal year. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 Expected Year to Date Percent 91.67% HEALTH INSURANCE FUND 21 Page 38 Item 7. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Amendment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Water Charges for Services 23,114,755$ -$ 23,114,755$ 17,886,393$ -$ 5,228,362$ 77%6, 9 16,936,552$ 6% Sewer Charges for Services 11,892,552 - 11,892,552 10,342,903 - 1,549,649 87%6 9,421,971 10% Licenses, Fees & Permits 377,705 - 377,705 420,774 - (43,069) 111%391,740 7% Utility Billing Penalties 186,900 - 186,900 209,376 - (22,476) 112%177,307 18% Interfund Principal Revenue - 77,089 77,089 64,100 - 12,989 83%7 - 0% Interest Income 350,000 - 350,000 464,798 - (114,798) 133%418,090 11% Other 3,494,342 (77,089) 3,417,253 637,850 - 2,779,403 19%2 570,173 12% Transfer In - - - - - - 0 - 0% Total Revenues 39,416,254$ -$ 39,416,254$ 30,026,195$ -$ 9,390,059$ 76%27,915,832$ 8% EXPENDITURES Administration 1,138,944$ -$ 1,138,944$ 977,752$ 12,256$ 148,936$ 87%933,068$ 5% Debt Service 4,609,584 - 4,609,584 4,867,843 - (258,259) 106%1 4,285,203 14% Water Purchases 12,704,415 - 12,704,415 10,500,686 - 2,203,729 83%8,844,847 19% Sewer Management Fee 4,560,895 - 4,560,895 4,639,735 - (78,840) 102%5 3,878,571 20% Franchise Fee 689,851 - 689,851 632,363 - 57,488 92%485,400 30% Public Works 8,226,657 13,800 8,240,457 6,735,229 740,804 764,424 91%6,059,878 11% Transfer Out 9,255,356 4,056 9,259,412 5,560,065 - 3,699,347 60%3 1,269,933 338% Total Expenses 41,185,702$ 17,856$ 41,203,558$ 33,913,673$ 753,060$ 6,558,178$ 84%25,756,901$ 32% REVENUE OVER (UNDER) EXPENDITURES (1,769,448)$ (17,856)$ (1,787,304)$ (3,887,478)$ 8 2,158,931$ Beginning Working Capital October 1 17,832,990 17,832,990 12,669,408 Ending Working Capital 16,045,686$ 13,945,512$ 14,828,339$ Notes 1 Annual debt service payments are made in February and August. 2 Other Revenue includes $3.0M budgeted for TxDOT reimbursement. 3 Transfers out consist of $2.0M - solid waste loan, $2.0M - DNT water line relocation, $400K - Wilson Creek, $75K - sewer replacement, and $1,085,065 - General Fund admin costs. 4 Minimum Ending Working Capital balance for FY23 = $8,278,513 (25%). 5 Sewer Management Fees are billed one month ahead of services. 6 Budget includes rate increase not imposed in the current year. 7 Loan payments started in May, will not follow expected percentage for first year. 8 The projected draw down on fund balance at year end is expected to be in line with the budgeted draw down on fund balance. 9 Water revenue for the year estimated to be $1.6M under budgeted amount. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 Expected Year to Date Percent 91.67% WATER-SEWER FUND 22 Page 39 Item 7. Aug-24 Aug-23 Growth % WATER SEWER WATER SEWER Change Four Year Cumulative # of Accts Residential 13,479 12,778 12,596 11,890 7.23%FY2024 FY2023 Average Average # of Accts Commercial 456 411 448 404 1.76%October 19,061 20,110 17,424 17,424 Consumption-Residential 298,770,510 92,154,010 291,250,220 81,541,620 4.86%November 10,540 11,190 11,104 28,528 Consumption-Commercial 42,509,420 16,816,960 37,766,060 18,727,450 5.01%December 8,003 6,273 7,256 35,784 Consumption-Commercial Irrigation 60,259,110 54,450,820 10.67%January 7,400 8,049 6,727 42,511 Avg Total Res Water Consumption 22,120 23,095 -4.22%February 6,200 23,095 6,381 48,891 Billed ($) Residential 2,032,403$ 812,276$ 2,001,277$ 735,341$ 3.95%March 7,600 5,839 6,436 55,327 Billed ($) Commercial 396,904 153,601 347,338 146,655 11.44%April 8,900 10,053 9,333 64,660 Billed ($) Commercial Irrigation 558,120 - 503,681 - 10.81%May 9,510 14,092 12,345 77,005 Total Billed ($)2,987,427$ 965,877$ 2,852,296$ 881,997$ 5.86%June 10,310 14,281 13,323 90,328 July 22,740 16,992 17,885 108,212 August 22,120 23,095 23,040 131,252 September 26,836 19,429 150,681 TOTAL (gal)132,384 162,724 150,681 Avg. Temp (°F)# Rain Days FY2024 FY2024 FY2024 FY2023 Average Cumulative October 68°8 11.30 5.65 8.48 8.48 November 58°2 0.57 5.82 3.20 11.67 December 53°5 4.09 3.43 3.76 15.43 January 43°10 3.86 1.29 2.58 18.01 February 58°5 1.56 4.51 3.04 21.04 March 61°12 6.57 2.69 4.63 25.67 April 69°9 9.07 1.20 5.14 30.81 May 77°11 9.71 3.62 6.67 37.47 June 84°5 4.35 2.35 3.35 40.82 July 85°8 1.84 0.47 1.16 41.98 August 89°2 0.96 0.07 0.52 42.49 September 1.18 1.18 43.67 Annual 77.00 53.88 32.28 43.67 Weather Data:https://www.wunderground.com/history/monthly/KDAL/date/2023-10 Average Total Residential Water Consumption by Month RainfallMonth TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 Expected Year to Date Percent 91.67% WATER-SEWER FUND 23 Page 40 Item 7. 77% 87% 111% 112% 133% Water Charges for Services Sewer Charges for Services Licenses, Fees & Permits Utility Billing Penalties Interest Income 0%20%40%60%80%100%120%140% WATER/SEWER REVENUE YTD % OF ANNUAL BUDGET 24 Page 41 Item 7. $17,886,393 10,500,686 $16,936,552 8,844,847 $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000 $20,000,000 Water Charges for Services Water Purchases WATER REVENUE AND EXPENSE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 25 Page 42 Item 7. 10,342,903 4,639,735 9,421,971 3,878,571 - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 Sewer Charges for Services Sewer Management Fee SEWER REVENUE AND EXPENSE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 26 Page 43 Item 7. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Amendment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES 45-4 Storm Drainage Utility Fee 825,000$ -$ 825,000$ 855,986$ -$ (30,986)$ 104%790,632$ 8% Drainage Review Fee - - - 3,150 - (3,150) 0%- 0% 45-4 Interest Income 1,800 - 1,800 11,936 - (10,136) 663%(3,465) -444% Other Revenue 3,000 - 3,000 - - 3,000 0%2,096 -100% Transfer In - - - - - - 0%- 0% Total Revenue 829,800$ -$ 829,800$ 871,072$ -$ (41,272)$ 105%789,264$ 10% EXPENDITURES Personnel Services 329,605$ -$ 329,605$ 288,401$ -$ 41,204$ 87%152,319$ 89% Debt Service 219,463 - 219,463 219,463 - 1 100%2 217,745 1% 45-7 Operating Expenditures 114,981 (2,028) 112,953 37,365 - 75,588 33%77,726 -52% Capital Expenditures 263,240 (225,000) 38,240 - 39,951 (1,711) 104%3 62,230 -100% Transfers Out 107,996 227,028 335,024 328,945 - 6,079 98%1 98,996 232% Total Expenses 1,035,285$ -$ 1,035,285$ 874,174$ 39,951$ 121,160$ 88%609,016$ 44% REVENUE OVER (UNDER) EXPENDITURES (205,485)$ -$ (205,485)$ (3,102)$ 180,248$ Beginning Working Capital October 1 380,410 380,410 632,579 Ending Working Capital Current Month 174,925$ 377,308$ 812,827$ Notes 1 Capital project funds are transferred as needed; General fund transfers are made monthly. 2 Annual debt service payments are made in February and August. 3 Encumbrance for vehicle, a one-time purchase, does not follow expected percentage. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 Expected Year to Date Percent 91.67% STORM DRAINAGE UTILITY FUND 27 Page 44 Item 7. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Amendment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Sanitation Charges for Services 2,979,722$ -$ 2,979,722$ 2,691,537$ -$ 288,185$ 90%2 2,264,050$ 19% Interest Income - - - 6,231 - (6,231) 0%2,799 123% Transfer In 2,050,000 - 2,050,000 2,000,000 - 50,000 98%- 0% Total Revenues 5,029,722$ -$ 5,029,722$ 4,697,768$ -$ 331,954$ 93%2,266,849$ 107% EXPENDITURES Administration 2,325,554$ (2,092,500)$ 233,054$ 56,609$ -$ 176,445$ 24%49,849$ 14% Sanitation Collection 2,668,887 - 2,668,887 2,257,283 - 411,604 85%2,040,415 11% Capital Expenditure - 1,955,000 1,955,000 1,933,413 17,067 4,520 100%1 - 0% Debt Service - 137,500 137,500 116,042 - 21,458 84%- 0% Transfer Out - - - - - - 0%- 0% Total Expenses 4,994,441$ -$ 4,994,441$ 4,363,347$ 17,067$ 614,027$ 88%2,090,263$ 109% REVENUE OVER (UNDER) EXPENDITURES 35,281$ -$ 35,281$ 334,421$ 176,586$ Beginning Working Capital October 1 6,018 6,018 Ending Working Capital 41,299$ 340,439$ Notes 1 Capital, one-time purchases, do not follow expected percentage. 2 Correction of General Fund franchise fee calculation for residential carts. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 Expected Year to Date Percent 91.67% SOLID WASTE FUND 28 Page 45 Item 7. $2,691,537 2,257,283 $2,264,050 2,040,415 $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 Sanitation Charges for Services Sanitation Collection SOLID WASTE REVENUE AND EXPENSE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 29 Page 46 Item 7. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Amendment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Grants 1,877,105$ -$ 1,877,105$ 250,681$ Property Taxes-Delinquent - - - - Property Taxes-Current 8,502,003 - 8,502,003 8,502,003 Taxes-Penalties - - - - Contributions/Interlocal Revenue - - - 2,932,712 Bond Proceeds - - - - Interest Income - - - 3,910,287 Other Revenue - - - 7,872 Transfers In - General Fund - 446,389 446,389 446,389 Transfers In - Impact Fee Funds - 300,000 300,000 300,000 Transfers In - Escrows - - - - Transfers In - Parks - 800,000 800,000 2,313,800 *Transfers In/Out - Bond Funds - - - - Total Revenues 10,379,108$ 1,546,389$ 11,925,497$ 18,663,743$ EXPENDITURES West Prosper Roads 14,017,321$ -$ -$ -$ -$ -$ -$ 14,017,321$ -$ Fishtrap (seg 2) PISD Reimbursement 940,631 - - - - - - 940,631 - DNT Main Lane (US 380 - FM 428)2,557,062 - 2,557,062 2,557,062 2,557,062 - 0 - 0 Coit Rd (First-Frontier) 4 Lns 6,500,000 - 6,499,199 6,499,199 1,738,931 - 4,760,268 801 4,760,268 First St (DNT to Coleman)24,786,567 - 22,644,181 22,644,181 663,715 156,754 21,823,711 2,142,387 21,823,711 Prosper Trl(Coit-Custer)5,769,088 - - - 4,088 - (4,088) 5,769,088 (4,088) First Street (Elem-DNT) 4 Lanes 30,895,929 - 23,477,314 23,477,314 12,240,019 10,518,025 719,270 7,418,615 719,270 Preston Road / First Street Dual Left Turns (Design & Construction)900,000 - 900,000 900,000 71,523 22,077 806,400 - 806,400 First St (Coit-Custer) 4 Lanes 26,769,101 - 8,305,215 8,305,215 7,160,565 230,767 913,884 18,463,886 913,884 Preston/Prosper Trail Turn Lane 900,000 - 749,462 749,462 335,855 12,437 401,170 150,538 401,170 Craig Street (Preston-Fifth)450,000 - 123,480 123,480 54,533 40,588 28,360 326,520 28,360 First Street (Teel - Gee Road)7,225,444 - 2,435,465 2,435,465 2,206,146 - 229,319 4,789,978 229,319 Gee Road (First Street - Windsong)4,041,041 - 1,024,673 1,024,673 506,598 43,416 474,660 3,016,368 474,660 Coleman (Gorgeous - Prosper Trail)1,500,000 - 945,443 945,443 167,579 438,005 339,859 554,557 339,859 Coleman (Prosper Trail - PHS)720,000 - 720,000 720,000 - - 720,000 - 720,000 Legacy (Prairie - First Street)10,625,000 - 9,906,174 9,906,174 5,388,427 4,111,392 406,354 718,827 406,354 Coit/US 380 SB Turn Lanes 300,000 - 276,014 276,014 245,727 26,858 3,429 23,986 3,429 Parvin (FM 1385 - Legacy)500,000 - - - - - - 500,000 - US 380 Deceleration Lanes - Denton County 500,000 - 500,000 500,000 43,600 35,550 420,850 - 420,850 Safety Way 800,000 - 800,000 800,000 - - 800,000 - 800,000 Gorgeous/McKinley 700,000 - 700,000 700,000 - - 700,000 - 700,000 Renaming of Fishtrap Road to W. First Street 80,000 - 77,123 77,123 - - 77,123 2,877 77,123 Gee Road (US 380--FM 1385)2,200,000 - 2,038,300 2,038,300 773,883 719,417 545,000 161,700 545,000 Frontier (Legacy-DNT)300,000 - - - - - - 300,000 - First Street (Coleman)500,000 - 499,791 499,791 417,330 79,219 3,242 209 3,242 Star Trail, Phase 5: Street Repairs 1,450,000 - 1,450,000 1,450,000 - 300,000 1,150,000 - 1,150,000 Prosper Trail (Coit - Custer) - 2 WB lanes 900,000 - 900,000 900,000 - - 900,000 - 900,000 Windsong Pkwy/380 Dual L Turns 152,800 - 152,800 152,800 12,400 10,400 130,000 - 130,000 Teel Parkway (US 380 - First Street Rd) NB 2 Lanes (Design)5,850,000 - 5,637,136 5,637,136 3,670,770 1,947,062 19,304 212,864 19,304 Traffic Improvement Projects - - - - - - - - - Parking Lot & Alley Improvements 122,500 - 122,500 122,500 59,950 62,550 - - - Coleman St (First-Go 660,000 - 660,000 660,000 - 660,000 - - - US380 Median Lighting 465,912 - - - - - - 465,912 - Fifth Street Quiet Zone 500,000 - 500,000 500,000 - - 500,000 - 500,000 Traffic Signal - Fishtrap & Artesia Boulevard 65,000 - 65,000 65,000 16,400 43,850 4,750 - 4,750 Med Lighting 380-Mah 300,000 - 300,000 300,000 - - 300,000 - 300,000 Traffic Signal - DNT/Frontier 281,500 - 281,500 281,500 16,125 66,875 198,500 - 198,500 Traffic Signal - Teel Pkway & Prairie Drive 65,000 - 65,000 65,000 13,600 27,150 24,250 - 24,250 Pedestrian Hybrid Beacons 777,600 - 777,600 777,600 26,250 61,350 690,000 - 690,000 Crswalk Sign Markings Flashers - - - - - - - - - Traffic Signal First 578,333 - 578,333 578,333 7,333 106,000 465,000 - 465,000 Traffic Warrant Stud 14,667 - 14,667 14,667 5,417 9,250 - - - Acaci Traffic Signal 503,480 - 503,480 503,480 34,330 134,598 334,552 - 334,552 DNT Signal Conduit Relocations 173,449 - 173,449 173,449 3,602 169,847 - - - Opticom Repair/Installation 85,000 - 85,000 85,000 - 82,557 2,443 - 2,443 Opticom Repair/Installation 800,000 - 800,000 800,000 - - 800,000 - 800,000 Tr. Signal (Denton-Fishtrap)349,500 - 349,500 349,500 - 49,500 300,000 - 300,000 Capital Expenditures 4,176,553 (4,176,553) - - - - - Total Street Projects 158,571,925$ 4,176,553$ 94,418,309$ 98,594,862$ 38,441,756$ 20,165,495$ 39,987,611$ 59,977,063$ 39,987,611$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 CAPITAL PROJECTS FUND - GENERAL 30 Page 47 Item 7. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Amendment Budget Actual Encumbrances Budget Balance Expenditure Balance TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 CAPITAL PROJECTS FUND - GENERAL Turf Irrigation SH289 48,935$ -$ -$ -$ -$ -$ -$ 48,935$ -$ Lakewood Preserve, Phase 2 5,102,255 - 5,102,255 5,102,255 4,132,408 247,877 721,970 - 721,970 Doe Branch Property Trail Connections 1,684,000 - 1,684,000 1,684,000 17,138 210,163 1,456,700 - 1,456,700 Downtown Pond Improvements 11,760 - - - - - - 11,760 - Raymond Community Park 19,800,000 - 18,991,658 18,991,658 2,854,132 15,883,437 254,089 808,342 254,089 Green Ribbon Lovers 2,295,000 - 2,295,000 2,295,000 - - 2,295,000 - 2,295,000 Windsong Park #3 750,000 - 750,000 750,000 - - 750,000 - 750,000 Downtown Park 408,240 - 408,240 408,240 - 105,700 302,540 - 302,540 Windsong Parkland Dedication 1,913,800 - 1,913,800 1,913,800 1,913,800 - - - - Froniter Park Pond Repairs 473,000 - 473,000 473,000 - 453,891 19,109 - 19,109 Various Hike and Bike Trails 580,680 - 580,680 580,680 - - 580,680 - 580,680 Prosper Trail Screening (Preston - Deer Run)750,000 - 750,000 750,000 40,850 116,150 593,000 - 593,000 Parks Master Plan Up 140,000 - 140,000 140,000 83,237 49,470 7,293 - 7,293 Downtown Monumentation 66,500 - 66,500 66,500 41,343 25,157 - - - Downtown Improvements 553,389 - 553,389 553,389 305 - 553,084 - 553,084 Total Park Projects 34,577,558$ -$ 33,708,521$ 33,708,521$ 9,083,212$ 17,091,844$ 7,533,464$ 869,037$ 7,533,464$ PD Car Camera and Body worn Camera System 387,225$ -$ 370,325$ 370,325$ -$ -$ 370,325$ 16,900$ 370,325$ Station #3 Quint Engine 1,495,000 - 25,120 25,120 19,736 4,794 589 1,469,880 589 Station #3 Ambulance 495,000 - 40,109 40,109 5,215 2,397 32,497 454,891 32,497 Parks & Public Works, Phase 1 3,450,000 - 3,450,000 3,450,000 25,790 1,161,296 2,262,913 - 2,262,913 Public Safety Complex, Phase 2-Design 1,562,823 - - - - - - 1,562,823 - Public Safety Complex, Phase 2-Dev Costs 124,691 - 975 975 975 - - 123,716 - Public Safety Complex, Phase 2-Construction 14,499,866 - - - - - - 14,499,866 - Public Safety Complex, Phase 2-FFE 1,108,321 - 8,375 8,375 8,375 - - 1,099,946 0 Fire Station #4 - Design 965,855 - 492,868 492,868 114,933 428,588 (50,652) 472,987 (50,652) Fire Station #4 - Engine 1,250,000 - 27,213 27,213 19,657 4,794 2,762 1,222,787 2,762 Fire Station #4 - Ambulance 552,000 - 427,568 427,568 9,529 378,789 39,249 124,432 39,249 Fire Station #4 - Other Costs 8,250 - - - - - - 8,250 - Fire Station #4 Construction 10,200,000 - 10,200,000 10,200,000 - - 10,200,000 - 10,200,000 Parks and Public Works Parking Lot - - - - - - - - - Interim Community Center - - - - - - - - - Finish Out Interior Spaces Town Hall First and Second Floor 650,000 - 650,000 650,000 188,602 229,092 232,306 - 232,306 Library Master Plan 130,000 - 130,000 130,000 48,555 51,563 29,882 - 29,882 Emergency Warning Sirens 296,887 - 296,887 296,887 296,380 - 506 - - PD Station Improvements 358,592 - 358,592 358,592 23,253 335,339 - - - Total Facility Projects 37,534,510$ -$ 16,478,032$ 16,478,032$ 761,000$ 2,596,653$ 13,120,378$ 21,056,478$ 13,119,872$ Transfer Out - - - - - - - - - Total Expenditures 230,683,993$ 4,176,553$ 144,604,861$ 148,781,414$ 48,285,969$ 39,853,992$ 60,641,453$ 81,902,579$ 60,640,947$ REVENUE OVER (UNDER) EXPENDITURES (136,855,918)$ (29,622,226)$ Beginning Fund Balance (Restricted for Capital Projects) October 1 77,609,702 77,609,702 Ending Fund Balance (Restricted for Capital Projects) Current Month (59,246,216)$ 47,987,476$ *Transfers In/Out - Bonds--Bond and CIP funds are both in the Capital Projects Fund so transfers between these funds are netted together and eliminated. 31 Page 48 Item 7. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Year Budget Budget Budget Amendment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Interest Income -$ -$ -$ 1,579,120$ Bond Proceeds - - - - Grants - 6,102,367 6,102,367 8,888,286 Transfers In - 471,613 471,613 2,700,000 Transfers In - ARPA Funds 6,348,980 (6,348,980) - - Transfers In - Impact Fee Funds - - - 3,100,000 Transfers In - Bond Funds - - - - Total Revenues 6,348,980$ 225,000$ 6,573,980$ 16,267,406$ EXPENDITURES Lower Pressure Plane Pump Station Design 18,931,100$ -$ 8,267,140$ 8,267,140$ 5,445,419$ 2,327,959$ 493,761$ 10,663,960$ 493,761$ LPP Water Line Phase, 2A 8,999,905 - 8,999,905 8,999,905 757,021 7,204,151 1,038,733 - 1,038,733 Broadway (Parvin-Craig)- - - - - - - - - Fishtrap (Elem-DNT) (Legacy Water Line)15,000 - - - - - - 15,000 - Doe Branch Parallel Interceptor 7,400,000 - 7,400,000 7,400,000 - - 7,400,000 - 7,400,000 Doe Branch, Phase 3 WWTP 55,000,000 6,348,980 48,651,020 55,000,000 6,102,367 - 48,897,633 - 48,897,633 Sanitary Sewer Replacement 75,000 - 75,000 75,000 42,136 - 32,864 - 32,864 Wilson Creek WW Line 400,000 - 400,000 400,000 8,525 - 391,475 - 391,475 Parks & Public Works, Phase 1 600,000 - 600,000 600,000 36,860 556,474 6,667 - 6,667 DNT (Prosper Trail - Frontier Parkway) 12-inch WL 3,500,000 - 3,500,000 3,500,000 1,202,287 23,785 2,273,928 - 2,273,928 Upper Doe Branch WW Line (Teel-PISD Stadium)4,050,000 - 4,050,000 4,050,000 - - 4,050,000 - 4,050,000 DNT Water Line Relocation (US 380 - First St)2,146,650 - 2,127,151 2,127,151 1,331,336 109,598 686,218 19,499 686,218 Master Plan Projects - - - - - - - - - 5 MG Ground Storage 5,539,007 - 5,539,007 5,539,007 - 599,500 4,939,507 - 4,939,507 Water Line Relocation Frontier 3,400,000 - 3,137,000 3,137,000 136,803 250,782 2,749,414 263,000 2,749,414 Total Water & Wastewater Projects 110,056,662$ 6,348,980$ 92,746,222$ 99,095,202$ 15,062,754$ 11,072,249$ 72,960,200$ 10,961,460$ 72,960,200$ Old Town Regional Pond #2 48,386$ -$ 17,177$ 17,177$ 16,883$ 231$ 63$ 31,210$ 63$ BNSF Drainage Reimbursement 500,000 - 500,000 500,000 500,000 - - - - Doe Branch Creek Erosion Control 225,000 - 225,000 225,000 - 198,032 26,968 - 26,968 Total Drainage Projects 773,386$ -$ 742,177$ 742,177$ 516,883$ 198,263$ 27,031$ 31,210$ 27,031$ Transfer out - - - - - - - - Total Expenses 110,830,048$ 6,348,980$ 93,488,399$ 99,837,379$ 15,579,636$ 11,270,512$ 72,987,231$ 10,992,669$ 72,987,231$ REVENUE OVER (UNDER) EXPENDITURES (93,263,399)$ 687,769$ Beginning Fund Balance (Restricted for Capital Projects) October 1 40,601,835 40,601,835 Ending Fund Balance (Restricted for Capital Projects) Current Month (52,661,564)$ 41,289,604$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT August 31, 2024 CAPITAL PROJECTS FUND-WATER/SEWER 32 Page 49 Item 7. Page 1 of 2 To: Mayor and Town Council From: Doug Kowalski, Chief of Police Through: Mario Canizares, Town Manager Re: Flock, Inc. Expansion Town Council Meeting – September 24, 2024 Strategic Visioning Priority: 4. Provide Excellent Municipal Services Agenda Item: Consider and act upon authorizing the Town Manager to execute an agreement with Flock Inc. for the lease of additional equipment, cameras, software, and services for $153,184. Description of Agenda Item: At the April 20 and June 11, 2024, Town Council Meetings, the Council approved the application submittals to the Motor Vehicle Crime Prevention Authority (MVCPA) for the FY24 and FY25 SB224 Catalytic Converter Grant programs. On July 16, 2024, the MVCPA awarded the Town of Prosper a total of $169,766 in awards related to the FY24 and FY25 SB224 Catalytic Converter Grant program, and both awards were accepted on August 13, 2024. In conjunction with the MVCPA grant application and Town Council approval of the FY25 Proposed budget on September 10, 2024, staff is seeking authorization to initiate a 60-day trial period for the lease of:  Town-owned camera integrations to Flock Real-Time Crime Center platform: $3,284  (2) Camera Trailer: $41,000  (16) Additional ALPRs: $48,000 recurring + $10,400 implementation: $58,400  Flock911: $20,000  Traffic Safety Analytics for additional ALPR cameras: $8,000  (6) Flock Condors PTZ: $18,000 recurring + $4,500: $22,500 Initiating the trial at this time will allow staff to begin the necessary permitting and integration process for the leased items and will secure priority installation with the vendor. Following the 60- day opt-out period, the contract will go into effect. Budget Impact: The 60-day trial is at no cost. $153,184 is allocated in the FY25 Lease Payments account and will be supplemental equipment to the current leased items from Flock Inc. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has approved the attached documents as to form and legality. POLICE DEPARTMENT Page 50 Item 8. Page 2 of 2 Attached Documents: 1. Flock Safety Trial Order Form Town Staff Recommendation: Town Staff recommends the Town Council authorize the Town Manager to execute an agreement with Flock Inc. for the lease of additional equipment, cameras, software, and services for $153,184. Proposed Motion: I move to approve authorizing the Town Manager to execute an agreement with Flock Inc. for the lease of additional equipment, cameras, software, and services for $153,184. Page 51 Item 8. Flock Safety + TX - Prosper PD ______________ Flock Group Inc. 1170 Howell Mill Rd, Suite 210 Atlanta, GA 30318 ______________ MAIN CONTACT: James Allen james.allen@flocksafety.com (972) 561-6737 Page 52 Item 8. EXHIBIT A ORDER FORM Customer: TX - Prosper PD Initial Term: 12 Months Legal Entity Name: TX - Prosper PD Renewal Term: 24 Months Accounts Payable Email: sbrewer@prospertx.gov Payment Terms: Net 30 Address: 101 S Main St Prosper, Texas 75078 Billing Frequency: Annual Plan - Invoiced at the end of the pilot period. Retention Period: 30 Days PROJECT PROVE IT Customer will have a 60 day opt-out period (“Opt-Out Period”) after implementation of the first Flock Hardware to terminate this Agreement without penalty or fees. After the Opt-Out Period, Customer may not terminate the Agreement, and Customer will pay any invoice(s) for the remainder of the Term, Net 30. Hardware and Software Products Annual recurring amounts over subscription term Item Cost Quantity Total Flock Safety Platform $138,284.00 Flock Safety Flock OS FlockOS ™ 911 Included 1 Included Flock Safety LPR Products Flock Safety Falcon ® Included 16 Included Flock Safety Video Products Flock Safety Condor ™ PTZ w/ LTE Service Included 6 Included Flock Safety Wing ™ Livestream Included 2 Included Flock Safety Wing ™ VMS Included 116 Included Flock Safety Platform Add Ons Traffic Analytics Package Included 16 Included Flock Safety Professional Services Custom Recurring Subscription Included 1 Included Custom Recurring Subscription Included 1 Included Professional Services and One Time Purchases Item Cost Quantity Total One Time Fees Flock Safety Professional Services Professional Services - Standard Implementation Fee $650.00 16 $10,400.00 Condor Professional Services - Standard Implementation Fee $750.00 6 $4,500.00 Subtotal Year 1: $153,184.00 Annual Recurring Subtotal: $138,284.00 Estimated Tax: $0.00 Page 53 Item 8. Contract Total: $153,184.00 Taxes shown above are provided as an estimate. Actual taxes are the responsibility of the Customer. This Agreement will automatically renew for successive renewal terms of the greater of one year or the length set forth on the Order Form (each, a “Renewal Term”) unless either Party gives the other Party notice of non-renewal at least thirty (30) days prior to the end of the then-current term. Special Terms: • Custom Subscription: Video Trailer with 24ft w/ 1 Condor, 1-quad cam, solar, deter lighting, red signage Custom Subscription: Video Trailer with 30ft w/ 1 Condor, 1-quad cam, solar, deter lighting, red signage Page 54 Item 8. Billing Schedule Billing Schedule Amount (USD) Year 1 At PPI End Date $153,184.00 Annual Recurring after Year 1 $138,284.00 Contract Total $153,184.00 *Tax not included Page 55 Item 8. Product and Services Description Flock Safety Platform Items Product Description Terms FlockOS™ Flock Safety’s situational awareness operating system. Flock Safety Falcon ® An infrastructure-free license plate reader camera that utilizes Vehicle Fingerprint® technology to capture vehicular attributes. The Term shall commence upon first installation and validation of Flock Hardware. Flock Safety Condor™ Flock’s pan, tilt, zoom (PTZ) or fixed cameras which capture video footage with the option to stream live video, capture and view video recordings, and upload videos. The Term shall commence upon first installation and validation of Flock Hardware. Flock Safety Wing™ Livestream Real-time video integration with third-party cameras via the Flock interface. The Term shall commence upon execution of this Agreement and continue for one (1) year, after which, the Term may be extended by mutual consent of the Parties, unless terminated by either Party. One-Time Fees Service Description Installation on existing infrastructure One-time Professional Services engagement. Includes site & safety assessment, camera setup & testing, and shipping & handling in accordance with the Flock Safety Advanced Implementation Service Brief. Professional Services - Standard Implementation Fee One-time Professional Services engagement. Includes site and safety assessment, camera setup and testing, and shipping and handling in accordance with the Flock Safety Standard Implementation Service Brief. Professional Services - Advanced Implementation Fee One-time Professional Services engagement. Includes site & safety assessment, camera setup & testing, and shipping & handling in accordance with the Flock Safety Advanced Implementation Service Brief. FlockOS Features & Description FlockOS Features Description Page 56 Item 8. By executing this Order Form, Customer represents and warrants that it has read and agrees all of the terms and conditions contained in the Terms of Service located at https://www.flocksafety.com/terms-and-conditions/L1/ and the Prepared911 Terms and Conditions, available at https://www.prepared911.com/prepared-live-terms-and- conditions. / / The Parties have executed this Agreement as of the dates set forth below. FLOCK GROUP, INC. Customer: TX - Prosper PD By: \FSSignature2\ By: \FSSignature1\ Name: \FSFullname2\ Name: \FSFullname1\ Title: \FSTitle2\ Title: \FSTitle1\ Date: \FSDateSigned2\ Date: \FSDateSigned1\ PO Number: Page 57 Item 8. Page 1 of 2 To: Mayor and Town Council From: Chuck Ewings, Assistant Town Manager Through: Mario Canizares, Town Manager Re: Installation of Lighted Bollards and Pole Lights North of Town Hall Town Council Meeting – September 24, 2024 Strategic Visioning Priority: 2. Development of Downtown as Destination Agenda Item: Consider and act upon authorizing the Town Manager to execute a contract with Groves Electrical Service, Inc., in the amount of $98,700 for the installation of lighted bollards and pole lights between Town Hall and W. Broadway St. Description of Agenda Item: The Downtown Advisory Committee has recommended installation of decorative, lighted bollards along the walking path between Town Hall and W. Broadway St. The project also includes adding to two decorative pole lights, matching the existing streetlights, along the path between the alley north of Town Hall and W. Broadway St. The intent is to improve pedestrian lighting at night and add more decorative fixtures. Groves Electrical is a member of Buy Board and pricing has been competitively bid through the cooperative purchasing program. Budget Impact: The improvements will be charged to Account 750-6610-10-00-2420-PK. Funding in CIP budget dedicated to downtown projects the amount of $98,700 is available for this project. Legal Obligations and Review: Standard contract language will be utilized. Attached Documents: 1. Groves Electrical Quote Town Staff Recommendation: Town staff recommends that the Town Council authorize the Town Manager to execute a contract with Groves Electrical Service, Inc., in the amount of $98,700 for the installation of lighted bollards and pole lights between Town Hall and W. Broadway St. FACILITIES Page 58 Item 9. Page 2 of 2 Proposed Motion: I move to authorize the Town Manager to execute a contract with Groves Electrical Service, Inc., in the amount of $98,700 for the installation of lighted bollards and pole lights between Town Hall and W. Broadway St. Page 59 Item 9. ________________________ __________________ _________________________ AUTHORIZED SIGNATURE PO # ESTIMATOR, JIMMY CLARK FOR ACCEPTANCE, PLEASE SIGN AND RETURN ONE COPY. PAYMENTS TO BE COD OR NET 10TH PROXY MONTH WITH APPROVED CREDIT.70% ROUGH AND 30% ON COMPLETION WHEN APPLICABLE. UNLESS SPECIFICALLY NOTED TO THE CONTRARY HEREIN, COVERAGE OF THESE ITEM ARE SPECIFICALLY EXCLUDED: Tax, permit fee, rock digging or excavation; erosion control; casing of piers, repair of unmarked underground utilities, conformance with The International Electrical Energy Conversation Code (IEECC); excavations of any nature in excess of four feed deep; COMPACTION to a specified density; utility communication co. charges; wage rates; requirements of any “Building Standards”; Specifications by Owner, Architect or Engineer; work show on any drawings, addenda or specification that could be concurred to be within our trade or responsibility other than t hose listed within our Scope of Work; temporary power or lighting; temporary power usage or deposit; installation of overhead power lines for temporary; bond fees; scheduled overtime; insurance in excess that listed or Builder’s Risk; fire or smoke stoppage for devices, light fixtures, raceways or conductors. Regulated by the Texas Department of Licensing and Regulations, PO Box 12157, Austin, TX 78711, 800-803-9202, 512-463-6599: website: www.license.state.tx.us/complaints. Owner or General Contractor to provide, toilet, water, electrical power, on site trash and debris disposal location. Price is void after 30 days. Contract review fee add $2,500.00 8/22/2024 ROBERT COOK 972-569-1143 TOWN OF PROSPER 250 W. FIRST ST RCOOK@PROSPERTX.GOV PROSPER, TX. 75078 BID #24AUG02AJC BUY BOARD: 733-24 SUBJECT: INSTALL 2 POLE LIGHTS AND 10 BOLLARD LIGHTS IN THE BACK PARKING LOT AND SIDEWALK. CALL DIG TESS TO LOCATE THE EXISTING UTILITIES. IF ALL IS CLEAR WE WILL PROCEED AS FOLLOWS: THE 10 BOLLARDS WILL GO DOWN THE MIDDLE OF THE CENTER SIDEWALK AREA FROM CITY HALL TO W. BROADWAY ST. CUT A SMALL SQUARE OPENING AT EACH BOLLARD LOCATION. TAP AN EXISTING CIRCUIT IN THE GRASS AREAS TO FEED THE BOLLARDS. BORE BETWEEN THE 10 OPENINGS AND STUB UP A CONDUIT. POUR CONCRETE BACK IN THE 10 OPENINGS. ONCE THE CONCRETE IS CURED, WE WILL INSTALL THE BOLLARDS WITH ANCHORS. ALLOWANCE OF A $5.00 LED LIGHT BULB, CUSTOMER TO CHOSE. 2 POLE LIGHTS WILL BE INSTALLED ON THE EAST SIDE OF THE SIDE WALK, NEAR THE EMPTY LOTS. INSTALL PRECAST CONCRETE PIERS. TRENCH BETWEEN THE POLES. CUT THE CONCRETE FROM THE GRASS TO THE EXISTING POLE LIGHT ON BROADWAY ST. INSTALL SURFACE MOUNT RIGID CONDUIT UP THE EXISTING PIER AND STUB THE CONDUIT IN UNDER THE POLE BASE SKIRT. STAND AND TEST THE NEW POLES. PRICE: $98,700.00 EXCLUSIONS: DIGGING IN ROCK, DAMAGE TO UNKNOWN UTILITIES, REMOVING/REPLACING A SIDEWALK SQUARE, THE INTEGRITY OF THE EXISTING CIRCUITS THAT WILL BE TAPPED. GROVES ELECTRICAL SERVICE, INC. 2410 SQUIRE PLACE, FARMERS BRANCH, TEXAS 75234, 972-484-2717 FAX 972-484-2263 ELECTRICAL and MECHANICAL, CONTRACTING and SERVICE www.groveselectric.com TECL17392 “SINCE 1968” Page 60 Item 9. Page 1 of 2 To: Mayor and Town Council From: Carrie Jones, Director of Public Works Through: Mario Canizares, Town Manager Chuck Ewings, Assistant Town Manager Re: Award of Concrete Repair and Replacement Contract Town Council Meeting – September 24, 2024 Strategic Visioning Priority: 4. Provide Excellent Municipal Services Agenda Item: Consider and act upon awarding Bid No. 2024-26-A to Wopac Construction, Inc. as the primary vendor, and Cam-Crete Contracting, Inc., as the secondary vendor, at the unit prices bid, to establish an annual contract for Miscellaneous Concrete Replacement Services; and authorizing the Town Manager to execute the same. Description of Agenda Item: The Public Works Department identifies repairs to concrete streets, alleys and sidewalks on a regular basis for ongoing maintenance. To repair multiple locations in a timely manner, an annual concrete replacement contract will provide staff a vendor to perform the repairs. The Town developed specifications and solicited bids to establish an estimated amount of $600,000 in concrete repairs throughout Fiscal Year 2025. On August 29, 2024, staff opened 9 bids for Bid No. 2024-26-A, Miscellaneous Concrete Replacement Services. Based on unit prices bid, Wopac Construction is the apparent low bidder and Cam-Crete Construction is the apparent second bidder. After completion of reference checks, staff recommends award to Wopac Construction as the primary vendor and Cam-Crete Construction as the secondary vendor. Wopac received highly rated reviews and has completed several years’ worth of concrete repairs for the Town. The initial term of the contract will be one year, with four optional one-year renewal periods. Budget Impact: The Town will only pay for actual installed quantities. Staff estimated expenditure for these services in FY2025 at $600,000. Based on the unit price bids, the estimated expenditures is $473,400.00 with Wopac Construction and $508,500.00 with Cam-Crete Contracting, Inc. This funding for this contract will be out of 100-5480-50-01 – Contracted Services. Subsequent annual expenditures will be subject to appropriations in future fiscal years. PUBLIC WORKS Page 61 Item 10. Page 2 of 2 Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has approved the attached documents as to form and legality. Attached Documents: 1. Bid Tabulation 2. Contract for Services Town Staff Recommendation: Town Staff recommends to award Bid No. 2024-26-A to Wopac Construction, Inc. as the primary vendor, and Cam-Crete Contracting, Inc., as the secondary vendor, at the unit prices bid, to establish an annual contract for Miscellaneous Concrete Replacement Services not to exceed a total expenditure of $600,000.00; and authorizing the Town Manager to execute the same. Proposed Motion: I move to award Bid No. 2024-26-A to Wopac Construction, Inc. as the primary vendor, and Cam- Crete Contracting, Inc., as the secondary vendor, at the unit prices bid, to establish an annual contract for Miscellaneous Concrete Replacement Services not to exceed a total expenditure of $600,000.00; and authorizing the Town Manager to execute the same. Page 62 Item 10. Solicitation Number Solicitation Title Close Date Responding Supplier City State Response Submitted Response Total Wopac Construction Inc.Prosper TX 8/28/2024 10:17:42 AM (CT)$473,400.00 CAM-CRETE CONTRACTING INC Venus TX 8/28/2024 07:45:22 PM (CT)$508,500.00 Garret Shields Infrastructure Garland TX 8/29/2024 12:17:57 PM (CT)$565,750.00 Vernara Dallas TX 8/29/2024 12:38:39 PM (CT)$595,750.00 CI Pavement (Alderink Enterprises, Inc)Grand Prairie TX 8/23/2024 09:16:15 AM (CT)$638,153.50 Jim Bowman Construction Company, L.P.Plano TX 8/29/2024 11:45:30 AM (CT)$779,000.00 GRod Construction, LLC Aurora TX 8/28/2024 03:05:10 PM (CT)$804,750.00 Pavecon Public Works, LP Grand Prairie TX 8/29/2024 10:11:39 AM (CT)$865,250.00 Cantecc Construction Plano TX 8/29/2024 01:40:11 PM (CT)$931,237.18 Certified by: Jay Carter, NIGP-CPP, CPPB, C.P.M. Certified on:August 29, 2024 Purchasing Manager Town of Prosper, Texas **All bids/proposals submitted for the designated project are reflected on this tabulation sheet. However,the listing of the bid/proposal on this tabulation sheet shall not be construed as a comment on the responsiveness of such bid/proposal or as any indication that the agency accepts such bid/proposal as being responsive. The agency will make a determination as to the responsiveness of the vendor responses submitted based upon compliance with all applicable laws,purchasing guidelines and project documents,including but not limited to the project specifications and contract documents. The agency will notify the successful vendor upon award of the contract and,as according to the law, all bid/proposal responses received will be available for inspection at that time. TOWN OF PROSPER BID TABULATION SUMMARY RFB No. 2024-26-A Addendum 1 Miscellaneous Concrete Repair Services 08/29/2024 @ 2:00PM Page 63 Item 10. Page 64 Item 10. Page 65 Item 10. Page 66 Item 10. Page 67 Item 10. Page 68 Item 10. Page 69 Item 10. Page 70 Item 10. Page 71 Item 10. Page 72 Item 10. Page 73 Item 10. Page 74 Item 10. Page 75 Item 10. Page 76 Item 10. Page 77 Item 10. Page 78 Item 10. Page 79 Item 10. Page 80 Item 10. Page 81 Item 10. Page 82 Item 10. Page 83 Item 10. Page 84 Item 10. Page 85 Item 10. Page 86 Item 10. 2024-26-A Miscellaneous Concrete Repair Services Issue Date:8/11/2024 Questions Deadline:8/22/2024 12:00 PM (CT) Response Deadline:8/29/2024 02:00 PM (CT) Contact Information Contact:Jay Carter Purchasing Manager Address:Purchasing Office Town Hall 3rd Floor 250 W. First St. P.O. Box 307 Prosper, TX 75078 Phone:(972) 569-1018 Email:jcarter@prospertx.gov Deadline: 8/29/2024 02:00 PM (CT)2024-26-APage 1 of 8 pages Exhibit A Page 87 Item 10. Event Information Number:2024-26-A Title:Miscellaneous Concrete Repair Services Type:Request for Bids Issue Date:8/11/2024 Question Deadline:8/22/2024 12:00 PM (CT) Response Deadline:8/29/2024 02:00 PM (CT) Notes: The Town of Prosper is soliciting bids to establish an annual fixed price contract for miscellaneous concrete replacement services, to be performed within the Town of Prosper as described in the following bid specifications. The successful vendor will be responsible for providing all equipment, materials and labor necessary to complete services. The successful vendor will enter into a contract with the Town, which will be effective for one year, with four optional one-year renewal periods. A sample contract is available for review in the Purchasing Office. The contract will be awarded to the lowest responsive responsible bidder meeting specifications. It is the Town’s intent to award a primary and, potentially, a secondary vendor. The estimated annual expenditure for this service is $600,000.00. Orders will be placed on an as needed basis only, as determined by the Town. The bids are due on August 29, 2024, by 2:00PM and must be submitted through Ionwave. Responses will be read at 3:00PM and can be attended at the following link: Microsoft Teams meeting Join on your computer, mobile app or room device Join the meeting now Meeting ID: 288 926 938 820 Passcode: NZYpXD Ship To Information Contact:Jay Carter, Purchasing Manager Address:Purchasing Office Town Hall 3rd Floor 250 W. First St. P.O. Box 307 Prosper, TX 75078 Phone:(972) 569-1018 Email:jcarter@prospertx.gov Billing Information Contact:Accounts Payable Address:Finance Town Hall 3rd Floor 250 W. First St. P.O. Box 307 Prosper, TX 75078 Phone:(972) 569-1017 Email:ap@prospertx.gov Deadline: 8/29/2024 02:00 PM (CT)2024-26-APage 2 of 8 pages Page 88 Item 10. Bid Attachments Insurance Requirements for Construction Services R7-25-19.pdf Download Insurance Requirements for Construction Services Standard Terms and Conditions for Procurements V 9-11-23.pdf Download Standard Terms and Conditions for Procurements V 9-11-23 References Worksheet - fillable.pdf Download References Worksheet Conflict of Interest Questionnaire 1-1-2021.pdf Download Conflict of Interest Questionnaire 1-1-2021 2024-26-A Bid Specifications.pdf Download 2024-26-A Bid Specifications Requested Attachments References Worksheet (Attachment required) Proof of Insurance Coverage (Attachment required) Per Section III of the specifications Bid Attributes 1 Terms and Conditions Acknowledgement I have read, understand and agree to all terms and conditions contained in this solicitation. I Agree (Required: Check if applicable) 2 Certification By checking this box, submitter hereby certifies that he/she understands the specifications, has read the document in its entirety and that the prices contained in this bid/proposal have been carefully reviewed and are submitted as correct and final. Vendor further certifies and agrees to furnish any or all products/services upon which prices are extended at the price offered, in accordance with the terms and conditions contained herein. Vendor agrees that acceptance of any or all items by the Town of Prosper, Texas, within the time frame indicated in this solicitation, constitutes a contract. The individual submitting this bid/proposal certifies that he/she is a legal agent of the company, authorized to submit on behalf of the company, and is legally responsible for the decisions as to the prices and supporting documentation provided. I Agree (Required: Check if applicable) 3 Addendum No. 1 By checking this box, vendor acknowledges receipt and understanding of Addendum No. 1 (if issued by the Town of Prosper). I Agree (Optional: Check if applicable) 4 Addendum No. 2 By checking this box, vendor acknowledges receipt and understanding of Addendum No. 2 (if issued by the Town of Prosper). I Agree (Optional: Check if applicable) Deadline: 8/29/2024 02:00 PM (CT)2024-26-APage 3 of 8 pages Page 89 Item 10. 5 Addendum No. 3 By checking this box, vendor acknowledges receipt and understanding of Addendum No. 3 (if issued by the Town of Prosper). I Agree (Optional: Check if applicable) Bid Lines 1 Remove 6-inch to 8-inch Reinforced Concrete Pavement - REMOVAL, DISPOSAL AND RECYCLING OF EXISTING REINFORCED CONCRETE STREET PAVEMENT (TYPICALLY 6 INCHES TO 8 INCHES) AND BASE MATERIAL (Response required) Quantity:1200 UOM:SY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 2 Remove 10-inch to 12-inch Reinforced Concrete Pavement - REMOVAL, DISPOSAL AND RECYCLING OF EXISTING REINFORCED CONCRETE STREET PAVEMENT (TYPICALLY 10 INCHES TO 12 INCHES) AND BASE MATERIAL (Response required) Quantity:400 UOM:SY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 3 Install 6-inch Reinforced Concrete Pavement (4,000 PSI) - FURNISH AND INSTALL 6 INCH REINFORCED CONCRETE STREET PAVING (4,000 PSI) (Response required) Quantity:500 UOM:SY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 4 Install 8-inch Reinforced Concrete Pavement (4,000 PSI) - FURNISH AND INSTALL 8 INCH REINFORCED CONCRETE STREET PAVING (4,000 PSI) (Response required) Quantity:800 UOM:SY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) Deadline: 8/29/2024 02:00 PM (CT)2024-26-APage 4 of 8 pages Page 90 Item 10. 5 Install 10-inch to 12-inch Reinforced Concrete Pavement (4,000 PSI) - FURNISH AND INSTALL 10-12 INCH REINFORCED CONCRETE STREET PAVING (4,000 PSI) (Response required) Quantity:300 UOM:SY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 6 Install 6-inch Reinforced Concrete Pavement (HES) 4,000 PSI - FURNISH AND INSTALL 6 INCH REINFORCED CONCRETE STREET PAVING (HES) 4,000 PSI (Response required) Quantity:100 UOM:SY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 7 Install 8-inch Reinforced Concrete Pavement (HES) 4,000 PSI - FURNISH AND INSTALL 8 INCH REINFORCED CONCRETE STREET PAVING (HES) 4,000 PSI (Response required) Quantity:100 UOM:SY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 8 Install 10-inch to 12-inch Reinforced Concrete Pavement (HES) 4,000 PSI - FURNISH AND INSTALL 10-12 INCH REINFORCED CONCRETE STREET PAVING (HES) 4,000 PSI (Response required) Quantity:100 UOM:SY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 9 Furnish and Install Compacted Recycle Concrete Flexbase for Base Repair - FURNISH AND INSTALL COMPACTED RECYCLED CONCRETE FLEXBASE FOR BASE REPAIR (Response required) Quantity:800 UOM:CY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) Deadline: 8/29/2024 02:00 PM (CT)2024-26-APage 5 of 8 pages Page 91 Item 10. 1 0 Remove and Replace 4-inch to 5-inch Concrete Sidewalk (3,500 PSI) - REMOVAL AND REPLACEMENT OF EXISTING 4-5 INCH REINFORCED CONCRETE SIDEWALK (3,500 PSI) (Response required) Quantity:600 UOM:SY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 1 1 Install 4-inch to 5-inch new concrete sidewalk (3,500 PSI) - FURNISH AND INSTALL NEW 4-5 INCH REINFORCED CONCRETE SIDEWALK (3500 PSI) (Response required) Quantity:250 UOM:SY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 1 2 Traffic Control - FURNISH, INSTALL, AND MAINTAIN CONSTRUCTION BARRICADING AND WARNING SIGNS, INCLUDING FLASHING ARROW BOARDS AND TRAFFIC CONTROL PLAN, IF NEEDED (Response required) Quantity:1 UOM:LS Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 1 3 Remove and Replace junction box or grate inlet (typically 3-foot x 3-foot) - REMOVAL, DISPOSAL AND RECONSTRUCTION OF A REINFORCED CONCRETE INLET BOX (VARIOUS SIZE) (Response required) Quantity:2 UOM:EA Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 1 4 Removal, disposal and reconstruction of existing reinforced concrete inlet throat - REMOVAL, DISPOSAL AND RECONSTRUCTION OF EXISTING REINFORCED CONCRETE INLET THROAT (VARIOUS SIZE) (Response required) Quantity:2 UOM:EA Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) Deadline: 8/29/2024 02:00 PM (CT)2024-26-APage 6 of 8 pages Page 92 Item 10. 1 5 Furnish, install and maintain sod grass (Response required) Quantity:350 UOM:SY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 1 6 Remove and replace existing 6-inch reinforced concrete drive approach (4,000 PSI) (Response required) Quantity:100 UOM:SY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 1 7 Install 5-inch to 6-inch stamped patterned median pavement and street pavement. Color to be applied to surface of wet concrete; color and stamped pattern to match existing and approved by Town Representative. (Response required) Quantity:250 UOM:SY Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 1 8 Furnish, install and remove reinforced concrete barrier free ramps (Response required) Quantity:4 UOM:EA Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) 1 9 Buyer Set Price - MISCELLANEOUS ITEM FOR EXTRA WORK, PER APPROVED INVOICE (Response required) Quantity:1 UOM:EA Unit Price:$Total:$ Supplier Notes: No bid Additional notes (Attach separate sheet) Deadline: 8/29/2024 02:00 PM (CT)2024-26-APage 7 of 8 pages Page 93 Item 10. Supplier Information Company Name: Contact Name: Address: Phone: Fax: Email: Supplier Notes By submitting your response, you certify that you are authorized to represent and bind your company. Print Name Signature Deadline: 8/29/2024 02:00 PM (CT)2024-26-APage 8 of 8 pages Page 94 Item 10. 2024-26-A Addendum 1 Wopac Construction Inc. Supplier Response Event Information Number:2024-26-A Addendum 1 Title:Miscellaneous Concrete Repair Services Type:Request for Bids Issue Date:8/11/2024 Deadline:8/29/2024 02:00 PM (CT) Notes:The Town of Prosper is soliciting bids to establish an annual fixed price contract for miscellaneous concrete replacement services, to be performed within the Town of Prosper as described in the following bid specifications. The successful vendor will be responsible for providing all equipment, materials and labor necessary to complete services. The successful vendor will enter into a contract with the Town, which will be effective for one year, with four optional one-year renewal periods. A sample contract is available for review in the Purchasing Office. The contract will be awarded to the lowest responsive responsible bidder meeting specifications. It is the Town’s intent to award a primary and, potentially, a secondary vendor. The estimated annual expenditure for this service is $600,000.00. Orders will be placed on an as needed basis only, as determined by the Town. The bids are due on August 29, 2024, by 2:00PM and must be submitted through Ionwave. Responses will be read at 3:00PM and can be attended at the following link: Microsoft Teams meeting Join on your computer, mobile app or room device Join the meeting now Vendor: Wopac Construction Inc.2024-26-A Addendum 1Page 1 of 5 pages Exhibit B Page 95 Item 10. Meeting ID: 288 926 938 820 Passcode: NZYpXD Contact Information Contact:Jay Carter Purchasing Manager Address:Purchasing Office Town Hall 3rd Floor 250 W. First St. P.O. Box 307 Prosper, TX 75078 Phone:(972) 569-1018 Email:jcarter@prospertx.gov Vendor: Wopac Construction Inc.2024-26-A Addendum 1Page 2 of 5 pages Page 96 Item 10. Wopac Construction Inc. Information Contact:Adam Leach Address:P.O. Box 819 Prosper, TX 75078 Phone:(972) 562-8316 Fax:(903) 433-2123 Email:adamleachwopac@aol.com Web Address:wopacconst.com By submitting your response, you certify that you are authorized to represent and bind your company. Adam Leach adamleachwopac@aol.com Signature Email Submitted at 8/28/2024 10:17:42 AM (CT) Requested Attachments References Worksheet Reference Work Sheet for Town of Prosper - 2024.pdf Proof of Insurance Coverage Insurance Cert for Town of Propser 2024.pdf Per Section III of the specifications Bid Attributes 1 Terms and Conditions Acknowledgement I have read, understand and agree to all terms and conditions contained in this solicitation. I Agree 2 Certification By checking this box, submitter hereby certifies that he/she understands the specifications, has read the document in its entirety and that the prices contained in this bid/proposal have been carefully reviewed and are submitted as correct and final. Vendor further certifies and agrees to furnish any or all products/services upon which prices are extended at the price offered, in accordance with the terms and conditions contained herein. Vendor agrees that acceptance of any or all items by the Town of Prosper, Texas, within the time frame indicated in this solicitation, constitutes a contract. The individual submitting this bid/proposal certifies that he/she is a legal agent of the company, authorized to submit on behalf of the company, and is legally responsible for the decisions as to the prices and supporting documentation provided. I Agree 3 Addendum No. 1 By checking this box, vendor acknowledges receipt and understanding of Addendum No. 1 (if issued by the Town of Prosper). I Agree 4 Addendum No. 2 By checking this box, vendor acknowledges receipt and understanding of Addendum No. 2 (if issued by the Town of Prosper). I Agree Vendor: Wopac Construction Inc.2024-26-A Addendum 1Page 3 of 5 pages Page 97 Item 10. 5 Addendum No. 3 By checking this box, vendor acknowledges receipt and understanding of Addendum No. 3 (if issued by the Town of Prosper). I Agree Bid Lines 1 Remove 6-inch to 8-inch Reinforced Concrete Pavement - REMOVAL, DISPOSAL AND RECYCLING OF EXISTING REINFORCED CONCRETE STREET PAVEMENT (TYPICALLY 6 INCHES TO 8 INCHES) AND BASE MATERIAL Quantity:1200 UOM:SY Unit Price:$35.00 Total:$42,000.00 2 Remove 10-inch to 12-inch Reinforced Concrete Pavement - REMOVAL, DISPOSAL AND RECYCLING OF EXISTING REINFORCED CONCRETE STREET PAVEMENT (TYPICALLY 10 INCHES TO 12 INCHES) AND BASE MATERIAL Quantity:400 UOM:SY Unit Price:$38.00 Total:$15,200.00 3 Install 6-inch Reinforced Concrete Pavement (4,000 PSI) - FURNISH AND INSTALL 6 INCH REINFORCED CONCRETE STREET PAVING (4,000 PSI) Quantity:500 UOM:SY Unit Price:$82.00 Total:$41,000.00 4 Install 8-inch Reinforced Concrete Pavement (4,000 PSI) - FURNISH AND INSTALL 8 INCH REINFORCED CONCRETE STREET PAVING (4,000 PSI) Quantity:800 UOM:SY Unit Price:$95.00 Total:$76,000.00 5 Install 10-inch to 12-inch Reinforced Concrete Pavement (4,000 PSI) - FURNISH AND INSTALL 10-12 INCH REINFORCED CONCRETE STREET PAVING (4,000 PSI) Quantity:300 UOM:SY Unit Price:$110.00 Total:$33,000.00 6 Install 6-inch Reinforced Concrete Pavement (HES) 4,000 PSI - FURNISH AND INSTALL 6 INCH REINFORCED CONCRETE STREET PAVING (HES) 4,000 PSI Quantity:100 UOM:SY Unit Price:$82.00 Total:$8,200.00 7 Install 8-inch Reinforced Concrete Pavement (HES) 4,000 PSI - FURNISH AND INSTALL 8 INCH REINFORCED CONCRETE STREET PAVING (HES) 4,000 PSI Quantity:100 UOM:SY Unit Price:$104.00 Total:$10,400.00 8 Install 10-inch to 12-inch Reinforced Concrete Pavement (HES) 4,000 PSI - FURNISH AND INSTALL 10-12 INCH REINFORCED CONCRETE STREET PAVING (HES) 4,000 PSI Quantity:100 UOM:SY Unit Price:$119.00 Total:$11,900.00 9 Furnish and Install Compacted Recycle Concrete Flexbase for Base Repair - FURNISH AND INSTALL COMPACTED RECYCLED CONCRETE FLEXBASE FOR BASE REPAIR Quantity:800 UOM:CY Unit Price:$55.00 Total:$44,000.00 1 0 Remove and Replace 4-inch to 5-inch Concrete Sidewalk (3,500 PSI) - REMOVAL AND REPLACEMENT OF EXISTING 4-5 INCH REINFORCED CONCRETE SIDEWALK (3,500 PSI) Quantity:600 UOM:SY Unit Price:$112.50 Total:$67,500.00 Vendor: Wopac Construction Inc.2024-26-A Addendum 1Page 4 of 5 pages Page 98 Item 10. 1 1 Install 4-inch to 5-inch new concrete sidewalk (3,500 PSI) - FURNISH AND INSTALL NEW 4-5 INCH REINFORCED CONCRETE SIDEWALK (3500 PSI) Quantity:250 UOM:SY Unit Price:$81.00 Total:$20,250.00 1 2 Traffic Control - FURNISH, INSTALL, AND MAINTAIN CONSTRUCTION BARRICADING AND WARNING SIGNS, INCLUDING FLASHING ARROW BOARDS AND TRAFFIC CONTROL PLAN, IF NEEDED Quantity:1 UOM:LS Unit Price:$3,500.00 Total:$3,500.00 1 3 Remove and Replace junction box or grate inlet (typically 3-foot x 3-foot) - REMOVAL, DISPOSAL AND RECONSTRUCTION OF A REINFORCED CONCRETE INLET BOX (VARIOUS SIZE) Quantity:2 UOM:EA Unit Price:$5,100.00 Total:$10,200.00 1 4 Removal, disposal and reconstruction of existing reinforced concrete inlet throat - REMOVAL, DISPOSAL AND RECONSTRUCTION OF EXISTING REINFORCED CONCRETE INLET THROAT (VARIOUS SIZE) Quantity:2 UOM:EA Unit Price:$2,500.00 Total:$5,000.00 1 5 Furnish, install and maintain sod grass Quantity:350 UOM:SY Unit Price:$14.00 Total:$4,900.00 1 6 Remove and replace existing 6-inch reinforced concrete drive approach (4,000 PSI) Quantity:100 UOM:SY Unit Price:$120.00 Total:$12,000.00 1 7 Install 5-inch to 6-inch stamped patterned median pavement and street pavement. Color to be applied to surface of wet concrete; color and stamped pattern to match existing and approved by Town Representative. Quantity:250 UOM:SY Unit Price:$119.00 Total:$29,750.00 1 8 Furnish, install and remove reinforced concrete barrier free ramps Quantity:4 UOM:EA Unit Price:$3,400.00 Total:$13,600.00 1 9 Buyer Set Price - MISCELLANEOUS ITEM FOR EXTRA WORK, PER APPROVED INVOICE Quantity:1 UOM:EA Unit Price:$25,000.00 Total:$25,000.00 Response Total: $473,400.00 Vendor: Wopac Construction Inc.2024-26-A Addendum 1Page 5 of 5 pages Page 99 Item 10. Page 1 of 2 To: Mayor and Town Council From: Pete Anaya, P.E., Assistant Director of Engineering – Capital Projects Through: Mario Canizares, Town Manager Chuck Ewing, Assistant Town Manager Hulon T. Webb, Jr., P.E., Director of Engineering Services Re: First Street (Coit – Custer): Change Order No. 04 Town Council Meeting – September 24, 2024 Strategic Visioning Priority: 1. Acceleration of Infrastructure Agenda Item: Consider and act upon approving Change Order No. 04 for CSP 2022-48-B to Mario Sinacola & Sons Excavating, Inc., related to construction services for the First Street (Coit Road – Custer ) 4 Lane project; and authorizing the Town Manager to execute Change Order No. 4 for $122,820. Description of Agenda Item: Town Council authorized a construction contract with Mario Sinacola & Sons Excavating, Inc., at the September 13, 2022, Town Council meeting in the amount of $22,412,429.35. The project consists of all work needed for construction of four lanes of concrete roadway, underground storm drainage system, bridge construction, concrete trails, pedestrian trail tunnel, and related grading and utility improvements along First Street between Coit Road and Custer Road. With the acceleration of the opening of Walnut Grove High School by PISD, Change Order No. 1 was approved in the amount of $100,000 to accelerate the construction of First Street from Coit Road to just west of the Greenspoint Subdivision on December 13, 2022, by Town Council. Change Order No. 2 expanded the southbound left turn lane on Coit Road to increase capacity for the opening of the new High School, added additional lime treatment to the subgrade to meet actual soil conditions and Town standards, and addressed repairs to an unknown buried manhole that was damaged during bridge construction. On July 11, 2023, Town Council approved Change Order No. 2 in the amount of $402,872.69. Change Order No. 3 was approved through a Manager’s Memo dated November 21, 2023, at no additional cost and added 20 calendar days to the contract, the change order revised quantities on the water and wastewater systems and modified retaining wall quantities at Custer Road. Change Order No. 4 is for the emergency repairs to the storm sewer system on the eastbound lanes of First Street east of Coit Road. During a rain event, staff noticed storm water was percolating up from a concrete joint in the new outside eastbound travel lane of First Street. Upon further inspection, it was discovered that what was labeled in the construction drawings as a small driveway culvert was actually an outfall for a drainage system that extended to Coit Road. Staff worked with the consultant to come up with a solution to resolve the buried outfall structure. Once ENGINEERING SERVICES Page 100 Item 11. Page 2 of 2 a solution was arrived at, staff had the contractor submit an estimate to address the issue. In discussions with the design consultant, it was agreed that the Town would pay for the items that would have been required if the outfall had been correctly labeled in the construction drawings and the consultant would pay for any additional items that were a result of having to go back to correct the issue. Budget Impact: The cost for Change Order No. 4 is $122,820, of which $61,750 is funded from the design consultant and the Town will fund the remaining $61,070 from Account No. 750-6610-10-00-2014- ST. The construction cost including Change Order No. 4 is $23,038,122.04, and the construction budget for the project is $23,400,000. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has approved the standard change order form as to form and legality. Attached Documents: 1. Change Order No. 4 2. Location Map Town Staff Recommendation: Town Staff recommends that the Town Council approve Change Order No. 04 for CSP 2022-48- B to Mario Sinacola & Sons Excavating, Inc., related to construction services for the First Street (Coit Road – Custer ) 4 Lane project; and authorizing the Town Manager to execute Change Order No. 4 for $122,820. Proposed Motion: I move to approve Change Order No. 04 for CSP 2022-48-B to Mario Sinacola & Sons Excavating, Inc., related to construction services for the First Street (Coit Road – Custer ) 4 Lane project; and authorizing the Town Manager to execute Change Order No. 4 for $122,820. Page 101 Item 11. Page 102Item 11. Page 103 Item 11. Page 1 of 2 To: Mayor and Town Council From: Pete Anaya, P.E., Assistant Director of Engineering – Capital Projects Through: Mario Canizares, Town Manager Chuck Ewing, Assistant Town Manager Hulon T. Webb, Jr., P.E., Director of Engineering Services Re: Purchase Traffic Control Related Items: Pedestrian Hybrid Beacons (PHB) and Traffic Signal Equipment Town Council Meeting – September 24, 2024 Strategic Visioning Priority: 1. Acceleration of Infrastructure Agenda Item: Consider and act upon authorizing the Town Manager to approve the purchase of traffic control related items for Pedestrian Hybrid Beacons (PHB) at First/Copper Canyon, First/Chaucer, Gee/Lockwood, and traffic signal equipment at other project locations, from Consolidated Traffic Controls, Inc., utilizing the Houston-Galveston Area Council (HGAC) Cooperative Purchasing Program for $350,805. Description of Agenda Item: On October 24, 2023, the Town entered into a Professional Engineering Services Agreement with Lee Engineering, Inc., for the design of a traffic signal at Gee Road and Acacia Parkway and design of PHB’s at First/Copper Canyon, First/Chaucer, and Gee/Lockwood locations. The design of the PHB’s has progressed to the point where we are able to order the required traffic signal poles, mast arms, cabinets, battery backup units (BBU), and related equipment. In addition, this order includes traffic controller cabinets and BBU’s for the Gee/Acacia traffic signal, Denton Way/Fishtrap Road permanent signal, replacement for the DNT/Frontier signal, and one extra cabinet and BBU to keep in inventory for any accidents or new project. There is currently an estimated six (6) month lead time for pole manufacturing, powder coating, and related equipment delivery. Local governments are authorized by the Interlocal Cooperation Act, V.T.C.A. Government Code, Chapter 791, to enter into joint contracts and agreements for the performance of governmental functions and services, including administrative functions normally associated with the operation of government (such as purchasing necessary materials and equipment). The Town of Prosper and HGAC entered into an Interlocal Agreement, effective January 4, 2001, which allows our local government to purchase certain goods or services through HGAC. The agreement automatically renews each fiscal year, unless cancelled by either party. ENGINEERING SERVICES Page 104 Item 12. Page 2 of 2 Budget Impact: The cost of this purchase is $350,805, to be funded from the following accounts. 750-6610-10-00-2418-TR $80,117 (First/Copper Canyon) 750-6610-10-00-2419-TR $77,908 (First/Chaucer) 750-6610-10-00-2417-TR $84,988 (Gee/Lockwood) 750-6610-10-00-2402-TR $26,948 (Gee/Acacia) 750-6610-10-00-2422-TR $26,948 (Denton Way/Fishtrap) 750-6610-10-00-2317-TR $26,948 (DNT/Frontier) 100-6610-50-01 $26,948 (Extra: Public Works FY25 Budget) Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has approved the attached documents as to form and legality. Attached Documents: 1. HGAC Contract Pricing Worksheet 2. Location Map Town Staff Recommendation: Town Staff recommends that the Town Council authorize the Town Manager to approve the purchase of traffic control related items for Pedestrian Hybrid Beacons (PHB) at First/Copper Canyon, First/Chaucer, Gee/Lockwood, and traffic signal equipment at other project locations, from Consolidated Traffic Controls, Inc., utilizing the Houston-Galveston Area Council (HGAC) Cooperative Purchasing Program for $350,805. Proposed Motion: I move to authorize the Town Manager to approve the purchase of traffic control related items for Pedestrian Hybrid Beacons (PHB) at First/Copper Canyon, First/Chaucer, Gee/Lockwood, and traffic signal equipment at other project locations, from Consolidated Traffic Controls, Inc., utilizing the Houston-Galveston Area Council (HGAC) Cooperative Purchasing Program for $350,805. Page 105 Item 12. Contract No.:PE-05-21 Date Prepared:9/10/2024 Buying Agency:Contractor: Contact Person: Prepared By: Phone:Phone: Fax:Fax: Email:Email: Line Number Quan Description Unit Pr Total 1837 7 M79319H 24" Split Base, Natural W/Hardware 618.00$ 4,326.00$ 2136 7 M78508-SC 353i ATCC-HV Prosper Cabinet IA-24CH,FITA-24CH, OA-16CH, PWDR, (Add Controller) 9 LS 220 19,600.00$ 137,200.00$ 2732 7 APC-DOT Turnkey UPS w/ APC Secure UPS 1300VA/1300 W 120 VAC In/Out RM Plus Bypass Unit, 12' Harness 6,230.00$ 43,610.00$ 185,136.00$ Quan Unit Pr Total 7 RAL 8008 Powder coat on BBU and riser 500.00$ 3,500.00$ -$ -$ -$ 3,500.00$ 2% Quan Unit Pr Total -$ -$ -$ 188,636.00$ Subtotal C: Delivery Date: 30 to 45 Days ARO D. Total Purchase Price (A+B+C): Total From Other Sheets, If Any: Subtotal B: Check: The total cost of Unpublished Options (Subtotal B) cannot exceed 25% of the total from Section A.For this transaction the percentage is: C. Other Allowances, Discounts, Trade-Ins, Freight, Make Ready or Miscellaneous Charges Description Subtotal A: B. Unpublished Options, Accessory or Service items - Itemize Below - Attach Additional Sheet If Necessary (Note: Unpublished Items are any which were not submitted and priced in contractor's bid.) Description Catalog / Price Sheet Name:Traffic Control, Enforcement & Signal Preemption Equipment General Description of Product:Traffic Control Equipment A. Catalog / Price Sheet Items being purchased - Itemize Below - Attach Additional Sheet If Necessary Total From Other Sheets, If Any: - 945-234-1930 800-448-8841 800-448-8850 Aschmidt@prospertx.gov Bobby.Hale@ctc-traffic.com CONTRACT PRICING WORKSHEET For Catalog & Price Sheet Type Purchases This Worksheet is prepared by Contractor and given to End User. If a PO is issued, both documents MUST be faxed to H-GAC @ 713-993-4548. Therefore please type or print legibly. Prosper Consolidated Traffic Controls, Inc. Alex Schmidt Bobby Hale Page 106 Item 12. Contract No.:PE-05-21 Date Prepared:8/28/2024 Buying Agency:Contractor: Contact Person: Prepared By: Phone:Phone: Fax:Fax: Email:Email: Line Number Quan Description Unit Pr Total 1675 1 M73101SW Shelf Mount Flex Controller- w/Wi-Fi ATC Cabinet 2,350.00$ 2,350.00$ 1688 1 S-OMNI OMNI Software 1,250.00$ 1,250.00$ 2137 1 M55517-SC 356i ATCC-HV Prosper Cabinet IA-24CH,FITA-24CH, OA-16CH, NAT, (Add Controller) 15,666.00$ 15,666.00$ 2190 1 400901 LED Cobra Head 400 Watt 120 Volt (Duralight)310.00$ 310.00$ 2272 1 36' SMA-80L-8 36' SMA-80L-8 12,517.00$ 12,517.00$ 2275 1 44' SMA-80 44' SMA-80 11,747.00$ 11,747.00$ 2425 1 SMA Mast Arm 32'-40' SMA Mast Arm 32'-40'1,482.00$ 1,482.00$ 2732 1 APC-DOT Turnkey UPS w/ APC Secure UPS 1300VA/1300 W 120 VAC In/Out RM Plus Bypass Unit, 12' Harness 6,230.00$ 6,230.00$ 51,552.00$ Quan Unit Pr Total 1 Powder Coat BBU Cabinet RAL 8008 500.00$ 500.00$ -$ -$ -$ 500.00$ 1% Quan Unit Pr Total 1 Discount for Poles (1,092.00)$ (1,092.00)$ -$ (1,092.00)$ 50,960.00$ Subtotal C: Delivery Date: 30 to 45 Days ARO D. Total Purchase Price (A+B+C): Total From Other Sheets, If Any: Subtotal B: Check: The total cost of Unpublished Options (Subtotal B) cannot exceed 25% of the total from Section A.For this transaction the percentage is: C. Other Allowances, Discounts, Trade-Ins, Freight, Make Ready or Miscellaneous Charges Description Subtotal A: B. Unpublished Options, Accessory or Service items - Itemize Below - Attach Additional Sheet If Necessary (Note: Unpublished Items are any which were not submitted and priced in contractor's bid.) Description Catalog / Price Sheet Name:Traffic Control, Enforcement & Signal Preemption Equipment General Description of Product:Traffic Control Equipment A. Catalog / Price Sheet Items being purchased - Itemize Below - Attach Additional Sheet If Necessary Total From Other Sheets, If Any: First & Chaucer 972-569-1098 800-448-8841 800-448-8850 panaya@prospertx.gov Bobby.Hale@ctc-traffic.com CONTRACT PRICING WORKSHEET For Catalog & Price Sheet Type Purchases This Worksheet is prepared by Contractor and given to End User. If a PO is issued, both documents MUST be faxed to H-GAC @ 713-993-4548. Therefore please type or print legibly. Prosper Consolidated Traffic Controls, Inc. Pete Anaya Bobby Hale Page 107 Item 12. Contract No.:PE-05-21 Date Prepared:8/28/2024 Buying Agency:Contractor: Contact Person: Prepared By: Phone:Phone: Fax:Fax: Email:Email: Line Number Quan Description Unit Pr Total 1675 1 M73101SW Shelf Mount Flex Controller- w/Wi-Fi ATC Cabinet 2,350.00$ 2,350.00$ 1688 1 S-OMNI OMNI Software 1,250.00$ 1,250.00$ 2137 1 M55517-SC 356i ATCC-HV Prosper Cabinet IA-24CH,FITA-24CH, OA-16CH, NAT, (Add Controller) 15,666.00$ 15,666.00$ 2190 2 400901 LED Cobra Head 400 Watt 120 Volt (Duralight)310.00$ 620.00$ 2270 1 32' SMA-80L-8 32' SMA-80L-8 11,495.00$ 11,495.00$ 2274 1 40' SMA-80L-8 40' SMA-80L-8 13,501.00$ 13,501.00$ 2425 2 SMA Mast Arm 32'-40' SMA Mast Arm 32'-40'1,482.00$ 2,964.00$ 2732 1 APC-DOT Turnkey UPS w/ APC Secure UPS 1300VA/1300 W 120 VAC In/Out RM Plus Bypass Unit, 12' Harness 6,230.00$ 6,230.00$ 54,076.00$ Quan Unit Pr Total 1 Powder Coat BBU cabinet RAL 8008 500.00$ 500.00$ -$ -$ -$ 500.00$ 1% Quan Unit Pr Total 1 Discount on Poles (1,407.00)$ (1,407.00)$ -$ (1,407.00)$ 53,169.00$ Subtotal C: Delivery Date: 30 to 45 Days ARO D. Total Purchase Price (A+B+C): Total From Other Sheets, If Any: Subtotal B: Check: The total cost of Unpublished Options (Subtotal B) cannot exceed 25% of the total from Section A.For this transaction the percentage is: C. Other Allowances, Discounts, Trade-Ins, Freight, Make Ready or Miscellaneous Charges Description Subtotal A: B. Unpublished Options, Accessory or Service items - Itemize Below - Attach Additional Sheet If Necessary (Note: Unpublished Items are any which were not submitted and priced in contractor's bid.) Description Catalog / Price Sheet Name:Traffic Control, Enforcement & Signal Preemption Equipment General Description of Product:Traffic Control Equipment A. Catalog / Price Sheet Items being purchased - Itemize Below - Attach Additional Sheet If Necessary Total From Other Sheets, If Any: First & Copper Canyon PHB 972-569-1098 800-448-8841 800-448-8850 panaya@prospertx.gov Bobby.Hale@ctc-traffic.com CONTRACT PRICING WORKSHEET For Catalog & Price Sheet Type Purchases This Worksheet is prepared by Contractor and given to End User. If a PO is issued, both documents MUST be faxed to H-GAC @ 713-993-4548. Therefore please type or print legibly. Prosper Consolidated Traffic Controls, Inc. Pete Anaya Bobby Hale Page 108 Item 12. Contract No.:PE-05-21 Date Prepared:8/28/2024 Buying Agency:Contractor: Contact Person: Prepared By: Phone:Phone: Fax:Fax: Email:Email: Line Number Quan Description Unit Pr Total 1666 1 M92410SW FLEX SHELF MOUNT CONTROLLER, WIFI, EB4 2,438.00$ 2,438.00$ 1688 1 S-OMNI OMNI Software 1,250.00$ 1,250.00$ 2137 1 M55517-SC 356i ATCC-HV Prosper Cabinet IA-24CH,FITA-24CH, OA-16CH, NAT, (Add Controller) 15,666.00$ 15,666.00$ 2190 2 400901 LED Cobra Head 400 Watt 120 Volt (Duralight)310.00$ 620.00$ 2274 1 40' SMA-80L-8 40' SMA-80L-8 13,501.00$ 13,501.00$ 2278 1 48' SMA-80L-8 48' SMA-80L-8 15,601.00$ 15,601.00$ 2425 1 SMA Mast Arm 32'-40' SMA Mast Arm 32'-40'1,482.00$ 1,482.00$ 2426 1 SMA Mast Arm 44'-48' SMA Mast Arm 44'-48'1,619.00$ 1,619.00$ 2732 1 APC-DOT Turnkey UPS w/ APC Secure UPS 1300VA/1300 W 120 VAC In/Out RM Plus Bypass Unit, 12' Harness 6,230.00$ 6,230.00$ 58,407.00$ Quan Unit Pr Total 1 Powder Coat BBU Cabinet 500.00$ 500.00$ -$ -$ -$ 500.00$ 1% Quan Unit Pr Total 1 Discount for Poles (867.00)$ (867.00)$ -$ (867.00)$ 58,040.00$ CONTRACT PRICING WORKSHEET For Catalog & Price Sheet Type Purchases This Worksheet is prepared by Contractor and given to End User. If a PO is issued, both documents MUST be faxed to H-GAC @ 713-993-4548. Therefore please type or print legibly. Prosper Consolidated Traffic Controls, Inc. Pete Anaya Bobby Hale 972-569-1098 800-448-8841 800-448-8850 panaya@prospertx.gov Bobby.Hale@ctc-traffic.com Subtotal A: B. Unpublished Options, Accessory or Service items - Itemize Below - Attach Additional Sheet If Necessary (Note: Unpublished Items are any which were not submitted and priced in contractor's bid.) Description Catalog / Price Sheet Name:Traffic Control, Enforcement & Signal Preemption Equipment General Description of Product:Traffic Control Equipment A. Catalog / Price Sheet Items being purchased - Itemize Below - Attach Additional Sheet If Necessary Total From Other Sheets, If Any: Gee & Lockwood Subtotal C: Delivery Date: 30 to 45 Days ARO D. Total Purchase Price (A+B+C): Total From Other Sheets, If Any: Subtotal B: Check: The total cost of Unpublished Options (Subtotal B) cannot exceed 25% of the total from Section A.For this transaction the percentage is: C. Other Allowances, Discounts, Trade-Ins, Freight, Make Ready or Miscellaneous Charges Description Page 109 Item 12. LOCATION MAP Traffic Related Equipment Purchase Project Locations First Street Frontier Pkwy DNT FM 1385 Page 110Item 12. Page 1 of 2 To: Mayor and Town Council From: Pete Anaya, P.E., Assistant Director of Engineering – Capital Projects Through: Mario Canizares, Town Manager Chuck Ewing, Assistant Town Manager Hulon T. Webb, Jr., P.E., Director of Engineering Services Re: Traffic Signal Conduit and Span Wire Pole Relocation DNT / Frontier Parkway Intersection Town Council Meeting – September 24, 2024 Strategic Visioning Priority: 1. Acceleration of Infrastructure Agenda Item: Consider and act upon authorizing the Town Manager to enter into an agreement with Mels Electric, LLC, related to relocating existing traffic signal conduits and span wire poles at DNT / Frontier Parkway Intersection project; and authorizing the Town Manager to execute documents for $155,999.45. Description of Agenda Item: The Town has been coordinating with NTTA for the extension of the DNT main lanes from the US 380 overpass north through the Town of Prosper and was notified of conflicts with the existing traffic signal conduits and span wire wood poles with proposed construction of the Frontier Parkway overpass by NTTA. The existing conduit was installed long before final plans for the DNT main lanes were designed, therefore, there was no way to accurately place the conduit in a location that did not conflict with the future lanes. The proposed scope of work involves the relocation of approximately 940 linear feet (LF) of PVC conduit, 3,600 LF of electrical conductor, 2,250 LF of communication conductors, 1,050 LF of opticom detector cable, additional vehicle signal heads, and the relocation of four 40-foot poles with luminaires, at both southbound and northbound intersections of Frontier Parkway and the DNT frontage roads. Since time is of the essence to resolve the conflicts and not impact the construction schedule for the expansion of the DNT main lanes project, the Engineering Department contacted the City of Garland to utilize their existing purchase order for “Traffic Signal Installations / Modernizations” from Mels Electric, LLC. The Town is able to utilize the City of Garland’s purchase order with Mels Electric, LLC, under an existing Interlocal Agreement with the Collin County Governmental Purchase Forum. This not only allows the Town to save time, it has also allowed the Town to save approximately 15% in costs when compared to previous unit costs for new installation work. ENGINEERING SERVICES Page 111 Item 13. Page 2 of 2 The Town has previously used Mels Electric, LLC, on several Town projects with satisfactory results. Upon approval, they will mobilize to the construction site within 30 days and be complete with the relocations in 90 days from mobilization. Budget Impact: This cost for the construction of the project is $155,999.45. The construction budget for the project is $200,000 in Account No. 750-6610-10-00-2317-TR. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has approved the attached documents as to form and legality. Attached Documents: 1. Proposal from Mels Electric, LLC 2. Location Map Town Staff Recommendation: Town Staff recommends that the Town Council approve an agreement with Mels Electric, LLC, related to relocating existing traffic signal conduits and span wire poles at DNT / Frontier Parkway Intersection project; and authorizing the Town Manager to execute documents for $155,999.45. Proposed Motion: I move to authorize the Town Manager to execute an agreement with Mels Electric, LLC, related to relocating existing traffic signal conduits and span wire poles at DNT / Frontier Parkway Intersection project; and authorize the Town Manager to execute documents for $155,999.45. Page 112 Item 13. 5016 MELS ELECTRIC LLC PO BOX 40, WILMER, TEXAS 75172 972/441-6208 FAX-972/441-6394 BID QUOTATION PROJECT: ONT & FRONTIER TRAFFIC SIGNAL MODIFICATION (Per Bid Items Received from Adam -Prosper & Chris -Lee Engineering Attached) LOCATION: PROSPER,TEXAS DATE : 9-9-24 VALID 30 DAYS TOTAL $155,999.45 -===:=: ' ----------===------====================================================, ' ============ ' ===--' = ' =- Item Description Quan. Unit Price I Per * Extended Price * =====-= . -----------------------------=--------===------=====----=======--======: : -=====----== ! ===== : ==== : ============= : MOBILIZATION 2 BARRICADES, SIGNS ANO TRAFFIC HANDLING (ARROW BOARD & CONES ONLY) 3 CONDT (PVC) (SCHD 40) (2") 4 CONDT (PVC) (SCHD 40) (2") (BORE) 5 CONDT (PVC) (SCHD 40) (3") 6 CONDT (PVC) (SCHD 40) (4") 7 CONDT (PVC) (SCHD 40) (4") (BORE) 8 CONDT (RM) (2") 9 CONDT (RM) (3") 10 ELEC CONDUCTOR (NO. 8) INSULATED 11 ELEC CONDUCTOR (NO. 6) BARE 12 GROUND BOX TY D (162922) W/APRON 13 REMOVE GROUND BOX 14 ZINC-COAT STL WIRE STRAND (1/4") 15 ZINC-COAT STL WIRE STRAND (3/8") 16 TIMBER POLE (CL 2) 40 FT 17 VEH SIG SEC (12") LED (GRN) 18 VEH SIG SEC (12") LED (GRN ARW) 19 VEH SIG SEC (12") LED (YEL) 20 VEH SIG SEC (12") LED (RED) 21 BACKPLATE W/REF BRDR(3 SEC)(VENT)ALUM 22 TRF SIG CBL (TY A) (14 AWG) (5 CONDR) 23 TRF SIG CBL (TY A) (14 AWG) (7 CONDR) 24 REMOVAL OF CABLES 25 REMOVAL OF SPAN CABLE ASSM 26 REMOVAL OF TIMBER POLES 27 REMOVAL OF SIGNAL HEAD ASSM 28 REMOVAL OF LUMINAIRE MAST ARMS 29 INSTALL OF LUMINAIRE MAST ARMS 30 REMOVE DOWN GUY AND ANCHOR W/GUARD 31 CONDUIT (PREPARE) 32 GROUND BOX (PREPARE) 33 RELOCATE RVDS 34 OPTICOM DETECTOR CABLE RCVD ADDENDUM: NOTES: Bid quotation does NOT include: engineering.barricades, temp. power, tax, pavement markings, utility co. charges, removal & replacement of irrigation, landscape, dirt, asphalt, or concrete, riprap around poles, engineered traffic control plan or equipment. TEMP. SIGNALS small roadside signs ANY NEW SIGNAL RELATED COMPONENTS / RADAR, CONTROLLER, ETC ... 1.00 I 2.00 I 125.oo I 75.oo I 20.00 I 450.00 I 190.00 I 40.00 I 40.00 I 2812.00 I 860.00 I 4.oo I 2.00 I 490.00 I 1659.oo I 4.oo I 8.00 2.00 10.00 10.00 10.00 1718.00 511.00 410.00 382.00 5.00 10.00 4.00 4.00 4.00 195.00 3.oo I 3.00 1036.00 $1,520.00 I LS $1,550.00 I MO $16.10 I LF $23.25 I LF $20.50 I LF $26.75 I LF $41.20 I LF $32.00 I LF $70.00 I LF $2.90 I LF • $3.00 I LF • $1,950.00 I EA • $375.00 I EA $7.00 I LF $7.50 I LF $2,650.00 I EA $400.00 J EA $400.00 I EA $400.00 I EA $400.00 I EA $1,320.00 J EA $3.20 I LF $4.10 J LF $5 .50 I LF $10.30 I LF $570.00 I EA • $140.00 I EA $2,590.00 I EA $2,390.00 I EA $850.00 I EA ' $8.50 I LF $1,125.00 I EA $1,250.00 I EA $2. 10 J LF I I I I I I I I I I I I ======= : ===============================================================---===---. =·-==-===- MATERIALS LABOR,OVERHEAD,PROFIT,ETC TOTAL BID PRICE $1,520.00 * $3,100.00 * $2,012.50 * $1,743.75 * $410.00 * $12,037.50 * $7,828.00 * $1,280.00 * $2,800.00 * $8,154.80 * $2,580.00 * $7,800.00 * $750.00 * $3,430.00 * $12,442.50 * $10,600.00 * $3,200.00 * $800.00 * $4,000.00 * $4,000.00 * $13,200.00 * $5,497.60 * $2,095.10 * $2,255.00 * $3,934.60 * $2,850.00 * $1,400.00 * $10,360.00 * $9,560.00 * $3,400.00 * $1,657.50 * $3,375.00 * $3,750.00 * $2,175.60 * $78,111.02 $77,888.43 $155,999.45 Page 113 Item 13. LOCATION MAP Traffic Signal Conduit and Span Wire Pole Relocations DNT and Frontier Parkway Intersection Traffic Signal Relocations DNT Frontier Parkway Page 114Item 13.