Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

resource loaded program not matching billing cycle

4 replies [Last post]
Thu, 2007-09-13 13:19
vikas agrawal
User offline. Last seen 4 years 38 weeks ago. Offline
Joined: 4 Aug 2007
Posts: 18
Groups: Building Information Modelling
Can anybody throw some light on how to match the billing cycle (which is 1 month later usually) with the projected financial progress.
Top

Replies

Mon, 2007-10-22 00:52
#1
Muhammad Jawad Sh...
User offline. Last seen 12 years 35 weeks ago. Offline
Joined: 21 Oct 2007
Posts: 9
Groups: None
Buddy,
Forget about matching the cashflow generated by QS and the cashflow generated by Primavera by planning engineer using resource loading.
Some projects having hundreds of small BOQ items that cannot be entered in primavera and even I as planning engineer is using hammack activity to assign lumpsum costs for maybe 10 to 15 activities in one time.
Its all matter of experience, work, watch, observe and listen to your Project Manager, thats the key to success of a good planning engineer.
Take care
Muhammad Jawad
Top
Fri, 2007-09-14 14:37
#2
vikas agrawal
User offline. Last seen 4 years 38 weeks ago. Offline
Joined: 4 Aug 2007
Posts: 18
Groups: Building Information Modelling
pls read BOW as BOQ
Top
Fri, 2007-09-14 14:36
#3
vikas agrawal
User offline. Last seen 4 years 38 weeks ago. Offline
Joined: 4 Aug 2007
Posts: 18
Groups: Building Information Modelling
i will detail out my question

The BOQ has hundreds of items. But primavera activities do not (and cannot) match those BOQ items. Somehow we manage to estimate the activity cost (budgeted cost) by manually summarizing relevant BOW items. Some error is already built in at this point.

Next, the cost loaded program is scheduled at the end of some month (say data date is end of March). The EV never matches with the amount your company billed till March end.

Of course the reason for this is very clear. Your QS applies his own % complete for item rates and exact spent on direct supplies. To complicate it further secured advances, deduction of mobilization advances, taxes etc etc make everything haywire.

As a result the EV obtained from schedule never matches the bill upto that period.

Hope some experts could throw light on this topic.
Top
Fri, 2007-09-14 10:22
#4
Oliver Melling
User offline. Last seen 4 years 29 weeks ago. Offline
Joined: 24 Apr 2007
Posts: 595
Groups: The GrapeVine
Vikas,

I do not understand the question.

Where are you tring to match the cycles?

In a financial report?

The Billing or Receipts profile will not usually match the spend profile.
As you have already stated, it is usually projected to come after the project financial spend in the programme.

The comparison of the two is what gives you the cashflow profile for the project.

Oliver
Top