A
AndrewO
All,
At my company we have two budgets we must adhere to - a project based
budget, and a department based budget. The sum of all work charged to
the project budgets must equal the department budget. This is
calculated on an annual basis.
So let's say the Project Management department has 3 members, so I
have 36 staff months of budget. However, this department budget
resets each calendar year, while the project budget does not.
So if we have project A, B, C, D, E, and F; each of which spans over a
two year period, and each of which has 1 staff year of Project
management assigned to it.
Each year PM 1 will spend .5 years on Project A and .5 years on
Project B; PM2 will spend .5 years on Project C and .5 years on
Project D; and PM3 will spend .5 years on Project E, and .5 years on
Project F.
I set up 6 tasks in MS Project, one task for the PM activities on each
project like so: Each task has a duration of 24 months and a work of
12 months; each PM is assigned two tasks at 50%.
I go to the Resource Usage sheet, and I look at the entry for PM1.
His "work" is 24 months, which is true. Project has even helpfully
spread the work out somewhat evenly across the months of 2009 and
2010, so that the PM is working ~ .5 months on each project, per
month.
If you're still with me, what I need is a way to display sum of all
the work scheduled to be completed by these 3 PMs scheduled within a
certain year. I need to make sure the work being done by the "PM
Team" during 2009 does not exceed the annual department budget of 3
staff years. Yes, PM1's work is 24 months, but 12 months of it is
scheduled to happen in 2009. Filters do not change the totals shown
in the Resource Usage view, they just hide some of the data. No
matter what I do, PM1's work is always 24 months.
I have thought of creating another resource, PM1_2010_BUDGET - and
splitting the task into two: 2009 PM and 2010 PM, and then assigning
each to a different resource. I think that will work, but it seems
like a kludge.
Any MSP experts out there got any ideas?
At my company we have two budgets we must adhere to - a project based
budget, and a department based budget. The sum of all work charged to
the project budgets must equal the department budget. This is
calculated on an annual basis.
So let's say the Project Management department has 3 members, so I
have 36 staff months of budget. However, this department budget
resets each calendar year, while the project budget does not.
So if we have project A, B, C, D, E, and F; each of which spans over a
two year period, and each of which has 1 staff year of Project
management assigned to it.
Each year PM 1 will spend .5 years on Project A and .5 years on
Project B; PM2 will spend .5 years on Project C and .5 years on
Project D; and PM3 will spend .5 years on Project E, and .5 years on
Project F.
I set up 6 tasks in MS Project, one task for the PM activities on each
project like so: Each task has a duration of 24 months and a work of
12 months; each PM is assigned two tasks at 50%.
I go to the Resource Usage sheet, and I look at the entry for PM1.
His "work" is 24 months, which is true. Project has even helpfully
spread the work out somewhat evenly across the months of 2009 and
2010, so that the PM is working ~ .5 months on each project, per
month.
If you're still with me, what I need is a way to display sum of all
the work scheduled to be completed by these 3 PMs scheduled within a
certain year. I need to make sure the work being done by the "PM
Team" during 2009 does not exceed the annual department budget of 3
staff years. Yes, PM1's work is 24 months, but 12 months of it is
scheduled to happen in 2009. Filters do not change the totals shown
in the Resource Usage view, they just hide some of the data. No
matter what I do, PM1's work is always 24 months.
I have thought of creating another resource, PM1_2010_BUDGET - and
splitting the task into two: 2009 PM and 2010 PM, and then assigning
each to a different resource. I think that will work, but it seems
like a kludge.
Any MSP experts out there got any ideas?