GENERAL FUND
FY 2022-23 Proposed Budget
General Fund - Budget Balancing Spreadsheet
TOTAL ON-GOING ONE-TIME ARPA
Estimated Beginning Working Cash July 1, 2021 General Fund and Fiscal Neutrality 8,228,685 Reserve for Earthquake Insurance Deductible (500,000)
Reserve for Capital Projects (450,000)
Reserve for Planning (825,000)
Reserve for Building (21,800)
Reserve for Reusable Bags (remaining) (13,930)
Reserve for PEG Fees (70,000)
Subtotal, Reserves (1,880,730)
Estimated Beginning Available Working Cash July 1, 2021, Before Fiscal Nueutrality Fund 6,347,955 Reserve for Fiscal Neutrality (4,209,129)
Estimated Beginning Available Working Cash July 1, 2021, After Fiscal Nueutrality Fund 2,138,826 2,138,826 FY 21-22 Projected Surplus from baseline operations 524,700 524,700 FY 21-22 Net of One-time Revenues and Expenditures (1,710,500) (1,710,500) American Rescue Plan Act (ARPA) Loss of Revenue Component 2,918,338 2,918,338 FY 21-22 Priority ARPA Projects (1,020,500) (1,020,500) 2,850,864 - 953,026 1,897,838 Add: Revenues 16,916,000 16,916,000
One-Time Revenues:
Total Revenues 16,916,000 16,916,000 - - Subtract: Expenses (16,139,422) (16,139,422)
One-Time Expenses:
(1) Employee Labor Agreements (3% COLA and 3% Retention Bonus) (350,000) (190,000) (160,000) (2) Village Parkway Traffic Calming (CIP) (626,025) (626,025) (3) Building Facilities Plan (75,000) (75,000)
(4) Parks Master Plan (150,000) (150,000)
Total Expenses (17,340,447) (16,329, 422) (786,025) (225,000) Surplus/(Deficit) (424,447) 586,578 (786,025) (225,000) 2,426,417 586,578 167,001 1,672,838 Estimated Beginning Available Working Cash July 1, 2022 Estimated Available Working Cash, June 30, 2023
FY 22-23 Proposed Budget
General Fund - Budget Summary
FY 19-20 FY 20-21 FY 21-22 FY 22-23
Actual Actual Budget Proposed
Beginning Available Balance 2,412,068 $ 1,847,112 $ 2,138,826 2,850,864$ Revenues
Taxes
Utility User Tax 3,483,843 3,590,649 3,509,000 3,589,000 Sales Tax 4,212,285 4,775,496 4,654,675 4,998,000 Property Taxes 1,415,995 1,451,716 1,520,000 1,571,000 Franchise Fees 948,503 862,104 896,000 905,000 Business Licenses 251,418 268,697 198,000 274,000 Transfer Tax 142,850 126,488 132,000 146,000 Transient Occupancy Tax 6,179 7,635 5,000 114,000 Intergovernmental 2,151,433 2,285,392 2,418,000 2,511,000 Fines & Forefeitures 62,582 36,586 37,000 38,000 Program Revenues
Community Development 675,556 824,891 242,000 306,000 Parks and Recreation 1,020,758 396,290 753,000 1,156,000 Police 483,110 48,958 219,000 139,000 Public Works 28,588 46,908 48,000 38,000 Other 6,770 10,571 11,000 11,000 Use of Money & Property 600,707 511,188 313,000 286,000 Cost allocated to other funds 534,992 619,634 739,325 684,000 Transfers In 227,335 150,000 150,000 150,000 16,252,904 16,013,203 15,845,000 16,916,000 Expenditures
Police 7,564,927 7,549,028 7,545,685 7,821,727 Public Works 305,464 292,525 374,592 382,857 Community Development 611,297 792,456 725,810 790,561 Parks and Recreation 2,165,547 1,434,988 1,787,803 2,017,537 City Council 376,082 407,588 331,114 358,645 City Manager 385,675 360,115 454,908 472,186 Workers Comp/General Liability 1,084,650 1,080,572 1,235,837 1,265,285 Human Resources 219,514 241,725 324,088 322,086 Legal 284,709 154,562 265,000 273,000 City Clerk/PIO 481,094 438,201 436,855 444,482 Finance 1,044,931 1,106,024 1,155,608 1,235,122 Non-Department 766,112 375,912 260,000 615,934 Transfers Out 205,099 214,976 423,000 330,000 15,495,101 14,448,672 15,320,300 16,329,422 Net Annual Activity
Baseline Operations 757,803 1,564,531 $ 524,700 $ 586,578 $ One-Time Revenues 1,723,486 600,750 1,056,000 - One-Time Expenditures (3,046,245) (1,873,567) (2,766,500) (786,025) Ending Available Balance (Before ARPA) 1,847,112 2,138,826 953,026 2,651,417 One-Time ARPA (Loss of Revenue) 2,918,338 -
One-Time ARPA Expenditures (1,020,500) (225,000) Ending Available Balance (Including ARPA) 1,847,112$ 2,138,826 $ 2,850,864 $ 2,426,417 $ Operating Reserve:
Beginning Balance 3,797,650 2,764,975 $ 4,209,129 $ 4,209,129 $ Current Year Contribution 236,867 -
Interest Earned 174,612 -
Return/(Draw) - reserve (1,269,542) 1,269,542 - Ending Balance 2,764,975 4,209,129 $ 4,209,129 $ 4,209,129 $ % of Projected Operating Expenditures 18% 29% 27% 26%
FY 22-23 Proposed Budget
FY 20-21 General Fund Available Balance Calculation
FY 20-21
Audited
Available Fund
Balance
Ending fund balance, as reported in Audited Financial Statements 45,958,422 $ Non-spendable (Due from Private Purpose Trust Fund) (27,787,637) Pension Section Trust (2,237,248)
Prepaid items (10,112)
Exclude Current Year Assets other than cash (4,183,015) Negative Cash (3,600,000)
Reserve for Earthquake Insurance Deductible (500,000)
Reserve for Capital Projects (450,000)
Reserve for Planning (825,000)
Reserve for Building (21,800)
Reserve for Reusable Bags (remaining) (13,930)
Reserve for PEG Fees (70,000)
Reserve for Encumbrances/Project Carryover (86,337)
Beginning available cash balance 6,173,343 $
Reserve for Economic Uncertainty (25% target) (4,034,517) Beginning cash balance, FY 21-22 2,138,826 $
FY 22-23 Proposed Budget
General Fund - One-time
Revenues and Expenditures
FY 19-20 FY 20-21 FY 21-22 FY 22-23
Actual Actual Budget Proposed
Coronavirus Relief Fund 351,747
RPTTF Pass Through 453,944 249,003 6,000 Projected Draw on Reserve 1,269,542
Planning: LEAP Grant 150,000
900,000
1,723,486 600,750 1,056,000 -
Increase in Planning Reserve 125,826
Increase in Fiscal Neutrality Reserve 236,867
Contribution to OPEB Trust 100,000
Contribution to Pension Trust 250,000
Encumbrances and Carryovers 521,477
Settlement Payment to DOF 1,812,075 604,025 604,000 604,025 Return of Unused Reserve 1,269,542
Planning: LEAP Grant 150,000
CAD/RMS System 198,000
Interfund Loan to LLAD 850,000
DP #22-1: Police Overhire 65,000
DP #22-2: One-time Retention Bonus 102,000
ADP #22-1: Sycamore Ave Mural Restoration 20,000
FBDP #22-1: Reserve for Restricted Planning Funds 107,000 FBDP #22-2: Contribution to IRS Section 115 Pension Trust 500,00 0 FBDP #22-4: Utility User Tax Renewal 40,000
BR #22-1: Special Event 175,000
BR #22-3: Repair the Community Pool Diving Board 12,000 BR #22-4: Corp Yard Landscaping 62,000
BR #22-5: Add Flock Cameras 2,500
BR #22-6: Add UUT Renewal 20,000
BR #22-7: Village Parkway Traffic Calming 100,000
BR #22-8: Elminate Contribution to Vehicle Replacement Fund (241 ,000) Employee Labor Agreements (3% Retention Bonus) 160,000
Village Parkway Traffic Calming (CIP) 22,000
3,046,245 1,873,567 2,766,500 786,025
Release Reserve for ROPS approval of RPTTF for
Emmerich and Montoya Lease