|
2021-22 OPERATING BUDGET-MID YEAR ATTACHMENT 2
<br /> ESTIMATED CHANGES IN FUND BALANCE
<br /> BEGINNING(1) NET NET NET EST.ENDING
<br /> FUND BALANCE BUDGET RECOMMENDED BUDGET RECOMMENDED BUDGET RECOMMENDED FUND BALANCE
<br /> June 30,2021 REVENUES REVENUES TRANSFERS TRANSFERS EXPENDITURES EXPENDITURES June 30,2022
<br /> GENERAL FUND $ 34,389,421 $ 131,641,838 $ 4,848,000 $ (6,575,498) $ (5,362,549) $ (125,466,340) $ 313,699 $ 33,788,571 (2)
<br /> RAINY DAY FUND 7,398,553 - - 2,734,757 - - - 10,133,310
<br /> ENTERPRISE FUNDS
<br /> Transit 294,091 345,387 56,113 171,893 - (640,781) (138,208) 88,495
<br /> Cemetery 708,374 295,500 25,000 50,000 - (354,656) (3,076) 721,142
<br /> Golf 136,374 4,164,886 400,006 (208,094) - (3,802,773) (192,000) 498,399
<br /> Storm Drain (300,753) 740,000 - 625,000 - (1,346,085) (17,250) (299,088)
<br /> Water/Recycled Water 13,345,529 33,739,541 (3,159,000) (5,109,334) - (30,464,139) 1,390,666 9,743,263
<br /> Sewer 8,860,195 16,327,500 (800,000) (1,069,953) - (16,357,425) 122,130 7,082,447
<br /> Enterprise Funds 23,043,810 55,612,814 (3,477,881) (5,540,488) - (52,965,858) 1,162,261 17,834,658
<br /> INTERNAL SERVICE FUNDS
<br /> Employee Benefits 8,322 774,909 (20,000) - - (697,909) - 65,322
<br /> Workers Compensation Fund (3,949,326) 1,545,500 - - - (2,130,070) - (4,533,896) (3)
<br /> Public Art Acquisition Fund 179,777 52,000 - - (22,000) 12,000 221,777
<br /> Vehicle Replacement Fund 4,073,956 330,000 (20,000) - - (577,500) - 3,806,456
<br /> Police Vehicle Replacement Fund 2,887,292 225,000 (10,000) - - (835,972) (83,528) 2,182,792
<br /> Pleas Fire Apparatus Replacement Fund 2,423,025 227,000 - - - (103,500) (47,000) 2,499,525
<br /> Equipment Replacement Fund 2,848,748 290,000 (5,000) - - (118,000) (113,000) 2,902,748
<br /> Facilities Renovation Fund 3,714,053 350,000 (30,000) - - (500,000) (126,000) 3,408,053
<br /> IT Replacement Fund 786,710 197,000 (7,000) - - (200,000) (100,000) 676,710
<br /> Golf Replacement Fund 637,691 6,000 - 208,094 - (210,000) - 641,785
<br /> Park&Median Renovation Fund 1,725,457 590,000 (50,000) (755,000) - (937,280) (37,721) 535,457
<br /> Street Light Replacement Fund 2,038,027 185,000 (10,000) - - (220,000) - 1,993,027
<br /> Traffic Signal Replacement Fund 518,803 412,000 (3,000) - - (218,760) (131,240) 577,803
<br /> PARS Section 115 Fund 29,362,086 - - - - - - 29,362,086
<br /> Retirees Medical Reserve Fund 0 4,270,000 - (91,000) - (4,287,000) 108,000 0
<br /> Self-Insurance Retention Fund 3,184,792 1,385,000 - - - (2,500,000) - 2,069,792
<br /> City Enhancement Fund 239,946 101,500 - - - (100,000) (30,000) 211,446
<br /> Internal Service Funds 50,679,360 10,940,909 (155,000) (637,906) - (13,657,991) (548,489) 46,620,884
<br /> SPECIAL REVENUE FUNDS
<br /> D.A.R.E. 18,756 1,200 - - - (5,000) - 14,956
<br /> Asset Forfeiture 17,731 100 - - - (7,000) - 10,831
<br /> Asset Forfeiture-Federal 10,173 3,500 - - - - - 13,673
<br /> Downtown Parking In-Lieu 715,736 23,500 - - - - - 739,236
<br /> Recycling&Waste Management 739,511 239,000 - - - (527,468) 14 451,057
<br /> Miscellaneous Donations 414,961 1,000 - - - (8,500) - 407,461
<br /> Bernal Donations 86 200,800 (195,800) - - - - 5,086
<br /> H.A.P.P.Y.Public Art Donations 75,348 41,000 (40,000) - - (40,000) - 36,348
<br /> CASB FEE 56,492 500 31,000 - - - (8,900) 79,092
<br /> Recycling&Waste Management Import Mi 289,244 5,500 - - - (172,157) 9 122,596
<br /> Operating Grants 139,859 54,000 - - - (63,003) - 130,856
<br /> Law Enforcement 722,240 8,000 190,000 - - - - 920,240
<br /> Used Oil Grant - - 16,944 - - - (16,944) -
<br /> Community Access T V 1,633,112 275,000 - - - (193,561) - 1,714,551
<br /> Downtown Economic Development Loan 29,290 500 - - - - - 29,790
<br /> Lower Income Housing 11,117,530 3,911,285 (60,000) - - (991,044) (5,874) 13,971,897
<br /> Community Development Block Grant - 418,976 285,298 - - (418,053) (286,221) -
<br /> H.O.M.E. Program - 201,187 499 - - (201,095) (591) -
<br /> Abandoned Vehicle 119,168 32,500 - - - (30,000) - 121,668
<br /> H.B.P.O.A.Maintenance District140,000 - - - (140,000) -
<br /> -
<br /> -
<br /> Urban Forestry 243,026 17,500 87,000 (25,000) - (239,500) - 83,026
<br /> Recycling&Waste Management 105,313 10,077 - - - (7,198) - 108,192
<br /> Laurel Creek Geologic Hazard District 1,004,849 60,556 - - - (39,638) - 1,025,767
<br /> Moller Geologic Hazard Dist 144,309 15,535 - - - (10,622) - 149,222
<br /> Oak Tree Farm Geologic Hazard Dist 119,491 14,776 - - - (11,524) - 122,743
<br /> Ponderosa Landscape District 88,620 16,021 - - - (19,580) (1) 85,061
<br /> Windsor Landscape District (17,562) 23,910 - - - (25,560) - (19,212)
<br /> Bonde Landscape District 7,353 26,100 - - - (24,470) - 8,983
<br /> Moller Ranch Landscape District 256,171 58,213 - - - (85,450) - 228,934
<br /> Oak Tree Farm Landscape Dist 72,581 19,862 - - - (41,880) - 50,563
<br /> North Pleasanton Improvements District 1,051,942 29,534 - - - (23,500) - 1,057,976
<br /> Business Support 1,745,115 - 25,000 - - - (25,000) 1,745,115
<br /> Special Revenue Funds 20,920,445 5,849,632 339,941 (25,000) - (3,325,802) (343,508) 23,415,708
<br /> OTHER FUNDS
<br /> PTCWD#3 Trust Fund 380,297 8,925 - - - (40,780) - 348,442
<br /> Other Funds 380,297 8,925 - - - (40,780) - 348,442
<br /> TOTAL-ALL FUNDS $ 136,811,886 $ 204,054,118 $ 1,555,060 $ (10,044,135) $ (5,362,549) $ (195,456,771) $ 583,964 $ 132,141,573
<br /> (1) Beginning Fund Balance amounts exclude GASB 31 adjustments,pension liabilities,and long term debt liabilities.
<br /> (2) Estimated Fund Balance excludes$800,000 for Crisis Response Program
<br /> (3) The negative fund balance reflects the recording of the estimated future liability regarding outstanding workers compensation claims.
<br />
|