TCPI (task field)

Data Type    Number (number field: A type of field whose content is a number. The maximum value allowed in this field is 999,999,999,999.99.)

Entry Type    Calculated (calculated field: A field in which the value is determined by Project based on information in other fields. Project may recalculate the value automatically or when you specify, depending on your choice of calculation settings.)

Description    The TCPI (to complete performance index) field shows the ratio of the work remaining to be done to funds remaining to be spent, as of the status date.

How Calculated    Microsoft Office Project calculates TCPI as:


Best Uses    Add the TCPI field to a task view to display or filter for the ratio of remaining available budget to be spent to remaining scheduled cost. This can help you see whether you're likely to have excess funds for the task, run out of money, or be right on target.

Example    You have a task with a baseline cost (BAC) of $200, BCWP of $125, and ACWP of $150. The TCPI is 1.5, indicating poor performance up to the status date. This means that to complete the project within budget, performance will need to improve.

Remarks    A TCPI value greater than 1 indicates a need for increased performance for the remaining work of the project in order to stay within budget (so you may need to give up some quality); less than 1 indicates performance can decrease to stay within budget, thus creating opportunities to increase quality or profit.

Applies to:
Project Professional 2013, Project Standard 2013, Project 2010, Project 2007, Project 2003