|
Attachment 2 - Exhibit A
<br />Actual
<br />June 30, 2022
<br />Balance
<br />Actual
<br />FY 2022/23
<br />Revenue
<br />Actual
<br />FY 2022/23
<br />Net Transfers
<br />Actual
<br />FY 2022/23
<br />Expenditures
<br />Recommended
<br />Budget
<br />Amendments
<br />Actual
<br />FY 2022/23
<br />Net Income
<br />w/ Budget
<br />Amendments
<br />Actual
<br />June 30, 2023
<br />Balance
<br />w/ Budget
<br />Amendments
<br />Major Long
<br />Term
<br />Commitments
<br />& Liabilities
<br />June 30, 2023
<br />YR END
<br />June 30, 2023
<br />Balance Less
<br />Commitments
<br />& 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 />FY 2022/23 OPERATING BUDGET YEAR-END REVIEW
<br /> CHANGES IN FUND BALANCES
<br />* The actual FY 2022/23 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 2022/23 General Fund ending fund balance is $50,671,729.
<br />Page 269 of 270
|