10 - Laserfiche WebLink

2014-15 OPERATING BUDGET ATTACHMENT 2 ESTIMATED CHANGES IN FUND BALANCE BEGINNING EST.ENDING ACTUAL ACTUAL ACTUAL ACTUAL FUND BALANCE BUDGET BUDGET BUDGET FUND BALANCE UNAUDITED UNAUDITED UNAUDTED UNAUDITED tune 30.2019 REVENUES TRANSFERS EXPENDITURES lune 30.2015 REVENUES TRANSFERS EXPENDITURES FUND BALANCE GENERAL FUND $ 15,041,581 $ 100,377,294 $ (3,985,330) $ (96,565,965) 5 14,867,581 $ 104,117,484 $ (3,966,798) $ (94,616,258) $ 20,576,010 ENTERPRISE FUNDS Senior Transportation - 230,071 399,412 (626,838) 2,645 245,083 386,713 (599,206) 32,590 Recycled Water - - 1,879,638 (44,831) (189,848) 1,644,959 Storm Drain 1,127,353 695,269 324,165 (1,007,698) 1,139,089 711,613 324,165 (883,898) 1,279,234 Electric Veh Charging Station 3,283 500 - - 3,783 3,066 - - 6,349 Cemetery Operations 448.457 29,381 30,000 (207,926) 299,912 60,741 30,000 (50,421) 488,777 Golf Course Operations 1,090 4,114,207 (313,163) (3,686,744) 115,390 3,621,617 (279,014) (3,228,239) 115,453 Water Operations and Maintenance 7,320,211 19,039,519 (1,745,551) (17,493,242) 7,120,937 16,822,340 (1,442,950) (14,723,080) 7,976,521 Sewer Operations and Maintenance 4,180,740 13.382,616 (1,098,900) (12,117,422) 4,347,035 13,730,592 (1,103,095) (12,120,366) 4,687,872 Enterprise Funds 13,081,134 37,491,563 (2,404,037) (35,139,870) 13,028,790 37,074,690 (2,129,011) (31,795,058) 16,231,756 INTERNAL SERVICE FUNDS Employee Benefit Fund (4,610,266) 17,722,633 - (16,874,239) (3,761,872) 19,006,464 - (18,124,518) (3,728,321) (1) LPFD Replacement Fund 267,779 82,800 - (195,700) 154,879 41,216 - (56,509) 252,486 Public Art Acquisition Fund 240,968 1,500 - (50,000) 192,468 1,443 - (2,802) 239,610 Public Art Maintenance Fund 48,346 400 - (26,000) 22,746 240 - (18,022) 30,564 Vehicle Replacement Fund 2,122,906 629,808 - (599,460) 2,153,254 633,364 - (187,303) 2,568,967 Equipment Replacement Fund 2,632,917 382,717 - (820,000) 2,195,634 382,576 - (516,728) 2,498,765 Facilities Renovation Fund 2,200,133 1,144,314 - (964,000) 2,380,447 1,148,130 - (455,711) 2,892,552 IT Replacement Fund 2,971,254 463,653 - (470,650) 2.964,257 463,826 - (753,190) 2,681,890 Pleas Fire Apparatus Replacement Fund 2,595,505 237,948 - - 2,833,453 240,430 - - 2,835.934 Police Vehicle Replacement Fund 569,134 468,965 - (549,000) 489,099 468,787 - (543,589) 494,332 Park&Median Renovation Fund 5,101,641 1,050,400 - (1,006,400) 5,145,641 1,055,022 - (965,985) 5,190,678 Street Light Replacement Fund 1,792,592 55,324 - (100,000) 1,747,916 80,557 - (101,359) 1,771,791 Traffic Signal Replacement Fund 780,033 277,325 - (400,000) 657,358 278,014 - (367,803) 690,244 Golf Replacement Fund 61,054 1,000 80,000 (135,600) 6,454 - 80,000 (139,955) 1,099 PERS Rate Stabilization Fund 1,928,584 - 9,571,416 (1,000,000) 10,500,000 - 9,571,416 (10,500,000) 1,000,000 LPFD Retirees Medical Reserve Fund 2,124,397 720,000 - (2,107,000) 737,397 506,276 - (1,059,180) 1,571,492 Workers Compensation Fund 1,304,435 1,026,000 - (1,000,000) 1,330,435 920,257 - (1,211,528) 1,013,165 Self-Insurance Retention Fund 5,729,021 895,000 - (1,080,000) 5,544,021 907,294 - (1,390,887) 5,245,429 LPFD Workers Comp Fund (1,628,228) 1,210,000 - (1,487,000) (1,905,228) 608,295 - (889,819) (1,909,752) (2) Retirees Medical Reserve Fund 25.232.280 5,636,000 (7,843,912) (4,875,000) 18,149,368 5,643,777 (7,843,912) (4,929,595) 18,102,551 Internal Service Funds 51,464,487 32,005,787 1,807,504 (33,740,049) 51,537,729 32,385,968 1,807,504 (42,214,482) 43,443,476 SPECIAL REVENUE FUNDS DARE Fund 22,400 3,800 - (5,000) 21,200 3,844 - (1,500) 24,744 Asset Forfeiture Fund 40,927 2,100 - (6,000) 37,027 1,213 - - 42,141 Downtown Parking Fund 17,829 24,500 57,500 - 99,829 14,864 67,500 - 100,192 Recycling&Waste Mgmt.Fund 797,434 202,300 - (255,000) 744,734 204,316 - (230,385) 771,366 Parks&Comm Sery Donations Fund 45,361 300 - - 45,661 31,610 - (17,954) 59,017 Miscellaneous Donations Fund 26,295 25,200 (25,000) (3,700) 22,795 6,701 - (1,384) 31,612 Youth Master Plan Fund 26,342 200 - - 26,542 159 - - 26,500 H.A.P.P.Y PUBLIC ART DONATIONS 12,614 40,200 - (40,000) 12,814 55,007 - (48,450) 19,172 MISCELLANEOUS OPERATING GRANTS - 5,093 (5,043) 50 58,223 - (58,223) - COMMUNITY ACCESS TELEVISION 472,354 236,900 - (76,000) 633,254 250,268 . (46,007) 676,615 Downtown Economic Devel Loan Fund 26,763 200 - - 26,963 161 - - 26,924 Lower Income Housing Fund 16,532,355 830,204 - (11,112,085) 6,250,474 1,446,773 - (815,394) 17,163,735 Used Oil Grant Fund 226 - - - 226 17,613 - (17,613) 226 Law Enforcement Fund 143,154 1,000 - (143,154) 1.000 128,992 - (52,666) 219,480 Lemoine Geologic Hazard District 62,154 7,949 - (6,875) 63,228 7,948 - (2,646) 67,456 Laurel Creek Geologic Hazard District 666,495 49,443 - (38,850) 677,088 50,281 - (8,237) 708,540 Ponderosa Landscape District 85,800 15,921 - (16,021) 85,700 15,970 - (11,541) 90,229 Windsor Landscape District (1,028) 23,860 - (23,920) (1,088) 23,739 - (21,045) 1,666 Moller Geologic Hazard District 102,408 11,410 - (10,199) 103,619 11,373 - (4,796) 108,985 Oak Tree Farm Geologic Hazard District 64,788 12,392 - (11,106) 66,074 12,484 - (4,704) 72,568 Bonde Landscape District 9,463 26,050 - (26,150) 9,363 26,152 - (27,382) 8,233 Moller Ranch Landscape District 240,094 57,913 - (81,979) 216,028 57,720 - (25,286) 272,529 Oak Tree Farm Landscape District 44,078 19,862 - (18,850) 45,090 19,845 - (17,333) 46,591 Community Develop Block Grant Fund - 1,558,986 - (1,558,986) 402,245 - (402,245) - HOME Program Fund - 535,270 - (535,270) - 340,295 - (340,295) - HBPOA Maintenance District Fund - 149,040 - (149,040) - 115,395 - (115,395) - AbandonedVehicleFund 248,699 31,500 - (30,000) 250,199 33,833 - (32,224) 250,308 Urban Forestry Fund 67,202 8,700 (18,637) (24,000) 33,265 22,603 (20,798) (19,740) 49,267 Library Donations Fund 55,267 300 - - 55,567 333 - - 55,599 Special Revenue Funds 19,809,474 3,880,593 13,863 (14,177,228) 9,526,702 3,359,961 46,702 (2,322,443) 20,893,693 OTHER FUNDS 2003&2004 Certificates of Participation 388,514 - - (386,460) 2,054 6 (2,060) (386,460) - PTCWD#3 Trust Fund 461,919 4,925 - (29,803) 437,041 6,606 - (19,372) 449,153 Other Funds 850.433 4,925 - (416,263) 439,095 6,612 (2,060) (405,832) 449,153 TOTAL.ALL FUNDS $ 100,247,110 $ 173,760,162 $ (4,568,000) $ (180,039,375) $ 89,399,897 $ 176,944,715 5 (4,243,663) $ (171,354,074) $ 101,594,088 (1) Reduction In the Fund Balance is equal to the amount of the outstanding Police Side Fund loan paid off in July 2011(53.73 million). (2) The negative fund balance reflects the recording of the estimated future liability regarding outstanding workers compensation claims.