Microsoft KB Archive/79941

= Comparing Actual Percent Complete to Planned Percent Complete =

Article ID: 79941

Article Last Modified on 11/25/2003

-

APPLIES TO


 * Microsoft Project 1.0 Standard Edition
 * Microsoft Project 3.0 Standard Edition
 * Microsoft Project 3.0a
 * Microsoft Project 4.0 Standard Edition
 * Microsoft Project 4.1 Standard Edition

-



This article was previously published under Q79941



SUMMARY
It is possible to create a filter in Microsoft Project for Windows that will determine if a task is behind schedule, based on the actual percent complete compared to the planned percent complete.



MORE INFORMATION
While there is no defined field for the planned percent complete for a task, Project does calculate this value when determining the BCWS (budgeted cost of work scheduled) value for the task.

The BCWS value is defined as

BCWS = (planned percent complete) X (planned cost)

where the planned percent complete is based on the task's planned start and finish dates, and the current date. For example, if a task has planned start and finish dates of 11/4/91 8:00am and 11/8/91 5:00pm, and the current date is 11/6/91 1:00pm, the planned percent complete would be 50% (assuming the default Standard project calendar is used).

Project also calculates a BCWP (budgeted cost of work performed) value for a task as

BCWP = (percent complete) X (planned cost),

where the percent complete represents the actual progress on the task.

Because of the similarity of these two formula, a comparison of actual percent complete to planned percent complete is equivalent to a comparison of BCWS to BCWP. This comparison can be convenient for filtering on certain tasks.

For example, to display only tasks that are running behind schedule (that is any tasks with a percent complete value less than their planned percent complete), you can create the following filter:

Note that these types of comparisons are only valid for tasks that have a planned cost associated with them.

Keywords: kbinfo kbusage KB79941

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.