Profit Summary

The Profit summary analytics include the following:

  • A bullet graph that provides a visual comparison of current year-to-date, quarter-to-date, or period profit to the current budget.

  • A table that compares the current to-date profit amount to the budget and displays the variance. For additional analysis, the table also provides prior year profit and budget amounts for the same period, and the projected year-end or quarter-end profit and budget amounts.

You can choose to view profit or gross profit, either as amounts or as margin percentages.

If your review of the summary profit data suggests the need for more detailed analysis, click Profit to go to Costpoint Analytics - Projects.

If you have not been given access to profit information in Costpoint Analytics, the Summary Dashboard tab does not display the Profit summary area.

In this topic

Bullet Graph

Table Data

Profit Calculation

User Options That Affect the Profit Summary

 

 

Bullet Graph

The Profit analytic area includes a bullet graph to give you a visual comparison of profit to budget for the analysis period. The center column of the table below the bullet graph in the Profit summary area displays the profit and budget amounts on which the graph is based.

Graph Item

Description

Horizontal bar (black)

The black horizontal bar represents the profit for the analysis period (for example, year-to-date profit).

If you position the mouse pointer at any point on this bar, Costpoint Analytics displays the profit budget amount, the profit amount and percentage of budget at which the cautionary alert is triggered, and the profit amount and percentage of budget at which the urgent alert is triggered.

Vertical bar (black)

The black vertical bar represents the profit budget or forecast for the analysis period (for example, year-to-date profit budget).

Percent Attained

The percentage to the right of the graph is the percentage of budget attained for the analysis period:

(Profit or gross profit / Budget or forecast) × 100.

Percentage scale

The scale along the bottom of the graph indicates percentage of budget.

Alert areas

The graph background is divided into alert areas based on tolerance percentages that your system administrator established for profit:

  • Acceptable — If the profit bar extends into the area on the right (as in the illustration above), that area is green, indicating acceptable performance.

  • Cautionary alert — If the profit bar ends within the middle area, that area is yellow, indicating that performance is below the expected level but is not yet a critical problem.

  • Urgent alert — If the profit bar ends within the left area, that area is red, indicating that performance is far enough below budget that it requires urgent attention.

The width of the cautionary alert area depends on the tolerances your system administrator specifies. If the difference between the percentage at which the cautionary area begins and that at which the urgent area begins is small, the cautionary alert area will be very narrow.

Table Data

Data Item

Description

Profit/Gross Profit: Prior Year

Year-to-date, quarter-to-date, or period profit or gross profit for the current period in the prior year.

Baseline Budget/Forecast: Prior Year

Year-to-date, quarter-to-date, or period profit or gross profit budget for the current period in the prior year.

Profit/Gross Profit: YTD/QTD/Period

Year-to-date, quarter-to-date, or period profit or gross profit as of the current period in the current year.

Baseline Budget/Forecast: YTD/QTD/Period

Year-to-date, quarter-to-date, or period profit or gross profit budget for the current period in the current year.

Variance: YTD/QTD/Period

Year-to-date, quarter-to-date, or period profit or gross profit variance from budget.

If the percent attained falls within the cautionary alert range or urgent alert range, Costpoint Analytics displays the variance within a colored border to draw your attention to it. A yellow border indicates a cautionary alert, and a red border indicates an urgent alert.

Profit/Gross Profit: Projected Year End/Projected Qtr End/YTD

Projected year-end or quarter-end profit or gross profit, based on actual performance through the current period and the budget for the remainder of the year.

If the analysis period is just the current period, this column displays year-to-date profit or gross profit through the current period.

Baseline Budget/Forecast: Projected Year End/Projected Qtr End/YTD

Year-end or quarter-end profit or gross profit budget.

If the analysis period is just the current period, this column displays the year-to-date profit or gross profit budget through the current period.

Profit Calculation

Costpoint Analytics first calculates profit for revenue-level projects and then rolls up those profit amounts and corresponding budget amounts to determine the summary profit data displayed on the Summary Dashboard tab.

You have the option to display summary data for either profit or gross profit:

Profit = Project revenue – All project direct and indirect costs.

Gross profit = Project revenue – (All project direct costs + Indirect costs directly linked to the project)

You also have the option to express profit or gross profit as dollar amounts or as margin percentages:

Profit margin = Profit / Revenue (displayed as a percentage)

Gross profit margin = Gross profit amount / Revenue (displayed as a percentage)

A Costpoint Analytics configuration option controls whether or not revenue is actual or target. For the calculation of gross profit, other configuration options determine whether cost of money is included and which indirect cost pools are included.

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.

Budget and forecast amounts and margins are calculated in the same way using revenue and cost budget data loaded from the Revenue Budget file.

Profit budget data on the Summary Dashboard tab does not include proposals. If your firm has loaded proposal data, go to the detailed Profit Analytics if you want to include proposal data in your analysis.

For more on how Costpoint Analytics calculates profit, see Profit Analytics: Data Sources.

User Options That Affect the Profit Summary

Your selections on the User Options tab affect the profit summary in the following ways:

User Option

Effect on the Analytics

Budget Type

Use the options under Budget Type to specify the budget data to which you want to compare actual performance:

  • Baseline Budget — Select this option to compare actual performance to the baseline budget.

  • Forecast — Select this option to compare actual performance to the current forecast (budget revision).

Org or Reorg

Use the options under Org or Reorg to indicate if you want to view data based on the organization structure or based on a reorganization:

  • Org — Select this option to view summarized data for all of the organizations to which you have access.

  • Reorg — Select this option to view summarized data for a specific reorganization. After you select Reorg, click Reorg Selection to display a list of the available reorganizations, and select the one you want.