Crystal Reports Stock Report Descriptions › Budget Forecast Analysis Report

Budget Forecast Analysis Report

Description

This report provides an analysis of budget, actual, and forecast costs by investment manager. Amounts display in the currency that is set in the report parameter. For projects with a detailed budget, the forecast feature is used to determine Estimate at Complete (EAC) based on the following: (Actuals Posted + Remaining Forecast). Otherwise, a prorated simple budget is used to determine the remaining forecast.

This report can be run only from CA Clarity PPM and not from BusinessObjects InfoView.

The graph shows the percentage of budget at completion by investment manager.

Run the report to work with the following:

• Project management.

  See the Project Management User Guide for more information.

• Financial management.

  See the Financial Management User Guide for more information.

• Service management.

  See the IT Service Management User Guide for more information.

• Demand management.

  See the Demand Management User Guide for more information.

• Portfolio management.

  See the Portfolio Management User Guide for more information.

Prerequisites

• The project requires enabling financially to generate the report.

  See the Project Management User Guide for more information.

• A simple budget, a forecast, or a detailed budget required for data to display on the report.
• For actual costs to display, enter and post transactions through financial processing.
• For Estimate at Complete (EAC) data to display, projects must be scheduled. In addition, cost rates must be set up in a cost/rate matrix with the matrix assigned to the projects.
• To use the OBS Unit parameter to filter the report, require at least one OBS in the system. In addition, require an OBS unit assigned to the programs or projects.
• Exchange Rate (Type=Average) must exist to do the calculation from investment to reporting currency.

Parameters

Investment Approval

Indicates the status of the investments in the report. Select the appropriate status from the drop-down.

Investment Manager

Identifies the investment manager whose data displays in the report. Click the Browse icon to select the investment manager name.

OBS Unit

Indicates the OBS unit by which the report is filtered.

Reporting Currency

Defines the currency type that appears on the report for amounts and totals.

Start Date

Defines the start date of the report. To select a specific day, select the Specific Date option and type a date in the text field in the mm/dd/yyyy format. Or, click the Date Picker to select a day from the calendar that displays. To select a relative date such as Start of Next Month, select the Relative Date option. Then, select the relative date from the drop-down list.

Report Fields

% Spent

Displays the percentage of the actual budget spent to date.

Calculation: (Actual to Date /Budget Total) x 100

Database Tables and Columns:

A calculated field. For more information, see the report SQL statement.

% Total Budget

Displays the amount spent as opposed to the amount budgeted.

Calculation: (EAC / Budget Total) x 100

Database Tables and Columns:

A calculated field. For more information, see the report SQL statement.

Actual to Date

Displays the actual amount of the budget spent to date. The data is taken from the aggregated actuals posted in WIP.

Database Tables and Columns:

ppa_wip_values.total_cost

Budget Total

Displays the total amount of the budget for the investment.

Database Tables and Columns:

If the investment has a detail budget, this value is taken from fin_financials.budget_cst_total, else it is taken from fin_financials.planned_cst_total.

EAC

Displays the estimated actuals at completion.

Calculation: Actual to Date + Month (1 through 3) + Remainder

Database Tables and Columns:

A calculated field. For more information, see the report SQL statement.

Forecast (Months 1-3)

Displays the budget forecast for selected months (1-3). The Forecast fields require a detail or a simple budget for the investment for data to appear in these fields.

If a detail budget exists, the forecast plan of record is used for the parameter Start Date and the totals posted in the fields.

If only a simple budget exists, the single budget amount is evenly distributed over the duration of the project. For example: If the simple budget=12,000 and the project duration is six months, the monthly budget/forecast is 2,000.

Database Tables and Columns:

If the investment has a detailed budget, this value is taken from the slice table odf_ssl_cst_dtl_cost.slice.

If the investment has simple budget and has forecast cost, the report does its slicing during the runtime based on the forecast cost. If the forecast cost is not present, the same calculation is done based on the planned cost.

Manager

Displays the name of the manager whose projects are being reported.

Database Tables and Columns:

nbi_project_current_facts.manager_last_name

nbi_project_current_facts.manager_first_name

Plan/Budget Variance

Displays the difference between the actuals budgeted and the actuals posted at completion.

Calculation: Budget Total - EAC

Database Tables and Columns:

A calculated field. For more information, see the report SQL statement.

Project

Displays the project being reported on.

Database Tables and Columns:

nbi_project_current_facts. project_name

Remainder

Displays the remaining months where actuals are not posted.

Database Tables and Columns:

The same as Forecast (Months 1-3), but it includes the slice values remaining after month 3.