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: 659
- Pages: 1
PAY & ARREARS CALCULATOR [GENERAL] 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 Grade Pay Pay 0 2400 0 2400 0 2400 0 2400 0 2400 0 2400 0 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 8050 2400 8050 2400 8050 2400 N E W
T.A. 0 0
600 P A Y
OLD SCALE 20
D.A. H.R.A.
Total
0 0 0 0 0 0 48 197 197 197 197 197 590 590 590 590 590 590 913 913 913 913 913 913 1217 1217 1217 1217 1217 1217 1672 1672 1768
2400 2400 2400 2400 2400 2400 2448 10037 10037 10037 10037 10037 10430 10430 10430 10430 10430 10430 11053 11053 11053 11053 11053 11053 11357 11357 11357 11357 11357 11357 12122 12122 14908
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 2090
TOTAL :
303225
Basic Pay
D. P.
0 0 0 0 0 0 0 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4100 4100 4100 4100 4100 4100 4100 4100 4100 4100 4100 4100 4200 4200 4200
0 0 0 0 0 0 0 6000 6000 6000 6000 6000 6000 6000 6000 6000 6000 6000 6150 6150 6150 6150 6150 6150 6150 6150 6150 6150 6150 6150 6300 6300 6300 O L D
HRA Rate=
15
D.A
H.R.A.
0 0 0 0 0 0 0 1740 1740 1740 1740 1740 2100 2100 2100 2100 2100 2100 2522 2522 2522 2522 2522 2522 2891 2891 2891 2891 2891 2891 2961 2961 2961
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 945
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 240
0 0 0 0 0 0 0 7740 7740 7740 7740 7740 8100 8100 8100 8100 8100 8100 8672 8672 8672 8672 8672 8672 9041 9041 9041 9041 9041 9041 9261 9261 10546
2400 2400 2400 2400 2400 2400 2448 2297 2297 2297 2297 2297 2330 2330 2330 2330 2330 2330 2381 2381 2381 2381 2381 2381 2316 2316 2316 2316 2316 2316 2861 2861 4362
222646
80579
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 100
TOTAL :
ARREARS : 80579 40% = ###
J
U
M
### ### ### ### ### ### ### 30 30 30 30 30 29 29 29 29 29 29 27 27 27 27 27 27 26 26 26 26 26 26 31 31 41
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 Grade Pay Pay 0 2400 0 2400 0 2400 0 2400 0 2400 0 2400 0 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7440 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 7740 2400 8050 2400 8050 2400 8050 2400 N E W
T.A. 0 0
600 P A Y
OLD SCALE 20
D.A. H.R.A.
Total
0 0 0 0 0 0 48 197 197 197 197 197 590 590 590 590 590 590 913 913 913 913 913 913 1217 1217 1217 1217 1217 1217 1672 1672 1768
2400 2400 2400 2400 2400 2400 2448 10037 10037 10037 10037 10037 10430 10430 10430 10430 10430 10430 11053 11053 11053 11053 11053 11053 11357 11357 11357 11357 11357 11357 12122 12122 14908
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 2090
TOTAL :
303225
Basic Pay
D. P.
0 0 0 0 0 0 0 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4100 4100 4100 4100 4100 4100 4100 4100 4100 4100 4100 4100 4200 4200 4200
0 0 0 0 0 0 0 6000 6000 6000 6000 6000 6000 6000 6000 6000 6000 6000 6150 6150 6150 6150 6150 6150 6150 6150 6150 6150 6150 6150 6300 6300 6300 O L D
HRA Rate=
15
D.A
H.R.A.
0 0 0 0 0 0 0 1740 1740 1740 1740 1740 2100 2100 2100 2100 2100 2100 2522 2522 2522 2522 2522 2522 2891 2891 2891 2891 2891 2891 2961 2961 2961
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 945
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 240
0 0 0 0 0 0 0 7740 7740 7740 7740 7740 8100 8100 8100 8100 8100 8100 8672 8672 8672 8672 8672 8672 9041 9041 9041 9041 9041 9041 9261 9261 10546
2400 2400 2400 2400 2400 2400 2448 2297 2297 2297 2297 2297 2330 2330 2330 2330 2330 2330 2381 2381 2381 2381 2381 2381 2316 2316 2316 2316 2316 2316 2861 2861 4362
222646
80579
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 100
TOTAL :
ARREARS : 80579 40% = ###
J
U
M
### ### ### ### ### ### ### 30 30 30 30 30 29 29 29 29 29 29 27 27 27 27 27 27 26 26 26 26 26 26 31 31 41
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