Simplified Spreadsheet Solutions. I: Subcontractor Information System
Publication: Journal of Construction Engineering and Management
Volume 127, Issue 6
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.
Get full access to this article
View all available purchase options and get full access to this article.
References
1.
Barton, P. ( 1985). Information systems in construction management: Principles and applications, Batsford Academic and Educational, London.
2.
Halphin, D. W., and Woodhead, R. W. ( 1987). Construction management, Wiley, New York.
3.
Hegazy, T. ( 2002). Computer-based construction project management, Pearson Education, Inc., Upper Saddle River, N.J.
4.
Hegazy, T., and Ersahin, T. (2001). “Simplified spreadsheet solutions. II: Overall schedule optimization.”J. Constr. Engrg. and Mgmt., ASCE, 127(6), 469–475.
5.
Means building construction cost data. (1998). R.S. Means Company, Inc., Kingston, Mass.
6.
Meuller, F. ( 1986). Integrated cost and schedule control for construction projects, Van Nostrand Reinhold, New York.
7.
Microsoft Excel, reference manual, version 8 for Windows 95. ( 1977). Microsoft Corp., Redmond, Wash.
8.
Reynolds, G. C. ( 1988). Information system for managers, West Publishing Co., St. Paul, Minn.
9.
Russell, J., and Radtke, M. ( 1991). “Subcontractor failure: Case history.” AACE Trans., E.2.1–E.2.6.
Information & Authors
Information
Published In
Journal of Construction Engineering and Management
Volume 127 • Issue 6 • December 2001
Pages: 461 - 468
History
Received: Jan 5, 2000
Published online: Dec 1, 2001
Published in print: Dec 2001
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.