Loading...
HomeMy WebLinkAbout2024- Budget and Vacancy Report FY2025 Q1 General Fund Status Report — FY 2025 1st Quarter General Fund Summary For FY25, the City adopted a budget of$165.2 million in total revenue including transfers and $165.4 million in total expenditures. The difference will be made by use of fund balance ($175,000). As of 6/30/2023, the General Fund balance is $29.66M, with $2O.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. The general fund budget report is presented in several formats for informational value as follows. After a separate revenue summary, the City's general fund is presented as formally adopted in appropriation detail showing personnel vs. operating expenditures. Revenue Summary Revenue YTD 30.0% 25.0% 20.0% 15.0% — 10.0% — 5.0% , , ■ 0.0% e 5a tke e5��c 419 C General Fund revenue collected through the first quarter of fiscal year 2024-2025 were over $63M, 38.1% of the budget. 1 • Property Taxes (32.6% of GF revenue budget) are largely collected at the beginning of the fiscal year. They were initially estimated to be $53.9M. At the end of the first quarter, tax billings were roughly $54.1M. • Income Tax (25.8%of GF revenue budget) collections were $6.7M (15.6% of its budgeted $42.7M). Accruals are being processed in the ledger but are manually estimated and incorporated into the report. • Licenses and Permits (1.1% of GF revenue budget) are estimated to be $1.85M. The City has received 5.6% of the budgeted amount. • State Grants (15.6% of GF revenue budget) are budgeted to be $25.8M in revenue. Quarter 1 YTD is trending with the three-year average. The first payment for revenue sharing is to be received in October (no change from previous years) and we are watching for whether the State will formally create a revenue sharing trust fund to provide additional stability going forward, with legislative activity presumed to occur on this topic after the upcoming election. • Return on Equity (ROE) (16.8%of GF revenue budget) represents payment to the City from the Board of Water & Light. The contract is 6% of budget and we will receive the full payment budgeted by BWL. We received the first payment of$7,185,378.76 in October. • Charges for Services (6.2% of GF revenue budget) are trending lower than the three- year average for the first quarter. • Fines and Forfeitures (1% of GF revenue budget) are budgeted to be about $1.6M. Quarter-to-date, they are trending above expectations. • Interest and Rents (0.4%of GF revenue budget) are budgeted to be $660,000 in FY25. The quarter-to-date amount is almost$38,000. • Other Revenues (0.2%of GF revenue budget) are a very small percentage of the General Fund budget and below the three-year average due to the city creating a separate fund for the opioid settlement money. 2 Expenditure Summary Expenditure YTD 50.0% 45.0% 40.0% 35.0% 30.0% 25.0% 20.0% 15.0% 10.0% I I I I 0.0/o 0e met `oe °J Ja L° G \Q, eyo �y �a �o ea yet a �o Q e r°ooe�e rho-Nc J�Q C�e`6o oco 5 General Fund expenditures are slightly above the 3-year average by 0.7%. Human Resources • Expenditures are higher than prior year averages due to the department catching up with internal vacancies. City Supported Agencies • Higher expenditures are due to timing of individual initiatives including the racial justice equity alliance and the charter commission. 3 Vacancy Factor There are a total of 39 vacancies in the General Fund and 69 in other funds. This totals over $1.65M in estimated vacancy savings in the first quarter. Total vacancies are down by 51 compared to FY24 Q1. 15 vacant police officer positions were adopted as part of the Public Safety Fund, contingent upon Michigan Senate on HB 4605 &4606 to formally approve this funding. These vacancies are not counted towards the vacancy factor as funding is reliant on these bills. Positions that were filled after 9/30/2024 include the Commercial/Industrial Appraiser, arborist, two maintenance workers, two premise officers, and a WWTP Laboratory Supervisor. 4 General • Revenues 1 July 1 , 124 - September 31 2024 FY 2025 3 Year 01 Adopted FY 2025 FY25 01 Percent Percent Budget 01 YTD YTD Average Property Taxes Non-Dedicated 40,375,000 40,574,184 Dedicated - Police 4,065,000 4,065,000 Dedicated - Fire 4,065,000 4,065,000 Dedicated - Roads 2,710,000 2,710,000 Dedicated - Parks 2,710,000 2,710,000 Total 53,925,000 54,124,184 100.4% 106.6% Income Taxes City Income Tax 42,750,000 6,689,098 Total 42,750,000 6,689,098 15.6% 16.5% Licenses & Permits Business Licenses 101,880 19,867 Cable Franchise Fees 900,000 - Medical Marijuana Licenses 800,000 75,000 Non-Business Licenses 25,120 5,461 Buildings Licenses & Permits 23,000 2,547 Total 1,850,000 102,875 5.6% 10.1% State Grants Public Safety 2,500,000 - Other State Grants 1,475,000 49,304 Reimbursements 1,800,000 - Revenue Sharing 19,075,000 - Capital City Allocation 1,000,000 - Total 25,850,000 49,304 0.2% 0.3% Return on Equity Board of Water and Light 27,500,000 - Sewage Disposal System 300,000 - Total 27,800,000 - 0.0% 0.0% Charges for Services Fees 89,700 14,841 Services Rendered 1,800,700 603,971 Building Inspection Fees 2,125,000 586,251 Services To Others 54,400 44,280 Central Stores/Notary 2,000 40 Public Safety Services 163,800 37,742 Ambulance Transport Fees 5,450,000 71,712 Sales 2,200 40 Use & Admission Fees 617,200 213,190 Total 10,305,000 1,572,067 15.3% 22.1% Fines & Forfeitures Fines & Forfeitures 1,576,000 444,676 Total 1,576,000 444,676 28.2% 20.7% Interest & Rent Interest Income 445,000 17,207 Rental Income 215,000 20,680 Total 660,000 37,888 5.7% 10.3 Other Revenue Donations & Contributions 131,500 8,808 Miscellaneous 157,500 5,748 Sale of Capital Assets 120,000 11 Total 409,000 14,567 3.6% 16.8% Interfund Transfers In Interfund Transfers In 100,000 - Tota l 100,000 - 0.0% 0.0 Use of Fund Balance Fund Balance 175,000 - Total 175,000 - 0.0% 0.0% Total General Fund Revenues 165,400,000 63,034,659 38.1% 43.1 GeneraL Fund Expenditures FY2025 July 1, 124 - September 31 2024 FY25 01 3 Year FY2025 Adopted FY2025 Amended FY 2025 Percent 01 Percent Appropriations Budget Budget 01 YTD YTD Averaae Council Personnel 541,858.00 541,858.00 114,763 Operating 193,843.00 193,843.00 24,054 Total 735,701.00 735,701.00 138,817 18.9% 18.3% Internal Auditor Personnel 195,192.00 195,192.00 15,566 Operating 8,159.00 8,159.00 1,750 Total 203,351.00 203,351.00 17,316 8.5% 16.5% Courts Personnel 4,823,927.00 4,823,927.00 1,012,090 Operating 1,494,273.00 1,494,273.00 189,049 Total 6,318,200.00 6,318,200.00 1,201,139 19.0% 20.2% Mayor's Office Personnel 1,034,509.00 1,034,509.00 201,546 Operating 282,089.00 282,089.00 41,568 Total 1,316,598.00 1,316,598.00 243,113.27 18.5% 20.0% Media Center Personnel 651,522.00 651,522.00 127,263 Operating 76,009.00 76,009.00 20,467 Total 727,531.00 727,531.00 147,730 20.3% 19.5% Clerk's Office Personnel 1,152,251.00 1,152,251.00 315,731 Operating 801,810.00 801,810.00 142,171 Total 1,954,061.00 1,954,061.00 457,903 23.4% 22.2% Neighborhood &Citizen Engagement Personnel 1,094,223.00 521,226.00 119,991 Operating 608,913.00 413,178.00 22,859 Total 1,703,136.00 934,404.00 142,850 15.3% 17.4% Economic Development&Planning Personnel 3,883,414.00 4,089,058.00 849,892 Operating 2,760,027.00 3,323,115.00 241,181 Total 6,643,441.00 7,412,173.00 1,091,073 14.7% 32.5% Finance Personnel 1,578,106.00 1,578,106.00 361,438 Operating 532,454.00 532,454.00 71,528 Total 2,110,560.00 2,110,560.00 432,966 20.5% 19.5% Assessing Personnel 1,521,803.00 1,521,803.00 266,426 Operating 233,461.00 233,461.00 33,560 Total 1,755,264.00 1,755,264.00 299,986 17.1% 16.0% Treasury Personnel 1,997,312.00 1,997,312.00 481,052 Operating 900,488.00 900,488.00 175,246 Total 2,897,800.00 2,897,800.00 656,297 22.6% 20.4% Human Resources Personnel 1,847,163.00 1,847,163.00 409,857 Operating 679,126.00 679,126.00 161,414 Total 2,526,289.00 2,526,289.00 571,271 22.6% 15.3% Attorney's Office Personnel 2,407,024.00 2,407,024.00 480,027 Operating 300,998.00 300,998.00 57,834 Total 2,708,022.00 2,708,022.00 537,861 19.9% 19.2% Police Personnel 47,833,586.00 47,833,586.00 11,291,760 Operating 9,284,341.00 9,284,341.00 1,273,014 Total 57,117,927.00 57,117,927.00 12,564,774 22.0% 21.1% Fire Personnel 37,119,450.00 37,119,450.00 9,136,885 Operating 6,098,360.00 6,098,360.00 731,598 Total 43,217,810.00 43,217,810.00 9,868,483 22.8% 21.9% Public Service Personnel 3,182,612.00 3,182,612.00 617,610 Operating 9,826,092.00 9,826,092.00 1,262,487 Total 13,008,704.00 13,008,704.00 1,880,097 14.5% 21.3% Human Relations&Community Service Personnel 1,832,040.00 1,832,040.00 367,653 Operating 248,553.00 248,553.00 40,191 Total 2,080,593.00 2,080,593.00 407,844 19.6% 17.7% Parks&Recreation Personnel 5,675,739.00 5,675,739.00 1,237,065 Operating 3,428,336.00 3,428,336.00 572,129 Total 9,104,075.00 9,104,075.00 1,809,194 19.9% 16.5% Human Services Operating 2,235,000.00 2,235,000.00 38,507 Total 2,235,000.00 2,235,000.00 38,507 1.7% 4.6% City Supported Agencies Operating 537,500.00 537,500.00 249,170 Total 537,500.00 537,500.00 249,170 46.4% 9.6% City Recognitions Operating 10,000.00 10,000.00 - Total 10,000.00 10,000.00 0.0% 0.0% Non-Departmental Vacancy Factor (1,500,000.00) (1,500,000.00) - 0.0% 0.0% S.Lansing Distric Library 145,000.00 145,000.00 37,667 26.0% 23.1% Debt Service 1,346,312.00 1,346,312.00 - 0.0% 0.0% Net Transfers 6,497,125.00 6,497,125.00 6,497,125 100.0% 100.0% Total 6,488,437.00 6,488,437.00 6,534,792 General Fund Total Expenditures 165,400,000.00 165,400,000.00 39,291,183 23.8% 23.1% Vacancy Factor Report Quarter Ending September 30,2024 Department PCN Position Description Bargaining Unit FIFE Vacancy Vacancy Factor Vacancies Counted Toward General Fund Vacancy Factor MAYOR DPCFSTAF DEPUTY MAYOR/CHIEF OF STAFF MAYOR 1.00 7/1/2024 46,343 PUBLIC MEDIA CENTER PTMYRSTF PT MAYORAL STAFF MAYOR 0.50 7/1/2024 5,217 PUBLIC MEDIA CENTER PTMYRSTF PT MAYORAL STAFF MAYOR 0.50 7/1/2024 5,217 HRCS NEW PREVAILING WAGE SPECIALIST T214NS 1.00 7/1/2024 12,174 HRCS NEW SECRETARY T243CTP 1.00 7/1/2024 9,151 CODE COMPLIANCE CCOFICER CODE ENFORCEMENT WORKER T243CTP 1.00 7/1/2024 12,731 CODE COMPLIANCE LDHOUSIN LEAD HOUSING INSPECTOR T243SUPV 1.00 8/21/2022 18,840 CODE COMPLIANCE PRMISOFF PREMISE OFFICER T243CTP 1.00 7/1/2024 10,056 CODE COMPLIANCE PRMISOFF PREMISE OFFICER T243CTP 1.00 7/1/2024 10,056 CODE COMPLIANCE PKFLDSUP FIELD SUPERVISOR T243SUPV 1.00 3/6/2024 14,002 ASSESSOR COMINDAP COMMERICAL/INDUSTRIAL APPRAISER T243CTP 1.00 6/15/2022 24,271 ASSESSOR RESAPPLD RESIDENTIAL APPRAISER T243CTP 1.00 10/18/2019 18,060 ASSESSOR RESAPPTR RESIDENTIAL APPRAISER APPRENTICE T243CTP 1.00 5/24/2019 15,558 ASSESSOR RESIDAPP RESIDENTIAL APPRAISER T243CTP 1.00 10/5/2017 CONTRACT TREASURY ACCOUNT34 ACCOUNTANT34 T243CTP 1.00 8/1/2024 9,592 TREASURY TRESYINV TREASURERY INVESTIGATOR T243CTP 1.00 9/30/2024 202 TREASURY INTAXAUD INCOME TAX AUDITOR T243CTP 1.00 8/1/2024 8,694 TREASURY ADMAST28 ADMINISTRATIVE ASSISTANT T243CTP 1.00 10/8/2022 14,827 TREASURY CUSTRP CUSTOMER SERVICE CLERK T243CTP 1.00 8/20/2022 8,348 HUMAN RESOURCES NEW DISPUTES AND RESOLUTIONS T243CTP 1.00 7/1/2024 17,936 CITY ATTORNEY LGLADVSR LEGAL ADVISOR T214NS 1.00 7/1/2020 19,013 CITY ATTORNEY ASTATY36 ASSISTANT CITY ATTORNEY T214 NS 1.00 12/1/2023 25,592 PUBLIC SERVICE/BUILDINGS CUSTOWKR CUSTODIAL WORKER 300 UAW 1.00 12/3/2021 10,593 PUBLIC SERVICE/BUILDINGS FACMTWKR SKILLED TRADES WORKER UAW 1.00 2/10/2024 12,588 PUBLIC SERVICE/BUILDINGS FACMTWKR SKILLED TRADES WORKER UAW 1.00 1/17/2024 12,588 PUBLIC SERVICE/BUILDINGS FACMTWKR SKILLED TRADES WORKER UAW 1.00 6/15/2024 12,588 POLICE-ADMIN ADMSPC31 ADMINISTRATIVE SPECIALIST31 T214NS 1.00 12/28/2011 CONTRACT POLICE-ADMIN ASTPOLCF ASSISTANT POLICE CHIEF NBSUPV 1.00 7/1/2024 24,898 POLICE-DETENTION POLOFFCR POLICE OFFICER 1 CCLPNS 1.00 01/31/23 19,946 POLICE-DETENTION DETENOFF DETENTION OFFICER T243CTP 1.00 01/19/24 18,959 POLICE-INVESTIGATIONS DETECT2C DETECTIVE IIC CCLP NS 1.00 5/1/2021 21,323 POLICE-INVESTIGATIONS DTCTVCSI CSIINVESTIGATOR CCLP NS 1.00 09/24/22 13,956 POLICE-INVESTIGATIONS POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 10/07/23 13,956 POLICE-INVESTIGATIONS POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 06/O1/23 13,956 POLICE-INVESTIGATIONS POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 07/14/22 13,956 POLICE-INVESTIGATIONS POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 02/14/23 13,956 POLICE-INVESTIGATIONS POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 06/16/22 13,956 POLICE-INVESTIGATIONS POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 12/17/22 13,956 POLICE-INVESTIGATIONS POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 05/06/23 13,956 POLICE-PATROL POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 02/20/24 13,956 POLICE-PATROL POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 03/25/24 13,956 POLICE-PATROL POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 03/09/24 13,956 POLICE-PATROL POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 07/01/24 13,956 POLICE-PATROL POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 07/O1/24 13,956 POLICE-PATROL POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 07/01/24 13,956 POLICE-PATROL POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 07/O1/24 13,956 FIRE-LOGISTICS MATALSP3 MAINTENANCE ALARM SPECIALIST IAFF 1.00 7/1/2022 14,932 FIRE-PREVENTION INSPECT4 INSPECTORIV IAFF 1.00 3/11/2023 22,463 FIRE-OPERATIONS CAPTAIN4 CAPTAINIV IAFF 1.00 9/15/2024 OVERTIME FIRE-OPERATIONS CAPTAIN4 CAPTAINIV IAFF 1.00 9/30/2024 OVERTIME FIRE-OPERATIONS FIRFIGTR FIREFIGHTER IAFF 1.00 9/21/2024 OVERTIME FIRE-OPERATIONS FIRFIGTR FIRE FIGHTER IAFF 1.00 9/21/2024 OVERTIME FIRE-TRAINING SECRTY26 SECRETARY T243CTP 1.00 9/8/2023 10,524 PARKS/BUSINESS&MANAGEMENT ADMSPC27 ADMINISTRATIVE SPECIALIST T243CTP 1.00 3/29/2024 9,588 PARKS/COMMUNITY CENTERS PTCLRK23 PT CLERK23 T243CTP 0.50 9/6/2024 1,025 PARKS/COMMUNITY CENTERS PTCLRK22 PT CLERK22 T243CTP 0.50 7/24/2023 3,801 1st Quarter Vacancy factor: 39.00 711,044 11 Vacancy Factor Report Quarter Ending September 30,2024 Department PCN Position Description Bargaining Unit FTE Vacancy Vacancy Factor Non-Vacancy Factor(non-General Fund)Vacancies PUBLIC SERVICE/O&M PUBWKSUP PUBLIC SERVICE SUPERVISOR T243SUP 1.00 2/5/2024 18,959 PUBLIC SERVICE/O&M SNMATWKR MAINTENANCE WORKER UAW 1.00 9/19/2023 11,587 PUBLIC SERVICE/O&M SNMATWKR MAINTENANCE WORKER UAW 1.00 6/18/2022 11,587 PUBLIC SERVICE/O&M SNMATWKR MAINTENANCE WORKER UAW 1.00 3/31/2022 11,587 PUBLIC SERVICE/O&M SNMATWKR MAINTENANCE WORKER UAW 1.00 1/16/2022 11,587 PUBLIC SERVICE/O&M SNMATWKR MAINTENANCE WORKER UAW 1.00 12/2/2023 11,587 PUBLIC SERVICE/O&M SNMATWKR MAINTENANCE WORKER UAW 1.00 3/26/2021 11,587 PUBLIC SERVICE/O&M SWRTMWKS SEWER MAINTENANCE WORKER UAW 1.00 3/15/2023 13,613 PUBLIC SERVICE/O&M FRSTWKRS ARB0RIST500 UAW 1.00 2/22/2023 12,588 PUBLIC SERVICE/O&M FRSTWKRS ARB0RIST500 UAW 1.00 7/l/2024 12,588 PUBLIC SERVICE/O&M FRSTWKRS ARB0RIST500 UAW 1.00 2/22/2023 12,588 PUBLIC SERVICE/O&M SOLWASOP SOLID WASTE OPERATOR UAW 1.00 7/l/2024 12,588 PUBLIC SERVICE/O&M CEMATWK2 CEMETARY WORKER UAW 1.00 7/1/2024 12,588 PUBLIC SERVICE/O&M CRTFNWRK CONCRETE FINISHER-WORKER UAW 1.00 7/l/2024 12,588 PUBLIC SERVICE/O&M EQP0PWK4 EQUIPMENT OPERATOR UAW 1.00 7/11/2024 11,062 PUBLIC SERVICE/O&M MANTWKR3 MAINTENANCE WORKER UAW 1.00 7/l/2024 11,587 PUBLIC SERVICE/O&M MANTWKR3 MAINTENANCE WORKER UAW 1.00 4/19/2023 11,587 PUBLIC SERVICE/O&M MANTWKR3 MAINTENANCE WORKER UAW 1.00 9/9/2024 2,809 PUBLIC SERVICE/O&M MANTWKR3 MAINTENANCE WORKER UAW 1.00 7/27/2024 8,075 PUBLIC SERVICE/O&M MANTWKR4 MAINTENANCE WORKER UAW 1.00 4/15/2024 12,588 PUBLIC SERVICE/O&M SRMANSUP SENIOR MAINTENANCE SUPERVISOR 37 T243SUPV 1.00 8/16/2024 7,494 PUBLIC SERVICE/O&M SOLWASOP SOLID WASTE OPERATOR UAW 1.00 7/l/2024 12,588 PUBLIC SERVICE/O&M SOLWASOP SOLID WASTE OPERATOR UAW 1.00 4/25/2024 12,588 PUBLIC SERVICE/O&M MANTWKR3 MAINTENANCE WORKER UAW 1.00 8/28/2021 11,587 PUBLIC SERVICE/O&M SWRMTWK3 SEWER MAINTENANCE WORKER T243SUPV 1.00 1/31/2022 13,613 PUBLIC SERVICE/O&M PUBWKSUP PUBLIC SERVICE SUPERVISOR T243SUP 1.00 12/4/2021 18,959 PUBLIC SERVICE/O&M SOLWASUP SOLID WASTE SUPERVISOR T243SUP 1.00 8/15/2020 17,174 ED&P/BUILDING SAFETY PLNREVSU PLAN REVIEW SUPERVISOR T214SUPV 1.00 1/8/2022 20,934 ED&P/BUILDING SAFETY MECINSPC MECHANICAL INSPECTOR T243CTP 1.00 6/30/2023 18,959 ED&P/BUILDING SAFETY BLDINSPC BUILDING INSPECTOR T243CTP 1.00 3/26/2024 17,174 ED&P/BUILDING SAFETY PEMTEFOF PERMITS ENFORCEMENT OFFICER T243CTP 1.00 1/1/2024 18,959 ED&P/CDBG NEW ASSISTANT DEVELOPMENT MGR T2145UPV 1.00 7/l/2024 17,063 ED&P/CDBG DEVELMGR DEVELOPMENT MANAGER NBSUPV 1.00 7/19/2024 17,766 ED&P/CDBG HSREHAGT HOUSING REHAB AGENT T243CTP 1.00 7/l/2024 12,731 ED&P/PARKING CUSTSREP CUSTOMER SERVICE REP T243CTP 1.00 8/17/2024 3,921 ED&P/PARKING SRLEDCSR SENIOR LEAD CUST SRVC REP T243CTP 1.00 7/l/2024 11,042 ED&P/PARKING PKGRVCOL PARKING REVENUE AMBASSADOR UAW 1.00 3/27/2023 9,781 ED&P/PARKING PKGRVCOL PARKING REVENUE AMBASSADOR UAW 1.00 6/15/2024 9,781 PUBLIC SERVICE/WWTP LABTECHN LABORATORY TECHNICIAN T243CTP 1.00 7/1/2024 10,524 PUBLIC SERVICE/WWTP LABSUP-TBD LAB SUPERVISOR T243SUP 1.00 7/1/2017 18,959 PUBLIC SERVICE/WWTP ELECTECH ELECTRICAL TECHNICIAN T243CTP 1.00 10/5/2006 16,359 PUBLIC SERVICE/WWTP WWMATWK6 WASTE WATER PLANT LABORER UAW 1.00 7/12/2019 12,588 PUBLIC SERVICE/WWTP WWSYSANL WASTEWATER SYSTEMS ANALYST T243CTP 1.00 10/23/2015 17,174 PUBLIC SERVICE/WWTP UTLELWKR UTILITY ELECTRICAL WORKER UAW 1.00 10/1/2022 13,613 PUBLIC SERVICE/WWTP FIELDTEC FIELDTECHNICIAN T243CTP 1.00 7/l/2024 10,524 PUBLIC SERVICE/WWTP WWMATWK7 WASTEWATER MAINTENANCE WKR 400 UAW 1.00 11/4/2023 11,587 PUBLIC SERVICE/WWTP LABTECHN LABORATORY TECHNICIAN T243CTP 1.00 6/30/2023 10,524 PUBLIC SERVICE/WWTP INSTRTEC INSTRUMENTATION TECHNICIAN T243CTP 1.00 3/2/2024 10,524 PUBLIC SERVICE/WWTP ST0RKPR4 STOREKEEPER/PARTS WORKER UAW 1.00 1/21/2024 12,588 PUBLIC SERVICE/WWTP WWPNT0P6 WASTEWATER MAINTENANCE WKR 600 UAW 1.00 5/27/2020 13,613 PUBLIC SERVICE/FLEET RADIOTEC RADIO INST.TECHNICIAN T243CTP 1.00 7/14/2023 10,524 PUBLIC SERVICE/FLEET VEHWKR04 VEHICLE MAINTENANCE WORKER 400 UAW 1.00 5/6/2024 11,587 PUBLIC SERVICE/FLEET ATGARSUP ASSIST SHIFT GARAGE SUPERVISOR T243SUP 1.00 7/l/2017 15,558 PUBLIC SERVICE/FLEET ATGARSUP ASSIST SHIFT GARAGE SUPERVISOR T243SUP 1.00 7/12/2019 15,558 PUBLIC SERVICE/FLEET MECHANIC MECHANIC UAW 1.00 4/l/2024 13,613 PUBLIC SERVICE/FLEET MECHANIC MECHANIC UAW 1.00 3/29/2019 13,613 PUBLIC SERVICE/FLEET MECHANIC MECHANIC UAW 1.00 5/13/2019 13,613 PUBLIC SERVICE/FLEET MECHANIC MECHANIC UAW 1.00 8/17/2019 13,613 PUBLIC SERVICE/FLEET SRVCSPEC SERVICE SPECIALIST T243CTP 1.00 9/20/2019 12,269 PUBLIC SERVICE/FLEET MECHANIC MECHANIC UAW 1.00 6/4/2022 13,613 PUBLIC SERVICE/FLEET MECHANIC MECHANIC UAW 1.00 7/21/2021 13,613 PUBLIC SERVICE/FLEET MECHANIC MECHANIC UAW 1.00 12/16/2023 13,613 PUBLIC SERVICE/FLEET MECHANIC MECHANIC UAW 1.00 10/28/2023 13,613 PUBLIC SERVICE/ENGINEERING ADMSPC30 ADMINISTRATIVE SPECIALIST T243CTP 1.00 12/1/2023 11,042 PUBLIC SERVICE/ENGINEERING ENGINR38 ENGINEER 38 T214NS 1.00 1/26/2023 24,353 PUBLIC SERVICE/ENGINEERING ENGINR38 ENGINEER 38 T214NS 1.00 6/6/2019 24,353 PUBLIC SERVICE/ENGINEERING BFINMGMT BUSINESS AND FINANCIAL MANAGER T243CTP 1.00 7/l/2024 17,936 PUBLIC SERVICE/ENGINEERING TRANSENG TRANSPORTATION ENGINEER NB SUPV 1.00 1/1/2020 28,898 INFORMATION TECHNOLOGY NEW TELECOMMUNICATIONS TECHNICIAN T243CTP 1.00 7/l/2024 13,344 1st Quarter Vacancy factor: 69.00 940,340 Total Ql Vacancy Factor 108.00 1,651,384 11