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 - 1.22.2020 _FINAL IOAS Approved.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 the following tabs:
- 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



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:
- Federal share of funds you are requesting
- Non-Federal Share Required based on the percentage of Non-Federal Share you have in the line item.
- Non-Federal Share- Cash and Non-Federal Share-In-Kind Identified and the percentage of the total amounts.
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 OCSE 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 share you are requesting, the amount of non-federal share that you need and the total amount of your budget.


STEP 2: Now that you know the amount of non-federal share that you need (the amount is indicated at the bottom of Column I), go back to the top of your budget and begin entering in the amounts of cash or in-kind contributions, in Columns K and L, that you intend to use. You can use all or part of the total amount of the expense (that you listed in Column I) to meet your non-federal share. Remember that a "cash" share is any expense that is being paid by another funding source (except from other federal funds) and "in-kind" is any service or goods being donated by a third party.
Example: You entered the annual hours in Column B and the wage in Column C for your Chief Judge position. The worksheet auto-populates Columns D through I. For this example, let's say Column I totals $40,000; however, you only need to use part of this salary to meet the non-federal share-cash. In Column K you would enter $25,000. Please review TAB-4_SAMPLE BUDGET WORKSHEET for additional examples.
NOTE: Please refer to 45 CFR 75.306 for additional information about non-federal share.


STEP 3: After entering the non-federal share amounts in Column K and L, review the Non-Federal Share Identified at the bottom of Column K/L. The amount should match the amount in Column I EXACTLY. If the amounts do not match, you must revise expense amounts or non-federal share amounts, as necessary, until the total amounts of each are the same.


STEP 4: Once you complete the budget in Tab-5_Budget Worksheet, review Tab-6_Budget At-A-Glance to ensure all the numbers appear correct.
- The amount in Row 25, Column B MUST be -0- (zero) or you will receive an error message when entering your information into GrantSolutions. If the amount is not -0- (zero) you must go back to Tab-5_Budget Worksheet and adjust expenses or the non-federal share amounts until you reach a -0- (zero) difference.
- If you are not using GrantSolutions, OCSE will enter the information into GrantSolutions for you. If the amount in Row 25, Column B is not -0- (zero) your budget submission may be rejected and sent back to you for corrections.


STEP 5: If you do not have enough non-federal share, the Tribe can choose to contribute the remaining amount of cash needed to meet the non-federal share.
If the Tribe is contributing cash, you must identify the line item categories where your program plans to expend it by entering the dollar amounts in the appropriate line items in the non-federal share-cash (Column K).
For example, you may use cash to pay your contractual items or supplies.

5. Indirect Cost Rate (IDC). Using your IDC rate to meet part of your non-federal share will impact the overall tribal IDC rate for ALL tribal programs for future years. Please use IDC for non-federal share with discretion.

6. Budget Submission:
Your budget submssion to OCSE 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.

7. 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.

8. 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.

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 OCSE Division of Regional Operations at OCSE.Tribal@acf.hhs.gov.

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. Non-Federal Share of 10%: Beginning with the first day of the first quarter of the funding grant for a comprehensive program, the tribe will receive 90% federal funding for the first three years. The tribe must verify that they can and will meet the remaining 10% of the budget through cash or in-kind contributions (45 CFR 309.130(c)(2)).

b. Non-Federal Share of 20%: Beginning in year four of the comprehensive program, the tribe will receive 80% federal funding and the tribe must verify that they can and will meet the remaining 20% of the budget through cash or in-kind contributions (45 CFR 309.130(c)(3)(i)).

c. 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. Non-Federal Share: When the IV-D program moves into comprehensive status, the tribe will be required to provide a non-federal share as noted in Section 4a and 4b above.

a. The non-federal share can be met with cash or in-kind (donated) contributions. Detailed information on non-federal share can be found in the Tribal Directors Resource Guide, pages 33-34.

b. When including the non-federal share expenses in your budget, be sure to include calculations and supporting documentation for each expense item. Items paid for from Indirect Costs cannot be used to meet the non-federal share requirement.
6. Non-Federal Share Definitions:

