DRAFT DEPARTMENT BUDGET.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AS
1	NSF SF424 REGULAR Budget Worksheet											updated	7/6/2018
2
3	Title	TBD
4	Project Begin Date:	04/01/24				Personnel Inflation Rate:	3.0%					NIH 12-mo Salary Cap:		$ 212,100
5	Project End Date:	03/31/29				Non-Personnel Inflation Rate:	2.0%
6	Number of years:	5												yes						yes						yes						yes
7	A. SENIOR/KEY PERSONNEL		YEAR 1						YEAR 2						YEAR 3						YEAR 4						YEAR 5							Math Check	Notes

8	Name	Project Role	YEAR 1: Base Salary	YEAR 1: Cal Months	Year 1: % effort	YEAR 1: Requested Salary	YEAR 1: Fringe Benefits	YEAR 1: Funds Requested	YEAR 2: Base Salary	YEAR 2: Cal Months	Year 2: % effort	YEAR 2: Requested Salary	YEAR 2: Fringe Benefits	YEAR 2: Funds Requested	YEAR 3: Base Salary	YEAR 3: Cal Months	Year 3: % effort	YEAR 3: Requested Salary	YEAR 3: Fringe Benefits	YEAR 3: Funds Requested	YEAR 4: Base Salary	YEAR 4: Cal Months	Year 4: % effort	YEAR 4: Requested Salary	YEAR 4: Fringe Benefits	YEAR 4: Funds Requested	YEAR 5: Base Salary	YEAR 5: Cal Months	Year 5: % effort	YEAR 5: Requested Salary	YEAR 5: Fringe Benefits	YEAR 5: Funds Requested	TOTAL			yes
9	Academic Year (9 month appointments)
10	NAME	PI	82,787	0.00	0.0%	-	-	-	85,271	0.00	0.0%	-	-	-	87,829	0.00	0.0%	-	-	-	90,464	0.00	0.0%	-	-	-	93,178	0.00	0.0%	-	-	-	-		Y1 salary assumes promotion
11
12																																	-
13	Summer (9 month appointments)																																-
14	NAME - Y1-4: 2m; Y5: 1m	PI	82,787	2.00	22.2%	18,397	1,177	19,574	85,271	2.00	22.2%	18,949	1,213	20,162	87,829	2.00	22.2%	19,518	1,249	20,767	90,464	2.00	22.2%	20,103	1,287	21,390	93,178	1.00	11.1%	10,353	663	11,016	92,909		Y1 salary assumes promotion
15	NAME 2 - Y1,2: 0.275 month	Co-I	163,200	0.275	3.06%	4,987	319	5,306	168,096	0.275	3.06%	5,136	329	5,465	173,139	0.00	0.0%	-	-	-	178,333	0.00	0.0%	-	-	-	183,683	0.00	0.0%	-	-	-	10,771		Budgeted based on actual IBS
21		SENIOR/KEY PERSONNEL SUBTOTAL				23,384	1,496	24,880				24,085	1,542	25,627				19,518	1,249	20,767				20,103	1,287	21,390				10,353	663	11,016	103,680	TRUE
22	B. OTHER PERSONNEL
23	Name	Project Role	YEAR 1: FT Base Salary	YEAR 1: Cal Months	Year 1: % effort	YEAR 1: Requested Salary	YEAR 1: Fringe Benefits	YEAR 1: Funds Requested	YEAR 2: Base Salary	YEAR 2: Cal Months	Year 2: % effort	YEAR 2: Requested Salary	YEAR 2: Fringe Benefits	YEAR 2: Funds Requested	YEAR 3: Base Salary	YEAR 3: Cal Months	Year 3: % effort	YEAR 3: Requested Salary	YEAR 3: Fringe Benefits	YEAR 3: Funds Requested	YEAR 4: Base Salary	YEAR 4: Cal Months	Year 4: % effort	YEAR 4: Requested Salary	YEAR 4: Fringe Benefits	YEAR 4: Funds Requested	YEAR 5: Base Salary	YEAR 5: Cal Months	Year 5: % effort	YEAR 5: Requested Salary	YEAR 5: Fringe Benefits	YEAR 5: Funds Requested	TOTAL			yes
24	FT GRA - Level 2, 12 months, 20 hours		22,398	12.00	0.0%	-	-	-	23,069	12.00	100.0%	23,069	5,883	28,952	23,762	12.00	100.0%	23,762	6,059	29,821	24,474	12.00	100.0%	24,474	6,241	30,715	25,209	0.00	0.0%	-	-	-	89,488		20 hr GA, 60% fringe, only budgeted in Y2, Y3, Y4
25	HT GRA - Level 2, 12 months, 10 hours		22,398	12.00	50.0%	11,199	2,856	14,055	23,069	6.00	50.0%	11,535	2,941	14,476	23,762	6.00	50.0%	11,881	3,030	14,911	24,474	6.00	50.0%	12,237	3,120	15,357	25,209	6.00	50.0%	12,604	3,214	15,818	74,617		10 hr GA, 60% fringe.
26	Undergraduate RA - Y1: 605 hr, Y2-4: 1100 hr, Y5: 495 hrs. TOTAL = 4400 h		24,960	3.49	29.1%	7,260	465	7,725	25,709	6.35	52.9%	13,596	870	14,466	26,480	6.35	52.9%	14,004	896	14,900	27,274	6.35	52.9%	14,424	923	15,347	28,093	2.86	23.8%	6,686	428	7,114	59,552		UGA pay is $12/hr.
37		OTHER PERSONNEL SUBTOTAL				18,459	3,321	21,780				48,200	9,694	57,894				49,647	9,985	59,632				51,135	10,284	61,419				19,290	3,642	22,932	223,657	TRUE
38	TUITION REMISSION - Graduate Students
39	Name	Project Role	YEAR 1: Per Credit	YEAR 1: # FT Credits	Year 1: % effort		YEAR 1: Requested Tuition	YEAR 1: Funds Requested	YEAR 2: Per Credit	YEAR 2: # FT Credits	Year 2: % effort		YEAR 2: Requested Tuition	YEAR 2: Funds Requested	YEAR 3: Per Credit	YEAR 3: # FT Credits	Year 3: % effort		YEAR 3: Requested Tuition	YEAR 3: Funds Requested	YEAR 4: Per Credit	YEAR 4: # FT Credits	Year 4: % effort		YEAR 4: Requested Tuition	YEAR 4: Funds Requested	YEAR 5: Per Credit	YEAR 5: # FT Credits	Year 5: % effort		YEAR 5: Requested Tuition	YEAR 5: Funds Requested	TOTAL			yes
40	FT GRA - Level 2, 12 months, 20 hours		711	32.00	0.0%		-	-	732	32.00	100.0%		23,435	23,435	754	32.00	100.0%		24,138	24,138	777	32.00	100.0%		24,862	24,862	800	32.00	0.0%		-	-	72,435		20 hr GA, 60% fringe, only budgeted in Y2, Y3, Y4
41	HT GRA - Level 2, 12 months, 10 hours		711	32.00	50.0%		11,376	11,376	732	32.00	50.0%		11,717	11,717	754	32.00	50.0%		12,069	12,069	777	32.00	50.0%		12,431	12,431	800	32.00	50.0%		12,804	12,804	60,397		10 hr GA, 60% fringe, no GA budgeted in Y4
42		TUITION REMISSION SUBTOTAL					11,376	11,376					35,152	35,152					36,206	36,207					37,293	37,293					12,804	12,804	132,832	TRUE
43
44		TOTAL SALARIES, BENEFITS & TUITION REMISSION				41,843	16,193	58,036				72,285	46,388	118,673				69,165	47,441	116,606				71,238	48,864	120,102				29,643	17,109	46,752	460,169	TRUE
45
46	C. EQUIPMENT (Non-recurring; exceeds $5K/unit)
47		[equipment item 1]																															-
48		[equipment item 2]																															-
49		EQUIPMENT SUBTOTAL						-						-						-						-						-	-	TRUE
50	D. TRAVEL																																-
51		[domestic]	$497	Subject Testing				2,297	$904	Subject Testing				4,576	$904	Subject Testing				4,650	$904	Subject Testing				4,724	$407	Subject Testing				2,355	18,602		3,616
52			$1,800	PI Domestic Conference: 1 people x ($500 air + $300 reg + $700 hotel + $188 per diem + $112 ground trans)					$1,836	PI Domestic Conference: 1 people					$1,873	PI Domestic Conference: 1 people					$1,910	PI Domestic Conference: 1 people					$1,948	PI Domestic Conference: 1 people							14,986
53									$1,836	Full-time GRA Domestic Conference					$1,873	Full-time GRA Domestic Conference					$1,910	Full-time GRA Domestic Conference: 1 people
54		[foreign]												-						-						-						-	-
55		TRAVEL SUBTOTAL						2,297						4,576						4,650						4,724						2,355	18,602	TRUE
56	E. PARTICIPANT/TRAINEE SUPPORT COSTS																																-
63	F. OTHER DIRECT COSTS																																-
64		[materials and supplies]	$0	description of cost				-	$0	description of cost				-						-						-						-	-
65			$0	description of cost					$0	description of cost
66			$0	description of cost
67			$0	description of cost
68			$0	description of cost
69			$0	description of cost											$0	description of cost
70			$0	description of cost
71
72		[publication costs]												-						-						800						800	1,600
73		[consultant services: ]						-						-						-						-						-	-
74			$0	description of cost					$0	description of cost					$0	description of cost					$0	description of cost					$0	description of cost
75			$0	description of cost					$0	description of cost					$0	description of cost					$0	description of cost					$0	description of cost
76		[ADP/computer services]	$0	description of cost				-	$0	description of cost				-	$0	description of cost				-	$0	description of cost				-	$0	description of cost				-	-
77			$0	description of cost					$0	description of cost					$0	description of cost					$0	description of cost					$0	description of cost							7,680
78		[equipment or faciity rental/user fees]												-						-						-						-
79		[alterations and renovations]												-						-						-						-	-
80		[other:] SUBJECT REIMBURSEMENT						935						1,700						1,700						1,700						765	6,800
81		X Measures - $15 x 3 testing sessions	$45		Incentive	11	Subjects		$45		Incentive	20	Subjects		$45		Incentive	20	Subjects		$45		Incentive	20	Subjects		$45		Incentive	9	Subjects
82		Y Measures	$40		Incentive	11	Subjects		$40		Incentive	20	Subjects		$40		Incentive	20	Subjects		$40		Incentive	20	Subjects		$40		Incentive	9	Subjects
83		[other:]												-						-						-						-	-
84		[other:]												-						-						-						-	-
85		[other:]												-						-						-						-	-
86		OTHER EXPENSES SUBTOTAL						935						1,700						1,700						2,500						1,565	8,400	TRUE
87	G. SUBCONTRACTS																																-
88		SUBCONTRACT DIRECT COSTS						-						-						-						-						-	-
89																																	-
90		SUBTOTAL DIRECT FOR NIH MODULAR BUDGET						61,268						124,949						122,956						127,326						50,672	487,171	TRUE
91																																	-
92		SUBCONTRACT Indirect Costs						-						-						-						-						-	-
93		SUBCONTRACTS SUBTOTAL						-						-						-						-						-	-
94		SUBCONTRACTS MTDC SUBTOTAL						-						-						-						-						-	-	-
95		SUBCONTRACT EXCLUSION SUBTOTAL						-						-						-						-						-	-
96	H. TOTALS																																TOTAL
97		TOTAL DIRECT COSTS						61,268						124,949						122,956						127,326						50,672	487,171	TRUE
98		MTDC	Less Tuition, Equipment, Participant, Sub Exclusion					49,892						89,797						86,749						90,033						37,868	354,339	TRUE
99		INDIRECT COSTS (@ 54.5%)						27,191						48,939						47,278						49,068						20,638	193,114	FALSE
100		TOTAL REQUESTED						88,459						173,888						170,234						176,394						71,310	680,285	TRUE
101
109
110	FY23 Fringe Benefit Rates
111	Description	Group	Fringe Rate
112	9-mo faculty	Faculty	30.7%
113	12-mo faculty	Faculty	30.7%
114	Faculty Acting/Admin Increment	Faculty	30.7%
115	Postdoctoral Scholar	Faculty	30.7%
116	Hourly student	Legislated Benefits	6.4%
117	Faculty additional pay	Legislated Benefits	6.4%
118	Faculty summer salary	Legislated Benefits	6.4%
119	Contractual faculty	Limited Benefits	25.5%
120	Contractual Staff	Limited Benefits	25.5%
121	9-mo Grad Assistant	Limited Benefits	25.5%
122	9.5-mo Grad Assistant	Limited Benefits	25.5%
123	12-mo Grad Assistant	Limited Benefits	25.5%
124	Exempt staff	Staff	36.9%
125	Non-exempt staff	Staff	36.9%
126
127
128