Table 1A -Sewer CIP Funds Adjusted Budget to Actual Revenues, Transfers & Expenditures
<br /> Recommended
<br /> Year End
<br /> Amended Budget . :Adjusted . � $ %
<br /> Sewer CIP Funds 'Budget Amendments 'Budget Actual, Variance Variance
<br /> Beginning Fund Balance $12,573,539 $12,573,539 $12,573,539
<br /> Revenues 419,094 $3,593 422,687 379,494 ($43,193) 10.2%
<br /> Transfers IN(Out) 1,200,000 1,200,000 1,200,000
<br /> Expenditures 10,071,552 4,593 10,076,145 892,545 (9,183,600) -91.1%
<br /> Ending'Fund Balance $4,121;081 ($1,000) $4,120,081 $13,260,488 $9,140,407'
<br /> Table 1B - Sewer CIP Funds Recommended Budget Carryovers to FY 2017/18
<br /> PROJECTED FUND BALANCE, JUNE 30, 2017 $13,260,488
<br /> PROJECT CARRYOVERS:
<br /> Annual Sewer Main Replacement and Improvements 1,977,068
<br /> Annual Sewer Pump and Motor Repairs 157,033
<br /> Bi-Annual Sewer Electrical Panel Improvements _ 93,619_
<br /> _Bi-Annual Sewer Emergency Generator Improvements 91,678
<br /> Misc Maintenance Management Software(See Misc CIP) 66,667
<br /> ---- -- ----- ----
<br /> Sewer System Master Plan and Model Update__ 150,000
<br /> Old Stanley Blvd Reconstruction and Undergrounding Utility 122,377
<br /> EALS/EARS Pump Station and Pipeline 4,697,027
<br /> ----- -------- —
<br /> Sewer Connection Fee Update 25,000
<br /> Meadowlark Sewer Siphon - 640,960_
<br /> ---- - ------
<br /> Sewer Rate Analysis 9,432
<br /> Sewer Telemetry Upgrades _81,777
<br /> Bi-Annual Sewer Maintenance Hole Improvements 114,459
<br /> Del Valle Parkway/ Nevada St Sewer Additions _ 838,874
<br /> Future Designated CIP Projects* 148,473
<br /> TOTAL.IPROJECLCARrRYOSZERS * r $9,214,444
<br /> AD'JUSTEDhFUND BALANCE ''JUNE 30 2017 . 44;4044
<br /> *Per Developer Contributions worksheet maintained by the Finance Department
<br /> **The difference($30,844)between the expenditure variance and the total carryover amount
<br /> represents excess interfund expenses that were not budgeted..
<br /> Water CIP Funds
<br /> Table 2A summarizes the FY 2016/17 activity for the Water CIP Funds. Actual
<br /> revenues were less than the adjusted budget by $11.9 million and transfers were
<br /> greater than the budget by $263,379. The revenue variance of$11.9 million is
<br /> attributed to the State Water Resources Control Board loan. The City only required
<br /> $9,979,419 of the $11.9 million loan. The $9,979,419 loan proceeds are reflected in the
<br /> beginning fund balance instead of under revenues. Actualexpenditures were less than
<br /> the adjusted budget by $6.4 million. The majority of the expenditure variance is due to
<br /> budgeted projects not being completed during the fiscal year that are being
<br /> recommended to be carried forward to the FY 2017/18 as presented in Table 2B.
<br /> 3
<br />
|