When the City of Bismarck was developing a new pressure zone in the northeast corner of Bismarck, they turned to AE2S to complete a study which evaluated fire flow demand and water quality, among other things through the use of hydraulic modeling. The study compared the costs, benefits, and concerns for eight alternatives that were developed.

Southeast Water Users District (SEWUD), formerly Ransom Sargent Water Users District, was formed due to a host of water supply issues, including both insufficient quantity and unacceptable quality. The system was constructed in four phases, and AE2S assisted SEWUD with funding throughout the project. Funding was received from Garrison Diversion Conservancy District's Municipal, Rural, and Industrial program, as well as loan funds through the United States Department of Agriculture/Rural Development. In addition, in 2005 AE2S prepared a Preliminary Engineering Report (PER) evaluating the potential impacts of the pending Arsenic Rule. The US Environmental Protection Agency ranked the project within the top ten of all potential Arsenic Trioxide Superfund projects, based on the PER. This made the project eligible for funding under the Superfund program.

Since 1999, the City of Grand Forks has utilized AE2S’s financial services staff to review annual and projected revenue sufficiency for the water, wastewater, and stormwater utilities to determine the need for and justification of adjustment to utility rates. These studies projected out 10 years for the water utility and five years for the wastewater and stormwater utilities. In combination with these activities, AE2S also assisted in capital improvement planning (CIP) for these utilities. A spreadsheet model was developed as part of this project, and was updated annually through 2002, when a new model was developed as part of the rate studies. Presentations to the City Council were also included as part of the annual scope.

AE2S conducted a comprehensive Cost of Service Analysis for the City of Rugby's water utility in response to a request to provide water to a regional water system. The analysis was performed utilizing standard methodology for determining the cost of water production based on the projected administrative, operation/maintenance, and depreciation expenses. A spreadsheet was developed for this analysis and serves as a tool for the City to provide an updated estimate of the water supply and treatment cost of consecutive service on an annual basis by adjusting the water utility budget, the recorded water usage, and depreciation values.