Cost not reflecting right in cost plan even though there is no ETC on Project Assignment
search cancel

Cost not reflecting right in cost plan even though there is no ETC on Project Assignment

book

Article ID: 228995

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

We are facing an issue with Cost plan. In one project the COST is reflecting wrong in cost plan.

On the Project we currently do not have any ETC but when we populate from 'Task Assignment' we see Cost being populated. 

Where is this cost data coming from?

Resolution

The "New from Task Assignment" feature work as follows:
For every Cost Detail ‘Planned Cost’ in past periods, the data comes from the Actuals Units (taken
from posted Transactions) and the Rate Matrix Cost. Therefore, the Cost Rate
posted via the actual transaction is ignored.

The populate feature will populate the ‘Planned Units’ from the (ETC+Actual) Units and the ‘Planned Cost’ come from the planned units multiplied by the matching row in the live rate matrix. (It will not involve the actual cost for the ‘planned cost’ calculation)
The ‘Actual Units’ and ‘Actual Costs’ come directly from the WIP Transaction that has been posted.
Therefore, the ‘Actual Cost’ may be different than the ‘Planned Cost’

Example:
Rate Matrix is configured with $100 Rate, but actual transactions may use a different rate
Actual Units = 8 hours (1 day)
Actual Cost = (8 x 200) = 1,600
Remaining ETC = 16 hours (2 days)
Actual Cost comes directly from posted WIP transaction

Cost Plan calculations
Planned Units = 16 + 8 = 24 hours (2 days remaining in ETC, 1 day posted as actuals = 3 days)
Planned Cost = (24 x 100) = 2,400 (using rate from matrix)

Screenshots Below:
1 - Rate Matrix Row
2 - Task Assignment
3 - Actual Transaction Posted into WIP
4 - Cost Plan Population by Assignment

 

Note:
Actuals are considered to be in the past, and calculated as explained above, if the date of posting exists outside of the current fiscal period for the current system date, even if they are chronologically in the past. This can lead to planned cost discrepancies between cost plans if they use a different period type (especially quarterly/annual versus 13 period/monthly .

Additional Information

Also refer to communities article:

Cost Plan 'Planned' calculations for past periods