15 - Laserfiche WebLink

2016-17 OPERATING BUDGET ATTACHMENT 2 ESTIMATED CHANGES IN FUND BALANCE(1) BEGINNING EST.ENDING GASB31 ACTUAL ACTUAL ACTUAL ACTUAL FUND BALANCE BUDGET BUDGET BUDGET FUND BALANCE UNAUDITED UNAUDITED UNAUDITED UNAUDITED June 30,2016 REVENUES TRANSFERS EXPENDITURES June 30,2017 REVENUES TRANSFERS EXPENDITURES FUND BALANCE GENERAL FUND $20,583,974 $112,076,453 ($11,816,736) ($104,775,323) $16,068,368 ($161,094) $115,734,082 ($12,032,547) ($101,698,716) $22,586,792 ENTERPRISE FUNDS Cemetery Operations 574,417 26,754 44,700 (866,247) (220,376) (1,866) 123,656 44,700 (277,684) 465,089 Golf Course Operations 115,390 4,169,522 (549,301) (3,620,221) 115,390 (1,775) 3,681,341 (323,939) (3,401,120) 71,672 Water Operations and Maintenance 8,973,514 29,040,700 (1,621,022) (23,402,833) 12,990,359 (53,980) 25,257,413 (2,038,157) (23,288,531) 8,904,239 Sewer Operations and Maintenance 5,299,511 14,137,000 (1,170,851) (13,112,559) 5,153,101 (40,836) 14,836,708 (1,187,270) (12,459,615) 6,489,335 Storm Drain 1,267,328 691,520 67,700 (1,031,506) 995,042 (4,627) 880,779 67,700 (1,294,046) 921,761 Senior Transportation 183,993 410,718 457,737 (791,340) 261,108 (1,177) 416,555 339,725 (633,647) 306,626 Enterprise Funds 16,414,154 48,476,214 (2,771,037) (42,824,707) 19,294,624 (104,262) 45,196,453 (3,097,242) (41,354,644) 17,158,722 INTERNAL SERVICE FUNDS Employee Benefit Fund (2,826,729) 929,106 - - (1,897,623) (19,725) 1,061,863 - (140,257) (1,905,123) (2) Workers Compensation Fund 488,275 2,080,604 - (1,235,000) 1,333,880 (20,407) 2,114,637 - (4,116,233) (1,513,320) (3) LPFD Workers Comp Fund (2,142,160) 1,210,000 - (1,953,000) (2,885,160) (4,172) 617,144 - (956,005) (2,481,021) (3) Public Art Acquisition Fund 220,048 59,900 - (114,400) 165,548 (866) 59,553 - (103,560) 176,041 Vehicle Replacement Fund 3,012,830 518,308 - (472,700) 3,058,438 (14,980) 616,556 - (274,117) 3,355,269 Police Vehicle Replacement Fund 1,064,432 470,465 - (109,800) 1,425,097 (5,414) 520,355 - (66,115) 1,518,672 LPFD Replacement Fund 270,234 83,000 - (75,600) 277,634 (857) 42,154 - (12,784) 299,604 Pleas Fire Apparatus Replacement Fund 1,890,641 236,448 - (1,350,000) 777,089 (6,378) 246,331 - (1,291,241) 845,732 Equipment Replacement Fund 1,611,452 372,217 - (1,658,000) 325,669 (7,593) 366,826 - (443,272) 1,535,006 Facilities Renovation Fund 4,083,601 1,143,814 - (2,318,134) 2,909,281 (8,626) 1,150,616 - (583,760) 4,650,457 IT Replacement Fund 2,167,103 457,653 - (1,317,341) 1,307,415 (8,677) 460,659 - (975,202) 1,652,560 Golf Replacement Fund 169,966 - 208,000 (269,800) 108,166 (484) 1,226 211,939 (70,178) 312,953 Park&Median Renovation Fund 5,953,384 1,062,400 - (1,633,116) 5,382,668 (28,574) 1,077,524 - (748,288) 6,282,620 Street Light Replacement Fund 1,812,974 58,324 - (488,047) 1,383,251 (8,372) 60,952 - (303,327) 1,570,599 Traffic Signal Replacement Fund 688,325 279,325 - (350,000) 617,650 (3,204) 279,256 - (240,221) 727,360 PERS Rate Stabilization Fund 1,500,000 - 4,146,319 (3,640,500) 2,005,819 - - 4,146,318 (3,640,500) 2,005,818 Retirees Medical Reserve Fund 19,289,792 6,013,000 63,890 (5,150,890) 20,215,792 (56,687) 4,918,889 215,890 (4,114,000) 20,310,571 LPFD Retirees Medical Reserve Fund 1,084,049 1,154,000 - (2,147,000) 91,049 (139) 652,196 - (913,000) 823,245 Self-Insurance Retention Fund 5,307,667 1,140,000 - (1,260,000) 5,187,667 (27,372) 1,168,822 - (1,310,041) 5,166,449 Internal Service Funds 45,645,888 17,268,564 4,418,209 (25,543,328) 41,789,333 (222,527) 15,415,558 4,574,147 (20,302,101) 45,333,492 SPECIAL REVENUE FUNDS D.A.R.E. 17,208 1,200 - (6,000) 12,408 (103) 1,771 - (1,500) 17,479 Asset Forfeiture 61,106 100 - - 61,206 (374) 636 - (27,686) 34,056 Asset Forfeiture-Federal 26,836 1,300 - (22,950) 5,186 - - - (11,576) 15,260 Downtown Parking In-Lieu 487,949 14,900 - - 502,849 (1,934) 96,242 - - 584,191 Recycling&Waste Management 386,833 204,000 - (200,000) 390,833 (2,759) 226,390 - (206,117) 407,106 Miscellaneous Donations 366,616 1,700 - (2,000) 366,316 - 96,252 - (61,765) 401,103 Bernal Donations 184,347 - - - 184,347 (1,011) 323,328 (442,506) - 65,169 H.A.P.P.Y.Public Art Donations 1,381 - - - 1,381 (136) 30,249 - (25,145) 6,484 Recycling&Waste Management Import Mi 302,498 - - (60,000) 242,498 (999) 3,052 - - 305,550 Operating Grants 104,786 34,781 - (64,781) 74,786 - 151,143 - (48,553) 207,376 Law Enforcement 178,537 146,075 - (146,075) 178,537 (1,254) 152,456 - (61,204) 269,788 Used Oil Grant 226 20,679 - (20,679) 226 - 19,381 - (19,608) - Community Access TV 899,754 244,000 - (89,035) 1,054,719 (4,329) 264,947 - (111,419) 1,053,283 Downtown Economic Development Loan 27,159 200 - - 27,359 (114) 274 - - 27,433 Lower Income Housing 13,994,665 6,050,900 (3,558,579) (10,260,203) 6,226,783 (69,461) 8,404,804 (3,558,579) (7,165,634) 11,675,256 Community Development Block Grant - 298,550 - (728,369) (429,819) - 199,603 - (199,603) - H.O.M.E. Program - 133,534 - (129,329) 4,205 - 38,786 - (38,786) - Abandoned Vehicle 252,660 32,000 - (175,000) 109,660 (1,431) 35,282 - (177,570) 110,372 H.B.P.O.A.Maintenance District - 100,000 - (100,000) - - 118,244 - (118,244) - Urban Forestry 24,001 181,950 (19,000) (35,765) 151,186 (729) 268,365 (19,000) (28,628) 244,737 Recycling&Waste Management 72,909 8,205 - (7,040) 74,074 (397) 9,430 - (3,490) 78,849 Laurel Creek Geologic Hazard District 754,033 51,639 - (39,254) 766,418 (3,990) 53,844 - (9,254) 798,623 Moller Geologic Hazard Dist 117,113 11,813 - (10,365) 118,561 (608) 12,076 - (9,815) 119,375 Oak Tree Farm Geologic Hazard Dist 81,638 12,812 - (11,273) 83,177 (412) 13,374 - (6,223) 88,789 Ponderosa Landscape District 91,075 16,021 - (16,021) 91,075 (416) 16,323 - (19,351) 88,047 Windsor Landscape District 5,253 23,910 - (19,335) 9,828 (83) 24,053 - (22,834) 6,473 Bonde Landscape District (2,498) 26,100 - (25,550) (1,948) (28) 26,016 - (21,567) 1,951 Moller Ranch Landscape District 258,655 58,213 - (101,614) 215,254 (1,466) 59,906 - (34,158) 284,403 Oak Tree Farm Landscape Dist 57,521 19,862 - (12,205) 65,178 (302) 20,193 - (35,721) 41,993 North Pleasanton Improvements District 944,680 7,000 - (3,000) 948,680 (4,853) 25,192 - (7,090) 962,782 Spedal Revenue Funds 19,696,941 7,701,444 (3,577,579) (12,285,843) 11,534,963 (97,188) 10,691,612 (4,020,085) (8,472,540) 17,895,927 OTHER FUNDS PTCWD#3 Trust Fund 437,981 5,625 - (40,780) 402,826 (2,233) 6,687 - (18,065) 426,603 Other Funds 437,981 5,625 - (40,780) 402,826 (2,233) 6,687 - (18,065) 426,603 TOTAL-ALL FUNDS $102,778,938 $185,528,300 ($13,747,143) ($185,469,981) $89,090,114 ($587,304) $187,044,391 ($14,575,727) ($171,846,067) $103,401,535 (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($1.91 million). (3)The negative fund balance reflects the recording of the estimated future liability regarding outstanding workers compensation claims.