14 - Laserfiche WebLink

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