Cash Contribution: Any expense for goods or services allocated to, and necessary for, the operation of the child support program that the tribe, or other third party, pays for with non-federal resources (unless otherwise allowed) is considered a cash contribution. List all cash contributions in the Non-Federal Share - Cash column in the Tab-5_Budget Worksheet.

In-Kind Contribution: A donation of goods or services, allocated to, and necessary for, the operation of the child support program made by a third party wherein no money is exchanged. List all in-kind contributions in the Non-Federal Share - In-Kind column in the Tab-5_Budget Worksheet.
7. Detailed Information is available within the following Tribal Budget Toolbox resources on OCSE's website:

OCSE’s Tribal Budget Toolbox

Tribal Child Support Budget Packet

Tribal Child Support Directors Resource Guide

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 OCSE 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 OCSE. As you complete each requirement, you can cross it off the list by placing an "X" in the cells highlighted in yellow.
For details and citations regarding each requirement, please read:

Tribal Child Support Budget Packet


(Pages 3, 22-24)


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. Statement certifying that the tribe can and will meet the non-federal share budget requirement


c. Contracts


d. IT specifications (if applicable)


e. Waiver request (if applicable)


f. 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
After completing your total budget in Columns A - I; enter the portion of expenses to be used for the Non-Federal Share-Cash in Column K and Non-Federal Share-In-Kind in Column L.
Federal Fiscal Year: INSTRUCTIONS: Enter the Federal Fiscal Year in this cell. FFY18
Federal Match Rate: INSTRUCTIONS: Enter the current federal match rate in this cell. 80% Tribal Match Rate: INSTRUCTIONS: Enter the current Tribal match rate in this cell. 20%



DEFINITION: § 309.130 How will Tribal IV–D programs be funded and what forms are required? (d) Non-Federal share of program expenditures. Each Tribe or Tribal organization that operates a child support enforcement program under title IV–D and § 309.65(a), unless the Secretary has granted a waiver pursuant to § 309.130(e), must provide the non-Federal share of funding, equal to: (1) 10 percent of approved and allowable expenditures during the 3-year period specified in paragraph (c)(2) of this section or; (2) 20 percent of approved and allowable expenditures during the subsequent periods specified in paragraph (c)(3) of this section. (3) The non-Federal share of program expenditures must be provided either with cash or with in-kind contributions and must meet the requirements found in 45 CFR 74.23. Non-Federal Share
LINE ITEMS (Calculations) QTR 1 QTR 2 QTR 3 QTR 4 TOTAL
DEFINITION: 45 CFR Part 75.2 Cost sharing or matching means the portion of project costs not paid by Federal funds (unless otherwise authorized by Federal statute). This may include the value of allowable third party in-kind contributions, as well as expenditures by the recipient. See also §75.306. CASH IN-KIND












PERSONNEL: Annual Hours Wage/ Hour Total Salary







INSTRUCTIONS: List all the personnel positions in this column; inlcuding those that will be used to meet the non-federal share. IV-D Director INSTRUCTIONS: Enter the total annual hours that will be worked for each position in this column; inlcuding those that will be used to meet the non-federal share. 2080 INSTRUCTIONS: Enter the hourly wage amount for each position in this column; inlcuding those that will be used to meet the non-federal share. 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
INSTRUCTIONS: Enter the cash amounts of wages for each applicable personnel position that will be paid for by the tribe and contributed to this budget. You MUST have an amount in Column I of which you can use all or part of the amount to meet the cash non-federal share. $- INSTRUCTIONS: Enter the amount of wages for each applicable position that will be donated to this budget. You MUST have an amount in Column I of which you can use all or part of the amount to meet the in-kind non-federal share. $-
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
$- $-
Chief Judge 1040 $55.00 $57,200.00 $14,300.00 $14,300.00 $14,300.00 $14,300.00 $57,200.00
$48,167.00 $4,500.00
Assc. Judge 520 $45.00 $23,400.00 $5,850.00 $5,850.00 $5,850.00 $5,850.00 $23,400.00
$23,400.00 $-
Clerk of Court 832 $20.00 $16,640.00 $4,160.00 $4,160.00 $4,160.00 $4,160.00 $16,640.00
$16,640.00 $-
Tribal Administrator 208 $40.00 $8,320.00 $2,080.00 $2,080.00 $2,080.00 $2,080.00 $8,320.00
$8,320.00 $-
Total FTEs 6.75









