Fixed cost for resource over the time period in MS PROJECT 2016

Hi,

I’ve got a question from one of my Blog readers:

“Mr. Nenad, I have a question please:
Let’s suppose that I have a human work resource assigned to different tasks within the project. It receive each month a fixed salary of 4000 dollars even if it has free days (without task assigned) during the month. How can I do that in MS Project ? If I create a work resource with a standard rate of 4000$/Month then I will not be able to solve the problem since MS Project will reduce this monthly salary to an hourly rate and the cost of the resource will be proportional to time consumed, which is not the case I speak about. I want for each month (January, February, ….December) a fixed salary for this resource.”

Well, the answer is: “It is NOT possible with MS PROJECT!”. Why? There are several reasons. The major one is that if you put a resource to the Task like this one:

image

then what is the real cost of the Resource who has $4000 salary per month. As you can see the Resource will work from 18.09.2018 to 30.09.2018, and from 01.10.2018 to 22.10.2018. Now those are two months but not full months. And rarely will you have task which started at the first day of the month, and finish at the last day of the month.

Another example is like this:

image

Now let’s say that resource will work 30% on the Task 1, and 50% on Task 2. What will be the cost on Task 1, and what on Task 2? Tasks have two different durations. And even worse, the resource will work only 80% of his time. What about rest of the 20%?

So no, this doesn’t make a sense. You should always have a rate per hour, week, month, and YES MS PROJECT should calculate costs according to effort (hours) which resource will spend on those tasks.

Regards.

Advertisements
Posted in MS PROJECT 2016, PMI, PRoject Management | Tagged , , | Leave a comment

Resource detail form in MS PROJECT 2016

Hi,

as I wrote many times there is a very useful Task form in MS PROJECT 2016!

Here is one simple project:

image

With the Task form we have full control over the Task, like this:

image

In Task form we can choose what are we going to look at like:

image

All of this is about Tasks, one by one. But, is it something similar but for resources, one by on. for example I want to see for one resource all tasks, or somethin like that. The answer is – YES. To get that on the screen follow this steps:

SNAGHTML4d823672

As you can see for one Resource I have all information about all Tasks. If I right click on the Resource form I will get:

SNAGHTML4d83c03e

No matter on which Task is your cursor you can choose previous or next button and see all the necessary information for one resource for all tasks. and of course you can edit those information. So Let’s say that Reviewer has spent 16 hours on Task – Review the article. I will choose Work option form the screen above and I will:

image

and I will get:

image

So if you want to manage your Task Resource by Resource, this is the best and most efficient option in MS PROJECT!

Regards!

Posted in MS PROJECT 2016, PMI, PRoject Management | Tagged , | Leave a comment

Duration and % completed–relation between them in MS PROJECT 2016

Hi,

I noticed that lot of MS Project users have a problem with Duration and work which was already completed. Let me give you an example in MS PROJECT 2016.

Let’s say that we have a one Task Project, with 4 Days Duration, and John is supposed to work on that Task:

image

As you can see John is going to spend 32 hours of work (4 days * 8 hours per day = 32 hours).

Now let’s say that Task is 50% completed:

image

and we get:

image

Now let’s say that we made a mistake. Task was originally meant to have Duration 3 days, and Task is 50% completed.

I will change Duration from 4 to 3 days and I will get:

image

