Design SpreadsheetsEstimation and Costing

Analysis of Rates of Building Construction in Excel

Analysis of Rates of Building Construction in Excel

  • To determine the rate of Building Construction a particular item of work from quantities of materials and labors required and their costs
  • The rates ofย  materialsย  andย labor are changing from place to place, therefore the ratesย  oย  differentย  itemsย  ofย  workย  also changes from place to place

Everyย Estimate should be accompanied byย the analysis of rates ofย the items provided in it.

  • Analysis of rates comprises of
  1. Cost of Material
  2. Cost of Labour
  3. T and P , and Sundries
  4. Carriage
  5. Contractorโ€™s Profit

Tools and Plants ( T & P )ย  = 2.5 to 3 % of the labour cost

Transportation cost more than 8 km is considered

  • Water charges = 1.5 to 2 % 0f total cost
  • Contractor โ€˜ s profit = 10 %

ย Selection of Plot And Study

Rates of Materials and Labours :

  • 1 st class bricks = Rs 4500 per 1000 Nos.
  • 2 nd class bricks = Rsย  4000 per 1000 Nos.
  • Brick Ballast = Rs 800 per cum
  • Coarse sand = Rs 800 per cum
  • Cement 50 kg bag = Rs 270 per bag
  • Twisted bars = Rs 5000 per Quintel
  • Bitumen = Rs 10 per kg

Masonย ย ย ย ย ย ย ย ย ย ย  =ย  Rs 550 per day

  • Plaster = Rs 300 per day
  • Carpenter = Rs 500 per day
  • Bhishti = Rs 350 per day
  • Mazdoor = Rs 350 per day
  • Painter = Rs 400 per day

Earth work in excavation:

Mazdoor = 33

(% cum)ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย  Masonย ย  = 1.5

  • Earth work in Filling : Mazdoor = 18

(% cum)ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย  Masonย ย  = 0.5

  • Cement concrete : Mazdoor = 15

in foundationย ย ย ย ย ย ย ย ย ย  Mason =1.5

Bhishtiย ย  = 2

Cement concreteย ย ย ย ย ย ย ย ย  : Mazdoor = 15

Mason =ย  1

Bhishtiย ย  = 2.5

  • R. Cement concrete : Mazdoor = 40

(10 cum )ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย  Mason =ย  2.5

Bhishtiย ย  = 5

Blacksmith = 4

Carpenter = 4

DPCย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย  : Mazdoor = 2.5(10 cum )

Mason =ย  1.5

Bhishti ย ย = 0.5

  • 1 st class brick work :ย  Mazdoor = 15

Mason =ย  8

Bhishtiย ย  = 2

Plastering workย ย ย ย  :ย  Mazdoor = 10

( 100 sqm)ย ย ย ย ย ย ย ย ย ย ย ย  Mason =ย  10

Bhishtiย ย  = 2

  • Distempering/painting/white washing :

Mazdoor = 5

( 100 sqm)ย ย ย ย ย ย ย ย ย ย ย  Painterย ย  = 4

Free Download wait for Count Downloadย 

Analysis of Rates of Building Construction in Excel Free Download Clicks Here Below wait for count down.

Related Articles

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button
Follow Engineers

Civil Engineering Job Update in WhatsApp

click on the below link to join
Join Now
close-link
Join over 1000+ Civil Engineers!

Civil Engineering Job Updates in WhatsApp

Daily Civil Jobs Updates click on the below link.
JOIN NOW!
close-link
Worldโ€™s Biggest Cruise Ship Construction Work Checklist Autocad 2d Plan with 3d Elevation