In summary, I will be extracting information out of various teams with regards to what work/projects we have open at the moment and also what's coming up in the next year. I will then find out from the development team leaders how many resources are currently being used and then forecast how many will be needed for the coming year. I guess the forecasting is something I will need to do with assistance of the development team leaders?
I will then need to present my headcount predictions/capacity plan to the senior management team and advise them on how to fill in the gaps (hire staff) and utilise current skills in the best way.
What do you think is the best way to construct and present this capacity plan to senior management? Some sort of spreadsheet format?
I've checked with all our Project Managers to see if they carry out a similar exercise at the beginning of each of their projects to work out tasks vs resources however none of them follow a consistent approach or have anything I can use as a template/guideline for me to develop in to a bigger plan.
What format do you suggest I present this in as they won't buy any of the available software out there to do this but at the same time it has to look good as they will be basing some of their recruitment decisions on this?