Excell Creditors - DOC by ped96069

VIEWS: 26 PAGES: 19

More Info
									NATIONAL ENERGY REGULATOR OF SOUTH AFRICA




NERSA DISTRIBUTION FORMS

     COMPLETION GUIDE




              Date: July 2010
NERSA Distribution forms completion guide                                                                           July 2010


Introduction

Municipalities are required to submit distribution forms (D-forms) to NERSA annually for two reasons:

      Tariff increase reviews and
      Statistical purposes for the electricity industry.

The analysis of municipal financial and technical performance is done based on the information contained in the D-
Forms and tariff applications. It is therefore critical that Municipalities submit duly completed and accurate information in
their D-forms.

D-forms are sent to municipalities at the end of July for completion. They are also available on the NERSA website,
www.nersa.org.za. Licensees are required to submit accurate and completed D-forms to NERSA by 31 October each
year.

All information requested in the D-forms relates to a RING-FENCED ELECTRICITY DISTRIBUTION ACTIVITY, or
Electricity Department within a Municipality. RING-FENCED means that separate accounts are kept for the electricity
distribution activity. This should ensure that the revenues, costs, assets, liabilities, reserves and provisions are
separately identifiable from those of any other business in the books of account of the licensee. Unfortunately, this is
not always the case in a Municipality.

This guide tries to give guidance on where to get the correct information for the purpose of completing these D-forms.

A set of D-Forms comprise of the following forms which should be submitted to NERSA as per the prescribed
deadlines:

                                                                                       Submission deadline
              Distribution Forms to be completed                                            to NERSA
              D1 Form: Financial information                                             31 October 2010
              D2 Form: Market information                                                31 October 2010
              D3 Form: Human resources information                                       31 October 2010
              D4 Form: Technical information                                             31 October 2010
              D5 Form: Connection information                                            31 October 2010
              D6 Form: Tariff information                                                31 October 2010
              D7 Form: Application for a tariff increase / tariff structure change       31 March 2011
              D8 Form: Quality of service                                                31 October 2010

The above electricity distribution forms are available in Excel and as Word documents on the NERSA website
(www.nersa.org.za).


Completed forms may be returned to NERSA through any of the following addresses:

Email:        dforms@nersa.org.za
Fax:          (012) 401-4700
Post:         PO Box 40343, Arcadia, 0007


For further enquiries please do not hesitate to contact Ms Thandeka Jamba (Senior Statistician) at:

Tel:          (012) 401-4665
Cell:         (082) 538-7180
E-mail:       thandeka.jamba@nersa.org.za




NERSA (Information Resource Management Department)                                                                   Page 1
NERSA Distribution forms completion guide                                                                            July 2010




                                            D1 - Form: Financial Information



D1 FORM (SECTION 1): GENERAL INFORMATION, DEFINITIONS AND INSTRUCTIONS

      Financial information is to be stated in R’000 (For ex. R1 234 567,00 should be stated as 1 235).

      ALL amounts exclude Value Added Tax (VAT).

      The format of all the financial statements shall comply with the Published Annual Financial Statements for Local
       Authorities Second Edition (January 1996). A copy of the Published Annual Financial Statements for Local
       Authorities Second Edition (January 1996) is obtainable from:

       Postal address:                               Or Street address:
       The Secretary                                 201 Progress House
       IMFO                                          Corner of Bordeaux and Rider streets
       P O Box 3322                                  Randburg
       Randburg                                      Telephone:      (011) 789-7443
       2125                                          Facsimile:      (011) 789-8830

       Or visit the web site of the Institute of Municipal Finance Officers (IMFO) at www.imfo.co.za.

      It is important to note that the Town Treasurer’s Report, Accounting policies, and Notes to the Financial
       Statements as they relate to the electricity activity are as mandatory as the financial statements.

      In addition to completing this form, the following financial statements are mandatory and must be included
       together with this form.

       o       Ring-fenced financial accounts: Financial information for a RING-FENCED ELECTRICITY ACTIVITY in
               respect of the actual figures for the financial year ending 30 June each year and the budget figures for the
               financial year ending 30 June the following year in the form of:

                     An Income Statement
                     A Balance Sheet and
                     A Cash Flow Statement

       o       Full financial statements: A copy of the latest full audited financial statements (un-audited if not audited by
               31 October each year).




NERSA (Information Resource Management Department)                                                                    Page 2
NERSA Distribution forms completion guide                                                                         July 2010




D1 FORM (SECTION 2): BALANCE SHEET

NOTE:

 Please remember that this information is for a ring-fenced Electricity Distribution Account.
 Fixed assets, building and other fixed assets include all administrative assets specifically associated with electricity
  distribution.
 Fixed assets, electricity distribution network and equipment include all assets related to electricity distribution.


