CESC Ltd.

INDEX
Sl.No Particulars
Page - No
1. REFERENCE
1
2. ACKNOWLEDGEMENT
2
3. ABOUT CESC

LIGHTING THE WAY TO FUTURE
3

LIGHT ON THE PAST 4
4. RPG ENTERPRISE
9
5. FUNCTIONAL DEPARTMENT OF CESC
10
6. MY PROJECT WORK
11
7 CONSUMER NUMBER ALLOCATION
12
8. PRE-BILLING SECTION

MI SYSTEM
16
COMPUTER AIDED SCREEN – BILL
20
TEMPORARY BILL


EXAMPLE OF TEMPORARY BILL

NON- ACTUAL BILL

OFFLINE ELECTRONIC DATA ENTRY 24
9. POST-BILLING SECTION

COMPLAIN
25
METER DEFFECT CODES
25,26
TARIFF
27

FORM MENU
27,28
LETTER SECTION
28,29

ABATEMENT SECTION 30

10. REFERENCE SECTION

RECONNECTION AND DISCONNECTION
31
BURNT METER
32
VALUNTARY DISCONNECTION
32
NAME TRANSFER
32
LOST CONTROL CELL
32
11. OFFLINE DATA ENTRY (PAYMENT DATA ENTRY)
34
12. SECURITY
34
PART REFUND
41
NAME TRANSFER
35
VOLUNTARY DISCONNECTION
35
OUTSTANDING CUTTOFF
35
13. OUTSTANDING SECTION
36
14. POSTING SECTION
37
SUSPENSE
38
BILL ADJUSTMENT
38
COPY BILL
39
TEMPORARY BILL REFUND 39
15. CONSUMER GRIEVANCE CELL
39
16. CREDIT CONTROL
40
17 OVERALL REVIEW
41
18. CONCLUSION 42





[30th August 2010]
CESC HOUSE | Project done by RAJA SARKAR



 PREFACE…


This report has been prepared by me in CALCUTTA ELECTRICT SUPPLY CORPORATON LIMITED. The objective of preparing this Project report is to make aware the organization about the procedure of different COMMERCIAL JOBS within the said organization and preview of all the steps involved in the process.
Study was also conducted to have the in-depth knowledge of commercial work that exists in same profiled organization.
Various related articles were studied and discussions were held on Project related topics during the Internship. The process for Customer interaction and back-end process were also studied in both theoretically and practically.














ACKNOWLEDGEMENT


This project study has been made possible through the direct and indirect help of various persons to whom I wish to express my gratitude. Also I want to thanks the organization for providing great opportunity in this competitive world.

I would like to thanks Mr. DEBDUTTA MAITRA ( Dy. General Manager ,HRD Taratolla) for providing me the opportunity to explore my inner self, I also want to thank all the employee of Commercial Department of Central Regional Office at Chowringhee Square and specially my mentor Mrs. SRABANI SETH (Assistant Manager) for providing me such a great learning environment.

Heartily thankful to Mr. VINAY RAI (Director- RAI BUSINESS SCHOOL) to give me this opportunity to conduct a research work to improve the quality of information collected from many sources.







CALCUTTA ELECTRIC SUPPLY CORORATION LIMITED

Lighting the way to the future

Starting as India's first fully integrated electrical utility, CESC has been generating and distributing electrical power in Kolkata and Howrah since 1899.
CESC is the sole distributor of electricity within an area of 567 sq km of Kolkata and Howrah serving 2.3 million consumers which includes domestic, industrial and commercial users. CESC own and operate four thermal power plants generating 1225 MW of power. These are Budge Budge Generating Station (750 MW), Southern Generating Station (135 MW), Titagarh Generating Station (240 MW) and New Cossipore Generating Station (100 MW). Almost 88% of the customers electricity requirement is met from their own generating plants, rest 12% of electricity is purchased from third parties. More than 50% of the coal requirement is sourced from captive mines We own and operate the Transmission & Distribution system through which we supply electricity to consumers. This system comprises of 474 km circuit of transmission lines linking the Company's generating and receiving stations with 85 distribution stations; 3,837 km circuit of HT lines further linking distribution stations with LT substations, large industrial consumers and 9,867 km circuit of LT lines connecting the LT substations to LT consumers CESC is in process of setting up a number of power stations in the country. CESC Limited is a flagship company of RPG Enterprises, one of India's leading industrial houses. In 1989 , CESC become a part of RPG Group.
In CESC , they divide their consumer in different parts according to the region. In all over Calcutta they divide the whole in Six Districts which are as follows……

Central Regional Office (CRO) ----Chowringhee Square, KOLKATA
North Regional Office (NRO) ----Shyam Bazar, KOLKATA
North Suburvan Regional Office (NSRO) ----Kamarhati, KOLKATA
Howrah Regional Office (HRO) ----Howrah
South Regional Office (SRO) ----Ballyguange, KOLKATA
South West Regional Office (SWRO) ----Taratolla, KOLKATA

In CRO they maintain a number of consumers and to maintain such consumers they devide them in to different part according to their area. Such division of consumer is as follows……..
01- State Govt. and Central Govt
85- Static Meter
88- CESC Consumption (Its maintain for Govt. duty purpose)
94- Calcutta Port Trust
95 & 96 – KMC & KMDA
20 – 34 is used for LT billing (Normal Consumers)
Light on the past

