[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Define Tasks in Man-Hours in MS Project so that changing resources changes finish date

Posted on 2007-03-29
1
Medium Priority
?
3,031 Views
Last Modified: 2013-11-15
I am somewhat of a MS Project n00b.  I have defined all the tasks in my project and would like to schedule those tasks.  I have already defined the resources available for my project.  What I want to do is be able to define the duration of an individual task as hours.  When I apply a resource to that task, the finish date should be determined based on the number of hours (man-hours) the task requires divided by the hours in the work week.  So if I had a task defined which required 80 hours and I assigned one resource, the finish date would be two weeks from the start date.  If i then applied a second resource to that project (we are going on the assumption that there is no diminishing return on adding new resources), the finish date would be one week from start date since 80 man hours = (2 resources) * (40 man hours / week).

I hope someone is able to get my meaning and give me a hand on this.
0
Comment
Question by:dougschultz
1 Comment
 
LVL 13

Accepted Solution

by:
bobsegrest earned 2000 total points
ID: 18830488
Hello Doug,

Good news!  You are on the right track.

In Microsoft Project the essential formula is:

     Work * Units = Duration

The rule is enter one, anchor one and let Project calculate the other.

The default Task Type when you install Project is Fixed Units.  The Task Type may be set to Fixed Units, Fixed Duration or Fixed Work.  The type that you fix is your anchor.

To make Project do what you want it to, set your task type to Fixed Work and set the Work (not the duration) for your task to 8- hours.  Now when you assign a resource (a unit) to the task, Project will automagically adjust the duration to 10 working days.  If you add a second resource (unit) to the task, Project will set the duration to 5 working days.

Does this answer your question?

Bob Segrest, PMP
Microsoft Project Blackbelt

PS: I would also like to recommend the book "Dynamic Scheduling With Microsoft Office Project 2003" by Eric Uyttewaal, ISBN1-932159-45-2.  It is probably the best book written on the practical use of Microsoft Project.

0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

640 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question