Navigate Up
Sign In

What is the RSAT?

The Retail Sales Allocation Tool (RSAT) is a dynamic interface tool for creating transparent, accurate allocations of sales of energy-efficiency products to the utility service territory in which they were installedwithout requiring end-user documentation.  

The tool uses detailed data sources that combine:

  • Retailer profiles
  • Information about products and stocking practices
  • Seventy-two consumer profiles from Experian’s Mosaic© customer segmentation data
  • GIS to map drive times and overlay the multiple data sources with all 142 public- and investor-owned utility service territories in the Pacific Northwest.

The current output of the tool is in the form of an Excel spreadsheet (with a choice of Macros or Filters) to allow for the tool to be used by all parties without the need for additional software or Web access.

For more detailed information, read the RSAT FAQ document.

Why was it developed?
BPA initiated this project:
  • To address utility requests for more accurate and transparent allocation percentages for the Simple Step, Smart Savings regional program 
  • To identify a methodology to move appliance programs upstream and relieve utilities from the laborious practice of Appliance Incentive forms
In November 2011, BPA contracted with Portland Energy Conservation Inc. (PECI) to build the RSAT. The goal of the project was to provide public and investor-owned utilities in BPA’s region with a tool that provides percentage allocation by utility service territory, of sales of energy efficient retail products from a variety of retail outlets.  Initial product categories were: lighting products (CFLs, LED, fixtures, lighting controls), showerheads, and appliances (refrigerators, freezers, clothes washers).
Today, the tool is updated annually and provided to utility customers for feedback prior to release. A current copy is available by contacting your Energy Efficiency Representative. 
Additional Resources
What can the RSAT do?
The RSAT can provide percentage allocations of sales of promoted (or non-promoted) energy-efficiency products in the many product classes that have been researched (i.e. LEDs, lighting fixtures, showerheads, heat pump water heaters, smart thermostats, clothes washers, and dryers). 
What can it not do?
The RSAT cannot predict the volume or quantity of sales of products.
How does BPA intend to use the RSAT?
Based on utility request and support, BPA updates the Simple Steps lighting and showerhead allocations every year, using the annual RSAT update. In 2015, the tool was updated to make upstream appliance measures available as well. The RSAT continues to determine shares of savings for products in the Simple Steps, Smart Savings promotions.
Who do I call if I have questions?

In all of these cases, public utilities should contact your Energy Efficiency Representative or David Murphy, Residential Program Manager at