Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Staff Resource Planning Using MS Project

3 replies [Last post]
Joseph McCluskey
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 29 Jun 2012
Posts: 5
Groups: None

Hi All,

I have been tasked with creating a site staff resource programme by my employer.

I am relatively new to planning and am hoping someone could provide me with suggestions on how to efficiently create a programme for staff resources using MS Project.

The objective of the programme is to view working time against non productive time to assign excess capacity to jobs.

Any assistance would be greatly appreciated.

Thanks

Joe 

Replies

Evgeny Z.
User offline. Last seen 42 weeks 3 days ago. Offline
Joined: 13 Jan 2008
Posts: 442
Groups: None

Unless I am missing something in your question, this is the standard MS Project functionality.

Create resources in View=>Resources

Create tasks (schedule) is Gantt diagram view

Assign resources to tasks.

To see resource utilisation go View=> Resource usage

Mike Fenton
User offline. Last seen 7 years 30 weeks ago. Offline
Joined: 25 Apr 2011
Posts: 10
Groups: None

Hi Joseph,

One way would be to list each member of the staff and then simply indent the jobs/work as single activities under each staff member. You then assign the staff member as a resource to each of the activities under them and then it's a simple case of moving the gantt bars around until you are happy with the amount of work that staff member has. To view each resources work load, go to the resource graph view. A clever way to view all the resources in the resource graph is to create an activity in your schedule seperate from the rest of your working activities with all the resources assigned to it, but with say a few minutes work for each resource. To view all the resources you can then click on this activity and then scroll through all the resources in the resource graph view. Without this you will need to click on an activity with a resource assigned individually. This can get frustrating if you want to quickly compare staff member workloads to see over and under allocation. There are many other ways to do staff planning, but this way is a simple solution to get you going.

Ron Beechey
User offline. Last seen 5 years 11 weeks ago. Offline
Joined: 13 Jun 2002
Posts: 61

Does you staff work on single tasks or projects with multible tasks  All of this would effect how you would start the schedule.   If your looking for lag time or free time that you can assign more work to that individual how will you get the estimated time for the tasks   lots to think about before you same that a single person has slack time available