To Complete Schedule Performance Indicator (TSPI) per Project

To Complete Schedule Performance Indicator (TSPI) per Project

To Complete Schedule Performance Indicator (TSPI) per Project is a project management key performance indicator that shows the percentage how the remaining project time should be utilized. To Complete Schedule Performance Indicator (TSPI) is a project efficiency rating that tells you at how much percentage of efficiency the assigned resources should work on project so that it can be on track. 

To Complete Schedule Performance Indicator (TSPI) can be calculated by the formula:

To Complete Schedule Performance Indicator (TSPI) = (Total Budgeted Cost - Budgeted Cost of Work Performed (BCWP)) / (Total Budgeted Cost - Budgeted Cost of Work Scheduled (BCWS))

It is equal to:

To Complete Schedule Performance Indicator (TSPI) = (Total Budgeted Cost - Earned Value (EV)) / (Total Budgeted Cost - Planned Value (PV))

If the value of this KPI is less than 1 the assigned resources should use the remaining project time more efficiently and work harder.

If the value of this KPI is greater than 1, the assigned resources can work at lower efficiency.

For example, if Total Budgeted Cost of a project is $30 000 USD, BCWP of the project is $9 000 USD at certain date and BCWS is $15 000 USD at the same date, TSPI is calculated as follows:

TSPI = (Total Budgeted Cost – BCWP) / (Total Budgeted Cost – BCWS) = ($30 000 USD – $9000 USD) / ($30 000 USD –$15 000 USD) = 1.4

TSPI 1.4 indicates that the resources have to work 140% harder than normal 100% to keep project on track.

To Complete Schedule Performance Indicator (TSPI) is used to forecast future performance of a project and take appropriate actions to keep it on track.

To calculate To Complete Schedule Performance Indicator (TSPI) per Project please follow the steps below:

• Add custom field “Total Budgeted Cost” (see “Actual Cost of Projects”)  with code  “cf_total_budgeted_cost”

For material-based projects you need to create additional custom field, for example, “Material Cost” with Code “cf_material_cost”



• Add the custom field “BCWP” (Budgeted Cost of Work Performed) with code “cf_bswp”



• Add the custom field “BCWS” (Budgeted Cost of Work Scheduled) with code “cf_bcws”



• Add the custom field “TSPI” with the formula:

($cf_total_budgeted_cost - $cf_bcwp) / ($cf_total_budgeted_cost - $cf_bcws)



• On Task Tree select the task group for which you need to display To Complete Schedule Performance Indicator (TSPI) per Project  and select “Custom fields options”



• Set the following custom fields settings for the custom fields: “Total Budgeted Cost”, “BCWP”, “BCWS” and “TSPI”
  • In “Settings for” select “This task group”
  • select “Enable”
  • select “Calculated by custom field formula (for task group)”











To Complete Schedule Performance Indicator (TSPI) per Project on Task Tree