Form 1 - Excel Version 1 - Excel Version Tribal Budget and Narrative Justification Template - Exc

Tribal Budget and Narrative Justification Template

Tribal Budget and Narrative Justification Template - Excel_2026_Revised for NFS.xlsx

Tribal Budget and Narrative Justification – Excel

OMB: 0970-0548

Document [xlsx]
Download: xlsx | pdf

Overview

TAB-1_INSTRUCTIONS
TAB-2_BUDGET BASICS
TAB-3_CHECKLIST
TAB-4_SAMPLE BUDGET WORKSHEET
TAB-5_BUDGET WORKSHEET
TAB-6_BUDGET AT-A-GLANCE
TAB-7_SF-424A


Sheet 1: TAB-1_INSTRUCTIONS

TRIBAL IV-D BUDGET DEVELOPMENT
INSTRUCTIONS FOR USING THE WORKSHEETS

1. Use Complete and Accurate Calculations: Gather all the necessary information you'll need prior to starting work on the budget (i.e., positions, wages, fringe calculations, supplies needed, etc. Refer to Tab-4_Sample Budget for examples).

2. Review Each Worksheet. This workbook was designed to give you an easy format to develop your budget.
Please read the information in each tab before you begin completing this workbook.

3. Budget Workbook Template:
In addition to this tab, the workbook includes:
- Tab-2_Budget Basics has helpful information for budget preparation.
- Tab-3_Checklist is a tool to ensure you have all the required documents for your budget submission. Check items off as you complete them.
- Tab-4_Sample Budget Worksheet gives you examples of how your budget line items should look.
- Tab-5_Budget Worksheet is the worksheet you can use to develop your annual budget.
- Tab-6_Budget-At-A-Glance auto-populates with the data you entered into Tab-5. It is designed to give you an overall summary of your budget.
- Tab-7_SF-424A auto-populates with the data you entered into Tab-5 .
Each worksheet is locked to reduce errors in calculations. The password to un-protect each worksheet is: 12345



Comment Box Instructions: Throughout the workbook are comment boxes that include additional directions for your convenience. Cells that have a small red triangle in the corner indicate there is a comment box attached. Hover your curser over the cell to see the comment.


Tab-5_Budget Worksheet:
- Cells highlighted in light yellow are unprotected to allow you to enter your information and tab through the worksheet.
- The worksheet includes free-form text areas where you can enter your justification narratives. This eliminates the need to create a separate justification narrative in a Word document.
- Many cells include formulas that will calculate amounts for you. This reduces errors because if you change an amount in one cell, all connected cells and worksheets will update also.
- All line items are in order to coincide with the SF-424A.


Tab-6_Budget-At-A-Glance:
This worksheet provides a summary of your Total Budget. It displays a break-down of:
- Total funds you are requesting
This easy-to-read summary can be used when you're discussing your budget with your tribal budget committees or tribal council.


Tab-7_SF-424A was added for your convenience. It auto-populates with all the budget information you entered in Tab-5_Budget Worksheet.
You can print this page and use it to copy the data into GrantSolutions, confident that all calculations are accurate and complete.

4. Initial Budget. Download the Tribal Budget Excel Workbook from the Tribal Budget Toolbox on the OCSS website and "Save As" TRIBAL BUDGET TEMPLATE. Open the file and do another "Save As" this time saving it as FFY(budget year)_BUDGET. Create your budget in the Tab-5_Budget Worksheet.


STEP 1: Create your total tribal child support program budget by filling in the appropriate fillable (yellow) cells in Columns A through H for each cost category. The worksheet includes formulas to auto-popluate the bottom of Column I indicating the amount of federal funding you are requesting.


STEP 2: Login to GrantSolutions. Enter numbers from Tab 7 in the 424A form online. Upload supporting documentation, including this Excel document, contracts, and your current Indirect Cost Rate agreement. Submit.

5. Budget Submission:
Your budget submission to OCSS must include Tab-5_Budget Worksheet, Tab-6_Budget-At-A-Glance, and Tab-7_SF-424A.
If you are using GrantSolutions, please delete all other tabs (Tab-1, Tab-2, Tab-3, and Tab-4) and upload the revised workbook into GrantSolutions. (To delete tabs, place your curser on the tab name, right click, and click delete).
If you are not using GrantSolutions, please print the worksheets in Tab-5, Tab-6 and Tab-7 to include in your budget packet.

