Rate Analysis for Construction in Excel

This is an exclusive excel sheet that can be downloaded at free of cost to make analysis of rates associated with building construction.

By exploring the excel sheet, one can find out the rate of a specific item of work based on the necessary quantities of materials and labors and their costs.

The rates of materials and labor fluctuate from place to place. As a result, the rates of various items of work are also modified from place to place.

Every Estimate should be supported with the analysis of rates of the items included in it.

Analysis of rates include the following items :-

Cost of Material
Cost of Labour
T and P, and Sundries
Carriage
Contractor’s Profit
Tools and Plants (T & P) = 2.5 to 3 % of the labor cost

Transportation cost over 8 km is taken into consideration.
Water charges = 1.5 to 2 % 0f total cost
Contractor ‘ s profit = 10 %

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

To download the excel sheet, click on the following link onlinecivilforum.com