#1
|
|||
|
|||
Average Billing Rate
I am trying to figure out the average billing rate based on the 'Assignment Units' rate. If I have 2 resources working on a task each at 50% but their billing rates are different, then the average billing rate would be somewhere between their individual billing rates. I want to take this average and divide it by a fee to determine number of hours available to spend on the task.
Is there an easy way to calculate this because it seems resource tabs and task tabs cannot be inputted into each other. Thanks |
#2
|
|||
|
|||
I'm not sure I follow. Divide the total cost for the task by the hours to get the rate per hour. The number of hours on the task is in the Work field.
|
#3
|
|||
|
|||
If I follow correctly, this isnt really a Project problem.
From what you say, you have 2 resources (man A and man B, say) who both spend equal time on each task. The cost for each is £A and £B. You have an amount of money- the fee- call it £X. You want to know how many hours man A and man B can put into each task without the fee being exceeded. If this is correct, I would suggest excel as a better alternative. If man A and man B put the same amount of time into each task, then the cost for each hour of the task is £A + £B (both are working on it so the total hourly cost is found by adding them together). You then have £X that cannot be exceeded. Divide this by the total hourly cost , so you have £X/(£A+£B) and that tells you how many hours they can spend on each task. If I have read it wrong, please clarify and we will see if we can sort it out |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Total Hours * hourly rate | medavidcook | Excel | 7 | 06-04-2015 09:29 AM |
Formula to determine Earned Hourly Rate | phowe43 | Excel | 2 | 06-02-2015 05:51 AM |
Cost Rate Table Macro Help | JohnTurner | Project | 1 | 01-27-2014 07:53 AM |
Help: Very low response-rate! | Jeff10 | Office | 6 | 12-17-2013 10:44 AM |
Monthly Growth Rate Formula | meggenm | Excel | 2 | 04-22-2013 09:21 PM |