Loading...
HomeMy WebLinkAbout2022 Approved Capital BudgetCity of Pickering 2022 Approved Capital Budget Table of Contents Department Budget Summaries Mayor & Council Office of the Chief Administrative Officer Corporate Projects 10325 Community Services Civic Complex 10240 Dunbarton Pool 10210 Don Beer Arena 10215 Community Centres 10220 Seaton Community Centre 10220 Recreation Complex-Central Core 10225 Recreation Complex-Pool 10230 Recreation Complex-Arenas 10235 Museum 10250 Operations Property Maintenance 10305 Roads Equipment 10315 Parks 10320 Fleet Services 10310 Corporate Services Information Technology 10405 By-Law 10425 Animal Services 10430 Engineering Services Streetlights & Signalization 10520 Sidewalks 10515 Stormwater Management 10525 Roads Projects 10570 Water Resources & Development Services 10510 Development Projects -(DC Funded) 10575 Finance Finance 10600 Fire Services Fire Protection 10700 Page 1 10 17 20 22 24 26 27 29 30 34 36 38 40 42 44 46 70 77 78 81 83 85 86 89 93 97 116 118 129 130 131 132 City of Pickering 2022 Approved Capital Budget Table of Contents Human Resources Human Resources Libraries Library Seton Regional Library General Government 10800 10900 10900 135 136 137 138 141 Common Budget Terms Assessment Growth The additional taxation revenue the City receives from new homes and businesses that are built each year. This revenue is used to cover the cost of providing services to the new residents/businesses and for long term financial planning. Budget Levy Sometimes referred to as the "Tax Levy", the budget levy is the total of all expenditures funded by property taxes. Capital Budget One time expenditures for major projects (often referred to as "infrastructure") such as roads, vehicles/equipment, parks, sidewalks, trails, streetlights, storm sewers, playgrounds and buildings. It includes both the development of new, and the maintenance/rehabilitation of existing infrastructure. Current Budget The expenditures (e.g., wages/benefits, supplies, contracted services, utilities, etc.) required to deliver the day to day City services. It also includes the revenues that the City receives (e.g., user fees, interest income, building permit fees, etc.). Debt A type of long term loan used as partial financing for major capital projects. The debt, including interest, is repayable over 5 to 25 years. Debenture debt spreads the project cost and related tax rate increase over a number of years and ensures that future taxpayers pay their fair share of capital projects being completed today. Development Charges A charge paid by developers to partially pay for the cost of new capital projects required as a result of growth (e.g., new roads, parks, trails, community centres, fire stations, etc.). Development charges do not cover the entire cost of a capital project, as legislation requires municipalities to fund a portion of most projects. In addition, certain expenditures are exempt from development charges and must be paid entirely by the municipality. Common Budget Terms Reserves/Reserve Funds Dollars set aside for specific purposes, both current and capital budget items. There are two main types of reserves/reserve funds: Statutory/Obligatory -municipalities are required by legislation to establish certain reserve funds (e.g., Development Charges, Parkland) Discretionary -can be established by Council for specific purpose (e.g., Vehicle Replacement, Rate Stabilization) City of Pickering 2022 Approved Capital Budget Reconciliation Draft Capital Budget as Submitted to Executive Committee -March 17, 2022 March 28, 2022 Budget Report to Council Changes Add: C10305.2109 Additional Funding for BHM -Park Walkway Reconstruction Revised 2022 Approved Capital Budget 1 $46,584,454 50,000 $46,634,454 City of Pickering 2022 Approved Capital Budget Overview 2022 Project Classification Approved Budget Infrastructure Renewal $18,348,064 Growth 28,286,390 Total $46,634,454 2022 Financing Summary Approved Budget Capital Paid from Property Taxes $639,000 Donations 27,500 Federal Grants 660,500 Provincial Grants 658,895 External Debt 1,571,000 Development Charges -Debt 6,004,000 Rate Stabilization Reserve 3,888,322 Discretionary Reserve & Reserve Funds 13,497,362 Third Party Contribution -Reserve Fund 397,500 Parkland -Reserve Fund 1,907,942 Federal Gas Tax -Reserve Fund 4,460,995 Development Charges -Reserve Fund 12,815,328 Road & Bridges -Reserve Fund 106,110 Total $46,634,454 2 City of Pickering Infrastructure Renewal 2022 Approved Capital Budget Overview 2022 Infrastructure Renewal by Program Approved Budget 10240 Civic Complex $1,325,000 10210 Dunbarton Pool 170,000 10220 Community Centres 252,000 10225 Rec. Complex-Core 776,000 10230 Rec. Complex-Pool 77,000 10235 Rec. Complex-Arenas 320,000 10250 Museum 939,000 10305 Property Maintenance 580,000 10315 Roads Equipment 120,000 10320 Parks 3,689,764 10310 Fleet Vehicles 2,147,000 10405 Information Technology 531,000 10520 Streetlights & Signalization 58,000 10515 Sidewalks 500,000 10510 Stormwater Management 1,170,000 10570 Roads Projects 4,465,300 10700 Fire Services 771,000 10900 Library 457,000 Total $18,348,064 3 City of Pickering Annual Debt Charges for 2022 Approved Capital Projects 2022 Project# Description Annual Project Debt Charges Amount Property Tax Debt Debt -5 Year 5340 .2215 FS #2 Interior Renovation $77,000 $371,000 Total Cost of Debt -5 Year $77,000 $371,000 Debt -15 Year 5340.2209 Fire Pumper Rescue Replacement $93,000 $1,200,000 Total Cost of Debt -15 Year $93,000 $1,200,000 Total Cost of Property Tax Funded Debt $170,000 $1,571,000 DC Debt DC Debt -15 Year (Protective Services} 5219 .2201 Animal Shelter -Construction $465,000 $6,004,000 Total Cost of Debt -15 Year $465,000 $6,004,000 Total Cost of DC Funded Debt $465,000 $6,004,000 Grand Total $635,000 $7,575,000 6 City of Pickering Accessibility Capital Projects 2022 Approved Capital Budget and 2023 to 2026 Capital Forecast Project Description 2022 Redman House Restoration (gross project cost= $700,000) Mitchell Park -Asphalt Pathways Reconstruction Accessible Public Washroom (Claremont Library) Fire Station #2 Interior Renovation (gross project cost= $371,000) Accessible Playgrounds (Parks) (gross project cost= $1,451,264) Valleyview Park Playground Construction (gross project cost= $120,000) RHM Park -Playground Replacement (gross project cost= $125,000) West Shore Boulevard Asphalt Sidewalk Construction Pickering Parkway -Multi-use Path Reconstruction The 2022 Capital Forecast includes four Village Greens and a Neighbourhood Park which will have accessible paths and other features. 2023 Walkway Reconstruction: Foxwood -Beckworth Walkway Reconstruction: Graceland -St. Mary Park Walkway Reconstruction: Whites -Cognac Walkway Reconstruction: Rosebank -Lightfoot Rec Complex Elevator Retrofit (gross project cost= $100,000) Dunmoore Park Pathway Construction J. McPherson Park -Accessible Pathway Construction Pathway Construction (Accessibility to Parks) Accessible Pedestrian Signals -4 locations (Year 2 of 5 year program) Accessible Pedestrian Signals -4 locations (Year 3 of 5 year program) Martin's Tot Lot Playground Replacement (gross project cost= $80,000) Playground Replacement -Southcott Park (gross project cost= $120,000) New Sidewalk Installation (Location TBD) Finch Avenue -Temp Asphalt Sidewalk Finch Avenue -New Sidewalk Construction Mapleridge Park Master Plan -Construction (gross project cost= $400,000) Beachfront Park Master Plan -Phase 1 Construction (gross project cost= $4,500,000) Primary Trail Network -Seaton T-1 Fire Station #5 Replacement (gross project cost= $5,867,000) Improvements to GAL Public Library Space Phases 1 & 2 (gross project cost= $300,000) 7 Accessibility Component of Project Cost $40,000 150,000 60,000 · 50,000 1,161,011 60,000 62,500 200,000 300,000 $2,083,511 $125,000 125,000 125,000 125,000· 30,000 200,000 300,000 300,000 361,000 361,000 40,000 60,000 200,000 100,000 75,000 100,000 1,125,000 360,000 50,000 20,000 $4,182,000 City of Pickering Accessibility Capital Projects 2022 Approved Capital Budget and 2023 to 2026 Capital Forecast The 2023 Capital Forecast includes a Village Green and three Neighbourhood Parks in Seaton which will have accessible paths and other features. Project Description 2024 Walkway Reconstruction: Strouds -Sultana Walkway Reconstruction: Charnwood -Greenvale Trail -Bayly Street -Waterfront Trail to Go Station Brougham Temperance House Restoration -Construction (gross project cost= $350,000) Pathway Reconstruction Major Oaks Park Pathway Reconstruction Locations TBD New Sidewalk Installation (Location TBD) Accessible Pedestrian Signals - 4 locations (Year 4 of 5 year program) Beachfront Park Master Plan Phase 2 Construction (gross project cost $3,300,000) Playground Replacement -Chickadee Park (gross project cost= $110,000) Whitevale Park -Playground Replacement (gross project cost= $140,000) Playground Replacement -Diana, Princess of Wales Park (gross project cost= $150,000) Primary Trail Network -Seaton T-4/T-5 Primary Trail Network -Seaton T-2 The 2024 Capital Forecast includes one Neighbourhood Park in Seaton which will have accessible paths and other features Project Description 2025 Walkway Reconstruction: Cattail -Dunbarton H.S. Walkway Reconstruction: Tanzer -Bayshore Tot Lot Trail -Bayly Street from Go Station to Hydro Corridor Civic Centre Elevator Upgrades (gross project cost= $240,000) Civic Centre Washrrom Renovations Civic Centre Renovations and Addition -Construction (gross project cost= $14,935,000) O'Brien Arena Renovation -Construction (gross project cost= $3,662,000) 8 Accessibility Component of Project Cost $125,000 125,000 539,600 20,000 150,000 300,000 200,000 361,000 850,000 55,000 70,000 75,000 1,090,000 360,000 $4,320,600 Accessibility Component of Project Cost $125,000 150,000 377,700 40,000 50,000 1,000,000 200,000 City of Pickering Accessibility Capital Projects 2022 Approved Capital Budget and 2023 to 2026 Capital Forecast Project Description 2025 Continued ..... General Store Restoration -Construction (gross project cost= $54,000) Harvey House Restoration -Construction (gross project cost= $258,000) Pathway Reconstruction Locations TBD Accessible Pedestrian Signals -4 locations (Year 5 of 5 year program) Playground Replacement -Bayshore Tot Lot Park (gross project cost= $120,000) Playground Replacement -Lynn Heights Park (gross project cost= $120,000) Playground Replacement -Bonita Park (gross project cost= $120,000) New Sidewalk Installation (Location TBD) Primary Trail Network -Seaton T-9 Primary Trail Network -Seaton T-10 2026 CHDRC Pool Renovations -Construction (gross project cost= $2,160,000) Fire Station# 4 Interior Retrofit (gross project cost= $192,000) New Sidewalk Installation (Location TBD) Pathway Reconstruction Locations TBD Trail from Creekside Park to SWM Pond Trail -Hydro Corridor -Liverpool to Whites Trail -Wharf Street to Sandy Beach Road Community Park -Greenwood Conservation Lands (gross project cost= $4,577,000) Playground Replacement -BRK Park (gross project cost= $150,000) Playground Replacement -Clearside Park (gross project cost= $120,000) Playground Replacement -Glengrove Park (gross project cost= $120,000) Playground Replacement -Pinegrove Park (gross project cost= $120,000) Seaton Community Centre -Construction (gross project cost= $73,430,000) Seaton Regional Librray -Construction (gross project cost= $17,690,0000) The 2026 Forecast includes four Village Greens and a Community Park in Seaton which will have accessible paths and other features. Accessibility Component of Project Cost 10,000 40,000 300,000 361,000 60,000 60,000 60,000 200,000 140,000 320,000 $3,493,700 $150,000 $10,000 $200,000 300,000 230,000 982,000 431,000 1,518,000 75,000 60,000 60,000 60,000 1,000,000 20,000 $5,096,000 Total $ 19,175,811 9 City of Pickering 2022 Capital Budget ---~ 2019 2019 1 2020 2021 2022 Budget Actuals Actuals Actuals Balance Ma~or Ryan -1 Rema ining Expenditures -· I I $6 ~ 1 I $9 ,389 504800 Cap Information Tch $10 ,000 $0 1 $0 Total Expenditures $10,000 $0 1 $0 $611 I $9,389 Financing --- 408001 Trf fr Rplc-Cap Res ($10 ,000) Total Financing ($10,000) I ' 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 (from January 1, 2019 to May 1, 2022). 10 City of Pickering 2022 Capital Budget 2019 l 2019 2020 2021 ! 2022 Budget Actuals Actuals Actuals I Balance K. Ashe, Reg. Coun. Ward 1 . ·---I Remaining - Expenditures I ·--- 504800 Cap Information Tch $10,000 1 $814 $0 $0 $9,186 Total Expenditures $10,000 1 $814 $0 $0 I $9,186 Fin_ancing --------------·· -----· I 408001 Trf fr Rplc-Cap Res ($10,000) - Total Financing ($10,000) I .. - 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 (from January 1, 2019 to May 1, 2022). 11 City of Pickering 2022 Capital Budget I ' 2019 2019 2020 2021 2022 Budget Actuals Actuals Actuals ( Balance f B. McLean, Reg. Coun. Ward 2 ----· ----t ~~main ing _ Expenditures --- 504800 Cap Information Tch $10,000 $0 $1 ,549 $0 $8,451 Total Expenditures $10,000 1 $0 ) $1,549 $0 $8,451 Financing ··-·-··---- ($10 ,000)1 408001 Tri fr Rplc-Cap Res -· ------- --· ____ _T otal Financing ($10 ,000) 1- I 1· I I As per Council Compensation & Communication Policy (Subsection 12.1 ), $10,000 is provided for computer hardware, software and telecommunications pe r term . As per the policy, these funds can only be spent during the first 40 months of office (from January 1, 2019 to May 1, 2022). 12 City of Pickering 2022 Capital Budget I I -; 2019 I 2019 2020 2021 2022 Budget I Actuals A~tuals _I Actuals Balance D. Pickles, Reg. Coun. Ward 3 ----- $0 1 Remaining _!=xpenditures ·-- . ------·-·-' $10,ooo i 504800 Cap Information Tch $205 $662 $9 ,133 Total Expenditures $10,ooo ; $205 / $662 $0 / $9,133 Financing I I ------------- 408001 Trf fr Rplc-Cap Res ($10 ,ooo>l I ----·- -· Total Financing ($10,000)1 I I I I 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 (from January 1, 2019 to May 1, 2022). 13 City of Pickering 2022 Capital Budget -- I -I t 2019 2019 2020 2021 I 2022 Budget I Actuals I Actuals Actuals I Balance I C. Doody-Hamilton City Coun. Ward 2 I Rem ~ining ----I ·--~:-, --• --- Expe~ditures ---·-------- 504800 Cap Information Tch $10,000 $0 $0 $5 ,771 Total Expenditures $10,000 $0 1 $0 $0 $5,771 Financing I ------. -... ___ 408001 Trf fr Rplc-Cap Res ______________ ($10 ,000) - . ··1 Total_Financing ($10,000) -I I I I I 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 (from January 1, 2019 to May 1, 2022). 15 City of Pickering 2022 Capital Budget ··•--·---- 2019 I 2019 2020 2021 2022 Budget I Actuals Actuals Actuals Balance S. Butt, City Coun. Ward 3 Rema ining ·----- Exp~nditures --_ .... ----------· 7 I 504800 Cap Information Tch $10 ,000 1 $4 ,316 $2 ,531 I $751 $2,402 Total Expenditures $10,000 J $4,316 $2,531 J $751 $2,402 Financing --I I 408001 Trf fr Rplc-Cap Res ($10 ,000) --I --I -- ·-·-------·--Total Financing ($10,000) I j i I I 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 (from January 1, 2019 to May 1, 2022). 1 6 City of Pickering 2022 Approved Capital Budget Office of the CAO Dept. Summary Expenditures Capital Machine&Eqp Total Expenditures Financing Trf fr RateStblz Res Total Financing 17 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 80,000 80,000 (80,000) (80,000) Corporate Projects Expenditures Capital Machine&Eqp Total Expenditures Financing Trf fr RateStblz Res Total Financing City of Pickering 2022 Approved Capital Budget 18 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 80,000 80,000 (80,000) (80,000) City of Pickering 2022 Approved Capital Budget Corporate Projects Run Date: Apr 1 , , 022 Funding Expense SAPWBS SAP GL Account element / SAP Description ,GL Account .. •s,----• ·----·-·-·-~ •-·----~---••----·-· -·····"---·----·--·-. ·-------···· ··------ --· ---------------~----·-· ---··-------- 5192.2209 EV_Charging Stations--······---···-·--.... ~--·· 1C10325.2201.01 ···-6178 Machinery & Equipment ___ ··-f;";,i)()(, '504200 Capital Machine&Eq~ 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 ' -~--~-~---~--,•-•-~--. ··-~•---~~---· 7021 R -Rate Stabilization (80,000) 408007 Trf fr RateStblz Res .... ----------··---··-··---------· '"··--------·-----.. --.~----------···--·-• ... _, ___ ... Total_ 5192.2209_EV Charging_Stations _______ (80,000) 80,000 Total Coroorate Proiects (80,000) 80.000 1 9 City of Pickering 2022 Approved Capital Budget Community Services Dept. Summary Expenditures Capital Parks Building Rpr & Mntc Cap Furniture&Fix Capital Machine&Eqp Capital Accessibility Capital Consulting Capital Consulting Capital Buildings Total Expenditures Fi_nancing Federal Grants Ontario Grants DebtFinancing-20Year Internal Loan-5Year Internal Loan-10Year Property Tax Funded Trf fr Self Ins Res Trf fr RateStblz Res Trf fr Dunbrt Pl Res Trf fr Don Beer A Res Trf fr PRC Pool Res Trf fr PRC Arena Res Trf fr FacilitiesRes Trf fr Major Equip Res Res Trf fr Casino Res Trf fr FGT Oblg RF Trf fr DC-P&R OB RF Trf fr Seaton FIA RF 20 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 515,000 150,000 859,000 25,000 125,000 200,000 950,000 40,000 220,000 70,000 70,000 24,437,960 2,665,000 26,467,960 3,859,000 (3,309,800) (560,000) (44,500) (426,000) (11,391,900) (200,000) (247,500) (198,560) (66,000) (200,000) (1,350,000) (2,103,000) (20,000) (40,000) (30,000) (114,000) (385,000) (395,000) (50,000) (562,000) (570,000) (8,061,950) (1,750) City of Pickering ·2022 Approved Capital Budget Community Services Dept. Summary Total Financing 21 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget (26,467,960) (3,859,000) Civic Complex Expenditures Cap Furniture&Fix Capital Consulting Capital Buildings Total Expenditures Financing Federal Grants Ontario Grants Internal Loan-10Year Property Tax Funded Trf fr Self Ins Res Trf fr RateStblz Res Trf fr Major Equip Res Res Trf fr FGT Oblg RF Total Financing City of Pickering ·2022 Approved Capital Budget 22 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 25,000 150,000 892,000 1,300,000 1,042,000 1,325,000 (178,000) (44,500) (247,500) (55,000) (25,000) (60,000) (232,000) (1,000,000) (65,000) (160,000) (300,000) (1,042,000) (1,325,000) Dunbarton Pool Expenditures Capital Buildings Total Expenditures Financing Trf fr RateStblz Res Trf fr Dunbrt Pl Res Total Financing City of Pickering 2022 Approved Capital Budget 24 Run Date: Jun 6; 2022 2021 2022 Approved Approved Budget Budget 45,000 170,000 45,000 170,000 (45,000) (150,000) (20,000) (45,000) (170,000) City of Pickering 2022 Approved Capital Budget Dunbarton Pool Run Date: Apr 1 , 2022 Funding Expense SAPWBS SAP GL Account element / SAP Description GL Account .. .... _________ , . ·····---··-""·· ................ ········-···---··-····· , .... ._ --·-· ..--------·-"·--. ··--·----.-... ------·--------·----···•-··•·--·------------•<'•-------..... .... .-.... I 5713.2201 Various.Roof & Structural_Repairs ...... : i C10210.2101.01 .. ... 6500_ Building Related ._ •.• u ____ ••••••~••••-••-•••••~•••••"•-••••• ••-• • •-" H'l,00D jS04100 Capital Buildings Additional funding for various lifecycle repairs and I I I reinforcement required to extend the life of the I I building asset (capital project C10210.2101). I I i ---------·-------··--·=-------------· -----------· ---_____ ,, ----------- 7021 R-Rate Stabilization (150,000)1 ;408007 Trf fr RateStblz Res , ..... -------------------~---·--·---,--- .... Total.5713.2201 Various.Roof & ~tructural_Repair, (150,000)' 150,000 I 5713.2202 Pool_ Controller Replacements·-· I C10210.2202.01 -------"'·'"-··~-----·-----« ._ --- _ 65Q0 Building_ Related ----·-··-------' ;504100 Capital Buildings Lifecycle replacement of pool equipment controllers. Existing units were installed in 2011. ---· •--•••••• -••-----oc-••--"•--••--•---•-•-"•"'-••Y••-~~ "'••----• -••-•---•• •---••-- (20,000): __ _7032 R-.Dunbarton PoolSurcharge _ 408011 Trf fr Dunbrt Pl Res ------·---··-~--~----· _ Total 5713.2202 Pool ControUer Replacements (20,000)i 20,000 Total Dunbarton Pool (170,000\, 170,000 25 Don Beer Arena Expenditures Capital Machine&Eqp Capital Consulting Capital Buildings Total Expenditures Financing Trf fr Self Ins Res Trf fr DonBeer A Res Trf fr Major Equip Res Res Trf fr FGT Oblg RF Total Financing City of Pickering 2022 Approved Capital Budget 26 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 125,000 70,000 230,000 425,000 (20,000) (40,000) (125,000) (240,000) (425,000) Community Centres Expenditures Capital Accessibility Capital Consulting Capital Buildings Total Expenditures Financing Federal Grants DebtFinancing-20Year Property Tax Funded Trf fr Self Ins Res Trf fr RateStblz Res Trf fr FGT Oblg RF Trf fr DC-P&R OB RF Total Financing Abbreviations City of Pickering 2022 Approved Capital Budget GALCC GWL TCC WACC George Ashe Library and Community Centre Greenwood Library Dr. Nelson F. Tomlinson Community Centre Whitevale Arts and Culture Centre · 27 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 900,000 30,000 21,617,400 222,000 22,517,400 252,000 (3,091,800) (11,391,900) (41,000) (40,000) (151,000) (60,000) (7,993,700) (22,517,400)" {252,000) Seaton Community Centre Expenditures Capital Consulting Total Expenditures Financing Trf fr DC-P&R OB RF Trf fr Seaton FIA RF Total Financing City of Pickering 2022 Approved Capital Budget 29 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 70,000 70,000 (68,250) (1,750) (70,000) Rec.Complex-Core Expenditures Capital Machine&Eqp Capital Buildings Total Expenditures Financing Ontario Grants Internal Loan-5Year Property Tax Funded Trf fr Self Ins Res Trffr RateStblz Res Trf fr FacilitiesRes Trf fr Major Equip Res Res Trf fr Casino Res Trf fr FGT Oblg RF Total Financing City of Pickering 2022 Approved Capital Budget 30 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 200,000 1,543,560 576,000 1,543,560 776,000 , (188,000) (200,000) (93,560) (40,000) (408,000) (438,000) (385,000) (205,000) (50,000) (162,000) (150,000) (1,543,560) (776,000) City of Pickering 2022 Draft Capital Budget Projects Listing Rec.Complex-Core Project Name 5731 Rec.Complex-Core 5731.2201 Chilled Water & Condenser Pump Replacements 5731.2203 BAS & Control Systems Upgrade -Design 5731.2204 Health Club Equipment Replacement 5731.2205 Tennis Court Flat Roof Gutter Repairs 5731.2206 Banquet Hall Floor Replacement 5731.2214 Sealant Replacement Total 31 Run Date: Jun 7, 2022 2022 Project Budget 150,000 80,000 200,000 120,000 155,000 71,000 776,000 City of Pickering 2022 Approved Capital Budget Rec.Complex-Core Run Date: Apr 1 , 2022 Funding Expense ISAPWBS SAPGL element / SAP Account ' GL Account Description ---"._ ... ............,_ ____ --"•·---••-" -'• -··----··· ~-"'·' "•"'·' i ·-··· ------------------·---·-- 5731~2201 Chilled Water & Conde11ser Pump_Replacements ______ J 'C10225.2201.01 ___ 6500 _Building Related i ! ,00:' 504100 Capital Buildings ---·-------------·--- Lifecycle replacement of chilled water and i condenser pumps including related controls ' components and accessories. ! ----------·-·-- 7505 RF -Federal Gas Tax ! ··----~------------·-----·---------· -----------~----~---•"'•----~--(150,000), '408502 Trf fr FGT Oblg RF ____ .. T_otal ... 57?1 .2201 _Chjlled Water_ & _Con(!enserPumi (150,000): 150,000 5731.2203 BAS & Control Systems Upgrade -_Design I C10225.2203.01 6500 Building Related [ i{l( 504100 Capital Buildings -.... ~--.--------•-•<'•-_,,_ __________ .,,~ i Investigation and design costs for lifecycle upgrade to the Chestnut Hill Developments Recreation Complex's (CHDRC) 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 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 , ------------------·-------------------------------- (80,000): 7021 R -Rate Stabilization 408007 Trf fr RateStblz Res . ----··"··-··---""•····------· ____ .,,. ______ . .-.... _, __ ···-··•••-·-----.. --------~--••·····" •·-· -·· ·-·· -. ' . ___ Total,_ 5731.2203 BAS & Control Syste1T1s. Upgrade (80,000) 80,000 ?731.2204 Health Club Equipment Replacement C10225.2204.01 ----- ___ 6178 __ Machinery & Eguipment ________ -----·--··--·-i .,, .. .,_, ________ , 200,01.X 504200 Capital Machine&Ec Fitness Equipment Replacement: Strength Machines (21), Cardio Machines (17) ··-7021 R -Rate Stabilization _________ ··-~-·-·. (200,000): 408007 Trf fr RateStblz Res To4J.I. 5731.2204 Health Club_ Equipment_ Replacer, (200,000)1 200,000 §J_31.2205 Tenriis -~_ourt Fla!~.O_Q_f_Gutter Repair_s __ ' . C10225.2107.01 1623 Prov Grant (f:h 402510 Ontario Grants ····-···-···--·--·-···· ·-•--·~ --·"-· ----••<>• -'••••••••• .. •• ----•-u" •• • u+>••--••-•~••"'•"'----•••• +w.•••-••••~"•-' Ontario Trillium Foundation -confirmed ' . ··-------·---~--~--~·-·-~---~----··--·--~----~ .... ---. ·-~~-· --.-"·· ""~-··--·- 6500 Building Related . 'l2t" ,; ·504100 Capital Buildings -----------· Additional funding for Tennis Court Flat Roof Gutter Repairs (capital project C10225.2107) I ............. , .... , ~+»-~ •.JoM••••~~--~-•-•••••~•••••••~• • •• .. •+c.n••--•-••-••••••-• 7021 R -Rate Stabilization (40,000), 408007 Trf fr RateStblz Res -·------------·---··-· . -· - Total 5731.2205 Tennis Court Flat Roof Gutter Re (120,000) 120,000 -~------~-~----~-------•----------·-···~-----------·--------------------------- !>731.2206 .. Banquet. Hall_Floor Replac~ITlent C10225.2206.01 1623 Prov Grant \ I 402510 Ontario Grants --------~-------------·-·-·---------·· --------------- Ontario Trillium Foundation -confirmed +• •-•M-m•++.++++•--••-------•••'--••~ •+•'-••••"'""'-•-••••0. ••"•-'•+••••••••-+•• ••+• •~••••-•••••• ----•-•--••--•••-•U .. --·- 6500 Building Related 1 504100 Capital Buildings ···· ··· ·· Replace existing cork flooring in the banquet hall with new resilient flooring. ••••H + -· ---s,••------·---·-··· -----·&•• ·----·-~· •·-.•. 7021 R -Rate Stabilization ' (47,000): 408007 Trf fr RateStblz Res --------~----.. ----·--·--·--------·-·-----------------· ---~---. -------------------~--- Total 5731.2206 Banauet Hall Floor Replacement (155,000)i 155,000 32 City of Pickering 2022 Approved Capital Budget Rec.Complex-Core Run Date: Apr 1 , 2022 I Funding Expense SAPWBS SAPGL . element / SAP Account """ ... ,, ................. _. __ '-·-·•·-·~ .. ~---·-•--~ ....... , .. "-···'·--·"··-~-----·" ,GL Account Description : -----·---·- i 5731.2214 Sealan_t ~eplacef!!ent , C10225.2214.01 "" --·-·••.-•··• ---f?_tQQ_~L!"ilding Related i 7",,000 504100 Capital Buildings ------------ Lifecycle replacement of exterior sealants at . • various locations, including tennis court precast • _______ ,_ _ __ J ________ -----------·--·--··· ·-· --··-~·-------i 7021 R -Rate Stabilization I (71,000)' 408007 Trf fr RateStblz Res •-••·'• ,,>•,••"••••"'•M,c,;•~-~~-•~---~ . ••~-~---~-••'"<""C"' .. -••--•-·----·- (71,000)l Total 5731.2214 Sealant Replacement ----" ; 71,000 -- Total Rec.Complex-Core ! (776,000); 776,000 33 Rec. Complex-Pool Expenditures Capital Buildings Total Expenditures Financing Ontario Grants Trffr RateStblz Res Trf fr PRC Pool Res Total Financing City of Pickering 2022 Approved Capital Budget 34 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 30,000 77,000 30,000 77,000 (52,000) (25,000) (30,000) (30,000) (77,000) City of Pickering 2022 Approved Capital Budget Rec. Complex-Pool Run Date: Apr 1 , 2022 Funding Expense SAPWBS SAPGL element / SAP Account GL Account Description -·-···---··-.__. ___ ·····-·--...... -·---•-•--·-· --------~ --........ ______ ., __ --·-----------~ .. --..... -,., ____ 5733.2201 PootBleachers Replacement ______ Cl0230.2201.0l __________ , __ 1623 Prov Grant (5 402510 Ontario Grants ------------------------. --· "--~-.-----------------•-'<••··----.... ----•---•··--·-·------··-----.--------------- Ontario Trillium Foundation -confirmed ---------------------···--·-----------------------·' _,, ----------------- ----~500 Buildir:ig_E_~l_ated ________________________ ., ___________ -! ., ,(" .so4100 Capital Buildings Lifecycle replacement of original 1983 retractable bleachers. ' ·-•·~··•--·--····-. . ~.,. _______ ,, ___ 7021 R -Rate Stabilization (25,000) 408007 Trf fr RateStblz Res •·•••••-•·•»--•••••-• --•-•>P•-~-, -~~--•-~-----"--'- Total 5733.2201 Pool Ble.~c,~~rs R.,eplace,'!!ent _" . (77,000) 77,000 c--~•~~•-•---'-'•-'.--'~~-~ Total Rec. Complex-Pool (77,000) 77,000 35 Rec.Complex-Arenas Expenditures Capital Buildings Total Expenditures Financing Ontario Grants Trf fr Self Ins Res Trf fr PRC Arena Res Trf fr FGT Oblg RF Total Financing City of Pickering 2022 Approved Capital Budget 36 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 40,000 320,000 40,000 320,000 (146,000) (40,000) (114,000) (60,000) (40,000) (320,000) City of Pickering 2022 Approved Capital Budget t Rec.Complex-Arenas Run Date: Apr 1 , 2022 Funding I Expense SAPWBS SAPGL i i element/ SAP Account GL Account Description ·-· ····--"' .. ~.•·-•·-·---.~·--~--»--_,.~~---·• ... ' ~----------·-----•"'-------------------------------------·--•----- ; 5735.2201 O'Brie,n Aren~ Skate Tile ~eplacemE}nt .... l C10235.2201.01 1623 Prov Grant (•,,;:",CJOr:i)· 402510 Ontario Grants -----••--•------"'M"---- Ontario Trillium Foundation -confirmed -------· , __ ·-----~--·-···-··--·-··--·------------------_________________ ., ____ ,, __________ 6500 Building Related , 705(:i")P '504100 Capital Buildings ••• "'•-• --~•---~•-,,. ~--~~~-•-~•-••-'-m½•·••~•--•-• • •--•-~~~ ••-•~••• -~-----•---•~••-•"-' Lifecycle replacement of existing athletic flooring in arena, originally installed in 1992. Budget includes $10,000 for project grant signage. i : ---------·----------------------- ... 7036.R -R/CmpJx Arena.Surcharge ----·· ··-·-·····-··-(59,000)1 408015 Trf fr PRC Arena Res ___ To~.L 573§.~2.0t Q'Bri~nAre_n_~ SkaJgTile Replac~ (205,000), 205,000 .5735.2202 Delaney S~ylig!}tJ~e.P!~~~!!!e.11t_ ______ I C10235.2202.01 ---- __ 6500 Building Related ________ 504100 Capital Buildings Lifecycle replacement of skylights over upper ' aisle walkway and stairwell in Delaney arena, originally installed in 1992. --,~---·· ----·-·-·- (55,000) .. 7036.R -R/CmpJx Arena Surcharge ____ ,408015 Trf fr PRC Arena Res .... _, __________ Total 5735.2202 Delaney Skylfght Replacement·-·' (55,000): 55,000 -·· 5735.2203 O'Brien Hot Water.Tank Replacement C10235.2203.01 -··- ·-6500 BuildirrgMated ·--·-----··-·-504100 Capital Buildings Lifecycle replacement of existing hot water tank. ! The equipment is original, installed in 1992. "' ----------------------·--·--••">--~------·----------·-·------------------- 7505 RF -Federal Gas Tax (60,000); 408502 Trf fr FGT Oblg RF ·---···-··---·----·---·---_, ... , .. ·~----~---~------------••·--·-----....... .,_ ... ... _Total. 5735.2203 O'Brien Hot Water Tank_Re~lace1 (60,000)1 60,000 Total Rec.Complex-Arenas ' (320 000), 320 000 37 Museum Expenditures Capital Parks Building Rpr & Mntc Capital Accessibility Capital Consulting Capital Buildings Total Expenditures Financing Federal Grants Ontario Grants Property Tax Funded Trf fr RateStblz Res Total Financing City of Pickering 2022 Approved Capital Budget 38 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 515,000 150,000 859,000 50,000 40,000 40,000 40,000 755,000 939,000 (40,000) (560,000) (40,000) (50,000) (665,000) (339,000) (755,000) (939,000) City of Pickering 2022 Approved Capital Budget Museum Run Date: Apr 1 , 2022 Funding Expense SAPWBS SAP GL Account element / SAP Description •GL Account ---·--·-·--. --------·-····-·-,.---··-·--· . ... ._ .......... ---···· ----·--··-------.--' ..... --.~----.. """"•· --------------------------------·-.... -----.----------~-----.-----·-·'" ,-~7'~~:_2205 Log Barn & House Restoration -Design & Construction • C10250.2205.90 1623 Prov Grant {40,000) i402510 Ontario Grants ···---•»•-···---····-·-------------------····· .. --~,..,-.,--·--·------........ ____________ , ______________ . .......... .. 6149 Restoration -Museum Bldg __ ---·--····-···--... ---'131: 1502340 Building Rpr & Mntc Structural repairs, waterproofing, roofing replacement and interior framing and finish work. Includes design costs, testing and construction. ' ····· ..... 6230 _prof/ConsultingFees ··--·-· 40,000 :502340 Building Rpr & Mntc 7021 R -Rate Stabilization (134,000) •408007 Trf fr RateStblz Res ---·---··-···-·-··--·~·-·-...... ________ --------····-···"· --... -----·-··""·•··~ ---·-··-----······· ..... -------------· . __ TotaI_5744 .. 2205 Log.Barn &_House_Restoration-_ (174,000) 174,000 • 57 44.2210 Redman House Restoration • C10250.2210.01 ---"--------··-----· ·--------·-------------------·---~ -- 1610 Federal Grants (560,000) •402500 Federal Grants . ------~----------------·--------------------·-·-·---------------- 6149 Restoration -Museum_ Bldg __ . .. . ........... , ,.1n 504100 Capital Buildings , .•.. ---------•-•-·- Restoration of various structural and architectural elements of the building required to maintain a heritage asset. Includes selective repairs to cladding, roofing, porch and barrier-free access ramp. Foundation and chimney repairs are also required. Redman House includes heritage construction dating back to the 1840s, and was expanded in 2004. This project will be limited to design unless the grant application is successful. .•. ••• ~ ~• •·-•• ,.,~;,.,-•. ~L.·' ""•••••· __ ,.,_ •-••• °'-~---_______ , ________ •504100 ... 61_ 83_~(?Ce~~jl)iliJy .. "' Capital Buildings •----···-·-·-··--•--a.•--·-U-----"--------·-•··--.. ··· ............. , .. __ "'~ ... _,Project will include_improvementstoacct3ssi_bility . 7021 R -Rate Stabilization (140,000). 408007 Trf fr RateStblz Res -••-•-••••• •-•••·<,-H,~-• •-•••~•~-•-•-•-<-•••-------•----•-------------------- Total 5744.2210 Redman House Restoration . ,,, _________ ,, ____ --~--~ ,, ______ .,.,,~--~-... ,, ..... ~ -~~---~--~~~--..... ,_____,_,_., --~---··---,_,_ ... _,_,. __ ,._~~-·--~~---~-(700,000) 700,000 5744.2213 Odd Fellows Hall Window Restoration C10250.2213.90 ••-'--~-~•·•-~"-• •'-••••••·••••-~---s<-•••••-•••~• •-~--•~--~-""•'"•' ••••-nH,>~••••••-•-••----•--•••--••'h• •----•~ =• ~--••>- .... §J 42. Restoratiori: .. M.1:1.5-~1:'1!1 §J~g_ .... 502340 Building Rpr & Mntc Restoration of 8 existing large custom wood frame windows with single pane float glass. Odd Fellows Hall was originally constructed in 1869. ~----·---.. ~ -•--·--"--------~---~-~ -, ___ .-, ___ ., --~---- 7021 R -Rate Stabilization (65,000) :408007 Trf fr RateStblz Res ... --···------~---·--·-··-•-~-•-·-·" ---,-. -- Total 57 44.2213 Odd Fellows Hall Window Resto1 (65,000) 65,000 -----~~~---· ---~-~-----·"·· ---~--,.,,,,_ ___ """ .. -~ ----------~ --------~-~---~-·~-----~·-·-- Total Museum (939,000) 939,000 I . ' 39 Operations Dept. Summary Expenditures Capital Parks Capital Vehicles Capital Vehicles Capital Vehicles Cap Information Tch Capital Machine&Eqp Cap Library Coll Mat Other Fixed Assets Capital Accessibility Capital Consulting Capital Land Capital Parks Capital Vehicles Capital Vehicles Capital Machine&Eqp Total Expenditures Financing Donations Federal Grants DebtFinancing-15Year Property Tax Funded Trf fr RateStblz Res Trf fr DC City's Res Trf fr VhcleRplc Res Trf fr Fence Res Trf fr Tennis Res Trf fr Major Equip Res Res Trf fr 3rdPtyOblg RF City of Pickering 2022 Approved Capital Budget 40 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 3,420,000 2,685,253 555,000 764,500 915,000 1,305,000 984,000 25,000 1,005,000 1,167,000 25,000 180,000 205,000 1,420,000 1,483,511 95,000 3,100,000 1,280,000 1,844,000 125,000 200,000 680,000 40,000 12,385,000 11,118,264 (10,000) (27,500) · (100,500) (1,200,000) (25,000) (100,000) (160,000) (1,060,322) (1,635,000) (425,000) (1,547,000) (1,536,000) (180,000) (180,000) (90,000) (135,000) (790,000) (687,000) (41,375) Operations Dept. Summary Trf fr PrklndOblg Rs Trffr FGT Oblg RF Trf fr DC-ProtectORF Trffr DC-TrnsprtORF Trf fr DC-OthHwy ORF Trf fr DC-P&R OB RF Trf fr DC-Libr OB RF Trf fr Seaton FIA RF Total Financing City of Pickering 2022 Approved Capital Budget 41 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget (4,180,000) (1,907,942) (320,000) (150,000) (53,625) (200,000) (40,000) (1,340,000) (2,883,000) (2,222,900) (198,000) (32,000) (46,100) (12,385,000) (11,118,264) Property Maintenance Expenditures Capital Machine&Eqp Other Fixed Assets Capital Accessibility Total Expenditures Financing Trf fr VhcleRplc Res Trf fr Fence Res Trf fr Major Equip Res Res Trf fr PrklndOblg Rs Total Financing City of Pickering 2022 Approved Capital Budget 42 Run Date: Jun 6, 2022 2021 2022 Approved. Approved Budget Budget 650,000 · 410,000 120,000 120,000 500,000 50,000 1,270,000 580,000 (40,000) (120,000) (120,000) (610,000) (410,000) (500,000) (50,000) (1,270,000) (580,000) Property Maintenance City of Pickering 2022 Approved Capital Budget 5311.2206 WidE3_Area Mower Repla~~ri:i~11t ·-··-··-· __ 6178 Machinery & Equipment .......... . . ..Wide Area Mower-replace_unit #770(2016) Run Date: Apr 1, 2022 Funding I Expense SAP WBS SAP GL Account element / SAP Description GL Account , Cl0305.2206.01 504200 Capital Machine&Eqp ... 7062 R -fl{!§jDrEq~ipfilent ____ -·-·-----'---'-( 1:....::3-"5-'-', 0:....::0:....::0.L."---), _____ 4_0_80_3_2 ___ -+T_rf_f_r_M-'aJ,_· o_r _Eq.,_u~ip_R_e_s _Re-ls ... Total. 531.1.~2206 Wide .Area Mower. RE:lplacement ·'-; --'(._1_35-'''-0_00-')'-· __ 1_3-'5,'-0-=-00.::.....c. _____ -+--------1 5311.2207 PrOJ?~rty~ine Fence Repfacement 6181 Other Fixed Assets -------·--·------·-·-----··"-"" ___ ---·--·-------····---< Additional funding for replacement of property linei fences along City road allowances at various locations . ....... ~--"-••--•··-----------··--·····-. ---··•--·----•·-··---____ .,._ -----·-···--. C10305.1505.90 i: · • 502760 Other Fixed Assets .... IQ5]_~ _ _:-_£_~r.i_c::~....... --·--·················-·-····-···-···~-('-'1_2_0!..;:,0...:.0..c.0.,_) _____ 4_0_80_2_8 ___ -+T_rf_f_r F_e_n_ce_R_e_s __ --1 .Total. 5311.2207 Property Une Fence. RepJaceme1'----'(._1_20_,,'-0_00-') __ 1_20_,,'-0_00 ______ -+--------1 §.~.1. 1.2208 Zero Turn MowersB~.PJ~.c~rn~1_1!_::_f.::_~f!!:ic(3) C10305.2208.01 .6178 Machinery & Equipme~t ... .. _ ....... , Electric Zero Turn Mowers -Replace gas units I ,,") 504200 Capital Machine&Eqp #S431, S432, and S433 (2015) ... 7062 R-Major Equipment_. ····-·-·--···-------'-(8_0_,_,0_0_0_,_1)_. ----------+---"-----'---'----1 408032 Trf fr Major Equip Res Res 80,000 ... Jotal .. 5311 .. 2208 .Zero Turn_ Mowers_Rep1acement'-: _ _.(_80....,,_00_0_.) __ ___, _______ -+--------i 5311.22Q~ __ ~idewalk E.lowwith Atta~brl!~!l.t~ .. :-Repl~cement C10305.2209.0l . 6178Machinery &_Equipment... . . ·······-···--··· 504200 Capital Machine&Eqp Sidewalk Plow & Attachments -replace unit #703 ..... J2015) ·-----··----··-·-------··--···-----' .... 70€}2 _ R -_ Major Equipment .... · ........ ·---·-. _ . . __ _,(~1 _75_,_,_00_0_,_) __________ +---~-~---1 ... Total __ 5311.2209 SidewalkPlow with Attachments.,--_(._1_7~5,'-0_00_,)'------''---------+---------1 408032 Trf fr Major Equip Res Res 5311.2213 Trailer-New -"-,-,,--· ·•-«-•""------,--·------·---""-------"-----~-.. " -------·-·-·· ·-·-·~ -. 6178 Machine.ry & Equipment. Trailer to transport mini-excavator ••~s'• ••--•-••••h••H-~•--•-•••~••-•---~-----••»•••••-•• ... 7062 R_ -_Major Equi~ment ......... ................ . Total 5311.2213 Trailer -New ,, .-,~c••--w~ •••·• ,•,, " •-•••-•, •• _ _,~--""••• ••-•·•••o~•··•.---• 5311.2219 BHM -Park Walkway Reconstruction_ ... 6183 Accessibility ···--Additional funding-for BHM walkway ....... ----··--- reconstruction -Between Elvira Court and Bruce Handscomb Memorial Park (capital project 175,000 C10305.2213.01 2 ,,O(l") 504200 Capital Machine&Eqp (20,000) 408032 Trf fr Major Equip Res Res (20,000) 20,000 C10305.2109.01 504700 Capital Parks Z!J.Q~.~f .: f~~l.§E19. .... . ................. -.. -.-.. --... ·.--.·.~--===:~-~:·:~_·:.~:-~~ .... ·. --'(._5_0'--, 0_0_0.,_) _____ 4_0_85_0_1 ___ -+T_rf_f_r P_r_kl_nd_O_b....::lg::....R_s __ 1 Total 5311.2219 BHM -Park Walkway Reconsc.t0.r_u._c.·_~(5_0..,_,0_0_0"-') __ 5_0..._, 0_0_0 _____ ---1----------a Total Property Maintenance (580,000l 580,000 43 Roads Equipment Expenditures Capital Machine&Eqp Capital Machine&Eqp Total Expenditures Financing Trf fr RateStblz Res Tri fr VhcleRplc Res Tri fr Major Equip Res Res Tri fr DC-OthHwy ORF Total Financing City of Pickering 2022 Approved Capital Budget 44 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 315,000 120,000 40,000 355,000 120,000 (60,000) (75,000) (70,000) (180,000) (50,000) (40,000) (355,000) (120,000) City of Pickering 2022 Approved Capital Budget Roads Equipment Run Date: Apr 1 , 2022 Funding ' Expense SAPWBS SAP GL Account element/ SAP Description GL Account •······· --··· --·-·· ·-·-···-····· ·-·, --· .... ·-····-. ,_ H ,,_, -----•-•----· -•••-----~-- 5319.2202_ Road Asphalt Roller_ Replacement _______ , C10315.2202.01 .. 61_7~ Ma(2hin_~ry ~ gquipment fi 1 ,:1: 504200 Capital Machine&Eqp ·····•--<>-••----·"'··----. -___ , •.. ··-·-~--,.,-, ,~" __ Road Asphalt Roller-replaceunit #102_(2010) . I 7062 R -Major Equipment _______ I (50,000), 408032 Trf fr Major Equip Res Res -· ..... Total_ 5319.2202_ R_oad Asphalt R0Her .. Replaceme1 (50,000) 50,000 5319.2207_ LED Temporary S1gn Trailer -New{2) .... 1 C10315.2221.01 ..... 6178 Machinery & _Equtpment ·•-······--·-·················-··-··-···' 504200 Capital Machine&Eqp ...... Solarmessage _boards(2) ___ .. 7040 R -Vehicle Replacement ____________ (70,000) 408016 Trf fr VhcleRplc Res 1········ ,,. .. -.. ,, .... Total ___ 5319.2207 _LED Temporary Sign Trailer~ Ne (70,000) 70,000 Total Roads Eauioment (120,000) 120,000 45 Parks Expenditures Capital Parks Capital Machine&Eqp Other Fixed Assets Capital Accessibility Capital Consulting Capital Land Capital Parks Total Expenditures Financing Donations Federal Grants Property Tax Funded Trffr RateStblz Res Trf fr DC City's Res T rf fr VhcleRplc Res Trffr Fence Res Trf fr Tennis Res Trf fr Major Equip Res Res Trf fr 3rdPtyOblg RF Trf fr PrklndOblg Rs Trf fr FGT Oblg RF Trffr DC-P&R OB RF Trf fr Seaton FIA RF Total Financing Abbreviations City of Pickering 2022 Approved Capital Budget BRC RHM Brock Ridge Community Park Rick Hull Memorial Park 46 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 3,420,000 2,685,253 40,000 421,000 60,000 85,000 920,000 1,433,511 95,000 3,100,000 1,280,000 1,844,000 8,915,000 6,468,764 (10,000) (90,500) (25,000) (100,000) (100,000) (1,060,322) (1,635,000) (425,000) (40,000) (94,000) (60,000) (60,000) (90,000)' (135,000) (227,000) (40,000) (3,680,000) (1,857,942) (320,000) (150,000) (2,883,000) (2,222,900) (32,000) (46,100) (8,91 s;ooo) (6,468,764) City of Pickering 2022 Draft Capital Budget Projects Listing Parks Project Name 5780 Parks 5780.2201 Mitchell Park -Asphalt Pathways Reconstruction 5780.2202 Tractor Replacement 5780.2203 Electric Utility Vehicle -New 5780.2204 Vacuum Excavator with Trailer Replacement 5780.2205 Village Green -Seaton P-121 5780.2206 Beachfront Park -Master Plan -Detailed Design 5780.2207 Parks Property Line Fence Replacement 5780.2208 Valleyview Park -Playground Reconstruction 5780.2209 Accessible Playgrounds 5780.2210 Esplanade Park Improvements 5780.2211 St Mary Park -Running Track Resurfacing 5780.2212 Usman Green -Basketball Play Area 5780.2213 Skate Board Park Community Size 5780.2214 Canadian Green -Basketball Play Area 5780.2215 Enclosed Trailer Replacement (2) 5780.2216 David Farr Park Security Camera -New 5780.2217 Brockridge Park Security Camera -New 5780.2218 Beverly Morgan Park Security Camera -New 5780.2219 Neighbourhood Park -Seaton P-109 5780.2220 Kinsmen Park Security Camera -New 5780.2221 Beachfront Park Security Camera -New 5780.2222 Bay Ridges Kinsmen Park-Sandy Beach Tennis Court Resurfacing 5780.2223 BRC Park -Parking Lot Paving 5780.2224 RHM Park -Playground Replacement 5780.2225 Rouge Valley Park -Resurface & Line Paint Basketball Court 5780.2226 Centennial Park -Baseball Diamond Outfield Fence Replacement 5780.2227 Village Green -Seaton P-108 5780.2228 Village Green -Seaton P-110 47 Run Date: Jun 7, 2022 2022 Project Budget 150,000 120,000 30,000 95,000 452,300 500,000 60,000 120,000 1,451,264 170,500 400,000 40,000 850,000 45,000 64,000 20,000 20,000 20,000 637,900 20,000 20,000 135,000 120,000 125,000 12,000 25,000 289,900 266,700 Parks City of Pickering 2022 Draft Capital Budget Projects Listing Project Name 5780.2229 Village Green -Seaton P-111 5780.2231 Walk-Behind Stone & Debris Burier -New Total 48 Run Date: Jun 7, 2022 2022 Project Budget 197,200 12,000 6,468,764 City of Pickering 2022 Approved Capital Budget Parks Run Date: Apr 1 , 202 Funding Expense SAPWBS SAP GL Account element / SAP Description GL Account ,. ---•----· ...... ._ ___ -. ----•-,•~-·---·· ·--·-··-----··--·----·-·---------------------·· '"" ·-·-~". -·---.,_~--- Walk-Behind Stone & Debris Burier -New. Walk-; behind soil renovator. ·----. -------·------------·------·--· _7062 R-Major B]uipment ______ (12,000) 408032 Trf fr Major Equip Res Re ---------·-------- Total 5780.2231 Walk-Behind Stone & Debris Bm (12,000) i 12,000 ----------------------·--~---------·---------·-----·- Total Parks (6,468,764) I 6,468 764 53 Fleet Vehicles Expenditures Capital Vehicles Capital Vehicles Capital Vehicles Cap Information Tch Capital Machine&Eqp Cap Library Coll Mat Capital Vehicles Capital Vehicles Total Expenditures Financing Donations Federal Grants DebtFinancing-15Year Trf fr VhcleRplc Res Trf fr 3rdPtyOblg RF Trffr DC-ProtectORF Trf fr DC-TrnsprtORF Trffr DC-OthHwy ORF Trffr DC-Libr OB RF Total Financing City of Pickering 2022 Approved Capital Budget 70 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 555,000 764,500 915,000 1,305,000 984,000 25,000 216,000 25,000 125,000 200,000 680,000 1,845,000 3,949,500 (27,500) (10,000) (1,200,000) (1,392,000) (1,372,000) (1,375) (53,625) (200,000) (1,340,000) (198,000) (1,845,000) (3,949,500) City of Pickering 2022 Draft Capital Budget Projects Listing Fleet Vehicles Project Name 5990 Fleet Vehicles 5311.2210 3/4 Ton Pickup Truck with Slide in Salter and Plow-Replacement (2) 5311.2217 3/4 Ton Pickup Truck with Tow Package -New (4) 5315.2202 1 Ton Truck with Service Body-Replacement 5319.2201 4 Ton Dump Truck with Snow Plow & Wing -Replacement 5319.2205 4 Ton Dump Truck with Snow Plow & Wing -New 5319.2206 1/2 Ton Pickup Truck -New 5319.2208 5 Ton Dump Truck with Snow Plow & Wing -New 5319.2209 4 Ton Dump Truck with Snow Plow, Wing & Brine Tank -New (2) 5325.2208 Mid Size SUV -New 5340.2205 Upfit New Fire Rescue -New 5340.2209 Fire Pumper Rescue Replacement 5719.2202 Cargo Van Replacement 5719.2207 Midsize Utility Vans -New (2) 5719.2212 Midsize SUV -New 5744.2204 Enclosed Trailer-New 5780.2234 1 Ton Truck with Service Body Replacement Total 71 Run Date: Jun 7, 2022 2022 Project Budget 180,000 300,000 10,000 330,000 330,000 27,500 350,000 660,000 45,000 200,000 1,200,000 45,000 90,000 45,000 32,000 105,000 3,949,500 -.J N New or Replacement Replacement Replacement Replacement Replacement New New New New New New (Seaton) New New (Seaton) New New Additional Funds Additional Funds 2022 Approved Vehicle Acquisition List (New & Replacement) Description of Plans for Expected Vehicle Vehicle Requested Existing Vehicle: Costs Primary User being Year, Make, Unit# Replaced Carqo Van Rep lacement 2015 Chevrolet, #790 $45 ,000 Community Centres Sale 3/4 Ton Truck , Slide in Salter and Plow (2) 2015 Ford, #775 & 776 180,000 Property Maintenance Sale 4 Ton Dume Truck with Snow Plow & Wino 2013 International, #42 330,000 Roads Equipment Sale Fire Pumpe r Rescue 2005 Smeal Pumper, # 532 1,200 ,000 Fire Services Sale Mid Size SUV -New N/A 45 ,000 Street Liqhts & Siqnalization Midsize Utility Vans -New (2) N/A 90,000 Community Centres Midsize SUV -New N/A 4 5 ,000 Community Centres-Corporate Securi Enclosed Trailer -New N/A 32,000 Museum 3/4 Ton Truck with Tow Packaoe -New (4) N/A 300,000 Prooertv Ma intenance 4 Ton Dump Truck wth Snow Plow & W ing -New N/A 330 ,000 Roads Equipment 4 Ton Dump T ruck w it h Snow Plow , Winq & Brine Tank -Ne w (2 ) 660 ,000 Roads Equipment 5 Ton Dump Truck with Snow Plow & Wing -New N/A 350,000 Roads Equipment Upfit New Fire Rescue -Ne w N/A 200 ,000 Fi re Services 1/2 Ton Pickup Truck -New N/A 27,500 Roads Equipment Total of 19 Vehicles Subtotal $3,834,500 1 Ton Truck with Service Body (approved in 2021) $10 ,000 Operations Centre 1 Ton Truck w ith Service Body (approved in 2021) 105,000 Parks Subtotal $115,000 Grand Total $3,949 ,500 Vehicle Other Replacement Funding Reserve Source $45,000 $0 180,000 0 330 ,000 0 1,200 ,000 45 ,000 0 90,000 0 45 ,000 0 22,000 10,000 300,000 0 330 ,000 66 0,000 350 ,000 200 ,000 0 27,500 10 ,000 0 105,000 0 $1 ,372,000 $2,577,500 City of Pickering 2022 Approved Capital Budget Fleet Vehicles Run Date: Apr 1 , 2022 ! Funding I Expense SAPWBS SAPGL I element/ SAP Account ----,_._. ·--"•-·'"' -,_,.' ---_,, • -P••" ,,.., __ ,_._, ... -· :GL Account Description , ____ ---··----·--------· -,---~----------------------------··-·-------- ~~-tt.?~! q ~!~ . .IQ1_1_E!c~l:!P_!_r_lJ_~tY'-'!t~ ~,ti~~ _!1_1 __ §~!!~r and Plow-Replacement(~ c10305,2210.01 ___ 6157 Vehicles_-under $100,000 i ,. {{1(1 504300 Capital Vehicles --- Two 3/4 Ton Pickup Trucks with Slide in Salter and Plow -replace unit #775 & #776 (2015 Ford I ,.,-,----·--~---~---------~----------···---------i 7040 R -Vehicle Replacement _______ : (180,000) 408016 Trf fr VhcleRplc Res I -·---·-------~-"~·•------- __ ,Total.5311.2210,3/4 TonPickupTruck_with_Slide_i (180,000) 180,000 5311.2217 3/4 Ton Pickup Truck with Tow Package -New (4) C10305.2217.01 6157_Vehicles -under $100,0DO ---_ ! ,· DOC 504300 Capital Vehicles ,_ --- 3/4 Ton Pickup Truck with Tow Package -New (4) (5311 Property Maintenance) -·------·-· ------~---------·------ 7040 _R -Vehicle Replacement .. (300,000) 408016 Trf fr VhcleRplc Res .. ,··--···--·-··-··--·-···----------·--------- ._Total _ 5311.2217 3/4 Ton Pickup Tru_ckvvith Tow P (300,000) 300,000 5315:-2202 1_TQ11 Truck wit~ S~rvice Body-Repfacement C10300.2102.01 ---"-•-•------'--- ___ 6158 Vehicles -Over $100,000 ---------------------------: 'IC ·504300 Capital Vehicles Additional funding to purchase one 1 Ton Truck with Service Body -replace unit #208 (2010 Ford) (5315 Operations Centre). Vehicle purchase approved in 2021 Capital Budget (5315.2102) ---···--••'-••--~----·-~ .... ----.-----¥-----·-··-~----------·-----·····--"• ------··· -----,--·----... , ------ _ 7040 R-Vehicle_ReplacBment_ _____ ,, ___ ,. ___ , _ ... ,.. (10,000) '408016 Trf fr VhcleRplc Res __ Total_ 5315.2202_1 Ton_Truck with Service Body -· (10,000) 10,000 5319.22014 Ton DumpTruck wittl Snow Plow_& Wing_-_Replacement ________ C10315.2220.01 ___ 6158Vehicles __ -()ver_$1,00,000 ____ ---------------~---•---??Cl 1 504300 Capital Vehicles 4 Ton Dump Truck with Snow Plow -replace unit _____ #42_(2013 lntemational) (5319 Roads ___ -••-"T'•-·--·-·-·- 7040 R -\fehide f3epl_acef!1e_nt ,, .... ______ (330,000) 408016 Trf fr VhcleRplc Res ., ""---~-•------ __ Total __ 5319.22014 Ton __ Dump Truckwith Snow Pit (330,000) 330,000 5319.229?_4 Ton Dump Truck with Snow Plow & Wing -New C10315.2205.01 __ 6458 __ Ve_~ icl~s -~ 0,\/~r ~ H:l0, Q_00 .::_§ea,!9~--________ ------~-._'.'.:V. 504300 Capital Vehicles 4 Ton Dump Truck with Snow Plow & Wing -New _ __ {Grc::i_wt_h).(5319 Roads_Equipment). ·-~----~---••,-- __7615 __ RF DC_-Other Services _Related to a Highway (330,000) 408603 Trf fr DC-0th Hwy Of _ Total 5319.2205_4 Ton_Dump Truck with Snow Pit (330,000) 330,000 . 5319.2206 1/2 Ton Pickup Truck_ -New....... .. .. __ -------------(10315.2206.01 1592 Donations (27,500) 406500 Donations ----------··•-· ______ _, __ .,. .. -~-----·---···---· ----·--·------····- _____ 6rn7 Vehicles_-under $100,000 ___________________________ 504300 Capital Vehicles 1/2 Ton pickup Truck for New Utility Cut Inspector _ Funded by Bell Canada over a 2 year period starting in 2022 (5319 Roads Equipment) --------·-·-----------·----~------·---~-,---·-----·-·--'"' ·--------- ___ Total _5319.2206_ 1/2_Ton Pickup Truck -_New ·--··-~-(27,500) 27,500 5319.2208 5 Ton_Dum~Truck with Snow Plow& Wing -New C10315.2222.01 6458 Vehicles_ -_Over $1_00,000 ~ Seaton _. __ --·--i ,-:::_c::c,, (;l)(i 504300 Capital Vehicles 5 Ton Dump Truck with Snow Plow & Wing (5319 Roads Equipment) I•••-~--·-·•-----~~-~--H•••"-,S •---•~ • -"-•-•-~---• •-rn•••••••••~••--•••<•••• __7615_RF DC-Other ServicesRelated to a Highway __ -(350,000) 408603 Trf fr DC-0th Hwy Of Total 5319.2208 5 Ton Dumo Truck with Snow Pie' (350,000) 350,000 74 City of Pickering 2022 Approved Capital Budget Fleet Vehicles Run Date: Apr 1 , 2022 Funding Expense SAPWBS SAPGL I element/ SAP Account GL Account Description ,_,_, •' ,-,--.. ~-·-· . ---_____ ,. _____ ,_,, ..... ,,,.-'--___ , ... ,_ ---------------------------~ _,, ___________ ------------ 5319.2209 4 Ton_Dump Truck W!th Sn,ow Plow1 Wing& Brine.Tank-N~w(2) __ C10315.2223.01 ,,_ 6158 Vehicles -Over $100,000 _________________ _ ___ ,)('Ji': ,504300 Capital Vehicles 4 Ton Dump Truck with Snow Plow, Wing & Brine I~r:!~ __ (2) (Growth) {5~19 Roads Equipment),:, __ ' 7615 RF _DC -Other Services _Related to a Hjg_byvay (660,000), ,408603 Trf fr DC-0th Hwy Of ,.,,.Tota! 5319.2209 4 Ton Dump Truck with Sno""_PI• (660,000) 660,000 5325.2208 Mid Size SUV -New • C10520.2208.01 ------------------·--·----- 6157 Vehicles -under $100,000 _,_ L! 504300 Capital Vehicles '"" .,, .... ______ ,_ __ ~------.. ----~---- Mid Size SUV New -(5325 Street Lights and .... ,., Signalization) ____ ---- _ _7040 R -Vehicle_ Replacement _______ (45,000), 408016 Trf fr VhcleRplc Res Total 5325.2208 Mid Size SUV -New (45,000) 45,000 -·---------~--------------------··--------------------------------------- 5340.2205_Upfit_New Fire Rescue -New_ 1 C10700.2205.01 _ 6158,Vehicles -qver $1_00, 000 __ , ___ -·-__ . ___ -·-· 504300 Capital Vehicles To upfit replacement for unit #540 purchased in __ -· 2021(5340.Fire Services) ___ '"'""'~---.-~,-~------··· ,-7040 R -Vehicle Replacement (200,000) 408016 Trf fr VhcleRplc Res -------------------·--•-.------ Total 5340.2205 Upfit New Fire Rescue -N~'N (200,000) 200,000 5340~2209 ,,Fire_ PumJ>er. Rescue Replacement_ ,, . (10700.2209.01 " 1703 Debt -15 Year (1,200,000) 406703 DebtFinancing-15Ye ---···--------··-~----··-·-----·-··----------···-~ ---------------· _ 6159 Fire Veh_ -_Over $100,000 ~-' ~; 1,00:: 504300 Capital Vehicles ----------- Pumper Rescue -Replace unit# 532 (2005 ____ Smeal_f:_!JmP~!) (5340 Fire_Services). ____ _ __ ,, ___ 6178 Machinery & Equtpment _ ·-I 216,000 504200 Capital Machine&Ec 1-----------~--______ , -----------" __ Total_ 5340.2209 Fire Pumper _Rescue Replaceme1 (1,200,000) 1,200,000 5719.2202 C~rgo Van Replacement .... I C10220.2202.01 ' 6157 Vehicles-under ~1.00,000,,, ____ , ,,. ,(f,O,'IC 504300 Capital Vehicles , .. Cargo Van -replace unit #790 (2015 Chevrolet) _ (5719 Community Cemtres). __ ,, J040_R_-Vehicle Replacement (45,000) 408016 Trf fr VhcleRplc Res --··- ___ Total 5719.2202 Carg9 v~m_RepJacement_ (45,000) 45,000 5719.2207 Midsize Utilitf Vans -. New J2)__ ___ . C10220.2207.01 "~__, ___ .-__,_. .. 6157 Vehicles -under $100,000 . Rf 504300 Capital Vehicles Midsize Utility Vans for increased cleaning of ' __ _facilities_(5719 Community Centres} ___ ., __ ,, ___ __ 7040_ R -Vehicle RePLacement_ (90,000) 408016 Trf fr VhcleRplc Res Total 5719.2207 .. Midsize Utilityyans -New J2) . _.,. (90,000) 90,000 5719.2212 Midsize SUV -New I C10220.2212.01 ·----------------------------···-------•'"·-·---------------·-------------· ·-. -·-·-···-·------- _ 6157 Vehicles -under$1_00,000 _________ L]~ r)nr .504300 Capital Vehicles Midsize SUV for Corporate Security Specialist """"" (Operations): -------------· -----------------·•-•·-----------··---- __ 7040 __ R -Vehicle ~ep)acement .... -··-___ ,,_ ' (45,000) .408016 Trf fr VhcleRplc Res ------~ Total 5719.2212 Midsize SUV -New (45,000) 45,000 ----------------.----·--··-------------------------"·-----·----------" ---·•·•-T"·•- 57 44.2204 Enclosed Trailer -New C10250.2204.01 _____ ,_ ________ -~ ---------~-------~------------------. ---------------------· ' 161 O Federal Grants {10,000), ,402500 Federal Grants "' Museums Assistant Proa ram (MAP) qrant lb City of Pickering 2022 Approved Capital Budget Fleet Vehicles Run Date: Apr 1 , 2022 Funding Expense SAPWBS SAPGL element/ SAP Account GL Account Description . ·" "··---· -•"-•--•---'. . . ''" .. .-...... ... -, .. , ·-~-----·-------------------------- 615?Vehicles -under.$1_00,000 .... "~!.;)QC ,504300 Capital Vehicles <. .. ••••·•~••-•••••••-•-•n• For Moving Art Show -New (Museum 5744). Acquisition of trailer is subject to receiving ·-••»--• .. M~seu_ms Assistant Prag ram(MAP) grant -•-u--• ..... 7040 R -Vehicle RepJacement ______ (22,000) 408016 Trf fr VhcleRplc Res Total 5744.2204 Enclosed Trailer -New "'••••••----.-~-••-•-••~•••--•-• _ _,_ •••-.-•-••••••-••••••••-••••~ .. ,.••""•'"" •• -•••-••-• • ••-••••••• """" ••-••••• ••-•••~ (32,000) 32,000 5780.22341. Ton Truck wJthService Body_Replacement . C10320.2115.01 _ 6158 Vehicles -Over $)00,000 _ ··---·----···---·-... ·i(J .. ooc 504300 Capital Vehicles Additional funding to purchase one 1 Ton Truck with Service Body-replace unit #795 (2014 Ford F450) (5780 Parks). Vehicle purchase approved in 2021 Capital Budget (5780.2115) ----------------~-------------~"-~-------_____________ ,. _______ -------------------- (105,000) 7040 R -Vehicle R~pJacement 408016 Trf fr VhcleRplc Res ____ ,. _________ -----------------· Total 578.0.2234_1 .. Te>11_,Trucl<.with ~~!'Vice Body_R (105,000) 105,000 Total Fleet Vehicles (3,949,500) 3 949 500 76 City of Pickering 2022 Approved Capital Budget Corporate Services Dept. Summary Expenditures Cap Information Tch Cap Information Tch Cap Information Tch Capital Consulting Capital Construction Cap Information Tch Capital Buildings Total Expenditures Financing Ontario Grants DC-DebtFinancing-15YR Trf fr Rplc-Cap Res Trffr RateStblz Res Trf fr DC City's Res Trf fr DC-ProtectORF Trf fr Animal Sit RF Trf fr Seaton FIA RF Total Financing 77 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 75,000 184,600 269,000 310,000 909,000 200,000 40,000 8,830,000 1,333,600 9,484,000 (48,000) (6,004,000) (384,600) (331,000) (275,000) (1,626,000) (656,600) (291,400) (1,200,000) (1,000) (1,333,600) (9,484,000) Information Technology Expenditures Cap Information Tch Cap Information Tch Capital Construction Cap Information Tch Total Expenditures Financing Ontario Grants Trf fr Rplc-Cap Res Trf fr RateStblz Res Trf fr DC-ProtectORF Trf fr Seaton FIA RF Total Financing City of Pickering 2022 Approved Capital Budget 78 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 184,600 269,000 310,000 200,000 40,000 424,600 579,000 (48,000) (384,600) (331,000) (200,000) (39,000) (1,000) (424,600) (579,000) Information Technology 5206 Information Technology City of Pickering 2022 Draft Capital Budget Projects Listing Project Name 5206.2201 Server Infrastructure Replacement 5206.2202 5 Yr PC Upgrades 5206.2203 Internet Services Technologies 5206.2204 Telecommunications Services Technologies 5206.2205 Council Chambers Audio Visual Upgrade 5206.2206 Server & Related Software Total 79 Run Date: Jun 7, 2022 2022 Project Budget 163,000 58,000 64,000 46,000 200,000 48,000 579,000 By-Law Services Expenditures Cap Information Tch Total Expenditures Financing Trf fr RateStblz Res Total Financing City of Pickering 2022 Approved Capital Budget 81 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 75,000 75,000 (75,000) (75,000) City of Pickering 2022 Approved Capital Budget By-Law Services Run Date: Apr 1 , 2022 Funding Expense SAPWBS SAP GL Account element / SAP Description GL Account ,, ,. ___ . ----- -·--__ .__J _______ ,., ~ -' --•-•~•--·• .. ···--~·-•--. ----- ··-· ----------·--·----------------------------____ , _,_,,_~ --------•••n••-•••••• -------·--·-- 5220,?201_Par~kingPermit.Hardware. & Software (10425.2201.01 _6174 System_& Software U~grade_ ' 504800 Cap Information Tch . ·•--"· To implement waterfront permit parking for both on-street and City parking lot locations. ""•---------------·--• ----•-•--•••-•••-••m• •-••••• --------- 7021 R -Rate Stabilization (75,000) 408007 Trf fr RateStblz Res --------·--·--' ------------ Total 5220.2201 Parking Permit_ Hardware & Soft\ (75,000) 75,000 Total By-Law Services (75,000) 75,000 82 Animal Services Expenditures Capital Consulting Capital Buildings Total Expenditures Financing DC-DebtFinancing-15YR Trf fr DC City's Res T rf fr DC-ProtectORF Trf fr Animal Sit RF Total Financing City of Pickering 2022 Approved Capital Budget 83 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 909,000 8,830,000 909,000 8,830,000 (6,004,000) (1,626,000) (617,600) (291 .400) (1,200,000) (909,000) (8,830,000) City of Pickering 2022 Approved Capital Budget Animal Services Run Date: Apr 1 , 2022 Funding : Expense SAPWBS SAP GL Account element/ Description I SAPGL ----------· ---,---------·--· ---·-------·--·· ... •·--_,, _____ ----· ···--, .... _, ______ ___ ,_ _______ .... ________ ., _________ ------------------··" 5219.2201 Animal Shelter -Construction C10430.2101.01 -------~-·--~--------·-----·-------------~---.------------. ___ 1708 DC Debt -15 Year (Protective_ Services) (6,004,000): 406743 DC-DebtFinancing-lSYR __ 6500 Building Related ______________________________________ 504100 Capital Buildings Construction of new animal shelter building ---···------·-·-·-------. ., . ., _______ ... ---.·-···----------------·-------·-------- ___ Z022 R -IJC's City's Share (1,626,000) I 408008 Trf fr DC City's Res ------·----·------· ------------ 7706 RF -Animal Shelter (1,200,000), 408703 Trf fr Animal Sit RF -------------------~-------------- Total 5219.2201 Animal Shelter -Construction (8,830,000) 8,830,000 "" ---·--·----·---------~-~-----------•-"•• ---····--"•"•"•--•···-·----·--•·-'"-·-~--·-~·-·· --'----------·-·--- Total Animal Services (8,830,000) 8,830,000 84 City of Pickering 2022 Approved Capital Budget Engineering Services Dept. Summary Expenditures Capital Consulting Capital Construction Capital Roads Capital Streetlights Capital Storm System Cap Traffic Signals Capital Sidewalks Capital Land Capital Buildings Total Expenditures Financing Ontario Grants Internal Loan-2 year Property Tax Funded Trf fr RateStblz Res Trf fr DC City's Res Trf fr Major Equip Res Res Trf fr 3rdPtyOblg RF Trf fr FGT Oblg RF Trf fr DC-TrnsprtORF Trf fr DC-SWM OB RF Trffr Rds&Bridgs RF Trffr SWM RF Trf fr OCIF Grant Total Financing 85 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 450,000 855,030 200,000 200,000 5,805,000 15,505,570 477,300 2,059,000 599,500 58,000 200,000 500,000 15,000,000 310,000 22,254,500 19,964,900 (169,838) (124,895) (2,175,000) (59,100) (46,000) (2,310,205) (5,741,375) (160,000) (6,200,000) (397,500) (2,685,000) (3,740,995) (6,825,000) (8,326,525) (311,500) (790,000) (106,110) (1,170,000) (880,357) (22,254,500) (19,964,900) Streetlights & Signalization Expenditures Cap Traffic Signals Total Expenditures Financing Ontario Grants Property Tax Funded Trf fr RateStblz Res Trf fr Major Equip Res Res Trf fr FGT Oblg RF Total Financing City of Pickering 2022 Approved Capital Budget 86 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 599,500 58,000 599,500 58,000 (169,838) (59,100) (46,000) (190,562) (160,000) (20,000) (12,000) (599,500) (58,000) City of Pickering 2022 Approved Capital Budget Streetlights & Signalization Run Date: Apr 1 , 2022 Funding Expense SAPWBS SAP GL Account element / SAP Description ' :GL Account ·-·-·" ., ....... ·-·•-" ' ---------·""" «----------------------.-.. -_________ _, -------.---------------------·····----.. -- ' 5325.2201 Traffic Signals/Controllers Replacement. • C10520.2201.01 . _ 2823 Paid from _ _Property Taxes (23,000)1 408900 Property Tax Funded 6254 Traffic Signals _________ . _,. . 23,0l::1 '504450 Cap Traffic Signals ---•-····--"·=-·••o'•-·-··-- Traffic Signals/Controllers Replacement -Dixie _______ Road at Glenanna Road (last replacement __ 2009) __ ' , _Total 5325.2201_ Traffic S1gnals/Controllers Repla (23,000)' 23,000 1 5325.2202 Traffic SLgnals/9ontrollers Replacement C10520.2202.01 ___ 2823 Paid from Property Taxes-·-···--·-· ... _______ (23,000). 408900 Property Tax Funded ... 6254 Traffic_ Sig}lals -·· ··--. ..• ,om •504450 Cap Traffic Signals . ·-·---·····-.. · -·-·--------------- Traffic Signals/Controllers Replacement-Bayly ___ Street at St. Martins Drive (original_install2009) ... ____ Total __ 5325.2202 Traffic Signals/Controllers Repla (23,000): 23,000 ~3?.~2?_0-1:J::·ED Sig_i:!<ll _He~d R.~place111(m_tPr9grarn. · C10520.2102.01 __ 6254 Traffic_Signals ------------•···--·-- , ·j 2,cln( -504450 Cap Traffic Signals Additional funding for replacement of LED signal ·······-__ heads(capital_project_C10520.2102L .. , ---~-... _ .. _________ 7505 RF -Federal Gas Tax (12,000)i ;408502 Trf fr FGT Oblg RF -------.-···•-"'""'"-• ~_.------·-------------~-.. --.. -------.. •-·"··-···-~----.-------------- .. _Total_ 5325.2204 LED Signal Head Replacement P (12,000)' 12,000 Total Streetlights & Signalization (58,000) 58,000 87 Sidewalks Expenditures Capital Sidewalks Total Expenditures Financing Trffr FGT Oblg RF Total Financing - City of Pickering 2022 Approved Capital Budget 89 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 200,000 500,000 200,000 500,000 (200,000) (500,000) (200,000) (500,000) City of Pickering 2022 Approved Capital Budget Sidewalks Run Date: Apr 1 , 2022 Funding Expense SAPWBS SAP GL element / SAP Account GL Account Description ,,,,, .,, -• , ... --••-·---- ,_ _____ , __ ···--.------------•••--• • ••---•--~--•m••---•-• ·-·--~-----·-•·'s-••·---------------------·-· - 5323.2201 West Shore Boulev~rd Asphalt Sidewalk Construction C10515.2201.01 6255 Sidewalks 2no,:-ir,1 504600 Capital Sidewalks ---· ~--------~ ~--·--·-----------•-~----·--·-----------------------·~·----·----- West Shore Boulevard New Construction -East side from Beachpoint Promenade to Sunrise --•---·-••·A -•~--•·-.-•·•---•·•·•···-•-·••-••-••-·•---••-•~---•·•~---------·--------·-------------·-- 7505 RF -Federal Gas Tax (200,000) 408502 Trf fr FGT Oblg RF -·-----•--~-~---•--•---••-. -••·····"'"··"·" ......... _.~ .... ,., •---•·····--...,-.......... , .. ~.~ ••• •••' •n~••• ~••"•" .-, ., __ --··---~---- Total 5323.2201 West Shore Boulevard Asphalt Si (200,000) 200,000 5323.2202 Pickering Parkway_-_Multi-use Path Reconstruction C10515.2202.01 6255 Sidewalks C -'!f<-, 504600 Capital Sidewalks ,.,··1 ' --------··----· ____ , _______ Pickering Parkway multi-use path reconstruction. North side from east of Glenanna Road to Hydro Corridor. -~~ -~~~-----·------~---•~--_,_, ___ J,, _,_ -~----~----------~ --· _,,,_,_ -· ----~·~ ------ 7505 RF -Federal Gas Tax (300,000) 408502 Trf fr FGT Oblg RF -.. ------·•-•> ,, ______ -------....... ------------~------ __ Total .5323.2202Pickering_Parkway --Multi-use_Pa (300,000) 300,000 Total Sidewalks (500,000) 500,000 90 Stormwater Management Expenditures Capital Storm System Capital Buildings Total Expenditures Financing Trffr SWM RF Total Financing City of Pickering 2022 Approved Capital Budget 93 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 860,000. 310,000 1,170,000 (1,170,000) (1,170,000) City of Pickering 2022 Approved Capital Budget Stormwater Management Run Date: Apr 1 , 2022 Funding Expense SAPWBS SAP GL Account element / SAP Description GL Account -··•·-"' ---~•···--• ···-··-·--·-··-·--·-·--····-----·------·--····~ ·--· -------... ···---·-·-----.--- 5410.2201 Usgoold SWMPond_(C2-08-GC)_Retrofit_ Cl0525.2203.01 6253 Storm Water ·504550 Capital Storm System ----·--·---~-----~-----~---------------·· Lisgoold SWM Pond on Meriadoc Dr. north of Dellbrook Ave -SWM Pond retrofit as per SWM Facility Asset Management Plan •.•• -~~«-• ~--~-~--~--------------~ _____ ., 771 0 RF -Stormwater Mgmt (860,000) 408707 Trffr SWM RF -------------------·---------·-..... _," ~ ... Total_5410.2201_LisgooldSWM Pond{C2-08-GC) (860,000) 860,000 5410.2202 Fairview Avenue -Reconstruction C10525.1901.01 ••·-.oo-u.,-rnH.~ • •••r•••, ~. -. ••••-•-•-~••-~-• ••-• .,--•••< --~ ___ .,,.., u"••••••" "•"•""•• __ ,_ ....... ,-~,-_.,, ... ..... 6500 Building_Related_ ·-···-· ":' . ; ~ 504100 Capital Buildings \..' '. -·-----•-··"·---------------- Additional funding for Fairview Avenue Reconstruction from Browning Avenue to South Terminus. Design and construction of a storm sewer and road reconstruction (capital project C10525.1901 ·-···-····-··· -----~·-----······-·•""""•·-·-----------·•"" ------------ 7710 RF -Stormwater Mgmt '"•+'•-~•-~--•-"'""~ -••••-•----'"¥ «•••-•---~-• ._,,,,.,,. .. ••••-~o~~'"'"""·-••-•• -~-•--••r,-........... ••--- (310,000) 408707 Trffr SWM RF (310,000) Total 5410.2202 Fairview Avenue -Reconstructio 310,000 ·-+•--••---•-•••--•••-•--~--H•-••H•• -"-~------·--·-· ---------- Total Stormwater ManaQement (1,170,000) 1,170,000 . 94 Roads Projects Expenditures Capital Consulting Capital Roads Total Expenditures Financing Ontario Grants Trf fr RateStblz Res Trf fr DC City's Res Trf fr 3rdPtyOblg RF Trf fr FGT Oblg RF Trffr DC-TrnsprtORF Trf fr Rds&Bridgs RF Trf fr OCIF Grant Total Financing City of Pickering 2022 Approved Capital Budget 97 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 450,000 200,000 5,805,000 4,265,300 6,255,000 4,465,300 (124,895) (2,119,643) (305,150) (197,500) (2,465,000) (3,228,995) (502,650) (790,000) (106,110) (880,357) (6,255,000) (4,465,300) City of Pickering 2022 Draft Capital Budget Projects Listing Roads Projects Project Name 5320 Roads Projects 5320.2201 Hoover Bridge -Assessment and Design 5320.2207 Scarborough/Pickering Townline Rd. -Road Reconstruction 5320.2208 Granite Court -Asphalt Resurfacing 5320.2209 Fieldlight Boulevard -Asphalt Resurfacing 5320.2210 Shadybrook Drive -Asphalt Resurfacing 5320.2211 Bainbridge Drive -Asphalt Resurfacing 5320.2212 Pickering Parkway-Asphalt Resurfacing· 5320.2213 Parkside Drive -Asphalt Resurfacing 5320.2214 Rawlings Drive -Asphalt Resurfacing 5320.2215 Chipmunk Street-Road Base and Asphalt Repair 5320.2216 Grenoble Boulevard -Road Base and Asphalt Repair 5320.2217 Haller Avenue -Road Base and Asphalt Repair 5320.2218 Lublin Avenue -Asphalt Resurfacing 5320.2219 Rosefield Road -Asphalt Resurfacing Total 98 Run Date: Jun 7, 2022 2022 Project Budget 200,000 1,005,300 220,000 150,000 475,000 295,000 450,000 140,000 400,000 140,000 170,000 200,000 350,000 270,000 4,465,300 City of Pickering 2022 Approved Capital Budget Roads Projects Run Date: Apr 1 , 2022 Funding Expense SAPWBS SAPGL element/ SAP Account GL Account Description -·-____ ,,. __ . ~~ ___ ,_., ---~ ---• ------------" --------·---·--------------------·---· 5320.2201 Hoover Bridge -Ass_essment and Design C10570.2201.01 · 1623 Prov Grant · · · 1 i 402510 Ontario Grants , •... Transit & Infrastructure (Tl) Grant -~-·-,Y•Y.•- .. 6230 Prof/Consulting Fees ::io,.ooo 504001 Capital Consulting C •-••----~•• • ___ , ____ ... ,.~--- Hoover Bridge (Internal ID 7004) -Located on Sideline 34, south of Eighth concession Road, over Reesor Creek. The proposed works include ! assessment of options to either rehabilitate or replace the existing bridge, or to create an alternate means of access to Sideline 34 properties. Scope includes associated design .. ·-·· work and approvals/permits. .. 7709_RF-Roads_&_Bridges_ (106,110) 408706 Trf fr Rds&Bridgs RF , ________ Total 5320.2201 Hoover_ Bridge -Assessment anc (200,000) 200,000 5320.2207 Scarborough/Pickering_Townline. Rd._ -_Road Reconstruction C10570.2207 .01 6251_ f3oad _Improvements ____ ........ ·1,e,Y .. ::-mo 504400 Capital Roads , .. . . , .. -~--~--·-···· Scarborough/Pickering Townline Road Reconstruction -Finch Ave. to CPR Crossing - RP-14 ·-------------···-------~-----------------------------------·- _ 7022 R -. DC's City's Share___ _ __ .... _ ... .... .. ... (305,150), 408008 Trf fr DC City's Res ... .... 7501_ RF -Third Party ContributLon . (197,500) 408200 Trf fr 3rdPtyOblg RF ... .. 7610 RF DC -Transportation_ Services_ .. ______ (502,650), 408602 Trf fr DC-TrnsprtORI Total 5320.2207_§._carborough/PickeringTownline (1,005,300) 1,005,300 5320.2208_Granite Court -Asphalt Resurfacing ...... C10570.2208.01 .. 6251 __ R,oad lmp;ovements ........ ., ,00( 504400 Capital Roads --·---------.-- Granite Court -Asphalt Resurfacing -Ironstone Manor to Whites Road (RR#38) -----------~---------------·-·-------~---··· 7505 RF -Federal Gas Tax (220,000) 1 408502 Trf fr FGT Oblg RF ......... •---··--·· "'--~-•--~---······---·-· ---·-······-···--·-· - ... Total 5320.~208 Granite Cour1: -Asphal! .Resurfac (220,000)· 220,000 5320.2209 _Fieldlight Boulevard_-Asphalt Resurfacing C10570.2209.01 -·--·-----~-- __ 6251_ Road Improvements ___________________ ..... 1 Fi(',0(,,-504400 Capital Roads Field light Boulevard -Asphalt Resurfacing - Glenview Road to Valley Farm Road I••-•-•••-••••--••••<•,-~,-~· •-••m• • -, .... ,c.,-••••••--•••-;,••,;~••--»-•••'"'••ho»,-... _,.s< •·-•~-·-----~ 7505 RF -Federal Gas Tax (150,000) 408502 Trf fr FGT Oblg RF -~-· -·-·--··------------------- __ Total_5320.2209_Fi~ldlight8oulevard -Asphalt RE (150,000) 150,000 !>320.221 0_ S_hadybro_ok Drive -Aspha~t ~esurfa2ing ' C10570.2210.01 6251 Road Improvements __ . -~-----··-_ " 7fi, )()(' 504400 Capital Roads .. Shadybrook Drive -Asphalt Resurfacing - Shadybrook Tot Lot (east end) to Spruce Hill 7505 RF -Federal Gas Tax (475,000) 408502 Trf fr FGT Oblg RF . Total 5320.2210 Shady):>rook_Drive -As~halt_Res1 (475,000) 475,000 5320.2211_ Bainbridge Drive -Asph_alt Resurfacing _ C10570.2211.01 6251 Roa<i Improvements 205,000 504400 Capital Roads ~---.. ----------" .. ~--~---_____ .s_, ____ Bainbridge Drive -Asphalt Resurfacing - Kingston Road (Hwy #2) to 370m south of 99 City of Pickering 2022 Approved Capital Budget Roads Projects Run Date: Apr 1 , 2022 Funding Expense '.SAPWBS SAPGL ! element / SAP Account _., •.. ~-' ----··•·-••-·-····· ·······--·~ ·" . .., .... ,,_. __ . : GL Account Description '······-····•-'--• , .... -----•----·•- Lublin Avenue -Asphalt Resurfacing -Parkham .... crescent to Alyssum Street·········-· ..... ··-··-·· i .. . .. 7505 RF -Federal Gas Tax : (350,000), ·408502 Trf fr FGT Oblg RF ----·--·---------- . _Total _5320.221_8 .. LubHn_Averrne_-_Asphalt Resurfa,' (350,000) 350,000 §320.2219 Rosefield Roa~ . .:--~~eti~JtR-~~'-:IXf~~ii:ig_ .. (10570.2219.01 ..... 6251Hoad_lmprovements _____ 27(:,00( ·504400 Capital Roads -----,•---•-~-•---•-·--···------···----·· .. ·-- Rosefield Road -Asphalt Resurfacing -Glenview ····-· Road to Fieldlight __ Boulevard ____ ----· --~ 7505 RF -Federal Gas Tax (270,000), 408502 Trf fr FGT Oblg RF ~---------------·---~-------··-------·-·------.s••-- ..... T.c:>t~I_ §~~C>:,??t~Rg_s~fi~I,~ ,R<:>c!~(-:f\.!:;pl}~I! RC3~llrf, (270,000) 270,000 Total Roads Projects : (4,465,300)' 4 465,300 101 City of Pickering 2022 Approved Capital Budget Water Resources & Development Services Expenditures Capital Construction Total Expenditures Financing Trf fr 3rdPtyOblg RF Total Financing 116 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 200,000 200,000 200,000 200,000 (200,000) (200,000) (200,000) (200,000) City of Pickering 2022 Approved Capital Budget Water Resources & Development Services Run Dale: Apr 1 , 2022 Funding Expense SAPWBS SAP GL Account element / SAP Description GL Account ···--"' ----·--_,_ '-· --·· ~ -'-·•---- ~•'"" •-~••••«••---•--,•• ••• , -------------------------·•--•-• ---· -•• + ......... _. '>••·----- 5613.22_Q1 _Var!ous Construction_~rojects_ C10510.2201.0l - 6250 Construction Costs 2,y 504500 Capital Construction -----·--.,-----··--------__ , ______ ,, __ --~------------------- Various Construction Projects Related to , _______ DeyelopmE?nt_ (funde9 _ fro_rn Third party _ ___ _ _ __ .Z9-9LBE -Third l:~1:ty_(29ntribution ··-------"'-~--------------(200,000) 408200 Trf fr 3rdPtyOblg RF __ Total __ 5613.2201 Various Construction Projects_ (200,000) 200,000 Total Water Resources & Development Services (200,000) 200,000 117 City of Pickering 2022 Approved Capital Budget Development Projects-(DC Funded) Expenditures Capital Consulting Capital Roads Capital Streetlights Capital Storm System Capital Land Total Expenditures Financing Internal Loan-2 year Trf fr DC City's Res Trf fr 3rdPty0blg RF Trf fr DC-TrnsprtORF Trf fr DC-SWM OB RF Total Financing 118 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 655,030 11,240,270 477,300 1,199,000 15,000,000 15,000,000 13,571,600 (2,175,000) {5,436,225) (6,000,000) {6,825,000) {7,823,875) (311,500) (15,000,000) (13,571,600) City of Pickering 2022 Draft Capital Budget Projects Listing Development Projects-(DC Funded) Project Name 5321 Development Projects-(DC Funded) 5321.2201 RP-5 Finch Ave -Rosebank Road to 500m West 5321.2202 RP-6 Finch Ave -Altona Road to Rosebank Road 5321.2203 Installation of Oil Grit Separators 5321.2204 8-29 Sandy Beach Rd. -Reconstruction Phase 2 5321.2205 TC-6 Valley Farm Road (East Side) 5321.2206 New East/West Local Road -Delta Boulevard Run Date: Jun 7, 2022 2022 Project Budget 289,900 125,000 349,000 5,220,000 62,400 125,000 5321.2207 Walnut Lane Extension -Design & Construction 6,550,300 5321.2208 Breezy Drive/Sunrise Avenue Storm Sewer Outfall Reconstruction and Oil Grit Separato 850,000 ------ Total 13,571,600 11 9 City of Pickering 2022 Approved Capital Budget Development Projects-(DC Funded) Run Date: Apr 1 , 2022 Funding I Expense SAP WBS SAP GL Account element/ SAP Description GL Account 5321,.2~01 RP-5 Finch .Ave.: .Rosebank Road to 500m West C10575.2201.01 .. 6252 Streetlights.& Sidewalks·----------· __________ _ 2,}?,9(! ,504620 Capital Streetlights RP-5 Finch Avenue North Side Rosebank Road to 500m west -------·---·----~-------J 022 R .-DC' s C iti s. Share ..... .. ........... (144,950) 408008 Trf fr DC City's Res _ 7610. RF DC_-Transportation.Services... . ......................... __ ..,__(1_4_4_,_,9_5_0"'-'-) __________ 1---___ .,___--1 408602 Trf fr Dc .. rrnsprtORF 289,900 Total 5321.2201 RP.~inch Ave _:B<>sebank Roa_c __ ..,__(2_8_9.,_,9_0_0._)' __ -'--------1----------1 5321.2202 RP-6 Finch Ave -Altona Road.toRosebank Roc1_~-----C10575.2202.01 .... 6252Streetlights & Sidewalks_ .. . ... ·j .. O(· 504620 Capital Streetlights RP-6 Finch Avenue South Side Altona Road to Rosebank Road ~---~----·----~-·-------~--····-·-·~----------~ -· 7022_ R -DC's _City's Share. ___ .. ____ .... __ _ ........... (62,500) 408008 Trf fr DC City's Res .... 761.Q_RF Dg. -Tra_11sportation Services_ .......................... _ __,(_62~''-5_0~0)'-'-. •----------+-----'------1 408602 Trf fr Dc .. rrnsprtORF 125,000 __ Total 5321.2202.RP-G_Finch Ave.-Altona Road t .. o:.. _ _,(._1_25_,,_0_00_,_1) __ __,_.:...:...: ______ +-------1 5321.2203 Installation of Oil Grit. Separators ................. . C10575.2203.01 6253 Storm Water 34Si 1 (11·i:· 504550 Capital Storm System ._ ... _ ......... . Installation of Oil Grit Separators (25/75) Frenchman's Bay ... 7022 R -PC's City's Share ·-··•·-_ (250,000), 408008 Trf fr DC City's Res 408604 Trf fr DC .. SWM OB RF 349,000 7611 RF DC -Storm Water Mgmt (99,000) :·Total 5321.2203 Installation of off<irit Sepilrators--(-'3-49-'.'-o-oo-',)'-------------+--------l C10575.1609.01 504400 Capital Roads 5321.2204 B-29 Sandy Beach Rd. -Reconstruction Phase 2 _ 6251. Road lmpmvem.ents .. ~-------. ------·----·~- Additional funding for Sandy Beach Road reconstruction and storm sewer installation - Bayly Street to Montgomery Park Road (50/50). Multi-year project. Phase 2 (capital project , . __ C10575.1609/1904) _... . ........ ________ .... _ 7022 R -DC's City's Shcire ····-·· (2,610,000) 408008 Trf fr DC City's Res . _J61 0 RF pc _-Transportation .. Services. _ .. .. ... . .. . _ ___,(_2,_,6_1_0,_, 0_0_0'-'--)------------1----'----1 408602 Trf fr DC-TrnsprtORF 5,220,000 Total _5321.2204 B-29 Sanely Beach_ Rd. -Reconst.__,_(~5,'-2_20_,,'-0_00_,)) _ __,____,_.:...:...: ______ +---------1 5321.2205 TC-6 VaUey Fann Road (EastSidej ..... ----· C10575.2205.01 _ 625~ Streetlights§. Sidewalks····-·--···-------·· ...... . f ,L !·,,; 504620 Capital Streetlights TC-6 Valley Farm Road (East Side) from Kingston Road to 1 00m south. H~---•-•-----• ••••-•-•-"'""•-,-~,-•---••TT-•••••••••-••• ••••••••-•< C"' •••<>--.-••-•-'••,s>,-, 7022 R: DC's City's Share •----•·· _ --··-·-(31,200) ·:.~ 7610. RF .DC_-'rransportation~Services __ -··-· .......... __ ..,_(3_1_,_,2_0_0__,_I)_' ----------+------'----! 408008 Trf fr DC City's Res 408602 Trf fr DC-TrnsprtORF 62,400 , ... Total . 5321.2205 TC-6 Valley Farm. Road jEast S.i.d. __ (.,_6_2,_,4_0_,0)'"'""· ---'----------+-------1 5321.2206 New East/West Local Road -Delta Boulevard C10575.2206.01 ""••••-••--~·•••+,-,,_-,~ ••• -~~---•• ·•• ~~--~~•-U~•~••'-''"'" •"•-. "<• ,,.», ___ ,,p;•"--'--'~-•~~•.,.___~~-H ... 6251. Road. Improvements .......... ··---_____ .. _ ··--· --·-· . i 25, ()(\, 504400 Capital Roads New east/west local road -Delta Boulevard to ......... 45m east (50/50).__ ··········--··· ·-······ .............. . 7022 R -DC's ·s Share ........ -·····-··--· ·-······--··-(62,500) 408008 Trf fr DC City's Res _ J61 0 RF DC-Tran~ortation .services ........ --• ..... ···-·---'(~6-2,'-5_0_0).___ _________ __,_ ___ ----''-----l 408602 Trf fr DC-TrnsprtORF 125,000 ___ Total ... 5321.2206 New .East/West Local Road_ -Del _ _,(_12_5_...,.,_00_0__,_l) __ __,_ _________ +--------1 5321.2207 Walnut Lane Extension -Deskm & Constructi.oo C10575.1801.01 City of Pickering 2022 Approved Capital Budget Development Projects-CDC Funded) ____ 6230_Prof/Consulti_ng_ Fees __ __ 6251 Road Improvements ___________________________ _ Additional funding forWalnut Lane Extension from Liverpool Road to Kingston Road. Completion of Design, Approvals, Permits and Construction in accordance with the Municipal ___ Class EA. (capital project C10575.1 __ 8 ___ 0 __ 1 __________________ _ Run Date: Apr 1, 2022 Funding Expense SAP WBS SAP GL Account element/ SAP Description GL Account 655,030 _5_04_0_0_1 ___ --+-c_a_p_ita_l_C_on_s_u_lti_ng _ ___, ··, ?7C 504400 Capital Roads ··-7022 R -_DC's City'sSh_are__ (1,637,575) _4_08_0_08 ____ T_r_ff_r_DC_C_it_y_'s_R_es _ _, _ 7610 RF DC -Transportation_Services ____________ __,_4_,'-9_1_2,_,7_2_5,._ _____ 4_0_86_0_2 ___ ----1-_Trf_fr_D_C_-T_rn_s_:__p_rt_O_RF--1 __ __Total 5321 __ .2207 V\falnut LaneExtension-Design__,_6_,,_5_50_,,_3_00_,___6_,,_5_50_,,_3_00 ______ --+-------1 5321.2208 Breezy Drive/Sunrise Avenue Storm Sewer Outfall Reconstruction and Oil Grit Separator_ln~tallation -Additional_Funds..(25/75) 6253 Storm Water -•--••••••r-----,.-~---•• -~•--•••-••••••• ••~••-••-•--•--•••--•--••--•••-----~---• .. ·-~••--.... -•• Additional funding (25/75) required for the reconstruction of the storm sewer outfall, an additional oil grit separator, contract administration, 5 year monitoring program and ancillary costs for the storm sewer outfall reconstruction project at Breezy Drive/Sunrise .~ ____ JtJ .. !r.,.~! •-~--l~-~-"!"';!.~1.Y."'>!"'~j-~_!""',-.. _C_!'L/:\_C:'7J; .. _1J'\O.~.)-.. «-.. C10575.1903.0l .. ", , 000 504550 Capital Storm System -------+-----~- 7022 R -DC's Share (637,500) 408008 Trffr DC City's Res ---7611 RF DC -Storm WaterMgmt ------------------------------------~2_12-'''-5_0~0'--____ 4_0_8_60_4 ___ ----1-T_rf_f_r_D_C-_SW_M_O_B_R_F--l Total 5321.2208Breezy Drive/Sunrise_Avenue Stc_~8_5-'0,'-0_0~0'--_8_5_0,'-0_0_0 ______ -+----------1 Total Develo ment Pro·ects-DC Funded 13 571 600 · 13 571 600 1 21 Finance Dept. Summary Expenditures Capital Roads Total Expenditures Financing Trf fr 3rdPtyOblg RF Total Financing · City of Pickering 2022 Approved Capital Budget 129 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 2,800,000 2,600,000 (2,800,000) (2,800,000) Finance and Taxation Expenditures Capital Roads Total Expenditures Financing Trf fr 3rdPtyOblg RF Total Financing City of Pickering 2022 Approved Capital Budget 130 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 2,800,000 2,800,000 (2,800,000) (2,800,000) Fire Services Dept. Summary Expenditures Cap Furniture&Fix Cap Information Tch Capital Machine&Eqp Capital Machine&Eqp Capital Consulting Capital Buildings Capital Storm System Cap Furniture&Fix Capital Machine&Eqp Capital Buildings Total Expenditures Financing DebtFinancing-5-Year Property Tax Funded Trf fr RateStblz Res Trf fr DC City's Res Trf fr Public Art Trf fr DC-ProtectORF Trf fr Seaton FIA RF Total Financing Abbreviations City of Pickering 2022 Approved Capital Budget Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget . Budget 42,500 30,000 110,000 150,000 55,000 82,000 95,000 636,290 300,000 84,140 169,000 533,500 616,140 1,671,290 (371,000) (32,000) (30,000) (200,000) (370,000) (190,887) (95,000) (291,640) (614,403) (92,500) (616,140) (1,671,290) FS#1 FS#2 FS#6 Fire Station #1, New Fire Station & HQ (Seaton) 1700 Zents Drive Fire Station #2, 553 Kingston Rd. Fire Station #6, 1115 Finch Ave. 131 Fire Services 5340 Fire Services City of Pickering 2022 Draft Capital Budget Projects Listing Project Name Run Date: Jun 7, 2022 2022 Project Budget 5340.2201 FS #1 New Fire Station & HQ (Seaton) Bunker Gear and Breathing Apparatus Equipmer 169,000 40,000 75,000 55,000 95,000 30,000 47,500 5340.2206 FS#6 Overhead Door Replacement 5340.2208 FS #6 Breathing Air Compressor I Filling Station 5340.2210 Dispatch Phone Upgrade 5340.2211 FS #1 Public Art 5340.2212 FIT Testing Hardware and Software Replacement 5340.2213 FS #2 Window Replacement 5340.2214 Thermal Imaging Camera Replacement 5340.2215 FS #2 Interior Renovation 5340.2216 FS #2 -FF&E Upgrade 5340.2219 FS#1 -Clean Water Collector Construction Total 132 110,000 371,000 42,500 636,290 1,671,290 City of Pickering 2022 Approved Capital Budget Fire Services Run Date: Apr 1 , 2022 Funding Expense SAPWBS SAP GL Account element / SAP Description ·GL Account ··-~-""'--<-,---··•--·--~--,. ··--•-· , ____ ·---~-~-·-~·--·--· --- i Lifecycle replacement of eight thermal imaging i cameras. Replacement includes cameras and vehicle charging systems. 1--·-· ·-----·-~----~------.. ---------•--~------~~~---~~ 7021 R -Rate Stabilization •-• -.,Un>~----~~• '-•-~•~~•••~«,,.~---~--~~--~•~•=•'---~-••• ••~••'--•-•->•• -••-•••-••u-•••••• •--'•• •-• (110,000) 408007 Trffr RateStblz Res ___ Tobll 5340.2214 Thermal lmagingCameraRey!ac ' (110,000) 110,000 5340.2215 FS #2 Interior Renovation C10700.1809.01 ___ ,, --~-... ~ .... --------•---' ~-~ .. -"~--~-·--~-~---~·-··---·•>•=·'"··--~-------·--.... ,,_ .... ___ .,,,_ -.. 1701 Debt -5 Year (371,000) 406701 DebtFinancing-5-Year '-----~--~-----~·~---~------~-~-----·••----------~-''--•--" --"'·------------· ---- 6500_Building Related~ 371.00ii 504100 Capital Buildings --• ··-·--····~--------' . -·--~---·-·· ~--·-·--·-~---~ "•-~- Additional funding for consolidated renovations to Fire Station #2, including interior renovations and accessibility improvements to interior, creation of a second, gender-neutral washroom, provision of roof access for improved safety and installation of new LED lighting systems (capital project ____ Q1_Q"J__QO_-LQOD_\ __ -------------- Total 5340.2215 FS #2 Interior Renovation I --~-----·--·--·--·-·-·---··-------·---·-------·-·--··--------·---·--·-···-··--··-·--------~----,--·-· -------··-· (-371,000) 371,000 5340.2216 FS #2 -FF&E U~grade ______ C10700.2216.01 6173 Furniture & Fixtures L:-'.1 5(1Cl 504950 Cap Furniture&Fix -··-·---·-------------•'""""-"------------···--·-----···-··-···· . .. ., ...... --. ...•.... -, ------·· -------Upgrade to furniture at Fire Station #2. __________ 7021 R -Rate Stabilization (42,500) 408007 Trf fr RateStblz Res -······-·------- Total 5340.2216 FS #2 -FF&E ~grade (42,500) 42,500 . 5340.2219 FS#1 -Clean Water Collector Construction C10700.1601.01 ----------··-··---~------··-·--··--····---------·---·-·-... .,.~ 6460 Other Construction Related Costs -Seaton 636.~:n 504550 Capital Storm System ---------- Additional funding for FS#1 -Clean Water Collector Construction (Seaton). Total project cost to be shared with other benefitting landowners through the Duffin Heights Cost Sharing ____ Ag;eemeJ1L(C10700._1601L _____ ---·-----··----------···- ___ 7022 R -_ DC's City's Share (190,887) 408008 Trffr DC City's Res --------- 7605 RF DC -Protection Services : (445,403) 408601 Trf fr DC-ProtectORF --···--···------·--·-·----·-···-----------------------·---------· -----... -~--~-· -·-Total 5340.2219 FS#1 -Clean Water Collector Co (636,290) 636,290 --~--------•-••~mo••••••~-------••-------•------• Total Fire Services (1 671 290) 1 671,290 134 City of Pickering 2022 Approved Capital Budget Human Resources Dept. Summary Expenditures Cap Information Tch Total Expenditures Financing Trf fr DC City's Res Trf fr DC-Stdy OB RF Total Financing 135 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 290,000 290,000 (176,500) (113,500) (290,000) Human Resources Expenditures Cap Information Tch Total Expenditures Financing Trf fr DC City's Res Trf fr DC-Stdy OB RF Total Financing City of Pickering 2022 Approved Capital Budget 136 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 290,000 290,000 (176,500) (113,500) (290,000) Library Summary Expenditures Cap Furniture&Fix Cap Information Tch Cap Library Coll Mat Capital Accessibility Capital Consulting Capital Buildings Total Expenditures Financing Federal Grants Ontario Grants Property Tax Funded Trf fr DC-Libr OB RF Trf fr Seaton FIA RF Total Financing City of Pickering 2022 Approved Capital Budget 137 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 35,000 112,000 37,000 305,000 295,000 300,000 60,000 25,000 . 6,302,600 30,000 7,044,600 457,000 (908,200) {60,000) (417,000) (397,000) (5,700,865) (18,535) (7,044,600) (457,000) Library 5800 Library 5800.2201 Collection Materials City of Pickering 2022 Draft Capital Budget Projects Listing Project Name 5800.2202 Accessible Public Washroom (Claremont Library) 5800.2204 George Ashe Library Computers Upgrade 5800.2205 Improvements to Claremont Library Public Service Space 5800.2206 Library Server Replacement 5800.2209 Create Virtual Programming space at Central Library Total 138 Run Date: Jun 7, 2022 2022 Project Budget 295,000 60,000 20,000 35,000 17,000 30,000 457,000 City of Pickering 2022 Approved Capital Budget Library Run Date: Apr 1 , 20 2 Funding Expense SAPWBS SAP GL Account element / SAP Description GL Account ·-_.,,,,,, ,._., ---"'-• ·-··-----·-·-· H·••• ,_ .. "·"·-- ---•--'"••----····--• --.------·-----·--·-· .,.-.~--,, "-···-----·-·"-----------· ----------------,~-"' 5800.2201 Collection Materials C10900.2202.01 •-•••-•~•-•~~-~-=--••••-~-~•~••••-a-.+•••--•• ---• ••-.. 2823 Paid from Property_ Taxes (295,000) 408900 Property Tax Funded ·-----~-----· ------ 6179 Book Collection Material --i, ·....,r .. 504900 Cap Library Coll Mat , . .. .... ·-----_________ _, ____ ------------~-----·---···---·--~-------·-·-·-·----·------------------------------•···-··-·-··••-•o,··. Collection Materials include: Books, movies, audiobooks and other types of physical materials along with their processing and packaging. Current collection includes approx. 140,000 items - 7% of collection replaced with new material each year. Assumes the addition of approx. 9,800 items ___ at $30 each.'"•· -------------·-~----------- Total 5800.2201 Collection Materials (295,000) 295,000 --.--------·-----~--------~----·---------·- 5800.2202. Acce~sible Public Washrootn {C!aremqnt Library) C10900.2203.0l 1623 Prov Grant 402510 Ontario Grants -------- Inclusive Communities Grant 2022 -2023 -·------······-·"'--·-···--· , .. -··--·-··--~-·---·---·-·---------·•----"'--·-····--·-· _,_ .. ·--···-····-·----·· , ..... 618~Accessjbi)ity_···· .. ·--·····-······-···· . ·-·· . 60, ; 504100 Capital Buildings __ ,. Converting the current staff washroom at the Claremont Library into a public washroom with accessibility features. Subject to receiving the Inclusive Communities Grant. -·•···~' •-•~•"•~~· --•~LO,••~•• •••~--~~•-...,.___..._.----•~--~•--••·--••--• •-•-••--••=-• ... Total_ 5800.2202Accessible Public Washroom (Cl (60,000) 60,000 5800.2204 George AsheUbrary Computers Upgrade Cl0900.2204.01 __ .2823 Paid from _Prop!3rty Taxes (20,000) 408900 Property Tax Funded ------· -- __ .6175 Hardware Replacements ... r~,; ' . 504800 Cap Information Tch ---·------~------- Replacement of public and staff computers at the George Ashe Library that are older than 5 years -··"'"''" with_ n~w eq!:JJpment .... • •"~• -••-----><-' '""•--~-••••••.o>,., H Total 5800.2204George Ashe Library.Computers (20,000) 20,000 5800.2205 lmp!:Q~~_!llents to Claremoni_biE!arY..P.!!.~ic Service Sp<!~~-C10900.2205.01 28?3 Paid from Pf()pertyTaxes (35,000) 408900 Property Tax Funded ---- 6173 Furniture & Fixtures 3~ .· ,o 504950 Cap Furniture&Fix ·-------------------------------~-----------·------------------- Replace furniture and equipment at Claremont Library (furniture is all at least 20 years old) in order to provide improved client experience for Extended Hours service. ----------~--~----------------~----~-----~---~---- Total 5800.2205 Improvements to Claremont Libr (35,000) 35,000 5800_.2J06. Library Server ReJ}lacement C10900.2206.0l d•••••••••~., •• -,·-~-. 2823 Paid from Property Taxes (17,000) 408900 Property Tax Funded 1----------------~---··--··"·•······-·········-------------~-----------~-----·-•·-··---•-•--··--·· "·····--· .~175 Hardware l3_~pl9.g~rr.:i-~i:i.!l3. ..... 7,n: 504800 Cap Information Tch ··-···--«---'-----~---s-• .. --... ,- The Library currently has 5 servers. One will be . __ f.~21_aced this y~~---· ••"•w •-•-•--•--•-•--------•-••-•••,~•- -··Total. 5800.2206_Ubrcuy Server_Replacement_ __ . (17,000) 17,000 5800.2209Create Virtual Programming space at Central Library C10900.2209.0l 2823 Paid from. Property Taxes (30,000) 408900 Property Tax Funded 6500 BuildinQ Related ~' ( 504100 Capital Buildings 139 City of Pickering 2022 Approved Capital Budget Library Run Date: Apr 1, 20 ~2 Funding Expense SAPWBS SAP GL Account element / SAP Description GL Account -, ----' ., i --~-~-"•--------------•--• --•-----... . -----------•--·-------------·-------. ---------·· Build space for staff to produce virtual programming, could also be used by the public when not in use by staff __ Total .. 5800.2209 Create Virtual. Programming _spat (30,000) 30,000 Total Library (457,000) 457 000 140 Seaton Regional Library Expenditures Capital Consulting Total Expenditures Financing Trf fr DC-Libr OB RF Trf fr Seaton FIA RF Total Financing City of Pickering 2022 Approved Capital Budget 141 Run Date: Jun 6, 2022 2021 2022 Approved Approved Budget Budget 25,000 25,000 (6,465) (18,535) (25,000)