Docstoc

Geographical Auto-delivery System

Document Sample
Geographical Auto-delivery System Powered By Docstoc
					CS 410 Orange Group
    Final Presentation




   CS 410 Orange Team   13 December 2010   1
   Personnel
   Problem
   Solution
   Design
   Business Plan
   Recap




                    CS 410 Orange Team   13 December 2010   2
CS 410 Orange Team   13 December 2010   3
Janet Brunelle          Chair
G. Hill Price           Vice Chair

Consultants
Irwin Levinstein        DB Expert
Stephan Olariu          Network Expert

Potential Consultants
Shuiwang Ji             AI Expert
Larry Lee               Probability & Statistics Expert
Jay Morris              Parallel Computing Expert
Steven Zeil             OOD Expert



                                 CS 410 Orange Team   13 December 2010   4
CS 410 Orange Team   13 December 2010   5
CS 410 Orange Team   13 December 2010   6
CS 410 Orange Team   13 December 2010   7
Lack of knowledge increases
 frustration and inefficiency
       while traveling.



                CS 410 Orange Team   13 December 2010   8
   Amount of money spent traveling

   Time wasted due to traffic

   No idea where anything is




                                 CS 410 Orange Team   13 December 2010   9
          10 %
     Points of 
      Interest


                  44%
  23%             Transportation
Lodging



          23%
 Food & Drinks




                  Source:  U.S Bureau of Labor Statistics

                         CS 410 Orange Team   13 December 2010   10
   “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


                                     CS 410 Orange Team   13 December 2010   11
Source: U.S. Travel Association
                CS 410 Orange Team   13 December 2010   12
CS 410 Orange Team   13 December 2010   13
Geographical Auto-delivery System



                   CS 410 Orange Team   13 December 2010   14
A system that automatically notifies users
about relevant traffic and points of interest
indicated in their profile while they are
traveling.




                           CS 410 Orange Team   13 December 2010   15
   Increase visibility for businesses

   Save time and money for travelers




                               CS 410 Orange Team   13 December 2010   16
CS 410 Orange Team   13 December 2010   17
                                          Avoid
                                          Traffic




Cheap
 Gas




                                        Favorite
                                       Restaurant

        CS 410 Orange Team   13 December 2010       18
CS 410 Orange Team   13 December 2010   19
CS 410 Orange Team   13 December 2010   20
CS 410 Orange Team   13 December 2010   21
   Business
    ◦ Account

   Traveler
    ◦ Phone Application
    ◦ Account




                          CS 410 Orange Team   13 December 2010   22
   Increase in:
    ◦ Visibility
    ◦ Customer base
    ◦ Cash flow




                      CS 410 Orange Team   13 December 2010   23
   Less money spent on travel overall

   Explore and enjoy:
    ◦ popular attractions
    ◦ points of interest within an unknown area

   Reduce:
    ◦ Time wasted
    ◦ Frustration



                                 CS 410 Orange Team   13 December 2010   24
   Business
    ◦ Computer System
      Internet
   Traveler
    ◦ Computer System
      Internet
    ◦ Smart phone
      GPS
      Data Package/Wi-Fi




                            CS 410 Orange Team   13 December 2010   25
CS 410 Orange Team   13 December 2010   26
CS 410 Orange Team   13 December 2010   27
   Input Validation

   Query Subsystem

   Database

   Point of Interest Notification Subsystem




                              CS 410 Orange Team   13 December 2010   28
CS 410 Orange Team   13 December 2010   29
CS 410 Orange Team   13 December 2010   30
CS 410 Orange Team   13 December 2010   31
CS 410 Orange Team   13 December 2010   32
CS 410 Orange Team   13 December 2010   33
CS 410 Orange Team   13 December 2010   34
CS 410 Orange Team   13 December 2010   35
CS 410 Orange Team   13 December 2010   36
CS 410 Orange Team   13 December 2010   37
CS 410 Orange Team   13 December 2010   38
CS 410 Orange Team   13 December 2010   39
CS 410 Orange Team   13 December 2010   40
CS 410 Orange Team   13 December 2010   41
                                                                              Traffic_Data
                Users                       Preferences
                                                                          LocationID
       UserID                            PrefID
                                                                          Latitude
       Email                             User (FK)
                                                                          Longitude
       Password                          Business (FK)
                                                                          Time
                                         Rating                           Weather

  Establishments                                                          AnonymousID

