Original Format Sep LES

8/8/2019 Original Format Sep LES

1/92

Communications

Leadership Effectiveness Score

At Circle Level

Wireless Business

Date:- 30/Sep/09

Instructions to Circles:

1 Date of Submission of the LES report is 10th of Every Month.

2 KPI Sheet: AOP figures to be taken from the file circulated by Mr. Hemant Kumar Gupta.

3

4 Savings Less than Rs 30,000 per month for any activity will be considered as zero.

5

6 PCO and CWG commission paid and clawback incurred should be incorporated in their respective sheets.

For scoring 'Review by CEO', along with LES report, a copy of the presentation and MOM should be mailed in cas

subsequently /pasted in the space provided in LES format.

Numbers mentioned in 'Channel Management' sheet should be correctly supported by the details provided inthe annexure. Payment details, viz. cheque no./ transfer entry no., GL code should be compulsorily provided.


2/92


3/92


Objective:

Scope of Circle Review:

Performance of every circle will be measured broadly in following four areas of operational activities & controls monitoring:

S.No Parameter Weightage

1 Circle MIS - Financials & Cost controls 55 55

2 Channel Management 25 25

3 Revenue Assurance & FMC 9 10

4 Process Compliance 5 10

5 CAF Management / CAF retrieval for VTM 3 10

6 RDEL Submission Cleared 3 10

100 100

1) Circle MIS - Financials & Cost controls


1 Financials review AOP Vs. Actuals 25 25

2 Provision for Expenses 10 103 Review with circle CEO 10 10

4 Cost reduction 2.5 2.5

4 Process improvement initiatives 2.5 2.5

5 Timeliness of MIS 5 5

55 55

1 Financials review AOP Vs. Actuals

Objective:

Following 3 parameters are considered to review Financial performance, weightage of each is given below:


1 Direct Opex 10 10

2 EBITDA 10 10

3 Revenue 5 5

25 25

Data SourceDAKC Report and SAP Report

Measure : AOP target achievement

Frequency: Monthly

Sheet Direct Opex:

1

2 Actual rate has to be derived from "Direct cost control MIS" sheet and the same must be copied to "KPI-Originalsent2Hemant" sheet.

3 Scoring will be done based on the variances between AOP & Actual rate per unit as tabulated below:

4 KPI is revised to include Data Card

Activity Scoring Criteria

Criteria Score

Variance 5% & above +2

Variance upto 5% +1

Variance upto -5% 0

Variance upto -5% to -10% -1

Variance > -10% -2

Sheet Financials (for Revenue & EBITDA):

1

2

3 Scoring will be done based on the AOP achieved basis as tabulated below:


Criteria Score

AOP achieved 100% & above 100%

AOP achieved 95% - 99.9% 75%

To ensure better co-ordination between commercial & business verticals, and ensure deliverables are measured and performance recognised& rewarded.

Six key areas of Financials reviews, Cost controls & initiatives have been identified for performance measurement. Weightage for eachsegment is tabulated below:

To review financial performance of each revenue product, throw light on reasons for variances and suggest plan of action in co-ordination with Business

teams to improve performance.

Direct Opex will be monitored on Rate per Unit basis. AOP cost per unit has been populated accordingly for each type of DirectOpex.

Revenue: Actual Gross revenue (CDMA+GSM) FTM compared to AOP target forms basis for score calculation.

EBITDA: Actual EBITDA (CDMA+GSM) FTM compared to AOP target forms basis for score calculation.


4/92

AOP achieved 85% - 94.9% 50%

AOP achieved 60%- 84.9% 25%

AOP achieved < 60% 0

Expense details in sheet " FINANCIAL-Groupings" must be filled as on end aug (YTD) and end sep (YTD) and figs will automatically appear in sheet " FINANCIAL-YTD"

Revenue Details must be filled in sheet " FINANCIAL-YTD" as on end aug (YTD) and end sep (YTD) and figs will automatically appear in sheet " FINANCIAL-MTD-COMP

Basis of allocation of expenses has been given in notes below in sheet " FINANCIAL-MTD-COMPUTED"

Manpower AOP figs and actuals must be taken from HR Head at respective circles.

Scoring for Revenue & EBITDA is Changed i.e. No Negative Marks will be given

All figures are in Crores

CDMA & GSM YTD Provision figures to be filled up seperately in Financial groupings


5/92

2 Provision for Expenses

Objective:

Provision for expenses should reflect close to actual amount of bills to be received in subsequent month/s. Escalation of pending bills

for amount provisioned for more than 2 months to the respective functional Heads and NHQ.

Following 3 parameters are considered to review Financial performance, weightage of each is given below:

Data SourceSAP & SEM report

Measure : Provision pendency in no. of months

Frequency: Monthly

Sheet 'Provision for expenses':

1 GL code wise FTM actual expenses and YTD provision to be updated for CDMA & GSM

2 Scoring will be done based on provision pendency in no. of months as tabulated below:


Criteria Score

Provision Pendency < 1.5 months +2

Provision Pendency 1.5 - 2.0 months +1

Provision Pendency 2.0 - 2.5 months -1

Provision Pendency >2.5 months -2

3 Review with circle CEO

Objective:

To apraise circle performance and seek support required from business to improve circle performance.

Data SourceCircle reports

Measure : Circle Review with CEO by 10th. & Circulation of MoM to NHQ commercial within days specified below

Frequency: Monthly

Coverage

1 Circle Financials review - AOP Vs. Actuals

2 Subscribers review - AOP Vs. Actuals

3 Debtors review

4 Channel performance review

5 Legal issues

6 MAT audit queries

7 Initiatives from Commercial team - Financial / Non-financial

Scoring will be done based on compliance to review dates as tabulated below:


Criteria Score Date of Receipts at DKAC

MOM / Review by 10th +5 11th

MOM / Review by 13th +2 14th

MOM / Review after 13th 0

Note: Date of review at circle & MOM and receipt at DAKC will be considered for scoring.

5 Marks are given for Review by CEO i.e. for PPT

4 Process improvement initiatives

Objective:

To improve operational efficiency and achieve cost effectiveness

Data SourceCircle Report

Measure : Implementation of Initiative & sharing with NHQ

Frequency: Monthly

Suggestive Areas:

1 Channel Management

2 Billing & Collection cost

3 AV/CV cost

4 CAF Management

5 Telecalling

6 Other Sales & Distribution cost

7 Network Opex.

8 Others


6/92

Scoring will be done based on potential savings as tabulated below:


Criteria Score

Saving >=10% +2

Saving >=5%


7/92


8/92

3 Clawback Recovery

Data SourceDAKC Report & Circle Report

Measure : % recovery of clawback amount within 1 month

Frequency: Monthly

1 Individual CP details for the circle need to be provided.

2 Clawback type is to be selected from the drop down menu only.3 Total clawback details for the CP needs to be furnished, not only clawback applied for the month.


Criteria Score

86-100% Clawback Recovery +2


61-75% Clawback Recovery 0

51-60% Clawback Recovery -1

< 50% Clawback Recovery -2

In case of PCO clawback circles must enter commission income details

4 PIS Pendency

Data SourceCircle Report & DAKC Report

Measure : Deposit of outstanding amount in the Company's Account.

Frequency: Monthly

1 Pay in slip not deposited and PIS pending status as on 25th of the month will be considered for this report.

2 Pendency should ideally be restricted to less than 3 days.

Criteria PIS Value Score

Channel partners with pendency for 0-3 days +2

Channel partners with pendency for 4-5 days +1

Channel partners with pendency for 6-10 days -1

Channel partners with pendency for > 10 days -2

Channel partners with pendency for > 30 days < 3000 -3

Channel partners with pendency for > 30 days > 3000 -6

3 Circle should prvide PIS value figure in the given column

5 DST Cost and Productivity

Data SourceCircle Report & DAKC Report

Measure : Acquisition per DST

Frequency: Monthly

1 Scores will be set on the basis DST Productivity


Criteria ScoreAcquisition per DST :

8 - 9 Nos. +2

6 - 7 Nos. 1

< 6 Nos. 0

3 Revenue Assurance & FMC

Objective:

To identify & closure of fraud cases and minimise revenue leakages thereof

