HRS/WK FTE Contact Hrs FTE
1 0.025 1.00 0.08
2 0.050 2.00 0.17
3 0.075 3.00 0.25
4 0.100 4.00 0.33
5 0.125 5.00 0.42
6 0.150 6.00 0.50
7 0.175 7.00 0.58
8 0.200 8.00 0.67
9 0.225 9.00 0.75
10 0.250 10.00 0.83
11 0.275 11.00 0.92
12 0.300 12.00 1.00
13 0.325
14 0.350 One 3.0 COURSE RELEASE TIME = 0.25
15 0.375
16 0.400 Minimum Salary Rate
17 0.425 Description Hourly Rate
18 0.450 Undergraduate Student $6.15
19 0.475 Graduate Assistant $10.25
20 0.500 Graduate Research Assistant $11.75
21 0.525 Graduate Teaching Assistant $11.75
22 0.550
23 0.575
24 0.600
25 0.625
26 0.650
27 0.675
28 0.700
29 0.725
30 0.750
31 0.775
32 0.800
33 0.825
34 0.850
35 0.875
36 0.900
37 0.925
38 0.950
39 0.975
40 1.000
RESEARCH & SPONSORED PROGRAMS
Salary Calculations 2007-QTR 2-4 Worksheets Instructions
BEFORE YOU BEGIN
The appropriate add-ins for Microsoft Excel must be activated for this application to operate correctly.
Go to Add-ins… on the Tools menu and ensure the following add-ins are checked:
Analysis Toolpack
Analysis Toolpack - VBA
Conditional Sum Wizard
Look-up Wizard
Solver Add-in
Check any that are not checked and click on OK.
OVERALL INSTRUCTIONS
1 Worksheets are designed to be used as read-only file in order to protect calculations and values
required for functions. Worksheets are designed for point-in-time calculations to determine
availability of grant funds in appropriate salary categories to support action requested. If it is desired
to save the data, the worksheet will need to be saved on local computer with a new name.
2 Three separate worksheets are provided. The first worksheet will calculate for an hourly rate
appointment (OPS faculty, staff, or student appointment). If a calculation is desired for an
appointment other than OPS on a given hourly rate, multiply this rate by 2088 hours to arrive at an
annual (12.0 month salary). The second worksheet is for a 9-month faculty member during either the
academic year or the summer supplemental appointment and calculates based on daily rate multiplied
by number of days in period. The third worksheet is for any faculty or staff appointment at an annual
(12-month; 26.1 pay periods) rate. Select the appropriate worksheet and refer to instructions below.
3 Insert text in green cells only. Yellow and Blue cells are calculation formulas based on information
entered for each calculation action.
4 Color Code ENTRY ITEMS CALCULATIONS ON KNOWN FTE
CALCULATIONS ON KNOWN SALARY AMOUNT FOR PERIOD OF APPOINTMENT
THAT DETERMINES FTE.
5 Enter name of employee in first block.
6 Banner ID is employee's Banner identification number which is used in lieu of social security number.
Enter only if known.
7 Date Prepared will default with current date. If it is desired to save this calculation with this date, it
must be changed to a fixed date before saving with another name.
GRANT INFORMATION
8 Account No.: Enter grant fund (index) number.
9 End Date: Enter grant fund end date for current authorized budget period.
10 Funds Available: This item will be the Grant Inception-to-Date available funds within the
appropriate salary category. Refer to item x for category definitions.
RESEARCH & SPONSORED PROGRAMS
Salary Calculations 2007-QTR 2-4 Worksheets Instructions
11 Desired Salary: If a fixed amount of salary is desired to be used for appointment and the FTE for this
amount is unknown, enter the amount in this box. For example, there is $5,000 available to support
an appointment for a given period of time and the FTE is unknown.
12 Period of Appointment: Enter the first date of the appointment and the last date of the appointment.
The worksheet will calculate number of working days in period for Total Cost Calculations. If end
date is unknown, enter the end date of the grant/fund.
13 Hourly or Annual Salary: On the hourly worksheet, enter the desired hourly rate. On the 9-month
or 12-month worksheets, enter the 9-month or 12-month base rate for full time 100% or 1.0 FTE.
14 Known FTE: If the FTE or percentage of effort is known, enter the appropriate percentage (.10 FTE
= 10%; 1.0 FTE = 100%; etc.). If amount of Desired Salary has been entered for calculation of FTE,
leave this block empty. See Reference worksheet for FTE based on hours worked per week or
contact hour equivalents.
15 Benefited: If the appointment is an OPS basis, select No from the drop down list and the maximum
fringe benefit rate (8.51%) will default. If the appointment is for a line position with benefits, select
Yes from the drop down list and the appropriate fringe benefit rate will be accessed on the base salary
rate.
RESEARCH & SPONSORED PROGRAMS
Salary Calculations 2007-QTR 2-4 Worksheets Instructions
TOTAL COST CALCULATIONS: These values and formula are protected cells and should not be
changed. An explanation of the calculations performed is shown below.
HOURLY CALCULATION WORKSHEET
1 Daily Rate: Multiplies hourly rate x 8 hours for normal workday.
2 Biweekly Rate: Multiplies Daily Rate x 10 workdays in a biweekly payroll period.
3 Period of Appointment Rate: Calculates an full-time (1.0 or 100%) rate for the period of appointment
based on number of working days in period.
4 Period of Employment (Days): Calculates number of working days in period.
5 Fringe Rate: Defaults to maximum fringe rate for OPS appointment status (staff or students enrolled
less than 6.0 semester hours.
6 Wages for POE @ Known FTE: Calculates salary at full time appointment base multiplied by known
FTE or number of weekly hours entered above. Adds fringe at maximum liability rate for OPS
appointment (8.51%). Total equals the total amount of salary and fringe costs. See Reference
worksheet for FTE based on hours worked per week or contact hour equivalents.
7 Wages for POE @ Calculated FTE: Calculates FTE required to pay the employee the Desired Salary
during appointment period entered. If rate exceeds 100%, the amount must be lowered or the period
extended or the additional funds shown as additional appointment.
SALARY CALCULATION WORKSHEETS (9-mo or 12-mo)
1 Biweekly Rate: Divides the salary base rate by number of pay periods (19.5 for 9-mo; 26.1 for 12-mo).
2 Daily Rate: Divides Biweekly Rate by number of days in pay period (10).
3 Hourly Rate: Divides Daily Rate by 8 hours for normal workday.
4 Period of Employment (Days): Calculates number of working days in period.
5 Fringe Rate: Defaults to maximum fringe rate for salary base.
6 Salary for POE @ Known FTE: Calculates salary at known FTE entered above. Adds fringe at
maximum liability rate for Salary Base Rate. Total equals the total amount of salary and fringe for
appointment.
7 Salary for POE @ Calculated FTE: Calculates FTE required to pay the employee the Desired Salary
during appointment period entered. If rate exceeds 100%, the amount must be lowered or the period
extended or the additional funds shown as additional appointment.
ate correctly.
University of West Florida
Research and Sponsored Programs
Use this Worksheet after January 1, 2011
9-MONTH SALARY CALCULATION WORKSHEET
Name:
Banner ID: Date Prepared: November 30, 2011
Fund No. Period of Appointment (POE)
Grant Information
From: 1/1/2011
End Date To: 3/31/2011
Funds Available Annual Salary
Desired Salary Known FTE Benefited
No
Total Cost Calculations
Biweekly Rate: $0.00
Daily Rate: $0.00
Hourly Rate: $0.00
POE (Days): 64
Calculated FTE
Fringe Rate: 9.85% #DIV/0!
Salary for POE Salary for POE
Known FTE Calculated FTE
Salary: Salary: #DIV/0!
+Fringe: +Fringe: #DIV/0!
Total: Total: #DIV/0!
NOTES
1. Fringe is automatically calculated at highest liability.
2. FTE is calculated when Annual Salary entered is less than the Funds Available.
3. If the Period of Appointment (POE) falls within the Summer term,
University of West Florida
Research and Sponsored Programs
Use this Worksheet after January 1, 2011
12-MONTH SALARY CALCULATION WORKSHEET
Name:
Banner ID: Date Prepared: November 30, 2011
Fund No. Period of Appointment (POE)
Grant Information
From: 1/1/2011
End Date To: 3/31/2011
Funds Available Annual Salary
$50,000.00
Desired Salary Known FTE Benefited
No
Total Cost Calculations
Biweekly Rate: $1,915.71
Daily Rate: $191.57
Hourly Rate: $23.95
POE (Days): 64
Calculated FTE
Fringe Rate: 9.85% 0.00%
Salary for POE Salary for POE
Known FTE Calculated FTE
Salary: Salary: $0.00
+Fringe: +Fringe: $0.00
Total: Total: $0.00
NOTES
1. Fringe is automatically calculated at highest liability.
2. FTE is calculated when Annual Salary entered is less than the Funds Available.
University of West Florida
Research and Sponsored Programs
Use this Worksheet after January 1, 2011
Use this Worksheet for OPS staff & students only. Calculate ESC using 9 or 12 mo worksheet.
OPS HOURLY WAGES CALCULATION WORKSHEET
Name:
Banner ID: Date Prepared: November 30, 2011
Account No. Period of Appointment (POE)
Grant Information
From: 1/1/2011
End Date To: 3/31/2011
Funds Available Hourly Rate
Desired Salary Known FTE Weekly Hours
or
Total Cost Calculations
Daily Rate: $0.00
Biweekly Rate: $0.00
Annual Rate: $0.00
POE (Days): 64
Calculated FTE
Fringe Rate: 3.65% #DIV/0!
Wages for POE Wages for POE
Known FTE Calculated FTE
Salary: Salary: #DIV/0!
+Fringe: +Fringe: #DIV/0!
Total: Total: #DIV/0!
NOTES
1. Fringe is fixed at 3.65%.
2. FTE is calculated based on hours worked per week.