Cost of Service Allocation Calculator
Allocate utility operating costs across customer classes using NARUC methodology
What You Can Do
You can develop complete cost-of-service analyses that allocate utility operating expenses across customer classes based on NARUC cost causation methodology. The skill guides you through reclassifying costs by function (generation, transmission, distribution, customer service), selecting defensible allocation drivers tied to actual cost causation, and building rate structures that withstand regulatory scrutiny and legal challenge.
Features
apply the regulatory standard used across US utility commissions
select allocation bases that logically connect costs to the classes causing them
reorganize accounting data by utility function rather than historical accounting categories
identify when customer classes are subsidizing others and quantify the impact
build defensible testimony exhibits and regulatory filings with documented cost allocation logic
compare your allocation approach against peer utilities and regulatory precedents
prepare documented responses to regulatory commission interrogatories on methodology
Example Output
Example 1: Distribution Cost Allocation
- Demand-related costs (transformers, poles, service lines) → allocated by peak demand (kW) across residential, commercial, industrial
- Customer service costs (metering, billing) → allocated by number of customers in each class
- Result: Industrial class reflects $8.2M of the $12M total distribution cost due to higher peak demand, residential bears $2.1M
Example 2: Subsidy Identification
- Current residential rate structure recovers 94% of allocated residential cost of service
- Commercial class recovers 103%, industrial class recovers 107%
- Finding: Residential customers subsidized by $1.8M annually due to outdated rate design
Example 3: Rate Case Testimony Exhibit
- Schedule of allocated operating costs by function and customer class
- Documentation of each allocation driver selection with cost causation rationale
- Comparison to prior year and peer utility methodologies
What's Included
- SKILL.md instruction file with step-by-step NARUC allocation methodology:
- Cost allocation driver selection framework with causation documentation template:
- Customer class cost build-up worksheet (residential, commercial, industrial, special contract):
- Cross-subsidy analysis template to identify misallocations:
- Rate design justification exhibit template for regulatory commission filings:
- Peer utility allocation methodology comparison checklist:
Who It's For
- Rate analysts preparing utility rate case filings before regulatory commissions
- Utility regulatory affairs managers developing rate design strategies
- Energy consultants building defensible cost allocation testimony
- Regulatory commission staff reviewing utility cost of service proposals
- Utility finance teams analyzing rate structure fairness and cost recovery
Best For
- Developing cost-of-service exhibits for regulatory rate cases
- Allocating capital investments across customer classes using cost causation
- Identifying and quantifying cross-subsidies between customer groups
- Building rate design proposals that survive regulatory and legal scrutiny
- Responding to regulatory commission discovery requests on cost allocation methodology
You might also like
You can search Wikidata using four complementary methods: keyword search via the Action API for label-based lookups, semantic/hybrid search through the Vector Database for fuzzy concept matching, direct entity retrieval via Special:EntityData for instant JSON data, and SPARQL queries through WDQS for complex graph relationships and reporting. Each method is optimized for different use cases—from quick entity lookups to multi-table data analysis across millions of linked facts.
by diegosouzapw
You can systematically analyze competitors across feature parity, positioning strategies, pricing models, and interaction patterns. This skill transforms scattered competitive intelligence into a working matrix that reveals differentiation gaps, underserved segments, and strategic opportunities—helping you prioritize roadmap decisions and justify go-to-market positioning with data.
by diegosouzapw
You can structure energy efficiency programs from baseline establishment through full implementation planning. The framework guides you through savings calculation methodologies, financial modeling, stakeholder engagement strategies, and sector-specific program design. You'll produce defensible programs that integrate market incentives, participant behavior analysis, operational constraints, and regulatory requirements into unified implementation strategies that achieve measurable savings targets.
by diegosouzapw
You can analyze renewable energy generation patterns to determine safe penetration levels, forecast real-time grid impacts from variable wind and solar resources, identify transmission constraints limiting renewable export, and design operational procedures that balance stability requirements with renewable integration objectives. The skill helps you quantify grid effects, calculate ramping requirements, and evaluate infrastructure investments needed to support high renewable penetration scenarios.
by diegosouzapw
You can rapidly diagnose medium-voltage distribution faults by analyzing protective device coordination sequences, load flow impacts, and field crew reports within Claude. The skill helps you distinguish between transient and permanent faults, identify whether issues stem from equipment failure or external factors, and validate remediation strategies before implementing risky switching operations. This accelerates your analytical phase so field resources can be deployed efficiently and switching decisions are made with confidence.
by diegosouzapw
You can validate complete rate case filings by cross-referencing testimony claims against supporting exhibits, verifying calculation consistency across 50+ workpapers, checking tariff language compliance with regulatory orders, and detecting missing disclosures or formatting violations. The skill generates detailed compliance reports with specific remediation steps, reducing manual review time from 40+ hours to 6-8 hours while ensuring submissions withstand commission scrutiny.
by diegosouzapw
You can feed Claude raw SCADA alarm dumps and sensor readings from multiple substations or feeders, and receive structured diagnostics that distinguish between nuisance alarms, maintenance signals, and critical grid threats. Claude correlates temporal sequences, applies domain logic around voltage tolerance and protection relay timing, and recommends immediate diagnostic steps or escalation decisions—enabling you to reduce response time and avoid unnecessary field crew dispatch.
by diegosouzapw
You can process complex multivariate utility datasets to identify non-linear relationships between weather, seasonality, calendar effects, and electricity demand. The skill generates calibrated probabilistic forecasts with confidence intervals (10th, 50th, 90th percentiles) that support risk-aware dispatch decisions, unit commitment planning, and reserve procurement—while flagging anomalies and structural shifts in consumption behavior for manual investigation.
by diegosouzapw