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 process complex transmission fault data—voltage sags, current transients, relay operations, and SCADA logs—to extract causal patterns and evaluate protection response effectiveness. Claude accelerates your diagnostic timeline from hours to minutes, surfacing hidden vulnerabilities and cascading failure risks that routine analysis misses. You'll validate protection coordination, assess equipment damage risk, and generate prioritized corrective actions backed by systematic fault sequence analysis.
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 analyze residential energy consumption patterns, audit findings, and building characteristics to generate prioritized retrofit recommendations ranked by payback period, seasonal impact, and cost-effectiveness. The skill calculates ROI metrics (simple payback, NPV, IRR), identifies compliance gaps against energy codes and incentive programs, and sequences interdependent measures to optimize retrofit strategy while accounting for behavioral factors and equipment lifecycles.
by diegosouzapw
You can input residential property characteristics and energy audit findings to receive systematically ranked retrofit recommendations prioritized by ROI and payback period. Claude analyzes multiple upgrade pathways, calculates realistic energy savings projections, compares financing options, and generates professional proposals that translate complex efficiency metrics into actionable upgrade sequences tailored to client budgets and goals.
by diegosouzapw
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 conduct structured residential energy assessments by inputting building characteristics, utility consumption patterns, and occupant behavior data. Claude analyzes this information to identify retrofit opportunities, quantify energy savings potential, calculate payback periods, and generate prioritized recommendations ranked by ROI. The skill handles complex interdependencies between measures (like how air sealing improves HVAC efficiency) to ensure financially sound retrofit packages.
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
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