Docstoc

Statutory Accounts Template - Excel

Document Sample
Statutory Accounts Template - Excel Powered By Docstoc
					              Electricity Distribution Network Service Providers
              Annual Reporting Template
             Table of contents
1. Introduction                        4. Dissaggregation statements            7. Service performance information

            1.1 Instructions                    4.1 Income statement               7.1 Performance incentive scheme


         1.2 Business details                    4.2 Balance sheet                       7.2 Major event days


2. Expenditure                                     4.3 Cash flows                      7.3 Other excluded items


        2.1 Capital expenditure          4.4 Asset dissagregation statement     8. Passthroughs

       2.2 Operating expenditure       5. Cost allocation                          8.1 Network support passthrough


    2.3 Material projects & programs            5.1 Causal allocation                   8.2 Cost passthroughs


        2.4 Capital contributions             5.2 Non-causal allocation         9. Relationships with other entities

3. Regulatory financial statements     6. Regulatory asset base                   9.1 Relationships with other entities


          3.1 Income statment            6.1 Prop, plant & eqp reconciliation     9.2 Expenditures with other entities


           3.2 Balance sheet                  6.2 Asset aging schedule          10. Regulatory adjustment

       3.3 Cash flows statement              6.3 Network characteristics          10.1 Regulatory adjustment journals
Australian Energy Regulator                                                                                                         DNSP Annual Reporting Template




  Contents

 Instructions
                                                                               Instructions
                              A DNSP must fill out and submit the pro formas in this spreadsheet for each regulatory year 80 business days after the
                              end of that year unless specified otherwise.
                              Please follow the instruction below when completing the pro formas in this spreadsheet:
                              1. Complete the 1.2 (business details) pro forma first. This sheet is linked to other pro formas and will automatically
                              update cells, such as the DNSP name.

                              2. Only input data into the orange and the yellow cells within the marked grids.
                              The orange cells indicate qualitative inputs;
                              The yellow cells indicate quantitative inputs;
                              Formulas have been included in the pro formas, so totals will be automatically calculated.
                              3. All values in the previous regulatory year must be in nominal terms and all values in future regulatory control years
                              must be in real terms.




