Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Resource Planning - How to Model
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel question for financial model | Excel Discussion (Misc queries) | |||
Looking for a project planning template | Excel Discussion (Misc queries) | |||
Does anyone have a good resource planning template? No timesheets | Excel Discussion (Misc queries) | |||
Matching parts to model numbers | Excel Discussion (Misc queries) | |||
VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) |