52672: Expenditures by FY

This grid lists expenditures by fiscal year, and provides a breakdown of estimated expenditures by work classification, which are determined using the work element budget ratios from statements of work.

Using column filters in grids

Column filters help you find the rows you are interested in by hiding the rows that don"t match your criteria

To filter a column using text, type one or more letters into the filter field

To filter a column using a numerical expression, type numbers and =, <, >, >=, or <= symbols. To filter a column to a range of values, use n1..n2, where n1 represents the start value, n2 represents the end value, and two periods are used to capture all values in between.


Account FY	Account Type	Current Contract Value	Expenditures	Invoiced (All Time)	Habitat Expenditures	Hatchery Expenditures	RME and Data Management Expenditures	Planning and Coordination Expenditures	Other Work Classification Expenditures	BPA Internal Operations Expenditures	Environmental Compliance Expenditures	Reporting Expenditures
Select all 2011 2012	Expense


2012	Expense	$274,679	$86,085	$119,585	$0	$0	$86,085	$0	$0	$0	$0	$0
2011	Expense	$274,679	$188,594	$155,094	$0	$0	$188,594	$0	$0	$0	$0	$0


		$549,358	$274,679	$274,679	$0	$0	$274,679	$0	$0	$0	$0	$0

Estimated Expenditures by Work Statement Element - this grid lists estimated expenditures by work statement element. Estimates are determined using work statement element effective budget ratios.

Using column filters in grids

Column filters help you find the rows you are interested in by hiding the rows that don"t match your criteria

To filter a column using text, type one or more letters into the filter field


Account FY	Account Type	WSE ID	WE ID	Title	WSE Effective Budget	% of Total WSE Effective Budget	Estimated Expenditures	WSE Start	WSE End	WSE Progress	WE Class	Primary Focal Species
Select all 2011 2012	Expense									Concluded	Select all Planning and Coordination RM & E and Data Management Reporting


2012	Expense	64266	119	A: Manage and Administer Project	$0	0.00%	$0	04/15/2011	12/14/2011	Concluded	Planning and Coordination
2012	Expense	63540	185	B: Periodic Status Reports for BPA	$0	0.00%	$0	07/01/2011	12/31/2011	Concluded	Reporting
2012	Expense	64267	132	C: Submit Progress Report for the period (Apr 2011) to (Dec 2011)	$0	0.00%	$0	11/15/2011	12/31/2011	Concluded	Reporting
2012	Expense	64252	160	D: Support End-Of-Season Quality Assurance Process	$182,622	66.48%	$57,234	04/15/2011	11/15/2011	Concluded	RM & E and Data Management
2012	Expense	64265	160	E: Scripts to run River Bathymetry Tool (RBT)	$6,800	2.47%	$2,131	05/15/2011	11/30/2011	Concluded	RM & E and Data Management
2012	Expense	64269	160	F: Manage and Host the system (8.5 months)	$8,415	3.06%	$2,637	04/15/2011	10/15/2011	Concluded	RM & E and Data Management
2012	Expense	68455	160	G: Display Charts of Measurements and Metrics	$21,434	7.80%	$6,717	08/01/2011	12/31/2011	Concluded	RM & E and Data Management
2012	Expense	67740	160	H: Display Topographic and Polygon Data	$1,663	0.60%	$521	08/01/2011	12/31/2011	Concluded	RM & E and Data Management
2012	Expense	67739	160	I: Support for end-of-year reporting of metrics	$53,745	19.56%	$16,844	08/01/2011	12/31/2011	Concluded	RM & E and Data Management
2011	Expense	64266	119	A: Manage and Administer Project	$0	0.00%	$0	04/15/2011	12/14/2011	Concluded	Planning and Coordination


							$274,679

Estimated Expenditures by Focal Species - this grid lists estimated expenditures by primary focal species. Allocations to primary focal species are done according to work statement element effective budget ratios.

Using column filters in grids

Column filters help you find the rows you are interested in by hiding the rows that don"t match your criteria

To filter a column using text, type one or more letters into the filter field


Account FY	Account Type	Focal Species	Estimated Expenditures (Direct)	Estimated Expenditures (Contract Admin)
Select all 2011 2012	Expense


2011	Expense		$0	$0
2012	Expense		$0	$0


			$0	$0

Estimated Expenditures by ESA-Listed Focal Species - this grid lists estimated expenditures by primary focal species for ESA-Listed focal species only. If this contract does not have any work statement elements where the primary focal species is an ESA-listed species, then this grid will be empty.

Using column filters in grids

Column filters help you find the rows you are interested in by hiding the rows that don"t match your criteria

To filter a column using text, type one or more letters into the filter field


Account FY	Account Type	Focal Species	Estimated Expenditures (Direct)	Estimated Expenditures (Contract Admin)
Select all 2011 2012	Expense


2011	Expense		$0	$0
2012	Expense		$0	$0


			$0	$0

Estimated Expenditures by Work Statement Element by Focal Species - this grid lists estimated expenditures by work statement element and by primary focal species. Allocations to primary focal species are done according to work statement element effective budget ratios.

Using column filters in grids

Column filters help you find the rows you are interested in by hiding the rows that don"t match your criteria

To filter a column using text, type one or more letters into the filter field


Account FY	Account Type	WSE ID	Title	Focal Species	Estimated Expenditures (Direct)	Estimated Expenditures (Contract Admin)
Select all 2011 2012	Expense


2011	Expense	64252	D: Support End-Of-Season Quality Assurance Process	$0	$0
2011	Expense	64267	C: Submit Progress Report for the period (Apr 2011) to (Dec 2011)	$0	$0
2012	Expense	64267	C: Submit Progress Report for the period (Apr 2011) to (Dec 2011)	$0	$0
2012	Expense	64252	D: Support End-Of-Season Quality Assurance Process	$0	$0
2011	Expense	64266	A: Manage and Administer Project	$0	$0
2012	Expense	64266	A: Manage and Administer Project	$0	$0
2011	Expense	67739	I: Support for end-of-year reporting of metrics	$0	$0
2012	Expense	67739	I: Support for end-of-year reporting of metrics	$0	$0
2011	Expense	63540	B: Periodic Status Reports for BPA	$0	$0
2012	Expense	63540	B: Periodic Status Reports for BPA	$0	$0


					$0	$0

Estimated Expenditures by Work Statement Element by ESA-Listed Focal Species - this grid lists estimated expenditures by work statement element and by primary focal species for ESA-Listed focal species only. If this contract does not have any work statement elements where the primary focal species is an ESA-listed species, then this grid will be empty.

Using column filters in grids

Column filters help you find the rows you are interested in by hiding the rows that don"t match your criteria

To filter a column using text, type one or more letters into the filter field


Account FY	Account Type	WSE ID	Title	Focal Species	Estimated Expenditures (Direct)	Estimated Expenditures (Contract Admin)
Select all 2011 2012	Expense


2011	Expense	67740	H: Display Topographic and Polygon Data	$0	$0
2012	Expense	67740	H: Display Topographic and Polygon Data	$0	$0
2011	Expense	64265	E: Scripts to run River Bathymetry Tool (RBT)	$0	$0
2012	Expense	64265	E: Scripts to run River Bathymetry Tool (RBT)	$0	$0
2011	Expense	64267	C: Submit Progress Report for the period (Apr 2011) to (Dec 2011)	$0	$0
2011	Expense	64252	D: Support End-Of-Season Quality Assurance Process	$0	$0
2012	Expense	64267	C: Submit Progress Report for the period (Apr 2011) to (Dec 2011)	$0	$0
2012	Expense	64252	D: Support End-Of-Season Quality Assurance Process	$0	$0
2011	Expense	67739	I: Support for end-of-year reporting of metrics	$0	$0
2012	Expense	67739	I: Support for end-of-year reporting of metrics	$0	$0


					$0	$0

Estimated Expenditures by Work Statement Element by Location - this grid lists estimated expenditures by work statement element and, using the primary work site location, allocates these estimated expenditures to individual Counties, States, Subbasins and Provinces.

Using column filters in grids

Column filters help you find the rows you are interested in by hiding the rows that don"t match your criteria

To filter a column using text, type one or more letters into the filter field

Please correct the errors noted below.