Update Earned Value and Cost Totals job calculates ETC Cost

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

How does the Update Earned Value and Cost Totals job calculate ETC cost at the assignment level?

Resolution

The ETC Cost is calculated based on the corresponding rate for the resource/role in the Rate Matrix.

If a rate exists in the Rate Matrix that fits that resource/role's criteria and date range, then the Rate Matrix Extraction job will need to run to populate the rate in the NBI_PROJ_RES_RATES_AND_COSTS table in the database. The rate in this table is then the rate that is referenced when calculating the ETC cost for the assignment.

ETC Cost = (ETC Hours) x (Rate in the NBI_PROJ_RES_RATES_AND_COSTS table)