Attachment 2
<br /> FY 2017/18 OPERTATING BUDGET YEAREND REVIEW
<br /> CHANGES IN FUND BALANCES
<br /> major Long
<br /> Actual Actual Actual Actual Proposed Proposed Actual Actual Term YR END
<br /> June 30,2017 FY2017118 FY2017/18 FY2017118 Transfers for Expenditures for FY2017/18 June 30,2018 Commitments June 30,2018
<br /> Balance Revenue Net Transfers Expenditures Council action Council action Net Income Balance &Liabilities Balance
<br /> 1,,.,o zn'nIR
<br /> GENERAL FUND 22,586,792 121,066,577 (6,365,987) (105,752,557) (2,274,942) (1,274,942) 8,948,033 27,984,942 1,921,177 26,063,765
<br /> ENTERPRISE FUNDS
<br /> Transit 306,626 409,367 358,977 (787,766) (19,421) 287,205 287,205
<br /> Cemetery 465,089 290,873 45,000 (600,881) (265,008) 200,081 200,081
<br /> Golf 71,672 3,774,140 (279,151) (3,566,661) (71.672) 0 0
<br /> Storm Drain 921,761 755,621 (170,000) (1,104,304) (3,272) (518,683) 399,806 399,806
<br /> Water 11,815,639 26,875,833 (4,322,321) (21,281,004) (31,324) 1,272,508 13,056,823 380,498 12,676,325
<br /> Recycled Water 530,848 1,523,888 (844,065) (2,670,987) (1,991,164) (1,460,317) (1,460,317)
<br /> Sewer 6,489,335 14,629,984 (1,085,171) (13,171,191) (16,068) 373,623 6,846,889 179,307 6,667,582
<br /> Enterprise Funds 20,600,970 48,259,706 (6,296,731) (43,182,794) (50,664) (1,219,817) 19,330,487 559,805 18,770,682
<br /> INTERNAL SERVICE FUNDS
<br /> Employee Benefits (1,331,123) 1,188,171 (226,803) 961,368 (369,755) (5,350,424) 4,980,669
<br /> Workers'Compensation (1,513,320) 1,071,174 (1,821,620) (750,446) (2,263,766) (7,850,000) 5,586,234
<br /> L.P.F.D. Workers'Compensation (2,477,783) 777,719 (687,659) 90,060 (2,387,723) (4,182,000) 1,794,277
<br /> Public Art Acquisition 176,041 54,966 (71,545) (16,579) 159,462 159,462
<br /> Vehicle Replacement 3,355,269 598,558 (335,357) 263,201 3,618,470 3,618,470
<br /> Police Vehicle Replacement 1,518,672 488,807 488,807 2,007,479 2,007,479
<br /> L.P.F.D. Replacement 300,087 44,128 (7,219) 36,909 336,996 336,996
<br /> Fire Apparatus Replacement 845,732 228,477 228,477 1,074,209 1,074,209
<br /> Equipment Replacement 1,535,006 373,733 (61,799) 311,935 1,846,941 1,846,941
<br /> Facilities Renovation 4,650,457 1,177,172 (1,359,000) (524,839) (706,666) 3,943,791 3,943,791
<br /> Information Technology Replacement 1,652,560 460,557 (1,003,256) (542,698) 1,109,861 1,109,861
<br /> Golf Replacement 312,953 2,284 201,037 (152,699) 50,622 363,575 363,575
<br /> Park&Median Renovation 6,282,620 1,100,229 (600,000) (1,108,378) (608,149) 5,674,471 5,674,471
<br /> Street Light Replacement 1,570,599 64,495 (82,774) (18,280) 1,552,319 1,552,319
<br /> Traffic Signal Replacement 727,360 281,774 (326,578) (44,803) 682,557 682,557
<br /> P E R S Rate Stabilization 2,005,818 2,005,818 2,005,818
<br /> Pleasanton Retirees'Medical Reserve 20,310,571 5,150,533 (61,000) (4,042,373) 1,047,160 21,357,731 5,325,000 16,032,731
<br /> L.P.F.D. Retirees'Medical Reserve-Joint 826,748 757,988 (926,618) (168,629) 658,119 658,119
<br /> Self-Insurance Retention 5,166,449 1,165,161 (1,940,379) (775,218) 4,391,231 (1,242,477) 5,633,708
<br /> Internal Service Funds 45,914,716 14,985,928 (1,818,963) (13,319,894) (152,929) 45,761,787 (11,294,083) 57,055,870
<br />
|