Loading...
18-113 - OGeneral Fund Original Budget Current Budget Amended Budget Increase (Decrease) Total Revenues: $ 27,877,145 $ 27,877,145 $ 27,877,145 $ - Total $ 27,877,145 $ 27,877,145 $ 27,877,145 $ - Expenditures: Administration 6,122,012$ 6,122,012$ 6,122,012$ -$ Police Services 4,742,276 4,742,276 4,793,966 51,689.55 Fire Services 7,675,378 7,675,378 7,675,378 - Public Works 3,698,019 3,698,019 3,808,430 110,411.00 Community Services 3,951,808 3,951,808 3,951,808 - Development Services 3,028,688 3,028,688 3,098,212 69,524.00 Engineering 1,236,308 1,236,308 1,257,808 21,500.00 Total $ 30,454,489 $ 30,454,489 $ 30,707,614 253,124.55 Water-Sewer Utility Fund Original Budget Current Budget Amended Budget Increase (Decrease) Total Revenues:20,022,105$ 20,022,105$ 20,022,105$ -$ Total 20,022,105$ 20,022,105$ 20,022,105$ -$ Expenditures: Administration 2,121,521$ 2,121,521$ 2,121,521$ -$ Debt Service 3,493,726$ 3,493,726$ 3,493,726$ -$ Water Purchases 5,349,510$ 5,349,510$ 5,349,510$ -$ Public Works 9,586,605$ 9,586,605$ 9,789,129$ 202,523.93$ Total 20,551,362$ 20,551,362$ 20,753,886$ 202,523.93$ VERF Fund Original Budget Current Budget Amended Budget Increase (Decrease) Total Revenues:1,642,961$ 1,642,961$ 1,642,961$ -$ Total 1,642,961$ 1,642,961$ 1,642,961$ -$ Expenditures: Technology Expenses 85,870$ 85,870$ 85,870$ -$ Equipment Expenses 277,336$ 277,336$ 277,336$ -$ Vehicle Expenses 532,339$ 532,339$ 535,114$ 2,775$ Total 532,339$ 532,339$ 535,114$ 2,775$ Total Revenue -$ Total Expenditures 458,423.48$ Net Effect All Funds (458,423.48)$ EXHIBIT "A" BUDGET AMENDMENT FISCAL YEAR 2018-2019 December 11, 2018 Ordinance No. 18-113, Page 3 Total Issued Debt Unissued Debt Unissued Debt Reimbursement Issued Prior Years 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 Cost Authorized Authorized Unauthorized Resolution 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 01 1412-ST Downtown Enhancements (Broadway) 200,000 2,365,959 2,565,959 2,320,686 D 245,589 01 02 1512-ST First Street (DNT - Coleman) 1,076,000 1,363,915 8,000,000 10,439,915 2,439,915 A, D 8,000,000 8,000,000 02 03 1507-ST West Prosper Road Improvements 6,000,000 6,781,000 3,100,000 15,881,000 9,516,000 B,C 4,265,000 2,100,000 2,100,000 03 04 1622-ST Main Street (First - Broadway) 625,000 625,000 400,000 E 225,000 04 05 Gates of Prosper, TIRZ No. 1 (Richland, Lovers Lane, Detention) 1,214,388 2,079,632 2,532,536 5,826,556 5,826,556 H 05 06 Matthews Southwest, TIRZ No. 2 188,352 440,601 628,953 628,953 J 06 07 1511-ST Prosper Trail (Kroger - Coit) 305,000 4,457,308 4,762,308 4,557,000 A,D 205,308 07 08 1721-ST Windsong Road Repairs, Phase 1 & 2 Acacia Parkway (Gee Road - Windsong Parkway) 1,022,782 1,022,782 1,022,782 D 08 09 1812-ST Windsong Road Repairs (Uretek) 920,000 920,000 920,000 D,Z 09 10 1817-ST Windsong Road Repairs, Phase 3 710,000 710,000 710,000 710,000 10 11 US 380 (Denton County Line - Lovers Lane) 59,000,000 59,000,000 59,000,000 X 11 12 1709-ST Prosper Trail (Coit - Custer) - 4 lanes 610,000 200,000 11,755,000 12,565,000 810,000 A 11,755,000 11,755,000 12 13 1710-ST Coit Road (First - Frontier) - 4 lanes 689,900 600,000 14,000,000 15,289,900 1,289,900 A 14,000,000 14,000,000 13 14 1307-ST Frontier Parkway (BNSF Overpass) 20,345,000 2,210,000 22,555,000 20,375,000 A,X 949,004 720,996 510,000 365,000 1,230,996 14 15 DNT Southbound Frontage Road 17,000,000 17,000,000 17,000,000 X 15 16 Teel Parkway (DCFWSD#10), Phase 2 1,000,000 1,000,000 1,000,000 X 16 17 1513-ST Old Town Streets 2015 (Fifth, McKinley) 1,000,000 1,000,000 1,000,000 1,000,000 17 18 1803-ST Fifth Street (Coleman - Church) 375,000 375,000 375,000 375,000 18 19 1804-ST Third Street (Main - Coleman) 250,000 250,000 250,000 250,000 19 20 1701-ST Eighth Street (Church - PISD Admin) 260,000 260,000 260,000 260,000 20 21 1702-ST Field Street (First - Broadway) 250,000 250,000 250,000 250,000 21 22 1708-ST E-W Collector (Cook Lane - DNT); design done w/ Cook Lane 125,000 1,250,000 1,375,000 1,375,000 A 22 23 1820-ST First Street/DNT Intersection Improvements 137,000 1,250,000 1,387,000 1,387,000 D 23 24 1823-ST Victory Way (Coleman - Frontier) - 2 lanes of 4 lane ultimate 250,000 2,250,000 2,500,000 250,000 D 385,000 1,865,000 2,250,000 24 25 1830-ST Prosper Trail/DNT Intersection Improvements 13,000 75,000 88,000 88,000 A,D 25 26 1831-ST First Street/BNSF RR Overpass Study 40,000 40,000 40,000 D 26 27 1832-ST Prosper Trail/BNSF RR Overpass Study 40,000 40,000 40,000 D 27 28 1824-ST Fishtrap (Teel Intersection Improvements) 150,000 1,350,000 1,500,000 150,000 D 1,350,000 1,350,000 28 29 1708-ST Cook Lane (First - End) 150,000 2,100,000 2,250,000 150,000 A 2,100,000 2,100,000 29 30 1825-ST Coleman Street (Gorgeous - Prosper Trail) - 4 lanes 375,000 2,125,000 2,500,000 375,000 D 2,125,000 2,125,000 30 31 FM 2478 (US 380 - FM 1461) 80,000 169,000 69,000 56,500,000 56,818,000 56,818,000 A,X 31 32 Coleman Street (at Prosper HS) 700,000 700,000 700,000 C 32 33 1908-ST Fifth Street (Parvin - Craig) 400,000 400,000 400,000 D 33 34 1908-ST Lane Street (First - Third) 225,000 225,000 225,000 D 34 35 1908-ST North Street (Seventh - Eighth) 175,000 175,000 175,000 D 35 36 1908-ST Pecan Street (First - End) 200,000 200,000 200,000 D 36 37 Craig Street (Preston - First) 750,000 750,000 750,000 750,000 37 38 Craig Street (First - Broadway) 350,000 350,000 350,000 350,000 38 39 Craig Street (Broadway - Fifth) 200,000 200,000 200,000 200,000 39 40 DNT Overpass at US380 8,000,000 92,000,000 100,000,000 96,000,000 D,J, X 4,000,000 4,000,000 40 41 US 380 (US 377 - Denton County Line) 129,728,061 129,728,061 129,728,061 X 41 42 DNT Main Lane (US 380 - FM 428) 87,500,000 262,500,000 350,000,000 350,000,000 X 42 43 Crown Colony (Meadow Run - Bradford) 465,000 465,000 53,816 411,184 465,000 43 44 Crown Colony (Bradford - High Point) 500,000 500,000 500,000 500,000 44 45 Ridgewood (Hays - Crown Colony) 560,000 560,000 560,000 560,000 45 46 Waterwood (Ridgewood - End) 150,000 150,000 150,000 150,000 46 47 Colonial (Ridgewood - End)150,000 150,000 150,000 150,000 47 48 Shady Oaks Lane (Ridgewood - End)150,000 150,000 150,000 150,000 48 49 Riverhill (Ridgewood - End)150,000 150,000 150,000 150,000 49 50 Plymouth Colony (Bradford - High Point)400,000 400,000 400,000 400,000 50 51 Plymouth Colony Circle (Plymouth Colony - End)200,000 200,000 200,000 200,000 51 52 Prestonview (Hays - Betts)750,000 750,000 750,000 750,000 52 53 Betts Lane (Prestonview - High Point)250,000 250,000 250,000 250,000 53 54 High Point Drive (Hays - Betts)725,000 725,000 725,000 725,000 54 55 West Yorkshire Drive (High Point - Bradford)250,000 250,000 250,000 250,000 55 56 Bradford Drive (West Yorkshire-Plymonth Colony)600,000 600,000 600,000 600,000 56 57 Chandler Circle (Preston Road-Hays)700,000 700,000 700,000 700,000 57 58 1703-ST Parvin Road (Good Hope - FM 1385) 270,000 270,000 270,000 270,000 58 59 1704-ST Pasewark (Preston - Hickory) 400,000 400,000 400,000 400,000 59 60 FM 1461 (SH 289 - CR 165) 53,000,000 53,000,000 53,000,000 X 60 61 Coleman Street (Prosper Trail - Preston) - 4 lanes 6,000,000 6,000,000 700,000 A 5,300,000 5,300,000 61 62 Fishtrap (Teel - DNT) - 4 lanes 13,500,000 13,500,000 1,250,000 A 12,250,000 12,250,000 62 63 Teel Parkway (US 380 - Fishtrap) - Add 2 lanes to make 4 4,500,000 4,500,000 500,000 A 4,000,000 4,000,000 63 69,908,640 61,526,197 15,791,536 12,819,000 278,228,061 87,500,000 0 382,050,000 907,823,434 820,657,853 8,734,901 2,459,812 75,971,184 365,000 2,845,000 5,580,996 8,750,000 0 0 0 64,100,000 A Impact Fees G Park Development Fund B Grant and Interlocal Funds H TIRZ #1 C Developer Agreements J TIRZ #2 D General Fund K Escrows E Water / Wastewater Fund X Non-Cash Contributions F Stormwater Drainage Fund Z Other Sources (See Detail) 01 IndexUnissued Debt Schedule Description Codes - Other Sources Funding Sources Other Sources Summary of Capital Improvement Program - 12/11 FINAL General Fund Projects IndexStreet Projects Subtotal EXHIBIT B - CAPITAL IMPROVEMENT PLAN Ordinance No. 18-113, Page 4 Funding Sources Total Other Issued Debt Unissued Debt Unissued Debt Reimbursement Issued Prior Years 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 Cost Sources Authorized Authorized Unauthorized Resolution 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 01 1827-TR Median Lighting - US 380 (Denton County - Custer)485,000 485,000 485,000 D 01 02 Median Lighting - Coit Road (First - Frontier)1,000,000 1,000,000 1,000,000 D 02 03 Median Lighting - First Street (Craig - Coit)625,000 625,000 625,000 D 03 04 Median Lighting - Prosper Trail (Dallas Pkwy - Preston)825,000 825,000 825,000 D 04 05 Median Lighting - Prosper Trail (Preston - Coit 625,000 625,000 625,000 D 05 06 Traffic Signal - FM 1461 & Coit Rd 125,000 125,000 125,000 X 06 07 Traffic Signal - FM 1461 & FM 2478 (Custer Rd)125,000 125,000 125,000 X 07 08 Traffic Signal - FM 2478 (Custer Rd) & Prosper Trail 125,000 125,000 125,000 X 08 09 Traffic Signal - SH 289 & Coleman Rd 220,000 220,000 220,000 X 09 10 1909-TR Traffic Signal - Coit Rd & First Street 250,000 250,000 250,000 A 10 11 Traffic Signal - DNT & Frontier: (Collin County)400,000 400,000 400,000 X 11 12 Traffic Signal - DNT & Prosper Trail: (Collin County)400,000 400,000 400,000 X 12 13 Traffic Signal - Coit Rd & Richland Boulevard 250,000 250,000 250,000 A 13 14 Traffic Signal - Fishtrap & Gee Road 250,000 250,000 250,000 A 14 15 Traffic Signal - Fishtrap & Teel Parkway 250,000 250,000 250,000 A 15 16 Traffic Signal - Fishtrap & Windsong Parkway 250,000 250,000 250,000 A 16 17 Traffic Signal - FM 1385 & Fishtrap 125,000 125,000 125,000 X 17 18 Traffic Signal - SH 289 & Lovers Lane 220,000 220,000 220,000 H 18 595,000 1,535,000 1,345,000 0 0 0 3,075,000 6,550,000 6,550,000 0 0 0 0 0 0 0 Funding Sources Total Other Issued Debt Unissued Debt Unissued Debt Reimbursement Issued Prior Years 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 Cost Sources Authorized Authorized Unauthorized Resolution 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 Neighborhood Park 01 1806-PK Star Trail Park #1 (7.5 Acres / No Lights)985,000 985,000 985,000 C, G 01 02 Lakewood Preserve (22 Acres / No Lights)483,000 483,000 966,000 966,000 C 02 03 1802-PK Hays Park (2 Acres / No Lights)50,000 300,000 350,000 350,000 G 03 04 Prairie Park (6.7 Acres / No Lights)300,000 300,000 300,000 C 04 05 Tanners Mill Park 468,000 500,000 968,000 468,000 C 500,000 500,000 05 06 Town Hall Open Space Park 55,000 2,000,000 2,055,000 55,000 D 2,000,000 2,000,000 07 Pecan Grove Irrigation (21.5 Acres / No Lights)75,000 75,000 75,000 D 07 08 Star Trail Park #2 (7.5 Acres / No Lights)1,393,000 1,393,000 535,000 C 858,000 858,000 08 09 Windsong Ranch Neighborhood Park #2 (7.5 Acres / No Lights)1,100,000 1,100,000 510,000 C, G 590,000 590,000 09 10 Pecan Grove Phase 2 (21.5 Acres / No Lights) (basketball, pavilion, parking, security lighting) 67,500 675,000 742,500 250,000 G 492,500 67,000 425,500 10 11 Park Operations Park (Convert area where Ops is into park) (17 Acres / No Lights) 50,000 425,000 475,000 475,000 50,000 425,000 11 12 Windsong Ranch Neighborhood Park #3 (7.5 Acres / No Lights)1,200,000 1,200,000 260,000 C 940,000 940,000 12 13 Star Trail Park #3 7.5 Acres / No Lights)1,160,000 1,160,000 785,000 C, G 375,000 375,000 13 14 Cedar Grove Park Phase 2 (9.8 Acres / No Lights)300,000 300,000 300,000 300,000 14 15 1303-PK Cockrell Park (8.4 Acres / No Lights)90,000 1,012,640 1,102,640 90,000 G 1,012,640 1,012,640 15 Trails 16 1801-PK Whitley Place H&BTrail Extension 70,000 500,000 570,000 70,000 G 500,000 500,000 16 17 Windsong H&B Trail Phases 3C,5,6A, 6B, 7, 8, and 9.450,524 450,524 450,524 450,524 450,524 2,252,620 2,252,620 C 17 18 1910-PK Hike and Bike Master Plan 35,000 35,000 35,000 D 18 19 1911-PK Pecan Grove H&B Trail 30,000 410,000 440,000 250,000 G 190,000 190,000 19 20 Star Trail H&B Trail Phases 1, 2, 3, and 4.100,000 100,000 1,000,000 1,200,000 1,200,000 C 20 21 Whitley Place H&B Trail (Power line Easement)280,000 280,000 280,000 280,000 21 22 H&B Trail Heads / H&B Trail Gateways 100,000 100,000 500,000 700,000 700,000 100,000 100,000 500,000 22 23 Future unnamed H&B Trail 1,000,000 1,000,000 1,000,000 1,000,000 23 Community Park 24 1603-PK Frontier Park - North Field Improvements (17 Acres / Lights)11,360,815 31,195 11,392,010 1,834,590 B,G 9,557,420 24 25 1808-PK West Park Land (200 Acres / Lights)50,000 50,000 50,000 D 25 26 Town Lake Improvements (24 Acres / Lights)15,000 300,000 315,000 315,000 15,000 300,000 26 27 Sexton Park (69 Acres / Lights) (Sports Fields)7,650,000 7,650,000 7,650,000 7,650,000 27 28 Sexton Park Phase 2 (Lights) (Additional Sports Fields)15,000,000 15,000,000 15,000,000 15,000,000 28 29 Windsong Ranch Community Park (51 Acres / Lights)17,000,000 17,000,000 17,000,000 17,000,000 29 30 Prosper Center Community Park ( 30 Acres / no lights)15,000,000 15,000,000 15,000,000 15,000,000 30 31 Star Trail Park Community Park (30 Acres / Lights)15,000,000 15,000,000 15,000,000 15,000,000 31 Medians 31 1417-PK Richland Boulevard Median Landscaping 5,000 170,000 175,000 175,000 D 31 32 1723-PK State Highway 289 Gateway Monument 304,752 304,752 304,752 D 32 33 1818-PK Additional Turf Irrigation SH 289 80,000 80,000 80,000 D 33 34 1813-PK SH 289/US 380 Green Ribbon Landscape Irrigation 59,250 750,000 809,250 809,250 B,D 34 11,455,815 1,578,721 4,156,524 4,291,024 1,475,524 3,835,524 0 75,632,640 102,425,772 12,690,212 9,557,420 0 80,178,140 0 0 500,000 1,910,000 1,905,500 1,400,000 0 74,462,640 Funding Sources Total Other Issued Debt Unissued Debt Unissued Debt Reimbursement Issued Prior Years 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 Cost Sources Authorized Authorized Unauthorized Resolution 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 01 1402-FC Town Hall - Professional Services 2,040,695 200,845 2,241,540 845 Z 2,240,695 1,250,000 379,195 01 02 1514-ST Town Hall - Offsite Infrastructure 1,307,400 1,307,400 32,400 F 1,275,000 02 03 1601-FC Town Hall - Construction 19,597,691 457,454 20,055,145 65,454 Z 19,989,691 10,451,732 03 04 1714-FC Town Hall - Furniture, Fixtures, and Equipment 1,362,000 1,362,000 1,362,000 1,362,000 04 05 1713-FC Police Station and Dispatch - Professional Services 59,696 1,000,000 385,000 1,444,696 59,696 D 1,000,000 385,000 1,000,000 385,000 05 06 1904-FC Police Station and Dispatch - Development Costs 550,000 550,000 550,000 550,000 06 07 1905-FC Police Station and Dispatch - Construction 11,400,000 11,400,000 335,000 D 11,065,000 11,065,000 07 08 1906-FC Police Station and Dispatch - Furniture, Fixtures, and Equipment 1,165,000 1,165,000 1,165,000 D 08 09 1809-FC Parks Operations and Public Works Complex 3,650,000 10,900,000 14,550,000 2,750,000 E, G 900,000 10,900,000 900,000 10,900,000 09 10 Westside Radio Tower for Public Safety 500,000 500,000 500,000 500,000 10 11 Central Fire Station Administration 2,546,000 2,546,000 2,546,000 2,546,000 11 12 Central Fire Station, Phase II (Bunk Gear Climate Storage)850,000 850,000 850,000 850,000 12 13 Eastside Fire Station 5,625,000 5,625,000 5,625,000 5,625,000 13 14 1901-EQ Ladder Truck 1,650,000 1,650,000 1,650,000 D 1,650,000 14 15 Recreation Center 15,000,000 15,000,000 15,000,000 15,000,000 15 16 Senior Facility 9,000,000 9,000,000 9,000,000 9,000,000 16 24,367,482 5,308,299 15,150,000 500,000 0 0 0 43,921,000 89,246,781 6,058,395 26,767,386 0 56,421,000 1,250,000 14,092,927 12,000,000 500,000 0 0 0 45,571,000 105,731,937 69,008,217 36,633,060 18,955,024 279,703,585 91,335,524 0 504,678,640 1,106,045,987 845,956,460 45,059,707 2,459,812 212,570,324 1,615,000 16,937,927 18,080,996 11,160,000 1,905,500 1,400,000 0 184,133,640 IndexIndexIndexUnissued Debt Schedule Unissued Debt Schedule Unissued Debt Schedule 02 Subtotal IndexPark Projects IndexFacility Projects Subtotal Grand Total General Fund Subtotal IndexSummary of Capital Improvement Program - 12/11 FINAL General Fund Projects Traffic Projects Ordinance No. 18-113, Page 5 Funding Sources Total Other Issued Debt Unissued Debt Unissued Debt Reimbursement Issued Prior Years 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 Cost Sources Authorized Authorized Unauthorized Resolution 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 01 1508-WA BNSF Railroad PRV's 175,000 175,000 175,000 01 02 1719-WA Custer Road Pump Station Expansion (Additional Pump)134,100 829,350 963,450 963,450 A 02 03 1822-WA Glennbrooke Water Meter PRV's 407,200 407,200 407,200 03 04 1715-WA Fishtrap 2.5 MG Elevated Storage Tank Site Acquisition 300,000 300,000 300,000 A 04 05 1902-WA Custer Road Meter Station and Water Line Relocations 290,325 1,905,200 2,195,525 2,195,525 E 05 06 1715-WA Fishtrap 2.5 MG Elevated Storage Tank 325,700 5,758,000 6,083,700 3,168,700 A 2,707,500 207,500 2,707,500 207,500 06 07 1716-WA Water Supply Line Phase 1 829,850 2,000,000 7,694,479 10,524,329 829,850 A 5,369,667 4,324,812 4,324,813 4,324,812 07 08 1716-WA Water Supply Line Phase 1 Easement Costs 1,941,500 1,857,000 3,798,500 1,857,000 A 1,941,500 1,941,500 08 09 1501-WA Lower Pressure Plane Pump Station and Transmission Line 185,100 1,250,000 14,250,000 15,685,100 4,127,081 A 1,308,019 10,250,000 1,250,000 5,125,000 5,125,000 09 10 1810-WA LPP Phase 2 Pipeline Easement Costs 1,487,150 1,487,150 1,487,150 A 10 11 1708-WA E-W Collector (Cook Lane - DNT) Water Line 250,000 250,000 250,000 E 11 12 1708-WA Cook Lane (First - End)400,000 400,000 400,000 E 12 13 1513-WA Old Town Streets 2015 (Fifth, McKinley) 350,000 350,000 350,000 E 13 14 Lower Pressure Plane Future Expansion (2025)14,000,000 14,000,000 14,000,000 14,000,000 14 1,649,750 7,078,050 17,336,954 16,555,200 0 0 0 14,000,000 56,619,954 15,928,756 0 11,908,886 0 28,782,312 0 10,223,813 4,532,312 5,125,000 5,125,000 0 0 14,000,000 Funding Sources Total Other Issued Debt Unissued Debt Unissued Debt Reimbursement Issued Prior Years 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 Cost Sources Authorized Authorized Unauthorized Resolution 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 01 Gates of Prosper, TIRZ No. 1 (Middle Doe Branch Line) 5,764,238 38,644 0 5,802,882 5,802,882 H 01 02 Matthews Southwest, TIRZ No. 2 (Lower Doe Branch Line) 1,166,922 166,492 0 1,333,414 1,333,414 J 02 03 1834-WW Public Works WWTP Decommission 65,000 900,000 965,000 965,000 A,E 03 04 1907-WW Doe Branch WWTP 0.25 MGD Expansion (2018)3,625,000 3,625,000 3,625,000 3,625,000 04 05 1903-WW Church / Parvin Wastewater Reconstruction 100,000 100,000 100,000 E 05 06 Doe Branch Parallel Interceptor (2021)5,000,000 5,000,000 5,000,000 5,000,000 06 07 Doe Branch WWTP 1.5 MGD Expansion (2024)24,190,495 24,190,495 24,190,495 24,190,495 07 6,931,161 270,136 4,625,000 0 5,000,000 0 0 24,190,495 41,016,791 8,201,296 0 0 32,815,495 0 0 3,625,000 0 5,000,000 0 0 24,190,495 Funding Sources Total Other Issued Debt Unissued Debt Unissued Debt Reimbursement Issued Prior Years 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 Cost Sources Authorized Authorized Unauthorized Resolution 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 01 1717-DR Old Town Drainage - First & Main Trunk Main 800,000 800,000 800,000 01 02 1616-DR Old Town Drainage - McKinley & Broadway Trunk Main 600,000 600,000 600,000 02 03 1614-DR Coleman Street Channel Improvements 17,500 290,979 308,479 17,500 F 290,979 03 04 1613-DR Old Town Drainage - Church & Parvin Drainage Impr.40,000 460,000 500,000 40,000 F 460,000 04 05 1718-DR Old Town Regional Retention - Broadway (Design & Constr.)25,000 216,149 550,000 791,149 241,149 550,000 550,000 05 06 1615-DR Old Town Regional Detention/Retention - Land Acquisition 540,000 385,000 925,000 540,000 385,000 385,000 06 07 1811-DR Old Town Drainage - Fifth Street Trunk Main 400,000 400,000 400,000 07 08 Old Town Drainage - Detention Pond Improvements 1,000,000 1,000,000 1,000,000 1,000,000 08 2,022,500 216,149 1,700,979 0 385,000 0 0 1,000,000 5,324,628 57,500 3,332,128 0 1,935,000 0 0 550,000 0 385,000 0 0 1,000,000 10,603,411 7,564,335 23,662,933 16,555,200 5,385,000 0 0 39,190,495 102,961,373 24,187,552 15,241,014 0 63,532,807 0 10,223,813 8,707,312 5,125,000 10,510,000 0 0 39,190,495 A Impact Fees B Grant and Interlocal Funds C Developer Agreements D General Fund E Water / Wastewater Fund F Stormwater Drainage Fund G Park Development Fund H TIRZ #1 J TIRZ #2 K Escrows X Non-Cash Contributions Z Other Sources (See Detail) Funding Sources Total Other Issued Debt Unissued Debt Unissued Debt Reimbursement Prior Years 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 Cost Sources Authorized Authorized Unauthorized Resolution 2017-2018 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2028 105,731,937 69,008,217 36,633,060 18,955,024 279,703,585 91,335,524 0 504,678,640 1,106,045,987 845,956,460 45,059,707 2,459,812 212,570,324 1,615,000 16,937,927 18,080,996 11,160,000 1,905,500 1,400,000 0 184,133,640 10,603,411 7,564,335 23,662,933 16,555,200 5,385,000 0 0 39,190,495 102,961,373 24,187,552 15,241,014 0 63,532,807 0 10,223,813 8,707,312 5,125,000 10,510,000 0 0 39,190,495 116,335,348 76,572,552 60,295,993 35,510,224 285,088,585 91,335,524 0 543,869,135 1,209,007,360 870,144,012 60,300,721 2,459,812 276,103,131 1,615,000 27,161,740 26,788,308 16,285,000 12,415,500 1,400,000 0 223,324,135 Index03 IndexWater Projects Summary of Capital Improvement Program - 12/11 FINAL Enterprise Fund Projects Grand Total Enterprise Funds Wastewater Projects Drainage Projects Summary of Capital Improvement Program - 12/11 FINAL Capital Improvement Program SummaryIndexIndex IndexIndexUnissued Debt Schedule Unissued Debt Schedule Index Grand Total Capital Improvement Program General Fund Enterprise Funds Unissued Debt Schedule Description Codes - Other Sources Subtotal Subtotal Capital Improvement Program Summary Subtotal Ordinance No. 18-113, Page 6 Department PO #Date Issued Account Number Line Balance Description Status 750-5419-10-00-1511-ST 17,500.00$ 750-5419-10-00-1511-ST 415.00$ 750-5419-10-00-1512-ST 68,458.49$ 750-5419-10-00-1512-ST 24,305.50$ 750-5419-10-00-1512-ST 30,782.50$ 07/06/15 750-6610-10-00-1714-FC 1,535.29$ 750-6610-10-00-1714-FC 5,637.94$ Engineering 15126 07/06/15 760-5419-10-00-0407-WA 9,650.00$ Professional Services for Prosper Trail Elevated Storage Tank No invoices paid in FY 2018; Project completed, but invoice submitted FY 2019; need to roll forward, pay invoice, and close PO. 11/16/15 750-6610-10-00-1507-ST 4,836,881.54$ 750-6610-10-00-1507-ST (250,000.00)$ 750-6610-10-00-1507-ST (9,100.00)$ 750-6610-10-00-1507-ST (2,450.00)$ 750-6610-10-00-1507-ST (106,728.89)$ Engineering 16105 02/26/16 760-6610-10-00-1613-DR 8,800.00$ Professional Services Agreement for the Old Town Drainage - Church & Parvin Drainage Improvements Project Last invoice date May 2018; Ongoing project, department requested to roll forward. 09/27/16 750-6610-10-00-1412-ST 2,000.00$ 750-6610-10-00-1412-ST 1,000.00$ 750-6610-10-00-1412-ST 6,000.00$ Engineering 17068 12/27/16 750-6610-10-00-1601-FC 44,636.84$ CSP No. 2015-51-B CMAR Town Hall Construction Last invoice date September 2018; Ongoing project, department requested to roll forward. 01/30/17 660-6610-50-00-1710-ST 204,412.40$ 660-6610-50-00-1710-ST 20,000.00$ 660-6610-50-00-1710-ST 60,500.00$ 660-6610-50-00-1710-ST 24,000.00$ 660-6610-50-00-1710-ST 10,230.00$ 660-6610-50-00-1710-ST 37,430.00$ 660-6610-50-00-1710-ST 110,000.00$ 660-6610-50-00-1710-ST 12,720.00$ 660-6610-50-00-1710-ST 95,000.00$ 660-6610-50-00-1710-ST 19,280.00$ 660-6610-50-00-1710-ST 80,000.00$ 660-6610-50-00-1710-ST 83,000.00$ 03/13/17 660-6610-50-00-1709-ST 32,766.60$ 660-6610-50-00-1709-ST 145,346.00$ 660-6610-50-00-1709-ST 24,096.37$ 660-6610-50-00-1709-ST 5,000.00$ 03/20/17 750-5410-10-00-1723-PK 2,000.00$ 750-5410-10-00-1723-PK 2,000.00$ 750-5410-10-00-1723-PK 1,600.00$ 750-5410-10-00-1723-PK 1,000.00$ 750-5410-10-00-1723-PK (2,000.00)$ 750-5410-10-00-1723-PK 500.00$ 04/20/17 630-6610-50-00-1715-WA 9,992.00$ 630-6610-50-00-1715-WA 87,100.00$ 630-6610-50-00-1715-WA 1,500.00$ 630-6610-50-00-1715-WA 5,213.21$ Engineering 15124 Professional Services for Town Hall/Multi-Purpose Facility Last invoice date April 2018; Ongoing project, department requested to roll forward. Engineering 15116 06/02/15 Professional Services for Prosper Trail (1,000 E of Preston Rd to Coit Rd) Last invoice date September 2018; Ongoing project, department requested to roll forward. Engineering 16256 Professional Engineering Services for Downtown Enhancement Project Last invoice date August 2018; Ongoing project, department requested to roll forward. Engineering 17088 Professional Engineering Services for Paving & Drainage Improvements for Coit Rd. from E. First St. to Frontier Pkwy Last invoice date September 2018; Ongoing project, department requested to roll forward. Engineering 16049 Road Improvements and Construction between Town, TVG Texas I, LLC, M/I Homes of DFW, LLC, and Prosper EDC Last invoice date January 2018; Ongoing project; department requested to roll forward. **Need to verify total invoices made under TVG Texas I, LLC Engineering 17122 Professional Engineering Services Prosper Trail from East of Coit Road to West of Custer Road Project Last invoice date August 2018; Ongoing project, department requested to roll forward. Last invoice date June 2018; Ongoing project, department requested to roll forward. Engineering 17143 Professional Engineering Services for Lower Pressure Plane Elevated Storage Tank Project Last invoice date September 2018; Ongoing project, department requested to roll forward. Parks & Rec Admin 17127 Professional Engineering Services Prosper Gateway Monument Design Project EXHIBIT C - PO ROLLL FORWARD DETAIL LIST Ordinance No. 18-113, Page 7 Department PO #Date Issued Account Number Line Balance Description Status 04/20/17 630-6610-50-00-1716-WA 5,380.00$ 630-6610-50-00-1716-WA 8,230.00$ 630-6610-50-00-1716-WA 11,190.00$ 630-6610-50-00-1716-WA 114,234.91$ 630-6610-50-00-1716-WA 3,977.51$ 630-6610-50-00-1716-WA 36,431.95$ 630-6610-50-00-1716-WA 3,948.43$ 630-6610-50-00-1716-WA 5,465.39$ 630-6610-50-00-1716-WA 35,017.50$ 630-6610-50-00-1716-WA 26,880.00$ 630-6610-50-00-1716-WA 10,500.00$ 630-6610-50-00-1716-WA 5,500.00$ 630-6610-50-00-1716-WA 3,360.00$ 630-6610-50-00-1716-WA 6,580.00$ Engineering 17148 05/08/17 630-6610-50-00-1719-WA 16,614.91$ Professional Engineering Services for Custer Road Pump Station Expansion Project Last invoice date September 2018; Ongoing project, department requested to roll forward. 08/29/17 750-5405-10-00-1512-ST 41,300.00$ 750-5405-10-00-1512-ST 14,000.00$ 760-6610-10-00-1615-DR 10,000.00$ 10/27/17 410-6160-20-01 2,025.00$ 410-6160-20-01 750.00$ 11/02/17 750-6610-10-00-1513-ST 1,200.00$ 750-6610-10-00-1513-ST 7,000.00$ 12/21/17 680-6610-50-00-1708-ST 123,495.44$ 680-6610-50-00-1708-ST 39,532.00$ 680-6610-50-00-1708-ST 4,294.70$ 680-6610-50-00-1708-ST 3,920.24$ 680-6610-50-00-1708-ST 1,018.00$ 680-6610-50-00-1708-ST 4,176.00$ 680-6610-50-00-1708-ST 992.00$ 680-6610-50-00-1708-ST 1,160.00$ 12/27/17 620-6610-60-00-1801-PK 1,700.00$ 620-6610-60-00-1801-PK 34,390.00$ 620-6610-60-00-1801-PK 2,750.00$ 620-6610-60-00-1801-PK 11,000.00$ 620-6610-60-00-1801-PK 900.00$ 620-6610-60-00-1801-PK 6,500.00$ 620-6610-60-00-1801-PK 750.00$ 01/29/18 100-5630-20-01 675.00$ 100-5630-20-01 250.00$ Last invoice date November 2017; inquired with Police Department. Partial order received Oct 2017. Three body cameras and trigger boxes are on back order due to equipment restructing; anticipated ship date is Dec 2018. Department requested to roll forward. Engineering 18062 Professional Engineering Services for the Old Town Streets 2015 (Fifth, McKinley) Project Last invoice date July 2018; Ongoing project, department requested to roll forward. VERF/Police 18054 Camera System and Trigger Box Last invoice date September 2018; Ongoing project, department requested to roll forward. Engineering 17195 Easement and ROW Acquisition Services - First Street (DNT- Coleman), Old Town Regional Detention/Retention, and Additional ROW Acquisition Services Last invoice date September 2018; Ongoing project, department requested to roll forward. Engineering 17144 Professional Engineering Services for Lower Pressure Plane Water Supply - Pipeline Project Phase 1 Last invoice date February 2018; inquired with Police Department. Partial order received Feb 2018. One body camera and trigger box are on back order due to equipment restructing; anticipated ship date is Dec 2018. Department requested to roll forward. Police 18120 Camera System and Trigger Box Last invoice date September 2018; Ongoing project, department requested to roll forward. Last invoice date September 2018; Ongoing project, department requested to roll forward. Parks & Rec Admin Engineering 18106 Professional Engineering Services for Whitley Place Trail Extension Project 18105 Professional Engineering Services for Cook Land and E-W Collector Project Ordinance No. 18-113, Page 8 Department PO #Date Issued Account Number Line Balance Description Status 03/01/18 100-5410-60-01-1813-PK 2,215.98$ 100-5410-60-01-1813-PK 2,500.00$ 100-5410-60-01-1813-PK 3,500.00$ 100-5410-60-01-1813-PK 2,500.00$ 100-5410-60-01-1813-PK 1,000.00$ 100-5410-60-01-1813-PK 5,743.46$ 03/13/18 200-6125-50-02 40,300.00$ 200-6125-50-02 1,200.00$ 04/02/18 750-6610-10-00-1412-ST 1,368,222.05$ 750-6610-10-00-1412-ST 243,264.50$ Engineering 18182 04/18/18 630-6610-50-00-1719-WA 570,718.56$ Bid No. 2018-57-B Custer Road Pump Station Expansion Last invoice date September 2018; Ongoing project, department requested to roll forward. Engineering 18197 05/11/18 750-6610-10-00-1714-FC 4,435.00$ Interior Design Services for Town Hall Last invoice date August 2018; Ongoing project, department requested to roll forward. 05/16/18 760-6610-10-00-1718-DR 250.00$ 760-6610-10-00-1718-DR 4,000.00$ 760-6610-10-00-1718-DR 10,000.00$ 760-6610-10-00-1718-DR 8,000.00$ 760-6610-10-00-1718-DR 8,000.00$ 760-6610-10-00-1718-DR 5,000.00$ 760-6610-10-00-1718-DR 6,000.00$ 05/23/18 750-6610-10-00-1701-ST 202,735.55$ 750-6610-10-00-1702-ST 132,241.54$ 750-6610-10-00-1803-ST 20,166.44$ 750-6610-10-00-1804-ST 40,338.75$ Engineering 18225 06/29/18 750-6610-10-00-1511-ST 3,809,774.10$ Bid No. 2018-75-B Paving and Drainage Improvements, Prosper Trail (Kroger-Coit) Last invoice date October 2018; Ongoing project, department requested to roll forward. 07/31/18 750-5410-10-00-1820-ST 1,300.00$ 750-5410-10-00-1820-ST 3,375.00$ 750-5410-10-00-1820-ST 28,910.00$ 08/17/18 750-5410-10-00-1823-ST 97,000.00$ 750-5410-10-00-1823-ST 77,000.00$ 750-5410-10-00-1823-ST 27,000.00$ 750-5410-10-00-1823-ST 3,000.00$ 750-5410-10-00-1823-ST 5,000.00$ 750-5410-10-00-1823-ST 8,000.00$ 750-5410-10-00-1823-ST 16,800.00$ 750-5410-10-00-1823-ST 6,000.00$ 750-5410-10-00-1823-ST 5,300.00$ 750-5410-10-00-1823-ST 2,500.00$ Police 18251 08/20/18 100-6110-20-01 49,988.62$ Old Town Hall Renovations Phase II Project just completed; Roll forward PO to receive invoice and close PO. 08/28/18 100-5480-50-01 14,500.00$ 100-5480-50-01 6,300.00$ 100-5410-98-01 21,500.00$ 08/28/18 200-6610-10-99-1513-WA 143,273.93$ 750-6610-10-00-1513-ST 758,211.14$ 760-6610-10-00-1811-DR 272,962.18$ Engineering 18172 Bid No. 2018-37-B Downtown Enhancements Last invoice date October 2018; Ongoing project, department requested to roll forward. Engineering 18201 Professional Engineering Services for the Old Town Drainage - Broadway & Church Retention Pond Improvements Last invoice date September 2018; Ongoing project, department requested to roll forward. Last invoice date September 2018; Ongoing project, department requested to roll forward. Public Works Water 18158 DCU Retrofit Project No invoices paid in FY 2018; Ongoing project, department requested to roll forward. Parks & Rec Admin 18152 Professional Engineering Services for US 380 Green Ribbon Landscape Design Project Last invoice date September 2018; Ongoing project; department requested to roll forward. Engineering 18259 Bid No. 2018-72-B Old Town Streets Last invoice date October 2018; Ongoing project, department requested to roll forward. Engineering/Streets 18258 Professional Engineering Services for Preston Road Signal Timing Project Last invoice date October 2018; Ongoing project; department requested to roll forward. Public Works Water 18205 Bid No. 2018-60-B Prosper Road Improvement Projects 2018, Eight, Fifth, Third and Field Streets Last invoice date August 2018; Ongoing project; department requested to roll forward. Engineering 18248 Professional Engineering Services for Victory Way (N. Coleman to Frontier Parkway) No invoices paid in FY 2018; Ongoing project, department requested to roll forward. Streets 18240 Professional Engineering Services for Fishtrap/First Street Intersection Improvements at Dallas North Tollway Ordinance No. 18-113, Page 9 Department PO #Date Issued Account Number Line Balance Description Status 08/28/18 750-6610-10-00-1713-FC 900,905.00$ 750-6610-10-00-1713-FC 19,921.69$ Parks & Rec Admin 18261 08/28/18 750-6610-10-00-1410-TR 22,708.65$ Decorative Monument Sign Electrical Work No invoices paid in FY 2018; Ongoing project, department requested to roll forward. Public Works Water 18265 09/04/18 200-6140-50-02 9,750.00$ Craig St. Elevated Scada Upgrade and Electrical for new Clay Val Last invoice date September 2018; Ongoing project; department requested to roll forward. Streets 18266 09/04/18 100-5480-50-01 81,611.00$ Bid No. 2018-81-B Prosper Trail Patching Coit Road to Custer Road No invoices paid in FY 2018; Ongoing project; department requested to roll forward. Engineering 18269 09/06/18 760-6610-10-00-1716-WA 1,720,684.19$ Bid No. 2018-79-B Lower Pressure Plane Water Line (BNSF Railroad to Preston Road) No invoices paid in FY 2018; Ongoing project, department requested to roll forward. 09/06/18 750-5410-10-00-1824-ST 3,000.00$ 750-5410-10-00-1824-ST 10,800.00$ 750-5410-10-00-1824-ST 17,720.00$ 750-5410-10-00-1824-ST 8,480.00$ 750-5410-10-00-1824-ST 4,972.72$ Streets 18277 09/14/18 100-5480-50-01 8,000.00$ Geotechnical Reiew of Town of Prosper Draft Pavement Design Manual No invoices paid in FY 2018; Ongoing project; department requested to roll forward. 09/17/18 760-6610-10-00-1822-WA 60,000.00$ 760-6610-10-00-1822-WA 30,000.00$ 760-6610-10-00-1822-WA 60,000.00$ Engineering 18282 09/17/18 750-6610-10-00-1713-FC 30,000.00$ Pre-Construction Services for Prosper Public Safety Complex Phase 1 No invoices paid in FY 2018; Ongoing project, department requested to roll forward. Public Works Water 18283 09/17/18 750-6610-10-00-1817-ST 618,385.00$ Bid No. 2018-82-B Prosper Road Improvement Project 2018 Windsong Ranch Phase III Miscellaneous Road Repairs No invoices paid in FY 2018; Ongoing project; department requested to roll forward. 09/17/18 200-5480-50-02 5,000.00$ 200-5480-50-02 3,000.00$ 09/17/18 100-5410-40-03 6,324.00$ 100-5410-40-03 8,200.00$ 100-5410-40-03 7,900.00$ 100-5410-40-03 8,900.00$ 100-5410-40-03 28,600.00$ 100-5410-40-03 4,800.00$ 100-5410-40-03 4,800.00$ Police 18289 09/25/18 100-6110-20-01 775.93$ Locks for PD Lockers There was an issue with the locks received. Currently working with the vendor to remedy the issue. Request to roll forward. Total 2017-2018 Open Encumbrances $18,094,364.75 Operating Accounts 100-5410-40-03 69,524.00$ 100-5410-98-01 21,500.00$ 100-5480-50-01 110,411.00$ 100-5630-20-01 925.00$ 100-6110-20-01 50,764.55$ 200-5480-50-02 8,000.00$ 200-6125-50-02 41,500.00$ 200-6140-50-02 9,750.00$ 200-6610-10-99-1513-WA 143,273.93$ 410-6160-20-01 2,775.00$ Total 458,423.48$ No invoices paid in FY 2018; Ongoing project; department requested to roll forward. Planning 18285 Professional Services for Phase 2 Prosper Old Town Area Assessment Last invoice date September 2018; Ongoing project, department requested to roll forward. Public Works Water 18284 Insurance Certificate Tracking Program Last invoice date September 2018; Ongoing project, department requested to roll forward. Engineering 18270 Professional Surveying and Engineering Design Services for Fishtrap Rd and Teel Pkwy Intersection Improvements Last invoice date September 2018; Ongoing project, department requested to roll forward. Engineering 18260 Professional Architectural and Engineering Services for Public Safety Facility Phase 1 (Police Station and Dispatch) Engineering 18280 Bid No. 2018-88-B Glenbrooke Estates Pressure Reducing Valve Installation Project No invoices paid in FY 2018; Ongoing project; department requested to roll forward. Ordinance No. 18-113, Page 10 Department PO #Date Issued Account Number Line Balance Description Status Multi-Year Accounts 620-6610-60-00-1801-PK 57,990.00$ 630-6610-50-00-1715-WA 103,805.21$ 630-6610-50-00-1716-WA 276,695.69$ 630-6610-50-00-1719-WA 587,333.47$ 660-6610-50-00-1709-ST 207,208.97$ 660-6610-50-00-1710-ST 756,572.40$ 680-6610-50-00-1708-ST 178,588.38$ 750-5405-10-00-1512-ST 55,300.00$ 750-5410-10-00-1723-PK 5,100.00$ 750-5410-10-00-1813-PK 17,459.44$ 750-5410-10-00-1820-ST 33,585.00$ 750-5410-10-00-1823-ST 247,600.00$ 750-5410-10-00-1824-ST 44,972.72$ 750-5419-10-00-1511-ST 17,915.00$ 750-5419-10-00-1512-ST 123,546.49$ 750-6610-10-00-1410-TR 22,708.65$ 750-6610-10-00-1412-ST 1,620,486.55$ 750-6610-10-00-1507-ST 4,468,602.65$ 750-6610-10-00-1511-ST 3,809,774.10$ 750-6610-10-00-1513-ST 766,411.14$ 750-6610-10-00-1601-FC 44,636.84$ 750-6610-10-00-1701-ST 202,735.55$ 750-6610-10-00-1702-ST 132,241.54$ 750-6610-10-00-1713-FC 950,826.69$ 750-6610-10-00-1714-FC 11,608.23$ 750-6610-10-00-1803-ST 20,166.44$ 750-6610-10-00-1804-ST 40,338.75$ 750-6610-10-00-1817-ST 618,385.00$ 760-5419-10-00-0407-WA 9,650.00$ 760-6610-10-00-1613-DR 8,800.00$ 760-6610-10-00-1615-DR 10,000.00$ 760-6610-10-00-1716-WA 1,720,684.19$ 760-6610-10-00-1718-DR 41,250.00$ 760-6610-10-00-1811-DR 272,962.18$ 760-6610-10-00-1822-WA 150,000.00$ Total 17,635,941.27$ 18,094,364.75$ Ordinance No. 18-113, Page 11