26934 REL 3: 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 2007 2008	Expense


2008	Expense	$85,838	$12,392	$12,392	$0	$0	$0	$9,313	$0	$0	$0	$3,078
2007	Expense	$85,838	$73,447	$73,447	$0	$0	$0	$55,201	$0	$0	$0	$18,246


		$171,676	$85,838	$85,838	$0	$0	$0	$64,514	$0	$0	$0	$21,324

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 2007 2008	Expense									Concluded	Select all Planning and Coordination Reporting


2008	Expense	15221	189	A: [no title]	$30,994	35.00%	$4,337	10/02/2006	09/27/2007	Concluded	Planning and Coordination
2008	Expense	15222	119	B: [no title]	$9,179	10.36%	$1,284	06/01/2007	07/31/2007	Concluded	Planning and Coordination
2008	Expense	15223	132	C: [no title]	$17,166	19.38%	$2,402	07/02/2007	09/27/2007	Concluded	Reporting
2008	Expense	15225	174	D: [no title]	$26,381	29.79%	$3,692	10/02/2006	09/27/2007	Concluded	Planning and Coordination	Chinook - Deschutes River Summer/Fall ESU; Chinook - Lower Columbia River ESU (Threatened); Chinook - Mid-Columbia River Spring ESU; Chinook - Snake River Fall ESU (Threatened); Chinook - Snake River Spring/Summer; Chinook - Snake River Spring/Summer ESU (Threatened); Chinook - Upper Columbia River Spring ESU (Endangered); Chinook - Upper Columbia River Summer/Fall ESU; Chinook - Upper Willamette River ESU (Threatened)
2008	Expense	15627	185	E: Periodic Status Reports for BPA	$4,832	5.45%	$676	01/01/2007	09/30/2007	Concluded	Reporting
2007	Expense	15221	189	A: [no title]	$30,994	35.00%	$25,707	10/02/2006	09/27/2007	Concluded	Planning and Coordination
2007	Expense	15222	119	B: [no title]	$9,179	10.36%	$7,613	06/01/2007	07/31/2007	Concluded	Planning and Coordination
2007	Expense	15223	132	C: [no title]	$17,166	19.38%	$14,238	07/02/2007	09/27/2007	Concluded	Reporting
2007	Expense	15225	174	D: [no title]	$26,381	29.79%	$21,881	10/02/2006	09/27/2007	Concluded	Planning and Coordination	Chinook - Deschutes River Summer/Fall ESU; Chinook - Lower Columbia River ESU (Threatened); Chinook - Mid-Columbia River Spring ESU; Chinook - Snake River Fall ESU (Threatened); Chinook - Snake River Spring/Summer; Chinook - Snake River Spring/Summer ESU (Threatened); Chinook - Upper Columbia River Spring ESU (Endangered); Chinook - Upper Columbia River Summer/Fall ESU; Chinook - Upper Willamette River ESU (Threatened)
2007	Expense	15627	185	E: Periodic Status Reports for BPA	$4,832	5.45%	$4,008	01/01/2007	09/30/2007	Concluded	Reporting


							$85,838

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


2007	Expense	Chinook - Deschutes River Summer/Fall ESU	$2,431	$5,730
2007	Expense	Chinook - Lower Columbia River ESU (Threatened)	$2,431	$5,730
2007	Expense	Chinook - Mid-Columbia River Spring ESU	$2,431	$5,730
2007	Expense	Chinook - Snake River Fall ESU (Threatened)	$2,431	$5,730
2007	Expense	Chinook - Snake River Spring/Summer ESU (Threatened)	$2,431	$5,730
2007	Expense	Chinook - Upper Columbia River Spring ESU (Endangered)	$2,431	$5,730
2007	Expense	Chinook - Upper Columbia River Summer/Fall ESU	$2,431	$5,730
2007	Expense	Chinook - Upper Willamette River ESU (Threatened)	$2,431	$5,730
2007	Expense	Chinook - Snake River Spring/Summer	$2,431	$5,730
2008	Expense	Chinook - Deschutes River Summer/Fall ESU	$410	$967


			$25,573	$60,266

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


2007	Expense	15221	A: [no title]	Chinook (O. tshawytscha) - Deschutes River Summer/Fall ESU	$0	$2,856
2007	Expense	15221	A: [no title]	Chinook (O. tshawytscha) - Lower Columbia River ESU (Threatened)	$0	$2,856
2007	Expense	15221	A: [no title]	Chinook (O. tshawytscha) - Mid-Columbia River Spring ESU	$0	$2,856
2007	Expense	15221	A: [no title]	Chinook (O. tshawytscha) - Snake River Fall ESU (Threatened)	$0	$2,856
2007	Expense	15221	A: [no title]	Chinook (O. tshawytscha) - Snake River Spring/Summer ESU (Threatened)	$0	$2,856
2007	Expense	15221	A: [no title]	Chinook (O. tshawytscha) - Upper Columbia River Spring ESU (Endangered)	$0	$2,856
2007	Expense	15221	A: [no title]	Chinook (O. tshawytscha) - Upper Columbia River Summer/Fall ESU	$0	$2,856
2007	Expense	15221	A: [no title]	Chinook (O. tshawytscha) - Upper Willamette River ESU (Threatened)	$0	$2,856
2007	Expense	15221	A: [no title]	Chinook (O. tshawytscha) - Snake River Spring/Summer (not listed)	$0	$2,856
2007	Expense	15222	B: [no title]	Chinook (O. tshawytscha) - Deschutes River Summer/Fall ESU	$0	$846


					$25,573	$60,266

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.