on 06-03-2014 7:51 AM
Hello Experts,
I am implementing EVA analysis for the first time. I am able to get almost all values in CNE5 but I am not able to understand the logic behind upward aggregation for manual weightage.
For example:
Project Version : 100
EV Basis : Cost Plan (annual)
POC weighting : Weight
- WBS1 POC weight 'none' Measurement Method : None
--WBS 1.1 POC weight 60 Measurement Method : None
---Activity A POC weight 70 Measurement Method : Cost Proportional
---Activity B POC weight 30 Measurement Method : Time Proportional
--WBS 1.2 POC weight 40 Measurement Method : None
---Activity C POC weight 50 Measurement Method : Cost Proportional
---Activity D POC weight 50 Measurement Method : Time Proportional
All these activities pertain to period 1, and after I run cjen and cne1 for period 1, i get the following values in cne5
Project Object | Weight | Aggr. plan POC |
---|---|---|
-WBS 1 | 300 | 66,7 |
--WBS 1.1 | 160 | 62.5 |
---Activity A | 70 | 100 |
---Activity B | 30 | 100 |
--WBS 1.2 | 140 | 71.4 |
---Activity C | 50 | 100 |
---Activity D | 50 | 100 |
Calculated Weight at WBS 1 : 160 + 140 = 300
Calculated Aggr. plan POC at WBS 1 : (160*62.5 + 140*71.4) / (160 + 140) = 66.7
Calculated weight at WBS 1.1 : 70 + 30 + 60 = 160
Calculated Aggr. plan POC at WBS 1.1 : 100 / 160 = 62.5
Calculated weight at WBS 1.2 : 70 + 30 + 40 = 140
Calculated Aggr. plan POC at WBS 1.2 : 100 / 140 = 71.4
Now my question is why the system is adding 60% to weightage when calculating Weight at WBS 1.1 and Aggr.plan POC for WBS 1.1 ? What is the logic behind it which I am failing to understand ?
Activities A & B are 100% complete so their superior WBS 1.1 should have an Aggr. plan POC of 100 %
Accordingly WBS 1.1 and WBS 1.2 are 100 % complete so Aggr. plan POC for WBS 1 should be 100 % as well.
If for example :
Activities C & D were 0 % complete, accordingly WBS 1.2 would have Aggr.plan POC = 0%. With Activities A & B completed, WBS 1.1 Aggr.plan POC should equal 100 %. Accordingly Aggr.plan POC for WBS 1 should equal : (100*60 + 0*40) / 100 = 60 %
I hope I am able to explain my problem and requirement. I am also attaching a screenshot for this scenario.
Kindly help me understand these calculations and find out a way to get the desired results.
Thankyou
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.