FULLY AUTOMATIC & ACCURATE CALCULATOR FOR MAHARASHTRA'S AIDED PRIMARY ,SECONDARY & HIGHER SECONDARY SCHOOLS STAFF WHOSE SCALE OF PAY IS NOT CHANGED AFTER 01 -01-2006. INSTRUCTIONS FOR USE 1. THIS IS SAMPLE PROTECTED FILE. 2. IT IS AVAILABLE AT CHEAPEST RATE OTHER THAN JALGAON DISTRICT. 3. ENTER IN "DATA ENTERY" SHEET i SCHOOL / COLLEGE NAME ii NAME OF EMPLOYEE iii DESIGNATION OF POST iv SCALE OF PAY v BASIC PAY AS ON 01-01-2006 vi MONTH OF INCREMENT vii RATE OF INCREMENT viii RATE OF HRA ix PF DETAILS & GET FIXATION CHART & CALCULATION OF INDIVIDUAL ARREARS IN ATTRACTIVE FORMAT ( WHICH CAN SUBMIT INTO PAY UNIT )
IF YOU ARE INTERESTED CONTACT - I. S. KHANDELWAL. MOB. 9403567443
ENTER SCHO
NAME OF SCHOOL/COLLEGE XYZ
ENTER NAM
NAME OF EMPLOYEE
ABC
DESIGNATION OF THE POST SCALE OF THE POST ( IN CASE OF NON TEACHING BASIC SCALE OF POST )
ASSISTANT TEACHER
VACATION
SELECT SC CASE OF N JUNIOR CLE 01-2006 TH
5500-175-9000
ENTER BASI
BASIC PAY AS ON 01-01-2006 6725 IF TBP POSSIBILITY OF PROMOTION SCALE OF PAY ADMISSIBLE UNDER TBP
SELECT DES DROPDOWN
Enter data o (POSSIBILIT got KALBAD 2006
Not applicable
Enter date o ISOLATED P 01-01-2006
IF TBP FOR ISOLATED POST OF PROMOTION SCALE OF Not applicable PAY ADMISSIBLE UNDER TBP
SELECT APP DESIGNATIO OF SECOND COLLEGE AL
IF DESIGNATION OF POST IS SUPERVISOR, HM OF JR. COLLEGE ADMISSIBLE PAY BAND WITH GRADE PAY
ENTER MONT FORMAT E.G
Month of Increment ( digit ) - 8 Month of Increment ( words ) - Aug Month and year of first increment Aug-06 -
Enter rate o
175
Rate of increment
Enter Rate o
7.5
Rate of HRA Rate of TA
Rate of special pay if any GPF CONTRIBUTED FROM from
Jan-06
500
from
Mar-06
500
from
Mar-07
500
from
Mar-08
800
from
Mar-09
800
ADVANCE -
HEAD OF SCHOOL-
ENTER CONTRIBUTION OF P.F.
from from GPF A/C NO
ENTER P.F. A/C NO.
21459
ENTER MONTH & YEAR
HEAD MISTRESS
ENTER ONLY WHEN AD COMMISION IS TAKEN BASIC OF OCTOMBER
SELECT SIGNATORY AUTHORITY AUTHORITY DOESN’T IN LIST KE
ENTER MONTH & YEAR
ENTER SCHOOL/COLLEGE NAME ENTER NAME OF EMPLOYEE SELECT DESIGNATION OF POST FROM DROPDOWN LIST SELECT SCALE OF POST FROM DROPDOWN LIST ( IN CASE OF NON TEACHING BASIC SACLE OF POST E.G. JUNIOR CLERK GOT KALBADHHA PROMOTION BEFORE 0101-2006 THEN SELECT SCALE 3050-75-3950-80-4900 ENTER BASIC PAY AS ON 01-012006
Enter data only in case of non teaching post (POSSIBILITY OF PROMOTIONABLE POST)who got KALBADHHA PROMOTION BEFORE 01-012006 Enter date only in case of Non teaching post ( ISOLATED POST ) GOT PROMOTION BEFORE 01-01-2006 SELECT APPROPRIATE PAY BAND ONLY WHEN DESIGNATION OF POST IS SYPERVISIOR,HM, OF SECONDARY SCHOOL WHERE IS JUNIOR COLLEGE ALSO OTHERWISE KEEP BLANK
ENTER MONTH OF INCREMENT IN DIGIT FORMAT E.G. FOR MAY ENTER ONLY 5
Enter rate of increment Enter Rate of
ENTER ONLY WHEN ADVANCE AGAINST OF PAY COMMISION IS TAKEN DIFFERENT THAN TWO MONTH BASIC OF OCTOMBER OTHERWISE KEEP BLANK
T SIGNATORY AUTHORITY FROM DROP DOWN LIST IF ANY ORITY DOESN’T IN LIST KEEP BLANK
PAGE NO.1 OF 2
STATEMENT SHOWING ARREARS FROM 01 ST JANUARY 2006 TO 31 ST MARCH 2009 AS PER SIXTH PAY COMMISSION XYZ ABC
Designation -
ASSISTANT TEACHER
Month of increment
Basic Pay as on 01 st Jan 2006
IN CASE OF WITHOUT PAY Month of increment LEAVE Rate of increment CALCULATE MANUALLY AND ENTER INTO APPROPRIATE Rate of H.R.A. Transport Allowance MONTH
6725 Aug
Aug-06
Basic Pay before increment
Jan-06
6725
Aug-06
6725 6900 7075 7250
175
Aug-07
7.5
Aug-08
75
Aug-09
+ + + +
175 175 175 175
Total Revised Pay Band as on Basic Pay 01st January 2006 after increment
Details of Pay after increments as per SIXTH Pay
Date of increment
12510
6900 Grade Pay as on 01-01-2006 7075 7250 New Rate of H.R.A. 7425 New Transport Allowance -
4300
Pay in Pay Band
Jan-06
12510
Jul-06
13020 13540 14080 14640
Jul-07 7.5
Jul-08
75
Jul-09
Grade Pay
Total Pay
4300
+ + + +
4300 4300 4300 4300
17840 18380 18940
DIFFERENCE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22 23
24
25
1
Jan-06
12510
4300
0
757
75
17642
1009
200
6725
3363
2118
757
75
0
13038
500
200
6722
-2118
0
0
0
4604
2
Feb-06
12510
4300
0
757
75
17642
1009
300
6725
3363
2118
757
75
0
13038
500
300
6722
-2118
0
0
0
4604
3
Mar-06
12510
4300
0
757
75
17642
1009
200
6725
3363
2118
757
75
0
13038
500
200
6722
-2118
0
0
0
4604
4
Apr-06
12510
4300
0
757
75
17642
1009
200
6725
3363
2118
757
75
0
13038
500
200
6722
-2118
0
0
0
4604
5
May-06
12510
4300
0
757
0
17567
1009
200
6725
3363
2421
757
0
0
13266
500
200
6722
-2421
0
0
0
4301
6
Jun-06
12510
4300
0
757
75
17642
1009
200
6725
3363
2421
757
75
0
13341
500
200
6722
-2421
0
0
0
4301
7
Jul-06
13020
4300
346
757
75
18498
1039
200
6725
3363
2421
757
75
0
13341
500
200
7232
-2075
0
0
0
5157
8
Aug-06
13020
4300
346
776
75
18517
1039
200
6900
3450
2484
776
75
0
13685
500
200
6970
-2138
0
0
0
4832
9
Sep-06
13020
4300
346
776
75
18517
1039
200
6900
3450
3002
776
75
0
14203
500
200
6970
-2656
0
0
0
4314
10
Oct-06
13020
4300
346
776
75
18517
1039
200
6900
3450
3002
776
75
0
14203
500
200
6970
-2656
0
0
0
4314
11 Nov-06
13020
4300
346
776
75
18517
1039
200
6900
3450
3002
776
75
0
14203
500
200
6970
-2656
0
0
0
4314
12 Dec-06
13020
4300
346
776
75
18517
1039
200
6900
3450
3002
776
75
0
14203
500
200
6970
-2656
0
0
0
4314
13
Jan-07
13020
4300
1039
776
75
19210
1039
200
6900
3450
3002
776
75
0
14203
500
200
6970
-1963
0
0
0
5007
14
Feb-07
13020
4300
1039
776
75
19210
1039
300
6900
3450
3002
776
75
0
14203
500
300
6970
-1963
0
0
0
5007
15
Mar-07
13020
4300
1039
776
75
19210
1039
200
6900
3450
3002
776
75
0
14203
500
200
6970
-1963
0
0
0
5007
16
Apr-07
13020
4300
1039
776
75
19210
1039
200
6900
3450
3623
776
75
0
14824
500
200
6970
-2584
0
0
0
4386
17 May-07
13020
4300
1039
776
0
19135
1039
200
6900
3450
3623
776
0
0
14749
500
200
6970
-2584
0
0
0
4386
18
Jun-07
13020
4300
1039
776
75
19210
1039
200
6900
3450
3623
776
75
0
14824
500
200
6970
-2584
0
0
0
4386
19
Jul-07
13540
4300
1606
776
75
20297
1070
200
6900
3450
4244
776
75
0
15445
500
200
7490
-2638
0
0
0
4852
20 Aug-07
13540
4300
1606
796
75
20317
1070
200
7075
3538
4351
796
75
0
15835
500
200
7227
-2745
0
0
0
4482
21 Sep-07
13540
4300
1606
796
75
20317
1070
200
7075
3538
4351
796
75
0
15835
500
200
7227
-2745
0
0
0
4482
22
Oct-07
13540
4300
1606
796
75
20317
1070
200
7075
3538
4351
796
75
0
15835
500
200
7227
-2745
0
0
0
4482
CF
285460
94600
14734
16999
1500
413293
22802
4600
151100
75555
67399
16999
1500
0
312553
11000
4600
153405
-52665
0
0
0
100740
Month
Pay in GRADE Pay Band PAY
D.A
H.R.A
T.A
To be Total contribute Amount (3 minimum to 7) P.F (6%)
P.T.
Pay
D.P
D.A
H.R.A
T.A
Total Amount Contribute d P.F (11 to 16)
P.T.
Pay
D.A.
H.R.A
Special Pay
DRAWN
17320
T.A
Sr.No
Pay Band PB-2, 930034800, Grade Pay -4300
Pay in Pay Band as on 01 st January 2006 6725
DUE
Manual Manual Pay Grade Pay
21459
MPF A/C No. -
Details of fixation as per SIXTH Pay commission Increment Amount
Details as per V th (OLD) pay commission 5500-175-9000
Scale of Pay -
Special Pay
Name of School /College Name of employee -
Total Amount (19 to 24)
PAGE NO. 2 OF 2 ABC
XYZ
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22 23
24
25
BF
285460
94600
14734
16999
1500
413293
22802
4600
151100
75555
67399
16999
1500
0
312553
11000
4600
153405
-52665
0
0
0
100740
23 Nov-07
13540
4300
1606
796
75
20317
1070
200
7075
3538
4351
796
75
0
15835
500
200
7227
-2745
0
0
0
4482
24 Dec-07
13540
4300
1606
796
75
20317
1070
200
7075
3538
4351
796
75
0
15835
500
200
7227
-2745
0
0
0
4482
25
Jan-08
13540
4300
2141
796
75
20852
1070
200
7075
3538
4988
796
75
0
16472
500
200
7227
-2847
0
0
0
4380
26
Feb-08
13540
4300
2141
796
75
20852
1070
300
7075
3538
4988
796
75
0
16472
500
300
7227
-2847
0
0
0
4380
27
Mar-08
13540
4300
2141
796
75
20852
1070
200
7075
3538
4988
796
75
0
16472
800
200
7227
-2847
0
0
0
4380
28
Apr-08
13540
4300
2141
796
75
20852
1070
200
7075
3538
4988
796
75
0
16472
800
200
7227
-2847
0
0
0
4380
29 May-08
13540
4300
2141
796
0
20777
1070
200
7075
3538
4988
796
0
0
16397
800
200
7227
-2847
0
0
0
4380
30
Jun-08
13540
4300
2141
796
75
20852
1070
200
7075
3538
4988
796
75
0
16472
800
200
7227
-2847
0
0
0
4380
31
Jul-08
14080
4300
2941
796
75
22192
1103
200
7075
3538
5731
796
75
0
17215
800
200
7767
-2790
0
0
0
4977
32 Aug-08
14080
4300
2941
816
75
22212
1103
200
7250
3625
5873
816
75
0
17639
800
200
7505
-2932
0
0
0
4573
33 Sep-08
14080
4300
2941
816
75
22212
1103
200
7250
3625
5873
816
75
0
17639
800
200
7505
-2932
0
0
0
4573
34
Oct-08
14080
4300
2941
816
75
22212
1103
200
7250
3625
5873
816
75
0
17639
800
200
7505
-2932
0
0
0
4573
35 Nov-08
14080
4300
2941
816
75
22212
1103
200
7250
3625
5873
816
75
0
17639
800
200
7505
-2932
0
0
0
4573
36 Dec-08
14080
4300
2941
816
75
22212
1103
200
7250
3625
5873
816
75
0
17639
800
200
7505
-2932
0
0
0
4573
37
Jan-09
14080
4300
4044
816
75
23315
1103
200
7250
3625
5873
816
75
0
17639
800
200
7505
-1829
0
0
0
5676
38
Feb-09
14080
4300
4044
816
75
23315
1103
300
7250
3625
5873
816
75
0
17639
800
300
7505
-1829
0
0
0
5676
39
Mar-09
14080
4300
4044
816 30691
75
23315
1103
200
7250
3625
5873
75
0
17639
800
200
7505
-1829
0
0
0
5676
2700
782161
41289
8200
2700
0
601307
23400
8200
279028
-98174
0
0
0
180854
1
Month
Pay in GRADE Pay Band PAY
2
TOTAL
D.A
520500 167700 60570
H.R.A
T.A
To be Total contribute Amount (3 minimum to 7) P.F (6%)
Financial Year Wise
01-01-2006 to 31-12-2006 54263
Jan -2006 to Feb - 2006
9208
01-01-2007 to 31-12-2007 55441
Mar -2006 to Feb - 2007
55069
01-01-2008 to 31-12-2008 54122
Mar -2007 to Feb - 2008
54187
01-01-2009 to 31-03-2009 17028
Mar -2008 to Feb - 2009
56714
Total
###
Mar-09 Total
Pay
D.P
D.A
H.R.A
816 272775 136397 158744 30691
T.A
Total Amount Contribute d P.F (11 to 16)
P.T.
Total Arrears LESS two months Basic Pay of October 2008 ( Advance )
Arrears divided By Financial / Calendar Year Calendar Year Wise
P.T.
5676 ###
LESS DIFFERENCE of PF as per rule 15.1(A) of Maharashtra Civil Services (Revised Pay)Rules,2009 Instructions regarding Pay fixation at page No.9 LESS DIFFERENCE of PT as per rule 15.1(A) of Maharashtra Civil Services (Revised Pay)Rules,2009 Instructions regarding Pay fixation at page No.9
NET AMOUNT OF ARREARS TO BE TRANSFER IN PROVIDENT FUND A/C
Pay
D.A.
H.R.A
Special Pay
DIFFERENCE
T.A
DRAWN Special Pay
DUE Sr.No
Manual Manual Pay Grade Pay
ASSISTANT TEACHER
180854 14500
Total Amount (19 to 24)
1 st Instalment 2009 2 nd Instalment 2010 3 rd Instalment 2011
17889
4 th Instalment 2012 5 th Instalment 2013
0 148465 HEAD MISTRESS XYZ
STATEMENT SHOWING ARREARS FROM 01 ST APRIL 2009 TO 31 ST JULY 2009 AS PER SIXTH PAY COMMISSION ( WITH OLD HRA, TA RATES, & D.A. AT 22%) XYZ ASSISTANT TEACHER
D.A
H.R.A
T.A
Total Amount (3 to 7)
P.T.
Pay
D.P
D.A
H.R.A
DIFFERENCE
T.A
Total Amount (11 to 16)
P.T.
Pay
D.A.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
1 2 3 4
Apr-09 May-09 Jun-09 Jul-09
14080 14080 14080 14640 56880
4300 4300 4300 4300 17200
4044 4044 4044 4167 16299
816 816 816 816 3264
75 0 75 75 225
23315 23240 23315 23998 93868
1103 1103 1103 1136 4445
200 200 200 200 800
7250 7250 7250 7250 29000
3625 3625 3625 3625 14500
5873 5873 5873 5873 23492
816 816 816 816 3264
75 0 75 75 225
0 0 0 0 0
17639 17564 17639 17639 70481
800 800 800 800 3200
200 200 200 200 800
7505 7505 7505 8065 30580
-1829 -1829 -1829 -1706 -7193
Special Pay
Pay in GRADE Pay Band PAY
To be contribute minimum P.F (6%)
Sr.No
Month
21459
MPF A/C No. -
DRAWN
T.A
Designation -
22 23
24
25
0 0 0 0 0
0 0 0 0 0
5676 5676 5676 6359 23387
H.R.A
ABC DUE
Contributed P.F
Name of employee -
Special Pay
Name of School /College -
0 0 0 0 0
HEAD MISTRESS XYZ
Total Amount (19 to 24)
ARCH 2009 AS PER SIXTH PAY COMMISSION VACATION
PF CONTRIBUTED FROM From
Jan-06
500
Jan
From
Mar-06
500
Feb
From
Mar-07
500
From
Mar-08
From
Mar-09
800 800
From From
IN CASE OF WITHOUT PAY LEAVE CALCULATE MANUALLY AND ENTER INTO APPROPRIATE MONTH
P.T.
Minimum 6% PF difference
DIFFERENCE Net Arrears
26
27
28
0
509
4095
0
509
4095
0
509
4095
0
509
4095
0
509
3792
0
509
3792
0
539
4618
0
539
4293
0
539
3775
0
539
3775
0
539
3775
0
539
3775
0
539
4468
0
539
4468
0
539
4468
0
539
3847
0
539
3847
0
539
3847
0
570
4282
0
570
3912
0
570
3912
0
570
3912
0
11802
88938
Manual Pay
MANU MANU AL AL T.A. P.T.
Mar Apr May Jun Jul Aug Sep
Oct Nov Dec
XYZ
27
28
0
11802
88938
0
570
3912
0
570
3912
0
570
3810
0
570
3810
0
270
4110
0
270
4110
0
270
4110
0
270
4110
0
303
4674
0
303
4270
0
303
4270
0
303
4270
0
303
4270
0
303
4270
0
303
5373
0
303
5373
0
303
5373
1 st Instalment 2009 2 nd Instalment 2010 3 rd Instalment 2011 4 th Instalment 2012 5 th Instalment 2013
XYZ
Net Arrears
26
0
HEAD MISTRESS
Minimum 6% PF difference
P.T.
DIFFERENCE
17889 162965
29693 29693 29693 29693 29693
Manual Pay
MANU MANU AL AL T.A. P.T.
HEAD MISTRESS XYZ
Minimum 6% PF difference
P.T.
H PAY COMMISSION ( WITH OLD HRA, TA RATES, & D.A. AT 22%)
ARREARS EXPECTED TO BE RECEIVE CASH
26
27
28
0 0 0 0 0
303 303 303 336 1245
5373 5373 5373 6023 22142
XYZ Provisional Pay Fixation and Arrears FROM 01 ST JANUARY 2006 TO 30 TH MARCH 2009 As per Grade Pay in Hakim Committee Report and G.R. Dated 27 th February 2009. Name of Employee ABC Designation Scale/Basic Pay as on 1-1-06
ASSISTANT TEACHER
5500-175-9000 New Grade Pay Old HRA rate of your city Month in which increment drawn Rate of existing Increment
6725 4300 7.5 8 175
Old Transport Allowance
75
IF PROMOTION
D.A. ( NEW ) Jan 06 - O% Jul 06 - 2% Jan 07 - 6% Jul 07 - 9% Jan 08 - 12% Jul 08 - 16% Jan 09 - 16%
%
DUE Month
BAND PAY
Jan-06 Feb-06 TOTAL FY 05-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 TOTAL FY 06-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 TOTAL FY 07-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08 Oct-08 Nov-08 Dec-08 Jan-09 Feb-09 TOTAL FY 08-09 Mar-09 GRAND TOTAL
GRADE PAY
BP+GP
D.A. (OLD) Jan 06 - 21% May 06 - 24% ### Sept 06 - 29% ### April 07 - 35% ### Jul 07 - 41% Jan 08 - 47% Jul 08 - 54%
DRAWN D.A.
TOTAL
Basic
D.P.
D.A.
Total
Arrears
12510 12510
4300 4300
16810 16810
0 0
16810 16810
6725 6725
3363 3363
2118 2118
12206 12206
4604 ### 4604 ###
25020
8600
33620
0
33620
13450
6726
4236
24412
9208
12510 12510 12510 12510 13020 13020 13020 13020 13020 13020 13020 13020
4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300
16810 16810 16810 16810 17320 17320 17320 17320 17320 17320 17320 17320
0 0 0 0 346 346 346 346 346 346 1039 1039
16810 16810 16810 16810 17666 17666 17666 17666 17666 17666 18359 18359
6725 6725 6725 6725 6725 6900 6900 6900 6900 6900 6900 6900
3363 3363 3363 3363 3363 3450 3450 3450 3450 3450 3450 3450
2118 2118 2421 2421 2421 2484 3002 3002 3002 3002 3002 3002
12206 12206 12509 12509 12509 12834 13352 13352 13352 13352 13352 13352
4604 ### 4604 ### 4301 ### 4301 ### 5157 ### 4832 ### 4314 ### 4314 ### 4314 ### 4314 ### 5007 ### 5007 ###
51600 205800
154200
4154
209954
81925
40965
31995
154885
17320 17320 17320 17320 17840 17840 17840 17840 17840 17840 17840 17840
1039 1039 1039 1039 1606 1606 1606 1606 1606 1606 2141 2141
18359 18359 18359 18359 19446 19446 19446 19446 19446 19446 19981 19981
6900 6900 6900 6900 6900 7075 7075 7075 7075 7075 7075 7075
3450 3450 3450 3450 3450 3538 3538 3538 3538 3538 3538 3538
3002 3623 3623 3623 4244 4351 4351 4351 4351 4351 4988 4988
13352 13973 13973 13973 14594 14964 14964 14964 14964 14964 15601 15601
51600 212000
18074
230074
84025
42016
49846
175887
17840 17840 17840 17840 18380 18380 18380 18380 18380 18380 18380 18380
2141 2141 2141 2141 2941 2941 2941 2941 2941 2941 4044 4044
19981 19981 19981 19981 21321 21321 21321 21321 21321 21321 22424 22424
7075 7075 7075 7075 7075 7250 7250 7250 7250 7250 7250 7250
3538 3538 3538 3538 3538 3625 3625 3625 3625 3625 3625 3625
4988 4988 4988 4988 5731 5873 5873 5873 5873 5873 5873 5873
15601 15601 15601 15601 16344 16748 16748 16748 16748 16748 16748 16748
51600 218400
34298
252698
86125
43065
66794
195984
18380
4044
22424
7250
3625
5873
16748
520500 167700 688200
60570
748770 272775
136397
158744
567916
180854
LESS ADVANCE OF TWO MONTHS BASIC PAY OF OCT.2008 NET ARREARS 1 ST INSTALLMENT 2 ND INSTALLMENT 3 RD INSTALLMENT 4 TH INSTALLMENT 5 TH INSTALLMENT
14500 166354 33271 33271 33271 33271 33270
13020 13020 13020 13020 13540 13540 13540 13540 13540 13540 13540 13540
160400 13540 13540 13540 13540 14080 14080 14080 14080 14080 14080 14080 14080
166800 14080
4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300 4300
55069 5007 ### 4386 ### 4386 ### 4386 ### 4852 ### 4482 ### 4482 ### 4482 ### 4482 ### 4482 ### 4380 ### 4380 ###
54187 4380 ### 4380 ### 4380 ### 4380 ### 4977 ### 4573 ### 4573 ### 4573 ### 4573 ### 4573 ### 5676 ### 5676 ###
56714 5676 ###
XYZ STATEMENT OF ARREARS FROM 01 ST APRIL 2009 TO 31 ST JULY 2009
Name of Employee Designation -
ABC ASSISTANT TEACHER DUE
14080 14080 14080 14640 56880
4300 4300 4300 4300 17200
BP+GP
18380 18380 18380 18940 74080
DRAWN D.A.
2941 4044 4044 4167 15196
TOTAL
21321 22424 22424 23107 89276
Basic
7250 7250 7250 7250 29000
D.P.
D.A.
3625 3625 3625 3625 14500
5873 5873 5873 5873 23492
Total
D.A.
14640
4300
18940
4167
H.R.A.
T.A.
TOATAL
PAY+G.P.
TOTAL SALARY IN MONTH OF AUGUST 2009 WITH OLD HRA AND TA RATES
GRADE PAY
Apr-09 May-09 Jun-09 Jul-09 Total
BAND PAY
GRADE PAY
PAY IN PAYBAND
Month
835
75
24017
16748 16748 16748 16748 66992
Arrears
4573 5676 5676 6359 22284
Page 20 of 27
XYZ
( yäoàáÊm 1 2 3 4 5
6
7
8
9 10 11 12 13 14
15
16
kàç»þqØà - ¥§ý ( qÑà qáÊ°²çþÀ 3 ) wçmÂà ) âÂàut 2009 ¡Âwuç âÀÂààÞ§ý 1 kàÂàçwàÊã 2006 Êàçkã wçmÂà âÂà Îàày§ýLu §ýtêjà ABC uàjç Âààw âÀÂààÞ§ý 01-01-2006 Êàçkã wçmÂà ASSISTANT TEACHER âÂàOÎjmã §ýÊàwuà°uà qÀàjç qÀÂààt PERMANENT Àkàê ( §ýàut/ÐnàÂààqÂÂà ) qÀày vàªàå ¡yvçvã 5500-175-9000 âwùtàÂà wçmÂàóç½àã qÀàçÂÂàmãjã yÞoã £qvÆo ¡yvçÌuà qÀàwÊ âÀ. 01-01-2006 qåwJ §ýàvr÷ Not applicable qÀàçÂÂàmã uàçkÂàà/¡àÎwàâym Zàªàmã uàçkÂàçjà vàs âtÓàvçvà ¡àÑç.mnàâq, âÀ. 01-01-2006 qåwJ Zà¾uÕà qÀàçÂÂàmãjã yÞoã £qvÆoqÀàçÂÂàmã ÂàyvçÌuà làvã ÂàyÌuày, qÀàçÂÂàmã qÀàwÊ â§Þýwà§ýàvr÷ ¥§ýà§ýL qÀàwÊ âÀ.01-01- Not applicable uàçkÂàà/¡àÎwàâym Zàªàmã uàçkÂàçhàvã 2006 qåwJ §ýàvr÷ qÀàçÂÂàmã âtÓàvçvã wçmÂàóç½àã uàçkÂàà/¡àÎwàâym Zàªàmã uàçkÂàçjà âÀÂààÞ§ý 01-01-2006 Êàçkã ¡yvçvã vàs âtÓàvà ¡yÌuày, §ýàvr÷ qÀàçÂÂàmã âwùtàÂà âwÙàvÆoã tåÓ wçmÂà (§äÞýºþãm uàçkÂàà/¡àÎwàâym Zàªàmã uàçkÂàçhàvã 6725 (¡) wçmÂàwà¼þãyÑ, âtÓàvçvã wçmÂàóç½àã¡yÌuày) 3363 (r) tÑàªàà¢ê wçmÂà (§ý) tÑàªàà¢ê sÙàà (21%) ¥§åý½à âwùtàÂà âwÙàvÆoã (¡ mç (»þ) §ýý) ¡.§íý. 4 °uà ytàçÊ ÀÎàêâwvçÌuà âwùtàÂà wçmÂàóç½àã°uà ¡ÂàäxÞªààÂàç yäoàáÊm wçmÂà rÝ»þ ¡àâ½à ªàíç»þ wçmÂà ( ¥j¥kã +wÀÎàêâwvçÌuà ¾uàqçÕàà ¡âo§ý ¡.§íîý. 5 °uà ytàçÊ âwùtàÂà wçmÂàóç½àãyàºþã uàçªu wçmÂàóç½àã wçmÂàóç½àã °uà ¡ÂàäxÞªààÂàç ÀÎàêwàwã yäoàáÊm rÝ»þÂàtäÀ ¡àâ½à ªàíç»þ wÊãv ¡.§íý.wçmÂà 7 (¡) tÁuç wçmÂàà¡°uà wçmÂà ¡àoàÊàwÊ kàç»þqØà mãÂà toãv âwwʽàqØààÂàäyàÊ yäoàáÊm wçmÂà t.Âàà.yç.(yä.wç.) âÂàut, 2009îî toãv rÝ»þ/óç½àã tÁuçwÊãv âÂàOÎjm Ñàç½ààÊç âÂàut 4 ÂàäyàÊ ¡.§íîý.4 ytàçÊãv wçmÂà wçmÂàóç½àãy vàªàå ¡yvçvç ªàíç»þ t.Âàà.yç.(yä.wç.) âÂàut, 2009îî toãv wçmÂà âÂàut 4 ÂàäyàÊ wÊãv ¡.§íîý.14(2) ÂàäyàÊ vàªàå ¡yvçvç ªàíç»þ wçmÂà (¡.§íý.9 wÊãv yÞÀsàêm ¡àâ½à¡.§íý.6 8 toãv°uà ªàíç»þ wçmÂàà°uà t.Âàà.yç.(yä.wç.)âÂàut,2009 toãv âÂàut Äýʧýà°uà 50%, â§ýtàÂà Ú. 100/-) 14(3) ÂàäyàÊ vªàå ¡yvçvç ¡âmáʨm §ýâÂà™þ §ýtêjà uà°uà yäoàáÊm ªàíç»þ wçmÂà wçmÂàà°uà ¡ÂàäxÞªààÂàç wà¼þâwvçvç yäoàáÊm wçmÂà (t.Âàà.yç.(yä.wç.)âÂàut,2009 toãv âÂàut7(1) hàvãv ¹þãq 5wçmÂà ¡àâ½à 7) vàªàå ÐnàÂààqÂÂà qÀàwÊãv ¡yÌuày, §ýâÂà™þ §ýtêjà uàjç Âààw ¡àâ½à âÂàOÎjmãÂàÞmÊjç wçmÂà §ýàut ¾uàjç âÂàOÎjm §çývçvç wçmÂàyä÷à qÀàwÊãv wçmÂà âÂàOÎjmãÂàÞmÊ°uà ÀÎàêâw½uàm uàwç. wçmÂààqçÕàà §ýtã¡yÌuày ¡yÌuày,§ýàut wèuâ¨m§ý wçmÂà qÀàwÊãv yäoàáÊm wçmÂà ( t.Âà.yç.(yä.wç.) âÂàuÈ,2009 toãv
-
2118
-
12206
-
Pay Band PB-2, 9300-34800, Grade Pay -4300
-
Not applicable
-
12510
-
4300
-
Not applicable
-
Not applicable
-
Not applicable
-
Not applicable
-
Not applicable
Page 21 of 27 ABC
ASSISTANT TEACHER
XYZ
wçmÂà âÂàOÎjmãÂàÞmÊjã yäoàáÊm âwÙàvÆoã (¡) yäoàáÊm wçmÂà 12510 rÝ»þ/wçmÂàóç½àã toãv wçmÂà 4300 ( wÊãv wçmÂà ¡.§íîý.10(wÊãv â§Þýwà 14 â§Þýwà (r) ªàíç»þ ¡.§íîý.11+12 15 Zàtà½àç kç ,vàªàå ¡yçv¡yçv mç ) ) 11+13, kç vàªàå mç (§ý) â§Þýwà âwÎàçx wçmÂà ¡ÂàäÖàçu ¡yÌuày Not applicable (t.Âàà.yç.(yä.wç.) âÂàut,2009 toãv âÂàut 7wçmÂà hàvãv qàç¹þâÂàut (1)(§ý)) (»þ) âwÎàçx , ¡ÂàäÖàçu ¡yÌuày Not applicable (t.Âàà.yç.(yä.wç.) âÂàut,2009 toãv qä¼þãv wçmÂàwà¼þãþjà âÀÂààÞ§ý ( t.Âàà.yç.(yä.wç.) âÂàuttoãv 7(1) âÂàut hàvãv 9¹þãq-4 6) ) ¡àâ½à wçmÂàwà¼þã 18 âÂàut,2009 ¡àâ½àw10 ràr wçmÂàw༠ÂàÞmÊjç wçmÂà wçmÂàwà¼þã ÂàÞmÊjç wçmÂ१åý½à §íýt þãjà ªàíç»þ àÞ§ wçmÂà rÝ»þ/wçmÂàóç½àã toãv wçmÂà täÓ âÀÂààÞ§ý ýi wçmÂà ii iii iv v wçmÂà 4300 16810 01 kàÂàç. 2006 12510 4300 17320 101 kåvè 2006 12510 + 510 = 13020 4300 17840 201 kåvè 2007 13020 + 520 = 13540 4300 18380 301 kåvè 2008 13540 + 540 = 14080 4300 18940 401 kåvè 2009 14080 + 560 = 14640 17
19 ¢mÊ ¡ÂàäxÞâªà§ý tàâÑmã -
20 âÀÂààÞ§ý -
HEAD MISTRESS XYZ
wçmÂà q»þmàÓ½àã ¡âsZààu
Page 22 of 27
BB G
#VALUE!
IF(H8="Not appli
IF(AND(OR(H6=
IF(AND(H7=X1
Page 23 of 27
Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Page 24 of 27
Pay Band recommonded by Committe
IF(AND(H6=X10),AA10,IF(AND(H6=X11),AA11,,IF(AND(H6=X12),AA12,IF(AND(H6=X13),AA13,IF(AND(H6=X14),A Pay Band
PERMANENT
1 £qâÎàÕà§ý ASSISTANT TEACHER
OFFICIATING
2 £qâÎàÕàã§ýà
Not applicable 1
2550-55-2660-60-3200
4 §ýâÂà™þ âvâq§ý F(H8="Not applicable","Not applicable",VLOOKUP(H8,X10:AC37,6)) JUNIOR CLERK
2
2610-60-2910-65-3300-704000
5 ZàuàçªàÎààÓà qáÊjÊ LAB. ATTENDENT
3
6 tä©uàÁuàq§ý HEAD MASTER
4
7 tä©uàÁuàâq§ýà HEAD MISTRESS
5
3 âÎàqà¢êPEON
3050-75-3950-80-4590
8 £qtä©uàÁuàq§ý ASSISTANT HEAD MASTER 3200-85-4900
F(AND(OR(H6=X13,H6=X14,H6=X16,H6=X17,H6=X18),Y13,IF(AND(OR(H6=X19,H6=X2 9 Îàà.âÎàÕà½à âÎàÕà§ý 6 PHYSICAL TEACHER 10 §ývà âÎàÕà§ý ART TEACHER
7
4000-100-6000
4500-125-7000
F(AND(H7=X11),AA11,IF(AND(H7=X12),AA12,IF(AND(H7=X13),AA13,IF(AND(H7=X14),A 11 tä©u âvâq§ý 8 HEAD CLERK 5000-150-8000
12 wÊã™þ SENIOR âvâq§ý CLERK
9
13 ZàuàçªàÎààÓà yÑàÉu§ý 10 LAB. ASSISTANT
5500-175-9000
6500-200-10500
14 ªàíÞnqàvLIBRARIAN
11
15 ªàíÞnqàvSUPERVISOR
12
16 yÞâªàm MUSIC âÎàÕà§ý TEACHER
13
7225-225-11050
Page 25 of 27
14 15 16 17
7500-250-12000
8000-275-13500 9125-275-14075
18 19 20 21 22 23 24 25 âÂàÊÞ§ý
Page 26 of 27
Pay Band recommonded by State Pay Revision Committee
Correspondi Pay Band ng Pay Bands
Grade Pay
Not applicable -1S
4440-7440
1300Pay Band -1S, 4440-7440, Grade Pay -1300
-1S
4440-7440
1600Pay Band -1S, 4440-7440, Grade Pay -1600
PB-1
5200-20200
1900 Pay Band PB-1, 5200-20200, Grade Pay - 1900
PB-1
5200-20200
2000 Pay Band PB-1, 5200-20200, Grade Pay -2000
PB-1
5200-20200
2400 Pay Band PB-1, 5200-20200, Grade Pay -2400
PB-1
5200-20200
2800 Pay Band PB-1, 5200-20200, Grade Pay -2800
PB-2
9300-34800
4200 Pay Band PB-2, 9300-34800, Grade Pay -4200
PB-2
9300-34800
4300 Pay Band PB-2, 9300-34800, Grade Pay -4300
PB-2
9300-34800
4400 Pay Band PB-2, 9300-34800, Grade Pay -4400
PB-2
9300-34800
4600 Pay Band PB-2, 9300-34800, Grade Pay -4600
Page 27 of 27
PB-2
9300-34800
4800 Pay Band PB-2, 9300-34800, Grade Pay -4800
PB-3
1560039100
5400 Pay Band PB-3, 15600-39100, Grade Pay -5400
PB-3
1560039100
5700 Pay Band PB-3, 15600-39100, Grade Pay -5700
Pay Band PB-2, 9300-34800, Grade Pay -4400 Pay Band PB-2, 9300-34800, Grade Pay -4500 Pay Band PB-2, 9300-34800, Grade Pay -4900 Pay Band PB-3, 15600-39100, Grade Pay -5800