Customer Retail Unit Cost Calculation Tool

This Workbook is designed to assist with the calculation of the Customer Retail Unit Cost (“CRUC”) value found in cell 77G on the Reporting Worksheet of the AWWA Water Audit Software Ver. 5. This cost represents the average volumetric charge a customer pays for water and is routinely applied to apparent losses. The CRUC is the weighted average composite of the system’s volumetric charges across customer classes and tiers, and includes sewer, stormwater and biosolids charges IF those charges are based on the volume of potable water consumed. Using this format will allow the user to see how much revenue is generated by each customer class and rate tier. The spreadsheet contains instructions and sample data and can be modified by the user to meet their specific needs.