13 - Laserfiche WebLink

Table 1A - Sewer CIP Funds Adjusted Budget to Actual Revenues, Transfers & Expenditures Recommended Year-End Amended Budget Adjusted $ Sewer CIP Funds Budget Amendments Budget Actual Variance ice Beginning Pond Balance 1 13.260 488 13.260 488 13 260 488 Revenues 119 853 $1 305 121 158 263.843 8142.685 117.8% Transfers In0Out 1 192 592 I 1 192 592 1 192 247 3450 Expenditures 11.845.997 2.305 11.848.302 1.740.063 (10.108.239) -85.3% Ending Fund Balance 2,726,936 ($1,000) $2,725,936 $12,976,515 $10,250,578 Table 1B - Sewer CIP Funds Bud•et Car overs to FY 2018/19 PROJECT CARRYOVERS: Annual Reinforced Sewer Main @ Arroyo 500,000 Bi-Annual Sewer Maint Hole Improvements 150,000 Biannual Sewer Emergency Generator 18,430 DI Val Pkwy/Nevada Sewer Addition 838,874 Eals/Ears Pump Station/Pipeline 4,601,863 Meadowlark Sewer Siphon 5,532 Scada Update 147,472 Sewer System Master Plan/Model Update 150,000 Val Vista Underdrain To Sewer 244,379 Future Designated CIP Projects* 148,473 TOTAL PROJECT CARRYOVERS** $6,805,023 D F ID EININCE,4,JNE 30, 2018 Gai;, $6,171,492 *Per Developer Contributions worksheet maintained by the Finance Department **The difference ($3.3m) between the expenditure variance and the total carryover amount represents closed projects return unspent funding to Fund Balance Water CIP Funds Table 2A summarizes the FY 2017/18 activity for the Water CIP Funds. Actual revenues were less than the adjusted budget by $670,586 less than budget due to not receiving the $750,000 reimbursement from the County for the Castlewood AMI Installation project that is expected to be complete in FY 2018/19. That $750,000 shortfall is offset by investment earnings and connection fees exceeding budget. Actual expenditures were less than the adjusted budget by $6.9 million. The majority of the expenditure variance is due to budgeted projects not being completed during the fiscal year that have been carried forward to the FY 2018/19 as presented in Table 2B. Staff is recommending through this Report that Council approve additional budget amendments totaling ($75,435) as follows: • Increase in revenue budget by $828 to account for increased interest earnings on the developer contributions fund balance. • Increase the expenditure budget by $76,263 for various construction contracts that exceeded the budget. 3