Can Project calculate the number of people (resources) required to execute?

D
Dale Favero 👤 Member for 13 years 9 months

I am using Project to plan execution time lines for maintenance.  I deal with a large workforce that has many special quals.  To that end I have my resource sheet set up showing all of these skills.  To accomplish this work takes numerous mechanics with this special skill.  I have been assigning that resource (special skill) and then tagging it with a 200%, 300% or whatever as appropriate to show the number of mechanics needed to make the team. 

Is there a better way?  I really need the ability to make task break downs without knowing who the work team is.  I need the software to help me track how many and what flavor of mechanics I need on any given week.

Thanks in Advance

Dale

R
Ron Beechey 👤 Member for 23 years 11 months

Hi Dale

First I would change the 100% to 1 as we are talking a resource of which it is hard to cut in half.   Since most tasks are duration driven.  anyway you can change this in the project options to Decimal.   Then for a task that needs 4 special welders you only need to indicate 4.   If you are doing your maintenance work like ours then you would have only a single resource per task.   It takes a little more time but makes a better schedule for each trade as you can filter for each and they have their own.   Also as Alexandre points out you can also take the task to the person but if there is a large number of resources as well as tasks  this may be hard to do.

There are a number of different views like the resource usage view were the total number of resources special can be viewed.   If need you can always copy and paste into excel and do some manpower graphs

R
Ron Beechey 👤 Member for 23 years 11 months

Hi Dale

First I would change the 100% to 1 as we are talking a resource of which it is hard to cut in half.   Since most tasks are duration driven.  anyway you can change this in the project options to Decimal.   Then for a task that needs 4 special welders you only need to indicate 4.   If you are doing your maintenance work like ours then you would have only a single resource per task.   It takes a little more time but makes a better schedule for each trade as you can filter for each and they have their own.   Also as Alexandre points out you can also take the task to the person but if there is a large number of resources as well as tasks  this may be hard to do.

There are a number of different views like the resource usage view were the total number of resources special can be viewed.   If need you can always copy and paste into excel and do some manpower graphs

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

Hi Dale,

you are on the right track

you could do even better: double-click the resource name in the resource sheet, and change the time-distributed availability of the resource to fit with the amount of work the resource will have to achieve

Alexandre

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts