Budget Worksheets and 90-4s

As PIs add budget worksheets to their proposals, data from these worksheets are automatically compiled per funding year (FY) to generate 90-4 forms in FMP. 'Budgets' is the primary FMP layout for managing budget information input to eSeaGrant via the budget worksheets.

Worksheets associated with each 90-4 are accessible under 'Related Worksheets'. Budget justification is editable at right. New budget worksheets may be added in FMP, but may edited only via the web. The Budgets layout is printer-friendly, and is the actual 90-4 template used for PDF exports. The print view of indirect costs rates and budget justification is shown below the 90-4.

90-4 Header Fields

Grantee : If 90-4 is a sub-award, then this field is automatically set to the PI's institution. If 'No', this field is automatically set to the SG host institution.

Grant Number : Driven by Grant Number assignment in associated 90-2. Setting this value in 90-2 triggers assignment of corresponding value in 90-4s for future funding years.

Project Number : Driven by Project Number assignment in associated 90-2.

Other Costs Display in 90-4

Sub-awards are listed first, followed by up to 13 other costs sorted alphabetically by type, and including a row for summarizing the remainder.

90-4 Total Costs Adjustments

You may adjust the SG and/or Grantee share of Total Costs in each 90-4 using this field. The SG and Grantee Total Costs fields are the only ones affected.

Sub-awards

PIs indicate that a worksheet is a sub-award when they answer 'Yes' to the budget worksheet question "Is this award to a non - <your institution> investigator?". This setting is reflect by the "Sub-Award?" toggle in the 'Budgets' layout.

Sub-award 90-4s must be accompanied by a sub-award coverpage. To create a sub-award coverpage for a 90-4, click the green '+ Sub-Award CP' button that accompanies the 90-4 as listed in the Pre-Proposals and Full Proposals layouts ('Budgets' tab). This creates a new 90-4 pre-configured as a coverpage for the selected 90-4, with the host institution Director as PI (see FMP Interface Configuration - RFP; $$subcontract_PI_id variable).

Excluding a 90-4 from Summary Calculations

This toggle allows for a 90-4 to be excluded in budget summary reports, with the exception of the Cumulative 90-4 and Overall 90-4 by FY (see RFP Reports in FMP).
 

Refer to the  used by PIs during a 2014 MITSG Omnibus RFP for a complete set of instructions for using the eSeaGrant budget worksheet.

Questions 1 - 4

1. Duration - This drop-down list driven by the funding years selected in call configuration (see Call Management).
2. Budget Type - Selection triggers auto-population of Section H IDC rates of non-sub-award budgets with relevant default rates (e.g. on-campus rate, off-campus rate, other) for the host institution. For this to work properly, default rates for each funding year must be included in the Funding Years table (see Call Management).
3. Worksheet Title - can be anything
4. (a) "Is this award to a non - <your institution> investigator?" - 'Yes' toggles worksheet as a sub-award
   (b) "If yes, does your institution have an active sub-award w/ MIT Sea Grant?" - for use with Other Cost sub-awards (see below)

Other Costs

Options
Sub-award (provide label)
Sub-award NOT subject to indirect (provide label)
Other cost subject to indirect (describe)
Other cost NOT subject to indirect (describe)
Tuition NOT subject to indirect cost

All of these options are required variables in eSeaGrant and must not be removed from nor edited in the database table other_cost_types.

"Sub-award NOT subject to indirect" is used primarily when the answer to question #4b ("If yes,…") is 'Yes'.

For Other Cost sub-awards, PIs submit one Statement of Work per proposal and a sub-award budget for each funding year involving a sub-award, populate the Other Cost line in worksheet with the appropriate values from the corresponding sub-award budget, and justify. If including justification in sub-award upload, they should note this in the justification text box.