Please HELP....or tell me if excel cannot handle this....

Hi, I am trying to comeup with a simple solution to plan my team
resources. I have 2 teams with different rates/location and a fixed
budget.
I have created 4 columns
Team1, Team 2, total hours and Total

Each team will have x number of resources. total worked Hours and Total
budget is Fixed (for example) $100000
I need help with the formula so I can increase numbers under team one
and it auto adjust team 2 so it matches the total. i.e. I may have 1
full time resource working for 2080 hours (full year) at $10 per hour
under team 1..so my team 2 should auto adjust the number required 2.55
resources @ $15/hr for 2080 hours. (so changing team 1 number auto
changes team 2 numbers so the total remains constant at 100000)

Any suggestions..I want to play out few scenarios

Thank you,


--
anasir
------------------------------------------------------------------------
anasir's Profile: http://www.excelforum.com/member.php...o&userid=30207
View this thread: http://www.excelforum.com/showthread...hreadid=499183