TCPI (task field)

Data Type    Number

Entry Type    Calculated

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:

TCPI = (BAC - BCWP) / (BAC - ACWP)

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.