6. Subsequent Budgets. After you have developed an initial budget using this Excel workbook, you can simply update it each consecutive year, saving you a lot of time. Using a standard naming format each year will allow you to create a library of budget files that will be easy to find when needed for future reference. (i.e., FFY14_Start-Up Budget_Year 1; FFY15_Start-Up Budget_Year2; FFY16_Budget; FFY16_Budget_Revision; etc.).


STEP 1: When budget time rolls around, open your budget from the previous year and do a "Save As", naming the workbook with the new Federal Fiscal Year (FFY). Example: FFY19_Budget


STEP 2: Update each expense and justification as needed. For example, you can update the wage for a particular staff position without having to change anything else, like the narrative, thus saving a lot of time.

PAPERWORK REDUCTION ACT OF 1995 (Pub. L. 104-13) STATEMENT OF PUBLIC BURDEN: The purpose of this information collection is to assist tribal child support programs in developing their annual budget through this optional form. Public reporting burden for this collection of information is estimated to average 16 hours per grantee, including the time for reviewing instructions, gathering and maintaining the data needed, and reviewing the collection of information. This is a voluntary collection of information. An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information subject to the requirements of the Paperwork Reduction Act of 1995, unless it displays a currently valid OMB control number. If you have any comments on this collection of information, please contact OCSS Division of Regional Operations at [email protected].

Sheet 2: TAB-2_BUDGET BASICS

TRIBAL IV-D BUDGET DEVELOPMENT
BUDGET BASICS


1. Federal Fiscal Year (FFY): Federal funding is awarded on a federal fiscal year cycle that begins October 1 and ends on September 30 each year.
2. Allowable Costs: All budget expenditures must comply with the requirements in 45 CFR 309.145 and 45 CFR 75 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for HHS Awards.
3. Start-Up Budgets: Start-Up Applications can be submitted at any time during the year. Your initial budget should be calculated beginning with the first day of the month in the quarter for which you anticipate being awarded funding and ending on the last day of the 12th month.

a. 100% Federal Funding: Start-Up programs are awarded 100% federal funding for the two-year project period.


b. Start-Up Budget up to $500,000: Start-Up program budgets cannot exceed $500,000 for two years. Note: Each year's budget should not exceed $250,000.

c. Transition to Comprehensive: Prior to the end of your Start-Up program, you must submit a Comprehensive Program Plan (Plan) that includes an annual budget and budget justification narrative. The time period for your Plan's annual budget will depend on when you anticipate transitioning to a comprehensive program. Starting out, your first comprehensive budget might not be on the federal fiscal year cycle.
4. Comprehensive Program Plan Budgets: When it is time to transition from a Start-Up program to a comprehensive IV-D program, you must submit a comprehensive program budget and budget justification narrative. Pursuant to 45 CFR 309.135(2), your budget can be for less than one year, but at least six months, or more than one year, not to exceed 17 months, to get transitioned onto the federal fiscal year cycle.

a. 100% Federal Funding: Comprehensive programs are awarded 100% federal funding.

b. Annual Budget Submissions: Pursuant to 45 CFR 309.130(b)(2), an annual budget must be submitted each year no later than August 1.
5. More Information is available on OCSS's website:

https://www.acf.hhs.gov/css/training-technical-assistance/tribal-child-support-budget-toolbox

Sheet 3: TAB-3_CHECKLIST

TRIBAL IV-D BUDGET DEVELOPMENT











ANNUAL BUDGET CHECKLIST







Pursuant to 45 CFR 309.125, the application (Start-Up and Comprehensive) must include a proposed budget and budget justification narrative.
Comprehensive Program budgets must be submitted to OCSS annually no later than AUGUST 1.

The checklist includes a list of documents required pursuant to 45 CFR 309.15 (Initial Application) and 309.130 (Comprehensive) and a list of documents recommended by OCSS. As you complete each requirement, you can cross it off the list by placing an "X" in the cells highlighted in yellow.



1. COVER LETTER (RECOMMENDED)

2. COVER SHEET (OPTIONAL)

