Teaching Wage Equity Gap Calculator - Click Rank Field for Notes on Use

	A	B	C	D	E	F	G	H	I	J
1	Rank	Salary	% teaching	Courses/year	Total teaching	Total non teaching	Per course wage	Per course equity gap	Equity model adjusted pay	$ to meet per course floor
2	Adjunct	$6,500.00	1	2	$6,500.00	$0.00	$3,250.00	-$2,500.00	$11,500.00	$5,000.00
3	Lecturer	$35,000.00	1	8	$35,000.00	$0.00	$4,375.00	-$1,375.00	$46,000.00	$11,000.00
4	Asst. prof	$67,000.00	0.4	4	$26,800.00	$40,200.00	$6,700.00	$950.00	$63,200.00	0
5	Tenured prof	$88,000.00	0.4	4	$35,200.00	$52,800.00	$8,800.00	$3,050.00	$75,800.00	0
6
7
8
9				18	$103,500.00	$93,000.00	$5,750.00			$16,000.00
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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