You are quite correct that you use the budget quantities (BOQ) to generate man hours from standard outputs.
The problem is that the BOQ items never align with the bar chart activities so they have to be summarised into totals that represent the chart.
This is relatively simple in Lotus 123 but in Excell it is a bit more complicated.
To start you need to have the budget quantities in one sheet and the bar chart activities in another.
The bar chart activities will have a unique number in the left hand column for each activity.
This unique number is then set against each element in the budget that corresponds with the bar chart.
In Lotus you can then do a simple Dsum formula to add all the hours that correspond to each number nad transfer them to the barchart.
In excell you need to sort the schedule into the number groups and then =sum each block which can then be transferred to the barchart.
It gets a little more complex when in a multi storey project and you have 20 activities for plaster and they are all measured together.
Now you have to set up a matrix in another sheet which sets down each floor and a pro rata allocation of quantities.
This ratio is then applied to the total plaster hours and allocated to each storey in your programme.
If you are using PowerProject then the resource hours can be cut and pasted in 5 seconds - in P3 however you have an afternoons work typing them all in.
The next step is to assign gang sizes and set up the resource modelling system to generate durations.
Using Lotus and PowerProject I can do a multi storey projevt in about 3 hours - P3 would take me 3 days - thank you Asta Development for the P3 > PowerProject conversion facility.
Best regards
Mike Testro
Member for
19 years
Member for19 years1 month
Submitted by BOULEKHSSAIM A… on Mon, 2008-09-15 08:20
In order to calculate your budget manhour you have to have the budget quantity for each activity, from that and through your standard manhour you convert your quantity into manhours, the total of those manhours will be your budget manhours.
this budget can be modifie, depend to drawing revision you have every time to check your quantity, and before you finalize your baseline, you must check your new quantity.
Hopefuy that my response satisfy you, if any body has more detail or other idea, ill be glad to let me know.
Take care, freinds.
Member for
17 years 3 months
Member for17 years4 months
Submitted by Athikah Hamzah on Fri, 2008-07-11 22:06
Member for
19 yearsRE: Budgeted Manhours
Hi Mike,
Thank you for that, appreciat.
Keep in touch my freind
Abderrahmane.Boulekhssaim@kbr.com
or
aerski@yahoo.fr
Member for
19 years 10 monthsRE: Budgeted Manhours
Hi Boulekhssaim
You are quite correct that you use the budget quantities (BOQ) to generate man hours from standard outputs.
The problem is that the BOQ items never align with the bar chart activities so they have to be summarised into totals that represent the chart.
This is relatively simple in Lotus 123 but in Excell it is a bit more complicated.
To start you need to have the budget quantities in one sheet and the bar chart activities in another.
The bar chart activities will have a unique number in the left hand column for each activity.
This unique number is then set against each element in the budget that corresponds with the bar chart.
In Lotus you can then do a simple Dsum formula to add all the hours that correspond to each number nad transfer them to the barchart.
In excell you need to sort the schedule into the number groups and then =sum each block which can then be transferred to the barchart.
It gets a little more complex when in a multi storey project and you have 20 activities for plaster and they are all measured together.
Now you have to set up a matrix in another sheet which sets down each floor and a pro rata allocation of quantities.
This ratio is then applied to the total plaster hours and allocated to each storey in your programme.
If you are using PowerProject then the resource hours can be cut and pasted in 5 seconds - in P3 however you have an afternoons work typing them all in.
The next step is to assign gang sizes and set up the resource modelling system to generate durations.
Using Lotus and PowerProject I can do a multi storey projevt in about 3 hours - P3 would take me 3 days - thank you Asta Development for the P3 > PowerProject conversion facility.
Best regards
Mike Testro
Member for
19 yearsRE: Budgeted Manhours
Hi Hamzah,
In order to calculate your budget manhour you have to have the budget quantity for each activity, from that and through your standard manhour you convert your quantity into manhours, the total of those manhours will be your budget manhours.
this budget can be modifie, depend to drawing revision you have every time to check your quantity, and before you finalize your baseline, you must check your new quantity.
Hopefuy that my response satisfy you, if any body has more detail or other idea, ill be glad to let me know.
Take care, freinds.
Member for
17 years 3 monthsRE: Budgeted Manhours
Hello Mike
Thanks for the info. Ill try to purchase it.
Cheers!
Member for
19 years 10 monthsRE: Budgeted Manhours
Hi Athika
This is the holy grail of the planners quest.
Go to the RICS bookshop website.
Look for the old Wessex estimating CD rom.
When you buy this it will give every output you will ever need in construction and M&E.
Good luck
Best regards
Mike Testto