HomeMy WebLinkAbout2024 - General Fund Status Report FY 2024 3rd Quarter General Fund Status Report — FY 2024 3rd 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 a total revenue including
transfers and ARPA reimbursement of about $166.0 million and total expenditures including
FY23 carryforwards of$167.1 million. As of 6/30/2023, the General Fund balance is $29.7M,
with $20.9M unassigned. This a 13.9%fund balance ratio.
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.
Revenue Summary
FY24 YTD
140.0%
120.0%
100.0%
80.0%
60.0%
40.0%
20.0%
0.0%
5 J I S ( S a+0 J ` JCS
e �o eJe� h�� o`key, Qec O� eJ��
Jt0 a�e<: 5k�c ae, e 4} tey� eta
F
General Fund revenue collected through the third quarter of FY24 were almost $113.2M, 71.8%
of the amended budget year-to-date.
1
• Property Taxes (32.1% of GF revenue budget) are largely collected at the beginning of
the fiscal year. They were initially estimated to be $50.6M. At the end of the third
quarter, collections were roughly $50.4M.
• Income Tax (26.8% of GF revenue budget) collections were $25.2M (59.6% of its
budgeted $42.3M). Due to timing of reviewing state tapes for compliance and with
resulting delays in collection, we are catching up in the most recent quarter.
• Return on Equity (ROE) (17% 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, expiring June 301", calls for quarterly
payment. We are currently negotiating a renewal contract to be effective for the
upcoming year. We have received almost 47% of the amended budget year-to-date. We
also received $5,946,002.85 on April 29t", after the quarter ended.
• State Revenue (15.3% of GF revenue budget) are budgeted to be $24.2M in revenue.
Quarter 3 YTD is higher than the three-year average, with year-end revenue estimates
expected to increase from the current budget.
• Charges for Services (5.9% of GF revenue budget) are trending higher than the three-
year average for the 3rd Quarter. Higher revenues can be attributed largely to
ambulance revenues exceeding budgeted revenues.
• Fines and Forfeitures (1% of GF revenue budget) are budgeted to be $1.5M. Quarter-
to-date, they are trending below expectations.
• Licenses and Permits (1.2% of GF revenue budget) are estimated to be $1.8M. The City
has received 58% 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 is over $770,000.
• Other Revenues (0.3% of GF revenue budget) are a very small percentage of the
General Fund budget and are trending above expectations.
2
Expenditure Summary
How the Money is Spent
Adopted FY 2023/2024 General Fund Budget
159.3 Million
Recreation Fleet/ Public Service
Information Debt Service Engineering
& Culture Technology.Equ��ent 1% °
Capital/Fu 4% 1%
nd City 311 Service
°
Transfers... Retirement/Fixed
Community Fringes
Development 30%
6%
Public Service
7%
General
Government
8% Police
Department
Fire 18%
Departm...
-EL-
FY24 Expenditures YTD
80.0%
70.0%
60.0%
50.0%
40.0%
30.0%
10.0%° — I:
•� u Yt3LO a) °2S C O m a) � C u cz p cvi
� 3 o o o E a� L a) (U > >
U Q p c� .� p °o °c L
E E o2 °Oao v-E O v m CL
u.
N >` c N N W N K u N
+- @ U L � N L " c O E >.
C 0 O (J °A U i f6 O 41 v a Oco
7 Y
Y i+ Z N Y C
u 7 U ca ra 2 Q O cc
W L �_ ! d = d
O CU LL H U
3
General Fund expenditures are trending below the 3-year target by about 4%. A final year-end
budget adjustment will be introduced for final adjustments and to allocate the vacancy factor.
Vacancy Factor
There is a total of about 64 vacancies in the General Fund (out of 619 positions) and around 57
in other funds (out of 330). This totals over $1.5M in estimated vacancy savings in the third
quarter. More than 40 new openings occurred due to various circumstances, including internal
promotions and transfers, with hirings holding vacancy rates consistent overall from the
previous quarter.
Positions filled during the quarter include:
Department Position Description
HRCS DIVERSITY, INCLUSION & EO SPECIALIST
HRCS HMIS PERFORMANCE ANALYST
TREASURY CITY TREASURER
HUMAN RESOURCES PAYROLL TECHNICIAN
POLICE - PATROL SOCIAL WORKER
FIRE - ADMIN ASSISTANT FIRE CHIEF
PUBLIC SERVICE/O&M ARBORIST 500
PUBLIC SERVICE/O&M SEWER MAINTENANCE WORKER
PUBLIC SERVICE/O&M PARKS MAINTENANCE WORKER
PUBLIC SERVICE/O&M O&M SUPERINTENDENT
ED&P/CDBG REHAB REHAB CONSTRUCTION SPCLST
ED&P/PARKING CUSTOMER SERVICE REP 28
PUBLIC SERVICE/WWTP WASTEWATER PLANT OPERATOR
PUBLIC SERVICE/FLEET MECHANIC
PUBLIC SERVICE/FLEET VEHICLE MAINTENANCE WORKER 400
PUBLIC SERVICE/ENGINEERING ENGINEERING TECHNICIAN SUPV
HUMAN RESOURCES PT RETIREMENT ANALYST
4
The city currently has 21 full-time position postings on the city's website as of 4/30/24 and
seven other employment opportunities. The full-time position listings include:
Department Position
ASSESSOR Lead Residential Appraiser
ASSESSOR Commercial Industrial Appraiser
CODE COMPLIANCE Code Enforcement Officer(5 positions)
ED&P/BUI LDI NG SAFETY Chief Building Inspector
ED&P/BUI LDI NG SAFETY Electrical Inspector
ED&P/BUI LDI NG SAFETY Building Inspector(2 positions)
ED&P/BUI LDI NG SAFETY Chief Electrical Inspector
ED&P/BUI LDI NG SAFETY Mechanical Inspector
HUMAN RESOURCES Health &Wellness Technician
NEIGH CTZN ENG Financial Counselor
PARKS Administrative Specialist
POLICE Police Officer Certified/Certifiable(11 positions)
POLICE Detention Officer(2 positions)
PUBLIC SERVICE ADMIN Assistant City Engineer(Environment)
PUBLIC SERVICE/FLEET Fleet Mechanic (7 positions)
PUBLIC SERVICE/O&M Accounting and Operations Specialist
PUBLIC SERVICE/O&M Arborist-Forestry Worker
PUBLIC SERVICE/O&M Maintenance Worker(2 positions)
PUBLIC SERVICE/WWTP Laboratory Supervisor
5
March 31, 2024 Revenue Summary
Fiscal Year July 1, 2023 -June 30, 2024
FY 2024 FY 2024 FY 2023 Mar. 31 3 Year
General Fund Revenues Adopted Amended Mar. 31 Percent Mar. 31
Budget Budget Actuals YTD Avg.
Property Taxes
Non-Dedicated 37,849,000 37,849,000 37,617,067
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 50,374,567 99.5% 99.8%
Income Taxes
City Income Tax 39,350,000 42,285,000 25,220,262
Total 39,350,000 42,285,000 25,220,262 59.6% 60.1%
Return on Equity
Board of Water and Light 26,500,000 26,500,000 12,486,715
Sewer Fund 300,000 300,000 -
Total 26,800,000 26,800,000 12,486,715 46.6% 51.1%
State Revenues
Revenue Sharing 17,744,475 17,976,375 9,506,483
Fire Reimbursement Grants 2,700,000 2,700,000 2,547,788
Personal Property Tax Reimbursement 1,000,000 1,500,000 904,646
Recreational Marijuana 900,000 918,100 1,418,072
Liquor License Fee 80,000 80,000 81,078
Capital City Allocation - 1,000,000 -
Total 22,424,475 24,174,475 14,458,068 59.8% 58.9%
Charges for Services
Public Safety 4,404,350 4,404,350 3,558,708
Reimbursements 2,442,500 2,442,500 1,796,839
Code Compliance 1,851,000 1,851,000 1,520,751
Recreation Fees 468,750 468,750 487,915
Appeals&Petitions 89,700 89,700 51,645
Work for Others 33,200 33,200 53,928
Central Stores 3,500 3,500 500
Subscriptions and Information 2,300 2,300 3,840
Total 9,295,300 9,295,300 7,474,125 80.4% 63.4%
Fines and Forfeitures
Fines and Forfeitures 1,505,200 1,505,200 945,216
Total 1,505,200 1,505,200 945,216 62.8% 70.5%
Licenses &Permits
Cable Franchise Fees 1,000,000 1,000,000 435,658
Marihuana Licenses 700,000 700,000 515,000
Business Licenses 71,450 71,450 76,087
Non-Business Licenses 35,600 35,600 22,819
Building Licenses&Permits 17,750 17,750 12,300
Total 1,824,800 1,824,800 1,061,865 58.2% 58.7%
Interest&Rents
Interest Income 621,195 621,195 770,930
Total 621,195 621,195 770,930 124.1% 104.0%
Other Revenues
Miscellaneous 173,000 173,000 111,880
Sale of Fixed Assets 120,000 120,000 1,973
Donations&Contributions 119,000 119,000 151,338
Total 412,000 412,000 265,191 64.4% 63.7%
Total General Fund
Operating Revenue 152,839,470 157,524,470 113,056,939 71.8% 71.1%
Transfers from Other Funds 100,000 100,000 100,000
Total 152,939,470 157,624,470 113,156,939 71.8% 71.1%
6
March 31, 2024 Departmental Summary
Fiscal Year July 1, 2023-June 30, 2024
FY 2024 FY 2024 FY 2024 Mar. 31 3 Year
General Fund Appropriations Adopted Amended Mar. 31 Percent Mar. 31
Budget Budget Actuals YTD Target
Total General Fund Reserves 29,661,497 29,661,497 23,451,802
Revenues(detail on previous page) 152,939,470 157,624,470 113,156,939 71.8% 71.1%
Departmental Expenditures:
Council 657,507 794,819 502,253 63.2% 72.8%
Internal Audit 219,000 231,514 164,115 70.9% 71.8%
Mayor's Office 1,427,425 1,583,017 1,118,591 70.7% 72.2%
Office of Community Media 626,456 704,994 481,621 68.3% 72.1%
District Court 5,723,828 6,286,997 4,205,453 66.9% 72.5%
Circuit Court Building Rental 337,363 337,363 344,557 102.1%
City Clerk's Office 1,602,373 1,820,665 1,251,477 68.7% 72.7%
Neighborhood&Citizen Engagement 1,491,669 1,556,407 762,368 49.0% 72.7%
Economic Development&Planning 6,272,104 6,820,769 4,442,568 65.1% 72.3%
Finance Department 2,238,610 2,324,926 1,639,346 70.5% 72.6%
City Assessor 1,707,829 1,987,550 1,098,889 55.3% 72.3%
Treasury/Income Tax 2,036,385 2,332,359 1,567,061 67.2% 72.7%
Human Resources Department 2,234,788 3,099,565 1,910,288 61.6% 73.0%
City Attorney's Office 2,364,324 2,640,175 1,722,938 65.3% 72.1%
Police Department 54,586,595 54,586,595 38,737,708 71.0% 73.6%
Fire Department 41,448,217 41,448,217 30,490,407 73.6% 73.6%
Public Service 13,506,989 13,606,989 9,201,498 67.6% 73.9%
Human Relations&Community Services 2,045,764 2,221,776 1,276,739 57.5% 72.3%
Parks&Recreation Department 8,092,939 9,335,135 5,985,829 64.1% 72.9%
Human Service Agency Support 2,084,932 3,505,776 1,845,720 52.6% 75.0%
Non-Departmental Expenditures:
Library Building Rental 136,500 136,500 117,637 86.2% 75.0%
Operating Subsidies to Other Funds 799,796 1,299,796 1,299,796 100.0% 100.0%
City Supported Agencies 549,500 1,256,366 250,010 19.9% 75.0%
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%
Vacancy Factor (1,500,000) (1,500,000) -
City Recognitions 10,000 10,000 3,656
Expenditures 159,367,303 167,094,680 117,745,525 70.5% 74.6%
Net Impact on Fund Balance (6,427,833) (9,470,210)
ARPA Reimbursement 8,287,500 8,287,500
Ending General Fund Reserves 31,521,164 28,478,787
7
March 31, 2024 Budget Appropriation Summary
Fiscal Year July 1, 2023 - June 30, 2024
FY 2024 FY 2024 FY 2024 Mar. 31
Estimated Revenues Adopted Amended Mar. 31 Percent
Budget Budget Actuals YTD
Property Taxes 50,606,500 50,606,500 50,374,567
Income Taxes 39,350,000 42,285,000 25,220,262
Return on Equity 26,800,000 26,800,000 12,486,715
State Revenues 22,424,475 23,174,475 14,458,068
Charges for Services 9,295,300 9,295,300 7,474,125
Fines& Forfeitures 1,505,200 1,505,200 945,216
Licenses & Permits 1,824,800 1,824,800 1,061,865
Interest& Rent 621,195 621,195 770,930
Other Revenue 412,000 412,000 2651191
Transfers from Other Funds 100,000 100,000 100,000
Total Revenues 152,939,470 157,624,470 113,156,939 71.8%
FY 2024 FY 2024 FY 2024 Mar. 31
Appropriations Adopted Amended Mar. 31 Percent
Budget Budget Actuals YTD
Council
Personnel 541,898 541,898 3921303
Operating 115,609 252,921 109,950
Total 657,507 794,819 502,253 63.2%
Internal Audit
Personnel 219,000 219,000 1571222
Operating - 12,514 6,892
Total 219,000 231,514 164,115 70.9%
Courts
Personnel 5,088,290 5,088,290 3,413,075
Operating 972,901 1,536,070 1,136,936
Total 6,061,191 6,624,360 4,550,010 68.7%
Mayor's Office
Personnel 1,309,579 1,309,579 9351850
Operating 117,846 273,438 182,741
Total 1,427,425 1,583,017 1,118,591 70.7%
Media Center
Personnel 622,556 622,556 4201488
Operating 3,900 82,438 61,133
Total 626,456 704,994 481,621 68.3%
Clerk's Office
Personnel 1,183,378 1,183,378 7421236
Operating 418,995 637,287 509,241
Total 1,602,373 1,820,665 1,251,477 68.7%
8
FY 2024 FY 2024 FY 2024 Mar. 31
Appropriations Adopted Amended Mar. 31 Percent
Budget Budget Actuals YTD
Neighborhood &Citizen Engagement
Personnel 1,018,426 1,168,426 5781039
Operating 473,243 387,981 184,330
Total 1,491,669 1,556,407 762,368 49.0%
Economic Development& Planning
Personnel 3,451,387 3,451,387 2,423,739
Operating 2,820,717 3,369,382 2,018,829
Total 6,272,104 6,820,769 4,442,568 65.1%
Finance/Operations
Personnel 1,770,206 1,770,206 1,215,038
Operating 468,404 554,720 424,308
Total 2,238,610 2,324,926 1,639,346 70.5%
Assessing
Personnel 1,707,829 1,707,829 9421255
Operating - 279,721 156,634
Total 1,707,829 1,987,550 1,098,889 55.3%
Treasury
Personnel 1,749,356 1,749,356 1,227,759
Operating 287,029 583,003 339,302
Total 2,036,385 2,332,359 1,567,061 67.2%
Human Resources
Personnel 1,968,618 1,968,618 1,305,699
Operating 266,170 1,130,947 604,588
Total 2,234,788 3,099,565 1,910,288 61.6%
Attorney's Office
Personnel 2,364,324 2,364,324 1,544,772
Operating - 275,851 178,166
Total 2,364,324 2,640,175 1,722,938 65.3%
Police
Personnel 45,876,734 45,756,734 33,195,347
Operating 8,709,861 8,829,861 5,542,361
Total 54,586,595 54,586,595 38,737,708 71.0%
Fire
Personnel 35,291,150 35,171,150 26,796,231
Operating 6,157,067 6,277,067 3,694,176
Total 41,448,217 41,448,217 30,490,407 73.6%
Public Service
Personnel 3,695,596 3,575,596 2,098,499
Operating 9,811,393 10,031,393 7,102,999
Total 13,506,989 13,606,989 9,201,498 67.6%
Human Relations&Community Service
Personnel 1,894,264 1,894,264 1,160,075
Operating 151,500 327,512 116,664
Total 2,045,764 2,221,776 1,276,739 57.5%
9
FY 2024 FY 2024 FY 2024 Mar. 31
Appropriations Adopted Amended Mar. 31 Percent
Budget Budget Actuals YTD
Parks &Recreation
Personnel 5,299,345 5,299,345 3,327,358
Operating 2,793,594 4,035,790 2,658,471
Total 8,092,939 9,335,135 5,985,829 64.1%
Human Services
Operating 2,084,932 3,505,776 1,845,720
Total 2,084,932 3,505,776 1,845,720 52.6%
City Supported Agencies/MRJEA
Operating 549,500 1,256,366 250,010
Total 549,500 1,256,366 250,010 19.9%
City Recognitions 10,000 10,000 3,656
Total 10,000 10,000 3,656 36.6%
Non-Departmental
Vacancy Factor (1,500,000) (1,500,000) -
Library Lease 136,500 136,500 117,637
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,742,433 101.6%
Total Expenditures 159,367,303 167,094,680 117,745,525 70.5%
10
Vacancy Factor Report
Quarter Ending March 31,2024
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
HRCS 1012500 CNTRTMGR CONTRACT MANAGER T243CTP 1.00 1/20/2024 12,313
HRCS 1012500 COMMINVT COMMISSION INVESTIGATOR T214NS 1.00 7/3/2023 15,267
CODE COMPLIANCE 1012610 CCOFICER CODE ENFORCEMENT WORKER T243CTP 1.00 11/25/2023 12,538
CODE COMPLIANCE 1012610 CCOFICER CODE ENFORCEMENT WORKER T243CTP 1.00 10/23/2023 12,538
CODE COMPLIANCE 1012610 LDHOUSIN LEAD HOUSING INSPECTOR T243SUPV 1.00 8/21/2022 18,555
CODE COMPLIANCE 1012610 CCOFICER CODE ENFORCEMENT WORKER T243CTP 1.00 9/2/2023 12,538
CODE COMPLIANCE 1012610 CCOFICER CODE ENFORCEMENT WORKER T243CTP 1.00 1/11/2024 10,995
CODE COMPLIANCE 1012610 CCOFICER CODE ENFORCEMENT WORKER T243CTP 1.00 1/1/2024 12,538
CODE COMPLIANCE 1012610 PKFLDSUP FIELD SUPERVISOR T243SUPV 1.00 3/6/2024 3,819
FINANCE/OPERATIONS 1012710 DPYFINDIR DEPUTY FINANCE DIRECTOR NON BARG SUPV 1.00 2/28/2023 NO BDGT IMPACT
ASSESSOR 1012720 ADMAST28 ADMIN ASSISTANT T243CTP 1.00 10/16/2023 10,875
ASSESSOR 1012720 COMINDAP COMM ERICAL/INDUSTRIALAPPRAISR T243CTP 1.00 6/15/2022 23,904
ASSESSOR 1012720 RESAPPLD RESIDENTIAL APPRAISER LEAD T243CTP 1.00 10/18/2019 18,672
ASSESSOR 1012720 RESAPPTR RESIDENTIAL APPRAISER APPRENTICE T243CTP 1.00 5/24/2019 15,322
ASSESSOR 1012720 RESIDAPP RESIDENTIAL APPRAISER T243CTP 1.00 10/5/2017 CONTRACT
TREASURY 1012730 CUSTSREP CUSTOMER SERVICE REP T243CTP 1.00 9/17/2022 8,222
TREASURY 1012730 ADMAST28 ADMINISTRATIVE ASSISTANT T243CTP 1.00 10/8/2022 14,602
TREASURY 1012730 TRESYINV TREASURERY INVESTIGATOR T243CTP 1.00 8/20/2022 17,786
HUMAN RESOURCES 1012800 SAFTYADM HEALTH&WELLNESS SPECIALIST T243CTP 0.25 7/1/2022 3,831
CITYATTORNEY 1012900 LGLADVSR LEGAL ADVISOR T214N5 1.00 7/1/2020 18,725
CITYATTORNEY 1012800 ASTATY36 ASSISTANT CITY ATTORNEY T214NS 1.00 11/11/2022 25,205
CITYATTORNEY 1012800 ASTATY36 ASSISTANT CITY ATTORNEY T214NS 1.00 12/1/2023 25,205
NEIGH CTZN ENG 1012320 FINCNCLR FINANCIAL COUNSELOR T243CTP 1.00 3/14/2024 2,810
PUBLIC SERVICE/BUILDINGS 1013140 CUSTOWKR CUSTODIAL WORKER300 UAW 1.00 12/3/2021 10,432
PUBLIC SERVICE/BUILDINGS 1013140 FACMTWKR SKILLED TRADES WORKER UAW 1.00 2/10/2024 6,676
PUBLIC SERVICE/BUILDINGS 1013140 FACMTWKR SKILLED TRADES WORKER UAW 1.00 1/17/2024 10,109
PUBLIC SERVICE/BUILDINGS 1013140 PROPTMGR FACILITIES AND PROPERTY SUPERINTENDENT T243SUPV 1.00 6/30/2023 19,489
PUBLIC SERVICE/BUILDINGS 1013140 PLUMBSUP BUILDING SERVICES SUPERVISOR T243SUPV 1.00 6/10/2018 20,616
PUBLIC SERVICE/BUILDINGS 1013140 ELECFACW ELECTRICAL FACILITY CTRL WKR UAW 1.00 11/2/2018 12,398
POLICE-ADMIN 1013201 ADMSPC31 ADMINISTRATIVE SPECIALIST31 T214NS 1.00 12/28/2011 CONTRACT
POLICE-DETENTION 1013224 SERGANT3 SERGEANTIII CCLPSUPV 1.00 03/14/24 3,982
POLICE-DETENTION 1013224 DETENOFF DETENTION OFFICER T243CTP 1.00 09/22/22 18,672
POLICE-DETENTION 1013224 DETENOFF DETENTION OFFICER T243CTP 1.00 01/19/24 14,650
POLICE-DETENTION 1013224 POLOFFCR 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 DETECT28 DETECTIVE IIB CCLP NS 1.00 8/26/2023 20,999
POLICE-INVESTIGATIONS 1013240 DETECT26 DETECTIVE IIB CCLP NS 1.00 8/14/2023 20,999
POLICE-INVESTIGATIONS 1013240 DETECT28 DETECTIVE IIB CCLP NS 1.00 7/21/2023 20,999
POLICE-INVESTIGATIONS 1013240 DETECT26 DETECTIVE IIB CCLP NS 1.00 10/13/2023 20,999
POLICE-INVESTIGATIONS 1013240 DETECT28 DETECTIVE IIB CCLP NS 1.00 10/13/2023 20,999
POLICE-INVESTIGATIONS/CSI 1013240 DTCTVCSI CSIINVESTIGATOR CCLP NS 1.00 09/24/22 13,745
POLICE-INVESTIGATIONS/C51 1013240 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 10/07/23 13,745
POLICE-INVESTIGATIONS/SOS 1013240 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 06/O1/23 20,999
POLICE-INVESTIGATIONS/SOS 1013240 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 02/14/23 20,999
POLICE-INVESTIGATIONS/SOS 1013240 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 06/16/22 20,999
POLICE-INVESTIGATIONS/C51 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-INVESTIGATIONS/C51 1013240 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 05/06/23 13,745
POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 03/25/24 1,057
POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 03/09/24 3,172
POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 02/20/24 6,132
POLICE-PATROL 1013251 CRMRESAN CRIME RESEARCH ANALYST T243CTP 1.00 05/20/22 CONTRACT
FIRE-LOGISTICS 1013510 SECRTY26 SECRETARY T243CTP 1.00 6/24/2023 9,442
FIRE-LOGISTICS 1013510 MATALSP3 MAINTENANCE ALARM SPECIALIST IAFF 1.00 7/1/2022 14,706
FIRE-PREVENTION 1013530 INSPECT4 INSPECTORIV IAFF 1.00 3/11/2023 22,122
FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 3/18/2024 OVERTIME
FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 3/9/2024 OVERTIME
FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 12/30/2023 OVERTIME
FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 12/30/2023 OVERTIME
FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 12/11/2023 OVERTIME
FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 12/2/2023 OVERTIME
FIRE-OPERATIONS 1013520 FIRFIGTR FIREFIGHTER IAFF 1.00 10/17/2023 OVERTIME
FIRE-TRAINING 1013540 SECRTY26 SECRETARY T243CTP 1.00 9/8/2023 10,364
PARKS/COMMUNITY CENTERS 1013811 PTCLRK23 PT CLERK23 T243CTP PT 0.50 3/16/2024 603
PARKS/COMMUNITY CENTERS 1013811 PTCLRK22 PT CLERK22 T243CTP PT 0.50 7/24/2023 3,743
3rd Quarter Vacancy factor: 64.25 788,864
2nd Quarter Vacancy factor: 57.25 726,292
1st Quarter Vacancy factor: 99.75 856,010
Total GF YTD Vacancy Factor 2,371,165.22
Total#of GF Positions 619
11
Vacancy Factor Report
Quarter Ending March 31,2024
Department Key PCN Position Description Bargaining Unit FTE Vacancy Vacancy Factor
Non-Vacancy Factor(non-General Fund)Vacancies
PARKS/CEMETARIES 5163840 ADMSPC27 ADMINISTRATIVE SPECIALIST T243CTP 1.00 2/19/2024 4,358
PUBLIC SERVICE/O&M 1013611 PUBWKSUP PUBLIC SERVICE SUPERVISOR T243SUP 1.00 2/5/2024 11,490
PUBLIC SERVICE/O&M 1013611 SNMATWKR MAINTENANCE WORKER UAW 1.00 9/19/2023 11,411
PUBLIC SERVICE/O&M 1013611 SNMATWKR MAINTENANCE WORKER UAW 1.00 6/18/2022 11,411
PUBLIC SERVICE/O&M 1013611 SNMATWKR MAINTENANCE WORKER UAW 1.00 3/31/2022 11,411
PUBLIC SERVICE/O&M 1013611 SNMATWKR MAINTENANCE WORKER UAW 1.00 1/16/2022 11,411
PUBLIC SERVICE/O&M 1013611 SNMATWKR MAINTENANCE WORKER UAW 1.00 12/2/2023 11,411
PUBLIC SERVICE/O&M 1013611 SNMATWKR MAINTENANCE WORKER UAW 1.00 3/26/2021 11,411
PUBLIC SERVICE/O&M 1013611 SWRTMWKS SEWER MAINTENANCE WORKER UAW 1.00 3/15/2023 13,406
PUBLIC SERVICE/O&M 1013611 FRSTWKRS ARBORIST500 UAW 1.00 2/22/2023 12,398
PUBLIC SERVICE/O&M 1013611 EQPOPWKS EQUIPMENT OPERATOR WORKER500 UAW 1.00 12/2/2023 12,398
PUBLIC SERVICE/O&M 1013611 SWRMTWK3 SEWER MAINTENANCE WORKER T243SUPV 1.00 1/31/2022 13,406
PUBLIC SERVICE/O&M 1013611 PUBWKSUP PUBLIC SERVICE SUPERVISOR T243SUP 1.00 12/4/2021 18,672
PUBLIC SERVICE/O&M 1013611 SOLWASUP SOLID WASTE SUPERVISOR T243SUP 1.00 8/15/2020 16,914
ED&P/BUILDING SAFETY 2492610 BLDINSUP BUILDING INSPECTOR SUPERVISOR T214SUPV 1.00 12/23/2023 21,655
ED&P/BUILDING SAFETY 2492610 PLNREVSU PLANT REVIEW SUPERVISOR T214SUPV 1.00 1/8/2022 20,616
ED&P/BUILDING SAFETY 2492610 MECINSPC MECHANICAL INSPECTOR T243CTP 1.00 6/30/2023 18,672
ED&P/BUILDING SAFETY 2492610 BLDINSPC BUILDING INSPECTOR T243CTP 1.00 3/26/2024 1,041
ED&P/BUILDING SAFETY 2492610 SECRTY26 SECRETARY 26 T243CTP 1.00 3/2/2024 5,745
ED&P/BUILDING SAFETY 2492610 BLDINSPC BUILDING INSPECTOR T243CTP 1.00 2/17/2024 8,618
ED&P/BUILDING SAFETY 2492610 ELCINSUP ELECTRICAL INSPECTOR SUPERVISOR T214SUPV 1.00 2/9/2024 11,418
ED&P/BUILDING SAFETY 2492610 ELCINSPC ELECTRICAL INSPECTOR T243CTP 1.00 1/22/2024 13,011
ED&P/BUILDING SAFETY 2492610 PEMTEFOF PERMITS ENFORCEMENT OFFICER T243CTP 1.00 1/1/2024 18,672
ED&P/PARKING 5853641 ACCTGSPT ACCOUNTING SPECIALIST T243CTP 1.00 2/1/2024 7,027
ED&P/PARKING 5853641 MANTWKR2 MAINTENANCE WORKER 200 UAW 1.00 4/19/2023 12,398
ED&P/PARKING 5853641 PKGRVCOL PARKING REVENUE AMBASSADOR UAW 1.00 3/27/2023 9,633
PUBLIC SERVICE/WWTP 5903670 ASPLSUPT ASSIST PLANT SUPERINTENDENT NBSUPV 1.00 7/31/2020 22,207
PUBLIC SERVICE/WWTP 5903670 LABSUP-TBD LAB SUPERVISOR T243SUP 1.00 7/1/2017 18,672
PUBLICSERVICE/WWTP 5903670 INDSRSUP INDUSTRIAL SURVELIANCE SUPERVISOR T243CTP 1.00 7/1/2015 18,672
PUBLIC SERVICE/WWTP 5903670 ELECTECH ELECTRICAL TECHNICIAN T243CTP 1.00 10/5/2006 16,111
PUBLICSERVICE/WWTP 5903670 WWMATWK6 WASTE WATER PLANT LABORER UAW 1.00 7/12/2019 12,398
PUBLIC SERVICE/WWTP 5903670 WWSYSANL WASTEWATER SYSTEMS ANALYST T243CTP 1.00 10/23/2015 16,914
PUBLIC SERVICE/WWTP 5903670 UTLELWKR UTILITY ELECTRICAL WORKER UAW 1.00 10/1/2022 13,406
PUBLIC SERVICE/WWTP 5903670 WWMATWK6 WASTEWATER MAINTENANCE WKR 400 UAW 1.00 12/30/2023 11,411
PUBLICSERVICE/WWTP 5903670 WWMATWK7 WASTEWATER MAINTENANCE WKR 400 UAW 1.00 11/4/2023 11,411
PUBLIC SERVICE/WWTP 5903670 LABTECHN LABORATORY TECHNICIAN T243CTP 1.00 6/30/2023 10,364
PUBLICSERVICE/WWTP 5903670 INSTRTEC INSTRUMENTATION TECHNICIAN T243CTP 1.00 3/2/2024 3,189
PUBLIC SERVICE/WWTP 5903670 STORKPR4 STOREKEEPER/PARTS WORKER UAW 1.00 1/21/2024 9,537
PUBLICSERVICE/WWTP 5903670 WWPNTOP6 WASTEWATER MAINTENANCE WKR 600 UAW 1.00 5/27/2020 13,406
PUBLIC SERVICE/FLEET 6433623 RADIOTEC RADIO INST.TECHNICIAN T243CTP 1.00 7/14/2023 10,364
PUBLIC SERVICE/FLEET 6433623 ATGARSUP ASSIST SHIFT GARAGE SUPERVISOR T243SUP 1.00 7/1/2017 15,322
PUBLIC SERVICE/FLEET 6433623 ATGARSUP ASSIST SHIFT GARAGE SUPERVISOR T243SUP 1.00 7/12/2019 15,322
PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 3/29/2019 13,406
PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 5/13/2019 13,406
PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 8/17/2019 13,406
PUBLIC SERVICE/FLEET 6433623 SRVCSPEC SERVICE SPECIALIST T243CTP 1.00 9/20/2019 12,083
PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 6/4/2022 13,406
PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 7/21/2021 13,406
PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 12/16/2023 13,406
PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 10/28/2023 13,406
PUBLIC SERVICE/ENGINEERING 6453603 ADMSPC30 ADMINISTRATIVE SPECIALIST T243CTP 1.00 12/1/2023 10,875
PUBLIC SERVICE/ENGINEERING 6453603 ENGINR38 ENGINEER 38 T214NS 1.00 1/26/2023 23,984
PUBLIC SERVICE/ENGINEERING 6453603 ENGINR38 ENGINEER 38 T214NS 1.00 6/6/2019 23,984
PUBLIC SERVICE/ENGINEERING 6453603 TRANSENG TRANSPORTATION ENGINEER NBSUPV 1.00 1/1/2020 28,460
HUMAN RESOURCES 1012800 SAFTYADM HEALTH&WELLNESS SPECIALIST T243CTP 0.75 7/1/2022 11,492
DISTRICT COURT 7602201 DPCLERK2 DEPUTY CLERK 2 DCT243 1.00 10/27/2023 9,970
DISTRICTCOURT 7602201 DPCLERK2 DEPUTY CLERK 2 DCT243 1.00 9/11/2023 9,970
3rd Quarter Vacancy factor: 56.75 763,380
2nd Quarter Vacancy factor: 56.25 712,779
1st Quarter Vacancy factor: 59.25 761,193
Total Non-GF YTD Vacancy Factor 2,237,352.30
Total#of Non-GF Positions 330
12