Resource Calculation Question

E

Eagle62

Hi,
I'm a bit of a novice and just cannot work out how to get MSP2003 to do what
I need! Which is :

The project will have 3 teams working on it.
Each team will work on each task together.
The percentage of the work done per team on each task will vary per task but
I know these percentages.
Each task must be completed within a fixed duration.
The total number of person days for each task has been determined and will
also need to stay fixed.

I need to enter the duration, amount of work and the percentage of each task
that will be performed by each team
so that MSP calculates the number of workdays to be performed on each task
for each team and therefore also calculates
how many people need to be allocated to each task per team.

Example task :

What I know is that :
Duration = 20 days
Work = 100 days
Team A will complete 50% of the work
Team B will complete 40% of the work
Team C will complete 10% of the work

I need MSP to calculate the number of workdays per team as :
Team A = 50 days
Team B = 40 days
Team C = 10 days and that therefore the resource requirement from each team
is

Team A = 50 / 20 = 2.5 people
Team B = 40 / 20 = 2 people
Team C = 10 / 20 = 0.5 people.

Apologies if this is basic but I can't see how to do it and would very much
appreciate any help.

Many thanks
Eagle
 
R

Rod Gill

Hi,

Try entering the durations you need against the tasks then select a task and
click the Assign Resources Task (Alt+F10). Enter the % against each resource
and you're done!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
E

Eagle62

Hi Rod,

Many thanks, it works very nicely! Just out of interest, Alt+F10 brings up
a different resource box to the one you get if you go via the task
information box. I couldn't make it work right via the task information
box. Is use of Alt+F10 the key thing or was I just doing something wrong
when I used the task info box?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tracking Resources as Trade Types - Rather than Individuals 1
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Weighted % Complete calculation 1
Individual vacation calendars in a team resource 0
Adding Quantum or Quantity of work to a task. 2
allocate resource over long period of time 0
Can I view task, shared to me in my to-do list, or is it nessesaryfor me to follow up on both my per 1
Automatically reduce resource allocation during overallocation period 0

Top