Revenue Analytics: Key Concepts

The Revenue Analytics provide a means to quickly view and assess large amounts of project revenue data. You can view revenue and analyze trends in the budget and variance. You can also compare revenue results to plans, and analyze different subsets of data (such as divisions or customers) over specific periods of time.  All of this information is important for accurate decision making and forecasting.  

Case Studies...

In this topic

Analysis Periods

Organization Access

Actual and Target Revenue

Proposals

Top-Level and Revenue-Level Projects

Alerts

Amounts and Calculations

Post Revenue

Report Revenue and Cross Charging

Adjustments to Revenue for Prior Years

Select a Chart

User Options and Revenue

 

Analysis Periods

Your system administrator specifies both the current fiscal period and the number of prior fiscal periods for which data is available. The future fiscal periods for which data is available are the periods for which budget data has been loaded into Costpoint Analytics.

For more information on specifying the analysis period, see Specify an Analysis Period.

Organization Access

During the security configuration process for Costpoint Analytics, your system administrator sets up the organization access for your Costpoint Analytics user role. This determines the organizations and reorganizations for which you can view analytic information. The Orgs list only includes organizations to which you have access.

You can change the organization type on the User Options tab. If you select the Reorg option, you can filter the analytics by reorganization:

For more information on filtering the analytics by organization or reorganization, see Filter by Organization. For more information on selecting the option to filter by reorganization on the User Options tab, see Organization or Reorganization.

Actual and Target Revenue

A Costpoint Analytics configuration option controls whether revenue is actual or target.

Proposals

You can use the Proposals option under the Additional Filters to further filter the data in the analytic. The proposal number and name are loaded as part of the budget or forecast process.

Use the Proposals attribute to select from the following for inclusion in the filter process:

Top-Level and Revenue-Level Projects

You can filter and analyze information by either top-level project or revenue-level project. If you select a top-level project, all revenue-level projects under it are included in the analytics data.

If you select one or more projects and then go to another Costpoint Analytics tab for which the project filter option is available, Costpoint Analytics automatically filters those analytics for the same projects.

For general information about making selections in filter lists, see Filter the Analytics: Overview.

For more information on filtering the analytics by project, see Filter by Project.

Alerts

Your system administrator determines the guidelines that control how, and when, you are alerted of variances. These alerts are either cautionary or urgent, depending on your configuration settings. A negative variance engages the alerts.

Refer to the following scale to determine the type of alerts that display:

You can click the Variance column heading to sort a table by alert status. Urgent alerts will display first, and then cautionary alerts, and then projects with an acceptable status.

Amounts and Calculations

Post Revenue

Revenue is typically posted by owning organization. This option is selected in the User Options. For more information on this user option, see Organization View.

Report Revenue and Cross Charging

A cross charge is a sharing of labor resources between different organizations within your firm. The cross charging process redistributes labor costs and associated revenue when an employee in one organization works on a project for another organization. The transfer of costs and revenue between organizations allows each organization to match costs with revenue.

There are two ways to report revenue:

Adjustments to Revenue for Prior Years

If your firm uses the Interim/Final Rates feature in Costpoint and includes prior year revenue adjustments in the Project Status Report (PSR) reporting tables, revenue amounts may include those prior year adjustments. A Costpoint Analytics configuration option controls whether the adjustments are included and, if they are, which fiscal periods are affected. For more information, see Adjustment Period.

The Actual or Target Revenue vs. Baseline or Forecast chart is the only chart or table that breaks out the prior year revenue adjustment amounts. In all other cases, if prior year revenue adjustments are included, revenue amounts are the net of normal revenue and applicable prior year adjustments.

Select a Chart

There are two ways to view revenue: Period and Year-To-Date (YTD). The type of chart impacts the data that displays on the charts.

Period is data for the current analysis period, while YTD provides a cumulative, rolling perspective within a given year. For example, February = January + February, March =  January + February + March, and so on.

Profit defaults to YTD when used initially, but you can switch the chart type at any time.  

To switch the type of chart...

  1. Locate the chart type options.  

  2. Click Period or YTD. The selected option's button turns green, and the pertinent information on the charts and tables updates to reflect your selection.

User Options and Revenue

Your selections on the User Options tab affect the Revenue Analytics in the following ways:

User Option

Effect on the Analytics

Budget Type

If you select Baseline Budget, the baseline budget data is used to calculate revenue that involve comparison to budget. If you select Forecast, the forecast data is used.

The revenue descriptions change to reflect the type of budget data (for example, Costs over Budget or Costs over Forecast).

For more information on this user option, see Budget Type.

Org or Reorg

If you select Org, you can filter and analyze risk data by organization. If you select Reorg, you can do so based on the selected reorganization.

The name and contents of the filter list and cycle options change to reflect your current selection.

For more information on this user option, see Organization or Reorganization.

Org View

Costpoint Analytics offers two organizational types, Owning and Performing, for computing and posting revenue.

Even though revenue is typically posted at the owning organization level, you can also post it at the performing organization level.

For more information on this user option, see Organization View.