Earned Value Calcultion based on Cost1 field

[Syahril Alfian]

Before knowing MS Project I used to use MS Excel doing the scheduling and
cost estimating.
After getting the Total Estimate Cost, I calculate the Contingency Allowance
cost, say 10% from the Total Cost, then I get the Grand Total Estimate Cost
by summing both cost. I applied contingency allowance calculation to
cover/anticipating any small materials that not calculate/include in the
calculation.
Now I can do that in MS Project, I insert Number1 field or Text1 field to
put my contingency allowance number, and then I insert Cost1 field, rename it
as Grand Total and apply a formula that using contingency allowance number
for each task. The formula I use: Grand Total(Cost1)
=[Cost]+([Cost]*([Number1]/100)).
The PROBLEM is Earned Value Analysis/Calculation can only based on the cost
in “Cost†column, CAN NOT be based on my Grand Total (Cost1), or Cost2, Cost3
and so on.
I WISH this can be done in the next version of MS Project, like there is
option to based Earned Value either on % Complete or Physical % Complete,
Baseline1, Baseline2 and so on thru the menu Tools-Options…..,
Schedule-Earned Value…..

Thanks,

Syahril Alfian

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...8eb0-ff1434aa80a2&dg=microsoft.public.project

 

[Jim Aksel [MVP]]

We add a contingency task to the baseline as a separate work package and let
that roll up to total cost. If someone wants to transfer $$ out of
contingency we create a cost task for that amount and a similar "new scope"
task in the work package that receives the funds.

There's mroe to it than just the EV. For example, you should be asking if
the money coming from contingency is allowing the other work package to have
(1) An authorized increase in EAC with no change to basline (BAC), (2) Are
you authorizing an increase to the receiving workpackage BAC (new baseline),
or (3) is there a new work package required.

I have a white paper that discussess a similar topic as releated to items in
a risk register. Check my blog at www.msprojectblog.com , select MS Project
Tips then scroll down to the paper on Risk Register. It gives you more
detail on what I discussed here.

HTH

Jim Aksel