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.
LVL 55
Jaime OlivaresSoftware ArchitectAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bobsegrestCommented:
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
0
bobsegrestCommented:
Looking at the first snapshot you see that the first task (Functionality X) has a duration of 55 days and the Task Type has been set to Fixed Work.
Notice in the second snapshot when we change the Units for the assigned resource (Developer 1), the Duration (and Finish Date) is reduced accordingly.
I think this is the response you are looking for.  If not, elaborate...
Bob Segrest
PMP, MCITP, MCT, Microsoft Project Blackbelt
 

Snap2.png
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Project Management Software

From novice to tech pro — start learning today.