Specifications include, but are not limited to: Task 1 – Coordination with 2014 Comprehensive Water Audit and the Enhanced Metering Project 1.1 Review the “Recommendations for Improving Non-Revenue Water Performance” identified in the previous audit. a. Determine which recommendations have not been implemented and with input from DOW staff, summarize the reasons for this. b. Develop a list of recommendations to re-evaluate during the current audit and submit for review. Consultant shall allow for sufficient time for DOW review. 1.2 Coordinate with City staff to review all available information pertaining the City’s Enhanced Metering Project. Consultant to fully understand that all recommendations developed as part of this audit need to consider and incorporate the City’s move to AMI. 1.3 Deliverable: Approved list of recommendations that shall be incorporated into Task 7 – Recommendations to Reduce Non-Revenue Water. Task 2 – Validate the Production and Consumption Figures 2.1 Validate the accuracy of the reported total amount of water supplied to the distribution system. a. Review the current methodology to determine/measure the finished water metered supply at the three treatment plants to validate the accuracy of the data. Field visits to the City’s water treatment plants are not anticipated, but will be undertaken as an optional service, if requested and authorized by the City. b. Validate, identify, and quantify flow rates and volume totals for the source water and identify any discrepancies in treatment plant supervisory control and data acquisition (SCADA) versus operations control center SCADA. c. Make recommendations for improving the current procedure, if applicable. d. For the thirteen water service districts validate, identify and quantify flow rates and volume totals for the infrastructure (booster station, tanks and pressure reducing valves) that provide water to each district. 2.2 Quantify the billed authorized consumption for the calendar year 2019. a. Compile billed authorized consumption (metered) data from the Columbus Utility Billing System (CUBS) and validate the accuracy of this data to ensure consumption is being reported correctly in the billing system. b. The Consultant will review annual billed volume adjustments. This effort will include: 1) Adjusting the reported Billed Authorized Consumption meter readings to allow for meter reading lag time. 2) Compile billed authorized consumption (unmetered) from miscellaneous fees collected from the DOW. A portion of the fees collected for hydrant usage and chlorination allows for usage of water. 3) Develop the adjusted Billed Authorized Consumption totals. 4) Make recommendations for improving the current procedure if applicable. 5) Perform the same calculation for the thirteen water service districts.