Tuesday, 15 December 2009

What Are My Project Costs by Resource Type for Next Period? Part 1

I often get asked by Project Managers about ways of extracting project data and this one seems to top the list. This information can easily be obtained via;

  1. Resource Usage View
  2. Visual Report

Let’s review how this can be done using Resource Usage view.

1) Log in to project Professional. Ensure that ‘Load Summary Resource Assignments’ is un-checked if you just want to view individual project data.

EPM2007_ProjectPro_ResUsage_4

2) Open your existing project from the server.

3) Navigate to ‘Resource Usage’ view.

EPM2007_ProjectPro_ResUsage_3

(click picture to enlarge)

4) Select Project Grouping ‘Resource Type’.

EPM2007_ProjectPro_ResUsage_2

(click picture to enlarge)

Note: Collapse assignments, as required, to show summary by Resource Type e.g. Work, Material or Cost. Right-click in the timephased area of the view and add ‘Cost’ field (remove ‘work’ field if not required).

The figure below illustrates an example of the view showing weekly costs split by Resource types > Resources.

EPM2007_ProjectPro_ResUsage_1

(click picture to enlarge)

The above changes can be made in Enterprise Global so that all users can benefit from standardisation. Alternatively, individuals can create their own local view. Refer to earlier post for creating local views.

No comments:

Post a comment

Please include your email address with comments.