SV fields

The SV (earned value schedule variance) field shows the difference in cost terms between the current progress and the baseline plan (baseline plan: The original project plans [up to 11 per project] used to track progress on a project. The baseline plan is a snapshot of your schedule at the time that you save the baseline and includes information about tasks, resources, and assignments.) of a task, all assigned tasks of a resource, or for an assignment up to the status date or today's date. You can use SV to check costs to determine whether tasks or assignments are on schedule. The timephased versions of these fields show values distributed over time.

There are several categories of SV fields.

Data Type    Currency (currency field: A type of field whose content is expressed as a cost. Examples include the Actual Cost and Fixed Cost fields. The maximum value allowed in this field is 999,999,999,999.99.)

ShowSV (task field)

Entry Type    Calculated (calculated field: A field in which the value is determined by Project based on information in other fields. Project may recalculate the value automatically or when you specify, depending on your choice of calculation settings.)

How Calculated    SV is the difference between budgeted cost of work performed (BCWP) (BCWP: The earned value field that indicates how much of the task's budget should have been spent, given the actual duration of the task. Note that Project calculates BCWP at the task level differently than at the assignment level.) and budgeted cost of work scheduled (BCWS) (BCWS: The earned value field that shows how much of the budget should have been spent, in view of the baseline cost of the task, assignment, or resource. BCWS is calculated as the cumulative timephased baseline costs up to the status date or today's date.). Microsoft Office Project calculates the SV as follows:

SV = BCWP - BCWS

Best Uses    Add the SV field to a task sheet (sheet: A spreadsheet-like representation [in rows and columns] of task or resource information. Each row specifies an individual task or resource. Each column [field] specifies a type of information, such as start dates or standard rates.) to determine whether the task is behind or ahead of its baseline schedule in cost terms.

Example    The baseline plan for the "Write proposal" task had the task scheduled to complete 50 hours of work (work: For tasks, the total labor required to complete a task. For assignments, the amount of work to which a resource is assigned. For resources, the total amount of work to which a resource is assigned for all tasks. Work is different from task duration.) (at a cost of $500) by June 1. However, on June 1, the percent complete on the task was only 80 percent. The BCWP for this task is $400 (80 percent of $500). The BCWS is $500. Therefore, the SV is -$100, indicating in cost terms how much the task is behind the baseline plan.

Remarks    If the SV is positive, the task is currently ahead of schedule in cost terms. If the SV is negative, the task is currently behind schedule in cost terms. SV is expressed in currency units, the same units used in the CV (earned value cost variance) field. This makes it easy to plot SV and CV on the same graph.

ShowSV (resource field)

Entry Type    Calculated (calculated field: A field in which the value is determined by Project based on information in other fields. Project may recalculate the value automatically or when you specify, depending on your choice of calculation settings.)

How Calculated    SV is the difference between BCWP and BCWS. Microsoft Office Project calculates the SV as follows:

SV = BCWP - BCWS

Best Uses    Add the SV field to a resource sheet to determine whether the resource is behind or ahead of its baseline schedule in cost terms.

Example    Your baseline plan had Sean scheduled to complete 50 hours of work (at $10 per hour) by June 1, and Sean only had 80 percent of the work done by June 1. The BCWP for Sean's assignments is $400 (80 percent of 500). The BCWS is $500. Therefore, the SV is -$100, indicating in cost terms how much the resource is behind the baseline schedule.

Remarks    If the SV is positive, the resource's tasks are currently ahead of schedule in cost terms. If the SV is negative, the resource's tasks are currently behind schedule in cost terms. SV is expressed in currency units, the same units used in the CV (earned value cost variance) field. This makes it easy to plot SV and CV on the same graph.

ShowSV (assignment field)

Entry Type    Calculated (calculated field: A field in which the value is determined by Project based on information in other fields. Project may recalculate the value automatically or when you specify, depending on your choice of calculation settings.)

How Calculated    Schedule variance (SV) is the difference between the BCWP and the BCWS. Microsoft Office Project calculates the SV as follows:

SV = BCWP - BCWS

Best Uses    Add the SV field to the sheet portion of the Task Usage or Resource Usage view (view: The combination of one or more views [Gantt Chart, Resource Sheet, and so on] and if applicable, a table and a filter. Use views to work with information in a variety of formats. There are three types of views: Charts or graphs, Sheets, and Forms.) to determine whether the assignment is behind or ahead of the baseline schedule in terms of cost. The comparison of the two can indicate whether your tasks are behind or ahead of the baseline plan.

Example    Your baseline plan had Sean, at $10 per hour, working for eight hours on a task on June 1. Because of schedule changes, this assignment is now scheduled for June 2. When the status date is June 1, the BCWS for Sean's assignment is $80, and the BCWP is $0, because no actual work (actual work: The amount of work that has been performed on a task or assignment. When you enter actual work on a task, the remaining work is calculated using this formula: Remaining Work = Work - Actual Work. Actual work is often referred to as "actuals.") has been done. Therefore, the SV is -$80, indicating in terms of cost that the assignment is behind schedule.

