Consultant Management Estimating Tool Users’ Manual

The New York State Department of Transportation (NYSDOT) Consultant Management Bureau’s primary responsibilities are to negotiate staffing hours/resources with engineering design consultants, and to monitor the consultant's costs. Currently the Consultant Management Bureau uses knowledge of past and current projects as well as engineering judgment to estimate consultant costs. The proposed research will focus on several major issues: 1. The establishment of a central database that contains historic total project cost and staffing level data; 2. The development of a computer based estimating tool that employs the data from the historical database to provide more accurate and efficient estimates of consultant resources. The authors will identify the major variables that affect the consultant's hours and develop predictive models. They will study multiple regression analysis as a method for developing the models. They will only consider techniques that can easily be incorporated in an Excel spreadsheet. The NYSDOT already employs an excel spreadsheet based estimating tool. The authors will determine how to best integrate the new computer tool with the existing spreadsheet. They will also explore how the developed estimating tool can exchange data with Primavera software. One meeting will be held with other interested parties in the NYSDOT to discuss the possibilities for integration. Training will be provided including at least three PowerPoint presentations to NYSDOT engineers. The meeting will occur in the main office, downstate, and in the Buffalo area. The PowerPoint presentations produced for the meetings will be provided to NYSDOT as a deliverable.This is the users manual for the system.