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