Microsoft Office Tutorials and References
In Depth Information
Examining resource costs
The scenario: At Lucerne Publishing, expenses in the new children’s book plan are derived,
for the most part, from the costs of resource assignments. You’ve already seen the task
costs, so next you’ll focus on resource cost variance.
In this exercise, you use different tables and sorting options to see resource cost variance.
On the View tab, in the Resource Views group, click Resource Sheet .
The Resource Sheet view appears.
On the View tab, in the Data group, click Tables , and then click Cost .
The Cost table appears.
In the Cost table, you can see each resource’s cost, baseline cost, and related cost
values. In most cases here, the cost values for work resources are derived from each
resource’s cost rate multiplied by the work on their assignments to tasks in the plan.
Currently, the resource sheet is sorted by resource ID. Next, you will sort it by
Click the AutoFilter arrow in the Cost column heading, and in the menu that appears,
click Sort Largest to Smallest .
Project sorts the resources by cost from highest to lowest. Note that the resources
are sorted according to the values in the Cost column, which is the sum of their
actual (or historical) costs, and their remaining (or expected) costs.