2019 US ST Proposal Tables Template.xlsx

XLSX spreadsheet 32 KB Posted Dec 20, 2018

Attached to: North America Wetlands Conservation Act 2020-1 U.S. Standard Grants
Opportunity number: F19AS00031
Issued by: Department of the Interior

About this file

From the source

2019 US ST Proposal Tables Template & Examples

View the file

Other files

File	Type	Posted
PKG00247121-instructions.pdf	PDF	Dec 20, 2018
2019 Eligibility Criteria and Processes FINAL.pdf	PDF	Dec 20, 2018
2019 US Standard Proposal Outline Template.docx	DOCX document	Dec 20, 2018
2019 US Standard Instructions FINAL.pdf	PDF	Dec 20, 2018

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.

Financial Table

ACTIVITIES	GRANT $	MATCHING PARTNERS				TRACT ID	NON-MATCH $
		ABBREVIATED PARTNER NAME	OLD MATCH $	NEW MATCH $	TOTAL

GRANT + MATCH $

	Land Costs: Fee Acquired	$		$	$	$		$
	Appraisals & Other Acquisition Costs	$		$	$	$		$
	Non-Contract Personnel & Travel	$		$	$	$		$
	A. TOTAL FEE ACQUIRED	$		$	$	$		$
	Land Costs: Fee Donated	$		$	$	$		$
	Appraisals & Other Acquisition Costs	$		$	$	$		$
	Non-Contract Personnel & Travel	$		$	$	$		$
	B. TOTAL FEE DONATED	$		$	$	$		$
	Land Costs: Easement Acquired	$		$	$	$		$
	Appraisals & Other Acquisition Costs	$		$	$	$		$
	Non-Contract Personnel & Travel	$		$	$	$		$
	C. TOTAL EASEMENT ACQUIRED	$		$	$	$		$
	Land Costs: Easement Donated	$		$	$	$		$
	Appraisals & Other Acquisition Costs	$		$	$	$		$
	Non-Contract Personnel & Travel	$		$	$	$		$
	D. TOTAL EASEMENT DONATED	$		$	$	$		$
	Land Costs: Lease Acquired	$		$	$	$		$
	Appraisals & Other Acquisition Costs	$		$	$	$		$
	Non-Contract Personnel & Travel	$		$	$	$		$
	E. TOTAL LEASE ACQUIRED	$		$	$	$		$
	Land Costs: Lease Donated	$		$	$	$		$
	Appraisals & Other Acquisition Costs	$		$	$	$		$
	Non-Contract Personnel & Travel	$		$	$	$		$
	F. TOTAL LEASE DONATED	$		$	$	$		$
	G. TOTAL ACQUIRED
(Sum of A,B,C,D,E,F)	$		$	$	$		$
	Contracts	$		$	$	$		$
	Materials & Equipment	$		$	$	$		$
	Non-Contract Personnel & Travel	$		$	$	$		$
	H. TOTAL RESTORED	$		$	$	$		$
	Contracts	$		$	$	$		$
	Materials & Equipment	$		$	$	$		$
	Non-Contract Personnel & Travel	$		$	$	$		$
	I. TOTAL ENHANCED	$		$	$	$		$
	Contracts	$		$	$	$		$
	Materials & Equipment	$		$	$	$		$
	Non-Contract Personnel & Travel	$		$	$	$		$
	J. TOTAL ESTABLISHED WETLANDS	$		$	$	$		$
	Grant Administration	$		$	$	$		$
	K. TOTAL OTHER DIRECT	$		$	$	$		$
	L. PREVIOUSLY APPROVED MCP			$		$
	M. GRAND TOTAL DIRECT
(Sum of G and H,I,J,K,L)	$		$	$	$		$
	Indirect Costs	$		$	$	$		$
	N. TOTAL INDIRECT	$		$	$	$		$
	GRAND TOTAL
(Sum of M and N)	$		$	$	$		$

PARTNER INFORMATION GRANT $ MATCHING PARTNERS TRACT ID NON-

MATCH $

ABBREVIATED PARTNER NAME OLD MATCH $ NEW MATCH $ TOTAL

GRANT + MATCH $

Full Partner Name 1	$	$	$	$	$
Full Partner Name 2	$	$	$	$	$
Full Partner Name 3…….	$	$	$	$	$
GRAND TOTAL	$	$	$	$	$

Financial Table Example

