Cash flow in primavera PM5

Hi,

i suggest that you still do it in excel.

Hi,

26 views without any reply. Please help

sonia

Sonia
It depends on your needs for the cash flow, so you’ll have to establish a concept by yourself. To give you an idea:

All payments must be attached to activities. You’ll have payments for a specific date (--> milestones) and payments spread over a certain time (e.g. Level of Effort). Don’t be too complicate.

Cash out:
- Man hours multiplied by price, can be one activity per role or one activity with more roles.
- Purchasing with down-payments --> milestones with expenses.
- Overhead: LoE with an expense, spread over duration
Cash in:
- Milestones in a different WBS than the other activities.
Cash in you can regard as expenses multiplied by -1.

If the project’s time-frame does change, cash flow will change accordingly.

How to print the curve? Unfortunately P5/P6 are not leading edge in graphical outputs, but you can creat a report in CSV-format which can be processed by EXCEL. --> Print-out of the curve will be in EXCEL.

This is just one idea. It will depend on your needs for %-complete as well.

Good Luck!
Dieter

Thanks Dieter,

Could you please ewplain me how to do it in Primavera?

Assuming I have only contract value that will be spread over activity duration with 1- first month advance payment 2- cost distributed as an s curve 3- Retention at the end of activity

how can i model this using primavera and then export the details to excel to allow me plotting the curve

Thanks a lot

Sonia
Let’s assume, retention to be paid after a warranty period of 12 months. You’ll have two milestones for cash in in their own WBS: Advanced and retention payment. No in-between payments?!?
"cost distributed as an s curve" is nice. It means the accumulated cost will be displayed as an s-curve, the curve for costs then is bell-shaped. Does some body want to make a fun of you? (Quelqu’un veut se môquer de toi?) This is absolutely too vague. But you’ll have freedom and can choose a curve with a flat curve to make the costs earlier. As you can’t attach expenses to a curve, you’ll have to use a dummy-resource. Assign this resource to a LoE between Project start and finish with a budget of x Dollar and attach a bell-shaped curve to this assignment. Then you’ll create a report from the group "activities" grouped by WBS.
Ask for more data. For my opinion this curve you’ll better draw manually.

Hope this helps.
Dieter

Thanks for your time

I have already the S curve data

now how can i export this to excel file ie to have the cost of each activity distributed over months following the S curve that i had already created in primavera?

Sonia
Ask your employer to join a training.

View (Left side of P6-window) "Reports" --> right mouse button --> select "ADD" --> mark "Time distributed reports" --> select "Activities" --> you’ll be guided by the wizzard, don’t forget to enter a name --> Output to ASCII will create a csv-file. For the separator you’ll have to check: mostly ;, sometimes , or blank does work.
This csv-file you can open in EXCEL.
Good luck!
Dieter

Thanks, This was very useful.

Hi Dieter Wambach

Sorry to bother you again. but when opening the report with excel, the cells are text format and I can not plot curves based on these infos. how can I have numbers?

Thanks

Hi Sonja
Check for field delimiters and text indicator. Check with different combinations.
You should open the file in EXCEL, not import.
Some time ago I had this problem as well. Unfortunately I don’t remember how I solved but I assume it was one of the above items.
Good luck!
Dieter

Thanks

I find it. you should modify the report and the click on the cell properties and uncheck "format text cell"

Thx very much