Loading...
HomeMy WebLinkAbout2021 Current Budget SummaryCity of Pickering 2021 Approved Current Budget Summary Table of Contents Department Page Introduction & Summaries 1 Office of the Chief Administrative Officer 11 Office of the CAO-Ad min 2121 17 Customer Care Centre 2129 18 Public Affairs & Corp. Comm. 2621 19 City Development 20 City Development-Admin 2610 26 Planning 2611 27 Building Services 2612 28 Sustainability 2620 29 Committee of Adjustment 2630 30 Heritage Pickering 2743 31 Community Services Culture, Recreation & Facilities 32 Culture & Recreation -Admin 2711 41 Civic Centre 2124 42 Senior Citizens Centre 2572 43 Programs 2712 44 Dunbarton Pool 2713 46 Don Beer Arena 2715 47 Community Centres 2719 49 Recreation Complex-Central Core 2731 51 Recreation Complex-Pool 2733 53 Recreation Complex-Arenas 2735 54 Museum 2744 56 Pickering Arts Centre 2740 58 Public Works 59 Operations -Admin 2500 65 Property Maintenance 2132 66 Fleet Services 2315 67 Roads 2320 68 Parks 2718 70 Corporate Services 72 Information Technology 2196 78 Legal Services 2125 79 Clerks Office 2122 80 Records Management & Elections 2191 81 2021 Approved Current & Capital Budget City Council approved the Draft 2021 Current and Capital Budgets at its March 22, 2021 Council meeting. Overall, the 2021 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 2021 tax increase to the City's net budget is 1.45 percent. When combined with the proposed increase for Durham Region and Education, the overall tax increase is 1.54 percent (assuming a Durham Region increase of 1.99 percent). The 2021 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. Budgetary pressures associated with COVID are expected to continue into 2021, in particular, program revenues for Community Services Department. Staff have invested considerable time reviewing the financial impacts on programs and services experienced over the past several months and have assumed current conditions will continue well into 2021 until the vaccine has been distributed around September. After September, the budget model assumes that the Pickering community will gradually experience a return to a certain degree to the new "modified normal". 1 Service Level Increases Waterfront By-law Enforcement ($51,000) During the current term of Council, there have been investments made to strengthen By-law enforcement. These investments were: 2019 • By-law Administration Clerk (Full Time position) This position was deployed to address the "paper/admin processing" to free up By- law officers time. 2020 • By-law Supervisor (Full Time) • By-law Officer (Full Time) • By-law Officer (Part-Time) Even with these additional resources, as demonstrated last summer, there is still a need for additional staffing resources to provide By-law enforcement for the waterfront and park areas from Mid-May to labour day for evenings, weekends and statutory holidays. Hiring term staff to provide coverage for waterfront and park areas from mid-May, 2021 to Labour Day, weekday evenings from 5:00 pm until 9:30 pm, weekends and statutory holidays from 10 am to 9: 30 pm would cost $51,000. Term staff would patrol parks and waterfront areas to ensure compliance with the Parks By-law, Traffic and Parking By- law, Nuisance By-law, Noise By-law and COVID 19 regulations. Issues to be monitored would include use of barbeques, campfires, noise levels, alcohol, smoking, dogs off leash and parking concerns. Investment to Meet Accessibility Compliance ($121,300) The Province of Ontario has strengthened its Information and Communications Standards under the Accessibility for Ontarians with Disabilities Act (AODA). These new standards became effective on January 1, 2021. Pickering has to file an accessibility compliance report as of December 31, 2021 and that report has to identify the City's accomplishments to date and provide a roadmap to achieving and or meeting the new Provincial standard. A high level breakdown of the project's cost is presented below. Contract Position Outsourcing -document remediation Software Site Scanning Total $ 70,000 30,000 13,800 7,500 $ 121,300 Without these additional resources, the City would be challenged to partially meet the Provincial standard. 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 r Office of the CAO Department \. I / '\ / ' Economic Development Customer Care Centre Public Affairs & & Strategic Projects Corporate Communication \. Key Activities for 2021 • Coordinate the City activities associated with the Durham Live development • Confirm updated City Centre project costs and funding strategy for Council consideration • City-wide education and engagement strategy on development • Review and expand e-commerce functionality • Naming rights and sponsorship opportunities • Broaden community engagement efforts on select City initiatives • Project stakeholder management for various proposed residential, commercial and industrial development plans • Enhanced marketing & communications for economic development and website/mobile applications • Investment attraction and project management of the Pickering Innovation Corridor • Development and management of the Pickering Nuclear Generating Station (PNGS) Social, Economic and Financial Impact Study • Development and implementation of the Pickering Local Economy Resilience Strategy 11 Financial Information Staffing Summary (Full & Regular Part Time) Approved Current Term 2019 2020 A .pprove d 2021 2018 14 Add Delete Total Full Time Reg. Part-Time Total 1 15 14 _j_ 15 14 _j_ 15 3 Q 3 0 17 Q 1 0 18 The department proposes one full-time Coordinator, Diversity & Inclusion position ($65,400). This new position will lead the corporate team on the development and implementation of the Corporate Wide Diversity & Inclusion strategy, as well as the associated programs and training. Available grant funding opportunities will be pursued for this new position. The other two proposed full-time positions are conversions from contract for the following: Economic Development & Strategic Projects Associate ($85,945) and Public Affairs Assistant ($71,640). The dollar figures includes salaries and benefits. Year-Over-Year (Net Cost) Budget Changes 2020 Budget 2021 Approved Budget YearNear Increase ($) (%) CAOAdministration $1,042,583 $1,185,007 $142,424 13.66 Customer Care Centre 441,656 497,914 56,258 12.74 Public Affairs & Corp. Comm. 509,995 783,611 273,616 53.65 ---~----~------'-------Tot a I (Net Cost) $1,994,234 $2,466,532 $472,298 23.68 ============================a====== Explanation of Significant Changes -Expenditures • Under the CAO Administration cost centre, the consulting account includes an expenditure of $252,000 to undertake a study for the financial impact for the closure of the Pickering Nuclear Generating Station that is equally funded by the City, OPG and Durham Region. It is anticipated that this consulting assignment will be completed by the second quarter of 2022. • Under the Public Affairs & Corp. Communications cost centre, the consulting account includes an expenditure of $50,000 for consulting resources to assist staff with high profile density development applications as it relates to communication and public engagement. 12 • Under the Customer Care cost centre, there is an addition of $50,90.0 (salary and benefits) for one temporary full time Customer Care Rep I to meet the increased call volume and workload due to COVID and City growth. Explanation of Significant Changes -Revenues/ (Transfer from Reserves) • Conversion of two contract positions previously funded from the rate stabilization reserve has resulted in a reduction in reserve funding translating into a higher Net Cost for the following two cost centres: CAO Administration and Public Affairs & Corporate Communications. 2020 Performance Indicators/Statistics E . D conom1c eve opmen ra eg1c roJec s t & St t . P . t Business Inquiries 1,200+ Business Consultations 100+ COVID Business Recovery Podcast Series 428 views Investment Inquiries 90 City-led Business Events (i.e. Town Halls and Realtor & 1,000 views Developer Symposium) COVID Business Events/Webinars with Partners 4,000+ views COVID Social Media Posts and Mail-outs (i.e. Newsletters, 3,000+ Social Media Posts) Support Local Campaian profiles (i.e. Profiling small businesses) 95 Customer Care Telephone 41,378 Counter -in person inquiries made by the public at the 703 Customer Care Centre (located at City Hall) AMANDA Service Requests -AMANDA is a property based 21,093 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 Customer Care staff 533 during regular business hours. Customer Care Web Email 4,125 Pingstreet -Smart App enabling residents to submit a request 414 for service or ask a question of the City. After-Hours Calls -calls received from the City's contracted 1,519 after-hours service provider that are screened and processed by City staff on the next business day. Total 69,765 13 Communication Website Website (pickering.ca) visits 494,364 visitors 1,445, 159 unique page views Website News Centre (Media Releases) 55,979 unique page views Social Media ~CityofPickering only (corporate account) Facebook Likes (new for 2020) 1,334 Total: 8,784 lnstagram Followers (new for 2020) 2,939 Total: 6,818 Twitter Impressions 1,117,100 Twitter Followers (new for 2020) 1,050 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 Unique Users 750 14 Office of the CAO Department 2019 Actuals Expenditures 1100 Salaries & Wages 1,241,369 1200 Overtime 422 1400 Employer Contributions 326,318 1800 Conferences 14,077 2110 Travel 39,609 2115 Bus Dev & City Pronio 20,345 2131 Cellular Phones 10,576 2140 Telephones 21,702 2210 Advertising 20,554 2211 Trade Shows, Exhib & Display~ 11,022 2220 Subscription & Publications 1,991 2340 Seminars & Education 5,770 2365 Purch Prnting/Broch/News Ur 4,095 2370 Insurance Premium 8,594 2392 Consulting & Professional 216,136 2394 Recpt, Prom & Sp Events 102,599 2395 Memberships 5,372 2396 Photo, Mapping, Printing 5,665 2399 Outside Agency Serv 23,443 2479 Software/Hardware Maintenanc 2,158 5300 Stationery & Office Supplies 4,266 5320 Program Supplies 11,566 5530 Utilities -Hydro 988 5900 Gas, Oil Tires 429 6100 Website Support Intranet 36,595 Total Expenditures 2,135,661 Revenues 9990 Other Revenue (11,540) 9954 Netted Revenue 0 9940 Advertising 0 9965 Cost Recoveries (37,699) 9985 Marketing Sponsorships (84,916) 1511 Film Permits (12,250) Total Revenues (146,405) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuin.g Stu (9,774) Total Transfers (9,774) City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 1,512,111 1,644,473 (111) 2,250 373,473 390,330 3,203 14,000 21,099 40,550 1,193 23,000 10,288 11,600 18,063 25,625 11,996 25,000 7,063 17,000 3,797 3,695 703 6,500 4,036 6,000 8,750 8,750 81,910 193,600 50,748 116,750 6,566 8,365 2,067 6,000 30,588 87,850 3,521 9,306 3,804 4,100 7,514 15,700 1,216 3,300 0 1,000 28,369 42,615 2,191,967 2,707,359 (7,850) (15,000) 0 0 0 (50,000) 0 (180,000) 0 (75,000) (18,500) 0 (26,350) (320,000) 0 (393,125) 0 0 0 (393,125) 15 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 181,683 1,826,156 11.05% 0 2,250 0.00% 36,312 426,642 9.30% (1,000) 13,000 (7.14%) 0 40,550 0.00% 0 23,000 0.00% 900 12,500 7.76% (515) 25,110 (2.01%) (2,000) 23,000 (8.00%) 0 17,000 0.00% (250) 3,445 (6.77%) 7,500 14,000 · 115.38% 0 6,000 0.00% 170 8,920 1.94% 398,836 592,436 206.01% (3,000) 113,750 (2.57%) 360 8,725 4.30% (2,000) 4,000 (33.33%) 27,000 114,850 30.73% 13,333 22,639 143.27% 0 4,100 0.00% (15,000) 700 (95.54%) 0 3,300 0.00% 0 1,000 0.00% 6,950 49,565 16.31% 649,279 3,356,638 23.98% 15,000 0 (100.00%) (11,500) (11,500) 0.00% 0 (50,000) 0.00% (143,000) (323,000) 79.44% 0 (75,000) 0.00% 0 0 0.00% (139,500) (459,500) 43.59% 10,855 (382,270) (2.76%) (48,336) (48,336) 0.00% (37,481) (430,606) 9.53% Office of the CAO Department 2019 Actuals Net 1,979,482 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 2,165,617 1,994,234 16 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 472,298 2,466,532 23.68% 2121 Office of the CAO -Adm in 2019 Actuals Expenditures 1100 Salaries & Wages 574,383 1200 Overtime 0 1400 Employer Contributions 136,898 1800 Conferences 11,231 2110 Travel 37,391 2115 Bus Dev & City Promo 19,231 2131 Cellular Phones 7,603 2140 Telephones 824 2210 Advertising 12,129 2211 Trade Shows, Exhib & Displayi 11,022 2220 Subscription & Publications 794 2340 Seminars & Education 5,186 2370 Insurance Premium 2,702 2392 Consulting & Professional 123,687 2394 Reep!, Prom & Sp Events 91,702 2395 Memberships 4,634 2399 Outside Agency Serv 22,050 2479 Software/Hardware Maintenanc 485 5300 Stationery & Office Supplies 3,740 5900 Gas, Oil Tires 429 Total Expenditures 1,066,121 Revenues 9965 Cost Recoveries (37,699) 9985 Marketing Sponsorships (84,916) Total Revenues (122,615) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuing Stu (9,774) Total Transfers (9,774) Net 933,732 City of Pickering 2021 - Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 848,794 967,583 0 750 192,808 222,142 3,203 8,500 21,050 34,000 1,193 20,000 7,270 7,400 1,493 2,115 6,420 15,000 7,063 17,000 293 775 132 5,000 2,750 2,750 54,149 125,000 44,125 103,000 5,983 7,520 12,475 22,350 970 1,493 2,920 2,500 0 1,000 1,213,091 1,565,878 0 (180,000) 0 (75,000) 0 (255,000) 0 (268,295) 0 0 0 (268,295) 1,213,091 1,042,583 17 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (985) 966,598 (0.10%) 0 750 0.00% 3,842 225,984 1.73% 0 8,500 0.00% 0 34,000 0.00% 0 20,000 0.00% 900 8,300 12.16% (65) 2,050 (3.07%) 0 15,000 0.00% 0 17,000 0.00% 0 775 0.00% 0 5,000 0.00% 50 2,800 1.82% 370,336 495,336 296.27% 0 103,000 0.00% 355 7,875 4.72% 0 22,350 0.00% 177 1,670 11.86% 0 2,500 0.00% 0 1,000 0.00% 374,610 1,940,488 23.92% (143,000) (323,000) 79.44% 0 (75,000) 0.00% (143,000) (398,000) 56.08% (40,850) (309,145) 15.23% (48,336) (48,336) 0.00% (89,186) (357,481) 33.24% 142,424 1,185,007 13.66% 2129 Customer Care Centre 2019 Actuals Expenditures 1100 Salaries & Wages 308,373 1200 Overtime 0 1400 Employer Contributions 97,193 1800 Conferences 1,140 2110 Travel 717 2131 Cellular Phones 619 2140 Telephones 19,576 2340 Seminars & Education 0 2370 Insurance Premium 2,533 2394 Recpt, Prom & Sp Events 41 2395 Memberships 399 2479 Software/Hardware Maintenanc 0 5300 Stationery & Office Supplies 267 5320 Program Supplies 11,566 Total Expenditures 442,424 Revenues 9990 Other Revenue (11,540) Total Revenues (11,540) Transfers to/from Reserves & R.F. Total Transfers 0 Net 430,884 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 360,693 312,237 89 1,000 104,638 96,783 0 1,500 0 800 233 800 15,575 22,100 0 500 2,580 2,580 0 750 416 495 527 811 410 600 7,514 15,700 492,675 456,656 (7,850) (15,000) (7,850) (15,000) 0 0 484,825 441,656 18 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 50,857 363,094 16.29% 0 1,000 0.00% 5,681 102,464 5.87% 0 1,500 0.00% 0 800 0.00% 0 800 0.00% (65) 22,035 (0.29%) 0 500 0.00% 50 2,630 1.94% 0 750 0.00% 5 500 1.01% (270) 541 (33.29%) 0 600 0.00% (15,000) 700 (95.54%) 41,258 497,914 9.03% 15,000 0 (100.00%) 15,000 0 (100.00%) 0 0 0.00% 56,258 497,914 12.74% 2621 Public Affairs & Corp. Comm. 2019 Actuals Expenditures 1100 Salaries & Wages 358,613 1200 Overtime 422 1400 Employer Contributions 92,227 1800 Conferences 1,706 2110 Travel 1,501 2115 Bus Dev & City Promo 1,114 2131 Cellular Phones 2,354 2140 Telephones 1,302 2210 Advertising 8,425 2220 Subscription & Publications 1,197 2340 Seminars & Education 584 2365 Purch Prnting/Broch/News Ur 4,095 2370 Insurance Premium 3,359 2392 Consulting & Professional 92,449 2394 Recpt, Prom & Sp Events 10,856 2395 Memberships 339 2396 Photo, Mapping, Printing 5,665 2399 Outside Agency Serv 1,393 2479 Software/Hardware Maintenan< 1,673 5300 Stationery & Office Supplies 259 5530 Utilities -Hydro 988 6100 Website Support Intranet 36,595 Total Expenditures 627,116 Revenues 9954 Netted Revenue 0 9940 Advertising 0 1511 Film Permits (12,250) Total Revenues (12,250) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 Total Transfers 0 Net 614,866 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 302,624 364,653 (200) 500 76,027 71,405 0 4,000 49 5,750 0 3,000 2,785 3,400 995 1,410 5,576 10,000 3,504 2,920 571 1,000 4,036 6,000 3,420 3,420 27,761 68,600 6,623 13,000 167 350 2,067 6,000 18,113 65,500 2,024 7,002 474 1,000 1,216 3,300 28,369 42,615 486,201 684,825 0 0 0 (50,000) (18,500) 0 (18,500) (50,000) 0 (124,830) 0 (124,830) 467,701 509,995 19 Run Date: 4/21/21 3:54 PM 2021 INC.IDEC. Approved % CHGE. Budget 2020 131,811 496,464 36.15% 0 500 0.00% 26,789 98,194 37.52% (1,000) 3,000 (25.00%) 0 5,750 0.00% 0 3,000 0.00% 0 3,400 0.00% (385) 1,025 (27.30%) (2,000) 8,000 (20.00%) (250) 2,670 (8.56%) 7,500 8,500 750.00% 0 6,000 0.00% 70 3,490 2.05% 28,500 97,100 41.55% (3,000) 10,000 (23.08%) 0 350 0.00% (2,000) 4,000 (33.33%) 27,000 92,500 41.22% 13,426 20,428 191.75% 0 1,000 0.00% 0 3,300 0.00% 6,950 49,565 16.31% 233,411 918,236 34.08% (11,500) (11,500) 0.00% 0 (50,000) 0.00% 0 0 0.00% (11,500) (61,500) 23.00% 51,705 (73,125) (41.42%) 51,705 (73,125) (41.42%) 273,616 783,611 53.65% 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 ,, " / Planning Division* Building Services Planning & Design Policy & Geomatics ' Zoning & Administration \_ * Includes Committee of Adjustment and Heritage Pickering Key Activities for 2021 "I I "I r Sustainability ' • Initiate Phase 2 of the Comprehensive Zoning By-law Review and the draft by-law consultation program • Recommend official plan and zoning amendments for both the Kingston Road Corridor & Specialty Retailing Node and the Infill & Replacement Housing Studies • Complete the Pickering Housing Strategy Study • Select and implement Phase 1 of Integrated Digital Solution • Review high density intensification applications (Universal City, Kingston Road Corridor and Brock Node) • Initiate Northeast Pickering community planning study • Initiate Waterfront & Nautical Village Visioning Exercise 20 "I • Complete the review and recommend a new Sign By-law Ooint initiative with Corporate Services Department) • Implement year 2 of the 5-year Corporate Energy Management Plan • Implement Corporate Waste Diversion Initiative • Develop new Integrated Sustainable Building & Development Standards Financial Information Staffing Summary (Full & Regular Part Time) Approved Current Term 2019 2020 Approved 2021 2018 44 0 44 Add Delete Total Full Time Reg. Part-Time Total 51 0 51 51 _Q 51 0 0 51 Q 0 _Q 0 0 51 No additional staffing recommended for 2021. There will be reclassifications of certain positions to accommodate workload demands for 2021. Year-Over-Year (Net Cost) Budget Changes 2020 Budget 2021 Approved Budget YearNear Increase ($) (%) City Development -Adm. $705,458 $776,919 $71,461 10.13 Planning 1,580,003 1,742,211 162,208 10.27 Building Services (580,772) (1,083,776) (503,004) 86.61 Sustainability 661,347 662,429 1,082 0 .16 Committee of Adjustment 10,464 10,071 (393) (3.76) Heritage Pickering 19,725 16,375 (3,350) (16.98) Total (Net Cost) =$==2==,3=9=6==,2=55===$2='=, 1=2=4==,2=2=9 ~($'==2=7aa=1,=99=6='=) ===(1=1=.3=5==) = Explanation of Significant Budget Changes -Expenses • Consulting & Professional -Budget increase of $1,385,951 reflects studies, directed by Council resolution, including $1,000,000 for Northeast Pickering background studies (71 % funded by landowners and 29% DC funded), and $50,000 for the Waterfront & Nautical Village Visioning Exercise. This amount also includes $75,000 for the first phase of a corporate strategic plan for the City's mapping system (39% DC funded), and additional funds to support external building permit submission reviews. 21 • Software/Hardware Maintenance -Budget increase of $61,883 reflects an increase in the annual software maintenance cost of $5,000 for the City's property data base system (AMANDA), the purchase of a new software & training subscription in the amount of $45,800 (which will help automate tasks now done by manual data input); and the purchase of new software in the amount of $12,720 (to allow for remote plan review, mark-up, changes and approvals by multiple staff). • Program Supplies -Due to COVID, several events and programs are either being modified, cancelled, or held virtually, resulting in a budget decrease of $29,730. Explanation of Significant Budget Changes -Revenues (Transfer from Reserves) • Sale of Services Planning Applications -Development application activity is variable. Budget increase of $140,500 based on anticipated applications for 2021. • Cost Recoveries -Budget increase of $662,745 based on funding from North East Pickering landowners group of studies in support of the official plan amendment. • Misc Income -Budget increase of $273,000 reflects amount of grant funding being pursued for Phase 2 of Sustainable Development Guidelines. • Transfer from Reserves -Due to COVID, several studies were delayed, which resulted in a net budget increase of $447,456 for transfers from reserves. It is anticipated that they will continue and/or proceed in 2021. ·2020 Performance Indicators/Statistics Building Services Permits Issued 1,021 Number of Inspections 12,117 Number of Investigations 204 Pl A I" f annmg pp 1ca 10ns To P&D Committee & Council 27 To Committee of Adjustment 71 To Site Plan Committee 26 To Heritage Committee/Delegated 3 Comments On policy initiatives of other 5 On Land Divisions 8 Film Permits 16 Pre-consultations 19 Reports I Information · Recommendations 16 28 22 Requests Geomatics Requests (e.g., mapping, addressing, program queries 413 and updates, open data portals) Legal, Vehicle & Zoning Compliance 115 Site Plan Approvals Issued 6 Special Studies, Projects, Reviews Underway 4 S t . bTt us ama 11ty Energy Conservation Incentives $112,000 collected Sustainable Pickering Initiatives -Workshops 4 (600 participants) -Trees and Shrubs Planted 690 -Farmers Market 4,550 attendees -Virtual Farmers Market 9,571 website views Waste Reduction & Diversion -Dog Waste 6.4 tonnes -Batteries 91 kilograms -Waste Diversion Receptacles 165 installed Notes ' Metrics are not inclusive of all City Development events/programs/projects. Metrics do not distinguish between the levels of complexity of requests/applications. Metrics do not reflect all work of all positions in the Department. 23 City Development Department 2019 Actuals Expenditures 1100 Salaries & Wages 4,007,956 1200 Overtime 5,575 1400 Employer Contributions 1,016,052 1800 Conferences 15,831 1900 Uniforms 1,582 2110 Travel 33,153 2131 Cellular Phones 8,348 2140 Telephones 13,934 2210 Advertising 7,653 2211 Trade Shows, Exhib & Display~ 1,733 2220 Subscription & Publications 8,274 2340 Seminars & Education 30,286 2365 Purch Prnting/Broch/News Ltr 397 2370 Insurance Premium 26,122 2371 Ins. Deductible 0 2392 Consulting & Professional 501,114 2394 Recpt, Prom & Sp Events 18,307 2395 Memberships 28,044 2396 Photo, Mapping, Printing 700 2399 Outside Agency Serv 12,656 2457 Veh -Repairs & Maintenance 855 2479 Software/Hardware Maintenanc 132,441 2635 Building Rentals 0 2678 Rental Misc Equip 9,845 5300 Stationery & Office Supplies 20,292 5302 Forms 1,130 5320 Program Supplies 153,603 5400 Gift Shop Plaques 0 5900 Gas, Oil Tires 66 5902 Supplies & Tools 723 5975 Hardware Replacements 0 Total Expenditures 6,056,672 Revenues 1460 Sale of Serv -Plan Admin (1,352) 1461 Sale of Serv -Plan Appl (1,275,325) 1517 Licenses & Permits (3,101,416) 1592 Donations 0 1623 Ont. Specific Grants 0 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 4,325,911 4,615,390 24,001 13,750 1,113,023 1,185,063 5,670 20,825 935 4,900 13,863 32,420 8,199 12,000 13,685 19,410 4,319 10,500 1,614 4,000 6,754 7,900 20,824 42,780 5,485 5,000 26,590 26,590 2,114 2,000 363,413 875,039 2,510 23,650 25,748 35,080 1,955 4,250 1,031 16,000 1,123 2,000 132,774 133,092 0 300 10,146 10,150 20,741 25,650 458 3,000 92,148 170,725 0 2,500 16 1,000 1,529 2,300 3,942 6,000 6,230,521 7,313,264 (1,639) (2,000) (1,875,085) (1,025,000) (3,080,737) (3,010,000) 0 (1,500) 0 0 24 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (40,336) 4,575,054 (0.87%) 3,000 16,750 21.82% 47,507 1,232,570 4.01% (8,600) 12,225 (41.30%) (2,000) 2,900 (40.82%) (11,200) 21,220 (34.55%) 1,700 13,700 14.17% (290) 19,120 (1.49%) (370) 10,130 (3.52%) (1,500) 2,500 (37.50%) (1,000) 6,900 (12.66%) 1,670 44,450 3.90% 1,000 6,000 20.00% 530 27,120 1.99% 0 2,000 0.00% 1,385,951 2,260,990 158.39% (9,200) 14,450 (38.90%) (4,410) 30,670 (12.57%) 5,780 10,030 136.00% (6,500) 9,500 (40.63%) 0 2,000 0.00% 61,883 194,975 46.50% 0 300 0.00% 0 10,150 0.00% (5,500) 20,150 (21.44%) (2,000) 1,000 (66.67%) (29,730) 140,995 (17.41%) (2,500) 0 (100.00%) 2,000 3,000 200.00% 1,000 3,300 43.48% 4,000 10,000 66.67% 1,390,885 8,704,149 19.02% 0 (2,000) 0.00% (140,500) (1,165,500) 13.71% 10,000 (3,000,000) (0.33%) 1,000 (500) (66.67%) (14,680) (14,680) 0.00% City Development Department 2019 Actuals 9990 Other Revenue (29,516) 9950 EventVendorFees (22,883) 9965 Cost Recoveries (28,746) 9980 Sponsorships No Tax 0 9985 Marketing Sponsorships 0 9990 Misc Income (5,375) 1511 Film Permits 0 9993 0th Rev -Rebates/Incentive (250) 1530 Rntl -CCC Roof Solar Panel (6,000) Total Revenues (4,470,863) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuing Stu (280,006) 1920 Transfer to/(from) Reserve Fun (158,677) Total Transfers (438,683) Net 1,147,126 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget (17,626) (35,000) (14,831) (25,000) (95,465) (281,965) 0 (5,000) 0 (1,000) (1,260) (4,000) 0 (7,500) (100,316) (40,000) (6,000) (6,000) (5,192,959) (4,443,965) 0 (233,840) (110,290) (144,424) (93,172) (94,810) (203,462) (473,074) 834,100 2,396,225 25 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 0 (35,000) 0.00% 0 (25,000) 0.00% (662,745) (944,710) 235.05% 1,500 (3,500) (30.00%) (2,000) (3,000) 200.00% (273,000) (277,000) 6,825.00% (135,000) (142,500) 1,800.00% 0 (40,000) 0.00% 0 (6,000) 0.00% (1,215,425) (5,659,390) 27.35% (119,505) (353,345) 51.11% 100,674 (43,750) (69.71%) (428,625) (523,435) 452.09% (447,456) (920,530) 94.58% (271,996) 2,124,229 (11.35%) 2610 City Development -Admin 2019 Actuals Expenditures 1100 Salaries & Wages 468,201 1200 Overtime 0 1400 Employer Contributions 114,635 1800 Conferences 2,316 2110 Travel 577 2131 Cellular Phones 421 2140 Telephones 1,838 2220 Subscription & Publications 5,999 2340 Seminars & Education 1,107 2370 Insurance Premium 3,052 2394 Recpt, Prom & Sp Events 1,018 2395 Memberships 224 2479 Software/Hardware Maintenanc 132,441 2678 Rental Misc Equip 9,845 5300 Stationery & Office Supplies 1,586 5902 Supplies & Tools 0 Total Expenditures 743,260 Revenues 1460 Sale of Serv-Plan Admin (1,352) Total Revenues (1,352) Transfers to/from Reserves & R.F. Total Transfers 0 Net 741,908 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 417,578 433,573 0 500 110,671 122,746 0 1,000 17 500 269 800 1,742 2,470 5,742 3,500 0 2,500 3,105 3,105 0 500 0 500 125,020 122,514 10,146 10,150 1,230 3,000 0 100 675,520 707,458 (1,639) (2,000) (1,639) (2,000) 0 0 673,881 705,458 26 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 8,061 441,634 1.86% 0 500 0.00% 1,873 124,619 1.53% (1,000) 0 (100.00%) (500) 0 (100.00%) 0 800 0.00% (80) 2,390 (3.24%) 1,000 4,500 28.57% (1,000) 1,500 (40.00%) 65 3,170 2.09% 0 500 0.00% 0 500 0.00% 64,542 187,056 52.68% 0 10,150 0.00% (1,500) 1,500 (50.00%) 0 100 0.00% 71,461 778,919 10.10% 0 (2,000) 0.00% 0 (2,000) 0.00% 0 0 0.00% 71,461 776,919 10.13% 2611 Planning 2019 Actuals Expenditures 1100 Salaries & Wages 1,703,917 1200 Overtime 2,734 1400 Employer Contributions 429,238 1800 Conferences 3,494 1900 Uniforms 249 2110 Travel 5,427 2131 Cellular Phones 1,465 2140 Telephones 5,260 2210 Advertising 0 2340 Seminars & Education 2,851 2370 Insurance Premium 12,920 2371 Ins. Deductible 0 2392 Consulting & Professional 255,236 2394 Recpt, Prom & Sp Events 514 2395 Memberships 10,493 2396 Photo, Mapping, Printing 0 2479 Software/Hardware Maintenanc 0 2635 Building Rentals 0 5300 Stationery & Office Supplies 11,007 5902 Supplies & Tools 1 Total Expenditures 2,444,806 Revenues 1461 Sale of Serv-Plan Appl (1,275,325) 9965 Cost Recoveries (28,746) 1511 Film Permits 0 Total Revenues (1,304,071) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuing Stu (131,258) 1920 Transfer to/(from) Reserve Fun (116,784) Total Transfers (248,042) Net 892,693 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 1,906,580 1,979,414 4,530 5,250 466,566 505,858 2,290 6,500 51 600 593 3,450 1,364 3,200 5,225 7,410 0 1,000 4,123 5,400 13,150 13,150 2,114 1,000 288,802 603,459 15 850 11,389 16,880 429 3,000 3,274 5,041 0 300 10,527 13,000 0 200 2,721,022 3,174,962 (1,875,085) (1,025,000) (38,365) (62,385) 0 (7,500) (1,913,450) (1,094,885) 0 (233,840) (110,290) (144,424) (93,172) (121,810) (203,462) (500,074) 604,110 1,580,003 27 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 286,451 2,265,865 14.47% 0 5,250 0.00% 89,851 595,709 17.76% (1,000) 5,500 (15.38%) 0 600 0.00% (1,000) 2,450 (28.99%) 800 4,000 25.00% 100 7,510 1.35% 0 1,000 0.00% 10,700 16,100 198.15% 260 13,410 1.98% 0 1,000 0.00% 1,184,821 1,788,280 196.34% (300) 550 (35.29%) (2,610) 14,270 (15.46%) (1,000) 2,000 (33.33%) (1,294) 3,747 (25.67%) 0 300 0.00% 0 13,000 0.00% 0 200 0.00% 1,565,779 4,740,741 49.32% (140,500) (1,165,500) 13.71% (732,615) (795,000) 1,174.34% (135,000) (142,500) 1,800.00% (1,008,115) (2,103,000) 92.07% (119,505) (353,345) 51.11% 100,674 (43,750) (69.71%) (376,625) (498,435) 309.19% (395,456) (895,530) 79.08% 162,208 1,742,211 10.27% 2612 Building Services 2019 Actuals Expenditures 1100 Salaries & Wages 1,414,191 1200 Overtime 1,882 1400 Employer Contributions 367,820 1800 Conferences 7,828' 1900 Uniforms 1,333 2110 Travel 25,234 2131 Cellular Phones 4,611 2140 Telephones 5,272 2220 Subscription & Publications 2,181 2340 Seminars & Education 22,158 2365 Purch Prnting/Broch/News Ltr 397 2370 Insurance Premium 7,239 2371 Ins. Deductible 0 2392 Consulting & Professional 184,313 2394 Recpt, Prom & Sp Events 2,571 2395 Memberships 12,.156 2399 Outside Agency Serv 4,099 2457 Veh -Repairs & Maintenance 855 2479 Software/Hardware Maintenanc 0 5300 Stationery & Office Supplies 7,329 5302 Forms 1,130 5900 Gas, Oil Tires 66 5902 Supplies & Tools 722 5975 Hardware Replacements 0 Total Expenditures 2,073,387 Revenues 1517 Licenses & Permits (3,101,416) 9990 Other Revenue (29,516) 9965 Cost Recoveries 0 Total Revenues (3,130,932) Transfers to/from Reserves & R.F. 1911 Trans. to/(from) Continuing Stu (148,748) 1920 Transfer to/(from) Reserve Fun 0 Total Transfers (148,748) Net (1,206,293) City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 1,600,897 1,802,517 19,471 7,000 433,197 456,919 2,997 7,800 884 4,000 12,409 25,150 5,193 5,500 5,474 7,765 750 4,000 11,585 26,000 5,485 5,000 7,370 7,370 0 1,000 53,414 219,580 1,946 6,900 10,570 13,080 0 6,000 1,123 2,000 2,745 4,227 7,755 8,000 458 3,000 16 1,000 1,529 2,000 3,942 6,000 2,189,210 2,631,808 (3,080,737) (3,010,000) (17,626) (35,000) (57,100) (219,580) (3,155,463) (3,264,580) 0 0 0 52,000 0 52,000 (966,253) (580,772) 28 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (363,980) 1,438,537 (20.19%) 3,000 10,000 42.86% (65,899) 391,020 (14.42%) (5,400) 2,400 (69.23%) (2,000) 2,000 (50.00%) (8,550) 16,600 (34.00%) 900 6,400 16.36% (255) 7,510 (3.28%) (2,000) 2,000 (50.00%) (5,900) 20,100 (22.69%) 1,000 6,000 20.00% 150 7,520 2.04% 0 1,000 0.00% (69,870) 149,710 (31.82%) (3,500) 3,400 (50.72%) (1,880) 11,200 (14.37%) (6,000) 0 (100.00%) 0 2,000 0.00% (1,690) 2,537 (39.98%) (4,000) 4,000 (50.00%) (2,000) 1,000 (66.67%) 2,000 3,000 200.00% 1,000 3,000 50.00% 4,000 10,000 66.67% (530,874) 2,100,934 (20.17%) 10,000 (3,000,000) (0.33%) 0 (35,000) 0.00% 69,870 (149,710) (31.82%) 79,870 (3,184,710) (2.45%) 0 0 0.00% (52,000) 0 (100.00%) (52,000) 0 (100.00%) (503,004) (1,083,776) 86.61% 2620 Sustainability 2019 Actuals Expenditures 1100 Salaries & Wages 414,687 1200 Overtime 959 1400 Employer Contributions 103,839 1800 Conferences 1,117 1900 Uniforms 0 2110 Travel 1,177 2131 Cellular Phones 1,851 2140 Telephones 1,564 2210 Advertising 7,653 2211 Trade Shows, Exhib & Displayi 1,733 2220 Subscription & Publications 94 2340 Seminars & Education 3,489 2370 Insurance Premium 2,911 2392 Consulting & Professional 51,389 2394 Recpt, Prom & Sp Events 14,169 2395 Memberships 4,346 2396 Photo, Mapping, Printing 700 2399 Outside Agency Serv 8,557 2479 Software/Hardware Maintenanc 0 5300 Stationery & Office Supplies 370 5320 Program Supplies 153,603 Total Expenditures 774,208 Revenues 1592 Donations 0 1623 Ont. Specific Grants 0 9950 EventVendorFees (22,883) 9980 Sponsorships No Tax 0 9985 Marketing Sponsorships 0 9990 Misc Income (5,375) 9993 0th Rev -Rebates/Incentive (250) 1530 Rntl -CCC Roof Solar Panel (6,000) Total Revenues (34,508) Transfers to/from Reserves & R.F. 1920 Transfer to/(from) Reserve Fun (41,893) Total Transfers (41,893) Net 697,807 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 393,776 392,686 0 1,000 102,055 99,046 383 4,000 0 300 619 2,000 1,373 2,500 1,244 1,765 4,319 9,500 1,614 4,000 262 400 5,116 8,380 2,965 2,965 15,000 37,000 549 15,000 2,964 3,770 1,526 1,000 1,031 10,000 1,735 1,310 1,229 1,500 92,148 170,725 629,908 768,847 0 (1,500) 0 0 (14,831) (25,000) 0 (5,000) 0 (1,000) (1,260) (4,000) (100,316) (40,000) (6,000) (6,000) (122,407) (82,500) 0 (25,000) 0 (25,000) 507,501 661,347 29 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 29,132 421,818 7.42% 0 1,000 0.00% 21,675 120,721 21.88% (1,000) 3,000 (25.00%) 0 300 0.00% (500) 1,500 (25.00%) 0 2,500 0.00% (55) 1,710 (3.12%) (370) 9,130 (3.89%) (1,500) 2,500 (37.50%) 0 400 0.00% (2,130) 6,250 (25.42%) 55 3,020 1.85% 271,000 308,000 732.43% (5,000) 10,000 (33.33%) 80 3,850 2.12% 6,780 7,780 678.00% (500) 9,500 (5.00%) 325 1,635 24.81% 0 1,500 0.00% (29,730) 140,995 (17.41%) 288,262 1,057,109 37.49% 1,000 (500) (66.67%) (14,680) (14,680) 0.00% 0 (25,000) 0.00% 1,500 (3,500) (30.00%) (2,000) (3,000) 200.00% (273,000) (277,000) 6,825.00% 0 (40,000) 0.00% 0 (6,000) 0.00% (287,180) (369,680) 348.10% 0 (25,000) 0.00% 0 (25,000) 0.00% 1,082 662,429 0.16% Committee of Adjustment 2019 Actuals Expenditures 1100 Salaries & Wages 6,960 1400 Employer Contributions 520 1800 Conferences 600 2110 Travel 489 2340 Seminars & Education 681 2395 Memberships 750 Total Expenditures 10,000 Revenues Total Revenues 0 Transfers to/from Reserves & R.F. Total Transfers 0 Net 10,000 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 7,080 7,200 534 494 0 1,000 225 820 0 200 750 750 8,589 10,464 0 0 0 0 8,589 10,464 30 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 0 7,200 0.00% 7 501 1.42% 0 1,000 0.00% (400) 420 (48.78%) 0 200 0.00% 0 750 0.00% (393) 10,071 (3.76%) 0 0 0.00% 0 0 0.00% (393) 10,071 (3.76%) 2743 Heritage Pickering 2019 Actuals Expenditures l 1800 Conferences 476 2110 Travel 249 2340 Seminars & Education 0 2392 Consulting & Professional 10,176 2394 Recpt, Prom & Sp Events 35 2395 Memberships 75 2396 Photo, Mapping, Printing 0 5300 Stationery & Office Supplies 0 5400 Gift Shop Plaques 0 Total Expenditures 11,011 Revenues Total Revenues 0 Transfers to/from Reserves & R.F. Total Transfers 0 Net 11,011 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 0 525 0 500 0 300 6,197 15,000 0 400 75 100 0 250 0 150 0 2,500 6,272 19,725 0 0 0 0 6,272 19,725 31 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (200) 325 (38.10%) (250) 250 (50.00%) 0 300 0.00% 0 15,000 0.00% (400) 0 (100.00%) 0 100 0.00% 0 250 0.00% 0 150 0.00% (2,500) 0 (100.00%) (3,350) 16,375 (16.98%) 0 0 0.00% 0 0 0.00% (3,350) 16,375 (16.98%) Overview Community Services Department Culture and Recreation, Facilities The Community Services Department is organized into two Divisions: Culture & Recreation and Operations. The Culture & Recreation Division is responsible for all matters relating to recreation and cultural services including recreation programs, memberships, cultural opportunities and special events. Culture & Recreation is responsible to provide Pickering residents with high quality culture and recreation programs, memberships, services and special events 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) Facilities Operations staff maintain facilities throughout the City. Capital Projects staff identify, plan and implement life cycle replacements of building components during the life of a facility. The Capital Projects staff are also responsible for all new construction of facilities. The City also has a centralized security responsibility within Facilities Operations. I Cultural Services J Museum r Community Services Department [ Culture & Recreation & Facilites) I Facility Recreation Corporate Programs Services Security 32 Facilities Capital Operations Projects Key Activities for 2021 • Key capital construction projects planned to commence in 2021 (CHDRC renovations, new Fire Station and HQ -FS #1 (1616 Bayly Street), Pickering Heritage & Community Centre) • Continued planning for the City Centre development and the Animal shelter • Develop recommended programs arid schematic concepts for the future Seaton Recreation Centre • Further development and delivery of virtual programming to fill gaps during COVID and be sustainable to service current and future community needs for at-home content • Studies/Plans Development (Security Services Plan, Community Safety Plan & Well-Being Plan) • Facilitating the development & implementation of the Pickering Anti-Black Racism T askforce plan • Facilitating the development & implementation of the Indigenous Relationship '?uilding Action Plan • Continue to develop and implement the Public Art Plan • Facilitate the implementation of the COVID recovery plan. Reinstatement and development of services, events and programs suspended or adversely affected in 2020 and 2021 Financial Information Full Time Reg. Part-Time Total 2018 67 52 119 Staffing Summary (Full & Regular Part Time) Approved Current Term 2019 2020 Add 71 52 123 75 49 111 1 Q 1 Approved 2021 Delete Total 0 76 Q 49 0 112 The above chart excludes contract, students and term employees. One new full time Non-Union Position of Supervisor, Facilities Operations with a start date of July 1, 2021. 33 Year-Over-Year (Net Cost) Budget Changes 2020 2021 YearNear Increase Budget Approved ($) (%) Budget Cult. & Rec -Adm. $2,993,912 $3,172,035 $178,123 5.95 Civic Centre 640,214 679,478 39,264 6.13 Seniors Citizens Centre 376,147 412,261 36,114 9.60 Programs 504,275 883,736 379,461 75.25 Dunbarton Pool 277,308 378,135 100,827 36.36 Don Beer Arena 242,779 749,792 507,013 208,84 Community Centres 714,463 852,646 138,183 19.34 Rec Complex -Core 2,131,892 2,240,160 108,268 5.08 Rec Complex -Pool 696,815 584,756 (112,059) (16.08) Rec Complex -Arenas 139,780 509,348 369,568 264.39 Museum 875,510 850,987 (24,523) (2.80) Pickering Arts Centre 140,296 0 {140,296} (100.00) Total (Net Cost) $9,733,391 $11,313,334 $1,579,943 16.23 Explanation of Significant Budget Changes -Expenses Under the "Culture & Recreation" and "Facilities" cost centres, the following accounts had significant Budget changes: • Salaries & Wages ($379,870) -Budget decrease due to reduction of level of service at the CHDRC due to continuing COVID restrictions and the major construction project in the change rooms, lobby and upper and lower cardio room. • Salaries & Wages Programs ($640,728) -Budget decrease due to programs being significantly cut back in 2021 by the continuation of COVID restrictions. • Overtime ($44,310) -Budget decrease due to significant reduction in overtime in support of weekend community events in 2021 due to continuation of COVID restrictions. • Employee Contributions $37,322 -Budget increase largely due to higher employer paid CPP premiums. This increase is partially offset by a reduction in employer contributions attributable to the above-mentioned reduction in budgeted salaries and wages. • Advertising ($29,000) -Budget decrease due to advertising savings in 2021 due to COVID reductions in events and programs. 34 • Trade Shows & Exhibits $60,500 -Budget increase due to the new Museum Blacksmith Shop Exhibit and Virtual Blacksmith shop project fully funded by Rural Economic Development Fund and Virtual Museum of Canada Fund. • Consulting & Professional ($128,685) -Budget decrease due to consulting servicing completed in 2020 for Space Use Study, Wayfinding Study & FaifMinded Pricing Policy deferred to 2022. • Outside Agency Services ($90, 130) -Budget decrease due to the deletion of busing services for programs due to COVID continuing restrictions. • Building Repairs & Maintenance ($220, 931) -Budget decrease due to the closure of the change rooms, lobby and cardio rooms at CHDRC and the temporary closure of the pool and arena ice arenas due to continuing COVID restrictions and the major renovation project • Program Build Rentals ($177,000) -Budget decrease due to significant reduction in the Community use of Schools for programs unable to run due to COVID continuing restrictions. • Program Supplies $40,000 -Budget increase due to addition of funding for the Public Arts Program (funded from the Public Arts Reserve). • Event Supplies ($92,675) -Budget decrease due to the reduction of events in 2021 due to the continuation of COVID restrictions. • Program Supplies ($36,715) -Budget decrease due to the reduction of programs in 2021 due to the continuation of COVID restrictions. • Committee Expenses $30,500 -Budget Increase due to the addition of funding new committee expenses for the Indigenous Relations Action Plan (Cultural Advisory Committee) and the Pickering Anti-Black Racism Taskforce. • Utilities ($257,921) -Budget decrease due to anticipated facilities reduced use and closure in 2021 due to continuing COVID restrictions. The Total Net Cost budgeted for the Pickering Arts Centre has decreased by $140,296 to reflect that the expenditures are being funded from the Casino Reserve Fund in 2021. Explanation of Significant Budget Changes -Revenues/ (Transfer from Reserves) • Revenues $3,075,233 -Budget decrease due to significant reductions in revenue for Admissions, Rentals, Events, Programs, Fitness, Museum and Community Rooms throughout all City Facilities due to continuing COVID restrictions. The City is anticipating a reduction in public health safety measures later in 2021 and have built this returning revenue stream into the revenue budgets for 04 of this year. 35 2020 Performance Indicators/Statistics Cultural Services Cultural Services Virtual Events, Cultural Pop-ups, on-line participants Destination Pickering Social Media Engagement (likes, shares, comments) Live Event Attendance (Events, Partner Events, Cultural Pop- ups) Recreation Services Programs offered pre-COVID Programs offered durinQ COVID Events Social media enQaQements Aquatics Programs offered Registered participants Swim members Available public swim hours Available rental hours Individual swim admission purchases Fitness Group fitness reQistered proQrams offered Group fitness registered participants Small Qroup training proQrams offered Small Qroup traininQ participants Personal traininQ packaQes sold Personal fitness members *no programs offered in spring or summer due to closure Health Club Health Club Members Available hours Individual admissions purchased Number of visits 36 109,827 8,948 2,184 668 580 10 33,675 528 1,665 254 1,426 907 2,383 96 412 71 149 25 221 1,261 3,283 250 76,000 Racquet Sports Number of Members: -Squash 134 -Racquetball 20 -Tennis 43 -Golden/Combination 39 Number of available hours: -Tennis 2,467 -Squash & Racquetball 2,365 Number of guests: -Tennis 2,816 -Squash 1,168 -Racquetball 234 Number of courts booked: -Tennis 5,727 -Squash 2,996 -Doubles Squash 774 -Racquetball 839 Pickerin Museum Villa e Museum visitors and pro ram participants 7,183 Facilities Operations -Arena CHDRC total hours of ice rental 1,256 OBA total hours of ice rental 3,127 CHDRC total hours of arena floor time rental 210 OBA total hours of arena floor time rental 0 OBA Banquet Hall rental hours 397 O'Brien Meeting Room rental hours 1,485 37 Culture, Recreation & Facilities 2019 Actuals Expenditures 1100 Salaries & Wages 7,529,847 1100 Salaries & Wages -Prg. 1,040,359 1200 Overtime 133,287 2712 0001 Program Overtime 5,002 1400 Employer Contributions 1,808,740 1800 Conferences 416 1900 Uniforms 45,530 2110 Travel 13,604 2122 Freight, Express & Cartage 4,500 2131 Cellular Phones 21,851 2140 Telephones 85,610 2210 Advertising 187,511 2211 Trade Shows, Exhib & Displays 890 2220 Subscription & Publications (2,000) 2340 Seminars & Education 24,807 2365 Purch Prnting/Broch/News Ltr 57,971 2370 Insurance Premium 61,845 2371 Ins. Deductible 2,363 2392 Consulting & Professional 98,289 2394 Recpt, Prom & Sp Events 59,545 2395 Memberships 13,751 2396 Photo, Mapping, Printing 5,859 2399 Outside Agency Serv 252,470 2435 Build Repairs & Mice 1,389,320 2457 Veh -Repairs & Maintenance 7,480 2478 Misc Equip Repairs 64,815 2479 Software/Hardware Maintenanc 44,978 2480 Antiques Repairs Mtce. 8,549 2482 Grounds Upkeep 766 2642 Community Use of Schools 1,733 2648 Building Rentals 70,386 2712 Prgm -Build Rentals 196,000 2678 Rental Misc Equip 5,120 2682 Land Rentals 44,810 2819 Financial Service Charges 0 5300 Stationery & Office Supplies 13,496 5302 Forms 1,021 5320 Program Supplies 13,131 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 6,838,318 8,033,959 451,770 965,635 47,342 171,455 221 0 1,665,616 2,024,516 0 7,600 15,392 46,500 5,283 18,425 1,745 2,500 24,823 32,800 82,493 100,535 156,172 260,400 1,529 1,200 897 4,550 10,359 49,600 45,696 57,000 62,960 62,960 2,002 11,000 94,532 223,985 32,455 63,000 16,211 16,417 4,146 9,000 249,691 317,935 1,406,942 1,538,875 10,107 11,300 56,351 75,650 56,409 72,809 10,305 8,700 1,025 2,800 25 3,500 72,815 72,210 0 196,000 5,219 9,600 44,810 46,160 0 0 13,169 17,050 25 1,900 11,604 12,255 38 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (379,870) 7,654,089 (4.73%) (640,728) 324,907 (66.35%) (44,310) 127,145 (25.84%) 0 0 0.00% 37,322 2,061,838 1.84% (4,035) 3,565 (53.09%) (6,492) 40,008 (13.96%) (7,800) 10,625 (42.33%) 0 2,500 0.00% 2,650 35,450 8.08% (1,600) 98,935 (1.59%) (29,000) 231,400 (11.14%) 60,500 61,700 5,041.67% (4,000) 550 (87.91%) (10,280) 39,320 (20.73%) (16,000) 41,000 (28.07%) 1,260 64,220 2.00% 0 11,000 0.00% (128,685) 95,300 (57.45%) 60,380 123,380 95.84% 3,879 20,296 23.63% 0 9,000 0.00% (90,130) 227,805 (28.35%) (220,931) 1,317,944 (14.36%) 0 11,300 0.00% (15,240) 60,410 (20.15%) 23,644 96,453 32.47% 5,000 13,700 57.47% 0 2,800 0.00% (1,500) 2,000 (42.86%) 1,200 73,410 1.66% (177,000) 19,000 (90.31%) (6,000) 3,600 (62.50%) (10) 46,150 (0.02%) 175,000 175,000 0.00% (5,000) 12,050 (29.33%) 0 1,900 0.00% 40,000 52,255 326.40% Culture, Recreation & Facilities 2019 Actuals 2712 Event Supplies 308,462 2712 Prgms Supplies 85,876 5320 Athletic Equip. Playroom 5,435 5330 Drop-In Centre Supplies 3,753 5340 Supplies -Special Events 10,182 5345 Antique Purchases 593 5350 Committee Expenses 7,793 5400 Gift Shop Plaques 5,734 5510 Utilities -Water 177,124 5520 Utilities -Gas 249,054 5530 Utilities -Hydro 1,181,702 5540 Utilities -Oil 6,296 5550 Utilities -Cable T.V. 1,470 5900 Gas, Oil Tires 9,521 5902 Supplies & Tools 38,298 5973 Minor Furniture & Fixtures 25,008 5974 System & Software Upgrades 0 5978 Misc. Equipment 18,231 Total Expenditures 15,448,184 Revenues 1610 Federal Grant (57,647) 1623 Ont. Specific Grants (185,257) 9397 Program Registrations (2,000,067) 9910 Gift Shop (8,464) 9915 Snack Bar (19,208) 9916 Vending Machines (18,695) 9930 Rentals (4,600) 9940 Advertising Space (77,988) 9943 Memberships-Pool/Health Clut (8,000) 9955 Programs (53,163) 9970 Child Supervision (32,405) 9975 Fitness Testing (53,736) 9977 Donations (2,237) 9920 Admissions -Public & Edu. (128,494) 9921 Admissions -Tennis (97,366) 9922 Admissions -Skating (17;623) 9923 Admissions -Public Swimming (59,488) 9924 Admissions -Squash (16,239) 9925 Admissions -Fitness Room (6,624) City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 151,372 291,025 64,954 111,715 16,071 2,300 (55) 4,400 11,465 14,500 470 600 23,047 67,750 2,311 5,250 116,292 189,265 183,445 287,496 881,263 1,317,361 4,628 5,683 1,348 850 6,844 10,075 21,238 75,536 2,018 23,600 0 25,000 6,039 13,400 12,991,209 16,995,587 (214,787) (147,000) (223,689) (243,800) (453,726) (1,944,900) (5,025) (10,500) (6,042) (16,950) (3,326) (17,500) (1,150) (4,600) (20,871) (77,000) 0 (8,000) (23,807) (76,560) (8,055) (30,000) · (23,668) (70,000) (10,411) (2,000) (38,390) (141,440) (60,300) (92,000) (9,840) (23,500) (12,042) (57,000) (6,777) (21,000) (2,682) (6,500) 39 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (92,675) 198,350 (31.84%) (36,715) 75,000 (32.86%) 0 2,300 0.00% 0 4,400 0.00% (2,920) 11,580 (20.14%) 0 600 0.00% 30,500 98,250 45.02% (2,625) 2,625 (50.00%) (36,845) 152,420 (19.47%) (58,376) 229,120 (20.30%) (162,700) 1,154,661 (12.35%) 0 5,683 0.00% 0 850 0.00% 0 10,075 0.00% (16,625) 58,911 (22.01%) 9,000 32,600 38.14% (25,000) 0 (100.00%) 0 13,400 0.00% {1,772,757) 15,222,830 (10.43%) (114,313) (261,313) 77.76% (148,505) (392,305) 60.91% 1,434,758 (510,142) (73.77%) 5,250 (5,250) (50.00%) 7,025 (9,925) (41.45%) 2,000 (15,500) (11.43%) 2,300 (2,300) (50.00%) 11,000 (66,000) (14.29%) (5,750) (13,750) 71.88% 40,000 (36,560) (52.25%) · 30,000 0 (100.00%) 30,000 (40,000) (42.86%) 0 (2,000) 0.00% 0 (141,440) 0.00% 18,000 (74,000) (19.57%) 11,750 (11,750) (50.00%) 47,965 (9,035) (84.15%) 10,000 (11,000) (47.62%) 4,500 (2,000) (69.23%) Culture, Recreation & Facilities 2019 Actuals 9926 Admissions -Racquet Ball (4,767) 9931 Rentals -Ice Surface (1,744,962) 9932 Rentals -Pool (280,649) 9933 Rentals -Mtg. Room/Public (89,668) 9934 Rentals -Mtg. Room/Prog. (27,000) 9935 Rentals -Halls (141,184) 9936 Rentals -Pool-School Board (1,199) 9937 Rentals -West Shore C.C. (64,770) 9938 Rentals -East Shore C.C. (50,887) 9939 Rentals -Lockers (121) 9941 Membertships -Tennis (24,625) 9943 Memberships -Pool/Health CIL (719,892) 9944 Memberships -Squash (80,691) 9945 Memberships -General (149,751) 9946 Memberships -Racquet Ball (24,008) 9947 Rentals -Claremont C.C. (10,234) 9949 Rentals -Petticoat Creek (64,564) 9958 Rentals -Wellness Clinic (59,517) 9959 Arena Floor Rentals (62,045) 9990 Other Misc Revenue (128,895) 9954 Netted Revenue (160,394) 9950 EventVendorFees (12,044) 9980 Sponsorships No Tax (50,400) 9985 Marketing Sponsorships (7,171) 9992 Other Revenue -Membership I (6,231) Total Revenues (6,812,970) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuing Stu (36,174) 1920 Transfer to/(from) Reserve Fun (18,428) Total Transfers (54,602) Net 8,580,612 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget (1,394) (5,000) (750,558) (1,852,000) (60,089) (276,000) (23,721) (86,000) 0 (27,000) (18,928) (149,000) 0 (1,258) (26,094) (70,901) (10,045) (56,000) (60) (100) (23,596) (24,000) (359,886) (679,000) (48,589) (75,000) (75,932) (140,500) (11,800) (21,000) (384) (800) (8,772) (54,000) (45,552) (59,000) (11,129) (39,500) (3,429) (24,850) (163,802) (175,702) (1,975) (13,950) (6,200) (4,500) (36,587) (37,000) (1,037) (5,000) (2,814,147) (6,867,311) (207,396) (314,500) (33,043) (42,475) (4,027) (37,910) (244,466) (394,885) 9,932,596 9,733,391 40 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 3,400 (1,600) (68.00%) 1,069,430 (782,570) (57.74%) 204,500 (71,500) (74.09%) 38,000 (48,000) (44.19%) 20,000 (7,000) (74.07%) 122,000 (27,000) (81.88%) 1,258 0 (100.00%) 26,121 (44,780) (36.84%) 46,000 (10,000) (82.14%) 100 0 (100.00%) 0 (24,000) 0.00% 308,000 (371,000) (45.36%) 19,000 (56,000) (25.33%) 50,500 (90,000) (35.94%) 9,000 (12,000) (42.86%) 0 (800) 0.00% 32,000 (22,000) (59.26%) (9,000) (68,000) 15.25% 0 (39,500) 0.00% (68,650) (93,500) 276.26% (188,421) (364,123) 107.24% 2,715 (11,235) (19.46%) (3,000) (7,500) 66.67% 7,500 (29,500) (20.27%) (1,200) (6,200) 24.00% 3,075,233 (3,792,078) (44.78%) 214,682 (99,818) (68.26%) 24,875 (17,600) (58.56%) 37,910 0 (100.00%) 277,467 (117,418) (70.27%) 1,579,943 11,313,334 16.23% 2711 Cult. & Rec. -Admin. 2019 Actuals Expenditures 1100 Salaries & Wages 1,717,937 1200 Overtime 13,363 1400 Employer Contributions 466,960 1800 Conferences 416 1900 Uniforms 1,863 2110 Travel 5,337 2131 Cellular Phones 6,868 2140 Telephones 8,327 2210 Advertising 133,757 2220 Subscription & Publications (2,000) 2340 Seminars & Education 1,980 2370 Insurance Premium 10,354 2392 Consulting & Professional 51,079 2394 Recpt, Prom & Sp Events 3,715 2395 Memberships 7,162 2396 Photo, Mapping, Printing 5,859 2435 Build Repairs & Mtce 0 2457 Veh -Repairs & Maintenance 0 2479 Software/Hardware Maintenanc 32,974 2648 Building Rentals 70,386 2819 Financial Service Charges 0 5300 Stationery & Office Supplies 2,769 5320 Program Supplies 0 5350 Committee Expenses 7,793 5520 Utilities -Gas 0 5973 Minor Furniture & Fixtures 660 5974 System & Software Upgrades 0 Total Expenditures 2,547,559 Revenues 1623 Ont. Specific Grants 0 Total Revenues 0 Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuing Stu (9,510) 1920 Transfer to/(from) Reserve Fun (18,428) Total Transfers (27,938) Net 2,519,621 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 1,789,587 1,976,454 7,989 27,855 494,927 569,292 0 6,100 1,832 2,500 2,302 8,000 9,802 10,000 9,470 12,685 113,276 128,400 897 4,200 2,704 6,220 10,540 10,540 10,326 119,870 749 6,000 10,487 8,700 4,146 9,000 207,396 213,000 1,833 0 37,399 40,616 72,774 72,200 0 0 5,031 4,800 0 0 23,047 67,750 1,601 0 654 1,000 0 25,000 2,818,769 3,330,182 (24,610) (50,000) (24,610) (50,000) (207,396) (213,000) (29,176) (35,360) (4,027) (37,910) (240,599) (286,270) 2,553,560 2,993,912 41 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 77,148 2,053,602 3.90% (15,975) 11,880 (57.35%) 24,411 593,703 4.29% (4,035) 2,065 (66.15%) 0 2,500 0.00% (6,000) 2,000 (75.00%) 0 10,000 0.00% (835) 11,850 (6.58%) (13,000) 115,400 (10.12%) (4,000) 200 (95.24%) (2,000) 4,220 (32.15%) 210 10,750 1.99% (103,870) 16,000 (86.65%) 0 6,000 0.00% 3,175 11,875 36.49% 0 9,000 0.00% (213,000) 0 (100.00%) 0 0 0.00% 29,499 70,115 72.63% 1,200 73,400 1.66% 175,000 175,000 0.00% 0 4,800 0.00% 40,000 40,000 0.00% 30,500 98,250 45.02% 0 0 0.00% 0 1,000 0.00% (25,000) 0 (100.00%) (6,572) 3,323,610 (0.20%) (45,575) (95,575) 91.15% (45,575) (95,575) 91.15% 173,000 (40,000) (81.22%) 19,360 (16,000) (54.75%) 37,910 0 (100.00%) 230,270 (56,000) (80.44%) 178,123 3,172,035 5.95% 2124 Civic Centre 2019 Actuals Expenditures 1100 Salaries & Wages 253,975 1200 Overtime 3,643 1400 Employer Contributions 49,607 1900 Uniforms 1,781 2140 Telephones 3,150 2340 Seminars & Education 504 2370 Insurance Premium 3,009 2371 Ins. Deductible 0 2392 Consulting & Professional 0 2394 Recpt, Prom & Sp Events 0 2399 Outside Agency Serv 81,739 2435 Build Repairs & Mtce 191,780 2478 Misc Equip Repairs 0 2479 Software/Hardware Maintenan< 0 2678 Rental Misc Equip 0 5510 Utilities -Water 11,977 5520 Utilities -Gas 24,198 5530 Utilities -Hydro 141,725 5550 Utilities -Cable T.V. 1,470 5902 Supplies & Tools 1,868 Total Expenditures 770,426 Revenues 9916 Vending Machines (254) 9954 Netted Revenue (160,394) Total Revenues (160,648) Transfers to/from Reserves & R.F. Total Transfers 0 Net 609,778 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 275,644 248,735 1,963 5,500 53,370 58,616 374 2,000 3,108 4,235 0 1,000 3,065 3,065 0 1,000 4,477 2,000 15 0 122,642 117,880 215,966 150,643 421 1,500 429 661 0 500 11,395 14,480 21,561 25,027 129,270 163,824 1,348 850 295 3,000 845,343 804,516 (145) (500) (163,802) (163,802) (163,947) (164,302) 0 0 681,396 640,214 42 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 150,983 399,718 60.70% 0 5,500 0.00% 15,596 74,212 26.61% 0 2,000 0.00% 545 4,780 12.87% 0 1,000 0.00% 55 3,120 1.79% 0 1,000 0.00% 0 2,000 0.00% 0 0 0.00% 10,620 128,500 9.01% 49,040 199,683 32.55% 0 1,500 0.00% 53 714 8.02% 0 500 0.00% 290 14,770 2.00% 503 25,530 2.01% 0 163,824 0.00% 0 850 0.00% 0 3,000 0.00% 227,685 1,032,201 28.30% 0 (500) 0.00% (188,421) (352,223) 115.03% (188,421) (352,723) 114.68% 0 0 0.00% 39,264 679,478 6.13% 2572 Senior Citizens Centre 2019 Actuals Expenditures 1100 Salaries & Wages 276,441 1200 Overtime 5,806 1400 Employer Contributions 52,943 1900 Uniforms 774 2110 Travel 763 2131 Cellular Phones 0 2140 Telephones 3,080 2210 Advertising 0 2340 Seminars & Education 3,334 2370 Insurance Premium 2,347 2394 Recpt, Prom & Sp Events 31,598 2395 Memberships 450 2399 Outside Agency Serv 3,662 2435 Build Repairs & Mtce 60,951 2479 Software/Hardware Maintenanc 1,902 5320 Athletic Equip. Playroom 5,435 5510 Utilities -Water 5,149 5520 Utilities -Gas 4,546 5530 Utilities -Hydro 24,226 5902 Supplies & Tools 1,461 5973 Minor Furniture & Fixtures 977 Total Expenditures 485,845 Revenues 1610 Federal Grant 0 1623 Ont. Specific Grants (135,612) 9955 Programs (38,686) 9990 Other Misc Revenue (460) 9950 EventVendorFees (5,875) 9980 Sponsorships No Tax (7,500) 9985 Marketing Sponsorships (200) Total Revenues (188,333) Transfers to/from Reserves & R.F. Total Transfers 0 Net 297,512 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 233,245 309,509 1,752 6,000 55,343 62,236 311 800 505 800 576 600 4,326 5,105 577 3,000 72 5,300 2,390 2,390 26,344 34,500 825 825 288 9,580 36,081 83,640 2,139 2,710 16,071 2,300 5,344 6,920 3,629 7,780 19,059 29,152 696 2,100 0 600 409,573 575,847 0 0 (131,842) (140,400) (19,385) (53,000) 50 0 (1,800) (3,800) (6,000) (500) 0 (2,000) (158,977) (199,700) 0 0 250,596 376,147 43 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (6,208) 303,301 (2.01%) 0 6,000 0.00% 17,402 79,638 27.96% 200 1,000 25.00% 200 1,000 25.00% 0 600 0.00% (380) 4,725 (7.44%) 0 3,000 0.00% 200 5,500 3.77% 50 2,440 2.09% 71,880 106,380 208.35% 0 825 0.00% (300) 9,280 (3.13%) (1,565) 82,075 (1.87%) (280) 2,430 (10.33%) 0 2,300 0.00% 130 7,050 1.88% (1,500) 6,280 (19.28%) 0 29,152 0.00% 0 2,100 0.00% 0 600 0.00% 79,829 655,676 13.86% (24,450) (24,450) 0.00% (47,630) (188,030) 33.92% 33,000 (20,000) (62.26%) 0 0 0.00% (4,635) (8,435) 121.97% 0 (500) 0.00% 0 (2,000) 0.00% (43,715) (243,415) 21.89% 0 0 0.00% 36,114 412,261 9.60% 2712 Programs 2019 Actuals Expenditures 1100 Salaries & Wages 533,637 1100 Salaries & Wages -Prg. 1,040,359 1200 Overtime 14,413 2712 0001 Program Overtime 5,002 1400 Employer Contributions 210,214 1900 Uniforms 4,832 2110 Travel 2,202 2131 Cellular Phones 1,387 2140 Telephones 1,5.88 2220 Subscription & Publications 0 2340 Seminars & Education 2,091 2365 Purch Prnting/Broch/News Ur 57,971 2370 Insurance Premium 9,146 2394 Recpt, Prom & Sp Events 2,911 2395 Memberships 1,018 2399 Outside Agency Serv 71,834 2478 Misc Equip Repairs 0 2479 Software/Hardware Maintenanc 0 2642 Community Use of Schools 1,733 2712 Prgm -Build Rentals 196,000 5302 Forms 0 2712 Event Supplies 308,462 2712 Prgms Supplies 85,876 5330 Drop-In Centre Supplies 3,753 5902 Supplies & Tools 2,203 5978 Misc. Equipment 3,416 Total Expenditures 2,560,048 Revenues 1610 Federal Grant (43,935) 1623 Ont. Specific Grants (10,382) 9397 Program Registrations (2,000,067) 9940 Advertising Space (22,988) 9990 Other Misc Revenue (7,840) 9950 EventVendorFees (6,169) 9980 Sponsorships No Tax (42,900) 9985 Marketing Sponsorships (2,646) Total Revenues (2,136,927) Transfers to/from Reserves & R.F. City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 431,422 582,373 451,770 965,635 430 16,900 221 0 152,054 198,790 1,076 5,000 1,875 3,200 832 1,500 1,742 2,470 0 100 2,435 7,400 45,696 57,000 9,310 9,310 1,835 3,000 1,323 1,200 2,338 92,000 0 200 2,621 4,057 25 3,500 0 196,000 0 500 151,372 291,025 64,954 111,715 (55) 4,400 0 2,800 1,064 7,000 1,324,340 2,567,075 (79,125) (49,000) (22,316) (14,400) (453,726) (1,944,900) (9,413) (22,000) 0 (8,350) (175) (10,150) (200) (4,000) (34,425) (10,000) (599,380) (2,062,800) 44 Run Date: 4/21/21 3:54 PM 2021 INC.IDEC. Approved % CHGE. Budget 2020 53,778 636,151 9.23% (640,728) 324,907 (66.35%) 0 16,900 0.00% 0 0 0.00% (39,717) 159,073 (19.98%) 0 5,000 0.00% 0 3,200 0.00% 2,000 3,500 133.33% (80) 2,390 (3.24%) 0 100 0.00% 200 7,600 2.70% (16,000) 41,000 (28.07%) 190 9,500 2.04% 0 3,000 0.00% 900 2,100 75.00% (89,000) 3,000 (96.74%) 0 200 0.00% (1,987) 2,070 (48.98%) (1,500) 2,000 (42.86%) (177,000) 19,000 (90.31%) 0 500 0.00% (92,675) 198,350 (31.84%) (36,715) 75,000 (32.86%) 0 4,400 0.00% 0 2,800 0.00% 0 7,000 0.00% (1,038,334) 1,528,741 (40.45%) (4,863) (53,863) 9.92% (29,800) (44,200) 206.94% 1,434,758 (510,142) (73.77%) 11,000 (11,000) (50.00%) 2,350 (6,000) (28.14%) 7,350 (2,800) (72.41%) (3,000) (7,000) 75.00% 0 (10,000) 0.00% 1,417,795 (645,005) (68.73%) 2712 Programs 2019 Actuals Total Transfers 0 Net 423,121 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 0 0 724,960 504,275 45 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 0 0 0.00% 379,461 883,736 75.25% 2713 Dunbarton Pool 2019 Actuals Expenditures 1100 Salaries & Wages 228,659 1200 Overtime 936 1400 Employer Contributions 41,794 1900 Uniforms 1,957 2110 Travel 131 2131 Cellular Phones 324 2140 Telephones 4,804 2340 Seminars & Education 920 2370 Insurance Premium 1,659 2392 Consulting & Professional 0 2395 Memberships 100 2399 Outside Agency Serv 1,183 2435 Build Repairs & Mtce 59,913 2478 Misc Equip Repairs 0 2479 Software/Hardware Maintenanc 0 5300 Stationery & Office Supplies 237 5520 Utilities -Gas 27,181 5902 Supplies & Tools 592 Total Expenditures 370,390 Revenues 9943 Memberships-Pool/Health Clut (8,000) 9923 Admissions -Public Swimming (4,686) 9932 Rentals -Pool · (116,859) Total Revenues (129,545) Transfers to/from Reserves & R.F. Total Transfers 0 Net 240,845 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 149,059 230,438 391 2,200 38,486 57,829 135 2,000 0 200 343 500 3,975 5,100 150 1,370 1,690 1,690 9,920 12,000 100 120 933 2,080 34,212 37,300 137 3,000 363 569 125 300 18,809 34,951 4,254 8,661 263,082 400,308 0 (8,000) (650) (5,000) (36,485) (110,000) (37,135) (123,000) 0 0 225,947 277,308 46 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 54,164 284,602 23.50% 0 2,200 0.00% 12,126 69,955 20.97% (380) 1,620 (19.00%) 0 200 0.00% 0 500 0.00% 10 5,110 0.20% 0 1,370 0.00% 30 1,720 1.78% (2,000) 10,000 (16.67%) (18) 102 (15.00%) 0 2,080 0.00% (2,000) 35,300 (5.36%) 0 3,000 0.00% (119) 450 (20.91%) (100) 200 (33.33%) (4,301) 30,650 (12.31%) 0 8,661 0.00% 57,412 457,720 14.34% (5,750) (13,750) 71.88% 3,165 (1,835) (63.30%) 46,000 (64,000) (41.82%) 43,415 (79,585) (35.30%) 0 0 0.00% 100,827 378,135 36.36% 2715 Don Beer Arena 2019 Actuals Expenditures 1100 Salaries & Wages 574,899 1200 Overtime 24,057 1400 Employer Contributions 127,201 1900 Uniforms 3,126 2110 Travel 0 2131 Cellular Phones 422 2140 Telephones 14,078 2340 Seminars & Education 1,165 2370 Insurance Premium 5,746 2371 Ins. Deductible 0 2392 Consulting & Professional 0 2394 Recpt, Prom & Sp Events 180 2395 Memberships 0 2399 Outside Agency Serv 2,930 2435 Build Repairs & Mtce 157,972 2478 Misc Equip Repairs 13,750 2479 Software/Hardware Maintenan< 0 2678 Rental Misc Equip 0 2682 Land Rentals 44,810 5300 Stationery & Office Supplies 257 5510 Utilities -Water 32,240 5520 Utilities -Gas 37,505 5530 Utilities -Hydro 271,294 5902 Supplies & Tools 762 5973 Minor Furniture & Fixtures 0 5978 Misc. Equipment 2,309 Total Expenditures 1,314,703 Revenues 9915 Snack Bar (10,064) 9916 Vending Machines (3,608) 9930 Rentals (4,600) 9922 Admissions -Skating (1,959) 9931 Rentals -Ice Surface (1,077,758) 9935 Rentals -Halls (33,354) 9959 Arena Floor Rentals (56,291) 9985 Marketing Sponsorships 0 Total Revenues (1,187,634) Transfers to/from Reserves & R.F. City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 518,972 606,361 10,697 20,000 109,695 146,381 1,387 5,000 0 200 416 1,800 14,508 16,110 577 4,110 5,850 5,850 0 2,000 0 0 90 0 0 400 5,231 3,115 122,030 156,365 9,410 15,000 1,046 1,639 0 300 44,810 46,160 37 300 27,617 31,790 26,918 41,385 197,885 286,398 1,238 2,165 0 0 4,975 6,400 1,103,389 1,399,229 (3,813) (9,850) (767) (4,500) (1,150) (4,600) (1,272) (3,500) (605,833) (1,040,000) (6,332) (47,000) (10,264) (32,000) 0 (15,000) (629,431) (1,156,450) 47 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (50,276) 556,085 (8.29%) 0 20,000 0.00% 1,456 147,837 0.99% 0 5,000 0.00% 0 200 0.00% 0 1,800 0.00% 40 16,150 0.25% 90 4,200 2.19% 120 5,970 2.05% 0 2,000 0.00% 5,000 5,000 0.00% 0 0 0.00% 0 400 0.00% 0 3,115 0.00% 40,530 196,895 25.92% 0 15,000 0.00% (369) 1,270 (22.51%) 0 300 0.00% (10) 46,150 (0.02%) 0 300 0.00% (7,490) 24,300 (23.56%) (9,735) 31,650 (23.52%) (67,248) 219,150 (23.48%) 0 2,165 0.00% 3,000 3,000 0.00% 0 6,400 0.00% (84,892) 1,314,337 (6.07%) 4,925 (4,925) (50.00%) 2,000 (2,5_00) (44.44%) 2,300 (2,300) (50.00%) 1,750 (1,750) (50.00%) 553,430 (486,570) (53.21%) 20,000 (27,000) (42.55%) 0 (32,000) 0.00% 7,500 (7,500) (50.00%) 591,905 (564,545) (51.18%) 2715 Don Beer Arena 2019 Actuals Total Transfers 0 Net 127,069 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 0 0 473,958 242,779 48 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 0 0 0.00% .· 507,013 749,792 208.84% 2719 Community Centres 2019 Actuals Expenditures 1100 Salaries & Wages 310,999 1200 Overtime 3,933 1400 Employer Contributions 59,761 1900 Uniforms 2,801 2110 Travel 129 2131 Cellular Phones 1,763 2140 Telephones 16,402 2340 Seminars & Education 686 2370 Insurance Premium 3,832 2371 Ins. Deductible 755 2392 Consulting & Professional 0 2399 Outside Agency Serv 4,748 2435 Build Repairs & Mtce 256,852 2457 Veh -Repairs & Maintenance 4,878 2478 Misc Equip Repairs 2,551 2479 Software/Hardware Maintenanc 0 2648 Building Rentals 0 5510 Utilities -Water 9,998 5520 Utilities -Gas 23,001 5530 Utilities. -Hydro 94,993 5540 Utilities -Oil 4,639 5900 Gas, Oil Tires 7,732 5902 Supplies & Tools 135 5973 Minor Furniture & Fixtures 14,330 5978 Misc. Equipment 2,172 Total Expenditures 827,090 Revenues 9916 Vending Machines (775) 9937 Rentals -West Shore C.C. (64,770) 9938 Rentals -East Shore C.C. (50,887) 9947 Rentals -Claremont C.C. (10,234) 9949 Rentals -Petticoat Creek (64,564) 9990 Other Misc Revenue 0 9954 Netted Revenue 0 Total Revenues (191,230) Transfers to/from Reserves & R.F. 1911 Trans. to/(from) Continuing Stu (1,425) Total Transfers (1,425) City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 256,169 279,516 1,761 8,000 49,412 67,028 429 2,200 0 500 1,753 2,500 14,015 13,755 215 1,360 3,900 3,900 0 2,000 37,399 45,000 7,365 11,984 220,628 282,476 5,187 6,300 1,949 1,500 451 703 41 10 10,352 13,000 20,323 27,863 80,878 116,990 3,335 4,867 6,146 8,112 548 2,000 0 10,000 0 0 722,256 911,564 (174) (1,000) (26,094) (70,901) (10,045) (56,000) (384) (800) (8,772) (54,000) 0 (2,500) 0 (11,900) (45,469) (197,101) 0 0 0 0 49 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 38,352 317,868 13.72% 0 8,000 0.00% 8,885 75,913 13.26% 0 2,200 0.00% 0 500 0.00% 0 2,500 0.00% (130) 13,625 (0.95%) 0 1,360 0.00% 80 3,980 2.05% 0 2,000 0.00% 3,300 48,300 7.33% 0 11,984 0.00% (13,171) 269,305 (4.66%) 0 6,300 0.00% 0 1,500 0.00% (141) 562 (20.06%) 0 10 0.00% 250 13,250 1.92% (1,763) 26,100 (6.33%) 0 116,990 0.00% 0 4,867 0.00% 0 8,112 0.00% 0 2,000 0.00% 0 10,000 0.00% 0 0 0.00% 35,662 947,226 3.91% 0 (1,000) 0.00% 26,121 (44,780) (36.84%) 46,000 (10,000) (82.14%) 0 (800) 0.00% 32,000 (22,000) (59.26%) 0 (2,500) 0.00% 0 (11,900) 0.00% 104,121 (92,980) (52.83%) (1,600) (1,600) 0.00% (1,600) (1,600) 0.00% 2719 Community Centres 2019 Actuals Net 634,435 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 676,787 714,463 50 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 138,183 852,646 19.34% 2731 Recreation Complex -Central Core 2019 Actuals Expenditures 1100 Salaries & Wages 2,014,694 1200 Overtime 32,540 1400 Employer Contributions 453,645 1900 Uniforms 13,753 2110 Travel 1,486 2131 Cellular Phones 7,502 2140 Telephones 11,007 2210 Advertising 32,607 2220 Subscription & Publications 0 2340 Seminars & Education 6,831 2370 Insurance Premium 13,070 2371 Ins. Deductible 166 2392 Consulting & Professional 1,992 2394 Recpt, Prom & Sp Events 10,727 2395 Memberships 2,598 2399 Outside Agency Serv 69,530 2435 Build Repairs & Mtce 318,341 2478 Misc Equip Repairs 37,955 2479 Software/Hardware Maintenanc 7,922 2678 Rental Misc Equip 5,120 5300 Stationery & Office Supplies 7,144 5302 Forms 1,021 5340 Supplies -Special Events 1,759 5510 Utilities -Water 52,992 5520 Utilities -Gas 56,188 5530 Utilities -Hydro 256,716 5902 Supplies & Tools 27,107 5973 Minor Furniture & Fixtures 9,041 Total Expenditures 3,453,454 Revenues 9916 Vending Machines (12,408) 9970 Child Supervision (32,405) 9975 Fitness Testing (53,736) 9921 Admissions -Tennis (97,366) 9924 Admissions -Squash (16,239) 9925 Admissions -Fitness Room (6,624) 9926 Admissions -Racquet Ball (4,767) 9933 Rentals -Mtg. Room/Public (37,719) City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 2,002,354 2,069,185 13,683 47,000 412,486 483,309 4,743 12,000 0 1,300 7,471 8,000 9,589 13,995 7,063 31,000 0 250 1,386 10,175 13,305 13,305 1,107 4,000 3,800 13,870 1,804 9,000 2,135 2,865 97,677 74,941 305,826 263,591 29,619 40,450 8,245 16,696 5,219 8,000 5,986 8,000 25 1,100 331 4,000 27,713 53,475 37,206 61,216 176,297 276,664 9,153 38,975 1,364 12,000 3,185,587 3,578,362 (1,673) (10,000) (8,055) (30,000) (23,668) (70,000) (60,300) (92,000) (6,777) (21,000) (2,682) (6,500) (1,394) (5,000) (8,873) (27,000) 51 Run Date: 4/21/21 3:54 PM 2021 INC.IDEC. Approved % CHGE. Budget 2020 (297,526) 1,771,659 (14.38%) (15,000) 32,000 (31.91%) 32,761 516,070 6.78% (4,000) 8,000 (33.33%) (500) 800 (38.46%) 650 8,650 8.13% (1,270) 12,725 (9.07%) (16,000) 15,000 (51.61%) 0 250 0.00% (4,250) 5,925 (41.77%) 265 13,570 1.99% 0 4,000 0.00% (13,870) 0 (100.00%) (6,500) 2,500 (72.22%) 0 2,865 0.00% (11,450) 63,491 (15.28%) (49,626) 213,965 (18.83%) (12,240) 28,210 (30.26%) (1,696) 15,000 (10.16%) (6,000) 2,000 (75.00%) (4,900) 3,100 (61.25%) 0 1,100 0.00% (3,000) 1,000 (75.00%) (15,295) 38,180 (28.60%) (17,516) 43,700 (28.61%) (22,664) 254,000 (8.19%) (12,775) 26,200 (32.78%) 3,000 15,000 25.00% (479,402) 3,098,960 (13.40%) 0 (10,000) 0.00% 30,000 0 (100.00%) 30,000 (40,000) (42.86%) 18,000 (74,000) (19.57%) 10,000 (11,000) (47.62%) 4,500 (2,000) (69.23%) 3,400 (1,600) (68.00%) 20,000 (7,000) (74.07%) 2731 Recreation Complex -Central Core 2019 Actuals 9934 Rentals -Mtg. Room/Prog. (27,000) 9935 Rentals -Halls (107,830) 9939 Rentals -Lockers (121) 9941 Membertships -Tennis (24,625) 9943 Memberships -Pool/Health CIL (642,707) 9944 Memberships -Squash (80,691) 9945 Memberships -General (149,751) 9946 Memberships -Racquet Ball (24,008) 9958 Rentals -Wellness Clinic (59,517) 9990 Other Misc Revenue (120,506) 9992 Other Revenue -Membership I (6,231) Total Revenues (1,504,251) Transfers to/from Reserves & R.F. 1910 Transfer to/(frorn) Reserve 0 1911 Trans. to/(from) Continuing Stu 0 Total Transfers 0 Net 1,949,203 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 0 (27,000) (12,596) (102,000) (60) (100) (23,596) (24,000) (316,396) (621,000) (48,589) (75,000) (75,932) (140,500) (11,800) (21,000) (45,552) (59,000) (3,479) (14,000) (1,037) (5,000) (652,459) (1,350,100) 0 (92,500) (3,867) (3,870) (3,867) (96,370) 2,529,261 2,131,892 52 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 20,000 (7,000) (74.07%) 102,000 0 (100.00%) 100 0 (100.00%) 0 (24,000) 0.00% 256,000 (365,000) (41.22%) 19,000 (56,000) (25.33%) 50,500 (90,000) (35.94%) 9,000 (12,000) (42.86%) (9,000) (68,000) 15.25% (71,000) (85,000) 507.14% (1,200) (6,200) 24.00% 491,300 (858,800) (36.39%). 92,500 0 (100.00%) 3,870 0 (100.00%) 96,370 0, (100.00%) 108,268 2,240,160 5.08% 2733 Recreation Complex -Pool 2019 Actuals Expenditures 1100 Salaries & Wages 466,105 1200 Overtime 6,677 1400 Employer Contributions 79,775 1900 Uniforms 3,864 2110 Travel 208 2140 Telephones 1,049 2340 Seminars & Education 1,490 2370 Insurance Premium 4,459 2392 Consulting & Professional 250 2395 Memberships 100 2435 Build Repairs & Mtce 113,081 2478 Misc Equip Repairs 0 2479 Software/Hardware Maintenanc 0 5510 Utilities -Water 52,992 5520 Utilities -Gas 56,188 5530 Utilities -Hydro 181,580 5902 Supplies & Tools 985 Total Expenditures 968,803 Revenues 9923 Admissions -Public Swimming (54,802) 9932 R(;:lntals -Pool (163,790) 9936 Rentals -Pool-School Board (1,199) 9943 Memberships -Pool/Health GIL (77,185) Total Revenues (296,976) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuing Stu (250) Total Transfers (250) Net 671,577 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 394,852 452,214 2,691 10,000 77,929 82,938 160 5,000 100 225 489 705 429 2,815 4,540 4,540 0 1,250 100 120 53,275 92,900 740 2,000 716 1,122 27,713 53,680 37,206 61,216 124,698 202,098 3,357 11,500 728,995 984,323 (11,392) (52,000) (23,604) (166,000) 0 (1,258) (43,490) (58,000) (78,486) (277,258) 0 (9,000) 0 (1,250) 0 (10,250) 650,509 696,815 53 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (261,940) 190,274 (57.92%) (5,000) 5,000 (50.00%) (15,636) 67,302 (18.85%) (2,312) 2,688 (46.24%) 0 225 0.00% (25) 680 (3.55%) (2,145) 670 (76.20%) 90 4,630 1.98% (1,250) 0 (100.00%) (18) 102 (15.00%) (20,950) 71,950 (22.55%) (1,000) 1,000 (50.00%) (337) 785 (30.04%) (9,880) 43,800 (18.41%) (17,516) 43,700 (28.61%) (37,098) 165,000 (18.36%) (3,850) 7,650 (33.48%) (378,867) 605,456 (38.49%) 44,800 (7,200) (86.15%) 158,500 (7,500) (95.48%) 1,258 0 (100.00%) 52,000 (6,000) (89.66%) 256,558 (20,700) (92.53%) 9,000 0 (100.00%) 1,250 0 (100.00%) 10,250 0 (100.00%) (112,059) 584,756 (16.08%) 2735 Recreation Complex -Arenas 2019 Actuals Expenditures 1100 Salaries & Wages 493,004 1200 Overtime 27,308 1400 Employer Contributions 117,106 1900 Uniforms 3,794 2131 Cellular Phones 622 2140 Telephones 4,154 2340 Seminars & Education 561 2370 Insurance Premium 4,343 2371 Ins. Deductible 1,442 2392 Consulting & Professional 12,040 2394 Reep!, Prom & Sp Events 150 2399 Outside Agency Serv 271 2435 Build Repairs & Mtce 131,189 2478 Misc Equip Repairs 5,068 2479 Software/Hardware Maintenanc 0 2678 Rental Misc Equip 0 5300 Stationery & Office Supplies 546 5302 Forms 0 5510 Utilities -Water 11,776 5520 Utilities -Gas 14,315 5530 Utilities -Hydro 187,841 5902 Supplies & Tools 1,969 5973 Minor Furniture & Fixtures 0 5978 Misc. Equipment 10,334 Total Expenditures 1,027,833 Revenues 9915 Snack Bar (7,575) 9916 Vending Machines (1,650) 9940 Advertising Space (55,000) 9922 Admissions -Skating (15,664} 9931 Rentals -Ice Surface (667,204) 9933 Rentals -Mtg. Room/Public (40,211) 9959 Arena Floor Rentals (5,754) 9985 Marketing Sponsorships (4,325) Total Revenues (797,383) Transfers to/from Reserves & R.F. 1911 Trans. to/(from) Continuing Stu 0 Total Transfers 0 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 263,473 490,610 5,261 25,000 82,305 117,972 121 4,000 552 1,000 4,151 5,465 218 3,650 4,420 4,420 895 2,000 11,960 11,995 0 0 1,843 1,100 111,431 159,545 11,164 7,000 813 1,274 0 800 68 650 0 300 6,158 15,920 9,971 20,548 128,997 217,191 915 3,335 0 0 0 0 644,716 1,093,775 (1,900) (4,000) (567) (1,500) (11,458) (55,000) (8,568) (20,000) (144,725) (812,000) (8,466) (42,000) (865) (7,500) (2,162) (10,000) (178,711) (952,000) 0 (1,995) 0 (1,995) 54 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (86,956) 403,654 (17.72%) (8,335) 16,665 (33.34%) (7,156) 110,816 (6.07%) 0 4,000 0.00% 0 1,000 0.00% (35) 5,430 (0.64%) 25 3,675 0.68% 90 4,510 2.04% 0 2,000 0.00% (11,995) 0 (100.00%) 0 0 0.00% 0 . 1,100 0.00% (10,939) 148,606 (6.86%) 0 7,000 0.00% (537) 737 (42.15%) 0 800 0.00% 0 650 0.00% 0 300 0.00% (4,850) 11,070 (30.46%) (6,548) 14,000 (31.87%) (36,191) 181,000 (16.66%) 0 3,335 0.00% 3,000 3,000 0.00% 0 0 0.00% (170,427) 923,348 (15.58%) 0 (4,000) 0.00% 0 (1,500) 0.00% 0 (55,000) 0.00% 10,000 (10,000) (50.00%) 516,000 (296,000) (63.55%) 12,000 (30,000) (28.57%) 0 (7,500) 0.00% 0 (10,000) 0.00% 538,000 (414,000) (56.51%) 1,995 0 (100.00%) 1,995 0 (100.00%) 2735 Recreation Complex -Arenas 2019 Actuals Net 230,450 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 466,005 139,780 55 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 369,568 509,348 264.39% 2744 Museum 2019 Actuals Expenditures 1100 Salaries & Wages 659,497 1200 Overtime 611 1400 Employer Contributions 149,734 1900 Uniforms 6,985 2110 Travel 3,348 2122 Freight, Express & Cartage 4,500 2131 Cellular Phones 2,963 2140 Telephones 17,971 2210 Advertising 21,147 2211 Trade Shows, Exhib & Display~ 890 2340 Seminars & Education 5,245 2370 Insurance Premium 3,880 2392 Consulting & Professional 32,928 2394 Recpt, Prom & Sp Events 10,264 2395 Memberships 2,323 2399 Outside Agency Serv 16,573 2435 Build Repairs & Mtce 99,241 2457 Veh -Repairs & Maintenance 2,602 2478 Misc Equip Repairs 5,491 2479 Software/Hardware Maintenan< 2,180 2480 Antiques Repairs Mtce. 8,549 2482 Grounds Upkeep 766 5300 Stationery & Office Supplies 2,543 5320 Program Supplies 13,131 5340 Supplies -Special Events 8,423 5345 Antique Purchases 593 5400 Gift Shop Plaques 5,734 5520 Utilities -Gas 5,932 5530 Utilities -Hydro 23,327 5540 Utilities -Oil 1,657 5900 Gas, Oil Tires 1,789 5902 Supplies & Tools 1,216 Total Expenditures 1,122,033 Revenues 1610 Federal Grant (13,712) 1623 Ont. Specific Grants (39,263) 9910 Gift Shop (8,464) 9915 Snack Bar (1,569) City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 523,541 682,179 724 3,000 139,609 150,214 4,824 6,000 501 3,000 1,745 2,500 3,078 5,900 17,120 20,910 35,256 98,000 1,529 1,200 2,173 6,200 3,950 3,950 16,650 18,000 1,618. 10,500 1,241 2,187 11,374 5,255 100,097 99,415 3,087 5,000 2,911 5,000 2,187 2,762 10,305 8,700 1,025 2,800 1,922 2,500 11,604 12,255 11,134 10,500 470 600 2,311 5,250 6,221 7,510 24,179 25,044 1,293 816 698 1,963 782 1,000 945,159 1,210,110 (135,662) (98,000) (44,921) (39,000) (5,025) (10,500) (329) (3,100) 56 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 22,281 704,460 3.27% 0 3,000 0.00% 2,057 152,271 1.37% 0 6,000 0.00% (1,500) 1,500 (50.00%) 0 2,500 0.00% 0 5,900 0.00% 560 21,470 2.68% 0 98,000 0.00% 60,500 61,700 5,041.67% (2,400) 3,800 (38.71%) 80 4,030 2.03% (4,000) 14,000 (22.22%) (5,000) 5,500 (47.62%) (160) 2,027 (7.32%) 0 5,255 0.00% 750 100,165 0.75% 0 5,000 0.00% (2,000) 3,000 (40.00%) (497) 2,265 (17.99%) 5,000 13,700 57.47% 0 2,800 0.00% 0 2,500 0.00% 0 12,255 0.00% 80 10,580 0.76% 0 600 0.00% (2,625) 2,625 (50.00%) 0 7,510 0.00% 501 25,545 2.00% 0 816 0.00% 0 1,963 0.00% 0 1,000 0.00% 73,627 1,283,737 6.08% (85,000) (183,000) 86.73% (25,500) (64,500) 65.38% 5,250 (5,250) (50.00%) 2,100 (1,000) (67.74%) 2744 Museum 2019 Actuals 9955 Programs (14,477) 9977 Donations (2,237) 9920 Admissions -Public & Edu. (128,494) 9933 Rentals -Mtg. Room/Public (11,738) 9990 Other Misc Revenue (89) Total Revenues (220,043) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuing Stu (24,989) Total Transfers (24,989) Net 877,001 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget (4,422) (23,560) (10,411) (2,000) (38,390) (141,440) (6,382) (17,000) 0 0 (245,542) (334,600) 0 0 0 0 0 0 699,617 875,510 57 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 7,000 (16,560) (29.71%) 0 (2,000) 0.00% 0 (141,440) 0.00% 6,000 (11,000) (35.29%) 0 0 0.00% (90,150) (424,750) 26.94% (8,000) (8,000) 0.00% 0 0 0.00% (8,000) (8,000) 0.00% (24,523) 850,987 (2.80%) 2740 Pickering Arts Centre 2019 Actuals Expenditures 1100 Salaries & Wages 0 1400 Employer Contributions 0 1800 Conferences 0 2110 Travel 0 2131 Cellular Phones 0 2479 Software/Hardware Maintenanc 0 5300 Stationery & Office Supplies 0 Total Expenditures 0 Revenues Total Revenues 0 Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 Total Transfers 0 Net 0 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 0 106,385 0 29,911 0 1,500 0 1,000 0 1,000 0 0 0 500 0 140,296 0 0 0 0 0 0 0 140,296 58 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (73,670) 32,715 (69.25%) (14,863) 15,048 (49.69%) 0 1,500 0.00% 0 1,000 0.00% 0 1,000 0.00% 55 55 0.00% 0 500 0.00% (88,478) 51,818 (63.07%) 0 0 0.00% (51,818) (51,818) 0.00% (51,818) (51,818) 0.00% (140,296) 0 (100.00%) Overview Community Services Department Public Works The Community Services Department is organized into two Divisions: Culture & Recreation and Operations. The Operations Division is responsible for Public Works, which runs from the Operations Centre on Clements Road and is responsible for the maintenance and operation of Roads, Parks & Property and Fleet vehicles and equipment. Public Works is responsible for the winter control of City roads and sidewalks from November to April. Fleet Services maintain all City vehicles, equipment and tools out of the Municipal Garage within the Operations Centre. Organization Chart I I Operations Property Adm. Maintenance Key Activities for 2021 Community Services Department Public Works I I Fleet Services I Roads • Seaton -Public Works maintenance of new roads, sidewalks and parks infrastructure • Completion of the Fleet Management Software Pilot Program • Implementation of the Fleet Parts Program I Parks • Development and implementation of the Public Works Level of Service Tracking and Reporting Program • Development of Parks asset management including the input of all 85 Parks into the Asset Management software solution already in use by the Facilities Capital projects team 59 Financial Information Staffing Summary (Full & Regular Part Time) Approved Current Term 2019 2020 Approved 2021 2018 68 3 71 Add Delete Total Full Time Reg. Part-Time Total 71 ~ 75 81 ~ 84 0 0 0 0 81 Q ~ 0 84 The above chart excludes contract, students and term employees. No additional staffing recommended for 2021. Public Works hire up to 50 seasonal staff every year to supplement full time staff, with the peak in summer months when grass and parks maintenance activity is highest. Year-Over-Year (Net Cost) Budget Changes 2020 Budget 2021 Approved Budget YearNear Increase ($) (%) Operations -Adm. $1,030,442 $1,082,168 $51,726 Property Maintenance 1,157,784 1,301,229 143,445 Fleet Services 1,482,633 1,619,050 136,417 Roads 7,472,888 7,597,598 124,710 Parks 4,515,648 4,682,246 166,598 5.02 12.39 9.20 1.67 3.69 3.98 Total (Net Cost) $15,659,395 $16,282,291 $622,896 ======~====================== Explanation of Significant Budget Changes -Expenses Under the "Public Works" cost centre, the following accounts have had significant Budget changes: • Salaries & Wages -$70,466 -Budget increase reflects the full year annualization of one Inspector, Utility Cuts and four Maintenance Worker positions approved in 2020, partially offset by reductions in salaries and wages for season term positions. • Overtime -($62,500) -Budget decrease due to significantly reduced overtime in support of weekend community events in 2021 due to continuation of COVID restrictions and going virtual. • Employee Contributions -$56,332. Budget increase largely reflects higher employer paid CPP premiums and increased employer contributions due to the earlier mentioned annualized positions approved in 2020. 60 • Seminars and Education -($31,750) -Budget decrease due to seminars and education being significantly cut back in 2021 due to the continuation of COVID restrictions. Only mandatory, regulatory and operationally essential training has been included in the 2021 budget. • Repairs & Maintenance -Winter Control -$50,000 -Budget increase due to Level of Service increase in the pm-active anti-icing road brine program $20,000 additional purchase of brine per year and $30,000 additional budget for snow removal from Cul-de-sacs and bridges. • Repairs & Maintenance -Contract Services -($25,000) -Budget decrease due to deferral of Ditching Contract, ($70,000), deferral of the Phragmite Control pilot ($15,000) to 2022. • Building Repairs & Maintenance -$168,571 -Budget increase due to enhanced cleaning supplies and staff for the Operations Centre and Parks outdoor public washroom. The cleaning of these has been transferred to Facilities Operations due to the need for COVID enhanced cleaning procedures best delivered by trained Facilities staff. The 2500 Operations Admin and 2718 Parks cost centres include transfer payments for these services. • Program Supplies -$35,000 -Budget increase due to increase in the Seniors Snow Removal program 15,000 and the addition of funding for a future pandemic monument 20,000. Explanation of Significant Budget Changes -Revenues/ (Transfer from Reserves) • Rentals -$106,000 -Revenue decrease largely from Parks permits due to COVID closures. • Other Misc. Revenue -$30,000 -Revenue decrease due to reduce anticipated revenue from Road Degradation Fees. 2020 Performance Indicators/Statistics Fleet Work orders completed -Fire Services 462 work orders Work orders completed -other Departments 1,821 work orders Vehicles maintained -cars, trucks, dump truck, snow ploughs, 210 trailer, fire truck, tractors Attachments maintained -wings, ploughs, salters, ball 69 groomers, beach groomers, etc. Small equipment maintained -mowers, chain saws, trimmers, 373 etc. 61 Parks GarbaQe picked up/disposed Sidewalk winter control response Maintains open space Maintains parks Maintains playgrounds Maintains splash pads Maintains sports fields -soccer, baseball, artificial turf, cricket pitch Propert Seniors sidewalk clearing program response/ registrations Roads Roadways maintained Minimum Maintenance Standards Roadway Patrol Minimum Maintenance Standards potholes repaired Winter control response Road salt used Road sand used Road sweepings picked up/disposed 62 200,180 kg 27 events 1,940 acres 85 63 3 64 fields 13 events/ 388 registrants 347 km paved 102 km gravel 7,220 km (cumulative) 3,312 potholes 39 events 4,335 tonnes 1,713tonnes 1,500 tonnes Public Works 2019 Actuals Expenditures 1100 Salaries & Wages 6,596,064 1200 Overtime 517,166 1400 Employer Contributions 1,662,629 1900 Uniforms 74,318 2110 Travel 2,057 2122 Freight, Express & Cartage 1,098 2123 Environmental Charges 279 2131 Cellular Phones 12,875 2140 Telephones 23,742 2220 Subscription & Publications 3,141 2340 Seminars & Education 35,142 2370 Insurance Premium 181,881 2371 Ins. Deductible 14,794 2392 Consulting & Professional 19,948 2394 Recpt, Prom & Sp Events 8,451 2395 Memberships 7,860 2396 Photo, Mapping, Printing 0 2399 Outside Agency Serv 100,844 2408 Rpr & Mnt -Winter Control 915,603 2408 Rpr & Mnt -Contract Services 240,780 2408 Rpr Main. Maint Mater 518,935 2410 Engineering Rpr & Mnt 345,656 2409 Highway Aids -Repair Maint. 82,683 2429 Parks Repairs & Maintenance 87,351 2435 Build Repairs & Mtce 347,727 2437 Tree Maintenance 377,477 2438 Lighting & Repair Maint. 30,946 2457 Veh -Repairs & Maintenance 389,549 2478 Misc Equip Repairs 301,524 2479 Software/Hardware Maintenanc 19,495 2482 Grounds Upkeep 285,699 2678 Rental Misc Equip 160,212 2682 Land Rentals 19,200 5300 Stationery & Office Supplies 9,809 5302 Forms 1,750 5320 Program Supplies 426,021 5510 Utilities -Water 59,116 5520 Utilities -Gas 42,191 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 6,943,497 7,663,326 383,254 447,000 1,756,316 1,966,180 63,337 80,515 432 1,800 2,121 1,800 253 500 17,174 18,500 24,714 29,575 6,150 4,400 6,789 64,235 215,773 215,773 11,830 34,050 21,522 57,840 2,137 7,550 5,056 10,570 0 200 128,357 87,650 636,793 755,000 146,120 180,000 470,339 525,000 603,309 787,000 101,436 75,000 37,249 60,000 366,268 324,350 397,207 390,000 17,120 20,000 487,181 425,000 277,504 235,000 30,407 103,102 183,780 319,860 149,714 127,800 19,200 21,696 9,781 11,000 3,311 2,000 309,589 408,000 76,149 79,805 48,274 27,115 63 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 70,466 7,733,792 0.92% (62,500) 384,500 (13.98%) 56,332 2,022,512 2.87% 3,335 83,850 4.14% 0 1,800 0.00% 0 1,800 0.00% 0 500 0.00% 9,200 27,700 49.73% 125 29,700 0.42% 8,200 12,600 186.36% (31,750) 32,485 (49.43%) 8,622 224,395 4.00% 0 34,050 0.00% 1,925 59,765 3.33% 50 7,600 0.66% 1,060 11,630 10.03% 0 200 0.00% 17,150 104,800 19.57% 50,000 805,000 6.62% (25,000) 155,000 (13.89%) 0 525,000 0.00% (30,000) 757,000 (3.81%) 0 75,000 0.00% 0 60,000 0.00% 168,571 492,921 51.97% (5,000) 385,000 (1.28%) 0 20,000 0.00% 21,000 446,000 4.94% 0 235,000 0.00% (14,502) 88,600 (14.07%) 5,640 325,500 1.76% 3,000 130,800 2.35% 0 21,696 0.00% 0 11,000 0.00% 0 2,000 0.00% 35,000 443,000 8.58% 7,425 87,230 9.30% 24,535 51,650 90.48% Public Works 2019 Actuals 5530 Utilities -Hydro 207,629 5640 Small Tools 8,806 5900 Gas, Oil Tires 486,744 5901 Fertilizer, Grass Etc. 36,150 5902 Supplies & Tools 12,879 5903 Shop Supplies 65,745 5973 Minor Furniture & Fixtures 0 5978 Misc. Equipment 19,598 5981 Other Minor Fixed Assets 2,344 8960 Taxes Tenant 219,601 Total Expenditures 14,983,509 Revenues 1430 Sale of Services -Public Work: (204,480) 1610 Federal Grant (19,600) 9916 Vending Machines (304) 9930 Rentals (185,778) 9955 Programs (34,100) 9990 Other Revenue (4,457) 9990 Other Misc Revenue (74,458) 9954 Netted Revenue (318,015) Total Revenues (841,192) Transfers to/from Reserves & R.F. 1911 Trans. to/(from) Continuing Stu (2,524) 1920 Transfer to/(from) Reserve Fun (8,782) Total Transfers (11,306) Net 14,131,011 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 182,163 195,182 16,227 8,000 362,847 520,503 23,562 42,000 21,072 10,500 72,157 49,500 1,056 1,000 40,720 53,923 48,165 70,000 223,945 258,645 14,951,357 16,777,445 (193,470) (180,000) (86,240) (18,000) (213) (500) (39,782) (210,000) 0 (40,000) (812) 0 (131,573) (130,000) (346,037) (368,350) (798,127) (946,850) (9,278) (11,200) (51,899) (160,000) (61,177) (171,200) 14,092,053 15,659,395 64 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 24,045 219,227 12.32% 2,000 10,000 25.00% 0 520,503 0.00% 0 42,000 0.00% 1,500 12,000 14.29% 0 49,500 0.00% 1,000 2,000 100.00% 2,677 56,600 4.96% 30,000 100,000 42.86% (22,645) 236,000 (8.76%) 361,461 17,138,906 2.15% 0 (180,000) 0.00% 0 (18,000) 0.00% 0 (500) 0.00% 106,000 (104,000) (50.48%) 0 (40,000) 0.00% 0 0 0.00% 30,000 (100,000) (23.08%) 0 (368,350) 0.00% 136,000 (810,850) (14.36%) (4,565) (15,765) 40.76% 130,000 (30,000) (81.25%) 125,435 (45,765) (73.27%) 622,896 16,282,291 3.98% 2500 Operations -Admin. 2019 Actuals Expenditures 1100 Salaries & Wages 606,453 1200 Overtime 4,559 1400 Employer Contributions 131,740 1900 Uniforms 1,632 2110 Travel 251 2131 Cellular Phones 965 2140 Telephones 2,148 2220 Subscription & Publications 2,005 2340 Seminars & Education 1,975 2370 Insurance Premium 14,510 2371 Ins. Deductible 0 2392 Consulting & Professional 4,890 2394 Recpt, Prom & Sp Events 4,287 2395 Memberships 778 2399 Outside Agency Serv 3,667 2435 Build Repairs & Mtce 129,501 2479 Software/Hardware Maintenan< 519 5300 Stationery & Office Supplies 9,809 5510 Utilities -Water 7,463 5520 Utilities -Gas 42,191 5530 Utilities -Hydro 133,838 5973 Minor Furniture & Fixtures 0 Total Expenditures 1,103,181 Revenues 9916 Vending Machines (304) 9990 Other Revenue (4,457) 9954 Netted Revenue (175,350) Total Revenues (180,111) Transfers to/from Reserves & R.F. Total Transfers 0 Net 923,070 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 436,393 676,447 1,404 2,000 106,668 178,866 1,464 1,200 0 250 1,097 800 2,986 4,235 6,081 4,000 148 4,450 45,426 45,426 0 2,000 6,716 10,000 46 1,500 665 1,500 6,413 5,100 156,668 101,000 2,938 25,948 9,781 11,000 7,393 6,500 48,274 27,115 121,600 95,955 1,056 1,000 963,217 1,206,292 (213) (500) (812) 0 (175,350) (175,350) (176,375) (175,850) 0 0 786,842 1,030,442 65 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (74,555) 601,892 (11.02%) 2,000 4,000 100.00% (20,566) 158,300 (11.50%) 0 1,200 0.00% 0 250 0.00% 800 1,600 100.00% (140) 4,095 (3.31%) 8,200 12,200 205.00% 200 4,650 4.49% 909 46,335 2.00% 0 2,000 0.00% 2,000 ' 12,000 20.00% 0 1,500 0.00% (300) 1,200 (20.00%) 0 5,100 0.00% 82,011 183,011 81.20% 1,457 27,405 5:62% 0 11,000 0.00% 130 6,630 2.00% 24,535 51,650 90.48% 24,045 120,000 25.06% 1,000 2,000 100.00% 51,726 1,258,018 4.29% 0 (500) 0.00% 0 0 0.00% 0 (175,350) 0.00% 0 (175,850) 0.00% 0 0 0.00% 51,726 1,082,168 5.02% 2132 Property Maintenance 2019 Actuals Expenditures 1100 Salaries & Wages 327,151 1200 Overtime 29,616 1400 Employer Contributions 72,937 1900 Uniforms 2,800 2131 Cellular Phones 1,217 2140 Telephones 265 2340 Seminars & Education 282 2370 Insurance Premium 4,058 2392 Consulting & Professional 0 2394 Recpt, Prom & Sp Events 0 2399 Outside Agency Serv 7,230 2437 Tree Maintenance 143,431 2438 Lighting & Repair Maint. 30,946 2457 Veh -Repairs & Maintenance 5,215 2478 Misc Equip Repairs 37,248 2479 Software/Hardware Maintenan< 0 2482 Grounds Upkeep 21,348 2678 Rental Misc Equip 20,126 2682 Land Rentals 19,200 5320 Program Supplies 338,176 5900 Gas, Oil Tires 19,166 5902 Supplies & Tools 3,893 5978 Misc. Equipment 9,406 5981 Other Minor Fixed Assets 0 8960 Taxes Tenant 3,809 Total Expenditures 1,097,520 Revenues 9990 Other Misc Revenue (22,225) Total Revenues (22,225) Transfers to/from Reserves & R.F. 1911 Trans. to/(from) Continuing Stu 0 1920 Transfer to/(from) Reserve Fun 0 Total Transfers 0 Net 1,075,295 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 302,090 408,696 16,319 30,000 73,608 87,743 2,437 2,630 1,386 1,800 249 350 200 1,435 4,130 4,130 8,141 20,000 15 150 9,033 4,550 145,828 140,000 17,120 20,000 8,124 4,000 34,566 30,000 626 963 19,037 30,360 13,463 23,000 19,200 21,696 253,724 315,000 12,108 21,061 4,712 1,000 8,227 10,080 26,101 20,000 3,826 2,500 984,270 1,201,144 (21,846) (25,000) (21,846) (25,000) (2,951) (3,360) (15,000) (15,000) (17,951) (18,360) 944,473 1,157,784 66 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 37,169 445!865 9.09% (4,000) 26,000 (13.33%) 26,174 113,917 29.83% 0 2,630 0.00% 3,000 4,800 166.67% (5) 345 (1.43%) (1,300) 135 (90.59%) 80 4,210 1.94% 15,765 35,765 78.83% 50 200 33.33% 3,450 8,000 75.82% 15,000 155,000 10.71% 0 20,000 0.00% 0 4,000 0.00% 0 30,000 0.00% (193) 770 (20.04%) 39,640 70,000 130.57% 0 23,000 0.00% 0 21,696 0.00% 15,000 330,000 4.76% 0 21,061 0.00% 1,500 2,500 150.00% (480) 9,600 (4.76%) 5,000 25,000 25.00% 0 2,500 0.00% 155,850 1,356,994 12.98% 0 (25,000) 0.00% 0 (25,000) 0.00% (12,405) (15,765) 369.20% 0 (15,000) 0.00% (12,405) (30,765) 67.57% 143,445 1,301,229 12.39% 2315 Fleet Services 2019 Actuals Expenditures 1100 Salaries & Wages 957,070 1200 Overtime 60,754 1400 Employer Contributions 316,648 1900 Uniforms 21,959 2110 Travel 1,064 2122 Freight, Express & Cartage 1,098 2123 Environmental Charges 279 2131 Cellular Phones 1,337 2140 Telephones 16,423 2220 Subscription & Publications 122 2340 Seminars & Education 8,608 , 2370 Insurance Premium 4,866 2394 Recpt, Prom & Sp Events 627 2395 Memberships 380 2399 Outside Agency Serv 1,951 2435 Build Repairs & Mice 92 2457 Veh -Repairs & Maintenance 4,557 2478 Misc Equip Repairs 3,628 2479 Software/Hardware Maintenanc 7,642 2678 Rental Misc Equip 0 5302 Forms 1,750 5900 Gas, Oil Tires 12,822 5902 Supplies & Tools 5,531 5903 Shop Supplies 65,745 5978 Misc. Equipment 975 Total Expenditures 1,495,928 Revenues 9954 Netted Revenue (142,665) Total Revenues (142,665) Transfers to/from Reserves & R.F. Total Transfers 0 Net 1,353,263 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 1,117,026 1,123,913 46,545 30,000 292,230 320,396 23,475 20,465 325 550 2,121 1,800 253 500 1,855 1,600 16,056 17,390 69 200 3,776 15,500 4,955 4,955 549 800 428 1,660 2,099 500 0 0 12,371 8,000 4,070 5,000 11,298 54,872 0 500 3,311 2,000 5,517 6,032 12,887 8,500 72,157 49,500 0 1,000 1,633,373 1,675,633 (170,687) (193,000) (170,687) (193,000) 0 0 1,462,686 1,482,633 67 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 79,476 1,203,389 7.07% 15,000 45,000 50.00% 38,463 358,859 12.00% 3,335 23,800 16.30% 0 550 0.00% 0 1,800 0.00% 0 500 0.00% 2,600 4,200 162.50% (90) 17,300 (0.52%) 0 200 0.00% 4,400 19,900 28.39% 95 5,050 1.92% 0 800 0.00% 540 2,200 32.53% 5,000 5,500 1,000.00% 0 0 0.00% 0 8,000 0.00% 0 5,000 0.00% (12,402) 42,470 (22.60%) 0 500 0.00% 0 2,000 0.00% 0 6,032 0.00% 0 8,500 0.00% 0 49,500 0.00% 0 1,000 0.00% 136,417 1,812,050 8.14% 0 (193,000) 0.00% 0 (193,000) 0.00% 0 0 0.00% 136,417 1,619,050 9.20% 2320 Roads 2019 Actuals Expenditures 1100 Salaries & Wages 2,557,333 1200 Overtime 315,538 1400 Employer Contributions 675,837 1900 Uniforms 26,300 2110 Travel 563 2131 Cellular Phones 3,231 2140 Telephones 1,349 2220 Subscription & Publications 1,014 2340 Seminars & Education 14,591 2370 Insurance Premium 141,254 2371 Ins. Deductible 12,929 2394 Recpt, Prom & Sp Events 3,249 2395 Memberships 3,094 2399 Outside Agency Serv 47,070 2408 Rpr & Mnt -Winter Control 915,603 2408 Rpr & Mnt -Contract Services 240,780 2408 Rpr Main. Maint Mater 518,935 2410 Engineering Rpr & Mnt 345,656 2409 Highway Aids -Repair Maint. 82,683 2435 Build Repairs & Mtce 135,450 2437 Tree Maintenance 128,266 2457 Veh -Repairs & Maintenance 316,580 2478 Misc Equip Repairs 191,462 2479 Software/Hardware Maintenanc 4,368 2678 Rental Misc Equip 53,551 5510 Utilities -Water 0 5640 Small Tools 8,806 5900 Gas, Oil Tires 321,093 5978 Misc. Equipment 449 Total Expenditures 7,067,034 Revenues 1430 Sale of Services -Public Work: (204,480) 1610 Federal Grant (9,800) 9990 Other Misc Revenue (52,233) Total Revenues (266,513) Transfers to/from Reserves & R.F. 1920 Transferto/(from) Reserve Fun 0 Total Transfers 0 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 2,851,694 3,043,196 237,570 285,000 751,306 804,870 18,212 27,220 0 500 6,060 7,800 1,990 2,825 0 200 1,347 23,000 143,762 143,762 11,217 25,000 1,274 4,000 2,926 3,740 58,912 39,500 636,793 755,000 146,120 180,000 470,339 525,000 603,309 787,000 101,436 75,000 137,455 135,450 123,793 125,000 381,362 340,000 177,214 120,000 6,700 9,282 10,859 31,500 11,456 8,000 16,227 8,000 230,393 347,543 9,137 19,500 7,148,863 7,876,888 (193,470) (180,000) (27,440) (9,000) (107,839) (105,000) (328,749) (294,000) 0 (110,000) 0 (110,000) 68 Run Date: 4/21/21 3:54 PM 2021 INC.IDEC. Approved % CHGE. Budget 2020 47,989 3,091,185 1.58% (25,500) 259,500 (8.95%) 15,100 819,970 1.88% 0 27,220 0.00% 0 500 0.00% 2,000 9,800 25.64% 245 3,070 8.67% 0 200 0.00% (17,750) 5,250 (77.17%) 7,188 150,950 5.00% 0 25,000 0.00% 0 4,000 0.00% 300 4,040 8.02% (5,500) 34,000 (13.92%) 50,000 805,000 6.62% (25,000) 155,000 (13.89%) 0 525,000 0.00% (30,000) 757,000 (3.81%) 0 75,000 0.00% 0 135,450 0.00% 0 125,000 0.00% 0 340,000 0.00% 0 120,000 0.00% (1,862) 7,420 (20.06%) (25,000) 6,500 (79.37%) 6,000 14,000 75.00% 2,000 10,000 25.00% 0 347,543 0.00% (15,500) 4,000 (79.49%) (15,290) 7,861,598 (0.19%) 0 (180,000) 0.00% 0 (9,000) 0.00% 30,000 (75,000) (28.57%) 30,000 (264,000) (10.20%) 110,000 0 (100.00%) 110,000 0 (100.00%) 2320 Roads 2019 Actuals Net 6,800,521 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 6,820,114 7,472,888 69 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 124,710 7,597,598 1.67% 2718 Parks 2019 Actuals Expenditures 1100 Salaries & Wages 2,148,057 1200 Overtime 106,699 1400 Employer Contributions 465,467 1900 Uniforms 21,627 2110 Travel 179 2131 Cellular Phones 6,125 2140 Telephones 3,557 2340 Seminars & Education 9,686 2370 Insurance Premium 17,193 2371 Ins. Deductible 1,865 2392 Consulting & Professional 15,058 2394 Recpt, Prom & Sp Events 288 2395 Memberships 3,608 2396 Photo, Mapping, Printing 0 2399 Outside Agency Serv 40,926 2429 Parks Repairs & Maintenance 87,351 2435 Build Repairs & Mtce 82,684 2437 Tree Maintenance 105,780 2457 Veh -Repairs & Maintenance 63,197 2478 Misc Equip Repairs 69,186 2479 Software/Hardware Maintenan< 6,966 2482 Grounds Upkeep 264,351 2678 Rental Misc Equip 86,535 5320 Program Supplies 87,845 5510 Utilities -Water 51,653 5530 Utilities -Hydro 73,791 5900 Gas, Oil Tires 133,663 5901 Fertilizer, Grass Etc. 36,150 5902 Supplies & Tools 3,455 5978 Misc. Equipment 8,768 5981 Other Minor Fixed Assets 2,344 8960 Taxes Tenant 215,792 Total Expenditures 4,219,846 Revenues 1610 Federal Grant (9,800) 9930 Rentals (185,778) 9955 Programs (34,100) 9990 Other Misc Revenue 0 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 2,236,294 2,411,074 81,416 100,000 532,504 574,305 17,749 29,000 107 500 6,776 6,500 3,433 4,775 1,318 19,850 17,500 17,500 613 7,050 6,665 27,840 253 1,100 1,037 3,670 0 200 51,900 38,000 37,249 60,000 72,145 87,900 127,586 125,000 85,324 73,000 61,654 80,000 8,845 12,037 164,743 289,500 125,392 72,800 55,865 93,000 57,300 65,305 60,563 99,227 114,829 145,867 23,562 42,000 3,473 1,000 23,356 23,343 22,064 50,000 220,119 256,145 4,221,634 4,817,488 (58,800) (9,000) (39,782) (210,000) 0 (40,000) (1,888) 0 70 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (19,613) 2,391,461 (0.81%) (50,000) 50,000 (50.00%) (2,839) 571,466 (0.49%) 0 29,000 0.00% 0 500 0.00% 800 7,300 12.31% 115 4,890 2.41% (17,300) 2,550 (87.15%) 350 17,850 2.00% 0 7,050 0.00% (15,840) 12,000 (56.90%) 0 1,100 0.00% 520 4,190 14.17% 0 200 0.00% 14,200 52,200 37.37% 0 60,000 0.00% 86,560 174,460 98.48% (20,000) 105,000 (16.00%) 21,000 94,000 28.77% 0 80,000 0.00% (1,502) 10,535 (12.48%) (34,000) 255,500 (11.74%) 28,000 100,800 38.46% 20,000 113,000 21.51% 1,295 66,600 1.98% 0 99,227 0.00% 0 145,867 0.00% 0 42,000 0.00% 0 1,000 0.00% 18,657 42,000 79.93% 25,000 75,000 50.00% (22,645) 233,500 (8.84%) 32,758 4,850,246 0.68% 0 (9,000) 0.00% 106,000 (104,000) (50.48%) 0 (40,000) 0.00% 0 0 0.00% 2718 Parks 2019 Actuals Total Revenues (229,678) Transfers to/from Reserves & R.F. 1911 Trans. to/(from) Continuing Stu (2,524) 1920 Transferto/(from) Reserve Fun (8,782) Total Transfers (11,306) Net · 3,978,862 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget (100,470) (259,000) (6,327) (7,840) (36,899) (35,000) (43,226) (42,840) 4,077,938 4,515,648 71 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 106,000 (153,000) (40.93%) 7,840 0 (100.00%) 20,000 (15,000) (57.14%) 27,840 (15,000) (64.99%) 166,598 4,682,246 3.69% 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. Corporate Services Department l I I I I Information Legal Services Legislative Municipal Law Technology Services* EnforcementA .) .) * Includes Clerks Office, Records Management & Elections and Print Shop/mail Room A Includes By-law Enforcement Services and Animal Services Key Activities for 2021 • Broadband initiatives including build-out of Vianet Whitevale/Green River Network and investigation of partnerships for the delivery of internet access to underserved areas of the City • Development of Corporate Strategic Plan, including public consultation • Agreements of Purchase and Sale for Seaton employment lands to enable ongoing economic development initiatives • Land Acquisitions and Cost Contribution Agreement for Pickering Casino Resort • Site selection and programming/conceptual design of new Animal Shelter • Preparation for 2022 Election (securing of vendor for voting method and development of voting procedures) • Completion of Ward Boundary Review • Ongoing education and enforcement of COVID Regulations and health orders • New Sign by-law (Joint initiative with City Development Department) • Implementation of multiple IT projects including security awareness training, integrated Security Incident Management System, multiple system and database upgrades, ongoing support of Webex Council and Committee meetings, virtual recreation programming and remote staff working 72 Financial Information Staffing Summary (Full & Regular Part Time) Approved Current Term 2019 2020 Approved 2021 2018 36 4 40 Add. Delete Total Full Time Reg. Part-Time Total 38 _§ 43 41 _Q 47 0 1 1 0 41 0 _J_ 0 47 The part-time Animal Services Attendant's hours have been increased in 2021 from 24 hours per week to 30 hours per week to increase the level of animal care. The additional annual cost is $11,425. Year-Over-Year (Net Cost) Budget Changes 2020 Budget 2021 Approved Budget YearNear Increase ($) (%) Information Technology $2,307,008 $2,497,536 $190,528 Legal Services 483,889 380,739 (103,150) Clerks Office 189,734 311,013 121,279 Records Mgmt. & Elections 156,841 146,401 (10,440) Print Shop/Mail Room 522,776 533,527 10,751 By-Law 301,852 707,996 406,144 Animal Services 477,755 530.326 52,571 8.26 (21.32) 63.92 (6.66) 2.06 134.55 11.00 15.04 Total (Net Cost) $4,439,855 $5,107,538 $667,683 ============================ Explanation of Significant Budget Changes -Expenses • Salaries and Wages $176,733 -Budget increase largely reflects one new Municipal Law Enforcement II position and one new part time By-law Enforcement position approved in 2020, the full year annualization of one new full time Help Desk positon, and a workplace accommodation in the Clerks and Animal Services cost centres. The budget increase was partially offset from a reduction in salaries due to the retirement of a Law Clerk position. $51,000 has also been budgeted for additional hours for By-law Enforcement staff to provide additional summer enforcement capacity. • Software and hardware maintenance $188,445 -Budget increase due to a number of factors: ► Movement of maintenance costs from System and Software Upgrades and Hardware Replacements accounts to the Software/Hardware Maintenance Contracts account. 73 Enforcement Services Parking Tickets Issued 20,409 Parking Fine Revenue $565,300 * COVID-19 Enforcement-hours spent 5,434 COVI D-19 Enforcement -# park patrols 14,239 By-law Violations Requests for Service 1,326 Animal Services Requests for Service 925 Animals Sheltered (cats/doQs/small animals) 394 Animals Adopted 298 Lost pets found and returned 92 * subject to increase per MTO reconciliation 75 Corporate Services Department 2019 Actuals Expenditures 1100 Salaries & Wages 3,299,749 1200 Overtime 46,135 1400 Employer Contributions 836,447 1800 Conferences 4,889 1900 Uniforms 13,691 2110 Travel . 3,188 2121 Postage 127,166 2122 Freight, Express & Cartage 2,564 2131 Cellular Phones 14,251 2140 Telephones 20,493 2210 Advertising 797 2220 Subscription & Publications 8,792 2320 Legal Services 10,988 2340 Seminars & Education 45,272 2341 Corporate Training 7,079 2370 Insurance Premium 23,726 2371 Ins. Deductible 0 2392 Consulting & Professional 75,579 2394 Recpt, Prom & Sp Events 9,844 2395 Memberships 8,039 2399 Outside Agency Serv 98,525 2435 Build Repairs & Mtce 17,953 2457 Veh -Repairs & Maintenance 15,489 2478 Misc Equip Repairs 22,865 2479 Software/Hardware Maintenan< 425,836 2648 Building Rentals 14,546 5300 Stationery & Office Supplies 6,328 5301 Printing Supplies 175,410 5302 Forms 8,084 5530 Utilities -Hydro 4,710 5540 Utilities -Oil 4,371 5900 Gas, Oil Tires 20,755 5902 Supplies & Tools 6,757 5903 Shop Supplies 17,926 5973 Minor Furniture & Fixtures 1,658 5974 System & Software Upgrades 91,116 5975 Hardware Replacements 52,122 5978 Misc. Equipment 81,283 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 3,589,922 3,611,640 71,502 71,370 873,433 1,005,634 1,129 10,000 13,434 18,100 674 6,100 152,160 147,000 2,007 3,100 17,037 20,360 20,965 27,990 407 800 7,209 11,170 11,909 12,000 42,289 53,850 8,098 12,000 24,148 24,148 0 2,000 85,434 171,464 1,973 8,750 7,581 9,500 84,200 97,875 13,660 13,358 13,109 17,800 37,532 48,700 515,665 506,497 14,909 16,556 6,490 11,300 152,723 190,000 1,694 8,000 4,407 6,798 2,855 6,500 21,423 27,763 3,699 4,500 13,642 15,100 0 1,500 88,826 100,584 84,724 93,600 64,318 59,150 76 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 176,733 3,788,373 4.89% (6,820) 64,550 (9.56%) 10,621 1,016,255 1.06% (6,400) 3,600 (64.00%) 800 18,900 4.42% (1,900) 4,200 (31.15%) 5,000 152,000 3.40% 0 3,100 0.00% 1,000 21,360 4.91% 1,705 29,695 6.09% 0 800 0.00% (2,975) 8,195 (26.63%) 0 12,000 0.00% 9,300 63,150 17.27% 0 12,000 0.00% 472 24,620 1.95% 0 2,000 0.00% (600) 170,864 (0.35%) (500) 8,250 (5.71%) 250 9,750 2.63% (500) 97,375 (0.51%) (1,000) 12,358 (7.49%) (5,000) 12,800 (28.09%) (2,600) 46,100 (5.34%) 188,445 694,942 37.21% 408 16,964 2.46% (400) 10,900 (3.54%) 10,000 200,000 5.26% 0 8,000 0.00% 0 6,798 0.00% 0 6,500 0.00% 0 27,763 0.00% 0 4,500 0.00% 0 15,100 0.00% (1,500) 0 (100.00%) (28,134) 72,450 (27.97%) (45,800) 47,800 (48.93%) 50,110 109,260 84.72% Corporate Services Department 2019 Actuals 6000 Parking -MOT 77,488 7181 Livestock Killed 0 Total Expenditures 5,701,911 Revenues 1411 Sale of Services-Administratior (82,509) 1413 Sale of Services -Legal (1,900) 1416 Sale of Services -Agreements (132,958) 1512 Lie. & Per-Business (163,885) 1513 Lie. & Per-Amusement (271,748) 1514 Lie. & Per-Taxi (29,174) 1520 Fines (908,847) 1516 Licences · (53,300) 1519 Licenses & Permits-Marriage (33,456) 1570 Adoptions (36,800) 1571 Impound Fees (7,685) 1572 Service Fees (4,795) 1592 Donations (3,815) 1623 Ont. Specific Grants 0 9990 Other Revenue (37,991) 9990 Other Misc Revenue (18,043) 9980 Sponsorships No Tax (4,478) 9985 Marketing Sponsorships (800) 9995 Misc Rev (8,914) Total Revenues (1,801,098) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuing Stu (39,295) Total Transfers (39,295) Net 3,861,518 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 54,392 75,000 763 1,000 6,110,342 6,528,557 (57,829) (80,000) (600) (2,000) (131,138) (180,000) (78,735) (165,000) (181,459) (200,000) (136,178) (180,000) (752,785) (862,000) (52,166) (59,000) (27,962) (30,000) (27,895) (31,600) (5,670) (4,000) (2,655) (3,300) (592) 0 (793) (1,000) (24,666) (16,200) (9,377) (20,000) (1,000) (3,000) 0 (2,000) (7,976) (8,000) (1,499,476) (1,847,100) 0 (187,638) (31,110) (53,964) (31,110) (241,602) 4,579,756 4,439,855 77 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 0 75,000 0.00% (500) 500 (50.00%) 350,215 6,878,772 5.36% 10,000 (70,000) (12.50%) 0 (2,000) 0.00% 25,000 (155,000) (13.89%) 100,000 (65,000) (60.61%) 20,000 (180,000) (10.00%) 40,000 (140,000) (22.22%) 160,000 (702,000) (18.56%) 0 (59,000) 0.00% 0 (30,000) 0.00% (400) (32,000) 1.27% 0 (4,000) 0.00% 0 (3,300) 0.00% 0 0 0.00% 500 (500) (50.00%) 50 (16,150) (0.31%) 0 (20,000) 0.00% 0 (3,000) 0.00% 0 (2,000) 0.00% 0 (8,000) 0.00% 355,150 (1,491,950) (19.23%) (91,646) (279,284) 48.84% 53,964 0 (100.00%) (37,682) (279,284) 15.60% 667,683 5,107,538 15.04% 2196 Information Technology 2019 Actuals Expenditures 1100 Salaries & Wages 1,015,375 1200 Overtime 33,034 1400 Employer Contributions 256,660 1800 Conferences 3,540 1900 Uniforms 0 2110 Travel 1,129 2131 Cellular Phones 7,209 2140 Telephones 3,833 2340 Seminars & Education 32,848 2341 Corporate Training 7,079 2370 Insurance Premium 7,711 2392 Consulting & Professional 27,638 2394 Recpt, Prom & Sp Events 627 2395 Memberships 534 2399 Outside Agency Serv 6,875 2478 Misc Equip Repairs 22,865 2479 Software/Hardware Maintenanc 373,365 5300 Stationery & Office Supplies 722 5974 System & Software Upgrades 91,116 5975 Hardware Replacements 52,122 5978 Misc. Equipment 81,283 Total Expenditures 2,025,565 Revenues Total Revenues 0 Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuing Stu (24,422) Total Transfers (24,422) Net 2,001,143 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 992,829 1,113,370 33,118 52,050 269,813 311,575 0 4,000 0 0 244 1,800 7,145 8,000 4,541 8,390 33,184 36,900 8,098 12,000 7,850 7,850 40,526 65,000 193 1,000 80 650 1,800 9,600 37,532 48,700 456,348 454,089 2,504 3,700 88,826 100,584 84,724 93,600 64,318 59,150 2,133,673 2,392,008 0 0 0 (85,000) 0 0 0 (85,000) 2,133,673 2,307,008 78 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 29,252 1,142,622 2.63% (6,000) 46,050 (11.53%) 12,496 324,071 4.01% (2,000) 2,000 (50.00%) 800 800 0.00% (600) 1,200 (33.33%) 0 8,000 0.00% (185) 8,205 (2.21%) 12,500 49,400 33.88% 0 12,000 0.00% 150 8,000 1.91% (3,100) 61,900 (4.77%) 0 1,000 0.00% 0 650 0.00% 0 9,600 0.00% (2,600) 46,100 (5.34%) 173,639 627,728 38.24% 0 3,700 0.00% (28,134) 72,450 (27.97%) (45,800) 47,800 (48.93%) 50,110 109,260 84.72% 190,528 2,582,536 7.97% 0 0 0.00% 0 (85,000) 0.00% 0 0 0.00% 0 (85,000) 0.00% 190,528 2,497,536 8.26% 2125 Legal Services 2019 Actuals Expenditures 1100 Salaries & Wages 479,879 1200 Overtime 247 1400 Employer Contributions 117,447 2110 Travel 426 2131 Cellular Phones 1,331 2140 Telephones 1,576 2220 Subscription & Publications 7,986 2320 Legal Services 10,988 2340 Seminars & Education 4,074 2370 Insurance Premium 3,400 2392 Consulting & Professional 33,068 2394 Recpt, Prom & Sp Events 427 2395 Memberships 5,777 2479 Software/Hardware Maintenanc 0 5300 Stationery & Office Supplies 903 Total Expenditures 667,529 Revenues 1413 Sale of Services -Legal (1,900) 1416 Sale of Services -Agreements (132,958) 9995 Misc Rev (8,914) Total Revenues (143,772) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 Total Transfers 0 Net 523,757 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 471,022 540,763 209 2,500 120,059 146,133 226 750 639 1,600 1,493 2,115 7,143 7,620 11,909 12,000 5,738 4,500 3,460 3,460 13,543 45,000 263 500 5,498 6,550 998 1,536 1,147 1,500 643,347 776,527 (600) (2,000) (131,138) (180,000) (7,976) (8,000) (139,714) (190,000) 0 (102,638) 0 (102,638) 503,633 483,889 79 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (72,779) 467,984 (13.46%) (1,000) 1,500 (40.00%) (25,433) 120,700 (17.40%) 0 750 0.00% 0 1,600 0.00% (750) 1,365 (35.46%) 25 7,645 0.33% 0 12,000 0.00% 0 4,500 0.00% 70 3,530 2.02% 0 45,000 0.00% 0 500 0.00% 0 6,550 0.00% (601) 935 (39.13%) 0 1,500 0.00% (100,468) 676,059 (12.94%) 0 (2,000) 0.00% 25,000 (155,000) (13.89%) 0 (8,000) 0.00% 25,000 (165,000) (13.16%) (27,682) (130,320) 26.97% (27,682) (130,320) 26.97% (103,150) 380,739 (21.32%) 2122 Clerks Office 2019 Actuals Expenditures 1100 Salaries & Wages 336,143 1200 Overtime 631 1400 Employer Contributions 100,802 1800 Conferences 1,349 2110 Travel 285 2131 Cellular Phones 830 2140 Telephones 1,803 2220 Subscription & Publications 368 2340 Seminars & Education 1,231 2370 Insurance Premium 2,510 2394 Recpt, Prom & Sp Events 295 2395 Memberships 403 2479 Software/Hardware Maintenanc 380 5300 Stationery & Office Supplies 1,993 Total Expenditures 449,023 Revenues 1411 Sale of Services-Administratior (82,509) 1513 Lie. & Per-Amusement (271,748) 1519 Licenses & Permits-Marriage (33,456) Total Revenues (387,713) Transfers to/from Reserves & R.F. Total Transfers 0 Net 61,310 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 490,779 374,763 914 1,000 84,819 108,885 14 1,600 0 500 266 1,100 995 1,410 66 500 0 2,500 2,555 2,555 22 750 824 1,000 760 1,171 1,513 2,000 583,527 499,734 (57,829) (80,000) (181,459) (200,0_00) (27,962) (30,000) (267,250) (310,000) 0 0 316,277 189,734 80 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 70,019 444,782 18.68% 0 1,000 0.00% 20,986 129,871 19.27% 0 1;600 0.00% 0 500 0.00% 0 1,100 0.00% 640 2,050 45.39% 0 500 0.00% 0 2,500 0.00% 45 2,600 1.76% 0 750 0.00% 0 1,000 0.00% (411) 760 (35.10%) 0 2,000 0.00% 91,279 591,013 18.27% 10,000 (70,000) (12.50%) 20,000 (180,000) (10.00%) 0 (30,000) 0.00% 30,000 (280,000) (9.68%) 0 0 0.00% 121,279 311,013 63.92% 2191 Records Management & Elections 2019 Actuals Expenditures 1100 Salaries & Wages 112,080 1200 Overtime 406 1400 Employer Contributions 33,700 2110 Travel 59 2140 Telephones 265 2340 Seminars & Education 963 2370 Insurance Premium 847 2392 Consulting & Professional 14,873 2399 Outside Agency Serv 4,680 2479 Software/Hardware Maintenanc 30,783 5300 Stationery & Office Supplies 404 Total Expenditures 199,060 Revenues Total Revenues 0 Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuing Stu (14,873) Total Transfers (14,873) Net 184,187 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 80,767 75,959 0 1,000 32,852 24,046 0 500 249 350 0 1,250 861 861 31,365 61,464 1,285 13,375 30,848 31,000 25 1,000 178,252 210,805 0 0 0 0 (31,110) (53,964) (31,110) (53,964) 147,142 156,841 81 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (6,637) 69,322 (8.74%) 0 1,000 0.00% (1,288) 22,758 (5.36%) 0 500 0.00% 330 680 94.29% 0 1,250 0.00% 19 880 2.21% 2,500 63,964 4.07% 0 13,375 0.00% 4,636 35,636 14.95% 0 1,000 0.00% (440) 210,365 (0.21%) 0 0 0.00% (63,964) (63,964) 0.00% 53,964 0 (100.00%) (10,000) (63,964) 18.53% (10,440) 146,401 (6.66%) 2199 Print Shop/Mail Room 2019 Actuals Expenditures 1100 Salaries & Wages 110,039 1200 Overtime 0 1400 Employer Contributions 26,864 2121 Postage 127,166 2122 Freight, Express & Cartage 2,564 2140 Telephones 527 2370 Insurance Premium 2,294 2399 Outside Agency Serv 32,732 2479 Software/Hardware Maintenanc 0 5300 Stationery & Office Supplies 830 5301 Printing Supplies 175,410 Total Expenditures 478,426 Revenues 9990 Other Revenue (9,458) Total Revenues (9,458) Transfers to/from Reserves & R.F. Total Transfers 0 Net 468,968 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 92,684 109,508 0 500 21,513 33,042 152,160 147,000 2,007 3,100 498 705 2,335 2,335 33,648 35,000 4,129 286 370 1,500 152,723 190,000 462,067 522,976 0 (200) 0 (200) 0 0 462,067 522,776 82 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 256 109,764 0.23% 0 500 0.00% (4,634) 28,408 (14.02%) 5,000 152,000 3.40% 0 3,100 0.00% (25) 680 (3.55%) 45 2,380 1.93% 0 35,000 0.00% (91) 195 (31.82%) 0 1,500 0.00% 10,000 200,000 5.26% 10,551 533,527 2.02% 200 0 (100.00%) 200 0 (100.00%) 0 0 0.00% 10,751 533,527 2.06% 2220 By-law 2019 Actuals Expenditures 1100 Salaries & Wages 854,568 1200 Overtime 4,591 1400 Employer Contributions 219,797 1800 Conferences 0 1900 Uniforms 8,619 2110 Travel 888 2131 Cellular Phones 3,845 2140 Telephones 1,611 2220 Subscription & Publications 398 2340 Seminars & Education 3,901 2370 Insurance Premium 4,742 2371 Ins. Deductible 0 2395 Memberships 734 2399 Outside Agency Serv 17,026 2457 Veh -Repairs & Maintenance 12,679 2479 Software/Hardware Maintenan< 18,959 5300 Stationery & Office Supplies 764 5302 Forms 8,084 5900 Gas, Oil Tires 15,263 5902 Supplies & Tools 1,392 6000 Parking -MOT 77,488 Total Expenditures 1,255,349 Revenues 1512 Lie. & Per-Business (163,885) 1514 Lie. & Per-Taxi (29,174) 1520 Fines (908,847) 9990 Other Misc Revenue (18,043) Total Revenues (1,119,949) Transfers to/frorri Reserves & R.F. Total Transfers 0 Net 135,400 City of Pickering 2021 Current Budget Approved Final 2020 · 2020 YTD Approved Actuals Budget 1,069,731 1,032,581 31,833 6,320 260,830 300,723 1,115 2,800 11,238 14,500 134 900 7,621 7,760 2,239 3,175 0 3,000 1,987 6,000 4,825 4,825 0 2,000 730 900 14,010 5,500 9,480 15,000 17,966 15,505 621 600 1,694 8,000 16,284 19,763 1,024 2,000 54,392 75,000 1,507,754 1,526,852 (78,735) (165,000) (136,178) (180,000) (751,085) (860,000) (9,377) (20,000) (975,375) (1,225,000) 0 0 532,379 301,852 83 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 111,095 1,143,676 10.76% 2,180 8,500 34.49% (263) 300,460 (0.09%) (2,800) 0 (100.00%) 0 14,500 0.00% 0 900 0.00% 0 7,760 0.00% 1,950 5,125 61.42% (3,000) 0 (100.00%) (2,000) 4,000 (33.33%) 95 4,920 1.97% 0 2,000 0.00% 0 900 0.00% 0 5,500 0.00% (5,000) 10,000 (33.33%) 3,887 19,392 25.07% 0 600 0.00% 0 8,000 0.00% 0 19,763 0.00% 0 2,000 0.00% 0 75,000 0.00% 106,144 1,632,996 6.95% 100,000 (65,000) (60.61%) 40,000 (140,000) (22.22%) 160,000 (700,000) (18.60%) 0 (20,000) 0.00% 300,000 (925,000) (24.49%) 0 0 0.00% 406,144 707,996 134.55% 2293 Animal Services 2019 Actuals Expenditures 1100 Salaries & Wages 391,665 1200 Overtime 7,226 1400 Employer Contributions 81,177 1800 Conferences 0 1900 Uniforms 5,072 2110 Travel 401 2131 Cellular Phones 1,036 2140 Telephones 10,878 2210 Advertising 797 2220 Subscription & Publications 40 2340 Seminars & Education 2,255 2370 Insurance Premium 2,222 2394 Recpt, Prom & Sp Events 8,495 2395 Memberships 591 2399 Outside Agency Serv 37,212 2435 Build Repairs & Mtce 17,953 2457 Veh -Repairs & Maintenance 2,810 2479 Software/Hardware Maintenan< 2,349 2648 Building Rentals 14,546 5300 Stationery & Office Supplies 712 5530 Utilities -Hydro 4,710 5540 Utilities -Oil 4,371 5900 Gas, Oil Tires 5,492 5902 Supplies & Tools 5,365 5903 Shop Supplies 17,926 5973 Minor Furniture & Fixtures 1,658 7181 Livestock Killed 0 Total Expenditures 626,959 Revenues 1520 Fines 0 1516 Licences (53,300) 1570 Adoptions (36,800) 1571 Impound Fees (7,685) 1572 Service Fees (4,795) 1592 Donations (3,815) 1623 Ont. Specific Grants 0 9990 Other Revenue (28,533) 9980 Sponsorships No Tax (4,478) City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 392,110 364,696 5,428 8,000 83,547 81,230 0 1,600 2,196 3,600 70 1,650 1,366 1,900 10,950 11,845 407 800 0 50 1,380 2,700 2,262 2,262 1,495 6,500 449 400 33,457 34,400 13,660 13,358 3,629 2,800 4,616 2,910 14,909 16,556 310 1,000 4,407 6,798 2,855 6,500 5,139 8,000 2,675 2,500 13,642 15,100 0 1,500 763 1,000 601,722 599,655 (1,700) (2,000) (52,166) (59,000) (27,895) (31,600) (5,670) (4,000) (2,655) (3,300) (592) 0 (793) (1,000) (24,666) (16,000) (1,000) (3,000) 84 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 45,527 410,223 12.48% (2,000) 6,000 (25.00%) 8,757 89,987 10.78% (1,600) 0 (100.00%) 0 3,600 0.00% (1,300) 350 (78.79%) 1,000 2,900 52.63% (255) 11,590 (2.15%) 0 800 0.00% 0 50 0.00% (1,200) 1,500 (44.44%) 48 2,310 2.12% (500) 6,000 (7.69%) 250 650 62.50% (500) 33,900 (1.45%) (1,000) 12,358 (7.49%) 0 2,800 0.00% 7,386 10,296 253.81% 408 16,964 2.46% (400) 600 (40.00%) 0 6,798 0.00% 0 6,500 0.00% 0 8,000 0.00% 0 2,500 0.00% ,. 0 15,100 0.00% (1,500) 0 (100.00%) (500) 500 (50.00%) 52,621 652,276 8.78% 0 (2,000) 0.00% 0 (59,000) 0.00% (400) (32,000) 1.27% 0 (4,000) 0.00% 0 (3,300) 0.00% 0 0 0.00% 500 (500) (50.00%) (150) (16,150) 0.94% 0 (3,000) 0.00% 2293 Animal Services 2019 Actuals 9985 Marketing Sponsorships (800) Total Revenues (140,206) Transfers to/from Reserves & R.F. Total Transfers 0 Net 486,753 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 0 (2,000) (117,137) (121,900) 0 0 484,585 477,755 85 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 0 (2,000) 0.00% (50) (121,950) 0.04% 0 0 0.00% 52,571 530,326 11.00% 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 Engineering Services Department Capital Projects & Infrastructure* I *Includes Crossing Guards, Sidewalks and Streetlights Key Activities for 2021 \.. Water Resources & Development Services • Completion of Integrated Transportation Master Plan • Completion of Beachfront Park Rehabilitation and Needs Assessment work plan and public engagement • Implementation of road safety measures to combat speeding on City roads • Commencement of detailed design for Highway 401 road crossing connecting Notion Road to Squires Beach Road • Completion of servicing in Seaton Innovation Corridor related to Kubota lands 86 Financial Information Fu.II Time Reg. Part-Time Total 2018 29 _Q 29 Staffing Summary (Full & Regular Part Time) Approved Current Term 2019 2020 Add 30 _Q 30 30 _Q 30 0 Q 0 Approved 2021 Delete Total 0 30 0 _Q 0 30 The above chart excludes 1 Full Time Term summer student (May to August) that was not hired in 2020 due to the COVID pandemic and will not be hired in 2021 due to continuation of the COVID pandemic. Year-Over-Year (Net Cost) Budget Changes 2020 Budget 2021 Approved Budget YearNear Increase ($) (%) Eng. Services-Adm. $2,406,348 $2,596,062 $189,714 Crossing Guards 376,828 396,400 19,572 Water Res. & Dev. Serv. 973,918 944,297 (29,621) Sidewalks 188,415 195,590 7,175 Street Lights 952,979 953,680 701 7.88 5.19 (3.04) 3.81 0.07 3.83 Total (Net Cost) $4,898,488 $5,086,029 $187,541 ============================== Explanation of Significant Budget Changes -Expenses • Under the Engineering Services Administration cost centre, the Outside Agency Services account includes an expenditure of $350,000 to implement the Automated Speed Enforcement program in 2021. This amount includes the one time startup cost as well as the monthly costs. • Under the Sidewalks cost centre, the Other Minor Fixed Assets account includes a reduction of $100,000 for the repair/replacement of sidewalks as this meets the requirements for the 2021 program. Explanation of Significant Budget Changes -Revenues/ (Transfer from Reserves) • The reduction in Transfer from Reserves is related to a reduction in continuing studies and consulting assignment requirements for 2021 as projects are further advanced or completed. 87 Engineering Services Department 2019 Actuals Expenditures 1100 Salaries & Wages 2,405,573 1200 Overtime 16,520 1400 Employer Contributions 637,265 1800 Conferences 848 1900 Uniforms 2,571 2110 Travel 2,506 2131 Cellular Phones 5,930 2140 Telephones 6,860 2210 Advertising 1,280 2220 Subscription & Publications 1,376 2340 Seminars & Education 10,008 2370 Insurance Premium 166,050 2371 Ins. Deductible 7,652 2392 Consulting & Professional 396,653 2394 Recpt, Prom & Sp Events 153 2395 Memberships 7,389 2396 Photo, Mapping, Printing 2,529 2399 Outside Agency Serv 364,715 2407 Roads Repair & Mtce 6,019 2408 Rpr Main. Maint Mater 8,718 2457 Veh -Repairs & Maintenance 6,152 2478 Misc Equip Repairs 276,216 2479 Software/Hardware Maintenan< 8,461 2678 Rental Misc Equip 3,357 5300 Stationery & Office Supplies 3,940 530.2 Forms 0 5530 Utilities -Hydro 484,722 5900 Gas, Oil Tires 11,823 5902 Supplies & Tools 1,282 5973 Minor Furniture & Fixtures 0 5978 Misc. Equipment 10,626 5981 Other Minor Fixed Assets 204,649 Total Expenditures 5,061,843 Revenues 1429 Sale of Serv-Dev Cntrl (1,639,629) 9990 Other Revenue (5,284) 9990 Other Misc Revenue (15,496) 9965 Cost Recoveries (36,688) City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 2,572,625 2,763,070 8,147 16,500 691,350 763,291 877 1,400 1,791 4,000 362 2,400 7,678 13,110 7,215 10,230 0 0 604 1,650 4,125 7,500 169,010 169,010 14,915 7,950 198,933 1,264,760 245 300 7,129 9,265 1,960 4,000 276,356 537,278 26,483 10,000 11,876 20,000 13,181 7,900 398,755 411,200 14,737 22,963 0 3,750 2,770 3,300 0 750 485,274 491,429 7,827 13,092 1,749 8,150 2,493 3,000 11,898 15,000 170,102 345,000 5,110,467 6,931,248 (1,378,605) (744,500) (6,713) 0 (20,385) (10,000) 0 (53,000) 89 Ruri Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 15,570 2,778,640 0.56% (4,500) 12,000 (27.27%) 1,391 764,682 0.18% (400) 1,000 (28.57%) (500) 3,500 (12.50%) (350) 2,050 (14.58%) (10) 13,100 (0.08%) 15 10,245 0.15% 0 0 0.00% 0 1,650 0.00% (2,900) 4,600 (38.67%) 7,690 176,700 4.55% 0 7,950 0.00% (215,704) 1,049,056 (17.05%) 0 300 0.00% 325 9,590 3.51% 0 4,000 0.00% 256,522 793,800 47.74% 0 10,000 0.00% 0 20,000 0.00% 5,100 13,000 64.56% (10,000) 401,200 (2.43%) (4,783) 18,180 (20.83%) 800 4,550 21.33% 0 3,300 0.00% 0 750 0.00% 8,571 500,000 1.74% 0 13,092 0.00% 0 8,150 0.00% (3,000) 0 (100.00%) (3,000) 12,000 (20.00%) (100,000) 245,000 (28.99%) (49,163) 6,882,085 (0.71%) (17,500) (762,000) 2.35% (3,000) (3,000) 0.00% 0 (10,000) 0.00% 18,000 (35,000) (33.96%) Engineering Services Department 2019 Actuals Total Revenues (1,697,097) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuing Stu (17,270) 1920 Transfer to/(from) Reserve Fun (514,927) Total Transfers (532,197) Net 2,832,549 City of Pickering 2021 Current Budget Approved Final · 2020 2020 YTD Approved Actuals Budget (1,405,703) (807,500) 0 0 (37,097) (142,785) (248,923) (1,082,475) (286,020) (1,225,260) 3,418,744 4,898,488 90 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 · (2,500) (810,000) 0.31% (35,000) (35,000) 0.00% 37,762 (105,023) (26.45%) 236,442 (846,033) (21.84%) 239,204 (986,056) (19.52%) 187,541 5,086,029 3.83% 2290 Engineering Services -Adm in. 2019 Actuals Expenditures 1100 Salaries & Wages 1,285,208 1200 Overtime 14,473 1400 Employer Contributions 342,515 1800 Conferences 848 1900 Uniforms 993 2110 Travel 1,215 2131 Cellular Phones 3,529 2140 Telephones 3,436 2210 Advertising 1,280 2220 Subscription & Publications 772 2340 Seminars & Education 2,801 2370 Insurance Premium 9,237 2371 Ins. Deductible 0 2392 Consulting & Professional 169,050 2394 Recpt, Prom & Sp Events 153 2395 Memberships 4,160 2396 Photo, Mapping, Printing 2,529 2399 Outside Agency Serv 1,628 2457 Veh -Repairs & Maintenance 4,018 2478 Misc Equip Repairs 0 2479 Software/Hardware Maintenanc 1,225 2678 Rental Misc Equip 3,357 5300 Stationery & Office Supplies 1,819 5302 Forms 0 5900 Gas, Oil Tires 6,505 5902 Supplies & Tools 127 5978 Misc. Equipment 10,626 Total Expenditures . 1,871,504 Revenues 9990 Other Revenue (4,426) 9965 Cost Recoveries 0 Total Revenues (4,426) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuing Stu (17,270) 1920 Transfer to/(from) Reserve Fun (118,018) Total Transfers (135,288) City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 1,386,167 1,498,117 2,260 14,000 372,804 414,467 877 1,400 741 2,000 73 750 3,737 7,710 3,732 5,290 0 0 0 1,000 1,321 1,500 9,400 9,400 0 2,000 118,571 750,530 245 200 4,391 5,180 1,960 4,000 0 152,800 7,580 5,000 0 200 3,726 9,671 0 3,750 1,553 2,100 0 750 1,852 7,413 85 150 11,898 12,000 1,932,973 2,911,378 (6,713) 0 0 (15,000) (6,713) (15,000) 0 0 (30,028) (39,360) (46,120) (450,670) (76,148) (490,030) 91 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 7,898 1,506,015 0.53% (4,000) 10,000 (28.57%) 1,292 415,759 0.31% (400) 1,000 (28.57%) 0 2,000 0.00% 0 750 0.00% (10) 7,700 (0.13%) 175 5,465 3.31% 0 0 0.00% 0 1,000 0.00% 0 1,500 0.00% 190 9,590 2.02% 0 2,000 0.00% (68,470) 682,060 (9.12%) 0 200 0.00% (50) 5,130 (0.97%) 0 4,000 0.00% 235,000 387,800 153.80% 3,000 8,000 60.00% 0 200 0.00% (3,681) 5,990 (38.06%) 800 4,550 21.33% 0 2,100 0.00% 0 750 0.00% 0 7,413 0.00% 0 150 0.00% 0 12,000 0.00% 171,744 3,083,122 5.90% (3,000) (3,000) 0.00% 15,000 0 (100.00%) 12,000 (3,000) (80.00%) (35,000) (35,000) 0.00% 24,563 (14,797) (62.41%) 16,407 (434,263) (3.64%) 5,970 (484,060) (1.22%) 2290 Engineering Services -Adm in. 2019 Actuals Net 1,731,790 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 1,850,112 2,406,348 92 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 189,714 2,596,062 7.88% 2230 Crossing Guards 2019 Actuals Expenditures 2370 Insurance Premium 2,310 2399 Outside Agency Serv 354,201 Total Expenditures 356,511 Revenues Total Revenues 0 Transfers to/from Reserves & R.F. Total Transfers 0 Net 356,511 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 2,350 2,350 266,005 374,478 268,355 376,828 0 0 0 0 268,355 376,828 93 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. :6-pproved % CHGE. Budget 2020 50 2,400 2.13% 19,522 394,000 5.21% 19,572 396,400 5.19% 0 0 0.00% 0 0 0.00% 19,572 396,400 5.19% 2613 Water Resources & Development Services 2019 Actuals Expenditures 1100 Salaries & Wages 1,120,365 1200 Overtime 2,047 1400 Employer Contributions 294,750 1900 Uniforms 1,578 2110 Travel 1,291 2131 Cellular Phones 2,401 2140 Telephones 3,424 2220 Subscription & Publications 604 2340 Seminars & Education 7,207 2370 Insurance Premium 7,116 2371 Ins. Deductible 0 2392 Consulting & Professional 227,603 2394 Recpt, Prom & Sp Events 0 2395 Memberships 3,229 2407 Roads Repair & Mtce 6,019 2457 Veh -Repairs & Maintenance 2,134 2478 Misc Equip Repairs 0 2479 Software/Hardware Maintenanc 7,236 5300 Stationery & Office Supplies 2,121 5900 Gas, Oil Tires , 5,318 5902 Supplies & Tools 1,155 5973 Minor Furniture & Fixtures 0 5978 Misc. Equipment 0 Total Expenditures 1,695,598 Revenues 1429 Sale of Serv-Dev Cntrl (1,639,629) 9990 Other Misc Revenue (15,496) 9965 Cost Recoveries (36,688) Total Revenues (1,691,813) Transfers to/from Reserves & R.F. 1911 Trans. to/(from) Continuing Stu 0 1920 Transfer to/(from) Reserve Fun (192,260) Total Transfers (192,260) Net (188,475) City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 1,186,458 1,264,953 5,887 2,500 318,546 348,824 1,050 2,000 289 1,650 3,941 5,400 3,483 4,940 604 650 2,804 6,000 7,245 7,245 0 1,000 79,344 504,230 0 100 2,738 4,085 26,483 10,000 5,601 2,900 412 1,000 11,011 13,292 1,217 1,200 5,975 5,679 1,664 8,000 2,493 3,000 0 3,000 1,667,245 2,201,648 (1,378,605) (744,500) (20,385) (10,000) 0 (38,000) (1,398,990) (792,500) (7,069) (103,425) (32,701) (331,805) (39,770) (435,230) 228,485 973,918 94 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 7,672 1,272,625 0.61% (500) 2,000 (20.00%) 99 348,923 0.03% (500) 1,500 (25.00%) (350) 1,300 (21.21%) 0 5,400 0.00% (160) 4,780 (3.24%) 0 650 0.00% (2,900) 3,100 (48.33%) 145 7,390 2.00% 0 1,000 0.00% (154,690) 349,540 (30.68%) 0 100 0.00% 375 4,460 9.18% 0 10,000 0.00% 2,100 5,000 72.41% 0 1,000 0.00% (1,102) 12,190 (8.29%) 0 1,200 0.00% 0 5,679 0.00% 0 8,000 0.00% (3,000) 0 (100.00%) (3,000) 0 (100.00%) (155,811) 2,045,837 (7.08%) (17,500) (762,000) 2.35% 0 (10,000) 0.00% 3,000 (35,000) (7.89%) (14,500) (807,000) 1.83% 20,655 (82,770) (19.97%) 120,035 (211,770) (36.18%) 140,690 (294,540) {32.33%) (29,621) 944,297 (3.04%) 2323 Sidewalks 2019 Actuals Expenditures 2370 Insurance Premium 140,954 2371 Ins. Deductible 7,652 2408 Rpr Main. Maint Mater 8,718 5981 Other Minor Fixed Assets 204,649 Total Expenditures 361,973 Revenues Total Revenues 0 Transfers to/from Reserves & R.F. 1920 Transfer to/(from) Reserve Fun (204,649) Total Transfers (204,649) Net 157,324 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 143,465 143,465 14,915 4,950 11,876 20,000 170,102 320,000 340,358 488,415 0 0 (170,102) (300,000) (170,102) (300,000) 170,256 188,415 95 Run Date: 4/21/21 3:54 PM 2021 INC.IDEC. Approved % CHGE. Budget 2020 7,175 150,640 5.00% 0 4,950 0.00% 0 20,000 0.00% (100,000) 220,000 (31.25%) (92,825) 395,590 (19.01%) 0 0 0.00% 100,000 (200,000) (33.33%) 100,000 (200,000) (33.33%) 7,175 195,590 3.81% 2325 Street Lights 2019 Actuals Expenditures 2370 Insurance Premium 6,433 2392 Consulting & Professional 0 2399 Outside Agency Serv 8,886 2478 Misc Equip Repairs 276,216 5530 Utilities -Hydro 484,722 5981 Other Minor Fixed Assets 0 Total Expenditures 776,257 Revenues 9990 Other Revenue (858) Total Revenues (858) Transfers to/from Reserves & R.F. 1911 Trans. to/(from) Continuing Stu 0 Total Transfers 0 Net 775,399 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 6,550 6,550 1,018 10,000 10,351 10,000 398,343 410,000 485,274 491,429 0 25,000 901,536 952,979 0 0 0 0 0 0 0 0 901,536 952,979 96 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 130 6,680 1.98% 7,456 17,456 74.56% 2,000 12,000 20.00% (10,000) 400,000 (2.44%) 8,571 500,000 1.74% 0 25,000 0.00% 8,157 961,136 0.86% 0 0 0.00% 0 0 0.00% (7,456) (7,456) 0.00% (7,456) (7,456) 0.00% 701 953,680 0.07% Finance Department Overview The Finance Department is responsible for the overall management of the City and Library 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 -.., r 'I r Taxation Budgets & Accountng Supply & Internal Audit Services Services \. ,J ) Key Activities for 2021 • Implementation of Financial System (SAP) and the Cash Management System (CORE) • Management of 2021 Budget Challenges • Commence new Development Charges Study and Community Benefits Study • Management of assessment appeals • Review of the City's WSIB funding arrangement, in conjunction with Human Resources • Develop a Municipal Revenue (Casino) Sharing Agreement • Completion of the 2020 Annual Audit • Completion of the five year Capital and Operating Impact Analysis • Issuance of T4 statements that meet the revised CRA reporting requirements for (Canada Emergency Response Benefit) or CERB -.., • Implementation of the Asset Management Plan that now includes a "level of service" measured by standard metrics for core assets (roads, bridges and stormwater assets) 97 Financial Information Staffing Summary (Full & Regular Part Time) Approved Current Term 2019 2020 Approved 2021 2018 26 0 26 Add Delete Total Full Time 1 0 28 Reg. Part-Time Total 26 _Q 26 27 _Q 27 0 Q _Q 1 0 28 The proposed new position is for a Senior Financial Analyst to be deployed in two areas: budgets and financial reporting. There is an urgent need to develop capacity and experience in the budget area. Currently, the vast majority of budget work continues to be undertaken either after regular working hours or working on weekends. In addition, this position is part of the department's succession strategy due to anticipated three retirements in the near future .. Government grant reporting increases every year and there is a need to have additional resources in this area. Year-Over-Year (Net Cost) Budget Changes 2020 2021 YearNear Increase Budget Approved ($) (%) Budget Finance $673,140 $649,517 ($23,623) (3.51) Supply & Services 430,492 445,457 14,965 3.48 Total (Net Cost) $1,103,632 $1,094,974 ($8,658) (0.78) Explanation of Significant Changes -Expenses • The consulting account is reflecting a decrease of $75,525 mainly due to the completion of the Property Tax System (TXM) upgrade. TXM software was upgraded to run on Oracle version 12C that provides a higher level of security functionality. For 2021, there are three major consulting projects for the City (from a financial perspective) to undertake: • Development Charge (DC) Study and Community Benefit Charge (CBC) Study ($80,000); 98 • Asset Management Plan (to be in compliance with Ontario Regulations 588/17) for a cost of $70,000; • 5 Year Capital & Operating Cost Financial Impact Analysis ($27,500). The DC and CBC studies are funded 100% from the Development Charges Reserve Fund. The costs associated with the asset management plan are funded from the Federal Gas Tax Reserve Fund. The 5 Year financial impact study is funded partially from DC's (39.1 %)and property taxes (60.9%). • The Province of Ontario has recently made changes to the Development Charges Act and Planning Act that provided a transition period of until September 18, 2022 to conform to the changes. The City needs to complete a new Community Benefit Charge Study before this date and prepare a new DC background study to reflect the changes in legislation and to allow City to continue to collect DC's after the expiry of the current DC By-law on December 31, 2022. • The City is required to produce an Asset Management Plan for its core municipal assets based on current levels of service. Municipal core assets includes roads, bridges and storm water assets. • The City has a significant major capital program for the next five years that includes City Centre project; Highway 401 Road Crossing; Animal Shelter; Pickering Heritage & Community Centre and Seaton Recreation & Library Complex. The consulting engagement should produce a five year financial strategy that examines capital and operating costs, a funding plan for capital projects that includes the use of multiple funding sources: debt, DC and other possible revenues and also considers debt levels as it applies to the Provincial Annual Repayment Limit or ARL. • The software/Hardware Maintena·nce account is showing an increase of $69, 113 mainly due to the SAP financial system. (The acronym SAP translates to Systems, Applications and Products). During the implementation phase, the City did not use all of the functionality/modules and with the City going "Live", this has resulted in higher software maintenance cost. • The Financial Service Charges account is showing a decrease of $175,000. This decrease is due to a transfer of the ActiveNet finance charges to the Culture & Rec - Administration cost centre. There is an accounting principle (matching) that states you "Match Expenses to Revenues". The matching principle is based on the cause and effect relationship. The City's recreation section uses ActiveNet software to manage their programs and for credit and debit payment processing. Employing the "matching principle", the ActiveNet costs of $175,000 were allocated to the recreation area to better reflect the true operating cost of the recreation area. 99 Explanation of Significant Changes -Revenues/ (Transfer from Reserves) Based on current interest rates, City staff are forecasting a decrease in investment revenues in the amount of $140,000. To mitigate the decrease, finance staff will explore opportunities with Durham Region Finance Department regarding a "pooling of investment funds" strategy. 2020 Performance Indicators/Statistics Accounts Receivable I Invoices Issued I Total Invoice Value Accounts Payable Vendors Paid Total Dollar Value Paroll I T4Slips Pa Statements P t T roper :y axes Phone Calls Tax Bills Issued Payments Processed Purchasing Cards Transactions Value of PCard Transactions Number of P Cards Issued Supply & Services Purchase Orders Issued Blanket POs -Number of Blanket POs -Total PO Value Bids -Number of Bids -Total Bids Value Quotes -Number of Quotes -Total Quotes Value RFPs -Number of RFPs · -Total RFPs Value Tenders -Number of Tenders -Total Tenders Value 255 $795,394 1,849 $82.9 m 937 17,818 17,528 65,321 $241.2m 3,631 $607,168 106 783 101 22.7m 98 $45.8 m 70 $6m 10 16.6 m 18 $23.1 m 100 2127 Finance 2019 Actuals Expenditures 1100 Salaries & Wages 1,961,820 1200 Overtime 3,528 1400 Employer Contributions 506,918 1800 Conferences 3,787 2110 Travel 507 2131 Cellular Phones 564 2140 Telephones 7,211 2191 Data Processing Services 160,529 2220 Subscription & Publicat(ons 2,275 2340 Seminars & Education 6,356 2365 Purch Prnting/Broch/News Ur 21,177 2370 Insurance Premium 13,756 2392 Consulting & Professional 143,924 2394 Recpt, Prom & Sp Events 2,771 2395 Memberships 13,547 2399 Outside Agency Serv 12,313 2478 Misc Equip Repairs 12,053 2479 Software/Hardware Maintenanc 219,502 2819 Financial Service Charges 254,850 5300 Stationery & Office Supplies 7,376 5302 Forms 621 5320 Program Supplies 0 5974 System & Software Upgrades 0 Total Expenditures 3,345,385 Revenues 1412 Tax Certificates & Other Fees (308,113) 1550 Interest on Investments (1,455,429) 1560 Penalties & Interest on Taxes (2,907,048) 1610 Federal Grant (30,436) 9990 Other Misc Revenue (109,728) Total Revenues (4,810,754) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 0 1911 Trans. to/(from) Continuing Stu 0 1920 Transfer to/(from) Reserve Fun (35,879) Total Transfers (35,879) Net (1,501,248) City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 2,088,743 2,243,400 9,548 35,750 539,988 630,063 1,816 8,300 0 1,700 1,072 875 6,469 9,175 170,181 165,000 2,127 4,000 2,929 14,600 18,197 22,000 14,000 14,000 200,303 404,430 1,041 1,600 14,149 16,245 5,940 13,000 2,178 2,300 480,859 427,432 134,503 250,000 7,250 11,200 2,008 1,500 0 0 0 12,600 3,703,301 4,289,170 (298,191) (271,000) (653,179) (665,000) (2,401,341) (2,265,000) 0 0 (117,864) (55,000) (3,470,575) (3,256,000) 0 (119,400) (24,735) (27,930) (75,713) (212,700) (100,448) (360,030) 132,278 673,140 102 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 116,744 2,360,144 5.20% 0 35,750 0.00% 33,490 663,553 5.32% (3,550) 4,750 (42.77%) (700) 1,000 (41.18%) 625 1,500 71.43% (300) 8,875 (3.27%) 7,000 172,000 4.24% 0 4,000 0.00% 600 15,200 4.11% 0 22,000 0.00% 280 14,280 2.00% (75,525) 328,905 (18.67%) 0 1,600 0.00% 1,050 17,295 6.46% 0 13,000 0.00% 0 2,300 0.00% 69,398 496,830 16.24% (175,000) 75,000 (70.00%) (2,000) 9,200 (17.86%) 0 1,500 0.00% 15,000 15,000 0.00% (4,000) 8,600 (31.75%) (16,888) 4,272,282 (0.39%) (10,000) (281,000) 3.69% 140,000 (525,000) (21.05%) (150,000) (2,415,000) 6.62% 0 0 0.00% (15,000) (70,000) 27.27% (35,000) (3,291,000) 1.07% 34,000 (85,400) (28.48%) 27,930 0 (100.00%) (33,665) (246,365) 15.83% 28,265 (331,765) (7.85%) (23,623) 649,517 (3.51%) 2133 Supply & Services 2019 Actuals Expenditures 1100 Salaries & Wages 271,806 1200 Overtime 79 1400 Employer Contributions 71,766 1800 Conferences 518 2110 Travel 96 2131 Cellular Phones 0 2140 Telephones 1,051 2340 Seminars & Education 2,763 2370 Insurance Premium 1',849 2394 Reep!, Prom & Sp Events 224 2395 Memberships 1,028 2399 Outside Agency Serv 1,496 2479 Software/Hardware Maintenanc 0 5300 Stationery & Office Supplies 502 Total Expenditures 353,178 Revenues Total Revenues 0 Transfers to/from Reserves & R.F. Total Transfers 0 Net 353,178 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 323,733 327,488 383 5,000 86,861 82,479 847 2,400 0 900 433 0 995 1,410 637 3,600 1,880 1,880 0 400 980 1,485 1,520 1,600 552 850 121 1,000 418,942 430,492 0 0 0 0 418,942 430,492 103 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 3,091 330,579 0.94% 0 5,000 0.00% 7,064 89,543 8.56% 0 2,400 0.00% 0 900 0.00% 0 0 0.00% (45) 1,365 (3.19%} 5,100 8,700 141.67% 40 1,920 2.13% 0 400 0.00% 0 1,485 0.00% 0 1,600 0.00% (285) 565 (33.53%) 0 1,000 0.00% 14,965 445,457 3.48% 0 0 0.00% 0 0 0.00% 14,965 445,457 3.48% Financial Information Staffing Summary (Full & Regular Part-Time) Approved Current Term 2018 2019 2020 Full Time Reg. Part-Time Total 103 _Q 103 106 0 106 109 _Q 109 Add 3 0 3 Approved 2021 Delete Total 0 112 0 _Q 0 112 Three additional firefighter positions added in 2021. These positions are for the new Seaton fire station that will be by early 2023. Year-Over-Year (Net Cost) Budget Changes 2020 Budget 2021 Approved Budget YearNear Increase ($) (%) Fire Protection $17,219,848 $17,658,307 $438,459 2.55 Emergency Operations 18,793 20,283 1,490 7 .93 ---~--------'--------'------Tot a I (Net Cost) $17,238,641 $17,678,590 $439,949 2.55 =="============----'=============== Explanation of Significant Budget Changes -Expenses • Salary and wages budget increase due to three additional firefighter positions added in 2021 for the new Seaton fire station, partially offset by salary savings from four mandatory firefighter retirements (age 60) with a potential for six more that are eligible with 30+ years in 2021 • The PPFA Collective Agreement expired at the end of 2018 and the anticipated Firefighters' salary increase is budgeted in the City's contingency account • Dispatch communications budget increase of $35,945 reflects increased operational costs for joint fire dispatch with Ajax Fire and Emergency Services • $10,000 added for specialized personal protective equipment (COVID-19) purchases 2020 Performance Indicators/Statistics Fire Prevention & Public Safety Vulnerable Occupancy Inspections (Legislated) 20 Complaint Inspections 136 Requested Inspections 365 Fire Investigations 30 Permits Reviewed 940 Public Fire Safety Education Events 63 105 F S ire uppress1on 0 f pera ions Fire/Smoke 350 Motor Vehicle Accidents 460 Medical Response 893 Rescue 25 Fire Alarm 318 Hazard (CO, wires down, gas leak, etc.) 233 Other (public assist, 911 unknown call, 329 etc.) Total Incidents 2,609 B "Id" UI mg an dF A ire t ppara us New Fire Headquarters designed and ✓ tendered for construction New Fire Tanker placed in service ✓ T .. rammg Officer Development Program Initiated ✓ Recruit firefighters trained (5 weeks) 3 E mergency M anagemen t Emergency Management and Civil ✓ Protection Act Compliant 2020 COVID Pandemic response coordination ✓ 106 Fire Services Department 2019 Actuals Expenditures 1100 Salaries & Wages 11,522,961 1200 Overtime 182,654 1400 Employer Contributions 3,115,036 1800 Conferences 3,023 1900 Uniforms 212,689 2110 Travel 2,213 2131 Cellular Phones 13,408 2140 Telephones 63,909 2142 Dispatch Communications 968,634 2210 Advertising 0 2220 Subscription & Publications 531 2340 Seminars & Education 114,000 2370 Insurance Premium 66,951 2371 Ins. Deductible 0 2392 Consulting & Professional 9,112 2394 Recpt, Prom & Sp Events 6,337 2395 Memberships 4,739 2396 Photo, Mapping, Printing 0 2399 Outside Agency Serv 22,737 2435 Build Repairs & Mtce 138,406 2457 Veh -Repairs & Maintenance 178,098 2478 Misc Equip Repairs 49,303 2479 Software/Hardware Maintenan< 0 5300 Stationery & Office Supplies 4,636 5302 Forms 402 5320 Program Supplies 16,517 5510 Utilities -Water 10,480 5520 Utilities -Gas 23,528 5530 Utilities -Hydro 46,518 5900 Gas, Oil Tires 88,558 5902 Supplies & Tools 40,170 5973 Minor Furniture & Fixtures 9,919 597 4 System & Software Upgrades 0 5975 Hardware Replacements 0 5978 Misc. Equipment 30,803 Total Expenditures 16,946,272 Revenues 1424 Sale of Services -Fire Prat. (96,582) City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 11,360,107 11,870,122 152,514 225,000 3,167,279 3,292,216 1,246 10,000 121,865 200,000 733 1,000 15,290 19,600 59,461 64,005 1,033,779 1,000,547 827 1,000 0 2,000 111,428 120,500 68,140 68,140 0 2,000 6,671 10,000 703 6,300 4,646 6,375 0 1,000 4,184 1,000 148,544 122,721 230,011 169,500 61,062 53,000 19,482 329 5,883 4,400 468 1,500 12,064 18,000 10,107 13,605 21,167 26,226 45,433 62,710 53,595 94,379 123,198 71,300 7,153 8,000 0 29,666 0 0 15,321 33,500 16,862,361 17,609,641 (106,655) (120,000) 107 Run Date: 4/21/21 3:46 PM 2021 INC.IDEC. Approved % CHGE. Budget 2020 384,032 12,254,154 3.24% (25,000) 200,000 (11.11%) 92,027 3,384,243 2.80% (10,000) 0 (100.00%) 0 200,000 0.00% 0 1,000 0.00% 0 19,600 0.00% (325) 63,680 (0.51%) 35,945 1,036,492 3.59% 0 1,000 0.00% 0 2,000 0.00% (5,500) 115,000 (4.56%) 1,360 69,500 2.00% 0 2,000 0.00% 5,000 15,000 50.00% (2,300) 4,000 (36.51%) 0 6,375 0.00% 0 1,000 0.00% 0 1,000 0.00% (28,000) 94,721 (22.82%) 0 169,500 0.00% 0 53,000 0.00% 20,431 20,760 6,210.03% 0 4,400 0.00% 0 1,500 0.00% 0 18,000 0.00% 245 13,850 1.80% 0 26,226 0.00% 0 62,710 0.00% 0 94,379 0.00% 7,700 79,000 10.80% 0 8,000 0.00% (26,666) 3,000 (89.89%) 20,200 20,200 0.00% (2,000) 31,500 (5.97%) 467,149 18,076,790 2.65% 0 (120,000) 0.00% Fire Services Department 2019 Actuals 1623 Ont. Specific Grants (20,148) 1640 Other Agency Grts (20,197) 9990 Other Revenue (609) 9965 Cost Recoveries (271,231) 9980 Sponsorships No Tax 0 9985 Marketing Sponsorships 0 Total Revenues (408,767) Transfers to/from Reserves & R.F. Total Transfers 0 Net 16,537,505 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget (8,395) 0 0 0 0 0 (263,386) (250,000) 0 (500) 0 (500) (378,436) (371,000) 0 0 16,483,925 17,238,641 108 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (27,200) (27,200) 0.00% 0 0 0.00% 0 0 0.00% 0 (250,000) 0.00% 0 (500) 0.00% 0 (500) 0.00% (27,200) (398,200) 7.33% 0 0 0.00% 439,949 17,678,590 2.55% 2240 Fire Protection 2019 Actuals Expenditures 1100 Salaries & Wages 11,369,603 1200 Overtime 182,654 1400 Employer Contributions 3,096,789 1800 Conferences 3,023 1900 Uniforms 212,689 2110 Travel 2,213 2131 Cellular Phones 12,802 2140 Telephones 62,451 2142 Dispatch Communications 968,634 2210 Advertising 0 2220 Subscription & Publications 531 2340 Seminars & Education 114,000 2370 Insurance Premium 66,292 2371 Ins. Deductible 0 2392 Consulting & Professional 9,112 2394 Recpt, Prom & Sp Events 5,893 2395 Memberships 4,739 2396 Photo, Mapping, Printing 0 2399 Outside Agency Serv 22,737 2435 Build Repairs & Mtce 138,406 2457 Veh -Repairs & Maintenance 178,098 2478 Misc Equip Repairs 49,303 2479 Software/Hardware Maintenam 0 5300 Stationery & Office Supplies 4,636 5302 Forms 402 5320 Program Supplies 16,517 5510 Utilities -Water 10,480 5520 Utilities -Gas 23,528 5530 Utilities -Hydro 46,518 5900 Gas, Oil Tires 88,558 5902 Supplies & Tools 40,170 5973 Minor Furniture & Fixtures 9,919 5974 System & Software Upgrades 0 5975 Hardware Replacements 0 5978 Misc. Equipment 30,803 Total Expenditures 16,771,500 Revenues 1424 Sale of Services -Fire Prot. (96,582) City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 11,201,045 11,742,814 152,514 225,000 3,148,077 3,260,735 1,246 8,500 121,865 200,000 733 1,000 14,797 18,800 58,189 62,125 1,033,779 1,000,547 827 1,000 0 2,000 111,428 119,000 67,470 67,470 0 2,000 6,671 10,000 703 5,500 4,646 6,050 0 500 4,184 1,000 148,544 122,721 230,011 169,500 61,062 52,500 19,268 0 5,689 4,000 468 1,500 12,064 18,000 10,107 13,605 21,167 26,226 45,433 62,710 53,595 94,379 123,198 70,500 7,153 8,000 0 29,666 0 0 15,321 33,500 16,681,254 17,440,848 (106,655) (120,000) 109 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 381,009 12,123,823 3.24% (25,000) 200,000 (11.11%) 91,361 3,352,096 2.80% (8,500) 0 (100.00%) 0 200,000 0.00% 0 1,000 0.00% 0 18,800 0.00% (325) 61,800 (0.52%) 35,945 1,036,492 3.59% 0 1,000 0.00% 0 2,000 0.00% (5,500) 113,500 (4.62%) 1,350 68,820 2.00% 0 2,000 0.00% 5,000 15,000 50.00% (2,000) 3,500 (36.36%) 0 6,050 0.00% 0 500 0.00% 0 1,000 0.00% (28,000) 94,721 (22.82%) 0 169,500 0.00% 0 52,500 0.00% 20,540 20,540 0.00% 0 4,000 0.00% 0 1,500 0.00% 0 18,000 0.00% 245 13,850 1.80% 0 26,226 0.00% 0 62,710 0.00% 0 94,379 0.00% 8,000 78,500 11.35% 0 8,000 0.00% (26,666) 3,000 (89.89%) 20,200 20,200 0.00% (2,000) 31,500 (5.97%) 465,659 17,906,507 2.67% 0 (120,000) 0.00% 2240 Fire Protection 2019 Actuals 1623 Ont. Specific Grants (20,148) 1640 Other Agency Grts (20,197) 9990 Other Revenue (609) 9965 Cost Recoveries (121,231) 9980 Sponsorships No Tax 0 9985 Marketing Sponsorships 0 Total Revenues (258,767) Transfers to/from Reserves & R.F. Total Transfers 0 Net 16,512,733 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget (8,395) 0 0 0 0 0 (113,386) (100,000) 0 (500) 0 (500) (228,436) (221,000) 0 0 16,452,818 17,219,848 110 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (27,200) (27,200) 0.00% 0 0 0.00% 0 0 0.00% 0 (100,000) 0.00% 0 (500) 0.00% 0 (500) 0.00% (27,200) (248,200) 12.31% 0 0 0.00% 438,459 17,658,307 2.55% 2241 Emergency Operations 2019 Actuals Expenditures 1100 Salaries & Wages 153,358 1400 Employer Contributions 18,247 1800 Conferences 0 2131 Cellular Phones 606 2140 Telephones 1,458 2340 Seminars & Education 0 2370 Insurance Premium 659 2394 Recpt, Prom & Sp Events 444 2395 Memberships 0 2396 Photo, Mapping, Printing 0 2478 Misc Equip Repairs 0 2479 Software/Hardware Maintenanc 0 5300 Stationery & Office Supplies 0 5902 Supplies & Tools 0 Total Expenditures 174,772 Revenues 9965 Cost Recoveries (150,000) Total Revenues (150,000) Transfers to/from Reserves & R.F. Total Transfers 0 Net 24,772 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 159,062 127,308 19,202 31,481 0 1,500 493 800 1,272 1,880 0 1,500 670 670 0 800 0 325 0 500 0 500 214 329 194 400 0 800 181,107 168,793 (150,000) (150,000) (150,000) (150,000) 0 0 31,107 18,793 1 1 1 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 3,023 130,331 2.37% 666 32,147 2.12% (1,500) 0 (100.00%) 0 800 0.00% 0 1,880 0.00% 0 1,500 0.00% 10 680 1.49% (300) 500 (37.50%) 0 325 0.00% 0 500 0.00% 0 500 0.00% (109) 220 (33.13%) 0 400 0.00% (300) 500 (37.50%) 1,490 170,283 0.88% 0 (150,000) 0.00% 0 (150,000) 0.00% 0 0 0.00% 1,490 20,283 7.93% 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. Human Resources Department \. I I I I I r Human Resources Employee Labour People & Services Relations Culture Key Activities for 2021 • Collective bargaining with 3 unions (PPFA, CUPE and Library) • Implementation of new Human Resources Information System including staff training on employee central (a self service module) • Select a consultant through a comprehensive RFP process for the creation of a Diversity & Inclusion Strategy with a multi-year focus and oversee the creation and implementation of the same • The creation of a comprehensive Terms & Conditions of Employment Policy for Non- union Employees which will include compensation structure and salary administration guidelines, benefits, hours of work and leaves 112 • Ongoing management of the staffing impacts resulting from the pandemic response plan including the management of existing work from home agreements and operational requirements • Review of the City's WSIB funding arrangement, in conjunction with Finance Financial Information Full Time Reg. Part-Time Total 2018 7 _Q 7 Staffing Summary (Full & Regular Part Time) Approved Current Term 2019 2020 8 _Q 8 10 _Q 10 Add 0 _Q 0 No additional staffing recommended for 2021. Year-Over-Year (Net Cost) Budget Changes Approved 2021 Delete 0 _Q 0 Total 10 0 10 2020 Budget 2021 Approved Budget YearNear Increase ($) (%) Human Resources $1,013,529 $1,100,364 $86,835 Health & Safety 145,245 148,194 2,949 8.57 2.03 7.75 Total (Net Cost) $1,158,774 $1,248,558 $89,784 =====~===='================== Explanation of Significant Budget Changes -Expenses $85,000 has been budgeted for the retention of services of a Diversity & Inclusion consultant to facilitate the completion of a Diversity & Inclusion (D&I) Strategy by conducting an unbiased third party review of the current state of diversity and inclusion within The Corporation of the City of Pickering and the Pickering Public Library. The framework of the D&I Strategy will include the development and implementation of diversity and inclusion practices, which will encompass a broad cross-section of activities, including, but not limited to: • Diversity and Inclusion in the Workplace policy; • employment opportunities, policies, and practices (recruitment, development, performance management, training, retention, and succession planning); · • programs and services (delivery and intake models); • community and civic engagement; • neighbourhood strengthening initiatives; 113 • planning and development of community designs and housing opportunities; • economic development programs and services. The D&I Strategy will identify recommendations to ensure all residents have access to City and PPL employment opportunities, programs, and services, and feel welcomed in Pickering. The D&I Strategy will assist us as an employer to identify gaps and implement initiatives to ensure our employees experience inclusion as well as demonstrate inclusive behaviors as we work together to serve the diverse needs of the Pickering community. 2020 Performance Indicators/Statistics Job Postings 52 New Employees Hired (excluding students) . 46 Rehires/transfers/promotions 136 Redeployments (due to COVID-19) 21 Student/mass hires 49 Retirements/resignations 38 Employees trained (various courses including Lockdown, Respect 743 in the Workplace, Health & Safety Orientation, Anti-Black Racism, Mental Health, Ladder Safety, WHIMIS) 114 Human Resources Department 2019 Actuals Expenditures 1100 Salaries & Wages 630,154 1200 Overtime 2,675 1400 Employer Contributions 185,236 1700 Employee Recognition & Appre 50,739 1800 Conferences 1,598 2110 Travel 156 2131 Cellular Phones 467 2140 Telephones 2,127 2210 Advertising 8,567 2340 Seminars & Education 45 2341 Corporate Training 28,721 2370 Insurance Premium 4,171 2392 Consulting & Professional 121,452 2394 Recpt, Prom & Sp Events 1,823 2395 Memberships 1,091 2479 Software/Hardware Maintenanc 34,908 5300 Stationery & Office Supplies 1,072 5380 Educational/Promotional Mater 1,026 5390 Workplace Accommodations 150 Total Expenditures 1,076,178 Revenues 9954 Netted Revenue 0 Total Revenues 0 Transfers to/from Reserves & R.F. 1920 Transfer to/(from) Reserve Fun (20,172) Total Transfers (20,172) Net 1,056,006 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 895,289 894,603 1,968 1,600 252,676 258,222 21,562 42,250 504 2,450 38 850 613 1,300 2,488 3,525 8,021 10,000 1,700 6,500 19,886 37,500 4,245 4,245 131,858 109,000 2,161 2,500 1,916 2,210 18,330 19,819 1,210 1,500 0 1,000 0 900 1,364,465 1,399,974 0 (213,700} 0 (213,700) (7,151) (27,500} (7,151) (27,500} 1,357,314 1,158,774 115 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 19,071 913,674 2.13% 0 1,600 0.00% 5,038 263,260 1.95% 0 42,250 0.00% 0 2,450 0.00% 0 850 0.00% 0 1,300 0.00% (110) 3,415 (3.12%) 0 10,000 0.00% 8,200 14,700 126.15% (4,500) 33,000 (12.00%) 85 4,330 2.00% 75,000 184,000 68.81% 0 2,500 0.00% 0 2,210 0.00% (902) 18,917 (4.55%) 0 1,500 0.00% 0 1,000 0.00% 0 900 0.00% 101,882 1,501,856 7.28% (16,598) (230,298) 7.77% (16,598) (230,298) 7.77% 4,500 (23,000) (16.36%) 4,500 (23,000) (16.36%) 89,784 1,248,558 7.75% 2139 Human Resources 2019 Actuals Expenditures 1100 Salaries & Wages 527,374 1200 Overtime 1,871 1400 Employer Contributions 146,615 1700 Employee Recognition & Appre 50,739 1800 Conferences 1,598 2110 Travel 156 2131 Cellular Phones 467 2140 Telephones 1,862 2210 Advertising 8,567 2340 Seminars & Education 45 2341 Corporate Training 8,548 2370 Insurance Premium 3,442 2392 Consulting & Professional 121,452 2394 Recpt, Prom & Sp Events 1,823 2395 Memberships 951 2479 Software/Hardware Maintenanc 31,542 5300 Stationery & Office Supplies 1,072 Total Expenditures 908,124 Revenues 9954 Netted Revenue 0 Total Revenues 0 Transfers to/from Reserves & R.F. Total Transfers 0 Net 908,124 City of Pickering 2021 C1ment Budget Approved Final 2020 2020 YTD Approved Actuals Budget 794,225 790,647 1,427 1,000 223,406 228,757 21,562 42,250 504 1,800 38 300 613 1,300 2,239 3,175 8,021 10,000 1,700 6,000 12,734 10,000 3,505 3,505 131,858 109,000 2,161 2,500 1,776 1,740 14,867 14,055 1,095 1,200 1,221,731 1,227,229 0 (213,700) 0 (213,700) 0 0 1,221,731 1,013,529 116 Run Date: 4/21/21 3:54 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 16,544 807,191 2.09% 0 1,000 0.00% 4,547 233,304 1.99% 0 42,250 0.00% 0 1,800 0.00% 0 300 0.00% 0 1,300 0.00% (105) 3,070 (3.31%) 0 10,000 0.00% 8,200 14,200 136.67% 0 10,000 0.00% 65 3,570 1.85% 75,000 184,000 68.81% IQ 2,500 0.00% - 0 1,740 0.00% (818) 13,237 (5.82%) 0 1,200 0.00% 103,433 1,330,662 8.43% (16,598) (230,298) 7.77% (16,598) (230,298) 7.77% 0 0 0.00% 86,835 1,100,364 8.57% 2141 Health & Safety 2019 Actuals Expenditures 1100 Salaries & Wages 102,780 1200 Overtime 804 1400 Employer Contributions 38,621 1800 Conferences 0 2110 Travel 0 2140 Telephones 265 2340 Seminars & Education 0 2341 Corporate Training 20,173 2370 Insurance Premium 729 2395 Memberships 140 2479 Software/Hardware Maintenan< 3,366 5300 Stationery· & Office Supplies 0 5380 Educational/Promotional Mater 1,026 5390 Workplace Accommodations 150 Total Expenditures 168,054 Revenues Total Revenues 0 Transfers to/from Reserves & R.F. 1920 Transfer to/(from) Reserve Fun (20,172) Total Transfers (20,172) Net 147,882 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 101,064 103,956 541 600 29,270 29,465 0 650 0 550 249 350 0 500 7,152 27,500 740 740 140 470 3,463 5,764 115 300 0 1,000 0 900 142,734 172,745 0 0 (7,151) (27,500) (7,151) (27,500) 135,583 145,245 117 Run Date: 4/21/21 3:54 PM 2021 INC.IDEC. Approved % CHGE. Budget 2020 2,527 106,483 2.43% 0 600 0.00% 491 29,956 1.67% 0 650 0.00% 0 550 0.00% (5) 345 (1.43%) 0 500 0.00% (4,500) 23,000 (16.36%) 20 760 2.70% 0 470 0.00% (84) 5,680 (1.46%) 0 300 0.00% 0 1,000 0.00% 0 900 0.00% {1,551) 171,194 (0.90%) 0 0 0.00% 4,500 (23,000) (16.36%) 4,500 (23,000) (16.36%) 2,949 148,194 2.03% Pickering Public Library Overview The Pickering Public Library is responsible for ensuring that all Pickering·residents have equitable access to resources, information and ideas that will enrich their personal, civic and corporate lives. Pickering Public Library [ Public Services J [ Support Services l The Pickering Public Library offers access to free spaces, programs, collections and other services that support the following ends: • Residents will be enriched by a culture of reading. • Residents will be supported in their lifelong learning needs at all ages and stages. • Residents will have access to welcoming public facilities where the entire community can read, connect, collaborate,,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. Key Activities for 2021 • Development of an outreach.vehicle program to serve new communities • Community engagement project connected to the services and spaces in the City Centre, Pickering Heritage & Community Centre, and George Ashe Libraries • Pilot a volunteer-supported delivery service for homebound seniors • Develop innovation plans for City Centre Library and Pickering Heritage & Community Centre • Action recommendations provided by Pickering Public Library's Anti-Black Racism Working Group • Implement enhanced outcomes-based evaluation framework for library programs 118 • Continued improvement of virtual programming through design thinking and prototyping • Implement curated book collections for children, teens and adults • Pilot extended service model at the Claremont Library • Develop programs and schematic concepts for the future Seaton Library Financial Information Staffing Summary (Full & Regular Part-Time) Approved Current Term 2019 2020 A ,pprove d 2021 2018 38 26 64 Add Delete Total Full Time Reg. Part-Time Total 37 25 63 36 24 60 1 Q 1 0 37 -2 22 -2 59 The proposed staffing complement in 2021 would eliminate a part-time Marketing Assistant role and add a full-time Marketing and Community Engagement role. This deferential will be funded by the elimination of a part-time, public service role. The new role will be responsible for supporting marketing and communications work and· community engagemen·t projects and programs. Year-Over-Year (Net Cost) Budget Changes 2020 Budget 2021 Approved Budget YearNear Increase ($) (%) Libraries $5,773,179 $5,834,310 $61,131 1.06 1.06 Total (Net Cost) $5,773,179 $5,834,310 $61,131 =~=========='===========~====== Explanation of Significant Budget Changes -Expenditures • Overall, the Library's 2021 budgeted expenditures deceased by 0.58% ($34,869) from the previous year. This change was driven by the following: o iI $37,000 to support increased use of digital collections and online learning platforms by library clients o iI $30,000 to upgrade security software and support virtual programming o iI $23,000 for City chargebacks related to diversity and inclusion consulting and staffing resources o iI $17,000 for enhanced cleaning procedures during the pandemic o ,0., $130,000 in salaries and wages due to pandemic conditions 11 9 Explanation of Significant Budget Changes -Revenues/ (Transfer from Reserves) o -0-$68,000 in fines and room rental revenues related to pandemic conditions o is $37,000 in reserve transfer 2020 Performance Indicators/Statistics Annual Per Capita (pop: 100,000) or % of Population Active cardholders 37,583 38% of total population Internet sessions accessed 624,637 6.2 per capita Total materials borrowed 496,445 5.0 per capita Website visits 246,397 2.5 per capita In-person visits 145,497 1.5 per capita Public Printing/ Copying (pages) 144,503 1.4 per capita Total digital learning sessions 108,298 1.1 per capita Program attendance 5,720 0.06 per capita Number of programs 483 120 Library 2019 Actuals Expenditures 1100 Salaries & Wages 3,580,858 1200 Overtime 1,736 1400 Employer Contributions 926,907 1700 Employee Recognition & Appre 3,535 1800 Conferences 8,694 1900 Uniforms 2,117 2110 Travel 6,341 2121 Postage 3,505 2122 Freight, Express & Cartage 1,427 2131 Cellular Phones 7,997 2140 Telephones 52,266 2210 Advertising 18,182 2320 Legal Services 11,426 2340 Seminars & Education 22,475 2365 Purch Prnting/Broch/News Ur 5,389 2370 Insurance Premium 23,918 2371 Ins. Deductible 0 2392 Consulting & Professional 17,108 2394 Recpt, Prom & Sp Events 10,910 2395 Memberships 7,482 2399 Outside Agency Serv 40,343 2435 Build Repairs & Mtce 254,401 2457 Veh -Repairs & Maintenance 685 2478 Misc Equip Repairs 38,316 2479 Software/Hardware Maintenanc 132,198 5300 Stationery & Office Supplies 19,124 5303 Catalogue Processing Supp 5,512 5310 Lib Materials 262,455 5320 Program Supplies 34,550 5510 Utilities -Water 15,374 5520 Utilities -Gas 31,741 5530 Utilities -Hydro 170,070 5900 Gas, Oil Tires 1,639 5902 Supplies & Tools 3,863 5973 Minor Furniture & Fixtures 3,509 5974 System & Software Upgrades 40,704 5975 Hardware Replacements 18,036 Total Expenditures 5,784,793 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget 3,154,486 3,461,809 480 0 862,752 914,436 2,810 3,000 4,971 6,500 617 2,300 1,413 6,000 1,170 3,800 310 1,000 9,438 11,000 50,153 57,276 13,303 14,000 0 0 29,316 16,900 2,079 9,000 24,345 24,345 0 2,000 27,151 31,850 1,928 9,000 7,388 7,500 42,287 274,760 205,757 260,389 572 2,000 25,091 43,250 191,559 187,841 10,508 19,000 2,841 5,000 288,246 273,290 20,332 35,750 14,683 17,940 27,090 34,461 153,069 189,000 2,775 2,132 5,230 3,500 415 5,000 0 0 59,205 46,075 5,243,770 5,981,104 121 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 (130,134) 3,331,675 (3.76%) 0 0 0.00% (16,422) 898,014 (1.80%) 0 3,000 0.00% (3,000) 3,500 (46.15%) 0 2,300 0.00% (2,000) 4,000 (33.33%) (500) 3,300 (13.16%) 0 1,000 0.00% 8,238 19,238 74.89% 5,814 63,090 10.15% (4,000) 10,000 (28.57%) 0 0 0.00% 12,500 29,400 73.96% (4,000) 5,000 (44.44%) 485 24,830 1.99% 0 2,000 0.00% (11,350) 20,500 (35.64%) (2,000) 7,000 (22.22%) 0 7,500 0.00% 23,274 298,034 8.47% 17,357 277,746 6.67% 0 2,000 0.00% (4,000) 39,250 (9.25%) 29,809 217,650 15.87% 0 19,000 0.00% 0 5,000 0.00% 36,700 309,990 13.43% (9,000) 26,750 (25.17%) 360 18,300 2.01% 0 34,461 0.00% 0 189,000 0.00% 0 2,132 0.00% 0 3,500 0.00% 5,000 10,000 100.00% 0 0 0.00% 12,000 58;075 26.04% (34,869) 5,946,235 (0.58%) Library 2019 Actuals Revenues 1529 Fines -Library Matis. (64,408) 1580 Misc. -Photocopies Lib. (44,411) 1592 Donations (6,168) 1610 Federal Grant (6,728) 1623 Ont. Specific Grants (135,345) 9916 Vending Machines (2,175) 9933 Rentals -Mtg. Room/Public (4,532) 9990 Other Misc Revenue (9,067) Total Revenues (272,834) Transfers to/from Reserves & R.F. 1910 Transfer to/(from) Reserve 80,000 Total Transfers 80,000 Net 5,591,959 City of Pickering 2021 Current Budget Approved Final 2020 2020 YTD Approved Actuals Budget (18,356) (80,000) (13,409) (52,000) (5,051) (16,000) (27,136) 0 (136,689) (106,425) (848) (2,500) (830) (8,000) (2,323) (6,000) (204,642) (270,925) 100,000 63,000 100,000 63,000 5,139,128 5,773,179 122 Run Date: 4/21/21 3:46 PM 2021 INC./DEC. Approved % CHGE. Budget 2020 60,000 (20,000) (75.00%) 0 (52,000) 0.00% (9,000) (25,000) 56.25% 0 0 0.00% 0 (106,425) 0.00% b (2,500) 0.00% 8,000 0 (100.00%) 0 (6,000) 0.00% 59,000 (211,925) (21.78%) 37,000 100,000 58.73% 37,000 100,000 58.73% 61,131 5,834,310 1.06% Maturity Date Projects City of Pickering 2021 Outstanding Debt Summary 2021 Liverpool Rd Nautical Village Blvd & Streetscape Liverpool Road -Road Works, Storm Sewer, Street Lighting 2021 and Boulevard Reconstruction, and Wharf Street Sidewalk Installation 2021 Stormwater Management Facility# 4 and related storm sewer cc 2021 Roof Reinforcement at East Shore Community Centre 2021 Supply & Delivery of One Articulating Front End Loader 2021 Supply & Delivery of Seven Fire Vehicles Replacement 2022 Expansion and Renovations of the Don Beer Arena (Refunding debentures of 2002 debt in 2012) 2022 Roof Replacements at the Don Beer Arena Rink 1 2022 Browning Ave Storm Sewer Replacement 2022 Supply and Delivery of Sweeper 2022 Frenchman's Bay Harbour Entrance 2022 Petticoat Creek Library Reading Garden Enclosure 2022 PCL Makerspace 2022 Highway 401 Notion Rd Crossing 2023 Banquet Hall and Washroom Renovations 3 Liverpool Road Reconstruction and Minor Storm Sewer Repair 202 from Ilona Park Road to krosno Boulevard 2023 Fire -One new 55 Foot Aerial Quint Fire Truck 2023 Don Beer Arena-Ice Rink 2 Renovations 2023 Pickering Recreation Complex Doubles Squash Court and 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 2025 Conbination Barn Restoration at the Pickering Museum Village 2025 Squires Beach Rd. From McKay to Clements Rd 2026 Urbanization of Third Concession Road and Brock Road to CPR underpass (BR-1) & (DH-15) 2026 Southview Drive -Road Reconstruction & Urbanization 2026 Westshore Neighbourhood-Flood Remediation, Breezy & Vistula Roads Reconstruction 2026 Fire -One 2013 Smeal Heavy Duty Aerial Ladder 2026 Pool Deck Repairs at Dunbarton Indoor Pool 2026 Don Beer Arena Roof Replacement 2027 AIP: Sixth Concession Rd -Road Reconstruction and Storm Sewer Replacement, Greenwood Road to Westney Road 135 Borrowed Outstanding Committed Principal Amount ($) Balance-2020 ($) 700,000 64,922 320,000 35,000 2,000,000 223,000 150,000 17,000 180,000 36,973 190,000 39,027 1,057,000 233,000 420,000 94,000 174,000 72,226 250,000 103,774 1,500,000 241,268 112,000 41,634 100,000 41,363 486,000 486,000 490,000 161,034 495,000 162,677 680,000 223,476 263,000 161,627 833,000 511,922 367,000 225,541 200,000 122,910 369,000 294,000 191,000 191,000 360,000 64,342 1,340,000 603,000 660,000 407,577 815,000 503,295 1,020,000 629,891 899,000 555,169 460,000 284,069 1,540,000 1,114,667 Maturity Date Projects City of Pickering 2021 Outstanding Debt Summary 2027 AIP Consulting Services for Sandy Beach Road Reconstruction 2027 SCBA Replacement -Breathing Apparatus 2028 Fire -One Fire Pumper Tanker 2029 Indoor Soccer Facility 2029 Westney Road -Road Reconstruction 2029 Salem Road -Road Reconstruction 2029 Brock Ridge Community Park and S.M.Woodsmere Park- Baseball Diamond Improvements Project 2029 Centennial Park Baseball Diamond Reconstruction Project 2030 Purchase of land for Seaton North Fire Station 2031 Delaney Arena Improvements at the Pickering Recreation Complex 2032 Pickering Civic Complex Roof Repairs 2032 Pickering Recreation Complex Roof Repairs 2033 Abbott Crescent Stormwater Management Pond- Reconstruction 2034 Whitevale Bridge 2037 New Operations Centre 2038 Conservation Barn Reconstruction at the Pickering Museum Village 2039 Pickering Recreation Complex Roof & Skylight Rehabilitation Program Total "Issued" Debt Commitments-Dec. 31, 2020 Borrowed Committed Amount ($) 300,000 288,000 749,000 3,734,000 1,496,000 700,000 919,000 357,000 1,856,000 2,249,000 520,000 550,000 342,000 1,400,000 9,907,000 850,000 690,000 45,528,000 The City has paid 32.84% of the original borrowed amount. Outstanding Principal Balance-2020 ($) 218,056 173,385 614,000 2 2,440,000 1,372,770 642,338 843,300 327,593 1,856,000 1,704,000 429,543 454,324 304,000 1,074,000 3 8,735,000 784,000 658,000 30,575,692 Please note that the Combination Barn and Conservation Barn are two different buildings. Loan & External Debt Approved in Prior Years' Capital Budget-Still to be issued 4 External Debt To be Issued by the Region 2031 FS# 5 Replacement -Design 2031 Backup Generator Replacement-Rec Complex 2031 Westney Road -Full Road Reconstruction (From Concession 8 to Concession 9). 2031 Backup Generator Replacement 2031 Tennis Court Flooring Replacement 2036 Fire Pumper Rescue Replacement 2041 Michell Bridge -Rehabilitation 2041 FS#1 New Fire Station & HQ (Seaton) 2041 Lobby & Core Area Renovations Sub-total Debt to be Issued 2021 New Debt (To be Approved by Council) New Debentures New Internal Loans 136 465,000 1,100,000 300,000 800,000 600,000 1,000,000 850,000 2,767,180 5,600,000 13,482,180 11,391,900 1,607,500 Maturity City of Pickering 2021 Outstanding Debt Summary Date Projects Sub-total 2021 Debt Note: 1 Funded from Duffin Heights Reserve 2 Funded from contribution from the Pickering Soccer Club 3 Funded from Development Charges Reserve Fund 137 Borrowed Committed Amount ($) Outstanding Principal Balance-2020 ($) 12,999,400 ..... CA) 00 S1.UnafProjcc:t1d Surnof2021Toul S1a101202.1Tocai Bal.lnc.D,c31,2020 PIOJlldN PlannedDrawa Reaarve ar RNwva Puftd o,nc11 Co.utbuUOM ~Nia'#!!: Sum ar Proj,cl,d s.n Gf' 2022 Total Bal.Inc, D•c 31 , 2021 PreJ•ded c,nc11 Con ullQn• SWD of 2022 Total PlaMKDrawa 1oumowa• City of Pickering Reserves :i.nd Reserve Funds Bal.ince Preliminary Forecast 2021 -2025 sum al ProJ,ct,d Sum of:lOll Total 8'l2nc:, DK 31, 2022 Proj9c&H p,nclt Ca"trtbu~• SWtlof21lU Total PllnnedDr&WI 9- Sum ar Proj,ctcd Sum 012.024 Total Sum of20Z4 Total B.al2nc•Dec31,2023 PlannadDraw. Projedd c,ncll\ OutftaWII u- SumafPraJectad SVmof2021Total B21.1naDcc31,2024 PiaMNDrawl o,nc:111 OUfflDllil!"._•l Sl.lm11f2021Tatat Pro)eckd Contribution, SumarPraj,ct,d 8.al2nce:Dac31,2025 fDanclll _WorkinqC:ipibl I 40000()-j O I O I 400000 '1 o I O I -400000 I o l O I 400000 I o I O l 400000 I o_J ___ o I_ _______ ~_.QQ_O_. 769195 0 54 354595·· 0 63400 49.CO O O 49.C O O O .CSI.COS 6525514 0 &1193514 0 7 580119.c O 7 S433!M 7 0 0 "168394 121 652594 0 S5 715 0 0 '55'2715 0 0 715 0 0 0 652715 8754U O O 87541115 0 0 6754!1II o 0 6754!16 0 0 0 ~~- Salflnsurnnce 677 842 0 r:200000 477 842 0 0 •776'2 o 0 .C77842 0 0 .C77M2 0 o .ens.a R:i!aSl:lbl!luitlon 17065000 0 587500 11 190 000 0 41'174001 7002600 1000000 1500000 6.502600 1500000 1000000 &002 800 1 1000000 5502500 Srchm-Pro ram:i 375152 18 500 0 393752 18500 0 .C12152 18500 0 .C3075'2 0 18500 ~11152 0 18500 467751 Srchm..Dunbnr1ol'!Pool 30235 5000 0 35235 5000 1'20 20235 5000 1'25000 135 0 5000 5235 0 5000 10 35 Srchm-OnBoorAron:i 101979 30000 40000 91979 30000 0 121979 30000 0 151979 0 30000 1!1197SI O 30000 11 Sl79 s1chm.Rnc Cm Ix Coro 2 883 27 ooo o 29 883 27 000 o 58 !183 27 000 so oom 33 1983 o 27 ooo 60 1983 40 ooo 27 ooo 47 883 _S rchrg_.RacCm lxPool 151111 15000 130 1111 15000 0 15 111 15000 0 30181 0 15000 45161 0 15000 60161 Srchr .RacCm lxAron:i 60034 20000 0 80034 20000 100000 34 20000 0 2003' 0 20000 40034 45000 20000 15034 Eo:amonl 390 0 0 390 0 0 390 0 0 3SIO 0 0 3SIO 0 0 3SIO SutanOoYROYIDw 1101344 0 405 119575' 0 51121 4'46'3 0 51121 1Sl35l2 o O 193 0 0 193522 Acca:!llblll lnltlollvos 32944 5 000 0 37 4 5 000 0 4 944 5000 0 479-44 0 5000 52SI.« 0 5000 S?SI.« Su:t:11n■b1o1n1tllltlvot, 340455 40000 0 3110455 40000 0 420-tSS 40000 0 460455 0 40000 500455 0 40000 SC0455 Fa cUitlo!I 548162 400000 5000 M1152 0 0 11811111 400000 0 1261162 0 400000 1681152 0 400000 20611'51 Acelnfra:,Pr r.11m 51SISOO O O 519 0 0 51Sl500 0 0 519500 0 0 51Sl500 0 0 519 00 MlnorBulldlnsR,tcm 1 100000 400000 0 1500000 400 000 0 1900000 400000 0 ,00000 0 400000 2700000 0 400000 3100000 2-'7H:177 15130,. 735'310 19026091 1150600 6230021 1-'3ll65'10 15110500 11113121 14462_.., 16371500 1110600 141711_..I 1'221500 1 !9101500 15213,'-'' Contln qoncy-Eloctlon OCClty'sShllre CcnllnulngS!ud!u VahlclnRoplacam,nt UlndPurchuo FlnoncllllSY;IDms SanlorCantr, wtntorC<lntral Oufflns Halg hts PropertyFancallna TrttReptacamanl Tennis Court MnlarEqulpmant MusoumCollactlor, Eh:ldOfflclol:iLllolnsurancn Racm1UOfl Compla>: ~-rv AnlmlllShallar Comm . Foel!ltlu Capll:IIWorlts WS!B Exco',s lndomnll'f WS18 Man , Slow PIich Opon:itlon,Ctr Ro:id!l&Brtdgas .$!Ol'!!~•·.a!D~ OC!FGr:int ~structure Sa:i!onFIA ~· 10093-101 ~ ~ _'.I~~ ~ 2,!QQJ!Qg_ 1!JQ.!IQ<>_ 19727&15 ~ .!!Y21 1152000 ~ .!Q.QQQ. ~ ~ 200000 20HOH5 ~ .ID.Jlfil 3011130 · • 000 000 .!MQ_ 9 000000 3355977 ~t ~ ~ ~7 ..... ~15_ 23212,'70 70000 3000000 .1QQ.QQQ_ 1 500000 !!. ~ B!Q.QQQ_ !!. __ o _21Q_,QQQ_ ,00000 1000000 ...1.QQQ. 1.Q.QQ.Q. ~ _1.QQ.Q!!:Q. 100 000 1.,!11,000 = MM .2Qfil. ~ ~ 1&QQ.QQQ. 1QQ..QQQ_ ~ ~ 611,11_7 ~ 1811 500 f2~4' f7!.5Q!!; !!. __ o (229~ ...J!.M2l'l 1345000] 500001 15'267751 '90000' (1~ ~ __ o _14~7851 ~ _'.11281901 7~ 1~ ~ ~311011 21100000 700000 17.C3425 ~ !!. 12515,325 !QLQ!!Q_ 4~ ~ ~ ~ 250000 22H521C ~ ~ M!J.!!· ~~ lQQ.Q:QQ.· 1.a!,· 9050000 41115977 3118207,· !£ill 3!i2 3A3 = ~~- 70000 3.QQQ..QQQ. 1QQ.QQQ_ .1._SQ_O....QQQ. fil..QQQ. ~ ,00000 1 000000 ~ 7.Q.QQQ. ~ .!QQ.QQQ. 50000 745]000 = _Si11.I9_ ~ ~ ..!!. ~ 1600000 B!Q.!1QQ_ ~ ~ = 4,j_U,OH ___,filQ.QQg; (2852960' f2.QQ..QQg 1255000' !!. __ o m~ (?15000 1070000 C282301 !..Q:11 1QQ,.QQQ, !!. 12150000' '1 133000' f3~ 1'7~ 2110426 11428Sl41 f2~_ 2162341 1_4,403 SM11iii 3 500000 700000 151.COIU ~ 1441325 .ill.QQQ_ ~ ~ ~ ~ 300000 2404:1915 ~ ,LO.All 313!129 " 4~ _4~ .!!l. 9110000 311 15977 ~ ~ filiill ~7) 2105742T Piirldand 1 010•03 · 571709 4180000 34152112 5013n '1045 30111.c89 F~GasTu 358 732 • 2962760 61177 933717 297913SI •557000 13551155 Bulldln Pormlt 000 0 0 0 000 000 0 0 000 000' CommunlryBona~t Ch:irg, I I (200174117}1 f20017411TII I (1 982393 (2 19998110' Dovalopm,nl Chargn •Soa following p;i;oforDCRa~arvaFundB11l11neo:i 7553135 ·1u21c5a (1~ 20c2s5n Re,;crvas :ind Ruorvo Funds Tab! 11,1rufil 11 101 121 I f43M75153\I 60131143 j j_l5_.I_~!.!!J!!] 12101t11So1I 31131311 I Note 1 -The above table does not in clude the C3slno Resetve 70000 3000000 lQ0,000 1.500~ ~ 1l!<!J>(l<l_ 400000 1 000000 ..1.QQQ. 1Q.QQQ. ~ .1.QQ..QQ!?. 50000 1.MM_00 ~ _5L9_trr ~ 1Q.QQQ. 3QQ.QQ.0 10 1600000 1QQ.QQQ_ 107473 2 500000 .M!1,!SS 5965911 3082018 1..!Z.!M4 U711J73j (2980524' f2.Q.Q.Q.00 '1 035000' !!. __ o ~ ~.!!!.!!!!!! !!. 0 ~ 150,48'15 filk 1-JQMOO' !!! '""' ~ __ o '1132117490' _C7 2'01.CS (77Mtl31\I ~ 114.C8417 f2.MQ! 262.7341 ~ ,.,.,. 4200000 700000 1,254743 _m.QQQ_ 1541325 1287000 _II~ ~ ~ ~ 350 000 1!,!10,050 ~- ~ 3 18537" 41!10000 , _69()_,QQ.Q, j.72: 91!10000 3140977 mm. ML!!.l !2!!21. 11n6S3 3115087'. ~- ~ '85287 371 M~O_r:t f200JIS111JI ~ ~_QQ_ 1 255000' 0 ~_QQ_ 5.!L!!! (300000' C2 625000' 1 095000' 0 ~ ~HS] ~ _____(M_R0001 __ o '531 3804' f2351551110\I 70000 3 000000 l.Q.Q.Q.QQ. 1500000 !!. m.QQ!!. 1!JQ.!IQ<>_ !!. __ o lIQ__,QQQ_ ,00000 1000000 ...1.QQQ. .!Q.QQ.Q. ~ 1.QQ.QQ!2. 50000 75'1000 = !.!!l! ~ !Q.QQQ. lQQ.QQQ. ~ !Q.Q!!Q. 1600000 1QQ,QQQ_ ~ ~ 1.4.QQ.QQQ_ "''" 3125753 _3,C9C_,_1J.I_ 177012!1j 420425"' _9~ t2.Mfil 2 en341 ~ 1118110!1 ~®Q_ 700000 1 OSS402 ~ !!. 2241325 ~QQQ_ ~ = ~ ~ ~ n•r:i as, 794~· . 3!1083,.. ~'.I _ .. ~ ~ .Lill. 8SIIIOOOO 2115,977 177!1707 1003461 7117Se ~ 3 1354'2 ~ QOOOOOO' 190J;__Q1__,IB 151141753 [212178'3)! '3813100) ~.0001 '1235000] 0 m~ ~ (1~ m!J..! (550000' ___!MR 3117000 (!3'11315)1 70000 3000000 1QQ.QQQ. 1500 000 .!lli!!Q. _?.QQ.QQQ_ ~ !!. ~ 1.QQQ.QQQ. ....!.QQQ. 1Q..QQQ_ ~ .1QQ.QQQ_ 50000 L_l5_C1,_0_0~ = •e. 2.l!!!!. !Q.QQQ. lQQ.QQQ. " ~ 1 600000 ~ ~ 106057 1400000 ~ 3 125 753 17721C03 j 490426' 8352457 _R3_A!l_! ~ ~ '"'"" !61l0000 .!!!!l.!!!!!! ~ 1!.QJ!QQ.. lS-41325 1777000 -~ ~io...QQQ. ~~ .C50000 -~~ 1 094,58" ~ 328!137 ·1 ~~000_ '""'000 2190,977 · 17211707 · 1019 0 11 · .!11.!!1 jl_ll_SI_A33 31551116 ~ 13 000000' t90~4 ~-2£3-~ (17927895)1 _. w co Attachment #1 to Report #FIN 06-20 City of Pickering Pre-Audit 2019 Statement of the Treasurer -Development Charges (DC) Reserve Fund for the Year Ended December 31, 2019 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 Parks & Library: Services Transportation Related to a Mgmt Studies Recreation Facilities & Total Description Hiahwav ,. $ $ $ $ $ $ $ $ Opening Balance, January 1, 2019 2,225,617 27,702,614 82,198 3,154,525 (184,512) 21,805,122 4,003,852 58,789,415 Plus: Development Charges Collections 743,641 2,108,082 363,688 236,843 231,723 3,031,479 671,088 7,386,544 Interest Income-Internal Investment 1,859 23,138 69 2,635 0 18,213 3,344 49,257 Interest Income -External Investment 48,321 601,455 1,785 68,488 0 473,414 86,928 1,280,391 Less Admin Fee (2,315) (28,813) (85) (3,281) 0 (22,679) · (4,164) (61,338) Sub-Total 791,505 2,703,863 365,456 304,685 231,723 3,500,426 757,196 8,654,854 Less: 2019 Transfer to Capital Funds 1 (866,883) (964,083) (667,843) (810,306) (350,865) (217,449) (3,877,428) 2019 Transfer to Current Funds-1 0 0 (412,389) 4 0 (292,539) (263,659) 4 0 (968,586) Sub-Total 2019 (866,883) (964,083) (1,080,232) o 0 (1,102,844) (614,524) (217,449) (4,846,014) Opr Ctr Debt Chrgs-Adjustment to 2018 Transfer to Current Funds, allocate 39% from "Other Services Related to a Highway'1 to 11Parks & Recreation" 262,043 5 (262,043) 5 0 Sub-Total (866,883) (964,083) (818,189) 0 (1,102,844) (876,567) (217,449) (4,846,014) Closing Balance, December 31, 2019 before Budget Commitments 2,150,240 29,442,394 (370,535) 3,459,209 (1,055,633) 24,428,981 4,543,599 62,598,255 Less Budget Co~mitments 2 (2,208,950) (4,868,847) 0 (3,632,977) (1,568,231) (2,410,659) (270,443) (14,960,108) Less New Operations Ctr Debt Charges Commitment 2020-2037 0 0 (7,457' 052) 3 0 0 (4,727,795) 3 0 (12,184,847) Sub-Total (2,208,950) (4,868,847) /7,457,052) (3,632,977) (1,568,231) (7,138,455) (270,443) (27,144,954) Closing Balance, December 31, 2019 after Budget Commitments-(Deficit) (58,711) 24,573,547 (7,827,587) 1,250,259 (2,623,864) 17,290,527 4,273,156 35,453,301 Notes: 1• See Attachment 2 for details 2. Budget commitments include capital projects previously approved, but have not proceeded or still ongoing. 2019 & Prior Commitments 3• New Operations Ctr outstanding debt charges from 2020-2037. Total amount owing $12,184,847, allocated in the ratio of 61 % "Other Services Related to a Highway'' and 39% "Parks & Recreation" •· New Operations ctr DC debt charges-2019 payment of $676,048, allocated 61 % to "Other Services Related to a Highway" $412,389 and 39% $263,659 to "Parks & Recreations" 5• Adjustment to 2018 debt charges, on which 100% was allocated to "Other Services related to Highway". Per 2018 DC Study: 61 % to "Other Services Related to a Highway" and 39% to "Parks & Recreation" 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 C/iarges Act or another Act.