3. TABLE OF CONTENTS (OPTIONAL)

4. STANDARD FORM (SF) 424: "Application for Federal Assistance" to be submitted with the initial grant application for funding under §309.65(a) and (b) (60 days prior to the start of the funding period).

5. STANDARD FORM (SF) 424A: "Budget Information, Non-construction Programs", to be submitted annually, no later that August 1 (60 days prior to the start of the funding period) in accordance with §309.115(a)(2) of this part. TAB-7_SF-424A auto-populates a SF-424A form for your convenience. With EACH submission the following information MUST be included:

6. QUARTER-BY-QUARTER ESTIMATE of expenditures for the funding period.

7. BUDGET JUSTIFICATION NARRATIVE

8. SUPPORTING DOCUMENTATION INCLUDED AS ATTACHMENTS:


a. Current Indirect Cost Agreement


b. Contracts


c. IT specifications (if applicable)


d. Other documentation as applicable











Pursuant to 45 CFR 309.15(c), following the initial funding period, the tribe or tribal organization operating a IV-D program must submit annually a Standard Form (SF) 424A, including all the necessary accompanying information and documentation described in paragraphs (a)(2) and (a)(3) of the section. Tab-7 is a SF-424A form that auto-populates using the information you enter into Tab-5_Budget Worksheet. You can print this page and use it to enter the data into GrantSolutions.

Sheet 4: TAB-4_SAMPLE BUDGET WORKSHEET

SAMPLE: BUDGET WORKSHEET & JUSTIFICATION NARRATIVE (START-UP OR COMPREHENSIVE)










Tribe Name: TRIBAL NATION NAME
Federal Fiscal Year: INSTRUCTIONS: Enter the Federal Fiscal Year in this cell. FFY25

Federal Share: 100%






LINE ITEMS (Calculations) QTR 1 QTR 2 QTR 3 QTR 4 TOTAL










PERSONNEL: Annual Hours Wage/ Hour Total Salary





INSTRUCTIONS: List all the personnel positions in this column IV-D Director INSTRUCTIONS: Enter the total annual hours that will be worked for each position in this column 2080 INSTRUCTIONS: Enter the hourly wage amount for each position in this column If a position is salaried, you must convert the annual salary amount to an hourly amount by dividing the annual salary by 2080 hours. Then enter that hourly amount in this column. $37.00 $76,960.00 $19,240.00 $19,240.00 $19,240.00 $19,240.00 $76,960.00
Admin Asst 2080 $13.50 $28,080.00 $7,020.00 $7,020.00 $7,020.00 $7,020.00 $28,080.00
CS Specialist 2080 $16.00 $33,280.00 $8,320.00 $8,320.00 $8,320.00 $8,320.00 $33,280.00
CS Specialist 2080 $17.00 $35,360.00 $8,840.00 $8,840.00 $8,840.00 $8,840.00 $35,360.00
Financial Specialist 2080 $18.00 $37,440.00 $9,360.00 $9,360.00 $9,360.00 $9,360.00 $37,440.00
CS Attorney 1040 $65.00 $67,600.00 $16,900.00 $16,900.00 $16,900.00 $16,900.00 $67,600.00
Total FTEs 5.5







TOTAL PERSONNEL:
$278,720.00 $69,680.00 $69,680.00 $69,680.00 $69,680.00 $278,720.00
IV-D Director INSTRUCTIONS: Enter text to briefly describe the roles and responsibilities for each position listed. The IV-D Director is responsible for the day-to-day operations of the child support program. Duties include, but are not limited to: supervision and training of staff; coordinating the collection and reporting of all child support data for federal and tribal reports; development and submission of program budgets; and representing the program at various meetings and conferences.






Admin Asst





CS Specialist





CS Specialist







Financial Specialist







CS Attorney















FRINGE:
INSTRUCTONS: Please use this row if your tribe uses a lump-sum percentage for calculating Fringe. Then leave the following rows blank. Lump Sum of Fringe: INSTRUCTIONS: Enter the lump-sum percentage amount, in this cell, that your tribe uses to calcuate Fringe. 0.00% of salaries $- $- $- $- $-
INSTRUCTIONS: If your Tribe breaks down Fringe Benefits by percentage, insert the details in these cells FICA INSTRUCTIONS: Enter the percentage amount your tribe uses for FICA in this cell 4.25% of salary 2,961.40 2,961.40 2,961.40 2,961.40 11,845.60
SUTA INSTRUCTIONS: Enter the percentage amount your tribe uses for SUTA in this cell 5.75% of salary 4,006.60 4,006.60 4,006.60 4,006.60 16,026.40
Medicare INSTRUCTIONS: Enter the percentage amount your tribe uses for Medicare in this cell 1.45% of salary 1,010.36 1,010.36 1,010.36 1,010.36 4,041.44
Workman's Comp INSTRUCTIONS: Enter the percentage amount your tribe uses for Workmans's Comp in this cell 3% of salary 2,090.40 2,090.40 2,090.40 2,090.40 8,361.60
Retirement/401K INSTRUCTIONS: Enter the percentage amount your tribe uses for retirement/401Ks in this cell 6% of salary 4,180.80 4,180.80 4,180.80 4,180.80 16,723.20

Amt/Yr # of staff





Health Insur/Single INSTRUCTIONS: Enter the annual amount for Single Health insurance for 1 person in this cell. $80.00 INSTRUCTIONS: Enter the number of FTE's for each benefit received in this column. 2.75 55.00 55.00 55.00 55.00 220.00
Health Insur/Family INSTRUCTIONS: Enter the annual amount for Family Health insurance for 1 person in this cell. $180.00 3.6 162.00 162.00 162.00 162.00 648.00
Life Insurance INSTRUCTIONS: Enter the annual amount for Life insurance for 1 person in this cell. $38.00 6.35 60.33 60.33 60.33 60.33 241.30
Disability Insurance INSTRUCTIONS: Enter the annual amount for Disability insurance for 1 person in this cell. $250.00 6.35 396.88 396.88 396.88 396.88 1,587.50
TOTAL FRINGE:
14,923.76 14,923.76 14,923.76 14,923.76 59,695.04








TRAVEL:
INSTRUCTIONS: Enter text to indicate the source of the travel estaimate calculations. (i.e., Airline websites, Travelocity, Kayak, etc.) GENERAL COMMENTS: All travel costs were estimated using Federal Per Diem rates and current airline and lodging rates from individual websites and/or Travelocity.com.










INSTRUCTIONS: Enter the name of each conference, meeting or event to be attended in the high-lighted cells in column A. NTCSA INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) 6 staff x lodging, airfare & per diem INSTRUCTIONS: Enter the cost of the total estimated travel for each event in the cell under the quarter that the travel will occur. $- $9,700.00 $- $- $9,700.00
INSTRUCTIONS: Enter the location of the conference, meeting or event in this cell. Tulalip, WA The NTCSA Annual conference will be in Tulalip, WA June 26-30, 2016. 5 child support staff plus the asscociate judge will attend this important training event to learn new child support information and skills.
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. June 26 - 29, 2016










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT:
$- $- $- $- $-
INSTRUCTONS: Enter the location of the conference, meeting or event in this cell. LOCATION:

INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:










TOTAL TRAVEL:
$- $9,700.00 $- $- $9,700.00








EQUIPMENT:
INSTRUCTIONS: Enter the type of equipment to be purchased in the high-lighted cells in column A. Only add items here if the purchase of the 1 item is equal to or more than $7,000 Server
$- $7,000.00 $- $- $7,000.00











$-





TOTAL EQUIPMENT
$- $7,000 $- $- $7,000








SUPPLIES: (Consumable Office Supplies)
INSTRUCTIONS: If applicable, list the type of supplies to be purchased in column A. General Office Supplies INSTRUCTIONS: Enter a brief description of how costs are calculated, if applicable. File folders, pens, notepads, pencils, post-it notes INSTRUCTIONS: Enter the estimated costs per Quarter in the appropriate cells for each cost listed. $500.00 $500.00 $500.00 $500.00 $2,000.00
Toner
$1,000.00 $1,000.00 $1,000.00 $1,000.00 $4,000.00
Computer Ink
$2,000.00 $2,000.00 $2,000.00 $2,000.00 $8,000.00


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-
TOTAL SUPPLIES:
$500.00 $500.00 $500.00 $500.00 $14,000.00