ACTIVITIES	GRANT $	MATCHING PARTNERS				TRACT ID	NON-MATCH $
		ABBREVIATED PARTNER NAME	OLD MATCH $	NEW MATCH $	TOTAL

GRANT + MATCH $

	Land Costs: Fee Acquired	$180,000	IDNR			$180,000	1
			LCCB		$580,000	$580,000	1
		$45,000	IDNR			$45,000	2
			INHF		$620,650	$620,650	2
			LCCB		$154,350	$154,350	2
			HTU	$73,800		$73,800	3
			IDNR	$475,000		$475,000	4
			PF-L		$10,000	$10,000	5
			TRCF		$10,000	$10,000	5
			IDNR		$63,000	$63,000	6
			PF-W		$20,000	$20,000	7
			PF-IC		$10,000	$10,000	7
			IDNR	$1,027,000		$1,027,000	8
		$475,000	IDNR		$125,000	$600,000	11
	Appraisals & Other Acquisition Costs		LCCB		$25,000	$25,000	1
			LCCB		$30,300	$30,300	2
	A. TOTAL FEE ACQUIRED	$700,000		$1,575,800	$1,648,300	$3,924,100		$0
	G. TOTAL ACQUIRED
(Sum of A,B,C,D,E,F)	$700,000		$1,575,800	$1,648,300	$3,924,100		$0
	Contracts	$100,000	IDNR		$150,000	$250,000	9
		$80,000	IDNR		$162,000	$242,000	10
	Materials & Equipment	$55,000	IDNR			$55,000	9
			USFWS			$0	9	$25,000
		$25,000	IDNR		$10,000	$35,000	10
			USFWS			$0	10	$25,000
	Non-Contract Personnel & Travel	$20,000	IDNR			$20,000	9
		$20,000	IDNR			$20,000	10
	I. TOTAL ENHANCED	$300,000		$0	$322,000	$622,000		$0
	M. GRAND TOTAL DIRECT
(Sum of G and H,I,J,K,L)	$1,000,000		$1,575,800	$1,970,300	$4,546,100		$0
	Indirect Costs		IDNR		$3,000	$3,000	9
	N. TOTAL INDIRECT	$0		$0	$3,000	$3,000		$0
	GRAND TOTAL
(Sum of M and N)	$1,000,000		$1,575,800	$1,973,300	$4,549,100		$0

PARTNER INFORMATION	GRANT $	MATCHING PARTNERS				TRACT ID	NON-MATCH $
		ABBREVIATED PARTNER NAME	OLD MATCH $	NEW MATCH $	TOTAL

GRANT + MATCH $

Iowa Department of Natural Resources	$1,000,000	IDNR	$1,502,000	$513,000	$3,015,000	1,2,4,6,8,9,10
Iowa Natural Heritage Foundation		INHF		$620,650	$620,650	2
Lee County Conservation Board		LCCB		$789,650	$789,650	1,2
Hardwood Timberland Unlimited		HTU	$73,800		$73,800	3
Pheasants Forever, Warren County Chapter		PF-W		$20,000	$20,000	7
Pheasants Forever, Iowa Capital Chapter		PF-IC		$10,000	$10,000	7
Pheasants Forever, Lee County Chapter		PF-L		$10,000	$10,000	5
Three Rivers Conservation Foundation		TRCF		$10,000	$10,000	5
U.S. Fish and Wildlife Service		USFWS				9,10	$50,000
GRAND TOTAL	$1,000,000		$1,575,800	$1,973,300	$4,549,100		$50,000

Work Plan Itemized Costs Tables

Use table below for Acquisition Direct Costs
Item & Work	Units	$/unit	Total $	Schedule (month, year)	Funding Source

(Grant or Partner name)

LAND COSTS

Subtotal Land Costs	$
APPRAISALS and OTHER ACQUISITION COSTS

Subtotal Appraisals and Other Acquisition Costs	$
NON-CONTRACT PERSONNEL and TRAVEL

Subtotal Non-Contract Personnel and Travel	$
TOTAL ACQUISITION DIRECT COSTS	$

Use table below for Restoration Direct Costs
Item & Work	Units	$/unit	Total $	Schedule (month, year)	Funding Source

CONTRACTS

Subtotal Contracts	$
MATERIALS and EQUIPMENT

Subtotal Materials and Equipment	$
NON-CONTRACT PERSONNEL and TRAVEL

Subtotal Non-Contract Personnel			$
TOTAL RESTORATION DIRECT COSTS			$
Use table below for Enhancement Direct Costs
Item & Work	Units	$/unit	Total $	Schedule (month, year)	Funding Source

