RE: EV Formulas

We don't use these fields for real earned value but here are the calculations:

BCWP: When a task is first created, the BCWP is $0.00. As soon as a
baseline is saved and progress is reported for the task (as actual work,
actual duration, or percentage of work complete), Microsoft Project
calculates BCWP. This calculation is based on the percentage of work
complete, as compared with the task's baseline duration. Microsoft Project
then calculates the cumulative baseline cost and provides the value of what
the task's actual costs should be, given the task's progress to that point in
the task's baseline duration.

BCWS: To calculate BCWS for a task, Microsoft Project adds the timephased
baseline costs of the task up to the status date.

ACWP: When a task is first created, the ACWP field contains $0. As
progress (percentage of completion or actual work) is reported on the task,
Microsoft Project calculates the actual cost of work performed (ACWP). This
is the cost of actual work plus any fixed costs for the task to date. By
default, how and when ACWP is calculated depend on the assigned resources'
Standard Rate, Overtime Rate, Per Use Cost, and Cost accrual settings in the
Resource Information dialog box, as well as the actual work reported, fixed
costs for tasks, and the status date or today's date. Microsoft Project can
calculate ACWP even if you do not have resources assigned. In this case, the
calculations are based on progress (percentage of completion or actual work)
and fixed costs to date for the task. If you prefer, you can have ACWP
calculated based on your entries in the Actual Cost (timephased) field. On
the Tools menu, click Options, and then click the Calculation tab. Clear the
Actual costs are always calculated by Microsoft Project check box.




"bauer172uw" wrote:

> I am looking to find the EXACT formulas that MS Project uses to calculate a
> few EV fields. I have made several posts asking for these but so far no one
> has been able to give a formula. The fields I am look for are:
>
> 1. BCWS
> 2. BCWP
> 3. ACWP
> 4. Physical % Complete - At the summary task level! I am aware that at the
> TASK level this is a user defined field, but at the summary level it is out
> of my control and is calculated for me.
>
> I am much appreciative of anyone who can supply these formulas. Please
> note: our organization uses Physical % Complete for all of our EV
> calculations. Also, our resources report progress via PWA (except sometimes
> managers will just enter 100% complete for certain tasks). Also, we are
> aware of how to set baselines, status dates, and the usual overhead for
> taking EV numbers.
>
> Thank You for any help!
>
> Mike
.

Relevant Pages

  • Re: Divorce Acutal Costs from Most Calculations
    ... the budgeted cost of the 100 widgets is $40 and the actual cost of the 100 widgets is $60. ... I think we need a "Time Card Hours" type field that is used to drive ACWP ... > or Actual Work field in later calculations. ...
    (microsoft.public.project)
  • Re: ENGLISH!
    ... Government policy is therefore blown off course by the views of an aggregate of lazy-minded people who cannot be arsed to learn anything new, and who are encouraged to remain in that state of lazy-mindedness by their low-quality newspapers. ... In the UK a longer time was allowed for the transition, ... Now that I think of it, there was one extra cost for me of having a dual ... engineering student at the time that electrical engineering calculations ...
    (alt.usage.english)
  • Re: EV Formulas
    ... Budgeted cost of work scheduled ... Description The ACWP field shows costs ... Microsoft Project can calculate ACWP even if you do not have resources ... the calculations are based on progress (percentage ...
    (microsoft.public.project)
  • Re: EV Formulas
    ... > Budgeted cost of work scheduled ... > Description The ACWP field shows costs ... > resources' Standard Rate, Overtime Rate, Per Use Cost, and Cost accrual ... the calculations are based on progress (percentage ...
    (microsoft.public.project)
  • Re: Calculating project completion %
    ... I don't see any reason not to use the definitions and calculations ... Project planning and tracking is about Cost. ... WHAT WOULD BE THE SOLUTION FOR CALCULATING PROJECT COMPLETION % ... Now lets think of a slightly different scenario: ...
    (microsoft.public.project)
Loading