Develop Consultant Management Estimating Tool

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. (3) The project will identify the major variables that affect the consultant's hours and develop predictive models. The project  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. The project will determine how to best integrate the new computer tool with the existing spreadsheet. The project 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.

  • Supplemental Notes:
    • Rutgers University, Center for Advanced Infrastructure and Transportation (CAIT)


  • English


  • Status: Active
  • Contract Numbers:


  • Sponsor Organizations:

    New York State Department of Transportation

    50 Wolf Road
    Albany, NY  United States  12232
  • Project Managers:

    Hoole, Paul

  • Performing Organizations:

    University Transportation Research Center

    City College of New York
    Marshak Hall, Suite 910, 160 Convent Avenue
    New York, NY  United States  10031

    Center for Advanced Infrastructure and Transportation

    Rutgers University
    100 Brett Rd
    Piscataway, NJ  United States  08854-8058
  • Principal Investigators:

    Williams, Trefor

  • Start Date: 20080601
  • Expected Completion Date: 0
  • Actual Completion Date: 20091231
  • Source Data: RiP Project 22532

Subject/Index Terms

Filing Info

  • Accession Number: 01462063
  • Record Type: Research project
  • Source Agency: Center for Advanced Infrastructure and Transportation
  • Contract Numbers: NYMTC-RU0054
  • Files: UTC, RiP, STATEDOT
  • Created Date: Jan 3 2013 1:57PM