CONTRACTS

Subtotal Contracts	$
MATERIALS and EQUIPMENT

Subtotal Materials and Equipment	$
NON-CONTRACT PERSONNEL and TRAVEL

Subtotal Non-Contract Personnel			$
TOTAL ENHANCEMENT DIRECT COSTS			$
Use table below for Establishment Direct Costs
Item & Work	Units	$/unit	Total $	Schedule (month, year)	Funding Source

CONTRACTS

Subtotal Contracts	$
MATERIALS and EQUIPMENT

Subtotal Materials and Equipment	$
NON-CONTRACT PERSONNEL and TRAVEL

Subtotal Non-Contract Personnel		$
TOTAL ESTABLISHMENT DIRECT COSTS		$
Use table below for Tract Indirect Costs
Allowable Category from I.C Rate Agreement	Specific Financial Plan Line Items to Which Indirect Cost is Applied	Direct Cost Base Amount	Approved Rate (%)*/ Agreement Date	Partner to which I.C. Rate Applies	I.C. Grant Amount	I.C. Match Amount	Total Indirect Cost

						$	$	$
						$	$	$
						$	$	$
Use table below for Other Activities Direct Costs
Item & Work	Units	$/unit	Total $	Schedule (month, year)	Funding Source

TOTAL OTHER ACTIVITIES DIRECT COSTS		$
Use table below for Other Activities Indirect Costs
Allowable Category from I.C Rate Agreement	Specific Financial Plan Line Items to Which Indirect Cost is Applied	Direct Cost Base Amount	Approved Rate (%)*/ Agreement Date	Partner to which I.C. Rate Applies	I.C. Grant Amount	I.C. Match Amount	Total Indirect Cost

$	$	$
$	$	$
$	$	$

TAQ 1

		Breeding		Migration		Wintering
	Species	Before	After	Before	After	Before	After
High Priority

Priority

Other

TAQ 2

A. Priority bird species:
Species/Plan	Numbers Affected	Benefits of Project	Tract Importance

B. Other wetland-associated bird species:
Species/Plan	Numbers Affected	Benefits of Project	Tract Importance

TAQ 3

A. National priority wetland areas:
National Bird Plan Priority Areas	In	Partially In	Out
NAWMP
PIF
Wading Birds
Shorebirds

TAQ 4

	ACTIVITY AND TRACTS IN THE PROPOSAL	STATUS, TYPES, AND ACRES OF WETLANDS
Note: Types subsidiary to types listed below have the same status.								UPLANDS	TOTAL
		DECREASING			STABLE			INCREASING	NO TREND DATA
		PEM	PFO	E2Veg	E1	L	R	M2, PSS, PUB, E2US	PML ,PRB, E2AB
	SECTION A
	Fee
	Easement
	Lease
	ACQUIRED TOTAL
	RESTORED
	ENHANCED
	ESTABLISHED
	TYPE TOTALS
	STATUS TOTALS
	GRAND TOTALS
	SECTION B
	Tract ID: (funding)
	Tract ID: (funding)
	Tract ID: (funding)
	Funding Categories: (G = Grant, OM = Old Match, NM = New Match, NO = Non-Match)
	Note: Do not include non-additive acres in this table

TAQ 5

ACTIVITY ACRES BY LONGEVITY OF BENEFITS

* Includes water control structures made of material other than wood.

** Includes wood water control structures and pumps.				TOTAL ACRES
		PERPETUITY	*26-99	**10-25	< 10
	SECTION A
	Fee
	Easement
	Lease
	TOTAL ACQUIRED
	RESTORED
	ENHANCED
	ESTABLISHED
	TOTAL
	SECTION B
	Tract (Funding)
	Tract (Funding)
	Tract (Funding)
	Funding Categories: (G = Grant, OM = Old Match, NM = New Match, NO = Non-Match)

Tract Table

Tract ID	Activity Type	Wetland Acres	Upland Acres	Riparian Miles	Public Access	Funding Category	Funding Source	County and State	Central Tract Location in Decimal Degrees	Final Title Holder
Tract					# Open Acres
Tract					# Open Acres
Tract					# Open Acres
Total Acres		Total # Wetland Acres	Total # Upland Acres		Total # Open Acres
Funding Categories: (G = Grant, OM = Old Match, NM = New Match, NO = Non-Match)

File details come from the government source that posted it.