1) The following activities carried out at circles in areas of RA&FMC will be measured to determine circle performance.


Activities Criticality

Cloning - RE AV 3

Cloning - Board Swap 3

Cloning - Adjustment/Waiver 3

Dedupe 3

High Usages - Negative RE-AV 3

Call Fingerprint Matching With Dedupe Fraud Customer 3

Call Profiling 2

Suspicious Credit Cards payment 3

Address/SDCA change 1

High Usage-Gold/Platinum Customers 1

High Usage- Postpaid Corporate Customers 2

International Roaming High Usage-Gold/Platinum Customers 3

Adjustments Passed 3

Comprehensive Adjustments 2

Negative Balance In Postpaid Accounts 2

Premium Number Allocations 3

Cheque Bounce Cases / NLD / ILD - Incorrect Reactivation 1

Special Credit Limit - Increase in customer's Credit Limit 1

International Roaming / ILD - Incorrect Activations 2


9/92


10/92


11/92

ED"


12/92


13/92


14/92


15/92


16/92


17/92


Circle:

Month Sep-09

Performance of Circle

Sr. no. Parameter Scoring % Weightage

1.100 Circle MIS - Financials & Cost controls

1.110 Direct Opex #DIV/0! 10

1.120 EBITDA 0% 10

1.130 Revenue 0% 5

1.200 Provision for Expenses 100% 10

1.300 Review with circle CEO 100% 10

1.400 Cost reduction 100% 2.5

1.410 Process improvement initiatives 40% 2.5

1.500 Timeliness of MIS 100% 5

Sub-Total 55

2.100 Channel Management

2.200 Channel Payouts 9% 10

2.300 NOC Receipt

2.310 Based on quality of NOC 100% 3

2.320 Based on % of NOC recd. 100% 2

2.400 Clawback Recovery -100% 4

2.500 PIS Pendency 0% 3

2.600 DST Cost and Productivity 0% 3

Sub-Total 25

3.100 Revenue Assurance & FMC

3.200 Fraud Monitoring & Control 100% 9

Sub-Total 9

4.100 Process Compliance

4.100 Business Commercial - Process Compliance - LES S 90% 5

4.110 CAF Management / CAF retrieval for VTM 100% 3

4.120 RDEL Jun submission clearance 63% 3

Sub-Total 11

Total 100


18/92

Score

#DIV/0!

0.0

0.0

10.0

10.0

2.5

1.0

5.0

#DIV/0!

0.9

3.0

2.0

-4.0

0.0

0.0

2

9.0

9

4.5

3.0 for Rdel it is 3 ,for Non Rdel make it 6

1.9 for Rdel it is 3 ,for Non Rdel make it 0

9

#DIV/0!


19/92

CDMA

Description Head KPI Unit

Qty

