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

Project Paper

Project Supporting Resource

p align="center">Generic Implementation Cost Modelp>The solution presented in the report, Costs and Benefits of Complete Water Treatment Plant Automation (91213) is a multi-step model as represented in this figure. p> p align="center">p>The model is an Excel workbook based tool consisting of several separate worksheets. 
Download the Excel Workbook (2mb) - Save to your computer p>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. p>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. p>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.