Page 187 - Colleyville FY19 Budget

Project Title Total Project Capital CEDC Fund County Funding Crime Control Drainage Fund FHA/TxDOT Area II Impact TIF Utility Wastewater Water Impact
Year Cost Projects Fund District Fees (West of 26) Capital Fund Impact Fees Fees
2020
Bransford Water Tank Rehabilitation - Construction $500,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $500,000.00 $0.00 $0.00
County Project (TBD) - Construction $800,000.00 $400,000.00 $0.00 $400,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Flood Gates Upgrade $425,000.00 $0.00 $0.00 $0.00 $0.00 $425,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Glade Road (Phase 1 - SH26 to Manning) - Construction $2,000,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,000,000.00 $0.00 $0.00 $0.00
Glade Road (Phase 2 - Manning to Pool) - Construction $2,000,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,000,000.00 $0.00 $0.00 $0.00
John McCain Road and Westcoat Drive Roundabout - Design $175,000.00 $175,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Justice Center - Metal Roof Coating $167,200.00 $0.00 $0.00 $0.00 $167,200.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
L.D. Lockett Road Right Turn Ln - Construction $150,000.00 $150,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
McDonwell School Road Right Turn Ln - Construction $150,000.00 $150,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
McDonwell School Road and Westcoat Drive Roundabout - Construction $1,400,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,400,000.00 $0.00 $0.00 $0.00 $0.00
Pleasant Run Waterline (John McCain North to Bear Creek) - Construction $900,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $900,000.00 $0.00 $0.00
Roberts Road - Construction $2,100,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,100,000.00 $0.00 $0.00 $0.00
Street Maintenance Program $500,000.00 $500,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Supervisory Control and Data Acquisition (SCADA) Replacement $350,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $350,000.00 $0.00 $0.00
Water Project 10: Apple Valley/Rustic Oaks/Bills Lane Water Lines and Road Rehabilitation on B $935,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $935,000.00 $0.00 $0.00
Water Project 5: Upsize and Replace Water Lines in Brighton Oaks Subdivision and Rehabilitate S $145,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $145,000.00 $0.00 $0.00
Water Project 11: Tinker Road Water Lines - Design $123,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $123,000.00 $0.00 $0.00
Sum Of Total Project Cost: $12,820,200.00 $1,375,000.00 $0.00 $400,000.00 $167,200.00 $425,000.00 $0.00 $1,400,000.00 $6,100,000.00 $2,953,000.00 $0.00 $0.00
Estimated 9/30/20 Available Balances $8,655,444.98 $0.00 $0.00 $0.00 $551,832.00 $14,585,450.00 $2,707,588.00 $1,048,492.00 $3,498,746.00
(+) Year-end surplus contributions $500,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $500,000.00 $0.00 $0.00
(+) FY21 Budgeted Contribution $1,500,000.00 $0.00 $325,052.00 $1,200,000.00 $0.00 $5,400,000.00 $400,000.00 $60,000.00 $192,000.00
Estimated 10/1/20 Available Balances $10,655,444.98 $0.00 N/A $325,052.00 $1,200,000.00 N/A $551,832.00 $19,985,450.00 $3,607,588.00 $1,108,492.00 $3,690,746.00
2021
City Hall - Flooring Rehab $87,808.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $87,808.00 $0.00 $0.00 $0.00
County Project (TBD) - Construction $800,000.00 $400,000.00 $0.00 $400,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Glade Road (Phase 2 - Manning to Pool) - Construction $2,000,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,000,000.00 $0.00 $0.00 $0.00
John McCain Road and Westcoat Drive Roundabout - Construction $1,400,000.00 $1,400,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Justice Center - Carpet and VCT Tile $88,052.00 $0.00 $0.00 $0.00 $88,052.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Justice Center - HVAC Replacement $237,000.00 $0.00 $0.00 $0.00 $237,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Pleasant Run Road Bridge at Big Bear (White Chapel Bridge) - Construction $1,200,000.00 $0.00 $0.00 $0.00 $0.00 $1,200,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Street Maintenance Program $500,000.00 $500,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Streetlighting for Pedestrian Crosswalks - Construction $50,000.00 $50,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Water Project 11: (Partial) Tinker Road Water Lines - Construction $1,110,000.00 $450,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $660,000.00 $0.00 $0.00
Water Project 12: (Partial) Woodbriar Estate Water Lines Replacement - Design $70,020.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $70,020.00 $0.00 $0.00
Water Project 5: Upsize and Replace Water Lines in Brighton Oaks Subdivision and Rehabilitate S $2,550,000.00 $650,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,900,000.00
Water Project 6: Upsize and Replace Water Lines in Woodbriar Estates and Quail Crest Subdivis $145,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $145,000.00 $0.00 $0.00
WW Project 1: Replace Sewer Lines in Woodbriar Estates and Quail Crest Subdivisions - Design $361,700.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $361,700.00 $0.00 $0.00
Sum Of Total Project Cost: $10,599,580.00 $3,450,000.00 $0.00 $400,000.00 $325,052.00 $1,200,000.00 $0.00 $0.00 $2,087,808.00 $1,236,720.00 $0.00 $1,900,000.00
Estimated 9/30/21 Available Balances $7,205,444.98 $0.00 $0.00 $0.00 $551,832.00 $17,897,642.00 $2,370,868.00 $1,108,492.00 $1,790,746.00
(+) Year-end surplus contributions $500,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $500,000.00 $0.00 $0.00
(+) FY22 Budgeted Contribution $1,500,000.00 $0.00 $0.00 $0.00 $0.00 $5,400,000.00 $500,000.00 $60,000.00 $192,000.00
Estimated 10/1/21 Available Balances $9,205,444.98 $0.00 N/A $0.00 $0.00 N/A $551,832.00 $23,297,642.00 $3,370,868.00 $1,168,492.00 $1,982,746.00
2022
County Project (TBD) - Construction $800,000.00 $400,000.00 $0.00 $400,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Library - Flooring Rehab $95,210.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $95,210.00 $0.00 $0.00 $0.00
Street Maintenance Program $500,000.00 $500,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Water Projec 12: Partial Woodbriar Estate Water Lines Replacement - Construction $433,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $433,000.00 $0.00 $0.00
Water Project 3: New Elevated Water Storage Tank and Associated Distribution Lines - Design $545,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $545,000.00
Water Project 6: Upsize and Replace Water Lines in Woodbriar Estates and Quail Crest Subdivisi $745,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $745,000.00 $0.00 $0.00
WW Project 1: Replace Sewer Lines in Woodbriar Estates and Quail Crest Subdivisions - Constru $1,900,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,900,000.00 $0.00 $0.00
WW Project 5: Quails Path and Chestnut Bend Sewer Line Replacement - Design $91,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $91,000.00 $0.00 $0.00
Sum Of Total Project Cost: $5,109,210.00 $900,000.00 $0.00 $400,000.00 $0.00 $0.00 $0.00 $0.00 $95,210.00 $3,169,000.00 $0.00 $545,000.00
Estimated 9/30/22 Available Balances $8,305,444.98 $0.00 $0.00 $0.00 $551,832.00 $23,202,432.00 $201,868.00 $1,168,492.00 $1,437,746.00
(+) Year-end surplus contributions $500,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $500,000.00 $0.00 $0.00
(+) FY23 Budgeted Contribution $1,500,000.00 $0.00 $0.00 $0.00 $0.00 $5,400,000.00 $600,000.00 $60,000.00 $192,000.00
Estimated 10/1/22 Available Balances $10,305,444.98 $0.00 N/A $0.00 $0.00 N/A $551,832.00 $28,602,432.00 $1,301,868.00 $1,228,492.00 $1,629,746.00
183