Loading...
HomeMy WebLinkAbout2023-2026 Capital Forecast-C~of- p](KER]NG 2023-2026 Capital Forecast Subject to Review and Endorsement by New Council As Submitted to Executive Committee March 17, 2022 City of Pickering 2023-2026 Capital Forecast Table of Contents Budget Summaries Mayor & Council Mayor Council Office of the CAO Department Corporate Projects Community Services Department Civic Complex Senior Citizens Centre Dunbarton Pool Don Beer Arena Community Centres Seaton Community Centre Recreation Complex -Central Core Recreation Complex -Pool Recreation Complex -Arenas Museum Operations Department Property Maintenance Roads Equipment Operations Centre Parks Fleet Vehicles Corporate Services Department Information Technology Animal Services Engineering Services Department Streetlights & Signalization Sidewalks Stormwater Management Roads Projects Water Resources & Development Services Development Projects -(DC Funded) Finance Department Finance and Taxation Fire Services Department Fire Services Department 5192 5700 5701 5713 5715 5719 5720 5731 5733 5735 5744 5311 5319 5315 5780 5990 5206 5219 5325 5323 5410 5320 5613 5321 5340 Page 1 4 5 7 10 11 16 17 24 27 29 32 39 42 50 53 57 64 66 72 77 82 98 110 111 117 119 120 126 131 136 144 149 156 157 160 161 Libraries Library City of Pickering 2023-2026 Capital Forecast Table of Contents Seaton Re~ional Library 5800 5801 169 170 176 Organization Expenditures 6129 Parks -Landscape Refurbishment 6149 Restoration Museum Bldg 6157 Vehicles -under $100,000 6158 Vehicles -Over $100,000 6159 Fire Veh -Over $100,000 6173 Furniture & Fixtures 6174 System & Software Upgrade 6175 Hardware Replacements 6177 IT Infrastructure 6178 Machinery & Equipment 6179 Book Collection Material 6181 Other Fixed Assets 6183 Accessibility 6230 Prof/Consulting Fees 6231 City Project Mgmt. Fees 6250 Construction Costs 6251 Road Improvements 6252 Streetlights & Sidewalks 6253 Storm Water 6254 Traffic Signals 6255 Sidewalks 6256 Bridges & Culverts 6260 Other Construction Related Costs 6265 Land Acquisition & Disp 6400 Building Related -Seaton 6429 Parks Landscape Refurb -Seaton 6430 Prof/Consult Fees -Seaton 6450 Construction Costs -Seaton 6457 Vehicles -Under $100,000 -Seaton 6458 Vehicles -Over $100,000 -Seaton 6477 IT Infrastructure Seaton 6478 Miscellaneous Equipment -Seaton 6483 Accessibility -Seaton 6500 Building Related Total Expenditures City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 5,460,000 1,000,000 1,200,000 1,005,000 635,000 1,975,000 337,000 300,000 2,398,000 290,000 200,000 2,725,000 14,903,997 1,725,000 44,784,877 3,200,000 2,652,000 1,469,000 1,464,000 375,000 64,500,000 (7,213,000) 1,370,000 500,000 455,000 300,000 419,000 860,000 11,008,100 160,297,974 1 Run Date: Mar 15, 2022 2024 2025 2026 Forecast Forecast Forecast 3,850,000 1,210,000 5,270,000 734,000 477,000 410,000 185,000 135,000 720,000 1,150,000 595,000 1,025,000 1,230,000 231,000 325,000 576,800 600,000 200,000 115,000 107,000 263,000 140,000 408,000 1,665,000 1,905,000 1,225,000 290,000 290,000 2,240,000 200,000 300,000 200,000 2,309,600 2,472,700 3,876,000 1,471,500 3,454,500 147,750 200,000 200,000 200,000 9,434,000 10,669,000 5,625,000 3,212,000 1,160,000 1,872,200 917,000 1,157,000 557,000 112,000 200,000 200,000 200,000 3,575,000 750,000 6,863,000 1,504,000 72,430,000 200,000 4,280,000 17,930,000 490,000 17,490,000 70,000 100,000 80,000 1,325,000 400,000 496,000 150,000 84,000 84,000 200,000 2,150,000 460,000 1,200,000 11,705,200 26,879,500 6,494,000 66 659 300 55 517 900 133 131 550 City of Pickering Multi-Year Capital Forecast 2023 -2026 Organization 2023 Forecast Financing 1592 Donations 1594 Sale of Land 1610 Federal Grants (42,000) 1701 Debt-5 Year (2,124,000) 1702 Debt-10 Year (5,055,000) 1703 Debt-15 Year (5,724,000) 1704 Debt -20 year (5,867,000) 1705 Debt -25 Year (19,197,688) 1708 DC Debt -15 Year (Protective Services) 1709 DC Debt -20 Year (Protective Services) 1711 Internal Loan -5 Year (1,891,500) 1712 Internal Loan-10 Year 1718 DC Internal Loan -5 Year (Protective Services) (84,000) 1722 DC Debt -10 Year (Transportation) (581,000) 1725 DC Debt -25 Year (Transportation) (6,616,340) 1726 DC Debt-5 Year (Other Services Related to Hwy) (545,000) 1729 DC Debt-20 Year (Other Services Related to Hwy) 1731 DC Internal Loan -20 Year (Other Services Related to Hwy) (500,000) 1732 DC Debt-20 Year (Library) 1733 DC Debt-25 Year (Library) (19,360,817) 1741 DC Debt-15 Year (Parks & Rec) 1742 DC Debt-20 Year (Parks & Rec) 1743 DC Debt-25 Year (Parks & Rec) (64,506,553) 2823 Paid from Property Taxes (1,160,000) 7001 R -Capital Equipment Replacement (445,000) 7021 R -Rate Stabilization (3,561,750) 7022 R -DC's City's Share (1,358,124) 7034 R -R/Cmplex Core Surcharge 7036 R -R/Cmplx Arena Surcharge 7040 R -Vehicle Replacement (2,220,000) 7050 R -Senior Centre (4,177,688) 7053 R -Sustainability Initiatives 7055 R -Facilities (120,000) 7057 R -Fence (200,000) 2 Run Date: Mar 15, 2022 2024 2025 2026 Forecast Forecast Forecast (200,000) (257,500) (2,060,000) (891,000) (1,153,000) (4,180,000) (4,030,000) (939,500) (4,650,000) (2,839,000) (9,694,800) (18,597,000) (18,578,310) (1,200,000) (477,750) (2,2.15,000) (2,133,000) (953,800) (1,146,700) (165,000) (84,000) (84,000) (2,817,000) (300,000) (650,000) (4,500,000) (800,000) (4,312,190) (5,766,500) (12,606,750) (71,699,725) (1,825,500) (1,310,500) (1,768,750) (366,000) (3,112,800) (4,507,764) (3,939,635) (93,000) (45,000) (45,000) (97,000) (1,080,000) (1,335,000) (780,000) (21,500) (65,000) (350,000) (200,000) (300,000) (200,000) Organization 7060 R -Seaton Land Grp FIA 7061 R -Tennis Court 7062 R -Major Equipment 7066 R -Library Building 7067 R -Casino 7501 RF -Third Party Contribution 7502 RF -Parkland 7505 RF -Federal Gas Tax 7601 RF DC -Growth Studies 7610 RF DC -Transportation Services 7611 RF DC -Storm Water Mgmt City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast (80,000) (1,480,000) (480,000) (1,315,429) (24,800,000) (1,050,000) (4,971,600) (185,250) (21,955,000) (268,376) 7622 RF DC -Parks & Recreation Services 31,361,630 7630 RF DC -Library 15,223,761 7708 RF -Operations Centre 7709 RF -Roads & Bridges (3,650,000) 7710 RF -Stormwater Mgmt (1,254,500) 7713 RF -Seaton Land Grp FIA (55,750) Total Financing (160,297,974) 3 Run Date: Mar 15, 2022 2024 2025 2026 Forecast Forecast Forecast (1,767,275) (755,000) (1,300,000) (775,000) (200,000) (200,000) (200,000) (880,000) (520,000) (1,200,000) (4,759,000) (6,972,000) (4,167,000) (234,000) (3,223,000) (2,616,000) (5,690,365) (472,286) (2,729,250) (980,350) (2,329,500) (493,200) (504,365) (50,000) (300,000) (2,225,000) (1,225,000) (2,275,000) (1,160,000) (765,000) (917,000) (433,800) (50,750) (1,515,635) (66,659,300) (55,517,900) (133,131,550) Mayor & Council Summary Expenditures 6175 Hardware Replacements Total Expenditures Financing 2823 Paid from Property Taxes Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 70,000 70.000 (70,000) (70,000) 4 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 5111 Mayor Expenditures 6175 Hardware Replacements Total Expenditures Financing 2823 Paid from Property Taxes Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 10,000 10 000 (10,000) (10,000) 5 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 5111 Mayor 5111.2301 Computer Equipment Mayor 2823 Paid from Property Taxes 6175 Hardware Replacements City of Pickering 2023 Capital Forecast As per Council Compensation & Communication Policy (Subsection 12.1 ), $10,000 is provided for computer hardware, software and telecommunications per term. A.s per the policy, these funds can only be spent during the first 40 months of office. Total 5111.2301 Computer Equipment Mayor Total 5111 Mayor 6 Run Date: Feb 27, 2022 Funding Expense (10,000) 10,000 (10,000) 10,000 (10,000) 10,000 5113 Council Expenditures 6175 Hardware Replacements Total Expenditures Financing 2823 Paid from Property Taxes Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 60,000 60 000 (60,000) (60,000) 7 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast City of Pickering 2023 Capital Forecast 5113 Council 5113.2301 Computer Equip Reg. Coun. Ward 1 2823 Paid from Property Taxes 6175 Hardware Replacements As per Council Compensation & Communication Policy (Subsection 12.1), $10,000 is provided for computer hardware, software and telecommunications per term. As per the policy, these funds can only be spent during the first 40 months of office. Total 5113.2301 Computer Equip Reg. Coun. Ward 1 5113.2302 Computer Equip Reg. Coun. Ward 2 2823 Paid from Property Taxes 6175 Hardware Replacements As per Council Compensation & Communication Policy (Subsection 12.1), $10,000 is provided for computer hardware, software and telecommunications per term. As per the policy, these funds can only be spent during the first 40 months of office. Total 5113.2302 Computer Equip Reg. Coun. Ward 2 5113.2303 Computer Equip Reg. Coun. Ward 3 2823 Paid from Property Taxes 6175 Hardware Replacements As per Council Compensation & Communication Policy (Subsection 12.1), $10,000 is provided for computer hardware, software and telecommunications per term. As per the policy, these funds can only be spent during the first 40 months of office. Total 5113.2303 Computer Equip Reg. Coun. Ward 3 5113.2304 Computer Equip City Coun. Ward 1 2823 Paid from Property Taxes 6175 Hardware Replacements As per Council Compensation & Communication Policy (Subsection 12.1), $10,000 is provided for computer hardware, software and telecommunications per term. As per the policy, these funds can only be spent during the first 40 months of office. Total 5113.2304 Computer Equip City Coun. Ward 1 5113.2305 Computer Equip City Coun. Ward 2 2823 Paid from Property Taxes 6175 Hardware Replacements 8 Run Date: Feb 27, 2022 Funding Expense (10,000) 10,000 (10,000) 10,000 (10,000) 10,000 (10,000) 10,000 (10,000) 10,000 (10,000) 10,000 (10,000) 10,000 (10,000) 10,000 (10,000) 10,000 5113 Council City of Pickering 2023 Capital Forecast As per Council Compensation & Communication Policy (Subsection 12.1), $10,000 is provided for computer hardware, software and telecommunications per term. As per the policy, these funds can only be spent during the first 40 months of office. Total 5113.2305 Computer Equip City Coun. Ward 2 5113.2306 Computer Equip City Coun. Ward 3 2823 Paid from Property Taxes 6175 Hardware Replacements As per Council Compensation & Communication Policy (Subsection 12.1 ), $10,000 is provided for computer hardware, software and telecommunications per term. As per the policy, these funds can only be spent during the first 40 months of office. Total 5113.2306 Computer Equip City Coun. Ward 3 Total 5113 Council 9 Run Date: Feb 27, 2022 Funding Expense (10,000) 10,000 (10,000) 10,000 (10,000) 10,000 (60,000) 60,000 City of Pickering Multi-Year Capital Forecast 2023 -2026 Office of the CAO Dept. Summary 2023 Forecast Expenditures 6178 Machinery & Equipment 84,000 6230 Prof/Consulting Fees 12,537,997 6231 City Project Mgmt. Fees 1,725,000 6250 Construction Costs 42,434,877 6260 Other Construction Related Costs (7,213,000) Total Expenditures 49.568 874 Financing 1610 Federal Grants (42,000) 1705 Debt -25 Year (5,587,688) 1725 DC Debt-25 Year (Transportation) (4,426,340) 1733 DC Debt-25 Year (Library) (19,360,817) 1743 DC Debt-25 Year (Parks & Rec) (64,506,553) 7050 R -Senior Centre (4,177,688) 7066 R -Library Building (480,000) 7067 R -Casino (830,429) 7505 RF -Federal Gas Tax (42,000) 7610 RF DC -Transportation Services 600,000 7622 RF DC -Parks & Recreation Services 34,060,880 7630 RF DC -Library 15,223,761 Total Financing (49,568,874) 10 Run Date: Mar 15, 2022 2024 2025 2026 Forecast Forecast Forecast 170,000 175,000 180,000 170 000 175.000 180 000 (170,000) (175,000) (180,000) (170,000) (175,000) (180,000) City of Pickering Multi-Year Capital Forecast 2023 -2026 57 40 City Centre Project (Alphabetical Order) 2023 Forecast Expenditures 6230 Prof/Consulting Fees 12,537,997 6231 City Project Mgmt. Fees 1,725,000 6250 Construction Costs 42,434,877 6260 Other Construction Related Costs (7,213,000) Total Expenditures 49 484 874 Financing 1705 Debt -25 Year (5,587,688) 1725 DC Debt -25 Year (Transportation) (4,426,340) 1733 DC Debt-25 Year (Library) (19,360,817) 1743 DC Debt -25 Year (Parks & Rec) (64,506,553) 7050 R -Senior Centre (4,177,688) 7066 R -Library Building (480,000) 7067 R -Casino (830,429) 7610 RF DC -Transportation Services 600,000 7622 RF DC -Parks & Recreation Services 34,060,880 7630 RF DC -Library 15,223,761 Total Financing (49,484,874) 10 Run Date: Mar 15, 2022 2024 2025 2026 Forecast Forecast Forecast City of Pickering 2023 Capital Forecast 57 40 City Centre Project (Alphabetical Order) 5740.2301 Bridge Link 1705 Debt-25 Year 6230 Prof/Consulting Fees 6231 City Project Mgmt. Fees 6250 Construction Costs Decrease in funding and change in financing for construction and design costs of an enclosed pedestrian bridge between the new Central Library and Senior & Youth Centre and any related fees. Project approved in 2020 Capital budget (5740.2004 ). Total project cost decreased to $1,243,912. 7050 R -Senior Centre 7067 R -Casino 7622 RF DC -Parks & Recreation Services 7630 RF DC -Library Total 5740.2301 Bridge Link 5740.2302 New Central Library 1705 Debt -25 Year 1733 DC Debt-25 Year (Library) 6230 Prof/Consulting Fees 6231 City Project Mgmt. Fees 6250 Construction Costs Additional funding and change in financing for construction and design costs of a new 53,000 square foot Central Library and any related fees. Project approved in 2020 Capital budget (5740.2002). Total project cost increased to $47,398,252. 6260 Other Construction Related Costs 7066 R -Library Building 7067 R -Casino 7630 RF DC -Library Total 5740.2302 New Central Library 5740.2303 Performing Arts Centre (PAC) 1705 Debt-25 Year 17 43 DC Debt -25 Year (Parks & Rec) 6230 Prof/Consulting Fees 6231 City Project Mgmt. Fees 6250 Construction Costs 10 Run Date: Mar 14, 2022 Funding Expense 1,989,000 (289,006) 9,912 (4,096,377) (352,259) (2,716) 1,207,685 1,533,761 4,375,471 (4,375,471) (4,644,812) (19,360,817) 3,772,142 380,352 12,779,439 (2,609,000) (480,000) (199,304) 10,362,000 (14,322,933) 14,322,933 (4,177,951) (16,585,730) 4,544,667 607,968 7,909,724 City of Pickering 2023 Capital Forecast 5740 City Centre Project (Alphabetical Order) Additional funding and change in financing for construction and design costs of a new 600 seat, 50,000 square foot Performing Arts Centre and any related fees. Includes Furniture & Fixtures. Project approved in 2020 Capital budget (5740.2001). Total project cost increased to $70,157,968. 6260 Other Construction Related Costs 7050 R -Senior Centre 7067 R -Casino 7622 RF DC -Parks & Recreation Services Total 5740.2303 Performing Arts Centre (PAC) 5740.2304 Phase 1 Service Relocations 1705 Debt-25 Year 1725 DC Debt -25 Year (Transportation) 6230 Prof/Consulting Fees 6231 City Project Mgmt. Fees 6250 Construction Costs Additional funding and change in financing for construction and design costs for relocation of existing underground municipal services from the Pickering Town Centre lands to be relocated to Glenanna ·Road and any related fees. Project approved in 2020 Capital budget (5740.2006). Total project cost increased to $7,549,648. 7067 R -Casino 7610 RF DC -Transportation Services Total 5740.2304 Phase 1 Service Relocations 5740.2305 Public Realm (City Lands) 1705 Debt -25 Year 6230 Prof/Consulting Fees 6231 City Project Mgmt. Fees 6250 Construction Costs Construction and design costs for public realm area extending from the public square to continue through South Esplanade and Esplanade Park to the CHDRC and any related fees. Includes Furniture & Fixtures. 7067 R -Casino 7622 RF DC -Parks & Recreation Services Total 5740.2305 Public.Realm (City Lands) 10 Run Date: Mar 14, 2022 Funding Expense (2,003,000) (2,500,000) (484,678) 12,689,000 (11,059,359) 11,059,359 3,790,800 (4,426,340) 658,900 60,648 (658,900) (25,108) 600,000 (60,648) 60,648 (6,411,800) 652,100 55,440 6,209,700 (51,781) (453,659) (6,917,240) 6,917,240 City of Pickering 2023 Capital Forecast 57 40 City Centre Project {Alphabetical Order) 5740.2306 Public Square 1705 Debt -25 Year 6230 Prof/Consulting Fees 6231 City Project Mgmt. Fees 6250 Construction Costs Construction and design costs for public square that connects the Central Library, Seniors & Youth Centre and Performing Arts Centre and any related fees. Includes Furniture & Fixtures. 7067 R -Casino 7622 RF DC -Parks & Recreation Services Total 5740.2306 Public Square 5740.2307 Senior & Youth Centre (S&Y) 1705 Debt -25 Year 1743 DC Debt -25 Year (Parks & Rec) 6230 Prof/Consulting Fees 6231 City Project Mgmt. Fees 6250 Construction Costs Additional funding and change in financing for construction and design costs of a new 65,000 square foot Senior & Youth Centre and any related fees. Includes Furniture & Fixtures. Project approved in 2020 Capital budget (5740.2003 ). Total project cost increased to $43,386,646. 6260 Other Construction Related Costs 7050 R -Senior Centre 7067 R -Casino 7622 RF DC -Parks & Recreation Services Total 5740.2307 Senior & Youth Centre (S&Y) 5740.2308 Underground Parking Garage 1705 Debt-25 Year 6230 Prof/Consulting Fees 6231 City Project Mgmt. Fees 6250 Construction Costs Decrease in funding and change in financing for construction and design costs of City Centre underground parking (331 City parking spaces) and any related fees. Project approved in 2020 Capital budget (5740.2005). Total project cost decreased to $26,744,036. 10 Run Date: Mar 14, 2022 Funding Expense (2,741,445) 630,462 48,048 5,716,957 (20,757) (3,633,265) (6,395,467) 6,395,467 5,058,000 (47,920,823) 1,990,831 348,096 8,227,724 (2,601,000) (1,325,429) (9,399) 36,232,000 (7,965,651) 7,965,651 1,550,520 577,901 214,536 6,346,610 City of Pickering 2023 Capital Forecast 5740 City Centre Project (Alphabetical Order) 7067 R -Casino 7622 RF DC -Parks & Recreation Services 7630 RF DC -Library Total 5740.2308 Underground Parking Garage Total 5740 City Centre Project (Alphabetical Order) 10 Run Date: Mar 14, 2022 Funding Expense (36,686) (11,980,881) 3,328,000 (7,139,047) 7,139,047 (49,484,874) 49,484,874 5192 Corporate Projects Expenditures 6178 Machinery & Equipment Total Expenditures Financing 1610 Federal Grants 7505 RF -Federal Gas Tax Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 84,000 84 000 (42,000) (42,000) (84,000) 1 1 Run Date: Feb 28, 2022 2024 2025 2026 Forecast Forecast Forecast 170,000 175,000 180,000 170.000 175 000 180.000 (170,000) (175,000) (180,000) (170,000) (175,000) (180,000) 5192 Corporate Projects 5192.2301 EV Charging Stations 161 0 Federal Grants 6178 Machinery & Equipment City of Pickering 2023 Capital Forecast EV Charging Stations (1x dual charging station). Location to be determined and the project cost excludes the cost of any electrical retrofits or enhancements to existing electrical infrastructure. Subject to receiving senior government funding. 7505 RF -Federal Gas Tax Total 5192.2301 EV Charging Stations Total 5192 Corporate Projects 1 2 Run Date: Feb 27, 2022 Funding Expense (42,000) 84,000 (42,000) (84,000) 84,000 (84,000) 84,000 5192 Corporate Projects 5192.2401 EV Charging Stations 6178 Machinery & Equipment City of Pickering 2024 Capital Forecast EV Charging Stations (2x dual charging station). Location to be determined and the project cost excludes the cost of any electrical retrofits or enhancements to existing electrical infrastructure. 7505 RF -Federal Gas Tax Total 5192.2401 EV Charging Stations Total 5192 Corporate Projec,ts 13 Run Date: Feb 27, 2022 Funding Expense 170,000 (170,000) (170,000) 170,000 (170,000) 170,000 5192 Corporate Projects 5192.2501 EV Charging Stations 6178 Machinery & Equipment City of Pickering 2025 Capital Forecast EV Charging Stations {2x dual charging station). Location to be determined and the project cost excludes the cost of any electrical retrofits or enhancements to existing electrical infrastructure. 7505 RF -Federal Gas Tax Total 5192.2501 EV Charging Stations Total 5192 Corporate Projects 14 Run Date: Feb 27, 2022 Funding Expense 175,000 (175,000) (175,000) 175,000 (175,000) 175,000 5192 Corporate Projects 5192.2601 EV Charging Stations 6178 Machinery & Equipment City of Pickering 2026 Capital Forecast EV Charging Stations (2x dual charging station). Location to be determined and the project cost excludes the cost of any electrical retrofits or enhancements to existing electrical infrastructure. 7505 RF -Federal Gas Tax Total 5192.2601 EV Charging Stations Total 5192 Corporate Projects 15 Run Date: Feb 28, 2022 Funding Expense 180,000 (180,000) (180,000) 180,000 (180,000) 180,000 City of Pickering Multi-Year Capital Forecast 2023 -2026 Community Services Dept. Summary 2023 Forecast Expenditures 6149 Restoration -Museum Bldg 6173 Furniture & Fixtures 25,000 6178 Machinery & Equipment 6183 Accessibility 30,000 6230 Prof/Consulting Fees 1,671,000 6400 Building Related -Seaton 6430 Prof/Consult Fees -Seaton 6483 Accessibility -Seaton 6500 Building Related 4,674,100 Total Expenditures 6.400 100 Financing 1592 Donations 1594 Sale of Land 1701 Debt -5 Year (902,000) 1702 Debt-10 Year (1,905,000) 1703 Debt 15 Year 1704 Debt -20 year 1711 Internal Loan -5 Year (674,500) 1712 Internal Loan-10 Year 1742 DC Debt -20 Year (Parks & Rec) 2823 Paid from Property Taxes (234,000) 7021 R Rate Stabilization (1,442,000) 7034 R -R/Cmplex Core Surcharge 7036 R -R/Cmplx Arena Surcharge 7053 R Sustainability Initiatives 7055 R -Facilities (120,000) 7060 R -Seaton Land Grp FIA 7067 R -Casino (485,000) 7505 RF -Federal Gas Tax (637,600) 7713 RF -Seaton Land Grp FIA Total Financing (6,400,100) 16 Run Date: Mar 15, 2022 2024 2025 2026 Forecast Forecast Forecast 734,000 477,000 25,000 25,000 576,800 45,000 45,000 20,000 1,340,000 150,000 871,500 670,500 107,750 72,430,000 12,930,000 1,000,000 6,025,200 26,603,500 5,952,000 20.605 700 29161 000 80 261.550 (200,000) (257,500) (2,060,000) (530,000) (792,000) (2,505,000) (400,000) (1,339,000) (3, 188,000) (18,597,000) (2,160,000) (1,259,000) (1,843,000) (576,800) (1,146,700) (165,000) (12,606,750) (71,699,725) (538,500) {492,500) (267,750) (93,000) (45,000) (45,000) (97,000) (21,500) (350,000) (1,730,275) (349,000) (3,125,000) (1,225,000) (323,250) (20,605,700) (29,161,000) (80,261,550) 5700 Civic Complex Expenditures 6173 Furniture & Fixtures 6183 Accessibility 6230 Prof/Consulting Fees 6500 Building Related Total Expenditures Financing 1701 Debt -5 Year 1703 Debt-15 Year 1704 Debt -20 year 1711 Internal Loan -5 Year 1712 Internal Loan-10 Year 2823 Paid from Property Taxes 7021 R -Rate Stabilization 7505 RF -Federal Gas Tax Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 25,000 1,442,000 345,000 1 812 000 (190,000) (155,000) (25,000) (1,442,000) (1,812,000) 17 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 25,000 25,000 576,800 1,090,000 4,673,700 16,884,000 35,000 4 698 700 17 999 000 611 800 (382,000) (1,339,000) (3,188,000) (14,935,000) (275,000) (370,000) (576,800) (1,146,700) (25,000) (67,000) (35,000) (64,000) (906,000) (4,698,700) (17,999,000) (611,800) 5700 Civic Complex City of Pickering 2023 Capital Forecast 5700.2301 Civic Complex Renovations and Addition -Design 6230 Prof/Consulting Fees Preliminary investigations, concept, detailed design and consulting budget for overall renovations to the Civic Complex, including a new enclosed lobby and consolidated service area on the ground floor between the existing city hall and library. This project will include renovations to major building areas and systems, and incorporate lifecycle replacement of many aging interior and exterior building components and finishes. 7021 R -Rate Stabilization Total 5700.2301 Civic Complex Renovations and Addition -Desigr 5700.2302 Workstations, Partitions, Tables, Shelving 2823 Paid from Property Taxes 6173 Furniture & Fixtures Replacement of original and worn furniture, some over 25 years old. Spare parts are no longer available as original furniture manufacturer is no longer in business. Includes replacement of existing furniture in poor repair. Total 5700.2302 Workstations, Partitions, Tables, Shelving 5700.2303 Low Pressure Steam Boilers Replacement 1711 Internal Loan -5 Year 6500 Building Related Lifecycle replacement of existing steam boilers installed in 2009. Total 5700.2303 Low Pressure Steam Boilers Replacement 5700.2304 Server Room Upgrades 1701 Debt-5 Year 6500 Building Related Lifecycle replacement of existing access flooring, rooftop air conditioning units and other related systems. Total 5700.2304 Server Room Upgrades Total 5700 Civic Complex 18 Run Date: Feb 27, 2022 Funding Expense 1,442,000 (1,442,000) (1,442,000) 1,442,000 (25,000) 25,000 (25,000) 25,000 (155,000) 155,000 (155,000) 155,000 (190,000) 190,000 (190,000) 190,000 (1,812,000) 1,812,000 City of Pickering 2024 Capital Forecast 5700 Civic Complex 5700.2401 Generator Replacement -Construction 1704 Debt -20 year 6500 Building Related Construction budget for the replacement of the existing backup power generator and related systems. Includes increasing the capacity of the existing and expanding backup power coverage throughout the Civic Complex. Total 5700.2401 Generator Replacement -Construction 5700.2402 Workstations, partitions, tables, shelving 2823 Paid from Property Taxes 6173 Furniture & Fixtures Replacement of original and worn furniture, some nearly 30 years old. Spare parts are no longer available as original furniture manufacturer is no longer in business. Includes replacement of existing furniture in poor repair. Total 5700.2402 Workstations, partitions, tables, shelving 5700.2403 Heater Replacements 6500 Building Related Lifecycle replacement of existing unit heaters and water heaters. Installation dates vary. 7505 RF -Federal Gas Tax Total 5700.2403 Heater Replacements 5700.2404 Exterior Window Replacement 1712 Internal Loan-10 Year 6500 Building Related Lifecycle replacement of existing exterior windows and frames. Existing units are original, in stalled in 1990. Includes replacement of curtain wall and sliding doors at main entrance. Total 5700.2404 Exterior Window Replacement 5700.2405 Central Tower Renovations 1704 Debt -20 year 6500 Building Related 1 9 Run Date: Feb 27, 2022 Funding Expense (1,540,000) 1,540,000 (1,540,000) 1,540,000 (25,000) 25,000 (25,000) 25,000 64,000 (64,000) (64,000) 64,000 (745,000) 745,000 (745,000) 745,000 (1,648,000) 1,648,000 City of Pickering 2024 Capital Forecast 5700 Civic Complex Lifecycle replacement of major building components on the interior and exterior of the central tower structure, including metal roof, windows and other components at end of life. The central tower contains more of the major mechanical equipment required by City Hall and the Library, and was constructed in 1990. All related work is being combined to avoid repeated expense for the extensive scaffolding required to complete the various scopes of work. Total 5700.2405 Central Tower Renovations 5700.2406 Parking Garage Retrofit & Repairs 1712 Internal Loan-10 Year 6500 Building Related Various repairs and lifecycle replacements of existing systems in the underground parking garage. Includes: overhead doors, CO monitoring systems, waterproofing repairs, heaters, line painting, and other related work. Total 5700.2406 Parking Garage Retrofit & Repairs 5700.2407 Security Upgrades 1711 Internal Loan -5 Year 6500 Building Related Installation of new and upgrades to existing security systems, including digital access controls, cameras and other related systems. Total 5700.2407 Security Upgrades 5700.2408 Exhaust Fan Replacements 1711 Internal Loan -5 Year 6500 Building Related Lifecycle replacement of existing exhaust fans Total 5700.2408 Exhaust Fan Replacements Total 5700 Civic Complex 20 Run Date: Feb 27, 2022 Funding Expense (1,648,000) 1,648,000 (401,700) 401,700 (401,700) 401,700 (190,000) 190,000 (190,000) 190,000 (85,000) 85,000 (85,000) 85,000 (4,698,700) 4,698,700 5700 Civic Complex City of Pickering 2025 Capital Forecast 5700.2501 Air Controls Compressor & Dryer Fan Replacement 2823 Paid from Property Taxes 6500 Building Related Lifecycle replacement of existing air controls compressor and dryer fan. Units are original, installed in 1990. Total 5700.2501 Air Controls Compressor & Dryer Fan Replaceme, 5700.2502 Workstations, partitions, tables, shelving 2823 Paid from Property Taxes 6173 Furniture & Fixtures Replacement of original and worn furniture, some nearly 30 years old. Spare parts are no longer available as original furniture manufacturer is no longer in business. Includes replacement of existing furniture in poor repair. Total 5700.2502 Workstations, partitions, tables, shelving 5700.2503 Air Handling Units -SF3 + RF3 Replacement 6500 Building Related Lifecycle replacement of supply fan SF-3 and return fan RF-3 serving the council chambers in city hall, including controls upgrade. Both are original equipment installed in 1990. 7505 RF -Federal Gas Tax Total 5700.2503 Air Handling Units -SF3 + RF3 Replacement 5700.2504 Elevator Upgrades 1711 Internal Loan -5 Year 6183 Accessibility 6500 Building Related Lifecycle retrofit and accessibility upgrades to the existing City Hall elevator. Total 5700.2504 Elevator Upgrades 5700.2505 Building Automation Upgrades 1711 Internal Loan -5 Year 6500 Building Related Lifecycle upgrades to building automation controls and equipment. Total 5700.2505 Building Automation Upgrades 5700.2506 Washroom Renovations 1701 Debt-5 Year 21 Run Date: Feb 27, 2022 Funding Expense (42,000) 42,000 (42,000) 42,000 (25,000) 25,000 (25,000) 25,000 185,000 (185,000) (185,000) 185,000 (240,000) 40,000 200,000 (240,000) 240,000 (130,000) 130,000 (130,000) 130,000 (382,000) 5700 Civic Complex 6183 Accessibility 6500 Building Related City of Pickering 2025 Capital Forecast Lifecycle replacement of fixtures and finished in existing public washrooms on the upper floor, and staff washrooms on the ground and upper floor. Total 5700.2506 Washroom Renovations 5700.2507 Civic Complex Renovations and Addition -Construction 1704 Debt -20 year 6183 Accessibility 6500 Building Related Construction budget for overall renovations to the Civic Complex (City Hall and Library sides). This project will include localized renovations to building areas and systems, and incorporate limited lifecycle replacement of aging interior building components and finishes. Total 5700.2507 Civic Complex Renovations and Addition -Const, 5700.2508 Site Works Upgrades and Replacements 1703 Debt-15 Year 6500 Building Related Lifecycle replacement of existing site work components, including: stairs, curbs, sidewalks, roadways, flagpoles. Landscaping, irrigation, street furniture and related components. Total 5700.2508 Site Works Upgrades and Replacements 5700.2509 LED Lighting Conversion and Ceiling Upgrades 6500 Building Related Replacement of existing fluorescent and other lighting systems with LED, including related ceiling repairs and modifications. 7505 RF -Federal Gas Tax Tota.I 5700.2509 LED Lighting Conversion and Ceiling Upgrades Total 5700 Civic Complex 22 Run Date: Feb 27, 2022 Funding Expense 50,000 332,000 (382,000) 382,000 (14,935,000) 1,000,000 13,935,000 (14,935,000) 14,935,000 (1,339,000) 1,339,000 (1,339,000) 1,339,000 721,000 (721,000) (721,000) 721,000 (17,999,000) 17,999,000 5700 Civic Complex 5700.2601 Gas Monitor Replacement 2823 Paid from Property Taxes 6500 Building Related City of Pickering 2026 Capital Forecast Lifecycle replacement of existing gas monitors. Total 5700.2601 Gas Monitor Replacement 5700.2602 Civic Complex Renovations -FF&E . 1711 Internal Loan -5 Year 6173 Furniture & Fixtures Furniture, fixtures and equipment for Civic Complex Renovations and Addition. Total 5700.2602 Civic Complex Renovations -FF&E Total 5700 Civic Complex 23 Run Date: Feb 27, 2022 Funding Expense (35,000) 35,000 (35,000) 35,000 (576,800) 576,800 (576,800) 576,800 (611,800) 611,800 5701 Senior Citizens Centre Expenditures 6230 Prof/Consulting Fees 6500 Building Related Total Expenditures Financing 1594 Sale of Land Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 24 Run Date: Mar 15, 2022 2024 2025 2026 Forecast Forecast Forecast 257,500 2,060,000 257,500 2 060 000 (257,500) (2,060,000) (257,500) (2,060,000) I I I . I I I 5701 Senior Citizens Centre City of Pickering 2025 Capital Forecast 5701.2501 ESCC Remediation & Decommissioning -Work Plan 1594 Sale of Land 6230 Prof/Consulting Fees East Shore Community Centre demolition & remediation plan, excluding lawn bowling club, shed and greens. Total 5701.2501 ESCC Remediation & Decommissioning -Work Pl Total 5701 Senior Citizens Centre 25 Run Date: Mar 14, 2022 Funding Expense (257,500) 257,500 (257,500) 257,500 (257,500) 257,500 5701 Senior Citizens Centre City of Pickering 2026 Capital Forecast 5701.2601 ESCC Remediation & Decommissioning • Construction 1594 Sale of Land 6500 Building Related East Shore Community Centre demolition & remediation plan, excluding lawn bowling club, shed and greens. Total 5701.2601 ESCC Remediation & Decommissioning -Constru Total 5701 Senior Citizens Centre 26 Run Date: Mar 14, 2022 Funding Expense (2,060,000) 2,060,000 (2,060,000) 2,060,000 (2,060,000) 2,060,000 5713 Dunbarton Pool Expenditures 6500 Building Related Total Expenditures Financing 1711 Internal Loan -5 Year Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 123,500 123 500 (123,500) (123,500) 27 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 5713 Dunbarton Pool 5713.2302 Pool Structural Steel Coating 1711 Internal Loan -5 Year 6500 Building Related City of Pickering 2023 Capital Forecast Selective repairs and application of protective coatings to structural steel to extend asset life. The existing structure was installed in 1970. Total 5713.2302 Pool Structural Steel Coating Total 5713 Dunbarton Pool 28 Run Date: Feb 27, 2022 Funding Expense (123,500) 123;500 (123,500) 123,500 (123,500) 123,500 5715 Don Beer Arena Expenditures 6230 Prof/Consulting Fees 6500 Building Related Total Expenditures Financing 1711 Internal Loan -5 Year 7505 RF -Federal Gas Tax Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 432,600 432,600 (432,600) (432,600) 29 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 25,000 319,000 344 000 (204,000) (140,000) (344,000) 5715 Don Beer Arena City of Pickering 2023 Capital Forecast 5715.2301 Rink 1 & 2 Refrigeration Plant -Construction 6500 Building Related Construction costs for replacement of existing compressors. Existing equipment was installed over various years, but is collectively nearing end of life. 7505 RF -Federal Gas Tax Total 5715.2301 Rink 1 & 2 Refrigeration Plant -Construction Total 5715 Don Beer Arena 30 Run Date: Feb 27, 2022 Funding Expense 432,600 (432,600) (432,600) 432,600 (432,600) 432,600 5715 Don Beer Arena City of Pickering 2024 Capital Forecast 5715.2401 Rink 3 Refrigeration Plant Upgrades (Phase 2) 6230 Prof/Consulting Fees 6500 Building Related Design and construction costs for required lifecycle replacements to the Rink 3 refrigeration plant. The plant was originally installed in 2002, and major components are at end of life. Includes related upgrades for regulatory compliance. 7505 RF -Federal Gas Tax Total 5715.2401 Rink 3 Refrigeration Plant Upgrades (Phase 2) 5715.2402 Rink 1 Skate Tile Replacement 1711 Internal Loan -5 Year 6500 Building Related Lifecycle replacement of existing rubber flooring in and adjoining to Rink #1. The existing flooring was installed in 2009. Total 5715.2402 Rink 1 Skate Tile Replacement Total 5715 Don Beer Arena 31 Run Date: Feb 27, 2022 Funding Expense 25,000 115,000 (140,000) (140,000) 140,000 (204,000) 204,000 (204,000) 204,000 (344,000) 344,000 5719 Community Centres Expenditures 6230 Prof/Consulting Fees 6500 Building Related Total Expenditures Financing 1702 Debt -10 Year 1711 Internal Loan -5 Year 2823 Paid from Property Taxes 7053 R -Sustainability Initiatives 7055 R -Facilities 7505 RF -Federal Gas Tax Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 160,000 336,000 496 000 (176,000) (40,000) (120,000) (160,000) (496,000) 32 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 110,500 518,500 1,467,500 95,000 629 000 1467500 95 000 (395,000) (745,000) (207,500) (93,500) (80,000) (21,500) (350,000) (50,000) (234,000) (15,000) (629,000) (1,467,500) (95,000) City of Pickering 2023 Capital Forecast 5719 Community Centres 5719.2301 WCC Restoration -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees WCC Restoration -Design Total 5719.2301 wee Restoration -Design 5719.2302 GALCC AC2 & AC1 Replacement 6500 Building Related Lifecycle replacement of seniors room air conditioning unit and controls at the George Ashe Library and Community Centre. The unit is original, installed in 2000. 7505 RF -Federal Gas Tax Total 5719.2302 GALCC AC2 & AC1 Replacement 5719.2303 Mt.Zion Restoration (Phase Two) 1711 Internal Loan -5 Year 6500 Building Related General repairs and restoration to the overall building Total 5719.2303 Mt.Zion Restoration (Phase Two) 5719.2304 GWCC Remediation and Demolition -Design 6230 Prof/Consulting Fees Greenwood Community Centre demolition & remediation plan. Design and testing only. 7055 R -Facilities Total 5719.2304 GWCC Remediation and Demolition -Design Total 5719 Community Centres 33 Run Date: Feb 27, 2022 Funding Expense (40,000) 40,000 (40,000) 40,000 160,000 (160,000) (160,000) 160,000 (176,000) 176,000 (176,000) 176,000 120,000 (120,000) (120,000) 120,000 (496,000) 496,000 City of Pickering 2024 Capital Forecast 5719 Community Centres 5719.2401 TCC Flooring Replacement (Seniors & Library) 2823 Paid from Property Taxes 6500 Building Related Ufecycle replacement of existing flooring in the branch library and seniors rooms. Includes temporary furniture and appliance relocation. Total 5719.2401 TCC Flooring Replacement (Seniors & Library) 5719.2402 GALCC Alarm System Upgrades 2823 Paid from Property Taxes 6500 Building Related Ufecycle upgrades to existing fire and security alarm system hardware at the George Ashe Library and Community Centre. Total 5719.2402 GALCC Alarm System Upgrades 5719.2403 GALCC Parking Lot Resurfacing -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees Consulting budget for resurfacing of the existing parking lot at GALCC. Includes pre-construction testing & inspection. Total 5719.2403 GALCC Parking Lot Resurfacing -Design 5719.2404 TCC Stage Lighting Replacement 6500 Building Related Ufecycle replacement of existing stage lighting. Includes allowance to upgrade or replace supporting structure. 7505 RF -Federal Gas Tax Total 5719.2404 TCC Stage Lighting Replacement 5719.2405 GWCC Remediation and Demolition -Construction 6500 Building Related Greenwood Community Centre demolition & remediation. 7055 R -Facilities Total 5719.2405 GWCC Remediation and Demolition -Constructio 5719.2406 GALCC Convert Lighting to LED -Design 6500 Building Related Design to convert existing interior and exterior light fixtures to LED. Existing poles and bases will be retained. 7053 R -Sustainability Initiatives 34 Run Date: Feb 27, 2022 Funding Expense (40,000) 40,000 (40,000) 40,000 (57,000) 57,000 (57,000) 57,000 (53,500) 53,500 (53,500) 53,500 50,000 (50,000) (50,000) 50,000 350,000 (350,000) (350,000) 350,000 21,500 (21,500) 5719 Community Centres City of Pickering 2024. Capital Forecast Total 5719.2406 GALCC Convert Lighting to LED -Design 5719.2407 GALCC East Wall Replacement Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees Reconstruction of the east exterior wall at the George Ashe Library and Community Centre, including re-grading, walkway repairs, window replacements, roofing, roof screens, and drainage repairs required to address ongoing water infiltration. Design and testing only. Total 5719.2407 GALCC East.Wall Replacement Design Total 5719 Community Centres 35 Run Date: Feb 27, 2022 Funding Expense (21,500) 21,500 (57,000) 57,000 (57,000) 57,000 (629,000) 629,000 5719 Community Centres City of Pickering 2025 Capital Forecast 5719.2501 GALCC Kitchen Exhaust & Hood Replacement 2823 Paid from Property Taxes 6500 Building Related Lifecycle replacement of existing kitchen hood exhaust fan originally installed in 2000. Total 5719.2501 GALCC Kitchen Exhaust & Hood Replacement 5719.2502 Northern Facilities -Potable Water Systems Replacemer 6500 Building Related Lifecycle replacement of drinking water treatment systems at· northern community centres. 7505 RF -Federal Gas Tax Total 5719.2502 Northern Facilities -Potable Water Systems Repla 5719.2503 TCC Kitchen Retrofit 2823 Paid from Property Taxes 6500 Building Related Lifecycle replacement of existing kitchen counters, flooring and appliances, including upgrades to exhaust systems. Originally installec:1 in 1997. Total 5719.2503 TCC Kitchen Retrofit 5719.2504 GALCC Parking Lot Resurfacing -Construction 1711 Internal Loan -5 Year 6500 Building Related Lifecycle replacement of top coat asphalt, including curb repairs, line painting, sidewalk and ramp repairs. Total 5719.2504 GALCC Parking Lot Resurfacing -Construction 5719.2505 GALCC Convert Lighting to LED -Construction 6500 Building Related Convert existing interior and exterior light fixtures to LED. Existing poles and bases will be retained. 7505 RF -Federal Gas Tax Total 5719.2505 GALCC Convert Lighting to LED -Construction 5719.2506 GALCC East Wall Replacement -Construction 1702 Debt-10 Year 6500 Building Related 36 Run Date: Feb 27, 2022 Funding Expense (20,000) 20,000 (20,000) 20,000 40,000 (40,000) (40,000) 40,000 (73,500) 73,500 (73,500) 73,500 (575,000) 575,000 (575,000) 575,000 194,000 (194,000) (194,000) 194,000 (395,000) 395,000 5719 Community Centres City of Pickering 2025 Capital Forecast Reconstruction of the east exterior wall at the George Ashe Library and Community Centre, including re-grading, walkway repairs, window replacements, roofing, roof screens, and drainage repairs required to address ongoing water infiltration. Total 5719.2506 GALCC East Wall Replacement -Construction 5719.2507 wee Restoration -Construction 1711 Internal Loan -5 Year 6500 Building Related wee Restoration -Construction Total 5719.2507 WCC Restoration -Construction Total 5719 Community Centres 37 Run Date: Feb 27, 2022 Funding Expense (395,000) 395,000 (170,000) 170,000 (170,000) 170,000 (1,467,500) 1,467,500 City of Pickering 2026 Capital Forecast 5719 Community Centres 5719.2601 GALCC Interior Retrofit -Design 2823 Paid from Property Taxes 6500 Building Related GALCC Interior Retrofit -Design Total 5719.2601 GALCC Interior Retrofit -Design 5719.2602 TCC Windows Investigation & Design 2823 Paid from Property Taxes 6500 Building Related TCC Windows Investigation & Design Total 5719.2602 TCC Windows Investigation & Design 5719.2603 WSCC Air Conditioners Replacement 6500 Building Related WSCC Air Conditioners Replacement 7505 RF -Federal Gas Tax Total 5719.2603 WSCC Air Conditioners Replacement Total 5719 Community Centres 38 Run Date: Feb 27, 2022 Funding Expense (50,000) 50,000 (50,000) 50,000 (30,000) 30,000 (30,000) 30,000 15,000 (15,000) (15,000) 15,000 (95,000) 95,000 5720 Seaton Community Centre Expenditures 6400 Building Related -Seaton 6430 Prof/Consult Fees -Seaton 6483 Accessibility -Seaton Total Expenditures Financing 1742 DC Debt-20 Year (Parks & Rec) 7060 R -Seaton Land Grp FIA 7713 RF -Seaton Land Grp FIA Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 39 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 72,430,000 12,930,000 1,000,000 12.930 000 73 430 000 (12,606,750) (71,699,725) (1,730,275) (323,250) (12,930,000) (73,430,000) City of Pickering 2024 Capital Forecast 5720 Seaton Community Centre 5720.2401 Seaton Community Centre -Design 1742 DC Debt-20 Year (Parks & Rec) 6430 Prof/Consult Fees -Seaton Seaton Community Centre -Design 7713 RF -Seaton Land Grp FIA Total 5720.2401 Seaton Community Centre -Design Total 5720 Seaton Community Centre 40 Run Date: Feb 27, 2022 Funding Expense (12,606,750) 12,930,000 (323,250) (12,930,000) 12,930,000 (12,930,000) 12,930,000 City of Pickering 2026 Capital Forecast 5720 Seaton Community Centre 5720.2601 Seaton Community Centre -Construction 1742 DC Debt -20 Year (Parks & Rec) 6400 Building Related -Seaton Seaton Community Centre -Construction 6483 Accessibility -Seaton Project will include accessibility upgrades 7060 R -Seaton Land Grp FIA Total 5720.2601 Seaton Community Centre -Construction Total 5720 Seaton Community Centre 41 Run Date: Feb 27, 2022 Funding Expense (71,699,725) 72,430,000 1,000,000 (1,730,275) (73,430,000) 73,430,000 (73,430,000) 73,430,000 5731 Rec.Complex-Core Expenditures 6178 Machinery & Equipment 6183 Accessibility 6230 Prof/Consulting Fees 6500 Building Related Total Expenditures Financing 1701 Debt -5 Year 1702 Debt -10 Year 1711 Internal Loan -5 Year 2823 Paid from Property Taxes 7034 R -R/Cmplex Core Surcharge 7505 RF -Federal Gas Tax Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 30,000 2,952,000 2 982 000 (712,000) (1,905,000) (220,000) (100,000) (45,000) (2,982,000) 42 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 45,000 45,000 102,000 53,000 514,000 4,575,000 1,705,000 616 000 4 673 000 1.750 000 (410,000) (2,110,000) (400,000) (276,000) (152,000) (193,000) (95,000) (93,000) (45,000) (45,000) (95,000) (1,915,000) (1,210,000) (616,000) (4,673,000) (1,750,000) City of Pickering 2023 Capital Forecast 5731 Rec.Complex-Core 5731.2301 Banquet Hall Digital Display Monitors 1711 Internal Loan -5 Year 6500 Building Related New digital display monitors and controls to replace existing projectors and screens in both halves of the banquet hall. Total 5731.2301 Banquet Hall Digital Display Monitors 5731.2302 Elevator Retrofit 2823 Paid from Property Taxes 6183 Accessibility 6500 Building Related Upgrade finishes and accessibility features in the existing lobby elevator to comply with current standards. Total 5731.2302 Elevator Retrofit 5731.2303 RF-15 Replacement 6500 Building Related Lifecycle replacement of RF-15 serving fitness/atrium areas, including controls. This equipment was originally installed in 1983. 7505 RF -Federal Gas Tax Total 5731.2303 RF-15 Replacement 5731.2304 Tennis Court Flooring Replacement -Construction 1702 Debt-10 Year 6500 Building Related Lifecycle replacement of the existing indoor tennis court flooring. Includes replacement of the existing asphalt flooring with a new concrete slab base. The building was constructed in 1990. Total 5731.2304 Tennis Court Flooring Replacement -Constructio 5731.2305 Tennis Court Structural Coating 1701 Debt -5 Year 6500 Building Related Repairs and application of protective coatings to existing structural steel in the indoor tennis courts to extend the life of the existing structure. The building was constructed in 1990. Total 5731.2305 Tennis Court Structural Coating 5731.2306 Paint Tennis Court Walls & Ceiling 1701 Debt-5 Year 43 Run Date: Feb 28, 2022 Funding Expense (220,000) 220,000 (220,000) 220,000 (100,000) 30,000 70,000 (100,000) 100,000 45,000 (45,000) (45,000) 45,000 (1,905,000) 1,905,000 (1,905,000) 1,905,000 (108,000) 108,000 (108,000) 108,000 (232,000) 5731 Rec.Complex-Core 6500 Building Related City of Pickering 2023 Capital Forecast Lifecycle replacement of existing indoor wall coatings in the tennis courts. Painting on the ceiling will be limited to selective structural elements, not the entire ceiling. Total 5731.2306 Paint Tennis Court Walls & Ceiling 5731.2308 BAS & Control Systems Upgrade -Construction 1701 Debt-5 Year 6500 Building Related Lifecycle upgrade to the CHDRC's existing building automation system (BAS). The existing system has been expanded gradually over the last 20 years and is nearing the end of viability of its software and hardware components and requires a general overhaul and upgrade. The existing building automation system (BAS) needs to have planned upgrades every 10 years to keep up with technology. This systems serves as a hub for automation controls for all city facilities. Total 5731.2308 BAS & Control Systems Upgrade -Construction Total 5731 Rec.Complex-Core 44 Run Date: Feb 28, 2022' Funding Expense 232,000 (232,000) 232,000 (372,000) 372,000 (372,000) 372,000 (2,982,000) 2,982,000 City of Pickering 2024 Capital Forecast 5731 Rec.Complex-Core 5731.2401' Convert Exterior and Parking Lot Lighting to LED 6500 Building Related Convert existing parking lot light fixtures and wall-mounted exterior light fixtures to LED. Existing poles and bases will be retained. 7505 RF -Federal Gas Tax Total 5731.2401 Convert Exterior and Parking Lot Lighting to LED 5731.2402 Loading Dock Retrofit 6500 Building Related Lifecycle replacement of the CHDRC loading dock to provide an adjustable dock, new bumpers and safety rails, replace doors and related equipment. 7034 R -R/Cmplex Core Surcharge Total 5731.2402 Loading Dock Retrofit 5731.2403 Parking Lot Resurfacing -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees Design for lifecycle replacement of top asphalt, and selective curb and catch basin repairs for the north public parking lot and south staff lot. Excludes the main entrance turning circle. Total 5731.2403 Parking Lot Resurfacing -Design 5731.2404 Chiller & Cooling Tower Replacement -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees Chiller & Cooling Tower Replacement-Design Total 5731.2404 Chiller & Cooling Tower Replacement -Design 5731.2405 Community Services Office Renovation 1711 Internal Loan -5 Year 6500 Building Related Community Services Office Renovation Total 5731.2405 Community Services Office Renovation 5731.2406 Roof & Skylight Replacement (D & D1) -Design 2823 Paid from Property Taxes 6500 Building Related Lifecycle replacement of roofs D & D1 (core area over space frame). Design and testing only. 45 Run Date: Feb 27, 2022 Funding Expense 95,000 (95,000) (95,000) 95,000 93,000 (93,000) (93,000) 93,000 (52,000) 52,000 (52,000) 52,000 (50,000) 50,000 (50,000) 50,000 (276,000) 276,000 (276,000) 276,000 (50,000) 50,000 5731 Rec.Complex-Core City of Pickering 2024 Capital Forecast Total 5731.2406 Roof & Skylight Replacement (D & D1) -Design Total 5731 Rec.Complex-Core 46 Run Date: Feb 27, 2022 Funding Expense (50,000) 50,000 (616,000) 616,000 City of Pickering 2025 Capital Forecast 5731 Rec.Complex-Core 5731.2501 Roof Replacement (J & 13) -Design 2823 Paid from Property Taxes 6500 Building Related Lifecycle replacement of roof J (squash courts) and 13 (loading dock and exit corridor). Design and testing only. Total 5731.2501 Roof Replacement (J & 13) -Design 5731.2502 Roof & Skylight Replacement (D, D1 & 14) -Construction 6500 Building Related Construction costs for lifecycle replacement of roofs D & D1 (core area over space frame). 7505 RF -Federal Gas Tax Total 5731.2502 Roof & Skylight Replacement (D, D1 & 14) -Const, 5731.2503 Staff Room Renovation 2823 Paid from Property Taxes 6500 Building Related Lifecycle replacement of existing millwork and fixtures in the staff lunch, locker rooms and adjoining washroom. Includes design costs. Total 5731.2503 Staff Room Renovation 5731.2504 Curtain Wall & Window Replacement -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees Lifecycle replacement of original 1983 aluminum windows at tenant suites on south side of core area and main entrance curtain wall. Design and testing only. Total 5731.2504 Curtain Wall & Window Replacement -Design 5731.2505 Parking Lot Resurfacing -Construction 1702 Debt -10 Year 6500 Building Related Lifecycle replacement of top asphalt, and selective curb and catch basin repairs for the north public parking lot and south staff lot. Excludes the main entrance turning circle. Total 5731.2505 Parking Lot Resurfacing -Construction 5731.2506 Chiller & Cooling Tower Replacement -Construction 1701 Debt-5 Year 6500 Building Related 47 Run Date: Feb 27, 2022 Funding Expense (50,000) 50,000 (50,000) 50,000 1,915,000 (1,915,000) (1,915,000) 1,915,000 (90,000) 90,000 (90,000) 90,000 (53,000) 53,000 (53,000) 53,000 (2,110,000) 2,110,000 (2,110,000) 2,110,000 (410,000) . 410,000 5731 Rec.Complex-Core City of Pickering 2025 Capital Forecast Chiller & Cooling Tower Replacement -Construction Total 5731.2506 Chiller & Cooling Tower Replacement -Construct 5731.2507 Health Club Equipment Replacement 6178 Machinery & Equipment Fitness Equipment Replacement: Strength Machines (3), Cardio Machines (1) 7034 R -R/Cmplex Core Surcharge Total 5731.2507 Health Club Equipment Replacement Total 5731 Rec.Complex-Core 48 Run Date: Feb 27, 2022 Funding Expense (410,000) 410,000 45,000 (45,000) (45,000) 45,000 (4,673,000) 4,673,000 5731 Rec.Complex-Core City of Pickering 2026 Capital Forecast 5731.2601 Curtain Wall & Window Replacement -Construction 6500 Building Related Lifecycle replacement of original aluminum windows at tenant suites on south side of core area and main entrance curtain wall - Construction 7505 RF -Federal Gas Tax Total 5731.2601 Curtain Wall & Window Replacement -Constructi1 5731.2602 Roof Replacement (J & 13) -Construction 1702 Debt-10 Year 6500 Building Related Lifecycle replacement of roof J (squash courts) and 13 (loading dock and exit corridor) -Construction Total 5731.2602 Roof Replacement (J & 13) -Construction 5731.2603 Carpet & Flooring Replacement 2823 Paid from Property Taxes 6500 Building Related Carpet & flooring replacement at various locations throughout the building Total 5731.2603 Carpet & Flooring Replacement 5731.2604 Health Club Equipment Replacement 6178 Machinery & Equipment Fitness Equipment Replacement: Strength Machines (2), Cardio Machines (6) 7034 R -R/Cmplex Core Surcharge Total 5731.2604 Health Club Equipment Replacement Total 5731 Rec.Complex-Core 49 Run Date: Feb 28, 2022 Funding Expense 1,210,000 (1,210,000) (1,210,000) 1,210,000 (400,000) 400,000 (400,000) 400,000 (95,000) 95,000 (95,000) 95,000 45,000 (45,000) (45,000) 45,000 (1,750,000) 1,750,000 5733 Rec. Complex-Pool Expenditures 6183 Accessibility 6230 Prof/Consulting Fees 6500 Building Related Total Expenditures Financing 1704 Debt -20 year 1711 Internal Loan -5 Year 7505 RF -Federal Gas Tax Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 50 2024 Forecast Run Date: Feb 27, 2022 2025 2026 Forecast Forecast 150,000 360,000 70,000 2,010,000 430 000 2 160 000 (2,160,000) (360,000) (70,000) (430,000) (2,160,000) 5733 Rec. Complex-Pool City of Pickering 2025 Capital Forecast 5733.2501 CHDRC Pool Renovations -Design 1711 Internal Loan -5 Year 6230 Prof/Consulting Fees Renovations to the tot and main pools, lifeguard station and change rooms, and related systems. Design only. Total 5733.2501 CHDRC Pool Renovations -Design 5733.2502 Family Change Room RTU Replacement 6500 Building Related Lifecycle replacement of existing roof top unit serving family change rooms. The unit was installed in 2002. 7505 RF -Federal Gas Tax Total 5733.2502 Family Change Room RTU Replacement Total 5733 Rec. Complex-Pool 51 Run Date: Feb 27, 2022 Funding Expense (360,000) 360,000 (360,000) 360,000 70,000 (70,000) (70,000) 70,000 (430,000) 430,000 5733 Rec. Complex-Pool City of Pickering 2026 Capital Forecast 5733.2601 CHDRC Pool Renovations -Construction 1704 Debt -20 year 6183 Accessibility Project will include accessibility upgrades 6500 Building Related Renovations to the tot and main pools, lifeguard station and change rooms, and related systems. Total 5733.2601 CHDRC Pool Renovations -Construction Total 5733 Rec. Complex-Pool 52 Run Date: Feb 27, 2022 Funding Expense (2,160,000) 150,000 2,010,000 (2,160,000) 2,160,000 (2,160,000) 2,160,000 5735 Rec.Complex-Arenas Expenditures 6183 Accessibility 6230 Prof/Consulting Fees 6500 Building Related Total Expenditures Financing 1701 Debt - 5 Year 1704 Debt -20 year 1711 Internal Loan-5 Year 2823 Paid from Property Taxes 7036 R -R/Cmplx Arena Surcharge 7067 R -Casino Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 485,000 485,000 (485,000) (485,000) 53 Run Date: Mar 15, 2022 2024 2025 2026 Forecast Forecast Forecast 200,000 560,000 50,000 3,572,000 47,000 560 000 3 772,000 97000 (530,000) (3,662,000) (110,000) (30,000) (97,000} (560 ,000) (3,772,000) (97,000) I . I I I I I I 5735 Rec.Complex-Arenas 5735.2301 Gravel Parking Lot Upgrades 6500 Building Related City of Pickering 2023 Capital Forecast Additional funding for gravel parking lot upgrades, including asphalt paving, provision of walking paths, lighting and related works to facilitate safe access between this site and the Civic Complex. Parking lot upgrade approved in 2020 Capital Budget (5735.2001). 7067 R -Casino Total 5735.2301 Gravel Parking Lot Upgrades Total 5735 Rec.Complex-Arenas Run Date: Mar 14, 2022 Funding Expense 485,000 (485,000) (485,000) 485,000 (485,000) 485,000 53A I I I 5735 Rec.Complex-Arenas City of Pickering 2024 Capital Forecast 5735.2401 O'Brien Arena Renovation -Design 1701 Debt -5 Year 6230 Prof/Consulting Fees Design and investigation costs for major renovation of the interior spaces in O'Brien Arena, including: structural repairs, building envelope, interior finishes, rink slab and dashboard, structural coating, parking lot asphalt and lighting, exterior patios, and other related systems. Total 5735.2401 O'Brien Arena Renovation -Design 5735.2402 Delaney Arena Mechanical Replacements -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees Delaney Arena Mechanical Replacements -Design Total 5735.2402 Delaney Arena Mechanical Replacements -Desigr Total 5735 Rec.Complex-Arenas 54 Run Date: Feb 27, 2022 Funding Expense (530,000) 530,000 (530,000) 530,000 (30,000) 30,000 (30,000) 30,000 (560,000) 560,000 5735 Rec.Complex-Arenas City of Pickering 2025 Capital Forecast 5735.2501 Delaney Arena Mechanical Replacements 1711 Internal Loan -5 Year 6500 Building Related Lifecycle replacement of existing mechanical equipment in Delaney arena, including pumps, heat exchangers, compressors and related equipment. Total 5735.2501 Delaney Arena Mechanical Replacements 5735.2503 O'Brien Arena Renovation -Construction 1704 Debt -20 year 6183 Accessibility Project will include accessibility upgrades 6500 Building Related Construction costs for major renovation of the interior spaces in O'Brien Arena, including: structural repairs, building envelope, interior finishes, rink slab and dashboard, structural coating, parking lot asphalt and lighting, exterior patios, and other related systems. Total 5735.2503 O'Brien Arena Renovation -Construction Total 5735 Rec.Complex-Arenas 55 Run Date: Feb 27, 2022 Funding Expense (110,000) 110,000 (110,000) 110,000 (3,662,000) 200,000 3,462,000 (3,662,000) 3,662,000 (3,772,000) 3,772,000 5735 Rec.Complex-Arenas City of Pickering 2026 Capital Forecast 5735.2601 Delaney Arena Skate Tile Replacement 6500 Building Related Lifecycle replacement of existing skate tile flooring in Delaney Arena. 7036 R -R/Cmplx Arena Surcharge Total 5735.2601 Delaney Arena Skate Tile Replacement 5735.2602 Delaney Arena Roof Replacement -Design 6230 Prof/Consulting Fees Delaney Arena Roof Replacement -Design 7036 R -R/Cmplx Arena Surcharge Total 5735.2602 Delaney Arena Roof Replacement -Design Total 5735 Rec.Complex-Arenas 56 Run Date: Feb 27, 2022 Funding Expense 47,000 (47,000) (47,000) 47,000 50,000 (50,000) (50,000) 50,000 (97,000) 97,000 5744 Museum Expenditures 6149 Restoration -Museum Bldg 6183 Accessibility 6230 Prof/Consulting Fees 6500 Building Related Total Expenditures Financing 1592 Donations 1711 Internal Loan -5 Year 1712 Internal Loan-10 Year 2823 Paid from Property Taxes Total Financing City· of Pickering Multi-Year Capital Forecast 2023 -2026" 2023 Forecast 69,000 69 000 (69,000) (69,000) 57 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 734,000 477,000 20,000 50,000 74,000 57,750 35,000 828.000 562 000 57 750 (200,000) (504,000) (258,000) (165,000) (124,000) (139,000) (57,750) (828,000) (562,000) (57,750) 5744 Museum City of Pickering 2023 Capital Forecast 5744.2301 Brougham Temperance House Restoration -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees Structural, ramp and porch repairs, roofing and cladding replacement, interior framing and finish work. Design and testing only. Total 5744.2301 Brougham Temperance House Restoration -Desi! 5744.2302 Collins House Restoration -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees Building investigations and designs for structural and architectural repairs required to maintain a heritage asset. Total 5744.2302 Collins House Restoration -Design Total 5744 Museum 58 Run Date: Feb 27, 2022 Funding Expense (42,000) 42,000 (42,000) 42,000 (27,000) 27,000 (27,000) 27,000 (69,000) 69,000 5744 Museum City of Pickering 2024 Capital Forecast 5744.2401 General Store Restoration -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees Roofing, cladding, porch and ramp repairs and interior finish replacement. Design and testing only. Total 5744.2401 General Store Restoration -Design 5744.2402 Brougham Temperance House Restoration -Constructic 1711 Internal Loan -5 Year 6149 Restoration -Museum Bldg Structural, ramp and porch repairs, roofing and cladding replacement, interior framing and finish work at the Brougham Temperance House (built ~1835), including restoration of existing wood frame window and doors. 6183 Accessibility Project will include ramp replacement Total 5744.2402 Brougham Temperance House Restoration -Com 5744.2403 Harvey House Restoration -Interior fit Out 1592 Donations PMV Foundation 2823 Paid from Property Taxes 6149 Restoration -Museum Bldg Construction costs for interior renovation and fit-out of the Harvey House, including restoration and finishing costs associated with preparing the building for programming, historic interpretation and exhibits. Total 5744.2403 Harvey House Restoration -Interior fit Out 5744.2404 Collins House Restoration -Construction 1711 Internal Loan -5 Year 6149 Restoration -Museum Bldg Selective cladding, roofing and trim replacement and repairs to structural framing in the Collins House (built ~1830). Includes repainting, improved pest-proofing, provision of barrier-free ramp and provision of foundation and functioning chimney for stove. Existing materials to be conserved, wherever possible. Total 5744.2404 Collins House Restoration -Construction 5744.2405 Miller Cole House Restoration -Design 2823 Paid from Property Taxes 59 Run Date: Feb 27, 2022 Funding Expense (17,000) 17,000 (17,000) 17,000 (350,000) 330,000 20,000 (350,000) 350,000 (200,000) (50,000) 250,000 (250,000) 250,000 (154,000) 154,000 (154,000) 154,000 (57,000) 5744 Museum 6230 Prof/Consulting Fees City of Pickering 2024 Capital Forecast Full cladding, trim and roof replacement, repairs to structural framing, and interior restoration for the Miller Cole House (built ~1840). Includes painting. Existing materials to be conserved, wherever possible. Design only. Total 5744.2405 Miller Cole House Restoration -Design Total 5744 Museum 60 Run Date: Feb 27, 2022 Funding Expense 57,000 (57,000) 57,000 (828,000) 828,000 5744 Museum City of Pickering 2025 Capital Forecast 5744.2501 Puterbaugh House Restoration 2823 Paid from Property Taxes 6149 Restoration -Museum Bldg Restoration of various structural and architectural elements of the building required to maintain a heritage asset. Includes wood framing, window, roof, chimney, finishes and related repairs. Total 5744.2501 Puterbaugh House Restoration 5744.2502 Improve Access to Conservation Drive Shed Loft 2823 Paid from Property Taxes 6500 Building Related Construct permanent stair to loft over Conservation Drive shed and improve interior and exterior lighting. Includes engineering and soils testing. Total 5744.2502 Improve Access to Conservation Drive Shed Loft 5744.2503 General Store Restoration -Construction 2823 Paid from Property Taxes 6149 Restoration -Museum Bldg Roofing, cladding, porch and ramp repairs and interior finish replacement. 6183 Accessibility Project will include ramp upgrades Total 5744.2503 General Store Restoration -Construction 5744.2504 Miller Cole House Restoration -Construction 1712 Internal Loan-10 Year 6149 Restoration -Museum Bldg Full cladding, trim and roof replacement, repairs to structural framing, and interior restoration for the Miller Cole House (built ~1840). Includes painting. Existing materials to be conserved, wherever possible. Total 5744.2504 Miller Cole House Restoration -Construction 5744.2505 Harvey House Restoration -Construction 1711 Internal Loan -5 Year 6149 Restoration -Museum Bldg Construction costs for the relocation and partial restoration of the Harvey House, including exterior and interior services. This budget excludes interior renovation and exhibit costs. 61 Run Date: Feb 27, 2022 Funding Expense (50,000) 50,000 (50,000) 50,000 (35,000) 35,000 (35,000) 35,000 (54,000) 44,000 10,000 (54,000) 54,000 (165,000) 165,000 (165,000) 165,000 (258,000) 218,000 5744 Museum 6183 Accessibility Project will include new ramp City of Pickering 2025 Capital Forecast Total 5744.2505 Harvey House Restoration -Construction Total 5744 Museum 62 Run Date: Feb 27, 2022 Funding Expense 40,000 (258,000) 258,000 (562,000) 562,000 5744 Museum City of Pickering 2026 Capital Forecast 5744.2601 Chapel & Drive Shed Restoration -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees Structural, roofing and cladding repairs, waterproofing and interior finish work. Design and testing only. Total 5744.2601 Chapel & Drive Shed Restoration -Design Total 5744 Museum 63 Run Date: Feb 27, 2022 Funding Expense (57,750) 57,750 (57,750) 57,750 (57,750) 57,750 City of Pickering Multi-Year Capital Forecast 2023 -2026 Operations Dept. Summary 2023 Forecast Expenditures 6129 Parks -Landscape Refurbishment 5,460,000 6157 Vehicles -under $100,000 1,000,000 6158 Vehicles -Over $100,000 1,200,000 6159 Fire Veh -Over $100,000 1,005,000 6173 Furniture & Fixtures 6178 Machinery & Equipment 1,814,000 6181 other Fixed Assets 200,000 6183 Accessibility 2,625,000 6265 Land Acquisition & Disp 6429 Parks -Landscape Refurb -Seaton 1,370,000 6430 Prof/Consult Fees -Seaton 500,000 6457 Vehicles -Under $100,000 -Seaton 455,000 6458 Vehicles -Over $100,000 -Seaton 300,000 6478 Miscellaneous Equipment -Seaton 335,000 6483 Accessibility -Seaton 860,000 6500 Building Related Total Expenditures 17,124 000 Financing 1702 Debt-10Year (700,000) 1703 Debt-15Year (5,724,000) 1704 Debt -20 year 1708 DC Debt -15 Year (Protective Services) 1711 Internal Loan -5 Year 1726 DC Debt-5 Year (other Services Related to Hwy) (545,000) 1729 DC Debt-20 Year (other Services Related to Hwy) 1731 DC Internal Loan -20 Year (other Services Related to Hwy) (500,000) 1741 DC Debt-15 Year (Parks & Rec) 2823 Paid from Property Taxes (200,000) 7022 R -DC's City's Share 7040 R -Vehicle Replacement (2,220,000) 7053 R -Sustainability Initiatives 7057 R -Fence (200,000) 7060 R -Seaton Land Grp FIA 7061 R -Tennis Court (80,000) 64 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 3,850,000 1,210,000 5,270,000 410,000 185,000 135,000 720,000 1,150,000 595,000 1,025,000 1,230,000 300,000 1,245,000 1,685,000 1,000,000 200,000 300,000 200,000 1,750,000 755,000 3,716,000 1,504,000 200,000 4,280,000 70,000 100,000 80,000 1,325,000 400,000 200,000 2,150,000 460,000 4,500,000 40,000 17,445 000 7 375 000 17 420,000 (4,650,000) (1,500,000) (3,040,500) (1,200,000) (180,000) (300,000) (650,000) (4,500,000) (5,766,500) (70,000) (50,000) (65,000) (100,000) (2,206,500) (1,080,000) (1,335,000) (780,000) (65,000) (200,000) (300,000) (200,000) (37,000) Operations Dept. Summary 7062 R -Major Equipment 7502 RF -Parkland 7505 RF -Federal Gas Tax City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast (1,480,000) (1,050,000) (1,655,000) 7622 RF DC -Parks & Recreation Services (2,699,250) 7708 RF -Operations Centre 7710 RF -Stormwater Mgmt (15,000) 7713 RF -Seaton Land Grp FIA (55,750) Total Financing (17,124,000) 65 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast (755,000) (1,300,000) (775,000) (880,000) (520,000) (1,200,000) (910,000) (1,175,000) (300,000) (2,459,450) (791,500) (2,329,500) (50,000) (300,000) (110,550) (38,500) (70,000) (17,445,000) (7,375,000) (17,420,000) 5311 Property Maintenance Expenditures 6129 Parks -Landscape Refurbishment 6178 Machinery & Equipment 6181 Other Fixed Assets 6183 Accessibility 6478 Miscellaneous Equipment -Seaton Total Expenditures Financing 1711 Internal Loan -5 Year City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 135,000 200,000 500,000 315,000 1 150 000 1726 DC Debt-5 Year (Other Services Related to Hwy) (175,000) 7057 R -Fence (200,000) 7062 R -Major Equipment (120,000) 7505 RF -Federal Gas Tax (500,000) 7622 RF DC -Parks & Recreation Services (140,000) 7710 RF -Stormwater Mgmt (15,000) Total Financing (1,150,000) 66 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 180,000 470,000 260,000 225,000 200,000 200,000 200,000 250,000 275,000 175,000 1,100 000 735 000 600,000 (180,000) (350,000) (200,000) (200,000) (200,000) (470,000) (260,000) (50,000) (250,000) (275,000) (1,100,000) (735,000) (600,000) City of Pickering 2023 Capital Forecast 5311 Property Maintenance 5311.2301 Walkway Reconstruction: Foxwood -Beckworth 6183 Accessibility Reconstruct walkway between Foxwood Trail and Beckworth Square including new fence and concrete walkway 7505 RF -Federal Gas Tax Total 5311.2301 Walkway Reconstruction: Foxwood -Beckworth 5311.2302 Walkway Reconstruction: Graceland -St. Mary Park 6183 Accessibility Reconstruct walkway between Graceland Court and St. Mary Park including new fence and concrete walkway 7505 RF -Federal Gas Tax Total 5311.2302 Walkway Reconstruction: Graceland -St. Mary Pa 5311.2303 Walkway Reconstruction: Whites -Cognac 6183 Accessibility Reconstruct walkway between Whites Road and Cognac Crescent including new fence and concrete walkway 7505 RF -Federal Gas Tax Total 5311.2303 Walkway Reconstruction: Whites -Cognac 5311.2304 Property Line Fence Replacement 6181 other Fixed Assets Replacement of property line fences along City road allowances at various locations 7057 R -Fence Total 5311.2304 Property Line Fence Replacement 5311.2305 Sidewalk Plow with Attachments -New 1726 DC Debt-5 Year (Other Services Related to Hwy) 6478 Miscellaneous Equipment -Seaton Sidewalk Plow with attachments for Seaton. Total 5311.2305 Sidewalk Plow with Attachments -New 5311.2306 Wide Area Mower -New 6478 Miscellaneous Equipment -Seaton Wide Area Mower for Growth -New 7622 RF D_C -Parks & Recreation Services Total 5311.2306 Wide Area Mower -New 5311.2307 Zero Turn Mower Replacement (4) 67 Run Date: Feb 27, 2022 Funding Expense 125,000 (125,000) (125,000) 125,000 125,000 (125,000) (125,000) 125,000 125,000 (125,000) (125,000) 125,000 200,000 (200,000) (200,000) 200,000 (175,000) 175,000 (175,000) 175,000 140,000 (140,000) (140,000) 140,000 5311 Property Maintenance 6178 Machinery & Equipment City of Pickering 2023 Capital Forecast Electric Zero Turn Mowers replacing gas powered units #S512, #S513, #S514, and #S515 (2017). 7062 R -Major Equipment Total 5311.2307 Zero Turn Mower Replacement (4) 5311.2309 Utility Boat and Trailer -New 6178 Machinery & Equipment Utility Boat and Trailer for Stormwater Pond Management 7710 RF -Stormwater Mgmt Total 5311.2309 Utility Boat and Trailer -New 5311.2313 Walkway Reconstruction: Rosebank -Lightfoot 6183 Accessibility Reconstruct walkway between Rosebank Road and Lightfoot Place including new fence and concrete walkway 7505 RF -Federal Gas Tax Total 5311.2313 Walkway Reconstruction: Rosebank -Lightfoot Total 5311 Property Maintenance 68 Run Date: Feb 27, 2022 Funding Expense 120,000 (120,000) (120,000) 120,000 15,000 (15,000) (15,000) 15,000 125,000 (125,000) (125,000) 125,000 (1,150,000) 1,150,000 City of Pickering 2024 Capital Forecast 5311 Property Maintenance 5311.2401 Property Line Fence Replacement 6181 Other Fixed Assets Property Line Fencing. 7057 R -Fence Total 5311.2401 Property Line Fence Replacement 5311.2402 HWY 401 Brock Road On/Off Ramp Landscape 1711 Internal Loan -5 Year 6129 Parks -Landscape Refurbishment 401 Brock Road On/Off Ramp Landscape Reconstruction including Welcome to Pickering Sign. Total 5311.2402 HWY 401 Brock Road On/Off Ramp Landscape 5311.2403 Two Sidewalk Tractor -Replacement (2) 6178 Machinery & Equipment Replacement of unit #714 & #718 (2015). 7062 R -Major Equipment Total 5311.2403 Two Sidewalk Tractor -Replacement (2) 5311.2404 Four Zero Turn Replacement (4) 6178 Machinery & Equipment Electric Zero Turn Mowers -Replacement of gas units #S550, #S551, #S552, & #S553 (2018). 7062 R -Major Equipment Total 5311.2404 Four Zero Turn Replacement (4) 5311.2405 Walkway Reconstruction: Strouds -Sultana 6183 Accessibility Reconstruct walkway between Strouds Lane and Sultana Square including new fence and concrete walkway 7505 RF -Federal Gas Tax Total 5311.2405 Walkway Reconstruction: Strouds -Sultana 5311.2406 Walkway Reconstruction: Charnwood -Greenvale 6183 Accessibility Reconstruct walkway between Charnwood Court and Greenvale Crescent including new fence and concrete walkway 7505 RF -Federal Gas Tax Total 5311.2406 Walkway Reconstruction: Charnwood -Greenvah Total 5311 Property Maintenance 69 Run Date: Feb 27, 2022 Funding Expense 200,000 (200,000) (200,000) 200,000 (180,000) 180,000 (180,000) 180,000 350,000 (350,000) (350,000) 350,000 120,000 (120,000) (120,000) 120,000 125,000 (125,000) (125,000) 125,000 125,000 (125,000) (125,000) 125,000 (1,100,000) 1,100,000 City of Pickering 2025 Capital Forecast 5311 Property Maintenance 5311.2501 Four Zero Turn Replacement (4) 6178 Machinery & Equipment Electric Zero Turn Mowers -Replacement of gas units #570, #571, #572 & #573 (2018). 7062 R -Major Equipment Total 5311.2501 Four Zero Turn Replacement (4) 5311.2502 Property Line Fence Replacement 6181 Other Fixed Assets Property Line Fencing Replacement 7057 R -Fence Total 5311.2502 Property Line Fence Replacement 5311.2503 Wide Area Mower -Replacement 6178 Machinery & Equipment Wide Area Mower replace unit #788. 7062 R -Major Equipment Total 5311.2503 Wide Area Mower -Replacement 5311.2506 Walkway Reconstruction: Cattail -Dunbarton H.S. 6183 Accessibility Reconstruct walkway between Cattail Court and Dunbarton High School including new fence and concrete walkway 7505 RF -Federal Gas Tax Total 5311.2506 Walkway Reconstruction: Cattail -Dunbarton H.S. 5311.2507 Walkway Reconstruction: Tanzer -Bayshore Tot Lot 6183 Accessibility Reconstruct walkway between Tanzer Court and Bayshore Tot Lot including new fence and concrete walkway 7505 RF -Federal Gas Tax Total 5311.2507 Walkway Reconstruction: Tanzer -Bayshore Tot l Total 5311 Property Maintenance 70 Run Date: Feb 27, 2022 Funding Expense 120,000 (120,000) (120,000) 120,000 200,000 (200,000) (200,000) 200,000 140,000 (140,000) (140,000) 140,000 125,000 (125,000) (125,000) 125,000 150,000 (150,000) (150,000) 150,000 (735,000) 735,000 City of Pickering 2026 Capital Forecast 5311 Property Maintenance 5311.2601 Sidewalk Plow with Attachments -New 1726 DC Debt-5 Year (Other Services Related to Hwy) 6478 Miscellaneous Equipment -Seaton Sidewalk Plow with attachments for Growth. Total 5311.2601 Sidewalk Plow with Attachments -New 5311.2602 Sidewalk Sweeper with Attachments -New 1726 DC Debt -5 Year (Other Services Related to Hwy) 6178 Machinery & Equipment Sidewalk Sweeper with Attachments for City Centre. Total 5311.2602 Sidewalk Sweeper with Attachments -New 5311.2603 Litter Vacuum -New 6178 Machinery & Equipment Litter Vacuum with Attachments for City Centre. 7062 R -Major Equipment Total 5311.2603 Litter Vacuum -New 5311.2604 Property Line Fence Replacement 6181 Other Fixed Assets Property Line Fencing. 7057 R -Fence Total 5311.2604 Property Line Fence Replacement Total 5311 Property Maintenance 71 Run Date: Feb 27, 2022 Funding Expense (175,000) 175,000 (175,000) 175,000 (175,000) 175,000 (175,000) 175,000 50,000 (50,000) (50,000) 50,000 200,000 (200,000) (200,000) 200,000 (600,000) 600,000 5319 Roads Equipment Expenditures 6178 Machinery & Equipment Total Expenditures Financing 7062 R -Major Equipment Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 1,100,000 1 100 000 (1,100,000) (1,100,000) 72 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 135,000 950,000 600,000 135 000 950 000 600 000 (135,000) (950,000) (600,000) (135,000) (950,000) (600,000) 5319 Roads Equipment City of Pickering 2023 Capital Forecast 5319.2301 Road Grader with Automatic Grade Control -ReplacemE 6178 Machinery & Equipment Road Grader -replace unit #110 (2013) 7062 R -Major Equipment Total 5319.2301 Road Grader with Automatic Grade Control -Rep 5319.2304 Hydroscopic Excavator with Attachments -Replacement 6178 Machinery & Equipment Hydroscopic Excavator with Attachments -replace unit #114 (2005). 7062 R -Major Equipment Total 5319.2304 Hydroscopic Excavator with Attachments -Repla1 Total 5319 Roads Equipment 73 Run Date: Feb 27, 2022 Funding Expense 550,000 (550,000) (550,000) 550,000 550,000 (550,000) (550,000) 550,000 (1,100,000) 1,100,000 5319 Roads Equipment City of Pickering 2024 Capital Forecast 5319.2401 Asphalt Heater -Replacement 6178 Machinery & Equipment Replace unit #144 (2016) 7062 R -Major Equipment Total 5319.2401 Asphalt Heater -Replacement 5319.2402 Asphalt Heater -New 6178 Machinery & Equipment Asphalt Heater -New. Truck mounted unit. 7062 R -Major Equipment Total 5319.2402 Asphalt Heater -New 5319.2403 Walk-behind Concrete Planer -Replacement (2) 6178 Machinery & Equipment Walk-behind Concrete Planer (2) (replace unit #S603 and #S604) 7062 R -Major Equipment Total 5319.2403 Walk-behind Concrete Planer -Replacement (2) 5319.2404 Concrete Dust Extractor -Replacement (2) 6178 Machinery & Equipment Concrete Dust Extractor (2) (replace unit #064 and #065) 7062 R -Major Equipment Total 5319.2404 Concrete Dust Extractor -Replacement (2) Total 5319 Roads Equipment 74 Run Date: Feb 27, 2022 Funding Expense 50,000 (50,000) (50,000) 50,000 50,000 (50,000) (50,000) 50,000 25,000 (25,000) (25,000) 25,000 10,000 (10,000) (10,000) 10,000 (135,000) 135,000 City of Pickering 2025 Capital Forecast 5319 Roads Equipment 5319.2502 Hydroscopic Excavator -Replacement 6178 Machinery & Equipment Hydroscopic Excavator -Replace unit #117 (2012) 7062 R -Major Equipment Total 5319.2502 Hydroscopic Excavator -Replacement 5319.2503 Street Sweeper -Replacement 6178 Machinery & Equipment Street Sweeper -replace unit #150 (2015) 7062 R -Major Equipment Total 5319.2503 Street Sweeper -Replacement Total 5319 Roads Equipment 75 Run Date: Feb 27, 2022 Funding Expense 600,000 (600,000) (600,000) 600,000 350,000 (350,000) (350,000) 350,000 (950,000) 950,000 5319 Roads Equipment City of Pickering 2026 Capital Forecast 5319.2601 Front End Loader with Attachments -Replacement 6178 Machinery & Equipment Front End Loader with Attachments -Replace Unit #118 (2018). 7062 R -Major Equipment Total 5319.2601 Front End Loader with Attachments -Replacemer 5319.2602 Street Sweeper -Replacement 6178 Machinery & Equipment Street Sweeper -Replace Unit #151 (2015). 7062 R -Major Equipment Total 5319.2602 Street Sweeper -Replacement Total 5319 Roads Equipment 76 Run Date: Feb 27, 2022 Funding Expense 250,000 (250,000) (250,000) 250,000 350,000 (350,000) (350,000) 350,000 (600,000) 600,000 5315 Operations Centre Expenditures 6173 Furniture & Fixtures 6178 Machinery & Equipment 6430 Prof/Consult Fees -Seaton 6500 Building Related Total Expenditures Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 60,000 500,000 560 000 1729 DC Debt-20 Year (Other Services Related to Hwy) 1731 DC Internal Loan -20 Year (Other Services Related to Hwy) (500,000) 2823 Paid from Property Taxes (60,000) 7053 R -Sustainability Initiatives 7708 RF -Operations Centre Total Financing (560,000) 77 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 300,000 65,000 4,500,000 40,000 4 500 000 365 000 40 000 (4,500,000) (40,000) (65,000) (300,000) (4,500,000) (365,000) (40,000) 5315 Operations Centre City of Pickering 2023 Capital Forecast 5315.2301 Ops. Ctre. Northern Satellite Facility -Design 1731 DC Internal Loan -20 Year (Other Services Related to Hwy) 6430 Prof/Consult Fees -Seaton Operations Centre Northern Satellite Facility-Design Total 5315.2301 Ops. Ctre. Northern Satellite Facility-Design 5315.2302 Ops. Centre EV Charging Stations 2823 Paid from Property Taxes 6178 Machinery & Equipment EV Charging Stations Total 5315.2302 Ops. Centre EV Charging Stations Total 5315 Operations Centre 78 Run Date: Feb 27, 2022 Funding Expense (500,000) 500,000 (500,000) 500,000 (60,000) 60,000 (60,000) 60,000 (560,000) 560,000 5315 Operations Centre City of Pickering 2024 Capital Forecast 5315.2401 Operations Centre Northern Satellite Facility -Construc1 1729 DC Debt-20 Year (Other Services Related to Hwy) 6500 Building Related Operations Centre Northern Satellite Facility-Construction Total 5315.2401 Operations Centre Northern Satellite Facility -Co Total 5315 Operations Centre 79 Run Date: Feb 27, 2022 Funding Expense (4,500,000) 4,500,000 (4,500,000) 4,500,000" (4,500,000) 4,500,000 5315 Operations Centre 5315.2501 EV Charging Stations 6178 Machinery & Equipment EV Charging Stations 7053 R -Sustainability Initiatives Total 5315.2501 EV Charging Stations City of Pickering 2025 Capital Forecast 5315.2502 Operations Centre Northern Satellite Facility -FF&E 6173 Furniture & Fixtures Furniture, fixtures and equipment for the new northern satellite facility. 7708 RF -Operations Centre Total 5315.2502 Operations Centre Northern Satellite Facility -FFi Total 5315 Operations Centre 80 Run Date: Feb 27, 2022 Funding Expense 65,000 (65,000) (65,000) 65,000 300,000 (300,000) (300,000) 300,000 (365,000) 365,000 5315 Operations Centre City of Pickering 2026 Capital Forecast 5315.2601 Carbon Monoxide System Replacement 2823 Paid from Property Taxes 6500 Building Related Carbon Monoxide System Replacement Total 5315.2601 Carbon Monoxide System Replacement Total 5315 Operations Centre 81 Run Date: Feb 27, 2022 Funding Expense (40,000) 40,000 (40,000) 40,000 (40,000) 40,000 5780 Parks Expenditures 6129 Parks -Landscape Refurbishment 6178 Machinery & Equipment 6181 Other Fixed Assets 6183 Accessibility 6265 Land Acquisition & Disp 6429 Parks -Landscape Refurb -Seaton 6478 Miscellaneous Equipment -Seaton 6483 Accessibility -Seaton Total Expenditures Financing 1702 Debt-10 Year 1703 Debt -15 Year 1704 Debt -20 year 1741 DC Debt-15 Year (Parks & Rec) 2823 Paid from Property Taxes 7022 R -DC's City's Share 7040 R -Vehicle Replacement 7057 R -Fence 7060 R -Seaton Land Grp FIA 7061 R -Tennis. Court 7062 R -Major Equipment 7502 RF -Parkland 7505 RF -Federal Gas Tax 7622 RF DC -Parks & Recreation Services 7713 RF -Seaton Land Grp FIA Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 5,460,000 300,000 2,125,000 1,370,000 20,000 860,000 10 135 000 (700,000) (4,500,000) (140,000) (20,000) (80,000) (260,000) (1,050,000) (1,155,000) (2,174,250) (55,750) (10,135,000) 82 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 3,670,000 1,210,000 5,270,000 190,000 140,000 175,000 100,000 1,500,000 480,000 3,716,000 1,504,000 200,000 4,280,000 25,000 2,150,000 460,000 7 710 000 2,390 000 14 970.000 (3,400,000) (3,040,500) (5,766,500) (70,000) (50,000) (25,000) (100,000) (2,206,500) (50,000) (100,000) (37,000) (150,000) (90,000) (125,000) (880,000) (520,000) (1,200,000) (660,000) (900,000) (300,000) (2,389,450) (691,500) (2,149,500) (60,550) (38,500) (70,000) (7,710,000) (2,390,000) (14,970,000) City of Pickering 2023 Capital Forecast 5780 Parks 5780.2301 Dunmoore Park Pathway Construction 6183 Accessibility Construction of asphalt path from Dunmoore parking lot to Engel Court and Atwood Crs. Will include removing stairs at Engel Court for accessibility 7505 RF -Federal Gas Tax Total 5780.2301 Dunmoore Park Pathway Construction 5780.2302 J. McPherson Park -Accessible Pathway Construction 6183 Accessibility New Accessibility Pathway at J. McPherson Park. From Parking lot to Baseball diamond and to the walkway at Pebble Court. 7502 RF -Parkland Total 5780.2302 J. McPherson Park -Accessible Pathway Constru 5780.2303 Neighbourhood Park -Seaton P-122 6429 Parks -Landscape Refurb -Seaton Neighbourhood Park (Seaton) P-122 (97.5/2.5) 7622 RF DC -Parks & Recreation Services 7713 RF -Seaton Land Grp FIA Total 5780.2303 Neighbourhood Park -Seaton P-122 5780.2304 Tractor Replacement 6178 Machinery & Equipment Tractor -replace unit #124 (2009). 7062 R -Major Equipment Total 5780.2304 Tractor Replacement 5780.2305 Primary Trail Network -Seaton T-1 6483 Accessibility -Seaton Primary trail network Seaton T-1 (97.5/2.5) 7622 RF DC -Parks & Recreation Services 7713 RF -Seaton Land Grp FIA Total 5780.2305 Primary Trail Network -Seaton T-1 5780.2306 Enclosed Trailer Replacement 2823 Paid from Property Taxes 6178 Machinery & Equipment Enclosed Trailer -replace unit #781 (2018) Total 5780.2306 Enclosed Trailer Replacement 83 Run Date: Feb 27, 2022 Funding Expense 200,000 (200,000) (200,000) 200,000 300,000 (300,000) (300,000) 300,000 590,000 (575,250) (14,750) (590,000) 590,000 110,000 (110,000) (110,000) 110,000 360,000 (351,000) (9,000) (360,000) 360,000 (20,000) 20,000 (20,000) 20,000 City of Pickering 2023 Capital Forecast 5780 Parks 5780.2310 Neighbourhood Park -Seaton P-120 6483 Accessibility -Seaton Neighbourhood Park (Seaton) P-120 (97.5/2.5) 7622 RF DC -Parks & Recreation Services 7713 RF -Seaton Land Grp FIA Total 5780.2310 Neighbourhood Park -Seaton P-120 5780.2311 Mapleridge Park Master Plan -Construction 6129 Parks -Landscape Refurbishment Mapleridge Park Master Plan -Construction -remove baseball diamond and replace with mini soccer field and new Tennis Courts. New soccer nets, relocate path to avoid flood plain, upgrade all other pathways, replace walkway lighting and wiring, remove concrete foundation. Project scope also includes reconstruction of Maple Ridge Tennis Courts. 6183 Accessibility 7502 RF -Parkland Total 5780.2311 Mapleridge Park Master Plan -Construction 5780.2312 Beachfront Park Master Plan -Phase 1 Construction 1703 Debt-15 Year 6129 Parks -Landscape Refurbishment Beachfront Park Master Plan -Phase 1 Construction -New Boardwalk (waterfront trail) and associated amenities from Millennium Square to Alex Robertson Park 6183 Accessibility Total 5780.2312 Beachfront Park Master Plan -Phase 1 Constructi 5780.2313 Enclosed Trailer Seaton -New 6478 Miscellaneous Equipment -Seaton Enclosed Trailer Seaton -New 7040 R -Vehicle Replacement Total 5780.2313 Enclosed Trailer Seaton -New 5780.2314 BRK Park Soccer Artificial Turf Replacement 1702 Debt-10 Year 6129 Parks -Landscape Refurbishment Replacement of artificial turf surface at Bay Ridges Kinsmen Park Soccer Field. Total 5780.2314 BRK Park Soccer Artificial Turf Replacement 84 Run Date: Feb 27, 2022 Funding Expense 500,000 (487,500) (12,500) (500,000) 500,000 300,000 100,000 (400,000) (400,000) 400,000 (4,500,000) 3,375,000 1,125,000 (4,500,000) 4,500,000 20,000 (20,000) (20,000) 20,000 (700,000) 700,000 (700,000) 700,000 City of Pickering 2023 Capital Forecast 5780 Parks 5780.2315 Martin's Tot Lot -Playground Replacement of Tot Unit 6129 Parks -Landscape Refurbishment Replacement of tot aged playground only in Martin's Tot Lot. 6183 Accessibility 7502 RF -Parkland Total 5780.2315 Martin's Tot Lot-Playground Replacement of Tot 5780.2318 Beachlawn Park -Multi-use Court 2823 Paid from Property Taxes 6129 Parks -Landscape Refurbishment Beachlawn Park -single basketball court Total 5780.2318 Beachlawn Park -Multi-use Court 5780.2319 Community Park Security Camera Seaton -P-115 2823 Paid from Property Taxes 6178 Machinery & Equipment Washroom area coverage of future community park at Burkholder Drive and Alexander Knox Total 5780.2319 Community Park Security Camera Seaton -P-115 5780.2320 DPW Park -Resurface & Line Paint Basketball Court 2823 Paid from Property Taxes 6129 Parks -Landscape Refurbishment Diana Princess of Wales Park -Resurface and line paint basketball court at Valleyview Park + new post and net. Total 5780.2320 DPW Park -Resurface & Line Paint Basketball Co 5780.2324 Neighbourhood Park -Seaton P-124 6429 Parks -Landscape Refurb -Seaton Neighbourhood Park-Seaton P-124 (97.5/2.5) 7622 RF DC -Parks & Recreation Services 7713 RF -Seaton Land Grp FIA Total 5780.2324 Neighbourhood Park -Seaton P-124 5780.2325 Village Green -Seaton P-125 6429 Parks -Landscape Refurb -Seaton Village Green Seaton P-125 (97.5/2.5) 7622 RF DC -Parks & Recreation Services 7713 RF -Seaton Land Grp FIA Total 5780.2325 Village Green -Seaton P-125 85 Run Date: Feb 27, 2022 Funding Expense 40,000 40,000 (80,000) (80,000) 80,000 (75,000) 75,000 (75,000) 75,000 (20,000) 20,000 (20,000) 20,000 (25,000) 25,000 (25,000) 25,000 540,000 (526,500) (13,500) (540,000) 540,000 240,000 (234,000) (6,000) (240,000) 240,000 5780 Parks City of Pickering 2023 Capital Forecast 5780.2326 Amberlea Park Hard Ball Diamond -Outfield Fence 6129 Parks -Landscape Refurbishment Amberlea Hard Ball Diamond-Outfield Fence Replacement ( 6 Foot Fence, 0-pipe Cap and Earthworks). 7502 RF -Parkland Total 5780.2326 Amberlea Park Hard Ball Diamond -Outfield Fenc 5780.2327 Pathway Construction (Accessibility to Parks) 6183 Accessibility Accessibility Pathways to Parks -Alex Robertson Park subject to OPG approval 7505 RF -Federal Gas Tax Total 5780.2327 Pathway Construction (Accessibility to Parks) 5780.2329 Kinsmen Park -Artificial Soccer Field Lighting 6129 Parks -Landscape Refurbishment Kinsmen Artificial Soccer Field Lighting Replacement (L.E.D). 7505 RF -Federal Gas Tax Total 5780.2329 Kinsmen Park -Artificial Soccer Field Lighting 5780.2330 Glendale Tennis Courts Resurfacing 6129 Parks -Landscape Refurbishment Glendale Tennis Courts Resurfacing 7061 R -Tennis Court Total 5780.2330 Glendale Tennis Courts Resurfacing 5780.2331 Remote Controlled Flail Mower -New 6178 Machinery & Equipment Remote Controlled Flail Mower For Phragmites Control -New 7062 R -Major Equipment Total 5780.2331 Remote Controlled Flail Mower -New 5780.2332 Playground Replacement -Southcott Park 6129 Parks -Landscape Refurbishment Replacement of playground in Southcott Park with accessibility options added-. 6183 Accessibility 7502 RF -Parkland Total 5780.2332 Playground Replacement -Southcott Park Total 5780 Parks 86 Run Date: Feb 27, 2022 Funding Expense 150,000 (150,000) (150,000) 150,000 300,000 (300,000) (300,000) 300,000 655,000 (655,000) (655,000) 655,000 80,000 (80,000) (80,000) 80,000 150,000 (150,000) (150,000) 150,000 60,000 60,000 (120,000) (120,000) . 120,000 (10,135,000) 10,135,000 City of Pickering 2024 Capital Forecast 5780 Parks 5780.2401 Community Park -Seaton P-115 Design 6429 Parks -Landscape Refurb -Seaton Community Parks (Seaton) P-115 (97 .5/2.5) 7622 RF DC -Parks & Recreation Services 7713 RF -Seaton Land Grp FIA Total 5780.2401 Community Park -Seaton P-115 Design 5780.2402 Greenwood Park Master Plan -Design 6129 Parks -Landscape Refurbishment Develop a master plan for the redevelopment of Greenwood Park 7502 RF -Parkland Total 5780.2402 Greenwood Park Master Plan -Design 5780.2403 Beachfront Park Master Plan -Phase 2 Construction 1703 Debt -15 Year 6129 Parks -Landscape Refurbishment Beachfront Park Master Plan -Phase 2 Construction -Existing washroom renovations and/or new washroom facility and associated improvements to Millennium Square, Park improvements from Millennium Square to the Frenchman's Bay harbour entrance 6183 Accessibility Total 5780.2403 Beachfront Park Master Plan -Phase 2 Constructi 5780.2404 Neighbourhood Park -Seaton P-134 6483 Accessibility -Seaton Neighbourhood Park (Seaton) P-134 located north of Whitevale Road , east of Sideline 24 7622 RF DC -Parks & Recreation Services 7713 RF -Seaton Land Grp FIA Total 5780.2404 Neighbourhood Park -Seaton P-134 5780.2405 Primary Trail Network -Seaton T-4/T-5 6483 Accessibility -Seaton Primary trail network Seaton T-4/T-5 (97.5/2.5) 7622 RF DC -Parks & Recreation Services 7713 RF -Seaton Land Grp FIA Total 5780.2405 Primary Trail Network -Seaton T-4/T-5 5780.2406 Skate Board Park -(skate spot) (Location TBD) 87 Run Date: Feb 27, 2022 Funding Expense 200,000 (195,000) (5,000) (200,000) 200,000 100,000 (100,000) (100,000) 100,000 (3,400,000) 2,550,000 850,000 (3,400,000) 3,400,000 700,000 (682,500) (17,500) (700,000) 700,000 1,090,000 (1,062,750) (27,250) (1,090,000) 1,090,000 City of Pickering 2024 Capital Forecast 5780 Parks 6129 Parks -Landscape Refurbishment Skate Board Park -(skate spot) (Location TBD) (50/50) 7022 R -DC's City's Share 7622 RF DC -Parks & Recreation Services Total 5780.2406 Skate Board Park -(skate spot) (Location TBD) 5780.2408 Pathway Reconstruction Major Oaks Park 6183 Accessibility Pathway reconstruction within Major Oaks Park 7505 RF -Federal Gas Tax Total 5780.2408 Pathway Reconstruction Major Oaks Park 5780.2409 Solar Pathway Lighting Woodview Tot Lot -New 6129 Parks -Landscape Refurbishment New lighting for pathway through Woodview Tot Lot for Safety 7505 RF -Federal Gas Tax Total 5780.2409 Solar Pathway Lighting Woodview Tot Lot -New 5780.2410 RHM Park -Tennis Court Lighting Replacement 6129 Parks -Landscape Refurbishment Replacement of tennis court lighting to LED, wiring & poles at Rick Hull Memorial Park 7505 RF -Federal Gas Tax Total 5780.2410 RHM Park -Tennis Court Lighting Replacement 5780.2411 Pathway Reconstruction Locations TBD 6183 Accessibility Pathway reconstruction various locations TBD 7505 RF -Federal Gas Tax Total 5780.2411 Pathway Reconstruction Locations TBD 5780.2412 Playground Replacement -Chickadee Park 6129 Parks -Landscape Refurbishment Replacement of playground in Chickadee Park with accessibility options added. 6183 Accessibility 7502 RF -Parkland Total 5780.2412 Playground Replacement -Chickadee Park 5780.2413 Whitevale Park -Playground Replacement 6129 Parks -Landscape Refurbishment 88 Run Date: Feb 27, 2022 Funding Expense 200,000 (100,000) (100,000) (200,000) 200,000 150,000 (150,000) (150,000) 150,000 85,000 (85,000) (85,000) 85,000 125,000 (125,000) (125,000) 125,000 300,000 (300,000) (300,000) 300,000 55,000 55,000 (110,000) (110,000) 110,000 70,000 City of Pickering 2024 Capital Forecast 5780 Parks Replacement of playground in Whitevale Park with accessibility options. 6183 Accessibility 7502 RF -Parkland Total 5780.2413 Whitevale Park -Playground Replacement 5780.2414 St. Mary Park -Soccer Field Rehabilitation 6129 Parks -Landscape Refurbishment St Mary's East Soccer Field Rehabilitation. 7502 RF -Parkland Total 5780.2414 St. Mary Park -Soccer Field Rehabilitation 5780.2415 Water Trailer -Replacement 2823 Paid from Property Taxes 6178 Machinery & Equipment Replace unit #796 (2014). Total 5780.2415 Water Trailer -Replacement 5780.2416 Backhoe / Loader -Replacement 6178 Machinery & Equipment Replace unit #717 (2014). 7062 R -Major Equipment Total 5780.2416 Backhoe/ Loader -Replacement 5780.2417 Enclosed Trailer -Replacement 2823 Paid from Property Taxes 6178 Machinery & Equipment Replace unit #759 (2019). Total 5780.2417 Enclosed Trailer -Replacement 5780.2418 Dunmoore Park -Parking Lot Reconstruction 6129 Parks -Landscape Refurbishment Pave & Curb Dunmoore Park Gravel Parking Lot. 7502 RF -Parkland . Total 5780.2418 Dunmoore Park -Parking Lot Reconstruction 5780.2419 Primary Trail Network -Seaton T-2 6483 Accessibility -Seaton Primary Trail network Seaton T-2 (97.5/2.5) 7622 RF DC -Parks & Recreation Services 89 Run Date: Feb 27, 2022 Funding Expense 70,000 (140,000) (140,000) 140,000 225,000 (225,000) (225,000) 225,000 (15,000) 15,000 (15,000) 15,000 150,000 (150,000) (150,000) 150,000 (25,000) 25,000 (25,000) 25,000 155,000 (155,000) (155,000) 155,000 360,000 (349,200) 5780 Parks 7713 RF -Seaton Land Grp FIA City of Pickering 2024 Capital Forecast Total 5780.2419 Primary Trail Network -Seaton T-2 5780.2425 BM Park -Resurface & Line Paint Basketball Court 2823 Paid from Property Taxes 6129 Parks -Landscape Refurbishment Resurface and line paint basketball court at Beverly Morgan Park. Total 5780.2425 BM Park -Resurface & Line Paint Basketball Coui 5780.2426 Playground Replacement -Diana, Princess of Wales Par 6129 Parks -Landscape Refurbishment Replacement of playground in Diana, Princess of Wales Park with accessibility options added. 6183 Accessibility 7502 RF -Parkland Total 5780.2426 Playground Replacement -Diana, Princess of Wal Total 5780 Parks 90 Run Date: Feb 27, 2022 Funding Expense (10,800) (360,000) 360,000 (30,000) 30,000 (30,000) 30,000 75,000 75,000 (150,000) (150,000) 150,000 (7,710,000) 7,710,000 City of Pickering 2025 Capital Forecast 5780 Parks 5780.2501 Water Trailer -Replacement 2823 Paid from Property Taxes 6178 Machinery & Equipment Water Trailer (replace unit #701) (2015). Total 5780.2501 Water Trailer -Replacement 5780.2502 Utility Tractor Replacement -Electric 2823 Paid from Property Taxes 6178 Machinery & Equipment Tractor (replace unit #732) (John Deere Gator 2015). Total 5780.2502 Utility Tractor Replacement -Electric 5780.2503 Tractor -Replacement 6178 Machinery & Equipment Tractor (replace unit #713) (John Deere 5100 2015). 7062 R -Major Equipment Total 5780.2503 Tractor -Replacement 5780.2504 BRK Park -North Parking Lot Paving 6129 Parks -Landscape Refurbishment Bay Ridges Kinsmen Park -Paving & Line Painting of Kinsmen North Parking Lot (pending OPG approval) 7502 RF -Parkland Total 5780.2504 BRK Park -North Parking Lot Paving 5780.2505 Pathway Reconstruction Locations TBD 6183 Accessibility Pathway reconstruction various locations TBD. 7505 RF -Federal Gas Tax Total 5780.2505 Pathway Reconstruction Locations TBD 5780.2506 Property Line Fence Replacement 6181 Other Fixed Assets Property Line Fence Replacement 7057 R -Fence Total 5780.2506 Property Line Fence Replacement 5780.2507 Krosno Creek Valley -Park Construction 6129 Parks -Landscape Refurbishment Krosno Cre,ek Valley (Hwy 401 to Bayly St.) Park Construction 91 . Run Date: Feb 27, 2022 Funding Expense (15,000) 15,000 (15,000) 15,000 (35,000) 35,000 (35,000) 35,000 90,000 (90,000) (90,000) 90,000 160,000 (160,000) (160,000) 160,000 300,000 (300,000) (300,000) 300,000 100,000 (100,000) (100,000) 100,000 270,000 City of Pickering 2025 Capital Forecast 5780 Parks 7622 RF DC -Parks & Recreation Services 7713 RF -Seaton Land Grp FIA Total 5780.2507 Krosno Creek Valley -Park Construction 5780.2509 Primary Trail Network -Seaton T-9 6483 Accessibility -Seaton Primary Trail Network -Seaton T9 (97.5/2.5) 7622 RF DC -Parks & Recreation Services 7713 RF -Seaton Land Grp FIA Total 5780.2509 Primary Trail Network -Seaton T-9 5780.2510 Primary Trail Network -Seaton T-10 6483 Accessibility -Seaton Primary Trail Network-Seaton T10 (97.5/2.5) 7622 RF DC -Parks & Recreation Services 7713 RF -Seaton Land Grp FIA Total 5780.2510 Primary Trail Network -Seaton T-10 5780.2512 Baseball Light Replacement -Kirkey Field 6129 Parks -Landscape Refurbishment Baseball Light Replacement -Kirkey Field -Replace existing lights with LED 7505 RF -Federal Gas Tax Total 5780.2512 Baseball Light Replacement -Kirkey Field 5780.2513 Playground Replacement -Bayshore Tot Lot Park 6129 Parks -Landscape Refurbishment Replacement of playground in Bayshore Park with accessibility options added. 6183 Accessibility 7502 RF -Parkland Total 5780.2513 Playground Replacement -Bayshore Tot Lot Park 5780.2514 Playground Replacement -Lynn Heights Park 6129 Parks -Landscape Refurbishment Replacement of playground in Lynn Heights Park with accessibility options added. 6183 Accessibility 7502 RF -Parkland Total 5780.2514 Playground Replacement -Lynn Heights Park 92 Run Date: Feb 27, 2022 Funding Expense (243,000) (27,000) (270,000) 270,000 140,000 (136,500) (3,500) (140,000) 140,000 320,000 (312,000) (8,000) (320,000) 320,000 600,000 (600,000) (600,000) 600,000 60,000 60,000 (120,000) (120,000) 120,000 60,000 ' 60,000 (120,000) (120,000) 120,000 5780 Parks City of Pickering 2025 Capital Forecast 5780.2515 Playground Replacement -Bonita Park 6129 Parks -Landscape Refurbishment Replacement of playground in Bonita Park with accessibility options added. 6183 Accessibility 7502 RF -Parkland Total 5780.2515 Playground Replacement -Bonita Park Total 5780 Parks 93 Run Date: Feb 27, 2022 Funding Expense 60,000 60,000 (120,000) (120,000) 120,000 (2,390,000) 2,390,000 City of Pickering 2026 Capital Forecast 5780 Parks 5780.2601 Electric UV -Replacement 6178 Machinery & Equipment Replaces Gas Powered Unit #707 John Deere Gator (2016). 7062 R -Major Equipment Total 5780.2601 Electric UV -Replacement 5780.2602 Enclosed Trailer -Replacement (2) 6178 Machinery & Equipment Enclosed Trailer -replace unit #778 and #779 (2018 CAN Trailers). 7040 R -Vehicle Replacement Total 5780.2602 Enclosed Trailer -Replacement (2) 5780.2603 Tractor -Replacement 6178 Machinery & Equipment Tractor-replace unit #761 (2017 John Deere Tractor). 7062 R -Major Equipment Total 5780.2603 Tractor -Replacement 5780.2604 Enclosed Trailer -New 2823 Paid from Property Taxes 6478 Miscellaneous Equipment -Seaton Enclosed Trailer for Seaton Total 5780.2604 Enclosed Trailer -New 5780.2605 Tile Drainage Sport Fields 6129 Parks -Landscape Refurbishment Add tile drainage to existing sport fields. 7502 RF -Parkland Total 5780.2605 Tile Drainage Sport Fields 5780.2606 Pathway Reconstruction Locations TBD 6183 Accessibility Pathway reconstruction various locations TBD. 7505 RF -Federal Gas Tax Total 5780.2606 Pathway Reconstruction Locations TBD 5780.2607 Playground Replacement -BRK Park 6129 Parks -Landscape Refurbishment Replacement of playground in BRK Park with accessibility options added. 94 Run Date: Feb 28, 2022 Funding Expense 35,000 (35,000) (35,000) 35,000 50,000 (50,000) (50,000) 50,000 90,000 (90,000) (90,000) 90,000 (25,000) 25,000 (25,000) 25,000 300,000 (300,000) (300,000) 300,000 300,000 (300,000) (300,000) 300,000 75,000 5780 Parks 6183 Accessibility 7502 RF -Parkland City of Pickering 2026 Capital Forecast Total 5780.2607 Playground Replacement-BRK Park 5780.2608 Playground Replacement -Clearside Park 6129 Parks -Landscape Refurbishment Replacement of playground in Clearside Park JR Playground with accessibility options added. 6183 Accessibility 7502 RF -Parkland Total 5780.2608 Playground Replacement -Clearside Park 5780.2609 Playground Replacement -Glengrove Park 6129 Parks -Landscape Refurbishment Replacement of playground in Glengrove Park with accessibility options added. 6183 Accessibility 7502 RF -Parkland Total 5780.2609 Playground Replacement -Glengrove Park 5780.2610 Playground Replacement -Pinegrove Park 6129 Parks -Landscape Refurbishment Replacement of playground in Pinegrove Park with accessibility options added. 6183 Accessibility 7502 RF -Parkland Total 5780.2610 Playground Replacement -Pinegrove Park 5780.2611 Village Green -Seaton P-116 6429 Parks -Landscape Refurb -Seaton Village Green Seaton P-116 (97.5/2.5) 7060 R -Seaton Land Grp FIA 7622 RF DC -Parks & Recreation Services Total 5780.2611 Village Green -Seaton P-116 5780.2612 Village Green -Seaton P-117 6429 Parks -Landscape Refurb -Seaton Village Green Seaton P-117 (97.5/2.5) 7060 R -Seaton Land Grp FIA 7622 RF DC -Parks & Recreation Services 95 Run Date: Feb 27, 2022 Funding Expense 75,000 (150,000) (150,000) 150,000 60,000 60,000 . (120,000) (120,000) 120,000 60,000 60,000 (120,000) (120,000) 120,000 60,000 60,000 (120,000) (120,000) 120,000 230,000 (5,750) (224,250) (230,000) 230,000 540,000 (13,500) (526,500) City of Pickering 2026 Capital Forecast 5780 Parks Total 5780.2612 Village Green -Seaton P-117 5780.2613 Village Green -Seaton P-118 6429 Parks -Landscape Refurb -Seaton Village Green Seaton P-118 (97.5/2.5) 7060 R -Seaton Land Grp FIA 7622 RF DC -Parks & Recreation Services Total 5780.2613 Village Green -Seaton P-118 5780.2614 Village Green -Seaton P-119 6429 Parks -Landscape Refurb -Seaton Village Green Seaton P-119 (97.5/2.5) 7060 R -Seaton Land Grp FIA 7622 RF DC -Parks & Recreation Services Total 5780.2614 Village Green -Seaton P-119 5780.2615 Community Park -Construction -Seaton P-115 1741 DC Debt-15 Year (Parks & Rec) 6429 Parks -Landscape Refurb -Seaton Community Park-Construction -Seaton P-115 (97.5/2.5) 7713 RF -Seaton Land Grp FIA Total 5780.2615 Community Park -Construction -Seaton P-115 5780.2616 Trail from Creekside Park to SWM Pond 6183 Accessibility Trail from Creekside Park to SWM Pond -Asphalt -Design, Approvals and Construction 7502 RF -Parkland Total 5780.2616 Trail from Creekside Park to SWM Pond 5780.2617 Trail -Hydro Corridor -Liverpool to Whites 6183 Accessibility Multi Purpose Trail -Hydro Corridor (Liverpool Rd. to Whites Rd.) (50/50) 7022 R -DC's City's Share 7622 RF DC -Parks & Recreation Services Total 5780.2617 Trail -Hydro Corridor -Liverpool to Whites 5780.2618 BRK Park -South Parking Lot Paving 6129 Parks -Landscape Refurbishment Pave Kinsmen South Parking Lot -pending OPG approval 96 Run Date: Feb 27, 2022 Funding Expense (540,000) 540,000 230,000 (5,750) (224,250) (230,000) 230,000 480,000 (12,000) (468,000) (480,000) 480,000 (2,730,000) 2,800,000 (70,000) (2,800,000) 2,800,000 230,000 (230,000) (230,000) 230,000 982,000 (491,000) (491,000) (982,000) 982,000 160,000 5780 Parks 7502 RF -Parkland City of Pickering 2026 Capital Forecast Total 5780.2618 BRK Park -South Parking Lot Paving 5780.2619 Trail -Wharf Street to Sandy Beach Road 6183 Accessibility Trail -Wharf Street to Sandy Beach Road 7022 R -DC's City's Share 7622 RF DC -Parks & Recreation Services Total 5780.2619 Trail -Wharf Street to Sandy Beach Road 5780.2620 Community Park -Greenwood Conservation Lands-Pha! 1704 Debt -20 year 1741 DC Debt-15 Year (Parks & Rec) 6129 Parks -Landscape Refurbishment Community Park -Greenwood Conservation Lands -land acquisition and phase 1 construction 6183 Accessibility 6265 Land Acquisition & Disp 7022 R -DC's City's Share Total 5780.2620 Community Park -Greenwood Conservation Land Total 5780 Parks 97 Run Date: Feb 27, 2022 Funding Expense (160,000) (160,000) 160,000 431,000 · (215,500) (215,500) (431,000) 431,000 (3,040,500) (3,036,500) 4,555,000 1,518,000 1,504,000 (1,500,000) (7,577,000) 7,577,000 (14,970,000) 14,970,000 5990 Fleet Vehicles Expenditures 6157 Vehicles -under $100,000 6158 Vehicles -Over $100,000 6159 Fire Veh -Over $100,000 6178 Machinery & Equipment 6457 Vehicles -Under $100,000 -Seaton 6458 Vehicles -Over $100,000 -Seaton Total Expenditures Financing 1703 Debt-15 Year City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 1,000,000 1,200,000 1,005,000 219,000 455,000 300,000 4179.000 (1,224,000) 1708 DC Debt-15 Year (Protective Services) 1726 DC Debt-5 Year (Other Services Related to Hwy) (370,000) 7040 R -Vehicle Replacement (2,200,000) 7622 RF DC -Parks & Recreation Services (385,000) 7708 RF -Operations Centre 7713 RF -Seaton Land Grp FIA Total Financing (4,179,000) 98 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 410,000 185,000 135,000 720,000 1,150,000 595,000 1,025,000 1,230,000 450,000 270,000 70,000 100,000 80,000 1,325,000 400,000 4.000.000 2 935 000 1 210 000 (1,250,000) (1,500,000) (1,200,000) (300,000) (300,000) (1,080,000) (1,335,000) (730,000) (70,000) (100,000) (180,000) (50,000) (50,000) (4,000,000) (2,935,000) (1,210,000) City of Pickering 2023 Capital Forecast 5990 Fleet Vehicles 5220.2301 Midsize SUV Replacement (2) 6157 Vehicles -under $100,000 Two Midsize SUVs -replace unit #418 and #419 (2016 Jeep Patriots) (5220 By-Law). 7040 R -Vehicle Replacement Total 5220.2301 Midsize SUV Replacement (2) 5220.2302 1/2 Ton Pickup Truck Replacement 6157 Vehicles -under $100,000 1/2 Ton Pickup Truck-replace unif#420 (2017 Dodge Ram) 7040 R -Vehicle Replacement Total 5220.2302 1/2 Ton Pickup Truck Replacement 5311.2310 1 Ton Dump Truck with Aluminum Body and Crane -Nev 6158 Vehicles -Over $100,000 1 Ton Dump Truck Roll Off body with Sea-Can, Dump Body, and Chipper Body Attachments for stormwater management -New 7040 R -Vehicle Replacement Total 5311.2310 1 Ton Dump Truck with Aluminum Body and Cran 5311.2311 Utility Truck -New 6158 Vehicles -Over $100,000 Utility truck for stormwater management materials and crew 7040 R -Vehicle Replacement Total 5311.2311 Utility Truck -New 5311.2312 4 Ton Dump Truck Roll-off Body -New 6158 Vehicles -Over $100,000 4 Ton Dump Truck Roll-off Body with Sea-Can, Dump Body, and Chipper Body Attachments for Property Line Fence Repair Crew 7040 R -Vehicle Replacement Total 5311.2312 4 Ton Dump Truck Roll-off Body-New 5315.2303 1/2 Ton Pickup Truck -Replacement 6157 Vehicles -under $100,000 1/2 Ton Pickup Truck-replace unit #210 (2015 Chevy Silverado) (5315 Operations Centre) 7040 R -Vehicle Replacement Total 5315.2303 1/2 Ton Pickup Truck -Replacement 5319.2302 4 Ton Dump Truck with Snow Plow and Wing -Replacen 99 Run Date: Feb 27, 2022 Funding Expense 100,000 (100,000) (100,000) 100,000 50,000 (50,000) (50,000) 50,000 175,000 (175,000) (175,000) 175,000 150,000 (150,000) (150,000) 150,000 200,000 (200,000) (200,000) 200,000 45,000 (45,000) (45,000) 45,000 5990 Fleet Vehicles 6158 Vehicles -Over $100,000 City of Pickering 2023 Capital Forecast 4 Ton Dump Truck with Snow Plow and Wing -replace unit #41 (2014 International) (5319 Roads Equipment). 7040 R -Vehicle Replacement Total 5319.2302 4 Ton Dump Truck with Snow Plow and Wing -Re 5319.2303 4 Ton Dump Truck with Snow Plow and Wing and Brine 1726 DC Debt -5 Year (Other Services Related to Hwy) 6458 Vehicles -.Over $100,000 -Seaton 4 Ton Dump Truck with Snow Plow and Wing and Brine Tank (Growth) (5319 Roads Equipment) Total 5319.2303 4 Ton Dump Truck with Snow Plow and Wing and 5319.2305 1 Ton Dump Truck with Aluminum Body and Crane -Nev 6158 Vehicles -Over $100,000 1 Ton Dump Truck for bridge crew (5319 Roads Equipment) 7040 R -Vehicle Replacement Total 5319.2305 1 Ton Dump Truck with Aluminum Body and Cran 5319.2306 1 Ton Truck with Aluminum Dump Body & Tailgate Lift G 1726 DC Debt -5 Year (Other Services Related to Hwy) 6457 Vehicles -Under $100,000 -Seaton 1 Ton Truck with Aluminum Dump Body & Tailgate Lift Gate - (Growth) New (5319 Roads Equipment). Total 5319.2306 1 Ton Truck with Aluminum Dump Body & Tailgat 5340.2307 Fire Pumper Rescue Replacement 1703 Debt-15 Year 6159 Fire Veh -Over $100,000 Fire Pumper Rescue -replace unit #542 (2011 Smeal) (5340 Fire Services). 6178 Machinery & Equipment Total 5340.2307 Fire Pumper Rescue Replacement 5340.2311 Midsize SUV -Replacement (5) 6157 Vehicles -under $100,000 Five Mid Size SUVs -replace units #578 (2016 Jeep Patriot) , #579 (2016 Jeep Patriot), #581 (2016 Jeep Patriot), #582 (2016 Jeep Patriot), and #580 (2016 Jeep Patriot) (5340 Fire Services). 7040 R -Vehicle Replacement . 100 Run Date: Feb 27, 2022 Funding Expense 300,000 (300,000) (300,000) 300,000 (300,000) 300,000 (300,000) 300,000 175,000 (175,000) (175,000) 175,000 (70,000) 70,000 (70,000) 70,000 (1,224,000) 1,005,000 219,000 (1,224,000) 1,224,000 225,000 (225,000) City of Pickering 2023 Capital Forecast 5990 Fleet Vehicles Total 5340.2311 Midsize SUV -Replacement (5) 5340.2312 .1/2 Ton Pickup Truck -Replacement (2) 6157 Vehicles -under $100,000 1/2 Ton Pickup Truck -replace unit #583, #584 (2015 GMC) (5340 Fire Services). 7040 R -Vehicle Replacement Total 5340.2312 1/2 Ton Pickup Truck -Replacement (2) 5612.2301 Electric Vehicle -New 6157 Vehicles -under $100,000 Electric Vehicle New (5612 Building Services). 7040 R -Vehicle Replacement Total 5612.2301 Electric Vehicle -New 5613.2301 1/2 Ton Pickup Truck -Replacement 6157 Vehicles -under $100,000 1/2 Ton Pickup Truck-replace unit #644 (2016 Dodge). (5613 Water Resources & Development Services) 7040 R -Vehicle Replacement Total 5613.2301 1/2 Ton Pickup Truck -Replacement 5613.2302 Midsize SUV Replacement (4) 6157 Vehicles -under $100,000 Four Midsize SUVs -replace units #645,646,647 (2017 Jeeps) and unit #643 (2015 Chevrolet Equinox) (5613 Water Resources & Development Services). 7040 R -Vehicle Replacement Total 5613.2302 Midsize SUV Replacement (4) 5780.2307 Garbage Packer with Crane -Replacement 6158 Vehicles -Over $100,000 Garbage Packer with Crane -replace unit #733 (2017 Ford) (5780 Parks). 7040 R -Vehicle Replacement Total 5780.2307 Garbage Packer with Crane ~ Replacement 5780.2308 1/2 Ton Pickup Truck Replacement 6157 Vehicles -under $100,000 1/2 Ton Pickup Truck -replace unit #720 (2016 Dodge) (5780 Parks). 101 Run Date: Feb 27, 2022 Funding Expense (225,000) 225,000 90,000 (90,000) (90,000) 90,000 60,000 (60,000) (60,000) 60,000 50,000 (50,000) (50,000) 50,000 180,000 (180,000) (180,000) 180,000 200,000 (200,000) (200,000) 200,000 45,000 City of Pickering 2023 Capital Forecast 5990 Fleet Vehicles 7040 R -Vehicle Replacement Total 5780.2308 1/2 Ton Pickup Truck Replacement 5780.2309 Cargo Van Replacement 6157 Vehicles -under $100,000 Cargo Van -replace unit #735 (2016 Ford F550) (5780 Parks). 7040 R -Vehicle Replacement Total 5780.2309 Cargo Van Replacement 5780.2316 1/2 Ton Pick-up Truck -New 6457 Vehicles -Under $100,000 -Seaton 1/2 Ton Pick-up Truck -New (5780 Parks) 7622 RF DC -Parks & Recreation Services Total 5780.2316 1/2 Ton Pick-up Truck -New 5780.2317 1 Ton Dump Truck with Tailgate Lift -Replacement 6157 Vehicles -under $100,000 1 Ton Dump Truck -replace unit #747 (2016 Dodge Ram) (5780 Parks). 7040 R -Vehicle Replacement Total 5780.2317 1 Ton Dump Truck with Tailgate Lift -Replacemer 5780.2321 3/4 Ton Pickup Truck with Slide-in Salter and Plow -Ne, 6457 Vehicles -Under $100,000 -Seaton 3/4 Ton Pickup Truck with Slide-in Salter and Plow -Growth (5780 Parks). 7622 RF DC -Parks & Recreation Services Total 5780.2321 3/4 Ton Pickup Truck with Slide-in Salter and PIO\ 5780.2322 3/4 Ton Pick-up Truck -New 6457 Vehicles -Under $100,000 -Seaton 3/4 Ton Pick-up Truck -Growth (5780 Parks). 7622 RF DC -Parks & Recreation Services Total 5780.2322 3/4 Ton Pick-up Truck -New 5780.2323 1 Ton Dump Truck with Tailgate Lift • New (Seaton) (3) 6457 Vehicles -Under $100,000 -Seaton 3 1 Ton Dump Truck new for Seaton (5780 Parks). 7622 RF DC -Parks & Recreation Services Total 5780.2323 1 Ton Dump Truck with Tailgate Lift• New (Seato1 Total 5990 Fleet Vehicles 102 Run Date: Feb 27, 2022 Funding Expense (45,000) (45,000) 45,000 45,000 (45,000) (45,000) 45,000 45,000 (45,000) (45,000) 45,000 110,000 (110,000) (110,000) 110,000 70,000 (70,000) (70,000) 70,000 60,000 (60,000) (60,000) 60,000 210,000 (210,000) (210,000) 210,000 (4,179,000) 4,179,000 5990 Fleet Vehicles 5220.2401 Midsize SUV -Replacement 6157 Vehicles -under $100,000 City of Pickering 2024 Capital Forecast Midsize SUV -replace unit #421 (Mitsubishi 2017)(5220 Bylaw). 7040 R -Vehicle Replacement Total 5220.2401 Midsize SUV -Replacement 5315.2402 Mid-Size 4 Wheel Drive Vehicle -New 6157 Vehicles -under $100,000 Midsize 4 Wheel Drive -New Security Specialist (Corporate Security) (5919) 7708 RF -Operations Centre Total 5315.2402 Mid-Size 4 Wheel Drive Vehicle -New 5319.2406 4 Ton Dump Truck with Snow Plow and Wing and Brine 1726 DC Debt-5 Year (Other Services Related to Hwy) 6458 Vehicles -Over $100,000 -Seaton 4 Ton Dump Truck with Snow Plow and Wing and Brine Tank (Growth) (5319 Roads Equipment) Total 5319.2406 4 Ton Dump Truck with Snow Plow and Wing and 5319.2407 Pickup Truck -Replacement 6157 Vehicles -under $100,000 Pickup Truck -replace unit #027 (Dodge 2017)(5319 Roads Equipment). 7040 R -Vehicle Replacement Total 5319.2407 Pickup Truck -Replacement 5319.2408 4 Ton Dump Truck with Snow Plow & Wing -Replaceme 6158 Vehicles -Over $100,000 4 Ton Dump Truck with Snow Plow & Wing -replace unit #046 (Mack 2017)(5319 Roads Equipment). 7040 R -Vehicle Replacement Total 5319.2408 4 Ton Dump Truck with Snow Plow & Wing -Repl 5319.2409 5 Ton Dump Truck with Snow Plow & Wing -Replaceme 6158 Vehicles -Over $100,000 5 Ton Dump Truck with Snow Plow & Wing -replace unit #045 (Mack 2017) (5319 Roads Equipment). 7040 R -Vehicle Replacement Total 5319.2409 5 Ton Dump Truck with Snow Plow & Wing -Repl 103 Run Date: Feb 27, 2022 Funding Expense 45,000 (45,000) (45,000) 45,000 50,000 (50,000) (50,000) 50;000 (300,000) 300,000 (300,000) 300,000 45,000 (45,000) (45,000) 45,000 300,000 (300,000) (300,000) 300,000 320,000 (320,000) (320,000) 320,000 City of Pickering 2024 Capital Forecast 5990 Fleet Vehicles 5340.2404 Fire Truck -Pumper Rescue Replacement 1703 Debt-15 Year 6159 Fire Veh -Over $100,000 Fire Truck -Pumper Rescue Replacement -replace unit #543 (2010 Smeal Pumper)(5340 Fires Services). 6178 Machinery & Equipment Total 5340.2404 Fire Truck -Pumper Rescue Replacement 5340.2405 Midsize SUV -Replacement (2) 6157 Vehicles -under $100,000 Midsize SUV -replace unit #585, #576 (2017 Mitsubishi) (5340 Fires Services). 7040 R -Vehicle Replacement Total 5340.2405 Midsize SUV -Replacement (2) 5340.2406 Fire Pumper Rescue Seaton -New 1708 DC Debt-15 Year (Protective Services) 6178 Machinery & Equipment 6458 Vehicles -Over $100,000-Seaton Fire Pumper Rescue new for New Fire Station B (5340 Fire Services). 7713 RF -Seaton Land Grp FIA Total 5340.2406 Fire Pumper Rescue Seaton -New 5613.2401 Midsize SUV -Replacements (3) 6157 Vehicles -under $100,000 Three Midsize SUVs -replace unit #648, #649, & #650 (Mitsubishi 2017)(5613 Water Resources & Development Services). 7040 R -Vehicle Replacement Total 5613.2401 Midsize SUV -Replacements (3) 5780.2421 1 Ton Dump Truck with Tailgate Lift -New (Seaton) (1) 6457 Vehicles -Under $100,000 -Seaton 1 Ton Dump Truck New for Growth (5780 Parks). 7622 RF DC -Parks & Recreation Services Total 5780.2421 1 Ton Dump Truck with Tailgate Lift -New (Seato1 5780.2422 Midsize SUV -Replacement 6157 Vehicles -under $100,000 Midsize SUV -replace unit #780 (Mitsubishi 2017)(5780 Parks). 104 Run Date: Feb 27, 2022 Funding Expense (1,250,000) 1,025,000 225,000 (1,250,000) 1,250,000 90,000 (90,000) (90,000) 90,000 (1,200,000) 225,000 1,025,000 (50,000) (1,250,000) 1,250,000 135,000 (135,000) (135,000) 135,000 70,000 (70,000) (70,000) 70,000 45,000 5990 Fleet Vehicles 7040 R -Vehicle Replacement City of Pickering 2024 Capital Forecast Total 5780.2422 Midsize SUV~ Replacement 5780.2423 1 Ton Truck with Aluminum Dump Body and Tailgate Lif 6158 Vehicles -Over $100,000 1 Ton Truck with Aluminum Dump Body -replace unit #777 (Dodge 2017)(5780 Parks). 7040 R -Vehicle Replacement Total 5780.2423 1 Ton Truck with Aluminum Dump Body and Tailg Total 5990 Fleet Vehicles 105 Run Date: Feb 27, 2022 Funding Expense (45,000) (45,000) 45,000 100,000 (100,000) (100,000) 100,000 (4,000,000) 4,000,000 5990 Fleet Vehicles City of Pickering 2025 Capital Forecast 5311.2505 1 Ton Boom Truck with Bucket -Replacement 6158 Vehicles -Over $100,000 1 Ton Boom Truck with Bucket replacement (replace unit #794 2013 Ford) (5311 Property Maintenance). 7040 R -Vehicle Replacement Total 5311.2505 1 Ton Boom Truck with Bucket -Replacement 5319.2505 4 Ton Dump Truck with Snow Plow and Wing -Replacen 6158 Vehicles -Over $100,000 4 Ton Dump Truck with Snow Plow and Wing -replace unit#043 & #044 (2016 Mack) (5319 Roads Equipment). 7040 R -Vehicle Replacement Total 5319.2505 4 Ton Dump Truck with Snow Plow and Wing -Re 5319.2506 1 Ton Truck with Aluminum Dump Body & Tailgate Lift Fi 6157 Vehicles -under $100,000 1 Ton Truck with Aluminum Dump Body and Tailgate Lift -replace unit# 768 (2018 Dodge Ram) (5319 Roads Equipment). 7040 R -Vehicle Replacement Total 5319.25061 Ton Truck with Aluminum Dump Body & Tailgat 5340.2508 Fire Truck -Aerial Ladder Replacement 1703 Debt-15 Year 6159 Fire Veh -Over $1 0Q,000 Fire Truck -Rescue Replacement -replace unit #545 (2013 Smeal) (5340 Fires Services). 6178 Machinery & Equipment Total 5340.2508 Fire Truck -Aerial Ladder Replacement 5340.2509 1/2 Ton Pickup Truck -Replacement 6157 Vehicles -under $100,000 1/2 Ton Pickup truck replacement unit #586 (2017 Ford) (5340 Fire) 7040 R -Vehicle Replacement Total 5340.25091/2 Ton Pickup Truck -Replacement 5612.2501 Electric Vehicle -Replacement 6157 Vehicles -under $100,000 Electric Vehicle replace unit #651 (2018 Chevy Bolt) (5612 Building Services). 106 Run Date: Feb 28, 2022 Funding Expense 150,000 (150,000) (150,000) 150,000 600,000 (600,000) (600,000) 600,000 75,000 (75,000) (75,000) 75,000 (1,500,000) 1,230,000 270,000 {1,500,000) 1,500,000 50,000 (50,000) (50,000) 50,000 60,000 5990 Fleet Vehicles 7040 R -Vehicle Replacement City of Pickering 2025 Capital Forecast Total 5612.2501 Electric Vehicle -Replacement 5780.2516 1 Ton Dump Truck with Aluminum Body and Lift Gate -I 6158 Vehicles -Over $100,000 1 Ton Dump Truck -replace unit #769 (2017 Dodge Ram), #777 (2016 Dodge Ram), #763 (2018 Dodge Ram) and #764 (2019 Dodge Ram) (5780 Parks) 7040 R -Vehicle Replacement Total 5780.2516 1 Ton Dump Truck with Aluminum Body and Lift , 5780.2518 1 Ton Dump Truck with Tailgate Lift -New(1) 6457 Vehicles -Under $100,000 -Seaton 1 Ton Dump Truck New for Growth (5780 Parks). 7622 RF DC -Parks & Recreation Services Total 5780.25181 Ton Dump Truck with Tailgate Lift-New(1) Total 5990 Fleet Vehicles 107 Run Date: Feb 27, 2022 Funding Expense (60,000) (60,000) 60,000 400,000 (400,000) (400,000) 400,000 100,000 (100,000) (100,000) 100,000 (2,935,000) 2,935,000 City of Pickering 2026 Capital Forecast 5990 Fleet Vehicles 5220.2601 1/2 Ton Pickup Truck Replacement 6157 Vehicles -under $100,000 1/2 Ton Pickup Truck-replace unit #424 (2019 Dodge) (5220 By-law). 7040 R -Vehicle Replacement Total 5220.26011/2 Ton Pickup Truck Replacement 5315.2602 1/2 Ton Pickup Truck.Replacement 6157 Vehicles -under $100,000 1/2 Ton Pickup Truck -replace unit #211 (2017 Dodge) (5315 Operation Admin). 7040 R -Vehicle Replacement Total 5315.26021/2 Ton Pickup Truck Replacement 5319.2603. 4 Ton Dump Truck with Snow Plow, Wing & Brine Tank• 1726 DC Debt-5 Year (Other Services Related to Hwy) 6458 Vehicles -Over $100,000 -Seaton 4 Ton Dump Truck with Snow Plow, Wing and Brine Tank (Growth) (5319 Roads Equipment). Total 5319.2603 4 Ton Dump Truck with Snow Plow, Wing & Brine 5319.2604 1 Ton Dump Truck with Tailgate Lift -Replacement 6158 Vehicles -Over $100,000 1 Ton Dump Truck Replacement Unit #769 (2017 Dodge) (5319 Roads). 7040 R -Vehicle Replacement Total 5319.26041 Ton Dump Truck with Tailgate Lift-Replacemer 5340.2606 Midsize SUV -Replacement (2) 6158 Vehicles -Over $100,000 Midsize SUV -replace unit #587 & #588 (2020 Dodge) (5340 Fire). 7040 R -Vehicle Replacement Total 5340.2606 Midsize SUV -Replacement (2) 5340.2607 Command Vehicle Replacement 6158 Vehicles -Over $100,000 Command Vehicle replace unit #576 (2017 Chevrolet) (5340 Fire). 7040 R -Vehicle Replacement Total 5340.2607 Command Vehicle Replacement 5719.2604 1/2 Ton Pickup Truck Replacement 108 Run Date: Feb 27, 2022 Funding Expense 45,000 (45,000) (45,000) 45,000 45,000 (45,000) (45,000) 45,000 (300,000) 300,000 (300,000) 300,000 100,000 (100,000) (100,000) 100,000 150,000 (150,000) . (150,000) 150,000 100,000 (100,000) (100,000) 100,000 City of Pickering 2026 Capital Forecast 5990 Fleet Vehicles 6157 Vehicles -under $100,000 1/2 Ton Pickup Truck-replace unit #787 (2017 Dodge) (5719 Community Centres). 7040 R -Vehicle Replacement Total 5719.26041/2 Ton Pickup Truck Replacement 5780.2621 1 Ton Dump Truck with Tailgate Lift -New 6458 Vehicles -Over $100,000 -Seaton 1 Ton Dump Truck New (Growth) (5780 Parks). 7622 RF DC -Parks & Recreation Services Total 5780.2621 1 Ton Dump Truck with Tailgate Lift -New 5780.2622 1 Ton Dump Truck with Tailgate Lift -Replacement (2) 6158 Vehicles -Over $100,000 1 Ton Dump Truck-replace unit# 747 (2016 Dodge), #.738 (2017 Dodge) (5780 Parks) 7040 R -Vehicle Replacement Total 5780.26221 Ton Dump Truck with Tailgate Lift-Replacemer 5780.2623 1/2 Ton Pickup Truck Replacement .6158 Vehicles -Over $100,000 1/2 Ton Pickup Truck -replace unit #734 (2017 Dodge) (5780 Parks). 7040 R ~ Vehicle Replacement Total 5780.2623 1/2 Ton Pickup Truck Replacement 5780.2624 3/4 Ton Pickup Truck with Tow Package -New 6457 Vehicles -Under $100,000 -Seaton 3/4 Ton Pickup Truck with Tow Package New (Growth) (5780 Parks). 7622 RF DC -Parks & Recreation Services Total 5780.2624 3/4 Ton Pickup Truck with Tow Package -New Total 5990 Fleet Vehicles 109 Run Date: Feb 27, 2022 Funding Expense 45,000 (45,000) (45,000) 45,000 100,000 (100,000) (100,000) 100,000 200,000 (200,000) (200,000) 200,000 45,000 (45,000) (45,000) 45,000 80,000 (80,000) (80,000) 80,000 (1,210,000) 1,210,000 City of Pickering Multi-Year Capital Forecast 2023 -2026 Corporate Services Dept. Summary 2023 Forecast Expenditures 6173 Furniture & Fixtures 330,000 6174 System & Software Upgrade 1,500,000 6175 Hardware Replacements 145,000 6177 IT Infrastructure 300,000 6477 IT Infrastructure -Seaton Total Expenditures 2 275.000 Financing 2823 Paid from Property Taxes 7001 R -Capital Equipment Replacement (445,000) 7021 R -Rate Stabilization (1,830,000) Total Financing (2,275,000) 110 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 200,000 78,000 50,000 226,000 140,000 408,000 496,000 150,000 714 000 200 000 834 000 (714,000) (200,000) (834,000) (714,000) (200,000) (834,000) 5206 Information Technology Expenditures 6174 System & Software Upgrade 6175 Hardware Replacements 6177 IT Infrastructure 6477 IT Infrastructure -Seaton Total Expenditures Financing 2823 Paid from Property Taxes 7001 R -Capital Equipment Replacement 7021 R -Rate Stabilization Total Financing City of Pickering Multi-Year Capital Forecast· 2023 -2026 2023 Forecast 1,500,000 145,000 300,000 1945000 (445,000) (1,500,000) (1,945,000) 1 1 1 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 200,000 78,000 50,000 226,000 140,000 408,000 496,000 150,000 714 000 200 000 834 000 (714,000) (200,000) (834,000) (714,000) · (200,000) (834,000) City of Pickering 2023 Capital Forecast 5206 Information Technology 5206.2301 Technology Infrastructure 6175 Hardware Replacements Corporate Application Integration -Automate and integrate systems to move away from manual import/export processes for Corporate Applications. This will include an automated service to extract, transform and load data into different systems as well as support the development of application program interfaces. 7001 R -Capital Equipment Replacement Total 5206.2301 Technology Infrastructure 5206.2302 Storage Area Network Upgrades 6177 IT Infrastructure The City's SAN is end of service and needs to be replaced. The SAN provides the storage infrastructure for all City data. This project includes both SAN storage and SAN network infrastructure. 7001 R -Capital Equipment Replacement Total 5206.2302 Storage Area Network Upgrades 5206.2303 Virtual Desktop Infrastructure 6177 IT Infrastructure New server infrastructure is required to upgrade the City's virtual desktop infrastructure environment used by staff to connect to applications and systems. This upgrade is required for improved audio/video transmission, reduced IT support requirements and to provide a better online collaboration experience. 7001 R -Capital Equipment Replacement Total 5206.2303 Virtual Desktop Infrastructure 5206.2304 5 Yrs. PC Upgrades 6175 Hardware Replacements Replacement of End User Computing Devices 7001 R -Capital Equipment Replacement Total 5206.2304 5 Yrs. PC Upgrades 5206.2305 Website Replacement and Customized Integrations proj1 6174 System & Software Upgrade 11 2 Run Date: Feb 27, 2022 Funding Expense 77,000 (77,000) (77,000) 77,000 178,000 (178,000) (178,000) 178,000 122,000 (122,000) (122,000) 122,000 68,000 (68,000) (68,000) 68,000 1,500,000 5206 Information Technology City of Pickering 2023 Capital Forecast City staff are currently developing a comprehensive, multi-year strategy to transform City services to digitally powered services, available online for customers 24/7. Once the strategy is completed, the City plans to replace its current website with a more modern and functional website that would better support robust eCommerce options and offer customized integrations (e.g., Customer Portal, Tax Portal, ePayments & SAP Integration, Live Chat) that would enhance service delivery. 7021 R -Rate Stabilization Total 5206.2305 Website Replacement and Customized lntegratior Total 5206 Information Technology 113 Run Date: Feb 27, 2022 Funding Expense (1,500,000) (1,500,000) 1,500,000 (1,945,000) 1,945,000 5206 Information Technology 5206.2402 Technology Infrastructure 2823 Paid from Property Taxes 6177 IT Infrastructure City of Pickering 2024 Capital Forecast IT Security Network and System Upgrades. Enhanced Security Infrastructure and Monitoring System will be required to combat cyber security threats. Total 5206.2402 Technology Infrastructure 5206.2403 Technology Services 2823 Paid from Property Taxes 6477 IT Infrastructure -Seaton Network connectivity infrastructure to replace annual costs for WAN Network. This would include infrastructure required for new facilities in Seaton. Total 5206.2403 Technology Services 5206.2404 5 Yr PC Upgrades 2823 Paid from Property Taxes 6175 Hardware Replacements Replacement of End User Computing Devices Total 5206.2404 5 Yr PC Upgrades Total 5206 Information Technology 114 Run Date: Feb 27, 2022 Funding Expense (140,000) 140,000 (140,000) 140,000 (496,000) 496,000 (496,000) 496,000 (78,000) 78,000 (78,000) 78,000 (714,000) 714,000 5206 Information Technology 5206.2502 Technology Services 2823 Paid from Property Taxes 6477 IT Infrastructure -Seaton City of Pickering 2025 Capital Forecast Introduction of Network and Integrated Resident Technology Solutions at City Parks and Trails (Phase 1) Total 5206.2502 Technology Services 5206.2503 5 Yr PC Upgrades 2823 Paid from Property Taxes 6175 Hardware Replacements Replacement of End User Computing Devices Total 5206.2503 5 Yr PC Upgrades Total 5206 Information Technology 115 Run Date: Feb 27, 2022 Funding Expense (150,000) 150,000 (150,000) 150,000 (50,000) 50,000 (50,000) 50,000 (200,000) 200,000 City of Pickering 2026 Capital Forecast 5206 Information Technology 5206.2601 Technology Infrastructure 2823 Paid from Property Taxes 6175 Hardware Replacements Upgrades to server, network and storage infrastructure due to City and staff growth. Total 5206.2601 Technology Infrastructure 5206.2602 5 Yr PC Upgrades 2823 Paid from Property Taxes 6175 Hardware Replacements Replacement of End User Computing Devices Total 5206.2602 5 Yr PC Upgrades 5206.2603 Internet Services Technologies 2823 Paid from Property Taxes 6177 IT Infrastructure Network switch and bandwidth capacity upgrades for City facilities. Total 5206.2603 Internet Services Technologies 5206.2604 Telecommunications Services Technologies 2823 Paid from Property Taxes 6177 IT Infrastructure Deployment of Cloud based Data and Voice Communications Systems with full integration into Microsoft 365 and on premises communications systems. Total 5206.2604 Telecommunications Services Technologies 5206.2605 Technology Infrastructure 2823 Paid from Property Taxes 6174 System & Software Upgrade Smart City Infrastructure Platform to enable new technologies and Internet of Things (JOT) initiatives. This would include a security aspect to protect JOT devices from cyber attack. Total 5206.2605 Technology Infrastructure Total 5206 Information Technology 116 Run Date: Feb 27, 2022 Funding Expense (128,000) 128,000 (128,000) 128,000 (98,000) 98,000 (98,000) 98,000 (110,000) 110,000 (110,000) 110,000 (298,000) 298,000 (298,000) 298,000 (200,000) 200,000 (200,000) 200,000 (834,000) 834,000 5219 Animal Services Expenditures 6173 Furniture & Fixtures Total Expenditures Financing 7021 R -Rate Stabilization Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 330,000 330 000 (330,000) (330,000) 117 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 5219 Animal Services 5219.2301 Animal Shelter -FF&E 6173 Furniture & Fixtures City of Pickering 2023 Capital Forecast Furniture, fixtures and equipment for new animal shelter building 7021 R -Rate Stabilization Total 5219.2301 Animal Shelter -FF&E Total 5219 Animal Services 118 Run Date: Feb 27, 2022 Funding Expense 330,000 (330,000) (330,000) 330,000 (330,000) 330,000 City of Pickering Multi-Year Capital Forecast 2023 -2026 Engineering Services Dept. Summary 2023 Forecast Expenditures 6183 Accessibility 6230 Prof/Consulting Fees 631,000 6250 Construction Costs 2,350,000 6251 Road Improvements 3,200,000 6252 Streetlights & Sidewalks 2,652,000 6253 Storm Water 1,469,000 6254 Traffic Signals 1,464,000 6255 Sidewalks 375,000 6256 Bridges & Culverts 64,500,000 Total Expenditures 76 641 000 Financing 1701 Debt -5 Year (722,000) 1702 Debt -10 Year (2,450,000) 1704 Debt 20 year 1705 Debt -25 Year (13,610,000) 1711 Internal Loan -5 Year (520,000) 1722 DC Debt -10 Year (Transportation) (581,000) 1725 DC Debt -25 Year (Transportation) (2,190,000) 2823 Paid from Property Taxes (60,000) 7022 R -DC's City's Share (1,358,124) 7501 RF -Third Party Contribution (24,800,000) 7505 RF -Federal Gas Tax (2,637,000) 7610 RF DC -Transportation Services (22,555,000) 7611 RF DC -Storm Water Mgmt (268,376) 7622 RF DC Parks & Recreation Services 7709 RF -Roads & Bridges (3,650,000) 7710 RF -Stormwater Mgmt (1,239,500) Total Financing {76,641,000) 119 Run Date: Mar 15, 2022 2024 2025 2026 Forecast Forecast Forecast 539,600 377,700 600,000 2,698,000 200,000 200,000 200,000 9,434,000 10,669,000 5,625,000 3,212,000 1,160,000 1,872,200 917,000 1,157,000 557,000 112,000 200,000 200,000 200,000 3,575,000 750,000 6,863,000 20 077.600 17 323.900 13,917 000 (361,000) (361,000) (4,180,000) (1,525,000) {539,500) (2,800,000) (160,000) (160,000) (2,817,000) (24,000) (24,000) (100,000) (3,012,800) (4,507,764) (1,733,135) (200,000) (200,000) (200,000) (2,462,000) (2,462,000) (2,462,000) (3,223,000) (2,616,000) (5,690,365) (472,286) (269,800) (188,850) (2,225,000) (1,225,000) (2,275,000) (1,160,000) (765,000) (917,000) (20,077,600) {17,323,900) {13,917,000) City of Pickering Multi-Year Capital Forecast 2023 -2026 5325 Streetlights & Signalization 2023 Forecast Expenditures 6230 Prof/Consulting Fees 100,000 6252 Streetlights & Sidewalks 200,000 6254 Traffic Signals 1,464,000 Total Expenditures 1764000 Financing 1701 Debt-5 Year (722,000) 1711 Internal Loan -5 Year (520,000) 2823 Paid from Property Taxes (60,000) 7022 R -DC's City's Share (45,000) 7505 RF -Federal Gas Tax (12,000) 761 0 RF DC -Transportation Services (405,000) Total Financing (1,764,000) 120 Run Date: Mar 15, 2022 2024 2025 2026 Forecast Forecast Forecast 1,157,000 557,000 112,000 1 157 000 557 000 112,000 (361,000) (361,000) (160,000) (160,000) (24,000) (24,000) (100,000) (60,000) (12,000) (12,000) (12,000) (540,000) (1,157,000) (557,000) (112,000) City of Pickering 2023 Capital Forecast 5325 Streetlights & Signalization 5325.2301 Traffic Signals/Controllers Replacement 2823 Paid from Property Taxes 6254 Traffic Signals Traffic Signals/Controllers Replacement-Altona Road @ Valley Gate (last replacement 2010) Total 5325.2301 Traffic Signals/Controllers Replacement 5325.2302 LED Signal Head Replacement Program 6254 Traffic Signals Replacement of LED signal heads 7505 RF -Federal Gas Tax Total 5325.2302 LED Signal Head Replacement Program 5325.2303 Accessible Pedestrian Signals -4 locations 1701 Debt-5 Year 6254 Traffic Signals Equipping existing traffic signals with accessible pedestrian signals. In accordance with AODA 2005. All signals must equipped by Jan 1,2025. Year 3 of 5 year program. Total 5325.2303 Accessible Pedestrian Signals -4 locations 5325.2304 Uninterruptible Power Supply -5 locations 1711 Internal Loan -5 Year 6254 Traffic Signals Installation of uninterruptible power supply battery backup system that operates signals in the event of a power outage. Year 3 of 5 year program. Total 5325.2304 Uninterruptible Power Supply -5 locations 5325.2305 Traffic Signals: Pickering Parkway at Glenanna 6254 Traffic Signals New traffic signals and intersection improvements -Pickering Parkway at Glenanna Road. (90/10) 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5325.2305 Traffic Signals: Pickering Parkway at Glenanna 5325.2306 Intersection Improvements: Rosebank at Sheppard Desi 6230 Prof/Consulting Fees 121 Run Date: Mar 14, 2022 Funding Expense (23,000) 23,000 (23,000) 23,000 12,000 (12,000) (12,000) 12,000 (361,000) 361,000 (361,000) 361,000 (160,000) 160,000 (160,000) 160,000 350,000 (35,000) (315,000) (350,000) 350,000 100,000 City of Pickering 2023 Capital Forecast 5325 Streetlights & Signalization Environmental Assessment and Design for Intersection Improvements Oog elimination and traffic signals) -Rosebank Road at Sheppard Avenue (90/10) 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5325:2306 Intersection Improvements: Rosebank at Sheppa1 5325.2307 Old Brock Road New Streetlights 1711 Internal Loan -5 Year 6252 Streetlights & Sidewalks Old Brock Road New Streetlights -from Howton Street to Uxbridge-Pickering Townline Total 5325.2307 Old Brock Road New Streetlights 5325.2308 Pedestrian Countdown Signals -5 locations 2823 Paid from Property Taxes 6254 Traffic Signals Retrofit existing traffic signals with pedestrian countdown signals for increased crossing safety. Year 3 of 3 year program. Total 5325.2308 Pedestrian Countdown Signals -5 locations 5325.2309 Accessible Pedestrian Signals -4 locations 1701 Debt -5 Year 6254 Traffic Signals Equipping existing traffic signals with accessible pedestrian signals. In accordance with AODA 2005. All signals must equipped by Jan 1,2025. Year 2 of 5 year program. Total 5325.2309 Accessible Pedestrian Signals -4 locations 5325.2310 Uninterruptible Power Supply -5 locations 1711 Internal Loan -5 Year 6254 Traffic Signals Installation of uninterruptible power supply battery backup system that operates signals in the event of a power outage. Year 2 of 5 year program. Total 5325.2310 Uninterruptible Power Supply -5 locations Total 5325 Streetlights & Signalization 122 Run Date: Mar 14, 2022 Funding Expense (10,000) (90,000) (100,000) 100,000 (200,000) 200,000 (200,000) 200,000 (37,000) 37,000 (37,000) 37,000 (361,000) 361,000 (361,000) 361,000 (160,000) 160,000 (160,000) 160,000 (1,764,000) 1,764,000 City of Pickering 2024 Capital Forecast 5325 Streetlights & Signalization 5325.2401 Accessible Pedestrian Signals -4 locations 1701 Debt -5 Year 6254 Traffic Signals Equipping existing traffic signals with accessible pedestrian signals. In accordance with AODA 2005. All signals must equipped by Jan 1,2025. Year 4 of 5 year program. Total 5325.2401 Accessible Pedestrian Signals -4 locations 5325.2402 Uninterruptible Power Supply -5 locations 1711 Internal Loan -5 Year 6254 Traffic Signals Installation of uninterruptible power supply battery backup system that operates signals in the event of a power outage. Year 4 of 5 year program. Total 5325.2402 Uninterruptible Power Supply -5 locations 5325.2403 Traffic Signals/Controllers Replacement 2823 Paid from Property Taxes 6254 Traffic Signals Traffic Signals/Controllers Replacement-Granite Court at Sandstone Manor (original install 2012) Total 5325.2403 Traffic Signals/Controllers Replacement 5325.2404 LED Signal Head Replacement Program 6254 Traffic Signals Replacement of LED signal heads 7505 RF -Federal Gas Tax Total 5325.2404 LED Signal Head Replacement Program 5325.2405 Intersection Improvements: Rosebank at-Sheppard 6254 Traffic Signals Intersection Improvements and signalization -Rosebank Road at Sheppard Avenue -Construction (90/10) 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5325.2405 Intersection Improvements: Rosebank at Sheppar Total 5325 Streetlights & Signalization 123 Run Date: Feb 27, 2022 Funding Expense (361,000) 361,000 (361,000) 361,000 (160,000) 160,000 (160,000) 160,000 (24,000) 24,000 (24,000) 24,000 12,000 (12,000) (12,000) 12,000 600,000 (60,000) (540,000) (600,000) 600,000 (1,157,000) 1,157,000 City of Pickering 2025 Capital Forecast 5325 Streetlights & Signalization 5325.2501 Accessible Pedestrian Signals -4 locations 1701 Debt-5 Year 6254 Traffic Signals Equipping existing traffic signals with accessible pedestrian signals. In accordance with AODA 2005. All signals must equipped by Jan 1,2025. Year 5 of 5 year program. total 5325.2501 Accessible Pedestrian Signals -4 locations 5325.2502 Uninterruptible Power Supply -5 locations 1711 Internal Loan -5 Year 6254 Traffic Signals Installation of uninterruptible power supply battery backup system that operates signals in the event of a power outage. Year 5 of 5 year program. Total 5325.2502 Uninterruptible Power Supply -5 locations 5325.2503 LED Signal Head Replacement Program 6254 Traffic Signals Replacement of LED signal heads 7505 RF -Federal Gas Tax Total 5325.2503 LED Signal Head Replacement Program 5325.2504 Traffic Signals/Controllers Replacement 2823 Paid from Property Taxes 6254 Traffic Signals Traffic Signals/Controllers Replacement-Finch Avenue at Spruce Hill Road (original install 2012) Total 5325.2504 Traffic Signals/Controllers Replacement Total 5325 Streetlights & Signalization 124 Run Date: Feb 27, 2022 Funding Expense (361,000) 361,000 (361,000) 361,000 (160,000) 160,000 (160,000) 160,000 12,000 (12,000) (12,000) 12,000 (24,000) 24,000 (24,000) 24,000 (557,000) 557,000 City of Pickering 2026 Capital Forecast 5325 Streetlights & Signalization 5325.2601 LED Signal Head Replacement Program 6254 Traffic Signals Replacement of LED signal heads 7505 RF -Federal Gas Tax Total 5325.2601 LED Signal Head Replacement Program 5325.2602 Traffic Signals/Controllers Replacement 2823 Paid from Property Taxes 6254 Traffic Signals Traffic Signals/Controllers Replacement-Liverpool Road @Tatra Drive (last replacement 2013) Total 5325.2602 Traffic Signals/Controllers Replacement 5325.2603 Traffic Sigmils/Controllers Replacement 2823 Paid from Property Taxes 6254 Traffic Signals Traffic Signals/Controllers Replacement-Fairport Road @ Strouds Lane (last replacement 2013) Total 5325.2603 Traffic Signals/Controllers Replacement 5325.2604 Traffic Signals/Controllers Replacement 2823 Paid from Property Taxes 6254 Traffic Signals Traffic Signals/Controllers Replacement-Pickering Parkway @ PTC/Picore Entrance (last replacement 2013) Total 5325.2604 Traffic Signals/Controllers Replacement 5325.2605 Traffic Signals/Controllers Replacement 2823 Paid from Property Taxes 6254 Traffic Signals Traffic Signals/Controllers Replacement-Finch Avenue @ Rosefield Road (last replacement 2013) Total 5325.2605 Traffic Signals/Controllers Replacement ~otal 5325 Streetlights & Signalization 125 Run Date: Feb 27, 2022 Funding Expense 12,000 (12,000) (12,000) 12,000 (25,000) 25,000 (25,000) 25,000 (25,000) 25,000 (25,000) 25,000 (25,000) 25,000 (25,000) 25,000 (25,000) 25,000 (25,000) 25,000 (112,000) 112,000 5323 Sidewalks Expenditures 6183 Accessibility 6255 Sidewalks Total Expenditures Financing 7022 R -DC's City's Share 7505 RF -Federal Gas Tax City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 375,000 375.000 (375,000) 7622 RF DC -Parks & Recreation Services Total Financing (375,000) 126 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 539,600 377,700 200,000 200,000 200,000 739,600 577 700 200 000 (269,800) (188,850) (200,000) (200,000) (200,000) (269,800) (188,850) (739,600) (577,700) (200,000) 5323 Sidewalks City of Pickering 2023 Capital Forecast 5323.2301 New Sidewalk Installation (Location TBD) 6255 Sidewalks New Sidewalk Installation (Location TBD) 7505 RF -Federal Gas Tax Total 5323.2301 New Sidewalk Installation (Location TBD) 5323.2302 Finch Avenue -Temp Asphalt Sidewalk 6255 Sidewalks New Temporary Asphalt Sidewalk -Finch Avenue, south side from Altona Road to Shadow Place 7505 RF -Federal Gas Tax Total 5323.2302 Finch Avenue -Temp Asphalt Sidewalk 5323.2303 Finch Avenue -New Sidewalk Construction 6255 Sidewalks New Sidewalk Finch Avenue -north side from Altona Road to approx. 50m east 7505 RF -Federal Gas Tax Total 5323.2303 Finch Avenue -New Sidewalk Construction Total 5323 Sidewalks 127 Run Date: Feb 27, 2022 Funding Expense 200,000 (200,000) (200,000) 200,000 100,000 (100,000) (100,000) 100,000 75,000 (75,000) (75,000) 75,000 (375,000) 375,000 5323 Sidewalks City of Pickering 2024 Capital Forecast 5323.2401 New Sidewalk Installation (Location TBD) 6255 Sidewalks New Sidewalk Installation (Location TBD) 7505 RF -Federal Gas Tax Total 5323.2401 New Sidewalk Installation (Location TBD) 5323.2402 Trail -Bayly Street -Waterfront Trail to Go Station 6183 Accessibility Trail -Bayly Street from Waterfront Trail to Go Station (50/50) 7022 R -DC's City's Share 7622 RF DC -Parks & Recreation Services Total 5323.2402 Trail -Bayly Street -Waterfront Trail to Go Station Total 5323 Sidewalks 128 Run Date: Feb 27, 2022 Funding Expense 200,000 (200,000) (200,000) 200,000 539,600 (269,800) (269,800) (539,600) 539,600 (739,600) 739,600 5323 Sidewalks City of Pickering 2025 Capital Forecast 5323.2501 New Sidewalk Installation (Location TBD) 6255 Sidewalks New Sidewalk Installation (Location TBD) 7505 RF -Federal Gas Tax Total 5323.2501 New Sidewalk Installation (Location TBD) 5323.2502 Trail -Bayly Street from Go Station to Hydro Corridor 6183 Accessibility Bayly Street from Go Station to Hydro Corridor (50/50) 7022 R -DC's City's Share 7622 RF DC -Parks & Recreation Services Total 5323.2502 Trail -Bayly Street from Go Station to Hydro Corri Total 5323 Sidewalks 129 Run Date: Feb 27, 2022 Funding Expense 200,000 (200,000) (200,000) 200,000 377,700 (188,850) (188,850) (377,700) 377,700 (577,700) 577,700 5323 Sidewalks City of Pickering 2026 Capital Forecast 5323.2601 New Sidewalk Installation (Location TBD) 6255 Sidewalks New Sidewalk Installation (Location TBD) 7505 RF -Federal Gas Tax Total 5323.2601 New Sidewalk Installation (Location TBD) Total 5323 Sidewalks 130 Run Date: Feb 27, 2022 Funding Expense 200,000 (200,000) (200,000) 200,000 (200,000) 200,000 5410 Stormwater Management Expenditures 6253 Storm Water· Total Expenditures Financing 7710 RF -Stormwater Mgmt Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 1,010,000 1 010.000 (1,010,000) (1,010,000) 131 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 1,160,000 765,000 917,000 1160 000 765 000 917,000 (1,160,000) (765,000) (917,000) (1,160,000) (765,000) (917,000) 5410 Stormwater Management City of Pickering 2023 Capital Forecast 5410.2301 Rouge SWM Pond (C1-01-ER) Cleanout 6253 Storm Water Rouge SWM Pond on Valley Ridge Crescent west of Pine Grove Avenue -SWM Pond Cleanout as per SWM Facility Asset Management Plan. 771 0 RF -Stormwater Mgmt Total 5410.2301 Rouge SWM Pond (C1-01-ER) Cleanout Total 5410 Stormwater Management 132 Run Date: Feb 27, 2022 Funding Expense 1,010,000 (1,010,000) (1,010,000) 1,010,000 (1,010,000) 1,010,000 5410 Stormwater Management City of Pickering 2024 Capital Forecast 5410.2401 Autumn SWM Pond (C1-03-PT) Cleanout 6253 Storm Water Autumn SWM Pond -on Autumn Crescent south of Strouds Lane - SWM Pond Cleanout as per SWM Facilities Asset Management Plan 771 0 RF -Stormwater Mgmt Total 5410.2401 Autumn SWM Pond (C1-03-PT) Cleanout 5410.2402 Begley Street SWM Pond (R3-02-AB) Cleanout 6253 Storm Water Begley Street SWM Pond -on Begley Street south of Bayly Street - SWM Pond. Cleanout as per SWM Facilities Asset Management Plan 7710 RF -Stormwater Mgmt Total 5410.2402 Begley Street SWM Pond (R3-02-AB) Cleanout Total 5410 Stormwater Management 133 Run Date: Feb 27, 2022 Funding Expense 780,000 (780,000) (780,000) 780,000 380,000 (380,000) (380,000) 380,000 (1,160,000) 1,160,000 5410 Stormwater Management City of Pickering 2025 Capital Forecast 5410.2501 Chickadee SWM Pond (C1-05-PT) Cleanout 6253 Storm Water Chickadee SWM Pond on Chickadee Court east of Altona Road - SWM Pond Cleanout as per SWM Facilities Asset Management Plan 7710 RF -Stormwater Mgmt Total 5410.2501 Chickadee SWM Pond (C1-05-PT) Cleanout 5410.2502 Dixie Estates 2 SWM Pond (C2-03-PC) Cleanout 6253 Storm Water Dixie Estates 2 SWM Pond -on Pine Glen Drive east of Dixie Road -SWM Pond Cleanout as per SWM Facilities Asset Management Plan 7710 RF -Stormwater Mgmt Total 5410.2502 Dixie Estates 2 SWM Pond (C2-03-PC) Cleanout Total 5410 Stormwater Management 134 Run Date: Feb 27, 2022 Funding Expense 360,000 (360,000) (360,000) 360,000 405,000 (405,000) (405,000) 405,000 (765,000) 765,000 5410 Stormwater Management City of Pickering 2026 Capital Forecast 5410.2601 Cognac SWM Pond (C2-01-DN) Cleanout 6253 Storm Water Cognac SWM Pond on Cognac Crescent, north of Finch Avenue west of Whites Rd -SWM Pond Cleanout as per SWM Facilities Asset Management Plan 771 0 RF -Stormwater Mgmt Total 5410.2601 Cognac SWM Pond (C2-01-DN) Cleanout 5410.2602 Valley Farm SWM Pond (C2-06-WD) Cleanout 6253 Storm Water Valley Farm SWM Pond -within Hydro Corridor, north of Finch Avenue and east of Valley Farm Road -SWM Pond Cleanout as per SWM Facilities Asset Management Plan 771 0 RF -Stormwater Mgmt Total 5410.2602 Valley Farm SWM Pond (C2-06-WD) Cleanout Total 5410 Stormwater Management 135 Run Date: Feb 27, 2022 Funding Expense 500,000 (500,000) (500,000) 500,000 417,000 (417,000) (417,000) 417,000 (917,000) 917,000 5320 Roads Projects Expenditures 6230 Prof/Consulting Fees 6250 Construction Costs 6251 Road Improvements 6256 Bridges & Culverts Total Expenditures Financing 1702 Debt -10 Year 1704 Debt -20 year 7022 R -DC's City's Share 7505 RF -Federal Gas Tax 7610 RF DC -Transportation Services 7709 RF -Roads & Bridges Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 450,000 2,150,000 3,200,000 3,000,000 8.800 000 (2,450,000) (45,000) (2,250,000) (405,000) (3,650,000) (8,800,000) 136 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 600,000 7,280,000 4,750,000 3,775,000 3,575,000 250,000 3,705,000 11455000 5 000.000 7.480 000 (4,180,000) (1,525,000) (2,800,000) (345,410) (2,250,000) (2,250,000) (2,250,000) (3,109,590) (2,225,000) (1,225,000) (1,775,000) (11,455,000) (5,000,000) (7,480,000) City of Pickering 2023 Capital Forecast 5320 Roads Projects 5320.2302 Wilson Bridge Replacement -Construction 6256 Bridges & Culverts Wilson Bridge (7002) Replacement Construction. 7709 RF -Roads & Bridges Total 5320.2302 Wilson Bridge Replacement -Construction 5320.2303 Old Brock Rd. -Road Reconstruction 1702 Debt-10 Year 6251 Road Improvements Old Brock Road -Hoxton Street to Uxbridge-Pickering Townline Total 5320.2303 Old Brock Rd. -Road Reconstruction 5320.2304 Seventh Concession Rd. -Road Reconstruction 6250 Construction Costs Sideline Road 32 to Sideline Road 26 -Road Reconstruction. Northern Roads Hard Surfacing Strategy. 7709 RF -Roads & Bridges Total 5320.2304 Seventh Concession Rd. -Road Reconstruction 5320.2305 Radom St. Culverts Replacement -Construction 1702 Debt-10 Year 6256 Bridges & Culverts Radom Street Culverts (7) Replacement Construction. Total 5320.2305 Radom St. Culverts Replacement -Construction 5320.2306 William Jackson Drive -Culvert Replacement Design 6230 Prof/Consulting Fees William Jackson Drive -Urfe Creek Culvert Structure Replacement - Design/approvals 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5320.2306 William Jackson Drive -Culvert Replacement De! 5320.2308 Chiron Crescent -Asphalt Resurfacing 6251 Road Improvements Chiron Crescent -Asphalt Resurfacing -Amberlea Rd to Amberlea Rd. 7505 RF -Federal Gas Tax Total 5320.2308 Chiron Crescent -Asphalt Resurfacing 5320.2309 Dellbrook Avenue -Asphalt Resurfacing 137 Run Date: Feb 27, 2022 Funding Expense 1,500,000 (1,500,000) (1,500,000) 1,500,000 (950,000) 950,000 (950,000) 950,000 2,150,000 (2,150,000) (2,150,000) 2,150,000 (1,500,000) 1,500,000 (1,500,000) 1,500,000 450,000 (45,000) (405,000) (450,000) 450,000 375,000 (375,000) (375,000) 375,000 City of Pickering 2023 Capital Forecast 5320 Roads Projects 6251 Road Improvements Dellbrook Avenue -Asphalt Resurfacing -Meriadoc Drive to Brock Road (RR#1) 7505 RF -Federal Gas Tax Total 5320.2309 Dellbrook Avenue -Asphalt Resurfacing 5320.2310 St. Martins Drive -Asphalt Resurfacing 6251 Road Improvements St. Martins Drive -Asphalt Resurfacing -Radom Street to Bayly Street (RR#22) 7505 RF -Federal Gas Tax Total 5320.2310 St. Martins Drive -Asphalt Resurfacing 5320.2311 Linwood Street -Asphalt Resurfacing 6251 Road Improvements Linwood Street -Asphalt Resurfacing -Liverpool Road to Bridle Path Crescent (west end) 7505 RF -Federal Gas Tax Total 5320.2311 Linwood Street -Asphalt Resurfacing 5320.2312 Eyer Drive -Asphalt Resurfacing 6251 Road Improvements Eyer Drive -Asphalt Resurfacing -70m south of Edge Lane to Hillcrest Road 7505 RF -Federal Gas Tax Total 5320.2312 Eyer Drive -Asphalt Resurfacing 5320.2313 Heathside Crescent -Asphalt Resurfacing 6251 Road Improvements Heathside Crescent -Asphalt Resurfacing -Longbow Drive (east end) to 320m south of Longbow Drive 7505 RF -Federal Gas Tax Total 5320.2313 Heathside Crescent -Asphalt Resurfacing 5320.2314 Waterford Gate -Asphalt Resurfacing 6251 Road Improvements Waterford Gate -Asphalt Resurfacing -Altona Road (RR #27) to 210m west of Altona Road (RR #27) 7505 RF -Federal Gas Tax Total 5320.2314 Waterford Gate -Asphalt Resurfacing 138 Run Date: Feb 27, 2022 Funding Expense 640,000 (640,000) (640,000) 640,000 170,000 (170,000) (170,000) 170,000 210,000 (210,000) (210,000) 210,000 305,000 (305,000} (305,000) 305,000 330,000 (330,000) (330,000) 330,000 220,000 (220,000) (220,000) 220,000 5320 Roads Projects Total 5320 Roads Projects City of Pickering 2023 Capital Forecast 139 Run Date: Feb 27, 2022 Funding Expense (8,800,000) 8,800,000 City of Pickering 2024 Capital Forecast 5320 Roads Projects 5320.2401 Liverpool Bridge Replacement -Construction 1704 Debt -20 year 6256 Bridges & Culverts Liverpool Bridge (3) Replacement -Construction Total 5320.2401 Liverpool Bridge Replacement-Construction 5320.2402 Greenwood Bridge -Rehabilitation Construction 1702 Debt -10 Year 6256 Bridges & Culverts Bridge Repairs -Greenwood Bridge Total 5320.2402 Greenwood Bridge -Rehabilitation Construction 5320.2403 Sixth Concession Rd. -Road Reconstruction 1702 Debt -10 Year 6251 Road Improvements Sixth Concession Road -reconstruction including storm sewer and outfall -from Greenwood Road to Highway 7 Total 5320.2403 Sixth Concession Rd. -Road Reconstruction 5320.2404 Dyson Rd. -Road Reconstruction 1702 Debt-10 Year 6251 Road Improvements Dyson Road -Rodd Avenue to Rougemount Drive Total 5320.2404 Dyson Rd. -Road Reconstruction 5320.2405 Sideline 24 -Road Reconstruction 6251 Road Improvements Sideline 24 -Highway 407 to Whitevale Road -Road Reconstruction. Northern Roads Hard Surfacing Strategy. 7709 RF -Roads & Bridges Total 5320.2405 Sideline 24 -Road Reconstruction 5320.2406 Sideline 14 -Road Reconstruction 1702 Debt -10 Year 6251 Road Improvements Sideline 14 -Hwy. 407 to Seventh Concession Road -Reconstruct granular base and hard surface. Northern Roads Hard Surfacing Strategy. Total 5320.2406 Sideline 14 -Road Reconstruction 5320.2407 Scarborough/Pickering Townline Rd.-Culvert ReplacemE 140 Run Date: Feb 27, 2022 Funding Expense (2,800,000) 2,800,000 (2,800,000) 2,800,000 (625,000) 625,000 (625,000) 625,000 (1,100,000) 1,100,000 (1,100,000) 1,100,000 (1,530,000) 1,530,000 (1,530,000) 1,530,000 975,000 (975,000) (975,000) 975,000 (925,000) 925,000 (925,000) 925,000 5320 Roads Projects 6230 Prof/Consulting Fees City of Pickering 2024 Capital Forecast Toronto/ Pickering Townline Culvert (2004) Replacement - Design/Approvals. 7709 RF -Roads & Bridges Total 5320.2407 Scarborough/Pickering Townline Rd.-Culvert Rep 5320.2408 Lot 2, Cone 7/8 Bridge Replacement-Design 6256 Bridges & Culverts Eighth Cone. Road (east of Sideline 2) (8003) Design - Replacement 7709 RF -Roads & Bridges Total 5320.2408 Lot 2, Cone 7/8 Bridge Replacement-Design 5320.2409 Joseph Street Road Reconstruction and Drainage Im pro 6251 Road Improvements Joseph Street from Franklin Street to Old Brock Road -road reconstruction and drainage improvements 7709 RF -Roads & Bridges Total 5320.2409 Joseph Street Road Reconstruction and Drainage 5320.2414 Asphalt Resurfacing Projects (TBD) 6251 Road Improvements Roads Resurfacing Projects (TBD) 7505 RF -Federal Gas Tax Total 5320.2414 Asphalt Resurfacing Projects (TBD) Total 5320 Roads Projects 141 Run Date: Feb 27, 2022 Funding Expense 600,000 (600,000) (600,000) 600,000 150,000 (150,000) (150,000) 150,000 500,000 (500,000) (500,000) 500,000 2,250,000 (2,250,000) (2,250,000) 2,250,000 (11,455,000) 11,455,000 5320 Roads Projects City of Pickering 2025 Capital Forecast 5320.2501 Seventh Concession Rd. (SL 26 to SL 22) Road ConstrU< 1702 Debt-10 Year 6251 Road Improvements Seventh Concession Road (SL 26 to SL 22). Northern Roads Hard Surfacing Strategy. Total 5320.2501 Seventh Concession Rd. (SL 26 to SL 22) Road Cc 5320.2502 Kinsale Rd. -Hard Surfacing 6251 Road Improvements Kinsale Road Paving -Hwy 407 to Seventh Concession Road upgrade to hard surface (1300m). Northern Roads Hard Surfacing Strategy. 7709 RF -Roads & Bridges Total 5320.2502 Kinsale Rd. -Hard Surfacing 5320.2503 Asphalt Resurfacing Projects (TBD) 6251 Road Improvements Resurfacing Projects {TBD) 7505 RF -Federal Gas Tax Total 5320.2503 Asphalt Resurfacing Projects (TBD) 5320.2504 Lehman #2 Bridge -Bridge Replacement -Design 6256 Bridges & Culverts Eighth Concession Road (8001) Replacement Construction - Design 7709 RF -Roads & Bridges Total 5320.2504 Lehman #2 Bridge -Bridge Replacement -Design 5320.2505 Pedestrian Bridge 9 -Bridge Replacement -Design 6256 Bridges & Culverts Pickering Museum Village (PB 09) Replacement Construction- Design 7709 RF -Roads & Bridges Total 5320.2505 Pedestrian Bridge 9 -Bridge Replacement -Desig Total 5320 Roads Projects 142 Run Date: Feb 27, 2022 Funding Expense (1,525,000) 1,525,000 (1,525,000) 1,525,000 975,000 (975,000) (975,000) 975,000 2,250,000 (2,250,000) (2,250,000) 2,250,000 150,000 (150,000) (150,000) 150,000 100,000 (100,000) (100,000) 100,000 (5,000,000) 5,000,000 5320 Roads Projects City of Pickering 2026 Capital Forecast 5320.2601 Seventh Concession Rd. (SL 22 to Brock Rd.) Road Corn 6251 Road Improvements Seventh Concession Road (SL 22 to Brock Road). Northern Roads Hard Surfacing Strategy. 7709 RF -Roads & Bridges Total 5320.2601 Seventh Concession Rd. (SL 22 to Brock Rd.) Ro~ 5320.2602 William Jackson Drive -Culvert Replacement -Construe 6256 Bridges & Culverts William Jackson Drive -Culvert Replacement -Construction 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5320.2602 William Jackson Drive -Culvert Replacement -Co 5320.2603 Lehman #2 Bridge -Bridge Replacement -Construction 6256 Bridges & Culverts Eighth Concession Road (8001) Replacement Construction 7709 RF -Roads & Bridges Total 5320.2603 Lehman #2 Bridge -Bridge Replacement -Constn 5320.2604 Pedestrian Bridge 9 -Bridge Replacement -Constructio1 6256 Bridges & Culverts 7709 RF -Roads & Bridges Total 5320.2604 Pedestrian Bridge 9 -Bridge Replacement-Cons1 5320.2605 Asphalt Resurfacing Projects (TBD) 6251 Road Improvements Resurfacing Projects (TBD) 7505 RF -Federal Gas Tax Total 5320.2605 Asphalt Resurfacing Projects (TBD) Total 5320 Roads Projects 143 Run Date: Feb 27, 2022 Funding Expense 1,525,000 (1,525,000) (1,525,000) 1,525,000 3,455,000 (345,410) (3,109,590) (3,455,000) 3,455,000 150,000 (150,000) (150,000) 150,000 100,000 (100,000) (100,000) 100,000 2,250,000 (2,250,000) (2,250,000) 2,250,000 (7,480,000) 7,480,000 City of Pickering Multi-Year Capital Forecast 2023 -2026 5613 Water Resources & Development Services 2023 Forecast Expenditures 6250 Construction Costs 200,000 Total Expenditures 200 000 Financing 7501 RF -Third Party Contribution (200,000) Total Financing (200,000) 144 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 200,000 200,000 200,000 200 000 200 000 200.000 (200,000) (200,000) (200,000) (200,000) (200,000) (200,000) City of Pickering 2023 Capital Forecast 5613 Water Resources & Development Services 5613.2303 Various Construction Projects 6250 Construction Costs Various Construction Projects Related to Development (funded from Third Party Contributions). 7501 RF -Third Party Contribution Total 5613.2303 Various Construction Projects Total 5613 Water Resources & Development Services 145 Run Date: Feb 27, 2022 Funding Expense 200,000 (200,000) (200,000) 200,000 (200,000) 200,000 City of Pickering 2024 Capital Forecast 5613 Water Resources & Development Services 5613.2402 Various Construction Projects 6250 Construction Costs Various Construction Projects Related to Development (funded from Third Party Contributions). 7501 RF -Third Party Contribution Total 5613.2402 Various Construction Projects Total 5613 Water Resources & Development Services 146 Run Date: Feb 27, 2022 Funding Expense 200,000 (200,000) (200,000) 200,000 (200,000) 200,000 City of Pickering 2025 Capital Forecast 5613 Water Resources & Development Services 5613.2501 Various Construction Projects 6250 Construction Costs Various Construction Projects Related to Development (funded from Third Party Contributions). 7501 RF -Third Party Contribution Total 5613.2501 Various Construction Projects Total 5613 Water Resources & Development Services 147 Run Date: Feb 27, 2022 Funding Expense 200,00.0 (200,000) (200,000) 200,000 (200,000) 200,000 City of Pickering 2026 Capital Forecast 5613 Water Resources & Development Services 5613.2601 Various Construction Projects 6250 Construction Costs Various Construction Projects Related to Development (funded from Third Party Contributions). 7501 RF -Third Party Contribution Total 5613.2601 Various Construction Projects Total 5613 Water Resources & Development Services 148 Run Date: Feb 27, 2022 Funding Expense 200,000 (200,000) (200,000) 200,000 (200,000) 200,000 City of Pickering Multi-Year Capital Forecast 2023 -2026 5321 Development Projects-(DC Funded) 2023 Forecast Expenditures 6230 Prof/Consulting Fees 81,000 6251 Road Improvements 6252 Streetlights & Sidewalks 2,452,000 6253 Storm Water 459,000 6256 Bridges & Culverts 61,500,000 Total Expenditures 64 492 000 Financing 1702 Debt-10Year 1705 Debt -25 Year (13,610,000) 1722 DC Debt -10 Year (Transportation) (581,000) 1725 DC Debt -25 Year (Transportation) (2, 190,000) 7022 R -DC's City's Share (1,268,124) 7501 RF -Third Party Contribution (24,600,000) 7610 RF DC -Transportation Services (21,745,000) 7611 RF DC -Storm Water Mgmt (268,376) 7709 RF -Roads & Bridges 7710 RF -Stormwater Mgmt (229,500) Total Financing (64,492,000) 149 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 2,698,000 2,154,000 5,919,000 1,850,000 3,212,000 1,107,200 500,000 3,158,000 5 366 000 10 224 200 5 008 000 (539,500) (2,817,000) (2,683,000) (4,318,914) (1,387,725) (;2,683,000) (2,616,000) (2,580,775) (472,286) (500,000) (5,366,000) (10,224,200) (5,008,000) City of Pickering 2023 Capital Forecast 5321 Development Projects-(DC Funded) 5321.2301 Bl-I Bayly St. -Sidewalks & Streetlights 1722 DC Debt -10 Year (Transportation) 6252 Streetlights & Sidewalks B1 -1 Sidewalks & Streetlights -Bayly Street (Church Street to Hydro Corridor -north and south sides) (50/50). 7022 R -DC's City's Share Total 5321.2301 Bl-I Bayly St. -Sidewalks & Streetlights 5321.2302 8-19 D Krosno Creek -SWM Facility -Design 6230 Prof/Consulting Fees B-19 (48/52) Krosno Creek SWM Facility K16 at Wharf St. (Design). 7022 R -DC's City's Share 7611 RF DC -Storm Water Mgmt Total 5321.2302 8-19 D Krosno Creek -SWM Facility -Design 5321.2303 DH-24 Brock Rd. -Sidewalks & Streetlights 6252 Streetlights & Sidewalks DH-24 Sidewalks & Streetlights -Brock Road( both sides Forbrock St to Taunton Rd.) 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5321.2303 DH-24 Brock Rd. -Sidewalks & Streetlights 5321.2304 8-30 D Krosno Creek -SWM Facility -Design 6253 Storm Water B-30 Krosno Creek SWM Facility K19 Hydro Corridor -(48/52) (feasibility, EA, Design, Land Cost & Approvals). 7611 RF DC -Storm Water Mgmt 7710 RF -Stormwater Mgmt Total 5321.2304 8-30 D Krosno Creek -SWM Facility -Design 5321.2305 Highway 401 Road Crossing Construction 1705 Debt -25 Year 1725 DC Debt -25 Year (Transportation) 6256 Bridges & Culverts 150 Run Date: Feb 27, 2022 Funding Expense (581,000) 1,162,000 (581,000) (1,162,000) 1,162,000 81,000 (42,124) (38,876) (81,000) 81,000 25,000 (12,500) (12,500) (25,000) 25,000 459,000 (229,500) (229,500) (459,000) 459,000 (13,610,000) (2,190,000) 61,500,000 City of Pickering 2023 Capital Forecast 5321 Development Projects-(DC Funded) Highway 401· Road Crossing -connecting Notion Road to Squires Beach Road, and re-alignment of Pickering Parkway at Notion Road -Construction (55/45). Includes utility·relocations and contract administration/inspection. 7501 RF -Third Party Contribution 7610 RF DC -Transportation Services Total 5321.2305 Highway 401 Road Crossing Construction 5321.2306 D-2 Kingston Rd Streetlighting/Sidewalks S. Side 6252 Streetlights & Sidewalks D-2 Kingston Road -South Side Steetlighting & Sidewalks (50/50). 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5321.2306 D-2 Kingston Rd Streetlighting/Sidewalks S. Side 5321.2307 D-1 Kingston Rd SteetlighUng/Sidewalks N. Side 6252 Streetlights.& Sidewalks D-1 Kingston Road -North Side Steetlighting & Sidewalks (50/50). 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5321.2307 D-1 Kingston Rd Steetlighting/Sidewalks N. Side Total 5321 Development Projects-(DC Funded) 151 Run Date: Feb 27, 2022 Funding Expense (24,600,000) (21,100,000) (61,500,000) 61,500,000 695,000 (347,500) (347,500) (695,000) 695,000 570,000 (285,000) (285,000) (570,000) 570,000 (64,492,000) 64,492,000 City of Pickering 2024 Capital Forecast 5321 Development Projects-(DC Funded) 5321.2401 RU-4 Audley Rd. -Road Reconstruction 6252 Streetlights & Sidewalks RU-4 Audley Road (50/50) Fifth Concession to Hwy. #7 -Two Lane Rural Reconstruction. 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5321.2401 RU-4 Audley Rd. -Road Reconstruction 5321.2402 R-4a Oakwood Drive -Road Reconstruction 6251 Road Improvements R-4a Oakwood Drive -2 lane urban reconstruction (Rougemount Drive to Mountain Ash Drive) (50/50) 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5321.2402 R-4a Oakwood Drive -Road Reconstruction 5321.2403 R-4b Oakwood Drive -Road Reconstruction 6251 Road Improvements R-4b Oakwood Drive -2 lane urban reconstruction & storm sewer install (Mountain Ash Drive to Toynevale Road) (50/50) 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5321.2403 R-4b Oakwood Drive -Road Reconstruction Total 5321 Development Projects-(DC Funded) 152 Run Date: Feb 27, 2022 Funding Expense 3,212,000 (1,606,000) (1,606,000) (3,212,000) 3,212,000 1,436,000 (718,000) (718,000) (1,436,000) 1,436,000 718,000 (359,000) (359,000) (718,000) 718,000 (5,366,000) 5,366,000 City of Pickering 2025 Capital Forecast 5321 Development Projects-(DC Funded) 5321.2501 Installation of Oil Grit Separators 6253 Storm Water Installation of Oil Grit Separators (25/75) Frenchman's Bay. 7022 R -DC's City's Share 7611 RF DC -Storm Water Mgmt Total 5321.2501 Installation of Oil Grit Separators 5321.2502 Arterial Road: Bayly to Kingston -Feasibility Study 6230 Prof/Consulting Fees TC-31 Future Arterial Road in Hydro Corridor, City Centre - Feasibility Study and Environmental Assessment (75/25). 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5321.2502 Arterial Road: Bayly to Kingston -Feasibility Stud 5321.2503 R-5 Rougemount Drive -Road Reconstruction 6251 Road Improvements R-5 Rougemount Drive -2 lane urban reconstruction & storm sewer install (Woodgrange Avenue to Toynevale Road) (50/50) 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5321.2503 R-5 Rougemount Drive -Road Reconstruction 5321.2504 8-19 C Krosno Creek -SWM Facility -Construction 6253 Storm Water B-19 Krosno Creek SWM Facility K16. Construction (48/52). 7022 R -DC's City's Share 7611 RF DC -Storm Water Mgmt Total 5321.2504 B-19 C Krosno Creek -SWM Facility -Constructic 5321.2505 DH-2 Valley Farm Rd. Bridge EA/Design 6256 Bridges & Culverts DH-2 Valley Farm Road Bridge EA/Design (90/10) 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5321.2505 DH-2 Valley Farm Rd. Bridge EA/Design 5321.2506 RU-7 Scarborough/Pickering Townline Road -Road Rec, 1722 DC Debt-10 Year (Transportation) 6251 Road Improvements 153 Run Date: Feb 27, 2022 Funding Expense 301,000 (215,690) (85,310) (301,000) 301,000 2,698,000 (674,500) (2,023,500) (2,698,000) 2,698,000 285,000 (142,500) (142,500) (285,000) 285,000 806,200 (419,224) (386,976) (806,200) 806,200 500,000 (50,000) (450,000) (500,000) 500,000 (2,817,000) 5,634,000 City of Pickering 2025 Capital Forecast 5321 Development Projects-(DC Funded) RU-7 Scarborough/Pickering Townline Road -Reconstruction & widening (CPR to Taunton Road/ Steeles Avenue)(S0/50) 7022 R -DC's City's Share Total 5321.2506 RU-7 Scarborough/Pickering Townline Road -Ro, Total 5321 Development Projects-(DC Funded) 154 Run Date: Feb 27, 2022 Funding Expense (2,817,000) (5,634,000) 5,634,000 (10,224,200) 10,224,200 City of Pickering 2026 Capital Forecast 5321 Development Projects-(DC Funded) 5321.2601 RP-2 Finch Ave. Culvert Replacement 6256 Bridges & Culverts RP-2 Finch Ave West of Altona Road Culvert Replacement (50/50). 7610 RF DC -Transportation Services 7709 RF -Roads & Bridges Total 5321.2601 RP-2 Finch Ave. Culvert Replacement 5321.2602 A-12, B-28 (Plummer) -Krosno Creek Crossing 1702 Debt -10 Year 6256 Bridges & Culverts A-12, B-28 (Plummer) -Krosno Creek Crossing 7610 RF DC -Transportation Services Total 5321.2602 A-12, 8-28 (Plummer) -Krosno Creek Crossing 5321.2603 RP-4 Finch Ave. -Road Reconstruction 6251. Road Improvements RP-4 Finch Avenue reconstruction, urbanization from Altona Road to Townline Road. (75/25) 7022 R -DC's City's Share 7610 RF DC -Transportation Services Total 5321.2603 RP-4 Finch Ave. -Road Reconstruction Total 5321 Development Projects-(DC Funded) 155 Run Date: Feb 27, 2022 Funding Expense 1,000,000 (500,000) (500,000) (1,000,000) 1,000,000 (539,500) 2,158,000 (1,618,500) (2,158,000) 2,158,000 1,850,000 (1,387,725) (462,275) (1,850,000) 1,850,000 (5,008,000) 5,008,000 Finance Dept. Summary Expenditures 6174 System & Software Upgrade Total Expenditures Financing 7021 R -Rate Stabilization 7601 RF DC -Growth Studies Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 475,000 475 000 (289,750) (185,250) (475,000) 156 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 600,000 600 000 (366,000) (234,000) (600,000) 5203 Finance and Taxation Expenditures 6174 System & Software Upgrade Total Expenditures Financing 7021 R -Rate Stabilization 7601 RF DC -Growth Studies Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 475,000 475 000 (289,750) (185,250) (475,000) 157 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 600,000 600 000 (366,000) (234,000) (600,000) 5203 Finance and Taxation 5203.2301 SAP Fleet Management 6174 System & Software Upgrade City of Pickering 2023 Capital Forecast Fleet Management: Development in SAP system to manage the City's fleet operations and to be able to report on overall total cost of ownership for all City vehicles. SAP to collect costs from work orders and consider the overhead, labour and spare parts fo arrive at the total vehicle ownership costs. SAP to also consider the depreciation and useful life of vehicles to obtain relevant KP ls to help determine the optimal time to replace vehicles. 7021 R -Rate Stabilization 7601 RF DC -Growth Studies Total 5203.2301 SAP Fleet Management Total 5203 Finance and Taxation 158 Run Date: Feb 27, 2022 Funding Expense 475,000 (289,750) (185,250) (475,000) 475,000 (475,000) 475,000 5203 Finance and Taxation 5203.2401 SAP Budget & Salary Module 6174 System & Software Upgrade City of Pickering 2024 Capital Forecast Integrate salaries and budget development module within existing core financial modules to provide an integrated information platform to facilitate business decision making. 7021 R -Rate Stabilization 7601 RF DC -Growth Studies Total 5203.2401 SAP Budget & Salary Module Total 5203 Finance and Taxation 159 Run Date: Feb 27, 2022 Funding Expense 600,000 (366,000) (234,000) (600,000) 600,000 (600,000) 600,000 Fire Services Dept. Summary Expenditures 6173 Furniture & Fixtures 6178 Machinery & Equipment 6183 Accessibility 6230 Prof/Consulting Fees 6430 Prof/Consult Fees -Seaton 6478 Miscellaneous Equipment -Seaton 6500 Building Related Total Expenditures Financing 1701 Debt-5 Year 1704. Debt -20 year City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 500,000 50,000 64,000 84,000 6,334,000 7 032 000 (500,000) (5,867,000) 1709 DC Debt-20 Year (Protective Services) 1711 Internal Loan -5 Year (397,000) 1718 DC Internal Loan -5 Year (Protective Services) (84,000) 2823 Paid from Property Taxes (184,000) 7505 RF -Federal Gas Tax 7713 RF -Seaton Land Grp FIA Total Financing (7,032,000) 160 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 206,000 250,000 10,000 86,000 40,000 490,000 84,000 84,000 312,000 146,000 502,000 852,000 806 000 552.000 (477,750) (616,000) (377,000) (84,000) (84,000) (152,000) (197,000) (175,000) (35,000) (12,250) (852,000) (806,000) (552,000) 5340 Fire Services Expenditures 6173 Furniture & Fixtures 6178 Machinery & Equipment 6183 Accessibility 6230 Prof/Consulting Fees 6430 Prof/Consult Fees -Seaton 6478 Miscellaneous Equipment -Seaton 6500 Building Related Total Expenditures Financing 1701 Debt -5 Year 1704 Debt -20 year City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 500,000 50,000 64,000 84,000 6,334,000 7 032 000 (500,000) (5,867,000) 1709 DC Debt-20 Year (Protective Services) 1711 Internal Loan -5 Year (397,000) 1718 DC Internal Loan -5 Year (Protective Services) (84,000) 2823 Paid from Property Taxes (184,000) 7505 RF -Federal Gas Tax 7713 RF -Seaton Land Grp FIA Total Financing (7,032,000) 161 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 206,000 250,000 10,000 86,000 40,000 490,000 84,000 84,000 312,000 146,000 502,000 852 000 806 000 552 000 (477,750) (616,000) (377,000) (84,000) (84,000) (152,000) (197,000) (175,000) (35,000) (12,250) (852,000) (806,000) (552,000) 5340 Fire Services City of Pickering 2023 Capital Forecast 5340.2301 FS #2 Partial Roof Replacement -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees Lifecycle replacement of lower flat roof over living quarters at Fire Station #2. Includes provision of rooftop access ladder and platform through upper part of hose tower. Total 5340.2301 FS #2 Partial Roof Replacement -Design 5340.2302 FS #2 Apparatus Bay Heaters 2823 Paid from Property Taxes 6500 Building Related FS #2 Apparatus Bay Heaters Total 5340.2302 FS #2 Apparatus Bay Heaters 5340.2303 Portable Radio Replacement 1701 Debt -5 Year 6178 Machinery & Equipment Lifecycle replacement of portable radios. Replacement includes portable radios, batteries, lapel mies, vehicle chargers, desktop chargers. Total 5340.2303 Portable Radio Replacement 5340.2304 FS #3 New Fire Station & (Seaton) Bunker Gear and Bre, 1718 DC Internal Loan -5 Year (Protective Services) 6478 Miscellaneous Equipment -Seaton Equipment for 4 firefighters including bunker gear and breathing apparatus equipment for FS #3 New Fire Station (Seaton North). Total 5340.2304 FS #3 New Fire Station & (Seaton) Bunker Gear ar 5340.2305 FS #6 Water Heater Replacement 2823 Paid from Property Taxes 6500 Building Related Lifecycle replacement of existing equipment installed in 2002. Total 5340.2305 FS #6 Water Heater Replacement 5340.2306 FS #2 Parking Lot Resurfacing -Construction 1711 Internal Loan -5 Year 6500 Building Related Lifecycle replacement of existing driveway and parking areas 162 Run Date: Feb 27, 2022 Funding Expense (26,000) 26,000 (26,000) 26,000 (50,000) 50,000 (50,000) 50,000 (500,000) 500,000 (500,000) 500,000 (84,000) 84,000 (84,000) 84,000 (30,000) 30,000 (30,000) 30,000 (212,000) 212,000 5340 Fire Services City of Pickering 2023 Capital Forecast Total 5340.2306 FS #2 Parking Lot Resurfacing -Construction 5340.2308 FS #5 Replacement -Demolition & New Construction 1704 Debt -20 year 6183 Accessibility 6500 Building Related Construction costs for the replacement of Fire Station #5. Includes demolition of existing structure. Fire Station #5 was originally constructed in 1964 and is at end of its serviceable life. Total 5340.2308 FS #5 Replacement -Demolition & New Construct 5340.2309 FS #6 Generator Replacement -Construction 1711 Internal Loan -5 Year 6500 Building Related Lifecycle replacement of existing generator. Original unit installed in 1993. Total 5340.2309 FS #6 Generator Replacement -Construction 5340.2310 FS #6 Kitchen & Living Quarters Retrofit -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees Design consulting services and related investigation costs to prepare for retrofit of the existing kitchen and living quarters at Fire Station #6, originally constructed in 1994. Total 5340.2310 FS #6 Kitchen & Living Quarters Retrofit -Design 5340.2313 FS #2 Exterior Security Camera System 2823 Paid from Property Taxes 6500 Building Related New camera systems to allow for video monitoring of building exterior parking. Total 5340.2313 FS #2 Exterior Security Carner~ System 5340.2314 FS #6 Exterior Security Camera System 2823 Paid from Property Taxes 6500 Building Related New camera systems to allow for video monitoring of building exterior parking. Total 5340.2314 FS #6 Exterior Security Camera System Total 5340 Fire Services 163 Run Date: Feb 27, 2022 Funding Expense (212,000) 212,000 (5,867,000) 50,000 5,817,000 (5,867,000) 5,867,000 (185,000) 185,000 (185,000) 185,000 (38,000) 38,000 (38,000) 38,000 (20,000) 20,000 (20,000) 20,000 (20,000) 20,000 (20,000) 20,000 (7,032,000) 7,032,000 City of Pickering 2024 Capital Forecast 5340 Fire Services 5340.2401 FS #2 Partial Roof Replacement-Construction 2823 Paid from Property Taxes 6500 Building Related Lifecycle replacement of the existing lower roof at Fire Station #2, originally installed in 2002. Total 5340.2401 FS #2 Partial Roof Replacement-Construction 5340.2402 FS #6 Fencing & Patio Replacement 2823 Paid from Property Taxes 6500 Building Related Lifecycle replacement of the existing enclosure and patio at Fire Station #6. Total 5340.2402 FS #6 Fencing & Patio Replacement 5340.2403 FS #5 Replacement -FF&E 1711 Internal Loan -5 Year 6173 Furniture & Fixtures Furniture, fixtures and equipment for the replacement of Fire Station #5. FF&E items which cannot be capitalized will be included in the operating budget(s) corresponding with the timing of construction and occupancy. Total 5340.2403 FS #5 Replacement -FF&E 5340.2407 FS #3 New Fire Station & (Seaton) Bunker Gear and Bree 1718 DC Internal Loan -5 Year (Protective Services) 6478 Miscellaneous Equipment -Seaton Equipment for 4 firefighters including bunker gear and breathing apparatus equipment for FS #3 New Fire Station (Seaton North). Total 5340.2407 FS #3 New Fire Station & (Seaton) Bunker Gear ar 5340.2409 FS #6 Kitchen & Living Quarters Retrofit -Construction 1711 Internal Loan -5 Year 6500 Building Related Construction costs for interior retrofit of the existing kitchen, living quarters and related adjunct spaces at Fire Station #6. These spaces were originally constructed in 1994. Total 5340.2409 FS #6 Kitchen & Living Quarters Retrofit -Constr 5340.2410 FS #6 Apparatus Bay Heaters 2823 Paid from Property Taxes 6500 Building Related 164 Run Date: Feb 27, 2022 Funding Expense (85,000) 85,000 (85,000) 85,000 (15,000) 15,000 (15,000) 15,000 (206,000) 206,000 (206,000) 206,000 (84,000) 84,000 (84,000) 84,000 (160,000) 160,000 (160,000) 160,000 (52,000) 52,000 5340 Fire Services FS #6 Apparatus Bay Heaters City of Pickering 2024 Capital Forecast Total 5340.2410 FS #6 Apparatus Bay Heaters 5340.2411 Dispatch CAD Replacement 1711 Internal Loan -5 Year 6178 Machinery & Equipment Dispatch CAD Replacement Total 5340.2411 Dispatch CAD Replacement Total 5340 Fire Services 165 Run Date: Feb 27, 2022 Funding Expense (52,000) 52,000 (250,000) 250,000 (250,000) 250,000 (852,000) 852,000 City of Pickering 2025 Capital Forecast 5340 Fire Services 5340.2501 FS #4 Generator Replacement -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees Investigation, assessment and design fees for the replacement of the existing generator at fire station #4. The existing unit was installed in 1997. Total 5340.2501 FS #4 Generator Replacement-Design 5340.2502 FS #2 (1 unit) & FS #3 (2 units) -Air Conditioners Replac 6500 Building Related Lifecycle replacement of existing air conditioners. Existing units installed in 2009. 7505 RF -Federal Gas Tax Total 5340.2502 FS #2 (1 unit) & FS #3 (2 units) -Air Conditioners I 5340.2503 FS #3 New Fire Station (Seaton) Bunker Gear and Breat~ 1718 DC Internal Loan -5 Year (Protective Services) 6478 Miscellaneous Equipment -Seaton Equipment for 4 firefighters including bunker gear and breathing apparatus equipment for FS #3 New Fire Station (Seaton North). Total 5340.2503 FS #3 New Fire Station (Seaton) Bunker Gear and 5340.2504 Seaton North FS #3 -Design 1709 DC Debt-20 Year (Protective Services) 6430 Prof/Consult Fees -Seaton Design consulting services for new fire station in north Seaton lands. Includes testing and inspection costs, and investigations on new site. 7713 RF -Seaton Land Grp FIA Total 5340.2504 Seaton North FS #3 -Design 5340.2505 FS #6 Exterior Openings Sealant Replacement 2823 Paid from Property Taxes 6500 Building Related Lifecycle replacement of existing sealants and related materials. Total 5340.2505 FS #6 Exterior Openings Sealant Replacement 5340.2506 FS#4 Interior Retrofit -Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees 166 Run Date: Feb 27, 2022 Funding Expense (50,000) 50,000 (50,000) 50,000 35,000 (35,000) (35,000) 35,000 (84,000) 84,000 (84,000) 84,000 (477,750) 490,000 (12,250) (490,000) 490,000 (23,000) 23,000 (23,000) 23,000 (36,000) 36,000 5340 Fire Services City of Pickering 2025 Capital Forecast Design costs to prepare for retrofit of the existing interior quarters on the north side of the apparatus bay, originally designed as the City's Emergency Control Centre, including replacing existing finishes, furniture, fixtures and equipment. Total 5340.2506 FS#4 Interior Retrofit -Design 5340.2507 FS #4 Apparatus Bay Painting 2823 Paid from Property Taxes 6500 Building Related Lifecycle replacement of existing paint on walls and mechanical ductwork in the apparatus bay. Total 5340.2507 FS #4 Apparatus Bay Painting Total 5340 Fire Services 167 Run Date: Feb 27, 2022 Funding Expense (36,000) 36,000 (88,000) 88,000 (88,000) 88,000 (806,000) 806,000 City of Pickering 2026 Capital Forecast 5340 Fire Services 5340.2601 FS #6 Window Replacement 2823 Paid from Property Taxes 6500 Building Related Renovation -Lifecycle replacement of windows at Fire Station #6 Total 5340.2601 FS #6 Window Replacement 5340.2602 FS #4 Interior Retrofit -Construction 1711 Internal Loan -5 Year 6183 Accessibility 6500 Building Related Lifecycle retrofit to existing kitchen and living quarters. The existing accommodations were only intended for volunteer use, whereas the station now has a permanent complement. Total 5340.2602 FS #4 Interior Retrofit -Construction 5340.2603 FS #4 Generator Replacement -Construction 1711 Internal Loan -5 Year 6500 Building Related Lifecycle replacement of existing generator. Original unit installed in 1997. Total 5340.2603 FS #4 Generator Replacement -Construction 5340.2604 FS #4 Driveway Replacement -Investigation & Design 2823 Paid from Property Taxes 6230 Prof/Consulting Fees FS #4 Driveway Replacement -Investigation & Design Total 5340.2604 FS #4 Driveway Replacement-Investigation & De: 5340.2605 FS #4 Carbon Monoxide System Replacement 2823 Paid from Property Taxes 6500 Building Related FS #4 Carbon Monoxide System Replacement Total 5340.2605 FS #4 Carbon Monoxide System Replacement Total 5340 Fire Services 168 Run Date: Feb 27, 2022 Funding Expense (115,000) 115,000 (115,000) 115,000 (192,000) 10,000 182,000 (192,000) 192,000 (185,000) 185,000 (185,000) 185,000 (40,000) 40,000 (40,000) 40,000 (20,000) 20,000 (20,000) 20,000 (552,000) 552,000 Library Summary Expenditures 6173 Furniture & Fixtures 6175 Hardware Replacements 6179 Book Collection Material 6183 Accessibility 6430 Prof/Consult Fees -Seaton 6450 Construction Costs -Seaton 6483 Accessibility -Seaton 6500 Building Related Total Expenditures Financing 1704 Debt -20 year 1711 Internal Loan -5 Year 1732 DC Debt -20 Year (Library) 2823 Paid from Property Taxes 7505 RF -Federal Gas Tax 7630 RF DC -Library 7713 RF -Seaton Land Grp FIA Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 280,000 122,000 290,000 20,000 712,000 (300,000) (412,000) (712,000) 169 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 37,000 57,000 37,000 290,000 290,000 2,240,000 5,000,000 17,490,000 200,000 868,000 130,000 6 195 000 477,000 19 967 000 (3,706,800) (13,377,810) (130,000) (800,000) (4,312,190) (327,000) (347,000) (327,000) (868,000) (493,200) (504,365) (1,445,635) (6,195,000) (477,000) (19,967,000) 5800 Library Expenditures 6173 Furniture & Fixtures 6175 Hardware Replacements 6179 Book Collection Material 6183 Accessibility 6500 Building Related Total Expenditures Financing 1711 Internal Loan -5 Year 2823 Paid from Property Taxes 7505 RF -Federal Gas Tax Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 280,000 122,000 290,000 20,000 712 000 (300,000) (412,000) (712,000) 170 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 37,000 57,000 37,000 290,000 290,000 290,000 868,000 130,000 1 195 000 477 000 327 000 (130,000) (327,000) (347,000) (327,000) (868,000) (1,195,000) (477,000) (327,000) City of Pickering 2023 Capital Forecast 5800 Library 5800.2301 Collection Materials 2823 Paid from Property Taxes 6179 Book Collection Material Collection Materials include: Books, movies, music and other types of physical materials along with their processing and packaging. Current collection includes over 140,000 items -6.5% of collection replaced with new material each year. Assumes the addition of approx. 9,100 items at $32 each. Total 5800.2301 Collection Materials 5800.2302 PCL Computers Replacement 2823 Paid from Property Taxes 6175 Hardware Replacements Replacement of public and staff computers at the Pickering Central Library that are older than 5 years with new equipment. Total 5800.2302 PCL Computers Replacement 5800.2303 Upgrade Library Servers 2823 Paid from Property Taxes 6175 Hardware Replacements The Library currently has 5 servers. One to be replaced this year. Total 5800.2303 Upgrade Library Servers 5800.2305 Improvements to GAL Public Service space Phase 1 & 2 1711 Internal Loan -5 Year 6173 Furniture & Fixtures Update of George Ashe Library public service space and furnishings to improve client experience -Phase 1 ($125,000) and Phase 2 ($175,000) 6183 Accessibility Total 5800.2305 Improvements to GAL Public Service space Phast 5800.2306 Laptop Charging and Loaning 2823 Paid from Property Taxes 6175 Hardware Replacements Laptop loaning and charging lockers to allow self serve loaning of laptops to the public at the Central Library Total 5800.2306 Laptop Charging and Loaning Total 5800 Library 171 Run Date: Feb 27, 2022 Funding Expense (290,000) 290,000 (290,000) 290,000 (40,000) 40,000 (40,000) 40,000 (17,000) 17,000 (17,000) 17,000 (300,000) 280,000 20,000 (300,000) 300,000 (65,000) 65,000 (65,000) 65,000 (712,000) 712,000 City of Pickering 2024 Capital Forecast 5800 Library 5800.2401 Collection Materials 2823 Paid from Property Taxes 6179 Book Collection Material Collection Materials include: Books, movies, music and other types of physical materials along with their processing and packaging. Current collection includes over 140,000 items -6.5% of collection replaced with new material each year. Assumes the addition of approx. 9,100 items at $32 each. Total 5800.2401 Collection Materials 5800.2402 GAL Computer Replacement 2823 Paid from Property Taxes 6175 Hardware Replacements Replacement of public and staff computers at George Ashe Library that are older than 5 years with new equipment. Total 5800.2402 GAL Computer Replacement 5800.2403 Upgrade Library Server 2823 Paid from Property Taxes 6175 Hardware Replacements The Library currently has 5 servers. One to be replaced this year. Total 5800.2403 Upgraqe Library Server 5800.2404 Skylight Repairs & Replacements 6500 Building Related Lifecycle repairs and replacement of existing skylights originally installed in 1990. 7505 RF -Federal Gas Tax Total 5800.2404 Skylight Repairs & Replacements 5800.2405 Exterior Window Replacements 6500 Building Related Lifecycle replacement of existing exterior windows, installed in 1990. 7505 RF -Federal Gas Tax Total 5800.2405 Exterior Window Replacements 5800.2406 HVAC Upgrades and Replacements 6500 Building Related Lifecycle repair and replacement of existing heating and ventilation equipment at end of life. 172 Run Date: Feb 27, 2022 Funding Expense (290,000) 290,000 (290,000) 290,000 (20,000) 20,000 (20,000) 20,000 (17,000) 17,000 (17,000) 17,000 350,000 (350,000) (350,000) 350,000 500,000 (500,000) (500,000) 500,000 18,000 5800 Library 7505 RF -Federal Gas Tax City of Pickering 2024 Capital Forecast Total 5800.2406 HVAC Upgrades and Replacements Total 5800 Library 173 Run Date: Feb 27, 2022 Funding Expense (18,000) (18,000) 18,000 (1,195,000) 1,195,000 5800 Library 5800.2501 Collection Materials 2823 Paid from Property Taxes 6179 Book Collection Material City of Pickering 2025 Capital Forecast Collection Materials include: Books, movies, music and other types of physical materials along with their processing and packaging. Total 5800.2501 Collection Materials 5800.2502 PCL Computers Replacement 2823 Paid from Property Taxes 6175 Hardware Replacements Replacement of public and staff computers at the Pickering Central Library that are at least 5 years old. Total 5800.2502 PCL Computers Replacement 5800.2503 Upgrade Library Server 2823 Paid from Property Taxes 6175 Hardware Replacements The Library currently has 5 servers. One to be replaced this year. Total 5800.2503 Upgrade Library Server 5800.2504 Building Automation Upgrades 1711 Internal Loan -5 Year 6500 Building Related Lifecycle upgrades to building automation controls and equipment. Total 5800.2504 Building Automation Upgrades Total 5800 Library 174 Run Date: Feb 27, 2022 Funding Expense (290,000) 290,000 (290,000) 290,000 (40,000) 40,000 (40;000) 40,000 (17,000) 17,000 (17,000) 17,000 (130,000) 130,000 (130,000) 130,000 (477,000) 477,000 5800 Library 5800.2601 Collection Materials 2823 Paid from Property Taxes 6179 Book Collection Material City of Pickering 2026 Capital Forecast Collection Materials include: Books, movies, music and other types of physical materials along with their processing and packaging. Total 5800.2601 Collection Materials 5800.2602 GAL Computers Replacement 2823 Paid from Property Taxes 6175 Hardware Replacements Replacement of public and staff computers at the George Ashe Library that are at least 5 years old. Total 5800.2602 GAL Computers Replacement 5800.2603 Library Server Upgrade 2823 Paid from Property Taxes 6175 Hardware Replacements The Library currently has 5 servers. One to be replaced this year. Total 5800.2603 Library Server Upgrade Total 5800 Library 175 Run Date: Feb 27, 2022 Funding Expense (290,000) 290,000 (290,000) 290,000 (20,000) 20,000 (20,000) 20,000 (17,000) 17,000 (17,000) 17,000 (327,000) 327,000 5801 Seaton Regional Library Expenditures 6179 Book Collection Material 6430 Prof/Consult Fees -Seaton 6450 Construction Costs -Seaton 6483 Accessibility -Seaton Total Expenditures Financing 1704 Debt -20 year 1732 DC Debt-20 Year (Library) 7630 RF DC -Library 7713 RF -Seaton Land Grp FIA Total Financing City of Pickering Multi-Year Capital Forecast 2023 -2026 2023 Forecast 176 Run Date: Feb 27, 2022 2024 2025 2026 Forecast Forecast Forecast 1,950,000 5,000,000 17,490,000 200,000 5 000.000 19,640 000 (3,706,800) (13,377,810) (800,000) (4,312,190) (493,200) (504,365) (1,445,635) (5,000,000) (19,640,000) 5801 Seaton Regional Library City of Pickering 2024 Capital Forecast 5801.2402 Seaton Regional Library -Design 1704 Debt -20 year 1732 DC Debt-20 Year (Library) 6430 Prof/Consult Fees -Seaton Seaton Community Library -Design 7630 RF DC -Library Total 5801.2402 Seaton Regional Library -Design Total 5801 Seaton Regional Library 177 Run Date: Feb 27, 2022 Funding Expense (3,706,800) (800,000) 5,000,000 (493,200) (5,000,000) 5,000,000 (5,000,000) 5,000,000 5801 Seaton Regional Library City of Pickering 2026 Capital Forecast 5801.2601 Seaton Regional Library -Construction 1704 Debt -20 year 1732 DC Debt -20 Year (Library) 6450 Construction Costs -Seaton Seaton Community Library -Construction 6483 Accessibility -Seaton Total 5801.2601 Seaton Regional Library -Construction 5801.2602 Seaton Regional Library Collection 6179 Book Collection Material Collection Materials. Library materials include: Books, movies, music and other types of materials along with their processing and packaging. New collection Year 1 of 2 7630 RF DC -Library 7713 RF -Seaton Land Grp FIA Total 5801.2602 Seaton Regional Library Collection Total 5801 Seaton Regional Library 178 Run Date: Feb 27, 2022 Funding Expense (13,377,810) (4,312, 190) 17,490,000 200,000 (17,690,000) 17,690,000 1,950,000 (504,365) (1,445,635) (1,950,000) 1,950,000 (19,640,000) 19,640,000