('000)

Acquisition Cost:

Channel Commission

Postpaid Mobile Rate per Acquisitions Rs.

Mobile-Data card Rate per Acquisitions Rs.

CWG (Mobile) Rate per Acquisitions Rs.

CWG-Data card Rate per Acquisitions Rs.

FWP Rate per Acquisitions Rs.

CWG(FWP) Rate per Acquisitions Rs.

Prepaid Prepaid-Mobile Rate per Acquisitions Rs.Prepaid-Data card Rate per Acquisitions Rs.


RDEL Rate per Acquisitions Rs.

FWP(PCO) Rate per Acquisitions Rs.

Other Acquisition Cost


Mobile-Data card Rate per Acquisitions Rs.


CWG-Data card Rate per Acquisitions Rs.


CWG(FWP) Rate per Acquisitions Rs.

Prepaid Prepaid-Mobile Rate per Acquisitions Rs.

Prepaid-Data card Rate per Acquisitions Rs.

Prepaid FWP(including RDEL) Rate per Acquisitions Rs.

FWP(PCO) Rate per Acquisitions Rs.

Billing Cost Postpaid Rate Per Bill Rs.

Collection Cost Postpaid % of Gross Collection %

Telecalling Expenses Per Subs per month Rs.

Customer Care Expenses Per Subs per month Rs.

Selling & Distribution Exp. Per Subs per month Rs.

PCO Revenue Enhancement % of PCO Revenue %


20/92

GSM


Qty

('000)

Acquisition Cost:

Channel Commission



Prepaid Mobile Rate per Acquisitions Rs.










RTL


Qty

('000)

Acquisition Cost:

Channel Commission








21/92





Remarks - Only YTD figures to be considered.

Overall scoring to be changed for circle which are operating in only single Technology

Circle should remove redundant zeros in scoring field if 0 varaince is not a computed variance


22/92

AOP YTD SEP 09 Actual YTD SEP 09

Rate Amount Qty Rate Amount

Qty Rate

(Rs.) (Rs.in lacs) ('000) (Rs.) (Rs.in lacs) ('000) (Rs.)

- -

- -

- -

- -

- -

- -

- -- -

- -

- -

- -

- -

- -

- -

- -

- -- -

- -

- -

- -

- -

- -

- 0.0%

- -

- -

- -

- 0.0%

CDMA Scoring


23/92


Rate Amount Qty Rate Amount Qty Rate


- -

- -

- -

- -

- -

- -

- -

- 0.0%

- -

- -

- -

GSM Scoring


Rate Amount Qty Rate Amount Qty Rate


- -

- -

- -

- -- -


24/92

- 0.0%

- -

- -

- -

RTL Scoring

Overall Scoring


25/92

Variance YTD SEP 09

Scoring

Qty Amount Rate Amount Total Amount

(Rs.in lacs) (Rs.in lacs) (Rs.in lacs) (%)

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

#DIV/0!

RateVariance

(Unit Cost)


26/92

Variance YTD SEP 09

Qty Amount Rate Amount Total Amount Scoring


- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

#DIV/0!

Variance YTD SEP 09

Qty Amount Rate Amount Total Amount Scoring


- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

RateVariance

(Unit Cost)

RateVariance

(Unit Cost)


27/92

- - - 0% 0

- - - 0% 0

- - - #DIV/0! #DIV/0!

- - - #DIV/0! #DIV/0!

#DIV/0!

#DIV/0!


28/92

Circle Name - EBITDA Statement Sep 2009(Rs. In Crores)CDMA GSM / RTL

ParticularsMobile Hello PCO CDMA CDMA TOTAL Mobile WIRELESS

AOP Actual AOP Actual AOP Actual Provision AOP Actual Provision Actual+Prov AOP Actual Variance Variance% Achieved Scoreing

Gross Revenue 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Service Tax 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Service Revenue 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Incoming IUC 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Total Revenue 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0% 0%

Incoming IUC -On Net Termination 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Outgoing IUC - On Net Termination 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Retained Revenue 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

License Fees 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%Spectrum Chgs 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Revenue net of Revenue Share 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Channel Commission 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 1.0 0.0 -1.0 0.0 -1.0 0.0 0.0 0.0 0% 0%

Channel Other Acquisition Cost 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Customer Care 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Billing Cost 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Collection Cost 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Telecalling Cost 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Selling & Distribution 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Direct Cost 0.0 0.0 0.0 0.0 0.0 1.0 0.0 1.0 0.0 -1.0 -1.0 0.0 0.0 0.0 0% 0%Network Opex 0.0 0.0 0.0 0.0 0.0 10.0 0.0 0.0 10.0 0.0 0.0 -5.0 -5.0 0.0 5.0 -5.0 0% 0%

Manpower 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Marketing 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Shared Services 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Bad Debt 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

R_Del Subsidy 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Gross Contribution by Circle 0.0 0.0 0.0 0.0 0.0 -11.0 0.0 -11.0 0.0 1.0 6.0 0.0 -5.0 5.0 0% 0% 0%

% of Circle Contribution on Total Revenue 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%

(A.)

Notes: Basis of allocation of Cost

1. Channel Commission - based on actuals.2. Customer care - based on closing subscribers for the month.

3. Billing & collection - based on actuals, any residual to be allocated basis closing subscriber for the month.

4. Network Opex - Based on closing subscribers for the month.

5. Manpower - Salary cost to be taken from HR, others to be allocated based on count of manpower.

6. Marketing Expenses - Based on closing subs for the month

7. Shared Services - Based on manpower in the beginning of the month.

8. In case breakup of AOP expenses- CDMA and GSM is not available, the entire amount can be entered in CDMA

(B.)

1. Mobile includes Data Card

2. CWG to be clubbed under respective heads

3. Scoring for Revenue & EBITDA is Changed (No Negative Marks):-

4. All figures are in Crores

5. CDMA & GSM YTD Provision figures to be filled up seperately in Financial groupings

Criteria Score

Target achieved 100% & above 100%

Target achieved 95% - 99.9% 75%



Target achieved < 60% 0%

Outgoing IUC - Outsider

Relance:Refer Notes below


29/92

Circle Name - EBITDA Statement Aug 2009(Rs. In Crores)CDMA GSM / RTL

ParticularsMobile Hello PCO CDMA CDMA Total Mobile WIRELESS

AOP Actual AOP Actual AOP Actual Provision AOP Actual AOP Actual Provision Actual+Prov AOP Actual Variance Variance% Achieved Scoreing

Gross Revenue 2.0 2.0 2.0 2.0 20.0 10.0 10.0 22.0 12.0 10.0 45% 55% Gross Billable Reven

Service Tax 0.0 0.0 0.0 0.0 0.0 0% 0% Less :

Service Revenue 2.0 2.0 0.0 0.0 0.0 0.0 2.0 2.0 20.0 10.0 10.0 22.0 12.0 10.0 45% 55%

Incoming IUC 0.0 0.0 0.0 0.0 0.0 0% 0% Add :

Total Revenue 2.0 2.0 0.0 0.0 0.0 0.0 2.0 2.0 20.0 10.0 10.0 22.0 12.0 10.0 45% 55% 0%

Incoming IUC -On Net Termination 0.0 0.0 0.0 0.0 0.0 0% 0% Add :

0.0 0.0 0.0 0.0 0.0 0% 0% Less :

Outgoing IUC - On Net Termination 0.0 0.0 0.0 0.0 0.0 0% 0%

Retained Revenue 2.0 2.0 0.0 0.0 0.0 0.0 2.0 2.0 20.0 10.0 10.0 22.0 12.0 10.0 45% 55%

License Fees 0.0 0.0 0.0 0.0 0.0 0% 0% Less :

Spectrum Chgs 0.0 0.0 0.0 0.0 0.0 0% 0%

0.0 0.0 0.0 0.0 0.0 0% 0%

Revenue net of Revenue Share 2.0 2.0 0.0 0.0 0.0 0.0 2.0 2.0 20.0 10.0 10.0 22.0 12.0 10.0 45% 55%

Channel Commission 0.0 0.0 0.0 0.0 0.0 0.0 5.0 1.0 0.0 1.0 5.0 1.0 4.0 80% 20% Less :

Channel Other Acquisition Cost 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Customer Care 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0% Less :

Billing Cost 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0% Less :

Collection Cost 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Telecalling Cost 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Selling & Distribution 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

0.0 0.0 0.0 0.0 0.0 0% 0%

Direct Cost 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 5.0 1.0 0.0 1.0 5.0 1.0 4.0 80% 20%

Network Opex 0.0 0.0 0.0 0.0 0.0 0.0 0.0 5.0 5.0 0.0 5.0 -5.0 0% 0% Less :

Manpower 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0% Less :

Marketing 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0% Less :

Shared Services 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0% Less :

Bad Debt 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

R_Del Subsidy 0.0 0.0 0.0 0.0 0.0 0.0 0% 0% 0.0 0.0 0.0 0.0 0.0 0.0 0% 0%

Gross Contribution by Circle 2.0 2.0 0.0 0.0 0.0 0.0 2.0 2.0 15.0 9.0 -5.0 4.0 17.0 6.0 11.0 65% 35% 0%

% of Circle Contribution on Total Revenue 100% 100% 0% 0% 0% 0% 75% 90% 40% 77% 50%

Outgoing IUC - Outsider


30/92

Cumulative AUG GL Expenses(Rs. In Crores)

Group GL Code GL Description Amount

CD

Mobile

7456021 Channel Associates - Commission

7456031 Acquisition/Fulfilment-RIM

7456032 Acquisition/ Fulfilment Commission

7456035 Key Retailer

7456036 Primery Incentive

7456061 Activation Commission Pre paid - RIM

7456062 Activation Commission

7456063 Activation Commission Pre paid - Data card

7456071 PCO Commission/Scheme(Aquisition Commission)

7456072 Activation Commission Post paid - FWP

7456073 Activation Commission Post paid - RIM

7456074 CWG Commission

7457301 DST Cost - Personnel7457302 DST Cost- Corporate

TOTAL 0 0 0

7102400 GSK/Welcome Kit

7410090 Fulfillment Commission-PCO

7456140 Credit verification agency fees

7457210 CPE Installation Charges

7457303 DST Cost-PCO

7545300 Address Verification Expenses-Postpaid

7545301 Customer Verification Prepaid

7545302 Customer Verification PCO

7545303 Customer Verification CWG7545310 CAF Management charges

TOTAL 0 0 0

7180001 Customer care Expense- PVAP

7180002 Customer care expenses - WWE

7180003 Customer Care Expenses - Others

7400100 Webstore Expenses (Customer Care)

TOTAL 0 0 0

7457000 Billing Expenses

7457004 Billing Expenses CWG

TOTAL 0 0 0

7155310 Hire Chgs - Cont.Serv - Feet on Stree - Colle

7456020 Channel Associates - Reimbursement

7457010 Collection Expenses-Others

7457015 Coll Exp -data entry for cheques collected

7457020 Coll Exp -Cheques Pickup charges

Mobile-Prov

Cha

nnel

Commis

sion

Othe

rAcq

uisitio

nCo

st

Cust

omer

CareE

xp.

Billin

gCost


31/92

7457021 Cheque pick up Charges - CWG

7457025 Coll Exp-Drop Box Charges

7457030 Commission to Collection Agent

7457033 Collection Commission-CWG

7457034 Channel Performance Incentive - Personal

7457035 Customer Retention Commission - Personal

7457041 CRO Collection Commission -PB

7457042 CRO Collection Commission -CWG

TOTAL 0 0 0

7155300 Hire Charges-Contracted Services(oper)

7155302 Hire Charges - Contracted Services (Operations) - PCO

7155303 Hire Charges - Contracted Services (Operations) - CWG

7155330 Hire Chgs - Cont.Serv - Tele Calling - Collec

7155340 Hire Chgs - Cont.Serv - Tele Calling - Market

7155350 Hire Chgs - Cont.Serv - OTC / CDC

7180000 Call Center Expenses

TOTAL 0 0 07400100 Webstore Expenses (Selling)

7405000 Sales Promotion Expenses Within India

7420010 Freight & Forwarding - Rail Transport Charges

7420200 Packing Expenses

7435000 Other Selling and Distribution Expenses

TOTAL 0 0 0

7520060 Trav. Inland - Fare

7520070 Trav. Inland - LB

7520080 Trav.Inland-Oth.Exp

7540000 Hire Charges - Vehic7541000 Local Conveyance

TOTAL 0 0 0

7182010 Lic.Fees-Rev Sharing

7182020 WPC-Spectrum Chgs

TOTAL 0 0 0

7720010 Provision for Bad Debts - Manual Posting

7720020 Provision for Bad Debts - Service Tax Compone

Bad Debts PCO

TOTAL 0 0 0

7100000 Stores & Spares Consumed - Mechanical

7100070 Stores & Sp Cons-Mech-Trf posting

7100090 Diff Costs - Stores & Spares - Mech

7100100 Stores & Spares Consumed - Electrical

7100190 Diff Costs - Stores & Spares - Elec

Telecalling

Exp

enses

elling

&DistributionE

xp.

Travellin

g&Lo

cal

LicF

ee&WPC

Ex

BadD

ebts


32/92

7100200 Stores & Spares Consumed - Inst.

7100290 Diff Costs - Stores & Spares - Inst

7100400 Lubes, Oils & Greases consumed

7100500 Other consumables - consumed

7100570 Other Consumables consumed -Tfr posting

7100590 Differential Costs - Other consumables

7100800 Stores & Spares Consumed - Electronics7100870 Stores & Sp Cons- Electronics-Trf posting

7100890 Diff Costs - Stores & Spares - Electronics

7105000 Chemicals & Catalysts Consumed

7110000 Packing Materials Consumed

7110400 Packing Material Consumed - Transfer posting

7125000 Fuel Consumed

7125070 Fuel Consumed at BTS - other than fleet cards

7125300 Differential Costs - Fuel

7130000 Power Consumed

7130100 Electricity Duty Paid on Power Purchased

7142520 Inward Freight/Delivery Costs on Purchases -

7145015 Asset Installation and De-Installation Chgs7145100 Repairs & Maintenance-Plant & Machinery-Elect

7145200 Repairs & Maintenance-Plant & Machinery-Mecha

7145210 Repairs & Maintenance-Plant & Machinery- DG S

7145300 Repairs & Maintenance-Plant & Mach-Intrumenta

7145360 Repairs & Maint.-Plant & Mach- Network Electr

7145400 Repairs & Maintenance-CES-Electrical

7146100 Repairs & Maintenance-Network Building / Site

7146120 Maintenance & Cable Entry Chgs for PoI

7146130 Rep. & Maint. - Network Utilities / AMCs

7147200 Repairs & Maintenance - Network Direct Burrie

7147210 Repairs & Maintenance - Network Optic Fibre C

7147300 Running & Maintaining of Splicing Vans used f7147310 Running & Maintaining of Bikes for FEOs used

7147320 Running and maint. Of CDMA test drive Vehicle

7147325 Repairs and Maint of Network Vehicles

7149100 Bandwidth charges - National

7149110 Bandwidth Charges - International

7149210 Port Charges for Interconnect

7149300 Leased line rental charges

7149551 Fixed Charges - Other IP

7149552 Fuel Charges - Other IP

7149553 Power Charges - Other IP

7149554 Fixed Charges - USO B

7149555 Fuel Charges - USO B7149556 Power Charges - USO B

7145000 Repairs & Maintenance-PM - Civil

7149400 Network information charges to agencies

7155000 Hire Chgs - Plant & Machinery

7155500 Hiring Chgs for Network maintenance vehicles

7155510 Hiring vehicles for route surveillance vehicl

7155515 Network Testing Charges


33/92

7155520 Hiring vehicles for CDMA test drive vehicles

7155530 Hire Charges - Contracted Services for Networ

7180200 VSAT connectivity charges

7182030 Spectrum charges-Point to point MW links

7182045 WPC Charges - Royalty MW Links -LMDS

7182330 GSM - Signalling Chgs - Global Roaming

7457214 CPE Related Expenses7505400 Rent for BTS Sites

7505410 Rent for MCN / IS / BAN / IDC / ODC Sites

7505420 Rent for PoI Sites - for space (co-location)

7505421 Rent for POI Sites -Passive Links

7505430 Rent for Network Maintenance Points

7505500 Rent for SAX Sites

7510115 Rates & Taxes - Network Sites

7530020 Professional Fees Paid To Others

7575060 Security Expenses

TOTAL 0 0 0

7146110 R&M-Electric & Other7420030 Freight & Forwarding - Air Transport Charges

7427900 Transport Charges

7505000 Rent For Office Prem

7505900 Rent - Others

7510100 Rates & Taxes-Others

7515000 R & M - Off.Bldgs

7515040 R & M - Computers

7515070 Annual Maint. Chgs

7540100 Hire Chgs -Office Eq

7540300 Hire Chgs -Cont Serv

7540500 Hire Chgs

7545000 Postage & Courier7550100 Telephone Exps

7552000 Electricity Expenses

7552300 Cable TV Charges

7553000 Water Expenses

7555000 Printing & Stationer

7575000 Books & Periodicals

7575020 Seminar Fees & Trg.

7575025 Meeting & Confer.Exp

7575040 Guest House Expenses

7575050 Entertainment Exp.

7575880 Fire Services Exps

7575900 Misc Exp - Others

TOTAL 0 0 0

7300000 Salaries And Wages

7300100 Salaries & Wages - Contractors

7300200 Salaries & Wages - Reimbursement

7305000 Bonus

7310000 Ex-Gratia

Shared

Servic

es


34/92

7315000 Salaries & Wages - Managerial Remuneration

7315100 Ex-Gratia - Managerial Remuneration

7315200 Co. Contribution to PF - Managerial Remunerat

7315300 Co. Contribution to Pension Scheme-Managerial

7315400 Co. Contribution to Gratuity - Managerial Rem

7315500 Co. Contribution to Superannuation-Managerial

7320000 Directors' Commission7325000 Co. Contribution To Provident Fund

7325020 Co. Contribution To Pension Scheme

7325040 Co. Contribution To Gratuity

7325060 Co. Contribution To Superannuation

7325080 Co. Contribution To ESIC

7325100 PF Administration and Inspection Charges

7325110 Employers Deposit Linked Insurance Charges

7325120 Co. Contribution - Labour Welfare Fund

7325130 Co. Cont. EDLI Administration Chargesnd

7325900 Co. Contribution for other payments

7330000 Leave Travel Allowance

7330010 Medical Expenses - Reimbursement7330011 Medical Expenses - Reimbursement - Taxable

7330020 Medical Expenses - Others

7330025 Medical Expenses - Others - Payroll - without

7330030 Catering/Lunch/Canteen Expenses

7330035 Food & Beverages Coupons

7330040 Uniform and Clothing

7330060 Electricity Allowance

7330090 Other Non-Taxable Allowances to employees

7330100 Reimbursement of Employee Related Expenses

7330200 Rent For Residential Flats-Third Parties

7330210 Rent For Residential Flats - Group Companies

7330220 Exp On Flats For Employees - Owned By Company7330230 Exp On Flats For Employees - Leased By Compan

7330250 Rent Recovered from Employees

7330300 Petrol Reimbursement (OYCS)

7330310 Petrol For COC Cars

7330320 Petrol Reimbursement (OYSS)

7330330 Petrol Reimbursement - Owned Two Wheeler

7330500 Employee Welfare - Transport & Hire Charges

7330600 Sundry Services - Stipend

7330900 Other Employee Welfare & Amenities

7330901 Other Employee Welfare & Amenities Reimbursem

7330910 Other Employee Welfare & Amenities - Without

TOTAL 0 0 0

7410001 Customer Acquisition Charges-R Del Spl Budget

7410030 Advt Exp - Hoarding Rental

7410031 Advt Exp - Hoarding Installation

7410040 Advt Exp - Vinyl Printing for Hoardings

7410077 Facia Change

7410078 NEW SIGNAGES

enses


35/92

7410085 Signages-WIN Towns

7435021 Hard Merchandising

7435022 Soft Merchandising

7410086 Marcom Expenses New town launch

7457305 Cutomer Acquisition Charges-COCA - Per

7575100 Advt Expn-Others

TOTAL 0 0 0


36/92

A

PCO

GSM/RTL

GSM ProvHello PCO Prov Mobile

0 0 00 0 0

0 0 0

0 0 0

0 0 0

0 0 0 1

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0

0 0 0 0 0 0 0 1 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0

0 0 0

0 0 0 0 0 0 0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0 0 0 0 0 0 0

0 0 0

0 0 00 0 0

0 0 0 0 0 0 0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

CDMAExp

CDMAProv

CDMA-TOTAL

Hello-Prov


37/92

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0

0 0 0 0 0 0 0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0 0 0 0 0 0 00 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0 0 0 0 0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0

0 0 0

0 0 0 0 0 0 0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0 0 0 0 0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0 0 0 0 0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0


38/92

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0 5

0 0 0

0 0 0

0 0 00 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0


39/92

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0 0 0 0 0 0 5

0 0 00 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0 0 0 0 0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0


40/92

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0 0 0 0 0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0


41/92

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 00 0 0 0 0 0 0 0 0


42/92

Cumulative SEP GL Expenses(R

Wireless Group GL Code

0 0 74560210 0 7456031

0 0 7456032

0 0 7456035

0 0 7456036

1 1 7456061

0 0 7456062

0 0 7456063

0 0 7456071

0 0 7456072

0 0 7456073

0 0 7456074

0 0 74573010 0 7457302

0 0

1 1

0 0 7102400

0 0 7410090

0 0 7456140

0 0 7457210

0 0 7457303

0 0 7545300

0 0 7545301

0 0 7545302

0 0 75453030 0 7545310

0 0

0 0

0 0

0 0 7180001

0 0 7180002

0 0 7180003

0 0 7400100

0 0

0 0

0 0 7457000

0 0 74570040 0

0 0

0 0 7155310

0 0 7456020

0 0 7457010

0 0 7457015

0 0 7457020

GSM-TOTAL

Cha

nnel

Commis

sion

Othe

rAcq

uisitio

nCo

st

Cust

omer

CareE

xp.

Billin

gCost


43/92

0 0 7457021

0 0 7457025

0 0 7457030

0 0 7457033

0 0 7457034

0 0 7457035

0 0 74570410 0 7457042

0 0

0 0

0 0 7155300

0 0 7155302

0 0 7155303

0 0 7155330

0 0 7155340

0 0 7155350

0 0 7180000

0 0

0 00 0 7400100

0 0 7405000

0 0 7420010

0 0 7420200

0 0 7435000

0 0

0 0

0 0 7520060

0 0 7520070

0 0 7520080

0 0 75400000 0 7541000

0 0

0 0

0 0

0 0 7182010

0 0 7182020

0 0

0 0

0 0

0 0 7720010

0 0 7720020

0 00 0

0 0

0 0 7100000

0 0 7100070

0 0 7100090

0 0 7100100

0 0 7100190

Telecalling

Exp

enses

Sellin

g&DistributionE

xp.

Travellin

g&Lo

cal

LicFee

&WPC

Ex

BadD

ebts


44/92

0 0 7100200

0 0 7100290

0 0 7100400

0 0 7100500

0 0 7100570

0 0 7100590

0 0 71008000 0 7100870

0 0 7100890

0 0 7105000

0 0 7110000

0 0 7110400

0 0 7125000

0 0 7125070

0 0 7125300

0 0 7130000

0 0 7130100

0 0 7142520

0 0 71450150 0 7145100

0 0 7145200

0 0 7145210

0 0 7145300

0 0 7145360

0 0 7145400

0 0 7146100

0 0 7146120

0 0 7146130

0 0 7147200

0 0 7147210

0 0 71473000 0 7147310

0 0 7147320

0 0 7147325

0 0 7149100

0 0 7149110

0 0 7149210

0 0 7149300

0 0 7149551

5 5 7149552

0 0 7149553

0 0 7149554

0 0 71495550 0 7149556

0 0 7145000

0 0 7149400

0 0 7155000

0 0 7155500

0 0 7155510

0 0 7155515


45/92


46/92

0 0 73150000 0 73151000 0 73152000 0 73153000 0 73154000 0 7315500

0 0 73200000 0 73250000 0 73250200 0 73250400 0 73250600 0 73250800 0 73251000 0 73251100 0 73251200 0 73251300 0 73259000 0 7330000

0 0 73300100 0 73300110 0 73300200 0 73300250 0 73300300 0 73300350 0 73300400 0 73300600 0 73300900 0 73301000 0 73302000 0 7330210

0 0 73302200 0 73302300 0 73302500 0 73303000 0 73303100 0 73303200 0 73303300 0 73305000 0 73306000 0 73309000 0 73309010 0 7330910

0 00 0

0 0 7410001

0 0 7410030

0 0 7410031

0 0 7410040

0 0 7410077

0 0 7410078

enses


47/92

0 0 7410085

0 0 7435021

0 0 7435022

0 0 7410086

0 0 7457305

0 0 7575100

0 00 0


48/92

. In Crores)

GL Description Amount

CDMA

Mobile Hello

Channel Associates - Commission

Acquisition/Fulfilment-RIM

Acquisition/ Fulfilment Commission

Key Retailer

Primery Incentive

Activation Commission Pre paid - RIM

Activation Commission

Activation Commission Pre paid - Data card

PCO Commission/Scheme(Aquisition Commission)

Activation Commission Post paid - FWP

Activation Commission Post paid - RIM

CWG Commission

DST Cost - PersonnelDST Cost- Corporate

TOTAL 0 0 0 0

GSK/Welcome Kit

Fulfillment Commission-PCO

Credit verification agency fees

CPE Installation Charges

DST Cost-PCO

Address Verification Expenses-Postpaid

Customer Verification Prepaid

Customer Verification PCO

Customer Verification CWGCAF Management charges

TOTAL 0 0 0 0

Customer care Expense- PVAP

Customer care expenses - WWE

Customer Care Expenses - Others

Webstore Expenses (Customer Care)

TOTAL 0 0 0 0

Billing Expenses

Billing Expenses CWG

TOTAL 0 0 0 0

Hire Chgs - Cont.Serv - Feet on Stree - Colle

Channel Associates - Reimbursement

Collection Expenses-Others

Coll Exp -data entry for cheques collected

Coll Exp -Cheques Pickup charges

Mobile-Prov


49/92

Cheque pick up Charges - CWG

Coll Exp-Drop Box Charges

Commission to Collection Agent

Collection Commission-CWG

Channel Performance Incentive - Personal

Customer Retention Commission - Personal

CRO Collection Commission -PB

CRO Collection Commission -CWG

TOTAL 0 0 0 0

Hire Charges-Contracted Services(oper)

Hire Charges - Contracted Services (Operations) - PCO

Hire Charges - Contracted Services (Operations) - CWG

Hire Chgs - Cont.Serv - Tele Calling - Collec

Hire Chgs - Cont.Serv - Tele Calling - Market

Hire Chgs - Cont.Serv - OTC / CDC

Call Center Expenses

TOTAL 0 0 0 0Webstore Expenses (Selling)

Sales Promotion Expenses Within India

Freight & Forwarding - Rail Transport Charges

Packing Expenses

Other Selling and Distribution Expenses

TOTAL 0 0 0 0

Trav. Inland - Fare

Trav. Inland - LB

Trav.Inland-Oth.Exp

Hire Charges - VehicLocal Conveyance

TOTAL 0 0 0 0

Lic.Fees-Rev Sharing

WPC-Spectrum Chgs

TOTAL 0 0 0 0

Provision for Bad Debts - Manual Posting

Provision for Bad Debts - Service Tax Compone

Bad Debts PCO

TOTAL 0 0 0 0

Stores & Spares Consumed - Mechanical

Stores & Sp Cons-Mech-Trf posting

Diff Costs - Stores & Spares - Mech

Stores & Spares Consumed - Electrical

Diff Costs - Stores & Spares - Elec


50/92

Stores & Spares Consumed - Inst.

Diff Costs - Stores & Spares - Inst

Lubes, Oils & Greases consumed

Other consumables - consumed

Other Consumables consumed -Tfr posting

Differential Costs - Other consumables

Stores & Spares Consumed - ElectronicsStores & Sp Cons- Electronics-Trf posting

Diff Costs - Stores & Spares - Electronics

Chemicals & Catalysts Consumed

Packing Materials Consumed

Packing Material Consumed - Transfer posting

Fuel Consumed

Fuel Consumed at BTS - other than fleet cards

Differential Costs - Fuel

Power Consumed

Electricity Duty Paid on Power Purchased

Inward Freight/Delivery Costs on Purchases -

Asset Installation and De-Installation ChgsRepairs & Maintenance-Plant & Machinery-Elect

Repairs & Maintenance-Plant & Machinery-Mecha

Repairs & Maintenance-Plant & Machinery- DG S

Repairs & Maintenance-Plant & Mach-Intrumenta

Repairs & Maint.-Plant & Mach- Network Electr

Repairs & Maintenance-CES-Electrical

Repairs & Maintenance-Network Building / Site

Maintenance & Cable Entry Chgs for PoI

Rep. & Maint. - Network Utilities / AMCs

Repairs & Maintenance - Network Direct Burrie

Repairs & Maintenance - Network Optic Fibre C

Running & Maintaining of Splicing Vans used fRunning & Maintaining of Bikes for FEOs used

Running and maint. Of CDMA test drive Vehicle

Repairs and Maint of Network Vehicles

Bandwidth charges - National

Bandwidth Charges - International

Port Charges for Interconnect

Leased line rental charges

Fixed Charges - Other IP

Fuel Charges - Other IP

Power Charges - Other IP

Fixed Charges - USO B

Fuel Charges - USO BPower Charges - USO B

Repairs & Maintenance-PM - Civil

Network information charges to agencies

Hire Chgs - Plant & Machinery

Hiring Chgs for Network maintenance vehicles

Hiring vehicles for route surveillance vehicl

Network Testing Charges


51/92

Hiring vehicles for CDMA test drive vehicles

Hire Charges - Contracted Services for Networ

VSAT connectivity charges

Spectrum charges-Point to point MW links

WPC Charges - Royalty MW Links -LMDS

GSM - Signalling Chgs - Global Roaming

CPE Related ExpensesRent for BTS Sites

Rent for MCN / IS / BAN / IDC / ODC Sites

Rent for PoI Sites - for space (co-location)

Rent for POI Sites -Passive Links

Rent for Network Maintenance Points

Rent for SAX Sites

Rates & Taxes - Network Sites

Professional Fees Paid To Others

Security Expenses

TOTAL 0 0 0 0

R&M-Electric & OtherFreight & Forwarding - Air Transport Charges

Transport Charges

Rent For Office Prem

Rent - Others

Rates & Taxes-Others

R & M - Off.Bldgs

R & M - Computers

Annual Maint. Chgs

Hire Chgs -Office Eq

Hire Chgs -Cont Serv

Hire Chgs

Postage & CourierTelephone Exps

Electricity Expenses

Cable TV Charges

Water Expenses

Printing & Stationer

Books & Periodicals

Seminar Fees & Trg.

Meeting & Confer.Exp

Guest House Expenses

Entertainment Exp.

Fire Services Exps

Misc Exp - Others

TOTAL 0 0 0 0

Salaries And Wages

Salaries & Wages - Contractors

Salaries & Wages - Reimbursement

Bonus

Ex-Gratia


52/92

Salaries & Wages - Managerial Remuneration

Ex-Gratia - Managerial Remuneration

Co. Contribution to PF - Managerial Remunerat

Co. Contribution to Pension Scheme-Managerial

Co. Contribution to Gratuity - Managerial Rem

Co. Contribution to Superannuation-Managerial

Directors' CommissionCo. Contribution To Provident Fund

Co. Contribution To Pension Scheme

Co. Contribution To Gratuity

Co. Contribution To Superannuation

Co. Contribution To ESIC

PF Administration and Inspection Charges

Employers Deposit Linked Insurance Charges

Co. Contribution - Labour Welfare Fund

Co. Cont. EDLI Administration Chargesnd

Co. Contribution for other payments

Leave Travel Allowance

Medical Expenses - ReimbursementMedical Expenses - Reimbursement - Taxable

Medical Expenses - Others

Medical Expenses - Others - Payroll - without

Catering/Lunch/Canteen Expenses

Food & Beverages Coupons

Uniform and Clothing

Electricity Allowance

Other Non-Taxable Allowances to employees

Reimbursement of Employee Related Expenses

Rent For Residential Flats-Third Parties

Rent For Residential Flats - Group Companies

Exp On Flats For Employees - Owned By CompanyExp On Flats For Employees - Leased By Compan

Rent Recovered from Employees

Petrol Reimbursement (OYCS)

Petrol For COC Cars

Petrol Reimbursement (OYSS)

Petrol Reimbursement - Owned Two Wheeler

Employee Welfare - Transport & Hire Charges

Sundry Services - Stipend

Other Employee Welfare & Amenities

Other Employee Welfare & Amenities Reimbursem

Other Employee Welfare & Amenities - Without

TOTAL 0 0 0 0

Customer Acquisition Charges-R Del Spl Budget

Advt Exp - Hoarding Rental

Advt Exp - Hoarding Installation

Advt Exp - Vinyl Printing for Hoardings

Facia Change

NEW SIGNAGES


53/92

Signages-WIN Towns

Hard Merchandising

Soft Merchandising

Marcom Expenses New town launch

Cutomer Acquisition Charges-COCA - Per

Advt Expn-Others

TOTAL 0 0 0 0


54/92

PCO

GSM/RTL

GSM ProvPCO Prov Mobile

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 1 1

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0 0 0 1 0 1

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

CDMAExp

CDMAProv

CDMA-TOTAL

GSM-TOTAL

Hello-Prov


55/92

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0 0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0


56/92

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 5 5

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0


57/92

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0 0 0 5 5

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0


58/92

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0 0 0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0


59/92

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 00 0 0 0 0 0 0 0 0


60/92

Wireless

00

0

0

0

1

0

0

0

0

0

0

00

0

1

0

0

0

0

0

0

0

0

00

0

0

0

0

0

0

0

0

0

0

00

0

0

0

0

0

0


61/92

0

0

0

0

0

0

00

0

0

0

0

0

0

0

0

0

0

00

0

0

0

0

0

0

0

0

0

00

0

0

0

0

0

0

0

0

0

0

00

0

0

0

0

0

0


62/92

0

0

0

0

0

0

00

0

0

0

0

0

0

0

0

0

0

00

0

0

0

0

0

0

0

0

0

0

00

0

0

0

0

0

0

0

5

0

0

00

0

0

0

0

0

0


63/92

0

0

0

0

0

0

00

0

0

0

0

0

0

0

0

0

5

00

0

0

0

0

0

0

0

0

0

0

00

0

0

0

0

0

0

0

0

0

0

00

0

0

0

0

0

0


64/92

0

0

0

0

0

0

00

0

0

0

0

0

0

0

0

0

0

00

0

0

0

0

0

0

0

0

0

0

00

0

0

0

0

0

0

0

0

0

0

00

0

0

0

0

0

0


65/92

0

0

0

0

0

0

00


66/92


Circle:

Month Sep-09

1.200 Provision Pendency in no. of months Rs. In lacs

CDMA GSM RTL Total

YTD Provision

7457301 DST Cost - Personnel 0.00 - - 0 0.00 - - 0.00

7456073 Activation Commission Post paid - RIM 0.00 - - 0 0.00 - - 0.00

7456031 Acquisition/Fulfilment-RIM 0.00 - - 0 0.00 - - 0.00

7456074 CWG Commission 0.00 - - 0 0.00 - - 0.00

7457302 DST Cost - CWG 0.00 - - 0 0.00 - - 0.00

7545300 Address Verification Expenses-Postpaid 0.00 - - 0 0.00 - - 0.00

7545310 CAF Management charges 0.00 - - 0 0.00 - - 0.00

7545303 Customer Verification CWG 0.00 - - 0 0.00 - - 0.007456072 Activation Commission Post paid - FWP 0.00 - - 0 0.00 - - 0.00

7456032 Acquisition/ Fulfilment Commission-FWP Postpaid 0.00 - - 0 0.00 - - 0.00

7456032 Upfront comm FWP 0.00 - - 0 0.00 - - 0.00

7456061 Activation Commission Pre paid - RIM 0.00 - - 0 0.00 - - 0.00

7456035 Key Retailer 0.00 - - 0 0.00 - - 0.00

7456036 Primery Incentive 0.00 - - 0 0.00 - - 0.00

7456021 Channel Associates - Commission 0.00 - - 0 0.00 - - 0.00

7456063 Activation Commission Pre paid - Data card 0.00 - - 0 0.00 - - 0.00

7545301 Customer Verification Prepaid 0.00 - - 0 0.00 - - 0.00

7456062 Upfront comm FWP/Fulfilment commission 0.00 - - 0 0.00 - - 0.00

7456062 Activation Commission 0.00 - - 0 0.00 - - 0.00

7456071 PCO Commission/Scheme(Aquisition Commission) 0.00 - - 0 0.00 - - 0.00

7457210 CPE Installation Charges 0.00 - - 0 0.00 - - 0.00

7545302 Customer Verification PCO 0.00 - - 0 0.00 - - 0.007457303 DST Cost-PCO 0.00 - - 0 0.00 - - 0.00

7410090 Fulfillment Commission-PCO 0.00 - - 0 0.00 - - 0.00

7457000 Billing Expenses 0.00 - - 0 0.00 - - 0.00

7457004 Billing Expenses CWG 0.00 - - 0 0.00 - - 0.00

7457030 Commission to Collection Agent-personal 0.00 - - 0 0.00 - - 0.00

7457033 Collection Commission-CWG 0.00 - - 0 0.00 - - 0.00

7457041 CRO Collection Commission -PB 0.00 - - 0 0.00 - - 0.00

7457042 CRO Collection Commission -CWG 0.00 - - 0 0.00 - - 0.00

7457010 Collection Expenses-Others 0.00 - - 0 0.00 - - 0.00

7457035 Customer Retention Commission - Personal 0.00 - - 0 0.00 - - 0.00

7457015 Coll Exp -data entry for cheques collected 0.00 - - 0 0.00 - - 0.00

7457020 Coll Exp -Cheques Pickup charges 0.00 - - 0 0.00 - - 0.00

7457021 Cheque pick up Charges - CWG 0.00 - - 0 0.00 - - 0.00

7155310 Hire Chgs - Cont.Serv - Feet on Stree - Colle 0.00 - - 0 0.00 - - 0.007456020 Channel Associates - Reimbursement 0.00 - - 0 0.00 - - 0.00

7457034 Channel Performance Incentive - Personal 0.00 - - 0 0.00 - - 0.00

7457025 Coll Exp-Drop Box Charges 0.00 - - 0 0.00 - - 0.00

7180000 RBPO & Welcome health 0.00 - - 0 0.00 - - 0.00

7155330 Hire Chgs - Cont.Serv - Tele Calling - Collec 0.00 - - 0 0.00 - - 0.00

7155300 Hire Charges-Contracted Services(oper) 0.00 - - 0 0.00 - - 0.00

7155340 Hire Chgs - Cont.Serv - Tele Calling - Market 0.00 - - 0 0.00 - - 0.00

7155350 Hire Chgs - Cont.Serv - OTC / CDC 0.00 - - 0 0.00 - - 0.00

7155303 Hire Charges - Contracted Services (Operations) - CWG 0.00 - - 0 0.00 - - 0.00

7155302 Hire Charges - Contracted Services (Operations) - PCO 0.00 - - 0 0.00 - - 0.00

7180001 Customer care Expense- PVAP 0.00 - - 0 0.00 - - 0.00

7180002 Customer care expenses - WWE 0.00 - - 0 0.00 - - 0.00

7180003 Customer Care Expenses - Others 0.00 - - 0 0.00 - - 0.00

7400100 Webstore Expenses 0.00 - - 0 0.00 - - 0.007405000 Sales Promotion Expenses Within India 0.00 - - 0 0.00 - - 0.00

7435000 Other Selling and Distribution Expenses 0.00 - - 0 0.00 - - 0.00

7420200 Packing Expenses 0.00 - - 0 0.00 - - 0.00

7420010 Freight & Forwarding - Rail Transport Charges 0.00 - - 0 0.00 - - 0.00

7420030 Freight & Forwarding - Air Transport Charges 0.00 - - 0 0.00 - - 0.00

7456140 Credit verification agency fees 0.00 - - 0 0.00 - - 0.00

- - 0.00 - - 0 - - 0 - - 0.00

Overall Scoring 100%

Note:-

1)Scoring criteria is tabulated below:-

Criteria Score

Provision Pendency < 1.5 months +2

Provision Pendency 1.5 - 2.0 months +1

Provision Pendency 2.0 - 2.5 months -1

Provision Pendency >2.5 months -2

ActualExp.

ProvisionPendency

ActualExp.

YTDProvision

ProvisionPendency

ActualExp.

YTDProvision

ProvisionPendency

ActualExp.

YTDProvision

ProvisionPendency

2) While calculating productwise Scoring, No. of line items * 2 is considered as maximum score so taken as denominator and Total scoreobtained is considered as numerator.


67/92

Scoring

2

2

2

2

2

2

2

2

22

2

2

2

2

2

2

2

2

2

2

2

2

2

22

2

2

2

2

2

2

2

2

2

2

2

2

2

22

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

112.00


68/92


69/92


70/92


71/92


72/92


73/92


74/92


75/92


76/92


Circle:

Month Sep-09

1.400 Cost reduction(Rs. In Lac)

Sr. no Description Revised Cost Remarks

1 Billing & Collection Cost 100.00 90.00 10%

Total 100 90 10%


1.410 Process Improvement initiatives

Sr. no Description Type Score

1 Please fill Details Not Unique 1

Total 1

Overall Scoring 40%

Note:- Cost Reduction

1) Pls copy the formula (i.e column F & H ) for every new row inserted.


