.

.

Thursday, 6 October 2016

33 QS Arrears - Sep to Sub Maj (Y Gp) & Hony Lt/Capt



Excel Sheet - Link Here

PCDA Circular-568 - Link Here


SEP (Y GP)
ARRERS CALCULATION : DELINKING QUALIFYING SERVICE 33 YEARS - MINIMUM GUARANTEED PENSION WEF 01.01.2006
01 Jan 06 to 30 Jun 0901 Jul 09 to 23 Sep 201224 Sep 12 to 30 Jun 2014Total Arrear
 1.1.06 to 30.6.14 (4+8+12)
QSMin Pen (Old) Cir 547Min Pen (New)Diff
 (2-1)
ArrearsMin Pen (Old) Cir 430Min Pen (New)Diff
(6-5)
Arrears Min Pen (Old) Cir 501Min Pen (New)Diff
  (10-9)
Arrears
12345678910111213
1538835125124257156.84603512552230103.75102512523914.788175.29
15.539615125116453567.34695512543024798.1519651250078365.38
1640385125108750023.74787512533819492.5529151250069516.2
16.541165125100946434.24879512524614186.8538551250060621
174194512593142844.6497151251548881.18548051250051725.8
17.54271512585439301.150635125623575.54557451250042876.62
184349512577635711.55155512500566951250035711.52
18.544275125698321225247512500576351250032121.96
194504512562128578.45339512500585851250028578.42
19.54582512554324988.95431512500595251250024988.86
204660512546521399.35523512500604751250021399.3


SEP (Y GP)
ARRERS CALCULATION : DELINKING QUALIFYING SERVICE 33 YEARS - MINIMUM GUARANTEED PENSION WEF 01.01.2006
01 Jan 06 to 30 Jun 0901 Jul 09 to 23 Sep 201224 Sep 12 to 30 Jun 2014Total Arrear
 1.1.06 to 30.6.14 (4+8+12)
QSMin Pen (Old) Cir 547Min Pen (New)Diff
 (2-1)
ArrearsMin Pen (Old) Cir 430Min Pen (New)Diff
(6-5)
Arrears Min Pen (Old) Cir 501Min Pen (New)Diff
  (10-9)
Arrears
12345678910111213
1538835125124257156.84603512552230103.75102512523914.788175.29
15.539615125116453567.34695512543024798.1519651250078365.38
1640385125108750023.74787512533819492.5529151250069516.2
16.541165125100946434.24879512524614186.8538551250060621
174194512593142844.6497151251548881.18548051250051725.8
17.54271512585439301.150635125623575.54557451250042876.62
184349512577635711.55155512500566951250035711.52
18.544275125698321225247512500576351250032121.96
194504512562128578.45339512500585851250028578.42
19.54582512554324988.95431512500595251250024988.86
204660512546521399.35523512500604751250021399.3
NK (Y GP)
ARRERS CALCULATION : DELINKING QUALIFYING SERVICE 33 YEARS - MINIMUM GUARANTEED PENSION WEF 01.01.2006
01 Jan 06 to 30 Jun 0901 Jul 09 to 23 Sep 201224 Sep 12 to 30 Jun 2014Total Arrear
 1.1.06 to 30.6.14 (4+8+12)
QSMin Pen (Old) Cir 547Min Pen (New)Diff
 (2-1)
ArrearsMin Pen (Old) Cir 430Min Pen (New)Diff
(6-5)
Arrears Min Pen (Old) Cir 501Min Pen (New)Diff
  (10-9)
Arrears
12345678910111213
153,8835,520163775334.74,6355520885510385,156552036414476140848.97
15.53,9615,520155971745.24,736552078445213.35,259552026110380127338.43
164,0385,520148268201.64,837552068339388.65,36255201586284113873.91
16.54,1165,520140464612.14,938552058233563.95,4655520552187100363.37
174,1945,520132661022.55,038552048227796.95,56855200088819.46
17.54,2715,5201249574795,139552038121972.35,67155200079451.25
184,3505,520117053843.45,240552028016147.65,77455200069991
18.54,4335,520108750023.75,341552017910322.95,87855200060346.67
194,5175,520100346158.15,4415520794555.935,98155200050713.99
19.54,6005,52092042338.45,5425520006,08455200042338.4
204,6845,52083638472.75,6435520006,18755200038472.72
20.54,7685,520752346075,7445520006,29055200034607.04
214,8515,52066930787.45,8445520006,39355200030787.38
21.54,9355,52058526921.75,9455520006,49655200026921.7
225,0195,520501230566,0465520006,59955200023056.02
HAV (Y GP)
ARRERS CALCULATION : DELINKING QUALIFYING SERVICE 33 YEARS - MINIMUM GUARANTEED PENSION WEF 01.01.2006
01 Jan 06 to 30 Jun 0901 Jul 09 to 23 Sep 201224 Sep 12 to 30 Jun 2014Total Arrear
 1.1.06 to 30.6.14 (4+8+12)
