Get documents about "salary cap worksheet
Document Sample
SALARY CAP WORKSHEET
Budgeting salaries for PIs with salaries above a sponsor's cap
Worksheet based on committed effort percentage OR Worksheet based on dollars budgeted
Enter values in yellow boxes Enter values in yellow boxes
Enter percent of effort committed by PI: Enter annual $ amount of salary budgeted for PI:
Enter the sponsor's annual salary rate cap: Enter the sponsor's annual salary rate cap: $ -
Enter PI's full time annual rate from his/her JED: Enter PI's full time annual rate from his/her JED: $ -
Enter JED contract length in months: Enter JED contract length in months: 0
PI's annualized pay rate is: $ - PI's annualized pay rate is: $ -
Equivalent number of effort months = - Effort % to commit: (note amt based on annualized rate) #DIV/0!
PI's monthly pay rate is: $ - Equivalent number of effort months = #DIV/0!
PI's monthly pay rate is: $ -
Sponsor's monthly pay rate cap is: $ -
PI's committed effort is valued at: $ -
Maximum amount sponsor will pay for this effort annually:* $ - (difference btwn these values is due to rounding of 1/12 to 8.33%)
Annual amount over the salary rate cap:** $ -
Percent of salary which may be charged to the grant:* 0.00% (based on amt of effort committed)
Percent of salary which must be provided elsewhere:** 0.00%
* The amount of salary which is an allowable cost to the grant may be charged directly to the grant, either by creating a LAM distribution line with the grant's purpose code and the
percentage calculated above (cell B16) for effort during the academic period, or by charging the equivalent dollar amount (cell B14) to the grant via an s-contract for effort in the summer.
** The amount of salary which is not an allowable cost to the grant may recorded as an effort percentage (see cell B17) in the LAM with a discretionary purpose code and the grant's
project code, or it may be paid (see amount in cell B15) via s-contract for summer effort using a discretionary purpose code and the grant's project code.
SALARY CAP WORKSHEET
Budgeting salaries for PIs with salaries above a sponsor's cap
Example of PI under salary cap
Enter the sponsor's annual salary cap: $ 196,700.00 (note, the value for the NIH cap has since increased)
Enter PI's full time annual rate from his/her JED: $ 102,000.00
Enter JED contract length in months: 9
PI's annualized pay rate is: $ 136,000.00 this does not exceed the sponsor's annual cap
Pi's monthly pay rate is: $ 11,333.33 1/9th of $120K or 1/12 of $136K
Enter percent of effort committed by PI: 10.00%
PI's committed effort is valued at: $ 13,600.00 10% of PI's annualized rate
Sponsor's cap for 10% of salary: $ 19,670.00 10% of annual salary cap
Maximum amount sponsor will pay for this PI's effort annually: $ 13,600.00 sponsor will pay full amount of PI's effort
Annual amount over the salary rate cap: $ -
Percent of salary which may be charged to the grant: 10.00%
Percent of salary which must be provided elsewhere: 0.00%
Example of PI over the salary cap
Enter the sponsor's annual salary cap: $ 196,700.00
Enter PI's full time annual rate from his/her JED: $ 150,000.00
Enter JED contract length in months: 9
PI's annualized pay rate is: $ 200,000.00 this is higher than the sponsor's annual cap
Pi's monthly pay rate is: $ 16,666.67 1/9th of $150K or 1/12 of $200K
Enter percent of effort committed by PI: 4.00%
PI's committed effort is valued at*: $ 8,000.00 4% of PI's annualized rate
Maximum amount sponsor will pay for this effort annually: $ 7,868.00 4% of annual salary cap
Value of effort committed which is above the salary rate cap: $ 132.00 ($8,000 - $7,868)
Percent of salary which may be charged to the grant: 3.93% (based on the fact that 4% was committed)
Percent of salary which must be provided elsewhere: 0.07% (charged like cost-share but not reportable as such)
*in this example, note that even though the value of the effort committed is less than the sponsor's monthly cap, the full value of the commitment is
unallowable. This may be misleading to some.
1/11/10 D Yasik
Converting effort % to dollars or months and vice-versa
To calculate budgets based on committed effort percentage
Enter values in yellow boxes
Enter percent of effort committed by PI:
Enter PI's full time annual rate from his/her JED:
Enter JED contract length in months:
PI's annualized pay rate = #DIV/0!
Value of PI's committed effort= 0.00% * #DIV/0! =
Equivalent number of effort months = 0.00% * 12 months =
To calculate effort percentage or months based on budgeted dollars
Enter values in yellow boxes
Enter budgeted amount for PI salary
Enter PI's full time annual rate from his/her JED: $ -
Enter JED contract length in months: 0
PI's annualized pay rate is: #DIV/0!
Budgeted amount is equivalent to this effort percentage= $0.00 / #DIV/0! =
Equivalent number of effort months = #DIV/0! * 12 months =
#DIV/0!
0.00
#DIV/0!
#DIV/0! months
Number of Months calculated based on percent effort
Summer Effort Period Academic Year Calendar Year
(3 months) (6 months) (9 months) (12 months)
Effort
5% 0.2 0.3 0.5 0.6
10% 0.3 0.6 0.9 1.2
15% 0.5 0.9 1.4 1.8
20% 0.6 1.2 1.8 2.4
25% 0.8 1.5 2.3 3.0
30% 0.9 1.8 2.7 3.6
35% 1.1 2.1 3.2 4.2
40% 1.2 2.4 3.6 4.8
45% 1.4 2.7 4.1 5.4
50% 1.5 3.0 4.5 6.0
55% 1.7 3.3 5.0 6.6
60% 1.8 3.6 5.4 7.2
65% 2.0 3.9 5.9 7.8
70% 2.1 4.2 6.3 8.4
75% 2.3 4.5 6.8 9.0
80% 2.4 4.8 7.2 9.6
85% 2.6 5.1 7.7 10.2
90% 2.7 5.4 8.1 10.8
95% 2.9 5.7 8.6 11.4
100% 3.0 6.0 9.0 12.0
read as: 5% of the summer equals .2 months
5% of an effort reporting period equals .3 months
5% of the 9 month academic year equals .5 months
5% of the calendar year equals .6 months
Percent Effort Calculations based on number of months
Summer Effort Report Pd Academic Year (9 Calendar Year (12
(3 months) (6 months) months) months)
Months
1 33.3% 16.7% 11.1% 8.3%
1.5 50.0% 25.0% 16.7% 12.5%
2 66.7% 33.3% 22.2% 16.7%
2.5 83.3% 41.7% 27.8% 20.8%
3 100.0% 50.0% 33.3% 25.0%
3.5 NA 58.3% 38.9% 29.2%
4 NA 66.7% 44.4% 33.3%
4.5 NA 75.0% 50.0% 37.5%
5 NA 83.3% 55.6% 41.7%
5.5 NA 91.7% 61.1% 45.8%
6 NA 100.0% 66.7% 50.0%
6.5 NA NA 72.2% 54.2%
7 NA NA 77.8% 58.3%
7.5 NA NA 83.3% 62.5%
8 NA NA 88.9% 66.7%
8.5 NA NA 94.4% 70.8%
9 NA NA 100.0% 75.0%
9.5 NA NA NA 79.2%
10 NA NA NA 83.3%
10.5 NA NA NA 87.5%
11 NA NA NA 91.7%
11.5 NA NA NA 95.8%
12 NA NA NA 100.0%
read as: 1 month is 33% of the summer
1 month is 16.7% of an effort reporting period
1 month is 11.1% of the 9 month academic year
1 month is 8.3% of the calendar year
Related docs
