salary-calc.xlsx

Figure Salary for a Semester (contract period) Appointment
Step 1 Choose Semester	Choose Semester using drop-down	# of Pay Periods	Note, use the drop down at left to choose the semester.	Semester	Pay Periods	Appointment Dates
Step 1 Choose Semester			Note, use the drop down at left to choose the semester.	Summer A 2012	3.2	5/7/12 - 6/19/12
Step 2 Enter appointment dates	Enter ACTUAL Start Date	Enter ACTUAL End Date	Biweekly pay periods	Summer B 2012	3.3	6/20/12 - 8/3/12
Step 2 Enter appointment dates				Summer C 2012	6.5	5/7/12 - 8/3/12
Step 3 Enter EITHER desired semester rate or desired biweekly rate	Desired Appointment Rate		Desired biweekly rate	Academic Year 2012/13 (9 mos)	19.5	8/7/12 - 5/6/13
		OR		Calendar Year 2012/13 (12 mos)	26.1	8/7/12 - 8/6/13
	Rate to enter on ASF		Rate to enter on ASF	Semester I (Fall) 2012	9.7	8/7/12 -12/19/12
				Semester II (Spring) 2013	9.8	12/20/12 -5/6/13
Actual amount to be paid. Include in Letter of Offer and in the ASF Remarks section.	ACTUAL amount employee will be paid		ACTUAL amount employee will be paid
				Click here to open a How-to document for this calculator

Calculate summer salary and FTE based on 9 month salary and credit hours
Semester	Faculty Member Name	9 Month (NAANNL) Salary	9 Month (Biweekly)	Summer Credit Hours	Summer FTE	Summer Weekly Hrs	Summer Salary
Summer A, B, C
Calculate FTE based on a specific dollar amount:
Semester	Faculty Member Name	9 Month (NAANNL) Salary	What do you want to pay?	Summer FTE should be	Summer Hours
Summer C						Click here for instructions on using this calculator
Summer A or B						Click here for instructions on using this calculator

For summers 2011-2013, salaries are capped at $4,167 per credit hour for each
course taught. (Example: A 1 hour credit course is capped at $4,167 while a 3
hour credit course is capped at $12,500.)

Hourly Salary Budget Calculator
First, enter the begin and end dates of appointment	Employee name		Enter ACTUAL begin date		Enter ACTUAL end date	Number of biweekly pay periods
First, enter the begin and end dates of appointment
Then, enter hours per week and hourly rate	Enter hours worked per week	X	Enter hourly rate	=	Total pay for length of appointment
Then, enter hours per week and hourly rate		X
OR
Enter pay amount available and hourly rate to get hours/FTE	Enter pay amount available for appointment	=	Enter hourly rate	X	Number of hours	FTE
Enter pay amount available and hourly rate to get hours/FTE				X

University of South Florida