report quantities and unit price for materials/labor used in a tas

[samson]

I would like to be able to report not only the total cost for each task but
also quantities and unit prices of materials and labor used for the task. Is
such reporting available?

thanks

 

[Jim Aksel]

You can use custom grouping/sorting under the project menu once you have the
appropriate columns/views displayed. It then becomes a sorting/grouping
issue.

There's not too much info here ... consider a formula in one of the custom
columns as well.

 

[Jim Aksel]

Also try using the "Task Usage View" View/Task Usage or View/More
Views/Tasks Usage.

This view gives a list of the tasks in Gantt Chart order. When you open the
task + sign, you see all resources assigned. You could turn on cost columns
as needed, custom formula columns, etc.

 

[JulieS]

Hi Samson,

Adding on to Jim's post. The Task Usage view is a start on what you are
searching for.

To the Usage table (left side) add the following fields:

Cost:
This will show total cost for the task at the task row and will show
cost per resource assignment at the assignment row.

Assignment Units
For work resources it will show the assignment units for the resource to
the task - usually in percentage
For material resources, it will show units of the material assigned as
well as the material label you defined in the resource sheet. For
example - 2 (units) gallons (material label)

Your wish to see unit pricing is a bit more complicated. The cost for
resources (both work and material) is entered in the Standard Rate
field, which is a Resource field. The Task Usage view only shows tasks
fields and assignment fields. (For more detail see FAQ 51 at the URL
under my name.)

In order to get the standard rate for each resource available in an
assignment field I had to take a couple of steps.
In the Resource Usage view, add a custom Cost field (Cost1) for example.
Customize the Cost1 field with the formula:

[Standard Rate]

This should show the Standard rate for each resource. Then create a
macro to copy the Cost1 Resource field to the Cost1 assignment field.

The macro was based on a macro by Jack Dahlgren (Project MVP). Jack's
macro can be found at:

http://masamiki.com/project/macros.htm
See his macro called Copy Task Fields

The variation on the macro to copy the Resource Cost1 field to the
Assignment Cost1 field follows:

Sub CopyResourceCostToAssignCost()
Dim r As Resource
Dim rs As Resources
Dim a As Assignment
Set rs = ActiveProject.Resources
For Each r In rs
If Not r Is Nothing Then
For Each a In r.Assignments
a.Cost1 = r.Cost1
Next a
End If
Next r
End Sub

After running the macro, if you display the Task Usage view and add the
Cost1 field, it will show the Resource's standard rates.

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

 

[samson]

Thank you for the tips.
I am checking if it would be handy to use microsoft project for construction
job quotation where some work, e.g. steel fabrication, is quoted in weight of
steel fabricated rather than hours spent on the task.
--
Samson Usagani

Hi Samson,

Adding on to Jim's post. The Task Usage view is a start on what you are
searching for.

To the Usage table (left side) add the following fields:

Cost:
This will show total cost for the task at the task row and will show
cost per resource assignment at the assignment row.

Assignment Units
For work resources it will show the assignment units for the resource to
the task - usually in percentage
For material resources, it will show units of the material assigned as
well as the material label you defined in the resource sheet. For
example - 2 (units) gallons (material label)

Your wish to see unit pricing is a bit more complicated. The cost for
resources (both work and material) is entered in the Standard Rate
field, which is a Resource field. The Task Usage view only shows tasks
fields and assignment fields. (For more detail see FAQ 51 at the URL
under my name.)

In order to get the standard rate for each resource available in an
assignment field I had to take a couple of steps.
In the Resource Usage view, add a custom Cost field (Cost1) for example.
Customize the Cost1 field with the formula:

[Standard Rate]

This should show the Standard rate for each resource. Then create a
macro to copy the Cost1 Resource field to the Cost1 assignment field.

The macro was based on a macro by Jack Dahlgren (Project MVP). Jack's
macro can be found at:

http://masamiki.com/project/macros.htm
See his macro called Copy Task Fields

The variation on the macro to copy the Resource Cost1 field to the
Assignment Cost1 field follows:

Sub CopyResourceCostToAssignCost()
Dim r As Resource
Dim rs As Resources
Dim a As Assignment
Set rs = ActiveProject.Resources
For Each r In rs
If Not r Is Nothing Then
For Each a In r.Assignments
a.Cost1 = r.Cost1
Next a
End If
Next r
End Sub

After running the macro, if you display the Task Usage view and add the
Cost1 field, it will show the Resource's standard rates.

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

I would like to be able to report not only the total cost for each task
but
also quantities and unit prices of materials and labor used for the
task. Is
such reporting available?

thanks