Re: Report of estimated % complete.
- From: "Steve House [Project MVP]" <sjhouse.remove.this@xxxxxxxxxxxxxxxxxxx>
- Date: Sun, 17 Apr 2005 07:43:00 -0400
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.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs
"DaveFusion" <DaveFusion@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:131A2235-12AA-44C3-818F-88F0EBBA31D5@xxxxxxxxxxxxxxxx
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" wrote:
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" <DaveFusion@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message
de news:B0AC7730-5DEA-4437-B184-A2C6315CBFD8@xxxxxxxxxxxxxxxx
> 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
.
- References:
- Report of estimated % complete.
- From: DaveFusion
- Re: Report of estimated % complete.
- From: Gérard Ducouret
- Re: Report of estimated % complete.
- From: DaveFusion
- Report of estimated % complete.
- Prev by Date: Re: Project 2002 weighing subtasks
- Next by Date: Re: suggestions on free Gantt software
- Previous by thread: Re: Report of estimated % complete.
- Next by thread: show deleted tasks compared to baseline
- Index(es):
Relevant Pages
|
