# Rate Case Automation

*/Opportunities/Rate_Case_Automation*

## Opportunity Overview

**Wedge**: Target mid-sized water and wastewater utilities filing with state Public Utility Commissions first. These entities possess simpler financial structures than electric utilities but still face rigorous filing formats, allowing for faster validation of the output. Expansion proceeds to complex electric and gas utilities, followed by automating the data request and interrogatory response phases during active litigation.
**Timing**: Large context window models ingest thousands of pages of historical commission rulings, precedent filings, and financial schedules simultaneously. Previous iterations failed on tabular financial data, but current reasoning models reliably map unstructured text to rigid regulatory formats without hallucinating numbers.
**Why This I C P**: Investor-Owned Utilities and large municipal utilities face high, recurring consultant costs and strict statutory deadlines for every filing. Their regulatory teams hold direct budget authority to buy tools that replace the expensive billable hours of outside counsel and economic consultants.
**Size Of Prize**: There are roughly 3,300 electric, gas, and water utilities in the US that routinely file rate cases. Assuming an average annual spend of $150k on rate case preparation tools and consultant offset per utility, this yields an addressable market of approximately $500M per year.
**Gap Narrative**: Public utilities spend 12 to 18 months manually compiling financial data, operational metrics, and legal arguments to file rate cases with state commissions. Regulatory affairs teams lack a dedicated system to map raw ERP data to commission-specific schedules and draft supporting testimony, forcing reliance on fragile spreadsheets and external consultants.
**Defensibility**: Defensibility stems from deep workflow lock-in and a proprietary mapping engine linking utility-specific charts of accounts to state-specific regulatory schedules. Over time, the system accumulates a private repository of successful legal arguments and commission preferences, creating high switching costs as the utility embeds the platform into its core compliance cadence.
**Why This Thesis**: Service-as-Software aligns perfectly because utilities require a finished, compliant filing package rather than another blank-canvas software tool. An agentic system that ingests raw utility data and outputs commission-ready schedules replaces the outsourced consultant layer directly and delivers the final work product.

## Opportunity Linked Thesis

**Thesis**: [Software](/Theses/Software)

## Opportunity Linked I C P

**Icp**: [Regulated Utility](/CompanyTypes/Regulated_Utility)

## Opportunity Market Sizing

_Illustrative — target and order-of-magnitude estimate figures, not an achieved track record (this Thing is concept-stage)._

**S A M**: ~$300-500M US investor-owned and large municipal utility segment
**S O M**: ~$15-35M
**T A M**: ~3,000 major regulated utility entities × ~$300k-500k/yr ≈ ~$900M-1.5B
**Growth Rate**: ~10-15%/yr, driven by rising capital expenditures for grid modernization forcing more frequent rate case filings
**Paid Comparable Spend**: ~$2M-5M per rate case paid to external economic consultants, regulatory counsel, and internal compliance headcount

## Opportunity Incumbents

- [PowerPlan Regulatory Suite](/Products/PowerPlan_Regulatory_Suite) — Tool
- [Microsoft Excel Models](/Products/Microsoft_Excel_Models) — Spreadsheet
- [Guidehouse Rate Consulting](/Products/Guidehouse_Rate_Consulting) — Service
- [ScottMadden Regulatory Support](/Products/ScottMadden_Regulatory_Support) — Service
- [Oracle Utilities EPM](/Products/Oracle_Utilities_EPM) — Tool
- [Concentric Energy Advisors](/Products/Concentric_Energy_Advisors) — Service

## Opportunity Win Conditions

**Kill Thresholds**:
- Implementation time exceeds 90 days for initial deployments
- Fewer than 40% of required rate case schedules are completed inside the platform
- Pilot conversion fails to secure a minimum $150k annual contract
- System requires more than 10 hours of human-in-the-loop data mapping per customer per month
**Leading Metrics**:
- Time-to-first-generated-schedule
- Percentage of rate schedules produced without manual Excel overrides
- Weekly active days by regulatory affairs analysts
- Data ingestion error rate per general ledger upload
**What Proves Right**: Utilities use the platform to ingest financial ledgers and automatically output the standardized testimony and margin schedules required for state public utility commissions. Regulatory analysts operate within the system to adjust capital expenditure assumptions and rerun cost-of-service models instead of exporting data to Excel. Customers pay $300k annual licenses because the system directly absorbs the workload previously billed by external economic consultants.
**What Proves Wrong**: Regulatory teams reject the automated schedules and immediately export raw data back into legacy Excel models for manual adjustment. The software fails to parse bespoke utility data schemas, forcing implementation cycles to stretch beyond six months. End-users bypass the testimony generation module entirely and manually draft filings alongside external regulatory counsel.

## Opportunity Build Profile

**Hardest Part**: Ensuring deterministic cross-referencing between dynamic financial cost-of-service models and narrative legal text. A single hallucinated or mismatched number between a source spreadsheet and a testimony paragraph invalidates the entire regulatory filing.
**Min Viable Scope**: Build exclusively for generating Direct Testimony narratives for investor-owned electric utilities using finalized Excel cost-of-service outputs. Leave out natural gas, water utilities, data-gathering workflows, and intervenor response generation.
**Cold Start Problem**: Acquiring structurally mapped historical rate cases linked to private utility financial models requires deep domain access before the system drafts anything useful. Break this by partnering with a single specialized rate-case consultancy to ingest their proprietary mapping of past filings as the foundational dataset.
**Time To First Value**: 3 to 4 months of data integration and template mapping before drafting the first usable testimony.
**Data Moat Available**: true
**Technical Difficulty**: High