YEAR EVENTS 1978 - The Comp. was incorporated on 28th March. A scheme of arrangement & amalgamation between the Calcutta Electricity Supply Corporation limited [CESCs], its stock holders & the Company dated 6th December 1978 became operative from 2nd April 1979. The Comp. owns & works the Calcutta & District Consolidate Electric License 1946 [granted licensess] for supply of electricity for all purposes in & around Calcutta.
1979 - The Comp. issued & allotted on 7th April, 71,94,951 No. of equity shares of Rs 10 each & 32,07,029 - 7 1/2% preference shares of Rs 10 each credited as fully paid-up to the persons who, at the close of business on 1st April, were the holders respectively of CESC Ordinary Stock: For every 5 nominal of 6% cumulative preference stock of CESC & for every 5 nominal of ordinary stock of CESC, eight equity shares of Rs 10 each of the Company.
1981 - Issued 3,00,000 No. of equity shares to ICICI. 6,50,000 No. of Equity shares to IDBI & 3,00,000 No. of equity shares to LIC all at par in part conversion of loans.
1985 - The Comp. issued 8,50,000 - 15% secured, redeemable, non-convertible debentures of Rs 100 each on rights basis in February to meet its working capital requirements.
1986 - The Comp. secured during the year a contract for erection of their Lalmatia [Bihars] 220/132 KV substation. Another contract was secured from BHEL for erection of their 400 KV substation at Kolaghat [West Bengals]. The Comp. was also entrusted with the preparation of feasibility studies for captive power generation projects.
1987 - The name of Comp. was changed from The Calcutta Electric Supply Corporation Ltd., to CESC Ltd., with effect from 1st of January.
1988 - A Memorandum of Understanding was signed between the consultancy and Contracts division & the Comp. by Neyveli Lignite Corporation for cabling work. A MOU was signed between the Consultancy and Contracts Division & MECON, a public sector consultancy firm to jointly undertake consultancy and construction contracts in power & engineering field both in and outside India.
1991 - All statutory clearances were received for 500 MW power station at Budge Budge.
- The Comp. proposed to set up a 3 x 250 MW coalfired thermal power station at Balagarh.
- The Comp. proposed to issue 20% secured redeemable non-convertible debentures aggregating Rs 20 crores on private placement basis to financial institutions.
- During March, the Comp. offered 33,89,006 No. of equity shares of Rs 10 at a premium of Rs 15 per share to the equity shareholders on Rights basis in the proportion of 1:5 and 1,69,451 No. of equity shares of Rs 10 each at a premium of Rs 15 per share to the permanent employees/workers of Comp. on an equitable basis.
- The Comp. issued 8,71,500-12.5% secured redeemable partly convertible debentures of Rs 600 each as follows: [is] 4,65,000 debentures were reserved for a preferential allotment to the equity shareholders; [iis] 43,575 debentures were reserved for preferential allotment to the permanent employees/workers of the Comp. on an equitable basis & [iiis] 3,62,925 debentures were offered to the Indian Public.
- Part `A' of Rs 250 of each debentures was to be converted into 10 equity shares of Rs 10 each at a premium of Rs 15 per share at the end of six months from the date of allotment.
- Part `B' of Rs 350 of each debenture was to be redeemed at par in 5 equal instalments of Rs 70/- each at the end of 7th to 11th years from the date of allotment.
- The Comp. allotted [including permitted retentions] 9,17,598 debentures & 39,94,596 No. of equity shares effective 11th June, 1991 respectively.
1992 - The Comp. proposed to undertake the project for a high installed capacity of 1,500 MW to be completed in three states - Stage-I of project comprising 2 x 250 MW units having an installed capacity of 500 MW which will be followed by one 500 MW unit in the second stage & another 500 MW unit in the third stage.
- The Comp. finalised to issue 1,55,43,240-16% secured redeemable non-convertible debentures of Rs 100 each for cash at par in order to raise resources for meeting a part of requirements of Budge Budge power station project & also for meeting the Company working capital needs. 1993 - Approvals/clearances were received. The Comp. entered into an agreement with Rolls Royce Power generation system for turnkey execution of project.
1994 - The Comp. proposed to set up a 1500 MW thermal generating station to be completed in 3 stages.
- During April, the Comp. issued 83,66,140 Global Depository receipts representing 83,66,140 shares together 33,46,456 warrants to subscribe for GDRs in units of 5 GDRs & 2 warrants. The issue price was US $ 53.34 per unit.
1995 - A new Comp. Integrated Coal Mining Pvt. limited was promoted by the Comp. to undertake the work of particularly power companies to be directly involved in mining.
- The Comp. issued 3,00,000 - 14% secured redeemable non-convertible debentures of Rs 100 each on private placement basis to financial institutions. These debentures are redeemable in five equal annual instalments at a premium of 5% from 9th April.
- 50,00,000 No. of equity shares allotted on conversion of warrants attached to 16% NCD.
1996 - The Comp. has promoted a new Comp. Balagarh Power Company Ltd., for setting up a 1500 MW thermal power station.
- CESCON, limited is a wholly owned subsidiary of Company. It carries on consultancy contracts & other allied business independently.
- 89,31,620 No. of equity shares of Rs 10 each allotted at a price of Rs 50 per share on conversion of warrants. 30,14,465 No. of equity shares of Rs 10 each Rs 1 paid up allotted at a price of Rs 50 per share on conversion of warrants. 34,97,000 No. of equity shares of Rs 10 each. Rs 1 paid up allotted at Rs 80 per share on conversion of warrants.
1997 - 120,00,000 pref. shares redeemed. 8,103 No. of equity shares allotted on conversion of warrants attached to 16% NCD.
- CESC is also setting up a 1,500-mw thermal power station in two or three stages at Balagarh.
- The largest disadvantage for Comp. is that it is situated in a state which is the strong hold of Leftists.
1998 - The long term rating of Rs.1550 million Non Convertible Debenture Programme of CESC limited has been downgraded from LAA to LA, indicating adequate safety, by Investment Information & Credit Rating Agency [ICRAs].
- The Calcutta Electric Supply Corporation, renamed CESC limited in 1987, has been lighting up Calcutta for over 100 years.
- The Comp. are the 2 per cent effective tariff increase after several months, which came in November 1996.
- 20,00,000-14.5% pref. shares redeemed. 101,88,665 equity shares of Rs. 10 each Rs. 5 per share paid up allotted on 15th Feb. 1999 on conversion of equity warrants `B' attached to 15% NCD.
1999 - CESC limited has demanded another hike in the fuel surcharge [FSCs] rates for a three year span form 1996-97 to 1998-99.
- CESC existing licensing agreement will be made to include borderline areas of city currently within the jurisdiction of WBSEB.
- The Comp. has grown into a 650 MW capacity generating and distributing network.
- The Comp. has initiated a series of interactive programmes on 'Building Excellent Service Provider' for its employees.
2000 - ICRA has downgraded the rating of Rs 155.3 crore NCD issue of the Comp. to LBBB+.
2001 - The Titagarh Thermal Power Station of CESC limited has been awarded the ISO 9002 certification. 2002
-CESC Board approves proposal for amalgamation of subsidiary.
-Appoints Mr Tarun Kumar Ray as the Nominee director of IFCI on the Board of Comp.
-Court orders the Comp. to pay Rs. 3 cr to Damodar Valley Corporation.
-Government nominates Mr Birenjit Kumar Paul on the Board of company.
2003 -Chemithon Engineers Ltd along with Heavy Water Board of Government starts work on development of process to bring down emission levels at the company.
-Unveils multi-pronged scheme to curb pollution at its thermal power facilities.
-Board approves to allot shares to Management Group and Associates.
-Introduces Voluntary Separation Scheme for all permanent employees of Comp. who have completed 10 years of service & attained 40 years of age.
-2300 employees apply for CESC retirement scheme
2004 --Hindustan Lever Ltd tied up with the private sector power utility, CESC Ltd, for sampling of Pepsodent toothpaste. `Touchbase with Kolkata' project said that with its April bills CESC would be sending out 14.1 lakh covers carrying the Pepsodent label & a small 15 gm tube of toothpaste with a new flavour.
-PTC forges alliance with CESC
2005 -CESC ties up with Power Finance Corporation [PFCs] to repay debt
-CESC executes MoU with Govt of Jharkhand
2008
-CESC Ltd has forayed into a memorandum of understanding with the Government of Bihar to establish a 2,000-MW power plant in the State Bhagalpur district at an investment of Rs 10,000 crore.








