Loading...
2021-03 - O - Amending Ordinance No. 2020-71 (FY 2020-2021 Annual Budget and Capital Improvement Program)TOWN OF PROSPER, TEXAS ORDINANCE NO. 2021-03 AN ORDINANCE OF THE TOWN OF PROSPER, TEXAS, AMENDING ORDINANCE NO. 2020-71 (FY 2020-2021 ANNUAL BUDGET AND CAPITAL IMPROVEMENT PROGRAM) AND ALLOCATING FUNDS TO FUND INCREASED EXPENDITURES OF $2,264,263.30 IN THE GENERAL FUND BUDGET; INCREASED EXPENDITURES OF $184,242.30 IN THE WATER - SEWER FUND BUDGET; INCREASED EXPENDITURES OF $100,000.00 IN THE STORMWATER DRAINAGE UTILITY FUND BUDGET; INCREASED EXPENDITURES OF $456,089.75 IN THE PARK IMPROVEMENT FUND BUDGET; INCREASED EXPENDITURES OF $54,662.74 IN THE WATER IMPACT FEE FUND BUDGET; INCREASED EXPENDITURES OF $475,876.15 IN THE EAST THOROUGHFARE IMPACT FEE FUND BUDGET; INCREASED EXPENDITURES OF $4,157.20 IN THE SPECIAL REVENUE FUND BUDGET; INCREASED EXPENDITURES OF $1,288,031.44 IN THE CARES ACT FUND BUDGET; AND INCREASED EXPENDITURES OF $154,185.00 IN THE WEST THOROUGHFARE IMPACT FEE FUND BUDGET; PROVIDING FOR REPEALING, SAVINGS AND SEVERABILITY CLAUSES; AND PROVIDING FOR AN EFFECTIVE DATE OF THIS ORDINANCE. WHEREAS, the Town Council of the Town of Prosper, Texas ("Town Council'), has investigated and determined that it will be beneficial and advantageous to the residents of the Town of Prosper, Texas ("Prosper"), to amend Ordinance No. 2020-71 (FY 2020-2021 Annual Budget and Capital Improvement Program) for the purposes listed in Exhibit "A," attached hereto and incorporated herein by reference; and WHEREAS, the changes will result in budgeted funds being reallocated among different funds and departments and an overall net increase in the budget for funding from fund balance. NOW, THEREFORE, BE IT ORDAINED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, THAT: SECTION 1 Findings Incorporated. The findings set forth above are incorporated into the body of this Ordinance as if fully set forth herein. SECTION 2 Amendment to Ordinance No. 2020-71 (FY 2020-2021 Budget). Ordinance No. 2020-71 (FY 2020-2021 Annual Budget and Capital Improvement Program) is hereby amended to allow for increases to appropriations as shown in Exhibit "A," attached hereto and incorporated herein by reference. SECTION 3 Savings/Repealing Clause. All provisions of any ordinance in conflict with this Ordinance are hereby repealed, but such repeal shall not abate any pending prosecution for violation of the repealed Ordinance, nor shall the repeal prevent prosecution from being commenced for any violation if occurring prior to the repeal of the Ordinance. Any remaining portions of conflicting ordinances shall remain in full force and effect. SECTION 4 Severability. Should any section, subsection, sentence, clause, or phrase of this Ordinance be declared unconstitutional or invalid by a court of competent jurisdiction, it is expressly provided that any and all remaining portions of this Ordinance shall remain in full force and effect. Prosper hereby declares that it would have passed this Ordinance, and each section, subsection, sentence, clause, or phrase thereof irrespective of the fact that any one or more sections, subsections, sentences, clauses, or phrases be declared unconstitutional or invalid. SECTION 5 Effective Date. This Ordinance shall become effective immediately upon its passage. DULY PASSED AND APPROVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, ON THIS 12TH DAY OF JANUARY, 2021. TOWN OF PROSPER, TEXAS KX(4 Ray Smi , Mayor ATTEST TO: T' Melissa Lee, To n Secretary APPROVED AS TO FORM AND LEGALITY: Terrence S. Welch, Town Attorney Ordinance No. 2021-03, Page 2 EXHIBIT "A" BUDGET AMENDMENT FISCAL YEAR 2020-2021 January 12, 2021 General Fund Original Budget Current Budget Amended Budget Increase (Decrease) Total Revenues 32,698,400.00 32,798,400.00 32,798,400.00 Total 32,698,400.00 32,798,400.00 32,798,400.00 Expenditures: Administration 5,598,394.00 6,125,394.00 6,391,809.23 266,415.23 Police Services 5,997,484.00 6,097,484.00 6,142,032.50 44,548.50 Fire Services 7,713,465.00 7,713,465.00 9,523,465.00 1,810,000.00 Public Works 3,272,379.00 3,272,379.00 3,290,076.90 17,697.90 Community Services 4,605,459.00 4,605,459.00 4,612,744.00 7,285.00 Development Services 3,371,304.00 3,371,304.00 3,466,304.00 95,000.00 Engineering 2,031,806.00 2,031,806.00 2,055,122.97 23,316.97 Total 32,590,291.00 33,217,291.00 35,481,554.60 2,264,263.60 Water -Sewer Utility Fund Original Budget Current Budget Amended Budget Increase (Decrease) Total Revenues 24,504,693.00 24,504,693.00 24,504,693.00 Total 24,504,693.00 24,504,693.00 24,504,693.00 Expenditures: Administration 2,615,646.00 2,615,646.00 2,690,901.00 75,255.00 Debt Service 3,701,269.00 3,701,269.00 3,701,269.00 - Water Purchases 6,681,709.00 6,681,709.00 6,681,709.00 - Public Works 11,410,264.00 11,410,264.00 11,519,251.30 108,987.30 Total 24,408,888.00 24,408,888.00 24,593,130.30 184,242.30 Stormwater Drainage Utility Fund Original Budget Current Budget Amended Budget Increase (Decrease) Total Revenues 715,200.00 715,200.00 715,200.00 Total 715,200.00 715,200.00 715,200.00 - Expenditures: Operating Expenses 197,751.00 197,751.00 297,751.00 100,000.00 Debt Service 245,592.00 245,592.00 245,592.00 - Transfers Out 104,926.00 104,926.00 104,926.00 Total 548,269.00 548,269.00 648,269.00 100,000.00 Park Improvement Fund Original Budget Current Budget Amended Budget Increase (Decrease) Total Revenues 607,500.00 607,500.00 607,500.00 Total 607,500.00 607,500.00 607,500.00 Expenditures 1,485,000.00 1,485,000.00 1,941,089.75 456,089.75 Total 1,485,000.00 1,485,000.00 1,941,089.75 456,089.75 Water Impact Fee Fund Original Budget Current Budget Amended Budget Increase (Decrease) Total Revenues 2,512,000.00 2,512,000.00 2,512,000.00 Total 2,512,000.00 2,512,000.00 2,512,000.00 Expenditures 1,840,000.00 1,840,000.00 1,894,662.74 54,662.74 Total 1,840,000.00 1,840,000.00 1,894,662.74 54,662.74 Ordinance No 2021-03, Page 3 EXHIBIT "A" BUDGET AMENDMENT FISCAL YEAR 2020-2021 January 12, 2021 East Thoroughfare Impact Fee Fund Original Budget Current Budget Amended Budget Increase (Decrease) Total Revenues 1,008,000.00 1,008,000.00 1,008,000.00 Total 1,008,000.00 1,008,000.00 1,008,000.00 Expenditures 475,000.00 475,000.00 950,876.15 475,876.15 Total 475,000.00 475,000.00 950,876.15 475,876.15 Special Revenue Fund Original Budget Current Budget Amended Budget Increase (Decrease) Total Revenues 54,600.00 54,600.00 54,600.00 Total 54,600.00 54,600.00 54,600.00 Total Expenditures 271,246.00 271,426.00 275,583.20 4,157.20 Total 271,246.00 271,426.00 275,583.20 4,157.20 CARES Act Fund Original Budget Current Budget Amended Budget Increase (Decrease) Total Revenues 662,567.23 662,567.23 Total $ - $ - $ 662,567.23 $ 662,567.23 Total Expenditures 1,288,031.44 1,288,031.44 Total $ $ - 1,288,031.44 1,288,031.44 West Thoroughfare Impact Fee Fund Original Budget Current Budget Amended Budget Increase (Decrease) Total Revenues 2,510,000.00 2,510,000.00 2,510,000.00 Total 2,510,000.00 2,510,000.00 2,510,000.00 Expenditures 3,137,500.00 3,137,500.00 3,291,685.00 154,185.00 Total 3,137,500.00 3,137,500.00 3,291,685.00 154,185.00 Total Revenue Total Expenditures Net Effect All Funds $ 662,567.23 $ 4,981,508.18 $ (4,318,940.95) Ordinance No 2021-03, Page 4 Exhibit B Department PO # Date Issued Vendor Name Line Balance Description Status Engineering (CIP) 16105 02/26/16 Wier & Associates $ 1,900.00 PSA Old Town Drainage - Church & Parvin Drainage Improvements Project 1613-DR Project in progress. Estimated completion Spring 2021. 16105 02/26/16 Wier & Associates $ 2,000.00 Engineering (CIP) 17088 01/30/17 Cobb, Fendley & Assoc., Inc. $ 60,500.00 PSA Paving & Drainage Improvements for Coit Road From E. First Street to Frontier Parkway Project 1710-ST Project in progress. Design 90% complete. 17088 01/30/17 Cobb, Fendley & Assoc., Inc. $ 16,000.00 17088 01/30/17 Cobb, Fendley & Assoc., Inc. $ 10,230.00 17088 01/30/17 Cobb, Fendley & Assoc., Inc. $ 16,500.00 17088 01/30/17 Cobb, Fendley & Assoc., Inc. $ 12,720.00 17088 01/30/17 Cobb, Fendley &Assoc., Inc. $ 81,700.00 17088 01/30/17 Cobb, Fendley & Assoc., Inc. $ 19,280.00 17088 01/30/17 Cobb, Fendley & Assoc., Inc. $ 64,824.50 17088 01/30/17 Cobb, Fendley & Assoc., Inc. $ 83,000.00 Engineering (CIP) 17122 03/13/17 HalffAssociates $ 658.73 PSA Prosper Trail From East of Coit Road to West of Custer Road Project 1709-ST Project in progress. Estimated completion Summer 2021. 17122 03/13/17 HalffAssociates $ 9,889.30 Engineering (CIP) 17143 04/20/17 Freese & Nichols $ 244.02 PSA Lower Pressure Plane Elevated Storage Tank Project 1715-WA Contract Amended. Project in progress. Construction 95 % complete. 17143 04/20/17 Freese & Nichols $ 18,287.00 Engineering (CIP) 17144 04/20/17 Freese & Nichols $ 3,977.51 PSA Lower Pressure Plane Water Supply - Pipeline Project 1716-WA Project in progress. Completed - roll to process final invoices. 17144 04/20/17 Freese & Nichols $ 3,948.43 17144 04/20/17 Freese & Nichols $ 1,515.28 17144 04/20/17 Freese & Nichols $ 26,962.50 17144 04/20/17 Freese & Nichols $ 10,965.00 17144 04/20/17 Freese & Nichols $ 7,050.00 Engineering (CIP) 18105 12/21/17 Garver, LLC $ 1,017.92 PSA Design of Cook Lane and E-W Collector Project Project in progress. Estimated completion Spring 2021. 18105 12/21/17 Garver, LLC $ 1,440.00 18105 12/21/17 Garver, LLC $ 2,880.00 18105 12/21/17 Garver, LLC $ 600.00 Parks Admin (CIP) 18106 12/27/17 BW2 Engineers, Inc. $ 1,650.00 PSA Whitely Place Trail Extension Project Project in progress. Estimated completion Winter 2021. 18106 12/27/17 BW2 Engineers, Inc. $ 6,500.00 18106 12/27/17 BW2 Engineers, Inc. $ 900.00 18106 12/27/17 BW2 Engineers, Inc. $ 1,700.00 18106 12/27/17 BW2 Engineers, Inc. $ 750.00 18106 12/27/17 BW2 Engineers, Inc. $ 1,500.00 18106 12/27/17 BW2 Engineers, Inc. $ 625.00 Parks Admin (CIP) 18152 03/01/18 HalffAssociates $ 1,400.00 PSA US 380 Green Ribbon Landscape Design Project Project in progress. Estimated completion Summer 2021. 18152 03/01/18 HalffAssociates $ 2,500.00 18152 03/01/18 HalffAssociates $ 4,315.00 18152 03/01/18 HalffAssociates $ 4,315.00 18152 03/01/18 HalffAssociates $ 1,320.00 18152 03/01/18 Halff Associates $ 500.00 Engineering (CIP) 18201 05/16/18 Wier & Associates, Inc. $ 8,000.00 PSA Old Town Drainage - Broadway & Church Retention Pond Improvements Project 1718-DR Project in progress. Estimated completion Spring 2021. 18201 05/16/18 Wier & Associates, Inc. $ 6,000.00 Engineering (CIP) 18225 06/29/18 RKM Utility Services $ 216,032.28 Bid No. 2018-75-B Paving and Drainage Improvements, Prosper Trail (Kroger- Colt) Roll to review and close-out project. 18225 06/29/18 RKM Utility Services $ 15,750.00 18225 06/29/18 RKM Utility Services $ 20,030.00 18225 06/29/18 RKM Utility Services $ 7,939.89 18225 06/29/18 RKM Utility Services $ 26,818.45 18225 06/29/18 RKM Utility Services $ 166,400.00 18225 06/29/18 RKM Utility Services $ 5,500.00 18225 06/29/18 RKM Utility Services $ 14,700.00 18225 06/29/18 RKM Utility Services $ 6,253.00 Engineering (CIP) 18248 08/17/18 BGE, Inc. $ 3,000.00 PSA Victory Way (N. Coleman to Frontier Parkway) Project 1823-ST Project in progress. Estimated completion Winter 2021. 18248 08/17/18 BGE, Inc. $ 5,000.00 18248 08/17/18 BGE, Inc. $ 678.52 18248 08/17/18 BGE, Inc. $ 20.00 18248 08/17/18 BGE, Inc. $ 188.62 Ordinance No. 2021-03, Page 5 Exhibit B Police Department (CIP) 18260 08/28/18 Brown Reynolds Watford Arch. $ 981,198.56 PSA Police Station and Dispatch Facility Roll to pay final invoice. 18260 08/28/18 Brown Reynolds Watford Arch. $ 30,751.46 Engineering (CIP) 18270 09/06/18 Spiars Engineering, Inc. $ 4,564.33 PSA Fishtrap Road and Teel Parkway Intersection Improvements Project 1824-ST Roll to pay final invoice. Parks Admin CIP 19026 10/11/18 Parkhill, Smith & Cooper, Inc. $ 283.57 PSA Has Park Project 1802-PK Project in progress. Estimated completion Spring 2021. Engineering (CIP) 19093 12/01/18 Freese & Nichols $ 43,232.65 PSA Custer Road Pipeline and Meter Vault Relocations Project Project under construction (10% complete). Will remain open until project is constructed and as-builts are required to be completed by engineer. 19093 12/01/18 Freese & Nichols $ 5,300.00 Engineering (CIP) 19130 01/03/19 Landmark Structures I, LP $ 720,248.00 Bid No. 2019-04-B Construction of Fishtrap 2.5 MG Elevated Storage Tank Project to be complete by January 2021. 95% complete. Engineering (CIP) 19204 03/27/19 Harris Kocher Smith $ 760.00 PSA Cook Lane Extension Project 1708-ST Awaiting final invoice. 19204 03/27/19 Harris Kocher Smith $ 380.00 19204 03/27/19 Harris Kocher Smith $ 1,380.00 Engineering 19216 04/04/19 Lee Engineering $ PSA Prosper Quiet Zone & Railroad Grade Separation Preliminary Design Services Project 1925-TR) Project in progress. Projects 95% complete. 19216 04/04/19 Lee Engineering $ 19216 04/04/19 Lee Engineering $ 19216 04/04/19 Lee En ineerin $ 19216 04/04/19 Lee Engineering $ 1,045.00 19216 04/04/19 Lee Engineering $ 3,485.00 19216 04/04/19 Lee Engineering $ 3,485.00 19216 04/04/19 Lee Engineering $ 867.50 19216 04/04/19 Lee Engineering $ 867.49 Engineering (CIP) 19246 05/22/19 McKee Utility Contractors, Inc $ 2,073,979.73 Bid No. 2019-52-B Lower Pressure Water Line Project in progress. 99% complete. 19246 05/22/19 McKee Utility Contractors, Inc $ 1,227.00 19246 05/22/19 McKee Utility Contractors, Inc $ 17,003.00 19246 05/22/19 McKee Utility Contractors, Inc $ 3,811.00 19246 05/22/19 McKee Utility Contractors, Inc $ 19,641.00 19246 05/22/19 McKee Utility Contractors, Inc $ 24,000.00 19246 05/22/19 McKee Utility Contractors, Inc $ 8,350.00 19246 05/22/19 McKee Utility Contractors, Inc $ 49,407.00 Police Department (CIP) 19254 05/30/19 Pogue Construction Co., LP $ 287,200.52 CMAR Services for Police Station and Dispatch Facility Roll to pay final invoice. Engineering (CIP) 19256 05/30/19 Stantec Consulting Services $ 1,600.00 PSA Traffic Signal Design at Teel Parkway and Fishtrap Road Project 1928-TR Roll to pay final invoice. 19256 05/30/19 Stantec Consulting Services $ 4,872.00 Police Department (CIP) 19257 05/30/19 Alliance Geotechnical Group $ 10,920.00 Geotechnical services for Police Station and Dispatch Facility Roll forward to close-out project. 19257 05/30/19 Alliance Geotechnical Group $ 3,077.75 19257 05/30/19 Alliance Geotechnical Group $ 9,335.00 19257 05/30/19 Alliance Geotechnical Group $ 10,279.65 19257 05/30/19 Alliance Geotechnical Group $ 15,862.60 19257 05/30/19 Alliance Geotechnical Group $ 14,480.00 Engineering (CIP) 19268 06/06/19 Teague Nall and Perkins Inc $ 19,200.00 PSA Improvements to Fishtrap Road (Segments 1 & 4) and Schematic Design of Fistrap Road (Elementary to DNT) Project 1923 ST Project in progress. Segment 1 complete; Segment 4 Design 95% complete. 19268 06/06/19 Teague Nall and Perkins Inc $ 8,500.00 19268 06/06/19 Teague Nall and Perkins Inc $ 15,000.00 19268 06/06/19 Teague Nall and Perkins Inc $ 23,000.00 19268 06/06/19 Teague Nall and Perkins Inc $ 1,500.00 Streets 19278 06/21/19 DDM Construction Corporation $ 15,201.30 Bid No. 2019-49-B East Fifth Street, North Street, Lanes Street, and Related Water Lines Roll forward to close-out project. 19278 06/21/19 DDM Construction Corporation $ 4,190.00 19278 06/21/19 DDM Construction Corporation $ 11,040.90 19278 06/21/19 DDM Construction Corporation $ 4,190.00 Ordinance No. 2021-03, Page 6 Exhibit B Parks Admin (Grants) 19293 07/22/19 Blais & Associates, Inc. $ 740.00 Grant Management Services for Texas Parks and Wildlife Department Non -Urban Outdoor Recreation Grant - Whitley Place Park Trail Extension and Amenities Project in progress. Estimated completion Winter 2021. 19293 07/22/19 Blais & Associates, Inc. $ 935.00 19293 07/22/19 Blais & Associates, Inc. $ 1,260.00 19293 07/22/19 Blais & Associates, Inc. $ 3,360.00 19293 07/22/19 Blais & Associates, Inc. $ 840.00 19293 07/22/19 Blais & Associates, Inc. $ 150.00 Parks Admin (CIP) 19301 07/25/19 HalffAssociates $ 1,512.50 PSA Citywide Trails Master Plan Project 1910- PK Project in progress. 95 % complete. 19301 07/25/19 Halff Associates $ 62.50 19301 07/25/19 Halff Associates $ 1,019.40 Engineering 19302 07/25/19 RLK Engineering, Inc. $ 1,200.00 PSA Coit Road at US 380 Turn Lane Project Roll forward and re-establish under US 380 Coit Road/Right Turn Lane Proj 19302 07/25/19 RLK Engineering, Inc. $ 400.00 Engineering (CIP) 19313 08/21/19 Freese & Nichols $ 21,738.48 PSA Lower Pressure Plane Pump Station and Pipeline Phase 2 Project 1501-WA Project in progress. Estimated completion Summer 2023. 19313 08/21/19 Freese & Nichols $ 147,900.00 19313 08/21/19 Freese & Nichols $ 46,900.00 19313 08/21/19 Freese & Nichols $ 193,400.00 19313 08/21/19 Freese & Nichols $ 32,317.19 19313 08/21/19 Freese & Nichols $ 34,100.00 19313 08/21/19 Freese & Nichols $ 20,300.00 19313 08/21/19 Freese & Nichols $ 5,179.37 19313 08/21/19 Freese & Nichols $ 24,841.35 Engineering (CIP) 19330 09/13/19 Roadway Solutions Inc. $ 1,445.34 Bid No. 2019-59-B Traffic Signal Installation: Colt Road at E. First Street Roll to pay 2021 invoice (final). 19330 09/13/19 Roadway Solutions Inc. $ 18,054.66 Police Department (CIP) 20048 10/25/19 Motorola Solutions, Inc. $ 219,093.00 Communications equipment for new Police Station and Dispatch Facility Roll to pay 2021 invoice (final). 20048 10/25/19 Motorola Solutions, Inc. $ 25,937.00 20048 10/25/19 Motorola Solutions, Inc. $ 13,011.00 Police Department (CIP) 20090 11/06/19 Engineered Air Balance Co, Inc $ 4,000.00 Commissioning services of HVAC, service hot water, and lighting controls stems Roll forward to complete services. (new Police Station and Dispatch Facility) Public Works 20146 12/19/19 Aclara Technologies LLC $ 20,000.00 Aclara ACE Software Set -Up and Integration Project in progress. ACE consumer engagement portal set to go live in Winter 2021. Currently upgrading customer meters that are not read hourly and project will be completed. 20146 12/19/19 Aclara Technologies LLC $ 3,500.00 20146 12/19/19 Aclara Technologies LLC $ 5,000.00 20146 12/19/19 Aclara Technologies LLC $ 10,000.00 20146 12/19/19 Aclara Technologies LLC $ 10,400.00 20146 12/19/19 Aclara Technologies LLC $ 800.00 20146 12/19/19 Aclara Technologies LLC $ 4,000.00 20146 12/19/19 Aclara Technologies LLC $ 1,200.00 Engineering (CIP) 20172 01/24/20 Stantec Consulting Services $ 5,150.00 PSA Traffic Signal Design at Coit Road and Richland Blvd Project #2005-TR Project in progress. Estimated completion Spring 2021. 20172 01/24/20 Stantec Consulting Services $ 1,600.00 Parks Admin (CIP) 20174 01/28/20 Studio 13 Design Group, PLLC $ 900.00 PSA Whitley Place Trail Powerline Easement Project #1926-PK Project in progress. Estimated completion Winter 2021. 20174 01/28/20 Studio 13 Design Group, PLLC $ 50.00 20174 01/28/20 Studio 13 Design Group, PLLC $ 3,725.00 20174 01/28/20 Studio 13 Design Group, PLLC $ 50.00 Police Department (CIP) 20184 02/13/20 Joe Goddard Enterprises LLC $ 4,000.00 Installation of new antenna at Police Station and Dispatch Facility Roll to pay 2021 invoice (final). Engineering (CIP) 20186 02/14/20 Mario Sinacola & Sons Excavate $ 5,825.55 CSP No. 2020-30-B Fishtrap Road and Teel Parkway Intersection Improvements Project in progress. Project 98 % complete. Engineering (CIP) 20191 02/20/20 Teague Nall and Perkins Inc $ 24,000.00 PSA Improvements to Fistrap Road from Stuber Elementary to DINT Project #2012-ST Project in progress. Estimated completion Fall 2022. 20191 02/20/20 Teague Nall and Perkins Inc $ 29,375.00 20191 02/20/20 Teague Nall and Perkins Inc $ 540.00 20191 02/20/20 Teague Nall and Perkins Inc $ 383,400.00 20191 02/20/20 Teague Nall and Perkins Inc $ 7,500.00 20191 02/20/20 Teague Nall and Perkins Inc $ 35,000.00 Engineering (CIP) 20192 02/20/20 Teague Nall and Perkins Inc $ 29,000.00 PSA Improvements to 1st Street from Coit Rd. to Custer Rd. Project 92014-ST) Project in progress. Estimated 75% complete. 20192 02/20/20 Teague Nall and Perkins Inc $ 32,025.00 20192 02/20/20 Teague Nall and Perkins Inc $ 2,000.00 20192 02/20/20 Teague Nall and Perkins Inc $ 442,750.00 20192 02/20/20 Teague Nall and Perkins Inc $ 45,000.00 20192 02/20/20 Teague Nall and Perkins Inc $ 27,000.00 Public Works 20198 02/26/20 Core & Main LP $ 94,441.30 Blanket PO for Meter Purchases Due to shipping delays, items received after October 1 st. Roll to pay final invoices. Engineering (CIP) 20202 03/05/20 City of Frisco $ 4,505.00 Median Maintenance & Improvements on US Highway 380 from Lovers Lane to Custer Road Roll to pay 2021 invoice (final). 20202 03/05/20 City of Frisco $ 287,053.68 Ordinance No. 2021-03, Page 7 Exhibit B Police Department CIP 20204 03/05/20 Promaxima Manufacturing, LLC $ 418.00 Public Safety Complex FFE Roll to pay 2021 invoice (final). Engineering (CIP) 20205 03/06/20 Maldonado -Burkett, LLP $ 3,140.00 PSA Traffic Signal Design at Fishtrap Road and Gee Road Project #2004-TR Project in progress. Estimated completion Spring 2021. 20205 03/06/20 Maldonado -Burkett, LLP $ 1,685.00 20205 03/06/20 Maldonado -Burkett, LLP $ 500.00 Police Department (Grants) 20213 03/17/20 Blais & Associates, Inc. $ 952.43 Professional Services JAG Grant Application Approval Grant awarded October 2020. Roll to pay 2021 invoice (final). Parks Admin (CIP) 20220 03/20/20 Central North Construction LLC $ 43,420.83 Turf Irrigation System - Add 28 spray zones and mainline Project completed. Roll to pay 2021 invoice (final). 20220 03/20/20 Central North Construction LLC $ 2,400.00 20220 03/20/20 Central North Construction LLC $ 3,114.10 Public Works 20223 03/20/20 Control Specialist Services $ 10,732.50 Inspection of HSP Units 1, 2, and 3 Custer. Pump 1 completed; Pumps 2 & 3 in progress. 20223 03/20/20 Control Specialist Services $ 3,813.50 Finance 20226 03/26/20 Sciens, LLC $ 19,300.00 ERP System Selection Consultant Project in progress. Selection of software underway. Public Works CIP 20241 04/16/20 DHS Automation $ 11,300.00 Water Supply Line Phase I Project completed. Roll to pay 2021 invoice (final). Parks Admin (CIP) 20246 05/01/20 Schrickel, Rollins and $ 22,490.00 PSA Hays Park Project 1802-PK Project in progress. Estimated completion Spring 2021. 20246 05/01/20 Schrickel, Rollins and $ 250.00 20246 05/01/20 Schrickel, Rollins and $ 750.00 20246 05/01/20 Schrickel, Rollins and $ 1,500.00 Engineering (CIP) 20253 05/11/20 McMahon Contracting LP $ 1,035,259.10 Bid No. 2020-41-B Victory Way Project Project in progress. Estimated completion Winter 2021. 20253 05/11/20 McMahon Contracting LP $ 22,174.56 Engineering (CIP) 20254 05/11/20 Durable Specialties, Inc $ 40,820.00 CSP No. 2020-54-B Fishtrap Road and Teel Parkway Traffic Signal Project completed. Roll to pay 2021 invoice (final). 20254 05/11/20 Durable Specialties, Inc $ 3,365.00 Police Department (CIP) 20255 05/11/20 Crosspoint Communications, Inc $ 157.97 Communications equipment for new Police Station and Dispatch Facility Project completed. Roll to pay 2021 invoice (final). 20255 05/11/20 Crosspoint Communications, Inc $ 534.00 20255 05/11/20 Crosspoint Communications, Inc $ 42.85 20255 05/11/20 Crosspoint Communications, Inc $ 25.65 20255 05/11/20 Crosspoint Communications, Inc $ 788.00 20255 05/11/20 Crosspoint Communications, Inc $ 34.64 20255 05/11/20 Crosspoint Communications, Inc $ 34.64 20255 05/11/20 Crosspoint Communications, Inc $ 50.30 20255 05/11/20 Crosspoint Communications, Inc $ 15.16 20255 05/11/20 Crosspoint Communications, Inc $ 3.10 20255 05/11/20 Crosspoint Communications, Inc $ 241.41 20255 05/11/20 Crosspoint Communications, Inc $ 6,177.43 Engineering (CIP) 20259 05/20/20 Kimle -Horn and Associates $ 500.00 PSA West Prosper Roads, Segment A Gee Road Landscape Architecture Project #2020-ST Project in progress. Estimated completion Winter 2021. 20259 05/20/20 Kimle -Horn and Associates $ 555.00 20259 05/20/20 Kimle -Horn and Associates $ 1,400.00 20259 05/20/20 Kimle -Horn and Associates $ 4,000.00 20259 05/20/20 Kimley-Horn and Associates $ 700.00 Engineering (CIP) 20264 05/28/20 Hayden Consultants, Inc $ 8,495.00 PSA Teel (US 380 Intersection Improvements) Project #2013-ST Project in progress. Design 60% complete. 20264 05/28/20 Hayden Consultants, Inc $ 26,254.00 20264 05/28/20 Hayden Consultants, Inc $ 17,020.00 20264 05/28/20 Hayden Consultants, Inc $ 400.00 20264 05/28/20 Hayden Consultants, Inc $ 350.00 20264 05/28/20 Hayden Consultants, Inc $ 800.00 20264 05/28/20 Hayden Consultants, Inc $ 448.08 20264 05/28/20 Hayden Consultants, Inc $ 250.00 Engineering (CIP) 20271 06/18/20 TDC2, LLC $ 72,719.60 CSP No. 2020-39-B Underground Fiber Optic Cable Installation Project completed. Roll to pay 2021 invoice (final). Ordinance No. 2021-03, Page 8 Exhibit B Engineering (CIP) 20272 06/19/20 Garver, LLC $ 225,516.28 PSA First Street from Dallas North Tollway to Coleman Street Project #1512-ST Project in progress. Design 70% complete. 20272 06/19/20 Garver, LLC $ 51,687.00 20272 06/19/20 Garver, LLC $ 4,117.92 20272 06/19/20 Garver, LLC $ 11,171.00 20272 06/19/20 Garver, LLC $ 30,752.00 20272 06/19/20 Garver, LLC $ 60,663.00 20272 06/19/20 Garver, LLC $ 5,924.00 20272 06/19/20 Garver, LLC $ 3,898.00 20272 06/19/20 Garver, LLC $ 31,056.00 20272 06/19/20 Garver, LLC $ 20,690.00 20272 06/19/20 Garver, LLC $ 38,976.00 20272 06/19/20 Garver, LLC $ 32,256.00 20272 06/19/20 Garver, LLC $ 8,120.00 20272 06/19/20 Garver, LLC $ 15,680.00 20272 06/19/20 Garver, LLC $ 2,000.00 20272 06/19/20 Garver, LLC $ 2,500.00 Police Department 20274 06/19/20 GT Distributors, Inc. $ 1,865.88 New hire rifles and related equipment. Shipping was delayed. Order is now complete. Roll to pay 2021 invoice (final). Police Department 20276 06/19/20 GT Distributors, Inc. $ 932.94 SRT rifles and related equipment. Shipping was delayed. Roll to pay 2021 invoice, with two items still outstanding. 20276 06/19/20 GT Distributors, Inc. $ 77.92 20276 06/19/20 GT Distributors, Inc. $ 161.12 Engineering 20278 06/22/20 Lee Engineering, LLC $ 13,566.98 PSA On Call Traffic Engineering Services Project Project is 50 % complete. Parks Admin (CIP) 20281 06/23/20 Dunaway Associates, LP $ 1,710.00 PSA Pecan Grove Park Phase 2 Project #2015- PK Project in progress. Estimated completion Winter 2021. 20281 06/23/20 Dunaway Associates, LP $ 11,700.00 20281 06/23/20 Dunaway Associates, LP $ 21,060.00 20281 06/23/20 Dunaway Associates, LP $ 700.00 20281 06/23/20 Dunaway Associates, LP $ 3,980.00 20281 06/23/20 Dunaway Associates, LP $ 3,000.00 20281 06/23/20 Dunaway Associates, LP $ 1,000.00 Engineering (CIP) 20282 06/24/20 Consolidated Traffic Controls $ 9,597.00 Purchase of traffic signal equipment for Temporary Traffic Signal at Fishtrap & Gee Road and Permanent Traffic Signal at Colt Road & Richland Blvd. Order completed. Roll to pay 2021 invoice (final). 20282 06/24/20 Consolidated Traffic Controls $ 12,468.00 20282 06/24/20 Consolidated Traffic Controls $ 14,288.00 20282 06/24/20 Consolidated Traffic Controls $ 1,888.00 20282 06/24/20 Consolidated Traffic Controls $ 180.00 20282 06/24/20 Consolidated Traffic Controls $ 7,144.00 Engineering (CIP) 20283 06/25/20 Consolidated Traffic Controls $ 13,277.00 Purchase of traffic signal equipment for Temporary Traffic Signal at Fishtrap & Gee Road and Permanent Traffic Signal at Coit Road & Richland Blvd. Order completed. Roll to pay 2021 invoice (final). 20283 06/25/20 Consolidated Traffic Controls $ 456.00 20283 06/25/20 Consolidated Traffic Controls $ 24,816.00 20283 06/25/20 Consolidated Traffic Controls $ 51,204.00 20283 06/25/20 Consolidated Traffic Controls $ 11,208.00 20283 06/25/20 Consolidated Traffic Controls $ 520.00 20283 06/25/20 Consolidated Traffic Controls $ 104.00 20283 06/25/20 Consolidated Traffic Controls $ 764.00 20283 06/25/20 Consolidated Traffic Controls $ 1,666.65 20283 06/25/20 Consolidated Traffic Controls $ 356.00 Engineering (CIP) 20284 06/25/20 Ratliff Hardscape, Ltd $ 7,265.63 CSP No. 2020-58-B Decorative Monument Signs - Prosper Trail at Coit Road Project completed. Roll to pay 2021 invoice (final). Town Manager's Office 20287 07/06/20 Ce tara, LLC $ 2,400.00 Lean Training/Coaching Training will be completed in 2021. Roll forward per Chuck. 20287 07/06/20 Ce tara, LLC $ 2,400.00 20287 07/06/20 Ce tara, LLC $ 1,000.00 20287 07/06/20 Ce tara, LLC $ 1,000.00 Engineering 20289 07/07/20 Accelerated Critical Path, Inc $ 117,517.88 1613-DR Old Town Drainage 1718-DR Old Town Regional Retention (Broadway Design & Construction) Projects in progress. 1613-DR Construction 75% complete. 1718-DR Construction 75 % complete. 20289 07/07/20 Accelerated Critical Path, Inc $ 334,595.00 20289 07/07/20 Accelerated Critical Path, Inc $ 92,699.60 20289 07/07/20 Accelerated Critical Path, Inc $ 206,824.60 20289 07/07/20 Accelerated Critical Path, Inc $ 7,300.40 20289 07/07/20 Accelerated Critical Path, Inc $ 1,761.00 Ordinance No. 2021-03, Page 9 Exhibit B Purchasing (CARES) 20290 07/13/20 Office Depot, Inc. $ 1,282.78 CARES Act 35-36: Reconfiguration of Court and UB areas for social distancing. Order completed. Roll to pay 2021 invoice (final). Parks Admin (CIP) 20294 07/14/20 Ratliff Hardscape, Ltd $ 413,921.78 CSP No. 2020-34-B Whitley Place Trail Extension Project in progress. Estimated completion Winter 2021. Fire Department 20305 07/23/20 DronesPlus Dallas $ 2,992.50 Purchase of drone and related equipment. Order completed. Roll to pay 2021 invoice (final). 20305 07/23/20 DronesPlus Dallas $ 359.10 20305 07/23/20 DronesPlus Dallas $ 94.05 20305 07/23/20 DronesPlus Dallas $ 711.55 Engineering (Grants) 20311 08/03/20 Blais & Associates, Inc. $ 14,080.00 Economic Development Construction Grant PWEAA FY 2020 Project in progress. Awaiting grant award letter. Roll to pay 2021 invoice. Parks Admin CIP 20320 08/05/20 S iars Engineering, Inc. $ 2,800.00 Too ra hic Survey of Has Park Services completed. Roll to pay 2021 invoice (final). Public Works 20322 08/07/20 Roadway Solutions Inc. $ 4,200.00 Boring and installation services. Project completed. Roll to pay 2021 invoice (final). 20322 08/07/20 Roadway Solutions Inc. $ 1,225.00 20322 08/07/20 Roadway Solutions Inc. $ 550.00 Dispatch 20330 08/11/20 Motorola Solutions, Inc. $ 1,420.76 Astro System Essentials Monthly Fee This PO was issued for previous years' payments. No receipts to date. Department to turn in invoices in 2021 for payment. 20330 08/11/20 Motorola Solutions, Inc. $ 1,420.76 20330 08/11/20 Motorola Solutions, Inc. $ 1,420.76 20330 08/11/20 Motorola Solutions, Inc. $ 1,420.76 20330 08/11/20 Motorola Solutions, Inc. $ 1,420.76 20330 08/11/20 Motorola Solutions, Inc. $ 1,420.76 20330 08/11/20 Motorola Solutions, Inc. $ 1,420.76 20330 08/11/20 Motorola Solutions, Inc. $ 1,420.76 20330 08/11/20 Motorola Solutions, Inc. $ 1,420.76 20330 08/11/20 Motorola Solutions, Inc. $ 1,420.76 20330 08/11/20 Motorola Solutions, Inc. $ 1,420.76 20330 08/11/20 Motorola Solutions, Inc. $ 1,420.78 Human Resources 20334 08/24/20 Justice Research Consultants $ 2,875.00 Employee and Recruiting Assessment Project in progress. Estimated completion Winter 2021. 20334 08/24/20 Justice Research Consultants $ 2,875.00 Engineering (CIP) 20336 08/24/20 Wilson Contractor Serv, LLC $ 3,454,363.33 Bid No. 2020-62-B Custer Road Pump Station Meter Vault Relocation Project Project in progress. Estimated completion Spring 2021. 20336 08/24/21 Wilson Contractor Serv, LLC $ 20,036.00 Engineering (CIP) 20340 08/26/20 Mario Sinacola & Sons Excavate $ 5,236,331.05 Bid No. 2020-75-B Prosper Trail - Coit Rd to Custer Rd 2-Lanes CIP No. 2008-ST Project in progress. Estimated completion Summer 2021. Purchasing (CARES) 20341 08/26/20 Pogue Construction Co., LP $ 451,239.58 CARES Act 25-27: Third floor finish -out for social distancing. Project completed. Roll to pay 2021 invoice (final). Purchasing (CARES) 20342 08/26/20 Vanguard Modular Building $ 58,731.00 CARES Act 48: Public Works modular building for social distancing Project completed. Roll to pay 2021 invoice (final). 20342 08/26/20 Vanguard Modular Building $ 12,878.00 20342 08/26/20 Vanguard Modular Building $ 12,996.00 20342 08/26/20 Vanguard Modular Building $ 2,272.00 Library 20343 08/26/20 Library Interiors of Texas LLC $ 3,624.00 Construct book storage area for Library Project completed. Roll to pay 2021 invoice (final). 20343 08/26/20 Library Interiors of Texas LLC $ 906.00 20343 08/26/20 Library Interiors of Texas LLC $ 1,432.50 Purchasing (CARES) 20346 08/28/20 Office Depot, Inc. $ 17,566.05 CARES Act 25: IT furniture for social distancing Project completed. Roll to pay 2021 invoice (final). 20346 08/28/20 Office Depot, Inc. $ 1,166.34 Purchasing (CARES) 20347 08/28/20 Office Depot, Inc. $ 20,623.56 CARES Act 26: Finance/HR furniture for social distancing Project completed. Roll to pay 2021 invoice (final). 20347 08/28/20 Office Depot, Inc. $ 1,166.34 Purchasing (CARES) 20348 08/28/20 Office Depot, Inc. $ 14,155.24 CARES Act 27: Communications furniture for social distancing Project completed. Roll to pay 2021 invoice (final). 20348 08/28/20 Office Depot, Inc. $ 1,555.12 Police Department 20350 09/01/20 Applied Concepts, inc. $ 3,810.00 Radar and related equipment Order completed. Roll to pay 2021 invoice (final). 20350 09/01/20 Applied Concepts, inc. $ 17.50 Purchasing (CARES) 20359 09/10/20 Integrated Com uter Systems $ 6,500.00 CARES Act 29: Computer equipment for EOC Order completed. Roll to pay 2021 invoice (final). 20359 09/10/20 Integrated Computer Systems $ 53,200.00 20359 09/10/20 Integrated Computer Systems $ 3,120.00 20359 09/10/20 Integrated Computer Systems $ 900.00 20359 09/10/20 Integrated Computer Systems $ 30,000.00 Dispatch 20366 09/15/20 Vista Com $ 10,208.00 Eventide Recorder Upgrade Order completed. Roll to pay 2021 invoice (final). 20366 09/15/20 Vista Com $ 3,350.00 20366 09/15/20 Vista Com $ 1,475.00 20366 09/15/20 Vista Com $ 2,246.00 20366 09/15/20 Vista Com $ 2,526.00 20366 09/15/20 Vista Com $ 1,329.00 20366 09/15/20 Vista Com $ 500.00 Ordinance No. 2021-03, Page 10 Exhibit B Police Department (CIP) 20367 09/16/20 Air Science USA LLC $ 7,598.00 Public Safety Complex Project in progress. Roll to pay 2021 invoice (final). 20367 09/16/20 Air Science USA LLC $ 812.00 Police Department (CIP) 20368 09/16/20 Integrated Com uter Systems $ 3,910.00 Property and Evidence Software Project in progress. Roll to pay 2021 invoice (final). 20368 09/16/20 Integrated Computer Systems $ 850.00 20368 09/16/20 Integrated Computer Systems $ 195.00 Police Department (CIP) 20371 09/18/20 Move Solutions, Ltd $ 623.00 Moving services to relocate PD personnel and equipment Services completed. Roll to pay 2021 invoice (final). 20371 09/18/20 Move Solutions, Ltd $ 590.00 20371 09/18/20 Move Solutions, Ltd $ 3,645.00 20371 09/18/20 Move Solutions, Ltd $ 721.50 20371 09/18/20 Move Solutions, Ltd $ 187.00 Engineering (CIP) 20375 09/29/20 Garver, LLC $ 24,867.00 PSA Frontier Park/Lakes of Prosper Drainage Channel Project #2003-DR Project in progress. Awarded and PO issued September 2020. 20375 09/29/20 Garver, LLC $ 38,940.00 20375 09/29/20 Garver, LLC $ 13,050.00 20375 09/29/20 Garver, LLC $ 12,529.00 20375 09/29/20 Garver, LLC $ 1,778.00 20375 09/29/20 Garver, LLC $ 3,747.00 20375 09/29/20 Garver, LLC $ 2,426.00 20375 09/29/20 Garver, LLC $ 2,663.00 TOTAL 2019-2020 ENCUMBRANCES $ 20,140,001.24 OPERATING ACCOUNTS 100-5210-10-02 $ 1,555.12 100-5210-10-03 $ 1,166.34 100-5210-10-05 $ 1,166.34 100-5212-50-05 $ 5,962.50 100-5214-20-01 $ 1,171.98 100-5410-10-99 $ 952.43 100-5410-60-01 $ 7,285.00 100-5410-98-01 $ 13,566.98 100-5410-98-01-1831-ST $ 4,352.50 100-5410-98-01-1832-ST $ 5,397.49 100-5480-10-99 $ 19,300.00 100-5480-20-05 $ 17,049.14 100-5480-50-01 $ 11,735.40 100-5620-20-01 $ 5,693.38 100-6140-20-05 $ 20,634.00 100-7000-10-99 $ 6,275.00 TOTAL GENERAL $ 123,263.60 200-5419-10-08 $ 16,400.00 200-5480-10-08 $ 38,500.00 200-5480-50-02 $ 10,732.50 200-5480-50-03 $ 3,813.50 200-5545-50-02 $ 94,441.30 200-7000-10-99 $ 20,355.00 TOTAL WATERISEWER $ 184,242.30 450-5410-98-02-2003-DR $ 100,000.00 TOTAL STORM DRAINAGE UTILITY $ 100,000.00 670-5206-10-00 $ 4,157.20 TOTAL FIRE SPECIAL REVENUE DONATIONS $ 4,157.20 TOTAL OPERATING ACCOUNTS $ 411,663.10 CARES ACT FUND 675-5220-10-00-2019-EM $ 53,627.63 675-5418-10-00-2019-EM $ 33,720.00 675-6110-10-00-2019-EM $ 538,116.58 TOTAL CARES ACT $ 625,464.21 TOTAL CARES ACT $ 625,464.21 Ordinance No. 2021-03, Page 11 Exhibit B MULTI -YEAR ACCOUNTS 620-5410-60-00-1910-PK $ 2,594.40 620-6610-60-00-1801-PK $ 425,421.78 620-6610-60-00-1802-PK $ 28,073.57 TOTAL PARK IMPROVEMENTS FEES $ 456,089.75 630-6610-50-00-1715-WA $ 244.02 630-6610-50-00-1716-WA $ 54,418.72 TOTAL WATER IMPACT FEES $ 54,662.74 660-6610-50-00-1710-ST $ 364,754.50 660-6610-50-00-2005-TR $ 111,121.65 TOTAL E THOROUGHFARE IMPACT FEES $ 475 876.15 680-5410-50-00-2013-ST $ 54,017.08 680-6610-50-00-1708-ST $ 8,457.92 680-6610-50-00-1928-TR $ 40,820.00 680-6610-50-00-2004-TR $ 50,890.00 TOTAL W THOROUGHFARE IMPACT FEES $ 154,185.00 750-5410-10-00-1512-ST $ 545,007.20 750-5410-10-00-1813-PK $ 14,350.00 750-5410-10-00-1823-ST $ 8,887.14 750-5410-10-00-1824-ST $ 4,564.33 750-5410-10-00-1923-ST $ 67,200.00 750-5410-10-00-1928-TR $ 6,472.00 750-5410-10-00-2012-ST $ 479,815.00 750-5410-10-00-2014-ST $ 577,775.00 750-5410-10-00-2015-PK $ 43,150.00 750-6610-10-00-1507-ST $ 7,155.00 750-6610-10-00-1511-ST $ 100,252.35 750-6610-10-00-1713-FC $ 1,079,905.02 750-6610-10-00-1801-PK $ 2,125.00 750-6610-10-00-1818-PK $ 48,934.93 750-6610-10-00-1823-ST $ 1,057,433.66 750-6610-10-00-1824-ST $ 5,825.55 750-6610-10-00-1827-TR $ 291,558.68 750-6610-10-00-1905-FC $ 287,200.52 750-6610-10-00-1906-FC $ 284,519.25 750-6610-10-00-1909-TR $ 19,500.00 750-6610-10-00-1926-PK $ 4,725.00 750-6610-10-00-1928-TR $ 3,365.00 750-6610-10-00-2008-ST $ 5,246,879.08 TOTAL CAPITAL PROJECTS $ 10,186,599.71 760-6610-10-00-1501-WA $ 526,676.39 760-6610-10-00-1613-DR $ 328,242.48 760-6610-10-00-1715-WA $ 738,535.00 760-6610-10-00-1716-WA $ 2,208,718.73 760-6610-10-00-1718-DR $ 350,356.00 760-6610-10-00-1902-WA $ 3,522,931.98 760-6610-10-00-1903-WW $ 100,000.00 TOTAL CAPITAL PROJECTS - WATER/SEWER $ 7,775,460.58 TOTAL MULTI -YEAR ACCOUNTS $ 19,102,873.93 GRAND TOTAL $ 20,140,001.24 Ordinance No. 2021-03, Page 12