PowerRep
Regulatory cost accounting for distribution network operators: Simple, transparent and cost-efficient.
PowerRep is an Excel-based tool developed by Hanser Consulting for the efficient and transparent creation of regulatory cost accounting and tariff calculations in accordance with the requirements of the Swiss Federal Electricity Commission (ElCom). PowerRep adapts to the individual starting point regarding raw data. The distribution network operator's employees are empowered to carry out the regulatory process with PowerRep as independently as possible.
Excel-based tool
Step-by-step, intuitive development along the regulatory process
Structure of the output masks according to the specifications of ElCom.
Adapting the input masks to the individual needs and basic data of the distribution network operator
Transparent and comprehensible presentation of interim results
Automatic plausibility checks and comparisons with previous year's values
Creation of the XML file for uploading to the EDES portal
PowerRep consists of the basic module with all essential functions for the annual regulatory process and two optional additional modules.
Company data
Asset overview
Cost accounting network actual and planned (incl. cost allocation and coverage difference overview)
Energy cost accounting: Actual and planned costs (including coverage difference overview)
Pricing network, energy and metering (including evaluations according to ElCom consumption categories)
EDES interface
Base
Fixed asset accounting
Optional add-on module for managing regulatory fixed asset accounting
Detailed fixed asset accounting per asset category
Detailed analyses (including asset schedule)
Annual accounts
Optional add-on module for preparing the regulatory annual financial statements
Profit and loss statement
Balance sheet
Practical application
-
Step-by-step, intuitive development along the regulatory process
-
Enabling the employees of the distribution network operator to carry out the regulatory process independently.
Regulatory safety
-
Structure of the output masks according to the ElCom specifications
-
Creating the XML file for upload to the EDES portal
Individual adaptability
-
Adapting the input masks to the specific needs and basic data of the distribution network operator
Quality assurance and plausibility check
-
Automatic plausibility checks
-
Comparisons with previous year's figures
1. Initialization
Offer, planning
2. Analysis, rough concept
Data basis, requirements
3. Detailed concept
Prototype input masks
6. Training
Ideally, within the regulatory process
5. Tests
Functional tests, plausibility checks of results
4. Implementation
Setting up input masks, integrating data
Distribution network operators of any size, with or without their own production facilities
Pure electricity supply companies and cross-utilization companies
Input data
Recording of all relevant basic data per process step
Direct transfer of data from the EDM, billing and accounting system
Transparent, traceable processing and documentation of data throughout the entire process.
Fixed asset accounting
Quantity structure and values by categories and network levels
Optional: complete regulatory accounting for each property
Actual cost accounting
Analysis of energy and power flows
Calculation of the rolling key and determination of the eligible costs
Coverage gap analysis with planning for the balancing of coverage gaps in subsequent years
Cost accounting
Sales target for the planned tariff year
Calculation of planned cost allocation and variance analyses
Determination of the quantities and costs eligible for regulatory approval, including production costs, taking into account statutory minimum shares for renewable energy.
Pricing
Determination of tariff rates per product for network, metering and basic energy supply
Mapping of variants, deviation analyses and evaluation of the effects on the ElCom tariff models
Data plausibility check
-
Database with previous year's values for comparisons and plausibility checks of current values