CONTRACTUAL:
INSTRUCTIONS: List titles of all contracts in the high-lighted cells in column A. DNA Contract INSTRUCTIONS: Enter a brief description of how costs are calculated, if applicable. You must include a copy of the signed contract. Indicate the number/letter of the attachment in this space also. 8 paternity cases x 3 participants x $35 per participant = $840
Draft (Signed) contract is in Attachment A.
INSTRUCTIONS: Enter the estimated costs per Quarter in the appropriate cells for each cost listed. $210.00 $210.00 $210.00 $210.00 $840.00







$- $- $- $- $-





TOTAL CONTRACTUAL:
$210.00 $210.00 $210.00 $210.00 $840.00








OTHER:
INSTRUCTIONS: List all "Other" anticipated expenses in the highlighted cells in column A. Phones INSTRUCTIONS: Enter a brief description of how costs were calculated. 5 phones x $60/mo x 12 mo = $3,600 INSTRUCTIONS: Enter the estimated costs per Quarter in the appropriate cells for each cost listed. $900.00 $900.00 $900.00 $900.00 $3,600.00
Fax 1 fax x $60/mo x 12 mo = $720 $180.00 $180.00 $180.00 $180.00 $720.00
Postage Estmiated postage for mailing letters. All postage is paid by the tribe's general account. $125.00 $125.00 $125.00 $125.00 $500.00
MTS maintenance We have an intra-agency agreement with the tribal IT dept. to do routine maintenance on our MTS. $2,500.00 $2,500.00 $2,500.00 $2,500.00 $10,000.00
Tribal Process Server 50 cases x $40 per service = $2,000 $500.00 $500.00 $500.00 $500.00 $2,000.00
Filing Fees/Tribal Court 100 case/yr x $45/case =$4,500
$1,125.00 $1,125.00 $1,125.00 $1,125.00 $4,500.00
Maintenance General cleaning & maintenance $300.00 $300.00 $300.00 $300.00 $1,200.00
TOTAL OTHER:
$5,630.00 $5,630.00 $5,630.00 $5,630.00 $22,520.00








TOTAL DIRECT COSTS
$90,943.76 $107,643.76 $90,943.76 $90,943.76 $392,475.04
INDIRECT COSTS INSTRUCTIONS: Enter the approved IDC rate in the high-lighted cell in column B. Apply the rate according to your Indirect Cost Rate Agreement, divide the total by four quarters. This example applies .30 * personnel cost excluding fringe 30%
$20,904.00 $20,904.00 $20,904.00 $20,904.00 $83,616.00
TOTALS:
$111,847.76 $128,547.76 $111,847.76 $111,847.76 $476,091.04
















Total Budget:
INSTRUCTIONS: This is the TOTAL PROPOSED BUDGET AMOUNT. $476,091.04

Sheet 5: TAB-5_BUDGET WORKSHEET

BUDGET WORKSHEET & JUSTIFICATION NARRATIVE (START-UP OR COMPREHENSIVE)










Program Name: INSTRUCTIONS: Enter the name of the Tribal program in this cell.

Federal Fiscal Year: INSTRUCTIONS: Enter the Federal Fiscal Year in this cell.


Federal Share: 100%






LINE ITEMS (Calculations) QTR 1 QTR 2 QTR 3 QTR 4 TOTAL










PERSONNEL: Annual Hours Wage/ Hour Total Salary





INSTRUCTIONS: List all the personnel positions in this column
INSTRUCTIONS: Enter the total annual hours that will be worked for each position in this column 0 INSTRUCTIONS: Enter the hourly wage amount for each position in this column. If a position is salaried, you must convert the annual salary amount to an hourly amount by dividing the annual salary by 2080 hours. Then enter that hourly amount in this column. $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-

0 $- $- $- $- $- $- $-
Total FTEs 0







TOTAL PERSONNEL:
$- $- $- $- $- $-
- INSTRUCTIONS: Enter text to briefly describe the roles and responsibilities for each position listed.







-







-







-







-







-







-







-







-







-







-







-







-















