how to break out labour & material pricing in report for PROJECT

[KCK]

I am currently using MSProject

I need to produce a report that will show separate $$$ totals for labour
and also for material.

The predefined reports do not seem to be able to do this. Is there some
other way?

thanks for any help


kck

 

[John]

I am currently using MSProject

I need to produce a report that will show separate $$$ totals for labour
and also for material.

The predefined reports do not seem to be able to do this. Is there some
other way?

thanks for any help


kck

KCK,
I depends somewhat on how you entered the material. If you used the
Fixed Cost field, (and this isn't necessarily the best field for all
material), then that field will obviously have the material total. The
Cost field will be the sum of labor cost and fixed cost so you would
need to set up a custom field with a formula to subtract out fixed cost
from cost.

If you identified resources using the Type field on the Resource Sheet,
(Work for labor and Material for material), then you can easily separate
out the cost by using the Resource Usage view and the grouping function.
Group on the Type field.

Other variants of reporting are possible depending on how the resource
are assigned, (e.g. labor and material separately), what format output
you want and whether you need to be able to show costs for selected
tasks (i.e. not the whole project).

Hope this helps.
John
Project MVP

 

[JulieS]

Hi KCK,

Assuming you have created both work and material resources, one option is to
use the Task Usage view, add the Cost field to the view and create a custom
group. Go to Project, Group by > More Groups and select "New."

Give the Group a name of your choice and select "Show in Menu" to make the
Group easier to find in the future.

First Row:
Field Name: Name
Field Type: Task
Order: Ascending

Click the option: Group Assignments not tasks

Second Row:
Field Name: Resource Type
Field Type: Assignment
Order: Ascending

This will group the tasks by task name and then group the assignments by
Resource Type (work or material).

The Cost field should summarize the total cost by Task as well as by
Resource Type.

Then print the left side (table) portion of the view.

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

Julie
Project MVP

 

[KCK]

thanks for your input



If you can...i also need to isolate and print off the material list in a
report


I have created both work and material resources....i then assigned the
apprpriate number of units of material(resource) along with the labour
resource



thanks


KCK

 

[JulieS]

Hi KCK,

You're welcome and thanks for the feedback.

I'm not sure I understand what you mean by a "material list". It wounds
as though you have created the resources (both work and material) on the
resource sheet. You could filter the resource sheet to show just
material resources and print the filtered view.

What more do you need to see in the "material list"?

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

Julie
Project MVP

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

 

[KCK]

great...thanks

now I have a new one......

i have a project all laid out and have assigned labour durations to each task.

The problem is that when I assign two resources to a task, i would expect
the duration to be halved......there must be a preference setting
somewhere....

can you help with this one?

regards

KCK

 

[JulieS]

Hi KCK,

You're welcome and thanks for the feedback. To your new question:

Project will drop the duration of a task when you add an additional
resource if:

1) The task already has at least one resource assigned.

And

2) the task is effort driven - fixed work or the task is effort driven -
fixed units (the default.)

If you assign both resources at the same time, then Project will not
decrease the duration of the task.

You can easlily see task type (fixed units, fixed duration, or fixed
work) and whether the tasks is effort driven nor not by splitting your
screen (Window > Split) from the Gantt chart to display the Task Form at
the bottom.

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

Julie
Project MVP

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