Resource cost in Gantt view

[bing]

I would like to be able to see the cost of a particular resource by task in a
column of the Gantt view. Is this possible?

 

[John]

I would like to be able to see the cost of a particular resource by task in a
column of the Gantt view. Is this possible?

Bing,
Yes and no. If you only have one resource assigned per task then the
cost in the Cost field is the data you want (assuming the task does not
also have material cost). If you have more than one resource assigned to
a task, the only way to display an individual resource's cost on the
Gantt Chart view is via VBA.

However, take a look at the Task Usage view. It will show cost by
resource assignment for each task. You won't have a Gantt display but
you will have the cost detail broken out.

John
Project MVP

 

[Projectability]

Bing,

If you want to identify the Resource Cost on a task in Microsoft Project you
could consider using a custom cost field that has the following formula
[cost]-[fixed cost] this will deliver the resource cost element on a task,
if you have more than one resource assigned it will be the cost of all
resources and does not break down. Having given the custom field and
appropriate name you could add it to the existing cost table.

If you are using Project 2007 the Assign Resource Dialogue box will display
the cost for each resource assigned to the task you have selected.

Another option to view this information would be to go Window Split and in
the form in the lower half of the screen [right clikc] and elect to show the
resource cost form.

I hope this helps.

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

www.projectability.co.uk

 

[bing]

Thanks for the feedback. I do have more than one resource on tasks, so I
solved it by writing a VBA macro that searches for the particular resource on
a task and sets Cost1 equal to the assigned cost for that task.
task.Cost1 = task.Assignments(i).Cost

Bing,

If you want to identify the Resource Cost on a task in Microsoft Project you
could consider using a custom cost field that has the following formula
[cost]-[fixed cost] this will deliver the resource cost element on a task,
if you have more than one resource assigned it will be the cost of all
resources and does not break down. Having given the custom field and
appropriate name you could add it to the existing cost table.

If you are using Project 2007 the Assign Resource Dialogue box will display
the cost for each resource assigned to the task you have selected.

Another option to view this information would be to go Window Split and in
the form in the lower half of the screen [right clikc] and elect to show the
resource cost form.

I hope this helps.

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

www.projectability.co.uk

Bing,
Yes and no. If you only have one resource assigned per task then the
cost in the Cost field is the data you want (assuming the task does not
also have material cost). If you have more than one resource assigned to
a task, the only way to display an individual resource's cost on the
Gantt Chart view is via VBA.

However, take a look at the Task Usage view. It will show cost by
resource assignment for each task. You won't have a Gantt display but
you will have the cost detail broken out.

John
Project MVP