DA CALCULATION SHEET

DA CALCULATION SHEET 

DA CALCULATION SHEET WITH INPUTS OF CPI(I-W) BASE YEAR 2001=100

We are proud to be the first to formulate the DA Table. 

We are aware of the fact that a number of you are very keen on learning how to calculate the Dearness Allowance. Hence, we created this table. At a stage, we ourselves were surprised by the response that it had received. Let us see, in detail, how DA is calculated. The calculations are very easy.  First is the month. Then comes the CPI (IW) Base Year 2001=100 and the relevant data. In the next column, you have the sum total of all the 12 months, i.e., the total of the declared AIPCIN numbers for the past 12 months. Next comes the division of the sum total by 12. 

The next step is the most crucial one. You will have to find out by how much it exceeds 115.76. You will have to calculate the excess as percentage of 115.76. 

(12 Monthly Average) – 115.76 
-----------------------------------    X 100  =  Percentage increase in prices (ignore decimals)
                     115.76

The table has been created to easily understand the formula...

M /Year
B.Y. 2001=100
Total of 12 Months
12 Months Average
% Increase over
115.763
App. DA
DA %
Jan-06
119
116.08
0.32
0.28
Feb-06
119
116.58
0.82
0.71
Mar-06
119
117.08
1.32
1.14
Apr-06
120
117.58
1.82
1.57
May-06
121
118.17
2.41
2.08
Jun-06
123
721
118.92
3.16
2.73
2
Jul-06
124
119.58
3.82
3.3
Aug-06
124
120.16
4.4
3.8
Sep-06
125
120.83
5.07
4.38
Oct-06
127
121.58
5.82
5.03
Nov-06
127
122.25
6.49
5.61
Dec-06
127
1475
122.92
7.16
6.18
6
Jan-07
127
1483
123.58
7.82
6.76
Feb-07
128
1492
124.33
8.57
7.41
Mar-07
127
1500
125
9.24
7.98
Apr-07
128
1508
125.67
9.91
8.56
May-07
129
1516
126.33
10.57
9.13
Jun-07
130
1523
126.92
11.16
9.64
9
Jul-07
132
1531
127.58
11.82
10.21
Aug-07
133
1540
128.33
12.57
10.86
Sep-07
133
1548
129
13.24
11.44
Oct-07
134
1555
129.58
13.82
11.94
Nov-07
134
1562
130.17
14.41
12.44
Dec-07
134
1569
130.75
14.99
12.95
12
Jan-08
134
1576
131.33
15.57
13.45
Feb-08
135
1583
131.92
16.16
13.96
Mar-08
137
1593
132.75
16.99
14.68
Apr-08
138
1603
133.58
17.82
15.4
May
2008
139
1613
Jun
2008
140
1623
135.25
16.84
16
July
2008
143
1634
Aug
2008
145
1646
Sep
2008
146
1659
Oct
2008
148
1673
Nov
2008
148
1687
Dec
2008
147
1700
141.67
22.38
22
Jan
2009
148
1714
Feb
2009
148
1727
Mar
2009
148
1738
Apr
2009
150
1750
May
2009
151
1762
June
2009
153
1775
147.92
27.78
27
July
2009
160
1792
149.33
29
Aug
2009
162
1809
150.75
30.23
Sep
2009
163
1826
152.17
31.45
Oct
2009
165
1843
153.58
32.67
Nov
2009
168
1863
155.25
34.11
Dec
2009
169
1885
157.08
35.7
35
Jan
2010
172
1909
159.08
37.42
Feb
2010
170
1931
160.92
39.01
Mar
2010
170
1953
162.75
40.59
Apr
2010
170
1973
164.42
42.03
May
2010
172
1994
166.17
43.54
Jun
2010
174
2015
167.92
40.05
45
July
2010
178
2033
169.42
46.35
August
2010
178
2049
170.75
47.5
Sep
2010
179
2065
172.08
48.65
Oct
2010
181
2081
173.42
49.81
Nov
2010
182
2095
174.58
50.81
Dec
2010
185
2111
175.92
51.97
51
Jan
2011
188
2127
177.25
53.12
Feb
2011
185
2142
178.5
54.2
Mar
2011
185
2157
179.75
55.28
Apr
2011
186
2173
181.08
56.43
May
2011
187
2188
182.33
57.51
Jun
2011
189
2203
183.58
58.59
58
July
2011
193
2218
184.83
59.67
August
2011
194
2234
186.17
60.82
Sep
2011
197
2252
187.67
62.12
Oct
2011
198
2269
189.08
63.34
Nov
2011
199
2286
190.5
64.56
Dec
2011
197
2298
191.5
65.43
65
Jan
2012
198
2308
192.33
66.15
Feb
2012
199
2322
193.5
67.15
Mar
2012
201
2338
194.83
68.31
Apr
2012
205
2357
196.42
69.67
May
2012
206
2376
198
71.04
Jun
2012
208
2395
199.58
72.41
72
Jul
2012
212
2414
201.17
73.78
August
2012
214
2434
202.83
75.22
Sep
2012
215
2452
204.33
76.51
Oct
2012
217
2471
205.92
77.88
Nov
2012
218
2490
207.5
79.25
Dec
2012
219
2512
209.33
80.83
80
Jan
2013
221
2535
211.25
82.49
Feb
2013
223
2559
213.25
84.22
Mar
2013
224
2582
215.17
85.87
Apr
2013
226
2603
216.92
87.38
May
2013
228
2625
218.75
88.97
Jun
2013
231
2648
220.67
90.62
90
Jul
2013
235
2671
222.58
92.28
Aug
2013
237
2694
224.5
93.93
Sep
2013
238
2717
226.42
95.59
Oct
2013
241
2741
228.42
97.32
Nov
2013
243
2766
230.5
99.12
Dec
2013
239
2786
232.17
100.56
100
Jan
2014
237
2802
233.5
101.71
Feb
2014
238
2817
234.75
102.79
Mar
2014
239
2832
236
103.87
Apr
2014
242
2848
237.33
105.02
May
2014
244
2864
238.67
106.17
Jun
2014
246
2879
239.92
107.25
107
Jul
2014
252
2896
241.33
108.47
Aug
2014
253
2912
242.67
109.63
Sep
2014
253
2927
243.92
110.71
Oct
2014
253
2939
244.92
111.57
Nov
2014
253
2949
245.75
112.29
Dec
2014
253
2963
246.92
113.29
113
Jan
2015
254
2980
248.33
114.52
Feb
2015
253
2995
249.58
115.6
Mar
2015
254
3010
250.83
116.68
Apr
2015
256
3024
252
117.69
May
2015
258
3038
253.17
118.69
Jun
2015
261
3053
254.42
119.77
119
Jul
2015
263
3064
255.33
120.56
Aug
2015
264
3075
256.25
121.36
Sep
2015
266
3088
257.33
122.29
Oct
2015
269
3104
258.67
123.44
Nov
2015
270
3121
260.08
124.67
Dec
2015
269
3137
261.42
125.82
125

DA Calculation as per 7th CPC

Month
Year
CPI(IW)
BY2001=100
12 Months
Total
12 Months
Average
Increased Over 261.42
DA %
Jan-16
269 
3152 
262.67 
0.48 
Feb-16
267
3166
263.33
0.92
Mar-16
268
3180
265.00
1.37
Apr-16
271
3195
266.25
1.85
May-16
275
3212
267.67
2.39
Jun-16
277
3228
269.00
2.90
2
Jul-16
280
3245
270.42
3.44
Aug-16
278
3259
271.58
3.89
Sep-16
277
3270
272.05
4.24
Oct-16
278
3279
273.25
4.53
Nov-16
277
3286
273.83
4.75
Dec-16
275
3292
274.33
4.94
4
Jan-17
274
3297
274.75
5.10
Feb-17
274
3304
275.33
5.33
Mar-17
275
3311
275.92
5.55
Apr-17
277
3317
276.41
5.74
May-17
278
3320
276.66
5.84
Jun-17
280
3323
276.91
5.93
5
Jul-17
285
3328
277.33
6.10
Aug-17
Sep-17
Oct-17
Nov-17
Dec-17



Comments

Popular posts from this blog

7th CPC Pay Fixation on Promotion/MACP Calculator with Matrix Table

Revised Pay Scale from 1.7.2017 for Karnataka Govt Employees