RPG ENTERPRISES
RPG Enterprises, with over 100 years of history, is one of India's leading industrial houses, with an annual turnover of Rs 14,500 Crores and assets exceeding Rs 12, 000 Crores. The group has more than twenty companies managing diverse business interests in the areas of Power, Tyre, Transmission, IT, Retail, Carbon Black, Entertainment, and Speciality.
Wide-ranging businesses, growing returns and a reputation to reckon, makes working with RPG an enriching experience. Where entrepreneurial skills are valued, excellence is the by-word, and performance is a pre-requisite.
RPGs business ethics promote higher levels of excellence. The groups values of Customer Sovereignty, People Orientation, Innovation & Entrepreneurship, Transparency & Integrity, Passion for Superior Performance, Anticipation, Speed and Flexibility propel it to perform and excel in all spheres of the business.
The following are some listed companies of RPG Group :-
 CEAT
 KEC International
 Spencer's Retail
 Zensar Technologies
 Phillips Carbon Black
 Raychem RPG
 Harrisons Malayalam
 RPG Life Sciences
 Saregama India
 Noida Power Company
 Spencers Travel Services
 Open Magazine







FUNCTIONAL DEPARTMENTS OF CESC LTD.
CESC Limited as a part of RPG Group has many functional departments which are as follows.. :-

 Generating Station
 CTM
 System Control
 Substation
 Mains
 Testing
 Commercial
 Materials
 Finance
 HRD / IR / Administration
 CIS , IT
 LCC
 Project














MY PROJECT WORK……

During my SUMMER TRAINING I have done my training in COMMERCIAL DEPARTMENT. In this period I have gone through all the Section of Commercial Department. Such sections are:-
Consumer number allocation

Pre-Billing Section
 Meter Inspection
 OEDE(Data Entry)
 CAS-B
Post-Billing Section
 OEDE (Payment Data Entry)
 Complaints
 Reference
 Security
 Posting
 Outstanding
 Credit Control
 CGC

All the jobs of above mentioned sections are done by separate software. Each software has its own specific option for each part of all the section. Every user is provided a USER ID and PASSWORD to operate such system.
Now, I will go through the entire sections step by step……




CONSUMER NUMBER ALLOCATION


