EFC Resources: Wisconsin Residential Water Rates Dashboard

Wisconsin Residential Water Rates Dashboard

Subject: Financial Data, Management, Rates
Program: Drinking Water and Wastewater
Tool type: Dashboard
Date: 11/10/2015
Version: 2015; v1.8
Tool: Click to run tool in browser (Flash)

 **Note: This dashboard uses Flash, which is incompatible with the Chrome web browser. Please use another browser, such as Mozilla Firefox, to view this dashboard.**

This interactive Rates Dashboard is designed to assist utility managers, finance directors, Board members, state and local officials, reporters, and customers in comparing their residential water and wastewater rates against multiple characteristics, including utility finances, system size, customer base demographics, and geography. Rates data for this dashboard are drawn from the 2015 residential drinking water rates data collected by the Public Service Commission (PSC) of Wisconsin's Division of Water, Telecommunications, and Consumer Affairs (DWTCA).

This Rates Dashboard was constructed as part of the Smart Management for Small Water Systems nationwide project of the Environmental Finance Center Network (EFCN). The EFCN is composed of numerous Environmental Finance Centers around the country, including the Environmental Finance Center at the University of North Carolina, Chapel Hill, which created this dashboard. This dashboard was created under a cooperative agreement with the United States Environmental Protection Agency.

View a video tutorial on how to use the Wisconsin interactive rates dashboard.

The dashboard includes residential drinking water rate structures effective as of September 2015, for over 575 public utilities in the state of Wisconsin. These residential drinking water rates for Wisconsin, evaluated at any increment of 1,000 gallons per month of usage between zero and 15,000 gallons per month, can be compared with:

  • All other water utilities in the state,
  • Utilities of the same size,
  • Utilities with the same water source,
  • Utilities using the same rate structure type,
  • Utilities serving communities with similar median household incomes,
  • Utilities within 50 miles,
  • Utilities in the same river basin,
  • Utilities with similar revenue generation, and
  • Utilities in the same Regional Planning Commission area.

The following measures for the selected utility are compared to key indicators or to the utilities within the selected comparison group:

  • Monthly drinking water combined bill for the selected consumption amount,
  • Conservation pricing signal (marginal price when going from 10,000 to 11,000 gallons per month),
  • Monthly bill as a percentage of median household income (MHI) for the community, and
  • Ratio of operating revenues to operating expenses (when available).

You can compare the monthly bill charged for the selected monthly amount of usage. You can also raise rates by up to 100% and observe the (hypothetical) effects on the utility's rates, conservation pricing signal, operating ratio, and rate affordability.

In addition, system financial health and customer demographic profiles are provided for utilities where data are available.

 

Troubleshooting

The dashboard is is an Adobe Flash (swf) file that should automatically run on your web browser once it is launched. The dashboard might take 20 to 40 seconds to load on your browser. If you are having trouble accessing the dashboards, try the following steps:

  1. Download the latest version of Adobe Flash Player (9.0 or later) on the browser you are using to access the dashboards (Chrome, Internet Explorer, Firefox, Safari, etc.)
  2. If an error message appears warning about running scripts, accept the scripts to launch the dashboards.
  3. If you are still having trouble accessing the dashboard, try switching to another web browser (we recommend using Chrome or Internet Explorer). You may need to download the latest version of Adobe Flash Player again before you proceed.
  4. If you are still unable to launch the dashboard, please email David Tucker.

 

Project page: Utility Financial Sustainability and Rates Dashboards

Project page: Smart Management for Small Water Systems

rates, dashboard, Wisconsin, drinking water, Water Dashboard, water rates, financial indicators, benchmarking, operating ratio