FRINGE:
INSTRUCTIONS: Please use this row if your tribe uses a lump-sum percentage for calculating Fringe. Then leave the following rows blank. Lump Sum of Fringe: INSTRUCTIONS: Enter the lump-sum percentage amount, in this cell, that your tribe uses to calcuate Fringe. 0.00% of salaries $- $- $- $- $-
INSTRUCTIONS: If your Tribe breaks down the Fringe cost by percentage, enter the details here FICA INSTRUCTIONS: Enter the percentage amount your tribe uses for FICA in this cell 0.00% of salaries $- $- $- $- $-
SUTA INSTRUCTIONS: Enter the percentage amount your tribe uses for SUTA in this cell 0.00% of salaries $- $- $- $- $-
Medicare INSTRUCTIONS: Enter the percentage amount your tribe uses for Medicare in this cell 0.00% of salaries $- $- $- $- $-
Workman's Comp INSTRUCTIONS: Enter the percentage amount your tribe uses for Workmans's Comp in this cell 0.00% of salaries $- $- $- $- $-
Retirement/401K INSTRUCTIONS: Enter the percentage amount your tribe uses for retirement/401Ks in this cell 0.00% of salaries $- $- $- $- $-

0% # of staff





Health Insur/Single INSTRUCTIONS: Enter the annual amount for Single Health insurance for 1 person in this cell. $- INSTRUCTIONS: Enter the number of FTE's for each benefit received in this column. 0 $- $- $- $- $-
Health Insur/Family INSTRUCTIONS: Enter the annual amount for Family Health insurance for 1 person in this cell. $- 0 $- $- $- $- $-
Life Insurance INSTRUCTIONS: Enter the annual amount for life insurance for 1 person in this cell. $- 0 $- $- $- $- $-
Disability Insurance INSTRUCTIONS: Enter the annual amount for disability insurance for 1 person in this cell. $- 0 $- $- $- $- $-
TOTAL FRINGE:
$- $- $- $- $-








TRAVEL:

INSTRUCTIONS: Enter text to indicate the source of the calculations (i.e., Airline websites, Travelocity, Kayak, etc.). GENERAL COMMENTS:










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT: INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) NUMBER OF STAFF ATTENDING: INSTRUCTIONS: Enter the cost of the total estimated travel for each event in the cell under the quarter that the travel will occur. $- $- $- $- $-
INSTRUCTONS: Enter the location of the conference, meeting or event in this cell. LOCATION: INSTRUCTIONS: Enter the justification narrative for this travel in this section. NARRATIVE:
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT: INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) NUMBER OF STAFF ATTENDING: $- $- $- $- $-
LOCATION: NARRATIVE:
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT: INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) NUMBER OF STAFF ATTENDING: $- $- $- $- $-
LOCATION: NARRATIVE:
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT: INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) NUMBER OF STAFF ATTENDING: $- $- $- $- $-
INSTRUCTONS: Enter the location of the conference, meeting or event in this cell. LOCATION: NARRATIVE:
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT: INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) NUMBER OF STAFF ATTENDING: $- $- $- $- $-
INSTRUCTONS: Enter the location of the conference, meeting or event in this cell. LOCATION: NARRATIVE:
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT: INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) NUMBER OF STAFF ATTENDING: $- $- $- $- $-
INSTRUCTONS: Enter the location of the conference, meeting or event in this cell. LOCATION: NARRATIVE:
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT: INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) NUMBER OF STAFF ATTENDING: $- $- $- $- $-
INSTRUCTONS: Enter the location of the conference, meeting or event in this cell. LOCATION: NARRATIVE:
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT: INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) NUMBER OF STAFF ATTENDING: $- $- $- $- $-
INSTRUCTONS: Enter the location of the conference, meeting or event in this cell. LOCATION: NARRATIVE:
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT: INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) NUMBER OF STAFF ATTENDING: $- $- $- $- $-
INSTRUCTONS: Enter the location of the conference, meeting or event in this cell. LOCATION: NARRATIVE:
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT: INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) NUMBER OF STAFF ATTENDING: $- $- $- $- $-
INSTRUCTONS: Enter the location of the conference, meeting or event in this cell. LOCATION: NARRATIVE:
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT: INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) NUMBER OF STAFF ATTENDING: $- $- $- $- $-
INSTRUCTONS: Enter the location of the conference, meeting or event in this cell. LOCATION: NARRATIVE:
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT: INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) NUMBER OF STAFF ATTENDING: $- $- $- $- $-
INSTRUCTONS: Enter the location of the conference, meeting or event in this cell. LOCATION: NARRATIVE:
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:










