University of Vermont

Sponsored Project Administration - SPA

217 Waterman Building . 85 South Prospect Street . Burlington, Vermont 05405 . (802) 656-3360

spa budget worksheet

SPA Budget Worksheet

Use the SPA Budget Worksheet to develop your proposal budget.  Please download the SPA Budget Worksheet from the SPA web site, or request your department's the assigned SPA Research Administrator to start the worksheet for you.

The SPA Budget Worksheet is divided into two major sections: 
  • Tab 1 - Sponsor Costs, Cost Share Contributions and Total Project Cost 
  • Tab 2 - Cost Share Commitments and Allocation of F&A Recovery
Fringe Benefit and F&A rates are automated to calculate a blended rate based on the fiscal year and start date of proposal

    Instructions - Tab 1

    1. Complete the data in the boxes at the top right corner

      • InfoEd Number
      • SPA Research Administrator name and date started
      • Worksheet Type
      • Principal Investigator Name
      • Proposal Department
      • Sponsor
      • Originating Sponsor
      • Purpose
      • UVM Rate Type
      • F&A Allowed?
      • Sponsor Rate
      • Multiple Principal Investigators?
      • Start and End Dates
      • Inflation Characteristics
      • Important Comments
    2. Personnel

      • Enter Personnel names
      • Select Role and Role Type from drop box
      • Enter Current Salary
      • Enter Effort %  for Sponsor Costs and for UVM Cost Share Commitments, if applicable
      • Enter Appointment Type (12,10,9 or 3 months)
      • Select Fringe Benefit Rate Type - the fringe benefit costs will auto-calculate for each year of the project based on blended rate across the fiscal years.
    3. Other Direct Costs

      • Enter other direct costs 
    4. Subcontracts

      1. Enter subcontract name(s)
      2. Enter subcontract(s) direct and indirect costs

    Instructions - Tab 2 - UVM Cost Share Commitments

    1. Select the responsible Cost Share Department for each item of cost share shown on Tab 1
    2. Describe each item of cost share.  For example, "John Smith salary cap cost share at 20%"
    3. Make sure the total equals the total on Tab 1 UVM Cost Share Commitments section

    Instructions - Tab 2 - Allocation of F&A Recovery 

    Customary Allocation of F&A Recovery will be 100% to the Proposal Department, unless this is a Multiple Principal Investigator proposal or unless a Deviation has been approved.   Customary Allocation of F&A recovery is described on the SPA web and is based on relative effort of all Principal Investigators.  Visit SPA web site page "Incentive Based Budgeting (IBB): Research and Indirect Cost Recovery Algorithm" for guidance.

    1. If the proposal IS NOT a Multiple PI Proposal, enter 100% for the Proposal Department. 
    2. If the proposal IS a Multiple PI Proposal, enter names of all Principal Investigators and Co-Principal Investigators.  Add more lines if necessary
    3. Select the Allocation Department for each Principal Investigator 
    4. Enter the total effort % for each year of the project
    5. The Total Allocation % should reflect the relative effort of all Principal Investigators across all years of the project
    6. If all the Deans involved wish to deviate from the customary allocation, they can do so in the red box to the right
    Once the SPA Budget Worksheet is completed and finalized, the SPA Research Administrator will convert the form from an excel document to a pdf document and will upload it to the Internal Documents Tab in InfoEd, where it will be available to Chairs and Deans in the route.

    Last modified January 02 2018 02:47 PM

    Contact UVM © 2018 The University of Vermont - Burlington, VT 05405 - (802) 656-3131