Link to home
Start Free TrialLog in
Avatar of Jaime Olivares
Jaime OlivaresFlag for Peru

asked on

Microsoft Project - How to use "work units" and have calculated duration

Hello all,
I am stuck with this for a while:

We have a software project which is defined by "work units", like:
- Functionality X: 55 Work Units
- Functionality Y: 36 Work Units
- etc.

A "work unit" has a fixed duration based on developer Performance, like: 1.5 units per day

What I want to do is to enter Start Date and Work Units, then MS Project should calculate the End Date.
I have the Start Date column, as well and End Date (which I want to be a calculated column), but don't know how to enter the Work Unit and the Performance.

Please help me to identify the proper column names and/or dialog fields.

Thanks in advance,
Jaime.
Avatar of bobsegrest
bobsegrest

Hello Jamie,
 
This could be fairly straight forward...  
Project scheduling is driven by a simple formula.   Duration (elapsed time) multiplied by Units (people) equals Work (effort).  Determine any two points, apply a little basic algebra and you have an answer.  In your case we come up with Work  divided by Units equals Duration.
 

snap1.png
ASKER CERTIFIED SOLUTION
Avatar of bobsegrest
bobsegrest

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial