Monthly Material Charge

M

Mark

How do I get Project to allocate an even monthly charge, like Software
Maintenance over the life of the program.

I've tried to prorate a Fixed Cost, but it spreads it according to the days
in each month, not evenly (same charge) for each month.

Can this be done?

Thanks...
 
J

Jan De Messemaeker

Hi Mark,

I would add a recurring task (recurring monthly) and attach the cost to that
one.
HTH
 
M

Mark

Jan,

Thought about that, but with 120 months and possibly 40 SW maintenance line
items, that would create a rats nest quickly.

Any other suggestions?

Thanks...
 
J

Jan De Messemaeker

Hi Mark,

Yes, there is an alternative using a VBA procedure but it's not trivial.
VBA in the TimescaleData method "knows" the true calendar months.

An idea to avoid messing up existing Project fuiles would be to create the
120 times 40 file separately and link it to the real file through a resource
pool such that you could "switch off" the presence of these 4800 tasks and
open the pool when necessary to view the total cost.
HTH
 
S

Steve House [MVP]

I think I would avoid entering it as a time-phased charge all together. A
charge has to be a charge for something, it doesn't exist in a vaccum and in
a project plan it is associated with specific tasks or groups of tasks. An
example that comes immediately to mind would be monthly rental on office
space that movie company has to rent while on location in a foreign city.
The bills come every month, but the reason for the rental in the first place
is the need to do the work of the group of tasks that create the requirment
for having an office to work in. If we didn't do those administrative
tasks, we wouldn't need an affice, and those costs would evaporate. The
costs should thus be charged to the project budget over the dates that the
work takes place on the tasks at hand, not the dates that the bills arrive
or the cheques are cut to pay them. This is, IMHO, a demonstration of the
fact that MSP is not a financial management application but rather a work
scheduling application. If you need to attribute charges in some other way
than "cost of work performed as it's being done" you need to hand that cash
flow management part of the job over to the accounting department and a real
accounting application.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top