38665: 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 2008 2009	Expense


2009	Expense	$87,965	$68,702	$75,225	$0	$0	$3,020	$64,172	$0	$0	$0	$1,510
2008	Expense	$87,965	$19,263	$12,740	$0	$0	$847	$17,993	$0	$0	$0	$423


		$175,930	$87,965	$87,965	$0	$0	$3,867	$82,165	$0	$0	$0	$1,933

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 2008 2009	Expense									Concluded	Select all Planning and Coordination RM & E and Data Management Reporting


2009	Expense	33062	119	A: General Administration of Project	$7,000	7.69%	$5,285	07/01/2008	06/30/2009	Concluded	Planning and Coordination
2009	Expense	33065	189	B: Coordinate restoration partners	$55,000	60.43%	$41,523	07/01/2008	06/30/2009	Concluded	Planning and Coordination
2009	Expense	33064	122	C: Provide Technical Review and Comment on Plans as Requested	$23,000	25.27%	$17,364	07/01/2008	06/30/2009	Concluded	Planning and Coordination	Steelhead - Snake River DPS (Threatened)
2009	Expense	33066	160	D: Oversee Clearwater Subbasin Inventory database	$4,000	4.39%	$3,020	07/01/2008	06/30/2009	Concluded	RM & E and Data Management
2009	Expense	33061	185	E: Periodic Status Reports for BPA	$0	0.00%	$0	10/01/2008	06/30/2009	Concluded	Reporting
2009	Expense	33070	132	F: Submit Annual Report	$2,000	2.19%	$1,510	07/01/2008	07/14/2008	Concluded	Reporting
2008	Expense	33062	119	A: General Administration of Project	$7,000	7.69%	$1,482	07/01/2008	06/30/2009	Concluded	Planning and Coordination
2008	Expense	33065	189	B: Coordinate restoration partners	$55,000	60.43%	$11,643	07/01/2008	06/30/2009	Concluded	Planning and Coordination
2008	Expense	33064	122	C: Provide Technical Review and Comment on Plans as Requested	$23,000	25.27%	$4,869	07/01/2008	06/30/2009	Concluded	Planning and Coordination	Steelhead - Snake River DPS (Threatened)
2008	Expense	33066	160	D: Oversee Clearwater Subbasin Inventory database	$4,000	4.39%	$847	07/01/2008	06/30/2009	Concluded	RM & E and Data Management


							$87,965

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 2008 2009	Expense


2008	Expense	Steelhead - Snake River DPS (Threatened)	$4,869	$14,395
2009	Expense	Steelhead - Snake River DPS (Threatened)	$17,364	$51,337


			$22,233	$65,732

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)

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 2008 2009	Expense


2008	Expense	33061	E: Periodic Status Reports for BPA	Steelhead (O. mykiss) - Snake River DPS (Threatened)	$0	$0
2008	Expense	33062	A: General Administration of Project	Steelhead (O. mykiss) - Snake River DPS (Threatened)	$0	$1,482
2008	Expense	33064	C: Provide Technical Review and Comment on Plans as Requested	Steelhead (O. mykiss) - Snake River DPS (Threatened)	$4,869	$0
2008	Expense	33065	B: Coordinate restoration partners	Steelhead (O. mykiss) - Snake River DPS (Threatened)	$0	$11,643
2008	Expense	33066	D: Oversee Clearwater Subbasin Inventory database	Steelhead (O. mykiss) - Snake River DPS (Threatened)	$0	$847
2008	Expense	33070	F: Submit Annual Report	Steelhead (O. mykiss) - Snake River DPS (Threatened)	$0	$423
2009	Expense	33061	E: Periodic Status Reports for BPA	Steelhead (O. mykiss) - Snake River DPS (Threatened)	$0	$0
2009	Expense	33062	A: General Administration of Project	Steelhead (O. mykiss) - Snake River DPS (Threatened)	$0	$5,285
2009	Expense	33064	C: Provide Technical Review and Comment on Plans as Requested	Steelhead (O. mykiss) - Snake River DPS (Threatened)	$17,364	$0
2009	Expense	33065	B: Coordinate restoration partners	Steelhead (O. mykiss) - Snake River DPS (Threatened)	$0	$41,523


					$22,233	$65,732

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)

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.