Download - 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.
-
8/8/2019 Original Format Sep LES
2/92
-
8/8/2019 Original Format Sep LES
3/92
Leadership Effectiveness Score
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
S.No Parameter Weightage
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:
S.No Parameter Weightage
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:
Activity Scoring Criteria
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.
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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:
Activity Scoring Criteria
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:
Activity Scoring Criteria
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
-
8/8/2019 Original Format Sep LES
6/92
Scoring will be done based on potential savings as tabulated below:
Activity Scoring Criteria
Criteria Score
Saving >=10% +2
Saving >=5%
-
8/8/2019 Original Format Sep LES
7/92
-
8/8/2019 Original Format Sep LES
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.
Activity Scoring Criteria
Criteria Score
86-100% Clawback Recovery +2
76-85% Clawback Recovery +1
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
Activity Scoring Criteria
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.
Activity Scoring Criteria
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
-
8/8/2019 Original Format Sep LES
9/92
-
8/8/2019 Original Format Sep LES
10/92
-
8/8/2019 Original Format Sep LES
11/92
ED"
-
8/8/2019 Original Format Sep LES
12/92
-
8/8/2019 Original Format Sep LES
13/92
-
8/8/2019 Original Format Sep LES
14/92
-
8/8/2019 Original Format Sep LES
15/92
-
8/8/2019 Original Format Sep LES
16/92
-
8/8/2019 Original Format Sep LES
17/92
Leadership Effectiveness Score
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
-
8/8/2019 Original Format Sep LES
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!
-
8/8/2019 Original Format Sep LES
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.
FWP Rate per Acquisitions Rs.
RDEL Rate per Acquisitions Rs.
FWP(PCO) Rate per Acquisitions Rs.
Other Acquisition Cost
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.
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 %
-
8/8/2019 Original Format Sep LES
20/92
GSM
Description Head KPI Unit
Qty
('000)
Acquisition Cost:
Channel Commission
Postpaid Mobile Rate per Acquisitions Rs.
CWG (Mobile) Rate per Acquisitions Rs.
Prepaid Mobile Rate per Acquisitions Rs.
Other Acquisition Cost
Postpaid Mobile Rate per Acquisitions Rs.
CWG (Mobile) Rate per Acquisitions Rs.
Prepaid Mobile 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.
RTL
Description Head KPI Unit
Qty
('000)
Acquisition Cost:
Channel Commission
Postpaid Mobile Rate per Acquisitions Rs.
Prepaid Mobile Rate per Acquisitions Rs.
Other Acquisition Cost
Postpaid Mobile Rate per Acquisitions Rs.
Prepaid Mobile Rate per Acquisitions Rs.
Billing Cost Postpaid Rate Per Bill Rs.
-
8/8/2019 Original Format Sep LES
21/92
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.
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
23/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%
- -
- -
- -
GSM Scoring
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.)
- -
- -
- -
- -- -
-
8/8/2019 Original Format Sep LES
24/92
- 0.0%
- -
- -
- -
RTL Scoring
Overall Scoring
-
8/8/2019 Original Format Sep LES
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)
-
8/8/2019 Original Format Sep LES
26/92
Variance YTD SEP 09
Qty Amount Rate Amount Total Amount Scoring
(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!
Variance YTD SEP 09
Qty Amount Rate Amount Total Amount Scoring
(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!
RateVariance
(Unit Cost)
RateVariance
(Unit Cost)
-
8/8/2019 Original Format Sep LES
27/92
- - - 0% 0
- - - 0% 0
- - - #DIV/0! #DIV/0!
- - - #DIV/0! #DIV/0!
#DIV/0!
#DIV/0!
-
8/8/2019 Original Format Sep LES
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 85% - 94.9% 50%
Target achieved 60% - 84.9% 25%
Target achieved < 60% 0%
Outgoing IUC - Outsider
Relance:Refer Notes below
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
45/92
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
47/92
0 0 7410085
0 0 7435021
0 0 7435022
0 0 7410086
0 0 7457305
0 0 7575100
0 00 0
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
65/92
0
0
0
0
0
0
00
-
8/8/2019 Original Format Sep LES
66/92
Leadership Effectiveness Score
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.
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
68/92
-
8/8/2019 Original Format Sep LES
69/92
-
8/8/2019 Original Format Sep LES
70/92
-
8/8/2019 Original Format Sep LES
71/92
-
8/8/2019 Original Format Sep LES
72/92
-
8/8/2019 Original Format Sep LES
73/92
-
8/8/2019 Original Format Sep LES
74/92
-
8/8/2019 Original Format Sep LES
75/92
-
8/8/2019 Original Format Sep LES
76/92
Leadership Effectiveness Score
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%
Overall Scoring 100%
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.
2)Scoring criteria is tabulated below:-
Criteria Score
Saving >=10% +2
Saving >=5%
-
8/8/2019 Original Format Sep LES
77/92
GL Score
2
2
mn.
us savings must be mentio
+
-
8/8/2019 Original Format Sep LES
78/92
Leadership Effectiveness Score
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 +
2)Scoring criteria is tabulated below:-
Other Than PCO
Criteria Score
86-100% Clawback Recovery+2
76-85% Clawback Recovery +1
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
-
8/8/2019 Original Format Sep LES
79/92
Leadership Effectiveness Score
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
2)Scoring criteria is tabulated below:-
Criteria PIS Value
Channel partners with pendency for 0-3 days
Channel partners with pendency for 4-5 days
Channel partners with pendency for 6-10 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.
-
8/8/2019 Original Format Sep LES
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
-
8/8/2019 Original Format Sep LES
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.
-
8/8/2019 Original Format Sep LES
82/92
Leadership Effectiveness Score
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
-
8/8/2019 Original Format Sep LES
83/92
NOC received with pending issues for >1
-
8/8/2019 Original Format Sep LES
84/92
Leadership Effectiveness Score
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
2)Scoring criteria is tabulated below:-
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 .
-
8/8/2019 Original Format Sep LES
85/92
-
8/8/2019 Original Format Sep LES
86/92
-
8/8/2019 Original Format Sep LES
87/92
Leadership Effectiveness Score
Circle:
Month: Sep-09
2.200 Channel Payout
Name of CP Type Status SAP Code Type
-
8/8/2019 Original Format Sep LES
88/92
-
8/8/2019 Original Format Sep LES
89/92
-
8/8/2019 Original Format Sep LES
90/92
Leadership Effectiveness Score
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.
2)Scoring criteria is tabulated below:-
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.
-
8/8/2019 Original Format Sep LES
91/92
Leadership Effectiveness Score
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 (%)
-
8/8/2019 Original Format Sep LES
92/92
Leadership Effectiveness Score
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
Overall Scoring 100%
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