How-To Guides

New Projects Impact Analysis & Leveling Workload

Over the course of normal business, projects need to be properly re-evaluated for appropriate reprioritization. Often, at executive management directive, managers need to address an incoming high priority project request drop into the mix of pre-existing projects. This guide addresses how to:

  1. Assess the impact of a new project on the existing resource workload,
  2. Identify under-utilized or free resources,
  3. Replace resources on tasks,
  4. Shift out certain tasks to level out the workload,
  5. If needed, shift out a low priority project completely to a later date.

Note: Celoxis does not provide priority-based scheduling or automatic resource leveling.

Assessing Impact of New Project on Existing Workload

  1. Create a new project state, say Requests (Administration > Project Management > Project States). Keep this new state in “Planning” stage and disallow time. This helps keeping the new project requests separate from the regular projects.
  2. Create a project for your new project request and keep it in “Requests” state (Add > Project > New Project). Enter the planned start date for this project.
  3. From the project’s Interactive Gantt tab, define the WBS and resources. Since the project is in “Requests” state, it will not affect your existing workload.
  4. Access the Resource Load (View > Resource Load). By default, this view will show you pre-existing planned and active projects.

  5. Edit Filters and Add “Requests” to the Project State Filter. Click on Apply. Now, your resource load view will immediately show you the impact that any new project requests will have on the existing mix and workload.

    Because of the new project request, the impact on the existing workload is high and a lot of resources are overallocated.

  6. You can download this view (Select “PDF” option from the top right button group) and send this to your executives to show the direct impact of the new requests on the existing mix of projects.

Identify Under-utilized or Free Resources

From the same Resource Load View, you can easily identify the under-utilized or free resources. These are the resources that are color-coded as blue. The color-coding helps visually identify free resources without looking at each cell.

Replace Resources on Tasks

You can directly replace resources on problematic tasks (Mouseover the task in contention, and select the 3-line menu > Edit Resources)

In the example below, you can Edit the “Survey commercial spaces” task and reassign it to Tanya who is relatively free in that period.


Shift out Tasks

There could be situations where free resources are not readily available. In such cases, you may need to shift out certain tasks that are of low priority and can be easily shifted out. To do this,

  1. Mouse over the appropriate task.
  2. Click on the 3-line menu.
  3. Select Edit Task. Here you can change the task’s start date to a later one.


Shift out Low Priority Projects

If you still have a resourcing issue, change the start date of the other low priority projects so that all other tasks in those projects are rescheduled. To do this,

  1. Click on the project to open it in a new tab.
  2. In the new tab, click on Edit (from the top right button group)
  3. From the Edit Project pop up, change its Start Date. This will automatically shift all tasks (except any manually scheduled tasks) in perspective to the new start date.


For queries or clarifications, please contact [email protected]

Was this article helpful?
1 out of 1 found this helpful
Return to top