Consumer Number which consists of 10 + 1 Digits…
First two is District number
Second three is Book number
Third three is Serial Number
Forth Two is Sub-Consumer number(Bi number)
The last is Check Digit


As an example we can say….





District number Book Number Serial Number Bi Number Check digit
Area wise


For consumer number allocation separate software is used called ‘’CESC ONLINE LT CONSUMER SERVICES’’.
Consumer number allocation job is a vital job based on which all the process depends .When a consumer applied for a connection maybe it’s a new connection or maybe it’s for modification are listed down and those applicants are allocated their consumer number according to their address from where the connection will belong too.

PROCESS OF ALLOCATION OF CONSUMER NUMBER :--
There are three different case in which consumer number is allocated………
New Issue
Shifting of Services of Existing Customers
Augmentation of Existing Consumer
In case of new issue applicants apply for the connection in mains department, they issue a Reference number to the applicant such reference number includes the District office code – applicants number – year. Such applicant number is the first number which is generated for his identity. When all the process is successfully done by mains department then that applicant details is sent for consumer number allocation.
Then the consumer number is allocated .For this process we have to see the adjacent consumer number of that particular area which is provided by the consumer to verify whether application belong to the same address or not .If yes then we can use such number as our Reference number and we can use such number by simply modifying the bi- number i.e. the end two digit (sub-consumer number).
If No, then we have to search our database for the appropriate consumer in respect of that particular address and then use such consumer number as reference and then as before simply changing in the bi-number we can provide a separate consumer number to the applicant.
If the applicants connected load is more than 30kwts then only the consumer will fall in district “85”
In case of Shifting or augmentation of existing connection consumer number will remain same as before they don’t require any new connection.



The following is the different options in the software for ALLOCATION OF CONSUMER NUMBER:--


Consumer number allocation (given data):-- Allocation of consumer number on the basis of give data.

Consumer number allocation (Given MR number):-- Through MR number i.e. Mains Reference number we can allocate consumer number separately.

List of unallocated DR advices :-- DR advices means such applicants list who have not yet been allocated any consumer number for different reason as the case may be.

List of allocated consumers yet to send to IT.

MR number wise enquiry from Mains table:-- It Means Mains reference number wise enquiry.

List of allocated consumer number(Given allocated data)

List of allocated consumer number (Given send data):-- It means how many applicants are given their consumer number

List of consumer number in mains data base:-- It means the list of applicants which is send through Mains Dept. to the Commercial Dept. for consumer number allocation.

Worksheet for DR advices(Main Data)

Worksheet of allocated Consumer numbers.

Consumer number allocation through NA-MD.

Amendment of allocated consumer number:-- It simply help to modify the consumers numbers which is already provided but within one day i.e. before sending it to the computer house.

Updation of Reason Code

Enquiry of Reason Code Cases









Now, after allocation of the consumer number each consumer is ready to get their connection. When a consumer start consumption of electricity he becomes liable to pay the charges and the process of billing starts. We can divide the billing procedure within two sections ……..

 Pre-Billing

 Post-Billing

The following are the different Steps in Pre-Billing Section.

MI SYSTEM: -
The software which is used for allocation of different jobs at MI Section is called ONLINE SYSTEM FOR METER INSPECTION .
In such system different option are:--
I want to allocate job:-- Such option is to allocate the jobs to the Meter Inspector.

I want to give feedback :-- After the job is done a feedback has to be given about the present status of such job for the purpose of being used by other section too.

Job summary report :-- Such report is made from Friday to Thursday , a whole week job.

I want to get no-feedback jobs:- If the job isn’t done in the scheduled time such option is used.

I want to generate petty cash voucher :-- In such case different voucher is prepared according to the different pay schedule which is allocated according to the work which is distributed to different employee. The employees are paid according to the voucher once a week.

Data base enquiry:-- Data are the inputs which is made by the user for the purpose of future reference. If the user want to make any enquiry he can avail such option.

Leave maintenance menu:-- According to this the total leave which taken by the employee is counted and based on this incentive is counted.


I want to generate reading date chart:-- Reading date chart is a schedule based on which allocated persons is responsible to get the reading of the meters registering consumption of individual consumer for generating the monthly bill purpose.

I want to enquire RD jobs:-- in such option when the consumer number the record of reconnection and disconnection jobs in the respect of that particular consumer number can be obtained.

I want to enquire Consumer Number wise RD jobs:-- This option is as same as we have discussed in the previous option i.e. “I want to enquire jobs”

Report for incentive points:-- Incentive is calculated based on the incentive points recorded, based on such report bonus is also calculated.

The above mentioned options are used by Meter Inspection Dept. for the purpose to make the job done and keep in track of all jobs for the purpose of any query. With the help of such options a variety of jobs are done by this dept. I will mention all the jobs done by this dept. which I have gone through within my training period.
When a consumer applies for a connection the initial work is done by the Mains Dept. and the job of mains Dept. is over after the installation of meter in the consumer’s premises. The billing is thereafter done by the commercial department.
In M.I. Section they also keep track of all the outstanding and also the outstanding follow up records after such billing process, Science there are a consumers who are defaulters. Such consumers are kept in track specially and Notice bills are sent to them to pay the monthly bill. If such consumers are default to pay the consecutive two months bill then they are provided a notice bill (i.e. green bill) if then also they don’t pay the bill then such connection is disconnected by M.I. Dept. If after such disconnection again the consumer wants to reconnect the line then they need to pay off all the outstanding including additional Security Deposit if required and also the reconnection charges. After payment of all this they need to notify the same and re-connection order to the M.I. Dept. will be issue thereafter. The consumers who have already paid the outstanding amount before the disconnection they need to notify their payment information to the M.I. Dept. in order to stop the disconnection procedure.
If any consumer faces when problem with the meter installed in his/her premises then he/she needs to complain Meter Inspector is sent for an inspection and on the basis of his report necessary steps are taken to solve the problem.









