Task usage labour cost

[Mickplumb]

Is there any way in the task usage to view separate totals for the resource type labour and materials.
I have a column that shows the total cost but would like separate ones that shows labour and material total costs
I separate the labour into "work" in the type resource box and the materials into "materials" in the type box.
Thanks for help

 

[JulieInMaine]

Create a new group with the following definition:
Group by
Field Name: Outline Number
Field Type: Task
Order: Ascending
Then By:
Field Name: Name
Field Type: Task
Order Ascending
Then By:
Field Name: Resource Type
Field Type: Assignment
Order Ascending

You'll need to check the option "Group Assignments not tasks" to be able to select assignment as the field type for resource type - but it should be you what you want. Add the Cost field and you should see summary data for costs.

I hope this helps.
Julie

 

[Mickplumb]

Wow,
you like giving me stuff to think about.
Thanks for the help.
I'll let you know how I go on.

 

[Mickplumb]

I managed to add the group.
What I'm looking for though is in the task view is there a column I can insert that will give me a total for the labour costs and one for materials cost.

 

[JulieInMaine]

Add the cost column to the Task usage view, apply the group and the cost field should be showing total cost per resource type.

 

[Mickplumb]

Thanks for the help but it doesn't really give me the desired data.
When I create a task e.g.
Fit shower enclosure.
I add resources ian, and Jamie say 4 hrs each. They are a work type and their rate was added when creating the resource.
I then add resource shower enclosure that is a material type. The price of which has been added in the resource cost when setting up.
The task view then shows the total task cost. After lots of tasks like this have been added the task view shows the total of all the tasks.
I'm after a column in the task view showing the work costs and another showing materials cost.
I've had no training with ms projects and i just use the parts that suit my needs, and so maybe doing things wrong.

 

[JulieInMaine]

Sorry - but short of VBA to loop through each task - the method I gave you using grouping in the Task Usage view is your best option.

 

[Mickplumb]

Thanks,
I've customized a resource usage view to show a breakdown of materials and labour but I mostly work with the task usage view.
The time line on the right is used for adding work hrs.
I even print off a copy of the time line prior to commencing the contract as a sort of work sheet, and I fill this in as work progresses.

 

[Mickplumb]

What's a VBA

 

[JulieInMaine]

VBA is visual basic for applications - a programming language used to manipulate project data. Did you create the group in the Task usage view?

 

[Mickplumb]

Yes I did
It's not the end of the world though.
I would of liked a column showing labour costs for the various tasks.
Would it make a difference if I added the materials as sub tasks, if that's possible.

 

[JulieInMaine]

I still don't believe you can get a separate column for work versus material resource costs without resorting to writing VBA code to accomplish this. The best I can recommend is the grouping in the Task Usage view to see the breakdown of costs per task by resource type.