
Tariff Design Impact Modeling for Rate Analysts
Model tariff revenue, load, and bill impacts with regulatory-ready sensitivity analysis
What You Can Do
You can construct multi-scenario tariff impact models that forecast revenue adequacy, customer bill distributions by segment, and demand response outcomes under proposed rate designs. The skill helps you translate tariff mechanics into transparent financial projections, regulatory documentation, and stakeholder communication frameworks that satisfy utility commission requirements and withstand rate case scrutiny.
Features
model 2–5 tariff alternatives with parallel financial outcomes for comparison
calculate residential, commercial, and industrial customer impacts with percentile distributions
project peak demand and consumption shifts under time-of-use and demand-response tariffs
stress test tariffs across weather, usage, and cost scenarios with breakeven thresholds
generate findings, assumptions, and cost allocation support for tariff filings
create executive summaries, visual impact charts, and testimony-ready talking points
allocate fixed and variable costs across rate classes using embedded cost-of-service methodology
verify tariff design recovers authorized revenue under forecasted load conditions
Example Output
Revenue Impact Summary:
- Current tariff revenue: $145.2M | Proposed TOU tariff revenue: $148.7M (+2.4%) | Conservative case: $142.1M (−2.1%)
Residential Bill Impacts (Annual):
- Average bill change: +$12/month (+3.2%)
- 25th percentile (low usage): −$8/month | 75th percentile (high usage): +$28/month
Sensitivity Table (Peak Demand Reduction %):
| Scenario | 0% Reduction | 5% Reduction | 10% Reduction | 15% Reduction |
|---|---|---|---|---|
| Base Case | $148.7M | $151.2M | $153.8M | $156.4M |
| Weather Stress | $142.1M | $144.1M | $146.3M | $148.6M |
What's Included
- SKILL.md: Complete tariff modeling framework with regulatory compliance protocols
- Revenue Impact Template: Multi-scenario financial model with sensitivity matrices
- Bill Impact Workbook: Customer segment analysis with percentile distributions and decile charts
- Stakeholder Communication Deck Outline: Executive summary structure, visual impact guidelines, and talking point frameworks
- Sensitivity Analysis Checklist: Stress-test parameters, weather/demand/cost scenarios, and breakeven thresholds
- Cost Allocation Worksheet: Embedded cost-of-service methodology with fixed/variable cost splits
Who It's For
- Rate analysts and tariff designers — model rate structures and quantify regulatory impacts
- Utility regulatory affairs professionals — prepare rate case filings and compliance documentation
- Energy economists — forecast demand elasticity and revenue adequacy under tariff changes
- Utility planning and strategy teams — evaluate tariff scenarios for board presentations and long-term planning
- Stakeholder engagement and communications specialists — translate complex tariff mechanics into executive summaries
Best For
- Tariff alternative comparison and scenario modeling — evaluate 2+ rate design options with parallel financial projections
- Regulatory rate case preparation — build defensible revenue models and cost allocation support for utility commission filings
- Customer bill impact forecasting — quantify impacts across residential, commercial, and industrial segments with distribution analysis
- Sensitivity and stress testing — model outcomes under weather extremes, demand volatility, and cost escalation scenarios
- Stakeholder workshop and testimony preparation — create clear, non-technical communication materials and assumption documentation