## Neighborhood

### Where the gap lives

- [Utilities](/Industries/Utilities) — latent gap · Industries
- [Regulatory affairs directors](/Customers/Regulatory_affairs_directors) — latent gap · Customers
- [Water, Sewage and Other Systems](/Industries/Water,_Sewage_and_Other_Systems) — latent gap · Industries
- [Utility compliance officers](/Customers/Utility_compliance_officers) — latent gap · Customers

### Surfaced from

- [Investor-Owned Electric & Gas Utility](/CompanyTypes/Investor-Owned_Electric_&_Gas_Utility) — surfaces · CompanyTypes
- [Enterprise Investor-Owned Utility (Electric & Gas)](/CompanyTypes/Enterprise_Investor-Owned_Utility_(Electric_&_Gas)) — surfaces · CompanyTypes

### Applies thesis

- [Investor-Owned Utility](/CompanyTypes/Investor-Owned_Utility) — applies thesis · CompanyTypes
- [Regulated Utility](/CompanyTypes/Regulated_Utility) — applies thesis · CompanyTypes
- [Regulated Utility Company](/CompanyTypes/Regulated_Utility_Company) — applies thesis · CompanyTypes

### Incumbent in

- [Microsoft Excel](/Software/Microsoft_Excel) — incumbent in · Software
- [Charles River Associates](/Products/Charles_River_Associates) — incumbent in · Products
- [Guidehouse Rate Consulting](/Products/Guidehouse_Rate_Consulting) — incumbent in · Products
- [In-House VBA Macros](/Products/In-House_VBA_Macros) — incumbent in · Products
- [OpenText Documentum](/Products/OpenText_Documentum) — incumbent in · Products
- [PowerPlan Regulatory Suite](/Products/PowerPlan_Regulatory_Suite) — incumbent in · Products
- [Workiva Wdesk](/Products/Workiva_Wdesk) — incumbent in · Products
- [ScottMadden Regulatory Support](/Products/ScottMadden_Regulatory_Support) — incumbent in · Products
- [Microsoft Excel Models](/Products/Microsoft_Excel_Models) — incumbent in · Products
- [Oracle Utilities EPM](/Products/Oracle_Utilities_EPM) — incumbent in · Products
- [Concentric Energy Advisors](/Products/Concentric_Energy_Advisors) — incumbent in · Products
- [Fragmented Excel Models](/Products/Fragmented_Excel_Models) — incumbent in · Products
- [Workiva Statutory Reporting](/Products/Workiva_Statutory_Reporting) — incumbent in · Products
- [NERA Economic Consulting](/Products/NERA_Economic_Consulting) — incumbent in · Products

### Embodies

- [Software](/Theses/Software) — embodies · Theses

### Similar Opportunities

- [Rate Case Author](/Opportunities/Rate_Case_Author) — similar · Opportunities
- [Rate Case Filing Service](/Opportunities/Rate_Case_Filing_Service) — similar · Opportunities
- [Rate Docket Synthesizer](/Opportunities/Rate_Docket_Synthesizer) — similar · Opportunities
- [Rate Docket Synthesizer](/Industries/Utilities/Opportunities/Rate_Docket_Synthesizer) — similar · Opportunities
- [Rate Case Automation](/Industries/Utilities/Opportunities/Rate_Case_Automation) — similar · Opportunities
- [Rate Case Agent](/Opportunities/Rate_Case_Agent) — similar · Opportunities
- [Rate Case Drafter](/Industries/Utilities/CompanyTypes/Enterprise_Investor-Owned_Utility_(Electric_&_Gas)/Opportunities/Rate_Case_Drafter) — similar · Opportunities
- [Rate Case Automation](/Industries/Utilities/CompanyTypes/Enterprise_Investor-Owned_Utility_(Electric_&_Gas)/Opportunities/Rate_Case_Automation) — similar · Opportunities
- [Rate Testimony Agent](/Industries/Utilities/CompanyTypes/Investor-Owned_Electric_&_Gas_Utility/Opportunities/Rate_Testimony_Agent) — similar · Opportunities
- [Rate Case Data Compiler](/Industries/Utilities/CompanyTypes/Regional_Municipal_Water_&_Sewer_Authority/Opportunities/Rate_Case_Data_Compiler) — similar · Opportunities
- [NERC Audit Service](/Opportunities/NERC_Audit_Service) — similar · Opportunities
- [Grid Capital Modeler](/Industries/Utilities/Opportunities/Grid_Capital_Modeler) — similar · Opportunities
- [Regulatory Change Monitor](/Knowledge/Law_and_Government/Opportunities/Regulatory_Change_Monitor) — similar · Opportunities
- [Collections Negotiation Agent](/Industries/Utilities/Opportunities/Collections_Negotiation_Agent) — similar · Opportunities
- [NERC Audit Agent](/Opportunities/NERC_Audit_Agent) — similar · Opportunities
- [NERC Reporting Engine](/Industries/Utilities/CompanyTypes/Rural_Electric_Cooperative/Opportunities/NERC_Reporting_Engine) — similar · Opportunities
- [RUS Compliance Automation](/Opportunities/RUS_Compliance_Automation) — similar · Opportunities
- [Automated Compliance Reporting for Energy](/Opportunities/Automated_Compliance_Reporting_for_Energy) — similar · Opportunities
- [Security Audit Generator](/Metrics/Requirements_Traceability_Index/Industries/Critical_Infrastructure/Opportunities/Security_Audit_Generator) — similar · Opportunities
- [Grid Capital Modeler](/Opportunities/Grid_Capital_Modeler) — similar · Opportunities