David Hughes, PE, vice president of Woodard & Curran, and Denise Cameron, PE, project engineer, found that more than 30% of Quincy, Mass.'s master meter water use was not being billed to customers — and that the city's department of public works had few effective management reporting tools to ensure the accuracy and reliability of its billing systems. Photo: Woodard & Curran
In the last year, the Boston suburb of Quincy, Mass., has seen a 50% reduction in nonrevenue water as the result of several initiatives at the city's department of public works, including random meter testing, an inoperable meter identification program, and location and repair of water main leaks.
Just a couple of years ago, though, the department's operations weren't so efficient.
The water and sewer budgets had been managed within the $200 million city budget, but with annual operating costs for the departments hovering around $40 million, the city created an enterprise fund to separate those budgets from the general fund and ensure that water and sewer ratepayers were not subsidizing general taxpayers.
But the enterprise fund revealed that the water and sewer receivables did not cover costs, and the department projected a $4 million deficit for the 2008 fiscal year. So in February 2008 the city contracted with consulting firm Woodard & Curran to perform a four-month audit to identify the causes of the deficit and provide a road map for bringing the accounts and department performance back into balance.
Quincy is one of more than 61 Massachusetts Water Resource Authority member communities, representing more than 2.5 million residents and 5,500 large industrial users.
With no treatment systems of its own, Quincy purchases nearly 10 million gallons of water daily and discharges about 16 mgd of sewage, which is pumped through the Nut Island Headworks in Quincy to the Deer Island treatment facility 7 miles away. Quincy manages the water and wastewater infrastructure in the city, much of which consists of cast-iron pipes installed in the 1920s. It also handles all billing and customer service for 22,000 resident accounts and about 700 commercial accounts, totaling more than 90,000 bills issued and collected each year.
“To regain control we needed to understand the critical issues and how to address them,” says Quincy Department of Public Works Business Manager Michael Coffey.AUDIT PROCESS
The audit was conducted by a team of three consultants with support from subcontractors such as a certified public accountant for financial analysis for report creation. The team analyzed the city's water and sewer billing and management systems beginning with the authority's 11 master meters (five for water and six for sewer) and continuing through customer service activities such as bill inquiries, service calls, and meter rereads.
After Quincy's 7,500 monthly bills are generated, the process begins with bill payment and extends through billing inquiry, the abatement process, meter rereads, and maintenance requests. The audit — which analyzed the entire process — revealed that inaccurate or inconsistent billing had a snowball effect for billing staff. Bill inquiry or abatement requests often forced staff to focus on reactive dispute resolution. Without adequate data archiving, justifying some bills proved difficult.
The audit analyzed the internal systems, processes, and personnel, including five meter-reading and three billing staff associated with each water and sewer billing and management activity. The audit team established priorities to address the most pressing problems and areas offering the greatest return on investment.
With more than half of its meters at least 30 years old, the department needed to upgrade more than 17,000 meters for more efficient data, and it secured a $14.9 million loan from the state revolving fund to finance the replacements and other improvements. Review of meter-reading data uncovered low meter-reading productivity (some meter-reading employees were logging few accounts per day), inefficient meter-reading schedules and routes that exacerbated the productivity issues.
Quincy had been using several different meter-reading methods, including radio reads and older “pin and wand” meters, making accurate data upload problematic. That contributed to additional estimated reads being entered, a lack of accessible and convenient water-use data, insufficient quality control data check methods, and increased workload for billing staff.