Remaining and Actual Units calculation issue

Hello Planners!

I need advice to understanding Remaining / Actual / At Complete Units calculation. There is 40hrs long activity to which a labor resource is assigned with 40h budgeted units. Calendar is 5d x 8hr. 

When activity started and DD moved 1 day ahead, I claim 20% Unit Percent Complete what makes Actual Labor Units=8h, Remaining Labor Units=32h and At Complete Labor Units=40h. However if I claim 40% Unit Percent Complete  for the same DD - Actual Labor Units=8h, Remaining Labor Units=12h and At Complete Labor Units=20h. However I need that At Complete Labor Units are equal to the Budgeted Labor Units. 

TASK SETTINGS:

  • Activity Type=Task Dependent;
  • Duration Type=Fixed Units;
  • % Complete Type=Units.

WBS SETTINGS:

  • Technique for computing Estimate to Complete (ETC): ETC=remaining cost for activity

PROJECT SETTINGS:

  • Link Budget and At Completion for not started Activities = Checked;
  • Subtract Actual from At Completion = Selected;
  • Recalculate Actual Units and Cost when duration % complete changes = Checked;
  • Link actual to date and actual this period units and costs = Checked.

[[wysiwyg_imageupload:6695:]]

Z
Zoltan Palffy 👤 Member for 16 years 10 months

Go to tools global change New

Where Units % Complete is not equal to 0

then duration % complete = Units % complete

now on the right Change 

then on the bottom Committ

R
Rustam Sharifov 👤 Member for 9 years 9 months

Hi Zoltan,

I need to use Units % Complete type, not Duration % Complete. Can the calculation be fixed with Units % Complete setting? Thanks!

R
Rustam Sharifov 👤 Member for 9 years 9 months

No, I didn't do twice amount of work with the same labor. When I claim 20% initially I get 8hrs actual, however then I increase Unit Progress Percent to 40% meaning that actual hours shall be 16hrs and remainder 24hrs, however I get actual 8hrs and remainder 12hrs instead. 

R
Rustam Sharifov 👤 Member for 9 years 9 months

No, I didn't do twice amount of work with the same labor. When I claim 20% initially I get 8hrs actual, however then I increase Unit Progress Percent to 40% meaning that actual hours shall be 16hrs and remainder 24hrs, however I get actual 8hrs and remainder 12hrs instead.  

R
Ron Beechey 👤 Member for 10 years 1 month

If I understand your issue to claim 40% you did twice the work with the same amount of labour.  (good for you) so the calculations are correct.  Why do you need to have the budgetted hours equal the actual.   If you save on this task somewhere along the way the hours will equal out as it may take longer on another task during the project.

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts