|
Table 2B -Water CIP Funds Recommended Budget Carryovers to 2012113FY
<br /> PROJECTED FUND BALANCE,JUNE 30, 2012 $13,333,424
<br /> PROJECT CARRYOVERS:
<br /> Pressure Reducing Station Rehabilitation 50,000
<br /> Bi-Annual Water Quality Improvement Project 75,455
<br /> Bi-Annual Electrical Panel Upgrades and Restorations 171,981
<br /> Bi-Annual Control Valve Installation 14,404
<br /> Bi-Annual Replacement of Polybutylene Service Laterals 16,646
<br /> Annual Water Pump and Motor Repairs 111,589
<br /> Bi-Annual Overhaul of Emergency Water Generators 38,522
<br /> Bi-Annual Water Tank Corrosion Repairs 100,000
<br /> Annual Water Main Replacements Projects 766,782
<br /> Annual Replacement of Water Meters#081040 15,917
<br /> Del Valle Parkway Water Main Extension 585,893
<br /> Utility Billing Software 6,520
<br /> Future Designated CIP Projects* 83,667
<br /> TOTAL PROJECT CARRYOVERS $2,037,376
<br /> ADJUSTED FUND BALANCE,JUNE 30, 2012 $11,296,048
<br /> *Per Developer Contributions worksheet maintained by the Finance Department
<br /> Miscellaneous CIP Funds
<br /> Table 3A summarizes the 11/12FY activity for the Miscellaneous CIF' Funds. Actual
<br /> revenues exceeded adjusted budget by $123,738 and actual expenditures were less
<br /> than adjusted budget by $8,583,480. Revenues exceeding budget included interest
<br /> income ($71,476), Public Facilities Fees ($36,125), Happy Valley Specific Plan Fees
<br /> ($27,548), PG&E solar rebates ($5,286) and miscellaneous revenue ($3,139).
<br /> Revenues exceeding budget were offset with less grant revenues than projected
<br /> ($19,836) due to the timing of receipt of these funds. These funds will be received in
<br /> the 2012/13FY. The American Recovery and Reinvestment Act (ARRA) grant revenue
<br /> and expenditure budget for the Energy Efficiency & Conservation project are included in
<br /> the recommended budget carryovers to 2012/13FY as presented Table 3B. The
<br /> expenditure variance is due to budgeted projects not being completed during the fiscal
<br /> year ($5,556,124) and the accumulation of project reserves ($3,027,356); all of which
<br /> are being recommended to be carried forward to the 2012/13FY as presented Table 3B.
<br /> Table 3A - Miscellaneous CIP Funds Adjusted Budget to Actual Revenues, Transfers &
<br /> Expenditures/Reserves
<br /> Recommended
<br /> Amended Year-End Adjusted $ ok
<br /> Miscellaneous CIP Funds Budget Budget Budget Actual Variance Variance
<br /> Amendments
<br /> Beginning Fund Balance 14,236,503 14,236,503 14,236,503
<br /> Plus Revenues 485,952 485,952 609,690 123,738 25.5%
<br /> Transfers In/Out 731,099 (26,672) 704,427 704,427
<br /> Less Expenditures/Reserves (9,764,910) 48,300 (9,716,610) (1,133,130) 8,583,480 -88.3%
<br /> Ending Fund Balance 5,688,644 21,628 5,710,272 14,417,490 8,707,218
<br /> Page 5 of 11
<br />
|