Allocating a different cost for an additional team in the same res

[Selgamal]

dear All,

I have the following problem that i need to solve.

I have a certain resource where if i use upto 400% of it the charge would be
70$ per hour. However, if the usage exceeds 400%, each additional 100% (i.e.
team) sall be charged at 120$ per hour.

Any idea how can i reflect this in MS Project 2007.

Thank you

 

[John]

dear All,

I have the following problem that i need to solve.

I have a certain resource where if i use upto 400% of it the charge would be
70$ per hour. However, if the usage exceeds 400%, each additional 100% (i.e.
team) sall be charged at 120$ per hour.

Any idea how can i reflect this in MS Project 2007.

Thank you

Selgamal,
If you want this to happen automatically I'm afraid it will take some
VBA. You can do it manually however by creating an additional resource
for the surcharge. Call it "Resource Part A", or similar. If a task only
uses up to 400% of the original resource, it will accrue cost at the
$70/hr rate. However, if the task is going to take more than 400%,
assign both the original resource and resource part a.

Hope this helps.

John
Project MVP

 

[vanita]

Hi

While defining resources database in Resource sheet view you can create
different Rate tables for a particular resource. Double click on the resource
name, the Resource Information box will open, in that go to Costs tab.

For your example if resource can be assigned two rates create two rate
tables. Then assign resources to activities. By default 'Rate A' is assigned.
After resource assignment go to Resource usage view and whichever assignment
is above 400% and you need to assign a different rate select that assignment,
right click, Assignment information box will open and there select different
Rate for this assignment.

I hope it helps.
Vanita

 

[Rob Schneider]

Perfect answer. All about the project and not Project.

--rms

www.rmschneider.com

 

[Ammar Al-Saket]

Hi Selgamal,

If you would consider units over 400% as overtime you could do it manually
as follows:
On the Resource Sheet view type Max Units. 400%, Std. Rate $70 and Ovt. Rate
$120.
On Task Usage view, table side, insert [Overtime Work] column, and on the
left side insert [Overallocation] row and then zoom out to get the total of
overallocated hours for a specific resource under certain task.

Type total overallocated hours under [Overtime Work] column, the program
will calculate regular hours, up to [400%], at $70 and the rest at $120.

I hope that works for you!

A. Al-Saket

 

[Selgamal]

Dear All
Thank you for your answers

I think i need to make my self clear .. the same resource is used by
multiple tasks. i need it to use the fifth team only if the cummulative usage
excceeds 400%

Any Help ?

Hi Selgamal,

If you would consider units over 400% as overtime you could do it manually
as follows:
On the Resource Sheet view type Max Units. 400%, Std. Rate $70 and Ovt. Rate
$120.
On Task Usage view, table side, insert [Overtime Work] column, and on the
left side insert [Overallocation] row and then zoom out to get the total of
overallocated hours for a specific resource under certain task.

Type total overallocated hours under [Overtime Work] column, the program
will calculate regular hours, up to [400%], at $70 and the rest at $120.

I hope that works for you!

A. Al-Saket

dear All,

I have the following problem that i need to solve.

I have a certain resource where if i use upto 400% of it the charge would be
70$ per hour. However, if the usage exceeds 400%, each additional 100% (i.e.
team) sall be charged at 120$ per hour.

Any idea how can i reflect this in MS Project 2007.

Thank you

 

[John]

Dear All
Thank you for your answers

I think i need to make my self clear .. the same resource is used by
multiple tasks. i need it to use the fifth team only if the cummulative usage
excceeds 400%

Any Help ?

Selgamal,
You're welcome. From my viewpoint you were clear the first time and my
first response is still applicable.

As Vanita noted Project has up to five different rates per resource. In
addition you can have multiple timephased rates in each of those five
rate tables. However, Project does not automatically support what you
want/need to do. So as I said before, it will take some VBA to automate
it or you will simply have to manage your project and make the necessary
rate adjustments manually.

John
Project MVP

Hi Selgamal,

If you would consider units over 400% as overtime you could do it manually
as follows:
On the Resource Sheet view type Max Units. 400%, Std. Rate $70 and Ovt.
Rate
$120.
On Task Usage view, table side, insert [Overtime Work] column, and on the
left side insert [Overallocation] row and then zoom out to get the total of
overallocated hours for a specific resource under certain task.

