Re: Costs for phases with tasks overlapping phases

Tech-Archive recommends: Speed Up your PC by fixing your registry

In article <1163422334.253257.175110@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
"king kong" <kay_schulz@xxxxxxxxx> wrote:

Hi John

Kay,
There are various ways to spread project management across the whole
project. However, I take issue with your statement that the costs for
tasks 1 and 2 are not sufficient to adequately describe the cost for
analysis. The way your file is structured, tasks 1 and 2 are the ONLY
tasks that comprise the analysis phase. If you really want a "piece" of
project management to be included with each phase then you will need to
add a separate little project management task to each phase. That's the
way hierarchy works.
This is not what I want. I need it later, but for my first cost
estimations and effort
estimations I cannot split them. I can just roughly say how much I
think I will do
during the running time of the project.

However, I'm not sure that what you are asking is really what you want.
Normally, project management and other "support" type activities are
shown under their own summary (pretty much like you show it). An overall

top summary line is then shown (Tools/Options/View tab - Show project
summary task) to get a top level picture of duration, work, cost, etc.
This is what I meant initially.

for the whole project. You can then look at the Task Usage view and see
the timescaled cost spread in various periods of time. So for example,
the the period during which the analysis phase is being performed, you
can see the total cost which will include analysis unique tasks and
project management during that period.

I can't. Which does not mean Project can't. It means I can't.
In the task usage view I do not the numbers for a certain time period
summarized.
E.g. for phase analysis I see the time but I cannot see a calculation.
It looks like this
Summary Task Work Duration Start Finish Inidvidual Days such as
M T W T F
Analysis 100hrs 20d 1.11. 1.12. 2.3hrs 2.5hrs
4.3hrs .....
ProjectMgmt 200hrs 100d 1.11. 1.10. 3.4hrs 3.4hrs
.....
But I do not see the project management efforts for this time period.
And I do not see the overall costs for this period
Sorry.
I do not understand how I can see:
Phase Analysis costs 123.456 CHF.
Or:
1.11. - 1.12. costs X CHF

I tried to use filters with Date Range between 1.11. 1.12.
No help.

Kay,
In my first paragraph I was simply explaining how hierarchy works. It
may not be what you wanted but that's how you set it up.

With regard to using the Task Usage view, it looks like you are getting
what you should although you show hours instead of cost. It may just be
a matter of how to interpret the data. If the time period (i.e.
duration) of the analysis phase falls on even weekly or monthly periods,
then set the timescale for weeks or months. In that case the cost rollup
will give you what you want directly. However, if the phase does not
start and/or end on week or month breakpoints, then you may have to set
the timescale for days and either add up the values for the time period
manually or use the Cumulative Cost timescaled field to display the
values.

If the above seems like too much effort, you can try using the "analyze
timescaled data in Excel" utility found on the Analysis toolbar. Export
the Cost field from the Task Usage view and summarize the time period
data in Excel with a formula. An alternative is a custom macro that adds
up the costs for the exact time period desired and then puts that data
into a spare field or exports the data to another application. Note: you
cannot filter fimescaled data and you cannot use a formula in a custom
field for timescaled data, the desired values must either be added up
manually or VBA must be used.

John
Project MVP
.

Relevant Pages

  • Re: Costs for phases with tasks overlapping phases
    ... what you should although you show hours instead of cost. ... If the time period (i.e. ... then set the timescale for weeks or months. ... timescaled data in Excel" utility found on the Analysis toolbar. ...
    (microsoft.public.project)
  • Re: Costs for phases with tasks overlapping phases
    ... Each phase has a clear end milestone, but group project management ... There are various ways to spread project management across the whole ... summary task) to get a top level picture of duration, work, cost, etc. ...
    (microsoft.public.project)
  • Re: Costs for phases with tasks overlapping phases
    ... There are various ways to spread project management across the whole ... but for my first cost ... summary task) to get a top level picture of duration, work, cost, etc. ...
    (microsoft.public.project)
  • Re: Simultaneous access/update to MS Project plan
    ... I resisted for reasons of cost, complexity to get up and running. ... "Enterprise Project Management". ... But that can't happen since the Dept must use the standard ... > Why are you resisting the urge to suggest using MS Project Server? ...
    (microsoft.public.project)
  • Re: Earned Value Analysis
    ... Actual cost - used for currency ... Principal, Oak Associates, Inc, www.oakinc.com "Advancing the Theory and Practice of Project Management" ... The nicest thing about NOT planning is that failure comes as a complete surprise and is not preceded by a period of worry and depression. ... >>Mark Durrenberger, PMP ...
    (microsoft.public.project2000)