Loading...
HomeMy WebLinkAboutPreliminary (Binder Notes) Capital Improvements Program FY19-20FD - MICU/EMS UNIT RETIREMENT SCHEDULE 03/04/20 FY2021 MICU ORIGINAL PURCHASE REMOUNTS UNIT # UNIT # YEAR 1ST 2ND SELL NOTES: 797X 640 2000 rr� INITIAL PURCHASE 20072014M REMOUNTED 2007 TO UNIT #797 2014 REMOUNTED 2014 TO UNIT #284 827X 686 2002, ;` INITIAL PURCHASE 2009 REMOUNTED 2009 TO UNIT #827 2016 REMOUNTED 2016 TO UNIT #285 852X 699 2003 INITIAL PURCHASE 2009 REMOUNTED 2009 TO UNIT #852 2016V REMOUNTED 2016 TO UNIT #286 287X 287 2019 ). , INITIAL PURCHASE 2026 REMOUNTED 2026 TO UNIT #000 2033 REMOUNTED 2033 TO UNIT #000 PENDING PENDING 2020; INITIAL PURCHASE 2027 REMOUNTED 1027 TO UNIT #000 2034 REMOUNTED 2034 TO UNIT #000 7 Years active duty - Chassis 20 Years active duty - MICU Box Expenses Cost Year Replace Miles LTD Per Mile 284 2014 2021 69652 $ 27,314 $ 0.39 Push to 2022 284X 2000 $ 7,877 285 2016 2022 82644 $ 37,243 $ 0.45 Move to 2021 285X 2002 $ 6,712 286 2016 2023 48609 $ 24,659 $ 0.51 WRECKED Move to 2020 286X 2003 $ 4,372 287 2019 2040 10398 $ 3,336 $ 0.32 Remount 2026,2033 287X 2019 $ - 944 2013 2020 48251 $ 31,496 $ 0.65 Remount 2027, 2034 944X 2007 $ 6,758 Replace 2041 BUDGET AMOUNTS 2014 - Remount @ $99,900 ($33,300 Chassis / $66,600 Box) 2021 - Unit replacement @ $287,500 ($59,500 Chassis / $228,000 Box) 2016 - Remount @ $104,500 ($35,500 Chassis / $69,000 Box) 2022 - Unit replacement @ $291,000 ($61,000 Chassis/$230,000,000 Box) 2016 - Remount @ $101,400 ($33,800 Chassis / $67,600 Box) 2023 - Unit replacement @ $294,000 ($62,000 Chassis / $232,000 Box) 2026 - Remount @ $000,000 ($00,000 Chassis 1 $00,000 Box) 2033 - Remount @ $000,000 ($00,000Chassis/$00,000 Box) 2040 - Unit replacement @ $333,000 ($73,000 Chassis / $260,000 Box) 2027 - Remount @ $98,500 ($34,800 Chassis/ $63,700 Box) 2034 - Remount ($00,000 Chassis/$00,000 Box) 2041- Unit replacement @ $333,500 ($72,500 Chassis / $261,000 Box) Depr Total Adjust Collected Per Unit Collected $ 52,994 $ 138,897 $ 156,346 $ 85,903 $ 45,442 $ 131,344 $ 85,902 $ 37,339 $ 131,011 $ 93,672 $ 12,422 $ 68,214 $ 55,792 DRAFT 3/2/2020 CAPITAL IMPROVEMENTS PROGRAM FUNDED PROJECTS SUMMARY Project Number Project Description Budget as of 5/31119 Appropriation/ Amendment Budget as of 2/28120 Expended as of 2/28/20 Remaining Funds Revised Project Cost Estimates Unfunded/ (Excess Funding) DRAINAGE PROJECTS DR9903 Misc. Drainage Improvements $ 1,197,011 $ 50,000 $ 1,247,011 $ 697,930 $ 549,081 $ 1,247,011 $ DR1101 Flooding Mitigation $ 500,000 $ $ 500,000 $ 18,334 $ 481,666 $ 500,000 $ DR1201 Misc. Creek Maintenance min bal $100,000 $ 270,000 $ $ 270,000 $ 116,316 $ 153,684 $ 270,000 $ - FB9902 Fund Balance - Drainage CIP $ $ - $ $ $ $ $ 77,176 Sub -Total Drainage Projects $ 1,967,011 $ 50,000 $ 2,017,011 $ 832,580 $ 1,184,431 $ 2,017,011 $ (77,176) STREET PROJECTS PS1203 Misc. Street Repairs min bai $150,000 $ 926,500 $ $ 926,500 $ 769,686 $ 156,814 $ 926,500 $ PS1601 East Harwood Road Extension $ 100,000 $ $ 100,000 $ $ 100,000 $ 100,000 $ PS1802 FY2018 Street Reconstruction -Fuller Wiser Rd./Bear Creek Pkwy. $ 6,198,809 $ 64,845 $ 6,263,654 $ 3,905,298 $ 2,358,356 $ 6,263,654 $ PS1901 FY2019 Street Improvements $ 950,000 $ $ 950,000 $ 942,705 $ 7,295 $ 950,000 $ PS1902 FY2019 Street Reconstruction -Pi eline/Hi hland/Harwood/Mills $ 12,464,572 $ 182,968 $ 12,647,540 $ 89,549 $ 12,557,991 $ 12,647,540 $ - PS1903 Misc. Screening Wall Repair $ 25,000 $ 25,000 $ 50,000 $ 1,293 $ 48,707 $ 50,000 $ PS2001 FY2020 Street Improvements $ $ 975,000 $ 975,000 $ 133,498 $ 841,502 $ 975,000 $ PS2002 Glade Road Reconstruction -East of Highway 360 $ $ 150,000 $ 150,000 $ $ 150.000 $ 150,000 $ PS2003 Traffic Signal -Cheek S ar er Road at Heritage Avenue $ $ 315,000 $ 315,000 $ 186 $ 314,814 $ 315,000 $ FB9907 Fund Balance - Street CIP $ $ $ $ - $ $ $ 101,618 Sub -Total Street Projects $ 20,664,881 $ 1,712,813 $ 22,377,694 $ 5,842,215 $ 16,535,479 $ 22,377,694 $ (101,618) WASTEWATER PROJECTS WW0002 Misc. Wastewater Rehab min bal $100,000 $ 781,086 $ $ 781,086 $ 665,742 $ 115,344 $ 781,086 $ WW0605 TRAWastewater Payments -Im act $ 1,080,000 $ 100,000 $ 1,180,000 $ 1,080,000 $ 100,000 $ 1,280,000 $ 100,000 WW 1901 Line Replacement - Cedar Hill Estates North $ 409,903 $ $ 409,903 $ 250,838 $ 159,065 $ 409,903 $ WW 1902 FY2019 44th CDBG LR. Oakwood Terrace Addition Phases III & IV $ 408,950 $ 31,311 $ 377,639 $ 244,973 $ 132,666 $ 377,639 $ WW2001 FY202045th CDBG LR. Midway Park 2nd Addition Phase 1 $ $ 392,886 $ 392,886 $ $ 392,886 $ 392,886 $ WW2002 Line Replacement - Midway Park 3rd Addition Phase 1 $ - $ 446,600 $ 446,600 $ $ 446,600 $ 446,600 $ W W2003 Line Replacement - North Main Street $ $ 189,000 $ 189,000 $ - $ 189,000 $ 189,000 $ FB9911 FB - Wastewater Impact Restricted $ $ - $ $ $ $ $ 725,660 Sub -Total Wastewater Projects $ 2,679,939 $ 1,097,175 $ 3,777,114 $ 2,241,553 $ 1,535,561 $ 3,877,114 $ (625,660) WATER PROJECTS WT0001 Misc. Water Rehab min bal $150,000 $ 953,511 $ $ 953,511 $ 795,631 $ 157,880 $ 953,511 $ WT0101 Water Tank Debt Payment -Impact $ 4,982,088 $ 258,230 $ 5,240,318 $ 5,068,160 $ 172,158 $ 5,240,318 $ WT0104 Well Repairs $ 1,688,992 $ $ 1,688,992 $ 1,604,924 $ 84,068 $ 1,688,992 $ WT0803 Meters/Transponders/Leak Detection annual transfer $158,000 $ 2,202,944 $ 158,000 $ 2,360,944 $ 1,312,939 $ 1,048,005 $ 2,518,944 $ 158,000 WT1403 Reclaimed Water Line Extension Debt Payment -impact $ 720,889 $ 117,794 $ 838,683 $ 760,153 $ 78,530 $ 959,527 $ 120,844 WT1603 Misc Valve Replacement min bal $150,000 $ 390,000 $ 125,000 $ 515,000 $ 206,068 $ 308,932 $ 515,000 $ WT1604 lReclaimed Water Line Extension Phase III $ 4,622,698 $ 25,530 $ 4,648,228 $ 3,831,959 $ 816,269 $ 4,648,228 $ WT1802 lWell Rep lacement-Fuller/Far North $ 10,112,673 $ 1,028,211 $ 11,140,884 $ 3,487,507 $ 7,653,377 $ 11,140,884 $ WT1901 Line Replacement - K nette Drive $ 635,000 $ - $ 635,000 $ 593,793 $ 41,207 $ 635,000 $ WT2001 Line Replacement - Alexander Lane $ $ 440,000 $ 440,000 $ 440,000 $ 440,000 $ FB9910 FB - Water Impact Restricted $ - $ $ $ $ $ $ 2,032,176 FB9901 FB - Water & Wastewater CIP $ $ $ $ $ - $ - $ 207,285 Sub -Total Water Projects $ 26,308,795 $ 2,152,765 $ 28,461,560 $ 17,661,134 $ 10,800,426 $ 28,740,404 $ (1,960,617) Added earned interest to project. DRAFT 3/2/2020 CAPITAL IMPROVEMENTS PROGRAM FUNDED PROJECTS SUMMARY Project Number Project Description Budget as of 5/31119 Appropriation/ Amendment Budget as of 2128/20 Expended as of 2/28120 Remaining Funds Revised Project Cost Estimates Unfunded/ (Excess Funding) OTHER AC1901 ITexas Star Sports Complex Phase VII $ 150,000 $ 4,379,810 $ 4,529,810 $ 200,330 $ 4,329,480 $ 4,529,810 $ CM0304 Ent Monument $ 135,782 $ $ 135,782 $ 121,427 $ 14,355 $ 135,782 $ CM0804 Redevelopment $ 4,227,621 $ 1,018,562 $ 5,246,183 $ 3,677,970 $ 1,568,213 $ 5,246,183 $ CM1701 Municipal Plaza Improvements Phase II $ 266,733 $ $ 266,733 $ 68,756 $ 197,977 $ 266,733 $ DV9901 EDC Incentive Funds $ 1,400,854 $ 25,000 $ 1,425,854 $ 1,351,148 $ 74,706 $ 1,450,854 $ 25,000 ED1002 EDC Contingency $ 250,000 $ 75,000 $ 325,000 $ 68,772 $ 256,228 $ 325,000 $ ED1601 Midtown Development $ 16,417,980 $ - $ 16,417,980 $ 15,348,780 $ 1,069,200 $ 16,417,980 $ FM1201 ADA/TAS Facility Improvements min bal $75,000 $ 140,000 $ - $ 140,000 $ 54,613 $ 85,387 $ 140,000 $ - FM1708 Library Remodel $ 7,310,908 $ 150,000 $ 7,460,908 $ 5,325,001 $ 2,135,907 $ 7,460,908 $ FM2006 Fire Station #1 $ $ 7,550,000 $ 7,550,000 $ 5,970 $ 7,544,030 $ 7,550,000 $ GC1801 TSGC Misc. Improvements min bal $150,000 $ 362,180 $ 115,000 $ 477,180 $ 361,028 $ 116,152 $ 477,180 $ GC2003 Texas Star Sloe Wall Protection Phase 1 $ $ 315,000 $ 315,000 $ $ 315,000 $ 315,000 $ PR0720 Misc. Park Improvements min bal $100,000 $ 918,253 $ 200,000 $ 1,118,253 $ 860,176 $ 258,077 $ 1,118,253 $ PRO804 Park Irrigation $ 250,000 $ 25,000 $ 275,000 $ 207,472 $ 67,528 $ 300,000 $ 25,000 PR1917 Carr Park Improvements _ T 0- $ 1,688,831 $ 10,561 $ 1,699,392 $ 1,171,406 $ 527,986 $ 1,699,392 $ PR2011 Wilshire Park Upgrades $ $ 1,953,820 $ 1,953,820 $ 13,135 $ 1,940,685 $ 1,953,820 $ FB9906 FB-EDC CIP $ $ $ $ $ $ $ 114,284 FB9908 FB-Texas Star Sports Complex CIP $ - $ - $ $ - $ $ - $ 202,710 FB9909 FB-General CIP $ $ $ $ $ $ $ 280,828 FB9913 FB-Car Rental CIP $ $ $ $ - $ $ $ 85,413 FB9916 FB-TSGC CIP $ - $ - $ - $ $ $ - $ 12,785 Sub -Total Other Projects $ 33,519,142 $ 15,817,753 $ 49,336,895 $ 28,835,984 $ 20,500,911 $ 49,386,895 $ (646,020) TOTAL FUNDED PROJECTS $ 85,139,768 $ 20,830,506 $ 105,970,274 $ 55,413,466 $ 50,556,808 1 $ 106,399,118 $ (3,411,091) Added earned interest to project. DRAFT 3/2/2020 CAPITAL IMPROVEMENT PROGRAMS FY2021 PROPOSED & UNFUNDED PROJECTS - SORTED BY TYPE PROPOSED METHOD OF FINANCING Project Description Priority Estimated Cost Operating Fund CIP Fund Balance Bond Sale Grants/ Contributions Impact Fees Escrow Funds Car Rental Tax Other EDC To Be Determined DRAINAGE PROJECTS None Current) A $ Sub -Total Drainage Priority A -Proposed FY2021 $ - K nette Drive Storm Drain Installation i221 B $ 300,000 XX Sub -Total Drainage Priority B-Unfunded $ 300,000 Chittam Drive Storm Drain Installation C TBD /'I XX Little Bear Creek Drainage Improvements C TBD XX Sub -Total Drainage Priority C-Unfunded $ - DRAINAGE PROJECTS - TOTAL $ 300,000 STREET PROJECTS None Current/ A $ - Sub -Total Street Priority A -Proposed FY2021 $ - FY2021 Street Improvements (21) B $ 1,000,000 XX FY2022 Street Improvements 122) B $ 1,025,000 XX FY2023 Street Improvements (23) B $ 1,050,000 XX FY2024 Street Improvements (24) B $ 1,075,000 XX Sub -Total Street Priority El -Unfunded $ 4,150,000 Cresthaven Drive Reconstruction C TBD XX E Alexander Lane Reconstruction C TBD XX Ross Avenue Extension C TBD XX Vine Street Reconstruction-SH183 to SH10 C TBD XX Sub -Total Street Priority C-Unfunded $ - STREET PROJECTS - TOTAL 4,150,000 WASTEWATER PROJECTS None Currently A $ - Sub -Total Wastewater Priority A -Proposed FY2021 $ FY2021 46th CDBG LR: Del Paso Street Phase 1121j B $ 299,000 XX LR: Midway Park 3rd Addition Phase II I21j B $ 487,400 XX LR: SH10 @ Main Street r21j B $ 121,000 XX LR: Cedar Hill Estates South Phase 1'12) B $ 378,000 XX FY2022 47th CDBG LR: Del Paso Street Ph II & Midway Park 2nd Addition Ph II (22) B $ 282,000 XX LR: Cedar Hill Estates South Phase 11 (23) B $ 368,000 XX FY2023 48th CDBG LR: Midway Park 2nd Addition Ph III & Euless Jr. H.S. Ph 1 /231 B $ 287,000 XX FY2024 49th CDBG LR: Euless Junior High School Phase II (24) B $ 284,000 XX LR: Oakwood Terrace North Phase 1 i24) B $ 352,000 XX Sub -Total Wastewater Priority B-Unfunded $ 2,858,400 LR. Oakwood Terrace North Phase II C TBD XX Sub -Total Wastewater Priority - n un e - WASTEWATER PROJECTS - TOTAL 2,858,400 LR = Line Replacement 1 Preliminary cost estimate of $1,186,000. DRAFT 3/2/2020 CAPITAL IMPROVEMENT PROGRAMS FY2021 PROPOSED & UNFUNDED PROJECTS - SORTED BY TYPE PROPOSED METHOD OF FINANCING Project Description Priority Estimated Cost Operating Fund CIP Fund Balance Bond Sale Grants/ Contributions Impact Fees Escrow Funds Car Rental Tax Other EDC To Be Determined WATER PROJECTS None Current/ A $ Sub -Total Water Priority A -Proposed FY2021 $ LR: Dunaway Drive (") B $ 450,000 XX LR: Bell -Hi Addition Phase I (22) B $ 225,000 XX LR: Huntington Drive (22) B $ 450,000 XX LR: Bell -Hi Addition Phase II /23) B $ 200,000 XX LR: Dickey Drive (23) B $ 565,000 XX LR: Midway Park 1st Addition 121) B $ 475,000 XX Sub -Total Water Priority B-Unfunded $ 2,365,000 1 Mil Well Replacement C TBD XX LR Midway Park 3rd Addition C TBD XX Reclaimed Water Line Extension Phase IV C TBD XX LR: Sagebrush Trail C TBD XX SH360 Water Crossing C TBD XX LR: Soto rande Boulevard C TBD XX Sub -Total Water Priority C-Unfunded $ - WATER PROJECTS - TOTAL $ 2,365,000 OTHER PROJECTS None Current/ A $ Sub -Total Other Priority A -Proposed FY2021 $ Carr Park Trail Connection B $ 241,100 XX Kiddie Carr Park Improve B $ 893.500 XX Blessing Branch Park Improvements B $ 365,064 XX Texas Star Sports Complex Phase VIII t B $ 3,816,945 XX Sub -Total Other Priority B-Unfunded $ 5,316,609 Animal Shelter Expansion/Renovation C TBD XX South Euless Park Upgrades C TBD XX Trail Enhancements Phase I C TBD XX Trail Enhancements Phase It C TBD XX Trail Enhancements Villages of Bear Creek C TBD XX Trailwood Park Im rovements C TBD XX Sub -Total Other Priority C-Unfunded $ - OTHER PROJECTS - TOTAL $ 5,316,609 LR = Line Replacement FY2020 Funding Sources DRAFT 7/23/2019 Funded Project # Project Name Source DR9903 Misc. Drainage Improvements Drainage Operating Fund PS 1903 Misc Screening Wall Repair Street CIP Fund Balance-17139907 WW0605 TRA Wastewater Payments - Impact WW Impact Fees-FB9911 WT0101 Water Tank Debt Payment -Impact WT Impact Fees-FB9910 WT0803 Meters/Transponders/Leak Detection (annual transfer $158,000) W/WW Operating Fund (Baseline) WT1403 Reclaimed Water Line Extension Debt Payment -Impact WT Impact Fees-FB9910 WT1603 Misc. Valve Replacement (min bal $150,000) W/WW CIP Fund Balance-FB9901 WT1802 Well Replacement-Fuller/Far North W/WW Rate Stabilization CM0804 Redevelopment Car Rental Fund DV9901 EDC Incentive Funds EDC Operating Fund (Baseline) ED1002 EDC Contingency EDC CIP Fund Balance-FB9906 GC1801 TSGC Misc. Improvements (min bal S150,000) TSGC Reserves PR0720 Misc. Park Improvements (min bal S100,000) EDC Operating Fund (One-time) PR0804 Park Irrigation EDC Operating Fund (Baseline) Unfunded Street "A" FY2020 Street Improvements General Fund (Baseline) Street "A" Glade Road Reconstruction -East of Highway 360 Street CIP Fund Balance-FB9907 Street "A" Traffic Signal -Cheek Sparger Road at Heritage Avenue Car Rental CIP Fund Balance-FB9913 Street "A" Escrow Fund Street "A" Reimbursement Other Entities Wastewater "A" FY2020 45th CDBG LR: Midway Park 2nd Addition Phase I CDBG Wastewater "A" Line Replacement: Midway Park 3rd Addition Phase I W/WW Operating Fund (Baseline) Wastewater "A" Line Replacement: North Main Street W/WW Operating Fund (Baseline) Water "A" Line Replacement -Alexander Lane W/WW Operating Fund (Baseline) Other "A" Fire Station #1 Construction CO Sale Other "A" Fire Station 41 Issuance Costs Debt Service Fund Other "A" Texas Star Slope Wall Protection Phase I Car Rental CIP Fund Balance-FB9913 Other "A" Texas Star Sports Complex Phase VII Construction EDC Bond Sale Other "A" Wilshire Park Upgrades Car Rental Fund Total Funded Amount 50,000 25,000 100,000 258,230 158,000 117,794 125,000 600,000 1,000,000 25,000 75,000 115,000 200,000 25,000 2,874,024 975,000 150,000 66,250 50,000 198,750 1,440,000 392,886 446,600 189,000 1,028,486 440,000 440,000 7,335,000 215,000 315,000 4,379,810 1,953,820 14,198,630 Total Unfunded 17,107,116 Totals for Funding Source Car Rental CIP Fund Balance-FB9913 381,250 Car Rental Fund 2,953,820 CDBG 392,886 CO Sale 7,335,000 Debt Service Fund 215,000 Drainage Operating Fund 50,000 EDC Bond Sale 4,379,810 EDC CIP Fund Balance-FB9906 75,000 EDC Operating Fund (Baseline) 50,000 EDC Operating Fund (One-time) 200,000 Escrow Fund 50,000 General Fund (Baseline) 975,000 Reimbursement Other Entities 198,750 Street CIP Fund Balance-17139907 175,000 TSGC Reserves 115,000 W/WW CIP Fund Balance-FB9901 125,000 W/WW Operating Fund (Baseline) 1,233,600 W/WW Rate Stabilization 600,000 WT Impact Fees-FB9910 376,024 WW Impact Fees-FB9911 100,000 Grand Total 19,981,140 Water & Wastewater Operating Transfers FY2020 Budget Preparation PRELIMINARY 712312019 Annual Transfer: WW LR: Midway Park 3rd Addition Phase I WW LR: North Main Street WT LR: Alexander Lane Annual Transfer: WW LR: Midway Park 3rd Addition Phase II WW LR: SH10 @ Main Street WT LR: Dunaway Drive Annual Transfer: WW LR: Cedar Hill Estates South Phase I WT LR: Bell -Hi Phase I WT LR: Huntington Drive Annual Transfer: WW LR: Cedar Hill Estates South Phase II WT LR: Bell -Hi Phase II WT LR: Dickey Drive Annual Transfer: WW LR: Oakwood Terrace North Phase I WT LR: Midway Park 1st Addition CDBG Projects FY2020 45th CDBG LR: Midway Park 2nd Addition Phase I FY2021 46th CDBG LR: Del Paso Street Phase I FY2022 47th CDBG LR: Del Paso Street Ph 11 & Midway Park 2nd Addition Ph 11 FY2023 48th CDBG LR: Midway Park 2nd Addition Ph III Euless Junior US Ph I FY2024 49th CDBG LR: Euless Junior High School Phase 11 FY2020 FY2021 FY2022 FY2023 FY2024 FY2020 FY2021 FY2022 FY2023 FY2024 Annual Transfer/ Project Estimate Balance 30,097 FB9901 $ 1,075,000 1,105,097 (446,600) 469,497 $ (189,000) 916,097 (440,000) 29,497 $ 1,075,000 1,104,497 (487,400) 617,097 (121,000) 496,097 (450,000) 46,097 $ 1,075,000 1,121,097 (378,000) 743,097 (225,000) 518,097 (450,000) 68,097 $ 1,075,000 1,143,097 (368,000) 775,097 (200,000) 575,097 (565,000) 10,097 $ 1,075,000 1,085,097 (352,000) 733,097 (475,000) 258,097 392,886 299,000 282,000 287,000 284,000