Table 213 - Water CIP Funds Budget Carryover FY 2021/22
<br />PROJECTED FUND BALANCE, JUNE 30, 2021
<br />$ 8,411,235
<br />PROJECT CARRYOVER:
<br />FOOTHILL AND SYCAMORE RCS
<br />1,895,743
<br />SANTA RITA/HOPYARD PIPING IMPROV
<br />501,882
<br />VINEYARD PS/MCCLOUD TANK REHAB
<br />500,000
<br />ANNUAL RECYCLED WATER R&R
<br />393,049
<br />PFAS TREATMENT &WELLS REHAB PROJ
<br />303,197
<br />WATER ASSET MANAGEMENT PLAN
<br />300,000
<br />WATER CAPACITY EVALUATION
<br />252,503
<br />SCADA UPDATE WATER
<br />101,198
<br />EMER POWER IMPROVEMENTS UTILITY SYS
<br />50,000.
<br />BRIDGE IMPROVEMENTS
<br />47,607
<br />RISK AND RESILIENCE ASSESSMENT
<br />42,399;
<br />TOTAL PROJECT CARRYOVERS
<br />4,387,579
<br />ADJUSTED FUND BALANCE, JUNE 30,2021
<br />1 $ 4,023,657
<br />Miscellaneous CIP Funds
<br />Table 3A summarizes the FY 2020/21 activity for the Miscellaneous CIP Funds. Actual
<br />revenues were higher than the amended budget by $915,434 due to increased interest
<br />income. The adjusted expenditure budget is reduced by $291,009 related to projects
<br />that have been closed out and the unused budget returned to fund balance. Actual
<br />expenditures were less than adjusted budget by $24.9 million. The expenditure variance
<br />is due to projects not yet completed, all of which have been carried forward to FY
<br />2021/22 as presented in Table 313.
<br />Staff is recommending that Council approve the following:
<br />• Increase the revenue budget by $915,434
<br />• Allocate $99,193 from Capital Projects reserves for emergency repairs
<br />completed at Hansen Playground in the amount of $99,193 under project 21768
<br />Table 3A- Miscellaneous CIP Funds Adjusted Budget to Actual Revenues, Transfers & Expenditures
<br />Page 4 of 9
<br />Year End
<br />Miscellaneous CIP
<br />Amended
<br />Budget
<br />Adjusted
<br />%
<br />Funds
<br />Budget
<br />Amendments
<br />Budget
<br />Actual
<br />$ Variance
<br />Variance
<br />Beginning Balance
<br />$ 30,594,803
<br />$ -
<br />$ 30,594,803
<br />$ 30,594,803
<br />$ -
<br />0%
<br />Revenues
<br />3,746,664
<br />915,434
<br />4,662,098
<br />4,662,098
<br />-
<br />0%
<br />Transfer In/(Out)
<br />968,235
<br />2,501,382
<br />3,469,617
<br />3,469,617
<br />-
<br />0%
<br />Expenditures
<br />28,482,182
<br />(291,009)
<br />28,191,173
<br />3,242,384
<br />(24,948,789)
<br />-8800
<br />Ending Fund Balance
<br />1 $ 6,827,520
<br />$ 3,707,8251
<br />$ 10,535,345
<br />1 $ 35,484,134
<br />1 $ 24,948,789
<br />Page 4 of 9
<br />
|