Task Management Software for Team Collaboration
 
HomeDownloadSupportPurchase
 
Installation GuideStartUp GuideOnline Help

To Complete Schedule Performance Indicator (TSPI) per Project

To Complete Schedule Performance Indicator (TSPI) per Project
   
Home  » Products  » VIP Task Manager Pro  » Tutorials  » Customization Guide  » 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


Play demo Play Demo

TryTry It FREE
Overview VIP Task Manager

» VIP Task Manager Pro
   VIP Task Manager Std
   Testimonials
   Turnkey Solution

Available: Workdays, Monday - Friday
8 am - 8 pm GMT for Europe/Asia
1 am - 1 pm PST for America




Login:
Password:
Register
Forgot your password?
Login As:
Login As
You can log in if you are registered at one of these services:

ProductsSolutionsDownloadSupportPurchaseContactsForumVideoMy Account
Copyright © 2004 - 2017 Task Management Software
 
          
 
Site Map