QSMin Pen (Old) Cir 547Min Pen (New)Diff
 (2-1)
ArrearsMin Pen (Old) Cir 430Min Pen (New)Diff
(6-5)
Arrears Min Pen (Old) Cir 501Min Pen (New)Diff
  (10-9)
Arrears
12345678910111213
153,8835,820193789140.74,5955,820122570645.85,3015,82051920641180427.12
15.53,9615,820185985551.24,7045,820111664359.75,4165,82040416067165977.98
164,0385,820178282007.64,8145,8201006580165,5315,82028911494151517.19
16.54,1165,820170478418.14,9235,820897517305,6475,8201736880137028.28
174,1945,820162674828.55,0335,82078745386.35,7625,820582307122521.47
17.54,2715,8201549712855,1425,82067839100.35,8775,82000110385.24
184,3505,820147067649.45,2515,82056932814.25,9925,82000100463.63
18.54,4335,820138763829.75,3615,82045926470.56,1085,8200090300.27
194,5175,820130359964.15,4705,82035020184.56,2235,8200080148.56
19.54,6005,820122056144.45,5805,82024013840.86,3385,8200069985.2
204,6845,820113652278.75,6895,8201317554.776,4535,8200059833.49
20.54,7685,8201052484135,7985,820221268.746,5685,8200049681.78
214,8515,82096944593.45,9085,820006,6845,8200044593.38
21.54,9355,82088540727.76,0175,820006,7995,8200040727.7
225,0195,820801368626,1275,820006,9145,8200036862.02
22.55,0275,82079336493.96,2365,820007,0295,8200036493.86
235,1155,82070532444.16,3455,820007,1455,8200032444.1
23.55,2035,82061728394.36,4555,820007,2605,8200028394.34
245,2915,82052924344.66,5645,820007,3755,8200024344.58
24.55,2915,82052924344.66,5645,820007,3755,8200024344.58
255,2915,82052924344.66,5645,820007,3755,8200024344.58
25.55,3805,82044020248.86,6745,820007,3755,8200020248.8
265,4685,820352161996,7835,820007,3755,8200016199.04
NB SUB (Y GP)
ARRERS CALCULATION : DELINKING QUALIFYING SERVICE 33 YEARS - MINIMUM GUARANTEED PENSION WEF 01.01.2006
01 Jan 06 to 30 Jun 0901 Jul 09 to 23 Sep 201224 Sep 12 to 30 Jun 2014Total Arrear
 1.1.06 to 30.6.14 (4+8+12)
QSMin Pen (Old) Cir 547Min Pen (New)Diff
 (2-1)
ArrearsMin Pen (Old) Cir 430Min Pen (New)Diff
(6-5)
Arrears Min Pen (Old) Cir 501Min Pen (New)Diff
  (10-9)
Arrears
12345678910111213
155,0498,33032811509926,4708,33018601072666,4708,330186073972332230.02
15.55,1758,33031551451936,8328,330149886389.77,1518,330117946889278471.59
165,3018,33030291393956,7948,330153688581.17,3258,330100539969267944.55
16.55,4288,33029021335506,9558,330137579296.36,9558,330137554684267530.04
175,5548,33027761277527,1178,330121369953.77,1178,330121348241245946.24
17.55,6808,33026501219537,2798,330105160611.27,2798,330105141798224362.44
185,8068,33025241161547,4418,33088951268.67,4418,33088935356202778.64
18.55,9328,33023981103567,6028,33072841983.87,6028,33072828953181292.28
196,0598,33022711045117,7648,33056632641.27,7648,33056622510159662.46
19.56,1858,330214598712.97,9268,33040423298.77,9268,33040416067138078.66
206,3118,330201992914.48,0888,33024213956.18,0888,3302429624116494.86
20.56,4378,330189387115.98,2498,330814671.278,2498,33081322195008.5
216,5648,330176681271.38,4118,330008,4118,3300081271.32
21.56,6908,330164075472.88,5738,330008,5738,3300075472.8
226,8168,330151469674.38,7358,330009,4188,3300069674.28
22.56,9428,330138863875.88,8968,330008,8968,3300063875.76
237,0688,330126258077.29,0588,330009,0588,3300058077.24
23.57,1958,330113552232.79,2208,330009,2208,3300052232.7
247,3218,330100946434.29,3828,330009,3828,3300046434.18
24.57,4478,33088340635.79,5438,330009,5438,3300040635.66
257,5738,33075734837.19,7058,330009,7058,3300034837.14
25.57,6998,33063129038.69,8678,330009,8678,3300029038.62
267,8268,33050423194.110,0298,3300010,0298,3300023194.08
26.57,9528,33037817395.610,1908,3300010,1908,3300017395.56
278,0788,3302521159710,3508,3300010,3528,3300011597.04
27.58,2048,3301265798.5210,5148,3300010,5148,330005798.52
288,3308,3300010,6758,3300010,6758,330000
SUB (Y GP)
ARRERS CALCULATION : DELINKING QUALIFYING SERVICE 33 YEARS - MINIMUM GUARANTEED PENSION WEF 01.01.2006
01 Jan 06 to 30 Jun 0901 Jul 09 to 23 Sep 201224 Sep 12 to 30 Jun 2014Total Arrear
 1.1.06 to 30.6.14 (4+8+12)
