nersa d-f…  · web viewin order to evaluate important parameters within the major components of...

31
NATIONAL ENERGY REGULATOR OF SOUTH AFRICA NERSA DISTRIBUTION FORMS COMPLETION GUIDE

Upload: others

Post on 16-Aug-2020

0 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

NATIONAL ENERGY REGULATOR OF SOUTH AFRICA

NERSA DISTRIBUTION FORMS

COMPLETION GUIDE

Date: July 2010

Page 2: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 3: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 4: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 5: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 6: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 7: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 8: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 9: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 10: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 11: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 12: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 13: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 14: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 15: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 16: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 17: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 18: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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

Page 19: NERSA D-F…  · Web viewIn order to evaluate important parameters within the major components of the end-user electricity market, the NERSA requires end-use and bulk consumers to

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