Level Remaining Schedule During Tracking

This is the last of four articles I’ve written recently on the topic of on tracking a project. I have outlined a four-step tracking cycle:  set the status date, enter actuals and revisions, reschedule incomplete work, and level the remaining schedule.

To explore the last step, let’s consider an example. The below schedule was baselined after initial resource leveling. It is 11 days long. Resource R is constrained to two units.

Figure 1: Baselined schedule prior to tracking

The project started as planned on October 4th. The first weekly status was October 8th. Only two days were spent on Task A. Task B was completed, but Task D was not started. Hence dependent Task F was not started. Incomplete work was rescheduled to start after the status date, resulting in a split of Task A and a Schedule No Earlier Than (SNET) constraint being placed on Task D and Task F.

Entering actuals and rescheduling incomplete work created resource overallocations in the remaining schedule. The underutilization of resource R in the first week caused the shifting of four days of work into the remaining schedule.

Figure 2: Remaining schedule with resource over allocations

In the Leveling Options dialog, the schedule is leveled from the Status Date through the end of the schedule. You do not want to level the entire schedule since this potentially would overwrite portions of the actual schedule from the beginning of the project. Note that the “To:” date may need to be extended to cover the potential expansion of the schedule during leveling.

If we choose to clear the prior leveling in the remaining schedule (by checking the Clear leveling values before leveling box), the leveling yields a 14-day schedule. During the day-by-day leveling starting after October 8th, Task E is critical on October 15th and that is why it is scheduled before Task F.

Figure 3: Leveling Options dialog with Clear Leveling Values before leveling box checked

Figure 4: Leveled remaining schedule, with Task E scheduled before Task F

If we choose to not clear the prior leveling within the remaining schedule (unchecking the box), we get a different 14-day leveling of the remaining schedule. With the prior leveling not cleared, Task F is critical on October 15th and is scheduled before Task E.

Figure 5: Leveling Options dialog with Clear leveling values before leveling box unchecked

Figure 6: Leveling remaining schedule, with Task F scheduled before Task E

Just as one may want to explore different leveling options prior to creating the baseline schedule, one should explore different leveling options for the remaining schedule. Project shows you only one leveling solution at a time based on the options you select. The one you are looking at may not be the best. As discussed in my prior MPUG postings on the subject, there is a distribution of leveling solutions. In this example, there was no difference in the project duration of the leveling’s. That will not always be the case.

Avatar photo
Written by Robin Nicklas
Robin Nicklas is a project management consultant and educator. Since 2001, he has trained project managers in the aerospace, financial, telecommunications, government, and software sectors. Prior to teaching, he spent twenty years in information systems and technology, twelve of which he managed software development at large information service companies. Since 2003, he has taught graduate and undergraduate courses in project management at the University of Washington in Seattle, as well as MS Project courses at Bellevue College Continuing Education since 2011. Robin is a former president of the PMI Puget Sound Chapter in Seattle and a certified PMP. He can be contacted through his website, robinnicklas.com.
Share This Post
  1. You say, “You do not want to level the entire schedule since this potentially would overwrite portions of the actual schedule from the beginning of the project.”
    Leveling cannot delay a task which is complete and is marked as 100% complete, and leveling will not delay any task which has an actual start date.
    So provided all complete tasks are to the left of the status date, there is no need to specify the leveling start date as being from the status date.

    • Avatar photo


      Your statements are correct. If a task has been recorded as 100% complete, it is not affected by leveling. If a task has an actual start date, it will not be delayed by leveling. In other words, actuals are not affected by leveling.

      The point I would like to convey is that we should be leveling incomplete work that is in front of us, rather than behind us, relative to the status date. In the third article of this series, I recommend rescheduling incomplete work to occur after the status state. If that third step has been done correctly, then it shouldn’t matter if we level the entire project or just the remaining project in the fourth step.

Leave a Reply