Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read SiteMap

Tags: , , , ,

Sponsored Links



Duration vs. Actual Work

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 12-02-2009
Glenn
 
Posts: n/a
Duration vs. Actual Work

I have a task with a 5d duration and 5d of work. If I complete only part of
my work each day, then my duration and/or finish date should grow accordingly.

In Tools->Options->Calculate, I check both Move check boxes. There are
actually 4 move check boxes but I checked just the 2 that are at the top
level.

In day 1, I complete only 0.5d of work. This moves my completion date 0.5d
ahead. I next set my current date and status date in Project->Information to
the next calendar date. On my second day, I complete only 0.5d of work and
my completion date pushes the duration of the task ahead another 0.5d which
should make my duration field equal to 6d but the duration field remains at
5d.

If I do only 0.5d of work each day, my task duration should grow from 5d to
10d. Instead my duration field remains at 5d and my final SV is 0.

Can anyone tell me why my duration does not grow and my SV does not reflect
a blown schedule?
Reply With Quote
  #2  
Old 12-02-2009
JulieS
 
Posts: n/a
Re: Duration vs. Actual Work

I think if you look at your Gantt chart, you'll see your task has
been split several times. Project is assuming you only worked 4
hours (8:00 - 12:00) and has moved the remaining work to recommence
the next morning at 8:00.

Have you tried recording actual work per day in either the Task
Usage or Resource Usage view? That method will do what I think you
are seeking. By the end of day 3 with only 12 hours of work
recorded, I show a 6.5 day duration and a negative SV. The
assignment units for the portion of the task with actual work
recorded has dropped to 50% and the actual 4 hours of work has been
spread evenly throughout the entire 8 hour (1day) duration.
Reply With Quote
  #3  
Old 12-02-2009
Steve House [MVP]
 
Posts: n/a
Re: Duration vs. Actual Work

Adding to Julie's answer, why should Project assume that if you only did 4
hours worth of work on the first day when 8 was originally scheduled, that
you'll continue doing only 4 hours a day on subsequent days? What if you
original task was Mon thru Fri 8 to 5 - wouldn't it make equal sense to
assume that you only got 4 man-hours of work done on Mon because something
unexpected came up that took time away from the task in question but you got
it cleared off your plate by the end of the day and are now able to work
full-bore on the task now? In that case you'd do Mon 4 hours between 8 and
5, then Tuesday 8 and so forth with the finish only needed to be extended by
half a day on the backside.
Reply With Quote
  #4  
Old 12-02-2009
Glenn
 
Posts: n/a
Re: Duration vs. Actual Work

My scenario of a task, planned to take 5 days that instead takes 10 days, is
arbitrary. My point is that if, for whatever reason, I only do half what I
plan to do each day, that my 5 day task will take 10 days. Given this, the
duration should move from being 5 days to 10 days and my SV should be hugely
negative and anything but 0.

I should not have to enter anthing manually if all my options are set in
advance and I prefer to only work from my task sheet.

Here's my list of steps:

1) Task set to Fixed Units with a duration of 5 days
2) Tools->Options->Calc has both Move checkboxes checked
3) I have one resource assigned at $125/hr or $1,000/day
4) I set my baseline
5) Each day I set % Work Complete equal to 10% which is only half of what
I planned to do for the day
6) I now see a split task with the planned finish date moving ahead by
half a day.
7) Each day I go to Project->Info and advance the current day and status
day ahead by one day and then I add another 10% of work complete once again
moving the finish day ahead by half a day.

After doing only a half days work for 10 days, I have finally finished my 5
days of work but my duration shows only 5 days whereas my gantt chart shows
duration to be 10 days.

Also, if I am 5 days late why is my SV equal to 0 since I am late by 5 days.
Reply With Quote
  #5  
Old 12-02-2009
Steve House [MVP]
 
Posts: n/a
Re: Duration vs. Actual Work

