Laserfiche WebLink
REV: 10-09-24 MI <br />program, and any relevant master plans. Consultant shall prepare the financial plan as <br />an Excel spreadsheet model to provide the City with a means to edit the model when <br />annual budgets and capital expenditures change each year. Consultant shall develop the <br />models to be as simple as possible and with input from the Public Works Director or their <br />designee(s) to ensure that they meet the City’s needs. Models shall have no licensing <br />restrictions. For specific elements: <br />•Expenses: Consultant shall tailor expense calculations to reflect variations in <br />staffing levels, salaries, operating expenses and other City requested inputs. <br />Analysis shall include San Francisco Public Utilities Commission (SFPUC) cost to <br />purchase water, taking into consideration SFPUC projected increases, recent <br />drought conditions, reduced water allotment from SFPUC, and potable water use <br />reduction and conservation goals identified in the City’s Urban Water Management <br />Plan. Expenses shall also include debt service and software. <br />•Revenues: Consultant shall calculate and project rate revenue based on the <br />current rate structure and projected growth in units of service (e.g., hundred cubic <br />feet (hcf), service connection size). <br />•Reserves: Consultant shall integrate current reserve funds into the model and <br />evaluate existing policies, as well as the need for adding, deleting, or redefining <br />the funds. Consultant shall confirm the reserve level rules for modeling the rate <br />increases, which will either reflect current policies or recommended policies. <br />Consultant shall assess the City’s reserve and consider creating a new reserve <br />target and potential rate stabilization fund. <br />•Capital Improvement Projects: Consultant will generate a 10-year capital <br />improvements schedule based on City staff information to determine the annual <br />cash-funded capital expenditures per fiscal year. <br />•Future Considerations: Consultant shall evaluate and account for changes in <br />accounts due to growth and water demand pattern fluctuations, such as from water <br />shortage concerns and new development. City staff shall be able to adjust future <br />assumption inputs in this model. <br />Deliverables: Consultant shall provide a 10-year water and recycled water financial <br />model that includes revenue requirement, reserves, reserve policies, debt service <br />coverage, and forecasted revenues. Consultant may also consider creating a new reserve <br />target and potential rate stabilization fund. <br />Task 6c. Cost-of-Service Analysis <br />Consultant shall prepare a cost-of-service analysis so that revenue requirements are <br />distributed among the customer classes (which includes, but is not limited to, single <br />family, commercial, ADUs, fire service connections, and construction meters) and <br />conform to the rate structures identified for each customer class. Consultant shall identify <br />the unit costs of service and proportionate share of the overall revenue requirement for <br />each class. Prior to preparing the cost-of-service analyses, Consultant shall present up <br />to three alternative rate structures for the consideration of the Public Works Director or <br />their designee(s). In presenting these alternatives, Consultant shall confirm whether the <br />City’s customer billing system has the ability to charge the rates. <br />ATTY/AGR.2024/Amend. No. 2/HF&H Consultants, LLC (Water Rate and Capacity Fee Study) (Page 5 of 13)