Results 1 to 4 of 4

Thread: MS Project - actual vs planned vs delivery

  1. #1
    Join Date
    Aug 2011
    Posts
    2

    MS Project - actual vs planned vs delivery

    I am new to MS Project. I have simple scenario and want to know how to accomplish in MS Project 2010.

    Scenario Example:
    Estimate delivery = 5 days
    Estimate work effort = 2 days (ie 16 hours spread across 5 days)
    Actual work effort = 12 hours

    **What I want achieve:
    1. Keep track of the progress ie actual work effort (for resource monitoring)
    2. Track the billable amount to client = 2 days vs actual effort (incase we underestimate)
    3. Keep track of the delivery time, to ensure we meet delivery time, although we have 3 days buffer.

  2. #2
    Join Date
    Nov 2005
    Posts
    625

    Re: MS Project - actual vs planned vs delivery

    You can create an autoscheduled task with 5 days duration. (Project will calculate the end date). Set a deadline equal to your "buffer". Temporarily set the task as fixed duration.

    Create a resource or resources and set their rates. The challenge is which rate to use -- the rate you charge the client or the internal rate what it costs you. You can use rate tables but you can only apply one rate per assignment at a time.

    With the task as fixed duration -- assign the resource and specify 16 hours of work. Project will calculate the assignment units (visible in the Peak Units field added to the Task Usage view) and spread the 16 hours of work evenly across the 5 day duration.

    Save a baseline.

    Track the actual work which will calculate the variance between what you thought (16 hours) and what is recorded. Tracking will enable you to also project new end dates (remaining work) as well as be alerted when you pass a deadline.

    Project is not particularly good for a "billing" product. I would keep an Excel spreadsheet to record billing data.

  3. #3
    Join Date
    Aug 2011
    Posts
    2

    Re: MS Project - actual vs planned vs delivery

    Thanks, that's great help!

    What if I also have subtasks? can I distribute the number of hours defined in the main tasks to the subtasks evenly?

    Example:
    Main Task Estimate work hours = 2
    There are 4 subtasks attached to it.

    Can project auto calculate the subtasks to 30mins each? If so, how can I set this?

  4. #4
    Join Date
    Nov 2005
    Posts
    625

    Re: MS Project - actual vs planned vs delivery

    You're welcome.

    As to the new question - no, I'm afraid it actually works in reverse. The summary tasks ("Main Task" in your example) will add up all of the work from the subtasks. Summary tasks should not have resources assigned to them -- so plan from the lower level up.

Similar Threads

  1. Planned % Complete - Enterprise Field in Project Server
    By Stelladee in forum Microsoft Project
    Replies: 4
    Last Post: 14-05-2012, 07:42 PM
  2. Replies: 1
    Last Post: 25-12-2011, 01:05 AM
  3. Planned vs Actual Work and % complete
    By bigboy in forum Microsoft Project
    Replies: 3
    Last Post: 09-07-2009, 06:28 AM
  4. Planned vs. Actual
    By Pine Le in forum Microsoft Project
    Replies: 2
    Last Post: 11-04-2009, 01:22 AM
  5. MS Project - Work planned to date
    By AtunRa in forum Windows Software
    Replies: 3
    Last Post: 08-01-2009, 02:34 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,512,468.83334 seconds with 17 queries