1Project Performance Reporting

This chapter contains the following:

Use tolerance percentages to compare the previous key performance indicator (KPI) value with the current value. The application calculates trend indicators based on the percentage increase or decrease in a KPI value and the tolerance percentage in the KPI definition.

Example of Tolerance Percentage

When you create a KPI, you must enter a tolerance percentage that's used to determine the trend indicator for a KPI. The percentage change in KPI value is calculated using the following formula:

Percentage Change in KPI values equals absolute
value of open bracket, open parenthesis, current value minus previous
value, closed parenthesis, multiplied by hundred, closed bracket,
divided by previous value.

This table describes how the application uses tolerance percentage to calculate the trend indicator.

KPI Tolerance Percentage and Trend Indicator Setting Current Period KPI Value and Status Indicator Previous Period KPI Value and Status Indicator Percentage Change Trend Indicator Based on Previous Period

PTD Actual Invoice Amount

5 percent

Up is Favorable

$3500

Critical

$4800

Warning

27 percent

Down, Unfavorable

PTD Actual Spent Labor Effort Percentage

5

Up is Favorable

75

On Track

71

On Track

5.6 percent

Up, Favorable

PTD Actual Margin Percentage

2 percent

Up is Favorable

28.5 percent

Warning

30.2 percent

On Track

5.6 percent

Down, Unfavorable

Financial Plan Types Included in Summarization

Approved forecast and baseline budget versions of the following financial plan types are included in the summarization of project performance data by default:

  • Approved Revenue Budget

  • Approved Cost Budget

  • Primary Revenue Forecast

  • Primary Cost Forecast

A budget or forecast financial plan type may support both cost and revenue in one version.

Additional Financial Plan Types Included in Summarization

Apart from the financial plan types that are included in the summarization by default, you can manually include up to four financial plan types in summarization of project performance data.

Tip: You can include a financial plan type before it's used on a project for creating a version.

You can replace a financial plan type only until the project performance data is summarized for reporting. After that, you can only disable the financial plan type to exclude it from further summarization.

Project performance trend indicators show whether project performance is favorable or unfavorable. You can view the following trends:

Trend What Does It Indicate

Up, favorable

An increasing KPI value is favorable to the project.

Up, unfavorable

An increasing KPI value is unfavorable to the project.

Down, favorable

A decreasing KPI value is favorable to the project.

Down, unfavorable

A decreasing KPI value is unfavorable to the project.

Unchanged

No change to the KPI value.

In the Setup and Maintenance work area, use the Manage Trend Indicators task to change the default sort order of the trend indicators. Based on this sort order, the KPIs are listed in the KPI Watchlist region in the Project Performance Dashboard.

Example of KPI Thresholds with Different Currencies

You can set up different threshold ranges for each currency for currency-based KPIs to ensure that the thresholds apply for a particular currency amount.

Example of Threshold Levels with Different Currencies

The following example describes setting up of different threshold levels for each currency.

Vision Corporation sells and installs human resource software. A standard KPI used for installation projects is Period-to-Date (PTD) Invoice Amount. Projects are executed in different countries having different project and ledger currencies, such as United States dollars (USD), Japanese yen (JPY), and Indian rupees (INR).

The PTD invoice amount for projects with a ledger currency of USD is critical if the value is between 0 and 3,000 USD. The PTD invoice amount for projects with a ledger currency of INR is critical if the value is between 0 and 50,000 INR. The currency thresholds are independent of currency conversion.

FAQs for Project Performance Reporting

Certain financial plan types are included in summarization by default, while you must manually select others. Approved forecast and baseline budget versions of the following financial plan types are automatically included in summarization of project performance data:

  • Approved Revenue Budget

  • Approved Cost Budget

  • Primary Revenue Forecast

  • Primary Cost Forecast

Apart from the default financial plan types, you can include up to four others in summarization of project performance data.

Yes. Select the Edit Current Page link in the Personalization menu to show or hide regions. You can also modify the arrangement of the region layouts using the Change Layout option.

Can I select the columns to appear in the Project Performance Reporting dashboard tables?

Yes. The View menu in the region gives you options to add or remove columns in a region.