Transcript Presentation

Design of a UST Management System
Joshua Holtgrewe
MAESC 2005
Tank 1
Tank 2
Automatic
Tank Gauge
Tank 3
Tank 4
Introduction to USTs



Memphis, Light, Gas, & Water currently stores
fuel for its motor vehicle operations in 20
tanks at 11 sites throughout Memphis and
Shelby County
This fuel is stored in underground storage
tanks (USTs)
The double walled tanks must be monitored
in order to ensure compliance with Tennessee
Dept. of Environment and Conservation
(TDEC) regulations
Current monitoring of USTs


Automatic tank gauges (ATGs)
These ATGs contain microcontrollers
that monitor the tanks employing
probes and sensors
Electric & Systems Operations
Covington Pike, Memphis, TN
Covington Pike Location
Monitoring


Employees gather receipts at all sites
Proof of passed leak test must be
logged for one year every day and
complied in yearly reports
120VAC Panel
ATG
Probes
Interstitial sensors
Why is a New Solution
Needed?



End of usable life of system
Difficulty meeting regulatory compliance
Labor cost can be reduced by
implementing a more efficient
monitoring system
Design Objectives




New system must be able to perform
same operations as existing system
Use of existing tanks and sensors
Offsite monitoring via network based
software
Real-time monitoring
Alternative A


Monitors up to eight
tanks
Broadband
connection and
software for offsite
management
Alternative B




Monitors up to 12
tanks
Economical
Broadband
connection and
software
Local vendor
Alternative Comparison
Design Criterion
Alternative
Alternative
A
B
Real-time monitoring
X
X
Printer for on-site data collection
X
X
Software for off-site monitoring
X
X
E-mail alerts from ATGs
X
Ability to monitor 8 tanks
X
X
Continuous testing ability
X
X
Use of existing probes/sensors
Multiple language support
X
X
Alternative A Total Costs
Qty
11
11
11
20
8
12
20
20
20
20
1
1
1
1
Item
ATG Console-PC Version
Ethernet TCP/IP Module
Static Probe
Magnetic 8' Probe
Probe Install Kit
Diesel Probe Install Kit
Interstitial Sensor
Piping Sump Sensor
4" Cap and Ring Kit
Sensor Cap Kit
Remote Software
Installation Fee
Freight Fee
Sales Tax @ 9.25%
Unit Price
Total Price
$
1,870.00 $ 20,570.00
$
795.00 $
8,745.00
$
162.50 $
1,787.50
$
1,040.00 $ 20,800.00
$
145.00 $
1,160.00
$
145.00 $
1,740.00
$
245.00 $
4,900.00
$
135.00 $
2,700.00
$
85.00 $
1,700.00
$
55.00 $
1,100.00
$
1,295.00 $
1,295.00
$
3,000.00 $
3,000.00
$
2,000.00 $
2,000.00
$
6,613.52 $
6,613.52
TOTAL
$ 78,111.02
Alternative B Total Costs
Qty
11
11
11
17
8
9
17
17
17
17
1
1
1
1
Item
ATG Console-PC Version
Ethernet TCP/IP Module
Static Probe
Magnetic 8' Probe
Probe Install Kit
Diesel Probe Install Kit
Interstitial Sensor
Piping Sump Sensor
4" Cap and Ring Kit
Sensor Cap Kit
Inform Software
Installation Fee
Freight Fee
Sales Tax @ 9.25%
Unit Price
Total Price
$
1,395.00 $ 15,345.00
$
535.00 $ 5,885.00
$
162.50 $ 1,787.50
$
990.00 $ 16,830.00
$
145.00 $ 1,160.00
$
145.00 $ 1,305.00
$
235.00 $ 3,995.00
$
135.00 $ 2,295.00
$
48.82 $
829.94
$
65.00 $ 1,105.00
$
1,150.00 $ 1,150.00
$
4,400.00 $ 4,400.00
$
1,500.00 $ 1,500.00
$
5,326.84 $ 5,326.84
TOTAL
$ 62,914.28
Choice: Alternative B





Savings of $15,000 as
compared to Alternative A
Some existing probes and
sensors are used
Some existing ATGs may
not need to be replaced
Same
manufacturer/vendor of
existing ATGs
Met all of design objectives
Screenshots of Software



Site Manager
Site Editor
Alarm History
Connectivity
Wireless
Router
LAN
ATG
Connectivity


Network connections required to the
eleven ATGs
Two types of solutions exist: LAN (local
area network) or WLAN (wireless local
area network)
LAN vs. WLAN at Covington
Pike





Wireless adapters can be located in enclosure with
ATG
No need for site adaptation
Access point can be located at the hub or switch in
the facility
Attenuation not a problem since the enclosures
housing the ATGs are within 200 feet of a nearby
office that will contain the hub or switch
Encryption provides security for wireless network
LAN Costs for Covington Pike
TRADITIONAL NETWORKING - COST ANALYSIS FOR MLGW
Qty
Units
Item
Unit Price Total Price
125 LF
Concrete Demolition/Replacement
$ 17.00 $ 2,125.00
125 LF
PVC Schedule 40 1/2" Conduit
$
1.70 $ 212.50
8 20' Sect. Category 5e Networking cable
$
8.95 $
71.60
1
Sales Tax @ 9.25%
$ 234.89 $ 234.89
TOTAL
$ 2,643.99
Source: RSMeans Electrical Cost Data, 28th Edition
WLAN Costs
WIRELESS NETWORKING - COST ANALYSIS FOR MLGW
Qty
Item
11 D-Link / DWL-810+/ Ethernet Wireless Bridge
11 D-Link / Air / DI-514/ Cable/DSL / Wireless Router
1 Sales Tax @ 9.25%
Note: This price is the cost for 11 sites.
Source: www.dlink.com
Unit Price Total Price
$ 64.99 $ 714.89
$ 44.19 $ 486.09
$ 117.10 $ 117.10
TOTAL
$ 1,318.08
Replacement
Recommendation




Alternative B with wireless network
connections
Use of IEEE 802.11b hardware
Meets and exceeds operating
temperature ranges
Meets and exceeds signal range for
connectivity with the switch or hub
onsite
Costs




Includes the new UST monitoring system
featuring the ATGs of Alternative B, its
probes, sensors and software
The wireless routers and access points
necessary for the communication in real-time
Installation by trained technicians
$64,232.40
Benefits of Solution



Relief of on-site labor responsibility and
the cost associated with this labor
Real-time monitoring
More effective method for regulatory
compliance
Economic Benefits



This design solution will eliminate over
$5,000 a month of labor
Over the 10 year life-cycle of the new
system the present worth of the
alternative is $371,853.53
The solution has a payback period of
approximately 13 months.
Overview of ATG System
Tank 1
Tank 2
Tank 3
Tank 4
Automatic
Tank Gauge
Control Wire
Overview of Networking
Router
Automatic Tank
Gauge with
Wireless Adapter
Overview of Networking System
Allen
Brunswick
Davis
Covington Pike
PC at MLGW
Headquarters
Heavy
North
Hickory Hill
Sheahan
Lichterman
South
McCord
Conclusion




Improved regulatory compliance
Reduction of labor costs
Real-time offsite monitoring
Return of capital investment in
13 months
Any Questions?
Main
Offices
Allen
Heavy
North
Brunswick
Davis
Hickory Hill
Lichterman
Sheahan
South
Covington
Pike
McCord
Questions……..









Introduction
ATG
Tanks/Site
Alternatives
Costs
Software
LAN vs WLAN
Costs of Networking
Benefits






MARR
Probes
Microcontroller
Sensors
Volumetric Calculations
Wireless
MARR



Minimum attractive rate of return
The interest rate at which one can
expect to receive due to the time value
of money
6%-8%
Present Worth Analysis



Initial Cost: $64,232.40
Annual Maintenance Costs: $750
Employee Productivity Savings: $60,000
PW = -64,232.40+ -750(P/A,i,n)+
60,000(P/A, i, n)
MARR Table
Present Worth of
MARR
Alternative
6%
$371,853.53
7%
$351,915.90
8%
$333,341.03
Microcontroller




CPU
256K Internal Memory
PROM
Connectors for printer, fax,
communications modules, other
peripherals
Inventory Probes



A voltage is induced by
the current flowing from
the change in magnetic
field.
The magnetic field
changes due to the
distance between the
top part of the probe
and the bottom
Hall effect
Leak detection


Interstitial liquid
sensor
Vapor sensorlocated in backfill to
detect vapor being
absorbed by soil
Volumetric Calculations
RH
R
a
Vunfilled  2L  RSinCos 1 a da
H
R
R
2





R
L
H
2
R
H
H


1 
V unfilled 
RL R  H 
 RSin 1   
2
2
R
R 


V filled 
R 2 L
2

H 2 R  H 
H 
1 
 RL  R  H 
 RSin 1   
2
R
R 


Wireless



802.11b signals have an outdoor range
of 1640 ft
Adapter output power of 15dBm
Signal degradation in a variety of
ranges (1MBps, 5.5MBps, 11MBps)
Wireless Ranges



11 MBps within
800ft.
5.5 MBps from
800ft. to 1300ft.
1 MBps from 1300ft.
to end of range
1600 ft.
1300 ft.
800 ft.