Loading...
HomeMy WebLinkAbout2023 - FY2024 Q1 Quarterly General Fund Status Report General Fund Status Report — FY 2024 1st Quarter General Fund Summary For FY24, the City adopted a budget of$152.9 million in total revenue including transfers and $159.3 million in total expenditures. The amended budget has total revenues at $156.6 million and expenditures at $165.4 million. The difference will be made up between leftover ARPA revenue-loss money ($8.3 million) and use of fund balance ($515,000). Revenue Summary FY24 YTD 30.0% 25.0% 20.0% 15.0% 10.0% 5.0% 0.0% - y10c F General Fund revenue collected through the first quarter of fiscal year 2023-2024 exceed expectations. 39.3% of the amended budgeted revenue has been received, about 2.4% higher than the 3-year average for September 3O1h YTD. • Property Taxes (32.3% of GF revenue budget) are largely collected at the beginning of the fiscal year. They were initially estimated to be $5O.6M. At the end of the first quarter, collections were roughly$54.7M. Although collections currently exceed estimated amounts, they are subject to tax appeals and other adjustment throughout the fiscal year. 1 • Income Tax (27% of GF revenue budget) collections are below the first quarter average. At the end of the 1st quarter, income tax collections were $4.15M (9.8% of its budgeted $42.3M). This amount includes income tax accruals back into FY23 in the amount of $4,233,995.16. • Return on Equity (ROE) (17.1% of GF revenue budget) represents payment to the City from the Board of Water & Light. Historically, payments have been received in December and June. However, the new agreement calls for quarterly payment. The first quarterly payment has not been received yet. • State Revenue (14.8% of GF revenue budget) are estimated to be $23.2M in revenue Quarter 1 YTD is in line with past first quarter reports. • Charges for Services (5.9% of GF revenue budget) are trending slightly below the 3 Year Average for the 1st Quarter. • Fines and Forfeitures (1% of GF revenue budget) are budgeted to be $1.5M. Quarter- to-date, they are trending with expectations. • Licenses and Permits (1.2% of GF revenue budget) are estimated to be $1.8M. The City has received 8.3% of the budgeted amount and is on track. • Interest and Rents (0.4% of GF revenue budget) are budgeted to be $621,195 in FY24. The quarter-to-date amount of$26,514 is low because the interest income has yet to be put into our general ledger system. • Other Revenues (0.3% of GF revenue budget) are a very small percentage of the General Fund budget and are trending above expectations because of the opioid settlement money. 2 Expenditure Summary How the Money is Spent Adopted FY 2023/2024 General Fund Budget 159.3 Million Recreation Information Fleet/ Debt Service Public Service & Culture Technology... 1a Equipment Engineering 0 � Capital/Fun 4% 4% 1% d Transfers City 311 Service 5% 0% Retirement/Fixed Community Fringes Development 30% 6% Public Service 7% I General Government 8% Police Department 18% Fire Departme... FY24 YTD 35.0% 30.0% 25.0% 20.0% 15.0% 10.0% 5.0% I t 0.0% — `v chi ,+T� C v °� U O cxa N C C (U °� p u N c -o E ai F v o ¢ p ' U - p °o °c E v o 0 E E v g v v n U -Fa �n E i m L O Q O ', CL M Q U N i O W Q U > U v t LO o E o o K E > c 0 0 v U ao i� na p v L a c CO Y a1 V O E ' _U _ Y = U U 7 U z f6 �p = Q O U LL F U General Fund expenditures are trending below the 3-year target by about 2.5%. 3 Vacancy Factor There is a total of about 100 vacancies in the General Fund and around 59 in other funds. This totals over$1.6M in vacancy savings. Conclusion The administration continues to monitor expenditures and seek necessary savings to maintain vital services while also making strategic investments to grow the City's economy and strengthen the quality of life for residents, workers, business owners, and visitors. With the aid of the American Rescue Plan Act, the City has been able to restore services negatively impacted by the COVID-19 pandemic. The general fund budget report is presented in several formats for informational value as follows. After a separate revenue and expenditure summary, the City's general fund is presented as formally adopted in appropriation detail showing personnel vs. operating expenditures. 4 September 30, 2023 Revenue Summary Fiscal Year July 1, 2023 -June 30, 2024 FY 2024 FY 2024 FY 2023 Sep. 30 3 Year General Fund Revenues Adopted Amended Sep. 30 Percent Sep. 30 Budget Budget Actuals YTD Avg. Property Taxes Non-Dedicated 37,849,000 37,849,000 41,940,797 Dedicated - Police 3,827,250 3,827,250 3,827,250 Dedicated - Fire 3,827,250 3,827,250 3,827,250 Dedicated - Roads 2,551,500 2,551,500 2,551,500 Dedicated - Parks 2,551,500 2,551,500 2,551,500 Total 50,606,500 50,606,500 54,698,297 108.1% 100.4% Income Taxes City Income Tax 39,350,000 42,285,000 4,155,889 Total 39,350,000 42,285,000 4,155,889 9.8% 12.7% Return on Equity Board of Water and Light 26,500,000 26,500,000 - Sewer Fund 300,000 300,000 Total 26,800,000 26,800,000 - 0.0% 0.0% State Revenues Revenue Sharing 17,744,475 17,976,375 - Fire Reimbursement Grants 2,700,000 2,700,000 - Personal Property Tax Reimbursement 1,000,000 1,500,000 - Recreational Marijuana 900,000 918,100 - Liquor License Fee 80,000 80,000 80,363 Total 22,424,475 23,174,475 80,363 0.3% 0.3% Charges for Services Public Safety 4,404,350 4,404,350 845,073 Reimbursements 2,442,500 2,442,500 582,478 Code Compliance 1,851,000 1,851,000 221,674 Recreation Fees 468,750 468,750 171,677 Appeals&Petitions 89,700 89,700 9,590 Work for Others 33,200 33,200 43,988 Central Stores 3,500 3,500 320 Subscriptions and Information 2,300 2,300 65 Total 9,295,300 9,295,300 1,874,865 20.2% 23.7% Fines and Forfeitures Fines and Forfeitures 1,505,200 1,505,200 316,486 Total 1,505,200 1,505,200 316,486 21.0% 21.4% Licenses&Permits Cable Franchise Fees 1,000,000 1,000,000 - Marihuana Licenses 700,000 700,000 115,000 Business Licenses 71,450 71,450 23,055 Non-Business Licenses 35,600 35,600 8,834 Building Licenses & Permits 17,750 17,750 4,550 Total 1,824,800 1,824,800 151,439 8.3% 8.2% Interest&Rents Interest Income 621,195 621,195 26,514 Total 621,195 621,195 26,514 4.3% 38.2% Other Revenues Miscellaneous 173,000 173,000 94,125 Sale of Fixed Assets 120,000 120,000 - Donations &Contributions 119,000 119,000 8,097 Total 412,000 412,000 102,223 24.8% 13.9% Total General Fund Operating Revenue 152,839,470 156,524,470 61,406,076 39.2% 36.8% Transfers from Other Funds 100,000 100,000 100,000 Total 152,939,470 156,624,470 61,506,076 39.3% 36.9% 5 September 30, 2023 Departmental Summary Fiscal Year July 1, 2023 -June 30, 2024 FY 2024 FY 2024 FY 2024 Sep. 30 3 Year General Fund Appropriations Adopted Amended Sep. 30 Percent Sep. 30 Budget Budget Actuals YTD Tar4et Beginning General Fund Balance 10,746,256 10,746,256 10,746,256 Beginning Budget Stab. Fund Balance 12,705,546 12,705,546 12,705,546 Total General Fund Reserves 23,451,802 23,451,802 23,451,802 Revenues(detail on previous page) 152,939,470 156,624,470 61,506,076 39.3% 36.9% Departmental Expenditures: Council 657,507 794,819 142,027 17.9% 22.7% Internal Audit 219,000 231,514 49,819 21.5% 21.8% Mayor's Office 1,427,425 1,583,017 383,020 24.2% 22.2% Office of Community Media 626,456 704,994 139,857 19.8% 21.9% District Court 5,723,828 6,286,997 1,216,462 19.3% 22.3% Circuit Court Building Rental 337,363 337,363 842 0.2% 0.5% City Clerk's Office 1,602,373 1,780,665 330,760 18.6% 22.5% Neighborhood &Citizen Engagement 1,491,669 1,556,407 203,768 13.1% 22.8% Economic Development&Planning 6,272,104 6,820,769 1,802,812 26.4% 22.2% Finance Department 2,238,610 2,324,926 469,782 20.2% 22.5% City Assessor 1,707,829 1,987,550 316,948 15.9% 22.2% Treasury/Income Tax 2,036,385 2,332,359 446,592 19.1% 22.6% Human Resources Department 2,234,788 3,099,565 456,372 14.7% 22.9% City Attorney's Office 2,364,324 2,640,175 500,318 19.0% 22.0% Police Department 54,586,595 54,586,595 11,369,232 20.8% 23.5% Fire Department 41,448,217 41,448,217 9,032,742 21.8% 23.4% Public Service 13,506,989 13,606,989 1,377,408 10.1% 19.7% Human Relations&Community Services 2,045,764 2,221,776 368,157 16.6% 22.2% Parks&Recreation Department 8,092,939 9,335,135 1,542,234 16.5% 15.9% Human Service Agency Support 2,084,932 2,584,932 128,500 5.0% 21.6% Non-Departmental Expenditures: Library Building Rental 136,500 136,500 46,093 33.8% 25.0% Operating Subsidies to Other Funds 799,796 1,299,796 1,299,796 100.0% 100.0% City Supported Agencies 549,500 549,500 159,989 29.1% 0.7% Capital Improvements 7,325,000 7,325,000 7,325,000 100.0% 100.0% Debt Service&Penalties 1,341,410 1,341,410 - 0.0% 0.0% Vacancy Factor (1,500,000) (1,500,000) - City Recognitions 10,000 10,000 - Expenditures 159,367,303 165,426,970 39,108,531 23.6% 26.2% Net Impact on Fund Balance (6,427 833) (8,802,500) ARPA Reimbursement 8,287,500 8,287,500 Ending General Fund Reserves 25,311,469 22,936,802 6 September 30, 2023 Budget Appropriation Summary Fiscal Year July 1, 2023 -June 30, 2024 FY 2024 FY 2024 FY 2024 Sep. 30 3 Year Estimated Revenues Adopted Amended Sep. 30 Percent Sep. 30 Budget Budget Actuals YTD Avg. Property Taxes 50,606,500 50,606,500 54,698,297 Income Taxes 39,350,000 42,285,000 4,155,889 Return on Equity 26,800,000 26,800,000 - State Revenues 22,424,475 23,174,475 80,363 Charges for Services 9,295,300 9,295,300 1,874,865 Fines& Forfeitures 1,505,200 1,505,200 316,486 Licenses &Permits 1,824,800 1,824,800 151,439 Interest& Rent 621,195 621,195 26,514 Other Revenue 412,000 412,000 102,223 Transfers from Other Funds 100,000 100,000 100,000 Total Revenues 152,939,470 156,624,470 61,506,076 39.3% 36.9% FY 2024 FY 2024 FY 2024 Sep. 30 Sep. 30 Appropriations Adopted Amended Sep. 30 Percent Target Budget Budget Actuals YTD Exp. Council Personnel 541,898 541,898 117,765 Operating 115,609 252,921 24,262 Total 657,507 794,819 142,027 17.9% 22.7% Internal Audit Personnel 219,000 219,000 47,504 Operating - 12,514 2,315 Total 219,000 231,514 49,819 21.5% 21.8% Courts Personnel 5,088,290 5,088,290 1,026,494 Operating 972,901 1,536,070 190,810 Total 6,061,191 6,624,360 1,217,304 18.4% 21.2% Mayor's Office Personnel 1,309,579 1,309,579 335,695 Operating 117,846 273,438 47,325 Total 1,427,425 1,583,017 383,020 24.2% 22.2% Media Center Personnel 622,556 622,556 122,631 Operating 3,900 82,438 17,226 Total 626,456 704,994 139,857 19.8% 21.9% Clerk's Office Personnel 1,183,378 1,183,378 238,322 Operating 418,995 597,287 92,438 Total 1,602,373 1,780,665 330,760 18.6% 22.5% Neighborhood &Citizen Engagement Personnel 1,018,426 1,018,426 173,849 Operating 473,243 537,981 29,919 Total 1,491,669 1,556,407 203,768 13.1% 22.8% Economic Development&Planning Personnel 3,451,387 3,451,387 719,813 Operating 2,820,717 3,369,382 1,082,999 Total 6,272,104 6,820,769 1,802,812 26.4% 22.2% Finance/Operations Personnel 1,770,206 1,770,206 400,745 Operating 468,404 554,720 69,037 Total 2,238,610 2,324,926 469,782 20.2% 22.5% 7 FY 2024 FY 2024 FY 2024 Sep. 30 Sep. 30 Appropriations Adopted Amended Sep. 30 Percent Target Budget Budget Actuals YTD Exp. Assessing Personnel 1,707,829 1,707,829 283,695 Operating - 279,721 33,253 Total 1,707,829 1,987,550 316,948 15.9% 22.2% Treasury Personnel 1,749,356 1,749,356 355,318 Operating 287,029 583,003 91,274 Total 2,036,385 2,332,359 446,592 19.1% 22.6% Human Resources Personnel 1,968,618 1,968,618 345,457 Operating 266,170 1,130,947 110,915 Total 2,234,788 3,099,565 456,372 14.7% 22.9% Attorney's Office Personnel 2,364,324 2,364,324 456,190 Operating - 275,851 44,128 Total 2,364,324 2,640,175 500,318 19.0% 22.0% Police Personnel 45,876,734 45,876,734 10,266,051 Operating 8,709,861 8,709,861 1,103,180 Total 54,586,595 54,586,595 11,369,232 20.8% 23.5% Fire Personnel 35,291,150 35,291,150 8,457,333 Operating 6,157,067 6,157,067 575,408 Total 41,448,217 41,448,217 9,032,742 21.8% 23.4% Public Service Personnel 3,695,596 3,695,596 605,508 Operating 9,811,393 9,911,393 771,900 Total 13,506,989 13,606,989 1,377,408 10.1% 19.7% Human Relations&Community Service Personnel 1,894,264 1,894,264 333,054 Operating 151,500 327,512 35,104 Total 2,045,764 2,221,776 368,157 16.6% 22.2% Parks &Recreation Personnel 5,299,345 5,299,345 1,016,479 Operating 2,793,594 4,035,790 525,755 Total 8,092,939 9,335,135 1,542,234 16.5% 15.9% Human Services Operating 2,084,932 2,584,932 128,500 Total 2,084,932 2,584,932 128,500 5.0% 21.6% City Supported Agencies/MRJEA Operating 549,500 549,500 159,989 Total 549,500 549,500 159,989 29.1% 0.7% City Recognitions 10,000 10,000 - Total 10,000 10,000 - 0.0% Non-Departmental Vacancy Factor (1,500,000) (1,500,000) - Library Lease 136,500 136,500 46,093 Debt Service 1,341,410 1,341,410 - Net Transfers 8,124,796 8,624,796 8,624,796 Total 8,102,706 8,602,706 8,670,889 100.8% 97.8% Total Expenditures 159,367,303 165,426,970 39,108,531 23.6% 26.2% 8 Vacancy Factor Report Quarter Ending September 30,2023 Department Key PCN Position Description Bargaining Unit FTE Vacancy Vacancy Factor Vacancies Counted Toward General Fund Vacancy Factor MAYOR 1012300 LABREMGR CHIEF LABOR NEGOTIATOR MAYOR 1.00 2/1/2023 26,874 NEIGH CTZN ENG 1012320 OPCOORDR MFE PROGRAM MANAGER T243CTP 1.00 5/27/2023 15,600 HRCS 1012500 DIEOPSPC DIVERSITY,INCLUSION&EO SPECIALIST T243CTP 1.00 7/14/2023 12,733 HRCS 1012500 COMMINVT COMMISSION INVESTIGATOR T214NS 1.00 7/3/2023 14,822 HRCS 1012500 HMISPFAN HMIS PERFORMANCE ANALYST T214NS 1.00 10/1/2021 14,226 HRCS 1012500 CNTRTMGR CONTRACT MANAGER T243CTP 1.00 3/18/2023 15,541 HRCS 1012500 CNTRTMGR CONTRACT MANAGER T243CTP 1.00 5/26/2023 15,541 CODE COMPLIANCE 1012610 CCOFICER CODE ENFORCEMENT WORKER T243CTP 1.00 9/2/2023 5,578 CODE COMPLIANCE 1012610 CCOFICER CODE ENFORCEMENT WORKER T243CTP 1.00 6/24/2023 18,128 CODE COMPLIANCE 1012610 LDHOUSIN LEAD HOUSING INSPECTOR T243SUPV 1.00 8/21/2022 18,014 CODE COMPLIANCE 1012610 PRMISOFF PREMISE OFFICER T243CTP 1.00 4/1/2023 9,615 FINANCE/OPERATIONS 1012710 FINDRCTR FINANCE DIRECTOR EXEC MGMT PLAN 0.50 8/13/2021 NO BDGT IMPACT FINANCE/OPERATIONS 1012710 DPYFINDIR DEPUTY FINANCE DIRECTOR NON BARG SUPV 1.00 2/28/2023 NO BDGT IMPACT FINANCE/OPERATIONS 1012710 ACCOUNT34 ACCOUNTANT 34 T243CTP 1.00 2/14/2023 12,759 ASSESSOR 1012720 COMINDAP COMMERICAL/INDUSTRIALAPPRAISR T243CTP 1.00 6/15/2022 23,207 ASSESSOR 1012720 RESAPPLD RESIDENTIAL APPRAISER LEAD T243CTP 1.00 10/18/2019 18,128 ASSESSOR 1012720 RESAPPTR RESIDENTIAL APPRAISER APPRENTICE T243CTP 1.00 5/24/2019 14,876 ASSESSOR 1012720 RESIDAPP RESIDENTIAL APPRAISER T243CTP 1.00 10/5/2017 CONTRACT TREASURY 1012730 CTYTREASR CITY TREASURER EXEC MGMT PLAN 0.50 8/13/2021 NO BDGT IMPACT TREASURY 1012730 CUSTSREP CUSTOMER SERVICE REP T243CTP 1.00 9/17/2022 10,558 TREASURY 1012730 ADMAST28 ADMINISTRATIVE ASSISTANT28 T243CTP 1.00 10/8/2022 14,177 TREASURY 1012730 TRESYINV TREASURERY INVESTIGATOR T243CTP 1.00 8/20/2022 17,268 TREASURY 1012730 CUSTSREP CUSTOMER SERVICE REP T243CTP 1.00 2/20/2021 10,558 HUMAN RESOURCES 1012800 HRSPEC34 HIRING SPECIALIST T243CTP 1.00 5/19/2023 CONTRACT HUMAN RESOURCES 1012800 HRSPEC34 HIRING SPECIALIST T243CTP 1.00 6/25/2022 CONTRACT HUMAN RESOURCES 1012800 SAFTYADM HEALTH&WELLNESS SPECIALIST T243CTP 0.25 7/1/2022 3,719 CITYATTORNEY 1012900 LGLADVSR LEGALADVISOR T214NS 1.00 7/1/2020 18,180 CITY ATTORNEY 1012800 ASTATY36 ASSISTANT CITY ATTORNEY T214 NS 1.00 11/11/2022 24,470 CITY ATTORNEY 1012800 ASTATY36 ASSISTANT CITY ATTORNEY T214 NS 1.00 9/16/2023 3,765 PUBLIC SERVICE/BUILDINGS 1013140 CUSTOWKR CUSTODIAL WORKER 300 UAW 1.00 12/3/2021 10,128 PUBLIC SERVICE/BUILDINGS 1013140 ELECFACW ELECTRICAL FACILITY CTRL WKR UAW 1.00 11/2/2018 12,036 PUBLIC SERVICE/BUILDINGS 1013140 PROPTMGR PROPERTY MANAGER T243SUPV 1.00 6/30/2023 18,921 PUBLIC SERVICE/BUILDINGS 1013140 PLUMBSUP PLUMBING SUPERVISOR T243SUPV 1.00 6/10/2018 20,016 POLICE-ADMIN 1013201 ADMSPC31 ADMINISTRATIVE SPECIALIST31 T214NS 1.00 12/28/2011 CONTRACT POLICE-CENTRAL SERVICES 1013221 POLCADET POLICECADET CCLPNONREP 1.00 3/9/2023 7,800 POLICE-CENTRAL SERVICES 1013221 POLCADET POLICECADET CCLPNONREP 1.00 9/29/2023 120 POLICE-CENTRAL SERVICES 1013221 CLERKS22 CENTRAL RECORD PRINCIPAL CLERK T243CTP 1.00 7/1/2022 11,180 POLICE-DETENTION 1013224 DETENOFF DETENTION OFFICER T243CTP 1.00 05/02/22 18,128 POLICE-DETENTION 1013224 DETENOFF DETENTION OFFICER T243CTP 1.00 09/22/22 18,128 POLICE-DETENTION 1013224 DETENOFF POLICE OFFICER 1 CCLP NS 1.00 1/31/2023 19,644 POLICE-INVESTIGATIONS 1013240 DETECT2C DETECTIVE IIC CCLP NS 1.00 5/1/2021 20,999 POLICE-INVESTIGATIONS 1013240 DETECT213 DETECTIVE 1113 CCLP NS 1.00 8/26/2023 8,077 POLICE-INVESTIGATIONS 1013240 DETECT213 DETECTIVE IIB CCLP NS 1.00 8/14/2023 11,307 POLICE-INVESTIGATIONS 1013240 DETECT213 DETECTIVE 1113 CCLP NS 1.00 7/21/2023 16,477 POLICE-INVESTIGATIONS/CSI 1013240 DTCTVCSI CSIINVESTIGATOR CCLP NS 1.00 09/24/22 13,745 POLICE-INVESTIGATIONS/SOS 1013240 POLOFFDT POLICE OFFICER DETECTIVE PAY CCLP NS 1.00 06/O1/23 20,999 POLICE-INVESTIGATIONS/SOS 1013240 POLOFFDT POLICE OFFICER DETECTIVE PAY CCLP NS 1.00 02/14/23 20,999 POLICE-INVESTIGATIONS/SOS 1013240 POLOFFDT POLICE OFFICER DETECTIVE PAY CCLP NS 1.00 06/16/22 20,999 POLICE-INVESTIGATIONS/CSI 1013240 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 07/14/22 13,745 POLICE-INVESTIGATIONS/CSI 1013240 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 12/17/22 13,745 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 09/15/23 2,326 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 09/08/23 3,383 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 09/01/23 4,441 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 08/17/23 6,767 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 08/16/23 6,978 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 05/06/23 13,745 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 04/04/23 13,745 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 02/21/23 13,745 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 01/13/23 13,745 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 12/30/22 13,745 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 12/03/22 13,745 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 10/29/22 13,745 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 07/14/22 13,745 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 12/10/21 13,745 POLICE-PATROL 1013251 CRMRESAN CRIME RESEARCH ANALYST T243CTP 1.00 05/20/22 CONTRACT FIRE-ADMIN 1013501 ASTFIRCF ASSISTANT FIRE CHIEF NB SUPV 1.00 9/14/2023 OVERTIME FIRE-LOGISTICS 1013510 SECRTY26 SECRETARY T243CTP 1.00 6/24/2023 9,167 FIRE-LOGISTICS 1013510 MATALSP3 MAINTENANCE ALARM SPECIALIST IAFF 1.00 7/1/2022 14,706 FIRE-PREVENTION 1013530 INSPECT4 INSPECTORIV IAFF 1.00 9/14/2023 4,084 FIRE-PREVENTION 1013530 INSPECT4 INSPECTORIV IAFF 1.00 3/11/2023 22,122 FIRE-PREVENTION 1013530 FIRMARS6 FIRE MARSHALL VI IAFF 1.00 9/14/2023 4,705 9 Vacancy Factor Report Quarter Ending September 30,2023 Department Key PCN Position Description Bargaining Unit FTE Vacancy Vacancy Factor FIRE-OPERATIONS 1013520 CAPTAIN4 CAPTAIN IV IAFF 1.00 9/25/2023 OVERTIME FIRE-OPERATIONS 1013520 CAPTAIN4 CAPTAIN IV IAFF 1.00 9/24/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 9/23/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 9/23/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 9/23/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 9/23/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 9/23/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 9/23/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 8/26/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 8/12/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 8/10/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 8/3/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 6/7/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 6/6/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 5/25/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 5/1/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 3/23/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 2/25/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 2/24/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 2/23/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 1/17/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 12/16/2022 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 11/21/2022 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 11/11/2022 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 11/5/2022 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 5/7/2022 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 10/23/2021 OVERTIME FIRE-TRAINING 1013540 SECRTY26 SECRETARY T243CTP 1.00 9/8/2023 2,477 PARKS/BUSINESS&MGMT 1013810 ADMAST28 ADMIN ASSISTANT T243CTP 1.00 9/13/2023 1,923 PARKS/BUSINESS&MGMT 1013810 PTCLRK23 PT CLERK 23 T243CTP PT 0.50 1/6/2023 3,807 PARKS/COMMUNITY CENTERS 1013811 PTCLRK22 PT CLERK 22 T243CTP PT 0.50 7/24/2023 2,796 PARKS/COMMUNITY CENTERS 1013811 PTCTRPRG PT COMMUNITY CENTER PROGRMMR T243PT 0.50 6/25/2021 7,089 l:t Quarter Vacancy factor: 99.75 856,010 10 Vacancy Factor Report Quarter Ending September 30,2023 Department Key PCN Position Description Bargaining Unit FTE Vacancy Vacancy Factor Non-Vacancy Factor(non-General Fund)Vacancies PUBLIC SERVICE/O&M 1013611 FRSTWKR6 ARBORIST500 UAW 1.00 6/1/2023 12,036 PUBLIC SERVICE/O&M 1013611 FRSTWKR6 ARBORIST500 UAW 1.00 7/20/2019 12,036 PUBLIC SERVICE/O&M 1013611 DRIVRWKR DRIVER WORKER 300 UAW 1.00 09/19/2023 1,534 PUBLIC SERVICE/O&M 1013611 DRIVRWKR DRIVER WORKER 300 UAW 1.00 06/18/2022 11,079 PUBLIC SERVICE/O&M 1013611 DRIVRWKR DRIVER WORKER 300 UAW 1.00 03/31/2022 11,079 PUBLIC SERVICE/O&M 1013611 DRIVRWKR DRIVER WORKER 300 UAW 1.00 01/16/2022 11,079 PUBLIC SERVICE/O&M 1013611 SNMATWKR MAINTENANCE WORKER UAW 1.00 03/26/2021 11,079 PUBLIC SERVICE/O&M 1013611 SWRTMWK5 SEWER MAINTENANCE WORKER UAW 1.00 03/15/2023 13,016 PUBLIC SERVICE/O&M 1013611 CRTFNWRK CONCRETE WORKER UAW 1.00 03/28/2023 12,036 PUBLIC SERVICE/O&M 1013611 FRSTWKR5 ARBORIST500 UAW 1.00 02/22/2023 12,036 PUBLIC SERVICE/O&M 1013611 PKSMTWK4 PARKS MAINTENANCE WORKER UAW 1.00 09/29/2023 185 PUBLIC SERVICE/O&M 1013611 PKSMTWK4 PARKS MAINTENANCE WORKER UAW 1.00 07/26/2023 8,888 PUBLIC SERVICE/O&M 1013611 ECPOPWK4 EQUIPMENT OPERATOR WORKER 400 UAW 1.00 01/27/2023 12,036 PUBLIC SERVICE/O&M 1013611 SWRMTWK3 SEWER MAINTENANCE WORKER T243SUPV 1.00 01/31/2022 13,016 PUBLIC SERVICE/O&M 1013611 OMSUPERT O&M SUPERINTENDENT NBSUPV 1.00 5/8/2023 22,663 PUBLIC SERVICE/O&M 1013611 WWMATWK6 WASTEWATER MAINTENANCE WKR 600 T243SUPV 1.00 5/27/2020 13,016 PUBLIC SERVICE/O&M 1013611 PUBWKSUP PUBLIC SERVICE SUPERVISOR T243SUP 1.00 12/4/2021 18,128 PUBLIC SERVICE/O&M 1013611 SOLWASUP SOLID WASTE SUPERVISOR T243SUP 1.00 8/15/2020 16,421 ED&P/CDBG REHAB 5266305600 CMDEVCRD COMMUNITY DEVELOPMENT COORDINATOR T243SUPV 1.00 5/5/2023 23,207 ED&P/BUILDING SAFETY 2492610 BLDINSPC BUILDING INSPECTOR T243CTP 1.00 7/21/2023 12,884 ED&P/BUILDING SAFETY 2492610 PLNREVSU PLANT REVIEW SUPERVISOR T214SUPV 1.00 1/8/2022 20,016 ED&P/BUILDING SAFETY 2492610 MECINSPC MECHANICAL INSPECTOR T243CTP 1.00 6/30/2023 18,128 ED&P/PARKING 5853641 CUSTSREP CUSTOMER SERVICE REP 28 T243CTP 1.00 1/22/2018 14,876 ED&P/PARKING 5853641 MANTWKR2 MAINTENANCE WORKER 200 UAW 1.00 4/19/2023 12,036 ED&P/PARKING 5853641 PKGRVCOL PARKINS SERVICES WORKER UAW 1.00 3/27/2023 8,532 PUBLIC SERVICE/WWTP 5903670 ASPLSUPT ASSIST PLANT SUPERINTENDENT NBSUPV 1.00 7/31/2020 21,561 PUBLIC SERVICE/WWTP 5903670 LABSUP-TBD LAB SUPERVISOR T243SUP 1.00 7/1/2017 18,128 PUBLIC SERVICE/WWTP 5903670 INDSRSUP INDUSTRIAL SURVELIANCE SUPERVISOR T243CTP 1.00 7/1/2015 18,128 PUBLIC SERVICE/WWTP 5903670 ELECTECH ELECTRICAL TECHNICIAN T243CTP 1.00 10/5/2006 15,642 PUBLIC SERVICE/WWTP 5903670 WWMATWK6 WASTE WATER PLANT LABORER UAW 1.00 7/12/2019 12,036 PUBLIC SERVICE/WWTP 5903670 WWSYSANL WASTEWATER SYSTEMS ANALYST T243CTP 1.00 10/23/2015 16,421 PUBLIC SERVICE/WWTP 5903670 UTLELWKR UTILITY ELECTRICAL WORKER UAW 1.00 10/1/2022 13,016 PUBLIC SERVICE/WWTP 5903670 WWMATWK6 WASTEWATER MAINTENANCE WKR 600 UAW 1.00 2/23/2023 13,016 PUBLIC SERVICE/WWTP 5903670 PLOPSU33 PLANT OPERATIONS SUPERVISOR 33 T243SUPV 1.00 4/29/2023 14,078 PUBLIC SERVICE/WWTP 5903670 UTMATWK4 UTILITY MAINT WORKER 400 UAW 1.00 12/31/2022 11,079 PUBLIC SERVICE/WWTP 5903670 LABTECHN LABORATORY TECHNICIAN T243CTP 1.00 6/30/2023 10,062 PUBLIC SERVICE/WWTP 5903670 WWPLTOPS WASTEWATER PLANT OPERATOR UAW 1.00 9/16/2023 1,852 PUBLIC SERVICE/WWTP 5903670 WWPNTOP6 WASTEWATER MAINTENANCE WKR 600 UAW 1.00 1/28/2023 13,016 INFO TECH 6303130 ADMSPC30 ADMINISTRATIVE SPECIALIST T243CTP 1.00 9/30/2023 - PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 9/15/2023 2,203 PUBLIC SERVICE/FLEET 6433623 RADIOTEC RADIO INST.TECHNICIAN T243CTP 1.00 7/14/2023 8,669 PUBLIC SERVICE/FLEET 6433623 ATGARSUP ASSIST SHIFT GARAGE SUPERVISOR T243SUP 1.00 7/1/2017 14,876 PUBLIC SERVICE/FLEET 6433623 ATGARSUP ASSIST SHIFT GARAGE SUPERVISOR T243SUP 1.00 7/12/2019 14,876 PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 3/29/2019 13,016 PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 5/13/2019 13,016 PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 8/17/2019 13,016 PUBLIC SERVICE/FLEET 6433623 SRVCSPEC SERVICE SPECIALIST T243CTP 1.00 9/20/2019 11,731 PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 6/4/2022 13,016 PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 7/21/2021 13,016 PUBLIC SERVICE/FLEET 6433623 VEHWKR04 VEHICLE MAINTENANCE WORKER 400 UAW 1.00 11/1/2020 11,079 PUBLIC SERVICE/ENGINEERING 6453603 ENGTEC34 ENGINEERING TECHNICIAN SUPV T243SUPV 1.00 4/17/2023 14,779 PUBLIC SERVICE/ENGINEERING 6453603 ENGINR38 ENGINEER 38 T214NS 1.00 1/26/2023 23,286 PUBLIC SERVICE/ENGINEERING 6453603 ENGINR38 ENGINEER 38 T214NS 1.00 6/6/2019 23,286 PUBLIC SERVICE/ENGINEERING 6453603 TRANSENG TRANSPORTATION ENGINEER NB SUPV 1.00 1/1/2020 27,631 HUMAN RESOURCES 1012800 SAFTYADM HEALTH&WELLNESS SPECIALIST T243CTP 0.75 7/1/2022 11,157 HUMAN RESOURCES 1012800 PTPRTECH PT RETIREMENT ANALYST T243PT 0.50 7/1/2022 7,821 DISTRICT COURT 7602201 PROBOFCR PROBATION OFFICER DCT243 1.00 4/1/2021 13,373 DISTRICT COURT 7602201 DPCLERK2 DEPUTY CLERK 2 DCT243 1.00 8/28/2023 3,834 DISTRICT COURT 7602201 DPCLERK2 DEPUTY CLERK 2 DCT243 1.00 7/15/2023 8,436 DISTRICT COURT 7602201 PROBOFCR PROBATION OFFICER DCT243 1.00 7/12/2019 CONTRACT l:t Quarter Vacancy factor: 59.25 761,193 Total 1st Quarter Vacancy factor 159.00 1,617,203.11 11