Friday, September 11, 2015

Using Microsoft Project Plan to Create an Updatable Project Plan

While most of the Project Managers are well versed with the Project Planning process, many end up being not so efficient at tracking of the Project Plan. In this article I aim to provide a quick guide for the budding Project Managers to be able to make use of the "Auto-Scheduling" and "Baselining" features of Microsoft Project Plan (MPP) to create and track to a plan in an efficient manner.

For the purpose of this article, I will be using MPP 2013. However, the concept will apply equally well to MPP 2010.

Creating an Updatable Plan:
Here I will explain a method that I have followed for years to create plans that are easily updatable at a later stage without too much of manual work. The key here is to avoid constraints that will add in the way of auto-update at a later stage.

Step 1 - Switch on the "Auto Schedule" feature of MPP as shown in the below screenshots




Step 2 - Add a Column for "Work" to the MPP file and call it "Effort"




Step 3 - Set the Project Start Date in the Project Tab -> Project Information -> Start Date field

Step 4 - Add all the tasks along with their subtask hierarchy to the "Task Name" column. This will create the tasks corresponding to each entry as shown below.



Step 5 - Add Effort in hours against each of the leaf tasks under the "Effort" column as shown below. The Efforts under the non-leaf tasks will get calculated automatically.



Step 6 - Add sequencing of the tasks by entering the "Predecessors" column values as shown below.



Step 7 - Enter the Resources who will work on each of the tasks under the "Resource Names" column. At this point, the efforts may change to compensate for extra resource allocation. Change the effort to original one if needed. This will make the resource utilization change. Add all the resources without worrying about the utilization.



Step 8 - Adjust the duration to make resource utilization equal 100%. As you change the duration, effort will change to compensate for it. However, a context menu will provide an option to alternatively change resource allocation (as shown below). Select the option to change resource allocation to 100% and retain the original effort.




At this point the plan is ready with no constraints to it. The trick here was to never have to set the Start and Finish dates manually. Since those dates are auto-scheduled, and subsequent changes in the plan will just readjust those dates, without the project manager needing to revisit and rearrange all the tasks.


Adding a Delay to a task
Let us say that Subtask 3 in the above plan gets delayed by 1 day. In that case, the plan can be readjusted simply by changing the duration of Subtask 3 as shown below.




Delaying the Start of a Task
If, for example, Subtask 3 needs to start 2 days later than the original plan, a delay can be added by adding a leading buffer in the predecessor column as shown below.




Note that in all these cases, the plan remains self-adjusting so that the Project Manager can try out various scenarios to choose the best possible plan.

As always, please feel free to provide your comments and questions. 

15 comments:

  1. Scrum Masters Awesome article, it was exceptionally helpful! I simply began in this and I'm becoming more acquainted with it better! Cheers, keep doing awesome!

    ReplyDelete
  2. You there, this is really good post here. Thanks for taking the time to post such valuable information. Quality content is what always gets the visitors coming. managing projects

    ReplyDelete
  3. I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. Project Initiation

    ReplyDelete
  4. The blog and data is excellent and informative as well Training Geelong

    ReplyDelete
  5. It is extremely nice to see the greatest details presented in an easy and understanding manner. Crisis Prevention Intervention Course Online

    ReplyDelete
  6. We share wholly such definition, hence it follows that financial investments (if it is not followed by real investments as a result) do not increase real material wealth and real nonmaterial wealth. According to this context, the expression below is very important: "we must distinguish financial investments, which represent placement of the funds in the ways of selling and purchasing the securities for the purpose of getting profit and financial investments, which become cash and real, moved to real physical capital." https://finmaxfx.com/en

    ReplyDelete
  7. Your web designer will ask you about this facet of your web site, but it is good to think about this on your own before you take that step. As a rule, the more pages a web site has, the higher the cost. Webdesign

    ReplyDelete
  8. i read a lot of stuff and i found that the way of writing to clearifing that exactly want to say was very good so i am impressed and ilike to come again in future.. scope management

    ReplyDelete
  9. This can be critical, however it can be needed that may help you go onto the idea weblink: [pii_email_8079047078567379049d]

    ReplyDelete
  10. Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our. پروژه ستین

    ReplyDelete
  11. It is truly a well-researched content and excellent wording. I got so engaged in this material that I couldn’t wait reading. I am impressed with your work and skill. Thanks. Spunlace Nonwoven for Wet Wipes

    ReplyDelete
  12. i wish to have some diamond necklace but they are quite expensive,. you can try this out

    ReplyDelete
  13. Showcasing all the positive skill of the marketing process will eventually earn the respect and attention of others looking for such services. go here

    ReplyDelete
  14. 网址导航是一个集合较多网址,并按照一定条件进行分类的一种网址站。网址导航可谓是互联网最早的网站形式之一。把互联网上分散的资源融为有机整体,实现资源的全面共享和有机协作,使人们能够透明地使用资源的整体能力并按需获取信息。88152网址大全是一个简单实用的网址导航网站,也是专业的网站分类目录,免费收录国内外各行各业正规优质的网站。详情请浏览 http://www.88152.com 网址大全

    ReplyDelete
  15. Quality Management Services Arrowsmith Construction and Project Management Limited is a professional construction management team. We have been executing projects of various sizes in the heavy civil and industrial sectors for the past decade throughout British Columbia and Western Canada.

    ReplyDelete

Role of a Risk Facilitator in the Risk Management Process

What is Risk In her very lucid lecture on Risk Management , Dr. Penny Pullan provides a very apt definition of Risk, with an analogy ...