Fixed duration Tasks and over allocation resolution in MS PROJECT 2016

Hi,

I have interesting question form one of my Blog Readers:

“I have below query in Fixed Duration Task.
Step1: created a task “paint the wall” with duration as 10 days (work starts by a Monday). Task is fixed duration
Step2: created a resource “A” (100%) – (8hrs/day)
Step3: assigned this resource in this task.
Step4: In task usage, changed the timelines middle tier->months, bottom tier->weeks
Step5: in task usage, entered actual work = 20hr in that task. It gave an warning message. Skipped.
Now it shows 1st week, Resource works 20hrs, and over allocated in next week with 60hrs.
Now, my query is, if i add another resource “B”, i expect that this extra 20hrs in 2nd week should be assigned to this resource “B”.`
I would like the MS project to calculate by itself and assign 40hrs for resource A and 20hrs to resource B.
Please guide on how to achieve this?”

I will show you how to do that in MS PROJECT 2016! I will follow steps from the question.

Step1: created a task “paint the wall” with duration as 10 days (work starts by a Monday). Task is fixed duration

image

As you can see, I make this Task Effort Driven, because I will have to split work between Resources.

Step2: created a resource “A” (100%) – (8hrs/day)

image

As you can see, I have another resource, Resource B, because I will need it for latter steps.

Step3: assigned this resource in this task.

image

Step4: In task usage, changed the timelines middle tier->months, bottom tier->weeks

image

and:

image

Step5: in task usage, entered actual work = 20hr in that task. It gave an warning message. Skipped

image

Now it shows 1st week, Resource works 20hrs, and over allocated in next week with 60hrs.
Now, my query is, if i add another resource “B”, i expect that this extra 20hrs in 2nd week should be assigned to this resource “B”.`
I would like the MS project to calculate by itself and assign 40hrs for resource A and 20hrs to resource B

I will assign Resource B on the Task:

image

I will get:

image

As you can see, remaining work among those Resources is divided in 60/40 (36 hours for Resource A, and 24 hours for Resource B). So, Resource A is not over allocated any more, but it is not what we want. We want that Resource A should work 40 hour, and Resource B 20 hours for Task. So I will have to put those hours manually:

image

and I’ve got what I wanted.

So, no, this is not going to happens automatically,  you should do it manually.

Hope this helps.

Regards!

Advertisements

About Nenad Trajkovski

Location: Zagreb, Croatia Occupation: Project Manager Interests: Project Management and MS PROJECT He was born in Zagreb, Croatia at 1963. After completing his college he started working on projects in different business areas (banking, manufacturing, automotive industry, distribution, oil companies, etc.) developing and implementing ERP systems into different companies. He has got a lot of experience working with people in different business processes and also possesses great knowledge in information technologies and financial services. Today he works as a business consultant, adn Project Manager in PERPETUUM MOBILE d.o.o. Zagreb. He is a regular lecturer for Project Management in MS Innovation Center in Varaždin, Logosoft Sarajevo in Bosnia and Herzegovina and SEAVUS GROUP in Skopje Macedonia. He was named the best lecturer of WINDAYS 2008 while his lecture was also voted as the best. In addition, he was in TOP 10 lecturers at the MS SINERGY 2009 and MS VISIA 2009, 2010. Shares first place as the best lecturer of KulenDays 2009 and 2010 and PMI Conference 2009 in Zagreb. He is also a regular lecturer in the MS Community. He is a Certified Accountant and a PMP (Project Manager Professional) and a PMI-RMP (Risk Manager Professional), MCP, MCT, and Microsoft Certified Technical Specialist - Microsoft Project 2010. From 01.01.2012 awarded with MVP (Microsoft Most Valuable Proffesional - Microsoft Project)!
This entry was posted in MICROSOFT PROJECT, Micsrosoft Project 2016, MS PROJECT 2016, PMI, PRoject Management and tagged , , , . Bookmark the permalink.

2 Responses to Fixed duration Tasks and over allocation resolution in MS PROJECT 2016

  1. vmkpmk says:

    Great explanation.. Thank you so much..

    Dear Ninad
    I have below query now, on msproject.

    I have 2 resource initially planned to work for 160hrs (fixed work) for 2 weeks (duration=10 days, 8hrs work/day) to complete a task (fixed work).

    Unfortunately, Due to some personal reason, 1st resource could work only for 15hrs in 1st week instead of 40hrs/week. Hence setting actual hrs=15hrs in week1 for 1st resource.
    Due to this 25hr work left out, onboarded 1 more resource from 2nd week to complete this 25hr remaining work.
    How to achieve this in msproject?

    I am expecting below result.. (below also gives 160hrs fixed work)

    For week1, A holds 15hrs, B holds 40hrs, C holds 0hr (As C starts only 2nd week)
    For week2, A should hold same 40hr, B should hold same 40hr, C must hold 25hr

    Please advice.

  2. Sundar says:

    Long Live, Ninad T — Great Blog. Excellent explanation.. I love this SITE – Bookmarked.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s