Develop Consultant Management Estimating Tools

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. <br />(3) The project will identify the major variables that affect the consultant's hours and develop predictive models. We will study multiple regression analysis as a method for developing the models. We will only consider techniques that can easily be incorporated in an Excel spreadsheet. (4) The NYSDOT already employs an excel spreadsheet based estimating tool. We will determine how to best integrate the new computer tool with the existing spreadsheet. We 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. (5) 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. A users manual will be developed to assist Consultant Managers using the system. Potentially this research can result in cost savings to the NYSDOT by providing an improved decision making tool to Consultant Managers negotiating contracts. The objective of the research project is to produce and calibrate a computer based design agreement estimating tool that uses a database of historical project information to produce budget estimates of consultant staffing.<br />


  • English


  • Status: Active
  • Contract Numbers:

    RF 55505-04-01

  • Sponsor Organizations:

    New York State Department of Transportation

    50 Wolf Road
    Albany, NY  USA  12232
  • Project Managers:

    Hoole, Paul

  • Performing Organizations:

    City College of New York

    Civil Engineering, Steinman T-127
    140th Street and Convent Avenue
    New York, NY  USA  10031

    Rutgers University, Piscataway

    Department of Civil and Environmental Engineering
    623 Bowser Road
    Piscataway, NJ  USA  08854
  • Principal Investigators:

    Parker, Neville

    Williams, Trefor

  • Start Date: 20080101
  • Actual Completion Date: 20111231
  • Source Data: RiP Project 18852

Subject/Index Terms

Filing Info

  • Accession Number: 01464397
  • Record Type: Research project
  • Source Agency: University Transportation Research Center
  • Contract Numbers: RF 55505-04-01
  • Files: UTC, RiP, STATEDOT
  • Created Date: Jan 3 2013 2:41PM