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:
Distribution Forms to be completedSubmission deadline
to NERSAD1 Form: Financial information 31 October 2010D2 Form: Market information 31 October 2010D3 Form: Human resources information 31 October 2010D4 Form: Technical information 31 October 2010D5 Form: Connection information 31 October 2010D6 Form: Tariff information 31 October 2010D7 Form: Application for a tariff increase / tariff structure change 31 March 2011D8 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: [email protected]: (012) 401-4700Post: PO Box 40343, Arcadia, 0007
For further enquiries please do not hesitate to contact Ms Thandeka Jamba (Senior Statistician) at:
Tel: (012) 401-4665Cell: (082) 538-7180E-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 HouseIMFO Corner of Bordeaux and Rider streetsP O Box 3322 RandburgRandburg Telephone: (011) 789-74432125 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 2010Note 2009/2010 2008/2009
R R
CAPITAL EMPLOYED
FUNDS AND RESERVES 1 233 413 1 044 737
Statutory funds 1 1 117 384 912 318Reserves 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 020LONG-TERM LIABILITIES 4 911 988 444 365CONSUMER DEPOSITS 5 62 459 52 468
2 247 926 1 622 769
EMPLOYMENT OF CAPITAL
FIXED ASSETS 6 1 879 679 1 583 177INVESTMENTS 7 128 094 44 176LONG-TERM DEBTORS 8 140 500 120 300DEFERRED 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 656Inventory 9 61 433 59 313Debtors 10 454 792 382 841Cash 11 772 9 169Short-term investments - -Short-term portion of long-term debtors 8 4 377 3 341
CURRENT LIABILITIES 459 857 581 947Provisions 12 - -Creditors 13 422 480 351 529Short-term portion of long-term liabilities 4 37 377 230 418Bank 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/2011ACTUAL BUDGET
REVENUE FROM SALES TO CONSUMERS (All sales from tariffs) XXX XXXREVENUE FROM SALE FOR REDISTRIBUTION XXX XXXREVENUE FROM SALES FOR OWN USE XXX XXX1. Revenue from Sales for Street Lighting XX XX2. Revenue from Sales to Other departments XX XX
TOTAL REVENUE FROM SALES XXXX XXXX
OTHER REVENUE XXX XXX1. Reconnections Fees XX XX2. New Connections XX XX3. Electricity Service Charges XX XX4. 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:
EXPENDITURE2009/2010 2010/2011ACTUAL BUDGET
Purchases XXXX XXXXEskom XXX XXXSelf generation XXX XXXOther (please specify: ………………………………..) XXX XXX
Salaries and Maintenance XXXX XXXXSalaries, Wages and allowances (own staff) XXX XXXPayments to consultants (operational work) XXX XXXPayments to consultants (capital work) XXX XXXRepairs and Maintenance (excluding salaries and allowances) XXX XXX
Capital Charges XXXX XXXXRedemption (External Loans) XXX XXXRedemption (Internal Loans) XXX XXXInterest (External Loans) XXX XXXInterest (Internal Loans) XXX XXX
Contribution to Capital XXX XXX
Contribution to Funds XXXX XXXXCapital Development Fund XXX XXXTariff Equalisation Fund XXX XXXRenewal Fund XXX XXXBad Debt Reserve XXX XXXMaintenance provision XXX XXXOther (please specify: ………………………………..) XXX XXX
Charges allocated from other Municipal Departments (Admin. Charges) XXX XXXCharges 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 2010Note 2009/2010 2010/2011
R R
CASH RETAINED FROM OPERATING ACTIVITIES 263 759 258 467
Cash generated by operations 19 333 628 337 590Investment 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 ACTIVITIESInvestment in Fixed Assets (451 812) (370 416)
NET CASH FLOW (188 053) (111 949)
CASH EFFECTS OF FINANCING ACTIVITIESIncrease/(decrease) in long-term loans 21 374 582 56 169Increase/(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 1Accnt 1
Meter* Tariff 2Accnt 2
Meter* Tariff 3Accnt 3
Meter*
End-use Consumer
End-useConsumer
Bulk Consumer
Tariff 4Accnt 4
Meter* Tariff 5Accnt 5
Meter*
End-use Consumer
End-use 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.
Supplier
Peak monthly maximum demand
Total energypurchased
Average Demand charge
(MVA) (MWh) (R/kVA/month)Actual Budget Actual Budget Actual
2009/10 20010/11 2009/10 20010/11 2009/10Eskom NightSave
sheet, cell G19 +MegaFlex sheet, cell I19
NightSave sheet, cell E18+MegaFlex sheet, cell F18
NightSave sheet, cell AK19
+
MegaFlex sheet, cell AP19
Self generationOther, 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:
The average system load factor is calculated as follows:
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 ACTUAL2009/10
BUDGET2010/11
MWh sold to consumers Sales 2009 2010 sheet, cell Q60MWh sold for redistribution by other licensee Sales 2009 2010 sheet, cell Q61MWh for own use Sales 2009 2010 sheet, cell P41MWh used for street lighting Sales 2009 2010 sheet, cell P43MWh sold to other departments Sales 2009 2010 sheet, cell P42Total 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 P30Average 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).
The complete BillR report is given in a separate file, BillR08080001 example.TXT. This is for the 8 th month of the financial year, February 2008.
The information is reduced to a Business tariff and a demand and energy tariff.
The Business tariff information is given in the next table.
NERSA (Information Resource Management Department) Page 13
NERSA Distribution forms completion guide July 2010
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 = 37No of meters interimed= 8No of interims raised = 4Interims raised = 1120.86Interims 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 = 4No of meters interimed= 0No of interims raised = 0Interims raised = 0.00Interims 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 = 4No of meters interimed= 0No of interims raised = 0Interims raised = 0.00Interims 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.
SIC CategoryNo. of consumers
(end-user and bulk)Sales (MWh) Revenue (R’000)
Actual Budget Estimate Actual Budget Estimate Actual Budget Estimate2009/10 2010/11 2011/12 2009/10 2010/11 2011/12 2009/10 2010/11 2011/12
Domestic (SIC 0)
Sales 2008 2009 sheet, cell AM58
Sales 2008 2009 sheet, cell AN58
Sales 2008 2009 sheet, cell AO58
Agriculture(SIC 1)
Sales 2008 2009 sheet, cell AM59
Sales 2008 2009 sheet, cell AN59
Sales 2008 2009 sheet, cell AO59
Mining & quarrying (SIC 2)
Sales 2008 2009 sheet, cell AM60
Sales 2008 2009 sheet, cell AN60
Sales 2008 2009 sheet, cell AO60
Manufacturing(SIC 3)
Sales 2008 2009 sheet, cell AM61
Sales 2008 2009 sheet, cell AN61
Sales 2008 2009 sheet, cell AO61
Commercial (SIC 6)
Sales 2008 2009 sheet, cell AM62
Sales 2008 2009 sheet, cell AN62
Sales 2008 2009 sheet, cell AO62
Transport (SIC 7)
Sales 2008 2009 sheet, cell AM63
Sales 2008 2009 sheet, cell AN63
Sales 2008 2009 sheet, cell AO63
General(SIC 4, 5, 8, 9)
Sales 2008 2009 sheet, cell AM64
Sales 2008 2009 sheet, cell AN64
Sales 2008 2009 sheet, cell AO64
Redistribution Sales 2008 2009 sheet, cell AM65
Sales 2008 2009 sheet, cell AN65
Sales 2008 2009 sheet, cell AO65
Own use, street lighting or sold to other depts.
Sales 2008 2009 sheet, cell AM66
Sales 2008 2009 sheet, cell AN66
Sales 2008 2009 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 Revenue from sales of electricity
Section 4Totals, Revenue
Confirm: The revenue items above are equal
CONSUMERS Section 3Total number of Consumers
Section 4Totals, No. of Consumers
Confirm: The Consumers items above are equal
ENERGY SOLD Section 3Total MWh sales
Section 4Total MWh sales
Confirm: The energy sold items above are equal
NERSA (Information Resource Management Department) Page 18