Loading...
HomeMy WebLinkAbout2024 - FY24 Q2 Quarterly Report General Fund Status report General Fund Status Report — FY 2024 2nd 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). The $515,000 use of fund balance comes from approved budget amendments allocating money to Council carryforwards and storm damage repairs. The proposed budget amendment, if passed on February 121", will reduce the fund balance usage to $55,000. As of 6/30/2023, the General Fund balance is $29.66M, 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 75.0% 70.0% 65.0% 60.0% 55.0% 50.0% 45.0% 40.0% 35.0% 30.0% 25.0% 20.0% 15.0% 10.0% 5.0% 0.0% Income Return on State Charges for Fines and Licenses& Interest& Other Taxes Equity Revenues Services Forfeitures Permits Rents Revenues 1 General Fund revenue collected through the second quarter of fiscal year 2023-2024 were almost $92.4M, 59% of the amended budget. • Property Taxes (32.3% 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 second quarter, collections were roughly $50.9M. • Income Tax (27% of GF revenue budget) collections were $13.1M (31.1% of its budgeted $42.3M). • 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. Although the second payment was received in January, it is considered the Q2 payment. • State Revenue (14.8% of GF revenue budget) are estimated to be $23.2M in revenue. Quarter 2 YTD is higher than the three-year average. • Charges for Services (5.9% of GF revenue budget) are trending slightly higher than the three-year average for the 2nd Quarter. • 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 33% 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 $430,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 Information Fleet/ Debt Service Public Service & Culture Technology... 1a Equipment Engineering � Capital/Fun 4% 4% 1% d Transfers City 311 Service 5% 0% Retirement/Fixed Community Fringes Development 30% 6% Public Service General Government 8% Police Department 18% Fire Departme... FY24 Expenditure YTD 60.0% 50.0% 40.0% 30.0% 20.0% 10.0% 0.0% — 'U -�� c0.> Y u °� �—' c O v u c c LOi o6 p L�.i v 3 c E v N H ar v '> O a 0 E v °o E o Q E E N o Q U �- �n = m Ln -c O - �' a^ ns t6 c6 u O- i O O i+ i Y O LL O_ T Ou O_ Q v a1 7 aJ > N N a1 c al al c Ln �., U 7 L c c !_ �. c w O U GA U i c o6 O O U T 'v u >_ � as w 2 U Y ++ Z N 7 a+ LL 1= L Y � O U `L r iU General Fund expenditures are trending below the 3-year target by about 3%. 3 Vacancy Factor There is a total of about 57 vacancies in the General Fund (out of 619 positions) and around 56 in other funds (out of 330). This totals over$1.4M in estimated vacancy savings. The Lansing Fire Department went from 34 vacant positions in Q1 to 10 in Q2. The Lansing Police Department went from 32 vacant positions in Q1 to 20 in Q2. Overall, the GF vacancy rate is 9.25%, which is down almost 7% compared to last quarter. The Non-GF vacancy rate is 17%, down 1% compared to last quarter. 4 December 31, 2023 Revenue Summary Fiscal Year July 1, 2023 -June 30, 2024 FY 2024 FY 2024 FY 2023 Dec. 31 3 Year General Fund Revenues Adopted Amended Dec. 31 Percent Dec. 31 Budget Budget Actuals YTD Avg. Property Taxes Non-Dedicated 37,849,000 37,849,000 38,114,006 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,871,506 100.5% 100.9% Income Taxes City Income Tax 39,350,000 42,285,000 13,140,503 Total 39,350,000 42,285,000 13,140,503 31.1% 33.3% 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% 42.4% State Revenues Revenue Sharing 17,744,475 17,976,375 6,491,548 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 - Liquor License Fee 80,000 80,000 80,363 Total 22,424,475 23,174,475 10,024,346 43.3% 34.3% Charges for Services Public Safety 4,404,350 4,404,350 1,175,061 Reimbursements 2,442,500 2,442,500 1,163,236 Code Compliance 1,851,000 1,851,000 1,280,914 Recreation Fees 468,750 468,750 313,845 Appeals&Petitions 89,700 89,700 25,580 Work for Others 33,200 33,200 50,777 Central Stores 3,500 3,500 410 Subscriptions and Information 2,300 2,300 780 Total 9,295,300 9,295,300 4,010,604 43.1% 41.6% Fines and Forfeitures Fines and Forfeitures 1,505,200 1,505,200 562,372 Total 1,505,200 1,505,200 562,372 37.4% 44.7% Licenses&Permits Cable Franchise Fees 1,000,000 1,000,000 221,183 Marihuana Licenses 700,000 700,000 315,000 Business Licenses 71,450 71,450 42,777 Non-Business Licenses 35,600 35,600 16,135 Building Licenses & Permits 17,750 17,750 6,700 Total 1,824,800 1,824,800 601,795 33.0% 32.9% Interest&Rents Interest Income 621,195 621,195 430,700 Total 621,195 621,195 430,700 69.3% 75.0% Other Revenues Miscellaneous 173,000 173,000 101,246 Sale of Fixed Assets 120,000 120,000 29 Donations &Contributions 119,000 119,000 61,924 Total 412,000 412,000 163,199 39.6% 34.3% Total General Fund Operating Revenue 152,839,470 156,524,470 92,291,738 59.0% 56.6% Transfers from Other Funds 100,000 100,000 100,000 Total 152,939,470 156,624,470 92,391,738 59.0% 56.7% 5 December 31, 2023 Departmental Summary Fiscal Year July 1, 2023 -June 30, 2024 FY 2024 FY 2024 FY 2024 Dec. 31 3 Year General Fund Appropriations Adopted Amended Dec. 31 Percent Dec. 31 Budget Budget Actuals YTD Taraet Total General Fund Reserves 29,661,497 29,661,497 29,661,497 Revenues(detail on previous page) 152,939,470 156,624,470 92,391,738 59.0% 56.7% Departmental Expenditures: Council 657,507 794,819 318,413 40.1% 48.9% Internal Audit 219,000 231,514 111,107 48.0% 48.4% Mayor's Office 1,427,425 1,583,017 868,075 54.8% 48.6% Office of Community Media 626,456 704,994 318,673 45.2% 48.7% District Court 5,723,828 6,286,997 2,760,832 43.9% 48.9% Circuit Court Building Rental 337,363 337,363 1,701 0.5% 1.1% City Clerk's Office 1,602,373 1,780,665 711,641 40.0% 48.8% Neighborhood &Citizen Engagement 1,491,669 1,556,407 529,248 34.0% 49.1% Economic Development&Planning 6,272,104 6,820,769 3,420,659 50.2% 48.7% Finance Department 2,238,610 2,324,926 1,183,990 50.9% 48.8% City Assessor 1,707,829 1,987,550 711,677 35.8% 48.7% Treasury/Income Tax 2,036,385 2,332,359 993,401 42.6% 48.9% Human Resources Department 2,234,788 3,099,565 1,146,486 37.0% 49.1% City Attorney's Office 2,364,324 2,640,175 1,140,849 43.2% 48.6% Police Department 54,586,595 54,586,595 24,611,468 45.1% 47.2% Fire Department 41,448,217 41,448,217 18,945,526 45.7% 47.2% Public Service 13,506,989 13,606,989 3,011,626 22.1% 40.4% Human Relations&Community Services 2,045,764 2,221,776 836,150 37.6% 48.7% Parks&Recreation Department 8,092,939 9,335,135 3,449,460 37.0% 33.0% Human Service Agency Support 2,084,932 2,584,932 1,008,229 39.0% 50.0% Non-Departmental Expenditures: Library Building Rental 136,500 136,500 68,447 50.1% 50.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 213,077 38.8% 1.4% 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% 50.0% Vacancy Factor (1,500,000) (1,500,000) - City Recognitions 10,000 10,000 Expenditures 159,367,303 165,426,970 74,985,532 45.3% 48.7% Net Impact on Fund Balance (6,427 833) (8,802,500) ARPA Reimbursement 8,287,500 8,287,500 Ending General Fund Reserves 31,521,164 29,146,497 6 December 31, 2023 Budget Appropriation Summary Fiscal Year July 1, 2023 -June 30, 2024 FY 2024 FY 2024 FY 2024 Dec. 31 3 Year Estimated Revenues Adopted Amended Dec. 31 Percent Dec. 31 Budget Budget Actuals YTD Avg. Property Taxes 50,606,500 50,606,500 50,871,506 Income Taxes 39,350,000 42,285,000 13,140,503 Return on Equity 26,800,000 26,800,000 12,486,715 State Revenues 22,424,475 23,174,475 10,024,346 Charges for Services 9,295,300 9,295,300 4,010,604 Fines&Forfeitures 1,505,200 1,505,200 562,372 Licenses&Permits 1,824,800 1,824,800 601,795 Interest&Rent 621,195 621,195 430,700 Other Revenue 412,000 412,000 163,199 Transfers from Other Funds 100,000 100,000 100,000 Total Revenues 152,939,470 156,624,470 92,391,738 59.0% 56.7% Dec. FY 2024 FY 2024 FY 2024 Dec. 31 31 Appropriations Adopted Amended Dec. 31 Percent Target Budget Budget Actuals YTD Exp. Council Personnel 541,898 541,898 265,826 Operating 115,609 252,921 52,587 Total 657,507 794,819 318,413 40.1% 48.9% Internal Audit Personnel 219,000 219,000 106,238 Operating - 12,514 4,869 Total 219,000 231,514 111,107 48.0% 48.4% Courts Personnel 5,088,290 5,088,290 2,319,940 Operating 972,901 1,536,070 442,593 Total 6,061,191 6,624,360 2,762,533 41.7% 46.5% Mayor's Office Personnel 1,309,579 1,309,579 761,978 Operating 117,846 273,438 106,097 Total 1,427,425 1,583,017 868,075 54.8% 48.6% Media Center Personnel 622,556 622,556 283,941 Operating 3,900 82,438 34,732 Total 626,456 704,994 318,673 45.2% 48.7% Clerk's Office Personnel 1,183,378 1,183,378 526,426 Operating 418,995 597,287 185,215 Total 1,602,373 1,780,665 711,641 40.0% 48.8% 7 Dec. FY 2024 FY 2024 FY 2024 Dec. 31 31 Appropriations Adopted Amended Dec. 31 Percent Target Budget Budget Actuals YTD Exp. Neighborhood &Citizen Engagement Personnel 1,018,426 1,018,426 391,888 Operating 473,243 537,981 137,361 Total 1,491,669 1,556,407 529,248 34.0% 49.1% Economic Development&Planning Personnel 3,451,387 3,451,387 1,626,015 Operating 2,820,717 3,369,382 1,794,643 Total 6,272,104 6,820,769 3,420,659 50.2% 48.7% Finance/Operations Personnel 1,770,206 1,770,206 897,336 Operating 468,404 554,720 286,654 Total 2,238,610 2,324,926 1,183,990 50.9% 48.8% Assessing Personnel 1,707,829 1,707,829 639,945 Operating - 279,721 71,732 Total 1,707,829 1,987,550 711,677 35.8% 48.7% Treasury Personnel 1,749,356 1,749,356 817,917 Operating 287,029 583,003 175,484 Total 2,036,385 2,332,359 993,401 42.6% 48.9% Human Resources Personnel 1,968,618 1,968,618 790,427 Operating 266,170 1,130,947 356,059 Total 2,234,788 3,099,565 1,146,486 37.0% 49.1% Attorney's Office Personnel 2,364,324 2,364,324 1,044,502 Operating - 275,851 96,347 Total 2,364,324 2,640,175 1,140,849 43.2% 48.6% Police Personnel 45,876,734 45,876,734 21,932,688 Operating 8,709,861 8,709,861 2,678,780 Total 54,586,595 54,586,595 24,611,468 45.1% 47.2% Fire Personnel 35,291,150 35,291,150 17,606,429 Operating 6,157,067 6,157,067 1,339,097 Total 41,448,217 41,448,217 18,945,526 45.7% 47.2% Public Service Personnel 3,695,596 3,695,596 1,426,632 Operating 9,811,393 9,911,393 1,584,994 Total 13,506,989 13,606,989 3,011,626 22.1% 40.4% Human Relations&Community Service Personnel 1,894,264 1,894,264 779,153 Operating 151,500 327,512 56,998 Total 2,045,764 2,221,776 836,150 37.6% 48.7% 8 Dec. FY 2024 FY 2024 FY 2024 Dec. 31 31 Appropriations Adopted Amended Dec. 31 Percent Target Budget Budget Actuals YTD Exp. Parks&Recreation Personnel 5,299,345 5,299,345 2,305,552 Operating 2,793,594 4,035,790 1,143,908 Total 8,092,939 9,335,135 3,449,460 37.0% 33.0% Human Services Operating 2,084,932 2,584,932 1,008,229 Total 2,084,932 2,584,932 1,008,229 39.0% 50.0% City Supported Agencies/MRJEA Operating 549,500 549,500 213,077 Total 549,500 549,500 213,077 38.8% 1.4% 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 68,447 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,693,243 101.1% 100.5% Total Expenditures 159,367,303 165,426,970 74,985,532 45.3% 48.7% 9 Vacancy Factor Report Quarter Ending December 31,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 HRCS 1012500 DIEOPSPC DIVERSITY,INCLUSION&EO SPECIALIST T243CTP 1.00 7/14/2023 14,779 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 CODE COMPLIANCE 1012610 CCOFICER CODE ENFORCEMENT WORKER T243CTP 1.00 11/25/2023 4,682 CODE COMPLIANCE 1012610 CCOFICER CODE ENFORCEMENT WORKER T243CTP 1.00 10/23/2023 9,364 CODE COMPLIANCE 1012610 LDHOUSIN LEAD HOUSING INSPECTOR T243SUPV 1.00 8/21/2022 18,014 CODE COMPLIANCE 1012610 CCOFICER CODE ENFORCEMENT WORKER T243CTP 1.00 9/2/2023 12,173 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 ASSESSOR 1012720 ADMAST28 ADMIN ASSISTANT T243CTP 1.00 10/16/2023 8,934 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 HUMAN RESOURCES 1012800 PAYRTECH PAYROLL TECHNICIAN T243CTP 1.00 10/16/2023 9,824 HUMAN RESOURCES 1012800 SAFTYADM HEALTH&WELLNESS SPECIALIST T243CTP 0.25 7/1/2022 3,719 CITY ATTORNEY 1012900 LGLADVSR LEGAL ADVISOR T214NS 1.00 7/1/2020 18,180 CITY ATTORNEY 1012800 ASTATY36 ASSISTANT CITY ATTORNEY T214NS 1.00 11/11/2022 24,470 CITY ATTORNEY 1012800 ASTATY36 ASSISTANT CITY ATTORNEY T214 NS 1.00 12/1/2023 7,906 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 Facilities&PropertiesSuperintendent T243SUPV 1.00 6/30/2023 18,921 PUBLIC SERVICE/BUILDINGS 1013140 PLUMBSUP BuildingServicesSupv T243SUPV 1.00 6/10/2018 20,016 POLICE-ADMIN 1013201 ADMSPC31 ADMINISTRATIVE SPECIALIST 31 T214 NS 1.00 12/28/2011 CONTRACT POLICE-DETENTION 1013224 SERGANT3 SERGEANTIII CCLPSUPV 1.00 10/15/23 18,251 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 DETECT26 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 DETECT26 DETECTIVE IIB CCLP NS 1.00 7/21/2023 20,999 POLICE-INVESTIGATIONS 1013240 DETECT26 DETECTIVE IIB CCLP NS 1.00 10/13/2023 18,092 POLICE-INVESTIGATIONS 1013240 DETECT213 DETECTIVE IIB CCLP NS 1.00 10/13/2023 18,092 POLICE-INVESTIGATIONS/CSI 1013240 DTCTVCSI CSIINVESTIGATOR CCLP NS 1.00 09/24/22 13,745 POLICE-INVESTIGATIONS/CSI 1013240 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 10/07/23 12,688 POLICE-INVESTIGATIONS/SOS 1013240 POLOFFDT POLICE OFFICER DETECTIVE PAY CCLP NS 1.00 06/01/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-INVESTIGATIONS/CSI 1013240 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 05/06/23 13,745 POLICE-PATROL 1013251 POLSSCLWR SOCIAL WORKER T243CTP 1.00 10/25/23 10,396 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 3/11/2023 22,122 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 FIRE FIGHTER IAFF 1.00 12/2/2023 OVERTIME FIRE-OPERATIONS 1013520 FIRFIGTR FIRE FIGHTER IAFF 1.00 10/17/2023 OVERTIME FIRE-TRAINING 1013540 SECRTY26 SECRETARY T243CTP 1.00 9/8/2023 10,062 PARKS/BUSINESS&MGMT 1013810 PTCLRK23 CLERK 23 T243CTP 0.50 11/11/2023 2,050 PARKS/COMMUNITY CENTERS 1013811 PTCLRK22 PT CLERK22 T243CTP PT 0.50 7/24/2023 3,634 2nd Quarter Vacancy factor: 57.25 726,292 1st Quarter Vacancy factor: 99.75 856,010 Total GF YTD Vacancy Factor 1 1,582,301.69 Total#of GF Positions 619 10 Vacancy Factor Report Quarter Ending December 31,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 DRIVRWKR DRIVER WORKER 300 UAW 1.00 09/19/2023 11,079 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 12/02/2023 3,409 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 SWRTMWK5 SEWER MAINTENANCE WORKER UAW 1.00 11/21/2023 5,807 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 12,036 PUBLIC SERVICE/O&M 1013611 EQPOPWK5 EQUIPMENT OPERATOR WORKER 500 UAW 1.00 12/02/2023 3,704 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 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 REHABCSP REHAB CONSTRUCTION SPCLST T243CTP 1.00 8/19/2023 12,173 ED&P/BUILDING SAFETY 2492610 BLDINSUP BUILDING INSPECTOR SUPERVISOR T214SUPV 1.00 12/23/2023 1,540 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 PARKING REVENUE AMBASSADOR UAW 1.00 3/27/2023 9,352 PUBLIC SERVICE/WWTP 5903670 ASPLSUPT ASSIST PLANT SUPERINTENDENT NB SUPV 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 400 UAW 1.00 12/30/2023 - PUBLIC SERVICE/WWTP 5903671 WWMATWK7 WASTEWATER MAINTENANCE WKR 401 UAW 1.00 11/4/2023 6,818 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 12,036 PUBLIC SERVICE/WWTP 5903670 WWPNTOP6 WASTEWATER MAINTENANCE WKR 600 UAW 1.00 5/27/2020 13,016 PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 9/15/2023 13,016 PUBLIC SERVICE/FLEET 6433623 RADIOTEC RADIO INST.TECHNICIAN T243CTP 1.00 7/14/2023 10,062 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 MECHANIC MECHANIC UAW 1.00 12/16/2023 2,002 PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 10/28/2023 9,011 PUBLIC SERVICE/FLEET 6433623 VEHWKR04 VEHICLE MAINTENANCE WORKER 400 UAW 1.00 11/1/2020 11,079 PUBLIC SERVICE/ENGINEERING 6453603 ADMSPC30 ADMINISTRATIVE SPECIALIST T243CTP 1.00 12/1/2023 3,411 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/2023 7,821 DISTRICT COURT 7602201 DPCLERK2 DEPUTY CLERK 2 DCT243 1.00 10/27/2023 7,055 DISTRICT COURT 7602201 DPCLERK2 DEPUTY CLERK 2 DCT243 1.00 9/11/2023 9,970 2nd Quarter Vacancy factor: 56.25 712,779 1st Quarter Vacancy factor: 59.25 761,193 Total Non-GF YTD Vacancy Factor 1,473,972.14 Total#of Non-GF Positions F 330 11