Table 2A - Water CIP Funds Adjusted Budget to Actual Revenues, Transfers &
<br /> Expenditures
<br /> Recommended
<br /> Year-End
<br /> Amended Budget Adjusted $
<br /> Water CIP Funds Budget Amendments Budget Actual Variance Variance
<br /> Beginning Fund Balance* $9,009,835 $9,009,835 $9.009,835
<br /> Revenues 222,715 222,715 282,365 $59,650 26.8%
<br /> Transfers In/(Out) 2.070,000 43,640 2,113,640 2,113,640 -
<br /> Exoenditures 9,590,885 176,825 9,767,710 2,144,347 (7,623,364) -78.0%
<br /> Ending Fund Balance $1,711,665 ($133,185) $1,578,480 $9,261,494 $7,683,013 487%
<br /> *The State Water Resources Control Board Loan balance of$9,379,766 is excluded from the fund balance
<br /> Table 2B - Water CIP Funds Budget Carryovers to FY 2019/20
<br /> PROJECTED FUND BALANCE, JUNE 30, 2019 $9,261,494
<br /> PROJECT CARRYOVERS:
<br /> Recycled Wtr Infras Exp-Design 17,984
<br /> Ruby Hill - Addl Water Storage 696,137
<br /> Bi-Annual Water Quality Improvement 371,817
<br /> Water Telemetry Upgrades 37,867
<br /> Water Scada Update 196,700
<br /> Bi-Annual Wtr Electrical Panel Impr 8,395
<br /> Bi-Annual Control Valve Improvement 4,527
<br /> Annual Replcmnt Polybutylene Servic 2,442
<br /> Bi-Annual Water Tank Corrosion Repa 45,816
<br /> Annual Water Main Replacement 784,904
<br /> Water Master Plan/Model Update 231,470
<br /> Tri-Valley Potable Reuse Master Pln 300,000
<br /> Del Valle Pkwy Water Main Ext 585,824
<br /> TOTAL PROJECT CARRYOVERS** 3,283,883
<br /> ADJUSTED FUND BALANCE, JUNE 30, 2019 $5,977,611
<br /> **The difference($4.2m) between the expenditure variance and the total carryover amount
<br /> represents closed projects return unspent funding to Fund Balance
<br /> 4
<br />
|