FY 2023 Finance Department Budget Presentation
Actual and Estimated Expenditures by Object
Department
Expenditures by Object
2018
Actuals
2019
Actuals
2020
Actuals
2021
Actuals
2022
Estimate
2023
Proposed
Personnel Costs $4,287,054 $4,277,685 $8,423,986 $8,608,558 $10,092,200 $10,681,100 Non-Personnel Costs 1,324,751 1,186,529 2,076,180 49,520,343 36,593,900 101,038,100 ID Charge Costs 1,183,216 1,276,500 3,184,959 2,706,468 2,773,200 3,198,000 TOTAL EXPENDITURES $6,795,021 $6,740,715 $13,685,125 $60,835,369 $49,459,300 $114,917,200 Finance Department
Actual and Estimated Expenditures
1. FY 21 Actual Personnel costs include partial year of staff for the Emergency Rental Assistance Program (ERAP).
2. FY 21 Actual Non-Personnel costs increased due to CARES-funded expenditures being paid from Finance.
3. FY 22 Estimate Personnel Costs include a full year of staff costs to process ERAP claims.
4. FY 22 Estimate Non-Personnel costs decreasing due to a decline in CARES-funded expenses.
5. FY 22 Estimate Non-Personnel costs include ERAP funded expenses.
6. FY 23 Proposed Non-Personnel costs include budgeting projects funded with ARPA ($71,226,600) and ERAP ($24,777,400) monies.
Actual and Estimated Revenue by Type
Department Revenue by Type 2018
Actuals
2019
Actuals
2020
Actuals
2021
Actuals 2022 Estimate 2023 Proposed
General Fund $1,496,634 $1,606,896 $1,503,819 $15,803,225 $1,513,600 $1,375,800 Special Revenue 0 0 92,795,521 180,857,919 167,601,100 88,549,600 Enterprise 0 0 0 0 0 0
Internal Service Fund 12,944,463 26,057,424 37,262,273 36,665,420 8,478,000 9,231,300 Trust (310) (1,378) 1,125 16,776 0 0
Debt Service 1 1 2 (1) 0 0
TOTAL REVENUE $14,440,787 $27,662,944 $131,562,740 $233,343,339 $177,592,700 $99,156,700 Finance Department
Actual and Estimated Revenues
Department Notes
1. Internal Service Fund revenue includes Health Self Insurance and Flexible Benefits Funds.
2. FY 20 includes $92.8 million of CARES funding received and deposited into Special Revenue Fund.
3. FY 21 Special Revenue Actuals include $85.4 million of ARPA funding and $34.6 million of ERAP.
4. FY 22 Special Revenue Estimates include figures for additional ERAP and ARPA funding anticipated to be received by fiscal year end.
5. FY 23 Special Revenue Proposed numbers reflect no additional ERAP or ARPA funds to be received.
6. FY 23 General Fund reflects a decrease in Variable Reimbursement due to Purchasing moving to General Services Department.
7. FY 22 and FY 23 Internal Service Fund Revenues do not include Health Self Insurance or Flexible Benefit Fund Estimates.
Finance Department
American Rescue Plan Act (ARPA)
Revenue Replacement
- Under ARPA Final Guidance, entities that receive a direct allocation of ARPA funds can use at least a portion of the monies to backfill revenues presumed to be lost due to the COVID pandemic’s economic impacts. - Revenue Replacement dollars can be used for any purpose the governmental entity deems appropriate. For all intents and purposes, they can be treated just like General Fund dollars. - The ARPA Final Guidance lists three methodologies for calculating the Revenue Replacement amount:
• Based on actual revenues calculated on a calendar year basis. • Based on actual revenues calculated on a fiscal year basis. • A flat $10 million standard allowance.
- In March 2022, Council approved the recognition of the $10 million standard allowance as Staff had determined that amount would be the minimum Revenue Replacement the City could claim. - Since then, Staff has completed the calculations for revenue replacement on a fiscal year basis and identified that the City can recognize up to $88,936,400 in revenue loss based on the Annual Consolidated Financial Reports (ACFR) for FY2020 ($37,807,000) and FY2021 ($51,129,400).
- ARPA Reporting Guidance recommends (but does not mandate) that Revenue Replacement dollars be spent on projects.
Finance Department
American Rescue Plan Act (ARPA)
As of the publication of this budget, Council has approved the allocation of $106,185,200 in ARPA funds. The FY 2023 Budget includes the allocation of the remaining ARPA funds of $64,622,800.
FY 23 Budget Expansions Expansion
Count or Cost
Additional Employees, Counts 2.00 FTE
Additional Employees, Costs $161,300
New Information Technology/Communications Equipment $8,800 New Field Services Equipment
Overtime $10,000
Operations and Maintenance $4,000
TOTAL FY 23 BUDGET EXPANSIONS $184,100
Finance Department
FY 23 Budget Expansions
Department Notes
1. Addition of two Payroll limited positions, Accountant Auditor and Payroll Accountant ($161,299), and computer equipment ($8,800).
2. Overtime for Business Tax and Payroll Unit ($10,000).
3. Office Supplies and Training for new Grants Management Unit ($4,000).
Finance Department
FY 23 Department Budget Priorities
Notable Service Impacts:
1. Two limited Payroll positions to reach sufficient
staffing levels in order to address ongoing
changing labor & tax laws, the growth in
processing payroll checks, as well as needed
coverage as payroll staff are assisting with the
migration to the Tyler Munis financial and
personnel systems.