Report of estimated % complete.

[DaveFusion]

Guys & Gals,
I have a request to produce a report which shows 'what the % complete should
be if all tasks are running on schedule'.

The only way I could think of doing this would be manually 'update to
schedule' all tasks, then Copy/Cut the % complete column, close the plan
without saving ( or possibly use the undo function ), paste the vales into a
user defined column and then print out.

I'm sure somebody out there has some natty little tool or macro that could
do all this for me at the touch of a mouse - if you're that person please let
me know !!!

Thanks

 

[Gérard Ducouret]

Hello Dave,
Why not use the Earned Value data : what you want is almost the BCWS,
compared with the BCWP and the ACWP.
Have a look in the Help for these fields.

Gérard Ducouret

 

[DaveFusion]

Thanks for that,
I've alloacted a 'cost' to each of my resources, and shown the 'earned
value' colums you quote in my 'Task' view.

However, the 'cost' of each task now has a value, but the columns you quote
are all set to £0.00

How do I get it calculate what amount of the Task Cost should have been
used, and what amount has actually been used ?

 

[Gérard Ducouret]

Dave,
For the Earned Value calculation, Project needs 2 references :
- a baseline : You'll create it by Tools / Tracking / Save Baseline / OK
- a Status Date : Project / Project Information / Status date : the date
where tracking data was collected

Gérard Ducouret

 

[Steve House [Project MVP]]

BCWS represents the amount of work that should have been done up to the
status date, expressed in terms of its expected costs. BCWP represents the
amount of work that actually WAS done up to the same status date, also
expressed in terms of what you planned to pay for it. ACWP is the amount
you actually DID pay to get that work done. It's broken down this way to
allow you to track performance against both schedule and budget
independently. BAC is Budget At Completion, the total expected cost of
doing all the work. It's the same number as Baseline Cost. So BCWS/BAC
represents the % Work Complete you should have achieved by the status date.
BCWP/BAC represents the % Work Complete you actually did achieve by the
status date. BCWP/BCWS give you SPI, Schedule Performance Index - <1 means
you're behind and >1 means you're ahead.

For consistency, make sure you understand there is a very big difference
between % Complete and % Work Complete. % Complete refers to duration but %
Work Complete refers to, well, work. How could they be different? It
happens whenever you have work contours. You have a task that starts Monday
at 8am and finishes Friday at 5pm. It's applying paint where there has to
be overnight drying time between coats. The resource puts in 1 hour each
day on Mon, Tue, Wed, and Thur applying the initial coats and then does all
the finish work on Fri taking 8 hours. Duration is 40 hours, total work is
12 hours. It is now 5pm Thursday and everything is on schedule. % Complete
= 4d/5d or 80%, % Work Complete = 4h/12h or 33% % Physical Complete -
essentially meaningless concept in this case IMO.