Need more flexibility in Resource Rate

J

Jon Fischer

In our service focused enterprise, we are constantly
negotiating out rates. Therefore, for each project, the
resource assigned may have a different rate. If that
resource is assigned to 10 different projects, with 10
different rates, this is going to be a problem.

In the database structure for Project/Resource Rates,
there is a table "MSP_RESOURCE_RATES". From the
structure of the table, it looks as though we could store
custom rates for each resource for each project.

Anybody have any thoughts on this? I only have a couple
of weeks to implement a solution that resolves our dilemna
 
B

Brian K - Project MVP

Jon said:
In our service focused enterprise, we are constantly
negotiating out rates. Therefore, for each project, the
resource assigned may have a different rate. If that
resource is assigned to 10 different projects, with 10
different rates, this is going to be a problem.

In the database structure for Project/Resource Rates,
there is a table "MSP_RESOURCE_RATES". From the
structure of the table, it looks as though we could store
custom rates for each resource for each project.

Anybody have any thoughts on this? I only have a couple
of weeks to implement a solution that resolves our dilemna
Click to expand...

Have you tried working with the rate tables in Project? This should let
you specify which rate table to apply to a given assignment.

Check it out.
 
G

Gary L. Chefetz [MVP]

Jon:

In addition to Brian's sound advice, keep in mind that Project is designed
to do costing not billing. If you use more than five billing rates for any
resource, you will not be able to model this in Project/Project Server
without some customization.
 
Top