Faculty Salary Grids - FT and PT rates.xlsx

	A	B	C	D	E	F	G	I	J	K	L	M	O
1		Salary Grid Example for 21/22
2
3		1.7% increase for 2021-22						2.2% increase for 2022-23
4					round manually						round manually
5	FF Salary Step	Step	20/21 Sal	101.70%	21/22 Sal	diffenence	% chk	Step	21/22 Sal	102.2%	22/23 Sal	diffenence	% chk
6	7	G	70,015.00	71,205.26	71,205.00		1.01700	G	71,205.00	72,771.51	72,772.00		1.02201
7	8	H	71,162.00	72,371.75	72,372.00	1,167.00	1.01700	H	72,372.00	73,964.18	73,964.00	1,192.00	1.02200
8	9	I	72,309.00	73,538.25	73,538.00	1,166.00	1.01700	I	73,538.00	75,155.84	75,156.00	1,192.00	1.02200
9	10	J	73,456.00	74,704.75	74,705.00	1,167.00	1.01700	J	74,705.00	76,348.51	76,348.00	1,192.00	1.02199
10	11	K	74,603.00	75,871.25	75,871.00	1,166.00	1.01700	K	75,871.00	77,540.16	77,540.00	1,192.00	1.02200
11	12	L	75,750.00	77,037.75	77,038.00	1,167.00	1.01700	L	77,038.00	78,732.84	78,732.00	1,192.00	1.02199
12	13	M	76,897.00	78,204.25	78,204.00	1,166.00	1.01700	M	78,204.00	79,924.49	79,924.00	1,192.00	1.02199
13	14	N	78,044.00	79,370.75	79,371.00	1,167.00	1.01700	N	79,371.00	81,117.16	81,117.00	1,193.00	1.02200
14	15	O	79,191.00	80,537.25	80,537.00	1,166.00	1.01700	O	80,537.00	82,308.81	82,309.00	1,192.00	1.02200
15	16	P	80,338.00	81,703.75	81,704.00	1,167.00	1.01700	P	81,704.00	83,501.49	83,501.00	1,192.00	1.02199
16	17	Q	81,485.00	82,870.25	82,870.00	1,166.00	1.01700	Q	82,870.00	84,693.14	84,693.00	1,192.00	1.02200
17	18	R	82,632.00	84,036.74	84,037.00	1,167.00	1.01700	R	84,037.00	85,885.81	85,885.00	1,192.00	1.02199
18	19	S	83,779.00	85,203.24	85,203.00	1,166.00	1.01700	S	85,203.00	87,077.47	87,077.00	1,192.00	1.02199
19	20	T	84,926.00	86,369.74	86,370.00	1,167.00	1.01700	T	86,370.00	88,270.14	88,270.00	1,193.00	1.02200
20
21			difference			difference			difference			difference
22			1,147.00			1,167.00			1,167.00			1,192.00
23
24
25		2020/21
26		Step	FT salary	PT salary	PT qtrly rate	64% of FT salary
27		G	70,015	44,810	14,937
28		H	71,162	45,544	15,181
29		I	72,309	46,278	15,426
30
31		2021/22
32		Step	FT salary	PT salary	PT qtrly rate	65% of FT salary
33		G/A	71,205	46,283	15,428	includes 1.7% COLA
34		H/B	72,372	47,042	15,681
35		I/C	73,538	47,800	15,933
36
37		2022/23
38		Step	FT salary	PT salary	PT qtrly rate	65% of FT salary
39		G/A	72,772	47,302	15,767	includes 2.2% COLA
40		H/B	73,964	48,077	16,026
41		I/C	75,156	48,851	16,284
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100