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?
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 .
Also refer to communities article: