Consolidating data multiple projects setup advice

stratis63

New Member
Joined
May 30, 2012
Messages
7
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
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,181,058
Messages
5,927,882
Members
436,575
Latest member
Tiger750

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top