|
City of Pleasanton Mid-Term Budget Update • FY 2022/23 20
<br />FY 2021/22 FY 2022/23
<br />Beginning
<br />Balance as of
<br />June 30, 2021
<br />Projected
<br />Revenue
<br />Projected Net
<br />Transfers
<br />Proposed
<br />Expenditures
<br />Projected
<br />Balance as of
<br />June 30, 2022
<br />Projected
<br />Revenue
<br />Projected Net
<br />Transfers
<br />Proposed
<br />Expenditures
<br />Projected
<br />Balance as of
<br />June 30, 2023
<br />General Fund (1) $34,389,421 $136,489,838 ($11,938,047) ($125,152,641)$33,788,571 $142,484,027 ($5,638,485)
<br />
<br />($137,245,542) $33,388,571
<br />Rainy Day Fund 7,398,553 - 2,734,757 - 10,133,310 - (3,512,760) - 6,620,550
<br />Internal Service
<br />City Enhancement Fund $239,946 $101,500 - ($130,000) $211,446 $101,500 - ($100,000) $212,946
<br />Employee Benefits 8,322 754,909 - (697,909) 65,322 774,909 - (697,909) 142,322
<br />Equipment
<br />Replacement 2,848,748 285,000 - (231,000) 2,902,748 292,000 - (255,000) 2,939,748
<br />Facilities Renovation 3,714,053 320,000 - (626,000) 3,408,053 350,000 ($788,500) (1,003,500) 1,966,053
<br />Pleasanton
<br />Fire Apparatus
<br />Replacement 2,423,025 227,000 - (150,500) 2,499,525 225,000 - (1,009,250) 1,715,275
<br />Golf Replacement 637,691 6,000 $208,094 (210,000) 641,785 6,000 216,218 (275,000) 589,003
<br />Information Technology
<br />Replacement 786,710 190,000 - (300,000) 676,710 197,000 - (300,000) 573,710
<br />P E R S Rate Stabilization 29,362,086 - - - 29,362,086 - - - 29,362,086
<br />Park & Median
<br />Renovation 1,725,457 540,000 (755,000) (975,000) 535,457 580,000 (1,185,000) (792,000) (861,543)
<br />Pleasanton Retirees'
<br />Medical Reserve - 4,270,000 (91,000) (4,179,000) - 4,587,000 (91,000) (4,595,000) (99,000)
<br />Police Vehicle
<br />Replacement 2,887,292 215,000 - (919,500) 2,182,792 225,000 - (887,700) 1,520,092
<br />Public Art Acquisition 179,777 52,000 - (10,000) 221,777 52,000 - (15,000) 258,777
<br />Self-Insurance
<br />Retention 3,184,792 1,385,000 - (2,500,000) 2,069,792 1,824,000 - (2,750,000) 1,143,792
<br />Street Light
<br />Replacement 2,038,027 175,000 - (220,000) 1,993,027 185,000 - (220,000) 1,958,027
<br />Traffic Signal
<br />Replacement 518,803 409,000 - (350,000) 577,803 412,000 - (450,000) 539,803
<br />Vehicle Replacement 4,073,956 310,000 - (577,500) 3,806,456 330,000 - (886,000) 3,250,456
<br />Workers Compensation (3,949,326) 1,545,500 - (2,130,070) (4,533,896) 1,792,000 - (2,291,430) (5,033,326)
<br />Total Internal Service Funds $50,679,360 $10,785,909 ($637,906) ($14,206,479) $46,620,884 $11,933,409 ($1,848,282) ($16,527,789) $40,178,222
<br />Enterprise
<br />Cemetery $708,374 $320,500 $50,000 ($357,732) $721,142 $353,000 $50,000 ($408,542) $715,600
<br />Golf 136,374 4,564,892 (208,094) (3,994,773) 498,399 4,327,368 (216,218) (3,950,179) 659,370
<br />Recycled Water (2,065,780) 3,049,500 (1,444,146) (1,753,485) (2,213,911) 3,109,500 (1,444,146) (1,679,840) (2,228,397)
<br />Sewer 8,860,195 15,527,500 (1,069,953) (16,235,295) 7,082,447 15,852,500 (695,277) (17,015,212) 5,224,458
<br />Storm Drain (300,753) 740,000 625,000 (1,363,335) (299,088) 730,000 625,000 (1,695,461) (639,549)
<br />Transit 294,091 401,500 171,893 (778,989) 88,495 650,600 267,881 (563,372) 443,604
<br />Water 15,411,309 27,531,041 (3,665,188) (27,319,988) 11,957,174 29,401,041 (2,652,871) (28,619,981) 10,085,363
<br />Total Enterprise Funds $23,043,809 $52,134,933 ($5,540,488) ($51,803,597) $17,834,657 $54,424,009 ($4,065,631)
<br />
<br />($53,932,586) $14,260,449
<br />2022/23 Mid-Term Operating Budget 2022/23 Mid-Term Operating Budget
<br />Estimated Changes in Fund BalanceEstimated Changes in Fund Balance
<br />(1) FY 2020/21 General Fund balance of $34.4 million is approximately $9.3 million less than the fund balance of $43.7 identified in the audited FY 2020/21 financial
<br /> statements. The $9.3 million difference is comprised of the $7.4 million listed on the Rainy Day Reserve and $1.9 million PARS Section 115 trust fair value earnings
<br /> and $81,000 of unrealized interest earnings.
<br />(2) The negative fund balance reflects the estimated future liability regarding outstanding workers compensation claims.
<br />(2)
|