FY25_EN_Budget_Tool_508_FINAL.xlsx

61 KB Posted

Attached to
Fiscal Year 2025 National Environmental Information Exchange Network Grant Program Solicitation Notice
Opportunity number
EPA-OMS-25-01
Issued by

About this file

Written by GovTribe AI ·

This is a budget calculation tool spreadsheet template for the FY2025 Exchange Network Grant Program. The template helps applicants calculate and categorize costs across eight budget categories: Personnel, Fringe Benefits, Travel, Equipment (items ≥$10,000), Supplies (items <$10,000), Contractual (with $93.53 maximum hourly rate for consultants), Other costs, and Indirect Costs.

The template includes both blank forms for applicant input and an example budget totaling $270,561 for a Capacity Building with Mentorship project. The example shows detailed breakdowns including three staff positions (Program Manager, Environmental Engineer, Data Scientist), equipment purchases like S-Node SRF units ($6,704 each) and TRILR Sensors ($8,123 each), and a consultant contract at $87.93/hour for 580 hours. The template is designed to generate numbers that can be used in the Budget Narrative Attachment Form, SF424-A Form, and Project Narrative Section 7, though it does not replace these required documents.

From the source

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
V10_fy25_optional_en_budget_tool.xlsx XLSX spreadsheet
FINAL_V2_EPA-OMS-25-01.pdf PDF
EPA-OMS-25-01_modification.pdf PDF
EPA-OMS-25-01.pdf 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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Template

Optional Exchange Network Budget Calculating Tool v.7
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 CostPeriod of Performance
3-Year Personnel Cost
Title 1Full Name$ - 03$ - 0
Title 2Full Name$ - 03$ - 0
Title 3Full Name$ - 03$ - 0
Title 4Full Name$ - 03$ - 0
Title 5Full Name$ - 00.00%$ - 03$ - 0
0.00%$ - 03$ - 0
$ - 03$ - 0
$ - 03$ - 0
$ - 03$ - 0
$ - 03$ - 0
Total Personnel Costs$0
#2. Fringe Benefits
Staff PositionStaff Name3-Year Personnel CostFringe Benefit Rate (Highlighted)3-Year Fringe Cost
Title 1Full Name$0$0
Title 2Full Name$0$0
Title 3Full Name$0$0
Title 4Full Name$0$0
Title 5Full Name$00.00%$0
Total Fringe Costs$0
#3. Travel
Trip ItemEstimated Cost (Highlighted)Duration (Highlighted)# of Travelers (Highlighted)Travel Cost
Airfare$ 323.30N/A$ - 0
Per Diem$ - 0
Rental Car$ - 0
Milage$ - 0
Hotel$ - 0
Trip 1 Cost:$0
Airfare$ - 0N/A0$ - 0
Per Diem$ - 000$ - 0
Rental Car$ - 000$ - 0
Milage$ - 000$ - 0
Hotel$ - 000$ - 0
Trip 2 Cost:$0
Airfare$ - 0N/A0$ - 0
Per Diem$ - 00$ - 0
Rental Car$ - 000$ - 0
Milage$ - 000$ - 0
Hotel$ - 000$ - 0
Trip 3 Cost:$0
Airfare$ - 0N/A$ - 0
Per Diem$ - 0$ - 0
Rental Car$ - 0$ - 0
Milage$ - 0$ - 0
Hotel$ - 0$ - 0
Trip 4 Cost:$0
Total$0
#4. EquipmentNOTE: 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 10$ - 0$ - 0
Item 20$ - 0$ - 0
Item 30$ - 0$ - 0
0$ - 0$ - 0
0$ - 0$ - 0
0$ - 0$ - 0
0$ - 0$ - 0
0$ - 0$ - 0
Total Equipment Cost$0
#5. SuppliesNOTE: 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 20$ - 0$ - 0
Supply Item 30$ - 0$ - 0
$ - 0$ - 0
0$ - 0$ - 0
0$ - 0$ - 0
0$ - 0$ - 0
Total Supplies Cost$0
#6. ContractualNOTE: $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 TypeSelect from Drop Down$ - 0$ - 0
Select Contract TypeSelect 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 DownOther Item 1$ - 0$ - 0
Select from Drop DownOther Item 2$ - 0$ - 0
0$ - 0$ - 0
0$ - 0$ - 0
0$ - 0$ - 0
$ - 0$ - 0
Total 'Other' Cost$0
#8. Indirect CostsNOTE: Rate must be valid until at least 9/30/2024.
Effective PeriodIDC Rate (Highlighted)Description of Base*Base Amount** (Highlighted)Total Indirect Costs
xx/xx/xxxx - xx/xx/xxxx0.00%$ - 0$ - 0
**Add base costs using '=SUM(blue rows in column G)'
Total Budget$ - 0
Remaining Balance Against Funding ThresholdERROR:#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
Capacity Building with MentorshipERROR:#N/A
#1. Personnel Costs
Staff Position
(Project Role) (Highlighted)Staff Name
(If Known) (Highlighted)Annual Salary (Highlighted)Percentage of Time (Highlighted)Annual CostPeriod of Performance
(Standard is 3 Years)Personnel Cost
Program ManagerFirstname Lastname$ 93,012.004.00%$ 3,7203$ 11,161
Env. EngineerFirstname Lastname$ 89,342.0015.00%$ 13,4013$ 40,204
Data ScientistFirstname Lastname$ 75,138.0020.00%$ 15,0283$ 45,083
$ - 00.00%$ - 03$ - 0
$ - 00.00%$ - 03$ - 0
0.00%$ - 03$ - 0
$ - 03$ - 0
$ - 03$ - 0
$ - 03$ - 0
$ - 03$ - 0
Total Personnel Costs$96,448
#2. Fringe Benefits
Staff PositionStaff NamePersonnel CostFringe Benefit Rate (Highlighted)Fringe Cost
Program ManagerFirstname Lastname$11,16134.00%$3,795
Env. EngineerFirstname Lastname$40,20434.00%$13,669
Data ScientistFirstname Lastname$45,08334.00%$15,328
00$00.00%$0
00$00.00%$0
00$00.00%$0
00$0$0
00$0$0
00$0$0
00$0$0
Total Fringe Costs$32,792
#3. Travel
Trip ItemEstimated Cost (Highlighted)Duration (Highlighted)# of Travelers (Highlighted)Travel Cost
Airfare$ 340N/A2$ 680
Per Diem$ 17642$ 1,408
Rental Car$ - 000$ - 0
Milage$ - 000$ - 0
Other$ - 000$ - 0
Trip 1 Cost:$2,088
Airfare$ - 0N/A0$ - 0
Per Diem$ - 000$ - 0
Rental Car$ - 000$ - 0
Milage$ - 000$ - 0
Other$ - 000$ - 0
$0
Airfare$ - 0N/A0$ - 0
Per Diem$ - 00$ - 0
Rental Car$ - 000$ - 0
Milage$ - 000$ - 0
Other$ - 000$ - 0
$0
Airfare$ - 0N/A$ - 0
Per Diem$ - 0$ - 0
Rental Car$ - 0$ - 0
Milage$ - 0$ - 0
Other$ - 0$ - 0
$0
Total$2,088
#4. EquipmentNOTE: 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 SRF2$ 6,704.00$ 13,408
UQX Monitor1$ 10,023.00$ 10,023
TRILR Sensor4$ 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. SuppliesNOTE: Price per unit should be LESS THAN $5,000
Supply Category (Highlighted)Item Name (Highlighted)Quantity (Highlighted)Price per Unit (Highlighted)Supplies Cost
Testing SuppliesField Kit15$ 63$ 945
Computing DeviceRugged Tablet10$ 450$ 4,500
Supply Item 30$ - 0$ - 0
$ - 0$ - 0
0$ - 0$ - 0
0$ - 0$ - 0
0$ - 0$ - 0
Total Supplies Cost$5,445
#6. ContractualNOTE: $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 ConsultantSingle Source*580.00$ 87.93$ 50,999
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 ServiceOn-site testing facility36$ 165.00$ 5,940
Select from Drop DownOther Item 2$ - 0
0$ - 0
0$ - 0
0$ - 0
$ - 0
Total 'Other' Cost$5,940
#8. Indirect CostsNOTE: Rate must be valid until at least 9/30/2024.
Effective PeriodIDC Rate (Highlighted)Description of Base*Base Amount** (Highlighted)Total Indirect Costs
10/1/2024-9/30/202515.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 ThresholdERROR:#N/A

Data Vali

Contract TypesOther' Category TypesSupply' Category Types
Select from Drop DownSelect from Drop DownSelect from Drop Down
Sealed BidRental and Lease CostMonitoring Supplies
Non-Competative*Participant Support CostsComputing Device
Request for ProposalsSubawardTesting Supplies
Other *Please ExplainEquipment Rental/LeaseOther *Please Explain
Internet Service
Meeting FacilitiesContractual
Light Food & BeverageContracting Firm
Other *Please ExplainIndividual Consultant
Vendor Firm
Select Contract Type
Applicant Type
Click Here for Drop-Down Arrow$ -
Individual Assistance Agreement$ 300,000.00
EN Partnership Agreement$ 500,000.00
Capacity Buildling with Mentorship$ 315,000.00

File details come from the government source that posted it. Updated .