8/18/2011                                                 12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                         Template: 1.1, Page 2 of 57
Australian Energy Regulator                                                                                                                                            DNSP Annual Reporting Template




                                                                Business details (1.2)
                                                                  Business details
             Contents
             Contents

            Instructions
            Instructions




                              Instructions
                              A DNSP must complete the following business details pro forma before continuing to enter data or values in any other pro formas statements. This pro forma
                              is linked to other pro formas in the spreadsheet and automatically generates column headings.


                              Table 1 - Submission particulars input sheet


                                                                                           Business details

                              Trading name
                              Australian business number



                              Business address
                                                                     Street no. and name
                                                                     Suburb
                                                                                                           State                                  Postcode

                              Postal address
                                                                     Street no. and name
                                                                     Suburb
                                                                                                           State                                  Postcode



                              Contact name/s
                              Contact phone/s
                              Contact email address/s




                                                                                            Reporting year

                              Regulatory reporting year                                                    Version Number




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                     Template: 1.2, Page 3 of 57
Australian Energy Regulator                                                                                                                                               DNSP Annual Reporting Template




                    Contents

                   Instructions
                                                                   Capital expenditure (2.1)


                                    Instructions

                                    Only enter capital expenditure for assets that are part of the regulated asset base.




                                    Table 1: System asset expenditure by asset type and cost drivers


                                     Network extensions ($000)
                                                                                      subtransmission                      distribution HV          distribution LV              total

                                                          lines and cables        overhead       underground         overhead      underground   overhead   underground

                                                                       CBD
                                                                     urban
                                                                rural short
                                                                 rural long
                                            substations and transformers
                                                                       CBD
                                                                     urban
                                                                      rural
                                           buildings, land and easements
                                                         communications
                                                                    meters
                                                      other system assets
                                                            public lighting
                                                                      Total                                                                                               $           -




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                       Template: 2.1, Page 4 of 57
Australian Energy Regulator                                                                                                                              DNSP Annual Reporting Template




                                     Increased load management ($000)
                                                                                subtransmission           distribution HV          distribution LV              total

                                                         lines and cables     overhead   underground   overhead   underground   overhead   underground

                                                                       CBD
                                                                     urban
                                                                rural short
                                                                 rural long
                                            substations and transformers
                                                                       CBD
                                                                     urban
                                                                      rural
                                           buildings, land and easements
                                                         communications
                                                                    meters
                                                      other system assets
                                                            public lighting
                                                                      Total                                                                              $           -

                                     Renewal/replacement ($000)
                                                                                subtransmission           distribution HV          distribution LV              total

                                                         lines and cables     overhead   underground   overhead   underground   overhead   underground

                                                                       CBD
                                                                     urban
                                                                rural short
                                                                 rural long
                                            substations and transformers
                                                                       CBD
                                                                     urban
                                                                      rural
                                           buildings, land and easements
                                                         communications
                                                                    meters
                                                      other system assets
                                                            public lighting
                                                                      Total                                                                              $           -




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                      Template: 2.1, Page 5 of 57
Australian Energy Regulator                                                                                                                                     DNSP Annual Reporting Template




                                     Service improvement ($000)
                                                                                subtransmission              distribution HV             distribution LV               total

                                                         lines and cables     overhead   underground     overhead       underground   overhead   underground

                                                                       CBD
                                                                     urban
                                                                rural short
                                                                 rural long
                                            substations and transformers
                                                                       CBD
                                                                     urban
                                                                      rural
                                           buildings, land and easements
                                                         communications
                                                                    meters
                                                      other system assets
                                                            public lighting
                                                                      Total                                                                                     $           -
                                                                                                                               Total system asset expenditure   $           -



                                    Table 2: Non-system asset expenditure ($'000)

                                    cost category                                             dollar value ($000)
                                    IT systems
                                    furniture, fittings, plant & equipment
                                    motor vehicles
                                    buildings
                                    land
                                    other non-system assets
                                    share of corporate assets
                                    Total non-system capex                                $                         -




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                             Template: 2.1, Page 6 of 57
Australian Energy Regulator                                                                                                                                                   DNSP Annual Reporting Template




                                    Table 3: Total capex


                                    cost category                                           dollar value ($000)
                                    System assets                                       $                              -
                                    Non-system assets                                   $                             -
                                    Total capex                                         $                             -



                                    Table 4: Definitions

                                    cost drivers                      definition                                                                                              Source
                                                                      Capital expenditure for the construction of assets extending the existing network and new customer
                                    Network extensions                connections. This category does not include Increased load management expenditure,                      AER
                                                                      Renewal/replacement expenditure and Service improvement expenditure.

                                                                      Capital expenditure relating to the management of electricity demand growth and/or movement in
                                                                      peak demand on existing network assets. This growth in demand may be attributable to existing
                                    Increased load management         customers, new customers connecting, or the movement of customers around the network. This              AER
                                                                      expenditure does not include Network extensions expenditure, Renewal/replacement expenditure
                                                                      and service improvement expenditure.
                                                                      Capital expenditure the primary purpose of which is for the replacement of existing network assets
                                                                      due to age, technological requirements, or redundancy. This category does not include Network
                                    Renewal/replacement                                                                                                                       AER
                                                                      extensions expenditure, Increased load management expenditure and Service improvement
                                                                      expenditure.

                                                                      Capital expenditure, the primary purpose of which is to improve network reliability and quality. This
                                    Service improvement expenditure   category does not include Network extentions expenditure, Increased load management expenditure AER
                                                                      and Renewal/replacement expenditure.

                                    asset categories                  definition                                                                                              Source
                                                                      Assets that distribute electricity at voltage levels between the transmission system and the HV
                                    Subtransmission                   section of the network. The connection boundaries are the outgoing terminals at the transmission        ESCV
                                                                      terminal station to the outgoing terminals of the HV circuit breakers at the zone substations.

                                                                      Overhead and underground lines and cables that serve a distribution function, including distribution
                                    Distribution lines                feeders, and the low voltage distribution system. These lines typically have a voltage of less than     QCA
                                                                      33kV.

                                                                      High Voltage: Assets that distribute electricity at voltage levels between the subtransmission and LV
                                    HV                                sections of the network. The connection boundaries are the outgoing terminals of the HV circuit         ESCV
                                                                      breakers at the zone substations to the LV terminals of the HV to LV distribution transformers.




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                             Template: 2.1, Page 7 of 57
Australian Energy Regulator                                                                                                                                               DNSP Annual Reporting Template




                                                                   Low Voltage: Assets that distribute electricity at low voltage. The connection boundaries are the LV
                                    LV                                                                                                                                    ESCV
                                                                   terminals of the HV to LV distribution transformers to the supply point.

                                                                   Central Business District: Assets that are primarily composed of underground circuits supplying the
                                    CBD                                                                                                                                   ESCV
                                                                   central business district.

                                                                   a feeder supplying predominantly commercial, high-rise buildings, supplied by a predominantly
                                    Urban                          underground distribution network containing significant interconnection and redundancy when            ESCV
                                                                   compared to urban areas.

                                                                   a feeder, which is not a CBD feeder, with actual maximum demand over the reporting period per total
                                    Rural - short                                                                                                                      ESCV
                                                                   feeder route length greater than 0.3 MVA/km.


                                    Rural - long                   a feeder which is not a CBD or urban feeder with a total feeder route length less than 200 km.         ESCV


                                    Substations and transformers   a feeder which is not a CBD or urban feeder with a total feeder route length greater than 200 km.


                                                                   Regulatory asset base
                                                                   Nature of regulatory asset base
                                                                                                                                                                          NER clause
                                    Regulatory asset base          (a) The regulatory asset base for a distribution system owed, controlled or operated by a Distribution
                                                                                                                                                                          6.5.1
                                                                   Network Service Provider is the value of those assets that are used by the provider to provide
                                                                   standard control services , but only to the extent that they are used to provide such services.

                                                                   A direct control service that is subject to a control mechanism based on a Distribution Network        NER Chapter
                                    Standard control service
                                                                   Service Provider's total revenue requirement.                                                          10.
                                                                                                                                                                          NER Chapter
                                    System assets                  Assets comprising part of the distribution system as defined in the NER.
                                                                                                                                                                          10.

                                                                   Any expenditure, which for the purpose of the Statutory Accounts has been or is to be included in the
                                                                   Fixed Asset Base of the Distribution Business, provided that the expenditure conforms with at least
                                                                   one of the following:
                                                                   • The expenditure relates to the purchase, development or construction of a new asset
                                    capex or capital expenditure                                                                                                         ESCV
                                                                   • The expenditure will increase the capacity or functionality of the distribution assets
                                                                   • The expenditure will significantly reduce the ongoing maintenance of the assets
                                                                   • The expenditure will extend the service life of distribution assets beyond that expected
                                                                   when the assets were originally installed.




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                         Template: 2.1, Page 8 of 57
       Australian Energy Regulator                                                                                                                                                                                            DNSP Annual Reporting Template




 Contents

Instructions
                                               Operating expenditure (2.2)


                     Instructions
                     Data to be input on the basis of the definitions provided.
                     All expenditure must relate to the provision of standard control distribution services.
                     Key cost drivers for expenditure: reasons for material changes in costs should be expanded upon in the relevant opex commentary proforma.
                     Templates must be completed in accordance with the instructions contained in the AER's Annual Information Reporting Regulatory Information Order and Cost Allocation Guidelines.
                     All cells must be filled out where possible, especially in relation to any commentary on variances.



                     Table 1 - Operating expenditure by category




                                                                                                                                                                                                    Revenue Cap     Key cost drivers and explanation for
                                          $’000                           Subtransmission                      HV                          LV                       Other               Total
                                                                                                                                                                                                        Allowance      material differences over time

                                                                                       undergroun                 undergroun                 undergroun                 undergroun
                                                                          overhead                   overhead                    overhead                   overhead
                                                                                            d                          d                           d                          d
                     Maintenance
                     Routine
                     Subtransmission
                     CBD
                     Urban
                     Rural – short
                     Rural – long
                     METERING - maintenance and repair
                     Vegetation management
                     Public Lighting
                     Other
                                  Subtotal routine maintenance
                     Condition-based
                     Subtransmission
                     CBD
                     Urban
                     Rural – short
                     Rural – long
                     METERING - maintenance and repair
                     Vegetation management
                     Public Lighting
                     Other
                         Subtotal condition-based maintenance
                     Corrective/Emergency
                     Subtransmission
                     CBD
                     Urban
                     Rural – short
                     Rural – long
                     METERING - maintenance and repair
                     Vegetation management
                     Public Lighting
                     Other
                        Subtotal corrective/emergency maintenance
                                             TOTAL MAINTENANCE




       12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                                                                    Template: 2.2, Page 9 of 57
Australian Energy Regulator                                                                 DNSP Annual Reporting Template




                                                                                Operating
                                                              Quality and Safety Systems
                                                            Network systems operations
                                                                    Demand management
                                                                          Direct Charges
                                                                  SCADA/Network control
                                                                                 Other IT
                                                           Billing and revenue collection
                                                                   Other operatiing costs
                                                                              Sub-Totals
                                                                          Total operating
                                           TOTAL DIRECT OPERATING AND MAINTENANCE
                                                                      Other expenditures
                                                                                    Other
                                                                        Customer service
                                                                              Regulatory
                                                               Advertising and marketing
                                                                      Meter data services
                                                                    Corporate Overheads
                                                    Executive and financial management
                                               Executive and financial management (Non-
                                                                     Insurance (Network)
                                                                 Insurance (Non-network)
                                                                                       HR
                                                                                    Other
                                                          TOTAL OTHER CONTROLLABLE
                                                                            TOTAL OPEX
                                                                  Revenue Cap Allowance




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                        Template: 2.2, Page 10 of 57
Australian Energy Regulator                                                                                                                                                                                      DNSP Annual Reporting Template




              Table 2 - Opex by expenditure category



                              Cost category (D)                        TOTAL


                                                   Labour
                                                 Materials
                                               Contractors
                                                     Other
                                                     Total



              Table 3 - Opex values



                   Opex approved & requested                           TOTAL


                                Opex requested by RNSP
                                 Pass through requested
                                   Total opex requested
                      Opex approved by regulator at reset
                                  Pass through approved
                        Total opex approved by regulator




              Table 4: Definitions

              Category                                                                                                              Definition
                                                             Advertising and marketing activities attributable to the provision of distribution services, including:
                                                             ·    Providing information to customers, and conducting promotional activities, in order to improve the utilisation of the distribution assets by
                                                             improving the power factor or the load factor.
                                                             ·    Providing contact telephone numbers for fault reporting, for example through bill inserts.
                                                             ·    Publicising reliability targets and communicating with distribution customers on reliability matters.
                                                             ·    Development of distribution tariffs.
                                                             ·    Communicating with customers on distribution matters, for instance, providing notice of planned interruptions.
                                                             ·    Educating the public on distribution-related electrical safety.
                                                             ·    Activities arising from the DNSPs' obligations in relation to the quality of supply.
              Advertising and marketing                      Excluded from this expenditure category are:
                                                             ·    Brand advertising.
                                                             ·    Corporate image making.
                                                             ·    Corporate/community sponsorships and donations.
                                                             ·    Communication internal to the business.
                                                             ·    Research and analysis on other distribution businesses.
                                                             ·    Contact with any Ombudsman.
                                                             ·    Advertising of retail services.


                                                             The billing of retailers for use of the distribution system, and the associated collection of distribution revenue from retailers.
                                                             This category comprises the following services:
                                                             • The invoicing function.
                                                             • The accounts receivable function.
              Billing and revenue collection
                                                             • The credit and bad debt collection function.
                                                             • The customer transfer function.
                                                             • Costs of operating the Customer Information System (CIS).

              Condition based maintenance                    Maintenance activities based on inspection/assessment of the condition of an asset.




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                                                             Template: 2.2, Page 11 of 57
Australian Energy Regulator                                                                                                                                                                                                  DNSP Annual Reporting Template




                                                                 The support activities required by the DNSP in order to ensure adequate and effective corporate governance. It is not directly related to
              Corporate overheads                                maintenance activities.

                                                                 Activities that restore a failed component to an operational state.
                                                                 All expenditure relating to the work incurred where supply has been interrupted or assets damaged or rendered unsafe by a breakdown, making
              Corrective/Emergency
                                                                 immediate operations and/or repairs necessary.

                                                                 The expenditures of providing the following services to distribution customers:
                                                                 ·     Facilitating the reporting to the Distribution Business of distribution faults and safety hazards, and complaints about the quality and reliability
                                                                 of supply.
              Customer service                                   ·     Responding to queries on new connections, disconnections and reconnections.
                                                                 ·     Responding to queries on improving power factor or load factor.

              Direct Charges                                     Costs associated with owning and managing assets, which (CIS) operating expenditures water charges, attributable to or caused by the
                                                                 Call centre expenditures and Customer Information Serviceinclude council rates charges, that are directly electricity bills and permits etc.
                                                                 Distribution substations, including the ‘distribution components’ of combined transmission/distribution substations and high voltage customer
              Distribution station                               connections. Excluded are the estimated value of land and buildings.

              Executive and financial management (Network)       Expenditure associated with the Executive and Financial Management of the Network Business. Use allocators as appropriate.
                                                                 Expenditure associated with the Executive and Financial Management of the Non-network aspect of the Business. Use allocators as appropriate.
              Executive and financial management (Non-network)
              Key cost drivers                                   Significant factors driving expenditure such as age and condition of assets, size of network, CPI, labour costs, legislative requirements.
                                                                 · meter reading
                                                                 · data exhange
                                                                 · data aggregation
                                                                 · data estimation
              Meter data services
                                                                 · data validation
                                                                 · data substitution
                                                                 · data forwarding

                                                                 Expenditure for Field Asset Locations, Service Marking, Service/ Installation Technical Advice, System Switching, Feeder Patrols, Customer Load
              Network systems operations                         Assessments, Quality of Supply Investigations, Commercial Plan Approvals, Network Connections & Modification Ad

                                                                 All activities not directly related to the operation and maintenance of the network, including administrative, planning and engineering support costs.
              Non-network

              Opex                                               Expenditure related to operating and maintaining assets which is not capex.
                                                                 Expenditure relation to IT support for Works Management System, Graphical Information System, National Electricity Market, Data Quality,
                                                                 Drawing Management Systems and Communications.
              Other IT                                           Does not include items recorded under "SCADA/Network Control."


                                                                 Overhead lines that serve a distribution function, including distribution feeders, and the low voltage distribution system. These lines typically have
              Overhead distribution                              a voltage of less than 33 kV.

              Public Lighting                                    This includes all expenditure from the operation and maintenance of lights used primarily for lighting public places (mainly street lights).
                                                                 Includes:
              Quality and Safety Systems                         · OHS
                                                                 The costs of meeting economic regulatory requirements as they apply to the DNSP.
                                                                 Included in this cost category are:
                                                                 • Costs associated with staffing the regulatory function, including a Regulatory Manager and staff, covering both state and federal economic
                                                                 regulation.
                                                                 • Costs associated with providing information requested by the AER.
                                                                 • Costs associated with preparing submissions to the AER in response to
                                                                 consultation processes administered by the AER.
                                                                 • Costs associated with participation in the AER’s reviews of price controls and the
              Regulatory                                         development and implementation of standards and procedures.
                                                                 • Costs of non-financial regulatory audits.
                                                                 Excluded from this cost category are:
                                                                 • Costs of preparing regulatory accounts (refer to Corporate Overheads - Executive and Financial Management).
                                                                 • Costs of financial regulatory audits (refer to Corporate Overheads - Executive and Financial Management).
                                                                 • Costs associated with environmental regulations.
                                                                 • Costs associated with technical and safety regulations.
                                                                 • Discretionary costs incurred for the purposes of regulatory processes.

              Routine maintenance                                Recurrent activities undertaken to maintain assets.
              SCADA/Network control                              Operation of the Electricity Network Control System and Emergency Call and Dispatchers Call Centre.




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                                                                         Template: 2.2, Page 12 of 57
Australian Energy Regulator                                                                                                                                                                        DNSP Annual Reporting Template




                                           Sub-transmission means those parts of the distribution system (including power lines and towers, cables and substations as the case may be) that
              Subtransmission              transfer electricity from the regional bulk supply points supplying areas of consumption to individual zone substations.

                                           Underground cables that serve a distribution function, including distribution feeders, and the low voltage distribution system. These lines typically
              Underground distribution     have a voltage of less than 33 kV.

                                           All expenditure relating to all normal tree cutting, undergrowth control and waste disposal connected to line clearing including co-ordination and
              Vegetation management        supervision of vegetation control work. Emergency work must not be included.




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                                               Template: 2.2, Page 13 of 57
       Australian Energy Regulator                                                                                                                                                                                                                                                                                                                                             DNSP Annual Reporting Template




                                                                                                                                                                                                                                                                                  Regulatory test                       Yes

                                       Material projects and programs (2.3)
 Contents                                                                                                                                                                                                                                                                         Business case                         No
Instructions




                      Instructions
                     Enter all material project and program information in the tables below for projects undertaken in the previous regulatory year.
                     Only include those projects and programs with a total cumulative expenditure over the life of the project or program of greater than 2 per cent of the RNSP's AAR in
                     the final year of the current regulatory period. For programs of an ongoing nature, the materiality threshold should be applied to the total expenditure for the program
                     over the relevant regulatory control period.




                      Table 1 - Projects/programs


                      Projects/programs
                                                                                                                                                                                                                                                 Proposed                Actual
                      Unique                                                                                                                                                                    Proposed start          Actual start                                              Categories of distribution                                      Business case     Regulatory              Actual            Forecast
                                           Name                                  Description                                                      Reasons                                                                                 commissioning commissioning                                                   Location
                      identifier                                                                                                                                                                            date                 date                                             services to be provided                                         approval          test satisfied       Expenditure        Expenditure
                                                                                                                                                                                                                                                      date                 date
                     Include unique                                                                                                                                                                                                                                                                                       Identify location if only                 Reference the
                                                                                                                                                  Where possible the reasons should relate                                                                                        Outline the categories of distribution                            Reference the
                     identifier for each                                                                                                                                                        Identify month and   Identify month and   Identify month and   Identify month and                                        one site, if several, eg                   appropriate
                                                                                                                                                  to the drivers that are contained in the                                                                                        services which are to be provided by                              appropriate                               (Nominal $)           (Real $)
                     project and                                                                                                                                                                              year                 year                 year                 year                                        pole replacement, insert                   documentation (if
                                                                                                                                                  expenditure reporting templates.                                                                                                the proposed asset(s)                                             documentation
                     program                                                                                                                                                                                                                                                                                             'various'.                                 relevant).




                     Item                  Definition                                                                                                                                                                                                                                                                                             Source
                     Project               Project is a capex project.                                                                                                                                                                                                                                                                            AER
                     Program               Expenditure on numerous similar items contributing to a larger overall objective. A program can be a mix of capex or opex or a series of small capex projects that aggregate to a material program.                                                                                                    AER




       12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                                                                                                                                                                                                                      Template: 2.3, Page 14 of 57
Australian Energy Regulator                                                                                             DNSP Annual Reporting Template




  Contents

 Instructions
                                                   Capital contributions (2.4)


                      Instructions


                      Enter the details of capital contributions, prepayments and financial guarantees from the previous regulatory year in Table 1




                      Table 1 - Capital contributions, prepayments and financial guarantees


                      Capital contributions, prepayments and financial guarantees
                      Capital contributions $'000
                      Prepayments $'000
                      Financial guarantees $'000




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                      Template: 2.4, Page 15 of57
Australian Energy Regulator                                                                                                                                         DNSP Annual Reporting Template




      Contents

     Instructions
                                                         Income statement (3.1)

                        Instructions
                        Enter detail of any income for the past financial year into the table below. Add rows beneath 'Other revenue', Network maintenance' and 'Other costs' as required for any
                        discretionary headings.
                        Note:
                        In addition it is mandatory to produce for each cost or revenue item that has been allocated to the standard control distribution services a supporting workpaper that
                        includes the following:
                        a) the amounts that have been directly attributed to the standard control distribution services
                        b) the amounts that have been allocated to each standard control distribution services
                        c) a description of the allocation basis
                        d) the numeric quantity of each allocator.



                        Table 1 - Income statement - standard control distribution services



                                                                                          Disaggregation
                        Account code
                                                                                           Statement -                                                          Regulatory
                         or reference                                                                                                      Regulatory                                  Support
                                                         Description                     Standard Control       Journal number                                   financial
                         to Account                                                                                                       adjustments                                 reference
                                                                                            Distribution                                                        statements
                             Code
                                                                                             Services

                                                            Network charges
                                           Gross proceeds from sale of assets
                                                                            #
                                                              Other revenue

                                                                     Total Revenue       $                  -   $                 -   $                 -   $                 -   $                 -

                                                                     Opex costs
                                                              Network operations
                                                        Network maintenance#
                                                                              #
                                                                  Other costs
                                                                  Depreciation
                                                 Book value of assets disposed

                                              Earnings before Interest and Tax           $                  -   $                 -   $                 -   $                 -   $                 -

                                                                            Taxation



