Automated Meter Reading Project AMR Presentation Industry

Automated Meter Reading Project (AMR) Presentation – Industry & Mining Forum 26 May 2016 Automated Meter Reading System Project (AMR) Project Engineering Services Section

Presentation Content Overview & Background CONTENT 1. AMR Solution Introductory Video 2. Acknowledgement & Appreciation 3. Objectives & Deliverables 4. AMR Road Map 5. Corporate Strategic Objectives & AMR Alignment 6. Governance Structure 7. Integrated AMR Model 8. AMR Customer Benefits 9. Critical Success Factors 10. Progress Update 11. Mechanical Aspects 12. Automation

AMR Flow Meter Aqua Master Solution Video Clip

Acknowledgement & Appreciation The AMR Team would like to extend our sincere gratitude to the AMR Steering Committee, Bulk Water Distribution Leadership, Regional Account Executives, and you are valued customers affording us an opportunity to be in the forefront of ruling out exciting innovations in the form of cutting edge Technology. We are truly humbled and have pledged our commitment to ensure an inclusive approach as role out this technologically advanced initiatives. Successful execution rests not only on the shoulders of AMR Team, but on us as a collective in unity.

Brief background of RW and Conception of AMR Objectives & Success Criteria • Replacement of all mechanical meters with mag-flow meters that will provide an accuracy level of <1% • To install a complete magnetic flow measurement, pressure measurement, data logging and a telemetry system linked to a central server database Deliverables Compilation & Submission of Preliminary Documentation (Detailed Programme, Declaration of Insurance, Team Member Documents, Site Induction • • To work towards reduction of NRW to <3%, Corporate Target; Installation and Commissioning • Proving Period Performance Testing • Real time extraction of readings from a central server database to the finance billing system Detailed Design, Procurement, Manufacture, Testing and Delivery Phase • • • Takeover including Completion & Submission of Final Documents

Project Road Map Phase 4 – 22 Meters Installed 2 Pilot Meters Installed Dashboard Interface Dev Phase 3 – H&S Set & Configure Phase 2 – Design & Prototype Dev Awarded Contract 07/15

Alignment of AMR to RW Strategic Objectives • Operational excellence and best fit technology • • Water losses will be reduced throughout the distribution network; Potential human error will be eliminated; Water volume balancing will be achieved, supporting WDM Strategies • High Performance Culture Stakeholder Engagement Culture Accurate, real time billing system from dedicated AMR database • The AMR Team will consolidate efforts to meet the needs of our clients; AMR will be an enabler for effective Asset Management • • • Stakeholders throughout business where extensively engaged; Improved service to our Bulk Customers, billing will have reduced disputes;

Alignment of AMR to RW Strategic Objectives Achieve Growth Reduction of water losses will increase our revenue stream; It will also impact our balance sheet positively (Increase in assets to generate revenue for growth; • Financial Viability • • Innovation of the Water Value Chain will improve our efficiencies; Resource will be redirected in terms of strengthening efforts in line with growth agenda; • Rural Development - Rand Water will continue to innovate and work towards ensuring that our Rural Communities benefit through these strategic initiatives

Governance Structure established and accountable COO AMR Team GM: SAM GM: OPS GM: IT GM: SS GFM ODD (HR)

Integrated Approach to implementing AMR Online WQ Reservoir Meters Cathodic Protection Energy Central Server Database Flow & Pressure • Billing • Water Balancing • Water Sampling for Analysis • Monitor Reservoir Levels • Corrosion Control • Monitor Energy Consumption Levels Project will be implemented in a phased approach, We’ve started with Flow & Pressure and Online WQ Instrument Stakeholder Consultation is progressing

How will AMR Benefit you our valued customer Mines & Industry Enhanced Billing on Water Consumption Improved response time to maintenance matters Provision of enhanced reports for statistical analysis Improved Customer Relationship Management

Key drivers to successful implementation of AMR Secure Shutdown Seamless Installation & Configure Transmission of Data Integrity & Accountability Monitoring of Infrastructure by Districts ater f eeds w ry n Indust ines & ocess ities, M tion pr uc mun on & prod isolati • Com aking mption m su or con rroded y be co g es Ma nitorin • Valv re, mo Repairs on Site tely Accura Invoice ers Custom

Key drivers to successful implementation of AMR Phase 2 – Hardware & Software Installed Configured & Tested 100% complete Phase 3 – Hardware & Software Installed Configured & Tested 100% complete Phase 4 – 22 Meters installed during Apr & May 2016

Mechanical

Typical illustration of meter installation Customer Reservoir PM ZK MP Eikenhof ZB Customer VG Source

Operations & Maintenance drivers Actions • • • Water Losses Consumer Reading Meters Meter maintenance and accuracy Pressure Monitoring Flow Monitoring • Vandalism • Disaster aversion alarms • • • Chamber Flooding • Description • • • Water meters are only read once per month Rand Water has 1730 meters, which are read monthly Mechanical meters were most suitable historically, business has to evolve its process & infrastructure Pipeline performance monitoring will be enhanced Meter accuracy is greatly reduced with mechanical meters, uncertain regarding consumer behaviour, flow meters will allow for data analysis, availability of stats to improve and better understand consumer behaviour; Vandalism of consumer meters and chambers are constantly a challenge, we’re also strengthening security of these chambers & meters ; Flooded chambers are only discovered during meter reading once per month, In the event of a burst pipe, there is a step change in flow rate, we’ll be able to monitor and response swiftly to this event

Meter Installation breakdown structure Flow Meter Sites Data logger Central Depot Server Sites Comm Devices AMR OPC Server F SQL Server P Archestra Server T, L F – Flow P – Pressure T – Alarm sensor tamper L – Level Switch for flooding AMR – Automated Meter Reading OPC – Open Protocol Communication

Automation

AMR Hardware Architecture • Automatic meter reading, or AMR, is the technology of automatically collecting consumption, diagnostic, and status data from water metering devices transferring that data to a central database for billing, troubleshooting, and analyzing. • AMR systems promote more cognisant water usage by revealing exactly how a site is using resources, and where reductions can be made to improve efficiency and lower costs. • AMR continually gathers data, and can provide this information on a real-time basis. Usage data can be viewed at any time, and once collected, is immediately stored in a repository of historical consumption information for comparative or analysis purposes.

AMR Hardware Architecture

AMR Sites • Magnetic flow meters shall measure flow and compute volume in real time. • Full bore in size without reduction of internal diameter, where a full bore meter cannot be installed, an insertion sensor with the same functionality shall be used. • ± 0. 5% accuracy above a water flow speed of 0. 5 m/s under laboratory conditions. • The flow transmitter must have a display screen with two displays at anytime namely flow rate and volume. • Float switches shall raise an alarm when the water level in the chamber increases above a certain point. • Pressure sensors shall measure pressure in real time • Provision shall be made for one pressure input at an operating pressure of up to 25 bar. • Theft proof enclosures shall be provided at the 612 consumer flow meter sites.

AMR Server Sites • It shall be possible to interrogate the software by as push button and get current data • An ability to zoom in and zoom out on profile graphs shall be provided • Line breaks on profile graphs during communication failure shall be shown • Plot of flow totals per week, month and year shall be possible • Bidirectional communication link to flow meter for alarm resetting and acknowledging via the data manager software shall be provided • It shall integrate seamlessly to Wonderware Archestra platform, In. SQL and In-touch • It shall integrate seamlessly to the SAP billing module ant Rand Water Oracle based billing system. • A facility to add, move or delete meters shall exist (meter management) • It shall generate meter management audit reports

AMR Software Workflow AMR OPC Server (Zeechart Application) AMR District Superintedent Spreadsheet AMR SQL Database AMR CSV Files AMR Billing Application AMR Data Analyst Spreadsheet AMR Customer Invoice AMR SCADA Application

AMR Value Proposition • Highly accurate meter readings – no more estimates • Improved billing processes • Real-time data access • Continual data readings enable you to monitor where water is being used at all times. • Each client will have access to full reporting information on each water billing information • Encourage individual to regulate their water usage • Increase confidence in service • Monitors tampering and theft

AMR Actual Report Rustenburg Meter

? 26