Attachment-08_Cost-Reimbursement-Budget-Worksheet

Date: 
09/13/2022
Document Text Version
Bitmap Bitmap
       
   
  volunteer_iowa_bug-April2011.jpg
 
               
               
This spreadsheet may be used for drafting your budget. You must enter your final budget directly into eGrants.                
                                 
The purpose of the budget worksheet is to serve as a tool for you as you draft your budget. The worksheet is formatted to show errors as a help. Enter your calculations and budget information for AMERICORPS/CNCS and Grantee share in the YELLOW cells below. This information can be entered into the eGrants budget narrative for your final application. The optional Match Replacement/State Allocation column in GREEN can be used to indicate other funds to be used as match to the AmeriCorps grant.  If awarded match replacement or state funding administered through Volunteer Iowa, programs will be required to complete the Budget Allocation form.

Cells in ORANGE or RED note a caution or error, see the "Note" for assistance with any orange/red cells. 
               
               
               
  Optional:            
                                 
Section I   AMERICORPS/ CNCS Share Grantee Share TOTAL   ARP Match Replacement/ State Allocation Note: use this optional column to note what portion of the grantee share you propose to come out of ARP match and/or a state allocation (such as Refugee RISE). The amount entered should not exceed the amount entered in column H.      
A. Personnel                        
Note: All staff members listed in this section under CNCS and/or Grantee Share are required to comply with the NSCHC requirements.                         
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
Section I.A Personnel Total   $0 $0 $0   $0            
                                 
B. Personnel Fringe Benefits                        
Note: If a fringe benefit amount is over 30%, please list covered items separately and justify the high cost. Holidays, leave, and similar vacation benefits are not included in the fringe.                        
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
Section I.B Personnel Fringe Benefits Total   $0 $0 $0   $0            
                                 
C.1 Staff Travel                        
Note: Required to budget at least $1250 for Volunteer Iowa required trainings- see list in Final Application Instructions and itemize costs for each training.                        
Travel to CNCS-Sponsored Meetings- N/A to Iowa AmeriCorps State Programs                        
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
Section I.C1 Staff Travel Total   $0 $0 $0   $0            
                                 
C.2. Member Travel (not applicable for planning grants)                        
        $0                
        $0                
        $0                
        $0                
        $0                
Section I.C2 Member Travel Total   $0 $0 $0   $0            
                                 
D. Equipment (not applicable for planning grants)                        
Note: Equipment is defined as tangible, non-expendable personal property having a useful life of more than one year AND an acquisition cost of $5,000 or more per unit.                        
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
Section I.D Equipment Total   $0 $0 $0   $0            
                                 
E. Supplies                        
Note: You must individually list any single item costing $1,000 or more. Except for safety equipment, you may only charge  member service gear to the federal share if it includes the AmeriCorps logo.                        
Member gear w/AmeriCorps logo (operational grants must include or explain how provided w/out grant funds)       $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
Section I.E Supplies Total   $0 $0 $0   $0            
                                 
F. Contracts & Consultants                        
Note: Daily rate must be included in the calculation. Do not list training or evaluation consultants here.                        
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
Section I.F Contracts & Consultants Total   $0 $0 $0   $0            
                                 
G.1 Staff Training                        
        $0                
        $0                
        $0                
        $0                
        $0                
Section I.G.1 Staff Training Total   $0 $0 $0   $0            
                                 
G.2. Member Training                        
        $0                
        $0                
        $0                
        $0                
        $0                
Section I.G.2 Member Training Total   $0 $0 $0   $0            
                                 
H. Evaluation                        
        $0                
        $0                
        $0                
        $0                
Section I.H Evaluation Total   $0 $0 $0   $0            
                                 
I. Other Program Operating Costs                        
Note: Must budget for National Service Criminal History Checks for all members & covered staff.                        
National service criminal history checks:       $0                
Required State Member Management system fee ($/member as established in RFA & Instructions)       $0     Note: Budgeted cost/member: #DIV/0!      
Required State Support & Monitoring fee ($/MSY and tiered fee as established in RFA & Instructions)       $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
        $0                
Section I.I Other Program Operating Costs Total WITH State Fee   $0 $0 $0   $0            
Section I Total           $0 $0 $0                
                                 
