Loading...
HomeMy WebLinkAboutGeneral fund Status Report FY23 1st Quater Budget Report General Fund Status Report — FY 2023 1st Quarter General Fund Summary The City budgeted to end FY22 with $18,579,413 in combined general fund reserves. For FY23, the City budgeted $145,800,000 in total revenue including transfers and $155,512,500 in total expenditures. The difference between budgeted revenue and budgeted expenditures is expected to be covered by ARPA funds. Thus, the estimated ending balance for FY23 is the same as the beginning balance of$18,579,413. The City's fund balance policy recommends a fund balance that is between 12%- 15% of expenditures. With estimated expenditures of$155,512,500, the recommended fund balance is $18,661,500 to $23,326,875. The City's annual audit is currently in progress. The final audit numbers for FY22 will be available for the quarterly report that ends December 31, 2022. How the Money is Spent FY 2022/2023 General Fund Budget 155.5 MiLLion Recreation & Information Fleet/ Debt Service Public Service Culture Technology Equipment 1% Engineering Capital/Fund 4% 4% 4% 1% Transfers City 311 Service 4% 0% Retirement/Fixed W Ft Fringes Community 28% Development 6% v3M Pls w e9k«dril t' ?x��`P, P'y Public Service 6% e, General Government 10% w S Y^a Police Department Fire Department 14% Revenue Summary General Fund revenue collected through the first quarter of fiscal year 2022-2023 are on track with expectations. • Property Taxes (33.2% of GF revenue budget) are largely collected at the beginning of the fiscal year. They were initially estimated to be $48.245M. At the end of the quarter, collections were roughly $50.79M. Although collections currently exceed estimated amounts, they are subject to tax appeals and other adjustment throughout the fiscal year. • Income Tax (25.8% of GF revenue budget) collections are slightly below the first quarter target. At the end of the 15Y quarter, income tax collections were $8.7M (23.3% of its budgeted $37.51M). • Return on Equity (ROE) (17.2% 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 amount was $7,138,749. This payment is 28.6% of the FY23 budgeted ROE amount of$25M. • State Revenue (14.8% of GF revenue budget) are estimated to be $16,899,500. Payments in the form of revenue sharing are expected to begin arriving in October. • Charges for Services (6.2% of GF revenue budget) are trending slightly ahead of the year-end estimated amount. • Fines and Forfeitures (1.2% of GF revenue budget) are budgeted to be $1,692,200. Quarter-to-date, they are trending ever so slightly below expectations. • Licenses and Permits (1.2% of GF revenue budget) are estimated to be $1,769,300. The City has received 11.8% of the budgeted amount. This low percentage is a timing issue because none of the estimated $1M of Cable Franchise fees have been received. • Interest and Rents (0.2% of GF revenue budget) are budgeted to be $330,000 in FY23. The quarter-to-date amount of$51,728 appears low due to the timing of these revenue getting posted. • Other Revenues (0.2% of GF revenue budget) are a very small percentage of the General Fund budget and are trending below budget expectations. Expenditure Summary Departmental actual expenditures for the first quarter are below first quarter anticipated expenditures. Percent of Actual Expenditure by Department for the First Quarter of FY23 0.50 0.45 _.. 0.40 0.35 0.30 0.25 _ 0.20 0.15 - - _ 0.10 - 0.05 0.00 e C° a�PJa�� L �oJ 5e\`e ��`� ����Fec`e ,Z. P Qat 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. Even so, there remains significant challenges to maintaining the City's fiscal health. 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, then in governmental detail it is summarized by purpose. September 30, 2023 Revenue Summary Fiscal Year July 1, 2022-June 30, 2023 FY 2023 FY 2023 FY 2023 FY 2023 Sep. 30 General Fund Revenues Adopted Amended Proiected Sep. 30 Percent Budget Budget Budget Actuals YTD Property Taxes Non-Dedicated 36,095,000 36,495,000 36,495,000 39,038,502 Dedicated - Police 3,645,000 3,525,000 3,525,000 3,525,000 Dedicated - Fire 3,645,000 3,525,000 3,525,000 3,525,000 Dedicated - Roads 2,430,000 2,350,000 2,350,000 2,350,000 Dedicated - Parks 2,430,000 2,350,000 2,350,000 2,350,000 Total 48,245,000 48,245,000 48,245,000 50,788,502 105.3% Income Taxes City Income Tax 37,510,000 37,510,000 37,510,000 8,747,789 Total 37,510,000 37,510,000 37,510,000 8,747,789 23.3% Return on Equity Board of Water and Light 25,000,000 25,000,000 25,000,000 7,138,749 Sewer fund 300,000 300,000 300,000 Total 25,300,000 25,300,000 25,300,000 7,138,749 28.2% State Revenues Revenue Sharing 16,899,500 16,899,500 16,899,500 - Fire Reimbursement Grants 2,750,000 2,750,000 2,750,000 - Personal Property Tax Reimbursement 900,000 900,000 900,000 - Recreational Marijuana 900,000 900,000 900,000 - Liquor License Fee 70,000 70,000 70,000 66,129 Total 21,519,500 21,519,500 21,519,500 66,129 0.3% Charges for Services Public Safety 4,368,850 4,368,850 4,368,850 1,157,532 Reimbursements 2,242,200 2,242,200 2,242,200 759,353 Code Compliance 1,846,000 1,846,000 1,846,000 282,651 Recreation Fees 415,500 415,500 415,500 159,595 Appeals& Petitions 82,450 82,450 82,450 25,773 Work for Others 33,200 33,200 33,200 111,123 Central Stores 3,500 3,500 3,500 675 Subscriptions and Information 2,300 2,300 2,300 (5,080) Total 8,994,000 8,994,000 8,994,000 2,491,621 27.7% Fines and Forfeitures Fines and Forfeitures 1,692,200 1,692,200 1,692,200 404,414 Total 1,692,200 1,692,200 1,692,200 404,414 23.9% Licenses&Permits Cable Franchise Fees 1,000,000 1,000,000 1,000,000 - Marihuana Licenses 650,000 650,000 650,000 185,000 Business Licenses 64,450 64,450 64,450 16,959 Non-Business Licenses 37,600 37,600 37,600 4,148 Building Licenses&Permits 17,250 17,250 17,250 3,550 Total 1,769,300 1,769,300 1,769,300 209,657 11.8% Interest&Rents Interest Income 330,000 330,000 330,000 51,728 Total 330,000 330,000 330,000 51,728 15.7% Other Revenues Miscellaneous 173,000 173,000 173,000 8,916 Sale of Fixed Assets 102,000 102,000 102,000 - Donations&Contributions 65,000 65,000 65,000 18,666 Total 340,000 340,000 340,000 27,582 8.1% Total General Fund Operating Revenue 145,700,000 145,700,000 145,700,000 69,926,171 48.0% Transfers from Other Funds 100,000 100,000 100,000 - Total 145,800,000 145,800,000 145,800,000 69,926,171 48.0% September 30, 2022 Departmental Summary Fiscal Year July 1, 2019 -June 30, 2022 FY 2023 FY 2023 FY 2023 Sep. 30 General Fund Appropriations Adopted Amended Sep. 30 Percent Budget Budget Actuals YTD Beginning General Fund Balance 5,873,867 5,873,867 5,873,867 Beginning Budget Stab. Fund Balance 12,705,546 12,705,546 12,705,546 Total General Fund Reserves 18,579,413 18,579,413 18,579,413 Revenues (detail on previous page) 145,800,000 145,800,000 69,926,171 48.0% Departmental Expenditures: Council 726,651 726,651 135,134 18.6% Internal Audit 207,885 207,885 15,736 7.6% Mayor's Office 1,769,932 1,769,932 343,585 19.4% Office of Community Media 606,113 606,113 125,392 20.7% District Court 5,984,638 5,984,638 1,301,735 21.8% Circuit Court Building Rental 336,693 336,693 - 0.0% City Clerk's Office 1,542,191 1,542,191 415,525 26.9% Neighborhood &Citizen Engagement 1,326,296 1,326,296 334,221 25.4% Economic Development &Planning 6,772,299 6,772,299 3,125,157 46.1% Finance Department 2,100,195 2,100,195 424,319 20.2% City Assessor 1,970,719 1,970,719 298,022 15.1% Treasury/Income Tax 2,398,328 2,398,328 521,530 21.7% Human Resources Department 2,724,062 2,724,062 381,302 14.0% City Attorney's Office 2,520,110 2,520,110 476,910 18.9% Police Department 51,580,854 51,580,854 11,627,473 22.5% Fire Department 40,272,672 40,272,672 9,131,417 22.7% Public Service 12,571,351 12,571,351 4,728,363 37.6% Human Relations &Community Services 1,842,818 1,842,818 329,486 17.9% Parks & Recreation Department 9,380,212 9,380,212 1,534,980 16.4% Human Service Agency Support 1,958,000 1,958,000 83,626 5.4% Non-Departmental Expenditures: Library Building Rental 136,150 136,150 33,587 24.7% Operating Subsidies to Other Funds 197,631 197,631 - 0.0% City Supported Agencies 489,500 489,500 (1,500) -0.3% Capital Improvements 4,823,000 4,823,000 - 0.0% Debt Service & Penalties 987,100 987,100 - 0.0% Vacancy Factor (700,000) (700,000) - Expenditures 155,512,500 155,512,500 35,365,998 22.8% Net Impact on Fund Balance (9,712,500) (9,712,500) Federal Stimulus Reimbursement IRS/ACA Bills Resolved - - Ending General Fund Reserves 8,866,913 8,866,913 September 30, 2023 Budget Appropriation Summary Fiscal Year July 1, 2022 -June 30, 2023 FY 2023 FY 2023 FY 2023 Sep. 30 Estimated Revenues Adopted Amended Sep. 30 Percent Budget Budget Actuals YTD Property Taxes 48,245,000 48,245,000 50,788,502 Income Taxes 37,510,000 37,510,000 8,747,789 Return on Equity 25,000,000 25,000,000 7,138,749 State Revenues 21,519,500 21,519,500 66,129 Charges for Services 8,994,000 8,994,000 2,491,621 Fines & Forfeitures 1,692,200 1,692,200 404,414 Licenses & Permits 1,769,300 1,769,300 209,657 Interest& Rent 330,000 330,000 51,728 Other Revenue 340,000 340,000 27,582 TOTAL REVENUES 145,400,000 145,400,000 69,926,171 48.0% FY 2023 FY 2023 FY 2023 Sep. 30 Appropriations Adopted Amended Sep. 30 Percent Budget Budget Actuals YTD Council Personnel 474,673 474,673 98,573 Operating 251,978 251,978 36,561 Total 726,651 726,651 135,134 18.6% Internal Audit Personnel 195,589 195,589 13,484 Operating 12,296 12,296 2,252 Total 207,885 207,885 15,736 7.6% Courts Personnel 4,829,179 4,829,179 1,001,542 Operating 1,492,152 1,492,152 300,193 Total 6,321,331 6,321,331 1,301,735 20.6% Mayor's Office Personnel 1,523,058 1,523,058 303,152 Operating 246,874 246,874 40,433 Total 1,769,932 1,769,932 343,585 19.4% Media Center Personnel 533,107 533,107 104,612 Operating 73,006 73,006 20,780 Total 606,113 606,113 125,392 20.7% Clerk's Office Personnel 1,103,136 1,103,136 280,816 Operating 439,055 439,055 134,709 Total 1,542,191 1,542,191 415,525 26.9% Neighborhood &Citizen Engagement Personnel 790,097 790,097 174,547 Operating 536,199 536,199 159,674 Total 1,326,296 1,326,296 334,221 25.4% Economic Development& Planning Personnel 3,364,071 3,364,071 661,207 Operating 3,408,228 3,408,228 2,463,950 Total 6,772,299 6,772,299 3,125,157 92.9% Finance/Operations Personnel 1,548,729 1,548,729 331,066 Operating 551,466 551,466 93,253 Total 2,100,195 2,100,195 424,319 20.2% FY 2023 FY 2023 FY 2023 Sep. 30 Appropriations Adopted Amended Sep. 30 Percent Budget Budget Actuals YTD Assessing Personnel 1,690,117 1,690,117 261,991 Operating 280,602 280,602 36,031 Total 1,970,719 1,970,719 298,022 15.1% Treasury Personnel 1,832,523 1,832,523 358,392 Operating 565,805 565,805 163,138 Total 2,398,328 2,398,328 521,530 21.7% Human Resources Personnel 1,609,829 1,609,829 271,037 Operating 1,114,233 1,114,233 110,265 Total 2,724,062 2,724,062 381,302 14.0% Attorney's Office Personnel 2,211,152 2,211,152 403,093 Operating 308,958 308,958 73,817 Total 2,520,110 2,520,110 476,910 18.9% Police Personnel 43,330,653 43,330,653 9,868,435 Operating 8,250,201 8,250,201 1,759,038 Total 51,580,854 51,580,854 11,627,474 22.5% Fire Personnel 34,484,467 34,484,467 8,133,026 Operating 5,788,205 5,788,205 998,390 Total 40,272,672 40,272,672 9,131,417 22.7% Public Service Personnel 2,945,961 2,945,961 3,003,075 Operating 9,625,390 9,625,390 1,725,289 Total 12,571,351 12,571,351 4,728,364 37.6% Human Relations &Community Service Personnel 1,669,373 1,669,373 296,294 Operating 173,445 173,445 33,191 Total 1,842,818 1,842,818 329,485 17.9% Parks & Recreation Personnel 5,759,154 5,759,154 553,881 Operating 3,621,058 3,621,058 981,099 Total 9,380,212 9,380,212 1,534,980 16.4% Human Services Operating 1,958,000 1,958,000 83,626 Total 1,958,000 1,958,000 83,626 5.4% City Supported Agencies Operating 489,500 489,500 (1,500) Total 489,500 489,500 (1,500) -0.3% Non-Departmental Vacancy Factor (700,000) (700,000) - Library Lease 136,150 136,150 33,587 Debt Service 987,100 987,100 - Net Transfers 6,007,731 6,007,731 - Total 6,430,981 6,430,981 33,587 -6.0% TOTAL EXPENDITURES 155,512,500 155,512,500 35,365,999 24.4% Vacancy Factor Report Fiscal Year Ending September 30,2022 Department Key PCN Position Description Bargaining Unit FTE Vacancy Vacancy Factor Vacancies Counted Toward General Fund Vacancy Factor COUNCIL/INTERNALAUDIT 1012120 LEGISAUD LEGISLATIVE AUDITOR COUNCIL 1.00 2/20/2020 22,483 NEIGH CTZN ENG 1012320 OPCOORDR GRANT ADMINISTRATOR T243CTP 1.00 7/1/2022 15,379 HRCS 1012500 HMISPFAN HMIS PERFORMANCE ANALYST T243CTP 1.00 9/3/2021 14,024 HRCS 1012500 T243SUP CONTRACT MNGMNT ADMINISTRATOR T243SUP 1.00 5/26/2022 24,570 CODE COMPLIANCE 1012610 CCOFICER CODE ENFORCEMENT WORKER T243CTP 1.00 7/1/2022 17,871 CODE COMPLIANCE 1012610 PRMISOFF PREMISE OFFICER T243CTP 1.00 8/1/2022 9,999 CODE COMPLIANCE 1012610 PRMISOFF PREMISE OFFICER T243CTP 1.00 8/11/2022 8,221 ED&P/PLANNING 1012620 ASTPLMGR ASSISTANT PLANNING MANAGER T214 SUPV 1.00 3/20/2020 CONTRACT FINANCE/OPERATIONS 1012710 FINDRCTR FINANCE DIRECTOR EXEC MGMT PLAN 0.50 8/13/2021 NO BDGT IMPACT FINANCE/OPERATIONS 1012710 BUDGETAN BUDGETANALYST T243CTP 1.00 B/6/2022 10,026 ASSESSOR 1012720 COMINDAP COMMERICAL/INDUSTRIALAPPRAISR T243CTP 1.00 6/15/2022 20,135 ASSESSOR 1012720 RESAPPLD RESIDENTIAL APPRAISER LEAD T243CTP 1.00 10/18/2019 17,871 ASSESSOR 1012720 RESAPPTR RESIDENTIAL APPRAISER APPRENTICE T243CTP 1.00 5/24/2019 14,665 ASSESSOR 1012720 RESIDAPP RESIDENTIAL APPRAISER T243CTP 1.00 10/5/2017 CONTRACT ASSESSOR 1012720 ADMAST28 ADMINISTRATIVE ASSISTANT 28 T243CTP 1.00 7/1/2022 11,565 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/16/2022 1,927 TREASURY 1012730 CUSTSREP CUSTOMER SERVICE REP T243CTP 1.00 2/19/2021 11,565 HUMAN RESOURCES 1012800 DPTDIRHR-TBD DEPUTY HR DIRECTOR NON BARG SUPV 1.00 1/1/2022 21,711 HUMAN RESOURCES 1012800 PRNCRECR PRINCIPAL RECRUITER T243CTP 1.00 4/18/2017 18,785 HUMAN RESOURCES 1012800 HRSPEC34 HIRING SPECIALIST T243CTP 1.00 7/1/2022 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 893 CITY ATTORNEY 1012900 LGLADVSR LEGAL ADVISOR T214 NS 1.00 4/6/2018 17,922 CITY ATTORNEY 1012800 PTASST31 PT LEGAL ASST DST CT 31 NON BARG SUPV 0.75 7/1/2022 7,448 PUBLIC SERVICE/BUILDINGS 1013140 BLDSERSU BUILDING SERVICES SUPERVISOR T243CTP 1.00 10/16/2020 19,732 PUBLIC SERVICE/BUILDINGS 1013140 CUSTOWKR CUSTODIAL WORKER 300 UAW 1.00 12/3/2021 9,985 PUBLIC SERVICE/BUILDINGS 1013140 ELCTRICN ELECTRICIAN T243SUP 1.00 12/30/2018 14,665 PUBLIC SERVICE/BUILDINGS 1013140 ELECFACW ELECTRICAL FACILITY CTRL WKR T243SUP 1.00 11/2/2018 11,866 PUBLIC SERVICE/BUILDINGS 1013140 PLUMBSUP PLUMBING SUPERVISOR UAW 1.00 6/10/2018 19,732 PUBLIC SERVICE/BUILDINGS 1013140 ADMAST29 ADMINISTRATIVE ASSISTANT 29 T243CTP 1.00 8/31/2022 5,110 POLICE-ADMIN 1013201 ADMSPC31 ADMINISTRATIVE SPECIALIST 31 T243SUP 1.00 12/28/2011 CONTRACT POLICE-ADMIN 1013201 BUDCTSUP BUDGET CONTROL SUPERVISOR T243SUP 1.00 6/27/2022 CONTRACT POLICE-ADMIN 1013201 CMNCTMGR COMMUNICATIONS DIRECTOR T243SUP 1.00 7/1/2022 CONTRACT POLICE-HUMAN RESOURCES 1013221 CLERKS22 CENTRAL RECORD PRINCIPAL CLERK T243CTP 1.00 7/1/2022 12,891 POLICE-HUMAN RESOURCES 1013221 POLTEC31 LPD FOIA ANALYST T243CTP 1.00 12/13/2021 12,891 POLICE-HUMAN RESOURCES 1013221 POLTEC31 LPD FOIA ANALYST T243CTP 1.00 7/31/2021 13,333 POLICE-RADIO LAB 1013222 RADTEC34 RADIO TECHNICIAN 34 T243CTP 1.00 3/26/2022 CONTRACT POLICE-DETENTION 1013224 DETENOFF DETENTION OFFICER T243CTP 1.00 12/5/2020 17,871 POLICE-DETENTION 1013224 DETENOFF DETENTION OFFICER T243CTP 1.00 5/2/2022 17,871 POLICE-DETENTION 1013224 DETENOFF DETENTION OFFICER T243CTP 1.00 9/22/2022 1,895 POLICE-DETENTION 1013224 DETENOFF DETENTION OFFICER T243CTP 1.00 9/7/2022 5,381 POLICE-DETENTION 1013224 DETENOFF POLICE OFFICER 1 CCLP NS 1.00 7/1/2022 18,537 POLICE-INVESTIGATIONS 1013240 DETECT2C DETECTIVE IIC CCLP NS 1.00 5/1/2021 19,835 POLICE-INVESTIGATIONS 1013240 DETECT213 DETECTIVE 118 CCLP NS 1.00 6/17/2022 19,835 POLICE-INVESTIGATIONS 1013240 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 2/13/2021 12,891 POLICE-INVESTIGATIONS 1013240 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 7/1/2022 12,891 POLICE-INVESTIGATIONS 1013240 POLOFFDT POLICE OFFICER DETECTIVE PAY CCLP NS 1.00 4/22/2022 19,835 POLICE-INVESTIGATIONS 1013240 POLOFFDT POLICE OFFICER DETECTIVE PAY CCLP NS 1.00 7/14/2022 17,130 POLICE-INVESTIGATIONS 1013240 POLOFFDT POLICE OFFICER DETECTIVE PAY CCLP NS 1.00 6/16/2022 19,835 POLICE-INVESTIGATIONS 1013240 SECRTY26 SECRETARY 26 CCLP NS 1.00 5/24/2022 CONTRACT POLICE-PATROL 1013251 ADMAST28 ADMINISTRATIVE ASSISTANT 28 T243CTP 1.00 1/1/2022 11,565 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 7/14/2021 TRAINEE POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 8/7/2021 TRAINEE POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 8/17/2021 TRAINEE POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 9/11/2021 12,891 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 1/6/2022 12,891 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 1/14/2022 12,891 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 2/26/2022 12,891 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 3/10/2022 12,891 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 3/10/2022 12,891 POLICE-PATROL 1013251 POLOFFCR POLICE OFFICER 1 CCLP NS 1.00 3/16/2022 12,891 FIRE-ADMIN 1013501 ASTFIRCF ASSISTANT FIRE CHIEF NB SUPV 1.00 1/15/2021 OVERTIME FIRE-ADMIN 1013501 ADMSPC30 ADMINISTRATIVE SPECIALIST 30 T243CTP 1.00 9/9/2022 3,388 FIRE-ADMIN 1013501 MATALSP3 MAINTENANCE ALARM SPECIALIST 3 IAFF 1.00 7/17/2021 OVERTIME FIRE-ADMIN 1013510 MATALSP3 MAINTENANCE ALARM SPECIALIST 4 IAFF 1.00 7/1/2022 19,687 FIRE-OPERATIONS 1013520 CAPTAIN4 CAPTAIN IV IAFF 1.00 9/30/2020 OVERTIME FIRE-OPERATIONS 1013520 CAPTAIN4 CAPTAIN IV IAFF 1.00 9/10/2021 OVERTIME FIRE-OPERATIONS 1013520 CAPTAIN4 CAPTAIN IV IAFF 1.00 9/10/2021 OVERTIME FIRE-OPERATIONS 1013520 CAPTAIN4 CAPTAIN IV IAFF 1.00 9/11/2021 OVERTIME FIRE-OPERATIONS 1013520 _CAPTAIN4 CAPTAIN IV IAFF 1.00 9/11/2021 OVERTIME FIRE-OPERATIONS 1013520 FIRENG02 ENGINEER 11 IAFF 1.00 5/3/2021 OVERTIME' Vacancy Factor Report Fiscal Year Ending September 30,2022 Department Kev PCN Position Description Bargaining Unit FTE Vacancy Vacancy Factor FIRE-OPERATIONS 1013520 FIRENG02 ENGINEER II IAFF 1.00 7/31/2021 OVERTIME FIRE-OPERATIONS 1013520 FIRENG02 ENGINEER II IAFF 1.00 9/11/2021 OVERTIME FIRE-OPERATIONS 1013520 FIRENG02 ENGINEER II IAFF 1.00 9/14/2021 OVERTIME FIRE-OPERATIONS 1013520 FIRENG02 ENGINEER II IAFF 1.00 10/23/2021 OVERTIME FIRE-OPERATIONS 1013520 FIRENG02 ENGINEER II IAFF 1.00 10/23/2021 OVERTIME FIRE-OPERATIONS 1013520 FFTRAINE FIRE FIGHTER TRAINEE IAFF 4.00 7/1/2022 32,755 PARKS/BUSINESS&MGMT 1013910 ACCiGCLK ACCOUNTING CLERK T243CTP 1.00 3/5/2022 12,717 PARKS/BUSINESS&MGMT 1013810 ADMSPC27 ADMINISTRATIVE SPECIALIST T243CTP 1.00 9/2/2022 3,680 PARKS/COMMUNITY CENTERS 1013811 PTCTRPRG PT COMMUNITY CENTER PROGRMMR T243PT 0.88 2/16/2022 12,299 81.88 757,401 Vacancy Factor Report Fiscal Year Ending September 30,2022 Department Key PCN Position Description Bargaining Unit FTE Vacancy Vacancy Factor Non-Vacancy Factor(non-General Fund)Vacancies PUBLIC SERVICE/O&M 1013611 ACTOPRSP ACCOUNTING AND OPERATIONS SPEC T243CTP 1.00 2/21/2022 13,976 PUBLIC SERVICE/O&M 1013611 ACTOPRSP ACCOUNTING AND OPERATIONS SPEC T243CTP 1.00 8/19/2022 6,564 PUBLIC SERVICE/O&M 1013611 EQPOPWK5 EQUIPMENT OPERATOR WORKER 500 UAW 1.00 1/16/2022 11,866 PUBLIC SERVICE/O&M 1013611 EQPOPWK6 EQUIPMENT OPERATOR WORKER 600 UAW 1.00 12/2/2021 12,831 PUBLIC SERVICE/O&M 1013611 MANTWKR4 MAINTENANCE WORKER 400 UAW 1.00 3/25/2022 10,921 PUBLIC SERVICE/O&M 1013611 PKSMTWK2 GROUNDS&MAINTENANCE WKR 200 UAW 1.00 9/4/2021 9,219 PUBLIC SERVICE/O&M 1013611 PKSMTWK2 GROUNDS&MAINTENANCE WKR 200 UAW 1.00 1/24/2022 9,219 PUBLIC SERVICE/O&M 1013611 PUBWKSUP PUBLIC SERVICE SUPERVISOR T243SUP 1.00 12/4/2021 15,420 PUBLIC SERVICE/O&M 1013611 SOLWASUP SOLID WASTE SUPERVISOR T243SUP 1.00 8/15/2020 16,188 ED&P/BUILDING SAFETY 2492610 BLDINSPC BUILDING INSPECTOR T243CTP 1.00 1/18/2022 16,188 ED&P/BUILDING SAFETY 2492610 BLDINSPC BUILDING INSPECTOR T243CTP 1.00 7/1/2022 16,188 ED&P/PARKING 5853640 PRKNGMGR PARKING MANAGER NBSUPV 1.00 9/24/2021 25,917 ED&P/PARKING 5853641 ACCTGCLK ACCOUNTING CLERK T243CTP 1.00 1/22/2018 10,532 ED&P/PARKING 5853641 ACCTGCLK ACCOUNTING CLERK T243CTP 1.00 5/18/2019 10,532 PUBLIC SERVICE/WWTP 5903670 ASPLSUPT ASSIST PLANT SUPERINTENDENT NBSUPV 1.00 7/31/2020 21,255 PUBLIC SERVICE/WWTP 5903670 LABSUP-TBD LAB SUPERVISOR T243SUP 1.00 7/1/2022 15,734 PUBLIC SERVICE/WWTP 5903670 PLOPSU36 PLANT OPERATIONS SUPERVISOR 36 T243SUP 1.00 7/22/2022 14,106 PUBLIC SERVICE/WWTP 5903670 WWMATWK6 WASTEWATER MAINTENANCE WKR600 UAW 1.00 5/27/2020 12,931 PUBLIC SERVICE/WWTP 5903670 WWRESHAN RESIDUAL HANDLER UAW 1.00 12/18/2020 11,866 PUBLIC SERVICE/WWTP 5903670 WWSYSANL WASTEWATER SYSTEMS ANALYST T243CTP 1.00 10/23/2015 16,188 PUBLIC SERVICE/WWTP 5903679 IPPSUP-TBD IPP SUPERVISOR T243SUP 1.00 6/21/2021 10,921 INFOTECH 6303130 DATANLST DATA ANALYST T243CTP 1.00 2/16/2018 16,188 INFOTECH 6303130 TELCMTEC TELECOMMUNICATIONS TECHNICIAN T243SUP 1.00 1/21/2022 15,420 INFOTECH 6303130 GISTECHN-TBD GISTECHNICIAN T243CTP 1.00 Mis-IablePCN - INFO TECH 6303130 SECURADM SECURITY ADMINISTRATOR T243SUP 1.00 Mis-lable PCN - PUBLIC SERVICE/FLEET 6433623 ATGARSUP ASSIST SHIFT GARAGE SUPERVISOR T243SUP 1.00 7/1/2017 14,665 PUBLIC SERVICE/FLEET 6433623 ATGARSUP ASSIST SHIFT GARAGE SUPERVISOR T243SUP 1.00 7/12/2019 14,665 PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 3/29/2019 11,866 PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 8/12/2022 6,472 PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 6/17/2022 11,866 PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 5/13/2019 11,866 PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 8/17/2019 11,866 PUBLIC SERVICE/FLEET 6433623 MECHANIC MECHANIC UAW 1.00 7/21/2021 11,866 PUBLIC SERVICE/FLEET 6433623 SRVCSPEC SERVICE SPECIALIST T243CTP 1.00 9/20/2019 11,565 PUBLIC SERVICE/FLEET 6433623 VEHWKR04 VEHICLE MAINTENANCE WORKER 400 UAW 1.00 11/1/2020 10,921 PUBLIC SERVICE/ENGINEERING G453603 CTYENGNR CITY ENGINEER T243SUP 1.00 8/16/2019 24,044 PUBLIC SERVICE/ENGINEERING 6453603 DPPBSDIR DEPUTY PUBLIC SERVICE DIRECTOR NBSUPV 1.00 7/1/2017 28,615 PUBLIC SERVICE/ENGINEERING 6453603 ENGTECHN ENGINEER TECHNICIAN T243CTP 1.00 9/4/2021 12,717 PUBLIC SERVICE/ENGINEERING 6453603 PLMINSPC PLUMBING INSPECTOR T243CTP 1.00 10/1/2018 14,665 PUBLIC SERVICE/ENGINEERING 6453603 TRANSENG TRANSPORTATION ENGINEER NBSUPV 1.00 1/1/2020 27,239 PUBLIC SERVICE/ENGINEERING 6453603 TRANSENG TRANSPORTATION ENGINEER NBSUPV 1.00 1/1/2020 27,239 HUMAN RESOURCES 1012800 SAFTYADM HEALTH&WELLNESS SPECIALIST T243CTP 0.75 7/1/2022 8,041 HUMAN RESOURCES 1012800 PTPRTECH PT RETIREMENT ANALYST T243CTP 0.50 7/1/2022 3,746 DISTRICT COURT 7602201 COLOFFCR COLLECTIONS OFFICER T243 DCT 1.00 4/1/2021 9,311 DISTRICT COURT 7602201 DPCLERK2 DEPUTY CLERK 2 T243 DCT 1.00 1/17/2020 9,311 DISTRICT COURT 7602201 DPCLERK2 DEPUTY CLERK 2 T243 DCT 1.00 9/7/2021 9,311 DISTRICT COURT 7602201 DPCLERK2 DEPUTY CLERK 2 T243 DCT 1.00 10/2/2021 9,311 DISTRICT COURT 7602201 MAGISCLK MAGISTRATE'S CLERK DCT NON REPR 1.00 7/12/2019 CONTRACT 47.25 621,237