Separate total personnel and material cost?

[Adrian]

Each resource is either of "work" or of "material" type and as such, they
have have a price per hour or per piece/use. So far, so good.
For my project (for reasons of billing), I have to list the costs for
personnel and for material resources separately, for tasks as well as for the
whole project. So, are there columns like this (two columns, that add up to
the "total cost"-column), and if there are not - where/how could I create an
individual column, or where would I find information about this?

I appreciate your held and thank you in advance.
Adrian

 

[Mike Glen]

Hi Adrian,

I don't see an easy way for this as the field "Type" is a Resource field and
cannot be seen in a Task view. I can only suggest that you use a Flag field
in the Task Entry table and manually insert a Y or N if the task is Work.
You can then have cost fields for where Flag=Y and another for Flag=N.
However, there might be an easier way through vba. Try posting on the
developernewsgroup. Please see FAQ Item: 24. Project Newsgroups. FAQs,
companion products and other useful Project information can be seen at this
web address: http://www.mvps.org/project/.

Mike Glen
Project MVP

 

[John]

Adrian,
I see a couple of choices. Labor cost is pretty straightforward, Work
hours X Pay Rate and it is calculated in the Cost field. Material cost
can often be simply listed as a single sum (assuming it is not time
related). The best way to enter this value is in the Fixed Cost field.
It can be accrued at the beginning, end or prorated over the Task
Duration.

If you need to see Labor cost separately, simply create a custom cost
field with the labor formula (you will need to either manually enter the
Pay Rate in a separate custom field or use a macro to populate a field
with the Pay Rate since it is a Resource field and not available
directly in Task views). The Fixed Cost field will show non-time related
material cost and the normal Cost field will show the total cost for
both labor and non-labor. Set up a view table with all three field side
by side and you will have a complete breakout.

If you do have time related material (e.g. fuel cost), I suggest you
create a separate sister task to the labor. They can be linked with a
Start-to-start relationship and given the same Duration (or you could
even create a hammock task in case the Duration changes with labor
assignments).

Hope this helps.
John