Microsoft KB Archive/44662

From BetaArchive Wiki

Method of BCWS Calculation

PSS ID Number: Q44662 Article last modified on 03-15-1995

1.00 3.00 3.00a 4.00 | 1.10 3.00 4.00


The information in this article applies to:
- Microsoft Project for Windows, versions 1.0, 3.0, 3.0a, 4.0 - Microsoft Project for the Macintosh, versions 1.1, 3.0, 4.0

Microsoft Project has the ability to calculate Earned Value during the life of a project, based on planned information. This cost is known as Budgeted Cost of Work Scheduled (BCWS). Given that you are working with a task with a starting date of 6/5/89 8:00 AM and a current date of 6/7/89 5:00pm and a single resource that has a standard rate of $100/d and has a duration of 5d, on 6/7/89 5:00 PM, BCWS will be calculated [after copying the scheduled information into the plan (Options, Set Plan)] as $270.00.

This value can be found by making the Task Sheet the active view and applying the Earned Value table (Table, Define Table, New). This value is calculated by dividing the total elapsed hours (57) by the total number of hours in the task (105) and rounding the product to the nearest two significant figures. In this example, the value is 54 percent. Then multiply the value (.54) by the planned cost (100 * 5). Therefore, on 6/7/89 at 5:00 PM, BCWS equals $270.00.

KBCategory: kbother KBSubcategory:

Additional reference words: 4.00 1.00 1.0 1.1 1.10 3.0 3.00

Copyright Microsoft Corporation 1995.