Hi I have a question regarding how Microsoft Project calculates BCWP. Let me ask the question in the form of an example

Scenario is based on single resource and single task with the EVM calculation using %complete (as opposed to physical % complete) with a contoured work profile.


Resource A costs £10/hr
Task 1 has a duration of 5 days with the following work profile (baseline work)

7.5h,3.75h,7.5h,3.75h,7.5h = 30hrs

Thus BCWS after day 5 is £300
£75,£112.5,£187.5,£225,£300

At the end of day 1 Resource A estimates that there is 3.5 days of work left (instead of 4) thus the new project duration is 4.5 days (as opposed to the base-lined 5). What is the BCWP?

I calculated (correctly) the %complete as 22% i.e. 1 day completed divided by the (new) duration 4.5 = 0.22 or 22%

So I thought perhaps BCWP 0.22 * £300 = £66.

This didn't look correct as the BCWS is £75 for day 1 and we managed to do more work that resulted in the estimate to complete reducing from 4 days to 3.5.

I then considered calculation from the point of view of base-lined remaining days and actual remaining days (I thought I read somewhere this is how it is calculated) i.e. 4 (base-lined) days left / 3.5 (new estimated) days left =1.143 * £75 = £85.714



According to my project this is correct against the resource. However Microsoft project reports £79.17 against the task. The BCWP against the tasks appears to drive the SPI.

My questions are
1. Is the method I used to calculate BCWP correct? i.e. remaining task duration method.
2. How does Microsoft Project arrive at £79.17 for the BCWP for the task when only 1 resource works on it and the BCWP against the resource is £85.714.

Any help greatly appreciated.