EstablishmentID
                                           Businesses
Business (FK)                           BusinessID
                                                                                     Trends
Address                                 Name
                                                                          Graph
Phone Number                            Type
                                        Subtype                           Type

                            Item        Login Name                        Start
                                        Password                          Stop
                   ItemID

                   Establishment (FK)

                   Name

                   Price


                                                  CS 410 Orange Team   13 December 2010       42
CS 410 Orange Team   13 December 2010   43
CS 410 Orange Team   13 December 2010   44
CS 410 Orange Team   13 December 2010   45
CS 410 Orange Team   13 December 2010   46
CS 410 Orange Team   13 December 2010   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




                                           CS 410 Orange Team   13 December 2010   48
CS 410 Orange Team   13 December 2010   49
   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


                                                  CS 410 Orange Team   13 December 2010   50
   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


                                CS 410 Orange Team   13 December 2010   51
   Our charge to download the phone
    application:
    ◦ $4.99 for 1st 3 months, then $1.99 per month




                                CS 410 Orange Team   13 December 2010   52
                            Norfolk, VA




CS 410 Orange Team   13 December 2010     53
CS 410 Orange Team   13 December 2010   54
CS 410 Orange Team   13 December 2010   55
CS 410 Orange Team   13 December 2010   56
CS 410 Orange Team   13 December 2010   57
                                                                          Google
                    AAA   Mapquest   MSN Autos        Gas Buddy
                                                                           Maps
 User Profile   ✓

Autonomous      ✓                                                              

Real-Time       ✓                                                             ✓ 
   Phone
                ✓                                                             ✓ 
Application
 Points of
                ✓   ✓        ✓                                                ✓
  Interest
  Traffic       ✓   ✓        ✓                                                 ✓

 Directions     ✓   ✓        ✓           ✓                                    ✓

 Gas Prices     ✓   ✓        ✓           ✓                  ✓                 ✓ 




                                      CS 410 Orange Team   13 December 2010        58
 AnDroid Apps             Where        TripIt            WeatherBug

   User Profile      ✓
  Autonomous         ✓ 
   Real-Time         ✓     ✓                                     
   Gas Prices        ✓     ✓                                     
  Restaurants        ✓     ✓             ✓                       
     Traffic         ✓     ✓                                     
     Hotels          ✓     ✓             ✓                       
Points of Interest   ✓     ✓                                     
    Weather          ✓     ✓             ✓                     ✓ 




                                  CS 410 Orange Team   13 December 2010   59
  iPhone Apps            AroundMe   Cheap Gas      Yelp      UrbanSpoon          Google Maps

   User Profile      ✓
  Autonomous         ✓                                                                   
   Real-Time         ✓
   Gas Prices        ✓      ✓          ✓                                                 
  Restaurants        ✓      ✓                       ✓                ✓                  ✓
     Traffic         ✓                                                                   ✓
Points of Interest   ✓      ✓                                                           ✓
     Hotels          ✓      ✓                                                           ✓ 




                                                CS 410 Orange Team   13 December 2010        60
                                                    Risk Matrix Legend
                  Probability              Financial
Risks      Very
                  High   Low
                                  Very     F1           Business Participation

           High                   Low      Schedule
                                           S1           Business Participation
    Very
                   S2    F1, S1            S2           Competition Completes First
I   High
                                           Legal 
m                                          L1           Distracted Driving 
    High    L1     T1    U1, U2     
p                                          Technical
a                                          T1           Server Load
    Low                             
c                                          User 
t   Very                                   U1           Privacy/Security
                                    
    Low                                    U2           Business Fraud




                                         CS 410 Orange Team   13 December 2010        61
   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

                              CS 410 Orange Team   13 December 2010   62
