# 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.

Jaime.
LVL 55
###### 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.

Commented:
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
Commented:
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