Fixed Work and Manually scheduled Tasks in Microsoft Project 2016

Hi,

I’ve got a question from one of my Blog Readers: “Dear Nenad, I have a problem with Fixed Work Task Type in MS PROJECT. When I add resource to a Fixed Work Task Type, and Task is Manually Scheduled, I get a wrong result! Is this a Bug, or what?”

No, this is not a Bug. I will show you how does it work in MS PROJECT 2016!

First I am going to create two Tasks, and both of them will be Fixed Work.

 image

and then:

image

and I will get:

image

Now I am going to make them as a Fixed Work Type (I will show you how to do it in Task 1):

image

I will create two Resources:

image

Now I am going to assign John to Task 1, and Task 2, as well:

image

John is overallocated, but this is not important for this scenario. Now I am going to change Task 2 to Manually Scheduled mode:

image

I will now assign Mary to Task 1:

image

and I will get:

image

As you can see, 24 hours work from John is split among John and Mary equally, because they are both 100% assigned for the Task. Since John and Mary are going to work 12 hours each, Duration is now shorter, and it is 1,5 days instead of previous 3 days.

I will do the same thing (assign Mary) to Task 2, which is manually scheduled Task, and I will get:

image

It seems like a bug because work is not split among Mary and John, and it acts like this Task is not effort driven. But this is not a bug. When you are using Manually Scheduled Tasks, you can not choose (it is dimmed) Task Type. Why? Because formula DURATION * UNITS = WORK doesn’t work, because Duration field in Manually Scheduled mode is not numeric, but it is text type in this case. I will show you that. I am going to change Duration field from 3 Days to BLABLABLA:

image

To conclude, Task Type make sense with Auto Scheduled Tasks, because in that case Duration field is numeric, and magic formula (DURATION * UNITS = WORK) can work. And, logically, choosing Task Type is only valuable when you let Project to make calculation for you, and that is only possible with Auto Scheduled Tasks.

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, Microsoft Project 2013, Micsrosoft Project 2016 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