...
Your department will provide the template and they will confirm that all the correct rates are used. There are many templates for NIH budgets.
| Tip |
|---|
An Excel budget is required by JHURA for every grant submission |
...
How To:
. |
How To: | Create a budget in Excel.
Personnel costs are typically the largest portion of your budget, For personnel, you need the columns below to compute effort for your grant. To compute effort, you can use this formula: =ROUND(Effort X BaseSal,0) X (# of months/12) This formula allows the user to change the number of months for each person. For example, if hiring a project coordinator that will start later in the first year of the project, you can set the months at nine or six. This is useful when dealing with budgets close to the threshold. 
You can compute mileage travel costs by multiplying miles by the current rate, which can be found here. Here’s a formula that can be used to compute travel costs. The $1,200 total cost includes $440 for the flight, $300 conference registration fee, $120 for ground transportation, $110/night X 2 nights hotel is $220, and $120 for other miscellaneous expenses. Airfare + Conference Registration + Ground Transportation + Hotel + Misc. expenses = One Trip $440 + $300 + $120 + $220 + $120 = $1,200
A formula based on effort can be used for supplies. For example: Supplies have been budgeted at $100 per month per percent effort, which is $1,260 per year (100 X 12 X 105%) Other categories can be listed on your Excel sheet as whole numbers. For example: Postage: $500
Below CONSORTIUM #1 : | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Resources: | https://jhura.jhu.edu/proposaldevelopment/budgets/
| ||||||||||
Contacts: | |||||||||||
Related Links: |
...