| SU/VA Faculty Salary Calculation Template |
|
|
|
|
|
|
|
|
| Fill in only those items in yellow. The spreadsheet will calculate the rest. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Faculty Name: |
|
|
|
|
|
Portion of total Responsibilities |
|
|
|
|
|
|
(v) |
|
(w) |
(x) |
(y) |
(z) |
| Total Annual Salary (SU + VA salary) |
|
|
This number is not used in any calculation on this worksheet.
|
|
|
VA 8ths |
|
VA Hrs |
VA % |
SU Hrs |
SU % |
| Is the effort on grant Stanford Time only? (yes or no) |
|
|
Confirm with PI.
|
|
|
1/8 |
ths |
5 |
8.33% |
55 |
91.67% |
|
(If answer is no, VA portion does not get charged to grant) |
|
|
|
|
2/8 |
ths |
10 |
16.67% |
50 |
83.33% |
| Type of appointment in 8ths VA APPOINTMENT |
|
|
Put VA's fraction here.
|
ths |
|
3/8 |
ths |
15 |
25.00% |
45 |
75.00% |
|
|
|
|
|
|
4/8 |
ths |
20 |
33.33% |
40 |
66.67% |
| (a) |
Total SU Effort - Based on SU/VA breakdown - see column (z). |
|
0.00% |
|
|
5/8 |
ths |
25 |
41.67% |
35 |
58.33% |
| (b) |
Of the total annual salary, how much of that is Stanford's portion? |
|
This includes b + v + a (base + variable + admin supplement)
|
|
|
6/8 |
ths |
30 |
50.00% |
30 |
50.00% |
| (c) |
What is the NIH salary cap? |
|
|
|
|
7/8 |
ths |
35 |
58.33% |
25 |
41.67% |
| (d) |
NIH Salary cap comparison (c x a) |
|
|
|
|
8/8 |
ths |
40 |
66.67% |
20 |
33.33% |
|
|
|
|
|
|
|
|
|
|
|
|
| (e) |
What is the % effort with respect to 100% appointment. |
|
|
|
|
<-This percentage represents the effort devoted with respect to the entire 100% SU+VA appointment. |
|
|
|
|
|
| (f) |
% of salary to be charged with respect to SU portion of the appointment (e / a) |
|
Calculation converts full-time effort (e) to Stanford-only effort based on (a).
|
|
|
Converts the % effort of a 100% appointment to % effort of SU portion or (a) Total SU Effort.
<-This percentage represents the effort devoted with respect to only the SU portion of their appointment. |
|
|
|
|
|
|
Continue calculation with the lowest between b & d |
|
|
|
|
|
|
|
|
|
|
| (g) |
If b is lowest, the amount of salary to be charged to grant is (f x b) |
|
- |
|
|
|
|
|
|
|
|
| (h) |
If d is lowest, the amount of salary to be charged to grant is (f x d) |
|
- |
|
|
|
|
|
|
|
|
| (i) |
If b = d the amount of salary to be charged to grant is (f x b) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The amount of salary to charge to the grant is |
|
Calculated ANNUAL(12-month) salary to be charged to grant.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Notes: |
[Enter your comments, recommendations, source of information, etc. ] |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Calendar months calculation |
|
|
|
|
|
|
|
|
|
|
|
|
A)SU effort |
|
|
|
|
|
|
|
|
|
|
|
B)Appointment @ SU |
0.00% |
|
|
|
|
|
|
|
|
|
|
C)# months in a year |
12 |
|
|
|
|
|
|
|
|
|
|
Effort in calendar months. (AxBxC) |
|
|
|
|
|
|
|
|
|
Filetype Excel XLSX | Posted on 17 Aug 2022 | 3 years ago
