|
2019-20 OPERATING BUDGET-MID YEAR ATTACHMENT 2
<br /> ESTIMATED CHANGES IN FUND BALANCE
<br /> 3EGINN NG(1) NET NET NET EST.ENDING
<br /> FUND BALANCE BUDGET RECOMMENDED BUDGET RECOMMENDED BUDGET RECOMMENDED FUND BALANCE
<br /> June 30,2019 REVENUES REVENUES TRANSFERS TRANSFERS EXPENDITURES EXPENDITURES June 30,2020
<br /> GENERAL FUND 5 27,829,628 $ 127,596,158 $ 2,294,460 $ (6,101,355) $ - $ (120,735,276) $ 1,686,463 $ 32,570,078 (2)
<br /> ENTERPRISE FUNDS
<br /> Cemetery Operations 151,382 190,18050,000 -
<br /> -
<br /> (243,037) (9,688) 138,837
<br /> Golf Course Operations 0 4,023,297 - (213,169) - (3.810,128) - -
<br /> Water&Recycled Water O&M 14,717,104 29,927,741 65,000 (3.723,129) - (28.140,530) (5,783) 12,840,403
<br /> Sewer Operations and Maintenance 7,471,734 15,507,500 - (359,000) - (14,895,273) 213,955 7,938,915
<br /> Storm Drain 320,613 724,440 330,000 - (1,128,169) 14,999 261.883
<br /> Senior Transportation 213 516 449,942 (1,049) 209,731 - (674,102) 86,957 284,995
<br /> Enterprise Funds 22,874,349 50,823,100 63,951 (3,705,567) - (48,891,240) 300,440 21,465,033
<br /> INTERNAL SERVICE FUNDS
<br /> Employee Benefit Fund (85,286) 754,909
<br /> (697,909) (28,286)
<br /> Workers Compensation Fund (3,051,084) 1,080,000 - - - (1,590,000) (279,000) (3,840,084) (3)
<br /> Public Art Acquisition Fund 144,698 1,000 - - - (38,000) (1,500) 106,198
<br /> Vehicle Replacement Fund 4,122,707 1,025,000 - - (643,280) (424,614) 4,079,813
<br /> Police Vehicle Replacement Fund 2,682,587 509,000 - 677,680
<br /> ( ) (35,782) 2,478,125
<br /> Pleas Fire Apparatus Replacement Fund 1,883,881 754,00070,100- -
<br /> ( ) (880,200) 1,687,581
<br /> Equipment Replacement Fund 2,069,403 501,000 - - - (446,200) (284,350) 1,839,853
<br /> Facilities Renovation Fund 5,587,460 1,030,000 (200,000) (914,445 -
<br /> (1,495,238) (6,200) 4,001,577
<br /> IT Replacement Fund 1,384,603 264,000 - - - (770,551) - 878,052
<br /> Golf Replacement Fund 555,688 - - 201,165 - (346,250) - 410,603
<br /> Park&Median Renovation Fund 4,844,467 540,000 (1,136,311) (13,689) (1,577,000) - 2,557,467
<br /> Street Light Replacement Fund 1,804,945 263,000 (200,000) (220,000) - 1,647,945
<br /> Traffic Signal Replacement Fund 643,106 256,000 - - (350,000) - 549,106
<br /> PERS Rate Stabilization Fund - - - - - _ - _
<br /> Retirees Medical Reserve Fund 21,357,731 5,173,061 - (88,000) - (4,494,000) - 21,948,792
<br /> Self-Insurance Retention Fund 4,304,615 1,180,000 - - - (1,800,000) (300.000) 3,384,615
<br /> City Enhancement Fund 203,753 - 200,000 - - 1200,000) 203,753
<br /> Internal Service Funds 48,453,273 13,330,970 - (2,237,591) (13,689) (15,416,208) (2,211,646) 41,905,109
<br /> SPECIAL REVENUE FUNDS
<br /> D.A.R.E. 18,123 1,200 - - -
<br /> (6,000) 13,323
<br /> Asset Forfeiture 54,026 500 - - - (7,000) - 47,526
<br /> Asset Forfeiture-Federal 8,232 3,500 - - - - - 11,732
<br /> Downtown Parking In-Lieu 691,410 19,500 - - - - - 710,910
<br /> Recycling&Waste Management 668,948 233,500 - - - (336,000) - 566,448
<br /> Miscellaneous Donations 400,598 4,700
<br /> (2,000) (6,500) 396,798
<br /> Bernal Donations 49,774 204,000 - - - - - 253,774
<br /> HA.P.P.Y.Public Art Donations 42,101 40,000 - - - (40,000) - 42,101
<br /> Recycling&Waste Management Import Mi 304,791 - - - (120,000) - 184,791
<br /> Operating Grants 181,891 73,000 - - - (75,000) (5,223) 174,668
<br /> Law Enforcement 363,032 1,500 - - - - - 364,532
<br /> Used Oil Grant - - - _ - - _ -
<br /> Community Access T V 1,338,069 259,000 - - - (344,684) - 1,252,385
<br /> Downtown Economic Development Loan 28,294 200 -
<br /> _ 28,494
<br /> Lower Income Housing10,006,989 2,142,818 (334,242) (60,752) 11,754,813- -
<br /> Community Development Block Grant 240,438 272,697 - - - (144,676) (4,988) 363,472
<br /> H.O.M.E. Program 34,827 531,416 -
<br /> (42,754) (499) 522,991
<br /> Abandoned Vehicle 114,403 31,000 - - - (30,000) - 115,403
<br /> H.B.P.O.A.Maintenance District - 100,000 - - - (100,000) - -
<br /> Urban Forestry 306,549 11,000 - (25.000) - (37,500) - 255,049
<br /> Recycling&Waste Management 91,783 9,642 - - - (4,736) - 96,689
<br /> Laurel Creek Geologic Hazard District 895,821 58,639 - - - (11,478) - 942,982
<br /> Moller Geologic Hazard Dist 130,124 13,517 - - - (8,036) - 135,605
<br /> Oak Tree Farm Geologic Hazard Dist 101,905 14,424 - - (7,844) - 108,485
<br /> Ponderosa Landscape District 87,664 16,021 - - - (15,580) (4,000) 84,106
<br /> Windsor Landscape District (7,036) 23,910 - - - (24,510) - (7,636)
<br /> Bonde Landscape District 964 26,100 - -
<br /> (24,470) 2,594
<br /> Moller Ranch Landscape District 272,800 58,213 - - - (55,450) (30,000) 245,563
<br /> Oak Tree Farm Landscape Dist 56,089 19,862 - - - (18,735) - 57,216
<br /> North Pleasanton Improvements District 1,003,497 23,034 - - - (23,500) 1,003,031
<br /> Special Revenue Funds 17,486,106 4,192,893 - (25.000) - (1,814,194) (111,961) 19,727,845
<br /> OTHER FUNDS
<br /> PTCWD 113 Trust Fund 110,988 6,125
<br /> (40,780) 376,333
<br /> Other Funds 410.988 6,125 - - - (40,780) - 376,333
<br /> TOTAL-ALL FUNDS $ 117,054,345 $ 195,949,246 $ 2,358,411 $ (12,069,513) $ (13,689) $ (186,897,698) $ (336,704) $ 116,044,399
<br /> (1) Beginning Fund Balance amounts exclude GA58 31 adjustments,pension liabilities,and long term debt liabilities.
<br /> (2) Estimated Fund Balance includes pending R&R allocation of$980,923&CIP transfer of$1,000,000.
<br /> (3)The negative fund balance reflects the recording of the estimated future liability regarding outstanding workers compensation claims
<br />
|