WHERE to get the information:

The information can be obtained from the Municipal Financial Statements. Another source of information is the report
on: “The ring fencing of Municipalities Electricity Departments and Eskom Distribution activities into Regional Electricity
Distributors (REDS) follow the 1998 White Paper on Energy Policy whose main objective was to synergize the
electricity distribution to customers towards a more effective, efficient and less fragmented industry”.


EXAMPLE:

BALANCE SHEET AT 30 JUNE 2010
                                                                     Note           2009/2010                2008/2009
                                                                                        R                        R

CAPITAL EMPLOYED
                                                                                         1 233 413                1 044 737
FUNDS AND RESERVES
Statutory funds                                                       1                  1 117 384                  912 318
Reserves                                                              2                    116 029                  132 419
(ACCUMULATED DEFICIT) RETAINED SURPLUS                                18                    (1 994)                  44 179
                                                                                         1 231 419                1 088 916

TRUST FUNDS                                                            3                   42 060                    37 020
LONG-TERM LIABILITIES                                                  4                  911 988                   444 365
CONSUMER DEPOSITS                                                      5                   62 459                    52 468
                                                                                       2 247 926                1 622 769

EMPLOYMENT OF CAPITAL
FIXED ASSETS                                                          6                  1 879 679                1 583 177
INVESTMENTS                                                           7                    128 094                   44 176
LONG-TERM DEBTORS                                                     8                    140 500                  120 300
DEFERRED CHARGES                                                      11                    27 136                    2 407
                                                                                         2 175 409                1 750 060

NET CURRENT ASSETS/(LIABILITIES)                                                            72 517                 (127 291)

CURRENT ASSETS                                                                            532 374                   454 656
Inventory                                                             9                    61 433                    59 313
Debtors                                                               10                  454 792                   382 841
Cash                                                                                       11 772                     9 169
Short-term investments                                                                          -                         -
Short-term portion of long-term debtors                                8                    4 377                     3 341

CURRENT LIABILITIES                                                                       459 857                   581 947
Provisions                                                            12                        -                         -
Creditors                                                             13                  422 480                   351 529
Short-term portion of long-term liabilities                           4                    37 377                   230 418
Bank overdraft                                                                                  -                         -



                                                                                       2 247 926                1 622 769




NERSA (Information Resource Management Department)                                                                 Page 3
NERSA Distribution forms completion guide                                                                         July 2010




D1 FORM (SECTION 3): CAPITAL EXPENDITURE


NOTE:

Please remember that this information is for a ring-fenced Electricity Distribution Account.


WHERE to get the information:

The information can be obtained from the Municipal Financial Statements. Another source of information is the report
on: “The ring fencing of Municipalities Electricity Departments and Eskom Distribution activities into Regional Electricity
Distributors (REDS) follow the 1998 White Paper on Energy Policy whose main objective was to synergize the
electricity distribution to customers towards a more effective, efficient and less fragmented industry”.




NERSA (Information Resource Management Department)                                                                 Page 4
NERSA Distribution forms completion guide                                                                               July 2010




D1 FORM (SECTION 4): INCOME STATEMENT

NOTE:

      Please remember that this information is for a ring-fenced Electricity Distribution Account.
      All amounts should exclude value added tax (VAT).


WHERE to get the information:

The information can be obtained from the Municipal Financial Statements. Another source of information is the report
on: “The ring fencing of Municipalities Electricity Departments and Eskom Distribution activities into Regional Electricity
Distributors (REDS) follow the 1998 White Paper on Energy Policy whose main objective was to synergize the
electricity distribution to customers towards a more effective, efficient and less fragmented industry”.


IMPORTANT:

It is important that the totals of the Revenue from sales of electricity section are the same as the amounts on the
NERSA D2-form, section 4


EXAMPLE:

INCOME STATEMENT FOR THE YEAR ENDED 30 JUNE 2010
                                                                    2009/2010                         2010/2011
                                                                     ACTUAL                           BUDGET

    REVENUE FROM SALES TO CONSUMERS (All sales from tariffs)                     XXX                              XXX
    REVENUE FROM SALE FOR REDISTRIBUTION                                         XXX                              XXX
    REVENUE FROM SALES FOR OWN USE                                               XXX                              XXX
    1. Revenue from Sales for Street Lighting                                     XX                               XX
    2. Revenue from Sales to Other departments                                    XX                               XX

    TOTAL REVENUE FROM SALES                                                    XXXX                          XXXX


    OTHER REVENUE                                                                XXX                              XXX
    1. Reconnections Fees                                                         XX                               XX
    2. New Connections                                                            XX                               XX
    3. Electricity Service Charges                                                XX                               XX
    4. Other                                                                      XX                               XX

    TOTAL REVENUE                                                         XXXXX                            XXXXX




