Attachment-08_Cost-Reimbursement-Budget-Worksheet

Date:

09/13/2022

Document File:

attachment-08_cost-reimbursement-budget-worksheet.xlsx

Document Text Version

Bitmap

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.

Section I.A Personnel Total

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.

Section I.B Personnel Fringe Benefits Total

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

Section I.C1 Staff Travel Total

C.2. Member Travel (not applicable for planning grants)

Section I.C2 Member Travel Total

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.

Section I.D Equipment Total

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)

Section I.E Supplies Total

F. Contracts & Consultants

Note: Daily rate must be included in the calculation. Do not list training or evaluation consultants here.

Section I.F Contracts & Consultants Total

G.1 Staff Training

Section I.G.1 Staff Training Total

G.2. Member Training

Section I.G.2 Member Training Total

H. Evaluation

Section I.H Evaluation Total

I. Other Program Operating Costs

Note: Must budget for National Service Criminal History Checks for all members & covered staff.

National service criminal history checks:

Required State Member Management system fee ($/member as established in RFA & Instructions)

Note: Budgeted cost/member:

#DIV/0!

Required State Support & Monitoring fee ($/MSY and tiered fee as established in RFA & Instructions)

Section I.I Other Program Operating Costs Total WITH State Fee

Section I Total

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

$17,600

$35,200

#DIV/0!

Three-Quarter Time

no minimum

$24,640

#DIV/0!

Half-Time

no minimum

$17,600

#DIV/0!

Reduced Half-Time

no minimum

$13,376

#DIV/0!

Quarter-Time

no minimum

$9,152

#DIV/0!

Minimum-Time

no minimum

$7,392

#DIV/0!

Abbreviated-Time

no minimum

$2,112

#DIV/0!

Total slots

Total MSYs

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

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!

Note: The FICA must be 7.65% of total living allowance (unless FICA exempt)

Workers Compensation (or AD&D), note rate:

Health Care:

Note: Show the formula including number of members, number of months, and monthly rate.

Other Member Support Costs:

Section II.B Member Support Costs

Section II Total

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

Commission Fixed Amount-n/a to Iowa programs

#DIV/0!

#DIV/0!

Section III.A Total

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)

CNCS share may be < or = to 5.26%

Max Amount

Maximum Grantee Share based on Rate Entered

Corporation Fixed Amount

Section III.B Total (enter totals in eGrants)

#DIV/0!

Section III Total

Budget Total

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

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.

You are here

Attachment-08_Cost-Reimbursement-Budget-Worksheet