Mid-YearBudget Adjustment Request
Proposed 02/01/2022
Beginning Fund Balance Reconciliation - Budget Basis
Actual Ending Fund Balance, June 30 2021 $ 9,218,558
Estimated Beginning Fund Balance, June 30, 2021 6,844,280 Actual Fund Balance in Excess of Estimated Actual $ 2,374,278 (a) Summary of Adjustments
Total Decrease for Transfers Out for Streets $ 1,744,000 Total UAL ADP Expenditures $ 6,000,000
Total One Time Furnace Replacement $ 10,000
Fund Dept Account Project Account Name Total Budget
Encumbered/Exp
ended Bal. Available Budget
Requested Budget
Reclassification
Post Adjustment
Budget Available
Budget Reductions:
101 00 81000 000000 Trasnsfers Out $ 3,758,340 $ (536,558) $ 3,221,782 $ (1,744,000) $ 1,477,782 Note: $1,544,000 for west-side street project and $200,000 for 116/West Cotati streets project both now funded through Bond Funding.
Budget Additions.
101 11 70450 UNFUND PERS Unfunded Liability 50,960 (50,960) - 289,170 289,170 101 12 70450 UNFUND PERS Unfunded Liability 25,980 (25,980) - 130,410 130,410 101 17 70450 UNFUND PERS Unfunded Liability 57,950 (57,950) - 328,860 328,860 101 18 70450 UNFUND PERS Unfunded Liability 8,990 (8,990) - 51,030 51,030 101 19 70450 UNFUND PERS Unfunded Liability 22,980 (22,980) - 141,750 141,750 101 20 70450 UNFUND PERS Unfunded Liability 4,000 (4,000) - 22,680 22,680 101 21 70450 UNFUND PERS Unfunded Liability 8,990 (8,990) - 51,030 51,030 101 22 70450 UNFUND PERS Unfunded Liability 18,980 (18,980) - 107,730 107,730 101 23 70450 UNFUND PERS Unfunded Liability 494,260 (494,260) - 3,505,200 3,505,200 101 24 70450 UNFUND PERS Unfunded Liability 39,970 (39,970) - 226,800 226,800 301 00 70450 UNFUND PERS Unfunded Liability 15,990 (15,990) - 90,720 90,720 401 00 38110 000000 Due To General Fund - - - 538,650 538,650 404 00 38110 000000 Due to General Fund - - - 515,970 515,970 Note: $6M allocation of the UAL ADP. 6,000,000 6,000,000 101 00 16000 000000 Due from Enterprise Funds - 0 - 1,054,620 1,054,620 Note: To record the balance due from Water and WasteWater funds to the General Fund for their Allocation of the ADP payment to CalPERS. 101 21 80570 000000 R&M General 12000 (6,549) 5,451 10,000 15,451 Note: To record additional one time expenditure needed to replace the furnace at City Hall.
Total Net Change for General Fund $ 3,120,660 (b)
Budgeted Ending Fund Balance as of June 30, 2022 $ 5,577,736 Actual Fund Balance in Excess of Estimated Actual (a) $ 2,374,278 Net Total Adjustments to Budget Uses: (b) $ (3,120,660) Estimated Ending Fund Balance as of June 30, 2021 $ 4,831,354 Required Reserve - 25% of Operating Expenditures $ 2,131,107 Excess Over Required Reserve $ 2,700,247