Laserfiche WebLink
Task 3. Reports, Models, and Presentation <br />Objective: RDN will develop customized water, recycled water, and wastewater financial models that <br />incorporates a dashboard to allow City staff to easily run scenarios and see the impacts in real time. we will <br />also provide executive reports codifying the results of the financial plans and updated reserve policies. The <br />reports will help educate the reader on the City's revenue requirements and potential rate adjustment needs <br />to maintain current levels of service. <br />Task 3.1. Financial Models <br />The financial planning models will be developed in an easy -to -use Microsoft Excel format designed to allow City <br />staff to conduct sensitivity scenarios by testing various assumptions through an interactive dashboard. Factors <br />that may be adjusted in the rate models include staff levels and salaries, operating expense levels, CIP spending, <br />capital equipment funding, impacts of rate increases, and pass -through charges. Any changes to the underlying <br />models will appear instantly in a dashboard for quick executive evaluation. <br />Task 3.2. Financial Plan Reports <br />RDN will summarize the findings of the water, recycled water, and wastewater financial plans. The financial <br />reports will discuss short- and long-term financial planning, capital planning, and reserve policy guidance. Key <br />data, analysis, and recommendations will be visualized to effectively convey results. <br />Task 4.3. Presentation of Results <br />As requested by City staff, RDN will present the results of the financial plans to stakeholders and/or City Council <br />and address questions or comments. Presentation materials will be provided to City staff beforehand for review. <br />We will ensure that our presentation is clear, compelling, and consistent with messages agreed upon by City staff. <br />Table 4. Task 3. — Reports and Models Deliverables <br />■ Update meetings as required <br />• In -person presentation of study results <br />• 10-Year financial models in Excel <br />• Financial Plan Reports in Word and PDF formats <br />• Comments, responses, and recommendations to draft report <br />=;WN 101Page <br />