Criteria Score

Saving >=10% +2

Saving >=5%


77/92

GL Score

2

2

mn.

us savings must be mentio

+


78/92


Circle:

Month: Sep-09

2.400 Clawback & Recovery

Name of CP Type of CP Code Clawback Type % o

PCO 200 100 300 200 100

Billing CB 0 0Acquisition Commission Reversal 0 0

Billing CB 0 0

PCO 0 0

PCO 0

PCO 0

PCO 0

PCO 0

PCO 0

Total 200 100 100

Overall Scoring PCO -100%

PCO business NA

Note:- 1) If you want to insert a row please selct any valid row and press CTRL C AND Then press Ctrl +


Other Than PCO

Criteria Score

86-100% Clawback Recovery+2


61-75% Clawback Recovery 0

51-60% Clawback Recovery -1

< 50% Clawback Recovery -2

3) While calculating overall Scoring, No. of line items * 2 is considered as maximum score so taken as denominator and Total score obtained is considered as numerator.4) In case of PCO Comission payable needs to be entered column " Commission Income"

5) In case circle does not have PCO business the same must be mentioned by highlighting "NA" as "NA"

Opening Bal of cawlback ason 01.07.09

Clawbacklevied inAUG 09

TotalAmount

Recoverable

Commission-Income

Net AmountRecoverable