INSTRUCTIONS: Enter the name of the conference, meeting or event in this cell. NAME OF EVENT: INSTRUCTIONS: Enter the number of staff attending and what costs will be incurred (i.e., lodging, airfare, per diem, rental cars, etc.) NUMBER OF STAFF ATTENDING: $- $- $- $- $-
INSTRUCTONS: Enter the location of the conference, meeting or event in this cell. LOCATION: NARRATIVE:
INSTRUCTIONS: Enter the date(s) of the conference, meeting or event in this cell. DATES:
TOTAL TRAVEL:
$- $- $- $- $-








EQUIPMENT:
INSTRUCTIONS: Enter the type of equipment to be purchased in the highlighted cells in column A.

$- $- $- $- $-

INSTRUCTIONS: Enter a brief justification narrative in this section.





$- $- $- $- $-





TOTAL EQUIPMENT
$- $- $- $- $-








SUPPLIES: (Consumable Office Supplies)
INSTRUCTIONS: If applicable, list the type of supplies to be purchased in column A.
INSTRUCTIONS: Enter a brief description of how costs are calculated, if applicable.
INSTRUCTIONS: Enter the estimated costs per quarter in the appropriate cells for each cost listed. $- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-
TOTAL SUPPLIES:
$- $- $- $- $-








CONTRACTUAL:
INSTRUCTIONS: List titles of all contracts in the highlighted cells in column A.
NSTRUCTIONS: Enter a brief description of how costs are calculated, if applicable.
INSTRUCTIONS: Enter the estimated costs per quarter in the appropriate cells for each cost listed. $- $- $- $- $-

INSTRUCTIONS: Enter the justification narrative in this section.




$- $- $- $- $-






$- $- $- $- $-






$- $- $- $- $-






$- $- $- $- $-




TOTAL CONTRACTUAL:
$- $- $- $-









OTHER:
INSTRUCTIONS: List all "Other" anticipated expenses in the highlighed cells in column A.
INSTRUCTIONS: Enter a brief description of how costs were calculated.
INSTRUCTIONS: Enter the estimated costs per quarter in the appropriate cells for each cost listed. $- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-


$- $- $- $- $-
TOTAL OTHER:
$- $- $- $-











TOTAL DIRECT COSTS
$- $- $- $- $-
INDIRECT COSTS INSTRUCTIONS: Enter the approved IDC rate in the high-lighted cell in column B. And calculate the total indirect costs needed divided by 4 quarters. 0.00%
$- $- $- $-

TOTALS:
$- $- $- $- $-
















Total Budget:
INSTRUCTIONS: This is the TOTAL PROPOSED BUDGET AMOUNT. $-

Sheet 6: TAB-6_BUDGET AT-A-GLANCE

Program Name:

Federal Fiscal Year:

Federal Share: 100%
BUDGET AT-A-GLANCE




Object Class Categories THIS IS YOUR TOTAL BUDGET

$
PERSONNEL $-
FRINGE $-
TRAVEL $-
EQUIPMENT $-
SUPPLIES $-
CONTRACTUAL $-
OTHER $-


TOTALS DIRECT CHARGES: $-
INDIRECT COSTS $-


TOTAL BUDGET $-

































Sheet 7: TAB-7_SF-424A

INSTRUCTIONS: PLEASE REVIEW THE SF 424A INSTRUCTIONS AS YOU COMPLETE THE FORM IN GRANTSOLUTIONS. A LINK IS LOCATED AT THE BOTTOM OF THIS SHEET. BUDGET INFORMATION - Non-Construction Programs OMB Approval No. 0348-0044
DESCRIPTION: This reproduction of SF-424A was designed to auto-populate based on the information the User enters into the workbook in Tab-5_Budget Worksheet. For complete instructions for completing the SF- 424A, please refer to the Intructions for the SF-424A published by OMB and available on the OCSE website. SECTION A - BUDGET SUMMARY
Grant Program Function or Activity
(a)
Catalog of Federal Domestic Assistance Number
(b)
Estimated Unobligated Funds New or Revised Budget
Federal
(c)
Non-Federal
(d)
DESCRIPTION: This cell auto-populates the federal share based on the percentage of the Total Budget from Tab-5_Budget Worksheet. Federal
(e)
Non-Federal
(f)
Total
(g)
1. Child Support:
Federal Share
93.563 $- $- $- $- $-