TOTAL PERSONNEL:
$278,720.00 $96,070.00 $96,070.00 $96,070.00 $96,070.00 $384,280.00
$96,527.00 $4,500.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















Chief Judge















Assc. Judge















Clerk of Court















Tribal Administrator

























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: When a person donates their time (above) to be used as an in-kind donated contribution, you cannot charge fringe.
FICA INSTRUCTIONS: Enter the percentage amount your tribe uses for FICA in this cell 4.25% of salary 4,082.98 4,082.98 4,082.98 4,082.98 16,331.90
4,102.40 INSTRUCTIONS: When a person donates their time (above) to be used as an in-kind donated contribution, you cannot charge fringe.
SUTA INSTRUCTIONS: Enter the percentage amount your tribe uses for SUTA in this cell 5.75% of salary 5,524.03 5,524.03 5,524.03 5,524.03 22,096.10
5,550.30
Medicare INSTRUCTIONS: Enter the percentage amount your tribe uses for Medicare in this cell 1.45% of salary 1,393.02 1,393.02 1,393.02 1,393.02 5,572.06
1,399.64
Workman's Comp INSTRUCTIONS: Enter the percentage amount your tribe uses for Workmans's Comp in this cell 3% of salary 2,882.10 2,882.10 2,882.10 2,882.10 11,528.40
2,895.81
Retirement/401K INSTRUCTIONS: Enter the percentage amount your tribe uses for retirement/401Ks in this cell 6% of salary 5,764.20 5,764.20 5,764.20 5,764.20 23,056.80
5,791.39

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
INSTRUCTIONS: If applicable, enter the appropriate amounts for each fringe category for each postion identified in the Personnel lines above that will be used as non-federal share. -
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:
20,320.52 20,320.52 20,320.52 20,320.52 81,282.06
19,739.54










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: If applicable, enter the amount of cash that the Tribe is paying towards the cost of personnel attending this event. $- INSTRUCTIONS: If applicable, enter the fair-market value cost of whatever is being donated, by a third party, toward the cost of travel. (i.e., donated airfare, comped hotel rooms, etc.) $-
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:














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



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:
$- $- $- $- $-
$- $-
LOCATION:



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:
$- $- $- $- $-
$- $-
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:














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:














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. Server
$- $7,000.00 $- $- $7,000.00
INSTRUCTIONS: If applicable, enter the cash match that will be used to purchase this piece of equipment. $7,000.00 INSTRUCTIONS: If applicable, enter the market value of the piece of equipment that is donated. $-















$-
$- $-









TOTAL EQUIPMENT
$- $7,000 $- $- $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.
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
INSTRUCTIONS: Enter the amount of cash that the Tribe is paying for any applicable supply items in this column. $- INSTRUCTIONS: Enter the fair market value amount for supplies that are being donated by a third party for each applicable supply listed. $-
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
$2,618.00 $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


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










CONTRACTUAL:


INSTRUCTIONS: List titles of all contracts in the high-lighted cells in column A. DNA Contract NSTRUCTIONS: 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
INSTRUCTIONS: Enter the cash amount that is being contributed to the cost of this contract by the tribe in this column. $- INSTRUCTIONS: Enter the fair market value amount for services that are being donated by a third party in this column for each contract listed. $-











$- $- $- $- $-
$- $-









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
INSTRUCTIONS: Enter the cash amount, in this column, that is being contributed by the tribe to each applicable expense listed in Column A $- INSTRUCTIONS: Enter the fair market value amounts in this column that is being donated by a third party for each applicable expense listed in column A. $-
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
$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
These fees will be waived by the tribal court and used to meet some of our non-federal share.
$1,125.00 $1,125.00 $1,125.00 $1,125.00 $4,500.00
$4,500.00 $-
Maintenance General cleaning & maintenance will be paid from general funds & used to meet some of our non-federal share. $300.00 $300.00 $300.00 $300.00 $1,200.00
$1,200.00
TOTAL OTHER:
$5,630.00 $5,630.00 $5,630.00 $5,630.00 $22,520.00
$6,200.00 $-
Total Cash Contribution Due to lack of cash and in-kind contributions in the budget, the Tribe will contribute the remaining amount of cash needed to meet the non-federal share. INSTRUCTIONS: Enter the total dollar amount in this cell that your Tribe is contributing to meet the non-federal share. Then distribute this amount in column K. $9,618.00



