Solved

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

Posted on 2007-03-29
1
2,128 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 13

Accepted Solution

by:
bobsegrest earned 500 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

635 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