Hegazy, T and Ersahin, T (2001) Simplified spreadsheet solutions: I: Subcontractor information system. Journal of Construction Engineering and Management, 127(6), pp. 461-468. ISSN 0733-9364
Abstract
This paper presents a subcontractor information system (SIS) to support the estimating and project control functions of subcontractors and small/medium-size contractors. For the proposed SIS to be simple and practical, it was developed in a spreadsheet program designed to maintain information related to resources and projects and to generate important business reports. Resource data are stored in six worksheets for labor, equipment, crews, material, subcontractors, and alternative methods of construction for various tasks. In addition, a separate worksheet is designed for each project to be used for estimating and control purposes. The latter worksheet allows the user to specify the work breakdown structure and optional methods for construction. As such, it represents a transparent estimating model that allows for quick what-if analysis regarding time and cost. In addition, the reporting worksheet provides information related to time, cost, and resource use at the individual and the multiproject levels. In a companion paper, the use of the SIS as basis for overall schedule optimization is described.
| Item Type: | Article |
|---|---|
| Index terms: | estimating, subcontractor, project control, spreadsheet, information system, program |
| Subjects: | practitioner, information systems, data science, control systems, financial and cost management, software systems |
| Topics: | Roles and Professions, Digital Applications, Project Management, Research Practice, Cost Management |
| Descriptive scope: | 2 PC |
N.B. Descriptive scope is a count of how many of the five facets of empirical research are indicated by the words used in title, abstract and keywords. It is not intended as a judgement on the research; merely a count of the kind of word we would expect to indicate Phenomenon, Concepts, Theoretical framing, Empirical techniques, Analytical techniques. If all five are present, then a code of “5 PCTEA” will indicate this. If you feel the coding for this record is questionable, we welcome discussion around the terms we matched or the way we categorized them. The facet you would expect may not be coded, or a facet may be coded inappropriately. This can also bear on a larger question, of which facets should be treated as defining in construction management research. Please get in touch, and we will look at it. More details here