SCHEDULE DEMO
ASK UI
SCHEDULE DEMO
ASK UI
SCHEDULE DEMO
ASK UI
SCHEDULE DEMO
ASK UI
Search

Regulatory

Integrated and Streamlined Regulatory Filings


UI’s Regulatory Solution enables you to perform high value tasks quickly and efficiently based on integrated data from multiple systems. It automates filings for rates departments, including Transmission, and enhances visibility in planning of transmission revenue. This information is integrated into the Financial Planning’s revenue forecast. As a result, you’ll shorten regulatory filing processes and collect revenue increases earlier.

With UI’s Regulatory Solution, you can:

  • ► Automate data integration with source systems to leverage the most accurate and up-to-date information from actuals, detailed budget, and plant, and quickly and easily process last-minute changes to a filing scenario.
  • ► Provide users with an integrated, multi-user, transparent, secure corporate system that provides a robust, business-owned framework that quickly and easily models revenue requirements, class cost of service, settlement, and strategic analyses.
  • ► Produce automated, ready-to-file, fully formatted filing schedules, workpapers, and data requests, and allow users to create custom Excel models with formulas intact that are exported directly from the system.


“It saved 2–3 weeks when comparing the previous to most recent rate case project plans. This was driven by automation. In addition, making changes in the past took 2–3 days. In the recent case, I made the changes in 1 day.”


UISG Customer


The Power of our Regulatory Solution

Reduce cycle time

 

Automation of schedules, working models, analyses (GAAP ROE / Regulated ROE), interfaces to source systems, and integration of data enables quick turn-around of filings, last minute changes, what-if scenarios, and forecasts.

Predict when to file

 

Forecasted revenue, rate base, and revenue requirements enable identification of revenue deficiency.

Improve transparency 

 

Drill down through calculations and data summaries to easily answer questions and analyze results.

Lower risk

 

Spreadsheet formula, link, and refresh errors can be avoided by moving spreadsheet logic into UI’s Regulatory solution. Keystroke and cut-and-paste errors are minimized through interfaces and integration.

DOWNLOAD THE SOLUTION SHEET

Learn how UI Solutions Group’s Regulatory Solution is Helping our Clients Succeed

Modules Commonly Integrated into the UI Regulatory Solution

UI partners with our client to bundle the appropriate combination of the 21 modules to address our client’s specific needs and achieve their business outcomes. This way, you get exactly what you need and nothing you don’t.

Regulatory
Accounting
Rates & Tariffs
Regulatory Filings
Targets & Assumptions
Rates & Tariffs
© 2024 Utilities International, Inc.
dba UI Solutions Group
150 N. Riverside Plaza
 Chicago, Illinois 60601
 Phone: 312-580-6200
 Fax: 312-580-6212
 Transparency in Coverage Rule

CLIENT SUCCESS 1 Improving Filing Accuracy and Credibility

Challenge

Confronted with a disallowed rate case caused by errors in a recent filing, our client was directed by management to eliminate errors and win back the confidence of their commissions. However, their filing system provided little transparency or security in the data and calculations, which made auditing their filing package very difficult.

Solution

  • The UI Solutions Group's Regulatory module’s multidimensional calculations and reporting provided management with the ability to produce accurate and auditable regulatory results.
  • The system’s editable logic and formula drilldown created a completely transparent user experience, giving analysts the ability to validate results.
  • UI Solutions Group's automated and ready-to-file Excel Working Model package — including filing schedules, workpapers, and data requests that satisfied commission requirements – avoided the need for manual intervention prior to filing.

Impact

The utility streamlined the time to file a rate case, with improved accuracy that, in turn, improved credibility with the commission. Automated calculations and filing schedules enabled the client’s regulatory staff to do more analyses and make changes as necessary.

CLIENT SUCCESS 2 Setting Regulatory Strategy

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.

CLIENT SUCCESS 3 Analyzing Regulatory Leakage

Challenge

Our client’s regulatory return on equity relative to their financial return was lagging, and without a more detailed system, they were left to impose top-side changes to their expense and capital forecast. This approach lacked the requisite detail to identify and correct specific problem areas.

Solution

  • UI Solutions Group's ROE Reconciliation Analysis Framework provided the ability to calculate the differences in financial and regulatory return at the lowest level of detail.
  • Driver-based analysis allowed analysts to define leakage points such as allocations, averaging methods, and capital structure differences.
  • Standard reports allowed managers to see leakage at varying levels in the ROE calculation.

Impact

The client was able to determine precisely what was contributing to the lower regulatory ROE and make strategic decisions to improve the loss. Better information about the sources of leakage helped the company’s regulatory affairs department work with commissions to suggest changes to the jurisdictional rules.

CLIENT SUCCESS 4 Automating Regulatory Accounting

Challenge

Frequent issues with our client’s regulatory clause system resulted in delays in the close process and inaccurate postings to their accounting system of record. The system lacked the flexibility to handle the data inconsistencies and the agility to turn around a result within a tight two-day window.

Solution

  • UI Solutions Group's SOX-compliant Regulatory solution provided the ability to integrate to the ERP source data, shortening the actualization process significantly and increasing flexibility by automatically adding projects, accounts, and other data with integrated error checking.
  • Analysts were able to use the system to produce a full set of standard reports to clarify calculated results and highlight new unmapped data items for a secure user group.
  • Posting entries to the ERP system became an automated, monthly process once results were analyzed and approved.

Impact

The streamlined actualization process and fast processing time significantly increased the team’s ability to efficiently review the details, helping to mitigate errors and avoid costly rework.

Regulatory Accounting Module

Today’s utility organizations must deliver accurate filings that meet increasingly complex logic and strict regulatory guidelines while operating with constrained timelines and manual spreadsheets. UI’s Regulatory Accounting Module eliminates the burden of spreadsheet management for you and gives you time back for strategic decision-making.

DOWNLOAD THE SOLUTION SHEET
This Module integrates with other modules as part of the following solution:

Financial Planning

Regulatory

Rates & Tariffs Module

Adopting the best toolkit for addressing a myriad of possible tariff changes is essential. UI’s Rates & Tariffs Module allows you to easily define rules and calculations to analyze the impact of various regulatory changes across an entire customer base.

DOWNLOAD THE SOLUTION SHEET
This Module integrates with other modules as part of the following solution:

Regulatory

Regulatory Filings Module

We understand clients need efficient and consistent regulatory filing processes that provide more value-added analysis time. UI’s Regulatory Filings Module supports you in creating reporting packages, performing analysis of supporting testimony results with ease, and more.

DOWNLOAD THE SOLUTION SHEET
This Module integrates with other modules as part of the following solution:

Regulatory

Targets & Assumptions Module

Time constraints during rate case or month-end processes often mean that accuracy is sacrificed to allow process completion. UI’s Targets & Assumptions Module creates consistency among your teams by aligning assumptions across the business to reduce the margin of error even during crunch times.

DOWNLOAD THE SOLUTION SHEET

This Module integrates with other modules as part of the following solution:

Financial Planning