Page History

...

Of all of the columns in this file the 5 that are used for project reporting are the following:

• Total Budgeted Cost
• Actual Cost
• Remaining Funds
• Cost Variance
• Schedule Variance
• Earned Value
• Planned Earned Value
• Schedule VarianceCost Variance With Contingency

These are the key outputs from this file and will appear in the tracking file and project dashboard.

...

This is the PA-Number to which the costs associated with this line item should be charged. 

Percentage Complete

This field contains an estimate of how much progress has been made on a given task. This field combined with the Actual Labor Hours Or M&S Cost field is used to determine how far under or over budget a project is.  This field should be updated by the PM regularly as the project progresses. 

Resource Allocation

This field computes the percentage of a resource's time is required to complete the task based upon the number of hours required and the planned duration.

...

The use of this field changed depending on if it is an M&S or Labor task. For an M&S task this is the actual total cost for the M&S item billed tot he account. For Labor this is the actual number of hours that have been spent on a given task. This in combination with the percentage complete is used to determine the how far under or over budget a project is.  This field should be updated regularly by the PM as the project progresses. 

...

Earned Hours

This field contains an estimate of how much progress has been made on a given task. This field combined with the Actual Labor Hours Or M&S Cost field is used to determine how far under or over budget a project is.  This field should be updated by the PM regularly as the project progresses. 

Actual Cost

This is the actual computed cost for a given task or the overall project. 

Remaining Funds

This is the amount of funding remaining for a given task or the overall projectcomputes the earned hours of a given item. 

Earned Value

This field computes the earned value of a given item. For M&S this earned value is the estimated cost of an item if purchased, for Labor this is the Budgeted Labor Cost multiplied by the percentage complete. In a perfect project the Earned Value would match the total cost of the project.

...

This is the planned percent complete based upon the task's start and end date compared to today's datethe last date of the previous month., assuming the task will have linear progress.

...

This is the expected earned value of a task using the planned % complete and the total cost for the task. 

...

This line item is the result of comparing the Actual Cost of each line item with the Earned Value. A positive value in this field means that you earned more value than it costed for a given line item,  indicating a Budget under-run. A negative value is a budget overrun.

Schedule Variance 

This is the computed schedule variance comparing the current earned value with the planned earned value for each task. A positive number indicates you are ahead of schedule.

Contingency

This field contains the applied computed contingency multiplier amount based upon the risk factor assigned to the item.

...

Baseline Start

This field is the result of applying the contingency factor to the Total Budgeted Cost number.

Earned Value With Contingency

This field applies the contingency factor to the earned value field. 

Cost Variance With Contingency

baselined start date of a task.  

Baseline Finish

This is baselined end date of a task. 

Variance

This is the schedule variance between the baseline schedule and the current schedule.This is the same as Budget Variance but computed with contingency applied.