Project 3019 / Report 91213 - Additional Material for Appendix C: Cost Database And Example Cost Estimate (ms excel 2 mb)

Project Paper
Description

Generic Implementation Cost Model
The solution presented in the report, Costs and Benefits of Complete Water Treatment Plant Automation(Order No. 91213), is a multi-step model. The model is an Excel workbook-based tool consisting of several separate worksheets.

The Component Cost Database worksheets contain the cost information including labor rates, expense estimates, equipment unit pricing, and software unit pricing, that is used in the higher level model spreadsheets. These costs are based on 2006 prices. The level of detail in the database is intended to be sufficient to account for significant cost differences, but is not so detailed as to require fine-grained analysis and design decisions.

The Automation Package worksheets are organized by unit process area and system wide control system elements, and cross reference the unit pricing information in the Component Cost Database. They provide the framework for developing cost estimates for automation systems that are typically found in water treatment plants. To develop the estimate, the user has to add project-specific information.

The Project Summary worksheet combines the unit pricing information and the project specific-requirements to develop a roll-up and summary of the estimated costs. The costs are provided as a range of expected values.

Generic Implementation Cost Model
The solution presented in the report, Costs and Benefits of Complete Water Treatment Plant Automation(Order No. 91213), is a multi-step model. The model is an Excel workbook-based tool consisting of several separate worksheets.

The Component Cost Database worksheets contain the cost information including labor rates, expense estimates, equipment unit pricing, and software unit pricing, that is used in the higher level model spreadsheets. These costs are based on 2006 prices. The level of detail in the database is intended to be sufficient to account for significant cost differences, but is not so detailed as to require fine-grained analysis and design decisions.

The Automation Package worksheets are organized by unit process area and system wide control system elements, and cross reference the unit pricing information in the Component Cost Database. They provide the framework for developing cost estimates for automation systems that are typically found in water treatment plants. To develop the estimate, the user has to add project-specific information.

The Project Summary worksheet combines the unit pricing information and the project specific-requirements to develop a roll-up and summary of the estimated costs. The costs are provided as a range of expected values.