I investigated this a couple months ago with CA. We had the same issue. There is a lot involved in getting the EAC and the way CA calculates it is not the way we want it to, therefore we are having someone build a Storyboard report for our needs. I also second what Urmas said plus here are the notes CA sent me about the EAC. Hope it helps.
For the EAC (Estimate at Completion) that is highlighted in that screen shot you provided in the Project Storyboard report, this is calculated as follows:
Project ETC(COST) + Project ACWP
The Estimate at Completion under Financial Performance in the Storyboard report should match the field 'EAC (T)' from the project. Is this not matching?
To make sure it is matching and calculating correctly, I recommend adding the following fields to the project list page:
* EAC (T)
* ETC (Cost)
* ACWP
So, then EAC (T) should = ETC (Cost) + ACWP
There is another EAC field called 'EAC' on the project list view. This field is calculated differently, and requires baselines, but this one isn't the one being pulled into the project storyboard report:
EAC = ACWP + [(BAC – BCWP) / CPI] where CPI = BCWP / ACWP Baseline Required: Yes
ACWP
Displays the system-calculated value of Actual Cost of Work Performed (ACWP). This value is the total direct cost (based on posted actuals) that is incurred in performing work during a specified period. The cost calculation includes all actuals posted up until the as-of date or the system date (if no as-of date is provided). ACWP is calculated at the following levels:
ACWP = Sum of Actual Cost for all the assignments on the task
ACWP = Sum of ACWP for all detail tasks in project
In short, ACWP is calculated by taking the actuals on the task * resource rate.
EAC (T)
Displays the system-calculated value of Estimate At Completion (EAC). This calculation is most often used when current variances are seen as typical of future variances.
EAC (T) = ACWP + ETC
ETC (Cost)
Displays the system-calculated value of Estimate To Completion (ETC).
ETC (Cost) = remaining labor cost + remaining non-labor cost
How is the ETC(Cost) Calculated?
ETC x the billing rate(from Rate Matrix).
- Can use the Team tab to calculate the ETC x the rate.
From CA:
Here's a link to the communities post I mentioned on our call: https://urldefense.proofpoint.com/v2/url?u=https-3A__communities.ca.com_message_98939930-2398939930&d=BQICaQ&c=6071WI5hme3qubAgsPInwSFFJUptGl1Ret_NIv4f0FM&r=Rgafss2eBPL3WxpuEQaP3DhgMmBoY9nK74o1rz8cVjA&m=4YGfAIzVqAe8LQ5kCWU7Lzcy42_OSdrXkLVZ2TXfu3Y&s=JOWQCn8UF2rL2AsZHqMpjfgm2uIO19JXtYJqls0AoB4&e=
This one explains some of the earned value fields such as ETC Cost in a little more detail.
ETC (Cost): Cost of Estimate to Complete
ETC (Cost) = remaining labor cost (ETC * billing rate) + remaining non-labor cost
Baseline Required: No