CS 410 Orange Team   13 December 2010   63
   Feasibility Presentation
   Work Breakdown Structure
   Milestone Presentation
   Business Plans
   Development Plan
   Project Website
   Final Presentation




                               CS 410 Orange Team   13 December 2010   64
                      Development
                          Plan




Management      Resource     Marketing          Evaluation
   Plan           Plan         Plan                Plan

         Staffing      Funding         Risk                    Work
           Plan          Plan       Management              Breakdown
                                       Plan                  Structure




                                    CS 410 Orange Team   13 December 2010   65
CS 410 Orange Team   13 December 2010   66
CS 410 Orange Team   13 December 2010   67
CS 410 Orange Team   13 December 2010   68
   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



                           CS 410 Orange Team   13 December 2010   69
CS 410 Orange Team   13 December 2010   70
                                                                 Overall
      Position         Total Hours   Hourly Rate
                                                                  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,500
 Documentation
                          150         $15.00/hr                  $2,250
    Specialist
    Webmaster             100         $15.00/hr                  $1,500
                                         Total Cost             $30,750
                                                30%
                                                                 $9,225
                                          Overhead
                                            TOTAL               $39,975
                                     CS 410 Orange Team   13 December 2010   71
    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


                               CS 410 Orange Team   13 December 2010   72
Staffing       $39,975

Resources         $3,570

TOTAL          $43,545




            CS 410 Orange Team   13 December 2010   73
CS 410 Orange Team   13 December 2010   74
CS 410 Orange Team   13 December 2010   75
CS 410 Orange Team   13 December 2010   76
   Hardware                      GUI
   Purchase necessary            Notification System
    severs for                    Database
    development
                                  Testing
   Install software
                                  Documentation
    ◦   Operating system
    ◦   Web hosting software
    ◦   Database Sever
    ◦   Smartphone SDK
   Software


                                   CS 410 Orange Team   13 December 2010   77
CS 410 Orange Team   13 December 2010   78
                      # of
                               Total        Hourly           Total
    Position        Employee
                               Hours         Rate            Cost
                       s
Project Manager        1       2000       $50.00/hr       $100,000
Software Engineer      3       2000       $34.00/hr       $204,000
Financial Analyst      1       750        $25.00/hr        $18,750
Marketing Analyst      1       700        $34.00/hr        $23,800
 Documentation
                       1       500        $25.00/hr        $12,500
   Specialist
 Web Developer         1       950        $25.00/hr        $23,750
    Database
                       1       2000       $40.00/hr        $80,000
 Administrator
                                            Total Cost $462,800
                                                       30%
                                                               $138,840
                                              Overhead
                                                   TOTAL $601,640
                                     CS 410 Orange Team 13 December 2010   79
         Resource             Quantity          Price   Total Cost
            Server               4            $10,000    $40,000
Uninterruptible Power Supply     1              $300       $300
          A/C Unit               1             $2,000     $2,000
        Workstation              2              $500      $1,000
Microsoft Office Professional    9              $300      $2,700
        Smartphone              10              $300      $3,000
           Router                1              $200       $200
       SSL Certificate           1               $0         $0
           MySQL                 4               $0         $0
             PHP                 4               $0         $0
           Apache                4               $0         $0
             Git                 4               $0         $0
        CodeBlocks               2               $0         $0
          Inkscape               2               $0         $0
                                                  TOTAL  $49,200

                                         CS 410 Orange Team   13 December 2010   80
Staffing     $601,640

Resources      $49,200

TOTAL        $650,840




            CS 410 Orange Team   13 December 2010   81
CS 410 Orange Team   13 December 2010   82
CS 410 Orange Team   13 December 2010   83
CS 410 Orange Team   13 December 2010   84
CS 410 Orange Team   13 December 2010   85
   Production Preparations
   Website
   Marketing
   Beta Testing Site
   Financial Tracking
   Technical Support Training
   Server Maintenance Schedule
   Continuing Development
    ◦ Version Upgrades
    ◦ Features Release

                            CS 410 Orange Team   13 December 2010   86
