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.

MS project for managing resources

6 replies [Last post]
Forum Guest
User offline. Last seen 2 years 24 weeks ago. Offline
Joined: 28 Jan 2009
Posts: 1
Groups: None
Hello,
Have a need to manage multiple resources to multiple projects.
The projects are of different resource usage pattern:
1. Resources are from say common pool
2. There is fixed resources say 3 out of 10 to project1 permanently.
3. Other resources are shared and used across say three projects.
4. One of the project uses resources in both day shift and night shift.
5. Now managing the work load of the resources is key in this case.

Now this is an example of real life situation in managing resoiurces across projects. The resources need to be ordered normally one week ahead from the resource pool. However for emergency services, the resources are allocated based on a duty rouster.

With the above situation , like to have some help / clarifications how we are able to manage the resources.

Please recommend software we could use.
Do you have some tool to share ?
Suggest / provide documents and solution for this if possible.

Thanks

Replies

Tony McClennon
User offline. Last seen 8 weeks 22 hours ago. Offline
Joined: 19 Nov 2002
Posts: 97
Groups: None
One way we overcame the problem of non-project/admin activities was to show the maximum units against the resources at a percentage less than 100% (e.g. 80%).

Each resources availability can either be determined from historical data (timesheets etc), or an agreed allowance for administrative/non project work agreed on by the Resource Managers.
Forum Guest
User offline. Last seen 2 years 24 weeks ago. Offline
Joined: 28 Jan 2009
Posts: 1
Groups: None
In my experience resource allocation is much more of a problem between projects than it is within one project. It also requires that all of the work, not just project work be included in the master file of all workers. I do not think MS Project can handle this in many organizations.

Bob Youker Bethesda Md.
Tony McClennon
User offline. Last seen 8 weeks 22 hours ago. Offline
Joined: 19 Nov 2002
Posts: 97
Groups: None
MS Project will allow the creation of a "resource pool", to which projects may be linked. Below is an extract from MSP help:

"A resource pool allows you to share resources among multiple projects. Using a resource pool allows you to schedule resources work across projects, identify conflicts between assignments in different projects, and see how a resources time is used in multiple projects If you have people or equipment that work on tasks in multiple project files, you may want to use the resource pool to centralize resource information, such as resource name, calendar used, resource units, and cost rate tables, making it easier to administer. Each project that uses resources from the resource pool is called a sharing file. You can use any other existing project file as a resource pool, but it is recommended that you create a new project file just for resource information to make it easiest to manage resource information and task assignments between sharing files and the resource pool."

This has the advantage of only having to create and maintain a single project file, rather than having to update each individual project files resources.

For further MSP Help on the subject, type "share" into the keyword box, then select "All about sharing resources" from the topic list.
Forum Guest
User offline. Last seen 2 years 24 weeks ago. Offline
Joined: 28 Jan 2009
Posts: 1
Groups: None
I have used a product called e-PSO which seems to fit your requirement.

Its a workflow/web based product which can be found at www.e-pso.co.uk or please e-mail me for more information on duck_99uk@yahoo.co.uk

Best regards
Katy
Se de Leon
User offline. Last seen 2 years 33 weeks ago. Offline
Joined: 15 May 2001
Posts: 321
Groups: None
Your basic question is what software would best suit your requirements. I believe you can use both MS Project and Primavera Software to attain your objectives based on the scenarios you’ve enumerated. Answering point by point your queries can be best answered if you already in the process of preparing your schedule.

If you have questions, feel free to email me.
Colin Cropley
User offline. Last seen 5 years 44 weeks ago. Offline
Joined: 1 Feb 2002
Posts: 57
Groups: None
You have posted your request for help in managing resources on an MS Project forum, but you say you would like advice on what software to use.
Two points you make about your multiple projects resourcing lead me to recommend either Primavera Project Planner (P3) or Primavera SureTrak (ST):

1) One of your projects uses resources in both day and night shifts P3 or ST handle up to 31 different base calendars, as well as unlimited resource calendar variants of the base calendars. They can also handle different shift calendars.

2) You are sharing resources across multiple projects.
P3 or ST can handle a group of Projects, called a Project Group, and member projects. These share resources, as well as coding and calendars.

You can plan each project separately, but report and analyse the resource usages overall in the Project group.

The key to managing this is the use of Activity Codes and Activity ID codes, especially the special Sub-Project Code (1st 2 characters of the Activity ID code used to identify which member project the activity belongs to).

In P3 you can code the resources hierarchically so that they can be generic or particular people.

eg, ENG* would capture all resources beginning ENG, while ENGJim could be a particular engineer named Jim. Jim would also be grouped in the wildcard resource ENG*

Hope this helps.