Revenue Analysis (BPA17)

Use this screen to display a summary of costs for the active level project or account. The report displays project ID, bill rate, hours, base cost, burdened cost, revenue, profit amount, profit percentage, and ceiling amount.

Budget Type

If you selected the Budget or Variance report type, select one of the following from the drop-down list:

EAC displays in the drop-down list only if an EAC exists for the project.

Project ID

Enter, or click, to select the project ID.

You must provide information for all enabled fields in order for the report to run as expected, else an error message displays.

Subtasks

After you select the Project ID and set other report options, click to populate the Major Group and Minor Group table.

Field descriptions for each level of detail are provided in the tables below.

Column Headings

Description

Project ID

This column displays the Project ID.

Major Group/Minor Group

This column displays the Major or Minor group description/name.

Bill Rate

This column reflects the billing rate of the PLC (the most recent PLC rate of time-phased PLCs).

If you budget by period, but the PLC rates are set up by subperiod and the rate changes during the period, Planning uses the latest PLC rate when calculating revenue for the entire period.  

Hours

This column displays the hours.

Cost

This column displays burdened cost for period selected by PLC and resource.

Burdened Cost

This column displays the overhead expenses for the project selected in the Navigation pane.

Revenue

The column displays revenue amounts to the corresponding PLC or account.

Profit

This column totals the profit for the period selected.

Profit %

This is calculated by taking the ITD Billed minus the ITD Cost = ITD Profit divided by billing x 100 = profit %.

Ceiling

This column displays totals for each column.

Under/(Over) Ceiling

The column displays total under ceiling or over ceiling data for the corresponding PLCs.