Appendix "A" to Report FCS20040(a) Page 1 of 3 City of Hamilton Available Capital Funding to Offset Anticipated COVID-19 Deficit Balances as of April 30, 2020 Project ID Description Total Budget Budget Status Actual PO Expenditures Commitments Uncommitted Balance Capital Levy Reserves Available Funding Development Charges Other Total Projects to be considered for delay/deferral Planning and Economic Development 7101558509 Public Art-West Ham Rail Trail 7202041208 Dundurn Exterior Pathways 7101258706 Dundurn Castle Exteriors 7201455700 Battlefield Interpretive Study 7201758703 Gage House Upper Rooms 7202041204 Childrens Museum Expansion Ph2 7201758701 Elec Box Heritage Program 7201841802 Steam Museum Tech Keefer Steps 8201755100 2017 Inter Village BIA Gateway 4501941900 Parking Control Squad Room 4031680681 Garner Rd-Hwy2 Wilson-Fiddlers 4032080288 Up Well-Stone Church-Limeridge 4031855815 South Mtn Arterial Study SMATS 4031955985 Highway 403 Connections Study 4031955986 MMLOS Policy & Trans Study 4032017051 Waterdown TM Implementation 4502055200 School Crossing Review Subtotal Planning and Economic Development Healthy and Safe Communities 7101557502 CLASS Software Upgrades Subtotal Healthy and Safe Communities Public Works 4411706201 Bar-Tiff Real Est Solicitation 4411706103 Bayfront Park Upgrades Ph 1 4411606111 Bayfront Park Beach Rehab 4411606004 Marketing Communication Imp 4411806103 Macassa Bay Boardwalk Trail 4411506104 West Harbour Draft Plan&Zoning 4411606103 Pier 6 Artisan Village 4411806102 Macassa Bay Shoreline Improv 3541951900 Generator ComplianceTest&Upgrd 3542041002 City Hall Garage Roof Rehab 3542041009 Compliance Remediation 3542051900 Generator ComplianceTest&Upgrd 3542055100 Facilities Audit Program 4452051900 Horticulture Infrastruct Repl 3722041805 HCC FOCH&FOC LifecycleRenewal 3722051000 Commonwealth Sq Railing Repl 3721949901 Summer's Lane Rehab&Pedstrn 4032041065 Snow Disposal - Yard Improve 4042010017 Street Lighting - Capital 4662020525 IPS - Intersection Ped Signal 25,000 75,000 254,293 100,000 182,300 700,000 34,000 95,000 36,000 30,000 1,870,000 150,000 150,000 30,000 160,000 150,000 100,000 4,141,593 226,861 74,913 118,788 37,500 14,706 92,413 565,181 14,170 23,134 23,374 1,290 61,967 25,000 75,000 13,263 1,953 40,138 662,500 19,294 1,298 36,000 30,000 1,870,000 150,000 150,000 30,000 160,000 150,000 100,000 3,514,445 25,000 75,000 13,263 40,138 662,500 19,294 1,298 36,000 280,000 60,000 150,000 30,000 160,000 150,000 1,702,492 260,380 260,380 229,507 229,507 22,444 22,444 8,429 8,429 8,429 8,429 200,000 500,000 280,000 450,000 1,100,000 641,540 1,191,900 1,150,000 110,000 140,000 450,000 470,000 310,000 60,000 700,000 100,000 1,950,000 250,000 400,000 370,000 22,190 84,053 106,994 20,744 592,952 24,714 167,698 44,319 - 13,078 13,232 57,947 6,625 - 200,000 477,810 195,947 329,928 1,079,256 35,356 1,109,240 975,677 110,000 140,000 450,000 470,000 310,000 60,000 700,000 100,000 1,905,681 250,000 400,000 370,000 200,000 477,810 164,455 1,079,256 35,356 951,029 975,677 110,000 140,000 450,000 470,000 310,000 60,000 700,000 100,000 1,100,000 250,000 400,000 370,000 1,953 30,000 100,000 131,953 329,928 805,681 - 1,590,000 90,000 1,680,000 - - 25,000 75,000 13,263 1,953 40,138 662,500 19,294 1,298 36,000 30,000 1,870,000 150,000 150,000 30,000 160,000 150,000 100,000 3,514,445 - 8,429 8,429 31,491 158,210 - 200,000 477,810 195,947 329,928 1,079,256 35,356 1,109,240 975,677 110,000 140,000 450,000 470,000 310,000 60,000 700,000 100,000 1,905,681 250,000 400,000 370,000 Appendix "A" to Report FCS20040(a) Page 2 of 3 Project ID 4662020531 4662020721 4031717241 4031817241 4031818217 4041810017 4041917384 4402055600 4402056003 4402056004 4401856127 4401856803 4401856817 4401356107 4401656603 4401756702 4401949510 4401956600 4401849107 4401855801 7102041701 7102041706 7102054702 7102051001 4032019106 4031810006 4031921960 4661920522 4661955946 4661720008 4661620630 4661720019 4661820019 4661820822 4661820823 4661915820 4661920017 4662020010 5301985803 5301985804 5302084003 5301641100 5301885804 5301885803 5121951900 5121990700 5122055137 5122090700 5122091001 5122095525 5121894000 5121892000 Description APS - Accessible Ped Signals Pedestrian Crossovers Fencing & Sound Barrier Rehab Fencing & Sound Barrier Rehab Bridge & Culvert Maintenance Street Lighting - Capital Annual Guiderail Upgrade 2019 Parks Testing and Reporting Mohawk Sports Park Masterplan Morton Park Redevelopment Churchill Park Phase 2 RHV Trails Mstr Plan The Nest Fifty Road Parkette Redev Cherry Beach Lakefront Park Sam Lawrence Park Fallen Firefighters Memorial Spraypad Infrastructure Rehab Olmstead Open Space-Monitoring Park Fencing Program Emergency Shoreline Study Community Halls Retrofits Recreation Centre Retrofits Facility Capital Maintenance Mech Infrastructure Lifecycle Hillcrest - Chedoke Recon Minor Annual Construction Fleet Addition - ES - Consruct Traffic Eng - Signal Design Autonomous-Connected Vehicles New Traffic Signal Instalation Two Way Road Conversion Annual Traffic Control RP 17 Annual Traffic Control RP 18 New Signal- Fifty @ North S Rd New Signal-Fruitland@North S R Traffic Counts Program Traffic Signal LED Upgrade Traffic Signal Modernization Terminal & End of Line Rehab Bus Stop Shelter Rehab Renaming the MacNab Terminal 330 Wentworth HSR Storage Bus Shelter Rehabilitation Terminal and End Line Rehab WasteCollectionEquip-DwntwnBIA PubSpace&SpecEvent Containers Waste Management R&D PubSpace&SpecEvent Containers Glan Landfill Stg3 Cells C D E SWMMP-Planning & Approvals Transfer Station CRC Closed Landfill Maintenance Total Budget 100,000 300,000 210,000 150,000 2,000,000 420,000 400,000 34,000 90,000 100,000 50,000 300,000 348,000 3,162,100 320,000 125,000 46,300 50,000 138,650 340,000 250,000 200,000 130,000 200,000 200,000 200,000 200,000 200,000 300,000 705,000 630,000 50,000 300,000 80,000 80,000 200,000 150,000 200,000 75,000 125,000 37,000 311,000 125,000 75,000 165,000 120,000 180,000 50,000 250,000 150,000 205,000 456,000 Budget Status Actual PO Expenditures Commitments 140,931 17,660 88,718 35,222 1,889,316 89,052 146,948 259,325 351,821 28,717 17,446 10,631 63,782 9,570 160,343 2,887,013 218,486 276,072 29,474 64,151 43,812 8,101 9,121 42,481 2,005 259,251 25,022 75,000 132,481 54,620 130,505 579,075 291,399 135,284 18,334 202,573 26,992 42,852 10,664 58,897 112,297 13,482 1,339 19,232 80,000 209,440 3,950 11,110 8,754 130,338 6,700 97,918 75,120 Uncommitted Balance 100,000 300,000 51,409 26,060 21,632 13,727 19,462 16,554 90,000 100,000 39,369 226,648 187,657 56,601 14,454 17,037 38,199 40,879 94,163 55,727 250,000 200,000 130,000 125,000 200,000 12,899 69,495 200,000 300,000 125,925 203,317 31,666 97,427 10,156 10,439 74,221 148,661 100,768 75,000 125,000 37,000 97,610 113,890 66,246 165,000 120,000 180,000 50,000 250,000 150,000 67,963 282,962 Capital Levy 100,000 300,000 51,409 26,060 21,632 13,727 19,462 16,554 90,000 100,000 39,369 226,648 56,601 14,454 38,199 40,879 90,768 250,000 200,000 130,000 125,000 200,000 12,899 69,495 200,000 300,000 125,925 203,317 31,666 97,427 10,156 10,439 74,221 148,661 100,768 75,000 125,000 37,000 97,610 113,890 66,246 165,000 50,000 180,000 50,000 250,000 150,000 67,963 282,962 Reserves 187,657 17,037 55,727 70,000 - Available Funding Development Charges - Other 3,396 - Total 100,000 300,000 51,409 26,060 21,632 13,727 19,462 16,554 90,000 100,000 39,369 226,648 187,657 56,601 14,454 17,037 38,199 40,879 94,163 55,727 250,000 200,000 130,000 125,000 200,000 12,899 69,495 200,000 300,000 125,925 203,317 31,666 97,427 10,156 10,439 74,221 148,661 100,768 75,000 125,000 37,000 97,610 113,890 66,246 165,000 120,000 180,000 50,000 250,000 150,000 67,963 282,962 Appendix "A" to Report FCS20040(a) Page 3 of 3 Project ID Description Total Budget Budget Status Actual PO Expenditures Commitments 136,019 238,560 70,420 19,690 156,711 13,314 273,228 44,918 22,514 77,599 7,373 22,003 2,770 18,178 10,234,783 1,725,889 5121991000 Glan Landfill Cap Improvements 5121994000 Transf Stn CRC Main Improv 5121994920 Env Services LegComplianceProg 4411706105 WH Parking Garage Feasibility 4411706102 Pier 8 Park 4032018019 Bridge 019 - Norman 4032018372 Bridge 372 - Wilson St E 4032019103 Marion - King to Dromore 4032019105 Glenmorris (York Heights Nbhd) 4031818404 Bridge 404 - Harrison Rd 4031818089 Bridge 089 - Creighton Rd 4031918048 Bridge 048 - Jones 4031918126 Bridge 126 - RR 56 Subtotal Public Works Corporate Services 3382055002 Provision for ICIP 3382055003 Provision SOGR Boards&Agencies Subtotal Corporate Services City Manager's Office 3381757505 Digital Strategy & Service Exp 3381858503 Performance Excellence Dashbrd 3381858502 Enhancing City of Hamilton App Subtotal City Manager's Office 418,000 268,000 185,000 300,000 1,419,300 30,000 30,000 140,000 140,000 170,000 260,000 180,000 170,000 29,816,790 280,000 250,000 40,000 570,000 261,977 21,705 10,310 293,992 Total Projects to be Considered for Delay/Deferral 40,202,763 5,000,000 414,000 5,414,000 - - Uncommitted Balance 43,421 177,890 28,289 286,686 1,101,154 30,000 30,000 140,000 140,000 147,486 175,028 155,227 151,822 17,856,117 Capital Levy 43,421 177,890 28,289 286,686 1,101,154 30,000 30,000 140,000 140,000 147,486 175,028 133,667 151,822 16,175,430 Available Funding Development Charges 1,466,031 - Reserves - Other Total 21,559 214,657 43,421 177,890 28,289 286,686 1,101,154 30,000 30,000 140,000 140,000 147,486 175,028 155,227 151,822 17,856,117 5,000,000 414,000 5,414,000 5,000,000 414,000 5,414,000 - - 10,000 10,000 18,023 228,295 19,690 266,008 18,023 21,003 39,026 199,987 19,690 219,676 - 7,305 7,305 18,023 228,295 19,690 266,008 11,323,464 1,820,300 27,058,998 23,339,376 1,817,660 221,962 27,058,998 1,345,000 240,000 250,000 644,119 50,000 916,795 213,000 250,000 190,000 11,908 7,876 2,548 10,176 2,446 81,388 95,718 50,500 171,184 - 1,294,500 228,092 242,124 470,386 39,824 916,795 210,554 168,612 94,282 200,000 128,000 100,000 210,000 36,000 150,000 170,000 100,000 50,000 - - - 200,000 128,000 100,000 210,000 36,000 150,000 170,000 100,000 50,000 4,098,914 212,059 221,684 3,665,170 1,144,000 - - - 1,144,000 125,000 360,000 200,000 1,094,110 864,450 985,550 714,165 187,000 2,745,440 524,945 26,963 153,289 118,108 854,782 668,972 933,125 713,702 147,338 2,601,631 523,613 297 10,321 39,205 25,467 45,296 5,949 - 98,037 206,414 71,571 200,123 170,010 7,129 463 33,713 143,809 1,332 98,037 206,414 71,571 200,123 3,933 470 463 33,713 4,557 510 13,068 243 - 153,009 6,416 131,096 - 8,156 821 98,037 206,414 71,571 200,123 170,010 7,129 463 33,713 143,809 1,332 7,800,660 6,741,524 126,535 932,601 619,792 13,310 290,522 8,977 932,601 52,102,337 18,277,048 2,168,520 31,656,770 25,103,168 1,830,970 1,970,522 230,939 29,135,600 1,680,000 5,000,000 414,000 5,414,000 Ongoing Projects with surplus funding available 4452053444 Tree Planting Program 4031941762 Facility Yard Maintenance 2019 4662015820 Traffic Counts Program 4402056918 BeasleyPk RehabPh2-KellySt Ped 4402051001 Equipment Upgrades 5122090200 Diversion Container Replcmnt 5122094000 Transf Stn CRC Main Improv 7401941603 MATC - Facility Upgrades 2051759702 Phase 1 Profile Management Total Ongoing Projects with Surplus Funding Available Completed or Cancelled Projects with Surplus Capital Levy Funding 3381959502 City Hall Digital Sign 7401851101 Automatic Vehicle Loc Devices 7401951602 Ice Water Rescue 6731641601 Bed Bug Strategy 3381355301 14 DC Study & '15-18 Intensif 3381855301 Development Charges' Bylaw 3501157102 PeopleSoft Systems-Upgrades 3621749100 Red Hill Bus Park Signage 3620604600 Secondary plan -AEGD 4041655601 Everyone Rides Initiative Pilo Total Completed or Cancelled Projects with Surplus Capital Levy Funding TOTAL