In partnership with PLMA, this group is for practitioners from energy utilities, solution providers, and trade allies to share load management expertise and explore innovative approaches to program delivery, pricing constructs, and technology adoption.


Whole Population Rate Analysis for Strategic Rate Design

image credit:
Rob Girvan's picture
Individual Contributor self

20+ years in Enterprise Software Applications in the Energy Industry, including ERP, Meter to Cash, CRM, Customer Engagement.

  • Member since 2013
  • 30 items added with 43,160 views
  • Apr 6, 2020

Whole Population Rate Analysis is the process of calculating bills for an entire utility’s customer population on a current and alternative rate plans using each customer’s individual historic load profile.  Typically used during the rate making process and the rate education processes, the Rate Analysis is useful to both internal and external audiences at utilities.  When fully aggregated, the Whole Population Rate Analysis provides a revenue impact analysis for the utility to measure the impact of transitioning from a current to future rate plan.

  • In 2018, 89 utilities—or nearly half of all major U.S. electric utilities—tried to change electricity rates by filing rate cases with state regulatory commissions; this number was the largest number since 1983. –
  • About half of U.S. investor-owned utilities have optional time varying rates for residential customers. New programs are being tested or talked about in at least ten states… -

With the increase in new rate plans in the utility industry, performing whole population rate analysis is becoming a strategic differentiator.

It may seem that performing a whole population rate analysis is rather straight forward and a capability that every utility already has, given that utilities have data warehouses and data lakes containing historic customer load information and billing engines for calculating customer’s monthly bills.  However, that is not the case.

  • The customer information systems (CIS), the systems responsible for calculating the customer’s bill, were originally set up to calculate customer’s bills only once a month, the generally accepted timeframe for sending bills and requesting payment.
  • Utility bill calculations are extremely data intensive.  The utility has between 720 and 2,880 meter reads per customer per month.  Each customer bill may have 10 line items.  The most complete rate analysis needs to be done over a minimum of 12 months.  For a utility with one million meters, this can equate to trillions of calculations to compare bills for the utility’s entire customer population across multiple rate plans.  CIS systems were sized based on the requirement of calculating bills once per month and just do not possess the necessary computing power.
  • Also, the CIS has a long list of responsibilities beyond bill calculations.  The CIS runs the collections and dunning process, issues and manages work-orders, and provides support to the customer service agents fielding customer calls.  All of these processes need to fit into a tight window.  That window was never intended to include rate analysis.

In short, the current CIS billing engine was not designed for whole population rate analysis.  Reconfiguring the CIS to do so is neither feasible nor cost effective.  In addition, it can put critical CIS functions such as collecting revenue, at risk, by over taxing the CIS system.

To perform whole population rate analysis, utilities can employ an Enterprise Rating Engine.  Enterprise Rating Engines are separate but integrated with the Utility CIS billing engine.  They are calibrated with the CIS so bill calculations match.  The Enterprise Rating Engine can calculate the utility’s whole customer population on multiple rate plans using 12 month (or longer) historic load information at the rate of millions of bills calculated per hour.

“Utilities need to make significant progress to overhaul their rate designs.” –  Whole population rate analysis can help utilities on this journey.

Rob Girvan's picture
Thank Rob for the Post!
Energy Central contributors share their experience and insights for the benefit of other Members (like you). Please show them your appreciation by leaving a comment, 'liking' this post, or following this Member.
More posts from this member
Spell checking: Press the CTRL or COMMAND key then click on the underlined misspelled word.
Matt Chester's picture
Matt Chester on Apr 6, 2020

In 2018, 89 utilities—or nearly half of all major U.S. electric utilities—tried to change electricity rates by filing rate cases with state regulatory commissions; this number was the largest number since 1983

Is there a reason we're seeing a sudden surge in interest in this? Is it the business environment? Or the need to makeup potential technology investment?

Rob Girvan's picture
Rob Girvan on Apr 6, 2020

It may be related to an increase in new types of programs, such as DR, TOU rates, special rates for EVs, community solar programs, and NEM.

Matt Chester's picture
Matt Chester on Apr 7, 2020

Yeah that makes sense-- so while those are still likely customer-friendly programs, they require reconfiguring what the rate-structure looks like. 

Get Published - Build a Following

The Energy Central Power Industry Network is based on one core idea - power industry professionals helping each other and advancing the industry by sharing and learning from each other.

If you have an experience or insight to share or have learned something from a conference or seminar, your peers and colleagues on Energy Central want to hear about it. It's also easy to share a link to an article you've liked or an industry resource that you think would be helpful.

                 Learn more about posting on Energy Central »