Solved

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

Posted on 2007-03-29
1
1,616 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 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

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…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

760 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now