NERSA (Information Resource Management Department)                                                                       Page 5
NERSA Distribution forms completion guide                                                                         July 2010




D1 FORM (SECTION 5): EXPENDITURE STATEMENT

NOTE:

    Please remember that this information is for a ring-fenced Electricity Distribution Account.
    All amounts should exclude value added tax (VAT).

WHERE to get the information:

The information can be obtained from the Municipal Financial Statements. Another source of information is the report
on: “The ring fencing of Municipalities Electricity Departments and Eskom Distribution activities into Regional Electricity
Distributors (REDS) follow the 1998 White Paper on Energy Policy whose main objective was to synergize the
electricity distribution to customers towards a more effective, efficient and less fragmented industry”.


IMPORTANT:

    It is important that the totals of the Purchases section are the same as the amounts on the NERSA D2-form
     (section 2) Totals: Cost of electricity purchases

    The General expenses section includes expenses not classified elsewhere, i.e. purchases, salaries and
     maintenance, capital charges, contribution to capital, contribution to funds, charges allocated to and from other
     departments.

EXAMPLE:
EXPENDITURE
                                                                                       2009/2010               2010/2011
                                                                                        ACTUAL                 BUDGET

Purchases                                                                                      XXXX                  XXXX
Eskom                                                                                           XXX                   XXX
Self generation                                                                                 XXX                   XXX
Other (please specify: ………………………………..)                                                          XXX                   XXX

Salaries and Maintenance                                                                       XXXX                  XXXX
Salaries, Wages and allowances (own staff)                                                      XXX                   XXX
Payments to consultants (operational work)                                                      XXX                   XXX
Payments to consultants (capital work)                                                          XXX                   XXX
Repairs and Maintenance (excluding salaries and allowances)                                     XXX                   XXX

Capital Charges                                                                                XXXX                  XXXX
Redemption (External Loans)                                                                     XXX                   XXX
Redemption (Internal Loans)                                                                     XXX                   XXX
Interest   (External Loans)                                                                     XXX                   XXX
Interest   (Internal Loans)                                                                     XXX                   XXX

Contribution to Capital                                                                            XXX                 XXX

Contribution to Funds                                                                          XXXX                  XXXX
Capital Development Fund                                                                        XXX                   XXX
Tariff Equalisation Fund                                                                        XXX                   XXX
Renewal Fund                                                                                    XXX                   XXX
Bad Debt Reserve                                                                                XXX                   XXX
Maintenance provision                                                                           XXX                   XXX
Other (please specify: ………………………………..)                                                          XXX                   XXX

Charges allocated from other Municipal Departments (Admin. Charges)                              XXX                   XXX
Charges allocated to other Municipal Departments                                               (XXX)                 (XXX)
General Expenses                                                                                 XXX                   XXX

Total Expenditure:                                                                           XXXXX                  XXXXX


Surplus/Deficit                                                                                XXXX                  XXXX




NERSA (Information Resource Management Department)                                                                 Page 6
NERSA Distribution forms completion guide                                                                         July 2010




D1 FORM (SECTION 6): NON-PAYMENT AND BAD DEBT


NOTE:

   Please remember that this information is for a ring-fenced Electricity Distribution Account.
   All amounts should exclude value added tax (VAT).


WHERE to get the information:

The information can be obtained from the Municipal Financial Statements. Another source of information is the report
on: “The ring fencing of Municipalities Electricity Departments and Eskom Distribution activities into Regional Electricity
Distributors (REDS) follow the 1998 White Paper on Energy Policy whose main objective was to synergize the
electricity distribution to customers towards a more effective, efficient and less fragmented industry”.


IMPORTANT:

Some of the totals written off can also be obtained from the previous year’s NERSA D-1 form.




NERSA (Information Resource Management Department)                                                                 Page 7
NERSA Distribution forms completion guide                                                                         July 2010




D1 FORM (SECTION 7): ALLOCATION OF THE SURPLUS AS CALCULATED IN SECTION 4


NOTE:

    Please do not complete this section in the case of a deficit.
    Please remember that this information is for a ring-fenced Electricity Distribution Account.
    All amounts should exclude value added tax (VAT).


WHERE to get the information:

The information can be obtained from the Municipal Financial Statements. Another source of information is the report
on: “The ring fencing of Municipalities Electricity Departments and Eskom Distribution activities into Regional Electricity
Distributors (REDS) follow the 1998 White Paper on Energy Policy whose main objective was to synergize the
electricity distribution to customers towards a more effective, efficient and less fragmented industry”.


EXAMPLE:

CASH FLOW STATEMENT FOR THE YEAR ENDED 30 JUNE 2010
                                                                      Note           2009/2010               2010/2011
                                                                                         R                       R

