Knowledgebase-Town of Wartrace Monthly Utility Reporting


Information Product

Title:Town of Wartrace Monthly Utility Reporting
Summary:MTAS was asked to make recommendations for a monthly reporting system for water and wastewater utilities.
Original Author:Darden, Ron
Co-Author:
Product Create Date:07/13/2011
Last Reviewed on::08/17/2011
Subject:Utilities--Reports; Utilities--Administration
Type:General
Original Document: Town of Wartrace.pdf

Reference Documents: July 13 letter to Ms. Gentry utility accounting.docx

Text of Document: Town of Wartrace
Monthly Utility Reporting

By Ron Darden, MTAS Municipal Management Consultant

MTAS recommends the following monthly reporting system for water and wastewater utilities:

Water System-Monthly

Customers
  • Number of customers
  • Number of water samples taken
  • Number of contaminated samples found

Capacity
  • MGD or thousands of gallons of water treated and pumped from the water plant
  • Gallons of water billed to customers
  • MGD or thousands of gallons unaccounted for water

Operating Income and expense
  • Revenue from water sales
  • Operating expenses ( exclude capital expenses unless included in revenue)
  • Net income or loss

Capital Projects
  • Revenue received from loans and grants
  • Expenses associated with the project
  • Available revenue

Graph-in order to track changes in revenues and expenses (operating) MTAS recommends that the city graph on a monthly basis revenue from water sales and expenses. A graph should also be used to track MGD or thousands of gallons pumped from the water plant and the gallons of water billed to customers. The graphs can alert the town of trends in the water system that can be addressed before they reach a critical stage.

Wastewater System-Monthly

Customers
  • Number of customers

Capacity
  • MGD or thousand s of gallons treated at the wastewater treatment plan
  • Gallons of wastewater billed to customers
  • MGD or thousands of gallons of wastewater unaccounted for (may be I&I)

Operating Income and expense
  • Revenue from wastewater sales
  • Operating expenses ( exclude capital expenses unless included in revenue)
  • Net income or loss

Capital Projects
  • Revenue received from loans and grants
  • Expenses associated with the project
  • Available revenue

Graph-in order to track changes in revenues and expenses (operating) MTAS recommends that the city graph on a monthly basis revenue from wastewater sales and expenses. A graph should also be used to track MGD or thousands of gallons of wastewater treated at the wastewater treatment plant and the gallons of wastewater billed to customers. The graphs can alert the town of trends in the wastewater system that can be addressed before they reach a critical stage.

Summary

The information outlined above, along with the appropriate graphs, should tell a board member and system management the current status of the utility and how it is performing over a period of time. By tracking water pumped at the water treatment plant and the amount billed to customers, the town can determine the amount of unaccounted for water loss. If the wastewater system is receiving more than is being pumped at the water treatment plant, the city should address inflow and infiltration into the wastewater system. If expenses of the system over a period of time exceed revenues, a rate adjustment may be necessary. A revenue and expense estimate should be presented for each capital project along with the available balance. The accuracy of master meters should be verified on a regular basis.