As you can see, when I changed Duration form 4 to 3 days, work has changed from 32 hours to 24 hours (3 days * 8 hours per day = 24 hours). Actual Duration and Actual work remained intact, and % complete is now 67%. Why? Because 2 days (Actual) / 3 days (Total9 = 0,67, e.g. 67%.

Remember this: Actual means – already done! if you don’t change it it will remain as it is no matter if you change Duration or Work.

So, back to the Case. If we want to have a Task which has 3 days Duration and is completed 50%, we should follow next steps:

1. This is the moment when we noticed that we have mad a mistake. So Duration is 4 days and % Complete is 50%:

image

2. First we will put 0% Completed:

SNAGHTML245b6934

and we will get:

image

3. Now we will change Duration from 4 to 3 days:

image

4. Finally we are going to make it 50% completed (as we did before, when Duration was 4 days), and we will get:

image

Now we have what we wanted at the first place. Of, course, same steps should be taken if we want to increase Duration!

Regards!

Posted in Microsoft Project 2013, MS PROJECT 2016, PMI, PRoject Management | Tagged , , , | Leave a comment

Total hours limit with multiple Projects using MS PROJECT

Hi,

I have a question from one of my Blog readers

“Thank you for all your advices which you share on blog. I have an issue where I would like in resource pool file calculate the total “booked” work hours between two (freely chosen) dates (eg between 1.1.2018 and 31.12.2018). In my case I have to monitor the total (planed) work hours per person which should not exceed 1700 h per year. Now I can see only a total work hours between start day of the first project and the end day of the last project per person.
Can you help me?
Thank you in advance.”

I will show you how can you do that using MS PROJECT 2016.

First I will create Resource Pool with John and Mary:

image

and:

image

I will save this file as Resources.mpp (you know how to da that, so I won’t show you pictures Smile)

Now I will create First Project with two Tasks:

image

and:

SNAGHTML5573dd21

I will assign both John and Mary to those Tasks using Resource Pool:

image

and:

image

and finally:

image

Following exactly the same steps I will create another Project – Second Project, and I will get this:

image

As you can see John and Mary are over allocated, but for this case this doesn’t matter.

Now I want to see how many hours are John and Mary spend this year in total, for all Projects. I will use Resource Pool and Resource Usage View:

image

Finally I will adjust Timescale on the right:

image

and:

image

and:

image

The result is:

image

Now I can see “occupation! of every single Resource in all projects, year by year.

Hope this help.

Regards

Posted in MS PROJECT 2016, PMI, PRoject Management | Tagged , | Leave a comment

Recording task progress ahead of schedule in MS PROJECT 2016

Hi, today I am going to clarify one important thing which bothers a lot of  of my Blog readers. I will go step by step through example and explain them.

First I’m going to build simple Project:

image

Now I will create three Resources:

SNAGHTML962d108

and I will assign them to Tasks:

image

I will now make Task 1 as 25% completed:

image

Task 2 actually starts earlier than planned (that is, earlier than its current Start Date). So Task 2 Actual Start Date is manually updated to an earlier date.

In the Mark on Trask -> Update Tasks dialog box I will enter 25% Complete , the earlier Actual Start Date for Task and click OK:

image

and:

image

and I will get:

image

Now, I will put status date to 24.07.2018, and then I will update the project to reschedule uncompleted tasks to after the Status Date:

image

and:

image

and I will get:

image

The Actual Start Dates of Task 1 and Task 2 are not changed, but their Finish Dates are changed for the later dates. That is  OK! Why? Start date is not changed because some work is already done and it was started at those Start Dates, so they cannot be moved or changed. What is done is DONE! It is written in the stone!

And now, where my blog readers have the biggest problem? Look at this.

I will make  Task 2 100% complete based on its earlier Actual Start Date and original Duration, so I will enter the Actual Finish Date in the Update Tasks dialog box:

image

Finally, I will get:

image

the question is: The Duration for this task is shown only 0.75 days instead of  its scheduled Duration of  3 days?

At the first look, it seems that this is a bug, because Start Date id 24.07.2018, finish Date is 26.07.2018, but Duration is 0,5 days instead of 3 days. But this is not a bug. I will explain why this is totally normal result:

  1. First I put 25% Completed for the Task 2 which had 3 days Duration. It means that actual Duration is 25% of 3 days is 0,75 days
  2. Then I moved the all unfinished Tasks after the status date, which is 24.07.2018.
  3. Because Task 2 has Finish to start relationship with Task 1, and Task 1 was supposed to finish at 27.07.2018, and the remaining part of Task 2 is supposed to start at that date (27.07.2018)
  4. BUT! I put 100% at %Complete, and Finish date to 26.07.2018. which is before Task 1 was finished.
  5. This means that Task 2 has no work left, so it was needed only 25% of original estimated work, and this is 0,75 days and 6 hours! If you have expected that those 2 days (25.07.2018, and 26.07.2018) work will be performed, you were wrong and this is because nothing is supposed to be done at that dates because Task 1 was not finished at that time. So the earliest date on which work on Task 2 is supposed to be done is 27.07.2018, and this is before the finish date of Task 1 which is 26.07.2018

Hope this helps.

Regards!

Posted in MS PROJECT 2016, PMI, PRoject Management | Tagged , | 1 Comment

Calculate Variance in Working Days after setting another baseline in MS PROJECT 2016

Hi,

I’ve got a question which is: “How do you calculate the working days in formulas when the baseline is not Baseline 0, and you need to see variance of that Baseline?”

It’s easy and I’ll show you how with MS PROJECT 2016. First I will create a simple Project with only two Tasks:

image

Now I am going to create some Resources and I will assign them to those Tasks:

image

and:

image

Finally I will save thee Baseline:

image

Now, suppose that, for example, Task 1 was started at 17.07.2018 (instead of 16.07.2018), and Actual duration i1 1 day, but remaining duration will be another 3 days:

image

and:

image

Suppose that another Task, is needed for the Project, and John and Mary are going to work on that Task:

image

Let’s no switch to Variance Table:

image

As you can see, Task 1 has Start Variance 1 day (because it was started 1 day latter than planned) , and Finish Variance 3 days (because it has duration 2 days longer than planned, and it was started 1 day latter than planned).

And no suppose that this is your new plan, because Stakeholders, Sponsor, CEO, or anyone else approved it as a new Project plan. But for historic purposes the old should be saved, so you should save this new plan as Baseline 1 (I’m not going to show you pictures, because procedure is the same like when I saved first Baseline. You just have to choose Baseline 1. After I save this baseline I will get in Variance table this:

image

Do you notice any change? NO! Same result. Now, if you want to see Variance according to Baseline 1 you should follow this steps:

image

and:

image

and finally:

image

So now if I look at the Variance Table I have:

image

So now, everything is OK. you can do this for every single Baseline.

Regards!

Posted in MS PROJECT 2016, PMI, PRoject Management | Tagged , | 1 Comment

Big or small Project – how to know which is which?

hqdefault

Hi,

many times I heard talking about big and small Projects. Many companies have different procedures for them. Of course procedures are lightweight for small Projects, and heavy for big ones. But, I am not going to talk about different procedures. I will talk about how recognize those Projects.

Almost every company which make differences among big and small project make it by the:

  • Budget – or how much will it cost?
  • Time – or how much will it last?
  • Resources – how many people are going to work on it?

And, for example, decision is:

  • If the Project is under $100.000 it will be considered as small, otherwise it will be considered as big
  • If the Project is under 3 months it will be considered as small, otherwise it will be considered as big
  • If the Project is going to be done under 10 people it will be considered as small, otherwise it will be considered as big

And, frankly, I do not agree with that. YES project can be measured with those parameters, but think about this: RISKS. From my point of view Project is big if it is risky. Let me explain that theory. Let’s say that you are going to upgrade 10 computers to the latest version of operating system. And you need 2 hours per computer. And you are going to be payed $500 per computer. And you need only two persons to do that. So, this is cheap, short, and not people demanding project. According to parameters mentioned above, it should be consider as small. BUT! What if those computers serves as as front end computers in the bank? What if mayor application is running on those computers. And, finally, if this application won’t work, you will get extremely angry customers. In other word, what if this upgrade project is risky? And it is, no matter of budget, time and resources. See where am i pointing at?

On the other hand, if you sold ERP system to company which is subsidiary of another Company. And it follows all processes and procedures as the main company. So, new ERP system is, more or less copy – paste Project. BUT, since we are talking about ERP, and licenses are expensive, we are talking, for example, about $500.000 budgeted Project. Is it big? Well, not exactly.

So risks, risks, risks, are always the primary measure when you think about your Project as big or small.

To be short, and jump in the conclusion at once. If your project is risky, no matter how small your budget, timeline, and resources demands are you should consider it as big!

 

Regards,

Nenad

 

Posted in Uncategorized | Leave a comment