12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                 Template: 3.1, Page 16 of 57
Australian Energy Regulator                                                                                                                                                      DNSP Annual Reporting Template




  Contents

 Instructions
                                                           Balance sheet (3.2)

                     Instructions
                     Complete table 1 - Balance sheet- standard control distribution services
                     Note:
                     In addition it is mandatory to produce for each cost or revenue item that has been allocated to the standard control distribution services a supporting workpaper that
                     includes the following:
                     a) the amounts that have been directly attributed to the standard control distribution services
                     b) the amounts that have been allocated to each standard control distribution services
                     c) a description of the allocation basis
                     d) the numeric quantity of each allocator.



                     Table 1 - Balance sheet - standard control distribution services


                                                                                                   Disaggregation
                     Account code or                                                                                                                                         Regulatory
                                                                                                Statement - Standard                                  Regulatory
                       reference to                          Description                                                    Journal number                                    financial           Support reference
                                                                                                 Control Distribution                                adjustments
                      Account Code                                                                                                                                           statements
                                                                                                      Services
                                                                                                        $'000                                        $'000 Dr/(Cr)             $'000
                                                                         Current Assets
                                                                           Receivables
                                                                          Prepayments
                                                                       Accrued revenue
                                                                            Inventories
                                                                    Non-current Assets
                                                                           Receivables
                                                                           Investments
                                                                                  Other
                                                         Property, plant and equipment
                                                                           Total Assets $                              -                         $                   -   $                    -
                                                                      Current Liabilities
                                                          Trade creditors and accruals
                                                                             Provisions
                                                                Non-current Liabilities
                                                                             Provisions
                                                                        Total Liabilities $                            -                         $                   -   $                    -
                                                                             Net Assets $                              -                         $                   -   $                    -




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                               Template: 3.2, Page 17 of 57
Australian Energy Regulator                                                                                                                                                                                                              DNSP Annual Reporting Template




                               Contents

                              Instructions
                                                                           Cash flow statement (3.3)

                                             Instructions
                                             Complete table 1 - Balance sheet- standard control distribution services. Insert rows for appropriate activities as appropriate.
                                             Note:
                                             In addition it is mandatory to produce for each cashflow item that has been allocated to the standard control distribution services a supporting workpaper that includes the following:
                                             a) the amounts that have been directly attributed to the standard control distribution services
                                             b) the amounts that have been allocated to the standard control distribution services
                                             c) a description of the allocation basis
                                             d) the numeric quantity of each allocator.



                                             Table 1 - Cash flow statement - standard control distribution services



                                                                                                                                   Disaggregation
                                             Account                                                                               Statement -                                                        Regulatory
                                                                                                                                                                                Regulatory                                   Support
                                             Code or          Description                                                          Standard Control Journal number                                    financial
                                                                                                                                                                                adjustments                                  reference
                                             reference                                                                             Distribution                                                       statements
                                                                                                                                   Services
                                                                                                                                   $'000                                        $'000 Dr/(Cr)         $'000
                                                                                                    Operating activities
                                                                       Disaggregated earnings before interest and tax
                                                                                                                 Plus

                                                                Proceeds from sale of property, plant and equipment

                                                                                                                  (Less)
                                                                           Payments for property, plant and equipment
                                                                                                            Plus / (less)
                                                                                 Increases / (decreases) in provisions
                                                                         Increases / (decreases) in trade creditors and
                                                                                                                 accruals
                                                                          Increases / (decreases) in customer deposits
                                                                                  (Increases) / decreases in receivables
                                                                                (Increases) / decreases in prepayments
                                                                                     (Increases) / decreases in inventory
                                                                            (Increases) / decreases in accrued revenue
                                                                                       Net cash from operating activities
                                                                                                     Investing activities
                                                                                                           Cash received
                                                                                             Insert appropriate activities
                                                                                                               Cash used
                                                                                             Insert appropriate activities
                                                                                       Net cash from operating activities
                                                                                                    Financing activities
                                                                                                           Cash received
                                                                                             Insert appropriate activities
                                                                                                               Cash used
                                                                                             Insert appropriate activities
                                                                                      Net cash from financing activities
                                                                                    Net increase/(decrease) in cash held
                                                                          Cash at the beginning of the reporting period
                                                                                 Cash at the end of the reporting period




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                                                                                     Template: 3.3, Page 18 of 57
Australian Energy Regulator                                                                                                                                                                                                          DNSP Annual Reporting Template




                       Contents

                      Instructions
                                                  Disaggregation statement - income (4.1)


                                      Instructions
                                      In addition it is mandatory to produce for each cost or revenue item that has been allocated to the standard control distribution services segment a supporting workpaper that includes the following:
                                      a) the amounts that have been directly attributed to the standard control distribution services segment
                                      b) the amounts that have been allocated to the standard control distribution services segment
                                      c) a description of the allocation basis
                                      d) the numeric quantity of each allocator.



                                      Table 1 - Disaggregation statement - income



                                      Account                                                                                      Standard              Alternative
                                      code or                                                                Audited                                                           Negotiated             Unregulated
                                                                                                                                   Control               Control                                                            Workpaper
                                      reference      Description                                             financial                                                         Distribution           distribution
                                                                                                                                   Distribution          Distribution                                                       reference
                                      to Account                                                             statements                                                        Services               Services
                                                                                                                                   Services              Services
                                      Code
                                                                                                             $'000                 $'000                 $'000                 $'000                  $'000
                                                                                    Network charges
                                                                                External project work

                                                               Gross proceeds from sale of assets
                                                                                   Other revenue

                                                                                     Total Revenue
                                                                                      Opex costs
                                                                              Network operations
                                                                            Network maintenance
                                                          (Insert appropriate maintenance costs)
                                                                                      Other costs
                                                                  (Insert appropriate other costs)
                                                                                     Depreciation
                                                                    Book value of assets disposed

                                                          Earnings before Interest and Tax
                                                                       Interest and dividend income
                                                                                    Finance charges

                                                              Profit(loss) before Income Tax
                                                                     Australian income tax expense
                                                                                Deferred income tax
                                                                                   Other income tax




                                                                 Profit(loss) after income tax
                                                                                         Dividends paid

                                                                           Retained Profit(Loss)



12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                                                                                   Template: 4.1, Page 19 of 57
Australian Energy Regulator                                                                                                                                                                                                                                        DNSP Annual Reporting Template




                                            Contents

                                           Instructions
                                                             Disaggregation statement - balance sheet (4.2)



                                                          Instructions

                                                          In addition it is mandatory to produce for each cost or revenue item that has been allocated to the standard control distribution services segment a supporting workpaper that includes the following:
                                                          a) the amounts that have been directly attributed to the standard control distribution services segment
                                                          b) the amounts that have been allocated to the standard control distribution services segment
                                                          c) a description of the allocation basis
                                                          d) the numeric quantity of each allocator.




                                                          Table 1 - Disaggregation statement - Balance sheet



                                                          Account                                                                               Standard               Alternative
                                                          code or                                                         Audited                                                            Negotiated             Unregulated
                                                                                                                                                Control                Control                                                            Workpaper
                                                          reference to      Description                                   financial                                                          Distribution           Distribution
                                                                                                                                                Distribution           Distribution                                                       reference
                                                          Account                                                         statements                                                         Services               Services
                                                                                                                                                Services               Services
                                                          Code
                                                                                                                          $'000                 $'000                  $'000                 $'000                  $'000
                                                                                                    Current Assets
                                                                                                              Cash
                                                                                                       Receivables
                                                                                                       Investments
                                                                                                      Prepayments
                                                                                                  Accrued revenue
                                                                                                        Inventories
                                                                                               Total current assets

                                                                                             Non-Current Assets
                                                                                  Property, plant and equipment
                                                                                                    Receivables
                                                                                                    Investments
                                                                                                           Other
                                                                                       Total non-current assets



                                                                                                        Total Assets



                                                                                               Current Liabilities
                                                                                    Trade creditors and accruals
                                                                                                            Loans
                                                                                              Customer deposits
                                                                                                  Bank overdraft
                                                                                                      Provisions
                                                                                          Total current liabilities

                                                                                            Non-Current Liabilities
                                                                                                       Provisions
                                                                                                  Total Liabilities

                                                                                             Net assets/(liabilities)




                                                                                                          Equity
                                                                                                  Share capital
                                                                                      Accumulated profits/losses

                                                                                          Total Equity/Deficiency

                                                                                  Accumulated Profits & Losses
                                                                                     - At the start of the period

                                                                                             - Profit / Loss retained

                                                                                         - At the end of the period




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                                                                                                               Template: 4.2, Page 20 of 57
Australian Energy Regulator                                                                                                                                                                                                       DNSP Annual Reporting Template




                        Contents

                       Instructions
                                                  Disaggregation statement - cash flows (4.3)



                                           Instructions
                                       Note: In addition it is mandatory to produce for each cost or revenue item that has been allocated to the standard control distribution services a supporting workpaper that includes the following:
                                       a) the amounts that have been directly attributed to the standard control distribution services
                                       b) the amounts that have been allocated to the standard control distribution services
                                       c) a description of the allocation basis
                                       d) the numeric quantity of each allocator.



                                           Table 1 - Disaggregation statement - cash flows



                                           Account
                                           code or                                                                                                 Alternative
                                                                                                                            Standard Control                             Negotiated             Unregulated
                                           reference Audited financial statements                                                                  Control                                                                     Workpaper
                                                                                                                            Distribution                                 Distribution           Distribution
                                           to                                                                                                      Distribution                                                                 reference
                                                                                                                            Services                                     Services               Services
                                           account                                                                                                 Services

                                           code
                                                      $'000                                                                 $'000                  $'000                 $'000                  $'000
                                                                                             Operating activities
                                                               Disaggregated earnings before interest and tax
                                                                                                               Plus
                                                          Proceeds from sale of property, plant and equipment
                                                                                                            (Less)
                                                                   Payments for property, plant and equipment
                                                                                                      Plus / (less)
                                                                            Increases / (decreases) in provisions
                                                                 Increases / (decreases) in trade creditors and
                                                                  Increases / (decreases) in customer deposits
                                                                          (Increases) / decreases in receivables
                                                                        (Increases) / decreases in prepayments
                                                                             (Increases) / decreases in inventory
                                                                    (Increases) / decreases in accrued revenue
                                                                               Net cash from operating activities
                                                                                            Investing activities
                                                                                                 Cash received
                                                                                   Insert appropriate activities
                                                                                                     Cash used
                                                                                   Insert appropriate activities
                                                                             Net cash from Investing activities
                                                                                            Financing activities
                                                                                                 Cash received
                                                                                   Insert appropriate activities
                                                                                                     Cash used
                                                                                   Insert appropriate activities
                                                                             Net cash from financing activities
                                                                          Net increase/(decrease) in cash held
                                                                  Cash at the beginning of the reporting period
                                                                       Cash at the end of the reporting period




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                                                                               Template: 4.3, Page 21 of 57
Australian Energy Regulator                                                                                                                                    DNSP Annual Reporting Template




   Contents

  Instructions
                                     Asset disaggregation statement (4.4)


                      Instructions
                      Analysis of property, plant and equipment disclosed in Disaggregation statement - balance sheet (4.2), prior to any regulatory adjustments.
                      Note:
                      In addition it is mandatory to produce for each cashflow item that has been allocated to the standard control distribution services segment a supporting workpaper that
                      includes the following:
                      a) the amounts that have been directly attributed to the standard control distribution services
                      b) the amounts that have been allocated to the standard control distribution services
                      c) a description of the allocation basis
                      d) the numeric quantity of each allocator.



                      Table 1 - Asset disaggregation statement (4.7)



                                                                                            Standard            Alternative
                                                                                                                                     Negotiated           Unregulated
                                                                                              Control              Control
                                                                                                                                     Distribution         Distribution              Total
                                                                                           Distribution         Distribution
                                                                                                                                       Services             Services
                                                                                            Services             Services
                                                                                        $'000                $'000                $'000                $'000                $'000
                      Gross book value
                                    Balance brought fwd
                                              Revaluation adjustments
                                              Additions
                                              Disposals / retirements
                                    Balance carried fwd
                      Accumulated depreciation
                                   Balance brought fwd
                                             Revaluation adjustments
                                             Depreciation charges
                                             Disposals
                                             At end of period
                      Net book value at end of period




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                            Template: 4.4, Page 22 of 57
Australian Energy Regulator                                                                                                                DNSP Annual Reporting Template




   Contents

  Instructions
                                                     Causal Allocation (5.1)


                      Instructions
                      Complete the table set out below to indicate:
                       - the Account Headings and the amounts subject to this Causal basis; and
                       - the description and quanta of allocator that has been used
                      Add or delete rows to accommodate other allocators or accounts as necessary



                      Table 1 - Causal allocation




                                                                                       Standard         Alternative
                                                                                                                        Negotiated      Unregulated
                                                                                        Control           Control
                                                                                                                        Distribution    Distribution          Total
                                                                                      Distribution      Distribution
                                                                                                                         Services        Services
                                                                                        Services         Services


                                                                                                $'000           $'000           $'000           $'000               $'000
                                             Account
                         Account code or reference to
                                       account code
                                             Allocator
                         Numeric quantity of allocator
                        Corresponding cost allocation
                                              Account
                        Account code or reference to
                                       account code
                                             Allocator
                         Numeric quantity of allocator
                        Corresponding cost allocation
                                              Account
                        Account code or reference to
                                            account code



