cancel
Showing results for 
Search instead for 
Did you mean: 

POC Aggregation from Activities to WBS

0 Kudos

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 ObjectWeightAggr. plan POC
-WBS 130066,7
--WBS 1.116062.5

---Activity A

70100
---Activity B30100
--WBS 1.214071.4
---Activity C50100
---Activity D50100

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

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

The only option I have found is to maintain aggregated POC weights at Activities level and no weights at WBS levels.

Answers (0)