|
Exhibit A
<br /> FY 2022123 OPERATING BUDGET YEAR-END REVIEW
<br /> CHANGES IN FUND BALANCES
<br /> Actual Actual Major Long YR END
<br /> Actual Actual Actual Actual Recommended FY 2022123 June 30,2023 Term June 30,2023
<br /> June 30,2022 FY 2022123 FY 2022123 FY 2022123 Budget Net Income Balance Commitments Balance Less
<br /> Balance Revenue Net Transfers Expenditures Amendments w/Budget wl Budget &Liabilities Commitments
<br /> Amendments Amendments June 30 2023 &Liabilities
<br /> GENERAL FUND $ 43,732,845 $ 152,768.013 $ (4,975,623) $ (133,556,605) $ (4,000,000) $ 10,235,785 $ 53,968,630 $ 2,379,150 $ 51,589,480
<br /> RAINY DAY FUND 10,133,310 - (3,512,760) (3,512,760) 6,620,550 6,620,550
<br /> ENTERPRISE FUNDS
<br /> Transit $ 463,502 $ 727,019 - $ (512,209) $ 214,810 $ 678,312 - $ 678,312
<br /> Cemetery 652,193 188,282 50,000 (365,938) (127,657) 524,536 500.000 24,536
<br /> Golf 1,835,443 5,914,922 (1,466,218) (4,622,602) (173,897) 1,661,545 1,661,545
<br /> Storm Drain (204,860) 737,680 625,000 (1,868,460) 1,000,000 494,220 289,360 289,360
<br /> Water 12,962,382 26,653,452 (304,006) (28,139,604) - (1,790,157) 11,172,225 - 11,172,225
<br /> Recycled Water (2,044,373) 2,348,677 (1,416,259) (1,700,011) (767,593) (2,811,966) (2,811,966)
<br /> Sewer 9,155,249 15,727,739 (99,994) (16,521,710) - (893,965) 8,261,284 8,261,284
<br /> Enterprise Funds $ 22,819,535 $ 52,297,771 $ (2,611,477) $ (53,730,534) 1,000,000 $ (3,044,239) $ 19,775,295 $ 500,000 $ 19,275,295
<br /> INTERNAL SERVICE FUNDS
<br /> Employee Benefits $ 63,924 $ 111,986 $ (115,286) - $ (3,300) $ 60,624 $ (4,824,475) $ 4,885,099
<br /> Workers'Compensation (4,084,078) 1,802,201 (1,826,958) 500,000 475,243 (3,608,835) (9,165,000) 5,556,165
<br /> Public Art Acquisition 211,749 106,526 (70) - 106,455 318,205 318,205
<br /> Vehicle Replacement 4,230,364 588,328 (542,808) 45,520 4,275,884 4,275,884
<br /> Police Vehicle Replacement 2,714,187 436,272 (1,250,364) - (814,091) 1,900,096 1,900,096
<br /> Fire Apparatus Replacement 2,457,948 449,448 (59,748) 250,000 639,700 3,097,648 3,097,648
<br /> Equipment Replacement 2,931,544 573,300 (208,603) - 364,697 3,296,242 3,296,242
<br /> Facilities Renovation 3,355,957 643,031 (788,500) (688,778) 250,000 (584,247) 2,771,710 2,771,710
<br /> Information Technology Replacement 617,244 380,625 - (862,208) 1,000,000 518,417 1,135,661 1,135,661
<br /> Golf Replacement 737,493 12,154 934,438 (651,394) - 295,199 1,032,692 1,032,692
<br /> Park&Median Renovation 1,497,346 1,053,109 (1,221,000) (731,256) (899,147) 598;199 598,199
<br /> Street Light Replacement 2,198,429 337,096 (36,895) - 300,201 2,498,630 2,498,630
<br /> Traffic Signal Replacement 842,196 841,462 (329,470) 200,000 711,992 1,554,188 1,554,188
<br /> PARS Section 115 Trust 28,059,531 - - - - 28,059,531 28,059,531
<br /> Pleasanton Retirees'Medical Reserve 161,381 3,585,422 68,000 (3,263,762) - 389,660 551,041 551,041
<br /> Self-Insurance Retention 2,520,437 1,798,481 - (3,375,989) 800,000 (777,507) 1,742,930 (859,094) 2;602,024
<br /> City Enhancement 343,950 212,208 - 212,208 556,158 556,158
<br /> internal Service Funds $ 48,859,603 $ 12,931,651 $ (1,007,062) $ (13,943,589) 3,000,000 $ 981,000 $ 49,840,603 $ (14,848,569) $ 64,689,172
<br /> The actual FY 2022123 General Fund Ending Fund Balance of$53,968,630 excludes a cumulative investment gain of$1,510,562 in the General Fund's share of the PARS Section 115 Trust and a GASB 31 fair value loss adjustment of$4,807,463. Accounting for these investment
<br /> adjustments,the revised FY 2022123 General Fund ending fund balance is$50,671,729.
<br />
|