|
Attachment 2
<br /> FY 2021/22 OPERATING BUDGET YEAR-END REVIEW
<br /> CHANGES IN FUND BALANCES
<br /> Major Long
<br /> Actual Actual Actual Actual proposed for Actual Actual Term YR END
<br /> June 30,2021 FY 2021/22 FY 2021/22 FY 2021/22 Council action FY 2021/22 June 30,2022 Commitments June 30,2022
<br /> Balance Revenue Net Transfers Expenditures Net Income Balance &Liabilities Cash Balance
<br /> June 30,2022
<br /> GENERAL FUND $ 34,398,275 $ 142,599,464 $ (11,831,954) $ (120,540,274) $ (950,000) $ 9,277,236 $ 43,675,512* $ 1.479 150 $ 42,196,362
<br /> RAINY DAY FUND 7.398,553 - 2,734,757 - - 2,734,757 10,133,310 - 10,133,310
<br /> ENTERPRISE FUNDS
<br /> Transit $ 296,577 $ 554,021 - $ (385,391) $ 168,630 $ 465,207 - $ 465,207
<br /> Cemetery 719,503 214,694 50,000 (324,773) (60,079) 659,424 500,000 159,424
<br /> Golf 142,285 5,979,366 (208,094) (4,073,996) 1,697,276 1,839,561 - 1,839,561
<br /> Storm Drain (300,200) 695,675 625,000 (1,222,833) 97,842 (202,358) - (202,358)
<br /> Water 15,623,124 27,095,841 (3,050,606) (26,569,386) (2,524,151) 13,098,973 - 13,098,973
<br /> Recycled Water (2,103,112) 3,222,538 (1,444,146) (1,754,512) 23,879 (2,079,233) - (2,079,233)
<br /> Sewer 8,995,185 16,071,498 (447,036) (15,377,448) 247,014 9,242,199 - 9,242,199
<br /> Enterprise Funds $ 23,373,362 $ 53,833,633 $ (4,474,882) $ (49,708,339) - $ (349,588) $ 23,023,773 $ 500,000 $ 22,523,773
<br /> INTERNAL SERVICE FUNDS
<br /> Employee Benefits $ 8,322 $ 632,492 - $ (573,890) $ 58,602 $ 66,924 $ (4,815,665) $ 4,882,589
<br /> Workers'Compensation (3,890,999) 1,568,803 - (1,720,392) (151,590) (4,042,589) (8,854,000) 4,811,411
<br /> Public Art Acquisition 180,817 51,929 - (20,275) 31,654 212,472 - 212,472
<br /> Vehicle Replacement 4,130,552 338,392 - (197,899) 140,492 4,271,045 - 4,271,045
<br /> Police Vehicle Replacement 2,926,479 298,991 - (482,787) (183,795) 2,742,684 - 2,742,684
<br /> Fire Apparatus Replacement 2,445,416 225,392 - (198,904) 26,488 2,471,904 - 2,471,904
<br /> Equipment Replacement 2,880,975 303,434 - (231,306) 72,129 2,953,103 - 2,953,103
<br /> Facilities Renovation 3,783,334 291,352 - (668,518) (377,166) 3,406,168 - 3,406,168
<br /> Information Technology Replacement 802,273 183,117 - (356,153) (173,036) 629,238 - 629,238
<br /> Golf Replacement 642,230 5,956 176,314 (83,857) 98,413 740,643 - 740,643
<br /> Park&Median Renovation 1,788,911 519,303 - (758,024) (238,721) 1,550,190 - 1,550,190
<br /> Street Light Replacement 2,065,129 172,917 - (20,398) 152,519 2,217,648 - 2,217,648
<br /> Traffic Signal Replacement 528,489 407,643 - (86,576) 321,067 849,555 - 849,555
<br /> PARS Section 115 Trust 25,668,673 - - - - 25,668,673 - 25,668,673
<br /> Pleasanton Retirees'Medical Reserve - 3,465,172 - (3,303,791) 161,381 161,381 - 161,381
<br /> Self-Insurance Retention 3,239,839 1,418,241 - (2,094,766) (676,526) 2,563,313 (816,859) 3,380,172
<br /> City Enhancement 239,963 103,051 - - 103,051 343,014 - 343,014
<br /> Internal Service Funds $ 47,440,402 $ 9,986,185 $ 176,314 $ (10,797,536) - $ (635,038) $ 46,805,365 $ (14,486,524) $ 61,291,889
<br /> 'The actual FY 2021/22 General Fund Ending Fund Balance of$43,675,512 excludes a cumulative investment gain of$925,110 in the General Fund's share of the PARS Section 115 Trust and a GASB 31 fair value loss adjustment of$2 569 367
<br /> Accounting for these investment adjustments,the revised FY 2021/22 General Fund ending fund balance is$42031.256.
<br />
|