Work Sheet For MBR
Work Sheet For MBR
Work Sheet For MBR
JULY'14 100 90
AUG'14 100 80
SEP'14 100 102
OCT'14 100 64
NOV'14 100 84
DEC'14 100 69
JAN'15 100 78.83
FEB'15 100 102.2
MAR'15 100 91
APR'15 120 86.94
MAY'15 120 83.65
JUNE'15 120 111.95
JULY'15 120 94.78
2012-13 2014-15
MONTHL 2013-14 MONTHLY MONTHLY
2 Y AVERAGE AVERAGE
AVERAGE
SEGMENT WI
2012-13
S.NO CATEGORY
No. of
Customers
A) Dealers Business 33
B) OEM'S 3
C) Group Companies 4
D) Direct Parties 72
Total 112
2014-15
JULY'14 AUG'14 SEP'14 OCT'14 NOV'14 DEC'14 JAN'15 FEB'15 MAR'15 APR'15 MAY'15 JUNE'15
2015-16 YTD
9373 NUMBERS
MONTH
384 MMN CNF PDK
JULY 1048 116 1585
MBERS TONNAGE
TOTAL TOTAL
CNF MMN CNF PDK CNF
192 2941 37 4.71 51.72 7.64 101.07
DIRECT PARTIES ZONE 1 QTR 2014-15 2 QTR 2014-15 3 QTR 2014-15 4 QTR 2014-15
OE - TONNAGE
DIRECT PARTIES ZONE 1 QTR 2014-15 2 QTR 2014-15 3 QTR 2014-15 4 QTR 2014-15
3.3 EAST
0.19 WEST 27 17.79 13.47 29.7
1.04 NORTH 0.59
10.2 SOUTH 0.27 0.16 0.3 0.24
DIRECT PARTIES ZONE 1 QTR 2014-15 2 QTR 2014-15 3 QTR 2014-15 4 QTR 2014-15
4.76 EAST
0.83 WEST
0.72 NORTH
5.6 SOUTH 6.88 4.28 5.42 4.77
DIRECT PARTIES ZONE 1 QTR 2014-15 2 QTR 2014-15 3 QTR 2014-15 4 QTR 2014-15
2.83 EAST 3.3 4.76 2.83 2.75
0.41 WEST 0.19 0.83 0.41 0.61
NORTH 1.04 0.72 1.23
7.54 SOUTH 10.2 5.6 7.54 6.93
DIRECT PARTIES
2.75
0.61
1.23
6.93
1 QTR 2015-16
18.67
13.3
7.77
1 QTR 2015-16
34
0
0.2
1 QTR 2015-16
4.14
1 QTR 2015-16
4
2.4
0.7
5.32
MONTH S.NO LIST OF NEW CUSTOMERS LOCATION
1 Auto & Farm Equipment Co. Gwalior
2 CMR Toyotsu Aluminium India Pvt. Ltd Chennai
3 Hindustan Coca-cola Moula-Ali
4 Hindustan Coca-cola Dasna
5 Hindustan Coca-cola Bhopal
Apr-15 6 Jindal Steel & Power Limited Angul
7 Magesh Engineering Works Chennai
8 Malhotra Rubber UP
9 Pharmazell Chennai
10 SBMT Equipments Bangalore
11 Tata Motors Lucknow
Hindustan Copper Ltd
Jet Airways
Jindal Steel & Power
Tata Motors
Visa Steel
TARGET ACHIEVEMENT
120 81
TARGET ACHIEVEMENT
50 43.33
140
120
120
100
81
80
Row 3
60
40
20
0
TARGET ACHIEVEMENT
2014-15
TARGET 100
ACHIEVEMENT 89
% ACHIEVED 89
TARGET ACHIEVEMENT
2014-15 100
2015-16 120
APR'15 MAY'15
MMN
PDK
TOTAL 87 84
1200
618
1000
OE - PERFORMANCE ANALYSIS
485
800 360
OE HALF YEARLY FY 2014-15 - AVG HALF YEARLY FY 2015-16 - AVG
GODREJ 242 336 416
600 FY 2015-16
VOLTAS 400 310 429
514 FY 2014-15
468
400 430 192
800
700 410
600 396
307
500
291
390 327
400 FY 2015-16
FY 2014-15
300 280
266
200 180 196
100 98
30
0
APRIL MAY JUNE JULY AUG SEP
70
60
50.00
50
43.33
40
30
20
10
Row 3
0
TARGET ACHIEVEMENT
Note: Incl C & F sale.
140
120
2015-16 100
120
80
2014-15
94 2015-16
60
78 40
20
0
ACHIEVEMENT % ACHIEVED TARGET ACHIEVEMENT % ACHIEVED
89 89
94 78
JUN'15
112
GODREJ
GROWTH % FY APRIL MAY JUNE JULY AUG SEP
416 39 2014 180 266 280 196 30 98 1050
FY 2015-16
7 2015 291 307 410 396 390 327 2121
FY 2014-15
2
0 VOLTAS
227
FY APRIL MAY JUNE JULY AUG SEP
GROWTH % 2014 468 218 514 430 240 227 2097
74 2015 360 310 618 485 192 416 2381
SEP
30
GODREJ 102
VOLTAS 13.54
261057
130212
& 2015-16 444083
835352 1108.35
2158
3780
7046.35
327
FY 2015-16
FY 2014-15
98
SEP
2014-15
2015-16
DOM - 1 QTR SALES ANALYSIS
16
14 13.64
12 11.11 12.31
10 10.38
9.55
8.83
8
0
APR'15 MAY'15 JUN'15 JULY'15 AUG'15 SEP'15
0.783333
10 0
DOM DOM DOM DOM DOM
APR'15 MAY'15 JUN'15 APR'15 MAY'15
APR 11.11
MAY 8.83
JUNE 13.64
JULY 12.31
AUG 9.55
SEP 10.38
PDK
58
39
35 PDK
120.00
50.00
120
50
140
101.92 45
120.00
100
120
79.03 40
MMN TARGET ACHIEVEMENT 94.78
35
100
50 38.57 80
30
80
60
25
4.29 60
20
40
15
40
PDK TARGET ACHIEVEMENT 10
20
20
120 92.00 5
00
TARGET
TARGET
90 85
70
50
30
10
FY 14-15 AVG I QT
ORDER INTAKE V
100
90
80
ORDER
FY 2015-16 ORDER INTAKE DESPATCHED ORDER INTAKE V
IN TONNES IN TONNES 100
APRIL 80 84 90
MAY 110 82 80
JUNE 100 105.5 70
JULY 100 94.78 60
TONNAGE
97.5 50
40
30
20
10
0
APRIL MAY
FY 2014-15 FY 2015-16
APR 95 86.94
MAY 85 83.65
JUNE 86 111.95
120.00
50.00 JULY 87 94.78
AUG 77
120.00 SEP 101
92.00
38.57 OCT 64.65
NOV 82.45
94.73
DEC 73.66
JAN 79
FEB 89.49
MAR 94.62
84.6 94.3
TARGET
TARGET ACHIEVEMENT
ACHIEVEMENT 39.99 4.71
46.48 7.64
ISON CHART FOR THE FY 2014-15 & 2015-16 WITH JULY 2015 pdk 46.48 7.64 54.12
94.73
ACTUALS
94 95
85
I QTR FY
FY 2014-15
SEGMENT 2015-16 Diff in %
AVG AVG
OE 22.38 34.12 52.45
DEALER 45.29 41.08 -9.30
DIRECT ACCOUNTS 11.48 14.83 29.17
GROUP COMPANIES 5.33 4.14 -22.31
TYRE SIZE % OF TOTAL SALES mmn + c nf
18X7-8 32 233 1356
6.00-9 4 18
6.50-10 94 68
7.00-12 92 41
8.15-15 10 145
MMN CNF
1048 308 1356
18X7-8 233 32 265
6.00-9 18 4 22
6.50-10 68 94 162
7.00-12 41 92 133
8.15-15 145 10 155
* Have data only for MMN.
FY 2012-13 2013-14 2014-15 2015-16 TILL JULY'15
TOTAL SALE IN 18493 21784 25370 9373
NUMBERS
100.0 96.0
84.5
80.0 72.6
61.6
60.0
40.0
20.0
0.0
2012-13 2013-14 2014-15 2015-16 TILL JULY'15
18 2114 16 2343 11
18 84.5 16 96 14
% COMPARISON - SEGMENT WISE
2015-16 as on
2014-15 31st July 2015
%
Comparison
on tonnage
-6
55
-27
28
14
S.NO STATES & UNION TERRITORIES ZONE
6 Chhattisgarh East
17 Jharkhand East
26 Odisha East
36 West Bengal East
SOUTH EAST
Dharwad
Karwar
Raichur
Bellary
Chitradurga
Shimoga
Chikmaglur
Tumkur
Kolar
APRIL 87
MAY 84
JUNE 112 94.33
94.61 JULY 101 TARGET I QTR ACHIEVEMENT II QTR ACHIEVEMENT
81 AUG 82 70 47.00 52.5
SEP 109
97.33333
70.00
70
60
50 47.00
140
40 120
120
30 100
100
20 80
10 60
TARGET I QTR ACHIEVEMENT
40
20
0
DOM - 1 QTR SALES ANALYSIS TARGET A
52.50
47.00
2014-15
FY
2015-16 TARGET ACHIEVEMENT % ACHIEVED
I QTR ACHIEVEMENT II QTR ACHIEVEMENT 2014-15 100 88.5 88.5
2015-16 120 96 80
Apr-14 95
TARGET ACHIEVEMENT % ACHIEVED May-14 85
Jun-14 86
Jul-14 87
Aug-14 77
Sep-14 101
20
0
APR'15 MAY'15 JUN
50
TOTAL
CNF
6.83 87
3.92 84
5.82 112
7.6 101
6.23 82
4.47 109
250
FY APRIL MAY JUNE JULY AUG SEP
2014-15 6 12 9 0 0 21551
200
2015-16 22 70 63 126 102 215
150
126 2014-15
102 2015-16
100
70
63
50 51
22
6 12 9
0 0 0
APRIL MAY JUNE JULY AUG SEP
RETREIVED CUSTOMERS
5
0
1. Pepsi co - Mamandur
APR'15 MAY'15 JUN'15 JUL'15 AUG'15 SEP'15 2. Maruthi Suzuki India Pvt Ltd
emicals Pvt Ltd
NO TONNAGE
MMN 1493 72.34
CNF 152 4.86
183
OVERALL SALES
2014-15 2015-16
I QTR 88.7 94.18
II QTR 88.33 97.11
OCT 64.65 145
C&F
2014-15 2015-16
I QTR
II QTR
OCT
2014-15
S.NO CATEGORY
AVG No. of Tyres / month
A) Dealers Business 1110
B) OEM'S 562
C) Group Companies 135
D) Direct Parties 308
Total 2114
STOCK SUBSTITUTION
PARTICULARS 2014-15 2015-16 YTD
IN NUMBERS 186 183
IN TONNAGE 7.32 7.7
APRIL MAY
SLTL 79 186
SECOND SALES 0 12
AVATAR 0 0
79 198
FY 2013-14
VALUE OF FORMS
PARTICULARS NO.OF CUSTOMERS REMARKS
TO BE COLLECTED
GEMINI DBN 3.78 L / UNITED
FORM - C 9 11.8 MOTOR C-FORM 0.36 L incl. by A &
F.
FORM - H 1 47.2 Doubtful
FY 2014-15
VALUE OF FORMS
PARTICULARS NO.OF CUSTOMERS REMARKS
TO BE COLLECTED
FORM - C 73 36.41
FORM - H 8 467.18 41.85 L Doubtful
150
140
130
120
110
100
90
80
70
60
50
40
30
20
10
TARGET ACHIEVEMENT
% GROWTH APRIL
6 2015-16 86.94
10 2014-15 95
124
% GROWTH APRIL
#DIV/0! 2015-16 11.88
#DIV/0! 2014-15 12.22
#DIV/0! 2015-16 284
2014-15 354
LES ANALYSIS - COMPARISON
Avg Tonnage / month AVG No. of Tyres / month Avg Tonnage / month
45 1134 44.6
22 938 36.7 FY 2014-15 (TONNAGE)
5 108 4.3 FY 2015-16 (TONNAGE)
11 399 17
84 2579 102.6
6701 261.37
% GROWTH 5212 196.7
-100 602 23.37
2335 92.44
7835 305.97
% GROWTH 6150 233.4
-2 710 27.67
2734 109.44 160
140
1119.2857142857 43.71 44.6
878.5714285714 33.3428571429 36.7 120
101.4285714286 3.9528571429 4.3
100
390.5714285714 15.6342857143 17
80
60
40
2015-16
2014-15 20
0
I QTR
2015-16
2014-15
16.00
14.00
12.00
APR MAY
10.00 JUN JUL AUG SEP OCT NOV
FY 2014-15 (TONNAGE) 0.03 0.2 0.15 0 0 0.84 0 0.16
8.00
FY 2015-16 (TONNAGE) 0.63 1.92 1.52 3.62 3.03 5.89 3.7
6.00
4.00
2.00
10.00
8.00
6.00
4.00
10
2.00
9
8 0.00
APRIL MAY JUNE JULY AUG SEP OCT NOV DEC JAN FEB MAR
7
6 240
5 FY 2014-15 (TONNAGE) 220
FY 2015-16 (TONNAGE) 200
4
180
3 160
160 2 140
1 120
140
100
0
120 80
APRMAYJUN JUL AUG SEP OCTNOVDEC JAN FEBMAR
60
100
40
80 2015-16 20
2014-15 0
60 APR MAY JUN JUL AUG SEP O
9.00
8.00
7.00
[email protected]
6.00
Kind attn Mr. Ashok
5.00
ERAGE TONNAGE PER MONTH - COMPARISON
4.00
2015-16
TONNAGE
103 3.00
2.00
1.00
0.00
APRIL MAY JUNE JULY AUG SE
POB SALES
FY 2014-15 (NOS) 6 12 9
FY 2015-16 (NOS) 22 70 63
FEB MAR
11.18 8.39
299 209
240
220
200
180
160
140
120 FY 2014-15 (NOS)
100 FY 2015-16 (NOS)
80
60
40
20
0
APR MAY JUN JUL AUG SEP OCTNOV DEC JAN FEB MAR
NON - MARKER TREND ANALYSIS - TONNAGE
JUNE JULY AUG SEP OCT NOV DEC JAN FEB MAR
2.27 2.45 2.36 3.54 5.70
3.00 3.23 4.64 4.91 1.36 2.52 2.09 2.46 3.00 5.60
2014-15
2015-16
MAY JUNE JULY AUG SEP OCT NOV DEC JAN FEB MAR
POB SALES IN NUMBERS
0 0 51 0 10 43 8 7 72
126 102 243 128