QSMin Pen (Old) Cir 547Min Pen (New)Diff
 (2-1)
ArrearsMin Pen (Old) Cir 430Min Pen (New)Diff
(6-5)
Arrears Min Pen (Old) Cir 501Min Pen (New)Diff
  (10-9)
Arrears
12345678910111213
155,7229,44037181711027,2559,440218512600972559,440218586897384008.76
15.55,8659,44035751645227,4369,440200411557174369,440200479699359791.26
166,0089,44034321579417,6189,440182210507576189,440182272461335476.32
16.56,1519,44032891513607,7999,440164194636.577999,440164165263311258.82
176,2949,44031461447797,9809,440146084198.279809,440146058064287041.32
17.56,4379,44030031381988,1629,440127873702.381629,440127850826262726.38
186,5809,44028601316178,3439,44010976326483439,440109743628238508.88
18.56,7239,44027171250368,5259,44091552768.185259,44091536390214193.94
196,8669,44025741184558,7069,44073442329.887069,44073429191189976.44
19.57,0099,44024311118758,8879,44055331891.588879,44055321993165758.94
207,1529,44022881052949,0699,44037121395.690699,44037114755141444
20.57,2959,440214598712.99,2509,44019010957.392509,4401907556117226.5
217,4389,4402002921329,4319,4409519.0394319,4409357.993009
21.57,5819,440185985551.29,6139,4400096139,4400085551.18
227,7249,440171678970.39,7949,4400097949,4400078970.32
22.57,8679,440157372389.59,9759,4400099759,4400072389.46
238,0109,440143065808.610,1579,44000101579,4400065808.6
23.58,1539,440128759227.710,3389,44000103389,4400059227.74
248,2969,440114452646.910,5209,44000105209,4400052646.88
24.58,4399,44010014606610,7019,44000107019,4400046066.02
258,5829,44085839485.210,8829,44000108829,4400039485.16
25.58,7259,44071532904.311,0649,44000110649,4400032904.3
268,8689,44057226323.411,2459,44000112459,4400026323.44
26.59,0119,44042919742.611,4269,44000112469,4400019742.58
279,1549,44028613161.711,6089,44000116089,4400013161.72
27.59,2979,4401436580.8611,7899,44000117899,440006580.86
289,4409,4400011,9709,44000119709,440000
SUB MAJ (Y GP)
ARRERS CALCULATION : DELINKING QUALIFYING SERVICE 33 YEARS - MINIMUM GUARANTEED PENSION WEF 01.01.2006
01 Jan 06 to 30 Jun 0901 Jul 09 to 23 Sep 201224 Sep 12 to 30 Jun 2014Total Arrear
 1.1.06 to 30.6.14 (4+8+12)
QSMin Pen (Old) Cir 547Min Pen (New)Diff
 (2-1)
ArrearsMin Pen (Old) Cir 430Min Pen (New)Diff
(6-5)
Arrears Min Pen (Old) Cir 501Min Pen (New)Diff
  (10-9)
