Agreement Amendments for AMI
Software Enhancements
Contract Subcommittee
January 25, 2023
Kimberly Zunino, Deputy Director Administration
Advanced Metering Infrastructure Agreements
Meter Data Management Software – Compass (formerly MeterSense) • Project Agreements for Meter Data Management – July 2021 • Agreements with N. Harris (parent company)
• Software implementation with training- $290,000
• Support and maintenance - $52,245 annually
with annual increases
Amendments to Implementation Agreement
• Multiple Amendments
• First Amendment, July 2017 - $24,000
• Implementation of Water Conservation Manager (WCM) Module • Second Amendment, October 2019 - $26,200
• Adding tiered rates to provide sewer cap data in system • Added water budgets for dedicated irrigation accounts • Onsite training services
• Developed test environment
• 80-hour service package
• Third Amendment, March 2021 - $10,000
• Created custom code in system to track continuous water use and generate reports • Forth Amendment, September 2022 - $5,290
• Updated registration process for customer portal for ease of use by customer 5th Amendment Proposed Enhancements
WaterSmart – Customer Portal
• Proposed enhancements
• Update menus on homepage
• More intuitive navigation & quick links
• Modifying multiple account labeling
• Add billing read for customers
• Allowing staff to assist customer
with account activation
• Develop reports for staff to review
customer notifications
• $29,900 for enhancements
5th Amendment Proposed Enhancements
Water Conservation Manager
• Proposed Enhancements
• Improve reporting tools
• Create location groups
• Grouping accounts for comparisons, program tracking, outreach, etc. • Future report writing
• Upgrade scorecard functionality to allow bulk mailing • Allotment development for water shortage
• $65,550 for enhancements
Amendments to Support and Maintenance
• Original for only meter data management (MDM) - $52,245 • Annual increases
• First Amendment, July 2017 - $42,000 annually
• Water Conservation Manager support and maintenance
• Currently no annual increases
• Second Amendment, September 2019 - $1,900 increase to MDM support • Annual increases
• Proposed third Amendment - $8,624 annually
• Supporting all proposed enhancements
Total Costs
• Implementation of enhancements
• Water Conservation Module and WaterSmart Portal
• $95,450
• Support and maintenance for enhancements
• $8,624 annually
• Increases currently at 4% annually
Recommendation
It is recommended by Santa Rosa Water staff that the Contract Review Subcommittee recommend to the Board of Public Utilities the amendments with N. Harris for implementation of AMI software enhancements and increased support and maintenance costs.