Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2015, 10:18 AM
tbrozovich tbrozovich is offline Average Billing Rate Windows 7 64bit Average Billing Rate Office 2013
Novice
Average Billing Rate
 
Join Date: Aug 2015
Posts: 2
tbrozovich is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-09-2015, 08:27 AM
JulieS JulieS is offline Average Billing Rate Windows 7 64bit Average Billing Rate Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 08-18-2015, 04:00 PM
Guloluseus Guloluseus is offline Average Billing Rate Windows 7 64bit Average Billing Rate Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average Billing Rate Total Hours * hourly rate medavidcook Excel 7 06-04-2015 09:29 AM
Average Billing Rate Formula to determine Earned Hourly Rate phowe43 Excel 2 06-02-2015 05:51 AM
Average Billing Rate 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
Average Billing Rate Monthly Growth Rate Formula meggenm Excel 2 04-22-2013 09:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft