budget template 2024.xlsx

	A	C	D	E	F	H	I	J	K	M	N	O	P	Q	R	S
1	Proposal Budget Worksheet, 5 Years
2	Compliments of the Office of Research and Sponsored Programs
3	Name:
4	Due Date:
5	Revised:
6	Proposal Title:
7
8	Project Start Date
9	Project EndDate
10	This worksheet assumes that each subawardee will be issued a new contract each year.
11	Enter data in year 1 and it will be projected in all future years using the indicated increment
12	Data may be entered in any future year and it will be projected to the end.
13	Note: A minimum of 1% academic year effort is required for all Senior Key Personnel
14
15	Please note: this templates automatically calculates university average fringe rates and the federally negotiated indirect/F&A rates. Please refer to the proposal guidelines for specific budgetary instructions.
16
17	Increment Rate				Fringe Rates Continued
18	Senior Key Personnel	2.00%			Hourly
19	Other Personnel	2.00%			Part-Time B		8.00%
20	Fringe Rates				Part Time B = Employees scheduled to work no more than
21	Fulltime Employees				38 hours per bi-weekly pay period and paid on an hourly basis
22	Faculty (Release Time)	49.40%
23	Faculty (Summer)	24.50%
24	Fulltime, and Part-time A	35.00%			F&A Rate (Indirect Cost)		59.00%
25	Fulltime = 70 hours or more per bi-weekly pay period and paid on an annual basis
26	Part Time A = Part time employees scheduled to work more than 38 hours but less than 70 per bi-weekly pay period
27
28	Senior Key Personnel					Year 1		Year 2		Year 3		Year 4		Year 5
29	Faculty (Release Time) Academic Year 9 months	% Effort	Person Months	# of Credits	Annual Salary	Sponsor / Requested	In-Kind Match	Sponsor / Requested	In-Kind Match	Sponsor / Requested	In-Kind Match	Sponsor / Requested	In-Kind Match	Sponsor / Requested	In-Kind Match
30						0		0		0		0		0
31						0		0		0		0		0
32						0		0		0		0		0
33						0		0		0		0		0
34						0		0		0		0		0
35						0		0		0		0		0
36	Subtotals					0		0		0		0		0		$0.00
37	Fringe Benefits Subtotals					0		0		0		0		0		$0.00
38	Senior Key Personnel Subtotals					0		0		0		0		0
39	Key Personnel Project Total Requested / Inkind	$0			$0
40
41	Faculty (Summer) 3 months	Person Months			Annual Salary	Year 1		Year 2		Year 3		Year 4		Year 5
42						0		0		0		0		0
43						0		0		0		0		0
44						0		0		0		0		0
45						0		0		0		0		0
46	Subtotals					0		0		0		0		0		$0.00
47	Fringe Benefits Subtotals					0		0		0		0		0		$0.00
48	Faculty (Summer) Subtotals					0		0		0		0		0
49	Faculty (Summer) Project Total Requested / Inkind	$0			$0
50
51	Other Personnel
52	Full-time & Part-Time A	% Effort			Annual Salary	Year 1		Year 2		Year 3		Year 4		Year 5
53								0		0		0		0
54						0		0		0		0		0
55						0		0		0		0		0
56	Subtotals							0		0		0		0		$0.00
57	Fringe Benefits Subtotals					0		0		0		0		0		$0.00
58	Fulltime and Part-Time A Subtotals					0		0		0		0		0
59	Fulltime and Part-time A Project Total Requested / Inkind	$0			$0
60
61	Part-Time B	Hours per Week	Hourly Rate	# of Weeks	Annual Salary	Year 1		Year 2		Year 3		Year 4		Year 5
62					$ -			0		0		0		0
63					$ -	0		0		0		0		0
64								0		0		0		0
65	Subtotals					0		0		0		0		0		$0.00
66	Fringe Benefits Subtotals					0		0		0		0		0		$0.00
67	Part-Time B Project Subtotals					0		0		0		0		0
68	Part-Time B Project Total Requested / Inkind	$0.00			$0.00
69	Total Personnel Costs	$0.00
70
71	Other than Personnel Services (OTPS)
72	Travel					Year 1		Year 2		Year 3		Year 4		Year 5
73								0		0		0		0
74						0		0		0		0		0
75						0		0		0		0		0
76	Subtotals					0		0		0		0		0
77	Travel Project Total Requested/ Inkind	$0.00			$0.00
78
79	Equipment ($5,000 or more)					Year 1		Year 2		Year 3		Year 4		Year 5
80								0		0		0		0
81						0		0		0		0		0
82						0		0		0		0		0
83	Subtotals					0		0		0		0		0
84	Equipment Project Total Requested/ Inkind	$0			$0
85
86	Stipends					Year 1		Year 2		Year 3		Year 4		Year 5
87						0		0		0		0		0
88						0		0		0		0		0
89	Subtotals					0		0		0		0		0
90	Stipends Project Total Requested/ Inkind	$0			$0
91
92	Materials and Supplies					Year 1		Year 2		Year 3		Year 4		Year 5
93								0		0		0		0
94						0		0		0		0		0
95						0		0		0		0		0
96						0		0		0		0		0
97	Subtotals					0		0		0		0		0
98	Materials & Supplies Project Total Requested / Inkind	$0.00			$0.00
99
100	Contractual Services					Year 1		Year 2		Year 3		Year 4		Year 5