Revenue in Project

[Brian]

Newbie question, so I apologize: Does any know how to
easily track revenue in Project? I have a number of
projects that we bill when we send a deliverable (which I
have defined as a milestone in Project) and I would like
to assign a revenue to each of the deliverables. That
way, I can track the cost of the resource utilization
required for each deliverable versus the revenue
associated with each deliverable.

Any help wouuld be greatly appreciated.

Thanks,
Brian

 

[Steve House]

The short answer is ... you don't. Project is good for estimating the
project budget and comparing actual to planned expenses but it is not
designed and should not be expected to serve as a replacement for your time
and billing systems or accounts receivable reporting. You can use some of
the user defined cost or numeric fields to record revenue information and
others to set up calculations to compare revenues to costs but I'd be very
careful with what you do with that information. There are lots of things
that go into a P&L besides just the per task resource costs that Project
tracks - facilities costs, general overhead, etc for example - and Project
essentially ignores them. The creation of the deliverable is represented by
a summary task, with all actual activities being subtasks. The summary task
rolls upo the subtasks costs into a total. The milestone for the
deliverable being, well, delivered, is also a subtask of the summary that
creates it. It has no cost itself since no resources are assigned and at
zero duration it has zero wortk. But it can have an entry in the user
defined field holding the revenue. That too rolls up to the summary, so when
we look at the summary we see both the rolled up cost field and the revenue
field.

 

[Jan De Messemaeker]

Hello,

Make the delivery of the deliverable a milestone not a summary task
In any task view insert a column called Cost1 (or cost2...)
Customize the column call it Revenue
Be sure the rollup is sum (that way you cannot enter dat on summary lebvel
so this is why you have to enter the revenue on a task level not summary)

You could add another cost column showing Revenue less cost call it profit

HTH