Arrears
12345678910111213
155,8679,68038131754747,4469,680223412883574469,680223488846393155.22
15.56,0149,68036661687097,6329,680204811810876329,680204881449368266.44
166,1609,68035201619907,8189,680186210738278189,680186274052343423.68
16.56,3079,68033731552258,0049,680167696654.980049,680167666655318534.9
176,4549,68032261484618,1909,680149085928.381909,680149059257293646.12
17.56,6009,68030801417428,3779,68013037514483779,680130351820268705.92
186,7479,68029331349778,5639,680111764417.485639,680111744423243817.14
18.56,8949,68027861282128,7499,68093153690.887499,68093137026218928.36
197,0409,68026401214938,9359,68074542964.289359,68074529629194085.6
19.57,1879,68024931147289,1219,68055932237.591219,68055922231169196.82
207,3349,68023461079639,3079,68037321510.993079,68037314834144308.04
20.57,4809,68022001012449,4939,68018710784.394939,6801877437119465.28
217,6279,680205394479.19,6809,6800096809,6800094479.06
21.57,7749,680190687714.19,8669,6800098669,6800087714.12
227,9209,680176080995.210,0529,68000100529,6800080995.2
22.58,0679,680161374230.310,2389,68000102389,6800074230.26
238,2149,680146667465.310,4249,68000104249,6800067465.32
23.58,3609,680132060746.410,6109,68000106139,6800060746.4
248,5079,680117353981.510,7969,68000107959,6800053981.46
24.58,6549,680102647216.510,9839,68000109839,6800047216.52
258,8009,68088040497.611,1699,68000111699,6800040497.6
25.58,9479,68073333732.711,3559,68000113559,6800033732.66
269,0949,68058626967.711,5419,68000115149,6800026967.72
26.59,2409,68044020248.811,7279,68000117279,6800020248.8
279,3879,68029313483.911,9139,68000119139,6800013483.86
27.59,5349,6801466718.9212,0999,68000120999,680006718.92
289,6809,6800012,2859,68000120999,680000
HONY LT
ARRERS CALCULATION : DELINKING QUALIFYING SERVICE 33 YEARS - MINIMUM GUARANTEED PENSION WEF 01.01.2006
01 Jan 06 to 30 Jun 0901 Jul 09 to 23 Sep 201224 Sep 12 to 30 Jun 2014Total Arrear
 1.1.06 to 30.6.14 (4+8+12)
QSMin Pen (Old) Cir 547Min Pen (New)Diff
 (2-1)
ArrearsMin Pen (Old) Cir 547Min Pen (New)Diff
(6-5)
Arrears Min Pen (Old) Cir 501Min Pen (New)Diff
  (10-9)
Arrears
12345678910111213
159,37315,4656092280354937315,4656092351326937315,46560922E+05873958.32
15.59,60815,4655857269539960815,4655857337773960815,46558572E+05840245.22
169,84215,4655623258770984215,4655623324278984215,46556232E+05806675.58
16.510,07615,46553892480021007615,46553893107841007615,46553892E+05773105.94
1710,31015,46551552372331031015,46551552972891031015,46551552E+05739536.3
17.510,54515,46549202264181054515,46549202837361054515,46549202E+05705823.2
1810,77915,46546862156501077915,46546862702421077915,46546862E+05672253.56
18.511,01315,46544522048811101315,46544522567471101315,46544522E+05638683.92
1911,24815,46542171940661124815,46542172431941124815,46542172E+05604970.82
19.511,48215,46539831832981148215,46539832297001148215,46539832E+05571401.18
2011,71615,46537491725291171615,46537492162051171615,46537491E+05537831.54
20.511,95115,46535141617141195115,46535142026521195115,46535141E+05504118.44
2112,18515,46532801509461218515,46532801891581218515,46532801E+05470548.8
21.512,41915,46530461401771241915,46530461756631241915,46530461E+05436979.16
2212,65415,46528111293621265415,46528111621101265415,46528111E+05403266.06
22.512,88815,46525771185941288815,46525771486161288815,46525771E+05369696.42
2313,12215,46523431078251312215,46523431351211312215,465234393181336126.78
23.513,35715,465210897010.21335715,46521081215681335715,465210883835302413.68
2413,59115,465187486241.51359115,46518741080741359115,465187474529268844.04
24.513,82515,465164075472.81382515,465164094578.81382515,465164065223235274.4
2514,06015,465140564658.11406015,465140581026.41406015,465140555877201561.3
25.514,29415,465117153889.41429415,465117167531.61429415,465117146571167991.66
2614,52815,46593743120.71452815,46593754036.81452815,46593737264134422.02
26.514,76315,465702323061476315,46570240484.31476315,46570227919100708.92
2714,99715,46546821537.41499715,46546826989.61499715,4654681861267139.28
27.515,23115,46523410768.71523115,46523413494.81523115,465234930633569.64
2815,46515,465001546515,465001546515,465000








No comments:

Post a Comment

1396