I need to build a capacity planner and i wanted your input in terms what is the best way to set it up
we have 6 franchisees that at the moment each one has a team dealing with a project.
The effort is calculated in man months and from there budget is derived. Mother company decided to scrap all these teams and hire a dedicated team that will deal with these projects allocating a percentage of their tem members time every month to each project. So for budget purposes they want to present to the upper management how this capacity planner will work and i need your advice in that.
Example
Current situation
Project a. L-4 l-3 l-2 l-1. launch date (launch date - months)
Resources. 1. 2. 4. 8. 5
Imagine you have 6 project like that different in effort and time duration each one from conception to launch. They span up to 48 months duration
And now you need to build a dedicated team that would allocate every month part of their time to each project instead of the six front sizes doing their own thing.
So for example
-5 -4. -3.
Resource 1
Project a. 0%. 20%. Etc
Project b. 100%. 80%.
and then create a pivot table or dash board
That will add all effort for budget purpose
What is the best way to setup the tabs and the consolidated part. Doing in ma 9 months every different project was easy now allocating percentages and consolidated in one I'm really confused what's the best way to set it up
we have 6 franchisees that at the moment each one has a team dealing with a project.
The effort is calculated in man months and from there budget is derived. Mother company decided to scrap all these teams and hire a dedicated team that will deal with these projects allocating a percentage of their tem members time every month to each project. So for budget purposes they want to present to the upper management how this capacity planner will work and i need your advice in that.
Example
Current situation
Project a. L-4 l-3 l-2 l-1. launch date (launch date - months)
Resources. 1. 2. 4. 8. 5
Imagine you have 6 project like that different in effort and time duration each one from conception to launch. They span up to 48 months duration
And now you need to build a dedicated team that would allocate every month part of their time to each project instead of the six front sizes doing their own thing.
So for example
-5 -4. -3.
Resource 1
Project a. 0%. 20%. Etc
Project b. 100%. 80%.
and then create a pivot table or dash board
That will add all effort for budget purpose
What is the best way to setup the tabs and the consolidated part. Doing in ma 9 months every different project was easy now allocating percentages and consolidated in one I'm really confused what's the best way to set it up