Spc Arrear Calculator
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Spc Arrear Calculator as PDF for free.
More details
- Words: 658
- Pages: 1
PAY & ARREARS CALCULATOR 1. ENTER ONLY IN YELLOW SHADED COLUMNS 2. DA from 01.07.2006 = 2%
8. Enter your old basic-pay in H-11 to H-43 columns adding annual increment wherever necessary.
3. DA from 01.01.2007 = 6% 4. DA from 01.07.2007 = 9% 6. DA from 01.07.2008 = 16%
10. DA is calculated on TA also in the revised scale.
7. Band Pay = Basic Pay X 1.86
11. Increment = 3 %.
NEW SCALE Month Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07 Mar-07 Apr-07 May-07 Jun-07 Jul-07 Aug-07 Sep-07 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08
HRA Rate= Band Pay 15440 15440 15440 15440 15440 15440 16050 16050 16050 16050 16050 16050 16050 16050 16050 16050 16050 16050 16680 16680 16680 16680 16680 16680 16680 16680 16680 16680 16680 16680 17330 17330 17330
Grade Pay 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800
N E W
T.A. 0 0
800 P A Y
OLD SCALE 10
D.A. H.R.A.
Total
0 0 0 0 0 0 417 417 417 417 417 417 1251 1251 1251 1251 1251 1251 1933 1933 1933 1933 1933 1933 2578 2578 2578 2578 2578 2578 3541 3541 3669
20240 20240 20240 20240 20240 20240 21267 21267 21267 21267 21267 21267 22101 22101 22101 22101 22101 22101 23413 23413 23413 23413 23413 23413 24058 24058 24058 24058 24058 24058 25671 25671 28812
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2213
TOTAL :
746628
Basic Pay
D. P.
8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300
12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 O L D
HRA Rate=
7.5
D.A
H.R.A.
2988 2988 2988 2988 2988 2988 3611 3611 3611 3611 3611 3611 4358 4358 4358 4358 4358 4358 5105 5105 5105 5105 5105 5105 5852 5852 5852 5852 5852 5852 5852 5852 5852
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 934
P A Y
DIFFERENCE
5. DA from 01.01.2008 = 12%
9. On promotion, the formula from the July month ( on B-18 column) may be copied to the promoted month to add increment.
CCA T.A.
Total
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 120
15438 15438 15438 15438 15438 15438 16061 16061 16061 16061 16061 16061 16808 16808 16808 16808 16808 16808 17555 17555 17555 17555 17555 17555 18302 18302 18302 18302 18302 18302 18302 18302 19556
4802 4802 4802 4802 4802 4802 5206 5206 5206 5206 5206 5206 5293 5293 5293 5293 5293 5293 5858 5858 5858 5858 5858 5858 5756 5756 5756 5756 5756 5756 7369 7369 9256
561144
185484
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200
TOTAL :
ARREARS : 185484 40% = ###
J
U
M
31 31 31 31 31 31 32 32 32 32 32 32 31 31 31 31 31 31 33 33 33 33 33 33 31 31 31 31 31 31 40 40 47
8. Enter your old basic-pay in H-11 to H-43 columns adding annual increment wherever necessary.
3. DA from 01.01.2007 = 6% 4. DA from 01.07.2007 = 9% 6. DA from 01.07.2008 = 16%
10. DA is calculated on TA also in the revised scale.
7. Band Pay = Basic Pay X 1.86
11. Increment = 3 %.
NEW SCALE Month Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07 Mar-07 Apr-07 May-07 Jun-07 Jul-07 Aug-07 Sep-07 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08
HRA Rate= Band Pay 15440 15440 15440 15440 15440 15440 16050 16050 16050 16050 16050 16050 16050 16050 16050 16050 16050 16050 16680 16680 16680 16680 16680 16680 16680 16680 16680 16680 16680 16680 17330 17330 17330
Grade Pay 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800 4800
N E W
T.A. 0 0
800 P A Y
OLD SCALE 10
D.A. H.R.A.
Total
0 0 0 0 0 0 417 417 417 417 417 417 1251 1251 1251 1251 1251 1251 1933 1933 1933 1933 1933 1933 2578 2578 2578 2578 2578 2578 3541 3541 3669
20240 20240 20240 20240 20240 20240 21267 21267 21267 21267 21267 21267 22101 22101 22101 22101 22101 22101 23413 23413 23413 23413 23413 23413 24058 24058 24058 24058 24058 24058 25671 25671 28812
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2213
TOTAL :
746628
Basic Pay
D. P.
8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300 8300
12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 12450 O L D
HRA Rate=
7.5
D.A
H.R.A.
2988 2988 2988 2988 2988 2988 3611 3611 3611 3611 3611 3611 4358 4358 4358 4358 4358 4358 5105 5105 5105 5105 5105 5105 5852 5852 5852 5852 5852 5852 5852 5852 5852
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 934
P A Y
DIFFERENCE
5. DA from 01.01.2008 = 12%
9. On promotion, the formula from the July month ( on B-18 column) may be copied to the promoted month to add increment.
CCA T.A.
Total
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 120
15438 15438 15438 15438 15438 15438 16061 16061 16061 16061 16061 16061 16808 16808 16808 16808 16808 16808 17555 17555 17555 17555 17555 17555 18302 18302 18302 18302 18302 18302 18302 18302 19556
4802 4802 4802 4802 4802 4802 5206 5206 5206 5206 5206 5206 5293 5293 5293 5293 5293 5293 5858 5858 5858 5858 5858 5858 5756 5756 5756 5756 5756 5756 7369 7369 9256
561144
185484
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200
TOTAL :
ARREARS : 185484 40% = ###
J
U
M
31 31 31 31 31 31 32 32 32 32 32 32 31 31 31 31 31 31 33 33 33 33 33 33 31 31 31 31 31 31 40 40 47
Related Documents
Spc Arrear Calculator
November 2019 5
Spc Arrear Calculator
October 2019 5
Spc Calculator General
October 2019 5
Tn Pay Comm Arrear Calculator
May 2020 3
Wb Arrear Calculator(ropa 2009)
April 2020 3