INSTRUCTIONS: You must enter this number into the correlating cell in GrantSolutions.





3.




$-
4.




$-
5. Totals
$- $- $- $- $-
SECTION B - BUDGET CATEGORIES
6. Object Class Categories
GRANT PROGRAM, FUNCTION OR ACTIVITY DESCRIPTION: This column displays the TOTAL of each Object Class Category of the budget. It is NOT a total of columns (1) plus (2) across. Total
(5)
DESCRIPTION: This column auto-populates the percentage of the federal share for each Object Class Category entered in Tab-5_Budget Worksheet. (1) Federal Share (2) (3) (4)
a. Personnel $- $- $- $- $-
b. Fringe Benefits $- $- $- $- $-
c. Travel $- $- $- $- $-
d. Equipment $- $- $- $- $-
e. Supplies $- $- $- $- $-
f. Contractual $- $- $- $- $-
g. Construction
$- $- $- $-
h. Other $- $- $- $- $-
i. Total Direct Charges (sum of 6a-6h) $- $- $- $- $-
j. Indirect Charges $- $- $- $- $-
k. TOTALS (sum of 6i and 6j) $- $- $- $- $-

INSTRUCTIONS: Enter the estimated amount of income, if any, expected to be generated from this project. Do not add or subtract this amount from the total project amount. Show under the program narrative statement the nature and source of income. The estimated amount of program income may be considered by the federal grantor agency in determining the total amount of the grant. 7. Program Income $- $- $- $- $-
Authorized for Local Reproduction Standard Form 424A (Rev. 7-97)
Previous Edition Usable
SF 424A & INSTRUCTIONS
Prescribed by OMB Circular A-102
SECTION C - NON-FEDERAL RESOURCES
(a) Grant Program (b) Applicant (c) State (d) Other Sources (e) TOTALS
8. - - - -
9. - - - -
10. - - - -
11. - - - -
12. TOTAL (sum of lines 8 - 11) - - - -
DESCRIPTION: This section auto-populates with information entered IN Tab-5_Budget Worksheet. Pursuant to 45 CFR 309.130(b)(2)(i). SECTION D - FORECASTED CASH NEEDS
13. Federal Total for 1st Year INSTRUCTIONS: If you are using GrantSolutions, it will auto-populate the amounts for each of theses quarters by "quartering" the amount you enter in the "Total for 1st Year" column. User can override the numbers and enter the actual numbers from this worksheet. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
$- $- $- $- $-
14




15. TOTAL (sum of lines 13 and 14) $- $- $- $- $-
DESCRIPTION: OGM does not require you to complete Section E unless your budget is a Year-1 Budget for a Start-Up program. SECTION E - BUDGET ESTIMATES OF FEDERAL FUNDS NEEDED FOR BALANCE OF PROJECT
a) Grant Program
FUTURE FUNDING PERIODS (Years)
(b) First (c) Second (d) Third (e) Fourth
16 $- $- $- $-
17 $- $- $- $-
18 $- $- $- $-
19 $- $- $- $-
20. TOTAL (sum of lines 16 - 19) $- $- $- $-
SECTION F - OTHER BUDGET INFORMATION
21. Direct Charges:
INSTRUCTIONS: Use this free-form text box to explain amounts for individual direct Object Class Categories that may appear to be out of the ordinary or to explain the details as required by the federal grantor agency.
INSTRUCTIONS: Use this free-form text box to enter the type of indirect cost rate (provisional, predetermined, final or fixed) that will be in effect during the funding period, the estimated amount of the base to which the rate is applied, and the total indirect expense. 22. Indirect Charges:

23. Remarks:
INSTRUCTIONS: Provide any other explanations or comments you deem necessary in this free-form text box.
Authorized for Local Reproduction Standard Form 424A (Rev. 7-97) Page 2



SF 424A & INSTRUCTIONS


File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy