How to Build a Project Schedule in 5 Easy Steps

Congratulations! You've been assigned your first project and your boss wants to see a project schedule at next week's status meeting. Hearing of your new promotion, the PC support team has installed Microsoft Project on your desktop so you're ready to start building a project schedule! Unfortunately, your Introduction to Microsoft Project training class isn't schedule until next month and your boss is expecting a full schedule by next week. Fortunately, if you have a book on Microsoft Project and this article, you'll be able to complete your assigned task.

According to the Project Management Body of Knowledge (PMBOK), there are five key processes to developing a project schedule. PMBOK's Time Management knowledge area explains each of the inputs, tools and techniques and output in detail so you should consult the PMBOK for supplemental information. Knowing that you need to get started with developing a project schedule, let's start with the five key steps.

Step One: Define Activities

The goal of the activity definition step is to identify all the tasks required to accomplish the product. This frequently results in identifying all the work products and deliverables that comprise the project. These deliverables are found as the components of a Work Break Down structure (WBS). The project schedule further decomposes these deliverables into the actual activities required to complete the work.

If the project team doesn't have an established scope statement, WBS, or sufficient scope definition, you may need to host a workshop or two to gather the requirements and further develop the project schedule. Since you need to produce a project schedule by next week, you will likely create tasks in your project schedule for "Analysis" or "Scope Definition". At this point in the project, it is OK to not have all the project details. You can build activities in your project schedule to gather the information. It is perfectly acceptable to build a plan for the analysis of the project before committing to the implementation or delivery phase of the project.

Assume for now you either have a WBS available or have enough information to build a sample set of tasks to further define the scope. Once you have all the activities defined, the next step is the sequence the activities.

Step Two: Sequence Activities

At this point you've entered all the task names and have further decomposed the deliverables listed in the WBS. The next step is to sequence the activities with dependencies. During this step, you'll identify any dependencies of related tasks and document them in the project schedule.   You'll need to analyze each of the tasks to understand which task has a dependency on additional tasks. In your favorite project schedule development book, be sure to read about the different types of dependency relationships include Finish-to-Start and Start-to-Start dependencies. These relationships will impact your task start and finish dates.

Step Three: Estimate Activity Resources

The next step is to identify the resources and their availability to your project. Remember that not all team members will be 100% available to your project as some team members will be working on multiple projects. In this step, you'll also assign resources to each of the tasks.   I usually assign resource to tasks using the standard Gantt Chart view in Microsoft Project. For each task at the lowest point in the WBS, click on the drop down box in the Resource Names column and select the available team member.

I recommend breaking down the tasks so you can assign one task to one resource to avoid adding multiple resources to a given task. It creates a larger project schedule, but it allows me better control in allocating and tracking resources as the project executes.

Step Four: Estimate Activity Durations

With resources assigned, the next step is to estimate each task's duration. The activity's duration is the number of working periods required to complete the task. In Microsoft Project, this can be defined in days, weeks, and even months! It is also important to understand the difference of the different duration types including Fixed Work, Fixed Duration and Fixed Units. Selecting the correct duration type impacts the resource availability and the forecasted task end date.

Step Five: Develop Schedule

The next step is to analyze the project schedule and examine the sequences, durations, resources and inevitable scheduling constraints. The goal of this step is to validate the project schedule correctly models the planned work. In this step you'll not only validate the duration estimates are accurate, but validate the resource allocations are correct.

Resource leveling is a key step in ensuring the project dates are realistic and the resources are appropriately assigned. Microsoft Project has an automatic resource leveling feature but I recommend against using it. Instead of automatic leveling, I recommend using a manual process to resolve resource overallocation. This manual process of resource leveling is time consuming but it results in a better end project with realistic end dates.

Once you've completed the schedule development, you'll be ready for a review with your boss for initial feedback. Once you meet with your boss to review the schedule, obtain his feedback and make the necessary changes. You'll want baseline the project schedule before you move to schedule execution. This will ensure the original dates are saved in Microsoft Project and you can compare the planned versus actual dates as the project progresses.

The next step in the PMBOK is Control the Schedule which will be the topic of a future article! I hope these simple steps have helped you get ready for your upcoming meeting. Good luck on the project!