Total Resource Cost

First let me set the stage.

I have created my resource sheet to include an hourly standard rate per
resource.


On tasks that require multiple resources, I want the system to add the total
sum verses coming with an average. Example four resources @ $50 per hour
should show a total cost of $200.00 for a one hour activity verses the
average of $50.


(Iâ??ve set my template to â??fixed durationâ??)



How can I get the system to show total sum verses average?

JulieS
Tue Jan 10 14:34:34 CST 2006

Hi Walter,

Project does not perform an average function for total cost. I think what
may be tripping you up is the amount of *work* that each resource is
scheduled to do on the task. By setting the task to fixed duration but
leaving the task as an effort driven task, project keeping the original
amount of work stable and drops the assignment units for each resource
added. Because project calculates costs by work * rate, it appears as
though project is averaging the cost.
To illustrate:
Split your screen from the Gantt chart (Window > Split) to show the task
form at the bottom.
Create a 1 day duration task, and in the task form selected fixed Duration,
and keep the check in effort driven. Click OK. When you assign the first
resource at 100%, 8 hours of work is calculated on the one-day duration
task. When you add a second resource, the duration remains at 1 day and
because the task is effort driven, the total amount of work remains the
same -- 8 hours -- and each resource's assignment units drops to 50%. The
tasks still costs the same because the amount of work (8 hours) is the same.

Create another 1 day duration task, fixed Duration but non-effort driven.
For each resource assigned, project just calculates an additional 8 hours of
work. The cost of the task increases as you add additional resources.

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

Julie
"Walter Isley" <WalterIsley@discussions.microsoft.com> wrote in message
news:BAC7071E-D994-4BDF-A61E-08627D77EACC@microsoft.com...
> First let me set the stage.
>
> I have created my resource sheet to include an hourly standard rate per
> resource.
>
>
> On tasks that require multiple resources, I want the system to add the
> total
> sum verses coming with an average. Example four resources @ $50 per hour
> should show a total cost of $200.00 for a one hour activity verses the
> average of $50.
>
>
> (I've set my template to "fixed duration")
>
>
>
> How can I get the system to show total sum verses average?
>
>

WalterIsley
Tue Jan 10 14:50:02 CST 2006

Thanks JulieS,

This looks good. I'll give it a shot.

"JulieS" wrote:

> Hi Walter,
>
> Project does not perform an average function for total cost. I think what
> may be tripping you up is the amount of *work* that each resource is
> scheduled to do on the task. By setting the task to fixed duration but
> leaving the task as an effort driven task, project keeping the original
> amount of work stable and drops the assignment units for each resource
> added. Because project calculates costs by work * rate, it appears as
> though project is averaging the cost.
> To illustrate:
> Split your screen from the Gantt chart (Window > Split) to show the task
> form at the bottom.
> Create a 1 day duration task, and in the task form selected fixed Duration,
> and keep the check in effort driven. Click OK. When you assign the first
> resource at 100%, 8 hours of work is calculated on the one-day duration
> task. When you add a second resource, the duration remains at 1 day and
> because the task is effort driven, the total amount of work remains the
> same -- 8 hours -- and each resource's assignment units drops to 50%. The
> tasks still costs the same because the amount of work (8 hours) is the same.
>
> Create another 1 day duration task, fixed Duration but non-effort driven.
> For each resource assigned, project just calculates an additional 8 hours of
> work. The cost of the task increases as you add additional resources.
>
> I hope this helps. Let us know how you get along.
>
> Julie
> "Walter Isley" <WalterIsley@discussions.microsoft.com> wrote in message
> news:BAC7071E-D994-4BDF-A61E-08627D77EACC@microsoft.com...
> > First let me set the stage.
> >
> > I have created my resource sheet to include an hourly standard rate per
> > resource.
> >
> >
> > On tasks that require multiple resources, I want the system to add the
> > total
> > sum verses coming with an average. Example four resources @ $50 per hour
> > should show a total cost of $200.00 for a one hour activity verses the
> > average of $50.
> >
> >
> > (I've set my template to "fixed duration")
> >
> >
> >
> > How can I get the system to show total sum verses average?
> >
> >
>
>
>

JulieS
Tue Jan 10 14:59:24 CST 2006

You're welcome Walter and thanks for the feedback. Please post with
additional questions should you need to.

Julie
"Walter Isley" <WalterIsley@discussions.microsoft.com> wrote in message
news:80AC4287-3CC4-4F0E-85A9-86F9854E9CB0@microsoft.com...
> Thanks JulieS,
>
> This looks good. I'll give it a shot.
>