How to show Resource overallocation within one day in MS PROJECT 2016?

 

Hi,

I have a question from one of my Blog Readers:

“Hi,
I have the following issue … I have a resource with an 8-hour working day. I assign him a task starting 9:00 am with a duration of 3 hours. I also assign him a task starting 10:00 am with duration 1 hour. Project does not flag it as an overallocation, I guess it’s because it does not go beyond the 8 hour restriction for a working day. But there is a conflict with the tasks since both have to be performed by the same resource at the same time. Is there a way to have Project indicate this conflict?
Thank you”

Well, here we are talking about showing overallocation within one day. I’ll show you that with MS PROJECT 2016!

First I will create a simple Project with two Tasks:

  • First Task with Duration 3 hours – starting at 09:00
  • Second Task with Duration 1 hour – starting at 10:00

image

Now I‘m going to create John, as Resource with 100% availability for this Project:

 image

Now, let’s say that John will work on both Tasks:

image

John is available supposed to work 8 hours per day, and since he will work 3 hours for First Task, and 1 hour for Second Task, he is not overallocated. Or is he? He is not overallocated in one day (he will not work more than eight hours per day), but what about during the day?

I will change Timescale on the Gantt Chart:

image

and:

image

image

and I will get:

image

As you can see, John IS overallocated between 10:00 and 11:00 but, it is not show on the screen. How to get that. Follow this step:

image

and you will get:

image

John is now marked as overallocated.

If Leveling option is set Day by Day then John will be marked as overallocated only if he is supposed to work more than 8 hours (in my example) per day, no matter if he is supposed to work on two or more Tasks at the same time during the day. But if this is set to Hour by Hour it means that John will be overallocated when he has to work during the day at the same time to two ore more Tasks.

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.

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