Microsoft Office Forums Unit of work
 Register FAQ Search Today's Posts Mark Forums Read

#1
05-14-2021, 02:12 AM
 ketanco Windows 7 64bit Office 2010 64bit Expert Join Date: Dec 2011 Posts: 279
Unit of work

Hello,

Work = duration x assigned units

So this is: time x units

Then why does MS project show units of work as hours? Should it not be manhours or workerhours etc...?
#2
05-15-2021, 12:56 PM
 miless2111s Windows 7 32bit Office 2007 Novice Join Date: May 2016 Posts: 28

It doesn't - it shows assigned units as %. It shows work as hours (or days depending on the option you have chosen).
Thus your formula should be work = time x % and thus the units of duration and work are hours.
#3
05-15-2021, 09:27 PM
 ketanco Windows 7 64bit Office 2010 64bit Expert Join Date: Dec 2011 Posts: 279

But the formula for work is

work = duration x assigned units
this is a universal formula
#4
05-16-2021, 01:14 AM
 miless2111s Windows 7 32bit Office 2007 Novice Join Date: May 2016 Posts: 28

Quote:
 Originally Posted by ketanco But the formula for work is work = duration x assigned units this is a universal formula
I fear we may have a mismatch in terms. What do you mean by "assigned units"? In MS Project the assignment of resource at x% of their time is the assignment element. This is measured in % of the resource's time

What are you referring to when you say "assigned unit" which you see as measured in hours?
#5
05-16-2021, 01:17 AM
 ketanco Windows 7 64bit Office 2010 64bit Expert Join Date: Dec 2011 Posts: 279

No I mean the universal formula for work.

Work = duration x assigned number of units to the task.

Assigned units can be as 5 men, 6 trucks,

so the work then will be man hours or truck hours etc.....
but why does MS project display it as hours only....
hour is duration. Work is not duration. it is how long certain amount of resource worked for it = duration x assigned units
#6
05-16-2021, 11:38 PM
 miless2111s Windows 7 32bit Office 2007 Novice Join Date: May 2016 Posts: 28

Quote:
 Originally Posted by ketanco No I mean the universal formula for work. Work = duration x assigned number of units to the task. Assigned units can be as 5 men, 6 trucks, so the work then will be man hours or truck hours etc..... but why does MS project display it as hours only.... hour is duration. Work is not duration. it is how long certain amount of resource worked for it = duration x assigned units
I am sorry I thought this was a question about MS Project and how it calculates work. I see it is more of a general philosophical point. So in your calculation when you apply 4 people to the task are you assigning them full time or part time? You can't answer this with "well if they were half time it would only be 2 people" as you need to communicate exactly who needs to be working on the task. Hence you need to be able to mark the resources A, B, C and D as 50% of their time. This is what MSP is doing with the allocation of resources (who are assumed to be full time unless marked with a % allocation)
I hope this helps but if this is more of a "MS did it wrong" type comment I suspect it won't.
Regards
Miles

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post adbast Word 1 08-10-2019 10:18 AM robot Excel 4 06-07-2017 07:00 AM Officer_Bierschnitt PowerPoint 2 01-14-2016 03:04 AM cag8f Project 18 01-02-2016 01:51 PM Jamal NUMAN Word 3 04-24-2011 04:48 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:01 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top