in

 

Project reporting using RAG and % complete

Last post 07-13-2007 8:28 AM by John Filicetti. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 06-08-2007 2:17 AM

    Project reporting using RAG and % complete

    Guys, I have just prepared a project reporting tool using Excel with the following fields:

    Task
    Start date
    Actual start date
    % complete
    RAG Status
    Owner

    My manager is having probs understanding why I have only used 25%, 50%, 75% 95% and 100% in the % complete as data validation.

    Can anyone point me in the right direction to explain to her, comprehensively why its only 25% etc? Rather than 1% to 100%? I cant imagine anyone in my team having to assess that their task is only 13% or 83% complete!

    Thanks!
  • 06-08-2007 7:06 AM In reply to

    Re: Project reporting using RAG and % complete

    You ask an interesting question and without knowing your update process, it seems people may be updating with 25%, 50%, 75%, and 100%. An ARE report could expose more information and I would draw from the work entry table instead of the fields you are reporting on. I have placed a number of ARE reports in the Files are you may want to try.
  • 06-11-2007 2:00 PM In reply to

    • AmyBrat
    • Top 200 Contributor
    • Joined on 11-02-2006
    • Albuquerque, NM
    • Posts 4

    Re: Project reporting using RAG and % complete

    Here's how I have explained it. And it really does depend on the industry you're in. Unless you are doing something that is very measuralbe, task percent complete is difficult to accurately report. Some people estimate based on the duration of time so that if I have a 10 hour task and I have worked 1.5 hours then I must be 15% complete. Some others go to the extreme and say that if a task is started it immediately goes to 50% complete, to mean In Progress. 0% obviously is Not started and 100% is complete. Best practice is to use the percent completes you listed above, although I've not seen the 95% used very often but I understand you to mean that it is almost done. This is why the % complete based on time doesn't always work well because it could take you 9 of the 10 days to get to 95% complete and then another 10 days to get it all the way to 100% complete.

    here is an interesting article

    http://rjmtech.blogspot.com/2006/01/how-percent-complete-is-that-task.html

     

    Hope this helps

  • 07-13-2007 8:28 AM In reply to

    Re: Project reporting using RAG and % complete

    Amy,

    Interesting insight.  When I am looking for task update metrics; I usually look for % complete on the work, and the duration only if I have scheduled things tightly. A 5 hour (work) task could be given 5 days of duration due to work conflicts. 

    As long as the task doesn't exceed duration, I am looking for the actual time (work) spent on the task.  The resource may complete the task in 2 hours or 8 hours of work and can report % complete on the work.  If they complete the 5 hour task in 5 hours of work and 3 days duration, I still consider it 100% complete.  If they complete the 5 hour task in 20 hours and in 20 days, it is also 100% complete.  Duration shouldn't be a factor in % complete, it should be a factor in Schedule Variance because the actual finish dates will be different and will affect subsequent tasks. 

Page 1 of 1 (4 items)

Navigate: Home | Blogs | Forums | Solution Library  Get Help:  Contact | Feedback | FAQ   Terms of Use:  Terms & Conditions | Privacy Policy