How to calculate Planned hours

[optoplan]

The customer wants to measure Earned hours against planed hours. Actua
hours/work is not interesting for the customer because it is a fixe
price contract.

Earned hours I get from this formula: % work complete*Baseline Work. I
a way I guess it should be physically % complete and not % work complet
(definitely not % complete) but we would like to weight the summar
levels with hours so it makes more sense to just use the % wor
complete column since it already does this automatically.
I have made a formula for earned hours in a text field, but have no
figured out how to do it for planned hours directly in MS Project. Doe
anybody know a way to do this?

I would think that it would be possible to get planned hours in som
way. Now I do this in Excel by summarising the exported hours up t
status date. This gives me planned hours that i paste back in a M
Project text column.

Is it possible to get a column that gives planned hours at the statu
date?
I will be grateful for answers and thoughts about the mentioned way t
measure progress

 

[José Miguel Piñeres]

Hello and welcome to this Microsoft Project General Questions newsgroup!

I believe that what you are describing is related to EVM (Earned Value
Metrics), and Project is pretty good at it.

I suggest you take a good look to the following links:

http://office.microsoft.com/en-us/project/HA101567921033.aspx

and

http://office.microsoft.com/en-us/project/HP453050141033.aspx?pid=CH100788901033

Within this last page, you will find a link to the ACWP and BCWP fields
that, when compared at a resource level, can give a very good result on what
you are trying to measure, in terms of cost. To transform that to work hours,
just do the math.

I hope this was helpful to you. Please, let us know how you get along with it.

Best Regards,

 

[vanita]

Hi

As suggested by Jose you could read up on EVM. But, EVM provides earned and
planned values in terms of cost values.

If you want a report on planned hours for each week or month or even on
daily basis, you may look into 'Workload' reports through Report > Reports >
Workload. To get cumulative values upto each day/week/month, edit the report
to show 'cumulative work'.

I hope it helps.
Vanita