Surface Water Detection System - PowerPoint Presentation

Slide1

Surface Water Detection System

Presented By:

Eric Boyd

Robert Dayton

Marissa Hornbrook

Jill Mostoller

Cassie Rothrauff

1

11/15/2010

Slide2

Problem Statement

Many roadways that are prone to flooding lack a city controlled contiguous alert system to warn drivers of dangerous water levels. Such a system could assist drivers in preventing vehicle damage and personal injury in cases where they proceed through inundated portions of the road. 211/15/2010

Slide3

Proposed Solution

Network of above ground ultrasonic sensors able to detect rising water levels in areas prone to floodingPhysical sign implemented to warn drivers of dangerous roadwaysCentralized data center for easy access by user-based applications311/15/2010

Slide4

Market Overview

CustomerCity governmentsBid proposal Private citizensCommercial frontendTarget UserDrivers411/15/2010

Slide5

Competition Matrix

Several implementations have been createdMost involve road-embedded devicesExtremely small commercial sector511/15/2010

Commercial FrontendRoadside Warning SignsInteractive Internet MapsMobile Device Support

Installation TypeRENCINoNoNoNoIn-GroundHays CountyNoYesYes

NoIn-GroundOhio DOTNo

No InformationYesNoNo-Information

EltecYesYesNo

NoIn-GroundOur DesignYes

YesYesYesAbove-Ground

Slide6

Slide7

Slide8

Slide9

Slide10

Slide11

Slide12

Slide13

Slide14

Slide15

Sensor is designed to be mounted above ground making it easier to install and maintain

Sensor accuracy range of 26’The communication link between the remote device and the data center could vary depending on localityA centralized data center would connect all remote sensors, log data, and make it available to the web serverHardware Breakdown1511/15/2010

Slide16

Slide17

Slide18

Slide19

Slide20

Slide21

Hardware/Software Milestones

1.2 - Public Web Application(s)Major FeaturesGoogle Maps is used to display graphic representation of water levelsUsers can set up custom RSS feeds to alert them to dangerous water levels on their route1.2.1 - Customizable Web Front1.2.2 - Google Maps API (Application Programming interface)1.2.3 - Google Maps End-User Interface1.2.4 - RSS API1.2.5 - RSS Feed1.2.6 - User-Customizable Alert System11/15/201021

Slide22

Marketing - What's in the Box?

Closed SystemAbove ground sensorMicrocontrollerWarning signUpgrade network packageIntegration with networkCentralized data centerAnnual software licenseUpgrade modular applicationsGoogle Maps Application GPS integration RSS Feed2211/15/2010

Slide23

Price Point

Closed System for 1 sensor: Labor: $90,638* Resources: $254 * GROSS TOTAL: $90,892 50% Markup: $45,446 NET TOTAL: $136,338 Each additional sensor: $254Networked System: Closed system cost: $136,338 Number of sensors * $254

Additional Resources: $150/sensor Annual Licensing Fee: $10,000*Reference Note: Labor estimates taken from Salary.com; resource estimates taken from parallax.com

11/15/201023

Slide24

Return on Investment

FinancialData sales to third party organizationsInsurance companiesNon-Financial Shorter response cycle to emergency floodingPublic safety serviceStatistics reporting11/15/201024

Slide25

Staffing

Project ManagerSoftware Engineer Electrical EngineerNetwork EngineerProgrammerMarketing SpecialistCity Consultants11/15/201025

Slide26

Resources

PrototypeUltrasonic sensorMicrocontrollerDevelopment PCWiringProduct ImplementationIndustrial ultrasonic sensorMicrocontrollerDevelopment PCsWiringRoad signU Channel Posts11/15/201026

Slide27

Staffing/Resources Cost

DevelopmentQuarterly Salary:Project Manager - Marissa$20,503Software Engineer - Eric

$18,132Electrical Engineer - Robert

$18,811Programmer - Jill$16,999Marketing Specialist - Cassie

$16,193 

Resources

Cost:

Ultrasonic Sensor$30

Microcontroller$30

Development PC$0

Wiring

$10TOTAL:

$90,708

11/15/2010

27

Development/Support

Annual Salary

Project Manager

$61,509

Software Engineer

$54,397

Electrical Engineer

$56,434

Network Engineer

$52,339

Programmer

$50,996

Marketing Specialist

$48,579

Remote Technical Support

$42,656

On-site Technical Support

$56,434

TOTAL STAFFING

COST:

$324,254

Resources

Ultrasonic Sensor

$100

Microcontroller

$60

Development PCs

$0

Wiring

$10

Custom Road Sign

$56

U Channel Posts

$28

TOTAL PER SENSOR

COST

:

$254

Prototype

Implementation

Slide28

Risk Analysis

Scheduling RisksInformation delayConcerning the cities specific network systemConcerning sensor locationsEquipment delayManufacturing delay on mounting systemManufacturing delay on road sign (putting the lights on the custom sign)Financial RisksAdditional unforeseen expensesAdditional parts needed that aren’t mentioned in budgetManufacturing costs increaseContract PenaltiesAssociated with Equipment delay that could cause a late delivery for the projectTechnical RisksTechnology AvailabilityCity doesn’t have a network system to piggy back

11/15/201028

Slide29

Challenges with Solution

People can ignore warning signsCannot assume that motorists will heed warningsInattentive drivers may not even see our signsCustom tailored design Hardware is essentially the same but networking of components could varyOptimal placement of sensors in flood prone areas will have to be planned accordingly2911/15/2010

Slide30

Benefits of Solution

Decrease in city expenses/Increased road safetyPaying police and firemen that are needed to block a flooded road or intersection and reroute trafficRescuing stranded motoristsWater damage expenses Traveler’s convenienceGoogle maps application can help travelers avoid flooded areas before they leave their houseWarning signs will alert drivers sooner so detours can be taken in advance3011/15/2010

Slide31

Conclusion

Modular, sensor based solution to solve uncertainty of water depthConstant real-time data stream useful to the client through modular implementationWarning drivers done both physically and onlineSaves the client both time and money, while solving an issue of public safety3111/15/2010

Slide32

Q&A

3211/15/2010