One worker, two groups with two pay rates

[CynthiaM]

How do I enter a resource with the same name who does two different jobs
(groups=Camera and Tape) and the two jobs have different day rates (Cam =
$300, Tape=$350)?

I entered ID: 1, Name: Joe Smith, Group: Camera, Per Use: $250 as one resource
and ID: 2, Name: Joe Smith, Group: Tape, Per Use: $300 as another resource

The Assign Resource dialog box will only assign the first Joe even if I
click assign on the second Joe, or filter by group=tape and assign that Joe.

 

[Salilu]

Split your Gantt (windows-> Split) to display the resource form in the lower
half. Note that there is ID field in all the resource forms. Enter the ID (
1 and 2 ) for 2 Joe Smiths ( Let MSP fill the Resourec Name field)

 

[Steve House [Project MVP]]

That's a classic example of the use of the Rate Tables feature - in fact, I
use almost exactly that example - Mary Ann who can serve as either an AD or
a Camera Assistant on a film shoot - in my classes. Go to the Resource
Sheet. Joe Smith should have only ONE entry, not two, in the resource sheet
otherwise Project won't be able to tell if you've double booked him on
different tasks occuring at the same time. Doing it the way you have really
fouls up the whole resource allocation functions. Double click on his ID
number on the left to display the Resource Information Form. You'll see
there are 5 rate tables there - the entrys from the regular resource sheet
populate Rate Table A with his standard rate, OT rate, and cost per use.
For simplicity use this table for the rates for his primary function,
perhaps Camera. Select the tab for Rate Table B and on it enter the std,
ot, and cost per use rates for his secondary function, pehaps that's Tape.
When you assign him to tasks Project will use the rates from Table A by
default to determine the costs. But you can then display your choice of
either the Task Usage or Resource Usage view, double click the ID number for
the assignment to display the Assignment Information form, and select the
rate table to be used for that specific task.

Be careful you understand how Cost per Use tallys into the cost of a task.
If you have Joe working as a Camera Operator at $250 per use, the budget is
assesed $250 for each time he is assigned to a task regardless of how long
that task takes - $250 per setup or per shot depending on how well you break
down the shot plan. If he is assigned to 5 days of filming entered as 1
task running for 5 days duration, the total cost will be $250. But if that
same shoot is carried in the plan as 5 individual 1-day setups, the cost is
5*$250 or $1250 even though the total duration of the work is exactly the
same. Make sure that accurately describes your actual situation. If those
rates represent day rates for a crew member, I'd recommend you consider
entering those as his Standard Rate so the estimated cost is calculated
based on the time spent working rather than the number of different tasks
he's assigned to. Otherwise you could easily have someone who actually gets
paid $250 a day hitting your budget at $500 because he's done one setup in
the morning and another the afternoon of the same day.

Hope this helps


--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs