| 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 [email protected]. |
| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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.
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
