Visual Earned Value Over Time Report

[Anna]

I'm working in MS Project 2007 and the service pack is installed.

When I try to generate an earned value over time report by going to
reports/visual reports/excel/earned value over time report/view, then
clicking on Assignment Usage with EV tab, I am receiving 0 values.

If I double click the Q2 it will drop down the weeks. If I double click the
items listed under type in the Pivot table field list, the
only value showing is under costs.

How do you get the values to read under the planned, earned and actuals
columns?

 

[Jack Dahlgren]

First, you need to assign resources to tasks within your project with costs
associated with them.
Second you need to set a baseline. Have you done that?
Third, you need to set the status date. Have you done that?
Finally you need to update the tasks with actual work done.

Then the reports would be valid.

-Jack Dahlgren

 

[Anna]

Hi Jack!

Resource have been assigned to the tasks. Cost have been entered in the task
sheet under Fixed Cost because The costs are lump sum and not hourly.

Should I enter the cost in the Resource sheet under fixed cost next to the
resource it's assigned to?

The baseline and staus dates have been assigned as well.

What do you mean by actual work done? % Complet? Physical % Complete? or 5
Work Complete? or actual against remaining duration?

 

[Jack Dahlgren]

Anna,

There are a number of ways to enter progress so that % complete is updated.
You get to choose how you want to do that. The earned value calculation
method can be configured to use either % Complete or Physical % Complete and
also which baseline to compare against. You can set that by going to tools
menu/options/calculation tab and click the "Earned Value" button.

Have you updated your fixed costs with the actual costs to date?

Planned cost should come from the baseline
Actual cost should come from the actual cost
Earned value is based on % complete (either regular or physical) x planned
cost.

-Jack Dahlgren

 

[Anna]

I have the Earned Value Method set at % Complete. I only have one baseline.
and that was the one I chose by going to tools menu/options/calculation tab
and click the "Earned Value" button.

As far as fixed cost with actual, no I have not updated. I thought that was
calculated automatically through Project. When I go to view/tables/ more
tables/ earned value, the information is already calculated with the
exception of the CV (Cost Varience) field.

When I go to the visual earned value over time report the planned, earned,
and actual fields are 0 values.

Is there a table like the task or resource sheet or a view Task/resource)
that I should be in before clicking on reports to get those values to show
the correct values on the visual report?

 

[Jack Dahlgren]

That earned value report only appears to work with resource based costs. You
can make a cost resource and assign it to the task to work around the issue
of fixed costs.

-Jack Dahlgren