You must identify the line item categories where your program plans to spend the tribal cash and enter those amounts in column K.
For example, you may use cash to pay your contractual items or supplies.













TOTAL DIRECT COSTS
$122,730.52 $139,430.52 $122,730.52 $122,730.52 $642,088.60
$132,084.54 $4,500.00
INDIRECT COSTS INSTRUCTIONS: Enter the approved IDC rate in the high-lighted cell in column B. 30% INSTRUCTIONS: The IDC rate in this worksheet is calculated on a percentage of salaries only. If your IDC rate is calculated differently, you MUST change the formula. Please contact your Program Specialist if you need technical assistance to re-formulate. OF TOTAL DIRECT COSTS MINUS CONTRACTUAL $48,093.64 $48,093.64 $48,093.64 $48,093.64 $192,374.58
CAUTION: If you choose to use an Indirect Cost rate as part of your non-federal share, either cash or in-kind, it will reduce the IDC rate for ALL tribal programs in the current year and beyond. Please use with descretion! $28,958.10 $1,350.00
TOTALS:
$170,824.16 $187,524.16 $170,824.16 $170,824.16 $834,463.18
$161,042.64 $5,850.00


















DEFINITION: 45 CFR Part 75.2 Federal share means the portion of total project costs that are paid by Federal funds. Federal Share: 80.00% INSTRUCTIONS: THIS IS THE TOTAL AMOUNT OF FEDERAL FUNDS BEING REQUESTED. $667,570.54
Non-Federal Share Identified






DEFINITION: Please refer to 45 CFR 75.306 for specific information about Non-Federal Share. Non-Federal Share: 20.00% INSTRUCTIONS: THIS IS THE TOTAL AMOUNT OF NON-FEDERAL MATCH REQUIRED. $166,892.64
INSTRUCTIONS: THIS IS THE TOTAL AMOUNT OF NON-FEDERAL MATCH IDENTIFIED. $166,892.64






Total Budget:
INSTRUCTIONS: This is the TOTAL PROPOSED BUDGET AMOUNT. $834,463.18






























































































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.

After completing your total budget in Columns A - I; enter the portion of expenses to be used for the Non-Federal Share-Cash in Column K and Non-Federal Share-In-Kind in Column L.
Federal Fiscal Year: INSTRUCTIONS: Enter the Federal Fiscal Year in this cell.

Federal Match Rate: INSTRUCTIONS: Enter the current federal match rate in this cell. 0% Tribal Match Rate: INSTRUCTIONS: Enter the current Tribal match rate in this cell. 0%




DEFINITION: § 309.130 How will Tribal IV–D programs be funded and what forms are required? (d) Non-federal share of program expenditures. Each Tribe or Tribal organization that operates a child support enforcement program under title IV–D and § 309.65(a), unless the Secretary has granted a waiver pursuant to § 309.130(e), must provide the non-federal share of funding, equal to: (1) 10 percent of approved and allowable expenditures during the 3-year period specified in paragraph (c)(2) of this section or; (2) 20 percent of approved and allowable expenditures during the subsequent periods specified in paragraph (c)(3) of this section. (3) The non-federal share of program expenditures must be provided either with cash or with in-kind contributions and must meet the requirements found in 45 CFR 74.23. NOTE: You MUST have an amount in Column I, and in Column J and K list the amount, in part or in full, that you will use toward your non-federal share. Please refer to TAB_2_SAMPLE BUDGET WORKSHEET for examples. Non-Federal Share
LINE ITEMS (Calculations) QTR 1 QTR 2 QTR 3 QTR 4 TOTAL
DEFINITION: 45 CFR Part 75.2 Cost sharing or matching means the portion of project costs not paid by Federal funds (unless otherwise authorized by Federal statute). This may include the value of allowable third party in-kind contributions, as well as expenditures by the recipient. See also §75.306. CASH IN-KIND












PERSONNEL: Annual Hours Wage/ Hour Total Salary







INSTRUCTIONS: List all the personnel positions in this column, inlcuding those that will be used to meet the non-federal share.
INSTRUCTIONS: Enter the total annual hours that will be worked for each position in this column; inlcuding those that will be used as non-federal share. 0 INSTRUCTIONS: Enter the hourly wage amount for each position in this column including those that will be used for non-federal share. 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. $- $- $- $- $- $- $-
INSTRUCTIONS: Enter the cash amounts of wages for each applicable personnel position that will be paid for by the tribe and contributed to this budget. You MUST have an amount in Column I of which you can use all or part of the amount to meet the cash non-federal share. $- INSTRUCTIONS: Enter the amount of wages for each applicable position that will be donated to this budget. You MUST have an amount in Column I of which you can use all or part of the amount to meet the in-kind non-federal share. $-

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: When a person donates their time (above) to be used as an in-kind donated contribution, you cannot charge fringe.
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 $- $- $- $- $-
INSTRUCTIONS: If applicable, enter the appropriate amounts for each fringe category for each postion identified in the Personnel lines above that will be used as non-federal share. $-
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. $- $- $- $- $-
INSTRUCTIONS: If applicable, enter the cash amount that the Tribe is paying towards the cost of personnel attending this event. $- INSTRUCTIONS: If applicable, enter the fair-market value cost of whatever is being donated, by a third party, toward the cost of travel. (i.e., donated airfare, comped hotel rooms, etc.) $-
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:












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: If applicable, enter the cash match that will be used to purchase this piece of equipment. $- INSTRUCTIONS: If applicable, enter the fair market value of the piece of equipment that is donated. $-

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. $- $- $- $- $-
INSTRUCTIONS: Enter the amount of cash that the Tribe is paying for any applicable supply items in this column. $- INSTRUCTIONS: Enter the fair market value amount for supplies that are being donated by a third party in this column for each applicable supply 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 cash amount that is being contributed to the cost of this contract by the Tribe in this column. $- INSTRUCTIONS: Enter the fair market value amount for services that are being donated by a third party in this column for each contract 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. $- $- $- $- $-
INSTRUCTIONS: Enter the cash amount that is being contributed by the Tribe for each applicable expense listed in Column A. $- INSTRUCTIONS: Enter the fair market value amounts in this column that are being donated by a third party for each applicable expense listed in column A. $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-


$- $- $- $- $-
$- $-
TOTAL OTHER:
$- $- $- $- $-
$- $-
Total Cash Contribution Due to lack of cash and in-kind contributions in the budget, the Tribe will contribute the remaining amount of cash needed to meet the non-federal share. INSTRUCTIONS: Enter the total dollar amount in this cell that your Tribe is contributing to meet the non-federal share. Then distribute this amount in column K. $-



You must identify the line item categories where your program plans to spend the tribal cash and enter those amounts in column K.
For example, you may use cash to pay your contractual items or supplies.















TOTAL DIRECT COSTS
$- $- $- $- $-
$- $-
INDIRECT COSTS INSTRUCTIONS: Enter the approved IDC rate in the highlighted cell in column B. 0.00% INSTRUCTIONS: The IDC rate in this worksheet is calculated on a percentage of TOTAL BUDGET MINUS CONTRACTUAL. If your IDC rate is calculated differently, you MUST change the formula. Please contact your Program Specialist if you need technical assistance to re-formulate. OF TOTAL DIRECT COSTS MINUS CONTRACTUAL $- $- $- $- $-
If you choose to use an Indirect Cost rate as part of your non-federal share, either cash or in-kind, it will reduce the IDC rate for ALL tribal programs in future budget years. Please use with discretion! $- $-
TOTALS:
$- $- $- $- $-
$- $-


















DEFINITION: 45 CFR Part 75.2 Federal share means the portion of total project costs that are paid by Federal funds. Federal Share: 0% INSTRUCTIONS: Cell I245 THIS IS THE TOTAL AMOUNT OF FEDERAL FUNDS BEING REQUESTED. $-
Total Non-Federal Share Identified






DEFINITION: Please refer to 45 CFR 75.306 for specific information about Non-Federal Share. Non-Federal Share: 0% INSTRUCTIONS: Cell I246 THIS IS THE TOTAL AMOUNT OF NON-FEDERAL SHARE THAT IS REQUIRED. $-
INSTRUCTIONS: Cell J/K246 THIS IS THE TOTAL AMOUNT OF NON-FEDERAL SHARE THAT YOU HAVE IDENTIFIED. $-






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
















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