CASH RETAINED FROM OPERATING ACTIVITIES                                                    263 759                  258 467

Cash generated by operations                                           19                  333 628                  337 590
Investment Income                                                      17                    14 295                   10 488
(Increase)/Decrease in working capital                                 20                  (14 150)                 (58 131)
                                                                                           333 773                  289 947

Less: External interest paid                                           17                  (83 309)                 (50 244)

Cash available from operations                                                             250 464                  239 703


Cash contributions from the public and State                                                     -                        -
Net proceeds on disposal of fixed assets                                                    13 295                   18 764

CASH UTILISED IN INVESTING ACTIVITIES
Investment in Fixed Assets                                                                (451 812)                (370 416)

NET CASH FLOW                                                                             (188 053)                (111 949)

CASH EFFECTS OF FINANCING ACTIVITIES
Increase/(decrease) in long-term loans                                 21                   374 582                  56 169
Increase/(decrease) in short-term loans                                22                 (100 000)                       -
(Increase)/decrease in cash investments                                23                  (83 918)                  53 113
(Increase)/decrease in cash                                            24                    (2 611)                  2 657

Net cash (generated)/utilised)                                                             188 053                  111 949




NERSA (Information Resource Management Department)                                                                 Page 8
NERSA Distribution forms completion guide                                                                         July 2010




                                            D2 - Form: Market Information


D2 FORM (SECTION 1): GENERAL INFORMATION DEFINITIONS AND INSTRUCTIONS

   All information requested relates to a RING-FENCED ELECTRICITY DISTRIBUTION ACTIVITY.
   RING-FENCED means that separate accounts are kept for the electricity distribution activity. This should ensure
    that the revenues, costs, assets, liabilities, reserves and provisions are separately identifiable from those of any
    other business in the books of account of the licensee.
   Financial information is to be stated in R’000 (For example. R1 234 567.00 should be stated as 1 235).
   Sales information is to be stated in MWh (NOT GWh or kWh).
   In sections 2, 3 and 4 the information in the actual column is in respect of the actual figures for the financial year
    ending on 30 June 2010 and the information in the budget column is in respect of the budget figures for the
    financial year ending on 30 June 2011


Consumer definitions

A consumer is a person or legal entity who:
 receives a supply of electricity in terms of a legal supply agreement entered into with a Supplier of electricity and
 is legally responsible for payment to the Supplier for electricity and/or related services used.


A distinction is made between two types of Consumers:

1. End-use consumer:

    The end-use consumer actually uses the electricity purchased to produce light, heat, processes and other forms of
    energy. A typical example of an end-use consumer is the domestic consumer who has an account with a supplier. In
    this example there is a supply agreement between the supplier and the end-use consumer. The consumer is thus
    also the customer.

2. Bulk Consumer:

    The bulk consumer distributes electricity to groups of end-use consumers. A supplier meters the consumption for
    each bulk consumer (which is the total consumption of a group of end-use consumers) and bills the consumer
    (please see diagram overleaf). The bulk consumer may or may not meter the individual consumption of end-use
    consumers, but end-use Consumers have agreements with their bulk consumer regarding the payment for
    consumption. A typical example of a bulk consumer is in the case of blocks of flats where the bulk consumers
    distribute to the occupants. The licensee should provide information as metered for the bulk consumer.


Supplier and the Supply Agreement

   A supplier is the licensed distributor of electricity.

   The supply agreement is the legal agreement between a supplier of electricity and a consumer setting out the
    general conditions under which the electricity product and related services are provided, and the obligations of a
    supplier and the consumer towards each other. Separate agreements may be entered into for certain aspects of the
    same supply - e.g. networks or wheeling charges and energy charges. For each account of the consumer specific
    detailed information such as fixed charges, instalment payment, applicable tariffs, etc. are maintained.


Point of connection

The point of connection is the point at which the electricity installation on any premises is connected to the distribution
system of a supplier. This is also referred to as the point of supply. End-use consumers may or may not have meters at
the connection point where they take supply from the bulk consumer.



NERSA (Information Resource Management Department)                                                                 Page 9
NERSA Distribution forms completion guide                                                                          July 2010



Consumer Classification

In order to evaluate important parameters within the major components of the end-user electricity market, the NERSA
requires end-use and bulk consumers to be classified according to the Standard Industrial Classification (SIC)
Categories defined in the fifth edition of the Standard Industrial Classification of all Economic Activities by Statistics
South Africa. The SIC Categories are groupings of economic activities across diverse industries.

Licensees are required to complete the market information by utilizing the SIC categories provided in this form.
Classifying according to the SIC categories provides a standardised framework for the collection, tabulation, analysis
and presentation of statistical data according to kind of economic activity.

