Monthly Budget

[Robin Roe]

Hi,

Just wondering if anyone could advise me on the following.

Most of the projects we do are fixed fee, so we would invoice a predefined
amount every month. Is there anyway in Project to represent this. Basically I
would like to be able enter the monthly fee we have agreed to invoice (which
may be different every month) so that I can plot the cost and actual cost
against it in a report.

Perhaps this may be a job for Excel, but would like to hear any suggestions

Thanks in advance

 

[Dale Howard [MVP]]

Robin --

You could probably use a recurring task with a Fixed Cost for this purpose.
Here's how:

1. Select a cell in your project
2. Click Insert - Recurring Task
3. Name the recurring task something like Monthly Invoice and set the
Duration to 1 day
4. Set the Recurrence Pattern to Monthly and select the billing day for
each recurrence
5. Select the End After option and specify how many occurences and then
click OK
6. Expand the Monthly Invoice recurring tasks
7. Click View - Table - Cost
8. In the Fixed Cost column, enter the invoice amount for that month

You will see the total amount invoices in the Total Cost column for the
recurring task. Just a thought. Hope this helps.

 

[Robin Roe]

Thanks Dale

That's a very good starting point. I need to make sure that these don't look
like they are a project cost, so perhaps I can put the budgets figures into a
custom field.