Attachment E Worksheet.xlsx
XLSX spreadsheet 73 KB Posted
- Attached to
- 2025 SUMMER TRANS, INSTITUTE - REBID
- Solicitation number
- 5400027696
- Issued by
- Richland County, South Carolina
About this file
This file is an Excel worksheet titled "Attachment E" related to the National Summer Transportation Institute (NSTI) Program, involving state Departments of Transportation and host sites across all U.S. states and territories. The worksheet contains multiple tables for planning and implementing NSTI programs, including staffing requirements (Table A), Intermodal Advisory Committee membership (Table B), partners and sponsors (Table C), implementation planning (Table D), and detailed budget narratives (Table E). The document serves as a comprehensive planning and budgeting tool for institutions implementing NSTI programs.
The budget section includes detailed breakdowns for direct program costs, participant support costs, and indirect costs, with specific guidelines for allowable expenses under federal funding. The worksheet requires documentation of employee compensation, fringe benefits, advertising and outreach, publication and printing, contractual services, supplies, travel costs, and participant support costs including transportation, lodging, and meals. Indirect costs are allowed only with an approved indirect cost rate proposal (ICRP) or the de minimis rate of 15% of Modified Total Direct Costs. The document specifies that funding can come from multiple sources including NSTI funds, 504(e) funds, state/local funds, and in-kind contributions.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| No Award.pdf | ||
| EXTENSION OF AWARD DATE.docx | DOCX document | |
| Solicitation Document.docx | DOCX document | |
| Attachment E Worksheet.xlsx | XLSX spreadsheet | |
| Mode of Payment.doc | DOC document | |
| Solicitation Document.docx | DOCX document | |
| Attachment E Worksheet.xlsx | XLSX spreadsheet | |
| Mode of Payment.doc | DOC document | |
| EXTENSION OF AWARD DATE.docx | DOCX document | |
| EXTENSION OF AWARD DATE.docx | DOCX document | |
| Solicitation Document.docx | DOCX document | |
| Mode of Payment.doc | DOC document | |
| Attachment E Worksheet.xlsx | XLSX spreadsheet | |
| Solicitation Document.docx | DOCX document | |
| Mode of Payment.doc | DOC document |
Show all 15
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Table A-Staffing
| Proposal Application | State Name | USPS Abbreviation | Traditional Abbreviation | |||||||||
| National Summer Transportation Institute (NSTI) Program | Alabama | AL | Alabama DOT | |||||||||
| Table A - Staffing Requirements | Alaska | AK | Alaska DOT | |||||||||
| State Abbreviation: | State Name: | State DOT/Pass-Through Entity: | American Samoa | AS | American Samoa DOT | |||||||
| Host Site: | Arizona | AZ | Arizona DOT | |||||||||
| Include the personnel details of staff that will be involved in the development, implementation, and delivery of the NSTI project. Provide a narrative description of the duties and responsibilities related to each staff member or position working on the NSTI project and a breakdown of the salary or wage with an estimated amount of time to be billed to the NSTI project. An equitable allocation of cost for salaried employees requires developing an hourly rate and determining the amount of time spent on the project. The NSTI Work Hours and Total Cost will be recorded in Table E-Budget Narrative. | Arkansas | AR | Arkansas DOT | |||||||||
| Place an "X" to select the appropriate program type. | ||||||||||||
| Eatmon, Robert (FHWA): Select more than one if applicable. | Residential Program | Virtual Program | Non-Residential Program | California | CA | California DOT | ||||||
| Personnel Assigned (if known) or provide position | Colorado | CO | Colorado DOT | |||||||||
| Name | Position/Title | Affiliation (Faculty, Contract, Student) | Monthly Salary | |||||||||
| Eatmon, Robert (FHWA): Enter the institution regular salary amount for the employee. If the Staff member is an hourly employee, then leave the Salary and Salary Hours blank and enter hourly rate in the appropriate field. | Salary Hours |
Eatmon, Robert (FHWA): How many hours does the individual currently work?
Is the salary paid on a weekly (40 hours), biweekly (80 hours), monthly (173.33 hours), or some other basis? Is the salary for part-time or full-time work?
| Enter the normal work hours for the applicable period of time. | Salary Rate |
| Eatmon, Robert (FHWA): Salary divided by Salary Hours (G10/I10) to calculate an estimated Hourly Salary Rate. | Hourly Rate |
| Eatmon, Robert (FHWA): Enter the hourly rate for non-salaried employees. Leave this blank if salary information is provided. | NSTI Work Hours |
Eatmon, Robert (FHWA): How many hours will this employee work on the NSTI program?
Enter that number here. Total Est. Cost Eatmon, Robert (FHWA): Multiply either the Salary Rate (J10) OR Hourly Rate (K10) by the NSTI Work Hours (L10) to calculate an estimated salary/wage cost for the project.
Eatmon, Robert (FHWA): Select more than one if applicable.
| Eatmon, Robert (FHWA): Enter the institution regular salary amount for the employee. If the Staff member is an hourly employee, then leave the Salary and Salary Hours blank and enter hourly rate in the appropriate field. | Connecticut | CT | Connecticut DOT | ||||||||||
| 1 | $0.00 | $0.00 | Delaware | DE | Delaware DOT | ||||||||
| Narrative: | Full time: Week = 40 Hours & Month = 173.33 Hrs | Hourly Paid Staff | NSTI Hours | Budget Detail | District of Columbia | DC | District of Columbia DOT | ||||||
| Florida | FL | Florida DOT | |||||||||||
| 2 | $0.00 | $0.00 | Georgia | GA | Georgia DOT | ||||||||
| Narrative: | Full time: Week = 40 Hours & Month = 173.33 Hrs | Hourly Paid Staff | NSTI Hours | Budget Detail | Guam | GU | Guam DOT | ||||||
| Hawaii | HI | Hawaii DOT | |||||||||||
| 3 | $0.00 | $0.00 | Idaho | ID | Idaho DOT | ||||||||
| Narrative: | Full time: Week = 40 Hours & Month = 173.33 Hrs | Hourly Paid Staff | NSTI Hours | Budget Detail | Illinois | IL | Illinois DOT | ||||||
| Indiana | IN | Indiana DOT | |||||||||||
| 4 | $0.00 | $0.00 | Iowa | IA | Iowa DOT | ||||||||
| Narrative: | Full time: Week = 40 Hours & Month = 173.33 Hrs | Hourly Paid Staff | NSTI Hours | Budget Detail | Kansas | KS | Kansas DOT | ||||||
| Kentucky | KY | Kentucky DOT | |||||||||||
| 5 | $0.00 | $0.00 | Louisiana | LA | Louisiana DOT | ||||||||
| Narrative: | Full time: Week = 40 Hours & Month = 173.33 Hrs | Hourly Paid Staff | NSTI Hours | Budget Detail | Maine | ME | Maine DOT | ||||||
| Maryland | MD | Maryland DOT | |||||||||||
| 6 | $0.00 | $0.00 | Massachusetts | MA | Massachusetts DOT | ||||||||
| Narrative: | Full time: Week = 40 Hours & Month = 173.33 Hrs | Hourly Paid Staff | NSTI Hours | Budget Detail | Michigan | MI | Michigan DOT | ||||||
| Minnesota | MN | Minnesota DOT | |||||||||||
| 7 | $0.00 | $0.00 | Mississippi | MS | Mississippi DOT | ||||||||
| Narrative: | Full time: Week = 40 Hours & Month = 173.33 Hrs | Hourly Paid Staff | NSTI Hours | Budget Detail | Missouri | MO | Missouri DOT | ||||||
| Montana | MT | Montana DOT | |||||||||||
| 8 | $0.00 | $0.00 | Nebraska | NE | Nebraska DOT | ||||||||
| Narrative: | Full time: Week = 40 Hours & Month = 173.33 Hrs | Hourly Paid Staff | NSTI Hours | Budget Detail | Nevada | NV | Nevada DOT | ||||||
| New Hampshire | NH | New Hampshire DOT | |||||||||||
| 9 | $0.00 | $0.00 | New Jersey | NJ | New Jersey DOT | ||||||||
| Narrative: | Full time: Week = 40 Hours & Month = 173.33 Hrs | Hourly Paid Staff | NSTI Hours | Budget Detail | New Mexico | NM | New Mexico DOT | ||||||
| New York | NY | New York DOT | |||||||||||
| 10 | $0.00 | $0.00 | North Carolina | NC | North Carolina DOT | ||||||||
| Narrative: | Full time: Week = 40 Hours & Month = 173.33 Hrs | Hourly Paid Staff | NSTI Hours | Budget Detail | North Dakota | ND | North Dakota | ||||||
| Northern Mariana Islands | MP | Northern Mariana Islands DOT | |||||||||||
| Ohio | OH | Ohio DOT | |||||||||||
| Oklahoma | OK | Oklahoma DOT | |||||||||||
| Oregon | OR | Oregon DOT | |||||||||||
| Pennsylvania | PA | Pennsylvania DOT | |||||||||||
| Puerto Rico | PR | Puerto Rico DOT | |||||||||||
| Rhode Island | RI | Rhode IslandDOT | |||||||||||
| South Carolina | SC | South Carolina DOT | |||||||||||
| South Dakota | SD | South Dakota DOT | |||||||||||
| Tennessee | TN | Tennessee DOT | |||||||||||
| Texas | TX | Texas DOT | |||||||||||
| Utah | UT | Utah DOT | |||||||||||
| Vermont | VT | Vermont DOT | |||||||||||
| Virgin Islands | VI | Virgin Islands DOT | |||||||||||
| Virginia | VA | Virginia DOT | |||||||||||
| Washington | WA | Washington DOT | |||||||||||
| West Virginia | WV | West Virginia DOT | |||||||||||
| Wisconsin | WI | Wisconsin DOT | |||||||||||
| Wyoming | WY | Wyoming DOT |
Table B-IAC
| National Summer Transportation Institute (NSTI) Program |
| Table B - Intermodal Advisory Committee (IAC) |
| State: |
| Host Site: |
| Host sites are encouraged to establish an Intermodal Advisory Committee (IAC) and select members from a broad spectrum of the transportation community. The FHWA, State DOT, Community Based Organization (CBO), and private industry individuals may participate as members of the IAC. |
| Name: |
| Title: |
| Organization: |
| Name: |
| Title: |
| Organization: |
| Name: |
| Title: |
| Organization: |
| Name: |
| Title: |
| Organization: |
| Name: |
| Title: |
| Organization: |
| Name: |
| Title: |
| Organization: |
| Name: |
| Title: |
| Organization: |
| Name: |
| Title: |
| Organization: |
| Name: |
| Title: |
| Organization: |
| Name: |
| Title: |
| Organization: |
Table C-Partners
| National Summer Transportation Institute (NSTI) Program |
| Table C - Partners and Sponsors |
| State: |
| Host Site: |
| Describe any partners, sponsors, and/or other contributors that will support the delivery of the NSTI Program. This includes individuals or entities that provide support through funding, sharing responsibility for delivering the NSTI program, or contributions in providing information and learning opportunities through presentations, field trips, site visits and/or tours. |
Describe the role and contribution of each partner or sponsor and provide funds or value of donated services and any costs associated with tours or site visits. Any donated funds or value of services should be included in this table and also recorded in the Budget Narrative In-kind Donations or State/Local funds. Costs related to registration fees for tours and site visits should be included in the estimated costs and also in the Budget Narrative Other Participant Support Costs.
1 Name or Contact Title Organization Donated Funds or Value of Services Estimated Cost (if any)
Role and Contribution Narrative
2 Name or Contact Title Organization Donated Funds or Value of Services Estimated Cost (if any)
3 Name or Contact Title Organization Donated Funds or Value of Services Estimated Cost (if any)
Role and Contribution Narrative
4 Name or Contact Title Organization Donated Funds or Value of Services Estimated Cost (if any)
Role and Contribution Narrative
5 Name or Contact Title Organization Donated Funds or Value of Services Estimated Cost (if any)
Role and Contribution Narrative
6 Name or Contact Title Organization Donated Funds or Value of Services Estimated Cost (if any)
Role and Contribution Narrative
7 Name or Contact Title Organization Donated Funds or Value of Services Estimated Cost (if any)
Role and Contribution Narrative
8 Name or Contact Title Organization Donated Funds or Value of Services Estimated Cost (if any)
Role and Contribution Narrative
9 Name or Contact Title Organization Donated Funds or Value of Services Estimated Cost (if any)
Role and Contribution Narrative
10 Name or Contact Title Organization Donated Funds or Value of Services Estimated Cost (if any)
Role and Contribution Narrative
Total Contribution $0.00 $0.00
Table D-Plan
| National Summer Transportation Institute (NSTI) Program |
| Table D - Implementation Plan |
| State: |
| Host Site: |
| Host sites should describe all tasks necessary to deliver a successful NSTI Program. The implementation plan should outline the steps the host site will take from concept, recruitment of IAC or partners/sponsors, development of a curriculum, promoting the program, review and selection of applicants and final delivery of the National Summer Transportation Institute program. The tasks and timeframes listed should match with the Statement of Work (SOW) submitted by the host site. |
| Task 1: |
| Assigned To: |
| Action Required: |
| Timeframe: |
| Task 2: |
| Assigned To: |
| Action Required: |
| Timeframe: |
| Task 3: |
| Assigned To: |
| Action Required: |
| Timeframe: |
| Task 4: |
| Assigned To: |
| Action Required: |
| Timeframe: |
| Task 5: |
| Assigned To: |
| Action Required: |
| Timeframe: |
| Task 6: |
| Assigned To: |
| Action Required: |
| Timeframe: |
| Task 7: |
| Assigned To: |
| Action Required: |
| Timeframe: |
| Task 8: |
| Assigned To: |
| Action Required: |
| Timeframe: |
| Task 9: |
| Assigned To: |
| Action Required: |
| Timeframe: |
| Task 10: |
| Assigned To: |
| Action Required: |
| Timeframe: |
Table E-Budget
| National Summer Transportation Institute (NSTI) Program | Alabama,Alaska,American Samoa,Arizona,Arkansas,California,Colorado, Connecticut,Delaware,District of Columbia,Florida,Georgia,Guam,Hawaii,Idaho,Illinois, Indiana,Iowa,Kansas,Kentucky,Louisiana,Maine,Maryland,Massachusetts,Michigan, Minnesota,Mississippi,Missouri,Montana,Nebraska,Nevada,New Hampshire,New Jersey,New Mexico,New York,North Carolina,North Dakota,Northern Mariana Islands,Ohio,Oklahoma,Oregon,Pennsylvania,Puerto Rico,Rhode Island,South Carolina, South Dakota,Tennessee,Texas,Utah,Vermont,Virgin Islands,Virginia,Washington,West Virginia,Wisconsin,Wyoming | ||||||
| Table E - Program Budget Narrative Worksheet | |||||||
| PROGRAM | CFDA # | FISCAL YEAR | STATE | HOST SITE | AC | ||
| Eatmon, Robert (FHWA): If your project will be using Advanced Construction, please place "X" here. | PROPOSAL/ MOD DATE |
Eatmon, Robert (FHWA): This is the date the NSTI worksheet is submitted to the State DOT. If there is a modification to an existing submittal, provide the date the modification is submitted.
NSTI 20.205
| Total Funding and Contributions | ||||
| NSTI Funds Requested | 504(e) Funds Added (NHPP, STBG, HSIP, CMAQ) | State/Local Funds | In-kind Contribution(s) | Total Cost |
| $0.00 |
| Budget Summary | ||||||||
| Narratives and Cost Details | Cost Breakdown | |||||||
| NSTI Funds | 504(e) | State/Local | In-kind | Total Cost | ||||
| Direct Program Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Participant Support Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Indirect Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Total NSTI Program Cost | ||||||||
| Eatmon, Robert (FHWA): These totals have conditional formatting and must equal the Total Funding and Contributions above. If the cell is highlighted you must adjust costs in the detail or modify the amounts identified in the Total Funding and Contribution to remain in balance. | $0.00 |
Eatmon, Robert (FHWA): The total costs that will be paid with NSTI funds from the detail sections below.
This number must match the NSTI Funds requested in Cell B8. $0.00 Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
Leave this field blank.
$0.00 Eatmon, Robert (FHWA): The total costs that will be paid with 504(e) funds from the detail sections below.
This number must match the 504(e) number requested in Cell G8. $0.00 Eatmon, Robert (FHWA): The total costs that will be paid with State/Local funds from the detail sections below.
This number must match the State/Local Funds number in Cell I8. $0.00 Eatmon, Robert (FHWA): The total value of In-kind contributions that will be used towards the project identified in the In-Kind detail sections below.
This number must match the In-kind number in Cell J8. $0.00
| Budget Narrative | ||||||||
| Narratives and Cost Details | Cost Breakdown | |||||||
| NSTI Funds | OJT/SS | 504(e) | State/University | In-kind | Total Cost | |||
| DIRECT PROGRAM COSTS | ||||||||
| Employee Compensation (detail cost of employee hourly/monthly rates and number of hours is provided in Table A-Staffing Requirements) | ||||||||
| The direct salary or wages paid to host site employees working directly on delivery of the NSTI program are allowable costs provided they meet the requirements in 2 CFR §200.430(h) regarding determining allowable personnel compensation costs for Institutions of Higher Education (IHE). The salary basis for charges to the NSTI by faculty members during the academic year are allowable at the Institutional Base Salary (IBS), which is the annual compensation paid by an IHE for an individual's appointment. In no event will charges to Federal awards, irrespective of the basis of computation, exceed the proportionate share of the IBS for that period unless specifically requested and in accordance with §200.430(h)(4). This principle applies to all members of faculty at an institution. Charges to the NSTI for salaries and wages must be based on records that accurately reflect the work performed. (See §200.430(i) Standards for Documentation of Personnel Expenses.) | ||||||||
| Title/Position | Hours | Cost | Distribute costs from Table A-Staffing to the appropriate fund type. | Total Cost | ||||
| 1 | ||||||||
| 2 | ||||||||
| 3 | ||||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 | ||||||||
| Total Employee Compensation | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Employee Fringe Benefits (provide justification and supporting documentation for any fringe benefit calculations, include cognizant approval) | ||||||||
| The costs of employee leave, insurance, pensions, and unemployment benefit plans are allowable costs, but fringe benefits must be allocated to Federal awards and all other activities in a consistent and equitable manner. A fringe benefit rate, if applied, must be approved by the cognizant agency for indirect cost. Identifying the total fringe benefit cost for an employee and identifying the equitable proportion that should be applied to the NSTI should be explained and documented in the Justification/Narrative below. (§200.431 Compensation–Fringe Benefits) |
Enter the appropriate fringe rate below and it will be applied to the salary entered above to calculate cost. To apply another methodology, describe in the narrative and enter the costs below. If the University will only be claiming the FICA amount (7.65%) for their employees enter that rate below. If claiming another rate, the Fringe Benefit rate approval from the Cognizant Agency for Indirect Costs must be provided to support rates other than the required FICA rate.
| Justification/Narrative | ||||
| Instructors will be hired on a temporary basis for two training days plus the duration of the two-week program. The program assistant will be hired for the duration of the two-week program. The university will provide full-time Dorm Supervisors as paid staff. All personnel will be hired through the University’s hiring process. The Youth Program Director will be responsible for the direct management of the daily operations for the summer Program. No ICAP documents required since fringe rates are below 7.65%. | ||||
| Title/Position | Rate | |||
| Eatmon, Robert (FHWA): If a rate is entered here, it must be supported with an approval from the Cognizant Agency for Indirect Costs. | Cost | NSTI Funds | OJT/SS |
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
| Leave these fields blank. | 504(e) | State/Local | In-kind | Total Cost | ||||||
| 1 | ||||||||||
| 2 | ||||||||||
| 3 | ||||||||||
| 4 | ||||||||||
| 5 | ||||||||||
| 6 | ||||||||||
| 7 | ||||||||||
| 8 | ||||||||||
| 9 | ||||||||||
| 10 | ||||||||||
| Total Fringe Benefits | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Advertising & Outreach | NSTI Funds | 504(e) | State/Local | In-kind | Total Cost | |||||
| Costs of advertising media and corollary administrative costs associated with the recruitment of personnel to support NSTI and advertising costs associated with NSTI program outreach are allowable costs. Advertising media include magazines, newspapers, radio and television, direct mail, exhibits, and the internet. (§200.421 Advertising and public relations) | ||||||||||
| Justification/Narrative |
| Total Advertising & Outreach | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | FALSE |
| Publication & Printing | NSTI Funds | 504(e) | State/Local | In-kind | Total Cost | |
| Publication costs for electronic and print media, including distribution, promotion, and general handling directly related to the NSTI program are allowable. (§200.461 Publication and printing costs.) | ||||||
| Justification/Narrative | ||||||
| Printing of flyers to promote the program. Electronic and print media to distribute press release to promote program. |
| Total Publication & Printing | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Contractual Services | NSTI Funds | 504(e) | State/Local | In-kind | Total Cost | |
| The costs of contracts to procure goods or services directly in support of the NSTI program are allowable costs. | ||||||
| Justification/Narrative |
| Total Contractual Services | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | FALSE |
| Supplies | NSTI Funds | 504(e) | State/Local | In-kind | Total Cost | |
| Costs incurred for materials and supplies necessary to carry out the NSTI program are allowable. Supplies are any tangible property with a per unit cost of less than $5,000, and this includes computing devices (computers, laptops, tablets). In the specific case of computing devices, charging as direct costs is allowable for devices that are essential and allocable to the performance of the NSTI program. (§200.453 Materials and supplies costs, including costs of computing devices) NOTE: If any computing devices will be a proposed cost in delivering a proposed NSTI Program, the applicant must document the essential need, how the computing devices will be used, and ensure the costs of procuring any computing devices does not significantly impact delivery of the overall NSTI Program initiative. If computing devices will be provided to students, then that is a participant support cost and must be included in that section below and not here. | ||||||
| Justification/Narrative |
| Total Supplies | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | FALSE |
| Travel Costs | NSTI Funds | 504(e) | State/Local | In-kind | Total Cost | |
| Expenses for transportation, lodging, subsistence, and related items incurred by host site employees related to the NSTI program is allowable. Travel must be performed in accordance with the Host Site’s written travel policies. NOTE: Travel costs for participants should NOT be recorded here. This is only employee travel. | ||||||
| Justification/Narrative |
| Total Travel Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | FALSE |
| Other Costs | NSTI Funds | 504(e) | State/Local | In-kind | Total Cost | |
| Enter any other costs not identified. This would included any allowable costs that don't fit the categories above or costs that are unallowable for Federal participation, but may be paid 100% with State/Local/University funds. NOTE: Costs of promotional items and memorabilia, including models, gifts, clothing, and souvenirs are UNALLOWABLE. Costs incurred for promotional items must not be charged to the NSTI Program, but these costs may be paid entirely with non-Federal funds. (§200.421(e)(3) Advertising and public relations) Costs for items provided to students must be included in the Other Participant Support Costs section below. | ||||||
| Justification/Narrative |
| Total Other Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | FALSE |
| PARTICIPANT SUPPORT COSTS | ||||||
| Transportation and Travel (field trips) | NSTI Funds | 504(e) | State/Local | In-kind | Total Cost | |
| Transportation and travel for participants includes stipends for transportation to and from NSTI location for non-Residential programs. Travel for participants to attend residential programs may be provided if necessary and reasonable for the NSTI program. Any travel for participants to attend field trips would also be included in this section. | ||||||
| Justification/Narrative |
| Total Participant Transportation and Travel | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | FALSE |
| Lodging and Facilities | NSTI Funds | 504(e) | State/Local | In-kind | Total Cost | |
| Lodging and facilities costs for residential programs are allowable costs for the NSTI program. Costs should be reasonable and allocable to the NSTI project. Non-residential programs may not charge lodging costs unless an overnight field trip necessitates lodging costs. This must be described in the narrative. | ||||||
| Justification/Narrative |
| Total Participant Lodging and Facilities | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | FALSE |
| Meals & Subsistence | NSTI Funds | 504(e) | State/Local | In-kind | Total Cost | |
| Meals and Subsistence costs are allowable for residential NSTI programs. Meal costs are NOT allowed with Federal funds in non-residential NSTI programs, unless the meal cost can be justified as being beneficial to the program and participants and would be necessary for the successful delivery of the NSTI program. The normal process would be for non-residential students to provide their own lunches or costs of meals may be provided and paid 100% with non-Federal funds. | ||||||
| Justification/Narrative |
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
Leave these fields blank.
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
Leave these fields blank.
Leave this field blank.
| Total Participant Meals & Subsistence | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | FALSE |
| Other Participant Support Costs | NSTI Funds | 504(e) | State/Local | In-kind | Total Cost | |
| Provide any additional participant support costs necessary for the delivery of the NSTI. These may include registration fees associated with field trips, but may not include food. Costs must be reasonable and necessary for the NSTI and related to transportation. Costs associated with field trips, site visits, and tours will also be provided in Table C-Partners & Sponsors. Other costs for participant support must be described in the narrative. Costs of computer equipment or tablets provided to participants must be recorded in this section. NOTE: If any computing devices will be provided to participants of the NSTI Program, the applicant must document the essential need, how the computing devices will be used, and ensure the costs of procuring any computing devices does not significantly impact delivery of the overall NSTI Program initiative. | ||||||
| Justification/Narrative |
Leave these fields blank.
| Total Other Participant Support Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | FALSE |
| INDIRECT COSTS | ||||||
| Indirect or Facilities and Administration (F&A) costs are allowable costs under the NSTI program; however, host sites must have an approved and currently effective indirect cost rate proposal (ICRP) for the indirect costs to be allowable in the budget. The Cognizant Agency for Indirect Cost for Institutions of Higher Education (IHE) is assigned to Department of Health and Human Services (HHS) or the Department of Defense's Office of Naval Research (DOD), normally depending on which of the two agencies (HHS or DOD) provide the most direct Federal funding to the IHE in the most recent three years. Where an IHE only receives Federal funds as a subrecipient, the Pass-Through Entity (PTE), which is the State DOT for the NSTI program, is responsible for determining the appropriate rate in collaboration with the subrecipient, which is either: |
1. A negotiated indirect cost rate between the PTE or State DOT and host site (predetermined rate, fixed rate with carry forward adjustment, provisional/final rate) ; or
2. Effective October 1, 2024, 2CFR 200, the de minimis rate is now 15% of Modified Total Direct Cost (excludes participant support costs).
Describe if the host Site will be claiming indirect costs and if so, provide an effective and approved Indirect Cost Rate Agreement from the IHE Cognizant Agency for Indirect Cost. If no agreement exists, indirect costs are not allowable unless the De Minimis rate is used. Indirect rates may be applied only to a Modified Total Direct Cost (MTDC) base as defined in §200.1, which excludes Participant Support Costs.
(See §200.332-Requirements for Pass-Through Entities, §200.414-Indirect (F&A) costs, Appendix III to Part 200-Indirect (F&A) Costs Identification and Assignment, and Rate Determination for IHEs) Rate Type:
Eatmon, Robert (FHWA): Select the rate type that has been approved. (Fixed, Predetermined, Provisional, or De Minimis)
If a rate is being charged there must be an approval from the Cognizant Agency for Indirect Costs. If there is no approval, then a de minimis rate may be applied to modified total direct costs, but not to participant support costs.
Eatmon, Robert (FHWA): If your project will be using Advanced Construction, please place "X" here. Justification/Narrative
Effective Period Eatmon, Robert (FHWA): The ICRP must be approved for an effective period that includes the delivery period of the NSTI program.
Eatmon, Robert (FHWA): This is the date the NSTI worksheet is submitted to the State DOT. If there is a modification to an existing submittal, provide the date the modification is submitted. Approved Rate:
Eatmon, Robert (FHWA): Enter the rate that has been approved by the Cognizant Agency for Indirect Cost for an effective period that includes the delivery time for the NSTI program.
Modified Total Direct Cost (MTDC) Base:
Eatmon, Robert (FHWA): MTDC means all direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $25,000 of each subaward (regardless of the period of performance of the subawards under the award). MTDC excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs and the portion of each subaward in excess of $25,000. Other items may only be excluded when necessary to avoid a serious inequity in the distribution of indirect costs, and with the approval of the cognizant agency for indirect costs.
Eatmon, Robert (FHWA): These totals have conditional formatting and must equal the Total Funding and Contributions above. If the cell is highlighted you must adjust costs in the detail or modify the amounts identified in the Total Funding and Contribution to remain in balance.
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
Leave these fields blank.
Eatmon, Robert (FHWA): The total costs that will be paid with NSTI funds from the detail sections below.
This number must match the NSTI Funds requested in Cell B8.
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
Leave this field blank.
Eatmon, Robert (FHWA): The total costs that will be paid with 504(e) funds from the detail sections below.
| This number must match the 504(e) number requested in Cell G8. | $0.00 | ||
| Total Indirect Costs | |||
| (Rate x MTDC) | $0.00 | ||
| Indirect Cost Fund Allocation | NSTI Funds |
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
Leave these fields blank.
Eatmon, Robert (FHWA): The total costs that will be paid with State/Local funds from the detail sections below.
This number must match the State/Local Funds number in Cell I8.
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
Leave these fields blank.
Eatmon, Robert (FHWA): The total value of In-kind contributions that will be used towards the project identified in the In-Kind detail sections below.
This number must match the In-kind number in Cell J8.
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
Leave these fields blank.
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
Leave these fields blank.
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
Leave these fields blank.
Eatmon, Robert (FHWA): If a rate is entered here, it must be supported with an approval from the Cognizant Agency for Indirect Costs.
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
Leave these fields blank.
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
Leave these fields blank.
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
Leave these fields blank.
Gottlieb, Joyce (FHWA): Gottlieb, Joyce (FHWA):
| Leave these fields blank. | 504(e) | State/Local | In-kind | Total Cost |
| $0.00 |
File details come from the government source that posted it. Updated .