CS 410 Orange Team   13 December 2010   87
                       # of
                              Total
    Position         Employee       Hourly Rate        Total Cost
                              Hours
                        s
 Project Manager        1     2000 $50.00/hr            $100,000
Software Engineer       3     1500 $34.00/hr            $153,000
Network Specialist      1     2000 $37.00/hr             $74,000
    Webmaster           1     1000 $25.00/hr             $25,000
Marketing Analyst       1      550   $34.00/hr           $18,700
 Financial Analyst      1      550   $25.00/hr           $13,750
     Database
                        1      2000   $40.00/hr         $80,000
   Administrator
  Documentation
                        1      400    $25.00/hr         $10,000
     Manager
Customer Support        3      2000   $15.00/hr               $90,000
                                       Total Cost            $564,450
                                      30% Overhead $169,335
                                                TOTAL $733,785
                                  CS 410 Orange Team 13 December 2010   88
                           Quantit
       Resource                         Price             Total Cost
                             y
      Workstation            3          $500               $1,500
VeriSign SSL Certificate     1          $995                $995
   Microsoft Office
                              3         $300                 $900
      Professional
         MySQL                4          $0                  $0
           PHP                4          $0                  $0
         Apache               4          $0                  $0
           Git                4          $0                  $0
      CodeBlocks              8          $0                  $0
        Inkscape              8          $0                  $0
                                        TOTAL              $3,395


                                     CS 410 Orange Team    13 December 2010   89
Staffing     $733,785

Resources         $3,395

TOTAL        $737,180




            CS 410 Orange Team   13 December 2010   90
CS 410 Orange Team   13 December 2010   91
CS 410 Orange Team   13 December 2010   92
CS 410 Orange Team   13 December 2010   93
CS 410 Orange Team   13 December 2010   94
        Staffing   Resource
Phase                              Total Cost
          Cost       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




                         CS 410 Orange Team   13 December 2010   95
Month 1                                           
                        x  $4.99  per  end-
60,000 new end-users    user                                $299,400 
1000 chain locations    x $20 per location                   $20,000 
                                                    Total = $319,400
Month 2                                           
                        x  $4.99  per  end-
1000 new end-users      user                                  $4,990 
50 small businesses     x $50 per business                    $2,500 
1000 chain locations    x $20 per location                   $20,000 
                                                    Total = $346,890
Month 3                                           
                        x  $4.99  per  end-
1000 new end-users      user                                  $4,990 
100 small businesses    x $50 per business                    $5,000 
1000 chain locations    x $20 per location                   $20,000 
                                                    Total = $376,880
Month 4                                           
                        x  $4.99  per  end-
1000 new end-users      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- x  $1.99  per CS end- Team 13 December 2010
                                         410 Orange                     96
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,107
Month 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,679
Month 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,542
Month 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


                                           CS 410 Orange Team   13 December 2010       97
                                        Month




CS 410 Orange Team   13 December 2010       98
   Problem – Lack of knowledge while traveling

   Solution –

   Design
    ◦ Topology
    ◦ Concurrency


   Business Plan
    ◦ Beta test in Norfolk
    ◦ Go national


                                CS 410 Orange Team   13 December 2010   99
                                        10
CS 410 Orange Team   13 December 2010    0
  You can’t get
anywhere without


                                                 10
         CS 410 Orange Team   13 December 2010    1
   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 Facebook




                                                                             10
                                     CS 410 Orange Team   13 December 2010    2
                                        10
CS 410 Orange Team   13 December 2010    3
                                        10
CS 410 Orange Team   13 December 2010    4
       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




                                                                                              10
                                                      CS 410 Orange Team   13 December 2010    5
   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




                                                                                                     10
                                                             CS 410 Orange Team   13 December 2010    6
   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/roadr
        age.jpg
   Sad Family, Slide 17
    ◦   http://www.ledaswann.com/images/family%20sad.jpg




                                                                                                     10
                                                             CS 410 Orange Team   13 December 2010    7

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:7/23/2013
language:Latin
pages:107