Cashflow, cashflow, cashflow

[Andrew]

Hi there

Sorry if this has been asked before, but I have searched the forum and not
found an answer that fits. I have been tasked to produce a cashflow for a
construction project. I know how to put the money in as a fixed cost against
each activity. I also know that you can allocate costs against the start,
finish or pro rata against the duration. No problems so far. What I am
struggling with is how do I simulate payment delays, ie you complete the work
but do not get paid for say 3 weeks later?. Also, I know how to use the
analyze timescale data in excel button, but is there a better way, that keeps
the information live ie if the contract bars move etc, without having to re
export as I find that I have to do some work on the excel file after the
export in order that the information is more readable. VBA has been mentioned
to me but I am a real novice in this and do not have the resources inhouse to
explore this. I have linked excel and MSP before and have found that the
whole thing becomes ver cumbersome and loses the connection when you relocate
files.

Any help would be appreciated

Andrew

 

[Gérard Ducouret]

Andrew,

<<you complete the work but do not get paid for say 3 weeks later?>>
You could create a milestone linked to the end of the task with a FS+3w
link, and apply the cost to that milestone.

Gérard Ducouret