Loading...
HomeMy WebLinkAbout2024 Mayors Proposed Current Budget 2024* Current Budget *As Proposed by the Mayor. January 30, 2024 -Qq;of- P](KERJNG Budget Summaries City of Pickering 2024 Current Budget Table of Contents Office of the Chief Administrative Officer Office of the CAO -Administration Customer Care Centre Public Affairs & Corp. Comm . Economic Development & Strategic Projects Economic Development & Strategic Projects City Development City Development -Administration Planning & Design Office of Affordability Building Services Sustainability Committee of Adjustment Heritage Pickering Community Services Culture & Recreation -Administration Programs Culture Services Dunbarton Pool Don Beer Arena Community Centres Recreation Complex -Central Core Recreation Complex -Pool Recreation Complex -Arenas Civic Centre Senior Citizens Centre Museum Operations Public Works -Administration Property Maintenance Fleet Services Roads Parks Operations Services Major Capital Facilities Department Page 1 16 10000 29 10005 31 10010 32 34 10050 42 44 10100 55 10105 56 10105-9755 58 10110 59 10115 61 10120 63 10125 64 65 10200 79 10205 81 10207 83 10210 85 10215 86 10220 88 10225 90 10230 92 10235 93 10240 95 10245 96 10250 98 100 10300 114 10305 116 10310 118 10315 120 10320 122 10325 124 10330 125 Corporate Services Legal Services Information Technology Clerks Office City of Pickering 2024 Current Budget Table of Contents Records Management & Elections Print Shop/ Mail Room By-Law Animal Services Engineering Services Engineering Services -Administration Crossing Guards Water Resources & Development Services Sidewalks Streetlights Finance Finance Supply & Services Fire Services Fire Protection Emergency Operations Human Resources Human Resources Health & Safety Libraries Library General Government Capital Reserve & Reserve Fund Continuity Schedule 126 10400 136 10405 137 10410 139 10415 140 10420 141 10425 142 10430 144 146 10500 154 10505 156 10510 157 10515 159 10520 160 161 10600 170 10605 172 173 10700 181 10705 183 184 10800 190 10805 191 192 10900 198 200 228 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 City of Pickering ::::::::::::::::::::::::t:::::::::::::::::::::::i:ilii]lt:\::::::::::::::::::~9.~4.::ijtjij:gijt::::<i:i:::::::::::::::::::::::::::::::::::::::::/!::::::::::::::::::::::::i::::::::;::::::::: 2023 Increase Budget {Decrease} City Revenues ($52 ,033,905) ($10,086,158) Est. Casino Gaming Revenues -16 ,000 ,000 -2 ,830 ,000 Supplementary Tax Revenues -500,000 -100 ,000 2024 Assessment Growth Q -3,393 ,000 Sub Total Lines (1 to 4) ($68,533,905) ($16,409 ,158) City Expenditures $138,892 ,481 $16,240,581 Transfer to Casino Reserve 16,000,000 2,830,000 Capital From Current 668,000 82,000 Sub Total (Lines 6 to 8) $155,560,481 $19,152 ,581 Net City (Lines 5 Minus 9) $87,026,576 2,743,423 One -Time Funding City Use of One Time Funds: Rate Stabilization Reserve -1 ,500,000 Funding of Major Cost Pressures From Casino Reserve Bill 23 (DC Fee Reduction) Elexicon Dividend Decrease Sub Total (Lines 11 to 13) Base Budget (L 10 Plus 14) Add: Bill 23 -DC Funding Shortfall Four Staff -4th Class FireFighters Recommended Budget Percentage Est. Levy Inc. Impact on Tax Bill School Boards 13.18% -3,500,000 1,000,000 -1,452 ,744 224,000 -6,452,744 1,224 ,000 $80,573,832 $3,967,422.80 3 ,500,000 -1,000,000 387,900 $84,073,832 $3,355,323 Residential Levy Impact City 31.20% 3.99% 1.25% 1 Estimated Region 55.62% 7.50% 4.17% 2024 Draft Budget ($62,120,063) -18 ,830,000 -600 ,000 -3,393,000 ($84,943 ,063) $155,133,062 18,830,000 750,000 $174,713,062 $89,769,999 -1 ,500,000 -2 ,500,000 -1,228,744 -5 ,228 ,744 $84,541,255 2,500 ,000 387,900 $87.429, 155 Total 100.00% 5.42% -12.00% -3 .37% -0.12% -4.04% -19.52% 19.32% 3.37% 0.10% 22 .78% 3.26% 0.00% 1.19% 0.27% 1.46% 4.72% -1.19% 0.46% 3.99% 2024-0 1-29 A B C D City of Pickering Casino Reserve 2023 2024 :Ja11uary t -Opening Balance $ 19,398,200 $. 22,574,953 Current Budget Capital Facilities Team (189,975) (625,406) Community Grants (260,181) (579,066) Senior's Snow Program (388,700) (583,050) City Centre Consulting (490,000) Petticoat Creek Conservation Park Visioning Exercise (300,000) Elexicon Dividend Shortfall • (1,452,800) (1,228,744) Bill 23 Development Charge Shortfall (3,738,095) (2,500,000) Total Current Budget Expenditures $ (6,519,751) $ (5,816,266) Capital Projects Capital Projects -2023 (4,533,700) Beachfront Park Master Plan (5,050,000) CHDRC -Tennis Court Flooring Replacement (2,210,000) City Centre Phase 1 -City Centre Park -Design (750,000) Brockridge Community Park -Parking Lot Improvements (550,000) Pickering Heritage & Community Centre (866,676) Accessible Pedestrian Signals (400,000) Claremont Memorial Park ~ Playground Reconstruction (400,000) Diana Princess of Wales Park -Playground Replacement (200,000) Ernie L. Stroud Park -New Multi-Use Court (156,000) Outdoor Pickelball Court Complex -Design (location TBD) (150,000) Beachlawn Park -New Multi-Use Court (100,000) Total Capital Budget Expenditures $ (4,533,700) $ (10,832,676) Total Expenditures I Commitments (B+C) $ (11,053,451) $ (16,648,942) S'ub-total (A~D) $ 8,344,749 $ 5,926,011 New Casino Funds 18,460,408 18,830,000 Less: Payments to Durham Region (4,230,204) (4,414,808) 1 Net Casino Revenues $ 14,230,204 $ 14,415,192 Represents the Philisophy that You Earn the Casino Dollars in Year A and Spend in Year B • December 31 -Estimated Closing Balance $ 22,574,953 $ 20,341,203 1 Estimated revenues and payments for 2024 2 The 2024 financial plan results in the City spending more dollars in 2024 than what is being projected to be received 2 2 City of Pickering 2024 Current Budget 2024 Key Current Budget Highlights • Operationalize the Corporate Strategic Plan • Increase Senior's Property Tax Grant from $535 to $560 • Enhance Community Events including an Easter Parade • Social funding for: St. Paul's on the Hill Community Food Bank, Dedicated Advocacy & Resource Services (OARS), Jerry Couglan Health & Wellness Centre and expanded community grant program • Undertake Petticoat Creek Conservation Park visioning exercise and associated investigative studies (Resolution #392/24) • Increase Fire Services Staffing -additional 4 firefighters • Expand support for the City's Committees (Community Safety & Wellbeing Advisory Committee, Anti-Black Racism Task Force) 4 City of Pickering 2024 New Full & Part Time Permanent Positions Department Position Effective #or··· 2024 Property Tax Impact Date Positions Salary Benefits Total Cost Office ofthe CAO Government & Stakeholder Relationship Specialist 1-Jan 1.0 $101,920 $30,600 $132,520 Community Engagement Coordinator (net cost) 1-Jan 0.5 -3,265 3,265 (conversion from contract to part-time) 1.5 . $101,920 $33,865 $135,785 Community Services Supervisor, Pickering Museum Village 1-Jan 1.0 107,100 32,100 139,200 Less: Part-time Childcare redunda.nt positions 1-Jan -2.5 (129,630) (25,150) (154,780) Facility Operator 1-Apr 2.0 87,800 26,400 114,200 Volunteer Coordinator (conversion from part-time) 1-Apr 1.0 55,300 16,600 71,900 Less: Part-time Volunteer Coordinator 1-Apr -0.5 (44,000) (7,900) (51,900) Graphic Assistant (net cost) 1-Jan 0.5 $5,500 $4,400 $9,900 (conversion from term to part-time) 1.5 $ 82,070 $ 46,450 $ 128,520 - Operations Heavy Equipment Operator I 1-Jan 2.0 $150,050 $45,015 $195,065 Maintenance Worker, Roads 1-Jan 2.0 144,310 43,300 187,610 Maintenance Worker, Parks & Property 1-Jan 2.0 144,310 43,300 187,610 Coordinator, SAP 1-Jan 1.0 88,635 26,590 115,225 7.0 $527,305 $158,205 $685,510 Corporate Services • Senior Project Manager, Digital Services 1-Jan 1.0 $129,440 $36,300 $165,740 Parking Control Officer 1-Jan 1.0 68,160 20,450 88,610 By-law Enforcement Officer (Part-time) 1-Jan 1.0 68,170 12,600 80,770 3.0 $265,770 $69,350 $335,120 Engineering Services Coordinator, Forestry Management 1-Jan 1.0 $112,900 $33,880 $146,780 Finance , Purchasing Contract Specialist 1-Jan 1.0 $78,500 $23,500 $102,000 Fire Services Firefighters 1-Jan 4.0 $298,300 $89,600 $387,900 Total 19.00 $1,466,765 $454,850. $1,921,615 -C�()/­p](KERJNG Average Daily Cost of Municipal Services: 23.2% $1.46 Fire Service � 4.2% $ 0.27 Debt Servicing Costs 20.7% Roads & Water Network $ 1.31 7.2% Library II 5.6% $ Community & Recreation Centres 0.35 6.5% 7 Corporate Services 2024 Budget Average Daily Cost of Municipal Services $ 6.31 $ 0.45 [ $ 0.41 8.0% Parks & Property $ 0.51 4.1% $ 0.26 Culture & Recreation Other 1.4% $ 0.09 1.6% Mayor, Council & Council Support $ 0.10 1.2% $ 0.08 1.2% $ 0.08 City Development 0.7% Animal Services 1.1% Arenas Streetlights $ 0.04 . 0.6% $ 0.04 1% .IK\ . • Customer 'G)Care Museum $ 0.07 0.8% $ 0.05 0.1% Community , By-law Grants •e:, • Services1 \· _: Recreation Programs c O � 'J,I· v·il •1 yrnrr $ 0.06 0.7% Crossing Guards $ 0.01 10.2% � ri����vE� l All Other f>AR�ING I Areas --�J $ 0.04 0.63 * Calculated based on the average assesed value of $612,000 for a residential property. 9 Full Accrual Budget The City of Pickering, like most municipalities, prepares its Current Budget on the traditional cash basis. This provides a clear and concise presentation of the property taxes needed to fund City operations each year'. This cash-based budget also determines the tax rate to be approved by Mayor and Council. Since 2009, changes by the Public Sector Accounting Board (PSAB) require municipalities to prepare financial statements on a full-accrual basis, including reporting Tangible Capital Assets (TCA) in the statement of financial position, and amortizing the assets over their useful lives in the statement of operations. Under Ontario Regulation 284/09, all municipalities are required to report on the impact that tangible capital asset purchases and amortization expense, as well as other non- cash items such as post-employment benefits and debt principle payments, have on the cash-based budget. This full-accrual budget presentation provides a complete picture of the long-term financial health of the City and is consistent with the City's full-accrual accounting in the financial statements. The estimated net increase in the 2024 accumulated surplus of the City resulting from the exclusion of non-cash items from the cash-based Current Budget is summarized below: PSAB Additions to 2024 Budget (Reduces Surplus) Amortization Expense Post-Employment Benefits Expense Total PSAB Additions PSAB Reduction to 2024 Budget (Increases Surplus) Tangible Capital Asset Acquisition Net Transfers to/from Reserves and Reserve Funds Debt Principal Payments Total PSAB Reductions Net Increase in Accumulated Surplus 10 ($12,555,100) (897,0001 ($13,452,000) $20,328,000 3,979,500 3,352,000 $27,659,500 $14,207,500 City of Pickering 2024 Departmental Expenditures by Cost Centre 2023 Increase/ Budget (Decrease) Department Expenditures 10000 Office of the CAO -Administration 583,867 27,481 10005 Customer Care Centre 506,916 12,339 10010 Public Affairs & Corp. Comm. 1,379,019 148,327 10050 Economic Development & Strategic Projects 1,171,582 798,776 10100 City Development -Administration 1,015,573 (133,955) 10105 Planning & Design 5,258,525 695,415 10110 Building Services 2,563,745 360,399 10115 Sustainability 870,335 355,475 10120 Committee of Adjustment 11,778 466 10125 Heritage Pickering 17,525 1,000 10200 Culture & Recreation -Administration 4,222,283 (902,725) 10205 Programs 3,344,383 (246,352) 10207 Cultural Services -1,761,895 10210 Dunbarton Pool 536,204 49,616 10215 Don Beer Arena 1,530,349 321,233 10220 Community Centres 892,171 259,268 10225 Recreation Complex -Central Core 3,951,930 (114,470) 10230 Recreation Complex -Pool 980,768 (26,486) 10235 Recreation Complex -Arenas 1,149,023 43,243 10240 Civic Centre 1,199,128 133,312 10245 Senior Citizens Centre 612,699 42,075 10250 Museum 1,638,549 (311,671) 10255 Pickering Arts Centre - - 10300 Public Works -Administration 1,022,806 82,865 10305 Property Maintenance 1,727,186 18,889 10310 Fleet Services 2,324,003 82,579 10315 Roads 9,177,349 1,146,810 10320 Parks 5,649,424 696,883 10325 Operations Services 1,611,829 55,088 10330 Major Capital Facilities 189,975 435,431 10400 Legal Services 995,053 (96,313) 10405 Information Technology 3,892,845 291,267 10410 Clerks Office 674,502 190,511 10415 Records Management & Elections 177,016 19,609 10420 Print Shop/Mail Room 561,750 21,373 11 Run Date: Jan 26, 2024 2024 % Change Budget From 2023 " -, 611,348 4.71% 519,255 2.43% 1,527,346 10.76% 1,970,358 68.18% 881,618 (13.19%) 5,953,940 13.22% 2,924,144 14.06% 1,225,810 40.84% 12,244 3.96% 18,525 5.71% 3,319,558 (21.38%) 3,098,031 (7.37%) 1,761,895 - % 585,820 9.25% 1,851,582 20.99% 1,151,439 29.06% 3,837,460 (2.90%) 954,282 (2.70%) 1,192,266 3.76% 1,332,440 11.12% 654,774 6.87% 1,326,878 (19.02%) -- % 1,105,671 8.10% 1,746,075 1.09% 2,406,582 3.55% 10,324,159 12.50% 6,346,307 12.34% 1,666,917. 3.42% 625,406 229.20% .. 898,740 (9.68%) 4,184,112 7.48% 865,013 28.24% 196,625 11.08% 583,123 3.80% City of Pickering 2024 Departmental Expenditures by Cost Centre 2023 Increase/ Budget (Decrease) 10425 By-Law 2,117,671 278,173 10430 Animal Services 766,832 56,130 10500 Engineering Services -Administration 3,166,507 329,314 10505 Crossing Guards 434,140 166,895 . 10510 Water Resources & Development Services 2,658,578 (159,858) 10515 Sidewalks 685 ,654 (195,649) 10520 Streetlights 1,024,720 99,301 10600 Finance 5,115,639 924,543 10605 Supply & Services 707,863 26,161 10700 Fire Protection 20 ,543 ,920 809,038 10705 Emergency Operations 184,642 6,272 10800 Human Resources 1,584,875 69,873 10805 Health & Safety 200,132 (4,381) 10900 Library 6,671,192 209,740 TOTAL 107,302,455 8,835,205 12 Run Date : Jan 26, 2024 2024 % Change Budget From 2023 2,395,844 13.14% 822,962 7.32% 3 ,495,821 10.40% 601,035 38.44% 2,498,720 (6.01%) 490,005 (28.53%) 1,124,021 9.69% 6,040,182 18.07% 734,024 3.70% 21,352,958 3.94% 190,914 3.40% 1,654 ,748 4.41% 195,751 (2.19%) 6,880,932 3.14% 116,137,660 8.23% City of Pickering 2024 Departmental Revenues by Cost Centre 2023 Increase I Budget (Decrease) Departmental Revenues 10010 Public Affairs & Corp. Comm. (161,985) 61,985 10050 Economic Development & Strategic Projects (202,250) (733,540) 10100 City Development -Administration (145,000) 143,000 10105 Planning & Design (3,537,480) 242,206 10110 Building Services (4,235,000) (535,000) 10115 Sustainability (202,750) (270,340) 10200 Culture & Recreation -Administration (587,300) 301,300 10205 Programs (2,481,950) (656,138) 10207 Cultural Services -(201,800) 10210 Dunbarton Pool (132,440) 700 10215 Don Beer Arena (1,087,650) (33,550) 10220 Community Centres (199,380) 5,980 10225 Recreation Complex -Central Core (1,239,690) (30,310) 10230 Recreation Complex -Pool (271,960) (6,561) 10235 Recreation Complex -Arenas (846,700) (47,400) 10240 Civic Centre (323,790) (136,250) 10245 Senior Citizens Centre (206,400) (53,244) 10250 Museum (753,650) 360,450 10300 Public Works -Administration (175,850) (15,250) 10305 Property Maintenance (60,100) (30,050) 10310 Fleet Services (193,000) 12,400 10315 Roads (425,050) 136,925 10320 Parks (259,000) 224,000 10325 Operations Services (46,000) - 10400 Legal Services (159,000) (109,000) 10405 Information Technology (251,680) 251,680 10410 Clerks Office (323,000) (35,000) 10425 By-Law (1,827,600) (494,500) 10430 Animal Services (180,300) (12,950) 10500 Engineering Services -Administration (235,000) (19,000) 10510 Water Resources & Development Services (1,317,540) (152,460) 10520 Streetlights (500) - 10600 Finance (4,316,000) (960,000) 10700 Fire Protection (231,000) 20,000 13 Run Date : Jan 26, 2024 2024 % Change Budget From 2023 ~ (100,000) (38.27%) (935,790) 362.69% (2,000) (98.62%) r (3,295,274) (6.85%) (4,770,000) 12.63% (473,090) 133.34% (286,000) (51.30%) (3,138,088) 26.44% (201,800) -% (131 ,740) (0.53%) (1,121,200) 3.08% (193,400) (3.00%) (1,270,000) 2.44% (278,521) 2.41% (894,100) 5.60% (460,040) 42.08% (259,644) 25.80% (393,200) (47.83%) (191,100) 8.67% (90,150) 50.00% (180,600) (6.42%) (288,125) (32.21%) (35,000) (86.49%) (46,000) - % (268,000) 68.55% -(100.00%) (358,000) 10.84% (2,322,100) 27.06% (193,250) 7.18% (254,000) 8.09% (1,470,000) 11.57% (500) - % (5,276,000) 22.24% (211,000) (8.66%) / 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 Office of the CAO Department I / ' Public Affairs & Corporate Communications '-.I I I ' , ' / ' , Public Affairs & Customer Care Office of the CAO Equity, Diversity Corporate Centre Administration & Inclusion Communications '-\: '- 16 ' Office of the CAO Department Key Activities for 2024 in Support of the Corporate Strategic Plan Corporate Key: Good Governance & Customer Service Excellence • Coordinate the implementation of the Corporate Strategic Plan and develop the corporate-wide operational plan. • Co-lead the implementation of the Digital Readiness Assessment & Strategy, including a website refresh project. • Implement customer service training for internal staff to support continuous improvement and customer service excellence. • Modernize processes within the Customer Care Centre through various channels, i.e. website, online service request forms, live chat, etc. • Host annual Staff Town Hall events across the corporation. • Communicate and liaise with external agencies to promote a cohesive partnership when dealing with issues impacting the City. Priority 1: Champion Economic Leadership and Innovation • Develop and implement a communications strategy, in partnership with the Economic Development & Strategic Projects Department, to increase public awareness and education regarding Economic Development and the benefits resulting from strong economic growth. Priority 2: Advocate for an Inclusive, Welcoming, Safe & Healthy Community • Implement the City's Equity, Diversity and Inclusion (EDI) Strategy (subject to Council's approval). • Host and support online and in-person outreach events based on strategic corporate initiatives, trending topics, and general engagement (Town Halls, pop- ups, speaker series). • Develop and implement new employee and administration staff training and communications programs to support the principles of Equity, Diversity, Inclusion. Priority 3: Advance Innovation & Responsible Planning to Support a Connected, Well-Serviced Community • Enhance digital media and video content production to support corporate priorities and initiatives. • Coordinate Speaker Series with respected knowledge leaders and community partners to promote Pickering's responsible planning and sustainable growth objectives. 17 Office of the CAO Department Priority 6: Foster an Engaged & Informed Community • Coordinate production of monthly Council Highlights and monthly Mayor's Recaps to promote Pickering's responsible planning and sustainable growth objectives. • Support departments across the Corporation in the communication of key services, programs, projects and initiatives. • Facilitate the completion of the Pickering Magazine, to be published and mailed to all households. • Coordinate and implement the social media strategy while developing social media staff leads and identifying new tools to invest in (such as Linkedln). • Explore emerging technologies that may benefit the Customer Care Centre that would allow community members to better engage with staff. 18 Financial Information Office of the CAO Department Staffing Summary (Full & Regular Part-Time) Prior Term of Council Current Term of Council 2019 2020 2021 2022 2023 2024 Approved Add Delete Total Full-Time 13 13 14 15 13 1 -14 Reg. Part-Time 1 1 1 2 2 1 -3 Total 14 14 15 17 15 2 -17 The department proposes to add the following positions in 2024: • One full-time Government & Stakeholder Relations Specialist position responsible for the provision of key public affairs and stakeholder relation activities for the Office of the CAO. Working closely with the Mayor, Chief Administrative Officer, and Senior Management, this position acts as a hands-on advisor when navigating issues related to government affairs and building and supporting stakeholder relationships. • Conversion of one contract part-time Community Engagement Coordinator position to permanent part-time to further the City's work in equity, diversity, and inclusion. Year-Over-Year (Net Cost) Budget Changes Year-Over-Year 2023 2024 Change Budget Budget ($) (%) CAO Administration $583,867 $611,348 $ 27,481 4.71% Customer Care Centre 506,916 519,255 12,339 2.43% Public Affairs & Corp. Communications 1,056,559 1,427,346 370,787 35.09% Total (Net Cost) $2,147,342 $2,557,949 $410,607 19.12% 1 9 Office of the CAO Department Explanation of Significant Departmental Budget Changes • Account Change Explanation ' Expenditures -Increase/ (Decrease) Salaries & Wages • Employee Benefits Advertising Consulting & Professional Services Committee Expenses Other Expenses : Total Expenditures $222,752 Increase is largely due to the addition of one new full- time Government & Stakeholder Relations Specialist ' position, the conversion of one contract Community Engagement Coordinator position to full-time, and the annualization of two new positions approved in 2023. $61,515 Increase is largely due to benefit costs associated with the above noted addition of one new full-time Government & Stakeholder Relations Specialist position, the conversion of one contract Community Engagement Coordinator position to full-time, and the annualization of two new positions approved in 2023. Additional impacts include the increase in statutory benefits costs due to enhanced CPP rates and inflationary increases in group health benefit costs. $31,000 Increase reflects the transfer of budgeted funds from Culture & Recreation -Adm in. (10200 cost centre) to enable the CAO's office to coordinate advertising for statutory notices. ($182,575) Decrease is attributed to the completion of the Digital Readiness Assessment, EDI consultations, and public engagement initiatives for the development of the Corporate Strategic Plan in 2023. $62,000 Increase is mainly due to policy development consulting costs for the Anti-Black Racism Task Force. ($6,545) $188,147 Revenues -(Increase) / Decrease Federal Grants Total Revenues $61,985 Decrease reflects the removal of one-time grant funding for one contract position from 2023. $61,985 20 Office of the CAO Department Account Change Explanation . Transfers -(Increase) / Decrease Continuing Studies Reserve ! Total Transfers I Net Increase $160,475 Decrease is due to completion of Digital Readiness Assessment in 2023. $160,475 $410,607 21 Office of the CAO Department Department Performance Indicators/Statistics Performance I 2021 2022 2023 Indicators/Statistics Corporate Communications Website Website (pickering.ca) 523,214 437,324 494,602 visitors Website (pickering.ca) 1,465,954 1,313,973 1,454,690 unique paQe views Website News Feed Subscribers: Business 452 509 580 Emergency Alert 506 592 703 Banner News & 730 831 948 Announcements Public Notices 679 759 862 Social Media @CityofPickering only (corporate account) F acebook Likes 11,258 12,000 14,241 F acebook Page Reach 519,923 2,855,689 5,282,388 ( estimated) lnstagram Page Reach 94,267 69,549 124,104 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. lnstaqram Followers 8,403 9,133 10,700 Twitter Followers 10,800 11,400 11,900 YouTube Channel Views 34,600 58,935 199,434 YouTube Hours Watched 6,000 7,995 18,290 YouTube Subscribers 668 920 2,077 22 Office of the CAO Department Performance 2021 2022 2023 Indicators/Statistics Facebook Live Events Mayor's Virtual Town SeQt. 21, 2021 March 30, 2022 Feb.28,2023 Halls • Total views: • Total views: • Total views: 697 907 2,100 • People • People • People reached: 1 , 187 reached: reached: • 93 comments 1,300 2,369 • 39 comments • 47 comments May 18, 2021 SeQt. 30, 2023 • Total views: • Total views: 1,300 429 • People • People reached: 6,000 reached: 7 41 • 163 comments • 42 comments Hate Crimes Town Hall N/A AQril 11, 2022 N/A • Total views: 757 • People reached: 832 • 19 comments Let's Talk Pickering -Nov.24,2021 N/A June 13, 2023 Speaker Series on Kim Petrin -Presentation with Planning and Manager of Karen Chapple U Development Development of T School of Services, City of Cities Edmonton • Total views: • Total views: 149 3,900 • People • People reached 621 reached: 6,500 • 3 comments • 25 comments Hosted as an in- Nov. 17,2021 person event ( 40. Brent Toderian -people), and Urban Advisor recorded video • Total views: uploaded after 3,900 the fact (not live • People streamed) reached: 8,000 • 73 comments 23 Office of the CAO Department Performance 2021 2022 2023 Indicators/Statistics Facebook Town Hall with NIA June 1, 2022 NIA CAO, Marisa Carpino • Total views: 5.3K • People reached: 5.3K Mayor's Telephone Town 5,865 attendees Feb.2,2022 NIA Halls • 3,088 attendees • 67 questions received Oct. 12, 2022 • 2,693 listeners • 33 questions received (4 development related) Mayor's V!VA Townhall - Seniors/Community/Faith ~20-25 guests Group Town Halls (in-St Mary & St person) John the Beloved Coptic Orthodox Church -30 guests South Pickering Seniors' Club and Pickering Lawn Bowling Club -1 O guests Amica Pickering ~20 guests St. Martins Anglican Church Townhall ~30 guests Muslim Community Roundtable -10 guests Jewish Community Roundtable -6 quests 24 Office of the CAO Department Performance 2021 2022 2023 Indicators/Statistics Media releases issued 64 39 65 by 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 1,644 1,107 1,943 Social media 2,932 2,664 4,556 Reach Trend. - Number of potential viewers that have been exposed to our search topics: Let's Talk Pickering -Digital Community Engagement Platform Registered users 1,411 1,790 ·3,120 Total Visits - # times a 10,900 13,700 75,000 user visited or stayed on the site > 30 minutes Aware Visitors: visitor 8,400 10,700 58,300 that has made one single visit to site or project Informed Visitors: visitor 4,200 3,900 26,200 who sought more information by clicking on something Engaged Visitors: visitor 1,800 1,800 18,600 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 PaQe Views 10,812 7,041 5,089 Unique Users 633 456 383 25 Office of the CAO Department Performance I 2021 2022 2023 Indicators/Statistics Customer Care • Telephone 44,622 41,068 38,350 Counter -in person 2,773 6,376 6,629 inquiries made by the public at the Customer Care Centre (located at City Hall) AMAN DA Service 27,008 27,653 31,953 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 350 683 374 communication with Customer Care staff during regular business hours. Customer Care Web 5,621 9,122 8,411 Email Pingstreet -Smart App 403 436 291 enabling residents to submit a request for service or ask a question of the City. After-Hours Calls -calls 1,308 1,686 1,542 received from the City's contracted after-hours service provider that are screened and processed by City staff on the next business day. Total 82,085 87,024 87,550 26 City of Pickering 2024 Current Budget Summary Office of the CAO Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 1,828,734 1,418,666 Salaries & Wages 1,411,789 1,064 5 ,128 Overtime 2,000 434,748 386,486 Employee Benefits 369,808 6,178 7,339 Conferences 10,000 16 ,346 19,977 Seminars & Education 31,500 18,609 14,061 Travel 18,550 17,731 1,237 Business Development 3,000 182 -Freight, Express & Cartage - 9,573 10,309 Cellular Phones 14,900 24,299 20 ,730 Telephone & Data 25 ,200 572 552 Internet 445 18,273 8 ,827 Advertising 13,000 6,000 -Trade Shows.Exhibits & Displays - 1,325 2,340 Subscriptions & Publications 3 ,545 6,365 4,470 Brochures/Newsletters Printing 5,000 3,427 4,379 Photo, Mapping, Print 5,500 8,920 8,360 Insurance Premium 8,360 439,205 151 ,686 Consulting & Professional Fees 227,575 58,405 23,139 Meals, Promotions & General 37,000 10,555 6,110 Memberships 1,740 26,210 7,582 Outside Agency Services 117,500 --Gas, Oil, Tire, Etc. 1,000 4 ,363 2,528 Stationary & Office Supplies 6,100 1,708 148 Programs & Event Supplies 700 50,758 37,650 Committee Expenses 75,000 1,474 1,783 Utilities -Hydro 2,300 11,876 20 ,791 Software & Hardware Mtce . Contracts 32 ,990 26,580 28,856 Website Support 42,300 998 -System & Software Upgrade - 142 -Hardware Replacements - 101 835 Misc . Equipment 3 ,000 3,034,721 2,193,969 Total Expenditures 2,469,802 Revenues --Federal Grants (61,985) (10,407) -Ontario Grants - 27 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 222,752 1,634,541 15.78% -2 ,000 -% 61 ,515 431 ,323 16 .63% 2,500 12,500 25 .00% {1,200) 30,300 (3 .81%) 1,250 19,800 6 .74% -3,000 -% --- % (1,460) 13,440 (9 .80%) 1,000 26 ,200 3 .97% -445 -% 31,000 44 ,000 238.46% --- % (225) 3,320 (6 .35%) -5,000 -% -5,500 - % 1,255 9,615 15 .01% (182 ,575) 45,000 (80 .23%) (1,000) 36,000 (2 .70%) 150 1,890 8.62% (1,500) 116,000 (1 .28%) 100 1,100 10.00% -6,100 -% -700 - % 62,000 137,000 82.67% (400) 1,900 (17 .39%) (7,015) 25,975 (21 .26%) -42 ,300 - % --- % --- % -3,000 -% 188,147 2,657,949 7.62% 61,985 -(100 .00%) --- % City of Pickering 2024 Current Budget Summary 10000 Office of the CAO -Administration 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 936 ,375 409,651 Salaries & Wages 422 ,724 -260 Overtime 500 217 ,637 118 ,935 Employee Benefits 107,145 6,178 5,078 Conferences 4,500 77 754 Seminars & Education 2,000 18,034 13,314 Travel 15,000 16,383 -Business Development - 182 -Freight , Express & Cartage - 4,920 4,122 Cellular Phones 5,300 1,749 1,453 Telephone & Data 1,700 229 184 Internet 100 11 ,169 1,786 Advertising 3 ,000 6,000 -Trade Shows.Exhibits & Displays - 257 203 Subscriptions & Publications 425 2,800 1,628 Insurance Premium 1,628 372,228 -Consulting & Professional Fees - 47,424 4 ,190 Meals, Promotions & General 10,000 5,465 4,127 Memberships 840 20,279 1,832 Outside Agency Services 3,000 --Gas, Oil, Tire, Etc . 1,000 3,616 1,836 Stationary & Office Supplies 4,500 989 166 Software & Hardware Mtce . Contracts 505 667 -Website Support - 142 -Hardware Replacements - 101 -Misc. Equipment - 1,672,901 569,519 Total Expenditures 583,867 Revenues --Federal Grants - (10,407) -Ontario Grants - --Marketing Sponsors - (268,396) -Cost Recoveries - (278,803) -Total Revenues - Transfers (132 ,913) -Transfer to(from) Cntg Sty Res . - 29 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 20,334 443,058 4 .81% -500 -% 7,000 114,145 6 .53% -4 ,500 - % (1,200) 800 (60 .00%) 1,000 16,000 6 .67% ---% --- % (1,320) 3,980 (24 .91 %) (100) 1,600 (5 .88%) -100 - % -3,000 - % ---% (225) 200 (52 .94%) 242 1,870 14.86% 5,000 5,000 -% (3,000) 7,000 (30 .00%) 150 990 17 .86% (500) 2 ,500 (16 .67%) 100 1,100 10.00% -4,500 -% -505 - % ---% --- % --- % 27,481 611,348 4.71% --- % ---% ---% ---% --- % --- % City of Pickering 2024 Current Budget Summary 10000 Office of the CAO -Administration 2022 2023 2023 Actuals YTD Account Description Budget Actuals --Transfer to(from) Reserve - (132,913) -Total Transfers - 1,261,185 569,519 Net Expenditures (Revenues) 583,867 30 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 ---% --- % 27,481 611 ,348 4 .71% City of Pickering 2024 Current Budget Summary 10005 Customer Care Centre 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 342,639 378,811 Salaries & Wages 362,248 438 1,308 Overtime 1,000 90,386 110 ,191 Employee Benefits 101,960 -1,377 Conferences 1,500 6,409 6,869 Seminars & Education 10,000 -352 Travel 800 211 295 Cellular Phones 1,200 21,675 17,824 Telephone & Data 21,800 229 184 Internet 230 2,630 2,893 Insurance Premium 2,893 486 945 Meals, Promotions & General 1,000 235 716 Memberships 550 366 377 Stationary & Office Supplies 600 57 148 Programs & Event Supplies 700 445 -Software & Hardware Mtce. Contracts 435 466,206 522,290 Total Expenditures 506,916 Revenues --Total Revenues - Transfers --Total Transfers - 466,206 522,290 Net Expenditures (Revenues) 506,916 31 Run Date: Jan 25, 2024 Increase I 2024 % Change Decrease Budget From 2023 9,441 371,689 2.61% -1,000 -% 4,436 106,396 4 .35% (1,500) -(100 .00%) -10 ,000 -% -800 -% (660) 540 (55 .00%) 200 22,000 0 .92% -230 -% 437 3,330 15 .11% -1,000 -% -550 -% -600 -% -700 -% (15) 420 (3.45%) 12,339 519,255 2.43% - - - % - - -% 12,339 519,255 2.43% City of Pickering 2024 Current Budget Summary 10010 Public Affairs & Corp. Comm. 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 549,720 630,204 Salaries & Wages 626,817 626 3,560 Overtime 500 126,725 157,360 Employee Benefits 160,703 -884 Conferences 4,000 9,860 12,354 Seminars & Education 19,500 575 395 Travel 2,750 1,348 1,237 Business Development 3,000 4,442 5,892 Cellular Phones 8,400 875 1,453 Telephone & Data 1,700 114 184 Internet 115 7,104 7,041 Advertising 10,000 1,068 2,137 Subscriptions & Publications 3,120 6,365 4,470 Brochures/Newsletters Printing 5,000 3,427 4,379 Photo, Mapping, Print 5,500 3,490 3,839 Insurance Premium 3,839 66,977 151,686 Consulting & Professional Fees 227,575 10,495 18 ,004 Meals, Promotions & General 26,000 4,855 1,267 Memberships 350 5,931 5,750 Outside Agency Services 114,500 381 315 Stationary & Office Supplies 1,000 1,651 -Programs & Event Supplies - 50,758 37,650 Committee Expenses 75,000 1,474 1,783 Utilities -Hydro 2,300 10,442 20,625 Software & Hardware Mtce. Contracts 32,050 25,913 28,856 Website Support 42,300 998 -System & Software Upgrade - -835 Misc . Equipment 3,000 895,614 1,102,160 Total Expenditures 1,379,019 Revenues --Federal Grants (61,985) --Advertising Space (100,000) --Total Revenues (161,985) Transfers 160,476 -Transfer to(from) Cntg Sty Res. (160,475) 32 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 192,977 819,794 30 .79% -500 -% 50,079 210,782 31.16% 4,000 8,000 100 .00% -19 ,500 -% 250 3 ,000 9 .09% -3,000 -% 520 8,920 6 .19% 900 2,600 52 .94% -115 -% 31,000 41,000 310 .00% -3,120 -% -5,000 -% -5,500 -% 576 4,415 15.00% (187,575) 40,000 (82.42%) 2 ,000 28,000 7.69% -350 -% (1,000) 113,500 (0 .87%) -1,000 -% ---% 62,000 137,000 82.67% (400) 1,900 (17.39%) (7,000) 25,050 (21 .84%) -42 ,300 -% ---% -3,000 -% 148,327 1,527,346 10.76% 61,985 -(100.00%) -(100,000) -% 61,985 (100,000) (38.27%) 160,475 -(100 .00%) City of Pickering 2024 Current Budget Summary 10010 Public Affairs & Corp. Comm. 2022 2023 2023 Actuals YTD Account Description Budget Actuals 160,476 -Total Transfers (160,475) 1,056,090 1,102,160 Net Expenditures (Revenues) 1,056,559 33 Run Dat e: Jan 25, 2024 Increase/ 2024 % Change Decrease Budget From 2023 160,475 -(100.00%) 370,787 1,427,346 35.09% Economic Development & Strategic Projects Department Overview The City's Economic Development & Strategic Projects Department is responsible for the expansion of the City's economic base and evolving Pickering's national and international profile by executing domestic & foreign investment and business retention programs. The Department is also responsible for leading the governmenUstakeholder relations and the project management of all major strategic projects/studies and infrastructure needs that are related to the development of employment lands, the expansion of the commercial and industrial base, major residential and non-residential growth areas, and new urban expansion areas. Management of corporate-wide grant applications, film production & attraction related activities, tourism, naming rights & sponsorship of public assets, are also the responsibility of the Economic Development & Strategic Projects Department. Economic Development includes: • Business Support • Local Business Communications • Business Retention & Expansion • Work Force & Talent Attraction • Research & Analytics • Target Sector Marketing • Investment Attraction (Domestic & Foreign Direct) • Trade Missions and Partnerships • Investment Servicing & Aftercare Film & Tourism includes: • Film Production Attraction • Creative Industries Attraction • Community Tourism Plan • Sports Tourism Attraction Program r Strategic Projects includes: • Pickering Nuclear Generating Station • Hotel/Convention Centre • Kingston Road Intensification • Pickering Innovation Corridor • Seaton Community • Northeast Pickering • Pickering City Centre • High Frequency Rail • Durham Live • Highway 407 Corridor • Post-Secondary Institution Attraction "I Economic Development & Strategic Projects Department '-) I I I I r 'I r 'I r " Economic Strategic Projects Film & Tourism Development ,) J '- 34 Economic Development & Strategic Projects Department Key Activities for 2024 in Support of the Corporate Strategic Plan Corporate Key: Good Governance & Customer Service Excellence • Site selection inquiries (for new businesses) and Site Visit Program (for existing businesses). Priority 1: Champion Economic Leadership and Innovation • Execute Investment Attraction Program. • Work with small/medium size businesses, developers and property owners on the future plans for the Kingston Road Intensification Program. • Monitor, lead and inform the Corporation on matters pertaining to the Pickering Nuclear Generating Station. • Work with other departments on the implementation of the Municipal Accommodation Tax. • Enhance investment attraction efforts to target businesses within the Creative/Film Industry. Priority 2: Advocate for an Inclusive, Welcoming, Safe & Healthy Community • Oversee all consulting work and the stakeholder relations for the High Frequency Rail project. • Enhance and execute Film & Tourism related initiatives (including attracting new facilities). • In collaboration with other departments complete and implement the Community Visitor Plan. • Actively participate in the Intelligent Communities Forum (ICF) and related initiatives. Priority 3: Advance Innovation & Responsible Planning to Support a Connected, Well-Serviced Community • Lead the completion and review of the Highway 7 Access Management study with key stakeholders and landowners in Seaton. • Work with all key stakeholders, utility providers and the development community to plan for the necessary infrastructure required for Seaton. • Prioritize the attraction of a Post-Secondary Institution to Pickering. • Oversee the completion of the Northeast Pickering Secondary Plan. • Work with key stakeholders and property owners on the proposed developments within Pickering City Centre. • Lead efforts in attracting a Hotel/Convention Centre. 35 Economic Development & Strategic Projects Department Priority 4: Lead & Advocate for Environmental Stewardship, Innovation & Resiliency • Enhance efforts and outreach for film & tv production attraction. Priority 5: Strengthen Existing and Building New Partnerships • Work with the property owner and key stakeholders on the Durham Live Project (including the Porsche Experience Centre and other proposed attractions). • Monitor, lead and inform the Corporation on matters pertaining to the Pickering Nuclear Generating Station. • Continue to strengthen all stakeholder relationships that assist in attraction of key users to the Pickering Innovation Corridor. Priority 6: Foster an Engaged & Informed Community • Review, plan and execute enhanced marketing promotions (social media, videos, publications). 36 Economic Development & Strategic Projects Department Financial Information Staffing Summary (Full & Regular Part-Time) Current Term of Council 2023 2024 Approved Transfer Delete Total Full-Time 5 1 -6 Reg. Part-Time ---- Total 5 1 -6 In 2023, one position related to the Film/Creative Industries function was transferred from the City Development Department to the Economic Development & Strategic Projects Department due to reorganization. The department is not proposing to add any new staffing in 2024. Year-Over-Year (Net Cost) Budget Changes Year-Over-Year 2023 2024 Change Budget Budget ($) (%) Economic Development $854,897 $808,379 ($46,518} (5.44%} Total (Net Cost) $854,897 $808,379 ($46,518) (5.44%) 37 Economic Development & Strategic Projects Department Explanation of Significant Departmental Budget Changes 'Account Change • Explanation Expenditures -Increase/ (Decrease) : Salaries & Wages Employee Benefits • Advertising Consulting & Professional Services Meals / Prom / General Software & Hardware Maintenance Contracts . Other Expenses $180,227 Increase is largely due to the transfer of one position from City Development in 2023 and the annualization , of one new position approved in 2023. $50,218 Increase is due to benefits costs related to the above noted transfer of one position from City Development in 2023 and the annualization of one new position approved in 2023. Additional impacts include the increase in statutory benefits costs due to enhanced CPP rates and inflationary increases in group health benefit costs. $14,000 Increase relates to budgeted funds for digital film advertising transferred from City Development. $533,131 Increase is largely driven by several new initiatives in 2024: High Frequency Rail (HFR) Corridor -$86,571 and the Highway Access Management Plan (HAMP) Study -$381,560 (HFR and HAMP costs are shared between the City, Ministry of Transportation and third- party contributors), consulting for Economic Development and Strategic Projects -$90,000 and consulting for naming rights and other partnerships - $50,000, partially offset by the completion of 2023 assignments related to the Corporate Strategic Plan ($75,000). $20,000 Increase is due to business development costs transferred from City Development related to the creative industries function. ($12,500) Decrease is attributed to the completion of the Customer Relationship Management project. $13,700 Total Expenditures $798,776 Revenues -(Increase)/ Decrease Federal Grants ($15,000) Increase reflects an increase in the 2024 CanExport Community Initiatives grant of $19,200, partially offset by a decrease due to one-time 2023 summer jobs grant of $4,200. 38 Economic Development & Strategic Projects Department Account Ontario Grants • Licenses & Permits Cost Recoveries Total Revenues Change • Explanation ($105 246) , Increase attributed to new funding from the Ministry of ' Transportation for HAMP study of ($125,500) in 2024 partially offset by completed 2023 grants. ($380,250) Increase reflects film revenues transferred from City Development as the function was moved under Economic Development in 2023. ($233,044) • Increase primarily due to new funding from the Seaton Landowners Group funding for the HAMP study. ($733,540) Transfers -(Increase)/ Decrease Continuing Studies Reserve Rate Stabilization Reserve Total Transfers Net Increase ($97,297) Increase due to HFR and HAMP studies started in 2023 and carried over to 2024 to be completed. ($14,457) Increase reflects Rate Stabilization reserve funding for the HFR study. ($111,754) ($46,518) 39 Economic Development & Strategic Projects Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2021 2022 2023 Business Inquiries 1,300+ 500+ 500+ (Covid related) (Covid related) Investment Inquiries (including lead 100+ 50 70 generation from domestic and international conferences/tradeshows and trade missions) Social Media -Impressions N/A 20,016 66,111 Impressions Impressions (Linked in) (Linkedin) 29,529 31,654 Impressions Impressions (Twitter) (Twitter/X) Social Media -Content Posted 1 N/A N/A 220 Posts (Linked in) 200 Posts (Twitter/X) Social Media -Follower Growth 1 N/A N/A 101 % Increase (Linked in) 6% Increase (Twitter/X) Development Projects N/A 12 14 New Business Grand Openings 8 18 17 Business Events 1 N/A N/A 40 Site Visit Program N/A N/A Mayor Site Visit Program: 11 BACD Small Business Visit: 55 Kingston Road Corridor Outreach: 250 40 Economic Development & Strategic Projects Department Performance Indicators/Statistics 2021 2022 2023 Participation in domestic and NIA NIA 12 International Conferences, tradeshows and development related trade missions 1,2 Film Location Permits lssued 3 24 -$6,000 29 -$7,250 25 -$9,000 (# & revenue) Filming in Parks/Facilities/Pickering 7 -$14,000 5 -$9,555 4 -$3,050 Museum Village 3 (# & revenue) Film Permit enquiries -no permit 10 7 4 issued 3 Film Backlot Lease (revenue)3 $240,000 $360,000 $367,200 Estimated Revenue from all Film $260,000 $376,805 $379,250 Activities 3 1 In 2023 new metrics were introduced as part of the Economic Development Strategy (approved by Council). Results are reported beginning in 2023. Where prior year's comparative indicators are not available they are identified as NIA. 2 In 2023, Economic Development & Strategic Projects staff participated in select industry-focused tradeshows and conferences that were aligned with the Council- approved Economic Development and Foreign Direct Investment Strategy and Analysis (Resolution #939/22). In addition to the target industries identified in the strategy, a key element of investment attraction and growth management for both residential and non-residential projects within the City, staff will focus on building key relationships with leaders from the development industry. Planning and attending trade missions to understand the economic viability of other successful projects in other jurisdictions is a key objective of the City's Economic Development Program, as endorsed by Council. The leads generated from the 2023 tradeshows, conferences and trade missions are noted within the above table. It is also important to note that, in addition to staff, elected officials' participation in economic attraction initiatives makes a powerful statement about the City's commitment to developing global partnerships, attracting international investment, and job creation. 3 In 2023 the Film function was transferred from the City Development Department to Economic Development & Strategic Projects Department. These Key Performance Indicators were previously reported in the City Development Department. 41 City of Pickering 2024 Current Budget Summary 10050 Economic Development & Strategic Projects 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures -593,618 Salaries & Wages 643,662 --Overtime 750 -148,005 Employee Benefits 138,805 -5,694 Conferences 15,500 -201 Seminars & Education 4,000 -20,155 Travel 26,500 -4,219 Business Development 20,000 -2,244 Cellular Phones 8,800 -1,453 Telephone & Data 1,700 -184 Internet 130 -4,901 Advertising 14,000 -12,000 Trade Shows.Exhibits & Displays • 20,000 -453 Subscriptions & Publications 775 -1,760 Insurance Premium 1,760 -42,218 Consulting & Professional Fees 150,000 -37,077 Meals, Promotions & General 68,000 -3,962 Memberships 10,575 -21,324 Outside Agency Services 23,350 -2,516 Stationary & Office Supplies 3,000 -148 Supplies & Tools - --Software & Hardware Mtce. Contracts 7,775 -34 Website Support - -12,211 System & Software Upgrade 12,500 -914,377 Total Expenditures 1,171,582 Revenues -(15,484) Federal Grants (25,000) --Ontario Grants (27,500) -(63,950) Licences & Permits - -(6,500) Marketing Sponsors (30,000) -(137,468) Cost Recoveries (119 ,750) -(223,402) Total Revenues (202,250) Transfers --Transfer to(from) Cntg Sty Res . - --Transfer to(from) Reserve (114,435) 42 Run Date : Jan 25, 2024 Increase I 2024 % Change Decrease Budget From 2023 180,227 823,889 28.00% -750 -% 50,218 189,023 36.18% 4,500 20,000 29.03% -4,000 -% 5,000 31,500 18 .87% -20,000 -% 1,600 10,400 18.18% 1,200 2,900 70 .59% -130 -% 14,000 28,000 100.00% -20,000 -% -775 -% 265 2,025 15 .06% 533,131 683,131 355.42% 20,000 88,000 29.41% (1 ,300) 9,275 (12.29%) 2,300 25,650 9 .85% -3,000 -% ---% 135 7,910 1.74% ---% (12,500) -(100.00%) 798,776 1,970,358 68.18% (15,000) (40,000) 60 .00% (105 ,246) (132,746) 382 .71% (380,250) (380,250) -% -(30,000) -% (233 ,044) (352,794) 194.61% (733,540) (935,790) 362.69% (97,297) (97 ,297) -% (14,457) (128,892) 12 .63% City of Pickering 2024 Current Budget Summary 10050 Economic Development & Strategic Projects 2022 2023 2023 Actuals YTD Account Description Budget Actuals --Total Transfers (114,435) -690,975 Net Expenditures (Revenues) 854,897 43 Run Date : Jan 25, 2024 Increase/ 2024 % Change Decrease Budget From 2023 (111,754) (226,189) 97.66% (46,518) 808,379 (5.44%1 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 ■ Office of Affordability • Sustainability " City Development Department I I I I ,r '\ r " r Planning & Design * Planning & Design Building Services Sustainability Policy & Geomatics Zoning & Administration '-,) '-~ '- Office of Affordability * Includes Committee of Adjustment (consents and minor variances), Heritage Pickering Advisory Committee, and Site Plan Review Panel 44 City Development Department Key Activities for 2024 in Support of the Corporate Strategic Plan Corporate Key: Good Governance & Customer Service Excellence • Maintain a high-quality level of service to process the growing volume of building permit applications, while ensuring compliance with the Ontario Building Code. • Complete the Streamlining the Development Application Review Process study. • Implement a review and approval process for land division responsibilities, downloaded from the Region of Durham. Priority 3: Advance Innovation & Responsible Planning to Support a Connected, Well-Serviced Community • Initiate Growth Management and Employment Lands Studies to help inform the Official Plan Review. • Complete the Retail Market Study. • Further implement housing initiatives within the Office of Affordability that would: (a) work collaboratively with local developers and the Region of Durham on affordable housing solutions for Pickering; and (b) be responsible for the City's housing policy portfolio, including updates and revisions to the City's Housing Strategy and Action Plan; the Annual Housing Monitoring Report Strategic Growth Areas Monitoring Report and 20-year Detailed Population Forecast Report; and responding to Provincial housing initiatives. • Subject to securing grant funding from the Federal Government's Housing Accelerator Fund (HAF), undertake the following initiatives: o Commence a Community Improvement Plan (CIP) program for Affordable and Purpose-built Rental Development; o Commence a City-initiated Zoning By-law Amendment for the Kingston Road Corridor and Brock Node; o Commence a Surplus Land Disposition & land Acquisition Strategy; o Commence a City-initiated Official Plan Amendment and Zoning By-law Amendment for Protected Major Transportation Areas study; o Commence a City-wide Parking Study; o Commence an Additional Dwelling Unit Education Program & Implementation Strategy; and o Commence a scoped Housing & lnclusionary Zoning Study. • Pursue Part IV designation under the Ontario Heritage Act for key cultural heritage properties. • 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, as well as other major developments and intensification in the City. 45 City Development Department Priority 3 (continued) • Continue the community planning process for Northeast Pickering (in conjunction with the Department of Economic Development & Strategic Projects). • Prepare for the Ontario Land Tribunal hearings on the following matters: o Amendment 38 to the Pickering Official Plan for the Kingston Road and Brock Node Intensification Area; and o Amendment 46 to the Pickering Official Plan for changes to the Development Review procedures. • Continue to work with IT to further implement various municipal services within myPickering (PRISM), the City's digital portal. • 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. Priority 4: Lead & Advocate for Environmental Stewardship, Innovation & Resiliency • Complete the Community Climate Adaptation Plan. • Complete a Measuring Sustainability Report. • Promote sustainable development through the coordination of a Sustainable Community-Building Series for those involved in the development sector. Priority 5: Strengthen Existing and Building New Partnerships • Undertake initiatives that support Urban Agriculture. Priority 6: Foster an Engaged & Informed Community • Inform the community of the transfer of land division responsibilities from the Region of Durham to the City of Pickering. • Facilitate community educational and engaging events/workshops related to sustainability matters. 46 Financial Information City Development Department Staffing Summary (Full & Regular Part-Time) Prior Term of Council Current Term of Council 2019 2020 2021 2022 2023 2024 Approved Add Remove/ Total Transfer Full-Time 51 51 51 50 64 -(4) 60 Reg. Part-Time -------- Total 51 51 51 50 64 -(4) 60 In accordance with the Council-approved Corporate GIS Strategic Plan, two full-time positions (Supervisor, Geomatics and Senior Geomatics Analyst) were transferred to the Corporate Services Department. In accordance with Mayoral Direction 01-2024, the full-time Senior Planner, Housing position, was converted to a Temporary Non-Union (contract) position for one-year. In 2024, the department is proposing to recruit two planning interns (effective June 1st), subject to grant funding from the Housing Accelerator Fund. In addition, the department is seeking to convert a Planner II position to a Senior Planner position effective April 1st . Lastly, the department eliminated a full-time Planner II, Site Planning position, effective January 1st given that Principal Planner, Development Review will be involved in reviewing Site Plans and other development applications. Year-Over-Year (Net Cost) Budget Changes Year-Over-Year 2023 2024 Change Budget Budget ($) (%) City Development-Adm. $870,573 $879,618 $9,045 1.04% Planning 1,101,505 1,537,762 436,257 39.61% Building Services (1,671,225) (1,845,856) (174,601) (10.45%) Sustainability 642,585 632,280 (10,305) (1.60%) Committee of Adjustment 11,778 12,244 466 3.96% Heritage Pickering 17,525 18,525 1,000 5.71% Total (Net Cost) $972,711 $1,234,573 $261,862 26.92% 47 City Development Department Explanation of Significant Departmental Budget Changes Account Change ' Explanation Expenditures -Increase/ (Decrease) ! Salaries & Wages Employee Benefits . Advertising Consulting & • Professional Services Outside Agency : Services Software & Hardware Maintenance Contracts Misc. Equipment Financial Service : Charges : Other Expenses Total Expenditures $192,670 $38,794 ($10,000) $1,035,793 Salary and wage increase is primarily due to annualization of positions approved in 2023 partially offset by reductions related to positions transferred to other departments. Increase is due to benefit costs related to the annualization of positions approved in 2023 as noted above, partially offset by reductions related to positions transferred to other departments. Additional impacts include the increase in statutory benefits costs due to enhanced CPP rates and inflationary increases in group health benefit costs. Decrease relates to budgeted funds for digital film advertising transferred to the Economic Development department. Increase is primarily due to a number of studies, subject to securing Housing Accelerator Fund (HAF) and Natural Resources Canada (NRCan) grants, planned for 2024 -$800,000. These projects will only proceed if the related grant funding is approved. In addition, some studies were approved in late 2023 and are carried over to 2024, including consulting for the development application processing process review -$218,447 and various background studies related to the Official Plan -$74,030. $13,200 Increase largely reflects design and editorial work supporting various sustainability projects. ($82,485) Decrease is due to the move from installation of certain software to annual maintenance. ($10,000) Decrease is attributed to one-time purchases for computers and related equipment for new staff completed in 2023. $85,000 Increase is related to new credit card processing fees. These fees will be fully recovered from customers choosing to pay by credit card. $15,828 $1,278,800 48 Account Rate Stabilization Reserve . Seaton Development ' Reserve Cherrywood Reserve Third Party Obligations Reserve Total Transfers Net Increase City Development Department Change : Explanation ($168,500) • Increase reflects funding for the consolidated zoning ! by-law review, plus transitional funding for the revenue shortfall caused by Bill 109 and the ' implementation of a 2-stage collection of planning application fees for site plan and zoning by-law amendments. $30,000 Decrease is attributed to the completion of the Waterfront & Nautical Village Visioning exercise in 2023. $43,630 This reserve was closed due to legislative changes in 2024. ($10,000) Increase reflects external funding for new aquatic planting initiative that will be undertaken by the Sustainability section. , ($596,804) $261,862 50 City Development Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2021 2022 2023 Building Services Permits Issued 1,297 1,699 1,934 Number of Inspections 11,490 13,657 16,244 Number of Investigations 1 165 201 203 Planning Applications P&D Committee & Council (official plan, zoning, subdivision and condominium 24 22 24 plans 2 ) Committee of Adjustment 113 132 49 Site Plan Review Panel 29 22 28 Heritage Committee/Delegated 7 2 5 Comments Policy initiatives of others 12 9 5 Land Divisions 28 31 15 Pre-consultations 35 28 42 Requests Geomatics Requests (e.g., mapping, addressing, program queries and 438 479 391 updates, open data portals) Legal & Vehicle Compliance Letters 190 143 165 Zoning Information Requests N/A 187 154 Site Plan Approvals Issued 8 19 6 Special Studies, Projects, Reviews 9 10 11 Underway Reports Information 19 11 14 Recommendation/Planning 48 49 42 51 City Development Department Performance Indicators/Statistics 2021 Sustainability Sustainable Pickering Initiatives -Workshops/Events 5 (386 participants) -Trees and Shrubs Planted 1,360 -Pollinator Plants Planted 500 -Farmers Market 3 2,400 attendees -Virtual Farmers Market4 9,874 website views Waste Reduction & Diversion -Dog Waste 9.0 tonnes -Batteries 372 kilograms 1 Some existing investigations carry over from previous years 2 Based on applications received during the year 2022 2023 11 17 (2,124 participants) (1,016 participants) 1,569 1,031 535 214 2,600 2,600 attendees attendees 10,114 11,149 website views website views 7.0 tonnes 6.6 tonnes 254 kilograms 299 kilograms 3 On a number of occasions, the i="armers Market was shut down early due to inclement weather 4 Starting in 2024, the data for the Farmers Market will be updated to reflect the changing function of the Virtual Farmers Market (post COVID) 52 City of Pickering 2024 Current Budget Summary City Development Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals -- Revenues --Federal Grants - (96,958) -Ontario Grants (387,630) (92,495) -Other Agency Grants - (1,995,023) (2,903,381) Department User Fees (2,675,100) (9,819) (12,044) Event Vendor Fees (12,250) (1,365) (1,155) Other User Fees - (4,099,440) (6,258,173) Licences & Permits (4,480,250) (2,025) -Fines & Charges - (4,884) -Donations (3,000) --Sponsorships - -(3,720) Sustainability Sponsorships (2,000) --Marketing Sponsors - --Sustain Mkt Sponsors (2,000) --Other Contributions - (42,704) (218,985) Cost Recoveries (558,000) (6,344,713) (9,397,458) Total Revenues (8,120,230) Transfers (86,856) -Transfer to/(from) DC Oblg RF (276,705) (122,403) -Transfer to(from) Cntg Sty Res . (25,300) --Transfer to(from) Reserve (317,535) (15,999) -Transfer to (from) Oblig RF (25,000) (225,258) -Total Transfers (644,540) 320,565 (1,791,708) Net Expenditures (Revenues) 972,711 54 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Budget From2023 (1,049,030) (1,049,030) -% 387,630 -(100 .00%) (20,000) (20,000) -% 218,625 (2,456,475) (8.17%) (1,750) (14,000) 14 .29% ---% (69,750) (4,550,000) 1.56% ---% -(3,000) -% (7,000) (7,000) -% 2,000 -(100.00%) (5,000) (5,000) -% 2,000 -(100.00%) (10 ,000) (10,000) -% 132,141 (425 ,859) (23.68%) (420,134) (8,540,364) 5.17% (164,105) (440,810) 59 .31% (327,829) (353,129) 1,295 .77% (94,870) (412,405) 29.88% (10,000) (35,000) 40.00% (596,804) (1,241,344) 92 .59% 261,862 1,234,573 26.92% City of Pickering 2024 Current Budget Summary 10105 Planning & Design 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 2,235,031 2,611,880 Salaries & Wages 2,803,716 17,338 32 ,560 Overtime 32,750 560,067 698,042 Employee Benefits 721,673 464 214 Uniforms 1,000 850 7,351 Conferences 9 ,000 3,022 6,049 Seminars & Education 13,450 572 1,015 Travel 2,950 2,551 1,606 Cellular Phones 4,000 6,417 7,900 Telephone & Data 9,100 838 1,003 Internet 835 -794 Advertising 18,000 -6,682 Subscriptions & Publications 5,000 141 188 Photo, Mapping, Print 2,000 13,410 14 ,751 Insurance Premium 14,751 --Insurance Deductible 1,000 381,633 399,988 Consulting & Professional Fees 1,551,160 17 19,059 Meals, Promotions & General 20,850 14,338 12,850 Memberships 17,330 -1,590 Outside Agency Services 2 ,500 --Building Rentals 300 4,880 7,174 Stationary & Office Supplies 9,600 --Supplies & Tools 300 3,229 -Software & Hardware Mtce. Contracts 7,260 --Misc. Equipment 10,000 3,244,798 3,830,696 Total Expenditures 5,258,525 Revenues (91,079) -Ontario Grants (244,630) (1,945 ,250) (2 ,639,339) Department User Fees (2,453,600) (367,500) (281,650) Licences & Permits (380,250) (42 ,704) (218 ,985) Cost Recoveries (459,000) (2,446,533) (3,139,974) Total Revenues (3,537,480) Transfers (86,856) -Transfer to/(from) DC Oblg RF (276,705) (101,907) -Transfer to(from) Cntg Sty Res . (25,300) 56 Run Date : Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 . (224,531) 2 ,579,185 (8.01%) (7 ,250) 25,500 (22 .14%) (44,136) 677,537 (6 .12%) (400) 600 (40.00%) 2,000 11,000 22 .22% 13,425 26 ,875 99 .81% -2,950 - % (2,000) 2,000 (50 .00%) 800 9 ,900 8 .79% -835 - % (10 ,000) 8,000 (55 .56%) (500) 4,500 (10.00%) (1,000) 1,000 (50 .00%) 2 ,214 16,965 15.01% 150 1,150 15.00% 31,103 1,582,263 2.01% (18 ,500) 2,350 (88.73%) (2,590) 14,740 (14.95%) (2,000) 500 (80 .00%) -300 - % (1,100) 8,500 (11.46%) (100) 200 (33.33%) (4,190) 3,070 (57 .71%) (10,000) -(100 .00%) (278,605) 4,979,920 (5.30%) 244,630 -(100 .00%) 453,705 (1,999,895) (18.49%) 380,250 -(100 .00%) 137,641 (321,359) (29 .99%) 1,216,226 (2,321,254) (34.38%) (164 ,105) (440,810) 59 .31% (242,389) (267,689) 958 .06% City of Pickering 2024 Current Budget Summary 10105 Planning & Design 2022 2023 2023 Actuals YTD Account Description Budget Actuals --Transfer to(from) Reserve (317 ,535) (5,381) -Transfer to (from) Oblig RF - (194,144) -Total Transfers (619 ,540) 604,121 690 ,722 Net Expenditures (Revenues) 1,101,505 57 Run Date : Jan 25, 2024 Increas e / 2024 %Change Decrease Budget From2023 (94,870) (412,405) 29 .88% ---% (501,364) (1,120,904) 80.93% 436,257 1,537,762 39.61% City of Pickering 2024 Current Budget Summary 10105 -9755 Office of Affordability 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures --Salaries & Wages 24,200 --Employee Benefits 7,240 --Consulting & Professional Fees - --Total Expenditures 31,440 Revenues --Federal Grants - --Department User Fees - --Total Revenues - Transfers - - Total Transfers - --Net Expenditures (Revenues) 31,440 58 Run Date : Jan 25, 2024 Increase I 2024 %Change Decrease Budget From2023 .... 134,000 158,200 553 .72% 8,580 15,820 118 .51% 800,000 800,000 -% 942,580 974,020 2,998.03% (865,780) (865,780) -% (108,240) (108 ,240) -% (974,020) (974,020) -% ---% (31,440) -(100.00%) City of Pickering 2024 Current Budget Summary 10110 Building Services 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 1,632,338 1,683,201 Salaries & Wages 1,760,020 13,148 17,769 Overtime 10,000 443,101 490,878 Employee Benefits 503,253 653 1,174 Uniforms 4,000 3,823 8,991 Conferences 9,900 10,750 18,454 Seminars & Education 30,300 15,162 13,546 Travel 22,600 4,586 8,656 Cellular Phones 9,100 6,417 6,145 Telephone & Data 7,100 838 780 Internet 835 3,369 1,856 Subscriptions & Publications 4,000 7,520 8,272 Insurance Premium 8,272 2,743 1,942 Insurance Deductible 3,000 53,856 17,484 Consulting & Professional Fees 95,000 187 7,886 Meals, Promotions & General 5,900 12,241 11,961 Memberships 19,355 1,029 -Building -Repairs & Maintenance - 803 1,114 Vehicle -Repairs & Maintenance 2,000 -202 Gas, Oil, Tire, Etc. 3,000 1,682 4,795 Stationary & Office Supplies 8,000 265 285 Forms 9,000 231 404 Supplies & Tools 2,000 16,202 15,116 Software & Hardware Mtce . Contracts 47,110 -5,399 Hardware Replacements - --Financial Services Charges - 2,230,944 2,326,310 Total Expenditures 2,563,745 Revenues (30,968) (33,997) Department User Fees (40,000) (3,731,940) (5,976,523) Licences & Permits (4 ,100,000) (2,025) -Fines & Charges - --Cost Recoveries (95,000) (3,764,933) (6,010,520) Total Revenues (4,235,000) Transfers (20,496) -Transfer to(from) Cntg Sty Res . - 59 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 205,410 1,965,430 11.67% -10,000 -% 52,401 555,654 10.41% -4,000 -% 800 10,700 8 .08% (4,100) 26,200 (13.53%) -22,600 -% 550 9,650 6 .04% 200 7,300 2.82% -835 -% -4,000 -% 1,248 9,520 15 .09% 450 3,450 15.00% 70,000 165,000 73.68% -5,900 -% (650) 18,705 (3 .36%) ---% -2,000 -% (2,000) 1,000 (66.67%) -8,000 -% (4,000) 5,000 (44.44%) -2,000 -% (44,910) 2,200 (95 .33%) ---% 85,000 85,000 -% 360,399 2,924,144 14.06% (85,000) (125,000) 212.50% (450,000) {4,550,000) 10 :98% ---% -(95,000) -% (535,000) (4,770,000) 12.63% ---% 10110 Building Services 2022 2023 City of Pickering 2024 Current Budget Summary 2023 Actuals YTD Account Description Budget Actuals (20,496) -Total Transfers - (1,554,485) (3,684,210) Net Expenditures (Revenues) (1,671,255) 60 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 --- % (174,601) (1,845,856) 10.45% 10115 Sustainability 2022 2023 Actuals YTD Actuals 370,161 254,641 2,051 790 77,122 74,749 214 315 1,287 3,919 -2,277 66 180 1,594 1,311 1,170 1,464 153 186 5,704 2,913 1,386 5,624 -- -- 3,020 3,322 107,788 10,657 1,419 1,873 2,762 3,406 4 ,868 4,631 465 1,732 102,450 111 ,053 470 - 684,150 485,043 -- (5,879) - (92,495) - -(228 ,326) (9,819) (12,044) (1,365) (1,155) (4,884) - -- -(3,720) -- -- City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries &·wages 429,490 Overtime 2,000 Employee Benefits 124,883 Uniforms 450 Conferences 5 ,000 Seminars & Education 8,000 Travel 1,000 Cellular Phones 2,900 Telephone & Data 1,700 Internet 190 Advertising 9 ,750 Trade Shows.Exhibits & Displays 3,000 Subscriptions & Publications 400 Photo, Mapping, Print 2,800 Insurance Premium 3,322 Consulting & Professional Fees 101,000 Meals, Promotions & General 11,000 Memberships 3,885 Outside Agency Services 10,300 Stationary & Office Supplies 2,000 Programs & Event Supplies 146,750 Software & Hardware Mtce. Contracts 515 Total Expenditures 870,335 Revenues Federal Grants - Ontario Grants - Other Agency Grants - Department User Fees (179,500) Event Vendor Fees (12,250) other User Fees - Donations (3,000) Sponsorships - Sustainability Sponsorships (2,000) Marketing Sponsors - Sustain Mkt Sponsors (2,000) 61 Run Date : Jan 25, 2024 Increase I 2024 %Change Decrease Budget From2023 40,804 470 ,294 9.50% -2,000 -% 8,618 133,501 6 .90% -450 -% 2,500 7 ,500 50 .00% -8,000 -% (250) 750 (25 .00%) -2,900 -% (100) 1,600 (5 .88%) -190 -% -9 ,750 -% -3,000 -% -400 -% -2 ,800 -% 498 3,820 14 .99% 262,690 363,690 260 .09% 18,500 29,500 168 .18% -3,885 -% 15,200 25,500 147 .57% -2,000 -% 7,000 153,750 4 .77% 15 530 2.91% 355,475 1,225,810 40.84% (183,250) (183,250) -% ---% (20,000) (20 ,000) -% (41,840) (221,340) 23.31% (1,750) (14,000) 14.29% ---% -(3,000) -% (7,000) (7,000) -% 2 ,000 -(100 .00%) (5,000) (5,000) -% 2,000 -(100 .00%) 10115 Sustainability 2022 2023 Actuals YTD Actuals -- -- (114,442) (245,245) -- (10 ,618) - (10,618) - 559,090 239,798 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Other Contributions - Cost Recoveries (4,000) Total Revenues (202,750) Transfers Transfer to(from) Cntg Sty Res . - Transfer to (from) Oblig RF (25,000) Total Transfers (25,000) Net Expenditures (Revenues) 642,585 62 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 (10,000) (10,000) -% (5,500) (9,500) 137.50% (270,340) (473,090) 133.34% (85,440) (85 ,440) -% (10,000) (35,000) 40 .00% (95,440) (120,440) 381.76% (10,305) 632,280 (1.60%) City of Pickering 2024 Current Budget Summary 10120 Committee of Adjustment 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 5,760 8,570 Salaries & Wages 8,400 438 785 Employee Benefits 508 --Conferences 1,000 -310 Seminars & Education 300 124 743 Travel 820 675 750 Memberships 750 6,997 11,158 Total Expenditures 11,778 Revenues --Total Revenues - Transfers - - Total Transfers - 6,997 11,158 Net Expenditures (Revenues) 11,778 63 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 120 8 ,520 1.43% 136 644 26 .77% 100 1,100 10.00% 100 400 33 .33% 10 830 1.22% -750 -% 466 12,244 3.96% ---% --- % 466 12,244 3.96% City of Pickering 2024 Current Budget Summary 10125 Heritage Pickering 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 483 -Conferences 525 --Seminars & Education 300 193 -Travel 500 --Photo, Mapping, Print 250 5,024 6 ,165 Consulting & Professional Fees 15,000 31 -Meals, Promotions & General 200 --Memberships 100 --Stationary & Office Supplies 150 399 -Gift Shop/Plaques 500 6,130 6,165 Total Expenditures 17,525 Revenues --Total Revenues - Transfers --Total Transfers - 6,130 6,165 Net Expenditures (Revenues) 17,525 64 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 -525 -% -300 -% -500 -% -250 -% (5,000) 10,000 (33.33%) -200 -% -100 -% -150 -% 6,000 6,500 1,200 .00% 1,000 18,525 5.71% --- % --- % 1,000 18,525 5.71% 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. I r ' r Recreation Community Services Department Culture, Recreation & Facilities ' r "I r Cultural Aquatics, Facilities Courts I ' r Community Services "I Services Services & Fitness Maintenance Administration ' ' ~ ' / ' / 65 Community Services Department Key Activities for 2024 in Support of the Corporate Strategic Plan Corporate Key: Good Governance & Customer Service Excellence • Further diversify revenue sources to reduce reliance on property taxes with an anticipated $8,523,057 in earned revenue in 2024. • Promote service modernization by using technology to advantage by purchasing a new staff scheduling software, implementing a new volunteer management software, and launching a new digital exhibit featuring bespoke digital elements at the Pickering Museum Village. • Monitor customer service standards with a view to advancing continuous improvement. Community consultation will inform design of the Seaton Recreation Complex to ensure the design is equitable, accessible and inclusive of all community members. • Complete the User Fee Study and update the Access to Recreation Policy to ensure that City services and programs are equitable, accessible and inclusive for all community members. Priority 1: Champion Economic Leadership and Innovation • In partnership with the Economic Development & Strategic Projects department, encourage and support tourism as an economic driver by launching and implementing Pickering's first Community Visitors Plan. • Encourage the arts as an economic driver and an essential part of the fabric of a complete, world class City. • Lead over 40 community events, engage more than 30 artists and launch a new permanent exhibit at the Pickering Museum Village from a Black-settler perspective. Priority 2: Advocate for an Inclusive, Welcoming, Safe & Healthy Community • Advance the City's first Community Safety & Well-Being Plan (subject to Council approval). This includes enhancing community safety through direct service and program delivery and continuing to support the Region of Durham in its efforts to lead the implementation of the Region's Community Safety & Well-Being Plan (subject to Council approval) . • Support community members with diverse needs, including those who are experiencing poverty and homelessness with the Community Safety & Well- Being Homelessness Task Force, that will be formed in 2024. • Support ongoing initiatives including wellness checks for those residents experiencing homelessness. 66 Community Services Department Priority 2 (continued) • Expand the delivery of municipal services, programs, and infrastructure to meet the needs of the current and future population, including expansion to Rick Johnson Memorial Park, Seaton. Programs will also be extended at Dr. Nelson Tomlinson Community Centre, Maple Ridge Public School and Valley Farm Public School. • Explore options to expand Pickleball in temporary program spaces, until the Seaton Recreation Complex is completed. • Implement the City's Public Art Plan with new permanent public art at Pickering's Waterfront, a new permanent artwork in celebration of Gordon Lightfoot at Ernie L. Stroud Park, a new permanent artwork at the corner of Highway 2 and Whites Road, and consultation and planning for a new artwork by artist Dorsey James in Council Chambers. Eight temporary artworks are also planned for 2024. • Launch new permanent exhibit at the Pickering Museum Village featuring Pickering's black history. The Redman House ( c. 1851) will undergo restoration in 2024. Priority 3: Advance Innovation & Responsible Planning to Support a Connected, Well-Serviced Community • Lead updates to the Recreation & Parks Master Plan that will identify opportunities to enhance recreational infrastructure and programs to meet the needs of Pickering's increasingly diverse and growing population. The Recreation & Parks Master Plan will be completed in 2024 (subject to Council's approval). • Lead the renewal of the Cultural Strategic Plan in 2024. • Lead community consultation for the design of the future Seaton Recreation Complex (subject to Council approval). Priority 5: Strengthen Existing and Building New Partnerships • Work with the advisory committees to advance City priorities including leading the Cultural Advisory Committee, the Accessibility Advisory Committee, the Community Safety & Well-Being Advisory Committee, the Pac4Teens Activity Council and the 55+ Committee. Priority 6: Foster an Engaged & Informed Community • Measure and report on community engagement progress. 67 Financial Information Community Services Department Staffing Summary (Full & Regular Part-Time) Prior Term of Council Current Term of Council 2019 2020 2021 2022 2023 2024 Approved Add Delete Total Full-Time 71 75 76 71 77 4 -81.0 Reg. Part-Time 52 49 49 48 44 1 (3.5) 41.5 Total 123 124 125 119 121 5 (3.5) 122.5 * The above chart excludes contract, students and term employees The department is proposing the following staffing changes in 2024: • Two new full-time Facility Operator positions for East Shore and George Ashe Community Centres to support better facility maintenance coverage during peak program times. • Conversion of one part-time Volunteer Coordinator position to full-time to meet growing demands of the City's volunteer program. • Conversion of one Term Graphic Designer position to part-time. • One new full-time Supervisor, Pickering Museum Village to meet the operational needs of the museum, utilizing funding from reclassification of existing positions. vacancies and redundancies. • Conversion of two full-time Facility Attendant positions to Facility Operator positions to support better facility maintenance coverage during peak program times. 68 Community Services Department Year-Over-Year (Net Cost) Budget Changes Year-Over-Year 2023 2024 Change Budget Budget ($) (%) Culture & Recreation -Admin. $3,302,896 $2,812,539 ($490,357) (14.85%) Programs 725,533 (40,057) (765,590) (105.52%) Cultural Services* 1,148,495 1,148,495 Dunbarton Pool 403,764 454,080 50,316 12.46% Don Beer Arena 442,699 730,382 287,683 64.98% Community Centres 692,791 958,039 265,248 38.29% Recreation Complex -Central 2,587,240 2,567,460 (19,780) (0.76%) Core Recreation Complex -Pool 708,808 675,761 (33,047) (4.66%) Recreation Complex -Arenas 302,323 298,166 (4,157) (1.38%) Civic Centre 875,338 872,400 (2,938) (0.34%) Senior Citizens Centre 406,299 395,130 (11,169) (2.75%) Museum 884,899 933,678 48,779 5.51% Total (Net Cost) $11,332,590 $11,806,073 $473,483 4.18% * In 2024 a new Cultural Services cost centre was created to better reflect the structure of the department. As a result, certain revenues and expenditures previously included in the Culture & Recreation -Adm in and Programs costs centres have been transferred to Cultural Services. 69 Account Meals / Promo / General Outside Agency Services Building Repairs & Maintenance Building Rentals Program & Event Supplies Committee Expenses Supplies & Tools 1 Utilities -Hydro Utilities -Gas i Software & Hardware Maintenance Contracts Furniture & Fixtures Other Expenses Total Expenditures Community Services Department J Change \ Explanation $13,000 Increase mainly due to the transfer of the corporate refreshment program budgeted funds from the General Government cost centre to Community Services in 2024. $87,978 1 Increase primarily due to expansion of the summer i camp bussing program to new locations in 2024. This : expense is offset by additional program revenues. • $48,485 Increase driven by the rising cost of maintaining aging facilities infrastructure as well as contract pricing increases for building services such as waste disposal and snow removal. $191,345 Increase attributed to the cost for the satellite facility : lease, additional facility maintenance costs and technology connectivity costs budgeted in the Civic • Centre cost centre. $102,009 Increase related to planned expansion of recreation programs and community events in 2024. $27,000 Increase largely attributed to the implementation of the new Community Safety & Well-Being Plan (subject to Council approval). $20,939 Increase related to planned expansion of recreation programs and replacement of tools. $10,000 is budgeted to replace or purchase supplies and equipment to expand programming at Dr. Nelson F. Tomlinson Community Centre. Additional funds are also required across other facilities to support first-aid and programming needs. $22,098 Increase reflects last year's consumption trends and anticipated price increase in 2024. $31,785 Increase reflects last year's consumption trends and anticipated price increase in 2024. $12,853 1 Increase includes pricing increases as well as cost of • new staff scheduling software and maintenance of . digital exhibit enhancements at the museum. $15,420 Increase mainly due to $10,000 for table and chair replacement at Dr. Nelson F. Tomlinson Community Centre and $5,600 for a pool vacuum replacement at the Chestnut Hill Developments Recreation Complex. $9,262: $1,008,938 71 Community Services Department Department Performance Indicators/Statistics Performance Indicators/Statistics 1 2021 2022 2023 Cultural Services Destination Pickering Social Media 15,185 63,590 63,663 EnQaQement (likes, shares, comments) Live Event Attendance (Events, Partner 22,000 41,965 75,097 Events, Cultural Pop-ups) Recreation Services ProQrams offered 283 1,104 1,195 ReQistered participants 3,464 8,134 12,067 Aquatics ProQrams offered 19 1,345 1,829 ReQistered participants 120 5,703 8,586 Swim members 177 321 510 Available public swim hours 1,071 3,749 3,753 Available rental hours 810 1,219 803 Individual swim admission purchases 153 9,873 12,246 Fitness Group fitness reQistered proQrams offered 193 161 479 Group fitness reQistered participants 468 679 1501 Small Qroup traininQ proQrams offered 77 40 83 Small Qroup traininQ participants 101 206 271 Personal traininQ packaQes sold 12 94 141 Personal fitness members 181 245 325 Health Club Health Club Members 669 1,531 2,030 Available hours 2,740 4,532 5,367 Individual admissions purchased 62 422 776 Racquet Sports Squash Members 78 175 167 Racquetball Members 12 29 29 Tennis Members 76 105 117 Golden/Combination Members 40 57 58 Number of available hours Tennis 5,200 19,096 21,468 Squash & Racquetball 20,720 47,740 57,268 Pickleball 2 N/A N/A 2,892 74 Community Services Department Performance lndicators/Statistics 1 2021 2022 Number of guests Tennis 786 3,330 Squash 479 3,974 Racquetball 58 1,005 Pickleball 2 N/A N/A Number of courts booked Tennis 3,800 9,990 Squash 1,125 6,730 Racquetball 149 2,011 Pickering Museum Village Museum visitors and program participants 9,248 10,515 Facilities Operations -Arena CHDRC total hours of ice rental 2,230 5,980 OBA total hours of ice rental 3,282 10,301 CHO RC total hours of arena floor time rental 98 104 OBA total hours of arena floor time rental 1,155 535 OBA Banquet Hall rental hours 1,003 1,526 O'Brien Meeting Room rental hours 3,124 2,977 1 Volunteers dedicated 3,210.5 hours or $82,762.50 to the Community Services Department in 2023. 2 These Performance Indicators were new in 2023 and prior year comparative information is not available (N/A). Legend: CHDRC -Chestnut Hill Developments Recreation Complex OBA -Don Beer Arena O'Brien Meeting Room -located at the CHDRC 75 2023 11,669 2,506 424 10,506 12,183 9,157 1,041 15,183 8,357 9,746 1,666 3,916 1,513 2,413 City of Pickering 2024 Current Budget Summary Community Services Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 8,208 ,677 8,551,797 Salaries & Wages 9,172,188 807,297 1,143,626 Salaries & Wages -Programs 1,272,620 214,141 231,277 Overtime 199 ,179 1,895,817 2,180,124 Employee Benefits 2,247,039 -872 Employee Recognition • - 36,085 26,857 Uniforms 55,060 4,172 2,560 Conferences 7,465 12,358 22,164 Seminars & Education 54,812 6,747 8,292 Travel 10,600 3,638 6,963 Freight, Express & Cartage 7,500 52 -Environmental Charges - 32,415 31,009 Cellular Phones 36 ,720 70 ,268 70,270 Telephone & Data 79,100 14,614 15,980 Internet 15 ,090 6,509 6,418 Cable TV 6,635 345,140 203,958 Advertising 261,850 151,621 38,995 Trade Shows,Exhibits & Displays 219,500 94 1,719 Subscriptions & Publications 550 • 56,109 24,485 Brochures/Newsletters Printing 67,000 -2,500 Photo, Mapping, Print 9,000 61 ,896 67,892 Insurance Premium 67,892 4,856 5,892 Insurance Deductible 11,000 35,882 109,005 Consulting & Professional Fees 393,387 66,939 10,573 Meals, Promotions & General 30,500 10,446 14,358 Memberships 16,399 237,344 251 ,658 Outside Agency Services 329,462 1,401,821 1,543,499 Building -Repairs & Maintenance 1,735,052 21,991 19 ,068 Vehicle -Repairs & Maintenance 22 ,900 26,501 26,489 Gas, Oil, Tire, Etc . 19,850 34,111 52,871 Misc. Equip. -Repairs & Maintenance 76,675 9,468 6,009 Artefact Repairs & Maintenance 8,700 370 1,712 Grounds Upkeep 2 ,800 214,555 193,492 Building Rentals 250,220 582 -Misc . Equip. Rentals 9,600 40,820 40,440 Land Rentals 99,345 13,698 12,261 Stationary & Office Supplies 14,450 76 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 ,-. 284,587 9,456,775 3 .10% 273,212 . 1,545,832 21.47% 20,000 219 ,179 10.04% 123,691 2,370,730 5 .50% ---% 19,110 74,170 34.71% 1,535 9 ,000 20.56% (12,247) 42,565 (22.34%) 1,300 11,900 12 .26% (3,000) 4,500 (40.00%) ---% (800) 35,920 (2 .18%) (3,820) 75,280 (4 .83%) -15,090 -% -6,635 -% (16,100) 245,750 (6.15%) (121,759) 97,741 (55.47%) -550 -% -67,000 -% (4,000) 5,000 (44.44%) 10,188 78,080 15 .01% 1,650 12 ,650 15.00% (153,918) 239,469 (39.13%) 13,000 43,500 42.62% 5,883 22,282 35.87% 87,978 417,440 26 .70% 48,485 1,783,537 2 .79% (6,000) 16,900 (26 .20%) 6,585 26,435 33 .17% (6,700) 69,975 (8 .74%) -8,700 -% -2,800 -% 191,345 441,565 76.47% -9 ,600 -% -99,345 -% -14,450 -% City of Pickering 2024 Current Budget Summary Community Services Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals --Forms 1,900 610,889 916,786 Programs & Event Supplies 1,155,225 2,296 4,235 Special Event Supplies 95,000 28,012 13,002 Committee Expenses 22,000 31,133 32,293 Supplies & Tools 58,211 114 253 Artefact Purchases 600 3,610 4,287 Gift Shop/Plaques 5,000 120,295 146,821 Utilities -Water 165,370 904,263 1,025,369 Utilities -Hydro 1,116,162 265,494 299,385 Utilities -Natural Gas 289,075 7,067 5,198 Utilities -Oil 6,367 23 ,726 36,439 Software & Hardware Mice . Contracts 69,637 3,863 33,982 Furniture & Fixtures 72,000 8,204 1,301 Misc. Equipment 15,800 3,085 2,584 Miscellaneous Expenses - 156,349 206,983 Financial Services Charges 175,000 7,334 6,000 Memberships - 16,222,768 17,660,003 Total Expenditures 20,057,487 Revenues (729,700) (425,276) Federal Grants (874,350) (329,035) (124,817) Ontario Grants (467,400) (25,167) (43,800) Other Agency Grants (76,000) -(245) Department User Fees (10,000) (11,639) (5,149) Gift Shop (11,600) (763) (8,942) Snack Bar (10,150) (11,484) (18,855) Vending Machines (16,600) (288 ,638) (383 ,981) Admissions (343,858) (1,543) (3,500) Rentals -User Fees (4,600) (1,419,888) (1,722,111) Rentals -Ice Surface (1,709,000) (21 ,509) (66,314) Rentals -Arena Floor (50,000) (210,105) (147 ,057) Rentals -Pool (274,400) (63,323) (105 ,336) Rentals -Meeting Rooms (107,700) (81,425) (131,019) Rentals -Halls (136,000) (79,334) (79,705) Rental -Wellness Clinic (81,000) (125,208) (187,164) Community Ctr. Rentals (183,980) -(14 ,275) Advertising Space (66,000) 77 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 -1,900 -% 102,009 1,257,234 8.83% 3,476 98,476 3.66% 27,000 49,000 122.73% 20,939 79,150 35.97% -600 -% -5,000 -% 2,630 168 ,000 1.59% 22,098 1,138,260 1.98% 31,785 320,860 11 .00% (1,377) 4,990 (21 .63%) 12,853 82,490 18.46% 15,420 87,420 21.42% 4,400 20,200 27 .85% ---% 7,500 182,500 4 .29% ---% 1,008,938 21,066,425 5.03% 630,550 (243,800) (72.12%) 233,524 (233,876) (49 .96%) 6,000 (70,000) (7.89%) -(10,000) -% -(11,600) -% (13,450) (23,600) 132.51% 1,700 (14,900) (10.24%) (2,502) (346,360) 0 .73% (286,000) (290,600) 6 ,217.39% (51,500) (1,760,500) 3 .01% (22,500) (72,500) 45.00% (3,801) (278,201) 1.39% 12,000 (95,700) (11 .14%) (1,000) (137,000) 0.74% (800) (81,800) 0 .99% (6 ,120) (190,100) 3 .33% -(66,000) -% City of Pickering 2024 Current Budget Summary · Community Services Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals (493,141) (968,598) Memberships (792,632) (11,963) (10 ,746) Event Vendor Fees (9,600) (3,658) (6,197) Seniors Event Fees (3,000) (41 ,351) (69,439) Older Adults 55+ Programs (54,000) (1,535,209) (2,301,684) Program Revenue (2,173 ,850) (14,001) (9,962) Museum Programs (15,000) (3,703) (4,493) Child Supervision - (55,773) (89,828) Fitness Testing (50,000) (90,377) (14,957) other User Fees (100 ,500) (3,365) (344) Donations (5,000) (16,900) (15,200) Sponsorships (18,000) (5,500) (18,500) Program Sponsorships (7,000) (5,000) (20,450) Marketing Sponsors (44,500) (13,715) (25,885) Program Mk! Sponsors (40,000) --Other Contributions (50,000) --Cost Recoveries (10,000) (353,648) (315 ,790) Netted Revenue (335,190) (6,046,065) (7,339,619) Total Revenues (8,130,910) Transfers 41,000 -Capital Expenditures - --Transfer to/(from) DC Oblg RF (217,087) 60,506 -Transfer to(from) Cntg Sty Res . - 62,843 75,000 Transfer to(from) Reserve (376,900) (290) -Transfer to (from) Oblig RF - 164,059 75,000 Total Transfers (593,987) 10,340,762 10,395,384 Net Expenditures (Revenues) 11,332,590 78 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 (71,868) (864,500) 9.07% (5,000) (14,600) 52 .08% (850) (3 ,850) 28 .33% (38 ,918) (92,918) 72.07% (844,738) (3,018,588) 38.86% 3 ,000 (12 ,000) (20 .00%) ---% (50,000) (100,000) 100 .00% 84,500 (16 ,000) (84.08%) -(5,000) -% 11,000 (7,000) (61.11%) 7 ,000 -(100 .00%) (32,500) (77,000) 73.03% 40,000 -(100 .00%) 30,000 (20 ,000) (60 .00%) -(10,000) -% (124,550) (459 ,740) 37 .16% (496,823) (8,627,733) 6 .11% ---% 47,685 (169,402) (21.97%) (51,617) (51,617) -% (34,700) (411,600) 9.21% ---% (38,632) (632,619) 6.50% 473 ,483 11,806,073 4.18% City of Pickering 2024 Current Budget Summary 10200 Culture & Recreation -Administration 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 1,661,719 1,743,958 Salaries & Wages 2,262,977 6,015 10,739 Overtime 20,335 433,770 451,828 Employee Benefits 592,999 -872 Employee Recognition - -275 Uniforms 2,500 2,977 2,560 Conferences 7,465 993 3,537 Seminars & Education .. 6,150 795 3,257 Travel 2,000 12,784 10,546 Cellular Phones 10,480 7,153 7,110 Telephone & Data 9,600 ' 1,590 2,372 Internet 1,745 142,019 123,664 Advertising 151,100 -909 Trade Shows ,Exhibits & Displays 5,000 -1,686 Subscriptions & Publications 200 --Photo, Mapping, Print 9,000 8,250 9,075 Insurance Premium 9,075 4,681 104,005 Consulting & Professional Fees 376,387 9,900 3,355 Meals, Promotions & General 9,000 5,385 6 ,397 Memberships 4,665 1,988 1,033 Vehicle -Repairs & Maintenance - 272 112 Gas, Oil, Tire, Etc . - 72,861 75,992 Building Rentals 75,310 4,483 4,874 Stationary & Office Supplies 4,300 166,436 283,144 Programs & Event Supplies 430,000 25 920 Special Event Supplies - 26,750 13,002 Committee Expenses 22,000 1,775 (17) Supplies & Tools - 6,270 25,338 Software & Hardware Mtce. Contracts 33,995 2,020 -Furniture & Fixtures 1,000 --Misc. Equipment - 156,349 206,983 Financial Services Charges 175,000 • 2,737,260 3,097,526 Total Expenditures 4,222,283 Revenues (151,832) (155,013) Federal Grants (372,300) (5,000) -Ontario Grants (125,000) 79 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 (398,086) 1,864,891 (17 .59%) (5,000) 15,335 (24.59%) (59,591) 533,408 (10 .05%) ---% (2,500) -(100 .00%) (965) 6,500 (12.93%) (3,150) 3,000 (51 .22%) 1,000 3,000 50 .00% (5,000) 5,480 (47 .71%) -9,600 -% -1,745 -% (61,100) 90,000 (40.44%) (5,000) -(100.00%) -200 -% (4,000) 5,000 (44.44%) 40 9,115 0.44% (154,918) 221,469 (41 .16%) -9,000 -% 5,225 9,890 112.00% ---% ---% 189,845 265,155 252 .08% (1,000) 3,300 (23.26%) (430,000) -(100 .00%) ---% 9,500 31,500 43.18% ---% 6,375 40,370 18 .75% -1,000 -% 8 ,600 8,600 -% 7,000 182,000 4 .00% (902,725) 3,319,558 (21.38%) 372,300 -(100.00%) 125,000 -(100 .00%) City of Pickering 2024 Current Budget Summary 10200 Culture & Recreation -Administration 2022 2023 2023 Actuals YTD Account Description Budget Actuals --Rentals -User Fees - -. (1,275) Other User Fees - (14,200) (15,000) Sponsorships (15,000) --Marketing Sponsors (25,000) --other Contributions (50,000) (171,032) (171,288) Total Revenues (587,300) Transfers --Transfer to/(from) DC Oblg RF (217,087) 60,506 -Transfer to(from) Cntg Sty Res . - (12,157) -Transfer to(from) Reserve (115,000) (290) -Transfer to (from) Oblig RF - 48 ,059 -Total Transfers (332,087) 2,614,287 2,926,238 Net Expenditures (Revenues) 3,302,896 80 Run Date : Jan 25, 2024 Increase/ 2024 % Change Decrease Budget From 2023 (286,000) (286,000) - % --- % 15,000 -(100 .00%) 25,000 -(100 .00%) 50,000 -(100 .00%) 301,300 (286,000) (51.30%) 47,685 (169,402) (21.97%) (51 ,617) (51 ,617) -% 115,000 -(100 .00%) --- % 111,068 (221,019) (33.45%) (490,357) 2,812,539 (14.85%) 10205 Programs 2022 2023 Actuals YTD Actuals 658,279 636,666 807,297 1,143,626 24,593 31,015 200,706 255,959 6,590 5,278 365 4,966 2,938 1,079 935 - 1,753 . 1,255 2,033 2,642 266 333 1,129 7,817 -33 56,109 24,485 9,500 10,450 6,951 (17) 1,250 1,154 32,560 49,502 -243 6,522 1,066 -- 141,662 117,468 1,153 - -- 391,309 587,216 1,262 - 3,449 (276) 854 - 1,171 1,279 11 - 2,360,647 2,883,239 (107,783) (106,418) (53,407) (33,604) (10,167) - City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 767,728 Salaries & Wages -Programs 1,272,620 Overtime 31,300 Employee Benefits 193,485 Uniforms 5,000 Seminars & Education 6,600 Travel 3,200 Freight, Express & Cartage - Cellular Phones 4,000 Telephone & Data 3,000 Internet 300 Advertising 13,750 Subscriptions & Publications 100 Brochures/Newsletters Printing 67,000 Insurance Premium 10,450 Meals, Promotions & General 3,000 Memberships 1,500 Outside Agency Services 71,200 Vehicle -Repairs & Maintenance 6,600 Gas, Oil, Tire, Etc. - Misc . Equip. -Repairs & Maintenance 200 Building Rentals 174,900 Stationary & Office Supplies - Forms 500 Programs & Event Supplies 696,125 Committee Expenses - Supplies & Tools 2,400 Software & Hardware Mtce. Contracts 2,425 Misc . Equipment 7,000 Miscellaneous Expenses - Total Expenditures 3,344,383 Revenues Federal Grants (150,000) Ontario Grants (42,000) Other Agency Grants (20,000) 81 Run Date: Jan 25, 2024 Increase I 2024 % Change Decrease Budget From 2023 (82,254) 685,474 (10 .71%) 273,212 1,545,832 21.47% (21,300) 10,000 (68.05%) 17,258 210,743 8.92% 8,080 13,080 161 .60% (2,400) 4,200 (36.36%) 300 3,500 9.38% ---% -4,000 -% (800) 2 ,200 (26 .67%) -300 -% (13,750) -(100.00%) -100 -% -67,000 -% (1,807) 8,643 (17 .29%) (3,000) -(100.00%) -1,500 -% 63,200 134,400 88.76% (6,600) -(100 .00%) ---% -200 -% 1,500 176,400 0.86% ---% -500 -% (477,066) 219,059 (68.53%) ---% -2,400 -% 75 2,500 3.09% (1,000) 6,000 (14 .29%) ---% (246,352) 3,098,031 (7.37%) 90,000 (60,000) (60.00%) 42,000 -(100 .00%) (25,000) (45,000) 125.00% 10205 Programs 2022 2023 Actuals YTD Actuals -(525) (11,963) (10,746) {1,535,209) (2,301,684) (4 ,900) (5,510) (5,500) (18,500) -(15,000) (13,715) (25,885) -- (1,742,644) (2,517,872) -- - - 618,003 365,367 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Advertising Space (11,000) Event Vendor Fees (9 ,600) Program Revenue (2 , 173,850) Other User Fees (18,500) Program Sponsorships (7 ,000) Marketing Sponsors - Program Mkt Sponsors (40,000) Cost Recoveries (10,000) Total Revenues (2,481,950) Transfers Transfer to(from) Reserve (136,900) Total Transfers (136,900) Net Expenditures (Revenues) 725,533 82 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 -(11,000) -% 9,600 -(100.00%) (844,738) (3,018 ,588) 38 .86% 15,000 (3 ,500) (81 .08%) 7,000 -(100.00%) ---% 40 ,000 -(100.00%) 10,000 -(100 .00%) (656,138) (3,138,088) 26.44% 136,900 -(100.00%) 136,900 -(100.00%) (765,590) (40,057) (105.52%) City of Pickering 2024 Current Budget Summary 10207 Cultural Services 2022 2023 2023 Actuals YTD Account Description Budget Actuals ~· Expenditures --Salaries & Wages - --Overtime - --Employee Benefits - --Uniforms - --Conferences - --Seminars & Education - --Cellular Phones - --Telephone & Data - --Advertising - --Trade Shows,Exhibits & Displays - --Insurance Premium - --Meals, Promotions & General - --Memberships - --Outside Agency Services - --Vehicle -Repairs & Maintenance - --Stationary & Office Supplies - --Programs & Event Supplies - --Committee Expenses - --Software & Hardware Mtce . Contracts - --Total Expenditures - Revenues --Federal Grants - --Ontario Grants - --Event Vendor Fees - --Other User Fees - --Sponsorships - --Marketing Sponsors - --Other Contributions - --Cost Recoveries - --Total Revenues - - Transfers --Transfer to(from) Reserve - --Total Transfers - 83 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 --•.•• r 506,740 506,740 -% 36,300 36,300 -% 104,263 104 ,263 -% 2,500 2 ,500 -% 2 ,500 2 ,500 -% 2,000 2,000 -% 5,000 5,000 -% 1,000 1,000 -% 48,750 48,750 -% 5,000 5,000 -% 4,692 4,692 -% 4,000 4,000 -% 505 505 -% 10,000 10,000 -% 6 ,600 6 ,600 -% 1,000 1,000 -% 1,002 ,975 1,002,975 -% 17,500 17,500 -% 570 570 -% 1,761,895 1,761,895 -% (44 ,700) (44,700) -% (33,500) (33 ,500) -% (14,600) (14,600) -% (10,000) (10,000) -% (4,000) (4,000) -% (65,000) (65,000) -% (20,000) (20 ,000) -% (10,000) (10,000) -% (201,800) (201,800) -% (411,600) (411,600) -% (411,600) (411,600) -% 10207 Cultural Services 2022 2023 Actuals YTD Actuals -- City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Net Expenditures (Revenues) 84 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 -1,148,495 1,148,495 -% 10210 Dunbarton Pool 2022 2023 Actuals YTD Actuals 145,903 217,511 4,834 4,894 39,126 48,665 1,616 370 506 3,600 115 117 12 - 511 515 3,454 3,012 1,511 1,390 1,720 1,892 -769 1,198 1,848 37,763 49 ,903 1,025 764 31 23 599 150 27,395 30,389 348 - -- -- 267,667 365,812 (2,522) (2,637) (93,286) (57,727) (7,334) (6 ,000) (103,142) (66,364) - - 164,525 299,448 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 330,417 Overtime 2,200 Employee Benefits 82,140 Uniforms 3,820 Seminars & Education 6,150 Travel 200 Environmental Charges - Cellular Phones 1,040 Telephone & Data 3,900 Internet 1,570 Insurance Premium 1,892 Memberships 1,211 Outside Agency Services 2,113 Building -Repairs & Maintenance 51,615 Misc . Equ ip. -Repairs & Maintenance 3,000 Stationary & Office Supplies 200 Supplies & Tools 8,661 Utilities -Natural Gas 32,680 Software & Hardware Mtce . Contracts 395 Furniture & Fixtures 3,000 Misc. Equipment - Total Expenditures 536,204 Revenues Admissions (5,000) Rentals -Pool (119,440) Memberships (8,000) Total Revenues (132,440) Transfers Total Transfers - Net Expenditures (Revenues) 403,764 85 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 26,296 356 ,713 7.96% -2,200 - % 152 82 ,292 0.19% 60 3,880 1.57% (5,150) 1,000 (83 .74%) -200 - % --- % -1,040 - % 200 4,100 5.13% -1,570 - % 283 2 ,175 14.96% 89 1,300 7.35% 187 2,300 8.85% 16 ,385 68 ,000 31 .74% -3,000 -% -200 - % 2,289 10,950 26.43% 2,220 34,900 6.79% 5 400 1.27% 1,000 4,000 33.33% 5,600 5,600 - % 49,616 585,820 9.25% 2,500 (2 ,500) (50 .00%) (1,800) (121,240) 1.51% -(8,000) - % 700 (131,740) (0.53%) - - - % 50,316 454,080 12.46% 10215 Don Beer Arena 2022 2023 Actuals YTD Actuals 637,767 642,821 32,376 50,178 138,637 173,951 3,278 1,216 418 870 -- 624 - 1 - 608 430 14,564 14,690 262 256 493 501 5,970 6,567 -- 333 391 -- 4,318 3,655 165,910 200,238 -1,107 2 ,916 12,276 -468 -- 40 ,820 40,440 265 38 176 959 31 ,823 41,792 214,850 276 ,103 36 ,780 44 ,774 900 - -- 4,220 - 1,338,309 1,513,721 -(7,481) (5 ,543) (5,265) City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 661,623 Overtime 20,000 Employee Benefits 165,858 Uniforms 7,080 Seminars & Education 5,600 Travel 200 Freight, Express & Cartage - Environmental Charges - Cellular Phones 1,800 Telephone & Data 15,100 Internet 265 Cable TV 545 Insurance Premium 6,567 Insurance Deductible 2,000 Meals, Promotions & General - Memberships 400 Outside Agency Services 3,115 Building -Repa irs & Maintenance 213 ,606 Gas , Oil, Tire, Etc. - Misc . Equ ip. -Repairs & Maintenance 15,000 Grounds Upkeep - Misc . Equip. Rentals 300 Land Rentals 99,345 Stationary & Office Supplies 300 Supplies & Tools 2,165 Utilities -Water 34,300 Utilities -Hydro 229 ,150 Utilities -Natural Gas 39,235 Software & Hardware Mtce. Contracts 795 Furniture & Fixtures 6,000 Misc. Equipment - Total Expenditures 1,530,349 Revenues Snack Bar (3 ,950) Vending Machines (3,600) 86 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 143,097 804,720 21.63% 5,000 25,000 25.00% 40 ,738 206,596 24 .56% 1,325 8,405 18 .71% (860) 4 ,740 (15.36%) -200 -% --- % --- % (800) 1,000 (44.44%) (500) 14 ,600 (3.31%) -265 -% -545 -% 983 7,550 14.97% 300 2,300 15.00% - --% -400 -% -3,115 - % 37,630 251 ,236 17.62% -- - % -15 ,000 -% ---% -300 - % -99,345 -% -300 -% -2,165 -% 10 ,700 45 ,000 31 .20% 79,550 308,700 34 .72% 3,965 43,200 10.11 % 105 900 13 .21% -6,000 - % ---% 321,233 1,851 ,582 20.99% (9 ,050) (13,000) 229.11% -(3,600) - % 10215 Don Beer Arena 2022 2023 Actuals YTD Actuals (1 ,208) - (1,543) (3 ,500) (852 ,006) (1,136,771) (20,565) (32,551) (19,763) (33,869) -- (900 ,628) (1,219,437) - - 437,681 294,284 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Admissions (2 ,000) Rentals -User Fees (4,600) Rentals -Ice Surface (992,000) Rentals -Arena Floor (38 ,000) Rentals -Halls (36,000) Marketing Sponsors (7,500) Total Revenues (1,087,650) Transfers Total Transfers - Net Expenditures (Revenues) 442,699 87 Run Date : Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 -(2,000) - % -(4 ,600) -% (30,000) (1 ,022,000) 3 .02% (1 ,000) (39,000) 2.63% (1,000) (37 ,000) 2 .78% 7,500 -(100 .00%) (33,550) (1,121,200) 3.08% --- % 287,683 730,382 64.98% City of Pickering 2024 Current Budget Summary 10220 Community Centres 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 293,863 231,605 Salaries & Wages 259,392 10,340 8,500 Overtime 8 ,000 59,853 53,108 Employee Benefits 63,450 1,996 2,019 Uniforms 4,920 1,083 254 Seminars & Education 1,760 436 87 Travel 500 16 -Environmental Charges - 3,217 3,683 Cellular Phones 2,500 6,324 6,922 Telephone & Data 7,300 5,901 6,436 Internet 6,080 1,066 1,081 Cable TV 1,080 -233 Advertising - 4,156 4,378 Insurance Premium 4,378 314 -Insurance Deductible 2,000 17 208 Meals, Promotions & General - 17,210 7,410 Outside Agency Services 11,984 282 ,294 216,336 Building -Repairs & Maintenance 333,545 17,946 10,341 Vehicle -Repairs & Maintenance 6,300 17,621 23,693 Gas, Oil , Tire, Etc. 17,150 2,302 1,020 Misc. Equip. ~ Repairs & Maintenance 1,500 32 32 Building Rentals 10 381 34 Stationary & Office Supplies - -31 Programs & Event Supplies - 1,568 582 Supplies & Tools 2 ,000 12,322 11 ,968 Utilities -Water 13,250 91,599 104,459 Utilities -Hydro 101,990 23,976 28,125 Utilities -Natural Gas 27,905 7,067 5,198 Utilities -Oil 4,867 413 2,200 Software & Hardware Mtce. Contracts 310 -7,445 Furniture & Fixtures 10,000 (234) (863) Miscellaneous Expenses - 863,079 736,525 Total Expenditures 892,171 Revenues (758) (1,120) Vending Machines (1 ,000) (125,208) (187,164) Commun ity Ctr . Rentals (183 ,980) 88 Run Date : Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 147,292 406,684 56.78% -8,000 - % 46,357 109,807 73 .06% (20) 4,900 (0.41%) 690 2,450 39.20% -500 - % --- % -2,500 - % (700) 6,600 (9 .59%) -6,080 - % -1,080 - % - -- % 657 5,035 15.01% 300 2,300 15.00% - -- % -11,984 - % 33,709 367,254 10 .11% -6,300 - % 6,315 23,465 36 .82% -1,500 - % -10 - % --- % - -- % 10,950 12,950 547 .50% (450) 12 ,800 (3.40%) 7,810 109,800 7.66% 4 ,185 32 ,090 15 .00% 123 4,990 2.53% 2,050 2,360 661 .29% -10 ,000 - % ---% 259,268 1,151,439 29.06% 200 (800) (20 .00%) (6,120) (190,100) 3.33% City of Pickering 2024 Current Budget Summary 10220 Community Centres 2022 2023 2023 Actuals YTD Account Description Budget Actuals --Other User Fees (2,500) --Netted Revenue (11,900) (125,966) (188,284) Total Revenues (199,380) Transfers 41,000 -Capital Expenditures - 41,000 -Total Transfers - 778,113 548,241 Net Expenditures (Revenues) 692,791 89 Run Date: Jan 25 , 2024 Increase/ 2024 %Change Decrease Budget From 2023 -(2,500) - % 11,900 -(100 .00%) 5,980 (193,400) (3.00%) --- % --- % 265 ,248 958,039 38.29% City of Pickering 2024 Current Budget Summary 10225 Recreation Complex -Central Core 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 2,152 ,656 2,325,251 Salaries & Wages 2,240,124 54,896 45,818 Overtime 73 ,844 471,157 558,695 Employee Benefits 576,180 10 ,684 8,595 Uniforms 9,820 194 -Conferences - 3,911 2,420 Seminars & Education 6,081 129 114 Travel 800 7,889 9,951 Cellular Phones 8,800 10,199 10 ,167 Telephone & Data 11,660 1,049 1,023 Internet 1,065 24,433 13 ,081 Advertising 31,000 104 -Subscriptions & Publications 250 13,570 14,927 Insurance Premium 14,927 2,790 4,985 Insurance Deductible 4 ,000 11 ,339 4 ,055 Meals, Promotions & General 13,000 1,670 2,827 Memberships 3,575 59,898 64,368 Outside Agency Services 66,370 362,026 447 ,816 Building -Repairs & Maintenance 403,404 413 -Vehicle -Repairs & Maintenance - 18,952 25,680 Misc. Equip . -Repairs & Maintenance 44,475 582 -Misc . Equip. Rentals 8,000 5,244 5,609 Stationary & Office Supplies 6,500 --Forms 1,100 2,199 2,431 Programs & Event Supplies 6,800 .17,578 26,296 Supplies & Tools 26,400 27,540 34 ,-837 Utilities -Water 36,180 • 191,986 206,403 Utilities -Hydro 244,000 58,185 66,435 Utilities -Natural Gas 60,385 8,973 5,169 Software & Hardware Mtce. Contracts 19,190 1,843 11,600 Furniture & Fixtures 34,000 6 22 Misc . Equipment - 3,308 (3,214) Miscellaneous Expenses - --Financial Services Charges - 3,525,403 3,895,361 Total Expenditures 3,951,930 Revenues 90 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 39 ,877 2,280,001 1.78% -73,844 -% (23,470) 552,710 (4.07%) 5,430 15,250 55.30% ---% 2,169 8,250 35 .67% -800 -% -8,800 -% (1,800) 9,860 (15.44%) -1,065 -% -31,000 -% -250 -% 2,238 17,165 14 .99% 600 4,600 15.00% -13 ,000 -% -3,575 - % (229) 66,141 (0 .35%) (146,810) 256,594 (36 .39%) ---% (6 ,700) 37,775 (15 .06%) -8,000 -% -6,500 -% -1,100 -% -6,800 -% 200 26,600 0.76% 1,320 37,500 3 .65% (13,200) 230,800 (5.41%) 6,715 67,100 11.12% 2,870 22,060 14 .96% 15,820 49,820 46.53% ---% ---% 500 500 -% (114,470) 3,837,460 (2.90%) City of Pickering 2024 Current Budget Summary 10225 Recreation Complex -Central Core 2022 2023 2023 Actuals YTD Account Description Budget Actuals -(245) Department User Fees (10,000) (2,799) (10,646) Vending Machines (10 ,000) (115 ,797) (183,869) Admissions (133,858) (27,749) (44,253) Rentals -Meeting Rooms (55 ,700) (61,662) (97,150) Rentals -Halls (100 ,000) (79 ,334) (79,705) Rental -Wellness Clinic (81,000) (445,599) (864 ,888) Memberships (719,632) (3,703) (4,493) Child Supervision - (55,773) (89,828) Fitness Testing (50,000) (85,477) (8,172) Other User Fees (79,500) (877 ,893) (1,383,249) Total Revenues (1,239,690) Transfers 75 ,000 75,000 Transfer to(from) Reserve (125,000) 75,000 75,000 Total Transfers (125,000) 2,722,510 2,587,112 Net Expenditures (Revenues) 2,587,240 91 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 -(10 ,000) - % 700 (9,300) (7 .00%) (11,842) (145 ,700) 8 .85% 21,000 (34 ,700) (37 .70%) -(100,000) - % (800) (81,800) 0.99% (68,868) (788,500) 9 .57% --- % (50,000) (100,000) 100.00% 79,500 -(100 .00%) (30,310) (1,270,000) 2.44% 125,000 -(100 .00%) 125,000 -(100.00%) (19,780) 2,567,460 (0 .76% City of Pickering 2024 Current Budget Summary 10230 Recreation Complex -Pool 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 645,509 621,650 Salaries & Wages 492,564 24,756 27 ,071 Overtime 5,000 134,059 143,434 Employee Benefits 91,709 3,649 3,999 Uniforms 6,320 532 3,928 Seminars & Education 6 ,246 23 -Environmental Charges - 574 574 Telephone & Data 700 75 73 Internet 75 4,630 5,093 Insurance Premium 5,093 -610 Insurance Deductible - -68 Meals, Promotions & General - -769 Memberships 1,236 94,984 96,630 Building -Repairs & Maintenance 74,950 459 -Misc . Equip . -Repairs & Maintenance 1,000 3,852 1,198 Supplies & Tools 7,650 27,540 34,837 Utilities -Water 52,750 135,794 145,992 Utilities -Hydro 162 ,500 58,185 66,435 Utilities -Natural Gas 60,385 723 -Software & Hardware Mtce . Contracts 590 -12,323 Furniture & Fixtures 12 ,000 7,334 6,000 Memberships - 1,142,678 1,170,684 Total Expenditures 980,768 Revenues (42,111) (52,756) Admissions (52,000) (116,819) (89 ,330) Rentals -Pool (154,960) (40,208) (97 ,710) Memberships (65,000) (199,138) (239,796) Total Revenues (271,960) Transfers --Total Transfers - 943,540 930,888 Net Expenditures (Revenues) 708,808 92 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 (68,837) 423,727 (13.98%) -5,000 -% 1,321 93,030 1.44% 500 6,820 7.91% (5,246) 1,000 (83 .99%) ---% (100) 600 (14.29%) -75 -% 767 5,860 15.06% ---% ---% 64 1,300 5.18% 39,100 114,050 52.17% -1,000 -% 6,000 13,650 78.43% (5 ,950) 46 ,800 (11 .28%) 700 163,200 0.43% 6,715 67,100 11.12% (120) 470 (20 .34%) (1,400) 10,600 (11 .67%) ---% (26,486) 954,282 (2.70%) (1 ,560) (53,560) 3.00% (2,001) (156,961) 1.29% (3,000) (68 ,000) 4 .62% (6,561) (278,521) 2.41% ---% (33,047) 675,761 (4.66%) City of Pickering 2024 Current Budget Summary 10235 Recreation Complex -Arenas 2022 2023 2023 Actuals YTD Account Description Budget Actuals -(13 ,750) Advertising Space (55,000) (606,626) (713,914) Total Revenues (846 ,700) Transfers --Total Transfers - 361,330 333,125 Net Expenditures (Revenues) 302 ,323 94 Run Date : Jan 25 , 2024 Increase/ 2024 %Change Decrease Budget From 2023 -(55,000) -% (47,400) (894,100) 5.60% ---% (4,157) 298,166 (1.38%1 10240 Civic Centre 2022 2023 Actuals YTD Actuals 395 ,805 493,332 17 ,185 18,755 63,822 96,482 1,134 1,096 -173 4 ,088 4 ,090 534 519 1,451 1,470 3,120 3,432 516 - 1,201 - -- 114 ,108 118,143 169,516 195 ,694 1,859 2 ,397 -- -610 586 1,074 10 ,072 10,488 90,401 100,267 28,364 32 ,339 440 - 904,202 1,080,361 (442) (313) (353,648) (315 ,790) (354,090) (316,103) -- 550,112 764,258 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 468,477 Overtime 5,500 Employee Benefits 99 ,200 Uniforms 2,220 Seminars & Education - Telephone & Data 4 ,700 Internet 530 Cable TV 1,500 Insurance Premium 3,432 Insurance Deductible 1,000 Consulting & Professional Fees 2 ,000 Meals, Promotions & General - Outside Agency Services 165 ,200 Building -Repairs & Maintenance 246,407 Misc . Equip. -Repairs & Maintenance 1,500 Misc. Equ ip. Rentals 500 Stationary & Office Supplies - Supplies & Tools 3,000 Utilities -Water 13 ,770 Utilities -Hydro 148,825 Utilities -Natural Gas 30,805 Software & Hardware Mtce . Contracts 562 Total Expenditures 1,199 ,128 Revenues Vending Machines (500) Netted Revenue (323 ,290) Total Revenues (323,790) Transfers Total Transfers - Net Expenditures (Revenues) 875,338 95 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From2023 102,109 570 ,586 21 .80% -5 ,500 -% 6 ,068 105 ,268 6 .12 % 3 ,320 5,540 149.55% ---% (600) 4 ,100 (12 .77 %) -530 -% -1,500 -% 518 3,950 15 .09% 150 1,150 15.00% -2,000 -% 15 ,000 15,000 -% 14 ,820 180 ,020 8.97 % 24 ,249 270,656 9 .84% -1,500 -% -500 -% ---% -3,000 -% (2,070) 11,700 (15.03%) (36 ,725) 112 ,100 (24 .68%) 6,395 37,200 20 .76% 78 640 13 .88% 133 ,312 1,332,440 11.12% 200 (300) (40 .00%) (136,450) (459,740) 42.21% (136 ,250) (460,040) 42.08% ---% (2,938) 872,400 (0.34%' City of Pickering 2024 Current Budget Summary 10245 Senior Citizens Centre 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 256,697 278,333 Salaries & Wages 280,747 6,857 6 ,001 Overtime 6,000 49 ,785 65,174 Employee Benefits 72,966 225 368 Uniforms 2 ,110 20 -Conferences - 712 -Seminars & Education 5,850 180 756 Travel 1,200 410 467 Cellular Phones 600 2 ,552 2,468 Telephone & Data 2,740 76 74 Internet 75 1,616 1,505 Cable TV 1,590 --Advertising 1,000 2,440 2,684 Insurance Premium 2 ,684 35,148 708 Meals, Promotions & General - 825 825 Membersh ips 850 1,165 346 Outside Agency Services 2,580 50,096 54,807 Building -Repairs & Maintenance 110,275 -472 Misc . Equip. -Repairs & Maintenance - 71 133 Stationary & Office Supplies - 17,168 28,512 Programs & Event Supplies 18,300 --Special Event Supplies 55,000 -1,611 Supplies & Tools 2,100 4,878 5,157 Utilities -Water 6,050 17,499 17,558 Utilities -Hydro 26,652 4,671 4 ,932 Utilities -Natural Gas 7,095 1,979 1,688 Software & Hardware Mtce . Contracts 2,235 --Misc . Equipment 4,000 -6,661 Miscellaneous Expenses - 455,070 481,240 Total Expenditures 612,699 Revenues (39,050) -Federal Grants - (129 ,078) (87,401) Ontario Grants (144,400) (3,658) (6,197) Seniors Event Fees (3,000) (41 ,351) (69,439) Older Adults 55+ Programs (54,000) (2,700) (200) Sponsorships (3,000) 96 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 45,011 325,758 16 .03% -6,000 -% 3,433 76,399 4 .70% 1,190 3,300 56.40% ---% (1 ,700) 4,150 (29 .06%) -1,200 -% -600 -% (400) 2,340 (14 .60%) -75 -% -1,590 -% -1,000 -% 406 3,090 15.13% ---% -850 -% -2,580 -% (18 ,079) 92,196 (16.39%) ---% ---% 6,100 24,400 33 .33% 17,476 72,476 31 .77% -2,100 -% (150) 5,900 (2.48%) (7 ,052) 19,600 (26.46%) (1,095) 6,000 (15.43%) 935 3 ,170 41 .83% (4,000) -(100.00%) ---% 42,075 654,774 6.87% ---% (13,476) (157,876) 9 .33% (850) (3,850) 28 .33% (38,918) (92,918) 72 .07% -(3,000) -% City of Pickering 2024 Current Budget Summary 10245 Senior Citizens Centre 2022 2023 2023 Actuals YTD Account Description Budget Actuals -(5,450) Marketing Sponsors (2,000) (215,837) (168,687) Total Revenues (206,400) Transfers - - Total Transfers - 239,233 312,553 Net Expenditures (Revenues) 406,299 97 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 -(2,000) -% (53,244) (259,644) 25.80% --- % (11 ,169) 395,130 (2.75%) 10250 Museum 2022 2023 Actuals YTD Actuals 864,940 851,095 3,830 3,279 170,849 194,609 6,003 · 1,837 981 - 3,164 1,949 2,154 2,882 2,079 6,963 4,795 3,835 18,467 17,446 1,612 1,615 177,559 59,163 151 ,621 38,086 -2,500 4,030 4,433 30,000 5,000 2,982 1,703 1,094 1,617 6,615 6,114 109,518 103,898 1,644 7,451 2,086 511 2,848 3,073 9,468 6,009 370 1,244 1,878 863 33,777 15,452 2,271 3,315 885 645 114 253 3,610 4,287 21,658 23,561 12,906 9,149 -- 2,098 2,044 -2,614 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 869,883 Overtime 2,000 Employee Benefits 174,271 Uniforms 6,620 Conferences - Seminars & Education 5,000 Travel 2,500 Freight, Express & Cartage 7,500 Cellular Phones 6,500 Telephone & Data 19,000 Internet 1,635 Advertising 65,000 Trade Shows.Exhibits & Displays 214,500 Photo, Mapping, Print - Insurance Premium 4,433 Consulting & Professional Fees 15,000 Meals, Promotions & General 5,500 Memberships 2,962 Outside Agency Services 5,255 Building -Repairs & Maintenance 102,765 Vehicle -Repairs & Maintenance 10,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 40,000 Supplies & Tools 500 Artefact Purchases 600 Gift Shop/Plaques 5,000 Utilities -Hydro 24,545 Utilities -Natural Gas 13,885 Utilities -Oil 1,500 Software & Hardware Mice. Contracts 8,495 Furniture & Fixtures - 98 Run Date: Jan 25, 2024 Increase/ 2024 % Change Decrease Budget From 2023 (187,144) 682 ,739 (21 .51%) 5,000 7,000 250.00% (13,761) 160,510 (7.90%) (1,800) 4,820 (27 .19%) --- % -5,000 - % -2,500 - % (3,000) 4,500 (40.00%) -6,500 -% (320) 18,680 (1.68%) -1,635 - % 10,000 75,000 15.38% (121 ,759) 92,741 (56.76%) --- % 667 5,100 15.05% 1,000 16,000 6.67% (3,000) 2,500 (54.55%) -2,962 - % -5 ,255 - % 19,541 122,306 19.02% (6,000) 4,000 (60.00%) 270 2,970 10 .00% -3,000 - % -8,700 - % -2,800 - % -2,500 - % -4,000 - % (14,000) 26 ,000 (35 .00%) 1,500 2,000 300.00% -600 - % -5,000 - % 615 25,160 2.51% 2 ,085 15,970 15 .02% (1,500) -(100.00%) (65) 8,430 (0.77%) --- % 10250 Museum 2022 2023 Actuals YTD Actuals 2,421 - 1,660,327 1,388,495 (431,035) (163,845) (141,550) (3,812) (15 ,000) (43 ,800) (11,639) (5,149) (763) (461) (112,624) (117,868) (14,092) (9 ,384) (14,001) (9,962) (3,365) (344) (5 ,000) - (749,069) (354,625) -- 911,258 1,033,870 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Misc. Equipment - Total Expenditures 1,638,549 Revenues Federal Grants (352 ,050) Ontario Grants (156,000) Other Agency Grants (56,000) Gift Shop (11,600) Snack Bar (2,000) Admissions (135 ,000) Rentals -Meeting Rooms (11,000) Museum Programs (15,000) Donations (5 ,000) Marketing Sponsors (10 ,000) Total Revenues (753,650) Transfers Total Transfers - Net Expenditures (Revenues) 884,899 99 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 --- % (311,671) 1,326,878 (19.02%) 212,950 (139 ,100) (60.49%) 113,500 (42,500) (72.76%) 31,000 (25,000) (55.36%) -(11 ,600) -% -(2,000) -% -(135,000) -% -(11,000) - % 3,000 (12,000) (20 .00%) -(5,000) -% -(10 ,000) -% 360,450 (393,200) (47.83%) - - -% 48,779 933,678 5.51% Operations Department Key Activities for 2024 in Support of the Corporate Strategic Plan Priority 1: Champion Economic Leadership and Innovation • Advance the development of key major projects, including the Seaton Recreation Complex and Library, Pickering Heritage & Community Centre, and new Animal Shelter in accordance with Council's direction. • Maintain highly detailed asset inventories for the management of facilities and parks assets, to ensure that the City achieves maximum potential life, best quality and performance, and efficiently allocates available funding for capital investment to meet growing needs. • Install the shop crane in the Municipal Garage to increase efficiency in the repair and maintenance of heavy equipment. ' Priority 2: Advocate for an Inclusive, Welcoming, Safe & Healthy Community • Expand Seniors & Persons with Disabilities Snow Clearing Program from 500 registrants to 750 registrants. • Continue to engage with the Pickering Accessibility Advisory Committee and other related stakeholders when planning and implementing facilities and parks capital projects. Priority 3: Advance Innovation & Responsible Planning to Support a Connected, Well-Serviced Community • Re-map winter control routes, adding two new road plow routes and expanding the small truck routes due to growth. • Purchase additional brine trucks to expand the Brine Program and to reduce salt usage during winter control. • Implement road widening program to help improve road configuration and extend the life of City roads. • Acquire chipper and brushing head for the new gradall that will help clear the overgrowth on northern roads. • Develop a workplace modernization program to increase flexible use of existing office space and workstations at City Hall and other major facilities. 101 Operations Department Priority 4: Lead & Advocate for Environmental Stewardship, Innovation & Resiliency • Continue to purchase battery powered small equipment to replace gas powered small equipment, including hammers, drills, hedge trimmers, and snow blowers. • Continue the conversion of the gas-powered small vehicles, tools and equipment, based on availability and application. • Retrofit existing facilities and building new facilities in accordance with sustainability principles and recognized industry standards to help reduce the City's overall carbon footprint. • Update the City's 2019 Corporate Energy Management Plan. This guiding document informs sustainable initiatives and the introduction of new technologies into City parks and facilities, photo-voltaic panels, heat/energy recovery, smart systems controls and other similar innovations. Priority 5: Strengthen Existing and Building New Partnerships • Upgrade the Fleet Operations Department work order management system to provide increased efficiencies for mechanics. This upgrade was included in the Current budget submission. 102 Financial Information Operations Department Staffing Summary (Full & Regular Part-Time) Prior Term of Council Current Term of Council 2019 2020 2021 2022 2023 2024 Approved Add Delete Total Full-Time 71 81 81 90 95 7 -102 Reg. Part-Time 4 3 3 3 3 --3 Total 75 84 84 93 98 7 -105 * The above chart excludes contract, students and term employees The department is proposing the following additional positions in 2024: • Two new full-time Maintenance Worker, Roads positions -Growth in Seaton requires two maintenance workers for two additional small truck routes to provide winter control level of service to meet Municipal Act. 2001, Ontario Regulation 239/02 Minimum Maintenance Standards for Municipal Highways (MMS). • Two new full-time Maintenance Worker, Parks & Property positions -Growth in Seaton requires two maintenance workers for additional assumed sidewalks and pathways which adds two more routes to the existing sidewalk plow routes. Additional parks/village greens are also expected to come on-line in 2024. • Two new full-time Heavy Equipment Operator I positions -Growth in Seaton requires two heavy equipment operators for two additional large plow routes to provide winter control level of service to meet Municipal Act. 2001, Ontario Regulation 239/02 Minimum Maintenance Standards for Municipal Highways (MMS). • One new Coordinator, SAP position -The Operations Department had an annual Current Expenditure Budget of $21,702,572 and Capital Budget of $18,483,368.00 in 2023. Operations Services also completed facilities capital projects for all other City departments, totaling $24,584,700 in 2023. The department requires embedded expertise in the SAP finance system. The quality of Operations submissions and compliance with workflow procedures needs this level of expertise. An SAP Coordinator embedded in Operations will also act as a liaison with the Finance SAP team to further develop and integrate SAP needs, workflow and procedures, and help train Operations staff as a subject matter expert. 103 Operations Department Year-Over-Year (Net Cost) Budget Changes Year-Over-Year 2023 2024 Change Budget Budget ($) (%) Public Works -Admin. $846,956 $914,571 $67,615 7.98% Property Maintenance 1,199,691 991,370 (208,321) (17.36%) Fleet Services 2,131,003 2,225,982 94,979 4.46% Roads 8,675,799 10,021,034 1,345,235 15.51% Parks 5,368,044 6,288,927 920,883 17.15% Operations Services 1,406,124 1,507,468 101,344 7.21% Major Capital Facilities - % Total (Net Cost) $19,627,617 $21,949,352 $2,321,735 11.83% 104 Account Repairs & Maintenance Highway Aids - Repairs & Maintenance Building Repairs & Maintenance • Tree Maintenance Vehicle Repairs & Maintenance Gas, Oil, Tires, etc. Misc. Equipment Repairs & Maintenance , Grounds Upkeep Building Rentals : Program & Event • Supplies Shop Supplies Operations Department Change ' Explanation ($14,500) Decrease due to reduction in granular aggregate/limestone and other aggregates based on historical usage trends ($25,000), partially offset by the cost of planned repair/replacement of the Claremont Community Service sign. $50,000 Increase reflects costs for miscellaneous signs (including hardware and posts) and traffic marking paint. $139,002 Increase due to higher internal charges for janitorial services, increased waste disposal costs and provisions for maintenance and repairs to building envelope as well as increased internal charges for washroom maintenance (annualization from 2023 to full year). $15,000 Increase largely represents additional costs for tree maintenance within road allowances and block pruning. $40,000 Increase attributed to additional costs for repair and maintenance of licensed vehicles due to growth. $144,585 Increase reflects rising fuel costs and additional diesel, gas, oil changes and tires required due to growth of the City's fleet of vehicles and equipment. $89,000 Increase represents provision for repairs and maintenance of EV charging equipment -$9,000, and increased costs for the repair and maintenance of fleet equipment and vehicles due to growth -$80,000. ($62,000) Decrease related to projected costs for mechanical harvesting of Eurasian Water-Milfoil weeds in Frenchman's Bay ($50,000) as well as reduced maintenance costs for seasonal outdoor rinks due to weather conditions ($25,000), partially offset by increases in topsoil and ball diamond maintenance materials $13,000. $27,955 Increase represents rental costs for six months at 1101 Kingston Road for the Capital Facilities staff. $209,400 Increase largely attributed to the cost of expanding the Senior's Snow Removal program -$224,400, partially offset by costs associated with the Banner Program which were transferred to the Community Services department ($15,000). $25,025 Increase largely reflects costs for various shop supplies, and miscellaneous hardware and fasteners required due to growth. 106 Account Total Revenues Operations Department Change • Explanation $328,025 Transfers -(Increase)/ Decrease , Development Charges • Reserve Fund i Continuing Studies ; Reserve , Rate Stabilization ' Reserve , City Share DC ! Reserves • Casino Reserve Sustainable Initiatives Reserve • Total Transfers • Net Increase $33,705 Decrease reflects the completion Facilities Renewal Plan which required less funding going forward. ($86,488) Increase is for carry-over funding for the TRCA water testing project and various other 2023 consulting projects continuing in 2024. $101,500 Decrease in funding is due to reduced scope of work for Mechanical Harvesting of Eurasian Water-Milfoil Weeds in Frenchman's Bay Project -$25,000 and completion of 2022 line painting and curb repair works. $51,229 Decrease reflects funding for the Facilities Renewal plan not required in 2024. ($629,781) Increase represents funding for the expansion of the Senior's Snow Removal program ($194,350) and increase in funding required to reflect a full year's cost for the new Capital Facilities Team ($435,431). $5,000 Decrease represents one-time cost for funding for preliminary engineering study of rooftop solar PV options for the Operations Centre completed in 2023. ($524,835) $2,321,735 108 Operations Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2021 2022 2023 Fleet Services Work orders completed -Fire 153 work 108 work 141 work Services orders orders orders Work orders completed -other 1,304 work 808 work 935 work Departments orders orders orders Vehicles maintained -cars, trucks, 218 244 263 dump truck, snow ploughs, trailer, (replacement (replacement fire truck, tractors units yet to be units yet to be auctioned) auctioned) Attachments maintained -wings, 72 77 87 ploughs, salters, ball groomers, beach Qroomers, etc. Small equipment maintained -407 418 439 mowers, chain saws, trimmers, etc. Parks GarbaQe picked up/disposed 186,600 kQ 224,760 kQ 232,460 kQ Sidewalk winter control response 11 events 18 events 15 events Maintains open space 1,940 acres 1,940 acres 1,960 acres Maintains parks 85 86 88 Maintains playQrounds 63 63 64 Maintains splash pads 3 3 3 Maintains sports fields -soccer, 64 fields 64 fields 64 fields baseball, artificial turf, cricket pitch Roads Roadways maintained 352 km paved 357 km paved 370 km paved 102 km gravel 102 km mavel 100 km gravel Minimum Maintenance Standards 7,687 km 7,747 km 7,891 km roadway patrol (cumulative) (cumulative) (cumulative) Minimum Maintenance Standards 2,479 3,312 3,462 potholes repaired potholes potholes potholes Winter control response 30 events 41 events 43 events Road salt used 3, 140 tonnes 7,348 tonnes 5,091 tonnes Road sand used 2, 117 tonnes 2,572 tonnes 1,369 tonnes Road sweepings picked up/disposed 1,200 tonnes 1,280 tonnes 1,320 tonnes 109 Operations Department Performance Indicators/Statistics 2021 2022 Facilities Capital Projects Number of Capital Projects 1 34 71 Average Value per Project1 $395,000 $351,210 Facility Condition Index (Overall 0.26 0.31 Portfolio)2 • 3 Total Replacement Cost of Building $251 million $287 million Assets 3 Property Maintenance Seniors sidewalk clearing program 6 events I 12 events/ response/ registrations 379 403 registrants registrants 1 Includes facility-based capital projects managed by Operations on behalf of other departments. Excludes carryover projects from previous years. 2023 63 $576,167 0.24 $299 million 13 events I 404 registrants 2 The Facility Condition Index measures the condition of a building by dividing the renewal backlog by the total Replacement Cost for each facility. A lower number is better, indicating less ofa renewal backlog. 3 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. 110 City of Pickering 2024 Current Budget Summary Operations Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 8,538 ,045 8,548 ,661 Salaries & Wages 9,608,131 504 ,767 371,375 Overtime 484,750 2,136,528 2,286,307 Employee Benefits 2,445,848 124,116 110,587 Uniforms 99,505 3,876 1,496 Conferences 2,600 33,409 40,509 Seminars & Education 64,565 6,901 5,946 Travel 6,800 10,184 13,040 Freight, Express & Cartage 1,800 2,587 88 Environmental Charges 2 ,000 19,915 27,603 Cellular Phones 29,605 24,942 23,825 Telephone & Data 25,125 1,641 1,600 Internet 2,020 6,285 6,285 Subscriptions & Publications 12,600 7 -Photo, Mapping, Print 11,450 200,470 220,517 Insurance Premium 221 ,217 12,623 30,058 Insurance Deductible 27,050 183,310 156 ,245 Consulting & Professional Fees 513,780 7,819 6,074 Meals, Promotions & General 9,150 7,560 11,753 Memberships 14 ,125 177,433 224,099 Outside Agency Services 362,700 782,575 639,848 Winter Control Maintenance 846,000 175,124 330 ,856 Repairs & Maintenance Contract Servi< 404,200 59,315 196,582 Engineering -Repairs & Maintenance 383,500 218,543 256,411 Storm Sewer -Repairs & Maitenance 370,000 511,674 487,046 Repairs & Maintenance Materials 642,500 116,640 83,536 Highway Aids -Repairs & Maintenance 75,000 92,083 71,069 Engineering Highway Aids -Repairs & 120,000 532,618 587,707 Building -Repairs & Maintenance 620,603 450,126 302,837 Tree Maintenance 405,000 36 ,323 17,578 Lighting -Repairs & Maintenance 30,000 481,089 526,925 Vehicle -Repairs & Maintenance 454 ,000 845 ,113 776,742 Gas, Oil, Tire , Etc. 846,010 402,023 394,594 Misc. Equip. -Repairs & Maintenance 305,000 405 ,980 430,765 Grounds Upkeep 416,500 41,684 44 ,253 Fert . & Lawn Control 55,000 --Building Rentals 9,700 111 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 1,201 ,138 10,809,269 12.50% 32,250 517,000 6.65% 441 ,180 2,887,028 18 .04% 13,120 112,625 13.19% 5,100 7,700 196 .15% (2 ,370) 62,195 (3 .67%) 4 ,000 10,800 58.82% -1,800 -% -2,000 - % 715 30,320 2.42% 175 25 ,300 0.70% -2,020 -% 200 12,800 1.59% 6,750 18 ,200 58.95% 35,123 256,340 15 .88% 4,060 31,110 15.01% (47,946) 465,834 (9.33%) 3,950 13 ,100 43.17% 4,730 18,855 33.49% (7,000) 355,700 (1.93%) 40,000 886 ,000 4 .73% 275,800 680,000 68 .23% (75,500) 308,000 (19 .69%) -370,000 -% (14 ,500) 628,000 (2.26%) 50,000 125 ,000 66 .67% -120 ,000 - % 139,002 759,605 22.40% 15,000 420,000 3.70% -30,000 - % 40 ,000 494,000 8.81% 144,585 990,595 17 .09% 89,000 394,000 29.18% (62 ,000) 354,500 (14 .89%) -55,000 - % 27,955 37,655 288.20% City of Pickering 2024 Current Budget Summary Operations Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals 188 ,001 130,195 Misc. Equip. Rentals 160,500 19,538 19,538 Land Rentals 21,696 13,295 8,271 Stationary & Office Supplies 17,650 2,753 5,342 Forms 6,000 321,471 267,434 Programs & Event Supplies 536,800 134 ,566 153,693 Supplies & Tools 85,475 1,888 -Educational Material - 13,904 -COVID Related Expenses - 71 ,934 67,092 Utilities -Water 92 ,200 187,764 201,955 Utilities -Hydro 201,725 64 ,630 75 ,512 Utilities -Natural Gas 65,230 63,390 88,121 Software & Hardware Mice . Contracts 170 ,732 -1,477 Furniture & Fixtures 5,000 44,887 43,107 Misc . Equipment 35,730 61,035 98,232 other Fixed Assets 140,000 178,825 197,415 Taxes -Tenant 236,000 -(486) Miscellaneous Expenses - --Financial Services Charges - 18,521,209 18,589,715 Total Expenditures 21,702,572 Revenues (67,200) -Federal Grants (18,000) (312 ,920) (382,934) Department User Fees (225,000) (122) (112) Vending Machines (500) (215 ,170) (210,696) Rentals -User Fees (215,000) (37,400) (32,500) Memrl Tree/Bench Revenue (35,000) (89,124) (89,357) Other User Fees (135,100) (6,000) (6,000) Municipal Rentals (6,000) -(10,702) Rebates & Incentives (40,000) (69,838) (119,772) Cost Recoveries (116,050) (308,467) (299,361) Netted Revenue (368,350) (1,106,241) (1,151,434) Total Revenues (1,159,000) Transfers --Transfer to/(from) DC Oblg RF (67,500) 28,418 -Transfer to(from) Cntg Sty Res . (40 ,780) (50,000) -Transfer to(from) Reserve (777,675) 11 2 Run Date : Jan 25, 2024 Increase I 2024 %Change Decrease Budget From2023 5,000 165 ,500 3 .12% -21,696 -% 2,250 19,900 12 .75% -6,000 - % 209,400 746,200 39 .01% 25 ,025 110,500 29 .28% --- % --- % 2,100 94,300 2 .28% 20,175 221,900 10.00% 21,570 86,800 33 .07% (62,412) 108,320 (36 .56%) -5,000 -% 10,920 46,650 30 .56% (60,000) 80 ,000 (42.86%) (21,000) 215 ,000 (8 .90%) ---% 1,000 1,000 -% 2,518,545 24,221,117 11.60% 18,000 -(100.00%) 15,000 (210,000) (6.67%) -(500) - % 215,000 -(100.00%) -(35 ,000) - % (30,050) (165,150) 22 .24% -(6,000) - % -(40,000) - % 102,925 (13,125) (88.69%) 7,150 (361 ,200) (1 .94%) 328,025 (830,975) (28.30%) 33,705 (33,795) (49.93%) (86,488) (127,268) 212 .08% (472,052) (1 ,249,727) 60 .70% Operations Department 2022 2023 Actuals YTD Actuals (30,000) - (51,582) - 17,363,386 17,438,281 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Transfer to (from) Oblig RF (30 ,000) Total Transfers (915,955) Net Expenditures (Revenues) 19,627,617 113 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 -(30,000) -% (524,835) (1,440,790) 57.30% 2 ,321,735 21,949,352 11.83% City of Pickering 2024 Current Budget Summary 10300 Public Works -Administration 2022 2023 2023 Actuals YTD Account Description Budget Actuals Transfers - - Total Transfers - 913 ,587 888,014 Net Expenditures (Revenues) 846 ,956 115 Run Date : Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 --- % 67,615 914,571 7.98% City of Pickering 2024 Current Budget Summary 10305 Property Maintenance 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 464 ,871 434 ,736 Salaries & Wages 461,460 28 ,732 19,900 Overtime 30,000 99,422 102 ,134 Employee Benefits 119,559 14,222 5,6 73 Uniforms 3,100 - 405 -Seminars & Education 1,510 -224 Travel - 419 -Freight, Express & Cartage - 2 ,336 2,897 Cellular Phones 3,660 295 301 Telephone & Data 300 39 38 Internet 40 7 -Photo , Mapp ing , Print - 4 ,210 4,631 Insurance Premium 4,631 331 1,737 Insurance Deductible - 11 ,021 29,750 Consulting & Professional Fees 88,695 62 51 Meals , Promotions & General 200 7,775 4,828 Outside Agency Services 8,000 148,441 116 ,354 Tree Maintenance 175,000 35 ,979 17,578 Lighting -Repairs & Maintenance 30,000 14,694 28,255 Vehicle -Repairs & Maintenance 12,000 36,981 49,386 Gas, Oil, Tire, Etc . 37,950 114,278 88,941 Misc. Equip. -Repairs & Maintenance 90,000 119 ,937 108,465 Grounds Upkeep 120,000 22 ,073 20,178 Misc . Equip . Rentals 28,000 19,538 19,538 Land Rentals 21 ,696 220,226 200,582 Programs & Event Supplies 448,800 5,222 2 ,676 Supplies & Tools 3,500 642 -Software & Hardware Mice . Contracts 555 1,822 5 ,190 Misc. Equipment 6,030 20,345 24 ,618 Other Fixed Assets 30,000 --Taxes -Tenant 2,500 1,394,325 1,288,661 Total Expenditures 1,727,186 Revenues (22 ,985) (40,121) Other User Fees (60,100) (22,985) (40,121) Total Revenues (60,100) 116 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 8,536 469,996 1.85% -30,000 -% 3,894 123,453 3.26 % 100 3 ,200 3 .23% -1,510 -% --- % --- % -3,660 - % -300 - % -40 - % --- % 694 5,325 14 .99% --- % (32 ,190) 56,505 (36 .29 %) -200 - % -8,000 -% (155,000) 20,000 (88 .57%) -30,000 -% -12,000 - % 15 ,795 53 ,745 41.62% -90,000 - % (50,000) 70 ,000 (41 .67%) -28 ,000 -% -21,696 -% 224,400 673 ,200 50.00% 1,500 5,000 42.86% (25) 530 (4.50%) 1,185 7,215 19 .65% -30,000 -% -2,500 - % 18,889 1,746,075 1.09% (30,050) (90 ,150) 50 .00% (30,050) (90,150) 50.00% City of Pickering 2024 Current Budget Summary 10305 Property Maintenance 2022 2023 2023 Actuals YTD Account Description Budget Actuals Transfers 1,338 -Transfer to(from) Cntg Sty Res . (13,695) (50 ,000) -Transfer to(from) Reserve (438,700) (15,000) -Transfer to (from) Oblig RF (15,000) (63,662) -Total Transfers (467,395) 1,307,678 1,248,540 Net Expenditures (Revenues) 1,199,691 117 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 (42,810) (56 ,505) 312 .60% (169,350) (608,050) 38 .60% 15,000 -(100 .00%) (197,160) (664,555) 42.18% (208,321) 991,370 (17.36%' 10310 Fleet Services 2022 2023 Actuals YTD Actuals 1,059,252 1,185 ,041 57,910 40 ,006 277,209 322,369 24 ,199 24,221 2,658 - 5,556 8,127 1,419 2,040 3 ,626 2 ,814 977 145 1,981 1,333 14,021 10,465 306 297 -- 5,050 5,555 857 315 823 1,268 61 ,654 150,602 501 1,551 9,430 7,770 19,485 15,705 4 ,340 6,576 -2,307 2 ,753 5,342 76,934 99,322 1,888 - 15,818 19,757 15 600 1,648,662 1,913,528 (133 ,117) (299,361) (133,117) (299,361) -- City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 1,407 ,695 Overtime 50,000 Employee Benefits 408 ,748 Uniforms 27,400 Conferences - Seminars & Education 23 ,970 Travel 550 Freight , Express & Cartage 1,800 Environmental Charges 2 ,000 Cellul ar Phones 2,400 Telephone & Data 11,700 Internet 305 Subscriptions & Publications 200 Insurance Premium 5,555 Meals, Promotions & General 800 Memberships 1,025 Outside Agency Services 225 ,500 Building -Repairs & Ma intenance 5,000 Vehicle -Repairs & Maintenance 8 ,000 Gas, Oil, Tire, Etc. 19 ,290 Misc. Equip. -Repairs & Maintenance 5,000 Misc . Equip . Rentals 500 Forms 6 ,000 Supplies & Tools 62,875 Educational Material - Software & Hardware Mtce . Contracts 45,690 Misc . Equipment 2,000 Total Expenditures 2,324,003 Revenues Netted Revenue (193 ,000) Total Revenues (193,000) Transfers Total Transfers - 118 Run Date: Jan 25 , 2024 Increase I 2024 % Change Decrease Budget From 2023 61,286 1,468,981 4.35% -50,000 -% 26,483 435 ,231 6.48% 2 ,160 29 ,560 7.88% ---% (5,500) 18,470 (22 .95%) -550 -% -1,800 -% -2,000 -% -2,400 -% 2,600 14 ,300 22 .22% -305 -% -200 -% 835 6 ,390 15 .03% 200 1,000 25 .00% 200 1,225 19.51 % -225,500 -% -5,000 -% -8,000 -% 1,930 21,220 10 .01% -5,000 -% -500 -% -. 6 ,000 -% 17 ,125 80 ,000 27.24% ---% (24,740) 20,950 (54.15%) -2 ,000 -% 82,579 2,406,582 3.55% 12,400 (180,600) (6.42%) 12,400 (180,600) (6.42%) ---% 10310 Fleet Services 2022 2023 Actuals YTD Actuals 1,515,545 1,614,167 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Net Expenditures (Revenues) 2,131,003 11 9 Run Date : Jan 25 , 2024 Increase/ 2024 %Change Decrease Budget From 2023 94,979 2,225,982 4.46% 10315 Roads 2022 2023 Actuals YTD Actuals 3,227,440 3,223,686 308,205 216,887 835,573 895 ,973 49,418 39,680 1,218 1,201 11,749 15,043 54 752 875 1,314 1,528 - 4,677 6,145 2,624 2,927 343 372 -- 150,950 166 ,045 12,292 26,532 -- 3,166 2 ,161 2,851 4,337 52,746 29 ,014 782,575 639,848 175,124 285 ,327 59,315 196,582 218,543 256,411 456,713 440 ,175 116,640 82,320 92,083 71,069 135,718 149,282 222,657 131,074 364,498 383,979 534,005 511,999 198,788 209,392 71 - 40,147 51 ,368 26,595 45,321 -- 6,795 14,092 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 3 ,607,333 Overtime 286,500 Employee Benefits 943,484 Uniforms 31,870 Conferences - Seminars & Education 18 ,000 Travel 500 Freight, Express & Cartage - Environmental Charges - Cellular Phones 9 ,900 Telephone & Data 3,400 Internet 340 Subscriptions & Publications 200 Insurance Premium 166,045 Insurance Deductible 20,000 Consulting & Professional Fees 5 ,000 Meals, Promotions & General 4 ,000 Memberships 4,240 Outside Agency Services 69,500 Winter Control Maintenance 846,000 Repairs & Maintenance Contract Servic 248 ,600 Engineering -Repairs & Maintenance 383,500 Storm Sewer -Repairs & Maitenance 370,000 Repairs & Maintenance Materials 595,000 Highway Aids -Repairs & Maintenance 75,000 Engineering Highway Aids -Repairs & 120,000 Building -Repairs & Maintenance 149,100 Tree Maintenance 150,000 Vehicle -Repairs & Maintenance 340,000 Gas , Oil, Tire, Etc. 534,110 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 6,727 120 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 392,515 3,999,848 10.88% 28,500 315,000 9.95% 153,192 • 1,096,676 16 .24% 8,235 40,105 25 .84% ---% 1,000 19,000 5 .56% -500 -% ---% ---% 300 10,200 3.03% (500) 2,900 (14 .71%) -340 -% -200 -% 24,905 190 ,950 15 .00% 3,000 23,000 15.00% 10,000 15 ,000 200 .00% -4,000 -% -4,240 -% -69,500 -% 40,000 886,000 4 .73% 144,400 393,000 58 .09% (75,500) 308,000 (19.69%) -370,000 -% (25,000) 570,000 (4 .20%) 50 ,000 125,000 66.67% -120,000 -% (9,600) 139 ,500 (6.44%) 165,000 315,000 110.00% 40,000 380,000 11 .76% 106,040 640,150 19.85% 80,000 200,000 66.67% ---% 5,000 35,000 16.67% 5,000 20,000 33 .33% 500 14 ,500 3.57% (177) 6,550 (2.63%) 10315 Roads 2022 2023 Actuals YTD Actuals -7,891 8,095,976 8,108,199 (18,900) - (312 ,920) (382 ,807) (66,139) (49,236) (69,838) (119 ,772) (467,797) (551 ,815) -- -- -- 7,628,179 7,556,384 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Misc . Equipment 10,000 Total Expenditures 9,177,349 Revenues Federal Grants (9 ,000) Department User Fees (225,000) Other User Fees (75,000) Cost Recove ries (116 ,050) Total Revenues (425,050) Transfers Transfer to(from) Reserve (76 ,500) Transfer to (from) Oblig RF - Total Transfers (76,500) Net Expenditures (Revenues) 8,675,799 1 21 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 -10,000 -% 1,146,810 10,324,159 12.50% 9 ,000 -· (100.00%) 25 ,000 (200 ,000) (11.11 %) -(75 ,000) -% 102 ,925 (13 ,125) (88 .69 %) 136,925 (288 ,125) (32.21%) 76,500 -(100 .00%) (15 ,000) (15,000) -% 61 ,500 (15,000) (80.39%) 1,345,235 10,021,034 15.51% 10320 Parks 2022 2023 Actuals YTD Actuals 2,623,170 2,706,747 109,538 88,669 608,498 640,714 32,433 39,017 14,274 9,726 371 459 5,137 7 ,516 82 (57) 8,018 12,044 2,460 2,183 229 186 -- 17,850 19 ,635 -1,789 784 5,528 671 743 947 1,764 50 ,918 34,317 -45 ,529 54,961 46,871 -1,216 179,473 206,250 79,028 55,409 344 - 92,467 106,921 254,642 199,554 84,617 87,488 285 ,972 322,300 41 ,684 44,253 125 ,781 56,342 1,984 254 101,245 66,852 21,665 2,396 13,904 - 59,219 56 ,648 77,971 87,369 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 2,798,288 Overtime 108,000 Employee Benefits 606 ,551 Uniforms 30,200 Seminars & Education 12,145 Travel 500 Freight, Express & Cartage - Environmental Charges - Cellular Phones 7,300 Telephone & Data 2,500 Internet 530 Photo, Mapping, Print 200 Insurance Premium 19 ,635 Insurance Deductible 5,050 Consulting & Professional Fees 22,380 Meals , Promotions & General 1,100 Memberships 2,760 Outside Agency Services 54,200 Repairs & Maintenance Contract Servi< 155,600 Repairs & Maintenance Materials 47,500 Highway Aids -Repairs & Maintenance - Building -Repairs & Maintenance 191,190 Tree Maintenance 80,000 Lighting -Repairs & Maintenance - Vehicle -Repairs & Maintenance 94,000 Gas, Oil, Tire, Etc. 254 ,660 Misc. Equip . -Repairs & Maintenance 90 ,000 Grounds Upkeep 296,500 Fert . & Lawn Control 55,000 Misc . Equip . Rentals 102,000 Stationary & Office Supplies - Programs & Event Supplies 88,000 Supplies & Tools 4 ,000 COVID Related Expenses - Utilities -Water 64,600 Utilities -Hydro 84 ,225 122 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 391,502 3,189,790 13.99% -108,000 -% 157,476 764,027 25 .96% 1,300 31,500 4.30% (580) 11,565 (4 .78%) -500 - % --- % --- % 700 8,000 9.59% (100) 2,400 (4 .00%) -530 -% -200 - % 2,945 22,580 15.00% 760 5,810 15 .05% (10,000) 12,380 (44.68%) -1,100 - % 80 2,840 2 .90% (7,000) 47,200 (12.92%) 131,400 287,000 84.45% 10,500 58,000 22 .11% - - - % 75,900 267 ,090 39.70% 5,000 85,000 6.25% --- % -94,000 - % 20,820 275,480 8.18% -90,000 - % (12,000) 284,500 (4 .05%) -55,000 - % -102,000 - % --- % (15,000) 73,000 (17 .05%) 1,000 5,000 25.00% --- % 3,800 68,400 5.88% 9,575 93,800 11.37% City of Pickering 2024 Current Budget Summary 10325 Operations Services 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 674,838 720 ,341 Salaries & Wages 856,489 90 5,586 Overtime 5,000 178,919 211,126 Employee Benefits 240 ,325 1,538 509 Uniforms 5,435 -295 Conferences 2,600 1,135 6,768 Seminars & Education 3,650 5,057 2,471 Travel 4,000 1,775 3 ,856 Cellular Phones 4 ,345 2,044 2,056 Telephone & Data 2,500 267 261 Internet 350 --Subscriptions & Publications - --Photo, Mapping, Print 9 ,000 2,500 2,750 Insurance Premium 2,750 171,505 120,967 Consulting & Professional Fees 395,705 188 1,281 Meals, Promotions & General 1,000 2,939 4;114 Memberships 5,850 132 -Building -Repairs & Maintenance 2,000 2,757 2,250 Stationary & Office Supplies 5,900 81 -Supplies & Tools - 25,841 36,139 Software & Hardware Mtce. Contracts 61,930 --Furn iture & Fixtures 3,000 1,071,606 1,120,770 Total Expenditures 1,611,829 Revenues (6 ,000) (6 ,000) Municipal Rentals (6,000) -(10,702) Rebates & Incentives (40,000) (6,000) (16,702) Total Revenues (46,000) Transfers --Transfer to/(from) DC Oblg RF (67,500) 19,702 -Transfer to(from) Cntg Sty Res. (19,705) --Transfer to(from) Reserve (72,500) 19 ,702 -Total Transfers (159,705) 1,085,308 1,104,068 Net Expenditures (Revenues) 1,406,124 124 Run Date : Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 95,738 952 ,227 11.18% -5,000 -% 30,061 270,386 12.51% (250) 5,185 (4.60%) 2,100 4 ,700 80.77% 1,850 5 ,500 50 .68% 2 ,000 6,000 50 .00% (1,105) 3,240 (25.43%) (600) 1,900 (24.00%) -350 -% 200 200 -% -9,000 -% 410 3,160 14 .91% (65 ,756) 329 ,949 (16.62%) (200) 800 (20 .00%) 950 6 ,800 16.24% (2,000) -(100 .00%) (1,000) 4,900 (16 .95%) ---% (7,310) 54 ,620 (11 .80%) -3,000 -% 55,088 1,666,917 3.42% -(6,000) -% -(40,000) -% -(46,000) -% 33 ,705 (33,795) (49.93%) (43,678) (63 ,383) 221 .66% 56,229 (16,271) (77 .56%) 46,256 (113,449) (28.96%) 101,344 1,507,468 7.21% City of Pickering 2024 Current Budget Summary 10330 Major Capital Facilities 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures --Salaries & Wages 126,500 --Overtime 1,250 --Employee Benefits 34,800 --Uniforms - --Conferences - --Seminars & Education 1,000 --Travel 1,000 --Cellular Phones 1,200 --Telephone & Data 625 --Photo, Mapping , Print 2,250 --Insurance Premium 700 --Consulting & Professional Fees - --Meals, Promotions & General 250 --Memberships - --Bu ilding -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) - 125 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 268,632 395,132 212 .36% 3,750 5,000 300 .00 % 66,754 10 1,554 191.82% 1,575 1,575 -% 3,000 3,000 -% 3,000 4,000 300.00% 2,000 3,000 200.00% 1,620 2,820 135 .00 % (625) -(100.00 %) 6,750 9,000 300.00 % 2 ,050 2,750 292.86% 50,000 50 ,000 -% 750 1,000 300 .00 % 3,500 3 ,500 -% (1,850) -(100.00 %) 27 ,955 37 ,655 288 .20 % 2 ,250 3,000 300 .00% 400 500 400.00 % (6 ,080) 1,920 (76 .00%) 435,431 625,406 229.20% ---% (435,431) (625,406) 229.20% (435,431) (625,406) 229.20% ---% Corporate Services Department Overview The Corporate Services Department supports the City's ongoing operations by providing legal, legislative, municipal law enforcement and information technology services to Council and to all City Departments. ..., Corporate Services Department I I I I I ..., Information Legal Services Legislative Municipal Law Technology Services Enforcement .) .) ..., -City Clerk ~ By-law Enforceme nt ..., >---Records Mgmt >--- Parking & Elections Enforceme nt Print Shop/Mail Animal ~ -Room Services '"------.) '"------- 126 Corporate Services Department Key Activities for 2024 in Support of the Corporate Strategic Plan Corporate Key: Good Governance & Customer Service Excellence • Confirm site selection and proceed with design on new animal shelter. This shelter will provide better service to the community and partner organizations. • Complete new Sign By-law and Short-Term Rental Licensing By-Law. • Continue the Workplace Modernization Initiative. • Create a tax portal for residents to access their property tax information in a secure manner. • Implement Meeting Management Software. • Complete updates to the Council Code of Conduct. • Complete updates to the City's Record Retention Policies. Priority 1: Champion Economic Leadership and Innovation • Obtain federal grants for summer staffing in Municipal Law Enforcement Services (MLES) and Animal Services to offset costs and promote animal adoption. • Begin Digital Strategy, in accordance with Council's direction, for enhanced resident engagement. • Lead efforts to support the Tech Connect 2024 initiative to provide a platform for businesses in Pickering by connecting them with staff and technology vendors. Priority 2: Advocate for an Inclusive, Welcoming, Safe & Healthy Community • Implement Short Term Rental licensing to ensure properties are safe and address community complaints. • Offer ·satellite adoption centres to create volunteer opportunities and provide residents access to adoptable animals. • Implement Work Order Management solution with interface for residents to report problems or provide suggestions. Priority 3: Advance Innovation & Responsible Planning to Support a Connected, Well-Serviced Community • Implement account authentication for online services. • Redesign City of Pickering Website to include increased functionality and efficient content management. • Complete IT Capability Study to identify staffing levels required to meet the demands of a connected and well serviced municipality. • Implement enhancements to cybersecurity systems. 127 Corporate Services Department Priority 4: Lead & Advocate for Environmental Stewardship, Innovation & Resiliency • Install meeting room upgrades to support a hybrid workforce and workspace modernization enabling staff to collaborate from anywhere. • Enhance print services to reduce paper and ink use through SharePoint online and Laserfiche. Priority 5: Strengthen Existing and Building New Partnerships • Partner with Durham College to research and investigate opportunities for website and security enhancements. • Participate in senior technology leadership discussions with municipalities in Durham Region to support technology innovation and cybersecurity resilience. Priority 6: Foster an Engaged & Informed Community • Municipal Law Enforcement Services will continue to partner with post-secondary institutions to provide co-op placements for students. • Implement GIS Strategic Plan and GIS activities to provide improved access to information and inform residents of development and planning opportunities using Geospatial modeling. • Enhance the website to include a secure and personalized resident experience and integrate with online services to provide a one-stop shop for residents. 128 Financial Information Corporate Services Department Staffing Summary (Full & Regular Part-Time) Prior Term of Council Current Term of Council 2019 2020 2021 2022 2023 2024 Approved Add/ Delete Total Transfers Full-Time 38 41 41 43 49 4 -53 Reg. Part-Time 5 6 7 8 7 1 -8 Total 43 47 48 51 56 5 -61 The department is proposing the following staffing changes in 2024: • One new full-time Senior Project Manager for Digital Services. • Transfer of one full-time Supervisor, Geomatics position and one full-time Senior Geomatics Analyst position from City Development to Information Technology. GIS resources were transferred to Corporate Services, IT Division to support the GIS Strategic Plan as approved by Council. • One new full-time Parking Control Officer position. This position will assist with coverage for school zone enforcement and overnight coverage. It will fill scheduling gaps and reduce overtime and be funded from parking fine revenues. • One new part-time By-law Enforcement Officer position. This position will allow for expanded coverage and assist with overnight issues. It will also reduce overtime for overnight enforcement activities. Year-Over-Year (Net Cost) Budget Changes Year-Over-Year 2023 2024 Change Budget Budget ($) (%) Legal Services $624,573 $472,650 ($151,923) (24.32%) Information Technology 3,574,165 4,184,112 609,947 17.07% Clerk's Office 351,502 507,013 155,511 44.24% Records Mgmt. & Elections 177,016 196,625 19,609 11.08% Print Shop/Mail Room 561,750 583,123 21,373 3.80% By-Law Enforcement 290,071 53,744 (236,327) (81 .47%) Animal Services 586,532 629,712 43,180 7.36% Total (Net Cost) $6,165,609 $6,626,979 $461,370 7.48% 129 Corporate Services Department Explanation of Significant Departmental Budget Changes • Account Change Explanation Expenditures -Increase I (Decrease) Salaries & Wages Overtime Employee Benefits Consulting & Professional Services $492,259 Increase in salaries and wages is mainly due to three new staff positions (one full-time Senior Project Manager position, one full-time Parking Control Officer position and one part time By-law Enforcement Officer position), additional part-time hours for Animal Services (grant funded), transfer of two full-time positions from the City Development department, and annualization of 2023 approved positions, partially offset by one-time costs from 2023 Streamline grant completed. $19,511 Increase in overtime budget reflects need to have MLES officers cover special events, afterhours issues and address problems at bars as well as additional support required for the Clerks division due to an increase in the number and the length of Meetings of Standing Committees and Council. $177,916 Increase relates to benefit costs associated with new staff positions, annualization of 2023 approved positions and additional part-time staffing. Additional impacts include the increase in statutory benefits costs due to enhanced CPP rates and inflationary increases in group health benefit costs. ($199,825) Decrease largely reflects consulting projects completed in 2023, including legal projects: Cherrywood ($100,0000) and a portion of Frenchman's Bay ($35,325), IT Capability Study ($67,000) and PRISM project ($30,000), partially offset by an annual security assessment -$30,000, and a $20,000 increase in Integrity Commissioner requirements. 130 Account Outside Agency Services Building Repairs & Maintenance Land Rentals 1 Supplies & Tools Software & Hardware Maintenance Contracts Systems & Software Upgrades • Misc. Equipment Other Expenses • Total Expenditures Corporate Services Department Change $61,500 ($14,998) ($13,600) $20,498 $319,174 ($82,950) ($55,795) $37,060 $760,750 . Explanation . Increase is mainly due to 2024 changes to include • $40,800 in processing fees for Waterfront Parking on ' a gross basis (previously net). This has no overall budget impact. Additional costs also include new printers and signage for Waterfront Parking - • $13,000, administration and consulting costs for a ' new short Term Rental Licensing program -$20,000 (funded from the Municipal Accommodation tax reserve) and $12,000 for expanded veterinary and post-adoption program (funded from a PetSmart Charities grant), partially offset by ($32,000) for the Waterfront Parking wi-fi hub completed in 2023. Decrease reflects one-time costs for Information Technology staff relocation completed in 2023. Decrease due to anticipating leasing costs not required. Increase reflects Print Room increase in copier maintenance and supplies supporting greater corporate use. Increase is attributed to new/expanded enterprise software licensing requirements -$194,550, new meeting management software solution -$100,000, annual cost increases to parking software -$5,120 and additional Laserfiche licensing costs -$18,500. Decrease is due to one-time software purchases completed in 2023 (Vulnerability Management and new staff licensing). Decrease reflects net change in departmental IT requirements and one-time equipment purchases for new staff completed in 2023. Revenues -(Increase)/ Decrease Ontario Grants ; Department User Fees Other User Fee Revenues $251,680 • Decrease is related to the completion of the Streamline Development Approval Fund project in 2023. ($384,200) Increase reflects the transfer of Waterfront Parking revenues from Other User Fees to this category, along with expected revenue growth for 2024. $260,000 Decrease is due to the transfer of Waterfront Parking revenue from this category to Department User Fees. 131 Account Licenses & Permits Fines & Charges Other Revenues Total Revenues Corporate Services Department Change Explanation ($139,300) Increase reflects additional revenue from personal transportation company trips, lotteries and marriage licenses based on historical trends. ($378,000) Increase in anticipated parking fine revenue due to hiring of one additional enforcement officer in 2024. Increase also reflects improved payment of fines in plate denial that police are now enforcing. ($9,950) ($399,770) Transfers -(Increase)/ Decrease Continuing Studies Reserve Rate Stabilization Reserve Cherrywood Reserve Municipal Accommodation Tax Reserve Seaton Development Reserve Total Transfers Net Increase ($43,675) Increase related to legal work associated with Frenchman's Bay in 2023 which will be carried over into 2024. $67,000 Decrease is due to completion of the IT Capability Study in 2023 which was funded from this reserve. $100,000 Decrease reflects reserve funding no longer required. ($20,000) Funding from this reserve will offset the cost of the Short Term Rental enforcement software. ($2,935) $100,390 $461,370 132 Corporate Services Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2021 2022 2023 Information Technoloav Service Support Requests 6,841 6,723 7,906 Staff connection -remote staff 258 268 289 connections Employees trained in information 502 561 586 security awareness Systems Availability 98.9% 99.1% 99.6% Projects Completed 49 47 35 Leaislative Services Committee & Council Meetinr:is 70 66** 88 Burial Permits Issued 1081 1,109 992 Marriar:ie Licenses Issued 519 879 876 Freedom of Information Requests 60 36 56 **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 Inaugural Meeting of Council. Legal Services Development-related Ar:ireements 23 20 19 Instruments Registered in Teraview 84 101 73 (Land Registry Office) Enforcement Services ParkinQ Tickets Issued 17,690 31,753 33,612 Parkinq Fine Revenue $625,077 $1,448,700 $1,398,000 * COVID-19 Enforcement -# park 24,893 N/A N/A patrols By-law Violations Requests for 1,572 1,667 1,672 Service Parking Enforcement Requests for 1,133 1,336 1,448 Service Animal Services Requests for 942 779 1,040 Service Animals Sheltered ( cats/dogs/small 405 425 427 animals) Animals Adopted 211 280 297 Lost pets found and returned 85 100 89 * subject to increase per MTO reconciliation 133 City of Pickering · 2024 Current Budget Summary Corporate Services Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 4,111,103 4,239,788 Salaries & Wages 4,706,439 122,397 131 ,122 Overtime 98,239 985,974 1,068,350 Employee Benefits 1,200,908 336 -Employee Recognition - 14,374 17,695 Uniforms 21,400 3,843 3,157 Conferences 8,000 39 ,688 45,004 Seminars & Education 63,920 12,817 13,002 Corporate Training 18,000 1,914 1,428 Travel 4,200 224,009 164,363 Postage 156,000 4,376 3,175 Freight, Express & Cartage 4,500 10 -Environmental Charges - 19,982 25,557 Cellular Phones 27,660 24,901 22,608 Telephone & Data 24,815 1,910 1,560 Internet 2,140 104 997 Advertising 800 9,469 9,372 Subscriptions & Publications 8 ,835 10,556 12,400 Legal Services Expense 12,000 24,620 66,934 Insurance Premium 66,934 --Insurance Deductible 2,000 118,381 343,887 Consulting & Professional Fees 539,500 4,459 20,099 Meals, Promotions & General 11,500 3,902 4,423 Memberships 14,600 223,549 214,877 Outside Agency Services 177,800 23,134 10,744 Building -Repairs & Maintenance 25,358 18,963 16,643 Vehicle -Repairs & Maintenance 12,800 36,438 35,305 Gas, Oil, Tire, Etc . 39,155 16,500 24,932 Misc. Equip. -Repairs & Maintenance 47,300 15,571 15,916 Building Rentals 17,498 -16 Misc . Equip. Rentals - --Land Rentals 13,600 14,867 9,307 Stationary & Office Supplies 11,900 7,838 6,421 Forms 10,000 -842 Programs & Event Supplies - 229 ,716 226,141 Supplies & Tools 235,602 55,393 -COVID Related Expenses - 134 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 492,259 5,198,698 10.46% 19,511 117,750 19 .86% 177,916 1,378,824 14 .82% --- % 4,200 25 ,600 19.63% -8 ,000 - % 9,480 73,400 14 .83% 4,000 22,000 22 .22% 400 4,600 9.52% -156,000 - % -4,500 -% --- % 2,500 30,160 9.04% 3,785 28,600 15.25% -2,140 - % 1,500 2,300 187 .50% 1,875 10,710 21.22% -12,000 - % 4,062 70,996 6.07% 300 2,300 15.00% (199,825) 339,675 (37 .04%) (5,800) 5,700 (50.43%) (4,180) 10,420 (28.63%) 61,500 239,300 34 .59% (14,998) 10,360 (59 .15%) -12 ,800 - % 3,916 43,071 10.00% (5,000) 42,300 (10.57%) 282 17,780 1.61% --- % (13,600) -(100 .00%) 500 12,400 4.20% -10,000 -% 6,000 6,000 - % 20,498 256,100 8.70% --- % City of Pickering 2024 Current Budget Summary Corporate Services Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals -524 Utilities -Water 3,300 4,407 9,558 Utilities -Hydro 17,300 -946 Utilities -Natural Gas 6,700 5,106 4,861 Utilities -Oil 6,500 939 ,130 840,752 Software & Hardware Mtce. Contracts 965,071 50,204 126,961 System & Software Upgrade 146,700 33 ,181 67,540 Hardware Replacements 100,400 -559 Furniture & Fixtures - 22,775 262,100 Misc. Equipment 280 ,795 23,666 24,244 Parking MOT 75,000 755 -Livestock Killed 500 -8,801 Financial Services Charges - -(648) Exchange Rate -Gain or Loss - 7,460,318 8,102,263 Total Expenditures 9,185,669 Revenues (16,800) -Federal Grants (18,900) (103,200) -Ontario Grants (252,180) -(25,000) Other Agency Grants (30,000) (311,465) (630,698) Department User Fees (284,500) -(450) Event Vendor Fees - (373,140) (75,071) Other User Fees (340,000) (684,466) (637 ,858) Licences & Permits (504 ,000) (1,519,332) (1,441,552) Fines & Charges (1,302,000) (4,363) (16,133) Donations - (800) (2,000) Sponsorships (3,000) (1,250) (18,750) Marketing Sponsors (7,000) (3,014,816) (2,847,512) Total Revenues (2,741,580) Transfers --Transfer to(from) Cntg Sty Res . - (435,075) -Transfer to(from) Reserve (278,480) (435,075) -Total Transfers (278,480) 4,010,427 5,254,751 Net Expenditures (Revenues) 6,165,609 135 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 -3,300 -% (7,600) 9,700 (43.93%) (1,520) 5,180 (22.69%) 160 6,660 2.46% 319,174 1,284,245 33 .07% (82,950) 63,750 (56.54%) 9,600 110 ,000 9 .56% ---% (55,795) 225,000 (19 .87%) -75,000 -% -500 -% 8,600 8,600 -% ---% 760,750 9,946,419 8.28% -(18,900) -% 251 ,680 (500) (99.80%) (5,000) (35,000) 16.67% (384,200) (668 ,700) 135.04% (450) (450) -% 260,000 (80,000) (76.47%) (139,300) (643,300) 27.64% (378,000) (1,680,000) 29.03% (1,500) (1,500) -% -(3,000) -% (3,000) (10,000) 42.86% (399,770) (3,141,350) 14.58% (43,675) (43,675) -% 144,065 (134,415) (51.73%) 100,390 (178,090) (36.05%) 461,370 6,626,979 7.48% 10400 Legal Services 2022 2023 Actuals YTD Actuals 389,709 405,670 1,561 67 98 ,815 110,194 336 - 853 319 -- 1,499 1,948 1,170 883 153 112 9,255 8,733 10,556 12,400 3,530 3,883 77,499 217,035 442 3,349 2,653 2,862 1,808 1,426 161 - 691 - 600,691 768,881 (205,197) (241,412) (106) - (205,303) (241,412) -- -- -- 395,388 527,469 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 530 ,744 Overtime 1,500 Employee Benefits 131,441 Employee Recognition - Seminars & Education 4 ,500 Travel 750 Cellular Phones 1,600 Telephone & Data 1,215 Internet 150 Subscriptions & Publications 8,085 Legal Services Expense 12,000 Insurance Premium 3,883 Consulting & Professional Fees 290,000 Meals, Promotions & General 500 Memberships 6,550 Stationary & Office Supplies 1,500 Supplies & Tools - Software & Hardware Mtce. Contracts 635 Total Expenditures 995,053 Revenues Department User Fees (159,000) Other User Fees - Total Revenues (159,000) Transfers Transfer to(from) Cntg Sty Res . - Transfer to(from) Reserve (211,480) Total Transfers (211,480) Net Expenditures (Revenues) 624,573 136 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From2023 .14,756 545,500 2.78% -1,500 -% 12,189 143 ,630 9 .27% ---% 500 5,000 11 .11% -750 -% -1,600 -% 85 1,300 7 .00% -150 -% 1,925 10,010 23 .81% -12,000 -% 582 4,465 14.99% (126,325) 163,675 (43.56%) -500 -% -6,550 -% -1,500 -% ---% (25) 610 (3 .94%) (96,313) 898,740 (9.68%) (109,000) (268,000) 68 .55% ---% (109,000) (268,000) 68.55% (43,675) (43,675) -% 97,065 (114,415) (45 .90%) 53,390 (158 ,090) (25.25%) (151,923) 472,650 (24.32%' City of Pickering 2024 Current Budget Summary 10405 Information Technology 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 1,210,632 1,441,075 Salaries & Wages 1,563,013 62 ,098 78 ,605 Overtime 70,000 296,645 330,515 Employee Benefits 399,286 -726 Uniforms 800 2,347 2,334 Conferences 6,000 30,676 33,968 Seminars & Education 45,400 12,817 13,002 Corporate Training 18,000 1,433 920 Travel 1,200 15 -Freight, Express & Cartage - 11 -Environmental Charges - 10,625 10,469 Cellular Phones 10,800 4,996 4,882 Telephone & Data 5,700 610 593 Internet 850 -467 Subscriptions & Publications - 8,000 48,652 Insurance Premium 48,652 38,287 122 ,247 Consulting & Professional Fees 229,500 348 4,006 Meals, Promotions & General 1,000 454 463 Memberships 5,400 458 -Outside Agency Services 2,400 --Building -Repairs & Maintenance 15,000 10 -Vehicle -Repairs & Maintenance - 16,500 24,932 Misc . Equip. -Repairs & Maintenance 47,300 -141 Building Rentals - -16 Misc . Equip . Rentals - 147 759 Stationary & Office Supplies 3,700 -842 Programs & Event Supplies - -174 Supplies & Tools - 55,393 -COVID Related Expenses - -524 Utilities -Water 3,300 -3,601 Utilities -Hydro 12,000 -946 Utilities -Natural Gas 6,700 617,133 756,721 Software & Hardware Mtce. Contracts 868,949 50 ,204 126,961 System & Software Upgrade 146,700 33,181 67,540 Hardware Replacements 100,400 22,775 262,100 Misc . Equipment 280,795 -(638) Exchange Rate -Gain or Loss - 137 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 206,803 1,769,816 13.23% -70,000 -% 107,264 506,550 26.86% -800 -% -6,000 -% 8,000 53,400 17 .62% 4,000 22,000 22.22% 400 1,600 33.33% ---% ---% 2,500 13,300 23.15% 300 6,000 5.26% -850 -% ---% 1,319 49,971 2.71% (65,500) 164,000 (28.54%) 200 1,200 20.00% (4,500) 900 (83 .33%) -2,400 -% (15,000) -(100 .00%) ---% (5,000) 42,300 (10.57%) ---% ---% -3,700 -% ---% ---% ---% -3,300 -% (8,400) 3,600 (70 .00%) (1,520) 5,180 (22.69%) 194,546 1,063,495 22.39% (82 ,950) 63 ,750 (56 .54%) 9,600 110,000 9.56% (60,795) 220,000 (21.65%) --~ % City of Pickering 2024 Current Budget Summary 10405 Information Technology 2022 2023 2023 Actuals YTD Account Description Budget Actua ls 2,475,795 3,337,543 Total Expenditures 3,892,845 Revenues (102,415) -Ontario Grants (251,680) (102,415) -Total Revenues (251,680) Transfers --Transfer to(from) Reserve (67,000) --Total Transfers (67,000) 2,373,380 3,337,543 Net Expenditures (Revenues) 3,574,165 138 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Budget From2023 291,267 4,184,112 7.48% 251,680 -(100.00%) 251,680 -(100.00%) 67,000 -(100.00%) 67,000 -(100.00%) 609,947 4,184,112 17.07% 10410 Clerks Office 2022 2023 Actuals YTD Actuals 397,215 455,421 15,031 11 ,141 109,416 133,095 1,496 823 -1,220 189 - 464 1,079 1,749 1,173 229 149 214 172 2,600 2,860 -4,605 1,005 94 458 856 2,361 1,922 -205 527 5,088 532,954 619,903 (62,595) (90,580) (351,036) (332,546) (413,631) (423,126) -- 119,323 196,777 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 495,935 Overtime 2,000 Employee Benefits 144,582 Conferences 2,000 Seminars & Education 3,000 Travel 500 Cellular Phones 1,600 Telephone & Data 1,400 Internet 230 Subscriptions & Publications 700 Insurance Premium 2,860 Consulting & Professional Fees 10,000 Meals, Promotions & General 1,000 Memberships 1,000 Stationary & Office Supplies 2,000 Supplies & Tools - Software & Hardware Mtce. Contracts 5,695 Total Expenditures 674,502 Revenues Department User Fees (83,000) Licences & Permits (240,000) Total Revenues (323,000) Transfers Total Transfers - Net Expenditures (Revenues) 351,502 139 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Budget Frotn2023 63,330 559,265 12.77% 8,000 10,000 400 .00% 18,016 162,598 12.46% -2,000 -% -3,000 -% -500 -% -1,600 - % 800 2,200 57 .14% -230 -% -700 - % 430 3,290 15.03% -10,000 -% -1,000 -% -1,000 -% -2,000 -% ---% 99,935 105,630 1,754.78% 190 ,511 865,013 28.24% -(83,000) -% (35,000) (275,000) 14.58% (35,000) (358,000) 10.84% ---% 155,511 507,013 44.24% City of Pickering 2024 Current Budget Summary 10415 Records Management & Elections 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 106,844 19,135 Salaries & Wages 74,329 6,802 -Overtime 2,000 23,417 14,974 Employee Benefits 23,854 -865 Seminars & Education 1,500 --Travel 500 74,875 -Postage - 590 581 Telephone & Data 700 77 74 Internet 75 880 968 Insurance Premium 968 2,595 -Consulting & Professional Fees 10 ,000 --Memberships - 32,942 8,174 Outside Agency Services 11,000 5,631 682 Stationary & Office Supplies 2,000 298,239 45,292 Software & Hardware Mtce . Contracts 50,090 552,892 90,745 Total Expenditures 177,016 Revenues --Total Revenues - Transfers (435,075) -Transfer to(from) Reserve - (435,075) -Total Transfers - 117,817 90,745 Net Expenditures (Revenues) 177,016 140 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 2,256 76,585 3.04% -2,000 -% 1,586 25,440 6.65% -1,500 -% -500 -% ---% -700 -% -75 -% 147 1,115 15 .19% (8 ,000) 2 ,000 (80 .00%) 520 520 -% 4,600 15,600 41.82% -2,000 -% 18,500 68 ,590 36 .93% 19,609 196,625 11.08% ---% ---% ---% 19,609 196,625 11.08% City of Pickering 2024 Current Budget Summary 10420 Print Shop/Mail Room 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 111,140 108,801 Salaries & Wages 115,861 1,735 376 Overtime 1,000 28,124 30,164 Employee Benefits 29,854 149,134 164,363 Postage 156,000 4,361 3,175 Freight, Express & Cartage 4 ,500 590 581 Telephone & Data 700 77 74 Internet 75 2,380 2,618 Insurance Premium 2,618 34,975 37,142 Outside Agency Services 39,000 1,338 1,000 Stationary & Office Supplies 1,500 202,154 196,474 Supplies & Tools 210,502 158 -Software & Hardware Mtce. Contracts 140 536,166 544,768 Total Expenditures 561,750 Revenues -(615) Other User Fees - -(615) Total Revenues - Transfers --Total Transfers - 536,166 544,153 Net Expenditures (Revenues) 561 ,750 141 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 2,170 118,031 1.87% -1,000 -% 1,123 30,977 3 .76% -156,000 -% -4,500 -% -700 -% -75 -% 392 3,010 14.97% 1,000 40,000 2.56% 500 2,000 33.33% 14,998 225,500 7.12% 1,190 1,330 850.00% 21,373 583,123 3 .80% ---% - - -% ---% 21,373 583,123 3.80% 10425 By-Law 2022 2023 Actuals YTD Actuals 1,438,311 1,343 ,629 25,568 26,982 330,652 339,222 11,441 12,646 6,265 7,223 10 189 (1) - 6,166 6,346 4,383 3,218 573 409 4,920 5,412 -- 237 242 91,966 120,134 11 ,066 14,490 28,289 26 ,816 2 ,753 2,950 7,838 6,421 744 454 18,186 26,929 23,666 24,244 -8,801 2,013,033 1,976,757 (12 ,600) - -(241 ,006) (340,745) (43,813) (288,001) (262 ,882) (1,515 ,292) (1,439,987) (2 ,156,638) (1,987,688) -- -- City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 1,440,640 Overtime 15,739 Employee Benefits 369 ,709 Uniforms 16,600 Seminars & Education 8,000 Travel 900 Environmental Charges - Cellular Phones 10,760 Telephone & Data 3,700 Internet 570 Insurance Premium 5,412 Insurance Deductible 2,000 Membersh ips 1,000 Outside Agency Services 86,500 Vehicle -Repairs & Maintenance 10,000 Gas, Oil, Tire, Etc. 29,160 Stationary & Office Supplies 600 Forms 10,000 Supplies & Tools 2,000 Software & Hardware Mtce. Contracts 29,381 Parking MOT 75,000 Financial Services Charges - Total Expenditures 2,117,671 Revenues Federal Grants (12,600) Department User Fees - Other User Fees (310 ,000) Licences & Permits (205,000) Fines & Charges (1,300 ,000) Total Revenues (1,827,600) Transfers Transfer to(from) Reserve - Total Transfers - 142 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From2023 180,459 1,621,099 12 .53% 11,511 27,250 73 .14% 20,725 390,434 5.61% 2,500 19,100 15.06% (1,000) 7 ,000 (12 .50%) -900 - % --- % -10 ,760 -% 2,400 6 ,100 64 .86% -570 - % 813 6,225 15 .02% 300 2,300 15.00% -1,000 - % 43,900 130,400 50.75% -10,000 - % 2,916 32,076 10.00% -600 - % -10,000 - % -2,000 - % 5,049 34,430 17 .18% -75,000 -% 8 ,600 8 ,600 - % 278,173 2,395,844 13.14% -(12,600) -% (272,200) (272 ,200) -% 260,000 (50,000) (83 .87%) (104,300) (309,300) 50 .88% (378,000) (1 ,678,000) 29.08% (494,500) (2,322,100) 27.06% (20,000) (20,000) - % (20,000) (20,000) - % 10425 By-Law 2022 2023 Actuals YTD Actuals (143,605) (10 ,931) City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Net Expenditures (Revenues) 290,071 143 Run Date : Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 (236,327) 53,744 (81.47%1 10430 Animal Services 2022 2023 Actuals YTD Actuals 457,252 466,057 9,602 13,951 98,905 110,186 2,933 4,323 1,894 1,409 282 319 1,228 5,715 11,423 11,290 191 149 104 997 -- 2,310 2,541 2 ,664 12,650 100 - 63,208 49,427 23,134 10,744 7,887 2,153 8,149 8,489 15,571 15,775 -- 829 568 -- 26 ,657 28,834 4,407 5,957 5,106 4,861 4,196 6,722 -559 -- 755 - -(10) 748,787 763,666 (4,200) - (785) - -(25,000) City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 485,917 Overtime 6,000 Employee Benefits 102,182 Uniforms 4,000 Seminars & Education 1,520 Travel 350 Cellular Phones 2,900 Telephone & Data 11,400 Internet 190 Advertising 800 Subscriptions & Publications 50 Insurance Premium 2,541 Meals, Promotions & General 9,000 Memberships 650 Outside Agency Services 38,900 Building -Repairs & Maintenance 10,358 Vehicle -Repairs & Maintenance 2,800 Gas, Oil, Tire, Etc. 9,995 Building Rentals 17,498 Land Rentals 13,600 Stationary & Office Supplies 600 Programs & Event Supplies - Supplies & Tools 23,100 Utilities -Hydro 5,300 Utilities -Oil 6,500 Software & Hardware Mtce. Contracts 10,181 Furniture & Fixtures - Misc . Equipment - Livestock Killed 500 Exchange Rate -Gain or Loss - Total Expenditures 766,832 Revenues Federal Grants (6,300) Ontario Grants (500) Other Agency Grants (30,000) 144 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From2G23 • 22,485 508,402 4.63% -6,000 - % 17,013 119,195 16 .65% 1,700 5,700 42.50% 1,980 3,500 130.26% -350 - % -2,900 -% 200 11,600 1.75% -190 - % 1,500 2,300 187 .50% (50) -(100.00%) 379 2,920 14 .92% (6,000) 3,000 (66.67%) (200) 450 (30 .77%) 12,000 50,900 30.85% 2 10,360 0 .02% -2,800 - % 1,000 10,995 10 .01% 282 17,780 1.61% (13,600) -(100 .00%) -600 - % 6,000 6,000 - % 5,500 28,600 23.81% 800 6,100 15.09% 160 6,660 2.46% (21) 10,160 (0.21%) ---% 5,000 5,000 - % -500 - % --- % 56,130 822,962 7.32% -(6,300) - % -(500) - % (5,000) (35,000) 16 .67% 10430 Animal Services 2022 2023 Actuals YTD Actuals (43,673) (57,700) -(450) (32,289) (30,643) (45,429) (42,430) (4,040) (1,565) (4,363) (16,133) (800) (2,000) (1 ,250) (18,750) (136,829) (194,671) -- 611,958 568,995 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Department User Fees (42,500) Event Vendor Fees - other User Fees (30,000) Licences & Permits (59,000) Fines & Charges (2,000) Donations - Sponsorships (3,000) Marketing Sponsors (7,000) Total Revenues (180,300) Transfers Total Transfers - Net Expenditures (Revenues) 586,532 145 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget F,om 2023 (3 ,000) (45,500) 7.06% (450) (450) - % -(30,000) -% -(59,000) - % -(2,000) - % (1,500) (1,500) -% -(3,000) -% (3,000) (10,000) 42.86% (12,950) (193,250) 7.18% - - - % 43,180 629,712 7.36% 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 streetlights and sidewalks) • Water Resources & Development Services • Landscape & Parks Development • Transportation & Traffic (includes the area of crossing guards) r 'I Engineering Services Department '-,) I I I I I r 'I r 'I r 'I r '\ Transportation & Capital Projects & Water Resources Infrastructure * & Development Services '-'-~ *Includes Streetlights and Sidewalks **Includes Crossing Guards Landscape & Parks Traffic** Development '-~ '-~ 146 Engineering Services Department Key Activities for 2024 in Support of the Corporate Strategic Plan Priority 2: Advocate for an Inclusive, Welcoming, Safe & Healthy Community • Completion of Accessible Playground Projects. • Undertake comprehensive review of municipal servicing submissions related to Seaton, Pickering Town Centre lands, and other development areas. Priority 3: Advance Innovation & Responsible Planning to Support a Connected, Well-Serviced Community • Design/Construction of Hwy 7 and Sideline 24 Intersection Improvements/Signalization. • Completion of City Centre Transportation Master Plan. • Implementation of Beachfront Park Master Plan Phase 1 Construction. Priority 4: Lead & Advocate for Environmental Stewardship, Innovation & Resiliency • Design/Construction of Whitevale Master Drainage Plan Project. • Update Fill & Topsoil Disturbance By-law. • Completion of Pine Creek Erosion Assessment Study. • Completion of Rouge Stormwater Management Pond Cleanout. • Prepare Foundation Drainage Discharge Policy. Priority 6: Foster an Engaged & Informed Community • Public EngagemenUDesign for City Centre Park (Glenanna Road). 147 Financial Information Engineering Services Department Staffing Summary (Full & Regular Part-Time) Prior Term of Council Current Term of Council 2019 2020 2021 2022 2023 2024 Approved Add Delete Full-Time 30 30 30 32 36 1 - Reg. Part-Time ------- Total 30 30 30 32 36 1 - The department is proposing to add the following new position in 2024: Total 37 - 37 • One new full-time Coordinator, Forestry Management position in order to maintain a healthy forest canopy and to deal more efficiently with customer care calls regarding tree-related issues. Year-Over-Year (Net Cost) Budget Changes Year-Over-Year 2023 2024 Change Budget Budget ($) (%) Eng. Services -Admin. $2,731,534 $3,097,513 $365,979 13.40% Crossing Guards 434,140 601,035 166,895 38.44% Water Res. & Dev. Serv. 858,312 781,144 (77,168) (8.99%) Sidewalks 235,654 265,005 29,351 12.46% Streetlights 1,019,848 1,109,150 89,302 8.76% Total (Net Cost) $5,279,488 $5,853,847 $574,359 10.88% 148 Engineering Services Department Explanation of Significant Departmental Budget Changes Account Change Explanation Expenditures -Increase/ (Decrease) Salaries & Wages $267,729 Increase due to addition of one new full-time Coordinator, Forestry Management position in 2024 and annualization of four positions approved in 2023, partially offset by elimination of one contract position which is no longer required. Employee Benefits $72,665 Increase in benefit costs related to addition of the above new position in 2024 and annualization of four positions approved in 2023, partially offset by the elimination of one full-time contract position which is no longer required. Additional impacts include the increase in statutory benefits costs due to enhanced CPP rates and inflationary increases in group health benefit costs. Insurance Premium $29,155 Increase reflects higher premium renewal costs for 2024. Consulting & ($134,536) Decrease related to 2023 projects/studies that have Professional Services progressed or are completed. Outside Agency $184,700 Increase largely due to additional costs associated Services with the 2023 school crossing guard contract - $166,500 and anticipated Automated Speed Enforcement costs -$17,000. Repairs & Maintenance ($10,000) Decrease due to the 2023 budget including sidewalk Materials and curb repairs carried forward from 2022 which was completed. Building Rentals ($19,400) Decrease attributed to elimination of one-time provision for rental cost which is not required. Utilities -Hydro $98,200 Increase reflects last year's actual streetlighting costs and price increases expected for 2024. Misc. Equipment ($31,500) Decrease attributed to elimination of one-time provision for equipment needs which is not required. Other Fixed Assets ($225,000) Decrease due to the 2023 budget including sidewalk repairs for 2022 which were completed. Other Expenses $7,990 Total Expenditures $240,003 149 Engineering Services Department Account Change Explanation Revenues-(Increase)/ Decrease Department User Fees ($249,500) Increase reflects higher anticipated activity and associated fees related to development activity. Cost Recoveries $72,540 Decrease primarily due to removal of external funding for a contract position which is no longer required. Other Revenues $5,500 Total Revenues ($171,460) Transfers -(Increase)/ Decrease Development Charges $51,147 Decrease due to completion of Development Charge Reserve Fund funded consulting & professional projects/assignments in 2023. Continuing Studies Reserve Rate Stabilization . Reserve Cherrywood Reserve Canada Community- Building Reserve Fund (formerly Federal Gas Tax) Total Transfers Net Increase $50, 138 Decrease reflects completion of consulting & professional projects/assignments carried forward in 2023. $10,251 Decrease attributed to completion of the Claremont Drainage Plan in 2023 . $169,280 One-time funding not required. $225,000 Decrease is due to completion of 2022 sidewalk repairs completed in 2023. $505,816 $574,359 150 Engineering Services Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2021 2022 2023 Driveway widening/curb cut 95 138 112 applications Pool enclosure applications 94 62 31 Fill permit applications 9 7 10 Centreline km of roads 352/101 353/101 360/99 (paved/unpaved) Number of bridges/culverts > 3m 66 72 72 (vehicular/pedestrian) Storm sewers 343 km 328 km 338 km Stormwater Management Facilities 20 20 20 (Ponds) Sidewalks/trails 441 km 443 km 447 km Streetliqhts 8,546 8,956 9,130 Cyclinq lanes 25.3 km 25.3 km 25.3 km Traffic/pedestrian siq nals 25 25 25 School crossinq quard locations 36 36 36 151 City of Pickering 2024 Current Budget Summary Engineering Services Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 2,615,290 2,704,370 Salaries & Wages 3,488,302 17 ,243 11 ,755 Overtime 15,900 688,695 754,979 Employee Benefits 948 ,216 1,316 2,359 Uniforms 3,500 --Conferences 1,000 1,757 5,060 Seminars & Education 10 ,960 14 436 Travel 2,000 8,016 12 ,805 Cellular Phones 14,390 8,756 8,772 Telephone & Data 10 ,200 1,144 1,114 Internet 1,110 --Subscriptions & Publications 1,150 1,860 2,938 Photo, Mapping, Print 4,000 176,700 194 ,370 Insurance Premium 194,370 27 ,078 6,516 Insurance Deductible 32,950 168,020 159,469 Consulting & Professional Fees 855,291 6,913 154 Meals , Promotions & General 500 5 ,926 6,979 Memberships 10,285 540,631 451,289 Outside Agency Services 685 ,300 18,708 26 ,504 Repairs & Maintenance Materials 40 ,000 --Building -Repairs & Maintenance 3,700 7,668 7,500 Vehicle -Repairs & Maintenance 10,000 13,677 13,771 Gas , Oil, Tire, Etc. 15 ,000 283 ,223 245,750 Misc. Equip . -Repairs & Maintenance 461,200 --Building Rentals 19,400 --Misc . Equip. Rentals 200 2,597 4,697 Stationary & Office Supplies 3,800 --Forms 750 61 -Programs & Event Supplies - 5,239 878 Supplies & Tools 8,650 453,529 512 ,975 Utilities -Hydro 475,000 32,560 24,213 Software & Hardware Mice . Contracts 60,975 37,592 39 ,807 Misc . Equipment 81 ,500 5,151 201,599 Other Fixed Assets 510,000 5,129,364 5,401,059 Total Expenditures 7,969,599 Revenues 152 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 267,729 3,756,031 7.68% (1,900) 14,000 (11 .95%) 72 ,665 1,020,881 7.66% 1,030 4,530 29.43% (500) 500 (50 .00%) 9,555 20,515 87 .18% (750) 1,250 (37.50%) 1,370 15,760 9.52% 1,300 11,500 12 .75% -1,110 • - % (550) 600 (47 .83%) -4,000 -% 29,155 223,525 15.00% 4,945 37,895 15.01% (134,536) 720,755 (15.73%) -500 - % 1,295 11,580 12.59% 184,700 870,000 26 .95% (10,000) 30,000 (25 .00%) (3,700) -(100.00%) -10,000 -% 950, 15 ,950 6.33% -461,200 -% (19,400) -(100.00%) -200 - % 400 4,200 10.53% (450) 300 (60 .00%) --- % (350) 8,300 (4.05%) 98,200 573 ,200 20 .67% (4,655) 56,320 (7.63%) (31,500) 50,000 (38 .65%) (225,000) 285,000 (44 .12%) 240,003 8,209,602 3.01% City of Pickering 2024 Current Budget Summary Engineering Services Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals (2,309 ,277) (3,248,625) Department User Fees (1,210 ,500) (108,322) (7,180) Other User Fees (2,000) -(775) Licences & Permits (7,500) --Misc . Revenue (500) (66,950) (302,498) Cost Recoveries (332,540) (2,484,549) (3 ,559,078) Total Revenues (1,553,040) Transfers (70,644) -Transfer to/(from) DC Oblg RF (380,246) 76,889 -Transfer to(from) Cntg Sty Res . (127,294) --Transfer to(from) Reserve (179,531) --Transfer to (from) Oblig RF (450,000) 6,245 -Total Transfers (1,137,071) 2,651,060 1,841,981 Net Expenditures (Revenues) 5,279 ,488 153 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From2023 (249,500). (1,460,000) 20.61% (2 ,000) (4,000) 100 .00% 7,500 -(100 .00%) -(500) -% 72,540 (260,000) (21.81%) (171,460) (1,724,500) 11.04% 51,147 (329,099) (13.45%) 50 ,138 (77,156) (39 .39%) 179,531 -(100.00%) 225,000 (225,000) (50 .00%) 505,816 (631,255) (44.48%) 574,359 5,853,847 10.88% City of Pickering 2024 Current Budget Summary 10500 Engineering Services -Administration 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 1,430,094 1,468,368 Salaries & Wages 1,865,620 11,764 7,795 Overtime 9,500 388,043 425 ,718 Employee Benefits 509,105 665 1,084 Uniforms 2,000 --Conferences 1,000 619 577 Seminars & Education 3,860 14 17 Travel 750 4,710 7,174 Cellular Phones 6,770 4 ,668 5,263 Telephone & Data 6,100 610 668 Internet 610 --Subscriptions & Publications 500 1,860 2,938 Photo , Mapping, Print 4,000 9,590 10,549 Insurance Premium 10,549 --Insurance Deductible 2 ,000 104,773 75,677 Consulting & Professional Fees 390,473 6 ,913 129 Meals, Promotions & General 400 3,780 4,407 Memberships 5,740 129,771 85,413 Outside Agency Services 235 ,800 1,935 4 ,628 Vehicle -Repairs & Maintenance 5,000 5,721 5,462 Gas , Oil, Tire, Etc . 6,190 --Misc. Equip . -Repairs & Maintenance 200 --Misc . Equip . Rentals 200 1,683 2,689 Stationary & Office Supplies 2,100 --Forms 750 61 -Programs & Event Supplies - 495 764 Supplies & Tools 150 21 ,140 16,846 Software & Hardware Mtce. Contracts 45,640 37 ,592 39,807 Misc. Equipment 51,500 2,166,501 2,165,973 Total Expenditures 3,166,507 Revenues 200 (7,180) Other User Fees (2 ,000) -(201,429) Cost Recoveries (233,000) 200 (208,609) Total Revenues (235,000) Transfers 154 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From2023 297,826 2,163,446 15 .96% -9,500 - % 91,303 600,408 17 .93% -2,000 -% (500) 500 (50 .00%) 3,340 7 ,200 86 .53% (250) 500 (33 .33%) 3,050 9,820 45.05% -6,100 - % -610 -% -500 - % -4,000 - % 1,581 12,130 14 .99% 300 2,300 15 .00 % (68 ,665) 321 ,808 (17 .59%) -400 - % 350 6,090 6 .10% 18 ,200 254 ,000 7 .72% -5,000 - % 619 6,809 10 .00% -200 - % -200 - % 900 3,000 42.86% (450) 300 (60 .00%) --- % 150 300 100.00% (16,940) 28,700 (37.12%) (1,500) 50,000 (2.91%) 329,314 3,495,821 10.40% (2 ,000) (4 ,000) 100.00% (17,000) (250,000) 7.30% (19,000) (254,000) 8.09% City of Pickering 2024 Current Budget Summary 10500 Engineering Services -Administration 2022 2023 2023 Actuals YTD Account Description Budget Actuals (67 ,031) -Transfer to/(from) DC Oblg RF (168,514) 31,460 -Transfer to(from) Cntg Sty Res. (31,459) (35,571) -Total Transfers (199,973) 2,131,130 1,957,364 Net Expenditures (Revenues) 2,731,534 155 Run Date : Jan 25 , 2024 Increase I 2024 %Change Decrease Budget From 2023 38,637 (129 ,877) (22 .93%) 17,028 (14,431) (54 .13%) 55,665 (144,308) (27.84%) 365,979 3,097,513 13.40% 10505 Crossing Guards 2022 2023 Actuals YTD Actuals -72,146 -5,062 2,400 2,640 -25 399,432 350,726 401,832 430,599 - - -- 401 ,832 430,599 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages - Employee Benefits - Insurance Premium 2,640 Meals, Promotions & General - Outside Agency Services 431,500 Total Expenditures 434,140 Revenues Total Revenues - Transfers Total Transfers - Net Expenditures (Revenues) 434,140 156 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 ---% ---% 395 3,035 14.96% ---% 166,500 598,000 38 .59% 166,895 601,035 38.44% ---% - --% 166,895 601,035 38.44% City of Pickering 2024 Current Budget Summary 10510 Water Resources & Development Services 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 1,185,196 1,163,856 Salaries & Wages 1,622,682 5,479 3,960 Overtime 6,400 300,652 324,199 Employee Benefits 439,111 651 1,275 Uniforms 1,500 1,138 4,483 Seminars & Education 7,100 -419 Travel 1,250 3,306 5,631 Cellular Phones 7,620 4,088 3,509 Telephone & Data 4 ,100 534 446 Internet 500 --Subscriptions & Publications 650 7,390 8,129 Insurance Premium 8,129 986 513 Insurance Deductible 1,000 60,001 73,820 Consulting & Professional Fees 440,446 --Meals , Promotions & General 100 2,146 2,572 Memberships 4,545 6 ,848 10,171 Repairs & Maintenance Materials 20,000 --Building -Repairs & Maintenance 3,700 5,733 2,872 Vehicle -Repairs & Maintenance 5,000 7,956 8,309 Gas, Oil, Tire , Etc. 8,810 1,017 -Misc . Equip . -Repairs & Maintenance 1,000 --Building Rentals 19,400 914 2,008 Stationary & Office Supplies 1,700 4 ,744 114 Supplies & Tools 8,500 11,420 7,367 Software & Hardware Mtce . Contracts 15,335 --Misc. Equipment 30,000 1,610,199 1,623,653 Total Expenditures 2,658,578 Revenues (2 ,309,277) (3,248 ,625) Department User Fees (1,210,500) -(775) Licences & Perm its (7 ,500) (66,950) (101 ,069) Cost Recoveries (99,540) (2,376,227) (3,350,469) Total Revenues {1,317,540) Transfers (3,613) -Transfer to/(from) DC Oblg RF (211,732) 44,157 -Transfer to(from) Cntg Sty Res. (91,463) 157 Run Date : Jan 25, 2024 Increase I 2024 %Change Decrease Budget From2023 (30,097) 1,592 ;585 (1.85%) (1 ,900) 4,500 (29 .69%) (18 ,638) 420,473 (4 .24%) 1,030 2,530 68.67% 6,215 13 ,315 87 .54% (500) 750 (40 .00%) (1,680) 5,940 (22 .05%) 1,300 5,400 31 .71% -500 - % (550) 100 (84 .62%) 1,221 9,350 15.02% 150 1,150 15 .00% (65,870) 374,576 (14.96%) -100 - % 945 5,490 20.79% (10,000) 10,000 (50 .00%) (3,700) -(100.00%) -5,000 - % 331 9,141 3 .76% -1,000 -% (19,400) -(100.00%) (500) 1,200 (29.41%) (500) 8,000 (5.88%) 12 ,285 27,620 80.11% (30,000) -(100 .00%) (159,858) 2,498,720 (6.01%) (249,500) (1,460,000) 20 .61% 7,500 -(100 .00%) 89,540 (10,000) (89.95%) (152,460) (1,470,000) 11.57% 12,510 (199,222) (5 .91%) 43,109 (48 ,354) (47 .13%) City of Pickering 2024 Current Budget Summary 10510 Water Resources & Development Services 2022 2023 2023 Actuals YTD Account Description Budget Actuals --Transfer to(from) Reserve (179,531) 40,544 -Total Transfers (482,726) (725,484) (1,726,816) Net Expenditures (Revenues) 858,312 158 Run Date : Jan 25, 2024 Increase I 2024 %Change Decrease Budget From2023 179,531 -(100 .00%) 235,150 (247,576) (48.71%) (77,168) 781,144 (8.99%' 10515 Sidewalks 2022 2023 Actuals YTD Actuals 150,640 165,704 26 ,092 6,003 11,860 16,333 5,151 199,388 193,743 387,428 (105,432) - (105,432) - -- -- 88,311 387,428 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Insurance Premium 165,704 Insurance Deductible 29,950 Repairs & Maintenance Materials 20,000 Other Fixed Assets 470,000 Total Expenditures 685,654 Revenues Other User Fees - Total Revenues - Transfers Transfer to (from) Oblig RF (450,000) Total Transfers (450,000) Net Expenditures (Revenues) 235,654 159 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 24,856 190,560 15 .00% 4,495 34,445 15 .01% -20 ,000 - % (225,000) 245,000 (47 .87%) (195,649) 490,005 (28.53%) ---% --- % 225,000 (225,000) (50 .00%) 225,000 (225,000) (50.00%) 29,351 265,005 12.46% 10520 Streetlights 2022 2023 Actuals YTD Actuals 6,680 7,348 3,246 9,972 11,428 15,150 282 ,206 245 ,750 453,529 512 ,975 -2,211 757,089 793 ,406 (3 ,090) - -- (3,090} - 1,272 - 1,272 - 755 ,271 793,406 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Insurance Premium 7 ,348 Consulting & Professional Fees 24,372 Outside Agency Services 18,000 Misc. Equip . -Repairs & Maintenance 460 ,000 Utilities -Hydro 475 ,000 Other Fixed Assets 40,000 Total Expenditures 1,024,720 Revenues Other User Fees - Misc . Revenue (500) Total Revenues (500} Transfers Transfer to(from) Cntg Sty Res . (4,372) Total Transfers (4,372} Net Expenditures (Revenues} 1,019,848 160 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Btt dget From2Q23 1,102 8,450 15 .00% (1) 24,371 -% -18,000 - % -460,000 -% 98,200 573,200 20 .67% -40,000 - % 99,301 1,124,021 9.69% --- % -(500) - % -(500} - % (9,999) (14,371) 228 .71% (9,999} (14,371} 228.71% 89,302 1,109,150 8.76% 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 systems and 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 the finance and accounting functions identified above. Finance Department I I I I I I '\ SAP& Taxation Budgets & Accounting Supply & Financial Risk Mgmt. Services Services Systems 1 61 Finance Department Key Activities for 2024 in Support of the Corporate Strategic Plan Corporate Key: Good Governance & Customer Service Excellence • Create a tax portal for residents to access their tax financial information securely. • Manage assessment appeals to protect the property tax base. • Undertake proactive approach as it relates to Pickering Nuclear Power Plant assessment. • Increased SAP training for City staff to move to intermediate knowledge base. • Explore adding web-based functionality through a standard payment processing portal. • Project lead for e-commerce portion of City's Digital Strategy (subject to Council approval). • Implement the new accounting standard for Asset Retirement Obligations. • Update the City's Purchasing Policy (PUR-01) and procedures to comply with new public procurement legislation. • Implement standard contracts to replace purchase orders as the contract (e.g., services, consulting, construction). • Establish new centralized procurement processes for the management of contract administration and vendor performance. • Continue to develop the City's Asset Management Plan to meet 0. Reg 588/17 (Phase II). • Pursue options for addressing inadequate Development Charge revenues for the City's growth-related capital program. • Work with other departments to implement the Municipal Accommodation Tax. Priority 6: Foster an Engaged & Informed Community • Present YouTube Virtual Capital Budget presentation and Q&A with Director, Finance & Treasurer. 162 Financial Information Finance Department Staffing Summary (Full & Regular Part-Time) Prior Term of Council Current Term of Council 2019 2020 2021 2022 2023 2024 Approved Add Delete Full-Time 26 27 28 31 34 1 - Reg. Part-Time ------- Total 26 27 28 31 34 1 - Total 35 - 35 The department is proposing to add one new full-time Purchasing Contract Specialist position to the Supply & Services team to support organizational growth. Year-Over-Year (Net Cost) Budget Changes Finance Supply & Services Total (Net Cost) 2023 Budget $564,989 707,863 $1,272,852 2024 Budget $252,582 734,024 $986,606 163 Year-Over-Year Change ($) ($ 312,407) 26,161 ($286,246) (%) (55.29%) 3.70% (22.49%) Finance Department Explanation of Significant Departmental Budget Changes Account Change Explanation Expenditures -Increase/ (Decrease) Salaries and Wages $365,772 Increase due fo the addition of one new full-time Purchasing Contract Specialist position in 2024 as well as the annualization impact of the four positions approved in 2023 and a workplace accommodation. These positions were required to meet the continued demands of organizational growth. Employee Benefits $167,092 Increase reflects benefit costs associated with new staff and annualization of 2023 approved positions. Additional impacts include the increase in statutory benefits costs due to enhanced CPP rates and inflationary increases in group health benefit costs. Data Processing $15,000 Increase attributed to higher fees and volume of Services payroll transactions handled each year. Consulting & $111,320 Increase primarily due to $100,000 for Asset Professional Services Retirement Obligations (ARB) accounting standard implementation, $90,000 for Development Charge • Study/ Amendment (funded from Development Charges), $45,000 for property assessment data review (funded from the Assessment Appeals Reserve), $34,500 for Proposed Level of Service Framework Asset Management sessions, required for legislative compliance (funded from Canada Community Building Fund -formally FGT), $10,000 related to review of taxation on PIL properties. These increases are partially offset by one-time consulting projects completed or partially completed in 2023 including: ($63,000) Asset Management Planning and Strategy, ($50,000) Financial Impact Study and ($43,000) related to Procurement Policy review. Software & Hardware $235,875 Increase resulting from growth in licensed users of Maintenance Contracts the City's financial system as well inflationary price increases. Financial Service $45,000 Increase reflects the current volume of electronic Charges payments processed. Other Expenses $10,645 Total Expenditures $950,704 164 Finance Department • Account Change Explanation Revenues -(Increase)/ Decrease Department User Fees Penalties & Interest Investment Income Other Contributions Total Revenues ($10,000) Increase is due to higher expected volumes of tax certificates, receipts and arrears fees resulting from population growth. ($225,000) Increase reflects actual revenues from 2022 and 2023. ($775,000) Increase attributed to higher interest rates which increases income on investments. $50,000 Decrease is due to one-time third-party contributions for development-related studies completed in 2023. ($960,000) Transfers -(Increase)/ Decrease Development Charges Reserve Fund Continuing Studies Reserve Assessment Appeals Reserve Financial Systems Reserve Other Reserve Transfers Canada Community- Building Reserve Fund Total Transfers Net Increase ($90,000) Increase is for a Development Charge Background Study I Amendment, required to address inadequate Development Charge funding for the growth-related capital program. $7,600 Decrease is due to studies completed in 2023. ($45,000) Increase is for Property Assessment Data Review and Analytic Services. ($112,500) Increase reflects higher annual software license fees for the City's .financial system. $2,850 ($39,900) Increase is related to the City's asset management initiatives in 2024 (legislative requirement). ($276,950) ($286,246) 165 Finance Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2021 2022 2023 Accounts Receivable Invoices Issued 337 320 325 Total Invoice Value $2.01M $2.01M $2.1M Accounts Payable Vendors Paid 1,422 1,101 1,342 Total Dollar Value $88.5M $94.2M $84.3M Invoices Processed 1 N/A N/A 22,040 Payments lssued 1 N/A N/A $335.1M Payroll T4 Slips 929 1,136 1,266 Pay Statements 17,228 20,684 22,892 Property Taxes Phone Calls 18,535 16,555 19,370 Tax Bills Issued 67,064 68,148 65,203 Payments Processed $254.3M $264.7M $284.5M Purchasing Cards Transactions 3,097 4,906 5,908 Value of P-Card Transactions $0.53M $0.68M $0.84M Number of P-Cards Issued 108 60 97 Supply & Services Purchase Orders Issued 1,186 1,088 1,197 Blanket POs -Total PO Value $31.8M $38.0M $42.1M Bids -Number of Bids 62 74 109 -Total Bids Value (excluding Single/Sole $24.7M $9.4M $16.3M Source contracts & consulting) Quotes -Number of Quotes 35 65 89 -Total Quotes Value $4.3M $2.8M $7.1M RFPs -Number of RFPs 5 2 11 -Total RFPs Value $2.0M $0.77M $1.8M Tenders Awarded -Number of Tenders 22 7 9 -Total Tenders Value $18.4M $5.8M $7.2M 166 Finance Department Performance Indicators/Statistics 2021 2022 SinQle/Sole Source 2 -Number of Single/Sole Source N/A 50 -Total Single/Sole Source Value N/A $2.2M Consulting & Professional Services 2 -Number of Consulting & Professional N/A 94 Services -Total Consulting & Professional N/A $2.SM Services Value 1 These Performance Indicators were new in 2023 and prior year comparative information is not available (N/A). 2 These Performance Indicators were new in 2022 and prior year comparative information is not available(N/A). 167 2023 35 $1.7M 110 $2.3M Finance Department 2022 2023 Actuals YTD Actuals 2,744,503 3,043,117 22,396 28,595 708,621 828,720 6,767 6,755 12,287 8,222 596 1,040 112 - 1,793 1,846 8,757 10,246 1,144 1,301 179,651 189,384 2,623 2,660 27,881 12,089 16,200 17,820 267,395 223,696 2,118 2,212 17,064 17,502 8,520 8,493 1,275 246 13,179 10,377 -921 7 ,519 15 ,000 522,278 729,377 -- 669 - (13) - 119,165 115,055 2,863 (141) 4,695,363 5,274,533 (314,174) (344,751) (155,213) (10,283) (3,311,796) (3,507 ,311) (2,097,817) (4,231,119) -- City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 3,371,433 Overtime 30,750 Employee Benefits 914,439 Conferences 10,650 Seminars & Education 30,950 Travel 1,900 Postage - Cellular Phones 2,400 Telephone & Data 11,800 Internet 1,135 Data Processing Services 185,000 Subscriptions & Publications 4,000 Brochures/Newsletters Printing 28,000 Insurance Premium 17,820 Consulting & Professional Fees 522,280 Meals, Promotions & General 2,000 Memberships 19,080 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 545,665 System & Software Upgrade 8,600 Hardware Replacements - Miscellaneous Expenses - Financial Services Charges 75,000 Exchange Rate -Gain or Loss - Total Expenditures 5,823,502 Revenues Department User Fees (281,000) Other User Fees (70,000) Pen . & Interest -Prop. Taxes (2 ,890,000) Investment Income (1,025,000) Other Contributions (50,000) 168 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 365 ,772 3,737,205 10.85% -30,750 -% 167,092 1,081,531 18.27% -10,650 -% 7,150 38,100 23.10% -1,900 -% ---% -2,400 -% (300) 11,500 (2 .54%) -1,135 -% 15,000 200,000 8 .11% -4,000 -% -28,000 ~ % 2,675 20,495 15.01% 111,320 633,600 21.31% 500 2,500 25 .00% 620 19 ,700 3.25% (2,500) 9,100 (21 .55%) -2,300 -% -10,200 -% 2,500 4,000 166 .67% -15,000 -% 235,875 781,540 43.23% -8,600 -% ---% ---% 45,000 120,000 60.00% ---% 950,704 6,774,206 16.33% (10 ,000) (291,000) 3.56% -(70,000) -% (225,000) (3,115,000) 7 .79% (775,000) (1,800,000) 75 .61% 50,000 -(100.00%) Finance Department 2022 2023 Actuals YTD Actuals (5,879,000) (8,093,464) (64 ,171) - -- (90,128) - (10,949) - (165,248) - (1,348,885) (2,818,931) City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Total Revenues (4,316,000) Transfers Transfer to/(from) DC Oblg RF - Transfer to(from) Cntg Sty Res. (14,100) Transfer to(from) Reserve (64 ,350) Transfer to (from) Oblig RF (156,200) Total Transfers (234,650) Net Expenditures (Revenues) 1,272,852 169 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 (960,000) (5,276,000) 22.24% (90,000) (90,000) -% 7,600 (6,500) (53.90%) (154 ,650) (219,000) 240.33% (39,900) (196,100) 25 .54% (276,950) (511,600) 118.03% (286,246) 986,606 (22.49%) 10600 Finance 2022 2023 Actuals YTD Actuals 2,464,248 2,583,258 19,229 28 ,595 632,471 705,280 5,851 4,487 10,957 6 ,036 596 647 112 - 1,529 1,512 7,587 8,782 991 1,115 179,651 189 ,384 2,623 .2 ,660 27,881 12 ,089 14 ,280 15,708 267 ,395 180,499 2,118 2,212 16,312 15,770 6,928 7,069 1,275 246 9,696 9,353 -921 7,519 15,000 520,762 728 ,359 -- 669 - (13) - 119,165 115,055 2,863 (141) 4,322,695 4,633,896 (314 ,174) (344,751) (155,213) (10,283) (3,311,796) (3,507,311) (2,097,817) (4,231,119) -- City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 2,862,964 Overtime 25 ,750 Employee Benefits 784,702 Conferences 8,250 Seminars & Education 22,250 Travel 1,000 Postage - Cellular Phones 2,100 Telephone & Data 10 ,100 Internet 985 Data Processing Services 185,000 Subscriptions & Publications 4,000 Brochures/Newsletters Printing 28,000 Insurance Premium 15,708 Consulting & Professional Fees 479,280 Meals, Promotions & General 1,600 Memberships 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 545,055 System & Software Upgrade 8,600 Hardware Replacements - Miscellaneous Expenses - Financial Services Charges 75,000 Exchange Rate -Gain or Loss - Total Expenditures 5,115,639 Revenues Department User Fees (281,000) Other User Fees (70,000) Pen. & Interest -Prop. Taxes (2,890,000) Investment Income (1,025,000) Other Contributions (50,000) 170 Run Date : Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 20'23 331,259 3,194,223 11 .57% -25,750 -% 135,962 920 ,664 17 .33% -8,250 -% 7,150 29,400 32 .13% -1,000 -% ---% -2 ,100 -% (500) 9,600 (4.95%) -985 -% 15,000 200,000 8 .11% -4,000 -% -28,000 -% 2,357 18,065 15 .01% 152,320 631,600 31.78% 500 2 ,100 31.25% 620 17 ,915 3.58% (2,500) 7 ,500 (25.00%) -2,300 -% -9,200 -% 2,500 4 ,000 166 .67% -15,000 -% 234,875 779,930 43.09% -8 ,600 -% ---% ---% 45,000 120,000 60 .00% ---% 924,543 6,040,182 18.07% (10,000) (291,000) 3 .56% -(70,000) -% (225,000) (3,115,000) 7 .79% (775,000) (1,800,000) 75 .61% 50,000 -(100.00%) 10600 Finance 2022 2023 Actuals YTD Actuals (5 ,879,000) (8,093,464) (64,171) - -- (90,128) - (10,949) - (165,248) - (1,721,553) (3,459,568) City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Total Revenues (4,316,000) Transfers Transfer to/(from) DC Oblg RF - Transfer to(from) Cntg Sty Res. (14,100) Transfer to(from) Reserve (64,350) Transfer to (from) Oblig RF (156,200) Total Transfers (234,650) Net Expenditures (Revenues) 564,989 171 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 (960,000) (5,276,000) 22.24% (90,000) (90,000) - % 7,600 (6,500) (53 .90%) (154 ,650) (219 ,000) 240.33% (39,900) (196,100) 25 .54% (276,950) (511,600) 118.03% (312,407) 252,582 (55.29%) City of Pickering 2024 Current Budget Summary 10605 Supply & Services 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 280,255 459,859 Salaries & Wages 508,469 3,167 -Overtime 5,000 76,150 123,440 Employee Benefits 129,737 916 2,268 Conferences 2,400 1,330 2,186 Seminars & Education 8,700 -393 Travel 900 264 334 Cellular Phones 300 1,170 1,464 Telephone & Data 1,700 153 186 Internet 150 1,920 2,112 Insurance Premium 2,112 -43,197 Consulting & Professional Fees 43,000 --Meals, Promotions & General 400 752 1,732 Memberships 1,785 1,592 1,424 Outside Agency Services 1,600 3,483 1,024 Stationary & Office Supplies 1,000 1,516 1,018 Software & Hardware Mtce. Contracts 610 372,668 640,637 Total Expenditures 707,863 Revenues --Total Revenues - Transfers --Total Transfers - 372,668 640,637 Net Expenditures (Revenues) 707,863 172 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2823 34,513 542,982 6.79% -5,000 -% 31,130 160 ,867 23.99% -2,400 -% -8,700 -% -900 -% -300 -% 200 1,900 11.76% -150 -% 318 2,430 15 .06% (41,000) 2,000 (95.35%) -400 -% -1,785 -% -1,600 -% -1,000 - % 1,000 1,610 163.93% 26,161 734,024 3.70% --- % --- % 26,161 734,024 3.70% Fire Services Department Overview The Fire Services Department is responsible for fire protection and emergency management within the City. Fire Protection responsibilities include response to emergencies, fire prevention inspections, public fire safety education and staff development and training. Emergency Management responsibilities include the coordination, response and management of large-scale emergencies in the City. Staff also ensure that the City is compliant with the Emergency Management and Civil Protection Act. Fire Services Department '- I Fire Protection Operations I I I I / "I Suppression Fire Training Prevention Rescue , Public Education \. .) Pickering Fire Station Locations: Fire Station 1 (Headquarters) -1700 Zents Drive Fire Station 2 -553 Kingston Road Fire Station 4 -4941 Old Brock Road (Claremont) Fire Station 5 -1616 Bayly Street Fire Station 6 -1115 Finch Avenue 173 ....., , I Emergency Operations I Emergency Management Fire Services Department Key Activities for 2024 in Support of the Corporate Strategic Plan Priority 1: Champion Economic Leadership and Innovation • Transition of Fire Dispatch to a regional consolidated centre. • Leverage the expansion of map-based data project to identify areas of concern and allocate resources more efficiently. Priority 2: Advocate for an Inclusive, Welcoming, Safe & Healthy Community • Rebranding of the Home Fire Inspection program (Fire Safe Pickering) and the introduction of a digital map-based application for recording and tracking home inspections. • Complete design for the replacement of Fire Station 5. • Addition of 4 new firefighter positions. • Renovation and upgrades to Fire Stations 2, 4 and 6. • Complete the Community Risk Assessment and Fire Master Plan. Priority 6: Foster an Engaged & Informed Community • Hold Fire Services Inaugural Community Safety Day at Fire Station 1. 174 Financial Information Fire Services Department Staffing Summary (Full & Regular Part-Time) Prior Term of Council Current Term of Council 2019 2020 2021 2022 2023 2024 Approved Add Delete Total Full-Time 106 109 112 116 121 4 -125 Reg. Part-Time -------- Total 106 109 112 116 121 4 -125 The department is proposing to add four additional firefighter positions in 2024, effective January 1, 2024. The recent opening of Fire Station 1 has absorbed the additional staff resources in the existing staff complement which were being used to fill in when staffing levels fall below minimums due to illness and/or injury. Year-Over-Year (Net Cost) Budget Changes Fire Protection Emergency Operations Total (Net Cost) 2023 Budget 2024 Budget $20,200,420 $21,014,312 34,642 40,914 $20,235,062 $21,055,226 175 Year-Over-Year Change ($) $813,892 6,272 $820,164 (%) 4.03% 18.11% 4.05% Fire Services Department Explanation of Significant Departmental Budget Changes Account Change Explanation Expenditures -Increase/ (Decrease) ' Salaries & Wages Overtime Employee Benefits Uniforms . Seminars & Education Dispatch Communications Consulting & Professional Services Building Repairs & Maintenance Gas, Oil, Tires, Etc. Supplies & Tools Utilities -Hydro $616,662 Increase largely reflects the annualization of five additional firefighters approved in 2023 as well as salary progressions related to the collective agreement. $150,000 Increase is due to the opening of Fire Hall 1 in May 2023 which absorbed the residual staffing resources available for vacation and illness coverage, resulting in a need for additional overtime funding. $332,200 Increase attributed to benefit costs related to annualization of five additional firefighters hired in 2023 as well as salary increases related to the collective agreement. Additional impacts include the increase in statutory benefits costs due to enhanced CPP rates and inflationary increases in group health benefit costs. $52,600 Increase primarily to cost of uniforms and bunker gear for four new firefighter positions proposed for 2024. ($11,500) Decrease is due to a reduction in planned staff seminar attendance in 2024. ($280,160) Decrease reflects savings expected to be realized through the move to a consolidated Regional fire dispatch model. ($105,954) Decrease is due to the partial completion of the Fire Master Plan (FMP) which is being carried over to 2024. $21,200 Increase in largely due to increased costs for waste and biohazard disposal. $13,370 Increase reflects continued high fuel prices and additional diesel, gas, oil changes and tires required for the City's growing vehicle fleet. $14,000 Increase is required for the replacement of several fire hoses which have reached their end of service life. $27,290 Increase based on current usage and price increases expected in 2024. 176 Account Furniture & Fixtures Other Expenses Total Expenditures Fire Services Department Change Explanation ($22,000) Decrease is mainly due to Fire Station 1 upfit and furniture replacements at Stations 2, 4 and 5 completed in 2023. $7,602 $815,310 Revenues -(Increase) / Decrease Ontario Grants Other Contributions Total Revenues ($10,000) Increase is related to a new Community Emergency Preparedness grant application planned for 2024 (subject to approval). $30,000 Decrease is related to third party contribution to FMP study completed in 2023. $20,000 • Transfers -(Increase)/ Decrease Development Charges Reserve Fund Continuing Studies Reserve Total Transfers Net Increase $3,366 ($18,512) Increase is for the Fire Master Plan carried over from 2023 to be completed in 2024. ($15,146) $820,164 177 Fire Services Department Department Performance Indicators/Statistics 2021 2022 2023 Fire Prevention & Public Safety Vulnerable Occupancy Inspections (Leqislated) 20 20 20 Complaint Inspections 205 143 104 Requested Inspections 421 720 359 Fire lnvestiqations 31 37 37 Permits Reviewed 370* 327 301 Public Fire Safety Education Events 361 115 217 Other Fire Safety/Community Support Activities 222 219 217 Fire Suppression Operations Fire/Smoke 311 325 345 Motor Vehicle Accidents 452 629 617 Medical Response 519 1,357 2,918 Rescue 18 23 26 Fire Alarm 324 474 544 Hazard (CO, wires down, qas leak, etc.) 267 322 261 Other (public assist, 911 unknown call, etc.) 323 347 475 Total Incidents 2,215 3,478 5,186 Training Recruit firefiqhters trained (7-week proqram) 11 5 9 178 City of Pickering 2024 Current Budget Summary Fire Services Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 12,944,864 13,678,603 Salaries & Wages 13,986,439 252,545 739,821 Overtime 250,000 3,597,288 3,882,501 Employee Benefits 3,766,030 177,243 183,989 Uniforms 220,000 4,055 4,404 Conferences 6,500 122,317 121,527 Seminars & Education 154,000 675 393 Travel 1,000 102 11 Freight, Express & Cartage - 57 -Environmental Charges - 17,952 18,938 Cellular Phones 16,300 62,382 73,087 Telephone & Data 61,400 1,156 1,077 Internet 1,160 2,482 1,692 Cable TV 2,505 1,059,383 1,087,784 Dispatch Comunications 1,107,240 -833 Advertising 1,000 -(11) Subscriptions & Publications 2,000 -130 Brochures/Newsletters Printing - --Photo, Mapping, Print 1,000 95,925 89,898 Insurance Premium 89,898 -710 Insurance Deductible 2,000 6,830 49,988 Consulting & Professional Fees 190,000 1,927 3,358 Meals, Promotions & General 4,250 2,417 4,580 Memberships 6,450 750 750 Outside Agency Services 1,000 192,432 240,187 Building -Repairs & Maintenance 146,200 201,335 239,911 Vehicle -Repairs & Maintenance 165,600 135,546 146,208 Gas, Oil, Tire, Etc. 133,700 53,525 104,532 Misc . Equip . -Repairs & Maintenance 88,500 6,375 6,643 Stationary & Office Supplies 6,000 --Forms 1,500 6 ,847 19,262 Programs & Event Supplies 21,000 108,568 109,537 Supplies & Tools 95,000 12,812 17,650 Utilities -Water 18,850 50,727 71,800 Utilities -Hydro 67,710 27,183 35,094 Utilities -Natural Gas 37,535 17,899 3,504 Software & Hardware Mice . Contracts 16,795 179 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 616,662 14,603,101 4.41% 150,000 400,000 60.00% 333,200 4,099,230 8.85% 52,600 272,600 23 .91% -6,500 - % (11,500) 142,500 (7.47%) -1,000 - % --- % ---% 1,600 17,900 9.82% 700 62,100 1.14% -1,160 -% -2,505 -% (280,160) 827,080 (25.30%) -1,000 - % -2,000 -% --- % -1,000 -% (1,978) 87,920 (2.20%) 300 2,300 15 .00% (105,954) 84,046 (55 .77%) 4,500 8,750 105.88% (2,000) 4,450 (31 .01%) -1,000 -% 21,200 167,400 14.50% 300 165,900 0.18% 13,370 147,070 10.00% 6,570 95,070 7.42% -6,000 -% -1,500 - % 3,400 24,400 16.19% 14,000 109,000 14.74% 470 19,320 2.49% 27,290 95,000 40.30% 2,865 40,400 7 .63% (425) 16,370 (2 .53%) City of Pickering 2024 Current Budget Summary Fire Services Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals 2,834 10,176 System & Software Upgrade 8,500 7,968 -Hardware Replacements - 9,238 22,824 Furniture & Fixtures 23,000 8,885 18,799 Misc. Equipment 28,500 -(256) Exchange Rate -Gain or Loss - 19,192,524 20,989,934 Total Expenditures 20,728,562 Revenues --Ontario Grants - (146,318) (106,042) Department User Fees (100,000) (5,432) -Other User Fees - --Sponsorships (500) --Marketing Sponsors (500) --Other Contributions (30,000) (250,000) (250,881) Cost Recoveries (250,000) (401,750) (356,923) Total Revenues (381,000) Transfers --Transfer to/(from) DC Oblg RF (112,500) --Transfer to(from) Cntg Sty Res . - --Total Transfers (112,500) 18,790,774 20,633,011 Net Expenditures (Revenues) 20,235,062 180 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 200 8 ,700 2 .35% ---% (22,000) 1,000 (95.65%) (9,900) 18,600 (34.74%) ---% 815,310 21,543,872 3.93% (10,000) (10,000) -% -(100,000) -% ---% -(500) -% -(500) -% 30,000 -(100 .00%) -(250,000) -% 20,000 (361,000) (5.25%) 3,366 (109,134) (2.99%) (18,512) (18 ,512) -% (15,146) (127,646) 13.46% 820,164 21,055,226 4.05% 10700 Fire Protection 2022 2023 Actuals YTD Actuals 12,780,544 13,512,555 252,545 739,821 3,564,585 3,838,970 177,243 183,989 4,055 4,404 122,317 121 ,527 675 393 102 11 57 - 17,365 18,506 62,361 72,834 1,156 1,077 873 369 1,059,383 1,087,784 -833 -(11) -130 -- 95,245 89 ,150 -710 6,830 49,988 1,866 2,987 2,417 4,580 750 750 191,542 240,171 201,335 239,911 135 ,546 146,208 53,133 104,534 6,375 5,791 -- 6,847 19,262 107,795 109,226 12,812 17,650 50,727 71,800 27,183 35,094 17,716 3,504 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 13,848 ,731 Overtime 250,000 Employee Benefits 3,732,639 Uniforms 220,000 Conferences 5,000 Seminars & Education 150,500 Travel 1,000 Freight, Express & Cartage - Environmental Charges - Cellular Phones 15,500 Telephone & Data 60,900 Internet 1,100 Cable TV 885 Dispatch Comunications 1,107,240 Advertising 1,000 Subscriptions & Publications 2,000 Brochures/Newsletters Printing - Photo, Mapping, Print 500 Insurance Premium 89,150 Insurance Deductible 2,000 Consulting & Professional Fees 190,000 Meals, Promotions & General 3,500 Memberships 6,050 Outside Agency Services 1,000 Building -Repairs & Maintenance 146,200 Vehicle -Repairs & Maintenance 165,600 Gas, Oil, Tire, Etc . 133,700 Misc. Equip . -Repairs & Maintenance 88,000 Stationary & Office Supplies 5,000 Forms 1,500 Programs & Event Supplies 21,000 Supplies & Tools 93,500 Utilities -Water 18,850 Utilities -Hydro 67,710 Utilities -Natural Gas 37,535 Software & Hardware Mtce. Contracts 16,630 1 81 Run Date : Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 612,691 14,461,422 4.42% 150,000 400,000 60 .00% 331,606 4,064,245 8.88% 52,600 272,600 23.91% -5,000 - % (11,500) 139,000 (7.64%) -1,000 - % --- % --- % 1,000 16,500 6.45% 700 61,600 1.15% -1,100 - % -885 - % (280,160) 827,080 (25.30%) -1,000 - % -2,000 - % --- % -500 - % (2,090) 87,060 (2 .34%) 300 2,300 15.00% (105,954) 84,046 (55 .77%) 4,500 8,000 128 .57% (2 ,000) 4,050 (33.06%) -1,000 - % 21,200 167,400 14 .50% 300 165,900 0.18% 13,370 147,070 10.00% 6,570 94,570 7.47% -5,000 - % -1,500 - % 3,400 24,400 16 .19% 14,000 107,500 14 .97% 470 19,320 2.49% 27,290 95,000 40 .30% 2,865 40,400 7 .63% (420) 16,210 (2.53%) 10700 Fire Protection 2022 2023 Actuals YTD Actuals 2,834 10 ,176 7,968 - 10,232 22,668 5,165 18,336 -(256) 18,987,579 20 ,775,432 -- (146,318) (106,042) (5,432) - -- -- -- (100,000) (100,881) (251,750) (206,923) -- -- - - 18,735,829 20,568,509 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget System & Software Upgrade 8,500 Hardware Replacements - Furniture & Fixtures 23,000 Misc . Equipment 28,500 Exchange Rate -Gain or Loss - Total Expenditures 20,543,920 Revenues Ontario Grants - Department User Fees (100,000) other User Fees - Sponsorships (500) Ma rketing Sponsors (500) Other Contributions (30,000) Cost Recoveries (100,000) Total Revenues (231,000) Transfers Transfer to/(from) DC Oblg RF (112,500) Transfer to(from) Cntg Sty Res . - Total Transfers (112,500) Net Expenditures (Revenues) 20,200,420 182 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 200 8,700 2.35% - --% (22,000) 1,000 (95 .65%) (9 ,900) 18 ,600 (34 .74%) --- % 809,038 21,352,958 3.94% (10,000) (10,000) - % -(100,000) - % --- % -(500) -% -(500) - % 30,000 -(100.00%) -(100,000) - % 20,000 (211,000) (8.66%) 3,366 (109,134) (2 .99%) (18 ,512) (18,512) - % (15,146) (127,646) 13.46% 813,892 21,014,312 4.03% City of Pickering 2024 Current Budget Summary 10705 Emergency Operations 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 164,320 166,048 Salaries & Wages 137,708 32,703 43,531 Employee Benefits 33,391 --Conferences 1,500 --Seminars & Education 3,500 587 432 Cellular Phones 800 21 253 Telephone & Data 500 --Internet 60 1,609 1,323 Cable TV 1,620 --Photo, Mapping, Print 500 680 748 Insurance Premium 748 61 371 Meals, Promotions & General 750 --Memberships 400 890 16 Building -Repairs & Maintenance - 392 (2) Misc. Equip . -Repairs & Maintenance 500 -852 Stationary & Office Supplies 1,000 773 311 Supplies & Tools 1,500 183 -Software & Hardware Mtce . Contracts 165 (994) 156 Furniture & Fixtures - 3,720 463 Misc. Equipment - 204,945 214,502 Total Expenditures 184,642 Revenues (150,000) (150,000) Cost Recoveries (150,000) (150,000) (150,000) Total Revenues (150,000) Transfers --Total Transfers - 54,945 64,502 Net Expenditures (Revenues) 34,642 183 Run Date: Jan 25 , 2024 Increase I 2024 %Change Decrease Budget From2023 3 ,971 141,679 2 .88% 1,594 34,985 4 .77% -1,500 -% -3,500 -% 600 1,400 75.00% -500 -% -60 -% -1,620 -% -500 -% 112 860 14.97% -750 -% -400 -% ---% -500 -% -1,000 -% -1,500 -% (5) 160 (3 .03%) ---% ---% 6,272 190,914 3.40% -(150,000) -% -(150,000) -% ---% 6,272 40,914 18.11% 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) and training. Employee Services -Employee benefits, compensation, Ontario Municipal Employee Retirement System (OMERS) administration, disability management and Workplace Safety & Insurance (WSIB) administration and employee wellness. Labour Relations -Grievance administration, collective bargaining, employee relations and policy development. People & Culture -Succession planning, equity, diversity & inclusion and organizational development. r ' Human Resources Department \. .) I I I I I r ' r ' Human Employee Labour People & Resources Services Relations Culture ~ 184 Human Resources Department Key Activities for 2024 in Support of the Corporate Strategic Plan Corporate Key: Good Governance & Customer Service Excellence • Coordinate the corporate wide utilization of SuccessFactors -Employee Central (HRIS self-service module) including the introduction of the recruitment/ onboarding module. • Ongoing review of policies and procedures to better align them with current practices and the Corporate Strategic Plan (New Employee Orientation, Training & Education, Employee Recognition). • Facilitate succession planning and leadership development initiatives. Priority 2: Advocate for an Inclusive, Welcoming, Safe & Healthy Community • Coordinate the development of an Equity, Diversity & Inclusion (EDI) Ten-Year Strategy utilizing an external consultant. • Participate in the implementation of the year one work plan of the EDI Strategy including supporting the creation of an EDI training plan for all employees. Priority 5: Strengthen Existing and Building New Partnerships • Foster relationships with educational institutions for co-operative education opportunities and internships. Engage with students, recent graduates, and newcomers to Canada about employment opportunities in municipal government through employment fairs. Priority 6: Foster an Engaged & Informed Community • Ongoing review of the corporation's recruitment and retention strategies leveraging proactive and creative employment advertisements and techniques to solicit qualified applicants. 185 Financial Information Human Resources Department Staffing Summary (Full & Regular Part-Time) Prior Term of Council Current Term of Council 2019 2020 2021 2022 2023 2024 Approved Add Delete Total Full-Time 8 10 10 11 12 -- Reg. Part-Time --- ---- Total 8 10 10 11 12 -- The department does not propose any staffing changes for 2024. Year-Over-Year (Net Cost) Budget Changes Human Resources Health & Safety Total (Net Cost) 2023 Budget $ 1,319,335 165,132 $1,484,467 2024 Budget $1,447,876 170,751 $1,618,627 186 Year-Over-Year Change ($) $128,541 5,619 $134,160 (%) 9.74% 3.40% 9.04% 12 - 12 Human Resources Department Explanation of Significant Departmental Budget Changes Account Change i Explanation Expenditures -Increase I (Decrease) Salaries & Wages Employee Benefits Corporate Training Consulting & Professional Services Other Expenses Total Expenditures $67,505 Increase is mainly due to annualization of one new full-time HR Associate position approved in 2023. $23,295 Increase is largely due to benefit costs related to annualization of new HR Associate position approved in 2023. Additional impacts include the increase in statutory benefits costs due to enhanced CPP rates and inflationary increases in group health benefit costs. ($10,000) Decrease reflects a budget reduction for planned training as a cost containment measure. ($18,728) Decrease is due to the partial completion of the Equity Diversity & Inclusion (EDI) Strategy which is being carried over to 2024. $3,420 $65,492 Revenues -(Increase) / Decrease Netted Revenues Total Revenues $64,940 Decrease reflects changes to the internal charge for HR services provided to the Library to better reflect the City's current level of support. $64,940 Transfers -(Increase)/ Decrease Continuing. Studies Reserve WSIB Reserve Fund Total Transfers Net Increase ($6,272) Increase in funding related to the portion of the EDI Strategy carried over from 2023 to 2024. $10,000 Funding for corporate training funded from this reserve is not required in 2024. $3,728 $134,160 187 Human Resources Department Department Performance Indicators/Statistics Performance Indicators/Statistics 2021 2022 2023 Job Postinqs 92 78 100 New Employees Hired (excludinq students) 112 111 138 Rehires/transfers/promotions 153 159 295 Student/mass hires 114 298 238 Retirements/resiqnations 69 36 32 Employees trained (various courses including 330 319 807 Respect in the Workplace, Health & Safety Awareness, confined space and working at heights) 188 City of Pickering 2024 Current Budget Summary Human Resources Department 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 979,112 1,061,202 Salaries & Wages 1,114,922 866 -Overtime 3,000 271,286 311,238 Employee Benefits 310,860 31,328 30,327 Employee Recognition 42,250 -1,577 Conferences 2,650 2,414 2,113 Seminars & Education 6,500 12,836 35,814 Corporate Training 60,000 71 85 Travel 500 708 844 Cellular Phones 1,300 2,969 3 ,519 Telephone & Data 3 ,700 382 447 Internet 380 16,068 18,143 Advertising 15,000 4,330 4,763 Insurance Premium 4,763 212,166 183,674 Consulting & Professional Fees 200,000 2,879 1,793 Meals, Promotions & General 3,500 1,580 2,718 Memberships 3,530 978 1,180 Stationary & Office Supplies 1,500 52 -Programs & Event Supplies - 699 639 Educational Material 1,400 --Workplace Accomodation 900 8,089 6,567 Software & Hardware Mtce. Contracts 8 ,352 1,548,813 1,666,643 Total Expenditures 1,785,007 Revenues (229,941) -Netted Revenue (240 ,540) (229,941) -Total Revenues (240,540) Transfers (50,090) -Transfer to(from) Cntg Sty Res . (25,000) (10,912) -Transfer to (from) Oblig RF (35 ,000) (61,002) -Total Transfers (60,000) 1,257,870 1,666,643 Net Expenditures (Revenues) 1,484,467 189 Run Date : Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From2023 67,505 1,182,427 6 .05% (1,000) 2,000 (33.33%) 23,295 334,155 7.49% -42,250 -% -2,650 -% -6,500 -% (10,000) 50,000 (16 .67%) -500 -% -1,300 -% 100 3 ,800 2 .70% -380 -% -15,000 -% 712 5,475 14 .95% (18,728) 181,272 (9 .36%) 3,500 7,000 100.00% 130 3,660 3.68% -1,500 -% ---% -1,400 -% -900 -% (22) 8 ,330 (0.26%) 65,492 1,850,499 3.67% 64 ,940 (175,600) (27.00%) 64,940 (175,600) (27.00%) (6,272) (31,272) 25 .09% 10 ,000 (25,000) (28.57%) 3,728 (56,272) (6.21%) 134,160 1,618,627 9.04% City of Pickering 2024 Current Budget Summary 10800 Human Resources 2022 2023 2023 Actuals YTD Account Description Budget Actuals Expenditures 862,321 941,620 Salaries & Wages 991,035 866 -Overtime 3,000 238,975 277,446 Employee Benefits 277,491 31,328 30,327 Employee Recognition 42,250 -1,577 Conferences 2,000 2,414 2,113 Seminars & Education 6,000 1,630 10 ,916 Corporate Training 25,000 71 85 Travel 300 708 844 Cellular Phones 1,300 2,674 3,218 Telephone & Data 3,700 343 409 Internet 340 16,068 18,143 Advertising 15,000 3,570 3,927 Insurance Premium 3,927 212,166 183,674 Consulting & Professional Fees 200,000 2 ,879 1,793 Meals, Promotions & General 3,500 1,440 2,578 Memberships 3,330 978 1,180 St~tionary & Office Supplies 1,200 4,487 -Software & Hardware Mtce. Contracts 5,502 1,382,918 1,479,850 Total Expenditures 1,584,875 Revenues (229,941) -Netted Revenue (240,540) (229,941} -Total Revenues (240,540} Transfers (50,090) -Transfer to(from) Cntg Sty Res . (25,000) (50,090} -Total Transfers (25,000} 1,102,887 1,479,850 Net Expenditures (Revenues} 1,319,335 190 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From2023 63,817 1,054,852 6.44% (1,000) 2,000 (33 .33%) 21,478 298 ,969 7.74% -42,250 -% -2,000 -% -6,000 -% -25,000 -% -300 -% -1,300 -% 100 3,800 2.70% -340 -% -15,000 -% 588 4,515 14 .97% (18 ,728) 181,272 (9 .36%) 3,500 7,000 100 .00% 130 3,460 3 .90% -1,200 -% (12) 5,490 (0 .22 %) 69,873 1,654,748 4.41% 64,940 (175,600) (27 .00%) 64,940 (175,600} (27.00%} (6,272) (31 ,272) 25 .09% (6,272} (31,272} 25 .09% 128,541 1,447,876 9.74% 10805 Health & Safety 2022 2023 Actuals YTD Actuals 116,791 119,582 32,311 33,792 -- -- 11,206 24,898 -- 295 301 39 38 760 836 140 140 -- 52 - 699 639 -- 3,602 6,567 165,895 186,793 -- (10,912) - (10,912) - 154,983 186,793 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 123,887 Employee Benefits 33,369 Conferences 650 Seminars & Education 500 Corporate Training 35,000 Travel 200 Telephone & Data - Internet 40 Insurance Premium 836 Memberships 200 Stationary & Office Supplies 300 Programs & Event Supplies - Educational Material 1,400 Workplace Accomodation 900 Software & Hardware Mtce . Contracts 2,850 Total Expenditures 200,132 Revenues Total Revenues - Transfers Transfer to (from) Oblig RF (35,000) Total Transfers (35,000) Net Expenditures (Revenues) 165,132 1 91 Run Date: Jan 25, 2024 Increase I 2024 %Change Decrease Budget From 2023 3,688 127,575 2.98% 1,817 35,186 5.45% -650 - % -500 - % (10,000) 25,000 (28.57%) -200 - % --- % -40 - % 124 960 14 .83% -200 - % -300 - % --- % -1,400 -% -900 - % (10) 2,840 (0 .35%) (4,381) 195,751 (2.19%) --- % 10,000 (25,000) (28.57%) 10,000 (25,000) (28.57%) 5,619 170,751 3.40% Pickering Public Library Overview The Pickering Public Library is responsible for ensuring that all Pickering residents have equitable access to the resources, information, and ideas that will enrich their civic, educational, career, and personal lives. , ..,, Pickering Public Library '-. ~ I 'I Public Services Support Service ,J \. 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. - 192 Pickering Public Library Key Activities for 2024 in Support of the Corporate Strategic Plan Corporate Key: Good Governance & Customer Service Excellence • Develop Business Continuity Plan and implement mitigation measures. • Implement framework that ensures programs and events are equitable, accessible and inclusive. Priority 1: Champion Economic Leadership and Innovation • Support Small Business Hub collaboration with Economic Development and Strategic projects department for Central Library. Priority 2: Advocate for an Inclusive, Welcoming, Safe & Healthy Community • Launch of the Outreach Vehicle to provide equitable access to library services. • Support the advancement of the action plan outlined in the City's Community Safety & Well-Being Plan (subject to Council approval). • Evaluate the Claremont Library Extended Access Pilot and ensure all safety considerations are implemented. • Ensure all library design projects prioritize safety considerations. • Implement a Library Equity, Diversity and Inclusion (EDI) Strategy aligned with the City's EDI Strategy (subject to Council approval). • Increase digital literacy and Maker Space programs for residents aged 55+. • Modify the layout of the Central Library to ensure gathering spaces for youth are accessible, inclusive, safe and welcoming. Priority 3: Advance Innovation & Responsible Planning to Support a Connected, Well-Serviced Community • Provide forums and information panels for residents to discuss and understand important community issues. • Provide public WIFI through the Outreach Vehicle community stops. Priority 4: Lead & Advocate for Environmental Stewardship, Innovation & Resiliency • Launch a "seed library" to promote environmental resiliency at community level. Priority 5: Strengthen Existing and Building New Partnerships • Build relationships with community members and service providers in developing service schedule for the Outreach Vehicle. Priority 6: Foster an Engaged & Informed Community • Provide annual report back to the community on the Library's strategic priorities and engagement initiatives. 193 Financial Information Pickering Public Library Staffing Summary (Full & Regular Part-Time) Prior Term of Council Current Term of Council 2019 2020 2021 2022 2023 2024 Approved Add . Delete Full-Time 37 36 37 39 39 -- Reg. Part-Time 25 24 22 20 20 -- Total 63 60 59 59 59 -- * The above charl excludes contract, students and term employees The Library is not requesting any change in staff complement in 2024. Year-Over-Year (Net Cost) Budget Changes Year-Over-Year 2023 2024 Change Budget Budget ($) (%) Pickering Public Library $6,387,017 $6,562,637 $175,620 2.75% Total (Net Cost) $6,387,017 $6,562,637 $175,620 2.75% 194 Total 39 20 59 Pickering Public Library Explanation of Significant Departmental Budget Changes Account Change Explanation Expenditures -Increase/ (Decrease) Salaries & Wages Employee Benefits Internet Consulting & Professional Services Outside Agency Services Building Repairs & Maintenance Utilities -Hydro Software & Hardware Maintenance Contracts Systems & Software Upgrade Other Expenses Total Expenditures $221,299 Increase due to updated collective agreement and grant funded positions. $77,520 Increase in benefits costs reflects the increase in salaries. Additional impacts include higher statutory benefits costs due to enhanced CPP rates, extension of OMERs pension benefits to additional part-time staff, and inflationary increases in group health benefit costs. ($19,860) Decrease reflects new contract with internet service provider, resulting in lower costs. ($75,825) Decrease primarily due to the partial completion of the Library Strategic Plan which is being carried over to 2024. ($78,495) Decrease reflects changes to the internal charge for Human Resource (HR) services provided to the Library to better reflect current level of support provided by the City. $36,492 Increase relates mainly to the internal charge from City for cleaning services, caused by updated contract rates. ($26,600) Decrease reflects reduced usage in 2023, partially offset by price increases expected in 2024. ($18,036) Decrease due to reduced annual contract pricing for the new Integrated Library System (ILS) database. $80,000 Increase reflects the one-time cost for replacement of ILS database software. $13,245 $209,740 195 Pickering Public Library ; Account Change Explanation Revenues -(Increase) / Decrease Ontario Grants Fines & Charges • Other Revenues Total Revenues $21,000 Decrease due to one-time grant for senior entrepreneurship program received in 2023. $10,000 Decrease reflects adjustment to match prior year actuals revenue levels. ($8,695) $22,305 Transfers -(Increase)/ Decrease Development Charges Reserve Fund Continuing Studies Reserve Rate Stabilization Reserve Total Transfers Net Increase $52,369 Decrease in funding for Library Strategic Plan which is being carried over to 2024. ($8,794) ($100,000) Increase relates to funding for replacement of ILS database software in 2024. ($56,425) $175,620 196 Pickering Public Library Departmental Performance Indicators/Statistics Performance 2021 2022 2023 Indicators/Statistics Total materials borrowed 758,202 860,735 829,877 Website visits 267,796 449,059 679,808 In-person visits 121,216 253,737 362,791 Active cardholders 33,855 33,497 37,795 Events & Outreach attendance 9,222 17,091 25,758 Number of events 520 650 944 197 10900 Library 2022 2023 Actuals YTD Actuals 3,308,620 3,509,200 6,560 2,878 874,733 972,417 2,273 1,995 1,585 2,380 5,790 10,886 20,178 20,637 1,527 5,285 2,622 2,208 365 86 15,427 15,276 21,292 19,713 35,179 35,828 1,299 1,095 13,149 9,037 3,172 8,645 24,830 28,730 -- 4,202 85,792 5,212 7,020 9,543 14,315 305,554 79,489 257,247 249,402 3,164 2,420 2,807 2,819 41,077 43,542 28,150 24,696 33,757 48,321 8,342 3,811 7,446 7,611 321,992 292,536 13,816 15,399 110,247 123,808 35,956 41,267 201,213 203,558 -40 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Expenditures Salaries & Wages 3,729,961 Overtime 3,275 Employee Benefits 1,042,079 Employee Recognition 3,800 Uniforms 1,070 Conferences 10,000 Seminars & Education 23,500 Travel 3,540 Postage 1,200 Freight, Express & Cartage 500 Cellular Phones 17,280 Telephone & Data 22,300 Internet 51,960 Cable TV 1,425 Advertising 20,000 Brochures/Newsletters Printing 11,000 Insurance Premium 27,313 Insurance Deductible 2,000 Consulting & Professional Fees 135,000 Meals, Promotions & General 7,000 Memberships 14,580 Outside Agency Services 343,910 Building -Repairs & Maintenance 252,818 Vehicle -Repairs & Maintenance 2,000 Gas, Oil, Tire, Etc. 3,430 Misc. Equip. -Repairs & Maintenance 43,140 Stationary & Office Supplies 19,000 Programs & Event Supplies 46,000 Committee Expenses 11,100 Supplies & Tools 9,500 Library Materials 306,000 Utilities -Water 17,300 Utilities -Hydro 165,000 Utilities -Natural Gas 38,185 Software & Hardware Mtce. Contracts 239,026 System & Software Upgrade 20,000 198 Run Date: Jan 25, 2024 Increase/ 2024 %C:Jiange Decrease Budget From 2023 221,299 3,951,260 5.93% 135 3,410 4 .12% 77,520 1,119,599 7.44% -3,800 -% 2,180 3,250 203.74% 1,000 11,000 10 .00% 2,500 26,000 10.64% 1,460 5,000 41.24% 300 1,500 25 .00% -500 - % 5,720 23,000 33 .10% (2,600) 19,700 (11.66%) (19,860) 32,100 (38.22%) (700) 725 (49 .12%) (2,000) 18,000 (10.00%) 2,000 13,000 18.18% 7,312 34,625 26.77% 300 2,300 15.00% (75,825) 59,175 (56.17%) -7,000 - % 1,170 15,750 8.02% (78,495) 265,415 (22.82%) 36,492 289,310 14.43% -2,000 - % 343 3,773 10 .00% (1,840) 41,300 (4.27%) -19,000 -% (8,000) 38,000 (17.39%) 700 11,800 6.31% (300) 9,200 (3.16%) (5,000) 301,000 (1.63%) (1,000) 16,300 (5.78%) (26,600) 138,400 (16.12%) 9,315 47,500 24 .39% (18,036) 220,990 (7.55%) 80,000 100,000 400 .00% 10900 Library 2022 2023 Actuals YTD Actuals 28,059 15 ,719 8,153 7,309 -5 -4 -34 5,764,538 5,915,213 (13,333) (113,469) (146,689) (63,864) -(6,450) (26,776) (39,245) -(10) (1 ,807) (1,541) (723) (2,146) (1,939) (6 ,342) (6,079) (6 ,094) (6 ,354) (7 ,915) (203,700) (247,076) -- -- 100 ,000 100,000 100,000 100,000 5,660,838 5,768,137 City of Pickering 2024 Current Budget Summary 2023 Account Description Budget Hardware Replacements 16,000 Furniture & Fixtures 10 ,000 Miscellaneous Expenses - Financial Services Charges - Exchange Rate -Gain or Loss - Total Expenditures 6,671,192 Revenues Federal Grants (37,000) Ontario Grants (157,425) Other Agency Grants - Department User Fees (53,000) Gift Shop - Vending Machines (2 ,500) Rentals -Meet ing Rooms (5,500) Other User Fees (10,000) Fines & Charges (20,000) Donations (20 ,000) Total Revenues (305 ,425) Transfers Transfe r to/(from) DC Oblg RF (78,750) Transfer to(from) Cntg Sty Res . - Transfer to(from) Reserve 100 ,000 Total Transfers 21,250 Net Expenditures (Revenues) 6,387,017 199 Run Date: Jan 25, 2024 Increase/ 2024 %Change Decrease Budget From 2023 3 ,000 19,000 18.75% (2,750) 7,250 (27 .50%) ---% ---% ---% 209 ,740 6,880,932 3.14% (8 ,195) (45 ,195) 22 .15% 21,000 (136,425) (13 .34%) ---% 3,000 (50 ,000) (5 .66%) ---% -(2,500) -% 500 (5,000) (9 .09%) (4,000) (14,000) 40.00% 10,000 (10 ,000) (50 .00%) -(20 ,000) -% 22,305 (283,120) (7.30%) 52,369 (26,381) (66 .50%) (8 ,794) (8,794) -% (100,000) -(100.00%) (56,425) (35,175) (265 .53%) 175,620 6,562,637 2.75% 2024 ESTIMATED CAPITAL RESERVE AND RESERVE FUND CONTINUITY Uncommitted Current Budget Estimated Other Transfer to Capital • Uncommitted •• Capital Reserves Estimated Bal., Interest Current Estimated Bal., Jan.1,2024 Allocation Income Contributions Budget Funding Dec.31,2024 City Share DC Charges $ (7,753,140) $ (1 ,200 ,000) $ $ -$ 16 ,271 $ 845 ,600 $ (8,091,269) Equipment Replacement -(1 ,250 ,000) ---1,103,000 (147,000) Facilities (5,616,275) (1,000,000) ---2 ,422 ,500 (4,193,775) Fence (670,000) (270 ,000) -550 ,000 (390,000) Financial Systems (711,808) (125 ,000) --174,000 -(662,808) Senior's Centre (4,200,000) (700 ,000) -4,900 ,000 Library Building (370,000) (100 ,000) --470 ,000 Parks Infrastructure (253,333) (410 ,000) --238 ,500 (424,833) Sustainable Initiatives (291,576) ---285,000 (6,576) Tennis Court (565,065) (230,000) -727 ,000 (68 ,065) Vehicle Replacement (2,273,366) (1 ,700 ,000) --2 ,785 ,000 (1,188,366) N Total Capital Reserves $ (22,704,563) $ (6,985,000) $ -$ -$ 190,271 $ 14,326,600 $ • . (15,172,692) N CX> Uncommitted • Current Budget Estimated Other Transfer to Capital Uncommitted Capital Reserve Funds Estimated Bal., Interest Current Estimated Bal., Jan.1,2024 Allocation Income Contributions Budget Funding Dec.31,2024 Animal Shelter $ (497,958) $ (300,000) $ (4,980) $ $ $ -$ (802,938) Canada Community-Building Fund (2,190,404) (21,904) (3 ,118,419) 421 ,100 2,612 ,000 (2,297,627) Public Benefits Obligatory (268 ,251) -(2 ,683) ---(270,934) OCIF Grant (1,786,799) (17,868) (2 ,573 ,240) -3 ,885 ,000 (492 ,907) Operations Centre (7,615,976) (76 ,160) --2 ,730 ,500 (4,961,636) Parkland in Lieu (3,506,749) -(35,067) (250 ,000) 401,000 (3,390,816) Roads & Bridges (7,816,673) (2 ,600 ,000) (78,167) -3 ,780 ,000 (6,714,840) Seaton FIA (4,146,782) (41 ,468) (1 ,063 ,190) 703 ,931 (4,547,509) Stormwater Management (3,482,596) (800,000) (34,826) -1,750 ,000 (2,567,422) Total Capital Reserve Funds $ (31,312,188) $ (3,700,000) $ (313,123) $ (7,004,849) $ 421,100 $ 15,862,431 $ (26,046,629) N N co 2024 ESTIMATED CAPITAL RESERVE AND RESERVE FUND CONTINUITY Development Charges (DC) & Uncommitted Current Budget Estimated Other Transfer to Capital Uncommitted Community Benefit Charge (CBC) Estimated Bal., Interest Current Estimated Bal., Reserve Funds Jan. 1,2024 Allocation Income Contributions Budget Funding Dec.31,2024 DC -By-Law Enforcement $ 2,812 ,804 $ $ 28 ,128 $ (18 ,217) $ -$ -$ 2,822,715 Services DC -Fire Protection Services 6,210,577 -62 ,106 (1 ,192,417) 109 ,134 -5,189,400 DC -Library Services (8,740,707) -(87,407) (1 ,629 ,357) 26 ,381 6 ,346 ,658 (4,084,432) DC -Other Services Related to a 8,744,493 87,445 (537 ,545) 129 ,877 693 ,000 9,117,270 Highway DC -Parks & Recreation Services (29,049,686) -(290,497) (9 ,541 ,277) 169,402 35 ,815 ,609 (2,896 ,449) DC -Storm Water Managment (924,948) (9,249 ) (453 ,359) 199 ,222 60,400 (1,127,934) DC -Studies 1,853,690 18 ,537 (291,522) 564 ,605 2,145,310 DC -Transportation (20,363,138) -(203,631) (2,971 ,357) -649 ,100 (22,889,026) Community Benefit Charges 41,964 -420 (200 ,000) -148,274 (9,342) Total DC & CBC $ (39,414,951) $. $ (394,148) $ (16,835,051) $ 1,198,621 $ 43,713,041" $ (11,732,488) Reserve Funds TOTAL CAPITAL RESERVES & $ (S 3 431 70 2) $ (10,685 ,000) $ (707 ,271) $ (23 ,839 ,900) $ 1,809 ,992 $ 73 ,902 ,072 $ (52 ,951 ,809) RESERVE FUNDS ' '