Auto Rental Agreement Template
W
Description
Auto Rental Agreement Template document sample
Document Sample


Yale University Federal Budget Template - Fiscal Year 2010
Yale University
Office of Research Administration
Federal Budget Template
This Template has been updated on
5/10/2010
Please click on the tabs below to move between sections of the template.
Please click on the Instructions tab to review the brief instructions prior to using the template.
Click here to start using the template.
Yale University Federal Budget Template - Fiscal Year 2010
Yale University
Office of Research Administration
Federal Proposal Budget Template
General:
The Federal Proposal Budget Template is meant to provide a user friendly manner to develop
a budget. The cells that are highlighted in yellow are those you will need to complete. The remaining cells
will auto-populate based on your input in the yellow cells.
The cells that are marked with a red triangle in the corner provide additional help text. Hover over the cell
and a box with additional instructions will appear. The cells that have blue underlined data (hyperlinks) are links
to additional information - both within Yale and Grants.gov.
Budget:
You will perform the majority of your data input on the BUDGET Tab. As indicated above, you only need to enter
information in the cells highlighted in Yellow.
Step 1: Complete Summary: The Summary section requests basic information regarding your proposal.
The Number of Months per Fiscal Year Box should be completed once the project dates are entered. This
chart helps calculate the base salary across fiscal years of the project. Enter the number of months from the
start of your project until the next fiscal year begins. For example, if your project begins on 1/01/11, the first
6 months of the project will take place in Fiscal Year 2011, therefore you would enter 6 in the yellow cell.
If, however, your project started in 11/01/10, the first 8 months of the project will take place in Fiscal Year 2011,
therefore you would enter 8 in the yellow cell.
Step 2: Complete Personnel Budget: You will enter all your personnel, their current base or hourly salaries and
their proposed effort. The base salary cell will auto-populate based on the amount entered in current salary.
This cell is calculating the increase in salary from one fiscal year to the next, assuming a 3% increase across
fiscal years. In addition to this Personnel section, Periods 2-5 are located at the bottom of the budget spreadsheet.
The budget assumes a 3% inflation over each period, you will just need to enter the effort for each future period.
Step 3: Complete Non-Personnel Budget: Enter each of your non-personnel costs in this section.
Additional fields have been provided to assist you in calculating exact travel costs. You will also enter any
subcontract costs in this section.
Sandbox for Detail Calculation:
This additional space has been provided for detailed calculations for non-personnel costs.
You may use this space to calculate non-personnel costs and enter the total on the Budget Tab.
Indirect Costs:
Step 4: Enter the Indirect Cost Rate: The majority of this tab will auto-populate and auto-calculate based on
information entered on the Budget Tab. You will just need to verify the indirect cost rate and enter $25,000 for
each subcontract listed on the Budget tab.
SF424 Modular:
Step 5: Review Modular Budget, if required: This tab should completely auto-populate for you. If your
proposal requires a modular budget, this tab compiles the information for you based on information entered
on the BUDGET tab and the Indirect Costs Tab.
Summary Section
Organization Name: Yale University
PI Name:
Short Title: may not exceed 81 characters including spaces
Proposal Submission Due Date:
RFA/PA/FOA #:
Budget Type (Project/Subaward):
Start date (mm/dd/yyyy): End date (mm/dd/yyyy): # months per Fiscal Year
0 12
Organizational DUNS # 04-320-7562
DHHS Agreement Date: 7/28/2010
Fringe Benefit Rates Federal YSM non-Fed
Fringe benefits effective date: 7/1/2010 TIAA (salaried) 31.0% 31.0%
Non TIAA (hourly) 46.0% 46.0%
Part-time 9.0% 9.0%
3% inflation factor used
Federal salary cap $ 199,700.00
Personnel Budget
Type Fringe Funds Funds Funds Funds Funds
Appt. Hourly Current Salary FY Base Salary % Requested Fringe Benefit Requested ($) Requested Requested ($) Requested Requested ($) Total for DOUBLE
Name Role on Project (month) Rate salary 09/10 ($) effort Cal. Months Salary ($) rate s Period 1 ($) Period 2 Period 3 ($) Period 4 Period 5 Entire Project CHECK
A. KEY/RESPONSIBLE PERSONNEL
a Principal Investigator 12 - - - 0.0% 0.00 - ###### - - - - - - -
b Principal Investigator 12 - - - 0.0% 0.00 - ###### - - - - - - -
c Co-Investigator 12 - - - 0.0% 0.00 - ###### - - - - - - -
d Co-Investigator 12 - - - 0.0% 0.00 - ###### - - - - - - -
e Co-Investigator 12 - - - 0.0% 0.00 - ###### - - - - - - -
f Co-Investigator 12 - - - 0.0% 0.00 - ###### - - - - - - -
SUBTOTAL KEY PERSONNEL - - - - - - -
B. OTHER PERSONNEL
a Post-Doctoral Associate 12 - - - 0.0% 0.00 - ###### - - - - - - -
b Post-Doctoral Associate 12 - - - 0.0% 0.00 - ###### - - - - - - -
c GRA 12 - 0.0% 0.00 - 0.00% - - - - - -
d M&P (salaried) 12 - - - 0.0% 0.00 - ###### - - - - - - -
e M&P (salaried) 12 - - - 0.0% 0.00 - ###### - - - - - - -
f C&T(hourly) 12 - - - - 0.0% 0.00 - ###### - - - - - - -
g C&T(hourly) 12 - - - - 0.0% 0.00 - ###### - - - - - - -
h Student- Academic Year - 0.0% 0.00 - - - -
i Student summer months - - - 0.0% 0.00 - 9.00% - - - - - - -
SUBTOTAL OTHER PERSONNEL 0 - - - - - - -
TOTAL Salary, Wages, and Fringe Benefits (A+B) - - - - - - - -
Non Personnel Budget
Funds Funds Funds Funds Funds
Requested ($) Requested Requested ($) Requested Requested ($) Total for
C. EQUIPMENT (>$5,000 per piece) Period 1 ($) Period 2 Period 3 ($) Period 4 Period 5 Entire Project
a - - - - - -
b - - - - - -
Total Equipment - - - - - - -
travel
D. TRAVEL lodging M&IE days Airfare # nights # trips TOTAL
Domestic (incl Canada, Mexico, and U.S. Possessions) $ - $ - $ - - - - - - -
Foreign $ - - - - - - -
Total Travel Cost - - - - - - -
F. OTHER DIRECT COSTS
1 Materials and Supplies - - - - - -
2 Publication Cost - - - - - -
3 Consultant Services - - - - - -
4 ADP/Computer Services - - - - - -
5 Subawards/consortium/Contractual AUTO CALCULATES - - - - - -
6 Equipment or facility rental/user fees - - - - - -
7 Alterations and renovations - - - - - -
8 Student Fees, AUTO CALCULATES - - - - - -
9 - - - - - -
10 - - - - - -
Total Other Direct Costs - - - - - - -
GRA Fees
Health Fee - - - - - - -
Tuition NOT INCLUDED IN IDC BASE - - - - - - -
TOTAL Student Fees TOTAL stipend,tuition and fees may not exceed post-doc 0-level - - - - - - -
Subaward - A
Direct Costs - - - - - -
Indirect Costs @ 1st $25K INCLUDED IN IDC BASE 0.0% - - - - - -
Total Costs - - - - - - -
Subaward - B
Direct Costs - - - - - -
Indirect Costs @ 1st $25K INCLUDED IN IDC BASE 0.0% - - - - - -
Total Costs - - - - - - -
Subaward - C
Direct Costs - - - - - -
Indirect Costs @ 1st $25K INCLUDED IN IDC BASE 0.0% - - - - - -
Total Costs - - - - - - -
TOTALS
Total NIH Direct Costs - Face Page excludes consortium F&A - - - - - - -
G. Total Yale's Direct Costs (A thru F) - LESS Subawards TranSum - - - - - - -
Total Yale Direct Costs - Including Subawards TranSum - - - - -
Indirect Cost Base (pulls from Indirect Cost tab) - - - - - - -
H. Indirect Costs (pulls from Indirect Cost tab) MTDC 65.5% Cognizant Federal Agency: DHHS, Michael Stanco, (212) 264-2069 - - - - - - -
I. TOTAL Direct and Indirect Costs Costs (G+H) - - - - - - -
Fringe Funds
Base Salary % Requested Fringe Benefit Requested ($)
Period 2 ($) effort Cal. Months Salary ($) rate s Period 2
KEY/RESPONSIBLE PERSONNEL
a Principal Investigator 12 0 0.0% 0.00 0 ###### 0 0
b Principal Investigator 12 0 0.0% 0.00 0 ###### 0 0
c Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
d Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
e Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
f Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
Subtotal Senior/Key Personnel 0
OTHER PERSONNEL
a Post-Doctoral Associate 12 0 0.0% 0.00 0 ###### 0 0
b Post-Doctoral Associate 12 0 0.0% 0.00 0 ###### 0 0
c GRA 12 0 0.0% 0.00 0 0
d M&P (salaried) 12 0 0.0% 0.00 0 ###### 0
e M&P (salaried) 12 0 0.0% 0.00 0 ###### 0 0
f C&T(hourly) 12 0 0.0% 0.00 0 ###### 0 0
g C&T(hourly) 12 0 0.0% 0.00 0 ###### 0 0
h Student- Academic Year 0 0.0% 0.00 0 0 0
i Student summer months 12 0 0.0% 0.00 0 9.50% 0 0
Subtotal Other Personnel 0
TOTAL Salary, Wages, and Fringe Benefits (A+B) 0 0 0 0
Fringe Funds
Base Salary % Requested Fringe Benefit Requested ($)
Period 3 ($) effort Cal. Months Salary ($) rate s Period 3
KEY/RESPONSIBLE PERSONNEL
a Principal Investigator 12 0 0.0% 0.00 0 ###### 0 0
b Principal Investigator 12 0 0.0% 0.00 0 ###### 0 0
c Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
d Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
e Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
f Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
Subtotal Senior/Key Personnel 0
OTHER PERSONNEL
a Post-Doctoral Associate 12 0 0.0% 0.00 0 ###### 0 0
b Post-Doctoral Associate 12 0 0.0% 0.00 0 ###### 0 0
c GRA 12 0 0.0% 0.00 0 0
d M&P (salaried) 12 0 0.0% 0.00 0 ###### 0
e M&P (salaried) 12 0 0.0% 0.00 0 ###### 0 0
f C&T(hourly) 12 0 0.0% 0.00 0 ###### 0 0
g C&T(hourly) 12 0 0.0% 0.00 0 ###### 0 0
h Student- Academic Year 0 0.0% 0.00 0 0
i Student summer months 12 0 0.0% 0.00 0 ###### 0 0
Subtotal Other Personnel 0
TOTAL Salary, Wages, and Fringe Benefits (A+B) 0 0 0 0
Fringe Funds
Base Salary % Requested Fringe Benefit Requested ($)
Period 4 ($) effort Cal. Months Salary ($) rate s Period 4
KEY/RESPONSIBLE PERSONNEL
a Principal Investigator 12 0 0.0% 0.00 0 ###### 0 0
b Principal Investigator 12 0 0.0% 0.00 0 ###### 0 0
c Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
d Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
e Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
f Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
Subtotal Senior/Key Personnel 0
OTHER PERSONNEL
a Post-Doctoral Associate 12 0 0.0% 0.00 0 ###### 0 0
b Post-Doctoral Associate 12 0 0.0% 0.00 0 ###### 0 0
c GRA 12 0 0.0% 0.00 0 0 0
d M&P (salaried) 12 0 0.0% 0.00 0 ###### 0 0
e M&P (salaried) 12 0 0.0% 0.00 0 ###### 0 0
f C&T(hourly) 12 0 0.0% 0.00 0 ###### 0 0
g C&T(hourly) 12 0 0.0% 0.00 0 ###### 0 0
h Student- Academic Year 0 0.0% 0.00
i Student summer months 0 0.0% 0.00 0 ###### 0 0
Subtotal Other Personnel 0
TOTAL Salary, Wages, and Fringe Benefits (A+B) 0 0 0 0
Fringe Funds
Base Salary % Requested Fringe Benefit Requested ($)
Period 5 ($) effort Cal. Months Salary ($) rate s Period 5
KEY/RESPONSIBLE PERSONNEL
a Principal Investigator 12 0 0.0% 0.00 0 ###### 0 0
b Principal Investigator 12 0 0.0% 0.00 0 ###### 0 0
c Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
d Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
e Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
f Co-Investigator 12 0 0.0% 0.00 0 ###### 0 0
Subtotal Senior/Key Personnel 0
OTHER PERSONNEL
a Post-Doctoral Associate 12 0 0.0% 0.00 0 ###### 0 0
b Post-Doctoral Associate 12 0 0.0% 0.00 0 ###### 0 0
c GRA 12 0 0.0% 0.00 0 0 0
d M&P (salaried) 12 0 0.0% 0.00 0 ###### 0 0
e M&P (salaried) 12 0 0.0% 0.00 0 ###### 0 0
f C&T(hourly) 12 0 0.0% 0.00 0 ###### 0 0
g C&T(hourly) 12 0 0.0% 0.00 0 ###### 0 0
h Student- Academic Year 0 0.0% 0.00
i Student summer months 12 0 0.0% 0.00 0 ###### 0 0
Subtotal Other Personnel 0
TOTAL Salary, Wages, and Fringe Benefits (A+B) 0 0 0 0
Item Name Cost Per Item # of Items Total Cost
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
Indirect Costs Calculation
Period 1 Period 2 Period 3 Period 4 Period 5 TOTALS
Total Direct Costs - - - - - -
Less; Equipment - - - - - -
Less Tuition - - - - - -
Less: Consortium - - - - - -
Plus: first $25,000 per consortium - - -
Total Base - - - - - - 0
Indirect Costs @ 65.5% - - - - - -
Total Costs - - - - - - 0
MODULAR WORKSHEET
TDC less consortium IDC in modules of $25,000
Budget Period 1
A Direct costs less consortium F&A -
Consortium F&A -
Total Direct Costs -
B IDC Base -
IDC Funds Requested -
C Total Direct and Indirect -
DHHS, Michael Stanco, (212) 264-2069 7/28/2010
Budget Period 2
A Direct costs less consortium F&A -
Consortium F&A -
Total Direct Costs -
B IDC Base -
IDC Funds Requested -
C Total Direct and Indirect -
DHHS, Michael Stanco, (212) 264-2069 7/28/2010
Budget Period 3
A Direct costs less consortium F&A -
Consortium F&A -
Total Direct Costs -
B IDC Base -
IDC Funds Requested -
C Total Direct and Indirect -
DHHS, Michael Stanco, (212) 264-2069 7/28/2010
Budget Period 4
A Direct costs less consortium F&A -
Consortium F&A -
Total Direct Costs -
B IDC Base -
IDC Funds Requested -
C Total Direct and Indirect -
DHHS, Michael Stanco, (212) 264-2069 7/28/2010
Budget Period 5
A Direct costs less consortium F&A -
Consortium F&A -
Total Direct Costs -
B IDC Base -
IDC Funds Requested -
C Total Direct and Indirect -
DHHS, Michael Stanco, (212) 264-2069 7/28/2010
TOTAL DIRECT -
TOTAL IDC -
TOTAL COSTS -
Related docs
Other docs by ffi62054
Business Forms Cross Reference Category Adams Item Tops Item Rediform Item Adams Product Desc - Excel
Views: 354 | Downloads: 0
Get documents about "