BCWS vs B'H'WS

[Elvis]

We do not load cost in our schedules based on legal and company proprietary
rules. Instead we use a BHWS and BHWP in the scheduling group. Of course
those hours are costed in a financial system which mirrors the work spread in
MS Projects timephased view.

The problem is, as an analyst i'd like to have visible, next to Projects %
Work Completed, a field that displays the hours that should have been
completed by the current date (or status date); Basically a BHWP or BHWS
field.

Since at the detail tasks our hours are level loaded, I can write the
formula to provide the data I am looking for but I am concerned at the
summary level the formula does not provide an accurate number since on the
summary level the hours are not level loaded as a result of timescale spreads
overlapping, etc.

Any help on getting the summary number for this BHWS concept is greatly
appreciated.

 

[Jan De Messemaeker]

Hi,

Work is correctly totalled at Summary task lebvel regardless of overlapping.
Duration isn't but that you do not need do you?

Greetings,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Rod Gill]

How about assigning all resources a rate of $1/hour then use normal BCWS and
BCWP? $ would then match hours exactly

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

We do not load cost in our schedules based on legal and company
proprietary
rules. Instead we use a BHWS and BHWP in the scheduling group. Of course
those hours are costed in a financial system which mirrors the work spread
in
MS Projects timephased view.

The problem is, as an analyst i'd like to have visible, next to Projects %
Work Completed, a field that displays the hours that should have been
completed by the current date (or status date); Basically a BHWP or BHWS
field.

Since at the detail tasks our hours are level loaded, I can write the
formula to provide the data I am looking for but I am concerned at the
summary level the formula does not provide an accurate number since on the
summary level the hours are not level loaded as a result of timescale
spreads
overlapping, etc.

Any help on getting the summary number for this BHWS concept is greatly
appreciated.


__________ Information from ESET Smart Security, version of virus
signature database 4963 (20100321) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4963 (20100321) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Elvis]

I am pretty sure this would work Rod, but in my case where the schedule is
already baselined, I would need to rebaseline every task so the costs get
added to the baseline and could be measured in the BCWS & BCWP fields. To
that point, I would need to somehow get my scheduled start and finish to mach
the current baseline and then set the baseline after adding the cost of 1
dollar per hour for each reasourse... correct? I am not sure I am willing
to work that hassel unless there is an easy way to back out status, reset
start and finish to original baseline and proceed witht he rate idea.

thanks for the idea though.