Analyze staffing profiles associated with projects

Staffing profiles that are associated with projects can be compared with those projects to see how well they match up in terms of resource allocation and actual workload.

Automatic tracking of actuals for staffing profiles

If a staffing profile is associated with a project, you can set it to roll up values for Actual Effort directly from the work plan. This is controlled through the project settings, in the Cost and Effort policy. For details, see Cost and effort policy.

Note: A staffing profile can only be associated with one project, and one project can only have one staffing profile.

Roll up actual effort values from a work plan

The roll-up of Actual Effort values from a work plan works as follows:

  • Actual FTE values are calculated from the Actual Effort tracked on the work plan's tasks. The actual effort values appear only on the Compare to Work Plan page.

  • The Compare to Work Plan page shows the scheduled and actual effort from the project's work plan, grouped by resource or role.

  • When viewing the Compare to Work Plan page grouped by resource, if a resource is not yet assigned to a task, the roll-up of scheduled effort appears in the unassigned collection.

  • When viewing the Compare to Work Plan page by role, the scheduled and actual effort appears under the role specified on the task.

  • Actual effort includes promised allocations.

    Note: A staffing profile for a project must be created from that project's Project Overview page.

To set staffing profile to track actuals for a project:

  1. Log on to PPM.

  2. From the menu bar, select Search > Projects and open the target project.

  3. Click Settings and click the Cost and Effort policy.

    Note: The Cost and Effort policy may not be editable. If not, you cannot modify the project's Cost and Effort settings unless you modify the project type that governs the project. See Create and configure project types for details on how project types govern project settings through project policies.

  4. Select Staffing Profile represents the work load imposed by the project.

  5. Select Use actual information from the work plan and Time Management when viewing actuals in the staffing profile.

  6. Click Save.

Back to top

Automatic tracking of actuals with Time Management

A staffing profile linked to a project can roll up even more accurate Actual Effort data if Time Management has been enabled and is properly set for the project. For more details on Time Management, see Time Management.

The Cost and Effort policy in the project's settings determines whether financial data is tracked for a project, and how actuals are calculated. The Cost and Effort policy also determines how Time Management is used to track effort, if Time Management has been enabled for the system.

Once Time Management is activated for the project, the Actual Effort values provided roll up into the staffing profile, assuming the staffing profile is set properly. For details, see Automatic tracking of actuals for staffing profiles.

To set Time Management to track Actual Effort for a project:

  1. Log on to PPM.

  2. From the menu bar, select Search > Projects and open the project you want.

  3. Click Settings and click on the Cost and Effort policy.

    Note: The Cost and Effort policy may not be editable. If not, you cannot modify the project's Cost and Effort settings unless you modify the project type that governs the project. See Create and configure project types for details on how project types govern project settings through project policies.

  4. Select Use Time Management to track actual effort against this project.

  5. Select the appropriate level of the work plan to track.

  6. Click Save.

Back to top

Compare a project's assignments to its staffing profile

The Compare to Work Plan page compares capacity (as the active staffing profiles for a project) to assignments within the associated project's work plan, viewable by role or by resource. It can be used to monitor compliance of the work plan and actuals to organizationally agreed-upon staffing levels for the project. To open the Compare to Work Plan page, click Compare to Work Plan on the Staffing Profile page.

The data in the Compare to Work Plan page can also be exported to a Microsoft Excel file for use in presentations or for further analysis. To export the Compare to Work Plan page to a Microsoft Excel file, click the Export to Excel link.

Note: If you have problems with the data in Excel, you may need to configure the Internet options of your Web browser. See Project Management for more information.

Back to top

See also: