Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2023 Approved Current Budget Summary
City of Pickering 2023 Approved Current Budget Summary Table of Contents Department Budget Summaries Office of the Chief Administrative Officer Office of the CAO-Ad min 10000 Customer Care Centre 10005 Public Affairs & Corp. Comm. 10010 Corporate Initiatives Economic Development Economic Development & Strategic Projects 10050 City Development City Development-Admin 10100 Planning & Design 10105 Building Services 10110 Sustainability 10115 Committee of Adjustment 10120 Heritage Pickering 10125 Community Services Cultu re & Recreation -Admin 10200 Programs 10205 Dunbarton Pool 10210 Don Beer Arena 10215 Community Centres 10220 Recreation Complex-Central Core 10225 Recreation Complex-Pool 10230 Recreation Complex-Arenas 10235 Civic Centre 10240 Senior Citizens Centre 10245 Museum 10250 Operations Public Works -Admin 10300 Property Maintenance 10305 Fleet Services 10310 Roads 10315 Parks 10320 Operations -Services 10325 Major Capital Facilities 10330 Page 1 13 24 26 27 29 32 37 39 49 50 52 54 56 57 58 73 75 77 78 80 82 84 85 87 88 90 92 106 108 110 112 114 116 118 City of Pickering 2023 Approved Current Budget Summary Table of Contents Corporate Services Legal Services 10400 Information Technology 10405 Clerks Office 10410 Records Management & Elections 10415 Print Shop/ Mail Room 10420 By -Law 10425 Animal Services 10430 Engineering Services Engineering Services-Admin 10500 Crossing Guards 10505 Water Resources & Development Services 10510 Sidewalks 10515 Streetlights 10520 Finance Finance 10600 Supply & Services 10605 Fire Services Fire Protection 10700 Emergency Operations 10705 Human Resources Human Resources 10800 Health & Safety 10805 Libraries Library 10900 General Government 119 127 129 131 132 133 134 135 137 144 146 147 149 150 151 159 161 162 168 170 171 176 177 178 183 185 City of Pickering 2023 Approved Current Budget Reconciliation Draft 2023 Current Budget as Submitted to Executive Committee on April 13, 2023 Executive Committee Changes: Increase: -Grant to Claremont Lions Club 11100.503050 -Grant to Orchard Villa Families 11100.503050 Decrease: -Community Grants Contingency 11100.503040 Draft 2023 Current Budget after Executive Committee Changes Report to Council Budget Changes: Increase: -Building Maintenance costs, 10405.502340 Information Technology -General Government Consulting for 11100.502230 Petticoat Creek business case analysist -Transfer from Rate Stabilization 11100.408007 Reserve for business case -Grant to Pickering Canadian 11100.503050 Caribbean Cultural Association Decrease: -General Government Contingency 11100.503500 -Community Grants Contingency 11100.503040 Approved 2023 Current Budget 2 $82, 162,832 $336 $1,000 ($1,336) $82,162,832 $37,000 $50,000 $(50,000) $3,210 ($37,000) ($3,210) $82,162,832 City of Pickering 2023 Approved Departmental Expenditures by Cost Centre Run Date: Sep 13, 2023 2022 2023 % Change Approved Increase/ Approved 2023 Budget Budget (Decrease) Budget vs. 2022 Budget Department Expenditures - 10000 Office of the Chief Administrative Officer 1,795,057 (1,211,190) 583,867 (67.47%) 10005 Customer Care Centre 482,458 24,458 506,916 5.07% 10010 Public Affairs & Corp Comm 1,247,053 131,966 1,379,019 10.58% 10050 Economic Development & Strategic Projects -1,171,582 1,171,582 - % 10100 City Development-Adm in 1,252,121 (236,548) 1,015,573 (18.89%) 10105 Planning & Design 4,912,293 346,232 5,258,525 7.05% 10110 Building Services 2,165,184 398,561 2,563,745 18.41% 10115 Sustainability 847,609 22,726 870,335 2.68% 10120 Committee of Adjustment 10,992 786 11,778 7.15% 10125 Heritage Pickering 17,525 -17,525 - % 10200 Culture & Recreation -Admin 3,228,425 993,858 4,222,283 30.78% 10205 Programs 2,782,129 562,254 3,344,383 20.21% 10210 Dunbarton Pool 448,550 87,654 536,204 19.54% 10215 Don Beer Arena 1,409,028 121,321 1,530,349 8.61% 10220 Community Centres 934,310 (42,139) 892,171 (4.51%) 10225 Recreation Complex -Central Core 3,687,600 264,330 3,951,930 7.17% 10230 Recreation Complex -Pool 963,423 17,345 980,768 1.80% 10235 Recreation Complex -Arenas 1,093,694 55,329 1,149,023 5.06% 10240 Civic Centre 1,150,206 48,922 1,199,128 4.25% 10245 Senior Citizens Centre 581,252 31,447 612,699 5.41% 10250 Museum 1,915,148 (276,599) 1,638,549 (14.44%) 10300 Public Works -Administration 1,182,925 (160,119) 1,022,806 (13.54%) 10305 Property Maintenance 1,445,018 282,168 1,727,186 19.53% 10310 Fleet Services 2,085,597 238,406 2,324,003 11.43% 10315 Roads 8,583,303 594,046 9,177,349 6.92% 10320 Parks 5,454,925 194,499 5,649,424 3.57% 10325 Operations Services 1,601,554 10,275 1,611,829 0.64% 10330 Major Capital Facilities -189,975 189,975 - % 10400 Legal Services 741,176 253,877 995,053 34.25% 10405 Information Technology 3,314,196 578,649 3,892,845 17.46% 10410 Clerks Office 511,545 162,957 674,502 31.86% 10415 Records Management & Elections 590,832 (413,816) 177,016 (70.04%) 10420 Print Shop/Mail Room 555,357 6,393 561,750 1.15% 10425 By-Law 1,880,347 237,324 2,117,671 12.62% 10430 Animal Services 696,309 70,523 766,832 10.13% 3 City of Pickering 2023 Approved Departmental Expenditures by Cost Centre Run Date : Sep 13 , 2023 2022 2023 % Change Approved Increase/ Approved 2023 Budget Budget (Decrease) Budget vs . 2022 Budget 10500 Engineering Services -Admin 3,112,605 53 ,902 3,166,507 1.73% 10505 Crossing Guards 424,400 9,740 434,140 2.30% 10510 Water Resources & Development Services 2,297,464 361,114 2,658,578 15.72% 10515 Sidewalks 395 ,590 290,064 685,654 73.32% 10520 Streetlights 1,081,780 (57,060) 1,024,720 (5.27%) 10600 Finance 4,823,741 291,898 5,115 ,639 6.05% 10605 Supply & Services 478,582 229,281 707,863 47.91% 10700 Fire Protection 18,922,854 1,621,066 20,543,920 8 .57% 10705 Emergency Operations 178,979 5,663 184,642 3.16% 10800 Human Resources 1,405,552 179,323 1,584,875 12.76% 10805 Health & Safety 170,061 30,071 200,132 17.68% 10900 Library 6,283,410 387,782 6,671,192 6.17% TOTAL 99,142,159 8,160,296 107,302,455 8.23% 4 City of Pickering 2023 Approved Departmental Revenues by Cost Centre Run Date: Sep 13, 2023 2022 2023 % Change Approved Increase/ Approved 2023 Budget Budget (Decrease) Budget vs. 2022 Budget Departmental Revenues 10000 Office of the Chief Administrative Officer (277,785) 277,785 -(100.00%) 1001 O Public Affairs & Corp .comm (111,500) (50,485) (161,985) 45.28% 10050 Economic Development & Strategic Projects -(202,250) (202,250) - % 10100 City Development-Admin (412,000) 267,000 (145,000) (64.81%) 10105 Planning & Design (2,581,995) (955,485) (3,537,480) 37.01% 10110 Building Services (3,373,390) (861,610) (4,235,000) 25.54% 10115 Sustainability (233,245) 30,495 (202,750) (13.07%) 10200 Culture & Recreation -Admin (474,550) (112,750) (587,300) . 23.76% 10205 Programs (1,722,750) (759,200) (2,481,950) 44.07% 10210 Dunbarton Pool (109,186) (23,254) (132,440) 21.30% 10215 Don Beer Arena (962,710) (124,940) (1,087,650) 12.98% 10220 Community Centres (190,180) (9,200) (199,380) 4.84% 10225 Recreation Complex -Central Core (1,075,564) (164,126) (1,239,690) 15.26% 10230 Recreation Complex -Pool (214,602) (57,358) (271,960) 26.73% 10235 Recreation Complex -Arenas (770,350) (76,350) (846,700) 9.91% 10240 Civic Centre (354,148) 30,358 (323,790) (8.57%) 10245 Senior Citizens Centre (246,530) 40,130 (206,400) (16.28%) 10250 Museum (1,156,602) 402,952 (753,650) (34.84%) 10300 Public Works -Administration (175,850) -(175,850) - % 10305 Property Maintenance (25,000) (35,100) (60,100) 140.40% 10310 Fleet Services (193,000) -(193,000) - % 10315 Roads (382,550) (42,500) (425,050) 11.11% 10320 Parks (192,000) (67,000) (259,000) 34.90% 10325 Operations Services (46,000) -(46,000) - % 10400 Legal Services (167,510) 8,510 (159,000) (5.08%) 10405 Information Technology (261,680) 10,000 (251,680) (3.82%) 10410 Clerks Office (282,000) (41,000) (323,000) 14.54% 10425 By-Law (1,365,300) (462,300) (1,827,600) 33.86% 10430 Animal Services (148,300) (32,000) (180,300) 21.58% 10500 Engineering Services -Admin (102,000) (133,000) (235,000) 130.39% 10510 Water Resources & Development Services (986,935) (330,605) (1,317,540) 33.50% 10520 Streetlights -(500) (500) - % 10600 Finance (3,566,000) (750,000) (4,316,000) 21.03% 10700 Fire Protection (176,000) (55,000) (231,000) 31.25% 5 10705 Emergency Operations 10800 Human Resources 10900 Library City of Pickering 2023 Approved Departmental Revenues by Cost Centre Run Date : Sep 13, 2023 2022 2023 % Change Approved Increase/ Approved 2023 Budget Budget (Decrease) Budget vs. 2022 Budget (150,000) -(150,000) - % (227,958) (12,582) (240,540) 5.52% (248 ,025) (57,400) (305,425) 23.14% TOTAL (22 ,963,195) (4,348,765) (27,311,960) 18.94% 6 City of Pickering 2023 Approved Departmental Transfers by Cost Centre Run Date : Sep 13, 2023 2022 2023 % Change Approved Increase I Approved 2023 Budget Budget (Decrease) Budget vs. 2022 Budget Departmental Transfers 10000 Office of the Chief Administrative Officer (246,280) 246,280 -(100.00%) 10010 Public Affairs & Corp Comm (81,840) (78,635) (160,475) 96.08% 10050 Economic Development & Strategic Projects -(114,435) (114,435) - % 10105 Planning & Design (827,760) 208,220 (619,540) (25.15%) 10115 Sustainability (25,000) -(25,000) -% 10200 Culture & Recreation -Ad min (150,400) (181,687) (332,087) 120.80% 10205 Programs -(136,900) (136,900) - % 10225 Recreation Complex -Central Core -(125,000) (125,000) -% 10250 Museum (10,000) 10,000 -(100.00%) 10305 Property Maintenance (65,000) (402,395) (467,395) 619.07% 10315 Roads (10,000) (66,500) (76,500) 665.00% 10320 Parks (68,900) 46,520 (22,380) (67.52%) 10325 Operations Services (100,000) (59,705) (159,705) 59.71% 10330 Major Capital Facilities -(189,975) (189,975) - % 10400 Legal Services (102,960) (108,520) (211 ,480) 105.40% 10405 Information Technology -(67,000) (67,000) - % 10415 Records Management & Elections (435,075) 435,075 -(100.00%) 10500 Engineering Services -Admin (270,000) 70,027 (199,973) (25.94%) 10510 Water Resources & Development Services (302,315) (180,411) (482,726) 59.68% 10515 Sidewalks (200,000) (250,000) (450,000) 125.00% 10520 Streetlights (3,100) (1,272) (4,372) 41.03% 10600 Finance (441,800) 207,150 (234,650) (46.89%) 10700 Fire Protection -(112,500) (112,500) - % 10800 Human Resources (50,100) 25,100 (25,000) (50.10%) 10805 Health & Safety (20,000) (15,000) (35,000) 75.00% 10900 Library 100,000 (78,750) 21,250 (78.75%) TOTAL (3,310,530) (920,313) (4,230,843) 27.80% 7 City of Pickering 2023 Apr:>_roved New Full & Part Time Permanent Positions 2023 Property Tax Impact 2024 Property Tax Impact Start # of Total Position Additional Annualized Department Position Date Positions Salary Benefits Cost Cost Cost (1) (2) (3) (4) (5)=(3)+(4)* Office of the CAO I Executive Assistant , Council 1-May 1.0 $47 ,800 $14,350 $62 ,150 I Government Affairs & Strategic Projects Advisor 1-May 1.0 63,600 19,100 82 ,700 2 .0 $111,400 $33,450 $144 ,850 $31,1001 $95 ,100 41,400 126 ,600 $72,500 I $221,100 Econon:iic D~velopment &I Marketing Specialist 1-Sep 1.0 I $28,9001 $8,6801 $37 ,58011 $75,2001 $115,0001 Strategic ProJects City Development I Principal Code Advisor 1-May 1.0 $70,100 $21 ,030 $91 ,130 $45,600 $139 ,500 I Senior Planner -Comprehensive Zoning By-law 1-Jun 1.0 56 ,300 16 ,900 73,200 52,300 128,000 I Senior Planner -Housing (Resolution #101 /23) 1-Oct 1.0 24 ,200 7,240 31,440 94,300 128,500 Senior Zoning Examiner 1-Jul 1.0 45,000 13 ,490 58 ,490 58,500 119 ,300 Building Inspector II 1-May 1.0 57,700 17 ,320 75,020 37,500 114,800 Examiner/ Inspector 1-May 1.0 55 ,600 16,670 72 ,270 36,100 110,500 Geomatics Analyst 1-May 1.0 47,800 14,330 62 ,130 31,100 95 ,100 ..... 0 ! Planner 11, Site Planning 1-May 1.0 47 ,800 14,330 62,130 31 ,100 95 ,100 AMANDA Programmer 1-May 1.0 47,800 14,330 62,130 31 ,100 95,100 I Zoning Technician 1-Jul 1.0 33 ,300 11,700 45,000 45,000 91,800 Clerk, Building Services 1-May 1.0 41 ,200 14,400 55 ,600 27,800 85 ,100 Building Inspector Interns 1-May 2.0 82 ,300 28,800 111 ,100 55 ,600 170 ,000 Coordinator, Community Energy Management 1-May 1.0 64,400 19,310 83 ,710 41,900 128,100 Less: Increased Planning & Building Revenues -(673,500) (209,850) (883 ,350) (587 ,900) (1,500,900) I 14.0 $0 $0 $0 $0 $0 Cherrywood Development f Principal Planner 1-Apr 1.0 $78,900 $23,670 $102,570 $34,190 $139,500 Senior Planner 1-Dec 1.0 7,200 2 ,160 9 ,360 103 ,000 114 ,600 Project Manager, Development Services 1-Sep 1.0 33,000 9 ,900 42,900 85,800 131 ,300 Water Resources Engineer 1-Sep 1.0 32,200 9,660 41,860 83 ,700 128,100 Coordinator, Development Approvals 1-Dec 2 .0 13,900 4 ,170 18,070 198,800 221 ,200 1 Technician, Development Approvals 1-Dec 1.0 5 ,800 1,740 7 ,540 82 ,900 92 ,200 I Inspector, Development Services 1-Dec 1.0 7,700 2,310 10 ,010 110,100 122,500 Senior Financial Analyst 1-Dec 1.0 2,190 660 2,850 148,200 154,100 I Less: Reserve Funding (180 ,890) (54 ,270) (235,160) (846,690) (1 ,103 ,500) 9.00 $0 $0 $0 $0 $0 City of Pickering 2023 Approved New Full & Part Time Permanent Positions 2023 Property Tax Impact 2024 Property Tax Impact Start #of Total Position Additional Annualized Department Position Date Positions Salary Benefits Cost Cost Cost (1) (2) (3) (4) (5)=(3)+(4)* Community Services I Acquatics Program Assistant 1-May 1.0 $36 ,100 $12 ,600 $48,700 $24,350 $74,500 (conversion from part-time) I Less: Part-time Acquatics Program Assistant 1-May -0.5 (42 ,200) (3 ,500) (45 ,700) (22 ,850) (69 ,900) I Facility Attendant (conversion from part-time) 1-May 2 .0 51 ,000 17,840 68,840 34 ,420 105,300 Less: Part-time Facility Attendant 1-May -1.0 (37,400) (7,060) (44,460) (22 ,230) (68 ,000) I Facility Attendant 1-May 1.0 38 ,300 13,390 51 ,690 25,845 79,100 . Less: Part-time Facility Custodian 1-May -0.5 (45,800) (4 ,580) (50 ,380) (25 ,190) (77 ,100) ' 2 .0 $ -$ 28 ,690 $ 28,690 $ 14,345 $ 43 ,900 Operations j Manager, Facilities Capital Projects 1-Sep 1.0 $38 ,500 $11 ,550 . $50,050 $100 ,100 $153,200 I Lead Hand, Road Maintenance 1-May 1.0 58 ,400 17,530 75 ,930 38,000 116 ,200 I Repairperson , Small Equipment 1-Jun 1.0 46,100 13,840 59,940 42 ,800 104,800 Heavy Equipment Operator I 1-May 1 .0 48,900 14,670 63 ,570 31 ,800 97 ,300 ..... 1 Maintenance Worker, Roads 1-May 1.0 47,000 14,100 61 ,100 30,600 93 ,500 ..... I Maintenance Worker, Parks & Property 1-May 1.0 47,000 14,100 61,100 30 ,600 93 ,500 I 6.0 $285 ,900 $85 ,790 $371 ,690 $273 ,900 $658 ,500 New Capital Facilities Project Manager 1-Sep 2.0 $85 ,400 $23 ,500 $108,900 $217,800 $333,200 Coordinator 1-Sep 1.0 25,600 7,040 32 ,640 65 ,300 99,900 Less: Reserve Funding (111 ,000) (30 ,540) (141,540) (283,100) (433 ,100) 3 .0 $0 $0 $0 $0 $0 Corporate Services I AMANADA Software Administrator 1-May 1.0 $51 ,100 $15 ,340 $66,440 $132,900 $203,300 Legislative Coordinator (Resolution #54/22) 1-Mar 1.0 72 ,300 21 ,690 93 ,990 18 ,800 115 ,000 I Business Analyst 1-May 1.0 46 ,100 15,100 61,200 30 ,600 93 ,600 I Clerk , Administration, Vital Stats . & Lottery Licensing 1-Jul 1.0 30 ,900 10 ,800 41 ,700 41 ,700 85 ,100 I Administrative Assistant 1-May 1.0 39,500 13,830 53,330 26,700 81 ,600 Animal Shelter Attendant (conversion from part-time) 1-May 1.0 34 ,700 12,140 46,840 33 ,500 81,900 ' Less: Part-time Animal Shelter Attendant 1-May -0.5 (33 ,300) (6 ,240) (39 ,540) (28 ,200) (69 ,100) I Less: Grant Funding (5 ,000) (5,000) (5 000) 5 .5 $241 ,300 $82,660 $318 ,960 $251,000 $586 ,400 City of Pickering 2023 Af!eroved New Full & Part Time Permanent Positions Start # of Department Position Date Positions Engineering Services : Engineer, Water Resources 1-Jul 1.0 I Manager, Transportation & Traffic Services 1-Jul 1.0 Sr. Coordinator, Asset Management 1-Jul 1.0 1 Coordinator, Development Approvals 1-Jul 1.0 I 4.0 Finance Sr. Financial Analyst 1-May 1.0 Systems Analyst -SAP 1-Dec 1.0 Sr. Procurement Analyst (Resolution #20/22) 1-Feb 1.0 Accounts Payable Clerk 1-May 1.0 I 4.0 I Fire Services l Firefighters (Resolution #20/22) -Seaton Related 1-Feb I 5 .0 11 I Hu~n Resources j HR Associate 1-Jul I 1.0 II I* (Includes an assumed salary increase) Total I 56.50 I I 2023 Property TaxJ_111_pact Salary (1) $48 ,300 $48 ,300 $47,700 $47,700 43 ,300 43 ,300 $41,700 $41,700 $181 ,000 $181 ,000 $70 ,100 8 ,800 76 ,400 42 ,780 $198,080 $298 ,3001 $35,9001 $1,380 ,7801 Benefits (2) $14 ,480 $14 ,480 $14,320 $14,320 13,000 13,000 $12 ,500 $12 ,500 $54 ,300 $54 ,300 $21 ,020 2 ,640 22 ,900 14 ,980 $61 ,540 $104,4001 $10 ,8001 $470,3101 Total Position Cost (3) $62 ,780 $62 ,780 62 ,020 62 ,020 56 ,300 56 ,300 54 ,200 54 ,200 $235,300 $235,300 $91 ,120 11,440 99,300 57,760 $259 ,620 $402 ,7001 I $46 ,700 I $1,84s,oso I 2024 Property Tc1x lmeact Additional Annualized Cost Cost (4) (5)=(3)+(4)* $62 ,800 $128 ,100 62 ,000 126,500 56,300 114,900 54 ,200 110 ,600 $235,300 $480 ,100 $45 ,600 $139,500 125,800 139 ,900 9 ,000 110,500 28 ,900 88 ,400 $209 ,300 $478 ,300 $36,6001 $448,1001 $46,7001 $95 ,300 $1 ,214,8451 $3,127,300 / '- 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: • Public Affairs & Corporate Communications • Customer Care Centre • Office of the CAO Administration • Equity, Diversity & Inclusion 'I Office of the CAO Department "' I / 'I Public Affairs & Corporate Communications '-/ I I 'I / " r ' r Public Affairs & Customer Care Office of the CAO Equity, Diversity Corporate Centre Administration & Inclusion Communications '-'-/ '- Key Activities for 2023 The Department's key activities for 2023 include: • Coordinate the implementation of the Corporate Strategic Plan • Coordinate the implementation of the Digital Readiness Assessment & Strategy • Coordinate the implementation of the City's Equity, Diversity & Inclusion Strategy • Coordinate City activities associated with the City Centre project • Coordinate City activities associated with the Cherrywood development • Conduct media relations training for senior management and key staff • Enhance digital media and video content production to support corporate priorities • Update social media strategy and implement staff training 13 " Office of the CAO Department • Review and strengthen Corporate brand guidelines and visual identity • Continue quarterly CAO Newsletter and other relevant communications to staff (e.g. video messages, Council Highlights) • Support Departments across the Corporation in the communication of their services, programs and initiatives • Expand public engagement efforts to continue to strengthen the Customer Care Centre's profile within the community • Create and implement customer service training for internal staff to assist with increasing service delivery expectations • Conduct customer service training sessions for Customer Care staff, to enhance training methods and techniques/topics Financial Information Staffing Summary (Full & Regular Part-Time) Approved Approved Prior Term New Term 2019 2020 2021 2022 2023 Add Transfers Total Out* Full-Time 14 14 17 18 2 -4 16 Reg. Part-Time 1 1 1 2 --2 Total 15 15 18 20 2 -4 18 * 4 positions were transferred from the Office of the CAO to establish the new Economic Development & Strategic Projects Department's cost centre The Department proposes one new full-time Government Affairs & Strategic Projects Advisor to coordinate the implementation of the Corporate Strategic Plan and other corporate priorities and to provide strategic advice regarding the public affairs of the corporation. In addition, the department proposes the conversion of one contract Digital Communications Specialist to full-time to provide dedicated support for the City's digital media program (videography, photography, and graphic design). 14 Office of the CAO Department Year-Over-Year (Net Cost) Budget Changes 2022 2023 Year-Over-Year Approved Approved Change Budget* Budget ($) (%) CAO Administration* $497,155 $583,867 $86,712 17.44% Customer Care Centre 482,458 506,916 24,458 5.07% Public Affairs & Corp. 1,053,713 1,056,559 2,846 0.27% Communications Total (Net Cost) $2,033,326 $2,147,342 $114,016 5.61% * In 2023, the Economic Development function was transferred from the budget of the Office of the CAO to its own departmental budget and cost centre to accurately reflect the current corporate structure. Budgetted expenses and revenues were transferred from the Office of the CAO -Administration cost centre to the new Economic Development & Strategic Projects cost centre and accordingly the 2022 comparative information has been restated -total transferred out was $773,837. Explanation of Significant Departmental Budget Changes Expenditures -Increases I (Decreases) Salaries & Benefits -$221 ,400 Budget increase largely due to the addition of one new full-time Government Affairs & Strategic Projects Advisor and the conversion of one contract Digital Communications Specialist to full-time. Consulting & Professional Fe~s -($229,300) Budget decrease due to economic development studies completed in 2022. Meals, Promotions & General Expenses -$18,800 Budget increase due to Equity, Diversity & Inclusion events and community partnerships moved from account 502250 in 2022 to account 502240 in 2023 (budget correction). Memberships -($11,700) Budget decrease due to Equity, Diversity & Inclusion events and community partnerships moved from account 502250 in 2022 to account 502240 in 2023 (budget correction). Committee Expenses -$10,000 Budget increase due to the addition of honoraria for consultations for the Indigenous Building Circle Initiative and increased community programming and workshops. 15 Office of the CAO Department Website Support-($10,500) Budget decrease due to lower eCommerce Payment Processing annual fees and licensing fees for Live Chat software. Revenues/Transfer from Reserves -(Increases) I Decreases Federal Grants -($62,000) Revenue increase due to the grant funding associated with the new full-time contract Community Engagement Coordinator position to support the City's Equity, Diversity and Inclusion plan. Ontario Grants -$14,600 Revenue decrease due to the Streamline Development project funding of a summer student position which concluded in 2022. Cost Recoveries -$80,900 Revenue decrease due to the elimination of third-party funding with the completion of the Pickering Nuclear Generating Station study in 2022. Netted Revenue -$11,500 Revenue decrease due to a one-time cost recovery from the Library for Public Affairs Assistant position in 2022. Transfer from Continuing Studies Reserve -($62,100) Increase due new funding for the Digital Readiness Assessment and Service Modernization Strategic Plan which is continuing in 2023 ($160,475), offset by the completion of several 2022 projects which were funded from this reserve. Transfer from Reserves -$123,700 Decrease primarily due to the elimination of rate stabilization reserve funding for one contract Digital Communications Specialist contract position. The department proposes to convert this contract position to a full-time position dedicated to support the City's digital media program. 16 Office of the CAO Department Department Performance Indicators/Statistics Performance 2020 2021 2022 Indicators/Statistics Corporate Communications Website Website (pickering.ca) 494,364 523,214 437,324 visitors Website (pickering.ca) 1,445,159 1,465,954 1,313,973 unique paQe views Website News Feed Subscribers: Business NIA 452 509 Emergency Alert Banner NIA 506 592 News & Announcements NIA 730 831 Public Notices NIA 679 759 Social Media @CityofPickering only (corporate account) F acebook Likes 8,784 11,258 12,000 Facebook Page Reach NIA 519,923 2,855,689 ( estimated) lnstagram Page Reach NIA 94,267 69,549 The number of unique accounts that saw any of your posts or stories at least once. Reach is different from impressions, which may include multiple views of your posts by the same accounts. This metric is estimated. lnstagram Followers 6,818 8,403 9,133 Twitter Followers 9,800 10,800 11,400 YouTube Channel Views 8,784 34,600 58,935 YouTube Hours Watched NIA 6,000 7,995 YouTube Subscribers NIA 668 920 17 Office of the CAO Department Performance 2020 2021 2022 Indicators/Statistics Facebook Live Events Mayor's Virtual Town Halls December 20, Se12tember 21, March 30, 2020 2021 2022 • Total views: • Total views: • Total views: 2,100 697 907 • People • People • People reached:5,200 reached: 1, 187 reached: 1,300 • 127 comments • 93 comments • 39 comments May 18, 2021 • Total views: 1,300 • People reached: 6,000 • 163 comments Hate Crimes Town Hall N/A N/A AQril 11, 2022 • Total views: 757 • People reached: 832 • 19 comments Let's Talk Pickering -N/A November 24, N/A Speaker Series on 2021 Kim Petrin - Planning and Development Manager of Develo12ment Services, City of Edmonton • Total views: 3,900 • People reached: 6,500 • 25 comments November 17, 2021 -Brent Toderian -Urban Advisor • Total views: 3,900 • People reached: 8,000 • 73 comments 18 Office of the CAO Department Performance 2020 2021 2022 Indicators/Statistics F acebook Town Hall with N/A N/A June 1, 2022 CAO, Marisa Carpino • Total views: 5.3K • People reached: 5.3K Mayor's Telephone Town N/A 5,865 attendees February 2, 2022 Halls • 3,088 attendees • 67 questions received October 12, 2022 • 2,693 listeners • 33 questions received (4 development related) Media releases issued by 66 64 39 City of Pickering Corporate Communications Media Exposure Data Summary Media Exposure -Reports on the number of traditional media and social media hits that we get: Traditional media N/A 1,644 1,107 Social media N/A 2,932 2,664 Reach Trend -Number of potential viewers that have been exposed to our search topics: Traditional media N/A 1, 637,200 N/A Let's Talk Pickering - Digital Community Engagement Platform, launched June 15, 2021: Registered users N/A 1,411 1,790 1 9 Office of the CAO Department Performance 2020 2021 2022 Indicators/Statistics Total Visits-# times a N/A 10,900 13,700 user visited or stayed on the site > 30 minutes Aware Visitors: visitor that N/A 8,400 10,700 has made one single visit to site or project Informed Visitors: visitor N/A 4,200 3,900 who sought more information by clicking on something Engaged Visitors: visitor N/A 1,800 1,800 that has contributed or provided feedback to an active tool on consultation paqe Pingstreet -Smart App which provides mobile users with key City news, calendar information, and social media feeds, along with reporting and feedback tools: Unique Page Views 14,803 10,812 7,041 Unique Users 750 633 456 Customer Care Telephone 41,378 44,622 41,068 Counter -in person 703 2,773 6,376 inquiries made by the public at the Customer Care Centre (located at City Hall) 20 Office of the CAO Department Performance 2020 2021 2022 Indicators/Statistics AMANDA Service 21,093 27,008 27,653 Requests -AMANDA is a property-based software platform, which, in part, allows service requests from the public to be opened, with follow up details entered until the completion of the request. Live Chat-real time 533 350 683 communication with Customer Care staff during regular business hours. Customer Care Web Email 4,125 5,621 9,122 Pingstreet -Smart App 414 403 436 enabling residents to submit a request for service or ask a question of the City. After-Hours Calls -calls 1,519 1,308 1,686 received from the City's contracted after-hours service provider that are screened and processed by City staff on the next business day. Total 69,765 82,085 87,024 21 City of Pickering 2023 Approved Current Budget Office of the CAO Department 2021 2022 2022 Actuals * Actuals * Account Description Approved Budget* Expenditures 1,543,130 1,827,868 Salaries & Wages 1,235,686 629 1,064 Overtime 2,000 401,243 434,748 Employee Benefits 324,520 1,574 1,626 Conferences 8,500 2,106 14,043 Seminars & Education 31,000 10,983 20,708 Travel 20,550 2,563 17,579 Business Development 3,000 -182 Freight, Express & Cartage - 8,473 9,565 Cellular Phones 7,500 20,582 24,096 Telephone & Data 24,235 595 572 Internet 445 14,153 17,787 Advertising 11 ,000 8,392 6,000 Trade Shows,Exhibits & Displays 5,000 2,360 540 Subscriptions & Publications 2,670 -6,365 Brochures/Newsletters Printing 6,000 3,635 3 ,079 Photo, Mapping, Print 4,000 8 ,920 8,920 Insurance Premium 7,440 416,356 439,205 Consulting & Professional Fees 456,825 45,754 54,400 Meals, Promotions & General 18,250 8,280 9,202 Memberships 13,400 26,867 25,314 Outside Agency Services 117,500 1 ,287 -Corporate Initiatives - --Gas, Oil, Tire, Etc. 1,000 5,396 2,589 Stationary & Office Supplies 6,100 357 1,844 Programs & Event Supplies 700 378 31,182 Committee Expenses 65,000 46 -Supplies & Tools - 20,096 11,856 Software & Hardware Mtce. Contracts 27 ,440 1,348 1,474 Utilities -Hydro 3,300 31,697 25,109 Website Support 52,825 -33 System & Software Upgrade - -142 Hardware Replacements 6,500 -. -Misc. Equipment - 2,587,200 2,997,092 Total Expenditures 2,462,386 Revenues --Federal Grants - -(12,239) Ontario Grants (14 ,600) --Advertising Space (100 ,000) (375) -Other User Fees - (265,590) (268,396) Cost Recoveries (80 ,860) --Netted Revenue (11,500) (265,965) (280,635) Total Revenues (206,960) 22 2023 Increase I Approved % Change Decrease Budget From 2022 176,103 1,411,789 14.25% -2,000 - 45,288 369,808 13.96% 1,500 10,000 17.65% 500 31,500 1.61% (2,000) 18,550 (9 .73%) -3 ,000 - --- 7 ,400 14,900 98.67% 965 25,200 3 .98% -445 - 2 ,000 13,000 18.18% (5,000) -(100.00%) 875 3,545 32 .77% (1,000) 5 ,000 (16 .67%) 1,500 5 ,500 37.50% 920 8,360 12.37% (229,250) 227,575 (50.18%) 18,750 37,000 102.74% (11 ,660) 1,740 (87.01%) -117,500 - --- -1,000 - -6 ,100 - -700 - 10,000 75,000 15.38% --- 5,550 32 ,990 20.23% (1,000) 2 ,300 (30.30%) (10,525) 42,300 (19 .92%) --- (6,500) -(100.00%) 3 ,000 3 ,000 - 7,416 2,469,802 0.30% (61,985) (61,985) - 14,600 -(100.00%) -(100,000) - --- 80 ,860 -(100.00%) 11,500 -(100.00%) 44,975 (161,985) (21.73%) City of Pickering 2023 Approved Current Budget Office of the CAO Department 2021 2022 2022 Actuals * Actuals* Account Description Approved Budget* Transfers 98,040 -Transfer to(from) Cntg Sty Res. (98,425) (40,524) -Transfer to(from) Reserve (123,675) 57,516 -Total Transfers (222,100) 2,378,751 I 2,716,457 I Net Expenditures (Revenues) 2,033,326 I 2023 Increase I Approved %Change Decrease Budget From 2022 (62,050) (160,475) 63.04% 123,675 -(100 .00%) 61,625 (160 ,475) (27.75%) 114,01s I 2,147 342 I 5.61% * In 2023, the Economic Development & Strategic Projects function was transferred from the budget of the Office of the CAO to its own departmental budget and cost centre to accurately reflect the current corporate structure. Budgetted expenses and revenues were transferred from the CAO Administration cost centre to the new Economic Development & Strategic Projects cost centre and accordingly the 2022 comparative budget information has been restated . Restated comparative actual results for 2022 and prior are not available for the Office of the CAO . 23 City of Pickering 2023 Approved Current Budget 10000 Office of the CAO -Administration 2021 2022 2022 Actuals " Actuals" Account Description Approved Budget" Expenditures 704,224 936 ,375 Salaries & Wages 361,787 --Overtime 500 183,983 217 ,637 Employee Benefits 99,188 1,574 1,626 Conferences 3,000 1,318 -Seminars & Education 1,000 10 ,983 20,133 Travel 14 ,000 2,537 16,383 Business Development - -182 F reight , Express & Cartage - 4,956 4,912 Cellular Phones 3,300 1,568 1,668 Telephone & Data 780 238 229 Internet 100 7,296 11 ,169 Advertising 3,000 8 ,392 6,000 Trade Shows.Exhibits & Displays 5 ,000 210 -Subscript ions & Publications - 2,800 2,800 Insurance P remium 1,320 334,938 372,228 Consulting & Professional Fees 219,725 30,651 44,263 Meals, Promotions & General 7,500 7,623 5,465 Memberships 200 12,858 20 ,279 Outside Agency Services - --Gas , Oil, Tire , Etc . 1,000 3,952 2,179 Stationary & Office Supplies 4 ,500 179 -Programs & Event Supplies - 378 -Committee Expenses - 46 -Supplies & Tools - 387 989 Software & Hardware Mtce. Contracts 475 -142 Hardware Replacements 6,500 1,321,091 1,664,659 Total Expenditures 732,875 Revenues --Federal Grants - -(12,239) Ontario Grants (14 ,600) -. -Marketing Sponsors - (265,590) (268,396) Cost Recoveries (80 ,860) (265,590) (280,635) Total Revenues (95,460) 24 2023 Increase/ Approved % Change Decrease Budget From 2022 60 ,937 422 ,724 16.84% -500 - 7,957 107,145 8.02% 1,500 4,500 50.00% 1,000 2 ,000 100.00% 1,000 15,000 7 .14% --- --- 2 ,000 5 ,300 60 .61% 920 1,700 117.95% -100 - -3,000 - (5 ,000) -(100 .00%) 425 425 - 308 1,628 23 .33% (219,725) -(100.00%) 2,500 10 ,000 33 .33% 640 840 320 .00% 3,000 3,000 - -1,000 - -4,500 - --- --- --- 30 505 6 .32% (6,500) -(100 .00%) (149,008) 583,867 (20.33%) --- 14 ,600 -(100 .00%) --- 80,860 -(100.00%) 95,460 -(100.00%) City of Pickering 2023 Approved Current Budget 10000 Office of the CAO -Administration 2021 2022 2022 Actuals * Actuals * Account Description Approved Budget* Transfers 98,040 -Transfer to(from) Cntg Sty Res . (98 ,425) (40,524) -Transfer to(from) Reserve (41,835) 57,516 -Total Transfers (140,260) 1113 017 1384024 Net Expenditures (Revenues) 497155 2023 Increase I Approved %Change Decrease Budget From 2022 98 ,425 -(100 .00%) 41,835 -(100 .00%) 140,260 -(100.00%) 86 712 583 867 17.44% * In 2023, the Economic Development & Strategic Projects function was transferred from the budget of the Office of the CAO to its own departmental budget and cost centre to accurately reflect the current corporate structure. Budgetted expenses and revenues were transferred from the CAO Administration cost centre to the new Economic Development & Strategic Projects cost centre and accordingly the 2022 comparative budget information has been restated . Restated comparative actual results for 2022 and prior are not available for the Office of the CAO . 25 City of Pickering 2023 Approved Current Budget Summary 10005 Customer Care Centre 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease Expenditures 417,707 342,639 Salaries & Wages 341,262 20,986 -438 Overtime 1,000 - 115,988 90,386 Employee Benefits 98,291 3,669 --Conferences 1,500 - -6,409 Seminars & Education 10,500 (500) --Travel 800 - 1,059 211 Cellular Phones 800 400 18,230 21,675 Telephone & Data 22,545 (745) 238 229 Internet 230 - 2,630 2,630 Insurance Premium 2,630 263 16 486 Meals, Promotions & General 750 250 416 235 Memberships 350 200 375 366 Stationary & Office Supplies 600 - -57 Programs & Event Supplies 700 - 146 445 Software & Hardware Mtce . Contracts 500 (65) 556,805 466,206 Total Expenditures 482,458 24,458 Revenues (375) -Other User Fees -- (375) -Total Revenues -- Transfers --Total Transfers -- 556,430 . 466,206 Net Expenditures (Revenues) 482,458 24,458 26 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 362,248 6.15% 1,000 -% 101,960 3 .73% 1,500 -% 10 ,000 (4.76%) 800 -% 1,200 50.00% 21,800 (3.30%) 230 -% 2 ,893 10.00% 1,000 33 .33% 550 57 .14% 600 -% 700 -% 435 (13.00%) 506,916 5.07% --% --% --% 506,916 5.07% City of Pickering 2023 Approved Current Budget Summary 10010 Public Affairs & Corp Comm 2021 2022 2022 Actua ls Actuals Account Description Approved Increase/ Budget Decrease Transfers -160,476 Transfer to(from) Cntg Sty Res . -(160,475) --Transfer to(from) Reserve (81,840) 81,840 -160,476 Total Transfers (81,840) (78,635) 709,304 1,056,090 Net Expenditures (Revenues) 1,053,713 2,846 28 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 (160,475) -% -(100.00%) (160,475) 96.08% 1,056,559 0.27% Corporate Initiatives Cherrywood Development Team In 2022, the province passed Bill 23, the More Homes Built Faster Act, 2022, which provided for the removal of the Duffins Rouge Agricultural Preserve (DRAP) lands from the Greenbelt. This change will allow for new development in the area known as Cherrywood in Pickering. It is expected that the required pace of review and approval in this new development area will be unusually quick because of the Province's requirement for construction to begin no later than 2025. In order to facilitate the timely review and approval of the expected applications and supporting materials for development within this area, the City is proposing to create a cross-functional dedicated Cherrywood Development team. Funding for this team would come from a newly established Cherrywood reserve, which would be temporarily funded with a loan from the Casino Reserve, with the intent that these funds would be repaid from development-related revenues and/or external contributions as development progresses. Financial Information 2023 Budget & 2024 Projection Cherrywood Development Team Less: Transfer from proposed new Cherrywood Reserve Total (Net Cost) 29 2023 Approved Budget $315,760 (315,760) $ - 2024 Projected Budget $408,380 (408,380) $- City of Pickering 2023 Cherrywood Development Run Date: Sep 13, 2023 2023 Approved Budget 10105 Planning & Design Salaries & Wages 86,100 Employee Benefits 25,830 Overtime 2,500 Software & Hardware Mtce. Contracts 4,000 Seminars & Education 1,200 Uniforms 400 Subscriptions & Publications 500 Memberships 2,000 Stationary & Office Supplies 100 Supplies & Tools 100 Misc. Equipment 10,000 Department User Fees (89,100) Transfer to (from) Reserve (43,630) Total Net Expenditures (Revenues) - 10200 Culture & Recreation -Adm in Consulting & Professional Fees 50,000 Cost Recoveries (50,000) Total Net Expenditures (Revenues) - 10400 Legal Services Consulting & Professional Fees 100,000 Transfer to (from) Reserve (100,000) Total Net Expenditures (Revenues) - 10510 Water Resources & Development Services Salaries & Wages 92,600 Employee Benefits 27,780 Overtime 500 Cellular Phones 3,300 Software & Hardware Mtce. Contracts 3,000 Travel 500 Stationary & Office Supplies 500 Supplies & Tools 500 Misc. Equipment 30,000 Gas, Oil, Tire, Etc. 500 30 City of Pickering 2023 Cherrywood Development Run Date: Sep 13, 2023 2023 Approved Budget Building -Repairs & Maintenance 3,700 Building Rentals 19,400 Department User Fees (5,500) Licences & Permits (7,500) Transfer to (from) Reserve (169,280) Total Net Expenditures (Revenues) - 10600 Finance Salaries & Wages 2,190 Employee Benefits 660 Consulting & Professional Fees 50,000 Cost Recoveries (50,000) Transfer to (from) Reserve (2,850) Total Net Expenditures (Revenues) - 10700 Fire Protection Consulting & Professional Fees 30,000 Cost Recoveries (30,000) Total Net Expenditures (Revenues) - Total Organization (excludes Gen Govt) - 31 Economic Development & Strategic Projects Department Overview The City's Economic Development & Strategic Projects Department is mandated to expand the City's economic base and evolve Pickering's national and international profile by executing a domestic & foreign investment and business retention program. The Department is also responsible for leading the government relations and project management of all major strategic projects and studies that are related to the development of employment lands, expanding the commercial and industrial base, major residential and non-residential growth areas, corporate-wide grant applications, naming rights & sponsorship of public assets, and urban growth expansion opportunities. Economic Development is responsible for: • Business support • Local Business Communications • Business Retention & Expansion • Work Force & Talent Attraction • Research & Analytics • Target Sector Marketing • Investment Attraction (Local & Foreign Direct) • Trade Missions and Partnerships • Investment Servicing & Aftercare Strategic Projects include: • Pickering Nuclear Generation Station (Extension/Decommissioning) • Hotel/Accommodation/Convention Centre • Kingston Road Intensification Corridor • Pickering Innovation Corridor • Seaton Community • Northeast Pickering • Cherrywood • High Frequency Rail • Durham Live • Federal Pickering Lands (Highway 407 Corridor) • Post-Secondary Institutions Attraction • Tourism Strategy 32 Economic Development & Strategic Projects Department r Economic Development & Strategic Projects Department I I I Economic Development Strategic Projects \. Key Activities for 2023 • Oversee the development of a High Frequency Rail (HFR) concept plan on Federal Land, in coordination with the Region of Durham • Hotel/Accommodation/Convention Centre Investment (per the approved Economic Development Strategy) • Develop an investment package to attract a post-secondary institution to Pickering (per the approved Economic Development Strategy) • Implement City-wide education and engagement strategy on development initiatives in collaboration with City Development and Corporate Communications for Kingston Road Intensification, Pickering Nuclear Generating Station (PNGS), Innovation Corridor, Pickering Industrial Parks, and Northeast Pickering (per the approved Economic Development Strategy) • Consult on next steps for the Central Pickering Development Plan (CPDP) repeal • Implementation of the Pickering Economic Development Strategy • Create and execute a Federal Direct Investment (FOi) promotion plan for 2023 (per the approved Economic Development Strategy) • Continue to manage stakeholder relations for all key developments within the City of Pickering including the Kingston Road Corridor and Specialty Node (per the approved Economic Development Strategy) • Create and implement a marketing strategy/strategic positioning and brand development (per the approved Economic Development Strategy) • Coordinate City activities associated with Durham Live • Initiate a tourism strategy in partnership with culture services • Investigate a municipal accommodation tax for tourism initiatives • Implement naming rights and sponsorships strategy for capital assets • Develop and implement a corporate calling program for business retention and expansion (per the approved Economic Development Strategy) • Execute government relation strategies for CPDP, HFR, post-secondary, and major transportation initiatives 33 Economic Development & Strategic Projects Department • Organize business events in partnership with stakeholders (Realtor & Developer Event) (per the approved Economic Development Strategy) • Enhance inventory of research and data regarding market trends (per the approved Economic Development Strategy) • Develop and maintain a small business centre (per the approved Economic Development Strategy) Financial Information 2019 Full-Time - Reg. Part-Time - Total - Staffing Summary (Full & Regular Part-Time) Approved Prior Term 2020 2021 2022 Add ---1 ---- - - - 1 Approved New Term 2023 Transfers In* 4 - 4 * In 2022, 4 positions were transferred from Office of the CAO Department due to re-organization Total 5 - 5 The department proposes to add one new full-time Marketing Specialist position. This position will increase Pickering's brand exposure on social media to showcase its value proposition. The position will be responsible for developing the marketing strategy and plan to support attraction and retention of business investments, economic growth, and community development. It will be responsible for developing a variety of marketing collateral including print, video, and digital content, to enhance investment attraction efforts. The marketing specialist will lead community engagement for significant development projects across the City and create the marketing and communications plan for impacted businesses. The position is also responsible for providing detailed analysis and insight into campaigns and for conducting regular and ongoing research to be shared across the department to inform decision making. It will also collaborate with stakeholders to cross-promote services and seek new advertising/marketing opportunities. The position will also play a critical role in the Naming Rights & Sponsorship Program. 34 Economic Development & Strategic Projects Department Year-Over-Year (Net Cost) Budget Changes 2022 2023 Year-Over-Year Approved Approved Change Budget* Budget {$) {%) Economic Development $773,837 $854,897 $81,060 10.48% Total (Net Cost) .$773,837 $854,897 $81,060 10.48% * In 2023, the Economic Development function was transferred from the budget of the Office of the CAO to its own deparlmental budget and cost centre to accurately reflect the current corporate structure. Budgetted expenses and revenues were transferred from the Office of the CAO -Administration cost centre to the new Economic Development & Strategic Projects cost centre and accordingly the 2022 comparative information has been restated -total transferred in was $773,837. Explanation of Significant Departmental Budget Changes Expenditures -Increases I (Decreases) Salaries & Benefits -$66,000 Increase largely relates the addition of a full-time Marketing Specialist position starting on September 1, 2023 as well as a full-time summer student to support the Department. Conferences -$10,000 The increase covers costs for increased staff and Members of Council to attend conferences as outlined in the Foreign Direct Investment (FOi) plan. Travel, Advertising, Trade Shows and Promotional Expenses -$21,000 The increase is for enhanced social media and internal marketing efforts as noted within the approved Economic Development Strategy as well as to support FOi efforts and trades hows. Revenues/Transfer from Reserves -(Increases) I Decreases Ontario Grants-($19,500) The increase is primarily related to a new Rural Economic Development grant ($15,000) that will support the Small Business Centre. 35 Economic Development & Strategic Projects Department Department Performance Indicators/Statistics* Performance Indicators/Statistics 2020 2021 2022 Business Inquiries 1,200+ 1,300+ 500+ Business Consultations 100+ 120+ 95+ Investment Inquiries 90 100+ 50 COVID Social Media Posts and Mail-3,000+ 3,500+ N/A outs (i.e. Newsletters, Social Media Posts) Social Media N/A N/A 20,016 Impressions (Linkedin) 29,529 Impressions (Twitter) Support Local Campaign profiles (i.e. 95 100+ 100+ ProfilinQ small businesses) EnQaQement with Developers N/A N/A Daily Development Projects N/A N/A 12 Grand OpeninQs 7 8 18 * Economic Development & Strategic Projects Department will be enhancing their indicators and metrics in 2023, upon completion of the first year of implementation of the Economic Development Strategy. 2023 Proposed Key Performance Indicators (Under Review): • Number of events attended • Number of meetings with existing businesses • Number of investment inquiries and qualified leads • Number of strategic projects • Job creation and capital investment figures • Number of new openings of new businesses • Engagement on social media channels 36 City of Pickering 2023 Approved Current Budget 10050 Economic Development & Strategic Projects 2021 2022 2022 Actuals * Actuals * Account Description Approved Budget* Expenditures --Salaries & Wages 584,582 --Overtime 250 --Employee Benefits 132,390 --Conferences 5,500 --Seminars & Education 4,000 --Travel 22,000 --Business Development 20,000 --Cellular Phones 8,000 --Telephone & Data 1,040 --Internet 130 --Advertising 12,000 --Trade Shows.Exh ibits & Displays 12,000 --Subscriptions & Publications 775 --Insurance Premium 1,760 --Consulting & Professional Fees 150,000 --Meals, Promotions & General 61 ,500 --Memberships 9 ,275 --Outside Agency Services 27 ,350 --Stationary & Office Supplies 1,000 --Software & Hardware Mtce. Contracts 630 --System & Software Upgrade 8,000 --Total Expenditures 1,062,182 Revenues --Federal Grants (17 ,500) --Ontario Grants (8,000) --Marketing Sponsors (30,000) --Cost Recoveries (126 ,825) --Total Revenues (182,325) 37 2023 Increase/ Approved % Change Decrease Budget From 2022 59,080 643 ,662 10.11% 500 750 200.00% 6,415 138,805 4 .85% 10,000 15,500 181 .82% -4,000 - 4 ,500 26,500 20.45% -20,000 - 800 8,800 10.00% 660 1,700 63.46% -130 - 2,000 14,000 16.67% 8 ,000 20,000 66.67% -775 - -1,760 - -150,000 - 6,500 68 ,000 10.57% 1,300 10,575 14 .02% (4,000) 23,350 (14.63%) 2 ,000 3,000 200.00% 7,145 7,775 - 4,500 12 ,500 56.25% 109,400 1,171,582 10.30% (7,500) (25,000) 42.86% (19,500) (27,500) 243 .75% -(30,000) - 7 ,075 (119 ,750) (5 .58%) (19 ,925) (202,250) 10.93% City of Pickering 2023 Approved Current Budget 10050 Economic Development & Strategic Projects 2021 2022 2022 Actuals * Actuals * Account Description Approved Budget* Transfers --Transfer to(from) Reserve (106,020) --Total Transfers (106,020) --I Net Expenditures (Revenues) 773,837 2023 Increase/ Approved % Change Decrease Budget From 2022 (8,415) (114 ,435) 7.94% (8,415) (114,435) 7.94% 81,060 854,897 10.48% * In 2023, the Econom ic Development & Strategic Projects function was transferred from the budget of the Office of the CAO to its own departmental budget and cost centre to accurately reflect the current corporate structure. Budgetted expenses and revenues were transferred from the CAO Administration cost centre to the new Economic Development & Strategic Projects cost centre and accordingly the 2022 comparative budget information has been restated . Comparative actual results for 2022 and prior are not available for the Economic Development & Strategic Projects. 38 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, housing affordability, 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 l , ' ' / Planning Division * Building Services Sustainability Planning & Design Policy & Geomatics Zoning & Administration '- * Includes Committee of Adjustment, Site Plan Committee and Heritage Pickering Key Activities for 2023 • Continue to work with IT to implement the various aspects of Project PRISM, the digital portal to access multiple municipal services • Implement new development application submission and review processes to address Bill 109 Planning Act changes • Implement priority tasks for year one as set out in the Corporate GIS plan • Establish an Office of Housing Affordability 39 "I City Development Department • Continue to evaluate site-specific applications for development in priority growth areas, including the City Centre, Kingston Road -Brock Node, Seaton, and the Innovation Corridor • Facilitate development approvals for Phase 1 of the Cherrywood Area • Continue the community planning process for Northeast Pickering (in conjunction with the Department of Economic Development & Strategic Projects) • Continue to evaluate site-specific applications for other major developments and intensification in the City • Prepare for Ontario Land Tribunal hearing on Amendment 38 to the Pickering Official Plan for the Kingston Road and Brock Node Intensification Area • Release for public review and comment the second draft of the consolidated zoning by-law, followed by a third draft by-law for Council consideration later in. the year • Implement a Zoning Certificate process, providing preliminary zoning reviews for minor variance, site plan, and building permit applications • Undertake Phase 2 of the Community Climate Adaptation Project, followed by the development of a Community Climate Adaptation Plan in Phase 3 • Commence update to Measuring Sustainability Report Financial Information 2019 Full-Time 51 Reg. Part-Time - Total 51 Staffing Summary (Full & Regular Part-Time) Approved Prior Term 2020 2021 2022 Add 51 51 50 14 ---- 51 51 50 14 Approved New Term 2023 Transfers Total -64 -- -64 The department is proposing to maintain two contract planning positions and two planning interns in its 2023 budget, which will be funded from the provincial Streamline Development Approval Fund. Funding from this grant must be spent by October 31, 2023. Once Council approves the budget, the department is proposing to convert the following two planning positions, which were funded form the Streamline Development Approvals Fund, to permanent positions in 2023: • One contract full-time Senior Planner, Comprehensive Zoning By-law to permanent full-time 40 City Development Department • One contract full-time Geomatics Analyst to permanent full-time The department is also proposing to add a number of positions to meet the growth demands for the processing of development and building permit applications, as follows: • One new full-time Planner II, Site Planning • One new full-time Senior Planner -Housing • One new full-time Senior Zoning Examiner • One new full-time Zoning Technician • One new full-time AMANDA Programmer • One new full-time Coordinator, Community Energy Management • One new full-time Principal Code Advisor • One new full-time Building Inspector II • One new full-time Examiner/Inspector • One new full-time Clerk, Building Services • Two new full-time Building Inspector Interns The cost of these new positions is intended to be fully offset by application revenue generated this year within City Development by anticipated development. Year-Over-Year (Net Cost) Budget Changes 2022 2023 Year-Over-Year Approved Approved Change Budget Budget ($) (%) City Development -Adm. $840,121 $870,573 $30,452 3.62% Planning 1,502,538 1,101,505 (401,033) (26.69%) Building Services (1,208,206) (1,671,225) (463,049) 38.33% Sustainability 589,364 642,585 53,221 9.03% Committee of Adjustment 10,992 11,778 786 7.15% Heritage Pickering 17,525 17,525 -% Total (Net Cost) $1,752,334 $972,711 ($779,623) (44.49%) 41 City Development Department Explanation of Significant Departmental Budget Changes Expenditures -Increases I (Decreases) Salaries & Benefits -$834,600 Budget increase largely reflects the hiring of a number of positions noted earlier, that are necessary to meet the growth demands for the processing of development and building permit applications throughout the City. Brochures/Newsletters/Printing -($11,000) Funds budgeted for purchased printing were transferred to the Forms account 502510 for 2023. Consulting & Professional Fees -($432,000) Decrease is due in part to the completion of all, or a portion, of projects in 2022 which were related to the Northeast Pickering OPA and the Streamline Development Approvals Fund grant program. In addition, Building Services have a reduced need for consulting fees as there are now in-house staff with the specific skill sets required to conduct this work. These budget reductions are partially offset by additions within the Sustainability cost centre of $26,000 to update the Measuring Sustainability Report, and $30,000 to undertake Phase 2 of the Community Climate Adaptation Project. Meals, Promotions & General Expenses -$21,000 Increase mainly due to one-time film industry networking event at the CHDRC in February 2023. Software & Hardware Maintenance Contracts -($23,000) Decrease is due to one-time purchase of additional Bluebeam licenses in 2022 which were not required in 2023. Hardware Replacement -($20,000) Decrease results from the transfer of budgetted costs to the Information Technology cost centre (10405) in Corporate Services. 42 City Development Department Revenue/Transfer from Reserves -(Increases) I Decreases Ontario Grants -$203,400 Decrease results from the completion of a portion of the Streamline Development Approvals project which was funded from Provincial grants. The remainder of the funds from this grant must be spent by October 31, 2023. Department User Fees -($1,155,500) Net revenue increase reflects higher fees and anticipated increase in Planning application volume within 2023 due to development activity. ($179,000) revenue increase within the Sustainability cost centre reflects new cost recovery allocations related to staff review of development applications. Other User Fees -$106,500 Decrease in revenue reflects the completion of the Integrated Sustainable Design Standards, which was one-time funded through grants by The Atmospheric Fund and the Region of Durham. Licences & Permits -($957,800) Revenue increase reflects higher fees and anticipated increase in building permit application volume within 2023 due to development activity. Cost Recoveries -$375,400 Decrease represents completion of studies at earlier phases, funded in whole or in part from developers, for peer review of technical studies, submitted in support of development applications for preparation of the northeast Pickering secondary plan. Transfers From Reserves -$104,200 Decrease represents completion of a number of studies, which requires less funding going forward. Transfers from Development Charges -$147,700 Decrease represents completion of a number of studies funded from Development Charges, which requires less funding going forward. 43 City Development Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 2022 Building Services Permits Issued 1,021 1,297 1,699 Number of Inspections 12,117 11,490 13,657 Number of Investigations 204 1651 201 1 Planning Applications To P&D Committee & Council (official plan, 27 24 22 zoning, subdivision and condominium plans2) To Committee of Adjustment 71 113 132 To Site Plan Committee 26 29 22 To Heritaqe Committee/Deleqated 3 7 2 Comments On policy initiatives of other 5 12 9 On Land Divisions 8 28 31 Pre-consultations 19 35 28 Requests Geomatics Requests (e.g., mapping, 413 438 479 addressing, program queries and updates, open data portals) Leqal, Vehicle & Zoning Compliance 115 190 143 Zoninq Information Requests N/A N/A 187 Site Plan Approvals Issued 6 8 19 Special Studies, Projects, Reviews Underway 4 9 10 Film Location Permits Issued(# & revenue) 16 24 -$6,000 29 -$7,250 Filming in Parks/Facilities/ Pickering Museum N/A 7 -$14,000 5 -$9,555 :Village(# & revenue) Film Permit enquiries -no permit issued 3 10 7 Film Backlot Lease (revenue) N/A $240,000 $360,000 Net Revenue to City Development N/A $246,000 $367,250 Estimated Revenue from all Film Activities N/A $260,000 $376,805 Reports Information 16 19 11 Recommendation/Planning 28 48 49 44 City Development Department Performance Indicators/Statistics 2020 2021 2022 Sustainability Sustainable Pickering Initiatives -Workshops/Events 4 (600 5 (386 11 (2,124 participants) participants) participants) -Trees and Shrubs Planted 690 1,360 1,569 -Pollinator Plants Planted N/A 500 535 -Farmers Market 4,550 2,400 2,600 attendees attendees 3 attendees -Virtual Farmers Market 9,571 website 9,874 website 10,114 website views views views Waste Reduction & Diversion -Doq Waste 6.4 tonnes 9.0 tonnes 7.0 tonnes -Batteries 91 372 254 kiloQrams kilograms kilograms 1 Some existing investigations carry over from previous years 2 based on applications received during the year 3 On a number of occasions, the Market was shut down early due to inclement weather 45 City of Pickering 2023 Approved Current Budget Summary City Development Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease Expenditures 4,446,281 4,668,750 Salaries & Wages 4,760 ,057 604 ,888 23,029 35,209 Overtime 18,000 24,750 1,149,254 1,193,179 Employee Benefits 1,275,184 173,555 1,817 1,493 Uniforms 4,900 150 5,098 6,743 Conferences 21,325 5,100 28,627 14,357 Seminars & Education 50,530 3,120 10,186 16,159 Travel 28,870 (500) 141 -Freight , Express & Cartage -- 6 ,842 9 ,636 Cellular Phones 14 ,700 2 ,100 15,279 16,048 Telephone & Data 16,995 3,305 2,227 2,097 Internet 2,125 - 6,138 5,704 Advertising 19,000 8 ,750 943 1,386 Trade Shows.Exhibits & Displays 2,500 500 7,754 9,944 Subscriptions & Publications 8 ,900 - 4 ,579 -Brochures/Newsletters Printing 11,000 (11,000) -141 Photo, Mapping , Print 3,250 1,800 27,120 27,120 Insurance Premium 27,120 2,712 1,935 2 ,743 Insurance Deductible 2,000 2,000 388,064 548,301 Consulting & Professional Fees 2,317,140 (431,980) 3,576 1,889 Meals, Promotions & General 17,450 21,000 25,171 30,394 Memberships 37,535 2,385 2,850 4,868 Outside Agency Services 15,500 (2,700) -1,029 Building -Repairs & Maintenance -- 877 803 Vehicle -Repairs & Maintenance 2 ,000 - --Gas , Oil, Tire, Etc. 3,000 - --Building Rentals 300 - 20,293 10,146 Misc. Equip . Rentals 10,150 - 4 ,893 8,915 Stationary & Office Supplies 23,700 (1,050) 488 265 Forms 3,000 6,000 92,239 102,450 Programs & Event Supplies 148 ,545 (1,795) 783 231 Supplies & Tools 2,300 - -399 Gift Shop/Plaques 500 - --COVID Related Expenses 2 ,500 (2 ,500) 141 ,894 170,135 Software & Hardware Mtce. Contracts 335,648 (23 ,003) 208 -Hardware Replacements 20,000 (20,000) 6,418,586 6,890,534 Total Expenditures 9,205,724 367,587 46 Run Date: Sep 13 , 2023 2023 Approved %Change Budget From 2022 5 ,364,945 12 .71% 42,750 137.50% 1,448,739 13.61% 5,050 3.06% 26,425 23 .92% 53,650 6 .17% 28,370 (1 .73%) --% 16,800 14.29% 20,300 19.45% 2,125 -% 27,750 46.05% 3 ,000 20.00% 8,900 -% -(100 .00%) 5,050 55.38% 29,832 10.00% 4,000 100.00% 1,885 ,160 (18.64%) 38,450 120.34% 39,920 6.35% 12,800 (17.42%) --% 2 ,000 -% 3,000 -% 300 -% 10,150 -% 22,650 (4.43%) 9,ooci 200 .00% 146.750 (1.21 %) 2,300 -% 500 -% -(100 .00%) 312,645 (6 .85%) -(100 .00%) 9,573,311 3.99% City of Pickering 2023 Approved Current Budget Summary City Development Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease Revenues (8,800) (96,958) Ontario Grants (590,995) 203,365 -(92,495) Other Agency Grants -- (1,324,931) (1,995,022) Department User Fees (1,430,500) (1,155,500) (15,433) (9,819) Event Vendor Fees (12,250) - (11,375) (1,365) Other User Fees (106,495) 106,495 (3,763,431) (4 ,099,440) Licences & Permits (3,522,500) (957,750) (6,000) -Municipal Rentals -- (1,000) (2 ,025) Fines & Charges -- -(4,884) Donations (500) (2,500) --Sustainability Sponsorships (2,000) - --Sustain Mkt Sponsors (2,000) - --Rebates & Incentives -- (46,994) (42,704) Cost Recoveries (933,390) 375,390 (5,177,964) (6,344,712) Total Revenues (6,600,630) (1,430,500) Transfers (91 ,350) (86 ,856) Transfer to/(from) DC Oblg RF (424,395) 147,690 74,470 (122,403) Transfer to(from) Cntg Sty Res. (79,520) 54,220 --Transfer to(from) Reserve (323,845) 49,940 -(15,999) Transfer to (from) Oblig RF (25,000) - (16,880) (225,258) Total Transfers (852,760) 251,850 1,223,742 320,564 Net Expenditures (Revenues) 1,752,334 (811,063) Cherrywood Development --Salaries & Wages -86 ,100 --Overtime -2,500 --Employee Benefits -25,830 --Uniforms -400 --Seminars & Education -1 ,200 --Subscriptions & Publications -. 500 --Memberships -2,000 --Stationary & Office Supplies -100 --Supplies & Tools -100 --Software & Hardware Mtce . Contracts -4,000 47 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 (387,630) (34.41%) -- % (2,586,000) 80.78% (12,250) -% -(100 .00%) (4,480,250) 27 .19% -- % -- % (3,000) 500 .00% (2 ,000) - % (2,000) - % -- % (558,000) (40.22%) (8,031,130) 21.67% (276,705) (34 .80%) (25,300) (68 .18%) (273,905) (15.42%) (25,000) - % (600,910) (29.53%) 941,271 (46.28%) 86,100 -% 2,500 - % 25,830 -% 400 - % 1,200 - % 500 -% 2,000 - % 100 - % 100 - % 4,000 -% City of Pickering 2023 Approved Current Budget Summary City Development Department 2021 2022 2022 Actuals Actuals Account Description Approved Incr ease/ Budget Decrease --Misc. Equipment -10,000 --Department User Fees -(89 ,100) --Transfe r to(from) Reserve -(4 3 ,630) - - Net Expenditures (Revenues) -- Office of Affordability --Salaries & Wages -24 ,200 --Employee Benefits -7,240 --Net Expenditures (Revenues) -31 ,440 1,223,742 320 ,564 Total Net Expenditures (Revenues) 1,752,334 (779,623) 48 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 10 ,000 - % (89 ,100) - % (43,630) - % --% 24,200 -% 7,240 -% 31,440 - % 972,711 (44.49%) City of Pickering 2023 Approved Current Budget Summary 10100 City Development-Admin 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease Expenditures 428,656 425,460 Salaries & Wages 456,718 16,901 -2,673 Overtime 500 - 110,917 112,451 Employee Benefits 129,430 2,062 -162 Uniforms -- -300 Conferences 1,000 - -585 Seminars & Education 2,500 - -42 Travel 500 - 233 906 Cellular Phones 800 - 1,830 2 ,044 Telephone & Data 2,125 275 278 267 Internet 265 - 6,573 6,575 Subscriptions & Publications 4,500 (4,500) 3,170 3,170 Insurance Premium 3,170 317 --Consulting & Professional Fees 350,000 (227,000) 102 235 Meals, Promotions & General 500 - 270 378 Memberships 500 - 20,293 10,146 Misc. Equip . Rentals 10,150 - 986 1,889 Stationary & Office Supplies 4,550 (1,550) --Supplies & Tools 100 - --COVID Related Expenses 500 (500) 140,229 150,234 Software & Hardware Mice. Contracts 284,313 (22,553) 713,537 717,517 Total Expenditures 1,252,121 (236,548) Revenues --Ontario Grants (410,000) 267,000 (6,215) (18,805) Department User Fees (2,000) - (6,215) (18,805) Total Revenues (412,000) 267,000 Transfers --Total Transfers -- 707,322 698,712 Net Expenditures (Revenues) 840 ,121 30 ,452 49 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 473,619 3 .70% 500 - % 131,492 1 .59% -- % 1,000 - % 2,500 - % 500 - % 800 -% 2,400 12 .94% 265 - % -(100 .00%) 3,487 10.00% 123,000 (64.86%) 500 - % 500 - % 10,150 -% 3,000 (34 .07%) 100 - % -(100 .00%) 261,760 (7 .93%) 1,015,573 (18.89%) (143,000) (65 .12%) (2,000) -% (145 ,000) (64.81%) -- % 870,573 3.62% City of Pickering 2023 Approved Current Budget Summary 10105 Planning & Design 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 2,112,966 2,235,031 Salaries & Wages 2,495,233 198,183 11,535 17,338 Overtime 7,000 23,250 523,386 560,067 Employee Benefits 634,695 53,908 352 464 Uniforms 600 - 3,702 850 Conferences 7,000 2,000 7,226 3,022 Seminars & Education 12,350 (100) -572 Travel 3,450 (500) 1,089 2,551 Cellular Phones 4,000 - 5,752 6,417 Telephone & Data 6,675 2,425 875 838 Internet 835 - --Advertising 11,000 7,000 11 -Trade Shows.Exhibits & Displays -- --Subscriptions & Publications -4,500 -141 Photo, Mapping, Print 2,000 - 13,410 13,410 Insurance Premium 13,410 1,341 --Insurance Deductible 1,000 - 221,615 381,633 Consulting & Professional Fees 1,662,750 (111,590) 153 17 Meals, Promotions & General 850 20 ,000 12,964 14,338 Memberships 14,830 500 --Outside Agency Services 10,000 (7,500) --Building Rentals 300 - 2,605 4,880 Stationary & Office Supplies 10,000 (500) --Supplies & Tools 200 - --COVID Related Expenses 500 (500) 912 3,229 Software & Hardware Mtce. Contracts 3,615 (355) --Hardware Replacements 10,000 (10,000) 2,918,553 3,244,798 Total Expenditures 4,912,293 182,062 Revenues -(91,079) Ontario Grants (180,995) (63 ,635) (1,280,164) (1,945,250) Department User Fees (1,283,500) (1,081,000) (248,250) (367,500) Licences & Permits (322,500) (57,750) (46,994) (42,704) Cost Recoveries (795,000) 336,000 (1,575,408) (2,446,533) Total Revenues (2,581,995) (866,385) Transfers 50 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 2,693,416 7.94% 30,250 332 .14% 688,603 8.49% 600 - % 9,000 28.57% 12,250 (0.81 %) 2,950 (14.49%) 4,000 - % 9,100 36 .33% 835 -% 18,000 63.64% --% 4,500 -% 2,000 - % 14,751 10.00% 1,000 - % 1,551,160 (6 .71%) 20 ,850 2,352 .94% 15,330 3.37% 2,500 (75.00%) 300 - % 9,500 (5 .00%) 200 - % -(100 .00%) 3,260 (9 .82%) -(100 .00%) 5,094,355 3.71% (244,630) 35.16% (2,364,500) 84 .22% (380,250) 17.91% (459,000) (42 .26%) (3,448,380) 33.55% City of Pickering 2023 Approved Current Budget Summary 10105 Planning & Design 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease (91,350) (86,856) Transfer to/(from) DC Oblg RF (424,395) 147,690 88 ,684 (101,907) Transfer to(from) Cntg Sty Res . (79,520) 54,220 --Transfer to(from) Reserve (323,845) 49,940 -(5,381) Transfer to (from) Oblig RF -- (2,666) (194,144) Total Transfers (827,760) 251,850 1,340,479 604,121 Net Expenditures (Revenues) 1,502,538 (432,473) Cherrywood Development --Salaries & Wages -86,100 --Overtime -2 ,500 --Employee Benefits -25,830 --Uniforms -400 --Seminars & Education -1,200 --Subscriptions & Publications -500 --Memberships -2 ,000 --Stationary & Office Supplies -100 --Supplies & Tools -100 --Software & Hardware Mtce. Contracts -4 ,000 --Misc. Equipment -10,000 --Department User Fees -(89 ,100) --Transfer to(from) Reserve -(43 ,630) - - Net Expenditures (Revenues) - - Office of Affordability --Salaries & Wages -24,200 --Employee Benefits -7,240 --Net Expenditures (Revenues) -31,440 1,340,479 604,121 Total Net Expenditures (Revenues) 1,502,538 (401,033) "51 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 (276,705) (34.80%) (25,300) (68 .18%) (273 ,905) (15.42%) -- % (575,910) (30.43%) 1,070,065 (28.78%) 86,100 - % 2,500 - % 25,830 -% 400 - % 1,200 - % 500 -% 2,000 - % 100 -% 100 -% 4,000 -% 10,000 - % (89,100) - % (43,630) - % -- % 24,200 -% 7,240 -% 31,440 - % 1,101,505 (26.69%) City of Pickering 2023 Approved Current Budget Summary 10110 Building Services 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease Expenditures 1 ,527,3 64 1,632,338 Salaries & Wages 1,412,001 348,019 11,495 13,148 Overtime 10,000 - 407 ,427 443,101 Employee Benefits 401,463 101 ,790 1,466 653 Uniforms 4,000 - 300 3,823 Conferences 7 ,800 2 ,100 21,172 10,750 Seminars & Education 30,300 - 9 ,910 15,162 Travel 22,600 - 4,008 4 ,586 Cellular Phones 7,700 1,400 6,389 6,417 Telephone & Data 6 ,675 425 874 838 Internet 835 - 939 3 ,369 Subscriptions & Publications 4,000 - 4 ,579 -Brochures/Newsletters Printing 11,000 (11 ,000) 7 ,520 7,520 Insurance Premium 7 ,520 752 1,935 2 ,743 Insurance Deductible 1 ,000 2 ,000 141,114 53,856 Consulting & Professional Fees 138,390 (43,390) 988 187 Meals, Promotions & General 5,900 - 8,316 12,241 Memberships 17,805 1 ,550 -1,029 Building -Repairs & Maintenance -- 877 803 Vehicle -Repairs & Maintenance 2,000 - --Gas, Oil, Tire, Etc. 3,000 - 1,043 1,682 Stationary & Office Supplies 8 ,000 - 488 265 Forms 3,000 6,000 783 231 Supplies & Tools 2,000 - --COVID Related Expenses 1,000 (1 ,000) 583 16,202 Software & Hardware Mtce. Contracts 47,195 (85) 208 -Hardware Replacements 10,000 (10,000) 2,159,778 2,230,944 Total Expenditures 2,165,184 398,561 Revenues (38 ,551) (30,968) Department User Fees (35 ,000) (5 ,000) (3 ,515,181) (3,731,940) Licences & Permits (3 ,200,000) (900,000) (1,000) (2,025) Fines & Ch a rges -- --Cost Recoveries (138,390) 43,390 (3 ,554,732) (3 ,764,933) Total Revenues (3,373,390) (861,610) Transfers 52 Run Date : Sep 13 , 2023 2023 Approved %Change Budget From 2022 1 ,760,020 24.65% 10,000 -% 503,253 25 .35% 4 ,000 -% 9,900 26 .92% 30,300 -% 22,600 -% 9 ,100 18.18% 7,100 6 .37% 835 -% 4 ,000 -% -(100 .00%) 8,272 10.00% 3 ,000 200 .00% 95,000 (31 .35%) 5,900 -% 19,355 8 .71 % --% 2 ,000 -% 3,000 -% 8,000 -% 9,000 200 .00% 2 ,000 -% -(100.00%) 47,110 (0 .18%) -(100 .00%) 2,563,745 18.41% . (40,000) 14.29% (4,100 ,000) 28 .13% --% (95 ,000) (31 .35%) (4,235,000) 25.54% City of Pickering 2023 Approved Current Budget Summary 10110 Building Services 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease (14,214) (20,496) Transfer to(from) Cntg Sty Res . -- (14,214) (20,496) Total Transfers -- (1,409 ,168) (1,554,485) Net Expenditures (Revenues) (1,208,206) (463,049) 53 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 --% --% (1,671,255) 38.33% 10115 Sustainability 2021 2022 Actuals Actuals -- -- (41,608) (114,442) -(10,618) -(10,618) 569,368 559,090 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase I Budget Decrease Rebates & Incentives -- Cost Recoveries -(4,000) Total Revenues (233,245) 30,495 Transfers Transfer to (from) Oblig RF (25,000) - Total Transfers (25,000) - Net Expenditures (Revenues) 589,364 53,221 55 Run Date : Sep 13 , 2023 2023 Approved % Change Budget From 2022 -- % (4 ,000) - % (202,750) (13.07%) (25 ,000) -% (25,000) - % 642,585 9.03% City of Pickering 2023 Approved Current Budget Summary 10120 Committee of Adjustment 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 7,080 5,760 Salaries & Wages 7,200 1,200 543 438 Employee Benefits 1,022 (514) 250 -Conferences 1,000 - --Seminars & Education 200 100 259 124 Travel 820 - 750 675 Memberships 750 - 8,882 6,997 Total Expenditures 10,992 786 Revenues - - Total Revenues -- Transfers - - Total Transfers - - 8,882 6,997 Net Expenditures (Revenues) 10,992 786 56 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 8,400 16.67% 508 {50.29%) 1,000 -% 300 50 .00% 820 -% 750 -% 11,778 7.15% -- % -- % 11,778 7.15% City of Pickering 2023 Approved Current Budget Summary 10125 Heritage Pickering 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease Expenditures -483 Confe re nces 525 - --Seminars & Education 300 - 17 193 Travel 500 - --Photo, Mapping, Print 250 - 6,773 5 ,024 Consulting & Professional Fees 15 ,000 - -31 Meals , Promotions & General 200 - 75 -Memberships 100 - --Stationary & Office Supplies 150 - -399 Gift Shop/Plaques 500 - 6,865 6,130 Total Expenditures 17,525 - Revenues --Total Revenues - - Transfers --Total Transfers - - 6,865 6,130 Net Expenditures (Revenues) 17,525 - 57 Run Date : Sep 13, 2023 2023 Approved %Change Budget From 2022 525 -% 300 - % 500 - % 250 - % 15 ,000 - % 200 -% 100 - % 150 -% 500 -% 17,525 -% -- % -- % 17,525 - % Community Services Department Overview The Community Services Department is responsible for all matters relating to recreation and culture services including recreation programs, memberships, cultural opportunities and special events. The department provides Pickering residents with high quality culture and recreation activities at a variety of City owned facilities including: • Chestnut Hill Developments Recreation Complex (CHDRC) (aquatics centre, fitness/health club, racquet courts, twin ice pad arena, banquet halls/meeting rooms) • Don Beer Arena (3 ice pads) • Dunbarton Indoor Pool (25 metre pool) • Community Centres (East Shore Community Centre, West Shore Community Centre, George Ashe Community Centre and northern facilities) • Pickering Museum Village (19 heritage buildings) In addition, the Community Services Department is responsible for the operation and maintenance of all City owned facilities including the Civic Complex. Community Services Department Culture & Recreation & Facilities I I I I r-[ r ', Recreation Cultural Aquatics & Facilities Community Services Services Fitness Maintenance Services \_ J '-,, '-Administration J ' J Responsibility for Corporate Security will be transferred from the Operations Department in 2023. Corporate Security is responsible for the centralized management and integration of security into our facilities, events and infrastructure. 58 Community Services Department Key Activities for 2023 • Return to regular service delivery for registered and drop-in programs affected by COVID and CHRDC Renovations • Implement marketing and communications initiatives to increase membership and participation • Return to a full line-up of community festivals and events • Undertake Recreation User Fee Study to establish a framework to inform the development of a Pricing Policy, and establish a process for updating and monitoring recreation fees and charges. The Recreation User Fees Study will contribute to the strategic goals of maintaining a fiscally sustainable system of community services facilities and programs, while maximizing participation • Recreation and Parks and Master Plan renewal • Develop and implement the Community Safety and Wellbeing Plan • In partnership with the Economic Development Department, develop a Community Tourism Plan • Construct the Pickering Heritage & Community Centre at the Pickering Museum Village • Remedial construction work and development of two new permanent exhibits for the Log Barn and House at the Pickering Museum Village • Install public art at Esplanade Park (Reflections by Studio F Minus), Fire Hall #1 (Power, by Patrick Birmingham), and new permanent public art at Pickering Museum Village (funded by Government of Canada) • Complete capital projects, including the installation of pool bleachers, health club equipment replacement and banquet hall flooring • Roll out ACTIVE Net Captivate app • In partnership with Operations, Pickering Library and Engineering departments, begin development of recommended program and schematic concepts for the new Seaton Recreation Centre 59 Financial Information 2019 Community Services Department Staffing Summary (Full & Regular Part-Time) Approved Prior Term 2020 2021 2022 Approved New Term 2023 Add Transfers Convert Full-Time Reg. Part- Time Total 71 52 123 75 76 49 49 124 125 71 -2 48 -- 119 -2 * The above chart excludes contract, students and term employees 4 -4 - The following two positions will be transferred into the Department in the year: • One full-time Corporate Security Specialist (from Operations Department) • One full-time SAP Clerk (from Finance) Total 77 44 121 The department is also proposing to convert the following four positions to full-time: • Two permanent part-time Facility Attendant • One part-time Aquatics Program Assistant • One permanent part-time Facility Custodian to a Facility Attendant 60 Community Services Department Year-Over-Year (Net Cost) Budget Changes 2022 2023 Approved Approved Budget Budget Culture & Recreation -Admin $2,603,475 $3,302,896 Programs 1,059,379 725,533 Dunbarton Pool 339,364 403,764 Don Beer Arena 446,318 442,699 Community Centres 744,130 692,791 Recreation Complex -Central 2,612,036 2,587,240 Core Recreation Complex -Pool 748,821 708,808 Recreation Complex -Arenas 323,344 302,323 Civic Centre 796,058 875,338 Senior Citizens Centre 334,722 406,299 Museum 748,546 884,899 Total (Net Cost) $10,756,193 $11,332,590 Explanation of Significant Departmental Budget Changes Expenditures -Increases I (Decreases) Salaries & Benefits -$623,900 Year-Over-Year Change ($) (%) $699,421 26.86% (333,846) (31.51 %) 64,400 18.98% (3,619) (0.81 %) (51,339) (6.90%) (24,796) (0.95%) (40,013) (5.34%) (21,021) (6.50%) 79,280 9.96% 71,577 21.38% 136,353 18.22% $576,397 5.36% The budget increase reflects the transfer of salary for the full time Corporate Security Specialist from the Operations Department -$142,465 and a full time SAP Clerk from Finance -$80,710. The budget also includes additional part-time hours for Facility Maintenance at Dunbarton Pool to support Public Health Regulations -$47,850 and additional hours for part-time Security Guards at Community Centres to meet operational requirements - $21,450. In addition, two permanent part-time Facility Attendant positions will be converted to full- time and one permanent part-time Facility Custodian position will be converted to a full- time Facility Attendant. The budget increase also includes the annualization of salary & benefits for the Community Safety and Wellbeing Coordinator -$75,000 -which was a new position in 2022. 61 Community Services Department The budget includes grant funded contract positions totaling $389,675 which includes the following: • One Marketing Assistant • Two Coordinators, Public Art • One Coordinator • One intern relating to Accessibility projects • One Community Engagement Coordinator • 2 Term Coordinators, Community Events • Additional hours for Community Event Leaders Grant funded positions are only filled with confirmation of the grant funding. Salaries & Wages -Programs -$385,600 The budget increase reflects the return to regular program staffing levels across all programs. Seminars & Education -$13,400 Increase will cover costs for departmental staff training and certifications including first aid training, defibrillator training and High Five certification. The budget also includes increased expenses to cover staff recertification in Certified Pool Operations and ORFA Ice maintenance that were not offered during the pandemic. Advertising -($79,700) Increase of $7,500 in Administration to promote programming and events which is more than offset by a reduction of ($87,500) in Museum related to grant funding for special projects that was included in the 2022 Current Budget. Consulting & Professional Fees -$191,000 Increase .includes one-time funding of $197,200 to complete the Recreation and Parks Masterplan Update (75% funded from Development Charges), $30,000 for an Arena Strategy and $69,000 for the completion of the Recreation User Fee Study. These are partially offset by a reduction of ($70,400) related to the completion of the Fair-Minded Pricing Policy and ($65,000) in the Museum for grant funded projects that were included in the 2022 Current Budget. 62 Community Services Department Meals, Promotion & General Expenses -($83,100) Budgeted funds at the Senior Citizens Centre were transferred from this account to Programs & Event Supplies ($18,300) and Special Event Supplies ($55,000) accounts and adjusted to reflect current grant funding. Outside Agency Services -$102,700 Increase of $50,000 to cover summer camp bussing, $11,200 for Pre-teen dances, and $10,000 for a Seasonal Weekend Waterfront Shuttle to be funded by a third party, partially offset by a decrease of ($12,300) for removal of Swim to Survive bussing. Budget increase also due to higher facility security costs of $18,850 and the addition of Networx Council Chambers weekly support costs of $15,450. Building Repairs & Maintenance -$386,300 Increase of $33,000 due to the transfer of responsibility for waste collections service from Region of Durham to the City (July 1 start) throughout all facilities. $125,000 is required for the replacement of carpet in the court areas at CHDRC (funded from the Rate Stabilization reserve). An increase of $9,295 is for parking lot line painting within the Civic Complex parking lot and $30,000 for Main Committee Room AN upgrades. The Tomlinson Community Centre requires an increase of $22,000 for kitchen appliance replacements. There was an increase in security camera repair costs throughout facilities of $10,000 due to increase in costs of technology. $16,500 is required to install a rink seal in the O'Brien Rink floor system. There are also general increases in many line items across the 502340 accounts due to maintenance requirements of aging facilities. The above increases are partially offset by a decrease of ($13,500) due to actual costs associated with supplying free feminine hygiene products throughout facilities. Vehicle Equipment Repairs & Maintenance -$12,600 Budgeted increase reflects last year's actual costs to repair vehicles used to support Programs and the Museum. Building Rentals -$34,300 Budgeted increase for rentals charged to the Program cost center from other department cost centres. Land Rentals -$53,200 Increase is for the lease of the land for the parking lot at Don Beer Arena from Hydro One. 63 Community Services Department COVID Related Expenditures ($78,000) All COVID related expenses have been removed from the budget. These costs were previously funded by one-time COVID grant funding. Utilities -Natural Gas -$48,500 Budget increase reflects last year's rising natural gas costs and anticipated increase in natural gas prices and consumption trends. Utilities -Hydro -($38,500) Decrease based on decline in projected consumption partially offset by price increases expected in 2023. Software & Hardware Maintenance Contracts -$43,100 Increase of $31,000 is related to Security Incident Reporting software maintenance costs transferred from the Operations department budget. There is also an increase of $9,500 for Active Net Mobile Application to support memberships and programs. Furniture & Fixtures $19,000 Increase of $7,000 is for expansion of lobby furniture at the Chestnut Hill Development Recreation Centre and $12,000 to purchase new lane ropes for its pool. Revenues/Transfer from Reserves -(Increases) I Decreases Federal Grants -$456,300 In 2022 there was $1,074,339 budgeted for federal grants which included several pandemic and COVID recovery grants that will not be offered in 2023. The 2023 budgeted federal grants include Young Canada Works ($85,300), the Natural Infrastructure Fund ($100,000), Canada Summer Jobs ($119,500), Celebrate Canada ($50,000), and Museum Assistance Program -Travelling Exhibit ($64,500). New federal grants total $408,300. Several grants were confirmed in 2022, but will be implemented in 2023 including: Young Canada Works ($23,000) Healthy Communities Fund ($83,000), Legacy Fund ($61,650), Commemorate Canada Reopening Fund ($46,650), Museum Assistance Program -Access to Digital Heritage ($177,750), and the Canada Community Revitalization Fund ($31,000). Multi-year and confirmed grant funding in 2023 totals $464,050. 64 Community Services Department Ontario Grants -$149,100 The City applies for and secures several recurring provincial grants annually. In 2023, these grants are anticipated to remain consistent with 2022 revenues including the following grants: Community Museum Operating Grant ($39,000), Summer Experience Fund ($14,000), Seniors Active Living Centre Operating Grants ($85,400), Seniors Active Living Centre Special Projects Grant ($30,000), and New Horizons ($25,000). Recurring provincial grants are expected to total $228,400 in 2023. In 2023, the City of Pickering will also apply for the following project-based Provincial grants: Reconnect Fund ($80,000), EnAbling Change Grant ($90,000), and the Rural Economic Development Fund ($100,000). New provincial project-based grants are expected to total $310,000 in 2023. In 2022, the City of Pickering had $50,000 in carried-over funds that were confirmed in 2021 from the Reconnect grant, and $44,400 in carried over funds from 2021 for the Rural Economic Development Fund. Other Agency Grants -($76,000) A ($20,000) grant is budgeted to be received from the Jumpstart program and ($15,000) from Central Counties Tourism. A Canadian Race Relations Foundation grant of ($41,000) was confirmed in 2022 and will be used in 2023. Department User Fees -($10,000) Increase is related to new Electric Vehicle charging program. Rentals -Ice -($182,000) Increase to ice rental revenues reflects the return to regular operations including increased revenues of ($113,000) at Don Beer Arena and ($69,000) at Recreation Complex-Arenas. Rentals -Pool -($48,100) Increase to pool rental revenues reflects the return to regular operations including increased revenues of ($21,800) at Dunbarton Pool and ($26,200) at Recreation Complex -Pool. Rentals -Meeting Rooms -($39,700) Increase reflects the return to regular operations for various meeting rooms. 65 Community Services Department Other Rentals -($55,800) Increase in other rental revenues reflects the return to regular operations for private banquet hall rentals. Memberships -($104,500) Return of membership revenues to typical levels following Chestnut Hill Developments Recreation Complex renovations and the removal of COVID-19 restrictions. Older Adult Programs -($32,000) Increase to Older Adult Program revenue reflects return to regular operations. Program Revenue -($907,300) Increase in program revenues reflects a return to regular operations including the following increases; Dance -($26,400), Summer Camps ($340,000), Learn to Swim ($215,000), March Break ($34,000), Arts ($52,000). Preschool ($47,000), Youth ($42,000) and Kindergym ($56,000). Revenue increase also reflects the resumption of Pre-Teen Dances with revenues of ($30,000). Child Supervision -$20,000 Decrease due to discontinuation of Child Supervision as of June 1. Fitness Testing -($14,700) Increase in revenues reflects return to regular operations. Sponsorships -$20,000 Decrease in sponsorships is mainly due to a reduction in Don Beer Arena sponsorship $10,000 and removal of one-time 2022 sponsorship for Winter Lights $30,000 partially offset by budgeted increase for Public Art sponsorships ($25,000). Transfer -From Reserves -($150,000) Increase reflects Carpet replacement at CHDRC to be funded from the Rate Stabilization Reserve ($125,000). ($25,000) relates to an increase in the transfer from the Public Art Reserve to support public art projects planned for 2023. Transfer -DC Reserve -($146,700) Increase in Development Charge funding for the 2023 Recreation and Park,s Master Plan. 66 Community Services Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 2022 Cultural Services Cultural Services Virtual Events, Cultural 109,827 32,713 0 Pop-ups, on-line participants Destination Pickering Social Media 8,948 15,185 63,590 Engagement (likes, shares, comments) Live Event Attendance (Events, Partner 2,184 22,000 41,965 Events, Cultural Pop-ups) Recreation Services Programs offered 580 283 1,104 Registered participants N/A 3,464 8,134 Aquatics Programs offered 528 19 1,345 Registered participants 1,665 120 5,703 Swim members 254 177 321 Available public swim hours 1,426 1,071 3,749 Available rental hours 907 810 1,219 Individual swim admission purchases 2,383 153 9,873 Fitness Group fitness registered programs offered 96 193 161 Group fitness registered participants 412 468 679 Small group training programs offered 71 77 40 Small group training participants 149 101 206 Personal training packages sold 25 12 94 Personal fitness members 221 181 245 Health Club Health Club Members 1,261 669 1,531 Available hours 3,283 2,740 4,532 Individual admissions purchased 250 62 422 Racquet Sports Squash Members 134 78 175 Racquetball Members 20 12 29 Tennis Members 43 76 105 Golden/Combination Members 39 40 57 67 Community Services Department Performance Indicators/Statistics 2020 2021 2022 Number of available hours: Tennis 2,467 5,200 19,096 Squash & Racquetball 2,365 20,720 47,740 Number of guests Tennis 2,816 786 3,330 Squash 1,168 479 3,974 Racquetball 234 58 1,005 Number of courts booked Tennis 5,727 3,800 9,990 Squash 2,996 1,125 6,730 Doubles Squash 774 226 2,436 Racquetball 839 149 2,011 Pickering Museum Village Museum visitors and program participants 7,183 9,248 10,515 Facilities Operations -Arena CHDRC total hours of ice rental 1,256 2,230 5,980 OBA total hours of ice rental 3,127 3,282 10,301 CHDRC total hours of arena floor time rental 210 98 104 OBA total hours of arena floor time rental 0 1,155 535 OBA Banquet Hall rental hours 397 1,003 1,526 O'Brien Meeting Room rental hours 1,485 3,124 2,977 • Volunteers dedicated 5,875 hours or $146,875 to the Pickering Museum Village in 2022 68 City of Pickering 2023 Approved Current Budget Summary Community Services Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 6,508,154 8,208,676 Salaries & Wages 8,647,928 524 ,260 554,228 807,297 Salaries & Wages -Programs 886,995 385,625 108,294 214,141 Overtime 183,779 15,400 1,672,641 1,895,816 Employee Benefits 2,132,543 114,496 30,099 36,084 Uniforms 45,860 9,200 -4,173 Conferences 6 ,965 500 14,490 12,358 Seminars & Education 41,434 13,378 1,658 6,747 Travel 15,625 (5,025) 622 3,638 Freight, Express & Cartage 2,500 5,000 -52 Environmental Charges -- 31,628 32,417 Cellular Phones 36,090 630 74,875 70,268 Telephone & Data 77,995 1,105 11,823 14,614 Internet 15,540 (450) 2,016 6 ,509 Cable TV 5 ,985 650 234,771 345,140 Advertising 327,800 (65,950) 13,826 151,621 Trade Shows,Exhibits & Displays 210,300 9 ,200 622 94 Subscriptions & Publications 350 200 31 ,254 56,109 Brochures/Newsletters Printing 60,000 7,000 4,509 -Photo, Mapping, Print 9,000 - 64,220 61,896 Insurance Premium 61,720 6,172 1,840 4,855 Insurance Deductible 11,000 - 102 ,877 35,882 Consulting & Professional Fees 152,400 190,987 40,504 66,939 Meals, Promotions & General 113,630 (83,130) 10,784 10,446 Memberships 16,212 187 197,203 237,345 Outside Agency Services 226,814 102,648 -814 Repairs & Maintenance Materials -- -90 Highway Aids -Repairs & Maintenance -- 929,136 1,402,224 Building -Repairs & Maintenance 1,348,765 386,287 14,299 21,991 Vehicle -Repairs & Maintenance 10,300 12,600 16,107 26,501 Gas, Oil, Tire, Etc . 13,850 6,000 40,331 34,111 Misc. Equip. -Repairs & Maintenance 79,675 (3,000) 11,098 9,468 Artefact Repairs & Maintenance 8,700 - 1,105 370 Grounds Upkeep 2,800 - 75,295 214,555 Building Rentals 215,910 34,310 990 582 Misc. Equip . Rentals 9,600 - 37,235 40,820 Land Rentals 46,150 53,195 69 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 9,172 ,188 6.06% 1,272,620 43.48% 199,179 8 .38% 2,247,039 5 .37% 55,060 20.06% 7,465 7 .18% 54,812 32 .29% 10,600 (32 .16%) 7,500 200 .00% --% 36,720 1 .75% 79,100 1.42% 15,090 (2.90%) 6,635 10.86% 261,850 (20.12%) 219,500 4 .37% 550 57.14% 67,000 11.67% 9,000 -% 67,892 10.00% 11,000 - % 343,387 125.32% 30,500 (73.16%) 16,399 1 .15% 329,462 45.26% --% --% 1,735,052 28.64% 22,900 122.33% 19,850 43.32% 76,675 (3 .77%) 8,700 -% 2,800 - % 250,220 15.89% 9,600 -% 99,345 115.27% City of Pickering 2023 Approved Current Budget Summary Community Services Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease 13,613 13,698 Stationary & Office Supplies 11,050 3,400 639 -Forms 1,900 - 241,240 610,888 Programs & Event Supplies 1,122,875 32,350 3,628 2,297 Special Event Supplies 34,000 61,000 60,013 28,012 Committee Expenses 29,500 (7,500) 18,266 31,134 Supplies & Tools 58,011 200 596 114 Artefact Purchases 600 - 2,945 3,610 Gift Shop/Plaques 5 ,000 - --COVID Related Expenses 78,000 (78,000) 94,452 120,294 Utilities -Water 163,370 2 ,000 702,342 904,262 Utilities -Hydro 1,154,661 (38,499) 169,678 265,494 Utilities -Natural Gas 240,575 48,500 4,202 7,067 Utilities -Oil 5,683 684 70 ,063 23,727 Software & Hardware Mtce. Contracts 26,525 43,112 247 -Hardware Replacements -- 4,288 3,863 Furniture & Fixtures 53,000 19,000 6 ,369 8,204 Misc. Equipment 9,800 6,000 1,864 3,086 Miscellaneous Expenses -- 44,388 156,349 Financial Services Charges 175,000 - -7,334 Memberships -- 12,277,367 16,224,076 Total Expenditures 18,193,765 1,813,722 Revenues (197,976) (729,700) Federal Grants (1 ,330,652) 456,302 (392,087) (329,035) Ontario Grants (616,480) 149,080 (8,000) (25,167) Other Agency Grants -(76 ,000) --Department User Fees -(10,000) (9,897) (11,639) Gift Shop (11,600) - -(763) Snack Bar (11,654) 1,504 (1,005) (11,484) Vending Machines (15,500) (1,100) (148,971) (288,639) Admissions (347,619) 3,761 -(1 ,543) Rentals -User Fees (2 ,906) (1,694) (670,192) (1,419,888) Rentals -Ice Surface (1,527 ,000) (182,000) (16 ,911) (21,509) Rentals -Arena Floor (50,000) - (43,971) (210,105) Rentals -Pool (226,320) (48,080) (9,996) (63,323) Rentals -Meeting Rooms (68,000) (39,700) 2,561 (81,425) Rentals -Halls (95,000) (41,000) 70 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 14,450 30 .77% 1,900 -% 1,155,225 2.88% 95,000 179.41% 22,000 (25.42%) 58,211 0.34% 600 -% 5,000 -% -(100.00%) 165,370 1 .22% 1,116,162 (3 .33%) 289,075 20.16% 6,367 12 .04% 69,637 162.53% --% 72,000 35 .85% 15,800 61 .22% --% 175,000 -% --% 20,007,487 9.97% (874,350) (34.29%) (467,400) (24 .18%) (76 ,000) -% (10,000) -% (11,600) -% (10 ,150) (12.91%) (16,600) 7 .10% (343,858) (1.08%) (4,600) 58 .29% (1,709,000) 11 .92% (50,000) -% (274,400) 21.24% (107,700) 58.38% (136,000) 43 .16% City of Pickering 2023 Approved Current Budget Summary Community Services Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease 15 -Rentals -Misc. Equipment -- (63,480) (79 ,334) Rental -Wellness Clinic (75,000) (6,000) (32,934) (125,208) Community Ctr. Rentals (175,200) (8,780) --Advertising Space (66,000) - (120,685) (493,141) Memberships (688,118) (104,514) -(11,963) Event Vendor Fees (7,100) (2,500) (1 ,508) (3,658) Seniors Event Fees (1,000) (2,000) (16,207) (41,351) Older Adults 55+ Programs (22,000) (32 ,000) (319,477) (1,535,209) Program Revenue (1,266,600) (907,250) (8,531) (14,001) Museum Programs (15,000) - -(3,703) Ch ild Supervision (20,000) 20 ,000 (16,167) (55,773) Fitness Testing (35,295) (14,705) (77,550) (90,378) Other User Fees (103,080) 2,580 (1,683) (3,365) Donations (5,000) - (1,062) (16,900) Sponsorships (3,000) (15,000) -(5 ,500) Program Sponsorships (7 ,000) - (4,000) (5,000) Marketing Sponsors (84,500) 40,000 (26,562) (13,715) Program Mk! Sponsors (35,000) (5,000) (20,000) -Other Contributions -- --Cost Recoveries -(10,000) (352,223) (353,648) Netted Revenue (365,548) 30,358 (2,558,499) (6,046,067) Total Revenues {7,277,172) (803,738) Transfers -41,000 Capital Expenditures -- --Transfer to/(from) DC Oblg RF (70,400) (146,687) (19,158) 60,506 Transfer to(from) Cntg Sty Res . -- 10,481 62,843 Transfer to(from) Reserve (90,000) (286,900) -(290) Transfer to (from) Oblig RF -- (8,677) 164,059 Total Transfers (160,400) (433,587) 9,710,191 10,342,068 Net Expenditures (Revenues) 10,756,193 576,397 Cherrywood Development --Consulting & Professional Fees -50,000 --Other Contributions -(50,000) - - Net Expenditures (Revenues) -- 71 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 -- % (81,000) 8 .00% (183,980) 5 .01% (66,000) -% (792,632) 15.19% (9,600) 35.21% (3,000) . 200 .00% (54,000) 145.45% (2,173,850) 71.63% (15,000) - % -(100 .00%) (50,000) 41 .66% (100,500) (2 .50%) (5 ,000) - % (18,000) 500.00% (7,000) -% (44 ,500) (47.34%) (40,000) 14.29% --% (10,000) - % (335,190) (8.30%) (8,080,910) 11.04% -- % (217,087) 208 .36% --% (376 ,900) 318 .78% --% (593,987) 270.32% 11,332,590 5.36% 50,000 - % (50 ,000) -% -- % City of Pickering 2023 Approved Current Budget Summary Community Services Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease 9,710,191 10,342,068 Total Net Expenditures (Revenues) 10,756,193 576,397 72 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 11 ,332,590 5.36% City of Pickering 2023 Approved Current Budget Summary 10200 Culture & Recreation -Admin 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease Expenditures 1 ,823,268 1,661,719 Salaries & Wages 1,721,908 541,069 13,264 6,015 Overtime 20,335 - 496,684 433,770 Employee Benefits 479 ,002 113,997 1,404 -Uniforms 2,500 - -2,977 Conferences 6,965 500 90 993 Seminars & Education 6,000 150 124 795 Travel 2,000 - 12,609 12,784 Cellular Phones 10,000 480 9 ,106 7,153 Telephone & Data 9,405 195 875 1,590 Internet 2,445 (700) 109,056 142,019 Advertising 143,600 7,500 --Trade Shows .Exhibits & Displays -5,000 453 -Subscriptions & Publications -200 4,509 -Photo, Mapping, Print 9,000 - 10,750 8,250 Insurance Premium 8 ,250 825 46,443 4,681 Consulting & Professional Fees 70,400 255,987 390 9,900 Meals, Promotions & General 9,000 - 4,751 5,385 Memberships 8,150 (3,485) 5,287 -Outside Agency Services -- -90 Highway Aids -Repairs & Maintenance -- -402 Building -Repairs & Maintenance -- 1,452 1,988 Vehicle -Repairs & Maintenance -- 1,820 272 Gas, Oil , Tire, Etc. -- 72 ,722 72,861 Building Rentals 73,400 1,910 2,682 4,483 Stationary & Office Supplies 4 ,300 - 10,330 166,436 Programs & Event Supplies 432,000 (2,000) -25 · Special Event Supplies -- 60,013 26,750 Committee Expenses 29 ,500 (7,500) 2,034 1,775 Supplies & Tools -- 60,229 6,270 Software & Hardware Mtce . Contracts 4,265 29,730 2,171 2,020 Furniture & Fixtures 1,000 - 44,388 156,349 Financial Services Charges 175,000 - 2,796,904 2,737,752 Total_ Expenditures 3,228,425 943,858 Revenues -(151,832) Federal Grants (399,550) 27,250 73 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 2,262,977 31.42% 20,335 - % 592,999 23.80% 2,500 -% 7,465 7.18% 6,150 2 .50% 2 ,000 - % 10,480 4 .80% 9,600 2 .07% 1,745 (28.63%) 151,100 5 .22% 5,000 - % 200 - % 9,000 -% 9,075 10.00% 326,387 363.62% 9,000 -% 4,665 (42.76%) --% -- % -- % -- % --% 75,310 2 .60% 4,300 - % 430 ,000 (0.46%) --% 22,000 (25.42%) --% 33,995 697 .07% 1,000 -% 175,000 - % 4,172,283 29.24% (372 ,300) (6.82%) City of Pickering 2023 Approved Current Budget Summary 10200 Culture & Recreation -Adm in 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease (36,656) (5,000) Ontario Grants (10,000) (115 ,000) -(14 ,200) Sponsorships -(15 ,000) --Marketing Sponsors (65,000) 40,000 (20 ,000) -Other Contributions -- (56,656) (171,032) Total Revenues (474,550) (62,750) Transfers --Transfe r to/(from) DC Oblg RF (70,400) (146,687) (17,861) 60,506 Transfer to(from) Cntg Sty Res . -- 10,481 (12 ,157) Transfer to(from) Reserve (80 ,000) (35 ,000) -(290) Transfer to (from) Oblig RF -- (7,380) 48,059 Total Transfers (150,400) (181,687) 2,732,868 2,614,779 Net Expenditures (Revenues) 2,603,475 699,421 Cherrywood Development --Consulting & Professional Fees -50 ,000 --Other Contributions -(50,000) --Net Expenditures (Revenues) -- 2,732,868 2,614,779 Total Net Expenditures (Revenues) 2,60-3,475 699,421 74 Run Date : Sep 13 , 2023 2023 Approved % Change Budget From 2022 (125,000) 1,150.00% (15,000) -% (25,000) (61 .54%) --% (537,300) 13.22% (217 ,087) 208 .36 % --% (115,000) 43 .75% --% (332,087) 120.80% 3,302,896 26.86% 50,000 -% (50,000) -% --% 3,302,896 26.86% 10205 Programs 2021 2022 Actuals Actuals 452,159 658,279 554,228 807,297 24,626 24,593 177,729 200,706 3,394 6,590 -1 6,004 365 963 2,938 -935 1,292 1,753 1,828 2,033 277 266 -1,129 150 - 29,039 56,109 9,500 9,500 1,074 6,951 1,323 1,250 1,000 32,560 -- 282 6,522 -- 2,551 141 ,662 4,049 1,153 -- 203,241 391,309 -1,262 -3,449 386 854 547 1,171 -11 1,475,642 2,360,648 (50,265) (107,783) (30,000) (53,407) City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase I Budget Decrease Expenditures Salaries & Wages 734,664 33,064 Salaries & Wages -Programs 886,995 385,625 Overtime 16,900 14,400 Employee Benefits 203,559 (10,074) Uniforms 5,000 - Conferences -- Seminars & Education 4,150 2,450 Travel 3,200 - Freight, Express & Cartage -- Cellular Phones 4,000 - Telephone & Data 2,125 875 Internet -300 Advertising -13,750 Subscriptions & Publications 100 - Brochures/Newsletters Printing 60,000 7,000 Insurance Premium 9,500 950 Meals, Promotions &.General 3,000 - Memberships 1,500 - Outside Agency Services 12,306 58,894 Vehicle -Repairs & Maintenance -6,600 Gas, Oil, Tire, Etc . -- Misc. Equip . -Repairs & Maintenance 200 - Building Rentals 142,500 32,400 Stationary & Office Supplies -- Forms 500 - Programs & Event Supplies 683,575 12,550 Committee Expenses -- Supplies & Tools 2,400 - Software & Hardware Mice. Contracts 955 1,470 Misc. Equipment 5,000 2,000 Miscellaneous Expenses -- Total Expenditures 2,782,129 562,254 Revenues Federal Grants (174,000) 24,000 Ontario Grants (206,050) 164,050 75 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 767,728 4.50% 1,272,620 43.48% 31,300 85 .21% 193,485 (4 .95%) 5,000 -% -- % 6,600 59.04% 3,200 - % --% 4,000 -% 3,000 41.18% 300 -% 13,750 - % 100 - % 67,000 11.67% 10,450 10.00% 3,000 - % 1,500 - % 71,200 478.58% 6,600 - % -- % 200 - % 174,900 22.74% -- % 500 - % 696,125 1.84% --% 2,400 -% 2,425 153.93% 7,000 40 .00% --% 3,344,383 20.21% (150,000) (13.79%) (42,000) (79.62%) 10205 Programs 2021 2022 Actuals Actuals (8,000) (10,167) -- -(11 ,963) (319,477) (1 ,535,209) -(4,900) -(5,500) (26,562) (13 ,715) -- (434,304) (1,742,644) -- -- 1,041,338 618,004 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase I Budget Decrease Other Agency Grants -(20,000) Advertising Space (11 ,000) - Event Vendor Fees (7 ,100) (2 ,500) Program Revenue (1 ,266,600) (907 ,250) Other User Fees (16 ,000) (2,500) Program Sponsorsh ips (7,000) - Program Mkt Sponsors (35,000) (5 ,000) Cost Recove ries -(10,000) Total Revenues (1,722,750) (759,200) Transfers Transfer to(from) Reserve -(136,900) Total Transfers -(136,900) Net Expenditures (Revenues) 1,059,379 (333,846) 76 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 (20,000) -% (11,000) -% (9 ,600) 35 .21 % (2 ,173,850) 71.63% (18,500) 15.63% (7 ,000) -% (4 0 ,000) 14.29 % (10,000) -% (2,481,950) 44.07% (136,900) -% (136,900) -% 725,533 (31.51%) City of Pickering 2023 Approved Current Budget Summary 10210 Dunbarton Pool 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 248,953 145,903 Salaries & Wages 264,574 65 ,843 4 ,150 4,834 Overtime 2,200 - 40,716 39,126 Employee Benefits 69,951 12 ,189 349 1,616 . Uniforms 2 ,000 1,820 572 506 S eminars & Education 2 ,186 3 ,964 -115 Travel 200 - -12 Environmental Charges -- 660 511 Cellular Phones 1,040 - 4,621 3,454 Telephone & Data 4,240 (340) 270 1,511 Internet 870 700 1,720 1,720 Insurance Premium 1,720 172 8,800 -Consulting & Professional Fees -- 102 -Memberships 110 1,101 1,189 1,198 Outside Agency Services 2 ,113 - -523 Repai rs & Maintenance Materials -- 27,016 37,763 Building -Repairs & Maintenance 44,915 6 ,700 1,193 1,025 Misc. Equip . -Repairs & Maintenance 3 !000 - 126 31 Stationary & Office Supplies 200 - 1,585 599 Supplies & Tools 8 ,661 - --COVID Related Expenses 5 ,000 (5,000) 20,674 27,395 Utilities -Natural Gas 32,180 500 113 348 Software & Hardware Mtce . Contracts 390 5 --Furniture & Fixtures 3,000 - 362,809 268,190 Total Expenditures 448 ,550 87,654 Revenues (2,167) (2,522) Admissions (4,228) (772) (43 ,971) (93 ,286) Rentals -Pool (97,624) (21 ,816) -(7 ,334) Memberships (7 ,334) (666) (46,138) (103,142) Total Revenues (109,186) (23,254) Transfers --Total Transfers -- 316,671 165,048 Net Expenditures (Revenues) 339,364 64,400 77 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 3 30,417 24.89% 2 ,200 -% 82,140 17.43% 3 ,820 91.00% 6,150 181 .34 % 200 -% --% 1,040 -% 3 ,900 (8 .02%) 1,570 80.46% 1 ,892 10.00% --% 1,211 1,000.91% 2 ,113 -% --% 51,615 14.92% 3,000 -% 200 -% 8,661 -% -(100 .00%) 32 ,680 1.55% 395 1 .28% 3,000 -% 536 ,204 19.54% (5 ,000) 18.26 % (119,440) 22.35% (8,000) 9 .08% (132,440) 21.30% -- % 403,764 18.98% City of Pickering 2023 Approved Current Budget Summary 10215 Don Beer Arena 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease Expenditures 464,215 637,767 Salaries & Wages 647,717 13,906 12,107 32,376 Overtime 20 ,000 - 130,299 138,637 Employee Benefits 157,316 8,542 1,133 3,278 Uniforms 5,000 2,080 335 418 Seminars & Education 3,100 2,500 --Travel 200 - -624 Freight, Express & Cartage -- -1 Environmental Charges -- 439 608 Cellular Phones 1,800 - 11,467 14,564 Telephone & Data 15,340 (240) 3,321 262 Internet 265 - 45 493 Cable TV 545 - 2,215 -Brochures/Newsletters Printing -- 5,970 5,970 Insurance Premium 5,970 597 --Insurance Deductible 2,000 - 60 333 Meals , Promotions & General -- --Memberships 400 - 3,847 4,318 Outside Agency Services 3 ,115 - 73,770 165,910 Building -Repairs & Maintenance 184,850 28,756 5 ,896 2,916 Misc. Equip. -Repairs & Maintenance 15,000 - --Misc. Equip . Rentals 300 - 37,235 40,820 Land Rentals 46,150 53,195 166 265 Stationary & Office Supplies 300 - 660 176 Supplies & Tools 2,165 - --COVID Related Expenses 9,000 (9 ,000) 17,838 31,823 Utilities -Water 24,300 10,000 138,071 214,850 Utilities -Hydro 219,150 10,000 25,569 36,780 Utilities -Natural Gas 33 ,235 6,000 222 900 Software & Hardware Mice. Contracts 1,010 (215) --Furniture & Fixtures 6,000 - 4,975 4,220 Misc . Equipment 4 ,800 (4,800) 939,855 1,338,309 Total Expenditures 1,409,028 121,321 Revenues --Snack Bar (5 ,804) 1,854 (319) (5,543) Vending Machines (2,500) (1 ,100) 78 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 661,623 2.15% 20,000 - % 165,858 5.43% 7 ,080 41.60% 5,600 80.65% 200 - % -- % --% 1,800 -% 15,100 (1.56%) 265 - % 545 - % -- % 6,567 10.00% 2,000 - % --% 400 - % 3,115 - % 213,606 15.56% 15,000 - % 300 -% 99,345 115.27% 300 - % 2,165 - % -(100 .00%) 34,300 41.15% 229,150 4 .56% 39,235 18 .05% 795 (21 .29%) 6,000 - % -(100.00%) 1,530,349 8.61% (3,950) (31 .94%) (3,600) 44.00% 10215 Don Beer Arena 2021 2022 Actuals Actuals -(1,208) -(1 ,543) (410,215) (852,006) (11 ,575) (20,565) (77) (19,763) -- (422,186) (900 ,628) -- 517,669 437,681 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Admissions (2,000) - Rentals -User Fees (2,906) (1 ,694) Rentals -Ice Surface (879,000) (113,000) Rentals -Arena Floor (38 ,000) - Rentals -Halls (25,000) (11,000) Marketing Sponsors (7 ,500) - Total Revenues (962,710) (124,940) Transfers Total Transfers -- Net Expenditures (Revenues) 446,318 (3,619) 79 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 (2,000) - % (4 ,600) 58 .29% (992,000) 12 .86% (38,000) - % (36,000) 44.00% (7 ,500) -% (1,087,650) 12.98% -- % 442,699 (0.81%) City of Pickering 2023 Approved Current Budget Summary 10220 Community Centres 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 258,289 293,863 Salaries & Wages 309,983 (50,591) 4,858 10,340 Overtime 8,000 - 56,070 59,853 Employee Benefits 78,276 (14,826) 1,770 1,996 Uniforms 2,200 2,720 305 1,083 Seminars & Education 3,260 (1,500) -436 Travel · 500 - -16 Environmental Charges -- 1,966 3,217 Cellular Phones 2,500 - 11,034 6,324 Telephone & Data 5,565 1,735 447 5,901 Internet 6,980 (900) 90 1,066 Cable TV 1,080 - 3,980 4,156 Insurance Premium 3,980 398 1,339 314 Insurance Deductible 2,000 - 39,274 -Consulting & Professional Fees -- -17 Meals, Promotions & General -- 34,267 17,210 Outside Agency Services 11,984 - 165,226 282,294 Building -Repairs & Maintenance 292,065 41,480 9,374 17,946 Vehicle -Repairs & Maintenance 6,300 - 12,120 17,621 Gas, Oil, Tire, Etc. 11,150 6,000 1,379 2,302 Misc . Equip. -Repairs & Maintenance 1,500 - 21 32 Building Rentals 10 - -381 Stationary & Office Supplies -- 88 -Programs & Event Supplies -- 1,082 1,568 Supplies & Tools 2,000 - --COVI D Related Expenses 12,000 (12,000) 10,559 12,322 Utilities -Water 13,250 - 78,962 91,599 Utilities -Hydro 116,990 (15,000) 21,538 23,976 Utilities -Natural Gas 27,405 500 3,095 7,067 Utilities -Oil 4,867 - 128 413 Software & Hardware Mtce . Contracts 465 (155) --Furniture & Fixtures 10,000 - 1,085 (234) Miscellaneous Expenses -- 718,346 863,079 Total Expenditures 934,310 (42,139} Revenues (101) (758) Vending Machines (1,000) - 80 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 259,392 (16.32%) 8,000 -% 63,450 (18 .94%) 4,920 123 .64% 1,760 (46.01%) 500 -% --% 2,500 -% 7,300 31 .18% 6,080 (12.89%) 1,080 -% 4,378 10.00% 2,000 -% --% --% 11,984 -% 333,545 14.20% 6,300 -% 17,150 53 .81% 1,500 -% 10 -% --% --% 2,000 -% -(100.00%) 13,250 -% 101,990 (12 .82%) 27,905 1.82% 4,867 -% 310 (33 .33%) 10,000 -% --% 892,171 (4.51%} (1,000) -% City of Pickering 2023 Approved Current Budget Summary 10220 Community Centres 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease (32,934) (125 ,208) Community Ctr. Rentals (175 ,200) (8 ,780) --other Use r Fees (2,080) (420) --Netted Revenue (11 ,900) - (33,035) (125 ,966) Total Revenues (190 ,180) (9 ,200) Transfers -41,000 Capital Expenditures -- (177) -Transfer to(from) Cntg Sty Res . -- (177) 41,000 Total Transfers - - 685,134 778,113 Net Expenditures (Revenues) 744,130 (51,339) 81 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 (183 ,980) 5.01% (2,500) 20.19 % (11,900) -% (199,380) 4.84% --% --% -- % 692,791 (6.90%' City of Pickering 2023 Approved Current Budget Summary 10225 Recreation Complex -Central Core 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 1,669,068 2 ,152,656 Salaries & Wages 2,204,874 35,250 24,892 54 ,896 Overtime 73,844 - 375,461 471,157 Employee Benefits 545,415 30,765 9,294 10,684 Uniforms 9,000 820 -194 Conferences -- 1,978 3,911 Seminars & Education 6,081 - 63 129 Travel 800 - 8,295 7,889 Cellular Phones 8,650 150 9,449 10,199 Telephone & Data 11,660 - 1,085 1,049 Internet 1,065 - 5,109 24,433 Advertising 31,000 - 8 104 Subscriptions & Publications 250 - 13,570 13,570 Insurance Premium 13,570 1,357 -2,790 Insurance Deductible 4,000 - 268 11 ,339 Meals, Promotions & General 13,000 - 2,294 1,670 Memberships 3,090 485 44,285 59,898 Outside Agency Services 57,491 8,879 -291 Repairs & Maintenance Materials -- 226 ,136 362,026 Building -Repairs & Maintenance 227,650 175,754 -413 Vehicle -Repairs & Maintenance -- 20,226 18,952 Misc. Equip. -Repairs & Maintenance 47,475 (3,000) 990 582 Misc. Equip . Rentals 8,000 - 3,920 5,244 Stationary & Office Supplies 3,100 3,400 639 -Forms 1,100 - 1,938 2,199 Programs & Event Supplies 1,000 5,800 7,331 17,578 Supplies & Tools 26,200 200 --COVID Related Expenses 14,000 (14,000) 22 ,076 27,540 Utilities -Water 38 ,180 (2,000) 141 ,019 191,986 Utilities -Hydro 254,000 (10,000) 29,432 58,185 Utilities -Natural Gas 45,885 14,500 5,529 8,973 Software & Hardware Mtce . Contracts 10,220 8,970 2 ,088 1,843 Furniture & Fixtures 27,000 7 ,000 -6 Misc. Equipment -- 129 3,308 Miscellaneous Expenses -- 2,626,572 3,525,694 Total Expenditures 3,687,600 264,330 82 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 2,240,124 1 .60% 73,844 - % 576,180 5.64% 9,820 9.11% --% 6,081 - % 800 - % 8,800 1.73% 11,660 - % 1,065 - % 31,000 -% 250 - % 14,927 10 .00% 4,000 -% 13,000 - % 3,575 15.70% 66,370 15.44% --% 403,404 77.20% -- % 44,475 (6 .32%) 8,000 -% 6,500 109.68% 1,100 - % 6,800 580 .00% 26,400 0 .76% -(100 .00%) 36,180 (5.24%) 244,000 (3 .94%) 60,385 31.60% 19,190 87 .77% 34,000 25 .93% --% --% 3,951,930 7.17% City of Pickering 2023 Approved Current Budget Summary 10225 Recreation Complex -Central Core 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Revenues --Department User Fees -(10 ,000) (272) (2,799) Vending Machines (10 ,000) - (47 ,837) (115,797) Admissions (107,900) (25,958) 2,352 (27,749) Rentals -Meeting Rooms (33 ,000) (22,700) 2,638 (61 ,662) Rentals -Halls (70 ,000) (30 ,000) 15 -Rentals -Misc. Equipment -- (63,480) (79,334) Rental -Wellness Clinic (75 ,000) (6,000) (101,290) (445 ,599) Memberships (639,369) (80,263) -(3,703) Child Supervision (20,000) 20,000 (16 ,167) (55,773) Fitness Testing (35,295) (14,705) (77,550) (85,477) Other User Fees (85 ,000) 5,500 (301,591) (877,893) Total Revenues (1,075,564) (164,126) Transfers -75 ,000 Transfer to(from) Reserve -(125 ,000) -75,000 Total Transfers -(125,000) 2,324,981 2,722,801 Net Expenditures (Revenues) 2,612,036 (24,796) 83 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 (10 ,000) -% (10,000) -% (133 ,858) 24.06% (55,700) 68 .79% (100,000) 42 .86% --% (81,000) 8.00% (719,632) 12 .55% -(100.00%) (50,000) 41 .66% (79 ,500) (6.47%) (1,239,690) 15.26% (125,000) -% (125,000) - % 2,587,240 (0.95%' City of Pickering 2023 . Approved Current Budget Summary 10235 Recreation Complex -Arenas 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 226,393 495,539 Salaries & Wages 519,711 18,545 9,032 28,459 Overtime 25,000 - 77,663 134,053 Employee Benefits 129,437 5,344 2,044 910 Uniforms 4,400 250 373 674 Seminars & Education 2,875 2,500 21 -Freight, Express & Cartage -- 872 448 Cellular Phones 1,000 - 3,904 860 Telephone & Data 1,910 (510) 246 1,738 Internet 1,600 150 155 1,883 Cable TV 1,920 - 10 (10) Subscriptions & Publications -- 4,510 4,510 Insurance Premium 4,510 451 -1,236 Insurance Deductible 2,000 - 30 269 Meals, Promotions & General -- -222 Memberships -- 440 272 Outside Agency Services 1,100 545 93,425 129,544 Building -Repairs & Maintenance 163,561 34,924 5,826 3,750 Misc. Equip . -Repairs & Maintenance 7,000 - --Misc. Equip . Rentals 800 - 34 192 Stationary & Office Supplies 650 - --Forms 300 - 348 665 Supplies & Tools 3,335 - --COVID Related Expenses 9,000 (9 ,000) 4,906 6,120 Utilities -Water 11,070 (2,000) 103,185 140,476 Utilities -Hydro 181,000 (2,500) 8,584 15,032 Utilities -Natural Gas 14,700 2,000 162 728 Software & Hardware Mtce . Contracts 815 (170) --Furniture & Fixtures 6,000 - -386 Misc. Equipment -4,800 542,163 967,956 Total Expenditures 1,093,694 55,329 Revenues --Snack Bar (3,850) (350) (66) (1,942) Vending Machines (1,500) - (5,188) (14,376) Admissions (16,000) - (259,977) (567,882) Rentals -Ice Surface (648,000) (69,000) 85 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 538,256 3.57% 25,000 - % 134,781 4.13% 4,650 5.68% 5,375 86.96% --% 1,000 - % 1,400 (26.70%) 1,750 9 .38% 1,920 - % --% 4,961 10.00% 2,000 -% --% -- % 1,645 49.55% 198,485 21 .35% 7,000 - % 800 -% 650 -% 300 -% 3,335 -% -(100 .00%) 9,070 (18.07%) 178,500 (1.38%) 16,700 13.61% 645 (20 .86%) 6,000 - % 4,800 -% 1,149,023 5.06% (4,200) 9.09% (1,500) -% (16,000) - % (717,000) 10 .65% City of Pickering 2023 Approved Current Budget Summary 10235 Recreation Complex -Arenas 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease (5,336) (944) Rentals -Arena Floor (12 ,000) - (2,365) (21 ,482) Rentals -Meeting Rooms (24,000) (17,000) --Advertising Space (55,000) - --Marketing Sponsors (10 ,000) 10 ,000 (272,932) (606,626) Total Revenues (770,350) (76,350) Transfers - - Total Transfers -- 269,231 361,330 Net Expenditures (Revenues) 323,344 (21,021) 86 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 (12,000) -% (41,000) 70 .83% (55,000) -% -(100 .00%) (846,700) 9.91% --% 302,323 (6.50%' 10240 Civic Centre 2021 2022 Actuals Actuals 280,379 395,805 6,596 17,185 46,854 63,822 2,580 1,134 34 - 3,570 4 ,088 557 534 1,593 1,451 3,120 3,120 501 516 -1,201 99,356 114,108 157,083 169,516 643 1,859 -- 192 - 321 - 1,158 586 -- 12,118 10,072 110,496 90,401 23,738 28,364 175 440 649 - 751,713 904,202 (247) (442) (352,223) (353 ,648) (352,470) (354,090) (1,119) - (1,119) - 398,124 550,112 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Expenditures Salaries & Wages 479,482 (11,005) Overtime 5,500 - Employee Benefits 102,085 (2,885) Uniforms 2,000 220 Seminars & Education 1,000 (1 ,000) Telephone & Data 4 ,250 450 Internet 530 - Cable TV 850 650 Insurance Premium 3 ,120 312 Insurance Deductible 1,000 - Consulting & Professional Fees 2,000 - Outside Agency Services 130 ,870 34,330 Building -Repairs & Maintenance 191,625 54,782 Misc. Equip. -Repairs & Maintenance 1,500 - Misc. Equip. Rentals 500 - Stationary & Office Supplies -- Programs & Event Supplies -- Supplies & Tools 3,000 - COVID Related Expenses 15,000 (15,000) Utilities -Water 14,770 (1,000) Utilities -Hydro 163,824 (14,999) Utilities -Natural Gas 26,805 4,000 Software & Hardware Mtce. Contracts 495 67 Miscellaneous Expenses -- Total Expenditures 1,150,206 48,922 Revenues Vending Machines (500) - Netted Revenue (353,648) 30,358 Total Revenues (354,148) 30,358 Transfers Transfer to(from) Cntg Sty Res . -- Total Transfers -- Net Expenditures (Revenues) 796,058 79,280 87 Run Date : Sep 13 , 2023 2023 Approved %Change Budget From 2022 468,477 (2 .30%) 5,500 -% 99,200 (2.83%) 2,220 11 .00% -(100 .00%) 4,700 10.59% 530 -% 1,500 76.47% 3,432 10 .00% 1,000 -% 2,000 -% 165,200 26.23% 246,407 28.59% 1,500 -% 500 -% --% --% 3,000 -% -(100 .00%) 13,770 (6 .77%) 148,825 (9 .16%) 30,805 14.92% 562 13.54% --% 1,199,128 4.25% (500) -% (323,290) (8 .58%) (323,790) (8.57%) -. -% -- % 875,338 9.96% City of Pickering 2023 Approved Current Budget Summary 10245 Senior Citizens Centre 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 201,997 256,697 Salaries & Wages 286,248 (5,501) 2,362 6,857 Overtime 6,000 - 49,026 49,785 Employee Benefits 74,458 (1,492) 351 225 Uniforms 1,200 910 -20 Conferences -- 1,308 712 Seminars & Education 5,500 350 -180 Travel 1,000 200 504 410 Cellular Phones 600 - 3,933 2,552 Telephone & Data 3 ,060 (320) 79 76 Internet 75 - 133 1,616 Cable TV 1,590 - --Advertising 1,000 - 2,440 2,440 Insurance Premium 2,440 244 32,866 35,148 Meals, Promotions & General 83,130 (83 ,130) 825 825 Memberships 825 25 1,772 1,165 Outside Agency Services 2,580 - 68,606 50 ,096 Building -Repairs & Maintenance 57,984 52,291 -71 Stationary & Office Supplies -- 2,625 17,168 Programs & Event Supplies 2,300 16,000 --Special Event Supplies -55,000 92 -Supplies & Tools 2,100 - --COVID Related Expenses 4,000 (4,000) 4,879 4,878 Utilities -Water 7 ,050 (1,000) 15,098 17,499 Utilities -Hydro 29 ,152 (2 ,500) 4,144 4,671 Utilities -Natural Gas 6,595 500 1,705 1,979 Software & Hardware Mtce . Contracts 2,365 (130) --Misc. Equipment -4,000 394,745 455,070 Total Expenditures 581,252 31,447 Revenues (6,500) (39,050) Federal Grants -- (236,404) (129,078) Ontario Grants (218,530) 74,130 (1,508) (3,658) Seniors Event Fees (1,000) (2,000) (16,207) (41,351) Older Adults 55+ Programs (22,000) (32,000) (1,062) (2,700) Sponsorships (3,000) - (4,000) -Marketing Sponsors (2 ,000) - 88 Run Date : Sep 13, 2023 2023 Approved %Change Budget From 2022 280,747 (1.92%) 6,000 -% 72,966 (2 .00%) 2,110 75 .83% --% 5,850 6.36% 1 ,200 20.00% 600 -% 2,740 (10.46%) 75 -% 1,590 -% 1,000 -% 2 ,684 10.00% -(100.00%) 850 3 .03% 2,580 -% 110,275 90 .18% --% 18,300 695.65% 55,000 -% 2,100 -% -(100.00%) 6,050 (14 .18%) 26,652 (8.58%) 7 ,095 7 .58% 2,235 (5 .50%) 4,000 -% 912,699 5.41% --% (144,400) (33 .92%) (3,000) 200.00% (54,000) 145.45% (3,000) -% (2,000) -% City of Pickering 2023 Approved Current Budget Summary 10245 Senior Citizens Centre 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease (265,681) (215,837) Total Revenues (246 ,530) 40,130 Transfers --Total Transfers - - 129,064 239 ,233 Net Expenditures (Revenues) 334,722 71,577 89 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 (206,400) (16.28%) --% 406,299 21 .38% 10250 Museum 2021 2022 Actuals Actuals 629,127 864,940 2,890 3,830 151,536 170,849 6,081 6,003 -981 3,426 3,164 387 2,154 601 2,079 4,991 4,795 15,452 18,467 4,589 1,612 120,607 177,559 13,826 151,621 4,030 4,030 8,360 30,000 5,816 2,982 1,387 1,094 5,760 6,615 87,689 109,518 3,474 1,644 1,885 2,086 5,169 2,848 11,098 9,468 1,105 370 2,444 1,878 22,696 33,777 3,628 2,271 3,224 885 596 114 2,945 3,610 -- 15,765 21,658 6,567 12,906 1,108 - 1,338 2,098 247 - City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Expenditures Salaries & Wages 983,874 (113,991) Overtime 1,000 1,000 Employee Benefits 192,486 (18,215) Uniforms 7,560 (940) Conferences -- Seminars & Education 5,000 - Travel 7,500 (5,000) Freight, Express & Cartage 2,500 5,000 Cellular Phones 6,500 - Telephone & Data 19,835 (835) Internet 1,635 - Advertising 152,200 (87,200) Trade Shows.Exhibits & Displays 210,300 4,200 Insurance Premium 4,030 403 Consulting & Professional Fees 80,000 (65,000) Meals, Promotions & General 5,500 - Memberships 2,027 935 Outside Agency Services 5,255 - Building -Repairs & Maintenance 116,165 (13,400) Vehicle -Repairs & Maintenance 4,000 6,000 Gas, Oil, Tire, Etc. 2,700 - Misc. Equip. -Repairs & Maintenance 3,000 - Artefact Repairs & Maintenance 8,700 - Grounds Upkeep 2,800 - Stationary & Office Supplies 2,500 - Programs & Event Supplies 4,000 - Special Event Supplies 34,000 6,000 Supplies & Tools 500 - Artefact Purchases 600 - Gift Shop/Plaques 5,000 - COVID Related Expenses 5,000 (5,000) Utilities -Hydro 25,545 (1,000) Utilities -Natural Gas 7,885 6,000 Utilities -Oil 816 684 Software & Hardware Mtce . Contracts 4,735 3,760 Hardware Replacements -- 90 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 869,883 (11.59%) 2 ,000 100 .00% 174,271 (9.46%) 6,620 (12.43%) --% 5,000 -% 2,500 (66.67%) 7,500 200.00% 6,500 -% 19,000 (4 .21 %) 1,635 - % 65,000 (57 .29%) 214,500 2.00% 4,433 10.00% 15,000 (81.25%) 5,500 -% 2,962 46.13% 5,255 - % 102,765 (11 .54%) 10,000 150.00% 2,700 -% 3,000 -% 8,700 -% 2,800 -% 2,500 -% 4,000 -% 40,000 17.65% 500 -% 600 -% 5,000 -% -(100.00%) 24,545 (3 .91 %) 13,885 76 .09% 1,500 83.82% 8,495 79.41% --% 10250 Museum 2021 2022 Actuals Actuals 28 - 848 2,421 1,150,720 1,660,327 (141,211) · (431 ,035) (89,027) (141,550) -(15,000) (9,897) (11,639) -(763) (93 ,545) (112,624) (9,983) (14,092) (8,531) (14,001) (1,683) (3,365) -(5,000) (353,877) (749,069) -- -- 796,843 911,258 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase I Budget Decrease Furniture & Fixtures -- Misc. Equipment -- Total Expenditures 1,915,148 (276,599) Revenues Federal Grants (757,102) 405 ,052 Ontario Grants (181,900) 25,900 Other Agency Grants -(56,000) Gift Shop (11,600) - Snack Bar (2,000) - Admissions (173,000) 38,000 Rentals -Meeting Rooms (11,000) - Museum Programs (15,000) - Donations (5,000) - Marketing Sponsors -(10,000) Total Revenues (1,156,602) 402,952 Transfers Transfer to(from) Reserve (10,000) 10,000 Total Transfers (10,000) 10,000 Net Expenditures (Revenues) 748,546 136,353 Run Date : Sep 13, 2023 2023 Approved %Change Budget From 2022 --% --% 1,638,549 (14.44%) (352,050) (53 .50%) (156 ,000) (14.24%) (56 ,000) -% (11,600) - % (2,000) - % (135,000) (21.97%) (11 ,000) - % (15,000) - % (5,000) -% (10,000) - % (753,650) (34.84%) -(100.00%) -(100.00%) 884,899 18.22% Staff have calculated approximately $146,875 in volunteer human resources and skills for the Museum (based on 2022 volunteer hours totaling 5,875 hours at a value of $25.00 per hour). 91 Operations Department Overview The Operations Department is organized in two divisions, Public Works and Operations Services. Operations Services is responsible for Facilities Capital Projects (managing capital lifecycle replacements for all City facilities, including renovations and new construction projects) and Energy Management (the City's Corporate Energy Management Plan that is the City's policy for energy efficiency and savings across all City facilities and operations). Public Works is responsible for the repair and maintenance of roads; winter control operations; maintenance of playgrounds; boulevard and parkland grass cutting; maintaining green space; and, managing the City's municipal fleet. Responsibility for Corporate Security will be transferred to Community Services in 2023. The Operations Centre is located at 1955 Clements Road, next to the Pickering Soccer Centre. [ ------Operations Admin. Fleet Services [ Operations Department ) Public Works ] I "" Property Parks Maintenance EJ 92 Operations Services Facilities Capital Projects Energy Management Corporate Security Key Activities for 2023 Public Works Operations Department • Re-structure winter control, adding one new road plow route and one new sidewalk route due to growth • Assume new stormwater management ponds • Implement the embedded Automotive Parts. Supply & Inventory Management System • Purchase four new heavy plow trucks with brine tanks to extend the pre-emptive winter anti-icing (direct liquid application) program on Main and Local roads and enhance winter control • Develop and implement an Electric Vehicle & Equipment Conversion Plan • Continuing the conversion of gas vehicles and equipment to electric, including new vehicles for Bylaw and Building Services, and electric equipment for Parks & Property • Install a new public electric vehicle charging station at Chestnut Hill Developments Recreation Complex • GPS tracking will be installed on all City-owned vehicles and pieces of equipment • Design and construct the new equipment storage shed in the Operations Centre's yard • Continue to develop the Parks' Asset Management Plan. All 85 parks are now in the VFA Asset Management database, allowing completion of the Parks Capital Asset Replacement Plan • Replace the Bayridges Kinsmen Park artificial-turf soccer field • Continue park sport fields LED lighting conversion program for Bayridges Kinsmen Park artificial-turf soccer field • Install solar lighting at Dunmoore Off-Leash Dog Park • Complete the all-season washroom facility located at Rotary Frenchman's Bay West Park • Reconstruct the rubber surface running tracks located at St Mary Park and Beverley Morgan Park • Reconstruct Dunmoore Tennis Court, including new LED lighting, fencing and drainage works · Facilities Capital Projects • Commence construction of the Pickering Heritage & Community Centre project, to be completed by 2026 • Complete construction of Fire Station #1 and Headquarters, located on Zents Drive • Commence design work for Fire Station #5 replacement, located on Bayly Street • Commence design work for new Animal Shelter, including stakeholder consultation • Commence design work for renovations to George Ashe Library & Community centre, including stakeholder consultation 93 Operations Department • Commence design work for renovations to the Civic Complex Council Chambers, including stakeholder consultation • Advance pre-design and conceptual work required to retain design consultants in 2024 for the Seaton Recreation Complex & Library Energy Management • Implement year 4 of the 5-year Corporate Energy Management Plan and begin preparing for its next update in 2024 • Provide technical support for facilities capital projects • Develop and expand electric vehicle charging station pilot projects Financial Information 2019 Full-Time 71 Reg. Part-Time 4 Total 75 Staffing Summary (Full & Regular Part-Time) Approved Prior Term 2020 2021 2022 Add 81 81 90 6 3 3 3 - 84 84 93 6 Approved New Term 2023 Transfers -1 - -1 Total 95 3 98 One full-time Corporate Security Specialist will be transferred to Community Services in 2023. The department proposes to add six new full-time positions of which five are related to the maintenance of new roads & parks infrastructure due to community growth. The other new full-time position is to supplement the existing Facilities Capital Projects team to manage the substantial increase in facilities capital projects. • One new full-time Manager, Facilities Capital Projects • One new full-time Heavy Equipment Operator 1 • One new full-time Lead Hand, Roads Maintenance • One new full-time Maintenance Worker, Roads • One new full-time Maintenance Worker, Parks & Property • One new full-time Repairperson, Small Equipment 94 Operations Department Year-Over-Year (Net Cost) Budget Changes 2022 2023 Year-Over-Year Approved Approved Change Budget Budget ($) (%) Public Works -Adm. $1,007,075 $846,956 ($160,119) (15.90%) Property Maintenance 1,355,018 1,199,691 (155,327) (11.46%) Fleet Services 1,892,597 2,131,003 238,406 12.60% Roads 8,190,753 8,675,799 485,046 5.92% Parks 5,194,025 5,368,044 174,019 3.35% Operations -Adm. 1,455,554 1,406,124 (49,430} {3.40%} Total (Net Cost) $19,095,022 $19,627,617 $532,595 2.79% Explanation of Significant Departmental Budget Changes Expenditures -Increases I (Decreases) Salaries & Benefits -$605,500 Increase largely reflects proposed new positions related to growth within Fleet Services, Roads, Parks and Capital Projects as outlined above. Seminars & Education -($21, 120) Decrease reflects the completion of one-time seminars or educational courses in 2022. Insurance Premium -$20,000 Increase reflects the higher premium renewal for 2023. Consulting & Professional Fees -$164,800 Increase includes the Facilities Renewal Plan (partially funded by Development Charges), the Water Testing & Species Inventory in Frenchman's Bay, and sports field lighting conversion to LED at Kinsman Park. Outside Agency Services -$92,600 Increase reflects the full year cost of the Fleet Parts Supplier program rolled out in 2022, and expansion of GPS location devices onto all Public Works' equipment. Repairs & Maintenance -Winter Control -$15,000 Increase reflects the cost of snow removal on bridges, laneways, mews, and cul-de- sacs (Roads) related to growth. 95 Operations Department Repairs & Maintenance -Contract Services -$107,200 Increase reflects the supply and installation of playground safety surfacing (Parks) (funds transferred from Grounds Upkeep and Misc. Equipment Rentals accounts). Repairs & Maintenance -Engineering -$118,500 Increase due to re-budgeting of 2022 concrete curb repair program, 2022 line painting and pavement marking program to be completed in 2023, and addition of a one-time project for boulevard repairs. Repairs & Maintenance -Storm Sewer -($20,000) Decrease due to reduction in costs related to the annual catchbasin cleaning contract. Engineering Hwy Aids Repair & Maintenance -($40,000) Decrease due to completion of a one-time retaining wall repair project in 2022. Repairs & Maintenance Buildings -$57,500 Increase is due to the repairs and maintenance costs for the Operations Centre, now that the facility is beyond the warranty, and an increase in the cross-charge from the from Fleet (share of overhead for the municipal garage) and Community Services Uanitorial services provided at the Operations Centre). Tree Maintenance -($15,000) Decrease is due to a reduction in costs for integrated pest control/ management (Property Maintenance). Gas, Oil, Tires -$130,000 Increase reflects last year's rising fuel costs and additional diesel, gas, oil changes and tires required due to the growth of the City's fleet of vehicles and equipment. Repairs & Maintenance -Miscellaneous Equipment -$60,000 Increase for repairs to large and small off-road equipment based on actuals (Property Maintenance and Parks). Grounds Upkeep -($56,000) Decrease mainly reflects the transfer of play unit safety surfacing material to a contacted service (Parks). Rental Misc. Equipment -($70,800) Decrease reflects the transfer of cost of a blower truck rental for playground safety surfacing to 502310 (Parks). 96 Operations Department Programs & Events Supplies -($158,800) Increase reflects the cost to expand the program capacity for the City's Seniors & Persons with Disabilities Snow Clearing Program from 500 to 750 participants annually. COVID Related Expenses -($71,100) Decrease reflects the removal of all COVID related expenses within the Department, a significant part being janitorial term staff for COVID enhanced cleaning. Utilities -Natural Gas -$11,000 Budget increase reflects last year's rising natural gas costs and anticipated increase in natural gas prices and consumption trends. Utilities -Hydro -($17,500) Decrease based on decline in projected consumption partially offset by price increases expected in 2023. Misc. Equipment -($88,600) Decrease represents one-time equipment purchases completed in 2022 (Property Maintenance and Parks). Revenues/Transfer from Reserves -(Increases) I Decreases Department User Fees -($45,000) Increase reflects higher Road Occupancy Permit fees due to rising costs. Rentals -User Fees -($65,000) Increase reflects the return to regular operations and the removal of COVID-19 restrictions. Other User Fees -($35,100) Increase reflects additional revenues expected from new fee structure and expansion of the City's Seniors & Persons with Disabilities Snow Clearing Program from 500 to 750 participants annually. Transfer from Development Charge Reserve Fund -($28,400) Increase due to additional Development Charge funding for the Facilities Renewal Study. Transfer from Continuing Studies Reserve -($40,800) Increase is funding for 2022 projects ongoing in 2023. 97 Operations Department Transfer from Reserves -($412,900) Increase is primarily due to a change in funding ($388,700) to support the expanded Seniors & Persons with Disabilities Snow Clearing Program which is now being funded from the Casino Reserve. 98 Operations Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 2022 Fleet Services Work orders completed -Fire 462 work 153 work 108 work Services orders orders orders Work orders completed -other 1,821 work 1,304 work 808 work Departments orders orders orders Vehicles maintained -cars, trucks, 210 218 244 dump truck, snow ploughs, trailer, (replacement fire truck, tractors units yet to be auctioned) Attachments maintained -wings, 69 72 77 ploughs, salters, ball groomers, beach groomers, etc. Small equipment maintained -373 407 418 mowers, chain saws, trimmers, etc. Parks Garbage picked up/disposed 200,180 kg 186,600 kg 224,760 kg Sidewalk winter control response 27 events 11 events 18 events Maintains open space 1,940 acres 1,940 acres 1,940 acres Maintains parks 85 85 86 Maintains playgrounds 63 63 63 Maintains splash pads 3 3 3 Maintains sports fields -soccer, 64 fields 64 fields 64 baseball, artificial turf, cricket pitch Roads Roadways maintained 347 km paved 352 km paved 357 km paved 102 km gravel 102 km gravel 102 km gravel Minimum Maintenance Standards 7,220 km 7,687 km 7,747 km roadway patrol (cumulative) (cumulative) (cumulative) Minimum Maintenance Standards 3,312 2,479 3,312 potholes repaired potholes potholes potholes Winter control response 39 events 30 events 41 events Road salt used 4,335 tonnes 3,140 tonnes 7,348 tonnes Road sand used 1,713 tonnes 2,117 tonnes 2,572 tonnes Road sweepings picked up/disposed 1,500 tonnes 1,200 tonnes 1,280 tonnes 99 Operations Department Performance Indicators/Statistics 2020 2021 Facilities Capital Projects Number of Capital Projects 1 43 34 Average Value per Project1 $801,000 $395,000 Facility Condition Index (Overall 0.25 0.26 Portfolio)2 Total Replacement Cost of Building $251 million $251 million Assets 2 Property Maintenance Seniors sidewalk clearing program 13 events/ 6 events/ response/ registrations 388 379 registrants registrants 1 Includes facility-based capital projects managed by Operations on behalf of other departments. Excludes carryover projects from previous years. 2022 71 $351,210 0.31 $287 million 12 events/ 403 registrants 2 As of January 1 of the respective year, based on VFA Facilities database. Excludes buildings and amenities in parks, and the City Centre projects. Current year dollars are-shown for each respective year. 2023 value includes construction cost inflation from the previous year. 100 Major Capital Facilities The City faces an unprecedented need for capital investment to provide new facilities, renovations of existing facilities, and life cycle replacements to keep pace with the growth and infrastructural renewal requirements of the City. The City's response to the COVID-19 pandemic required the deferral and delay of many capital projects due to the economic uncertainty at the time. Growth and the release of deferred projects has created a significant increase in the capital forecast over the next ten years and beyond. The existing capital projects team is established to deal with routine capital life cycle replacement and renewal projects which represent an average of $9 million per year. The current approved capital projects along with the 2023 proposed capital projects, and 2024-2027 forecast projects include: the Pickering Heritage & Community Centre, Animal Shelter, Seaton Recreation Complex & Library, Council Chamber renovation, Seaton Fire Hall #3, Fire Hall #5 Replacement, Northern Public Works Facility, O'Brien Arena Renovation, Seaton Community Centre, and support for the City Centre Project. These proposed major capital projects represent a commitment in excess of $425 million over a 10 to 15-year time span. This does not yet include new facilities associated with growth related to Cherrywood and North East Pickering. The expected workload requires a new staffing model that can successfully support multiple major new facility projects over a time span that is often six or more years. The new team will ensure that each project effectively navigates through: • identification and development of the need • program evaluation • stakeholder consultation • design (incorporating sustainable and resilient goals) • capital budgeting and support of grant applications • permit and planning applications • procurement • construction • operationalizing for opening • monitoring the warranty period Staff are recommending the formation of a new dedicated Capital Facilities project team to focus on these major new projects and ensure that they are successfully delivered; while the existing staff complement continue to support the infrastructure renewal program. The cost of this new team would be funded from the Casino Reserve. 101 Major Capital Facilities Financial Information 2023 Budget & 2024 Projection New Capital Facilities Team Less: Transfer from Casino Reserve Total (Net Cost) Staffing 2023 Approved Budget $189,975 (189,975) $- 2024 Projected Budget $1,253,610 {1,253,610) $- Staff recommend the formation of a new dedicated Capital Facilities team led by, and reporting to, the Division Head, Operations Services. Commencing on September 1, 2023, the new team would be staffed by: • Shared Division Head, Operations Services • Two new full time Senior Project Managers • One new full-time Coordinator This staffing level would be supplemented in future budgets once all major projects for the next ten years are clearly identified and the schedule and overlapping of concurrent projects is clearly understood. 102 City of Pickering 2023 Approved Current Budget Summary Operations Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 7,515,971 8,538,044 Salaries & Wages 8,928,797 679,334 340,753 504,768 Overtime 488,500 (3,750) 1,882,586 2,136,528 Employee Benefits 2,353,416 92,432 110,336 124,115 Uniforms 89,995 9,510 -3,877 Conferences 1,800 800 7,981 33,409 Seminars & Education 84,685 (20,120) 1,681 6,902 Travel 5,800 1,000 2,413 10,183 Freight, Express & Cartage 1,800 - 138 2,588 Environmental Charges 2,000 - 19,286 19,916 Cellular Phones 29,330 275 20,458 24,942 Telephone & Data 29,030 (3,905) 5,792 1,640 Internet 3,520 (1,500) 6,653 6,285 Subscriptions & Publications 12,800 (200) -7 Photo, Mapping, Print 9,200 2,250 224,395 200,470 Insurance Premium 200,470 20,747 10,041 12,622 Insurance Deductible 34,050 (7,000) 3,760 183,309 Consulting & Professional Fees 349,000 164,780 2,563 7,820 Meals, Promotions & General 8,600 550 6,308 7,561 Memberships 15,660 (1,535) 142,666 177,433 Outside Agency Services 270,112 92,588 513,773 782,496 Winter Control Maintenance 831,000 15,000 166,095 175,124 Repairs & Maintenance Contract Servic 297,000 107,200 130,866 59,315 Engineering -Repairs & Maintenance 265,000 118,500 188,896 218,543 Storm Sewer -Repairs & Maitenance 390,000 (20,000) 485,441 511,675 Repairs & Maintenance Materials 640 ,000 2,500 104,971 116,640 Highway Aids -Repairs & Maintenance 75,000 - 77,087 92,083 Engineering Highway Aids -Repairs & 160,000 (40,000) 498,617 532,617 Building -Repairs & Maintenance 561,261 59,342 388,701 450,126 Tree Maintenance 420,000 (15,000) 8,165 36,323 Lighting -Repairs & Maintenance 20,000 10,000 459,711 481,089 Vehicle -Repairs & Maintenance 448,000 6,000 582,498 845,113 Gas, Oil, Tire, Etc. 716,010 130,000 300,454 402,023 Misc. Equip. -Repairs & Maintenance 245,000 60,000 285,989 405,981 Grounds Upkeep 472,500 (56,000) 33,379 41,684 Fert . & Lawn Control 59,000 (4,000) --Building Rentals -9,700 103 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 9,608,131 7.61% 484,750 (0 .77%) 2,445,848 3.93% 99,505 10 .57% 2,600 44.44% 64,565 (23 .76%) 6,800 17 .24% 1,800 -% 2,000 -% 29,605 0.94% 25,125 (13.45%) 2,020 (42 .61%) 12,600 (1 .56%) 11,450 24.46% 221,217 10.35% 27,050 (20 .56%) 513,780 47.21% 9,150 6.40% 14,125 (9 .80%) 362,700 34.28% 846,000 1.81% 404,200 36.09% 383,500 44 .72% 370,000 (5 .1 3%) 642,500 0.39% 75,000 - % 120,000 (25 .00%) 620,603 10 .57% 405,000 (3.57%) 30 ,000 50 .00% 454,000 1.34% 846,010 18.16% 305,000 24.49% 416,500 (11.85%) 55,000 (6.78%) 9,700 -% City of Pickering 2023 Approved Current Budget Summary Operations Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease 108,423 188,001 Misc. Equip. Rentals 231,300 (70 ,800) 19,256 19,538 Land Rentals 21,696 - 7,421 13,295 Stationary & Office Supplies 16,000 1,650 5,068 2,753 Forms 2,000 4,000 247,653 321,458 Programs & Event Supplies 378,000 158,800 93,218 134,568 Supplies & Tools 82,875 2,600 -1,888 Educational Material -- -13,904 COVID Related Expenses 71,053 (71,053) 75,894 71,934 Utilities -Water 92,200 - 170,818 187,765 Utilities -Hydro 219,227 (17,502) 55,932 64,630 Utilities -Natural Gas 54,230 11,000 27,941 63,389 Software & Hardware Mtce . Contracts 159,105 11,627 724 -Furniture & Fixtures 2,000 3,000 37,325 44,887 Misc. Equipment 124,300 (88 ,570) 25,128 61 ,036 Other Fixed Assets 145,000 (5,000) 229,565 178,825 Taxes -Tenant 236,000 - 1,064 -Miscellaneous Expenses -- 15,633,854 18,521,122 Total Expenditures 20,353,322 1,349,250 Revenues -(67,200) Federal Grants (18,000) - (195,951) (312,920) Department User Fees (180,000) (45,000) (65) (122) Vending Machines (500) - (119,710) (215,170) Rentals -User Fees (150,000) (65,000) (54,600) (37,400) Memrl Tree/Bench Revenue (33,000) (2,000) (95,220) (89,124) Other User Fees (100 ,000) (35,100) -(6,000) Municipal Rentals (6,000) - --Rebates & Incentives (40,000) - (700) -Misc. Revenue -- (13,125) (69,838) Cost Recoveries (118,550) 2,500 (393,368) (308,467) Netted Revenue (368,350) - (872,739) (1,106,241) Total Revenues (1,014,400) (144,600) Transfers --Transfer to/(from) DC Oblg RF (39,140) (28,360) (6,055) 28,418 Transfer to(from) Cntg Sty Res. -(40,780) -(50,000) Transfer to(from) Reserve (174,760) (602,915) 104 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 160,500 (30 .61%) 21,696 -% 17,650 10.31% 6,000 200.00% 536,800 42.01% 85,475 3 .14% --% -(100.00%) 92,200 -% 201,725 (7.98%) 65,230 20.28% 170,732 7 .31% 5,000 150.00% 35,730 (71.26%) 140,000 (3.45%) 236,000 -% --% 21,702,572 6.63% (18 ,000) -% (225,000) 25.00% (500) -% (215,000) · 43 .33% (35,000) 6.06% (135 ,100) 35.10% (6,000) -% (40,000) -% --% (116,050) (2 .11%) (368,350) -% (1,159,000) 14.25% (67,500) 72.46% (40,780) -% (777 ,675) 345.00% City of Pickering 2023 Approved Current Budget Summary Operations Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease (30,000) (30,000) Transfer to (from) Oblig RF (30,000) - (36,055) (51,582) Total Transfers (243,900) (672,055) 14,725,060 17,363,299 Net Expenditures (Revenues) 19 ,095,022 532,595 105 Run Date : Sep 13 , 2023 2023 Approved % Change Budget From 2022 (30 ,000) -% (915,955) 275.55% 19 ,627,617 2.79% City of Pickering 2023 Approved Current Budget Summary 10300 Public Works -Administration 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Transfers --Total Transfers -- 929,011 9 .13,587 Net Expenditures (Revenues) 1,007,075 (160,119) 107 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 -- % 846,956 (15.90%) City of Pickering 2023 Approved Current Budget Summary 10305 Property Maintenance 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease Expenditures 349,179 464,871 Salaries & Wages 440,545 20,915 21,358 28,732 Overtime 30,000 - 82,375 99,422 Employee Benefits 116,152 3,407 2 ,007 14,222 Uniforms 2,630 470 -405 Seminars & Education 1,510 - -419 Freight, Express & Cartage -- 2,463 2,336 Cellular Phones 3,660 - 364 295 Telephone & Data 305 (5) 40 39 Internet 40 - -7 Photo, Mapping, Print -- 4,210 4,210 Insurance Premium 4,210 421 -331 Insurance Deductible -- 2,198 11,021 Consulting & Professional Fees 20 ,000 68,695 -62 Meals, Promotions & General 200 - 8,138 7,775 Outside Agency Services 8,000 - 164,231 148,441 Tree Maintenance 190,000 (15,000) 8,165 35,979 Lighting -Repairs & Maintenance 20,000 10,000 7,948 14,694 Vehicle -Repairs & Maintenance 6,000 6,000 19,128 36,981 Gas, Oil, Tire, Etc. 28,950 9,000 61,389 114,278 Misc. Equip. -Repairs & Maintenance 40,000 50,000 59,079 119,937 Grounds Upkeep 120,000 - 14,511 22,073 Misc. Equip . Rentals 28,000 - 19,256 19,538 Land Rentals 21,696 - 183,735 220,226 Programs & Event Supplies 272,000 176,800 3,863 5,222 Supplies & Tools 2,500 1,000 181 642 Software & Hardware Mtce. Contracts 720 (165) 7,236 1,822 Misc. Equipment 50,400 (44,370) 4,274 20,345 Other Fixed Assets 35,000 (5,000) 1,913 -Taxes -Tenant 2,500 - 1,027,241 1,394,325 Total Expenditures 1,445,018 282,168 Revenues (19,912) (22,985) Other User Fees (25,000) (35,100) (19,912) (22,985) Total Revenues (25,000) (35,100) Transfers 108 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 461,460 4.75% 30,000 - % 119,559 2.93% 3,100 17.87% 1,510 - % --% 3,660 -% 300 (1 .64%) 40 - % -- % 4,631 10.00% -- % 88,695 343.48% 200 - % 8,000 -% 175,000 (7 .89%) 30,000 50.00% 12,000 100.00% 37,950 31 .09% 90,000 125.00% 120,000 - % 28,000 -% 21,696 - % 448,800 65.00% 3,500 40.00% 555 (22.92%) 6,030 (88.04%) 30,000 (14 .29%) 2,500 -% 1,727,186 19.53% (60,100) 140.40% (60,100) 140.40% City of Pickering 2023 Approved Current Budget Summary 10305 Property Maintenance 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease (6,055) 1,338 Transfer to(from) Cntg Sty Res . -(13,695) -(50,000) Transfer to(from) Reserve (50,000) (388,700) (15,000) (15,000) Transfer to (from) Oblig RF (15 ,000) - (21,055) (63,662) Total Transfers (65,000) (402,395) 986,274 1,307,678 Net Expenditures (Revenues) 1,355,018 (155,327) 109 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 (13,695) -% (438,700) 777.40% (15,000) -% (467,395) 619.07% 1,199,691 (11.46%) 10310 Fleet Services 2021 2022 Actuals Actuals 1,052,996 1,059,252 30,268 57,910 288,022 277,209 23,691 24,199 -2,658 564 5,556 650 1,419 2,235 3,626 138 977 2,104 1,981 11,772 14,021 4,680 306 -- 5 ,050 5,050 258 857 338 823 1,965 61 ,654 117 - 495 501 11,618 9,430 14,454 19,485 4,449 4,340 -- 74 - 5,068 2,753 521 (13) 70,376 76,934 -1,888 18,168 15,818 500 - -15 1,550,571 1,648,649 (218,018) (133,117) (218,018) (133,117) City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Expenditures Salaries & Wages 1,295,071 112,624 Overtime 45,000 5,000 Employee Benefits 387,161 21,587 Uniforms 25,400 2,000 Conferences -- Seminars & Education 19,900 4,070 Travel 550 - Freight, Express & Cartage 1,800 - Environmental Charges 2,000 - Cellular Phones 2,400 - Telephone & Data 16,995 (5,295) Internet 305 - Subscriptions & Publications 200 - Insurance Premium 5,050 505 Meals, Promotions & General 800 - Memberships 2,400 (1,375) Outside Agency Services 145,500 80,000 Highway Aids -Repairs & Maintenance -- Building -Repairs & Maintenance 5,000 - Vehicle -Repairs & Maintenance 8,000 - Gas, Oil, Tire, Etc. 8,290 11,000 Misc. Equip. -Repairs & Maintenance 5,000 - Misc. Equip . Rentals 500 - Stationary & Office Supplies -- Forms 2,000 4,000 Programs & Event Supplies -- Supplies & Tools 62,875 - Educational Material -- Software & Hardware Mtce. Contracts 42,400 3,290 Furniture & Fixtures -- Misc. Equipment 1,000 1,000 Total Expenditures 2,085,597 238,406 Revenues Netted Revenue (193,000) - Total Revenues (193,000) - 110 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 1,407,695 8.70% 50,000 11 .11% 408,748 5 .58% 27,400 7.87% --% 23,970 20.45% 550 -% 1,800 -% 2,000 -% 2,400. -% 11,700 (31.16%) 305 -% 200 -% 5,555 10.00% 800 -% 1,025 (57.29%) 225,500 54 .98% --% 5,000 -% 8,000 -% 19,290 132.69% 5,000 -% 500 -% --% 6,000 200 .00% --% 62,875 -% --% 45,690 7.76% --% 2,000 100.00% 2,324,003 11.43% (193,000) -% (193,000) - % 10310 Fleet Services 2021 2022 Actuals Actuals -- 1,332,553 1,515,532 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Transfers Total Transfers -- Net Expenditures (Revenues) 1,892,597 238,406 111 Run Date : Sep 13, 2023 2023 Approved %Change Budget From 2022 -- % 2,131,003 12.60% 10315 Roads 2021 2022 Actuals Actuals 3,002,473 3,227,440 220,005 308,205 798,415 835,573 44,723 49,418 -1,218 5,743 11,749 -54 178 875 -1,528 4,873 4,677 2,352 2,624 357 343 -- 150,950 150,950 6,511 12,292 -- 1,679 3,166 3,024 2,851 54,518 52,746 513,773 782,575 166,095 175,124 130,866 59,315 188,896 218,543 438,646 456,713 104,854 116,640 77,087 92,083 135,450 135,718 127,310 222,657 362,495 364,498 366,301 534,005 140,107 198,788 46 71 -40,147 13,119 26,595 8,100 - 3,290 6 ,795 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Expenditures Salaries & Wages 3,275,021 332,312 Overtime 286,500 - Employee Benefits 869,347 74 ,137 Uniforms 27,510 4,360 Conferences -- Seminars & Education 23,625 (5,625) Travel 500 - Freight, Express & Cartage -- Environmental Charges -- Cellular Phones 10,350 (450) Telephone & Data 2,730 670 Internet 340 - Subscriptions & Publications 200 - Insurance Premium 150,950 15,095 Insurance Deductible 25,000 (5,000) Consulting & Professional Fees 5,000 - Meals, Promotions & General 4,000 - Memberships 4 ,240 - Outside Agency Services 53,000 16,500 Winter Control Maintenance 831,000 15,000 Repairs & Maintenance Contract Servic 247,000 1,600 Engineering -Repairs & Maintenance 265,000 118 ,500 Storm Sewer -Repairs & Maitenance 390,000 (20,000) Repairs & Maintenance Materials 575,000 20,000 Highway Aids -Repairs & Maintenance 75,000 - Engineering Highway Aids -Repairs & 160,000 (40,000) Building -Repairs & Maintenance 135,450 13,650 Tree Maintenance 150,000 - Vehicle -Repairs & Maintenance 340,000 - Gas, Oil, Tire, Etc. 478 ,110 56,000 Misc. Equip . -Repairs & Maintenance 120,000 - Grounds Upkeep -- Misc. Equip . Rentals 30,000 - Supplies & Tools 15,000 - Utilities -Water 14,000 - Software & Hardware Mtce . Contracts 7,430 (703) 112 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 3,607,333 10 .15% 286,500 -% 943,484 8.53% 31,870 15.85% --% 18,000 (23 .81%) 500 -% --% --% 9,900 (4.35%) 3,400 24.54% 340 -% 200 -% 166,045 10.00% 20,000 (20 .00%) 5,000 -% 4 ,000 -% 4 ,240 -% 69,500 31 .13% 846,000 1 .81% 248,600 0.65% 383,500 44.72% 370,000 (5 .13%) 595,000 3.48% 75,000 -% 120,000 (25 .00%) 149,100 10.08% 150,000 -% 340,000 -% 534,110 11 .71% 120,000 -% --% 30,000 -% 15,000 -% 14,000 -% 6 ,727 (9.46%) 10320 Parks 2021 2022 Actuals Actuals 2,566,456 2,623,170 68,515 109,538 581,080 608,498 37,527 32,433 1,674 14,274 69 371 -5,137 -82 8,210 8,018 2,834 2,460 238 229 -- 17,850 17,850 3,530 - 1,562 784 171 671 1,747 947 60,306 50,918 -(79) -- 46,794 54,961 199,916 179,473 97,160 79,028 -344 77,525 92,467 182,615 254,642 92,410 84,617 226,824 285,972 33,379 41,684 93,912 125,781 -1,984 62,657 101,245 3,923 21,665 -13,904 56,723 59,219 62,909 77,971 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Expenditures Salaries & Wages 2,528,434 269,854 Overtime 118,000 (10,000) Employee Benefits 586,389 20,162 Uniforms 29,000 1,200 Seminars & Education 23,050 (10,905) Travel 500 - Freight, Express & Cartage -- Environmental Charges -- Cellular Phones 7,300 - Telephone & Data 2,860 (360) Internet 2,030 (1 ,500) Photo, Mapping, Print 200 - Insurance Premium 17,850 1,785 Insurance Deductible 7,050 (2,000) Consulting & Professional Fees 15,000 7,380 Meals, Promotions & General 1,100 - Memberships 3,120 (360) Outside Agency Services 54,200 - Winter Control Maintenance -- Repairs & Maintenance Contract Servic 50,000 105,600 Repairs & Maintenance Materials 65,000 (17,500) Building -Repairs & Maintenance 175,885 15,305 Tree Maintenance 80,000 - Lighting -Repairs & Maintenance -- Vehicle -Repairs & Maintenance 94,000 - Gas, Oil, Tire, Etc. 200,660 54,000 Misc. Equip. -Repairs & Maintenance 80,000 10,000 Grounds Upkeep 352,500 (56,000) Fert . & Lawn Control 59,000 (4,000) Misc. Equip . Rentals 172,800 (70,800) Stationary & Office Supplies -- Programs & Event Supplies 106,000 (18,000) Supplies & Tools 2,500 1,500 COVID Related Expenses 40,000 (40,000) Utilities -Water 66,600 (2,000) Utilities -Hydro 99,227 (15;002) 114 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 2,798,288 10.67% 108,000 (8.47%) 606,551 3.44% 30,200 4.14% 12 ,145 (47.31%) 500 -% -- % -- % 7,300 -% 2,500 (12.59%) 530 (73 .89%) 200 - % 19,635 10 .00% 5,050 (28 .37%) 22,380 49.20% 1,100 -% 2,760 (11 .54%) 54,200 - % --% 155 ,600 211.20% 47,500 (26.92%) 191,190 8 .70% 80,000 -% -- % 94,000 -% 254,660 26 .91% 90,000 12.50% 296,500 (15.89%) 55,000 (6 .78%) 102,000 (40 .97%) --% 88,000 (16 .98%) 4,000 60 .00% -(100.00%) 64 ,600 (3 .00%) 84,225 (15 .12%) 10320 Parks 2021 2022 Actuals Actuals 6,058 8,679 24,930 4 3,050 20,854 40,690 227,652 178 ,825 579 - 4,868,589 5,221,502 -(48 ,300) (119 ,710) (215 ,170) (54,600) (37,400) (257) - (700) - (175,267) (300,870) -7,378 -- (15,000) (15,000) (15,000) (7,622) 4,678,322 4,913,010 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase I Budget Decrease Software & Hardware Mtce. Contracts 10,270 (660) Misc. Equipment 60,900 (43,200) Other Fixed Assets 110,000 - Taxes -Tenant 233,500 - Miscellaneous Expenses -- Total Expenditures 5,454,925 194,499 Revenues Federal Grants (9 ,000) - Rentals -User Fees (1 50,000) (65,000) Memrl Tree/Ben c h Revenue (33,000) (2,000) Other User Fees -- Misc. Revenue -- Total Revenues (192,000) (67,000) Transfers Transfer to(from) Cntg Sty Res. -(7,380) Transfer to(from) Reserve (53,900) 53,900 Transfer to (from) Oblig RF (15,000) - Total Transfers (68,900) 46,520 Net Expenditures (Revenues) 5,194,025 174,019 115 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 9 ,610 (6.43 %) 17,700 (70.94%) 110,000 -% 233 ,500 -% --% 5,649,424 3.57% (9 ,000) -% (215,000) 43 .33% (35,000) 6 .06% --% --% (259 ,000) 34.90% (7,380) -% -(100.00%) (15 ,000) -% (22,380) (67.52%) 5,368,044 3.35% City of Pickering 2023 Approved Current Budget Summary 10325 Operations Services 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures -674 ,838 Salaries & Wages 906 ,217 (49,728) -90 Overt ime 5,000 - -178 ,919 Employee Benefits 270 ,677 (30,352) 1,098 1,538 Uniforms 3 ,955 1,480 --Conferences 1,800 800 -1,135 Seminars & Education 9,450 (5 ,800) 962 5,057 Travel 4 ,000 - -1,775 Cellular Phones 4,020 325 -2,044 Telephone & Data 2,500 - -267 Internet 350 - --Subscriptions & Publications 200 (200) --Photo, Mapp ing, Print 9 ,000 - -2 ,500 Insurance Premium 2,500 250 -171,505 Consulting & Professional Fees 297,000 98 ,705 -188 Meals , Promotions & General 1,000 - 417 2,939 Memberships 4,700 1,150 --Outside Agency Service.s 4 ,000 (4,000) 258 132 Building -Repairs & Maintenance 2 ,000 - 124 -Vehicle -Repairs & Maintenance -- 1 ,926 -Misc. Equip . -Repairs & Ma intenance -- 41 -Grounds Upkeep -- -2,757 Stationary & Office Supplies 5,000 900 179 -Programs & Event Supplies -- 562 81 Supplies & Tools -- -25,841 Software & Hardware Mtce . Contracts 68,185 (6,255) --Furniture & Fixtures -3 ,000 5,567 1,071,606 Total Expenditures 1,601,554 10,275 Revenues -(6,000) Municipal Rent als (6 ,000) - --Rebates & Ince ntives (40 ,000) - -(6,000) Total Revenues (46,000) - Transfers --Transfer to/(from) DC Oblg RF (39 ,140) (28,360) -19,702 Transfer to(from) Cntg Sty Res . -(19 ,705) 11 6 Run Date : Sep 13 , 2023 2023 Approved %Change Budget From 2022 856,489 (5.49%) 5,000 -% 240,325 (11 .21 %) 5,435 37.42 % 2 ,600 44.44% 3,650 (61.38%) 4,000 -% 4,345 8 .08% 2,500 -% 350 -% -(100 .00%) 9,000 -% 2,750 10 .00 % 395 ,705 33 .23% 1,000 -% 5,850 24.47% -(100.00%) 2 ,000 -% --% --% --% 5,900 18 .00% --% --% 61,930 (9 .17%) 3,000 -% 1,611,829 0.64% (6 ,000) -% (40,000) -% (46 ,000) -% (67 ,500) 72.46 % (19 ,705) -% City of Pickering 2023 Approved Current Budget Summary 10325 Operations Services 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease --Transfer to(from) Reserve (60 ,860) (11,640) -19,702 Total Transfers (100,000) (59,705) 5,567 1,085,308 Net Expenditures (Revenues) 1 ,455,554 (49,430) 117 Run Date : Sep 13 , 2023 2023 Approved % Change Budget From 2022 (72,500) 19 .13% (159,705) 59.71% 1,406,124 (3.40%) City of Pickering 2023 Approved Current Budget Summary 10330 Major Capital Facilities 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures --Salaries & Wages -126,500 --Overtime -1,250 --Employe e Benefits -34,800 --Seminars & Education -1,000 --Travel -1,000 --Cellular Phones -1,200 --Telephone & Data -625 --Photo, Mapping , Print -2 ,250 --Insurance Premium -700 --Meals, Promotions & General -250 --Building -Repairs & Maintenance -1,850 --Building Rentals -9 ,700 --Stationary & Office Supplies -750 --Supplies & Tools -100 --Software & Hardware Mtce . Contracts -8 ,000 --Total Expenditures -189,975 Revenues - - Total Revenues - - Transfers --Transfer to(from) Reserve -(189 ,975) - - Total Transfers -(189,975) - - Net Expenditures (Revenues) -- 118 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 126,500 - % 1,250 - % 34,800 -% 1,000 - % 1,000 -% 1,200 -% 625 -% 2,250 -% 700 -% 250 -% 1,850 - % 9,700 -% 750 - % 100 -% 8 ,000 - % 189,975 -% --% (189 ,975) - % (189 ,975) - % -- % Corporate Services Department The Corporate Services Department supports the City's ongoing operations by providing legal, legislative, municipal law enforcement and information technology services to Council and to all City Departments. 'I Corporate Services Department '-. I I I I I ' .., r ..,, r "I Information Legal Services Legislative Municipal Law Technology Services* Enforcement)\ .J ~ ~ * Includes Clerks Office, Records Management & Elections and Print Shop/Mail Room " Includes By-law Enforcement Services and Animal Services Key Activities for 2023 • • • • • • • • • • • • • • • Research and recommendations to implement a Lobbyist Registry for the City of Pickering Research and recommendations to update and modernize the City's Procedure By-law and Council Code of Conduct Implement an updated Boards and Committees Policy and the establishment and support for new Advisory Committees Research and recommendations to update the City's Record Retention Policies New online portal for permit applications Service Modernization -Digital Strategy and Implementation Ongoing enhancements to network security Migrate from legacy copper-based Primary Rate Interface (PRI) connectivity to digital Session Initiation Protocol (SIP) connectivity Implement vulnerability, mitigation, detection and response system to automate patching of network connected devices Storage Area Network upgrades -move to new technology due to the end of life storage hardware Citrix Environment Upgrade and VMWare (Server Virtualization Platform) Upgrade Hybrid AV requirements for meeting rooms. City staff are currently operating in a hybrid working environment and existing meeting room technology needs to be updated to support hybrid work environment and provide IT staff with the ability to remotely support staff virtually regardless of the facility. Data backup architecture review and disaster recovery solution review and testing (including review of data retention, ability to restore, and resilience to ransomware attack) Prepare updated Sign By-law for Council approval Update the Noise and Nuisance BY-lpfg Corporate Services Department • Review and comment on Short-Term Rentals • Enact E-Scooter By-law • Private Tree Protection By-law to be provided to Council for implementation • Processing and enforcement related to Circus, Rib Fest and Butter Tart Festival on Pickering Town Centre property as private events • Review and potential implementation regarding backyard chicken pilot project • Launched a new Animal Management Software program with Online Licensing options • Continuing to offer a Community Pet Pantry to ensure all pet owners have access to food and supplies for their pet • In 2022, the Animal Services Satellite Adoption Centre Volunteers collectively contributed to 888 hours of volunteer work where they helped us feed, clean and socialize cats while at our satellite adoption site located at PetSmart • Host Indigenous Led programs and educate close to 200 people on our deep connection with animals • Received a 5-year, $25,000 sponsorship for the Canine Activity Area at Dunmoore Park • 30 Active Volunteers for Animal Services • Negotiate and coordinate contracts defining City Centre Project • Legal support and contract negotiation for sale of City's interest in Elexicon Inc. • Negotiate and complete Agreements of Purchase and Sale for parcels of Seaton employment lands • Land acquisition and collaboration with TRCA on connection of City's Waterfront Trail • Negotiate lease terms for new Animal Shelter and project management of shelter design and construction • Update the waterfront parking strategy Financial Information 2019 Full-Time 38 Reg. Part-Time 5 Total 43 Staffing Summary (Full & Regular Part-Time) Approved Prior Term 2020 2021 2022 Add 41 41 43 5 6 7 8 - 47 48 51 5 120 Approved New Term 2023 Convert Total 1 49 -1 7 -56 Corporate Services Department The department proposes the following new positions: • One new full-time Clerk, Administration, Vital Stats & Lottery Licensing to provide for additional supports in customer service and administrative tasks within Legislative Services and to reduce the impact of staff absences • One new full-time Legislative Coordinator (Council Resolution #54/22) to assist with policy development, provide updates and support for legislated changes, and to lead and oversee special projects within Legislative Services • One new full-time administrative assistant to support for IT, Clerk's and Municipal Law Enforcement Services • One new full-time Amanda Software Administrator to maintain and administer the day-to-day requirements of the Corporate Amanda system • One new full-time Business Analyst to assess how the city is performing and help them improve their processes and systems. They will also conduct research and analysis in order to come up with solutions to business problems and help to introduce these solutions • Conversion of one part-time Animal Shelter Attendant position to full time to ensure adequate staffing of animal shelter per statutory requirements and to accommodate additional animals brought to the shelter by the Town of Wh itch u rch-Stouffvi I le Year-Over-Year (Net Cost) Budget Changes 2022 2023 Year-Over-Year Approved Approved Change Budget Budget ($) (%) Legal Services $470,706 $624,573 $153,867 32.69% Information Technology 3,052,516 3,537,165 484,649 15.88% Clerk's Office 229,545 346,402 116,857 50.91% Records Mgmt. & Elections 155,757 177,016 21,259 13.65% Print Shop/Mail Room 555,357 561,750 6,393 1.15% By-Law 515,047 290,071 (224,976) (43.68%) Animal Services 548,009 586,532 38,523 7.03% Total (Net Cost) $5,526,937 $6,123,509 $596,572 10.79% 1 21 Corporate Services Department Explanation of Significant Budget Changes -Expenditures Expenditures -Increases I (Decreases) Salaries and Benefits -$547,000 Budget increase largely reflects proposed new staff including: one new full-time Clerk, Vital Statistics and Lotteries, one new full-time Legislative Coordinator, Animal Services Attendant and Clerk additional hours, one new full-time administrative assistant shared between IT, Clerk's and MLES. Postage -($75,000) Decrease is due to the completion of the 2022 election. Insurance -$42,300 Increase is primarily due to Cyber insurance cost moved to the IT cost centre's budget. Consulting and Professional -$215,500 Increase due to: additional research required regarding legal jurisdiction over Frenchman's Bay -$79,000, increased Integrity Commissioner fees -$50,000, Corporate Software Strategic Plan -$57,000, Corporate Systems Integration Support - $9,500, Online Building Permit Portal (PRISM) -$30,000 and Compliance Audit Committee costs -$9,000. Outside Agency Services -$48,600 Increase is primarily due to one-time cost for WiFi hubs, communications and signage associated with the 2023 Waterfront parking program along with new accounting for property remediation costs charged to owners under the City's By-laws (offsetting recoveries reflected in Miscellaneous Revenues). Land Rentals -$13,600 Increase is due to the new Animal Shelter location land lease beginning in April 2023. COVID Related Expenditures ($194,300) $191,530 in hardware costs were transferred to Misc. Equipment. All remaining COVID related expenses have been removed from the budget. Software and Hardware Maintenance -($107,200) Decrease is primarily due to completion of the 2022 election ($280,500), partially offset by an increase in the budget for software licensing fees and Hotspot App for Waterfront parking program of $10,000. Systems & Software Upgrades -($15,100) Decrease due to completion of the Adobe license upgrade in 2022 ($27,800) offset by increases in security and project management software. 122 Corporate Services Department Hardware Replacements -$41,000 Increase in data system costs due to growth. Misc. Equipment -$223,000 $191,530 was transferred from the COVID Related Expenses budget. The remaining increase is due to requirements for additional computers and peripherals for proposed new staff. Revenues/Transfer from Reserves -(Increases) I Decreases Federal Grants -($18,900) Increase in 2023 Canada Summer Jobs partial grant funding (Animal Shelter and By- law Enforcement staff). Ontario Grants -$32,500 $10,000 decrease in the Streamline Development Approval funding in 2023 and transfer of PetSmart Charities Grant of $20,000 to Other Agency Grants account. Other Agency Grants -($30,000) Increase reflects transfer of PetSmart Charities Grant of ($20,000) from Ontario Grants as well as an increase in this grant for 2023. Licences & Permits -($58,500) Increase reflects prior year trends and return to normal operations for all categories of licenses, sign permits and Vehicle for Hire trip fees. Fines & Charges -($420,000) Increase reflects the trend in Waterfront parking program revenues. Transfer from Reserve -$359,500 Decrease is mainly due to $435,075 in funding from the Election Reserve not required in 2023, partially offset by new funding of ($65,800) for the IT Capability Study from the Rate Stabilization reserve. 123 Corporate Services Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 2022 Information Technology SeNice Support Requests (Help 6,042 6,841 6,723 Desk tickets) Staff connection -remote staff 252 258 268 connections Employees trained in information 375 502 561 security awareness Systems Availability 98.5% 98.9% 99.1% Projects Completed 17 49 47 Legislative Services Committee & Council Meetinqs 70 66** Burial Permits Issued 1081 1,109 Marriaqe Licences Issued 519 879 Freedom of Information Requests 60 36 **Note: Council/Committee Meetings ended at the end of September due to the Municipal Election -no meetings were held for the months of October and November with the exception of the lnauQural Meetinq of Council. Legal Services Development-related AQreements 20 23 20 Instruments Registered in Teraview 101 84 101 (Land Reqistrv Office) Enforcement Services Parking Tickets Issued 20,409 17,690 31,753 Parking Fine Revenue $565,300 * $625,077 $1,448,700* COVID-19 Enforcement -# park 14,239 24,893 N/A patrols By-law Violations Requests for 1,326 1,572 1,667 SeNice Parking Enforcement Requests for 910 1,133 1,336 SeNice Animal SeNices Requests for 925 942 779 SeNice Animals Sheltered ( cats/dogs/small 394 405 425 animals) Animals Adopted 298 211 280 Lost pets found and returned 92 85 100 * subject to increase per MTO reconciliation 124 City of Pickering 2023 Approved Current Budget Summary Corporate Services Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease Expenditures 3 ,565,618 4,111,102 Salaries & Wages 4,270,488 435,951 89,358 122,397 Overtime 92,239 6,000 906,492 985,975 Employee Benefits 1,095,851 105,057 -336 Employee Recognition -- 15,053 14,374 Uniforms 20,200 1,200 499 3,843 Conferences 3 ,600 4,400 32,113 39,688 Seminars & Education 63,400 520 9,641 12,817 Corporate Training 16,000 2,000 216 1,914 Travel 4,200 - 135,197 224,009 Postage 231,000 (75,000) 3,636 4,376 Freight, Express & Cartage 3,100 1 ,400 -10 Environmental Charges -- 15,350 19,982 Cellular Phones 24,760 2,900 19,609 24,901 Telephone & Data 27,555 (2,740) 5,091 1,910 Internet 2,140 - 568 104 Advertising 800 - 8,314 9,469 Subscriptions & Publications 8,395 440 10,651 10,556 Legal Services Expense 12,000 - 24,620 24,620 Insurance Premium 24,620 42,314 --Insurance Deductible 2,000 - 107,367 118,381 Consulting & Professional Fees 224,000 215,500 2,564 4,459 Meals, Promotions & General 8,500 3 ,000 5 ,034 3 ,902 Memberships 14,500 100 102,460 223,549 Outside Agency Services 129,175 48,625 13,683 23,134 Building -Repairs & Maintenance 12,358 13,000 18,142 18,964 Vehicle -Repairs & Maintenance 12,800 - 29,721 36,439 Gas, Oil, Tire, Etc. 38,155 1,000 13,351 16,500 Misc. Equip. -Repairs & Maintenance 46,100 1,200 15,308 15,571 Building Rentals 17,406 92 --Land Rentals -13,600 5,942 14,867 Stationary & Office Supplies 18,400 (6,500) 5,969 7,838 Forms 8,000 2,000 172,057 229,716 Supplies & Tools 228,202 7,400 -55,393 COVID Related Expenses 194,530 (194,530) --Utilities -Water -3,300 5,416 4,407 Utilities -Hydro 6,798 10,502 125 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 4,706,439 10.21% 98,239 6 .50% 1,200,908 9.59% --% 21,400 5 .94% 8,000 122.22% 63,920 0.82% 18,000 12 .50% 4,200 -% 156,000 (32.47%) 4,500 45 .16% --% 27,660 11 .71% 24,815 (9.94%) 2,140 -% 800 -% 8,835 5 .24% 12,000 -% 66,934 171 .87% 2,000 -% 439,500 96.21% 11,500 35 .29% 14,600 0.69% 177,800 37.64% 25,358 105.20% 12,800 -% 39,155 2.62% 47,300 2 .60% 17,498 0 .53% 13,600 -% 11,900 (35 .33%) 10,000 25 .00% 235,602 3.24% -(100 .00%) 3 ,300 -% 17,300 154.49% City of Pickering 2023 Approved Current Budget Summary Corporate Services Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease --Utilities -Natural Gas -6,700 5 ,659 5 ,106 Utilities -Oil 6 ,500 - 550,674 939 ,130 Software & Hardware Mtce . Contracts 1,067,496 (102,425) 72,687 50,204 System & Software Upgrade 161,799 (15,099) 18 ,3 95 33,181 Hardware Replacements 59,400 41,000 1,151 -Furniture & Fixtu res -- 46,588 22,775 Misc. Equipme nt 57,795 22 3 ,000 14,726 23 ,666 Parking MOT 75 ,000 - -755 Livestock Killed 500 - 6 ,048,920 7,460,320 Total Expenditures 8,289 ,762 795,907 Revenues -(16 ,800) Federal Grants -(18,900) -(103,200) Ontario Grants (284 ,680) 32 ,500 (1 ,250) -Other Agency Grants -(30,000) (285,160) (311,465) Department User Fees (276,810) (7 ,690) (49,421) (373,140) Other User Fees (330,800) (9,200) (454 ,685) (684,466) Licences & Permits (445 ,500) (58,500) (651 ,649) (1 ,519 ,332) Fines & Charges (882,000) (420,000) (3,212) (4 ,363) Donations -- -(800) Sponsorships (3 ,000) - (1 ,000) (1 ,250) Marketing Sponsors (2 ,000) (5,000) (1,446,377) (3,014,816) Total Revenues (2,224,790) (516,790) Transfers (16,827) -Transfer to(from) Cntg Sty Res . -- -(435 ,075) Transfer to(from) Reserv e (53 8,035) 359,555 (16,827) (435,075) Total Transfers (538,035) 359 ,555 4,585,716 4,010,429 Net Expenditures (Revenues) 5,526,937 638,672 Cherrywood Development --Consulting & Professional Fees -100,000 --Transfer to(from) Reserve -(100,000) --Net Expenditures (Revenues) - - 4,585,716 4,010,429 Total Net Expenditures (Revenues) 5,526,937 638,672 126 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 6 ,700 - % 6,500 - % 965 ,071 (9 .59 %) 146,700 (9 .33 %) 100,400 69.02% --% 280,795 385 .85% 75 ,000 - % 500 -% 9,085,669 9.60% (18,900) -% (252 ,180) (11.42%) (30,000) - % (284 ,500) 2 .78 % (340,000) 2.78% (504 ,000) 13 .13% (1,302,000) 47 .62% --% (3,000) -% (7 ,000) 250 .00 % (2 ,741,580) 23.23% --% (178,480) (66 .83%) (178,480) (66 .83%) 6,165,609 11.56% 100,000 -% (100 ,000) - % -- % 6,165 ,609 11.56% 10400 Legal Services 2021 2022 Actuals Actuals 388,564 389,709 361 1,561 100,510 98,815 -336 1,208 853 -- 596 1,499 1,159 1,170 159 153 8,120 9 ,255 10,651 10,556 3,530 3 ,530 63,128 77,499 -442 3,098 2,653 1,079 1,808 -161 188 691 582,351 600,691 (187,379) (205 ,197) -(106) (187,379) (205,303) -- -- 394,972 395,388 -- -- -- City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Expenditures Salaries & Wages 499,977 30,767 Overtime 1,500 - Employee Benefits 127,984 3,457 Employee Recognition -- Seminars & Education 4,500 - Travel 750 - Cellular Phones 1,600 - Telephone & Data 1,215 - Internet 150 - Subscriptions & Publications 7 ,645 440 Legal Services Expense 12,000 - Insurance Premium 3,530 353 Consulting & Professional Fees 71,000 119,000 Meals, Promotions & General 500 - Memberships 6,550 - Stationary & Office Supplies 1,500 - Supplies & Tools -- Software & Hardware Mtce. Contracts 775 (140) Total Expenditures 741,176 153,877 Revenues Department User Fees (167,510) 8,510 Other User Fees -- Total Revenues (167,510) 8,510 Transfers Transfer to(from) Reserve (102,960) (8,520) Total Transfers (102,960) (8,520) Net Expenditures (Revenues) 470,706 153,867 Cherrywood Development Consulting & Professional Fees -100,000 Transfer to(from) Reserve -(100,000) Net Expenditures (Revenues) -- 127 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 530,744 6 .15% 1,500 - % 131,441 2 .70% --% 4,500 - % 750 - % 1 ,600 -% 1,215 -% 150 - % 8 ,085 5.76% 12,000 - % 3,883 10.00% 190,000 167.61% 500 - % 6,550 - % 1,500 -% -- % 635 (18.06%) 895,053 20.76% (159,000) (5 .08%) -- % (159,000) (5.08%) (111,480) 8 .28% (111,480) 8.28% 624,573 32.69% 100,000 -% (100,000) - % --% 10400 Legal Services 2021 2022 Actuals Actuals 394,972 395,388 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Total Net Expenditures (Revenues) 470,706 153,867 128 Run Dat e: Sep 13 , 2023 2023 Approved % Change Budget From 2022 624,573 32.69% City of Pickering 2023 Approved Current Budget Summary 10405 Information Technology 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 1,034,702 1,210,632 Salaries & Wages 1,409,797 153,216 55,524 62,098 Overtime 64,000 6,000 285,972 296 ,645 Employee Benefits 359,962 39,324 --Uniforms 800 - -2,347 Conferences 2,000 4,000 24,237 30,676 Seminars & Education 45,400 - 9,641 12,817 Corporate Train ing 16,000 2,000 -1,433 Travel 1,200 - -15 Freight, Express & Cartage -- -11 Environmental Charges -- 7,587 10,625 Cellular Phones 9,900 900 4,098 4,996 Telephone & Data 7 ,355 (1 ,655) 636 610 Internet 850 - 30 -Subscriptions & Publications -- 8,000 8,000 Insurance Premium 8 ,000 40,652 26,966 38,287 Consulting & Professional Fees 147,000 82,500 482 348 Meals, Promotions & General 1,000 - 464 454 Memberships 5,400 - -458 Outside Agency Services 2,400 - --Building -Repairs & Maintenance -15,000 -10 Vehicle -Repairs & Maintenance -- 13,351 16,500 Misc. Equip . -Repairs & Maintenance 46,100 1,200 1,212 147 Stationary & Office Supplies 3,700 - 174 -Supplies & Tools -- -55,393 COVID Related Expenses 191,530 (191,530) --Utilities -Water -3,300 --Utilities -Hydro -12,000 --Utilities -Natural Gas -6,700 503 ,249 617,133 Software & Hardware Mtce. Contracts 712,808 156,141 72,687 50,204 System & Software Upgrade 161 ,799 (15,099) 18,395 33,181 Hardware Replacements 59,400 41,000 1,151 -Furniture & Fixtures -- 46,466 22,775 Misc. Equipment 57,795 223,000 2,115,024 2,475,795 Total Expenditures 3,314,196 578,649 Revenues 129 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 1,563,013 10 .87% 70,000 9 .38% 399,286 10.92% 800 -% 6,000 200.00% 45,400 -% 18,000 12 .50% 1,200 -% --% --% 10,800 9.09% 5,700 (22.50%) 850 -% --% 48 ,652 508 .15% 229,500 56.12% 1,000 -% 5,400 -% 2,400 -% 15,000 -% --% 47,300 2 .60% 3,700 -% --% -(100 .00%) 3,300 -% 12,000 -% 6,700 -% 868,949 21.91% 146,700 (9 .33%) 100,400 69.02% --% 280,795 385.85% 3,892,845 17.46% City of Pickering 2023 Approved Current Budget Summary 10405 Information Technology 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease -(102,415) Ontario Grants (261,680) 10 ,000 -(102,415) Total Revenues (261,680) 10,000 Transfers --Transfer to(from) Reserve -(67,000) - - Total Transfers -(67,000) 2,115,024 2,373,380 Net Expenditures (Revenues) 3,052,516 521,649 130 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 (251,680) (3 .82%) (251,680) (3.82%) (67,000) -% (67,000) -% 3,574,165 17.09% City of Pickering 2023 Approved Current Budget Summary 10415 Records Management & E lections 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 59,957 106,844 Salaries & Wages 93 ,507 (19,178) 376 6 ,802 Overtime 2 ,000 - 28 ,978 23,417 Employee Benefits 25,780 (1 ,926) 1,211 -Seminars & Education 1,500 - --Travel 500 - -74,875 Postage 75,000 (75,000) 511 590 Telephone & Data 605 95 79 77 Internet 75 - 880 880 Insuran ce Premium 880 88 17 ,272 2 ,595 Consulting & Professional Fees 6,000 4 ,000 5 ,540 32,942 Outside Agency Services 49 ,875 (38,875) 162 5,631 Stationary & Office Supplies. 8,500 (6,500) --COVID Related Expenses 3,000 (3 ,000) 30 ,747 298,239 Software & Hardware Mtce . Contracts 323 ,610 (273,520) 145,713 552,892 Total Expenditures 590 ,832 (413,816) Revenues --Total Revenues -- Transfers (16,827) -Transfer to(from) Cntg Sty Res . -- -(435 ,075) Transfe r to(from) Reserve (4 35,075) 435 ,075 (16 ,827) (435,075) Total Transfers (435,075) 435,075 128,886 117,817 Net Expenditures (Revenues) 155,757 21,259 132 Run Date : Sep 13 , 2023 2023 Approved %Change Budget From 2022 74,329 (20 .51 %) 2,000 -% 23,854 (7.47%) 1,500 -% 500 -% -(100 .00%) 700 15.70% 75 -% 968 10 .00% 10 ,000 66 .67% 11,000 (77 .94%) 2 ,000 (76.47%) -(100 .00%) 50,090 (84 .52%) 177,016 (70.04%) -- % --% -(100 .00 %) -(100.00%) 177,016 13.65% City of Pickering 2023 Approved Current Budget Summary 10420 Print Shop/Mail Room 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 87 ,286 111,140 Salaries & Wages 114,355 1,506 -1,735 Overtime 1 ,000 - 21 ,787 28,124 Employe e Benefits 30,065 (211) 135,197 149,1 34 Postage 156 ,000 - 3,636 4 ,3 61 Freight, Ex press & Cartage 3 ,100 1,400 681 590 Telephone & Data 605 95 79 77 Internet 75 - 2 ,380 2 ,380 Insuran ce Premium 2,380 238 34,131 34 ,975 Outside Agency Services 37,500 1,500 729 1,338 Stationary & Office Supplies 1,500 - 149,836 202 ,154 Supplies & Tools 208,602 1,900 45 158 Software & Hardware Mtce . Contracts 175 (35) 435,787 536,166 Total Expenditures 555,357 6,393 Revenues - - Total Revenues -- Transfers - - Total Transfers - - 435,787 536,166 Net Expend itures (Revenues) 555 ,357 6,393 133 Run Date : Sep 13 , 2023 2023 Approved % Change Budget From 2022 115,861 1 .32 % 1,000 -% 29 ,854 (0 .70 %) 156,000 - % 4,500 45 .16% 700 15.70% 75 - % 2,618 10.00% 39 ,000 4 .00% 1,500 - % 210,502 0 .91% 140 (20.00%) 561,750 1.15% --% -- % 561,750 1.15% 10425 By-Law 2021 2022 Actuals Actuals 1,156,820 1,438 ,311 24 ,219 25 ,568 270,650 330,652 12,771 11,441 4,360 6 ,265 -10 -(1) 4,027 6,166 3 ,775 4,383 597 573 4 ,920 4,920 -- 496 237 25,129 91 ,966 13,186 11,066 24,150 28,289 1,028 2 ,753 5,969 7,838 1,468 744 16 ,102 18,186 122 - 14,726 23,666 1,584,515 2,013,033 -(12,600) (22,557) (340,745) (234,880) (288 ,001) (651,011) (1 ,515,292) (908 ,448) (2,156,638) -- 676,067 (143,605) City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Expenditures Salaries & Wages 1,328,915 111,725 Overtime 15,739 - Employee Benefits 341,756 27,953 Uniforms 15,800 800 Seminars & Education 8,000 - Travel 900 - Environmental Charges -- Cellular Phones 8,760 2,000 Telephone & Data 4,555 (855) Internet 570 - Insurance Premium 4,920 492 Insurance Deductible 2,000 - Memberships 900 100 Outside Agency Services 5,500 81,000 Vehicle -Repairs & Maintenance 10 ,000 - Gas, Oil, Tire, Etc. 27,160 2 ,000 Stationary & Office Supplies 600 - Forms 8 ,000 2,000 Supplies & Tools 2,000 - Software & Hardware Mtce. Contracts 19,272 10,109 Misc . Equipment -- Parking MOT 75 ,000 - Total Expenditures 1,880,347 237,324 Revenues Federal Grants -(12,600) Other User Fees (310,800) 800 Licences & Permits (174,500) (30,500) Fines & Charges (880,000) (420,000) Total Revenues (1,365,300) (462,300) Transfers Total Transfers - - Net Expenditures (Revenues) 515,047 (224,976) 134 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 1,440,640 8.41% 15 ,739 -% 369 ,709 8 .18% 16,600 5.06% 8,000 -% 900 - % -- % 10,760 22 .83% 3,700 (18 .77%) 570 - % 5,412 10 .00% 2,000 - % 1,000 11.11% 86,500 1,472 .73% 10,000 -% 29,160 7 .36% 600 -% 10 ,000 25 .00% 2,000 - % 29,381 52.45% --% 75,000 -% 2,117,671 12.62% (12,600) - % (310,000) (0 .26%) (205,000) 17.48% (1,300,000) 47 .73% (1,827,600) 33.86% -- % 290,071 (43.68%) City of Pickering 2023 Approved Current Budget Summary 10430 Animal Services 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 407,242 457,252 Salaries & Wages 442,346 43,571 6,162 9,602 Overtime 6,000 - 89,929 98,905 Employee Benefits 98,490 3,692 2,282 2,933 Uniforms 3,600 400 57 1,894 Seminars & Education 1,500 20 216 282 Travel 350 - 1,907 1,228 Cellular Phones 2,900 - 7,884 11,423 Telephone & Data 11,400 - 3,303 191 Internet 190 - 568 104 Advertising 800 - --Subscriptions & Publications 50 - 2,310 2,310 Insurance Premium 2,310 231 2,082 2,664 Meals, Promotions & General 6,000 3,000 518 100 Memberships 650 - 37,659 63 ,208 Outside Agency Services 33,900 5,000 13,683 23,134 Building -Repairs & Maintenance 12,358 (2,000) 4,956 7,887 Vehicle -Repairs & Maintenance 2,800 - 5,570 8,149 Gas, Oil, Tire, Etc. 10,995 (1,000) 15,308 15,571 Building Rentals 17,406 92 --Land Rentals -13,600 318 829 Stationary & Office Supplies 600 - 20,578 26,657 Supplies & Tools 17,600 5,500 5,416 4,407 Utilities -Hydro 6,798 (1,498) 5,659 5,106 Utilities -Oil 6,500 - 166 4,196 Software & Hardware Mtce. Contracts 10,266 (85) -755 Livestock Killed 500 - 633,773 748,787 Total Expenditures 696,309 70,523 Revenues -(4,200) Federal Grants -(6,300) -(785) Ontario Grants (23,000) 22,500 (1,250) -Other Agency Grants -(30,000) (38,952) (43,673) Department User Fees (39,300) (3,200) (26,864) (32,289) Other User Fees (20,000) (10,000) (46,610) (45,429) Licences & Permits (59,000) - (638) (4,040) Fines & Charges (2,000) - 135 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 485,917 9 .85% 6,000 -% 102,182 3.75% 4,000 11.11% 1,520 1 .33% 350 -% 2,900 -% 11,400 -% 190 -% 800 -% 50 -% 2,541 10.00% 9,000 50.00% 650 -% 38,900 14.75% 10,358 (16 .18%) 2,800 -% 9,995 (9.10%) 17,498 0 .53% 13,600 -% 600 -% 23,100 31 .25% 5,300 (22.04%) 6,500 -% 10,181 (0 .83%) 500 -% 766,832 10.13% (6,300) -% (500) (97.83%) (30,000) -% (42,500) 8 .14% (30,000) 50 .00% (59,000) -% (2,000) -% City of Pickering 2023 Approved Current Budget Summary 10430 Animal Services 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease (3,212) (4 ,363) Donations -- -(800) Sponsorships (3,000) - (1,000) (1 ,250) Marketing Sponsors (2,000) (5,000) (118,526) (136,829) Total Revenues (148,300) (32,000) Transfers --Total Transfers -- 515,247 611,958 Net Expenditures (Revenues) 548,009 38,523 136 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 -- % (3,000) -% (7,000) 250 .00% (180,300) 21.58% -- % 586,532 7.03% Engineering Services Department Overview The Engineering Services Department is responsible for the overall management of major capital works projects (roads, bridges, 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 and sidewalks) • Water Resources & Development Services • Landscape & Parks Development Engineering Services Department I I r 'I r 'I r -...., Capital Projects & Water Resources & Landscape & Parks Development Development Infrastructure* Services '-~ '-'-~ *Includes Crossing Guards, Streetlights and Sidewalks Key Activities for 2023 The Department's key activities include: • Design/Construct Brock Road Clean Water Collector Project • Design/Construct Walnut Lane Extension from Liverpool Road to Kingston Road • Design/Construct Hwy 7 at Sideline 24 -Intersection/Signalization • Complete Rotary Frenchman's Bay West Park Comfort Station & Phase 2 Construction • Complete Breezy Drive/Sunrise Avenue Storm Sewer Outfall Reconstruction 137 Engineering Services Department • Detailed design of Beachfront Park Master Plan • Complete City Centre Transportation Master Plan • Update Fill & Topsoil Disturbance By-law • Complete Pine Creek Erosion Assessment • Undertake comprehensive review of municipal servicing submissions related to Cherrywood, Seaton and other development areas • Review/comment on detailed design drawings for Kingston Road Bus Rapid Transit project • Prepare a Foundation Drainage Discharge Policy • Expand the Automated Speed Enforcement program through the addition of one camera Financial Information 2019 Full-Time 30 Reg. Part-Time - Total 30 Staffing Summary (Full & Regular Part-Time) Approved Prior Term 2020 2021 2022 Add 30 30 32 4 ---- 30 30 32 4 Approved New Term 2023 Transfers Total -36 -- -36 The Department proposes to add four new full-time positions, of which two are related to maintaining levels of service for development approvals for increased number of applications. These costs are offset by increased revenues. The other two positions are to expand the areas of transportation and traffic services and asset management in order to address increased needs and workload in these two areas. The proposed positions are as follows: • One new full-time Manager, Transportation & Traffic Services • One new full-time Senior Coordinator, Asset Management • One new full-time Coordinator, Development Approvals • One new full-time Engineer, Water Resources 138 Engineering Services Department Year-Over-Year (Net Cost) Budget Changes 2022 2023 Year-Over-Year Approved Approved Change Budget Budget ($) (%) Eng. Services -Admin. $2,740,605 $2,731,534 $(9,071) (0.33%) Crossing Guards 424,400 434,140 9,740 2.30% Water Res. & Dev. Serv. 1,008,214 858,312 (149,902) (14.87%) Sidewalks 195,590 235,654 40,064 20.48% Street Lights 1,078,680 1,019,848 (58,832) (5.45%) Total (Net Cost) $5,447,489 $5,279,488 $(168,001) (3.08%) Explanation of Significant Departmental Budget Changes Expenditures -Increases I (Decreases) Salaries & Benefits -$423,900 Increase is largely due to annualization of two positions from 2022 and addition of four proposed new positions in 2023 (July 1 start dates). Insurance Premium -$17,700 Increase reflects the higher premium renewal for 2023. Insurance Deductible -$25,000 Increase reflects last year's actual deductible costs. Consulting & Professional Fees -($107,600) There is a decrease related to projects and assignments that have progressed, are completed, or are no longer required, offset by an increase of $135,000 due to three new projects/assignments. Outside Agency Fees -($104,500) The decrease is due to an adjustment to Automated Speed Enforcement program costs, offset by the cost of adding an additional speed camera in 2023 and an increase in Crossing Guard costs and Ontario One Call fees. 139 Engineering Services Department Utilities -Hydro -($25,000) Decrease reflects last year's actual streetlighting costs partially offset by price increase expected in 2023. Other Fixed Assets -$250,000 The increase is due to re-budgeting of the 2022 sidewalk rehabilitation program to be completed in 2023. Revenues/Transfer from Reserves -(Increases) I Decreases Department User Fees -($315,000) Increase is due to higher anticipated Engineering Design Review fees and Development Inspections fees for Subdivisions and Site Plans. Fines -Automated Speed Enforcement Program -$100,000 Decrease is due to Automated Speed Enforcement program being changed to a cost- recovery model. Cost Recoveries -($235,600) Increase is primarily due to the introduction of a new funding model with the Region of Durham which provides for full recovery of the cost of administering the Automated Speed Enforcement program. Transfer from Development Charge Reserve Fund -$108,600 The decrease is due to progress made in Development Charge funded consulting & professional projects/assignments. Transfer from Continuing Studies Reserve -($65,700) The increase will fund studies carried over from 2022 that are not complete. Transfer from Reserves -$14,800 The decrease relates to partial completion of the Claremont Drainage Plan. As a result, the project will require less funding from the Tax Rate Stabilization Reserve in 2023. Transfer from Reserve Funds -($250,000) The increase will fund the 2022 sidewalk rehabilitation program (FGT) carried over from the prior year. 140 Engineering Services Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 2022 Driveway widening/curb cut 79 95 138 applications Pool enclosure applications 64 94 62 Fill permit applications 23 9 7 Centreline km of roads 347.4/102.1 352/101 353/101 (paved/unpaved) Number of bridges/culverts > 3m 67 66 72 (vehicular/pedestrian) Km of storm sewers 249.5 343 328 Number of Stormwater Management 20 20 20 Facilities (Ponds) Km of sidewalks/trails 381.6 441 443 Number of Streetliqhts 7,358 8,546 8,956 Km of cvclinq lanes 25.3 25.3 25.3 Number of traffic/pedestrian siqnals 25 25 25 Number of school crossing guard 36 36 36 locations 141 City of Pickering 2023 Approved Current Budget Summary Engineering Services Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 2,380,171 2,615,289 Salaries & Wages 3,053,881 341,821 5,092 17,243 Overtime 9,400 6,000 661,460 688 ,694 Employee Benefits 844,323 76 ,1 13 1,065 1,316 Uniforms 3,500 - 215 -Conferences 1,000 - (270) 1,757 Seminars & Education 9,660 1,300 185 14 Travel 2,050 (550) 6 ,014 8,015 Cellular Phones 10,440 650 7,843 8,756 Telephone & Data 9,105 1,095 1 ,192 1,144 Internet 610 500 --Subscriptions & Publications 1,650 (500) 559 1,860 Photo, Mapping, Print 4,000 - 177,246 176,700 Insurance Premium 176,700 17,670 19,396 27,078 Insurance Deductible 7 ,950 25,000 92 ,287 168,020 Consulting & Professional Fees 962,915 (107,624) 15 6,913 Meals, Promotions & General 300 200 8,010 5,926 Memberships 10,040 245 355,938 540,631 Outside Agency Services 789 ,8 00 (104,500) 894 -Winter Control Maintenance -- 37,746 18,708 Repairs & Maintenance Materials 30,000 10,000 6 ,536 7,667 Vehicle -Repairs & Maintenance 13,000 (3,000) 8,565 13,677 Gas, Oil, Tire, Etc. 18,000 (3,500) 324,210 283,223 Misc. Equip. -Repairs & Maintenance 471,200 (10,000) --Misc. Equip . Rentals 200 - 2,826 2,597 Stationary & Office Supplies 3,300 - --Forms 750 - -61 Programs & Event Supplies -- 766 5 ,2 38 Supplies & Tools 8,150 - 456,930 453,529 Utilities -Hydro 500,000 (25,000) 14,229 32,559 Software & Hardware Mtce. Contracts 58,415 (440) 1,723 37,592 Misc. Equipment 51,500 - 160,078 5,151 Other Fixed Assets 260,000 250,000 4,730,921 5,129,358 Total Expenditures 7,311 ,839 475,480 Revenues (1,801,284) (2,309,277) Department User Fees (890,000) (315,000) 142 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 3,395,702 11 .19% 15,400 63 .83% 920,436 9.01% 3,500 -% 1,000 -% 10,960 13.46% 1,500 (26 .83%) 11,090 6.23% 10,200 12.03% 1,110 81.97% 1 ,150 (30.30%) 4,000 -% 194,3 70 10.00% 32 ,950 314.47% 855,291 (11 .18%) 500 66.67% 10,285 2.44% 685,300 (13 .23%) --% 40,000 33.33% 10,000 (23 .08%) 14,500 (19.44%) 461,200 (2.12%) 200 -% 3,300 -% 750 -% --% 8,150 -% 475,000 (5.00%) 57,975 (0 .75%) 51,500 -% 510,000 96.15% 7,787,319 6.50% (1,205,000) 35.39% City of Pickering 2023 Approved Current Budget Summary Engineering Services Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease (57,430) (108,322) Other User Fees -(2,000) --Fines & Charges (100,000) 100,000 (1,738) -Misc. Revenue (2,000) 1,500 (23 ,587) (66 ,950) Cost Recoveries (96,935) (235,605) (1,884,039) (2,484,549) Total Revenues (1,088,935) (451,105) Transfers (40,488) (70,644) Transfer to/(from) DC Oblg RF (488,800) 108,554 (23,649) 76,889 Transfer to(from) Cntg Sty Res. (61,615) (65,679) --Transfer to(from) Reserve (25 ,000) 14,749 (157,788) -Transfer to (from) Oblig RF (200,000) (250,000) (221,925) 6,245 Total Transfers (775,415) (192,376) 2,624,957 2,651,054 Net Expenditures (Revenues) 5,447,489 (168,001) Cherrywood Development --Salaries & Wages -92,600 --Overtime -500 --Employee Benefits -27,780 --Travel -500 --Cellular Phones -3,300 --Building -Repairs & Maintenance -3,700 --Gas, Oil, Tire, Etc. -500 --Building Rentals -19,400 --Stationary & Office Supplies -500 --Supplies & Tools -500 --Software & Hardware Mtce . Contracts -3,000 --Misc. Equipment -30 ,000 --Department User Fees -(5,500) --Licences & Permits -(7,500) --Transfer to(from) Reserve -(169 ,280) --Net Expenditures (Revenues) -- 2,624,957 2,651,054 Total Net Expenditures (Revenues) 5,447,489 (168,001) 143 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 {2,000) -% -(100 .00%) (500) (75 .00%) (332,540) 243 .05% (1,540,040) 41.43% (380 ,246) (22 .21%) (127,294) 106.60% (10,251) (59.00%) (450,000) 125.00% (967,791) 24.81% 5,279,488 (3.08% 92,600 -% 500 -% 27,780 -% 500 -% 3,300 -% 3,700 -% 500 -% 19,400 -% 500 -% 500 -% 3,000 -% 30,000 -% (5,500) -% (7 ,500) -% (169,280) -% -- % 5,279,488 (3.08%) City of Pickering 2023 Approved Current Budget Summary 10500 Engineering Services -Admin 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 1,371,490 1,430,094 Salaries & Wages 1,640 ,860 224 ,760 3 ,524 11 ,764 Overtime 6 ,500 3,000 384,756 388,043 Employee Benefits 458,290 50,815 194 665 Uniform~ 2,000 - 215 -Conferences 1,000 - 1,496 619 Seminars & Education 3,860 - -14 Travel 750 - 3,196 4,710 Cellular Phones 6,120 650 4,182 4,668 Telephone & Data 4,855 1,245 636 610 Internet 610 - --Subscriptions & Publications 1,000 (500) 559 1,860 Photo, Mapping, Print 4,000 - 9,590 9,590 Insurance Premium 9,590 959 534 -Insurance Deductible 2,000 - 52,829 104,773 Consulting & Professional Fees 490,500 (100,027) -6,913 Meals, Promotions & General 200 200 5 ,523 3,780 Memberships 5,740 - 81,886 129,771 Outside Agency Services 355,800 (120,000) 2,056 1,935 Vehicle -Repairs & Maintenance 8,000 (3,000) 3,217 5 ,721 Gas, Oil, Tire, Etc. 10,190 (4,000) --Misc. Equip . -Repairs & Maintenance 200 - --Misc. Equip . Rentals 200 - 1,310 1,683 Stationary & Office Supplies 2,100 - --Forms 750 - -61 Programs & Event Supplies -- 48 495 Supplies & Tools 150 - 4,842 21,140 Software & Hardware Mtce. Contracts 45,840 (200) 1,723 37,592 Misc . Equipment 51,500 - 1,933,806 2,166,501 Total Expenditures 3,112,605 53,902 Revenues -200 Other User Fees -(2 ,000) --Fines & Charges (100,000) 100,000 (1,738) -Misc. Revenue (2,000) 2,000 --Cost Recoveries -(233 ,000) (1,738) 200 Total Revenues (102,000) (133,000) 144 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 1,865 ,620 13 .70% 9,500 46 .15% 509,105 11 .09% 2,000 -% 1,000 -% 3 ,860 -% 750 -% 6,770 10 .62% 6,100 25 .64% 610 -% 500 (50.00%) 4,000 -% 10,549 10.00% 2,000 -% 390,473 (20 .39%) 400 100.00% 5,740 -% 235,800 (33 .73%) 5,000 (37.50%) 6,190 (39 .25%) 200 -% 200 -% 2,100 -% 750 -% --% 150 -% 45,640 (0.44%) 51,500 -% 3,166,507 1.73% (2,000) -% -(100 .00%) -(100 .00%) (233 ,000) -% (235,000) 130;39% City of Pickering 2023 Approved Current Budget Summary 10500 Engineering Services -Admin 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Transfers (34,519) (67,031) Transfer to/(from) DC Oblg RF (270,000) 101,486 (18,557) 31,460 Transfer to(from) Cntg Sty Res . -(31,459) (53,076) (35,571) Total Transfers (270,000) 70,027 1,878,992 2,131 ,130 Net Expenditures (Revenues) 2,740,605 (9,071) 145 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 (168,514) (37 .59%) (31,459) -% (199,973) (25.94%) 2,731,534 (0.33%) City of Pickering 2023 Approved Current Budget Summary 10505 Crossing Guards 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 2,400 2,400 Insurance Premium 2,400 240 264,789 399,432 Outside Agency Services 422,000 9 ,500 267,189 401,832 Total Expenditures 424,400 9,740 Revenues --Total Revenues -- Transfers --Total Transfers -- 267,189 401,832 Net Expenditures (Revenues) 424,400 9,740 146 Run Date : Sep 13, 2023 2023 Approved %Change Budget From 2022 2,640 10 .00% 431,500 2 .25% 434,140 2.30% --% --% 434,140 2.30% City of Pickering 2023 Approved Current Budget Summary 10510 Water Resources & Development Services 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease Expenditures 1,008,681 1,185,196 Salaries & Wages 1,413,021 117,061 1,568 5,479 Overtime 2,900 3,000 276,703 300,652 Employee Benefits 386,033 25,298 871 651 Uniforms 1,500 - (1,766) 1,138 Seminars & Education 5,800 1,300 185 -Travel 1,300 (550) 2,818 3,306 Cellular Phones 4,320 - 3,660 4,088 Telephone & Data 4,250 (150) 557 534 Internet -500 --Subscriptions & Publications 650 - 7 ,390 7,390 Insurance Premium 7 ,390 739 -986 Insurance Deductible 1,000 - 33,248 60,001 Consulting & Professional Fees 419,315 21,131 15 -Meals, Promotions & General 100 - 2,487 2,146 Memberships 4,300 245 6,478 6,848 Repairs & Maintenance Materials 10,000 10,000 4,479 5,733 Vehicle -Repairs & Maintenance 5,000 - 5,349 7,956 Gas, Oil, Tire , Etc. 7,810 500 -1,017 Misc. Equip . -Repairs & Maintenance 1,000 - 1,516 914 Stationary & Office Supplies 1,200 - 718 4,744 Supplies & Tools 8,000 - 9 ,387 11,420 Software & Hardware Mtce. Contracts 12,575 (240) 1,364,344 1,610,199 Total Expenditures 2,297,464 178,834 Revenues (1,801,284) (2,309 ,277) Department User Fees (890 ,000) (315,000) (23,587) (66 ,950) Cost Recoveries (96,935) (2,605) (1,824,871) (2,376 ,227) Total Revenues (986,935) (317,605) Transfers (5,969) (3,613) Transfer to/(from) DC Oblg RF (218,800) 7,068 (663) 44,157 Transfer to(from) Cntg Sty Res . (58,515) (32,948) --Transfer to(from) Reserve (25,000) 14,749 (6,632) 40,544 Total Transfers (302,315) (11,131) (467,159) (725,484) Net Expenditures (Revenues) 1,008,214 (149,902) 14 7 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 1,530,082 8 .28% 5,900 103.45% 411,331 6.55% 1,500 -% 7,100 22.41% 750 (42.31%) 4,320 -% 4,100 (3 .53%) 500 - % 650 - % 8,129 10.00% 1,000 - % 440,446 5 .04% 100 - % 4,545 5 .70% 20,000 100.00% 5 ,000 -% 8 ,310 6.40% 1,000 -% 1 ,200 - % 8,000 - % 12,335 (1.91%) 2,476,298 7.78% (1,205,000) 35 .39% (99,540) 2.69% (1,304,540) 32.18% (211,732) (3.23%) (91,463) 56 .31% (10,251) (59 .00%) (313,446) 3.68% 858,312 (14.87%) City of Pickering 2023 Approved Current Budget Summary 10510 Water Resources & Development Services 2021 2022 2022 Actuals Actua ls Account Description Approved Increase/ Budget Decrease Cherrywood Development --Salaries & Wages -92 ,600 --Overtime -500 --Employee Benefits -27,780 --Travel -500 --Cellula r Phon e s -3 ,300 --Building -Repairs & Maintenance -3,700 --Gas, Oil, Tire, Etc . -500 --Building Re ntals -19,400 --Stationary & Office Supplies -500 --Supplies & Tools -500 --Software & Hardware Mtce . Contracts -3 ,000 --Misc. Equipment -30,000 --Department User Fees -(5,500) --Licences & Permits -(7,500) --Transfer to(from) Reserve -(169,280) --Net Expenditures (Revenues) -- (467,159) (725,484) Total Net Expenditures (Revenues) 1,008,214 (149,902) 148 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 92,600 -% 500 -% 27 ,780 -% 500 -% 3 ,3 00 -% 3,700 -% 500 -% 19,400 -% 500 -% 500 -% 3 ,000 -% 30,000 -% (5,500) -% (7 ,500) -% (169,280) -% --% 858,312 (14.87%) 10515 Sidewalks 2021 2022 Actuals Actuals 151,186 150 ,640 18 ,862 26,092 894 - 31,268 11,860 160,078 5,151 362,288 193,743 (47,595) (105,432) (47,595) (105 ,432) (157 ,788) - (157,788) - 156,905 88,311 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase I Budget Decrease Expenditures Insurance Premium 150,640 15,064 Insurance Deducti ble 4,950 25,000 Winter Control Maintenance -- Repairs & Maintenance Materials 20,000 - Other Fi xed Assets 220 ,000 250 ,000 Total Expenditures 395,590 290 ,064 Revenues Other User Fees -- Total Revenues -- Transfers Transfer to (from) Oblig RF (200 ,000) (250,000) Total Transfers (200,000) (250,000) Net Expenditures (Revenues) 195,590 40,064 149 Run Date : Sep 13 , 2023 2023 Approved % Change Budget From 2022 165 ,704 10 .00% 29,9 50 505 .05 % -- % 20,000 - % 470,000 113 .64% 685,654 73.32% --% -- % (450,000) 125.00% (450,000) 125.00% 235,654 20.48% 10520 Streetlights 2021 2022 Actuals Actuals 6 ,680 6 ,680 6 ,210 3,246 9,263 11 ,428 324 ,210 282,206 456 ,770 453,529 -- 803,133 757 ,089 (9 ,835) (3,090) -- (9,835) (3,090) (4,429) 1,272 (4,429) 1,272 788,869 755,271 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Expenditures Insu rance Premium 6,680 668 Consulting & Profession a l Fees 53,100 (28 ,728) Outside Agency Services 12 ,000 6 ,000 Misc. Equip . -Repairs & Maintenance 470,000 (10,000) Utilities -Hydro 500 ,000 (25,000) other Fi xed Assets 40,000 - Total Expenditures 1,081,780 (57,060) Revenues Othe r User Fees -- Misc . Revenue -(500) Total Revenues -(500) Transfers Transfer to(from) Cntg Sty Res . (3,100) (1,272) Total Transfers (3,100) (1 ,272) Net Expenditures (Revenues) 1,078,680 (58,832) 150 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 7,348 10 .00 % 24,372 (54 .10 %) 18 ,000 50 .00% 460 ,000 (2.13 %) 475,000 (5 .00%) 40 ,000 -% 1,024,720 (5.27%) --% (500) -% (500) -% (4 ,372) 41 .03% (4,372) 41.03% 1,019,848 (5.45%) 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, which includes all of the finance and accounting functions identified above. Finance Department I I I I I I Budgets & Accountng Supply & ERP& Taxation Financial Risk Mgmt. Services Services Systems Key Activities for 2023 The department's priorities include: • Implement Profit Centre accounting in SAP to provide enhanced functionality / consolidate departmental programs and current budget to obtain financial reports from a single source • Enhance integration between SAP and Sucessfactors • Refresh the budget documents and introduce 10-year capital forecast • Manage assessment appeals • Continue to develop the City's Asset Management Plan to meet 0. Reg 588/17 (Phase Ill) requirements for 2025 • Manage 2023 budget challenges 151 Finance Department Financial Information Staffing Summary (Full & Regular Part-Time) Approved Approved Prior Term New Term 2019 2020 2021 2022 2023 Add Transfers Total Full-Time 26 27 28 31 4 -1 34 Reg. Part-Time - - --- - - Total 26 27 28 31 4 -1 34 During 2022, one full-time SAP Clerk was transferred to Community Services. For 2023, the Finance Department is proposing to add four new positions to support organizational growth, complete systems and process improvements related to the City's new ERP system, and to respond to changes in the legislative environment. The four positions are as follows: • One new full-time Senior Procurement Analyst (Council Resolution #20/22) • One new full-time Accounts Payable Clerk • One new full-time Senior Financial Analyst • One new full-time Systems Analyst -SAP Year-Over-Year (Net Cost) Budget Changes 2022 2023 Year-Over-Year Approved Approved Change Budget Budget ($) (%) Finance $815,941 $564,989 $(250,952) (30.76%) Supply & Services 478,582 707,863 229,281 47.91% Total (Net Cost) $1,294,523 $1,272,852 $(21,671) (1.67%) 152 Finance Department Explanation of Significant Departmental Budget Changes Expenditures -Increases I (Decreases) Salaries, Wages & Benefits -$396,800 The budget increase in 2023 is due to the addition of four proposed new positions, partially offset by an in-year transfer of one position to Community Services. These positions are required to meet the demands of organizational growth, complete systems and process improvements and address increased complexities in financial planning due to ongoing changes in the legislative environment. Data Processing Services -$13,000 Increase is due to increased fees and volume of transactions handled each year. Consulting & Professional -$65,300 Increase related to $124,600 for new Fiscal Impact Studies for Cherrywood, Northeast Pickering and City Centre (Council Resolution #37/23), $50,500 for Phase 1 of a Level of Service Framework to support the city's Asset Management Strategy (as required by legislation), $43,000 to complete a Procurement Policy review and revision, along with development of new standard contract templates, and $4,300 for training to support compliance with Ontario Reg. 588/17 -Asset Management Plan. These increases are offset by one-time projects completed in 2022 including: ($80,000) for the Development Charge Background Study (DCBS) and Community Benefits Charge Study (CBCS), ($61,000) related to the portion of the FMW Budget Software refresh project completed, and ($27,500) for the 5-year Capital and Operating Impact Analysis Software & Hardware Maintenance -($19,300) Decrease primarily due to termination of software maintenance contract on legacy financial accounting system which was replaced by the new financial system. 153 Finance Department Revenues/Transfer from Reserves -(Increases) I Decreases Penalties & Interest on Taxes -($200,000) Increase reflects actual revenues from 2021 and 2022. Investment Income -($500,000) Increase due to the rise in interest rates which increases income on investments. Transfer from Development Charge Obligatory Reserve Fund -$90,760 Decrease due to the completion of the 5-year Development Charge financial impact analysis and Community Benefit Charge study in 2022. Transfer from Continuing Studies Reserve -($14,100) The increase relates to the remaining portion of the FMW Budget Refresh project which was not complete in 2022. Transfers from Reserve -$189,400 The transfer from reserves has decreased due to the completion of a portion of the FMW Budget Refresh project (which was funded from the Rate Stabilization Reserve) and the removal of Financial Systems reserve funding for the SAP Systems Support position. This position is now being funded from property taxes. Transfers from Obligatory Reserve Fund -($56,100) The increase relates to various 2023 Asset Management Plan projects which are funded from the Canada Community Building Fund (previously call the Federal Gas Tax). 154 Finance Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 2022 Accounts Receivable Invoices Issued 255 337 320 Total Invoice Value $795,394 $2,011,435 $2,013,195 Accounts Payable Vendors Paid 1,849 1,422 1,101 Total Dollar Value $82.9 m $88.5 m $94.2 m Payroll T4 Slips 937 929 1,136 Pav Statements 17,818 17,228 20,684 Property Taxes Phone Calls 17,528 18,535 16,555 Tax Bills Issued 65,321 67,064 68,148 Payments Processed $241.2 m $254.3M $264.7M Purchasing Cards Transactions 3,631 3,097 4,906 Value of PCard Transactions $607,168 $534,027 $683,777 Number of PCards Issued 106 108 60 Supply & Services Purchase Orders Issued 783 1,186 1,088 Blanket POs -Total PO Value 101 $31.8 $38.0m Bids 22.7 m -Number of Bids 98 62 74 -Total Bids Value (excluding Single/Sole $45.8 m $24.7m $9.4m Source contracts & consultinq) Quotes -Number of Quotes 70 35 65 -Total Quotes Value $6 m $4.3m $2.8 m RFPs -Number of RFPs 10 5 2 -Total RFPs Value $16.6 m $2.0m $0.77m Tenders -Number of Tenders 18 22 7 -Total Tenders Value $23.1 m $18.4m $5.8m Single/Sole Source 255 -Number of Single/Sole Source NIA NIA 50 155 Finance Department Performance Indicators/Statistics 2020 2021 2022 -Total Single/Sole Source Value NIA NIA $2.2m Consulting & Professional Services -Number of Consulting & Professional NIA NIA 94 Services -Total Consulting & Professional NIA NIA $2.Sm Services Value 156 Finance Department 2021 2022 Actuals Actuals 2,458,798 2,744,503 41,048 22,395 656,956 708 ,620 356 6,767 6,479 12,287 -596 -112 1,049 1,793 7,617 8 ,756 1,192 1,144 153,463 179,651 2,394 2,623 25,065 27,881 16 ,200 16,200 207,674 267,395 2,287 2,118 14,218 17,063 8 ,888 8,520 1,715 1,275 7,404 13,179 -- 4,376 7,519 483,006 522,278 -- -669 537 (13) 93,656 119,165 (1,043) 2 ,863 4,193 ,335 4,695,359 (338,066) (314,174) (134,271) (155,213) (2,701 ,669) (3,311,796) (293,505) (2 ,097,8 17) (800) - City of Pickering 2023 Approved Current Budget Summary 2022 ' Account Description Approved Increase/ Budget Decrease Expenditures Salaries & Wages 3,030,830 338,413 Overtime 30,750 - Employee Benefits 855,393 58,386 Conferences 8,750 1,900 Seminars & Education 31,250 (300) Travel 1,900 - Postage -- Cellular Phones 2,100 300 Telephone & Data 9,105 2,695 Internet 1,135 - Data Processing Services 172,000 13,000 Subscriptions & Publications 4,000 - Brochures/Newsletters Printing 22,000 6,000 Insurance Premium 16,200 1,620 Consulting & Professional Fees 407,000 65,280 Meals, Promotions & General 2,000 - Memberships 18,780 300 Outside Agency Services 11 ,600 - Misc. Equip . -Repairs & Maintenance 2,300 - Stationary & Office Supplies 10,200 - Forms 1,500 - Programs & Event Supplies 15,000 - Software & Hardware Mtce. Contracts 564,930 (19,265) System & Software Upgrade 8,600 - Hardware Replacements -- Miscellaneous Expenses -- Financial Services Charges 75 ,000 - Exchange Rate -Gain or Loss -- Total Expenditures 5,302,323 468,329 Revenues Department User Fees (281,000) - Other User Fees (70 ,000) - Pen . & Interest -Prop. Taxes (2,690 ,000) (200,000) Investment Income (525,000) (500,000) Misc. Revenue -- 157 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 3,369,243 11 .17% 30,750 -% 913,779 6 .83% 10,650 21.71% 30 ,950 (0 .96%) 1,900 -% --% 2,400 14 .29% 11,800 29 .60% 1,135 -% 185,000 7 .56% 4,000 -% 28,000 27.27% 17,820 10.00% 472,280 16 .04% 2,000 -% 19,080 1 .60% 11 ,600 -% 2,300 -% 10,200 -% 1,500 -% 15,000 -% 545,665 (3.41%) 8 ,600 -% --% --% 75,000 -% --% 5,770,652 8.83% (281,000) -% (70,000) -% (2,890,000) 7.43% (1,025,000) 95 .24% --% Finance Department 2021 2022 Actuals Actuals (3,468,311) (5,879 ,000) (25,710) (64 ,171) -- -(90,128) (59,621) (10,949) (85,331) (165,248) 639,693 (1,348,889) -- -- -- -- -- -- 639,693 (1,348,889) City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase I Budget Decrease Total Revenues (3,566,000) (700,000) Transfers Transfer to/(from) DC Oblg RF (90 ,760) 90 ,760 T ransfer to(from) Cntg Sty Res. -(14 ,100) Transfe r to(from) Reserve (2 50 ,940) 189,440 Transfer to (from) Oblig RF (100 ,100) (56,100) Total Transfers (441,800) 210,000 Net Expenditures (Revenues) 1,294,523 (21,671) Cherrywood Development Salaries & Wages -2,190 Employee Benefits -660 Consulting & Professional Fees -50,000 Other Contributions -(50 ,000) Transfer to(from) Reserve -(2 ,850) Net Expenditures (Revenues) -- Total Net Expend itures (Revenues) 1,294,523 (21,671) 158 Run Date : Sep 13 , 2023 2023 Approved % Change Budget From 2022 (4,266,000) 19.63% -(100 .00%) (14,100) -% (61,500) (75.49 %) (156 ,200) 56 .04% (231,800) (47.53%) 1,272,852 (1.67%) 2 ,190 - % 660 -% 50,000 -% (50 ,000) - % (2 ,850) - % --% 1,272,852 (1.67%) 10600 Finance 2021 2022 Actuals Actuals 2,129,561 2,464,248 34,067 19 ,229 572,282 632,471 356 5,851 6,463 10,957 -596 -112 710 1,529 6,548 7,587 1,033 991 153,463 179,651 2,394 2,623 25,065 27,881 14,280 14,280 207,674 267,395 2,287 2 ,118 13,271 16,312 7,296 6,928 1,715 1,275 7,389 9,696 -- 4,376 7 ,519 482,872 520,762 -- -669 537 (13) 93,656 119,165 (1,043) 2,863 3,766,252 4,322,695 (338,066) (314,174) (134,271) (155,213) (2,701,669) (3,311,796) (293,505) (2,097,817) (800) - City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Expenditures Salaries & Wages 2 ,673,749 187,025 Overtime 25,750 - Employee Benefits 759,222 24,820 Conferences 6,350 1,900 Seminars & Education 22,550 (300) Travel 1,000 - Postage -- Cellular Phones 2,100 - Telephone & Data 7,890 2,210 Internet 985 - Data Processing Services 172,000 13,000 Subscriptions & Publications 4,000 - Brochures/Newsletters Printing 22,000 6,000 Insurance Premium 14,280 1,428 Consulting & Professional Fees 407,000 22 ,280 Meals, Promotions & General 1,600 - Member_ships 17,295 - Outside Agency Services 10,000 - Misc. Equip. -Repairs & Maintenance 2,300 - Stationary & Office Supplies 9,200 - Forms 1,500 - Programs & Event Supplies 15,000 - Software & Hardware Mtce . Contracts 564,370 (19,315) System & Software Upgrade 8,600 - Hardware Replacements -- Miscellaneous Expenses -- Financial Services Charges 75,000 - Exchange Rate -Gain or Loss -- Total Expenditures 4,823,741 239,048 Revenues Department User Fees (281,000) - Other User Fees (70,000) - Pen. & Interest -Prop . Taxes (2,690,000) (200,000) Investment Income (525,000) (500,000) Misc. Revenue -- 159 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 2,860,774 6 .99% 25,750 -% 784,042 3.27% 8,250 29.92% 22,250 (1.33%) 1,000 -% -- % 2,100 - % 10,100 28 .01% 985 - % 185,000 7.56% 4,000 - % 28,000 27.27% 15,708 10.00% 429,280 5.47% 1,600 -% 17,295 -% 10,000 - % 2,300 -% 9,200 -% 1,500 -% 15,000 -% 545,055 (3.42%) 8,600 -% -- % --% 75,000 -% --% 5,062,789 4.96% (281,000) -% (70,000) - % (2,890 ,000) 7.43% (1,025,000) 95 .24% --% 10600 Finance 2021 2022 Actuals Actuals (3,468,311) (5,879,000) (25,710) (64,171) -- -(90,128) (59 ,621) (10 ,949) (85,331) (165,248) 212,610 (1,721,553) -- -- -- -- -- -- 212,610 (1,721,553) City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Total Revenues (3,566,000) (700,000) Transfers Transfer to/(from) DC Oblg RF (90,760) 90,760 Transfer to(from) Cntg Sty Res . -(14,100) Transfer to(from) Reserve (250,940) 189,440 Transfer to (from) Oblig RF (100,100) (56 ,100) Total Transfers (441,800) 210,000 Net Expenditures (Revenues) 815,941 (250,952) Cherrywood Development Salaries & Wages -2,190 Employee Benefits -660 Consulting & Professional Fees -50,000 Other Contributions -(50 ,000) Transfer to(from) Reserve -(2,850) Net Expenditures (Revenues) -- Total Net Expenditures (Revenues) 815,941 (250,952) 160 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 (4,266,000) 19.63% -(100.00%) (14,100) -% (61,500) (75.49%) (156 ,200) 56.04% (231,800) (47.53%) 564,989 (30.76%1 2,190 -% 660 -% 50,000 - % (50,000) - % (2,850) -% -- % 564,989 (30.76%) City of Pickering 2023 Approved Current Budget Summary 10605 Supply & Services 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 329,237 280,255 Salaries & Wages 357,081 151,388 6,981 3,167 Overtime 5 ,000 - 84,674 76,150 Employee Benefits 96,171 33,566 -916 Conferences 2,400 - 15 1,330 Seminars & Education 8,700 - --Travel 900 - 339 264 Cellular Phones -300 1,069 1,170 Telephone & Data 1,215 485 159 153 Internet 150 - 1,920 1,920 Insurance Premium 1,920 192 --Consulting & Professional Fees -43,000 --Meals , Promotions & General 400 - 947 752 Memberships 1,485 300 1,592 1,592 Outside Agency Services 1,600 - 15 3,483 Stationary & Office Supplies 1,000 - 134 1,516 Software & Hardware Mtce. Contracts 560 50 427,082 372,668 Total Expenditures 478,582 229,281 Revenues --Total Revenues -- Transfers --Total Transfers -- 427,082 372,668 Net Expenditures (Revenues) 478,582 229,281 1 61 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 508,469 42.40% 5,000 -% 129,737 34.90% 2,400 -% 8,700 -% 900 -% 300 -% 1,700 39 .92% 150 -% 2,112 10.00% 43,000 -% 400 -% 1,785 20.20% 1,600 -% 1,000 -% 610 8 .93% 707,863 47.91% -- % -- % 707,863 47.91% Financial Information 2019 Full-Time 106 Reg. Part-Time - Total 106 Fire Services Department Staffing Summary (Full & Regular Part-Time) Approved Prior Term 2020 2021 2022 Add 109 112 116 5 ---- 109 112 116 5 Approved New Term 2023 Transfers Total -121 -- -121 The department received pre-budget approval (Resolution #20/22) for five additional firefighter positions in 2023, with a start date of February 1st , for the new Seaton Fire Headquarters that will be open on March 20, 2023. Year-Over-Year (Net Cost) Budget Changes 2022 2023 Year-Over-Year Approved Approved Change Budget Budget ($) (%) Fire Protection $18,746,854 $20,200,420 $1,453,566 7.75% Emergency Operations 28,979 34,642 5,663 19.54% Total (Net Cost) $18,775,833 $20,235,062 $1,459,229 7.77% Explanation of Significant Departmental Budget Changes Expenditures -Increases/ (Decreases) Salaries & Benefits -$1,305,000 Increase mainly due to annualization of five new firefighters hired in 2022 as well as five additional firefighters to be hired in 2023 (prebudget approval received -Council Resolution #20/22). Uniforms -$10,000 The increase provides uniforms for additional staff hired to staff the new fire hall. 163 Fire Services Department Seminars & Education -$15,000 Increase is required to provide provincially mandated Provincial Firefighter Certification to staff. Dispatch Communications -$38,300 Increase reflects the budgetary increase from Ajax Fire for the shared dispatch services provided. Consulting & Professional Fees -$145,000 $150,000 is budgeted to complete the 2023 Fire Master Plan (75% of this cost will be funded by Development Charges). This increase is offset by the completion of the building condition audit project in 2022. Building Repairs & Maintenance -$50,200 $15,000 increase partially reflects the transfer of responsibility for waste collections service from Region of Durham (July 1 start) to the City throughout all facilities. The remaining increase mainly relates to operating costs associated with the new fire hall and the cost of biohazard disposal. Supplies & Tools -$16,000 Increase in foam budget based on 2022 actual usage. COVID Related Expenses -($28,000) For 2023, all COVID related expenses have been removed from budgets. Utilities -$20,000 Increase due to anticipated price increases and additional consumption for water, hydro and natural gas related to the opening of the new fire hall in 2023. Furniture & Fixtures -$15,000 These funds are required to upfit the new fire hall. Revenues/Transfer from Reserves -(Increases) I Decreases Department User Fees -($25,000) User fees reflect a projected increase in false alarm charges revenues for 2023. Transfer from Development Charge Reserve Fund -($112,500) Budget amount reflects Development Charge funding (75%) of the Fire Master Plan in 2023. 164 Fire Services Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 2022 Fire Prevention & Public Safety Vulnerable Occupancy Inspections (Legislated) 20 20 20 Complaint Inspections 136 205 143 Requested Inspections 365 421 720 Fire lnvestiqations 30 31 37 Permits Reviewed 940 370* 327 Public Fire Safety Education Events 63 361 115 Other Fire Safety/Community Support Activities 222 219 Fire Suppression Operations Fire/Smoke 350 311 325 Motor Vehicle Accidents 460 452 629 Medical Response 893 519 1,357 Rescue 25 18 23 Fire Alarm 318 324 474 Hazard (CO, wires down, qas leak, etc.) 233 267 322 Other (public assist, 911 unknown call, etc.) 329 323 347 Total Incidents 2,609 2,215 3,478 Training Recruit firefighters trained (7-week program) 3 11 5 * New tracking process in 2021 reflects the number of permits and not the number of site visits or permit re-submissions as reflected in previous years. 165 City of Pickering 2023 Approved Current Budget Summary Fire Services Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase I Budget Decrease Expenditures 12,623,851 12,944,864 Salaries & Wages 12,894,979 1,091,460 249,684 252,545 Overtime 250,000 - 3,383,612 3,597,288 Employee Benefits 3,552,522 213,508 171,507 177,243 Uniforms 210,000 10,000 -4,055 Conferences 3,500 3,000 107,329 122,317 Seminars & Education 139,000 15,000 455 675 Travel 1,000 - 50 102 Freight, Express & Cartage -- -57 Environmental Charges -- 14,729 17,952 Cellular Phones 16,300 - 45,519 62,382 Telephone & Data 61,635 (235) 15,537 1,156 Internet 1,160 - 184 2,481 Cable TV 2,205 300 1,007,847 1,059,383 Dispatch Comunications 1,068,967 38,273 1 ,104 -Advertising 1,000 - --Subscriptions & Publications 2,000 - --Photo, Mapping, Print 1,000 - 69,500 95,925 Insurance Premium 95,925 (6,027) --Insurance Deductible 2,000 - 4,889 6,830 Consulting & Professional Fees 15,000 145,000 410 1,927 Meals, Promotions & General 4,250 - 4,120 2,417 Memberships 6,450 - 10,150 750 Outside Agency Services 1,000 - 125,333 192,431 Building -Repairs & Maintenance 96,000 50,200 203,623 201,335 Vehicle -Repairs & Maintenance 165,600 - 62,825 135,546 Gas, Oil, Tire, Etc. 129,700 4,000 98,392 53 ,525 Misc. Equip. -Repairs & Maintenance 80,000 8,500 -86 Grounds Upkeep -- 4,384 6,375 Stationary & Office Supplies 5,000 1,000 494 -Forms 1,500 - 6,590 6,847 Programs & Event Supplies 18,000 3,000 93,590 108,569 Supplies & Tools 79,000 16,000 --COVID Related Expenses 28,000 (28,000) 10,313 12,812 Utilities -Water 13,850 5,000 46,979 50,727 Utilities -Hydro 62,710 5,000 20,475 27,183 Utilities -Natural Gas 27,535 10,000 166 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 13,986,439 8.46% 250,000 -% 3,766,030 6 .01% 220,000 4 .76% 6,500 85.71% 154,000 10.79% 1,000 -% --% --% 16,300 -o/o 61,400 (0 .38%) 1,160 -% 2,505 13 .61% 1,107,240 3.58% 1,000 -% 2,000 -% 1,000 -% 89,898 (6 .2a¾) 2 ,000 -% 160,000 966.67% 4 ,250 -% 6,450 -% 1,000 -% 146,200 52 .29% 165,600 -% 133,700 3 .08% 88,500 10.63% --% 6,000 20.00% 1,500 -% 21,000 16.67% 95,000 20.25% -(100.00%) 18,850 36.10% 67,710 7.97% 37,535 36.32% City of Pickering 2023 Approved Current Budget Summary Fire Services Department 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease 168 -Utilities -Oil -- 5,003 17,899 Software & Hardware Mtce . Contracts 20,045 (3,250) -2,834 System & Software Upgrade 8,500 - 15,740 7,968 Hardware Replacements -- 7,789 9,239 Furniture & Fixtures 8,000 15,000 15,140 8,885 Misc. Equipment 28,500 - 18,427,315 19,192,610 Total Expenditures 19,101,833 1,596,729 Revenues (27,200) -Ontario Grants -- (7,500) -Other Agency Grants -- (129 ,275) (146,318) Department User Fees (75,000) (25,000) -(5,432) Other User Fees -- --Sponsorships (500) - --Marketing Sponsors (500) - (259,215) (250,000) Cost Recoveries (250,000) - (423,190) (401,750) Total Revenues (326,000) (25,000) Transfers --Transfer to/(from) DC Oblg RF -(112,500) - - Total Transfers -(112,500) 18,004,125 18,790,860 Net Expenditures (Revenues) 18,775,833 1,459,229 Cherrywood Development --Consulting & Professional Fees -30,000 --Other Contributions -(30 ,000) - - Net Expenditures (Revenues) - - 18,004,125 18,790,860 Total Net Expenditures (Revenues) 18,775,833 1,459,229 167 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 -- % 16,795 (16 .21%) 8,500 - % -- % 23,000 187.50% 28,500 - % 20,698,562 8.36% -- % -- % (100,000) 33 .33% -- % (500) - % (500) - % (250,000) - % (351,000) 7.67% (112,500) - % (112,500) - % 20,235,062 7.77% 30 ,000 -% (30,000) -% -- % 20,235,062 7.77% 10700 Fire Protection 2021 2022 Actuals Actuals 12,462,382 12 ,780,544 249,684 252,545 3 ,364,175 3 ,564,585 171,507 177,243 -4,055 107,329 122,317 455 675 50 102 -57 14,125 17,365 43,888 . 62 ,361 15,532 1,156 74 873 1,007,847 1,059,383 1,104 - -- -- 68,820 95,245 -- 4,889 6,830 410 1,866 4 ,036 2,417 10,150 750 125,333 191,542 203,623 201,335 62,825 135,546 98 ,392 53,133 -86 3,936 6,375 494 - 6,590 6,847 93,590 107 ,795 -- 10,313 12,812 46,979 50 ,727 20,475 27,183 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Expenditures Salaries & Wages 12,762,004 1,086,727 Overtime 250,000 - Employee Benefits 3,519,553 213,086 Uniforms 210,000 10,000 Conferences 3,500 1,500 Seminars & Education 135,500 15,000 Travel 1,000 - Freight, Express & Cartage -- Environmental Charges -- Cellular Phones 15,500 - Telephone & Data 59,815 1,085 Internet 1,100 - Cable TV 885 - Dispatch Comunications 1,068,967 38,273 Advertising 1,000 - Subscriptions & Publications 2,000 - Photo, Mapping, Print 500 - Insurance Premium 95 ,245 (6,095) Insurance Deductible 2,000 - Consulting & Professional Fees 15,000 145,000 Meals, Promotions & General 3,500 - Memberships 6,050 - Outside Agency Services 1,000 - Building -Repairs & Maintenance 96,000 50,200 Vehicle -Repairs & Maintenance 165,600 - Gas, Oil, Tire, Etc . 129,700 4,000 Misc. Equip . -Repairs & Maintenance 79 ,500 8,500 Grounds Upkeep -- Stationary & Office Supplies 4,000 1,000 Forms 1,500 - Programs & Event Supplies 18,000 3,000 Supplies & Tools 77,500 16,000 COVID Related Expenses 28,000 (28,000) Utilities -Water 13,850 5,000 Utilities -Hydro 62,710 5,000 Utilities -Natural Gas 27 ,535 10,000 168 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 13,848,731 8.52% 250,000 -% 3 ,732,639 6 .05% 220,000 4.76% 5,000 42.86% 150,500 11 .07% 1,000 -% --% --% 15,500 -% 60,900 1.81% 1,100 -% 885 -% 1,107,240 3.58% 1,000 -% 2,000 -% 500 -% 89,150 (6.40%) 2,000 -% 160,000 966 .67% 3 ,500 -% 6,050 -% 1,000 -% 146,200 52 .29% 165,600 -% 133,700 3.08% 88,000 10.69% --% 5,000 25 .00% 1,500 -% 21,000 16.67% 93,500 20.65% -(100 .00%) 18,850 36 .10% 67,710 7.97% 37,535 36.32% City of Pickering 2023 Approved Current Budget Summary 10705 Emergency Operations 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expend itures 161,469 164,320 Salaries & Wages 132,975 4 ,733 19,437 32 ,703 Employee Benefits 32 ,969 422 --Conferences -1,500 --Seminars & Education 3,500 - 604 587 Cellular Phones 800 - 1,631 21 Telephone & Data 1,820 (1,320) 5 -Internet 60 - 110 1,609 Cable TV 1,320 300 --Photo, Mapping, Print 500 - 680 680 Insurance Premium 680 68 -61 Meals, Promotions & General 750 - 84 -Memberships 400 - -890 Building -Repairs & Maintenance -- -392 Misc. Equip . -Repairs & Maintenance 500 - 448 -Stationary & Office Supplies 1,000 - -773 Supplies & Tools 1,500 - 52 183 Software & Hardware Mtce. Contracts 205 (40) -(994) Furniture & Fixtures -- 59 3,720 Misc. Equipment -- 184,579 204,945 Total Expenditures 178,979 5,663 Revenues (150,000) (150,000) Cost Recoveries (150 ,000) - (150,000) (150,000) Total Revenues (150,000) - Transfers --Total Transfers -- 34,579 54,945 Net Expenditures (Revenues) 28,979 5,663 170 Run Date : Sep 13, 2023 2023 Approved % Change Budget From 2022 137,708 3 .56% 33 ,391 1.28% 1,500 -% 3,500 -% 800 -% 500 (72 .53%) 60 -% 1,620 22 .73% 500 -% 748 10.00% 750 -% 400 -% --% 500 -% 1,000 -% 1,500 -% 165 (19 .51%) --% --% 184,642 3.16% (150 ,000) -% (150,000) -% --% 34,642 19.54% Human Resources Department Overview The Human Resources Department provides a variety of centralized services to both the City of Pickering and the Pickering Public Library related to the management of our people resources. This includes the following functions under each operational area: Human Resources -Centralized recruitment, health & safety, employee recognition, Human Resources Information System (HRIS), training. Employee Services -Employee benefits, compensation, Ontario Municipal Employee Retirement System (OMERS) administration, disability management and Workplace Safety & Insurance (WSIB) administration, employee wellness. Labour Relations -Grievance administration, collective bargaining, employee relations and policy development. People & Culture -Centralized human resources administrative services for the Pickering Public Library (PPL), diversity & inclusion and organizational development. r .., Human Resources Department \. .) I I I I I r .., r Human Resources Employee Labour People & Services Relations Culture \. ~ 171 .., Human Resources Department Key Activities for 2023 • Collective bargaining with CUPE Local 3506 (Pickering Public Library) • Coordinate the corporate wide usage of Employee Central (HRIS self-service module) • Coordinate the development of an Equity, Diversity & Inclusion Ten-Year Strategy utilizing an external consultant • Administration of the new OMERS membership rules for non-full-time employees • Ongoing review of the corporation's recruitment and retention strategies including a focused assessment of vacancies to ensure the timely filling of positions to meet the City's growing needs • Review and implementation of administrative procedures to be digitized (online forms) • Ongoing review of policies and procedures to better align them with updated and current practices (New Employee Orientation, Training & Education, Employee Recognition) Financial Information 2019 Full-Time 8 Reg. Part-Time - Total 8 Staffing Summary (Full & Regular Part-Time) Approved Prior Term 2020 2021 2022 Add 10 10 11 1 ---- 10 10 11 1 Approved New Term 2023 Transfers Total -12 -- -12 The department proposes to add one new Human Resources Associate to address the proposed increase in City staff and their associated needs. 172 Human Resources Department Year-Over-Year (Net Cost) Budget Changes 2022 2023 Year-Over-Year Approved Approved Change Budget Budget ($) Human Resources $1,127,494 $1,319,335 $191,841 Health & Safety 150,061 165,132 15,071 Total (Net Cost) $1,277,555 1,484,467 206,912 Explanation of Significant Departmental Budget Changes Expenditures -Increases I (Decreases) Salaries & Benefits -$163,800 (%) 17.01% 10.04% 16.20% Increase largely due to the reclassification of two Supervisors to Managers, one new proposed full-time HR Associate position to address ongoing recruitment as well as the annualized impact of the additional full-time position of HR Associate in 2022. Corporate Training -$30,000 Budget increase includes $15,000 for team building and business writing, $15,000 to cover the back-log of employees whose health & safety specific training expired during the pandemic, as well as additional mental wellness supervisory training (funded from the WSIB reserve). Consulting & Professional Fees -$14,900 Increase related to external counsel for ongoing legal advice in consideration of pending arbitrations. Revenues/Transfer from Reserves -(Increases) I Decreases Transfer from Continuing Studies Reserve -$25,100 Decrease due to completion of a portion of the Diversity & Inclusion Strategy in 2022 which reduces the project funding requirements. Transfer from WSIB Reserve -($15,000) Increase in funding for Health & Safety training planned for 2023. 173 Human Resources Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2020 2021 2022 Job Postinqs 52 92 78 New Employees Hired (excludinq students) 46 112 111 Rehires/transfers/promotions 136 153 159 Redeployments (due to COVID-19) 21 3 N/A Student/mass hires 49 114 298 Retirements/resiqnations 38 69 36 Employees trained (various courses including 743 330 319 Lockdown, Respect in the Workplace, Health & Safety Awareness, confined space and working at heiqhts) 174 City of Pickering 2023 Approved Current Budget Summary Human Resources Department 2021 2022 2022 -.ti!. ~· ... -:..... .. Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 903,137 979,112 Salaries & Wages 984,036 130,886 1,339 866 Overtime 1,600 1,400 258,399 271 ,286 Employee Benefits 279,390 31,470 36,252 31,328 Employee Recognition 42,250 - 76 -Conferences 2,450 200 6,614 2,414 Seminars & Education 14,700 (8,200) 7,924 12,836 Corporate Training 30,000 30,000 -71 Travel 850 (350) 1,186 708 Cellular Phones 1,300 - 2,558 2,969 Telephone & Data 3,035 665 397 381 Internet 380 - 11,248 16,068 Advertising 10,000 5,000 4,330 4,330 Insurance Premium 4,330 433 173,025 212,166 Consulting & Professional Fees 185,100 14,900 1,915 2,878 Meals, Promotions & General 2,500 1,000 1,603 1,580 Memberships 2,160 1,370 1,452 978 Stationary & Office Supplies 1,500 - -52 Programs & Event Supplies -- -699 Educational Material 1,400 - --Workplace Accomodation 900 - 7,009 8,090 Software & Hardware Mtce . Contracts 7 ,732 620 1,418,464 1,548,812 Total Expenditures 1,575,613 209,394 Revenues (174,999) (229 ,941) Netted Revenue (227,958) (12,582) (174,999) (229,941) Total Revenues (227,958) (12,582) Transfers 50,090 (50,090) Transfer to(from) Cntg Sty Res. (50,100) 25,100 (7,448) (10,912) Transfer to (from) Oblig RF (20,000) (15,000) 42,642 (61,002) Total Transfers (70,100) 10,100 1,286,107 1,257,869 Net Expenditures (Revenues) 1,277,555 206,912 175 Run Date: Sep 13, 2023 2023 Approved %Change Budget From 2022 1,114,922 13.30% 3,000 87.50% 310,860 11.26% 42,250 -% 2,650 8 .16% 6,500 (55 .78%) 60,000 100.00% 500 (41 .18%) 1,300 -% 3,700 21 .91% 380 -% 15,000 50.00% 4,763 10.00% 200,000 8 .05% 3,500 40.00% 3 ,530 63.43% 1,500 -% --% 1,400 -% 900 -% 8,352 8.02% 1,785,007 13.29% (240,540) 5 .52% (240,540) 5.52% (25 ,000) (50.10%) (35,000) 75.00% (60,000) (14.41 %) 1,484,467 16.20% City of Pickering 2023 Approved Current Budget Summary 10800 Human Resources 2021 2022 2022 Actuals Actuals Account Description Approved Increase/ Budget Decrease Expenditures 793 ,680 862 ,321 Salaries & Wages 874,193 116,842 1 ,339 866 Overtime 1,000 2,000 228 ,537 238,975 Employee Benefits 248,247 29,244 36 ,252 31,328 Employee Recognition 42,250 - 76 -Conferences 1,800 200 6,614 2,414 Seminars & Education 14,200 (8 ,200) 475 1,630 Corporate Training 10,000 15,000 -71 Travel 300 - 1,186 708 Cellular Phones 1,300 - 2,296 2 ,674 Telephone & Data 2 ,730 970 357 343 Internet 340 - 11,248 16,068 Advertising 10,000 5,000 3 ,570 3 ,570 Insurance Premium 3,570 357 173,025 212,166 Consulting & Professional Fees 185,100 14,900 1,848 2,879 Meals, Promotions & General 2,500 1,000 1,463 1,440 Memberships 1,960 1,370 1,452 978 Stationary & Office Supplies 1,200 - 3,499 4,487 Software & Hardware Mtce . Contracts 4,862 640 1,266,917 1,382,918 Total Expenditures 1,405,552 179,323 Revenues (174,999) (229,941) Netted Revenue (227 ,958) (12 ,582) (174,999) (229,941) Total Revenues (227,958) (12,582) Transfers 50,090 (50,090) Transfer to(from) Cntg Sty Res . (50 ,100) 25,100 50,090 (50,090) Total Transfers (50,100) 25,100 1,142,008 1,102,887 Net Expenditures (Revenues) 1,127,494 191,841 176 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 991 ,035 13.37% 3,000 200.00% 277,491 11 .78% 42,250 -% 2,000 11 .11% 6,000 (57 .75%) 25,000 150.00% 300 -% 1,300 -% 3,700 35 .53% 340 -% 15,000 50 .00% 3,927 10.00% 200 ,000 8 .05% 3 ,500 40.00% 3,330 69 .90% 1,200 -% 5 ,502 13.16% 1,584,875 12.76% (240 ,540) 5 .52% (240,540) 5.52% (25,000) (50 .10%) (25,000) (50 .10%) 1,319,335 17.01% 10805 Health & Safety 2021 2022 Actuals Actuals 109,457 116,791 -- 29,863 32,311 -- -- 7,449 11,206 -- 262 295 40 39 760 760 67 - 140 140 -- -52 -699 -- 3 ,510 3,602 151,548 165,895 -- (7,448) (10,912) (7,448) (10,912) 144,100 154,983 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase/ Budget Decrease Expenditures Salaries & Wages 109,843 14,044 Overtime 600 (600) Employee Benefits 31 ,143 2,226 Conferences 650 - Seminars & Education 500 - Corporate Training 20,000 15,000 Travel 550 (350) Telephone & Data 305 (305) Internet 40 - Insurance Premium 760 76 Meals, Promotions & General -- Memberships 200 - Stationary & Office Supplies 300 - Programs & Event Supplies -- Educational Material 1,400 - Workplace Accomodation 900 - Software & Hardware Mtce. Contracts ·_2,870 (20) Total Expenditures 170,061 30,071 Revenues Total Revenues -- Transfers Transfer to (from) Oblig RF (20,000) (15 ,000) Total Transfers (20,000) (15,000) Net Expenditures (Revenues) 150,061 15,071 177 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 123,887 12 .79% -(100.00%) 33,369 7 .15% 650 -% 500 -% 35,000 75.00% 200 (63 .64%) -(100 .00%) 40 -% 836 10 .00% --% 200 -% 300 -% --% 1,400 -% 900 -% 2,850 (0 .70%) 200,132 17.68% --% (35,000) 75.00% (35,000) 75.00% 165,132 10.04% Pickering Public Library Overview The Pickering Public Library is responsible for ensuring that all Pickering residents have equitable access to the resources, information, and ideas that will enrich their civic, educational, career, and personal lives. I Pickering Public Library I .I --------, [ Public Services ] [ Support Services ] The Pickering Public Library offers access to free spaces, programs, collections, and other services that support the following ends: • Residents will be supported in their lifelong learning needs at all ages and stages • Residents will be enriched by a culture of reading • Residents will have access to inclusive, accessible, and welcoming public facilities and virtual spaces where the entire community can read, work, connect, collaborate, create, play, learn, or simply be • Residents will have access to library services that are high quality, efficient, and cost-effective, developed with community input and awareness • Residents will have access to library services that support their financial, physical, social, and mental well-being • Residents will have access to library services that champion inclusion, diversity and belonging 178 Pickering Public Library Key Activities for 2023 • Engage the community, stakeholders, and staff in developing an updated strategic plan for 2024-2027 • Renovate the Claremont Library to add an accessible public washroom and new shelving and furniture • Install a video production booth for client use in Maker Space • Renovate the lobby of the Central Library to reduce staff spaces and provide space for public seating, collections, and displays • Launch outreach vehicle Financial Information 2019 Full-Time 37 Reg. Part-Time 25 Total 63 Staffing Summary (Full & Regular Part-Time) Approved Prior Term 2020 2021 2022 Add 36 37 39 - 24 22 20 - 60 59 59 - Approved New Term 2023 Transfers Total -39 -20 -59 The Library is not requesting any change in staff complement in 2023. Year-Over-Year (Net Cost) Budget Changes 2022 2023 Year-Over-Year Approved Approved Change Budget Budget ($) (%) Libraries $6,135,385 $6,387,017 $251,632 4.10% Total (Net Cost) $6,135,385 $6,387,017 $251,632 4.10% 179 Pickering Public Library Explanation of Significant Departmental Budget Changes Expenditures -Increases/ (Decreases) Salaries, Wages & Benefits -$190,900 Increase reflects additional Sunday hours year-round at Central and George Ashe branches and the addition of one summer student position (see related grant funding below). Internet-$13,500 Increase supports improved public WIFI speeds for clients in all three library locations for teleworking and online learning. Consulting and Professional Fees -$116,500 The increase supports the development of the 2024-2027 strategic plan (partially funded from the Development Charge reserve fund) and a brand strategy. Building Repairs & Maintenance -$14,000 Increase due to maintenance requirements for aging facilities. Outside Agency Services -$57,200 Increased security costs reflect new contract and security coverage for Sunday hours at Central and George Ashe library branches. Program & Event Supplies -$20,000 Increase largely reflects one-time program costs for the senior's entrepreneurship program funded by a provincial grant (see related grant funding below). Library Materials -($14,000) Decrease in materials expenses is related to savings in digital resources. COVID Related Expenses -($53,000) Decrease reflects return to standard cleaning levels provided by City janitorial staff. All COVID-related expenses have been removed from the budget in 2023. Utilities -($23,000) Decrease due to prior year consumption trends partially offset by expected price increases in 2023. Software & Hardware Maintenance Contracts -$17,000 Increase in software costs for both client and staff use and additional software for enhanced cybersecurity. 180 Pickering Public Library System & Software Upgrades -$20,000 This expenditure is for the replacement of the library's Integrated Library System software. Revenues/Transfer from Reserves -(Increases)/ Decreases Federal & Provincial Grants -($60,400) The following grants are expected in 2023: • Ontario Connectivity Grant (awarded) • Seniorpreneur grant (awarded) • Young Canada Works summer jobs (forecasted) Transfer from Development Charge Reserve Fund -($78,800) This funding is related to the development of the Library's 2024-2047 strategic plan. 181 Pickering Public Library Departmental Performance Indicators/Statistics Performance 2020 2021 2022 Indicators/Statistics Total materials borrowed 684,038 758,202 860,735 Website visits 246,397 267,796 449,059 In-person visits 145,497 121,216 253,737 Active cardholders 37,583 33,855 33,497 Events & Outreach attendance 6,771 9,222 17,091 Number of events 503 520 650 182 Library 2021 2022 Actuals Actuals 3,094,936 3,308,620 2,768 6,560 837,447 874,733 1,997 2,273 3,104 1,585 3 ,695 5,790 29,174 20,178 305 1,527 1,040 2,622 162 365 13,245 15,427 50,692 21,292 4 ,979 35,179 119 1,299 13,627 13,149 5 ,425 3,172 24,830 24,830 -- 14,594 4,202 3,844 5,212 7 ,019 9,543 242,819 305,554 233,832 257,247 1,839 3,164 1,566 2,807 44,485 41 ,077 21,239 28,150 29,807 33 ,757 -8 ,342 6,287 7,446 314,398 321 ,992 -- 9,928 13,816 133,853 110,247 31,057 35,956 225,826 201 ,213 City of Pickering 2023 Approved Current Budget Summary 2022 -' Account Description Approved Increase/ Budget Decrease Expenditures Salaries & Wages 3,582,424 147,537 Overtime -3,275 Employee Benefits 1,001,984 40,095 Employee Recognition 4,135 (335) Uniforms 3,950 (2 ,880) Conferences 7 ,000 3,000 Seminars & Education 28,600 (5,100) Travel 3,000 540 Postage 1,150 50 Freight, Express & Cartage 400 100 Cellular Phones 12,980 4,300 Telephone & Data 23,165 (865) Internet 38,500 13,460 Cable TV 1,425 - Advertising 11 ,800 8,200 Brochures/Newsletters Printing 7,000 4,000 Insurance Premium 24,830 2 ,483 Insurance Deductible 2,000 - Consulting & Professional Fees 18,500 116,500 Meals, Promotions & General 6,000 1,000 Memberships 7,580 7,000 Outside Agency Services 286,698 57,212 Building -Repairs & Maintenance 238,843 13,975 Vehicle -Repairs & Maintenance 4,000 (2,000) Gas, Oil, Tire, Etc . 2,930 500 Misc. Equip . -Repairs & Maintenance 41,490 1,650 Stationary & Office Supplies 18 ,500 500 Programs & Event Supplies 26,000 20,000 Committee Expenses 11,000 100 Supplies & Tools 8,000 1 ,500 Library Materials 319,990 (13,990) COVID Related Expenses 53,000 (53,000) Utilities -Water 18,300 (1,000) Utilities -Hydro 189,000 (24 ,000) Utilities -Natural Gas 36,185 2,000 Software & Hardware Mtce . Contracts 222,051 16,975 183 Run Date: Sep 13, 2023 2023 Approved % Change Budget From 2022 3 ,729,961 4.12% 3 ,275 -% 1,042,079 4.00% 3,800 (8 .10%) 1,070 (72 .91 %) 10,000 42 .86% 23,500 (17.83%) 3,540 18 .00% 1,200 4.35% 500 25 .00% 17,280 33 .13% 22 ,300 (3.73%) 51,960 34.96% 1,425 -% 20 ,000 69.49% 11,000 57 .14% 27,313 10.00% 2,000 -% 135,000 629 .73% 7,000 16.67% 14,580 92 .35% 343,910 19 .96% 252,818 5.85% 2,000 (50 .00%) 3,430 17 .06% 43,140 3 .98% 19,000 2 .70% 46,000 76 .92% 11,100 0.91% 9,500 18 .75% 306,000 (4 .37%) -(100.00%) 17,300 (5.46%) 165,000 (12 .70%) 38,185 5.53% 239,026 7 .64% Library 2021 2022 Actuals Actuals -- 32 ,583 28 ,059 14 ,331 8,153 5,456,852 5,764,538 (36 ,574) (13 ,333) (136 ,689) (146,689) (11,939) (26,776) (291) (1,807) -(723) (12,204) (1,939) (9,338) (6,079) (3 ,995) (6 ,354) (211 ,030) (203,700) -- 100,000 100,000 100,000 100,000 5,345,822 5,660,838 City of Pickering 2023 Approved Current Budget Summary 2022 Account Description Approved Increase I Budget Decrease System & Software Upgrade -20,000 Hardware Replacements 16,000 - Furniture & Fixtures 5 ,000 5,000 Total Expenditures 6,283,410 387,782 Revenues Federal Grants (27 ,600) (9,400) Ontario Grants (106,425) (51,000) Department User Fees (53 ,000) - Vending Machines (2,500) - Rentals -Meeting Rooms (3,500) (2 ,000) Other User Fees (10,000) - Fines & Charges (20,000) - Donations (25,000) 5,000 Total Revenues (248,025) (57,400) Transfers Transfer to/(from) DC Oblg RF -(78,750) Transfer to(from) Reserve 100,000 - Total Transfers 100,000 (78,750) Net Expenditures (Revenues) 6,135,385 251,632 184 Run Date : Sep 13, 2023 2023 Approved %Change Budget From 2022 20,000 -% 16 ,000 -% 10,000 100.00% 6,671,192 6.17% (37 ,000) 34.06% (157,425) 47 .92% (53,000) -% (2 ,500) -% (5,500) 57 .14% (10 ,000) -% (20 ,000) -% (20,000) (20 .00%) (305,425) 23.14% (78,750) -% 100,000 -% 21,250 (78.75%) 6,387,017 4.10% City of Pickering 2023 11005 Council Support Approved Background Information Expenditures 2023 Budget 502210.0001 Insurance Premium Annual cost of insurance policy that provides protection for municipal activities and property. (Policy coverage includes: liability, automobile and property).1,518 Total 502210.0001 Insurance Premium 1,518 502240.0001 Meals/Prom/General Includes provision for Special Meetings (i.e. Council, Budget, etc.)3,500 Total 502240.0001 Meals/Prom/General 3,500 502250.0001 Memberships Executive Assistant, Mayor 150 Total 502250.0001 Memberships 150 502700.0001 Sfwr/Hdwr Mntc Contr Maintenance - HRIS 1,000 Total 502700.0001 Sfwr/Hdwr Mntc Contr 1,000 502500.0001 Stationery&OfficeSup General office supplies, toners 455 Total 502500.0001 Stationery&OfficeSup 455 Total Expenses $377,803 Council 208A