Extending Resource Cost Rate tables

[Prasanth]

Hi ,

We have a requirement wherein we need to have more than 5 standard rates
available through cost rate tables.Is there a way to extend this?Please
provide some samples if any.

Regards,
Prasanth.

 

[John]

Hi ,

We have a requirement wherein we need to have more than 5 standard rates
available through cost rate tables.Is there a way to extend this?Please
provide some samples if any.

Regards,
Prasanth.

Prasanth,
You mean to tell us that you need more than 125 rates for a single
resource? Each resource can have up to 5 tables and each of those can
have up to 25 time based variable rates.

Normally pay rate changes are time based (i.e. annual increase -
typically salary resources, or periodic increases - typically hourly
resources). That's why the rate table is structured as it is. It
recognizes that any given resource might work at 5 different job levels,
each of which has a different pay rate. Then time phasing can be applied
to each of those.

If you do indeed have a very unique situation that requires more pay
rates per resource then here is a suggestion. Define those resources as
different entities. For example Joe-A, Joe-B, etc. Create as many
"parts" of Joe as you need to accommodate the pay rate structure. Assign
parts of Joe as appropriate for his tasks. You can use the grouping
function to get a grand total of Joe's costs for all his tasks.

Hope this helps.

John
Project MVP

 

[Prasanth]

Hi John,

We have a requirement where in a resource can play more than 5 roles in a
single project and the rates should be specific to a role and when the
resource has been assigned to a specific role the rate should be
automatically mapped.The existing Cost Rate Tables will allow us to define
only 5 rates for a single resource as the resource may also be involved in
multiple projects at the same time.Hence, I need to know the possibilities of
extending the cost rates for the resources and the way to accomplish the same.

Thanks for your response John.

 

[Jan De Messemaeker]

Hi,

I do understand your requirement, but I do not see a possibility I'm afraid.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[John]

Hi John,

We have a requirement where in a resource can play more than 5 roles in a
single project and the rates should be specific to a role and when the
resource has been assigned to a specific role the rate should be
automatically mapped.The existing Cost Rate Tables will allow us to define
only 5 rates for a single resource as the resource may also be involved in
multiple projects at the same time.Hence, I need to know the possibilities of
extending the cost rates for the resources and the way to accomplish the same.

Thanks for your response John.

Prasanth,
I already suggested a solution, try that.

As far as modifying the existing cost rate tables, that's not possible,
the cost rate table structure is a fixed part of Project's design.
However, your case isn't the first time I've run into something a user
needs/wants. The solution is to come up with a workaround that will
achieve the same or similar results despite the limitations of Project.
Hence my suggestion.

John
Project MVP