In M.I. Dept. they also maintain the following books.
Cash payment register: - In such register they maintain the record of such consumers who paid their electric usage charges not within the stipulated time but before the disconnection of such connection. Such register is used identify such consumers who paid their dues so that there is no unwanted disconnection.
Meter Book:-In such register the consumption of the consumer is recorded on the monthly basis and based on which the consumer is billed for his consumption. Such book contain all the details of the consumer by which consumer can be separately identified during meter reading. Such book consist of the District number , Book number , Consumer number , Bi- number , Last month reading , Address specially which type of consumer is he Domestic (G) , Commercial (M) , Industrial (K).
PTR Book:- Such register consist of pages of individual consumer according to their consumer ID. Every pages of a consumer consist of 40 lines where the reading of the consumer is taken. But at the end of 40 lines the 41st reading is written at the side during this time the new book is to be generated to replace the finished lot. In the new meter book such side reading of previous book is hated before they are taken for use.

The following are the terms used

Special Cutoff: - Consumers having Notice bills and outstanding more than Rs 20000are cutoff vide special cutting jobs.

Super Special Cutoff:- Consumers having Notice Bills with outstanding more than Rs 50000/- are disconnected in such drives where two meter Inspectors ,one Officer ,one security consultant are sent.

Special RD:- Urgent Reconnection / disconnection jobs are executed on the same date when the job is issued. This is special RD.For such job Meter Inspector get an extra remuneration with salary.

COPUTER AIDED SCREENING(CAS):--


In such section the following jobs are effected……..

Attending post billing exception lists.

Inspection of new meter page.

Temporary Billing.

Screening non-actual billing cases.

The details of such jobs are as follows……….
Attending post billing exceptions lists:--CAS section attends post billing exception lists ,notes exchange information ,Reconnection/Disconnection and various other post billing information.
Discfew ----- In such case they put code 1 and code 2. This is used for cutoff the line.
Meter Exchange ------- In such case they need to indicate the full information regarding the Reading date, Old meter reading, new meter reading, Meter Number and Meter information.
Recdiff ---------- This is used for Reconnection to the different party and code 2 is being used in this case.
Address Change------- Change of mailing address and account address.
Name transfer --------- Change in the name of the consumer
Meter Amendments -------- Ins this case Code M-o5 and M-03 is used and it’s called MTRAMEN.
URAC ---------- Disconnected for few months
Bill holding ------ If there is any dispute in billing process then some time such bill is kept in hold.

Temporary Bill:--
Such type of bill is prepared when there is a temporary connection. Such connection is given when there is a need of connection not for a long time its only for a temporary basis not more than 105 days. In such cases when a consumer applies for a temporary connection then he has to submit a certain amount as a security deposit. Such security amount is decided upon the type of consumption and the hrs of usage. Based on such information the consumption is calculated accordingly and charged. Temporary connections are given to consumption as well as commercial consumption. In both cases there is difference in rate amount. Such rate difference depends upon different factors. Which are as follows………..
Rate for Domestic --- 5.78 per unit (G)
Rate for commercial---5.78 per unit (M)
Duty:--- For G ---- upto 300 units no duty
301 and above 10% duty
For M ---- upto 150 no duty
151 to 500 ---10% duty
501 to 1000 ---12.5% duty
1001 and above 15 % duty
Fuel Surcharge 48 paisa per unit
I am going to give two example one for domestic and another for commercial by which the calculation of such temporary bill will be clear……

FOR DOMESTIC (G)
Units let’s take 550 units of consumption and loop connection 3 per connection is Rs 10/-
Rebate calculation
So, total unit charge --- 550 X 578p = 317900p
Add: - 3 loop charge = 3000p
320900p
X 2%
641800p
So, Rebate will be Rs 64.18/-
Now the calculation of Duty
Total cost of unit consumed: -- 317900p
Less: - Rebate 6418p
Net Energy charge 311482p
Add: - Fuel Surcharge (48 X 550) 26400p
337882p
So Duty will be 10 % of 337882p = Rs 337.88/-
So the total temporary Bill Value of 550 unit for Domestic consumption will be
Gross Energy charge 3179.00
Fuel Surcharge 264.00
Meter Rent 30.00
Fixed Charges 5.00
Duty 337.88
TOTAL BILL 3815.88
FOR COMERCIAL (M)
Units let’s take 550 units of consumption and loop connection 3 per connection is Rs 15/-
Rebate calculation
So, total unit charge --- 550 X 578p = 317900p
Add: - 3 loop charge = 4500p
322400p
X 2%
644800p
So, Rebate will be Rs 64.48/-
Now the calculation of Duty
Total cost of unit consumed: -- 317900p
Less:- Rebate 6448p
Net Energy charge 311452p
Add :- Fuel Surcharge (48 X 550) 26400p
Gross energy charge 337852p
So Duty will be 12.5 % of 337852p = Rs 422.32/-
So the total temporary Bill Value of 550 unit for Domestic consumption will be
Gross Energy charge 3179.00
Fuel Surcharge 264.00
Meter Rent 45.00
Fixed Charges 10.00
Duty 422.32
TOTAL BILL 3920.32
Non actual bill to Actual bill
When a consumer is charged on rental in his monthly bill for a long time then to avoid such non actual billing this process is taken. In such process we have to look why the consumer is not billed on actual and solve the problem by taken various acts as such Forced billing.