Is the checkbox on the calculation page "Updating Task Status Updates
Resource Status" on or off? For convenience assume the task in your
scenario started Monday, was to end Friday and the default Standard calendar
is in charge. An the first day, when you entered 10% work complete, with it
on it, Project also sets the Actual Duration to 4 hours, 10% of the total.
The resource is 100% so that means he worked 8am to 12 noon, then stopped.
The task splits with the unworked portion moving to restart Tuesday 8am.
When you enter 10% for Tuesday, work again proceeds from 8am to 12 noon and
then stops. (Resource is 100%, remember, so there's a 1:1 correspondence
between work accomplished and time passed.) As of the end of the day
Tuesday Actual Duration is 1 day (not 2 days because at 4 hours working time
per day it takes 2 calendar days to burn-up 1 duration day) and remaining
Duration is 4 days; the remaining work is scheduled to resume Wednesday at
8am. The result is that work is done in the mornings and the afternoons
become non-working time (times inside splits are non-working - the task goes
on 'vacation.') Non-working time does not count for duration so although
the task elapsed time extends for another 5 days plus weekend, the
non-working afternoons are backed out of the duration and so the duration
remains at 5 days, 10 weekdays at 4 working time hours per day.
Reply With Quote
  #6  
Old 12-02-2009
Glenn
 
Posts: n/a
Re: Duration vs. Actual Work

My "Updating Task Status Updates Resource Status" is checked on.

Again my duration=5d and my single resource at 100% is set at $125/hr or
$1,000/day. My baseline is set. On day one, my BCWS=$1,000, BCWP=0 and
ACWP=0.

I am testing a single task in a new project just to see how things work.

My question here really revolves around SV. If on day one, I set my Actual
Work to 100%, I finish 4 days ahead of schedule with SV being positive
meaning I finished ahead of schedule.

What I want to know is how I can complete only partial work each day, or in
my previous scenario of completing only half of what I need to do for each
day which leaves me finishing 5 days late, where my SV should be negative.
Currently this scenario leaves me with SV=0 at completion which is not true
as I finish 5 days late.

What's happening here?
Reply With Quote
  #7  
Old 13-02-2009
JulieS
 
Posts: n/a
True. However when you status date = end of day 5 (as
scheduled) you'll see SV = 0. You will still show a Finish Variance
of -4days, but your SV = 0.

Given your scenario above, here's what I see:

End of Day 1:
Actual Work = 4 hours
Status date = end of Day 1
SV = ($500)

End of Day 2:
Actual Work = 8 hours
Status date = end of Day 2
SV = ($1000)

End of Day 3:
Actual Work = 12 hours
Status date = end of Day 3
SV = ($1500)

End of Day 4:
Actual Work = 16 hours
Status date = end of Day 4
SV = ($2000)

End of Day 5:
Actual Work = 20 hours
Status Date = end of Day 5
SV ($2500)

So, at the end of the original duration of 5 days you have a
negative SV, a Finish Variance of 2.5 days.

If you continue on in the same method, each day doing 1/2 of the
original scheduled work and pushing your finish date out, your
schedule variance start to shrink because as you extend the finish
date of the task, you are not increasing the amount of scheduled
work -- therefore your BCWS stays at $5000 while your BCWP continues
to increase as you continue to record work on the task. Again, your
finish variance continues to grow.

"Duration" means something different to Project than it does to you
and me. To project, it's part of a mathematical relation that is
always CONSISTENT for a concrete task:
Duration = Work * Units
This is not the same as the "elapsed time between the start and finish
dates". To complicate things, however, a SUMMARY task will use the
"elapsed time" definition.

To illustrate, add the "BCWS", "BCWP", and "SV" columns to your
table. After I set the Status Date to the first day, I see that the
BCWS = $1000 and the BCWP = $0. After I enter %WorkComplete = 10%, I
see that BCWP = $500 and the schedule variance SV = ($500). The bar
splits and the new elapsed time is 5.5 days. The Duration field is 5
days. Everything seems in order.

