Price and Usage Analysis Report Overview

Use the Price/Usage Analysis to view the current period and cumulative to date variance at the Control Account, Work Package and / or Resource level. Variance amounts are expressed in hours, direct and total dollars, as well as percentages of same. For details about the formulas, see Calculated Field Formulas and Descriptions.

Location of Elements of Cost

This report uses the Element of Cost as a subtotal when resources are selected. The Location of Elements of Cost setting for the project is located in the Projects Form View on the General tab. Use this setting to specify whether the Element of Cost is defined at a level of the resource file or a code on the resource.

Tip: Using a code on the resource will improve the performance for generating this report.

Element of Cost Sorting/Grouping Field

The Element of Cost option on the Sorting/Grouping tab is not selected by default. If selected, and the EOC is a code on the resource, then only the code will display on the report. If the EOC is a level of the Resource code file, then the description will display in the report.

Filtering the Data

You can specify either specific records or criteria when you define the filter that the system uses when creating the report. Click in the Selection column to display the Control Account Search Dialog Box.

For more information, see Modify Standard Reports and Specifying Criteria vs. Specific Records (Values).

Master Projects

For reports that support master projects, if you select a master project in Project Search (<Report> Search dialog box), when the report runs, data for all subprojects related to the selected master project displays on the report.

The cost sets that are used (displayed on the Table Columns tab of the Options dialog box) are from the master project. You don't need to define the cost sets in each subproject. When you run the report, only the classes in the master project for the cost sets you have selected will be retrieved from each subproject. For example, if you select a cost set on the Table Columns tab that includes a budget class, when you run the report, it only retrieves the budget class data from each subproject.

Reports using master projects use the master calendar.

To display the data by project, group by Project on the Sorting/Grouping tab.

Report Options

You can use the Options dialog box to customize the report. Click in the Options column to display the Price and Usage Analysis Options dialog box which includes the following tabs:

All tabs on the Report Options dialog box share some common options and buttons.

Generate the Report

You can generate this report from the following areas:

What do you want to do?

Review the report procedures (use, modify, edit, format, sort, and archive reports)


View location

Learn more about...