Type total overallocated hours under [Overtime Work] column, the program
will calculate regular hours, up to [400%], at $70 and the rest at $120.

I hope that works for you!

A. Al-Saket

dear All,

I have the following problem that i need to solve.

I have a certain resource where if i use upto 400% of it the charge would
be
70$ per hour. However, if the usage exceeds 400%, each additional 100%
(i.e.
team) sall be charged at 120$ per hour.

Any idea how can i reflect this in MS Project 2007.

Thank you

 

[Selgamal]

Dear All


Thank you for your help.. we did it manually at the end

thanks anyways

Dear All
Thank you for your answers

I think i need to make my self clear .. the same resource is used by
multiple tasks. i need it to use the fifth team only if the cummulative usage
excceeds 400%

Any Help ?

Selgamal,
You're welcome. From my viewpoint you were clear the first time and my
first response is still applicable.

As Vanita noted Project has up to five different rates per resource. In
addition you can have multiple timephased rates in each of those five
rate tables. However, Project does not automatically support what you
want/need to do. So as I said before, it will take some VBA to automate
it or you will simply have to manage your project and make the necessary
rate adjustments manually.

John
Project MVP

Hi Selgamal,

If you would consider units over 400% as overtime you could do it manually
as follows:
On the Resource Sheet view type Max Units. 400%, Std. Rate $70 and Ovt.
Rate
$120.
On Task Usage view, table side, insert [Overtime Work] column, and on the
left side insert [Overallocation] row and then zoom out to get the total of
overallocated hours for a specific resource under certain task.

Type total overallocated hours under [Overtime Work] column, the program
will calculate regular hours, up to [400%], at $70 and the rest at $120.

I hope that works for you!

A. Al-Saket


:

dear All,

I have the following problem that i need to solve.

I have a certain resource where if i use upto 400% of it the charge would
be
70$ per hour. However, if the usage exceeds 400%, each additional 100%
(i.e.
team) sall be charged at 120$ per hour.

Any idea how can i reflect this in MS Project 2007.

Thank you

.

 

[John]

Dear All


Thank you for your help.. we did it manually at the end

thanks anyways

Selgamal,
You're welcome. Obviously Project doesn't have the functionality that
meets the needs/wants of all users. Sometimes you just have to go with a
workaround. However VBA is included with Project and that added
functionality can make a whole world of difference - virtually anything
is possible. If you don't know VBA but would like to learn, you should
consider getting fellow MVP, Rod Gill's book on the subject. You can
find out more at, http://www.projectvbabook.com.

Hope this helps.

John
Project MVP

Dear All
Thank you for your answers

I think i need to make my self clear .. the same resource is used by
multiple tasks. i need it to use the fifth team only if the cummulative
usage
excceeds 400%

Any Help ?

Selgamal,
You're welcome. From my viewpoint you were clear the first time and my
first response is still applicable.

As Vanita noted Project has up to five different rates per resource. In
addition you can have multiple timephased rates in each of those five
rate tables. However, Project does not automatically support what you
want/need to do. So as I said before, it will take some VBA to automate
it or you will simply have to manage your project and make the necessary
rate adjustments manually.

John
Project MVP

:

Hi Selgamal,

If you would consider units over 400% as overtime you could do it
manually
as follows:
On the Resource Sheet view type Max Units. 400%, Std. Rate $70 and Ovt.
Rate
$120.
On Task Usage view, table side, insert [Overtime Work] column, and on
the
left side insert [Overallocation] row and then zoom out to get the
total of
overallocated hours for a specific resource under certain task.

Type total overallocated hours under [Overtime Work] column, the
program
will calculate regular hours, up to [400%], at $70 and the rest at
$120.

I hope that works for you!

A. Al-Saket


:

dear All,

I have the following problem that i need to solve.

I have a certain resource where if i use upto 400% of it the charge
would
be
70$ per hour. However, if the usage exceeds 400%, each additional
100%
(i.e.
team) sall be charged at 120$ per hour.

Any idea how can i reflect this in MS Project 2007.

Thank you

.