One of your notes above said that you see BCWS = $1000 before entering
the work. That's indicative that the baseline is accurate. The fact
that you don't see BCWP = $500 after entering %WorkComplete = 10%
greatly puzzles me. It should work.
Reply With Quote
  #8  
Old 13-02-2009
Glenn
 
Posts: n/a
I guess SV = 0 in all cases when work for a task is fully complete.

Is there a means of tracking how late (or early) tasks are completed? In my
example, the task was five days later than planned. The task had planned to
take 5 days when it ended up taking 10 days.

For some reason MSP's field named "Actual Duration" was listed as being 5
days when the task took 10 days to complete. The meaning of all of the
fields are most often found to be contrary to what one might find to be in
any way logical.

The "Actual Duration" was 10 days. Is there another field that will give me
the full amount of time that the task took to be completed?

Maybe it's just me, but this seems to be just too hard.

I just shifted my "earned value method" from % Complete to Physical %
Complete and that changed my Actual Duration to the correct amount of extra
time the task took to complete - less time for the split tasks where the
gantt bar jumped ahead when I completed only part of what I planned to
complete for a day. As such, the Actual Duration still does not equal the
difference between the Actual Start and the Actual Finish dates.
Reply With Quote
  #9  
Old 13-02-2009
JulieS
 
Posts: n/a
If we are talking about the same scenario the actual duration is not
10 days, it's 5. It spanned 10 days but each day was only counted
as 4 hours so still 40 hours = 5 days. You can view start and
finish variance in the Variance table. You can always calculated
difference the actual start and actual finish through a formula in
one of the additional duration fields (Duration1) but the Actual
duration will show 5 days.

That's not the correct actual duration. Actual Duration at completion in
your scenario is 5 days, not 10. Duration is not simply the difference
between Actual Start and Actual Finish as measured by clocks and stationary
store calendars. It's the number of working time MINUTES between start and
end but ONLY those minutes defined as working time count. At 4 hours
working time per day, the resource has to come to work on 10 working days to
work for 5 duration days. Do not confuse duration with elapssed time - they
are not even close to measuring the same thing.

Summary tasks do NOT always report elapsed time correctly. See the thread
starting on 2/6/2009 where I originally asked about work occurring on
weekend tasks. You will see that I solved my particular problem of
displaying the elapsed time by using a formula and a text field. (Sorry I
don't know how to give you a clickable reference to the exchange.)
Reply With Quote
  #10  
Old 22-04-2010
Member
 
Join Date: Apr 2010
Posts: 1
Re: Duration vs. Actual Work

I'm trying to determine how Actual Duration is derived. and this explanation doesn't match what I am seeing.

I have a Task with three Resource.

Task Start
03/30/2010
Task Finish
05/20/2010
Actual Work
21h
Actual Duration
1d

The timephase Actual Work for the Resources, starting on 3/30 is:

Res1 0 0 4 0 0 0 0 0 3 2 0 0 0 0 0 2 3
Res2 1 1 0 0 0 0 0 1 1 1 0 0 0 0 0 1 1
Res3 (no Actual Work)


If the Actual Duration is the actual work hours, I would expect that it would be 2.6d. If it were the working days from the start, I would expect it to be 8d.

How is Actual Duration 1d?
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Duration vs. Actual Work"
Thread Thread Starter Forum Replies Last Post
Actual Duration Not Calculating Accurately by76 Microsoft Project 1 27-04-2011 07:23 AM
Project duration Longer in MS Project than the actual duration Techbee Microsoft Project 5 24-01-2011 04:21 PM
Actual Duration display jp Microsoft Project 19 07-04-2010 08:26 PM
Question on duration and actual working time bakkhos Microsoft Project 6 19-10-2009 07:21 PM
Change Duration and Actual Finish Kirsty Microsoft Project 6 10-09-2009 09:27 PM


All times are GMT +5.5. The time now is 02:17 AM.