Backlog Composition Table

The Backlog Composition table provides a high-level overview of the backlog's details, including beginning backlog, component amounts, ending backlog, and the variance from budget or forecast. This information is displayed by the designated analysis period, and you can select different dashboard filters and analysis periods to adjust as needed.

The start and end date for the analysis period display as part of the caption, and the caption updates as you change dates. This information is important for cases where there is baseline or budget data beyond the current period.

In this topic

Display the Table

Table Data

Backlog Type

User Options That Affect the Table

Maximize the Table

Focus the Table

Sort the Table

Send the Table Data to Excel

Other Chart Actions

Display the Table

If the Backlog Composition table is not visible, click the Composition tab.

Table Data

All columns are inception-to-date (ITD). If periods beyond the current period are included, then respective budget information is included, depending on the selected Budget Type on the User Options tab.

Data Item

Description

Beginning Backlog

The beginning backlog amount is calculated by applying the ending backlog for the first prior period that contains a value.

New Contracts/Funding

This column displays an increase to backlog.

Contract Expansion/Additional Funding

This column displays an increase to backlog.

Contract/Funding Adjustments

This column displays any contract or funding adjustments.

Actual or Target Revenue

Revenue is the difference between YTD revenue from period to period within the fiscal year. This column displays the actual or target revenue for the analysis period.

If prior year revenue adjustments are included in the PSR tables, revenue amounts may include those revenue adjustments, depending on how Costpoint Analytics is configured. For more information, see Adjustment Period

Ending Backlog

 

Ending Backlog = (Beginning Backlog + New Contracts + Contract Expansion + Adjustments – Revenue)

Ending Backlog Baseline Budget (or Forecast)

This displays the ending baseline budget or forecast, depending on the settings on the User Options tab.

Variance

Variance = Ending Backlog – Ending Backlog Budget

Variance %

This is the Variance divided by Ending Backlog Budget; this column displays as a percentage.

If there is a variance, a cautionary or urgent alert may display in this column.

  • Cautionary alert — The Variance % cell displays in yellow to indicate the alert is cautionary.

  • Urgent alert — The Variance % cell displays in red to indicate the alert is urgent.

See Alerts for more information.

Backlog Type

There are two types of backlog: Contract and Funded.

Backlog defaults to Contract when used initially, but you can switch the type of backlog at any time.

To switch the type of backlog...

  1. Locate the backlog type options.

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

User Options That Affect the Table

The following options on the User Options tab affect this chart:

For descriptions of how each option affects Backlog Analytics, see User Options That Affect Backlog.

Change the Analyzed Attribute

By default, the Backlog Composition table displays the backlog and contract information by top-level organization, but you have the option to display the distribution by any of the following:

To change the view, do either of the following:

If you apply filters before you change the view, the table only displays data for items that satisfy those filters. For example, if you select two project types in the Project Type list under Additional Filters and then use to display the by project type, the table only displays the projects for those two project types.

See Filter the Analytics for more information.

Maximize the Table

Click to display the table at its maximum size so you can read it and interact with it more easily. Click to restore the table to its original size and location on the tab.

Focus the Table

You can narrow the focus of this table by selecting a row in the table. Costpoint Analytics removes all data from the table except for that row.

If you focus the table by selecting a row, Costpoint Analytics applies the same change, as appropriate, to all other analytic objects.

Sort the Table

To sort the table based on the values in one of the columns, double-click the column heading for that column.

To change the sort order from ascending to descending or from descending to ascending, double-click the column heading of the current sort column.

Send the Table Data to Excel

Click to send the data underlying the table to Microsoft Excel. More...

Other Table Actions

In addition to the actions described above, you can also do the following:

For more on these actions, see Print, Email, or Export Analytic Data and Attach Notes to Analytics.