Do’s and Don’ts: Use a Simple Program Simulation for Initial Assessment

A “Master” project is great for modeling a program but takes time to create and refine. (If you do not know about this capability see my other article, “Do’s and Don’ts: Creating Subprojects”)

If you are pressed for time and just want a high level initial assessment of resources, work and cost across all the projects, consider a simple program simulation! Here is one technique to create one:

1. In the Gantt Chart: Enter the basic project descriptions and expected durations on one line each. Each line then represents a project. Use Manually Scheduled tasks so no constraints are placed on the model. Overlap and concurrence between projects is ok. Show the Project Summary Task so you can capture and roll up data from the projects.

The figure below shows the model’s projects as well as resources assigned.

Do’s and Don’ts: Use a Simple Program Simulation for Initial Assessment

2. In the Resource Sheet: Enter as resources the skill sets required for the projects. Include cost if possible. Enter the total number of each resource skill to be assigned to projects in the Max Units field. If part time, enter the percentage. In the example below I used 1 person, full time for each skill. The Max Units are therefore 1 or 100%.

Do’s and Don’ts: Use a Simple Program Simulation for Initial Assessment

3. Assign the resources to their respective projects: Max Units represent the number of resources you have for assignment. Insert the Peak Units field next to the Max Units field.


Want more Do’s and Don’ts? Check out Sam’s new book: Microsoft® Project Do’s and Don’ts!


4. Analyze the results: Bear in mind that these are not fully developed project plans, just an initial assessment. The Peak Units field will tell you the number of resources required to meet the project schedule represented in the Gantt Chart.

Below is the Resource Usage View formatted to show only Peak Units over the project duration. Notice that the time periods requiring more than the Max Units are formatted in red.

Do’s and Don’ts: Use a Simple Program Simulation for Initial Assessment

Do you have the number of resources required on staff? Look at the Cost Tables or Project Statistics. Can you afford these projects?

If the answers to these very basic questions are favorable, you might wish to invest in the creation of a  “Master” project to develop a more detailed and refined plan. If they are unfavorable or questionable – you didn’t waste a lot of time and money to find that out!

Written by Sam Huffman
Sam Huffman first gained insight into Microsoft Project while working as a member of the MS Project development and support team. He has maintained his depth of knowledge of MS Project with each release and is a leading authority in the use and features of MS Project, Project Server and Project Online. Since the early 1990's Sam has honed his instruction skills by delivering training programs to thousands every year. Sam is a frequent content contributor to the Microsoft Project User Group (MPUG) and speaks to groups often about MS Project, Enterprise Project Management and the discipline of Project Management. He was awarded Microsoft Most Valuable Professional from 2010-2017. Check out his blog on MS Project. The softcover version of my newest book Microsoft® Project Do’s and Don’ts is now available for purchase! It is portable, brief and to the point so you can find help when you need it. Through tips, best practices and examples it will help you jumpstart your project!
Share This Post
Have your say!
00

Leave a Reply