Analyzing Program Budgets

Page Name

Definition Name

Usage

Program Budget Analysis Page

PGM_BUD_ANALYSIS

Analyze program cost budget versus actual amounts, estimate to complete, and the baseline budget.

Project Request Analysis Page

PGM_PRJRQ_ANALYSIS

Compare the project request estimate to the associated program or project budget.

Use program budget analytics to compare the program budget with program actual, program estimate to complete, and program baseline budget amounts.

Note: Program budgeting analytics report against only cost budgets.

Program budget analysis inquiry is built using PeopleSoft Analytic Calculation Engine (ACE). PeopleSoft ACE is a tool for developing and administering analytic models, which calculate and send data to PeopleSoft applications for the purposes of multidimensional reporting, analysis, and data entry.

See "Configuring and Starting Analytic Servers" in PeopleTools: System and Server Administration.

Use the Program Budget Analysis page (PGM_BUD_ANALYSIS) to analyze program cost budget versus actual amounts, estimate to complete, and the baseline budget.

Navigation:

  • Program Management > Program Budgeting > Program Budget Analysis > Program Budget Analysis

  • Program Management > Program Tools > Review Program > Review Program. Click the Program Budget Analysis link.

This example illustrates the fields and controls on the Program Budget Analysis page. You can find definitions for the fields and controls later on this page.

 Program Budget Analysis page

Selection Criteria

Select values for the fields on the slicer bar to filter the information that appears on the analysis page.

Field or Control

Description

Department

Select a value to limit the report to a specific department.

Project Budget Item

Select a value to limit the report to a specific budget item.

Account

Select a value to limit the report to a specific account.

Data Grid

The analysis grid displays data for the program and each child program or project that is associated with the program. The budget periods are based on the program budget calendar.

Field or Control

Description

Total Budget Amount

Displays the budget amounts for the active program budget. If the selected program does not have an active budget, the child projects and programs under the selected program appear individually. The total budget values for the child projects and programs are also rolled up to display a program total.

Total Actuals Amount

Displays the actuals amounts from the projects that comprise the program. The individual project amounts are rolled up to display a program total amount. The accounting date on the project transactions is used to determine the budget period in which the amount is displayed. The Actual Cost analysis group defined at the project level is used to determine the transactions used to derive this total.

ETC Amount (estimate to complete amount)

Displays the estimate to complete amounts for the projects that comprise the program. The individual project amounts are rolled up to display a program total amount. The accounting date on the estimate to complete transactions is used to determine the budget period in which the amount is displayed. The system uses the Cost Estimate to Complete analysis group defined on the Installation Options - Project Costing Integration page to determine the transactions to use to derive this total.

Baseline Amount

Displays the baseline budget for the program if one is defined.

Use the Project Request Analysis page (PGM_PRJRQ_ANALYSIS) to compare the project request estimate to the associated program or project budget.

Navigation:

Program Management > Program Budgeting > Project Request Analysis > Project Request Analysis

This example illustrates the fields and controls on the Project Request Analysis page. You can find definitions for the fields and controls later on this page.

 Project Request Analysis page

Field or Control

Description

Project Request ID

Displays the project request ID of the project whose business case estimate is compared to the program or project budget.

Request Status

Displays the current status of the project request.

Version Of

Displays the version of the project request.

Related Project ID

Displays the project identifier for the corresponding project request.

Program

Indicates whether the project is a program. If the box is selected, the project is a program.

View Currency

Enter the currency in which to view the budget variance, cost budget, and cost actuals. You must click the Convert Currency button to change the amounts. The default value is the project business unit currency.

Convert Currency

Click to restate all of the budget amounts in the currency that you specified in the View Currency field.

Budget Variance

Field or Control

Description

Project Request Estimate

Displays the total estimated cost from the Project Request page

Total Budget

Displays the total active program or project budget. If a program has an active budget and the child projects under it have active budgets, then the program budget is the total budget. If the program does not have an active budget, and the child projects under it have active budgets, then the total budget is the roll up of the active child project budgets under the program.

Variance

Displays the difference between the project request estimate and total budget.

Program Budgets

Field or Control

Description

Project Name

Displays the child program or project descriptions.

Cost Budget

Displays the active program or project budget.

Cost Actuals

Displays the actual costs for the projects under the program.

Amount Variance

Displays the difference between the cost budget and cost actuals amounts.