The data displayed in Revenue Analytics are calculated using a combination of revenue and cost data from Costpoint and revenue and cost budget data from an external budget file.
Costpoint Analytics configuration settings also affect the revenue calculations.
|
Data Item |
Source |
|
Actual Revenue |
The Actual Revenue is the total transaction amount of actual recognized revenue that is posted to the summary data table Projects, using the actual rates. If prior year revenue adjustments are included in the PSR tables, actual revenue amounts may include those revenue adjustments, depending on how Costpoint Analytics is configured. For more information, see Adjustment Period. |
|
Target Revenue |
The Target Revenue is the total transaction amount of actual recognized revenue that is posted to the PSR table Projects, using the target rates. If prior year revenue adjustments are included in the PSR tables, target revenue amounts may include those revenue adjustments, depending on how Costpoint Analytics is configured. For more information, see Adjustment Period. |
|
Prior Year Adjustment Revenue |
If prior year revenue adjustments are included in the PSR tables, adjustment revenue amounts may be available in the data model, depending on how Costpoint Analytics is configured. For more information, see Adjustment Period. |
|
Revenue Budget |
The Revenue Budget is the original expected revenue for a project that is typically entered by accounting period. |
|
Revenue Forecast |
The Revenue Forecast is the most recent updated version of the expected revenue for a project that is typically entered by accounting period. |
|
Revenue Tolerance |
The Revenue Tolerance is the percent of revenue, below the Revenue Budget or Forecast, that your organization considers cautionary or urgent. Cautionary alerts display in the Revenue analytic as yellow. Urgent alerts display in the Revenue analytic as red. |
|
Percentage contribution to revenue for an organization, project type, project manager, or customer |
Revenue for the organization, project type, project manager, or customer for the period, quarter, or year ÷ Total revenue for the period, quarter, or year. |
|
Views of Revenue Determined in User Options |
The following options impact revenue information:
|
|
Cost of Money |
The Cost of Money (COM) is included in revenue calculations. |
|
Projects and Organizations |
Revenue is derived from projects that are classified as Direct, Inter-Company or Inter-Co Multi. The revenue level of the project is used to obtain the owning organization and the project attributes. |
|
Profit amount
|
Project revenue – This is all project direct and indirect costs. Revenue — The source of Revenue is the Project Status Report reporting table in Costpoint. Revenue can be either actual or target, depending on the Revenue Type option your firm selects when it configures Costpoint Analytics. Costs — The source of Costs is the Project Status Report reporting table in Costpoint. If prior year cost or revenue adjustments are included in the PSR tables, the calculation of profit amounts may include those adjustments, depending on how Costpoint Analytics is configured. For more information, see Adjustment Period. |
|
Profit Margin |
Profit Margin = Profit Amount / Revenue Margin is displayed as a percentage. |
|
Gross Profit Amount |
Project Revenue = (All project direct costs + Indirect costs directly linked to the project) Revenue — The source is the Project Status Report reporting table in Costpoint. Revenue can be either actual or target, depending on the Revenue Type option your firm selects when it configures Costpoint Analytics. Costs — The source is the Project Status Report reporting table in Costpoint. The gross profit calculation is also affected by Costpoint Analytics configuration options that enable your firm to do the following:
If prior year cost or revenue adjustments are included in the PSR tables, the calculation of gross profit amounts may include those adjustments, depending on how Costpoint Analytics is configured. For more information, see Adjustment Period. |
|
Gross profit margin |
Gross Profit Amount / Revenue Margin is displayed as a percentage. |
|
Baseline budget profit amount |
Budgeted project revenue – All budgeted project direct and indirect costs. Revenue — The source is the baseline budget revenue data in the revenue and cost budget file. Revenue can be either actual or target, depending on the Revenue Type option your firm selects when it configures Costpoint Analytics. Costs — The source is the baseline budget cost data in the revenue and cost budget file. |
|
Forecast profit amount |
Budgeted project revenue – All budgeted project direct and indirect costs. Revenue — The source is the forecast revenue data in the revenue and cost budget file. Revenue can be either actual or target, depending on the Revenue Type option your firm selects when it configures Costpoint Analytics. Costs — The source is the forecast cost data in the revenue and cost budget file. |
|
Project Manager, Project Name, Project Type, Project Parent |
The Project Manager, Project Name, Project Type, and Project Parent occur at the Revenue Project level. |
|
Projected profit amount |
This is a combination of profit calculated from Costpoint data for fiscal periods through the current period and budgeted profit calculated from baseline budget or forecast data for future fiscal periods. |
|
Projected profit margin |
Projected profit amount / Projected revenue Projected Revenue — This is a combination of revenue from Costpoint data for fiscal periods through the current period and budgeted revenue from baseline budget or forecast data for future fiscal periods. Margin is displayed as a percentage. |
|
Inception Budget Revenue |
The Inception Budget Revenue is a projected value that is derived by applying past actuals and projected revenue to derive the ITD Budgeted Revenue for future periods. |
|
Inception Forecast Revenue |
The Inception Forecast Revenue is a projected value that is derived by applying past actuals and projected revenue to derive the ITD Budgeted Forecast for future periods. |
|
Projected gross profit amount |
This is a combination of gross profit calculated from Costpoint data for fiscal periods through the current period and budgeted gross profit calculated from baseline budget or forecast data for future fiscal periods. |
|
Projected gross profit margin |
Projected Gross Profit Margin = Projected Gross Profit Amount /Projected Revenue Projected Revenue — This is a combination of revenue from Costpoint data for fiscal periods through the current period and budgeted revenue from baseline budget or forecast data for future fiscal periods. Margin is displayed as a percentage. |
|
Amount variance |
Amount Variance = Projected Profit or Gross Profit Amount – Baseline Budget Amount or Forecast Amount |
|
Amount variance percentage |
Amount Variance Percentage = (Amount variance / Baseline budget amount or forecast amount) × 100 |
|
Baseline budget margin |
Baseline Budget Margin = Baseline budget profit amount / Baseline budget revenue Margin is displayed as a percentage. |
|
Forecast margin |
Forecast Margin = Forecast profit amount / Forecast revenue Margin is displayed as a percentage. |
|
Margin variance |
Margin Variance = Projected profit or gross profit margin – Baseline budget margin or forecast margin |
|
Margin variance percentage |
Margin Variance Percentage = (Margin variance / Baseline budget margin or forecast margin) × 100 |
|
Posting Revenue |
It is very common to post revenue by Owning Corporate Structure. |
|
Cross Charging |
Cross charging affects the display of revenue data when revenue is calculated by performing corporate structure. It does not affect revenue by owning corporate structure because of the revenue only being reported by owning corporate structure. |