Proposal - Northern - 2001-04-17 r
aro
li ` ` \ d{ 4,
ers , 4
Northern Digital Inc.
April 17 2001
Costa Mesa Sanitary District
234 E. 171h St. Suite 205
Costa Mesa, CA 92627
Attn: Rob Hamers
Subject: Proposal for SCADA System Enhancements
Dear Rob:
The purpose of this document is to define a Scope of Work to meet the District's needs for
modifications to the existing Motorola MOSCAD/Wonderware SCADA System. These
modifications will solve the problems described during site visits and telephone conversations with
District Personnel. NDI has completed an engineering study of the current SCADA configuration
t• to determine appropriate changes to the SCADA system to provide the District with a more stable
and functional system. NDI's proposed changes are described in the following sections.
If you have any questions or comments please contact me at (949) 752 7805
Sincerely
Weeecs Da*eeds:.
Helen Danielson
Account Manager
;,
Costa Mesa Sanitary District Northern Digital, Inc.
S
SCOPE OF WORK FOR THE
SCADA SYSTEM PROJECT
Costa Mesa Sanitary District
Prepared by
Northern Digital, Inc.
-.. 4 j 4 s
li __
y, 3
Northern Digital, Inc
Headquarters Southern California Office
4520 California Ave. Suite 200 18201 W McDurmott Suite E
Bakersfield, CA 93309 Irvine, CA 92614
661 322-6044 949-752 7805
il
Quote# 1779 2 4-23-01
Costa Mesa Sanitary District Northern Digital, Inc.
DESCRIPTION OF THE SYSTEM
The Costa Mesa Sanitary District is currently running Wonderware s version 7.0 software on 2
computers that run Microsoft Windows NT 4.0 operating system. One computer is at City Hall
and one is at the Corporate Yard. Each of these nodes can be granted access to the district-wide
Ethernet network.
The computer at the Corporate Yard is the primary SCADA computer for the sewer telemetry
The computer at the City Hall communications center is the secondary SCADA computer Both
computer systems presently gather data each minute on all pumps. The data is total accumulated
runtime and total number of starts for that day (since midnight). The gathered data is stored as a
cumulative EXCEL spreadsheet file which may be exported for analysis or printing on any other
office computer. No report printer is attached to the City Hall SCADA computer (only an alarm
printer).
Item 1. REPORT DATA GATHERING AND DATA STORAGE
NDI proposes to improve system data gathering, storage and reporting capability with the
following actions:
• Upgrade both SCADA PC's to most current Wonderware and most current InTouch service
packs.
• Install and activate the Industrial SQL (InSQL) application(part of the Wonderware
Factorysuite). This is a `front end' for the included Microsoft SQL 7.0
• The SQL database will be housed in the report generation machine at City Hall. The SQL
approach will store large amounts of data in the most efficient format. The circular buffer
approach will be used so that there is no possibility of filling the hard disk and causing a
system `crash' Data on pump starts and runtimes will be gathered from both the City Hall
computer and from the Corporate Yard computer via the network connection.
• Both computers must be granted network access and TCP/IP addresses by District IT
personnel. These machines should not be members of a District domain as administrative
rights are necessary for each machine. These two SCADA computers should remain an
independent workgroup. Both computers will be configured for autolog-on and autobooting
into the SCADA application programs.
S
Quote# 1779 3 4-23-01
Costa Mesa Sanitary District Northern Digital, Inc.
Item 2: Report Generation
This item has been fully investigated by NDI and the following actions will enable the reports to be
functional:
• Utilize Microsoft Access to perform the queries of the SQL database with Visual Basic
compatible scripts.
• Develop Access forms for report output. Forms may be modified if the District wishes
changes to be made in the graphics or representation.
• The tables in SQL will be used.
• The SQL database will reside on the Report Generator PC to allow for a regular back-up
procedure of the database and the Server configuration at the same time.
• Queries will be written to allow any time period to be input by the viewing operator. Data for
this requested period will then be extracted from the SQL database and formatted for report
viewing and/or printing.
Item 3: Pricing
MODEL QTY DESCRIPTION UNIT EXTENDED
Programming & Engineering/Integration
Hours
NDISE 160 Report Generation $ 95.00 $ 15,200.00
NDISE 120 Report Data Gathering and Data Storage $ 95.00 $ 11 400.00
NDIET 55 Technician Services and Validation $ 68.00 $ 3,740.00
Total $30,340.00
This quote is valid for 60 days
•
Quote# 1779 4 4-23-01
Costa Mesa Sanitary District Northern Digital, Inc.
CLASSIFICATION RATE SCHEDULE
(Effective Date 1/1/01)
PROFESSIONAL SERVICES
CLASSIFICATION NDI STD Discount
RATE Rate
CONSULTANT $150.00 $125.00
SYSTEM ENGINEER(COMPUTER&NETWORK) $135.00 $95.00
RELIABILITY/ PDM ENGINEER $135.00 $95.00
CONTROL SYSTEM ENGINEER $135.00 $95.00
PROJECT MANAGER $120.00 $105 00
DESIGNER/PROGRAMMER $110.00 $85.00
INTEGRATION SPECIALIST $100.00 $80.00
INVENTORY/ WAREHOUSE SPECIALIST $85.00 $75.00
DRAFTING $70.00 $63.00
TRAINING
CLASSIFICATION COSTS
PDM TRAINING
ON-SITE $1,500.00 PER DAY+ T&E.
ALL MATERIALS ADDITIONAL
S
Quote # 1779 5 4-23-01
Costa Mesa Sanitary District Northern Digital, Inc.
TECHNICAL SERVICES
CLASSIFICATION NDI STD
RATE Discount Rate
ENGINEERING TECHNICIAN $75.00 $68.00
RELIABILITY TECHNICIAN $75.00 $68.00
INSTRUMENTATION TECHNICIAN/INSTALLER $65.00 $55.00
PANEL FABRICATION/ SHOP SERVICES $60.00 $50.00
FIELD SERVICE TRUCK $11.00 $10.00
• SERVICE BILLED IN '/z HOUR INCREMENTS (TECHNICAL SERVICES)
• (4) HOUR MINIMUM CALL-OUT (TECHNICAL SERVICES)
II • WORKING HOURS ARE 7.30AM TO 4.00PM (TECHNICAL SERVICES)
• OVERTIME RATES:
• 1.5 TIMES AFTER(8) HOURS & SUNDAYS
• DOUBLE TIME (HOLIDAYS)
• DOES NOT APPLY TO TRUCK RATE
PER DIEM (APPLIES OUT OF THE GREATER BAKERSFIELD AREA)
APPLIES TO PROFESSIONAL & TECHNCIAL SERVICES.
• $85.00 PER PERSON PER DAY (NO OVERNIGHT)
• $160.00 PER PERSON PER DAY (OVERNIGHT)
• MILEAGE AT $.50/MILE
• AIR TRAVEL AND RENTAL CAR WILL BE AT COST PLUS 15%
Quote# 1779 6 4-23-01