ITEM 24 ATTACHMENT 2 - Laserfiche WebLink

City of Pleasanton 2025 Water Rate Study Water Resources Economics iii LIST OF TABLES Table 1-1: Current Bi-Monthly Fixed Charges (Potable and Recycled) ..................................................... 4 Table 1-2: Current Combined Variable Charges ..................................................................................... 4 Table 1-3: Current Discount Programs ................................................................................................... 4 Table 1-4: Current Reserve Policies ....................................................................................................... 5 Table 1-5: Proposed Financial Plan Scenario ......................................................................................... 7 Table 1-6: Current and Proposed City Bi-Monthly Fixed Charges (Potable) ............................................ 10 Table 1-7: Current and Proposed Zone 7 Bi-Monthly Fixed Charges (Potable) ........................................ 11 Table 1-8: Current and Proposed City and Zone 7 Variable Charges (Potable) ....................................... 11 Table 1-9: Current and Proposed Bi-Monthly Fixed Charges (Recycled) ................................................. 11 Table 1-10: Current and Proposed Variable Charges (Recycled) ........................................................... 11 Table 1-11: Proposed Single Family Customer Impacts ........................................................................ 12 Table 1-12: Proposed Recycled Irrigation Customer Impacts ................................................................ 12 Table 1-13: Proposed Drought Rates ................................................................................................... 14 Table 1-14: Proposed Combined Variable Charges and Drought Rates ................................................. 15 Table 1-15: Proposed Single Family Customer Impacts (Stage 2 Shortage) ............................................ 15 Table 1-16: Proposed Single Family Customer Impacts (Stage 3 Shortage) ............................................ 16 Table 1-17: Water Connection Fee Calculation .................................................................................... 18 Table 1-18: Proposed Water Connection Fees ..................................................................................... 18 Table 2-1: Current Bi-Monthly Fixed Charges (Potable and Recycled) ................................................... 21 Table 2-2: Current Combined Variable Charges ................................................................................... 21 Table 2-3: Current Discount Programs ................................................................................................. 22 Table 2-4: Effective Bi-Monthly Fixed Charges (Potable and Recycled) .................................................. 22 Table 2-5: Effective Combined Variable Charges .................................................................................. 22 Table 2-6: Projected Customer Accounts ............................................................................................ 23 Table 2-7: Projected Discount Program Bills ........................................................................................ 25 Table 2-8: Projected Customer Water Usage (ccf) ................................................................................ 25 Table 2-9: Projected Discount Program Usage (ccf) .............................................................................. 26 Table 2-10: Calculated Rate Revenues at Current Rates ....................................................................... 27 Table 2-11: Revenue Summary ............................................................................................................ 28 Table 2-12: Expense Inflationary Assumptions ..................................................................................... 28 Table 2-13: Calculated Potable Water Supply Costs ............................................................................ 29 Table 2-14: Expense Summary ............................................................................................................ 30 Table 2-15: Existing Debt Service ......................................................................................................... 31 Table 2-16: Proposed Debt Service ...................................................................................................... 31 Table 2-17: Capital Project Costs and Execution Rate .......................................................................... 32 Table 2-18: Capital Expense Summary ................................................................................................ 32 Table 2-19: Status Quo Financial Plan Scenario ................................................................................... 33 Table 2-20: Projected Potable and Recycled Cash Flows (Status Quo Financial Plan) ............................ 34 Table 2-21: Projected Potable and Recycled Fund Balances (Status Quo Financial Plan) ....................... 35 Table 2-22: Forecasted Potable and Recycled Financial Performance (Status Quo Financial Plan) ........ 36 Table 2-23: Proposed Water and Recycled Financial Plan Scenario ...................................................... 39 Table 2-24: Projected Potable and Recycled Cash Flows (Proposed Financial Plan) .............................. 40 Table 2-25: Projected Potable Cash Flows (Proposed Financial Plan) ................................................... 42 Table 2-26: Projected Recycled Cash Flows (Proposed Financial Plan) ................................................. 43 Table 2-27: Projected Potable and Recycled Fund Balances (Proposed Financial Plan) ......................... 44