How to calculate BOQ for getting the total amount required for materials

In this construction video tutorial, you can learn how to calculate BOQ to ascertain the amount for the various materials with the use of the excel sheet.

The material list for building a house spreadsheet contains different types of heads like serial number, description, measuring unit, quantity, unit price and total.

At first, find out the amount of cement. In serial number put 1, in description provide cement, in measuring unit provide number, in quantity put 300, in unit price provide 520. To find out the total amount just multiply quantity with unit price i.e. 300 x 520 = 156000.

Secondly, find out the amount of sand. In serial number put 2, in description provide sand, in measuring unit give CFT, in quantity provide 1000, in unit price provide 20 i.e. 20 rupees per cubic feet. To find out the total amount just multiply quantity with unit price i.e. 1000 x 20 = 20000.

Thirdly, determine the amount of aggregate. In serial number put 3, in description provide aggregate, in measuring unit provide CFT, in quantity put 2000, in unit price provide 18. To work out the total amount, just multiply quantity with unit price i.e. 2000 x 18 = 36000.

The same calculation can be made for door and window.

To find out the total amount, sum up the amount of all the materials i.e. 2,96,000. Therefore, 2,96,000 amount is required for the materials.

To get more information, watch the following video tutorial.

Video Source: Civil Engineers