Excavation | Rate analysis and Quantity calculation Tool

Introduction

To carry out any construction work we required the quantity calculation and that gives a detailed explanation of how much quantity to procure at the construction site. The rate analysis is one of the best calculations which help to carry out the cost and quantity calculation for construction work.

This post will help to calculate the rate analysis of Excation using the following standard tool developed by Parag Pal.

Rate analysis of Excavation 

Rate analysis of excavation is very important as it gives importance to the cost calculation of unit and multiple quantity at a given time with cost using the following tool.

Kindly provide the input in the yellow highlighted cell and it is suggested to watch the video below before kick start working on following rate analysis of excavation tool.

Watch following video to undertsand how to use this tool.

Rate analysis of Excavation Tool

Excavation Quantity		cum
RATE ANALYSIS - By PARAG KAMLAKAR PAL
Description	Rate	Quantity	Unit	Amount
EARTH WORKS SITE CLEARING
HELPER			day
Sub Total
Add for Machinery, Scaffoldings, etc.			Percentage
Add for Sundries & Contingencies			Percentage
Add for Water Charges & Electricity			Percentage
Add for Profit & Overhead			Percentage
Total
EARTH WORKS BLASTING ROCKS			Unit	Cu.M.
COUNTRY BLASTING POWDER			Kg
COUNTRY FUSE			m
HELPER			day
Sub Total
Add for Machinery, Scaffoldings, etc.			Percentage
Add for Sundries & Contingencies			Percentage
Add for Water Charges & Electricity			Percentage
Add for Profit & Overhead			Percentage
Total
EARTH WORKS EXCAVATION ORDINARY SOIL			Unit	Cu.M.
HELPER			day
Sub Total
Add for Machinery, Scaffoldings, etc.			Percentage
Add for Sundries & Contingencies			Percentage
Add for Water Charges & Electricity			Percentage
Add for Profit & Overhead			Percentage
Total
EARTH WORKS EXCAVATION HARD SOIL			Unit	Cu.M.
HELPER			day
Sub Total
Add for Machinery, Scaffoldings, etc.			Percentage
Add for Sundries & Contingencies			Percentage
Add for Water Charges & Electricity			Percentage
Add for Profit & Overhead			Percentage
Total
EARTH WORKS EXCAVATION			Unit	Cu.M.
HELPER			day
Sub Total
Add for Machinery, Scaffoldings, etc.			Percentage
Add for Sundries & Contingencies			Percentage
Add for Water Charges & Electricity			Percentage
Add for Profit & Overhead			Percentage
Total
EARTH WORKS FILLING FOUNDATION			Unit	Cu.M.
HELPER			day
Sub Total
Add for Machinery, Scaffoldings, etc.			Percentage
Add for Sundries & Contingencies			Percentage
Add for Water Charges & Electricity			Percentage
Add for Profit & Overhead			Percentage
Total
EARTH WORKS FILLING FOUNDATION USING SAND			Unit	Cu.M.
SAND			cum
HELPER			day
Sub Total
Add for Machinery, Scaffoldings, etc.			Percentage
Add for Sundries & Contingencies			Percentage
Add for Water Charges & Electricity			Percentage
Add for Profit & Overhead			Percentage
Total
EARTH WORKS FILLING PLINTH USING EARTH FROM SITE			Unit	Cu.M.
HELPER			day
Sub Total
Add for Machinery, Scaffoldings, etc.			Percentage
Add for Sundries & Contingencies			Percentage
Add for Water Charges & Electricity			Percentage
Add for Profit & Overhead			Percentage
Total
EARTH WORKS FILLING PLINTH USING EARTH OUTSIDE			Unit	Cu.M.
EARTH			cum
HELPER			day
Sub Total
Add for Machinery, Scaffoldings, etc.			Percentage
Add for Sundries & Contingencies			Percentage
Add for Water Charges & Electricity			Percentage
Add for Profit & Overhead			Percentage
Total
EARTH WORKS FILLING PLINTH USING SAND			Unit	Cu.M.
SAND			cum
HELPER			day
Sub Total
Add for Machinery, Scaffoldings, etc.			Percentage
Add for Sundries & Contingencies			Percentage
Add for Water Charges & Electricity			Percentage
Add for Profit & Overhead			Percentage
Total

If you like this tool then please subscribe my youtube channel:Subscribe Youtube channel