Businessman Stepping on Banana Peel

When Things do not go as Planned (in MS Project)

“A plan never survives contact with the enemy.”  If you are using Microsoft Project and things do not go as planned, your project has “issues”.  :) You can track these issues as tasks in the project schedule.  This allows you to easily capture the impact on schedule and costs.  This is also useful to explain the reasons for variance from the plan in a way that can be quantified.  It can also be used during the lessons learned session after the project or phase is completed discuss with the team how they could have been avoided or predicted better.  This would then lead to better planning in the future.

An issue is a problem that prevents a task from being done.  It may be related to a risk that was previously identified or it may be completely unexpected.  These come up all the time in projects, especially IT projects.  They are typically tracked in an issues log.  In the issues log the problem is stated and an action item to resolve it is described along with a due date.  The task being affected should be indicated, but often isn’t.  Each action taken to resolve it is logged until the issue is resolved.  The task being affected can then be finished unless there is another issue that prevents it (an all too common occurrence).  This usually results in schedule slippage and perhaps additional cost, which is often not captured in the issues log.

How do you do this in MS Project?  When an issue is identified, a task would be added to the project schedule.  The task description would identify it as an issue with a brief title and perhaps an identifying number from the issue log.  This issue task would then be linked to the task that can be completed using a finish-to-start or a finish-to-finish dependency.  The start date would be the date it was identified.  When is the finish date?  It depends on whether the resolution is known at the time it is identified.  If it is, you can make the finish date be the date it will be resolved.   Here is an example using the Example MS Office Project 2007 template for Security Infrastructure Improvement Plan from Microsoft Office:

MS Project example of Issue as a task 1

The pricing information needed for task 29 is not available because the contact person is not available until next week.  For this example, we are assuming that the contact person is irreplaceable for that week.  You will notice that this change has caused both the issue and the task that it is linked to become critical (red) and will delay the entire project by 3 working days.

Sometimes the resolution is not known right away. There is always a next action however.  In this case create another task as a subtask of the issue.  The start date would be the same as the issue start date, and the finish date is the due date of this action item.  If this action does not resolve the issue, it is marked as complete and the next action is added as a subtask of the issue with a finish-to-start link to the previous action item.  This continues until the issue is resolved.  The advantage of this is that you can show progress toward resolution as completed action items (tasks in MS Project) and capture the impact of each action and the entire issue accurately.  Continuing with the previous example:

MS Project Issue Task exmaple 2

Here task 43, “Solution Implementation” cannot be completed because a software module was discovered on some of the client workstations that is incompatible with the solution being implemented.  Not all client workstations are affected however so the team decided to implement the solution on those while finding a solution for the ones affected.  We have put a finish-to-finish dependency between the issue and the task affected with a lag of 3 days because the team has determined that they can implement the solution on the affected machines about 3 days after a solution to the incompatibility is implemented.  The critical path is not affected yet.

After a week of analyzing the problem, the team has found that an upgrade of the client software to version 1.2.2 will solve the problem.  It will take a week to upgrade these so we add another subtask to the issue for this.

MS Project Issue Task example 3

Now the critical path has been affected and caused a delay of 2 more working days to the project schedule.  This is why the Gantt bar for this task is now red.  It also shows that the solution implementation is 50% complete in spite of the issue, because we continued working on the unaffected workstations.

If progress is reported weekly, this will show that analysis of the problem was completed and what the impact of the problem is to the plan overall.  You can also track labor and perhaps software license costs to the issue to know the cost impact of the problem.  If root cause analysis is done, this information can be used to determine what corrective action is worthwhile.

This is just one example of how tracking issues as tasks in MS Project can help you and those you report to make better decisions.

IT Project Manager

What Does it Take to be an IT Project Manager?

There has been a lot of debate on LinkedIn.com about what an Information Technology (IT) Project Manager (PM) is supposed to do.   It is fascinating because there are so many different views on this.  It is up to almost 900 posts at the time of this writing!  There has been around 400 unique contributors to this discussion, so it has really brought everyone out of the woodwork.

What are the duties of an IT Project Manager?  What qualifications are needed?  Can a non-IT PM manage IT projects?  There is a wide variety of responses as you might expect.  Here is the spectrum:

  • IT PM must be the technical expert with some experience on projects
  • IT PM must have been a technical expert once and has been trained as a PM
  • IT PM must be familiar with the technical area, have technical experts on team, and experience as PM
  • IT PM must have some experience in IT,  have technical experts on the team, and experience as PM
  • IT PM should have some experience in IT,  have technical experts on the team, and experience as PM
  • IT PM must be experienced in PM  with technical lead on the team.  Exposure to IT would be helpful.
  • IT PM must be experienced in PM. No other qualifications needed.

I wrote about whether a project manager has to have technical skills a while back, not knowing how widespread this controversy was.  Which one is correct?  It depends on where you work.

Why such a diversity of opinion about this?  Hasn’t the Project Management Institute (PMI) laid to rest what a project manager is supposed to do?  The problem with any standard is that the broader it is, the less specific it becomes.  The PMI’s A Guide to the Project Management Body Of Knowledge (PMBOK) is very broad when it describes project management.  The position of project manager has come about in many organizations without PMI’s input.  Project management itself is thousands of years old(e.g. the Great Pyramids).  The rush to get Project Management Professional (PMP) certified seems to have happened mostly in the last decade.  The result is that project management has grown up differently in different industries and organizations.  PMI’s standards are compiled from common practices across these industries.

What do project managers do in your organization that is not described in the PMBOK?  Do they write code?  Do they troubleshoot technical issues?  Do they design a technical solution?  What about people issues?  Do they mediate conflicts between team members?  Do they investigate why a team member isn’t performing well?  Do they do any team building activities?  Please leave a comment here!