V10_fy25_optional_en_budget_tool.xlsx
XLSX spreadsheet 66 KB Posted
- Attached to
- Fiscal Year 2025 National Environmental Information Exchange Network Grant Program Solicitation Notice
- Opportunity number
- EPA-OMS-25-01
- Issued by
-
Environmental Protection Agency
About this file
This document is an Excel-based Optional Exchange Network Budget Calculating Tool designed to help applicants calculate project budgets for the EPA's Fiscal Year 2025 National Environmental Information Exchange Network Grant Program. The budget template provides a structured approach for detailing costs across eight budget categories: Personnel Costs, Fringe Benefits, Travel, Equipment, Supplies, Contractual, Other Costs, and Indirect Costs, with an example budget demonstrating realistic entries for a potential project.
The associated federal grant opportunity is administered by the Environmental Protection Agency (EPA) under the Environmental Information Exchange Network Grant Program (CFDA 66.608), which aims to facilitate environmental data sharing among states, territories, and tribes. The grant program supports projects that improve environmental data management, with funding instruments including cooperative agreements and grants. The example budget shows a total project budget of $270,561 against a funding threshold of $400,000, with eligible applicants including states, U.S. territories, federally recognized tribes, and inter-tribal consortia. The current solicitation has a revised application due date of March 20th, 2025, with anticipated individual awards ranging from $200,000 to $500,000.
FY25 EN Budget Tool
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Changes Since Prior SN Version - Summary.docx | DOCX document | |
| fy25-optional-project-narrative-template_508_FINAL.docx | DOCX document | |
| updated_fy25-optional-project-narrative-template_508_FINAL.docx | DOCX document | |
| updated_fy25-optional-cover-letter-template_508_FINAL.docx | DOCX document | |
| fy25-optional-cover-letter-template_508_FINAL.docx | DOCX document | |
| updated_fy25-optional-budget-narrative-attachment-form-template_508_FINAL.docx | DOCX document | |
| fy25-optional-budget-narrative-attachment-form-template_508_FINAL.docx | DOCX document | |
| FY25_EN_Budget_Tool_508_FINAL.xlsx | XLSX spreadsheet | |
| FINAL_V2_EPA-OMS-25-01.pdf | ||
| EPA-OMS-25-01_modification.pdf | ||
| EPA-OMS-25-01.pdf |
Show all 11
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
Template
| Optional Exchange Network Budget Calculating Tool v.9 |
| Users Guide: This tool is intended to help calculate the project budget and correctly categorize costs. You can use the numbers generated by this sheet to input costs per budget category in the Budget Narrative Attachment |
| Form, the SF424-A Form, and Project Narrative, Section 7 'Overview of Project Budget'. It is not intended to be used in place of any of these documents. |
Highlighted columns indicate areas where you may enter information
| (as needed). Non-highlighted areas are automatically calculated. To add rows, copy the row above your last entry then right-click or use the 'clipboard' to use the 'insert copied cells' paste option. | |||||||
| Please do not delete rows as this may result in formula errors. Instead, hide unwanted rows by selecting them and using 'hide' in the right-click menu options. | |||||||
| A Note on Errors: | |||||||
| #VALUE!' indicates that needed information is missing or has been entered incorrectly. If you get this error please check that you have selected a budget option in cell E128. | |||||||
| #REF' indicates that a cell can no longer be referenced to complete the formula. If you get this error, please check that you have not deleted any columns or rows. | |||||||
| Also, check that you have inserted any new rows using the 'insert copied cells' option. | |||||||
| Improper Percentages: If a number is entered and the percent displays incorrectly, try entering the number as a decimal. (15.8% = 0.158) | |||||||
| Feel free to contact the Exchange Network Grants Team at engrantprogram@epa.gov with any issues or questions regarding this form. | |||||||
| Applicant Type (Highlighted) | Funding Threshold | ||||||
| Click Here for Drop-Down Arrow | $ - | ||||||
| #1. Personnel Costs | |||||||
| Staff Position | |||||||
| (Project Role) (Highlighted) | Staff Name | ||||||
| (If Known) (Highlighted) | Annual Salary (Highlighted) | Percentage of Time (Highlighted) | Annual Cost | Period of Performance | |||
| 3-Year Personnel Cost | |||||||
| Title 1 | Full Name | $ - 0 | $ - 0 | 3 | $ - 0 | ||
| Title 2 | Full Name | $ - 0 | $ - 0 | 3 | $ - 0 | ||
| Title 3 | Full Name | $ - 0 | $ - 0 | 3 | $ - 0 | ||
| Title 4 | Full Name | $ - 0 | $ - 0 | 3 | $ - 0 | ||
| Title 5 | Full Name | $ - 0 | 0.00% | $ - 0 | 3 | $ - 0 | |
| 0.00% | $ - 0 | 3 | $ - 0 | ||||
| $ - 0 | 3 | $ - 0 | |||||
| $ - 0 | 3 | $ - 0 | |||||
| $ - 0 | 3 | $ - 0 | |||||
| $ - 0 | 3 | $ - 0 | |||||
| Total Personnel Costs | $0 | ||||||
| #2. Fringe Benefits | |||||||
| Staff Position | Staff Name | 3-Year Personnel Cost | Fringe Benefit Rate (Highlighted) | 3-Year Fringe Cost | |||
| Title 1 | Full Name | $0 | $0 | ||||
| Title 2 | Full Name | $0 | $0 | ||||
| Title 3 | Full Name | $0 | $0 | ||||
| Title 4 | Full Name | $0 | $0 | ||||
| Title 5 | Full Name | $0 | 0.00% | $0 | |||
| Total Fringe Costs | $0 | ||||||
| #3. Travel | |||||||
| Trip Item | Estimated Cost (Highlighted) | Duration (Highlighted) | # of Travelers (Highlighted) | Travel Cost | |||
| Airfare | $ - 0 | N/A | $ - 0 | ||||
| Per Diem | $ - 0 | $ - 0 | |||||
| Rental Car | $ - 0 | $ - 0 | |||||
| Milage | $ - 0 | $ - 0 | |||||
| Hotel | $ - 0 | $ - 0 | |||||
| Trip 1 Cost: | $0 | ||||||
| Airfare | $ - 0 | N/A | 0 | $ - 0 | |||
| Per Diem | $ - 0 | 0 | 0 | $ - 0 | |||
| Rental Car | $ - 0 | 0 | 0 | $ - 0 | |||
| Milage | $ - 0 | 0 | 0 | $ - 0 | |||
| Hotel | $ - 0 | 0 | 0 | $ - 0 | |||
| Trip 2 Cost: | $0 | ||||||
| Airfare | $ - 0 | N/A | 0 | $ - 0 | |||
| Per Diem | $ - 0 | 0 | $ - 0 | ||||
| Rental Car | $ - 0 | 0 | 0 | $ - 0 | |||
| Milage | $ - 0 | 0 | 0 | $ - 0 | |||
| Hotel | $ - 0 | 0 | 0 | $ - 0 | |||
| Trip 3 Cost: | $0 | ||||||
| Airfare | $ - 0 | N/A | $ - 0 | ||||
| Per Diem | $ - 0 | $ - 0 | |||||
| Rental Car | $ - 0 | $ - 0 | |||||
| Milage | $ - 0 | $ - 0 | |||||
| Hotel | $ - 0 | $ - 0 | |||||
| Trip 4 Cost: | $0 | ||||||
| Total | $0 | ||||||
| #4. Equipment | NOTE: Price per Unit should = $10,000 or more, a unit costing less than $10,000 should be categorized under 'Supplies' (#5, below) | ||||||
| Item Name (Highlighted) | Quantity (Highlighted) | Price per Unit (Highlighted) | Equipment Cost | ||||
| Item 1 | 0 | $ - 0 | $ - 0 | ||||
| Item 2 | 0 | $ - 0 | $ - 0 | ||||
| Item 3 | 0 | $ - 0 | $ - 0 | ||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| Total Equipment Cost | $0 | ||||||
| #5. Supplies | NOTE: Price per unit should be LESS THAN $10,000) | ||||||
| Supply Category (Highlighted) | Item Name/Description (Highlighted) | Quantity (Highlighted) | Price per Unit (Highlighted) | Supplies Cost | |||
| Supply Item 1 | $ - 0 | $ - 0 | |||||
| Supply Item 2 | 0 | $ - 0 | $ - 0 | ||||
| Supply Item 3 | 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| Total Supplies Cost | $0 | ||||||
| #6. Contractual | NOTE: $93.53 is the max hourly rate for an individual consultant. Single-Source contract procurement requires a justification in the budget narrative. | ||||||
| Contract Type (Highlighted) | Procurement Method (Highlighted) | Hours (Highlighted) | Hourly Rate (Highlighted) | Contractual Cost | |||
| Select Contract Type | Select from Drop Down | $ - 0 | $ - 0 | ||||
| Individual Consultant | Select from Drop Down | $ - 0 | $ - 0 | ||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| Total Contractual Cost | $0 | ||||||
| #7. Other | |||||||
| Category (Highlighted) | Name/Description (Highlighted) | Quantity (Highlighted) | Price per Unit (Highlighted) | Other Cost | |||
| Select from Drop Down | Other Item 1 | $ - 0 | $ - 0 | ||||
| Select from Drop Down | Other Item 2 | $ - 0 | $ - 0 | ||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| $ - 0 | $ - 0 | ||||||
| Total 'Other' Cost | $0 | ||||||
| #8. Indirect Costs | NOTE: Rate must be valid until at least 9/30/2026. | ||||||
| Effective Period | IDC Rate (Highlighted) | Description of Base* | Base Amount** (Highlighted) | Total Indirect Costs | |||
| xx/xx/xxxx - xx/xx/xxxx | 0.00% | $ - 0 | $ - 0 | ||||
| **Add base costs using '=SUM(blue rows in column G)' | |||||||
| Total Budget | $ - 0 | ||||||
| Remaining Balance Against Funding Threshold | ERROR:#VALUE! |
Example_FY24
| Optional Exchange Network Budget EXAMPLE |
| Users Guide: This tool is intended to help calculate the project budget and correctly categorize costs. You can use the numbers generated by this sheet to input costs per budget category in the Budget Narrative Attachment Form, the SF424-A Form, and Project Narrative, Section 7 'Overview of Project Budget'. It is not intended to be used in place of any of these documents. |
| Highlighted columns indicate areas where you may enter information (as needed). Non-highlighted areas are automatically calculated. | |||||||
| To add rows, copy the row above your last entry then right-click or use the 'clipboard' to use the 'insert copied cells' paste option. | |||||||
| Please do not delete rows as this may result in formula errors. Instead, hide unwanted rows by selecting them and using 'hide' in the right-click menu options. | |||||||
| A Note on Errors: | |||||||
| #VALUE!' indicates that needed information is missing or has been entered incorrectly. If you get this error please check that you have selected a budget option in cell E128. | |||||||
| #REF' indicates that a cell can no longer be referenced to complete the formula. If you get this error, please check that you have not deleted any columns or rows. | |||||||
| Also, check that you have inserted any new rows using the 'insert copied cells' option. | |||||||
| Improper Percentages: If a number is entered and the percent displays incorrectly, try entering the number as a decimal. (15.8% = 0.158) | |||||||
| Feel free to contact the Exchange Network Grants Team at engrantprogram@epa.gov with any issues or questions regarding this form. | |||||||
| Applicant Type (Highlighted) | Funding Threshold | ||||||
| Individual Assistance Agreement | $400,000 | ||||||
| #1. Personnel Costs | |||||||
| Staff Position | |||||||
| (Project Role) (Highlighted) | Staff Name | ||||||
| (If Known) (Highlighted) | Annual Salary (Highlighted) | Percentage of Time (Highlighted) | Annual Cost | Period of Performance | |||
| (Standard is 3 Years) | Personnel Cost | ||||||
| Program Manager | Firstname Lastname | $ 93,012.00 | 4.00% | $ 3,720 | 3 | $ 11,161 | |
| Env. Engineer | Firstname Lastname | $ 89,342.00 | 15.00% | $ 13,401 | 3 | $ 40,204 | |
| Data Scientist | Firstname Lastname | $ 75,138.00 | 20.00% | $ 15,028 | 3 | $ 45,083 | |
| $ - 0 | 0.00% | $ - 0 | 3 | $ - 0 | |||
| $ - 0 | 0.00% | $ - 0 | 3 | $ - 0 | |||
| 0.00% | $ - 0 | 3 | $ - 0 | ||||
| $ - 0 | 3 | $ - 0 | |||||
| $ - 0 | 3 | $ - 0 | |||||
| $ - 0 | 3 | $ - 0 | |||||
| $ - 0 | 3 | $ - 0 | |||||
| Total Personnel Costs | $96,448 | ||||||
| #2. Fringe Benefits | |||||||
| Staff Position | Staff Name | Personnel Cost | Fringe Benefit Rate (Highlighted) | Fringe Cost | |||
| Program Manager | Firstname Lastname | $11,161 | 34.00% | $3,795 | |||
| Env. Engineer | Firstname Lastname | $40,204 | 34.00% | $13,669 | |||
| Data Scientist | Firstname Lastname | $45,083 | 34.00% | $15,328 | |||
| 0 | 0 | $0 | 0.00% | $0 | |||
| 0 | 0 | $0 | 0.00% | $0 | |||
| 0 | 0 | $0 | 0.00% | $0 | |||
| 0 | 0 | $0 | $0 | ||||
| 0 | 0 | $0 | $0 | ||||
| 0 | 0 | $0 | $0 | ||||
| 0 | 0 | $0 | $0 | ||||
| Total Fringe Costs | $32,792 | ||||||
| #3. Travel | |||||||
| Trip Item | Estimated Cost (Highlighted) | Duration (Highlighted) | # of Travelers (Highlighted) | Travel Cost | |||
| Airfare | $ 340 | N/A | 2 | $ 680 | |||
| Per Diem | $ 176 | 4 | 2 | $ 1,408 | |||
| Rental Car | $ - 0 | 0 | 0 | $ - 0 | |||
| Milage | $ - 0 | 0 | 0 | $ - 0 | |||
| Other | $ - 0 | 0 | 0 | $ - 0 | |||
| Trip 1 Cost: | $2,088 | ||||||
| Airfare | $ - 0 | N/A | 0 | $ - 0 | |||
| Per Diem | $ - 0 | 0 | 0 | $ - 0 | |||
| Rental Car | $ - 0 | 0 | 0 | $ - 0 | |||
| Milage | $ - 0 | 0 | 0 | $ - 0 | |||
| Other | $ - 0 | 0 | 0 | $ - 0 | |||
| $0 | |||||||
| Airfare | $ - 0 | N/A | 0 | $ - 0 | |||
| Per Diem | $ - 0 | 0 | $ - 0 | ||||
| Rental Car | $ - 0 | 0 | 0 | $ - 0 | |||
| Milage | $ - 0 | 0 | 0 | $ - 0 | |||
| Other | $ - 0 | 0 | 0 | $ - 0 | |||
| $0 | |||||||
| Airfare | $ - 0 | N/A | $ - 0 | ||||
| Per Diem | $ - 0 | $ - 0 | |||||
| Rental Car | $ - 0 | $ - 0 | |||||
| Milage | $ - 0 | $ - 0 | |||||
| Other | $ - 0 | $ - 0 | |||||
| $0 | |||||||
| Total | $2,088 | ||||||
| #4. Equipment | NOTE: Price per Unit should = $5,000 or more, a unit costing less than $5,000 should be categorized under 'Supplies' (#5, below) | ||||||
| Item Name (Highlighted) | Quantity (Highlighted) | Price per Unit (Highlighted) | Equipment Cost | ||||
| S-Node SRF | 2 | $ 6,704.00 | $ 13,408 | ||||
| UQX Monitor | 1 | $ 10,023.00 | $ 10,023 | ||||
| TRILR Sensor | 4 | $ 8,123.00 | $ 32,492 | ||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| Total Equipment Cost | $55,923 | ||||||
| #5. Supplies | NOTE: Price per unit should be LESS THAN $5,000 | ||||||
| Supply Category (Highlighted) | Item Name (Highlighted) | Quantity (Highlighted) | Price per Unit (Highlighted) | Supplies Cost | |||
| Testing Supplies | Field Kit | 15 | $ 63 | $ 945 | |||
| Computing Device | Rugged Tablet | 10 | $ 450 | $ 4,500 | |||
| Supply Item 3 | 0 | $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| Total Supplies Cost | $5,445 | ||||||
| #6. Contractual | NOTE: $87.93 is the max hourly rate for an individual consultant. Single-Source contract procurement requires a justification in the budget narrative. | ||||||
| Contract Type (Highlighted) | Procurement Method (Highlighted) | Hours (Highlighted) | Hourly Rate (Highlighted) | Contractual Cost | |||
| Individual Consultant | Sealed Bid | 580.00 | $ 87.93 | $ 50,999 | |||
| $ - 0 | |||||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| 0 | $ - 0 | $ - 0 | |||||
| Total Contractual Cost | $50,999 | ||||||
| #7. Other | |||||||
| Category (Highlighted) | Item Name (Highlighted) | Quantity (Highlighted) | Price per Unit (Highlighted) | Other Cost | |||
| Internet Service | On-site testing facility | 36 | $ 165.00 | $ 5,940 | |||
| Select from Drop Down | Other Item 2 | $ - 0 | |||||
| 0 | $ - 0 | ||||||
| 0 | $ - 0 | ||||||
| 0 | $ - 0 | ||||||
| $ - 0 | |||||||
| Total 'Other' Cost | $5,940 | ||||||
| #8. Indirect Costs | NOTE: Rate must be valid until at least 9/30/2024. | ||||||
| Effective Period | IDC Rate (Highlighted) | Description of Base* | Base Amount** (Highlighted) | Total Indirect Costs | |||
| 10/1/2024-9/30/2025 | 15.30% | Other, Supplies, Travel, Personnel, Fringe | $ 136,773 | $ 20,926 | |||
| **Add base costs using '=SUM(blue rows in column G)' | |||||||
| Total Budget | $270,561 | ||||||
| Remaining Balance Against Funding Threshold | $129,438.57 |
Data Vali
| Contract Types | Other' Category Types | Supply' Category Types |
| Select from Drop Down | Select from Drop Down | Select from Drop Down |
| Sealed Bid | Rental and Lease Cost | Monitoring Supplies |
| Non-Competative* | Participant Support Costs | Computing Device |
| Request for Proposals | Subaward | Testing Supplies |
| Other *Please Explain | Equipment Rental/Lease | Other *Please Explain |
| Internet Service | ||
| Meeting Facilities | Contractual | |
| Light Food & Beverage | Contracting Firm | |
| Other *Please Explain | Individual Consultant | |
| Vendor Firm | ||
| Select Contract Type |
| Applicant Type | |
| Click Here for Drop-Down Arrow | $ - |
| Individual Assistance Agreement | $ 400,000.00 |
| EN Partnership Agreement | $ 600,000.00 |
| Capacity Building with Mentorship | $ 415,000.00 |
File details come from the government source that posted it. Updated .