Section II: Member Costs (not applicable for planning grants)   AMERICORPS/ CNCS Share Grantee Share TOTAL                
Note: The living allowance must not exceed the minimum or maximum amounts per member as published in the NOFO.                        
A. Living Allowance  # Stipended # Non-Stipended Total Members             Minimum Maximum Budgeted      
Full-Time     0       $0     $17,600 $35,200 #DIV/0!      
Three-Quarter Time     0       $0     no minimum $24,640 #DIV/0!      
Half-Time     0       $0     no minimum $17,600 #DIV/0!      
Reduced Half-Time     0       $0     no minimum $13,376 #DIV/0!      
Quarter-Time      0       $0     no minimum $9,152 #DIV/0!      
Minimum-Time     0       $0     no minimum $7,392 #DIV/0!      
Abbreviated-Time     0       $0     no minimum $2,112 #DIV/0!      
    Total slots 0              
    Total MSYs 0             Note: Total MSYs must be at least 8.00, unless you have been granted a waiver to the MSY minimum or are requesting a micro grant. 
Section II.A Living Allowance   $0 $0 $0   $0
                                 
B. Member Support Costs                        
Note: The FICA must be 7.65% of total living allowance (unless FICA exempt).  For healthcare, show calculation of # members, # months, & monthly rate.                        
FICA (auto calculation of %) #DIV/0!       $0     Note: The FICA must be 7.65% of total living allowance (unless FICA exempt)
Workers Compensation (or AD&D), note rate:          $0                
Health Care:          $0     Note: Show the formula including number of members, number of months, and monthly rate.
Other Member Support Costs:         $0    
Section II.B Member Support Costs   $0 $0 $0   $0            
                                 
Section II Total   $0 $0 $0   $0            
                                 
Section III: Administrative/Indirect Costs   AMERICORPS/ CNCS Share Grantee Share TOTAL     Note: Use Admin. Costs tab to assist in calculating these amounts.
A: Corporation Fixed Percentage Method                    
If you are using a State or Federally Approved Indirect Cost Rate, do not enter amounts here, enter in B.             CNCS share may be < or = to 5.26% of CNCS I+II Max Amount Grantee Share should be 10.00% or less Max Amount
Corporation Fixed Amount   $0 $0 $0     $0 $0
Commission Fixed Amount-n/a to Iowa programs       $0         #DIV/0!     #DIV/0!
Section III.A Total   $0 $0 $0   $0            
                                 
B: Federally Approved Indirect Cost Rate Method                    
If you are using the Corporation Fixed Percentage Method, do not enter amounts here, enter in A.                          
Indirect Cost Rate using MTDC Method:* (enter Rate)         $0                
      CNCS share may be < or = to 5.26% Max Amount Maximum Grantee Share based on Rate Entered  
Corporation Fixed Amount       $0     $0  
Section III.B Total (enter totals in eGrants)   $0 $0 $0   $0     #DIV/0!      
                                 
Section III Total   $0 $0 $0   $0            
                                 
Budget Total           $0 $0 $0   $0 Note: the total amount of match entered here should be the same amount as the Source of Match total below.
                     
Match Percent   #DIV/0!       Note: Grantee share must meet minimum Match Requirements according to the match schedule.
AmeriCorps Funding Year 1,2,3 4 5 6 7 8 9 10+    
Match Requirements 24% 26% 30% 34% 38% 42% 46% 50%                
                      Note: The Cost per MSY must not exceed $23,000 or $26,000 for most cost reimbursement grants or full-time fixed amount grants, $800 or $1000 for Education Award Fixed Amount Grants, and $1000 for Professional Corps. See RFA for full list of allowable Cost per MSY. Max allowable is $28,800.
Cost per MSY #DIV/0!    
                     
Source of Match- Description       Classification Source Amount                
For each source of matching funds, enter the requested information.                          
                         
                         
                         
                         
                         
                         
Source of Match Total              $                -     Note: Source of Match total must equal Total Grantee Share of the budget.    
                           
Other Federal Funding   Yes/No          
Does your organization have experience directly managing other federal grants?     <- Select from drop down                  
                                 
Note: *These calculations assume the Modified Total Direct Costs (MTDC) method is used for the Federally Approved Indirect Cost Rate and are maximums if all amounts reported to Section I of the grant are eligible to have the indirect rate applied to them.  A manual calculation should be performed for maximum total CNCS and Grantee Share Administration and maximum for Section III.B if an organization with a federally approved indirect rate uses a base other than MTDC or if MTDC is used but certain amounts in Section I and II are not part of the base that the rate should be applied to.  In such a case, the formulas in the yellow cells in Section II Grantee Share should be disregarded, and the applicant should enter the appropriate numbers in place of the formulas.                
               
               
               
               
This worksheet is adapted from a form originally created by the OneStar Foundation of Austin, Texas.                

Printed from the website on January 29, 2023 at 12:35am.