Simplified Spreadsheet Solutions.?I: Subcontractor Information System

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.