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.

Schedule of rate breakdown

15 replies [Last post]
Mohamed Sahir
User offline. Last seen 13 years 48 weeks ago. Offline
Joined: 28 Sep 2006
Posts: 21
Groups: None
In the schedule of rate break down, we have % breakup of Material, labor, plant and overhead & profit. For Ex: item “A”: Material – 70%, Labor-15%, Plant-15%, OHP-15% Totaling 100%.
Now we have a variation for a similar item as “A”.
We got the new quotation for the materials.
We submitted our variation to the consultant, saying that since the material cost is 70%. The new rate for the item will be (material cost / 0.7).
They replied back to us stating that such a calculation is unacceptable, since in doing so we will be getting 15% of the total rate as our OHP. Since the OHP is 15% of (Material + Labor + Plant).we will have to resubmit the variation in this format.
In such a case how will one work out the Labor & Plant component using the schedule of rate breakdown.
Your suggestions are welcome.

Replies

Mike Testro
User offline. Last seen 28 weeks 20 hours ago. Offline
Joined: 14 Dec 2005
Posts: 4418

Hi Moahmed

The first thing to think about is not re start long dead threads - it is anoying for PP members to be reminded of 4 year old topics.

If you have any number of queries please set them down in the appropriate forum and PP members will respond.

Best regards

Mike Testro

mohamed saddam
User offline. Last seen 13 years 30 weeks ago. Offline
Joined: 1 Mar 2011
Posts: 2
Groups: None

salaam to you all,  my name is moahmed, i am from maldives, i have lots to ask, if any body have time 4 me plz i need some help,

Samer Zawaydeh
User offline. Last seen 5 years 30 weeks ago. Offline
Joined: 3 Aug 2008
Posts: 1664
Dear Mohamed,

You can make the format that is appropriate for the project that you have.

Basically you will have the following sections:

1. Material
2. Manpower
3. Equipment
4. Others depending on the type of project.

Then you apply the factors for Overhead and Profits.

With kind regards,

Samer
Mohamed Sahir
User offline. Last seen 13 years 48 weeks ago. Offline
Joined: 28 Sep 2006
Posts: 21
Groups: None
Samer Thank you for your reply,

But my basic question is regarding the way in which the schedule of rate breakdown is presented. The standard format.
The variation example was just to explain the complexity of it.

regards
sahir
Samer Zawaydeh
User offline. Last seen 5 years 30 weeks ago. Offline
Joined: 3 Aug 2008
Posts: 1664
Dear Mohamed,
Since the description of the item in the BOQ changed (the thickness in this case) then you need to do a price analysis.

The price analysis will be based on the rates of similar items in the BOQ. So in this case, you will only change the cost of the material from thickness 1 to thickness 2.

With kind regards,

Samer
Mohamed Sahir
User offline. Last seen 13 years 48 weeks ago. Offline
Joined: 28 Sep 2006
Posts: 21
Groups: None
hello,

I was waiting to get some suggestions.Is any more detailing required.

regards

mds.
Mohamed Sahir
User offline. Last seen 13 years 48 weeks ago. Offline
Joined: 28 Sep 2006
Posts: 21
Groups: None
Hey guys wait a minute! Let me give you an example: Variation: Change in thickness of the 150mm Gre Pipe. (Pl. Note it is not the Dia. but the thickness that has changed) BoQ Item Description Is : In trenches, depth: not exceeding 1.5 m for 150mm pipe Rate Break down from the: Schedule of rate break down. Material-60%, Labour-15%, plant-10% & ohp-15% Total (100%) Now the general approach would be to 1. Break up the rate into M, L, P components based on the Schedule of rate break down %’s. 2. To the material component apply the price differences, to get the new material cost. 3. Assuming there will not be any increase in labor and plant costs the new direct cost ( M+L+P) will be (New M + L + P ) 4. Now the new rate has to be (New M + L+ P) x 1.15 (I.e., including the OHP) or can we say the new rate is (New M)/0.6 .These two approaches yields two different OHP’s. The consultant is in favor of the former. We objected to this saying, how can we have two different approaches, while breaking up the rate and then when rebuilding it. So their argument was doesn’t rely on the “Schedule of rate break down” build up the plant and labor components for the new rate. This is ok, but it just makes the post contract administration simply tough. Still we decided to buildup the L&P cost, then the productivity is always questioned, and academic evaluations are done leading to wastage of time and energy and disputes. What went wrong in our contract? Was it the format of the Schedule of rate break down, that is creating the problem? Is it not the standard way to show your rate breakdowns? Please comment.
R. Catalan
User offline. Last seen 12 years 31 weeks ago. Offline
Joined: 15 Aug 2005
Posts: 314
Groups: None
Sajid/Samer,

