Loading...
2020-71 - OAMENDED BUDGET 2019-2020 AS ORIGINALLY TRANSMITTED CHANGES FINAL PROPOSED GENERAL FUND Administration 5,139,289$ 5,376,987$ 221,407$ 5,598,394$ Police Services 5,631,207 5,997,484 - 5,997,484 Fire Services 7,676,989 7,713,465 - 7,713,465 Public Works 3,213,736 3,272,379 - 3,272,379 Community Services 4,736,198 4,605,459 - 4,605,459 Development Services 3,238,239 3,371,304 - 3,371,304 Engineering 1,839,369 2,031,806 - 2,031,806 31,475,027$ 32,368,884$ 221,407$ 32,590,291$ WATER/SEWER FUND Administration 2,380,374$ 2,615,646$ -$ 2,615,646$ Debt Service 3,930,237 3,701,269 - 3,701,269 Water Purchases 5,590,642 6,681,709 - 6,681,709 Public Works 14,178,726 11,410,264 - 11,410,264 26,079,979$ 24,408,888$ -$ 24,408,888$ DEBT SERVICE (I&S)7,022,740$ 7,699,741$ -$ 7,699,741$ TIRZ # 1 1,766,715 2,723,028 - 2,723,028 TIRZ # 2 342,549 13,007 - 13,007 CRIME CONTROL AND PREVENTION SPECIAL PURPOSE DISTRICT 1,327,155 1,425,708 - 1,425,708 FIRE CONTROL, PREVENTION, AND EMERGENCY MEDICAL SERVICES SPECIAL PURPOSE DISTRICT 1,326,274 1,490,812 - 1,490,812 PARKS IMPROVEMENT AND DEDICATION FEES 703,700 1,735,000 - 1,735,000 IMPACT FEES 7,920,426 7,842,500 - 7,842,500 SPECIAL REVENUE 1,518,394 271,246 - 271,246 STORM DRAINAGE 643,030 548,269 - 548,269 VERF 1,420,442 1,397,585 - 1,397,585 HEALTH INSURANCE TRUST 3,115,741 3,421,811 - 3,421,811 27,107,166$ 28,568,707$ -$ 28,568,707$ 84,662,172$ 85,346,479$ 221,407$ 85,567,886$ Unspent project funds for Capital Projects, Park Improvement and Dedication Fees, and Impact Fees as of September 30, 2020, will automatically be re-apportioned to their respective projects for FY 2020-2021. Funds encumbered for the VERF will also be re-apportioned for FY 2020-2021. GRAND TOTAL EXHIBIT A General Fund Total Water/Sewer Total Other Funds Total PROPOSED BUDGET 2020-2021 Ordinance No. 2020-71, Page 3 TotalIssued Debt Unissued Debt Unissued Debt IssuedPrior Years 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030 CostAuthorized Authorized Unauthorized 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030011836-STDNT Southbound Frontage Road17,000,00017,000,00017,000,000X01021511-STProsper Trail (Kroger - Coit): (Design)305,000305,000305,000A02031511-STProsper Trail (Kroger - Coit): (Construction)4,564,0554,564,0554,465,846A,D,K98,20903041512-STFirst Street (DNT - Coleman): (Design)2,786,5672,786,5672,439,915A,D346,65204051507-STWest Prosper Road Improvements, Segment D: (Construction)3,404,6183,404,6183,404,61805061708-STE-W Collector (Cook Lane - DNT); design done w/ Cook Lane1,455,000 1,455,0001,375,000A80,00006071820-STFirst Street/DNT Intersection Improvements: (Design)137,000137,000137,000D07081820-STFirst Street/DNT Intersection Improvements: (Construction)1,250,000 1,250,0001,250,000A08091823-STVictory Way (Coleman - Frontier) - 2 lanes: (Design)300,000300,000250,000D50,00009101823-STVictory Way (Coleman - Frontier) - 2 lanes: (Construction)2,200,000 2,200,0002,200,00010111709-STProsper Trail (Coit - Custer) - 4 lanes: (Design)810,000 810,000810,000A11122008-STProsper Trail (Coit - Custer) - 2 lanes: (Construction)6,300,000 6,300,0001,250,000D300,0004,750,000 4,750,00012131825-STColeman (Rogers MS - Turn Lane): (Design & Construction)375,000 375,000375,000D13141819-STColeman Street (at Prosper HS): (Design & Construction)790,000 790,000790,000C, K14151923-STFishtrap (Segments 1, 4); (Elem to DNT) schematic: (Design)778,900 778,900778,900D15162009-STFishtrap, Segment 1 (Teel - Middle School): (Construction)1,470,000 1,470,000280,0001,190,000 1,190,00016171932-STCoit Road and US 380 (SB Right Turn Lane): (Design)6,300 6,3006,300A,D17181932-STCoit Road and US 380 (SB Right Turn Lane): (Construction)125,000 125,00035,000A90,00018191830-STProsper Trail/DNT Intersection Improvements: (Design)88,00088,00088,000A,D19201830-STProsper Trail/DNT Intersection Improvements: (Construction)2,000,000 2,000,000400,000 1,600,000 1,600,00020211824-STFishtrap (Teel Intersection Improvements): (Design)150,000 150,000150,000D21221824-STFishtrap (Teel Intersection Improvements): (Construction)1,400,000 1,400,0001,400,00022231708-STCook Lane (First - End): (Design)150,000 150,000150,000A23241708-STCook Lane (First - End): (Construction)3,500,000 3,500,000600,000 2,900,000 2,900,00024252014-STFirst Street (Coit - Custer) - 4 lanes: (Design)1,000,000 1,000,0001,000,000 1,000,00025262010-STFishtrap (Teel - Gee Road): (Design)400,000 400,000400,000C26272011-STGee Road (Fishtrap - Windsong Retail): (Design)250,000 250,000250,000C27282012-STFishtrap (Elem - DNT) - 4 lanes: (Design)900,000 900,000300,000A,D,K600,000 600,00028291710-STCoit Road (First - Frontier) - 4 lanes: (Design)1,289,9001,289,9001,289,900A,X29302013-STTeel (US 380 Intersection Improvements): (Design)100,000 100,000100,000A,K30311307-STFrontier Parkway (BNSF Overpass)3,650,000 29,912,49633,562,49627,812,496A,X05,750,0005,750,00031321805-STFM 2478 (US 380 - FM 1461)391,869 57,000,00057,391,86957,391,869A,K,X32331934-STDNT Overpass at US38080,970,000 9,030,000 90,000,00083,970,000D,J,X6,030,0006,030,00033342017-STFishtrap, Segment 4 (Middle - Elem) - 4 lanes: (Construction)2,750,0002,750,0002,750,0002,750,00034351936-STUS 380 (US 377 - Denton County Line)178,105,000178,105,000178,105,000D,X35361938-STFM 1461 (SH 289 - CR 165)175,000 175,000 175,000 45,190,87045,715,87045,715,870A,X36371933-STFishtrap (Segment 2) - PISD reimbursement1,164,0001,164,0001,164,0001,164,00037381937-STDNT Main Lane (US 380 - FM 428)35,000,000 315,000,000350,000,000350,000,000X38140,297,209 267,942,496 45,369,000 175,000 360,190,870 0 0 813,974,575 776,991,096 9,249,4790 27,734,000 12,040,000 8,500,000 7,194,0000000Design9,451,6670000009,451,667Construction27,914,055 32,662,496 1,164,000000061,740,551Design & Construction102,931,487 235,280,000 44,205,000 175,000 360,190,87000 742,782,357Land/Easements0000000 0Funding SourcesTotal Other Issued Debt Unissued Debt Unissued Debt IssuedPrior Years 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030 Cost Sources Authorized Authorized Unauthorized 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030011929-STBNSF Quiet Zone First/Fifth145,000145,000145,000D01021909-TRTraffic Signal - Coit Rd & First Street: (Construction)306,299306,299306,299A,D02031939-TRTraffic Signal - DNT & Frontier: (Collin County)400,000400,000400,000X03041940-TRTraffic Signal - DNT & Prosper Trail: (Collin County)400,000400,000400,000X04051928-TRTraffic Signal - Fishtrap & Teel Parkway: (Design)34,10034,10034,100A05061928-TRTraffic Signal - Fishtrap & Teel Parkway: (Construction)400,000400,000400,000A06072004-TRTraffic Signal - Fishtrap & Gee Road: (Design)50,00050,00050,000A07082004-TRTraffic Signal - Fishtrap & Gee Road: (Construction)250,000250,000250,000A08092007-TRTraffic Signal - SH 289 & Lovers Lane (TIRZ #1)300,000300,000300,000H09102005-TRTraffic Signal - Coit Rd & Richland: (Design)50,00050,00050,000A10112005-TRTraffic Signal - Coit Rd & Richland: (Construction)410,000410,000410,000A11122101-TRTraffic Signal - Fishtrap & Artesia Boulevard: (Design)50,00050,00050,000A,C12132101-TRTraffic Signal - Fishtrap & Artesia Boulevard: (Construction)425,000425,000425,000A,C`13141935-TRTraffic Signal - FM 1385 & Fishtrap: (TxDOT)250,000250,000250,000X1415Traffic Signal - FM 2478 (Custer Rd) & First Street: (TxDOT) 500,000500,000500,000X1516Traffic Signal - First Street & La Cima: (Design) 50,00050,00050,000A1617Traffic Signal - First Street & La Cima: (Construction) 400,000400,000400,000A1718Traffic Signal - First Street & Coleman: (Design)50,00050,00050,000A1819Traffic Signal - First Street & Coleman: (Construction)425,000425,000425,000A192,745,399 725,000 950,000 475,0000004,895,399 4,895,399 0 0 00000000Design134,100 50,000 50,000 50,000000284,100Construction1,511,299 425,000 400,000 425,0000002,761,299Design & Construction1,100,000 250,000 500,00000001,850,000Land/Easements0000000 0General Fund Projects01Summary of Capital Improvement Program - 09/08 FINAL Subtotal Index IndexIndex Funding SourcesOtherSourcesUnissued Debt Schedule Subtotal Traffic ProjectsUnissued Debt ScheduleIndexStreet ProjectsEXHIBIT BOrdinance No. 2020-71, Page 4 Funding SourcesTotal Other Issued Debt Unissued Debt Unissued Debt IssuedPrior Years 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030 Cost Sources Authorized Authorized Unauthorized 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030Neighborhood Park01 Town Hall Open Space Park: (Design) 55,00055,00055,000D0102 Tanners Mill Park: (Construction) 468,000468,000468,000C0203 Star Trail Park #2 (7.5 Acres / No Lights): (Construction) 535,000535,000535,000C0304 Windsong Ranch Park #2 (7.5 Acres / No Lights): (Design) 30,00030,00030,000C0405 Windsong Ranch Park #2 (7.5 Acres / No Lights): (Construction) 230,000 230,000230,000C0506 Lakewood Preserve (22 Acres / Lights): Construction) 423,000 544,500 967,500967,500C06071802-PK Hays Park (2 Acres / No Lights): (Design ) 85,00085,00085,000G07081802-PK Hays Park (2 Acres / No Lights): (Construction) 375,000375,000375,000G0809 Pecan Grove Phase 2 (21.5 Acres / No Lights) (basketball, pavilion, parking, security lighting): (Design) 67,50067,500500G67,0000910 Pecan Grove Phase 2 (21.5 Acres / No Lights) (basketball, pavilion, parking, security lighting): (Construction) 575,000575,000575,000G1011 Prairie Park (6.7 Acres / No Lights) 300,000300,000600,000600,000C11Trails121801-PKWhitley Place H&B Trail Extension: (Design)70,00070,00070,000G12131910-PKHike and Bike Master Plan: (Design)68,00068,00068,000D1314Star Trail H&B Trail Phases 1, 2, 3, and 4: (Construction)200,000200,000200,000C14151926-PKWhitley Place H&B Trail (OH Easement): (Design)10,00010,00010,00015161926-PKWhitley Place H&B Trail (OH Easement): (Construction)270,000270,000270,00016171801-PKWhitley Place H&B Trail Extension: (Construction)680,000680,000500,000G180,0001718Windsong H&B Trail Ph 3C,5,6A, 6B, 7, 8, and 9: (Design)40,00040,00040,000C1819Windsong H&B Trail Ph 3C,5,6A, 6B, 7, 8, and 9: (Construction)1,351,572 435,000 495,0002,281,5722,281,572C19Community Park20Frontier Park Storage: (Design & Construction)147,927147,927147,927D20Medians211723-PKState Highway 289 Gateway Monument474,752474,752474,752D21221818-PKAdditional Turf Irrigation SH 28980,00080,00080,000D22231813-PKSH 289/US 380 Green Ribbon Landscape Irrigation809,250809,250809,250B,D23242018-PKColeman Street Median Landscaping (Talon - Victory): (Design)30,00030,00030,000A24252018-PKColeman Street Median Landscaping (Talon - Victory): (Construction) 320,000320,000320,000A25261922-PKDowntown Monument (Broadway/Preston): (Design)16,000 75,00091,00091,000D26271922-PKDowntown Monument (Broadway/Preston): (Construction)380,000380,000380,000D,K276,461,001 2,684,500 795,00000009,940,501 9,413,501 527,000 0 00000000Design401,500 145,00000000546,500Construction5,911,574 2,539,500 795,00000009,246,074Design & Construction147,927000000147,927Land/Easements0000000 0Funding SourcesTotal Other Issued Debt Unissued Debt Unissued Debt IssuedPrior Years 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030 Cost Sources Authorized Authorized Unauthorized 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030011713-FCPolice Station and Dispatch - Professional Services1,644,6961,644,69631,293D1,613,40301021904-FCPolice Station and Dispatch - Development Costs550,000550,000550,00002031905-FCPolice Station and Dispatch - Construction12,645,80412,645,8041,435,000D11,210,80403041906-FCPolice Station and Dispatch - Furniture, Fixtures, and Equipment 1,165,0001,165,0001,165,000D04052102-FCWestside Radio Tower for Communications500,000500,000500,000500,0000516,005,500 500,0000000016,505,500 2,631,293 13,374,2070 500,0000 500,00000000Design2,194,6960000002,194,696Construction13,810,80400000013,810,804Design & Construction0 500,00000000500,000Land/Easements0000000 0165,509,109 271,851,996 47,114,000 650,000 360,190,87000 845,315,975 793,931,289#REF!23,150,6860 28,234,000 12,040,000 9,000,000 7,194,0000000Design12,181,963 195,000 50,000 50,00000012,476,963Construction49,147,732 35,626,996 2,359,000 425,00000087,558,728Design & Construction104,179,414 236,030,000 44,705,000 175,000 360,190,87000 745,280,284Land/Easements0000000 0##A Impact FeesD General FundG Park Development FundK Escrows##B Grant and Interlocal FundsE Water / Wastewater FundH TIRZ #1X Non-Cash Contributions##C Developer AgreementsF Stormwater Drainage FundJ TIRZ #2Z Other Sources (See Detail)IndexPark ProjectsIndexFacility ProjectsIndex IndexUnissued Debt ScheduleUnissued Debt Schedule02Summary of Capital Improvement Program - 09/08 FINALGeneral Fund Projects Subtotal Grand Total General Fund Description Codes - Other SourcesDesignConstructionDesign & Construction Subtotal EXHIBIT BOrdinance No. 2020-71, Page 5 Funding SourcesTotal Other Issued Debt Unissued Debt Unissued Debt IssuedPrior Years 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030 Cost Sources Authorized Authorized Unauthorized 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030011902-WACuster Road Meter Station and WL Relocations: (Design)359,225359,225359,225E01021902-WACuster Road Meter Station and WL Relocations: (Land/Easements)53,24453,24453,244E02031902-WACuster Road Meter Station and WL Relocations: (Construction)3,454,3633,454,3633,454,363E03041715-WAFishtrap 2.5 MG Elevated Storage Tank: (Design)325,700325,700325,700A04051715-WAFishtrap 2.5 MG Elevated Storage Tank: (Construction)6,108,0006,108,0003,143,000A2,965,00005061716-WALPP Water Line Phase 1a & 1b: (Design)829,850829,850829,850A06071716-WALPP Water Line Phase 1a & 1b: (Construction)10,658,20010,658,200175,000A10,483,20007081716-WALPP Water Line Phase 1 Easement Costs1,691,5001,691,5000A1,691,50008091501-WALPP Pump Station and LPP WL Phase 2: (Design)1,585,1001,585,100277,081A1,308,01909101501-WALPP Pump Station and LPP WL Phase 2: (Construction)15,200,00015,200,0004,000,000A11,200,0005,600,000 5,600,00010111810-WALPP Water Line Phase 2 Easement Costs1,000,0001,000,0001,000,000A11121708-WAE-W Collector (Cook Lane - DNT) Water Line: (Construction)295,775295,775289,750E6,02512131708-WACook Lane (First - End): (Construction)400,000400,000400,000E1314LPP Future Expansion (2026): (Design)1,400,0001,400,0001,400,0001,400,0001415LPP Future Expansion (2026): (Construction)12,600,00012,600,00012,600,00012,600,00015161930-WA Broadway (Parvin-Craig): (Construction) 150,000150,000150,000E1625,910,957 1,000,000 15,200,00000014,000,000 56,110,957 14,457,213 16,453,744 0 25,200,000 0 0 5,600,000 5,600,000 0 0 14,000,000Design3,099,875000001,400,000 4,499,875Construction21,066,3380 15,200,00000012,600,000 48,866,338Design & Construction0000000 0Land/Easements1,744,744 1,000,000000002,744,744Funding SourcesTotal Other Issued Debt Unissued Debt Unissued Debt IssuedPrior Years 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030 Cost Sources Authorized Authorized Unauthorized 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030011903-WWChurch / Parvin Wastewater Reconstruction: (Construction)100,000100,000100,000E01022103-WWDoe Branch Parallel Interceptor (2021): (Design)500,000500,000500,00002032103-WWDoe Branch Parallel Interceptor (2021): (Construction)4,500,0004,500,0001,000,0003,500,0003,500,0000304Doe Branch, Phase 3 WWTP (2025): (Design)1,450,00001,450,0001,450,000E00405Doe Branch, Phase 3 WWTP (2025): (Construction)13,050,00013,050,00013,050,000 13,050,00005100,000 0 5,000,000 14,500,00000019,600,000 3,050,000 0 0 16,550,000 0 0 3,500,000 13,050,000 0 0 0Design0 0 500,000 1,450,0000001,950,000Construction100,000 0 4,500,000 13,050,00000017,650,000Design & Construction0000000 0Land/Easements0000000 0Funding SourcesTotal Other Issued Debt Unissued Debt Unissued Debt IssuedPrior Years 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030 Cost Sources Authorized Authorized Unauthorized 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030011614-DRColeman Street Channel Improvements: (Construction)400,000400,000(0)400,000400,00001021613-DROld Town Drainage - Church & Parvin: (Design)40,00040,00040,000F02031613-DROld Town Drainage - Church & Parvin: (Construction)460,000 215,000675,000460,000215,00003041718-DROld Town Regional Retention - Broadway: (Design)25,00025,00025,000004051718-DROld Town Regional Retention - Broadway: (Construction)616,686616,686616,686215,00005062024-DROld Town Regional Retention Pond #2 - Land Acquisition385,000385,000385,000385,00006072003-DRFrontier Park/Preston Lakes Drainage: (Design)100,000100,000100,000F07082003-DRFrontier Park/Preston Lakes Drainage: (Construction)985,000985,000985,000985,000081,241,686 1,000,000 985,00000003,226,686 140,000 1,101,6860 1,985,0000 1,000,000 985,0000000Design165,000000000165,000Construction1,076,686 615,000 985,00000002,676,686Design & Construction0000000 0Land/Easements0 385,00000000385,00027,252,643 2,000,000 21,185,000 14,500,00000 14,000,000 78,937,643 17,647,213 17,555,4300 43,735,0000 1,000,000 10,085,000 18,650,00000 14,000,000Design3,264,8750 500,000 1,450,00000 1,400,000 6,614,875Construction22,243,024 615,000 20,685,000 13,050,00000 12,600,000 69,193,024Design & Construction0000000 0Land/Easements1,744,744 1,385,000000003,129,744##A Impact FeesD General FundG Park Development FundK Escrows##B Grant and Interlocal FundsE Water / Wastewater FundH TIRZ #1X Non-Cash Contributions##C Developer AgreementsF Stormwater Drainage FundJ TIRZ #2Z Other Sources (See Detail)Unissued Debt Schedule Subtotal Subtotal Index Subtotal Grand Total Enterprise Funds Wastewater ProjectsDrainage ProjectsIndex Unissued Debt ScheduleUnissued Debt ScheduleDesign & ConstructionIndex Water ProjectsDesignConstructionIndex Index Index Description Codes - Other SourcesSummary of Capital Improvement Program - 09/08 FINAL03Enterprise Fund ProjectsEXHIBIT BOrdinance No. 2020-71, Page 6 Funding SourcesTotal Other Issued Debt Unissued Debt Unissued Debt IssuedPrior Years 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030 Cost Sources Authorized Authorized Unauthorized 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024 2024-2025 2025-2030165,509,109 271,851,996 47,114,000 650,000 360,190,870 0 0 845,315,975 793,931,289 23,150,6860 28,234,000 12,040,000 9,000,000 7,194,000000027,252,643 2,000,000 21,185,000 14,500,00000 14,000,000 78,937,643 17,647,213 17,555,4300 43,735,0000 1,000,000 10,085,000 18,650,00000 14,000,000192,761,752 273,851,996 68,299,000 15,150,000 360,190,8700 14,000,000 924,253,618 811,578,502 40,706,1160 71,969,000 12,040,000 10,000,000 17,279,000 18,650,00000 14,000,000Design15,446,838 195,000 550,000 1,500,00000 1,400,000 19,091,838Construction71,390,756 36,241,996 23,044,000 13,475,00000 12,600,000 156,751,752Design & Construction104,179,414 236,030,000 44,705,000 175,000 360,190,87000 745,280,284Land/Easements1,744,744 1,385,000000003,129,744 Enterprise Funds Capital Improvement Program Summary General Fund Summary of Capital Improvement Program - 09/08 FINALCapital Improvement Program Summary04 Grand Total Capital Improvement Program EXHIBIT BOrdinance No. 2020-71, Page 7