Staff Resource Planning Using MS Project

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 

E
Evgeny Z. 👤 Member for 18 years 6 months

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

M
Mike Fenton 👤 Member for 15 years 3 months

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.

R
Ron Beechey 👤 Member for 24 years 1 month

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

Featured Partner

Top Posters

Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts