Collaborate on Building Construction Bill Format in Excel for Supervision with Ease Using airSlate SignNow

Building construction bill format in excel for Supervision

in order to estimate the cost of a construction project you need to estimate the cost of the materials equipment Manpower subcontractors required for the project but you have to do that in a systematic way in Excel to avoid mistakes and to be able to validate and review your estimate after you are done and let me show you now how we can do that so the first part we have here is the project overview and what I'm having here is Bill number three conrete works for a residential building eight floors or eight story building with two basements and one Podium and as we can see the BQ is split into substructure and we have the super structure here and under the substructure we have the PED concrete steel reinforcement form work and post tensioning works and we have the same thing for the super structure and what we need now is to estimate the cost of this project so in order to do that the first thing we need to do is a cost estimation template which is a template that we will be using here to estimate the cost so the template looks like that I'll say here rate and amount and I need to merge these two cells and this will be materials make this bold and I'll just copy this and paste it here five times like that so materials equipment man power and subcontractors and total cost and this will make sense in a moment I'll just have all borders here and then go all the way down up to here so I'm selecting all this range and I need to do some lines here have some vertical lines like that and the dotted line in the middle so this is my cost estimation template it will look something like that then we need the total here for for page one because we have three pages so I'll make all borders here and if you see this formula it's just the submission of all the items so I'll just copy it and paste it here under the five amount columns like that so I'm just summing this column and for the second page I want to do the same thing and I'll also copy this formula and paste it here under the five amount columns so I'm just summing here page number two as well and for the project summary again all borders and again I'll copy this and paste it under the five columns here so this is the submission now the next part to be having our cost estimation template is to just do a formula here so the amount of the materials will be equal to the rate of the materials multiplied by the quantity and dollar sign column e so that I can copy this formula and paste it freely so here basically just for example man power the amount of the man power is equal to the man power rate multiplied by the quantity and the same thing for all the other cost elements we call these the cost elements and the total cost rate will be calculated in this cell so the total cost rate will be equal to subcontractor rate plus Manpower rate plus equipment rate plus materials rate so I have a row that looks like that I'll copy it and I'll paste it like next to all the boq items that we have like this I'm just selecting the range for all the items because basically I'm going to be using the same thing everywhere and here the page summary actually this is page number one summary and page number two so I just want to copy this and paste it as well here so that I can get my cost so my cost estimation template is something that looks like that and once I have this now I am ready to start estimating the cost and now let's start estimating the cost for the PED concrete items first so the first item I have here is the PCC and I need to estimate the cost of all the cost elements materials equipment Manpower and subcontractors required for this item so start starting with the materials for the PCC poured concrete I need to supply the concrete so let's assume that the concrete supply rate is 200 and plus let's say 20 for the pumping charges and 10 for the temperature control and I'll multiply this by 1.07 to add 7% wastage so this is my material rate here and I'm getting the amount for the materials only for the supply of the concrete plus the wastage for that and I might need hand tools here to do the concrete casting and also I'll just add five and man power 10 by the way I have detailed videos I'll keep links in the description to show you how to calculate this rate of the Manpower but for the time being I don't want to complicate so I'll keep it at this level so I have here five for the equipment or the hand tools to be used and 10 for the labors who will be actually doing the concrete casting they will stay with the pump and cast the concrete and all of that and I don't have any subcontractors here so I'm getting a cost rate as you can see of 261 so if I copy this line and paste it here I'll have a small change which is as following for the supply of the concrete itself because here I'm assuming 200 for the supply of the concrete because it's C20 because it's PCC but for the raft Foundation maybe C40 is required which will be a little bit more expensive let's say 220 or something this will be based on your material list and the price of the supply of the concrete but for the time being I'll consider it again to 20 but everything else will remain same so I'm just getting a cost rate of 20 more than the PCC because C40 is more expensive than C20 and I'll copy this and paste it everywhere so I'm assuming that everywhere else I need C40 sometimes for the columns it's C60 so for the columns for example this might increase 230 it's just an example so I'm just keeping them all same for the time being and again I'll copy this row and I want to estimate the cost also for the PED concrete for the super structure items so here so like that I have estimated the PED concrete for the sub and super structure now the next part is to estimate the cost of the steel reinforcement and here as you can see the steel is measured in kilog so I need to supply the steel first so I'll assume that the supply rate of the steel is 2.5 per kg 2,500 per ton and I'll multiply that by 1.05 to add 5% wastage plus let's say .05 for The Binding wire so I'm getting a supply rate per kg of 2.68 which includes the supply of the steel itself 1 kg and The Binding wire required for that and for the hand tools and all of that let's go for 0.1 and for the Manpower or the labors required to fix the steel let's say5 and again I'll leave videos in the description showing you how to calculate the Manpower rate but here per kg I'm assuming my cost is5 per kg so I'm getting a cost rate here of 3.28 per kg this will be my cost rate for the steel reinforcement and actually this rate will be unified for for all of them because the unit of measurement is same all the items are measured in kilogram and I estimated the cost per kilogram so here for all the substructure and super structure items I paste my cost and the red breakdown analysis also for this cost so now we have the PED concrete priced and the steel reinforcement priced and now is the time to estimate the cost for the shuttering or the form work so as we can see here we have these items for the shuttering or form work and for the materials I need for the shuttering let's assume that one plywood sheet will be supplied at 100 and the sheet is 3 square m in area so each Square met will be equal 200 divided 3 and I'll divide by 3 one more time to assume that I'm going to use this one square meter for three times and then I'll multiply that by 1 point5 to add for the wastage and I'll multiply this by 1.3 to allow for all the other Woods required Square sections and so on so these are the materials that I need in terms of wood now in terms of hand tools we can add something like two and for the Manpower required it's around 15 per square meter of form workk and this will be my cost here so if I copy this and paste it for all the for workk items for the substructure and for the super structure I'll be almost done but for the slabs here we have suspended slabs so it is not only form work required we need also scaffolding so here under the equipment I'll add 20 per square meter for scaffolding and I'm assuming that it will be rented so this is the rental price per month 20 so I'm assuming that I'm am going to be using a rented scaffolding and always there is something that is called the basis of estimate and the basis of estimate are your assumptions based on what you are estimating what is your assumption for the estimating so here that I have added 20 for the renting of the scaffolding I need to add in the man power another five for the actually of the scaffolding so it will be 20 here so I'll just copy this line here of the slaps and I'll paste it here also suspended slaps and why do we have slaps in the substructure because this is a residential IAL building so the basement slab and the ground floor slab are calculated with the substructure so I have just pasted here for the suspended slabs and I am getting the cost like that 32 wherever or wherever there is no scaffolding and 57 wherever you need scaffolding and actually for the Manpower rate some people suggest that the productivity will be different from one item to another so here the rate shouldn't be fixed that can be done but it will not imp act the cost that much and now it is the time to estimate the cost for the Post tensioning works and for me the post tensioning Works will be done by a subcontractor so here for the post tension here under the subcontractor I'll put a subcontractor rate and I'll just get a quotation let's say for 32 but I have to look at the scope of work so this subcontractor will be designing the post tensioning works and we'll Supply the tendons and the materials but he will ask my steel fixers to that under his supervision so I need around 10 or 15 more for the labors so my total cost here is around 42 for this item and again this is in the substructure so I'll just copy it and paste it here for the super structure as well and now as you can see all my formulas are running and I am getting around 6.8 million cost here and this cost is coming from all the items from the P concrete steel reinforcement and form work and post tensioning works for the sub and super structure so this is the cost that I am getting right now and I also have the breakdown of the cost like how much is the materials how much is the equipment Manpower and subcontractors required to do this work and quickly if we are meeting for the first time I am Ahmed Adel and you are watching cost engineering professional and here I help you develop the required skills and enhance your knowledge to elevate your cost engineering career so if this is what you want you can quickly subscribe and now since we have estimated the cost for all the items it is the time now to add the markup and for this I'll just copy this column and I'll paste it here and I just want to delete everything and merge these two cells and I'll put a percentage here sorry a percentage and this will be a percentage column so a percentage column like that and this will be bold and what do I need to do here here I will add my markup and the markup is whatever number or percentage that you are going to add to your cost rate to get your boq rate because all this time I am just like estimating the cost of the project but now I need the price that will be submitted to the client so let's assume 20% markup here so my price will be my Cost Plus 20% so I can just copy this 20 and paste it opposite or next to all my items here boq items so just like that and of course I will show you now that you can have different markup for the different items so just here I have 20% everywhere and my BQ rate here will be equal to open a bracket 1 plus the markup and close the bracket and this will be multiplied by the cost rate so I'm getting my BQ rate here so I'll just I copy this formula and I want to paste it to price all the items because I have the cost I'm just adding the markup now so something like this and just paste so as you can see I am getting a selling price of 8.2 million where my cost is 6.8 and actually here I can see the average markup that I have so I'll say equal to here this one divided by this one minus one so I'm getting 20% and why because all my items are having 20% markup but let's say for example that I want to add more markup to the suspended slabs so I'll say for the slabs here 25% I want to add for the for for the PED concrete and also here for the steel enforcement 25 and for the suspended slabs here 25 and this for the subst structure for the super structure let's do the same thing for the suspended slabs so I'm just adding more markup to the suspended slabs like that so as you can see I have 25 for the suspended slabs and this will give me an average markup of 22% because I have 20% for some items and 25% for some other items so the overall percentage that I have for my project now is 22% as you can see here this is the cost 6.8 and this is your boq price 8.3 and these are your boq rates that we got from this estimate and now comes the part that I love the most actually which is validating your estimate now we have done our estimate but we need to cross check is it correct or no and how to do that first of all you need to go through all your cost rates and see that they are logical as per your experience because um I'm assuming that you are an estimator so you have seen these numbers so many times so you will just go here and check your total rate or total cost rate to make sure that nothing is wrong and also you can check your boq rates that they are logical or they are as per the industry like or market price that we are familiar with if you want to add markup if you want to change something in the formulas so you can do that but more than that I can do is actually I want to see how many cubic meters of concrete overall is there in this project so I'll say equal to some I just need the total volume of concrete in this project so I'll just sum these items of the substructure here plus another sum for the super structure okay so I'm having like 7,600 cubic M of concrete so if I say 8.3 divided by 7,600 I am getting around 1,094 per cubic met overall of course the 7,600 is everything the raft retaining walls columns slabs all the items are coming here so this rate is average and since I am in the market for example I understand that yes the selling rate of the concrete will be like around 1,00 1,100 but this is on average for the columns it might be 1,300 and I'm talking about a rate that includes the PED concrete the steel reinforcement the form work the post tensioning works so all the works so this is a is a rate that is being logical which tells me that somehow my calculations are okay and I can also do the breakdown of this one so here I can say equal to the material amount divided by the total like volume of the building and I'll just dollar sign the column here so I'm getting 655 on average again for the supply of the concrete steel woods and all the materials and here for the equipment and Manpower and subcontractors and even the total I'll do the same thing so as you can see I am getting a total cost rate of about 894 so from my experience this should come somewhere around 850 or 800 something in this range so I'm still near so I can say that yes my estimate is okay okay and for the Manpower for example I understand that subcontractors will charge me somewhere between 160 to 200 something in that range so this if I use a subcontractor so if I am doing it in-house so I'm getting here around 142 like per cubic meter overall for the shuttering steel fixing and concrete casting so this number is logical for me so these are all things that you can use to validate your estimate cross check like you have done all the formulas you have done all the calculations but now is the time to check your numbers and validate is it logical or do you see something that is odd or something strange or numbers looks fine and all of that and from what I'm am seeing here I see that the numbers are okay so in that case I can understand that yes this is a correct estimate I can now go and discuss it with a colleague or with a manager or someone just to have two eyes looking at the estimate and just to let you know this video took so much effort to prepare so I'll really be grateful if you share it with anyone else whom you know whom can benefit from that so that we can spread this knowledge and I leave a link in the description below where you can subscribe to my newsletter to get more insights and updates about what we are doing on cost engineering professional and if you are interested in cost engineering overall you can check this video here you will like it I am sure and that will be it for this video thank you so much for watching and I'll see you in the next one