Levelling: Work Distribution based on Resource Capacity and Project Priorities. RRS feed

  • Question

  • Hi team,

    I have inherited about 25 projects and 15 resources spread across these projects. We use project server 2010 to manage projects....we launch any lest a new project each month. We run Weekely modelling.Having a nightmare managing shared resources. Hoping that I can get some of my questions answered here and bring back some semblance of here goes my first question.....

    lets assume I have two resources;

    resource1 whose allocation for project activities is 75%. His capacity in resource center view in pwa is 6 hours and resource 2 who has 8 hours capacity per day.

    let us assume there is a 28 hour, fixed work  task on which both the resources are assigned.

    let us assume that this task can start on jan1st -

    scenario1: both the resources are working on only 1 project.

    is the project server smart enough to assign 12 hours to resource1 and 16 hours to resource2, so that both of them finish at same time?

    scenario2: a higher priority project gets introduced in the portfolio because of which resource1 will not be available till 2nd Jan to Start work.

    is the tool smart enough to assign more work to resource2 to ensure that both of them finish the task on project1 same time?

    Thanks in advance...


    Sunday, June 22, 2014 7:39 AM

All replies

  • If you assign a single person to a Fixed Work task they will work on it for as long as it takes at their default Maximum Units.

    If you add a second person the task will take less time and the work will be apportioned based upon both resources maximum units.

    If you specify the work on the task before assigning the first resource (add the work column to a tabular view and enter a value in the work cell for a task) Microsoft Project will behave as you are looking for in your question.

    For example I create a new Fixed Work task and it shows with 1d? duration - I enter 28 hours work in the work cell - the task still shows 1d? duration. I assign a person to the task who works to the same base calendar as the project but who has maximum units of 75% defined and can therefore work 6 ours per day.

    I assign them to the task and the duration changes to 4.67 days - this is how long it will take someone who works 6 hours per day to complete 28 hours work. Technically speaking the duration is 4.6666 recurring days but project only shows 2 decimal places.

    If I know assign an additional resource to the same task and that person works 8 hours per day as their maximum units are 100% the duration will reduce to 2 days and the work will be apportioned 12/16 to the two resources.

    So the tool is smart enough to behave in the way you are expecting in Scenario 1.

    It will not however make decisions for you to address Scenario 2 unless you engage in "Multi-Project Resource Levelling" if you do this and your Projects do have different priority values then Resource Levelling will deploy resource to the more important project first in cases where a resource has conflicting assignments across projects in the same window of time.

    Dominic Moss MAPM Microsoft Certified Technology Specialist Wellingtone Ltd - Your Project Management Partner - Certified Microsoft Partner Specialising in EPM/PPM - Corporate Members of the Association for Project Management [APM] - Members of the Recruitment Employment Confederation [REC]

    Wellingtone Project Server Services

    Wellingtone Project Management Recruitment

    Wellingtone PM News Subscribe to The Wellingtone Project Management Newsletter Join the thousands of project management professionals who receive practical, straight forward advice, templates, tips and expert articles every month.

    <o:p> </o:p>

    Tuesday, June 24, 2014 1:32 PM