Challenge
Producing an accurate forecast of revenue deficiency proved challenging for our client’s outdated regulatory systems. It was critical to know when to file and how much additional revenue was needed in order to improve rate case outcomes, but they lacked the tools to quickly forecast and evaluate strategic scenarios.
Solution
- UI Solutions Group's Strategic Modeling solution enabled our client to model regulatory results over a five-year period providing the detail needed to set regulatory strategy.
- Integrating actual and forecast data from multiple enterprise systems, user spreadsheets, and manual inputs proved critical to defining a regulatory system of record.
- The web-based dashboarding functionality allowed management to run dozens of ad-hoc scenarios quickly, showing incremental results to their base case for rate base, revenue deficiency, and return across their jurisdictions.
Impact
Drastically improved forecast accuracy and timely what-if scenarios allowed management to be confident of potential rate case outcomes and make better rate case filing decisions that minimized lost revenues.
