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 3 columns
Team1, Team 2, and Total

Each team will x number of resources. Fixed total is (for example) $1000
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 under team 1..so my team 2 should auto adjust the number required 2.55 resources @ $15 for 2080 hours.

Any suggestions..I want to play out few scenarios

Thank you,

Azim