Resource usage based on time estimate

J

JoelB

I have posted a similar thread about tasks and resource allotment in the
past and gotten great feedback. I am a Project newbie, and probably need to
change my thinking (not to mention spend more time studying instead of just
doing), but perhaps someone out there can point me in the right direction.

I think I have boiled it down to this: ideally I would like for everything
to be static except for the employee's average daily commitment (i.e. -
units). I would like to be able to manually adjust start, end, duration, or
total hours, and only have Project recalculate that percentage. I would
also like for it to store and display the employee's total hours, so I don't
have to go back and look it up if I choose to adjust it.

Is any of that possible with MS Project, or can someone tell me how my
thinking is wrong?

More detail of what I'm trying to do is below.

TIA,
Joel

We tend to figure out how many hours a given employee is going to have to
work on a task to get it finished. However, that employee is going to be
juggling multiple tasks at any given time, not just working on the one. I
want to use Project to manipulate those tasks and adjust them without it
messing up the amount of hours I have put in for the employee.

For example, I create a task and put in how many hours that task is going to
take the employee. I want to be able to move the start dates, end dates,
and/or durations around, and have Project figure out the of that employee's
average daily time commitment dynamically. I also want to be able to change
the hours that the employee is going to invest in the task, without Project
messing up my dates and durations.

So, if the employee is working on two tasks at the same time, but it's going
to take too much time each day, I want to be able to stretch the tasks over
a longer duration until the employee's consolidated average daily commitment
is reduced to a feasible amount of time. Or, I might want to change the
employee's hours on the task, have it adjust the percentage of the
employee's daily time is going to be committed to the task, again without
Project messing up my dates and durations.

Project always seems to change or not change things differently. Fixed
Duration, non-Effort Driven *appears* to be the closest thing to what I am
after. However, if I change the duration, it does not change the employee's
Units amount, so the hours that I entered are lost.
 
R

Rod Gill

Hi,

Project can do all you want. It sounds like fixed work is the setting you
need. You also need to read help and get training in how to assign and then
edit resources.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/
 

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

Top