Friday, 14 March 2014

Some Figures of the Other Kind

Read somewhere (in chain emails) the bloated figures allegedly sent by Army HQ to MoD as the OROP. Funnily/tragically enough, OROP has been given to General/COAS though Army Cdr/VCOAS and COAS are in the Apex (Fixed) scale!

So here is something to occupy Excel buffs and commentators for the interim. Tables on the lines of Circular 500 are being worked out and will be up as soon as refined and ready.





Random Calculations: Retiring on or after 01.01.2006
Not to be quoted for any purpose – official or otherwise
(Excel work sheet - courtesy Brig (retd) Vijay Raheja, Signals)

Table A – Pension without benefit of Ld AG’s Opinion

Flt Lt & equivalent
Year
Pay in Band
Grade Pay
MSP
Net Pay
Pension
01-Jan-06
18600
6100
6000
30700
15350
01-Jul-06
18980
6100
6000
31080
15540
01-Jul-07
19360
6100
6000
31460
15730
01-Jul-08
20130
6100
6000
32230
16115
01-Jul-09
20920
6100
6000
33020
16510
01-Jul-10
21740
6100
6000
33840
16920
01-Jul-11
22580
6100
6000
34680
17340
01-Jul-12
23450
6100
6000
35550
17775
01-Jul-13
24340
6100
6000
36440
18220
01-Jul-14
25260
6100
6000
37360
18680
Sqn Ldr & equivalent
Year
Pay in Band
Grade Pay
MSP
Net Pay
Pension
01-Jan-06
23810
6600
6000
36410
18205
01-Jul-06
24270
6600
6000
36870
18435
01-Jul-07
24740
6600
6000
37340
18670
01-Jul-08
25690
6600
6000
38290
19145
01-Jul-09
26660
6600
6000
39260
19630
01-Jul-10
27660
6600
6000
40260
20130
01-Jul-11
28690
6600
6000
41290
20645
01-Jul-12
29750
6600
6000
42350
21175
01-Jul-13
30850
6600
6000
43450
21725
01-Jul-14
31980
6600
6000
44580
22290
Wg Cdr & equivalent
Year
Pay in Band
Grade Pay
MSP
Net Pay
Pension
01-Jan-06
28090
8000
6000
42090
21045
01-Jul-06
28640
8000
6000
42640
21320
01-Jul-07
29190
8000
6000
43190
21595
01-Jul-08
30310
8000
6000
44310
22155
01-Jul-09
31460
8000
6000
45460
22730
01-Jul-10
32650
8000
6000
46650
23325
01-Jul-11
33870
8000
6000
47870
23935
01-Jul-12
35130
8000
6000
49130
24565
01-Jul-13
36430
8000
6000
50430
25215
01-Jul-14
37770
8000
6000
51770
25885
Gp Capt & equivalent
Year
Pay in Band
Grade Pay
MSP
Net Pay
Pension
01-Jan-06
40890
8700
6000
55590
27795
01-Jul-06
41640
8700
6000
56340
28170
01-Jul-07
42400
8700
6000
57100
28550
01-Jul-08
43940
8700
6000
58640
29320
01-Jul-09
45520
8700
6000
60220
30110
01-Jul-10
47150
8700
6000
61850
30925
01-Jul-11
48830
8700
6000
63530
31765
01-Jul-12
50560
8700
6000
65260
32630
01-Jul-13
52340
8700
6000
67040
33520
01-Jul-14
54180
8700
6000
68880
34440
Air Cmde & equivalent
Year
Pay in Band
Grade Pay
MSP
Net Pay
Pension
01-Jan-06
43390
8900
6000
58290
29145
01-Jul-06
44180
8900
6000
59080
29540
01-Jul-07
44980
8900
6000
59880
29940
01-Jul-08
46600
8900
6000
61500
30750
01-Jul-09
48270
8900
6000
63170
31585
01-Jul-10
49990
8900
6000
64890
32445
01-Jul-11
51760
8900
6000
66660
33330
01-Jul-12
53580
8900
6000
68480
34240
01-Jul-13
55460
8900
6000
70360
35180
01-Jul-14
57400
8900
6000
72300
36150
AVM & equivalent
Year
Pay in Band
Grade Pay
MSP
Net Pay
Pension
01-Jan-06
47440
10000
6000
63440
31720
01-Jul-06
48310
10000
6000
64310
32155
01-Jul-07
49190
10000
6000
65190
32595
01-Jul-08
50970
10000
6000
66970
33485
01-Jul-09
52800
10000
6000
68800
34400
01-Jul-10
54690
10000
6000
70690
35345
01-Jul-11
56640
10000
6000
72640
36320
01-Jul-12
58640
10000
6000
74640
37320
01-Jul-13
60700
10000
6000
76700
38350
01-Jul-14
62830
10000
6000
78830
39415

Table B - Corrected for Rank Pay inclusion

Flt Lt
Year
Pay in Band
Grade Pay
MSP
Net Pay
Pension
01-Jan-06
19350
6600
6000
31950
15975
01-Jul-06
19740
6600
6000
32340
16170
01-Jul-07
20140
6600
6000
32740
16370
01-Jul-08
20950
6600
6000
33550
16775
01-Jul-09
21780
6600
6000
34380
17190
01-Jul-10
22640
6600
6000
35240
17620
01-Jul-11
23520
6600
6000
36120
18060
01-Jul-12
24430
6600
6000
37030
18515
01-Jul-13
25370
6600
6000
37970
18985
01-Jul-14
26330
6600
6000
38930
19465
Sqn Ldr
Year
Pay in Band
Grade Pay
MSP
Net Pay
Pension
01-Jan-06
26040
7600
6000
39640
19820
01-Jul-06
26550
7600
6000
40150
20075
01-Jul-07
27070
7600
6000
40670
20335
01-Jul-08
28120
7600
6000
41720
20860
01-Jul-09
29200
7600
6000
42800
21400
01-Jul-10
30310
7600
6000
43910
21955
01-Jul-11
31450
7600
6000
45050
22525
01-Jul-12
32630
7600
6000
46230
23115
01-Jul-13
33840
7600
6000
47440
23720
01-Jul-14
35090
7600
6000
48690
24345
Wg Cdr
Year
Pay in Band
Grade Pay
MSP
Net Pay
Pension
01-Jan-06
42120
8700
6000
56820
28410
01-Jul-06
42890
8700
6000
57590
28795
01-Jul-07
43670
8700
6000
58370
29185
01-Jul-08
45250
8700
6000
59950
29975
01-Jul-09
46870
8700
6000
61570
30785
01-Jul-10
48540
8700
6000
63240
31620
01-Jul-11
50260
8700
6000
64960
32480
01-Jul-12
52030
8700
6000
66730
33365
01-Jul-13
53860
8700
6000
68560
34280
01-Jul-14
55740
8700
6000
70440
35220
Gp Capt
Year
Pay in Band
Grade Pay
MSP
Net Pay
Pension
01-Jan-06
46050
8900
6000
60950
30475
01-Jul-06
46880
8900
6000
61780
30890
01-Jul-07
47720
8900
6000
62620
31310
01-Jul-08
49420
8900
6000
64320
32160
01-Jul-09
51170
8900
6000
66070
33035
01-Jul-10
52980
8900
6000
67880
33940
01-Jul-11
54840
8900
6000
69740
34870
01-Jul-12
56760
8900
6000
71660
35830
01-Jul-13
58730
8900
6000
73630
36815
01-Jul-14
60760
8900
6000
75660
37830
Air Cmde
Year
Pay in Band
Grade Pay
MSP
Net Pay
Pension
01-Jan-06
48870
10000
6000
64870
32435
01-Jul-06
49760
10000
6000
65760
32880
01-Jul-07
50660
10000
6000
66660
33330
01-Jul-08
52480
10000
6000
68480
34240
01-Jul-09
54360
10000
6000
70360
35180
01-Jul-10
56300
10000
6000
72300
36150
01-Jul-11
58290
10000
6000
74290
37145
01-Jul-12
60340
10000
6000
76340
38170
01-Jul-13
62460
10000
6000
78460
39230
01-Jul-14
64640
10000
6000
80640
40320
AVM
Year
Pay in Band
Grade Pay
MSP
Net Pay
Pension
01-Jan-06
58370
10000
6000
74370
37185
01-Jul-06
59400
10000
6000
75400
37700
01-Jul-07
60450
10000
6000
76450
38225
01-Jul-08
62570
10000
6000
78570
39285
01-Jul-09
64750
10000
6000
80750
40375
01-Jul-10
67000
10000
6000
83000
41500
01-Jul-11
69310
10000
6000
85310
42655
01-Jul-12
71690
10000
6000
87690
43845
01-Jul-13
74150
10000
6000
90150
45075
01-Jul-14
76680
10000
6000
92680
46340

Table C –  Pension from Tables A & B

Running







Flt Lt
Sqn Ldr
Wg Cdr
Gp Capt
Air
Cmde
AVM
01-Jan-06
15350
18205
21045
27795
29145
31720
01-Jul-06
15540
18435
21320
28170
29540
32155
01-Jul-07
15730
18670
21595
28550
29940
32595
01-Jul-08
16115
19145
22155
29320
30750
33485
01-Jul-09
16510
19630
22730
30110
31585
34400
01-Jul-10
16920
20130
23325
30925
32445
35345
01-Jul-11
17340
20645
23935
31765
33330
36320
01-Jul-12
17775
21175
24565
32630
34240
37320
01-Jul-13
18220
21725
25215
33520
35180
38350
01-Jul-14
18680
22290
25885
34440
36150
39415
Rank Pay Added

Flt Lt
Sqn Ldr
Wg Cdr
Gp Capt
Air Cmde
AVM
01-Jan-06
15975
19820
28410
30475
32435
37185
01-Jul-06
16170
20075
28795
30890
32880
37700
01-Jul-07
16370
20335
29185
31310
33330
38225
01-Jul-08
16775
20860
29975
32160
34240
39285
01-Jul-09
17190
21400
30785
33035
35180
40375
01-Jul-10
17620
21955
31620
33940
36150
41500
01-Jul-11
18060
22525
32480
34870
37145
42655
01-Jul-12
18515
23115
33365
35830
38170
43845
01-Jul-13
18985
23720
34280
36815
39230
45075
01-Jul-14
19465
24345
35220
37830
40320
46340








No comments:

Post a Comment