geographical auto-delivery system
DESCRIPTION
Geographical Auto-Delivery System. CS 410 Orange Group Final Presentation. Presentation Outline. Personnel Problem Solution Design Business Plan Recap. Personnel. Associates. Janet BrunelleChair G. Hill PriceVice Chair Consultants Irwin LevinsteinDB Expert - PowerPoint PPT PresentationTRANSCRIPT
CS 410 Orange GroupFinal Presentation
13 December 2010 1CS 410 Orange Team
Personnel Problem Solution Design Business Plan Recap
13 December 2010 2CS 410 Orange Team
13 December 2010 3CS 410 Orange Team
Janet Brunelle ChairG. Hill Price Vice Chair
ConsultantsIrwin Levinstein DB ExpertStephan Olariu Network Expert
Potential ConsultantsShuiwang Ji AI ExpertLarry Lee Probability & Statistics ExpertJay Morris Parallel Computing ExpertSteven Zeil OOD Expert
13 December 2010 4CS 410 Orange Team
13 December 2010 5CS 410 Orange Team
13 December 2010 6CS 410 Orange Team
13 December 2010 7CS 410 Orange Team
Lack of knowledge increases frustration and inefficiency
while traveling.
13 December 2010 8CS 410 Orange Team
Amount of money spent traveling
Time wasted due to traffic
No idea where anything is
13 December 2010 9CS 410 Orange Team
10 %Points
of Interest
23%Lodging
23%Food & Drinks
44%Transportation
Source: U.S Bureau of Labor Statistics
13 December 2010 10CS 410 Orange Team
“In 2008, the average U.S. household spends about $1,415 on transportation, lodging, food and drinks, and points of interest while on vacation and pleasure trips”1
“U.S. Travel Association forecasts [this year] that there will be 450.9 million business trips in the U.S. and up to 480 million in 2012”2 1. U.S. Bureau of Labor Statistics
2. U.S. Travel Association
13 December 2010 11CS 410 Orange Team
Source: U.S. Travel Association
13 December 2010 12CS 410 Orange Team
13 December 2010 13CS 410 Orange Team
Auto-delivery SystemGeographical
13 December 2010 14CS 410 Orange Team
A system that automatically notifies users about relevant traffic and points of interest indicated in their profile while they are traveling.
13 December 2010 15CS 410 Orange Team
Increase visibility for businesses
Save time and money for travelers
13 December 2010 16CS 410 Orange Team
13 December 2010 17CS 410 Orange Team
Avoid Traffic
Cheap Gas
Favorite Restauran
t
13 December 2010 18CS 410 Orange Team
13 December 2010CS 410 Orange Team 19
13 December 2010CS 410 Orange Team 20
13 December 2010CS 410 Orange Team 21
Business◦ Account
Traveler◦ Phone Application◦ Account
13 December 2010 22CS 410 Orange Team
Increase in:◦ Visibility◦ Customer base◦ Cash flow
13 December 2010 23CS 410 Orange Team
Less money spent on travel overall
Explore and enjoy:◦ popular attractions◦ points of interest within an unknown area
Reduce:◦ Time wasted◦ Frustration
13 December 2010 24CS 410 Orange Team
Business◦ Computer System
Internet Traveler
◦ Computer System Internet
◦ Smart phone GPS Data Package/Wi-Fi
13 December 2010 25CS 410 Orange Team
13 December 2010CS 410 Orange Team 26
13 December 2010CS 410 Orange Team 27
Input Validation
Query Subsystem
Database
Point of Interest Notification Subsystem
13 December 2010 28CS 410 Orange Team
13 December 2010 29CS 410 Orange Team
13 December 2010 30CS 410 Orange Team
13 December 2010CS 410 Orange Team 31
13 December 2010 32CS 410 Orange Team
13 December 2010CS 410 Orange Team 33
13 December 2010CS 410 Orange Team 34
13 December 2010CS 410 Orange Team 35
13 December 2010CS 410 Orange Team 36
13 December 2010CS 410 Orange Team 37
13 December 2010CS 410 Orange Team 38
13 December 2010CS 410 Orange Team 39
13 December 2010CS 410 Orange Team 40
13 December 2010 41CS 410 Orange Team
UsersUserID
Password
Item
ItemID
Establishment (FK)
Name
Price
Establishments
EstablishmentID
Business (FK)
Address
Phone Number
Preferences
PrefID
User (FK)
Business (FK)
Rating
BusinessesBusinessID
Name
Type
Subtype
Login Name
Password
Trends
Graph
Type
Start
Stop
13 December 2010 42CS 410 Orange Team
Traffic_Data
LocationID
Latitude
Longitude
Time
Weather
AnonymousID
13 December 2010 43CS 410 Orange Team
13 December 2010 44CS 410 Orange Team
13 December 2010 45CS 410 Orange Team
13 December 2010 46CS 410 Orange Team
13 December 2010CS 410 Orange Team 47
60 million smartphones are in use at end of 20091
By 2011 total number of smartphone users surpass 142.8 million2
Global smartphone shipments are expected to increase 105% to 506 million units in 20143
Sources: 1. Mobile Health News
2. Nielson Company
3. Zach’s Investment Research
13 December 2010 48CS 410 Orange Team
13 December 2010 49CS 410 Orange Team
United States had a total of 6,045,655 business firms and 7,705,018 business establishments in 2007
In Virginia alone there are 157,501 firms and 200,503 locations
Bilal Syed, RaceCoast gas station owner, stated he is willing to pay $50/month for G.A.S.
Charge businesses $50/month per location More locations = more of a discount per
location
Source: gaebler.com: Resource for Entrepreneurs
13 December 2010 50CS 410 Orange Team
62.5% out of 71 people surveyed who have a smartphone said they would pay for G.A.S.
Dr. Olariu said he is willing to pay $15/month.
Popular services, which provide traffic updates, gas prices, weather reports, and news info◦ MSN Direct: $29.95/mo◦ XM Nav Traffic: $9.94 to 16.94/mo◦ FM Traffic: $49.99/mo
13 December 2010CS 410 Orange Team 51
Our charge to download the phone application:◦ $4.99 for 1st 3 months, then $1.99 per month
13 December 2010CS 410 Orange Team 52
Norfolk, VA
13 December 2010 53CS 410 Orange Team
13 December 2010CS 410 Orange Team 54
13 December 2010 55CS 410 Orange Team
13 December 2010 56CS 410 Orange Team
13 December 2010 57CS 410 Orange Team
AAA MapquestMSN
AutosGas
BuddyGoogle Maps
User Profile ✓
Autonomous ✓
Real-Time ✓ ✓
Phone Application
✓ ✓
Points of Interest
✓ ✓ ✓ ✓
Traffic ✓ ✓ ✓ ✓
Directions ✓ ✓ ✓ ✓ ✓
Gas Prices ✓ ✓ ✓ ✓ ✓ ✓
13 December 2010 58CS 410 Orange Team
AnDroid Apps Where TripIt WeatherBug
User Profile ✓
Autonomous ✓
Real-Time ✓ ✓
Gas Prices ✓ ✓
Restaurants ✓ ✓ ✓
Traffic ✓ ✓
Hotels ✓ ✓ ✓
Points of Interest
✓ ✓
Weather ✓ ✓ ✓ ✓
13 December 2010 59CS 410 Orange Team
iPhone Apps AroundMeCheap
GasYelp
UrbanSpoon
Google Maps
User Profile ✓
Autonomous ✓
Real-Time ✓
Gas Prices ✓ ✓ ✓
Restaurants ✓ ✓ ✓ ✓ ✓
Traffic ✓ ✓
Points of Interest
✓ ✓ ✓
Hotels ✓ ✓ ✓
13 December 2010 60CS 410 Orange Team
Risk Matrix LegendFinancial
F1 Business Participation
Schedule
S1 Business Participation
S2 Competition Completes First
Legal
L1 Distracted Driving
Technical
T1 Server Load
User
U1 Privacy/Security
U2 Business Fraud
RisksProbability
Very High
High LowVery Low
Impact
Very High
S2 F1, S1
High L1 T1 U1, U2
Low
Very Low
13 December 2010 61CS 410 Orange Team
Distracted Driving (L1): Voice Commands, Audible Alerts
Server Load (T1): Topology based design, Concurrent design
Business Participation (F1): Marketing Plan, Viral Marketing
Business Participation (S1): Marketing Plan Privacy/Security (U1): Encryption, Password,
Firewalls, etc. Business Fraud (U2): Business Agreement,
User Reports
13 December 2010 62CS 410 Orange Team
13 December 2010CS 410 Orange Team 63
Feasibility Presentation Work Breakdown Structure Milestone Presentation Business Plans Development Plan Project Website Final Presentation
13 December 2010CS 410 Orange Team 64
13 December 2010CS 410 Orange Team 65
DevelopmentPlan
ManagementPlan
StaffingPlan
ResourcePlan
FundingPlan
MarketingPlan
RiskManagement
Plan
EvaluationPlan
WorkBreakdownStructure
13 December 2010CS 410 Orange Team 66
13 December 2010CS 410 Orange Team 67
13 December 2010 68CS 410 Orange Team
Prototype Design and Requirement Lists Prototype Test Plan Product and Prototype User Manuals Set Up Database and Web Server Prototype Development and Demonstration Prototype Test and Acceptance
Demonstration Update Documentation
13 December 2010CS 410 Orange Team 69
13 December 2010 70CS 410 Orange Team
13 December 2010 71CS 410 Orange Team
PositionTotal Hours
Hourly RateOverall Total
Project Manager 600 $15.00/hr $9,000
Software Specialist 600 $15.00/hr $9,000
Financial Specialist 250 $15.00/hr $3,750
Marketing Specialist 250 $15.00/hr $3,750
Database Specialist 100 $15.00/hr $1,500Documentation
Specialist150 $15.00/hr $2,250
Webmaster 100 $15.00/hr $1,500
Total Cost $30,75030%
Overhead$9,225
TOTAL $39,975
13 December 2010 72CS 410 Orange Team
Resource Quantity Price Total Cost
ODU CS Server 2 $0 $0
ODU Workstations 7 $500 $3,500
Smartphone SDK 5 $0 $0
Microsoft Office 7 $10 $70
MySQL 1 $0 $0
PHP 1 $0 $0
Apache 1 $0 $0
Git 1 $0 $0
CodeBlocks 7 $0 $0
Inkscape 7 $0 $0
TOTAL $3,570
13 December 2010 73CS 410 Orange Team
Staffing $39,975
Resources $3,570
TOTAL $43,545
13 December 2010 74CS 410 Orange Team
13 December 2010CS 410 Orange Team 75
13 December 2010 76CS 410 Orange Team
Hardware Purchase necessary
severs for development
Install software◦ Operating system◦ Web hosting software◦ Database Sever◦ Smartphone SDK
Software
13 December 2010CS 410 Orange Team 77
GUI Notification System Database Testing Documentation
13 December 2010 78CS 410 Orange Team
13 December 2010 79CS 410 Orange Team
Position# of
Employees
Total Hours
Hourly Rate
Total Cost
Project Manager 1 2000 $50.00/hr $100,000Software Engineer
3 2000 $34.00/hr $204,000
Financial Analyst 1 750 $25.00/hr $18,750Marketing
Analyst1 700 $34.00/hr $23,800
Documentation Specialist
1 500 $25.00/hr $12,500
Web Developer 1 950 $25.00/hr $23,750Database
Administrator1 2000 $40.00/hr $80,000
Total Cost $462,80030%
Overhead$138,840
TOTAL $601,640
13 December 2010 80CS 410 Orange Team
ResourceQuantit
yPrice Total Cost
Server 4 $10,000 $40,000Uninterruptible Power
Supply1 $300 $300
A/C Unit 1 $2,000 $2,000Workstation 2 $500 $1,000
Microsoft Office Professional
9 $300 $2,700
Smartphone 10 $300 $3,000Router 1 $200 $200
SSL Certificate 1 $0 $0MySQL 4 $0 $0
PHP 4 $0 $0Apache 4 $0 $0
Git 4 $0 $0CodeBlocks 2 $0 $0
Inkscape 2 $0 $0TOTAL $49,200
13 December 2010 81CS 410 Orange Team
Staffing $601,640
Resources $49,200
TOTAL $650,840
13 December 2010 82CS 410 Orange Team
13 December 2010CS 410 Orange Team 83
13 December 2010CS 410 Orange Team 84
13 December 2010 85CS 410 Orange Team
Production Preparations Website Marketing Beta Testing Site Financial Tracking Technical Support Training Server Maintenance Schedule Continuing Development
◦ Version Upgrades◦ Features Release
13 December 2010CS 410 Orange Team 86
13 December 2010 87CS 410 Orange Team
13 December 2010 88CS 410 Orange Team
Position# of
Employees
Total Hour
s
Hourly Rate
Total Cost
Project Manager 1 2000 $50.00/hr $100,000Software Engineer 3 1500 $34.00/hr $153,000Network Specialist 1 2000 $37.00/hr $74,000
Webmaster 1 1000 $25.00/hr $25,000Marketing Analyst 1 550 $34.00/hr $18,700Financial Analyst 1 550 $25.00/hr $13,750
Database Administrator
1 2000 $40.00/hr $80,000
Documentation Manager
1 400 $25.00/hr $10,000
Customer Support 3 2000 $15.00/hr $90,000Total Cost $564,450
30% Overhead $169,335
TOTAL $733,785
13 December 2010 89CS 410 Orange Team
ResourceQuanti
tyPrice
Total Cost
Workstation 3 $500 $1,500VeriSign SSL Certificate 1 $995 $995
Microsoft Office Professional
3 $300 $900
MySQL 4 $0 $0PHP 4 $0 $0
Apache 4 $0 $0Git 4 $0 $0
CodeBlocks 8 $0 $0Inkscape 8 $0 $0
TOTAL $3,395
13 December 2010 90CS 410 Orange Team
Staffing $733,785
Resources $3,395
TOTAL $737,180
13 December 2010 91CS 410 Orange Team
13 December 2010CS 410 Orange Team 92
13 December 2010CS 410 Orange Team 93
13 December 2010CS 410 Orange Team 94
13 December 2010CS 410 Orange Team 95
Phase
Staffing Cost
Resource Cost
Total Cost
1 $39,975 $3,570 $43,545
2 $601,640 $49,200 $650,840
3 $733,785 $3,395 $737,180
TOTAL $1,431,565
13 December 2010CS 410 Orange Team 96
Month 1 60,000 new end-users x $4.99 per end-user $299,400 1000 chain locations x $20 per location $20,000 Total = $319,400Month 2 1000 new end-users x $4.99 per end-user $4,990 50 small businesses x $50 per business $2,500 1000 chain locations x $20 per location $20,000 Total = $346,890Month 3 1000 new end-users x $4.99 per end-user $4,990 100 small businesses x $50 per business $5,000 1000 chain locations x $20 per location $20,000 Total = $376,880Month 4 1000 new end-users x $4.99 per end-user $4,990 150 small businesses x $50 per business $7,500 1000 chain locations x $20 per location $20,000 50,000 returning end-users x $1.99 per end-user $99,500 Total = $508,790
13 December 2010CS 410 Orange Team 97
Month 5 1000 new end-users x $4.99 per end-user $4,990 200 small businesses x $50 per business $10,000 1000 chain locations x $20 per location $20,000 50,900 returning end-users x $1.99 per end-user $101,291 Total = $645,107Month 6 1000 new end-users x $4.99 per end-user $4,990 250 small businesses x $50 per business $12,500 1000 chain locations x $20 per location $20,000 51,800 returning end-users x $1.99 per end-user $103,082 Total = $785,679Month 7 1000 new end-users x $4.99 per end-user $4,990 300 small businesses x $50 per business $15,000 1000 chain locations x $20 per location $20,000 52,700 returning end-users x $1.99 per end-user $104,875 Total = $930,542Month 8 1000 new end-users x $4.99 per end-user $4,990 350 small businesses x $50 per business $17,500 1000 chain locations x $20 per location $20,000 53,600 returning end-users x $1.99 per end-user $106,664 Total = $1,079,696
13 December 2010 98CS 410 Orange Team
Month
Problem – Lack of knowledge while traveling
Solution –
Design◦ Topology◦ Concurrency
Business Plan◦ Beta test in Norfolk◦ Go national
13 December 2010 99CS 410 Orange Team
13 December 2010 100
CS 410 Orange Team
You can’t get anywhere without
13 December 2010 101
CS 410 Orange Team
Meetings◦ Full team once a week on Friday, 4:30 CPI Room◦ Individual member meetings◦ Other groups guidance (web site design)◦ Consultant Meetings and Boss Oversight
Tools Utilized◦ Team Wiki: cs.odu.edu/~410orang/wiki◦ Team Forum: cs.odu.edu/~410orang/forum◦ Communication via E-mail, Text Messaging, and
13 December 2010 102
CS 410 Orange Team
13 December 2010 103
CS 410 Orange Team
13 December 2010 104
CS 410 Orange Team
United States Department of Labor: Bureau of Labor Statistics http://www.bls.gov/spotlight/2010/travel/
U.S. Travel Association: U.S. Travel Forecast Charts http://www.ustravel.org/sites/default/files/page/2009/09/ForecastSummary.pdf
National Business Travel Association http://www2.nbta.org/Lists/Resource%
20Library/NBTA2009Forecast.pdf Edgar Snyder & Associates: Car Accident Cell Phone Statistics
http://www.edgarsnyder.com/car-accident/cell-phone/statistics.html Texas Transportation Institute: Economic Factors Tap the Brakes on
Traffic Congestion http://mobility.tamu.edu/ums/media_information/press_release.stm
Mobile Heath News◦ http://mobihealthnews.com/7052/ctia-50-million-smartphones-in-us/
Zach’s Investment Research http://www.zacks.com/stock/news/35221/Smartphone+Growth+to+Accelerate
Nielsen Wire http://blog.nielsen.com/nielsenwire/consumer/smartphones-to-overtake-feature-
phones-in-u-s-by-2011/ gaebler.com: Resource for Entrepreneurs
http://www.gaebler.com/Number-of-Small-Businesss-in-Virginia.htm
13 December 2010 105
CS 410 Orange Team
Family, Slide 5, 17 & 18◦ http://www.buzzle.com/img/articleImages/15911-43med.jpg
Business Man, Slide 5◦ http://www.gnurf.net/v3/wp-content/uploads/2008/04/031-busy-business-man.png
Restroom Sign, Slide 6◦ http://happyberfdaytome.files.wordpress.com/2010/07/restroom_sign.jpg
Fast Food Chains, Slide 6, 17 & 18◦ http://www.babble.com/CS/blogs/strollerderby/2008/11/16-22/fast-food-logos.gif
Dollar Sign, Slide 6, 17 & 18◦ http://pslawnet.files.wordpress.com/2010/05/dollar-sign.jpg
Clock, Slide 6 & 17◦ http://www.webeden.co.uk/blog/wp-content/uploads/2009/07/real-time-search.jpg
Traffic (HRBT), Slide 7, 17 & 18◦ http://i.ytimg.com/vi/S0-GSHdQxII/0.jpg
Vacation Family, Slide 88◦ http://www.toonpool.com/user/496/files/vacation_50845.jpg
Business Man, Slide 88◦ http://us.cdn4.123rf.com/168nwm/yayayoy/yayayoy1006/yayayoy100600039.jpg
13 December 2010 106
CS 410 Orange Team
Angry Driver, Slide 17◦ http://assets.nydailynews.com/img/2009/06/18/alg_road-rage.jpg
Confused Man, Slide 17 & 18◦ http://pstransitoperators.files.wordpress.com/2010/05/confused.jpg
Road Rage, Slide 17◦ http://4.bp.blogspot.com/_HANEd5oXlMk/SoBNCPmd10I/AAAAAAAAGIk/EEEtLZzWqbA/s400/
roadrage.jpg
Sad Family, Slide 17◦ http://www.ledaswann.com/images/family%20sad.jpg
13 December 2010 107
CS 410 Orange Team