|
2018-19 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,2018 REVENUES REVENUES TRANSFERS TRANSFERS EXPENDITURES EXPENDITURES June 30,2019
<br /> GENERAL FUND $ 27,982,988 $ 121,912,266 $ 831,390 $ (7,134,250) $ (2,029,497) $ (114,778,016) $ 1,198,107 $ 27,982,987
<br /> ENTERPRISE FUNDS
<br /> Cemetery Operations 200,431 213,180 (86,880) 45,000 - (476,246) (6,831) (111,346)
<br /> Golf Course Operations 1,126 4,141,354 - (289,203) (963) (3,824,958) - 27,356
<br /> Water&Recycled Water O&M 11,596,506 28,730,441 906,300 (1,432,000) - (25,736,165) 261,437 14,326,518
<br /> Sewer Operations and Maintenance 6,846,889 14,909,500 20,000 (1,101,700) - (13,307,089) 245,713 7,613,313
<br /> Storm Drain 405,806 689,440 2,500 322,000 - (1,224,592) (39,090) 156,064
<br /> Senior Transportation 288,574 552,379 21,285 387,238 - (761,407) 28,442 516,511
<br /> Enterprise Funds 19,339,332 49,236,294 863,205 (2,068,665) (963) (45,330,457) 489,672 22,528,417
<br /> INTERNAL SERVICE FUNDS
<br /> Employee Benefit Fund (369,755) 1,749,094 50,000 - - (784,073) - 645,266
<br /> Workers Compensation Fund (2,263,766) 1,040,000 30,000 - - (1,340,000) (350,000) (2,883,766) (2)
<br /> LPFD Workers Comp Fund (2,387,723) 1,528,000 (8,000) - - (1,930,000) - (2,797,723) (2)
<br /> Public Art Acquisition Fund 174,462 51,000 500 - - (101,000) - 124,962
<br /> Vehicle Replacement Fund 3,781,737 608,385 20,000 - - (672,700) (868,000) 2,869,422
<br /> Police Vehicle Replacement Fund 2,180,185 560,968 15,000 - - (604,000) (74,500) 2,077,653
<br /> LPFD Replacement Fund 336,996 82,000 2,200 - - (94,000) - 327,196
<br /> Pleas Fire Apparatus Replacement Fund 1,148,401 268,998 800 - - (460,000) (345,010) 613,189
<br /> Equipment Replacement Fund 1,911,272 353,217 19,000 - - (737,500) 228,000 1,773,989
<br /> Facilities Renovation Fund 4,433,233 1,753,359 15,000 - - (908,368) (500,000) 4,793,224
<br /> IT Replacement Fund 1,187,110 459,653 - - - (602,830) (4,529) 1,039,404
<br /> Golf Replacement Fund 361,946 - 2,500 202,000 - (113,300) - 453,146
<br /> Park&Median Renovation Fund 5,674,471 1,062,400 35,000 - - (1,905,000) (229,061) 4,637,810
<br /> Street Light Replacement Fund 1,565,916 58,324 7,000 - - (200,000) - 1,431,240
<br /> Traffic Signal Replacement Fund 738,379 279,325 2,000 - - (350,000) - 669,704
<br /> PERS Rate Stabilization Fund 2,005,818 - - - - - - 2,005,818
<br /> Retirees Medical Reserve Fund 21,357,731 5,258,538 (120,000) (65,000) - (5,137,000) - 21,294,269
<br /> LPFD Retirees Medical Reserve Fund 615,160 1,736,000 - - - (1,943,000) - 408,160
<br /> Self-Insurance Retention Fund 4,391,231 1,155,000 - - - (1,750,000) - 3,796,231
<br /> City Enhancement Fund 200,000 - - - - - - 200,000
<br /> Internal Service Funds 47,042,805 18,004,261 71,000 137,000 - (19,632,771) (2,143,100) 43,479,195
<br /> SPECIAL REVENUE FUNDS
<br /> D.A.R.E. 17,693 1,200 - - - (6,000) - 12,893
<br /> Asset Forfeiture 37,783 500 - - - - (12,500) 25,783
<br /> Asset Forfeiture-Federal 15,260 3,500 - - - (6,000) (1,000) 11,760
<br /> Downtown Parking In-Lieu 664,176 19,500 - - - - - 683,676
<br /> Recycling&Waste Management 474,144 233,500 - - - (277,000) - 430,644
<br /> Miscellaneous Donations 400,081 4,700 - - - (2,000) - 402,781
<br /> Bernal Donations 943 204,000 - - - - - 204,943
<br /> H.A.P.P.Y.Public Art Donations 20,764 40,000 - - - (40,000) - 20,764
<br /> Recycling&Waste Management Import Mit 306,672 - - - - (60,000) - 246,672
<br /> Operating Grants 198,464 54,000 - - - (54,000) - 198,464
<br /> Law Enforcement 281,340 1,500 2,500 - - - - 285,340
<br /> Used Oil Grant - - - - - - - -
<br /> Community Access T V 1,247,746 259,000 6,000 - - (214,468) - 1,298,278
<br /> Downtown Economic Development Loan 27,773 200 160 - - - - 28,133
<br /> Lower Income Housing 9,581,722 2,142,818 5,000 - - (1,090,549) (11,305) 10,627,686
<br /> Community Development Block Grant - 272,697 - - - (177,576) (70,808) 24,312
<br /> H.O.M.E. Program - 531,416 380 - - (531,416) (380) -
<br /> Abandoned Vehicle 111,963 31,000 800 - - (30,000) - 113,763
<br /> H.B.P.O.A.Maintenance District - 100,000 - - - (100,000) - -
<br /> Urban Forestry 294,785 11,000 3,500 (20,000) - (36,500) - 252,785
<br /> Recycling&Waste Management 84,767 8,822 550 - - (32,111) - 62,028
<br /> Laurel Creek Geologic Hazard District 842,573 54,639 4,000 - - (89,428) - 811,784
<br /> Moller Geologic Hazard Dist 122,816 12,534 900 - - (50,436) - 85,814
<br /> Oak Tree Farm Geologic Hazard Dist 93,829 13,558 800 - - (61,344) - 46,843
<br /> Ponderosa Landscape District 99,020 16,021 600 - - (22,650) - 92,991
<br /> Windsor Landscape District (12,387) 23,910 (50) - - (24,465) - (12,992)
<br /> Bonde Landscape District (5,811) 26,100 - - - (27,150) - (6,861)
<br /> Moller Ranch Landscape District 261,435 58,213 1,900 - - (51,679) - 269,869
<br /> Oak Tree Farm Landscape Dist 45,577 19,862 300 - - (18,850) - 46,889
<br /> North Pleasanton Improvements District 976,496 23,034 5,500 - - (23,500) - 981,530
<br /> Special Revenue Funds 16,189,623 4,167,224 32,840 (20,000) - (3,027,122) (95,993) 17,246,571
<br /> OTHER FUNDS
<br /> PTCWD#3 Trust Fund 418,300 6,125 - - - (40,780) - 383,645
<br /> Other Funds 418,300 6,125 - - (40,780) - 383,645
<br /> TOTAL-ALL FUNDS $ 110,973,048 5 193,326,170 $ 1,798,435 $ (9,085,915) $ (2,030,460) $ (182,809,147) $ (551,315) $ 111,620,816
<br /> (1) Beginning Fund Balance amounts exclude GASB 31 adjustments,pension liabilities,and long term debt liabilities.
<br /> (2) The negative fund balance reflects the recording of the estimated future liability regarding outstanding workers compensation claims.
<br />
|