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. |
In this topicTop-Level and Revenue-Level Projects Report Revenue and Cross Charging |
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.
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:
The Reorgs list only includes reorganizations to which you have access.
You do not have access to a reorganization if you do not have access to any of the organizations mapped to that reorganization.
You have access to a reorganization if you have access to at least one organization mapped to that 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.
A Costpoint Analytics configuration option controls whether revenue is actual or target.
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:
Projects Only — Select this option to only include projects in the filter process.
Proposals Only — Select this option to only include proposals in the filter process.
All — This is the default. Select this option to include both projects and proposals in the filter process.
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.
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:
Cautionary alert — The Variance % cell displays in yellow to indicate that performance is below the expected level but is not yet a critical problem.
Urgent alert — The Variance % cell displays in red to indicate that performance is far enough below budget that it requires urgent attention.
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 — All revenue amounts are inception to date for the period, quarter, or year.
Calculations — All calculations are at the project's revenue level, computed as actual or target, and only used for projects that are classified as Direct, Inter-Company, or Inter-Co Multi. Your system administrator determines this classification on the Project Classification field in either the Maintain Project Master (client server) or Manage Project User Flow (web) configuration screen.
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.
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:
By Owning Corporate Structure — Revenue is posted by the owning corporate structure of the project. This means that the entire project’s revenue and costs for each division are reported "up" to the owning organization. If using cross charging, the posting of revenue is not impacted because the entire project’s revenue and cost are reported to the division where each organization is assigned.
By Performing Corporate Structure — Revenue is posted by performing organization and does not roll up under the owning organization. When using cross charging, the display of revenue data is impacted because the entire project's revenue and costs are reported for each division.
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.
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...
Locate the chart type options.
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.
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. |