Project Overview Tab

The Project Overview tab allows you to track project compliance and reporting, including revenue-to-funding value percentage.

It links to other Costpoint applications and shows specific project setup issues that may affect reporting accuracy. Click the info icon in the upper-right corner of any chart or table to see a quick explanation of what it shows and how to use it.

% Revenue to Funding

This pie chart provides a quick visual summary of the distribution of top-level projects based on the percentage of revenue earned compared to the funded value. Use this information to monitor project progress and notify customers when the project is approaching a 75% milestone.

The pie chart is categorized into the following ranges:

  • 0-59%
  • 60-75%
  • 76%+

The number of top-level projects in each range is displayed next to the corresponding segment.

Top Level Projects Missing Information

This bar chart and table identify top-level projects with missing or incomplete setup data, which may affect reporting accuracy across Costpoint. Use the icons in the upper-right corner to switch between the bar chart and table views. The table view lists the specific projects with missing information.

The horizontal bar chart displays how many top-level projects are missing information in each category. For each missing type, the chart counts a project once if any required information is missing at lower levels, regardless of how many levels are affected. This ensures the chart provides a clear, high-level overview without overstating the issue.

For example, if Project Manager is missing on every project level, the chart counts it as 1 for the associated top-level project, not for each missing lower level. If the revenue level is undefined or missing, Command Center treats the setup as incomplete for the top-level project, rather than attempting to count missing items at lower levels. Similarly, Labor History Rate and Modifications are only counted when the revenue level is defined, since these are required at that level.

Clicking a bar filters the table to display only projects missing that specific data. From the filtered table, click Missing Type to open the relevant application and update the data. You must have rights/access to the application to be able to open it. The linked application varies by missing data type:

  • Customer  > Manage Project User Flow
  • Labor History Rate  > Link Project Labor Category Rates to Projects, Manage Project Labor Categories (PLC), or Link PLC Rates to Employee/Vendor
    Note: The Missing Labor History Rate is a dynamic link that directs you to one of these three Costpoint applications, depending on the project's rate sequence setup.
  • Modifications  > Manage Modifications
  • Project Manager  > Manage Project User Flow
  • Revenue Setup  > Manage Revenue Information

Project Table

This table provides a detailed list of all top-level projects assigned to you and expands to revenue-level projects. It serves as the main data view for tracking project performance at a glance.

Use the following controls above the table to customize your view:

Field Description
Collapse All

Click this button to collapse grid information.

Expand All

Click this button to expand grid information.

Clear All Filters

Click this button to clear all the filters you selected.

As of [date]

The data displayed in this table is based on the End Date set on the Manage Current Reporting Period screen, which is maintained by your administrator. The active reporting date is displayed at the top of the table header (for example, As of 05/31/2020).

The table includes the following columns:

Field Description
Project ID

This column displays the project ID. You can click the arrow icon to drill down to the revenue-level project.

This is a clickable link that opens the Manage Project User Flow application, where you can view and update detailed project information.

Project Name

This column displays the project name.

Project Manager

This column displays the project manager assigned to the project.

ITD Funded

This column displays the inception-to-date (ITD) funded value, including award fee.

Total Revenue

This column displays the total revenue, which includes ITD revenue calculated at target rates, plus pending revenue. Pending revenue is the estimated revenue on transactions like labor expenses that have been entered but not yet posted. It helps provide more real-time insight into the % Revenue to Funding calculation.

% Revenue to Funding

This column displays the percentage of revenue compared to the funded value. Projects that are 60-75% are highlighted in yellow.

Note: You can sort data in ascending or descending order by clicking in the column headers. To filter data, click next to any column name and select your criteria.

Project Revenue Details

The Project Revenue Details side panel is displayed when you click any row in the project list table. It displays the selected project's revenue performance and key setup information.

Field Description
Project ID - Project Name

This is a clickable link that opens the Project Status Report for the selected project on a new tab. When you hover over this field, a tooltip labeled "Launch Project Status Report" is displayed.

% Revenue to Funding

This displays the % Revenue to Funding value. Projects that are 60-75% are highlighted in yellow.

Revenue Information

Field Description
Contract Value

This displays the ITD, Pending, and Total contract values. Pending values represent future modifications or changes effective after the current BI reporting period, while ITD values are based on the effective date of the modification. These values are updated when revenue is calculated, and changes are stored in the PROJ_MOD_ITD_SUM table and then reflected in PSR_HSR.

Funded Value

This displays the ITD, Pending, and Total funded values. Pending values represent future modifications or changes effective after the current BI reporting period, while ITD values are based on the effective date of the modification. These values are updated when revenue is calculated, and changes are stored in the PROJ_MOD_ITD_SUM table and then reflected in PSR_HSR.

Revenue

This displays the ITD, Pending, and Total revenue values. Pending revenue is the estimated revenue from transactions that have been entered but not yet posted. It helps provide more real-time insight into the % Revenue to Funding calculation. Optionally, to populate the Pending Revenue column, run the Update Pending Report Tables application.

Important: As a best practice, it is recommended to update pending transactions, PSR, revenue, and burdens daily. If you update the pending transactions daily but only update the PSR weekly, some transactions may not be displayed in either data set. Posted transactions will drop from the pending table but won't be displayed in the PSR until its next update. Make sure your process timing is aligned to avoid data gaps.
Project Status Update

This displays the most recent date and time when the PSR data was last refreshed.

Pending Report Update

This displays the most recent date and time when the pending revenue data was last refreshed, based on the source table used for Pending Revenue.

Project Information

Field Description
Project Manager

This displays the project manager assigned to the project. Click the name to send an email to the project manager using your default email application.

Period of Performance

This displays the period of performance dates.

Customer Name

This displays the customer name that is entered on the Manage Project User Flow screen.

Owning Organization

This displays the owning organization.

Contractor Representative

Click the name to send an email to the contractor representative using your default email application.

Administrative Contracting Officer

Click the name to send an email to the administrative contracting officer using your default email application.

Project Type

This displays the project type.

Revenue Formula

This displays the revenue formula.