It is understood that adequate records may not be readily available in the required format as tariffs do not necessarily
coincide with the SIC Categories. It is thus recommended that the larger non-domestic Consumers of all licensed
Distributors be classified according to the Major Divisions of the SIC within the information systems of Licensees.


Diagram of typical supply agreements

             Supplier                                          Supplier


    Consumer       supply agreement                    Consumer     supply agreement


Tariff 1      Meter*             Tariff 2    Meter*                             Tariff 3    Meter*
Accnt 1                          Accnt 2                                        Accnt 3

             End-use                         End-use                                         Bulk
            Consumer                        Consumer                                       Consumer




                                                                  Tariff 4    Meter*          Tariff 5    Meter*
                                                                  Accnt 4                     Accnt 5

                                                                              End-use                     End-use
                                                                             Consumer                    Consumer
 * Point of connection




NERSA (Information Resource Management Department)                                                                 Page 10
NERSA Distribution forms completion guide                                                                            July 2010




D2 FORM (SECTION 2): PURCHASES OF ELECTRICITY

NOTE:

In the “Name of supplier” column, ALL electricity purchased from outside suppliers, self-generated or co-generated
should be included.


WHERE to get the information:

The information can be obtained from the Municipal Financial Statements. Another source of information is the report
on: “The ring fencing of Municipalities Electricity Departments and Eskom Distribution activities into Regional Electricity
Distributors (REDS) follow the 1998 White Paper on Energy Policy whose main objective was to synergize the
electricity distribution to customers towards a more effective, efficient and less fragmented industry”.

The example on the Excel sheet, NERSA STATS.xls can also be used to compile the information. The completed sheet
can also be e-mailed to the address in this document.


EXAMPLE:

The following table is an example. The information refers to cells in the example in the Excel sheet, NERSA STATS.xls.
If the correct account information was completed in the sheet, the required information will be calculated by the sheet
and given in the referred cell. The same sheets can be duplicated for different accounts (and suppliers, like “self
generation” or “other”) and given in exactly the same way.

                                             Peak monthly maximum              Total energy            Average
                                                      demand                    purchased         Demand charge
              Supplier                                  (MVA)                     (MWh)            (R/kVA/month)
                                                Actual         Budget       Actual      Budget    Actual
                                               2009/10        20010/11     2009/10     20010/11        2009/10
              Eskom                         NightSave                    NightSave                NightSave sheet,
                                            sheet, cell                  sheet, cell              cell AK19
                                            G19                          E18
                                            +                            +                        +
                                            MegaFlex                     MegaFlex
                                            sheet, cell I19              sheet, cell              MegaFlex sheet,
                                                                         F18                      cell AP19
              Self generation
              Other, specify:
              ………………
              Totals

The Budget figures can be supplied from the existing year’s tariff budget.




NERSA (Information Resource Management Department)                                                                   Page 11
NERSA Distribution forms completion guide                                                                                        July 2010




D2 FORM (SECTION 3): ELECTRICITY SALES, NUMBER OF CONSUMERS AND SYSTEM
                     DETAILS

WHERE to get the information:

The information can be obtained from the Municipal Financial Statements. Another source of information is the report
on: “The ring fencing of Municipalities Electricity Departments and Eskom Distribution activities into Regional Electricity
Distributors (REDS) follow the 1998 White Paper on Energy Policy whose main objective was to synergize the
electricity distribution to customers towards a more effective, efficient and less fragmented industry”.

The example in Excel sheet, NERSA STATS.xls can also be used to compile the information.

If no half-hourly load profiles are available, the average power factor can normally be read from the power factor meter
in the Eskom supply substation.


IMPORTANT:

The percentage MWh losses is calculated as follows:

                                         MWh Purchased and Generated  MWh Sold
                                                                                 100 %
                                             MWh Purchased and Generated


The average system load factor is calculated as follows:

                                    MWh Purchased and Generated in the Month
                                                                                       100 %
                          Monthly Maximum Demand in MW  Number of hours in the month


 The Average load factor is the average of the 12 Monthly Load Factors. This is done in the Excel sheet, NERSA
  STATS.xls, where the monthly accounts can be updated.


EXAMPLE:

The following table is an example. The information refers to cells in the example Excell sheet, NERSA STATS.xls. If the
correct account information was completed in the sheet, the required information will be calculated by the sheet and
given in the referred cell.
Sales and own use in the licensed area of supply                              ACTUAL                                     BUDGET
                                                                               2009/10                                   2010/11
MWh sold to consumers                                          Sales 2009 2010 sheet, cell Q60
MWh sold for redistribution by other licensee                  Sales 2009 2010 sheet, cell Q61
MWh for own use                                                Sales 2009 2010 sheet, cell P41
MWh used for street lighting                                   Sales 2009 2010 sheet, cell P43
MWh sold to other departments                                  Sales 2009 2010 sheet, cell P42
Total MWh sales

Total number of consumers                                      Sales 2009 2010 sheet, cell C24

System details
Total energy (MWh) purchased and generated                     This is from the “Total” of section 2, Actual.   This is from the “Total” of
                                                                                                                section 2, Budget.
Percentage MWh losses                                          Sales 2009 2010 sheet, cell P30
Average System Load Factor                                     Average
                                                               (NightSave sheet, cell AP18
                                                               +
                                                               MegaFlex sheet, cell AV18)
Average System Power Factor




NERSA (Information Resource Management Department)                                                                               Page 12
NERSA Distribution forms completion guide                                                                         July 2010




D2 FORM (SECTION 4): CONSUMER PROFILE

NOTE:

The Standard Industrial Classification of all Economic activities, Fifth Edition, Statistics South Africa, January 1993 is
applicable.


WHERE to get the information:

The information can be obtained from the Municipal Financial Statements. Another source of information is the report
on: “The ring fencing of Municipalities Electricity Departments and Eskom Distribution activities into Regional Electricity
Distributors (REDS) follow the 1998 White Paper on Energy Policy whose main objective was to synergize the
electricity distribution to customers towards a more effective, efficient and less fragmented industry”.

The example in the Excel sheet, NERSA STATS.xls can also be used to compile the information.


IMPORTANT:

The following figures should be identical:

   D2 Form (Section 3) Total number of consumers            &      D2 Form (Section 4) Total number of consumers
   D2 Form (Section 3) Total MWh sales                      &      D2 Form (Section 4) Total sales (MWh)
   D1 Form (Section 4) Revenue from sales of electricity    &      D2 Form (Section 4) Total Revenue


EXAMPLE:

The following table is an example. The information refers to cells in the example in the Excel sheet, NERSA STATS.xls.
If the correct account information was completed in the sheet, the required information will be calculated by the sheet
and given in the referred cell.

An example of a financial system Sebata is also icluded. The BillR report for a month as exported as a CSV, or comma,
delimited. File. This can be used in a word processor package (like Word) or in a spreadsheet package (like Excel).
                                                                                                          th
The complete BillR report is given in a separate file, BillR08080001 example.TXT. This is for the 8 month of the
financial year, February 2008.

The information is reduced to a Business tariff and a demand and energy tariff.




NERSA (Information Resource Management Department)                                                                Page 13
NERSA Distribution forms completion guide                                                                                              July 2010


The Business tariff information is given in the next table.
LOCAL MUNICIPALITY
E L E C T R I C I T Y    S A L E S   S T A T S                                                                             P.
____________________________________________________________________________________________________________________________________
  Minimums      Account BasCharge Step    Limit    Tariff       Units      Amount                 Adjustments
  TotMinms      NoUsers TotBasChrg                                                              Units    Amount
____________________________________________________________________________________________________________________________________

E E105 BUSINESS
      0.00 008189310000     91.16    1 99999999   0.44930      73928    33215.85                   0       0.00
      0.00           33   3008.28    2        0   0.00000          0        0.00
                                     3        0   0.00000          0        0.00
                                     4        0   0.00000          0        0.00
                                     5        0   0.00000          0        0.00
                                     6        0   0.00000          0        0.00
                                     7        0   0.00000          0        0.00
                                     8        0   0.00000          0        0.00
                                     9        0   0.00000          0        0.00
                                    10        0   0.00000          0        0.00
                                    11        0   0.00000          0        0.00
                                    12        0   0.00000          0        0.00
                                    13        0   0.00000          0        0.00
                                    14        0   0.00000          0        0.00
                                    15        0   0.00000          0        0.00
      0.00         0.00   1488.28                  TOTALS      73928    33215.85    34704.13           0      0.00 ***
No of meters read     =              37
No of meters interimed=               8
No of interims raised =               4
Interims raised       =         1120.86
Interims reversed     =         -831.38


From this, the following is used in the example in Excel sheet, NERSA STATS.xls:
 The code for this tariff is E105 BUSINESS.
 This tariff consists of a fixed charge, or monthly service charge, and the cost for the consumption.
 Number of customers billed on this tariff for this month is 33. This is entered into the example in Excel, NERSA
   STATS.xls, Sales 2009 2010 sheet. This is done for each month for each tariff
 Tariff for the monthly service charge is R91.16, VAT excluded. If this amount is multiplied by the number of
   customers, 33, the amount of R3,008.28 was billed.
 The tariff for the energy consumed, in kWh, for this tariff is R0.4493/kWh.
 The consumption of energy billed to the customers on this tariff for this month was 73,928kWh (or units). This is
   entered into the example in Excel, NERSA STATS.xls, Sales 2009 2010 sheet. This is done for each month for
   each tariff
 If this consumption is multiplied by the rate, the amount of R33,215.85 was billed.
 The sum of the two amounts, R3,008.28+R33,215.85=R36,224.13, are entered into the example in Excel, NERSA
   STATS.xls, Sales 2009 2010 sheet. This is done for each month for each tariff.




NERSA (Information Resource Management Department)                                                                                     Page 14
NERSA Distribution forms completion guide                                                                                              July 2010


The Large Power ser tariff, or demand tariff, information is given in the next table.

LOCAL MUNICIPALITY
E L E C T R I C I T Y    S A L E S   S T A T S                                                                             P.
____________________________________________________________________________________________________________________________________
  Minimums      Account BasCharge Step    Limit    Tariff       Units      Amount                 Adjustments
  TotMinms      NoUsers TotBasChrg                                                              Units    Amount
____________________________________________________________________________________________________________________________________

E E108 KVA CONSUMER
      0.00 008189310000    364.65     1 99999999     0.18000    112962   20333.16                  0       0.00
      0.00            4   1458.60     2        0     0.00000         0       0.00
                                      3        0     0.00000         0       0.00
                                      4        0     0.00000         0       0.00
                                      5        0     0.00000         0       0.00
                                      6        0     0.00000         0       0.00
                                      7        0     0.00000         0       0.00
                                      8        0     0.00000         0       0.00
                                      9        0     0.00000         0       0.00
                                     10        0     0.00000         0       0.00
                                     11        0     0.00000         0       0.00
                                     12        0     0.00000         0       0.00
                                     13        0     0.00000         0       0.00
                                     14        0     0.00000         0       0.00
                                     15        0     0.00000         0       0.00
      0.00         0.00   1458.60                     TOTALS    112962   20333.16   21791.76        0        0.00 ***
No of meters read     =                4
No of meters interimed=                0
No of interims raised =                0
Interims raised       =             0.00
Interims reversed     =             0.00


E K108 KVA CONSUMER
      0.00 008189310000      0.00     1   99999999   60.36000      301   18168.36                  0       0.00
      0.00            4      0.00     2   99999999   60.36000        0       0.00
                                      3   99999999   60.36000        0       0.00
                                      4   99999999   60.36000        0       0.00
                                      5   99999999   60.36000        0       0.00
                                      6          0    0.00000        0       0.00
                                      7          0    0.00000        0       0.00
                                      8          0    0.00000        0       0.00
                                      9          0    0.00000        0       0.00
                                     10          0    0.00000        0       0.00
                                     11          0    0.00000        0       0.00
                                     12          0    0.00000        0       0.00
                                     13          0    0.00000        0       0.00
                                     14          0    0.00000        0       0.00
                                     15          0    0.00000        0       0.00
      0.00         0.00      0.00                      TOTALS      301   18168.36   18168.36           0      0.00 ***
No of meters read     =                4
No of meters interimed=                0
No of interims raised =                0
Interims raised       =             0.00
Interims reversed     =             0.00



From this, the following is used in the example Excell sheet, NERSA STATS.xls:
     The code for this tariff is E108 KVA CONSUMER. It is important to know that this tariff also has a demand
      component. This is under the code E K108 KVA CONSUMER.
     This tariff consists of a fixed charge, or monthly service charge, the cost for the consumption in kWh and the cost
      for the maximum consumption in any integration period in kVA.
     Number of customers billed on this tariff for this month is 4. This is entered into the example in Excel, NERSA
      STATS.xls, Sales 2009 2010 sheet. This is done for each month for each tariff
     Tariff for the monthly service charge is R364.65, VAT excluded. If this amount is multiplied by the number of
      customers, 4, the amount of R1,458.60 was billed.
     The tariff for the energy consumed, in kWh, for this tariff is R0.1800/kWh.
     The consumption of energy billed to these customers on this tariff for this month was 112,962kWh (or units). This
      is entered into the example in Excel, NERSA STATS.xls, Sales 2009 2010 sheet. This is done for each month for
      each tariff
     If this consumption is multiplied by the rate, the amount of R20,333.16 was billed.
     From the second set of information, with the code E K108 KVA CONSUMER, one can also see that there are 4
      customers.
     The tariff for the maximum demand registered, in kVA, for this tariff is R60.36/kVA per month.
     The summated maximum demand billed to these customers on this tariff for this month was 301kVA.
     If this summated maximum demand is multiplied by the rate, the amount of R18,168.36 was billed.
     The sum of the two amounts for the service charge and for the energy charge,
      R1,458.60+R20,333.16=R21,791.76, are entered into the example in Excel, NERSA STATS.xls, Sales 2009
      2010 sheet. This is done for each month for each tariff.
     For the demand tariff the amount for maximum demand is also entered into the example in Excel, NERSA
      STATS.xls, Sales 2009 2010 sheet. This is done for each month for each of the maximum demand tariffs.




