|
2020-21 OPERATING BUDGET-MIDYEAR EXHIBIT A
<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 /> lune 30,2020 REVENUES REVENUES TRANSFERS TRANSFERS EXPENDITURES EXPENDITURES June 30,2021
<br /> GENERAL FUND $ 31,819,420 $ 131,011,958 5 (9,071,943) $ (8,590,565) 2,147,025 5 (121,683,240) $ 4,956,766 $ 30,589,420 (2)
<br /> RAINY DAY FUND 3,545,578 5,000,000 (1,147,025) 7,398,553
<br /> ENTERPRISE FUNDS
<br /> Cemetery Operations 177,444 243,500 - 50,000 - 17,612 (256,905) 231,651
<br /> Golf Course Operations (0) 4,178,466 (260,000) (240,553) (15,000) (3,934,913) 272,000 (0)
<br /> Water&Recycled Water O&M 13,291,359 31,747,241 • (3,476,129) (30,143,694) 5,674 11,424,451
<br /> Sewer Operations and Maintenance 9,028,133 15,897,500 (856,000) - (15,168,903) (40,535) 8,860,196
<br /> Storm Drain (79,219) 735,440330,000 - (1,335,403) 61,292 (287,890)
<br /> Senior Transportation 227,991 493,013 30,713 216,717 - (706,273) 117,638 379,800
<br /> Enterprise Funds 22,645,709 53,295,160 (229,287) (3,975,965) (15,000) (51,271,575) 159,164 20,608,206
<br /> INTERNAL SERVICE FUNDS
<br /> Employee Benefit Fund (119,033) 759,909 - (697,909) (57,033)
<br /> Workers Compensation Fund (4,352,437) 1,077,000 • - (1,869,000) - (5,144,437) (3)
<br /> Public Art Acquisition Fund 78,823 2,000 - . - (39,500) - 41,323
<br /> Vehicle Replacement Fund 4,365,580 562,000 (200,000) - - (1,067,894) - 3,659,686
<br /> Police Vehicle Replacement Fund 3,017,060 291,000 (100,000) - (713,462) - 2,494,598
<br /> Pleas Fre Apparatus Replacement Fund 1,904,582 392,000 (150,000) . . (40,250) - 2,106,332
<br /> Equipment Replacement Fund 2,497,276 282,000 (100,000) - - (730,550) 1,948,726
<br /> Facilities Renovation Fund 5,165,729 472,000 (160,000) (1,729,136) (1,501,438) 2,247,155
<br /> IT Replacement Fund 1,077,001 147,000 (50,000) - - (770,551) - 403,450
<br /> Golf Replacement Fund 348,317 8,000 •
<br /> 208,773 15,000 (247,300) 332,790
<br /> Park&Median Renovation Fund 3,072,431 325,000 (100,000) (755,000) - (1,457,793) 1,084,638
<br /> Street Light Replacement Fund 1,884,152 152,000 (50,000) - - (220,000) 1,766,152
<br /> Traffic Signal Replacement Fund 701,520 136,000 (50,000) - - (350,000) - 437,520
<br /> PARS Section 115 Fund 22,239,402 - - - - . - 22,239,402
<br /> Retirees Medical Reserve Fund 510,100 5,183,325 (91,000) - (4,551,000) - 1,051,425
<br /> Self-Insurance Retention Fund 3,877,854 1,185,000 . - - (2,387,585) - 2,675,269
<br /> City Enhancement Fund 178,718 103,000 (40,000) - - (200,000) - 41,718
<br /> Internal Service Funds 46,447,076 11,077,234 (1,000,000) (2,366,363) 15,000 (16,844,232) - 37,328,715
<br /> SPECIAL REVENUE FUNDS
<br /> D.A.R.E- 18,527 1,200 - (6,000) - 13,727
<br /> Asset Forfeiture 99,371 1,000 - (7,000) - 93,371
<br /> Asset Forfeiture-Federal 10,173 3,500 - - - - 13,673
<br /> Downtown Parking In-Lieu 707,024 23,500 - - - - 730,524
<br /> Recycling&Waste Management 737,892 237,000 - - - (224,232) (32,463) 718,197
<br /> Miscellaneous Donations 414,776 1,300 - - - (8,500) - 407,576
<br /> Bernal Donations 27,203 200,800 - - - - 228,003
<br /> H.A.P.P.Y.Public Art Donations 63,382 40,600 - - - (40,000) - 63,982
<br /> CASB FEE 33,155 500 - - - 33,655
<br /> Recycling&Waste Management Import Mi 285,716 5,500 - - - (90,000) - 201,216
<br /> Operating Grants 139,261 54,000 - - - (62,192) - 131,069
<br /> Law Enforcement 545,566 6,000 - - - 551,566
<br /> Used Oil Grant - - - - . -
<br /> Community Access T V 1,448,363 273,000 - - - (343,561) - 1,377,802
<br /> Downtown Economic Development Loan 28,933 500 - - - . 29,433
<br /> Lower Income Housing 10,222,323 2,182,818 - - - (1,123,092) (1,120,725) 10,161,325
<br /> Community Development Block Grant - 602,127 655,225 - (602,127) (655,226) (0)
<br /> H.O.M.E. Program - 200,604 372 - - (200,604) (372)
<br /> Abandoned Vehicle 117,317 32,000 - - - (30,000) - 119,317
<br /> H.B.P.O.A.Maintenance District . 100,000 - - - (100.x) -
<br /> Urban Forestry 357,992 16,500 - (25,000) - (37,500) - 311,992
<br /> Recycling&Waste Management 99,381 9,907 - - (4,736) - 104,552
<br /> Laurel Creek Geologic Hazard District 952,259 59,639 - (11,478) 1,000,420
<br /> Moller Geologic Hazard Dist 137,960 13,814 - - (8,036) - 143,738
<br /> Oak Tree Farm Geologic Hazard Dist 110,725 14,776 - - - (7,844) 117,657
<br /> Ponderosa landscape District 88,219 16,021 - (19,580) 84,660
<br /> Windsor Landscape District (13,908) 23,910 - (24,510) - (14,508)
<br /> Bonde Landscape District 1,795 26,100 - - - (24,470) - 3,425
<br /> Moller Ranch Landscape District 257,403 58,213 . - - (85,450) - 230,166
<br /> Oak Tree Farm Landscape Dist 63,377 19,862 - - ' (18,735) - 64,504
<br /> North Pleasanton Improvements District 1,034,657 23,034 - - - (23,500) - 1,034,191
<br /> Special Revenue Funds 17,988,843 4,247,725 655,597 (25,000) - (3,103,146) (1,808,785) 17,955,233
<br /> OTHER FUNDS
<br /> PTCWD#3 Trust Fund 395,860 8,925 - - - (40,780) 364,005
<br /> Other Funds 395,860 8,925 - - - (40,780) - 364,005
<br /> TOTAL-ALL FUNDS $ 119,296,908 $ 199,641,002 $ (9,645,633) $ (14,957,893) $ 2,147,025 $ (192,942,973) $ 3,307,144 $ 106,845,580
<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 />
|