Re: Track Estimated vs Actual work

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



"Best" is one of those tricky concepts, it depends on what you're trying to achieve. You can view variance values in many different tables - variances compare the values shown in the current schedule to the values saved in those same field in the baseline. My baseline says the Fidget Widget task was to start on June 1st and take 10 days. After saving the baseline we revised our estimated duration to 14 days and also the predecessor task turns out to be running late - the schedule after posting the updates and actuals shows Fidget Widget will start 10 June and take 14 days. There is about a 10-day Start Variance and 4-day Duration Variance.

Another very valuable way to compare them is through Earned Value calculations. It takes a little getting used to the concept of measuring time in dollars, but what Earned Value does is compare actual progress in terms of the work actually done by a designated reporting date, the status date, related to the work you were expecting to get done by that same date. Using resource costs insures everything gets compared in constant units and you always compare apples to apples. The Budgeted Cost of Work Performed compared to Budgeted Cost of Work Scheduled tell you is you're on schedule while Actual Cost of Work Performed compared to Budgeted Cost of Work Performed tells you if you're over or under budget. Take a look at Project's help for more details.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs



"Kevin" <Kevin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:D408073F-7996-48EE-A0A5-DBD7D284022F@xxxxxxxxxxxxxxxx
John, thanks, I thought that might be the case.

What is the best way to then compare the Baseline schedule to your current
schedule?

Thanks


"John" wrote:

In article <8D0E232F-68A2-4470-B123-91A88C53B3E7@xxxxxxxxxxxxx>,
 "Kevin" <Kevin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> Im trying to track my Estimated vs Actual work. when I enter the Actual > Work
> the Estiamted Work moves with that and therefore the whole schedule > moves.
>
> I want to be able to track my original estimates for reporting and > learning
> purposes so if I enter Actuals I dont want the Estimates to change.
>
> Is there a way to stop the estimates changing or a better way to do > this?


Kevin,
Any time actual values are entered, whether it is Actual Work, Actual
Start, etc. the corresponding estimated values will adjust to agree with
the actual value. This is normal and expected behavior. What you should
be looking at are baseline values. The purpose of a baseline is to "lock
in" the original estimate values (Work, Start, Finish, Cost, etc.) so
they will be available for comparison purposes.

After a project plan is developed and reviewed to ensure everything
plays (i.e. the end goal is doable, resources are properly assigned,
cost values meet the budget, etc.) then a baseline is set. If during the
course of actually performing the plan, major changes occur (e.g. scope
change), the original baseline can be updated or a whole new baseline
can be set (Project has the ability to track multiple baselines).

Hope this helps.
John


.



Relevant Pages

  • In favor of separating work and duration in tracking
    ... I think we do agree on:"You use the baseline and the current schedule ... together to compare the plan as it was expected to unfold THEN to what ... stick to the finish date of monday current week after entering work. ... that MSP will calculate the duration effects in the network downstream ...
    (microsoft.public.project)
  • RE: Prob a basic question...
    ... You can then compare your baseline dates to current dates. ... View/Tracking Gantt ... the respective tasks (work packages?) have changed; how do i capture the new ...
    (microsoft.public.project)
  • RE: Customized Field using Formula
    ... compared to where you should be (if you were on schedule). ... Tools/Trackng/Save Baseline. ... Your formula can compare between and [Baseline ... about Microsoft Project ...
    (microsoft.public.project)
  • RE: Customized Field using Formula
    ... compared to where you should be (if you were on schedule). ... Tools/Trackng/Save Baseline. ... Your formula can compare between and [Baseline ... about Microsoft Project ...
    (microsoft.public.project)
  • Re: Baseline issue (please help!)
    ... Open your old schedule, copy the task start / finish dates and ... paste them in the column "Baseline Start & Baseline Finish" of the new ... you save the baseline back then before starting and now want to compare ... We have a project wherein we are entering the actuals ...
    (microsoft.public.project)