I agree to both of you. Hope we made it clearer this time.

Best regards,
Rommel
Samer Zawaydeh
User offline. Last seen 5 years 30 weeks ago. Offline
Joined: 3 Aug 2008
Posts: 1664
Dear Everyone,

This is a numbers issue.

The Contractual OHP = 15% of the Final Price = 17.647% of the M+L+P.

You just have to point this issue to the Consultant, and they should understand.

Unless you have another clause in your Contract stating clearly that the OHP=15%.

Best Regards,

Samer
Sajid Balma
User offline. Last seen 13 years 14 weeks ago. Offline
Joined: 8 Jun 2007
Posts: 151
Groups: None
Hi Catalan
I understand but don’t agree that my OHP is 17.647%.

Although, in the end it won’t make a difference in terms of amount. But, if I have a lump sum contract then I may loose ground as I am asking higher OHP.

My 15% OHP is based/integrated in my selling price and not in my direct cost. So, I divide my direct cost by 0.85 to reach my selling cost.

DC = 1080
Selling Price = 1080/.85 = 1270.59

Now, what is my OHP in 1270.59 is 15%.

OHP = 1270.59x.15 = 190.59

So, my direct cost comes to what you have claculated earlier.

It is just how you present/argue your claculations.

I am looking forward to listen on my way of presenting the entitlement.

Regards


R. Catalan
User offline. Last seen 12 years 31 weeks ago. Offline
Joined: 15 Aug 2005
Posts: 314
Groups: None
Dear Mohammad,

Let us calculate:

For example if your BOQ rate is 1,200:
Material = 840 (70%)
Labor = 120 (10%)
Plant = 60 (5%)
OH&P = 180 (15%)

Therefore, your Direct Cost (M+L+P) is 1,020 and OH&P is 180. Then, what is the % OH&P?

OH&P = 17.647% of Direct Cost (180/1020)

Let us check whether the 17.647% is correct:
1,020 x 15% = 153 (Wrong)
1,020 x 17.647% = 180 (Correct)

From the above example, if the new material cost is 900, what is the new BOQ rate?

Direct cost = 900+120+60 = 1,080
OH&P = 1,080 x 17.647% = 190.59
New BOQ Rate = 1,270.59

Hope the above helps,

R. Catalan

Samer Zawaydeh
User offline. Last seen 5 years 30 weeks ago. Offline
Joined: 3 Aug 2008
Posts: 1664
Dear Mohammad,

You will calculate the total cost including everything, then apply the percentage of OHP.

Kind Regards,

Samer
Mohamed Sahir
User offline. Last seen 13 years 48 weeks ago. Offline
Joined: 28 Sep 2006
Posts: 21
Groups: None
Dear Samer,

Thankyou for you view, But my question is if the schedule of rate breakdown shows OHP as 15 %, is it 15% of rate or 15 % of (M+L+P), as when calculating the rate from first priciples.

The General format for the schedule of rate breakdown is:

item “A”: Material – 70%, Labor-10%, Plant-5%, OHP-15% Totaling 100%

I hope iam clear now.

Regards : Md. Sahir
Samer Zawaydeh
User offline. Last seen 5 years 30 weeks ago. Offline
Joined: 3 Aug 2008
Posts: 1664
Dear Mohammad,

For variations, you need to calculate the actual costs. So start by submitting the quotations or actual invoices, then you can estimate the number of hours+ supervision+ overhead and profit+ any other cost associated with it.

You can not use the original formual for the variation. Unless the variation is an extra quantity. If it is a new item, then a fresh analysis is needed.

kind regards,

Samer
Mohamed Sahir
User offline. Last seen 13 years 48 weeks ago. Offline
Joined: 28 Sep 2006
Posts: 21
Groups: None
There is a correction:
For Ex: item “A”: Material – 70%, Labor-10%, Plant-5%, OHP-15% Totaling 100%.