Spreadsheet Calculator 46628 | Kuali Salary Guide Fy20

Partial file snippet.

Sheet 1: Salary Guide 

	
	
	
	
	
	
	
	
	
		Guide to Calculating Salary and Effort in Kuali 
		

		

		

		Version 9 - Effective 9/1/2020
		

		

		

		

		

		

	
	
		 
		

		

		

		

		

		

		

		

		

		

	
	
		Important Information
		

		

		

		

		

		

		

		

		

		

	
	
		For the purposes of proposal budgeting:
		

		

		

		

		

		

		

		

		

		

	
	
		Academic Calendar
		

		9/1 - 5/31
		

		

		

		

		

		

		

		

	
	
		Summer  Calendar
		

		6/1 - 8/31
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		KEY  CONCEPTS:
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		There will be multiple entries per person either for AY or Summer effort
		

		

		

		

		

		

		

		

		

		

	
	
		Cost of Living increases are calculated on July 1
		

		

		

		

		

		

		

		

		

		

	
	
		Cumulative grant year effort should begin and end with the proposed project period
		

		

		

		

		

		

		 
		 
		

		

	
	
		Object Codes drive and assign the appropriate fringe benefit rate
		

		

		

		

		

		

		

		

		

		

	
	
		Salary is entered with % of effort and not months (the system will do the translation to months for sponsor forms)
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Effort Calculator
		

		

		

		

		

		

		

		

		

		

	
	
		

		Months
		Appointment Type
		% Effort
		

		

		

		

		

		

		

	
	
		AY
		1
		9
		11.11%
		

		INPUTS
		

		 
		

		

		

	
	
		Summer
		1
		3
		33.33%
		

		KUALI ENTRY
		

		

		

		

		

	
	
		CAL
		2
		12
		16.67%
		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Example 1 
		

		Grant Period 7/1-6/30
		

		 
		

		

		

		

		

		

	
	
		

		

		PI 3 month AY effort
		

		

		

		

		

		

		

		

	
	
		

		

		PI 2 months Summer effort
		

		

		

		

		

		

		

		

	
	
		

		

		AY salary
		$100,000 
		

		

		

		

		

		

		

	
	
		How to calculate effort
		

		

		

		

		

		

		

		

		

		

	
	
		AY
		3 months/9month
		

		33.33%
		Entered date range 9/1/2019-5/31/2020
		

		$33,000 
		

		

		

		

	
	
		Summer
		2months/3months
		

		66.67%
		Entered date range 7/1/2019-8/31/2019
		

		$14,889 
		

		

		

		

	
	
		

		

		

		67.00%
		Entered date range 6/1/2020-6/30/2020
		

		$7,444 
		

		

		

		

	
	
		

		

		

		

		

		Total
		$55,333 
		

		

		

		

	
	
		

		

		*difference to below is due to COLA increase on 7/1
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Example 2
		

		Grant Period 11/1-10/31
		

		

		

		

		

		

		

		

	
	
		

		

		PI 3 month AY effort
		

		

		

		

		

		

		

		

	
	
		

		

		PI 2 months Summer effort
		

		

		

		

		

		

		

		

	
	
		

		

		AY salary
		$100,000 
		

		

		

		

		

		

		

	
	
		AY
		3/months/9months
		

		33.00%
		Entered date range 11/1/2019-5/31/2020
		

		$25,667 
		

		

		

		

	
	
		

		

		

		33.00%
		Entered date range 9/1/2020-10/31/2020
		

		$7,590 
		

		

		

		

	
	
		Summer
		2 months/3months
		

		67.00%
		Entered date range 6/1/2020-8/31/2020
		

		$22,854 
		

		

		

		

	
	
		

		

		

		

		

		Total
		$56,111 
		

		

		

		

	
	
		

		

		*difference to above is due to COLA increase on 7/1
		

		

		

		

		

		

		

		

	