12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                        Template: 5.1, Page 23 of 57
Australian Energy Regulator                                                                                          DNSP Annual Reporting Template




                                             Allocator
                         Numeric quantity of allocator
                        Corresponding cost allocation
                                              Account
                        Account code or reference to
                                       account code
                                             Allocator
                         Numeric quantity of allocator
                        Corresponding cost allocation
                                              Account
                        Account code or reference to
                                       account code
                                             Allocator
                         Numeric quantity of allocator
                        Corresponding cost allocation


                      Table 2: Detailed description and explanation of the basis of allocation for each allocator:



                                 Allocator                                                            Description




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                 Template: 5.1, Page 24 of 57
Australian Energy Regulator                                                                                                 DNSP Annual Reporting Template




  Contents

 Instructions
                                             Non-causal allocation (5.2)


                      Instructions

                      Complete the table set out below to indicate the Account Headings and the
                      amounts subject to this non-causal basis. If necessary add/remove rows to accommodate more costs or accounts.



                      Table 1 - Non-causal allocation



                                                                 Standard          Alternative
                                                                                                      Negotiated        Unregulated
                                                                  Control            Control
                                                                                                      Distribution       Distribution          Total
                                                               Distribution       Distribution
                                                                                                       Services            Services
                                                                 Services           Services
                                                                       $'000              $'000                $'000              $'000              $'000
                                Account
                         Account code
                       or reference to
                         account code

                               Allocator
                                Numeric
                              quantity of
                               allocator
                        Corresponding
                       cost allocation

                                Account


12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                         Template: 5.2, Page 25 of 57
Australian Energy Regulator                 DNSP Annual Reporting Template




                         Account code
                       or reference to
                         account code

                               Allocator
                                Numeric
                              quantity of
                               allocator
                        Corresponding
                       cost allocation

                                Account
                         Account code
                       or reference to
                         account code

                               Allocator
                                Numeric
                              quantity of
                               allocator
                        Corresponding
                       cost allocation

                                Account
                         Account code
                       or reference to
                         account code

                               Allocator
                                Numeric
                              quantity of
                               allocator




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls        Template: 5.2, Page 26 of 57
Australian Energy Regulator                                                                                                      DNSP Annual Reporting Template



                           Corresponding
                       cost allocation

                                 Account
                           Account code
                       or reference to
                           account code

                                Allocator
                                 Numeric
                              quantity of
                                 allocator
                           Corresponding
                       cost allocation



                      Table 2: Detailed description and explanation of the basis of allocation for each allocator:



                      The detailed descriptions should contain

                      1.   A detailed description and explanation of the basis of allocation.
                      2.   An explanation as to why no causal basis could be established.
                      3.   Justification for choosing the non-causal basis of allocation and why it was preferred over others.
                      4.   Date on which the Commission/AER granted approval.




                            Allocator                                                                   Detailed description




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                             Template: 5.2, Page 27 of 57
Australian Energy Regulator                DNSP Annual Reporting Template




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls       Template: 5.2, Page 28 of 57
Australian Energy Regulator                                                                                                                                                                            DNSP Annual Reporting Template




                                            Contents
                                                                Property, plant and equipment reconciliation
                                           Instructions
                                                                                    (6.1)

                                                          Instructions


                                                          Complete Table 1 - Reconciliation of property, plant and equipment. Table 1 only applies to standard control distribution services.

                                                          Subject to the provisions of this section, a DNSP shall apply the discretionary headings consistently to subsequent regulatory financial statements. These discretionary
                                                          headings should be as consistent as possible with those applied in its regulatory information provided to the AER under the submission guidelines. Discretionary headings
                                                          shall agree with, or be traceable to, the account headings in a DNSP's general ledger or the chart of accounts that underpins its base accounts

                                                          A DNSP may vary the discretionary headings from those used in a preceding regulatory accounting year if:
                                                          -a revision of this RIO should require such a change, or
                                                          -the AER issues written approval after recieving an application from a DNSP for such a variation. Such an application should include an explanation of the relationships
                                                          between revised account headings and their predecessors.




                                                          Table 1 - Reconciliation of property, plant and equipment - standard control distribution services



                                                          $'000                                                      subtransmission         distribution HV         distribution LV

                                                                                                                            $'000                  $'000                   $'000
                                                          Gross values
                                                                                      Regulatory period
                                                                                             Plus/minus
                                                                               Revaluation adjustments
                                                                                              Additions
                                                                                  Disposals/retirements
                                                          At prior accounting date
                                                                               Revaluation adjustments
                                                                                Disposals during period
                                                          At end of period
                                                                             Accumulated depreciation
                                                                               Revaluation adjustments
                                                                                  Depreciation charges
                                                                                  Disposals/retirements
                                                          At start of period
                                                                               Revaluation adjustments
                                                                    Current period depreciation charge
                                                                     Depreciation released on disposals
                                                          At end of period
                                                          Values agreed by the Commission at the
                                                          start of the reguatory control period
                                                          Net regulatory values at start of period
                                                          Net reguatory values at end of period




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                                                    Template: 6.1, Page 29 of 57
Australian Energy Regulator                                                                                                                     DNSP Annual Reporting Template




  Contents

 Instructions
                                                    Asset aging schedule (6.2)


                      Instructions
                     Enter details of the age of assets in the table 1 - asset aging schedule. Only enter details of standard control distribution service assets. All values
                     should be in $real for the current regulatory year.



                      Table 1 - Asset aging schedule - standard control distribution services



                                                                           Useful life remaining (years after regulatory accounting date)
                                                    Total         1 to 2          3 to 4         5 to 6         7 to 8     9 to 10       11 to 15       16 to 20          >20

                                                    $'000         $'000           $'000          $'000          $'000          $'000         $'000         $'000         $'000
                         lines and cables
                         Subtransmission
                           Distribution HV
                           Distribution LV
                          substations and
                            transformers
                        Subtransmission
                          Distribution HV
                          Distribution LV
                      buildings, land and
                              easements
                         communications
                                  meters
                            other system
                                      assets
                              public lighting
                                        Total   $           - $             - $            - $            - $            - $           - $           - $           - $           -



