Project Systems – Result Analyses – Different valuation method under one RA WBS
I have a situation in which Level 2 WBS has the RA key and RA will always run on level 2. RA keys not allowed on lower levels WBS. Project structure extends to level 5 and usually cost and revenue are collected at level 4 and level 5.
Requirement is, RA should run and accumulate at level 2 but the values should be calculated as per the level 4 and level 5 WBS status. e.g. if level 4 WBS is not billed then actual cost should post to WIP and revenue to unbilled AR but if the level 4 is Billed then individual amount should contribute to COS and Actual Revenue. All the individual calculation for WIP, Unbilled AR, COS and revenue should be accumulated at level 2 WBS.
Level 2 WBS (RA Key) (Total) WIP | Unbilled AR | COS | Revenue |
Level 2 WBS (RA Key) (Total) | $100 | $120 | $180 | $220 |
level 3-A (not billed yet) (Total) | $100 | $120 | | |
level 4 (not billed yet) | $40 | $100 | | |
level 5 (not billed yet) | $ 60 | $20 | | |
Level 3-B (billed) (Total) | | | $180 | $220 |
level 4 (billed) | | | $70 | $80 |
level 5 (billed) | | |$110 | $140 |
Any help would be appreciated.