fy24-optional-budget_calculating_tool_Final.xlsx

XLSX spreadsheet 61 KB Posted Mar 27, 2024

Attached to: FY 2024 National Environmental Information Exchange Network Grant Program
Opportunity number: EPA-OMS-24-01
Issued by: Environmental Protection Agency

About this file

Written by GovTribe AI · Mar 28, 2024

This document is a template for an optional budget calculating tool for the FY 2024 National Environmental Information Exchange Network Grant Program. The tool is intended to help applicants correctly categorize and calculate project costs for budget submission. It includes detailed line items for personnel, fringe benefits, travel, equipment, supplies, contractual services, and indirect costs.

The related federal grant opportunity is the FY 2024 National Environmental Information Exchange Network Grant Program, solicitation number EPA-OMS-24-01, offered by the Environmental Protection Agency. The program provides cooperative agreements and grants to support the Environmental Information Exchange Network, with the goals of facilitating data sharing, reducing regulatory burden, streamlining data collection, and improving data quality and access. Eligible applicants include "Other" organizations. The funding activity categories are focused on the environment. The CFDA number for this program is 66.608.

From the source

Optional Budget Calculating Tool

View the file

Other files

File	Type	Posted
fy24-optional-project-narrative-template_Final.docx	DOCX document	Mar 27, 2024
fy24-optional-cover-letter-template_Final.docx	DOCX document	Mar 27, 2024
fy24-optional-budget-narrative-attachment-form-template_Final.docx	DOCX document	Mar 27, 2024
EPA-OMS-24-01.pdf	PDF	Mar 27, 2024
EPA-OMS-24-01_modified.pdf	PDF	Mar 27, 2024

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

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	Funding Threshold
Click Here for Drop-Down Arrow	$ -

	#1. Personnel Costs
	Staff Position
(Project Role)	Staff Name
(If Known)	Annual Salary	Percentage of Time	Annual Cost	Period of Performance
(Standard is 3 Years)	Personnel Cost
	Title 1	Full Name	$ - 0	0.00%	$ - 0	3	$ - 0
	Title 2	Full Name	$ - 0	0.00%	$ - 0	3	$ - 0
	Title 3	Full Name	$ - 0	0.00%	$ - 0	3	$ - 0
	Title 4	Full Name	$ - 0	0.00%	$ - 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	Personnel Cost	Fringe Benefit Rate	Fringe Cost
	Title 1	Full Name	$0	0.00%	$0
	Title 2	Full Name	$0	0.00%	$0
	Title 3	Full Name	$0	0.00%	$0
	Title 4	Full Name	$0	0.00%	$0
	Title 5	Full Name	$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				$0

#3. Travel
	Trip	Trip Item	Estimated Cost	Duration	# of Travelers	Travel Cost
		Airfare	$ - 0	N/A		$ - 0
		Per Diem	$ - 0	0	0	$ - 0
	1	Rental Car	$ - 0	0	0	$ - 0
		Milage	$ - 0	0	0	$ - 0
		Other	$ - 0	0	0	$ - 0
	Trip 1 Cost:					$0
		Airfare	$ - 0	N/A	0	$ - 0
		Per Diem	$ - 0	0	0	$ - 0
	2	Rental Car	$ - 0	0	0	$ - 0
		Milage	$ - 0	0	0	$ - 0
		Other	$ - 0	0	0	$ - 0
	Trip 2 Cost:					$0
		Airfare	$ - 0	N/A	0	$ - 0
		Per Diem	$ - 0		0	$ - 0
	3	Rental Car	$ - 0	0	0	$ - 0
		Milage	$ - 0	0	0	$ - 0
		Other	$ - 0	0	0	$ - 0
	Trip 3 Cost:					$0
		Airfare	$ - 0	N/A		$ - 0
		Per Diem	$ - 0			$ - 0
	4	Rental Car	$ - 0			$ - 0
		Milage	$ - 0			$ - 0
		Other	$ - 0			$ - 0
	Trip 4 Cost:					$0
	Total Travel Costs					$0

#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	Quantity	Price per Unit	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 $5,000
		Supply Category	Item Name	Quantity	Price per Unit	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: $91.95 is the max hourly rate for an individual consultant. Single-Source contract procurement requires a justification in the budget narrative.
		Contract Type	Procurement Method	Hours	Hourly Rate	Contractual Cost
		Select Contract Type	Select from Drop Down		$ - 0	$ - 0
		Select Contract Type	Select from Drop Down		$ - 0	$ - 0
		0			$ - 0	$ - 0
		0			$ - 0	$ - 0
		0			$ - 0	$ - 0
		Total Contractual Cost				$0

#7. Other
	Category	Item Name	Quantity	Price per Unit	Other Cost
	Select from Drop Down	Other Item 1			$ - 0
	Select from Drop Down	Other Item 2			$ - 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/2024.
		Effective Period	IDC Rate	Description of Base*	Base Amount**	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