Changing cost rate table for a resource midstream on a task. RRS feed

  • Question

  • How do we change the cost rate table on a resource assignment when the resource's cost changes midstream on a task????

    e.g If i have assigned resource 'xyz' on a task 'pqr' which is a task for 40 hrs , the resource was supposed to work as per cast rate table A on that task but due to some issues it goes on standby and at that time cost rate table B is used and after standby is over it again starts to work as per cost rate table A.

    10hrs - Cost rate table A.

    1 hr - Cost rate table B.

    30 hrs - Cost rate table C. 

    Total work changed from 40 to 41 hrs.

    In this case how do we change the cost rate table midstream on a Task.

    Thanks & Regards

    Atul Lal

    Monday, April 22, 2013 11:23 AM

All replies

  • Are you not using the "Effective Date" field to control the costs? That could be used to define the effective date of a particular cost/table

    Sapna Shukla

    Monday, April 22, 2013 11:30 AM
  • The screenshot below shows how you could change the resource rate from £40 to £45 per hour, with an effective date for the change. The £40 rate has no effective date, meaning it applies from the start of the project until the next rate is effective. 

    Hope this helps,


    Monday, April 22, 2013 12:35 PM
  • Hello Atul Lai,

    Sorry - the cost rate tables are per assignment and unless as Sapna says, you are able to define the specific date of the rate change the only option I see is to split the assignment into three pieces - one for each Cost Rate Table.  The issue with using the effective date - is that will apply to all tasks.

    If the resource did switch between two rates - is it possible to assign the 1 hour at an overtime rate?  Your text says A to B to A - but the list shows 3 rates tables.


    Monday, April 22, 2013 12:36 PM
  • The situation that I am facing is as follows;

    A drilling rig has different kinds of operational rates like movement,drilling,stand-by etc.

    lets say these are R1,R2,R3 etc. for the same 'Drilling Rig'.

    Now as per the actual plan the Rig was supposed to drill a well in 40 hrs , but due to some operational issues it goes on standby/maintenance for a few hrs and then again resumes work after a few hours (may be on the same day) .

    Now as per the initial planning cost rate table A(=R1) was applied to the task but during execution we need Cost rate table B(=R2) or C(=R3) to be applied mid-stream for some time and then again apply cost rate table A(=R1).

    Can we achieve this??

    Thanks & Regards


    Tuesday, April 23, 2013 4:37 AM
  • No. Any one assignment can only have one cost rate. You can't assign the same resource to one task more than once, so you need to create new tasks for the restarted sections and use the relevant Cost Rate Table.

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

    Tuesday, April 23, 2013 10:08 AM
  • For that scenario, I would assign the rig to three simultaneous tasks: Move, Drill, and Standby.  Each task assignment has the appropriate rate table assigned.  Planned work is 40 hours for Drill and 0 for the others.

    Record actual hours against the tasks as work progresses: Drill for a few hours, then a few hours of Standby, then a few more hours of Drill.

    Reid McTaggart – DeltaBahn Vice President
    Blog | Twitter | LinkedIn Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you. This can help other community members reading the thread.

    Tuesday, April 23, 2013 6:49 PM
  • And, if you are using the calculated schedule, the Standby task would have no successors.
    Wednesday, April 24, 2013 3:16 PM