Project KPIs

Overview

This article explains how the Project KPIs that appear on the Project Workspace are calculated.

KPI Indicators Located on the Project Workspace area

The KPIs can be found on the project workspace area.

Which fields drive the KPIs?

A few fields are associated with populating the KPIs. For the specific business rules and calculations for each KPI, refer to the section below, KPIs that ship with ResourceFirst and their Business Rules.

KPI	Fields used to calculate the KPI value
Overall	This considers each of the values of the other KPIs
Budget	Financial forecast on Financial Assignment page Official Baseline of the Financial forecast on Financial Assignment page Note: the out of the box field, Budget, does not impact this KPI
Schedule	Project End date Official Baseline Project End Date
Resource	Labor forecast Labor Allocated
Scope	The assumption is if the resource demand increases then the scope also increases. Labor forecast on Assignment page Official Baseline of the labor forecast on Assignment page
Risk	# of Risks Probability value of each Impact value of each
Issue	# of Issues Probability value of each Impact value of each
Quality	The project’s Status field

KPIs that ship with ResourceFirst and their Business Rules

Every KPI gets a number: 3=red, 2=yellow, 1=green.

Overall:

• Every KPI gets a number 3=red, 2=yellow, 1=green.
• Take the average of the other 6 KPIs and round it to the nearest color.

Budget:

• Note: this is a calculated KPI; the out of the box field, Budget, does not impact this KPI.
• Rule is:
  • ((Forecast from Financials Assignment page) – (Official Baseline from Financials Assignment page)) / (Official Baseline from Financials Assignment page)
  • If >.1 then red.  If <=0 then G

Schedule:

• Project End date vs. Official Baseline Project End Date.
  • Note: Of the two baseline types, Baseline and Official Baseline, only the Official Baseline is considered by the KPI
• Determined by percentage of baseline duration:
  • (EndDate-Official BaselineEndDate) / (Official BaselineEndDate- Official BaselineStartDate)
  • If >10% then Red.  If <=0 then Green, else Yellow.

Resource:

• Labor Forecast vs. Labor Allocated
• Green is >95% allocated, Yellow is 70-95%, Red is below 70%

Scope:

• The assumption is if the resource demand increases then the scope also increases.
• Rule is:
  • ((Labor Forecast from Assignment page) – (Official Baseline of the labor forecast on Assignment)) / (Official Baseline of the labor forecast on Assignment page)
  • If >.1 then red.  If <=0 then G

Risk:

• Probability and impact of defined Risks
• Rules are:
  • Calculate each Risk using Impact * Probability (each get a number from 1 to 3).
  • Take the average.
  • When >6 then Red; when >3 then Yellow, else Green

Issue:

• Volume and impact Probability and impact of defined Issues
  • Calculate each Issue using Impact * Probability (each get a number from 1 to 3).
  • Take the average.
  • When >6 then Red; when >3 then Yellow, else Green

Quality:

• The out of the box field, Status, is manually updated. This Quality KPI reflects the Green/Yellow/Red value selected in that field. This is a health assessment status set by the project manager.

KPIs Configuration [Notes for ResourceFirst Admins]

Project Kpis View

• The name of the view needs to have only the K capitalized in Kpis and the full name needs to be Project Kpis.
• The view only needs a few fields as seen below. The actual KPI indicators are automatic and aren’t fields added to the view definition.
• Additional custom calculations can be added.

Enabling the KPIs

For the indicators to be enabled:

• There is a Pulse Script that needs to be added to ResourceFirst (ask PDWare Support for this script) and then scheduled.
• The fields listed in column two of the section, Which fields drive the KPIs?, need to be populated for their respective KPI calculations to occur.