Institutional-Repository, University of Moratuwa.  

Integration of cost control and estimation using Spreadsheets and databases

Show simple item record

dc.contributor.author Kodikara, GW
dc.contributor.editor Hettiarachchci, P
dc.date.accessioned 2022-12-16T09:29:14Z
dc.date.available 2022-12-16T09:29:14Z
dc.date.issued 1997-11
dc.identifier.citation ****** en_US
dc.identifier.uri http://dl.lib.uom.lk/handle/123/19834
dc.description.abstract Cost control is very important for any industry, since it is the activity which monitors the actual cost against the budgeted costs and initiates corrective actions if the costs are higher than expected. The estimating activity produces the anticipated cost or the budget and it is advantageous if the cost control activity could be linked to the estimating process. Computers can be effectively used to link the two processes, maximising data sharing and forwarding. In Sri Lanka most of the construction companies do not have integrated estimating and cost control systems in order to improve their performances although there are some " off the shelf packages" available in the market for independent activities. Therefore, it is required to conduct research and development in this area. As a first step, it is advisable to use readily available general software such as spreadsheets and databases and develop low cost system to address the need. This paper presents research work undertaken at the Department of Civil Engineering of the University of Moratuwa to develop a simple cost control system (using a database) linked to an estimating system (in a spreadsheet environment). A detailed study of existing literature on estimating and cost control was carried out and the concept for integration was established. Collection of cost data at site level is tiecessary for cost control, hence cost collection data sheets were designed to gather cost information at sites daily and enter to the system weekly to produce reports. It was decided to collect the maximum amount of data with minimum paper work since personnel at work sites are generally reluctant to undertake additional paper work. A cost control system was developed using Microsoft Access® and was linked to the estimating system, which is in the Microsoft Excel® environment. A test run was successfully carried out using a two storied building as an example. The system produces four reports for variance analysis for the most recent week, variance analysis for the whole period, percentage of work completed and cost details (breakdown of cost under major cost areas) for each BOQ item under construction. This information helps to monitor the behaviour of work in a better way. en_US
dc.language.iso en en_US
dc.publisher Engineering Research Unit, Faculty of Engiennring, University of Moratuwa en_US
dc.title Integration of cost control and estimation using Spreadsheets and databases en_US
dc.type Conference-Full-text en_US
dc.identifier.faculty Engineering en_US
dc.identifier.department Engineering Research Unit, University of Moratuwa en_US
dc.identifier.year 1997 en_US
dc.identifier.conference Research for Industry 1997 en_US
dc.identifier.place Katubedda en_US
dc.identifier.proceeding Proceedings of Symposium on Research for Industry 1997 en_US


Files in this item

This item appears in the following Collection(s)

Show simple item record