Only two things it could be... the total hours or the rates. The total work
shown on the resource sheet (or resource usage view) must match the total
work on the Gantt chart (or Task Usage View).
Look at these things.
First, on the Gantt Chart view make sure the "work" column is inserted.
Also, turn on the Project Summary Task (Task 0)... Tools/Options/View (tab);
check the box to show the project summary task. The value of "work" for Task
0 is the total work in the whole file. If you insert the cost column, the
cost on Task 0 is the file total cost.
Go to the Resource Sheet (the one listing all your resources and where you
keyed the rate). On the resource sheet, also insert the "work" column and
the cost column. On this sheet, you will need to manually total the work and
multiply by the rate. It should match the cost column on a resource by
resource basis. When you total them up the cost/work should match what you
have on the Gantt Chart for Task 0.
If they do not match up, go to the Resource Usage View (View/Resource Usage
View). Here, insert the "work" and "cost" columns on the left side of the
sheet. On this view you should be able to reconcile the total work assigned
for each resource back to the Resource sheet.
Look at the Task usage view. (View/Task Usage) This is a "cousin" view to
the Resource Usage view. Here you will see the spread of hours for each
task. Insert the cost and work columns on the left just like you did the
other three times. From here, you should be able to reconcile back to the
Gantt View and verify no resources are assigned to the summary tasks.
So, I've sent you to 4 places and had you insert cost and work columns on
all those views. Your problem will have to show up somewhere. My personal
guess is that when you look at the resource sheet you are using a different
value for the hours.
One other place you can look. If you have escallated rates you will
manually calculate a lower total cost because you'll be tempted to use the
present work rate shown.... yet that rate might increase after some magic
date (like 1/1/2010). To see if this is the case, go to the resource sheet
and double click on a resource. Pull the cost tab and look at the smaller
tabs A,B...E and see if you have dates and revised costs in any of those.
Gut check tells me probably not, you would already know if you have those
unless you inherited the file. Besides, you state your problem runs in the
opposite direction.
Also, you mention the Resource Chart (I assume you mean Graph). This is not
the most accurate place to get information (notice I never sent you there,
favoring the Resource Usage View instead). What happens on the resource
usage chart is the max value of assignment is shown even if it only occurrs
for 1 minute during the time frame defined on the horizontal axis. That
might also be the cause of your error.
see if that helps you reconcile it. If not, post back and maybe I can take
a look at the file. Gut check tells me to agree with Mike -- summary
resources that you may have missed. However, Project would handle that
consistently and it would reconcile (it is a logic error, not a calcuation
error). See where that takes you. It seems nearly impossible for it not to
reconcile.
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com