Wednesday, June 22, 2022

SV Percent (%) fields [MS]

The SV% (schedule variance percent) field shows the ratio of schedule variance (SV) to budgeted cost of work scheduled (BCWS), expressed as a percentage. The timephased version of this field shows values distributed over time.

There are several categories of SV Percent (%) fields.

Data Type    Percentage

SV Percent (%) (task field)

Entry Type    Calculated

How Calculated    Project calculates SV% for a task as follows:

SV% = (SV / BCWS) * 100

Best Uses    Add the SV% field to a task view when you want to see a percentage of how much you're under, over, or exactly on target with your schedule for the current level of completion on tasks.

Example    The schedule variance for a task (the difference between budgeted cost of work performed and scheduled) is \$50. The budgeted cost of work scheduled is \$500. Your SV% is 10 percent, meaning you're 10 percent ahead of schedule for the current level of completion on this task.

Remarks    If the SV% is a positive percentage, the task is ahead of schedule. If it's 0 percent, the task is right on target. If it's a negative percentage, the task is behind schedule.

The SV% field is available by default on the Earned Value Schedule Indicators table. With the Task Sheet view displayed, you can apply the Earned Value Schedule Indicators table in the More Tables dialog box.

SV Percent (%) (task-timephased field)

Entry Type    Calculated

How Calculated    SV% is the task's timephased schedule variance (SV) divided by the timephased BCWS. The timephased values for SV and BCWS make timephased values for SV% available. Project calculates the SV% for a task as follows:

SV% = (SV / BCWS) * 100

Best Uses    Add the SV% field to the timephased portion of the Task Usage view when you want to see a percentage of how much you're under, over, or exactly on target with your schedule for the current level of completion on tasks.

Example    On Monday, the schedule variance for a task (the difference between budgeted cost of work performed and scheduled) is \$50, indicating you're \$50 under budget. The budgeted cost of work scheduled is \$500. Your SV% is 10 percent, meaning you're 10 percent ahead of schedule for the current level of completion on this task. On Tuesday, the SV for the task is \$0. The BCWS for this day is \$500. The SV% is 0 percent, indicating that you're exactly on target. On Wednesday, the SV for the task is -\$10, and the BCWS for this day is \$400. The SV% is -2.5 percent, indicating that the task is 2.5 percent behind schedule so far.

Remarks    If the SV% is a positive percentage, the task is ahead of schedule. If it's 0 percent, the task is right on target. If it's a negative percentage, the task is behind schedule.

In addition to the timephased SV%, you can show total SV% for tasks in the sheet portion of the Task Usage view. Either add the SV% field to the current table, or apply the Earned Value Schedule Indicators table, in which the SV% field is included by default. With the Task Usage view displayed, you can apply the Earned Value Schedule Indicators table in the More Tables dialog box.