#1
|
|||
|
|||
Earned Value Calculations - BCWP In Microsoft Project
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Microsoft Project Managing Planned / Earned Value & Actual Costs | shane_dav71 | Project | 1 | 10-06-2014 06:07 PM |
MS Project not calculating earned value correctly | mtbtomo | Project | 1 | 10-23-2013 06:49 AM |
Microsoft Word Form, DropDown Fields and Calculations | Tracy Lynn | Word VBA | 2 | 09-29-2013 08:59 PM |
Finding Earned Values for Different Baselines in a single project | pratik6312 | Project | 1 | 08-22-2013 11:18 AM |
Microsoft Word Calculations and Dropdown Fields | Tracy Lynn | Office | 4 | 06-26-2013 07:36 AM |