OEDE (OFFLINE ELECTRONIC DATA ENTRY)
This section is mostly involved in data entry.
After reading all meter books are sent to the OEDE Section for data entry. All data are sent electronically via. CIS network to Computer House for billing.
Apart from meter reading data entry .time sheet ,data of employees are also entered in this section on the basis of tie sheet and salary slips are also prepared. Some payment data entry is also done by OEDE.
For entering all data they need to keep in mind the following codes…….

Home + 1 means Select Book
Home + 3 means NA Card
Home + 4 means MD Card (Meter Details)
Home + 5 means Final Closing
Home + 7 means Force Entry
Home + 9 means Verify Consumers
Home + C means Call Back
K- Force Bill


The following are the other different sections of Commercial Department.

COMPLAIN SECTION
Complain section deals with all complains related to billing such as high bill, average bill and defective meters. Upon receipt of a Complaint which may be verbal or written inspection advice is sent to testing Department Electronically and proper reply is sent to consumer upon receipt of the inspection report. Exchange advice is sent to testing department or CGC if the meter is defective. An erroneous bill is abated appropriately.

In Complaint Section they use different codes which are as follows:--

Meter Defect Codes:-
BL- Body Alive
BS- Meter body seal rusted/broken
BT- Burnt
CA-Check the accuracy
CB- Backward creeping
CF- forward creeping
CM- Get correct meter number and rating
CS- Check the seals
DF- Defective
DI- Disconnected
DM- Damaged
DP-Check dials position
EN- Emitting noise
ER- Erratic registration
EX- Exchange generated inspection
FG- Face glass broken
HI- High consumption
LD- Low registration
MN- Np missing
MT- Meter tampered
NU- Not in use
OR- Over registration
PD- Pt defective.
PI- Pilferage
PU- Purpose of use/nature of load
RD- Replace if defective
SC- Supply connected loop connected
SG- Sluggish
SN- Stolen
SP- Stopped
TA- Check if tampered.
TP- Tp missing/jam
TARIFF:- In complain section case related to Tariff are also attended…..
Tariff Codes for Commercial use is: -- 4 ---------- 1
For Domestic use is: -- 9 ----------1
For Industrial use is:--3 -----------3

In this section meter type can be exchanged from domestic to commercial or may be commercial to industrial or may be industrial to domestic etc as the case may be.The appropriate cases from the above are used during tariff exchange.
Now the procedure of changing the meter type:-------
When a consumer submit an application letter regarding the change of the type of the meter the copy of such application letter is send to the tariff section and the responsible person arranges inspection through MI Section.
The tariff is exchanged according to the inspection report.
The above tariff exchange is done through R 09 form. Except R 09 there is also another form which is used in another purpose. Thed various forms at Commercial Department are as follows:--
Form menu:--
R-01
R-03
R-04
R-05
R-06
R-09
R-10
R-17
R-32
R-33
R-29
R-35
MR sheet – Non TOD
MR sheet - TOD
MD sheet
NA sheet
Forms viewing
Telephone number entry
Consumer level splitting data entry
Interruption due to Disconnection (Dist : 85)
R – 20/21
LETTER SECTION:-
The standardized letters are also issued from Complain Section which are follows.
1) Ltr 1 (Consumer letter referred to DE)
2) Ltr 2 (Repeated no access)
3) Ltr 3 (Call)
4) Ltr 4 (Confusion in circuit)
5) Ltr 5 (Under registration / back creeping)
6) Ltr 6 (For documents)
7) Ltr 7 (Re-inspection ,CC-TD-CMI-DE)
8) Ltr 8 (High logic)
9) Ltr 9 (High logic case specified)
10) Ltr 10 (Super quality meter stopped/billed on NMO)
11) Ltr 11 (Information after abatement)
13) Ltr 13 (Consumption OK)
14) Ltr 14 (Meter OK)
14a) Ltr 14a (Meter OK further)
15) Ltr 15 (Meter emitting noise)
16) Ltr 19 (Billing OK after inspection)
17) Ltr 20 (Point defective)
18) Ltr 15b (R 10 attended)
19) Ltr 15c (R-10 Consent required)
20) Ltr 16 (Further inspection SPC - TD)
21) Ltr 17 (Meter reverse, internal memo)
22) Ltr 18 (Meter sluggish/stopped)
23) Ltr 18a (Meter sluggish/stopped)
24) Ltr 24 (Proposal for meter inspection and creeping benifit)
25) Ltr 25 (Information on meter replacement)
26) Ltr 26 (Over/Under ch-subsequent to NR/NA)
27) Ltr 27 (Under charge adjustment case specific)
28) Ltr 28 (Reading to be verified)
29) Ltr 30 (General acknowledgement)
30) Ltr DR section (Reading problem raised by consumer)

Abatement Section

