EHHD Simple Budget Template 2022            
  Year 1 Year 2 Year 3 Year 4 Year 5 Total
Salaries            
Faculty    $        -  $        -      $         -
Benefits            -            -            -                 -
Faculty              -            -                 -
Benefits            -            -            -                 -
Professional              -            -                 -
Benefits            -            -            -                 -
Professional            
Benefits            
Graduate students              -            -                 -
Benefits            -            -            -                 -
Undergraduates              -            -                 -
Benefits            -            -            -                 -
Clerical            
Benefits            
Subtotal salaries            
Subtotal benefits            
Total Salary and Benefits            
             
Contracted Services  $        -  $        -  $        -  $        -  $        -             -
Publication                       -
Communications & Supplies            -            -            -            -            -             -
Travel - Domestic            -            -            -            -            -             -
Travel - Foreign            -            -            -            -            -             -
Repairs and Maintenance                       -
             
MODIFIED TOTAL DIRECT COSTS            
                        -
Equipment                       -
Awards                       -
Participant Support            
Stipend                       -
Travel                       -
Sustenance                       -
Other                       -
                        -
                        -
Total Direct Costs (TDC)            
Facilities & Administration (Indirect Costs)            
Total Costs            
             
COLA 1.02          
F&A RATE 0.44          
BENEFITS:            
FACULTY 37% we recommend using the “MSU-paid Benefits Computation” 
POST-DOC 35% worksheet at http://www.montana.edu/hr/benicalc.html for final 
GRADUATE 1% benefits numbers for part-time or low-paid staff.
UNDERGRADUATE 1% 9% if fewer than 6 credits
CLERICAL 47%          
             
EHHD Budget Template Directions            
             
1. The benefits formula uses the percent-of-salary fractions shown in the dark purple print at the bottom of the page. If you need to add salary lines, be sure to add Benefits row formulas as well. 
       
2. Separate spreadsheets are provided (as you'll see on the tabbed line at the bottom of the page) to help you come up with the amounts that belong in the Template budget, since often the amounts for "Contracted Services," "Communications," "Travel," "Materials & Supplies," and "Subcontracts" are composite figures.
 
You will note that the cells on the "Budget Overview" (primary) spreadsheet for those items refer to the sums set to calcuate on the spreadsheets that feed into the primary spreadsheet.  Again, be sure that if you add rows to any of these sub-sheets, that the summary formulas reflect all the entries. 
 
3. You'll see that "direct costs" on the spreadsheet are divided between "Modified Total Direct Costs" and the "non-MTDC" total, which includes tuition payments for graduate students, and costs and stipends for "participants" (e.g. research subjects or community partners).   This is because the latter budget items are exempted from the total on which F&A are figured as a percentage. So on this budget spreadsheet, the F&A are figured on the Modified Total Direct Costs, and then the total sums both types of Direct costs plus Indirect costs.  
 
4. F&A can be charged only on the first $25,000 in a subcontracted (subaward) portion of a grant.  So when a subcontract adds up to more than $25,000 in a year no additional IDCs are charged to the granting agency for the extra increment of the subcontract.  So, if you have a subcontract that amounts to more than $25,000 in a given year, be sure to change the formula so that the under-25,000 fragmentand the over-25,000 fragments are entered on the apppropriate lines.    
     
5. If you are planning a muli-year grant, you may want to build an annual "cost-of-living" (COLA) increase onto out-year salaries.  The built-in formula for salaries in Years 2-5 multiplies the previous year's salary by the COLA rate shown in cell B47.  So if you want to assume 3% salary increases each year, you should change the figure in the COLA row to 1.03.  Even though MUS policy may not allow the increases you budget for, it's a good idea to build in the cushion just in case!
       
6. The MSU "F&A" or "IDC" rate can vary according to the type of activity funded.  These rates are noted on Sponsored Programs' Information Sheet.  In addition, granting agencies may vary their Indirect Cost (AKA "Overhead," or "Facilities & Administration") rates.  If the IDC rate for your project is other than 42.5%, be sure to change the figure in "F&A RATE" row accordingly to ensure the proper IDCs are calculated in this budget.