12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                              Template: 6.2, Page 30 of 57
Australian Energy Regulator                                                                                                                  DNSP Annual Reporting Template




  Contents

 Instructions
                                              Network characteristics (6.3)


                      Instructions

                     Enter network characteristics data in the tables below. Only enter details of standard control distribution network assets inculded in the RAB in
                     the tables below.



                      Table 1 - Line length



                                 Line Length (km)                                 position                                         voltage

                                                                     underground          overhead        sub-transmission         high voltage       low voltage

                                     Total km
                                          CBD
                                        Urban
                                   Rural short
                                    Rural long


                      Table 2 - Metered supply points



                        Number of metered supply points                     type of customer                                   supply voltage

                                                                      underground            overhead      sub-transmission         high voltage       low voltage

                                     Total no.
                                          CBD
                                        Urban
                                   Rural short
                                    Rural long



12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                           Template: 6.3, Page 31 of 57
Australian Energy Regulator                                                                                                                               DNSP annual reporting template




           Contents
                                   Service target performance incentive scheme
          Instructions
                                                        (7.1)

                              Instructions

                              Enter service target performance scheme information from the previous financial year i.e. from 1 July to 30 June in the table below. GSL payments
                              information should be reported on a regulatory year.

                              Please note: Some additional information to that set out in the STPIS is requested to monitor additional aspects of service performance
                              and to assist the AER in developing the scheme.

                              Section A: Reliability
                              Note: Where network segmented by alternative method to network type then table headings should be changed accordingly.
                              Note: The exclusion methodology to be used is set out in STPIS. Details of excluded events are required in 7.2 and 7.3 of this work book.

                              Table 1: SAIDI


                                                                                                                  Network categorisation
                                                                                                                                                                          Whole
                              SAIDI                                                          CBD              Urban          Rural short       Rural long
                                                                                                                                                                      network
                              with exclusions
                                                                           Planned
                                                                         Unplanned
                                                                              Total                   0                 0                  0                0                0
                              without exclusions
                                                                           Planned
                                                                         Unplanned




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                     Template: 7.1, Page 32 of 57
Australian Energy Regulator                                                                                                      DNSP annual reporting template




                                                                     Total             0           0                 0                0               0

                              Table 2: SAIFI


                                                                                             Network categorisation
                                                                                                                                                 Whole
                              SAIFI                                            CBD         Urban       Rural short       Rural long
                                                                                                                                              network
                              with exclusions
                                                                 Planned
                                                               Unplanned
                                                                    Total              0           0                 0                0               0
                              without exclusions
                                                                 Planned
                                                               Unplanned
                                                                    Total              0           0                 0                0               0

                              Table 3: MAIFI


                                                                                             Network categorisation
                                                                                                                                                 Whole
                              MAIFI                                            CBD         Urban       Rural short       Rural long
                                                                                                                                              network
                                                          with exclusions
                                                       without exclusions
                                                                    Total              0           0                 0                0               0

                              Table 4 - Breakdown of unplanned interruptions by category


                              Interruption category                             No.         %




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                              Template: 7.1, Page 33 of 57
Australian Energy Regulator                                                                           DNSP annual reporting template




                                  Weather (e.g. storms, rainfall, wind blown
                                                                                            #DIV/0!
                                                                     debris
                                                         Equipment failure                  #DIV/0!
                                                          Operational error                 #DIV/0!
                                                    Vegetation (e.g. trees)                 #DIV/0!
                                             Animals (e.g. possums, birds)                  #DIV/0!
                                     Third party impacts, including vehicle
                                                                                            #DIV/0!
                                 collisions, vandalism, dig-ins, bus fire etc.
                                                        Transmission failure                #DIV/0!
                                                              Load shedding                 #DIV/0!
                                         Inter distributor connection failure               #DIV/0!
                                                                        Other               #DIV/0!
                                                                        Total    0          #DIV/0!


                              Section B: Quality of supply

                              Table 5: Quality of supply complaints by complaint category


                              Complaint category                                 No.          %
                                                        Low supply voltage                  #DIV/0!
                                                              Voltage dips                  #DIV/0!
                                                             Voltage swell                  #DIV/0!
                                                             Voltage spike                  #DIV/0!
                                                        Waveform distortion                 #DIV/0!




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                 Template: 7.1, Page 34 of 57
Australian Energy Regulator                                                                                DNSP annual reporting template




                                                    TV or radio interference                     #DIV/0!
                                                     Noise from appliances                       #DIV/0!
                                                                       Other                     #DIV/0!
                                                                        Total          0         #DIV/0!

                              Table 6: Quality of supply complaints by likely cause


                              Complaint category                                       No.         %
                                                Faulty network equipment                         #DIV/0!
                                        Network interference by distributor
                                                                                                 #DIV/0!
                                                                 equipment
                                Network interference by another customer                         #DIV/0!

                                                       Network limitation                        #DIV/0!
                                                Customer initiated problem                       #DIV/0!
                                                     No problem identified                       #DIV/0!
                                                            Environmental                        #DIV/0!
                                                                      Total            0         #DIV/0!


                              Section C: Customer Service

                              Table 7: Telephone answering

                                                                                With          Without
                              Telephone answering
                                                                                exclusiuons   exclusions
                                                      Total number of calls

                              Number of calls answered within 30 seconds

                                    Percentage of calls answered within 30
                                                                                   #DIV/0!
                                                                    seconds

                              Table 8: New connections (optional parameter in STPIS)




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                      Template: 7.1, Page 35 of 57
Australian Energy Regulator                                                                           DNSP annual reporting template




                              New connections                                      No.
                                                   Number of new connections
                               Number of new connections not provided on
                                                or before the agreed date
                              Percentage of new connections not provided
                                                                                  #DIV/0!
                                                   on or before the agreed date

                              Table 9: Streetlight repair (optional parameter in STPIS)


                              Streetlight repair                                   No.
                                                   Total number of streetlights

                                            Total number of streetlight faults


                              Total number of streetlight faults reported by
                              person who is the occupier of an immediately
                              neighbouring residence or is the proprietor of
                                      an immediately neigbouring business

                                   Faulty street lights not repaired within 5
                                           days of fault report or agreed date
                                       Percentage of faulty street lights not
                                    repaired within 5 days of fault report or     #DIV/0!
                                                                   agreed date

                              Table 10: Response to written enquiries (optional parameter in STPIS)


                              Response to written enquiries                        No.
                                                          Written enquiries
                              Number of written enquiries not responded to
                                                                 in 5 days*
                                        Percentage of written enquiries not
                                                                                  #DIV/0!
                                                       responded to in 5 days*




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                 Template: 7.1, Page 36 of 57
Australian Energy Regulator                                                                                                       DNSP annual reporting template




                              *Not including Saturday, Sunday and Public holidays


                              Table 11: Customer complaints by category
                                                                          ]
                              Customer complaints by category                             No.
                                                      Reliability of supply
                                                         Quality of supply
                                                        Customer service
                                                                      Other



                              Section D: Guaranteed service levels

                              Table 12: Guaranteed service level (GSL) reporting requirements

                              Note: Where the GSL component of the STPIS does not apply leave this section blank



                                         GSL parameters                                                number of      total
                                                                                                       payments    payments ($)

                                                                                          CBD and
                                                     frequency of interruptions
                                                                                    urban feeders

                                                                                      Rural (short
                                                                                         and long)
                                                                                           feeders
                                                                                          CBD and
                                                       duration of interruptions
                                                                                    urban feeders

                                                                                      Rural (short
                                                                                         and long)
                                                                                          feeders
                                                                                       Level 1 - 20
                                                 total duration of interruptions
                                                                                              hours




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                             Template: 7.1, Page 37 of 57
Australian Energy Regulator                                                                  DNSP annual reporting template




                                                                              Level 2 - 30
                                                                                    hours
                                                                              Level 3 - 60
                                                                                    hours
                                                         streetlight repair
                                                         new connections
                                           notice of planned interruptions




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                        Template: 7.1, Page 38 of 57
Australian Energy Regulator                                                                                                                               DNSP annual reporting template




                              Section E: Worst performing feeders

                              Table 13: Unplanned SAIDI and unplanned SAIFI of the worst performing 10% of feeders by feeder category

                              Note: If the worst performing 10% of feeders consists of more than 100 feeders only report the worst performing 10. If the network contains less
                              than 30 feeders report the 3 worst performing feeders. Exclusions do not apply to this table.
                              `
                                                                                                           Unplanned         Unplanned
                                                                                          Feeder ID                                                       Comments
                                                                                                              SAIDI             SAIFI
                                                  Worst performing CBD feeders
                                                                            Feeder 1
                                                                            Feeder 2
                                                                            Feeder 3
                                                                            Feeder 4
                                                                            Feeder 5
                                                                            Feeder 6
                                                                            Feeder 7
                                                                            Feeder 8
                                                                            Feeder 9
                                                                          Feeder 10
                                                Worst performing urban feeders




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                      Template: 7.1, Page 39 of 57
Australian Energy Regulator                                                 DNSP annual reporting template




                                                                Feeder 1
                                                                Feeder 2
                                                                Feeder 3
                                                                Feeder 4
                                                                Feeder 5
                                                                Feeder 6
                                                                Feeder 7
                                                                Feeder 8
                                                                Feeder 9
                                                               Feeder 10
                                     Worst performing short rural feeders
                                                                Feeder 1
                                                                Feeder 2
                                                                Feeder 3
                                                                Feeder 4
                                                                Feeder 5
                                                                Feeder 6
                                                                Feeder 7
                                                                Feeder 8
                                                                Feeder 9
                                                               Feeder 10
                                      Worst performing long rural feeders
                                                                Feeder 1
                                                                Feeder 2
                                                                Feeder 3
                                                                Feeder 4
                                                                Feeder 5
                                                                Feeder 6
                                                                Feeder 7
                                                                Feeder 8
                                                                Feeder 9
                                                               Feeder 10




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                       Template: 7.1, Page 40 of 57
Australian Energy Regulator                                                                                                                             DNSP annual reporting template




                                   Definitions - performance reporting categories

                              Table 1 - Reliability of supply definitions




                                        Performance reporting
                                                                                    Definition                                                               Source
                                                              parameter

                                                                      Reliability
                                                                                The sum of the duration of each unplanned sustained customer
                                                                                                                                                            Appendix A,
                                                             Unplanned SAIDI interruption (in minutes) divided by the total number of distribution
                                                                                                                                                            AER DNSP
                                   (system average interruption duration index) customers. Unplanned SAIDI excludes momentary interruptions (one
                                                                                                                                                            STPIS
                                                                                minute or less).

                                                                               The total number of unplanned sustained customer interruptions         Appendix A,
                                                              Unplanned SAIFI
                                                                               divided by the total number of distribution customers. Unplanned SAIFI AER DNSP
                                 (system average interruption frequency index) excludes momentary interruptions (one minute or less).
                                                                                                                                                      STPIS

                                                                           MAIFI                                                                            Appendix A,
                                                                                    The total number of customer interruptions of one minute or less,
                                   (momentary average interruptions frequency divided by the total number of distribution customers.                        AER DNSP
                                                                        index)                                                                              STPIS




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                   Template: 7.1, Page 41 of 57
Australian Energy Regulator                                                                                                                         DNSP annual reporting template




                                                                           1. The number of distribution customers is calculated as the average of
                                                                           the number of customers at the beginning of the reporting period and
                                                                           the number of customers at the end of the reporting period.
                                                                           2. Unmetered Street Lighting supplies are excluded. Other unmetered
                                                                           supplies can either be included or excluded from the calculation of     Appendix A,
                                   Further notes to reliability parameters reliability measures.                                                   AER DNSP
                                                                           3. Inactive accounts are excluded.                                      STPIS
                                                                           4. In calculating MAIFI, each operation of an automatic reclose device
                                                                           is counted as a separate interruption. Sustained interruptions which
                                                                           occur when a recloser locks out after several attempts to reclose
                                                                           should be deleted from MAIFI calculations.

                                                               Network type
                                                                            a feeder supplying predominantly commercial, high-rise buildings,
                                                                                                                                                Appendix A,
                                                                            supplied by a predominantly underground distribution network
                                                                 CBD feeder                                                                     AER DNSP
                                                                            containing significant interconnection and redundancy when compared
                                                                                                                                                STPIS
                                                                            to urban areas.
                                                                             a feeder, which is not a CBD feeder, with actual maximum demand              Appendix A,
                                                                urban feeder over the reporting period per total feeder route length greater than 0.3     AER DNSP
                                                                             MVA/km.                                                                      STPIS
                                                                                                                                                          Appendix A,
                                                                                 a feeder which is not a CBD or urban feeder with a total feeder route
                                                            short rural feeder                                                                            AER DNSP
                                                                                 length less than 200 km.
                                                                                                                                                          STPIS




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                 Template: 7.1, Page 42 of 57
Australian Energy Regulator                                                                                                                           DNSP annual reporting template




                                                                                                                                                          Appendix A,
                                                                                a feeder which is not a CBD or urban feeder with a total feeder route
                                                            long rural feeder                                                                             AER DNSP
                                                                                length greater than 200 km.
                                                                                                                                                          STPIS


                              Table 2 - Customer service component and GSL definitions




                                      Performance reporting
                                                                                Definition                                                                 Source
                                                          parameter

                                                                                                                                                 Appendix A,
                                                  Duration of interruptions The duration of an unplanned interruption experienced by a customer. AER DNSP
                                                                                                                                                 STPIS
                                                                                                                                                 Appendix A,
                                                                            The number of unplanned sustained interruptions experienced by a
                                                Frequency of interruptions                                                                       AER DNSP
                                                                            customer in a year.
                                                                                                                                                 STPIS

                                                                          The connection of electricity supply to a new customer’s premises on
                                                                          or before the date agreed to with the customer. For the ‘customer               Appendix A,
                                                          New connections service’ component, this is expressed as a percentage of the total              AER DNSP
                                                                          number of new connections.                                                      STPIS
                                                                          Note: Does not include re-energisation of existing premises.

                                                                                                                                                          Appendix A,
                                                                                The delivery of notice to customers of a planned interruption on or
                                              Notice of planned interruptions                                                                             AER DNSP
                                                                                before the threshold.
                                                                                                                                                          STPIS

                                                                          The provision of a written response to a written enquiry on or before
                                                                                                                                                Appendix A,
                                                                          the defined threshold. Written enquiries and responses include email.
                                            Response to written enquiries                                                                       AER DNSP
                                                                          For the ‘customer service’ component, this is expressed as a
                                                                                                                                                STPIS
                                                                          percentage of the total number of written enquiries.




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                 Template: 7.1, Page 43 of 57
Australian Energy Regulator                                                                                                                    DNSP annual reporting template




                                                                         For the ‘GSL’ component, the repair of a public light within ’x’ business
                                                                         days of each fault report or a period otherwise agreed between the
                                                                         distributor and the person, if that person is the occupier of an
                                                                                                                                                   Appendix A,
                                                                         immediately neighboring residence or is the proprietor of an
                                                      Streetlight repair                                                                           AER DNSP
                                                                         immediately neighboring business.
                                                                                                                                                   STPIS
                                                                         For the ‘customer service’ component, the repair of a public light within
                                                                         ’x’ business days of each fault, expressed as a percentage of the total
                                                                         number of public light faults.


                                                                     Calls to the fault line answered in 30 seconds where the time to answer
                                                                     a call is measured from when the call enters the telephone system of
                                                                     the call centre (including that time when it may be ringing unanswered
                                                                     by any response) and the caller speaks with a human operator, but
                                                                     excluding the time that the caller is connected to an automated
                                                                     interactive service that provides substantive information. This measure
                                                                     does not apply to:                                                      Appendix A,
                                                 Telephone answering • calls to payment lines and automated interactive services;            AER DNSP
                                                                     • calls abandoned by the customer within 30 seconds of the call being STPIS
                                                                     queued for response by a human operator. Where the time in which a
                                                                     telephone call is abandoned is not measured, then an estimate of the
                                                                     number of calls abandoned within 30 seconds will be determined by
                                                                     taking 20 per cent of all calls abandoned.
                                                                     Note: Being placed in an queuing system (automated or otherwise)
                                                                     does not constitute a response.

                                                                                                                                                    Appendix A,
                                                                             The sum of the durations of all unplanned interruptions experienced by
                                           Total duration of interruptions                                                                          AER DNSP
                                                                             a customer in a year.
                                                                                                                                                    STPIS


                              References

                                                                             Australian Energy Regulator, Electricity distribution network service
                                                         AER DNSP STPIS
                                                                             providers service target performance incentive sheme , 28 June 2008




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                             Template: 7.1, Page 44 of 57
Australian Energy Regulator                DNSP annual reporting template




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls      Template: 7.1, Page 45 of 57
Australian Energy Regulator                                                                                                                                                                                                          DNSP Annual Reporting Template




  Contents

 Instructions
                              Service performance - major event days (7.2)


                     Instructions

                     Enter service target performance scheme information from the previous financial year i.e. from 1 July to 30 June in the table below.




                     Table 1: Service target performance incentive scheme - major event days*
                     *Major event day (MED) is defined in the STPIS.
                     If required add extra columns for other parameters required under a distribution determination.


                     MED boundary (Tmed)               [insert MED boundary (Tmed) as calculated in accordance with the STPIS]

                                                                                                                                                                                 Telephone answering                    <insert any other
                                   Date                 Brief description of event            Unplanned SAIDI impact             Unplanned SAIFI impact Unplanned MAIFI impact                          GSL impact                                   Comments
                                                                                                                                                                                       impact                             parameter>
                                                        Insert brief description of
                               DD:MM:YY                                                                   mins                               mins               mins                  % of calls       No of payments
                                                                     event




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                                                                                    Template: 7.2, page 46 of 56
Australian Energy Regulator                                                                                                                                                                            DNSP Annual Reporting Template




  Contents

 Instructions
                      Service performance - Other exlcuded items (7.3)


                     Instructions

                     Enter service target performance scheme information from the previous financial year i.e. from 1 July to 30 June in the table below.



                     7.3 Service target performance incentive scheme - other exlcuded items*
                     * Includes:
                     1 load shedding due to a generation shortfall
                     2 automatic load shedding due to the operation of under frequency relays following the occurrence of a power system under-frequency condition
                     3 load shedding at the direction of the National Electricity Market Management Company (NEMMCO) or a system operator
                     4 load interruptions caused by a failure of the shared transmission network
                         load interruptions caused by a failure of transmission connection assets except where the interruptions were due to inadequate planning of transmission connections and the DNSP is responsible for
                     5
                         transmission connection planning
                         load interruptions caused by the exercise of any obligation, right or discretion imposed upon or provided for under jurisdictional electricity legislation or national electricity legislation applying to a
                     6
                         DNSP.

                                                                                                                                                   <Insert any
                                                  Event            Unplanned            Unplanned             Unplanned
                              Date                                                                                              GSL impact             other                                Further information
                                               category*          SAIDI impact         SAIFI impact         MAIFI impact
                                                                                                                                                   parameter>
                                            Insert 1:6 (see                                                                         No of                                 E.g Provide reference to relevant jursdictional
                         DD:MM:YY                                      mins                 mins                 mins
                                                 above)                                                                          payments                                                 electricity legislation




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                                                    Template: 7.3, Page 47 of 57
Australian Energy Regulator                DNSP Annual Reporting Template




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls       Template: 7.3, Page 48 of 57
Australian Energy Regulator                                                                                                     DNSP Annual Reporting Template




        Contents

       Instructions
                                               Network support passthroughs (8.1)


                              Instructions

                              Enter details of any network support passthroughs in the previous regulatory year into table 1.




                              Table 1 - Network support pass through - standard control distribution services


                                                                                                                                                   $'000
                              (1) Network support allowance
                              (2) actual network support expenditure
                              (3) Network support pass through amount                                    $                                               -



                              Reasons for variation




                              Evidence showing actual network support expenditure




                              Date network support pass through written statement
                              was submitted to the AER




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                            Template: 8.1, Page 49 of 57
Australian Energy Regulator                                                                                           DNSP Annual Reporting Template




   Contents

  Instructions
                                                      Cost passthroughs (8.2)


                       Instructions

                       Compete the following tables if your business had any passthroughs in the previous regulatory year. Add extra rows as
                       necessary.



                       Table 1 - Positive pass throughs

                                                Date of positive change event
                              Date of written statement submitted to the AER
                                                   Date of AER determination
                                               Approved pass through amount


                       Table 2 - Negative pass throughs



                                                Date of negative change event
                              Date of written statement submitted to the AER
                                                   Date of AER determination
                                                Required pass through amount




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                   Template: 8.2, Page 50 of 57
Australian Energy Regulator                                                                                                                                    DNSP Annual Reporting Template




  Contents

 Instructions
                                     Relationships with other entities (9.1)


                      Instructions

                      List any relationships the RNSP has with other entities that meet the following criteria. The other entity:
                      (1) controls the RNSP
                      (2) is controlled by the RNSP
                      (3) is controlled by an entity that controls the RNSP
                      (4) is controlled by an entity which is controlled by the RNSP
                      (5) is a director of the RNSP
                      (6) is a director of any entity identified in (1) to (4) above;
                      except where the entity’s relationship with the RNSP results solely from dealings with:
                       (i) financial institutions
                       (ii) authorised trustee corporations (as defined in the Corporations Act 2001 (Cth))
                       (iii) fund managers
                       (iv) trade unions
                       (v) statutory authorities
                       (vi) government departments; or
                       (vii) local governments.

                      For the purposes of this worksheet
                      (1) an entity is any of the following:
                       (i) a body corporate;
                       (ii) a partnership;
                       (iii) an unincorporated body;
                       (iv) an individual;
                       (v) for a trust that has only one trustee-the trustee;
                       (vi) for a trust that has more than one trustee-the trustees together.
                      (2) an entity controls a second entity if the first entity has the capacity to determine the outcome of decisions about the second entity's financial and operating
                      policies. In determining whether the first entity has this capacity:
                       (i) the practical influence the first entity can exert (rather than the rights it can enforce) is the issue to be considered; and
                       (ii) any practice or pattern of behaviour affecting the second entity's financial or operating policies is to be taken into account (even if it involves a breach of an
                       agreement or a breach of trust).



                      Table 1 - Relationships with other entities




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                            Template: 9.1, Page 51 of 57
Australian Energy Regulator                                                                         DNSP Annual Reporting Template



                      Entity                      Relationship
                      Identify the other entity   Identify the type of relationship based on the criteria in the instructions




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                  Template: 9.1, Page 52 of 57
Australian Energy Regulator                                                                                                                                                                                          DNSP Annual Reporting Template




  Contents

 Instructions
                                     Expenditures with other entities (9.2)


                      Instructions

                      In relation to expenditures with other persons which either directly or indirectly relate to, or are connected with, the provision of electricity distribution services the RNSP is to provide the following information:
                      (1) List the top ten expenditures the RNSP has had with other persons for the supply of goods and/or services in the previous regulatory year. The top ten expenditures are to be determined on the basis of the total
                      estimated value of transactions (excluding GST). Multiple transactions with the same person must be cumulated when determining the top ten expenditures. The RNSP should include transactions with both monetary
                      and non-monetary consideration. Transactions do not include payments to electricity market participants.
                      (2) For each transaction identified in (1) above:
                      (i) the nature of the expenditure, including a description of the goods and/or services provided
                      (ii) an estimation of the total value of the expenditure (excluding GST)
                      (iii) a description of the procurement process undertaken in respect of the goods and/or services
                      (v) whether any of the expenditures are with a person identified in the section 9.1 of this order.



                      Table 1 - Transactions in current regulatory control period
                                                                                                                           Terms and conditions of the supply

                                                                                          Description of                   Basis for determining            Variation in             Period of          Value of
                                                          Nature of expenditure                                                                                                                                      Procurement process
                                                                                          goods/services provided          price                            price                    contract      expenditure

                      Top ten
                                                                                                                                                           State whether                               Provide an    A description of the
                                                                                                                           Outline the basis for
                      expenditures                        Outline the nature of the       Provide a description of the     determining the price under the
                                                                                                                                                           the contract           State the time estimation of the   procurement process
                                                                                                                                                           allows for            period covered total value of the   undertaken in respect of the
                                                          expenditure                     goods/services provided          contract and the price per unit
                                                                                                                                                           variations in the     by the contract      expenditure    goods and/or services that are
                                                                                                                           of good or service provided
                                                                                                                                                           price                                 (excluding GST)     the subject of the expenditure

                                                      1
                                                      2
                                                      3
                                                      4
                                                      5
                                                      6
                                                      7
                                                      8
                                                      9
                                                     10




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                                                                                                                 Template: 9.2, Page 53 of 57
Australian Energy Regulator                                                                                                       DNSP Annual Reporting Template




   Contents
                              Regulatory adjustment journals - prescribed
  Instructions
                                      distribution services (10.1)

                     Instructions
                     Fill out the following tables as required. This schedule must contain for each Regulatory Adjustment made on the Income Statement and
                     Balance Sheet, the following:
                     a) a journal entry showing accounts debited and credited
                     b) an explanation of why the adjustment has been made.


                      Table 1 - Regulatory adjustment journals - Prescribed distribution services




                       Journal number        Account Debited           Account Credited                      Amount                     Supporting statement No.
                                                                                                     Debit               Credit
                                                                                                     $'000               $'000




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                                             Template: 10.1, Page 54 of 57
Australian Energy Regulator                DNSP Annual Reporting Template




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls      Template: 10.1, Page 55 of 57
Australian Energy Regulator                                                                                 DNSP Annual Reporting Template




                                                  Pro forma or regulatory information notice amendments
  Contents           Date                  Reference or ID    Description
 Instructions           12 August 2008                                                initial development phase




12051d90-b2b7-4e7e-91ed-76f9548ece10.xls                                                                Template: DevProcess, Page 56 of 57

				
DOCUMENT INFO
Description: Statutory Accounts Template document sample