Kathryn_Ellis

CA Clarity Tuesday Tip: Cost Plan 'Planned' calculations for past periods

Discussion created by Kathryn_Ellis Employee on Aug 13, 2013
Latest reply on Sep 11, 2014 by Kathryn_Ellis

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

Outcomes