Microsoft Office Tutorials and References
In Depth Information
Examining task costs
▪ You can quickly display late tasks—tasks that are late in relation to whatever status
date you set. To set a status date, on the Project tab, in the Status group, click Status
Date. Then on the Format tab, in the Bar Styles group, select the Late Tasks check box.
The Gantt bars of tasks that were scheduled to be completed by the status date but
are incomplete are formatted dark gray.
▪ The Slipping Tasks report describes tasks that are off schedule. To view a Slipping
Tasks report, on the Report tab, in the View Reports group, click In Progress and then
▪ If you saved a baseline in your plan, you can show baseline and slippage bars on the
chart portion of a Gantt Chart view. On the Format tab, in the Bar Styles group, click
Baseline or Slippage, and then select the baseline values you want.
▪ In this exercise, you viewed variance for a task. To see variance for assignments
to a task, switch to the Task Usage view and then apply the Variance table (to see
scheduled variance) or the Work table (to see work variance).
Examining task costs
The schedule’s status (determining if tasks start and finish on time), although critical to
nearly all projects, is only one indicator of overall project health. For projects that include
cost information, another critical indicator is cost variance: Are tasks running over or under
budget? Task costs in Project consist of fixed costs applied directly to tasks, resource costs
derived from assignments, or both. When tasks cost more or less than planned to complete,
cost variance is the result. Evaluating cost variance enables you to make incremental budget
adjustments for individual tasks to avoid exceeding your project’s overall budget.
Although tasks and resources (and their costs) are directly related, it’s informative to
evaluate each individually.
The scenario: At Lucerne Publishing, you’ve seen the overall scope of cost variance for the
new children’s book plan. Next you’ll focus on the specific tasks that have incurred the
In this exercise, you view task cost variance. You’ll start by displaying the Cost table.
On the View tab, in the Data group, click Tables and then click Cost .
The Cost table appears in the Task Sheet view.