How is % Expended calculated in Open Workbench versus the CA PPM application

Document ID : KB000027048
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:   

How is % Expended calculated in Open Workbench (OWB) and the CA PPM application?

Solution:   

Open Workbench:

In Open Workbench, the calculation includes cost rates for all types of resources. 

At the Assignment level: (actual hours * billing rate) / [(actual hours + ETC hours) * billing rate]
OR
actual hours / (actual + ETC hours)

Billing Rate comes from the Rate Matrix Extraction table (NBI_PROJ_RES_RATES_AND_COSTS) general Actual Cost Rate where task_id = -1

At the task level everything is converted to Cost, then the division is done.

In other words, calculate each assignment for the task: actual hours * billing rate and total usage * billing rate. Add all actual costs for the task, add all total usage costs for the task, then divide.

CA PPM application:  

In the CA PPM application, the % Expended field does not use cost rates and it is limited to the labor resources only.

The calculation is actual hours/ total usage hours.