DEARNESS ALLOWANCE

DA CALCULATION SHEET

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 6th CPC DA calculations given below...

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...

DA Table from 1.1.2016 as per 7th CPC


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

Month/Year
CPI(IW) BY2001=100
Total of 12 Months
12 Months Average
DA with Decimal
DA %
Jan-16
269
3152
262.67
0.48

Feb-16
267
3166
263.83
0.92

Mar-16
268
3180
265
1.37

Apr-16
271
3195
266.25
1.85

May-16
275
3212
267.67
2.39

Jun-16
277
3228
269
2.9
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.1

Feb-17
274
3304
275.33
5.32

Mar-17
275
3311
275.92
5.55

Apr-17
277
3317
276.42
5.74

May-17
278
3320
276.67
5.83

Jun-17
280
3323
276.91
5.93
5%
Jul-17
285
3328
277.33
6.09

Aug-17
285
3335
277.92
6.31

Sep-17
285
3343
278.58
6.56

Oct-17
287




Nov-17





Dec-17







Dearness Allowance Table from 2008 

Month
Year
Base Year 
Total
Average
App. DA
DA
2001=100
May
2008
139
1613
--
--
--
June
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



(Click to view DA Table form 1.1.2006)


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