Invoicing through CPM schedule

u can make a dummy resoucre (for example u define all of the BOQ items complete with their unit rates), then you assign each activity with the budgeted qty. of the resource (from tender).

Then when u make an update and apply actual qty. you can make a tabular report which shows the actual cost (even weekly or monthly).

Mr. Karim
Thanks for the reply. I’ve a one more doubt that while printing histograms out how can I hide this dummy resource.
Regards
Dinesh

Dinesh,

if u get me correctly, When u apply actual qty. of the BOQ items on their relevant activities then the report (tabular / graphical) will show u the actual cost which have been obtained from the actual qty. multiplied by the unit rate of the BOQ item.

so when u print the histogram , actually it will show u the actual cost (money unit), and if u print in P3 e/c it won’t show u anything at all on the top of the histogram !

Dinesh,

I think your method should work already with what you need for the time being. However, you might have limited capabilities in generating other reports like answering a question, How much is the material,labor and equipment components of your current earned value?

In my opinion, defining resources with cost is very important as it gives you so much protection for claims, among other purposes. However, care must be given into account if you have more than one currency used in the contract BOQ. It will give you a little difficulty in deriving the exact contract amount due to convertion factors and updating the earned values as it is possible that a variance will occur if you do it in excel.

Being new in using V5, I hope that my comments make sense to you and to all.

Regards,

Arman

Friends
Do you completely depend on Primavera for cost monitoring and billing or keep a parallel database in Excel sheet? I’d like to know please..
Dinesh

Actually it depends on the project’s type (whether it is Lumpsum or Unit Rate), mainly we use Excel sheets for invoicing in Unit Rate Projects and Primavera progress for invoicing in Lumpsum projects.

Dinesh,

Karim’s point is very logical on various reasons.I had that experience of a unit rate project where the engineer required an invoice with documentations both using excel and Primavera. Both had to be perfect and to be reported on a regular weekly & monthly basis.Excel is coming from the QS department and Primavera from the Planning dept.It came out to be a huge challenge to demonstrate the capabilities of Primavera software and the people who used it as well.

Regards,
Arman

Hi
Thanks for the response. Slightly differing from the subject - I’d like to know the technique to print Resource histogram department-vise. If I create a resource breakdown structure as shown below
Company
Company.Civil
Company.Civil.Mason
Company.Civil.JCB Operator
Company.Mechanical
Company.Mechanical.Welder
Company.Mechanical.Fitter
Can I print histogram for Civil dept? (not individual Mason & JCB oprator histograms but together)

yes it is very simple actually, when u are in Tracking mode u see a window that shows the resources in the project and in it there is "Resource ID & Resource Name" columns.

To select multi resources u press "ctrl" while clicking on the desired resoucre, note also that u can make a graphical report for multi WBS showing multi resources using the prevouis method.

Thanks Karim I got it...

Hi Friends
How can I get the calender duration in the WBS heading if I define a 5 or 6 day calender for activities under it? For example I want to display 730 days (od) where start is 1-jan-07 and end date is 31-dec-08; now Primavera Project management is showing original duration in WBS heading as 627 days!!
Dinesh

Dinesh

- Duration in the WBS heading depend on What are the Global Calendar when you Schedule, so if you want to display 730 days where start is 01.Jan.07 and finish is 31.Dec.08, you have to set The Global Calendar is: 7 days Workweek.
_ The Global calendar in Primavera Project Management in your PC may be set is 6 days Workweek Calendar, so WBS heading Original duration is 627 days, this is logical!

Cheers,

Tu Huynh Van
Is there any method to assign a 7-day global calender to WBS heading & a 6-day calender for activities under it?
Dinesh

Dinesh,

- For Global Calendar, in Activities layout, select Enterprise/Calendars/Global, and choice 7-day Calendar.
- For activities under it, The calendar will be assigned for each activity. To assign, select General tab in Activity detail, and choice the correct calendar for each activity in "Activity calendar".

Tu,

Hi all,
If we go to Project menu >WBS(in Primavera Project management)we can assign ’Est Weight’ to WBS code/name. Can somebody tell how PM uses this weights in Calculations? My intention is to cost load with WBS milestone weights in a new Project coming up.
Dinesh

Mario Sanvitile, Means these Est Weights has no role in calculating the earned values. Is that right? Dinesh