|
2017-18 OPERATING BUDGET-MID YEAR Attachment 1
<br /> ESTIMATED CHANGES IN FUND BALANCE(1)
<br /> BEGINNING NET NET NET EST.ENDING
<br /> FUND BALANCE BUDGET RECOMMENDED BUDGET RECOMMENDED BUDGET RECOMMENDED FUND BALANCE
<br /> June 30,2017 REVENUES REVENUES TRANSFERS TRANSFERS EXPENDITURES EXPENDITURES June 30,2018
<br /> GENERAL FUND $ 22,586,792 $ 115,155,893 $ 2,807,607 $ (6,384,591) $ (721,176) $ (107,938,638) $ (1,442,120) $ 24,063,767
<br /> ENTERPRISE FUNDS
<br /> Cemetery Operations 465,089 78,790 137,390 45,000 - (319,985) (553,133) (146,849)
<br /> Golf Course Operations 71,672 4,020,731 - (280,780) - (3,713,551) - 98,072
<br /> Water&Recycled Water O&M 12,346,487 23,565,611 4,335,224 (5,579,175) 3,339,871 (25,674,271) (2,079,049) 10,254,697
<br /> Sewer Operations and Maintenance 6,489,335 14,383,000 - (1,105,700) - (13,140,304) 31,499 6,657,830
<br /> Storm Drain 921,761 689,440 2,000 322,000 (500,000) (1,075,449) 5,145 364,897
<br /> Senior Transportation 306,626 525,900 (133,720) 381,981 - (834,908) (137,517) 108,364
<br /> Enterprise Funds 20,600,970 43,263,473 4,340,894 (6,216,674) 2,839,871 (44,758,468) (2,733,055) 17,337,010
<br /> INTERNAL SERVICE FUNDS
<br /> Employee Benefit Fund (1,905,123) 1,728,175 40,000 - - (784,073) - (921,021) (1)
<br /> Workers Compensation Fund (1,513,320) 1,040,000 - - - (1,172,000) (100,000) (1,745,320) (2)
<br /> LPFD Workers Comp Fund (2,477,783) 1,527,000 - - - (1,739,500) - (2,690,283) (2)
<br /> Public Art Acquisition Fund 176,041 51,500 - - - (101,000) - 126,541
<br /> Vehicle Replacement Fund 3,355,269 527,308 57,200 - - (626,700) - 3,313,077
<br /> Police Vehicle Replacement Fund 1,518,672 474,465 3,000 - - (224,827) - 1,771,310
<br /> LPFD Replacement Fund 300,087 82,000 - - - (94,000) - 288,087
<br /> Pleas Fire Apparatus Replacement Fund 845,732 230,948 (5,000) - - (630,000) (136,002) 305,678
<br /> Equipment Replacement Fund 1,535,006 355,217 15,000 - - (613,000) - 1,292,223
<br /> Facilities Renovation Fund 4,650,457 1,163,814 (10,000) - (1,309,000) (888,636) - 3,606,635
<br /> IT Replacement Fund 1,652,560 458,653 - - - (945,200) (134,308) 1,031,705
<br /> Golf Replacement Fund 312,953 - - 202,000 (963) (113,300) (70,000) 330,690
<br /> Park&Median Renovation Fund 6,282,620 1,062,400 20,000 - (600,000) (1,420,000) (230,000) 5,115,020
<br /> Street Light Replacement Fund 1,570,599 58,324 3,000 - - (200,000) - 1,431,923
<br /> Traffic Signal Replacement Fund 727,360 279,325 - - - (350,000) - 656,685
<br /> PERS Rate Stabilization Fund 2,005,818 - - - 721,176 - - 2,726,994
<br /> Retirees Medical Reserve Fund 20,310,571 5,091,968 - (61,000) - (4,993,000) - 20,348,539
<br /> LPFD Retirees Medical Reserve Fund 826,748 1,508,000 - - - (1,881,000) - 453,748
<br /> Self-Insurance Retention Fund 5,166,449 1,150,000 - - - (1,300,000) (325,000) 4,691,449
<br /> Internal Service Funds 45,340,716 16,789,097 123,200 141,000 (1,188,787) (18,076,236) (995,310) 42,133,680
<br /> SPECIAL REVENUE FUNDS
<br /> D.A.R E 17,479 1,200 500 - - (6,000) - 13,179
<br /> Asset Forfeiture 34,056 500 3,500 - - - 38,056
<br /> Asset Forfeiture-Federal 15,260 3,500 - - - (6,000) - 12,760
<br /> Downtown Parking In-Lieu 584,191 19,000 59,000 - - - - 662,191
<br /> Recycling&Waste Management 407,106 203,500 - - - (200,000) (114,600) 296,006
<br /> Miscellaneous Donations 401,749 4,700 8,300 - - (2,000) (11,000) 401,749
<br /> Bernal Donations 65,169 203,000 - - (203,000) - - 65,169
<br /> H.A.P.P.Y.Public Art Donations 6,484 40,000 - - - (40,000) - 6,484
<br /> Recycling&Waste Management Import Mit 305,550 - 3,100 - - (60,000) - 248,650
<br /> Operating Grants 207,376 54,000 - - - (118,477) - 142,899
<br /> Law Enforcement 269,788 1,500 125,638 - - (146,075) - 250,851
<br /> Used Oil Grant - - 20,781 - - - (20,781) -
<br /> Community Access T V 1,053,283 258,000 2,000 - - (162,382) (45,618) 1,105,283
<br /> Downtown Economic Development Loan 27,433 200 100 - - - - 27,733
<br /> Lower Income Housing 11,675,256 2,869,190 511,000 - - (1,092,918) (2,751,935) 11,210,593
<br /> Community Development Block Grant - 368,922 61,750 - - (447,638) 16,966 - (0)
<br /> H.O.M.E. Program - 524,744 - - - (532,890) 1,703 (6,443)
<br /> Abandoned Vehicle 110,372 31,000 200 - - (30,000) - 111,572
<br /> H.B.P.O.A.Maintenance District - 100,000 - - - (100,000) - -
<br /> Urban Forestry 244,737 11,000 69,500 (19,000) - (17,500) (5,000) 283,737
<br /> Recycling&Waste Management 78,849 8,612 200 - - (7,075) - 80,586
<br /> Laurel Creek Geologic Hazard District 798,623 53,639 1,000 - - (39,340) - 813,922
<br /> Moller Geologic Hazard Dist 119,375 12,506 200 - - (10,400) - 121,681
<br /> Oak Tree Farm Geologic Hazard Dist 88,789 13,602 100 - - (11,308) - 91,183
<br /> Ponderosa Landscape District 88,047 16,021 300 - - (16,021) - 88,347
<br /> Windsor Landscape District 6,473 23,910 (50) - - (23,270) (13,200) (6,137)
<br /> Bonde Landscape District 1,951 26,100 - - - (25,500) - 2,551
<br /> Moller Ranch Landscape District 284,403 58,213 1,200 - - (51,679) (30,000) 262,137
<br /> Oak Tree Farm Landscape Dist 41,993 19,862 300 - - (18,850) (800) 42,505
<br /> North Pleasanton Improvements District 962,782 23,002 2,500 - - (23,500) (3,500) 961,284
<br /> Special Revenue Funds 17,896,573 4,949,423 871,119 (19,000) (203,000) (3,188,823) (2,977,765) 17,328,526
<br /> OTHER FUNDS
<br /> PTCWD#3 Trust Fund 426,603 5,925 - - - (40,780) - 391,748
<br /> Other Funds 426,603 5,925 - - - (40,780) - 391,748
<br /> TOTAL-ALL FUNDS $ 106,851,653 $ 180,163,811 $ 8,142,820 $ (12,479,265) $ 726,908 $ (174,002,946) $ (8,148,250) $ 101,254,730
<br /> (1)Budget amounts reflect proposed General Fund surplus allocations.
<br /> (2) Reduction in the Fund Balance is equal to the amount of the outstanding Police Side Fund loan paid off in July 2011($.92 million)
<br /> (3) The negative fund balance reflects the recording of the estimated future liability regarding outstanding workers compensation claims.
<br />
|