NERSA (Information Resource Management Department)                                                                                     Page 15
NERSA Distribution forms completion guide                                                                                         July 2010


The result of this is then entered into the D2-form as shown in the next table.

                                        No. of consumers                           Sales (MWh)                      Revenue (R’000)
SIC Category                           (end-user and bulk)
                                Actual       Budget       Estimate     Actual        Budget      Estimate     Actual    Budget    Estimate
                               2009/10       2010/11       2011/12    2009/10        2010/11     2011/12     2009/10    2010/11   2011/12
Domestic                     Sales 2008                              Sales 2008                             Sales
(SIC 0)                      2009 sheet,                             2009                                   2008
                             cell AM58                               sheet, cell                            2009
                                                                     AN58                                   sheet,
                                                                                                            cell AO58
Agriculture                  Sales 2008                              Sales 2008                             Sales
(SIC 1)                      2009 sheet,                             2009                                   2008
                             cell AM59                               sheet, cell                            2009
                                                                     AN59                                   sheet,
                                                                                                            cell AO59
Mining      &    quarrying   Sales 2008                              Sales 2008                             Sales
(SIC 2)                      2009 sheet,                             2009                                   2008
                             cell AM60                               sheet, cell                            2009
                                                                     AN60                                   sheet,
                                                                                                            cell AO60
Manufacturing                Sales 2008                              Sales 2008                             Sales
(SIC 3)                      2009 sheet,                             2009                                   2008
                             cell AM61                               sheet, cell                            2009
                                                                     AN61                                   sheet,
                                                                                                            cell AO61
Commercial                   Sales 2008                              Sales 2008                             Sales
(SIC 6)                      2009 sheet,                             2009                                   2008
                             cell AM62                               sheet, cell                            2009
                                                                     AN62                                   sheet,
                                                                                                            cell AO62
Transport                    Sales 2008                              Sales 2008                             Sales
(SIC 7)                      2009 sheet,                             2009                                   2008
                             cell AM63                               sheet, cell                            2009
                                                                     AN63                                   sheet,
                                                                                                            cell AO63
General                      Sales 2008                              Sales 2008                             Sales
(SIC 4, 5, 8, 9)             2009 sheet,                             2009                                   2008
                             cell AM64                               sheet, cell                            2009
                                                                     AN64                                   sheet,
                                                                                                            cell AO64
Redistribution               Sales 2008                              Sales 2008                             Sales
                             2009 sheet,                             2009                                   2008
                             cell AM65                               sheet, cell                            2009
                                                                     AN65                                   sheet,
                                                                                                            cell AO65
Own use, street lighting     Sales 2008                              Sales 2008                             Sales
or sold to other depts.      2009 sheet,                             2009                                   2008
                             cell AM66                               sheet, cell                            2009
                                                                     AN66                                   sheet,
                                                                                                            cell AO66
Totals




NERSA (Information Resource Management Department)                                                                                Page 16
NERSA Distribution forms completion guide                                                                      July 2010




                                      D3 - Form: Human Resources Information



D3 FORM (SECTION 1): GENERAL INFORMATION AND INSTRUCTIONS

   All information relates to a ring-fenced electricity activity
   Only include information of personnel who are predominantly involved in the distribution of electricity



D3 FORM (SECTION 2): HUMAN RESOURCES - NUMBERS

WHERE to get the information:

The information can be obtained from the Municipal Financial Statements or the Human Resources Department.
Another source of information is the report on: “The ring fencing of Municipalities Electricity Departments and Eskom
Distribution activities into Regional Electricity Distributors (REDS) follow the 1998 White Paper on Energy Policy whose
main objective was to synergize the electricity distribution to customers towards a more effective, efficient and less
fragmented industry”.




NERSA (Information Resource Management Department)                                                             Page 17
NERSA Distribution forms completion guide                                                                      July 2010


Consistency checks
After forms NER D1 to NER D3 have been completed, confirm the following with regard to consistency of information
provided by ticking in the boxes provided:

ITEM                               D1 - Form                           D2 - Form                   D3 - Form

REVENUE                            Section 4                           Section 4
                                   Revenue from sales of electricity   Totals, Revenue

Confirm: The revenue items above are equal

CONSUMERS                                                              Section 3
                                                                       Total number of Consumers

                                                                       Section 4
                                                                       Totals, No. of Consumers
Confirm: The Consumers items above are equal

ENERGY SOLD                                                            Section 3
                                                                       Total MWh sales

                                                                       Section 4
                                                                       Total MWh sales
Confirm: The energy sold items above are equal




NERSA (Information Resource Management Department)                                                             Page 18

								
To top