AmountRecovered

Relance:Pl do not enter in thiscolumn

Relance:

Pl do not enter in thiscolumn


79/92


Circle:

Month: Sep-09

2.500 Pending Pay-in Slip as on:

Name of CP Type Code

Overall Scoring 0%

Note:- * Pl provide Pending PIS status as on 25th day of every month

1) If you want to insert a row please select any valid row and press CT


Criteria PIS Value

Channel partners with pendency for 0-3 days



Channel partners with pendency for > 10 days

Channel partners with pendency for > 30 days < 3000

Channel partners with pendency for > 30 days > 3000

3) For Pendancy > 30 days,PIS Value Column is included which carries

4) Minimum score will not be less than zero

5) While calculating overall Scoring, No. of line items * 2 is consideredTotal score obtained is considered as numerator.


80/92

Days PIS Value Scoring

6-10 -1

0-3 2

6-10 -1

6-10 -1

4-5 1

>30 4000 -6

>30 -3

0-3

0-3

0-3

0-3

0-3

0-3

0-3

0-3

0-3

0-3

0-3

0-3

0-3

0-3

0-3

0-3

0-3

0-30-3

0-3

0-3

0-3

0-3

0-3

0-3

-9

L C AND Then press Ctrl +

Score

+2

+1

-1

-2

