Comparative Analysis of Bill of Quantity (BOQ) Results with Revit, Tekla Structures and Excel Software in the Sei Mangkei Fat Trap Refinery II Construction Project

Abstract

This study aims to compare the results of Bill of Quantity (BOQ) calculations using three different approaches: Microsoft Excel, Autodesk Revit, and Tekla Structures, applied to the Fat Trap Refinery II Sei Mangkei construction project. The analysis focuses on the volume and weight of structural elements, based on secondary project data. Validation was carried out by modeling a beam approximately 50 meters long with dimensions of 300 mm × 600 mm, which showed that Autodesk Revit produced results closest to manual calculations. Microsoft Excel remains a dependable method, especially when used by meticulous planners, as it allows full control over the calculation process. Tekla Structures showed greater deviation but offers advantages in anticipating long-term risks. Based on the findings, Autodesk Revit is recommended as the most suitable method for modern projects that require precision and efficiency, while Excel remains relevant for users who prioritize manual oversight. This research is expected to serve as a reference for selecting the appropriate BOQ calculation method according to the characteristics and needs of construction projects.

KeyWords: Bill of Quantity, Building Information Modeling, Tekla Structure, Autodesk Revit, and Fat Trap