Schedule a Task to Start As Late As Possible Based on the Start Date of Another Task

//Schedule a Task to Start As Late As Possible Based on the Start Date of Another Task

Schedule a Task to Start As Late As Possible Based on the Start Date of Another Task

Problem Description

I answered an interesting question recently in the Microsoft Answers user forum for Microsoft Project users. The user who asked the question stated that she was new to Microsoft Project. She indicated that she is managing a construction project and wanted to know the latest possible date she could order wood flooring so that it is delivered to the construction site just in time for the flooring to be installed.

Her situation with ordering the wood flooring is very similar to ordering the equipment for the Implement task, such as shown in Figure 1. Notice that the Start date of the Implement task is controlled by a series of Predecessor tasks, namely the Design, Build, and Test tasks. To match the situation faced by the user who asked the question in the forum, suppose that the Order Equipment task must start as late as possible and must finish immediately before the Implement task starts. This requirement is based on historical records that show it typically takes 5 days for new equipment to be delivered, once the equipment is ordered.

Figure 1: Order Equipment must start as late as possible

Figure 1: Order Equipment must start as late as possible

Solution

Although there are several possible solutions to this scheduling problem, the easiest way to solve the problem is to set an As Late As Possible (ALAP) constraint on the Order Equipment task. To do this, double-click the Order Equipment task and then click the Advanced tab in the Task Information dialog. Click the Constraint Type pick list and select the As Late As Possible constraint, such as shown in Figure 2. The behavior of this constraint is as the name implies: it schedules the task as late as it possible can, based on the task’s dependency relationships.

Figure 2: Set an ALAP constraint on the task

Figure 2: Set an ALAP constraint on the task

Click the OK button when finished. Notice in Figure 3 that Microsoft Project schedules the Order Equipment task as late as possible, which means that it finishes immediately prior to the start of the Implement task. If the schedule slips on the Design, Build, or Test tasks, causing the Implement task to slip, the Order Equipment task will slip as well. This is the desired scheduling behavior for the Order Equipment task in Microsoft Project.

Figure 3: Order Equipment task scheduled as late as possible

Figure 3: Order Equipment task scheduled as late as possible

By |2019-06-12T14:35:49+00:00June 12th, 2019|Microsoft Project Tips|
Dale Howard, Microsoft Project MVP
Dale Howard is the Director of Education for PROJILITY. He has used Microsoft Project since version 4.0 for Windows 95 and has used the Microsoft PPM tool since the first version was released with the name, Project Central, in the year 2000. He is the co-author of 21 books on Microsoft Project, Project Server, and Project Online. He is currently one of only 28 Microsoft Project MVPs (Most Valuable Professionals) in the entire world and one of only 6 in the United States.

About Projility

PROJILITY is a Microsoft PPM and CRM services leader and product innovator. Our Hammerhead products have helped organizations around the world save hundreds of thousands on Microsoft Project Server training, customization, and support costs.

Contact Us

2 Wisconsin Circle,Suite 700
Chevy Chase, MD 20815
Phone: 703.448.6777
Fax: 703.842.8478
Email: info@projility.com