Show new navigation
On
Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program

Budgets & Expenditures

Types of Work Funded
Types of Work Funded

Description: Rolls up program funding across time by work class such as Habitat, Hatchery, Research Monitoring and Evaluation, Local & Regional Coordination, etc. Includes summary and detail pie charts showing funding levels for various types of work. Provides drill-downs to work element detail.

Dimensions: Work Class, Work Element, Work Element Budget, Account Type (Expense or Capital), NPCC Province, NPCC Subbasin


Spending by State and County
Spending by State and County

Description: Compiles Program spending by Account Type, Fiscal Year, and by State/County. Uses Work Element budget ratios to proportionally distribute expenditures (invoices) to work elements, and then uses Work Element location and GIS to determine State and County. Provides drill-downs to work element level detail.

Dimensions: Expenditures (Spending), Account Type (Expense or Capital), Fiscal Year, State, County, Project, Contract, Work Element, Work Element Budget


Spending by Project Emphasis and State/County
Spending by Project Emphasis and State/County

Description: Compiles Program spending by Account Type, Fiscal Year, Project Emphasis, and by State/County. Uses Work Element budget ratios to proportionally distribute expenditures (invoices) to work elements, and then uses Work Element location and GIS to determine State and County. Provides drill-downs to work element level detail.

Dimensions: Expenditures (Spending), Account Type (Expense or Capital), Fiscal Year, Project Emphasis, State, County, Project, Contract, Work Element, Work Element Budget


Spending by Province and Subbasin
Spending by Province and Subbasin

Description: Compiles Program spending by Account Type, Fiscal Year, and NPCC Province/Subbasin. Uses Work Element budget ratios to proportionally distribute expenditures (invoices) to work elements, and then uses Work Element location and GIS to determine Province and Subbasin. Provides drill-downs to work element level detail.

Dimensions: Expenditures (Spending), Account Type (Expense or Capital), Fiscal Year, NPCC Province, NPCC Subbasin, Project, Contract, Work Element, Work Element Budget


Spending By Focal Species
Spending By Focal Species

Description: Shows the estimated spending by Focal Species – various anadromous and resident fish and general wildlife category – by fiscal year. Since contractors don’t invoice BPA by work element, much less by focal species, this report allocates project costs by the proportion of the work element budgets and the focal species associated with each work element. This report has two tables: Spending by all Focal Species, and Spending by ESA-Listed Focal Species (a table that allows BPA to meet federal reporting requirements).

Dimensions: Focal Species, ESA-Listed Fish Species, Direct Spending, Contract Administration Spending, Program Administrative Spending, Account Type (Expense, Capital), Work Element Budgets


Program Spending Plan
Program Spending Plan

Description: This report estimates the Program’s spending for the current fiscal year. It aggregates work element budgets for the most recently issued contract and BPA Internal Work statements, as well as for any early stage contracts (called contract requisitions). This report uses those budgets and the duration of work elements to create a shaped budget. The report does NOT factor in any real expenditure data (invoices). It provides a summary for the program, a pie chart showing the spending by work class, and then a table showing spending plans for each project.

Dimensions: Account Type (Expense, Capital), Work Class, Project Number, Project Title, BPA Project Manager, Monthly Spending Estimate, Fiscal Year Total


Fish Accord Original Budgets
Fish Accord Original Budgets

Description: Provides a snaphot of ten year project budgets (FY08-FY18) as of the signing of the Fish Accord agreements between BPA and various entities. Also shows the Cost of Living Adjustment (COLA) applied to the entity subtotal budget by fiscal year starting in FY10.

Dimensions: Fish Accord Entity, Project, Fiscal Year, Budget, COLA


Fish Accord Budget Decision History Detail
Fish Accord Budget Decision History Detail

Description: Provides budget transfer detail for the Capital and Expense accounts for FY2008-2018 for all projects that received any funding from the selected Fish Accord Fund.

Dimensions: Project, Review, Fund, Fiscal Year, Budget


Budget History and Forecast
Budget History and Forecast

Description: View historical and forecast project budgets for a maximum of ten contiguous fiscal years.

Dimensions: Project, Account Type (Expense, Capital), Budget, Fiscal Year


Internal SOW Summary Report
Internal SOW Summary Report

Description: For Internal Statements of Work, compares Work Element budgets (Planned and Updated) to the sum entered in the budget tool.

Dimensions: Project, Account, Fiscal Year, Work Element Type


Project Budget by Fiscal Year
Project Budget by Fiscal Year

Description: Lists this project’s budgets and contracted amounts by fiscal year (FY2008 forward). Also provides a historical log of every budget transfer.

Dimensions: Project, Fiscal Year Working Budgets, Account Type, Contract, Contracted Amount, Review, Decision Date


Accrual Accuracy Dashboard

Description: Lists actual accruals compared with what accruals should have been based on backdated invoice amounts

Dimensions: Expenditure, Project, Contract, Date