Scheduling Problem in MS PROJECT 2013

Hi,

again a question from one of My Blog Readers:

“What if you work 9 hrs per day mon to thurs and 8 hrs per day friday for week 1, and for week 2 you work 9 hrs per day mon to thursday, no work on fri. So week 1 is 44 hrs and week 2 is 36 hrs. I can specify all this in the working calendar, but in the scheduling options, you can only choose a certain no of hrs per day, and a certain no of hrs per week, and this would differ from the working calendar, which would lead to errors. What’s you advice on such a situation?”

Ufffff! Let’s start with MS PROJECT 2013! First of all:

image

then:

image

and:

image

Notice that it is 8 Hours Per Day!

Now I am going to rearrange Standard Calendar:

image

and:

image

I do not have to do anything for Friday/12/13/2013, because it is already scheduled as 8 hour working day.

I’m going to set up second week:

image

Finally I’ll set Friday/12/20/2013 as a non working day:

image

Now, I’ll add Task with 10 days Duration:

image

and I’ll assign John (who works on Standard Calendar) to the Task:

image

After Assigning John To Task 1I’ll get:

image

Now, let’s take a look at the Task Usage View:

image

Let me explain:

Because I said that one day will have 8 hours for working (look at the top of this Post) the Calculation is: This Task 1 needs 10 days of duration * 8 hours per day = 80 hours. So, for completing this Task we will need to work 80 hours on it! Because John will work on Standard Calendar he will work first week from Monday to Thursday 9 hours per day (4*9=36 hours), 8 hours on Friday, which is 36+8=44 hours at First week, and Second week he will work 9 hours per day (from Monday to Thursday, 4*9=36 hours), and he will not work on Friday. Total is: 44 hours at first week + 36 hours at second week = 80 hours.

This is how MS PROJECT works! What will be if I change in Scheduling options that it is 9 hours per day:

image

Back to the Task Usage View:

image

Because I said that one day will have 9 hours for working (look at the top of this Post) the Calculation is: This Task 1 needs 10 days of duration * 9 hours per day = 90 hours. So, for completing this Task we will need to work 90 hours on it! Because John will work on Standard Calendar he will work first week from Monday to Thursday 9 hours per day (4*9=36 hours), 8 hours on Friday, which is 36+8=44 hours at First week, and Second week he will work 9 hours per day (from Monday to Thursday, 4*9=36 hours), and he will not work on Friday. Total is: 44 hours at first week + 36 hours at second week = 80 hours. We need 10 hours more to complete this Task, So John will work 8 hours at Monday and 2 hours at Tuesday at third week.

Be very careful! When you change working hours from 8 to 9, for example, all Tasks will be affected by that.

So that’s it! I hope that this explains MS PROJECT behavior

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 2010, Microsoft Project 2013, Microsoft SharePoint, PMI and tagged , , , , , . Bookmark the permalink.

2 Responses to Scheduling Problem in MS PROJECT 2013

  1. sajjad says:

    Dear Sir,

    I am looking for answer about wrong durations in Ms-Project 2013. I placed the duration for 10 days and get the start and finish date difference equals to 12 days though as per calender it should be 11 days. Kindly advice why it is behaving like this

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