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. 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,

Azim