Page History

In the budget file there are two main sections. It is very important that you do not later alter the column order of this file!

The first is M&S / Travel. These are for fixed costs that are not directly associated with a schedule task. They may be indirectly linked to a schedule item such as "Purchase x,y,z". In this section Travel and M&S are in two separate sub-groups. 

...

• Actual Reported Cost Computed Or Real M&S
• Budget Variance
• Budget Variance With Contingency
• Duration Variable From Schedule Variance
• Duration Variable Schedule Variance With Contingency

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

...

This file is an incoming link from the Schedule sheet which contains the planned calendar duration of each task. This field is used in later fields to compute the schedule status of the project.

This column will soon be removed

Planned Duration With Contingency (Days)

This field is the result of applying the contingency factor to the Planned Duration.

This column will soon be removed

Assigned To From Schedule

This is an incoming linked field containing the resource name assigned to each Labor Task in the Schedule File.

We will eventually change this so it is assigned in the budget file.

Percent Complete From Schedule Or Local M&S

...

This is the same as Budget Variance but computed with contingency applied.

...

Planned % Complete From Schedule

This is the linked duration variance value from the budget sheet. This is an indication of how many days you are behind or ahead of schedule. A positive value is an indication of being behind schedule, a negative value is an indication of being ahead of schedule.

...

the planned percent complete based upon the task's start and end date compared to today's date, assuming the task will have linear progress.

Planned Earned Value

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

Planned Earned Value With Contingency

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

Schedule Variance 

This is the computed schedule variance comparing the current earned value with the planned earned value for each task.

Schedule Variance With Contingency

This is the computed duration schedule variance comparing the current earned value with the contingency factor appliedplanned earned value with contingency for each task.

 PA

...

Number

This is the PA-Code Number to which the costs associated with this line item should be charged. This is outwardly linked to the Schedule tasks.

...