Prev: Replacing Resource Assignments
Next: duration and work what is the difference
From: Craig on 8 May 2008 15:57
I'm a newbie, but I've looked around and can't find the answer.

I would like to build a WBS with hours by task and subtask which are
totaled. Also, the hours by resource are totaled and multiplied by the
hourly cost of the resource. Any ideas?
Appreciate any suggestions.

Thanks,
Craig
From: JulieS on 8 May 2008 17:15
Hello Craig,

1) If you create tasks and indent to create subtasks you have the
first step.
2) Link the tasks as appropriate to drive the schedule of the tasks
3) Create resources and assign standard rates to those resources.
4) Assign resources to the subtasks to generate work. The summary
task will automatically total the work of the subtasks.
5) The cost will be calculated by work * rate = cost. The subtasks
will have work and cost, the summary tasks will add all the work and
costs for you.

I suggest taking a good read of fellow MVP, Mike Glen's excellent
series of articles on using MS Project. You can find the link to his
articles and other useful information at:

http://project.mvps.org/mike's_tutorials.htm

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

"Craig" <Craig(a)discussions.microsoft.com> wrote in message
news:13F8C3BF-AE50-4CE3-B140-2F3F9CA25F89(a)microsoft.com...
> I'm a newbie, but I've looked around and can't find the answer.
>
> I would like to build a WBS with hours by task and subtask which are
> totaled. Also, the hours by resource are totaled and multiplied by
> the
> hourly cost of the resource. Any ideas?
> Appreciate any suggestions.
>
> Thanks,
> Craig


From: Craig on 8 May 2008 18:04
Thanks for the reply. I've done those steps. I wasn't clear enough with my
question.

I'm looking for a report that provides:
WBS Task # | Task Name |
| Resource Name | Hours | Cost

"JulieS" wrote:

> Hello Craig,
>
> 1) If you create tasks and indent to create subtasks you have the
> first step.
> 2) Link the tasks as appropriate to drive the schedule of the tasks
> 3) Create resources and assign standard rates to those resources.
> 4) Assign resources to the subtasks to generate work. The summary
> task will automatically total the work of the subtasks.
> 5) The cost will be calculated by work * rate = cost. The subtasks
> will have work and cost, the summary tasks will add all the work and
> costs for you.
>
> I suggest taking a good read of fellow MVP, Mike Glen's excellent
> series of articles on using MS Project. You can find the link to his
> articles and other useful information at:
>
> http://project.mvps.org/mike's_tutorials.htm
>
> 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
>
> "Craig" <Craig(a)discussions.microsoft.com> wrote in message
> news:13F8C3BF-AE50-4CE3-B140-2F3F9CA25F89(a)microsoft.com...
> > I'm a newbie, but I've looked around and can't find the answer.
> >
> > I would like to build a WBS with hours by task and subtask which are
> > totaled. Also, the hours by resource are totaled and multiplied by
> > the
> > hourly cost of the resource. Any ideas?
> > Appreciate any suggestions.
> >
> > Thanks,
> > Craig
>
>
>
From: JulieS on 8 May 2008 20:36
Hi Craig,

Due to the wonders of newsgroup formatting, it's not too clear what
you are looking for as far as the format.

The left side of the Gantt chart view is the Task Sheet. If you
change the view to only show the task sheet, you could create a custom
table to combine the fields you have listed and apply that table to
the view. To create the table choose View >Tables > More Tables.
Select a table (Entry is a good start) and choose Copy. Give the
table an appropriate name. Apply the new table to the task sheet and
then add and remove columns (fields) as needed.

All of the fields you want already exist in Project:
WBS
Task Name
Resource Names
Work (Hours)
Cost

You can then just print the view for your report.

Sorry if I've missed again.

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


"Craig" <Craig(a)discussions.microsoft.com> wrote in message
news:F7F87CCB-01C2-4840-B990-111C99ECE081(a)microsoft.com...
> Thanks for the reply. I've done those steps. I wasn't clear enough
> with my
> question.
>
> I'm looking for a report that provides:
> WBS Task # | Task Name |
> | Resource Name | Hours |
> Cost
>
> "JulieS" wrote:
>
>> Hello Craig,
>>
>> 1) If you create tasks and indent to create subtasks you have the
>> first step.
>> 2) Link the tasks as appropriate to drive the schedule of the tasks
>> 3) Create resources and assign standard rates to those resources.
>> 4) Assign resources to the subtasks to generate work. The summary
>> task will automatically total the work of the subtasks.
>> 5) The cost will be calculated by work * rate = cost. The subtasks
>> will have work and cost, the summary tasks will add all the work
>> and
>> costs for you.
>>
>> I suggest taking a good read of fellow MVP, Mike Glen's excellent
>> series of articles on using MS Project. You can find the link to
>> his
>> articles and other useful information at:
>>
>> http://project.mvps.org/mike's_tutorials.htm
>>
>> 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
>>
>> "Craig" <Craig(a)discussions.microsoft.com> wrote in message
>> news:13F8C3BF-AE50-4CE3-B140-2F3F9CA25F89(a)microsoft.com...
>> > I'm a newbie, but I've looked around and can't find the answer.
>> >
>> > I would like to build a WBS with hours by task and subtask which
>> > are
>> > totaled. Also, the hours by resource are totaled and multiplied
>> > by
>> > the
>> > hourly cost of the resource. Any ideas?
>> > Appreciate any suggestions.
>> >
>> > Thanks,
>> > Craig
>>
>>
>>


 | 
Pages: 1
Prev: Replacing Resource Assignments
Next: duration and work what is the difference