An unpaid erroneous bill is abated and paid erroneous bill is credated.
The codes used in abatement are are as follows.……
R-17 which is used to modify the meter reading
RAVG- Its mean review of avg bull
RDGD- its mean Rated duty adjustment
ERDG- Erroneous Reading
ERDN- Erroneous Data Entry

After abatement R-17 Form is issued to rectify the meter reading recorded the .









REFERENCE SECTION
In Reference Section the following jobs are taken care of……..
Reconnection and Disconnection

Burnt Meter/LCC

Name Transfer

Now we move on towards describing the above stated points……
Reconnection and Disconnection: -- Above I have already said that why a disconnection happened. Now, after such disconnection if any consumer want to reconnect his connection again the he have to follow the following steps.
For reconnection of a Disconnected the consumer has to rectifying regional office and take a copy of composite bill. The composite which includes all security.
In this Reconnection and Disconnection process there are different forms which is as under……
@) R-01 For Inspection / Voluntary Disconnection.
@) R-03 Foe Reconnection where the Disconnection has been done by using plain seal.
@) R-04 For reconnection of a supply disconnected for outstanding due in the same name.
@) R-05 For reconnection of supply in a different name ,where the disconnection was done using plain seal.

@) R-06 For reconnection in a different name where supply was disconnected for outstanding dues.
Burnt Meter:-- All burnt meter cases should be reported to site office first. Burnt domestic meters are exchanged by the District Office – Commercial and Industrial meters are restored only after obtaining Commercial and LCC clearance .For Industrial meters, clearance from Pollution Central Board is required before restoration of supply.


Voluntary Disconnection:-- Such type of disconnection happen only when a consumer voluntarily apply for disconnection for any reason. In such case the consumer will get back his/her security amount which he has deposited after paying of all his/her dues.

Name Transfer:-- Minor changes in name and address are done through R-10 .For name transfer a standard set of forms need to filled up by the applicant along with required legal documents when a Security Deposit Bill is raised in the new name and upon payment of the same name transfer is effected.



Loss Control Cell (LCC):-- LCC disconnects the supply of a consumer when he does some unethical job to lower down his consumption such consumers are penalized and charged an amount as a penalty. When such consumer settles the penalty amount and reconnection charge then he is eligible for reconnection of the same connection.




In Reference Section they use different codes to perform their job.. Such codes are as follows…….

Code 1- Disconnection with bill
Code 2- Reconnection
Code 3- Removal with bill
Code 4- Disconnection without bill
Code 5- Removal without bill
Code 6- Disconnection by LCC with bill
Code 7- Reconnection by LCC with bill
Code 9- Disconnection by LCC


The above stated codes are used in the software to perform the desired function. Without such codes one can’t complete his/her job.








OEDE (OFFLINE ELECTRONIC DATA ENTRY)
Previously I have explain what are the jobs of OEDE Section in Pre billing process now its also necessary to mention that OEDE also has a role in Post billing process we call this PAYMENT DATA ENTRY.
All the payments which have been made by the consumer need to be appearing in the individual consumer account. If such amount doesn’t match then the same amount will also appear in the next bill. To avoid such unwanted situation the payment matching is necessary. The function of such section is to track all the manual payments.
1)Payment of Blue Bill after ten (10) days from “Due Date”
2)A Bill is paid in Installments.
3)Advance payment is made.
For such cases all information are sent to OEDE for Payment Data Entry

SECURITY
Refund of security happens in the following cases……
In case of PART REFUND

In case of NAME TRANSFER

Disconnection

In case of OUTSTANDING CUTOFF.
The cases are detailed below……
Part Refund:- For part refund consumer needs to apply and submit the ORIGINAL SECURITY DEPOSIT (SD) RECEIPT for endorsement.
Name Transfer:- If someone want to exchange the name of the consumer then he has to deposit a new security deposit according to his connected load and the old security deposit paid to the previous consumer by cheque in the address desired.
Voluntary Disconnection:- When a consumer wants to surrender his connection he has to submit a Surrender his connection ,he has to submit a letter in his respective Regional Office when the supply is disconnected through MI Section and thereafter his SD becomes refundable.
Outstanding Cutoff:- If any consumer have any outstanding in his account and the security deposit which is maintain in his account is more than the maintainable amount of security deposit then such outstanding amount is deucted from the security money which he was previously deposited after cutting off.

Inspite of all this they also do other works such as……..
They issue R -32 Form which helps to remove all the details of the consumer after making adjustment.

They issue R-33 Form to put an entry of refund.
The Calculation of Deposited security depends upon the unit consumption. It has a pre stated format which is attached below.





OUTSTANDING
Outstanding section is an important section as it helps the organization to earn the amount supplied lying disconnected.

As we know from the above that there are a number of consumer who are defaulters and after some time the company cut off such connection and such unpaid amount remain as blocked amount. To realize such amount the company keeps track of such consumers dues but are using eleo r defaulters as ctricity by taking from others. Then the company cutoff such consumers connection for helping defaulters. As soon as the company disconnect his connection then he comes to office to know the reason . But as he was helping such consumer who has liability and he didn’t pay then he has to pay all his liability to reconnect his own connection Then after settlement he is now allowed to share his own connection with the defaulter. This type of settlement is done by the outstanding section.

In another case when a consumer want to get a new connection the job of the outstanding section is to check that whether such consumer have any outstanding or not may be on the same name or may be on the same premises then such applicants receive a letter from the outstanding section to come and make settlement of such outstanding. When the consumer arrives outstanding settlement is done and then the consumer becomes eligible to get the new connection.
The settlement amount depends upon the type of application (domestic or commercial)

After the settlement of such a bill is issued within next day and the consumer need to collect that bill and deposit the same for his connection. After payment of such bill the consumer will get the clearance from the outstanding department and the system will proceed further.




POSTING SECTION
The main function of the posting section is as follows:----
Cheque Return

Suspense

Bill Adjustment

Copy Bill

Refunjd of of Bill
Now ,I will discuss the above stated points one by one…….
Cheque Return:- Any consumer can pay his/her bill by cheque. But in some cases we have seen that due to some reasons CESC Bankers returned some cheques. Firstly The names of the CESC Banker’s are as follows:--
UNITED COMMERCIAL BANK
INDIAN OVERSEAS BANK
UNITED BANK OF INDIA
ABN ARO
ICICI BANK
SBI CAG
HDFC SECURITY
The above stated bank act as CESC bankers. When such bank returne cheques then the job of the posting department is to keep records of such cheque and return these to the consumer .In case of returned cheque the consumer is liable to pay extra Rs 30/-- as banking charges. There are some cases where more than one consumer has drawn a chaque in favour of CESCIf such cheque get dishonored then CESC will charge only Rs 30/- and such cheques are returns to the Accounts Department and the account department return such cheque to the posting department.Such amount is debited along with the cheque return charge to the individual consumers account by issuing R-13 form and included in the next bill. The dishonor cheque is returned to the consumer stating the reason for dishonor of such cheque.

Process of recording the dishonor cheque in posting department……

Cheque monitoring system…
R-13 cheque returns information entry…
R-13 Cheque returns information enquiry reports…
R-13 Cheque returns information commit..

Suspense:- If any consumer refuse to pay the amount which the company billed him the consumer can file a case in the court. Till such time the decision is given by the court the consumer is liable to pay a certain portion of the bill amount to maintain his connection and such payments are made as suspense account.After judgment is given by the court the suspense amount is adjusted according to it.

Bill Adjustment:- In case of unmatched payments the bill amount is added to the next bill. Posting Section deducts the amount ,which has already been paid ,from the current bill. Such cases are referred to Accounts Department and upon proper verification by them ,final adjustment is done by Posting Section.


Copy Bill:- If the consumer doesn’t receive his bill ,the consumer can collect the copy of a current bill for payment .

Temporary Bill Refund:-- If any consumer avail any temporary connection , then after the stipulated period consumer is liable to get refund of the bill.For temporary connection purpose consumer paid a security deposit and after the bill amount is adjusted with the security money the excess amount is returned to the consumer and if there is shortfall then such amount is claimed from the consumer in the form of a bill which the consumer is liable to pay.

CONSUMER GRIEVANCE CELL (CGC)
Different consumer put different application regarding their problem. Some of the applications are referred to C.G.C. In such cases letters are verified by C.G.C. and then inspection is held to. After inspection proper steps are taken to solve that problem. Inspection report are send from the C.G.C to the respective section and based on such report a communication is send to the consumer mentioning the necessary action which will be taken by the department.










CREDIT CONTROL

Credit Control is a Separate branch within the CESC Commercial Department. The function is to control the outstanding dues credit of only Public Bodies. Public bodies mean the different Govt. under taking organization. The list of all those PUBLIC BODIES is available at the end.
There are a number of public bodies who don’t pay their dues within the stipulated time. As a result the due amount increases month by month. So to control such increment in their dues CESC maintains a separate department called Credit Control.
For settlement of such dues a group of experienced employee specially those who are retired are selected to make settlement of such dues. They approach to the different Govt. bodies and discuss about the pending amount and try to settle down such dues. When they make part payment of such dues they are entitled to a rebate and the payment made are matched and adjusted against their total due. The remaining amount is carried forwarded and debited in the next month bill.
For internal purpose Credit Control Department maintain a weekly payment sheet and also a monthly payment sheet. In weekly payment sheet they maintain the weekly payment which they receive and the abatement amount by making all the adjustments. Those public bodies who have paid comes first in the weekly sheet .After the month end such weekly bill is accumulated and a final monthly bill is prepared .In monthly bill they maintain the current month’s net due and previous months gross due and DPS and payment which they made this month. After preparing such monthly statement they compare with the previous month to see the net increase or net decrease in consumption, payment on individual basis and also by taking all the bodies as a whole.











OVERALL REVIEW


During the project report I studied the various functions of Commercial Department and the practical implementation in real situation. The overall function of Commercial Department is as follows……….
Commercial Department

Functions

(i) Solving complaints of Consumers.
(ii) Exchange of defective Electric Meter.
(iii) Solving complaints of delay in delivery/receipt of bills (Electric)
(iv) Solving complaints of discrepancies in consumption
(v) Solving complaints of discrepancies in rates/amount of electric supply.
(vi) Attending complaints regarding Excessive billing (Electric)
(vii) Report Misuse/theft of Electricity.
(viii) Allowing installments on bill when necessary.












CONCLUSION

It has been observed during the project work that technical skills and communicational skills are dominant in such Consumer Oriented Sector. Presentational skill is also important in such sector.

While having my training it has been observed multitasking ability is required in all sections. Employees willing to take additional responsibilities are preferred.