Program Name: 0

Federal Fiscal Year: 0




Federal Match Rate: 0%




Tribal Match Rate: 0%





BUDGET AT-A-GLANCE
This worksheet provides you with an easy-to-view snapshot of the numbers you entered in the Tab-5 Budget Worksheet for Columns B and E/F.
Column B is your TOTAL BUDGET, Column E/F is the non-federal share amount you identified and Column C is the resulting Federal Share amounts.
Office of Grants Management (OGM) can award 100% of a direct cost category and lessor percentages in other cost categories as long as the Total Percentage in Column G/Row 21 is the appropriate percentage.



Object Class Categories THIS IS YOUR TOTAL BUDGET This is the percentage of the Federal Share of Your Total Budget This is the percentage of the Non-Federal Share You Identified in Your Budget

$ $ % Cash In-Kind %
PERSONNEL $- $- 0.0% $- $- 0.0%
FRINGE $- $- 0.0% $- $- 0.0%
TRAVEL $- $- 0.0% $- $- 0.0%
EQUIPMENT $- $- 0.0% $- $- 0.0%
SUPPLIES $- $- 0.0% $- $- 0.0%
CONTRACTUAL $- $- 0.0% $- $- 0.0%
OTHER $- $- 0.0% $- $- 0.0%


TOTALS DIRECT CHARGES: $- $-
$- $-

INDIRECT COSTS $- $- 0.0% $- $- 0.0%


TOTAL BUDGET $- $- 0.0% $- 0.0%








Federal Share: $-





DESCRIPTION: This is the non-federal share you need to meet. Non-Federal Share Needed: $-





DESCRIPTION: This is the non-federal share you identified in your budget in Tab 5. Non-Federal Share Identified $-





DIFFERENCE: DESCRIPTION: THE AMOUNT IN THIS CELL MUST BE $ -0- TO AVOID RECEIVING AN ERROR MESSAGE IN GRANTSOLUTIONS. IF THE AMOUNT IN THIS CELL APPEARS IN BRACKETS ( ) IT MEANS YOU ARE LACKING THAT AMOUNT OF NON-FEDERAL SHARE. IF THE AMOUNT IS NOT IN BRACKETS, IT MEANS THE NON-FEDERAL SHARE AMOUNT IDENTIFIED IS MORE THAN WHAT IS NEEDED. YOU MUST ADJUST YOUR EXPENSES OR NON-FEDERAL SHARE AMOUNTS IN THE TAB-5_BUDGET WORKSHEET UNTIL THE DIFFERENCE BETWEEN THE NON-FEDERAL SHARE REQUIRED AND THE NON-FEDERAL SHARE IDENTIFIED IS -0- (ZERO). $-





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)
DESCRIPTION: This cell auto-populates the Non-Federal share REQUIRED based on the percentage you entered for the Total Budget in Tab-5_Budget Worksheet. Non-Federal
(f)
Total
(g)
1. Child Support:
Federal Share
93.563 $- $- $- $- $-
2. Child Support:
Non-Federal Share
INSTRUCTIONS: You must enter this number into the correlating cell in GrantSolutions. 93.563 $- $- $- $- $-
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 DESCRIPTION: This column auto-populates with the non-federal share IDENTIFIED for each Object Class Category entered in Tab-5_Budget Worksheet. (2) Non-Federal Share (3)
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: This is the total Non-Federal Share IDENTIFIED in Tab-5_Budget Worksheet. It MUST match the total Non-Federal Share NEEDED that is auto-populated in Cell F-6 above in Section A. $- $- $- $-

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 DESCRIPTION: This cell auto-populates the total non-federal share IDENTIFIED in Tab-5_Budget Worksheet. This amount MUST match the non-federal share REQUIRED that is displayed above in Section A, Cell F-6. (b) Applicant (c) State (d) Other Sources (e) TOTALS
8. - - - -
9. TRIBAL CHILD SUPPORT: Non-Federal Share - - - -
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. Non-Federal $- $- $- $- $-
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