-3

-6

weight 2 if PIS value is more than 3000.

s maximum score so taken as denominator and


81/92

Relance:

Please paste copy of mail of MOM discussed and sent to CEO. You may hide thiscomments after pasting the mail.

In case MOM is not pasted as per the schedule, the same must be separately to Mrmahesh krishnamurthy and Mr Sanjay.

Activity scoring criteria:

Review by 15th +2Review by 18th +1Review by 20th 0Review by 23rd -1Review after 23rd -2

Note: The basis of scoring would be review date.

MOM must be received latest by 24th in case of reveiw on 23rd, else within 3 dayswhere review happens on 15th/18th & 20th respectively.


82/92


Circle:

2.300 NOC From Externa C anne Partners

Name of CP Type SAP Code

KEY

1 2 1 Clear

2 NOC received with pending issues for 1 month

3 NOC received with pending issues for >1


83/92

NOC received with pending issues for >1


84/92


Circle:

Month Sep-09

2.200 Channel Payout

Type of CP Total No. of CP Commission

2 2 Acquisition Commissi

2 2

2 22 2

2 22 2

2 2

2 22 2

2 2

2 2

Overall Scoring

* Active CPs: Acquisition made for last 04 months or Bil ling done in last 04 months.

Note:- 1) Pl copy the Scoring formula (i.e column N,O,P) for every new row inserte


Criteria Score

90-100% payouts ti ll 15th +290-100% payouts ti ll 23rd +1

Outstanding payments 0

4) AUG months scheme must be settled 100% in SEP, scheme's that are exten

5) Blank Rows with zero data must be deleted.6) If you want to insert a row please selct any valid row and press CTRL C AN

No. of ActiveCPs *

Eligible forPayment

(No.)

P1

3) While calculating overall Scoring, No. of line items * 2 is cons idered as maximas denominator and Total score obtained is considered as numerator .


85/92


86/92


87/92


Circle:

Month: Sep-09

2.200 Channel Payout

Name of CP Type Status SAP Code Type


88/92


89/92


90/92


Circle:

Month: Sep-09

2.600 DST Cost

Name of DST Code Scoring

0

0

0

0

0

0

0

0

0

00

0

0

0 0

Overall Scoring 0%

Note:-

* DSTs considered should be in the system for 1 month

1) Pls copy the Scoring formula (i.e column E) for every new row inserted.


Criteria ScoreAcquisition per DST :

8 - 9 Nos. +2

6 - 7 Nos. +1

< 6 Nos. 0

No. ofAcquisition(FTM)

3) While calculating overall Scoring, No. of line items * 2 is considered as maximum score so taken asdenominator and Total score obtained is considered as numerator.


91/92


Circle:

Month Sep-09

Fraud Monitoring & Control (FMC) - LES Score

Circle:

Compliance Score (%): 100%

Quality Score (%): 100%

Total Score (70% Compliance + 30% Quality) : 100%

Activities Expectations From Circle Criticality Weightage

Cases Validated Quality Check

Cloning - RE AV RE-AV 3 - 3 100.00% 0.00%

Cloning - Board Swap Board swap 3 - 2 100.00% 0.00%

Cloning - Adjustment/Waiver Adjustment/Waiver to be passed 3 - 2 100.00% 0.00%

Dedupe RE-AV 3 - 8 100.00% 0.00%

High Usages - Negative RE-AV RE-AV 3 - 3 100.00% 0.00%

Call Fingerprint Matching With Dedupe Fraud Customer RE-AV 3 - 2 100.00% 0.00%

Call Profiling RE-AV 2 - 2 100.00% 0.00%

Suspicious Credit Cards payment RE-AV 3 - 2 100.00% 0.00%

Address/SDCA change RE-AV 1 - 3 100.00% 0.00%

High Usage-Gold/Platinum Customers Review and Action 1 - 2 100.00% 0.00%

High Usage- Postpaid Corporate Customers Review and Action 2 - 4 100.00% 0.00%

International Roaming High Usage-Gold/Platinum Customers Review and Action 3 - 1 100.00% 0.00%

Adjustments Passed Review reasons and approvals 3 - 4 100.00% 0.00%

Comprehensive Adjustments Review reasons and approvals 2 - 8 100.00% 0.00%

Negative Balance In Postpaid Accounts Review excess payments 2 - 5 100.00% 0.00%

Premium Number Allocations Review reasons and approvals 3 - 2 100.00% 0.00%

Cheque Bounce Cases / NLD / ILD - Incorrect Reactivation Review reasons and approvals 1 - 4 100.00% 0.00%

Special Credit Limit - Increase in customer's Credit Limit Review reasons and approvals 1 - 4 100.00% 0.00%

International Roaming / ILD - Incorrect Activations Review reasons and approvals 2 - 2 100.00% 0.00%

Weighted Score 100% 100%

Please Note:

Compliance with SLA (%) = (1 - No. of Exceeding SLA / Total) * 100

Weightage = Criticality * Total No. of Cases

Criticality: 3 - High, 2 - Medium, 1 - Low

SLA forClosure

(No of days)No. ofCases

No of CasesexceedingSLA

ComplianceScore (%)

No ofSampleschecked

No of Casesincorrectlyactioned

QualityScore (%)


92/92


Circle: Orissa

Month Sep-09

A. Business Commercial - Process Compliance - LES Score

Circle:

Compliance Score (%): 100%

Punctuality Score (%): 0%

90%

Activities Weightage

Total Base Compliance Punctuality of Report Submission

Measure of Total Base Unit Value Measure of Action taken Value Actual Date

Address Verification5 No of OTAFs (AV Positive) No ('000s) Sample Size 10.0% 10% 100% 0%

5 AV Negative Cases No ('000s) AV Negative Cases actioned 100.0% 100% 100% 0%

Money collected (Tradeable Stock) 10 Collection Amount Rs. (Lakhs) Money collected without reversal 100.0% 100% 100% 0%

Postpaid Collection 10 Collection Amount Rs. (Lakhs) 100.0% 100% 100% 0%

Sales Return Analysis 10 Circlewise sales returns Rs. (Lakhs) Sales Returns due to incorrect billing 100.0% 100% 100% 0%

Free Issue Material 10 Material Issued Rs. (Lakhs) Total Issued with approval 100.0% 100% 100% 0%

Waivers

3.33 Waiver Amount Rs. (Lakhs) Sample Size 30.0% 30% 100% 0%

3.33 Waivers Audited Rs. (Lakhs) Waivers with reasons found 100.0% 100% 100% 0%

3.33 Wrong waivers found in audit Rs. (Lakhs) Amount Reversed 100.0% 100% 100% 0%

Adjustments

3.33 Adjustment Amount Rs. (Lakhs) Adjustments Audited 30.0% 30% 100% 0%

3.33 Adjustments Audited Rs. (Lakhs) Adjustments with reasons found 100.0% 100% 100% 0%

3.33 Wrong adjustments found in audit Rs. (Lakhs) Amount Reversed 100.0% 100% 100% 0%

Security Deposit Waiver

3.33 Number Acquisitions w/o waiver 80.0% 80% 100% 0%

3.33 Acquisitions w/o waiver Number Waivers Audited 20.0% 20% 100% 0%

3.33 Negative Audit results Number Collection 100.0% 100% 100% 0%

Customer Refund5 Refunded Amount Rs. (Lakhs) Refunded within 60 days 100.0% 100% 100% 0%

5 Refunded Amount Rs. (Lakhs) Amount Audited 20.0% 20% 100% 0%

CAF Management 10 Total Retrieval Requests Number Honoured in SLA 100.0% 100% 100% 0%

Overall 100 100.0% 0.0%

Compliance score is reduced from 10 to 5 for all circles

B. CAF Management / CAF retrieval for VTM

CAF retrieval for VTM % Score

100 N 100 100% 2

100 Y 95 95% 0

Total 1 2


CAF retrieval cannot be more than Caf request received from VTM

In case of NON RDEL cirlces(viz DEL,KOL,CHG,MU,OR,J&K,ASSAM & NE) ,Total maximum score for CAF magment is to be made 6 in overall score

In case of RDEL cirlces(viz DEL,KOL,CHG,MU,OR,J&K,ASSAM & NE) ,Total maximum score for CAF magment is to be made as 3 .

Activity Scoring

Criteria- caf retrieval % Score

Prior to 1 St Apr 2007

< 96% 0

>96% and < 100% 0.5

100% 1

Post to 1 St Apr 2007

< 96% 0

>96% and < 100% 0.5

100% 2

C. RDEL Submission Cleared

Fin Year Amt Received in Aug Score

2007-08 0 0 0 100%

2008-09 20 11 9 50%

2007-09 20 11 9 75%2009-10 15 14.8 0.2 50%

Total Score(90% Compliance + 10% Punctuality) :

Actual%

Benchmark%

ComplianceScore

ExpectedDate

PunctualityScore

Collection deposited on time(100% on time + 50% (1 - 7 days)

Acquisitions(other than SOHO & SME)

CAF retrieval request received inAug

Prior to 1st Apr2007

Amt of claim ason 1.8.2009

Balance

Amt ofclaim

Relance:To be entered manually

Documents

Original Format Sep LES