Sheet 2: Grad Calculator

	
	
	
	
	
	
	
	
	
	
	
	
		GRADUATE STUDENT CALCULATOR
		

		

		

		Version 9 - Effective 9/1/2020
		

		

		

		

		

		

		

		

	
	
		Important Information
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		For the purposes of proposal budgeting:
		

		

		INPUTS
		

		

		

		

		

		

		

		

		

	
	
		Academic Calendar
		9/1 - 5/31
		

		KUALI ENTRY
		

		

		

		

		

		

		

		

		

	
	
		Summer  Calendar
		6/1 - 8/31
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Current minimum hourly rate
		30.33
		 
		

		

		

		

		

		

		

		

		

		

	
	
		Input actual rate to be used
		30.33
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Base Salary Hours
		 Base Salary Weeks
		Actual Weeks         SEE NOTE
		USE THIS AS BASE SALARY 
		Actual Hours/Week
		Weeks/Period
		USE THIS EFFORT 
		

		

		

		

		

	
	
		AY 9 month base salary
		40
		38
		38
		 46,101.60 
		 20.00 
		 38.00 
		50.00%
		 Enter both base salary and effort in applicable field in Kuali  
		

		

		

		 
	
	
		Summer 3 month base salary
		40
		14
		14
		 16,984.80 
		 20.00 
		 14.00 
		50.00%
		

		

		

		

		

	
	
		Cumulative
		

		

		

		 63,086.40 
		

		

		

		

		

		

		

		

	
	
		NOTE: 20 hours/week  typical maximum in AY and 40 hrs/week maximum in Summer
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		NOTE: Enter both base salaries to Grad student personnel entries
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		NOTE: Enter percent of effort when assigning Grad students to the budget
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		NOTE: Grad student academic and summer salaries are calculated separately. Users will need two entries for each grad student if they have both AY and Summer effort.
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		 NOTE: Do NOT change UNLESS period of performance is less than 12 months.
		

		

	
	
		

		 
		

		

		 
		

		

		

		

		

		

		

		

	
	
		Tuition
		FY21
		FY22
		FY23
		FY24
		FY25
		FY26
		FY27
		

		

		

		

		

	
	
		18.388
		19.704
		21.020
		22.336
		23.651
		24.967
		26.283
		

		

		

		

		

	
	
		 13,975 
		 14,975 
		 15,975 
		 16,975 
		 17,975 
		 18,975 
		 19,975 
		

		

		

		

		 
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		GRAD TOTAL Cost Estimator
		For informational purposes only and will not exactly match Kuali due to grant period start/end date and COLA
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Cola
		0.02
		FY21
		FY22
		FY23
		FY24
		FY25
		FY26
		FY27
		

		

		

		

	
	
		AY Salary
		

		 23,050.80 
		 23,511.82 
		 23,982.05 
		 24,461.69 
		 24,950.93 
		 25,449.95 
		 25,958.94 
		

		

		

		

	
	
		AY Fringe
		19.75%
		 4,552.53 
		 4,643.58 
		 4,736.46 
		 4,831.18 
		 4,927.81 
		 5,026.36 
		 5,126.89 
		

		

		

		

	
	
		Sum Salary
		

		 8,492.40 
		 8,662.25 
		 8,835.49 
		 9,012.20 
		 9,192.45 
		 9,376.30 
		 9,563.82 
		

		

		

		

	
	
		Sum Fringe
		21.38%
		 1,815.68 
		 1,851.99 
		 1,889.03 
		 1,926.81 
		 1,965.35 
		 2,004.65 
		 2,044.75 
		

		

		

		

	
	
		Total Salary & Fringe
		

		 37,911.41 
		 38,669.64 
		 39,443.03 
		 40,231.89 
		 41,036.53 
		 41,857.26 
		 42,694.40 
		

		

		

		

	
	
		Tuition
		

		 13,975.00 
		 14,975.00 
		 15,975.20 
		 16,975.00 
		 17,975.00 
		 18,975.00 
		 19,975.08 
		

		

		

		

	
	
		Total
		

		 51,886.41 
		 53,644.64 
		 55,418.23 
		 57,206.89 
		 59,011.53 
		 60,832.26 
		 62,669.48

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet salary guide to calculating and effort in kuali version effective important information for the purposes of proposal budgeting academic calendar summer key concepts there will be multiple entries per person either ay or cost living increases are calculated on july cumulative grant year should begin end with proposed project period object codes drive assign appropriate fringe benefit rate is entered not months system do translation sponsor forms calculator appointment type inputs entry cal example pi month how calculate monthsmonth date range monthsmonths total difference below due cola increase above grad graduate student current minimum hourly input actual used base hours weeks see note use this as hoursweek weeksperiod enter both applicable field typical maximum hrsweek salaries personnel percent when assigning students budget separately users need two each if they have change unless performance less than tuition fy estimator informational only exactly match startend sum amp...

Related files

Share

Help

Guide to Calculating Salary and Effort in Kuali				Version 9 - Effective 9/1/2020

Important Information
For the purposes of proposal budgeting:
Academic Calendar		9/1 - 5/31
Summer Calendar		6/1 - 8/31


KEY CONCEPTS:

There will be multiple entries per person either for AY or Summer effort
Cost of Living increases are calculated on July 1
Cumulative grant year effort should begin and end with the proposed project period
Object Codes drive and assign the appropriate fringe benefit rate
Salary is entered with % of effort and not months (the system will do the translation to months for sponsor forms)

Effort Calculator
	Months	Appointment Type	% Effort
AY	1	9	11.11%		INPUTS
Summer	1	3	33.33%		KUALI ENTRY
CAL	2	12	16.67%

Example 1		Grant Period 7/1-6/30
		PI 3 month AY effort
		PI 2 months Summer effort
		AY salary	$100,000
How to calculate effort
AY	3 months/9month		33.33%	Entered date range 9/1/2019-5/31/2020		$33,000
Summer	2months/3months		66.67%	Entered date range 7/1/2019-8/31/2019		$14,889
			67.00%	Entered date range 6/1/2020-6/30/2020		$7,444
					Total	$55,333
		*difference to below is due to COLA increase on 7/1

Example 2		Grant Period 11/1-10/31
		PI 3 month AY effort
		PI 2 months Summer effort
		AY salary	$100,000
AY	3/months/9months		33.00%	Entered date range 11/1/2019-5/31/2020		$25,667
			33.00%	Entered date range 9/1/2020-10/31/2020		$7,590
Summer	2 months/3months		67.00%	Entered date range 6/1/2020-8/31/2020		$22,854
					Total	$56,111
		*difference to above is due to COLA increase on 7/1

GRADUATE STUDENT CALCULATOR				Version 9 - Effective 9/1/2020
Important Information
For the purposes of proposal budgeting:			INPUTS
Academic Calendar	9/1 - 5/31		KUALI ENTRY
Summer Calendar	6/1 - 8/31

Current minimum hourly rate	30.33
Input actual rate to be used	30.33
	Base Salary Hours	Base Salary Weeks	Actual Weeks SEE NOTE	USE THIS AS BASE SALARY	Actual Hours/Week	Weeks/Period	USE THIS EFFORT
AY 9 month base salary	40	38	38	46,101.60	20.00	38.00	50.00%	Enter both base salary and effort in applicable field in Kuali
Summer 3 month base salary	40	14	14	16,984.80	20.00	14.00	50.00%
Cumulative				63,086.40
NOTE: 20 hours/week typical maximum in AY and 40 hrs/week maximum in Summer
NOTE: Enter both base salaries to Grad student personnel entries
NOTE: Enter percent of effort when assigning Grad students to the budget
NOTE: Grad student academic and summer salaries are calculated separately. Users will need two entries for each grad student if they have both AY and Summer effort.
NOTE: Do NOT change UNLESS period of performance is less than 12 months.

Tuition	FY21	FY22	FY23	FY24	FY25	FY26	FY27
	18.388	19.704	21.020	22.336	23.651	24.967	26.283
	13,975	14,975	15,975	16,975	17,975	18,975	19,975

GRAD TOTAL Cost Estimator	For informational purposes only and will not exactly match Kuali due to grant period start/end date and COLA


Cola	0.02	FY21	FY22	FY23	FY24	FY25	FY26	FY27
AY Salary		23,050.80	23,511.82	23,982.05	24,461.69	24,950.93	25,449.95	25,958.94
AY Fringe	19.75%	4,552.53	4,643.58	4,736.46	4,831.18	4,927.81	5,026.36	5,126.89
Sum Salary		8,492.40	8,662.25	8,835.49	9,012.20	9,192.45	9,376.30	9,563.82
Sum Fringe	21.38%	1,815.68	1,851.99	1,889.03	1,926.81	1,965.35	2,004.65	2,044.75
Total Salary & Fringe		37,911.41	38,669.64	39,443.03	40,231.89	41,036.53	41,857.26	42,694.40
Tuition		13,975.00	14,975.00	15,975.20	16,975.00	17,975.00	18,975.00	19,975.08
Total		51,886.41	53,644.64	55,418.23	57,206.89	59,011.53	60,832.26	62,669.48

Related files

Share

Share to social media

Help

Login Area