Planning multiple concurrent and independent tasks

M

mwebergo

I have a project that is tasked with completing a current state assessment of
multiple applications (36 total apps). I have 4 business analysts charged
with completing the assessments. In estimating the work required to complete
a current state assessment we came up with an estimate of 52 hours per
application. Each assessment is an independent task. There is no
requirement for completing one before another. I would like to be able to
track the actual effort for each application so that we can refine our
estimates for the specific application for later phases of the project.

The primary factor for scheduling of the assessments is the availability of
IT and business subject matter experts for the applications. Given the
fluidity of people's schedules I don't think it is possible to accurately
pre-schedule the order of the completion of the assessments. Rather, I would
like to provide my BA's the flexibility in scheduling the assessments based
on SME availability. Similarly, I would like to be able to change the
assigned BA on a given application in a easy fashion as I expect this to
fluid as well. Essentially the BA's self select the applications they are
going to work on next. I expect the BA's will work on multiple assessments
in parallel so that if a delay in one application is encountered (such as lag
waiting for review/signoff of the assessment from the SME's) is not lost time.

Given these considerations, I am trying to come up with the best way to
setup the tasks in MS Project so that I can track earned value throughout the
entire 3 month duration of the project and report status of earned value on a
weekly basis. A couple of options I have considered:
1. Create 36 separate fixed work tasks with the work setup to match our
estimate of 52 hours. Set the duration of each task to be the total 3 month
duration of the assessment period. Essentially each of the 36 tasks
contributes a small amount of the BCWS each week whereas only those
assessments that are in progress will show the ACWP and BCWP. Seems kind of
hokey but avoids having to try to schedule or move assessments around based
on which ones actually are in progress.
2. Create 36 separate fixed work tasks with the work setup to match our
estimate of 52 hours. Set the duration of each task to the actual duration
expected for a given assessment (i.e. 1.5 weeks). Arbitrarily assign the
applications to a given time period. In this case, the BCWS will be
determined based on the scheduling of the apps but it's likely that the ACWP
and BCWP will be driven by different applications than what I scheduled.
3. Other options????

On a related note, what is the best approach for the BA assignment? Assign
all 4 BA's to each task and expect that only the one who is actually working
on it will enter his work? Don't pre-assign the BA's and only add them after
they have "signed up" for a given application?
 
R

Rod Gill

You do not really have a project, rather a set of tasks to complete a
contract rather than a specific project objective. So, I would do this all
in Excel. For each assessment have estimated hours, actual hours and
remaining hours updated weekly.
Include a field completed you set to 1 only when the assessment is done.
In another sheet, have a column per week and 2 rows per assessment.
calculate cumulative work expected hours done and actual hours done per week
with two total rows at the bottom for cumulative work expected and
cumulative work actual


Now create a graph of number of assessments complete over the 3 months. You
could also graph predicted number of assessments completed over time.
Create a second graph of cumulative predicted work over time against
cumulative actual work.

So, if actual work trends along predicted work, then your SMEs are available
and things are on time. From an EV perspective if you are also trending on
time for number of assessments complete then you can relax. Otherwise.....

You need to track number of assessments completed, will all be complete on
time and hours per assessment. Project can't easily help you with this, or
create the graph that will help most here.
--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx
 
M

mwebergo

Thanks Rod.
I agree with your assessment and in fact what you propose is very similar to
what I had created in Excel. However, my organization requires that we use
MS Project Server for time tracking purposes which is what led to me posting
the question below. Given this I guess my question still stands but I do
appreciate your advice.
 
J

Jan De Messemaeker

Hi,

Since you mention Project Server: I would assign a generic resource to the
tasksand allow the expert to change that to his name when he grabs it.
As for teh tazsks, personally I would go for the second scenario.
HTH
 
M

Mike Glen

Hi ,

Next time, please try posting on the server newsgroup. Please see FAQ Item:
24. Project Newsgroups. FAQs, companion products and other useful Project
information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top