Remarks    If the SV value is positive, the assignment is currently ahead of the baseline schedule in terms of cost. If the SV is negative, the assignment is currently behind the baseline schedule in terms of cost. SV is expressed in currency units, the same units used in the CV (earned value cost variance) field. This makes it easy to plot SV and CV on the same graph.

ShowSV (task-timephased field)

Entry Type    Calculated (calculated field: A field in which the value is determined by Project based on information in other fields. Project may recalculate the value automatically or when you specify, depending on your choice of calculation settings.)

How Calculated    SV is the difference between BCWP and BCWS. Microsoft Office Project calculates the SV as follows:

SV = BCWP - BCWS

Best Uses    Add the SV field to the timephased portion of the Task Usage view to determine whether the task is behind or ahead of the baseline plan in cost terms. Because Project maintains timephased values for BCWP and BCWS, timephased values for the SV are also available.

Example     The baseline plan for the "Write proposal" task had the task scheduled to complete 50 hours of work (at a cost of $500) by June 1. However, on June 1, the percent complete (percent complete: A field that you use to enter or display how much of a task has been completed. This value is expressed as the percentage of the task duration that has been completed.) on the task was only 80 percent. The BCWP for this task is $400 (80 percent of $500). The BCWS is $500. Therefore, the SV is -$100, indicating in cost terms how much the task is behind the baseline plan.

Remarks    If the SV is a positive value, the task is currently ahead of schedule in terms of cost. If the SV is a negative value, the task is currently behind schedule in terms of cost. SV is expressed in currency units, the same units used in the CV (earned value cost variance) field. This makes it easy to plot SV and cost variance (CV) (CV: The difference between the budgeted cost of work performed [BCWP] on a task and the actual cost of work performed [ACWP]. If the CV is positive, the cost is currently under the budgeted amount; if the CV is negative, the task is currently over budget.) on the same graph (graph: A view [such as the Resource Graph] that presents schedule information graphically.).

ShowSV (resource-timephased field)

Entry Type    Calculated (calculated field: A field in which the value is determined by Project based on information in other fields. Project may recalculate the value automatically or when you specify, depending on your choice of calculation settings.)

How Calculated    SV is the difference between BCWP and BCWS. Microsoft Office Project calculates the SV as follows:

SV = BCWP - BCWS

Best Uses    Add the SV field to the timephased portion of the Resource Usage view to determine whether the resource is behind or ahead of its baseline schedule in cost terms. Because Project maintains timephased values for BCWP and BCWS, timephased values for the SV are also available.

Example    Your baseline plan had Sean scheduled to complete 50 hours of work (at $10 per hour) by June 1, and Sean only had 80 percent of the work done by June 1. The BCWP for Sean's assignments (assignment: A specific resource that is assigned to a particular task.) is $400 (80 percent of 500). The BCWS is $500. Therefore, the SV is -$100, indicating in cost terms how much the resource is behind the baseline schedule.

Remarks    If the SV is a positive value, the resource's tasks are currently ahead of schedule in terms of cost. If the SV is a negative value, the resource's tasks are currently behind schedule in terms of cost. SV is expressed in currency units, the same units used in the CV (earned value cost variance) field. This makes it easy to plot SV and cost variance (CV) (CV: The difference between the budgeted cost of work performed [BCWP] on a task and the actual cost of work performed [ACWP]. If the CV is positive, the cost is currently under the budgeted amount; if the CV is negative, the task is currently over budget.) on the same graph (graph: A view [such as the Resource Graph] that presents schedule information graphically.).

ShowSV (assignment-timephased field)

Entry Type    Calculated (calculated field: A field in which the value is determined by Project based on information in other fields. Project may recalculate the value automatically or when you specify, depending on your choice of calculation settings.)

How Calculated    SV is the difference between BCWP and BCWS. Microsoft Office Project calculates the SV as follows:

SV = BCWP - BCWS

Best Uses    Add the SV field to the timephased portion of the Task Usage or Resource Usage view to determine whether the assignment is behind or ahead of the baseline schedule in cost terms. The comparison can indicate whether your tasks are behind or ahead of the baseline plan. Because Project maintains timephased values for BCWP and BCWS, timephased values for the SV are also available.

Example    Your baseline plan had Sean, at $10 per hour, working for eight hours on a task on June 1. Because of schedule changes, this assignment is now scheduled for June 2. When the status date is June 1, the BCWS for Sean's assignment is $80 and the BCWP is $0 because no actual work has been done. Therefore, the SV is -$80, indicating in cost terms that the assignment is behind schedule.

Remarks    If the SV is a positive value, the assignment is currently ahead of the baseline schedule in terms of cost. If the SV is a negative value, the assignment is currently behind the baseline schedule in terms of cost. SV is expressed in currency units, the same units used in the CV (earned value cost variance) field. This makes it easy to plot SV and cost variance (CV) on the same graph.

 
 
Applies to:
Project 2010, Project 2007, Project 2003