A
anasir
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
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