How to get Resource Hours Cost

[boni]

Hi,

I need actual work and actual cost of a resource in a project for a
particular task. I am getting actual cost from time sheet data in table
"Msp_View_Proj_Assn_tp_by_day" of Project Server 2003 database.

The problem is when I update the standard rate of a resource using Microsoft
Office Project 2003 and republish the project information; cost information
against tasks is updated using recent standard rate, as it does preserve the
cost/resource rate history.

For example if standard rate of Steve Masters is $70/hr and he works 8 hours
on a particular task then I get the cost $560.00. When i update the standard
rate to $80/hr and republish the project then i get the cost $640.00 for the
same task.

However the previous data should not be updated after revising the standard
rate. Is there any way that after updating the standard rate of a resource,
cost information of old task remains the same?

 

[JulieS]

Hi Boni,

I'm not a server guru, so I'm afraid I can't delve deeply into the
effect on the server side.

But to answer your question, yes, you can change resource rates based on
date. If you double click on a resource's name in Project 2003, click
the Costs tab. On the A tab (default cost table) in the second row enter
the effective date and the new rate(s). This will only change the cost
for work performed on or after the effective date. Any tasks scheduled
before the effective date will remain at the old rate.

I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[boni]

Hi Julie,

Yes, this is exactly what I need.
Thanks.

 

[JulieS]

You're welcome and thanks for the feedback.

Julie

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project