The URL can be used to link to this page

Home My WebLink About2022 Approved Current Budget SummariesCity of Pickering 2022 Approved Current Budget Summary Table of Contents Department Page Introduction & Budget Summaries 1 Office of the Chief Administrative Officer 9 Office of the CAO-Ad min 10000 18 Customer Care Centre 10005 20 Public Affairs & Corp. Comm . 10010 21 City Development 22 City Development-Admin 10100 31 Planning 10105 32 Building Services 10110 34 Sustainability 10115 36 Committee of Adjustment 10120 38 Heritage Pickering 10125 39 Community Services 40 Culture & Recreation -Admin 10200 53 Civic Centre 10240 55 Senior Citizens Centre 10245 56 Programs 10205 58 Dunbarton Pool 10210 60 Don Beer Arena 10215 61 Community Centres 10220 63 Recreation Complex-Central Core 10225 65 Recreation Complex-Pool 10230 67 Recreation Complex-Arenas 10235 68 Museum 10250 70 Pickering Art Centre 10255 72 Operations 73 Operations -Admin 10325 82 Public Works -Admin 10300 83 Property Maintenance 10305 84 Fleet Services 10310 86 Roads 10315 87 Parks 10320 89 Corporate Services 91 Information Technology 10405 98 Legal Services 10400 99 Clerks Office 10410 100 Records Management & Elections 10415 101 City of Pickering 2022 Approved Current Budget Summary Table of Contents Print Shop/ Mail Room 10420 102 By-Law 10425 103 Animal Services 10430 104 Engineering Services 106 Engineering Services-Admin 10500 112 Crossing Guards 10505 114 Water Resources & Development Services 10510 115 Sidewalks 10515 117 Streetlights 10520 118 Finance 119 Finance 10600 125 Supply & Services 10605 127 Fire Services 128 Fire Protection 10700 134 Emergency Operations 10705 136 Human Resources 137 Human Resources 10800 141 Health & Safety 10805 142 Libraries 143 Library 10900 146 General Government 11100 148 Appendix A 175 2022 Approved Current & Capital Budget Council approved the Draft 2022 Current and Capital Budgets at its March 28, 2022 Council meeting. Overall, the 2022 Current and Capital Budgets ensure that Pickering's strong financial position is maintained and our residents continue to receive the programs and services they value. The total 2022 tax increase to the City's net budget is 1. 79 percent. When combined with the proposed increase for Durham Region and Education, the overall tax increase is 1.98 percent (based on a Durham Region increase of 2.60 percent). The 2022 budget includes the impact of decisions made in previous years such as the annualized impact of service adjustments (winter control) and operating costs for previously approved capital works to provide new infrastructure as the City grows such as new vehicles, equipment and parks. Also included are costs associated with the assumption of new subdivisions such as roads, street lighting and street trees. The 2022 City Budget is based on the premise that the omicron COVID-19 variant would impact City operations for the first two months of the year. The month of March is currently being viewed as a transitional month back to a new modified normal. Over the last two years, operating under the COVI D-19, environment, the lessons learned is that it is important to have financial flexibility and strength to accommodate these unforeseen twists and turns. Hopefully, this is the last year, whereby the City's budget will reflect to some degree, the financial impact of COVID-19. 1 As the above graph reflects, the City share is slightly higher for 2022 in contrast to earlier years. The 2022 overall increase is substantially below the current rate of inflation. Budgetary Levy Increases 2000 to 2022 In 2000, Pickering Council approved a zero percent increase and since then the budget levy increases have ranged from 9.8 percent to 1.45 percent excluding the approved 2022 budget levy increase. The approved levy increase of 1. 79 percent is the second lowest increase in over twenty years. It is interesting to note, that the average levy increase for the current term, is the lowest over the last twenty years. Budget Levy Increases (0/o) 2001 to 2022 10.0 nn ,--- 0 9.0 v, - 8.0 7.6 7.0 ~ n -·- " --~ Q 6.0 5.5 -· - 5.0 4.0 ~Q ---__ ~ -n 3.99 3.53 .Jo ,J .Jo ,J ... , V 3.0 2.99 2.93 2.99 ,-- .<.o:, 2.49 2.47 2.0 1.45 1.0 0.0 2001 2003 2005 2007 2009 2011 2013 2015 2017 2019 2021 A --·= ~ ~ Average Property Tax Increase Term Per Term 2006 to 2009 6.00% 2010 to 2014 3.40% 2015 to 2018 3.20% Current 2.18% The table below provides a summary of the financial impact of the approved 2022 budget levy increase based on various residential assessment values. Table One Financial Impact of Budget Increase over 2021 City Share of Property Taxes I Residential Assessment I $100,000 $530,000 [ Increase (Over 2021) I $5.91 $31.32 $612,000 $36.17 The Municipal Property Assessment Corporation or MPAC has identified that the average assessment value for a Pickering residential property for 2022 is $530,000. The average residential assessment value is based on all types of housing structures that includes: single detached, semi-detached, townhouses and condominiums. (MPAC uses a market valuation date of January 1, 2016 to determine assessment values. The market valuation date represents the theoretical value of a property as determined between a willing buyer and seller from an "arm's length transaction" perspective.) Using the $530,000 assessment value, a Pickering resident would pay an additional $31.32 for the Pickering share of property taxes or $2.61 per month. 4 /' '- Office of the CAO Department Overview The Office of the Chief Administrative Officer (CAO) Department is responsible for the overall management of the municipal corporation, coordinating professional and administrative advice to City Council and implementing the decisions of Council. The Office of the CAO Department oversees the following functions: • Economic Development & Strategic Projects • Customer Care Centre • Public Affairs & Corporate Communication /' Office of the CAO Department I ' r 'I /' Economic Development Customer Care Centre & Strategic Projects '-'- Key Activities for 2022 Public Affairs & orate nication Corp Commu • Coordinate City activities associated with the Durham Live development • Confirm City Centre Project costs and funding strategy for Council consideration • Implement City-wide education and engagement strategy on development initiatives such as Kingston Road Intensification Plan, Pickering Nuclear Generating Station (PNGS), Innovation Corridor, Pickering Industrial Parks and Northeast Pickering • Complete the Land Use Review and coordinate investment attraction initiatives for the Pickering Innovation Corridor • Complete the Hotel Feasibility Study and implement investment attraction initiatives • Oversee the completion of the Pickering Nuclear Generating Station (PNGS) Social, Economic and Financial Impact Study • Complete and Implement the Pickering Economic Development Strategy • Develop a High Frequency Rail (HFR) concept plan on Federal Pickering Lands, in coordination with the Region of Durham 9 • Continue to manage stakeholder relations for all key developments within the City of Pickering including the Kingston Road Corridor and other Specialty Node • Coordinate the development of the corporate-wide Digital Readiness Assessment and Service Modernization Strategy • Develop naming rights and sponsorships strategy for capital assets, including Pickering City Centre • Coordinate the implementation of the corporate-wide Equity, Diversity and Inclusion Strategy ( 10-year) • Assist with the coordination of the Pickering Anti-Black Racism Taskforce and Indigenous Relationship Building Circle initiatives • Implement enhanced corporate-wide customer service training programs Financial Information Staffing Summary (Full & Regular Part Time) Approved Current Term 2018 2019 2020 2021 Full Time Reg. Part-Time Total 14 1 15 14 ---1 15 14 _1 15 17 1 18 Add 1 1 2 Approved 2022 Delete Total 0 18 0 2 0 20 The department proposes the conversion of one part-time Information Clerk from contract to a permanent part-time position to support Customer Care. Additionally, the department proposes one new full-time Senior Economic Development & Projects Officer position who will take lead on number of strategic projects including the implementation of the Economic Development Strategy and be responsible for business outreach and community engagement for major developments such as Kingston Road Corridor Intensification, decommissioning of PNGS, and Pickering Industrial Parks. Lastly, one full-time Administrative Assistant contract position is reflected in the 2022 Current Budget to support the Economic Development & Special Projects Department (funded 50% from Rate Stabilization Reserve). 10 Year-Over-Year (Net Cost) Budget Changes 2021 Budget 2022 Approved Budget YearNear Increase ($) (%) CAOAdministration $1,185,007 $1,270,992 $85,985 7.26% Customer Care Centre 499,047 482,458 (16,589) (3.32) Public Affairs & Corp. Comm. 784,702 1,053,713 269,011 34.28 ---~--~-~---~------ Tot a I (Net Cost) $2,468,756 $2,807,163 $338,407 13.71% =============================== Explanation of Significant Budget Changes Expenditures -Increases/ (Decreases) • Under the CAO Administration cost centre, there is an additional $12,100 in salaries and benefits added to the 2022 budget for a summer student diversity internship position to support the Economic Development Department. These costs are 100% offset by a grant from the provincial Streamline Development Approval Fund. In addition, there is an additional $5,000 budgeted in the outside agency services account for Economic Development Writing Services to support the preparation of grant applications. • Under the Customer Care cost centre, there is a net savings of approximately $25,000 budgeted in salaries and benefits due to the conversation of one full-time Manager, Customer Care to one full-time Supervisor, Customer Care. These savings are partially offset by an additional investment of $10,000 in seminars & education for corporate-wide customer staff training. • Under the Public Affairs & Corp. Communications cost centre, the consulting account includes an expenditure of $180,000 budgeted for consulting services to initiate a Digital Readiness Assessment and Service Modernization Strategic Plan that introduces and/or enhances corporate-wide online digital service delivery. The committee expense account includes an additional expenditure of $20,000 budgeted for the Pickering Anti-Black Racism Taskforce (PABRT) stipend (as approved by Council Resolution #577/21). The 2022 budget also includes a total expenditure of $43,000 for the Indigenous Relationship Building Circle and PABRT, which is offset by a transfer of funds from the 2711 cost centre. Lastly, the salary and benefits account includes an additional $45,000 to reflect the full years' salary of one full-time Senior Advisor, Equity, Diversity & Inclusion position in 2022 (from 8 months in 2021). 1 1 Revenues/Transfer from Reserves -(Increases)/ Decreases • Under the CAO Administration cost centre, there is an increase of approximately ($50,000) in transfers from the Continuing Studies Reserve to fund the completion of the City's Economic Development Strategy, Hotel Feasibility Study Update and Land Use Review of the Innovation Corridor. In addition, there is a decrease of $45,000 in Marketing Sponsorship revenues to reflect the reduction in large scale in-person business development events planned for 2022. Department 2020 & 2021 Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 Economic Development & Strategic Projects* Business Inquiries 1,200+ 1,300+ Business Consultations 100+ 120+ COVID Business Recovery Podcast Series 428 views n/a Investment Inquiries 90 100+ City-led Business Events (i.e. Town Halls and 1,000 views n/a Realtor & Developer Symposium) COVID Business Events/Webinars with Partners 4,000+ views 5,000+ views COVID Social Media Posts and Mail-outs (i.e. 3,000+ 3,500+ Newsletters, Social Media Posts) Support Local Campaign profiles (i.e. Profiling 95 100+ small businesses) Grand Openings 7 8 Kingston Road Intensification Business n/a 400 Outreach * Economic Development & Strategic Projects Department will be enhancing their indicators and metrics in 2023, upon completion of the Economic Development Strategy. 12 Performance Indicators/Statistics 2020 2021 Customer Care Telephone 41,378 44,622 Counter -in person inquiries made by the public 703 2,773 at the Customer Care Centre (located at City Hall) AMANDA Service Requests -AMANDA is a 21,093 27,008 property based software platform, which, in part, allows service requests from the public to be opened, with follow up details entered until the completion of the request. Live Chat -real time communication with 533 350 Customer Care staff during regular business hours. Customer Care Web Email 4,125 5,621 Pingstreet -Smart App enabling residents to 414 403 submit a request for service or ask a question of the City. After-Hours Calls -calls received from the City's 1,519 1,308 contracted after-hours service provider that are screened and processed by City staff on the next business day. Total 69,765 82,085 Communication Website Website (pickering.ca) visitors 494,364 523,214 Website (pickering.ca) unique page views 1,445,159 1,465,954 Website News Feed Subscribers: Business n/a 452 Emergency Alert Banner n/a 506 News & Announcements n/a 730 Public Notices n/a 679 Social Media @CityofPickering only (corporate account) Facebook Likes 8,784 11,258 lnstagram Followers 6,818 8,403 Twitter Followers 9,800 10,800 YouTube Channel Views n/a 34,600 YouTube Hours Watched n/a 6,000 13 Performance Indicators/Statistics 2020 2021 Facebook Live Events Mayor's Virtual Town Halls December 20, 2020 n/a -Total views 2,100 -People reached 5,200 -Comments 127 September 21, 2021 n/a -Total views 697 -People reached 1,187 -Comments 93 May 18, 2021 n/a -Total views 1,300 -People reached 6,000 -Comments 163 Let's Talk Pickering -Speaker Series on PlanninQ and Development November 24, 2021: Kim Petrin, Manager of n/a Development Services, City of Edmonton -Total views 3,900 -People reached 6,500 Comments 25 November 17, 2021: Brent Toderian, Urban n/a Advisor -Total views 3,900 -People reached 8,000 Comments 73 Media releases issued by City of Pickering 66 64 Corporate Communications Media Exposure Data Summary Media Exposure -Reports on the number of traditional media and social media hits that we get: Traditional media n/a 1,644 Social media n/a 2,932 Reach Trend -Number of potential viewers that have been exposed to our search topics: Traditional media n/a 1, 637,200 Social media n/a 10,200,000 Let's Talk Pickering -Digital Community Engagement Platform, launched June 15, 2021 Registered users n/a 1,411 Total Visits-# times a user visited or stayed on n/a 10,900 the site > 30 minutes 14 Performance Indicators/Statistics 2020 2021 Aware Visitors: visitor that has made one single n/a 8,400 visit to site or project Informed Visitors: visitor who sought more n/a 4,200 information by clicking on something Engaged Visitors: visitor that has contributed or n/a 1,800 provided feedback to an active tool on consultation page Pingstreet -Smart App which provides mobile users with key City news, calendar information, and social media feeds, along with reporting and feedback tools. Unique Page Views 14,803 10,812 Unique Users 750 633 15 Office of the CAO Department Account Descript ions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Travel Bus Dev & City Promo Cellular Phones Telephones Internet Advertising Trade Shows , Ex hib & Displays Subscription & Publications Seminars & Education Purch Prnting/Broch/News Ur Insurance Premium Consulting & Professional Recpt, Prom & Sp Events Memberships Photo, Mapping, Printing Outside Agency Serv Software/Hardware Maintenance CoI Stationery & Office Supplies Program Supplies Committee Expenses Utilities -Hydro Gas , Oil Tires System & Software Upgrades Hardwa re Replacements Website Support Intranet Total Expenditures Revenues Federal Grant Ont. Specific Grants Other Revenue Netted Revenue City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 1,644,473 1 ,827,980 2 ,250 2,250 390 ,330 427,042 14,000 13,000 40 ,550 40 ,550 23,000 23,000 11,600 12,500 25 ,625 25,110 0 0 25,000 23 ,000 17,000 17,000 3 ,695 3,445 6 ,500 14,000 6 ,000 6 ,000 8 ,750 8,920 193 ,600 592,436 116,750 113,750 . 8 ,365 8,725 6 ,000 4 ,000 87,850 114,850 9 ,306 22,639 4 ,100 4 ,100 15,700 700 0 0 3 ,300 3 ,300 1,000 1 ,000 0 0 0 0 42 ,615 49,565 2,707,359 3,358,862 0 0 0 0 (15 ,000) 0 0 (11 ,500) 16 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 (7,712) 1,820 ,268 (0.42%) 0 2,250 0 .00% 29,868 456,910 6 .99% 1,000 14,000 7 .69 % 2 ,000 42 ,550 4 .93 % 0 23 ,000 0.00% 3 ,000 15,500 24.00% 165 25,275 0 .66% 575 575 0 .00% 0 23,000 0.00% 0 17,000 0.00% 0 3,445 0 .00% 21 ,000 35 ,000 150.00% 0 6 ,000 0 .00% 280 9,200 3 .14% 14,389 606,825 2.43% (34,000) 79,750 (29 .89%) 13 ,950 22,675 159 .89% 0 4,000 0.00% 30 ,000 144,850 26 .12% 5,431 28,070 23 .99% 3 ,000 7,100 73.17% 0 700 0 .00% 65,000 65,000 0.00% 0 3,300 0 .00 % 0 1,000 0 .00% 8,000 8,000 0 .00% 6,500 6 ,500 0 .00% 3 ,260 52,825 6 .58 % 165,706 3,524,568 4.93% (17,500) (17 ,500) 0 .00% (22 ,600) (22,600) 0.00% 0 0 0 .00% 0 (11,500) 0.00% Office of the CAO Department Account Descriptions Advertising Cost Recoveries Marketing Sponsorships Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Trans. to/(from) Continuing Studies F Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget (50,000) (50,000) (180 ,000) (323,000) (75,000) (75,000) (320,000) (459,500) (393,125) (382,270) 0 (48,336) (393 125) (430 6061 1,994,234 2,468,756 17 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE. Budget 2021 (50,000) (100,000) 100 .00% 115,315 (207,685) (35.70%) 45,000 (30,000) (60.00%) 70,215 (389,285) (15.28%) 152,575 (229,695) (39.91 %) (50,089) (98,425) 103.63% 102 486 1328 120) (23.80%1 338,407 2,807,163 13.71% Office of the CAO -Adm in Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Travel Bus Dev & City Promo Cellular Phones Telephones Internet Advertising Trade Shows, Exhib & Displays Subscription & Publications Seminars & Education I Insurance Premium Consulting & Professional Recpt, Prom & Sp Events Memberships Outside Agency Serv Software/Hardware Maintenance CoI Stationery & Office Supplies Gas , Oil Tires · System & Software Upgrades Hardware Replacements Total Expenditures Revenues Federal Grant Ont. Specific Grants Cost Recoveries Marketing Sponsorships Total Revenues Transfers to/from Reserves ·& R.F. Transfer to/(from) Reserve Trans . to/(from) Continuing Studies F Total Transfers City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 967,583 966,598 750 750 222,142 225,984 8 ,500 8 ,500 34,000 34 ,000 20,000 20,000 7,400 8,300 2,115 2,050 0 0 15,000 15 ,000 17,000 17,000 775 775 5,000 5,000 2 ,750 2 ,800 125,000 495 ,336 103,000 103 ,000 7,520 7,875 22 ,350 22,350 1,493 1,670 2,500 2 ,500 1,000 1,000 0 0 0 0 1,565,878 1,940,488 0 0 0 0 (180,000) (323,000) (75,000) (75,000) (255,000) (398,000) (268,295) (309,145) 0 (48,336) (268 295} (357 481} 18 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE. Budget 2021 (20,229) 946,369 (2.09%) 0 750 0.00% 5,594 231,578 2.48% 0 8,500 0 .00% 2,000 36,000 5 .88% 0 20,000 0 .00% 3,000 11,300 36 .14% (230) 1,820 (11 .22%) 230 230 0 .00% 0 15 ,000 0.00% 0 17,000 0.00% 0 775 0 .00% 0 5 ,000 0 .00% 280 3,080 10.00% (125,611) 369 ,725 (25 .36%) (34,000) 69,000 (33 .01%) 1,600 9,475 20 .32% 5,000 27,350 22 .37% (565) 1,105 (3,3.83%) 3,000 5,500 120.00% 0 1,000 0.00% 8,000 8,000 0 .00% 6,500 6 ,500 0 .00% (145 ,431) 1,795,057 (7.49%: (17 ,500) (17,50_0) 0.00% (22,600) (22,600) 0 .00% 115,315 (207,685) (35 .70%) 45,000 (30 ,000) (60 .00%) 120,215 (277,785) (30.20%) 161,290 (147,855) (52 .17%) (50,089) (98,425) 103.63% 111 201 (246 280\ (31.11%) Office of the CAO -Adm in Account Descriptions Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 1,042,583 1,185,007 19 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE. Budget 2021 85,985 1,270,992 7.26% Customer Care Centre Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Travel Cellular Phones Telephones Internet Seminars & Education Insurance Premium Recpt, Prom & Sp Events Memberships Software/Hardware Maintenance Co1 Stationery & Office Supplies Program Supplies Total Expenditures Revenues Other Revenue Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 312,237 364,006 1,000 1 ,000 96,783 102,685 1,500 1,500 800 800 800 800 22,100 22,035 0 0 500 500 2,580 2 ,630 750 750 495 500 811 541 600 600 15 ,700 700 456,656 499,047 (15,000) 0 (15,000) 0 0 -0 441,656 499,047 20 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 202 1 (22 ,744) 341,262 (6 .25%) 0 1,000 0.00% (4,394) 98,291 (4.28%) 0 1,500 0.00% 0 800 0.00% 0 800 0 .00% 510 22 ,545 2 .31% 230 230 0.00% 10,000 10,500 2,000 .00% 0 2,630 0 .00% 0 750 0.00% (150) 350 (30.00%) (41) 500 (7.58%) 0 600 0 .00% 0 700 0.00% (16,589) 482,458 (3.32%) 0 0 0.00% 0 0 0.00% 0 0 0.00% (16,589) 482,458 (3.32%) Public Affairs & Corp. Comm. Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Travel Bus Dev & City Promo Cellular Phones Telephones Internet Advertising Subscription & Publ ications Seminars & Education Purch Prnting/Broch/News Ur Insurance Premium Consulting & Professional Recpt, Prom & Sp Events Memberships Photo, Mapping, Printing Outside Agency Serv Software/Hardware Maintenance CoI Stationery & Office Supplies Committee Expenses Utilities -Hydro Website Support Intranet Total Expenditures Revenues Netted Revenue Advertising Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 364,653 497,376 500 500 71,405 98 ,373 4,000 3,000 5 ,750 5 ,750 3,000 3,000 3,400 3,400 1,410 1,025 0 0 10,000 8,000 2 ,920 2,670 1,000 8,500 6,000 6 ,000 3,420 3,490 68,600 97,100 13,000 10,000 350 350 6 ,000 4,000 65 ,500 92,500 7,002 20,428 1,000 1,000 0 0 3,300 3 ,300 42,615 49,565 684,825 919,327 0 (11,500) (50,000) (50,000) (50,000) (61,500) (124 ,830) (73,125) (124 830) (73 125) 509,995 784,702 21 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE. Budget 2021 35,261 532,637 7 .09% 0 500 0 .00% 28,668 127,041 29 .14% 1,000 4,000 33 .33% 0 5,750 0 .00% 0 3,000 0.00% 0 3,400 0.00% (115) 910 (11.22%) 115 115 0 .00% 0 8,000 0 .00% 0 2,670 0.00% 11 ,000 19,500 129.41% 0 6,000 0 .00% 0 3,490 0.00% 140 ,000 237,100 144.18% 0 10,000 0 .00% 12 ,500 12,850 3,571.43% 0 4,000 0 .00% 25,000 117,500 27.03% 6,037 26,465 29.55% 0 1,000 0.00% 65,000 65,000 0 .00% 0 3,300 0 .00% 3,260 52,825 6.58% 327,726 1,247,053 35.65% 0 (11 ,500) 0.00% (50 ,000) (100,000) 100.00% (50,000) (111,500) 81.30% (8 ,715) (81,840) 11.92% (8 715) (81 840) 11.92% 269,011 1,053,713 34.28% City Development Department Overview The City Development Department takes a holistic approach towards city building through advancing smart growth planning principles, while adhering to the objectives of sustainability and environmental stewardship. The department participates in numerous activities respecting land use and public policy, community development, urban design, site planning and building construction. The department is responsible for the following areas: • Administration • Building Services • Planning ■ Planning & Design ■ Policy & Geomatics ■ Zoning & Administration • Sustainability r City Development Department ~ I I I I , ' Planning Division * Building Services Sustainability Planning & Design Policy & Geomatics Zoning & Administration '- * Includes Committee of Adjustment, Site Plan Committee, and Heritage Pickering Key Activities for 2022 • Develop a Site Plan Control Manual • Continue to work with IT to implement Project PRISM, the digital portal to access1 municipal services • Monitor and update Corporate Waste Diversion Initiative • Develop new Integrated Sustainable Design Standards 22 • Undertake climate change risk and vulnerability assessment project, followed by the development of a Climate Adaptation Plan with ICLEI Canada -Local Governments for Sustainability • In consultation with other departments, develop a community garden framework • Undertake a Geographic Information System (GIS) Strategic Plan for the Corporation • Undertake the community planning process for Northeast Pickering (in conjunction with the Department of Economic Development & Strategic Projects) • Establish a Monitoring Plan to ensure the goals and objectives of the City's Housing Strategy are being met • Represent the City's interest in commenting on the Region's Envision Durham process (Urban Land Needs Analysis & Draft Official Plan) • Secure Regional approval of Amendment 38 to the Pickering Official Plan and prepare a draft zoning by-law for the Kingston Mixed Use and Brock Mixed Use intensification areas • In conjunction with Economic Development & Strategic Projects, and Public Affairs & Corporate Communications, prepare and undertake an engagement strategy for the zoning by-law for the Kingston Mixed Use and Brock Mixed Use intensification areas • Design and undertake an annual monitoring program for changes within the Strategic Growth Areas, including the City Centre and the Kingston Mixed Use and Brock Mixed Use intensification areas • Continue to evaluate site specific applications for major development and intensification • Release for public review and comment the first draft of the comprehensive zoning by-law • Continue Waterfront and Nautical Village Review • Finalize work program to roll out full service Film Office (with Council approval) Financial Information Staffing Summary (Full & Regular Part Time) Approved Current Term 2018 2019 2020 2021 Full Time 44 Reg. Part-Time _Q Total 44 51 Q 51 51 Q 51 51 0 51 * Transfer of one position to Operations due to re-organization 23 Add 0 0 A pprove d 2022 Delete Total -1* 50 0 Q -1 50 The department is proposing adding two contract planning positions to its 2022 budget, which will be funded from the provincial Streamline Development Approval Grant. In support of the Provincial mandate to establish a Diversity internship program, the department also proposes to hire two eligible planning students. Both positions will be temporary and be funded from the above-noted Streamline Development Approval Grant. Year-Over-Year (Net Cost) Budget Changes City Development -Adm. Planning Building Services Sustainability Committee of Adjustment Heritage Pickering Total (Net Cost) 2021 Budget $778,934 1,756,051 (1,061,932) 667,789 10,071 16,375 $2,167,288 2022 Approved Budget $840,121 1,502,538 (1,208,206) 589,364 10,992 17,525 $1,752,334 Explanation of Significant Budget Changes Expenditures -Increases/ (Decreases) City Development -Administration (Cost Centre) YearNear Increase ($) (%) $61,187 (253,513) (146,274) (78,425) 921 1,150 ($414,954) 7.86% (14.44) 13.77 (11.74) 9.15 7.02 (19.15%) Consulting & Professional $350,000 -Increase reflects Mobile App Development, ArcGIS upgrades and development of online guidelines, all of which are funded from the provincial Streamline Development Approval Grant. Software/Hardware Maintenance Contracts $97,257 -Increase reflects additional Bluebeam-Revu license costs for additional users, and ArcGIS portal software for enhanced efficiencies in plans review and data input. Planning (Cost Centre) Salaries and Wages $217,657 -Increase reflects the additional hiring of full time contract staff. 24 Employer Contributions $36,857 -Budget increase is attributable to the above- mentioned contract positions and increased employer CPP contribution rates in 2022. Consulting & Professional ($125,530) -Decrease reflects completion of Phase 1 and substantial completion of Phase 2 of the comprehensive zoning by-law review. Outside Agency Services $10,000 -Budget increase reflects digital film advertising for film activity (i.e., to promote the City backlot in Green River). Hardware Replacements $10,000 -Increase reflects purchase of additional hardware for contract staff, which is funded from the provincial Streamline Development Approval Grant. Building Services (Cost Centre) Seminars & Education $10,200 -Increase reflects anticipated education requirements for staff to suit new building code changes. Software/Hardware Maintenance Contracts $44,658 -Increase reflects additional maintenance costs to suit implementation and use of e-Permitting solution. Sustainability (Cost Centre) Salaries & Wages ($37,475) -Budget decrease from 2021 to 2022 is related to the transfer of the Energy Conservation Engineer position to the Operations Department from th~ Sustainability Section. Employer Contributions (12,945) -Budget decrease is attributable to the above- mentioned decrease in budgeted salaries and wages. Consulting & Professional ($157,000) -Budget decrease largely reflects the amount of funds necessary in 2022 to complete and implement Phase 2 of the Sustainable Development Guidelines, which is fully offset by grant funding from The Atmospheric Fund, a regional climate agency, and the Region of Durham. Program Supplies $7,550 -Increase reflects cost and demand of program supplies. 25 Revenue/Transfer from Reserves -(Increases)/ Decreases City Development -Administration (Cost Centre) Ont. Specific Grants -($410,000) -Increase reflects Provincial Streamline Development Approval Grant funding to offset earlier mentioned software/hardware costs and consulting for this technology. Planning (Cost Centre) Sale of Services Planning Applications ($118,000) -Development application activity is variable. Budget increase reflects anticipated development applications for 2022. Ont. Specific Grants -($180,995) -Increase reflects Provincial Streamline Development Approval Grant funding to offset costs for contract staff. License & Permits -Film Permit ($180,000) -Budget increase reflects annual lease revenue for City backlot. Transfer from Reserve $67,770 -Among other projects completed, the net budget decrease in funding from transfers from reserves reflects completion of Phase 1 and substantial completion of Phase 2 of the comprehensive zoning by-law review. Building Services (Cost Centre) Revenues ($200,000) -Budget increase reflects anticipated building permit revenues for 2022. Sustainability (Cost Centre) Sale of Services Planning Applications ($110,000) -In 2022, and going forward, City Development will be allocating cost recovery for staff review of development applications to this Section. Miscellaneous Income $170,505 -Budget decrease largely reflects the amount of grant funding to be carried over and received in 2022 from The Atmospheric Fund to complete and implement Phase 2 of the Sustainable Development Guidelines. 26 Department 2020 & 2021 Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 Building Services Permits Issued 1,021 1,297 Number of Inspections 12,117 11,490 Number of lnvestiQations 204 1651 Planning Applications To P&D Committee & Council 27 57 To Committee of Adjustment 71 113 To Site Plan Committee 26 29 To Heritage Committee/Delegated 3 7 Comments On policy initiatives of other 5 12 On Land Divisions 8 28 Pre-consultations 19 35 Requests Geomatics Requests (e.g., mapping, addressing, 413 438 program queries and updates, open data portals) Legal, Vehicle & Zoning Compliance 115 190 Site Plan Approvals Issued 6 8 Special Studies, Projects, Reviews Underway 4 9 Film Permits Issued (# & revenue) 16 24 --$6,000 Filming in Parks/Pickering Museum Village(# & revenue) N/A 7 --$14,000 Film Permit enquiries -no permit issued 3 10 Film Backlot Lease (revenue) N/A $240,000 Net Revenue to City Development N/A $246,000 Estimated Revenue from all Film Activities N/A $260,000 Reports Information 16 19 Recommendations 28 48 27 Sustainability Sustainable Pickering Initiatives -Workshops 4 (600 5 (386 participants) participants) -Trees and Shrubs Planted 690 1,360 -Pollinator Plants Planted New 500 not reported in 2020 -Farmers Market 4,550 attendees 2,400 attendees 2 -Virtual Farmers Market 9,571 website 9,874 website views views Waste Reduction & Diversion -Dog Waste 6.4 tonnes 9.0 tonnes -Batteries 91 kilograms 372 kiloqrams -Staff who received waste diversion training (in-person New 543 and/or with video and survey) Not reported in 2020 1 Some existing investigations carry over from previous years 2 On a number of occasions, the Market was shut down early due to inclement weather 28 City Development Department Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Uniforms Travel Cellular Phones Telephones Internet Advertising Trade Shows, Exhib & Displays Subscription & Publications Seminars & Education Purch Prnting/Broch/News Ur Insurance Premium Ins. Deductible Consulting & Professional Recpt, Prom & Sp Events Memberships Photo, Mapping, Printing Outside Agency Serv Veh -Repairs & Maintenance Software/Hardware Maintenance CoI Building Rentals Rental Misc Equip Stationery & Office Supplies Forms Program Supplies Gift Shop Plaques Gas, Oil Tires Supplies & Tools Hardware Replacements COVID Related Expenditures Total Expenditures Revenues City of Pickering 2022 Approved Current Budget 2020 2021 Approved I Approved Budget Budget 4,615 ,390 4,611,519 13,750 16,750 1,185,063 1,239,164 20,825 12,225 4,900 2,900 32,420 21,220 12,000 13,700 19,410 19,120 0 0 10,500 10,130 4,000 2,500 7,900 6,900 42,780 44,450 5,000 6,000 26,590 27,120 2,000 2,000 875,039 2,260,990 23,650 14,450 35,080 30,670 4,250 10,030 16,000 9,500 2,000 2,000 133,092 194,975 300 300 10,150 10,150 25,650 20,150 3,000 1,000 170,725 140,995 2,500 0 1,000 3,000 2,300 3,300 6,000 10,000 0 0 7,313,264 8,747,208 29 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 148,538 4,760,057 3 .22% 1,250 18,000 7.46% 36,020 1,275,184 2 .91% 9,100 21,325 74.44% 2 ,000 4,900 68 .97% 7,650 28,870 36.05% 1,000 14,700 7.30% (2,125) 16,995 (11 .11%) 2,125 2,125 0 .00% 8,870 19,000 87 .56% 0 2,500 0.00% 2,000 8,900 28 .99% 6,080 50,530 13.68% 5,000 11 ,000 83 .33% 0 27,120 0 .00% 0 2,000 0 .00% 56,150 2,317,140 2.48% 3,000 17,450 20 .76% 6,865 37,535 22 .38% (6,780) 3,250 (67.60%) 6,000 15,500 63.16% 0 2,000 0 .00% 140,673 335,648 72.15% 0 300 0 .00% 0 10,150 0 .00% 3,550 23 ,700 17.62% 2,000 3,000 200.00% 7,550 148,545 5 .35% 500 500 0 .00% 0 3,000 0.00% (1,000) 2,300 (30 .30%) 10,000 20,000 100.00% 2,500 2,500 0 .00% 458,516 9,205,724 5.24% City Development Department Account Descriptions Sale of Serv -Plan Admin Sale of Serv -Plan Appl Sale of Serv -Plan Appl Licenses & Permits Donations Ont. Specific Grants Other Revenue Event Vendor Fees Cost Recoveries Sponsorships No Tax Marketing Sponsorships Misc Income Film Permits 0th Rev -Rebates/Incentive Rntl -CCC Roof Solar Panel Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Trans . to/(from) Continuing Studies F Transfer to/(from) Reserve Fund Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget (2,000) (2,000) (1,025,000) (1,165,500) 0 0 (3,010,000) (3 ,000,000) (1,500) (500) 0 (14,680) (35,000) (35,000) (25,000) (25,000) (281,965) (944,710) (5,000) (3,500) (1,000) (3 ,000) (4,000) (277,000) (7,500) (142,500) (40 ,000) (40 ,000) (6,000) (6,000) (4,443,965) (5,659,390) (233 ,840) (353 ,345) (144,424) (43,750) (94,810) (523,435) (473 074) (920 530\ 2,396,225 2,167,288 30 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 0 (2,000) 0 .00% (118,000) (1,283,500) 10.12% (110,000) (110,000) 0 .00% (200,000) (3,200,000) 6 .67% 0 (500) 0 .00% (576,315) (590,995) 3,925 .85% 0 (35,000) 0 .00% 12,750 (12,250) (51 .00%) 11 ,320 (933,390) (1 .20%) 1,500 (2,000) I (42 .86%) 1,000 (2,000) (33 .33%) 170,505 (106,495) (61.55%) (180,000) (322,500) 126 .32% 40 ,000 0 (100.00%) 6,000 0 (100 .00%) (941,240) (6,600,630) 16.63% 29,500 (323,845) (8 .35%) (35,770) (79,520) a1.?6% 74,040 (449,395) (14 .15%) 67770 (852 760) (7.36%) (414,954) 1,752,334 (19.15%) City Development -Adm in Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Travel Cellular Phones Telephones Internet Subscription & Publications Seminars & Education Insurance Premium Consulting & Professional Recpt, Prom & Sp Events Memberships Software/Hardware Maintenance Co1 Rental Misc Equip Stationery & Office Supplies Supplies & Tools COVID Related Expenditures Total Expenditures Revenues Sale of Serv -Plan Admin Ont. Specific Grants Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 433,573 443,316 500 500 122,746 124,952 1,000 0 500 0 800 800 2,470 2,390 0 0 3,500 4,500 2,500 1,500 3,105 3,170 0 0 500 500 500 500 122,514 187,056 10,150 10,150 3,000 · 1,500 100 100 0 0 707,458 780,934 (2,000) (2,000) 0 0 (2,000) (2,000) 0 0 705,458 778,934 31 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 13,402 456,718 3.02% 0 500 0.00% 4,478 129,430 3 .58% 1,000 1,000 0 .00% 500 500 0.00% 0 800 0 .00% (265) 2,125 (11.09%) 265 265 0 .00% 0 4,500 0.00% 1,000 2,500 66 .67% 0 3,170 0.00% 350,000 350,000 0.00% 0 500 0.00% 0 500 0 .00% 97,257 284,313 51.99% 0 10,150 0 .00% 3,050 4,550 203 .33% 0 100 0 .00% 500 500 0.00% 471,187 1,252,121 60.34% 0 (2,000) 0 .00% (410,000) (410,000) 0.00% . (410,000) (412,000) 20 ,500.00% 0 0 0.00% 61,187 840,121 7.86% Planning Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Uniforms Travel Cellular Phones Telephones Internet Advertising Sem inars & Education Insurance Premium Ins . Deductible Consulting & Professional Recpt , Prom & Sp Events Memberships Photo, Mapping, Printing Outside Agency Serv Software/Hardware Maintenance Co1 Building Rentals Stationery & Office Supplies Supplies & Tools Hardware Replacements COVID Related Expenditures Total Expenditures Revenues Sale of Serv -Plan Appl Ont. Specific Grants Cost Recoveries Film Permits Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Trans . to/(from) Continuing Studies F Transfer to/(from) Reserve Fun d City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 1,979,414 2,277 ,576 5,250 5,250 505 ,858 597,838 6 ,500 5 ,500 600 600 3,450 2,450 3,200 4,000 7,410 7 ,510 0 0 1,000 1,000 5,400 16,100 13,150 13,410 1,000 1,000 603,459 1,788 ,280 850 550 16 ,880 14,270 3,000 2,000 0 0 5,041 3,747 300 300 13,000 13,000 200 200 0 0 0 0 3,174,962 4,754,581 (1,025,000) (1, 165,500) 0 0 (62 ,385) (795 ,000) (7,500) (142,500) (1,094,885) (2,103,000) (233,840) (353 ,345) (144,424) (43,750) (121,810) (498,435) 32 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 217,657 2 ,495,233 9 .56% 1,750 7,000 33 .33% 36 ,857 634 ,695 6 .17% 1,500 7,000 27.27% 0 600 0 .00% 1,000 3,450 40 .82% 0 4,000 0 .00% (835) 6 ,675 (11 .12%) 835 835 0 .00 % 10,000 11 ,000 1,000.00% (3 ,750) 12,350 (23 .29%) 0 13,410 0.00% 0 1,000 0 .00% (125,530) 1,662,750 (7 .02%) 300 850 54 .55% 560 14,830 3 .92 % 0 2,000 0.00% 10 ,000 10,000 0 .00% (132) 3,615 (3.52%) 0 300 0.00% (3,000) 10,000 (23 .08%) 0 200 0.00% 10 ,000 10,000 0 .00% 500 500 0 .00% 157,712 4,912,293 3.32% (118 ,000) (1,283 ,500) 10.12% (180 ,995) (180,995) 0 .00% 0 (795 ,000) 0 .00% (180 ,000) (322 ,500) 126.32% (478,995) (2,581,995) 22.78% 29 ,500 (32 3,845) (8 .35%) (35,770) (79,520) 81 .76% 74,040 (424 ,395) (14 .85 %) Planning Account Descriptions Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 202 1 Approved Approved Budget Budget (500 074) (895 530) 1,580,003 1,756,051 33 Run Date: 5/31/22 3:02 PM 2022 INC ./DEC . Approved % CHGE. Budget 2021 67770 (827 760) (7.57%' (253,513) 1,502,538 (14.44%) Building Services Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Uniforms Travel Cellular Phones Telephones Internet Subscription & Publications Seminars & Education Purch Prnting/Broch/News Ur Insurance Premium Ins. Deductible Consulting & Professional Recpt, Prom & Sp Events Memberships Outside Agency Serv Veh -Repairs & Maintenance Software/Hardware Maintenance CoI Stationery & Office Supplies Forms Gas , Oil Tires Supplies & Tools Hardware Replacements COVID Related Expenditures Total Expenditures Revenues Licenses & Permits Other Revenue Cost Recoveries Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Fund Total Transfers City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 1,802,517 1,457,047 7,000 10,000 456,919 394,354 7,800 2,400 4 ,000 2,000 25,150 16,600 5,500 6,400 7,765 7,510 0 0 4,000 2,000 26,000 20,100 5,000 6,000 7,370 7,520 1,000 1,000 219,580 149,710 6,900 3,400 13,080 11,200 6,000 0 2,000 2,000 4,227 2,537 8,000 4,000 3,000 1,000 1,000 3,000 2,000 3 ,000 6,000 10,000 0 0 2,631,808 2,122,778 (3,010,000) (3,000,000) (35,000) (35,000) (219,580) (149,710) (3,264,580) (3 ,184,710) 52 ,000 0 52 000 0 34 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHG E. Budget 2021 (45,046) 1,412,001 (3.09%) 0 10,000 0.00% 7,109 401,463 1.80% 5,400 7,800 225.00% 2,000 .4,000 100.00% 6,000 22,600 36 .14% 1,300 7,700 20.31% (835) 6,675 (11 .12%) 835 835 0.00% 2,000 4,000 100 .00% 10,200 30,300 50 .75% 5 ,000 11,000 83 .33% 0 7,520 0 .00% 0 1,000 0 .00% (11,320) 138,390 (7.56%) 2,500 5,900 73 .53% 6,605 17,805 58 .97% 0 0 0 .00% 0 2,000 0 .00% 44,658 47,195 1,760.27% 4,000 8,000 100.00% 2 ,000 3,000 200 .00% 0 3,000 0.00% (1,000) 2 ,000 (33.33%) 0 10,000 0.00% 1,000 1,000 0.00% 42,406 2,165,184 2.00% (200 ,000) (3,200,000) 6 .67% 0 (35,000) 0 .00% 11,320 (138 ,390) (7 .56%) (188,680) (3,373,390) 5.92% 0 0 0.00% 0 0 0.00% Building Services Account Descriptions Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget (580,772) (1,061,932) 35 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 (146,274) (1,208,206) 13.77% Sustainability Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Uniforms Travel Cellular Phones Telephones Internet Advertising Trade Shows, Exhib & Displays Subscription & Publications Seminars & Education Insurance Premium Consulting & Professional Reep!, Prom & Sp Events Memberships Photo, Mapping, Printing Outside Agency Serv Software/Hardware Maintenance CoI Stationery & Office Supplies Program Supplies COVID Related Expenditures Total Expenditures Revenues Sale of Serv -Plan Appl Donations Ont. Specific Grants Event Vendor Fees Sponsorships No Tax Marketing Sponsorships Misc Income 0th Rev -Rebates/Incentive Rntl -CCC Roof Solar Panel Total Revenues City of Pickering 2022 Approved Current Budget 2020 2021 Approved ! Approved Budget Budget 392,686 426,380 1,000 1,000 99,046 121,519 4,000 3,000 ; 300 300 2,000 1,500 2,500 2,500 1,765 1,710 0 0 9,500 9,130 4,000 2,500 400 400 8,380 6,250 2,965 3,020 37,000 308 ,000 15,000 10,000 3,770 3,850 1,000 7,780 10,000 9,500 1,310 1,635 1,500 1,500 170,725 140,995 0 0 768,847 1,062,469 0 0 (1,500) (500) 0 (14,680) (25,000) (25,000) (5,000) (3,500) (1,000) (3,000) (4,000) (277,000) (40,000) (40,000) (6,000) (6,000) (82,500) (369,680) 36 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 (37,475) 388,905 (8."79%) (500) 500 (50 .00%) (12,945) 108,574 (10.65%) 1,000 4,000 33.33% 0 300 0 .00% (500) 1,000 (33.33%) (300) 2,200 (12 .00%) (190) 1,520 (11 .11%) 190 190 0.00% (1,130) 8,000 (12.38%) 0 2,500 0.00% 0 400 0 .00% (1,370) 4,880 (21 .92%) 0 3,020 0.00% (157,000) 151,000 (50.97%) 0 10,000 0.00% (300) 3,550 (7 .79%) (6,780) 1,000 (87.15%) (4,000) 5,500 (42.11%) (1,110) 525 (67 .89%) (500) 1,000 (33 .33%) 7,550 148,545 5.35% 500 500 0.00% (214,860) 847,609 (20.22%) (110,000) (110,000) 0.00% 0 (500) 0.00% 14,6°80 0 (100.00%) 12,750 (12,250) (51 .00%) 1,500 (2,000) (42 .86%) 1,000 (2,000) (33.33%) 170,505 (106,495) (61 .55%) 40,000 0 (100 .00%) 6,000 0 (100.00%) 136,435 (233,245) (36.91%) Sustainability Account Descriptions Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Fund Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget (25,000) (25,000) 125 000\ 125 000\ 661,347 667,789 37 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE . Budget 2021 0 (25,000) 0 .00% 0 125 000\ 0.00% (78 ,425) 589,364 (11.74%) Committee of Adjustment Account Descriptions Expenditures Salaries & Wages Employer Contributions Conferences Travel Seminars & Education Memberships Total Expenditures Revenues Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 7,200 7 ,200 494 501 1,000 1,000 820 420 200 200 750 750 10,464 10,071 0 0 0 0 10,464 10,071 38 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 0 7 ,200 0 .00% 521 1,022 103.99% 0 1,000 0 .00% 400 820 95 .24% 0 200 0 .00% 0 750 0 .00% 921 10,992 9.15% 0 0 0.00% 0 0 0.00% 921 10,992 9.15% Heritage Pickering Account Descriptions Expenditures Conferences Travel Seminars & Education Consulting & Professional Recpt, Prom & Sp Events Memberships Photo, Mapping, Printing Stationery & Office Supplies Gift Shop Plaques Total Expenditures Revenues Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved i Approved Budget Budget 525 325 500 250 300 300 15,000 15,000 400 0 100 100 250 250 150 150 2,500 0 19,725 16,375 0 0 0 0 19,725 16,375 39 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 200 525 61.54% 250 500 100 .00% 0 300 0 .00% 0 15,000 0 .00 % 200 200 0 .00% 0 100 0 .00% 0 250 0 .00% 0 150 0 .00% 500 500 0 .00 % 1,150 17,525 7.02% 0 0 0.00% 0 0 0.00% 1,150 17,525 7.02% Community Services Department Overview The Community Services Department is responsible for all matters relating to recreation and culture services including recreation programs, memberships, cultural opportunities and special events. The department provides Pickering residents with high quality culture and recreation activities at a variety of City owned facilities including: • Chestnut Hill Developments Recreation Complex (CHDRC) (aquatics centre, fitness/health club, racquet courts, twin ice pad arena, banquet halls/meeting rooms) • Don Beer Arena (3 ice pads) • Dunbarton Indoor Pool (25 metre pool) • Community Centres (East Shore Community Centre, West Shore Community Centre, George Ashe Community Centre and northern facilities) • Pickering Museum Village (19 heritage buildings) In addition, the Community Services Department is responsible for the operation and maintenance of all City owned facilities including the Civic Complex. Community Services Department Culture & Recreation & Facilities I I I I r ' r ' r ..., r Recreation Cultural Aquatics & Facilities Community Services Services Fitness Maintenance Services '-_/ j \. ,, '-.,, '--Administration Key Activities for 2022 • Return to regular service delivery for registered and drop-in programs affected by COVID and the implementation of marketing and communications initiatives to increase membership and participation 40 ' _/ • Completion of lobby, fitness, change room, lighting, security and mechanical renovations at Chestnut Hill Developments Recreation Complex (CHDRC) • Re-opening of full service levels at CHDRC including a rebranding of promotional materials and membership drive • Initiate pool bleacher replacement, banquet hall floor replacement, tennis court roof repairs and arena floor replacement capital projects at CHDRC • In partnership with the Operations department initiate the development of a long term strategy for the Northern Community Services facilities • In partnership with Operations, Pickering Library and Engineering departments, begin development of recommended program and schematic concepts for the new Seaton Recreation Centre • Development of City of Pickering action items and response to the Durham Region Community Safety and Well Being Plan • Cultural Tourism development including the development of tourism routes led through the Pickering Museum Village • Renovation of and exhibit design for the Log Barn at Pickering Museum Village • Development of a Public Art Strategy and implementation of permanent public art works at New Fire Headquarters and Esplanade Park Financial Information Staffing Summary (Full & Regular Part Time) Approved Current Term 2018 2019 2020 2021 Add Full Time 67 71 75 76 2 Reg. Part-Time 52 52 49 49 0 Total 119 123 124 125 2 Approved 2022 Delete -7 :1 -8 The above chart excludes contract, students and term employees. Total 71 48 119 In 2021, the City merged Public Works, Facilities Capital Projects, Corporate Security, and Energy Management into a new Operations Department. Seven full-time positions were transferred from Community Services Department to the new Operations Department. The department is proposing one new full-time Coordinator, Community Safety and Well Being position starting in September 2022 to implement action items in response to the Community Safety and Wellbeing plan. In addition, the conversion of one part-time 41 Event Coordinator position to a full-time position is being proposed to support the growth in city and community events. Year-Over-Year (Net Cost) Budget Changes 2021 2022 YearNear Increase Budget Approved ($) (%) Budget Cult. & Rec -Adm. $3,185,608 $2,603,475 ($582,133) (18.27%) Civic Centre 683,915 796,058 112,143 16.40 Seniors Citizens Centre 416,497 334,722 (81,775) (19,63) Programs 893,886 1,059,379 165,493 18.51 Dunbarton Pool 382,315 339,364 (42,951) (11.23) Don Beer Arena 760,468 446,318 (314,150) (41.31) Community Centres 857,697 744,130 (113,567) (13.24) Rec Complex -Core 2,273,318 2,612,036 338,718 14.90 Rec Complex -Pool 591,170 748,821 157,651 26.67 Rec Complex -Arenas 517,961 323,344 (194,617) (37.57) Museum 860,578 748,546 (112,032) (13.02) Pickering Arts Centre 0 0 0 0.00 Total (Net Cost) $11,423,413 $10,756,193 ($667,220) (5.84%) Explanation of Significant Budget Changes Expenditures -Increases (Decreases) Under the Community Services cost centres, the following accounts had significant budget changes: Salaries & Wages $900,232 -Budgeted increase to cover $485,305 in grant funded positions. Budgeted increase also includes $414,700 in additional part time staffing for COVID screening and additional cleaning staff, and includes a reduction of $99,000 for part time staff during January COVID service reductions. Lastly, budget includes funding for a Coordinator, Community and Safety Well position with a September 1 start date and the conversion of a part-time Event Coordinator position to full time. Salaries & Wages -Programs $562,088 -Budgeted increase for part-time staff to resume full offering of registered programs. Staffing is budgeted based on elimination of programming in January based on COVID restrictions, resumption of programming with capacity limits February through June and full capacity programs July through December. 42 Overtime $56,634 -Budget increase to return to pre-COVID service and activity levels. Employee Contributions $54,233 -Budget increase is attributable to the earlier mentioned new positions and increased employer CPP contribution rates in 2022. Uniforms $5,852 -Budget Increase due to return to pre-COVID staffing and service levels. Advertising $96,400 -Budget increase due to return to pre-COVID 19 events and programs. Trade Shows & Exhibits $148,600 -Budget increase due to Museum Blacksmith, Log Barn and Mobile Museum Exhibits. Expenses are fully offset by grant funding. Printing/Broch/Newsletter $19,000 -Budget increase to Pre-COVID levels for marketing for programming and events. Consulting & Professional $57,100 -Budget decrease of ($46,700) due to consulting transfer to Operations department due to restructuring. Increase of $70,400 to conduct Fair Minded Pricing Policy development. Increase of $66,000 to museum consulting for exhibit design that is fully offset by grant revenue. Reception, Promotion & Special Events ($9,750) -Budget decrease of ($23,250) in Seniors Centre tied to the removal of Special COVID -19 grant funding and associated expenses. Increase of $10,500 to return to pre-COVID activity levels at the CHDRC for member events. Building Repairs & Maintenance $30,821 -Budget decreases due to transfers to COVID related expenditures. Budget increase of $48,400 due to inclusion of dispensers and supplies to provide free feminine hygiene products across city facilities. Increase of $32,000 at George Ashe Library and Community Centre (GALCC) for security camera and septic system repairs. Increase at the Museum for lighting improvements and landscape improvements that are partially offset by donations. Miscellaneous Equipment Repairs $19,265 -Budget increase for fitness equipment relocation and servicing due to capital replacement of fitness equipment in late 2022. Software/Hardware Maintenance Contracts ($69,893) -Budget decrease due to transfer of $66,000 to Operations due to department restructuring. 43 Artefact Repairs & Maintenance ($5,000) -Budget decrease for museum artifact repairs based on needs of the collection. Program Building Rentals $120,000 -Budget increase due to the resumption of Community use of Schools and return of Learn to Swim programming at CHRDC Pool as internal rental charges have been resumed. Program Supplies $383,745 -Budget Increase for expenses related to the Public Art Program. Expenses are fully offset by transfers from the Public Art Reserve and grant funding. Event Supplies $360,075 -Budget increase of $181,000 for grant funded projects including $75,000 for the Cultural Tourism Strategy (100% funded from Tourism Development Fund), $13,000 for Community Tourism Event Pod Program (100% funded from Central Counties Tourism Grant), $65,000 for Cultural Fusion Festival and Culture Days Programming (100% funded through Reconnect Grant) and $20,000 for Esplanade Park Commemoration event (100% funded from Commemorate Canada Recovery Fund). Budget increase of $67,000 for Canada Day daytime events reinstated to the budget post-COVID. Budget reduction of $40,000 for the elimination of Canada· Day -evening event. Increase of $26,600 for Celebrate Winter event supplies offset by sponsorships. Increase of$16,500 for expenses Central Counties Tourism Grant (100% grant funded). Program Supplies $45,750 -Budget increase for supplies to align with resumption of programming. Supplies -Special Events $23,420 -Budget increase of $23,420 at the Museum for supplies for programming. Offset by admissions revenues. Committee Expenses ($68,750) -Budget decrease partially due to the transfer of Pickering Anti-Black Racism Taskforce ($25,000) and the Indigenous Relationship Action Plan ($17,500) to the CAO's office. Utilities Water $10,950 -Budget increase reflects re-opening of CHDRC Pool and Durham Region rate increase. Utilities Gas -$11,455 -Budget increase based on anticipated increase in natural gas prices. 44 Minor Furniture & Fixtures $17,400 -Budget increase for replacement defibrillators and furniture at CHDRC. COVID Related Expenditures $78,000 -budget increase based on expense relocation from other budget lines for expenses directly related to COVID. Revenues/Transfer from Reserves -(Increases)/ Decreases Federal Grant Revenues ($1,069,339) -Budgeted increase in grant revenues. Budgeted funding includes Legacy Fund Grant ($65,000), My Mainstreet Community Activator Grant ($150,000), Community Revitalization Fund ($151,250) and Commemorate Canada Reopening Fund ($25,000), Canada Summer Jobs ($103,000), Celebrate Canada ($24,000), Commemorate Canada Recovery Fund ($70,000), Young Canada Works ($45,500), Canada Cultural Investment Fund ($55,000), Virtual Museum of Canada ($83,900), Museum Assistance Program ($268,000) Canada Cultural Spaces Fund ($100,000), Tourism Relief Fund ($95,000) and Museum Assistance Reopening Fund ($100,000). Ontario Grants ($224,175) -Budgeted increase in revenues due to a number of project grants including; Tourism Development Grant ($75,000), Central Counties Tourism ($30,000), Reconnect Festivals and Events ($70,000), Reconnect Grant carryover ($50,000), Rural Economic Development Fund ($44,400) and the Rural Economic Development Fund ($30,000). Returning grants include Jumpstart ($10,000), Community Museum Operating Grant ($39,000) Summer Experience Fund ($3,500), Central Counties Tourism ($15,000) and Swim to Survive (14,500). $218,500 in grant funding to support seniors programming has also been budgeted which is an increase of $30,500 over 2021 revenues due to carryovers of some 2021 grant funding. Program Revenues ($756,458) -Program revenue budget has been increased by $756,458 to $1,266,600. Revenues were budgeted based on elimination of programming in January based on COVID restrictions, resumption of programming with capacity limits February through June and full capacity programs July through December. Child Supervision ($20,000) Budgeted increase due to resumption of Child Supervision services and admissions. Admissions ($96,794) -Budgeted increase due to the return to pre-COVID service levels and completion of CHDRC renovations. 45 Rentals -Ice ($744,430) -Budgeted revenue increase to align with resumption of ice rentals in February 2022. Includes one pad of summer ice. Rentals -Pool ($154,820) -Budgeted revenue increase for the re-opening of CHDRC Pool and resumption of regular user group rentals. Rentals ($178,620) -Budget increase in rental revenue for Meeting Rooms ($13,000), Halls ($68,000), West Shore CC ($46,620) and East Shore CC ($24,000) and GALCC ($27,000) Memberships ($121,584) Budgeted increase due to the return to pre,..COVID service levels and completion of CHDRC renovations. Arena Floor ($10,500) -Budget increase in budgeted revenue for the resumption of regular user group rentals. Sponsorships ($90,000) -Budget increase in sponsorships due to the resumption of events. Transfer-From Reserves (27,663) -Reflects a $40,000 budget increase in funding from the Public Art Reserve to fund planned City Public Art Projects in 2022, partially offset by a reduction in transfers from other reserves. Transfer -DC Reserve ($70,400) -Reflects a budget transfer from DC reserves funds to fund the cost of consulting for development of the Fair Minded Pricing Study and Policy. Department 2020 & 2021 Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 Cultural Services Cultural Services Virtual Events, Cultural Pop-ups, on-109,827 32,713 line participants Destination Pickering Social Media Engagement (likes, 8,948 15,185 shares, comments) Live Event Attendance (Events, Partner Events, 2,184 22,000 Cultural Pop-ups) 46 Performance Indicators/Statistics 2020 2021 Recreation Services Programs offered 580 283 Registered participants N/A 3,464 Events 10 18 Social media engagements 33,675 5,454 Aquatics Programs offered 528 19 Registered participants 1,665 120 Swim members 254 177 Available public swim hours 1,426 1,071 Available rental hours 907 810 Individual swim admission purchases 2,383 153 Fitness Group fitness reqistered programs offered 96 193 Group fitness reqistered participants 412 468 Small qroup traininq proqrams offered 71 77 Small group training participants 149 101 Personal training packages sold 25 12 Personal fitness members 221 181 Health Club Health Club Members 1,261 669 Available hours 3,283 2,740 Individual admissions purchased 250 62 Number of visits 76,000 8,603 Racquet Sports Squash Members 134 78 Racquetball Members 20 12 Tennis Members 43 76 Golden/Combination Members 39 40 Number of available hours: Tennis 2,467 1,300 4 courts= 5,200 Squash & Racquetball 2,365 2,072 10 courts= 20,720 47 Performance Indicators/Statistics 2020 2021 Number of guests Tennis 2,816 786 Squash 1,168 479 Racquetball 234 58 Number of courts booked Tennis 5,727 3,800 Squash 2,996 1,125 Doubles Squash 774 226 Racquetball 839 149 Pickerin~ Museum Village Museum visitors and proqram participants 7,183 9,248 Facilities Operations -Arena CHDRC total hours of ice rental 1,256 2,230 OBA total hours of ice rental 3,127 3,282 CHDRC total hours of arena floor time rental 210 98 OBA total hours of arena floor time rental 0 1,155 OBA Banquet Hall rental hours 397 1,003 O'Brien Meeting Room rental hours 1,485 3,124 48 Community Services Department Account Descriptions Expenditures Salaries & Wages Salaries & Wages -Prg . Overtime Employer Contributions Conferences Uniforms Travel Freight, Express & Cartage Cellular Phones Telephones Internet Cable Advertising T rade Shows, Exhib & Displays Subscription & Publications Seminars & Education Purch Prnting/Broch/News Ur Insurance Premium Ins . Deductible Consulting & Professional Recpt, Prom & Sp Events Memberships Photo, Mapping, Printing Outside Agency Serv Build Repairs & Mtce Veh -Repairs & Maintenance Misc Equip Repairs Software/Hardware Maintenance Co1 Antiques Repairs Mtce. Grounds Upkeep Community Use of Schools Building Rentals Prgm -Build Rentals Rental Misc Equip Land Rentals City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 8,033,959 7,747,696 965,635 324,907 171,455 127,145 2 ,024,516 2,078,310 7,600 3,565 46,500 40,008 18,425 10,625 2,500 2,500 32,800 35,450 100,535 98,935 0 0 0 0 260,400 231,400 1,200 61,700 4,550 550 49,600 39,320 57,000 41 ,000 62,960 64,220 11,000 11,000 223,985 95,300 63,000 123,380 16,417 20,296 9,000 9,000 317,935 227 ,805 1,538,875 1,317,944 11,300 11,300 75,650 60,410 72,809 96,453 8 ,700 13,700 2,800 2,800 3,500 2,000 72,210 73,410 196,000 19,000 9,600 3,600 46,160 46,150 49 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 900,232 8,647,928 11.62% 562,088 886,995 173.00% 56,634 183,779 44 .54% 54,233 2,132,543 2.61% 3,400 6,965 95.37% 5,852 45,860 14.63¾ 5,000 15,625 47 .06% 0 2,500 0 .00% 640 36,090 1 .81% (20,940) 77,995 (21.17%) 15,540 15,540 0.00% 5,985 5,985 0 .00% 96,400 327,800 41 .66% 148,600 210,300 240.84% (200) 350 (36 .36%) 2,114 41,434 5 .38% 19,000 60,000 46.34% (2,500) 61,720 (3.89%) 0 11,000 0.00% 57,100 152,400 59.92% (9,750) 113,630 (7.90%) (4,084) 16,212 (20 .12%) 0 9,000 0.00% (991) 226,814 (0.44%) 30,821 1,348,765 2.34% (1,000) 10,300 (8.85%) 19,265 79,675 31 .89% (69,928) 26,525 (72.50%) (5,000) 8,700 (36.50%) 0 2,800 0 .00% 1,500 3,500 75.00% 0 73,410 0.00% . 120,000 139,000 631 .58% 6,000 9,600 166.67% 0 46,150 0 .00% Community Services Department Account Descriptions Financial Service Charges Stationery & Office Supplies Forms Program Supplies Event Supplies Prgms Supplies Athletic Equip . Playroom Drop-In Centre Supplies Supplies -Special Events Antique Purchases Committee Expenses Gift Shop Plaques Utilities -Water Utilities -Gas Utilities -Hydro Utilities -Oil Utilities -Cable T.V. Gas, Oil Tires Supplies & Tools Minor Furniture & Fixtures System & Software Upgrades Misc. Equipment COVID Related Expenditures Total Expenditures Revenues Federal Grant Ont. Specific Grants Program Registrations Gift Shop Snack Bar Vending Machines Rentals Advertising Space Memberships-Pool/Health Club Programs Child Supervision City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved INC./DEC . Budget Budget 0 175,000 0 17,050 12,050 (1,000) 1,900 1,900 0 12 ,255 52,255 383,745 291,025 198,350 360,075 111,715 75 ,000 45,750 2,300 2,300 0 4,400 4,400 0 14,500 11,580 23,420 600 600 0 67,750 98,250 (68,750) 5,250 2 ,625 2,375 189,265 152,420 10,950 287,496 229,120 11,455 1,317,361 1 ,154,661 0 5,683 5,683 0 850 850 (850) 10,075 10,075 3 ,775 75,536 58,911 2,100 23,600 32,600 17,400 25,000 0 0 13,400 13,400 (3,600) 0 0 78,000 16,995,587 15,332,909 2,860,856 (147,000) (261,313) (1,069,339) (243,800) (392,305) (224,175) (1,944,900) (510,142) (756,458) (10,500) (5,250) (6 ,350) (16 ,950) (9,925) (1,729) (17,500) (15 ,500) 0 (4,600) (2,300) (606) (77,000) (66,000) 0 (8 ,000) (13,750) 6,416 (76,560) (36 ,560) (440) (30,000) 0 (20,000) 50 Run Date: 5/31/22 3:02 PM 2022 Approved % CHGE . Budget 2021 175,000 0 .00% 11,050 (8 .30%) 1,900 0.00% 436,000 734 .37% 558,425 181.54% 120,750 61.00% 2 ,300 0 .00% 4,400 0 .00% 35,000 202.25% 600 0.00% 29,500 (69.97%) 5,000 90.48% 163,370 7.18% 240,575 5 .00% 1,154,661 0 .00% 5,683 0 .00% 0 (100 .00%) 13,850 37.47% 61 ,011 3 .56% 50 ,000 53 .37% 0 0.00% 9,800 (26 .87%) 78 ,000 0 .00% 18,193,765 18.66% (1,330,652) 409.22% (616,480) 57 .14% (1,266,600) 148.28% (11,600) 120.95% (11 ,654) 17.42% (15,500) 0 .00% (2,906) 26.35% (66,000) 0 .00% (7 ,334) (46 .66%) (37,000) 1 .20% (20,000) 0 .00% Community Services Department Account Descriptions Fitness Testing Donations Admissions -Public & Edu . Admissions -Tennis Admissions -Skating Admissions -Public Swimming Admissions -Squash Admissions -Fitness Room Admissions -Racquet Ball Rentals -Ice Surface Rentals -Pool Rentals -Mtg . Room/Public Rentals -Mtg. Room/Prog . Rentals -Halls Rentals -Pool-School Board Rentals -West Shore C .C . Rentals -East Shore C.C. Rentals -Lockers Membertships -Tennis Memberships -Pool/Health Club Memberships -Squash Memberships -General Memberships -Racquet Ball Rentals -Claremont C .C . Rentals -Petticoat Creek Rentals -Wellness Clinic Arena Floor Rentals Other Misc Revenue · Netted Revenue Event Vendor Fees Sponsorships No Tax Marketing Sponsorships l'vliscellaneous Revenue Other Revenue -Membership NSF F Total Revenues Transfers to/from Reserves & R.F . City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved INC./DEC . Budget Budget (70,000) (40 ,000) 4,705 (2,000) (2,000) (3,000) (141,440) (141,440) (31,560) (92,000) (74,000) (9,000) (23,500) (11,750) (6,250) (57 ,000) (9,035) (39,684) (21,000) (11,000) (5,500) (6,500) (2,000) (3,100) (5 ,000) (1,600) (1,700) (1,852,000) (782,570) (744,430) (276,000) (71,500) (154,820) (86,000) (48,000) (13,000) (27,000) (7,000) 0 (149 ,000) (27 ,000) (68,000) (1,258) 0 0 (70,901) (44,780) (46 ,620) (56,000) (10,000) (24,000) (100) 0 0 (24,000) (24 ,000) (3 ,500) (679,000) (371,000) (111,789) (75,000) (56,000) 1,000 (140,500) (90,000) (13,095) (21,000) (12,000) 5,800 (800) (800) 0 (54 ,000) (22 ,000) (27,000) (59,000) (68,000) (7,000) (39,500) (39,500) (10,500) (24,850) (93,500) (4 ,580) (175,702) (364 ,123) (1,425) (13,950) (11 ,235) 3,135 (4,500) (7,500) (2,500) (37,000) (29 ,500) (90,000) 0 0 (5,000) (5,000) (6,200) 0 (6,867,311) (3,792,078) (3,485,094) 51 Run Date: 5/31/22 3:02 PM 2022 Approved % CHGE. Budget 2021 (35,295) (11 .76%) (5,000) 150.00% (173,000) 22 .31% (83,000) 12 .16% (18,000) 53.19% (48,719) 439 .23% (16,500) 50 .00% (5,100) 155 .00% (3,300) 106 .25% (1,527,000) 95 .13% (226,320) 216 .53% (61,000) 27.08% (7,000) 0.00% (95,000) 251 .85% 0 0 .00% (91,400) 104.11% (34,000) 240 .00% 0 0.00% (27,500) 14.58% (482,789) 30.13% (55,000) (1 .79%) (103 ,095) 14.55% (6,200) (48.33%) (800) 0 .00% (49 ,000) 122 .73% (75 ,000) 10 .29% (50,000) 26.58% (98,080) 4.90% (365,548) 0 .39% (8 ,100) (27 .90%) (10 ,000) 33 .33% (119,500) 305 .08% (5,000) 0 .00% (6,200) 0 .00% (7,277,172) 91.90% Cult. & Rec. -Admin. Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Uniforms Travel Cellular Phones Telephones Internet Advertising Subscription & Publications Seminars & Education Insurance Premium Consulting & Professional Recpt, Prom & Sp Events Memberships Photo, Mapping, Printing Build Repairs & Mtce Software/Hardware Maintenance Co1 Building Rentals Financial Service Charges Stationery & Office Supplies Program Supplies Committee Expenses Minor Furniture & Fixtures System & Software Upgrades Total Expenditures Revenues Federal Grant Ont. Specific Grants Marketing Sponsorships Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Trans . to/(from) Continuing Studies F City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 1,976,454 2,064,928 27,855 11,880 569,292 595,950 6,100 2,065 2,500 2,500 8,000 2,000 10,000 10,000 12,685 11,850 0 0 128,400 115,400 4,200 200 6,220 4,220 10,540 10,750 119,870 16,000 6,000 6,000 8,700 11,875 9,000 9,000 213,000 0 40,616 70,115 72,200 73,400 0 175,000 4,800 4,800 0 40,000 67,750 98,250 1,000 1,000 25,000 0 3,330,182 3,337,183 0 0 (50,000) (95,575) 0 0 (50,000) (95,575) (213,000) (40,000) (35,360) (16,000) 53 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE . Budget 2021 (343,020) 1,721,908 (16.61%) 8,455 20,335 71.17% (116,948) 479,002 (19.62%) 4,900 6 ,965 237.29% 0 2,500 0.00% 0 2,000 0 .00% 0 10,000 0 .00% (2,445) 9,405 (20.63%) 2,445 2,445 0 .00% 28,200 143,600 24.44% (200) 0 (100.00%) 1,780 6,000 42.18% (2,500) 8,250 (23.26%) 54,400 70,400 340.00% 3,000 9,000 50 .00% (3,725) 8,150 (31.37%) 0 9,000 0.00% 0 0 0 .00% (65,850) 4,265 (93 .92%) 0 73,400 0.00% 0 175,000 0.00% (500) 4,300 (10.42%) 392,000 432,000 980.00% (68,750) 29,500 ; (69.97%) 0 1,000 0.00% 0 0 0.00% (108,758) 3,228,425 (3.26%) (399,550) (399 ,550) 0.00% 85,575 (10,000) (89.54%) (65,000) (65 ,000) 0 .00% (378,975) (474,550) 396.52% (40,000) (80,000) 100.00% 16,000 0 (100.00%) Cult. & Rec. -Adm in. Account Descriptions Transfer to/(from) Reserve Fund Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget (37,910) 0 (286 270) (56 000) 2,993,912 3,185,608 54 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE . Budget 2021 (70,400) (70,400) 0.00% (94 400) (150 400) 168.57% (582,133) 2,603,475 (18.27%) Civic Centre Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Uniforms Telephones Internet Cable Seminars & Education Insurance Premium Ins . Deductible Consulting & Professional Outside Agency Serv Build Repairs & Mtce Misc Equip Repairs Software/Hardware Maintenance Co1 Rental Misc Equip Utilities -Water Utilities -Gas Utilities -Hydro Utilities -Cable T.V. Supplies & Tools COVID Related Expenditures Total Expenditures Revenues Vending Machines Netted Revenue Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 I 2021 Approved j, Approved Budget Budget 248,735 403,459 5,500 5,500 58,616 74,908 2 ,000 2,000 4 ,235 4,780 0 0 0 0 1,000 1 ,000 3,065 3,120 1,000 1,000 2,000 2,000 117,880 128,500 150,643 199,683 1,500 1,500 661 714 500 500 14,480 14,770 25,027 25 ,530 163,824 163,824 850 850 3 ,000 3,000 0 0 804,516 1,036,638 (500) (500) (163,802) (352,223) (164,302) (352,723) 0 0 640,214 683,915 55 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE . Budget 2021 76 ,023 479,482 18.84% 0 5,500 0.00% 27,177 102,085 36.28% 0 2,000 0 .00% (530) 4,250 (11.09%) 530 530 0 .00% 850 850 0.00% 0 1,000 0 .00% 0 3,120 0 .00% 0 1,000 0.00% 0 2,000 0.00% 2,370 130 ,870 1.84% (8,058) 191,625 (4 .04%) 0 1,500 0.00% (219) 495 (30 .67%) 0 500 0 .00% 0 14,770 0 .00% 1,275 26 ,805 4.99% 0 163,824 0 .00% (850) 0 (100.00%) 0 3,000 0 .00% 15,000 15 ,000 0.00% 113,568 1,150,206 10.96% 0 (500) 0.00% (1,425) (353,648) 0.40% (1,425) (354,148) 0.40% 0 0 0.00% 112,143 796,058 16.40% Senior Citizens Centre Account Descriptions Expenditures Salaries & Wages Overtime Employer Contri butions Uniforms Travel Cellular Phones Telephones Internet Cable Advertising Seminars & Education Insurance Premium Recpt, Prom & Sp Events Memberships Outside Agency Serv Build Repairs & Mtce Software/Hardware Maintenance Co1 Ath letic Equip . Playroom Utilities -Water Utilities -Gas Utilities -Hydro Supplies & Tools Minor Furniture & Fixtures COVID Related Expenditures Total Expenditures Revenues Federal Grant Ont. Specific Grants Programs Event Vendor Fees Sponsorships No Tax Marketing Sponsorships Total Revenues Transfers to/from Reserves & R.F. Total Transfers City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 309,509 306 ,916 6 ,000 6,000 62,236 80,259 800 1,000 800 1,000 600 600 5,105 4,725 0 0 0 0 3,000 3 ,000 5,300 5,500 2,390 2,440 / 34,500 106 ,380 825 825 9 ,580 9,280 83,640 82 ,075 2 ,710 2,430 2,300 2,300 6,920 7,050 7,780 6,280 29 ,152 29,152 2,100 2,100 600 600 0 0 575,847 659 ,912 0 (24,450) (140,400) (188,030) (53 ,000) (20 ,000) (3,800) (8,435) (500) (500) (2,000) (2,000) (199,700) (243,415) 0 0 56 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 (20,668) 286,248 (6.73%) 0 6,000 0 .00% (5 ,801) 74,458 (7.23%) 200 1,200 20.00% 0 1,000 0.00% 0 600 0.00% (1,665) 3,060 (35 .24%) 75 75 0 .00% 1,590 1,590 0.00% (2,000) 1,000 (66 .67%) 0 5 ,500 0 .00% 0 2,440 0.00% (23 ,250) 83,130 (21 .86%) 0 825 0.00% (6 ,700) 2,580 (72 .20%) (24 ,091) 57,984 (29 .35%) (65) 2 ,365 (2.67%) 0 2,300 0.00% 0 7,050 0 .00% 315 6 ,595 5.02% 0 29,152 0.00% 0 2,100 0 .00% (600) 0 (100 .00%) 4 ,000 4,000 0.00% .(78,660) 581,252 (11.92%) 24,450 0 (100.00%) (30,500) (218,530) 16.22% (2,000) (22,000) 10.00% 7,435 (1,000) (88.14%) (2 ,500) (3,000) 500.00% 0 (2,000) 0 .00% (3,115) (246,530) 1 .28% 0 0 0.00% Senior Citizens Centre Account Descriptions Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved I Approved I , Budget Budget 376,147 416,497 57 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 - (81,775) 334,722 (19.63%) Programs Account Descriptions Expend itures Salaries & Wages Salaries & Wages -Prg. Overtime Employer Contributions Uniforms Travel Cellular Phones Telephones Subscription & Publications Sem inars & Education Purch Prnting/Broch/News Ur Insurance Premium Recpt, Prom & Sp Events Memberships Outside Agency Serv Misc Equip Repairs Software/Ha rdware Maintenance Co 1 Community Use of Schools Prgm -Build Rentals Forms Event Supplies Prgms Supplies Drop -In Centre Supplies Supplies & Tools Misc. Equipment Total Expenditures Revenues Federal Grant Ont. Specific Grants Program Registrations Advertising Space Other Misc Revenue Event Vendor Fees Sponsorships No Tax Marketing Sponsorships City of Pickering 2022 Approved Current Budget 20 20 2021 Approved ' Approved 1, Budge t Budget 582,373 644,857 965 ,635 324 ,907 16 ,900 16,900 198,790 160 ,517 5,000 5 ,000 3,200 3 ,200 1,500 3 ,500 2,470 2,390 100 100 7,400 7 ,600 57,000 41 ,000 9,310 9,500 3 ,000 3,000 1,200 2,100 92 ,000 3 ,000 200 200 4,057 2,070 3,500 2 ,000 196,000 19 ,000 500 500 291 ,025 198,350 111,715 75,000 4,400 4,400 2,800 2,800 7 ,000 7 ,000 2,567 ,075 1,538,891 (49,000) (53 ,863) (14,400) (44 ,200) (1 ,944,900) (510 ,142) (22 ,000) (11 ,000) (8,350) (6 ,000) (10,150) (2 ,800) (4,000) (7 ,000) (10,000) (10,000) 58 Run Date: 5/31/22 3 :02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 89 ,807 · 734,664 13.93% 562 ,088 886 ,995 173 .00 % 0 16 ,900 0 .00% 43,042 203,559 26 .81% 0 5 ,000 . 0.00% 0 3 ,200 0.00% 500 4,000 14.29% (265) 2 ,125 (11 .09%) 0 100 0 .00% (3,450) 4 ,150 (45 .39%) 19 ,000 60,000 46.34% 0 9 ,500 0 .00% 0 3,000 0.00% (600) 1,500 (28.57%) 9 ,306 12 ,306 310 .20% 0 200 0 .00% (1,115) 955 (53.86 %) 1,500 3 ,500 75.00% 120,000 139,000 631 .58% 0 500 0 .00% 360,075 558,425 181.54% 45 ,750 120,750 61 .00% 0 4,400 0 .00% (400) 2,400 (14 .29%) (2 ,000) 5 ,000 (28 .57%) 1,243,238 2,782,129 80.79% (120 ,137) (174,000) 223 .04% (161 ,850) (206,050) 366 .18% (756,458) (1,266 ,600) 148.28% 0 (11 ,000) 0 .00 % (5,000) (11,000) 83 .33 % (4 ,300) (7,100) 153 .57% 0 (7 ,000) 0 .00% (25 ,000) (35,000) 250 .00% Programs Account Descriptions Miscellaneous Revenue Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved INC J DEC . Budget Budget 0 0 (5,000) (2,062,800) (645,005) (1,077,745) 0 0 0 504,275 893,886 165,493 59 Run Date: 5/31/22 3:02 PM 2022 Approved % CHGE . Budget 2021 (5,000) 0 .00% (1,722,750) 167.09% 0 0.00% 1,059,379 18.51% Dunba·rton Pool Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Uniforms Travel Cellular Phones Telephones Internet Seminars & Education Insurance Premium Consulting & Professional Memberships Outside Agency Serv Build Repairs & Mtce Misc Equip Repairs Software/Hardware Maintenance Co1 Stationery & Office Supplies Utilities -Gas . Supplies & Tools COVID Related Expenditures Total Expenditures Revenues Memberships-Pool/Health Club Admissions -Public Swimming Rentals -Pool Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 230,438 288 ,182 2,200 2,200 57,829 70,555 2,000 1,620 200 200 500 500 5,100 5 ,110 0 0 1,370 1 ,370 1,690 1,720 12,000 10,000 120 102 2,080 2,080 37,300 35,300 3 ,000 3,000 569 450 300 200 34 ,951 30,650 8,661 8,661 0 0 400,308 461,900 (8 ,000) (13,750) (5,000) (1,835) (110,000) (64,000) (123 ,000) (79,585) 0 0 277,308 382,315 60 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE. Budget 2021 (23,608) 264 ,574 (8.19%) 0 2,200 0 .00% (604) 69,951 (0 .86%) 380 2,000 23.46% 0 200 0.00% 540 1,040 108.00% (870) 4 ,240 (17.03%) 870 870 0 .00% 816 2,186 59 .56% 0 1,720 0.00% (10,000) 0 (100.00%) 8 110 7.84% 33 2,113 1.59% 9,615 44,915 27.24% 0 3,000 0.00% (60) 390 (13 .33%) 0 200 0 .00% 1,530 32,180 4.99% 3,000 11 ,661 34 .64% 5,000 5,000 0.00% (13,350) 448 ,550 (2.89%' 6,416 (7,334) (46.66%) (2 ,393) (4,228) 130.41% (33,624) (97,624) 52.54% (29 ,601) (109,186) 37.19% 0 0 0.00% (42,951) 339,364 (11.23%) Don Beer Arena Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Uniforms Travel Cellular Phones Telephones Internet Cable Seminars & Education Insurance Premium Ins. Deductible Consulting & Professional Memberships Outside Agency Serv Build Repairs & Mtce Misc Equip Repairs Software/Hardware Maintenance Co1 Rental Misc Equip Land Rentals Stationery & Office Supplies Utilities -Water Utilities -Gas Utilities -Hydro Supplies & Tools Minor Furniture & Fixtures Misc. Equipment COVID Related Expenditures Total Expenditures Revenues Snack Bar Vending Machines Rentals Admissions -Skating Rentals -Ice Surface City of Pickering 2022 Approved Current Budget 2020 2021 Approved .~ Approved ' Budget Budget 606,361 565,203 20,000 20,000 146,381 149,395 5,000 5,000 200 200 1,800 1,800 16,110 16,150 0 0 0 0 4,110 4,200 5,850 5,970 2,000 2,000 0 5,000 400 400 3 ,115 3,115 156,365 196,895 15,000 15,000 1,639 1,270 300 300 46,160 46,150 300 300 31,790 24,300 41,385 31,650 286,398 219,150 2,165 2,165 0 3,000 6,400 6,400 0 0 1,399,229 1,325,013 (9,850) (4,925) (4,500) (2,500) (4 ,600) (2,300) (3,500) (1,750) (1,040,000) (486,570) 61 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 82 ,514 647 ,717 14.60% 0 20,000 0 .00% 7,921 157,316 5 .30% 0 5,000 0 .00% 0 200 0.00% 0 1,800 0 .00% (810) 15,340 (5.02%) 265 265 0 .00% 545 545 0 .00% (1,100) 3,100 (26 .19%) 0 5,970 0.00% 0 2,000 0.00% (5,000) 0 (100 .00%) 0 400 0 .00% 0 3,115 0.00% (12,045) 184,850 (6 .12%) 0 15,000 0 .00% (260) 1,010 (20.47%) 0 300 0.00% 0 46,150 0 .00% 0 300 0.00% 0 24,300 0 .00% 1,585 33,235 5 .01% 0 219 ,150 0.00% 0 2,165 0 .00% 3,000 6,000 100.00% (1,600) 4,800 (25.00%) 9,000 9,000 0 .00% 84,015 1,409,028 6.34% (879) (5,804) 17.85% 0 (2,500) 0.00% (606) (2,906) 26.35% (250) (2,000) 14.29% (392,430) (879,000) 80 .65% Don Beer Arena ' Account Descriptions Rentals -Halls Arena Floor Rentals Marketing Sponsorships Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget (47,000) (27,000) (32,000) (32,000) (15,000) (7,500) (1,156,450) (564,545) 0 0 242,779 760,468 62 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 2,000 (25,000) (7.41%) (6,000) (38,000) 18.75% 0 (7,500) 0 .00% (398,165) (962,710) 70.53% 0 0 0.00% (314,150) 446,318 (41.31%) Community Centres Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Uniforms Travel Cellular Phones Telephones Internet Cable Seminars & Education Insurance Premium Ins . Deductible Consulting & Professional Outside Agency Serv Build Repairs & Mtce Veh -Repairs & Maintenance Misc Equip Repairs Software/Hardware Maintenance CoI Building Rentals Utilities -Water Utilities -Gas Utilities -Hydro Utilities -Oil Gas, Oil Tires Supplies & Tools Minor Furniture & Fixtures COVI D Related Expenditures Total Expenditures Revenues Vending Machines Rentals -West Shore C.C . Rentals -East Shore C .C. Rentals -Claremont C.C. Rentals -Petticoat Creek Other Misc Revenue City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 279,516 322,073 8,000 8,000 67,028 76,759 2,200 2,200 . 500 500 2,500 2,500 13,755 13,625 0 0 0 0 1,360 1,360 3,900 3,980 2,000 2,000 45,000 48,300 11,984 11,984 282,476 269,305 6,300 6,300 1,500 1,500 703 562 10 10 13,000 13 ,250 27,863 26,100 116,990 116,990 4,867 4,867 8,112 8,112 2,000 2,000 10,000 10,000 0 0 911,564 952,277 (1,000) (1,000) (70,901) (44,780) (56,000) (10,000) (800) (800) (54,000) (22,000) (2,500) (2,500) 63 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 (12,090) 309,983 (3 .75%) 0 8,000 0 .00% 1,517 78,276 1 .98% 0 2,200 0.00% 0 500 0.00% 0 2,500 0.00% (8,060) 5,565 (59.16%) 6,980 6,980 0.00% 1,080 1,080 0.00% 1,900 3,260 139.71% 0 3,980 0 .00% 0 2,000 0.00% (48,300) 0 (100.00%) 0 11,984 0.00% 22,760 292,065 8.45% 0 6,300 0 .00% 0 1,500 0.00% (97) 465 (17.26%) 0 10 0.00% 0 13,250 0.00% 1,305 27,405 5.00% 0 116,990 0.00% 0 4,867 0.00% 3,038 11,150 37.45% 0 2,000 0.00% 0 10,000 0.00% 12,000 12,000 0 .00% (17,967) 934,310 (1.89%) 0 (1,000) 0 .00% (46,620) (91,400) 104.11% (24,000) (34,000) 240.00% 0 (800) 0 .00% (27,000) (49,000) 122.73% 420 (2,080) (16 .80%) Community Centres Account Descriptions Netted Revenue Total Revenues Transfers to/from Reserves & R.F. Trans. to/(from) Continuing Studies F Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved ' Approved Budget Budget (11,900) (11,900) (197,101) (92,980) 0 (1 ,600) 0 (1 600) 714,463 857,697 64 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 0 (11,900) 0.00% (97 ,200) (190,180) 104.54% 1 ,600 0 (100 .00%) 1 600 0 (100.00%1 (113,567) 744,130 (13.24%) City of Pickering 2022 Approved Current Budget Recreation Complex -Central Core 2020 2021 Account Descriptions Approved Approved Budget Budget Expenditures Salaries & Wages 2,069,185 1,799,633 Overtime 47,000 32 ,000 Employer Contributions 483,309 521,254 Uniforms 12,000 8,000 Travel 1,300 800 Cellular Phones 8,000 8,650 Telephones 13,995 12,725 Internet 0 0 Advertising 31,000 15,000 Subscription & Publications 250 250 Seminars & Education 10,175 5,925 Insurance Premium 13,305 13,570 Ins . Deductible 4,000 4,000 Consulting & Professional 13,870 0 Recpt, Prom & Sp Events 9,000 2 ,500 Memberships 2,865 2 ,865 Outside Agency Serv 74,941 63,491 Build Repairs & Mtce 263,591 213,965 Misc Equip Repairs 40,450 28 ,210 Software/Hardware Maintenance CoI 16,696 15,000 Rental Misc Equip 8,000 2,000 Stationery & Office Supplies 8,000 3,100 Forms 1,100 1,100 Supplies -Special Events 4 ,000 1,000 Utilities -Water 53,475 38,180 Utilities -Gas 61,216 43,700 Utilities -Hydro 276,664 254,000 Supplies & Tools 38,975 26 ,200 Minor Furniture & Fixtures 12,000 15,000 COVID Related Expenditures 0 0 Total Expenditures 3,578,362 3,132,118 Revenues Vending Machines (10,000) (10 ,000) Child Supervision (30,000) 0 Fitness Testing (70,000) (40,000) 65 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 405,241 2 ,204,874 22.52% 41,844 73,844 130.76% 24,161 545,415 4 .64% 1,000 9,000 12.50% 0 800 0 .00% 0 8,650 0 .00% (1,065) 11,660 (8 .37%) 1,065 1,065 0.00% 16,000 _31,000 106.67% 0 250 0 .00% 156 6,081 2 .63% 0 13 ,570 0.00% 0 4,000 0 .00% 0 0 0 .00% 10,500 13,000 420.00% 225 3,090 7.85% (6,000) 57,491 (9.45%) 13,685 227,650 6.40% 19,265 47,475 68.29% (4,780) 10,220 (31.87%) 6,000 8,000 300.00% 0 3,100 0.00% 0 1,100 0 .00% 0 1,000 0.00% 0 38,180 0.00% 2,185 45 ,885 5 .00% 0 254,000 0 .00% 0 26,200 0 .00% 12,000 27,000 80 .00% 14,000 14,000 0 .00% 555,482 3,687,600 17.74% 0 (10,000) 0 .00% (20,000) (20,000) 0 .00% 4,705 (35,295) (11 .76%) City of Pickering 2022 Approved Current Budget Recreation Complex -Central Core 2020 2021 Account Descriptions Approved Approved Budget Budget Admissions -Tennis (92,000) (74 ,000) Admissions -Squash (21,000) (11,000) Admissions -Fitness Room (6,500) (2,000) Admissions -Racquet Ball (5,000) (1,600) Rentals -Mtg. Room/Public (27,000) (7,000) Rentals -Mtg . Room/Prog . (27,000) (7,000) Rentals -Halls (102,000) 0 Rentals -Lockers (100) 0 Membertships -Tennis (24,000) (24,000) Memberships -Pool/Health Club (621,000) (365,000) Memberships -Squash (75,000) (56,000) Memberships -General (140,500) (90,000) · Memberships -Racquet Ball (21,000) (12,000) Rentals -Wellness Clinic (59,000) (68,000) Other Misc Revenue (14,000) (85,000) Other Revenue -Membership NSF F (5,000) (6,200) Total Revenues (1,350,100) (858,800) Transfers to/from Reserves & R.F. Transfer to/(from) Reserve (92,500) 0 Trans . to/(from) Continuing Studies F (3,870) 0 Total Transfers (96 370) 0 Net 2,131,892 2,273,318 66 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 (9,000) (83 ,000) 12 .16% (5,500) (16,500) 50 .00% (3,100) (5,100) 155.00% (1,700) (3,300) 106 .25% (19 ,000) (26,000) 271.43% 0 (7,000) 0.00% (70,000) (70,000) 0.00% 0 0 0.00% (3,500) (27 ,500) 14.58% (76,374) (441 ,374) 20.92% 1,000 (55,000) (1 .79%) (13 ,095) (103,095) 14 .55% . 5,800 (6,200) (48 .33%) (7,000) (75,000) 10.29% 0 (85,000) 0 .00% 0 (6,200) 0 .00% (216,764) (1,075,564) 25.24% 0 0 0 .00% 0 0 0.00% 0 0 0.00% 338,718 2,612,036 14.90% Recreation Complex -Pool Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Uniforms Travel Telephones Internet Seminars & Education Insurance Premium Consulting & Professional Memberships Build Repairs & Mtce Misc Equip Repairs Software/Hardware Maintenance Co1 Utilities -Water Utilities -Gas Utilities -Hydro Supplies & Tools COVID Related Expenditures Total Expenditures Revenues Admissions -Public Swimming Rentals -Pool Rentals -Pool-School Board Memberships -Pool/Health Club Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Trans. to/(from) Continuing Studies F Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved . Approved Budget Budget 452,214 195,984 10,000 5,000 . 82,938 68,006 5,000 2,688 225 225 705 680 0 0 2,815 670 4,540 4,630 1,250 0 120 102 92,900 71 ,950 2,000 1,000 1,122 785 53,680 43,800 61,216 43,700 202,098 165,000 11,500 7,650 0 0 984,323 611,870 (52,000) (7,200) (166,000) (7,500) (1,258) 0 (58 ,000) (6,000) (277,258) (20,700) (9,000) 0 (1,250) 0 (10 250) 0 696,815 591,170 67 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 298,909 494,893 152 .52% 0 5,000 0.00% 32 ,552 100,558 47.87% 2,312 5,000 86.01% 0 225 0.00% (75) 605 (11 .03%) 75 75 0.00% 1,612 2,282 240 .60% 0 4,630 0.00% 0 0 0 .00% 8 110 7.84% (2,000) 69,950 (2 .78%) 0 1,000 0 .00% 25 810 3.18% 10,950 54,750 25.00% 2,185 45 ,885 5.00% 0 165 ,000 0.00% 0 7 ,650 0 .00% 5,000 5,000 0 .00% 351,553 963,423 57.46% (37,291) (44,491) 517 .93% (121,196) (128,696) 1 ,615.95% 0 0 0 .00% (35,415) (41,415) 590.25% (193,902) (214,602) 936.72% 0 0 0.00% 0 0 0 .00% 0 0 0.00% 157,651 748,821 26.67% Recreation Complex -Arenas Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Uniforms Cellular Phones Telephones Internet Cable Seminars & Education Insurance Premium Ins . Deductible Consulting & Professional Outside Agency Serv Build Repairs & Mtce Misc Equip Repairs Software/Hardware Maintenance Co I Rental Misc Equip Stationery & Office Supplies Forms Utilities -Water Utilities -Gas Utilities -Hydro Supplies & Tools Minor Furniture & Fixtures COVID Related Expenditures Total Expenditures Revenues Snack Bar Vending Machines Advertising Space Admissions -Skating Rentals -Ice Surface Rentals -Mtg . Room/Public Arena Floor Rentals Marketing Sponsorships City of Pickering 2022 Approved Current Budget 2020 2021 Approved I Approved Budget Budget 490,610 411,030 25,000 16,665 117,972 112,053 4,000 4,000 1,000 1,000 5,465 5,430 0 0 0 0 3 ,650 3,675 4,420 4,510 2 ,000 2,000 11 ,995 0 1,100 1,100 159,545 148,606 7,000 7,000 1,274 737 800 800 650 650 300 300 15,920 11,070 20,548 14,000 217,191 181,000 3,335 3,335 0 3,000 0 0 1,093,775 931,961 (4,000) (4,000) (1,500) (1,500) (55,000) (55,000) (20,000) (10,000) (812,000) (296,000) (42 ,000) (30,000) (7,500) (7,500) (10 ,000) (10,000) 68 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 108,681 519,711 26.44% 8,335 25,000 50 .02% 17 ,384 129,437 15.51% 400 4,400 10.00% 0 1,000 0 .00% (3,520) 1,910 (64.83%) 1,600 1,600 0.00% 1,920 1,920 0 .00% (800) 2,875 (21.77%) 0 4,510 0 .00% 0 2,000 0.00% 0 0 0 .00% 0 1 ,100 0.00% 14 ,955 163,561 10.06% 0 7,000 0.00% 78 815 10.58% 0 800 0 .00% 0 650 0 .00% 0 300 0.00% 0 11,070 0 .00% 700 14,700 5.00% 0 181,000 0.00% 0 3,335 0 .00% 3,000 6,000 100.00% 9,000 9,000 0.00% 161,733 1,093,694 17.35% 150 (3,850) (3 .75%) 0 (1,500) 0 .00% 0 (55,000) 0.00% (6,000) (16 ,000) 60 .00% (352,000) (648,000) 118 .92% 6,000 (24,000) (20 .00%) (4,500) (12,000) 60 .00% 0 (10,000) 0.00% Recreation Complex -Arenas Account Descriptions Total Revenues Transfers to/from Reserves & R.F. Trans . to/(from) Continuing Studies F Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget (952,000) (414,000) (1,995) 0 (1 995) 0 139,780 517,961 69 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 (356,350) (770,350) 86.07% 0 0 0.00% 0 0 0 .00% (194,617) 323,344 (37.57%) Museum Account Descr iptions Expenditures Salaries & Wages Overtime Employer Contributions Uniforms Travel Freight, Express & Cartage Cellular Phones Telephones Internet Advertising Trade Shows , Exhib & Displays Seminars & Education Insurance Prem ium Consulting & Professional Recpt, Prom & Sp Events Memberships Outside Agency Serv Build Repairs & Mtce Veh -Repairs & Maintenance Misc Equip Repairs Software/Hardware Maintenance Co I Antiques Repairs Mtce. Grounds Upkeep Stationery & Office Supplies Program Supplies Supplies -Special Events Antique Purchases Gift Shop Plaques Uti lities -Gas Utilities -Hydro Util ities -Oil Gas , Oil Tires Supplies & Tools COVID Related Expenditures Total Expenditures City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 682,179 712 ,716 3 ,000 3,000 150,214 153,606 6,000 6,000 3 ,000 1 ,500 2,500 2,500 5 ,900 5 ,900 20 ,910 21,470 0 0 98,000 98,000 1 ,200 61 ,700 6,200 3 ,800 3 ,950 4,030 18 ,000 14,000 10,500 5 ,500 2,187 2,027 5 ,255 5,255 99 ,415 100,165 5,000 5 ,000 5,000 3,000 2 ,762 2,265 8,700 13 ,700 2 ,800 2,800 2 ,500 2 ,500 12 ,255 12,255 10,500 10,580 600 600 5 ,250 2 ,625 7,510 7,510 25,044 25,545 816 816 1,963 1,963 1,000 1,000 0 0 1,210,110 1,293,328 70 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 271 ,158 983,874 38 .05% (2,000) 1,000 (66 .67%) 38,880 192,486 25.31% 1,560 7 ,560 26 .00% 6 ,000 7 ,500 400.00% 0 2 ,500 0 .00% 600 6,500 10.17% (1 ,635) 19 ,835 (7 .62%) 1,635 1,635 0 .00% 54 ,200 152,200 55.31% 148 ,600 210 ,300 240.84% 1,200 5 ,000 31 .58 % 0 4 ,030 0.00% 66 ,000 80 ,000 471.43% 0 5,500 0 .00% 0 2,027 0 .00% 0 5 ,255 0 .00% 16,000 116,165 15.97% (1,000) 4 ,000 (20.00%) 0 3 ,000 0 .00% 2,470 4,735 109.05 % (5,000) 8 ,700 (36 .50%) 0 2,800 0.00% 0 2 ,500 0 .00% (8 ,255) 4 ,000 (67 .36%) 23,420 34 ,000 221 .36% 0 600 0 .00% 2,375 5 ,000 90.48% 375 7 ,885 4.99 % 0 25,545 0.00% 0 816 0 .00% 737 2 ,700 37.54% (500) 500 (50 .00%) 5,000 5 ,000 0 .00% 621,820 1,915,148 48.08% Museum Account Descriptions Revenues Federal Grant Ont. Specific Grants Gift Shop Snack Bar Programs Donations Admissions -Public & Edu . Rentals -Mtg . Room/Public Total Revenµes Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 I 2021 , Approved Approved Budget Budget (98,000) (183 ,000) (39,000) (64,500) (10,500) (5,250) (3,100) (1,000) (23,560) (16,560) (2,000) (2,000) (141,440) (141,440) (17,000) (11,000) (334,600) (424,750) 0 (8,000) 0 (8,000) 875,510 860,578 71 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 (574,102) (757,102) 313 .72% (117,400) (181,900) 182.02% (6,350) (11,600) 120.95% (1,000) (2,000) 100.00% 1,560 (15,000) (9.42%) (3,000) (5,000) 150.00% (31 ,560) (173,000) 22.31% 0 (11,000) 0 .00% (731,852) (1,156,602) 172.30% (2 ,000) (10,000) 25.00% (2 000) (10 000) 25.00% (112,032) 748,546 (13.02%) Pickering Arts Centre Account Descriptions Expenditures Salaries & Wages Employer Contributions Conferences Travel Cellular Phones Software/Hardware Maintenance CoI Stationery & Office Supplies Total Expenditures Revenues Total Revenues . Transfers to/from Reserves & R .F. Transfer to/(from) Reserve Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved II Approved Budget Budget 106,385 32 ,715 29,911 15,048 1,500 1 ,500 1 ,000 1,000 1,000 1,000 0 55 500 500 140,296 51,818 0 0 0 (51,818) 0 (51 818) 140,296 0 72 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 (32 ,715) 0 (100.00%) (15 ,048) 0 (100.00%) (1 ,500) 0 (100 .00%) (1 ,000) 0 (100.00%) (1,000) 0 (100.00%) (55) 0 (100.00%) (500) 0 (100.00%) (51,818) 0 (100.00%) 0 0 0.00% 51 ,818 0 (100.00%) 51 818 0 (100.00%) 0 0 0.00% Operations Department Overview In 2021, the City merged Public Works, Facilities Capital Projects, Corporate Security, and Energy Management into a new Operations Department. Operations Services consists of: • Facilities Capital Projects -responsible for managing capital lifecycle replacements for all City facilities, renovations and new construction projects. • Corporate Security -responsible for the centralized management and integration of security into our facilities, events and infrastructure. • Energy Management -responsible for the City's Corporate Energy Management Plan that is the City's policy for energy efficiency and savings across all City facilities and operations. Public Works is responsible for the repair and maintenance of roads; winter control operations; maintenance of playgrounds; boulevard and parkland grass cutting; maintaining green space; and, managing the City's municipal fleet. The Operations Centre is located at 1955 Clements Road, next to the Pickering Soccer Centre. [ [ Public Works ~ I Operations Property Admin. Maintenance Operations Department ) ] "" Parks Operations Services Facilities Capital Projects Energy Management Fleet Services 6 Corporate Security Key Activities for 2022 Public Works • Adding the maintenance of 16 km of new roads, 11 km of new sidewalks and multi- use paths, and 5 new parks due to Seaton and infill development 73 • Re-structuring winter control, adding 1 new road plow route and 1 new sidewalk route • Assuming 2 new stormwater management ponds • Implementation of the embedded Automotive Parts Supply & Inventory Management System • Development and implementation of the Public Works work order management system, including levels of service by activity, benchmarking, and dashboard reporting • Continued development of the Parks asset management, including the input of the remaining 25 percent of the 85 parks into the VFA Asset Management software solution • Extending the pre-emptive winter anti-icing (direct liquid application) program on Collector and Local roads to enhance winter control • Continuing the conversion of gas vehicle and equipment to electric, including new vehicles for Bylaw and Building Services, and Parks & Property electric zero turn mowers and electric hand held equipment • Continuing the Parks sports field LED lighting conversion program for Kinsmen Park South East and South West baseball diamonds Facilities Capital Projects • Complete construction of Fire Station #1 and Headquarters, located on Zents Drive • Commence design work for Fire Station #5 replacement, located on Bayly Street, to be tender-ready for early 2023 • Commence design work for new Animal Shelter, including stakeholder consultation • Implement, manage, and advance to completion facilities capital projects in the approved 2022 Capital budget Corporate Security • Create a Business Continuity Plan template for the Operations Department • Develop a Corporate Security Policy for the City • Review and update security procedures • Leverage the Security Committee to drive proactive security projects Energy Management Implement year 3 of the 5-year Corporate Energy Management Plan. Provide technical support for facilities capital projects 74 Financial Information Staffing Summary (Full & Regular Part Time) Approved Current Term 2018 2019 2020 2021 Full Time Reg. Part-Time Total 68 3 71 71 4 75 81 J 84 81 J 84 Add 9 Q 9 A d pprove 2022 Delete Total 0 90 Q 3 0 93 With the creation of the new Operations Department in 2021, seven full-time positions were transferred from Community Services Department and one full-time position was transferred from the City Development Department to the new Operations Department. The department proposes one new full-time Apprentice Mechanic position to support fleet maintenance due to the growth in vehicles and equipment, and one new full-time Utility Cut Inspector contract position (funded by Third Party). Year-Over-Year (Net Cost) Budget Changes 2021 Budget 2022 Approved Budget YearNear Increase ($) (%) Operations -Adm. $1,455,554 $1,455,554 Public Works -Adm. 1,087,272 1,007,075 (80,197) Property Maintenance 1,309,148 1,355,018 45,870 Fleet Services 1,637,306 1,892,597 255,291 Roads 7,650,239 8,190,753 540,514 Parks 4,723,595 5,194,025 470,430 0.00% (7.38) 3.50 15.59 7.07 9.96 16.38% Total (Net Cost) $16,407,560 $19,095,022 $2,687,462 ==================================== Explanation of Significant Budget Changes Expenditures -Increases/ (Decreases) Salaries & Wages $1,087,619 -Budget increase largely reflects Operations Administration salaries of $794,233 transferred from Community Services as part of the reorganization and formation of the Operations Department. 75 Overtime $104,000 -Budget increase due to overtime for Parks & Roads re-instated to the budget to support the return of in-person Community Services events. Employer Contributions $313,021 -Budget increase largely reflects the transfer of Operations Administration staff to Operations from Community Services. Uniforms $6,145 -Budget increase due to the transfer of Operations Administration staff to Operations from Community Services. Seminars & Education $52,200 -Budget increase reflects reinstatement of pre- COVID budget for in-person training for regulatory and mandatory training much of which was suspended since 2020. Operations Administration staff budget of $9,450 transferred from Community Services. Consulting & Professional $189,235 -Budget increase due to the transfer of Operations Administration budget to Operations from Community Services. Photo, Mapping, Printing $9,000 -Budget increase due to the transfer of Operations Administration budget to Operations from Community Services. Outside Agency Services $165,312 -Budget increase reflects transfer of $4,000 from Community Services for Operations Administration and $145,000 budgeted in Fleet Services for the new Parts Supplier fees. Repairs & Maintenance -Winter Control $26,000 -Budget increase due to an increase in the supply price of road salt. Repairs & Maintenance -Contract Services $142,000 -Budget increase reflects contract re-instated to pre-Covid. Phragmites Control pilot program re-instated to budget. Bridges/culverts/embankment repairs increased to deal with backlog of work. Rpr Main. Maint Mater $50,000 -Budget increase reflects an increase in guiderails in house repairs for 2022. Building Repairs & Maintenance $68,340 -Budget increased because the new Operations Centre construction warranty has expired. $59,000 added for annual repairs and maintenance budget. Misc. Equipment Repairs $10,000 -Budget increase due to an increase in repairs for addition of new equipment added to the inventory in 2021. 76 Software/Hardware Maintenance Contracts $70,505 -Budget increase reflects $68,000 transferred from Community Services to Operations Administration for asset management software. $5,000 transferred from City Development for EV charging online services. Grounds Upkeep $147,000 -Budget increase due to $100,000 budgeted for mechanical harvesting of Eurasian Water-Milfoil Weeds in Frenchman's Bay and $55,000 added for playground safety surfacing and grounds upkeep reinstated to pre- COVID level of service. Rental Misc. Equipment $100,500 -Budget increase reflects reinstatement of rental vehicle required for seasonal staff. Program Supplies $(65,000) -Budget decrease due to reduction in Senior Snow program. Gas, Oil, Tires $195,507 -Budget increase due to anticipated higher gasoline and diesel prices in 2022. Fertilizer, Grass, etc. $17,000 -Budget increase reflects reinstatement of the pre- COVID level of service. Misc. Equipment $67,700 -Budget increase includes impact tool added for playgrounds safety surfacing testing, new electric trimmers, new battery packs for electric equipment, security cameras in selected parks locations and City pit gate security. Other Minor Fixed Assets $45,000 -Budget increase for accessibility playground equipment. COVID Related Expenditures $71,053 -Budget increase for enhanced cleaning services provided by Community Services maintenance staff. Revenues/Transfer from Reserves -(Increases)/ Decreases Cost Recoveries ($118,550) -Budget increase reflects cost recovery of new contract Utility Cut Inspector position. Other Revenue -Rebates/Incentive ($40,000) -Budget increase due to Green initiatives/incentives and rebates transferred from City Development. 77 Rental -CCC Roof Solar Panel ($6,000) -Budget increase reflects rental revenue transferred from City Development. Department 2020 & 2021 Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 Fleet Services Work orders completed -Fire Services 462 work 153 work orders orders Work orders completed -other Departments 1,821 work 1,304 work orders orders Vehicles maintained -cars, trucks, dump truck, 210 218 snow ploughs, trailer, fire truck, tractors Attachments maintained -wings, ploughs, salters, 69 72 ball groomers, beach groomers, etc. Small equipment maintained -mowers, chain 373 407 saws, trimmers, etc. Parks Garbage picked up/disposed 200,180 kg 186,600 kg Sidewalk winter control response 27 events 11 events Maintains open space 1,940 acres 1,940 acres Maintains parks 85 85 Maintains playgrounds 63 63 Maintains splash pads 3 3 Maintains sports fields -soccer, baseball, artificial 64 fields 64 fields turf, cricket pitch Roads Roadways maintained 347 km paved 352 km paved 102 km gravel 102 km gravel Minimum Maintenance Standards roadway patrol 7,220 km 7,687 km (cumulative) (cumulative) Minimum Maintenance Standards potholes 3,312 potholes 2,479 potholes repaired Winter control response 39 events 30 events Road salt used 4,335 tonnes 3,140 tonnes Road sand used 1,713 tonnes 2,117 tonnes Road sweepings picked up/disposed 1,500 tonnes 1,200 tonnes 78 Performance Indicators/Statistics 2020 Facilities Capital Projects Number of Capital Projects 1 43 Average Value per Project1 $801,000 Facility Condition Index (Overall Portfolio)2 0.25 Total Replacement Cost of Building Assets2 $251 million Property Maintenance Seniors sidewalk clearing program response/ 13 events/ registrations 388 registrants Corporate Security Security Incident Reports Submitted 72 New/Replacement Security Cameras Installed 35 Security Video Requests 14 1 Includes facility-based capital projects managed by Operations on behalf of other departments. Excludes carryover projects from previous years. 2021 34 $395,000 0.26 $251 million 6 events/ 379 registrants 121 57 26 2 As of January 1 of the respective year, based on VFA Facilities database. Excludes buildings and amenities in parks, and the City Centre projects. 79 Public Works -Admin. Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Uniforms Travel Cellular Phones Telephones Internet Subscription .& Publications Seminars & Education Insurance Premium Ins . Deductible Consulting & Professional Recpt, Prom & Sp Events Memberships Outside Agency Serv Build Repairs & Mtce Software/Hardware Maintenance CoI Stationery & Office Supplies Utilities -Water Utilities -Gas Utilities -Hydro Minor Furniture & Fixtures COVID Related Expenditures Total Expenditures Revenues Vending Machines Netted Revenue Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 , Approved Current Budget 2020 2021 Approved i Approved Budget Budget 676,447 606,180 2,000 4,000 178,866 159,116 1,200 1,200 250 250 800 1,600 4,235 4,095 0 0 4,000 12,200 4,450 4,650 45,426 46,335 2,000 2,000 10,000 12,000 1,500 1 ,500 1,500 1,200 5,100 5 ,100 101,000 183,011 25 ,948 27,405 11,000 11,000 6,500 6,630 27 ,115 51,650 95,955 120,000 1,000 2 ,000 0 0 1,206,292 1,263,122 (500) (500) (175,350) (175,350) (175,850) (175,850) 0 0 1,030,442 1,087,272 83 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 (122,671) 483,509 (20 .24%) 0 4,000 0.00% (35,426) 123,690 (22.26%) 300 1,500 25.00% 0 250 0.00% 0 1,600 0 .00% (455) 3,640 (11 .11%) 455 455 0.00% 0 12,200 0 .00% 2,500 7 ,150 53.76% (26,425) 19,910 (57.03%) 0 2,000 0 .00% 0 12,000 0.00% 0 1,500 0.00% 0 1,200 0.00% 312 5,412 6.12% 59,915 242,926 32.74% 2,695 30,100 9 .83% 0 11,000 0 .00% 4,970 11,600 74.96% 2,580 54,230 5.00% 0 120,000 0.00% 0 2 ,000 0 .00% 31,053 31,053 0.00% (80,197) 1,182,925 (6.35%) 0 (500) 0 .00% 0 (175,350) 0.00% 0 (175,850) 0.00% 0 o· 0.00% (80,197) 1,007,075 (7.38%) Property Maintenance Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Uniforms Cellular Phones Telephones Internet Seminars & Education Insurance Premium Consulting & Professional Recpt, Prom & Sp Events Outside Agency Serv Tree Maintenance Lighting & Repair Maint. Veh -Repairs & Maintenance Misc Equip Repairs Software/Hardware Maintenance Co1 Grounds Upkeep Rental Misc Equip Land Rentals Program Supplies Gas, Oil Tires Supplies & Tools Misc. Equipment Other Minor Fixed Assets Taxes Tenant Total Expenditures Revenues Other Misc Revenue Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Trans. to/(from) Continuing Studies F Transfer to/(from) Reserve Fund Total Transfers City of Pickering 2022 Approved Current Budget 2020 2021 Approved ' Approved Budget Budget 408,696 452,598 30,000 26,000 87,743 115,103 2,630 2,630 1 ,800 4,800 350 345 0 0 1,435 135 4,130 4,210 20,000 35,765 150 200 4,550 8,000 140,000 155,000 20,000 20,000 4,000 4,000 30,000 30,000 963 770 30,360 70,000 23,000 23,000 21,696 21,696 315,000 330,000 21 ,061 21,061 1,000 2,500 10,080 9,600 20,000 25,000 2,500 2,500 1,201,144 1,364,913 (25,000) (25,000) (25,000) (25,000) 0 0 (3,360) (15,765) (15,000) (15,000) (18 360) (30 765) 84 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 (12,053) 440 ,545 (2.66%) 4,000 30,000 15.38% 1,049 116,152 0 .91% 0 2,630 0 .00% (1,140) 3,660 (23 .75%) (40) 305 (11 .59%) 40 40 0 .00% 1,375 1,510 1,018.52% 0 4,210 0.00% (15,765) 20,000 (44 .08%) 0 200 0.00% 0 8,000 0 .00% 35,000 190,000 22 .58% 0 20,000 0 .00% 2,000 6,000 50 .00% 10,000 40,000 33.33% (50) 720 (6.49%) 50,000 120,000 71.43% 5,000 28,000 21.74% 0 21,696 0 .00% (58,000) 272,000 (17 .58%) 7,889 28,950 37.46% 0 2,500 0.00% 40,800 50,400 425 .00% 10,000 35,000 40 .00% 0 2,500 0.00% 80,105 1,445,018 5.87% 0 (25,000) 0.00% 0 (25,000) 0.00% (50 ,000) (50,000) 0.00% 15,765 0 (100.00%) 0 (15 ,000) 0 .00% (34 235) (65 000) 111.28% Property Maintenance Account Descriptions Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved . Budget Budget 1,157,784 1,309,148 85 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 45,870 1,355,018 3.50% Fleet Services Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Uniforms Travel Freight, Express & Cartage Environmental Charges Cellular Phones Telephones Internet Subscription & Publications Seminars & Education Insurance Premium Recpt, Prom & Sp Events Memberships Outside Agency Serv Build Repairs & Mtce Veh -Repairs & Maintenance Misc Equip Repairs Software/Hardware Maintenance Co, Rental Misc Equip Forms Gas, Oil Tires Supplies & Tools Shop Supplies Misc. Equipment Total Expenditures Revenues Netted Revenue Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved : Approved Budget Budget 1,123,913 1,218,843 30,000 45 ,000 320,396 361,661 20,465 23,800 550 550 1,800 1,800 500 500 1 ,600 4,200 17,390 17,300 0 0 200 200 15,500 19,900 4,955 5,050 800 800 1,660 2,200 500 5,500 0 0 8 ,000 8,000 5,000 5,000 54,872 42,470 500 500 2,000 2,000 6,032 6 ,032 8,500 8,500 49,500 49,500 1,000 1,000 1,675,633 1,830,306 (193,000) (193,000) (193,000) (193,000) 0 0 1,482,633 1,637,306 86 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE . Budget 2021 76,228 1,295,071 6.25% 0 45 ,000 0 .00% 25,500 387 ,161 7.05% 1,600 25,400 6.72% 0 550 0 .00% 0 1,800 0 .00% 1,500 2,000 300 .00% (1,800) 2,400 (42.86%) (305) 16,995 (1 .76%) 305 305 0.00% 0 200 0 .00% 0 19,900 0.00% 0 5,050 0.00% 0 800 0.00% 200 2,400 9.09% 140,000 145,500 2,545.45% 5,000 5,000 0.00% 0 8,000 0.00% 0 5,000 0.00% (70) 42,400 (0 .16%) 0 500 0.00% 0 2,000 0 .00% 2,258 8,290 37.43% 4,875 13,375 57.35% 0 49,500 0 .00% 0 1,000 0.00% 255,291 2,085,597 13.95% 0 (193 ,000) 0.00% 0 (193,000) 0.00% 0 0 0.00% 255,291 1,892,597 15.59% Roads Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Uniforms Travel Cellular Phones Telephones Internet Subscription & Publications Seminars & Education Insurance Premium Ins. Deductible Consulting & Professional Recpt, Prom & Sp Events Memberships Outside Agency Serv Rpr & Mnt -Winter Control Rpr & Mnt -Contract Services Rpr Main. Maint Mater Engineering Rpr & Mnt Highway Aids -Repair Maint. Build Repairs & Mtce Tree Maintenance Veh -Repairs & Maintenance Misc Equip Repairs Software/Hardware Maintenance Co I Rental Misc Equip Utilities -Water Small Tools Gas, Oil Tires Misc. Equipment Total Expenditures Revenues Sale of Services -Public Works Federal Grant City of Pickering 2022 Approved Current Budget 2020 202 1 Approved I Approved Budget Budget 3,043,196 3,136 ,204 2a5·,ooo 259,500 804,870 827 ,592 27,220 27,220 500 500 7,800 9,800 2,825 3,070 0 0 200 200 23 ,000 5 ,250 143,762 150,950 25,000 25,000 0 0 4,000 4,000 3,740 4,040 39,500 34,000 755,000 805 ,000 180,000 155,000 525,000 525,000 787,000 757,000 75,000 75 ,000 135,450 135,450 125,000 125,000 340,000 340,000 120,000 120,000 9,282 7,420 31,500 6,500 8 ,000 14,000 8,000 10,000 347 ,543 347,543 19,500 4,000 7,876,888 7,914,239 (180,000) (180,000) (9,000) (9,000) 87 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 138,817 3,275,021 4.43% 27,000 286,500 10.40% 41,755 869,347 5.05% 290 27,510 1.07% 0 500 0 .00% 550 10,350 5.61% (340) 2,730 (11 .07%) 340 340 0 .00% 0 200 0.00% 18 ,375 23,625 350_.00% 0 150,950 0 .00% 0 25 ,000 0 .00% 5,000 5,000 0 .00% 0 4,000 0 .00% 200 4,240 4 .95% 19,000 53 ,000 55 .88% 26,000 831,000 3.23% 92,000 247 ,000 59.35% 50,000 (575,000 9 .52% 58 ,000 815,000 7.66% 0 75,000 0.00% 0 135,450 0 .00% 25,000 150,000 20.00% 0 340,000 0.00% 0 120,000 0 .00% 10 7,430 0.13% 23,500 30,000 361 .54% 0 14,000 0.00% 5,000 15,000 50 .00% 130,567 · 478 ,110 37 .57% 8 ,000 12,000 200 .00% 669,064 8,583,303 8.45% 0 (180,000) 0 .00% 0 (9,000) 0 .00% Roads Account Descriptions Other Misc Revenue Cost Recoveries Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Transfer to/(from) Reserve Fund Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved , Budget Budget (105,000) (75,000) 0 0 (294,000) (264,000) 0 0 (110,000) 0 (110000\ 0 7,472,888 7,650,239 88 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 0 (75,000) 0 .00% (118,550) (118,550) 0 .00% (118,550) (382,550) 44.91% (10,000) (10,000) 0 .00% 0 0 0.00% 110 000\ (10 000\ 0.00% 540,514 8,190,753 7.07% Parks Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Uniforms Travel Cellular Phones Telephones Internet Seminars & Education Insurance Premium Ins . Deductible Consulting & Professional Recpt, Prom & Sp Events Memberships Photo, Mapping, Printing Outside Agency Serv Rpr & Mnt -Contract Services Parks Repairs & Maintenance Build Repairs & Mtce Tree Maintenance Veh -Repairs & Maintenance Misc Equip Repairs Software/Hardware Maintenance Co1 Grounds Upkeep Rental Misc Equip Program Supplies Utilities -Water Utilities -Hydro Gas, Oil Tires Fertilizer, Grass Etc. Supplies & Tools Misc. Equipment Other Minor Fixed Assets Taxes Tenant COVID Related Expenditures City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 2,411,074 2,427,353 100,000 50,000 574,305 576,923 29,000 29,000 500 500 6,500 7,300 4,775 4,890 0 0 19 ,850 2,550 17,500 17,850 7,050 7,050 27 ,840 12,000 1,100 1,100 3,670 4,190 200 200 38,000 52,200 0 0 60,000 60 ,000 87,900 174,460 125,000 105,000 73,000 94,000 80,000 80,000 12,037 10,535 289,500 255,500 72,800 100,800 93,000 113,000 65,305 66,600 99,227 99 ,227 145,867 145,867 42,000 42,000 1,000 1,000 23,343 42,000 50,000 75,000 256,145 233,500 0 0 89 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 101,081 2 ,528,434 4.16% 68,000 118 ,000 136.00% 9,466 586 ,389 1 .64% 0 29,000 0 .00% 0 500 0 .00% 0 7,300 0 .00% (2,030) 2,860 (41 .51%) 2,030 2,030 0 .00% 20,500 23,050 803 .92% 0 17,850 0 .00% 0 7,050 0 .00% 3,000 15,000 25.00% 0 1,100 0.00% (1,070) 3,120 (25 .54%) 0 200 0 .00% 2,000 54,200 3.83% 50,000 50,000 0.00% 5,000 65,000 8 .33% 1,425 175,885 0 .82% (25,000) 80 ,000 (23 .81%) 0 94,000 0.00% 0 80,000 0 .00% (265) 10,270 (2 .52%) 97,000 352,500 37 .96% 72,000 172,800 71.43% (7,000) 106,000 (6 .19%) 0 66 ,600 0.00% 0 99,227 0.00% 54,793 200,660 37.56% 17,000 59,000 40.48% 1,500 2 ,500 150.00% 18 ,900 60,900 45.00% 35,000 110,000 46 .67% 0 233 ,500 0 .00% 40,000 40,000 0 .00% Parks Account Descriptions Total Expenditures Revenues Federal Grant Rentals Programs Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Trans. to/(from) Continuing Studies F Transfer to/(from) Reserve Fund Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 4,817,488 4,891,595 (9,000) (9,000) (210,000) (104,000) (40,000) (40,000) (259,000) (153,000) 0 0 (7,840) 0 (35,000) (15,000) (42 840) (15 000) 4,515,648 4 ,723,595 90 Run Date: 5/31/22 3:02 PM 2022 INC ./DEC . Approved % CHGE. Budget 2021 563,330 5,454,925 11.52% 0 (9,000) 0 .00% (46,000) (150,000) 44 .23% 7,000 (33,000) (17 .50%) (39,000) (192,000) 25.49% (53,900) (53,900) 0 .00% 0 0 0.00% 0 (15 ,000) 0.00% (53 900) (68 900) 359.33% 470,430 5,194,025 9.96% Corporate Services Department The Corporate Services Department supports the City's ongoing operations by providing legal, legislative, municipal law enforcement and information technology services to Council and to all City Departments. 'I Corporate Services Department I I I I I " Information Legal Services Legislative Municipal Law Technology Services* Enforcement/\ ~ '- * Includes Clerks Office, Records Management & Elections and Print Shop/Mail Room A Includes By-law Enforcement Services and Animal Services Key Activities for 2022 • Preparation and administration of the 2022 Municipal Election • Review of Boards and Committees Policy ADM 040 to ensure the provisions are in line with the needs of the City's Advisory Committees, Boards and Taskforces, to allow them to effectively carry out their mandates • Review, assess and implement as appropriate hybrid remote/in-person Council and Committee meeting solution • New online portal for permit applications • Service Modernization -Digital Strategy and Implementation • Ongoing enhancements to network security • Migration from legacy copper-based Primary Rate Interface (PRI) connectivity to digital Session Initiation Protocol (SIP) connectivity • Implementation of vulnerability, mitigation, detection and response system to automate patching of network connected devices • New network core switching environment -Move to Cisco Network technologies due to end-of-life network hardware • Citrix Environment Upgrade and VMWare (Server Virtualization Platform) Upgrade • Data backup architecture review and disaster recovery solution review and testing (including review of data retention, ability to restore, and resilience to ransomware attack) 91 • Vulnerability Risk Assessment in 2022 to include internet, network, servers, cloud instance of SAP, and physical security testing of facilities to identify risks associated with physical access to desktops and network equipment • New User Onboarding procedures to virtually onboard new City staff • Preparation of updated Sign By-law for Council approval • Negotiation and completion of Agreements of Purchase and Sale for parcels of Seaton employment lands • Land acquisition and collaboration with TRCA on connection of City's Waterfront Trail • Negotiation of lease terms for new Animal Shelter and project management of shelter design and construction • Project Management for implementation of City's new waterfront parking strategy Financial Information Staffing Summary (Full & Regular Part Time) Approved Current Term Approved 2018 2019 2020 2021 2022 Add Delete Total Full Time 36 38 41 41 3 1 43 Reg. Part-4 5 _§ z 1 Q 8 Time Total 40 43 47 48 4 1 51 The department proposes the following new positions and the transfer of one position to the Finance Department: • One new full-time IT Security Analyst to plan and carry out security measures to protect the City's computer network and systems. The Security Analyst will stay up-to-date on the latest methods used by attackers to infiltrate computer systems. The Security Analyst will also research new security technology to decide what will most effectively protect the City's network. • One new full-time IT Helpdesk Analyst to maintain current infrastructure and applications and provide ongoing technology support to all City staff. • One new part-time Animal Shelter Attendant position to ensure adequate staffing of animal shelter per statutory requirements and to accommodate additional animals brought to the shelter by the Town of Whitchurch-Stouffville. 92 • One new Supervisor, Parking Enforcement to provide ongoing supervision of all parking operations, including parking ticket administration, ticket reviews, court appearances, staff scheduling and community outreach. The position will also oversee the new waterfront paid parking program, and can provide administrative supervision of the City's new Automated Speed Enforcement program. (This position will be funded from revenues anticipated from the new Waterfront paid parking program.) • One full-time position to be transferred from Corporate Services Department to the Finance Department to support the SAP system from a technical perspective. In addition to the above new full-time and part-time positions, the department is proposing adding two contract IT positions to its 2022 budget, which will be funded from the provincial Streamline Development Approval Grant. These positions will be supporting the Pickering Resident Interface for Service Modernization (PRISM) project. Year-Over-Year (Net Cost) Budget Changes 2021 Budget 2022 Approved Budget YearNear Increase ($) (%) Information Technology $2,509,713 $3,052,516 $542,803 Legal Services 383,449 470,706 87,257 Clerks Office 312,058 229,545 (82,513) Records Mgmt. & Elections 146,401 155,757 9,356 Print Shop/Mail Room 535,506 555,357 19,851 By-Law 723,447 515,047 (208,400) Animal Services 535,116 548,009 12,893 21.63% 22.76 (26.44) 6.39 3.71 (28.81) 2.41 7.41% Total (Net Cost) $5,145,690 $5,526,937 $381,247 =============="==~=============== Explanation of Significant Budget Changes Expenditures -Increases/ (Decreases) Salaries and Wages $449,912 -Budget increase reflects one new part-time Animal Services Attendant, one new IT Security Analyst, one new IT Helpdesk Analyst and one new Supervisor, Parking Enforcement positions. In addition, two contract IT staff positions have been added to the 2022 budget that are 100% funded from the provincial Streamline Development Approval Grant to support the PRISM project. In addition, the budget increase includes wages for temporary election staff for the 2022 Municipal Election, which is funded from the Elections Reserve. Lastly, dedicated Waterfront Parking Enforcement term staff have been added to the budget for paid waterfront parking lots and on-street permit parking (RTC BYL 02-21 Resolution #728/21). 93 Employer Contributions $73,647 -Budget increase is attributable to the earlier mentioned new positions and increased employer CPP contribution rates in 2022. Postage $79,000 -Budget increase due to significant increase required for the municipal election, together with overall increase in mailing volume. Consulting and Professional $53,136 -Budget increase for IT Strategic Plan and contract legal services from Region of Durham. Outside Agency Services $31,800 -Budget increase largely reflects equipment, facility rentals and communications costs for the 2022 Municipal Election funded from the Elections Reserve, partially offset by reduction in IT Outside Agency Services costs. Software and Hardware Maintenance $372,554 -Budget increase required for hardware and software maintenance costs and election software and laptop rentals. Stationary & Office Supplies $7,500 -Budget increase due to supplies required for the 2022 Municipal Election funded from the Elections Reserve. Printing Supplies $8,602 -Budget increase reflects higher cost of printing supplies and the cost of a new Ricoh wide format plotter/printer for Graphics Department. Gas, Oil Tires $10,392 -Budget increase based on 2021 projected actuals and anticipated increase in gasoline and diesel prices. System and Software Upgrades $89,349-Budget increase reflects Adobe Cloud licences, licencing for new employees and Vulnerability Detection and Response System costs. Hardware Replacements $11,600 -Budget increase reflects computers and licencing costs for two contract IT staff positions to support the PRISM project, 100% funded form the provincial Streamline Development Approval Grant. Revenues/Transfer from Reserves -(Increases)/ Decreases Departmental Revenues ($732,840) -Budget increase primarily due to recent increase in parking fine amounts, renewed parking enforcement as pandemic measures are relaxed and implementation of the City's waterfront parking strategy. In addition, grant funding from the provincial Streamline Development Approval Grant has been budgeted to fund two IT contract positions to support PRISM project. 94 Transfer from Reserve ($258,751) -Budget increase reflects transfer from the Elections Reserve to fund the 2022 Municipal Election, partially offset by a budget reduction in transfers from other reserves. Department 2020 & 2021 Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 Information Technology Service Support Requests (Help Desk tickets) 6,042 6 ,841 Staff connection -remote staff connections 252 258 Employees trained in information security 375 502 awareness Systems Availability 98.5% 98.9% Projects Completed 17 49 Online Attacks Blocked (severe) Data not 49,808 available Malicious Connection Attempts Blocked Data not 237,540,628 available Malicious Emails Blocked 760 ,744 444 ,390 Legal Services Development-related Agreements 20 23 Instruments Registered in Teraview (Land 101 84 Registry Office) Enforcement Services Parking Tickets Issued 20 ,409 17,690 Parking Fine Revenue $565,300 * $625,077* COVI D-19 Enforcement - # park patrols 14,239 24,893 By-law Violations Requests for Service 1,326 1,572 Parking Enforcement Requests for Service 910 1,133 Animal Services Requests for Service 925 942 Animals Sheltered (cats/dogs/small animals) 394 405 Animals Adopted 298 211 Lost pets found and returned 92 85 * subject to increase per MTO reconciliation Legislative Services Committee & Council Meetings 70 70 Burial Permits Issued 1,063 1081 Marriage Licences Issued 343 519 Freedom of Information Requests 27 60 95 Corporate Services Department Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Uniforms Travel Postage Freight, Express & Cartage Cellular Phones Telephones Internet Advertising Subscription & Publications Legal Services Seminars & Education Corporate Training Insurance Premium Ins . Deductible Consulting & Professional Recpt, Prom & Sp Events Memberships Outside Agency Serv Build Repairs & Mice Veh -Repairs & Maintenance Misc Equip Repairs Software/Hardware Maintenance CoI Building Rentals Stationery & Office Supplies Printing Supplies Forms Utilities -Hydro Utilities -Oil Gas, Oil Tires Supplies & Tools Shop Supplies City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 3,611,640 3,820 ,576 71 ,370 64,550 1,005,634 1,022 ,204 10,000 3 ,600 18,100 18,900 6,100 4,200 147,000 152,000 3,100 3,100 20,360 21,360 27,990 29,695 0 0 800 800 11,170 8 ,195 12 ,000 12,000 53,850 63,150 12,000 12,000 24 ,148 24,620 2,000 2 ,000 171,464 170,864 8,750 8,250 9,500 9 ,750 97 ,875 97,375 13,358 12,358 17,800 12,800 48 ,700 46,100 506,497 694 ,942 16,556 16,964 11,300 10,900 190,000 200 ,000 8,000 8,000 6,798 6,798 6,500 6,500 27,763 27,763 4,500 4,500 15 ,100 15,100 96 Run Date: 5/31/22 3:02 PM 2022 INC.IDEC . Approved % CHGE . Budget 2021 449,912 4,270,488 11 .78% 27,689 92,239 42 .90% 73,647 1,095,851 7.20% 0 3 ,600 0 .00% 1,300 20 ,200 6.88% 0 4,200 0.00% 79,000 231 ,000 51 .97% 0 3 ,100 0 .00% 3,400 24,760 15.92% (2,140) 27,555 (7.21 %) 2,140 2,140 0.00% 0 800 0 .00% 200 8,395 2.44% 0 12,000 0 .00% 250 63,400 0.40% 4,000 16,000 33.33% 0 24,620 0.00% 0 2 ,000 0 .00% 53,136 224,000 31.10% 250 8,500 3.03% 4,750 14,500 48 .72% 31,800 129,175 32 .66% 0 12,358 0 .00% 0 12,800 0.00% 0 46,100 0 .00% 372 ,554 1,067,496 53 .61% 442 17,406 2.61% 7,500 18,400 68.81% 8,602 208,602 4.30% 0 8,000 0 .00% 0 6,798 0.00% 0 6,500 0 .00% 10,392 38,155 37.43% 0 4,500 0.00% 0 15,100 0 .00% Corporate Services Department Account Descriptions Minor Furniture & Fixtures System & Software Upgrades Ha rdware Replacements Misc. Equipment Parking -MOT Livestock Killed COVID Related Expenditures Total Expenditures Revenues Sale of Services-Administration Sale of Services -Legal Sale of Services -Agreements Lie . & Per-Business Lie . & Per-Amusement Lie . & Per-Ta xi Fines Licences Licenses & Permits-Marriage Adoptions Impound Fees Service Fees Ont. Specific G rants Other Revenue Other Misc Revenue Sponsorships No Tax Marketing Sponsorships Misc Rev Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Trans . to/(from) Continuing Studies F Total Transfers Net . City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 1 ,500 , 0 100,584 72,450 93,600 47 ,800 59,150 109,260 75,000 75 ,000 1 ,000 500 0 0 6,528,557 6,916 ,924 (80 ,000) (70 ,000) (2 ,000) (2 ,000) (180 ,000) (155 ,000) (165,000) (65,000) (200 ,000) (180 ,000) (180,000) (140 ,000) (862 ,000) (702 ,000) (59 ,000) (59 ,000) (30 ,000) (30 ,000) (31 ,600) (32 ,000) (4,000) (4,000) (3 ,300) (3 ,300) (1,000) (500) (16 ,200) (16 ,150) (20 ,000) (20,000) (3,000) (3,000) (2,000) (2,000) (8 ,000) (8 ,000) (1,847,100) (1 ,491,950) (187,638) (279 ,284) (53 ,964) 0 (241 602) (279 284) 4,439,855 5,145,690 97 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 0 0 0.00% 89 ,349 161,799 123.33% 11,600 59,400 24.27% (51,465) 57 ,795 (47 .10%) 0 75,000 0 .00% 0 500 0 .00% 194,530 194,530 0.00 % 1,372,838 8,289,762 19.85% 0 (70 ,000) 0 .00% 0 (2,000) 0 .00% (2,510) (157 ,510) 1.62% 24,500 (40,500) (37.69%) 0 (180,000) 0.00% 6 ,000 (134 ,000) (4.29%) (180,000) (882 ,000) 25.64% 0 (59,000) 0.00% (2 ,000) (32 ,000) 6 .67% 0 (32 ,000) 0 .00% 0 (4,000) 0.00 % 0 (3,300) 0 .00% (284 ,180) (284,680) 56 ,836 .00 % (3,850) (20 ,000) 23 .84% (290,800) (310,800) 1,454.00% 0 (3 ,000) 0.00% 0 (2,000) 0 .00 % 0 (8,000) 0 .00% (732,840) (2,224,790) 49.12% (258 ,751) (538,035) 92 .65% 0 0 0 .00% (258 751) (538 035) 92.65% 381,247 5,526,937 7.41% Information Technology Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Uniforms Travel Cellular Phones Telephones Internet Seminars & Education Corporate Training Insurance Premium Consulting & Professional Recpt, Prom & Sp Events Memberships Outside Agency Serv Misc Equip Repairs Software/Hardware Maintenance Co1 Stationery & Office Supplies System & Software Upgrades Hardware Replacements Misc. Equipment COVID Related Expenditures Total Expenditures Revenues Ont. Specific Grants Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved ' Budget Budget 1,113,370 1,152,839 52,050 46,050 311,575 326,031 4,000 2,000 0 800 1,800 1,200 8,000 8,000 8,390 8,205 0 0 36,900 49,400 12,000 12,000 7,850 8,000 65,000 61,900 1,000 1,000 650 650 9,600 9 ,600 48,700 46,100 454,089 627,728 3,700 3,700 100,584 72,450 93,600 47,800 59,150 109,260 0 0 2,392,008 2,594,713 0 0 0 0 (85,000) (85,000) {85 000) 185 000) 2,307,008 2,509,713 98 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 256,958 1,409,797 22.29% 17,950 64,000 38.98% 33,931 359,962 10.41% 0 2,000 0.00% 0 800 0 .00% 0 1,200 0.00% 1,900 9,900 23.75% (850) 7,355 (10.36%) 850 850 0.00% (4,000) 45,400 (8.10%) 4,000 16,000 33.33% 0 8,000 0.00% 85,100 147,000 137.48% 0 1,000 0 .00% 4,750 5,400 730.77% (7,200) 2,400 (75.00%) 0 46,100 0.00% 85,080 712,808 13.55% 0 3,700 0.00% 89,349 161,799 123.33% 11,600 59,400 24.27% (51,465) 57,795 (47 .10%) 191,530 191,530 0 .00% 719,483 3,314,196 27.73% (261,680) (261,680) 0 .00% (261,680) (261,680) 0.00% 85,000 0 (100 .00%) 85 000 0 (100.00%) 542,803 3,052,516 21.63% Legal Services Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Travel Cellular Phones Telephones Internet Subscri ption & Publications Legal Services Seminars & Education Insurance Premium Consulting & Professional Recpt, Prom & Sp Events Memberships Software/Hardware Maintenance Co1 Stationery & Office Supplies Total Expenditures Revenues Sale of Services -Legal Sale of Services -Agreements Misc Rev Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved I Approved ' Budget Budget 540,763 470,256 2 ,500 1 ,500 146,133 121 ,138 750 750 1,600 1,600 2,115 1,365 0 0 7,620 7,645 12,000 12 ,000 4,500 4,500 3,460 3,530 45,000 45,000 500 500 6,550 6,550 1,536 935 1,500 1,500 776,527 678,769 (2,000) (2,000) (180,000) (155,000) (8,000) (8,000) (190,000) (165,000) (102,638) (130,320) (102 638) 1130 320\ 483,889 383,449 99 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE. Budget 2021 29,721 499,977 6 .32% 0 1,500 0 .00% 6,846 127,984 5 .65% 0 750 0 .00% 0 1,600 0 .00% (150) 1,215 (10 .99%) 150 150 0.00% 0 7 ,645 0.00% 0 12,000 0.00% 0 4,500 0 .00% 0 3,530 0 .00% 26,000 71,000 57.78% 0 500 0 .00% 0 6,550 0.00% (160) 775 (17 .11%) 0 1,500 0 .00% 62,407 741,176 9.19% 0 (2 ,000) 0.00% (2,510) (157,510) 1.62% o. (8,000) 0.00% (2,510) (167,510) 1.52% 27 ,360 (102 ,960) (20 .99%) 27 360 1102 960\ (20.99%: 87,257 470,706 22.76% Clerks Office Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Travel Cellular Phones Telephones Internet Subscription & Publications Seminars & Education Insurance Premium Recpt, Prom & Sp Events Memberships Software/Hardware Maintenance Co1 Stationery & Office Supplies Total Expenditures Revenues Sale of Services-Administration Lie . & Per-Amusement Licenses & Permits-Marriage Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved I' Approved Budget Budget 374 ,763 445,659 1,000 1,000 108,885 130 ,039 1,600 1,600 500 500 1,100 1,100 1,410 2,050 0 0 500 500 2 ,500 2,500 2 ,555 2 ,600 750 750 1,000 1,000 1,171 760 2 ,000 2,000 499,734 592 ,058 (80,000) (70,000) (200 ,000) (180,000) (30,000) (30,000) (310,000) (280,000) 0 0 189,734 312,058 100 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 (64,068) 381,591 (14.38%) 1,000 2,000 100 .00% (18,225) 111 ,814 (14 .02%) 0 1,600 0.00% 0 500 0.00% 500 1,600 45.45% (230) 1,820 (11.22%) 230 230 0 .00% 200 700 40 .00% 0 2 ,500 0 .00% 0 2 ,600 0 .00% 250 1,000 33 .33% 0 1,000 0.00% (170) 590 (22.37%) 0 2,000 0 .00% (80,513) 511 ,545 (13.60%) 0 (70 ,000) 0 .00% 0 (180,000) 0.00% (2,000) (32,000) 6 .67% (2,000) (282,000) 0.71% 0 0 0.00% (82,513) 229,545 (26.44%) Records Management & Elections City of Pickering 2022 Approved Current Budget 2020 2021 Account Descriptions Approved i Approved . Budget Budget Expenditures Salaries & Wages 75,959 69,322 Overtime 1,000 1,000 Employer Contributions 24,046 22,758 Travel 500 500 Postage 0 0 Telephones 350 680 Internet 0 0 Seminars & Education 1,250 1,250 Insurance Premium 861 880 Consulting & Professional 61,464 63,964 Outside Agency Serv 13,375 13,375 Software/Hardware Maintenance Co1 31,000 35,636 Stationery & Office Supplies 1,000 1,000 COVID Related Expenditures 0 0 Total Expenditures 210,805 210,365 Revenues Total Revenues 0 0 Transfers to/from Reserves & R.F. Transfer to/(from) Reserve 0 (63,964) Trans . to/(from) Continuing Studies F (53,964) 0 Total Transfers (53 964) (63 964) Net 156,841 146,401 101 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 24,185 93,507 34.89% 1,000 2,000 100.00% 3,022 25,780 13 .28% 0 500 0 .00% 75,000 75,000 0 .00% (75) 605 (11.03%) 75 75 0.00% 250 1,500 20.00% 0 880 0.00% (57,964) 6,000 (90.62%) 36,500 49,875 272 .90% 287,974 323,610 808.10% 7,500 8,500 750.00% 3 ,000 3,000 0 .00% 380,467 590,832 180.86% 0 0 0.00% (371,111) (435,075) 580.19% 0 0 0 .00% (371 111 \ (435 075) 580.19% 9,356 155,757 6.39% Print Shop/Mail Room Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Postage Freight, Express & Cartage Telephones Internet Insurance Premium Outside Agency Serv Software/Hardware Maintenance Co1 Stationery & Office Supplies Printing Supplies Total Expenditures Revenues Other Revenue Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 i 2021 Approved I Approved Budget Budget 109,508 111,410 500 500 33,042 28,741 147,000 152,000 3,100 3,100 705 680 0 0 2,335 2,380 35 ,000 35,000 286 195 1,500 1,500 190,000 200,000 522,976 535,506 (200) 0 (200) 0 0 0 522,776 535,506 102 Run Date: 5/31/22 3:02 PM . 2022 INC./DEC. Approved % CHGE. Budget 2021 - 2 ,945 114,355 2 .64% 500 1 ,000 100.00% 1 ,324 30,065 4 .61% 4,000 156,000 2 .63% 0 3,100 0 .00% (75) 605 (11 .03%) 75 75 0 .00% 0 2,380 0.00% 2,500 37,500 7 .14% (20) 175 (10 .26%) 0 1,500 0 .00% 8 ,602 208,602 4 .30% 19,851 555,357 3.71% 0 0 0 .00% 0 0 0.00% 0 0 0.00% 19,851 555,357 3.71% By-law Account Descriptions Expenditures Salaries & Wages Overtime Employer' Contributions Conferences Uniforms Travel Cellular Phones Telephones Internet Subscription & Publications Seminars & Education Insurance Premium Ins . Deductible Memberships Outside Agency Serv Veh -Repairs & Maintenance Software/Hardware Maintenance Co t Stationery & Office Supplies Forms Gas, Oil Tires Supplies & Tools Parking -MOT Total Expenditures Revenues Lie . & Per-Business Lie . & Per-Ta xi Fines Other Misc Revenue Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 1,032,581 1,156,789 6 ,320 8,500 300,723 302,798 2 ,800 0 14 ,500 14,500 900 900 7 ,760 7,760 3 ,175 5,125 0 0 3 ,000 0 6,000 4 ,000 4 ,825 4,920 2,000 2,000 900 900 5,500 5,500 15,000 10,000 15,505 19 ,392 600 600 8,000 8 ,000 19,763 19,763 2 ,000 2,000 75,000 75,000 1,526,852 1,648,447 (165 ,000) (65,000) (180 ,000) (140 ,000) (860,000) (700 ,000) (20 ,000) (20 ,000) (1,225,000) (925,000) 0 0 301,852 723,447 103 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 172,126 1,328,915 14 .88% 7 ,239 15 ,739 85 .16% 38 ,958 341,756 12 .87% 0 0 0 .00% 1 ,300 15,800 8.97% 0 900 0 .00% 1,000 8,760 12 .89% (570) 4,555 (11.12%) 570 570 0.00 % 0 0 0 .00% 4 ,000 8,000 100 .00% 0 4,920 0 .00% 0 2,000 0.00% 0 900 0.00% 0 5 ,500 0 .00% 0 10 ,000 0.00% (120) 19,272 (0.62%) 0 600 0.00% 0 8,000 0 .00% 7,397 27,160 37.43% 0 2,000 0 .00% 0 75 ,000 0 .00% 231 ,900 1,880,347 14.07% 24,500 (40 ,500) (37.69%) 6,000 (134 ,000) (4 .29%) (180,000) (880,000) 25.71% (290 ,800) (310 ,800) 1,454.00% (440,300) (1,365,300) 47.60% 0 0 0.00% (208,400) 515,047 (28.81%1 Animal Services Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Uniforms Travel Cellular Phones Telephones Internet Advertising Subscription & Publ ications Seminars & Education Insu rance Premium Recpt, Prom & Sp Events Memberships Outside Agency Serv Build Repairs & Mtce Veh -Repairs & Maintenance Software/Hardware Maintenance Co I Building Rentals Stationery & Office Suppl ies Utilities -Hydro Utilities -Oil Gas, Oil Tires Supplies & Tools Shop Supplies Minor Furniture & Fixtures Livestock Killed Total Expenditures Revenues Fines Licences Adoptions Impound Fees Service Fees City of Pickering 2022 Approved Current Budget 2020 2021 Approved ,, Approved Budget Budget 364 ,696 414,301 8 ,000 6 ,000 81 ,230 90,699 1,600 0 3,600 3,600 1 ,650 350 1,900 2,900 11,845 11,590 0 0 800 800 50 50 2,700 1,500 2 ,262 2,310 6,500 6,000 400 650 34,400 33,900 13,358 12,358 2 ,800 2,800 2,910 10,296 16,556 16,964 ·1,000 600 6,798 6 ,798 6,500 6,500 8,000 8 ,000 2,500 2 ,500 15,100 15,100 1,500 0 1,000 500 599,655 657,066 (2 ,000) (2,000) (59,000) (59,000) (31,600) (32,000) (4 ,000) (4,000) (3,300) (3,300) 104 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 28,045 442,346 6 .77% 0 6 ,000 0 .00% 7,791 98,490 8 .59% 0 0 0 .00% 0 3,600 ' 0 .00% 0 350 0 .00% 0 2,900 0 .00% (190) 11,400 (1 .64%) 190 190 0.00% 0 800 0.00 % 0 50 0.00% 0 1,500 0 .00% 0 2,310 0 .00% 0 6,000 0 .00 % 0 650 0.00% 0 33 ,900 0 .00% 0 12 ,358 0.00% 0 2 ,800 0 .00% (30) 10 ,266 (0 .29%) 442 17,406 2 .61% 0 600 0 .00% 0 6 ,798 0 .00% 0 6,500 0 .00% 2,995 10,995 37.44% 0 2,500 0.00% 0 15,100 0 .00% 0 0 0 .00% 0 500 0 .00% 39,243 696,309 5.97% 0 (2 ,000) 0 .00% 0 (59 ,000) 0 .00% 0 (32,000) 0.00% 0 (4 ,000) 0 .00 % 0 (3 ,300) 0 .00% Animal Services Account Descriptions Ont. Specific Grants Other Revenue Sponsorshi ps No Tax Mar keting Sponsorships Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget (1,000) (500) (16,000) (16 ,150) (3 ,000) {3,000) (2 ,000) (2,000) (121,900) (121,950) 0 0 477,755 535,116 105 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 (22,500) (23 ,000) 4 ,500.00% (3,850) (20 ,000) 23 .84% 0 (3 ,000) 0 .00% 0 (2 ,000) 0 .00% (26,350) (148 ,300) 21.61% 0 0 0.00% 12,893 548,009 2.41% Engineering Services Department Overview The Engineering Services Department is responsible for the overall management of major capital works projects (roads, streetlights and traffic signals, sidewalks, storm sewers, parks & trails), infrastructure maintenance/repair programs, forestry services, transportation engineering and planning, traffic operations, school crossing guard program, infrastructure asset management, storm water and water resources management and land development servicing. The Engineering Services Department oversees the following areas/functions: • Capital Projects & Infrastructure (includes the areas of crossing guards, streetlights & sidewalks) • Water Resources & Development Services • Landscape & Parks Development Engineering Services Department I I / ' / ' / -.., Capital Projects & Water Resources & Landscape & Parks Development Development Infrastructure* Services ' '-./ '-./ *Includes Crossing Guards, Streetlights and Sidewalks Key Activities for 2022 • Durham Area Municipality's Review of Streetlights on Regional Roads • Detailed Design for Beachfront Park Master Plan • Reconstruction of Breezy Drive/Sunrise Avenue Storm Sewer Outfall • Design and Construction of Brock Road Clean Water Collector Project • Commencement of City Centre Transportation Master Plan • Completion of Walnut Lane Extension Municipal Class Environmental Assessment • Completion of Claremont Drainage Plan Municipal Class Environmental Assessment 106 Financial Information Staffing Summary (Full & Regular Part Time) Approved Current Term 2018 2019 2020 2021 Full Time Reg. Part-Time Total 29 _Q 29 30 Q 30 30 0 30 30 0 30 Add 3 0 3 Approved 2022 Delete Total 0 33, Q Q 0 33 The Department proposes one new full-time Coordinator, Parks Development position to manage parks/trails projects inspection and contract administration, one new full-time Technician, Traffic Operations position to assist with the Automated Speed enforcement program and growing traffic needs in the community, and one new full-time Technician, Development Approvals contract position (funded by Third Party) to review municipal consent applications for utility installations. Year-Over-Year (Net Cost) Budget Changes 2021 Budget 2022 Approved Budget YearNear Increase ($) (%) Eng. Services -Adm. $2,615,971 $2,740,605 $124,634 4.76% Crossing Guards 396,400 424,400. 28,000 7.06 Water Res. & Dev. Serv. 957,236 1,008,214 50,978 5.33 Sidewalks 195,590 195,590 0 0 Street Lights 953,680 1,078,680 125,000 13.11 Total (Net Cost) ~$=5~, 1=1=8~,8=7=7 =$~5~,4=4=7~,4=8=9=~$3=2=8~,6=1=2==6=.4=2=%= Explanation of Significant Budget Changes Expenditures -Increases/ (Decreases) Salaries & Wages $247,297 -Budget increase largely due to three new positions (one funded by third party). Employer Contributions $74,737 -Budget increase due to above-mentioned new positions and increased CPP employer contribution rates in 2022. 107 Seminars & Education $5,060 -Budget increase related to training requirements for new staff, and for health & safety training. Consulting & Professional ($86,141) -Budget reduction due to studies that were completed in 2021 and no longer require funding. Misc. Equipment Repairs $70,000 -Budget increase related to streetlight maintenance and street light utility locate requests anticipated in 2022. Software/Hardware Maintenance Contracts $40,235 -Budget increase due to requirement in 2022 to renew AutoCAD licenses for 3 years. Misc. Equipment $39,500 -Budget increase to purchase additional traffic speed management equipment and devices. Other Fixed Assets $15,000 -Budget increase for miscellaneous streetlight installation projects. Tree Maintenance $35,000 -Budget increase required for additional tree protection (beaver management), and LLD (Gypsy moth) pest control. Engineering Repair & Maintenance $58,000 -Budget increase required for Integrated Transportation Master Plan related line painting and a retaining wall repair. Revenues/Transfer from Reserves -(Increases)/ Decreases Sale of Services -Development Control ($118,000) -Budget increase in revenue specific to design review and inspection fees anticipated in 2022. Cost Recoveries ($61,935) -Budget increase in cost recoveries due to new staff position being funded by third party. Fines -Automated Speed Enforcement Program ($100,000) -Budget increase in revenue due to the introduction of this new revenue source in 2022 as the program is now fully implemented. Transfer from Continuing Studies $43,408 -Budget reduction in transfer due to various consulting assignments and studies that either have progressed further to completion, or were completed in 2021. 108 Transfer from Reserve Fund $157,233 -Budget reduction in transfer from the DC Reserve Fund due to consulting studies that were completed, and reduced cost/transfer required for the City Centre Transportation Master Plan. Department 2020 & 2021 Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 Driveway widening/curb cut applications 79 95 Pool enclosure applications 64 94 Fill permit applications 23 9 Centreline km of roads (paved/unpaved) 347.4/102.1 352/101 Number of bridges/culverts > 3m 67 66 (vehicular/pedestrian) Km of storm sewers 249.5 343* Number of Stormwater Management Facilities 20 20 (Ponds) Km of sidewalks/trails 381.6 441* Number of Streetlk1hts 7,358 8,546* Km of cycling lanes 25.3 25.3 Number of traffic/pedestrian signals 25 25 Number of school crossing guard locations 36 36 Number of playground equipment areas 62 69 Number of outdoor soccer fields 37 34* Number of outdoor baseball diamonds 30 30 Number of splash pads 3 3 * Adjustments due to refinement in asset data. 109 Engineering Services Department City of Pickering 2022 Approved Current Budget 2020 2021 Account Descriptions Approved ' Approved I Budget Budget Expenditures Salaries & Wages 2 ,763 ,070 2 ,806,584 Overtime 16 ,500 12,000 Employer Contributions 763,291 769 ,586 Conferences 1,400 1,000 Uniforms 4,000 3,500 Travel 2,400 2,050 Cellular Phones 13,110 13,100 Telephones 10,230 10,245 Internet 0 0 Subscription & Publications 1 ,650 1,650 Seminars & Education 7,500 4,600 Insurance Premium 169,010 176,700 Ins. Deductible 7,950 7,950 Consulting & Professional 1,264,760 1,049,056 Recpt, Prom & Sp Events 300 300 Memberships 9,265 9,590 Photo , Mapping, Printing 4,000 4,000 Outside Agency Serv 537,278 793,800 Roads Repair & Mtce 10,000 10,000 Rpr Main . Maint Mater 20,000 20,000 Veh -Repairs & Maintenance 7 ,900 13,000 Misc Equip Repairs 411,200 401,200 Software/Hardware Maintenance Co1 22,963 18,180 Rental Misc Equip 3,750 4,550 Stationery & Office Supplies 3,300 3,300 Forms -750 750 Utilities -Hydro 491,429 500,000 Gas, Oil Tires 13,092 · 13,092 Supplies & Tools 8,150 8,150 Minor Furniture & Fixtures 3,000 0 Misc. Equipment 15,000 12,000 Other Minor Fixed Assets 345,000 245,000 Total Expenditures 6,931,248 6,914,933 Revenues Sale of Serv-Dev Cntrl (744,500) (762,000) 110 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHG E. Budget 202 1 247,297 3,053,881 8 .81% (2,600) 9,400 (21.67%) 74,737 844,323 9.71% 0 1,000 0 .00% 0 3,500 0 .00% 0 2,050 0.00% (2 ,660) 10,440 (20.31%) (1 ,140) 9,105 (11.13%) 610 610 0 .00% 0 1,650 0.00% 5,060 9,660 110.00% 0 176 ,700 0 .00% 0 7 ,950 0 .00% (86,141) 962 ,915 (8.21%) 0 300 0 .00% 450 10,040 4.69% 0 4,000 0 .00% (4 ,000) 789,800 (0 .50%) 0 10,000 0.00% 0 20,000 0.00% 0 13,000 0 .00% 70,000 471,200 17.45% 40,235 58,415 221 .31% (4,350) 200 (95.60%) 0 3,300 0.00% 0 750 0 .00% 0 500,000 0.00% 4 ,908 18 ,000 37.49% 0 8,150 0 .00% 0 0 0.00% 39,500 51,500 329 .17% 15,000 260,000 6.12% 396,906 7,311,839 5.74% (118,000) (880,000) 15.49% Engineering Services Department City of Pickering 2022 Approved Current Budget 2020 2021 Account Descriptions Approved Approved Budget Budget · Fines -Auto . Speed Enforcement Pr, 0 0 Other Revenue 0 (3 ,000) Other Misc Revenue (10 ,000) (10,000) Cost Recoveries (53 ,000) (35,000) Total Revenues (807,500) (810,000) Transfers to/from Reserves & R.F. Transfer to/(from) Reserve 0 (35 ,000) Trans. to/(from) Continuing Studies F (142,785) (105,023) Transfer to/(from) Reserve Fund (1,082,475) (846 ,033) Total Transfers (1 225 260) (986 056) Net 4,898,488 5,118,877 1 1 1 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 (100,000) (100,000) 0 .00% 1 ,000 (2 ,000) (33 .33%) 0 (10 ,000) 0 .00% (61,935) (96,935) 176.96% (278,935) (1,088,935) 34.44% 10,000 (25,000) (28 .57%) 43,408 (61 ,615) (41 .33 %) 157,233 (688 ,800) (18 .58%) 210 641 (775 415) (21.36%' 328,612 5,447,489 6.42% Engineering Services -Adm in. Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Uniforms Travel Cellular Phones Telephones Internet Subscription & Publications Seminars & Education Insurance Premium Ins . Deductible Consulting & Professional Reep!, Prom & Sp Events Memberships Photo, Mapping, Printing Outside Agency Serv Veh -Repairs & Maintenance Misc Equip Repairs Software/Hardware Maintenance Co1 Rental Misc Equip Stationery & Office Supplies Forms Gas, Oil Tires Supplies & Tools Misc . Equipment Total Expenditures Revenues Fines -Auto . Speed Enforcement Pr, Other Revenue Cost Recoveries Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 1,498,117 1,522,975 14,000 10,000 414,467 418,708 1,400 1,000 2,000 2,000 750 750 7,710 7,700 5,290 5,465 0 0 1,000 1,000 1,500 1,500 9,400 9,590 2,000 2,000 750,530 682,060 200 200 5,180 5,130 4,000 4,000 152,800 387,800 5,000 8,000 200 200 9,671 5,990 3,750 4,550 2,100 2,100 750 750 7,413 7,413 150 150 12,000 12,000 2,911,378 3 ,103,031 0 0 0 (3,000) (15,000) 0 (15,000) (3,000) 0 (35,000) 11 2 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE. Budget 2021 117,885 1,640,860 7.74% (3,500) 6,500 (35 .00%) 39,582 458,290 9.45% 0 1,000 0 .00% 0 2,000 0.00% 0 750 0.00% (1,580) 6,120 (20 .52%) (610) 4,855 (11.16%) 610 610 0.00% 0 1,000 0.00% 2,360 3,860 157.33% 0 9,590 0 .00% 0 2,000 0 .00% (191,560) 490,500 (28.09%) 0 200 0.00% 610 5,740 11 .89% 0 4,000 0.00% (32,000) 355,800 (8.25%) 0 8,000 0.00% 0 200 0.00% 39,850 45,840 665.28% (4,350) 200 (95.60%) 0 2,100 0 .00% 0 750 0.00% 2,777 10,190 37.46% 0 150 0 .00% 39,500 51,500 329.17% 9,574 ' 3,112,605 0.31% (100,000) (100,000) ,0.00% 1,000 (2,000) (33 .33%) 0 0 0 .00% (99,000) (102,000) 3,300.00% 35,000 0 (100 .00%) Engineering Services -Adm in. Account Descriptions Trans . to/(from) Continuing Studies F Transfer to/(from) Reserve Fund Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved ,1 Approved Budget Budget (39 ,360) (14 ,797) (450,670) (434,263) (490 030\ (484 060\ 2,406 ,348 2,615,971 113 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 14,797 0 (100 .00%) 164,263 (270 ,000) (37 .83%) 214 060 (270.000\ (44.22%1 124,634 2,740,605 4.76% Crossing Guards Account Descri ptions Expenditures Insurance Premium Outside Agency Serv Total Expenditures Revenues Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved ; Approved Budget Budget 2 ,350 2,400 374,478 394,000 376,828 396,400 0 0 0 0 376,828 396,400 114 Run Date: 5/31/22 3:02 PM ·2022 INC./DEC . Approved % CHGE. Budget 2021 0 2,400 0 .00% 28,000 422,000 7 .11 % 28,000 424,400 7.06% 0 0 0.00% 0 0 0.00% 28 ,000 424,400 7.06% City of Pickering 2022 Approved Current Budget Water Resources & Development Services 2020 2021 Account Descriptions Approved Approved Budget Budget Expenditures Salaries & Wages 1,264,953 1,283,609 Overtime 2,500 2,000 Employer Contributions 348,824 350,878 Uniforms 2,000 1,500 Travel 1,650 1,300 Cellular Phones 5,400 5,400 Telephones 4,940 4,780 Subscription & Publicatio_ns 650 650 Seminars & Education 6 ,000 3,100 Insurance Premium 7,245 7,390 Ins. Deductible 1,000 1,000 Consulting & Professional 504,230 349,540 Recpt, Prom & Sp Events 100 100 Memberships 4,085 4,460 Roads Repair & Mtce 10,000 10,000 Veh -Repairs & Maintenance 2,900 5,000 Misc Equip Repairs 1,000 1,000 Software/Hardware Maintenance Co1 13,292 12,190 Stationery & Office Supplies 1,200 1,200 Gas, Oil Tires 5,679 5,679 Supplies & Tools 8,000 8,000 Minor Furniture & Fixtures 3 ,000 0 Misc. Equipment 3 ,000 0 Total Expenditures 2,201,648 2,058,776 Revenues Sale of Serv,Dev Cntrl (744,500) (762,000) other Misc Revenue (10,000) (10,000) Cost Recoveries (38,000) (35 ,000) Total Revenues (792,500) (807,000) Transfers to/from Reserves & R.F. Transfer to/(from) Reserve 0 0 Trans . to/(from) Continuing Studies F (103,425) (82,770) Transfer to/(from) Reserve Fund (331,805) (211,770) Total Transfers (435 230) (294 540) 115 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 129,412 1,413,021 10 .08% ~00 2,900 45.00% 35,155 386,033 10.02% 0 1,500 0.00% 0 1,300 0.00% (1,080) 4,320 (20 .00%) (530) 4,250 (11 .09%) 0 650 0.00% 2,700 5 ,800 87.10% 0 7,390 0 .00% 0 1,000 0 .00% 69,775 419,315 19 .96% 0 100 0.00% (160) 4 ,300 (3 .59%) 0 10 ,000 0 .00% 0 5,000 0 .00% 0 1,000 0.00% 385 12,575 3 .16% 0 1,200 0.00% 2,131 7 ,810 37 .52% 0 8,000 0.00% 0 0 0 .00% 0 0 0.00% 238,688 2,297,464 11.59% (118 ,000) (880,000) 15.49% 0 (10,000) 0 .00% (61,935) (96,935) 176.96% (179,935) (986,935) 22.30% (25,000) (25,000) 0.00% 24,255 (58 ,515) (29 .30%) (7,030) (218 ,800) 3.32% (7 775) (302 315) 2.64% City of Pickering 2022 Approved Current Budget Water Resources & Development Services 2020 2021 Account Descriptions Approved ' Approved Budget Budget Net 973,918 957,236 11 6 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 202 1 50,978 1,008,214 5 :33% Sidewalks Account Descriptions Expenditures Insurance Premium Ins. Deductible Rpr Main . Maint Mater Other Minor Fixed Assets Total Expenditures Revenues Total Revenues Transfers to/from Reserves & R.F. Transfer to/(frorn) Reserve Fund Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 143,465 150 ,640 4,950 4 ,950 20,000 20 ,000 320 ,000 220,000 488,415 395,590 0 0 (300,000) (200,000) (300 000) (200 000) 188,415 195,590 117 Run Date : 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 0 150,640 0.00 % 0 4 ,950 0 .00% 0 20,000 0 .00 % 0 220 ,000 0 .00% 0 395 ,590 0.00% 0 0 0 .00% 0 (200 ,000) 0 .00% 0 (200 000) 0.00% 0 195,590 0 .00% Street Lights Account Descriptions Expenditures Insurance Premium Consulting & Professional Outside Agency Serv Misc Equip Repairs Utilities -Hydro Other Minor Fi xed Assets Total Expenditures Revenues Total Revenues Transfers to/from Reserves & R.F. Trans . to/(from) Continuing Studies F Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 6 ,550 6 ,680 10,000 17,456 10,000 12,000 410 ,000 400,000 491,429 500,000 25 ,000 25 ,000 952,979 961,136 0 0 0 (7,456) 0 (7 456) 952,979 953,680 118 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE . Budget 2021 0 6,680 0 .00% 35,644 53,100 204 .19% 0 12,000 0 .00% 70 ,000 470,000 17.50% 0 500,000 0.00% 15,000 40,000 60 .00% 120,644 1,081,780 12.55% 0 0 0.00% 4,356 (3,100) (58.42 %) 4 356 (3 100\ (58.42%) 125,000 1,078,680 13.11% Finance Department Overview The Finance Department is responsible for the overall management of the City and Ubrary from a financial management perspective. The duties and responsibilities include; advice to Council; budgets, payroll, payment of invoices, purchasing, insurance, risk management, accounts receivable, financial reporting, Tangible Capital Assets (TCA) and the issuance and collection of property taxes. The Finance Department consists of two cost centres: Supply & Services (Purchasing) and Finance that includes all of the finance and accounting functions identified above. Finance Department I I I I I r Taxation Budgets & Risk Accountng Supply & Mgmt. Services Services Key Activities for 2022 • Continue enhancement of Financial System (SAP) and the Cash Management System (CORE) to leverage system efficiencies for the benefit of the organization • Project lead for negotiation and possible sale of City's interest in Elexicon Inc. • Management of 2022 Budget challenges • Complete Development Charges Study and Community Benefits Study • Management of assessment appeals • Completion of the 2021 Annual Audit • Development of Asset Management Strategy 11 9 Financial Information Staffing Summary (Full & Regular Part Time) Approved Current Term Approved 2018 2019 2020 2021 2022 Add Delete Total Full Time 26 26 27 28 3* 0 31 Reg. Part-_Q _Q 0 _Q Q Q _Q Time Total 26 26 27 28 3 0 28 '* Conversion of one contract position to full time. The Finance Department is proposing three new positions of which one position is a conversion from long-term contract to full time, transfer of one position from Corporate Services Department and one new senior financial analysist. The SAP financial system represents a major opportunity for the City to enhance its financial management but requires additional staffing resources to manage and support the system. For the last four years, the SAP project manager has been employed on a contract basis and it is recommended that this position be made full time to manage the project from a day-to- day operational basis. The transfer position will be used to support the SAP system from a technical perspective. The new senior financial analyst is required to due to workload and will assist with budget software "Refresh." Year-Over-Year (Net Cost) Budget Changes 2021 2022 Budget Approved Budget Finance $665,451 $815,937 Supply & Services 449,447 478,582 Total (Net Cost) $1,114,898 $1,294,519 Explanation of Significant Budget Changes Expenditures -Increases/ (Decreases) YearNear Increase ($) (%) $150,486 22.61% 29,135 6.48 $179,621 16.11% Salaries & Wages $323,525 -Budget increase largely due to three new positions of which one position is a conversion from a long-term contract. 120 Overtime ($10,000) -The completion and implementation of the new financial system reduces the need to budget for overtime in 2022. Employee Contributions $98,951-Budget increase is attributable to the earlier mentioned new positions and increased CPP employer contribution rates in 2022. Consulting & Professional $78,095 -The increase is mainly due to the budgeting software ($75,000) refresh to accommodate the new financial system (funded from rate stabilization reserve) and the Cyber Insurance Study cost shared with Durham Region and Area Municipalities. Software/Hardware Maintenance Contracts $67,535 -The increase reflects the costs of the SAP annual software licenses. For the first two years, the software license costs were part of the implementation costs. The annual software licenses are funded from the Financial Systems Reserve. Revenues/Transfer from Reserves -(Increases)/ Decreases Penalties & Interest on Taxes ($275,000) -The 2020 and 2021 penalties and interest actuals were $2,694,486 and $2,701,669. The 2022 budget is being increased by $275,000 to reflect a budget amount of $2,690,000 that is more in-line with the 2020 and 2021 activity. Transfers to Reserve ($165,540) -The increase in Transfer to Reserves is mainly due to funding of the budgeting software refresh and SAP Annual licenses. Transfers from Reserve Fund $55,505 -The decrease in the Transfer to Reserve Fund is mainly due to a former contract position no longer being funded from the reserve fund, as it has been converted to a permanent full time position. Department 2020 & 2021 Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 Accounts Receivable Invoices Issued 255 337 Total Invoice Value $795,394 $2,011,435 Accounts Payable Vendors Paid 1,849 1,422 Total Dollar Value $82.9 m $88.5 m 1 21 Performance Indicators/Statistics 2020 2021 Payroll T4 Slips 937 929 Pay Statements 17,818 17,228 Property Taxes Phone Calls 17,528 18,535 Tax Bills Issued 65,321 67,064 Payments Processed $241.2 m $254.3 m Purchasing Cards Transactions 3,631 3,097 Value of PCard Transactions $607,168 $534,027 Number of P Cards Issued 106 108 Supply & Services Purchase Orders Issued 783 1,186 Blanket POs -Number of Blanket POs 101 0 -Total PO Value 22.7m 31.8 m Bids -Number of Bids 98 62 -Total Bids Value $45.8 m $24.7 m Quotes -Number of Quotes 70 $4.3 m -Total Quotes Value $6 m $24.7 m RFPs -Number of RFPs 10 5 -Total RFPs Value $16.6 m $2 m Tenders -Number of Tenders 18 22 -Total Tenders Value $23.1 m $18.4 m 122 Finance Department Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Travel Cellular Phones Telephones Internet Data Processing Services Subscription & Publications Seminars & Education Purch Prnting/Broch/News Ur Insurance Premium Consulting & Professional Recpt, Prom & Sp Events Memberships Outside Agency Serv Misc Equip Repairs Software/Hardware Maintenance Co1 Financial Service Charges Stationery & Office Supplies Forms Program Supplies System & Software Upgrades Total Expenditures Revenues Tax Certificates & Other Fees Interest on Investments Penalties & Interest on Taxes Other Misc Revenue Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Trans . to/(from) Continuing Studies F Transfer to/(from) Reserve Fund City of Pickering 2022 Approved Current Budget 2020 2021 Approved ' Approved Budget Budget 2,570,888 2,707,302 40,750 40,750 712,542 756,441 10,700 7 ,150 2,600 1,900 875 1,500 10,585 10,240 0 0 165,000 172,000 4,000 4,000 18,200 23,900 22,000 22,000 15,880 16,200 404,430 328,905 2,000 2,000 17,730 18,780 14,600 14,600 2,300 2,300 428,282 497,395 250,000 75,000 12,200 10,200 1,500 1,500 0 15,000 12,600 8,600 4,719,662 4,737,663 (271,000) (281,000) (665,000) (525,000) (2,265,000) (2,415,000) (55,000) (70,000) (3,256,000) (3,291,000) (119,400) (85,400) (27,930) 0 (212,700) (246,365) 123 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 323,525 3,030,827 11 .95% (10,000) 30,750 (24 .54%) 98,951 855,392 13 .08% 1,600 8,750 22.38% .0 1,900 0.00% 600 2,100 40.00% (1,135) 9,105 (11 .08%) 1,135 1,135 0 .00% 0 172,000 0.00% 0 4,000 0 .00% 7,350 31,250 30 .75%. 0 22,000 0.00% 0 16,200 0.00% 78,095 407,000 23.74% 0 2,000 0.00% 0 18,780 0.00% (3,000) 11,600 (20.55%) 0 2,300 0.00% 67,535 564,930 13.58% 0 75,000 0 .00% 0 10,200 0.00% 0 1,500 0.00% 0 15,000 0.00% 0 8,600 0.00% 564,656 5,302,319 11.92% 0 (281,000) 0.00% 0 (525,000) 0.00% (275,000) (2,690,000) 11 .39% 0 (70,000) 0 .00% (275,000) (3,566,000) 8.36% (165,540) (250,940) 193.84% 0 0 0.00% 55,505 (190,860) (22 .53%) Finance Department Account Descriptions Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 ' Approved Approved Budget Budget (360 030\ (331 765\ 1,103,632 1,114,898 124 Run Date: 5/31/22 3:02 PM -2022 INC./DEC . Approved % CHGE . Budget 2021 (110.035\ (441 800\ 33.17% 179,621 1,294,519 16.11% Finance Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Travel Cellular Phones Telephones Internet Data Processing Services Subscription & Publications Seminars & Education Purch Prnting/Broch/News Ur Insurance Premium Consulting & Professional Recpt, Prom & Sp Events Memberships Outside Agency Serv Misc Equip Repairs Software/Hardware Maintenance CoI Financial Service Charges Stationery & Office Supplies Forms Program Supplies System & Software Upgrades Total Expenditures Revenues Tax Certificates & Other Fees Interest on Investments Penalties & Interest on Taxes Other Misc Revenue Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Trans . to/(from) Continuing Studies F Transfer to/(from) Reserve Fund City of Pickering -2022 Approved Current Budget 2020 2021 Approved / Approved Budget Budget 2,243 ,.400 2,373,358 35,750 35 ,750 630,063 666,273 8,300 4 ,750 1,700 1,000 875 1,500 9,175 8,875 0 0 165,000 172,000 4,000 4,000 14,600 15,200 22,000 22,000 14,000 14,280 404,430 328 ,905 1 ,600 1,600 16,245 17,295 13,000 13,000 2,300 2,300 427,432 496,830 250,000 75,000 11,200 9,200 1,500 1,500 0 15,000 12,600 8,600 4,289,170 4,288,216 (271,000) (281,000) (665,000) (525 ,000) (2,265,000) (2,415,000) (55,000) (70,000) (3,256,000) (3,291,000) (119,400) (85,400) (27,930) 0 (212,700) (246,365) 125 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 300 ,388 2,673,746 12.66% (10,000) 25 ,750 (27 .97%) 92 ,948 759,221 13 .95% 1 ,600 6,350 33.68% 0 1,000 0.00% 600 2,100 40 .00% · (985) 7 ,890 (11 .10%) 985 985 0.00% 0 172,000 0 .00% 0 4,000 0 .00% 7,350 22,550 48.36% 0 22,000 0 .00% 0 14,280 0.00% 78 ,095 407,000 23.74% 0 1,600 0.00% 0 17,295 0 .00% (3,000) 10,000 (23 .08%) 0 2,300 0 .00% 67,540 564 ,370 13.59% 0 75,000 0.00% 0 9,200 0 .00% 0 1,500 0.00% 0 1.5,000 0 .00% 0 8,600 0 .00% 535,521 4,823,737 12.49% 0 (281 ,000) 0.00% 0 (525,000) 0 .00% (275,000) (2 ,690,000) 11 .39% 0 (70 ,000) 0.00% (275,000) (3,566,000) 8.36% (165,540) (250 ,940) 193.84% 0 0 0 .00% 55,505 (190,860) (22.53%) Finance Account Descriptions Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 \ 2021 Approved , Approved Budget Budget (360 030} (331 765} 673,140 665,451 126 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 (110 035} (441 800} 33.17% 150,486 815,937 22.61% Supply & Services Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Travel Telephones Internet Seminars & Education Insurance Premium Recpt, Prom & Sp Events Memberships . Outside Agency Serv Software/Hardware Maintenance Co1 Stationery & Office Supplies Total Expenditures Revenues Total Revenues Transfers to/from Reserves & R.F . Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved I Approved Budget Budget 327,488 333 ,944 5 ,000 5 ,000 82,479 90,168 2,400 2,400 900 900 1,410 1,365 0 0 3,600 8 ,700 1 ,880 1,920 400 400 1,485 1,485 1,600 . 1 ,600 850 565 1,000 1 ,000 430,492 449,447 0 0 0 0 430,492 449,447 127 Run Date: 5/31122 3:02 PM 2022 INC./DEC . Approved % 'CHGE. Budget 2021 23,137 357 ,081 6.93% 0 5,000 0 .00% 6,003 96 ,171 6 .66 % 0 2,400 0 .00% 0 900 0 .00% (150) 1,215 (10 .99%) 150 150 0.00% 0 8 ,700 0 .00% 0 1,920 0.00% 0 400 0 .00% 0 1,485 0 .00% 0 1 ,600 0 .00% (5) 560 (0.88 %) 0 1,000 0 .00% 29,135 478,582 6.48% 0 0 0.00% 0 0 0.00% 29,135 478,582 6.48% • In person public education restarted including Get Real Pickering, Adopt-a-School, After the Heat • Update response protocols and areas as new station comes on line • Launch of software that will assist in development of public fire safety education programs and building manager fire safety programs Financial Information 2018 Full Time 103 Reg. Part-_Q Time Total 103 Staffing Summary (Full & Regular Part-Time) Approved Current Term 2019 2020 2021 Add 106 109 112 4 _Q _Q 0 Q 106 109 112 4 A d pprove 2022 Delete Total 0 116 0 Q 0 116 The department proposes four additional firefighter positions in 2022, with a start date of September 1st , for the new Seaton Fire Headquarters that will be open in early 2023. Year-Over-Year (Net Cost) Budget Changes 2021 2022 Budget Approved Budget Fire Protection $17,951,284 $18,746,854 Emergency Operations 20,283 28,979 Total (Net Cost) $17,971,567 $18,775,833 Explanation of Significant Budget Changes Expenditures -Increases/ (Decreases) YearNear Increase ($) (%) $795,570 4.43% 8,696 42.87 $804,266 4.48% Salaries & Wages· $394,325 -Budget Increase largely due to the hiring of four new firefighter positions for Seaton (September 1st start date) and the PPFA collective agreement increase, partially offset by mandatory firefighter retirements. Overtime $50,000 -Budget increase for overtime specifically related to COVID. 129 Employer Contributions $121,802 -Budget increase largely due to above-mentioned new positions and increased CPP employer contribution rates in 2022. Uniforms $10,000 -Budget Increase due to inflation and our increased staffing. Dispatch Communications $32,475 -Budget increase reflects increased operating costs of joint fire dispatch with Ajax Fire and Emergency Services. Seminars & Education $24,000 -Budget increase related to inflation and the increase in our firefighters complement. Insurance premium $26,425 -Budget increase due to property insurance premiums for new Seaton Fire Headquarters. Miscellaneous Equipment Repairs $27,000 -Budget increase mostly related to increased cost of aging radio equipment repairs and servicing and out-sourcing of self- contained breathing apparatus repairs and testing. Gas, Oil & Tires $35,321 -Budget increase due to anticipated higher gasoline and diesel prices in 2022. Revenues/Transfer from Reserves -(Increases)/ Decreases Sale of Service Revenue $45,000 -Budget reduced to reflect actuals over the past two years. These are responses on the 400 series highways and Highway 7 paid by the province. Lower revenues are due to decreased traffic and incidents during the pandemic. Department 2020& 2021 Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 Fire Prevention & Public Safety Vulnerable Occupancy Inspections (Legislated) 20 20 Complaint Inspections 136 205 Requested Inspections 365 421 Fire Investigations 30 31 Permits Reviewed 940 370* Public Fire Safety Education Events 63 361 130 Performance Indicators/Statistics 2020 2021 Fire Suppression Operations Fire/Smoke 350 311 Motor Vehicle Accidents 460 452 Medical Response 893 519 Rescue 25 18 Fire Alarm 318 324 Hazard (CO, wires down, Qas leak, etc.) 233 267 Other (public assist, 911 unknown call, etc.) 329 323 Total Incidents 2,609 2215 Training Recruit firefighters trained (7 week program) 3 11 *New tracking process in 2021 reflects the number of permits and not the number of site visits or permit re-submissions as reflected in previous years. 131 Fire Services Department Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Uniforms Travel Cellular Phones Telephones Internet Dispatch Communications Cable Advertising Subscription & Publications Seminars & Education Insurance Premium Ins. Deductible Consulting & Professional Recpt, Prom & Sp Events Memberships Photo , Mapping, Printing Outside Agency Serv Build Repairs & Mtce Veh -Repairs & Maintenance Misc Equip Repairs Software/Hardware Maintenance CoI Stationery & Office Supplies Forms Program Suppl ies Utilities -Water Utilities -Gas Utilities -Hydro Gas, Oil Tires Supplies & Tools Minor Furn iture & Fixtures System & Software Upgrades City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 11,870,122 12,500,654 225,000 200,000 3,292,216 3,430,720 10,000 0 200,000 200,000 1,000 1,000 19,600 19,600 64 ,005 63,680 0 0 1,000,547 1,036,492 0 0 1,000 1 ,000 2 ,000 2,000 120,500 115,000 68,140 69,500 2,000 2 ,000 10,000 15,000 6,300 4,000 6,375 6,375 1,000 1,000 1,000 1,000 122,721 94,721 169,500 169,500 53,000 53 ,000 329 20,760 4,400 4,400 1,500 1 ,500 18 ,000 18,000 13 ,605 13 ,850 26 ,226 26 ,226 62 ,710 62,710 94,379 94,379 71,300 79,000 8,000 8 ,000 29,666 3,000 132 Run Date: 5/31/22 3:02 PM 2022 INC ./DEC . Approved % CHGE. Budget 2021 394 ,325 12,894,979 3 .15% 50,000 250,000 25.00% 121,802 3 ,552 ,522 3 .55% 3,500 3 ,500 0.00% 10,000 210,000 5.00% 0 1,000 0 .00% (3,300) 16,300 (16 .84%) (2,045) 61,635 (3.21 %) 1,160 1,160 0 .00% 32,475 1,068,967 3.13% 2,205 2,205 0.00% 0 1,000 0 .00% 0 2 ,000 0 .00% 24,000 139 ,000 20 .87% 26,425 95,925 38 .02% 0 2,000 0 .00% 0 15,000 0 .00% 250 4,250 6 .25% 75 6,450 1.18% 0 1,000 0.00% 0 1,000 0 .00% 1,279 96,000 1.35% (3,900) 165,600 (2.30%) 27 ,000 80 ,000 50 .94% (715) 20,045 (3.44%) 600 5 ,000 13 .64% 0 1,500 0 .00% 0 18,000 0.00% 0 13,850 0.00% 1,309 27,535 4.99% 0 62,710 0 .00% 35 ,321 129,700 37.42% 0 79 ,000 0.00 % 0 8 ,000 0 .00% 5,500 8 ,500 183 .33% Fire Services Department Account Descriptions Hardware Replacements Misc. Equipment . COVID Related Expenditures Total Expenditures Revenues Sale of Services -Fi re Prot. Ont. Specific Grants Cost Recoveries Sponsorships No Tax Marketing Sponsorships Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 0 20,200 33,500 31,500 0 0 17 ,609,641 18,369,767 (120,000) (120 ,000) 0 (27,200) (250 ,000) (250,000) (500) (500) (500) (500) (371,000) (398,200) 0 0 17,238,641 17 ,971,567 133 Run Date: 5/31/22 3:02 PM 2022 INC ./DEC. Approved % CHGE . Budget 2021 (20,200) 0 (100.00%) (3 ,000) 28,500 (9 .52 %) 28,000 28,000 0 .00% 732,066 19,101,833 3 .99% 45 ,000 (75,000) (37.50%) 27 ,200 0 (100 .00%) 0 (250 ,000) 0 .00% 0 (500) 0.00% 0 (500) 0.00 % 72,200 (326 ,000) (18.13%) 0 0 0.00% 804,266 18,775,833 4.48% Fire Protection Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Uniforms Travel Cellular Phones Telephones Internet Dispatch Communications Cable Advertising Subscription & Publications Seminars & Education Insurance Premium Ins . Deductible Consulting & Professional Recpt, Prom & Sp Events Memberships Photo , Mapping , Printing Outside Agency Serv Build Repa i rs & Mtce Veh -Repairs & Maintenance Misc Equip Repairs Software/Hardware Maintenance CoI Stationery & Office Supplies Forms Program Supplies Utilities -Water Utilities -Gas Utilities -Hydro Gas , Oil Tires Supplies & Tools Minor Furniture & Fixtures System & Software Upgrades City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 11,742,814 12 ,370,323 225,000 200,000 3 ,260,735 3,398,573 8 ,500 0 200,000 200,000 1 ,000 1 ,000 18 ,800 18 ,800 62,125 61,800 0 0 1 ,000,547 1,036,492 0 0 1,000 1,000 2 ,000 2,000 119,000 113 ,500 67,470 68,820 2 ,000 2 ,000 10,000 15,000 5,500 3,500 6 ,050 6,050 500 500 1,000 1 ,000 122,721 94 ,721 169,500 169,500 52 ,500 52,500 0 20,540 4,000 4,000 1 ,500 1,500 18,000 18 ,000 13,605 13,850 26,226 26,226 62,710 62 ,710 94,379 94,379 70 ,500 78 ,500 8,000 8,000 29,666 3 ,000 134 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 391 ,681 12 ,762 ,004 3 .17% 50 ,000 250,000 25.00% 120,980 3,519,553 3 .56% 3,500 3 ,500 0 .00% 10 ,000 210,000 5 .00% 0 1 ,000 0 .00% (3 ,300) 15,500 (17 .55%) (1,985) 59,815 (3 .21%) 1,100 1 ,100 0 .00% 32,475 1,068,967 3 .13% 885 885 0 .00% 0 1 ,000 0 .00% 0 2,000 0 .00% 22 ,000 135,500 19.38% 26,425 95,245 38.40% 0 2,000 0 .00% 0 15 ,000 0 .00% 0 3 ,500 0 .00% 0 6 ,050 0 .00% 0 500 0 .00% 0 1,000 0 .00% 1,279 96,000 1 .35% (3 ,900) 165,600 (2 .30%) 27 ,000 79,500 51.43% (700) 19,840 (3.41%) 0 4,000 0.00% 0 1,500 0 .00% 0 18,000 0.00% 0 13 ,850 0 .00 % 1 ,309 27,535 4.99% 0 62,710 0 .00% 35,321 129,700 37.42% (1,000) 77,500 (1.27%) 0 8 ,000 0.00% 5,500 8,500 183.33% Fire Protection Account Descriptions Hardware Replacements Misc . Equipment COVID Related Expenditures Total Expenditures Revenues Sale of Services -Fire Prot. Ont. Specific Grants Cost Recoveries Sponsorships No Tax Marketing Sponsorships Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 0 20,200 33,500 31,500 0 0 17,440,848 18,199,484 (120,000) (120,000) 0 (27,200) (100,000) (100,000) (500) (500) (500) (500) (221,000) (248,200) 0 0 17,219 ,848 17,951,284 135 Run Date: 5/31/22 3:02 PM 2022 INC ./DEC . Approved % CHGE . Budget 2021 (20 ,200) 0 (100.00%) (3,000) 28 ,5 00 (9 .52%) 28,000 28 ,000 0 .00% 723,370 18 ,922,854 3.97% 45,000 (75,000) (37 .50%) 27,200 0 (100.00%) 0 (100 ,000) 0.00% 0 (500) 0 .00% 0 (500) 0.00% 72,200 (176,000) (29.09%) 0 0 0.00% 795,570 18,746,854 4.43% Emergency Operations Account Descriptions Expenditures Salaries & Wages Employer Contributions Conferences Cellular Phones Telephones Internet Cable Seminars & Education Insurance Premium Recpt, Prom & Sp Events Memberships Photo, Mapping, Printing Misc Equip Repairs Software/Hardware Maintenance CoI Stationery & Office Supplies Supplies & Tools Total Expenditures Revenues Cost Recoveries Total Revenues Transfers to/from Reserves & R.F. Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved B.udget Budget 127,308 130 ,331 31,481 32,147 1,500 0 800 800 1,880 1,880 0 0 0 0 1,500 1,500 670 680 800 500 325 325 500 500 500 500 329 220 400 400 800 500 168,793 170,283 (150,000) (150,000) (150,000) (150,000) 0 0 18,793 20,283 136 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 2,644 132,975 2 .03% 822 32,969 2 .56% 0 0 0 .00% 0 800 0.00% (60) 1,820 (3 .19%) 60 60 0.00% 1,320 1,320 0.00% 2,000 3,500 133.33% 0 680 0.00% 250 750 50 .00% 75 400 23 .08% 0 500 0.00% 0 500 0.00% (15) 205 (6 .82%) 600 1,000 150.00% 1,000 1,500 200.00% 8,696 178,979 5.11% 0 (150,000) 0 .00% 0 (150,000) 0.00% 0 0 0.00% 8,696 28,979 42.87% Human Resources Department Overview The Human Resources Department provides a variety of centralized services to both the City of Pickering and the Pickering Public Library related to the management of our people resources. This includes the following functions under each operational area: Human Resources -Centralized recruitment, health & safety, employee recognition, Human Resources Information System (HRIS), training. Employee Services -Employee benefits, compensation, Ontario Municipal Employee Retirement System (OMERS) administration, disability management and Workplace Safety & Insurance (WSIB) administration, employee wellness. Labour Relations -Grievance administration, collective bargaining, employee relations and policy development. People & Culture -Centralized human resources administrative services for the Pickering Public Library (PPL), diversity & inclusion and organizational development. r 'I Human Resources Department " .) I I I I I r ... Human Resources Employee Labour People & Services Relations Culture Key Activities for 2022 • Collective bargaining with 2 unions (CUPE City and CUPE Library) • Implementation of a new Human Resources Information System including staff training on employee central (a self-service module) • Oversee the work of a consultant which will create an Equity, Diversity & Inclusion Strategy with a multi-year focus • Ongoing management of the staffing impacts resulting from the pandemic response plan including the management of existing Work From Home Agreements, Mandatory Vaccination Procedure and operational requirements 137 • Implementation of a post-pandemic Working From Home Procedure and management of the same • Creation and implementation of a Disconnecting from Work Procedure in response to Bill 27: Working for Workers Act, 2021. This will require a fulsome review of operational needs, collective agreements and current work practices to establish expectations of employees outside of standard operating hours ensuring we are meeting our obligation to provide the required time free from the performance of work Financial Information Staffing Summary (Full & Regular Part Time) Approved Current Term 2018 2019 2020 2021 Full Time Reg. Part-Time Total 7 Q 7 8 Q 8 10 _Q 10 10 _Q 10 Add 1 0 1 Approved 2022 Delete Total 0 11 Q 0 0 11 The department proposes one new full-time SAP HR Business Analyst position necessary for full implementation and maintenance of the new HR Information System (Success Factors) and associated modules. Year-Over-Year (Net Cost) Budget Changes 2021 2022 Budget Approved Budget Human Resources $1,100,364 $1,127,494 Health & Safety 148,194 150,061 Total (Net Cost) $1,248,558 $1,277,555 Explanation of Significant Budget Changes Expenditures -Increases/ (Decreases) YearNearlncrease ($) (%) $27,130 2.47% 1,867 1.26 $28,997 2.32% Salaries & Wages $70,362 -Budget increase partially due to one new full-time SAP HR Business Analyst position to act as a dedicated resource to the full implementation of Success Factors including corporate training on Employee Central, a self-service 138 employee information module. This position will also manage the implementation of other identified system modules including recruitment, onboarding and training. Employee Contributions $16,130 -Budget increase is attributable to the earlier noted new position and increased CPP employer contribution rates in 2022. Software/Hardware Maintenance $11,185 -Budget reduced for removal of Software Maintenance previously required to maintain the old HR information system. Consulting & Professional -The $185,100 amount budgeted in 2022 reflects (i) $50,100 carry-over from 2021 for the retention of an Equity Diversity & Inclusion (EDI) consultant to facilitate the completion of an EDI Strategy to be funded from Continuing Studies Reserve and (ii) an additional $25,000 budgeted for Phase 2 of the development of the EDI Strategy required for the existing consultant to perform additional focus groups to ensure adequate employee engagement and consultation. Department 2020 & 2021 Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 Job Postinqs 52 92 New Employees Hired (excluding students) 46 112 Rehires/transfers/promotions 136 153 Redeployments (due to COVID-19) 21 3 Student/mass hires 49 114 Retirements/resiqnations 38 69 Employees trained (various courses including 743 330 Lockdown, Respect in the Workplace, Health & Safety Awareness, confined space and workinQ at heights) 139 Human Resources Department Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Employee Recognition & Appreciatio Conferences Travel Cellular Phones Telephones Internet Advertising Seminars & Education Corporate Training Insurance Premium Consulting & Professional Recpt, Prom & Sp Events Memberships Software/Hardware Maintenance Co1 Stationery & Office Supplies Educational/Promotional Materials Workplace Accommodations Total Expenditures Revenues Netted Revenue Total Revenues Transfers to/from Reserves & R.F. Trans. to/(from) Continuing Studies f Transfer to/(from) Reserve Fund · Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 894,603 913,674 1,600 1,600 258,222 263 ,260 42,250 42,250 2,450 2,450 850 850 1,300 1,300 3 ,525 3,415 0 0 10,000 10,000 6,500 14,700 37,500 33,000 4,245 4,330 109,000 184,000 2,500 2,500 2,210 2,210 19,819 18,917 1,500 1,500 1,000 1,000 900 900 1,399,974 1,501,856 (213,700) (230,298) (213,700) (230,298) 0 0 (27,500) (23,000) (27 500) (23 000) 1,158,774 1,248,558 140 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 70,362 984,036 7 .70% 0 1,600 0.00% 16,130 279,390 6.13% 0 42,250 0.00% 0 2,450 0.00% 0 850 0.00% 0 1,300 0 .00% (380) 3,035 (11 .. 13%) 380 380 0 .00% 0 10,000 0.00% 0 14,700 0.00% (3,000) 30,000 (9.09%) 0 4,330 0 .00% 1,100 185,100 0.60% 0 2,500 0.00% (50) 2,160 (2.26%) (11,185) 7,732 (59.13%) 0 1,500 0 .00% 400 1,400 40.00% 0 900 0 .00% 73,757 1,575,613 4.91% 2,340 (227,958) (1 .02%) 2,340 (227,958) (1.02%) (50,100) (50,100) 0 .00% 3,000 (20,000) (13.04%) (47 100) (70 100) 204.78% 28,997 1,277,555 2.32% Human Resources Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Employee Recognition & Appreciatio Conferences Travel Cellular Phones Telephones Internet Advertising Seminars & Education Corporate Training Insurance Premium Consulting & Professional Recpt, Prom & Sp Events Memberships Software/Hardware Maintenance Co1 Stationery & Office Supplies Total Expenditures Revenues Netted Revenue Total Revenues Transfers to/from Reserves & R.F. Trans. to/(from) Continuing Studies F Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 790 ,647 807 ,191 1,000 1,000 228,757 233,304 42,250 42,250 1,800 1,800 300 300 1,300 1,300 3,175 3,070 0 0 10,000 10,000 6,000 14,200 10,000 10,000 3,505 3,570 109,000 184,000 2 ,500 2,500 1,740 1,740 14,055 13,237 1,200 1,200 1,227,229 1,330,662 (213,700) (230,298) (213,700) (230,298) 0 0 0 0 1,013,529 1,100,364 141 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 67,002 874,193 8 .30% 0 1,000 0.00% 14,943 248,247 6.40% 0 42,250 0 .00% 0 1,800 0 .00% 0 300 0.00% 0 1,300 0 .00% (340) 2 ,730 (11.07%) 340 340 0.00% 0 10,000 0 .00% 0 14,200 0 .00% 0 10,000 0 .00% 0 3 ,570 0 .00% 1,100 185,100 0 .60% 0 2,500 0 .00% 220 1,960 12 .64% (8,375) 4,862 (63 .27%) 0 1,200 0 .00% 74,890 1,405,552 5.63% 2,340 (227,958) (1 .02%) 2,340 (227,958) (1.02%) (50,100) (50,100) 0.00% (50 100) (50 100) 0.00% 27,130 1,127,494 2.47% Health & Safety Account Descriptions Expenditures Salaries & Wages Overtime Employer Contributions Conferences Travel Telephones Internet Seminars & Education Corporate Training Insurance Premium Memberships Software/Hardware Maintenance Co1 Stationery & Office Supplies Educational/Promotional Materials Workplace Accommodations Total Expenditures Revenues Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Furid Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved ' Approved Budget Budget 103,956 106,483 600 600 29,465 29,956 650 650 550 550 350 345 0 0 500 500 27,500 23,000 740 760 470 470 5,764 5,680 300 300 1,000 1,000 900 900 172,745 171,194 0 0 (27,500) (23,000) (27 500) (23 000) 145,245 148,194 142 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE. Budget 2021 3 ,360 109,843 3 .16% 0 600 0.00% 1,187 31,143 3 .96% 0 650 0 .00% 0 550 0.00% (40) 305 (11.59%) 40 40 0 .00% 0 500 0 .00% (3,000) 20 ,000 (13 .04%) 0 760 0 .00% (270) 200 (57.45%) (2,810) 2,870 (49.47%) 0 300 0 .00% 400 1,400 40 .00% 0 900 0 .00% (1,133) 170,061 (0.66%) 0 0 0.00% 3,000 (20,000) (13.04%) 3 000 (20 000) (13.04%) 1,867 150,061 1.26% Pickering Public Library Overview The Pickering Public Library is responsible for ensuring that all Pickering residents have equitable access to the resources, information, and ideas that will enrich their civic, educational, career, and personal lives. Pickering Public Library [ Publ ic Services ] Support Services The Pickering Public Library offers access to free spaces, programs, collections and other services that support the following ends: • Residents will be supported in their lifelong learn ing needs at all ages and stages . • Residents will be enriched by a culture of reading . • Residents will have access to inclusive, accessible and welcoming public facilities and virtual spaces where the entire community can read, work, connect, collaborate, create, play, learn, or simply be . • Residents will have access to library services that are high quality, efficient, and cost-effective , developed with community input and awareness. • Residents will have access to library services that support their financial, physical, social, and mental well-being . • Residents will have access to library services that champion inclusion , diversity and belonging. Key Activities for 2022 • Launch outreach van with mobile Maker Space to serve new and underserved communities • Refresh Claremont Library branch and pilot Extended Access service • Develop and action recommendations provided by the Pickering Public Library Anti- Black Racism Working Group 143 • Establish permanent video production space for use by community and staff • Engage community on improvement projects for Claremont Library and George Ashe Library • Develop hybrid programming model to allow for broadcasting live, in-person programs • Develop recommended programs and schematic concepts for new Seaton Community Library • Pilot social worker in library locations to build connections and provide referrals to broader community services Financial Information 2018 Full Time 38 Reg. Part-26 Time Total 64 Staffing Summary (Full & Regular Part-Time) Approved Current Term 2019 2020 2021 Add 37 36 37 4 25 24 22 0 63 60 59 4 A d pprove 2022 Delete Total (2) 39 m 20 (4) 59 The Library added a full-time Assistant Manager (lnfoTech) and two full-time Senior Client Experience Associate positions. These new positions will enable increased leadership of public service staff and branch operations and enhanced client experience. Funding for these new full-time positions comes from the elimination of one full-time Operations Coordinator position, one full-time Client Experience Associate Technology position and two part-time Senior Client Experience Associate positions. The Library also added an Executive Assistant role that was formerly part of the staffing complement. Year-Over-Year (Net Cost) Budget Changes 2021 2022 YearNear Increase Budget Approved ($) (%) Budget Libraries $5,876,597 $6,135,385 $258,788 4.40% Total (Net Cost) $5,876,597 $6,135,385 $258,788 4.40% 144 Explanation of Significant Budget Changes Expenditures -Increases/ (Decreases) Overall, the Library's expenses increased by 4.92% ($294,888) from the previous year. This change was driven by the following: • iI$312,432 in salaries and benefits resulting from scheduled annual increases, Executive Assistant role, grant-dependent summer student positions and restoring positions post-pandemic. -0-$42,000 in hardware replacement because of one-time laptop purchases in prior year. • iI $14,000 in building repairs and maintenance for thorough cleaning of branches. • iI $10,000 to support increased use of digital collections and on line learning platforms by library clients. Revenues/Transfer from Reserves -(Increases)/ Decreases • iI $27,000 in anticipated grants to fund summer student positions • iI $9,500 in miscellaneous revenue Library 2020 & 2021 Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 Total materials borrowed 496,445 758,202 Website visits 246,397 267,796 In-person visits 145,497 121,216 Active cardholders 37,583 33,855 Public Computer Use* 624,637 433,144 Total digital learning sessions 108,298 108,099 Program attendance 5,720 9,088 Number of programs 483 514 *Comparison year over year not possible due to change in measurement tool 145 Library Account Descriptions Expenditures Sa laries & Wages Employer Contributions Employee Recognition & Appreciatio Conferences Uniforms Travel Postage Freight, Express & Cartage Cellular Phones Telephones Internet Cable Advertising Semina rs & Education Purch Prnting/Broch/News Ur Insurance Prem ium Ins . Deductible Consulting & Professional Recpt , Prom & Sp Events Memberships Outside Agency Serv Build Repairs & Mtce Veh -Repairs & Maintenance Misc Equip Repairs Software/Hardware Maintenance Co1 Stationery & Office Supplies Catalogue Processing Supp Lib Materials Program Supplies Committee Ex penses Utilities -Water Utilities -Gas Utilities -Hydro Gas, Oil Tires Supplies & Tools City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 3,461,809 3 ,367,282 914,436 904,694 3,000 3,000 6 ,500 3,500 2,300 2,300 6,000 4,000 3 ,800 3,300 1 ,000 1,000 11,000 19 ,238 57,276 63,090 0 0 0 0 14 ,000 10 ,000 16,900 29,400 9,000 5,000 24,345 24 ,830 2 ,000 2,000 31 ,850 20,500 9 ,000 7 ,000 7,500 7 ,500 274,760 298,034 260 ,389 277,746 2,000 2,000 43,250 39 ,250 187,841 217,650 19,000 19,000 5,000 5,000 273 ,290 309 ,990 35,750 26,750 0 0 17,940 18 ,300 34,461 34,461 189,000 189,000 2,132 2 ,132 3 ,500 3,500 146 Run Date: 5/31/22 3:02 PM 2022 INC./DEC. Approved % CHGE . Budget 2021 215,142 3 ,582,424 6 .39% 97,290 1,001,984 10 .75% 1,135 4,135 37.83 % 3 ,500 7,000 100.00% 1,650 3,950 71.74% (1,000) 3 ,000 (25 .00%) (2 ,150) 1,150 (65 .15 %) (600) 400 (60 .00%) (6,258) 12,980 (32 .53%) (39 ,925) 23 ,165 (63 .28%) 38,500 38,500 0 .00% 1,425 1,425 0 .00% 1,800 11,800 18.00% (800) 28 ,600 (2 .72%) 2,000 7,000 40.00% 0 24,830 0 .00% 0 2 ,000 0.00% (2,000) 18 ,500 (9 .76%) (1,000) 6,000 (14.29%) 80 7 ,580 1.07% (11,336) 286 ,698 (3 .80%) (38,903) 238,843 (14.01%) 2 ,000 4 ,000 100.00% 2 ,240 41,490 5 .71% 4,401 222,051 2 .02% (500) 18 ,500 (2 .63%) (1 ,000) 4,000 (20 .00%) 10,000 319,990 3 .23% (750) 26 ,000 (2.80%) 11,000 11 ,000 0 .00% 0 18,300 0.00% 1,724 36,185 5 .00% 0 189,000 0 .00% 798 2,930 37.43% 500 4,000 14.29% Library Account Descriptions Minor Furniture & Fixtures Hardware Replacements COVID Related Expenditures Total Expenditures Revenues Fines -Library Matis . Misc . -Photocopies Lib. Donations Federal Grant Ont. Specific Grants Vending Machines Rentals -Mtg. Room/Public Other Misc Revenue Total Revenues Transfers to/from Reserves & R.F. Transfer to/(from) Reserve Total Transfers Net City of Pickering 2022 Approved Current Budget 2020 2021 Approved Approved Budget Budget 5,000 10,000 46,075 58,075 0 0 5,981,104 5,988,522 (80 ,000) (20,000) (52,000) (52,000) (16,000) (25,000) 0 0 (106,425) (106,425) (2,500) (2,500) (8,000) 0 (6,000} (6,000) (270,925) (211,925) 63,000 100,000 63 000 100 000 5,773,179 5,876,597 14 7 Run Date: 5/31/22 3:02 PM 2022 INC./DEC . Approved % CHGE . Budget 2021 (5 ,000) 5,000 (50.00%) (42 ,075) 16,000 (72.45%) 53,000 53,000 0 .00% 294,888 6,283,410 4.92% 0 (20,000) 0.00% (1,000) (53,000) 1 .92% 0 (25,000) 0 .00% (27,600) (27,600) 0 .00% 0 (106,425) 0 .00% 0 (2,500) 0 .00% (3,500) (3,500) 0.00% (4,000) (10,000) 66.67% (36,100) (248 ,025) 17.03% 0 100,000 0.00% 0 100 000 0.00% 258,788 6,135,385 4.40% Maturity Date Projects City of Pickering 2022 Outstanding Debt Summary Expansion and Renovations of the Don Beer Arena (Refunding 2022 debentures of 2002 debt in 2012) 2022 Roof Replacements at the Don Beer Arena Rink 1 2022 Frenchman's Bay Harbour Entrance 2022 Browning Ave Storm Sewer Replacement 2022 Supply and Delivery of Sweeper 2022 Petticoat Creek Library Reading Garden Enclosure 2022 PCL Makerspace 2022 Highway 401 Notion Rd Crossing 2023 Banquet Hall and Washroom Renovations Liverpool Road Reconstruction and Minor Storm Sewer Repair 2023 from Ilona Park Road to Krosno Boulevard 2023 Supply & Delivery of one new 55 Foot Aerial Quint Fire Truck 2023 Don Beer Arena-Ice Rink 2 Renovations Pickering Recreation Complex Doubles Squash Court and 2023 Aerobics Studio 2023 Sheppard Ave, Reinforced Soil System Supply and Delivery of One New Latest Model Year Articulating 2023 Front Loader 2024 Supply and Delivery of Road Grader with Attachments 2026 Southview Drive -Road Reconstruction & Urbanization Westshore Neighbourhood-Flood Remediation, Breezy & 2026 Vistula Roads Reconstruction Supply & Delivery of One 2013 Smeal Heavy Duty Aerial 2026 Ladder 2026 Pool Deck Repairs at Dunbarton Indoor Pool 2026 Don Beer Arena Roof Replacement AIP: Sixth Concession Rd -Road Reconstruction and Storm 2027 Sewer Replacement, Greenwood Road to Westney Road 2028 Supply & Delivery of One Fire Pumper Tanker 2029 Indoor Soccer Facility 2029 Westney Road -Road Reconstruction 2029 Salem Road -Road Reconstruction Brock Ridge Community Park and S.M.Woodsmere Park- 2029 Baseball Diamond Improvements Project 2029 Centennial Park Baseball Diamond Reconstruction Project 2030 Purchase of land for Seaton North Fire Station Delaney Arena Improvements at the Pickering Recreation 2031 Complex 2032 Pickering Civic Complex Roof Repairs 2032 Pickering Recreati~m Complex Roof Repairs Abbott Crescent Stormwater Management Pond- 2033 Reconstruction 2034 Whitevale Bridge 175 Borrowed Outstanding Committed Principal Amount Balance-2021 1,057,000 118,000 420,000 48,000 1,500,000 41,155 174,000 36,524 250,000 52,476 112,000 18,733 100,000 20,916 486,000 486,000 490,000 109,150 495,000 110,264 680,000 151,474 263,000 109,122 833,000 345,623 367,000 152,273 200,000 82,983 369,000 222,000 660,000 342,330 815,000 422,725 1,020,000 529,056 899,000 466,295 460,000 238,594 1,540,000 966,952 749,000 544,000 3,734,000 1 2,201,000 1,496,000 1,232,735 700,000 576,815 919,000 757,275 357,000 294,176 1,856,000 2 1,675,000 2,249,000 1,563,000 520,000 398,708 550,000 421,710 342,000 284,000 1,400,000 1,013,000 Maturity Date Projects City of Pickering 2022 Outstanding Debt Summary Supply and Delivery of a Fire Pumper Rescue Replacement 2036 Project 2037 New Operations Centre Conservation Barn Reconstruction at the Pickering Museum 2038 Village Pickering Recreation Complex Roof & Skylight Rehabilitation 2039 Program Chestnut Hill Developments Recreation Complex -Lobby & 2041 Core Area Renovations -Construction Construction of a New Fire Station and Headquarters on Zent 2041 Drive Total Debt Commitments-Dec. 31, 2021 Borrowed Committed Amount 990,000 9,907,000 3 850,000 690,000 5,600,000 8,978,000 4 55,077,000 Loan & External Debt Approved in Prior Years' Capital Budget-Still to be issued External Debt To be Issued by the Region 2031 Backup Generator Replacement-Rec Complex 2031 Westney Road -Full Road Reconstruction (From Concession 8 2041 Michell Bridge -Rehabilitation Sub-total Debt to be Issued 2022 New Debt (To be Approved by Council) New Debentures New Internal Loans Sub-total 2022 Debt Note: City Centre project debt is excluded 1 Funded from contribution from the Pickering Soccer Club 2 Funded from Property Taxes $758K & Dev Charges Res Fund $1.098M 3 Funded from Development Charges Reserve Fund 4 Funded from Property Taxes $2.765M & Dev Charges Res Fund $6.213M 176 975,180 300,000 850,000 7,575,000 0 Outstanding Principal Balance-2021 990,000 8,328,000 751,000 630,000 5,600,000 8,978,000 41,309,063 975,180 300,000 850,000 2,125,180 7,575,000 0 7,575,000 _. -.J -.J Attachment #1 to Report #FIN 11-21 City of Pickering 2020 Statement of the Treasurer -Development Charges Reserve Fund -{Pre Audit) For the year ended December 31, 2020 DC Act S 43 {2)(a) Services to which the Development Charges Relates 100% Recovery (Non-Discounted) 10% Statutory Deduction (Discounted) Account 7605 7610 7615 7611 7601 7622 7630 Protective Other Services Storm Water Library: Transportation Related to a Studies (Deficit) Parks & Recreation Facilities & Description Services Hiahwav /Deficitl Mgmt .. ~+~.;~,~ $ $ $ $ $ $ $ Opening Balance, January 1, 2020 2,150,240 29,442,394 (370,535) 3,459,209 (1,055,633) 24,428,981 4,543,599 Plus: Development Charges Collections 845,812 4,691,778 417,438 273,368 268,070 5,030,476 965,259 Interest Income-Internal Investment 1,302 17,832 -2,095 -14,795 -2,752 Interest Income-Negative Balance 373 5,114 (3,583) 601 (7,537) 4,243 789 Interest Income -External Investment 36,316 497,257 -58,423 -412,585 -76,738 Less Adm in Fee (2,152) (29,460) -(3,461) -(24,444) -(4,546) Sub-Total 881,651 5,182,521 413,855 331,026 260,533 5,437,655 1,040,992 Less: 2020 Transfer to Capital Funds 1 (359,380) (2,228,102) (458,539) (8,939) (506,053) (1,909,273) (461,000) 2020 Transfer to Current Funds 1 --(412,195) 3 -(163,226) /263,534)' - Sub-Total 2020 (359,380) (2,228,102) (870,734) (8,939) (669,279) (2, 172,807) -(461,000) Closing Balance, December 31, 2020 before Budget Commitments 2,672,511 32,396,812 (827,415) 3,781,297 (1,464,379) 27,693,829 5,123,592 Less Budget Commitments 2 (9,225,494) (6,350,300) (482,262) (3,624,038) (1,099,327) (71,648,769) -(21,794,312) Less Operations Ctr Debt Chrgs Commitments 2021-2037 --(7,044,856) 4 --/4,464,261) 4 - Sub-Total BudQet Commitments (9,225,494) (6,350,300) (7,527 118) (3,624,038) (1,099,327) (76,113,030) (21,794,312) Closing Balance, December 31, 2020 after Budget Commitments-(Deficit) (6,552,983) 26,046,512 (8,354,533) 157,259 (2,563,706) (48,419,200.63) (16,670,720) Notes '· See Attachment 2 for detailed breakdown. 2 Budget commitments include capital projects previously approved, but have not proceeded or still ongoing. 2020 & Prior Commitments. 3• Annual principal & interest payment related to the New Operations Centre debenture financing, at a funding ratio of 61% from "Other Services Related to a Highway" and 39% from "Parks & Recreation" 4• Includes outstanding principal & interest payments related to the 20-year development charges debenture financing for the new Operations Centre. Total o'A.ing from 2021-2037. Original principal & interest payment of $13.Sm The Municipality is compliant with s.s.59.1 (1) of the Development Charges Act, whereby charges are not directly or indirectly imposed on development nor has a requirement to construct a service related to development been imposed, except as permitted by the Development Charges Act or another Act. Total $ 62,598,255 12,492,201 38,776 0 1,081,319 (64,063) 13,548,233 (5,931,286) (838,955) (6,770,241) 69,376,247 (114,224,502) (11,509,117) (125,733,619) (56,357,372)