Earned Value for Work done

[Red Rag]

Hello,
I'm using Project 2003.
Is it possible to get the Earned value (BCWS, BCWP and ACWP) for resource
Work done, to the exclusion of any "Fixed Cost" ?
Thanks for any idea,

Red Rag

 

[Steve House [MVP]]

Project 2003 has multiple baselines and you can select the one to reference
for earned value calculations. You could save your baseline to, say,
Baseline 1 before entering your fixed costs and then use that for your BCWS
and BCWP calcualtions. As for ACWP, that one is a little more difficult and
I'm
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs
still trying to figure out something there. Maybe someone else has an
idea.

 

[davegb]

Haven't tried this, so tell me if it would work. What if you used a
calculable field, subtract the fixed costs, then calculated your other
EV paramters and showed the result in a custom table. Really, you'd
just be bypassing Project's built in EV and substituting your own. But
not very complicated.

 

[JulieS]

Hi Red Rag,

I believe if you look at the assignment data in the resource usage view the
Earned Value data excludes any task fixed cost information.

Hope this helps. Let us know how you get along.

Julie

 

[Red Rag]

Hello Davegb,
To subtract the fixed costs according to the progress pro rata until a task
is completed ? I think it would be a little tough ;-(
Anyway, thanks for the hint ! I'll give it a try.

Red Rag

 

[Red Rag]

Hi Julie,

That's a good idea I think, while this view doesn't display the sum at the
project level. I'll try to adapt this idea to in export toward Excel via the
"Analyse Timescaled Data in Excel" feature.
Thanks again !

Red Rag

 

[JulieS]

Hi Red Rag,

Glad to have helped and thanks for the feedback. Let us know if we can
assist again.

Julie