Overhead apportionment

Hi Sally

How are you getting on with your overhead tracking in Project? I've been thinking of other ways of tracking the overhead figure. I'm not sure if this meets your requirements but I hope it helps:

In the resource sheet the resource usage sheet view insert a column and choose the cost1 field (assuming this isn't being used for something else in your project).

Right click on the column you have just inserted and choose customize fields.

From the dialog box that appears click on the formula button

(We are creating a custom formula to multiply total work for this resource by a notional overhead rate. The result will be put into the new column we have created.)

In the formula box enter:

([work]/60)*2

Work is calculated in minutes so dividing by 60 results in the number of hours allocated. If you want to track how many days have been assigned divide by 480.

2 is my notional overhead figure. Change this depending on whether you are calculating days or hours.

I hope this makes sense and comes closer to the kind of calculation you are looking for. Let me know how you get on.

Kind regards,

Andrew