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:
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.